修改【办事指南】需求变更 bug

lidongdong

2022-10-18 87133c5faa4f4787cf6bdaf118910dab52e87bcd

修改【办事指南】需求变更 bug

 flower_city/src/main/java/com/dg/core/db/gen/entity/TransactionEvent.java

@@ -247,6 +247,15 @@
    private String commonProblemName;


    @ApiModelProperty("办理区域")
    private String transactionArea;

    @ApiModelProperty("办理区域url")
    private String transactionAreaUrl;

    @ApiModelProperty("办理区域文件名称")
    private String transactionAreaName;


    @TableField(exist = false)
    @ApiModelProperty(name = "sumTransactionNum", value = "导办服务数量")

 flower_city/src/main/resources/mapper/TransactionEventMapper.xml

@@ -44,6 +44,9 @@
        <id     property="commonProblemName"      column="common_problem_name"      />
        <id     property="operationalGuidelineVideoName"      column="operational_guideline_video_name"      />
        <id     property="operationalGuidelineName"      column="operational_guideline_name"      />
        <id     property="transactionArea"      column="transaction_area"      />
        <id     property="transactionAreaUrl"      column="transaction_area_url"      />
        <id     property="transactionAreaName"      column="transaction_area_name"      />

    </resultMap>

@@ -88,6 +91,9 @@
            operational_guideline_video_url,
            operational_guideline_video_name,
            operational_guideline_name,
            transaction_area,
            transaction_area_url,
            transaction_area_name,
            (IF((select classify_grade from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)='2',
                (select classify_name from automessage_classify_administration where automessage_classify_administration.id=(select parent_id from
                automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)),
@@ -193,6 +199,9 @@
        <if test="commonProblemName != null and commonProblemName != '' ">common_problem_name,</if>
        <if test="operationalGuidelineVideoName != null and operationalGuidelineVideoName != '' ">operational_guideline_video_name,</if>
        <if test="operationalGuidelineName != null and operationalGuidelineName != '' ">operational_guideline_name,</if>
        <if test="transactionArea != null ">transaction_area,</if>
        <if test="transactionAreaUrl != null ">transaction_area_url,</if>
        <if test="transactionAreaName != null ">transaction_area_name,</if>
        update_time,
        create_time
        )values(
@@ -231,6 +240,9 @@
        <if test="commonProblemName != null and commonProblemName != '' ">#{commonProblemName},</if>
        <if test="operationalGuidelineVideoName != null and operationalGuidelineVideoName != '' ">#{operationalGuidelineVideoName},</if>
        <if test="operationalGuidelineName != null and operationalGuidelineName != '' ">#{operationalGuidelineName},</if>
        <if test="transactionArea != null ">#{transactionArea},</if>
        <if test="transactionAreaUrl != null ">#{transactionAreaUrl},</if>
        <if test="transactionAreaName != null ">#{transactionAreaName},</if>
        sysdate(),
        sysdate()
        )
@@ -274,6 +286,9 @@
            <if test="operationalGuidelineVideoUrl != null ">operational_guideline_video_url=#{operationalGuidelineVideoUrl},</if>
            <if test="operationalGuidelineVideoName != null and operationalGuidelineVideoName != '' ">operational_guideline_video_name=#{operationalGuidelineVideoName},</if>
            <if test="operationalGuidelineName != null and operationalGuidelineName != '' ">operational_guideline_name=#{operationalGuidelineName},</if>
            <if test="transactionArea != null ">transaction_area=#{transactionArea},</if>
            <if test="transactionAreaUrl != null ">transaction_area_url=#{transactionAreaUrl},</if>
            <if test="transactionAreaName != null ">transaction_area_name=#{transactionAreaName},</if>
            update_time=sysdate()
        </set>
        where  id= #{id}