Module:Sandbox/Sebotic/query test

local p = {}
	
function p.hello(frame)
	entity = mw.wikibase.getEntityObject(frame.args[1])
	
	infobox_string = 
		[[
{| class="wikitable"
|-
! Column 1 !! Column 2 !! Column 3
|-
| rowspan="2" | A
| colspan="2" style="text-align: center;" | B
|-
| C <!-- column 1 occupied by cell A -->
| D
|-
| E
| rowspan="2" colspan="2" style="text-align: center;" |F
|-
| G <!-- column 2+3 occupied by cell F -->
|-
| colspan="3" style="text-align: center;" | H
|}
]]
	
	
	infobox_string2 = [[
{{infobox3cols
| headerstyle = background-color: #ddd
| labelstyle  = background-color: #c3fdb8
| datastyle   = background-color: #eee
| name        = {{{path|}}}

| above       = {{{Name|{{PAGENAME}} }}}
| subheader   = {{{caption|}}}
| image       = {{#invoke:InfoboxImage|InfoboxImage|image={{{image|}}}|size=250px|sizedefault=frameless|upright=1.14|alt={{{alt|}}}}}
| caption     = {{{image_source|}}}

|data1={{#if:{{{PDB|}}}
| <table style="border: none; padding: 0; margin: 0; width: 100%; text-align: left">
<tr style="background-color: #ddd; text-align: center">
<th colspan=2>Available structures</th>
</tr>
<tr>
<th rowspan = "2" style="background-color: #c3fdb8; width:43px">]] .. "[[Protein Data Bank|PDB]]" .. [[</th>
<td colspan = "2" style="background-color: #eee"> {{#if:{{{Homologene|}}}|
Ortholog search: [http://www.ebi.ac.uk/pdbe/searchResults.html?display=both&term={{Homologene2PDBe|{{{Homologene}}}}} PDBe], [http://www.rcsb.org/pdb/search/smartSubquery.do?smartSearchSubtype=UpAccessionIdQuery&accessionIdList={{Homologene2uniprot|{{{Homologene}}}}} RCSB]|
{{#if:{{{Hs_Uniprot|}}}|
Human UniProt search: [http://www.ebi.ac.uk/pdbe/searchResults.html?display=both&term={{{Hs_Uniprot}}} PDBe], [http://www.rcsb.org/pdb/search/smartSubquery.do?smartSearchSubtype=UpAccessionIdQuery&accessionIdList=::{{{Hs_Uniprot}}} RCSB]
</td>
}}
}}
</tr>
<tr>
<td>
<table class="collapsible collapsed" style="border: none; padding: 0; margin: 0; width: 100%; text-align: left">
<tr style="background-color: #ddd; text-align: center">
<th colspan=2>List of PDB id codes</th>
</tr>
<tr>
<td colspan = "2" style="background-color: #eee">
{{{PDB}}}
</td>
</tr>
</table>
</td></tr>
</table>
}}

| header3     = Identifiers

| label4      = ]] .. "[[Human Genome Organisation|Symbol{{#if:{{#invoke:Sandbox/Sebotic/query_test|get_aliases}}|s}}]]" .. [[
| data4       = <span class="plainlinks">[http://www.genenames.org/cgi-bin/gene_symbol_report?hgnc_id={{#invoke:Wikidata|getValue|P354|{{{entrez|FETCH_WIKIDATA}}} }} {{#invoke:Wikidata|getValue|P353|{{{entrez|FETCH_WIKIDATA}}} }}]</span>{{#if: {{#invoke:Sandbox/Sebotic/query_test|get_aliases}} |&nbsp;{{#invoke:Sandbox/Sebotic/query_test|get_aliases}}  }}
| label5      = External IDs
| data5       = {{#if:{{{OMIM|}}}|{{OMIM5|{{{OMIM}}} }} }} {{#if:{{{MGIid|}}}|{{MGI|{{{MGIid}}} }} }} {{#if:{{#invoke:Wikidata|getValue|P593|{{{entrez|FETCH_WIKIDATA}}} }}|{{Homologene|{{#invoke:Wikidata|getValue|P593|{{{entrez|FETCH_WIKIDATA}}} }} }} }} {{#if:{{{IUPHAR|}}}|]] .. "[[International Union of Basic and Clinical Pharmacology|IUPHAR]]" .. [[: {{IUPHAR|{{{Symbol}}} }} }} {{#if:{{{ChEMBL|}}}|]] .. "[[ChEMBL]]" .. [[: <span class="plainlinks">[https://www.ebi.ac.uk/chembldb/index.php/target/inspect/CHEMBL{{{ChEMBL}}} {{{ChEMBL}}}]</span> }} {{#if:{{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }}|]] .. "[[GeneCards]]" .. [[: <span class="plainlinks">[http://www.genecards.org/cgi-bin/carddisp.pl?id_type=entrezgene&id={{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }} {{#invoke:Wikidata|getValue|P353|{{{entrez|FETCH_WIKIDATA}}} }} Gene]</span> }} 

| label6      = ]] .. "[[Enzyme Commission number|EC number]]" .. [[
| data6       = {{#if:{{{ECnumber|}}}|<span class="plainlinks" style="white-space: nowrap">[http://www.genome.jp/dbget-bin/www_bget?enzyme+{{#invoke:String|replace|{{{ECnumber}}}|,%s*|+|plain=false}} {{{ECnumber}}}]</span>}}

| data7       = <table class="collapsible collapsed" style="border: none; padding: 0; margin: 0; width: 100%; text-align: left">
<tr style="background-color: #ddd;">
<th colspan=2 style="text-align: center">]] .. "[[Gene ontology]]" .. [[</th><!-- name of the project Gene Ontology -->
</tr>
{{#if:{{{Function|}}}|
<tr>
<th style="background-color: #c3fdb8">Molecular function</th>
<td style="background-color: #eee">{{{Function}}}</td>
</tr>
}}
{{#if:{{{Component|}}}|
<tr>
<th style="background-color: #c3fdb8">Cellular component</th>
<td style="background-color: #eee">{{{Component}}}</td>
</tr>
}}
{{#if:{{{Process|}}}|
<tr>
<th style="background-color: #c3fdb8">Biological process</th>
<td style="background-color: #eee">{{{Process}}}</td>
</tr>
}}
{{#if:{{{Hs_Uniprot|}}}|
<tr>
<td style="background-color: #eee;text-align:center;" colspan="2" >Sources: [http://amigo.geneontology.org/cgi-bin/amigo/gp-assoc.cgi?gp=UniProtKB:{{{Hs_Uniprot}}} Amigo] / [http://www.ebi.ac.uk/QuickGO/GProtein?ac={{{Hs_Uniprot}}} QuickGO]</td></tr>
}}
</table>

| header8     = {{#if:{{#invoke:Wikidata|getValue|P692|{{{entrez|FETCH_WIKIDATA}}} }}|RNA expression pattern }}

| data9       = {{#invoke:InfoboxImage|InfoboxImage|image={{#invoke:Wikidata|getValue|P692|{{{entrez|FETCH_WIKIDATA}}}
 }}|sizedefault=frameless|upright=1.14}}

| data10      = {{#invoke:InfoboxImage|InfoboxImage|image={{{GeneAtlas_image2|}}}|sizedefault=frameless|upright=1.14}}

| data11      = {{#invoke:InfoboxImage|InfoboxImage|image={{{GeneAtlas_image3|}}}|sizedefault=frameless|upright=1.14}}

| data12      = {{#if:{{#invoke:Wikidata|getValue|P692|{{{entrez|FETCH_WIKIDATA}}} }}|<span class="plainlinks">[http://biogps.org/gene/{{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }}/ More reference expression data]</span>}}

| header13    = {{#if:{{{Protein_domain_image|}}}|Protein domains}}

| data14      = {{#invoke:InfoboxImage|InfoboxImage|image={{{Protein_domain_image|}}}|sizedefault=frameless|upright=1.14}}

| header15    = Orthologs

| data16      = {{{Orthologs|}}}

| label17     = Species
| data17a     = '''Human'''
| data17b     = '''Mouse'''

| label18     = ]] .. "[[Entrez]]" .. [[
| data18a     = {{#if:{{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }}|<span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=gene&cmd=retrieve&dopt=default&list_uids={{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }}&rn=1 {{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }}]</span>|n/a }}
| data18b     = {{#if:{{#invoke:Wikidata|getValue|P684|from={{#invoke:Wikidata|getValue|P351}} }}
|<span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?db=gene&cmd=retrieve&dopt=default&list_uids={{{Mm_EntrezGene}}}&rn=1 {{#invoke:Wikidata|getValue|P684|from={{#invoke:Wikidata|getValue|P351}} }}
]</span>|n/a }}

| label19     = ]] .. "[[Ensembl]]" .. [[
| data19a     = {{#if:{{#invoke:Wikidata|getValue|P594|{{{entrez|FETCH_WIKIDATA}}} }}|<span class="plainlinks" style="white-space: nowrap">[http://www.ensembl.org/Homo_sapiens/geneview?gene={{#invoke:Wikidata|getValue|P594|{{{entrez|FETCH_WIKIDATA}}} }};db=core {{#invoke:Wikidata|getValue|P594|{{{entrez|FETCH_WIKIDATA}}} }}]</span>|n/a}}
| data19b     = {{#if:{{{Mm_Ensembl|}}}|<span class="plainlinks" style="white-space: nowrap">[http://www.ensembl.org/Mus_musculus/geneview?gene={{{Mm_Ensembl}}};db=core {{{Mm_Ensembl}}}]</span>|n/a}}

| label20     = ]] .. "[[UniProt]]" .. [[
| data20a     = {{#if:{{{Hs_Uniprot|}}}|{{Uniprot|{{{Hs_Uniprot}}}}}|n/a}}
| data20b     = {{#if:{{{Mm_Uniprot|}}}|{{Uniprot|{{{Mm_Uniprot}}}}}|n/a}}

| label21     = RefSeq (mRNA)
| data21a     = {{#if:{{#invoke:Wikidata|getValue|P639|{{{entrez|FETCH_WIKIDATA}}} }} span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/entrez/viewer.fcgi?val{{#invoke:Wikidata|getTAValue|P639|{{{entrez|FETCH_WIKIDATA}}} }} {{#invoke:Wikidata|getTAValue|P639|1|{{{entrez|FETCH_WIKIDATA}}} }}]</span>|n/a}}
| data21b     = {{#if:{{{Mm_RefseqmRNA|}}}|<span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/entrez/viewer.fcgi?val={{{Mm_RefseqmRNA}}} {{{Mm_RefseqmRNA}}}]</span>|n/a}}

| label22     = RefSeq (protein)
| data22a     = {{#if:{{{Hs_RefseqProtein|}}}|<span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/entrez/viewer.fcgi?val={{{Hs_RefseqProtein}}} {{{Hs_RefseqProtein}}}]</span>|n/a}}
| data22b     = {{#if:{{{Mm_RefseqProtein|}}}|<span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/entrez/viewer.fcgi?val={{{Mm_RefseqProtein}}} {{{Mm_RefseqProtein}}}]</span>|n/a}}

| label23     = Location (UCSC)
| data23a     = {{#ifexpr:{{#if:{{{Hs_GenLoc_chr|}}}|1|0}}*{{#if:{{{Hs_GenLoc_start|}}}|1|0}}*{{#if:{{{Hs_GenLoc_end|}}}|1|0}}|<span class="plainlinks" style="white-space: nowrap">[http://genome.ucsc.edu/cgi-bin/hgTracks?org=Human{{#if:{{{Hs_GenLoc_db|}}}|&db={{{Hs_GenLoc_db}}}|}}&position=chr{{{Hs_GenLoc_chr}}}:{{{Hs_GenLoc_start}}}-{{{Hs_GenLoc_end}}} Chr {{{Hs_GenLoc_chr}}}:<br />{{#expr:{{{Hs_GenLoc_start}}} / 1000000 round 2}} – {{#expr:{{{Hs_GenLoc_end}}} / 1000000 round 2}} Mb]</span>|n/a }}
| data23b     = {{#ifexpr:{{#if:{{{Mm_GenLoc_chr|}}}|1|0}}*{{#if:{{{Mm_GenLoc_start|}}}|1|0}}*{{#if:{{{Mm_GenLoc_end|}}}|1|0}}|<span class="plainlinks" style="white-space: nowrap">[http://genome.ucsc.edu/cgi-bin/hgTracks?org=Mouse{{#if:{{{Mm_GenLoc_db|}}}|&db={{{Mm_GenLoc_db}}}|}}&position=chr{{{Mm_GenLoc_chr}}}:{{{Mm_GenLoc_start}}}-{{{Mm_GenLoc_end}}} Chr {{{Mm_GenLoc_chr}}}:<br />{{#expr:{{{Mm_GenLoc_start}}} / 1000000 round 2}} – {{#expr:{{{Mm_GenLoc_end}}} / 1000000 round 2}} Mb]</span>|n/a }}

| label24     = ]] .. "[[PubMed]]" .. [[ search
| data24a     = {{#if:{{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }}|<span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/sites/entrez?db=gene&cmd=Link&LinkName=gene_pubmed&from_uid={{#invoke:Wikidata|getValue|P351|{{{entrez|FETCH_WIKIDATA}}} }}]</span>|n/a }}
| data24b     = {{#if:{{{Mm_EntrezGene|}}}|<span class="plainlinks" style="white-space: nowrap">[http://www.ncbi.nlm.nih.gov/sites/entrez?db=gene&cmd=Link&LinkName=gene_pubmed&from_uid={{{Mm_EntrezGene}}}]</span>|n/a }}

}}]]

infobox_string3 = 
"<nowiki>" ..
"|header1 = dds" ..
"|label1 = label1" ..
"|data1 = " ..
"|data1a = data1a" ..
"|data1b = data1" ..
"|data1c = data1c" ..
"<nowiki/>"
	
	--return entity['aliases']['en'][1]['value']
	return infobox_string
	
	
end

function p.get_aliases(frame)
	entity = mw.wikibase.getEntityObject(frame.args['from'])
		
	a = ''
	if entity['aliases'] ~= nil then
        test = entity['aliases']['en']
		for key, value in ipairs(test) do
			a = a .. ', ' ..  value['value']
		end
			
		return a
	end
	
end
 
return p