collectstatement.js 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133
  1. define(['jquery', 'bootstrap', 'backend', 'table', 'form'], function ($, undefined, Backend, Table, Form) {
  2. $('ul.nav-tabs li').click(function(){
  3. $(this).addClass('active').siblings().removeClass('active')
  4. });
  5. var Controller = {
  6. index: function () {
  7. // 初始化表格参数配置
  8. Table.api.init({
  9. extend: {
  10. index_url: 'collectstatement/index',
  11. table: 'orders_collect'
  12. },
  13. showToggle: false,
  14. showColumns: false,
  15. showExport: false,
  16. commonSearch: false,
  17. operate: false,
  18. search:false,
  19. onLoadSuccess: function (data) {
  20. $("[data-toggle='tooltip']").tooltip({trigger: 'focus hover',html : true });
  21. }
  22. });
  23. var table = $("#table");
  24. table.bootstrapTable({
  25. url: $.fn.bootstrapTable.defaults.extend.index_url,
  26. pk: 'id',
  27. sortName: 'createdate',
  28. columns: [Controller.api.showColumns()]
  29. });
  30. // 为表格绑定事件
  31. Table.api.bindevent(table);
  32. },
  33. api: {
  34. showColumns:function(){
  35. var cols = new Array();
  36. cols.push({field: 'createdate', title: __('日期'),formatter: Controller.api.formatter.createtime});
  37. cols.push({field: 'pv', title: __('PV'),formatter:Controller.api.formatter.format_pv});
  38. cols.push({field: 'uv', title: __('UV'),formatter:Controller.api.formatter.format_uv});
  39. cols.push({field: 'recharge_money', title: __('总充值')});
  40. cols.push({field: 'normal_recharge_money', title: __('普通充值'),formatter: Controller.api.formatter.normal_recharge_money});
  41. cols.push({field: 'normal_recharge_orders_count', title: __('普通充值订单数'),formatter: Controller.api.formatter.normal_recharge_orders_count });
  42. cols.push({field: 'vip_recharge_money', title: __('年度VIP会员'),formatter: Controller.api.formatter.vip_recharge_money});
  43. cols.push({field: 'vip_recharge_orders_count', title: __('年度VIP会员订单数'),formatter: Controller.api.formatter.vip_recharge_orders_count});
  44. return cols;
  45. },
  46. bindevent: function () {
  47. Form.api.bindevent($("form[role=form]"));
  48. },formatter: {
  49. format_pv:function(value,row,index){
  50. return parseInt(row.pv);
  51. },
  52. format_uv:function(value,row,index){
  53. return parseInt(row.uv);
  54. },
  55. normal_recharge_orders: function (value, row, index) {
  56. return '<span style="color:#e74c3c">¥'+((row.recharge_money-row.recharge_money_benefit)* 1.00).toFixed(2) + '</span>';
  57. },
  58. normal_recharge_money:function (value, row, index) {
  59. var normal_recharge_str = '<p>¥'+row.normal_recharge_money+'</p>';
  60. if(row.normal_recharge_orders>0){
  61. var normal_recharge_str_avg = Number(row.normal_recharge_money/row.normal_recharge_orders) * 1.00;
  62. normal_recharge_str += '<i>成功人次:'+row.normal_recharge_orders+'<br/>人均:¥'+ Number(normal_recharge_str_avg.toFixed(2))+'</i>';
  63. }else{
  64. normal_recharge_str +='<i>成功人次:0<br/>人均:¥0'+'</i>';
  65. }
  66. return normal_recharge_str;
  67. },
  68. normal_recharge_orders_count:function(value,row,index){
  69. var normal_recharge_order_str = '<p>已支付:'+row.normal_recharge_orders+'笔</p>';
  70. var wzf = row.normal_recharge_orders_count-row.normal_recharge_orders;
  71. if(row.normal_recharge_orders > 0){
  72. if (row.kandian_recharge_orders_count >0) {
  73. var normal_recharge_str_order_avg = (row.kandian_recharge_orders*100/row.kandian_recharge_orders_count) * 1.00;
  74. } else {
  75. var normal_recharge_str_order_avg = (row.normal_recharge_orders*100/row.normal_recharge_orders_count) * 1.00;
  76. }
  77. normal_recharge_order_str += '<p>未支付:'+wzf+'笔</p>';
  78. normal_recharge_order_str += '<p>完成率:'+ Math.floor(normal_recharge_str_order_avg)+'%'+'</p>';
  79. }else{
  80. normal_recharge_order_str += '<p>未支付:'+wzf+'笔</p>';
  81. normal_recharge_order_str += '<p>完成率:0%'+'</p>';
  82. }
  83. return normal_recharge_order_str;
  84. },
  85. vip_recharge_money:function (value, row, index) {
  86. var vip_recharge_str = '<p>¥'+row.vip_recharge_money+'</p>';
  87. if(row.vip_recharge_orders > 0){
  88. var vip_recharge_str_avg = Number(row.vip_recharge_money/row.vip_recharge_orders) * 1.00;
  89. vip_recharge_str += '<i>成功人次:'+row.vip_recharge_orders+'<br/>人均:¥'+ Number(vip_recharge_str_avg.toFixed(2))+'</i>';
  90. }else{
  91. vip_recharge_str +='<i>成功人次:0<br/>人均:¥0'+'</i>';
  92. }
  93. return vip_recharge_str;
  94. },
  95. vip_recharge_orders_count:function(value,row,index){
  96. var vip_recharge_order_str = '<p>已支付:'+row.vip_recharge_orders+'笔</p>';
  97. var vipwzf = row.vip_recharge_orders_count-row.vip_recharge_orders;
  98. if(row.vip_recharge_orders > 0){
  99. if(row.vip_recharge_orders_count){
  100. var vip_recharge_str_order_avg = (row.vip_recharge_orders*100/row.vip_recharge_orders_count) * 1.00;
  101. }else{
  102. var vip_recharge_str_order_avg = 0;
  103. }
  104. vip_recharge_order_str += '<p>未支付:'+vipwzf+'笔</p>';
  105. vip_recharge_order_str += '<p>完成率:'+ Math.floor(vip_recharge_str_order_avg)+'%'+'</p>';
  106. }else{
  107. vip_recharge_order_str += '<p>未支付:'+vipwzf+'笔</p>';
  108. vip_recharge_order_str += '<p>完成率:0%'+'</p>';
  109. }
  110. return vip_recharge_order_str;
  111. },
  112. total_benefit:function(value,row,index){
  113. return '¥'+value;
  114. },
  115. total_benefit_channel:function(value,row,index) {
  116. return '<span style="color:#e74c3c">¥' + Number(value).toFixed(2) + '</span>';
  117. },
  118. createtime:function(value,row,index){
  119. return value.substring(0,4)+'-'+ value.substring(4,6)+'-'+value.substring(6,8);
  120. },
  121. }
  122. }
  123. };
  124. return Controller;
  125. });