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'])){
$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_kq = $DB->query("SELECT * FROM tb_kqxs_data WHERE kqxs_data_ngay BETWEEN '".$date_begin."' AND '".$date_end."' GROUP BY kqxs_data_ngay");
$txt_show = '<table class="table table-bordered mt-2"><tr><th>Ngà y</th><th>Kết quả</th></tr>';
while ($r_kq = $DB->fetch_row($q_kq)){
$weekDay = date('w', strtotime($r_kq['kqxs_data_ngay']));
if($weekDay!=6) {
$q_kq2 = $DB->query("
SELECT *,
CONCAT(kqxs_data_chuc, kqxs_data_donvi) AS so_check,
count(*) as so_luong_so_check
FROM tb_kqxs_data
WHERE kqxs_data_ngay='" . $r_kq['kqxs_data_ngay'] . "' AND kqxs_tinh_key IN (SELECT kqxs_tinh_key FROM tb_kqxs_tinh WHERE kqxs_mien_key='mien-nam')
GROUP BY so_check ");
}else{
$q_kq2 = $DB->query("
SELECT *,
CONCAT(kqxs_data_chuc, kqxs_data_donvi) AS so_check,
count(*) as so_luong_so_check
FROM tb_kqxs_data
WHERE kqxs_data_ngay='" . $r_kq['kqxs_data_ngay'] . "' AND kqxs_tinh_key IN (SELECT kqxs_tinh_key FROM tb_kqxs_tinh WHERE kqxs_mien_key='mien-nam') AND kqxs_tinh_key!='binh-phuoc'
GROUP BY so_check ");
}
$socuoi = '';
while ($r_kq2 = $DB->fetch_row($q_kq2)){
if($r_kq2['so_luong_so_check']>=3){
$txt_tmp_tinh_key = $r_kq2['kqxs_tinh_key'];
/*$row_check_tinh = $DB->fetch_row($DB->query("SELECT CONCAT(kqxs_data_chuc, kqxs_data_donvi) AS so_check,count(*) as so_luong_so_check FROM tb_kqxs_data WHERE kqxs_tinh_key='".$txt_tmp_tinh_key."' AND kqxs_data_ngay='" . $r_kq['kqxs_data_ngay'] . "' HAVING so_check='".$r_kq2['so_check']."' "));*/
$arr_result['kqxs_data_id'] = $r_kq2['kqxs_data_id'];
$arr_result['kqxs_data_chuc'] = $r_kq2['kqxs_data_chuc'];
$arr_result['kqxs_data_donvi'] = $r_kq2['kqxs_data_donvi'];
$arr_result['so_check'] = $r_kq2['so_check'];
$arr_result['kqxs_tinh_key'] = $r_kq2['kqxs_tinh_key'];
//$arr_result['check_tinh'] = $row_check_tinh['so_luong_so_check'];
$list_result[$r_kq['kqxs_data_ngay']][] = $arr_result;
$socuoi .= $r_kq2['so_check'] . ',' . $r_kq2['so_luong_so_check'] . '<br/>';
}
//$socuoi .= $r_kq2['so_check'].','.$r_kq2['so_luong_so_check'].'<br/>';
//rieng thu 7 k tinh binh phuoc
}
}
}
if(!empty($list_result)){
foreach($list_result as $kqxs_data_ngay => $arr_val){
$weekDay = date('w', strtotime($kqxs_data_ngay));
$txt_show_check = '';
foreach ($arr_val as $val){
$so_check = $val['so_check'];
$kqxs_data_chuc = $val['kqxs_data_chuc'];
$kqxs_data_donvi = $val['kqxs_data_donvi'];
if($weekDay!=6) {
$q_check = $DB->query("SELECT *,CONCAT(kqxs_data_chuc, kqxs_data_donvi) AS `so_check` FROM tb_kqxs_data WHERE kqxs_data_chuc='$kqxs_data_chuc' AND kqxs_data_donvi='$kqxs_data_donvi' AND CONCAT(kqxs_data_chuc, kqxs_data_donvi)='$so_check' AND kqxs_data_ngay='$kqxs_data_ngay' AND kqxs_tinh_key IN (SELECT kqxs_tinh_key FROM tb_kqxs_tinh WHERE kqxs_mien_key='mien-nam') ");
}else{
$q_check = $DB->query("SELECT *,CONCAT(kqxs_data_chuc, kqxs_data_donvi) AS `so_check` FROM tb_kqxs_data WHERE kqxs_data_chuc='$kqxs_data_chuc' AND kqxs_data_donvi='$kqxs_data_donvi' AND CONCAT(kqxs_data_chuc, kqxs_data_donvi)='$so_check' AND kqxs_data_ngay='$kqxs_data_ngay' AND kqxs_tinh_key IN (SELECT kqxs_tinh_key FROM tb_kqxs_tinh WHERE kqxs_mien_key='mien-nam') AND kqxs_tinh_key!='binh-phuoc' ");
}
$arr_tinh_key = array();
while ($r_check = $DB->fetch_row($q_check)){
$arr_tinh_key[] = $r_check['kqxs_tinh_key'];
}
$arr_check = array_count_values($arr_tinh_key);
if(count($arr_check)>=2){
/*print_r($arr_check);
exit();*/
foreach($arr_check as $val_count){
if($val_count>=2){
$row_check_sox = $DB->fetch_row($DB->query("SELECT * FROM tb_kqxs_sox WHERE kqxs_sox_ngay='$kqxs_data_ngay' AND kqxs_sox_data='$so_check' "));
if(!$row_check_sox){
$arr_insert = array('kqxs_sox_ngay'=>$kqxs_data_ngay,'kqxs_sox_data'=>$so_check);
$DB->do_insert('tb_kqxs_sox',$arr_insert);
}
$txt_show_check .= $so_check.'<br/>';
}else{
$txt_show_check .= '';
}
}
}
}
$txt_show .= '<tr><td>'.date('d-m-Y',strtotime($kqxs_data_ngay)).'</td><td>'.$txt_show_check.'</td></tr>';
}
}
$txt_show .= '</table>';
/*print_r($list_result);
exit();*/
/*function check_result($list_result){
global $DB;
}*/
?>