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_thukhac = 0; $sum_trukhac = 0; $sum_tongdong = 0; $sum_tiennuoc = 0; $sum_tiengiatui = 0; $sum_thuquay = 0; foreach($arrBillPhong as $i=>$rw){ $count++; if($rw['PHONGKHAC_DATHANHTOAN']!=1){ $sum_no += $rw['KLT_THANHTOAN_NO']; } $sum_tm +=$rw['KLT_THANHTOAN_TM'] + $rw['TRATRUOC_TM']; if($cty_id==31){ $sum_tm -= $rw['TIENQUAY']; } $sum_ck += $rw['KLT_THANHTOAN_CK'] + $rw['TRATRUOC_CK']; $sum_the += $rw['KLT_THANHTOAN_THE']+ $rw['TRATRUOC_THE']; $sum_tm2 += $rw['KLT_THANHTOAN2_TM']; $sum_ck2 += $rw['KLT_THANHTOAN2_CK']; $sum_the2 += $rw['KLT_THANHTOAN2_HTTHE']; if($cty_id==31){ $tienphong = $rw['KLT_TIENPHONG']-$rw['KLT_TRUKHAC']+$rw['KLT_THUKHAC']; }elseif($rw['BC_TRATRUOC']!=1){ $tienphong = $rw['KLT_TIENPHONG']; } $sum_tienphong += $tienphong; $tiennuoc = $rw['TONGDICHVU']-$rw['TIENQUAY']-$rw['THU_GIATUI']; $sum_tiennuoc += $tiennuoc; $tiengiatui = $rw['THU_GIATUI']; $sum_tiengiatui += $tiengiatui; $thuquay = $rw['TIENQUAY']; $sum_thuquay += $thuquay; $thukhac = $rw['KLT_THUKHAC'] + $rw['KLT_TONGTIENPHONGKHAC'] ; $sum_thukhac += $rw['KLT_THUKHAC'] + $rw['KLT_TONGTIENPHONGKHAC'] ; $trukhac = $rw['KLT_TRUKHAC']; $sum_trukhac += $rw['KLT_TRUKHAC']; if($cty_id==31){ $tong_dong = $rw['KLT_TONGTHANHTOAN']-$thuquay;//$rw['KLT_TIENPHONG'] + $rw['KLT_TONGTIENPHONGKHAC'] + $rw['TONGDICHVU'] + $rw['KLT_THUKHAC'] - $rw['KLT_TRUKHAC']; }else{ $tong_dong = $rw['KLT_TONGTHANHTOAN']; } $sum_tongdong += $tong_dong; ?>
        
# Phòng Khách hàng Vào Ra Tiền phòng Tiền nước Giặt ủi Thu quầy Thu khác Trừ khác Tổng Thanh toán Ghi chú
TM CK Thẻ Nợ
decodeSpecialChar($rw['PH_TEN'])."(".$rw['KLT_SOHD'].")";?> decodeSpecialChar($rw['KH_TEN']);?> format_vn_number($tienphong,0); } ?> format_vn_number($tiennuoc,0);}; ?> format_vn_number($tiengiatui,0);?> format_vn_number($thuquay,0);?> format_vn_number($thukhac,0);?> format_vn_number($trukhac,0);?> format_vn_number($tong_dong,0);?> format_vn_number($rw['TRATRUOC_TM']+$rw['KLT_THANHTOAN_TM']-$rw['TIENQUAY'],0);?> format_vn_number($rw['TRATRUOC_CK'] + $rw['KLT_THANHTOAN_CK'],0);?> format_vn_number($rw['TRATRUOC_THE'] + $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);} ; ?>
Tổng cộng format_vn_number($sum_tienphong,0);?> format_vn_number($sum_tiennuoc,0);?> format_vn_number($sum_tiengiatui,0);?> format_vn_number($sum_thuquay,0);?> format_vn_number($sum_thukhac,0);?> format_vn_number($sum_trukhac,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);?>