order.js 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. $('.form_date').datetimepicker({
  2. language: 'zh-CN',
  3. weekStart: 1,
  4. todayBtn: 1,
  5. autoclose: 1,
  6. todayHighlight: 1,
  7. startView: 2,
  8. minView: 2,
  9. forceParse: 0
  10. });
  11. $('#tab_order').bootstrapTable({
  12. locale: 'zh-CN', //中文支持
  13. singleSelect: true,
  14. columns: [{checkbox: false}],
  15. pagination: true, //是否开启分页(*)
  16. pageNumber: 1, //初始化加载第一页,默认第一页
  17. pageSize: 20, //每页的记录行数(*)
  18. pageList: [2, 3, 4], //可供选择的每页的行数(*)
  19. sidePagination: "server", //分页方式:client客户端分页,server服务端分页(*)
  20. queryParamsType: "",
  21. columns: [
  22. {
  23. field: 'cpOrderId',
  24. title: '订单id',
  25. align: 'center',
  26. valign: 'middle',
  27. sortable: true
  28. },
  29. {
  30. field: 'uid',
  31. title: '用户id',
  32. align: 'center',
  33. valign: 'middle',
  34. sortable: true
  35. },
  36. {
  37. field: 'amount',
  38. title: '金额(元)',
  39. align: 'center',
  40. valign: 'middle',
  41. sortable: true,
  42. formatter: function (value, row, index) {
  43. var amount = (value / 100);
  44. return amount.toFixed(2);
  45. }
  46. },
  47. {
  48. field: 'product_id',
  49. title: '物品id',
  50. align: 'center',
  51. valign: 'middle',
  52. sortable: true
  53. },
  54. {
  55. field: 'product_count',
  56. title: '物品数量',
  57. align: 'center',
  58. valign: 'middle',
  59. sortable: true
  60. },
  61. {
  62. field: 'close_ts',
  63. title: '支付时间',
  64. align: 'center',
  65. valign: 'middle',
  66. sortable: true,
  67. formatter: function (value, row, index) {
  68. var unixTimestamp = new Date(value * 1000);
  69. return unixTimestamp.toLocaleString();
  70. }
  71. },
  72. {
  73. field: 'channel',
  74. title: '平台',
  75. align: 'center',
  76. valign: 'middle',
  77. sortable: true
  78. },
  79. {
  80. field: 'zoneid',
  81. title: '区服',
  82. align: 'center',
  83. valign: 'middle',
  84. sortable: true
  85. },
  86. ]
  87. });
  88. function searchOrder() {
  89. var platform = $('#inputPlatform').val();
  90. var startTime = $('#date-text').val();
  91. var endTime = $('#date-text1').val();
  92. var url = getProviderUrl("order");
  93. url += "?platform=" + platform;
  94. url += "&startTime=" + startTime;
  95. url += "&endTime=" + endTime;
  96. $('#tab_order').bootstrapTable('refresh', {url: url});
  97. url = getProviderUrl("orderChart");
  98. var params = {};
  99. params.platform = platform;
  100. params.startTime = startTime;
  101. params.endTime = endTime;
  102. $.post(url, params,function(data){
  103. $('#totalPrize').text("总充值:" + data.totalPrize + "元");
  104. Canvas2(data.data,data.labels);
  105. }, 'json');
  106. }
  107. var chart = null;
  108. function Canvas2(datas,labels) {
  109. var lineChartData = {
  110. labels: labels,
  111. datasets: [
  112. {
  113. fillColor: "rgba(220,220,220,0.2)",
  114. strokeColor: "rgba(220,220,220,1)",
  115. pointColor: "rgba(220,220,220,1)",
  116. pointStrokeColor: "#fff",
  117. pointHighlightFill: "#fff",
  118. pointHighlightStroke: "rgba(220,220,220,1)",
  119. data: datas
  120. }
  121. ]
  122. }
  123. $('#orderCanvas').attr("width",$('#orderCanvasParent').width());
  124. var ctx = document.getElementById("orderCanvas").getContext("2d");
  125. if(chart != null){
  126. chart.destroy();
  127. }
  128. chart = new Chart(ctx).Line(lineChartData);
  129. }