<?php

class Table_InvtList
{
    protected $_table = null;

    public function __construct() {
        $this->_table = new DbTable_InvtList();
    }

    public function getAdapter() {
        return $this->_table->getAdapter();
    }

    public static function getInstance() {
        return new Table_InvtList();
    }

    /**
     * @param $row
     * @return mixed
     */
    public function add($row) {
        return $this->_table->insert($row);
    }


    /**
     * @param $row
     * @param $value
     * @param string $field
     * @return mixed
     */
    public function update($row, $value, $field = "il_id") {
        $where = $this->_table->getAdapter()->quoteInto("{$field}= ?", $value);
        return $this->_table->update($row, $where);
    }

    /**
     * @param $value
     * @param string $field
     * @return mixed
     */
    public function delete($value, $field = "il_id") {
        $where = $this->_table->getAdapter()->quoteInto("{$field}= ?", $value);
        return $this->_table->delete($where);
    }

    /**
     * @param $value
     * @param string $field
     * @param string $colums
     * @return mixed
     */
    public function getByField($value, $field = 'il_id', $colums = "*") {
        $select = $this->_table->getAdapter()->select();
        $table = $this->_table->info('name');
        $select->from($table, $colums);
        $select->where("{$field} = ?", $value);
        return $this->_table->getAdapter()->fetchRow($select);
    }

    public function getForLock($value, $field = 'il_id', $colums = "*") {
        $select = $this->_table->getAdapter()->select();
        $table = $this->_table->info('name');
        $select->from($table, $colums);
        $select->where("{$field} = ?", $value);
        $select->forUpdate();
        return $this->_table->getAdapter()->fetchRow($select);
    }

    public function getAll() {
        $select = $this->_table->getAdapter()->select();
        $table = $this->_table->info('name');
        $select->from($table, "*");
        return $this->_table->getAdapter()->fetchAll($select);
    }

