EIOS/aj_liquidation.php

112 lines
3.4 KiB
PHP
Raw Permalink Normal View History

2023-12-28 15:39:22 +03:00
<?php
error_reporting(E_ALL);
ini_set('memory_limit', '-1');
header('Content-Type: application/json; charset=utf-8');
date_default_timezone_set('Europe/Moscow');
include 'inc/_db.php';
include 'config.php';
$des=''; if(isset($_GET['des'])) $des = $_GET['des'];
if($des=='liquidation'){
$rez = liquidation_get();
//echo json_encode($rez,JSON_UNESCAPED_UNICODE);
echo '<pre>'.print_r($rez,1).'</pre>';
}
function liquidation_get(){
GLOBAL $ST,$DB; $out=array();
//_liquidation: id, id_student, id_teacher, fakultet, type, iup, name, control, date_create, date_end, semestr, mark, date_mark, id_stat, print, id_user
$sql = 'SELECT id, id_student, id_teacher, fakultet, type, iup, name, control, date_create, date_end, semestr, mark, date_mark
FROM ' . $ST['dbpf'] . '_liquidation WHERE mark IS NOT NULL ORDER BY date_create DESC LIMIT 100';
$rez = $DB->QUR_SEL($sql);
if ($rez) {
foreach ($rez as $k => $v) if ($k) {
$tmp = get_student_info($v['id_student']);
if(count($tmp)) {
unset($tmp[0]['id_grupp']);
$v['student'] = $tmp[0];
$tmp = get_teacher_info($v['id_teacher']);
$v['teacher'] = $tmp[0];
unset($v['id_student'],$v['id_teacher']);
$out[] = $v;
}
}
}
return $out;
}
function get_user_info($id_user){
GLOBAL $DB,$ST;
$out=array();
$sql = 'SELECT id,fio,polis,snils,guid FROM '.$ST['dbpf'].'_users WHERE id='.$id_user;
$rez = $DB->QUR_SEL($sql);
if ($rez){
foreach($rez as $k => $v)if($k){
$out[] = $v;
}
}
return $out;
}
function get_student_info($id_student){
GLOBAL $DB,$ST;
$out=array();
//$sql = 'SELECT
// s.num_zach,s.num_grupp,s.kod_podgotovki,s.id_user
// g.sokr,g.fo,g.year_start,
// f.name,f.abbreviated
//FROM
// '.$ST['dbpf'].'_students as s,
// '.$ST['dbpf'].'_grupp as g,
// '.$ST['dbpf'].'_faculties as f
//WHERE
// g.id_facult=f.id AND
// d.id=s.id_grupp AND
// s.id='.$id_student;
$sql = 'SELECT num_zach, num_grupp, kod_podgotovki, id_user,id_grupp FROM '.$ST['dbpf'].'_students WHERE id='.$id_student.' ORDER BY data_c DESC LIMIT 1';
$rez = $DB->QUR_SEL($sql);
if ($rez){
foreach($rez as $k => $v)if($k){
$tmp = get_grupp_info($v['id_grupp']);
if(isset($tmp[0])) $v = array_merge($v,$tmp[0]);
//$v['user'] = get_user_info($v['id_user']);
$tmp = get_user_info($v['id_user']);
if(isset($tmp[0])) $v = array_merge($v,$tmp[0]);
$out[] = $v;
}
}
return $out;
}
function get_grupp_info($id_grupp){
GLOBAL $DB,$ST;
$out=array();
$sql = 'SELECT sokr,fo,year_start FROM '.$ST['dbpf'].'_grupp WHERE id='.$id_grupp;
$rez = $DB->QUR_SEL($sql);
if ($rez){
foreach($rez as $k => $v)if($k){
$out[] = $v;
}
}
return $out;
}
function get_teacher_info($id_teacher){
GLOBAL $DB,$ST;
$out=array();
$sql = 'SELECT
t.fakultet,t.kafedra,
u.fio,u.polis,u.snils,u.guid
FROM
'.$ST['dbpf'].'_teachers as t,
'.$ST['dbpf'].'_users as u
WHERE
u.id=t.id_user AND
t.id='.$id_teacher;
$rez = $DB->QUR_SEL($sql);
if ($rez){
foreach($rez as $k => $v)if($k){
$out[] = $v;
}
}
return $out;
}