<?php include "myDatabase.php"; include "myDatabase4.php"; $ro = new database(); $ro4 = new database4(); $ro4->opdPayment_updater("2016-04-01", "2016-04-01"); foreach ($ro4->opdPayment_updater_itemNo() as $itemNo) { $registrationNo = $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo); $shift = $ro->selectNow("patientCharges", "reportShift", "itemNo", $itemNo); $description = $ro->selectNow("patientCharges", "description", "itemNo", $itemNo); if ($ro->selectNow("patientCharges", "paidVia", "itemNo", $itemNo) == "Cash") { $amountPaid = $ro->selectNow("patientCharges", "cashPaid", "itemNo", $itemNo); } else { $amountPaid = $ro->selectNow("patientCharges", "amountPaidFromCreditCard", "itemNo", $itemNo); } $orNo = $ro->selectNow("patientCharges", "orNO", "itemNo", $itemNo); $type = "OPD"; $paidBy = $ro->selectNow("patientCharges", "paidBy", "itemNo", $itemNo); $timePaid = $ro->selectNow("patientCharges", "timePaid", "itemNo", $itemNo); $datePaid = $ro->selectNow("patientCharges", "datePaid", "itemNo", $itemNo); $paidVia = $ro->selectNow("patientCharges", "paidVia", "itemNo", $itemNo); $myData = array("registrationNo" => $registrationNo, "itemNo" => $itemNo, "shift" => $shift, "description" => $description, "amountPaid" => $amountPaid, "orNo" => $orNo, "type" => $type, "paidBy" => $paidBy, "timePaid" => $timePaid, "datePaid" => $datePaid, "paidVia" => $paidVia); $ro4->insertNow("collectionReport", $myData); }