a.id AS "id", a.biz_id AS "bizId", a.biz_type AS "bizType", a.nose_id AS "noseId", a.nose_code AS "noseCode", a.device_number AS "deviceNumber", a.device_platform AS "devicePlatform", a.device_model AS "deviceModel", a.device_version AS "deviceVersion", a.device_information AS "deviceInformation", a.operator_id AS "operatorId", a.operator_code AS "operatorCode", a.operator_time AS "operatorTime", a.checkin_status AS "checkinStatus", a.checkin_fail_reason AS "checkinFailReason", a.notify_time AS "notifyTime", a.del_flag AS "delFlag", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate" SELECT FROM dog_nose_checkin a WHERE a.id = #{id} SELECT FROM dog_nose_checkin a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_nose_checkin a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_nose_checkin a a.del_flag = '0' AND a.nose_id = #{noseId} SELECT max(RIGHT(nose_code,7)) as n FROM dog_nose_checkin WHERE LEFT(nose_code,8) = DATE_FORMAT(NOW(),'%Y%m%d') INSERT INTO dog_nose_checkin( id, biz_id, biz_type, nose_id, nose_code, device_number, device_platform, device_model, device_version, device_information, operator_id, operator_code, operator_time, checkin_status, checkin_fail_reason, notify_time, del_flag, create_by, create_date, update_by, update_date ) VALUES ( #{id}, #{bizId}, #{bizType}, #{noseId}, #{noseCode}, #{deviceNumber}, #{devicePlatform}, #{deviceModel}, #{deviceVersion}, #{deviceInformation}, #{operatorId}, #{operatorCode}, #{operatorTime}, #{checkinStatus}, #{checkinFailReason}, #{notifyTime}, #{delFlag}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate} ) UPDATE dog_nose_checkin SET biz_id = #{bizId}, biz_type = #{bizType}, nose_id = #{noseId}, nose_code = #{noseCode}, device_number = #{deviceNumber}, device_platform = #{devicePlatform}, device_model = #{deviceModel}, device_version = #{deviceVersion}, device_information = #{deviceInformation}, operator_id = #{operatorId}, operator_code = #{operatorCode}, operator_time = #{operatorTime}, checkin_status = #{checkinStatus}, checkin_fail_reason = #{checkinFailReason}, notify_time = #{notifyTime}, update_by = #{updateBy.id}, update_date = #{updateDate} WHERE id = #{id} UPDATE dog_nose_checkin SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}