<?php
session_start();
header('Content-Type: text/html; charset=utf-8');

if(isset($_POST['ajdes'])){
	include '_db.php';
	include '../config.php';
	include 'functions.php';
	
	$out=array();
	if($_POST['ajdes']=='save_students'){//Изменение студентов группы и емаил
		$out['gid'] = $_POST['gid']; $er_kol=0; $su_kol=0; $out['html'] = '';
		foreach($_POST['podgrupp'] as $key => $val){
			if($val=='') $val=1;
			$sql = 'UPDATE '.$ST['dbpf'].'_students SET num_grupp="'.$val.'" WHERE id='.$key.'';
			$rez = $DB->QUR($sql);
			if(!$rez['err'])$su_kol++; else $er_kol++;
		}
		$out['html'] .= 'Номера групп: успех:'.$su_kol.'; ошибок: '.$er_kol.'';
		$er_kol=0; $su_kol=0;
		foreach($_POST['email'] as $key => $val){
			$sql = 'UPDATE '.$ST['dbpf'].'_users SET email="'.$val.'" WHERE id='.$key.'';
			$rez = $DB->QUR($sql);
			if(!$rez['err'])$su_kol++; else $er_kol++;
		}
		$out['html'] .= ' | Email: успех:'.$su_kol.'; ошибок: '.$er_kol.'';	
	}
	if($_POST['ajdes']=='send_email'){//получение инфы о преподе
		$user_id = (int)$_POST['user_id'];
		//$user_id = 1;
		$email = $_POST['email'];
		//$email = 'alneo.ru@yandex.ru';
		$message = nl2br($_POST['message']);
		$message .= "\n<br>---<br>\nВас проверял: ".$_SESSION['user']['fio'].' '.date('H:i d.m.Y');
		$html='';
		if($email!=''){
			//$e = send_email('EIOS.MKGTU.RU Результаты проверки',$message,$email);
			//if($e) $html .= 'Письмо пользователю отправлено!<br>';
			//else $html .= 'Письмо пользователю не отправлено!<br>';
            $params['eml']['email']=$email;
            $params['eml']['title']='EIOS.MKGTU.RU Результаты проверки';
            $params['eml']['message']=$message;
		}
		//$sql = 'INSERT INTO '.$ST['dbpf'].'_pm VALUES (0,'.mktime().','.$_SESSION['user']['id'].','.$user_id.',"'.$message.'",2,1,"")';
		//$rez = $DB->QUR($sql);
		//if(!$rez['err']) $html .= 'Личное сообщение на сайте отправлено!<br>';
		//else $html .= 'Личное сообщение на сайте не отправлено!<br>';

        include_once 'inc/pm_route.php';
        $params['pm']['otkogo_user_id'] = $_SESSION['user']['id'];
        $params['pm']['komu_user_id'] = $user_id;
        $params['pm']['message_text'] = $message;
        $params['pm']['from_status'] = 2;
        $params['pm']['to_status'] = 1;
        $params['pm']['file'] = '';
        $pm_rez = PM_SEND($params);

        if($pm_rez['eml']['send']==1) $html .= 'Письмо пользователю отправлено!<br>'; else $html .= 'Письмо пользователю не отправлено!<br>';
        if($pm_rez['pm']['send']==1) $html .= 'Личное сообщение на сайте отправлено!<br>'; else $html .= 'Личное сообщение на сайте не отправлено!<br>';


		//$out['html'] = '<pre>'.print_r($_POST,1).'</pre>';
		$out['html'] = $html;
	}
	if($_POST['ajdes']=='get_info_prepod'){//получение инфы о преподе
		$id = (int)$_POST['id'];
		$what=$_POST['what'];
		$fio='';
		$sql = 'SELECT u.id,u.fio,t.id as tid FROM '.$ST['dbpf'].'_users as u,'.$ST['dbpf'].'_teachers as t WHERE u.id='.$id.' AND t.id_user=u.id LIMIT 1';
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			$id = $rez[1]['id'];
			$fio = $rez[1]['fio'];
			$tid = $rez[1]['tid'];
			$file = '../tmp/get_info_prepod/'.translit($fio).'_'.$id.'.json';
			//if(!file_exists($file)){ //нужно связаться с расчетом часов и узнать
			if(!file_exists($file)){ //нужно связаться с расчетом часов и узнать
				$url = 'http://local.mkgtu.ru/calchour_2023/get_json.php?json=get_info_prepod&fio='.urlencode($fio).'';
				$json = file_get_contents($url);
				file_put_contents($file,$json);
			}else{
				$json = file_get_contents($file);
			}
			$html = prepod_check_status($json,$tid,$what);
		}
		$out['html'] = $html;
	}
	
	echo json_encode($out);
	exit();
}
//echo '<pre>'.print_r($_GET,1).'</pre>';
function get_kafedra_disciplin($kafedra,$sem='9'){//получение дисциплин из учебного плана
	$file = 'tmp/statuses/json_get_disciplins_'.md5($kafedra.$sem).'.json';
	//if((time()-$ft)>(60*60*24*30)) unlink($file);//файл обновляется 1 раз в 30 дней
	if((time()-$ft)>(60*60*24*30)) unlink($file);//файл обновляется 1 раз в 30 дней
	if(!file_exists($file)){
	//if(true){
		$url = 'http://local.mkgtu.ru/calchour_2023/get_json.php?json=get_disciplins&kafedra='.urlencode($kafedra).'&sem='.urlencode($sem).'';
		$json = file_get_contents($url);
		file_put_contents($file,$json);
	}else{
		$json = file_get_contents($file);
	}
	//$json1 = array_unique(json_decode($json,1));
	$json1 = json_decode($json,1);
	return $json1;
}
/**
* Функция для получения уникального ассоциативного массива по ключу
* @var $key - ключ, по которому будет выборка
* @var $array - исходный массив
*
* @return - Вернет уникальный массив
*/
/*function getUniqueArray($key, $array){
    $arrayKeys = array(); // массив для хранения ключей
    $resultArray = array(); // выходной массив
    foreach($array as $one){ // проходим циклом по всему исходному массиву
        if(!in_array($one[$key], $arrayKeys)){ // если такого значения еще не встречаласть, то
            $arrayKeys[] = $one[$key]; // пишем значение ключа в массив, для дальнейшей проверки
            $resultArray[] = $one; // записываем уникальное значение в выходной массив
        }
    }
    return $resultArray; // возвращаем массив
}*/

