public function get_add_payid_handler()
{
global $FANNIE_PLUGIN_SETTINGS, $FANNIE_OP_DB, $FANNIE_TRANS_DB, $FANNIE_ROOT;
$ret = array();
$dbc = FannieDB::get($FANNIE_OP_DB);
$model = new CustdataModel($dbc);
$model->CardNo($this->add);
if (count($model->find()) == 0) {
$ret['error'] = 'Mem# ' . $this->add . ' does not exist!';
} else {
$model->personNum(1);
$model->load();
$ret['name'] = $model->LastName() . ', ' . $model->FirstName();
$dbc = FannieDB::get($FANNIE_TRANS_DB);
$model = new ArLiveBalanceModel($dbc);
$model->card_no($this->add);
$balance = 0;
if ($model->load()) {
$balance = $model->balance();
}
$ret['balance'] = $balance;
$dbc = FannieDB::get($FANNIE_PLUGIN_SETTINGS['StaffArPayrollDB']);
$model = new StaffArAccountsModel($dbc);
$model->card_no($this->add);
$model->nextPayment(0);
$model->payrollIdentifier($this->payid);
$model->save();
}
echo json_encode($ret);
return false;
}
function recreate_views($con)
{
$db_name = $this->config->get('TRANS_DB');
$con->query("DROP VIEW ar_history_today", $db_name);
$model = new ArHistoryTodayModel($con);
$model->createIfNeeded($db_name);
$con->query("DROP VIEW ar_history_today_sum", $db_name);
$model = new ArHistoryTodaySumModel($con);
$model->createIfNeeded($db_name);
$con->query("DROP VIEW ar_live_balance", $db_name);
$model = new ArLiveBalanceModel($con);
$model->addExtraDB($this->config->get('OP_DB'));
$model->createIfNeeded($db_name);
$con->query("DROP VIEW stockSumToday", $db_name);
$model = new StockSumTodayModel($con);
$model->createIfNeeded($db_name);
$con->query("DROP VIEW equity_live_balance", $db_name);
$model = new EquityLiveBalanceModel($con);
$model->addExtraDB($this->config->get('OP_DB'));
$model->createIfNeeded($db_name);
}
