[
    {
        "Key":"工单查询",
        "Value":"SELECT * from (
                SELECT DISTINCT
                  t.CaseNo as 案卷编号,
					ID,
					事件来源,
					事件类型,
					受理员,
					上报时间,
					客户编号,
					联系电话,
					客户名称,
					客户地址,
					发送部门,
					事项内容,
					信息类型,
					活动名称,
					派单时间,

                    w.到场时间,
                    w.结束时间,
                    w.维修员,
                    w.具体原因,
                    w.维修方法,
                    w.材质类型,     
                    w.服务内容,
                    w.原表底数,
                    w.水表口径,
                    w.新表底数,
                    w.新表编号,
                    w.封铅号,
                    w.损坏部位,
					w.主管规格
            FROM
                (
                    SELECT
                        *
                    FROM
                        (
                            SELECT
                                ID,
                                事件类型,
                                EventSource AS 事件来源,
                                CaseNo,
                                上报时间,
                                客户编号,
                                联系电话,
                                客户名称,
                                客户地址,
                                发送部门,
                                事项内容,
                                信息类型,
								派单时间,
                                isnull(活动名称, '已归档') AS 活动名称
                            FROM
                                CIV_GD_WX_CASELIST c
                            LEFT JOIN FLOWDOINGCASE f ON c.CaseNo = f.案件编号
                        ) s
                    LEFT JOIN (
                        SELECT
                            l1.案件编号,
                            l2.名称 AS 受理员
                        FROM
                            LANDFLOWGLOB l1,
                            FLOW_USERS l2
                        WHERE
                            l1.流程ID = 4
                        AND l1.活动ID = 13
                        AND l1.承办人ID = l2.用户ID
                    ) l ON s.CASENO = l.案件编号
                ) t
            LEFT JOIN (
                    SELECT
                    g.CASENO,
                    g.到场时间,
                    g.结束时间,
                    g.维修员,
                    g.具体原因,
                    g.维修方法,
                    g.材质类型,     
                    g.服务内容,
                    '' as 处理结果,
                     0 as 原表底数,
                     0 as 水表口径,
                     0 as 新表底数,
                    '' as 新表编号,
                    '' as 封铅号,
                    '' as 损坏部位,
                    cast(g.主管规格 as varchar(20)) as 主管规格
                FROM
                    CIV_GD_WX_CASELIST c,
                    CIV_GD_WX_GW_FEEDBACK g
                WHERE
                    c.CASENO = g.CASENO  
                UNION 
                SELECT
                    s.CASENO,
                    s.到场时间,
                    s.结束时间,
                    s.维修员,
                    s.具体原因,
                    s.维修方法,
                    s.材质类型,     
                    s.服务内容,
                    s.处理结果,
                    s.原表底数,
                    s.水表口径,
                    s.新表底数,
                    s.新表编号,
                    s.封铅号,
                    s.损坏部位,
                    cast(s.主管规格 as varchar(20)) as 主管规格
                    FROM
                        CIV_GD_WX_CASELIST c,
                        CIV_GD_WX_SB_FEEDBACK s
                    WHERE
                        c.CASENO = s.CASENO  
            ) w ON t.CASENO = w.CASENO
            WHERE
                len(t.CaseNo) > 0
            ) EventTable
            ",
        "Desc":"工单查询SQL语句"
    },
    {

        "Key":"维修工单导出",
        "Value":"SELECT
    distinct t1.CASENO,
    t1.事件类型,
    t1.上报时间,
    t1.客户名称,
    t1.客户编号,
    t1.联系电话,
    t1.客户地址,
    t1.事项内容,
    t1.受理员,
    isnull(t1.维修员,t2.维修员) 维修员,
    isnull(t1.服务内容,t2.服务内容) 服务内容,
    t1.派单时间,
    isnull(t1.到场时间,t2.到场时间) 到场时间,
    isnull(t1.结束时间,t2.结束时间) 结束时间,
    isnull(t1.具体原因,t2.具体原因) 具体原因,
    isnull(t1.维修方法,t2.维修方法) 维修方法,
	isnull(t1.材质类型,t2.材质类型) 材质类型,
	isnull(t1.主管规格,t2.主管规格) 主管规格,
    原表底数,
    水表口径,
    新表底数,
    新表编号,
    封铅号,
    损坏部位,
    t1.发送部门
FROM
    (
        SELECT
            c.受理员,
            c.上报时间,
            c.CASENO,
            c.发送部门,
            c.事件类型,
            c.客户名称,
            c.客户编号,
            c.事项内容,
            c.派单时间,
            维修员,
            服务内容,
            具体原因,
            维修方法,
            到场时间,
            结束时间,
			材质类型,
			cast(主管规格 as varchar(20)) as 主管规格,
            c.客户地址,
            c.联系电话
        FROM
            (
                SELECT
                    *
                FROM
                    CIV_GD_WX_CASELIST j
                LEFT JOIN (
                    SELECT
                        l.案件编号,
                        f.[名称] AS 受理员
                    FROM
                        LANDFLOWGLOB l,
                        FLOW_USERS f
                    WHERE
                        l.[活动ID] = 13
                    AND l.[流程ID] = 4
                    AND l.[承办人ID] = f.[用户ID]
                ) k ON j.CASENO = k.案件编号
            ) c
        LEFT JOIN CIV_GD_WX_GW_FEEDBACK g ON c.CASENO = g.CASENO
    ) t1,
    (
        SELECT
            c.受理员,
            c.上报时间,
            c.CASENO,
            c.发送部门,
            c.事件类型,
            c.客户名称,
            c.客户编号,
            c.客户地址,
            c.联系电话,
            c.事项内容,
            c.派单时间,
            维修员,
            服务内容,
            具体原因,
            维修方法,
            到场时间,
            结束时间,
            原表底数,
            水表口径,
            新表底数,
            新表编号,
            封铅号,
            cast(主管规格 as varchar(20)) as 主管规格,
            材质类型,
            损坏部位
        FROM
            (
                SELECT
                    *
                FROM
                    CIV_GD_WX_CASELIST j
                LEFT JOIN (
                    SELECT
                        l.案件编号,
                        f.[名称] AS 受理员
                    FROM
                        LANDFLOWGLOB l,
                        FLOW_USERS f
                    WHERE
                        l.[活动ID] = 13
                    AND l.[流程ID] = 4
                    AND l.[承办人ID] = f.[用户ID]
                ) k ON j.CASENO = k.案件编号
            ) c
        LEFT JOIN CIV_GD_WX_SB_FEEDBACK s ON c.CASENO = s.CASENO
    ) t2
WHERE
    t1.CASENO = t2.caseno and t1.CASENO in ({1})",
        "Desc":"维修工单Excel导出语句"
    },
    {
        "Key":"DelayFlowName",
        "Value":"延期",
        "Desc":"延期申请流程名称"
    },
	{
        "Key":"DelaySupName",
        "Value":"主管审批",
        "Desc":"延期流程主管审核活动名称"
    },
	{
        "Key":"FixDispatchName",
        "Value":"维修派单",
        "Desc":"维修流程维修派单活动名称"
    },
	{
        "Key":"EventSuperviseName",
        "Value":"事件审核",
        "Desc":"维修流程维修派单活动名称"
    },
	{
		"Key":"EnableDeptSecurity",
        "Value":"1",
        "Desc":"是否启用按机构做权限控制,1:是,0:否"
	},
	{
		"Key":"EnableSA",
        "Value":"1",
        "Desc":"管理员是否不受机构权限控制,1:是,0:否"
	},
	{
		"Key":"SACode",
        "Value":"1-1",
        "Desc":"管理员机构编码"
	},
	{
		"Key":"OnlineByGPS",
        "Value":"1",
        "Desc":"是否根据GPS状态决定用户在线状态,1:是,0:否"
	},
	{
		"Key":"UserType_maintain",
        "Value":"2",
        "Desc":"维修员用户标识(不建议修改)"
	},
	{
		"Key":"WeiXiu_Code",
        "Value":"1003",
        "Desc":"维修流程编码"
	},
	{
		"Key":"MobileNode",
        "Value":"温泉现场维修,咸安现场维修",
        "Desc":"手持端节点"
	}
]