<?php

/*
 * Catabatic Technology Pvt. Ltd.
 * File Name :TblLeadSource.php
 * File Description :Manage to Lead Source Operation
 * Created By : Er Amit Kumar Dubey 
 * Created Date: 7-May-2017
 */

class Travel_Model_TblLeadSource {

    protected $_dbObj;
    public $baseUrl;

    public function __construct() {
        $request = Zend_Controller_Front::getInstance()->getRequest();
        $this->baseUrl = $request->getScheme() . '://' . $request->getHttpHost();
        $this->_dbObj = Zend_Db_Table::getDefaultAdapter();
    }

    //query to insert remark data in db created by amit kumar dubey on 16 august 2016 at 1:09 PM
    public function GetAllSouce($AgencySysId = NULL) {
        $select = $this->_dbObj->select();
        $select->from('TB_Master_LeadSource');
        $select->where("IsActive = ?", 1);
        $select->where("IsMarkForDel = ?", 0);
        (isset($AgencySysId) && !empty($AgencySysId)) ? $select->where("AgencySysId = ?", $AgencySysId) : '';
        $result = $this->_dbObj->fetchAll($select);
        return $result;
    }

    public function GetLeadSourceById($id, $AgencySysId = NULL) {
        $select = $this->_dbObj->select();
        $select->from('TB_Master_LeadSource');
        $select->where("IsActive = ?", 1);
        $select->where("IsMarkForDel = ?", 0);
        $select->where("LeadSourceSysId = ?", $id);
        (isset($AgencySysId) && !empty($AgencySysId)) ? $select->where("AgencySysId = ?", $AgencySysId) : '';
        $result = $this->_dbObj->fetchRow($select);
        return $result;
    }

    public function getLeadStage($AgencySysId, $strLeadSource = NULL) {
        
    }

    public function addAgencyLeadStage($agencyLeadStageData = array()) {
        
    }

    public function updateAgencyLeadStage($agencyLeadStageDataDb = array(), $AgencySysId = NULL) {
        $where = array('AgencySysId =?' => $AgencySysId);
        return $this->_dbObj->update('TB_Master_LeadSource', $agencyLeadStageDataDb, $where);
    }
}