SELECT t.user_name username ,s.STAFF_NAME name ,t.user_password password ,s.STAFF_IDCODE identityCard ,s.STAFF_PUNIT industryTitle ,IF(LENGTH(s.STAFF_LEADERPOST)>0,'ADMIN','APPROVE') role ,s.STAFF_GENDER sex ,s.STAFF_CODE alarm ,s.STAFF_SCODE organCode ,s.STAFF_PHONE trombone ,t.create_user createId ,t.create_time createDate ,t.update_user modifiedId ,t.update_time modifiedDate FROM sys_user t INNER JOIN sys_staff s ON t.staff_id = s.staff_id WHERE 1=1 AND t.user_status='1' AND t.del_flag='0' AND (instr(date_format(t.create_time, '%Y-%m-%d'),#{day}) OR instr(date_format(t.update_time, '%Y-%m-%d'),#{day})) SELECT act_no FROM dxab_activity WHERE instr(create_time, #{day}) OR instr(create_time, #{day}) SELECT CONCAT(act_id,'') FROM dxab_activity WHERE act_id = #{activityId} SELECT s.STAFF_IDCODE FROM sys_user t INNER JOIN sys_staff s ON t.staff_id = s.staff_id WHERE 1=1 AND t.user_status='1' AND t.del_flag='0' AND t.user_name = #{username} SELECT t.user_name FROM sys_user t INNER JOIN sys_staff s ON t.staff_id = s.staff_id WHERE 1=1 AND t.user_status='1' AND t.del_flag='0' AND s.STAFF_IDCODE = #{idCode} insert into dxab_activity act_id, act_name, act_no, act_type, max_person_number, site_area, sold_tickets_number, begin_time, end_time, hold_addr, act_content, approval_status, archive_status, data_source, create_time, update_time, act_duty_leader_staff_id, act_duty_leader_staff_code, act_duty_leader_staff_name, act_duty_leader_station_id, act_duty_staff_id, act_duty_staff_code, act_duty_staff_name, act_duty_station_id, act_report_time, safe_license_status, daily_attend_person, organizer_unit, organizer_regist, report_unit, security_power_number, staff_number, security_number, volunteer_number, responsible_unit, risk_level, security_check, security_programme, act_duty_leader_staff_phone, act_duty_staff_phone, act_site_leader_staff_phone, act_site_leader_staff_id, act_site_leader_staff_code, #{actId}, #{actName}, #{actNo}, #{actType}, #{maxPersonNumber}, #{siteArea}, #{soldTicketsNumber}, #{beginTime}, #{endTime}, #{holdAddr}, #{actContent}, #{approvalStatus}, #{archiveStatus}, #{dataSource}, #{createTime}, #{updateTime}, #{actDutyLeaderStaffId}, #{actDutyLeaderStaffCode}, #{actDutyLeaderStaffName}, #{actDutyLeaderStationId}, #{actDutyStaffId}, #{actDutyStaffCode}, #{actDutyStaffName}, #{actDutyStationId}, #{actReportTime}, #{safeLicenseStatus}, #{dailyAttendPerson}, #{organizerUnit}, #{organizerRegist}, #{reportUnit}, #{securityPowerNumber}, #{staffNumber}, #{securityNumber}, #{volunteerNumber}, #{responsibleUnit}, #{riskLevel}, #{securityCheck}, #{securityProgramme}, #{actDutyLeaderStaffPhone}, #{actDutyStaffPhone}, #{actSiteLeaderStaffPhone}, #{actSiteLeaderStaffId}, #{actSiteLeaderStaffCode}, #{actSiteLeaderStaffName}, #{actSiteLeaderStationId}, update dxab_activity act_type = #{actType}, max_person_number = #{maxPersonNumber}, site_area = #{siteArea}, sold_tickets_number = #{soldTicketsNumber}, begin_time = #{beginTime}, end_time = #{endTime}, hold_addr = #{holdAddr}, act_content = #{actContent}, approval_status = #{approvalStatus}, archive_status = #{archiveStatus}, data_source = #{dataSource}, update_time = #{updateTime}, act_duty_leader_staff_id = #{actDutyLeaderStaffId}, act_duty_leader_staff_code = #{actDutyLeaderStaffCode}, act_duty_leader_staff_name = #{actDutyLeaderStaffName}, act_duty_leader_station_id = #{actDutyLeaderStationId}, act_duty_staff_id = #{actDutyStaffId}, act_duty_staff_code = #{actDutyStaffCode}, act_duty_staff_name = #{actDutyStaffName}, act_duty_station_id = #{actDutyStationId}, act_report_time = #{actReportTime}, safe_license_status = #{safeLicenseStatus}, daily_attend_person = #{dailyAttendPerson}, organizer_unit = #{organizerUnit}, organizer_regist = #{organizerRegist}, report_unit = #{reportUnit}, security_power_number = #{securityPowerNumber}, staff_number = #{staffNumber}, security_number = #{securityNumber}, volunteer_number = #{volunteerNumber}, responsible_unit = #{responsibleUnit}, risk_level = #{riskLevel}, security_check = #{securityCheck}, security_programme = #{securityProgramme}, act_duty_leader_staff_phone = #{actDutyLeaderStaffPhone}, act_duty_staff_phone = #{actDutyStaffPhone}, act_site_leader_staff_phone = #{actSiteLeaderStaffPhone}, act_site_leader_staff_id = #{actSiteLeaderStaffId}, act_site_leader_staff_code = #{actSiteLeaderStaffCode}, where act_no = #{actNo} update dxab_activity approval_status = #{approvalStatus}, update_time = now() where act_no = #{actNo} delete from sys_file_info where REL_ID = #{actId} INSERT INTO sys_file_info (FILE_ID, FILE_NAME, FILE_TYPE, FILE_DIR, FILE_SIZE, FILE_URL, REL_ID, FILE_NO, ORDER_NO, CREATE_TIME, FILE_TITLE) select #{item.fileId,jdbcType=VARCHAR}, #{item.fileName,jdbcType=VARCHAR}, #{item.fileType,jdbcType=VARCHAR}, #{item.fileDir,jdbcType=VARCHAR}, #{item.fileSize,jdbcType=DECIMAL},#{item.fileUrl,jdbcType=VARCHAR}, #{item.relId,jdbcType=VARCHAR}, #{item.fileNo,jdbcType=VARCHAR}, #{item.orderNo,jdbcType=DECIMAL}, #{item.createTime,jdbcType=TIMESTAMP}, #{item.fileTitle,jdbcType=VARCHAR} from dual