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 : /proc/self/root/var/www/html/api-truyentranh/includes/ |
<?php
function get_dtb_diem_moet_2021($v_pupil_id,$v_class_id,$v_khoi_id,$v_school_id,$v_hoc_ky,$v_learn_year){
global $DB,$arr_xep_loai_hoc_luc,$arr_hanh_kiem_value,$arr_danh_hieu_hoc_sinh,$arr_kqht,$arr_kqrl;
$row_school = $DB->fetch_row($DB->query("SELECT SCHOOL_BRAND FROM TB_SCHOOL WHERE SCHOOL_ID='$v_school_id' "));
$txt_brand = $row_school['SCHOOL_BRAND'];
$q_list_subject_hk1 = $DB->query("SELECT a.SUBJECT_ID,a.CTD,a.SOCONDIEMTX FROM TB_KHSB a RIGHT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID WHERE a.KHOI_ID='$v_khoi_id' AND a.HESOTD>0 ORDER BY b.SUBJECT_TYPE ASC,b.SUBJECT_ORDER DESC ");
$q_list_subject_hk2 = $DB->query("SELECT a.SUBJECT_ID,a.CTD_2 as CTD,a.SOCONDIEMTX FROM TB_KHSB a RIGHT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID WHERE a.KHOI_ID='$v_khoi_id' AND a.HESOTD>0 AND a.HESOTD_2 >0 ORDER BY b.SUBJECT_TYPE ASC,b.SUBJECT_ORDER DESC");
$list_subject = $arr_tmp = array();
$list_subject[1] = array();
$v_count_subject_1 = $v_count_subject_2 = 0;
while ($r_list_subject_hk1 = $DB->fetch_row($q_list_subject_hk1)){
$arr_tmp['SUBJECT_ID'] = $r_list_subject_hk1['SUBJECT_ID'];
if($r_list_subject_hk1['SUBJECT_ID']>0) {
$v_count_subject_1 = $v_count_subject_1 + 1;
}
$arr_tmp['CTD'] = $r_list_subject_hk1['CTD'];
$arr_tmp['SOCONDIEMTX'] = $r_list_subject_hk1['SOCONDIEMTX'];
$list_subject[1][] = $arr_tmp;
}
$arr_tmp = array();
$list_subject[2] = array();
while ($r_list_subject_hk2 = $DB->fetch_row($q_list_subject_hk2)){
$arr_tmp['SUBJECT_ID'] = $r_list_subject_hk2['SUBJECT_ID'];
if($r_list_subject_hk2['SUBJECT_ID']>0) {
$v_count_subject_2 = $v_count_subject_2 + 1;
}
$arr_tmp['CTD'] = $r_list_subject_hk2['CTD'];
$arr_tmp['SOCONDIEMTX'] = $r_list_subject_hk1['SOCONDIEMTX'];
$list_subject[2][] = $arr_tmp;
}
//hoc ky 1
$arr_tb_hk1 = $arr_all_mark_toan_van_nn_hk1 = array();
$arr_danhgia_hk1 = array();
//$arr_json=array();
if($v_hoc_ky==1) {
$check_count_ck_hk_1 = 0;
$mon_chua_co_diem_ck_1 = array();
foreach ($list_subject[1] as $val) {
$v_tmp_subject = $val['SUBJECT_ID'];
$v_tmp_ctd = $val['CTD'];
$v_socondiemtx = $val['SOCONDIEMTX'];
$v_check_toan_van_nn = get_subject_xeploai($v_tmp_subject, $v_school_id);
$v_gk_hk_1 = '';
$q_mark = $DB->query("SELECT MARK_VALUE,MARK_HESO FROM TB_MARK WHERE 1 AND PUPIL_ID='" . $v_pupil_id . "' AND SUBJECT_ID='" . $v_tmp_subject . "' AND MARK_HK='1' AND MARK_YEAR='" . $v_learn_year . "' ORDER BY MARK_LAST_UPDATE ASC ");
$arr_tx = array();
while ($r_mark = $DB->fetch_row($q_mark)) {
$v_ck_hk_1 = '';
if ($v_tmp_ctd != '0') {
if ($r_mark['MARK_VALUE'] == '7' or $r_mark['MARK_VALUE'] == '7.0') {
$r_mark['MARK_VALUE'] = 'Đ';
} else {
$r_mark['MARK_VALUE'] = 'CĐ';
}
} else {
}
if ($r_mark['MARK_HESO'] == '1') {
$arr_tx[] = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '2') {
$v_gk_hk_1 = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '3') {
$v_ck_hk_1 = $r_mark['MARK_VALUE'];
if($r_mark['MARK_VALUE']>0 or $r_mark['MARK_VALUE']=='Đ' or $r_mark['MARK_VALUE']=='CĐ'){
$check_count_ck_hk_1 = $check_count_ck_hk_1+1;
}else{
$mon_chua_co_diem_ck_1[] = $v_tmp_subject;
}
}
}
$v_tb_hk1 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 1), 1);
if ($v_tmp_ctd != '0') {
$arr_danhgia_hk1[] = intval($v_tb_hk1);
if ($v_tb_hk1 == '7' or $v_tb_hk1 == '7.0') {
$v_tb_hk1 = 'Đ';
} else {
$v_tb_hk1 = 'CĐ';
}
} else {
$arr_tb_hk1[] = $v_tb_hk1;
if ($v_check_toan_van_nn == 1) {
$arr_all_mark_toan_van_nn_hk1[] = $v_tb_hk1;
}
}
$txt_pucm_hk1 = get_pupil_comment($v_school_id, $v_pupil_id, 1000, 1, $v_learn_year);
$txt_subject_name = mb_convert_encoding(get_subject_name($v_tmp_subject, $v_school_id), "Windows-1252", "UTF-8");
$arr_diem_hk1[] = array('SUBJECT_ID' => $val['SUBJECT_ID'], 'SUBJECT_NAME' =>$txt_subject_name,'ddgtx'=>$arr_tx,'ddggk'=>$v_gk_hk_1,'ddgck'=>$v_ck_hk_1,'tbmhk'=>$v_tb_hk1);
}
$v_max_toan_van_hk1 = max($arr_all_mark_toan_van_nn_hk1);
$v_tbm_hk1 = array_sum($arr_tb_hk1) / count($arr_tb_hk1);
$v_min_tb_hk1 = min($arr_tb_hk1);
$v_kqht_hk1 = get_kqht($arr_tb_hk1, $arr_danhgia_hk1);
if ($v_kqht_hk1 == 5) {
$v_kqht_hk1 = 4;
}
$v_kqrl_hk1 = get_kqrl_hk($v_school_id, $v_pupil_id, 1, $v_learn_year);
//$arr_json['score_data'] =$arr_diem_hk1;
if($check_count_ck_hk_1==$v_count_subject_1) {
$arr_json['diem_trung_binh_hoc_ky'] = round($v_tbm_hk1, 1);
$arr_json['ket_qua_hoc_tap_hoc_ky'] = $arr_kqht[$v_kqht_hk1];
}else{
$arr_json['diem_trung_binh_hoc_ky'] = '';
$arr_json['ket_qua_hoc_tap_hoc_ky'] = '';
}
$arr_json['ket_qua_ren_luyen_hoc_ky'] = $arr_kqrl[$v_kqrl_hk1];
$arr_json['hoc_ky'] = 1;
$arr_json['diem_trung_binh_ca_nam'] = null;
$arr_json['xep_loai_hoc_luc_ca_nam'] = null;
$arr_json['xep_loai_hanh_kiem_ca_nam'] = null;
$arr_json['danhhieu_ca_nam'] = null;
$arr_json['ngay_nghi_ca_nam'] = null;
$arr_json['nhan_xet_gvcn_ca_nam'] = showutf($txt_pucm_hk1);
return $arr_json;
}
//hoc ky 2
if($v_hoc_ky!=1) {
$check_count_ck_hk_2 = 0;
$arr_tb_hk2 = $arr_tb_cn = $arr_diem_cn = $arr_danhgia_cn = $arr_all_mark_toan_van_nn_hk2 = $arr_all_mark_toan_van_nn_cn = array();
if(empty($list_subject[2])){
}else {
foreach ($list_subject[2] as $val) {
$v_tmp_subject = $val['SUBJECT_ID'];
$v_tmp_ctd = $val['CTD'];
$v_socondiemtx = $val['SOCONDIEMTX'];
$v_check_toan_van_nn = get_subject_xeploai($v_tmp_subject, $v_school_id);
$v_gk_hk_2 = '';
$q_mark = $DB->query("SELECT MARK_VALUE,MARK_HESO FROM TB_MARK WHERE 1 AND PUPIL_ID='" . $v_pupil_id . "' AND SUBJECT_ID='" . $v_tmp_subject . "' AND MARK_HK='2' AND MARK_YEAR='" . $v_learn_year . "' ORDER BY MARK_LAST_UPDATE ASC ");
$arr_tx = array();
while ($r_mark = $DB->fetch_row($q_mark)) {
if ($v_tmp_ctd != '0') {
if ($r_mark['MARK_VALUE'] >= '7' or $r_mark['MARK_VALUE'] == '7.0') {
$r_mark['MARK_VALUE'] = 'Đ';
} else {
$r_mark['MARK_VALUE'] = 'CĐ';
}
} else {
}
if ($r_mark['MARK_HESO'] == '1') {
$arr_tx[] = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '2') {
$v_gk_hk_2 = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '3') {
$v_ck_hk_2 = $r_mark['MARK_VALUE'];
if($r_mark['MARK_VALUE']>0 or $r_mark['MARK_VALUE']=='Đ' or $r_mark['MARK_VALUE']=='CĐ'){
$check_count_ck_hk_2 = $check_count_ck_hk_2+1;
}else{
$mon_chua_co_diem_ck_2[] = $v_tmp_subject;
}
}
}
$v_tb_hk1 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 1), 1);
$v_tb_hk2 = $v_tb_cn = '';
if (isset($v_ck_hk_2)) {
$v_tb_hk2 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 2), 1);
$v_tb_cn = round((($v_tb_hk2 * 2) + $v_tb_hk1) / 3, 1);
}
if ($v_tmp_ctd != '0') {
if ($v_tb_hk1 >= '7' or $v_tb_hk1 == '7.0') {
$v_tb_hk1 = 'Đ';
} else {
$v_tb_hk1 = 'CĐ';
}
$arr_danhgia_hk2 = $v_tb_hk2;
if ($v_tb_hk2 >= '7' or $v_tb_hk2 == '7.0') {
$v_tb_hk2 = 'Đ';
} else {
$v_tb_hk2 = 'CĐ';
}
$arr_danhgia_cn[] = $v_tb_cn;
if ($v_tb_cn >= '7' or $v_tb_cn == '7.0') {
$v_tb_cn = 'Đ';
} else {
$v_tb_cn = 'CĐ';
}
} else {
$arr_tb_hk2[] = $v_tb_hk2;
$arr_tb_cn[] = $v_tb_cn;
$arr_diem_cn[] = $v_tb_cn;
if ($v_check_toan_van_nn == 1) {
$arr_all_mark_toan_van_nn_hk2[] = $v_tb_hk2;
$arr_all_mark_toan_van_nn_cn[] = $v_tb_cn;
}
}
/*$txt_pucm_hk2 = get_pupil_comment($v_school_id, $v_pupil_id, $v_tmp_subject, 2, $v_learn_year);
if (!empty($txt_pucm_hk2)) {
}*/
$txt_subject_name = mb_convert_encoding(get_subject_name($v_tmp_subject, $v_school_id), "Windows-1252", "UTF-8");
$arr_diem_hk2[] = array('SUBJECT_ID' => $val['SUBJECT_ID'], 'SUBJECT_NAME' =>$txt_subject_name,'ddgtx'=>$arr_tx,'ddggk'=>$v_gk_hk_2,'ddgck'=>$v_ck_hk_2,'tbmhk'=>$v_tb_hk2);
}
$v_max_toan_van_hk2 = max($arr_all_mark_toan_van_nn_hk2);
$v_tb_hk2 = array_sum($arr_tb_hk2) / count($arr_tb_hk2);
$v_min_tb_hk2 = min($arr_tb_hk2);
$v_xlhl_2 = get_xep_loai_hoc_luc($v_tb_hk2, $v_min_tb_hk2, $v_max_toan_van_hk2);
$txt_show_tb_hk_2 = ($v_tb_hk2 > 0) ? round($v_tb_hk2, 1) : 'N/A';
$txt_hanhkiem_hk2 = get_hanh_kiem($v_pupil_id, $v_learn_year, 2);
$txt_danh_hieu_hk2 = get_xep_loai_chung($v_tb_hk2, $v_min_tb_hk2, $v_max_toan_van_hk2, $txt_hanhkiem_hk2);
$v_kqht_hk2 = get_kqht($arr_tb_hk2, $arr_danhgia_hk2);
$v_kqrl_hk2 = get_kqrl_hk($v_school_id, $v_pupil_id, 2, $v_learn_year);
if($v_count_subject_2==$check_count_ck_hk_2) {
$arr_json['diem_trung_binh_hoc_ky'] = round($v_tb_hk2, 1);
$arr_json['ket_qua_hoc_tap_hoc_ky'] = $arr_kqht[$v_kqht_hk2];
}else{
$arr_json['diem_trung_binh_hoc_ky'] = '';
$arr_json['ket_qua_hoc_tap_hoc_ky'] = '';
}
$arr_json['ket_qua_ren_luyen_hoc_ky'] = $arr_kqrl[$v_kqrl_hk2];
$arr_json['hoc_ky'] = 2;
$v_max_toan_van_cn = max($arr_all_mark_toan_van_nn_cn);
$v_tb_cn = array_sum($arr_tb_cn) / count($arr_tb_cn);
$v_min_tb_cn = min($arr_tb_cn);
$v_xlhl_cn = get_xep_loai_hoc_luc($v_tb_cn, $v_min_tb_cn, $v_max_toan_van_cn);
if($v_count_subject_2==$check_count_ck_hk_2) {
$txt_show_tb_cn = ($v_tb_cn > 0) ? round($v_tb_cn, 1) : '';
}else{
$txt_show_tb_cn = '';
}
$txt_hanhkiem_cn = get_hanh_kiem($v_pupil_id, $v_learn_year, 2);
$txt_danh_hieu_cn = get_xep_loai_chung($v_tb_cn, $v_min_tb_cn, $v_max_toan_van_cn,
$txt_hanhkiem_cn);
$v_kqht_cn = get_kqht($arr_diem_cn, $arr_danhgia_cn);
$txt_danh_hieu = '';
if ($v_kqht_cn == 5) {
$txt_danh_hieu = 'Học sinh Xuất sắc';
$v_kqht_cn = 4;
} elseif ($v_kqht_cn == 4) {
$txt_danh_hieu = 'Học sinh Giỏi';
}
$txt_pucm_cn = get_pupil_comment($v_school_id, $v_pupil_id, 1000, 2, $v_learn_year);
$v_ngay_bat_dau_nam_hoc = get_attribute_data('nbdnhm', 0, $v_school_id, date('Y-m-d'));
$row_ngay_nghi = $DB->fetch_row($DB->query("SELECT count(PUPIL_EVENT_ID) as TOTAL_NGHI FROM TB_PUPIL_EVENT WHERE (PUPIL_EVENT_SUB_TYPE=2 or PUPIL_EVENT_SUB_TYPE=1) AND PUPIL_EVENT_TYPE=5 AND PUPIL_ID='$v_pupil_id' AND PUPIL_EVENT_DATE BETWEEN " . $v_ngay_bat_dau_nam_hoc . " AND " . date('Y-m-d') . " "));
$arr_json['diem_trung_binh_ca_nam'] = $txt_show_tb_cn;
if(isset($v_xlhl_cn) and $v_xlhl_cn>1) {
$arr_json['xep_loai_hoc_luc_ca_nam'] = $arr_xep_loai_hoc_luc[$v_xlhl_cn];
}else{
$arr_json['xep_loai_hoc_luc_ca_nam'] = '';
}
$arr_json['xep_loai_hanh_kiem_ca_nam'] = $arr_hanh_kiem_value[$txt_hanhkiem_cn];
$arr_json['danhhieu_ca_nam'] = $txt_danh_hieu;
$arr_json['ngay_nghi_ca_nam'] = $row_ngay_nghi['TOTAL_NGHI'];
$arr_json['nhan_xet_gvcn_ca_nam'] = showutf($txt_pucm_cn);
}
return $arr_json;
}
}
function get_diem_moet_2021($v_pupil_id,$v_class_id,$v_khoi_id,$v_school_id,$v_hoc_ky,$v_learn_year){
global $DB,$arr_xep_loai_hoc_luc,$arr_hanh_kiem_value,$arr_danh_hieu_hoc_sinh,$arr_kqht,$arr_kqrl;
$row_school = $DB->fetch_row($DB->query("SELECT SCHOOL_BRAND FROM TB_SCHOOL WHERE SCHOOL_ID='$v_school_id' "));
$txt_brand = $row_school['SCHOOL_BRAND'];
$q_list_subject_hk1 = $DB->query("SELECT a.SUBJECT_ID,a.CTD,a.SOCONDIEMTX FROM TB_KHSB a RIGHT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID WHERE a.KHOI_ID='$v_khoi_id' AND a.HESOTD>0 ORDER BY b.SUBJECT_TYPE ASC,b.SUBJECT_ORDER DESC ");
$q_list_subject_hk2 = $DB->query("SELECT a.SUBJECT_ID,a.CTD_2 as CTD,a.SOCONDIEMTX FROM TB_KHSB a RIGHT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID WHERE a.KHOI_ID='$v_khoi_id' AND a.HESOTD>0 AND a.HESOTD_2 >0 ORDER BY b.SUBJECT_TYPE ASC,b.SUBJECT_ORDER DESC");
$list_subject = $arr_tmp = array();
$list_subject[1] = array();
while ($r_list_subject_hk1 = $DB->fetch_row($q_list_subject_hk1)){
$arr_tmp['SUBJECT_ID'] = $r_list_subject_hk1['SUBJECT_ID'];
$arr_tmp['CTD'] = $r_list_subject_hk1['CTD'];
$arr_tmp['SOCONDIEMTX'] = $r_list_subject_hk1['SOCONDIEMTX'];
$list_subject[1][] = $arr_tmp;
}
$arr_tmp = array();
$list_subject[2] = array();
while ($r_list_subject_hk2 = $DB->fetch_row($q_list_subject_hk2)){
$arr_tmp['SUBJECT_ID'] = $r_list_subject_hk2['SUBJECT_ID'];
$arr_tmp['CTD'] = $r_list_subject_hk2['CTD'];
$arr_tmp['SOCONDIEMTX'] = $r_list_subject_hk1['SOCONDIEMTX'];
$list_subject[2][] = $arr_tmp;
}
$arr_tb_hk1 = $arr_all_mark_toan_van_nn_hk1 = array();
$arr_danhgia_hk1 = array();
if($v_hoc_ky==1) {
foreach ($list_subject[1] as $val) {
$v_tmp_subject = $val['SUBJECT_ID'];
$v_tmp_ctd = $val['CTD'];
$v_socondiemtx = $val['SOCONDIEMTX'];
$v_check_toan_van_nn = get_subject_xeploai($v_tmp_subject, $v_school_id);
$v_gk_hk_1 = $v_ck_hk_1 = '';
$q_mark = $DB->query("SELECT MARK_VALUE,MARK_HESO FROM TB_MARK WHERE 1 AND PUPIL_ID='" . $v_pupil_id . "' AND SUBJECT_ID='" . $v_tmp_subject . "' AND MARK_HK='1' AND MARK_YEAR='" . $v_learn_year . "' ORDER BY MARK_LAST_UPDATE ASC ");
$arr_tx = array();
while ($r_mark = $DB->fetch_row($q_mark)) {
if ($v_tmp_ctd != '0') {
if ($r_mark['MARK_VALUE'] == '7' or $r_mark['MARK_VALUE'] == '7.0') {
$r_mark['MARK_VALUE'] = 'Đ';
} else {
$r_mark['MARK_VALUE'] = 'CĐ';
}
} else {
}
if ($r_mark['MARK_HESO'] == '1') {
$arr_tx[] = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '2') {
$v_gk_hk_1 = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '3') {
$v_ck_hk_1 = $r_mark['MARK_VALUE'];
}
}
$v_tb_hk1 = '';
if (isset($v_ck_hk_1)) {
$v_tb_hk1 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 1), 1);
}else{
$v_tb_hk1 = '';
}
if ($v_tmp_ctd != '0') {
$arr_danhgia_hk1[] = intval($v_tb_hk1);
if ($v_tb_hk1 == '7' or $v_tb_hk1 == '7.0') {
$v_tb_hk1 = 'Đ';
} else {
$v_tb_hk1 = 'CĐ';
}
} else {
$arr_tb_hk1[] = $v_tb_hk1;
if ($v_check_toan_van_nn == 1) {
$arr_all_mark_toan_van_nn_hk1[] = $v_tb_hk1;
}
}
$txt_pucm_hk1 = showutf(get_pupil_comment($v_school_id, $v_pupil_id, $v_tmp_subject, 1, $v_learn_year));
$txt_subject_name = showutf(get_subject_name($v_tmp_subject, $v_school_id));
$arr_diem_hk1[] = array('SUBJECT_ID' => $val['SUBJECT_ID'], 'SUBJECT_NAME' =>$txt_subject_name,'ddgtx'=>$arr_tx,'ddggk'=>$v_gk_hk_1,'ddgck'=>$v_ck_hk_1,'tbmhk'=>$v_tb_hk1);
}
$v_max_toan_van_hk1 = max($arr_all_mark_toan_van_nn_hk1);
$v_tb_hk1 = array_sum($arr_tb_hk1) / count($arr_tb_hk1);
$v_min_tb_hk1 = min($arr_tb_hk1);
$v_kqht_hk1 = get_kqht($arr_tb_hk1, $arr_danhgia_hk1);
if ($v_kqht_hk1 == 5) {
$v_kqht_hk1 = 4;
}
$v_kqrl_hk1 = get_kqrl_hk($v_school_id, $v_pupil_id, 1, $v_learn_year);
$arr_json['score_data'] =$arr_diem_hk1;
$arr_json['kqht'] = $arr_kqht[$v_kqht_hk1];
$arr_json['kqrl'] = $arr_kqrl[$v_kqrl_hk1];
$arr_json['comment_gvcn'] = get_pupil_comment($v_school_id,$v_pupil_id,1000,1,$v_learn_year);
$arr_json['hoc_ky'] = 1;
$arr_json['dtb_cn'] = null;
$arr_json['xlhl_cn'] = null;
$arr_json['xlhk_cn'] = null;
$arr_json['danhhieu_cn'] = null;
$arr_json['ngay_nghi_cn'] = null;
$arr_json['nhan_xet_gvcn_cn'] = null;
return $arr_json;
}
//hoc ky 2
if($v_hoc_ky!=1) {
$arr_tb_hk2 = $arr_tb_cn = $arr_diem_cn = $arr_danhgia_cn = $arr_all_mark_toan_van_nn_hk2 = $arr_all_mark_toan_van_nn_cn = array();
if(empty($list_subject[2])){
}else {
foreach ($list_subject[2] as $val) {
$v_tmp_subject = $val['SUBJECT_ID'];
$v_tmp_ctd = $val['CTD'];
$v_socondiemtx = $val['SOCONDIEMTX'];
$v_check_toan_van_nn = get_subject_xeploai($v_tmp_subject, $v_school_id);
$v_gk_hk_2 = '';
$q_mark = $DB->query("SELECT MARK_VALUE,MARK_HESO FROM TB_MARK WHERE 1 AND PUPIL_ID='" . $v_pupil_id . "' AND SUBJECT_ID='" . $v_tmp_subject . "' AND MARK_HK='2' AND MARK_YEAR='" . $v_learn_year . "' ORDER BY MARK_LAST_UPDATE ASC ");
$arr_tx = array();
while ($r_mark = $DB->fetch_row($q_mark)) {
if ($v_tmp_ctd != '0') {
if ($r_mark['MARK_VALUE'] >= '7' or $r_mark['MARK_VALUE'] == '7.0') {
$r_mark['MARK_VALUE'] = 'Đ';
} else {
$r_mark['MARK_VALUE'] = 'CĐ';
}
} else {
}
if ($r_mark['MARK_HESO'] == '1') {
$arr_tx[] = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '2') {
$v_gk_hk_2 = $r_mark['MARK_VALUE'];
}
if ($r_mark['MARK_HESO'] == '3') {
$v_ck_hk_2 = $r_mark['MARK_VALUE'];
}
}
$v_tb_hk1 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 1), 1);
$v_tb_hk2 = $v_tb_cn = '';
if (isset($v_ck_hk_2)) {
$v_tb_hk2 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 2), 1);
$v_tb_cn = round((($v_tb_hk2 * 2) + $v_tb_hk1) / 3, 1);
}
if ($v_tmp_ctd != '0') {
if ($v_tb_hk1 >= '7' or $v_tb_hk1 == '7.0') {
$v_tb_hk1 = 'Đ';
} else {
$v_tb_hk1 = 'CĐ';
}
$arr_danhgia_hk2 = $v_tb_hk2;
if ($v_tb_hk2 >= '7' or $v_tb_hk2 == '7.0') {
$v_tb_hk2 = 'Đ';
} else {
$v_tb_hk2 = 'CĐ';
}
$arr_danhgia_cn[] = $v_tb_cn;
if ($v_tb_cn >= '7' or $v_tb_cn == '7.0') {
$v_tb_cn = 'Đ';
} else {
$v_tb_cn = 'CĐ';
}
} else {
$arr_tb_hk2[] = $v_tb_hk2;
$arr_tb_cn[] = $v_tb_cn;
$arr_diem_cn[] = $v_tb_cn;
if ($v_check_toan_van_nn == 1) {
$arr_all_mark_toan_van_nn_hk2[] = $v_tb_hk2;
$arr_all_mark_toan_van_nn_cn[] = $v_tb_cn;
}
}
$txt_pucm_hk2 = showutf(get_pupil_comment($v_school_id, $v_pupil_id, $v_tmp_subject, 2, $v_learn_year));
$txt_subject_name = showutf(get_subject_name($v_tmp_subject, $v_school_id));
$arr_diem_hk2[] = array('SUBJECT_ID' => $val['SUBJECT_ID'], 'SUBJECT_NAME' =>$txt_subject_name,'ddgtx'=>$arr_tx,'ddggk'=>$v_gk_hk_2,'ddgck'=>$v_ck_hk_2,'tbmhk'=>$v_tb_hk2);
}
$v_max_toan_van_hk2 = max($arr_all_mark_toan_van_nn_hk2);
$v_tb_hk2 = array_sum($arr_tb_hk2) / count($arr_tb_hk2);
$v_min_tb_hk2 = min($arr_tb_hk2);
$v_xlhl_2 = get_xep_loai_hoc_luc($v_tb_hk2, $v_min_tb_hk2, $v_max_toan_van_hk2);
$txt_show_tb_hk_2 = ($v_tb_hk2 > 0) ? round($v_tb_hk2, 1) : 'N/A';
$txt_hanhkiem_hk2 = get_hanh_kiem($v_pupil_id, $v_learn_year, 2);
$txt_danh_hieu_hk2 = get_xep_loai_chung($v_tb_hk2, $v_min_tb_hk2, $v_max_toan_van_hk2, $txt_hanhkiem_hk2);
$v_kqht_hk2 = get_kqht($arr_tb_hk2, $arr_danhgia_hk2);
$v_kqrl_hk2 = get_kqrl_hk($v_school_id, $v_pupil_id, 2, $v_learn_year);
$txt_pucm_cn = get_pupil_comment($v_school_id, $v_pupil_id, 1000, 2, $v_learn_year);
$arr_json['score_data'] = $arr_diem_hk2;
$arr_json['kqht'] = $arr_kqht[$v_kqht_hk2];
$arr_json['kqrl'] = $arr_kqrl[$v_kqrl_hk2];
$arr_json['comment_gvcn'] = $txt_pucm_cn;
$arr_json['hoc_ky'] = 2;
$v_max_toan_van_cn = max($arr_all_mark_toan_van_nn_cn);
$v_tb_cn = array_sum($arr_tb_cn) / count($arr_tb_cn);
$v_min_tb_cn = min($arr_tb_cn);
$v_xlhl_cn = get_xep_loai_hoc_luc($v_tb_cn, $v_min_tb_cn, $v_max_toan_van_cn);
$txt_show_tb_cn = ($v_tb_cn > 0) ? round($v_tb_cn, 1) : 'N/A';
$txt_hanhkiem_cn = get_hanh_kiem($v_pupil_id, $v_learn_year, 2);
$txt_danh_hieu_cn = get_xep_loai_chung($v_tb_cn, $v_min_tb_cn, $v_max_toan_van_cn,
$txt_hanhkiem_cn);
$v_kqht_cn = get_kqht($arr_diem_cn, $arr_danhgia_cn);
$txt_danh_hieu = '';
if ($v_kqht_cn == 5) {
$txt_danh_hieu = 'Học sinh Xuất sắc';
$v_kqht_cn = 4;
} elseif ($v_kqht_cn == 4) {
$txt_danh_hieu = 'Học sinh Giỏi';
}
$arr_json['dtb_cn'] = $txt_show_tb_cn;
if(isset($v_xlhl_cn) and $v_xlhl_cn>1) {
$arr_json['xlhl_cn'] = $arr_xep_loai_hoc_luc[$v_xlhl_cn];
}else{
$arr_json['xlhl_cn'] = '';
}
$arr_json['xlhk_cn'] = $arr_hanh_kiem_value[$txt_hanhkiem_cn];
$arr_json['danhhieu_cn'] = $txt_danh_hieu;
//$arr_json['ngay_nghi_cn'] = $row_ngay_nghi['TOTAL_NGHI'];
$arr_json['nhan_xet_gvcn_cn'] = $txt_pucm_cn;
}
return $arr_json;
}
}
function get_diem_moet($v_pupil_id,$v_class_id,$v_khoi_id,$v_school_id,$v_hoc_ky,$v_learn_year){
global $DB,$arr_xep_loai_hoc_luc,$arr_hanh_kiem_value,$arr_danh_hieu_hoc_sinh;
$arr_khoa_diem = get_expiresday_mark($v_school_id, $v_learn_year);
$khoa_diem_hk_1 = $khoa_diem_hk_2 = 0;
if(isset($arr_khoa_diem[1]) and strtotime($arr_khoa_diem[1])<=time()){
$khoa_diem_hk_1 = 1;
}
if(isset($arr_khoa_diem[2]) and strtotime($arr_khoa_diem[2])<=time()){
$khoa_diem_hk_2 = 1;
}
$txt_brand = get_school_brand($v_school_id);
$q_list_subject_hk1 = $DB->query("SELECT a.SUBJECT_ID,a.CTD,a.SOCONDIEMTX FROM TB_KHSB a RIGHT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID WHERE a.KHOI_ID='$v_khoi_id' AND a.HESOTD>0 ORDER BY b.SUBJECT_TYPE ASC,b.SUBJECT_ORDER DESC ");
$q_list_subject_hk2 = $DB->query("SELECT a.SUBJECT_ID,a.CTD_2 as CTD,a.SOCONDIEMTX FROM TB_KHSB a RIGHT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID WHERE a.KHOI_ID='$v_khoi_id' AND a.HESOTD>0 AND a.HESOTD_2 >0 ORDER BY b.SUBJECT_TYPE ASC,b.SUBJECT_ORDER DESC");
$list_subject = $arr_tmp = array();
$list_subject[1] = array();
while ($r_list_subject_hk1 = $DB->fetch_row($q_list_subject_hk1)){
$arr_tmp['SUBJECT_ID'] = $r_list_subject_hk1['SUBJECT_ID'];
$arr_tmp['CTD'] = $r_list_subject_hk1['CTD'];
$arr_tmp['SOCONDIEMTX'] = $r_list_subject_hk1['SOCONDIEMTX'];
$list_subject[1][] = $arr_tmp;
}
//return "SELECT SUBJECT_ID,CTD FROM TB_KHSB WHERE KHOI_ID='$v_khoi_id' AND HESOTD>0 ";
$arr_tmp = array();
$list_subject[2] = array();
while ($r_list_subject_hk2 = $DB->fetch_row($q_list_subject_hk2)){
$arr_tmp['SUBJECT_ID'] = $r_list_subject_hk2['SUBJECT_ID'];
$arr_tmp['CTD'] = $r_list_subject_hk2['CTD'];
$arr_tmp['SOCONDIEMTX'] = $r_list_subject_hk1['SOCONDIEMTX'];
$list_subject[2][] = $arr_tmp;
}
//hoc ky 1
$arr_tb_hk1 = $arr_all_mark_toan_van_nn_hk1 = array();
$txt_diem_hk1 = '<table class="table table-responsive mt-2">
<tr><th colspan="5">Kết quả học kỳ 1 - Năm học '.$v_learn_year.' - Lớp '.get_class_full_name($v_class_id).'</th></tr>
<tr><th>Môn học</th><th>ĐĐGtx</th><th>ĐĐGgk</th><th>ĐĐGck</th><th>TBMhk1</th></tr>';
foreach($list_subject[1] as $val){
$v_gk_hk_1 = $v_ck_hk_1 = '';
$v_tmp_subject = $val['SUBJECT_ID'];
$v_tmp_ctd = $val['CTD'];
$v_socondiemtx = $val['SOCONDIEMTX'];
$v_check_toan_van_nn = get_subject_xeploai($v_tmp_subject,$v_school_id);
$q_mark = $DB->query("SELECT MARK_VALUE,MARK_HESO FROM TB_MARK WHERE 1 AND PUPIL_ID='".$v_pupil_id."' AND SUBJECT_ID='".$v_tmp_subject."' AND MARK_HK='1' AND MARK_YEAR='".$v_learn_year."' ORDER BY MARK_LAST_UPDATE ASC ");
$arr_tx = array();
while ($r_mark = $DB->fetch_row($q_mark)) {
if($v_tmp_ctd!='0'){
if($r_mark['MARK_VALUE']=='7' or $r_mark['MARK_VALUE']=='7.0'){
$r_mark['MARK_VALUE'] = 'Đ';
}else{
$r_mark['MARK_VALUE'] = 'CĐ';
}
}else{
}
if($r_mark['MARK_HESO'] == '1') {
$arr_tx[] = $r_mark['MARK_VALUE'];
}
if($r_mark['MARK_HESO'] == '2') {
$v_gk_hk_1 = $r_mark['MARK_VALUE'];
}
if($r_mark['MARK_HESO'] == '3') {
$v_ck_hk_1 = $r_mark['MARK_VALUE'];
}
}
$v_tb_hk1 = 'n/a';
if(isset($v_ck_hk_1)) {
$v_tb_hk1 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 1), 1);
}
if($v_tmp_ctd!='0'){
if($v_tb_hk1=='7' or $v_tb_hk1=='7.0'){
$v_tb_hk1 = 'Đ';
}else{
$v_tb_hk1 = 'CĐ';
}
}else{
$arr_tb_hk1[] = $v_tb_hk1;
if($v_check_toan_van_nn==1){
$arr_all_mark_toan_van_nn_hk1[] = $v_tb_hk1;
}
}
$txt_diem_hk1 .= '<tr><td>' . get_subject_name($v_tmp_subject, $v_school_id) . '</td><td>'.implode(' ',$arr_tx).'</td><td>'.$v_gk_hk_1.'</td><td>'.$v_ck_hk_1.'</td><td>'.$v_tb_hk1.'</td></tr>';
$txt_pucm_hk1 = get_pupil_comment($v_school_id,$v_pupil_id,$v_tmp_subject,1);
if(!empty($txt_pucm_hk1)) {
$txt_diem_hk1 .= '<tr><td colspan="5">' . $txt_pucm_hk1 . '</td></tr>';
}
}
$v_max_toan_van_hk1 = max($arr_all_mark_toan_van_nn_hk1);
$v_tb_hk1 = array_sum($arr_tb_hk1)/count($arr_tb_hk1);
$v_tb_hk1 = round($v_tb_hk1,1);
$v_min_tb_hk1 = min($arr_tb_hk1);
//$v_xlhl_1 = get_xep_loai_hoc_luc($v_tb_hk1,$v_min_tb_hk1,$v_max_toan_van_hk1);
$txt_show_tb_hk_1 = ($v_tb_hk1>0)?round($v_tb_hk1,1):'N/A';
$v_xlhl_1 = get_xep_loai_hoc_luc($txt_show_tb_hk_1,$v_min_tb_hk1,$v_max_toan_van_hk1);
$txt_hanhkiem_hk1 = get_hanh_kiem($v_pupil_id,$v_learn_year,1);
$txt_danh_hieu_hk1 = get_xep_loai_chung($v_tb_hk1,$v_min_tb_hk1,$v_max_toan_van_hk1,$txt_hanhkiem_hk1);
$txt_diem_hk1 .= '<tr><th>TB các môn</th><th>Học lực</th><th>Hạnh kiểm</th><th colspan="2">Danh hiệu</th></tr>';
$txt_diem_tb_show_tb_hk_1 = $txt_xep_loai_hoc_luc_1=$txt_danh_hieu_1='--';
if($khoa_diem_hk_1==1){
$txt_diem_tb_show_tb_hk_1 = $txt_show_tb_hk_1;
$txt_xep_loai_hoc_luc_1 = $arr_xep_loai_hoc_luc[$v_xlhl_1];
$txt_danh_hieu_1 = $arr_danh_hieu_hoc_sinh[$txt_danh_hieu_hk1];
}
$txt_diem_hk1 .= '<tr><td>'.$txt_diem_tb_show_tb_hk_1.'</td><td>'.$txt_xep_loai_hoc_luc_1.'</td><td>'.$arr_hanh_kiem_value[$txt_hanhkiem_hk1].'</td><td colspan="2">'.$txt_danh_hieu_1.'</td></tr></table>';
//hoc ky 2
$arr_tb_hk2 = $arr_tb_cn = $arr_all_mark_toan_van_nn_hk2 = $arr_all_mark_toan_van_nn_cn = array();
if(empty($list_subject[2])){
$txt_diem_hk2 = '<p>Chưa có điểm hoặc trường chưa cấu hình hệ số điểm môn học học kỳ 2, phụ huynh liên hệ trường để biết thêm thông tin.</p>';
}else{
$txt_diem_hk2 = '<table class="table table-responsive mt-5">
<tr><th colspan="7">Kết quả học kỳ 2 - Năm học '.$v_learn_year.' - Lớp '.get_class_full_name($v_class_id).'</th></tr>
<tr><th>Môn</th><th>tx</th><th>gk</th><th>ck</th><th>hk1</th><th>hk2</th><th>cn</th></tr>';
foreach($list_subject[2] as $val){
$v_gk_hk_2 = $v_ck_hk_2 = '';
$v_tmp_subject = $val['SUBJECT_ID'];
$v_tmp_ctd = $val['CTD'];
$v_socondiemtx = $val['SOCONDIEMTX'];
$v_check_toan_van_nn = get_subject_xeploai($v_tmp_subject,$v_school_id);
$q_mark = $DB->query("SELECT MARK_VALUE,MARK_HESO FROM TB_MARK WHERE 1 AND PUPIL_ID='".$v_pupil_id."' AND SUBJECT_ID='".$v_tmp_subject."' AND MARK_HK='2' AND MARK_YEAR='".$v_learn_year."' ORDER BY MARK_LAST_UPDATE ASC ");
$arr_tx = array();
while ($r_mark = $DB->fetch_row($q_mark)) {
if($v_tmp_ctd!='0'){
if($r_mark['MARK_VALUE']>='7' or $r_mark['MARK_VALUE']=='7.0'){
$r_mark['MARK_VALUE'] = 'Đ';
}else{
$r_mark['MARK_VALUE'] = 'CĐ';
}
}else{
}
if($r_mark['MARK_HESO'] == '1') {
$arr_tx[] = $r_mark['MARK_VALUE'];
}
if($r_mark['MARK_HESO'] == '2') {
$v_gk_hk_2 = $r_mark['MARK_VALUE'];
}
if($r_mark['MARK_HESO'] == '3') {
$v_ck_hk_2 = $r_mark['MARK_VALUE'];
}
}
$v_tb_hk1 = round(get_mark_avg($v_pupil_id,$v_tmp_subject,$v_learn_year,1),1);
$v_tb_hk2 = $v_tb_cn = 'n/a';
if(isset($v_ck_hk_2)) {
$v_tb_hk2 = round(get_mark_avg($v_pupil_id, $v_tmp_subject, $v_learn_year, 2), 1);
$v_tb_cn = round((($v_tb_hk2 * 2) + $v_tb_hk1) / 3, 1);
}
//$v_tb_cn = round(get_mark_avg($v_pupil_id,$v_subject_id,$v_current_learn_year,3),1);
if($v_tmp_ctd!='0'){
if($v_tb_hk1>='7' or $v_tb_hk1=='7.0'){
$v_tb_hk1 = 'Đ';
}else{
$v_tb_hk1 = 'CĐ';
}
if($v_tb_hk2>='7' or $v_tb_hk2=='7.0'){
$v_tb_hk2 = 'Đ';
}else{
$v_tb_hk2 = 'CĐ';
}
if($v_tb_cn>='7' or $v_tb_cn=='7.0'){
$v_tb_cn = 'Đ';
}else{
$v_tb_cn = 'CĐ';
}
}else{
$arr_tb_hk2[] = $v_tb_hk2;
$arr_tb_cn[] = $v_tb_cn;
if($v_check_toan_van_nn==1){
$arr_all_mark_toan_van_nn_hk2[] = $v_tb_hk2;
$arr_all_mark_toan_van_nn_cn[] = $v_tb_cn;
}
}
$txt_diem_hk2 .= '<tr><td>' . get_subject_name($v_tmp_subject, $v_school_id) . '</td><td>'.implode(' ',$arr_tx).'</td><td>'.$v_gk_hk_2.'</td><td>'.$v_ck_hk_2.'</td><td>'.$v_tb_hk1.'</td><td>'.$v_tb_hk2.'</td><td>'.$v_tb_cn.'</td></tr>';
$txt_pucm_hk2 = get_pupil_comment($v_school_id,$v_pupil_id,$v_tmp_subject,2);
if(!empty($txt_pucm_hk2)) {
$txt_diem_hk2 .= '<tr><td colspan="7">' . $txt_pucm_hk2 . '</td></tr>';
}
}
$v_max_toan_van_hk2 = max($arr_all_mark_toan_van_nn_hk2);
$v_tb_hk2 = array_sum($arr_tb_hk2)/count($arr_tb_hk2);
$v_tb_hk2 = round($v_tb_hk2,1);
$v_min_tb_hk2 = min($arr_tb_hk2);
$v_xlhl_2 = get_xep_loai_hoc_luc($v_tb_hk2,$v_min_tb_hk2,$v_max_toan_van_hk2);
$txt_show_tb_hk_2 = ($v_tb_hk2>0)?round($v_tb_hk2,1):'N/A';
$txt_hanhkiem_hk2 = get_hanh_kiem($v_pupil_id,$v_learn_year,2);
$txt_danh_hieu_hk2 = get_xep_loai_chung($v_tb_hk2,$v_min_tb_hk2,$v_max_toan_van_hk2,$txt_hanhkiem_hk2);
$txt_diem_hk2 .= '<tr><th colspan="2">TB các môn</th><th>Học lực</th><th>Hạnh kiểm</th><th colspan="3">Danh hiệu</th></tr>';
$txt_diem_tb_show_tb_hk_2 = $txt_xep_loai_hoc_luc_2=$txt_danh_hieu_2='--';
if($khoa_diem_hk_2==1){
$txt_diem_tb_show_tb_hk_2 = $txt_show_tb_hk_2;
$txt_xep_loai_hoc_luc_2 = $arr_xep_loai_hoc_luc[$v_xlhl_2];
$txt_danh_hieu_2 = $arr_danh_hieu_hoc_sinh[$txt_danh_hieu_hk2];
}
$txt_diem_hk2 .= '<tr><td colspan="2">'.$txt_diem_tb_show_tb_hk_2.'</td><td>'.$txt_xep_loai_hoc_luc_2.'</td><td>'.$arr_hanh_kiem_value[$txt_hanhkiem_hk2].'</td><td colspan="3">'.$txt_danh_hieu_2.'</td></tr>';
$v_max_toan_van_cn = max($arr_all_mark_toan_van_nn_cn);
$v_tb_cn = array_sum($arr_tb_cn)/count($arr_tb_cn);
$v_tb_cn = round($v_tb_cn,1);
$v_min_tb_cn = min($arr_tb_cn);
$v_xlhl_cn = get_xep_loai_hoc_luc($v_tb_cn,$v_min_tb_cn,$v_max_toan_van_cn);
$txt_show_tb_cn = ($v_tb_cn>0)?round($v_tb_cn,1):'N/A';
$txt_hanhkiem_cn = get_hanh_kiem($v_pupil_id,$v_learn_year,2);
$txt_danh_hieu_cn = get_xep_loai_chung($v_tb_cn,$v_min_tb_cn,$v_max_toan_van_cn,$txt_hanhkiem_cn);
$txt_pucm_cn = get_pupil_comment($v_school_id,$v_pupil_id,100,2);
$v_ngay_bat_dau_nam_hoc = get_attribute_data('nbdnhm',0,$v_school_id,date('Y-m-d'));
$row_ngay_nghi = $DB->fetch_row($DB->query("SELECT count(PUPIL_EVENT_ID) as TOTAL_NGHI FROM TB_PUPIL_EVENT WHERE (PUPIL_EVENT_SUB_TYPE=2 or PUPIL_EVENT_SUB_TYPE=1) AND PUPIL_EVENT_TYPE=5 AND PUPIL_ID='$v_pupil_id' AND PUPIL_EVENT_DATE BETWEEN " . $v_ngay_bat_dau_nam_hoc . " AND " . date('Y-m-d') . " "));
$txt_diem_hk2 .= '<tr><th colspan="7">Tổng kết năm học</th></tr><tr><td colspan="5">Điểm trung bình cả năm</td><td colspan="2">'.$txt_show_tb_cn.'</td></tr><tr><td colspan="5">Xếp loại học lực</td><td colspan="2">'.$arr_xep_loai_hoc_luc[$v_xlhl_cn].'</td></tr><tr><td colspan="5">Xếp loại hạnh kiểm</td><td colspan="2">'.$arr_hanh_kiem_value[$txt_hanhkiem_cn].' </td></tr><tr><td colspan="5">Danh hiệu cả năm</td><td colspan="2">'.$arr_danh_hieu_hoc_sinh[$txt_danh_hieu_cn].' </td></tr><tr><td colspan="5">Ngày nghỉ</td><td colspan="2">'.$row_ngay_nghi['TOTAL_NGHI'].'</td></tr><tr><td colspan="2">Nhận xét của gvcn</td></tr><tr><td colspan="5">'.$txt_pucm_cn.'</td></tr></table>';
}
if($v_hoc_ky==1){
return $txt_diem_hk1;
}else {
return $txt_diem_hk2;
}
}
function get_diem_tieu_hoc($v_pupil_id,$v_class_id,$v_khoi_id,$v_school_id,$v_hoc_ky,$v_learn_year){
global $DB;
$arr_hanh_kiem_th_type = array('tu_chu_va_tu_hoc'=>'Tự chủ và tự học','giao_tiep_va_hop_tac'=>'Giao tiếp và hợp tác','giai_quyet_van_de_va_sang_tao'=>'Giải quyết vấn đề và sáng tạo','ngon_ngu'=>'Ngôn ngữ','tinh_toan'=>'Tính toán','khoa_hoc'=>'Khoa học',
'cong_nghe'=>'Công nghệ', 'tin_hoc'=>'Tin học',
'tham_my'=>'Thẩm mỹ','the_chat'=>'Thể chất','yeu_nuoc'=>'Yêu nước','nhan_ai'=>'Nhân ái','cham_chi'=>'Chăm chỉ','trung_thuc'=>'Trung thực','trach_nhiem'=>'Trách nhiệm','nhan_xet_chung_cua_gvcn'=>'Nhận xét chung của giáo viên chủ nhiệm');
$txt_brand = get_school_brand($v_school_id);
$arr_monhoc = array('T'=>'Hoàn thành tốt(T)','H'=>'Hoàn thành(H)','C'=>'Chưa hoàn thành(C)');
$arr_nangluc = array('T'=>'Tốt(T)','D'=>'Đạt(D)','C'=>'Cần cố gắng(C)');
if($v_hoc_ky==1){
$check_hesotd2 = ' AND a.HESOTD>0 ';
}else{
$check_hesotd2 = ' AND a.HESOTD>0 AND a.HESOTD_2>0 ';
}
$arr_json['hanhkiem_th_category_diem'][0] = array('category_id'=>'nang_luc_cot_loi','category_name'=>'Năng lực cốt lõi',
'sub_category'=>array(array('sub_category_id'=>'nang_luc_chung','sub_category_name'=>'Năng lực chung'),array('sub_category_id'=>'nang_luc_dac_thu','sub_category_name'=>'Năng lực đặc thù'))
);
$arr_json['hanhkiem_th_category_diem'][1] = array('category_id'=>'pham_chat_chu_yeu','category_name'=>'Phẩm chất chủ yếu'
);
$arr_hanh_kiem_th_type_json[0] = array(
'category_id'=>'nang_luc_cot_loi','sub_category_id'=>'nang_luc_chung',
'items'=>array(
array('item_id'=>'tu_chu_va_tu_hoc','item_name'=>'Tự chủ và tự học học'),
array('item_id'=>'giao_tiep_va_hop_tac','item_name'=>'Giao tiếp và hợp tác'),
array('item_id'=>'giai_quyet_van_de_va_sang_tao','item_name'=>'Giải quyết vấn đề và sáng tạo')
)
);
$arr_hanh_kiem_th_type_json[1] = array(
'category_id'=>'nang_luc_cot_loi','sub_category_id'=>'nang_luc_dac_thu',
'items'=>array(
array('item_id'=>'ngon_ngu','item_name'=>'Ngôn ngữ'),
array('item_id'=>'tinh_toan','item_name'=>'Tính toán'),
array('item_id'=>'khoa_hoc','item_name'=>'Khoa học'),
array('item_id'=>'cong_nghe','item_name'=>'Công nghệ'),
array('item_id'=>'tin_hoc','item_name'=>'Tin học'),
array('item_id'=>'tham_my','item_name'=>'Thẩm mỹ'),
array('item_id'=>'the_chat','item_name'=>'Thể chất')
)
);
$arr_hanh_kiem_th_type_json[3] = array(
'category_id'=>'pham_chat_chu_yeu',
'items'=>array(
array('item_id'=>'yeu_nuoc','item_name'=>'Yêu nước'),
array('item_id'=>'nhan_ai','item_name'=>'Nhân ái'),
array('item_id'=>'cham_chi','item_name'=>'Chăm chỉ'),
array('item_id'=>'trung_thuc','item_name'=>'Trung thực'),
array('item_id'=>'trach_nhiem','item_name'=>'Trách nhiệm')
)
);
$arr_json['hanhkiem_th_type'] = $arr_hanh_kiem_th_type_json;
$q_diem_diem_th_hk1 = $DB->query("SELECT * FROM TB_MARK_TH WHERE SCHOOL_ID ='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND MARK_YEAR='$v_learn_year' AND MARK_HK IN ('1','2') ORDER BY MARK_LAST_UPDATE DESC");
while($row_diem_th_hk1 = $DB->fetch_row($q_diem_diem_th_hk1)){
$arr_diem_th_hk1_type[$row_diem_th_hk1['MARK_HK']][$row_diem_th_hk1['SUBJECT_ID']] = $row_diem_th_hk1['MARK_TYPE'];
$arr_diem_th_hk1_value[$row_diem_th_hk1['MARK_HK']][$row_diem_th_hk1['SUBJECT_ID']] = $row_diem_th_hk1['MARK_VALUE'];
$arr_diem_th_hk1_note[$row_diem_th_hk1['MARK_HK']][$row_diem_th_hk1['SUBJECT_ID']] = $row_diem_th_hk1['MARK_NOTE'];
}
$q_subject = $DB->query(" SELECT DISTINCT a.SUBJECT_ID as SUBJECT_ID
FROM TB_KHSB a LEFT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID
WHERE a.SCHOOL_ID='".$v_school_id."' AND a.KHOI_ID = '".$v_khoi_id."' ".$check_hesotd2." ORDER BY b.SUBJECT_ORDER ASC ");
while ($r_subject = $DB->fetch_row($q_subject)){
$v_tmp_subject_id = $r_subject['SUBJECT_ID'];
$muc_dat_duoc_sub_hk = '';
if(isset($arr_diem_th_hk1_type[1][$v_tmp_subject_id])){
$muc_dat_duoc_sub_hk = $arr_monhoc[$arr_diem_th_hk1_type[1][$v_tmp_subject_id]];
}
$diem_ktdk_sub_hk = '';
if(isset($arr_diem_th_hk1_value[1][$v_tmp_subject_id]) and $arr_diem_th_hk1_value[1][$v_tmp_subject_id]>0){
$diem_ktdk_sub_hk = floatval($arr_diem_th_hk1_value[1][$v_tmp_subject_id]);
}
$nhan_xet_sub_hk = '';
if(isset($arr_diem_th_hk1_note[1][$v_tmp_subject_id])){
$nhan_xet_sub_hk = showutf(trim($arr_diem_th_hk1_note[1][$v_tmp_subject_id]));
}
$muc_dat_duoc_hk = '';
if(isset($arr_diem_th_hk1_type[2][$v_tmp_subject_id])){
$muc_dat_duoc_hk = $arr_monhoc[$arr_diem_th_hk1_type[2][$v_tmp_subject_id]];
}
$diem_ktdk_hk = '';
if(isset($arr_diem_th_hk1_value[2][$v_tmp_subject_id]) and $arr_diem_th_hk1_value[2][$v_tmp_subject_id]>0){
$diem_ktdk_hk = floatval($arr_diem_th_hk1_value[2][$v_tmp_subject_id]);
}
$nhan_xet_hk = '';
if(isset($arr_diem_th_hk1_note[2][$v_tmp_subject_id])){
$nhan_xet_hk = showutf(trim($arr_diem_th_hk1_note[2][$v_tmp_subject_id]));
}
$arr_data_diem_hk1[] = array('subject_id'=>$r_subject['SUBJECT_ID'],'subject_name'=>showutf(get_subject_name($r_subject['SUBJECT_ID'],$v_school_id))
,
'diem_giua_hk1'=>array('muc_dat_duoc'=>$muc_dat_duoc_sub_hk,'diem_ktdk'=>$diem_ktdk_sub_hk,'nhan_xet'=>$nhan_xet_sub_hk),
'diem_cuoi_hk1'=>array('muc_dat_duoc'=>$muc_dat_duoc_hk,'diem_ktdk'=>$diem_ktdk_hk,'nhan_xet'=>$nhan_xet_hk)
);
}
$arr_json['hoc_ky_1']['diem_data'] = $arr_data_diem_hk1;
$arr_hanh_kiem_th = $arr_hanh_kiem_th_type;
unset($arr_hanh_kiem_th['nhan_xet_chung_cua_gvcn']);
$row_check_hanh_kiem = $DB->fetch_row($DB->query(" SELECT * FROM TB_HANH_KIEM_TH_NEW WHERE 1 AND PUPIL_ID='".$v_pupil_id."'
AND HANH_KIEM_HK='2'
AND HANH_KIEM_YEAR='".$v_learn_year."' AND HANH_KIEM_TYPE='nhan_xet_chung_cua_gvcn' LIMIT 1 "));
$arr_json['hoc_ky_1']['nhan_xet_chung_cua_gvcn'] = showutf(trim($row_check_hanh_kiem['HANH_KIEM_VALUE']));
//hk2
$q_diem_diem_th_hk2 = $DB->query("SELECT * FROM TB_MARK_TH WHERE SCHOOL_ID ='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND MARK_YEAR='$v_learn_year' AND MARK_HK IN ('3','4') ORDER BY MARK_LAST_UPDATE DESC");
while($row_diem_th_hk2 = $DB->fetch_row($q_diem_diem_th_hk2)){
$arr_diem_th_hk2_type[$row_diem_th_hk2['MARK_HK']][$row_diem_th_hk2['SUBJECT_ID']] = $row_diem_th_hk2['MARK_TYPE'];
$arr_diem_th_hk2_value[$row_diem_th_hk2['MARK_HK']][$row_diem_th_hk2['SUBJECT_ID']] = $row_diem_th_hk2['MARK_VALUE'];
$arr_diem_th_hk2_note[$row_diem_th_hk2['MARK_HK']][$row_diem_th_hk2['SUBJECT_ID']] = $row_diem_th_hk2['MARK_NOTE'];
}
$q_subject2 = $DB->query(" SELECT DISTINCT a.SUBJECT_ID as SUBJECT_ID
FROM TB_KHSB a LEFT JOIN TB_SUBJECT".strtoupper($txt_brand)." b ON a.SUBJECT_ID=b.SUBJECT_ID
WHERE a.SCHOOL_ID='".$v_school_id."' AND a.KHOI_ID = '".$v_khoi_id."' ".$check_hesotd2." ORDER BY b.SUBJECT_ORDER ASC ");
while ($r_subject2 = $DB->fetch_row($q_subject2)){
$v_tmp_subject_id = $r_subject2['SUBJECT_ID'];
$muc_dat_duoc_sub_hk = '';
if(isset($arr_diem_th_hk2_type[3][$v_tmp_subject_id])){
$muc_dat_duoc_sub_hk = $arr_monhoc[$arr_diem_th_hk2_type[3][$v_tmp_subject_id]];
}
$diem_ktdk_sub_hk = '';
if(isset($arr_diem_th_hk2_value[3][$v_tmp_subject_id]) and $arr_diem_th_hk2_value[3][$v_tmp_subject_id]>0){
$diem_ktdk_sub_hk = floatval($arr_diem_th_hk2_value[3][$v_tmp_subject_id]);
}
$nhan_xet_sub_hk = '';
if(isset($arr_diem_th_hk2_note[3][$v_tmp_subject_id])){
$nhan_xet_sub_hk = showutf(trim($arr_diem_th_hk2_note[3][$v_tmp_subject_id]));
}
$muc_dat_duoc_hk = '';
if(isset($arr_diem_th_hk2_type[4][$v_tmp_subject_id])){
$muc_dat_duoc_hk = $arr_monhoc[$arr_diem_th_hk2_type[4][$v_tmp_subject_id]];
}
$diem_ktdk_hk = '';
if(isset($arr_diem_th_hk2_value[4][$v_tmp_subject_id]) and $arr_diem_th_hk2_value[4][$v_tmp_subject_id]>0){
$diem_ktdk_hk = floatval($arr_diem_th_hk2_value[4][$v_tmp_subject_id]);
}
$nhan_xet_hk = '';
if(isset($arr_diem_th_hk2_note[4][$v_tmp_subject_id])){
$nhan_xet_hk = showutf(trim($arr_diem_th_hk2_note[4][$v_tmp_subject_id]));
}
$arr_data_diem_hk2[] = array('subject_id'=>$r_subject2['SUBJECT_ID'],'subject_name'=>showutf(get_subject_name($r_subject2['SUBJECT_ID'],$v_school_id))
,
'diem_giua_hk2'=>array('muc_dat_duoc'=>$muc_dat_duoc_sub_hk,'diem_ktdk'=>$diem_ktdk_sub_hk,'nhan_xet'=>$nhan_xet_sub_hk),
'diem_cuoi_nam'=>array('muc_dat_duoc'=>$muc_dat_duoc_hk,'diem_ktdk'=>$diem_ktdk_hk,'nhan_xet'=>$nhan_xet_hk)
);
}
$arr_json['hoc_ky_2']['diem_data'] = $arr_data_diem_hk2;
$arr_hanh_kiem_th = $arr_hanh_kiem_th_type;
unset($arr_hanh_kiem_th['nhan_xet_chung_cua_gvcn']);
$row_check_hanh_kiem = $DB->fetch_row($DB->query(" SELECT * FROM TB_HANH_KIEM_TH_NEW WHERE 1 AND PUPIL_ID='".$v_pupil_id."'
AND HANH_KIEM_HK='4'
AND HANH_KIEM_YEAR='".$v_learn_year."' AND HANH_KIEM_TYPE='nhan_xet_chung_cua_gvcn' LIMIT 1 "));
$arr_json['hoc_ky_2']['nhan_xet_chung_cua_gvcn'] = showutf(trim($row_check_hanh_kiem['HANH_KIEM_VALUE']));
if($v_hoc_ky==1){
return $arr_json['hoc_ky_1'];
}else {
return $arr_json['hoc_ky_2'];
}
}
function get_diem_esl($v_pupil_id,$v_class_id,$v_khoi_id,$v_khoi_level,$v_school_id,$v_hoc_ky,$v_learn_year){
global $mydb,$DB;
$txt_diem_esl = '<table class="table table-bordered mt-5"><tr><th>Subjects</th><th>Score</th></tr>';
$q_mark_esl = $DB->query("SELECT * FROM TB_MARK_ESL WHERE PUPIL_ID='$v_pupil_id' AND MARK_ESL_HOC_KY='$v_hoc_ky' AND MARK_ESL_LEARN_YEAR='$v_learn_year' ");
$flag_subject = 0;
while ($r_mark_els = $DB->fetch_row($q_mark_esl)){
if($r_mark_els['MARK_ESL_TYPE']=='mark'){
if($flag_subject!=$r_mark_els['SUBJECT_ESL_ID']){
$row_check_subject = $mydb->fetch_row($mydb->query("SELECT SUBJECT_ESL_NAME FROM TB_SUBJECT_ESL WHERE SUBJECT_ESL_ID='".$r_mark_els['SUBJECT_ESL_ID']."' "));
$txt_diem_esl .= '<tr><th colspan="2">'.$row_check_subject['SUBJECT_ESL_NAME'].'</th></tr>';
$flag_subject = $r_mark_els['SUBJECT_ESL_ID'];
}
$row_check_cotdiem = $mydb->fetch_row($mydb->query("SELECT COTDIEM_ESL_NAME FROM TB_COTDIEM_ESL WHERE COTDIEM_ESL_ID='".$r_mark_els['COTDIEM_ELS_ID']."' "));
$txt_diem_esl .= '<tr><td>'.$row_check_cotdiem['COTDIEM_ESL_NAME'].'</td><td>'.$r_mark_els['MARK_ESL_VALUE'].'</td></tr>';
}
if($r_mark_els['MARK_ESL_TYPE']=='gpa'){
$txt_diem_esl .= '<tr><td>GPA</td><td>'.$r_mark_els['MARK_ESL_VALUE'].'</td></tr>';
}
if($r_mark_els['MARK_ESL_TYPE']=='comment'){
$txt_diem_esl .= '<tr><th colspan="2">Midterm comments</th></tr>';
$txt_diem_esl .= '<tr><td colspan="2">'.trim($r_mark_els['MARK_ESL_COMMENT']).'</td></tr>';
}
if($r_mark_els['MARK_ESL_TYPE']=='comment_vi'){
$txt_diem_esl .= '<tr><th colspan="2">End of Semester comments</th></tr>';
$txt_diem_esl .= '<tr><td colspan="2">'.trim($r_mark_els['MARK_ESL_COMMENT_VI']).'</td></tr>';
}
}
$txt_diem_esl .= '</table>';
return $txt_diem_esl;
}
function get_diem_esl_json($v_pupil_id,$v_hoc_ky,$v_learn_year){
global $mydb,$DB;
$arr_year = explode('-',$v_learn_year);
$q_mark_esl = $DB->query("SELECT * FROM TB_MARK_ESL WHERE PUPIL_ID='$v_pupil_id' AND MARK_ESL_HOC_KY='$v_hoc_ky' AND MARK_ESL_LEARN_YEAR='$v_learn_year' ORDER BY MARK_ESL_TYPE='comment',MARK_ESL_TYPE='comment_vi',MARK_ESL_TYPE='gpa' ASC ");
$flag_subject = 0;
if($arr_year[1]<=2024){
//$DB = $mydb;
}else{
$mydb = $DB;
}
while ($r_mark_els = $DB->fetch_row($q_mark_esl)){
if($r_mark_els['MARK_ESL_TYPE']=='mark'){
$esl['MARK_ESL_TYPE'] = $r_mark_els['MARK_ESL_TYPE'];
if($flag_subject!=$r_mark_els['SUBJECT_ESL_ID']){
$row_check_subject = $mydb->fetch_row($mydb->query("SELECT SUBJECT_ESL_NAME FROM TB_SUBJECT_ESL WHERE SUBJECT_ESL_ID='".$r_mark_els['SUBJECT_ESL_ID']."' "));
$esl['SUBJECT_ESL'] = array('SUBJECT_ESL_ID'=>$r_mark_els['SUBJECT_ESL_ID'],'SUBJECT_ESL_NAME'=>showutf($row_check_subject['SUBJECT_ESL_NAME']));
$flag_subject = $r_mark_els['SUBJECT_ESL_ID'];
}
$row_check_cotdiem = $mydb->fetch_row($mydb->query("SELECT COTDIEM_ESL_NAME FROM TB_COTDIEM_ESL WHERE COTDIEM_ESL_ID='".$r_mark_els['COTDIEM_ELS_ID']."' "));
$esl['SUBJECT_ESL_CORE'] = array('SUBJECT_ESL_CORE_ID'=>$r_mark_els['COTDIEM_ELS_ID'],'SUBJECT_ESL_CORE_NAME'=>showutf($row_check_cotdiem['COTDIEM_ESL_NAME']),'SUBJECT_ESL_CORE_VALUE'=>showutf($r_mark_els['MARK_ESL_VALUE']),'SUBJECT_ESL_COMMENT'=>null);
}
if($r_mark_els['MARK_ESL_TYPE']=='gpa'){
$esl['MARK_ESL_TYPE'] = 'GPA';
$esl['SUBJECT_ESL_CORE'] = array('SUBJECT_ESL_CORE_ID'=>null,'SUBJECT_ESL_CORE_NAME'=>null,'SUBJECT_ESL_CORE_VALUE'=>showutf(trim($r_mark_els['MARK_ESL_VALUE'])));
}
if($r_mark_els['MARK_ESL_TYPE']=='comment'){
$esl['MARK_ESL_TYPE'] = 'Midterm comments';
$esl['SUBJECT_ESL_CORE'] = array('SUBJECT_ESL_CORE_ID'=>null,'SUBJECT_ESL_CORE_NAME'=>null,'SUBJECT_ESL_CORE_VALUE'=>null,'SUBJECT_ESL_COMMENT'=>showutf(trim($r_mark_els['MARK_ESL_COMMENT'])));
}
if($r_mark_els['MARK_ESL_TYPE']=='comment_vi'){
$esl['MARK_ESL_TYPE'] = 'End of Semester comments';
$esl['SUBJECT_ESL_CORE'] = array('SUBJECT_ESL_CORE_ID'=>null,'SUBJECT_ESL_CORE_NAME'=>null,'SUBJECT_ESL_CORE_VALUE'=>null,'SUBJECT_ESL_COMMENT'=>showutf(trim($r_mark_els['MARK_ESL_COMMENT_VI'])));
}
$list[] = $esl;
}
return $list;
}
function get_subject_xeploai($p_subject_id,$v_school_id){
global $DB;
$brand = get_school_brand($v_school_id);
$q_check = $DB->query("SELECT SUBJECT_XEPLOAI FROM TB_SUBJECT".strtoupper($brand)." WHERE SUBJECT_ID='$p_subject_id'");
$r_check = $DB->fetch_row($q_check);
return intval($r_check['SUBJECT_XEPLOAI']);
}
function get_pupil_comment($v_school_id,$v_pupil_id,$v_subject_id,$p_lear_hk,$v_learn_year=''){
global $DB;
if($v_learn_year==''){
$v_learn_year = get_current_learn_year($v_school_id);
}
if($p_lear_hk==1){
$txt_sub_hk = "1,2";
}else{
$txt_sub_hk = '3,4';
}
$row_comment = $DB->fetch_row($DB->query("SELECT PUCM_CONTENT FROM TB_PUCM WHERE SCHOOL_ID='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND SUBJECT_ID='$v_subject_id' AND SUB_HK IN (".$txt_sub_hk.") AND `YEAR`='$v_learn_year' AND PUCM_CONTENT!='' AND PUCM_CONTENT is not null ORDER BY PUCM_TIME DESC LIMIT 1 "));
return trim($row_comment['PUCM_CONTENT']);
}
function get_class_khoi($p_class_id){
global $DB;
$rs = $DB->query("
SELECT
KHOI_ID
FROM TB_CLASS
WHERE CLASS_ID= '".$p_class_id."'
");
if($arr=$DB->fetch_row($rs)){
return $arr['KHOI_ID'];
}
return "";
}
function get_khoi_level($p_khoi_id){
global $DB;
$rs = $DB->query("
SELECT
KHOI_LEVEL
FROM TB_KHOI
WHERE KHOI_ID= '".$p_khoi_id."'
");
if($arr=$DB->fetch_row($rs)){
return $arr['KHOI_LEVEL'];
}
return "";
}
function get_hanh_kiem($p_pupil_id,$p_learn_year,$p_learn_hk){
global $DB;
$rs = $DB->query("
SELECT
HANH_KIEM_VALUE
FROM TB_HANH_KIEM
WHERE PUPIL_ID = '".$p_pupil_id."' AND HANH_KIEM_HK='".$p_learn_hk."' AND HANH_KIEM_YEAR='".$p_learn_year."'
");
if($arr = $DB->fetch_row($rs)){
return $arr['HANH_KIEM_VALUE'];
}
return 0;
}
function get_learn_year_by_date($v_date,$v_school_id=100){
global $DB;
$row_check_year = $DB->fetch_row($DB->query("SELECT CONCAT(SUBSTRING(max(tb.ATTRIBUTE_DATE),1,4),'-',SUBSTRING(max(tb.ATTRIBUTE_DATE),1,4)+1) as max_att_date FROM `TB_ATTRIBUTE` tb WHERE `ATTRIBUTE_TYPE`='nbdnhm' AND `SCHOOL_ID`='$v_school_id' AND `ATTRIBUTE_DATE` <= '".$v_date."' ORDER BY ATTRIBUTE_DATE DESC,UPDATE_TIME DESC LIMIT 1 "));
return $row_check_year['max_att_date'];
}
function get_school_brand($v_school_id){
global $DB;
$row_school = $DB->fetch_row($DB->query("SELECT SCHOOL_BRAND FROM TB_SCHOOL WHERE SCHOOL_ID='".$v_school_id."' LIMIT 1 "));
return $row_school['SCHOOL_BRAND'];
}
function get_img_pupil($v_pupil_id,$width,$height){
global $DB,$text_to_img;
$row_pic_pupil = $DB->fetch_row($DB->query("SELECT a.IMG FROM TB_PUPIL_PICTURE a LEFT JOIN TB_PUPIL b ON a.PUPIL_ID=b.PUPIL_ID WHERE a.PUPIL_ID='$v_pupil_id' ORDER BY TIME DESC LIMIT 1 "));
if(!empty($row_pic_pupil['IMG'])){
$img_txt = 'https://iportal.nhg.vn/webservice/thumb_v3.php?file=' . base64_encode($row_pic_pupil['IMG']) . '&width=' . $width . '&height=' . $height;
}else{
$row_pupil = $DB->fetch_row($DB->query("SELECT PUPIL_REAL_NAME FROM TB_PUPIL WHERE PUPIL_ID='$v_pupil_id'"));
$arr_pupil = explode(' ',$row_pupil['PUPIL_REAL_NAME']);
$text = $arr_pupil[count($arr_pupil)-1];
$text_to_img->createImage($text);
$fileName = $v_pupil_id;
$year_now = date('Y');
$month_now = date('m');
if(is_dir("/var/www/html/nhg_portal/upload/pupil/".$year_now)) {
if (!is_dir("/var/www/html/nhg_portal/upload/pupil/" . $year_now . "/" . $month_now )) {
mkdir("/var/www/html/nhg_portal/upload/pupil/" . $year_now . "/" . $month_now,0777);
}
}else{
mkdir("/var/www/html/nhg_portal/upload/pupil/" . $year_now,0777);
if (!is_dir("/var/www/html/nhg_portal/upload/pupil/" . $year_now . "/" . $month_now )) {
mkdir("/var/www/html/nhg_portal/upload/pupil/" . $year_now . "/" . $month_now,0777);
}
}
$text_to_img->saveAsPng($fileName,"/var/www/html/nhg_portal/upload/pupil/" . $year_now . "/" . $month_now.'/');
$img_txt = 'https://iportal.nhg.vn/upload/pupil/' . $year_now . '/' . $month_now.'/'.$fileName.'.png';
}
return $img_txt;
}
function get_img_teacher($v_teacher_id,$width,$height){
global $DB;
$v_tmp_teacher_id = $v_teacher_id;
$v_teacher_image = '';
$folder = '';
$name = '';
$img_txt = '';
$row_check = $DB->fetch_row($DB->query("SELECT IMAGE_NAME,FOLDER FROM TB_TEACHER_IMAGES WHERE TEACHER_ID = '$v_tmp_teacher_id' AND (IMAGE_NUM='1' OR IMAGE_NUM='2' OR IMAGE_NUM='3' OR IMAGE_NUM='4') AND IMAGE_NAME != '' ORDER BY UPDATE_TIME DESC LIMIT 1 "));
if ($row_check) {
$folder = $row_check['FOLDER'];
$name = $row_check['IMAGE_NAME'];
if($name!='') {
$img_txt = 'https://iportal.nhg.vn/webservice/thumb_v3.php?file=' . base64_encode('upload/teacher/' . $folder . '/' . $name) . '&width=' . $width . '&height=' . $height;
}else{
$img_txt = NULL;
}
} else {
$img_txt = NULL;
}
return $img_txt;
}
function get_room_name($p_room_id){
global $DB;
$rs = $DB->query("
SELECT
ROOM_TITLE
FROM TB_ROOM
WHERE ROOM_ID= '".$p_room_id."'
");
if($arr=$DB->fetch_row($rs)){
return $arr['ROOM_TITLE'];
}
return "";
}
function get_tkb_current_date($p_school_id,$p_tkb_date,$p_hk){
global $DB;
if(empty($p_hk)){
$p_hk = get_current_learn_hk($p_school_id);
}
$v_cur_year = get_current_learn_year($p_school_id);
$rs = $DB->query("
SELECT
TKB_DATE
FROM TB_TKB
WHERE SCHOOL_ID = '".$p_school_id."' AND TKB_DATE <= '".$p_tkb_date."' AND TKB_HK='$p_hk'
ORDER BY TKB_DATE DESC
LIMIT 1
");
if($arr= $DB->fetch_row($rs)){
//mysql_free_result($rs);
return $arr['TKB_DATE'];
}else{
//mysql_free_result($rs);
//exit('Chưa có TKB học kỳ '.$p_hk.' năm học '.$v_cur_year);
return date('Y-m-d');
}
}
function get_current_learn_hk($p_school_id){
$v_ngay_bat_dau_hocky2 = get_attribute_data("nbdhk2",0,$p_school_id,date("Y-m-d"));
if($v_ngay_bat_dau_hocky2 > date("Y-m-d")){
return 1;
}else{
return 2;
}
}
function get_current_learn_year($p_school_id){
$v_ngay_bat_dau_nam_hoc = get_attribute_data("nbdnhm",0,$p_school_id,date("Y-m-d"));
$arr_ngay_bat_dau_nam_hoc = explode("-",$v_ngay_bat_dau_nam_hoc);
return $arr_ngay_bat_dau_nam_hoc[0]."-".($arr_ngay_bat_dau_nam_hoc[0]+1);
}
function get_attribute_data($p_attribute_key,$p_teacher_id,$p_school_id,$p_date){
global $DB;
$rs = $DB->query("
SELECT
ATTRIBUTE_DATA
FROM TB_ATTRIBUTE
WHERE TEACHER_ID='".$p_teacher_id."' AND ATTRIBUTE_TYPE = '".$p_attribute_key."' AND SCHOOL_ID='".$p_school_id."' AND ATTRIBUTE_DATE <= '".$p_date."'
ORDER BY ATTRIBUTE_DATE DESC, ATTRIBUTE_ID DESC
LIMIT 1
");
if($arr = $DB->fetch_row($rs)) return $arr['ATTRIBUTE_DATA'];
else return "";
}
function get_subject_name($p_subject_id,$v_school_id=0){
global $DB;
if($p_subject_id==1000){
return 'Chủ nhiệm';
}
$row_check = $DB->fetch_row($DB->query("SELECT SUBJECT_SCHOOL_NAME FROM TB_SUBJECT_SCHOOL WHERE SUBJECT_ID= '".$p_subject_id."' AND SCHOOL_ID='".$v_school_id."' "));
if($row_check && trim($row_check['SUBJECT_SCHOOL_NAME'])!=''){
return $row_check['SUBJECT_SCHOOL_NAME'];
}else {
$brand = get_school_brand($v_school_id);
$rs = $DB->query("
SELECT
SUBJECT_NAME
FROM TB_SUBJECT".strtoupper($brand)."
WHERE SUBJECT_ID= '" . $p_subject_id . "'
");
if ($arr = $DB->fetch_row($rs)) {
return $arr['SUBJECT_NAME'];
}
return "";
}
}
function get_class_name($p_class_id){
global $DB;
$rs = $DB->query("
SELECT
CLASS_NAME
FROM TB_CLASS
WHERE CLASS_ID= '".$p_class_id."'
");
if($arr=$DB->fetch_row($rs)){
return $arr['CLASS_NAME'];
}
return "";
}
function get_class_full_name($p_class_id){
global $DB;
$rs = $DB->query("
SELECT
a.CLASS_NAME
,a.CLASS_LEVEL,b.KHOI_TITLE
FROM TB_CLASS a LEFT JOIN TB_KHOI b ON a.KHOI_ID=b.KHOI_ID
WHERE a.CLASS_ID= '".$p_class_id."'
");
if($arr=$DB->fetch_row($rs)){
return $arr['KHOI_TITLE']."".$arr['CLASS_NAME'];
}
return "";
}
function get_mark_avg($p_pupil_id,$p_subject_id,$p_year,$p_hk){
global $DB;
$v_where_clause = " AND PUPIL_ID='".$p_pupil_id."' AND SUBJECT_ID= '".$p_subject_id."' AND MATB_YEAR= '".$p_year."' AND MATB_HK= '".$p_hk."' ";
$rs = $DB->query("
SELECT
MATB_VALUE
FROM TB_MATB
WHERE 1 ".$v_where_clause."
");
if($arr = $DB->fetch_row($rs)){
return $arr['MATB_VALUE'];
}else{
return 'N/A';
}
}
function get_school_name($p_school_id){
global $DB;
$rs = $DB->query("
SELECT
SCHOOL_NAME
,SCHOOL_PROVINCE
FROM TB_SCHOOL
WHERE SCHOOL_ID= '".$p_school_id."'
");
if($arr=$DB->fetch_row($rs)){
return $arr['SCHOOL_NAME'];
}
return "";
}
function get_vphsgv_name($p_vphsgv_id){
global $DB;
$rs = $DB->query("
SELECT
VPHSGV_TITLE
FROM TB_VPHSGV
WHERE VPHSGV_ID= '".$p_vphsgv_id."'
");
if($arr=$DB->fetch_row($rs)){
return $arr['VPHSGV_TITLE'];
}
return "";
}
function get_teacher_image_file($p_teacher_id,$p_image_num,$p_image_size="th"){
$v_teacher_thum_image_file = 'upanh/upload/10040308/02-2016/logo3-56cd68435710f.png';
for($i=1;$i<=4;$i++){
if(file_exists("../images/teacher/".$p_image_size.$p_teacher_id."_".$i.".jpg")){
$v_teacher_thum_image_file ="images/teacher/".$p_image_size.$p_teacher_id."_".$i.".jpg";
}
}
return $v_teacher_thum_image_file;
}
function get_teacher_image($p_teacher_id,$p_image_num){
global $DB;
$rs = $DB->query("SELECT IMAGE_DATA FROM TB_TEACHER_IMAGES WHERE TEACHER_ID='".$p_teacher_id."' AND IMAGE_NUM ='".$p_image_num."'");
$arr = $DB->fetch_row($rs);
return $arr['IMAGE_DATA'];
}
function images_resize($max_width,$max_height,$source_file,$dest_file){
list($width, $height, $type, $attr) = @getimagesize($source_file);
if (($width*$height)==0) return false;
if (($max_width*$max_height)==0) return false;
$new_width = $width;
$new_height = $height;
if ( ($width>$max_width)&&($width/$max_width>=$height/$max_height)){
$new_width = $max_width;
$new_height = (int)($height * $max_width/$width);
}else if (($height>$max_height)&&($width/$max_width<=$height/$max_height)){
$new_height = $max_height;
$new_width = (int)($width * $max_height/$height);
}
switch($type){
case 1;//Gif
$im_source = @imagecreatefromgif($source_file);
break;
case 2;//Jpg
$im_source = @imagecreatefromjpeg($source_file);
break;
case 3;//Png
$im_source = @imagecreatefrompng($source_file);
break;
default ;
$im_source = @imagecreatefromjpeg($source_file);
break;
}
$im_dest = @imagecreatetruecolor($new_width,$new_height);
$background = @imagecolorallocate($im_dest, 255, 255, 255);
@imagefill($im_dest,0,0,$background);
@imagecopyresampled ($im_dest,$im_source, 0,0,0,0,$new_width,$new_height,$width,$height);
if ($im_dest) $v_ok = true;
else $v_ok = false;
@unlink($dest_file);
@imagejpeg($im_dest,$dest_file,100);
@imagedestroy($im_dest);
@imagedestroy($im_source);
return $v_ok;
}
function week_tc_to_time($v_week_tc,$v_school_id){
global $CORE;
if(isset($CORE->input['txt_year']) and $CORE->input['txt_year']!=''){
$v_c_year = $CORE->input['txt_year'];
}else {
$v_c_year = get_current_learn_year($v_school_id);
}
$arr_year = explode('-',$v_c_year);
$v_ngay_bat_dau_nam_hoc = get_attribute_data("nbdnhm",0,$v_school_id,date("Y-m-d"));
$v_begin_time_quy = strtotime($v_ngay_bat_dau_nam_hoc);
$v_begin_time_quy = strtotime('Last Monday', $v_begin_time_quy );
$v_time_tc = ($v_week_tc)*604800;
$v_time = $v_time_tc+$v_begin_time_quy;
$ts = strtotime('Last Monday', $v_time );
return $ts;//return timestamp of monday begin week
}
function week_tc_now($v_school_id){
global $CORE;
if(isset($CORE->input['txt_year']) and $CORE->input['txt_year']!=''){
$v_c_year = $CORE->input['txt_year'];
}else {
$v_c_year = get_current_learn_year($v_school_id);
}
$arr_year = explode('-',$v_c_year);
$v_ngay_bat_dau_nam_hoc = get_attribute_data("nbdnhm",0,$v_school_id,date("Y-m-d"));
$v_begin_time_quy = strtotime($v_ngay_bat_dau_nam_hoc); // chỉnh theo thứ 2 của tuần đầu tiên năm t/c mới
$v_begin_time_quy = strtotime('Last Monday', $v_begin_time_quy );
$time_monday_now = strtotime('monday next week');
//echo date('d/m/Y',$time_monday_now);
$v_time_tc = $time_monday_now - $v_begin_time_quy;
$v_week_now = round($v_time_tc/604800,0);
//$v_begin_week = date('w',strtotime($v_begin_quy));
return $v_week_now;
}
function get_teacher_name($p_teacher_id){
global $DB;
if($p_teacher_id>0) {
$rs = $DB->query("
SELECT
TEACHER_REAL_NAME
FROM TB_TEACHER
WHERE TEACHER_ID = '" . $p_teacher_id . "'
");
if ($arr_teacher = $DB->fetch_row($rs)) {
return $arr_teacher['TEACHER_REAL_NAME'];
}
}
return "";
}
function get_xep_loai_chung($p_tbm,$p_min_tbm,$p_max_tb_toan_van,$p_hanh_kiem){
$v_xl_hoc_luc = get_xep_loai_hoc_luc($p_tbm,$p_min_tbm,$p_max_tb_toan_van);
if($p_hanh_kiem){
if($v_xl_hoc_luc==5 && $p_hanh_kiem==1) return 5;
if($v_xl_hoc_luc==5 && $p_hanh_kiem==2) return 4;
if($v_xl_hoc_luc==4 && $p_hanh_kiem<=2) return 4;
if($v_xl_hoc_luc==4 && $p_hanh_kiem==3) return 3;
if($v_xl_hoc_luc==4 && $p_hanh_kiem>3) return 2;
if($v_xl_hoc_luc==3 && $p_hanh_kiem<=3) return 3;
if($v_xl_hoc_luc==3 && $p_hanh_kiem==4) return 2;
if($v_xl_hoc_luc==2 && $p_hanh_kiem<=4) return 2;
return 1;
}else{
if($v_xl_hoc_luc==5) return 5;
if($v_xl_hoc_luc==4) return 4;
if($v_xl_hoc_luc==3) return 3;
if($v_xl_hoc_luc==2) return 2;
return 1;
}
}
function get_xep_loai_hoc_luc($p_tbm,$p_min_tbm,$p_max_tb_toan_van){
//add 20-5-2013
//khong che 2 bac
if($p_tbm>=8 and $p_max_tb_toan_van>=8 and $p_min_tbm<6.5){
return 4;
}
if($p_tbm>=6.5 and $p_max_tb_toan_van>=6.5 and $p_min_tbm<5.0){
return 3;
}
if($p_tbm>=6.5 and $p_max_tb_toan_van>=5.0 and $p_min_tbm<3.5){
return 2;
}
//begin check
if($p_tbm>=8 && $p_min_tbm >= 6.5 && $p_max_tb_toan_van>=8) { return 5;}
if($p_tbm>=8 && $p_min_tbm >= 5.0) {return 4;}
if($p_tbm>=6.5 && $p_min_tbm >= 5.0 && $p_max_tb_toan_van>=6.5) {return 4;}
if($p_tbm>=8 ) {return 3;}
if($p_tbm>=6.5 && $p_max_tb_toan_van>=6.5 && $p_min_tbm < 3.5 && $p_min_tbm >= 3.0){
return 3;
}
if($p_tbm>=6.5 && $p_min_tbm >= 5.0 && $p_max_tb_toan_van>=5.0) {return 3;}
if($p_tbm>=6.5 && $p_min_tbm >= 3.5 && $p_min_tbm <5.0 && $p_max_tb_toan_van>=5.0 ) {return 3;}
if($p_tbm>=5.0 && $p_min_tbm >= 3.5 && $p_max_tb_toan_van>=5.0) {return 3;}
//cac truong hop con lai yeu
if($p_tbm>=6.5) {return 2;}
if($p_tbm>=6.5 && $p_min_tbm >= 3.5 && $p_min_tbm < 5.0 && $p_max_tb_toan_van < 5.0) {return 2;}
if($p_tbm>=3.5 && $p_min_tbm >= 2.0) {return 2;}
return 1;
}
function str_encode($data,$pwd)
{
$x = 0;
$a = 0;
$j = 0;
$Zcrypt = '';
$pwd_length = strlen($pwd);
for ($i = 0; $i < 255; $i++) {
$key[$i] = ord(substr($pwd, ($i % $pwd_length)+1, 1));
$counter[$i] = $i;
}
for ($i = 0; $i < 255; $i++) {
$x = ($x + $counter[$i] + $key[$i]) % 256;
$temp_swap = $counter[$i];
$counter[$i] = $counter[$x];
$counter[$x] = $temp_swap;
}
for ($i = 0; $i < strlen($data); $i++) {
$a = ($a + 1) % 256;
$j = ($j + $counter[$a]) % 256;
$temp = $counter[$a];
$counter[$a] = $counter[$j];
$counter[$j] = $temp;
$k = $counter[(($counter[$a] + $counter[$j]) % 256)];
$Zcipher = ord(substr($data, $i, 1)) ^ $k;
$Zcrypt .= chr($Zcipher);
}
return $Zcrypt;
}
function get_diem_th($v_school_id,$v_pupil_id,$v_year,$v_subject,$v_hk,$v_mark_type){
global $DB;
$row_diem = $DB->fetch_row($DB->query("SELECT $v_mark_type FROM TB_MARK_TH WHERE SCHOOL_ID ='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND MARK_YEAR='$v_year' AND SUBJECT_ID='$v_subject' AND MARK_HK='$v_hk' LIMIT 1"));
if($row_diem){
return $row_diem[$v_mark_type];
}else{
return '';
}
}
function get_chucvu_name($p_chucvu_id,$v_school_id){
global $DB;
$txt_brand = get_school_brand($v_school_id);
if(!isset($txt_brand) or $txt_brand=='') {
$txt_brand = get_school_brand($v_school_id);
$row_chucvu = $DB->fetch_row($DB->query("SELECT CHUCVU_TITLE
FROM TB_CHUCVU" . strtoupper($txt_brand) . "
WHERE CHUCVU_ID = '" . $p_chucvu_id . "' "));
}else{
$row_chucvu = $DB->fetch_row($DB->query("SELECT CHUCVU_TITLE
FROM TB_CHUCVU
WHERE CHUCVU_ID = '" . $p_chucvu_id . "' "));
}
if($row_chucvu){
return $row_chucvu['CHUCVU_TITLE'];
}else{
return '';
}
}
function get_id_by_username($username){
global $DB;
$row_check = $DB->fetch_row($DB->query("SELECT a.PUPIL_ID,a.PUPIL_REAL_NAME FROM TB_PUPIL a LEFT JOIN TB_USER b ON a.USER_ID=b.USER_ID WHERE b.USER_KEY='$username' "));
if($row_check){
$arr = array('id'=>$row_check['PUPIL_ID'],'fullname'=>$row_check['PUPIL_REAL_NAME'],'type'=>0);
}else{
$row_check = $DB->fetch_row($DB->query("SELECT a.FANDM_ID,a.FATHER_NAME FROM TB_FANDM a LEFT JOIN TB_USER b ON a.USER_ID=b.USER_ID WHERE b.USER_KEY='$username' "));
if($row_check) {
$arr = array('id' => $row_check['FANDM_ID'], 'fullname' => $row_check['FATHER_NAME'].' (PH)','type'=>2);
}else {
$row_check = $DB->fetch_row($DB->query("SELECT a.TEACHER_ID,a.TEACHER_REAL_NAME FROM TB_TEACHER a LEFT JOIN TB_USER b ON a.USER_ID=b.USER_ID WHERE b.USER_KEY='$username' "));
$arr = array('id'=>$row_check['TEACHER_ID'],'fullname'=>$row_check['TEACHER_REAL_NAME'],'type'=>1);
}
}
return $arr;
}
function make_password()
{
$pass = "";
$chars = array(
"1","2","3","4","5","6","7","8","9","0",
"a","A","b","B","c","C","d","D","e","E","f","F","g","G","h","H","i","I","j","J",
"k","K","l","L","m","M","n","N","o","O","p","P","q","Q","r","R","s","S","t","T",
"u","U","v","V","w","W","x","X","y","Y","z","Z");
$count = count($chars) - 1;
srand((double)microtime()*1000000);
for($i = 0; $i < 6; $i++)
{
$pass .= $chars[rand(0, $count)];
}
return($pass);
}
function count_all_api($p_where_clause,$p_table_name){
global $DB;
$row_check = $DB->fetch_row($DB->query("
SELECT
COUNT(*) as total
FROM ".$p_table_name."
WHERE 1 ".$p_where_clause."
"));
return $row_check['total'];
}
function secondsToTime($inputSeconds) {
$then = new DateTime(date('Y-m-d H:i:s', $inputSeconds));
$now = new DateTime(date('Y-m-d H:i:s', time()));
$diff = $then->diff($now);
return array('years' => $diff->y, 'months' => $diff->m, 'days' => $diff->d, 'hours' => $diff->h, 'minutes' => $diff->i, 'seconds' => $diff->s);
}
function get_kqht($arr_diem=array(),$arr_danhgia=array()){
$flag_90 = 0;
$flag_80 = 0;
$flag_65 = 0;
$flag_50 = 0;
$flag_35 = 0;
$flag_danhgia = 0;
foreach($arr_diem as $val){
if($val>=9.0){
$flag_90++;
}
if($val>=8.0){
$flag_80++;
}
if($val>=6.5){
$flag_65++;
}
if($val>=5.0){
$flag_50++;
}
if($val>=3.5){
$flag_35++;
}
}
foreach ($arr_danhgia as $val){
if($val!='7'){
$flag_danhgia++;
}
}
if($flag_danhgia==0 && $flag_65==count($arr_diem) && $flag_90>=6 ) {
return 5;
}elseif($flag_danhgia==0 && $flag_65==count($arr_diem) && $flag_80>=6 ){
return 4;
}elseif($flag_danhgia==0 && $flag_50==count($arr_diem) && $flag_65>=6 ){
return 3;
}elseif($flag_danhgia<=1 && $flag_35==count($arr_diem) && $flag_50>=6 ){
return 2;
}else{
return 1;
}
}
function get_kqrl($v_school_id,$v_pupil_id,$v_learn_year){
global $DB;
$arr = array('1'=>'0','2'=>'0','3'=>'0');
$q_kqrl = $DB->query("SELECT * FROM TB_KQRL WHERE SCHOOL_ID='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND KQRL_YEAR='$v_learn_year' ");
if($r_kqrl = $DB->fetch_row($q_kqrl)) {
while ($r_kqrl = $DB->fetch_row($q_kqrl)) {
$arr[$r_kqrl['KQRL_HK']] = $r_kqrl['KQRL_VALUE'];
}
}
if($arr[1]>0 && $arr[2]>0){
if($arr[2]==4 && $arr[1]>=3){
$arr[3]=4;
}elseif($arr[2]==3 && $arr[1]>=2){
$arr[3]=3;
}elseif($arr[2]==2 && $arr[1]==4){
$arr[3]=3;
}elseif($arr[2]==4 && $arr[1]>=1){
$arr[3]=3;
}elseif($arr[2]==2 && $arr[1]>=1){
$arr[3]=2;
}elseif($arr[2]==3 && $arr[1]>=1){
$arr[3]=2;
}else{
$arr[3]=1;
}
}else{
$arr[3]=0;
}
return $arr;
}
function check_lenlop($arr_kqht,$v_kqrl,$so_ngay_nghi){
foreach ($arr_kqht as $val){
if($val<2){
return 0;
}
}
if($v_kqrl<2){
return 0;
}
if($so_ngay_nghi>45){
return 0;
}
return 1;
}
function check_khenthuong($v_kqrl_hk3,$v_khht_hk3,$arr_diem_hk3=array()){
$flag_90 = 0;
foreach ($arr_diem_hk3 as $val){
if($val>=9.0){
$flag_90++;
}
}
if($v_kqrl_hk3>=4 && $v_khht_hk3>=4 && $flag_90>=6){
return 2;
}
if($v_kqrl_hk3>=4 && $v_khht_hk3>=4){
return 1;
}
return 0;
}
function get_kqrl_hk($v_school_id,$v_pupil_id,$v_current_learn_hk,$v_current_learn_year){
global $DB;
$row_check = $DB->fetch_row($DB->query("SELECT * FROM TB_KQRL WHERE SCHOOL_ID='$v_school_id' AND PUPIL_ID='$v_pupil_id' AND KQRL_HK='$v_current_learn_hk' AND KQRL_YEAR='$v_current_learn_year' LIMIT 1 "));
$v_kqrl = 0;
if($row_check){
$v_kqrl = $row_check['KQRL_VALUE'];
}
return $v_kqrl;
}
function get_socondiemtk_api($v_khoi_id,$v_subject_id){
global $DB;
$row_SOCONDIEMTX = $DB->fetch_row($DB->query("SELECT SOCONDIEMTX FROM TB_KHSB WHERE KHOI_ID='$v_khoi_id' AND SUBJECT_ID='$v_subject_id'"));
if($row_SOCONDIEMTX){
return intval($row_SOCONDIEMTX['SOCONDIEMTX']);
}else{
return 0;
}
}
function get_khoi_ctd_api($p_khoi_id,$p_subject_id,$p_learn_hk){
global $DB;
$row = $DB->fetch_row($DB->query("SELECT CTD,CTD_2 FROM TB_KHSB WHERE KHOI_ID= '".$p_khoi_id."' AND SUBJECT_ID = '".$p_subject_id."'"));
if($row) {
if ($p_learn_hk == 1) {
return $row['CTD'];
}
if ($p_learn_hk == 2) {
return $row['CTD_2'];
}
}else {
return "";
}
}
function result_bmi($gender,$v_bmi,$age,$months){
$arr_phanloai = array('1'=>'Thiếu cân','2'=>'Sức khỏe dinh dưỡng tốt','3'=>'Nguy cơ béo phì','4'=>' Béo phì','5'=>'Trẻ suy dinh dưỡng thể gầy còm mức độ nặng','6'=>'Trẻ suy dĩnh dưỡng thể gầy còm','7'=>'Trẻ bình thường','8'=>'Trẻ thừa cân','9'=>'Trẻ béo phì');
if($gender!=2){
$gender = 1;
}
if($age<2){
$v_month = $age*12+$months;
if($gender == 1){
if($v_month==12) {
if ($v_bmi < 13.4) {
return 5;
} elseif ($v_bmi >= 13.4 and $v_bmi < 14.4) {
return 6;
} elseif ($v_bmi >= 14.4 and $v_bmi < 18.2) {
return 7;
} elseif ($v_bmi >= 18.2 and $v_bmi < 19.8) {
return 8;
} elseif ($v_bmi >= 19.8) {
return 9;
}
}
if($v_month==13) {
if ($v_bmi < 13.3) {
return 5;
} elseif ($v_bmi >= 13.3 and $v_bmi < 14.3) {
return 6;
} elseif ($v_bmi >= 14.3 and $v_bmi < 18.1) {
return 7;
} elseif ($v_bmi >= 18.1 and $v_bmi < 19.7) {
return 8;
} elseif ($v_bmi >= 19.7) {
return 9;
}
}
if($v_month==14) {
if ($v_bmi < 13.2) {
return 5;
} elseif ($v_bmi >= 13.2 and $v_bmi < 14.2) {
return 6;
} elseif ($v_bmi >= 14.2 and $v_bmi < 18) {
return 7;
} elseif ($v_bmi >= 18 and $v_bmi < 19.5) {
return 8;
} elseif ($v_bmi >= 19.5) {
return 9;
}
}
if($v_month==15) {
if ($v_bmi < 13.1) {
return 5;
} elseif ($v_bmi >= 13.1 and $v_bmi < 14.1) {
return 6;
} elseif ($v_bmi >= 14.1 and $v_bmi < 17.8) {
return 7;
} elseif ($v_bmi >= 17.8 and $v_bmi < 19.4) {
return 8;
} elseif ($v_bmi >= 19.4) {
return 9;
}
}
if($v_month==16) {
if ($v_bmi < 13.1) {
return 5;
} elseif ($v_bmi >= 13.1 and $v_bmi < 14) {
return 6;
} elseif ($v_bmi >= 14 and $v_bmi < 17.7) {
return 7;
} elseif ($v_bmi >= 17.7 and $v_bmi < 19.3) {
return 8;
} elseif ($v_bmi >= 19.3) {
return 9;
}
}
if($v_month==17) {
if ($v_bmi < 13) {
return 5;
} elseif ($v_bmi >= 13 and $v_bmi < 13.9) {
return 6;
} elseif ($v_bmi >= 13.9 and $v_bmi < 17.6) {
return 7;
} elseif ($v_bmi >= 17.6 and $v_bmi < 19.1) {
return 8;
} elseif ($v_bmi >= 19.1) {
return 9;
}
}
if($v_month==18) {
if ($v_bmi < 12.9) {
return 5;
} elseif ($v_bmi >= 12.9 and $v_bmi < 13.9) {
return 6;
} elseif ($v_bmi >= 13.9 and $v_bmi < 17.5) {
return 7;
} elseif ($v_bmi >= 17.5 and $v_bmi < 19) {
return 8;
} elseif ($v_bmi >= 19) {
return 9;
}
}
if($v_month==19) {
if ($v_bmi < 12.9) {
return 5;
} elseif ($v_bmi >= 12.9 and $v_bmi < 13.8) {
return 6;
} elseif ($v_bmi >= 13.8 and $v_bmi < 17.4) {
return 7;
} elseif ($v_bmi >= 17.4 and $v_bmi < 18.9) {
return 8;
} elseif ($v_bmi >= 18.9) {
return 9;
}
}
if($v_month==20) {
if ($v_bmi < 12.8) {
return 5;
} elseif ($v_bmi >= 12.8 and $v_bmi < 13.7) {
return 6;
} elseif ($v_bmi >= 13.7 and $v_bmi < 17.3) {
return 7;
} elseif ($v_bmi >= 17.3 and $v_bmi < 18.8) {
return 8;
} elseif ($v_bmi >= 18.8) {
return 9;
}
}
if($v_month==21) {
if ($v_bmi < 12.8) {
return 5;
} elseif ($v_bmi >= 12.8 and $v_bmi < 13.7) {
return 6;
} elseif ($v_bmi >= 13.7 and $v_bmi < 17.2) {
return 7;
} elseif ($v_bmi >= 17.2 and $v_bmi < 18.7) {
return 8;
} elseif ($v_bmi >= 18.7) {
return 9;
}
}
if($v_month==22) {
if ($v_bmi < 12.7) {
return 5;
} elseif ($v_bmi >= 12.7 and $v_bmi < 13.6) {
return 6;
} elseif ($v_bmi >= 13.6 and $v_bmi < 17.2) {
return 7;
} elseif ($v_bmi >= 17.2 and $v_bmi < 18.7) {
return 8;
} elseif ($v_bmi >= 18.7) {
return 9;
}
}
if($v_month==23) {
if ($v_bmi < 12.7) {
return 5;
} elseif ($v_bmi >= 12.7 and $v_bmi < 13.6) {
return 6;
} elseif ($v_bmi >= 13.6 and $v_bmi < 17.1) {
return 7;
} elseif ($v_bmi >= 17.1 and $v_bmi < 18.6) {
return 8;
} elseif ($v_bmi >= 18.6) {
return 9;
}
}
}
if($gender == 2){
if($v_month==12) {
if ($v_bmi < 12.7) {
return 5;
} elseif ($v_bmi >= 12.7 and $v_bmi < 13.8) {
return 6;
} elseif ($v_bmi >= 13.8 and $v_bmi < 17.9) {
return 7;
} elseif ($v_bmi >= 17.9 and $v_bmi < 19.6) {
return 8;
} elseif ($v_bmi >= 19.6) {
return 9;
}
}
if($v_month==13) {
if ($v_bmi < 12.6) {
return 5;
} elseif ($v_bmi >= 12.6 and $v_bmi < 13.7) {
return 6;
} elseif ($v_bmi >= 13.7 and $v_bmi < 17.7) {
return 7;
} elseif ($v_bmi >= 17.7 and $v_bmi < 19.5) {
return 8;
} elseif ($v_bmi >= 19.5) {
return 9;
}
}
if($v_month==14) {
if ($v_bmi < 12.6) {
return 5;
} elseif ($v_bmi >= 12.6 and $v_bmi < 13.6) {
return 6;
} elseif ($v_bmi >= 13.7 and $v_bmi < 17.6) {
return 7;
} elseif ($v_bmi >= 17.6 and $v_bmi < 19.3) {
return 8;
} elseif ($v_bmi >= 19.3) {
return 9;
}
}
if($v_month==15) {
if ($v_bmi < 12.5) {
return 5;
} elseif ($v_bmi >= 12.5 and $v_bmi < 13.5) {
return 6;
} elseif ($v_bmi >= 13.5 and $v_bmi < 17.5) {
return 7;
} elseif ($v_bmi >= 17.5 and $v_bmi < 19.2) {
return 8;
} elseif ($v_bmi >= 19.2) {
return 9;
}
}
if($v_month==16) {
if ($v_bmi < 12.4) {
return 5;
} elseif ($v_bmi >= 12.4 and $v_bmi < 13.5) {
return 6;
} elseif ($v_bmi >= 13.5 and $v_bmi < 17.4) {
return 7;
} elseif ($v_bmi >= 17.4 and $v_bmi < 19.1) {
return 8;
} elseif ($v_bmi >= 19.1) {
return 9;
}
}
if($v_month==17) {
if ($v_bmi < 12.4) {
return 5;
} elseif ($v_bmi >= 12.4 and $v_bmi < 13.4) {
return 6;
} elseif ($v_bmi >= 13.4 and $v_bmi < 17.3) {
return 7;
} elseif ($v_bmi >= 17.3 and $v_bmi < 18.9) {
return 8;
} elseif ($v_bmi >= 18.9) {
return 9;
}
}
if($v_month==18) {
if ($v_bmi < 12.3) {
return 5;
} elseif ($v_bmi >= 12.3 and $v_bmi < 13.3) {
return 6;
} elseif ($v_bmi >= 13.3 and $v_bmi < 17.2) {
return 7;
} elseif ($v_bmi >= 17.2 and $v_bmi < 18.8) {
return 8;
} elseif ($v_bmi >= 18.8) {
return 9;
}
}
if($v_month==19) {
if ($v_bmi < 12.3) {
return 5;
} elseif ($v_bmi >= 12.3 and $v_bmi < 13.3) {
return 6;
} elseif ($v_bmi >= 13.3 and $v_bmi < 17.1) {
return 7;
} elseif ($v_bmi >= 17.1 and $v_bmi < 18.8) {
return 8;
} elseif ($v_bmi >= 18.8) {
return 9;
}
}
if($v_month==20) {
if ($v_bmi < 12.2) {
return 5;
} elseif ($v_bmi >= 12.2 and $v_bmi < 13.2) {
return 6;
} elseif ($v_bmi >= 13.2 and $v_bmi < 17) {
return 7;
} elseif ($v_bmi >= 17 and $v_bmi < 18.7) {
return 8;
} elseif ($v_bmi >= 18.7) {
return 9;
}
}
if($v_month==21) {
if ($v_bmi < 12.2) {
return 5;
} elseif ($v_bmi >= 12.2 and $v_bmi < 13.2) {
return 6;
} elseif ($v_bmi >= 13.2 and $v_bmi < 17) {
return 7;
} elseif ($v_bmi >= 17 and $v_bmi < 18.6) {
return 8;
} elseif ($v_bmi >= 18.6) {
return 9;
}
}
if($v_month==22) {
if ($v_bmi < 12.2) {
return 5;
} elseif ($v_bmi >= 12.2 and $v_bmi < 13.1) {
return 6;
} elseif ($v_bmi >= 13.1 and $v_bmi < 16.9) {
return 7;
} elseif ($v_bmi >= 16.9 and $v_bmi < 18.5) {
return 8;
} elseif ($v_bmi >= 18.5) {
return 9;
}
}
if($v_month==23) {
if ($v_bmi < 12.2) {
return 5;
} elseif ($v_bmi >= 12.2 and $v_bmi < 13.1) {
return 6;
} elseif ($v_bmi >= 13.1 and $v_bmi < 16.9) {
return 7;
} elseif ($v_bmi >= 16.9 and $v_bmi < 18.5) {
return 8;
} elseif ($v_bmi >= 18.5) {
return 9;
}
}
}
}else {
if ($gender == 2 or $gender == 1) {
if ($age == 2) {
if ($v_bmi < 14.4) {
return 1;
}
if ($v_bmi >= 14.4 and $v_bmi < 18) {
return 2;
}
if ($v_bmi >= 18 and $v_bmi <= 19) {
return 3;
}
if ($v_bmi > 19) {
return 4;
}
}
if ($age == 3) {
if ($v_bmi < 14) {
return 1;
}
if ($v_bmi >= 14 and $v_bmi < 17.2) {
return 2;
}
if ($v_bmi >= 17.2 and $v_bmi <= 18.5) {
return 3;
}
if ($v_bmi > 18.5) {
return 4;
}
}
if ($age == 4) {
if ($v_bmi < 13.5) {
return 1;
}
if ($v_bmi >= 13.5 and $v_bmi < 16.8) {
return 2;
}
if ($v_bmi >= 16.8 and $v_bmi <= 18) {
return 3;
}
if ($v_bmi > 18) {
return 4;
}
}
if ($age == 5) {
if ($v_bmi < 13) {
return 1;
}
if ($v_bmi >= 13 and $v_bmi < 16.8) {
return 2;
}
if ($v_bmi >= 16.8 and $v_bmi <= 18.2) {
return 3;
}
if ($v_bmi > 18.2) {
return 4;
}
}
if ($age == 6) {
if ($v_bmi < 13.4) {
return 1;
}
if ($v_bmi >= 13.4 and $v_bmi < 17.2) {
return 2;
}
if ($v_bmi >= 17.2 and $v_bmi <= 19) {
return 3;
}
if ($v_bmi > 19) {
return 4;
}
}
if ($age == 7) {
if ($v_bmi < 13.5) {
return 1;
}
if ($v_bmi >= 13.5 and $v_bmi < 17.5) {
return 2;
}
if ($v_bmi >= 17.5 and $v_bmi <= 19.5) {
return 3;
}
if ($v_bmi > 19.5) {
return 4;
}
}
if ($age == 8) {
if ($v_bmi < 13.5) {
return 1;
}
if ($v_bmi >= 13.5 and $v_bmi < 18.5) {
return 2;
}
if ($v_bmi >= 18.5 and $v_bmi <= 19.5) {
return 3;
}
if ($v_bmi > 19.5) {
return 4;
}
}
if ($age == 9) {
if ($v_bmi < 13.8) {
return 1;
}
if ($v_bmi >= 13.8 and $v_bmi < 19.5) {
return 2;
}
if ($v_bmi >= 19.5 and $v_bmi <= 21.8) {
return 3;
}
if ($v_bmi > 21.8) {
return 4;
}
}
if ($age == 10) {
if ($v_bmi < 14) {
return 1;
}
if ($v_bmi >= 14 and $v_bmi < 20) {
return 2;
}
if ($v_bmi >= 20 and $v_bmi <= 23) {
return 3;
}
if ($v_bmi > 23) {
return 4;
}
}
if ($age == 11) {
if ($v_bmi < 14.5) {
return 1;
}
if ($v_bmi >= 14.5 and $v_bmi < 20.8) {
return 2;
}
if ($v_bmi >= 20.8 and $v_bmi <= 24) {
return 3;
}
if ($v_bmi > 24) {
return 4;
}
}
if ($age == 12) {
if ($v_bmi < 14.8) {
return 1;
}
if ($v_bmi >= 14.8 and $v_bmi < 21.8) {
return 2;
}
if ($v_bmi >= 21.8 and $v_bmi <= 25.4) {
return 3;
}
if ($v_bmi > 25.4) {
return 4;
}
}
if ($age == 13) {
if ($v_bmi < 15.4) {
return 1;
}
if ($v_bmi >= 15.4 and $v_bmi < 22.5) {
return 2;
}
if ($v_bmi >= 22.5 and $v_bmi <= 26.4) {
return 3;
}
if ($v_bmi > 26.4) {
return 4;
}
}
if ($age == 14) {
if ($v_bmi < 15.8) {
return 1;
}
if ($v_bmi >= 15.8 and $v_bmi < 23.4) {
return 2;
}
if ($v_bmi >= 23.4 and $v_bmi <= 27.2) {
return 3;
}
if ($v_bmi > 27.2) {
return 4;
}
}
if ($age == 15) {
if ($v_bmi < 16.3) {
return 1;
}
if ($v_bmi >= 16.3 and $v_bmi < 24) {
return 2;
}
if ($v_bmi >= 24 and $v_bmi <= 28.1) {
return 3;
}
if ($v_bmi > 28.1) {
return 4;
}
}
if ($age == 16) {
if ($v_bmi < 16.8) {
return 1;
}
if ($v_bmi >= 16.8 and $v_bmi < 24.6) {
return 2;
}
if ($v_bmi >= 24.6 and $v_bmi <= 28.9) {
return 3;
}
if ($v_bmi > 28.9) {
return 4;
}
}
if ($age == 17) {
if ($v_bmi < 17.2) {
return 1;
}
if ($v_bmi >= 17.2 and $v_bmi < 25.2) {
return 2;
}
if ($v_bmi >= 25.2 and $v_bmi <= 29.5) {
return 3;
}
if ($v_bmi > 29.5) {
return 4;
}
}
if ($age == 18) {
if ($v_bmi < 17.5) {
return 1;
}
if ($v_bmi >= 17.5 and $v_bmi < 25.7) {
return 2;
}
if ($v_bmi >= 25.7 and $v_bmi <= 30.4) {
return 3;
}
if ($v_bmi > 30.4) {
return 4;
}
}
if ($age == 19) {
if ($v_bmi < 17.8) {
return 1;
}
if ($v_bmi >= 17.8 and $v_bmi < 26.1) {
return 2;
}
if ($v_bmi >= 26.1 and $v_bmi <= 31) {
return 3;
}
if ($v_bmi > 31) {
return 4;
}
}
if ($age == 20) {
if ($v_bmi < 17.9) {
return 1;
}
if ($v_bmi >= 17.9 and $v_bmi < 26.5) {
return 2;
}
if ($v_bmi >= 26.5 and $v_bmi <= 31.9) {
return 3;
}
if ($v_bmi > 31.9) {
return 4;
}
}
}
}
}
function showutf($txt){
if(empty($txt)){
return '';
}
$txt = mb_convert_encoding(trim($txt), "Windows-1252", "UTF-8");
$txt = html_entity_decode($txt,ENT_QUOTES | ENT_HTML5);
return html_entity_decode($txt);
}
function jsonutf($arr){
header('Content-Type: application/json');
return json_encode($arr,JSON_UNESCAPED_UNICODE);
}
function convert_ncr_to_utf8($str, $all = TRUE)
{
if (preg_match_all('/\&#(\d+)\;/', $str, $matches))
{
for ($i = 0, $s = count($matches['0']); $i < $s; $i++)
{
$digits = $matches['1'][$i];
$out = '';
if ($digits < 128)
{
$out .= chr($digits);
}
elseif ($digits < 2048)
{
$out .= chr(192 + (($digits - ($digits % 64)) / 64));
$out .= chr(128 + ($digits % 64));
}
else
{
$out .= chr(224 + (($digits - ($digits % 4096)) / 4096));
$out .= chr(128 + ((($digits % 4096) - ($digits % 64)) / 64));
$out .= chr(128 + ($digits % 64));
}
$str = str_replace($matches['0'][$i], $out, $str);
}
}
if ($all)
{
$str = str_replace(array("&", "<", ">", """, "'", "-"),
array("&","<",">","\"", "'", "-"),
$str);
}
return $str;
}
function check_date_input($date){
list($dd,$mm,$yyyy) = explode('-',$date);
if (!checkdate($mm,$dd,$yyyy)) {
return false;
}
return true;
}
function safeupload($file,$folder){
//$DOCUMENT_ROOT = str_replace('/public','',$_SERVER['DOCUMENT_ROOT']);
$DOCUMENT_ROOT = $_SERVER['DOCUMENT_ROOT'];
$link_img = '';
$arr_errors = array();
$maxsize = 10485760;
$acceptable = array(
'application/pdf',
'image/jpeg',
'image/jpg',
'image/gif',
'image/png',
'application/x-rar-compressed', 'application/octet-stream', 'application/zip','application/msword','application/vnd.openxmlformats-officedocument.wordprocessingml.document','application/vnd.ms-excel','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','application/vnd.ms-powerpoint','application/vnd.openxmlformats-officedocument.presentationml.presentation'
);
if(($file['size'] >= $maxsize) || ($file["size"] == 0)) {
return 1;
}
if(!in_array($file['type'], $acceptable) && !empty($file["type"])) {
return 2;
}
$time = time();
$file_name = $file['name'];
$year_now = date('Y');
$month_now = date('m');
/*if (!is_dir($DOCUMENT_ROOT."/upload/".$folder."/" . $year_now . "/" . $month_now )) {
if(mkdir($DOCUMENT_ROOT."/upload/".$folder."/" . $year_now . "/" . $month_now,0755,true)){
}else{
return 4;
}
}*/
$uniqid_file = uniqid();
$ext = get_file_extension($file_name);
$txt_file_name = str_replace(' ','-',convert_utf8_to_kd($file_name));
$file_name_new = $time.'-'.$uniqid_file.'-'.str_replace(array($ext,'.'),array('',''),substr($txt_file_name,0,50)).'.'.$ext;
$uploadURL = 'https://iportal.nhg.vn/upload.php';
$filePath = $file['tmp_name'];
$ch = curl_init();
// Create a CURLFile object
$fileData['files[0]'] = new CURLFile(
$filePath, // File path
mime_content_type($filePath), // MIME type (auto-detected)
$file_name_new // Filename to use on the server
);
$fileData['folder'] = 'bao_bai/'.date('Y').'/'.date('m');
// Set cURL options
curl_setopt_array($ch, array(
CURLOPT_URL => $uploadURL,
CURLOPT_POST => true,
CURLOPT_POSTFIELDS => $fileData,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_HEADER => false,
CURLOPT_SSL_VERIFYPEER => false, // For development only, enable in production
CURLOPT_TIMEOUT => 30 // Timeout in seconds
));
// Execute the cURL request
$response = curl_exec($ch);
$arr_res = json_decode($response,true);
// Check for errors
if (curl_errno($ch)) {
return 3;
}
$link_img = $arr_res[0]['file_path'];
return $link_img;
/*if(move_uploaded_file($file['tmp_name'], $DOCUMENT_ROOT.'/upload/'.$folder.'/'.$year_now.'/'.$month_now.'/'.$file_name_new)) {
$link_img = 'upload/' . $folder . '/' . $year_now . '/' . $month_now . '/' . $file_name_new;
return $link_img;
}else{
return 3;
}*/
}
function get_file_extension($file_name) {
return substr(strrchr($file_name,'.'),1);
}
function textformatdb($txt){
return mb_convert_encoding(trim($txt),'HTML-ENTITIES','UTF-8');
}
function get_subject_hk($v_school_id,$txt_hk,$v_khoi_id){
global $DB;
$q_school = $DB->query("SELECT SCHOOL_BRAND FROM TB_SCHOOL WHERE SCHOOL_ID='$v_school_id' ORDER BY SCHOOL_ID LIMIT 1 ");
while ($r_school = $DB->fetch_row($q_school)){
$txt_brand = strtoupper($r_school['SCHOOL_BRAND']);
}
if($txt_hk==1) {
$q_subject = $DB->query( "SELECT a.SUBJECT_ID , b.* FROM TB_SUBJECT" . $txt_brand . " a INNER JOIN TB_KHSB b ON a.SUBJECT_ID=b.SUBJECT_ID AND b.SCHOOL_ID='$v_school_id' AND b.HESOTD>0 AND b.KHOI_ID='$v_khoi_id' ORDER BY SUBJECT_ORDER DESC");
}else{
$q_subject = $DB->query( "SELECT a.SUBJECT_ID , b.* FROM TB_SUBJECT" . $txt_brand . " a INNER JOIN TB_KHSB b ON a.SUBJECT_ID=b.SUBJECT_ID AND b.SCHOOL_ID='$v_school_id' AND b.HESOTD_2>0 AND b.KHOI_ID='$v_khoi_id' ORDER BY SUBJECT_ORDER DESC");
}
$arr_subject_id = array();
while ($r_subject = $DB->fetch_row($q_subject)){
$arr_subject_id[] = $r_subject['SUBJECT_ID'];
}
return $arr_subject_id;
}
function get_subject_hk_chuong_trinh($v_school_id,$txt_hk,$v_khoi_id){
global $DB;
$q_school = $DB->query("SELECT SCHOOL_BRAND FROM TB_SCHOOL WHERE SCHOOL_ID='$v_school_id' ORDER BY SCHOOL_ID LIMIT 1 ");
while ($r_school = $DB->fetch_row($q_school)){
$txt_brand = strtoupper($r_school['SCHOOL_BRAND']);
}
if($txt_hk==1) {
$q_subject = $DB->query( "SELECT a.SUBJECT_ID , b.* FROM TB_SUBJECT" . $txt_brand . " a INNER JOIN TB_KHSB b ON a.SUBJECT_ID=b.SUBJECT_ID AND b.SCHOOL_ID='$v_school_id' AND b.KHOI_ID='$v_khoi_id' ORDER BY SUBJECT_ORDER DESC");
}else{
$q_subject = $DB->query( "SELECT a.SUBJECT_ID , b.* FROM TB_SUBJECT" . $txt_brand . " a INNER JOIN TB_KHSB b ON a.SUBJECT_ID=b.SUBJECT_ID AND b.SCHOOL_ID='$v_school_id' AND b.KHOI_ID='$v_khoi_id' ORDER BY SUBJECT_ORDER DESC");
}
$arr_subject_id = array();
while ($r_subject = $DB->fetch_row($q_subject)){
$arr_subject_id[] = $r_subject['SUBJECT_ID'];
}
return $arr_subject_id;
}
function is_pupil_class_combine($DB,$v_pupil_id,$learn_year){
$row_check = $DB->fetch_row($DB->query("SELECT CLASS_COMBINE_ID FROM TB_CLASS_COMBINE_PUPIL WHERE PUPIL_ID='$v_pupil_id' AND LEARN_YEAR='$learn_year' LIMIT 1 "));
if($row_check){
return $row_check['CLASS_COMBINE_ID'];
}
return false;
}
?>