"; while($row = mysql_fetch_array($qq)){ $sjAmount=0; $pID =$row['journal_patient_id']; $refID =$row['ref_number']; if($mylastRef===$refID){ }else{ $cfname=mysql_result(mysql_query("SELECT `patient_fname` FROM `patient_list` WHERE `branch_code`='$compCode' AND `patient_id`='$pID'"),0); $clname=mysql_result(mysql_query("SELECT `patient_lname` FROM `patient_list` WHERE `branch_code`='$compCode' AND `patient_id`='$pID'"),0); //ORIGINAL CASH JOURNAL BEFORE PAYMENT //$sj=mysql_query("SELECT * FROM `sales_journal` WHERE `branch_code`='$compCode' AND `trans_id`='$refID' AND `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `trans_type`='CASH' AND `patient_id`='$pID' AND `cancel`!='yes' || `branch_code`='$compCode' AND `trans_id`='$refID' AND `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `trans_type`='Advance' AND `patient_id`='$pID' AND `cancel`!='yes'"); $sj=mysql_query("SELECT * FROM `sales_journal` WHERE `branch_code`='$compCode' AND `trans_id`='$refID' AND `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `trans_type`='CASH' AND `cancel`!='yes' || `branch_code`='$compCode' AND `trans_id`='$refID' AND `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `trans_type`='Advance' AND `cancel`!='yes'"); while($sjrow = mysql_fetch_array($sj)){ $sjAmount = $sjAmount + $sjrow['amount']; } $sjTotal =$sjTotal + $sjAmount; echo ""; if($sjAmount > 0){ //NOV 14.2017 echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $mylastRef=$row['ref_number']; } //NOV 14.2017 } } $dtl_qq=mysql_query("SELECT * FROM `sales_journal` WHERE `branch_code`='$compCode' AND `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `trans_type`='Advance' AND `cancel`!='yes'|| `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `branch_code`='$compCode' AND `trans_type`='CASH' AND `cancel`!='yes' ORDER BY `item_desc`,`cust_lname` ASC"); while($dtRow = mysql_fetch_array($dtl_qq)){ $patID = $dtRow['patient_id']; $sjItemID = $dtRow['item_id']; $itemDesc = mysql_result(mysql_query("SELECT `medicine_desc` FROM `medicines` WHERE `medicine_id`='$sjItemID'"),0); $checkPackage = mysql_result(mysql_query("SELECT `patient_package_code` FROM `patient_list` WHERE `patient_id`='$patID'"),0); if($checkPackage ==='19'){ $txCodeA ='Tx-Service Rate'; $txCodeB ='Tx-SR'; $pfCode ='PF-SRP'; }else if($sjItemID ==='0'){ $txCodeA ='INCOME - Tx'; $txCodeB ='INCOME - Tx'; $pfCode ='INCOME - Tx-PF'; }else { $txCodeA ='Tx-PHIC'; $txCodeB ='Tx-PHIC'; $pfCode ='PF-PHIC'; } if($dtRow['cancel'] !='yes'){ $scCAmount =$scCAmount + $dtRow['amount']; $trAmount = $dtRow['amount']; $sjCashTotal =$sjCashTotal + $sjAmount; } //if($trAmount > 0 || $trAmount < 0) { NOV 14.2017 echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "";//Debit Amount echo ""; echo ""; echo ""; //} } $dtl_cc=mysql_query("SELECT * FROM `sales_journal` WHERE `branch_code`='$compCode' AND `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `trans_type`='Advance' AND `cancel`='yes' || `trans_date` BETWEEN '$searchFromDate' AND '$searchToDate' AND `branch_code`='$compCode' AND `trans_type`='CASH' AND `cancel`='yes'"); while($dtRow = mysql_fetch_array($dtl_cc)){ //$scCAmount =$scCAmount + $dtRow['amount']; //$sjCashTotal =$sjCashTotal + $sjAmount; $xAmount = $dtRow['amount']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "";//Debit Amount echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

CASH RECEIPT JOURNAL REPORTORT ( )
"; echo "
Date	Account Description	Ref. No.	Name of Patient	QTY	Line Description	Debit Amnt	Credit Amnt	Job Description
".$row['journal_date']."	"; if($pID==='0'){ echo "PAYMENT RECEIVED"; }else { echo "CASH ON HAND"; } echo "	OR#: ".$row['ref_number']."	"; if($pID==='0'){ echo "PAYMENT RECEIVED"; }else { echo $cfname ." ". $clname; } echo "	-	"; if($pID==='0'){ echo "PAYMENT RECEIVED"; }else { echo $cfname ." ". $clname; } echo "	"; echo number_format($sjAmount,2,'.',','); echo "	-	-
".$dtRow['trans_date']."	"; $itemDes = $dtRow['item_desc']; $transType = $dtRow['trans_type']; if($itemDes ==='Tx-PHIC'){ echo 'INCOME - ' . $txCodeA; }else if($itemDes==='PHIC-PF'){ echo 'INCOME - ' . $pfCode; }else { echo 'INCOME - '.$itemDes; } echo "	OR#: ".$dtRow['trans_id']."	".$dtRow['cust_fname']." ".$dtRow['cust_lname']."	".$dtRow['trans_qty']."	"; $itemDes = $dtRow['item_desc']; //echo $itemDes; if($itemDes ==='Tx-PHIC'){ echo $txCodeB; }else if($itemDes==='PHIC-PF'){ echo $pfCode; }else { echo $itemDes; } echo "	-	".$dtRow['amount']."	"; //echo $dtRow['doctor_id']; $docID=$dtRow['doctor_id']; $docFName = mysql_result(mysql_query("SELECT `doc_fname` FROM `doctors_profile` WHERE `doc_id`='$docID'"),0); $docLName = mysql_result(mysql_query("SELECT `doc_lname` FROM `doctors_profile` WHERE `doc_id`='$docID'"),0); if($dtRow['item_desc']==='PHIC-PF'){ echo $suf. " " .$docFName .", ". $docLName; }else { echo "-"; } echo "
".$dtRow['trans_date']."	".$dtRow['item_desc']."	".$dtRow['trans_id']."	".$dtRow['cust_fname']." ".$dtRow['cust_lname']."	0	"; $itemDes = $dtRow['item_desc']; if($itemDes!='TX-CASH OUT' || $itemDes!='PHIC-PF' || $itemDes!='SRP-PF' || $itemDes!='PHIC-Incentive' || $itemDes!='Tx-PHIC'){ echo "INCOME - ".$itemDes; }else { switch($itemDes){ case 'TX-CASH OUT': echo "INCOME - Tx-SRP"; break; case 'PHIC-PF': echo "SRP-PF"; break; case 'PHIC-Incentive': echo "PSI-PHIC INCENTIVE"; break; case 'Tx-PHIC': echo "Tx - SRP"; break; case 'SRP-PF': echo "SRP-PF"; break; } } echo "	-	0	"; //echo $dtRow['doctor_id']; $docID=$dtRow['doctor_id']; $docFName = mysql_result(mysql_query("SELECT `doc_fname` FROM `doctors_profile` WHERE `doc_id`='$docID'"),0); $docLName = mysql_result(mysql_query("SELECT `doc_lname` FROM `doctors_profile` WHERE `doc_id`='$docID'"),0); echo "Cancelled (" . $xAmount .")"; echo "
TOTAL						".number_format($sjTotal,2,'.',',')."	".number_format($scCAmount,2,'.',',')."
Print Version

"; ?>