���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() 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'; $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(); } if(!check_date_input($arr_data['txt_date'])){ $arr_res['status'] = 'Error'; $arr_res['status_note'] = 'txt_date có dạng dd-mm-yyyy'; 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']; $v_pupil_id = $arr_data['pupil_id']??0; $v_subject_id = $arr_data['subject_id']??0; $txt_date_db = date('Y-m-d',strtotime($arr_data['txt_date'])); $v_learn_year = $arr_data['learn_year']??get_current_learn_year($v_school_id); $txt_hoc_ky = $arr_data['hoc_ky']??0; if($txt_hoc_ky==0){ $arr_res['status'] = 'Error'; $arr_res['status_note'] = 'Học kỳ không tìm thấy'; echo jsonutf($arr_res); exit(); } $row_check_pupil = $DB->fetch_row($DB->query("SELECT * FroM TB_PUPIL WHERE PUPIL_ID='$v_pupil_id' LIMIT 1")); if(!$row_check_pupil){ $arr_res['status'] = 'Error'; $arr_res['status_note'] = 'Học sinh không tìm thấy'; echo jsonutf($arr_res); exit(); } $row_check_pcgd = $DB->fetch_row($DB->query("SELECT * FroM TB_PCGD WHERE TEACHER_ID='$v_teacher_id' AND SUBJECT_ID='$v_subject_id' AND CLASS_ID='".$row_check_pupil['CLASS_ID']."' AND PCGD_YEAR='".$v_learn_year."' LIMIT 1")); if(!$row_check_pcgd){ $arr_res['status'] = 'Error'; $arr_res['status_note'] = 'Giáo viên không có phân công giảng dạy lớp này'; echo jsonutf($arr_res); exit(); } $v_class_id = intval($row_check_pupil['CLASS_ID']); if($v_class_id==0){ $arr_res['status'] = 'Error'; $arr_res['status_note'] = 'Học sinh chưa chốt danh sách xếp lớp đầu năm'; echo jsonutf($arr_res); exit(); } $r_class = $DB->fetch_row($DB->query("SELECT * FROM TB_CLASS WHERE CLASS_ID='$v_class_id' LIMIT 1")); $v_khoi_id = $r_class['KHOI_ID']; $txt_score_type_id = $v_mark_type = $arr_data['score_type_id']??0; $arr_score_type[0] = array('score_type_id'=>1,'score_type_name'=>'ĐĐGtx','score_type_he_so'=>1); $arr_score_type[1] = array('score_type_id'=>2,'score_type_name'=>'ĐĐGgk','score_type_he_so'=>2); $arr_score_type[2] = array('score_type_id'=>3,'score_type_name'=>'ĐĐGck','score_type_he_so'=>3); $txt_score_type_name = ''; $score_type_he_so = 0; foreach($arr_score_type as $key=>$val){ if($txt_score_type_id==$val['score_type_id']){ $txt_score_type_name = $val['score_type_name']; $txt_score_type_he_so = $score_type_he_so = $val['score_type_he_so']; } } if(empty($txt_score_type_name) or $txt_score_type_he_so==0){ $arr_res['status'] = 'Error'; $arr_res['status_note'] = 'score_type_id không tìm thấy'; echo jsonutf($arr_res); exit(); } if($txt_score_type_id==1) { $row_count_so_cot_diem = get_socondiemtk_api($v_khoi_id,$v_subject_id); $row_mark_check_so_cot_diem = $DB->fetch_row($DB->query("SELECT COUNT(DISTINCT MARK_ID) as total_diem FROM `TB_MARK` WHERE SCHOOL_ID='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND SUBJECT_ID='$v_subject_id' AND MARK_YEAR='$v_learn_year' AND MARK_HK='$txt_hoc_ky' AND MARK_TYPE='$v_mark_type' ")); if($row_mark_check_so_cot_diem['total_diem']>$row_count_so_cot_diem){ $arr_res['status'] = 'Error'; $arr_res['status_note'] = 'Số con điểm ĐĐGtx đã vượt quá cài đặt'; echo jsonutf($arr_res); exit(); } } $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'; $arr_res['status_note'] = 'score_value không tìm thấy'; echo jsonutf($arr_res); exit(); } $arr_insert = array('SCHOOL_ID'=>$v_school_id,'PUPIL_ID'=>$v_pupil_id,'TEACHER_ID'=>$v_teacher_id,'SUBJECT_ID'=>$v_subject_id,'MARK_DATE'=>$txt_date_db,'MARK_GROUP'=>0,'MARK_YEAR'=>$v_learn_year,'MARK_HK'=>$txt_hoc_ky,'MARK_VALUE'=>$score_value,'MARK_HESO'=>$txt_score_type_he_so,'MARK_TYPE'=>$v_mark_type,'MARK_NOTE'=>trim($arr_data['txt_note']),'MARK_LAST_UPDATE'=>date('Y-m-d H:i:s')); $core_id = $DB->do_insert('TB_MARK',$arr_insert); $arr_res['status'] = 'Success'; $arr_res['status_note'] = 'Đã thêm điểm'; $arr_res['core_id'] = $core_id; echo jsonutf($arr_res); exit(); ?>