not_renewed.blade.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236
  1. @extends('admin/layout')
  2. @section('header')
  3. <link href="{{asset('css/plugins/switchery/switchery.css')}}" rel="stylesheet">
  4. <style>
  5. .btn-danger, .btn-primary, .btn-info {
  6. background: #2a94e0 !important;
  7. border-color: #2a94e0 !important;
  8. }
  9. .table-striped > tbody > tr:nth-of-type(odd) {
  10. background: #f8f8f8 !important;
  11. }
  12. .table-striped > tbody > tr .btn {
  13. background: none !important;
  14. }
  15. .table-striped > tbody > tr td {
  16. font-size: 14px !important;
  17. }
  18. .table-striped > tbody > tr:hover {
  19. background: #ffebd8 !important;
  20. }
  21. .table-striped > tbody > tr:hover .btn {
  22. background: #2a94e0 !important;
  23. color: #fff !important;
  24. }
  25. .table-striped > tbody > tr:hover .btn .glyphicon {
  26. color: #fff !important;
  27. }
  28. </style>
  29. @endsection
  30. @section('content')
  31. @php $authUser=auth()->user() @endphp
  32. <body class="gray-bg">
  33. <div class="wrapper wrapper-content animated fadeInRight">
  34. <div class="row">
  35. <div class="col-sm-12">
  36. <div class="ibox float-e-margins">
  37. <div class="ibox-content">
  38. <form class="row" id="searchForm" onsubmit="units.search();return false;">
  39. <div class="input-group">
  40. <select name="not_renewed_reason_analyze" id="not_renewed_reason_analyze" title=""
  41. class="form-control"
  42. style="width: 150px;float: right" onchange="tips.selectPage();">
  43. <option value="0">未续费原因</option>
  44. <option value="1">效果不好</option>
  45. <option value="2">疫情影响</option>
  46. <option value="3">业务转型</option>
  47. <option value="4">价格高</option>
  48. <option value="5">服务器不在引擎力</option>
  49. </select>
  50. <select name="editorId" id="editorId" title="" class="form-control"
  51. style="width: 150px;float: right" onchange="units.selectPage();">
  52. <option value="">请选择建站采编</option>
  53. @foreach($editors as $item)
  54. <option value="{{$item->id}}">{{$item->nickname}}</option>
  55. @endforeach
  56. </select>
  57. <select name="optimizerId" id="optimizerId" title="" class="form-control"
  58. style="width: 150px;float: right"
  59. onchange="units.selectPage();">
  60. <option value="">请选择优化组长</option>
  61. @foreach($optimizers as $item)
  62. <option value="{{$item->id}}">{{$item->nickname}}</option>
  63. @endforeach
  64. </select>
  65. <select name="manageHelperId" id="manageHelperId" title="" class="form-control"
  66. style="width: 150px;float: right"
  67. onchange="units.selectPage();">
  68. <option value="">请选择项目经理</option>
  69. @foreach($managerHelpers as $item)
  70. <option value="{{$item->id}}">{{$item->nickname}}</option>
  71. @endforeach
  72. </select>
  73. <select name="sellerId" id="sellerId" title="" class="form-control"
  74. style="width: 150px;float: right" onchange="units.selectPage();">
  75. <option value="">请选择销售</option>
  76. @foreach($sellerUsers as $item)
  77. <option value="{{$item->id}}">{{$item->nickname}}</option>
  78. @endforeach
  79. </select>
  80. <select name="serverId" id="serverId" title="" class="form-control"
  81. style="width: 150px;float: right" onchange="units.selectPage();">
  82. <option value="">请选择客服</option>
  83. @foreach($services as $item)
  84. <option value="{{$item->id}}">{{$item->nickname}}</option>
  85. @endforeach
  86. </select>
  87. <div class="input-group" style="width: 150px;float: right">
  88. <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
  89. <input type="text" class="form-control lay-datetime" id="monthRange"
  90. name="endDate" placeholder="请选择过期截止时间" style="width: 150px">
  91. </div>
  92. <div class="input-group" style="width: 150px;float: right">
  93. <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
  94. <input type="text" class="form-control lay-datetime" id="monthRange2"
  95. name="startDate" placeholder="请选择过期起始时间" style="width: 150px">
  96. </div>
  97. <input type="text" placeholder="请输入域名或项目名称" class="input-md form-control"
  98. name="keyword"
  99. id="keyword" style="width: 200px;float: right">
  100. <span class="input-group-btn">
  101. <button type="button" class="btn btn-md btn-primary"
  102. onclick="units.search()"> 搜索</button>
  103. <button type="button" class="btn btn-md" style="margin-left: 10px"
  104. name="btnReset"> 重置</button>
  105. <button type="button" class="btn btn-md btn-primary" style="margin-left: 10px"
  106. onclick="units.export1()"> 导出</button>
  107. </span>
  108. </div>
  109. </form>
  110. <hr>
  111. <div class="table-responsive">
  112. <table id="table" class="table table-condensed" data-mobile-responsive="true"></table>
  113. </div>
  114. </div>
  115. </div>
  116. </div>
  117. </div>
  118. </div>
  119. </body>
  120. @endsection
  121. @section('footer')
  122. <script src="{{asset('js/plugins/layDate-v5.0.9/laydate/laydate.js')}}"></script>
  123. <script>
  124. laydate.render({
  125. elem: '#monthRange'
  126. , type: 'month'
  127. , format: 'yyyy-MM'
  128. });
  129. laydate.render({
  130. elem: '#monthRange2'
  131. , type: 'month'
  132. , format: 'yyyy-MM'
  133. });
  134. var units = {
  135. export1: function () {
  136. var formValues = tips.getFormValues("#searchForm");
  137. var str = $.param(formValues);
  138. window.open('/admin/analyze/index/not-renewed-export?' + str)
  139. },
  140. selectPage: function () {
  141. tips.selectPage();
  142. },
  143. search: function () {
  144. tips.selectPage();
  145. },
  146. openDetail: function (id, title) {
  147. // parent.layerLoad();
  148. tips.page('/admin/sites/' + id + '/overview', title);
  149. }
  150. };
  151. // 月流量 月询盘 月排名 月软文 项目经理 项目进度
  152. var config = {};
  153. config.url = '/admin/analyze/index/not-renewed';
  154. config.pageSize = 20;
  155. config.showColumns = true;
  156. config.columns = [ //字段
  157. {
  158. title: '序号', align: 'center', formatter: function (value, item, index) {
  159. return index + 1;
  160. },
  161. width: '10px'
  162. },
  163. {title: '公司', field: 'cn_title', align: 'center'},
  164. {title: '项目状态', field: 'status', align: 'center'},
  165. {title: '网站', field: 'domain', align: 'center'},
  166. {title: '过期时间', field: 'expired_at', align: 'center'},
  167. {title: '下单时间', field: 'order_at', align: 'center'},
  168. {title: '上线时间', field: 'online_at', align: 'center'},
  169. {title: '达标时间', field: 'reach_at', align: 'center'},
  170. {title: '关键词指标', field: 'keyword_goal', align: 'center'},
  171. {title: '实际达标关键词', field: 'top10', align: 'center'},
  172. {title: '月流量', field: 'traffic', align: 'center'},
  173. {title: '询盘总数', field: 'inquire', align: 'center'},
  174. {title: '未续费原因', field: 'notRenewedReasonAnalyze', align: 'center'},
  175. {title: '销售', field: 'seller_title', align: 'center', visible: false},
  176. {title: '客服', field: 'server_title', align: 'center', visible: false},
  177. {title: '项目总监', field: 'managers_title', align: 'center', visible: false},
  178. {title: '项目经理', field: 'manage_helper_title', align: 'center', visible: false},
  179. {title: '优化组长', field: 'optimizerTitle', align: 'center', visible: false},
  180. {title: '建站采编', field: 'ae_title', align: 'center', visible: false},
  181. {title: '竞价', field: 'bidTitle', align: 'center', visible: false},
  182. {title: '软文', field: 'articleTitle', align: 'center', visible: false},
  183. {title: '设计', field: 'designerTitle', align: 'center', visible: false},
  184. {title: '前端', field: 'webTitle', align: 'center', visible: false},
  185. {title: '合同签订时间', field: 'sign_at', align: 'center', visible: false},
  186. {title: '百千约访时间', field: 'bq_at', align: 'center', visible: false},
  187. {title: '续费次数', field: 'renewal_times', align: 'center', visible: false},
  188. {title: '续费时间', field: 'renewal_at', align: 'center', visible: false},
  189. {
  190. title: '操作', field: 'id', align: 'center',
  191. formatter: function (value, row) {
  192. return '<button onclick="units.openDetail(' + value + ',\'' + row.cn_title + '\')" class="btn btn-xs"><span class="glyphicon glyphicon-menu-hamburger"></span>详情</button><br>';
  193. }
  194. }
  195. ];
  196. tips.bootstrapTable(config);
  197. </script>
  198. @endsection