Персональные инструменты

Шаблон:ВыпускникиБД — различия между версиями

Материал из Кафедра Автоматики и телемеханики

Перейти к: навигация, поиск
 
(не показана одна промежуточная версия этого же участника)
Строка 6: Строка 6:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where=year=2013 AND groups="{{#var:groups}}" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND grouptype="{{#var:grouptype}}"
 
|data=dbcount=sum(quantity)
 
|data=dbcount=sum(quantity)
 
}}{{#vardefine:at_total|{{#external_value:dbcount}}}}{{#clear_external_data:}}{{#get_db_data:
 
}}{{#vardefine:at_total|{{#external_value:dbcount}}}}{{#clear_external_data:}}{{#get_db_data:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="государственное" AND grouptype="{{#var:grouptype}}"
 
|data=dbcount1=sum(quantity)
 
|data=dbcount1=sum(quantity)
 
}}{{#vardefine:at_gp|{{#external_value:dbcount1}}}}{{#clear_external_data:}}{{#get_db_data:
 
}}{{#vardefine:at_gp|{{#external_value:dbcount1}}}}{{#clear_external_data:}}{{#get_db_data:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="частное" AND grouptype="{{#var:grouptype}}"
 
|data=dbcount2=sum(quantity)
 
|data=dbcount2=sum(quantity)
 
}}{{#vardefine:at_ooo|{{#external_value:dbcount2}}}}{{#clear_external_data:}}{{#get_db_data:
 
}}{{#vardefine:at_ooo|{{#external_value:dbcount2}}}}{{#clear_external_data:}}{{#get_db_data:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="акционерное" AND grouptype="{{#var:grouptype}}"
 
|data=dbcount3=sum(quantity)
 
|data=dbcount3=sum(quantity)
 
}}{{#vardefine:at_ao|{{#external_value:dbcount3}}}}{{#clear_external_data:}}{{#get_db_data:
 
}}{{#vardefine:at_ao|{{#external_value:dbcount3}}}}{{#clear_external_data:}}{{#get_db_data:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="собственное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="собственное" AND grouptype="{{#var:grouptype}}"
 
|data=dbcount4=sum(quantity)
 
|data=dbcount4=sum(quantity)
 
}}{{#vardefine:at_priv|{{#external_value:dbcount4}}}}
 
}}{{#vardefine:at_priv|{{#external_value:dbcount4}}}}
Строка 90: Строка 90:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="государственное" AND grouptype="{{#var:grouptype}}"
 
|limit=1000
 
|limit=1000
 
|group by=names
 
|group by=names
Строка 120: Строка 120:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="акционерное" AND grouptype="{{#var:grouptype}}"
 
|limit=1000
 
|limit=1000
 
|group by=names
 
|group by=names
Строка 149: Строка 149:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="частное" AND grouptype="{{#var:grouptype}}"
 
|limit=1000
 
|limit=1000
 
|group by=names
 
|group by=names
Строка 178: Строка 178:
 
db=db1
 
db=db1
 
|from=statistic
 
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="собственное" AND grouptype="{{#var:grouptype}}"
+
|where=year="{{{1}}}" AND groups="{{#var:groups}}" AND types="собственное" AND grouptype="{{#var:grouptype}}"
 
|limit=1000
 
|limit=1000
 
|group by=names
 
|group by=names

Текущая версия на 21:00, 21 сентября 2014




{{{4}}} ( чел.)



Распределение выпускников по типам предприятий


Подробная статистика по типам предприятий
.