/**
* 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();
}
