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.WorkMastCondition;
import com.slcf.pojo.WorkMastBean;
import com.slcf.bean.WorkDetailCondition;
import com.slcf.pojo.WorkDetailBean;

@Repository
public interface WorkFileDao {

	//-------------------主档------------------------------//
	/**
	 * 插入主档
	 * @param workMast
	 * @return
	 */
	@Insert("insert into asr_wrk_mast(wrk_no,io_time,wrk_sts,io_type,io_pri,crn_no, "
			+ " source_sta_no,sta_no,source_loc_no,loc_no,full_plt,picking, "
			+ " barcode,exit_mk,empty_mk,link_mis,memo,modi_user,modi_time) "
			+ " values(#{wrk_no},#{io_time},#{wrk_sts},#{io_type},#{io_pri},#{crn_no}, "
			+ " #{source_sta_no},#{sta_no},#{source_loc_no}, #{loc_no},#{full_plt},#{picking}, "
			+ " #{barcode},#{exit_mk},#{empty_mk},#{link_mis},#{memo},#{modi_user},getdate())")
	public int insertWorkMast(WorkMastBean workMast);
	
	/**
	 * 分页查询主档信息
	 * @param workMastCon
	 * @return
	 */
	public List<WorkMastBean> queryWorkMastList(WorkMastCondition workMastCon);
	
	//根据过滤条件统计总数量
	public int getWorkMastCount(WorkMastCondition workMastCon);
	
	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from asr_wrk_mast order by wrk_no asc")
	public List<WorkMastBean> getWorkMastList();
	
	/**
	 * 根据id查询信息
	 * @param id
	 * @return
	 */
	@Select("select *,wrk_desc wrk_sts_name from asr_wrk_mast a,asr_bas_wrk_status b where a.wrk_sts=b.wrk_sts and wrk_no=#{id}")
	public WorkMastBean getWorkMastById(int id);
	
	//更新
	@Update("update asr_wrk_mast set wrk_sts=#{wrk_sts},io_pri=#{io_pri},barcode=#{barcode}, "
			+ " modi_user=#{modi_user},modi_time=getdate() "
			+ " where wrk_no=#{wrk_no}")
	public int upWorkMast(WorkMastBean workMast);
	
	//根据id删除工作信息
	@Delete("delete from asr_wrk_mast where wrk_no=#{id}")
	public int delWorkMastById(int id);
	
	//根据过滤条件统计总数量
	@Select("select count(*) from asr_wrk_mast where source_sta_no=#{dev_no} and (wrk_sts=1 or wrk_sts=6)")
	public int getStoreWorkCount(int dev_no);
	
	//-------------------明细------------------------------//
	/**
	 * 插入明细档
	 * @param workDetail
	 * @return
	 */
	@Insert("insert into asr_wrk_detl(wrk_no,io_time,matnr,lgnum,tbnum,tbpos,zmatid,maktx,werks,anfme,altme,zpallet,bname,memo,modi_user,modi_time) "
			+ " values(#{wrk_no},#{io_time},#{matnr},#{lgnum},#{tbnum},#{tbpos},#{zmatid},#{maktx},#{werks},#{anfme},#{altme},#{zpallet},#{bname},#{memo},#{modi_user},getdate())")
	public int insertWorkDetail(WorkDetailBean workDetail);
	
	/**
	 * 分页查询明细档信息
	 * @param workDetailCon
	 * @return
	 */
	public List<WorkDetailBean> queryWorkDetailList(WorkDetailCondition workDetailCon);
	
	//根据过滤条件统计总数量
	public int getWorkDetailCount(WorkDetailCondition workDetailCon);
	
	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from asr_wrk_detl order by wrk_no,mat_no asc")
	public List<WorkDetailBean> getWorkDetailList();
	
//	/**
//	 * 根据id查询信息
//	 * @param id
//	 * @return
//	 */
//	@Select("select * from asr_wrk_detl where wrk_no=#{id}")
//	public WorkDetailBean getWorkDetlById(int id);
	
	//删除工作档资料，先插入日志档
	@Insert("insert into asr_wrk_detl_log select * from asr_wrk_detl where wrk_no=#{wrk_no};"
			+ " insert into asr_wrk_mast_log select * from asr_wrk_mast where wrk_no=#{wrk_no};")
	public int insertLog(int wrk_no);
	
	//根据id删除工作信息
	@Delete("delete from asr_wrk_detl where wrk_no=#{wrk_no};delete from asr_wrk_mast where wrk_no=#{wrk_no};")
	public int delWorkFileById(int wrk_no);
	
	/**
	 * 根据工作号、物料号查询信息
	 * @param id
	 * @return
	 */
	@Select("select * from asr_wrk_detl where wrk_no=#{wrk_no} and mat_no=#{mat_no}")
	public WorkDetailBean getWorkDetlByIdNo(@Param("wrk_no")int wrk_no,@Param("mat_no")String mat_no);
	
	@Select("select * from asr_wrk_detl where mat_no=#{mat_no}")
	public WorkDetailBean getWorkDetlByMatNo(@Param("mat_no")String mat_no);
	
	//更新
	@Update("update asr_wrk_detl set "// wrk_sts=#{wrk_sts},io_pri=#{io_pri}, "
			+ " modi_user=#{modi_user},modi_time=getdate() "
			+ " where wrk_no=#{wrk_no} and mat_no=#{mat_no}}")
	public int upWorkDetail(WorkDetailBean workDetail);
	
	/**
	 * 根据工作号、物料代号查询工作档明细
	 * @param wrk_no
	 * @param matnr
	 * @return
	 */
	@Select("select * from asr_wrk_detl where wrk_no=#{wrk_no} and lgnum=#{lgnum} and tbnum=#{tbnum} and tbpos=#{tbpos} and matnr=#{matnr}")
	public WorkDetailBean getWorkDetlById(WorkDetailBean workDetail);
	
	/**
	 * 更新实际拣料数量
	 * @param workDetl
	 * @return
	 */
	@Update("update asr_wrk_detl set nista=#{nista} "
			+ " where wrk_no=#{wrk_no} and lgnum=#{lgnum} and tbnum=#{tbnum} and tbpos=#{tbpos} and matnr=#{matnr}")
	public int upWorkDetl(WorkDetailBean workDetl);

	/**
	 * 根据托盘码查询工作明细List
	 * @return
	 */
	@Select("select * from asr_wrk_detl where zpallet=#{zpallet} order by wrk_no asc")
	public List<WorkDetailBean> getWorkDetlList(String zpallet);
}