package com.mandi.fendan.mapper;

import java.util.List;
import java.util.Map;

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 com.mandi.fendan.persist.Fd_XSTDMX;
import com.mandi.fendan.util.persist.WaitXSTDMX;

public interface Fd_XSTDMXMapper {

	@Insert("insert into fd_xstdmx "
	+ "(tdmx_tdfl,tdmx_tdls,tdmx_pch,tdmx_hj,tdmx_zt,tdmx_mz,tdmx_jz,"
	+ "tdmx_ggxh,tdmx_zpbz,tdmx_fdbz,tdmx_zcbz,tdmx_gbbz,tdmx_ck,tdmx_hth,tdmx_ywy,tdmx_ddh,tdmx_hwbh,tdmx_wlbh,tdmx_fhzz,tdmx_wbzcc,tdmx_cc) "
	//tdmx_ttlx
	+ "values "
	+ "(#{tdmx_tdfl},#{tdmx_tdls},#{tdmx_pch},"
	+ "#{tdmx_hj},#{tdmx_zt},#{tdmx_mz},#{tdmx_jz},#{tdmx_ggxh},#{tdmx_zpbz},"
	+ "0,0,0,#{tdmx_ck},#{tdmx_hth},#{tdmx_ywy},#{tdmx_ddh},#{tdmx_hwbh},#{tdmx_wlbh},#{tdmx_fhzz},#{tdmx_wbzcc},#{tdmx_cc})")
	//,#{tdmx_ttlx}
	public int insert(Fd_XSTDMX xstdmx);

	@Select("select * from fd_xstdmx where tdmx_tdfl=#{tdmx_tdfl} ")
	public Fd_XSTDMX get(String tdmx_tdfl);

	/**
	 * 批量获取
	 * @param tdmx_tdfls
	 * @return
	 */
	@Select("select * from fd_xstdmx where tdmx_tdfl in (${tdmx_tdfls}) ")
	public List<Fd_XSTDMX> gets(@Param("tdmx_tdfls") String tdmx_tdfls);

	@Select("select * from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_gbbz=0 ")
	public List<Fd_XSTDMX> getListbytdls(String tdmx_tdls);

	/**
	 * 根据提单分录和车牌号获取提单明细
	 * @param tdmx_tdls
	 * @param tdmx_fdcph
	 * @return
	 */
	@Select("select * from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_fdcph=#{tdmx_fdcph} and tdmx_gbbz=0 ")
	public List<Fd_XSTDMX> getListByTdlsAndCph(@Param("tdmx_tdls") String tdmx_tdls,@Param("tdmx_fdcph")String tdmx_fdcph);

	/**不要用了可能是两条记录，没有关闭标志**/
	@Deprecated
	@Select("select * from fd_xstdmx where tdmx_pch=#{tdmx_pch} ")
	public Fd_XSTDMX getbyPCH(String tdmx_pch);
	/**改为 按照批次号和车牌号查找未关闭的明细**/
	@Select("select top 1  a.* "
			+ "from fd_xstdmx a LEFT JOIN fd_xstd b on a.tdmx_tdls=b.td_tdls "
			+ "LEFT JOIN fd_vehicle_xstd c on b.td_tdbh=c.xstdNo "
			+ "where a.tdmx_pch=#{tdmx_pch} and c.vehicleId=#{vehicleId} and tdmx_gbbz=0")
	public Fd_XSTDMX getbyPCHONE(@Param("tdmx_pch") String tdmx_pch,@Param("vehicleId") String vehicleId);
	/**改为 按照批次号和提单编号查找未关闭的明细**/
	@Select("select top 1  a.* from fd_xstdmx a LEFT JOIN fd_xstd b on a.tdmx_tdls=b.td_tdls "
			+ "where a.tdmx_pch=#{tdmx_pch} and b.td_tdbh=#{tdNo} and tdmx_gbbz=0 ")
	public Fd_XSTDMX getbyPCHandTDNOONE(@Param("tdmx_pch") String tdmx_pch,@Param("tdNo") String tdNo);

	@Delete("delete from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_zcbz=0 ")
	public int delbyTDLS(String tdmx_tdls);
	@Delete("delete from fd_xstdmx where tdmx_tdfl=#{tdmx_tdfl}")
	public int del(String tdmx_tdfl);

	@Update("update fd_xstdmx set tdmx_fdcph=#{tdmx_fdcph},"
			+ "tdmx_fdbz=#{tdmx_fdbz},tdmx_fdywbh=#{tdmx_fdywbh},tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} where tdmx_tdfl=#{tdmx_tdfl}")
	public int updateFD(Fd_XSTDMX tdmx);

	@Update("update fd_xstdmx set tdmx_fdcph=#{tdmx_fdcph},tdmx_fdbz=#{tdmx_fdbz},tdmx_fdywbh=#{tdmx_fdywbh},tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} where tdmx_tdls=#{tdmx_tdls} and tdmx_gbbz=0 and tdmx_fdbz=0 and tdmx_zcbz=0 ")
	public int updateFDBatch(Fd_XSTDMX tdmx);

