eloquent($query) ->addColumn('folder', function ($query){ return ucfirst($query->folder_name ?? ''); }) ->filterColumn('folder', function ($query, $keyword){ $sql = "mail_folders.name like ?"; $query->whereRaw($sql, ["%{$keyword}%"]); }) ->addColumn('action', function ($query){ return '

'. // ''. ''. ''. ' '. '

'; // =========== Old =============== // return '

'. // ''. // ''. // ''. // ' '. // '

'; }); } public function query() { $user = Auth::user(); $listFromApi = $this->getUserList()->pluck('id')->toArray(); return $user->mailing_list()->newQuery()->whereIn('api_mail_list_id', $listFromApi) ->leftJoin('mail_folders','mail_folders.api_mail_folder_id','=','user_mailing_lists.api_folder_id') ->selectRaw('user_mailing_lists.*, mail_folders.name as folder_name'); } public function getUserList(){ // Get current user mail folder data $currentUser = \auth()->user(); $userMailLists = $currentUser->mailing_list()->pluck('api_mail_list_id')->toArray(); $sendinblue = new SendinBlueEmailService(); //=================== Get data from API ===================// $preMailListContent = $sendinblue->getApiCall('get-lists')['lists'] ?? []; $mailContentCollection = collect($preMailListContent); return $mailContentCollection->whereIn('id',$userMailLists); } public function html() { return $this->builder() ->setTableId('mailinglist-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(1) ->buttons( Button::make('create'), Button::make('export'), Button::make('print'), Button::make('reset'), Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('folder'), Column::make('name'), Column::make('subject'), Column::make('language'), Column::make('from_name'), Column::make('from_email'), Column::make('status'), Column::make('list_id')->title('ID'), Column::make('created_at'), Column::computed('action') ->exportable(false) ->printable(false) ->width(140) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'EMAIL_MailingList_' . date('YmdHis'); } }