if(isset($_GET['page'])){
	if ($_GET['page'] == 'st39_8'){ //активность преподавателЯ
		$st_view='st39_8'; 
		$logs = array();
		
		
		//proverka активности преподавателя
		if (isset($_POST['search_active'])){
			$fio = $_POST["fio"];
			
			
			$sql='SELECT * FROM '.$ST['dbpf'].'_logs WHERE message LIKE "%'.$fio.'%" ORDER BY data_c DESC';
			$rez=$DB->QUR_SEL($sql);
			if($rez){
				foreach($rez as $key => $val)if($key){
					//проверяем является ли он преподавателем
					$part = explode("id:", $val['message']);
					$part = explode("-", $part[1]);
					
					$sql2 = 'SELECT * FROM '.$ST['dbpf'].'_teachers WHERE id_user = "'.$part[0].'" ';
					$rez2 = $DB->QUR_SEL($sql2);
					
					
					/***/
					if ($rez2) if ($rez2[0] > 0){
						$val['data_c'] = date('H:i:s d.m.Y',$val['data_c']);
						$val['message'] = stripslashes($val['message']);
						$logs[] = $val;
					}
				}
			}
		}
		//активные преподаватели
		$teachers = array();
		$sql = 'SELECT teach.*, us.* FROM '.$ST['dbpf'].'_teachers as teach, '.$ST['dbpf'].'_users as us WHERE NOT (teach.status = "-1") AND us.id = teach.id_user ';
		$rez = $DB->QUR_SEL($sql);
		if ($rez){
			foreach ($rez as $key => $val) if ($key){
				
				$teachers[] = $val;
			}
		}
		
		/*************/
		$smarty->assign('teachers',$teachers);
		$smarty->assign('logs',$logs);
		$smarty->assign('st_view',$st_view);
	}
	if($_GET['page']=='st39_7'){//активность преподавателей
		$kafedra = urldecode($_GET['des']);
		$st_view='st39_7'; 
		
		$teachers = array();
		
		//выводим список преподавателей
		$sql = 'SELECT us.*, teach.* FROM '.$ST['dbpf'].'_users as us, '.$ST['dbpf'].'_teachers as teach WHERE teach.id_user = us.id AND teach.kafedra = "Физического воспитания" ';
		$rez = $DB->QUR_SEL($sql);
		if ($rez){
			foreach ($rez as $key => $val) if ($key){
				$teachers[] = $val;
			}
		}
		
		//выводим список всех кафедр
		$kafedres = array();
		$sql = 'SELECT * FROM '.$ST['dbpf'].'_kafedres ORDER BY code';
		$rez = $DB->QUR_SEL($sql);
		if ($rez){
			foreach ($rez as $key => $val) if ($key){
				$kafedres[] = $val;
			}
		}
		
		
		$smarty->assign('kafedres',$kafedres);
		$smarty->assign('teacher',$teachers);
		$smarty->assign('st_view',$st_view);
	}
	
	if($_GET['page']=='st39_6'){//активность студентов группы
		$kafedra = urldecode($_GET['des']);
		$st_view='st39_6'; $grupp=array();
		
		//выбираем список групп
		$sql = 'SELECT * FROM '.$ST['dbpf'].'_grupp ORDER BY sokr,kurs';
		$rez=$DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$grupp[] = $val;
				//if($id==$val['id']) $out[$key]['active']=1;
			}
		}
		
		$smarty->assign('grupp',$grupp);
		$smarty->assign('st_view',$st_view);
	}
	if($_GET['page']=='st39_5'){//незарегистрирвоанные кафедры
		$st_view='st39_5'; $smarty->assign('st_view',$st_view);
		$prkaf = iup_check_kafedras();
		
		$kafs = array();
		foreach($prkaf as $key => $val){
			foreach($val['kafs'] as $key1 => $val1){
				if(!in_array($val['fio'],$kafs[$val1])){
					$tmp['fio']=$val['fio'];
					$tmp['check_learn']=check_fio_inlearn($val['fio']);
					
					$kafs[$val1][] = $tmp;
					
				}
			}
		}
		//echo '<pre>'.print_r($kafs,1).'</pre>'; 
		$smarty->assign('kafs',$kafs);
	}
	if($_GET['page']=='st39_4'){//активность кафедры
		$kafedra = urldecode($_GET['des']);
		$st_view='st39_4'; $users=array();
		$m1=array('Вошел пользователь');
		$m2=array('Вход');
		$sql = 'SELECT u.id as uid,u.fio,u.email,u.foto,t.* FROM '.$ST['dbpf'].'_teachers as t,'.$ST['dbpf'].'_users as u WHERE t.id_user=u.id AND t.kafedra="'.$kafedra.'" AND u.status>-1 AND t.status>-1 AND NOT (u.fio = "") ORDER BY u.fio ';
		if ($kafedra == "Политехнический колледж МГТУ") $sql = 'SELECT u.id as uid,u.fio,u.email,u.foto,t.* FROM '.$ST['dbpf'].'_teachers as t,'.$ST['dbpf'].'_users as u WHERE t.id_user=u.id AND t.kafedra="'.$kafedra.'" AND u.status>-1 AND t.status>-1 AND NOT (u.fio = "") ORDER BY u.fio LIMIT 15';
			
		//по умолчанию выводим логи за последние день
		//$date_start = date("U")-2*24*60*60;
		$date_start = mktime(0,0,0,date('m'),date('d')-2,date('Y'));
		$date_end = mktime(0,0,0,date('m'),date('d')+1,date('Y'));
		if ($kafedra == "Политехнический колледж МГТУ") {
			//$date_start = date("U")-1*24*60*60;
			$date_start = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
		}
		//echo date('H:i:s d.m.Y',$date_start);//23:03:38 24.04.2020
		//echo $sql;
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				//$sql1 = 'SELECT * FROM '.$ST['dbpf'].'_logs WHERE message LIKE "%'.$val['fio'].'%" ORDER BY data_c DESC';
				//$sql1 = 'SELECT * FROM '.$ST['dbpf'].'_logs WHERE message LIKE "%'.$val['fio'].'%" AND NOT (message LIKE "%Вход%") AND data_c >= '.$date_start.' ORDER BY data_c DESC';
				$sql1 = 'SELECT * FROM '.$ST['dbpf'].'_logs WHERE message LIKE "%'.$val['fio'].'%" AND data_c >= '.$date_start.' AND data_c <= '.$date_end.' ORDER BY data_c DESC';
				$rez1 = $DB->QUR_SEL($sql1);
				//echo $sql1.'<pre>'.print_r($rez1,1).'</pre>';
				if($rez1){
					foreach($rez1 as $key1 => $val1)if($key1){
						$val1['data_c'] = date('H:i <b>d.m.Y</b>',$val1['data_c']);
						$val1['message'] = str_replace($m1,$m2,$val1['message']);
						$val1['message'] = str_replace($val['fio'],'',$val1['message']);
						$val1['message'] = str_replace($val['uid'],'',$val1['message']);
						$val1['message'] = str_replace('id:','',$val1['message']);
						$val1['message'] = str_replace('-: ','',$val1['message']);
						$val1['message'] = str_replace(' :','',$val1['message']);
						$val['logs'][] = $val1;
					}
				}
				$users[] = $val;
			}
		}
		//echo '<pre>'.print_r($users,1).'</pre>';
		$smarty->assign('date_end',$date_end);
		$smarty->assign('date_start',$date_start);
		$smarty->assign('kafedra',$kafedra);
		$smarty->assign('users',$users);
		$smarty->assign('st_view',$st_view);
	}
	if($_GET['page']=='st39_3'){//список дисциплин по кафедрам
		$st_view='39_3';
		if(!in_array(39,$_SESSION['user']['statuses'])) {header('Location: https://eios.mkgtu.ru/'); exit();}
		$sem=1; if(isset($_GET['des'])) $sem=$_GET['des'];
		$kafedras=array();
		$sql = 'SELECT kafedra FROM '.$ST['dbpf'].'_teachers GROUP BY kafedra ORDER BY kafedra ';
		$rez = $DB->QUR_SEL($sql);
		if($rez){

			foreach($rez as $key => $val)if($key){
				//echo $val['kafedra'].' = '.count($val['kafedra']).'<br>';
				if(strlen($val['kafedra'])>1){
					$val['url'] = urlencode($val['kafedra']);
					//echo 'http://local.mkgtu.ru/calchour_2017/get_json.php?json=get_disciplins&kafedra='.$val['kafedra'].'&sem='.urlencode('7,8').'<br>';
					$val['disciplins'] = get_kafedra_disciplin($val['kafedra'],$sem);
					$kafedras[]=$val;
				}
			}
		}
		
		//делаем значения элементов массива уникальным
		//$kafedras = array_unique($kafedras);
		
		//echo '<pre>'.print_r($kafedras,1).'</pre>';
		$smarty->assign('sem',$sem);
		$smarty->assign('kafedras',$kafedras);
		$smarty->assign('st_view',$st_view);
	}
	if($_GET['page']=='st39_2'){//список студентов
		$st_view='39_2'; 
		$m1=array('(м)','(М)','(ИУП)','(я)');
		$m2=array('','','','');
		$g0=array(); $ngrupps=array(); $users=array();
		$sql = 'SELECT * FROM '.$ST['dbpf'].'_grupp ORDER BY sokr,kurs,fo';
		if(isset($_GET['des'])){
			if($_GET['des']=='print'){//печатаем группу
				$sql = 'SELECT * FROM '.$ST['dbpf'].'_grupp WHERE id='.(int)$_GET['id'].' ORDER BY sokr,kurs,fo';
			}
		}
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$ng = str_replace($m1,$m2,$val['sokr']);
				$tng = explode('(',$ng);
				$val['og']=trim($tng[0]);
				$g0[$val['id']]=$val;
			}
		}
		//TO DO: при печати тоже надо выбрать только нужных
		$sql = 'SELECT u.id as uid,u.fio,u.email,u.pass,u.data_u,s.id,s.id_grupp,s.num_zach,s.num_grupp FROM '.$ST['dbpf'].'_students as s,'.$ST['dbpf'].'_users as u WHERE u.id=s.id_user AND NOT(u.status = -1) ORDER BY s.num_grupp,u.fio';
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$val['data_u'] = date('H:i d.m.Y',$val['data_u']);
				if(isset($g0[$val['id_grupp']])){
					$g0[$val['id_grupp']]['students'][] = $val;
				}else{//нет такой группы
					$ngrupps[] = $val;
				}
			}
		}
		$print=0; $print0=0; $print1=0;
		if(isset($_GET['des'])){
			if($_GET['des']=='print') $print=1;
			if($_GET['des']=='print0') $print0=1;
			if($_GET['des']=='print1') $print1=1;
		}
		$grupps=array();
		foreach($CF['fak_kaf'] as $fak => $v){
			foreach($v as $grup => $kaf){
				foreach($g0 as $k1 => $v1){
					if($v1['og']==trim($grup)){
						
						$add=true;
						if($print1){
							if($_GET['dop']==$kaf) $add=true; else $add=false;
						}
						if($print0){
							if($_GET['dop']==$fak) $add=true; else $add=false;
						}
						
						if($add) $grupps[$fak][$kaf][]=$v1;
						unset($g0[$k1]);
					}
				}
			}
		}
		if($print){ $smarty->assign('print',1); }else $smarty->assign('print',0);
		if($print0){ $smarty->assign('print0',1); }else $smarty->assign('print0',0);
		if($print1){ $smarty->assign('print1',1); }else $smarty->assign('print1',0);
		
		/*$g0 = '';
		$ngrupps = '';*/
		
		
		$smarty->assign('st_view',$st_view);
		$smarty->assign('grupps',$grupps);//группы по факультетам и кафедрам
		$smarty->assign('g0',$g0);//группы не совпадающие по факультетам и кафедрам
		$smarty->assign('ngrupps',$ngrupps);//группы не совпадающие по группам
		$smarty->assign('fak_kaf',$CF['fak_kaf']);
		//echo '<pre>'.print_r($grupps,1).'</pre>'.$_GET['dop'];
		/*echo '<pre>'.print_r($grupps,1).'</pre>';
		echo '<pre>'.print_r($g0,1).'</pre>';*/
		if($print||$print0||$print1){//печатаем группу			
			$smarty->assign('time',date('H:i d.m.Y'));
			$smarty->display('tpl_statuses_grupp_print.html');
			exit();
		}
	}
	if($_GET['page']=='st39_1'){
		if(isset($_POST['link_kafs'])){
			//echo '<prE>'.print_r($_POST,1).'</pre>';
			foreach($_POST['kafs'] as $fio => $kaf)if($kaf!=''){
				$sql = 'SELECT t.id FROM '.$ST['dbpf'].'_users as u,'.$ST['dbpf'].'_teachers as t WHERE u.fio="'.$fio.'" AND t.id_user=u.id LIMIT 1';
				$rez = $DB->QUR_SEL($sql);
				if($rez){
					$sql = 'UPDATE '.$ST['dbpf'].'_teachers SET kafedra="'.$kaf.'" WHERE id='.$rez[1]['id'].' LIMIT 1';
					$rez = $DB->QUR($sql);
				}
			}
		}
		
		$kafs = iup_check_kafedras(); //echo '<prE>'.print_r($kafs,1).'</pre>';
		if(!in_array(39,$_SESSION['user']['statuses'])) {header('Location: http://learn-mkgtu.ru/'); exit();}
		$st_view='39_1'; $smarty->assign('st_view',$st_view);
		$sql = 'SELECT u.id as uid,u.fio,u.foto,t.* FROM '.$ST['dbpf'].'_teachers as t,'.$ST['dbpf'].'_users as u WHERE t.id_user=u.id ORDER BY u.fio';
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$val['data_u'] = date('H:i d.m.Y',$val['data_u']);
				$users[]=$val;
			}
		}
		$smarty->assign('kafs',$kafs); 
		$smarty->assign('users',$users);
	}
	if($_GET['page']=='st39'){//отображение кафедр
		$check=false; $whatshow=1;
		if(in_array(39,$_SESSION['user']['statuses'])) $check=true;//группа проверки
		
		if(in_array(21,$_SESSION['user']['statuses'])) $check=true;//зем. декана (добавлено по просьбе Кучинской)
		else{
			if(in_array(30,$_SESSION['user']['statuses'])) {//зав.кафедрой
				$check=true;
				if(!isset($_SESSION['user']['teacher']['kafedra'])||$_SESSION['user']['teacher']['kafedra']=='') $check=false;
				else {
					$whatshow=2;
					$_GET['des'] = $_SESSION['user']['teacher']['kafedra'];
				}
			}
		}
		if(!$check){header('Location: https://eios.mkgtu.ru/'); exit();}
		
		if(isset($_GET['des'])){//выберем всех преподавателей кафедры
			$kafedra = urldecode($_GET['des']);
			$st_view='st39_01'; $users=array();
			
			
			$sql = 'SELECT u.id as uid,u.fio,u.email,u.foto,t.*,t.id as id_teacher, u.data_u as date_active FROM '.$ST['dbpf'].'_teachers as t,'.$ST['dbpf'].'_users as u WHERE t.id_user=u.id AND t.kafedra="'.$kafedra.'" AND u.status>-1 ORDER BY u.fio';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				foreach($rez as $key => $val)if($key){
					$val['data_u'] = date('H:i d.m.Y',$val['date_active']);
					$file = 'tmp/get_info_prepod/_y2023__'.translit($val['fio']).'_'.$val['id'].'.json';
					
					
					if(!file_exists($file)){ //нужно связаться с расчетом часов и узнать
					//if(true){ //нужно связаться с расчетом часов и узнать
						//echo 'Файла: '.$file.' нет<br>';
						$url = 'http://local.mkgtu.ru/calchour_2023/get_json.php?json=get_info_prepod&fio='.urlencode($val['fio']).'';
						//echo $url.'<br>';  
						$json = file_get_contents($url);
						//echo $json;
						file_put_contents($file,$json);
					}else{
						//echo 'Файла: '.$file.' есть<br>';
						$json = file_get_contents($file);
					}
					$json = json_decode($json,1);
					$val['predmets']=array(); $val['issemestr']=array();
					
					//значения дублировались повторно - данная функция позволяет сделать массив уникальным по значениям определенного ключа
					$json['db'] = getUniqueArray('id_ucheb_plan', $json['db']);
					foreach($json['db'] as $k => $v){
						$show=true;
						foreach($nopredm as $k1 => $v1) if(strpos($v['name_disp'],$v1)!==false) $show=false;
						if($show){
							$z=array();
							$z['name_disp']=$v['name_disp'];
							$z['name_disp'] = trim(preg_replace('/[\t\n\r\s]+/', ' ', $z['name_disp']));
							$z['lekcii']=$v['lekcii'];
							$z['prakt_sem_zan']=$v['prakt_sem_zan'];
							$z['lab_zan']=$v['lab_zan'];
							$z['kr']=$v['kr'];
							$z['kur']=$v['kur'];
							$z['kup']=$v['kup'];
							$z['uch_pr']=$v['uch_pr'];
							$z['uch_pr_p']=$v['uch_pr_p'];
							$z['proizv_pr']=$v['proizv_pr'];
							$z['preddip_pr']=$v['preddip_pr'];
							$z['spec']=$v['spec'];
							$z['kurs']=$v['kurs'];
							$z['semestr']=$v['semestr'];
							$z['fo']=$v['fo'];
							//if($val['uid']==7102) { echo $val['uid'].'='.$val['id'].'<br>';  }
							//$z['statuses'] = check_material_rc($val['uid'],$val['id'],$z); //ДЛЯ СТАРЫХ ПРОВЕРОК ТОЛЬКО
							
							//--------------------------------------------------
							$z['id'] = $v['id'];
							$z['id_ucheb_plan'] = $v['id_ucheb_plan'];
							$id_u_p = $v['id_ucheb_plan'];
							
							//находим айдишник предмета, с которым нужно работать
							$name_disp = $v['name_disp'];
							$name_disp = trim(preg_replace('/[\t\n\r\s]+/', ' ', $name_disp));
							
							$kurs_pr = $v['kurs'];
							$semestr_pr = $v['semestr'];
							$sql3 = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE `name` = "'.$name_disp.'" AND `kurs` = '.$kurs_pr.' AND `semestr` = '.$semestr_pr.' ORDER BY `id` DESC';
							//$sql3 = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE `name` = "'.$name_disp.'" ';

							$rez3 = $DB->QUR_SEL($sql3);
							if ($rez3) $id_what = $rez3[1]['id'];
							else $id_what = 0;
							$z['id_what'] = $id_what;
							//*********
							
							//echo $v['name_disp'];
							//ТАКЖЕ ПОДГРУЖАЕМ ВЕСЬ УЧЕБНЫЙ МАТЕРИАЛ ДАННОГО ПРЕПОДАВАТЕЛЯ - ЧТОБЫ СРАВНИВАТЬ
							$z['myLection'] = get_lection_teacher($val['id_teacher'], $name_disp, $v['kurs'], $v['semestr']);
							//$z['myLection'] = get_lection_teacher($val['id_teacher'], $v['name_disp'], $v['kurs'], $v['semestr']);
							$z['rabProgram'] = get_lection_teacher($val['id_teacher'], $name_disp, $v['kurs'], $v['semestr'], 1);
							//$z['rabProgram'] = get_lection_teacher($val['id_teacher'], $v['name_disp'], $v['kurs'], $v['semestr'], 1);
							//echo '<pre>'; print_r($z['myLection']); echo '</pre>'; //exit;
							
							
							//*****/
							$val['predmets'][]=$z;

							 if(!in_array($v['semestr'],$val['issemestr'])) $val['issemestr'][]=$v['semestr'];
						}
					}
					sort($val['issemestr']);
					//if($val['uid']==7102) { echo '<pre>'.print_r($json['db'],1).'</pre>'; echo '<pre>'.print_r($val,1).'</pre>'; exit();  }
					$users[]=$val;
				}
				//echo '<pre>'.print_r($users,1).'</pre>';
			}
			$smarty->assign('users',$users);
			$smarty->assign('whatshow',$whatshow);
			$smarty->assign('kafedra',$kafedra);
		}
		else{//выберем все кафедры
			$st_view='st39'; $kafedras=array();
			$sql = 'SELECT kafedra FROM '.$ST['dbpf'].'_teachers GROUP BY kafedra ORDER BY kafedra';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				foreach($rez as $key => $val)if($key){
					//echo $val['kafedra'].' = '.count($val['kafedra']).'<br>';
					if(strlen($val['kafedra'])>1){
						$val['url'] = urlencode($val['kafedra']);
						$kafedras[]=$val;
					}
				}
			}
			$smarty->assign('kafedras',$kafedras);
		}
		$smarty->assign('st_view',$st_view);
	}
	if($_GET['page']=='st39_0'){//отображение всех преподавателей
		if(!in_array(39,$_SESSION['user']['statuses'])) {header('Location: http://learn-mkgtu.ru/'); exit();}
		$st_view='st39_0'; $users=array();
		// здесь лучше добавить выбор кафедры!
		
		$nopredm=array('РВКР','РИМ ','ЗДН ','ОЛ','РИН','ГЭЗ','ЗВКР','РАД ','ЗДВ ','ЗДО');
		//выберем всех преподавателей 
		$sql = 'SELECT u.id as uid,u.fio,u.foto,t.* FROM '.$ST['dbpf'].'_teachers as t,'.$ST['dbpf'].'_users as u WHERE t.id_user=u.id ORDER BY u.fio';
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$val['data_u'] = date('H:i d.m.Y',$val['data_u']);
				$users[]=$val;
			}
		}
		$smarty->assign('st_view',$st_view);
		$smarty->assign('users',$users);
	}
	
	$smarty->assign('user',$_SESSION['user']);
	$maincontent = $smarty->fetch('tpl_statuses.html');
}

