| | |
| | | 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; |
| | |
| | | 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); |
| | | } |
| | | |
| | | |
| | | } |