Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/api-truyentranh/includes/post/ |
<?php
global $DB;
/*$arr_unput = array('user_key'=>'giacbn.nhg','txt_date'=>'20-02-2024','SCHOOL_ID'=>120,'TEACHER_ID'=>10003829,'TIET_NUM'=>1,'CLASS_ID'=>5628,'SUBJECT_ID'=>50);
echo json_encode($arr_unput);
exit();*/
$json = file_get_contents('php://input');
$arr_data = json_decode($json, true);
$arr_res = $arr_data;
$user_key = $arr_data['user_key']??'';
if(empty($user_key)){
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'user_key không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$r_user = $DB->fetch_row($DB->query("SELECT * FROM TB_USER WHERE USER_KEY='$user_key'"));
if(!$r_user) {
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'user_key không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$user_id = $r_user['USER_ID'];
$r_teacher = $DB->fetch_row($DB->query("SELECT * FROM TB_TEACHER WHERE USER_ID='$user_id'"));
$TEACHER_ID = $r_teacher['TEACHER_ID'];
$v_school_id = $r_teacher['SCHOOL_ID'];
$v_vphsgv_id = $arr_data['vi_pham_id'];
$row_check_vp = $DB->fetch_row($DB->query("SELECT * FROM TB_VPHSGV WHERE VPHSGV_ID='$v_vphsgv_id'"));
if(!$row_check_vp) {
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'vi_pham_id không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$v_pupil_id = $arr_data['pupil_id'];
$row_pupil = $DB->fetch_row($DB->query("SELECT * FROM TB_PUPIL WHERE PUPIL_ID='$v_pupil_id' "));
if(!$row_pupil){
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'pupil_id không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$tiet_id=$arr_data['lesson_id'];
$row_tiet = $DB->fetch_row($DB->query("SELECT * FROM TB_TIET WHERE TIET_ID='$tiet_id' AND TEACHER_ID='$TEACHER_ID'"));
if(!$row_tiet){
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'lesson_id không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$vi_pham_note = textformatdb($arr_data['vi_pham_note']);
$arr_insert = array('SCHOOL_ID'=>$v_school_id,'PUPIL_ID'=>$v_pupil_id,'TIET_ID'=>$tiet_id,'TEACHER_ID'=>$TEACHER_ID,'VPHSGV_ID'=>$v_vphsgv_id,'NOTE'=>$vi_pham_note,'UPDATE_TIME'=>date('Y-m-d H:i:s'),'TIET_DATE'=>$row_tiet['TIET_DATE'],'TIET_NUM'=>$row_tiet['TIET_NUM'],'SUBJECT_ID'=>$row_tiet['SUBJECT_ID']);
$row_check_ghisdb = $DB->fetch_row($DB->query("SELECT * FROM TB_GHISDB WHERE PUPIL_ID='".$v_pupil_id."' AND TIET_ID='".$tiet_id."' AND VPHSGV_ID='".$v_vphsgv_id."'"));
if(!$row_check_ghisdb){
$GHISDB_ID= $DB->do_insert('TB_GHISDB',$arr_insert);
$arr_ghires = array('ghi_db_id'=>$GHISDB_ID,'lesson_id'=>$tiet_id,'pupil_id'=>$v_pupil_id,'pupil_name'=>showutf($row_pupil['PUPIL_REAL_NAME']),'vi_pham_id'=>$v_vphsgv_id,'vi_pham_name'=>showutf($row_check_vp['VPHSGV_TITLE']),'vi_pham_note'=>showutf($arr_data['vi_pham_note']));
$arr_res['status'] = 'Success';
$arr_res['status_note'] = 'Đã cập nhật vi phạm';
$arr_res['data'] = $arr_ghires;
echo jsonutf($arr_res);
exit();
}else{
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'Vi phạm đã cập nhật trước đây';
echo jsonutf($arr_res);
exit();
}
?>