File manager

File manager - Edit - /home/autoph/public_html/portal/includes/cash-receipt_cs_new.php

Back
<?php $myDate = explode("/",$toDate); $myDay = $myDate[1]; $myMonth = $myDate[0]; $myYear = $myDate[2]; $compCode = $user_data['company_assignment']; ?> <div STYLE='height: 450px; width: 100%; font-size: 12px; overflow: auto;'> <table style="border-collapse:collapse;background:#fff:border:none;height:100%;width:100%"> <tr> <td class="lightGradient" style="border:1px solid lightgray;height:32px;font-size:14px;font-weight:normal;color:gray"> <img src="images/bullet.gif" width="10px" height="10px"> </img> <b style="font-size:14px;color:red">CASH RECEIPT JOURNAL REPORTORT ( <?php echo $_GET['dateFrom']. " \| ".$_GET['dateTo'];?>)</b> </td> </tr> <tr> <td valign="TOP" style="border:1px solid white;font-size:14px;weight:bold;color:gray;height:400px;background:white"> <?php $searchFromDate = $_GET['dateFrom']; $searchToDate = $_GET['dateTo']; $qq=mysql_query("SELECT * FROM `sales_journal_hdr` WHERE `journal_comp_id`='$compCode' AND `journal_date` BETWEEN '$searchFromDate' AND '$searchToDate' ORDER by `ref_number` ASC"); echo "<table style='width:100%; height:95% border:1px solid white; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:80px;background:lightgray;border:1px solid gray;font-size:13px;height:20px'>Date</th> <th class='Gradient' align='center' style='width:200px;background:lightgray;border:1px solid gray;font-size:13px'> Account Description</th> <th class='Gradient' align='center' style='width:100px;background:lightgray;border:1px solid gray;font-size:13px'>Ref. No.</th> <th class='Gradient' align='center' style='width:150px;background:lightgray;border:1px solid gray;font-size:13px'>Name of Patient</th> <th class='Gradient' align='center' style='width:30px;background:lightgray;border:1px solid gray;font-size:13px'>QTY</th> <th class='Gradient' align='center' style='width:200px;background:lightgray;border:1px solid gray;font-size:13px'>Line Description</th> <th class='Gradient' align='center' style='width:80px;background:lightgray;border:1px solid gray;font-size:13px'>Debit Amnt</th> <th class='Gradient' align='center' style='width:80px;background:lightgray;border:1px solid gray;font-size:13px'>Credit Amnt</th> <th class='Gradient' align='center' style='width:200px;background:lightgray;border:1px solid gray;font-size:13px'> Job Description</th> </tr>"; 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 "<tr>"; if($sjAmount > 0){ //NOV 14.2017 echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:20px'>".$row['journal_date']."</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;width:200px;height:20px'>"; if($pID==='0'){ echo "PAYMENT RECEIVED"; }else { echo "CASH ON HAND"; } echo "</a></td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;height:20px'>OR#: ".$row['ref_number']."</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;height:20px'>"; if($pID==='0'){ echo "PAYMENT RECEIVED"; }else { echo $cfname ." ". $clname; } echo "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;height:20px'> - </td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:left;height:20px'>"; if($pID==='0'){ echo "PAYMENT RECEIVED"; }else { echo $cfname ." ". $clname; } echo "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:right;height:20px'>"; echo number_format($sjAmount,2,'.',','); echo "</td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:100px;height:20px'> - </td>"; echo "<td style='font-size:12px;border:1px solid lightgray;text-align:center;width:100px;height:20px'> -</td>"; echo "</tr>"; $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 "<tr>"; echo "<td style='font-size:12px;text-align:center;border:1px solid lightgray'>".$dtRow['trans_date']."</td>"; echo "<td style='font-size:12px;text-align:left;border:1px solid lightgray;width:200px'>"; $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 "</td>"; echo "<td style='font-size:12px;text-align:left;border:1px solid lightgray'>OR#: ".$dtRow['trans_id']."</td>"; echo "<td style='font-size:12px;text-align:left;border:1px solid lightgray'>".$dtRow['cust_fname']." ".$dtRow['cust_lname']."</td>"; echo "<td style='font-size:12px;text-align:center;border:1px solid lightgray'>".$dtRow['trans_qty']."</td>"; echo "<td style='font-size:12px;text-align:left;border:1px solid lightgray'>"; $itemDes = $dtRow['item_desc']; //echo $itemDes; if($itemDes ==='Tx-PHIC'){ echo $txCodeB; }else if($itemDes==='PHIC-PF'){ echo $pfCode; }else { echo $itemDes; } echo "</td>"; echo "<td style='font-size:12px;text-align:center;border:1px solid lightgray'>-</td>";//Debit Amount echo "<td style='font-size:12px;text-align:right;border:1px solid lightgray'>".$dtRow['amount']."</td>"; echo "<td style='font-size:12px;text-align:left;border:1px solid lightgray'>"; //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 "</td>"; echo "</tr>"; //} } $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 "<tr>"; echo "<td style='font-size:12px;color:red;text-align:center;border:1px solid lightgray'>".$dtRow['trans_date']."</td>"; echo "<td style='font-size:12px;color:red;text-align:left;border:1px solid lightgray'>".$dtRow['item_desc']."</td>"; echo "<td style='font-size:12px;color:red;text-align:center;border:1px solid lightgray'>".$dtRow['trans_id']."</td>"; echo "<td style='font-size:12px;color:red;text-align:left;border:1px solid lightgray'>".$dtRow['cust_fname']." ".$dtRow['cust_lname']."</td>"; echo "<td style='font-size:12px;color:red;text-align:center;border:1px solid lightgray'>0</td>"; echo "<td style='font-size:12px;color:red;text-align:left;border:1px solid lightgray;width:200px'>"; $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 "</td>"; echo "<td style='font-size:12px;color:red;text-align:center;border:1px solid lightgray'>-</td>";//Debit Amount echo "<td style='font-size:12px;color:red;text-align:right;border:1px solid lightgray'>0</td>"; echo "<td style='font-size:12px;color:red;text-align:center;border:1px solid lightgray'>"; //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 "</td>"; echo "</tr>"; } echo "<tr>"; echo "<td colspan='6' style='text-align:right;border:1px solid lightgray;font-size:14px;font-weight:bold'>TOTAL</td>"; echo "<td style='text-align:right;border:1px solid lightgray;font-size:14px;font-weight:bold'>".number_format($sjTotal,2,'.',',')."</td>"; echo "<td style='text-align:right;border:1px solid lightgray;font-size:14px;font-weight:bold'>".number_format($scCAmount,2,'.',',')."</td>"; echo "<td colspan='2' style='text-align:right;border:1px solid lightgray;font-size:16px;font-weight:bold'></td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='9' style='text-align:right;border:1px solid lightgray;font-size:14px;font-weight:bold'><a href='sales-receipt-print.php?dateFrom=$searchFromDate&dateTo=$searchToDate' target='_Blank'>Print Version</a></td>"; echo "</tr>"; echo "</table>"; ?> </td> </tr> </table> </div>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings