function getPaymentList($condition = "") { $paymentRecords = new PaymentRecords(); if ($paymentRecords->selectRecords($condition)) { if (!($domDoc = $paymentRecords->getDomDocument())) { return false; } else { $xmlStr = $domDoc->dump_mem(true); return $xmlStr; } } else { return false; } }
function getSortedOwnerArrayListFromPayment() { $paymentRecords = new PaymentRecords(); $condition = " WHERE status!='cancelled' "; $paymentRecords->selectRecords($condition); if (is_array($paymentRecords->arrayList)) { foreach ($paymentRecords->arrayList as $payment) { $ownerIDArray[] = $payment->getOwnerID(); } $ownerIDArrayUnique = array_unique($ownerIDArray); $sortedOwnerIDArray = $this->getSortedOwnerIDArray($ownerIDArrayUnique); return $sortedOwnerIDArray; } else { return false; } }
function getPaymentRecordsOwnerID($ownerID) { $condition = " WHERE ownerID=" . $ownerID . " AND status!='cancelled' ORDER BY paymentDate ASC"; $paymentRecords = new PaymentRecords(); $paymentRecords->selectRecords($condition); if (is_array($paymentRecords->arrayList)) { return $paymentRecords; } else { return false; } }
<input type="hidden" name="formAction" value="go"> <input type="submit" name="goBtn" value="Process Next Batch"> </form> <? if($_GET["formAction"]!="go") exit; ini_set("max_execution_time",300); include_once("collection/Payment.php"); include_once("collection/PaymentRecords.php"); //$condition = "WHERE Payment.propertyType IS NULL "; $paymentRecords = new PaymentRecords; $paymentRecords->selectRecords($condition); echo "<hr>"; echo "count:"; echo count($paymentRecords->arrayList); echo "<hr>"; $count = 0; foreach($paymentRecords->arrayList as $payment){ if(is_numeric($_GET["limit"])){ if($count==$_GET["limit"]){ exit; } }
function getFilteredPaymentRecords() { $paymentEndingDate = date("Y-m-d", strtotime($this->formArray["quarterEndingDate"] . " " . $this->formArray["year"])); $paymentBeginningDate = date("Y-m-d", strtotime($this->formArray["quarterBeginningDate"] . " " . $this->formArray["year"])); $condition = "WHERE " . PAYMENT_TABLE . ".status!='cancelled' AND (" . PAYMENT_TABLE . ".paymentDate >= '" . $paymentBeginningDate . "' AND " . PAYMENT_TABLE . ".paymentDate <= '" . $paymentEndingDate . "')"; $condition .= " AND " . PAYMENT_TABLE . ".propertyType IS NOT NULL"; $paymentRecords = new PaymentRecords($this->dbName); if ($paymentRecords->selectRecords($condition)) { return $paymentRecords; } else { return false; } }