增加或修改
insert into history_order
(update_time,update_by,create_time,create_by,customer_phone,box_no,region_id,partner_id,terminal_no,order_id,oid)
values
<foreach collection="list" item="history" separator=",">
(#{history.updateTime},#{history.updateBy},#{history.createTime},#{history.createBy}, #{history.customerPhone},#{history.boxNo},#{history.regionId},
#{history.regionId},#{history.terminalNo},#{history.orderId}, #{history.oid})
</foreach>
ON DUPLICATE KEY UPDATE
update_time = VALUES ( `update_time`),
pick_up_cleartext = VALUES ( `pick_up_cleartext`),
customer_email = VALUES ( `customer_email`),
customer_phone = VALUES ( `customer_phone`);
查询,传两个参数的,一个实体,一个其它类型
dao层
sql
查询,传一个list,一个其它类型
dao层
sql
查询今日订单
SELECT COUNT( * ) AS a FROM inbox_order WHERE TO_DAYS( inbox_time ) = TO_DAYS( NOW( ) ) AND partner_id = #{partnerId}
查询昨日订单
SELECT COUNT(*) FROM inbox_order WHERE TO_DAYS( NOW() ) - TO_DAYS( inbox_time) = 1
同步两个表中的电话号码
UPDATE sys_user a SET a.phonenumber = (SELECT b.phone FROM app_user_info b WHERE b.user_id = a.user_id)
WHERE EXISTS(SELECT 1 FROM app_user_info b WHERE b.user_id = a.user_id)
根据条件选择进入
<choose>
<when test="associatesId == null">
AND ad.delivery_mode != 3
</when>
<otherwise>
AND abi.associates_id = #{associatesId}
</otherwise>
</choose>