/** * function updateDBTable * <pre> * Updates the DB table info. * </pre> * @return [void] */ function updateDBTable($isDebug = false) { $status = parent::updateDBTable($isDebug); if ($status == true) { $values = $this->getArrayOfValues(); // echo "<pre>".print_r($values,true)."</pre>"; if (isset($values['reg_id'])) { // update balance owing column in cim_reg_registration table $singleReg = new RowManager_RegistrationManager($values['reg_id']); // $singleReg_list = $singleReg->getListIterator(); // $singleReg_array = $singleReg_list->getDataList(); // // reset($singleReg_array); // $record = current($singleReg_array); // $oldBalance = $record['registration_balance']; $balanceGetter = new FinancialTools(); $balance = array(); // $balance['registration_balance'] = $oldBalance - $record['cctransaction_amount']; $balance['registration_balance'] = $balanceGetter->simpleCalcBalanceOwing($values['reg_id']); $singleReg->loadFromArray($balance); $singleReg->updateDBTable(); } } }
/** * function updateDBTable * <pre> * Updates the DB table info. * </pre> * @return [void] */ function updateDBTable() { // make sure label is translated into UnicodeEntities $data = $this->getLabel(); $newData = Unicode_utf8ToUnicodeEntities($data); $this->setLabel($newData); parent::updateDBTable(); // Go Through and remove any existing xlation requests for this // label entry. $currentPageID = $this->getPageID(); $currentKey = $this->getKey(); $currentLanguageID = $this->getLanguageID(); $xlationManager = new RowManager_XLationManager(); // for each label with matching PageID & Key $labelManager = new RowManager_MultilingualLabelManager(); $labelManager->setPageID($currentPageID); $labelManager->setKey($currentKey); $labelList = $labelManager->getListIterator(); $labelList->setFirst(); while ($label = $labelList->getNext()) { // delete any xlation entry with current language_id & // matching label_id if ($xlationManager->loadByLabelAndLanguage($label->getID(), $currentLanguageID)) { $xlationManager->deleteEntry(); } } // next label }