' . 'Paid' ; else return ''; }) ->make(true); } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { $user_id = $this->request()->get('user_id',0); if(!empty($user_id)) { $query = CreditHistory::where([ ['user_id', '=', $user_id], // ['credited_by', '=', Auth::user()->username] ]); } else { $query = CreditHistory::where('id',0); } return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->ajax('') ->addAction(['width' => '60px']) ->parameters($this->getBuilderParameters()); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'date_credited', 'credited', 'old_bal', 'new_bal', 'currency', 'status', 'credited_by' ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'reselleruserpaymdatatables_' . time(); } }