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(); }
/** * 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(); }
/** * 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 getDatatable() { $query = User::select('first_name', 'last_login', 'id')->get(); return Datatable::collection($query)->addColumn('last_login', function ($model) { return date('M j, Y h:i A', strtotime($model->last_login)); })->addColumn('id', function ($model) { return '<a href="/users/' . $model->id . '">view</a>'; })->searchColumns('name', 'last_login')->orderColumns('name', 'last_login')->make(); }
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 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(); } }
/** * @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(); }
/** * 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'); }
/** * 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(); }
public function getBreedsDataTable() { $query = Breed::select('name', 'species', 'description_url', 'id')->get(); return Datatable::collection($query)->addColumn('name', function ($model) { return $model->name; })->addColumn('species', function ($model) { return $model->species; })->addColumn('description_url', function ($model) { return '<a href="' . $model->description_url . '">See Breed Description</a>'; })->addColumn('id', function ($model) { return '<a href="/breed/' . $model->id . '">view</a>'; })->searchColumns('name', 'species')->orderColumns('name', 'species')->make(); }
/** * getDatatable */ public function getDatatable() { $collection = Order::all(); return Datatable::collection($collection)->showColumns('date', 'no', 'customer', 'status', 'item_fee', 'caution_money', 'point_fee', 'credit_fee', 'pay_fee', 'amount_fee', 'remain_fee')->orderColumns('date', 'customer', 'status')->searchColumns('date', 'no', 'customer', 'status')->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('remain_fee', function ($model) { return $model->item_fee - $model->amount_fee - $model->point_fee - $model->credit_fee; })->addColumn('actions', function ($model) { return $str = '<button data-id="' . $model->id . '" class="btn btn-info btn-order">查看订单</button>'; })->make(); }
/** * This function is used to display the list of users using chumper datatables * @return datatable */ public function user_list() { // displaying list of users with chumper datatables return \Datatable::collection(User::where('role', '!=', 'admin')->where('role', '!=', 'agent')->get())->searchColumns('user_name')->orderColumns('user_name', 'email')->addColumn('user_name', function ($model) { if (strlen($model->user_name) > 20) { $username = substr($model->user_name, 0, 30); $username = substr($username, 0, strrpos($username, ' ')) . ' ...'; } else { $username = $model->user_name; } return $username; })->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('ban', function ($model) { $status = $model->ban; if ($status == 1) { $stat = '<button class="btn btn-danger btn-xs">Banned</button>'; } else { $stat = '<button class="btn btn-success btn-xs">Active</button>'; } return $stat; })->addColumn('lastlogin', function ($model) { $t = $model->updated_at; return TicketController::usertimezone($t); })->addColumn('Actions', function ($model) { return '<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>'; })->make(); }
public function index() { $data = Author::all(['id', 'name']); if (Datatable::shouldHandle()) { return Datatable::collection($data)->showColumns('id', 'name')->addColumn('1', function ($model) { $html = '<a href="' . route('admin.authors.edit', $model->id) . '" class="btn btnn"> <i class="mdi-editor-mode-edit"></i> </a>'; return $html; })->addColumn('2', function ($model) { $html = Form::open(['route' => ['admin.authors.destroy', $model->id], 'method' => 'delete']); $html .= '<button class="btn btnn" type="submit"> <i class="mdi-action-delete"></i> </button>'; $html .= Form::close(); return $html; })->searchColumns('name')->orderColumns('name')->make(); } return View::make('authors.index')->withTitle('Penulis'); }
/** * getDatatable */ public function getDatatable() { $collection = Employee::all(); return Datatable::collection($collection)->showColumns('date', 'name', 'mobile', 'actived', 'department')->orderColumns('date', 'name', 'actived')->searchColumns('date', 'name', 'mobile')->addColumn('date', function ($model) { return date('Y-m-d', strtotime($model->created_at)); })->addColumn('department', function ($model) { return $model->department->name; })->addColumn('actived', function ($model) { if ($model->actived == 0) { return '<span class="label label-danger">禁用</span>'; } else { return '<span class="label label-success">激活</span>'; } })->addColumn('actions', function ($model) { return $str = '<button data-id="' . $model->id . '" class="btn btn-info btn-employee">查看</button>'; })->make(); }
public function index() { if (Datatable::shouldHandle()) { return Datatable::collection(Book::with('author')->orderBy('id', 'desc')->get())->showColumns('id', 'title', 'amount')->addColumn('author', function ($model) { return $model->author->name; })->addColumn('1', function ($model) { $html = '<a href="' . route('admin.books.edit', $model->id) . '" class="btn btnn"> <i class="mdi-editor-mode-edit"></i> </a>'; return $html; })->addColumn('2', function ($model) { $html = Form::open(['route' => ['admin.books.destroy', $model->id], 'method' => 'delete']); $html .= '<button class="btn btnn" type="submit"> <i class="mdi-action-delete"></i> </button>'; $html .= Form::close(); return $html; })->searchColumns('title', 'amount', 'author')->orderColumns('title', 'amount', 'author')->make(); } return View::make('books.index')->withTitle('Buku'); }
public function getDatatable() { $collection = Customer::all(); return Datatable::collection($collection)->showColumns('date', 'name', 'mobile', 'qq', 'mail', 'street', 'address', 'type')->searchColumns('date', 'name', 'mobile', 'qq', 'mail', 'street', 'address', 'type')->orderColumns('date', 'name', 'mobile', 'qq', 'mail', 'street', 'address', 'type')->addColumn('date', function ($model) { return date('Y-m-d', strtotime($model->created_at)); })->addColumn('type', function ($model) { if ($model->type == 0) { $str = '<span class="label-warning label">客服注册</span>'; } else { $str = '<span class="label-success label">网络注册</span>'; } return $str; })->addColumn('actions', function ($model) { return $str = '<a href="' . URL::route('admin.suppliers.edit', $model->id) . '" class="btn btn-info btn-sm pull-left">编辑</a> ' . Form::open(array('route' => array('admin.suppliers.destroy', $model->id), 'method' => 'delete', 'data-confirm' => '确定操作?')) . ' <button type="submit" class="btn btn-danger btn-sm pull-right">删除</button>' . Form::close(); })->make(); }
public function getDatatable() { $collection = Item::all(); return Datatable::collection($collection)->showColumns('code', 'price_market', 'stock', 'image', 'category')->searchColumns('code', 'price_market', 'stock', 'category')->orderColumns('code', 'price_market', 'stock', 'category')->addColumn('category', function ($model) { if (isset($model->category->name)) { return $model->category->name; } return "无分类。。。"; })->addColumn('image', function ($model) { if ($model->image) { return HTML::image($model->image, $model->code, array('width' => '80', 'height' => '80')); } return "无图片。。。"; })->addColumn('actions', function ($model) { return $str = '<a href="' . URL::route('admin.items.edit', $model->id) . '" class="btn btn-info btn-sm pull-left" role="button">编辑</a> ' . Form::open(array('route' => array('admin.items.destroy', $model->id), 'method' => 'delete', 'data-confirm' => '确定操作?')) . ' <button type="submit" class="btn btn-danger btn-sm">删除</button>' . Form::close(); })->make(); }
/** * This function is used to display the list of Organizations * @return datatable */ public function org_list() { // chumper datable package call to display Advance datatable return \Datatable::collection(Organization::all())->searchColumns('name')->orderColumns('name', 'website')->addColumn('name', function ($model) { // return $model->name; if (strlen($model->name) > 20) { $orgname = substr($model->name, 0, 25); $orgname = substr($orgname, 0, strrpos($orgname, ' ')) . ' ...'; } else { $orgname = $model->name; } return $orgname; })->addColumn('website', function ($model) { $website = $model->website; return $website; })->addColumn('phone', function ($model) { $phone = $model->phone; return $phone; })->addColumn('Actions', function ($model) { // displaying action buttons // modal popup to delete data 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 function get_unassigned() { if (Auth::user()->role == "admin") { // $tickets = Tickets::where('status', '=', 1)->where('assigned_to', '=', Auth::user()->id)->get(); $tickets = Tickets::where('assigned_to', '=', null)->where('status', '1')->get(); } else { $dept = Department::where('id', '=', Auth::user()->primary_dpt)->first(); $tickets = Tickets::where('assigned_to', '=', null)->where('dept_id', '=', $dept->id)->get(); // $dept = Department::where('name','=',Auth::user()->primary_dpt)->first(); // $tickets = Tickets::where('status', '=', 1)->where('assigned_to', '=', Auth::user()->id)->get(); } return \Datatable::collection(new Collection($tickets))->addColumn('id', function ($ticket) { return "<input type='checkbox' name='select_all[]' class='icheckbox_flat-blue' value='" . $ticket->id . "'></input>"; })->addColumn('subject', function ($ticket) { $subject = DB::table('ticket_thread')->select('title')->where('ticket_id', "=", $ticket->id)->first(); $string = $subject->title; if (strlen($string) > 20) { $stringCut = substr($string, 0, 30); $string = substr($stringCut, 0, strrpos($stringCut, ' ')) . ' ...'; } //collabrations $collaborators = DB::table('ticket_collaborator')->where('ticket_id', '=', $ticket->id)->get(); $collab = count($collaborators); if ($collab > 0) { $collabString = ' <i class="fa fa-users"></i>'; } else { $collabString = null; } $threads = Ticket_Thread::where('ticket_id', '=', $ticket->id)->first(); //Ticket_Thread::where('ticket_id', '=', $ticket->id)->get(); $count = count($threads); $attachment = Ticket_attachments::where('thread_id', '=', $threads->id)->get(); $attachCount = count($attachment); if ($attachCount > 0) { $attachString = ' <i class="fa fa-paperclip"></i>'; } else { $attachString = ""; } //return $threads->id; return "<a href='" . route('ticket.thread', [$ticket->id]) . "' title='" . $subject->title . "'>" . $string . " <span style='color:green'>(" . $count . ")<i class='fa fa-comment'></i></span></a>" . $collabString . $attachString; })->addColumn('ticket_number', function ($ticket) { return "<a href='" . route('ticket.thread', [$ticket->id]) . "' title='" . $ticket->ticket_number . "'>#" . $ticket->ticket_number . "</a>"; })->addColumn('priority', function ($ticket) { $priority = DB::table('ticket_priority')->select('priority', 'priority_color')->where('priority_id', "=", $ticket->priority_id)->first(); return '<span class="btn btn-' . $priority->priority_color . ' btn-xs">' . $priority->priority . '</span>'; //return "loda"; })->addColumn('from', function ($ticket) { $from = DB::table('users')->select('user_name')->where('id', "=", $ticket->user_id)->first(); return "<span style='color:#508983'>" . $from->user_name . "</span>"; })->addColumn('Last Replier', function ($ticket) { $TicketData = Ticket_Thread::where('ticket_id', '=', $ticket->id)->where('is_internal', '!=', 1)->max('id'); $TicketDatarow = Ticket_Thread::where('id', '=', $TicketData)->first(); $LastResponse = User::where('id', '=', $TicketDatarow->user_id)->first(); if ($LastResponse->role == "user") { $rep = "#F39C12"; $username = $LastResponse->user_name; } else { $rep = "#000"; $username = $LastResponse->first_name . " " . $LastResponse->last_name; if ($LastResponse->first_name == null || $LastResponse->last_name == null) { $username = $LastResponse->user_name; } } return "<span style='color:" . $rep . "'>" . $username . "</span>"; })->addColumn('assigned_to', function ($ticket) { if ($ticket->assigned_to == null) { return "<span style='color:red'>Unassigned</span>"; } else { $assign = DB::table("users")->where('id', "=", $ticket->assigned_to)->first(); return "<span style='color:green'>" . $assign->first_name . " " . $assign->last_name . "</span>"; } })->addColumn('Last', function ($ticket) { $TicketData = Ticket_Thread::where('ticket_id', '=', $ticket->id)->max('id'); $TicketDatarow = Ticket_Thread::select('updated_at')->where('id', '=', $TicketData)->first(); return date('d F Y, H:i:s', strtotime($TicketDatarow->updated_at)); })->searchColumns('subject', 'from', 'assigned_to', 'ticket_number', 'priority')->orderColumns('subject', 'from', 'assigned_to', 'Last Replier', 'ticket_number', 'priority', 'Last')->make(); }
/** * function for send ajax request to view * * @return Response */ public function listing_ajax() { //$query = Building::all(); $query = Building::select('id', 'title', 'type', 'building_size', 'area_size', 'price', 'status_id', 'created_at')->with('status')->get(); //var_dump($query); return Datatable::collection($query)->addColumn('title', function ($model) { return $model->title; })->addColumn('type', function ($model) { return $model->type; })->addColumn('building_size', function ($model) { return $model->building_size; })->addColumn('area_size', function ($model) { return $model->area_size; })->addColumn('price', function ($model) { return $model->price; })->addColumn('status_id', function ($model) { return $model->status->name; })->addColumn('created_at', function ($model) { return $model->created_at->format('d-m-Y'); })->addColumn('show', function ($model) { return '<a href="' . action('AdminBuildingsController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>'; })->addColumn('edit', function ($model) { return '<a href="' . action('AdminBuildingsController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>'; })->addColumn('delete', function ($model) { return '<form action="' . action('AdminBuildingsController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>'; })->searchColumns('type', 'price', 'status_id')->orderColumns('id', 'type', 'created_at', 'building_size', 'status_id')->make(); }
public function dataTables() { $admins = Admin::all(); return Datatable::collection($admins)->showColumns("id", "account", "name", "created_at")->searchColumns('account')->orderColumns('created_at')->setAliasMapping()->make(); }
/** * function for send ajax request to view * * @return Response */ public function listingJson() { $query = UnitType::select('id', 'name', 'project_id', 'building_area', 'base_price', 'changed_by')->with('User')->with('Project')->get(); return Datatable::collection($query)->addColumn('name', function ($model) { return ucfirst($model->name); })->addColumn('project_id', function ($model) { // return $model->project_id; return ucfirst($model->project->name); })->addColumn('building_area', function ($model) { return $model->building_area; })->addColumn('base_price', function ($model) { return $model->base_price; })->addColumn('changed_by', function ($model) { return $model->user->name; })->addColumn('show', function ($model) { return '<a href="' . action('UnitTypesController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>'; })->addColumn('edit', function ($model) { return '<a href="' . action('UnitTypesController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>'; })->addColumn('delete', function ($model) { return '<form action="' . action('UnitTypesController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>'; })->searchColumns('block', 'additional_land_area', 'status_id')->orderColumns('id', 'block', 'unit_type_id', 'additional_land_area', 'additional_facility')->make(); }
/** * function for send ajax request to view * * @return Response */ public function listingJson() { $query = DpBookedUnit::select('id', 'booked_unit_id', 'is_valid', 'dp_type', 'dp_amount', 'changed_by', 'created_at')->with('User')->with('BookedUnit')->get(); return Datatable::collection($query)->addColumn('booked_unit_id', function ($model) { return $model->id; })->addColumn('is_valid', function ($model) { $is_valid = $model->is_valid == '1' ? 'Yes' : 'No'; return $is_valid; })->addColumn('dp_type', function ($model) { return $model->dp_type; })->addColumn('dp_amount', function ($model) { return $model->dp_amount; // return $model->project->name . $model->project_id; })->addColumn('created_at', function ($model) { return $model->created_at->format('d-m-Y'); })->addColumn('changed_by', function ($model) { return $model->user->name; })->addColumn('show', function ($model) { return '<a href="' . action('DpBookedUnitsController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>'; })->addColumn('edit', function ($model) { return '<a href="' . action('DpBookedUnitsController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>'; })->addColumn('delete', function ($model) { return '<form action="' . action('DpBookedUnitsController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>'; })->searchColumns('id', 'booked_unit_id', 'is_valid')->orderColumns('id', 'booked_unit_id', 'is_valid', 'dp_type', 'dp_amount', 'changed_by')->make(); }
public function getFoodAreaDataTables() { $levels = Category::where('parent_code', 'FOOD_AREA')->get(); return Datatable::collection($levels)->showColumns("id", "code", "parent_code", "name", "add1", "desc", "created_at")->searchColumns('name')->orderColumns('created_at')->setAliasMapping()->make(); }
public function getallusers() { return Datatable::collection(UserDetails::all(array('id', 'employee_id', 'firstname', 'surname', 'department', 'email')))->searchColumns(array('employee_id', 'firstname', 'surname'))->addColumn('employee_id', function ($model) { return $model->employee_id; })->addColumn('firstname', function ($model) { return ucfirst($model->surname) . ', ' . ucfirst($model->firstname); })->addColumn('department', function ($model) { return $model->department; })->addColumn('email', function ($model) { return $model->email; })->addColumn('action', function ($model) { return "<a href='e_user/" . $model->employee_id . "'class='btn btn-sm btn-success'><i class='fa fa-edit'></i></a>\n\t\t\t\t\t<a href='u_leave/" . $model->employee_id . "'class='btn btn-sm btn-info'><i class='fa fa-refresh'></i></a>\n\t\t\t\t\t<a href='d_user/" . $model->employee_id . "'class='btn btn-sm btn-danger'><i class='fa fa-trash'></i></a>"; })->make(); }
/** *Provide language datatable to language page *@return type */ public function getLanguages() { $path = '../resources/lang'; $values = scandir($path); //Extracts names of directories present in lang directory $values = array_slice($values, 2); // skips array element $value[0] = '.' & $value[1] = '..' return \Datatable::collection(new Collection($values))->addColumn('language', function ($model) { return Config::get('languages.' . $model); })->addColumn('id', function ($model) { return $model; })->addColumn('status', function ($model) { if (Lang::getLocale() === $model) { return "<span style='color:green'>" . Lang::trans("lang.active") . "</span>"; } else { return "<span style='color:red'>" . Lang::trans("lang.inactive") . "</span>"; } })->addColumn('Action', function ($model) { if (Lang::getLocale() === $model) { return "<a href='change-language/" . $model . "'><input type='button' class='btn btn-info btn-xs btn-flat' disabled value='" . Lang::trans("lang.disable") . "'/></a> \n <a href='change-language/" . $model . "' class='btn btn-danger btn-xs btn-flat' disabled><i class='fa fa-trash' style='color:black;'> </i> " . Lang::trans("lang.delete") . "</a>"; } else { return "<a href='change-language/" . $model . "'><input type='button' class='btn btn-info btn-xs btn-flat' value='" . Lang::trans("lang.enable") . "'/></a> \n <a href='delete-language/" . $model . "' class='btn btn-danger btn-xs btn-flat'><i class='fa fa-trash' style='color:black;'> </i> " . Lang::trans("lang.delete") . "</a>"; } })->searchColumns('language', 'id')->make(); }
/** * Get specified data for datatable * ref : https://github.com/Chumper/Datatable * @return json */ public function getDatatable() { return Datatable::collection(Functionalscope::all())->showColumns('id', 'code', 'title')->searchColumns('code', 'title')->orderColumns('code', 'title')->addColumn('action', function ($model) { $html = '<a href=' . route('functionalscopes.edit', ['functionalscopes' => $model->id]) . ' class="m-l-sm"><i class="fa fa-edit fa-hover" data-toggle="tooltip" data-placement="top" title="Ubah"></i></a>'; $html .= Form::open(array('url' => "functionalscopes/{$model->id}", 'role' => 'form', 'method' => 'delete', 'class' => 'form-inline', 'style="display:inline;"')); $html .= Form::submit('Delete', array('class' => 'hidden')); $html .= '<a href="#" data-confirm="Anda yakin akan menghapus functional scope ' . $model->title . ' ?" class="m-l-sm js-delete-confirm"><i class="fa fa-times fa-hover" data-toggle="tooltip" data-placement="top" title="Hapus"></i></a>'; $html .= Form::close(); return $html; })->make(); }
/** * function for send ajax request to view * * @return Response */ public function listingJson() { $query = Customer::select('id', 'name', 'sex', 'no_ktp', 'no_npwp', 'changed_by')->with('User')->get(); return Datatable::collection($query)->addColumn('name', function ($model) { return ucfirst($model->name); })->addColumn('sex', function ($model) { $sex = $model->sex == '1' ? 'Male' : 'Female'; return $sex; })->addColumn('no_ktp', function ($model) { return $model->no_ktp; })->addColumn('no_npwp', function ($model) { return $model->no_npwp; })->addColumn('changed_by', function ($model) { return $model->user->name; })->addColumn('show', function ($model) { return '<a href="' . action('CustomersController@detail', $model->id) . '" class="btn btn-small btn-primary btn-constant"><i class="fa fa-eye fa-fw"></i></a>'; })->addColumn('edit', function ($model) { return '<a href="' . action('CustomersController@edit', $model->id) . '" class="btn btn-small btn-success btn-constant"><i class="fa fa-edit fa-fw"></i></a>'; })->addColumn('delete', function ($model) { return '<form action="' . action('CustomersController@delete', $model->id) . '" method="POST"><button type="submit" class="btn btn-small btn-danger btn-constant" onclick = "return confirm(\'Are you sure?\')"><i class="fa fa-times fa-fw"></i></button></form>'; })->searchColumns('name', 'no_ktp', 'no_npwp')->orderColumns('id', 'name', 'sex', 'no_ktp', 'no_npwp', 'changed_by')->make(); }