$toolPath = ''; //Page::findPathExtension( $toolName ); require_once $toolPath . $toolName; // get privileges for the current viewer $privManager = new PrivilegeManager($this->viewer->getID()); if ($privManager->isCampusAdmin($this->EVENT_ID, $this->CAMPUS_ID) == true) { /********** NOTE: make sure 60 second PHP timeout is not activated: use filters, such as event_id ************/ $EVENT_ID = 18; // retrieve registration records $regs = new RowManager_RegistrationManager(); $regs->setEventID($EVENT_ID); $regsList = $regs->getListIterator(); $regsArray = $regsList->getDataList(); $priceGetter = new FinancialTools(); reset($regsArray); foreach (array_keys($regsArray) as $k) { $record = current($regsArray); $reg_id = $record['registration_id']; $owed = $priceGetter->simpleCalcBalanceOwing($reg_id); // store calculated balance owing in registration record $singleReg = new RowManager_RegistrationManager($reg_id); $balance = array(); $balance['registration_balance'] = $owed; $singleReg->loadFromArray($balance); $singleReg->updateDBTable(); next($regsArray); } echo "SUCCESS!"; } else { echo "PRIVILEGE LEVEL NOT HIGH ENOUGH..."; }
/** * 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(); } } }