| | |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import springfox.documentation.annotations.ApiIgnore; |
| | | |
| | | import java.text.DecimalFormat; |
| | | import java.util.List; |
| | | import java.util.ArrayList; |
| | | import java.util.Map; |
| | |
| | | * 公司运营情况进入图表 |
| | | */ |
| | | @PostMapping("/selectTb") |
| | | public R selectTb(String jurisdiction, String enterpriseName, Integer current, Integer size) { |
| | | List<Map<Object, Object>> list = informationService.selectTb(jurisdiction, enterpriseName, current, size); |
| | | public R<IPage> selectTb(String jurisdiction, String enterpriseName, Query query) { |
| | | IPage list =informationService.selectTb(Condition.getPage(query),jurisdiction, enterpriseName); |
| | | return R.data(list); |
| | | } |
| | | |
| | |
| | | * 公司经济情况进入图表 |
| | | */ |
| | | @PostMapping("/selectJj") |
| | | public R selectJj(String jurisdiction, String enterpriseName, Integer current, Integer size) { |
| | | List<Map<Object, Object>> list = informationService.selectJj(jurisdiction, enterpriseName, current, size); |
| | | public R<IPage> selectJj(String jurisdiction, String enterpriseName, Query query) { |
| | | IPage list = informationService.selectJj(Condition.getPage(query),jurisdiction, enterpriseName); |
| | | return R.data(list); |
| | | } |
| | | |
| | |
| | | * 业务统计情况 |
| | | */ |
| | | @PostMapping("/selectYw") |
| | | public R selectYw(String jurisdiction, String deptid,Integer current,Integer size) { |
| | | List<Map<Object, Object>> list = informationService.selectYw(jurisdiction, deptid,current,size); |
| | | public R<IPage> selectYw(String jurisdiction, String deptid, Query query) { |
| | | IPage list = informationService.selectYw(Condition.getPage(query),jurisdiction, deptid); |
| | | return R.data(list); |
| | | } |
| | | |
| | |
| | | * 业务统计明细 |
| | | */ |
| | | @PostMapping("/selectDis") |
| | | public R selectDis(String jurisdiction, String deptid, String fid, Integer current, Integer size) { |
| | | List<Map<Object, Object>> list = informationService.selectDis(jurisdiction, deptid, fid, current, size); |
| | | public R<IPage> selectDis(String jurisdiction, String deptid, String fid, Query query) { |
| | | IPage list = informationService.selectDis(Condition.getPage(query),jurisdiction, deptid, fid); |
| | | return R.data(list); |
| | | } |
| | | |
| | |
| | | return R.data(lists); |
| | | } |
| | | |
| | | // public static void main(String[] args) throws Exception { |
| | | // //ftp服务器IP地址 |
| | | // String ftpHost = "192.168.0.105"; |
| | | // //ftp服务器端口 |
| | | // int ftpPort = 21; |
| | | // //ftp服务器用户名 |
| | | // String ftpUserName = "yly"; |
| | | // //ftp服务器密码 |
| | | // String ftpPassword = "Yly@123"; |
| | | // //ftp服务器路径 |
| | | // String ftpPath = ""; |
| | | // //本地路径 |
| | | // String localPath = "D:\\anbao"; |
| | | // //文件名 |
| | | // String fileName = "sql.json"; |
| | | // FtpUtil.downloadFtpFile(ftpHost, ftpUserName, ftpPassword, ftpPort, ftpPath, localPath, fileName); |
| | | // String s = TestJson(); |
| | | // String sql = stringReplace(s); |
| | | // MysqlCenlint.inster(sql); |
| | | // MysqlCenlint.delete(); |
| | | // } |
| | | /** |
| | | * 违规经营 |
| | | */ |
| | | @PostMapping("/selectWg") |
| | | public R selectWg() { |
| | | List<Map<Object, Object>> list = informationService.selectWg(); |
| | | for (int i=0;i<list.size();i++){ |
| | | //总数 |
| | | String znums = list.get(i).get("znum").toString(); |
| | | int znum=Integer.parseInt(znums); |
| | | //持证人数 |
| | | String cznums = list.get(i).get("cznum").toString(); |
| | | int cznum=Integer.parseInt(cznums); |
| | | //缴纳社保人数 |
| | | String sbnums = list.get(i).get("sbnum").toString(); |
| | | int sbnum=Integer.parseInt(sbnums); |
| | | } |
| | | return R.data(list); |
| | | } |
| | | |
| | | /** |
| | | * 经营不善 |
| | | */ |
| | | @PostMapping("/selectJy") |
| | | public R selectJy() { |
| | | List<Map<Object, Object>> list = informationService.selectJy(); |
| | | for (int i=0;i<list.size();i++){ |
| | | |
| | | } |
| | | return R.data(list); |
| | | } |
| | | |
| | | |
| | | } |