/** * 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; }