rock_customer_totalge.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154
  1. <?php if(!defined('HOST'))die('not access');?>
  2. <script >
  3. $(document).ready(function(){
  4. {params}
  5. var uid=params.uid;
  6. if(!uid)uid=adminid+'';
  7. var columns=[{
  8. text:'部门',dataIndex:'deptname'
  9. },{
  10. text:'姓名',dataIndex:'name'
  11. },{
  12. text:'月份',dataIndex:'month'
  13. },{
  14. text:'待收金额',dataIndex:'shou_moneyd'
  15. },{
  16. text:'已收金额',dataIndex:'shou_moneys'
  17. },{
  18. text:'应收金额',dataIndex:'shou_moneyz'
  19. },{
  20. text:'当月已收金额',dataIndex:'shou_moneyn'
  21. },{
  22. text:'收款单数',dataIndex:'shou_shu'
  23. },{
  24. text:'待付金额',dataIndex:'fu_moneyd'
  25. },{
  26. text:'已付金额',dataIndex:'fu_moneys'
  27. },{
  28. text:'应付金额',dataIndex:'fu_moneyz'
  29. },{
  30. text:'当月已付金额',dataIndex:'fu_moneyn'
  31. },{
  32. text:'付款单数',dataIndex:'fu_shu'
  33. }];
  34. var a = $('#view_{rand}').bootstable({
  35. tablename:'custfina',params:{'uid':uid},modedir:'{mode}:{dir}',storeafteraction:'custtotalgeafter',storebeforeaction:'custtotalgebefore',
  36. columns:columns,
  37. load:function(a){
  38. c.loadcharts('shou_moneys','已收金额');
  39. }
  40. });
  41. var myChart=false;
  42. var c = {
  43. reload:function(){
  44. a.reload();
  45. },
  46. daochu:function(){
  47. a.exceldown();
  48. },
  49. search:function(){
  50. var startdt = get('start_{rand}').value,
  51. enddt = get('end_{rand}').value;
  52. a.setparams({'startdt':startdt,'enddt':enddt},true);
  53. },
  54. loadcharts:function(sf, nas){
  55. if(!myChart){
  56. $('#ssssv_{rand}').after('<div class="blank20"></div><div id="main_show{rand}" style="width:98%;height:400px;"></div>');
  57. myChart = echarts.init(get('main_show{rand}'));
  58. }
  59. var rows = a.getData('rows'),i,len=rows.length,v;
  60. if(!sf)sf='shou_moneys';
  61. var xAxis=[],data=[];
  62. for(i=len-1;i>=0;i--){
  63. xAxis.push(rows[i].month);
  64. v = rows[i][sf];if(v=='')v=0;
  65. data.push(parseFloat(v));
  66. }
  67. var option = {
  68. title: {
  69. text: ''+nas+'图表',
  70. left: 'center'
  71. },
  72. tooltip: {},
  73. legend: {
  74. data:['']
  75. },
  76. xAxis: {
  77. data: xAxis
  78. },
  79. yAxis: {type : 'value'},
  80. series: [{
  81. name: nas,
  82. type: 'line',
  83. data: data
  84. }]
  85. };
  86. myChart.setOption(option);
  87. },
  88. inits:function(){
  89. var ss=[];
  90. for(var i=0;i<columns.length;i++){
  91. if(i>2)ss.push({name:columns[i].text,id:columns[i].dataIndex});
  92. }
  93. js.setselectdata(get('selectsss_{rand}'), ss,'id');
  94. get('selectsss_{rand}').value='shou_moneys';
  95. $('#selectsss_{rand}').change(function(){
  96. c.changesels(this);
  97. });
  98. },
  99. changesels:function(o){
  100. var val = o.value;if(val=='')return;
  101. var nam = o.options[o.selectedIndex].text;
  102. this.loadcharts(val, nam);
  103. }
  104. };
  105. js.initbtn(c);
  106. $('#start_{rand}').val(js.now('Y-01'));
  107. $('#end_{rand}').val(js.now('Y-m'));
  108. c.inits();
  109. });
  110. </script>
  111. <div>
  112. <table width="100%">
  113. <tr>
  114. <td style="padding-right:10px">
  115. <button class="btn btn-default" click="reload" type="button"><i class="icon-refresh"></i></button>
  116. </td>
  117. <td style="padding-right:10px">
  118. <div style="width:120px" class="input-group">
  119. <input readonly placeholder="月份从" class="form-control" id="start_{rand}" >
  120. <span class="input-group-btn">
  121. <button onclick="return js.selectdate(this,'start_{rand}','month')" class="btn btn-default" type="button"><i class="icon-calendar"></i></button>
  122. </span>
  123. </div>
  124. </td>
  125. <td nowrap>至&nbsp; </td>
  126. <td>
  127. <div style="width:120px" class="input-group">
  128. <input readonly class="form-control" id="end_{rand}" >
  129. <span class="input-group-btn">
  130. <button onclick="return js.selectdate(this,'end_{rand}','month')" class="btn btn-default" type="button"><i class="icon-calendar"></i></button>
  131. </span>
  132. </div>
  133. </td>
  134. <td style="padding-left:10px">
  135. <button class="btn btn-default" click="search" type="button">搜索</button>
  136. </td>
  137. <td width="90%" style="padding-left:10px">
  138. </td>
  139. <td align="right" nowrap>
  140. <button class="btn btn-default" click="daochu,1" type="button">导出</button>
  141. </td>
  142. </tr>
  143. </table>
  144. </div>
  145. <div class="blank10"></div>
  146. <div id="view_{rand}"></div>
  147. <div class="blank10"></div>
  148. <div id="ssssv_{rand}"><select id="selectsss_{rand}" style="width:250px" class="form-control"><option value="">--选择图表字段--</option></select></div>
粤ICP备19079148号