echo "<table border=0 width='160%'>";
echo "<tr>";
echo "<td><b>Name:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>";
echo "<td><b>Date:</b> " . $ro->selectNow("radioSavedReport", "date", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Age/Sex</b> " . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "<td>Physician: <b>" . $ro->selectNow("radioSavedReport", "physician", "itemNo", $itemNo) . "</b></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Room:</b> " . $ro->getRegistrationDetails_room() . "</td>";
echo "<td>Examination: <b>{$description}</b></td>";
echo "</tr>";
echo "</table>";
echo "<textarea id='report' name='radioReport' class='txtArea'>";
echo $ro->doubleSelectNow("radioSavedReport", "radioReport", "registrationNo", $registrationNo, "itemNo", $itemNo);
echo "</textarea>";
echo "<br><br>";
$ro->coconutButton("edit");
$ro->coconutFormStop();
?>
<script type="text/javascript">
CKEDITOR.replace( 'report',
{
enterMode : CKEDITOR.ENTER_BR,
skin : 'office2003'
});
$totalDays = $dateOut[1] + 31 - $dateIn[1];
} else {
if ($dateIn[0] == "Nov") {
$totalDays = $dateOut[1] + 30 - $dateIn[1];
} else {
}
}
}
}
}
}
}
}
}
}
}
}
}
//echo "Total Days ".$totalDays;
$totalPrice = $ro->doubleSelectNow("patientCharges", "sellingPrice", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()) * $totalDays;
$totalPHIC = 500 * $totalDays;
$totalExcess = $totalPrice - $totalPHIC;
//echo "<br>Total Price ".$totalPrice;
//echo "<br>Total PhilHealth ".$totalPHIC;
//echo "<br>Total Excess ".($totalPrice - $totalPHIC);
$ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "quantity", $totalDays);
$ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "total", $totalPrice);
$ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "phic", $totalPHIC);
$ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "cashUnpaid", $totalExcess);
//addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/SOAoption/summary.php?registrationNo={$registrationNo}&username={$username}");
} else {
}
}
}
}
}
}
}
}
}
}
}
}
$datePaid = $year . "-" . $month . "-" . $day;
for ($x = 0; $x < $countz; $x++) {
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "cashPaid", $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
// kuhain ang total price at ilagay sa cashPaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "cashUnpaid", "0");
// gwen 0 ang cashUnpaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "status", "PAID");
// tagged as PAID
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "datePaid", $datePaid);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "control_datePaid", $year . "-" . $m . "-" . $day);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "timePaid", $ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "paidBy", $username);
// gwen 0 ang cashUnpaid cols
/*
$newQty = ( $ro->selectNow("inventory","quantity","inventoryCode", $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo[$x])) - $ro->selectNow("patientCharges","quantity","itemNo",$itemNo[$x]) );
$ro->editNow("inventory","inventoryCode",$ro->doubleSelectNow("patientCharges","chargesCode","itemNo",$itemNo[$x],"registrationNo",$registrationNo),"quantity",$newQty);
*/
<?php
include "../../../myDatabase1.php";
$username = $_GET['username'];
$itemNo = $_GET['itemNo'];
$registrationNo = $_GET['registrationNo'];
$ro = new database1();
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashPaid", $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo, "registrationNo", $registrationNo));
// kuhain ang total price at ilagay sa cashPaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashUnpaid", "0");
// gwen 0 ang cashUnpaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "status", "PAID");
// tagged as PAID
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "datePaid", date("M_d_Y"));
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "timePaid", $ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "paidBy", $username);
// gwen 0 ang cashUnpaid cols
$newQty = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) - $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
$ro->editNow("inventory", "inventoryCode", $ro->doubleSelectNow("patientCharges", "chargesCode", "itemNo", $itemNo, "registrationNo", $registrationNo), "quantity", $newQty);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentStatus", "dispensedBy_" . $username);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentTime", $ro->getSynapseTime());