Шаблон:ВыпускникиБД — различия между версиями
Материал из Кафедра Автоматики и телемеханики
Corrector (обсуждение | вклад) |
Corrector (обсуждение | вклад) |
||
| (не показаны 3 промежуточные версии этого же участника) | |||
| Строка 1: | Строка 1: | ||
---- | ---- | ||
| − | {{ | + | {{#vardefine:groups|{{{2}}}}} |
| − | {{{2}} | + | {{#vardefine:grouptype|{{{3}}}}} |
| − | + | {{#vardefine:desc|{{{4}}}}} | |
| − | {{#vardefine: | + | |
| − | {{#vardefine: | + | |
| − | + | ||
{{#clear_external_data:}}{{#get_db_data: | {{#clear_external_data:}}{{#get_db_data: | ||
db=db1 | db=db1 | ||
|from=statistic | |from=statistic | ||
| − | |where={{ | + | |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}}}} | ||
| Строка 93: | Строка 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 | ||
| Строка 123: | Строка 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 | ||
| Строка 152: | Строка 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 | ||
| Строка 181: | Строка 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}}} ( чел.)
| Распределение выпускников по типам предприятий |
|---|
| Подробная статистика по типам предприятий |
|---|
