Просмотр исходного текста страницы Выпускники:Статистика:2000

{{#vardefine:year|1999}}
{{#vardefine:type|at}}
=Статистика трудоустройства выпускников за {{#var:year}} год=


{{#get_db_data:
db=db1
|from=statistic
|where={{#if:{{#var:year}}|year={{#var:year}} AND}} groups="at"
|data=dbcount=sum(quantity)
}}
{{#vardefine:at_total|{{#external_value:dbcount}}}}

{{#clear_external_data:}}
{{#get_db_data:
db=db1
|from=statistic
|where=year={{#var:year}} AND groups="at" AND types="государственное"
|data=dbcount1=sum(quantity)
}}
{{#vardefine:at_gp|{{#external_value:dbcount1}}}}

{{#clear_external_data:}}
{{#get_db_data:
db=db1
|from=statistic
|where=year={{#var:year}} AND groups="at" AND types="частное"
|data=dbcount2=sum(quantity)
}}
{{#vardefine:at_ooo|{{#external_value:dbcount2}}}}

{{#clear_external_data:}}
{{#get_db_data:
db=db1
|from=statistic
|where=year={{#var:year}} AND groups="at" AND types="акционерное"
|data=dbcount3=sum(quantity)
}}
{{#vardefine:at_ao|{{#external_value:dbcount3}}}}

{{#clear_external_data:}}
{{#get_db_data:
db=db1
|from=statistic
|where=year={{#var:year}} AND groups="at" AND types="собственное"
|data=dbcount4=sum(quantity)
}}
{{#vardefine:at_priv|{{#external_value:dbcount4}}}}

{{#var:at_priv}}


{{:Выпускники:Статистика:Шапка}}
----

== Специальность 220201.65 "Управление и информатика в технических системах" ({{#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=year={{#var:year}} AND groups="at" 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=year={{#var:year}} AND groups="at" 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=year={{#var:year}} AND groups="at" 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__