/** * @param string $account * @return null|Account */ public function getAccountByAccount($account) { $sql_array = array('SELECT' => '*', 'FROM' => array('sp_account' => 'a'), 'WHERE' => $this->db->sql_in_set('account', $account), 'ORDER_BY' => 'account_id'); $sql = $this->db->sql_build_query('SELECT', $sql_array); $result = $this->db->sql_query_limit($sql, 1); $row = $this->db->sql_fetchrow(); $this->db->sql_freeresult($result); return $row ? Account::load($row) : null; }
/** * @return array * @throws Exception */ private function pay() { $this->checkAccount(); $this->checkExternalPayment(); $created = new \DateTime(); $data = []; $data['ext_payment_system_id'] = $this->paymentSystem->getID(); $data['total'] = $this->payAmount; $data['external_id'] = $this->payID; $data['external_date'] = $this->payDate; $data['created'] = $created->format('U'); $externalPayment = $this->db->createExternalPayment($data); $response['account'] = $this->account->getAccount(); $response['reg_id'] = $externalPayment->getID(); $response['reg_date'] = $created->format('Y-m-dTH:i:s'); return $response; }