<?php

/*
 * Catabatic Technology Pvt. Ltd.
 * File Name :SentSms.php
 * File Description :Manage to Sms Operation
 * Created By : Amit Kumar Dubey 
 * Created Date: 13-Sept-2017
 */

class Travel_Model_CRM_SentSms {

    protected $_dbObj;
    public $_crmsentsmsObj;

    public function __construct() {
        $this->_crmsentsmsObj = new Travel_Model_TblCrmSentSms();
        $this->_dbObj = Zend_Db_Table::getDefaultAdapter();
    }

    //query to insert remark data in db created by amit kumar dubey on 13 sept 2017 at 03:59 PM
    public function addSentSms(array $data) {
        //print_r($data);
        $this->_crmsentsmsObj->insert($data);
        $lastID = $this->_dbObj->lastInsertId();
        return $lastID;
    }

    public function UpdateAgencyCustomer(array $data, $where = NULL) {
        return $this->_crmsentsmsObj->update($data, $where);
    }

    public function GetSentSmsDetail($SmsSysId) {
        $select = $this->_dbObj->select();
        $select->from(array('tb1' => "TB_Agency_Sent_Sms"));
        $select->where('tb1.SmsSysId = ?', $SmsSysId);
        $result = $this->_dbObj->fetchAll($select);
        return $result;
    }

    public function GetSentSmsIDByLongUrl($longUrl) {
        $select = $this->_dbObj->select();
        $select->from(array('tb1' => "TB_Agency_Sent_Sms"));
        $select->where('tb1.LongURL = ?', $longUrl);
        $result = $this->_dbObj->fetchRow($select);
        return $result['SmsSysId'];
    }

}