';
        // print_r($condition);
        // print_r($type);exit;
        $select = $this->_table->getAdapter()->select();
        $table = $this->_table->info('name');
        $types = ($type) == 'count(*)' ? "COUNT(DISTINCT product.product_sku,customer.customer_company_name)" : $type;
        if($condition['dateFor'] || $condition['dateTo']){
            $condition['product_search_id'] = 5;//时间shipment_time唯一检索查询
        }
        switch ($condition['product_search_id']) {
            case 1://待入库指产品关联的备货ASN处于待审核状态的产品；
                $select->from($table,$types)
                    ->join('customer', $table.'.customer_id = customer.customer_id','customer.customer_company_name as E28')
                    ->join('receiving_detail', $table.'.product_barcode = receiving_detail.product_barcode','receiving_detail.receiving_code')
                    ->join('receiving', 'receiving.receiving_code = receiving_detail.receiving_code','receiving.receiving_status');
                $select->where("receiving.receiving_status = ?", 3);
                $select->where("receiving.receive_model_type = ?", 0);
                break;
            case 2://库内指目前在系统中有库存的产品；
                $select->from($table,$types)
                ->join('customer', $table.'.customer_id = customer.customer_id','customer.customer_company_name as E28')
                ->join('product_inventory', $table.'.product_id = product_inventory.product_id','product_inventory.pi_sellable');
                $select->orWhere("product_inventory.pi_sellable >0 or product_inventory.pi_reserved >0",$condition["product_id"]);
                break;
            case 3://待出库指产品关联的订单处于已提交到已加挂状态的产品；
                $select->from($table,$types)
                    ->join('customer', $table.'.customer_id = customer.customer_id','customer.customer_company_name as E28')
                    ->join('order_product', $table.'.product_id = order_product.product_id','order_product.order_code')
                    ->join('orders', 'orders.order_code = order_product.order_code','orders.order_status');
                $select->where("orders.order_status in(?)", array(4,5,6,7,8,9,10));
                $select->where("orders.order_mode_type = ?", 0);
                break;
            case 4||5://已出库只产品关联的订单处于物流完成到已签收状态的产品
                $showFields=array(
                    'product_id as E0',
                    'product_barcode as E2',
                    'product_sku as E1',
                    'product_title as E6',
                    'goods_id as E25',
                    'hs_code as E27',
                    'customer_company_name as E28',
                    'shipment_time',
                    );
                $types = ($type) == 'count(*)' ? "count(*)" : $showFields;
               // echo $types;exit;
                return Service_ProductSearch::getLikeByCondition($condition, $types, $pageSize, $page);
                break;
            default://产品状态为全部时，指所有已备案成功的产品。
                $select->from($table,$type)
                ->joinLeft('customer', $table.'.customer_id = customer.customer_id','customer.customer_company_name as E28');
                $select->where($table.".product_status = ?",1);
                break;
        }
        
       // $select->from($table, $type);
        $select->where("1 =?", 1);
        if(isset($condition["product_title"]) && $condition["product_title"] != ""){
            $select->where("product_title like ?",'%'.$condition["product_title"].'%');
        }
        if(isset($condition["hs_code"]) && $condition["hs_code"] != ""){
            $select->where("hs_code like ?",'%'.$condition["hs_code"].'%');
        }
        if(isset($condition["customer.customer_company_name_like"]) && $condition["customer.customer_company_name_like"] != ""){
            $select->where("customer_company_name like ?",'%'.$condition["customer.customer_company_name_like"].'%');
        }
        if(isset($condition["product_sku"]) && $condition["product_sku"] != ""){
            $select->where("product_sku like ?",'%'.$condition["product_sku"].'%');
        }
        if(isset($condition["goods_id"]) && $condition["goods_id"] != ""){
            $select->where("goods_id like ?",'%'.$condition["goods_id"].'%');
        }
        if(isset($condition["dateFor"]) && $condition["dateFor"] != ""){
            $select->where("order_operation_time.shipment_time >= ?",$condition["dateFor"]);
        }
        if(isset($condition["dateTo"]) && $condition["dateTo"] != ""){
            $select->where("order_operation_time.shipment_time <= ?",$condition["dateTo"]);
        }

        /*CONDITION_END*/
        if ('count(*)' == $type) {
            return $this->_table->getAdapter()->fetchOne($select);
        } else {
            //全部不需要去重复
            if(in_array($condition['product_search_id'], array(1,2,3))){
                $select->group(array("product.product_sku","customer.customer_company_name"));
            }
            if (!empty($orderBy)) {
                $select->order($orderBy);
            }
            if ($pageSize > 0 and $page > 0) {
                $start = ($page - 1) * $pageSize;
                $select->limit($pageSize, $start);
            }
            $sql = $select->__toString();
            // die($select->__toString());
            return $this->_table->getAdapter()->fetchAll($sql);
        }
    }
}