/*
*  Copyright 2019-2020 Zheng Jie
*
*  Licensed under the Apache License, Version 2.0 (the "License");
*  you may not use this file except in compliance with the License.
*  You may obtain a copy of the License at
*
*  http://www.apache.org/licenses/LICENSE-2.0
*
*  Unless required by applicable law or agreed to in writing, software
*  distributed under the License is distributed on an "AS IS" BASIS,
*  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
*  See the License for the specific language governing permissions and
*  limitations under the License.
*/
package com.youchain.businessdata.service.dto;

import lombok.Data;

import java.sql.Timestamp;
import java.util.List;
import com.youchain.annotation.Query;

/**
* @website https://eladmin.vip
* @author huojin
* @date 2023-08-16
**/
@Data
public class PickDetailQueryCriteria{
    /** 模糊 */
    // 左关联查询，left Join ， joinName为关联实体名称 , propName为关联实体 字段
    @Query(joinName = "item", propName="code",type = Query.Type.INNER_LIKE)
    private String itemCode;

    /** 模糊 */
    @Query(joinName = "item", propName="name",type = Query.Type.INNER_LIKE)
    private String itemName;

    /** 叫料库区 */
    @Query(joinName = "shArea", propName="code",type = Query.Type.INNER_LIKE)
    private String rkAreaCode;
    /** 拣货库区 */
    @Query(joinName = "area", propName="code",type = Query.Type.INNER_LIKE)
    private String ckAreaCode;

    /** 接收工厂 */
    @Query(joinName = "pickTicket", propName="gcCode",type = Query.Type.INNER_LIKE)
    private String gcCode;
    /** 模糊 */
    @Query(type = Query.Type.INNER_LIKE)
    private String po;
    /** 需求不足*/
    @Query(type = Query.Type.GREATER_THAN)
    private Double pureXqBz;
    /** 可用库存数*/
    @Query(type = Query.Type.GREATER_THAN)
    private Double invQty;

    /** 等于 */
    @Query(type = Query.Type.EQUAL)
    private String status;

    @Query(type = Query.Type.BETWEEN)
    private List<Timestamp> createTime;

    /** 模糊 */
    @Query(joinName = "pickTicket", propName="id",type = Query.Type.EQUAL)
    private Long pickTicketId;

    /** 备货单号 */
    @Query(type = Query.Type.INNER_LIKE)
    private String code;

    /** 页面类型  ZSC指示残 ALL明细 */
    @Query(type = Query.Type.EQUAL)
    private String pageType;
    /**ZCZS 正常指示,ZZJL 制造叫料*/
    @Query(type = Query.Type.EQUAL)
    private String type;

}