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;
$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();
}
$v_pupil_id = $arr_data['pupil_id']??0;
$row_pupil = $DB->fetch_row($DB->query("SELECT * FROM TB_PUPIL WHERE PUPIL_ID='$v_pupil_id' LIMIT 1"));
if(!$row_pupil) {
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'pupil_id 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'"));
if(!$r_teacher) {
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'user_key không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$TEACHER_ID = $r_teacher['TEACHER_ID'];
$v_school_id = $r_teacher['SCHOOL_ID'];
$v_teacher_id = $r_teacher['TEACHER_ID'];
$learn_year = $arr_data['learn_year']??'';
$hoc_ky = $arr_data['hoc_ky']??'';
$class_id = $arr_data['class_id']??0;
$hanh_kiem_value = $arr_data['hanh_kiem_value']??0;
if($learn_year=='' or !is_numeric($hanh_kiem_value)) {
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'Không đủ dữ liệu để cập nhật';
echo jsonutf($arr_res);
exit();
}
$row_check_class = $DB->fetch_row($DB->query("
SELECT *
FROM TB_CLASS
WHERE CLASS_ID='$class_id' AND (CLASS_TEACHER = '".$v_teacher_id."' OR CLASS_TEACHER_2 = '".$v_teacher_id."') AND CLASS_STATUS = 0 AND LEARN_YEAR='".$learn_year."'
LIMIT 1
"));
if(!$row_check_class) {
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'Giáo viên không phải giáo viên chủ nhiệm lớp';
echo jsonutf($arr_res);
exit();
}
$row_check = $DB->fetch_row($DB->query("SELECT * FROM TB_KQRL WHERE SCHOOL_ID='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND KQRL_HK='$hoc_ky' AND KQRL_YEAR='$learn_year' LIMIT 1 "));
if($row_check){
$DB->query("UPDATE TB_KQRL SET KQRL_VALUE='$hanh_kiem_value' WHERE KQRL_ID='".$row_check['KQRL_ID']."' ");
$arr_res['status'] = 'Update success';
$arr_res['status_note'] = 'Đã cập nhật hạnh kiểm';
echo jsonutf($arr_res);
exit();
}else{
$arr_insert = array('SCHOOL_ID'=>$v_school_id,'PUPIL_ID'=>$v_pupil_id,'KQRL_HK'=>$hoc_ky,'KQRL_YEAR'=>$learn_year,'KQRL_VALUE'=>$hanh_kiem_value,'KQRL_UPDATE_TIME'=>date('Y-m-d h:i:s'),'TEACHER_ID'=>$v_teacher_id);
$DB->do_insert('TB_KQRL',$arr_insert);
$arr_res['status'] = 'Insert success';
$arr_res['status_note'] = 'Đã thêm mới hạnh kiểm';
echo jsonutf($arr_res);
exit();
}
?>