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();
?>