<?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_Supplier {
    protected $_dbObj;
    protected $_crmsupplierObj;

    public function __construct() {
		$this->_crmsupplierObj = new Travel_Model_TblICSupplier();
		$this->_dbObj = Zend_Db_Table::getDefaultAdapter();
    }
	public function GetSupplierDetailsByIds($supplierId){
		$select = $this->_dbObj->select();
		$select->from('TB_IC_Supplier');
		//$select->where("IsActive = ?", 1);
		$select->where("SupplierSysId IN (?)", $supplierId);
		$select->order('SupplierSysId desc');
		$result = $this->_dbObj->fetchAll($select);
        return $result;
	}
	public function GetSupplierTypeByIds($supplierTypeId){
		$select = $this->_dbObj->select();
		$select->from('TB_Master_SupplierType');
		//$select->where("IsActive = ?", 1);
		$select->where("SupplierTypeSysId IN (".$supplierTypeId.")");
		$select->order('SupplierTypeSysId desc');
		$result = $this->_dbObj->fetchAll($select);
        return $result;
	}
}