/** * Danh sách Reader theo định dạng của Datatables. * * @return \Datatable JSON */ public function data() { /** @var \Minhbang\ILib\Reader $query */ $query = Reader::queryDefault()->withUser()->withEnumTitles()->orderUpdated(); if (Request::has('search_form')) { $query = $query->searchWhereBetween('readers.created_at', 'mb_date_vn2mysql')->searchWhereBetween('readers.updated_at', 'mb_date_vn2mysql'); } return Datatable::query($query)->addColumn('index', function (Reader $model) { return $model->user_id; })->addColumn('code', function (Reader $model) { return Html::linkQuickUpdate($model->user_id, $model->code, ['label' => $model->code, 'attr' => 'code', 'title' => trans('ilib::reader.code'), 'class' => 'w-md', 'placement' => 'right'], ['class' => 'a-code']); })->addColumn('name', function (Reader $model) { return "{$model->user_name} <small class=\"text-navy\"><em> - {$model->user_username}</em></small>"; })->addColumn('security_id', function (Reader $model) { return Html::linkQuickUpdate($model->user_id, $model->security_id, ['label' => $model->security, 'attr' => 'security_id', 'title' => trans("ilib::reader.security_id"), 'class' => 'w-md', 'placement' => 'left'], ['class' => 'a-security_id']); })->addColumn('actions', function (Reader $model) { return Html::tableActions($this->route_prefix . 'backend.reader', ['reader' => $model->user_id], $model->user_name, trans('ilib::reader.reader'), ['renderEdit' => false]); })->searchColumns('users.username', 'users.name')->make(); }
/** * Danh sách Reader theo định dạng của Datatables. * * @return \Datatable JSON */ public function data() { /** @var \Minhbang\ILib\Reader $query */ $query = Reader::queryDefault()->allowedEbook()->withUser(); if (Request::has('search_form')) { $query = $query->searchWhereBetween('ebook_reader.expires_at', 'mb_date_vn2mysql'); } return Datatable::query($query)->addColumn('index', function (Reader $model) { return $model->user_id; })->addColumn('code', function (Reader $model) { return $model->code; })->addColumn('name', function (Reader $model) { return "{$model->user_name} <small class=\"text-navy\"><em> - {$model->user_username}</em></small>"; })->addColumn('ebook', function (Reader $model) { return $model->ebook_title; })->addColumn('expires', function (Reader $model) { // chuyển ngày định dạng VN, bỏ phần giây :00 ở cuối $expires_at = substr(mb_date_mysql2vn($model->expires_at), 0, -3); return Html::linkQuickUpdate($model->user_id, $expires_at, ['attr' => 'expires_at', 'title' => trans('ilib::reader.expires_at'), 'class' => 'w-md no-focus', 'placement' => 'left'], ['class' => 'a-expires_at'], route($this->route_prefix . 'backend.reader_ebook.quick_update', ['reader' => $model->user_id, 'ebook' => $model->ebook_id])); })->addColumn('actions', function (Reader $model) { return Html::tableActions($this->route_prefix . 'backend.reader_ebook', ['reader' => $model->user_id, 'ebook' => $model->ebook_id], trans('ilib::reader.allowed_title', ['reader' => "{$model->user_name} ({$model->user_username})", 'ebook' => $model->ebook_title]), trans('ilib::reader.allowed'), ['renderEdit' => false, 'renderShow' => false]); })->searchColumns('users.username', 'users.name')->make(); }