/** * fetchByPaymentRefono, retrieves a single payment as an array * @param string $paymentRefnoId of the payment to be removed * @return array The row to be returned */ public function getByRefNo($paymentrefno) { $ccObject = new Model_Core_Creditcard(); $fields = array('refNo' => 'refno', 'policyNumber' => 'policynumber', 'paymentFrequency' => 'paymentfrequency', 'cardName' => 'cardname', 'cardNumber' => 'cardnumber', 'cardType' => 'cardtype', 'expiryDate' => 'expirydate', 'startDate' => 'startdate', 'issueNo' => 'issueno', 'paymentDate' => 'paymentdate', 'paymentRefNo' => 'paymentrefno', 'merchantId' => 'merchantid', 'expWarnLetterSent' => 'expwarnlettersent'); $select = $this->select()->from($this->_name, $fields)->where('refno = ?', $paymentrefno)->order('paymentdate DESC')->order('paymentrefno DESC')->limit(1); $row = array(); $row = $this->fetchRow($select); if (!empty($row)) { $ccObject->refNo = $row->refNo; $ccObject->policyNumber = $row->policyNumber; $ccObject->paymentFrequency = $row->paymentFrequency; $ccObject->cardName = $row->cardName; $ccObject->cardNumber = $row->cardNumber; $ccObject->cardType = $row->cardType; $ccObject->expiryDate = $row->expiryDate; $ccObject->startDate = $row->startDate; $ccObject->issueNo = $row->issueNo; $ccObject->paymentDate = $row->paymentDate; $ccObject->paymentRefNo = $row->paymentRefNo; $ccObject->merchantId = $row->merchantId; $ccObject->expWarnLetterSent = $row->expWarnLetterSent; return $ccObject; } else { // Could not find a requested Payment Application_Core_Logger::log("No Credit Card Payment for this reference number {$paymentrefno}. Not found in table {$this->_name}", 'warning'); return false; } }
/** * Returns all the previous claim types. * * This method reads in all the previous claim types recognised by the * system and populates each one into a PreviousClaimType object. An * array of these objects will then be returned. The results can be filtered * by supplying an argument to reflect this. * * @param string $productName * Filters the results by product name. Must correspond to a const exposed by the * Model_Insurance_ProductNames class. * * @return array * An array of PreviousClaimType objects, each one encapsulating a valid previous * claim type. */ public function getPreviousClaimTypes($productName = null) { $select = $this->select(); //Prepare the where clause, if applicable. if (!empty($productName)) { switch ($productName) { case Model_Insurance_ProductNames::TENANTCONTENTSPLUS: $fieldValue = 'tenants'; break; case Model_Insurance_ProductNames::LANDLORDSPLUS: $fieldValue = 'landlords'; break; case Model_Insurance_ProductNames::PORTFOLIOINSURANCE: $fieldValue = 'portfolio'; break; default: throw new Zend_Exception(get_class() > __FUNCTION__ . ': argument supplied is invalid.'); } $select->where('claimType = ?', $fieldValue); } $claimTypesAll = $this->fetchAll($select); if (count($claimTypesAll) > 0) { //Populate the data retrieved into PreviousClaimType objects. $returnArray = array(); foreach ($claimTypesAll as $currentClaimType) { $returnArray[] = new Model_Insurance_PreviousClaimType($currentClaimType['claimTypeID'], $currentClaimType['claimType'], $currentClaimType['claimTypeText']); } return $returnArray; } else { // Can't get previous claim types - log a warning Application_Core_Logger::log("Can't get previous claim types from table {$this->_name} (filterBy = {$productName})", 'warning'); } }
/** * Retrieves the specified property lease. * * @param integer $propertyLeaseId * The unique property lease identifier. * * @return mixed * The property lease details, encapsulated in a Model_Referencing_PropertyLease * object, or null if the property lease cannot be found. */ public function getByPropertyLeaseId($propertyLeaseId) { $select = $this->select(); $select->where('id = ?', $propertyLeaseId); $propertyLeaseRow = $this->fetchRow($select); if (empty($propertyLeaseRow)) { Application_Core_Logger::log(get_class() . '::' . __FUNCTION__ . ':Unable to find property lease.'); $returnVal = null; } else { $propertyLease = new Model_Referencing_PropertyLease(); $propertyLease->id = $propertyLeaseRow->id; //Add the address details if (!empty($propertyLeaseRow->address_id)) { $addressDatasource = new Datasource_Core_Addresses(); $propertyLease->address = $addressDatasource->getById($propertyLeaseRow->address_id); } if ($propertyLeaseRow->monthly_rent >= 0) { $propertyLease->rentPerMonth = new Zend_Currency(array('value' => $propertyLeaseRow->monthly_rent, 'precision' => 0)); } if (!empty($propertyLeaseRow->start_date)) { if ($propertyLeaseRow->start_date != '0000-00-00') { $propertyLease->tenancyStartDate = new Zend_Date($propertyLeaseRow->start_date, Zend_Date::ISO_8601); } } $propertyLease->tenancyTerm = $propertyLeaseRow->term; $propertyLease->noOfTenants = $propertyLeaseRow->no_of_tenants; $returnVal = $propertyLease; } return $returnVal; }
/** * Update an existing Schedule * @param $policyNumber A policy number * */ public function store($policyNumber, $data) { $dataArray = array(); $dataArray['paymentrefno'] = $data->paymentRefNo; $dataArray['january'] = $data->january; $dataArray['february'] = $data->february; $dataArray['march'] = $data->march; $dataArray['april'] = $data->april; $dataArray['may'] = $data->may; $dataArray['june'] = $data->june; $dataArray['july'] = $data->july; $dataArray['august'] = $data->august; $dataArray['september'] = $data->september; $dataArray['october'] = $data->october; $dataArray['november'] = $data->november; $dataArray['december'] = $data->december; #$dataArray['policynumber'] = $data->policyNumber; $dataArray['sixmonthfee'] = $data->sixMonthFee; $dataArray['ddfee'] = $data->ddFee; $dataArray['banked'] = $data->banked; // Save the record $where = $this->quoteInto('policynumber = ?', $policyNumber); if (!$this->update($dataArray, $where)) { // Failed update Application_Core_Logger::log("Can't update schedule in table {$this->_name}", 'error'); } }
/** * Returns an existing address. * * @param integer $addressId * The unique address identifier. * * @return mixed * A Model_Core_Address encapsulating the address details, or null if * the address cannot be found. */ public function getById($addressId) { if (empty($addressId)) { return null; } $select = $this->select(); $select->where('id = ?', $addressId); $addressRow = $this->fetchRow($select); if (empty($addressRow)) { Application_Core_Logger::log(get_class() . '::' . __FUNCTION__ . ':Unable to find address.'); $returnVal = null; } else { $address = new Model_Core_Address(); $address->id = $addressRow->id; $address->flatNumber = $addressRow->flat_number; $address->houseName = $addressRow->house_name; $address->houseNumber = $addressRow->house_number; $address->addressLine1 = $addressRow->address_line1; $address->addressLine2 = $addressRow->address_line2; $address->town = $addressRow->town; $address->county = $addressRow->county; $address->postCode = $addressRow->postcode; $address->country = $addressRow->country; $address->isOverseasAddress = $addressRow->is_overseas == 1 ? true : false; $returnVal = $address; } return $returnVal; }
/** * Insert a new row into the portfolio table * * @param Model_Insurance_Portfolio_Portfolio propertyObject The Property to save * * @return int The last insert ID */ public function save($propertyObject) { $insertArray = array(); $insertArray['policynumber'] = $propertyObject->policyNumber; $insertArray['premium'] = $propertyObject->premium; $insertArray['quote'] = $propertyObject->quote; $insertArray['IPT'] = $propertyObject->ipt; $insertArray['policyoptions'] = $propertyObject->policyOptions; $insertArray['amountscovered'] = $propertyObject->amountsCovered; $insertArray['optionpremiums'] = $propertyObject->optionPremiums; $insertArray['propaddress1'] = $propertyObject->propAddress1; $insertArray['propaddress3'] = $propertyObject->propAddress3; $insertArray['propaddress5'] = $propertyObject->propAddress5; $insertArray['proppostcode'] = $propertyObject->propPostcode; $insertArray['riskarea'] = $propertyObject->riskArea; $insertArray['discount'] = $propertyObject->discount; $insertArray['surcharge'] = $propertyObject->surcharge; $insertArray['rateSetID'] = 0; $insertArray['excessID'] = $propertyObject->excessId; $insertArray['optiondiscounts'] = $propertyObject->optionDiscounts; $insertArray['riskareab'] = $propertyObject->riskAreaB; if ($lastId = $this->insert($insertArray)) { return $lastId; } else { // Error Application_Core_Logger::log("Could not insert into table {$this->_name}", 'error'); return false; } }
/** * Inserts a new additional information record into the additionalinfo table. * * Function responsible for adding additional information to a quote or policy, * to supplement the underwriting answers. * * @param Model_Insurance_AdditionalInformation $additionalInformation * A Model_Insurance_AdditionalInformation object containing all the additional * information provided by the user when applying for a policy / policy * renewal etc. * * @return void */ public function insertAdditionalInformation($additionalInformation) { $data = array('policynumber' => $additionalInformation->getPolicyNumber(), 'additionalinfo' => $additionalInformation->getAdditionalInformation()); if (!$this->insert($data)) { // Failed insertion Application_Core_Logger::log("Can't insert specified possession in table {$this->_name}", 'error'); } }
/** * Inserts a single previous claim into the dbase. * * Receives a single Model_Insurance_PreviousClaim object - which * represents an instance where the customer has made a claim on a previous * policy - and attempts to insert it intothe previousClaims table. * * @param Model_Insurance_PreviousClaim $previousClaim * A Model_Underwriting_DomainObjects_PreviousClaim object which provide information * about the previous claim to insert. */ public function insertPreviousClaim($previousClaim) { $data = array('refno' => $previousClaim->getRefno(), 'claimmonth' => $previousClaim->getClaimMonth(), 'claimyear' => $previousClaim->getClaimYear(), 'claimvalue' => $previousClaim->getClaimValue()->getValue(), 'claimTypeID' => $previousClaim->getClaimType()->getClaimTypeID()); if (!$this->insert($data)) { // Failed insertion Application_Core_Logger::log("Can't insert previous claim in table {$this->_name}", 'error'); } }
/** * Writes a single UW answer to the dbase. * * This method writes to the dbase the UW answer passed in. It expects a single * underwriting answer, encapsulated in an Model_Insurance_Answer * object. * * @param Model_Insurance_Answer $answer * An Model_Insurance_Answer object encapsulating the answer given * by the user in response to the corresponding UW question. */ public function insertUnderwritingAnswer($answer) { $dateAnswered = $answer->getDateAnswered()->toString(Zend_Date::ISO_8601); $data = array('policyNumber' => $answer->getPolicyNumber(), 'questionID' => $answer->getQuestionNumber(), 'answerGiven' => $answer->getAnswer(), 'dateAnswered' => $dateAnswered); if (!$this->insert($data)) { // Failed insertion Application_Core_Logger::log("Can't insert underwriting answer in table {$this->_name}", 'error'); } }
/** * Inserts sharers into the database. * * This method provides a convenient way of inserting sharers into the database. * * @param Model_Insurance_TenantsContentsPlus_Sharers $sharers * The Model_Insurance_TenantsContentsPlus_Sharers object containing all the sharers * information to be inserted. * * @return void */ public function insertSharers($sharer) { //Put it all together and insert. $data = array('policynumber' => $sharer->getPolicyNumber(), 'sharer1' => $sharer->getSharerOccupation(Model_Insurance_TenantsContentsPlus_Sharers::SHARER_01), 'sharer2' => $sharer->getSharerOccupation(Model_Insurance_TenantsContentsPlus_Sharers::SHARER_02)); if (!$this->insert($data)) { // Failed insertion Application_Core_Logger::log("Can't insert sharers in table {$this->_name}", 'error'); } }
/** * TODO: Document this * @param * @return * @author John Burrin */ private function _insert($insertArray) { if ($id = $this->insert($insertArray)) { return $id; } else { // Error Application_Core_Logger::log("Could not insert into table {$this->_name}", 'error'); return false; } }
/** * Save a mta object in the database * * @param Model_Insurance_MTA $mta this is the MTA object you want saving * @return bool|int */ public function create(Model_Insurance_MTA $mta) { $data = array('policynumber' => $mta->getPolicynumber(), 'policyoptions' => $mta->getPolicyoptions(), 'amountscovered' => $mta->getAmountscovered(), 'optionpremiums' => $mta->getOptionpremiums(), 'dateAdded' => $mta->getDateAdded(), 'dateOnRisk' => $mta->getDateOnRisk(), 'dateOffRisk' => $mta->getDateOffRisk(), 'status' => $mta->getStatus(), 'MTAId' => $mta->getMTAId(), 'premium' => $mta->getPremium(), 'quote' => $mta->getQuote(), 'ipt' => $mta->getIpt(), 'amountToPay' => $mta->getAmountToPay(), 'AdminCharge' => $mta->getAdminCharge(), 'displayNotes' => $mta->getDisplayNotes(), 'monthsRemaining' => $mta->getmonthsRemaining(), 'propAddress1' => $mta->getPropAddress1(), 'propAddress3' => $mta->getPropAddress3(), 'propAddress5' => $mta->getPropAddress5(), 'propPostcode' => $mta->getPropPostcode(), 'changeCorrespondenceAndPersonal' => $mta->getChangeCorrespondenceAndPersonal(), 'riskArea' => $mta->getRiskArea(), 'riskAreaB' => $mta->getRiskAreaB(), 'paidNet' => $mta->getPaidNet(), 'paragonMortgageNumber' => $mta->getParagonMortgageNumber()); $mtaID = $this->insert($data); if (!$mtaID) { // Failed insertion Application_Core_Logger::log("Can't insert MTA in table {$this->_name}", 'error'); return false; } return $mtaID; }
/** * Reflects in the datasource the loading(s) to be applied to a particular policy. * * @param string $policyNumber * The quote or policy number. * * @param string $optionsdiscounts * The pipe-delimited loadings to insert into the record. This will reflect the * loading applied to the particular coverages. * * @param Zend_Date $date * The date on which the loading applies. * * @return boolean * Returns true if loading is successfully inserted. */ public function addLoadingHistory($policyNumber, $optionDiscounts, $date) { $data = array('policynumber' => $policyNumber, 'optiondiscounts' => $optionDiscounts, 'date' => $date->toString(Zend_Date::ISO_8601)); if ($this->insert($data)) { $returnVal = true; } else { // Failed insertion Application_Core_Logger::log("Can't insert loading in table {$this->_name}", 'error'); $returnVal = false; } return $returnVal; }
/** * This function will add a new note into the cleanupnotes table * * @param int schemeNumber * @param string note * @return boolean */ public function addNote($schemeNumber, $note) { $data = array('AGENTSCHEMENUMBER' => $schemeNumber, 'DATETIME' => new Zend_Db_Expr('NOW()'), 'NOTES' => $note); // Insert the data into a new row in the table if ($this->insert($data)) { return true; } else { // Failed insertion Application_Core_Logger::log("Can't insert note in table {$this->_name} (AGENTSCHEMENUMBER = {$schemeNumber})", 'error'); return false; } }
/** * Fetch options from the database * * @param none * @return array */ public function fetchOptionsByProduct($productName) { $select = $this->select()->from(array('p' => $this->_name))->setIntegrityCheck(false)->join(array('o' => 'productOptions'), 'p.productID = o.productID')->join(array('s' => 'policyOptions'), 'o.policyOptionID = s.policyOptionID')->join(array('r' => 'productRates'), 'o.productOptionsID = r.productOptionsID')->where('p.productID = ?', 1); $rows = $this->fetchAll($select); if (!empty($rows)) { return $rows; } else { // Can't find policy options for this type - log a warning Application_Core_Logger::log("Policy options not found in database (productName = {$productName})", 'warning'); return false; } }
/** * This function will add a new note into the agentNotes table * * @param int schemeNumber * @param string note * @return boolean * */ public function addNote($schemeNumber, $note, $csuid) { $data = array('agentschemeno' => $schemeNumber, 'dateEntered' => new Zend_Db_Expr('NOW()'), 'csuid' => $csuid, 'text' => $note); // Insert the data into a new row in the table if ($this->insert($data)) { return true; } else { // Failed insertion Application_Core_Logger::log("Can't insert note in table {$this->_name} (AGENTSCHEMENUMBER = {$schemeNumber})", 'error'); return false; } }
public function getByKey($key) { $select = $this->select()->where('`key` = ?', $key); $panel = $this->fetchRow($select); if (count($panel) > 0) { return array('id' => $panel->id, 'key' => $panel->key, 'description' => $panel->description, 'content' => $panel->content); } else { // Can't find content for that key - log a warning Application_Core_Logger::log('Panel content not found in database (key = ' . $key . ')', 'warning'); return false; } }
/** * Creates a new record in the rent_recovery_plus_mta table * * @param Model_Insurance_RentRecoveryPlus_RentRecoveryPlusMta $rrpMta * @param int $mtaId * @return bool */ public function create($rrpMta, $mtaId) { $isSuccessful = true; $data = array('mta_id' => $mtaId, 'policynumber' => $rrpMta->getPolicyNumber(), 'claim_info' => $rrpMta->getClaimInfo()); // New quote so just insert if (!$this->insert($data)) { // Failed insertion Application_Core_Logger::log("Can't insert quote in table {$this->_name}", 'error'); $isSuccessful = false; } return $isSuccessful; }
/** * Returns the PropertyLease identifier associated with the Reference identifier passed in. * * @param integer $referenceId * The unique Reference identifier. * * @return mixed * Returns the integer PropertyLease identifier, if found. Else returns null. */ public function getPropertyLeaseId($referenceId) { $select = $this->select(); $select->where('reference_id = ?', $referenceId); $mapRow = $this->fetchRow($select); if (empty($mapRow)) { Application_Core_Logger::log(get_class() . '::' . __FUNCTION__ . ': Unable to find PropertyLeaseMap.'); $returnVal = null; } else { $returnVal = $mapRow->property_lease_id; } return $returnVal; }
/** * Returns a specific product located by its name. * * @param string $name * The product's name. Case insensitive. * * @return mixed * Returns a Model_Referencing_Product encapsulating the product details, * or null if no matching product found. */ public function getByName($name) { $select = $this->select()->from; $select->where('name = ?', $name); $productRow = $this->fetchRow($select); if (empty($productRow)) { Application_Core_Logger::log(get_class() . '::' . __FUNCTION__ . ':Unable to find product.'); $returnVal = null; } else { $returnVal = $this->_createDomainObject($productRow); } return $returnVal; }
/** * Returns the expected (correct) answer for a specified underwriting question. * * @param integer $questionID * Identifies the underwriting question. * * @return mixed * Returns a string corresponding to one of the consts exposed by the * Model_Insurance_Answer class, or null if the question cannot be found * in the datasource. */ public function getExpectedAnswer($questionID) { $select = $this->select(); $select->where('underwritingQuestionID = ?', $questionID); $row = $this->fetchRow($select); if (!empty($row)) { $expectedAnswer = $row->correctAnswer; } else { Application_Core_Logger::log("Can't retrieve underwriting question in table {$this->_name}", 'error'); $expectedAnswer = null; } return $expectedAnswer; }
/** * Finds a set of insurer rates by policy option and policy startdate * * @param int id * @param date $date * @return Array * * @example $commRate[]=$commR->getCommissionRatebyDate(1502469,'2011-01-01'); */ function getCommissionRate($agent, $date) { $select = $this->select()->where("agentschemeno = ?", $agent['agentschemeno'])->where("startdate <= ?", $date)->where("enddate >= ? OR enddate='0000-00-00' ", $date); $row = $this->fetchRow($select); if (count($row) > 0) { $this->_rateArr = array('newbuscommissionrate' => $row->newbuscommissionrate, 'commissionrate' => $row->commissionrate, 'newbuscommissionrate_tc' => $row->newbuscommissionrate_tc, 'commissionrate_tc' => $row->commissionrate_tc); return true; } else { // Can't find content for that key - log a warning Application_Core_Logger::log('Agent Commission Rate not found in database (agentschemeno = ' . $agent['agentschemeno'] . ')', 'warning'); return false; } }
/** * Fetch options from the database * * @param none * @return array */ public function fetchOptions() { $fields = array('policyOption', 'minimumSumInsured', 'policyOptionID'); $select = $this->select(); $select->from($this->_name, $fields); $select->where('optionType = ?', $this->_optionType); $this->_options = $this->fetchAll($select); if (count($this->_options) > 0) { return $this->_options; } else { // Can't find policy options for this type - log a warning Application_Core_Logger::log("Policy options not found in database (optionType = {$this->_optionType})", 'warning'); return false; } }
/** * This function will add a new note into the agentNotes table * * @param int schemeNumber * @param string note * @return boolean * */ public function addEnquiry($enquiryData) { # Zend_Debug::dump($enquiryData); $rsAddress = new Manager_Core_Postcode(); $riskAddress = $rsAddress->getPropertyByID($enquiryData['ins_address'], false); #Zend_Debug::dump($riskAddress);die(); $insertData = array('agentschemeno' => $enquiryData['agentschemeno'], 'title' => $enquiryData['title'], 'first_name' => $enquiryData['first_name'], 'last_name' => $enquiryData['last_name'], 'phone_number' => $enquiryData['phone_number'], 'mobile_number' => $enquiryData['mobile_number'], 'address_id' => $riskAddress['id'], 'houseNumber' => $riskAddress['houseNumber'], 'buildingName' => $riskAddress['buildingName'], 'address1' => $riskAddress['address1'], 'address2' => $riskAddress['address2'], 'address3' => $riskAddress['address3'], 'address4' => $riskAddress['address4'], 'address5' => $riskAddress['address5'], 'postcode' => $riskAddress['postcode'], 'county' => $riskAddress['county'], 'postcode' => $riskAddress['postcode'], 'organisation' => $riskAddress['organisation'], 'department' => $riskAddress['department'], 'additional_information' => $enquiryData['additional_information'], 'isSent' => 0, 'enquiry_type' => $enquiryData['prospector'], 'created' => new Zend_Db_Expr('NOW()')); // Insert the data into a new row in the table if ($this->insert($insertData)) { return true; } else { // Failed insertion Application_Core_Logger::log("Can't insert in table {$this->_name} (AGENTSCHEMENUMBER = {$schemeNumber})", 'error'); return false; } }
/** * Updates a Transaction Support record * * @param Model_Core_TransactionSupport $transactionSupport * @return bool */ public function updateTransactionSupport(Model_Core_TransactionSupport $transactionSupport) { // Firstly we need to see if this already exists $select = $this->select(); $select->where('TransID = ?', $transactionSupport->getTransId()); $row = $this->fetchRow($select); // There should only be a single transaction support with the given id if (count($row) == 1) { $data = array('TransID' => $transactionSupport->getTransId(), 'EnquiryID' => $transactionSupport->getEnquiryId(), 'ProductID' => $transactionSupport->getProductId(), 'AgentTypeID' => $transactionSupport->getAgentTypeId(), 'DealAgentTypeID' => $transactionSupport->getDealAgentTypeId(), 'Guarantor' => $transactionSupport->getGuarantor(), 'Band' => $transactionSupport->getBand(), 'Duration' => $transactionSupport->getDuration(), 'Renewal' => $transactionSupport->getRenewal(), 'RunningAmount' => $transactionSupport->getRunningAmount(), 'Insurance' => $transactionSupport->getInsurance(), 'IPT' => $transactionSupport->getIpt(), 'Income' => $transactionSupport->getIncome(), 'Invoiced' => $transactionSupport->getInvoiced(), 'Transdate' => $transactionSupport->getTransdate(), 'StatusChangeDate' => $transactionSupport->getStatusChangeDate()); $where = $this->_db->quoteInto('TransID = ?', $transactionSupport->getTransId()); $this->update($data, $where); return true; } Application_Core_Logger::log("Can't update transaction support claim in table {$this->_name}", 'error'); return false; }
/** * Updates a transaction record * * @param Model_Core_Transaction $transaction * @return bool */ public function updateTransaction(Model_Core_Transaction $transaction) { // Firstly we need to see if this already exists $select = $this->select(); $select->where('ID = ?', $transaction->getId()); $row = $this->fetchRow($select); // There should only be a single transaction with the given id if (count($row) == 1) { $data = array('PreviousID' => $transaction->getPreviousId(), 'EnquiryID' => $transaction->getEnquiryId(), 'Amount' => $transaction->getAmount(), 'StatusID' => $transaction->getStatusId(), 'InvoiceID' => $transaction->getInvoiceId(), 'CreditNoteID' => $transaction->getCreditNoteId(), 'InsuranceNetAmount' => $transaction->getInsuranceNetAmount(), 'TransactionDate' => $transaction->getTransactionDate()); $where = $this->_db->quoteInto('ID = ?', $transaction->getId()); $this->update($data, $where); return true; } Application_Core_Logger::log("Can't update transaction claim in table {$this->_name}", 'error'); return false; }
public function updateInvoiceEmailStatus($agentSchemeNumber) { try { $update_data = array('emailSent' => 1, 'emailSentAt' => new Zend_Db_Expr('NOW()')); $where = $this->quoteInto('agentSchemeNumber = ?', $agentSchemeNumber); // Insert the data into a new row in the table if ($this->update($update_data, $where)) { return true; } // Failed update Application_Core_Logger::log("Can't update table {$this->_name} (AGENTSCHEMENUMBER = {$agentSchemeNumber})", 'error'); return false; } catch (Exception $e) { throw new Zend_Exception('updateInvoiceEmailStatus - Couldn\'t update...: ' . $e->getMessage()); } }
/** * Retrieves the specified ProductSelection. * * @param integer $referenceId * The unique Reference identifier. * * @return mixed * The ProductSelection details, encapsulated in a Model_Referencing_ProductSelection object, * or null if the ProductSelection cannot be found. */ public function getByReferenceId($referenceId) { $select = $this->select(); $select->where('reference_id = ?', $referenceId); $row = $this->fetchRow($select); if (empty($row)) { Application_Core_Logger::log(get_class() . '::' . __FUNCTION__ . ':Unable to find ProductSelection.'); $returnVal = null; } else { //Populate the details into an Enquiry object. $productSelection = new Model_Referencing_ProductSelection(); $productSelection->referenceId = $referenceId; $productSelection->duration = $row->duration; $returnVal = $productSelection; } return $returnVal; }
/** * Finds a specific tax rate by its type * * @param string $type * @param date $date * @return double * * @example $ipt=$tax->getTaxByType('ipt'); */ function getTaxByType($type, $date = null) { if (is_null($date)) { $date = date("Y-m-d"); } $type = strtoupper($type); // Just to be on the safe side ;-) $select = $this->select()->from($this->_name, array('id', 'rate'))->where('type = ?', $type)->where('start_date <= ?', $date)->where('end_date >= ? OR end_date IS NULL', $date); $row = $this->fetchRow($select); if (count($row) > 0) { return array('id' => $row['id'], 'rate' => round($row['rate'], 3)); } else { // Can't get tax info - log a warning Application_Core_Logger::log("Can't get tax by type from table {$this->_name}", 'warning'); return null; } }
/** * Retrieves a Model_Referencing_CustomerMap object. * * @param integer $referenceId The unique Reference identifier. * @return mixed A Model_Referencing_CustomerMap, or null if none found. */ public function getReferenceCustomer($referenceId) { $select = $this->select(); $select->where('reference_id = ?', $referenceId); $referenceCustomerRow = $this->fetchRow($select); if (empty($referenceCustomerRow)) { Application_Core_Logger::log(get_class() . '::' . __FUNCTION__ . ': Unable to find CustomerMap.'); $returnVal = null; } else { //Populate the details into an CustomerMap object. $referenceCustomer = new Model_Referencing_CustomerMap(); $referenceCustomer->customerType = $referenceCustomerRow->customer_type_id; $referenceCustomer->customerId = $referenceCustomerRow->customer_id; $returnVal = $referenceCustomer; } return $returnVal; }