| | |
| | | <result property="masterNames" column="master_names" /> |
| | | <result property="transactionIds" column="transaction_ids" /> |
| | | <result property="transactionNames" column="transaction_names" /> |
| | | <result property="openid" column="openid" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectSysUserVo"> |
| | |
| | | master_names, |
| | | transaction_ids, |
| | | transaction_names, |
| | | openid, |
| | | (select organization_name from automessage_organization_chart where automessage_sys_user.department_id=automessage_organization_chart.id) as department_name |
| | | FROM |
| | | automessage_sys_user |
| | |
| | | <if test="masterNames != null and masterNames != '' ">,master_names</if> |
| | | <if test="transactionIds != null and transactionIds != '' ">,transaction_ids</if> |
| | | <if test="transactionNames != null and transactionNames != '' ">,transaction_names</if> |
| | | <if test="openid != null and openid != '' ">,openid</if> |
| | | )values( |
| | | sysdate() |
| | | <if test="userId != null and userId != '' ">,#{userId}</if> |
| | |
| | | <if test="masterNames != null and masterNames != '' ">,#{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> |
| | | ) |
| | | </insert> |
| | | |
| | |
| | | <if test="masterNames != null and masterNames != '' ">,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> |
| | | ,update_time=sysdate() |
| | | </set> |
| | | where user_id= #{userId} |