function check_fio_inlearn($fio){
	GLOBAL $ST,$DB; $out=array();
	$sql = 'SELECT * FROM '.$ST['dbpf'].'_users WHERE fio="'.$fio.'"';
	$rez = $DB->QUR_SEL($sql);
	if($rez){
		$out['msg']='';
		foreach($rez as $key => $val)if($key){
			$tmp['id'] = $val['id'];
			$tmp['email'] = $val['email'];
			//$rez1 = $DB->QUR_SEL('SELECT * FROM '.$ST['dbpf'].'_teachers WHERE id_user='.$val['id'].'');
			$rez1 = $DB->QUR_SEL('SELECT * FROM '.$ST['dbpf'].'_teachers WHERE id_user='.$val['id'].' AND `status` = -1 ');
			if($rez1) $tmp['teacher'] = $rez1[1]; else $tmp['teacher'] = array(); 
			$out['users'][]=$tmp;
		}
	}else{
		$out['msg']='Точного совпадения нет! Выберем Фамилию и имя';
		$t=explode(' ',$fio); unset($t[count($t)-1]);
		$sql = 'SELECT * FROM '.$ST['dbpf'].'_users WHERE fio LIKE "%'.implode(' ',$t).'%"';
		//$out['msg'].=$sql;
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$tmp['id'] = $val['id'];
				$tmp['email'] = $val['email'];
				//$rez1 = $DB->QUR_SEL('SELECT * FROM '.$ST['dbpf'].'_teachers WHERE id_user='.$val['id'].'');
				$rez1 = $DB->QUR_SEL('SELECT * FROM '.$ST['dbpf'].'_teachers WHERE id_user='.$val['id'].' AND `status` = -1');
				if($rez1) $tmp['teacher'] = $rez1[1]; else $tmp['teacher'] = array(); 
				$out['users'][]=$tmp;
			}
		}else{
			$out['msg']='Совпадения по Фамилии и имени нет!';
		}
	}
	return $out;
}
function check_material($t,$mat,$grups,$jarr){//проверка что загрузил в расчете часов
	$out = array(); $out['html']='';//'<pre>'.print_r($mat,1).''.print_r($grups,1).''.print_r($jarr['db'],1).'</pre>';
	//$mat['kurs'] $mat['semestr'] $mat['name']
	//$grups[]=array('sokr'=>$rez[1]['sokr'],'kurs'=>$rez[1]['kurs'],'fo'=>$rez[1]['fo']);
	$txt=''; $all=count($grups); $proc=0;
	foreach($jarr['db'] as $key => $val){
		if($t=='lection'){
			if($val['lekcii']!=0){
				if($val['name_disp']==$mat['name']){
					$g=0; $gn=''; //$proc+=100/$all;
					foreach($grups as $k => $v){
						if($val['spec']==$v['sokr']&&$val['kurs']==$v['kurs']&&$val['fo']==$v['fo']){
							$g=1;
							$gn=$v['sokr'].'-'.$val['kurs'].' '.$val['fo'];
							$proc+=(100/$all)/$all;
						}
					}
					if($g) $txt.='Дисциплина '.$gn.' OK; '."\n";
				}
			}
		}
		if($t=='practich'){
			if($val['prakt_sem_zan']!=0){
				if($val['name_disp']==$mat['name']){
					$g=0; $gn=''; //$proc+=100/$all;
					foreach($grups as $k => $v){
						if($val['spec']==$v['sokr']&&$val['kurs']==$v['kurs']&&$val['fo']==$v['fo']){
							$g=1;
							$gn=$v['sokr'].'-'.$val['kurs'].' '.$val['fo'];
							$proc+=(100/$all)/$all;
						}
					}
					if($g) $txt.='Дисциплина '.$gn.' OK; '."\n";
				}
			}
		}
		if($t=='controln'){
			if($val['kr']!=0){
				if($val['name_disp']==$mat['name']){
					$g=0; $gn=''; //$proc+=100/$all;
					foreach($grups as $k => $v){
						if($val['spec']==$v['sokr']&&$val['kurs']==$v['kurs']&&$val['fo']==$v['fo']){
							$g=1;
							$gn=$v['sokr'].'-'.$val['kurs'].' '.$val['fo'];
							$proc+=(100/$all)/$all;
						}
					}
					if($g) $txt.='Дисциплина '.$gn.' OK; '."\n";
				}
			}
		}
		if($t=='kursov'){
			if($val['kur']!=0||$val['kup']!=0){
				if($val['name_disp']==$mat['name']){
					$g=0; $gn=''; //$proc+=100/$all;
					foreach($grups as $k => $v){
						if($val['spec']==$v['sokr']&&$val['kurs']==$v['kurs']&&$val['fo']==$v['fo']){
							$g=1;
							$gn=$v['sokr'].'-'.$val['kurs'].' '.$val['fo'];
							$proc+=(100/$all)/$all;
						}
					}
					if($g) $txt.='Дисциплина '.$gn.' OK; '."\n";
				}
			}
		}
		if($t=='praktika'){
			if($val['uch_pr']!=0||$val['uch_pr_p']!=0||$val['proizv_pr']!=0||$val['preddip_pr']!=0){
				if($val['name_disp']==$mat['name']){
					$g=0; $gn=''; //$proc+=100/$all;
					foreach($grups as $k => $v){
						if($val['spec']==$v['sokr']&&$val['kurs']==$v['kurs']&&$val['fo']==$v['fo']){
							$g=1;
							$gn=$v['sokr'].'-'.$val['kurs'].' '.$val['fo'];
							$proc+=(100/$all)/$all;
						}
					}
					if($g) $txt.='Дисциплина '.$gn.' OK; '."\n";
				}
			}
		}
		
	}
	$out['all'] =$all;
	$out['proc']=$proc;
	if($proc==0) 			$out['color']='#b94a48';
	if($proc>0&&$proc<50) 	$out['color']='#c48a62';
	if($proc==50) 			$out['color']='#c4bb62';
	if($proc>50&&$proc<100) $out['color']='#9fc462';
	if($proc==100) 			$out['color']='#62c462';
	if($proc>100) 			$out['color']='#00a900';
	$out['html'].=''.$txt.'';
	$out['div']='<div class="tooltips" data-trigger="hover" data-placement="bottom" data-original-title="'.$out['html'].'" style="position: absolute;right: 0px;top: 0px;background-color:'.$out['color'].';padding:2px;">'.$out['proc'].'</div>';//.'<pre>'.print_r($mat,1).''.print_r($grups,1).''.print_r($jarr['db'],1).'</pre>';
	return $out;
}

