rock_customer_total.php 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
  1. <?php if(!defined('HOST'))die('not access');?>
  2. <script >
  3. $(document).ready(function(){
  4. {params}
  5. var atype=params.atype,month=js.now('Y-m');
  6. var a = $('#view_{rand}').bootstable({
  7. tablename:'admin',params:{'atype':atype,'month':month},fanye:atype=='all',
  8. modedir:'{mode}:{dir}',storeafteraction:'custtotalafter',storebeforeaction:'custtotalbefore',
  9. columns:[{
  10. text:'部门',dataIndex:'deptname'
  11. },{
  12. text:'姓名',dataIndex:'name'
  13. },{
  14. text:'月份',dataIndex:'month'
  15. },{
  16. text:'待收金额',dataIndex:'shou_moneyd'
  17. },{
  18. text:'已收金额',dataIndex:'shou_moneys'
  19. },{
  20. text:'应收金额',dataIndex:'shou_moneyz'
  21. },{
  22. text:'当月已收金额',dataIndex:'shou_moneyn'
  23. },{
  24. text:'收款单数',dataIndex:'shou_shu'
  25. },{
  26. text:'待付金额',dataIndex:'fu_moneyd'
  27. },{
  28. text:'已付金额',dataIndex:'fu_moneys'
  29. },{
  30. text:'应付金额',dataIndex:'fu_moneyz'
  31. },{
  32. text:'当月已付金额',dataIndex:'fu_moneyn'
  33. },{
  34. text:'付款单数',dataIndex:'fu_shu'
  35. }],
  36. load:function(a){
  37. c.loadcharts();
  38. },
  39. itemclick:function(){
  40. btn(false);
  41. },
  42. beforeload:function(){
  43. btn(true);
  44. }
  45. });
  46. function btn(bo){
  47. get('xiang_{rand}').disabled = bo;
  48. }
  49. var myChart=false;
  50. var c = {
  51. reload:function(){
  52. a.reload();
  53. },
  54. daochu:function(){
  55. a.exceldown();
  56. },
  57. search:function(){
  58. var s=get('key_{rand}').value,mon = get('month_{rand}').value;
  59. a.setparams({key:s,month:mon},true);
  60. },
  61. view:function(){
  62. var d=a.changedata;
  63. addtabs({num:'custfintotal'+d.id+'',url:'main,customer,totalge,uid='+d.id+'',icons:'bar-chart',name:''+d.name+'的年度统计'});
  64. },
  65. loadcharts:function(){
  66. if(atype!='down')return;
  67. if(!myChart){
  68. $('#view_{rand}').after('<div class="blank20"></div><div id="main_show{rand}" style="width:98%;height:500px;"></div>');
  69. myChart = echarts.init(get('main_show{rand}'));
  70. }
  71. var rows = a.getData('rows'),i,len=rows.length,v;
  72. var xAxis=[],data=[];
  73. for(i=0;i<len;i++){
  74. xAxis.push(rows[i].name);
  75. v = rows[i].shou_moneyz;if(v=='')v=0;
  76. data.push(parseFloat(v));
  77. }
  78. var mon = get('month_{rand}').value;
  79. var option = {
  80. title: {
  81. text: ''+mon+'月份应收金额图表',
  82. left: 'center'
  83. },
  84. tooltip: {},
  85. legend: {
  86. data:['应收金额']
  87. },
  88. xAxis: {
  89. data: xAxis
  90. },
  91. yAxis: {type : 'value'},
  92. series: [{
  93. name: '金额',
  94. type: 'bar',
  95. data: data
  96. }]
  97. };
  98. myChart.setOption(option);
  99. }
  100. };
  101. js.initbtn(c);
  102. $('#month_{rand}').val(month);
  103. });
  104. </script>
  105. <div>
  106. <table width="100%">
  107. <tr>
  108. <td style="padding-right:10px">
  109. <button class="btn btn-default" click="reload" type="button"><i class="icon-refresh"></i></button>
  110. </td>
  111. <td style="padding-right:10px">
  112. <div style="width:120px" class="input-group">
  113. <input readonly placeholder="月份" class="form-control" id="month_{rand}" >
  114. <span class="input-group-btn">
  115. <button onclick="return js.selectdate(this,'month_{rand}','month')" class="btn btn-default" type="button"><i class="icon-calendar"></i></button>
  116. </span>
  117. </div>
  118. </td>
  119. <td>
  120. <input class="form-control" style="width:200px" id="key_{rand}" placeholder="部门/人员">
  121. </td>
  122. <td style="padding-left:10px">
  123. <button class="btn btn-default" click="search" type="button">搜索</button>
  124. </td>
  125. <td width="90%" style="padding-left:10px">
  126. </td>
  127. <td align="right" nowrap>
  128. <button class="btn btn-default" id="xiang_{rand}" click="view" disabled type="button">详情</button> &nbsp;
  129. <button class="btn btn-default" click="daochu,1" type="button">导出</button>
  130. </td>
  131. </tr>
  132. </table>
  133. </div>
  134. <div class="blank10"></div>
  135. <div id="view_{rand}"></div>
  136. <div class="tishi">系统是以收付款单上是所属日期算对应月份统计的,当月已收金额是收款时间是当月的统计。</div>
粤ICP备19079148号