| | |
| | | <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 ">,#{masterIds}</if> |
| | | <if test="masterNames != null ' ">,#{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 ">,#{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 ">,master_ids=#{masterIds}</if> |
| | | <if test="masterNames != null ">,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 ">,matters_ids=#{mattersIds}</if> |
| | | <if test="mattersIds != null">,matters_ids=#{mattersIds}</if> |
| | | ,update_time=sysdate() |
| | | </set> |
| | | where user_id= #{userId} |