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/infotratruoc/ |
<?php
$fmt = new NumberFormatter( 'vi_VN', NumberFormatter::CURRENCY );
$txt_list = '<table class="table table-bordered">';
$q_vps = $DB->query("SELECT * FROM tb_infovps ORDER BY infovps_begin ASC");
$txt_list .= '<tr><th colspan="5">Phí VPS</th></tr>';
$txt_list .= '<tr><td>ID</td><td>VPS IP</td><td>Bắt đầu</td><td>Kết thúc</td><td>Số tiền</td></tr>';
$total_vps = 0;
while ($r_vps = $DB->fetch_row($q_vps)){
$txt_list .= '<tr><td><a href="?act=management&code=infovps&type=post&infovps_id='.$r_vps['infovps_id'].'">'.$r_vps['infovps_id'].'</a></td><td>'.$r_vps['infovps_ip'].'</td><td>'.date('d-m-Y',strtotime($r_vps['infovps_begin'])).'</td><td>'.date('d-m-Y',strtotime($r_vps['infovps_end'])).'</td><td>'.$fmt->formatCurrency($r_vps['infovps_pricebegin'],'VND').'</td></tr>';
$total_vps+= $r_vps['infovps_pricebegin'];
}
$txt_list .= '<tr><td colspan="4">Total phí VPS</td><td>'.$fmt->formatCurrency($total_vps,'VND').'</td></tr>';
$q_hosting = $DB->query("SELECT * FROM tb_infohosting ORDER BY infohosting_begin ASC");
$txt_list .= '<tr><th colspan="5">Phí HOSTING</th></tr>';
$txt_list .= '<tr><td>ID</td><td>HOSTING IP</td><td>Bắt đầu</td><td>Kết thúc</td><td>Số tiền</td></tr>';
$total_hosting = 0;
while ($r_hosting = $DB->fetch_row($q_hosting)){
$txt_list .= '<tr><td><a href="?act=management&code=infohosting&type=post&infohosting_id='.$r_hosting['infohosting_id'].'">'.$r_hosting['infohosting_id'].'</a></td><td>'.$r_hosting['infohosting_ip'].'</td><td>'.date('d-m-Y',strtotime($r_hosting['infohosting_begin'])).'</td><td>'.date('d-m-Y',strtotime($r_hosting['infohosting_end'])).'</td><td>'.$fmt->formatCurrency($r_hosting['infohosting_pricebegin'],'VND').'</td></tr>';
$total_hosting+= $r_hosting['infohosting_pricebegin'];
}
$txt_list .= '<tr><td colspan="4">Total phí hosting</td><td>'.$fmt->formatCurrency($total_hosting,'VND').'</td></tr>';
$q_domain = $DB->query("SELECT * FROM tb_infodomain ORDER BY infodomain_begin ASC");
$txt_list .= '<tr><th colspan="5">Phí domain</th></tr>';
$txt_list .= '<tr><td>ID</td><td>Domain</td><td>Bắt đầu</td><td>Kết thúc</td><td>Số tiền</td></tr>';
$total_domain = 0;
while ($r_domain = $DB->fetch_row($q_domain)){
$txt_list .= '<tr><td><a href="?act=management&code=infodomain&type=post&infodomain_id='.$r_domain['infodomain_id'].'">'.$r_domain['infodomain_id'].'</a></td><td>'.$r_domain['infodomain_domain'].'</td><td>'.date('d-m-Y',strtotime($r_domain['infodomain_begin'])).'</td><td>'.date('d-m-Y',strtotime($r_domain['infodomain_end'])).'</td><td>'.$fmt->formatCurrency($r_domain['infodomain_pricebegin'],'VND').'</td></tr>';
$total_domain+= $r_domain['infodomain_pricebegin'];
}
$txt_list .= '<tr><td colspan="4">Total phí domain</td><td>'.$fmt->formatCurrency($total_domain,'VND').'</td></tr>';
$r_tratruoc = $DB->fetch_row($DB->query("SELECT sum(infotratruoc_sotien) as total_tratruoc FROM tb_infotratruoc "));
$txt_list .= '<tr><td colspan="4">Trả trước</td><td class="text-success">'.$fmt->formatCurrency($r_tratruoc['total_tratruoc'],'VND').'</td></tr>';
$v_con = ($r_tratruoc['total_tratruoc']-($total_vps+$total_hosting+$total_domain));
$txt_list .= '<tr><th colspan="4">Còn lại</th><th class="text-danger">'.$fmt->formatCurrency($v_con,'VND').'</th></tr>';
$txt_list .= '</table>';
?>