<?php

/*
 * Catabatic Technology Pvt. Ltd.
 * File Name :TblCRMCustomer.php
 * File Description :Manage to Supplier Operation
 * Created By : Amit Kumar Dubey 
 * Created Date: 02-Nov-2016
 */

class Travel_Model_CRM_TravelPlanStatus {

    protected $_dbObj;
    protected $_crmtravelplanstatusObj;

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

    public function GetTravelPlanStatus() {
        $select = $this->_dbObj->select();
        $select->from('TB_Master_TravelPlan_Status');
        //$select->where("IsActive = ?", 1);
        $select->where("IsActive = ?", 1);
        $select->order('TPStatusSysId desc');
        $result = $this->_dbObj->fetchAll($select);
        return $result;
    }

    public function GetTravelPlanStatusByType($type, $TPStatusSysId = NULL) {
        $select = $this->_dbObj->select();
        $select->from('TB_Master_TravelPlan_Status');
        //$select->where("IsActive = ?", 1);
        $select->where("IsActive = ?", 1);
        $select->where("Type = ?", $type);
        if (isset($TPStatusSysId) && !empty($TPStatusSysId)) {
            $select->where("TPStatusSysId = ?", $TPStatusSysId);
        }
        $select->order('Seq ASC');
        $result = $this->_dbObj->fetchAll($select);
        return $result;
    }

    public function GetTravelPlanStatusByTypeName($type, $TPStatusSysId) {
        $select = $this->_dbObj->select();
        $select->from('TB_Master_TravelPlan_Status');
        //$select->where("IsActive = ?", 1);
        $select->where("IsActive = ?", 1);
        if (!empty($type)) {
            $select->where("Type = ?", $type);
        }
        if (!empty($TPStatusSysId)) {
            $select->where("TPStatusSysId = ?", $TPStatusSysId);
        }
        $select->order('Seq ASC');

        if (empty($TPStatusSysId)) {
            $result = $this->_dbObj->fetchAll($select);
            return $result;
        } else {
            $result = $this->_dbObj->fetchRow($select);
            return $result['TPStatus'];
        }
    }
    public function GetTravelPlanStatusForQuerySearchArray($type, $StageType, $TPStatusSysId) {
        $select = $this->_dbObj->select();
        $select->from('TB_Master_TravelPlan_Status');
        $select->where("IsActive = ?", 1);
        $select->where("StageType = ?", $StageType);
        if (!empty($type)) {
            $select->where("Type = ?", $type);
        }
        if (!empty($TPStatusSysId)) {
            $select->where("TPStatusSysId = ?", $TPStatusSysId);
        }
        $select->order('Seq ASC');
        $result = $this->_dbObj->fetchAll($select);
        $response = array();
        if (empty($TPStatusSysId)) {
            for ($i = 0; $i < count($result); $i++) {
                $response[$result[$i]['TPStatusSysId']] = $result[$i];
            }
        } else {
            $response = $result;
        }
        return $response;
    }
    public function GetTravelPlanStatusArray($type, $TPStatusSysId) {
        $select = $this->_dbObj->select();
        $select->from('TB_Master_TravelPlan_Status');
        //$select->where("IsActive = ?", 1);
        $select->where("IsActive = ?", 1);
        if (!empty($type)) {
            $select->where("Type = ?", $type);
        }
        if (!empty($TPStatusSysId)) {
            $select->where("TPStatusSysId = ?", $TPStatusSysId);
        }
        $select->order('Seq ASC');
        $result = $this->_dbObj->fetchAll($select);
        $response = array();
        if (empty($TPStatusSysId)) {
            for ($i = 0; $i < count($result); $i++) {
                $response[$result[$i]['TPStatusSysId']] = $result[$i];
            }
        } else {
            $response = $result;
        }
        return $response;
    }

}