MiniCollecterCollectedController.php 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222
  1. <?php
  2. namespace App\Admin\Controllers\Collecter;
  3. use App\Admin\Actions\Extensions\CollecterConfigButton;
  4. use App\Admin\Actions\Extensions\ImportCollectJsonButton;
  5. use App\Admin\Actions\Grid\BatchCollecterProcessAction;
  6. use App\Admin\Actions\Grid\BatchCollecterpublishAction;
  7. use App\Admin\Metrics\Collecter\collectedStatus;
  8. use App\Models\Circle\WxCircle;
  9. use App\Models\Collecter\MiniCollecterCollected;
  10. use App\Models\User\WxUser;
  11. use Dcat\Admin\Form;
  12. use Dcat\Admin\Grid;
  13. use Dcat\Admin\Layout\Content;
  14. use Dcat\Admin\Layout\Row;
  15. use Dcat\Admin\Show;
  16. use Dcat\Admin\Http\Controllers\AdminController;
  17. use App\Admin\Metrics\Users\RobotUsers;
  18. use Illuminate\Support\Facades\DB;
  19. class MiniCollecterCollectedController extends AdminController
  20. {
  21. public function index(Content $content)
  22. {
  23. return $content
  24. ->header('收集数据')
  25. ->description('收集的数据在处理完成之后,你可以手动勾选发布,也可以等程序自动发布(10分站一次)')
  26. ->body(function (Row $row) {
  27. $row->column(6,new RobotUsers());
  28. $row->column(6,new collectedStatus());
  29. })
  30. ->body($this->grid());
  31. }
  32. /**
  33. * Make a grid builder.
  34. *
  35. * @return Grid
  36. */
  37. protected function grid()
  38. {
  39. return Grid::make(new MiniCollecterCollected(), function (Grid $grid) {
  40. $counts = DB::table('wx_user')
  41. ->select(
  42. DB::raw('SUM(CASE WHEN is_robot > 0 THEN 1 ELSE 0 END) AS robot_count'),
  43. DB::raw('SUM(CASE WHEN is_robot = 1 THEN 1 ELSE 0 END) AS free_robot_count'),
  44. )->first();
  45. if($counts){
  46. if($counts->robot_count <= 0){
  47. $grid->header(function ($collection) {
  48. return '<div style="background-color: powderblue;color: #414750;padding: 10px;border-radius: 5px;display: inline-block;margin-top: 20px;">你还一个机器人都没有呢,无法做任何操作,先去<a href="'.admin_url('users').'">用户管理</a>添加机器人</div>';
  49. });
  50. }else if($counts->free_robot_count <= 0){
  51. $grid->header(function ($collection) {
  52. return '<div style="background-color: powderblue;color: #414750;padding: 10px;border-radius: 5px;display: inline-block;margin-top: 20px;">可绑定的机器人不足,你可以去<a href="'.admin_url('users').'">用户管理</a>添加机器人, 默认一个机器人账号绑定一个第三方账号,你也可以设置一个机器人账号绑定多个第三方账号</div>';
  53. });
  54. }
  55. }
  56. $grid->simplePaginate();
  57. $grid->quickSearch(['id', 'link','author','title', 'content'])->placeholder('搜索文章ID,标题,内容,作者...')->width(50);
  58. $grid->column('id')->sortable();
  59. $grid->model()->orderBy('id', 'desc');
  60. // $grid->column('post_unique');
  61. // $grid->column('author_unique');
  62. $grid->column('link')->display(function ($v){
  63. return '<a href="'.$v.'" target="_blank">查看</a>';
  64. });
  65. $grid->column('author');
  66. $grid->column('title_or_content', '预览')->display(function ($v){
  67. if($this->title){
  68. return $this->title;
  69. }
  70. if($this->content){
  71. return mb_substr(strip_tags($this->content), 0, 40) . '...';
  72. }
  73. return '';
  74. })->limit(20);
  75. $grid->column('imgs')->display(function ($v){
  76. return count(json_decode($v, true));
  77. });
  78. $grid->column('comments')->display(function ($v){
  79. if(is_string($v)){
  80. $com_arr = json_decode($v, true);
  81. if($com_arr && is_array($com_arr)){
  82. return count($com_arr);
  83. }
  84. }else if(is_array($v)){
  85. return count($v);
  86. }
  87. });
  88. $grid->column('tags')->display(function ($v){
  89. return count(json_decode($v, true));
  90. });
  91. $grid->column('musics');
  92. $grid->column('videos')->display(function ($v){
  93. if(is_string($v)){
  94. return count(json_decode($v, true));
  95. }else if(is_array($v)){
  96. return count($v);
  97. }
  98. return 0;
  99. });
  100. $grid->column('post_id');
  101. $grid->column('status')->using([0 => '待处理', 1 => '待发布', 2 => '已发布', 3 => '处理中', 4 => '处理失败'])->label([
  102. 0=>'red',
  103. 1=>'green',
  104. 2=>'default',
  105. 3 => 'red',
  106. 4 => 'darkred'
  107. ])->sortable();
  108. $grid->column('tenant_id')->editable();
  109. // $grid->column('created_at');
  110. $grid->column('updated_at')->sortable();
  111. $grid->filter(function (Grid\Filter $filter) {
  112. $filter->equal('id');
  113. });
  114. $grid->tools([
  115. new CollecterConfigButton(),
  116. new ImportCollectJsonButton()
  117. ]);
  118. $grid->disableCreateButton();
  119. $grid->batchActions(function ($batch) {
  120. $batch->add((new BatchCollecterpublishAction()));
  121. $batch->add((new BatchCollecterProcessAction()));
  122. });
  123. $grid->actions(function (Grid\Displayers\Actions $actions) {
  124. // $actions->append((new PostCommentLotteryAction())->setKey($this->id));
  125. });
  126. });
  127. }
  128. /**
  129. * Make a show builder.
  130. *
  131. * @param mixed $id
  132. *
  133. * @return Show
  134. */
  135. protected function detail($id)
  136. {
  137. return Show::make($id, new MiniCollecterCollected(), function (Show $show) {
  138. $show->field('id');
  139. $show->field('post_unique');
  140. $show->field('author_unique');
  141. $show->field('link');
  142. $show->field('author');
  143. $show->field('title');
  144. $show->field('content');
  145. $show->field('imgs');
  146. $show->field('comments');
  147. $show->field('tags');
  148. $show->field('musics');
  149. $show->field('videos');
  150. $show->field('post_id');
  151. $show->field('circle_id');
  152. $show->field('user_id');
  153. $show->field('tenant_id');
  154. $show->field('status');
  155. $show->field('created_at');
  156. $show->field('updated_at');
  157. });
  158. }
  159. /**
  160. * Make a form builder.
  161. *
  162. * @return Form
  163. */
  164. protected function form()
  165. {
  166. return Form::make(new MiniCollecterCollected(), function (Form $form) {
  167. $form->display('id');
  168. $form->text('post_unique');
  169. $form->text('author_unique');
  170. $form->text('link');
  171. $form->text('author');
  172. $form->text('title');
  173. if(__system_is_model_enable('laradocs', 'dcat-neditor')){
  174. $form->neditor('content');
  175. }else{
  176. $form->editor('content');
  177. }
  178. // $form->text('imgs');
  179. // $form->text('comments');
  180. // $form->text('tags');
  181. // $form->text('musics');
  182. // $form->text('videos');
  183. $form->text('post_id');
  184. $form->select('circle_id', '发布圈子')->options(WxCircle::pluck('circle_name','id'));
  185. $form->select('user_id', '用户')->options(function ($id) {
  186. if($id){
  187. $user = \App\Models\User\WxUser::find($id);
  188. if ($user) {
  189. return [$user->id => $user->user_name];
  190. }
  191. }
  192. })->ajax('select/users');
  193. // $form->text('status');
  194. $form->text('tenant_id');
  195. $form->display('created_at');
  196. $form->display('updated_at');
  197. $form->deleting(function (Form $form){
  198. global $__MINI_GLOBAL_TENANT_ID__;
  199. if($__MINI_GLOBAL_TENANT_ID__ > 0){
  200. return $form->response()->error('权限不足,不可以删除其他分站对象');
  201. }
  202. });
  203. });
  204. }
  205. }