Шаблон:ВыпускникиБД — различия между версиями
Материал из Кафедра Автоматики и телемеханики
Corrector (обсуждение | вклад) |
Corrector (обсуждение | вклад) |
||
| (не показана одна промежуточная версия этого же участника) | |||
| Строка 6: | Строка 6: | ||
db=db1 | db=db1 | ||
|from=statistic | |from=statistic | ||
| − | |where=year= | + | |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={{ | + | |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={{ | + | |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={{ | + | |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={{ | + | |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={{ | + | |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={{ | + | |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={{ | + | |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={{ | + | |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}}} ( чел.)
| Распределение выпускников по типам предприятий |
|---|
| Подробная статистика по типам предприятий |
|---|
