</select> автор доклада<br> <textarea name="text_content_<?php echo $row_id_detail; ?> " rows="6" cols="60"></textarea> текст доклада <p>Постановили <select name="opinion_id_<?php echo $row_id_detail; ?> " style="width:300;"> <?php $query = 'select id,name from protocol_opinions order by name'; echo getFrom_ListItemValue($query, 'id', 'name', 'opinion_id_' . $row_id_detail); ?> </select> решение <br> <textarea name="opinion_text_<?php echo $row_id_detail; ?> " rows="2" cols="60"></textarea> дополнение к решению <p> <label title="позволяет отслеживать выполнение в общем списке протоколов"><input type="checkbox" name="on_control_<?php echo $row_id_detail; ?> "> <span class=warning>на контроле</span> </label> <input type="file" name="file_name_<?php echo $row_id_detail; ?>
$add_string = reset_param_name($query_string, 'trip_id'); //для фильтра по преп-лю $add_string = reset_param_name($add_string, 'page'); //для перехода к первой странице сортировки по преп-лю //echo ' admin_role='.$admin_role; ?> Протокол № <select name="trip_id" id="trip_id" style="width:200;" onChange="javascript:window.location.href='?<?php echo reset_param_name($query_string, 'trip_id'); ?> &trip_id='+this.options[this.selectedIndex].value;"> <?php //getFrom_ListItemValue($listQuery,$listId,$listName,$FormListItemName) $query_ = 'select pt.id, concat(p.num," от ",DATE_FORMAT(p.date_text,"%d.%m.%Y") ," (", (select count(*) from protocol_trip_details ptd where ptd.trip_id=pt.id),")") as name from protocol_trips pt left join protocols p on p.id=pt.protocol_id order by 2 desc'; echo getFrom_ListItemValue($query_, 'id', 'name', 'trip_id'); ?> </select> <?php //persons_select($add_string.'&page=1&trip_id'); echo ' <input type=button value="Все" onclick=javascript:window.location.href="' . $main_page . '";> '; //echo showPrintSaveOpt('print&doc',$_SERVER['QUERY_STRING']); echo ' <b>список</b>: ' . showPrintSaveOpt('print&doc', $_SERVER['QUERY_STRING'], ''); if ($trip_id > 0) { //showPrintSaveOpt('print&doc',$_SERVER['QUERY_STRING']); echo ' <b>выписка</b>: ' . showPrintSaveOpt('print&doc', 'trip_id=' . $trip_id, 'protocol_trip_print.php'); } echo '</td> <td align=right><input type=text name="q" id="q" width=50 value=""> <input type=button value="Найти" title="поиск проводится в текущем разделе (архив или тек.уч.год) выбором соот.ссылки" OnClick=javascript:go2search(\'' . $trip_id . '\',\''; if (isset($_GET['archiv'])) {
$('#list1').change(function(){ //главный список, фильтруемый список, тип_запроса, разворачивать_при_пустом_главном adjustList2('list1','list2','StGroup2Students','allowMainIsNull'); }).change(); }); </script> </head> <body> <?php $files_path = '../../'; //include '../asu/sql_connect.php'; include $files_path . 'sql_connect.php'; ?> <div class="border"> <label>Страна</label><br /> <select id="list1"> <?php $listQuery = "SELECT id,\r\n\t concat(name,' (',(\r\n\t select count(*) from students s where s.group_id=sg.id\r\n\t ),')') as name\r\n\t FROM study_groups sg WHERE 1 order by sg.name"; echo getFrom_ListItemValue($listQuery, 'id', 'name', 'list1'); ?> </select> </div> <div class="border"> <label>Автомобиль</label> <span id="ac_loading" class="cascadeSelect_loading" style="display:none";> </span> <br /> <select id="list2" disabled="disabled"></select> </div> </body> </html>
<?php if (!isset($_GET['save']) && !isset($_GET['print'])) { ?> <div id="div_filter" class=text style="text-align:center;display:none;"> <form name=dateFilter action="" method="get" id="dateFilter"> дата начала<select name="dateFrom" id="dateFrom"> <?php $query = 'select distinct `year` from `izdan` where TRIM(`year`)<>"" order by `year` desc'; echo getFrom_ListItemValue($query, 'year', 'year', 'dateFrom'); ?> </select> окончания<select name="dateTo" id="dateTo"> <?php $query = 'select distinct `year` from `izdan` where TRIM(`year`)<>"" order by `year` desc'; echo getFrom_ListItemValue($query, 'year', 'year', 'dateTo'); ?> </select> <input type=button onClick='resetFilter()' value="x" title="сбросить фильтр"> <input type=button onClick='date_test()' value='Ok'> </form> </div> <div class=text style="text-align:center;"> <a href="#" onclick="hide_show('div_filter');">отобрать публикации по дате</a> </div> <?php echo "<div style='text-align:right;'>\r\n\t<a class=text href='?" . $_SERVER["QUERY_STRING"] . "&save&attach=xls' title='Выгрузить для анализа' target='_blank'>Передать в MS Excel</a> \r\n\t<a class=text href='?" . $_SERVER["QUERY_STRING"] . "&print' title='Распечатать' target='_blank'>Печать</a></div>"; } $rateArr = array(); $rateArr[0] = array('пособия, монографии и учебники', 0.5, '`izdan`.type_book=1 or `izdan`.type_book=27'); $rateArr[1] = array('пособия или учебники с гр. УМО', 1, '`izdan`.type_book=2 or `izdan`.type_book=28');
$query .= $search_query; } } $query .= ' order by ' . $groupArr[0][2] . ',' . $groupArr[1][2] . ',' . $groupArr[2][2] . ',4 '; //echo '$query='.$query; $res_PP = mysql_query($query . ' limit ' . ($page - 1) * $pageVals . ',' . $pageVals); if (mysql_num_rows($res_PP) == 0) { echo '<p class=warning style="width:80%;text-align:center;">В текущем учебном году записей не обнаружено. Возможно не указана предполагаемая дата защиты дипломного проекта, либо она раньше <u>' . DateTimeCustomConvert(substr($def_settings['date_start'], 0, 10), 'd', 'mysql2rus') . '</u>. Подробнее смотрите в <u>Примечание</u></p>'; } else { if (!isset($_GET['save']) && !isset($_GET['print'])) { echo '<table width=99% class="notinfo"><tr>'; echo '<td align=left width=350> Специальность <select name="speciality_id" id="speciality_id" style="width:200;" onChange=javascript:window.location.href="?"+this.id+"="+this.options[this.selectedIndex].value+"&' . reset_param_name(reset_param_name($query_string, 'speciality_id'), 'page') . '">'; $query_ = 'select id,name from specialities order by name'; echo getFrom_ListItemValue($query_, 'id', 'name', 'speciality_id'); echo '</select> </td><td> '; echo '<input type=button value="Все" onclick=javascript:window.location.href="' . $curpage . '";> <input type=button value="Печать" onclick=javascript:window.location.href="?print=1&' . $_SERVER["QUERY_STRING"] . '";> <input type=button value="в Word" onclick=javascript:window.location.href="?save&attach=doc&' . $_SERVER["QUERY_STRING"] . '"></td> <td align=right><input type=text name="q" id="q" width=50 value=""> <input type=button value="Найти" OnClick=javascript:go2search();></td> </tr></table>'; echo '<p>'; ?> <form name=order_list id=order_list action="" method="get"> порядок группировки: <?php if (isset($_GET['archiv'])) { echo '<input type=hidden id=archiv name=archiv>'; } for ($j = 0; $j < count($groupArr); $j++) {
echo '<p class="notinfo"><a href="?action=add&' . $_SERVER["QUERY_STRING"] . '"> Добавить</a> <a href="filial_form.php" title="более наглядно"> Добавить через печатную форму</a> <br/> <b>Справочники:</b> <a href="spravochnik.php?sprav_id=23&spr_type=0#id_23">филиалы</a> <a href="spravochnik.php?sprav_id=22&spr_type=0#id_22">тип проезда транспортом</a> <a href="spravochnik.php?sprav_id=21&spr_type=0#id_21">действия в командировке</a> <p>'; } echo '<table width=99% class="notinfo"><tr>'; echo '<td align=left width=150> Сотрудник* </td><td> <select name="kadri_id" id="kadri_id" style="width:300;" onChange=javascript:window.location.href="?kadri_id="+this.options[this.selectedIndex].value+"&' . reset_param_name($query_string, 'kadri_id') . '">'; $query = 'select kadri.id, concat(kadri.fio, " (",count(*),")") as caption from kadri right join filial_going fg on kadri.id = fg.kadri_id ' . ($view_all_mode ? "" : " where kadri.id=" . $kadri_id) . ' group by kadri.id,kadri.fio order by 2 ASC limit 0,1000'; echo getFrom_ListItemValue($query, 'id', 'caption', 'kadri_id'); echo '</select> '; if ($view_all_mode) { echo '<input type=button value="Все" onclick=javascript:window.location.href="' . $curpage . '";> '; } echo '<input type=button value="Печать" onclick=javascript:window.location.href="?print=1&' . $_SERVER["QUERY_STRING"] . '";> <input type=button value="в Word" onclick=javascript:window.location.href="?save&attach=doc&' . $_SERVER["QUERY_STRING"] . '"></td> <td align=right><input type=text name="q" id="q" width=50 value=""> <input type=button value="Найти" OnClick=javascript:go2search();></td> </tr></table> <p>'; } if ($q != '') { echo '<div>Поиск: <b><u>' . $q . '</u></b> <a href="?' . reset_param_name($query_string, 'q') . '">сбросить поиск</a></div><br>'; $search_query = 'and (kadri.`fio` like "%' . $q . '%" or kadri.`fio_short` like "%' . $q . '%" or
function print_hours($year, $part) { global $hour_kind_name, $hour_kind_code; global $total_year; //для расчета общего итога global $total_year_fil; global $part_num; global $kind_type_defaults; global $lect_control; global $lect_id; $hours_kind_type_selected = ''; //среди чего выборка по типу нагрузки $query = 'select id from hours_kind_type order by id'; $res = mysql_query($query); while ($a = mysql_fetch_array($res)) { //$select_val=''; if (isset($_GET['kind_type' . $a['id']]) && $_GET['kind_type' . $a['id']] == 'on') { if ($hours_kind_type_selected == '') { $hours_kind_type_selected = $a['id']; } else { $hours_kind_type_selected = $hours_kind_type_selected . ',' . $a['id']; } } //echo '<option value="'.$a['id'].'"'.$select_val.'>'.$a['name'].'</option>'; } $query_all = 'SELECT hours_kind.id,hours_kind.stud_cnt, subjects.name as subj_name, specialities.name as spec_name, levels.name as level_name, study_groups.name as group_name, study_groups.man_cnt as man_cnt,hours_kind.hours_kind_type,hours_kind.groups_cnt,hours_kind.comment,hours_kind.year_id,hours_kind.part_id, lects, practs, labor, rgr, recenz, kurs_proj, consult, test, exams, study_pract, work_pract, consult_dipl, gek, aspirants, aspir_manage, duty, time_intervals.name as year_name, time_parts.name as part_name,hours_kind_type.name as hours_kind_type_name,hours_kind.on_filial FROM hours_kind left join subjects on hours_kind.subject_id=subjects.id left join specialities on specialities.id=hours_kind.spec_id left join levels on levels.id=hours_kind.level_id left join study_groups on study_groups.id=hours_kind.group_id left join time_intervals on time_intervals.id=hours_kind.year_id left join time_parts on time_parts.id=hours_kind.part_id left join hours_kind_type on hours_kind_type.id=hours_kind.hours_kind_type where kadri_id=' . $_GET['kadri_id'] . ' and time_intervals.name="' . $year . '" and time_parts.name="' . $part . '" and hours_kind_type in(' . $hours_kind_type_selected . ') limit 0,100 '; //echo $query_all; if ($res_all = mysql_query($query_all) and mysql_numrows($res_all) > 0) { /*echo '<hr><font size=-1> Найдено записей: '.mysql_numrows($res_all).'</font><br>';*/ } else { if (!isset($_GET['save']) && !isset($_GET['print'])) { echo '<hr><font color="red" size=-1>Записей за указанный семестр нет</font>'; } } //echo $query_all; //для расчета нагрузки - список показателей видов часов echo '<div align="center"> ' . strtoupper($part) . ' СЕМЕСТР</div>'; $cols_disable = 0; //число скрытых столцов $not_print_cols = 0; //число непечатаемых столбцов (в нумерации столбцов) //echo ' kind_type_defaults='.$kind_type_defaults; echo '<form name="h_copy_' . $part_num . '" method="POST" action="?kadri_id=' . $_GET['kadri_id'] . '&year=' . $_GET['year'] . '&export' . $kind_type_defaults . '"><table name=tab1 border=1 cellpadding="0" cellspacing="0" width=""> <tr align="center" class="title">'; if (!isset($_GET['save']) && !isset($_GET['print']) && $_SESSION['userType'] == 'admin') { echo '<td width="50"><input type=checkbox name="checkbox_del_all' . $part_num . '" title="для копирования нагрузки" onClick="javascript:mark_all(this.name,' . $part_num . ');"> </td> <td width="50"><img src="images/todelete.png" title="Удалить"> <img src="images/toupdate.png" title="Правка"></td>'; } if ($_SESSION['userType'] != 'admin') { $cols_disable = 2; } echo '<td width="20">№</td>'; echo '<td width="230">НАИМЕНОВАНИЕ ДИСЦИПЛИН</td>'; //250 echo '<td width="20"><img src="images/hours_pics/facul.gif" border=0 title="Факультет"></td>'; echo '<td width="20"><img src="images/hours_pics/special.gif" border=0 title="Cпециальность"></td>'; echo '<td width="20"><img src="images/hours_pics/kurs.gif" border=0 title="Курс"></td>'; echo '<td width="20"><img src="images/hours_pics/gr_number.gif" border=0 title="Число групп"></td>'; echo '<td width="20"><img src="images/hours_pics/stud_number.gif" border=0 title="Количество студентов"></td>'; if (!isset($_GET['save']) && !isset($_GET['print'])) { //echo '<td width="60">группа</td>'; echo '<td width="100">тип нагрузки</td>'; echo '<td width="60">комментарий</td>'; } else { $not_print_cols = 4; } //вывод видов часов (лекция, практ, лабор...) for ($i = 0; $i < sizeof($hour_kind_name); $i++) { echo '<td><img src="images/hours_pics/' . $hour_kind_code[$i] . '.gif" alt="' . $hour_kind_name[$i] . '"></td>'; } echo '<td><img src="images/hours_pics/sum.gif" alt="Всего часов"></td>'; $add_col = 0; //добавочный номер для столбца if (isset($_GET['filial_flag']) && $_GET['filial_flag'] == 'on') { echo '<td><img src="images/hours_pics/add_filials.gif" alt="надбавка 50% к всего"></td>'; //$cols_disable--;$not_print_cols--; $add_col = 1; } echo '</tr><tr align="center" class="main_">'; if (!isset($_GET['save']) && !isset($_GET['print'])) { for ($i = 1; $i < sizeof($hour_kind_name) + 13 - $cols_disable + $add_col; $i++) { echo '<td>' . $i . '</td>'; } } else { for ($i = 1; $i < sizeof($hour_kind_name) + 13 - $not_print_cols + $add_col; $i++) { echo '<td>' . $i . '</td>'; } } echo '</tr>'; // echo '<h3>$total='.$total.'</h3>'; $total = 0; $sumCol = array(); //итоги по столбцам for ($i = 0; $i < sizeof($hour_kind_code); $i++) { $sumCol[$i] = 0; } $j = 0; $sumColFilial = 0; while ($tmpval = mysql_fetch_array($res_all)) { $sum = 0; $j++; echo '<tr align="left" class="main_">'; if (!isset($_GET['save']) && !isset($_GET['print']) && $_SESSION['userType'] == 'admin') { echo ' <td width="50"><input type=checkbox name="checkbox_h_copy_' . $tmpval['id'] . '" title="для копирования нагрузки"> </td> <td align="center"> <a href=javascript:del_confirm(' . $_GET['kadri_id'] . ',' . $tmpval['id'] . ',' . $tmpval['year_id'] . ') title="Удалить"> <img src="images/todelete.png" alt="Удалить" border="0"></a> <a href="s_hours.php?kadri_id=' . $_GET['kadri_id'] . '&hours_id=' . $tmpval['id'] . '&tab=2" title="Правка"> <img src="images/toupdate.png" alt="Правка" border="0"></a></td>'; } //else {} echo '<td width="">' . $j . ' </td>'; echo '<td width="230" align=left>' . $tmpval['subj_name'] . ' </td>'; echo '<td width="30"> ИРТ</td>'; echo '<td width="30" align=center>' . $tmpval['spec_name'] . ' </td>'; echo '<td width="30" align=right>' . $tmpval['level_name'] . ' </td>'; if (trim($tmpval['man_cnt']) != '') { $tmpval['man_cnt'] = ' ( ' . $tmpval['man_cnt'] . 'чел. )'; } else { $tmpval['man_cnt'] = ''; } if ($tmpval['groups_cnt'] == 0) { $tmpval['groups_cnt'] = ''; } echo '<td align=right>' . $tmpval['groups_cnt'] . ' </td>'; if ($tmpval['stud_cnt'] == 0) { $tmpval['stud_cnt'] = ''; } echo '<td align=right>' . $tmpval['stud_cnt'] . ' </td>'; //число студентов if (!isset($_GET['save']) && !isset($_GET['print'])) { //echo '<td>'.$tmpval['group_name'].$tmpval['man_cnt'].' </td>'; /*if ($tmpval['hours_kind_type']==0) {$tmpval['hours_kind_type']='основная';} else {$tmpval['hours_kind_type']='дополнительная';}*/ echo '<td>' . $tmpval['hours_kind_type_name'] . ' </td>'; echo '<td>' . $tmpval['comment'] . ' </td>'; } for ($i = 0; $i < sizeof($hour_kind_code); $i++) { if ($tmpval[$hour_kind_code[$i]] == 0) { $tmpval[$hour_kind_code[$i]] = ''; } echo '<td align="center">' . $tmpval[$hour_kind_code[$i]] . ' </td>'; $sum += $tmpval[$hour_kind_code[$i]]; $sumCol[$i] += $tmpval[$hour_kind_code[$i]]; } echo '<td align="center">' . $sum . ' </td>'; if (isset($_GET['filial_flag']) && $_GET['filial_flag'] == 'on') { //вывод с учетом выезда if ($tmpval['on_filial'] == 1) { echo '<td align="center">' . $sum * 0.5 . ' </td>'; $sumColFilial += $sum * 0.5; } else { echo '<td align="center"> </td>'; } } echo '</tr>'; $total += $sum; $part_id = $tmpval['part_id']; $year_id = $tmpval['year_id']; } echo '<tr>'; //<td> </td><td> </td>'; if (!isset($_GET['save']) && !isset($_GET['print']) && $_SESSION['userType'] == 'admin') { echo '<td colspan=2> </td>'; } echo '<td align="center" colspan=2> Итого часов: </td><td> </td>'; for ($i = 0; $i < 6 - $not_print_cols / 2; $i++) { echo '<td align="center"> </td>'; } $sumTimeTibleCheck = 0; //для сверки с расписанием for ($i = 0; $i < sizeof($hour_kind_code); $i++) { if ($sumCol[$i] > 0) { //подсчет суммы (Лекции+ЛабРаб+Практики) для сверки с расписанием if ($i < 3 && !isset($_GET['save']) && !isset($_GET['print'])) { $sumTimeTibleCheck += $sumCol[$i]; //------------------------- $sum_l_h = 0; //.$hour_kind_name[$i] switch ($hour_kind_name[$i]) { case 'лаборатор. занятий': // $sum_l_h = hour_cnt($lect_id, $year_id, $part_id, 'л/р'); break; case 'лекции': // $sum_l_h = hour_cnt($lect_id, $year_id, $part_id, 'л'); break; case 'практич.': // $sum_l_h = hour_cnt($lect_id, $year_id, $part_id, 'пр'); break; } //------------------------- if ($sumCol[$i] != $sum_l_h) { echo '<td align="center">' . $sumCol[$i] . '<span class=warning>' . $sum_l_h . '</span></td>'; } else { echo '<td align="center">' . $sumCol[$i] . '</td>'; } } else { echo '<td align="center">' . $sumCol[$i] . '</td>'; } } else { echo '<td align="center"> </td>'; } } echo '<td align="center">' . $total . '</td>'; //учет при выборе "с учетом Филиалов" if (isset($_GET['filial_flag']) && $_GET['filial_flag'] == 'on') { $total_year_fil += $total + $sumColFilial; if ($sumColFilial > 0) { echo '<td align="center">' . $sumColFilial . ' </td>'; } else { echo '<td align="center"> </td>'; } } echo '</tr>'; $total_year += $total; echo '</table>'; //окончание формы часов if (!isset($_GET['save']) && !isset($_GET['print']) && $lect_control) { ?> <select name=type_copy style="width:300;"> <option value=0> копировать с перемещением (удаляем у одного- добавляем другому) </option> <option value=1> только копирование (сохраняем у одного и добавляем другому)</option> </select> <select id="teach_name" name="teach_name" style="width:200;"><?php if ($_SESSION['userType'] == 'admin' || $_SESSION['role'] == 'izdan') { $listQuery = 'select k.id,k.fio from kadri k left join person_types pt on pt.id=k.person_type where pt.name_short like "%ППС%" order by fio '; } else { $listQuery = 'select k.id,k.fio from kadri k left join person_types pt on pt.id=k.person_type where pt.name_short like "%ППС%" and k.id="' . trim($_GET['kadri_id']) . '" order by fio '; } echo getFrom_ListItemValue($listQuery, 'id', 'fio', 'kadri_id'); ?> </select> <select name="year_list" style="width:100;"> <option value="0">год</option> <?php $query = 'select id,name from time_intervals order by name desc'; $res = mysql_query($query); while ($a = mysql_fetch_array($res)) { $select_val = ''; if (isset($tmpval)) { if ($tmpval['year_id'] == $a['id']) { $select_val = ' selected'; } } else { if (isset($_POST['year_list'])) { if ($_POST['year_list'] == $a['id']) { $select_val = ' selected'; } } else { if (isset($def_settings)) { if ($def_settings['year_id'] == $a['id']) { $select_val = ' selected'; } } } } echo '<option value="' . $a['id'] . '"' . $select_val . '>' . $a['name'] . '</option>'; } ?> </select> <select name="part_list" style="width:100;"> <option value="0">семестр</option> <?php $query = 'select id,name from time_parts order by name desc '; $res = mysql_query($query); while ($a = mysql_fetch_array($res)) { $select_val = ''; if (isset($tmpval)) { if ($tmpval['part_id'] == $a['id']) { $select_val = ' selected'; } } else { if (isset($_POST['part_list'])) { if ($_POST['part_list'] == $a['id']) { $select_val = ' selected'; } } else { if (isset($def_settings)) { if ($def_settings['part_id'] == $a['id']) { $select_val = ' selected'; } } } } echo '<option value="' . $a['id'] . '"' . $select_val . '>' . $a['name'] . '</option>'; } ?> </select> <input type=button value="Ok" onClick="javascript:test_copy(<?php echo $part_num; $part_num++; ?> );"> </form> <?php $sum_l_h = 0; $sum_l_h = hour_cnt($lect_id, $year_id, $part_id, ''); //echo 'lect_id='.$lect_id.', year='.$tmpval['year_id'].', part='.$tmpval['part_id'].', sum_l_h='.$sum_l_h; if ($sum_l_h != $sumTimeTibleCheck) { echo '<div class=warning> за <u>' . $part . '</u> семестр ошибка сверки с расписанием. в расписании=' . $sum_l_h . ', в нагрузке=' . $sumTimeTibleCheck . '</div>'; } else { echo '<div class=success>за <u>' . $part . '</u> семестр сверено с расписанием</div>'; } } //echo '<div align="left"> Итого часов: '.$total.'</div>'; }
echo $dolgnost; ?> </span></u></b> <span style='font-size:10.0pt'>Ф.И.О.</span><b><u><span style='font-size:10.0pt'> <?php if (!isset($_GET['save']) && !isset($_GET['print'])) { ?> <select id="kadri_id3" name="kadri_id3" onChange="javascript:confirm_url('?kadri_id='+this.options[this.selectedIndex].value+'&<?php echo reset_param_name($query_string, 'kadri_id'); ?> ');" style="width:80;"><?php $listQuery = "select k.id,k.fio_short as name \r\n\t\t \tfrom kadri k \r\n\t\t\torder by k.fio"; //getFrom_ListItemValue($listQuery,$listId,$listName,$FormListItemName) echo getFrom_ListItemValue($listQuery, 'id', 'name', 'kadri_id'); ?> </select> <?php } else { echo '<b><u>' . $fio_short . '</u></b>'; } ?> </span></u></b></p> <p class=MsoBodyText2 style='margin-top:6.0pt'>Назначение аванса:</p> <table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0 style='margin-left:5.4pt;border-collapse:collapse;border:none'> <tr style='page-break-inside:avoid;height:18.7pt'> <td width=83 style='width:62.2pt;border:solid windowtext 1.0pt;border-left: none;padding:0cm 5.4pt 0cm 5.4pt;height:18.7pt'> <p class=MsoNormal align=center style='text-align:center'><span
$query = 'SELECT s.id, concat(s.fio," (",sg.name,")") as name FROM study_groups sg RIGHT OUTER JOIN students s ON (sg.id = s.group_id) '; if ($param1 != '' && $param1 == 'true') { //текущий год $query .= 'WHERE (sg.year_id = ' . $def_settings['year_id'] . ') order by 2'; } else { //поиск в архиве $query .= 'WHERE (sg.year_id < ' . $def_settings['year_id'] . ' or sg.year_id is NULL) order by 2'; } break; case 'pract_list': $query = 'select id,concat(name," (",replace((select count(*) from `diploms` where diploms.pract_place_id=pract_places.id),"0","-"),")") as name from pract_places '; if ($param2 != '' && $param2 == 'true' && $param1 != '') { //применить фильтр $query .= 'WHERE (name like "%' . $param1 . '%" or comment like "%' . $param1 . '%")'; } else { //отменить фильтр } $query .= ' order by 2'; break; default: $query = ''; } if ($listId != '' && $selectId > 0) { $res_edit[$listId] = $selectId; } $list_str = getFrom_ListItemValue($query, 'id', 'name', $listId); //$list_str='<option>'.'$listId='.$listId.',$selectId='.$selectId.'</option>'; echo mb_convert_encoding($list_str, "UTF-8", "cp1251"); } }
echo ' <tr><td> специальность *</td><td> <select name="spec_id" id="spec_id" style="width:300;">'; $listQuery = 'select id,name from specialities order by name'; echo getFrom_ListItemValue($listQuery, 'id', 'name', 'spec_id'); echo ' </select></td></tr>'; echo ' <tr><td> курс * </td><td> <select name="level_id" style="width:300;">'; $listQuery = 'select id,name from levels order by name'; echo getFrom_ListItemValue($listQuery, 'id', 'name', 'level_id'); echo ' </select></td></tr>'; //------------------------------------------------------------------------------ ?> <tr><td> тип нагрузки</td><td> <select name="hours_kind_type" style="width:300;"> <?php $listQuery = 'select id,name from hours_kind_type order by id'; echo getFrom_ListItemValue($listQuery, 'id', 'name', 'hours_kind_type'); ?> </select><br> <label><input type=checkbox name="filial_flag" <?php if (isset($res_edit) && $res_edit['on_filial'] == 1) { echo ' checked'; } ?> > <font color=red>с учетом выезда</font></label> </td></tr> <tr><td> число групп</td> <td><input type=text maxlength="3" value="<?php if (isset($res_edit)) { echo $res_edit['groups_cnt']; }