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_i = array('user_key'=>'duongvt.quynhon','pupil_id'=>123123,'subject_id'=>1,'txt_date'=>date('Y-m-d'),'learn_year'=>'2023-2024','hoc_ky'=>1,'score_value'=>9.9,'score_type_id'=>1,'txt_note'=>'qqw dwqdqwd');
echo jsonutf($arr_i);
exit();*/
/*insert_mark(
$v_school_id
,$v_pupil_id
,$v_teacher_id
,$v_subject_id
,$v_mark_date
,$v_mark_group
,$v_mark_year
,$v_mark_hk
,$v_mark_value
,$v_mark_heso
,$v_mark_type
,$v_mark_note
);*/
$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 1';
$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 2';
$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_teacher_id = $r_teacher['TEACHER_ID'];
$score_value = floatval($arr_data['score_value']);
if(empty($arr_data['score_value']) or $score_value<0 or $score_value>10){
$arr_res['status'] = 'Error 3';
$arr_res['status_note'] = 'score_value không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$core_id = intval($arr_data['core_id']);
if($core_id==0){
$arr_res['status'] = 'Error 5';
$arr_res['status_note'] = 'core_id không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$row_old_mark = $DB->fetch_row($DB->query("SELECT * FROM TB_MARK WHERE MARK_ID='$core_id' AND TEACHER_ID='$v_teacher_id' LIMIT 1"));
if(!$row_old_mark){
$arr_res['status'] = 'Error 5';
$arr_res['status_note'] = 'giáo viên có điểm sửa không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$reason_edit_db = textformatdb($arr_data['reason_edit']);
$arr_update = array('MARK_VALUE'=>$score_value,'MARK_NOTE'=>textformatdb($arr_data['txt_note']),'MARK_LAST_UPDATE'=>date('Y-m-d H:i:s'));
$DB->do_update('TB_MARK',$arr_update, " WHERE MARK_ID='$core_id' " );
$arr_insert_his = array('MAHI_TIME'=>date('Y-m-d H:i:s'),'MAHI_MARK_OLD_VALUE'=>$row_old_mark['MARK_VALUE'],'MAHI_MARK_OLD_TYPE'=>$row_old_mark['MARK_TYPE'],'MAHI_MARK_OLD_HESO'=>$row_old_mark['MARK_HESO'],'MAHI_MARK_NEW_VALUE'=>$score_value,'MAHI_MARK_NEW_TYPE'=>$row_old_mark['MARK_TYPE'],'MAHI_MARK_NEW_HESO'=>$row_old_mark['MARK_HESO'],'MAHI_NOTE'=>$reason_edit_db,'MAHI_TYPE'=>$row_old_mark['MARK_TYPE'],'SCHOOL_ID'=>$v_school_id,'PUPIL_ID'=>$row_old_mark['PUPIL_ID'],'TEACHER_ID'=>$v_teacher_id,'SUBJECT_ID'=>$row_old_mark['SUBJECT_ID'],'MAHI_MARK_NEW_NOTE'=>textformatdb($arr_data['txt_note']),'MAHI_MARK_OLD_NOTE'=>$row_old_mark['MARK_NOTE'],'MARK_ID'=>$core_id);
$DB->do_insert('TB_MAHI',$arr_insert_his);
$arr_res['status'] = 'Success';
$arr_res['status_note'] = 'Đã sửa điểm';
$arr_res['core_id'] = $core_id;
echo jsonutf($arr_res);
exit();
?>