a.id AS "id", a.member_code AS "memberCode", a.member_name AS "memberName", a.content AS "content", a.content_value AS "contentValue", a.reissue_content_value AS "reissueContentValue", a.express_type AS "expressType", a.express_name AS "expressName", a.express_no AS "expressNo", a.address AS "address", a.postcode AS "postcode", a.receiver AS "receiver", a.receive_date AS "receiveDate", a.post_date AS "postDate", a.phone AS "phone", a.create_date AS "createDate", a.create_by AS "createBy.id", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.print_state AS "printState", a.send_remarks AS "sendRemarks", a.sender AS "sender", a.send_address AS "sendAddress", a.send_phone AS "sendPhone", a.sender_detail AS "senderDetail", a.other_express_no AS "otherExpressNo", a.province as "province", a.city as "city", a.area as "area", a.origincode as "origincode", a.destcode as "destcode", a.two_dimension_code as "twoDimensionCode", a.pro_code as "proCode", a.print_icon as "printIcon", a.dest_route_label as "destRouteLabel", a.dest_team_code as "destTeamCode", a.coding_mapping as "codingMapping", a.cloud_print_url AS "cloudPrintUrl" SELECT FROM sys_express_send a WHERE a.id = #{id} SELECT FROM sys_express_send a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.member_name = #{memberName} AND a.content LIKE '%'||#{content}||'%' '%'+#{content}+'%' concat('%',#{content},'%') AND a.express_type = #{expressType} AND a.express_name = #{expressName} AND a.express_no = #{expressNo} AND a.address = #{address} AND a.postcode = #{postcode} AND a.receiver = #{receiver} AND a.receive_date = #{receiveDate} AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{beginCreateDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endCreateDate}, '%Y-%m-%d') AND a.phone = #{phone} AND a.send_remarks LIKE '%'||#{sendRemarks}||'%' '%'+#{sendRemarks}+'%' concat('%',#{sendRemarks},'%') ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM sys_express_send a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO sys_express_send( id, member_code, member_name, content, content_value, reissue_content_value, express_type, express_name, express_no, address, postcode, receiver, receive_date, post_date, phone, create_date, create_by, update_by, update_date, remarks, del_flag, send_remarks, sender, send_address, send_phone, sender_detail, other_express_no, province, city, area, origincode, destcode ) VALUES ( #{id}, #{memberCode}, #{memberName}, #{content}, #{contentValue}, #{reissueContentValue}, #{expressType}, #{expressName}, #{expressNo}, #{address}, #{postcode}, #{receiver}, #{receiveDate}, #{postDate}, #{phone}, #{createDate}, #{createBy.id}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{sendRemarks}, #{sender}, #{sendAddress}, #{sendPhone}, #{senderDetail}, #{otherExpressNo}, #{province}, #{city}, #{area}, #{origincode}, #{destcode} ) UPDATE sys_express_send SET member_code = #{memberCode}, member_name = #{memberName}, content = #{content}, content_value = #{contentValue}, reissue_content_value = #{reissueContentValue}, express_type = #{expressType}, express_name = #{expressName}, express_no = #{expressNo}, address = #{address}, postcode = #{postcode}, receiver = #{receiver}, receive_date = #{receiveDate}, post_date = #{postDate}, phone = #{phone}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, send_remarks = #{sendRemarks}, sender = #{sender}, send_address = #{sendAddress}, send_phone = #{sendPhone}, sender_detail = #{senderDetail}, other_express_no = #{otherExpressNo}, province = #{province}, city = #{city}, area = #{area}, origincode = #{origincode}, destcode = #{destcode} WHERE id = #{id} UPDATE sys_express_send SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE sys_express_send SET print_state = #{printState} WHERE id = #{id} SELECT a.express_name AS "expressName", a.express_no AS "expressNo" FROM sys_express_send a WHERE a.member_code = #{memberCode} AND a.del_flag = '0' AND a.content LIKE CONCAT('%',#{content},'%') ORDER BY a.create_date DESC LIMIT 1 SELECT a.id AS "id", a.express_name AS "expressName", a.express_no AS "expressNo", a.other_express_no AS "otherExpressNo", a.phone AS "phone" FROM sys_express_send a WHERE a.express_no = #{expressNo} AND a.del_flag = '0' ORDER BY a.create_date DESC LIMIT 1 update sys_express_send set receive_date = #{receiveDate} where express_no = #{expressNo} SELECT express_no AS "expressNo" FROM sys_express_send WHERE receive_date IS NULL AND DATE_ADD(post_date,INTERVAL 5 DAY) < NOW() AND post_date > "2020-02-01 00:00:00" select count(1) from sys_express_send where other_express_no = #{otherExpressNo} update sys_express_send set cloud_print_url = #{url} where other_express_no = #{otherExpressNo}