index.php 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168
  1. <?php
  2. /* @var $this \yii\web\View */
  3. use yii\helpers\Url;
  4. $this->title = '出金报表';
  5. ?>
  6. <?php $this->beginBlock('header_script'); ?>
  7. <link href="<?= STATIC_URL ?>/ui/css/plugins/dataTables/datatables.min.css" rel="stylesheet">
  8. <?php $this->endBlock(); ?>
  9. <div class="row">
  10. <div class="col-md-3">
  11. <?= $this->render('/common/_left_menu.php') ?>
  12. </div>
  13. <div class="col-md-9">
  14. <div class="ibox">
  15. <div class="ibox-title">
  16. <h2>出金报表</h2>
  17. </div>
  18. <form>
  19. <input type="hidden" name="type" value="withdraw">
  20. <div class="ibox-content m-b-sm border-bottom">
  21. <div class="row">
  22. <div class="col-sm-3">
  23. <div class="form-group">
  24. <label class="control-label" for="price">上级代理商</label>
  25. <select name="ibId" class="form-control select22">
  26. <option value="">请选择</option>
  27. <?php foreach ((array)$ibs as $ib) : ?>
  28. <option value="<?= $ib['id'] ?>" <?= $ib['id'] == Yii::$app->getRequest()->get('ibId') ? 'selected' : '' ?>><?= $ib['name'] ?></option>
  29. <?php endforeach; ?>
  30. </select>
  31. </div>
  32. </div>
  33. <div class="col-sm-2">
  34. <div class="form-group">
  35. <label class="control-label" for="price">客户姓名</label>
  36. <input type="text" id="name" name="name" value="<?= Yii::$app->getRequest()->get('name') ?>" placeholder="客户姓名" class="form-control">
  37. </div>
  38. </div>
  39. <div class="col-sm-2">
  40. <div class="form-group">
  41. <label class="control-label" for="price">开始时间</label>
  42. <input readonly="readonly" type="text" id="sTime" name="sTime" value="<?= Yii::$app->getRequest()->get('sTime') ?>" placeholder="开始时间" class="data form-control">
  43. </div>
  44. </div>
  45. <div class="col-sm-2">
  46. <div class="form-group">
  47. <label class="control-label" for="quantity">结束时间</label>
  48. <input readonly="readonly" type="text" id="eTime" name="eTime" value="<?= Yii::$app->getRequest()->get('eTime') ?>" placeholder="结束时间" class="data form-control">
  49. </div>
  50. </div>
  51. <div class="col-sm-3">
  52. <div class="form-group">
  53. <label class="control-label" for="quantity">操作</label>
  54. <input type="submit" class="btn btn-primary form-control" value="搜索">
  55. </div>
  56. </div>
  57. </div>
  58. </div>
  59. </form>
  60. <div class="ibox-content">
  61. <div class="table-responsive">
  62. <table id="datatables" class="table table-striped table-bordered table-hover dataTables-example">
  63. <thead>
  64. <tr>
  65. <th>代理商</th>
  66. <th>账户</th>
  67. <th>姓名</th>
  68. <th>金额</th>
  69. </tr>
  70. </thead>
  71. </table>
  72. </div>
  73. </div>
  74. </div>
  75. </div>
  76. </div>
  77. <?php $this->beginBlock('footer_script'); ?>
  78. <script src="<?= STATIC_URL ?>/ui/js/plugins/dataTables/datatables.min.js"></script>
  79. <script>
  80. var table;
  81. $(document).ready(function () {
  82. table = $('#datatables').DataTable({
  83. <?php if (isset($isHaveAdmin) && $isHaveAdmin == true) : ?>
  84. "aLengthMenu": [[20,50,100,500,999999999], [20,50,100,500,"ALL"]],
  85. <?php else : ?>
  86. "aLengthMenu": [[20,50,100], [20,50,100]],
  87. <?php endif; ?>
  88. language: {
  89. "sProcessing": "处理中...",
  90. "sLengthMenu": "显示 _MENU_ 项结果",
  91. "sZeroRecords": "没有匹配结果",
  92. "sInfo": "显示第 _START_ 至 _END_ 项结果,共 _TOTAL_ 项",
  93. "sInfoEmpty": "显示第 0 至 0 项结果,共 0 项",
  94. "sInfoFiltered": "(由 _MAX_ 项结果过滤)",
  95. "sInfoPostFix": "",
  96. "sSearch": "搜索订单号,账户:",
  97. "sUrl": "",
  98. "sEmptyTable": "表中数据为空",
  99. "sLoadingRecords": "载入中...",
  100. "sInfoThousands": ",",
  101. "oPaginate": {
  102. "sFirst": "首页",
  103. "sPrevious": "上页",
  104. "sNext": "下页",
  105. "sLast": "末页"
  106. },
  107. "oAria": {
  108. "sSortAscending": ": 以升序排列此列",
  109. "sSortDescending": ": 以降序排列此列"
  110. }
  111. },
  112. "processing": true,
  113. "serverSide": true,
  114. "ajax": '<?= Url::to(['trades/index', 'type' => 'withdraw', 'sTime' => Yii::$app->getRequest()->get('sTime'), 'eTime' => Yii::$app->getRequest()->get('eTime'), 'name' => Yii::$app->getRequest()->get('name'), 'ibId' => Yii::$app->getRequest()->get('ibId')]) ?>',
  115. "order": [[1, "desc"]],
  116. "columns": [{
  117. "data": "IBNAME"
  118. }, {
  119. "data": "LOGIN"
  120. }, {
  121. "data": "NAME"
  122. },
  123. {
  124. "data": "SPROFIT"
  125. }],
  126. columnDefs: [{
  127. targets: 0,
  128. "orderable": false
  129. }, {
  130. targets: 2,
  131. "orderable": false
  132. }],
  133. "sPaginationType": "full_numbers",
  134. dom: '<"html5buttons"B>lTfgitp',
  135. buttons: [{
  136. extend: 'copy'
  137. },
  138. {
  139. extend: 'csv'
  140. },
  141. {
  142. extend: 'excel'
  143. },
  144. {
  145. extend: 'pdf'
  146. },
  147. {
  148. extend: 'print',
  149. customize: function (win) {
  150. $(win.document.body).addClass('white-bg');
  151. $(win.document.body).css('font-size', '10px');
  152. $(win.document.body).find('table').addClass('compact').css('font-size', 'inherit');
  153. }
  154. }]
  155. });
  156. $('#datatables tbody').on('click', 'tr',
  157. function () {
  158. if ($(this).hasClass('selected')) {
  159. $(this).removeClass('selected');
  160. } else {
  161. table.$('tr.selected').removeClass('selected');
  162. $(this).addClass('selected');
  163. }
  164. });
  165. });
  166. </script>
  167. <?php $this->endBlock(); ?>