PHP Receipt::selectRecord方法代码示例

 function getReceipt($receiptID)
 {
     $receipt = new Receipt();
     $receipt->selectRecord($receiptID);
     if (!($domDoc = $receipt->getDomDocument())) {
         return false;
     } else {
         $xmlStr = $domDoc->dump_mem(true);
         return $xmlStr;
     }
 }

 function getCollectionArrayList()
 {
     $sortedOwnerIDArray = $this->getSortedOwnerIDArray();
     foreach ($sortedOwnerIDArray as $ownerID) {
         $ownerName = $this->getOwnerName($ownerID);
         $paymentRecords = $this->getPaymentRecordsOwnerID($ownerID);
         if (is_array($paymentRecords->arrayList)) {
             foreach ($paymentRecords->arrayList as $payment) {
                 $paymentID = $payment->getPaymentID();
                 $paymentDate = $payment->getPaymentDate();
                 $taxDeclarationNumber = $this->getTDNumberFromPayment($payment->getTdID(), $payment->getBacktaxTDID());
                 $collectionRecords = $this->getCollectionRecordsFromPaymentID($paymentID);
                 if (is_array($collectionRecords->arrayList)) {
                     foreach ($collectionRecords->arrayList as $collection) {
                         $receipt = new Receipt();
                         $receiptID = $collection->getReceiptID();
                         $receipt->selectRecord($receiptID);
                         $receiptNumber = $receipt->getReceiptNumber();
                         $basicTax = 0;
                         $sefTax = 0;
                         switch ($collection->getTaxType()) {
                             case "basic":
                                 $basicTax = $collection->getAmountPaid();
                                 break;
                             case "sef":
                                 $sefTax = $collection->getAmountPaid();
                                 break;
                         }
                         $total = $basicTax + $sefTax;
                         $collectionRecordArray = array("ownerName" => $ownerName, "taxDeclarationNumber" => $taxDeclarationNumber, "datePaid" => $paymentDate, "orNumber" => $receiptNumber, "basicTax" => $basicTax, "sefTax" => $sefTax, "total" => $total);
                         $collectionArrayList[] = $collectionRecordArray;
                     }
                 }
             }
         }
     }
     if (is_array($collectionArrayList)) {
         return $collectionArrayList;
     } 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;
     }
 }

 function getReceipt($receiptID)
 {
     $receipt = new Receipt($this->dbName);
     if ($receipt->selectRecord($receiptID)) {
         return $receipt;
     }
     return false;
 }

 function searchRecords($searchKey, $fields, $limit)
 {
     $condition = "where (";
     foreach ($fields as $key => $value) {
         if ($key == 0) {
             $condition = $condition . $value . " like '%" . $searchKey . "%'";
         } else {
             $condition = $condition . "or " . $value . " like '%" . $searchKey . "%' ";
         }
     }
     if (!strstr(strtoupper($limit), 'ORDER')) {
         $sql = sprintf("select * from %s %s;", RECEIPT_TABLE, $condition . ") and status != 'cancelled' ORDER BY receiptID DESC " . $limit);
     } else {
         $limit = str_replace("WHERE", "and", $limit);
         $sql = sprintf("select * from %s %s;", RECEIPT_TABLE, $condition . ") " . $limit);
     }
     //echo $sql;
     $this->setDB();
     $this->db->query($sql);
     while ($this->db->next_record()) {
         $receipt = new Receipt();
         $receipt->selectRecord($this->db->f("receiptID"));
         $this->arrayList[] = $receipt;
     }
     if (count($this->arrayList) > 0) {
         $this->setDomDocument();
         return true;
     } else {
         return false;
     }
 }