/**
* Получить текущие tpd в ИУПах ФДДО.
* @param array $sem настройки семестра, по умолчанию - все семестры
* @return array [ [id_iup , numst , id_tup , id_link_tup_d , sem , year] ]
*/
public static function getIuptpd($sem = false, $kaf = false)
{
$MsSQL = RPDB::connect();
$q = 'select
iup.id id_iup,
iup.numst,
iup.id_tup,
link.id_link_tup_d,
link.sem,
tup.year
from link_iup_tup_d link,iup,tup
where iup.id= link.id_iup AND iup.type=1 AND tup.id=iup.id_tup';
$STH = $MsSQL->prepare($q);
$arResult = array();
if ($STH->execute()) {
$_t = $STH->fetchAll(PDO::FETCH_ASSOC);
if ($sem) {
foreach ($_t as $k => $v) {
if ($v['sem'] == RPU::absSemForUP($v['year'], $sem)) {
$arResult[$k] = $v;
}
}
} else {
$arResult = $_t;
}
}
return $arResult;
}
if ($row['ws'] == $row['we']) {
$unvis[$i]['week'] = $row['ws'] . ' неделя';
} else {
$unvis[$i]['week'] = $row['ws'] . ' - ' . $row['we'] . ' недели';
}
}
//Взять взыскания студента
$sanction = RPIrro::getSanction($gr['id']);
$textzamech = array('1' => "Замечание", "2" => "Выговор");
foreach ($sanction as $i => $row) {
$sanction[$i]['data'] = RPU::convDtP($row['data']);
$sanction[$i]['type'] = $textzamech[$row['id_type']];
}
//Взять направление и профиль
$MsSQL = RPDB::connect();
$result = $MsSQL->prepare("select np.name np,op.name op from np,op,bup,tup,tup_gr where op.id_np=np.id AND bup.id_op=op.id AND tup.id_bup=bup.id AND tup_gr.id=tup.id AND tup_gr.gr=?");
if (!$result->execute(array($gr['id']))) {
throw new Exception('Ошибка при нахождении НП и ОП');
}
if (!($studinf = $result->fetch(PDO::FETCH_ASSOC))) {
throw new Exception('Ошибка при нахождении НП и ОП');
}
//============================
$arResult['dis'] = $dis;
$arResult['dolg'] = $dolg;
$arResult['sem'] = RPU::absSemForUP($gr['year'], $set);
$arResult['napr'] = $studinf['np'];
$arResult['prof'] = $studinf['op'];
$arResult['unvis'] = RPU::filterBy($unvis, array('numst' => $numst));
$arResult['sanction'] = RPU::filterBy($sanction, array('numst' => $numst));
$arResult['irs_km'] = $irs_km;
