| | |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.FTP.FtpUtil; |
| | | import org.springblade.modules.FTP.OutJson; |
| | | import org.springblade.modules.FTP.monitor; |
| | | import org.springblade.modules.apply.entity.Apply; |
| | | import org.springblade.modules.apply.excel.ApplyExcel; |
| | | import org.springblade.modules.apply.excel.ApplyImporter; |
| | |
| | | "'" + "," + "'" + apply.getApplyStatus() + "'" + "," +"'" + apply.getIsExam() + "'" + ");" + |
| | | "update blade_user set is_apply = " + user1.getIsApply() + " " +"where id = " + "'" + user1.getId() + "'"; |
| | | String json = JSON.toJSONString(s); |
| | | OutJson.createJsonFile(json, "d:/", "wsql"); |
| | | String response = String.valueOf((new Date()).getTime()); |
| | | OutJson.createJsonFile(json, "d:/", "w"+response); |
| | | FileInputStream in = null; |
| | | try { |
| | | in = new FileInputStream(new File("D:\\" + fileName)); |
| | | in = new FileInputStream(new File("D:\\" + "w"+response+".json")); |
| | | } catch (FileNotFoundException e) { |
| | | e.printStackTrace(); |
| | | } |
| | | FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", fileName, in); |
| | | FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response+".json", in); |
| | | } |
| | | |
| | | |
| | |
| | | @TableField("dept_id") |
| | | private Long deptId; |
| | | |
| | | /** |
| | | * 政策发布封面 url |
| | | */ |
| | | @TableField("cover_url") |
| | | private String coverUrl; |
| | | |
| | | /** |
| | | * 1.通知公告 2:政策发布 |
| | | */ |
| | | private Integer type; |
| | | |
| | | } |
| | |
| | | <if test="notice.category!=null"> |
| | | and n.category = #{notice.category} |
| | | </if> |
| | | <if test="notice.type!=null"> |
| | | and n.type = #{notice.type} |
| | | </if> |
| | | <if test="notice.deptId!=null and notice.jurisdiction!=null"> |
| | | and (n.dept_id = #{notice.deptId} or bu.jurisdiction = #{notice.jurisdiction} |
| | | or n.dept_id = 1123598813738675201 |
| | |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd") |
| | | private Date endTime; |
| | | |
| | | /** |
| | | * 保安服务类型 |
| | | */ |
| | | @TableField("serve_type") |
| | | private String serveType; |
| | | |
| | | |
| | | } |
| | |
| | | */ |
| | | package org.springblade.modules.dispatcher.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.SqlParser; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.modules.dispatcher.entity.Dispatcher; |
| | | import org.springblade.modules.dispatcher.vo.DispatcherUnitVO; |
| | |
| | | * @param dispatcherUnitVO1 |
| | | * @return |
| | | */ |
| | | Integer getDispatcherCount(@Param("dispatcherUnit")DispatcherUnitVO dispatcherUnitVO1); |
| | | @SqlParser(filter = true) |
| | | Integer getDispatcherCount(@Param("dispatcherUnitVO1")DispatcherUnitVO dispatcherUnitVO1); |
| | | } |
| | |
| | | select ifnull(count(*),0) count from sys_dispatcher |
| | | where |
| | | 1=1 |
| | | and dispatcher_unit_id #{dispatcherUnitVO1.id} |
| | | and dispatcher_unit_id = #{dispatcherUnitVO1.id} |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | */ |
| | | package org.springblade.modules.dispatcher.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.SqlParser; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.apache.ibatis.annotations.Param; |
| | |
| | | <if test="dispatcherUnit.district!=null"> |
| | | and sdu.district = #{dispatcherUnit.district} |
| | | </if> |
| | | <if test="dispatcherUnit.beginTime!=null or dispatcherUnit.overTime!=null"> |
| | | and sdu.end_time <= #{dispatcherUnit.overTime} and sdu.end_time >= #{dispatcherUnit.beginTime} |
| | | or ( sdu.start_time <= #{dispatcherUnit.overTime} and sdu.start_time >= #{dispatcherUnit.beginTime}) |
| | | </if> |
| | | </select> |
| | | |
| | | <!--自定义树--> |
| | |
| | | * 派遣人数 |
| | | */ |
| | | private Integer num; |
| | | |
| | | /** |
| | | * 开始时间 |
| | | */ |
| | | private String beginTime; |
| | | |
| | | /** |
| | | * 结束时间 |
| | | */ |
| | | private String overTime; |
| | | } |
| | |
| | | + "'" + dept.getTenantId() + "'" + "," + "'" + information.getEnterprisename() + "'" + "," + "'" + dept.getAncestors() + "'" + "," + "'" + dept.getDeptCategory() + "'" + ")"; |
| | | Object o = s; |
| | | String json = JSON.toJSONString(o); |
| | | long l = System.currentTimeMillis(); |
| | | //new日期对 |
| | | Date date = new Date(l); |
| | | //转换提日期输出格式 |
| | | SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | System.out.println(dateFormat.format(date)); |
| | | |
| | | String response = dateFormat.format(date).replaceAll("[[\\s-:punct:]]", ""); |
| | | String response = String.valueOf((new Date()).getTime()); |
| | | OutJson.createJsonFile(json, "d:/", "w"+response); |
| | | FileInputStream in = new FileInputStream(new File("D:\\" + "w"+response+".json")); |
| | | FtpUtil.uploadFile(ftpHost, ftpPort, ftpUserName, ftpPassword, "anbao/", "/", "w"+response+".json", in); |
| | |
| | | package org.springblade.modules.recruitment.mapper; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.SqlParser; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.apache.ibatis.annotations.Param; |