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['s'])) {
$q_mien = $DB->query("SELECT * FROM tb_kqxs_tinh ");
while ($r_mien = $DB->fetch_row($q_mien)){
if($r_mien['kqxs_mien_key']=='mien-nam'){
$v_mien = 1;
}elseif ($r_mien['kqxs_mien_key']=='mien-trung'){
$v_mien = 2;
}else{
$v_mien = 3;
}
$DB->query("UPDATE tb_kqxs_data SET kqxs_data_mien='$v_mien' WHERE kqxs_tinh_key='".$r_mien['kqxs_tinh_key']."' ");
}
exit();
$s = $CORE->input['s'];
$date_begin = date('Y-m-d',strtotime($s['date_begin']));
$date_end = date('Y-m-d',strtotime($s['date_end']));
$txt_mien = 'mien-nam';
if(isset($s['mien'])) {
$txt_mien = $s['mien'];
}
$q_check_begin = $DB->query("SELECT * FROM tb_kqxs_sox WHERE kqxs_sox_ngay BETWEEN '$date_begin' AND '$date_end' ORDER BY kqxs_sox_ngay ASC");
$txt_show = '';
$count_total = $count_1 = $count_2 = $count_3 = $count_4 = $count_5 = 0;
while ($r_check_begin = $DB->fetch_row($q_check_begin)) {
$v_tmp_ngay = $r_check_begin['kqxs_sox_ngay'];
$v_tmp_so = $r_check_begin['kqxs_sox_data'];
if($txt_mien=='mien-nam') {//ngay 1
$r_check_trung_mien_nam = $DB->fetch_row($DB->query("SELECT * FROM tb_kqxs_data WHERE kqxs_data_socheck='$v_tmp_so' AND kqxs_data_ngay>'$v_tmp_ngay' AND kqxs_tinh_key IN (SELECT kqxs_tinh_key FROM tb_kqxs_tinh WHERE kqxs_mien_key='$txt_mien') ORDER BY kqxs_data_ngay ASC LIMIT 1 "));
}
if($txt_mien=='mien-trung') {//ngay 2
$r_check_trung_mien_nam = $DB->fetch_row($DB->query("SELECT * FROM tb_kqxs_data WHERE kqxs_data_socheck='$v_tmp_so' AND kqxs_data_ngay>'$v_tmp_ngay' AND kqxs_tinh_key IN (SELECT kqxs_tinh_key FROM tb_kqxs_tinh WHERE kqxs_mien_key='$txt_mien')
AND kqxs_data_socheck IN (SELECT kqxs_dutoan_so FROM tb_kqxs_dutoan WHERE kqxs_dutoan_khoangcach!='1' AND kqxs_dutoan_mien='mien-nam' AND kqxs_dutoan_ngaydanh='$v_tmp_ngay' )
ORDER BY kqxs_data_ngay ASC LIMIT 1 "));
}
if($txt_mien=='mien-bac') {//ngay 3
$r_check_trung_mien_nam = $DB->fetch_row($DB->query("SELECT * FROM tb_kqxs_data WHERE kqxs_data_socheck='$v_tmp_so' AND kqxs_data_ngay>'$v_tmp_ngay' AND kqxs_tinh_key IN (SELECT kqxs_tinh_key FROM tb_kqxs_tinh WHERE kqxs_mien_key='$txt_mien')
AND kqxs_data_socheck IN (
SELECT kqxs_dutoan_so FROM tb_kqxs_dutoan WHERE (kqxs_dutoan_khoangcach !='1' AND `kqxs_dutoan_mien`='mien-nam') OR (kqxs_dutoan_khoangcach !='2' AND `kqxs_dutoan_mien`='mien-trung') AND kqxs_dutoan_ngaydanh='$v_tmp_ngay'
)
ORDER BY kqxs_data_ngay ASC LIMIT 1 "));
}
if($r_check_trung_mien_nam) {
$khoang_cach = strtotime($r_check_trung_mien_nam['kqxs_data_ngay']) - strtotime($v_tmp_ngay);
$khoang_cach = $khoang_cach / (24 * 60 * 60);
$txt_show .= '<tr><td>' . $r_check_trung_mien_nam['kqxs_data_socheck'] . '</td><td>' . date('d-m-Y', strtotime($v_tmp_ngay)) . '</td><td>' . date('d-m-Y', strtotime($r_check_trung_mien_nam['kqxs_data_ngay'])) . '</td><td>' . $khoang_cach . '</td></tr>';
//echo 'Ngà y đánh: '.$v_tmp_ngay.' - Ngà y trúng: '.$r_check_trung_mien_nam['kqxs_data_ngay'].':'.$r_check_trung_mien_nam['kqxs_data_socheck'].'<br/>';
if ($khoang_cach == 1) {
$count_1++;
}
if ($khoang_cach == 2) {
$count_2++;
}
if ($khoang_cach == 3) {
$count_3++;
}
if ($khoang_cach == 4) {
$count_4++;
}
if ($khoang_cach >= 5) {
$count_5++;
}
$count_total++;
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_kqxs_dutoan WHERE kqxs_dutoan_so='" . $r_check_trung_mien_nam['kqxs_data_socheck'] . "' AND kqxs_dutoan_ngaydanh='" . $v_tmp_ngay . "' AND kqxs_dutoan_ngaytrung='" . $r_check_trung_mien_nam['kqxs_data_ngay'] . "' AND kqxs_dutoan_khoangcach='$khoang_cach' AND kqxs_dutoan_mien='$txt_mien' "));
if (!$row_check) {
$arr_insert = array('kqxs_dutoan_so' => $r_check_trung_mien_nam['kqxs_data_socheck'], 'kqxs_dutoan_ngaydanh' => $v_tmp_ngay, 'kqxs_dutoan_ngaytrung' => $r_check_trung_mien_nam['kqxs_data_ngay'], 'kqxs_dutoan_khoangcach' => $khoang_cach, 'kqxs_dutoan_mien' => $txt_mien);
$DB->do_insert('tb_kqxs_dutoan', $arr_insert);
}
}
}
}
?>