Difference between revisions of "CompanyHistory"

From Sega Retro
 
(26 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<includeonly><span style="display:none;">{{#if:{{{1|}}}|{{#vardefine:companyname|{{{1}}}}}{{#vardefine:command|companies.company="{{{1}}}"}}{{#fornumargs: n
+
<includeonly>{{#vardefine:results|}}<span style="display:none;">{{#if:{{{1|}}}|{{#vardefine:companyname|{{{1}}}}}{{#vardefine:command|companies.company="{{{1}}}"}}{{#fornumargs: n
 
| value
 
| value
 
| {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR companies.company="{{#var:value}}"}}|}}
 
| {{#vardefine:nameList|{{#var:nameList}},{{#var:value}}}}{{#ifexpr:{{#var:n}} > 1|{{#vardefine:command|{{#var:command}} OR companies.company="{{#var:value}}"}}|}}
−
}}</span>{{#cargo_query:
+
}}</span>{{#vardefine:results|{{#var:results}}{{#cargo_query:
−
table=companies,releases
+
table=companies,releases,codeformat
−
|fields=companies.name=companiesname,releases.name=releasesname,releases.date,companies.company,companies.format,companies.role,companies.credited
+
|fields=companies.name=companiesname,releases.name=releasesname,MIN(releases.date),companies.company,companies.format,companies.role,companies.credited,codeformat.code=test,codeformat.format=test2,companies.specificrole
−
|join on=companies.name=releases.name
+
|join on=companies.name=releases.name,releases.console=codeformat.code
−
|where=({{#var:command}}) {{#if:{{{role|}}}|and companies.role="{{{role|}}}"}} {{#if:{{{format|}}}|and companies.format="{{{format|}}}"}}
+
|group by=releases.name
−
|order by=releases.date
+
|order by=MIN(releases.date),releases.name
 +
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#ifeq:{{{type|}}}|hardware||{{#if:{{{format|}}}|and (companies.format="{{{format|}}}") and (codeformat.format="{{{format|}}}")}}}} {{#switch:{{{type|}}}
 +
|accessories=and releases.type="1"{{#vardefine:italics|}}
 +
|hardware=and (releases.type="2" or releases.type="-1"){{#vardefine:italics|}}
 +
|#default=and not releases.type="1" and not releases.type="2" and not releases.type="-1"{{#vardefine:italics|yes}}
 +
}}
 
|format=template
 
|format=template
 +
|limit=1000
 
|template=CompanyHistory/Cargo
 
|template=CompanyHistory/Cargo
−
}}}}</includeonly><noinclude>
+
|default=
 +
}}{{#ifeq:{{{type|}}}|accessories||{{#cargo_query:
 +
table=unreleased,companies
 +
|fields=companies.name=companiesname,unreleased.name=releasesname,unreleased.date,companies.company,companies.format,companies.role,companies.credited
 +
|join on=unreleased.name=companies.name
 +
|group by=unreleased.name
 +
|order by=unreleased.date,unreleased.name
 +
|where=({{#var:command}}) {{#if:{{{role|}}}|and (companies.role LIKE "{{{role|}}}%")}} {{#if:{{{format|}}}|and (companies.format="{{{format|}}}")}}
 +
|format=template
 +
|limit=1000
 +
|template=CompanyHistory/Cargo/Unreleased
 +
|default=
 +
}}}}}}}}{{#var:results}}</includeonly><noinclude>
 +
Template to list a company's softography. It's a bit crude.
 +
 
 +
e.g. Sega, 32X:
 +
 
 +
===Publisher===
 +
<pre>{{CompanyHistory|Sega|format=32X|role=Publisher}}</pre>
 +
{{CompanyHistory|Sega|format=32X|role=Publisher}}
 +
 
 +
===Developer===
 +
<pre>{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}</pre>
 +
{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}
 +
 
 +
===Licensor===
 +
<pre>{{CompanyHistory|Sega|format=32X|role=Licensor}}</pre>
 +
{{CompanyHistory|Sega|format=32X|role=Licensor}}
  
−
{{CompanyHistory|Sega|format=DC}}
+
===Books===
 +
<pre>{{CompanyHistory|IDW Publishing|format=book|role=Publisher}}</pre>
 +
{{CompanyHistory|IDW Publishing|format=book|role=Publisher}}
  
−
[[Category:Sega Retro templates]]
+
[[Category:Templates]]
 
</noinclude>
 
</noinclude>

Latest revision as of 11:37, 30 October 2022

Template to list a company's softography. It's a bit crude.

e.g. Sega, 32X:

Publisher

{{CompanyHistory|Sega|format=32X|role=Publisher}}

Developer

{{CompanyHistory|Sega|Sega CS|format=32X|role=Developer}}

Licensor

{{CompanyHistory|Sega|format=32X|role=Licensor}}

Books

{{CompanyHistory|IDW Publishing|format=book|role=Publisher}}

Retrieved from "https://segaretro.org/index.php?title=Template:CompanyHistory&oldid=823049"