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;
$user_key = $CORE->input['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();
}
$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'];
$arr_res['user_id'] = $user_id;
$arr_res['teacher_id'] = $r_teacher['TEACHER_ID'];
$arr_res['teacher_fullname'] = showutf($r_teacher['TEACHER_REAL_NAME']);
$tiet_id=$CORE->input['lesson_id'];
$row_tiet = $DB->fetch_row($DB->query("SELECT * FROM TB_TIET WHERE TIET_ID='$tiet_id' AND TEACHER_ID='$TEACHER_ID'"));
if(!$row_tiet){
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'lesson_id không tìm thấy';
echo jsonutf($arr_res);
exit();
}
$lesson_title = textformatdb(trim($CORE->input['lesson_title']));
$lesson_note = textformatdb(trim($CORE->input['lesson_note']));
$tiet_ppct= textformatdb(trim($CORE->input['tiet_ppct']));
$lesson_rank = trim($CORE->input['lesson_rank']);
$dan_do_bao_bai = $lesson_comment = textformatdb(trim($CORE->input['dan_do_bao_bai']));
$link_bao_bai = trim($CORE->input['link_bao_bai'])??'';
$han_nop = trim($CORE->input['han_nop']);
$arr_update = array('LESSION_TITLE'=>$lesson_title,'NOTE'=>$lesson_note,'TIET_PPCT'=>$tiet_ppct,'RANK'=>$lesson_rank,'LAST_UPDATE_TIME'=>date('Y-m-d H:i:s'));
$DB->do_update('TB_TIET',$arr_update," WHERE TIET_ID='$tiet_id' AND TEACHER_ID='$TEACHER_ID' ");
if(!empty($lesson_comment)){
if($han_nop!=''){
if(!check_date_input($han_nop)){
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'han_nop có dạng dd-mm-yyyy';
echo jsonutf($arr_res);
exit();
}
$han_nop_db = date('Y-m-d',strtotime($han_nop));
}else{
$han_nop_db = '0000-00-00';
}
$row_check2 = $DB->fetch_row($DB->query("SELECT * FROM TB_TIET_COMMENT WHERE TIET_ID='$tiet_id' "));
if(!$row_check2){
$arr_insert_comment = array('TIET_ID'=>$tiet_id,'TIET_COMMENT_CONTENT'=>$lesson_comment,'TIET_HAN_NOP'=>$han_nop_db,'TIET_LINK'=>$link_bao_bai);
$DB->do_insert('TB_TIET_COMMENT',$arr_insert_comment);
}else{
$arr_update_comment = array('TIET_COMMENT_CONTENT'=>$lesson_comment,'TIET_HAN_NOP'=>$han_nop_db,'TIET_LINK'=>$link_bao_bai);
$DB->do_update('TB_TIET_COMMENT',$arr_update_comment, " WHERE TIET_ID='$tiet_id' ");
}
}
$arr_allow_file_type = array("jpg","jpeg","gif","mid","mp3","mp4","png","tif","doc","docx","rar","zip","pdf","rtf","txt","xls","xlsx","pptx","ppt");
$file_bai = '';
$v_file_name = $file_type = '';
$file_size = 0;
if(isset($_FILES['file_bao_bai']) && $_FILES["file_bao_bai"]["name"]!=''){
$file = $_FILES['file_bao_bai'];
$folder = 'bao_bai';
$link_img_upload = safeupload($file,$folder);
if(!is_numeric($link_img_upload)){
//$link_img = $INFO['app_url'].'/'.$link_img_upload;
$link_img = $link_img_upload;
}else{
switch($link_img_upload){
case 1:
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'file_bao_bai cần nhỏ hơn 10MB';
echo jsonutf($arr_res);
exit();
break;
case 2:
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'file_bao_bai không đúng định dạng';
echo jsonutf($arr_res);
exit();
break;
case 3:
$arr_res['status'] = 'Error';
$arr_res['status_note'] = 'Máy chủ đầy dung lượng, không thể upload';
echo jsonutf($arr_res);
exit();
break;
default:
//$DOCUMENT_ROOT = str_replace('/public','',$_SERVER['DOCUMENT_ROOT']);
$DOCUMENT_ROOT = $_SERVER['DOCUMENT_ROOT'];
$arr_res['status'] = 'Error';
$arr_res['status_note'] = $DOCUMENT_ROOT;
echo jsonutf($arr_res);
exit();
break;
}
}
$file_type = $_FILES["file_lesson"]["type"];
$file_size = $_FILES["file_lesson"]["size"];
$v_file_name = $_FILES["file_lesson"]["name"];
$file_bai = $link_img;
}
if(!empty($file_bai)){
if($row_check2['TIET_COMMENT_FILE']!='' and file_exists($row_check2['TIET_COMMENT_FILE'])){
unlink($row_check2['TIET_COMMENT_FILE']);
}
$arr_parse = splitUrl($file_bai);
$TIET_DOMAIN = str_replace(array('https://','http://'),array('',''),$arr_parse['domain']);
$file_bai = $arr_parse['remaining_path'];
$file_bai = substr($file_bai, 1);
$arr_update_comment_file = array('TIET_COMMENT_FILE'=>$file_bai,'TIET_DOMAIN'=>$TIET_DOMAIN);
$DB->do_update('TB_TIET_COMMENT',$arr_update_comment_file, " WHERE TIET_ID='$tiet_id' ");
$arr_res['file_bao_bai'] = $file_bai;
$arr_res['file_bao_bai_domain'] = $TIET_DOMAIN;
}
$arr_res['status'] = 'Success';
$arr_res['status_note'] = 'Đã cập nhật sổ đầu bài';
$arr_res['lesson_id'] = $tiet_id;
$arr_res['lesson_title'] = html_entity_decode($lesson_title);
$arr_res['dan_do_bao_bai'] = html_entity_decode($lesson_comment);
echo jsonutf($arr_res);
exit();
/*$arr_insert_tiet = array('CLASS_ID'=>$v_tkb_CLASS_ID,'ROOM_ID'=>$v_tkb_ROOM_ID,'SCHOOL_ID'=>$v_school_id,'SUBJECT_ID'=>$v_tkb_SUBJECT_ID,'TIET_DATE'=>$v_tiet_date,'TIET_NUM'=>$v_tkb_TIET_NUM,'TEACHER_ID'=>$v_teacher_id,'RANK'=>0,'LESSION_TITLE'=>'','NOTE'=>'','LAST_UPDATE_TIME'=>date('Y-m-d H:i:s'),'TIET_PPCT'=>'','TIET_STATUS'=>$v_tiet_status,'TIET_ONTAP'=>0,'TIET_DATINHLUONG'=>0);
$DB->do_insert('TB_TIET',$arr_insert_tiet);*/
function splitUrl($url) {
$parsedUrl = parse_url($url);
$domain = '';
$remainingPath = '';
if (isset($parsedUrl['host'])) {
$domain = $parsedUrl['scheme'] . '://' . $parsedUrl['host'];
$remainingPath = isset($parsedUrl['path']) ? $parsedUrl['path'] : '';
if (isset($parsedUrl['query'])) {
$remainingPath .= '?' . $parsedUrl['query'];
}
if (isset($parsedUrl['fragment'])) {
$remainingPath .= '#' . $parsedUrl['fragment'];
}
} elseif (isset($parsedUrl['path'])) {
// Handle cases where the URL might just be a path
$parts = explode('/', $parsedUrl['path'], 2);
if (!empty($parts[0])) {
$domain = $parts[0];
$remainingPath = isset($parts[1]) ? '/' . $parts[1] : '';
}
}
return array('domain' => $domain, 'remaining_path' => $remainingPath);
}
?>