| | |
| | | <if test="departmentName != null and departmentName != '' ">,#{departmentName}</if> |
| | | <if test="departmentArea != null and departmentArea != '' ">,#{departmentArea}</if> |
| | | <if test="leisureState != null and leisureState != '' ">,#{leisureState}</if> |
| | | <if test="masterIds != null and masterIds != '' ">,#{masterIds}</if> |
| | | <if test="masterNames != null and masterNames != '' ">,#{masterNames}</if> |
| | | <if test="masterIds != null ">,#{masterIds}</if> |
| | | <if test="masterNames != null ' ">,#{masterNames}</if> |
| | | <if test="transactionIds != null and transactionIds != '' ">,#{transactionIds}</if> |
| | | <if test="transactionNames != null and transactionNames != '' ">,#{transactionNames}</if> |
| | | <if test="openid != null and openid != '' ">,#{openid}</if> |
| | | <if test="isDivisionHead != null and isDivisionHead != '' ">,#{isDivisionHead}</if> |
| | | <if test="mattersIds != null and mattersIds != '' ">,#{mattersIds}</if> |
| | | <if test="mattersIds != null ">,#{mattersIds}</if> |
| | | ) |
| | | </insert> |
| | | |
| | |
| | | <if test="departmentName != null and departmentName != '' ">,department_name=#{departmentName}</if> |
| | | <if test="departmentArea != null and departmentArea != '' ">,department_area=#{departmentArea}</if> |
| | | <if test="leisureState != null and leisureState != '' ">,leisure_state=#{leisureState}</if> |
| | | <if test="masterIds != null and masterIds != '' ">,master_ids=#{masterIds}</if> |
| | | <if test="masterNames != null and masterNames != '' ">,master_names=#{masterNames}</if> |
| | | <if test="masterIds != null ">,master_ids=#{masterIds}</if> |
| | | <if test="masterNames != null ">,master_names=#{masterNames}</if> |
| | | <if test="transactionIds != null and transactionIds != '' ">,transaction_ids=#{transactionIds}</if> |
| | | <if test="transactionNames != null and transactionNames != '' ">,transaction_names=#{transactionNames}</if> |
| | | <if test="openid != null and openid != '' ">,openid=#{openid}</if> |
| | | <if test="isDivisionHead != null and isDivisionHead != '' ">,is_division_head=#{isDivisionHead}</if> |
| | | <if test="mattersIds != null and mattersIds != '' ">,matters_ids=#{mattersIds}</if> |
| | | <if test="mattersIds != null ">,matters_ids=#{mattersIds}</if> |
| | | ,update_time=sysdate() |
| | | </set> |
| | | where user_id= #{userId} |