<?
	$id_user = $_SESSION['user']['id'];
    include_once $_SERVER['DOCUMENT_ROOT'].'/inc/class_SYSTEM.php';
    $SYSTEMclass = new SYSTEMclass();
	//АККРЕДИТАЦИЯ - ЗАЯВЛЕНИЯ и подача документов
	if ($_GET['page'] == 'order'){
		$msg = 0; //нет сообщений
		
		//загрузить заявление и добавить данные
		if (isset($_POST['add_accredit'])){
			$accredit = $_POST['accredit'];
			$surname = addslashes($_POST['surname']);
			$name = addslashes($_POST['name']);
			$patronymic = addslashes($_POST['patronymic']);
			$sex = addslashes($_POST['sex']);
			$type = addslashes($_POST['type']);
			$citizenship = addslashes($_POST['citizenship']);
			$fellow = addslashes($_POST['fellow']);
			$attidude = addslashes($_POST['attidude']);
			$snils = addslashes($_POST['snils']);
			$phone_number = addslashes($_POST['phone_number']);
			$date_born = addslashes($_POST['date_born']);
			$index_reg = addslashes($_POST['index_reg']);
			$address = addslashes($_POST['address']);
			$vid_doc = addslashes($_POST['vid_doc']);
			$seria_doc = addslashes($_POST['seria_doc']);
			$num_doc = addslashes($_POST['num_doc']);
			$date_doc = addslashes($_POST['date_doc']);
			$kem_doc = addslashes($_POST['kem_doc']);
			$type_edu = addslashes($_POST['type_edu']);
			$level_edu = addslashes($_POST['level_edu']);
			$spec_edu = addslashes($_POST['spec_edu']);
			$seria_edu = addslashes($_POST['seria_edu']);
			$num_edu = addslashes($_POST['num_edu']);
			$date_edu = addslashes($_POST['date_edu']);
			$kem_edu = addslashes($_POST['kem_edu']);
			$date_create = date("U");
			
			
			//загрузка файлов в директорию
			$dir_dest = 'upload/accredit/';
			
			//паспорт
			$file_pasport='';
			if(isset($_FILES['file_pasport'])){
				if(!file_exists($dir_dest)) mkdir($dir_dest);
				$fil = $date_create.$_FILES['file_pasport']['name'];
				$t = explode('.',$fil); $ext = $t[count($t)-1]; 
				unset($t[count($t)-1]); $fn = implode('.',$t);
				$file_pasport = $dir_dest . basename(translit($fn).'.'.$ext);
				//if (!move_uploaded_file($_FILES['file_pasport']['tmp_name'], $file_pasport)) {
				if (!$SYSTEMclass->sysUPLOAD($_FILES['file_pasport']['tmp_name'], $file_pasport)) {
					$file_pasport='';
				}
			}

			
			//диплом
			$file_edu='';
			if(isset($_FILES['file_edu'])){
				if(!file_exists($dir_dest)) mkdir($dir_dest);
				$fil = $date_create.$_FILES['file_edu']['name'];
				$t = explode('.',$fil); $ext = $t[count($t)-1]; 
				unset($t[count($t)-1]); $fn = implode('.',$t);
				$file_edu = $dir_dest . basename(translit($fn).'.'.$ext);
				//if (!move_uploaded_file($_FILES['file_edu']['tmp_name'], $file_edu)) {
				if (!$SYSTEMclass->sysUPLOAD($_FILES['file_edu']['tmp_name'], $file_edu)) {
					$file_edu='';
				}
			}
			
			//военный билет
			$file_vb='';
			if(isset($_FILES['file_vb'])){
				if(!file_exists($dir_dest)) mkdir($dir_dest);
				$fil = $date_create.$_FILES['file_vb']['name'];
				$t = explode('.',$fil); $ext = $t[count($t)-1]; 
				unset($t[count($t)-1]); $fn = implode('.',$t);
				$file_vb = $dir_dest . basename(translit($fn).'.'.$ext);
				//if (!move_uploaded_file($_FILES['file_vb']['tmp_name'], $file_vb)) {
				if (!$SYSTEMclass->sysUPLOAD($_FILES['file_vb']['tmp_name'], $file_vb)) {
					$file_vb='';
				}
			}
			
			//СНИЛС
			$file_snils='';
			if(isset($_FILES['file_snils'])){
				if(!file_exists($dir_dest)) mkdir($dir_dest);
				$fil = $date_create.$_FILES['file_snils']['name'];
				$t = explode('.',$fil); $ext = $t[count($t)-1]; 
				unset($t[count($t)-1]); $fn = implode('.',$t);
				$file_snils = $dir_dest . basename(translit($fn).'.'.$ext);
				//if (!move_uploaded_file($_FILES['file_snils']['tmp_name'], $file_snils)) {
				if (!$SYSTEMclass->sysUPLOAD($_FILES['file_snils']['tmp_name'], $file_snils)) {
					$file_snils='';
				}
			}
			
			//заявление
			$file_zayv='';
			if(isset($_FILES['file_zayv'])){
				if(!file_exists($dir_dest)) mkdir($dir_dest);
				$fil = $date_create.$_FILES['file_zayv']['name'];
				$t = explode('.',$fil); $ext = $t[count($t)-1]; 
				unset($t[count($t)-1]); $fn = implode('.',$t);
				$file_zayv = $dir_dest . basename(translit($fn).'.'.$ext);
				//if (!move_uploaded_file($_FILES['file_zayv']['tmp_name'], $file_zayv)) {
				if (!$SYSTEMclass->sysUPLOAD($_FILES['file_zayv']['tmp_name'], $file_zayv)) {
					$file_zayv='';
				}
			}
			
			
			//ДОБАВЛЕНИЕ В БАЗУ
			$sql = 'INSERT INTO '.$ST['dbpf'].'_accredit (`id_user`, `surname`, `name`, `patronymic`, `sex`, `type`, `citizenship`, `fellow`, `attidude`, `snils`, `phone_number`, `date_born`, `index_reg`, `address`, `vid_doc`, `seria_doc`, `num_doc`, `date_doc`, `kem_doc`, `type_edu`, `level_edu`, `spec_edu`, `seria_edu`, `num_edu`, `date_edu`, `kem_edu`, `file_pasport`, `file_edu`, `file_vb`, `file_snils`, `file_zayv`, `date_create`, `status`, `accredit`) VALUES ("'.$id_user.'", "'.$surname.'", "'.$name.'", "'.$patronymic.'", "'.$sex.'", "'.$type.'", "'.$citizenship.'", "'.$fellow.'", "'.$attidude.'", "'.$snils.'", "'.$phone_number.'", "'.$date_born.'", "'.$index_reg.'", "'.$address.'", "'.$vid_doc.'", "'.$seria_doc.'", "'.$num_doc.'", "'.$date_doc.'", "'.$kem_doc.'", "'.$type_edu.'", "'.$level_edu.'", "'.$spec_edu.'", "'.$seria_edu.'", "'.$num_edu.'", "'.$date_edu.'", "'.$kem_edu.'", "'.$file_pasport.'", "'.$file_edu.'", "'.$file_vb.'", "'.$file_snils.'", "'.$file_zayv.'", "'.$date_create.'", "0", "'.$accredit.'") ';
			//echo $sql;
			$rez = $DB->QUR($sql);
			$id = mysql_insert_id();
			
			//НУЖНО ЕЩЕ ЗАГРУЗИТЬ ФАЙЛЫ И УКАЗАТЬ ССЫЛКИ В БАЗЕ
			
			$msg = 1;
			save_logs('Заявление на аккредитацию оформлено №'.$id);
			
			
		}
		
		//мои заявления
		$zayavks = array();
		$sql = 'SELECT * FROM '.$ST['dbpf'].'_accredit WHERE id_user = "'.$id_user.'" ';
		$rez = $DB->QUR_SEL($sql);
		if ($rez){
			foreach ($rez as $key => $val) if ($key){
				
				/*$val['date_born'] = date('d.m.Y', $val['date_born']);
				$val['date_doc'] = date('d.m.Y', $val['date_doc']);
				$val['date_edu'] = date('d.m.Y', $val['date_edu']);*/
				$val['date_create'] = date('d.m.Y', $val['date_create']);
				$zayavks[] = $val;
			}
		}
		
		$fio = $_SESSION['user']['fio'];
		
		
		$smarty->assign('fio', $fio);
		$smarty->assign('msg', $msg);
		$smarty->assign('zayavks', $zayavks);
		$maincontent = $smarty->fetch('tpl_accredit_order.html');
	}
	
	//ПРЕДСЕДАТЕЛЬ АККРЕДИТАЦИОННОЙ КОМИССИИ
	if ($_GET['page'] == 'chairman'){
		//заявления на рассмотрении
		$zayavks = array();
		$sql = 'SELECT ac.*, us.* FROM '.$ST['dbpf'].'_accredit as ac, '.$ST['dbpf'].'_users as us WHERE ac.status = "0" AND ac.id_user = us.id AND ac.date_create >= "'.(date("U")-3600*24*90).'"';
		$rez = $DB->QUR_SEL($sql);
		if ($rez){
			foreach ($rez as $key => $val) if ($key){
				
				$val['date_create'] = date('d.m.Y', $val['date_create']);
				$zayavks[] = $val;
			}
		}
		
		$smarty->assign('zayavks', $zayavks);
		$maincontent = $smarty->fetch('tpl_accredit_chairman.html');
	}
	
	//ПРОСМОТР ОБЩЕЙ ТАБЛИЦЫ
	if (($_GET['page'] == 'print0')||($_GET['page'] == 'print')){ //0 в конце - СПО
		
		//заявления
		$zayavks = array();
		//$sql = 'SELECT * FROM '.$ST['dbpf'].'_accredit  ';
		if ($_GET['page'] == 'print0') $sql = 'SELECT ac.*, us.* FROM '.$ST['dbpf'].'_accredit as ac, '.$ST['dbpf'].'_users as us WHERE ac.status = "0" AND ac.id_user = us.id AND ac.date_create >= "'.(date("U")-3600*24*90).'" AND ac.level_edu = "Среднее профессиональное образование"'; 
		else $sql = 'SELECT ac.*, us.* FROM '.$ST['dbpf'].'_accredit as ac, '.$ST['dbpf'].'_users as us WHERE ac.status = "0" AND ac.id_user = us.id AND ac.date_create >= "'.(date("U")-3600*24*90).'" AND ac.level_edu = "Высшее образование"'; 
		$rez = $DB->QUR_SEL($sql);
		if ($rez){
			foreach ($rez as $key => $val) if ($key){
				
				$val['date_create'] = date('d.m.Y', $val['date_create']);
				$zayavks[] = $val;
			}
		}
		
		$smarty->assign('zayavks', $zayavks);
		$smarty->display('tpl_accredit_print.html');
		exit;
	}
?>