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/admin.adimi/code/tracuuso/ |
<?php
$txt_date = $CORE->input['txt_date'];
$q_ngay = $DB->query("SELECT * FROM tb_kqxs_data WHERE kqxs_data_ngay ='$txt_date' ORDER BY kqxs_data_ngay, kqxs_data_mien ,kqxs_tinh_name, kqxs_data_giaikey='giai8' DESC,kqxs_data_giaikey='giaidbl' ASC, kqxs_data_giaikey DESC ");
$txt_show = '<table class="table table-bordered">';
$flag_ngay = $flag_mien = $flag_tinh = $flag_giai ='';
while ($r_ngay = $DB->fetch_row($q_ngay)) {
$txt_ngay = date('d-m-Y', strtotime($r_ngay['kqxs_data_ngay']));
$weekDay = date('w', strtotime($r_ngay['kqxs_data_ngay']));
if($flag_ngay!=$r_ngay['kqxs_data_ngay']) {
$txt_show .= '<tr><th class="red">' . $txt_ngay . '</th></tr>';
$flag_ngay=$r_ngay['kqxs_data_ngay'];
}
if($flag_mien!=$r_ngay['kqxs_data_mien']) {
if($r_ngay['kqxs_data_mien']==1){
$txt_mien='Miền Nam';
}
if($r_ngay['kqxs_data_mien']==2){
$txt_mien='Miền Trung';
}
if($r_ngay['kqxs_data_mien']==3){
$txt_mien='Miền Bắc';
}
$txt_show .= '<tr><th class="red">' . $txt_mien . '</th></tr>';
$flag_mien=$r_ngay['kqxs_data_mien'];
}
if($flag_tinh!=$r_ngay['kqxs_tinh_name']) {
if($weekDay!=6) {
$stt = 1;
$txt_show .= '<tr><th>' . $r_ngay['kqxs_tinh_name'] . '</th></tr>';
$flag_tinh = $r_ngay['kqxs_tinh_name'];
}else{
if($r_ngay['kqxs_tinh_key']!='binh-phuoc'){
$stt = 1;
$txt_show .= '<tr><th>' . $r_ngay['kqxs_tinh_name'] . '</th></tr>';
$flag_tinh = $r_ngay['kqxs_tinh_name'];
}
}
}
if($weekDay!=6) {
$txt_show .= '<tr><td> ' . $r_ngay['kqxs_data_sofull'] . '</td></tr>';
}else{
if($r_ngay['kqxs_tinh_key']!='binh-phuoc'){
$txt_show .= '<tr><td> ' . $r_ngay['kqxs_data_sofull'] . '</td></tr>';
}
}
}
$txt_show .= '</table>';
echo $txt_show;
exit();
?>