/** * ajax-based serverside processed datatables example action */ public function action_datatables_ajax() { // Column definition $columns = array("test1" => "Testcolumn #1", "test2" => "Testcolumn #2"); // Generate random data $data = Session::instance()->get('dattables_example', array()); if (empty($data)) { for ($i = 0; $i < 5000; $i++) { $data[] = array('test1' => $this->generateRandomString(25), 'test2' => $this->generateRandomString(25)); } } // Create datatable $datatable = new Datatable($columns); // Here you could also pass in a orm model like this: $datatable->add_entries(ORM::factory('Model')); // Then the model needs to have columns named like the keys in the column definition, so in this example // test1 and test2 are needed properties on the model. $datatable->add_entries($data); $datatable->set_serverside(URL::base() . 'UIFWExamples/datatables_ajax'); // Render html code from datatable->render() with the html layout if (Request::$current->is_ajax()) { echo $datatable->ajax_render(); } else { $this->renderHtml($datatable->render()); } }
public function getUsersDataTable() { $query = UserModel::select('username', 'roles', 'id')->get(); return Datatable::collection($query)->addColumn('id', function ($model) { return '<a href="/users/' . $model->id . '">view</a>'; })->searchColumns('username', 'roles')->orderColumns('username', 'roles')->make(); }
public function getDatatable($clientPublicId = null) { $credits = $this->creditRepo->find($clientPublicId, Input::get('sSearch')); $table = Datatable::query($credits); if (!$clientPublicId) { $table->addColumn('checkbox', function ($model) { return '<input type="checkbox" name="ids[]" value="' . $model->public_id . '">'; })->addColumn('client_name', function ($model) { return link_to('clients/' . $model->client_public_id, Utils::getClientDisplayName($model)); }); } return $table->addColumn('amount', function ($model) { return Utils::formatMoney($model->amount, $model->currency_id); })->addColumn('balance', function ($model) { return Utils::formatMoney($model->balance, $model->currency_id); })->addColumn('credit_date', function ($model) { return Utils::fromSqlDate($model->credit_date); })->addColumn('private_notes', function ($model) { return $model->private_notes; })->addColumn('dropdown', function ($model) { return '<div class="btn-group tr-action" style="visibility:hidden;"> <button type="button" class="btn btn-xs btn-default dropdown-toggle" data-toggle="dropdown"> ' . trans('texts.select') . ' <span class="caret"></span> </button> <ul class="dropdown-menu" role="menu"> <li><a href="javascript:archiveEntity(' . $model->public_id . ')">' . trans('texts.archive_credit') . '</a></li> <li><a href="javascript:deleteEntity(' . $model->public_id . ')">' . trans('texts.delete_credit') . '</a></li> </ul> </div>'; })->make(); }
/** * getDatatable */ public function getDatatable() { $collection = Department::all(); return Datatable::collection($collection)->showColumns('name', 'right')->orderColumns('name')->searchColumns('name')->addColumn('actions', function ($model) { return $str = '<button data-id="' . $model->id . '" class="btn btn-info btn-department">查看部门</button>'; })->make(); }
/** * getHistroy(入库历史) */ public function getDatatable() { $collection = HistoryWarehouse::all(); return Datatable::collection($collection)->showColumns('date', 'identity', 'item', 'batch', 'quantity', 'position', 'operator')->searchColumns('date')->orderColumns('date', 'identity', 'item', 'batch', 'quantity', 'position', 'operator')->addColumn('date', function ($model) { return date('Y-m-d H:i', strtotime($model->created_at)); })->make(); }
public function getClientDatatable() { $search = Input::get('sSearch'); $invitationKey = Session::get('invitation_key'); $invitation = Invitation::where('invitation_key', '=', $invitationKey)->with('contact.client')->first(); if (!$invitation) { return []; } $invoice = $invitation->invoice; if (!$invoice || $invoice->is_deleted) { return []; } $payments = $this->paymentRepo->findForContact($invitation->contact->id, Input::get('sSearch')); return Datatable::query($payments)->addColumn('invoice_number', function ($model) { return $model->invitation_key ? link_to('/view/' . $model->invitation_key, $model->invoice_number) : $model->invoice_number; })->addColumn('transaction_reference', function ($model) { return $model->transaction_reference ? $model->transaction_reference : '<i>Manual entry</i>'; })->addColumn('payment_type', function ($model) { return $model->payment_type ? $model->payment_type : ($model->account_gateway_id ? '<i>Online payment</i>' : ''); })->addColumn('amount', function ($model) { return Utils::formatMoney($model->amount, $model->currency_id); })->addColumn('payment_date', function ($model) { return Utils::dateToString($model->payment_date); })->make(); }
/** * This function is used to display the list of Organizations * @return datatable */ public function org_list() { return \Datatable::collection(Organization::all())->searchColumns('name')->orderColumns('name', 'website')->addColumn('name', function ($model) { return $model->name; })->addColumn('website', function ($model) { $website = $model->website; return $website; })->addColumn('phone', function ($model) { $phone = $model->phone; return $phone; })->addColumn('Actions', function ($model) { //return '<a href=article/delete/ ' . $model->id . ' class="btn btn-danger btn-flat" onclick="myFunction()">Delete</a> <a href=article/' . $model->id . '/edit class="btn btn-warning btn-flat">Edit</a> <a href=show/' . $model->id . ' class="btn btn-warning btn-flat">View</a>'; //return '<form action="article/delete/ ' . $model->id . '" method="post" onclick="alert()"><button type="sumbit" value="Delete"></button></form><a href=article/' . $model->id . '/edit class="btn btn-warning btn-flat">Edit</a> <a href=show/' . $model->id . ' class="btn btn-warning btn-flat">View</a>'; return '<span data-toggle="modal" data-target="#deletearticle' . $model->id . '"><a href="#" ><button class="btn btn-danger btn-xs"></a> ' . \Lang::get('lang.delete') . ' </button></span> <a href="' . route('organizations.edit', $model->id) . '" class="btn btn-warning btn-xs">' . \Lang::get('lang.edit') . '</a> <a href="' . route('organizations.show', $model->id) . '" class="btn btn-primary btn-xs">' . \Lang::get('lang.view') . '</a> <div class="modal fade" id="deletearticle' . $model->id . '"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title">Are You Sure ?</h4> </div> <div class="modal-body"> ' . $model->user_name . ' </div> <div class="modal-footer"> <button type="button" class="btn btn-default pull-left" data-dismiss="modal" id="dismis2">Close</button> <a href="' . route('org.delete', $model->id) . '"><button class="btn btn-danger">delete</button></a> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div>'; })->make(); }
public static function Create($config) { if (empty($config)) { throw new \Exception(__CLASS__ . '. Config not found.'); } $dt = Datatable::make(); $dt->id($config['id']); // Table id in the DOM $dt->displayStart($config['display-start']); // DT offset parameter $dt->displayLength($config['display-length']); // DT page length parameter $dt->rowSourceUrl($config['row-source']); // DT row source URL $dt->columns($config['columns']); // DT columns $dt->dom($config['dom']); // DT dom $dt->name($config['name']); $dt->caption($config['caption']); $dt->icon($config['icon']); $dt->defaultOrder($config['default-order']); if ($config['custom_styles']) { $dt->custom_styles($config['custom_styles']); } if ($config['custom_scripts']) { $dt->custom_scripts($config['custom_scripts']); } return $dt; }
public function buscar_registros_dt() { return \Datatable::query($this->repo_main->buscar_todos_dt())->addColumn('descripcion', function ($model) { return $model->denominacion; })->addColumn('esta_vigente', function ($model) { if ($model->esta_vigente == 1) { return '<i class="fa fa-check-square-o"></i>'; } else { return '<i class="fa fa-square-o"></i>'; } })->addColumn('nivel_nacional', function ($model) { if ($model->nivel_nacional == 1) { return '<i class="fa fa-check-square-o"></i>'; } else { return '<i class="fa fa-square-o"></i>'; } })->addColumn('nivel_zonal', function ($model) { if ($model->nivel_zonal == 1) { return '<i class="fa fa-check-square-o"></i>'; } else { return '<i class="fa fa-square-o"></i>'; } })->addColumn('nivel_distrital', function ($model) { if ($model->nivel_distrital == 1) { return '<i class="fa fa-check-square-o"></i>'; } else { return '<i class="fa fa-square-o"></i>'; } })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('seguridades/roles/editar') . '/' . Crypt::encrypt($model->id_rol) . '" class="btn btn-default btn-xs btn-mini "><i class="fa fa-pencil"></i></a>' . '<a href="' . url('seguridades/roles/eliminar') . '/' . Crypt::encrypt($model->id_rol) . '" class="btn btn-dark btn-xs btn-mini"><i class="fa fa-trash-o"></i></a>' . '<a href="' . url('seguridades/roles/permisos/listar') . '/' . Crypt::encrypt($model->id_rol) . '" class="btn btn-primary btn-xs btn-mini"><i class="fa fa-bars"></i> permisos</a>' . '</div>'; })->searchColumns('denominacion', 'denominacion_visual', 'esta_vigente', 'nivel_nacional', 'nivel_zonal', 'nivel_distrital')->orderColumns('denominacion', 'denominacion_visual', 'esta_vigente', 'nivel_nacional', 'nivel_zonal', 'nivel_distrital')->make(); }
public function getDatatable() { $clients = $this->clientRepo->find(Input::get('sSearch')); return Datatable::query($clients)->addColumn('checkbox', function ($model) { return '<input type="checkbox" name="ids[]" value="' . $model->public_id . '">'; })->addColumn('name', function ($model) { return link_to('clients/' . $model->public_id, $model->name); })->addColumn('first_name', function ($model) { return link_to('clients/' . $model->public_id, $model->first_name . ' ' . $model->last_name); })->addColumn('email', function ($model) { return link_to('clients/' . $model->public_id, $model->email); })->addColumn('created_at', function ($model) { return Utils::timestampToDateString(strtotime($model->created_at)); })->addColumn('last_login', function ($model) { return Utils::timestampToDateString(strtotime($model->last_login)); })->addColumn('balance', function ($model) { return Utils::formatMoney($model->balance, $model->currency_id); })->addColumn('dropdown', function ($model) { return '<div class="btn-group tr-action" style="visibility:hidden;"> <button type="button" class="btn btn-xs btn-default dropdown-toggle" data-toggle="dropdown"> ' . trans('texts.select') . ' <span class="caret"></span> </button> <ul class="dropdown-menu" role="menu"> <li><a href="' . URL::to('clients/' . $model->public_id . '/edit') . '">' . trans('texts.edit_client') . '</a></li> <li class="divider"></li> <li><a href="' . URL::to('invoices/create/' . $model->public_id) . '">' . trans('texts.new_invoice') . '</a></li> <li><a href="' . URL::to('payments/create/' . $model->public_id) . '">' . trans('texts.new_payment') . '</a></li> <li><a href="' . URL::to('credits/create/' . $model->public_id) . '">' . trans('texts.new_credit') . '</a></li> <li class="divider"></li> <li><a href="javascript:archiveEntity(' . $model->public_id . ')">' . trans('texts.archive_client') . '</a></li> <li><a href="javascript:deleteEntity(' . $model->public_id . ')">' . trans('texts.delete_client') . '</a></li> </ul> </div>'; })->make(); }
public function getDatatable() { $products = $this->ProductRepo->find(Input::get('sSearch')); return Datatable::query($products)->addColumn('checkbox', function ($model) { return '<input type="checkbox" name="ids[]" value="' . $model->public_id . '">'; })->addColumn('product_key', function ($model) { return link_to('products/' . $model->public_id, $model->product_key); })->addColumn('notes', function ($model) { return nl2br(Str::limit($model->notes, 50)); })->addColumn('cost', function ($model) { return Utils::formatMoney($model->cost, 1); })->addColumn('name', function ($model) { return nl2br($model->category_name); })->addColumn('dropdown', function ($model) { return '<div class="btn-group tr-action" style="visibility:hidden;"> <button type="button" class="btn btn-xs btn-default dropdown-toggle" data-toggle="dropdown"> ' . trans('texts.select') . ' <span class="caret"></span> </button> <ul class="dropdown-menu" role="menu"> <li><a href="' . URL::to('products/' . $model->public_id) . '/edit">' . uctrans('texts.edit_product') . '</a></li> <li class="divider"></li> <li><a href="' . URL::to('products/' . $model->public_id) . '/archive">' . uctrans('texts.delete_product') . '</a></li> </ul> </div>'; })->make(); }
public function getDatatable($accountId, $clientPublicId = null, $entityType, $search) { $query = $this->getInvoices($accountId, $clientPublicId, $search)->where('invoices.is_quote', '=', $entityType == ENTITY_QUOTE ? true : false); $table = \Datatable::query($query); if (!$clientPublicId) { $table->addColumn('checkbox', function ($model) { return '<input type="checkbox" name="ids[]" value="' . $model->public_id . '">'; }); } $table->addColumn("invoice_number", function ($model) use($entityType) { return link_to("{$entityType}s/" . $model->public_id . '/edit', $model->invoice_number); }); if (!$clientPublicId) { $table->addColumn('client_name', function ($model) { return link_to('clients/' . $model->client_public_id, Utils::getClientDisplayName($model)); }); } $table->addColumn("invoice_date", function ($model) { return Utils::fromSqlDate($model->invoice_date); })->addColumn('amount', function ($model) { return Utils::formatMoney($model->amount, $model->currency_id); }); if ($entityType == ENTITY_INVOICE) { $table->addColumn('balance', function ($model) { return Utils::formatMoney($model->balance, $model->currency_id); }); } return $table->addColumn('due_date', function ($model) { return Utils::fromSqlDate($model->due_date); })->addColumn('invoice_status_name', function ($model) { return $model->invoice_status_name; })->addColumn('dropdown', function ($model) use($entityType) { $str = '<div class="btn-group tr-action" style="visibility:hidden;"> <button type="button" class="btn btn-xs btn-default dropdown-toggle" data-toggle="dropdown"> ' . trans('texts.select') . ' <span class="caret"></span> </button> <ul class="dropdown-menu" role="menu"> <li><a href="' . \URL::to("{$entityType}s/" . $model->public_id . '/edit') . '">' . trans("texts.edit_{$entityType}") . '</a></li> <li><a href="' . \URL::to("{$entityType}s/" . $model->public_id . '/clone') . '">' . trans("texts.clone_{$entityType}") . '</a></li> <li class="divider"></li><li>'; if ($entityType == ENTITY_INVOICE) { $str .= '<a href="' . \URL::to('payments/create/' . $model->client_public_id . '/' . $model->public_id) . '">' . trans('texts.enter_payment') . '</a></li>'; if ($model->quote_id) { $str .= '<li><a href="' . \URL::to("quotes/{$model->quote_id}/edit") . '">' . trans("texts.view_quote") . '</a></li>'; } } else { if ($entityType == ENTITY_QUOTE) { if ($model->quote_invoice_id) { $str .= '<li><a href="' . \URL::to("invoices/{$model->quote_invoice_id}/edit") . '">' . trans("texts.view_invoice") . '</a></li>'; } } } return $str . '<li class="divider"></li> <li><a href="javascript:archiveEntity(' . $model->public_id . ')">' . trans("texts.archive_{$entityType}") . '</a></li> <li><a href="javascript:deleteEntity(' . $model->public_id . ')">' . trans("texts.delete_{$entityType}") . '</a></li> </ul> </div>'; })->make(); }
public function buscar_registros_dt($id_proceso) { return \Datatable::query($this->repo_main->buscar_todos_dt(Crypt::decrypt($id_proceso)))->addColumn('nombre', function ($model) { return $model->nombre; })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('catalogos/procesos_ac/requisitos/editar') . '/' . Crypt::encrypt($model->id_requisitos) . '" class="btn btn-default btn-xs btn-mini "><i class="fa fa-pencil"></i></a>' . '<a href="' . url('catalogos/procesos_ac/requisitos/eliminar') . '/' . Crypt::encrypt($model->id_requisitos) . '" class="btn btn-danger btn-xs btn-mini"><i class="fa fa-trash-o"></i></a>' . '</div>'; })->searchColumns('id_proceso', 'nombre', 'observaciones')->orderColumns('id_proceso', 'nombre', 'observaciones')->make(); }
public function buscar_registros_dt() { return \Datatable::query($this->repo_servicios->buscar_todos_dt())->addColumn('denominacion', function ($model) { return $model->denominacion; })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('catalogos/servicios_ac/editar') . '/' . Crypt::encrypt($model->id_servicio) . '" class="btn btn-default btn-xs btn-mini "><i class="fa fa-pencil"></i></a>' . '<a href="' . url('catalogos/servicios_ac/eliminar') . '/' . Crypt::encrypt($model->id_servicio) . '" class="btn btn-dark btn-xs btn-mini"><i class="fa fa-trash-o"></i></a> ' . '</div>'; })->searchColumns('denominacion')->orderColumns('denominacion')->make(); }
/** * Another example method that returns a data table. * @param int $idSite * @param string $period * @param string $date * @param bool|string $segment * @return DataTable */ public function getBannerstatistics($idSite, $period, $date, $segment = false, $idSubtable = false, $filter_limit = 10, $filter_sort_column = 'impressions', $filter_sort_order = 'desc', $filter_pattern = null) { $params = array('idSite' => $idSite, 'period' => $period, 'date' => $date, 'segment' => $segment, 'filter_limit' => $filter_limit, 'filter_sort_column' => $filter_sort_column, 'filter_sort_order' => $filter_sort_order, 'filter_pattern' => $filter_pattern); if ($idSubtable) { return $this->bannerStats($idSubtable, $params); } $contentNames = \Piwik\API\Request::processRequest('Contents.getContentNames', $params); $bannerTable = new Datatable(); //$period = $dataTable->getMetadata(DataTableFactory::TABLE_METADATA_PERIOD_INDEX); //$bannerTable->setMetadataValues($contentNames->getAllTableMetadata()); foreach ($contentNames->getRows() as $contentName) { $bannerName = $contentName->getColumn('label'); $row = new Row(array(Row::COLUMNS => array('Name' => $bannerName, 'Visits' => $contentName->getColumn('nb_visits'), 'Impressions' => $contentName->getColumn('nb_impressions'), 'Interactions' => $contentName->getColumn('nb_interactions'), 'Conversion rate' => $contentName->getColumn('interaction_rate')), Row::DATATABLE_ASSOCIATED => $bannerName)); $bannerTable->addRow($row); } return $bannerTable; }
public static function datatable($timestamps = true) { $filters = Input::get('filters'); $model = static::getClass(); $query = static::getDTquery(Input::get('trash'), $timestamps); $query = static::filterDTQuery($filters, $query, $model); $query = static::selectDTFields($query); $dataTable = Datatable::query($query); return $dataTable; }
public function getManageUser() { $operator = Sentry::findAllUsersWithAccess('operator'); $operatorCollection = new Illuminate\Database\Eloquent\Collection($operator); $data = Datatable::collection($operatorCollection)->addColumn('full_name', function ($model) { return $model->first_name . ' ' . $model->last_name; })->showColumns('id', 'email', 'last_login')->searchColumns('full_name', 'email', 'last_login')->orderColumns('full_name', 'email', 'last_login')->make(); $group = Group::all(); return View::make('dashboard.admin.manageuser')->with('group', $group); }
public function buscar_registros_dt($id_rol) { return \Datatable::query($this->repo_main->buscar_todos_dt(Crypt::decrypt($id_rol)))->addColumn('modulo', function ($model) { return $model->modulo; })->addColumn('agrupador', function ($model) { return '<small class="text-muted text-xs">' . $model->agrupador . '</small>'; })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('seguridades/roles/permisos/eliminar') . '/' . Crypt::encrypt($model->id_rol_modulo) . '" class="btn btn-dark btn-xs btn-mini"><i class="fa fa-trash-o"></i></a>' . '</div>'; })->searchColumns('config_rol_modulo.id_rol_modulo', 'config_modulo.descripcion', 'config_modulosubsistema.descripcion')->orderColumns('config_rol_modulo.id_rol_modulo', 'config_modulo.descripcion', 'config_modulosubsistema.descripcion')->make(); }
public function buscar_registros_dt($id_provincia) { return \Datatable::query($this->repo_main->buscar_todos_dt($id_provincia))->addColumn('denominacion', function ($model) { return $model->denominacion; })->addColumn('codigo', function ($model) { return $model->codigo; })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('catalogos/ciudades/editar') . '/' . Crypt::encrypt($model->id_ciudad) . '" class="btn btn-default btn-xs btn-mini "><i class="fa fa-pencil"></i></a>' . '<a href="' . url('catalogos/ciudades/eliminar') . '/' . Crypt::encrypt($model->id_ciudad) . '" class="btn btn-dark btn-xs btn-mini"><i class="fa fa-trash-o"></i></a>' . '<a href="' . url('catalogos/parroquias/listar') . '/' . Crypt::encrypt($model->id_ciudad) . '" class="btn btn-warning btn-xs btn-mini"><i class="fa fa-bars"></i> parroquias</a>' . '</div>'; })->searchColumns('denominacion', 'codigo')->orderColumns('denominacion', 'codigo')->make(); }
/** * Display a listing of the resource. * * @return Response */ public function index() { if (Datatable::shouldHandle()) { $operator = Sentry::findAllUsersWithAccess('operator'); $operatorCollection = new Illuminate\Database\Eloquent\Collection($operator); return Datatable::collection($operatorCollection)->addColumn('full_name', function ($model) { return $model->first_name . ' ' . $model->last_name; })->showColumns('id', 'email', 'last_login')->searchColumns('full_name', 'email', 'last_login')->orderColumns('full_name', 'email', 'last_login')->make(); } return View::make('dashboard.admin.manageuser'); }
/** * @return bool */ public function getUsersDataTable() { $query = UserModel::select('username', 'roles', 'id')->get(); return Datatable::collection($query)->searchColumns('username', 'roles')->orderColumns('username', 'roles')->addColumn('username', function ($model) { return $model->username; })->addColumn('roles', function ($model) { return $model->roles; })->addColumn('Actions', function ($model) { return "<a href='/projectinv/public/resource/" . $model->id . "' class='btn btn-success'>View</a>"; })->make(); }
public function borrowList() { if (Datatable::shouldHandle()) { return Datatable::collection(Book::with('author')->orderBy('id', 'desc')->get())->showColumns('id', 'title', 'amount', 'stock')->addColumn('author', function ($model) { return $model->author->name; })->addColumn('borrow', function ($model) { $html = '<a href="' . route('books.borrow', $model->id) . '" class="btn btnn"> <i class="mdi-action-grade"></i> </a>'; return $html; })->searchColumns('title', 'amount', 'author')->orderColumns('title', 'amount', 'author')->make(); } }
public function buscar_registros_dt() { return \Datatable::query($this->repo_main->buscar_todos_dt())->addColumn('codigoSemplades', function ($model) { return $model->codigoSemplades; })->addColumn('zona', function ($model) { return $model->zona; })->addColumn('denominacion_institucional', function ($model) { return $model->denominacion_institucional; })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('catalogos/distritos/editar') . '/' . Crypt::encrypt($model->id_distrito) . '" class="btn btn-default btn-xs btn-mini "><i class="fa fa-pencil"></i></a>' . '<a href="' . url('catalogos/distritos/eliminar') . '/' . Crypt::encrypt($model->id_distrito) . '" class="btn btn-dark btn-xs btn-mini"><i class="fa fa-trash-o"></i></a> ' . '</div>'; })->searchColumns('div_distrito.id_distrito', 'div_distrito.codigoSemplades', 'div_distrito.denominacion', 'div_distrito.denominacion_institucional', 'div_zona.denominacion')->orderColumns('div_distrito.id_distrito', 'div_distrito.codigoSemplades', 'div_distrito.denominacion', 'div_distrito.denominacion_institucional', 'div_zona.denominacion')->make(); }
public function buscar_registros_dt($id_subsistema) { return \Datatable::query($this->repo_main->buscar_todos_dt(Crypt::decrypt($id_subsistema)))->addColumn('descripcion', function ($model) { return $model->descripcion . ' <small class="text-muted">(' . $model->texto . ')</small>'; })->addColumn('esta_activo', function ($model) { return '[' . $model->controlador . ']' . '[' . $model->accion . ']'; })->addColumn('icon', function ($model) { return '<i class="' . $model->icon . '"></i>'; })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('seguridades/modulos/detalles/editar') . '/' . Crypt::encrypt($model->id_modulo) . '" class="btn btn-default btn-xs btn-mini "><i class="fa fa-pencil"></i></a>' . '<a href="' . url('seguridades/modulos/detalles/eliminar') . '/' . Crypt::encrypt($model->id_modulo) . '" class="btn btn-dark btn-xs btn-mini"><i class="fa fa-trash-o"></i></a>' . '</div>'; })->searchColumns('id_modulo', 'id_subsistema', 'orden', 'descripcion', 'texto', 'accion', 'controlador', 'icon')->orderColumns('id_modulo', 'id_subsistema', 'orden', 'descripcion', 'texto', 'accion', 'controlador', 'icon')->make(); }
public function buscar_registros_dt() { return \Datatable::query($this->repo_main->buscar_todos_dt())->addColumn('codigo_amie', function ($model) { return $model->codigo_amie; })->addColumn('denominacion', function ($model) { return $model->denominacion; })->addColumn('ubicacion', function ($model) { return '<small class="text-muted text-xs">' . $model->ubicacion . '<br>' . $model->ubicacion2 . '</small>'; })->addColumn('commands', function ($model) { return '<div class="btn-group">' . '<a href="' . url('catalogos/ies/editar') . '/' . Crypt::encrypt($model->id_institucion_educativa) . '" class="btn btn-default btn-xs btn-mini "><i class="fa fa-pencil"></i></a>' . '<a href="' . url('catalogos/ies/eliminar') . '/' . Crypt::encrypt($model->id_institucion_educativa) . '" class="btn btn-dark btn-xs btn-mini"><i class="fa fa-trash-o"></i></a> ' . '</div>'; })->searchColumns('id_institucion_educativa', 'codigo_amie', 'div_institucion_educativa.denominacion', 'div_distrito.denominacion', 'div_circuito.codigoSemplades', 'div_zona.denominacion', 'div_ciudad.denominacion')->orderColumns('codigo_amie', 'id_institucion_educativa', 'div_institucion_educativa.denominacion')->make(); }
public function getClientDatatable($clientId) { $query = DB::table('credits')->join('accounts', 'accounts.id', '=', 'credits.account_id')->join('clients', 'clients.id', '=', 'credits.client_id')->where('credits.client_id', '=', $clientId)->where('clients.deleted_at', '=', null)->where('credits.deleted_at', '=', null)->where('credits.balance', '>', 0)->select(DB::raw('COALESCE(clients.currency_id, accounts.currency_id) currency_id'), DB::raw('COALESCE(clients.country_id, accounts.country_id) country_id'), 'credits.amount', 'credits.balance', 'credits.credit_date'); $table = \Datatable::query($query)->addColumn('credit_date', function ($model) { return Utils::fromSqlDate($model->credit_date); })->addColumn('amount', function ($model) { return Utils::formatMoney($model->amount, $model->currency_id, $model->country_id); })->addColumn('balance', function ($model) { return Utils::formatMoney($model->balance, $model->currency_id, $model->country_id); })->make(); return $table; }
/** * This function is used to display the list of users * @return datatable */ public function user_list() { return \Datatable::collection(User::where('role', '!=', 'admin')->where('role', '!=', 'agent')->get())->searchColumns('user_name')->orderColumns('user_name', 'email')->addColumn('user_name', function ($model) { return $model->user_name; })->addColumn('email', function ($model) { $email = $model->email; return $email; })->addColumn('phone', function ($model) { $phone = ""; if ($model->phone_number) { $phone = $model->ext . ' ' . $model->phone_number; } $mobile = ""; if ($model->mobile) { $mobile = $model->mobile; } $phone = $phone . " " . $mobile; return $phone; })->addColumn('status', function ($model) { $status = $model->active; if ($status == 1) { $stat = '<button class="btn btn-success btn-xs">Active</button>'; } else { $stat = '<button class="btn btn-danger btn-xs">Inactive</button>'; } return $stat; })->addColumn('lastlogin', function ($model) { $t = $model->updated_at; return TicketController::usertimezone($t); })->addColumn('Actions', function ($model) { //return '<a href=article/delete/ ' . $model->id . ' class="btn btn-danger btn-flat" onclick="myFunction()">Delete</a> <a href=article/' . $model->id . '/edit class="btn btn-warning btn-flat">Edit</a> <a href=show/' . $model->id . ' class="btn btn-warning btn-flat">View</a>'; //return '<form action="article/delete/ ' . $model->id . '" method="post" onclick="alert()"><button type="sumbit" value="Delete"></button></form><a href=article/' . $model->id . '/edit class="btn btn-warning btn-flat">Edit</a> <a href=show/' . $model->id . ' class="btn btn-warning btn-flat">View</a>'; return '<span data-toggle="modal" data-target="#deletearticle' . $model->id . '"><a href="#" ><button class="btn btn-danger btn-xs"></a> ' . \Lang::get('lang.delete') . ' </button></span> <a href="' . route('user.edit', $model->id) . '" class="btn btn-warning btn-xs">' . \Lang::get('lang.edit') . '</a> <a href="' . route('user.show', $model->id) . '" class="btn btn-primary btn-xs">' . \Lang::get('lang.view') . '</a> <div class="modal fade" id="deletearticle' . $model->id . '"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title">Are You Sure ?</h4> </div> <div class="modal-body"> ' . $model->user_name . ' </div> <div class="modal-footer"> <button type="button" class="btn btn-default pull-left" data-dismiss="modal" id="dismis2">Close</button> <a href="' . route('user.delete', $model->id) . '"><button class="btn btn-danger">delete</button></a> </div> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div>'; })->make(); }
/** * getDatatable */ public function getDatatable() { $collection = Order::where('order_status', 'order_stockuped')->get(); return Datatable::collection($collection)->showColumns('date', 'no', 'customer', 'status', 'actions')->orderColumns('date', 'customer')->searchColumns('date', 'no', 'customer')->addColumn('date', function ($model) { return date('Y-m-d', strtotime($model->created_at)); })->addColumn('customer', function ($model) { return $model->customer->name; })->addColumn('status', function ($model) { return get_order_status($model->order_status); })->addColumn('actions', function ($model) { return $str = '<button data-id="' . $model->id . '" class="btn btn-info btn-stockorder">查看货品</button>'; })->make(); }
/** * admin.comments.index * */ public function getAdminIndex() { if (Sentry::hasAnyAccess(['comments_index'])) { if (Request::ajax()) { $result = DB::table('comments')->select(array('comments.id', 'comments.description as description', 'comments.created_at as created', 'users.email as email', 'users.first_name as first_name', 'users.last_name as last_name'))->join('profiles', 'comments.profile_id', '=', 'profiles.id')->join('users', 'profiles.user_id', '=', 'users.id')->where('comments.status', '=', 1); return Datatable::query($result)->searchColumns('email', 'first_name', 'last_name', 'description')->orderColumns('created', 'id')->showColumns('id', 'description', 'email', 'first_name', 'last_name')->addColumn('Operaciones', function ($model) { return "<a class='operation' href='" . URL::to('#Send') . "' id={$model->id} data-toggle='modal'>\n\t\t\t\t\t\t\t\t<span class='label label-success'><i class='fa fa-envelope-o'></i> Responder</span>\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t<a class='operation' href='" . URL::to('#Delete') . "' id={$model->id} data-toggle='modal'>\n\t\t\t\t\t\t\t\t<span class='label label-default'><i class='fa fa-trash'></i> Eliminar</span>\n\t\t\t\t\t\t\t</a>"; })->make(); } else { return View::make('comments.admin.index'); } } }
public function getDatatable($clientPublicId) { $query = DB::table('activities')->join('clients', 'clients.id', '=', 'activities.client_id')->where('clients.public_id', '=', $clientPublicId)->where('activities.account_id', '=', Auth::user()->account_id)->select('activities.id', 'activities.message', 'activities.created_at', 'activities.balance', 'activities.adjustment'); return Datatable::query($query)->addColumn('id', function ($model) { return Utils::timestampToDateTimeString(strtotime($model->created_at)); })->addColumn('message', function ($model) { return Utils::decodeActivity($model->message); })->addColumn('balance', function ($model) { return Utils::formatMoney($model->balance, 1); })->addColumn('adjustment', function ($model) { return $model->adjustment != 0 ? Utils::formatMoney($model->adjustment, 1) : ''; })->make(); }