| Báo cáo thực thu |
|
|
| # |
Phòng |
Vào |
Ra |
Tiền phòng |
Giặt ủi |
Dịch vụ |
Thu khác |
Trừ khác |
Giảm giá |
Tổng |
Trả trước |
Thanh toán |
Bù Tips |
Tips |
Ghi chú |
| TM |
CK |
Thẻ |
TM |
CK |
Thẻ |
Nợ |
TM |
CK |
0,
'sum_giatui' => 0,
'sum_dichvu' => 0,
'sum_thukhac' => 0,
'sum_trukhac' => 0,
'sum_giamgia' => 0,
'sum_tongdong' => 0,
'sum_tm' => 0,
'sum_ck' => 0,
'sum_the' => 0,
'sum_no' => 0,
'sum_tratruoc_tm' => 0,
'sum_tratruoc_ck' => 0,
'sum_tratruoc_the' => 0,
'sum_tlk_tm' => 0,
'sum_tlk_ck' => 0,
'sum_tlk_the' => 0,
'sum_thukhac' => 0,
'sum_chi' => 0
);
$arr_tonghop['banve_tm'] = 0;
$arr_tonghop['banve_ck'] = 0;
$arr_tonghop['banve_the'] = 0;
$arr_tonghop['banve'] = 0;
$sum_tips = array('tm'=>0,'ck'=>0,'butips'=>0);
while($t < $t2){
if($chinhanh_id==351 && date('Y-m-d',$t)<='2022-03-24'){
$ngaybc_bd = date('Y-m-d',$t)." 08:00:00";
}else{
$ngaybc_bd = date('Y-m-d H:i:s',$t);
}
$ngaybc_kt = date('Y-m-d H:i:s',$t+86400);
if($chinhanh_id==203){
if(date('Y-m-d',$t+86400)<'2023-11-30'){
$ngaybc_bd = date('Y-m-d',$t)." 22:00:00";
$ngaybc_kt = date('Y-m-d',$t+86400)." 22:00:00";
// echo "-1--";
}elseif(date('Y-m-d',$t+86400)=='2023-11-30'){
$ngaybc_bd = date('Y-m-d',$t)." 22:00:00";
$ngaybc_kt = date('Y-m-d',$t+86400)." 18:00:00";
// echo "-2--";
}elseif(date('Y-m-d',$t+86400)<'2024-02-24'){
$ngaybc_bd = date('Y-m-d',$t)." 18:00:00";
$ngaybc_kt = date('Y-m-d',$t+86400)." 18:00:00";
}elseif(date('Y-m-d',$t+86400)=='2024-02-24'){
$ngaybc_bd = date('Y-m-d',$t)." 18:00:00";
$ngaybc_kt = date('Y-m-d',$t+86400)." 17:30:00";
}
// echo "-3--";
}
if($chinhanh_id==477){
if(date('Y-m-d',$t)<='2024-02-28'){
$ngaybc_bd = date('Y-m-d',$t)." 00:00:01";
$ngaybc_kt = date('Y-m-d',$t+86400)." 00:00:00";
// echo "-1--";
}elseif(date('Y-m-d',$t)=='2024-02-29'){
$ngaybc_bd = date('Y-m-d',$t)." 00:00:01";
$ngaybc_kt = date('Y-m-d',$t)." 23:00:00";
// echo "-2--";
}elseif(date('Y-m-d',$t)<'2024-04-01'){
$ngaybc_bd = date('Y-m-d',$t-86400)." 23:00:01";
$ngaybc_kt = date('Y-m-d',$t)." 23:00:00";
// echo "-2--";
}elseif(date('Y-m-d',$t)=='2024-04-01'){
$ngaybc_bd = date('Y-m-d',$t-86400)." 23:00:01";
$ngaybc_kt = date('Y-m-d',$t)." 22:00:00";
// echo "-2--";
}
}
// $ngaybc_bd = date('Y-m-d H:i:s',$t);
if($thoidiembaocao>='12:00'){
$ngay_hienthi = date('d/m/Y',$t+86400);
}else{
$ngay_hienthi = date('d/m/Y',$t);
}
?>
|
Ngày (".date('H:i d/m/Y',strtotime($ngaybc_bd))." - ".date('H:i d/m/Y',strtotime($ngaybc_kt))." )";?> |
getBaoCaoDoanhThu_Checkout($ngaybc_bd,$ngaybc_kt,$chinhanh_id,$time_format,$tc_baocao);
$thu_dichvule = 0;
if($tc_baocao=="DOANHTHUNGAY"){
$rs_tratruoc = $mBC->getDTTraTruocTrongNgay($ngaybc_bd,$ngaybc_kt,$chinhanh_id,$time_format);
$rs_tralaikhach = $mBC->getTraLaiKhach($ngaybc_bd,$ngaybc_kt,$chinhanh_id,$time_format);
$rs_thuno = $mBC->getBaoCaoDoanhThu_ThuNo($ngaybc_bd,$ngaybc_kt,$chinhanh_id,$time_format);
$rs_thuno_motphan = $mBC->getBaoCaoDoanhThu_ThuMotPhanNo($ngaybc_bd,$ngaybc_kt,$chinhanh_id,$time_format);
$rs_banve = $mTicket->getBaoCaoNgay_BanveSpa($ngaybc_kt,$chinhanh_id);
$thu_dichvule = $mBC->getBaoCaoThuDichVuLe(date('Y-m-d',strtotime($ngaybc_kt)),$thoidiembaocao.":00",$chinhanh_id);
// $tong_chi_ngay = $mChi->getTongChiNgay($chinhanh_id,$ngaybc_bd,$ngaybc_kt);
$rw_thukhac = $mThu->getTongThuNgay_HTTT($chinhanh_id,$ngaybc_bd,$ngaybc_kt);
$tong_thukhac_ngay = $rw_thukhac['TONGTHUKHAC'];
$tong_thukhac_ngay_tm = $rw_thukhac['THU_TM'];
$tong_thukhac_ngay_ck = $rw_thukhac['THU_CK'];
$tong_thukhac_ngay_the = $rw_thukhac['THU_THE'];
$tienvon = $mDVSD->getTienVon($chinhanh_id,$ngaybc_bd,$ngaybc_kt);
$tongchi_pl = $mChi->getTongChiNgay_HTTT($chinhanh_id,$ngaybc_bd,$ngaybc_kt);
$tong_chi_ngay = $tongchi_pl['tongchi_tm'] + $tongchi_pl['tongchi_ck'] + $tongchi_pl['tongchi_the'];
$tongchi_tinhchiphi+=$tongchi_pl['tongchi_tinhchiphi'];
$tongchi_ngoaichiphi+=$tongchi_pl['tongchi_ngoaichiphi'];
$tong_tienvon+=$tienvon;
}
// while($rw=$conn->fetchRow($rs)){
// if($rw['PH_DOAN']==1){
// $arrDoan[$rw['KLT_ID']] = $rw;
// }else{
// $arrBillPhong[] = $rw;
// }
// }
$count=0;
$sum_tm = 0;
$sum_ck = 0;
$sum_the = 0;
$sum_no = 0;
$sum_tratruoc_tm = 0;
$sum_tratruoc_ck = 0;
$sum_tratruoc_the = 0;
$sum_giatui = 0;
$sum_tienphong = 0;
$sum_dichvu = 0 ;
$sum_thukhac = 0;
$sum_trukhac = 0;
$sum_giamgia = 0;
$sum_tongdong = 0;
$sum_tips_ngay_tm = 0;
$sum_tips_ngay_ck = 0;
$sum_butips_ngay = 0;
while($rw=$conn->fetchRow($rs)){
// if(!isset($arr_idklt[$rw['KLT_ID']])){
// $arr_idklt[$rw['KLT_ID']] = $rw['KLT_ID'];
// }
$tips_tm = 0;
$tips_ck = 0;
$butips = 0;
if($cty_id==246){
if($rw['KLTEX_HTTTTIENBOA']==0){
$sum_tips['tm']+=$rw['KLTEX_TIENBOA'];
$sum_tips_ngay_tm+=$rw['KLTEX_TIENBOA'];
$tips_tm = $rw['KLTEX_TIENBOA'];
}elseif($rw['KLTEX_HTTTTIENBOA']==5){
$sum_tips['ck']+=$rw['KLTEX_TIENBOA'];
$sum_tips_ngay_ck+=$rw['KLTEX_TIENBOA'];
$tips_ck = $rw['KLTEX_TIENBOA'];
}
$sum_tips['butips']+= $rw['KLTEX_TIENBUTIPS'];
$sum_butips_ngay += $rw['KLTEX_TIENBUTIPS'];
$butips = $rw['KLTEX_TIENBUTIPS'];
}
$thu_tm = $rw['KLT_THANHTOAN_TM'] + $rw['KLT_THANHTOAN2_TM'];
$thu_ck = $rw['KLT_THANHTOAN_CK'] + $rw['KLT_THANHTOAN2_CK'];
$thu_the = $rw['KLT_THANHTOAN_THE'] + $rw['KLT_THANHTOAN2_HTTHE'];
// if($rw['PHONG_THANHTOAN']==NULL || ($rw['THOIDIEM_PHONGKHAC_THANHTOAN']!=NULL && strtotime($rw['THOIDIEM_PHONGKHAC_THANHTOAN']) > strtotime($ngaybc_kt) )){
$thu_no = $rw['KLT_THANHTOAN_NO'];
// }else{
// $thu_no = 0;
// }
if($rw['PH_DOAN']==1 && $thu_tm==0 && $thu_ck==0 && $thu_the==0 && $thu_no==0){
continue;
}
$sl_checkout++;
$count++;
$tienphong = $rw['KLT_TIENPHONG'];
$giatui = $rw['GIATUI'];
$dichvu = $rw['DICHVU'];
$thukhac = $rw['KLT_THUKHAC'];
$trukhac = $rw['KLT_TRUKHAC'] - $butips;
$giamgia = $rw['KLT_TIENKHUYENMAI'];
$tienphongkhac = $rw['KLT_TONGTIENPHONGKHAC'];
$sum_tm +=$thu_tm;
$sum_ck += $thu_ck;
$sum_the += $thu_the;
$sum_tratruoc_tm += $rw['TRATRUOC_TM'];
$sum_tratruoc_ck += $rw['TRATRUOC_CK'];
$sum_tratruoc_the += $rw['TRATRUOC_THE'];
$sum_tienphong += $tienphong;
$sum_giatui += $giatui;
$sum_dichvu += $dichvu;
$sum_thukhac += $thukhac;
$sum_trukhac += $trukhac;
$sum_giamgia += $giamgia;
$tong_dong = $tienphong + $giatui + $dichvu + $thukhac - $giamgia - $trukhac ;
$sum_tongdong += $tong_dong;
$arr_tong['sum_tienphong'] += $tienphong;
$arr_tong['sum_giatui'] += $giatui;
$arr_tong['sum_dichvu'] += $dichvu;
$arr_tong['sum_thukhac'] += $thukhac;
$arr_tong['sum_trukhac'] += $trukhac;
$arr_tong['sum_tongdong'] += $tong_dong;
$arr_tong['sum_giamgia'] += $giamgia;
$arr_tong['sum_tm'] += $thu_tm;
$arr_tong['sum_ck'] += $thu_ck;
$arr_tong['sum_the'] += $thu_the;
// if($rw['THOIDIEM_PHONGKHAC_THANHTOAN']!=NULL && strtotime($rw['THOIDIEM_PHONGKHAC_THANHTOAN']) <= $t2 ){
if($rw['PHONG_THANHTOAN']==NULL){
$sum_no += $thu_no;
}
if($rw['PHONG_THANHTOAN']==NULL && ( $rw['KLT_THOIDIEMTHANHTOANNO']===NULL || ($rw['KLT_THOIDIEMTHANHTOANNO']!=NULL && strtotime($rw['KLT_THOIDIEMTHANHTOANNO']) > $t2)) ){
$arr_tong['sum_no'] += $thu_no;
}
$arr_tong['sum_tratruoc_tm'] += $rw['TRATRUOC_TM'];
$arr_tong['sum_tratruoc_ck'] += $rw['TRATRUOC_CK'];
$arr_tong['sum_tratruoc_the'] += $rw['TRATRUOC_THE'];
?>
|
".$webhelper->decodeSpecialChar($rw['PH_TEN'])." (".$rw['KLT_SOHD'].") ".$webhelper->decodeSpecialChar($rw['KH_TEN'])." ";?> |
|
|
format_vn_number($tienphong,0);?> |
format_vn_number($giatui,0);?> |
format_vn_number($dichvu,0);?> |
format_vn_number($thukhac,0);?> |
format_vn_number($trukhac,0);?> |
format_vn_number($giamgia,0);?> |
format_vn_number($tong_dong,0);?> |
|
format_vn_number($rw['TRATRUOC_CK'],0);?> |
format_vn_number($rw['TRATRUOC_THE'],0);?> |
|
format_vn_number($thu_ck,0);?> |
format_vn_number($thu_the,0);?> |
;">format_vn_number($thu_no,0);?> |
format_vn_number($butips,0);?> |
format_vn_number($tips_tm,0);?> |
format_vn_number($tips_ck,0);?> |
0){
echo "";
if($rw['KLT_KHUYENMAI']>100){
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."/ngày";
}else{
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."%";
}
echo "
";
}
if($tienphongkhac!=0){
echo "Nhận nợ: ".WebHelper::format_vn_number($tienphongkhac)."
";
echo $mBC->getPhongChuyenNo($rw['KLT_ID']);
}
if($rw['PHONG_THANHTOAN']!=NULL){
if($rw['THOIDIEM_PHONGKHAC_THANHTOAN']!=NULL && strtotime($rw['THOIDIEM_PHONGKHAC_THANHTOAN']) <= strtotime($ngaybc_kt) ){
$note = "(Đã thanh toán trong ngày)";
}elseif($rw['THOIDIEM_PHONGKHAC_THANHTOAN']!=NULL && strtotime($rw['THOIDIEM_PHONGKHAC_THANHTOAN']) <= $t2 ){
$note = "(Đã thanh toán trong kỳ)";
}else{
$note= "";
}
echo "P. ".$rw['PHONG_THANHTOAN']." thanh toán ".$note." ";
}elseif($rw['PHONG_NHANNO']){
echo "Chuyển vào P. ".$rw['PHONG_NHANNO']." ";
}
if($rw['KLT_KPTVAOSOM']==1){
echo "KPT Vào sớm ";
}
if($rw['KLT_KPTTRATRE']==1){
echo "KPT Trả trễ ";
}
if($rw['CHITIETTRTRUOC']!=NULL){
echo "".$rw['CHITIETTRTRUOC']." ";
}
// echo $webhelper->decodeSpecialChar($rw['KLT_GHICHU']);
?>
|
0){
$count++;
$arr_tong['sum_tm'] += $thu_dichvule;
$arr_tong['sum_dichvu'] += $thu_dichvule;
$arr_tong['sum_tongdong'] += $thu_dichvule;
$sum_tm +=$thu_dichvule;
$sum_dichvu += $thu_dichvule;
$sum_tongdong += $thu_dichvule;
?>
|
Bán lẻ dịch vụ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
numRows($rs_banve)>0){
while($rw=$conn->fetchRow($rs_banve)){
$count++;
$arr_tonghop['banve_tm'] = $rw['TICKET_TM'];
$arr_tonghop['banve_ck'] = $rw['TICKET_CK'];
$arr_tonghop['banve_the'] = $rw['TICKET_THE'];
$arr_tonghop['banve'] += $rw['TICKET_SOTIEN'];
?>
|
Khách hàng: decodeSpecialChar($rw['KH_TEN'])." nạp tiền lúc ".$rw['TICKET_THOIDIEM_DM'] ." "."".$rw['TICKET_THOIDIEM_HI']."";
if($rw['TICKET_KHUYENMAI']>0){
echo ", giảm giá: ".WebHelper::format_vn_number($rw['TICKET_KHUYENMAI']);
}
?> |
|
|
|
|
|
0){
echo $webhelper->format_vn_number($rw['TICKET_TM'],0);
$arr_tong['sum_tratruoc_tm'] += $rw['TICKET_TM'];
$sum_tratruoc_tm += $rw['TICKET_TM'];
};?>
|
0){
echo $webhelper->format_vn_number($rw['TICKET_CK'],0);
$arr_tong['sum_tratruoc_ck'] += $rw['TICKET_CK'];
$sum_tratruoc_ck += $rw['TICKET_CK'];
};?>
|
0){
echo $webhelper->format_vn_number($rw['TICKET_THE'],0);
$arr_tong['sum_tratruoc_the'] += $rw['TICKET_THE'];
$sum_tratruoc_the += $rw['TICKET_THE'];
};?>
|
|
|
|
|
|
0){
$count++;
$arr_tong['sum_tm'] += $tong_thukhac_ngay_tm;
$arr_tong['sum_ck'] += $tong_thukhac_ngay_ck;
$arr_tong['sum_the'] += $tong_thukhac_ngay_the;
$arr_tong['sum_thukhac'] += $tong_thukhac_ngay;
$sum_tm +=$tong_thukhac_ngay_tm;
$sum_ck +=$tong_thukhac_ngay_ck;
$sum_the +=$tong_thukhac_ngay_the;
?>
|
Thu khoản khác |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
numRows($rs_thuno)>0 || $conn->numRows($rs_thuno_motphan)>0)){
?>
|
Thu nợ trong ngày
|
fetchRow($rs_thuno)){
$count++;
$thu_tm = $rw['KLT_THANHTOAN2_TM'] + $rw['TRATRUOC_TM'];
$thu_ck = $rw['KLT_THANHTOAN2_CK'] + $rw['TRATRUOC_CK'];
$thu_the =$rw['KLT_THANHTOAN2_HTTHE'] + $rw['TRATRUOC_THE'];
$thu_no =0;
$tienphong = $rw['KLT_TIENPHONG'];
$giatui = $rw['GIATUI'];
$dichvu = $rw['DICHVU'];
$thukhac = $rw['KLT_THUKHAC'];
$trukhac = $rw['KLT_TRUKHAC'];
$giamgia = $rw['KLT_TIENKHUYENMAI'];
$tienphongkhac = $rw['KLT_TONGTIENPHONGKHAC'];
$tong_dong_1 = $tienphong + $giatui + $dichvu + $thukhac - $giamgia - $trukhac ;
$arr_tong['sum_tm'] += $thu_tm;
$arr_tong['sum_ck'] += $thu_ck;
$arr_tong['sum_the'] += $thu_the;
$sum_tm +=$thu_tm;
$sum_ck += $thu_ck;
$sum_the += $thu_the;
?>
|
".$webhelper->decodeSpecialChar($rw['PH_TEN'])." (".$rw['KLT_SOHD'].") ".$webhelper->decodeSpecialChar($rw['KH_TEN'])." ";?> |
|
|
format_vn_number($tienphong,0);?> |
format_vn_number($giatui,0);?> |
format_vn_number($dichvu,0);?> |
format_vn_number($thukhac,0);?> |
format_vn_number($trukhac,0);?> |
format_vn_number($giamgia,0);?> |
format_vn_number($tong_dong_1,0);?> |
|
|
|
|
format_vn_number($thu_ck,0);?> |
format_vn_number($thu_the,0);?> |
format_vn_number($thu_no,0);?> |
0){
echo "";
if($rw['KLT_KHUYENMAI']>100){
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."/ngày";
}else{
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."%";
}
echo "
";
}
if($tienphongkhac!=0){
echo "Nhận nợ: ".WebHelper::format_vn_number($tienphongkhac)."
";
}
?>
|
fetchRow($rs_thuno_motphan)){
$count++;
$thu_tm = $rw['TRATRUOC_TM'];
$thu_ck = $rw['TRATRUOC_CK'];
$thu_the = $rw['TRATRUOC_THE'];
$thu_no =0;
$tienphong = $rw['KLT_TIENPHONG'];
$giatui = $rw['GIATUI'];
$dichvu = $rw['DICHVU'];
$thukhac = $rw['KLT_THUKHAC'];
$trukhac = $rw['KLT_TRUKHAC'];
$giamgia = $rw['KLT_TIENKHUYENMAI'];
$tienphongkhac = $rw['KLT_TONGTIENPHONGKHAC'];
$tong_dong_1 = $tienphong + $giatui + $dichvu + $thukhac - $giamgia - $trukhac ;
$arr_tong['sum_tm'] += $thu_tm;
$arr_tong['sum_ck'] += $thu_ck;
$arr_tong['sum_the'] += $thu_the;
$sum_tm +=$thu_tm;
$sum_ck += $thu_ck;
$sum_the += $thu_the;
?>
|
".$webhelper->decodeSpecialChar($rw['PH_TEN'])." (".$rw['KLT_SOHD'].") ".$webhelper->decodeSpecialChar($rw['KH_TEN'])." ";?> |
|
|
format_vn_number($tienphong,0);?> |
format_vn_number($giatui,0);?> |
format_vn_number($dichvu,0);?> |
format_vn_number($thukhac,0);?> |
format_vn_number($trukhac,0);?> |
format_vn_number($giamgia,0);?> |
format_vn_number($tong_dong_1,0);?> |
|
|
|
|
format_vn_number($thu_ck,0);?> |
format_vn_number($thu_the,0);?> |
format_vn_number($thu_no,0);?> |
0){
echo "";
if($rw['KLT_KHUYENMAI']>100){
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."/ngày";
}else{
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."%";
}
echo "
";
}
echo "Thu một phần nợ
";
?>
|
numRows($rs_tratruoc)>0){
?>
|
Thu trả trước trong ngày
|
fetchRow($rs_tratruoc)){
$count++;
$thu_tm = 0;
$thu_ck = 0;
$thu_the =0;
$thu_no =0;
// $tienphong = $rw['KLT_TIENPHONG'];
$giatui = 0;// $rw['GIATUI'];
$dichvu = 0;//$rw['DICHVU'];
$thukhac = 0;// $rw['KLT_THUKHAC'];
$trukhac = 0;//$rw['KLT_TRUKHAC'];
$giamgia = 0;//$rw['KLT_TIENKHUYENMAI'];
$tienphongkhac = 0;//$rw['KLT_TONGTIENPHONGKHAC'];
$sum_tratruoc_tm += $rw['TRATRUOC_TM'];
$sum_tratruoc_ck += $rw['TRATRUOC_CK'];
$sum_tratruoc_the += $rw['TRATRUOC_THE'];
// $sum_tienphong += $tienphong;
$sum_giatui += $giatui;
$sum_dichvu += $dichvu ;
$sum_thukhac += $thukhac ;
$sum_trukhac += $trukhac;
$sum_giamgia += $giamgia;
$tong_dong = $tienphong + $giatui + $dichvu + $thukhac - $giamgia - $trukhac ;
// $sum_tongdong += $tong_dong;
// $arr_tong['sum_tienphong'] += $tienphong;
// $arr_tong['sum_giatui'] += $giatui;
// $arr_tong['sum_dichvu'] += $dichvu + $thukhac;
// $arr_tong['sum_trukhac'] += $trukhac;
// $arr_tong['sum_tongdong'] += $tong_dong;
// $arr_tong['sum_giamgia'] += $giamgia;
$arr_tong['sum_tm'] += $thu_tm;
$arr_tong['sum_ck'] += $thu_ck;
$arr_tong['sum_the'] += $thu_the;
$arr_tong['sum_tratruoc_tm'] += $rw['TRATRUOC_TM'];
$arr_tong['sum_tratruoc_ck'] += $rw['TRATRUOC_CK'];
$arr_tong['sum_tratruoc_the'] += $rw['TRATRUOC_THE'];
?>
|
".$webhelper->decodeSpecialChar($rw['PH_TEN'])." (".$rw['KLT_SOHD'].") ".$webhelper->decodeSpecialChar($rw['KH_TEN'])." ";?> |
|
|
format_vn_number($tienphong,0);?> |
format_vn_number($giatui,0);?> |
format_vn_number($dichvu,0);?> |
format_vn_number($thukhac,0);?> |
format_vn_number($trukhac,0);?> |
format_vn_number($giamgia,0);?> |
format_vn_number($tong_dong,0);?> |
|
format_vn_number($rw['TRATRUOC_CK'],0);?> |
format_vn_number($rw['TRATRUOC_THE'],0);?> |
|
format_vn_number($thu_ck,0);?> |
format_vn_number($thu_the,0);?> |
;">format_vn_number($thu_no,0);?> |
0){
echo "";
if($rw['KLT_KHUYENMAI']>100){
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."/ngày";
}else{
echo "G.giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."%";
}
echo "
";
}
if($tienphongkhac!=0){
echo "Nhận nợ: ".WebHelper::format_vn_number($tienphongkhac)."
";
}
?>
|
numRows($rs_tralaikhach)>0){
?>
|
Hủy đặt phòng - Tiền trả lại khách
|
fetchRow($rs_tralaikhach)){
$count++;
$trakhach_tm = $rw['TLK_TM'];
$trakhach_ck = $rw['TLK_CK'];
$trakhach_the = $rw['TLK_THE'];
$arr_tong['sum_tlk_tm'] += $rw['TLK_TM'];
$arr_tong['sum_tlk_ck'] += $rw['TLK_CK'];
$arr_tong['sum_tlk_the'] += $rw['TLK_THE'];
// $sum_tm -=$trakhach_tm;
// $sum_ck -= $trakhach_ck;
// $sum_the -= $trakhach_the;
$sum_tratruoc_tm += $trakhach_tm;
$sum_tratruoc_ck += $trakhach_ck;
$sum_tratruoc_the += $trakhach_the;
$arr_tong['sum_tratruoc_tm'] +=$trakhach_tm;
$arr_tong['sum_tratruoc_ck'] += $trakhach_ck;
$arr_tong['sum_tratruoc_the'] += $trakhach_the;
// $arr_tong['sum_tm'] -= $trakhach_tm;
// $arr_tong['sum_ck'] -= $trakhach_ck;
// $arr_tong['sum_the'] -= $trakhach_the;
?>
|
".$webhelper->decodeSpecialChar($rw['PH_TEN'])." (".$rw['KLT_SOHD'].") ".$webhelper->decodeSpecialChar($rw['KH_TEN'])." ";?> |
|
|
|
|
|
|
|
|
|
|
format_vn_number($trakhach_ck,0);?> |
format_vn_number($trakhach_the,0);?> |
|
|
|
|
Hủy đặt phòng |
0){
$count++;
$arr_tong['sum_chi'] += $tong_chi_ngay;
$arr_tong['sum_tm'] -= $tongchi_pl['tongchi_tm'];
$arr_tong['sum_ck'] -= $tongchi_pl['tongchi_ck'];
$arr_tong['sum_the'] -= $tongchi_pl['tongchi_the'];
$sum_tm -=$tongchi_pl['tongchi_tm'];
$sum_ck -= $tongchi_pl['tongchi_ck'];
$sum_the -= $tongchi_pl['tongchi_the'];
?>
|
Chi trong ngày |
|
|
|
|
|
|
|
|
|
|
|
|
0){echo "-";}; echo WebHelper::format_vn_number($tongchi_pl['tongchi_tm'],0);?> |
0){echo "-";}; echo WebHelper::format_vn_number($tongchi_pl['tongchi_ck'],0);?> |
0){echo "-";}; echo WebHelper::format_vn_number($tongchi_pl['tongchi_the'],0);?> |
|
|
| Cộng ngày |
format_vn_number($sum_tienphong,0);?> |
format_vn_number($sum_giatui,0);?> |
format_vn_number($sum_dichvu,0);?> |
format_vn_number($sum_thukhac,0);?> |
format_vn_number($sum_trukhac,0);?> |
format_vn_number($sum_giamgia,0);?> |
format_vn_number($sum_tongdong,0);?> |
format_vn_number($sum_tratruoc_tm,0);?> |
format_vn_number($sum_tratruoc_ck,0);?> |
format_vn_number($sum_tratruoc_the,0);?> |
format_vn_number($sum_tm,0); //echo "
".WebHelper::format_vn_number($arr_tong['sum_tm'])?> |
format_vn_number($sum_ck,0);?> |
format_vn_number($sum_the,0);?> |
format_vn_number($sum_no,0);?> |
format_vn_number($sum_butips_ngay,0);?> |
format_vn_number($sum_tips_ngay_tm,0);?> |
format_vn_number($sum_tips_ngay_ck,0);?> |
|
| Tổng cộng |
format_vn_number($arr_tong['sum_tienphong'],0);?> |
format_vn_number($arr_tong['sum_giatui'],0);?> |
format_vn_number($arr_tong['sum_dichvu'],0);?> |
format_vn_number($arr_tong['sum_thukhac'],0);?> |
format_vn_number($arr_tong['sum_trukhac'],0);?> |
format_vn_number($arr_tong['sum_giamgia'],0);?> |
format_vn_number($arr_tong['sum_tongdong'],0);?> |
format_vn_number($arr_tong['sum_tratruoc_tm'],0);?> |
format_vn_number($arr_tong['sum_tratruoc_ck'],0);?> |
format_vn_number($arr_tong['sum_tratruoc_the'],0);?> |
format_vn_number($arr_tong['sum_tm'],0);?> |
format_vn_number($arr_tong['sum_ck'],0);?> |
format_vn_number($arr_tong['sum_the'],0);?> |
format_vn_number($arr_tong['sum_no'],0);?> |
format_vn_number($sum_tips['butips'],0);?> |
format_vn_number($sum_tips['tm'],0);?> |
format_vn_number($sum_tips['ck'],0);?> |
|
| Lượt phòng checkout trong kỳ: |
Tiền mặt |
Chuyển khoản |
Trả thẻ |
Thực thu (1) |
Nợ lại (2) |
Cộng (1 + 2) |
|
(1)
|
Doanh thu phòng
(Không tính thu nợ tháng trước và thu cọc checkin tháng sau)
|
|
|
|
|
|
|
|
(*)
|
Thu tiền nộp tài khoản khách/ Bán liệu trình
|
|
|
|
|
|
- |
|
(2)
|
Thu khác
|
|
|
|
|
- |
- |
|
(1 + 2)
|
Doanh thu
|
|
|
|
|
|
|
|
(3)
|
Chi khác
|
|
|
|
|
- |
- |
|
(1 + 2 - 3)
|
Doanh thu - Chi
|
|
|
|
|
|
|
|
(1*)
|
Tips
|
|
|
|
|
|
|
|
(2*)
|
Chi lương
|
|
|
|
|
|
|
|
(1*)-(2*)
|
Lương: Thu - Chi
|
|
|
|
|
|
|
|
|
Thu - Chi (Vé + Tips)
|
|
|
|
|
|
|
|
(4)
|
Thu nợ checkout trước
|
|
|
|
|
- |
- |
|
(5)
|
Thu cọc checkin sau
|
|
|
|
|
- |
- |
|
(1 + 2 - 3 + 4 + 5)
|
Thực thu - chi
|
|
|
|
|
- |
- |
Tổng hợp doanh thu:
Doanh thu phòng chưa giảm giá: format_vn_number($arr_tong['sum_tienphong'],0);?> Tổng tiền giảm giá tiền phòng: format_vn_number($arr_tong['sum_giamgia'],0);?> Doanh thu tiền phòng đã giảm giá: format_vn_number($arr_tong['sum_tienphong'] - $arr_tong['sum_giamgia'],0);?> Thu dịch vụ + giặt ủi: format_vn_number($arr_tong['sum_giatui'] + $arr_tong['sum_dichvu'],0);?> Tổng khoản trừ khác: format_vn_number($arr_tong['sum_trukhac'] ,0);?> Tổng doanh thu: format_vn_number($arr_tong['sum_tongdong'],0);?>
Tổng hợp thực thu:
Tổng thu tiền mặt: format_vn_number($arr_tong['sum_tm'] + $arr_tong['sum_tratruoc_tm'] + $arr_tong['sum_chi'],0);?> Tổng thu chuyển khoản: format_vn_number($arr_tong['sum_ck'] + $arr_tong['sum_tratruoc_ck'],0);?> Tổng thu qua thẻ: format_vn_number($arr_tong['sum_the'] + $arr_tong['sum_tratruoc_the'],0);?> Tổng thu khoản khác (đã cộng vào thu tiền mặt): format_vn_number($arr_tong['sum_thukhac'],0);?> Tổng chi: format_vn_number($arr_tong['sum_chi'] ,0);?> Tổng thực thu: format_vn_number($arr_tong['sum_tm'] + $arr_tong['sum_tratruoc_tm'] + $arr_tong['sum_the'] + $arr_tong['sum_tratruoc_the']+$arr_tong['sum_ck'] + $arr_tong['sum_tratruoc_ck'],0);?> Tổng nợ chưa thanh toán: format_vn_number($arr_tong['sum_no'] ,0);?>
Tổng tiền vốn dịch vụ: format_vn_number($tong_tienvon,0);?> Chi tiết chi:
Tổng chi tính chi phí: format_vn_number($tongchi_tinhchiphi,0);?> Tổng chi ngoài chi phí: format_vn_number($tongchi_ngoaichiphi,0);?>
|