| | |
| | | <id property="commonProblem" column="common_problem" /> |
| | | <id property="commonProblemUrl" column="common_problem_url" /> |
| | | <id property="commonProblemName" column="common_problem_name" /> |
| | | <id property="operationalGuidelineVideoName" column="operational_guideline_video_name" /> |
| | | <id property="operationalGuidelineName" column="operational_guideline_name" /> |
| | | |
| | | </resultMap> |
| | | |
| | |
| | | common_problem_url, |
| | | common_problem_name, |
| | | operational_guideline_video_url, |
| | | operational_guideline_video_name, |
| | | operational_guideline_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)), |
| | |
| | | <if test="commonProblem != null and commonProblem != '' ">common_problem,</if> |
| | | <if test="commonProblemUrl != null and commonProblemUrl != '' ">common_problem_url,</if> |
| | | <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> |
| | | update_time, |
| | | create_time |
| | | )values( |
| | |
| | | <if test="commonProblem != null and commonProblem != '' ">#{commonProblem},</if> |
| | | <if test="commonProblemUrl != null and commonProblemUrl != '' ">#{commonProblemUrl},</if> |
| | | <if test="commonProblemName != null and commonProblemName != '' ">#{commonProblemName},</if> |
| | | <if test="operationalGuidelineVideoName != null and operationalGuidelineVideoName != '' ">#{operationalGuidelineVideoName},</if> |
| | | <if test="operationalGuidelineName != null and operationalGuidelineName != '' ">#{operationalGuidelineName},</if> |
| | | sysdate(), |
| | | sysdate() |
| | | ) |
| | |
| | | <if test="commonProblemUrl != null and commonProblemUrl != '' ">common_problem_url=#{commonProblemUrl},</if> |
| | | <if test="commonProblemName != null and commonProblemName != '' ">common_problem_name=#{commonProblemName},</if> |
| | | <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> |
| | | update_time=sysdate() |
| | | </set> |
| | | where id= #{id} |