/**
* получаем историю операция по карте
*
* @param $cardId
* @param $limit
*/
public static function getOperationsHistory($cardId, $params = [])
{
if (empty($cardId)) {
return [];
}
$db = Oracle::init();
$card = Model_Card::getCard($cardId);
$user = Auth::instance()->get_user();
$where = ["card_id = " . Oracle::quote($cardId), "agent_id = " . $user['AGENT_ID']];
if (!empty($card['CONTRACT_ID'])) {
$where[] = "contract_id = " . Oracle::quote($card['CONTRACT_ID']);
}
$sql = "\n\t\t\tselect *\n\t\t\tfrom " . Oracle::$prefix . "V_WEB_CRD_HISTORY\n\t\t\twhere " . implode(" and ", $where) . "\n\t\t\torder by HISTORY_DATE desc\n\t\t";
if (!empty($params['pagination'])) {
return $db->pagination($sql, $params);
}
return $db->query($sql);
}
/**
* грузим данные по карте
*/
public function action_card()
{
$cardId = $this->request->param('id');
$contractId = $this->request->query('contract_id');
$card = Model_Card::getCard($cardId, $contractId);
if (empty($card)) {
$this->html('<div class="error_block">Ошибка</div>');
}
$oilRestrictions = Model_Card::getOilRestrictions($cardId);
$lastFilling = Model_Card::getLastFilling($cardId);
$servicesList = Model_Card::getServicesList($cardId);
$popupCardEdit = Common::popupForm('Редактирование карты', 'card/edit', ['card' => $card, 'oilRestrictions' => $oilRestrictions, 'servicesList' => $servicesList], 'card_edit_' . $cardId);
$html = View::factory('ajax/clients/card')->bind('card', $card)->bind('oilRestrictions', $oilRestrictions)->bind('lastFilling', $lastFilling)->bind('popupCardEdit', $popupCardEdit);
$this->html($html);
}
