EIOS/rabprog/inc/class_FAKKAF.php

304 lines
12 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
class class_FAKKAF{
private $DB=null;
private $TTable='';
private $polya=array();
function __construct(){
GLOBAL $DB,$ST;
$this->DB = $DB;
$this->TTable = $ST['dbpf'].'_fshp_fakkaf';
$this->polya = $this->table_create();
}
//id kafedra fakultet kodkaf kodkaf_old
/**
* Создание таблицы и возвращение полей таблицы
* @return string[][]
*/
private function table_create(){
$polya = array(
0=>array('name'=>'id','type'=>'int(11)','nul'=>'NOT NULL','dop'=>'AUTO_INCREMENT'),
array('name'=>'kafedra','type'=>'varchar(255)','nul'=>'NOT NULL','dop'=>''),
array('name'=>'fakultet','type'=>'varchar(255)','nul'=>'NOT NULL','dop'=>''),
array('name'=>'kodkaf','type'=>'varchar(255)','nul'=>'NOT NULL','dop'=>''),
array('name'=>'kodkaf_old','type'=>'varchar(255)','nul'=>'NOT NULL','dop'=>''),
);
$sql = 'CREATE TABLE IF NOT EXISTS `'.$this->TTable.'` (';
foreach($polya as $k => $v){ $sql .= '`'.$v['name'].'` '.$v['type'].' '.$v['nul'].' '.$v['dop'].',';}
$sql .= 'primary key (id) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;';
$this->DB->QUR($sql);
return $polya;
}
/**
* Основа работы с интерфейсом
* @return string[]|void
* @throws SmartyException
*/
public function HTML(){
GLOBAL $WorkDIR;
$CHPU = new class_CHPU($WorkDIR);
$URLS = $CHPU->uri();
$smartyC = new class_smarty();
$smarty = $smartyC->config(__DIR__.'\..\tpl');
$view = 'all';
$out = array('name'=>'Факультеты и кафедры','body'=>'');
//обработка АЯКС запросов
if(isset($_POST['ajdes'])){
header('Content-Type: application/json; charset=utf-8');
$out=array();
//Установка кафедры для дисциплины
if($_POST['ajdes']=='setkaf_update'){
$id = (int)$_POST['id'];
$kafedra_new = $this->DB->rescape($_POST['kafedra_new']);
$sql = 'UPDATE acs_fshp_uchebplans SET kaf_name="'.$kafedra_new.'" WHERE id='.$id.' LIMIT 1';
$rez = $this->DB->QUR($sql);
if(!$rez['err']){
$out['err']=0;
$out['msg']='Обновили';
}else{
$out['err']=1;
$out['msg']='Не обновили';
}
}
//Смена кафедр в УП на правильные
if($_POST['ajdes']=='compare_update'){
$kafedra_old = $this->DB->rescape($_POST['kafedra_old']);
$kafedra_new = $this->DB->rescape($_POST['kafedra_new']);
$sql = 'UPDATE acs_fshp_uchebplans SET kaf_name="'.$kafedra_new.'" WHERE kaf_name="'.$kafedra_old.'"';
$rez = $this->DB->QUR($sql);
if(!$rez['err']){
$out['err']=0;
$out['msg']='Обновили';
}else{
$out['err']=1;
$out['msg']='Не обновили';
}
}
//удаление записи комп.модели
if($_POST['ajdes']=='Dele_TR'){
$data['id'] = (int)$_POST['idr'];
$out = $this->Delete($data);
}
//сохранение записи комп.модели
if($_POST['ajdes']=='Save_TR'){
$data['kafedra'] = $this->DB->rescape($_POST['kafedra']);
$data['fakultet'] = $this->DB->rescape($_POST['fakultet']);
$data['kodkaf'] = $this->DB->rescape($_POST['kodkaf']);
$data['kodkaf_old'] = $this->DB->rescape($_POST['kodkaf_old']);
$data['id'] = (int)$_POST['idr'];
if($data['id']==0) $out = $this->Save($data);
else $out = $this->Edit($data);
}echo json_encode($out);
exit();
}
if(isset($URLS[1])){
$view = $URLS[1];
if($URLS[1]=='compare'){
$fakkaf=array();
$sql = 'SELECT * FROM `'.$this->TTable.'` ORDER BY id';//fakultet ASC';
$rez = $this->DB->QUR_SEL($sql);
//echo '<pre>'.print_r($rez,1).'</pre>';exit();
if(!$rez['err']&&$rez['kol']){
foreach($rez['rez'] as $key => $val){
$fakkaf[$val['kodkaf']]['kod'] = $val['kodkaf'];
$fakkaf[$val['kodkaf']]['name'] = $val['kafedra'];
}
}
$items = array();
$sql = 'SELECT `kaf_kod`,`kaf_name` FROM `acs_fshp_uchebplans` GROUP BY `kaf_name` ORDER BY `acs_fshp_uchebplans`.`kaf_kod` ASC';
$rez = $this->DB->QUR_SEL($sql);
if(!$rez['err']&&$rez['kol']){
foreach($rez['rez'] as $key => $val){
$val['rr'] = $this->str_compareColor($fakkaf[$val['kaf_kod']]['name'],$val['kaf_name']);
$items[] = $val;
}
}
$smarty->assign('items', $items);
$smarty->assign('fakkaf', $fakkaf);
}
if($URLS[1]=='kafnul'){
$items=array();
$sql = 'SELECT kodkaf,kafedra FROM `'.$this->TTable.'` ORDER BY id';
$rez = $this->DB->QUR_SEL($sql);
if(!$rez['err']&&$rez['kol']){
foreach($rez['rez'] as $key => $val){
$sql1 = 'SELECT id,index1,name,`kaf_kod`,`kaf_name` FROM `acs_fshp_uchebplans` WHERE kaf_kod="'.$val['kodkaf'].'" AND kaf_name!="'.$val['kafedra'].'"';
$rez1 = $this->DB->QUR_SEL($sql1);
if(!$rez1['err']&&$rez1['kol']){
foreach($rez1['rez'] as $key1 => $val1){
$val1['rr'] = $this->str_compareColor($val['kafedra'],$val1['kaf_name']);
$val1['kafkod_1'] = $val['kodkaf'];
$val1['kafname_1'] = $val['kafedra'];
$items[] = $val1;
}
}
}
}
$smarty->assign('items', $items);
}
$smarty->assign('view', $view);
$out['body'] = $smarty->fetch('page_fakkaf.html');
}
//Отображение всех
if(!isset($URLS[1])||$URLS[1]=='all') {
$smarty->assign('items', $this->Items());
$smarty->assign('view', $view);
$out['body'] = $smarty->fetch('page_fakkaf.html');
}
return $out;
}
function str_compareColor($str1,$str2){
$out='';
$array1 = mb_str_split($str1);
$array2 = mb_str_split($str2);
foreach($array1 as $k1 => $v1){
if($array2[$k1]!=$v1){
$out .= '<span style="color: red;font-weight: bold;">'.$array2[$k1].'</span>';
}else{
$out .= $array2[$k1];
}
}
return $out;
}
/**
* Подготовка данных для таблицы
* @param $data
* @return mixed
*/
private function Prepare_data($data){
if(!isset($data['kafedra'])) $data['kafedra']=''; else $data['kafedra']=$this->DB->rescape($data['kafedra']);
if(!isset($data['fakultet'])) $data['fakultet']=''; else $data['fakultet']=$this->DB->rescape($data['fakultet']);
if(!isset($data['kodkaf'])) $data['kodkaf']=''; else $data['kodkaf']=$this->DB->rescape($data['kodkaf']);
if(!isset($data['kodkaf_old'])) $data['kodkaf_old']=''; else $data['kodkaf_old']=$this->DB->rescape($data['kodkaf_old']);
if($data['pos']=='') $data['pos']=0;
return $data;
}
/**
* Редактирование записи
* @param $data
* @return array
*/
private function Edit($data){
$data = $this->Prepare_data($data);
$sql = 'UPDATE `'.$this->TTable.'` SET kafedra="'.$data['kafedra'].'",fakultet="'.$data['fakultet'].'",kodkaf="'.$data['kodkaf'].'",kodkaf_old="'.$data['kodkaf_old'].'" WHERE id='.$data['id'].' LIMIT 1';
$rez = $this->DB->QUR($sql);
if(!$rez['err']){
$out['err']=0;
$out['msg']='Обновили запись';
$out['id']=$this->DB->lastinsertID();
}else{
$out['err']=1;
$out['msg']='Не обновили запись. Ошибка!';
$out['id']=$data['id'];
}
return $out;
}
/**
* Сохранение записи
* @param $data
* @return array
*/
private function Save($data){
$data = $this->Prepare_data($data);
$sql = 'INSERT INTO `'.$this->TTable.'` VALUES(0,"'.$data['kafedra'].'","'.$data['fakultet'].'","'.$data['kodkaf'].'","'.$data['kodkaf_old'].'");';
$rez = $this->DB->QUR($sql);
if(!$rez['err']){
$out['err']=0;
$out['msg']='Добавили запись';
$out['id']=$this->DB->lastinsertID();
}else{
$out['err']=1;
$out['msg']='Не добавили запись. Ошибка!';
$out['id']=0;
}
return $out;
}
/**
* Удаление записи
* @param $data
* @return array
*/
private function Delete($data){
$sql = 'DELETE FROM `'.$this->TTable.'` WHERE id='.$data['id'].' LIMIT 1';
$rez = $this->DB->QUR($sql);
if(!$rez['err']){
$out['err']=0;
$out['msg']='Удалили запись';
$out['id']=$data['id'];
}else{
$out['err']=1;
$out['msg']='Не удалили запись. Ошибка!';
$out['id']=0;
}
return $out;
}
/**
* Получение
* @return array|mixed
*/
public function Items(){
$out=array();
$sql = 'SELECT * FROM `'.$this->TTable.'` ORDER BY kodkaf';//fakultet ASC';
$rez = $this->DB->QUR_SEL($sql);
if(!$rez['err']&&$rez['kol']){
$out = $rez['rez'];
}
return $out;
}
/**
* Получение по названию кафедры
* @return array|mixed
*/
public function Item_by_kafname($kafname){
$out=array();
//Истории и права
if($kafname=='истории государства и права') $kafname = 'Истории и права';
if($kafname=='Истории государства и права') $kafname = 'Истории и права';
$sql = 'SELECT * FROM `'.$this->TTable.'` WHERE kafedra="'.$this->DB->rescape($kafname).'"';
//echo $sql; //SELECT * FROM `acs_fshp_fakkaf` WHERE kafedra="истории государства и права"
$rez = $this->DB->QUR_SEL($sql);
if(!$rez['err']&&$rez['kol']){
$out = $rez['rez'][0];
if (strpos($out['fakultet'], 'Факультет') !== false) {
$out['fakultet'] = str_replace('Факультет','',$out['fakultet']);
}
}
return $out;
}
/**
* Получение по коду
* @return array|mixed
*/
public function Item_by_kod($kodkaf){
$out=array();
$sql = 'SELECT * FROM `'.$this->TTable.'` WHERE kodkaf="'.$this->DB->rescape($kodkaf).'"';
$rez = $this->DB->QUR_SEL($sql);
if(!$rez['err']&&$rez['kol']){
$out = $rez['rez'][0];
}
return $out;
}
/**
* Получение по старому коду
* @return array|mixed
*/
public function Item_by_oldkod($kodkaf){
$out=array();
$sql = 'SELECT * FROM `'.$this->TTable.'` WHERE kodkaf_old="'.$this->DB->rescape($kodkaf).'"';
$rez = $this->DB->QUR_SEL($sql);
if(!$rez['err']&&$rez['kol']){
$out = $rez['rez'][0];
}
return $out;
}
}