芝麻web文件管理V1.00
编辑当前文件:/home/sditechnicalteam/public_html/app/DataTables/ProposalDataTable.php
editProposalPermission = user()->permission('edit_lead_proposals'); $this->addInvoicePermission = user()->permission('add_invoices'); $this->deleteProposalPermission = user()->permission('delete_lead_proposals'); $this->viewProposalPermission = user()->permission('view_lead_proposals'); } /** * Build DataTable class. * * @param mixed $query Results from query() method. * @return \Yajra\DataTables\DataTableAbstract */ public function dataTable($query) { return datatables() ->eloquent($query) ->addIndexColumn() ->addColumn('action', function ($row) { $action = '
'; $action .= '
' . __('app.view') . '
'; $action .= '
' . __('modules.proposal.publicLink') . '
'; $action .= '
' . trans('app.download') . '
'; if (!$row->signature && $this->editProposalPermission == 'all' || ($this->editProposalPermission == 'added' && user()->id == $row->added_by)) { $action .= '
' . trans('app.edit') . '
'; } if ($row->status != 'declined') { $action .= '
' . trans('app.send') . '
'; } if (($this->addInvoicePermission == 'all' || ($this->addInvoicePermission == 'added' && user()->id == $row->added_by)) && $row->client_id) { $action .= '
' . __('app.create') . ' ' . __('app.invoice') . '
'; } if (!$row->signature && $this->deleteProposalPermission == 'all' || ($this->deleteProposalPermission == 'added' && user()->id == $row->added_by)) { $action .= '
' . trans('app.delete') . '
'; } $action .= '
'; return $action; }) ->editColumn('client_name', function ($row) { return '
' . mb_ucwords($row->client_name) . '
'; }) ->editColumn('status', function ($row) { if ($row->status == 'waiting') { return '
' . __('modules.proposal.' . $row->status); } if ($row->status == 'declined') { return '
' . __('modules.proposal.' . $row->status); } else { return '
' . __('modules.proposal.' . $row->status); } }) ->editColumn('total', function ($row) { return currency_formatter($row->total, $row->currency_symbol); }) ->editColumn( 'valid_till', function ($row) { return Carbon::parse($row->valid_till)->format($this->company->date_format); } ) ->editColumn( 'created_at', function ($row) { return Carbon::parse($row->created_at)->format($this->company->date_format); } ) ->rawColumns(['name', 'action', 'status', 'client_name']) ->removeColumn('currency_symbol'); } public function ajax() { return $this->dataTable($this->query()) ->make(true); } /** * @return \Illuminate\Database\Query\Builder */ public function query() { $request = $this->request(); $model = Proposal::select('proposals.id', 'proposals.hash', 'leads.client_name', 'leads.client_id', 'leads.id as lead_id', 'total', 'valid_till', 'status', 'currencies.currency_symbol', 'leads.company_name', 'proposals.added_by') ->with('signature') ->join('currencies', 'currencies.id', '=', 'proposals.currency_id') ->join('leads', 'leads.id', 'proposals.lead_id'); if ($request->startDate !== null && $request->startDate != 'null' && $request->startDate != '') { $startDate = Carbon::createFromFormat($this->company->date_format, $request->startDate)->toDateString(); $model = $model->where(DB::raw('DATE(proposals.`created_at`)'), '>=', $startDate); } if ($request->endDate !== null && $request->endDate != 'null' && $request->endDate != '') { $endDate = Carbon::createFromFormat($this->company->date_format, $request->endDate)->toDateString(); $model = $model->where(DB::raw('DATE(proposals.`created_at`)'), '<=', $endDate); } if ($request->leadId !== null && $request->leadId != 'null' && $request->leadId != '' && $request->leadId != 'all') { $model = $model->where('proposals.lead_id', $request->leadId); } if ($request->status != 'all' && !is_null($request->status)) { $model = $model->where('proposals.status', '=', $request->status); } if ($this->viewProposalPermission == 'added') { $model = $model->where('proposals.added_by', user()->id); } return $model; } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->setTableId('invoices-table') ->columns($this->getColumns()) ->minifiedAjax() ->orderBy(1) ->destroy(true) ->responsive(true) ->serverSide(true) ->stateSave(true) ->processing(true) ->dom($this->domHtml) ->language(__('app.datatable')) ->parameters([ 'initComplete' => 'function () { window.LaravelDataTables["invoices-table"].buttons().container() .appendTo( "#table-actions") }', 'fnDrawCallback' => 'function( oSettings ) { $("body").tooltip({ selector: \'[data-toggle="tooltip"]\' }) }', ]) ->buttons(Button::make(['extend' => 'excel', 'text' => '
' . trans('app.exportExcel')])); } /** * Get columns. * * @return array */ protected function getColumns() { return [ '#' => ['data' => 'DT_RowIndex', 'orderable' => false, 'searchable' => false, 'visible' => false], __('app.id') => ['data' => 'id', 'name' => 'id', 'title' => __('app.id'), 'visible' => false], __('app.name') => ['data' => 'client_name', 'name' => 'client_name', 'title' => __('app.name')], __('modules.invoices.total') => ['data' => 'total', 'name' => 'total', 'title' => __('modules.invoices.total')], __('app.date') => ['data' => 'created_at', 'name' => 'leads.created_at', 'title' => __('app.date')], __('modules.estimates.validTill') => ['data' => 'valid_till', 'name' => 'valid_till', 'title' => __('modules.estimates.validTill')], __('app.status') => ['data' => 'status', 'name' => 'status', 'title' => __('app.status')], Column::computed('action', __('app.action')) ->exportable(false) ->printable(false) ->orderable(false) ->searchable(false) ->addClass('text-right pr-20') ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'Proposals_' . date('YmdHis'); } public function pdf() { set_time_limit(0); if ('snappy' == config('datatables-buttons.pdf_generator', 'snappy')) { return $this->snappyPdf(); } $pdf = app('dompdf.wrapper'); $pdf->loadView('datatables::print', ['data' => $this->getDataForPrint()]); return $pdf->download($this->getFilename() . '.pdf'); } }