<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.securitycontrol.inter.mapper.BdMapper">
    <insert id="insertData">
        insert  into  tb_bd_device(device_id,devic_type,status,device_name,create_time,bd_id,remarks,del_flag)
                value (
                    #{deviceId},#{deviceModelId},0,#{deviceName},now(),#{gatewayId},#{description},0
                )
    </insert>
    <insert id="insertWarn">
        insert into  tb_warn (warn_time,warn_content,warn_type,bd_device,db_id,bid_code)
            value (#{eventTime},#{eventDesc},#{eventCode},#{deviceId},#{gatewayId},#{bidCode})
    </insert>
    <update id="bindBdPro">
        update tb_pro_bd set bid_code=#{bidNo},bind_time=now()  where bd_code=#{gatewayId} ;
    </update>
    <update id="deviceDel">
            update tb_bd_device set  del_flag=1 where device_id=#{deviceId} and bd_id=#{gatewayId}
    </update>
    <update id="deviceStatus">
        update tb_bd_device set  status=#{state} where device_id=#{deviceId} and bd_id=#{gatewayId}
    </update>
    <!--查询工程名称-->
    <select id="getProjectByName" resultType="com.securitycontrol.inter.vo.ProjectVo">
        select id,pro_name projectName,pro_no projectNo,tjp.org_id builderNo,
                sb.city_name builderName,vlotage volLevel,pro_type projectType
            from tb_jj_project tjp
            left join sys_build sb on sb.org_id=tjp.org_id
            <where>
                <if test="projectName!=null and projectName!=''">
                     AND pro_name like('%',#{projectName},'%')
                </if>
            </where>
    </select>
    <!--查询单项工程信息-->
    <select id="getPepsinInfoByPrcNo" resultType="com.securitycontrol.inter.vo.SingleProVo">
        select
            id,single_name singleName,signle_no singleNo,wbs_code wbsCode,
            project_no projectNo,single_desc singleDesc,vol_level volLevel,
            line_length lineLength,subs_cap subsCap,pro_type singleTypeCode,
            subs_type subsTypeCode,estimate_type estimateTypeCode,tjp.org_id builderNo,
            start_date startDate,end_date productDate,complete_date completeDate,sb.city_name builderName
            from tb_sign_project tjp
            LEFT JOIN sys_build sb on sb.org_id=tjp.org_id
            <where>
                <if test="projectNo!=null and projectNo!=''">
                    AND tjp.project_no =#{projectNo}
                </if>
            </where>
    </select>
    <select id="getSGTenderListBySinList" resultType="com.securitycontrol.inter.vo.BidProjectVo">
            select
			bid.pro_id id,bid.sign_code singleNo,bid.bid_code bidNo,
			bid.pro_code projectCode,bid.pro_name bidName,bid.pro_cost,
			bid.sg_unit,bid.jl_unit,bid.pro_type,
			bid.pro_scale,bid.manager,bid.status,
			bid.plan_start_time,bid.plan_end_time,
			bid.start_time startDate,bid.end_time completeDate,bid.tc_date productDate,
			bid.org,bid.bid_type bidType,
			bid.sg_manage buildManager,bid.jl_manage chiefSuperVice,bid.sub_type subsTypeCode
		from tb_project bid
		WHERE del_flag=0
            <if test="signList !=null and signList.size() >0 ">
                <foreach collection="signList" open=" and sign_code in(" close=")" item="item" separator=",">
                       #{item}
                </foreach>
            </if>
    </select>
    <!--查询人员数据u录入-->
    <select id="getPeopleInfo" resultType="com.securitycontrol.inter.vo.UserInfoVo">
            select twt.team_name workClassName,twt.team_leader,ttp.id_number idCard,
                ttp.user_name name,ttp.user_type jobType,ttp.phone mobile
			,jp.pro_name projectName,  twt.bid_code bidNo,ttp.user_id userId
			from tb_work_team twt
			left join  tb_project bid on twt.bid_code=bid.bid_code
			left join t_team_people ttp on twt.team_id=ttp.team_id
			left join tb_jj_project jp on jp.pro_no=bid.pro_code
		where ttp.id_number is not null
    </select>
    <select id="getDeviceNumById" resultType="java.lang.Integer">
        select count(1)
             from tb_bd_device
               where del_flag=0 and device_id=#{deviceId}
    </select>
    <select id="getBidCodeByBd" resultType="java.lang.String">
         select
             bid_code
              from tb_pro_bd
              where   bd_code=#{gatewayId}
    </select>
</mapper>