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'=>'anhltp.campha','pupil_id'=>120,'week_day'=>'01-01-2024',
'comment_mn_content'=>'Chiến binh ưu tú','comment_mn_img'=>'1','teacher_id'=>10003829,'comment_mn_time'=>date('Y-m-d H:i:s'));
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']??'';
$PHIEU_BE_NGOAN_ID = $arr_data['comment_mn_id']??0;
if(!check_date_input($arr_data['week_day'])){
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'week_day có dạng dd-mm-yyyy';
echo jsonutf($arr_res);
exit();
}
$txt_date = date('Y-m-d',strtotime($arr_data['week_day']));
$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();
}
$arr_huy_hieu = array(
'1'=>array('1. Chiến binh ưu tú','upload/logos/mn-uu-tu.png'),
'2'=>array('2. Chiến binh vượt trội','upload/logos/mn-vuot-troi.png'),
'3'=>array('3. Chiến binh chăm chỉ','upload/logos/mn-cham-chi.png')
);
$user_id = $r_user['USER_ID'];
$r_teacher = $DB->fetch_row($DB->query("SELECT * FROM TB_TEACHER WHERE USER_ID='$user_id'"));
$v_teacher_id = $TEACHER_ID = $r_teacher['TEACHER_ID'];
$v_school_id = $r_teacher['SCHOOL_ID'];
$v_pupil_id = $arr_data['pupil_id'];
$v_post_time = date('Y-m-d H:i:s');
$PHIEU_BE_NGOAN_COMMENT = textformatdb($arr_data['comment_mn_content']);
$huy_hieu_id = $arr_data['huy_hieu_id']??0;
$PHIEU_BE_NGOAN_IMG = '';
if($huy_hieu_id>0){
if($huy_hieu_id<4) {
$PHIEU_BE_NGOAN_IMG = $arr_huy_hieu[$huy_hieu_id][1];
}else{
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'huy_hieu_id là số từ 1 đến 3';
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();
}
$arr_insert = array('PUPIL_ID'=>$v_pupil_id,'WEEK_DAY'=>$txt_date,'PHIEU_BE_NGOAN_COMMENT'=>$PHIEU_BE_NGOAN_COMMENT,'PHIEU_BE_NGOAN_IMG'=>$PHIEU_BE_NGOAN_IMG,'TEACHER_ID'=>$v_teacher_id,'TIME_POST'=>date("Y-m-d h:i:s"));
$arr_res['status'] = 'Success';
$row_check = $DB->fetch_row($DB->query("SELECT * FROM TB_PHIEU_BE_NGOAN WHERE PUPIL_ID='$v_pupil_id' AND WEEK_DAY='$txt_date' "));
if($row_check){
$v_comment_mn_id = $row_check['PHIEU_BE_NGOAN_ID'];
$DB->do_update('TB_PHIEU_BE_NGOAN',$arr_insert," WHERE PHIEU_BE_NGOAN_ID='".$row_check['PHIEU_BE_NGOAN_ID']."' ");
$arr_res['status_note'] = 'Đã sửa comment mầm non thành công';
}else{
$v_comment_mn_id = $DB->do_insert('TB_PHIEU_BE_NGOAN',$arr_insert);
$arr_res['status_note'] = 'Đã thêm comment mầm non thành công';
}
/*if($PHIEU_BE_NGOAN_ID==0){
$v_comment_mn_id = $DB->do_insert('TB_PHIEU_BE_NGOAN',$arr_insert);
$arr_res['status_note'] = 'Đã thêm comment mầm non thành công';
}else{
$v_comment_mn_id = $PHIEU_BE_NGOAN_ID;
$DB->do_update('TB_PHIEU_BE_NGOAN',$arr_insert," WHERE PHIEU_BE_NGOAN_ID='$PHIEU_BE_NGOAN_ID' ");
$arr_res['status_note'] = 'Đã sửa comment mầm non thành công';
}*/
$arr_res['school_id'] = $v_school_id;
$arr_res['pupil_id'] = $v_pupil_id;
$arr_res['teacher_id'] = $v_teacher_id;
$arr_res['teacher_name'] = showutf($r_teacher['TEACHER_REAL_NAME']);
$arr_res['comment_time'] = date("Y-m-d h:i:s");
$arr_res['comment_mn_content'] = html_entity_decode($PHIEU_BE_NGOAN_COMMENT);
$arr_res['comment_mn_id'] = $v_comment_mn_id;
echo jsonutf($arr_res);
?>