/** * получаем историю операция по карте * * @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); }