|
|
|
| # |
STT |
Phòng |
Vào |
Ra |
Ngày |
Đ.Giá |
Phụ thu |
Giặt ủi |
Nước |
Thu khác |
Trừ khác |
Giảm giá |
Phải thu |
Tổng
Trả trước |
Trả trước
trong ngày |
Thu |
Khách hàng |
| TM |
CK |
Thẻ |
Nợ |
fetchRow($rs)){
$count++;
$phuthu = 0;
$baotratre = $rw['KLT_BAOTRATRE'];
$slkhach = $rw['KLT_SLKHACH'];
$klt_ext_info = $mKLT->get_ext_info($rw);
if($rw['KLT_THOIDIEMTRAPHONG']!=NULL){
$time_out_full = $rw['KLT_THOIDIEMTRAPHONG'];
if(strtotime($rw['KLT_THOIDIEMTRAPHONG'])>strtotime($search_ngay_db." ".$thoidiembaocao.":00")){
$t_out = $search_ngay_db." ".$thoidiembaocao.":00";
}else{
$t_out = $time_out_full;
}
$arrfromjson = json_decode($rw['KLT_PRICE_INFO'],true);
$arr_price_add_1 = $arrfromjson['ARR_PRICE_ADD'];
$arr_ts_1 = $arrfromjson['ARR_TS'];
$arr_price_early_1 = $arrfromjson['ARR_PRICE_EARLY'];
$arr_giatheonguoi_1 = $arrfromjson['ARR_ADD_PERSON'];
$cachtinhphuthuthemnguoi_1 = $arrfromjson['ARR_OTHER']['cachtinh_pttn'];
unset($arrfromjson['ARR_TS']);
unset($arrfromjson['ARR_PRICE_ADD']);
unset($arrfromjson['ARR_PRICE_EARLY']);
unset($arrfromjson['ARR_ADD_PERSON']);
unset($arrfromjson['ARR_OTHER']);
$arr_price_1 = $arrfromjson;
$data = $mKLT->calcBalance($arr_ts_1, $arr_price_1,$arr_price_early_1, $arr_price_add_1, $rw['KLT_THOIDIEMNHANPHONG'],$t_out,$arr_giatheonguoi_1,$slkhach,$cachtinhphuthuthemnguoi,$rw['KLT_UUTIENGIO'],$baotratre,$rw['KLT_TINHTUANTHANG'],$klt_ext_info);
}else{
$kltid = $rw['KLT_ID'];
$roomid = $rw['KLT_IDPH'];
$t_out = $search_ngay_db." ".$thoidiembaocao.":00";
$arr_price = $mPhong->getPriceToArray($rw['KLT_IDPH'],$rw['KLT_THOIDIEMNHANPHONG']);
if($rw['KLT_GIAPHONGAPDUNG']!==NULL){
$arr_price['GIANGAY'] = $rw['KLT_GIAPHONGAPDUNG'];
$arr_price['GIAQUADEM'] = $rw['KLT_GIAPHONGAPDUNG'];
}
//$arr_price_early = $mTinhVaoSom->getToArray($cty_id);
$arr_giatheonguoi = $mGiaTheoNguoi->getGiaTheoNguoi($roomid);
//Lay thong tin gia phong
$arr_ts = $mTS->getThongTinTinhTienPhong($cty_id);
//$arr_price_add = $mTinhQuaGio->getToArray($cty_id);
//Vao som
$arr_price_early = $mKLT->getPhuThuVaoSom($kltid);
if(empty($arr_price_early)){
$arr_price_early = $mVaoSomPhong->getToArray($roomid);
}
if(empty($arr_price_early)){
$arr_price_early = $mTinhVaoSom->getToArray($cty_id);
}
//Tra tre
$arr_price_add = $mKLT->getPhuThuTraTre($kltid);
if(empty($arr_price_add)){
$arr_price_add = $mTraTrePhong->getToArray($roomid);
}
if(empty($arr_price_add)){
$arr_price_add = $mTinhQuaGio->getToArray($cty_id);
}
$data = $mKLT->calcBalance($arr_ts, $arr_price,$arr_price_early, $arr_price_add, $rw['KLT_THOIDIEMNHANPHONG'],$t_out,$arr_giatheonguoi,$slkhach,$cachtinhphuthuthemnguoi,$rw['KLT_UUTIENGIO'],$baotratre,$rw['KLT_TINHTUANTHANG'],$klt_ext_info);
}
$tienphong = 0;
$phuthu = 0;
$tien_khuyenmmai = 0;
$songay_tinhkhuyenmai = 0;
if($rw['KLT_UUTIENGIO']==1){
if($rw['KLT_THOIDIEMTRAPHONG']!=NULL){
$t = strtotime($rw['KLT_THOIDIEMTRAPHONG']) - strtotime($rw['KLT_THOIDIEMNHANPHONG']);
}else{
$t = strtotime($_out) - strtotime($rw['KLT_THOIDIEMNHANPHONG']);
}
$songay = intval($t/3600);
if(intval(($t%3600)/60)>=$lamtrongio){
$songay++;
}
if($songay==0){
$songay++;
}
$songay .="h";
$tienphong = $data['first']['amount'];
if(isset($data['last'])){
$tienphong += $data['last']['amount'];
}
}else{
//*Tinh lai tien phong, phu thu, so ngay*/
$songay = 0;
if($data['first']['day']>0){
$songay+= $data['first']['day'];
$songay_tinhkhuyenmai += $data['first']['day'];
$tienphong += $data['first']['amount'];
}else{
$phuthu += $data['first']['amount'];
}
if(isset($data['middle'])){
if($data['middle']['day']>0){
$songay+= $data['middle']['day'];
$songay_tinhkhuyenmai += $data['middle']['day'];
$tienphong += $data['middle']['amount'];
}else{
$phuthu += $data['middle']['amount'];
}
}
if(isset($data['last'])){
if($data['last']['day']>0){
$songay+= $data['last']['day'];
$songay_tinhkhuyenmai += $data['last']['day'];
$tienphong += $data['last']['amount'];
}else{
$phuthu += $data['last']['amount'];
}
}
//Phu thu them nguoi
if($data['ptnguoi']['songuoi']>0 && $data['ptnguoi']['sodem']>0 && $data['ptnguoi']['dongia_nguoi_dem']>0){
$phuthu += $data['ptnguoi']['songuoi']*$data['ptnguoi']['sodem']*$data['ptnguoi']['dongia_nguoi_dem'];
}
if($data['ptnguoi']['songuoi']>0 && $data['ptnguoi']['songay']>0 && $data['ptnguoi']['dongia_nguoi_ngay']>0){
$phuthu += $data['ptnguoi']['songuoi']*$data['ptnguoi']['songay']*$data['ptnguoi']['dongia_nguoi_ngay'];
}
/*End Tinh lai tien phong, phu thu, so ngay */
}
//Tinh khuyen mai
if($rw['KLT_KHUYENMAI']>100){
$tien_khuyenmai = $rw['KLT_KHUYENMAI']*$songay_tinhkhuyenmai;
}else{
$tien_khuyenmai = ($rw['KLT_KHUYENMAI']/100)*$tienphong;
}
$tong_tien = $tienphong + $phuthu + $rw['THU_GIATUI'] + $rw['THU_TUNHAN'] + $rw['THU_QUAY'];
$tong_tien += $rw['THU_DICHVUKS'] + $rw['KLT_THUKHAC'] - $rw['KLT_TRUKHAC'] - $tien_khuyenmai;
$thukhac = $rw['THU_QUAY'] + $rw['THU_DICHVUKS'] + $rw['KLT_THUKHAC'];
$sum_phuthu += $phuthu;
$sum_giatui += $rw['THU_GIATUI'];
$sum_nuoc += $rw['THU_TUNHAN'];
$sum_thukhac += $thukhac;
$sum_trukhac += $rw['KLT_THUKHAC'];
$sum_tienkhuyenmai += $tien_khuyenmai;
$sum_phaithu += $tong_tien;
$sum_datratruoc += $rw['TRATRUOC'];
$sum_tratruoctrongngay += $rw['TRATRUOC_TRONGNGAY'];
$sum_tm += $rw['KLT_THANHTOAN_TM'];
$sum_ck += $rw['KLT_THANHTOAN_CK'];;
$sum_the += $rw['KLT_THANHTOAN_THE'];;
$sum_no += $rw['KLT_THANHTOAN_NO'];;
?>
|
|
decodeSpecialChar($rw['PH_TEN']);?> |
|
|
|
giaGio($rw['KLT_IDPH']));}else{ echo $webhelper->format_vn_number($rw['GIAPHONG_NGAY'],0);};?> |
format_vn_number($phuthu,0);?> |
format_vn_number($rw['THU_GIATUI'],0);?> |
format_vn_number($rw['THU_TUNHAN'],0);?> |
format_vn_number($rw['THU_DICHVUKS'],0);?> |
format_vn_number($thukhac,0);?> |
0){ echo $webhelper->format_vn_number($tien_khuyenmai,0);};?> |
format_vn_number($tong_tien,0);?> |
format_vn_number($rw['TRATRUOC'],0);?> |
format_vn_number($rw['TRATRUOC_TRONGNGAY'],0);?> |
|
|
|
|
decodeSpecialChar($rw['KH_TEN']);?> |
| |
Tổng cộng |
format_vn_number($sum_phuthu,0);?> |
format_vn_number($sum_giatui,0);?> |
format_vn_number($sum_nuoc,0);?> |
format_vn_number($sum_thukhac,0);?> |
format_vn_number($sum_trukhac,0);?> |
format_vn_number($sum_tienkhuyenmai,0);?> |
format_vn_number($sum_phaithu,0);?> |
format_vn_number($sum_datratruoc,0);?> |
format_vn_number($sum_tratruoctrongngay,0);?> |
format_vn_number($sum_tm,0);?> |
format_vn_number($sum_ck,0);?> |
format_vn_number($sum_the,0);?> |
format_vn_number($sum_no,0);?> |
|
|
Tổng doanh thu
format_vn_number($sum_phaithu,0);?>
Trong đó:
Thu tiền mặt + Trả trước trong ngày
format_vn_number($sum_tm + $sum_tratruoctrongngay,0);?>
0){ ?>
Thu tiền CK
format_vn_number($sum_ck,0);?>
0){ ?>
Thu tiền thẻ
format_vn_number($sum_the,0);?>
0){ ?>
Nợ lại
format_vn_number($sum_no,0);?>
0){ ?>
Tổng trả trước
format_vn_number($sum_datratruoc,0);?>
Dự kiến thu thêm
format_vn_number($sum_phaithu-$sum_datratruoc-$sum_tm-$sum_ck-$sum_the-$sum_no,0);?>
|