function getPayment($paymentID) { $payment = new Payment(); $payment->selectRecord($paymentID); if (!($domDoc = $payment->getDomDocument())) { return false; } else { $xmlStr = $domDoc->dump_mem(true); return $xmlStr; } }
function purge() { $rptsDB = new DB_RPTS(); $rptsDB2 = new DB_RPTS(); $sqlselect = "SELECT collectionID FROM collections WHERE receiptNum = '' OR receiptNum is NULL;"; $rptsDB->query($sqlselect); $due = new Dues(); while ($rptsDB->next_record()) { $collectionID = $rptsDB->f("collectionID"); $this->collectionID = $collectionID; $this->isStoredInDatabase = true; $sqlselect2 = "select payments.paymentID, payments.dueID from payments \n \t\t\t\t\t\tinner join collectionPayments on payments.paymentID=collectionPayments.paymentID \n where collectionPayments.collectionID ={$collectionID}"; #echo("$sqlselect2<br>"); $rptsDB2->query($sqlselect2); $payment = new Payment(); while ($rptsDB2->next_record()) { $payment->setPaymentID($rptsDB2->f("paymentID")); $payment->selectRecord(); // if Payment is BacktaxTD, FLAG BacktaxTD paidStatus as '' for false / UNPAID if ($strstr = strstr($payment->dueType, ",")) { $backtaxTDID = strstr($strstr, "="); $backtaxTDID = str_replace("=", "", $backtaxTDID); $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord("", $backtaxTDID); $backtaxTD->setBacktaxTDID($backtaxTDID); $backtaxTD->setTotalPaid(0); $backtaxTD->updatePaidStatus(""); $backtaxTD->updateRecord(); } $dueID = $rptsDB2->f("dueID"); $due->setDueID($dueID); $due->select(); $due->resetPayments(); $due->store(); } if (!$this->deleteRecord()) { return false; } } return true; }
function selectRecords($condition = "") { $sql = sprintf("select * from %s %s;", PAYMENT_TABLE, $condition); //echo $sql; //echo "<hr>"; $this->setDB(); $this->db->query($sql); while ($this->db->next_record()) { $payment = new Payment(); $payment->selectRecord($this->db->f("paymentID")); $this->arrayList[] = $payment; unset($payment); } unset($this->db); if (count($this->arrayList) > 0) { $this->setDomDocument(); return true; } else { return false; } }
function cancelReceiptList($receiptIDArray = "") { if (is_array($receiptIDArray)) { $collectionRecords = new CollectionRecords(); $collection = new Collection(); $receipt = new Receipt(); $payment = new Payment(); foreach ($receiptIDArray as $receiptID) { // find other receipts associated to payment $collectionRecords->selectRecords("WHERE receiptID='" . $receiptID . "'"); $paymentID = $collectionRecords->arrayList[0]->getPaymentID(); $collectionRecords->selectRecords("WHERE paymentID='" . $paymentID . "'"); if (is_array($collectionRecords->getArrayList())) { foreach ($collectionRecords->getArrayList() as $collection) { $cancelReceiptIDArray[] = $collection->getReceiptID(); $cancelPaymentIDArray[] = $collection->getPaymentID(); $cancelCollectionIDArray[] = $collection->getCollectionID(); } } } $cancelCollectionIDArray = array_unique($cancelCollectionIDArray); $cancelReceiptIDArray = array_unique($cancelReceiptIDArray); $cancelPaymentIDArray = array_unique($cancelPaymentIDArray); foreach ($cancelCollectionIDArray as $collectionID) { $collection->selectRecord($collectionID); $collection->setStatus("cancelled"); $collection->updateRecord(); } $condition = " WHERE "; foreach ($cancelReceiptIDArray as $receiptID) { if ($condition != " WHERE ") { $condition .= " OR "; } $condition .= " receiptID = '" . $receiptID . "' "; $receipt->selectRecord($receiptID); $receipt->setStatus("cancelled"); $receipt->updateRecord(); } foreach ($cancelPaymentIDArray as $paymentID) { $payment->selectRecord($paymentID); $payment->setStatus("cancelled"); $payment->updateRecord(); } // cancel associated mergedReceipts $receiptRecords = new ReceiptRecords(); if ($receiptRecords->selectRecords($condition)) { if (!($domDoc = $receiptRecords->getDomDocument())) { return false; } else { $xmlStr = $domDoc->dump_mem(true); return $xmlStr; } } else { return false; } } else { return false; } }