	@Update("update fd_xstdmx set tdmx_fdcph=null,tdmx_fdbz=0,tdmx_fdywbh=null,tdmx_fdwlgsbh=null where tdmx_tdls=#{tdmx_tdls} and tdmx_fdywbh=#{tdmx_fdywbh} and tdmx_gbbz=0 and tdmx_fdbz!=0 and tdmx_zcbz=0")
	public int cancelFDBatch(@Param("tdmx_tdls") String tdmx_tdls,@Param("tdmx_fdywbh") String tdmx_fdywbh);


	@Update("update fd_xstdmx set tdmx_zccph=#{tdmx_zccph},tdmx_zcbz=#{tdmx_zcbz},"
			+ "tdmx_zcwlgsName=#{tdmx_zcwlgsName},tdmx_zcdriver=#{tdmx_zcdriver},tdmx_zcphone=#{tdmx_zcphone} "
			+ "where tdmx_tdfl=#{tdmx_tdfl}")
	public int updateZC(Fd_XSTDMX tdmx);

	@Update("update fd_xstdmx set tdmx_zccph=#{tdmx_zccph},tdmx_zcbz=#{tdmx_zcbz},"
			+ "tdmx_zcwlgsName=#{tdmx_zcwlgsName},tdmx_zcdriver=#{tdmx_zcdriver},tdmx_zcphone=#{tdmx_zcphone},tdmx_fdbz=0,tdmx_fdcph=null,tdmx_fdwlgsbh=null,tdmx_fdywbh=null "
			+ "where tdmx_tdfl=#{tdmx_tdfl}")
	public int updateZCANDFD(Fd_XSTDMX tdmx);

	@Update({
			"<script>",
			"update fd_xstdmx set tdmx_zccph=#{tdmx_zccph},tdmx_zcbz=#{tdmx_zcbz},"
			+ "tdmx_fdcph=#{tdmx_fdcph},tdmx_fdbz=#{tdmx_fdbz},tdmx_fdywbh=#{tdmx_fdywbh},"
			+ "tdmx_zcwlgsName=#{tdmx_zcwlgsName},tdmx_zcdriver=#{tdmx_zcdriver},tdmx_zcphone=#{tdmx_zcphone},",
			"<if test=\"tdmx_fdwlgsbh !=null and tdmx_fdwlgsbh!='' \"> ",
			"tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} ",
			"</if>",
			 "where tdmx_tdfl=#{tdmx_tdfl}",
			"</script>"
	})
	public int updateZCnoFD(Fd_XSTDMX tdmx);

	@Update("update fd_xstdmx set tdmx_gbbz=#{tdmx_gbbz} where tdmx_tdfl=#{tdmx_tdfl}")
	public int updateGB(Fd_XSTDMX tdmx);

	@Select("select * from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_gbbz=0 ")
	public List<Fd_XSTDMX> getbytdls(String tdmx_tdls);
	@Select("select * from fd_xstdmx where tdmx_tdfl=#{tdmx_tdfl} and tdmx_tdls=#{tdmx_tdls}")
	public Fd_XSTDMX getbytdflAndtdls(@Param("tdmx_tdfl") String tdmx_tdfl,@Param("tdmx_tdls") String tdmx_tdls);

//	@Select("select count(1) from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_gbbz=0 and (tdmx_fdbz!=0 or tdmx_zcbz!=0)")
	@Select("select count(1) from fd_xstdmx a LEFT JOIN fd_bsheet b on a.tdmx_fdywbh=b.bsNo  where a.tdmx_tdls=#{tdmx_tdls}  and a.tdmx_gbbz=0 and (a.tdmx_fdbz!=0 or a.tdmx_zcbz!=0) and b.status='在办' ")
	public int getbytdlswithZCorFD(String tdmx_tdls);
	@Select("select * from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_gbbz=0 and tdmx_fdbz=0 and tdmx_zcbz=0 ")
	public List<Fd_XSTDMX> getNOZCandFD(String tdmx_tdls);

	@Select("select * from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} and tdmx_fdywbh=#{tdmx_fdywbh}  and tdmx_gbbz=0 and tdmx_fdbz=1 and tdmx_zcbz=0 ")
	public List<Fd_XSTDMX> getbyBsNoandcmNo(@Param("tdmx_tdls") String tdmx_tdls,
			@Param("tdmx_fdywbh") String tdmx_fdywbh,@Param("tdmx_fdwlgsbh") String tdmx_fdwlgsbh);

	@Update("update fd_xstdmx set tdmx_fdcph=null,tdmx_fdbz=0,tdmx_fdywbh=null,tdmx_fdwlgsbh=null  where tdmx_tdls=#{tdmx_tdls} and tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} and tdmx_fdywbh=#{tdmx_fdywbh}  and tdmx_gbbz=0 and tdmx_fdbz=1 and tdmx_zcbz=0 ")
	public int updatebyBsNoandcmNo(@Param("tdmx_tdls") String tdmx_tdls,
			@Param("tdmx_fdywbh") String tdmx_fdywbh,@Param("tdmx_fdwlgsbh") String tdmx_fdwlgsbh);

