/** * Zwraca odpowiedzi sms * * @param string $clientHash identyfikator klienta * @param string $serviceHash identyfikator uslugi * @throws SoapFault * @return object */ public function getSmsResponse($clientHash = null, $serviceHash = null) { try { $model = new SmsReceivied(); $adapter = $model->getAdapter(); $adapter->beginTransaction(); $where = "data_pobrania is null and service_hash ='{$serviceHash}' "; $select = $model->select(); $select->setIntegrityCheck(false)->from(array('r' => 'sms.receivied'))->joinLeft(array('s' => 'ws.ws_service'), 's.id = r.ws_service_id', array('service_name'))->where($where); $this->data = $select->query()->fetchAll(); $where = "data_pobrania is null and ws_service_id =(select id from ws_service where service_hash ='{$serviceHash}') "; $data_pobrania = array('data_pobrania' => date("Y-m-d h:i:s")); $update = $model->update($data_pobrania, $where); $adapter->commit(); // var_dump($data); return $this->data; } catch (Logic_WebService_Exception $e) { return $this->_faultHandler($e); } catch (Logic_Service_Exception $e) { return $this->_faultHandler($e); } }