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
if(isset($CORE->input['submitbt']) or isset($CORE->input['submitbt_excel']) ) {
$s = $CORE->input['s'];
$date_begin = date('Y-m-d', strtotime($s['date_begin']));
$date_end = date('Y-m-d', strtotime($s['date_end']));
$q_ngay = $DB->query("SELECT * FROM tb_kqxs_data WHERE kqxs_data_ngay BETWEEN '$date_begin' AND '$date_end' 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)) {
$arr_ngay[] = $r_ngay['kqxs_data_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 . ' <a href="javascript:void(0);" onclick="copyToClipboard(\''.$r_ngay['kqxs_data_ngay'].'\');">[Copy to clipboard]</a></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>';
}
}
$stt++;
}
$txt_show .= '</table>';
if( isset($CORE->input['submitbt_excel'])){
require_once('lib/HtmlExcel.php');
$css = "
.red {
color: red;
}";
$xls = new HtmlExcel();
$xls->setCss($css);
$xls->addSheet("Numbers", $txt_show);
//$xls->addSheet("Names", $names);
$xls->headers();
echo $xls->buildFile();
}
}
?>