	@Select("select * from fd_xstdmx where tdmx_fdywbh=#{bsNo} and tdmx_gbbz=0 and tdmx_fdbz=1 and tdmx_zcbz=0 ")
	public List<Fd_XSTDMX> getbybsNoandNOZCandFD(String bsNo);
	@Update("update fd_xstdmx set tdmx_fdcph=null,tdmx_fdbz=0,tdmx_fdywbh=null,tdmx_fdwlgsbh=null  where tdmx_fdywbh=#{bsNo} and tdmx_gbbz=0 and tdmx_fdbz=1 and tdmx_zcbz=0 ")
	public int updatebybsNoandNOZCandFD(String bsNo);
	@Select("select * from fd_xstdmx where tdmx_tdls=#{tdmx_tdls} and tdmx_zcbz=0 ")
	public List<Fd_XSTDMX> getforClose(String tdmx_tdls);


	public List<Map<String, Object>> getList(Map<String, Object> mp);
	public int countPage(Map<String, Object> mp);


	@Select("select * from fd_xstdmx where tdmx_tdls=#{tdls}  and tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} and tdmx_gbbz=0 and tdmx_fdbz!=0 and tdmx_zcbz=0   ")
	public List<Fd_XSTDMX> getbytdlsandcmNo(@Param("tdls")String tdls,@Param("tdmx_fdwlgsbh")String tdmx_fdwlgsbh);
	@Update("update fd_xstdmx set tdmx_fdcph=null,tdmx_fdbz=0,tdmx_fdywbh=null,tdmx_fdwlgsbh=null  where tdmx_tdls=#{tdls} and tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} and tdmx_gbbz=0 and tdmx_fdbz !=0 and tdmx_zcbz=0   ")
	public int updatebytdlsandcmNo(@Param("tdls")String tdls,@Param("tdmx_fdwlgsbh")String tdmx_fdwlgsbh);

	@Select("select count(1) from fd_xstdmx where tdmx_fdywbh=#{bsNo} and tdmx_tdls=#{tdls} and tdmx_zcbz=1 and tdmx_gbbz=0 and tdmx_zccph=#{vehicleId} ")
	public int getbyBsNowithZC(@Param("bsNo") String bsNo ,@Param("tdls") String tdls ,@Param("vehicleId") String vehicleId);

	@Select("select count(1) from fd_xstdmx where tdmx_fdywbh=#{bsNo}  and tdmx_zcbz=1 and tdmx_gbbz=0 and tdmx_zccph=#{vehicleId}")
	public int getbyBsNowith(@Param("bsNo") String bsNo,@Param("vehicleId") String vehicleId);

	@Select("select * from xstdmx_view where tdmx_fdywbh=#{bsNo} and tdmx_fdwlgsbh=#{tdmx_fdwlgsbh} and tdmx_sfzc=0 ")
	public List<WaitXSTDMX> getwaitMXbyBsNoandcmNo(@Param("bsNo")String bsNo,@Param("tdmx_fdwlgsbh")String tdmx_fdwlgsbh);
	@Select("select * from xstdmx_view where tdmx_fdywbh=#{bsNo} and tdmx_sfzc=0 ")
	public List<WaitXSTDMX> getwaitMXbyBsNo(@Param("bsNo")String bsNo);

	@Select("select * from fd_xstdmx")
	public List<Fd_XSTDMX> getlistA();
	@Update("update fd_xstdmx set tdmx_ggxh=#{tdmx_ggxh} where tdmx_tdfl=#{tdmx_tdfl}")
	public int updateMXGG(Fd_XSTDMX mx);

	//明晟 LED 装车
	@Select({"select  hw.name tdmx_hwmc,mx.* from fd_xstdmx mx " ,
			" left join nc_hw hw on mx.tdmx_hwbh=hw.pkid and hw.state=1 " ,
			" join xs_taskmonitor xt on mx.tdmx_fdywbh = xt.businessNo  ",
			" join fd_bsheet on bsNo=tdmx_fdywbh and status='在办' " ,
			" where SdepartNo=#{sdepartNo} and xt.firstgbtime is not null  and xt.lastgbtime is null"
	})
	public List<Map> getHwList(String sdepartNo);

	/** 义瑞、科技LED显示 序号  车号  装车区  状态 **/
	@Select({
			"select  bs.numberplates,businessNo,zcWz,firstzxhtime," ,
			"case WHEN EXISTS ( SELECT * FROM bussinessitems WHERE bussinessNo = x.businessNo ) THEN '在装'" ,
			" when x.firstgbtime is not null then '待装' else '完成' end zcStatus " ,
			" from xs_taskmonitor x" ,
			" join bussinesssheet bs on x.businessNo=bs.bussinessNo and bs.sstatus='在办' " ,
			" where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is  null order by jctime"
	})
	public List<Map> yRZcList(String sdepartNo);

}