|
|
Chọn thời điểm: Từ
buildHourSelect('Search_ThuChi_TuGio',$search_tugio_1,'cbo width_50',$disable_from).":";
echo $htmlHelper->buildMinuteSelectFull('Search_ThuChi_TuPhut',$search_tuphut_1,'cbo width_50',$disable_from)." ";
echo $htmlHelper->buildInput('Search_ThuChi_TuNgay',$search_tungay,'textbox width_100 datepicker','maxlength=\'10\' '.$disable_from);
echo " đến ";
echo $htmlHelper->buildHourSelect('Search_ThuChi_DenGio',$search_dengio_1,'cbo width_50').":";
echo $htmlHelper->buildMinuteSelectFull('Search_ThuChi_DenPhut',$search_denphut_1,'cbo width_50')." ";
echo $htmlHelper->buildInput('Search_ThuChi_DenNgay',$search_denngay,'textbox width_100 datepicker','maxlength=\'10\'');
?>
|
| STT |
Mã giao dịch |
Ngày |
Nội dung |
Nhân viên |
Tiền D.vụ |
Số tiền |
Tiền mặt |
Chuyển khoản |
Thẻ |
Bộ phận |
$branch_type_i){
$datasearch['CNH_ID'] = $chinhanh_id_i;
if($branch_type_i==TYPE_IS_MASSAGE){
$datasearch['VETHANG'] = 0;
$rs_thu = $mThu->getDataBangKeTongHopThu($datasearch);
$tongtien_thu = $mThu->getTongTienBangKeTongHopThu($datasearch);
$datasearch['VETHANG'] = 1;
$rs_thuvethang = $mThu->getDataBangKeTongHopThu($datasearch);
$tongtien_thuvethang = $mThu->getTongTienBangKeTongHopThu($datasearch);
if($conn->numRows($rs_thu) > 0) {
$stt = 0;
$idcnh = '';
$tittle_thu = 0;
while ($rw = $conn->fetchRow($rs_thu)) {
$stt++;
if($tittle_thu == 0){
?>
| Bán |
|
|
0 |
|
|
|
|
|
>
|
>decodeSpecialChar($rw['TICKET_TICKETCODE']); ?> |
|
Thu: //decodeSpecialChar($rw['DV_TEN']);
if($rw['TICKET_KHUYENMAI']>0){
if($rw['TICKET_KHUYENMAI']<=100){
echo " Giảm giá: ".WebHelper::format_vn_number($rw['TICKET_KHUYENMAI'])."% ";
}else{
echo "Giảm giá: ".WebHelper::format_vn_number($rw['TICKET_KHUYENMAI'])." ";
}
}
if($rw['TICKET_MAGIAMGIA']!=""){
echo "[CODE: ".$rw['TICKET_MAGIAMGIA']." - SĐT: ".$rw['TICKET_SDTGIAMGIA']."] ";
}
if($rw['TICKET_HUY']==1){
echo "Hủy lúc: ".$rw['TICKET_THOIDIEMHUY'].", Lý do: ".WebHelper::decodeSpecialChar($rw['TICKET_LYDOHUY'])." ";
}
?>
|
decodeSpecialChar($rw['NV_HOTEN']); ?> |
> |
>format_vn_number($rw['TICKET_TM']+$rw['TICKET_THE']+$rw['TICKET_CK'], 0); ?> |
>format_vn_number($rw['TICKET_TM'], 0); ?> |
>format_vn_number($rw['TICKET_CK'], 0); ?> |
>format_vn_number($rw['TICKET_THE'], 0); ?> |
>decodeSpecialChar($arrTenCNH[$rw['TICKET_IDCNH']]); ?> |
numRows($rs_thuvethang) > 0) {
$stt = 0;
$idcnh = '';
$tittle_thu = 0;
while ($rw = $conn->fetchRow($rs_thuvethang)) {
$stt++;
if($tittle_thu == 0){
?>
| Bán vé tháng |
|
|
0 |
|
|
|
|
|
>
|
>decodeSpecialChar($rw['TICKET_TICKETCODE']); ?> |
|
Thu: //decodeSpecialChar($rw['DV_TEN']);
if($rw['TICKET_SDTMUA']!=""){
echo " [SĐT Khách: ".$rw['TICKET_SDTMUA']."] ";
}
if($rw['TICKET_KHUYENMAI']>0){
if($rw['TICKET_KHUYENMAI']<=100){
echo " Giảm giá: ".WebHelper::format_vn_number($rw['TICKET_KHUYENMAI'])."% ";
}else{
echo "Giảm giá: ".WebHelper::format_vn_number($rw['TICKET_KHUYENMAI'])." ";
}
}
if($rw['TICKET_MAGIAMGIA']!=""){
echo "[CODE: ".$rw['TICKET_MAGIAMGIA']." - SĐT: ".$rw['TICKET_SDTGIAMGIA']."] ";
}
if($rw['TICKET_HUY']==1){
echo "Hủy lúc: ".$rw['TICKET_THOIDIEMHUY'].", Lý do: ".WebHelper::decodeSpecialChar($rw['TICKET_LYDOHUY'])." ";
}
?>
|
decodeSpecialChar($rw['NV_HOTEN']); ?> |
> |
>format_vn_number($rw['TICKET_TM']+$rw['TICKET_THE']+$rw['TICKET_CK'], 0); ?> |
>format_vn_number($rw['TICKET_TM'], 0); ?> |
>format_vn_number($rw['TICKET_CK'], 0); ?> |
>format_vn_number($rw['TICKET_THE'], 0); ?> |
>decodeSpecialChar($arrTenCNH[$rw['TICKET_IDCNH']]); ?> |
getDataBangKeTongHopThu($datasearch);
$tongtien_thu = $mThu->getTongTienBangKeTongHopThu($datasearch);
if($conn->numRows($rs_thu) > 0) {
$stt = 0;
$idcnh = '';
$tittle_thu = 0;
while ($rw = $conn->fetchRow($rs_thu)) {
$stt++;
if($tittle_thu == 0){
?>
| Bán |
|
|
0 |
|
|
|
|
|
>
|
>decodeSpecialChar($rw['TICKET_TICKETCODE']); ?> |
|
Thu: //decodeSpecialChar($rw['DV_TEN']);
if($rw['TICKET_KHUYENMAI']>0){
if($rw['TICKET_KHUYENMAI']<=100){
echo " Giảm giá: ".WebHelper::format_vn_number($rw['TICKET_KHUYENMAI'])."% ";
}else{
echo "Giảm giá: ".WebHelper::format_vn_number($rw['TICKET_KHUYENMAI'])." ";
}
}
if($rw['TICKET_MAGIAMGIA']!=""){
echo "[CODE: ".$rw['TICKET_MAGIAMGIA']." - SĐT: ".$rw['TICKET_SDTGIAMGIA']."] ";
}
if($rw['TICKET_HUY']==1){
echo "Hủy lúc: ".$rw['TICKET_THOIDIEMHUY'].", Lý do: ".WebHelper::decodeSpecialChar($rw['TICKET_LYDOHUY'])." ";
}
?>
|
decodeSpecialChar($rw['NV_HOTEN']); ?> |
> |
>format_vn_number($rw['TICKET_TM']+$rw['TICKET_THE']+$rw['TICKET_CK'], 0); ?> |
>format_vn_number($rw['TICKET_TM'], 0); ?> |
>format_vn_number($rw['TICKET_CK'], 0); ?> |
>format_vn_number($rw['TICKET_THE'], 0); ?> |
>decodeSpecialChar($arrTenCNH[$rw['TICKET_IDCNH']]); ?> |
getBCThuCheckout($datasearch);
$has_row = false;
$sum_tm = 0;
$sum_the = 0;
$sum_ck = 0;
if($conn->numRows($rs_thu_checkout) > 0) {
$stt = 0;
$idcnh = '';
$tittle_thu = 0;
$has_row = true;
?>
|
- Thanh toán khi trả bàn |
fetchRow($rs_thu_checkout)) {
$stt++;
if($rw['KLT_HUYDATPHONG']==0){
$sum_tm += $rw['TIENMAT'];
$sum_the += $rw['QUATHE'];
$sum_ck += $rw['CHUYENKHOAN'];
}
$tiendichvu = 0;
if($rw['TIENDICHVU']>0){
$tiendichvu = $rw['TIENDICHVU'];
}
$tongthu_dichvu += $tiendichvu;
?>
>
|
decodeSpecialChar($rw['KLT_SOHD']).")"; ?> |
|
Thu: //decodeSpecialChar($rw['KH_TEN']);
echo ", Vào lúc: ".$rw['THOIDIEM_VAO']."";
$arr_note = array();
if($rw['KLT_KHUYENMAI']>0){
if($rw['KLT_KHUYENMAI']>100){
$arr_note[]= "Giảm giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."/đêm";
}else{
$arr_note[]= "Giảm giá: ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."%";
}
}
if($rw['KLT_THUKHAC']>0){
$arr_note[]= "Thu khoản khác: ".WebHelper::format_vn_number($rw['KLT_THUKHAC'])."";
}
if($rw['KLT_TRUKHAC']>0){
$arr_note[]= "Giảm trừ khác: ".WebHelper::format_vn_number($rw['KLT_TRUKHAC'])."";
}
if($rw['TRATRUOC']>0){
$arr_note[]= " Đã thu trước: ".WebHelper::format_vn_number($rw['TRATRUOC'])." ";
}
if($rw['THANHTOAN_NO']>0){
$arr_note[]= "Nợ: ".WebHelper::format_vn_number($rw['THANHTOAN_NO'])."";
}
if($rw['KLT_SOHD_THANHTOAN'] != ''){
$arr_note[]= "chuyển vào HĐ ".$rw['KLT_SOHD_THANHTOAN']." (P.".$rw['PH_TEN_THANHTOAN'].") ";
}
if(!empty($arr_note)){
echo "".implode(", ", $arr_note)." ";
}
?>
|
decodeSpecialChar($rw['NV_HOTEN']); ?> |
format_vn_number($tiendichvu, 0); ?> |
format_vn_number($rw['TIENMAT']+$rw['CHUYENKHOAN']+$rw['QUATHE'], 0); ?> |
format_vn_number($rw['TIENMAT'], 0); ?> |
format_vn_number($rw['CHUYENKHOAN'], 0); ?> |
format_vn_number($rw['QUATHE'], 0); ?> |
|
|
|
|
|
|
|
|
|
getBCThuTraTruoc($datasearch);
$rs_thu_checkout=$mBaoCao->getBCThuCheckout($datasearch);
$rs_thu_no=$mBaoCao->getBCThuNo($datasearch);
$has_row = false;
$sum_tm = 0;
$sum_the = 0;
$sum_ck = 0;
if($conn->numRows($rs_thu_tratruoc) > 0) {
$stt = 0;
$idcnh = '';
$tittle_thu = 0;
$has_row = true;
?>
|
- Thu cọc |
fetchRow($rs_thu_tratruoc)) {
$stt++;
$sum_tm += $rw['TIENMAT'];
$sum_the += $rw['QUATHE'];
$sum_ck += $rw['CHUYENKHOAN'];
?>
|
decodeSpecialChar($rw['KLT_SOHD']).")"; ?> |
|
Thu cọc: //decodeSpecialChar($rw['KH_TEN']);
?>
|
decodeSpecialChar($rw['NV_HOTEN']); ?> |
|
format_vn_number($rw['TIENMAT']+$rw['CHUYENKHOAN']+$rw['QUATHE'], 0); ?> |
format_vn_number($rw['TIENMAT'], 0); ?> |
format_vn_number($rw['CHUYENKHOAN'], 0); ?> |
format_vn_number($rw['QUATHE'], 0); ?> |
|
numRows($rs_thu_checkout) > 0) {
$stt = 0;
$idcnh = '';
$tittle_thu = 0;
$has_row = true;
?>
|
- Thanh toán khi trả phòng |
fetchRow($rs_thu_checkout)) {
$stt++;
if($rw['KLT_HUYDATPHONG']==0){
$sum_tm += $rw['TIENMAT'];
$sum_the += $rw['QUATHE'];
$sum_ck += $rw['CHUYENKHOAN'];
$tongthu_dichvu += $rw['TIENDICHVU'];
}
$tiendichvu = 0;
if($rw['TIENDICHVU']>0){
$tiendichvu = $rw['TIENDICHVU'];
}
?>
>
|
decodeSpecialChar($rw['KLT_SOHD']).")"; ?> |
|
Thu: //decodeSpecialChar($rw['KH_TEN']);
echo ", Vào lúc: ".$rw['THOIDIEM_VAO']."";
$arr_note = array();
if($rw['KLT_KHUYENMAI']>0){
if($rw['KLT_KHUYENMAI']>100){
$arr_note[]= "Giảm giá ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."/đêm";
}else{
$arr_note[]= "Giảm giá: ".WebHelper::format_vn_number($rw['KLT_KHUYENMAI'])."%";
}
}
if($rw['KLT_THUKHAC']>0){
$arr_note[]= "Thu khoản khác: ".WebHelper::format_vn_number($rw['KLT_THUKHAC'])."";
}
if($rw['KLT_TRUKHAC']>0){
$arr_note[]= "Giảm trừ khác: ".WebHelper::format_vn_number($rw['KLT_TRUKHAC'])."";
}
if($rw['TRATRUOC']>0){
$arr_note[]= " Đã thu trước: ".WebHelper::format_vn_number($rw['TRATRUOC'])." ";
}
if($rw['THANHTOAN_NO']>0){
$arr_note[]= "Nợ: ".WebHelper::format_vn_number($rw['THANHTOAN_NO'])."";
}
if($rw['KLT_SOHD_THANHTOAN'] != ''){
$arr_note[]= "chuyển vào HĐ ".$rw['KLT_SOHD_THANHTOAN']." (P.".$rw['PH_TEN_THANHTOAN'].") ";
}
if(!empty($arr_note)){
echo "".implode(", ", $arr_note)." ";
}
?>
|
decodeSpecialChar($rw['NV_HOTEN']); ?> |
format_vn_number($tiendichvu, 0); ?> |
format_vn_number($rw['TIENMAT']+$rw['CHUYENKHOAN']+$rw['QUATHE'], 0); ?> |
format_vn_number($rw['TIENMAT'], 0); ?> |
format_vn_number($rw['CHUYENKHOAN'], 0); ?> |
format_vn_number($rw['QUATHE'], 0); ?> |
|
numRows($rs_thu_no) > 0) {
$stt = 0;
$idcnh = '';
$tittle_thu = 0;
$has_row = true;
?>
|
- Thanh toán nợ |
fetchRow($rs_thu_no)) {
$sum_tm += $rw['TIENMAT'];
$sum_the += $rw['QUATHE'];
$sum_ck += $rw['CHUYENKHOAN'];
$stt++;
?>
|
decodeSpecialChar($rw['KLT_SOHD']).")"; ?> |
|
Thu nợ: //decodeSpecialChar($rw['KH_TEN']);
?>
|
decodeSpecialChar($rw['NV_HOTEN']); ?> |
|
format_vn_number($rw['TIENMAT']+$rw['CHUYENKHOAN']+$rw['QUATHE'], 0); ?> |
format_vn_number($rw['TIENMAT'], 0); ?> |
format_vn_number($rw['CHUYENKHOAN'], 0); ?> |
format_vn_number($rw['QUATHE'], 0); ?> |
|
|
|
|
|
|
|
|
|
numRows($rs_thubanle) > 0) {
$idcnh = '';
$tittle_thubanle = 0;
$sum_banle = 0;
while ($rw = $conn->fetchRow($rs_thubanle)) {
$stt++;
$tongthu +=$rw['SOTIEN'];
$tongthu_tm +=$rw['SOTIEN'];
$sum_banle += $rw['SOTIEN'];
if ($tittle_thubanle == 0) {
?>
| Thu bán lẻ nước |
|
Bán lẻ |
decodeSpecialChar($rw['NGAYBAN']); ?> |
decodeSpecialChar($rw['DV_TEN']);
if($rw['DVSD_NHANVIEN']==1){
echo " - Nhân viên";
}elseif($rw['DVSD_NHANVIEN'] == 2){
echo " - Chủ";
}else{
echo " - Khách";
}
?> |
decodeSpecialChar($rw['NV_HOTEN']); ?> |
|
format_vn_number($rw['SOTIEN'], 0); ?> |
format_vn_number($rw['SOTIEN'], 0); ?> |
0 |
0 |
|
| CỘNG |
|
format_vn_number($sum_banle, 0); ?> |
format_vn_number($sum_banle, 0); ?> |
0 |
0 |
|
numRows($rs_thukhac) > 0) {
$idcnh = '';
$tittle_thukhac = 0;
while ($rw = $conn->fetchRow($rs_thukhac)) {
$stt++;
if ($tittle_thukhac == 0) {
?>
| Thu khác |
|
|
|
|
|
|
|
|
|
|
decodeSpecialChar($rw['THU_NGAY']); ?> |
decodeSpecialChar($rw['THU_NOIDUNG']); ?> |
decodeSpecialChar($rw['NV_HOTEN']); ?> |
|
format_vn_number($rw['THU_SOTIEN'], 0); ?> |
format_vn_number($rw['THU_SOTIEN_TM'], 0); ?> |
format_vn_number($rw['THU_SOTIEN_CK'], 0); ?> |
format_vn_number($rw['THU_SOTIEN_THE'], 0); ?> |
|
numRows($rs_chi) > 0) {
$idcnh = '';
$tittle_chi = 0;
while ($rw = $conn->fetchRow($rs_chi)) {
$stt++;
if ($tittle_chi == 0) {
?>
| Chi |
|
|
|
|
|
|
|
|
|
decodeSpecialChar($rw['LCP_TEN']); ?> |
|
decodeSpecialChar($rw['CP_NOIDUNG']);
if($rw['DVLK_TEN']!=NULL){ echo " ".$webhelper->decodeSpecialChar($rw['DVLK_TEN'])." ";}
?> |
decodeSpecialChar($rw['NV_HOTEN']); ?> |
|
format_vn_number($rw['CP_SOTIEN'], 0); ?> |
format_vn_number($rw['CP_SOTIEN_TM'], 0); ?> |
format_vn_number($rw['CP_SOTIEN_CK'], 0); ?> |
format_vn_number($rw['CP_SOTIEN_THE'], 0); ?> |
|