|
|
|
| # |
Phòng |
Vào |
Ra |
Tiền phòng |
Dịch vụ |
Trừ khác |
Trả trước |
Tổng |
Thanh toán |
Trả nợ |
Giảm giá |
Ghi chú |
| TM |
CK |
Thẻ |
Nợ |
FOC |
TM |
CK |
Thẻ |
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_foc = 0;
$sum_tm2 = 0;
$sum_ck2 = 0;
$sum_the2 = 0;
$sum_tienphong = 0;
$sum_dichvu = 0 ;
$sum_trukhac = 0;
$sum_tongdong = 0;
$sum_tratruoc = 0;
foreach($arrBillPhong as $i=>$rw){
// if($rw['PH_DOAN']==1){
// $arrDoan[] = $rw;
// }else{
$count++;
//Xu ly No
if($rw['KLT_IDKLT_DOAN']!=null && $rw['KLT_THANHTOAN_NO']>0){
$idklt_doan = $rw['KLT_IDKLT_DOAN'];
if(isset($arrDoan[$idklt_doan])){
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_TM']>0){
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_TM'] >=$rw['KLT_THANHTOAN_NO']){
$rw['KLT_THANHTOAN_TM'] += $rw['KLT_THANHTOAN_NO'];
$arrDoan[$idklt_doan]['KLT_THANHTOAN_TM'] -= $rw['KLT_THANHTOAN_NO'];
$rw['KLT_THANHTOAN_NO'] = 0;
}else{
$rw['KLT_THANHTOAN_TM'] += $arrDoan[$idklt_doan]['KLT_THANHTOAN_TM'];
$rw['KLT_THANHTOAN_NO'] -= $arrDoan[$idklt_doan]['KLT_THANHTOAN_TM'];
$arrDoan[$idklt_doan]['KLT_THANHTOAN_TM'] = 0;
}
}
//
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_CK']>0 && $rw['KLT_THANHTOAN_NO']>0){
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_CK'] >=$rw['KLT_THANHTOAN_NO']){
$rw['KLT_THANHTOAN_CK'] += $rw['KLT_THANHTOAN_NO'];
$arrDoan[$idklt_doan]['KLT_THANHTOAN_CK'] -= $rw['KLT_THANHTOAN_NO'];
$rw['KLT_THANHTOAN_NO'] = 0;
}else{
$rw['KLT_THANHTOAN_CK'] += $arrDoan[$idklt_doan]['KLT_THANHTOAN_CK'];
$rw['KLT_THANHTOAN_NO'] -= $arrDoan[$idklt_doan]['KLT_THANHTOAN_CK'];
$arrDoan[$idklt_doan]['KLT_THANHTOAN_CK'] = 0;
}
}
//
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_THE']>0 && $rw['KLT_THANHTOAN_NO']>0){
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_THE'] >=$rw['KLT_THANHTOAN_NO']){
$rw['KLT_THANHTOAN_THE'] += $rw['KLT_THANHTOAN_NO'];
$arrDoan[$idklt_doan]['KLT_THANHTOAN_THE'] -= $rw['KLT_THANHTOAN_NO'];
$rw['KLT_THANHTOAN_NO'] = 0;
}else{
$rw['KLT_THANHTOAN_THE'] += $arrDoan[$idklt_doan]['KLT_THANHTOAN_THE'];
$rw['KLT_THANHTOAN_NO'] -= $arrDoan[$idklt_doan]['KLT_THANHTOAN_THE'];
$arrDoan[$idklt_doan]['KLT_THANHTOAN_THE'] = 0;
}
}
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_NO']>0 && $rw['KLT_THANHTOAN_NO']>0){
if($arrDoan[$idklt_doan]['KLT_THANHTOAN_NO'] >=$rw['KLT_THANHTOAN_NO']){
$arrDoan[$idklt_doan]['KLT_THANHTOAN_NO'] -= $rw['KLT_THANHTOAN_NO'];
}else{
$arrDoan[$idklt_doan]['KLT_THANHTOAN_NO'] = 0;
}
}
}
$sum_no += $rw['KLT_THANHTOAN_NO'];
}else{
if($rw['PHONGKHAC_DATHANHTOAN']!=1){
$sum_no += $rw['KLT_THANHTOAN_NO'];
}
}
$sum_tm +=$rw['KLT_THANHTOAN_TM'] + $rw['TRATRUOC_TRONGNGAY'];
$sum_ck += $rw['KLT_THANHTOAN_CK'];
$sum_the += $rw['KLT_THANHTOAN_THE'];
$sum_tratruoc += $rw['TONG_TRATRUOC'];
$sum_tm2 += $rw['KLT_THANHTOAN2_TM'];
$sum_ck2 += $rw['KLT_THANHTOAN2_CK'];
$sum_the2 += $rw['KLT_THANHTOAN2_HTTHE'];
$sum_tienphong += $rw['KLT_TIENPHONG'];
$sum_dichvu += $rw['TONGDICHVU'] + $rw['KLT_THUKHAC'] + $rw['KLT_TONGTIENPHONGKHAC'] ;
$sum_trukhac += $rw['KLT_TRUKHAC'];
$tong_dong = $rw['KLT_TONGTHANHTOAN'];//$rw['KLT_TIENPHONG'] + $rw['KLT_TONGTIENPHONGKHAC'] + $rw['TONGDICHVU'] + $rw['KLT_THUKHAC'] - $rw['KLT_TRUKHAC'];
$sum_tongdong += $tong_dong;
?>
|
".$webhelper->decodeSpecialChar($rw['PH_TEN'])." (".$rw['KLT_SOHD'].")".$webhelper->decodeSpecialChar($rw['KH_TEN'])." ";?> |
|
|
format_vn_number($rw['KLT_TIENPHONG'],0);?> |
format_vn_number($rw['TONGDICHVU'] + $rw['KLT_THUKHAC'] + $rw['KLT_TONGTIENPHONGKHAC'],0);?> |
format_vn_number($rw['KLT_TRUKHAC'],0);?> |
format_vn_number($rw['TONG_TRATRUOC'],0);?> |
format_vn_number($tong_dong,0);?> |
format_vn_number($rw['TRATRUOC_TRONGNGAY'],0);}else{ echo $webhelper->format_vn_number($rw['KLT_THANHTOAN_TM'],0);};?> |
format_vn_number($rw['KLT_THANHTOAN_CK'],0);?> |
format_vn_number($rw['KLT_THANHTOAN_THE'],0);?> |
0 && $rw['KLT_IDKLT_DOAN']==null){echo "".$webhelper->format_vn_number($rw['KLT_THANHTOAN_NO'],0).""; }else{ echo $webhelper->format_vn_number($rw['KLT_THANHTOAN_NO'],0);} ; ?> |
|
format_vn_number($rw['KLT_THANHTOAN2_TM'],0);?> |
format_vn_number($rw['KLT_THANHTOAN2_CK'],0);?> |
format_vn_number($rw['KLT_THANHTOAN2_HTTHE'],0);?> |
100){ echo $webhelper->format_vn_number($rw['KLT_KHUYENMAI'],0); }elseif($rw['KLT_KHUYENMAI']>0){ echo $rw['KLT_KHUYENMAI'].$rw['KLT_DVTKHUYENMAI'];};?> |
Trả trước";
}
if($rw['TENPHONG_THANHTOAN']!=null){
$note_pay = "";
// if($rw['PHONGKHAC_DATHANHTOAN']==1){
// $note_pay = ", đã thanh toán";
// }
echo " Chuyển vào P.".$rw['TENPHONG_THANHTOAN'].$note_pay." ";
}
//echo $ghichu_tratruoc;
echo $webhelper->decodeSpecialChar($rw['KLT_GHICHU']);
?> |
| Tổng cộng |
format_vn_number($sum_tienphong,0);?> |
format_vn_number($sum_dichvu,0);?> |
format_vn_number($sum_trukhac,0);?> |
format_vn_number($sum_tratruoc,0);?> |
format_vn_number($sum_tongdong);?> |
format_vn_number($sum_tm);?> |
format_vn_number($sum_ck,0);?> |
format_vn_number($sum_the,0);?> |
format_vn_number($sum_no,0);?> |
format_vn_number($sum_foc,0);?> |
format_vn_number($sum_tm2,0);?> |
format_vn_number($sum_ck2,0);?> |
format_vn_number($sum_the2,0);?> |
|
|
$rw){
if($rw['KLT_THANHTOAN_TM'] + $rw['KLT_THANHTOAN_CK'] + $rw['KLT_THANHTOAN_THE'] + $rw['KLT_THANHTOAN_NO'] + $rw['KLT_THANHTOAN2_TM'] + $rw['KLT_THANHTOAN2_CK'] + $rw['KLT_THANHTOAN2_HTTHE'] == 0){
unset($arrDoan[$idklt_doan]);
}
}
if(!empty($arrDoan)){ ?>
| Danh sách đoàn |
| # |
Tên đoàn |
Vào |
Ra |
Tiền phòng |
Dịch vụ |
Trừ khác |
Trả trước |
Tổng cộng |
Thanh toán |
Trả nợ |
Giảm giá |
Ghi chú |
| TM |
CK |
Thẻ |
Nợ |
FOC |
TM |
CK |
Thẻ |
$rw){
//$rw = $arrDoan[$j];
$count++;
$sum_tm +=$rw['KLT_THANHTOAN_TM'] + $rw['TRATRUOC_TRONGNGAY'];
$sum_ck += $rw['KLT_THANHTOAN_CK'];
$sum_the += $rw['KLT_THANHTOAN_THE'];
$sum_no += $rw['KLT_THANHTOAN_NO'];
$sum_tm2 += $rw['KLT_THANHTOAN2_TM'];
$sum_ck2 += $rw['KLT_THANHTOAN2_CK'];
$sum_the2 += $rw['KLT_THANHTOAN2_HTTHE'];
$sum_tienphong += $rw['KLT_TIENPHONG'];
$sum_dichvu += $rw['TONGDICHVU'] + $rw['KLT_THUKHAC'];
$sum_trukhac += $rw['KLT_TRUKHAC'];
$sum_tratruoc += $rw['TONG_TRATRUOC'];
$tong_dong = $rw['KLT_TIENPHONG'] + $rw['TONGDICHVU'] + $rw['KLT_THUKHAC'] - $rw['KLT_TRUKHAC'];
$sum_tongdong += $tong_dong;
?>
|
".$webhelper->decodeSpecialChar($rw['PH_TEN'])." (".$rw['KLT_SOHD'].")".$webhelper->decodeSpecialChar($rw['KH_TEN'])." ";?> |
|
|
format_vn_number($rw['KLT_TIENPHONG'],0);?> |
format_vn_number($rw['TONGDICHVU'],0);?> |
format_vn_number($rw['KLT_TRUKHAC'],0);?> |
format_vn_number($rw['TONG_TRATRUOC'],0);?> |
format_vn_number($tong_dong,0);?> |
format_vn_number($rw['TRATRUOC_TRONGNGAY'],0);}else{ echo $webhelper->format_vn_number($rw['KLT_THANHTOAN_TM'],0);};?> |
format_vn_number($rw['KLT_THANHTOAN_CK'],0);?> |
format_vn_number($rw['KLT_THANHTOAN_THE'],0);?> |
format_vn_number($rw['KLT_THANHTOAN_NO'],0);?> |
|
format_vn_number($rw['KLT_THANHTOAN2_TM'],0);?> |
format_vn_number($rw['KLT_THANHTOAN2_CK'],0);?> |
format_vn_number($rw['KLT_THANHTOAN2_HTTHE'],0);?> |
100){ echo $webhelper->format_vn_number($rw['KLT_KHUYENMAI'],0); }elseif($rw['KLT_KHUYENMAI']>0){ echo $rw['KLT_KHUYENMAI'].$rw['KLT_DVTKHUYENMAI'];};?> |
Trả trước";
}
if($rw['TENPHONG_THANHTOAN']!=null){
$note_pay = "";
if($rw['PHONGKHAC_DATHANHTOAN']==1){
$note_pay = ", đã thanh toán";
}
echo " Chuyển vào P.".$rw['TENPHONG_THANHTOAN'].$note_pay." ";
}
//echo $ghichu_tratruoc;
echo $webhelper->decodeSpecialChar($rw['KLT_GHICHU']);
?> |
| Tổng cộng |
format_vn_number($sum_tienphong,0);?> |
format_vn_number($sum_dichvu,0);?> |
format_vn_number($sum_trukhac,0);?> |
format_vn_number($sum_tratruoc,0);?> |
format_vn_number($sum_tongdong);?> |
format_vn_number($sum_tm);?> |
format_vn_number($sum_ck,0);?> |
format_vn_number($sum_the,0);?> |
format_vn_number($sum_no,0);?> |
format_vn_number($sum_foc,0);?> |
format_vn_number($sum_tm2,0);?> |
format_vn_number($sum_ck2,0);?> |
format_vn_number($sum_the2,0);?> |
|
|
