| | |
| | | <id property="transactionArea" column="transaction_area" /> |
| | | <id property="transactionAreaUrl" column="transaction_area_url" /> |
| | | <id property="transactionAreaName" column="transaction_area_name" /> |
| | | <id property="classifyIds" column="classify_ids" /> |
| | | |
| | | </resultMap> |
| | | |
| | |
| | | transaction_area, |
| | | transaction_area_url, |
| | | transaction_area_name, |
| | | classify_ids, |
| | | (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="transactionArea != null ">transaction_area,</if> |
| | | <if test="transactionAreaUrl != null ">transaction_area_url,</if> |
| | | <if test="transactionAreaName != null ">transaction_area_name,</if> |
| | | <if test="classifyIds != null ">classify_ids,</if> |
| | | update_time, |
| | | create_time |
| | | )values( |
| | |
| | | <if test="transactionArea != null ">#{transactionArea},</if> |
| | | <if test="transactionAreaUrl != null ">#{transactionAreaUrl},</if> |
| | | <if test="transactionAreaName != null ">#{transactionAreaName},</if> |
| | | <if test="classifyIds != null ">#{classifyIds},</if> |
| | | sysdate(), |
| | | sysdate() |
| | | ) |
| | |
| | | <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> |
| | | <if test="classifyIds != null ">classify_ids=#{classifyIds},</if> |
| | | update_time=sysdate() |
| | | </set> |
| | | where id= #{id} |