✏️ Edit: CityTable.php
Path:
/home/thiqat5/electronics.thiqatech.com/platform/plugins/location/src/Tables/CityTable.php
Size: 5.92 KB · Modified: 2022-04-22 10:13:56 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<?php namespace Botble\Location\Tables; use Illuminate\Support\Facades\Auth; use BaseHelper; use Botble\Base\Enums\BaseStatusEnum; use Botble\Location\Repositories\Interfaces\CityInterface; use Botble\Location\Repositories\Interfaces\CountryInterface; use Botble\Location\Repositories\Interfaces\StateInterface; use Botble\Table\Abstracts\TableAbstract; use Html; use Illuminate\Contracts\Routing\UrlGenerator; use Yajra\DataTables\DataTables; class CityTable extends TableAbstract { /** * @var bool */ protected $hasActions = true; /** * @var bool */ protected $hasFilter = true; /** * @var CountryInterface */ protected $countryRepository; /** * @var StateInterface */ protected $stateRepository; /** * CityTable constructor. * @param DataTables $table * @param UrlGenerator $urlGenerator * @param CityInterface $cityRepository * @param CountryInterface $countryRepository * @param StateInterface $stateRepository */ public function __construct( DataTables $table, UrlGenerator $urlGenerator, CityInterface $cityRepository, CountryInterface $countryRepository, StateInterface $stateRepository ) { parent::__construct($table, $urlGenerator); $this->repository = $cityRepository; $this->countryRepository = $countryRepository; $this->stateRepository = $stateRepository; if (!Auth::user()->hasAnyPermission(['city.edit', 'city.destroy'])) { $this->hasOperations = false; $this->hasActions = false; } } /** * {@inheritDoc} */ public function ajax() { $data = $this->table ->eloquent($this->query()) ->editColumn('name', function ($item) { if (!Auth::user()->hasPermission('city.edit')) { return $item->name; } return Html::link(route('city.edit', $item->id), $item->name); }) ->editColumn('state_id', function ($item) { if (!$item->state_id || !$item->state->name) { return '—'; } return Html::link(route('state.edit', $item->state_id), $item->state->name); }) ->editColumn('country_id', function ($item) { if (!$item->country_id || !$item->country->name) { return '—'; } return Html::link(route('country.edit', $item->country_id), $item->country->name); }) ->editColumn('checkbox', function ($item) { return $this->getCheckbox($item->id); }) ->editColumn('created_at', function ($item) { return BaseHelper::formatDate($item->created_at); }) ->editColumn('status', function ($item) { return $item->status->toHtml(); }) ->addColumn('operations', function ($item) { return $this->getOperations('city.edit', 'city.destroy', $item); }); return $this->toJson($data); } /** * {@inheritDoc} */ public function query() { $query = $this->repository->getModel()->select([ 'id', 'name', 'state_id', 'country_id', 'created_at', 'status', ]); return $this->applyScopes($query); } /** * {@inheritDoc} */ public function columns() { return [ 'id' => [ 'title' => trans('core/base::tables.id'), 'width' => '20px', ], 'name' => [ 'title' => trans('core/base::tables.name'), 'class' => 'text-start', ], 'state_id' => [ 'title' => trans('plugins/location::city.state'), 'class' => 'text-start', ], 'country_id' => [ 'title' => trans('plugins/location::city.country'), 'class' => 'text-start', ], 'created_at' => [ 'title' => trans('core/base::tables.created_at'), 'width' => '100px', ], 'status' => [ 'title' => trans('core/base::tables.status'), 'width' => '100px', ], ]; } /** * {@inheritDoc} */ public function buttons() { return $this->addCreateButton(route('city.create'), 'city.create'); } /** * {@inheritDoc} */ public function bulkActions(): array { return $this->addDeleteAction(route('city.deletes'), 'city.destroy', parent::bulkActions()); } /** * {@inheritDoc} */ public function getBulkChanges(): array { return [ 'name' => [ 'title' => trans('core/base::tables.name'), 'type' => 'text', 'validate' => 'required|max:120', ], 'state_id' => [ 'title' => trans('plugins/location::city.state'), 'type' => 'customSelect', 'validate' => 'required|max:120', ], 'country_id' => [ 'title' => trans('plugins/location::city.country'), 'type' => 'customSelect', 'validate' => 'required|max:120', ], 'status' => [ 'title' => trans('core/base::tables.status'), 'type' => 'customSelect', 'choices' => BaseStatusEnum::labels(), 'validate' => 'required|in:' . implode(',', BaseStatusEnum::values()), ], 'created_at' => [ 'title' => trans('core/base::tables.created_at'), 'type' => 'date', ], ]; } }
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF