|
|
| Строка 1: |
Строка 1: |
| − | {{#vardefine:year|2011}}
| |
| − | =Статистика трудоустройства выпускников за {{#var:year}} год=
| |
| | | | |
| − | {{:Выпускники:Статистика:Шапка}}
| |
| − | ----
| |
| − | {{#vardefine:groups|at}}
| |
| − | {{#vardefine:desc|Специальность 220201.65 "Управление и информатика в технических системах"}}
| |
| − | {{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}"
| |
| − | |data=dbcount=sum(quantity)
| |
| − | }}{{#vardefine:at_total|{{#external_value:dbcount}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное"
| |
| − | |data=dbcount1=sum(quantity)
| |
| − | }}{{#vardefine:at_gp|{{#external_value:dbcount1}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное"
| |
| − | |data=dbcount2=sum(quantity)
| |
| − | }}{{#vardefine:at_ooo|{{#external_value:dbcount2}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное"
| |
| − | |data=dbcount3=sum(quantity)
| |
| − | }}{{#vardefine:at_ao|{{#external_value:dbcount3}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="собственное"
| |
| − | |data=dbcount4=sum(quantity)
| |
| − | }}{{#vardefine:at_priv|{{#external_value:dbcount4}}}}{{#var:at_priv}}
| |
| − | == {{#var:desc}} ({{#var:at_total}} чел.)==
| |
| − | ----
| |
| − |
| |
| − |
| |
| − | {| class="tiles" align="center"
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Распределение выпускников по типам предприятий
| |
| − | |-
| |
| − | {{#if:{{#var:at_gp}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Государственные предприятия
| |
| − | |
| |
| − | {{#var:at_gp}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_gp}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_ao}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Акционерные предприятия
| |
| − | |
| |
| − | {{#var:at_ao}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_ao}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_ooo}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Частные компании
| |
| − | |
| |
| − | {{#var:at_ooo}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_ooo}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_priv}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Собственные предприятия
| |
| − | |
| |
| − | {{#var:at_priv}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_priv}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | |}
| |
| − |
| |
| − |
| |
| − |
| |
| − | {| class="tiles" align="center"
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Подробная статистика по типам предприятий
| |
| − | |-
| |
| − | {{#if:{{#var:at_gp}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − |
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Государственные предприятия - {{PeoplePercent|{{#var:at_gp}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | |-
| |
| − | }}
| |
| − | }}
| |
| − | {{#if:{{#var:at_ao}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Акционерные предприятия - {{PeoplePercent|{{#var:at_ao}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | |-
| |
| − | }}
| |
| − | }}
| |
| − | {{#if:{{#var:at_ooo}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Частные компании - {{PeoplePercent|{{#var:at_ooo}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | }}
| |
| − | }}
| |
| − | |}
| |
| − |
| |
| − | ----
| |
| − | {{#vardefine:groups|tk}}
| |
| − | {{#vardefine:desc|Специальность 210406.65 "Сети связи и системы коммутации"}}
| |
| − | {{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}"
| |
| − | |data=dbcount=sum(quantity)
| |
| − | }}{{#vardefine:at_total|{{#external_value:dbcount}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное"
| |
| − | |data=dbcount1=sum(quantity)
| |
| − | }}{{#vardefine:at_gp|{{#external_value:dbcount1}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное"
| |
| − | |data=dbcount2=sum(quantity)
| |
| − | }}{{#vardefine:at_ooo|{{#external_value:dbcount2}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное"
| |
| − | |data=dbcount3=sum(quantity)
| |
| − | }}{{#vardefine:at_ao|{{#external_value:dbcount3}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="собственное"
| |
| − | |data=dbcount4=sum(quantity)
| |
| − | }}{{#vardefine:at_priv|{{#external_value:dbcount4}}}}{{#var:at_priv}}
| |
| − | == {{#var:desc}} ({{#var:at_total}} чел.)==
| |
| − | ----
| |
| − |
| |
| − |
| |
| − | {| class="tiles" align="center"
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Распределение выпускников по типам предприятий
| |
| − | |-
| |
| − | {{#if:{{#var:at_gp}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Государственные предприятия
| |
| − | |
| |
| − | {{#var:at_gp}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_gp}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_ao}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Акционерные предприятия
| |
| − | |
| |
| − | {{#var:at_ao}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_ao}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_ooo}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Частные компании
| |
| − | |
| |
| − | {{#var:at_ooo}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_ooo}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_priv}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Собственные предприятия
| |
| − | |
| |
| − | {{#var:at_priv}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_priv}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | |}
| |
| − |
| |
| − |
| |
| − |
| |
| − | {| class="tiles" align="center"
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Подробная статистика по типам предприятий
| |
| − | |-
| |
| − | {{#if:{{#var:at_gp}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − |
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Государственные предприятия - {{PeoplePercent|{{#var:at_gp}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | |-
| |
| − | }}
| |
| − | }}
| |
| − | {{#if:{{#var:at_ao}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Акционерные предприятия - {{PeoplePercent|{{#var:at_ao}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | |-
| |
| − | }}
| |
| − | }}
| |
| − | {{#if:{{#var:at_ooo}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Частные компании - {{PeoplePercent|{{#var:at_ooo}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | }}
| |
| − | }}
| |
| − | |}
| |
| − |
| |
| − |
| |
| − |
| |
| − | ----
| |
| − | {{#vardefine:groups|kzi}}
| |
| − | {{#vardefine:desc|Специальность 090105.65 "Комплексное обеспечение информационной безопасности автоматизированных систем"}}
| |
| − | {{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}"
| |
| − | |data=dbcount=sum(quantity)
| |
| − | }}{{#vardefine:at_total|{{#external_value:dbcount}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное"
| |
| − | |data=dbcount1=sum(quantity)
| |
| − | }}{{#vardefine:at_gp|{{#external_value:dbcount1}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное"
| |
| − | |data=dbcount2=sum(quantity)
| |
| − | }}{{#vardefine:at_ooo|{{#external_value:dbcount2}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное"
| |
| − | |data=dbcount3=sum(quantity)
| |
| − | }}{{#vardefine:at_ao|{{#external_value:dbcount3}}}}{{#clear_external_data:}}{{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="собственное"
| |
| − | |data=dbcount4=sum(quantity)
| |
| − | }}{{#vardefine:at_priv|{{#external_value:dbcount4}}}}{{#var:at_priv}}
| |
| − | == {{#var:desc}} ({{#var:at_total}} чел.)==
| |
| − | ----
| |
| − |
| |
| − |
| |
| − | {| class="tiles" align="center"
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Распределение выпускников по типам предприятий
| |
| − | |-
| |
| − | {{#if:{{#var:at_gp}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Государственные предприятия
| |
| − | |
| |
| − | {{#var:at_gp}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_gp}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_ao}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Акционерные предприятия
| |
| − | |
| |
| − | {{#var:at_ao}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_ao}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_ooo}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Частные компании
| |
| − | |
| |
| − | {{#var:at_ooo}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_ooo}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | {{#if:{{#var:at_priv}}|{{#!:
| |
| − | |-
| |
| − | !
| |
| − | *Собственные предприятия
| |
| − | |
| |
| − | {{#var:at_priv}} чел.
| |
| − | |
| |
| − | {{Progress|{{#expr:({{#var:at_priv}}/{{#var:at_total}})*100 round 2}}|350}}
| |
| − | |-
| |
| − | }}}}
| |
| − | |}
| |
| − |
| |
| − |
| |
| − |
| |
| − | {| class="tiles" align="center"
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Подробная статистика по типам предприятий
| |
| − | |-
| |
| − | {{#if:{{#var:at_gp}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="государственное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − |
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Государственные предприятия - {{PeoplePercent|{{#var:at_gp}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | |-
| |
| − | }}
| |
| − | }}
| |
| − | {{#if:{{#var:at_ao}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="акционерное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Акционерные предприятия - {{PeoplePercent|{{#var:at_ao}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | |-
| |
| − | }}
| |
| − | }}
| |
| − | {{#if:{{#var:at_ooo}}|{{#!:
| |
| − | {{#clear_external_data:}}
| |
| − | {{#get_db_data:
| |
| − | db=db1
| |
| − | |from=statistic
| |
| − | |where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="{{#var:groups}}" AND types="частное"
| |
| − | |limit=1000
| |
| − | |group by=names
| |
| − | |order by=types,names
| |
| − | |data=dbtypes=types,dbnames=names,dbyear=year,dbquantity=sum(quantity),dbpercent=sum(quantity)/{{#var:at_total}}*100,dbgroups=groups
| |
| − | }}
| |
| − | |- class="shadow"
| |
| − | ! colspan=3 height="30" | Частные компании - {{PeoplePercent|{{#var:at_ooo}}|{{#var:at_total}}}}
| |
| − | |-
| |
| − | {{#for_external_table:<nowiki />
| |
| − | {{#!:
| |
| − | |-
| |
| − | !
| |
| − | *{{{dbnames}}}
| |
| − | |
| |
| − | {{#vardefine:at_temp|{{{dbquantity}}}}}
| |
| − | '''{{{dbquantity}}} чел.'''
| |
| − | |
| |
| − | '''{{{dbpercent}}}%'''
| |
| − | }}
| |
| − | }}
| |
| − | }}
| |
| − | }}
| |
| − | |}
| |
| − |
| |
| − | __NOTOC__ __NOTITLE__
| |
