top10ByBrandAndSupplier.js 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331
  1. function queryMonthly(){
  2. var startDate = document.getElementById("startDate").value;
  3. var endDate = document.getElementById("endDate").value;
  4. var param = {
  5. startDate:startDate,
  6. endDate:endDate
  7. };
  8. console.log(param);
  9. // 折线图
  10. $.ajax({
  11. url: "../monthly/top10ByBrandAndSupplier",
  12. data: param,
  13. contentType:"application/x-www-form-urlencoded",
  14. type: 'POST',
  15. success: function(data) {
  16. document.getElementById("supplierUl").innerHTML = "";
  17. document.getElementById("brandUl").innerHTML = "";
  18. createLi("Brand","Units Sold","brandUl",true);
  19. createLi("Supplier","Units Sold","supplierUl",true);
  20. console.log(data.top10ByBrand);
  21. for(var i = 0 ; i < data.top10ByBrand.length; i++){
  22. createLi(data.top10ByBrand[i].brand,data.top10ByBrand[i].sales,"brandUl",false);
  23. }
  24. for(var i = 0 ; i < data.top10BySupplier.length; i++){
  25. createLi(data.top10BySupplier[i].supplier,data.top10BySupplier[i].sales,"supplierUl",false);
  26. }
  27. }
  28. });
  29. }
  30. function createLi(title,sales,ulId,flag){
  31. var ul = document.createElement("ul")
  32. if(flag){
  33. ul.setAttribute("class","th")
  34. }
  35. var li_1=document.createElement("li");
  36. li_1.innerHTML = title;
  37. var li_2=document.createElement("li");
  38. li_2.innerHTML = sales;
  39. ul.appendChild(li_1);
  40. ul.appendChild(li_2);
  41. document.getElementById(ulId).appendChild(ul);
  42. }
  43. // var li=document.createElement("li");
  44. // var span_1=document.createElement("span");
  45. // li.innerHTML = title;
  46. // span_1.setAttribute("class","spanClass")
  47. // var span_2=document.createElement("span");
  48. // span_2.innerHTML = sales;
  49. // span_2.setAttribute("class","spanClass")
  50. // li.appendChild(span_1);
  51. // li.appendChild(span_2);
  52. let vm = new Vue({
  53. el: '#rrapp',
  54. data: {
  55. date: '',
  56. refreshTime: 10,
  57. type: 'store',
  58. refreshCount:0,
  59. storeId: '',
  60. merchSn: '',
  61. merchName: '',
  62. storeName: '',
  63. salesDate: '',
  64. totalSales: '',
  65. actualSales: '',
  66. preferentialLoss: '',
  67. totalCost: '',
  68. grossProfit: '',
  69. grossProfitRatio: '',
  70. proportion: '',
  71. guestNumber: '',
  72. guestUnitPrice: '',
  73. lastSalesTime: '',
  74. categoryId: '',
  75. categoryName: '',
  76. showList: false,
  77. compareDate: '',//比较日期
  78. storeId2: '',
  79. merchSn2: '',
  80. merchName2: '',
  81. storeName2: '',
  82. salesDate2: '',
  83. totalSales2: '',
  84. actualSales2: '',
  85. preferentialLoss2: '',
  86. totalCost2: '',
  87. grossProfit2: '',
  88. grossProfitRatio2: '',
  89. proportion2: '',
  90. guestNumber2: '',
  91. guestUnitPrice2: '',
  92. lastSalesTime2: '',
  93. intervalId: 0,
  94. isCompare: false,
  95. compare2: '',
  96. temp: {
  97. date: '',
  98. refreshTime: 10,
  99. type: '',
  100. storeId: '',
  101. merchSn: '',
  102. salesDate: '',
  103. categoryId: ''
  104. },
  105. rateList: [
  106. {
  107. id: '0',
  108. name: '含税'
  109. },
  110. {
  111. id: '1',
  112. name: '不含税'
  113. }
  114. ],
  115. projectList: [
  116. {
  117. id: '0',
  118. name: '销售总额'
  119. },
  120. {
  121. id: '1',
  122. name: '客单价'
  123. }
  124. ],
  125. seriesTypeList: [
  126. {
  127. id: 'bar',
  128. name: '垂直柱状图'
  129. },
  130. {
  131. id: 'line',
  132. name: '折线图'
  133. },
  134. {
  135. id: 'pie',
  136. name: '饼图'
  137. }
  138. ],
  139. formatsList: [
  140. {
  141. id: '0',
  142. name: '<全部>'
  143. },
  144. {
  145. id: '1',
  146. name: '<非全部>'
  147. }
  148. ],
  149. salesList: [
  150. {
  151. store: {storeId: '11106', storeName: '前海店'},
  152. totalSales: 43046.18,
  153. actualSales: 35593.46
  154. }
  155. ],
  156. dept: {
  157. deptId: '',
  158. deptName: ''
  159. },
  160. category: {
  161. categoryId: '',
  162. categoryName: ''
  163. },
  164. seriesList: [], //保存饼图数据
  165. seriesList2: [],
  166. xAxisList: { //主要用于保存 启动刷新时的条件和数据
  167. storeId: '',
  168. storeName: '',
  169. merchSn: '',
  170. merchName: '',
  171. totalSales: '',
  172. actualSales: '',
  173. preferentialLoss: '',
  174. totalCost: '',
  175. grossProfit: '',
  176. grossProfitRatio: '',
  177. proportion: '',
  178. guestNumber: '',
  179. guestUnitPrice: '',
  180. lastSalesTime: '',
  181. salesDate: '0',
  182. projectSelect: '0',
  183. type:''
  184. },
  185. dataList: [],
  186. tooltip: {},
  187. today:''
  188. },
  189. created() {
  190. this.rateSelect = this.rateList[0].id;
  191. this.projectSelect = this.projectList[0].id;
  192. this.seriesTypeSelect = this.seriesTypeList[0].id;
  193. this.formatsSelect = this.formatsList[0].id;
  194. },
  195. methods: {
  196. seriesTypeSwitch: function () {
  197. console.log(vm.seriesTypeSelect);
  198. },
  199. showEcharts: function () {
  200. // 基于准备好的dom,初始化echarts实例
  201. myChart = echarts.init(document.getElementById('main'));
  202. myChart.clear();
  203. //加载动画
  204. myChart.showLoading();
  205. //项目下拉框判断 6-19,饼图设置 vm.xAxisList
  206. var temp = '';
  207. if (vm.xAxisList.projectSelect == '0') {
  208. if (vm.xAxisList.type == 'dept') {
  209. temp = '[' + vm.xAxisList.merchSn + ']' + vm.xAxisList.merchName + '/销售总额:' + vm.xAxisList.totalSales + '元(' + vm.xAxisList.salesDate + ')';
  210. } else {
  211. temp = '[' + vm.xAxisList.storeId + ']' + vm.xAxisList.storeName + '/销售总额:' + vm.xAxisList.totalSales + '元(' + vm.xAxisList.salesDate + ')';
  212. }
  213. vm.seriesList2.push(vm.xAxisList.totalSales);
  214. vm.seriesList.push({value: vm.xAxisList.totalSales, name: temp});
  215. } else if (vm.xAxisList.projectSelect == '1') {
  216. if (vm.xAxisList.type == 'dept') {
  217. temp = '[' + vm.xAxisList.merchSn + ']' + vm.xAxisList.merchName + '/客单价:' + vm.xAxisList.guestUnitPrice + '元(' + vm.xAxisList.salesDate + ')';
  218. } else {
  219. temp = '[' + vm.xAxisList.storeId + ']' + vm.xAxisList.storeName + '/客单价:' + vm.xAxisList.guestUnitPrice + '元(' + vm.xAxisList.salesDate + ')';
  220. }
  221. vm.seriesList2.push(vm.xAxisList.guestUnitPrice);
  222. vm.seriesList.push({value: vm.xAxisList.guestUnitPrice, name: temp});
  223. }
  224. vm.dataList = [temp];
  225. if (vm.seriesTypeSelect == "pie") {
  226. vm.seriesList2 = vm.seriesList.concat();
  227. }
  228. // console.log('vm.seriesList2');
  229. // console.log(vm.seriesList2);
  230. // 指定图表的配置项和数据
  231. //销售量
  232. var option = {
  233. title: {
  234. // textAlign: 'right',
  235. text: 'Monthly Customers & Avg Basket',
  236. x: 'center',
  237. textStyle: {
  238. //文字颜色
  239. color: '#17233d',
  240. //字体风格,'normal','italic','oblique'
  241. fontStyle: 'normal',
  242. //字体粗细 'normal','bold','bolder','lighter',100 | 200 | 300 | 400...
  243. fontWeight: 'bold',
  244. //字体系列
  245. fontFamily: 'sans-serif',
  246. //字体大小
  247. fontSize: 28
  248. }
  249. },
  250. tooltip: {
  251. formatter: function (params) {
  252. return params.name;
  253. }
  254. },
  255. legend: {
  256. data: ['/销售总额']
  257. },
  258. xAxis: {
  259. data: vm.dataList,
  260. axisLabel: {
  261. interval: 0
  262. }
  263. },
  264. yAxis: {},
  265. series: [{
  266. barMaxWidth: '20%',
  267. barWidth: '50%',
  268. radius: '55%',
  269. roseType: 'angle',
  270. type: vm.seriesTypeSelect,
  271. color: ['#dd6b66', '#759aa0'],
  272. data: vm.seriesList2
  273. }]
  274. };
  275. //隐藏
  276. myChart.hideLoading();
  277. // 使用刚指定的配置项和数据显示图表。
  278. myChart.setOption(option);
  279. },
  280. tooltipFormatter: function () {
  281. if (vm.type == 'dept') {
  282. return '[' + vm.merchSn + ']' + vm.merchName + '/销售总额:' + vm.totalSales + '元(' + vm.salesDate + ')';
  283. }
  284. return '[' + vm.storeId + ']' + vm.storeName + '/销售总额:' + vm.totalSales + '元(' + vm.salesDate + ')';
  285. },
  286. showTable: function (postParam) {
  287. console.log(postParam);
  288. $("#jqGrid").jqGrid('setGridParam', {
  289. postData: postParam
  290. }).trigger("reloadGrid").closest(".ui-jqgrid-bdiv").css({"overflow-x": "scroll"});
  291. },
  292. switchProjectView: function () {
  293. console.log(vm.projectSelect);
  294. }
  295. }
  296. });