StatisticsController.java 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325
  1. package com.yihu.wlyy.web.statistic;
  2. import com.yihu.wlyy.entity.statistics.PopulationBase;
  3. import com.yihu.wlyy.service.app.statistics.StatisticsService;
  4. import com.yihu.wlyy.web.BaseController;
  5. import io.swagger.annotations.Api;
  6. import org.json.JSONArray;
  7. import org.json.JSONObject;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.data.redis.core.StringRedisTemplate;
  10. import org.springframework.http.MediaType;
  11. import org.springframework.stereotype.Controller;
  12. import org.springframework.web.bind.annotation.RequestMapping;
  13. import org.springframework.web.bind.annotation.RequestMethod;
  14. import org.springframework.web.bind.annotation.ResponseBody;
  15. /**
  16. * Created by lyr on 2016/08/16.
  17. */
  18. @Controller
  19. @RequestMapping(value = "/statistics", produces = MediaType.APPLICATION_JSON_UTF8_VALUE)
  20. @Api(description = "统计")
  21. public class StatisticsController extends BaseController {
  22. @Autowired
  23. StatisticsService statisticsService;
  24. /**
  25. * 获取统计时间
  26. *
  27. * @return
  28. */
  29. @RequestMapping(value = "/time")
  30. @ResponseBody
  31. public String getStatisticsTime(){
  32. try{
  33. return write(200,"查询成功","data",statisticsService.getStatisticsTime());
  34. }catch (Exception e){
  35. e.printStackTrace();
  36. return error(-1,"查询失败");
  37. }
  38. }
  39. /**
  40. * 指标按间隔统计
  41. *
  42. * @param startDate 起始日期
  43. * @param endDate 结束时间
  44. * @param interval 时间间隔
  45. * @param area 区域或机构
  46. * @param level 级别
  47. * @param index 指标
  48. * @return
  49. */
  50. @RequestMapping(value = "/interval")
  51. @ResponseBody
  52. public String indexInterval(String startDate, String endDate, int interval, String area, int level, String index) {
  53. String tag = "";
  54. try {
  55. String[] indexes = index.split(",");
  56. JSONObject result = new JSONObject();
  57. if (index != null) {
  58. for (String idx : indexes) {
  59. result.put("index_" + idx, statisticsService.getDateIncrementDetail(startDate, endDate, interval, area, level, idx));
  60. }
  61. }
  62. return write(200, "查询成功!", "data", result);
  63. } catch (Exception e) {
  64. e.printStackTrace();
  65. return error(-1, tag + "查询失败!");
  66. }
  67. }
  68. /**
  69. * 指标期间增长量
  70. *
  71. * @param startDate
  72. * @param endDate
  73. * @param area
  74. * @param level
  75. * @param index
  76. * @return
  77. */
  78. @RequestMapping("/increment")
  79. @ResponseBody
  80. public String getIndexIncrement(String startDate, String endDate, String area, int level, String index) {
  81. try {
  82. String[] indexes = index.split(",");
  83. JSONObject result = new JSONObject();
  84. for (String idx : indexes) {
  85. result.put("index_" + idx, statisticsService.getIntervalIncrement(startDate, endDate, area, level, idx));
  86. }
  87. return write(200, "查询成功", "data", result);
  88. } catch (Exception e) {
  89. e.printStackTrace();
  90. return error(-1, "查询失败");
  91. }
  92. }
  93. /**
  94. * 指标截止日期累积量
  95. *
  96. * @param endDate
  97. * @param area
  98. * @param level
  99. * @param index
  100. * @return
  101. */
  102. @RequestMapping("/total")
  103. @ResponseBody
  104. public String getIndexTotal(String endDate, String area, int level, String index) {
  105. try {
  106. String[] indexes = index.split(",");
  107. JSONObject result = new JSONObject();
  108. for (String idx : indexes) {
  109. result.put("index_" + idx, statisticsService.getTotalAmount(endDate, area, level, idx));
  110. }
  111. return write(200, "查询成功", "data", result);
  112. } catch (Exception e) {
  113. e.printStackTrace();
  114. return error(-1, "查询失败");
  115. }
  116. }
  117. /**
  118. * 指标期间增长量
  119. *
  120. * @param startDate
  121. * @param endDate
  122. * @param area
  123. * @param level
  124. * @param index
  125. * @return
  126. */
  127. @RequestMapping("/lowlevel_increment")
  128. @ResponseBody
  129. public String getIndexLowLevelIncrement(String startDate, String endDate, String area, int level, String index, int sort,String lowLevel) {
  130. try {
  131. String[] indexes = index.split(",");
  132. JSONObject result = new JSONObject();
  133. for (String idx : indexes) {
  134. result.put("index_" + idx, statisticsService.getLowLevelIncrementDetail(startDate, endDate, area, level, idx, sort,lowLevel));
  135. }
  136. return write(200, "查询成功", "data", result);
  137. } catch (Exception e) {
  138. e.printStackTrace();
  139. return error(-1, "查询失败");
  140. }
  141. }
  142. /**
  143. * 指标截止日期累积量
  144. *
  145. * @param endDate
  146. * @param area
  147. * @param level
  148. * @param index
  149. * @return
  150. */
  151. @RequestMapping("/lowlevel_total")
  152. @ResponseBody
  153. public String getIndexLowLevelTotal(String endDate, String area, int level, String index, int sort, String lowLevel) {
  154. try {
  155. String[] indexes = index.split(",");
  156. JSONObject result = new JSONObject();
  157. for (String idx : indexes) {
  158. result.put("index_" + idx, statisticsService.getLowLevelTotalDetail(endDate, area, level, idx, sort, lowLevel));
  159. }
  160. return write(200, "查询成功", "data", result);
  161. } catch (Exception e) {
  162. e.printStackTrace();
  163. return error(-1, "查询失败");
  164. }
  165. }
  166. /**
  167. * 指标期间增长量
  168. *
  169. * @param startDate
  170. * @param endDate
  171. * @param area
  172. * @param level
  173. * @param index
  174. * @return
  175. */
  176. @RequestMapping("/leveltwo_increment")
  177. @ResponseBody
  178. public String getIndexLevelTwoIncrement(String startDate, String endDate, String area, int level, String index) {
  179. try {
  180. String[] indexes = index.split(",");
  181. JSONObject result = new JSONObject();
  182. for (String idx : indexes) {
  183. result.put("index_" + idx, statisticsService.getLevelTwoIndexIncrement(startDate, endDate, area, level, idx));
  184. }
  185. return write(200, "查询成功", "data", result);
  186. } catch (Exception e) {
  187. e.printStackTrace();
  188. return error(-1, "查询失败");
  189. }
  190. }
  191. /**
  192. * 获取签约率、签约完成率
  193. *
  194. * @param endDate 截止日期
  195. * @param area 区域
  196. * @param level 区域级别 4:城市 3:区 2:社区 1:团队
  197. * @return
  198. */
  199. @RequestMapping(value = "/sign_info")
  200. @ResponseBody
  201. public String getAreaSignInfo(String endDate, String area, int level) {
  202. try {
  203. JSONObject result = new JSONObject();
  204. long sign = statisticsService.getTotalAmount(endDate, area, level, "1");
  205. long weiJf = statisticsService.getWeiJiaoFei(endDate, area, level);
  206. JSONObject signRate = statisticsService.getSignRate(endDate,area,level);
  207. JSONObject signTaskRate = statisticsService.getSignTaskRate(endDate,area,level);
  208. result.put("sign",sign);
  209. result.put("expenses",weiJf);
  210. result.put("signRate",signRate);
  211. result.put("signTaskRate",signTaskRate);
  212. return write(200, "查询成功", "data", result);
  213. } catch (Exception e) {
  214. e.printStackTrace();
  215. return error(-1, "查询失败");
  216. }
  217. }
  218. /**
  219. * 获取三级指标增量
  220. *
  221. * @param startDate
  222. * @param endDate
  223. * @param area
  224. * @param level
  225. * @return
  226. */
  227. @RequestMapping(value = "/sixfive_statistics")
  228. @ResponseBody
  229. public String getSixFiveStatistics(String startDate, String endDate, String area, int level){
  230. try{
  231. JSONArray result = statisticsService.getSixFiveStatistics(startDate,endDate,area,level);
  232. return write(200,"查询成功","data",result);
  233. }catch (Exception e){
  234. e.printStackTrace();
  235. return error(-1,"查询失败");
  236. }
  237. }
  238. /**
  239. * 指标按间隔统计
  240. *
  241. * @param startDate 起始日期
  242. * @param endDate 结束时间
  243. * @param interval 时间间隔
  244. * @param area 区域或机构
  245. * @param level 级别
  246. * @param index 指标
  247. * @return
  248. */
  249. @RequestMapping(value = "/interval_total")
  250. @ResponseBody
  251. public String indexIntervalTotal(String startDate, String endDate, int interval, String area, int level, String index){
  252. try {
  253. String[] indexes = index.split(",");
  254. JSONObject result = new JSONObject();
  255. if (index != null) {
  256. for (String idx : indexes) {
  257. result.put("index_" + idx, statisticsService.getDateTotal(startDate, endDate, interval, area, level, idx));
  258. }
  259. }
  260. return write(200, "查询成功!", "data", result);
  261. } catch (Exception e) {
  262. e.printStackTrace();
  263. return error(-1, "查询失败!");
  264. }
  265. }
  266. /**
  267. * 指标截止日期累积量
  268. *
  269. * @param date
  270. * @param area
  271. * @param level
  272. * @param index
  273. * @return
  274. */
  275. @RequestMapping("/lowlevel_all")
  276. @ResponseBody
  277. public String getIndexLowLevelTotalSign(String date, String area, int level, String index, int sort, String lowLevel) {
  278. try {
  279. String[] indexes = index.split(",");
  280. JSONObject result = new JSONObject();
  281. for (String idx : indexes) {
  282. result.put("index_" + idx, statisticsService.getLowLevelTotal(date, area, level, idx, sort, lowLevel));
  283. }
  284. return write(200, "查询成功", "data", result);
  285. } catch (Exception e) {
  286. e.printStackTrace();
  287. return error(-1, "查询失败");
  288. }
  289. }
  290. }