package com.slcf.dao;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import com.slcf.bean.WaitCheckCondition;
import com.slcf.pojo.WaitCheckBean;

@Repository
public interface WaitCheckDao {

	/**
	 * 添加
	 * @param waitCheck
	 * @return
	 */
	@Insert("insert into cust_wait_check(lgnum,ivnum,ivpos,lqnum,matnr,maktx,werks,lgtyp,lgpla, "
			+ " memo,modi_time) "
			+ " values(#{lgnum},#{ivnum},#{ivpos},#{lqnum},#{matnr},#{maktx},#{werks},#{lgtyp},#{lgpla}, "
			+ " #{memo},getdate())")
	public int insertWaitCheck(WaitCheckBean waitCheck);
	
	//分页查询所有信息
	public List<WaitCheckBean> queryWaitCheckList(WaitCheckCondition waitCheckCon);
	
//	//统计所有数据总数量
//	@Select("select count(*) from cust_wait_check")
//	public int getLocationCount();
	
	//根据过滤条件统计总数量
	public int getWaitCheckCount(WaitCheckCondition waitCheckCon);
	
	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from cust_wait_check order by sheet_no,mat_no desc")
	public List<WaitCheckBean> getWaitCheckList();
	
	/**
	 * 查询信息
	 * @param id
	 * @return
	 */
	@Select("select * from cust_wait_check where lgnum=#{lgnum} and tbnum=#{tbnum} and tbpos=#{tbpos} and zmatid=#{zmatid}")
	public WaitCheckBean getWaitCheckById(WaitCheckBean waitCheck);
	
	//更新
	@Update("update cust_wait_check set qty=#{qty},ctns=#{ctns},wt=#{wt},memo=#{memo},modi_user=#{modi_user},modi_time=getdate(), "
			+ " loc_no=#{loc_no}, sta_no=#{sta_no},type=#{type},in_qty=#{in_qty},barcode=#{barcode} "
			+ " where sheet_no=#{sheet_no} and mat_no=#{mat_no}")
	public int upWaitCheck(WaitCheckBean waitCheck);
	
	//根据id删除工作信息
	@Delete("delete from cust_wait_check where lgnum=#{lgnum} and ivnum=#{ivnum} and ivpos=#{ivpos}")
	public int delWaitCheckById(WaitCheckBean waitCheckBean);
	
	//待删除资料，先插入日志档
	@Insert("insert into cust_wait_check_log select * from cust_wait_check where lgnum=#{lgnum} and ivnum=#{ivnum} and ivpos=#{ivpos}")
	public int insertLog(WaitCheckBean waitCheckBean);
	
	/**
	 * 根据条码查询通知档
	 * @return
	 */
	@Select("select * from cust_wait_check a left join bas_mat_code b on a.mat_no=b.mat_no "
			+ "where barcode=#{barcode}  order by sheet_no,a.mat_no desc")
	public List<WaitCheckBean> getApiWaitCheckList(@Param("barcode")String barcode);
}