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/management/infovps/ |
<?php
$fmt = new NumberFormatter( 'vi_VN', NumberFormatter::CURRENCY );
$v_infovps_id = 0;
$row_check = $DB->get_colum_tb('tb_infovps');
$row_check['infovps_begin'] = date('d-m-Y');
$row_check['infovps_end'] = date('d-m-Y');
$txt_log = '';
if(isset($CORE->input['infovps_id']) && $CORE->input['infovps_id']>0){
$v_infovps_id = $CORE->input['infovps_id'];
$row_check = $DB->fetch_row($DB->query("SELECT * FROM tb_infovps WHERE infovps_id='$v_infovps_id' "));
$row_check['infovps_begin'] = date('d-m-Y',strtotime($row_check['infovps_end']));
$row_check['infovps_end'] = date('d-m-Y');
//lich sư gia han
$txt_log = '';
$q_log = $DB->query("SELECT * FROM tb_infovps_log WHERE infovps_id='$v_infovps_id' ORDER BY time_post ASC");
while ($r_log = $DB->fetch_row($q_log)){
$txt_begin = date('d-m-Y', strtotime($r_log['infovps_begin']));
$txt_end = date('d-m-Y', strtotime($r_log['infovps_end']));
$txt_log .= '<tr><td>'.$r_log['infovps_log_id'].'</td><td>'.$txt_begin.'</td><td>'.$txt_end.'</td><td>'.$fmt->formatCurrency($r_log['infovps_price'],'VND').'</td><td>'.date('d-m-Y',$r_log['time_post']).'</td><td>'.$r_log['user_post'].'</td><td><a href="?act=management&code=infovps&type=del_log&infovps_id='.$v_infovps_id.'&log_id='.$r_log['infovps_log_id'].'" onclick="return confirm(\'Bạn có chắc muốn xóa?\')">Xóa</a> </td></tr>';
}
}
if(isset($CORE->input['submitbt'])) {
$f = $CORE->input['f'];
$v_infovps_id = $f['infovps_id'];
if (strtotime($f['infovps_end']) < strtotime($f['infovps_begin'])) {
exit('Sai thời gian!');
}
$txt_begin = date('Y-m-d', strtotime($f['infovps_begin']));
$txt_end = date('Y-m-d', strtotime($f['infovps_end']));
$v_pricebegin = preg_replace('/[^0-9]/', '', $f['infovps_price']);
$arr_insert_log = array('infovps_id' => $v_infovps_id, 'infovps_begin' => $txt_begin, 'infovps_end' => $txt_end, 'infovps_price' => $v_pricebegin, 'time_post' => time(), 'user_post' => $ob_user->user_name);
$row_check_log = $DB->fetch_row($DB->query("SELECT * FROM tb_infovps_log ORDER BY time_post DESC LIMIT 1 "));
if ($row_check_log['infovps_end'] > $txt_begin) {
exit('Thời gian bắt đầu phải lớn hơn thời gian kết thúc VPS!');
}
$DB->do_insert('tb_infovps_log',$arr_insert_log);
$row_vps = $DB->fetch_row($DB->query("SELECT * FROM tb_infovps WHERE infovps_id='$v_infovps_id' "));
$v_price = $row_vps['infovps_pricebegin']+$v_pricebegin;
$DB->query("UPDATE tb_infovps SET
infovps_end='$txt_end', infovps_pricebegin='$v_price'
WHERE infovps_id='".$v_infovps_id."'
");
$print->refresh('?act=management&code=infovps&type=giahanvps&infovps_id='.$v_infovps_id);
}
?>