/**
* Cutoff Action - change status for clients
*
* @package las
* @version 1.0
*/
public function cutoffAction()
{
$balances = Payments::sum(['conditions' => 'status=' . Payments::SUCCESS, 'column' => 'amount', 'group' => 'client_id']);
foreach ($balances as $balance) {
if ($balance->sumatory < 0) {
$client = Clients::findFirst($balance->client_id);
$tariff = $client->getTariff();
// Change status
$client->status = $balance->sumatory < -$tariff->amount ? Clients::DISCONNECTED : Clients::INDEBTED;
$client->save();
}
}
}
/**
* Edit action - edit the client
*
* @package las
* @version 1.0
*/
public function editAction()
{
// Get id from url params and check if record exist
$params = $this->router->getParams();
if (isset($params[0]) && ($client = Clients::findFirst($params[0]))) {
$tariffs = Tariffs::find(['status=:status:', 'bind' => ['status' => Tariffs::ACTIVE]]);
if (!count($tariffs)) {
$this->flashSession->notice($this->tag->linkTo(['#', 'class' => 'close', 'title' => __("Close"), '×']) . '<strong>' . __('Notice') . '!</strong> ' . __("Please add the tariff first") . ': ' . $this->tag->linkTo('admin/tariffs/add', __('Add')));
}
// Set title, pick view and send variables
$this->tag->setTitle(__('Clients') . ' / ' . __('Edit'));
$this->view->pick('clients/write');
$this->view->setVars(['tariffs' => $tariffs, 'status' => Clients::status(true)]);
// Check if the form has been sent
if ($this->request->isPost() === true && $this->request->hasPost('submit')) {
$client->__set('tariffs', $tariffs);
$valid = $client->write('update');
// Check if data are valid
if ($valid instanceof Clients) {
$this->flashSession->success($this->tag->linkTo(['#', 'class' => 'close', 'title' => __("Close"), '×']) . '<strong>' . __('Success') . '!</strong> ' . __("The data has been saved."));
} else {
$this->view->setVar('errors', $valid);
$this->flashSession->warning($this->tag->linkTo(['#', 'class' => 'close', 'title' => __("Close"), '×']) . '<strong>' . __('Warning') . '!</strong> ' . __("Please correct the errors."));
}
} else {
// Values to fill out the form
$this->tag->setDefaults(['fullName' => $client->fullName, 'address' => $client->address, 'tariff' => $client->tariff_id, 'description' => $client->description, 'status' => $client->status]);
}
} else {
parent::notFoundAction();
}
}
