package com.mandi.fendan.mapper;

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

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.mandi.fendan.util.persist.Serviceenum;

/**
 * 一卡通数据取值
 * @author 15083
 *
 */
public interface Fd_YKTMapper {
	
	@Select("select a.* from enterworker a left join users b on a.userid=b.id where b.username=#{username}")
	public Map<String, Object> findWorkerByUserName(String username);
	@Update("update bussinesssheet set canedit='不可编辑',sstatus='终止' where bussinessNo=#{bussinessNo} ")
	public int endBsheet(String bussinessNo);
	@Delete("delete from bussinesssheet  where bussinessNo=#{bussinessNo} ")
	public int delBsheet(String bussinessNo);
	@Select("select * from cardinuse where cardno=#{cardno} ")
	public Map<String, Object> getcardinuse(String cardno);
	@Select("select * from vehicle_queuing where numberplates=#{vehicleId} and gatesNo=#{gatesNo} ")
	public Map<String, Object> getpdindx(@Param("vehicleId") String vehicleId,@Param("gatesNo") String gatesNo);
	@Select("select top 1 a.* from bussinesssheet a left join gbusi_type b  on a.btid=b.id where b.businesstypeNo=#{btNo} and a.numberplates=#{vehicleID} and a.sstatus=#{sstatus} and a.sdepartNo=#{sdepartNo} ")
	public Map<String, Object> getBsheet(@Param("vehicleID") String vehicleID,@Param("btNo") String btNo,@Param("sstatus") Serviceenum status,@Param("sdepartNo") String sdepartNo);
	@Select("select top 1 * from cardinuse where numberplates=#{vehicleId}")
	public Map<String, Object> getcardbyVehicleID(String vehicleId);
	@Update("update bussinesssheet set rcompany=#{shcompany},rcID=#{rcID} where bussinessNo=#{bussinessNo} ")
	public int updateshcompany(@Param("bussinessNo")String bussinessNo,@Param("shcompany") String shcompany,@Param("rcID") String rcID);
	
	@Select("select count(1) from weight_doc where businessNo=#{bussinessNo} and wdstate='正常' ")
	public int getweight_doc(@Param("bussinessNo")String bussinessNo);
	
	@Select("SELECT ISNULL(SUM(a.gross),0) gross,ISNULL(SUM(a.tare),0) tare from weight_doc a where a.businessNo=#{bussinessNo} and a.wdstate='正常'  ")
	public Map<String, Object> getweight_docgt(@Param("bussinessNo")String bussinessNo);
	
	@Select("SELECT DISTINCT(b.username) FROM worker_depart a LEFT JOIN users b on a.userid=b.id LEFT JOIN enterworker e on a.workerNo=e.gonghao where a.departNo=#{bianhao} and e.state=1 and b.id is not null  ")
	public List<String> getUserNsByDepart(String bianhao);
	
	
}