//здесь добавлял еще семестр но пришлось убрать(((
function check_material_rc($id_user,$id_teacher,$z){//проверка по расчете часов планам выбираем то что загруид в леарн
	GLOBAL $ST,$DB; $out=array();
	
	if ($z['fo'] == 'оч') $z['fo'] = 'ОФО';
	elseif ($z['fo'] == 'заоч') $z['fo'] = 'ЗФО';
	else $z['fo'] = 'ОЗФО';
	
	//if ($id_teacher == 304) { echo '<pre>'; print_r ($z); echo '</pre>';}
	
	$out['lection']=0; $out['controln']=0; $out['kursov']=0; $out['praktika']=0;
	$out['practich']=0; //0 - нет практических и групп, 1 - нет практических, 2 - есть все
	if($z['lekcii']!=0){//lection
		$out['lection']=0;
		//$sql = 'SELECT id FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$id_teacher.' AND name="'.$z['name_disp'].'" AND kurs='.$z['kurs'];//.' AND semestr='.$z['semestr'].''
		$sql = 'SELECT id FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$id_teacher.' AND name="'.$z['name_disp'].'" AND type="лек" AND kurs='.$z['kurs'];//.' AND semestr='.$z['semestr'].''
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$out['lection']=1;
				$sql1 = 'SELECT g.* FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$val['id'].' AND lg.id_grupp=g.id AND g.sokr="'.$z['spec'].'" AND g.kurs="'.$z['kurs'].'" AND g.fo="'.$z['fo'].'"';
				$rez1 = $DB->QUR_SEL($sql1);
				//echo $sql1.':<pre>'.print_r($rez1,1).'</pre>';
				//$out['lection_rez'][]=$rez1;
				//$out['lection_kol']++;
				if($rez1!=''){
					foreach($rez1 as $key1 => $val1)if($key1){
						$out['lection']=2;
					}
				}
			}
		}
	}
	
	if($z['prakt_sem_zan']!=0||$z['lab_zan']!=0){//practich
		

		//NEW SPOSOB
		$sql = 'SELECT * FROM '.$ST['dbpf'].'_grupp WHERE sokr LIKE "%'.$z['spec'].'-'.$z['kurs'].'%" AND fo = "'.$z['fo'].'"';
		
		
		//if ($id_teacher == 304) echo $sql.';<br />';
		$rez = $DB->QUR_SEL($sql);
		if ($rez){
			foreach ($rez as $key => $val) if ($key){
				//$out['practich'] = 1;
				$sql1 = 'SELECT lec.*,lg.* FROM '.$ST['dbpf'].'_lections as lec, '.$ST['dbpf'].'_lections_grupp as lg WHERE lec.id = lg.id_lections AND lg.id_grupp = "'.$val['id'].'" AND lec.name="'.$z['name_disp'].'" AND lec.type="лаб"  AND lec.kurs="'.$z['kurs'].'" AND lec.semestr="'.$z['semestr'].'" ';
				//$sql1 = 'SELECT lec.* FROM '.$ST['dbpf'].'_lections as lec, '.$ST['dbpf'].'_lections_grupp as lg WHERE lec.id_teacher='.$id_teacher.' AND lec.id = lg.id_lections AND lg.id_grupp = "'.$val['id'].'" AND lec.name="'.$z['name_disp'].'" AND lec.type = "лаб" AND lec.kurs="'.$z['kurs'].'" AND lec.semestr="'.$z['semestr'].'"'; 
				//$sql1 = 'SELECT lec.* FROM '.$ST['dbpf'].'_lections as lec, '.$ST['dbpf'].'_lections_grupp as lg WHERE lec.id_teacher='.$id_teacher.' AND lec.id = lg.id_lections AND lg.id_grupp = "'.$val['id'].'" AND lec.name="'.$z['name_disp'].'" AND lec.type = "лаб" ';
				
				//if ($id_teacher == 304) echo $sql1.';<br />';
				
				$rez1 = $DB->QUR_SEL($sql1);
				//print_r($rez1);
				foreach ($rez1 as $key1 => $val1) if ($key1) {

					$out['practich'] = 2; break;
					
				}
				//if ($id_teacher == 304) echo $out['practich'].'<br />';
				//if ($out['practich'] == 2) break; //если все отлично в одном случае, то дальше можно не проверять
			}
		}
		
		//if ($id_teacher == 304) echo $out['practich'];
		
		//СТАРЫЙ СПОСОБ
		//$sql = 'SELECT l.id FROM '.$ST['dbpf'].'_lections as l,'.$ST['dbpf'].'_practich as p WHERE l.id_teacher='.$id_teacher.' AND l.name="'.$z['name_disp'].'" AND l.kurs='.$z['kurs'].' AND p.id_lection=l.id';// AND l.semestr='.$z['semestr'].'
		/*$sql = 'SELECT id FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$id_teacher.' AND name="'.$z['name_disp'].'" AND type="лаб" AND kurs='.$z['kurs'].' AND semestr = '.$z['semestr'].' GROUP BY id';
		if ($id_teacher == 297) echo $sql.';<br />';
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$out['practich']=1;
				//$sql1 = 'SELECT g.* FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$val['id'].' AND lg.id_grupp=g.id AND g.sokr="'.$z['spec'].'" AND g.kurs="'.$z['kurs'].'" AND g.fo="'.$z['fo'].'"';
				//$sql1 = 'SELECT g.* FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$val['id'].' AND lg.id_grupp=g.id AND g.sokr LIKE "'.$z['spec'].'-'.$z['kurs'].'%" AND g.fo="'.$z['fo'].'" ';
				$sql1 = 'SELECT g.* FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$val['id'].' AND lg.id_grupp=g.id AND g.sokr LIKE "'.$z['spec'].'-'.$z['kurs'].'%" AND g.fo="'.$z['fo'].'" ';
				
				
				if ($id_teacher == 297) echo $sql1.';<br />';
				$rez1 = $DB->QUR_SEL($sql1);
				if($rez1){
					foreach($rez1 as $key1 => $val1)if($key1){
						$out['practich']=2;
					}
				}
			}
		}*/
	}
	if($z['kr']!=0){//controln
		$out['controln']=0;
		//$sql = 'SELECT l.id FROM '.$ST['dbpf'].'_lections as l,'.$ST['dbpf'].'_controln as p WHERE l.id_teacher='.$id_teacher.' AND l.name="'.$z['name_disp'].'" AND l.kurs='.$z['kurs'].' AND p.id_lection=l.id';// AND l.semestr='.$z['semestr'].'
		$sql = 'SELECT id FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$id_teacher.' AND name="'.$z['name_disp'].'" AND type="контр" AND kurs='.$z['kurs'];
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$out['controln']=1;
				$sql1 = 'SELECT g.* FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$val['id'].' AND lg.id_grupp=g.id AND g.sokr="'.$z['spec'].'" AND g.kurs="'.$z['kurs'].'" AND g.fo="'.$z['fo'].'"';
				$rez1 = $DB->QUR_SEL($sql1);
				if($rez1){
					foreach($rez1 as $key1 => $val1)if($key1){
						$out['controln']=2;
					}
				}
			}
		}
	}
	if($z['kur']!=0||$z['kup']!=0){//kursov
		$out['kursov']=0;
		//$sql = 'SELECT l.id FROM '.$ST['dbpf'].'_lections as l,'.$ST['dbpf'].'_kursov as p WHERE l.id_teacher='.$id_teacher.' AND l.name="'.$z['name_disp'].'" AND l.kurs='.$z['kurs'].' AND p.id_lection=l.id';// AND l.semestr='.$z['semestr'].'
		$sql = 'SELECT id FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$id_teacher.' AND name="'.$z['name_disp'].'" AND type="курс" AND kurs='.$z['kurs'];
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$out['kursov']=1;
				$sql1 = 'SELECT g.* FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$val['id'].' AND lg.id_grupp=g.id AND g.sokr="'.$z['spec'].'" AND g.kurs="'.$z['kurs'].'" AND g.fo="'.$z['fo'].'"';
				$rez1 = $DB->QUR_SEL($sql1);
				if($rez1){
					foreach($rez1 as $key1 => $val1)if($key1){
						$out['kursov']=2;
					}
				}
			}
		}
	}
	if($z['uch_pr']!=0||$z['uch_pr_p']!=0||$z['proizv_pr']!=0||$z['preddip_pr']!=0){//praktika
		$out['praktika']=0;
		//$sql = 'SELECT l.id FROM '.$ST['dbpf'].'_lections as l,'.$ST['dbpf'].'_praktika as p WHERE l.id_teacher='.$id_teacher.' AND l.name="'.$z['name_disp'].'" AND l.kurs='.$z['kurs'].' AND p.id_lection=l.id';// AND l.semestr='.$z['semestr'].'
		$sql = 'SELECT id FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$id_teacher.' AND name="'.$z['name_disp'].'" AND type="практика" AND kurs='.$z['kurs'];
		$rez = $DB->QUR_SEL($sql);
		if($rez){
			foreach($rez as $key => $val)if($key){
				$out['praktika']=1;
				$sql1 = 'SELECT g.* FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$val['id'].' AND lg.id_grupp=g.id AND g.sokr="'.$z['spec'].'" AND g.kurs="'.$z['kurs'].'" AND g.fo="'.$z['fo'].'"';
				$rez1 = $DB->QUR_SEL($sql1);
				if($rez1){
					foreach($rez1 as $key1 => $val1)if($key1){
						$out['praktika']=2;
					}
				}
			}
		}
	}
	return $out;
}
function prepod_check_status($json,$tid,$what=''){//получение аякс данных по разделам
	GLOBAL $ST,$DB;
	$out='';//'<pre>'.print_r(json_decode($json,1),1).'</pre>'; 
	$jarr = json_decode($json,1);
	if($what=='workprogram'){
	//выберем у препода все рабочие программы
	$sql = 'SELECT * FROM '.$ST['dbpf'].'_workprogram WHERE id_teacher='.$tid.'';
	$rez = $DB->QUR_SEL($sql);//$out.=$sql.'<pre>'.print_r($rez,1).'</pre>';
	if($rez){
		$out .= '<table class="table">';
		$out .= '<thead><tr>
			<th width="40%">Рабочая программа</th>
			<th width="10%">Обновлена</th>
			<th width="30%">Специальность</th>
			<th width="10%">Семестры</th>
			<th width="10%">Файл</th>
		</tr></thead><tbody>';
		foreach($rez as $key => $val)if($key){
			$ksf='';$ksfa=array(); $ksfa['och']=''; $ksfa['zao']='';
			/*$kursy=explode('|',$val['kurs']);
			$semey=explode('|',$val['semestr']);
			$foy=explode('|',$val['fo']);
			$t=explode(',',$kursy[0]); foreach($t[0] as $k => $v){ if ($v!=0) $ksfa['och'][($k+1)]=1; }
			$t=explode(',',$kursy[1]); foreach($t[1] as $k => $v){ if ($v!=0) $ksfa['zao'][($k+1)]=1; }
			$t=explode(',',$semey[0]); foreach($t[0] as $k => $v){ if ($v!=0) $ksfa['och'][($k+1)]=1; }
			$t=explode(',',$semey[1]); foreach($t[1] as $k => $v){ if ($v!=0) $ksfa['zao'][($k+1)]=1; }*/
			$semey=explode('|',$val['semestr']);
			$t=explode(',',$semey[0]); foreach($t as $k => $v){ if ($v!=0) $ksfa['och'].=($k+1).','; }
			if(isset($semey[1])){
				$t=explode(',',$semey[1]); foreach($t as $k => $v){ if ($v!=0) $ksfa['zao'].=($k+1).','; }
			}
			if($ksfa['och']!='') $ksf .= 'ОФО: '.$ksfa['och'];
			if($ksfa['zao']!='') { if($ksfa['och']!='') $ksf.='<br>'; $ksf .= 'ЗФО: '.$ksfa['zao']; }
			
			$out .= '<tr>';
			$out .= '<td><span class="tooltips" data-trigger="hover" data-placement="bottom" data-original-title="'.$val['descrip'].'">'.$val['name'].'</span></td>';
			$out .= '<td>'.date('d.m.Y',$val['data_u']).'</td>';
			$out .= '<td>'.$val['specialnost'].'</td>';
			$out .= '<td>'.$ksf.'</td>';
			$out .= '<td><a href="/upload/workprogram/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			$out .= '</tr>';
		}
		$out .= '</tbody></table>';
	}
	}
	if($what=='lections'){
	//выберем у препода все лекции
	//$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$tid.''; //СТАРЫЙ ФОРМАТ
	$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$tid.' AND type="лек"';
	$rez = $DB->QUR_SEL($sql);//$out.=$sql.'<pre>'.print_r($rez,1).'</pre>';
	if($rez){
		$out .= '<table class="table">';
		$out .= '<thead><tr>
			<th width="40%">Лекция</th>
			<th width="10%">Обновлена</th>
			<th width="30%">Специальность</th>
			<th width="10%">Семестры</th>
			<th width="10%">Файл</th>
		</tr></thead><tbody>';
		foreach($rez as $key => $val)if($key){
			//также смотрим, есть ли выставленные оценки ЗА МОДУЛИ
			//$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_prepod="'.$tid.'" AND id_what = "'.$val['id'].'" AND what="лек" LIMIT 3';
			$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_what = "'.$val['id'].'" AND type=1  LIMIT 3';
			$rez_mark = $DB->QUR_SEL($sql_mark);
			if ($rez_mark[0] > 0) $isMark = '<i class="icon-plus" style="color: green;"> </i>'; else $isMark = '<i class="icon-minus" style="color: red;"> </i>';
			
			
			/****/
			$ksf= ' к.'.$val['kurs'].' c.'.$val['semestr'];
			$gmg = get_mat_grupps($val['id'],1);
			$status = check_material('lection',$val,$gmg['masi'],$jarr);
			$out .= '<tr>';
			$out .= '<td style="position: relative;">
				<span class="tooltips" data-trigger="hover" data-placement="bottom" data-original-title="'.$val['descrip'].'">'.$val['name'].' '.$isMark.'</span>';
				$out .= $status['div'];
				$out .= '<br>'.$gmg['html'].'
			</td>';
			$out .= '<td>'.date('d.m.Y',$val['data_u']).'</td>';  
			$out .= '<td>'.$val['specialnost'].'</td>';
			$out .= '<td>'.$ksf.'</td>';
			$df=explode('|',$val['file']);
			$out .= '<td>';
			foreach($df as $k => $v) $out .= ($k+1).'. <a href="/upload/lections/'.$v.'" target="_blank">Скачать</a>; ';
			/*foreach($df as $k => $v) if (strpos($v, "https://eios.mkgtu.ru/") !== false) $out .= ($k+1).'. <a href="/upload/lections/'.$v.'" target="_blank">Скачать</a>; '; else $out .= ($k+1).'. <a href="'.$v.'" target="_blank">Скачать</a>; ';*/ 
			
			$out .= '</td>';
			$out .= '</tr>';
		}
		$out .= '</tbody></table>';
	}
	}
	if($what=='practich'){
	//выберем у препода все практические
	//$sql = 'SELECT * FROM '.$ST['dbpf'].'_practich WHERE id_teacher='.$tid.'';
	$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$tid.' AND type="лаб"';
	$rez = $DB->QUR_SEL($sql);
	if($rez){
		$out .= '<table class="table">';
		$out .= '<thead><tr>
			<th width="40%">Практическая</th>
			<th width="10%">Обновлена</th>
			<th width="30%">Семестры</th>
			<th width="20%">Файл</th>
		</tr></thead><tbody>';
		foreach($rez as $key => $val)if($key){
			//также смотрим, есть ли выставленные оценки ЗА МОДУЛИ
			//$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_prepod="'.$tid.'" AND id_what = "'.$val['id'].'" AND what="лек" LIMIT 3';
			$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_what = "'.$val['id'].'" AND type=1  LIMIT 3';
			$rez_mark = $DB->QUR_SEL($sql_mark);
			if ($rez_mark[0] > 0) $isMark = '<i class="icon-plus" style="color: green;"> </i>'; else $isMark = '<i class="icon-minus" style="color: red;"> </i>';
			
			/***/
			$ksf= ' к.'.$val['kurs'].' c.'.$val['semestr'];
			//$gmg = get_mat_grupps($val['id_lection']);
			$gmg = get_mat_grupps($val['id'],1);
			$status = check_material('practich',$val,$gmg['masi'],$jarr);
			$out .= '<tr>';
			$out .= '<td style="position: relative;"><span class="tooltips" data-trigger="hover" data-placement="bottom" data-original-title="'.$val['descrip'].'">'.$val['name'].' '.$isMark.'</span>';
				$out .= $status['div'];
				$out .= '<br>'.$gmg['html'].'</td>';
			$out .= '<td>'.date('d.m.Y',$val['data_u']).'</td>';
			$out .= '<td>'.$ksf.'</td>';
			if (strpos($val['file'], "https://eios.mkgtu.ru/") !== false) $out .= '<td><a href="'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';  else $out .= '<td><a href="/upload/lections/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			$out .= '</tr>';
		}
		$out .= '</tbody></table>';
	}
	}
	if($what=='controln'){
	//выберем у препода все контрольные
	//$sql = 'SELECT * FROM '.$ST['dbpf'].'_controln WHERE id_teacher='.$tid.'';
	$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$tid.' AND type="контр"';
	$rez = $DB->QUR_SEL($sql);
	if($rez){
		$out .= '<table class="table">';
		$out .= '<thead><tr>
			<th width="40%">Контрольная</th>
			<th width="10%">Обновлена</th>
			<th width="50%">Файл</th>
		</tr></thead><tbody>';
		foreach($rez as $key => $val)if($key){
			//также смотрим, есть ли выставленные оценки ЗА МОДУЛИ
			//$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_prepod="'.$tid.'" AND id_what = "'.$val['id'].'" AND what="лек" LIMIT 3';
			$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_what = "'.$val['id'].'" AND type=1  LIMIT 3';
			$rez_mark = $DB->QUR_SEL($sql_mark);
			if ($rez_mark[0] > 0) $isMark = '<i class="icon-plus" style="color: green;"> </i>'; else $isMark = '<i class="icon-minus" style="color: red;"> </i>';
			
			
			/***/
			//$gmg = get_mat_grupps($val['id_lection']);
			$gmg = get_mat_grupps($val['id'],1);
			$status = check_material('controln',$val,$gmg['masi'],$jarr);
			$out .= '<tr>';
			$out .= '<td style="position: relative;"><span class="tooltips" data-trigger="hover" data-placement="bottom" data-original-title="'.$val['descrip'].'">'.$val['name'].' '.$isMark.'</span>';
				$out .= $status['div'];
				$out .= '<br>'.$gmg['html'].'</td>';
			$out .= '<td>'.date('d.m.Y',$val['data_u']).'</td>';
			//$out .= '<td><a href="/upload/controln/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			if (strpos($val['file'], "https://eios.mkgtu.ru/") !== false) $out .= '<td><a href="'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';  else $out .= '<td><a href="/upload/lections/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			$out .= '</tr>';
		}
		$out .= '</tbody></table>';
	}
	}
	if($what=='kursov'){
	//выберем у препода все курсовые
	//$sql = 'SELECT * FROM '.$ST['dbpf'].'_kursov WHERE id_teacher='.$tid.'';
	$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$tid.' AND type="курс"';
	$rez = $DB->QUR_SEL($sql);
	if($rez){
		$out .= '<table class="table">';
		$out .= '<thead><tr>
			<th width="40%">Курсовая</th>
			<th width="10%">Обновлена</th>
			<th width="50%">Файл</th>
		</tr></thead><tbody>';
		foreach($rez as $key => $val)if($key){
			//также смотрим, есть ли выставленные оценки ЗА МОДУЛИ
			//$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_prepod="'.$tid.'" AND id_what = "'.$val['id'].'" AND what="лек" LIMIT 3';
			$sql_mark = 'SELECT * FROM '.$ST['dbpf'].'_ocenki WHERE id_what = "'.$val['id'].'" AND type=1  LIMIT 3';
			$rez_mark = $DB->QUR_SEL($sql_mark);
			if ($rez_mark[0] > 0) $isMark = '<i class="icon-plus" style="color: green;"> </i>'; else $isMark = '<i class="icon-minus" style="color: red;"> </i>';
			
			
			//$gmg = get_mat_grupps($val['id_lection']);
			$gmg = get_mat_grupps($val['id'],1);
			$status = check_material('kursov',$val,$gmg['masi'],$jarr);
			$out .= '<tr>';
			$out .= '<td style="position: relative;"><span class="tooltips" data-trigger="hover" data-placement="bottom" data-original-title="'.$val['descrip'].'">'.$val['name'].' '.$isMark.'</span>';
				$out .= $status['div'];
				$out .= '<br>'.$gmg['html'].'</td>';
			$out .= '<td>'.date('d.m.Y',$val['data_u']).'</td>';
			//$out .= '<td><a href="/upload/kursov/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			if (strpos($val['file'], "https://eios.mkgtu.ru/") !== false) $out .= '<td><a href="'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';  else $out .= '<td><a href="/upload/lections/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			$out .= '</tr>';
		}
		$out .= '</tbody></table>';
	}
	}
	if($what=='praktika'){
	//выберем у препода все Пркатики
	//$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE id_teacher='.$tid.'';
	$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE id_teacher='.$tid.' AND type="практика"';
	$rez = $DB->QUR_SEL($sql);
	if($rez){
		$out .= '<table class="table">';
		$out .= '<thead><tr>
			<th width="40%">Практика</th>
			<th width="10%">Обновлена</th>
			<th width="50%">Файл</th>
		</tr></thead><tbody>';
		foreach($rez as $key => $val)if($key){
			//$gmg = get_mat_grupps($val['id_lection']);
			$gmg = get_mat_grupps($val['id'],1);
			$status = check_material('praktika',$val,$gmg['masi'],$jarr);
			$out .= '<tr>';
			$out .= '<td style="position: relative;"><span class="tooltips" data-trigger="hover" data-placement="bottom" data-original-title="'.$val['descrip'].'">'.$val['name'].'</span>';
				$out .= $status['div'];
				$out .= '<br>'.$gmg['html'].'</td>';
			$out .= '<td>'.date('d.m.Y',$val['data_u']).'</td>';
			//$out .= '<td><a href="/upload/praktika/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			if (strpos($val['file'], "https://eios.mkgtu.ru/") !== false) $out .= '<td><a href="'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';  else $out .= '<td><a href="/upload/lections/'.$val['file'].'" target="_blank">'.$val['file'].'</a></td>';
			$out .= '</tr>';
		}
		$out .= '</tbody></table>';
	}
	}
	$out .= '<script>$(document).ready(function(){
		$(".tooltips").tooltip();
	});</script>';
	/*
	$predmets=array();
	$arr = json_decode($json,1);
	$nopredm=array('РВКР','РИМ ','ЗДН ','ОЛ','РИН','ГЭЗ','ЗВКР','РАД ','ЗДВ ','ЗДО');
	foreach($arr['db'] as $k => $v){
		$show=true;
		foreach($nopredm as $k1 => $v1) if(strpos($v['name_disp'],$v1)!==false) $show=false;
		if($show){
			$z=array();
			$z['lekcii']=$v['lekcii'];
			$z['prakt_sem_zan']=$v['prakt_sem_zan'];
			$z['lab_zan']=$v['lab_zan'];
			$z['kr']=$v['kr'];
			$z['kur']=$v['kur'];
			$z['kup']=$v['kup'];
			$z['uch_pr']=$v['uch_pr'];
			$z['uch_pr_p']=$v['uch_pr_p'];
			$z['proizv_pr']=$v['proizv_pr'];
			$z['preddip_pr']=$v['preddip_pr'];
			$predmets[$v['name_disp']]['rc']=$z;
		}
	}
	*/
	/*
	foreach($predmets as $predmet => $v){//надо проверить материалы у препода
		if($v['rc']['lekcii']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['lection'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['lection'] = 2;
			}
		}
		if($v['rc']['prakt_sem_zan']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_practich WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['practic'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['practic'] = 2;
			}
		}
		if($v['rc']['lab_zan']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_practich WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['practic'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['practic'] = 2;
			}
		}
		if($v['rc']['kr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_controln WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['controln'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['controln'] = 2;
			}
		}
		if($v['rc']['kur']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_kursov WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['kursov'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['kursov'] = 2;
			}
		}
		if($v['rc']['kup']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_kursov WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['kursov'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['kursov'] = 2;
			}
		}
		if($v['rc']['uch_pr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
		if($v['rc']['uch_pr_p']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
		if($v['rc']['proizv_pr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
		if($v['rc']['preddip_pr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
	}
	//формируем таблицу данных препода
	$out .= '<table class="table table-striped table-bordered table-advance table-hover">';
	$out .= '<thead><tr>';
		$out .= '<th>Предмет</th>';
		$out .= '<th>Лекции</th>';
		$out .= '<th>Практ.</th>';
		$out .= '<th>Контр.</th>';
		$out .= '<th>Курсо.</th>';
		$out .= '<th>Практ.</th>';
	$out .= '</tr></thead><tbody>';
	foreach($predmets as $k => $v){
	$out .= '<tr>';
		$out .= '<td>'.$k.'</td>';	
		$c=''; $t='-'; if($v['rc']['lekcii']!=0){ $c='label-important'; $t='0%'; if(isset($v['lekcii'])){ 
			if($v['lekcii']==1) { $c='label-warning'; $t='50%'; }
			if($v['lekcii']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['prakt_sem_zan']!=0||$v['rc']['lab_zan']!=0){$c='label-important'; $t='0%'; if(isset($v['practic'])){ 
			if($v['practic']==1) { $c='label-warning'; $t='50%'; }
			if($v['practic']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['kr']!=0){$c='label-important'; $t='0%'; if(isset($v['controln'])){ 
			if($v['controln']==1) { $c='label-warning'; $t='50%'; }
			if($v['controln']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['kur']!=0||$v['rc']['kup']!=0){$c='label-important'; $t='0%'; if(isset($v['kursov'])){ 
			if($v['kursov']==1) { $c='label-warning'; $t='50%'; }
			if($v['kursov']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['uch_pr']!=0||$v['rc']['uch_pr_p']!=0||$v['rc']['proizv_pr']!=0||$v['rc']['preddip_pr']!=0){$c='label-important'; $t='0%'; if(isset($v['praktika'])){ 
			if($v['praktika']==1) { $c='label-warning'; $t='50%'; }
			if($v['praktika']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
	$out .= '</tr>';		
	}
	$out .= '<tr><td colspan="6" style="font-size:11px;"><span class="label">-</span> нет часов,<span class="label label-important">0%</span>-есть часы, но нет материала, <span class="label label-warning">50%</span>-есть часы и есть материал, но нет файла, <span class="label label-success">100%</span>-есть часы и есть материал и файл</td></tr>';
	$out .= '</tbody></table>';
	//$out .= '<pre>'.print_r($predmets,1).'</pre>';
	*/
	return $out;
}
function get_mat_grupps($id_lection,$l=0){//получаем привязанные группы по лекциям
	GLOBAL $ST,$DB; $out1 = array(); $out=' '; $m=array();
	$sql = 'SELECT id,name FROM '.$ST['dbpf'].'_lections WHERE id='.$id_lection.'';
	$rez = $DB->QUR_SEL($sql);
	if($rez&&$rez[0]>0){
		if($l==0) $out .= 'к лекции: '.$rez[1]['name'].' ';
		$sql = 'SELECT g.sokr,g.fo,g.kurs FROM '.$ST['dbpf'].'_lections_grupp as lg,'.$ST['dbpf'].'_grupp as g WHERE lg.id_lections='.$id_lection.' AND lg.id_grupp=g.id';
		$rez = $DB->QUR_SEL($sql);
		if($rez&&$rez[0]>0){
			foreach($rez as $k => $v)if($k){
				$m[]=array('sokr'=>$rez[1]['sokr'],'kurs'=>$rez[1]['kurs'],'fo'=>$rez[1]['fo']);
				$out .= '<b>'.$v['sokr'].'-'.$v['kurs'].'</b> '.$v['fo'].'; ';
			}
		}
	}
	$out1['masi'] = $m;
	$out1['html'] = $out;
	return $out1;
}
function prepod_check_status_old($json,$tid){
	GLOBAL $ST,$DB;
	$out=''; $predmets=array();
	$arr = json_decode($json,1);
	$nopredm=array('РВКР','РИМ ','ЗДН ','ОЛ','РИН','ГЭЗ','ЗВКР','РАД ','ЗДВ ','ЗДО');
	foreach($arr['db'] as $k => $v){
		$show=true;
		foreach($nopredm as $k1 => $v1) if(strpos($v['name_disp'],$v1)!==false) $show=false;
		if($show){
			$z=array();
			$z['lekcii']=$v['lekcii'];
			$z['prakt_sem_zan']=$v['prakt_sem_zan'];
			$z['lab_zan']=$v['lab_zan'];
			$z['kr']=$v['kr'];
			$z['kur']=$v['kur'];
			$z['kup']=$v['kup'];
			$z['uch_pr']=$v['uch_pr'];
			$z['uch_pr_p']=$v['uch_pr_p'];
			$z['proizv_pr']=$v['proizv_pr'];
			$z['preddip_pr']=$v['preddip_pr'];
			$predmets[$v['name_disp']]['rc']=$z;
		}
	}
	foreach($predmets as $predmet => $v){//надо проверить материалы у препода
		if($v['rc']['lekcii']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_lections WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['lection'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['lection'] = 2;
			}
		}
		if($v['rc']['prakt_sem_zan']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_practich WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['practic'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['practic'] = 2;
			}
		}
		if($v['rc']['lab_zan']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_practich WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['practic'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['practic'] = 2;
			}
		}
		if($v['rc']['kr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_controln WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['controln'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['controln'] = 2;
			}
		}
		if($v['rc']['kur']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_kursov WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['kursov'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['kursov'] = 2;
			}
		}
		if($v['rc']['kup']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_kursov WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['kursov'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['kursov'] = 2;
			}
		}
		if($v['rc']['uch_pr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
		if($v['rc']['uch_pr_p']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
		if($v['rc']['proizv_pr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
		if($v['rc']['preddip_pr']!=0){
			$sql = 'SELECT * FROM '.$ST['dbpf'].'_praktika WHERE name LIKE "%'.$predmet.'%" AND id_teacher='.$tid.'';
			$rez = $DB->QUR_SEL($sql);
			if($rez){
				$predmets[$predmet]['praktika'] = 1;
				if($rez[1]['file']!='') $predmets[$predmet]['praktika'] = 2;
			}
		}
	}
	//формируем таблицу данных препода
	$out .= '<table class="table table-striped table-bordered table-advance table-hover">';
	$out .= '<thead><tr>';
		$out .= '<th>Предмет</th>';
		$out .= '<th>Лекции</th>';
		$out .= '<th>Практ.</th>';
		$out .= '<th>Контр.</th>';
		$out .= '<th>Курсо.</th>';
		$out .= '<th>Практ.</th>';
	$out .= '</tr></thead><tbody>';
	foreach($predmets as $k => $v){
	$out .= '<tr>';
		$out .= '<td>'.$k.'</td>';	
		$c=''; $t='-'; if($v['rc']['lekcii']!=0){ $c='label-important'; $t='0%'; if(isset($v['lekcii'])){ 
			if($v['lekcii']==1) { $c='label-warning'; $t='50%'; }
			if($v['lekcii']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['prakt_sem_zan']!=0||$v['rc']['lab_zan']!=0){$c='label-important'; $t='0%'; if(isset($v['practic'])){ 
			if($v['practic']==1) { $c='label-warning'; $t='50%'; }
			if($v['practic']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['kr']!=0){$c='label-important'; $t='0%'; if(isset($v['controln'])){ 
			if($v['controln']==1) { $c='label-warning'; $t='50%'; }
			if($v['controln']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['kur']!=0||$v['rc']['kup']!=0){$c='label-important'; $t='0%'; if(isset($v['kursov'])){ 
			if($v['kursov']==1) { $c='label-warning'; $t='50%'; }
			if($v['kursov']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
		$c=''; $t='-'; if($v['rc']['uch_pr']!=0||$v['rc']['uch_pr_p']!=0||$v['rc']['proizv_pr']!=0||$v['rc']['preddip_pr']!=0){$c='label-important'; $t='0%'; if(isset($v['praktika'])){ 
			if($v['praktika']==1) { $c='label-warning'; $t='50%'; }
			if($v['praktika']==2) { $c='label-success'; $t='100%'; }
		}}
		$out .= '<td><span class="label '.$c.'">'.$t.'</span></td>';
	$out .= '</tr>';		
	}
	$out .= '<tr><td colspan="6" style="font-size:11px;"><span class="label">-</span> нет часов,<span class="label label-important">0%</span>-есть часы, но нет материала, <span class="label label-warning">50%</span>-есть часы и есть материал, но нет файла, <span class="label label-success">100%</span>-есть часы и есть материал и файл</td></tr>';
	$out .= '</tbody></table>';
	//$out .= '<pre>'.print_r($predmets,1).'</pre>';
	return $out;
}

function iup_check_kafedras(){//проверяем для преподов кафедру
	$file = 'tmp/json_kafedras_prepod.json';
	$ft = filemtime($file);
	if((time()-$ft)>(60*60*24*3)) unlink($file);//файл обновляется 1 раз в 3 дня
	if(!file_exists($file)){
		$url = 'http://local.mkgtu.ru/calchour_2023/get_json.php?json=kafedras_prepod';
		$json = file_get_contents($url);
		file_put_contents($file,$json);
	}else{
		$json = file_get_contents($file);
	}
	$json1 = json_decode($json,1);

	//$url = 'http://local.mkgtu.ru/calchour_2017/get_json.php?json=kafedras_prepod';
	//$json = json_decode(file_get_contents($url),1);
	$out=array();$out1=array();
	foreach($json1 as $k => $v){
		$out[$v['fio']][] = $v['name'];
	}
	foreach($out as $k => $v){
		$z['fio'] = $k;
		$z['kafs'] = $v;
		$out1[] = $z;
	}
	return $out1;
}
Предмет	Лекции	Практ.	Контр.	Курсо.	Практ.
'.$k.'	'.$t.'	'.$t.'	'.$t.'	'.$t.'	'.$t.'
- нет часов,0%-есть часы, но нет материала, 50%-есть часы и есть материал, но нет файла, 100%-есть часы и есть материал и файл