$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();
}
}
}