    /**
     * @param array $condition
     * @param string $type
     * @param int $pageSize
     * @param int $page
     * @param string $orderBy
     * @return array|string
     */
    public function getByCondition($condition = array(), $type = '*', $pageSize = 0, $page = 1, $orderBy = "") {
        $select = $this->_table->getAdapter()->select();
        $table = $this->_table->info('name');
        $select->from($table, $type);
        $select->where("1 =?", 1);
        /*CONDITION_START*/
        if (isset($condition["il_id"]) && $condition["il_id"] != "") {
            $select->where("il_id = ?", $condition["il_id"]);
        }
        if (isset($condition["BondInvtNo"]) && $condition["BondInvtNo"] != "") {
            $select->where("BondInvtNo = ?", $condition["BondInvtNo"]);
        }
        if (isset($condition["SeqNo"]) && $condition["SeqNo"] != "") {
            $select->where("SeqNo = ?", $condition["SeqNo"]);
        }
        if (isset($condition["PutrecNo"]) && $condition["PutrecNo"] != "") {
            $select->where("PutrecNo = ?", $condition["PutrecNo"]);
        }
        if (isset($condition["PutrecNo_in"]) && $condition["PutrecNo_in"] != "") {
            $select->where("PutrecNo in(?)", $condition["PutrecNo_in"]);
        }
        if (isset($condition["EtpsInnerInvtNo"]) && $condition["EtpsInnerInvtNo"] != "") {
            $select->where("EtpsInnerInvtNo = ?", $condition["EtpsInnerInvtNo"]);
        }
        if (isset($condition["BizopEtpsSccd"]) && $condition["BizopEtpsSccd"] != "") {
            $select->where("BizopEtpsSccd = ?", $condition["BizopEtpsSccd"]);
        }
        if (isset($condition["BizopEtpsno"]) && $condition["BizopEtpsno"] != "") {
            $select->where("BizopEtpsno = ?", $condition["BizopEtpsno"]);
        }
        if (isset($condition["BizopEtpsNm"]) && $condition["BizopEtpsNm"] != "") {
            $select->where("BizopEtpsNm = ?", $condition["BizopEtpsNm"]);
        }
        if (isset($condition["RcvgdEtpsno"]) && $condition["RcvgdEtpsno"] != "") {
            $select->where("RcvgdEtpsno = ?", $condition["RcvgdEtpsno"]);
        }
        if (isset($condition["RvsngdEtpsSccd"]) && $condition["RvsngdEtpsSccd"] != "") {
            $select->where("RvsngdEtpsSccd = ?", $condition["RvsngdEtpsSccd"]);
        }
        if (isset($condition["RcvgdEtpsNm"]) && $condition["RcvgdEtpsNm"] != "") {
            $select->where("RcvgdEtpsNm = ?", $condition["RcvgdEtpsNm"]);
        }
        if (isset($condition["DclEtpsSccd"]) && $condition["DclEtpsSccd"] != "") {
            $select->where("DclEtpsSccd = ?", $condition["DclEtpsSccd"]);
        }
        if (isset($condition["DclEtpsno"]) && $condition["DclEtpsno"] != "") {
            $select->where("DclEtpsno = ?", $condition["DclEtpsno"]);
        }
        if (isset($condition["DclEtpsNm"]) && $condition["DclEtpsNm"] != "") {
            $select->where("DclEtpsNm = ?", $condition["DclEtpsNm"]);
        }
        if (isset($condition["InvtDclTime"]) && $condition["InvtDclTime"] != "") {
            $select->where("InvtDclTime = ?", $condition["InvtDclTime"]);
        }
        if (isset($condition["EntryDclTime"]) && $condition["EntryDclTime"] != "") {
            $select->where("EntryDclTime = ?", $condition["EntryDclTime"]);
        }
        if (isset($condition["EntryNo"]) && $condition["EntryNo"] != "") {
            $select->where("EntryNo = ?", $condition["EntryNo"]);
        }
        if (isset($condition["RltInvtNo"]) && $condition["RltInvtNo"] != "") {
            $select->where("RltInvtNo = ?", $condition["RltInvtNo"]);
        }
        if (isset($condition["RltPutrecNo"]) && $condition["RltPutrecNo"] != "") {
            $select->where("RltPutrecNo = ?", $condition["RltPutrecNo"]);
        }
        if (isset($condition["RltEntryNo"]) && $condition["RltEntryNo"] != "") {
            $select->where("RltEntryNo = ?", $condition["RltEntryNo"]);
        }
        if (isset($condition["RltEntryBizopEtpsSccd"]) && $condition["RltEntryBizopEtpsSccd"] != "") {
            $select->where("RltEntryBizopEtpsSccd = ?", $condition["RltEntryBizopEtpsSccd"]);
        }
        if (isset($condition["RltEntryBizopEtpsno"]) && $condition["RltEntryBizopEtpsno"] != "") {
            $select->where("RltEntryBizopEtpsno = ?", $condition["RltEntryBizopEtpsno"]);
        }
        if (isset($condition["RltEntryBizopEtpsNm"]) && $condition["RltEntryBizopEtpsNm"] != "") {
            $select->where("RltEntryBizopEtpsNm = ?", $condition["RltEntryBizopEtpsNm"]);
        }
        if (isset($condition["RltEntryRvsngdEtpsSccd"]) && $condition["RltEntryRvsngdEtpsSccd"] != "") {
            $select->where("RltEntryRvsngdEtpsSccd = ?", $condition["RltEntryRvsngdEtpsSccd"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsno"]) && $condition["RltEntryRcvgdEtpsno"] != "") {
            $select->where("RltEntryRcvgdEtpsno = ?", $condition["RltEntryRcvgdEtpsno"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsNm"]) && $condition["RltEntryRcvgdEtpsNm"] != "") {
            $select->where("RltEntryRcvgdEtpsNm = ?", $condition["RltEntryRcvgdEtpsNm"]);
        }
        if (isset($condition["RltEntryDclEtpsSccd"]) && $condition["RltEntryDclEtpsSccd"] != "") {
            $select->where("RltEntryDclEtpsSccd = ?", $condition["RltEntryDclEtpsSccd"]);
        }
        if (isset($condition["RltEntryDclEtpsno"]) && $condition["RltEntryDclEtpsno"] != "") {
            $select->where("RltEntryDclEtpsno = ?", $condition["RltEntryDclEtpsno"]);
        }
        if (isset($condition["RltEntryDclEtpsNm"]) && $condition["RltEntryDclEtpsNm"] != "") {
            $select->where("RltEntryDclEtpsNm = ?", $condition["RltEntryDclEtpsNm"]);
        }
        if (isset($condition["ImpexpPortcd"]) && $condition["ImpexpPortcd"] != "") {
            $select->where("ImpexpPortcd = ?", $condition["ImpexpPortcd"]);
        }
        if (isset($condition["DclPlcCuscd"]) && $condition["DclPlcCuscd"] != "") {
            $select->where("DclPlcCuscd = ?", $condition["DclPlcCuscd"]);
        }
        if (isset($condition["ImpexpMarkcd"]) && $condition["ImpexpMarkcd"] != "") {
            $select->where("ImpexpMarkcd = ?", $condition["ImpexpMarkcd"]);
        }
        if (isset($condition["MtpckEndprdMarkcd"]) && $condition["MtpckEndprdMarkcd"] != "") {
            $select->where("MtpckEndprdMarkcd = ?", $condition["MtpckEndprdMarkcd"]);
        }
        if (isset($condition["SupvModecd"]) && $condition["SupvModecd"] != "") {
            $select->where("SupvModecd = ?", $condition["SupvModecd"]);
        }
        if (isset($condition["TrspModecd"]) && $condition["TrspModecd"] != "") {
            $select->where("TrspModecd = ?", $condition["TrspModecd"]);
        }
        if (isset($condition["DclcusFlag"]) && $condition["DclcusFlag"] != "") {
            $select->where("DclcusFlag = ?", $condition["DclcusFlag"]);
        }
        if (isset($condition["DclcusTypecd"]) && $condition["DclcusTypecd"] != "") {
            $select->where("DclcusTypecd = ?", $condition["DclcusTypecd"]);
        }
        if (isset($condition["VrfdedMarkcd"]) && $condition["VrfdedMarkcd"] != "") {
            $select->where("VrfdedMarkcd = ?", $condition["VrfdedMarkcd"]);
        }
        if (isset($condition["InvtIochkptStucd"]) && $condition["InvtIochkptStucd"] != "") {
            $select->where("InvtIochkptStucd = ?", $condition["InvtIochkptStucd"]);
        }
        if (isset($condition["PrevdTime"]) && $condition["PrevdTime"] != "") {
            $select->where("PrevdTime = ?", $condition["PrevdTime"]);
        }
        if (isset($condition["FormalVrfdedTime"]) && $condition["FormalVrfdedTime"] != "") {
            $select->where("FormalVrfdedTime = ?", $condition["FormalVrfdedTime"]);
        }
        if (isset($condition["ApplyNo"]) && $condition["ApplyNo"] != "") {
            $select->where("ApplyNo = ?", $condition["ApplyNo"]);
        }
        if (isset($condition["ListType"]) && $condition["ListType"] != "") {
            $select->where("ListType = ?", $condition["ListType"]);
        }
        if (isset($condition["InputCode"]) && $condition["InputCode"] != "") {
            $select->where("InputCode = ?", $condition["InputCode"]);
        }
        if (isset($condition["InputCreditCode"]) && $condition["InputCreditCode"] != "") {
            $select->where("InputCreditCode = ?", $condition["InputCreditCode"]);
        }
        if (isset($condition["InputName"]) && $condition["InputName"] != "") {
            $select->where("InputName = ?", $condition["InputName"]);
        }
        if (isset($condition["IcCardNo"]) && $condition["IcCardNo"] != "") {
            $select->where("IcCardNo = ?", $condition["IcCardNo"]);
        }
        if (isset($condition["InputTime"]) && $condition["InputTime"] != "") {
            $select->where("InputTime = ?", $condition["InputTime"]);
        }
        if (isset($condition["ListStat"]) && $condition["ListStat"] != "") {
            $select->where("ListStat = ?", $condition["ListStat"]);
        }
        if (isset($condition["CorrEntryDclEtpsSccd"]) && $condition["CorrEntryDclEtpsSccd"] != "") {
            $select->where("CorrEntryDclEtpsSccd = ?", $condition["CorrEntryDclEtpsSccd"]);
        }
        if (isset($condition["CorrEntryDclEtpsNo"]) && $condition["CorrEntryDclEtpsNo"] != "") {
            $select->where("CorrEntryDclEtpsNo = ?", $condition["CorrEntryDclEtpsNo"]);
        }
        if (isset($condition["CorrEntryDclEtpsNm"]) && $condition["CorrEntryDclEtpsNm"] != "") {
            $select->where("CorrEntryDclEtpsNm = ?", $condition["CorrEntryDclEtpsNm"]);
        }
        if (isset($condition["DecType"]) && $condition["DecType"] != "") {
            $select->where("DecType = ?", $condition["DecType"]);
        }
        if (isset($condition["StshipTrsarvNatcd"]) && $condition["StshipTrsarvNatcd"] != "") {
            $select->where("StshipTrsarvNatcd = ?", $condition["StshipTrsarvNatcd"]);
        }
        if (isset($condition["InvtType"]) && $condition["InvtType"] != "") {
            $select->where("InvtType = ?", $condition["InvtType"]);
        }
        if (isset($condition["EntryStucd"]) && $condition["EntryStucd"] != "") {
            $select->where("EntryStucd = ?", $condition["EntryStucd"]);
        }
        if (isset($condition["PassportUsedTypeCd"]) && $condition["PassportUsedTypeCd"] != "") {
            $select->where("PassportUsedTypeCd = ?", $condition["PassportUsedTypeCd"]);
        }
        if (isset($condition["Rmk"]) && $condition["Rmk"] != "") {
            $select->where("Rmk = ?", $condition["Rmk"]);
        }
        if (isset($condition["DclTypecd"]) && $condition["DclTypecd"] != "") {
            $select->where("DclTypecd = ?", $condition["DclTypecd"]);
        }
        if (isset($condition["NeedEntryModified"]) && $condition["NeedEntryModified"] != "") {
            $select->where("NeedEntryModified = ?", $condition["NeedEntryModified"]);
        }
        if (isset($condition["LevyBlAmt"]) && $condition["LevyBlAmt"] != "") {
            $select->where("LevyBlAmt = ?", $condition["LevyBlAmt"]);
        }
        if (isset($condition["ChgTmsCnt"]) && $condition["ChgTmsCnt"] != "") {
            $select->where("ChgTmsCnt = ?", $condition["ChgTmsCnt"]);
        }
        if (isset($condition["GenDecFlag"]) && $condition["GenDecFlag"] != "") {
            $select->where("GenDecFlag = ?", $condition["GenDecFlag"]);
        }
        if (isset($condition["add_time"]) && $condition["add_time"] != "") {
            $select->where("add_time = ?", $condition["add_time"]);
        }
        if (isset($condition["status"]) && $condition["status"] != "") {
            $select->where("status = ?", $condition["status"]);
        }
        if (isset($condition["il_id"]) && $condition["il_id"] != "") {
            $select->where("il_id = ?", $condition["il_id"]);
        }
        if (isset($condition["BondInvtNo"]) && $condition["BondInvtNo"] != "") {
            $select->where("BondInvtNo = ?", $condition["BondInvtNo"]);
        }
        if (isset($condition["SeqNo"]) && $condition["SeqNo"] != "") {
            $select->where("SeqNo = ?", $condition["SeqNo"]);
        }
        if (isset($condition["PutrecNo"]) && $condition["PutrecNo"] != "") {
            $select->where("PutrecNo = ?", $condition["PutrecNo"]);
        }
        if (isset($condition["EtpsInnerInvtNo"]) && $condition["EtpsInnerInvtNo"] != "") {
            $select->where("EtpsInnerInvtNo = ?", $condition["EtpsInnerInvtNo"]);
        }
        if (isset($condition["BizopEtpsSccd"]) && $condition["BizopEtpsSccd"] != "") {
            $select->where("BizopEtpsSccd = ?", $condition["BizopEtpsSccd"]);
        }
        if (isset($condition["BizopEtpsno"]) && $condition["BizopEtpsno"] != "") {
            $select->where("BizopEtpsno = ?", $condition["BizopEtpsno"]);
        }
        if (isset($condition["BizopEtpsNm"]) && $condition["BizopEtpsNm"] != "") {
            $select->where("BizopEtpsNm = ?", $condition["BizopEtpsNm"]);
        }
        if (isset($condition["RcvgdEtpsno"]) && $condition["RcvgdEtpsno"] != "") {
            $select->where("RcvgdEtpsno = ?", $condition["RcvgdEtpsno"]);
        }
        if (isset($condition["RvsngdEtpsSccd"]) && $condition["RvsngdEtpsSccd"] != "") {
            $select->where("RvsngdEtpsSccd = ?", $condition["RvsngdEtpsSccd"]);
        }
        if (isset($condition["RcvgdEtpsNm"]) && $condition["RcvgdEtpsNm"] != "") {
            $select->where("RcvgdEtpsNm = ?", $condition["RcvgdEtpsNm"]);
        }
        if (isset($condition["DclEtpsSccd"]) && $condition["DclEtpsSccd"] != "") {
            $select->where("DclEtpsSccd = ?", $condition["DclEtpsSccd"]);
        }
        if (isset($condition["DclEtpsno"]) && $condition["DclEtpsno"] != "") {
            $select->where("DclEtpsno = ?", $condition["DclEtpsno"]);
        }
        if (isset($condition["DclEtpsNm"]) && $condition["DclEtpsNm"] != "") {
            $select->where("DclEtpsNm = ?", $condition["DclEtpsNm"]);
        }
        if (isset($condition["InvtDclTime"]) && $condition["InvtDclTime"] != "") {
            $select->where("InvtDclTime = ?", $condition["InvtDclTime"]);
        }
        if (isset($condition["EntryDclTime"]) && $condition["EntryDclTime"] != "") {
            $select->where("EntryDclTime = ?", $condition["EntryDclTime"]);
        }
        if (isset($condition["EntryNo"]) && $condition["EntryNo"] != "") {
            $select->where("EntryNo = ?", $condition["EntryNo"]);
        }
        if (isset($condition["RltInvtNo"]) && $condition["RltInvtNo"] != "") {
            $select->where("RltInvtNo = ?", $condition["RltInvtNo"]);
        }
        if (isset($condition["RltPutrecNo"]) && $condition["RltPutrecNo"] != "") {
            $select->where("RltPutrecNo = ?", $condition["RltPutrecNo"]);
        }
        if (isset($condition["RltEntryNo"]) && $condition["RltEntryNo"] != "") {
            $select->where("RltEntryNo = ?", $condition["RltEntryNo"]);
        }
        if (isset($condition["RltEntryBizopEtpsSccd"]) && $condition["RltEntryBizopEtpsSccd"] != "") {
            $select->where("RltEntryBizopEtpsSccd = ?", $condition["RltEntryBizopEtpsSccd"]);
        }
        if (isset($condition["RltEntryBizopEtpsno"]) && $condition["RltEntryBizopEtpsno"] != "") {
            $select->where("RltEntryBizopEtpsno = ?", $condition["RltEntryBizopEtpsno"]);
        }
        if (isset($condition["RltEntryBizopEtpsNm"]) && $condition["RltEntryBizopEtpsNm"] != "") {
            $select->where("RltEntryBizopEtpsNm = ?", $condition["RltEntryBizopEtpsNm"]);
        }
        if (isset($condition["RltEntryRvsngdEtpsSccd"]) && $condition["RltEntryRvsngdEtpsSccd"] != "") {
            $select->where("RltEntryRvsngdEtpsSccd = ?", $condition["RltEntryRvsngdEtpsSccd"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsno"]) && $condition["RltEntryRcvgdEtpsno"] != "") {
            $select->where("RltEntryRcvgdEtpsno = ?", $condition["RltEntryRcvgdEtpsno"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsNm"]) && $condition["RltEntryRcvgdEtpsNm"] != "") {
            $select->where("RltEntryRcvgdEtpsNm = ?", $condition["RltEntryRcvgdEtpsNm"]);
        }
        if (isset($condition["RltEntryDclEtpsSccd"]) && $condition["RltEntryDclEtpsSccd"] != "") {
            $select->where("RltEntryDclEtpsSccd = ?", $condition["RltEntryDclEtpsSccd"]);
        }
        if (isset($condition["RltEntryDclEtpsno"]) && $condition["RltEntryDclEtpsno"] != "") {
            $select->where("RltEntryDclEtpsno = ?", $condition["RltEntryDclEtpsno"]);
        }
        if (isset($condition["RltEntryDclEtpsNm"]) && $condition["RltEntryDclEtpsNm"] != "") {
            $select->where("RltEntryDclEtpsNm = ?", $condition["RltEntryDclEtpsNm"]);
        }
        if (isset($condition["ImpexpPortcd"]) && $condition["ImpexpPortcd"] != "") {
            $select->where("ImpexpPortcd = ?", $condition["ImpexpPortcd"]);
        }
        if (isset($condition["DclPlcCuscd"]) && $condition["DclPlcCuscd"] != "") {
            $select->where("DclPlcCuscd = ?", $condition["DclPlcCuscd"]);
        }
        if (isset($condition["ImpexpMarkcd"]) && $condition["ImpexpMarkcd"] != "") {
            $select->where("ImpexpMarkcd = ?", $condition["ImpexpMarkcd"]);
        }
        if (isset($condition["MtpckEndprdMarkcd"]) && $condition["MtpckEndprdMarkcd"] != "") {
            $select->where("MtpckEndprdMarkcd = ?", $condition["MtpckEndprdMarkcd"]);
        }
        if (isset($condition["SupvModecd"]) && $condition["SupvModecd"] != "") {
            $select->where("SupvModecd = ?", $condition["SupvModecd"]);
        }
        if (isset($condition["TrspModecd"]) && $condition["TrspModecd"] != "") {
            $select->where("TrspModecd = ?", $condition["TrspModecd"]);
        }
        if (isset($condition["DclcusFlag"]) && $condition["DclcusFlag"] != "") {
            $select->where("DclcusFlag = ?", $condition["DclcusFlag"]);
        }
        if (isset($condition["DclcusTypecd"]) && $condition["DclcusTypecd"] != "") {
            $select->where("DclcusTypecd = ?", $condition["DclcusTypecd"]);
        }
        if (isset($condition["VrfdedMarkcd"]) && $condition["VrfdedMarkcd"] != "") {
            $select->where("VrfdedMarkcd = ?", $condition["VrfdedMarkcd"]);
        }
        if (isset($condition["InvtIochkptStucd"]) && $condition["InvtIochkptStucd"] != "") {
            $select->where("InvtIochkptStucd = ?", $condition["InvtIochkptStucd"]);
        }
        if (isset($condition["PrevdTime"]) && $condition["PrevdTime"] != "") {
            $select->where("PrevdTime = ?", $condition["PrevdTime"]);
        }
        if (isset($condition["FormalVrfdedTime"]) && $condition["FormalVrfdedTime"] != "") {
            $select->where("FormalVrfdedTime = ?", $condition["FormalVrfdedTime"]);
        }
        if (isset($condition["ApplyNo"]) && $condition["ApplyNo"] != "") {
            $select->where("ApplyNo = ?", $condition["ApplyNo"]);
        }
        if (isset($condition["ListType"]) && $condition["ListType"] != "") {
            $select->where("ListType = ?", $condition["ListType"]);
        }
        if (isset($condition["InputCode"]) && $condition["InputCode"] != "") {
            $select->where("InputCode = ?", $condition["InputCode"]);
        }
        if (isset($condition["InputCreditCode"]) && $condition["InputCreditCode"] != "") {
            $select->where("InputCreditCode = ?", $condition["InputCreditCode"]);
        }
        if (isset($condition["InputName"]) && $condition["InputName"] != "") {
            $select->where("InputName = ?", $condition["InputName"]);
        }
        if (isset($condition["IcCardNo"]) && $condition["IcCardNo"] != "") {
            $select->where("IcCardNo = ?", $condition["IcCardNo"]);
        }
        if (isset($condition["ListStat"]) && $condition["ListStat"] != "") {
            $select->where("ListStat = ?", $condition["ListStat"]);
        }
        if (isset($condition["CorrEntryDclEtpsSccd"]) && $condition["CorrEntryDclEtpsSccd"] != "") {
            $select->where("CorrEntryDclEtpsSccd = ?", $condition["CorrEntryDclEtpsSccd"]);
        }
        if (isset($condition["CorrEntryDclEtpsNo"]) && $condition["CorrEntryDclEtpsNo"] != "") {
            $select->where("CorrEntryDclEtpsNo = ?", $condition["CorrEntryDclEtpsNo"]);
        }
        if (isset($condition["CorrEntryDclEtpsNm"]) && $condition["CorrEntryDclEtpsNm"] != "") {
            $select->where("CorrEntryDclEtpsNm = ?", $condition["CorrEntryDclEtpsNm"]);
        }
        if (isset($condition["DecType"]) && $condition["DecType"] != "") {
            $select->where("DecType = ?", $condition["DecType"]);
        }
        if (isset($condition["StshipTrsarvNatcd"]) && $condition["StshipTrsarvNatcd"] != "") {
            $select->where("StshipTrsarvNatcd = ?", $condition["StshipTrsarvNatcd"]);
        }
        if (isset($condition["InvtType"]) && $condition["InvtType"] != "") {
            $select->where("InvtType = ?", $condition["InvtType"]);
        }
        if (isset($condition["EntryStucd"]) && $condition["EntryStucd"] != "") {
            $select->where("EntryStucd = ?", $condition["EntryStucd"]);
        }
        if (isset($condition["PassportUsedTypeCd"]) && $condition["PassportUsedTypeCd"] != "") {
            $select->where("PassportUsedTypeCd = ?", $condition["PassportUsedTypeCd"]);
        }
        if (isset($condition["DclTypecd"]) && $condition["DclTypecd"] != "") {
            $select->where("DclTypecd = ?", $condition["DclTypecd"]);
        }
        if (isset($condition["NeedEntryModified"]) && $condition["NeedEntryModified"] != "") {
            $select->where("NeedEntryModified = ?", $condition["NeedEntryModified"]);
        }
        if (isset($condition["LevyBlAmt"]) && $condition["LevyBlAmt"] != "") {
            $select->where("LevyBlAmt = ?", $condition["LevyBlAmt"]);
        }
        if (isset($condition["ChgTmsCnt"]) && $condition["ChgTmsCnt"] != "") {
            $select->where("ChgTmsCnt = ?", $condition["ChgTmsCnt"]);
        }
        if (isset($condition["GenDecFlag"]) && $condition["GenDecFlag"] != "") {
            $select->where("GenDecFlag = ?", $condition["GenDecFlag"]);
        }
        if (isset($condition["dateFor"]) && $condition["dateFor"] != "") {
            $select->where("add_time >= ?", date("Y-m-d H:i:s",strtotime($condition["dateFor"])));
        }
        if (isset($condition["dateTo"]) && $condition["dateTo"] != "") {
            $select->where("add_time <= ?", date("Y-m-d H:i:s",strtotime($condition["dateTo"])));
        }
        if (isset($condition["status"]) && $condition["status"] != "") {
            $select->where("status = ?", $condition["status"]);
        }
        if (isset($condition["upload_file_id_no_empty"]) && $condition["upload_file_id_no_empty"] != "") {
            $select->where("upload_file_id !=0");
        }
        if (isset($condition["zb_status_in"]) && $condition["zb_status_in"] != "" &&!empty($condition['zb_status_in'])) {
            $select->where("zb_status in(?)", $condition['zb_status_in']);
        }
        if (isset($condition["upload_file_id"])&& $condition["upload_file_id"] != "") {
            $select->where("upload_file_id = ?", $condition['upload_file_id']);
        }
        if (isset($condition["batch_code"])&& $condition["batch_code"] != "") {
            $select->where("batch_code = ?", $condition['batch_code']);
        }
        /*CONDITION_END*/
        if ('count(*)' == $type) {
            return $this->_table->getAdapter()->fetchOne($select);
        } else {
            if (!empty($orderBy)) {
                $select->order($orderBy);
            }
            if ($pageSize > 0 and $page > 0) {
                $start = ($page - 1) * $pageSize;
                $select->limit($pageSize, $start);
            }
            $sql = $select->__toString();
            return $this->_table->getAdapter()->fetchAll($sql);
        }
    }
    public function getLeftJoinByCondition($condition = array(), $type = '*', $pageSize = 0, $page = 1, $orderBy = "") {
        $select = $this->_table->getAdapter()->select();
        $table = $this->_table->info('name');
        $select->from(['i'=>$table], $type);
        $select->where("1 =?", 1);
        $select->joinInner(["ib"=>'invt_list_body'],"i.il_id=ib.il_id",null);
        if (isset($condition["GdsMtno"]) && $condition["GdsMtno"] != "") {
            $select->where("GdsMtno = ?", $condition["GdsMtno"]);
        }
        if (isset($condition["status_in"]) && $condition["status_in"] != "") {
            $select->where("status in(?)", $condition["status_in"]);
        }
        if (isset($condition["PutrecNo"]) && $condition["PutrecNo"] != "") {
            $select->where("PutrecNo = ?", $condition["PutrecNo"]);
        }
        if (isset($condition["putrec_seqno_empty"])) {
            $select->where("PutrecSeqno = ''");
        }
        if ('count(*)' == $type) {
            return $this->_table->getAdapter()->fetchOne($select);
        } else {
            if (!empty($orderBy)) {
                $select->order($orderBy);
            }
            if ($pageSize > 0 and $page > 0) {
                $start = ($page - 1) * $pageSize;
                $select->limit($pageSize, $start);
            }
            $sql = $select->__toString();
            return $this->_table->getAdapter()->fetchAll($sql);
        }
    }
    /**
     * @todo 和预录入连接
     */
    public function getLeftJoinbgByCondition($condition = array(), $type = '*', $pageSize = 0, $page = 1, $orderBy = "") {
        $select = $this->_table->getAdapter()->select();
        $table = $this->_table->info('name');

        $select->from(['i'=>$table], $type);
        $select->joinLeft("bg_pri_entry_data_detail_body_head as bpedhh", "bpedhh.bpedbh_id=i.bpedbh_id", array('bpd_ref_no'));
        $select->joinLeft("bg_pri_entry_data as bped", "bped.bped_id=bpedhh.bped_id", array('ref_no'));

        $select->where("1 =?", 1);

        if (isset($condition["il_id"]) && $condition["il_id"] != "") {
            $select->where("il_id = ?", $condition["il_id"]);
        }
        if (isset($condition["BondInvtNo"]) && $condition["BondInvtNo"] != "") {
            $select->where("BondInvtNo = ?", $condition["BondInvtNo"]);
        }
        if (isset($condition["SeqNo"]) && $condition["SeqNo"] != "") {
            $select->where("SeqNo = ?", $condition["SeqNo"]);
        }
        if (isset($condition["PutrecNo"]) && $condition["PutrecNo"] != "") {
            $select->where("PutrecNo = ?", $condition["PutrecNo"]);
        }
        if (isset($condition["PutrecNo_in"]) && $condition["PutrecNo_in"] != "") {
            $select->where("PutrecNo in(?)", $condition["PutrecNo_in"]);
        }
        if (isset($condition["EtpsInnerInvtNo"]) && $condition["EtpsInnerInvtNo"] != "") {
            $select->where("EtpsInnerInvtNo = ?", $condition["EtpsInnerInvtNo"]);
        }
        if (isset($condition["BizopEtpsSccd"]) && $condition["BizopEtpsSccd"] != "") {
            $select->where("BizopEtpsSccd = ?", $condition["BizopEtpsSccd"]);
        }
        if (isset($condition["BizopEtpsno"]) && $condition["BizopEtpsno"] != "") {
            $select->where("BizopEtpsno = ?", $condition["BizopEtpsno"]);
        }
        if (isset($condition["BizopEtpsNm"]) && $condition["BizopEtpsNm"] != "") {
            $select->where("BizopEtpsNm = ?", $condition["BizopEtpsNm"]);
        }
        if (isset($condition["RcvgdEtpsno"]) && $condition["RcvgdEtpsno"] != "") {
            $select->where("RcvgdEtpsno = ?", $condition["RcvgdEtpsno"]);
        }
        if (isset($condition["RvsngdEtpsSccd"]) && $condition["RvsngdEtpsSccd"] != "") {
            $select->where("RvsngdEtpsSccd = ?", $condition["RvsngdEtpsSccd"]);
        }
        if (isset($condition["RcvgdEtpsNm"]) && $condition["RcvgdEtpsNm"] != "") {
            $select->where("RcvgdEtpsNm = ?", $condition["RcvgdEtpsNm"]);
        }
        if (isset($condition["DclEtpsSccd"]) && $condition["DclEtpsSccd"] != "") {
            $select->where("DclEtpsSccd = ?", $condition["DclEtpsSccd"]);
        }
        if (isset($condition["DclEtpsno"]) && $condition["DclEtpsno"] != "") {
            $select->where("DclEtpsno = ?", $condition["DclEtpsno"]);
        }
        if (isset($condition["DclEtpsNm"]) && $condition["DclEtpsNm"] != "") {
            $select->where("DclEtpsNm = ?", $condition["DclEtpsNm"]);
        }
        if (isset($condition["InvtDclTime"]) && $condition["InvtDclTime"] != "") {
            $select->where("InvtDclTime = ?", $condition["InvtDclTime"]);
        }
        if (isset($condition["EntryDclTime"]) && $condition["EntryDclTime"] != "") {
            $select->where("EntryDclTime = ?", $condition["EntryDclTime"]);
        }
        if (isset($condition["EntryNo"]) && $condition["EntryNo"] != "") {
            $select->where("EntryNo = ?", $condition["EntryNo"]);
        }
        if (isset($condition["RltInvtNo"]) && $condition["RltInvtNo"] != "") {
            $select->where("RltInvtNo = ?", $condition["RltInvtNo"]);
        }
        if (isset($condition["RltPutrecNo"]) && $condition["RltPutrecNo"] != "") {
            $select->where("RltPutrecNo = ?", $condition["RltPutrecNo"]);
        }
        if (isset($condition["RltEntryNo"]) && $condition["RltEntryNo"] != "") {
            $select->where("RltEntryNo = ?", $condition["RltEntryNo"]);
        }
        if (isset($condition["RltEntryBizopEtpsSccd"]) && $condition["RltEntryBizopEtpsSccd"] != "") {
            $select->where("RltEntryBizopEtpsSccd = ?", $condition["RltEntryBizopEtpsSccd"]);
        }
        if (isset($condition["RltEntryBizopEtpsno"]) && $condition["RltEntryBizopEtpsno"] != "") {
            $select->where("RltEntryBizopEtpsno = ?", $condition["RltEntryBizopEtpsno"]);
        }
        if (isset($condition["RltEntryBizopEtpsNm"]) && $condition["RltEntryBizopEtpsNm"] != "") {
            $select->where("RltEntryBizopEtpsNm = ?", $condition["RltEntryBizopEtpsNm"]);
        }
        if (isset($condition["RltEntryRvsngdEtpsSccd"]) && $condition["RltEntryRvsngdEtpsSccd"] != "") {
            $select->where("RltEntryRvsngdEtpsSccd = ?", $condition["RltEntryRvsngdEtpsSccd"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsno"]) && $condition["RltEntryRcvgdEtpsno"] != "") {
            $select->where("RltEntryRcvgdEtpsno = ?", $condition["RltEntryRcvgdEtpsno"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsNm"]) && $condition["RltEntryRcvgdEtpsNm"] != "") {
            $select->where("RltEntryRcvgdEtpsNm = ?", $condition["RltEntryRcvgdEtpsNm"]);
        }
        if (isset($condition["RltEntryDclEtpsSccd"]) && $condition["RltEntryDclEtpsSccd"] != "") {
            $select->where("RltEntryDclEtpsSccd = ?", $condition["RltEntryDclEtpsSccd"]);
        }
        if (isset($condition["RltEntryDclEtpsno"]) && $condition["RltEntryDclEtpsno"] != "") {
            $select->where("RltEntryDclEtpsno = ?", $condition["RltEntryDclEtpsno"]);
        }
        if (isset($condition["RltEntryDclEtpsNm"]) && $condition["RltEntryDclEtpsNm"] != "") {
            $select->where("RltEntryDclEtpsNm = ?", $condition["RltEntryDclEtpsNm"]);
        }
        if (isset($condition["ImpexpPortcd"]) && $condition["ImpexpPortcd"] != "") {
            $select->where("ImpexpPortcd = ?", $condition["ImpexpPortcd"]);
        }
        if (isset($condition["DclPlcCuscd"]) && $condition["DclPlcCuscd"] != "") {
            $select->where("DclPlcCuscd = ?", $condition["DclPlcCuscd"]);
        }
        if (isset($condition["ImpexpMarkcd"]) && $condition["ImpexpMarkcd"] != "") {
            $select->where("ImpexpMarkcd = ?", $condition["ImpexpMarkcd"]);
        }
        if (isset($condition["MtpckEndprdMarkcd"]) && $condition["MtpckEndprdMarkcd"] != "") {
            $select->where("MtpckEndprdMarkcd = ?", $condition["MtpckEndprdMarkcd"]);
        }
        if (isset($condition["SupvModecd"]) && $condition["SupvModecd"] != "") {
            $select->where("SupvModecd = ?", $condition["SupvModecd"]);
        }
        if (isset($condition["TrspModecd"]) && $condition["TrspModecd"] != "") {
            $select->where("TrspModecd = ?", $condition["TrspModecd"]);
        }
        if (isset($condition["DclcusFlag"]) && $condition["DclcusFlag"] != "") {
            $select->where("DclcusFlag = ?", $condition["DclcusFlag"]);
        }
        if (isset($condition["DclcusTypecd"]) && $condition["DclcusTypecd"] != "") {
            $select->where("DclcusTypecd = ?", $condition["DclcusTypecd"]);
        }
        if (isset($condition["VrfdedMarkcd"]) && $condition["VrfdedMarkcd"] != "") {
            $select->where("VrfdedMarkcd = ?", $condition["VrfdedMarkcd"]);
        }
        if (isset($condition["InvtIochkptStucd"]) && $condition["InvtIochkptStucd"] != "") {
            $select->where("InvtIochkptStucd = ?", $condition["InvtIochkptStucd"]);
        }
        if (isset($condition["PrevdTime"]) && $condition["PrevdTime"] != "") {
            $select->where("PrevdTime = ?", $condition["PrevdTime"]);
        }
        if (isset($condition["FormalVrfdedTime"]) && $condition["FormalVrfdedTime"] != "") {
            $select->where("FormalVrfdedTime = ?", $condition["FormalVrfdedTime"]);
        }
        if (isset($condition["ApplyNo"]) && $condition["ApplyNo"] != "") {
            $select->where("ApplyNo = ?", $condition["ApplyNo"]);
        }
        if (isset($condition["ListType"]) && $condition["ListType"] != "") {
            $select->where("ListType = ?", $condition["ListType"]);
        }
        if (isset($condition["InputCode"]) && $condition["InputCode"] != "") {
            $select->where("InputCode = ?", $condition["InputCode"]);
        }
        if (isset($condition["InputCreditCode"]) && $condition["InputCreditCode"] != "") {
            $select->where("InputCreditCode = ?", $condition["InputCreditCode"]);
        }
        if (isset($condition["InputName"]) && $condition["InputName"] != "") {
            $select->where("InputName = ?", $condition["InputName"]);
        }
        if (isset($condition["IcCardNo"]) && $condition["IcCardNo"] != "") {
            $select->where("IcCardNo = ?", $condition["IcCardNo"]);
        }
        if (isset($condition["InputTime"]) && $condition["InputTime"] != "") {
            $select->where("InputTime = ?", $condition["InputTime"]);
        }
        if (isset($condition["ListStat"]) && $condition["ListStat"] != "") {
            $select->where("ListStat = ?", $condition["ListStat"]);
        }
        if (isset($condition["CorrEntryDclEtpsSccd"]) && $condition["CorrEntryDclEtpsSccd"] != "") {
            $select->where("CorrEntryDclEtpsSccd = ?", $condition["CorrEntryDclEtpsSccd"]);
        }
        if (isset($condition["CorrEntryDclEtpsNo"]) && $condition["CorrEntryDclEtpsNo"] != "") {
            $select->where("CorrEntryDclEtpsNo = ?", $condition["CorrEntryDclEtpsNo"]);
        }
        if (isset($condition["CorrEntryDclEtpsNm"]) && $condition["CorrEntryDclEtpsNm"] != "") {
            $select->where("CorrEntryDclEtpsNm = ?", $condition["CorrEntryDclEtpsNm"]);
        }
        if (isset($condition["DecType"]) && $condition["DecType"] != "") {
            $select->where("DecType = ?", $condition["DecType"]);
        }
        if (isset($condition["StshipTrsarvNatcd"]) && $condition["StshipTrsarvNatcd"] != "") {
            $select->where("StshipTrsarvNatcd = ?", $condition["StshipTrsarvNatcd"]);
        }
        if (isset($condition["InvtType"]) && $condition["InvtType"] != "") {
            $select->where("InvtType = ?", $condition["InvtType"]);
        }
        if (isset($condition["EntryStucd"]) && $condition["EntryStucd"] != "") {
            $select->where("EntryStucd = ?", $condition["EntryStucd"]);
        }
        if (isset($condition["PassportUsedTypeCd"]) && $condition["PassportUsedTypeCd"] != "") {
            $select->where("PassportUsedTypeCd = ?", $condition["PassportUsedTypeCd"]);
        }
        if (isset($condition["Rmk"]) && $condition["Rmk"] != "") {
            $select->where("Rmk = ?", $condition["Rmk"]);
        }
        if (isset($condition["DclTypecd"]) && $condition["DclTypecd"] != "") {
            $select->where("DclTypecd = ?", $condition["DclTypecd"]);
        }
        if (isset($condition["NeedEntryModified"]) && $condition["NeedEntryModified"] != "") {
            $select->where("NeedEntryModified = ?", $condition["NeedEntryModified"]);
        }
        if (isset($condition["LevyBlAmt"]) && $condition["LevyBlAmt"] != "") {
            $select->where("LevyBlAmt = ?", $condition["LevyBlAmt"]);
        }
        if (isset($condition["ChgTmsCnt"]) && $condition["ChgTmsCnt"] != "") {
            $select->where("ChgTmsCnt = ?", $condition["ChgTmsCnt"]);
        }
        if (isset($condition["GenDecFlag"]) && $condition["GenDecFlag"] != "") {
            $select->where("GenDecFlag = ?", $condition["GenDecFlag"]);
        }
        if (isset($condition["add_time"]) && $condition["add_time"] != "") {
            $select->where("add_time = ?", $condition["add_time"]);
        }
        if (isset($condition["status"]) && $condition["status"] != "") {
            $select->where("status = ?", $condition["status"]);
        }
        if (isset($condition["il_id"]) && $condition["il_id"] != "") {
            $select->where("il_id = ?", $condition["il_id"]);
        }
        if (isset($condition["BondInvtNo"]) && $condition["BondInvtNo"] != "") {
            $select->where("BondInvtNo = ?", $condition["BondInvtNo"]);
        }
        if (isset($condition["SeqNo"]) && $condition["SeqNo"] != "") {
            $select->where("SeqNo = ?", $condition["SeqNo"]);
        }
        if (isset($condition["PutrecNo"]) && $condition["PutrecNo"] != "") {
            $select->where("PutrecNo = ?", $condition["PutrecNo"]);
        }
        if (isset($condition["EtpsInnerInvtNo"]) && $condition["EtpsInnerInvtNo"] != "") {
            $select->where("EtpsInnerInvtNo = ?", $condition["EtpsInnerInvtNo"]);
        }
        if (isset($condition["BizopEtpsSccd"]) && $condition["BizopEtpsSccd"] != "") {
            $select->where("BizopEtpsSccd = ?", $condition["BizopEtpsSccd"]);
        }
        if (isset($condition["BizopEtpsno"]) && $condition["BizopEtpsno"] != "") {
            $select->where("BizopEtpsno = ?", $condition["BizopEtpsno"]);
        }
        if (isset($condition["BizopEtpsNm"]) && $condition["BizopEtpsNm"] != "") {
            $select->where("BizopEtpsNm = ?", $condition["BizopEtpsNm"]);
        }
        if (isset($condition["RcvgdEtpsno"]) && $condition["RcvgdEtpsno"] != "") {
            $select->where("RcvgdEtpsno = ?", $condition["RcvgdEtpsno"]);
        }
        if (isset($condition["RvsngdEtpsSccd"]) && $condition["RvsngdEtpsSccd"] != "") {
            $select->where("RvsngdEtpsSccd = ?", $condition["RvsngdEtpsSccd"]);
        }
        if (isset($condition["RcvgdEtpsNm"]) && $condition["RcvgdEtpsNm"] != "") {
            $select->where("RcvgdEtpsNm = ?", $condition["RcvgdEtpsNm"]);
        }
        if (isset($condition["DclEtpsSccd"]) && $condition["DclEtpsSccd"] != "") {
            $select->where("DclEtpsSccd = ?", $condition["DclEtpsSccd"]);
        }
        if (isset($condition["DclEtpsno"]) && $condition["DclEtpsno"] != "") {
            $select->where("DclEtpsno = ?", $condition["DclEtpsno"]);
        }
        if (isset($condition["DclEtpsNm"]) && $condition["DclEtpsNm"] != "") {
            $select->where("DclEtpsNm = ?", $condition["DclEtpsNm"]);
        }
        if (isset($condition["InvtDclTime"]) && $condition["InvtDclTime"] != "") {
            $select->where("InvtDclTime = ?", $condition["InvtDclTime"]);
        }
        if (isset($condition["EntryDclTime"]) && $condition["EntryDclTime"] != "") {
            $select->where("EntryDclTime = ?", $condition["EntryDclTime"]);
        }
        if (isset($condition["EntryNo"]) && $condition["EntryNo"] != "") {
            $select->where("EntryNo = ?", $condition["EntryNo"]);
        }
        if (isset($condition["RltInvtNo"]) && $condition["RltInvtNo"] != "") {
            $select->where("RltInvtNo = ?", $condition["RltInvtNo"]);
        }
        if (isset($condition["RltPutrecNo"]) && $condition["RltPutrecNo"] != "") {
            $select->where("RltPutrecNo = ?", $condition["RltPutrecNo"]);
        }
        if (isset($condition["RltEntryNo"]) && $condition["RltEntryNo"] != "") {
            $select->where("RltEntryNo = ?", $condition["RltEntryNo"]);
        }
        if (isset($condition["RltEntryBizopEtpsSccd"]) && $condition["RltEntryBizopEtpsSccd"] != "") {
            $select->where("RltEntryBizopEtpsSccd = ?", $condition["RltEntryBizopEtpsSccd"]);
        }
        if (isset($condition["RltEntryBizopEtpsno"]) && $condition["RltEntryBizopEtpsno"] != "") {
            $select->where("RltEntryBizopEtpsno = ?", $condition["RltEntryBizopEtpsno"]);
        }
        if (isset($condition["RltEntryBizopEtpsNm"]) && $condition["RltEntryBizopEtpsNm"] != "") {
            $select->where("RltEntryBizopEtpsNm = ?", $condition["RltEntryBizopEtpsNm"]);
        }
        if (isset($condition["RltEntryRvsngdEtpsSccd"]) && $condition["RltEntryRvsngdEtpsSccd"] != "") {
            $select->where("RltEntryRvsngdEtpsSccd = ?", $condition["RltEntryRvsngdEtpsSccd"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsno"]) && $condition["RltEntryRcvgdEtpsno"] != "") {
            $select->where("RltEntryRcvgdEtpsno = ?", $condition["RltEntryRcvgdEtpsno"]);
        }
        if (isset($condition["RltEntryRcvgdEtpsNm"]) && $condition["RltEntryRcvgdEtpsNm"] != "") {
            $select->where("RltEntryRcvgdEtpsNm = ?", $condition["RltEntryRcvgdEtpsNm"]);
        }
        if (isset($condition["RltEntryDclEtpsSccd"]) && $condition["RltEntryDclEtpsSccd"] != "") {
            $select->where("RltEntryDclEtpsSccd = ?", $condition["RltEntryDclEtpsSccd"]);
        }
        if (isset($condition["RltEntryDclEtpsno"]) && $condition["RltEntryDclEtpsno"] != "") {
            $select->where("RltEntryDclEtpsno = ?", $condition["RltEntryDclEtpsno"]);
        }
        if (isset($condition["RltEntryDclEtpsNm"]) && $condition["RltEntryDclEtpsNm"] != "") {
            $select->where("RltEntryDclEtpsNm = ?", $condition["RltEntryDclEtpsNm"]);
        }
        if (isset($condition["ImpexpPortcd"]) && $condition["ImpexpPortcd"] != "") {
            $select->where("ImpexpPortcd = ?", $condition["ImpexpPortcd"]);
        }
        if (isset($condition["DclPlcCuscd"]) && $condition["DclPlcCuscd"] != "") {
            $select->where("DclPlcCuscd = ?", $condition["DclPlcCuscd"]);
        }
        if (isset($condition["ImpexpMarkcd"]) && $condition["ImpexpMarkcd"] != "") {
            $select->where("ImpexpMarkcd = ?", $condition["ImpexpMarkcd"]);
        }
        if (isset($condition["MtpckEndprdMarkcd"]) && $condition["MtpckEndprdMarkcd"] != "") {
            $select->where("MtpckEndprdMarkcd = ?", $condition["MtpckEndprdMarkcd"]);
        }
        if (isset($condition["SupvModecd"]) && $condition["SupvModecd"] != "") {
            $select->where("SupvModecd = ?", $condition["SupvModecd"]);
        }
        if (isset($condition["TrspModecd"]) && $condition["TrspModecd"] != "") {
            $select->where("TrspModecd = ?", $condition["TrspModecd"]);
        }
        if (isset($condition["DclcusFlag"]) && $condition["DclcusFlag"] != "") {
            $select->where("DclcusFlag = ?", $condition["DclcusFlag"]);
        }
        if (isset($condition["DclcusTypecd"]) && $condition["DclcusTypecd"] != "") {
            $select->where("DclcusTypecd = ?", $condition["DclcusTypecd"]);
        }
        if (isset($condition["VrfdedMarkcd"]) && $condition["VrfdedMarkcd"] != "") {
            $select->where("VrfdedMarkcd = ?", $condition["VrfdedMarkcd"]);
        }
        if (isset($condition["InvtIochkptStucd"]) && $condition["InvtIochkptStucd"] != "") {
            $select->where("InvtIochkptStucd = ?", $condition["InvtIochkptStucd"]);
        }
        if (isset($condition["PrevdTime"]) && $condition["PrevdTime"] != "") {
            $select->where("PrevdTime = ?", $condition["PrevdTime"]);
        }
        if (isset($condition["FormalVrfdedTime"]) && $condition["FormalVrfdedTime"] != "") {
            $select->where("FormalVrfdedTime = ?", $condition["FormalVrfdedTime"]);
        }
        if (isset($condition["ApplyNo"]) && $condition["ApplyNo"] != "") {
            $select->where("ApplyNo = ?", $condition["ApplyNo"]);
        }
        if (isset($condition["ListType"]) && $condition["ListType"] != "") {
            $select->where("ListType = ?", $condition["ListType"]);
        }
        if (isset($condition["InputCode"]) && $condition["InputCode"] != "") {
            $select->where("InputCode = ?", $condition["InputCode"]);
        }
        if (isset($condition["InputCreditCode"]) && $condition["InputCreditCode"] != "") {
            $select->where("InputCreditCode = ?", $condition["InputCreditCode"]);
        }
        if (isset($condition["InputName"]) && $condition["InputName"] != "") {
            $select->where("InputName = ?", $condition["InputName"]);
        }
        if (isset($condition["IcCardNo"]) && $condition["IcCardNo"] != "") {
            $select->where("IcCardNo = ?", $condition["IcCardNo"]);
        }
        if (isset($condition["ListStat"]) && $condition["ListStat"] != "") {
            $select->where("ListStat = ?", $condition["ListStat"]);
        }
        if (isset($condition["CorrEntryDclEtpsSccd"]) && $condition["CorrEntryDclEtpsSccd"] != "") {
            $select->where("CorrEntryDclEtpsSccd = ?", $condition["CorrEntryDclEtpsSccd"]);
        }
        if (isset($condition["CorrEntryDclEtpsNo"]) && $condition["CorrEntryDclEtpsNo"] != "") {
            $select->where("CorrEntryDclEtpsNo = ?", $condition["CorrEntryDclEtpsNo"]);
        }
        if (isset($condition["CorrEntryDclEtpsNm"]) && $condition["CorrEntryDclEtpsNm"] != "") {
            $select->where("CorrEntryDclEtpsNm = ?", $condition["CorrEntryDclEtpsNm"]);
        }
        if (isset($condition["DecType"]) && $condition["DecType"] != "") {
            $select->where("DecType = ?", $condition["DecType"]);
        }
        if (isset($condition["StshipTrsarvNatcd"]) && $condition["StshipTrsarvNatcd"] != "") {
            $select->where("StshipTrsarvNatcd = ?", $condition["StshipTrsarvNatcd"]);
        }
        if (isset($condition["InvtType"]) && $condition["InvtType"] != "") {
            $select->where("InvtType = ?", $condition["InvtType"]);
        }
        if (isset($condition["EntryStucd"]) && $condition["EntryStucd"] != "") {
            $select->where("EntryStucd = ?", $condition["EntryStucd"]);
        }
        if (isset($condition["PassportUsedTypeCd"]) && $condition["PassportUsedTypeCd"] != "") {
            $select->where("PassportUsedTypeCd = ?", $condition["PassportUsedTypeCd"]);
        }
        if (isset($condition["DclTypecd"]) && $condition["DclTypecd"] != "") {
            $select->where("DclTypecd = ?", $condition["DclTypecd"]);
        }
        if (isset($condition["NeedEntryModified"]) && $condition["NeedEntryModified"] != "") {
            $select->where("NeedEntryModified = ?", $condition["NeedEntryModified"]);
        }
        if (isset($condition["LevyBlAmt"]) && $condition["LevyBlAmt"] != "") {
            $select->where("LevyBlAmt = ?", $condition["LevyBlAmt"]);
        }
        if (isset($condition["ChgTmsCnt"]) && $condition["ChgTmsCnt"] != "") {
            $select->where("ChgTmsCnt = ?", $condition["ChgTmsCnt"]);
        }
        if (isset($condition["GenDecFlag"]) && $condition["GenDecFlag"] != "") {
            $select->where("GenDecFlag = ?", $condition["GenDecFlag"]);
        }
        if (isset($condition["dateFor"]) && $condition["dateFor"] != "") {
            $select->where("add_time >= ?", date("Y-m-d H:i:s",strtotime($condition["dateFor"])));
        }
        if (isset($condition["dateTo"]) && $condition["dateTo"] != "") {
            $select->where("add_time <= ?", date("Y-m-d H:i:s",strtotime($condition["dateTo"])));
        }
        if (isset($condition["status"]) && $condition["status"] != "") {
            $select->where("status = ?", $condition["status"]);
        }
        if (isset($condition["upload_file_id_no_empty"]) && $condition["upload_file_id_no_empty"] != "") {
            $select->where("upload_file_id !=0");
        }
        if (isset($condition["zb_status_in"]) && $condition["zb_status_in"] != "" &&!empty($condition['zb_status_in'])) {
            $select->where("zb_status in(?)", $condition['zb_status_in']);
        }
        if (isset($condition["upload_file_id"])&& $condition["upload_file_id"] != "") {
            $select->where("upload_file_id = ?", $condition['upload_file_id']);
        }
        if (isset($condition["batch_code"])&& $condition["batch_code"] != "") {
            $select->where("batch_code = ?", $condition['batch_code']);
        }

        if (isset($condition["ref_no"]) && $condition["ref_no"] != "") {
            $select->where("bped.ref_no = ?", $condition["ref_no"]);
        }
        if (isset($condition["bpd_ref_no"]) && $condition["bpd_ref_no"] != "") {
            $select->where("bpedhh.bpd_ref_no = ?", $condition["bpd_ref_no"]);
        }
        if ('count(*)' == $type) {
            return $this->_table->getAdapter()->fetchOne($select);
        } else {
            if (!empty($orderBy)) {
                $select->order($orderBy);
            }
            if ($pageSize > 0 and $page > 0) {
                $start = ($page - 1) * $pageSize;
                $select->limit($pageSize, $start);
            }
            $sql = $select->__toString();
            return $this->_table->getAdapter()->fetchAll($sql);
        }
    }
}