示例#1
1
 public function listingBerita()
 {
     $berita = Berita::select('id', 'judul', 'deskripsi', 'created_at', 'slug');
     return Datatables::of($berita)->addColumn('operation', function ($index) {
         return "<button value='{$index->id}' onClick='ViewModal(this);' class='btn btn-social-icon btn-dropbox btn-sm' data-toggle='modal' data-target='#viewModal' title='View Data'><i class='fa fa-share-square-o'></i></button>" . " <button value='{$index->id}' onClick='EditModal(this);' class='btn btn-social-icon btn-linkedin btn-sm ' data-toggle='modal' title='Edit Data' data-target='#myModal'><i class='fa fa-edit'></i></button>" . " <button value='{$index->id}' onClick='HapusModal(this);' class='btn btn-social-icon btn-google btn-sm' data-toggle='modal' data-target='#dellModal' title='Hapus Data'><i class='fa fa-trash'></i></button>" . " <a href='berita/post/{$index->slug}' target='_blank'> <button value='{$index->id}' class='btn btn-social-icon btn-vk btn-sm' title='View Post'><i class='fa fa-link'></i></button></a> ";
     })->removeColumn('slug')->make();
 }
 /**
  * @param ManageUserRequest $request
  * @return mixed
  */
 public function __invoke(ManageUserRequest $request)
 {
     return Datatables::of($this->users->getForDataTable($request->get('status'), $request->get('trashed')))->editColumn('confirmed', function ($user) {
         return $user->confirmed_label;
     })->addColumn('roles', function ($user) {
         return $user->roles->count() ? implode("<br/>", $user->roles->pluck('name')->toArray()) : trans('labels.general.none');
     })->addColumn('actions', function ($user) {
         return $user->action_buttons;
     })->withTrashed()->make(true);
 }
 public function listingPengumuman()
 {
     //        $pengumuman = Pengumuman::all();
     //        return response()->json(
     //            $pengumuman->toArray()
     //        );
     $pengumuman = Pengumuman::select('id', 'judulPeng', 'created_at');
     return Datatables::of($pengumuman)->addColumn('operation', function ($index) {
         return "<button value='{$index->id}' onClick='EditModal(this);' class='btn btn-primary' data-toggle='modal' data-target='#myModal'>Edit</button>" . " <button value='{$index->id}' onClick='HapusModal(this);' class='btn btn-danger' data-toggle='modal' data-target='#dellModal'>Hapus</button>" . " <button value='{$index->id}' onClick='ViewModal(this);' class='btn btn-default' data-toggle='modal' data-target='#viewModal'>View</button>";
     })->make();
 }
 public function listingLowongan()
 {
     //        $lowongans = Lowongan::all();
     //        return response()->json(
     //            $lowongans->toArray()
     //        );
     $lowongan = Lowongan::select('id', 'judul', 'namaPt', 'deadline', 'slug');
     return Datatables::of($lowongan)->addColumn('operation', function ($index) {
         return "<button value='{$index->id}' onClick='ViewModal(this);' class='btn btn-social-icon btn-dropbox btn-sm' data-toggle='modal' data-target='#viewModal' title='View Data'><i class='fa fa-share-square-o'></i></button>" . " <button value='{$index->id}' onClick='EditModal(this);' class='btn btn-social-icon btn-linkedin btn-sm ' data-toggle='modal' title='Edit Data' data-target='#myModal'><i class='fa fa-edit'></i></button>" . " <button value='{$index->id}' onClick='HapusModal(this);' class='btn btn-social-icon btn-google btn-sm' data-toggle='modal' data-target='#dellModal' title='Hapus Data'><i class='fa fa-trash'></i></button>" . " <a href='lowongan/post/{$index->slug}' target='_blank'> <button value='{$index->id}' class='btn btn-social-icon btn-vk btn-sm' title='View Post'><i class='fa fa-link'></i></button></a> ";
     })->removeColumn('slug')->make();
 }
 /**
  * @param ManageRoleRequest $request
  * @return mixed
  */
 public function __invoke(ManageRoleRequest $request)
 {
     return Datatables::of($this->roles->getForDataTable())->addColumn('permissions', function ($role) {
         if ($role->all) {
             return '<span class="label label-success">' . trans('labels.general.all') . '</span>';
         }
         return $role->permissions->count() ? implode("<br/>", $role->permissions->pluck('display_name')->toArray()) : '<span class="label label-danger">' . trans('labels.general.none') . '</span>';
     })->addColumn('users', function ($role) {
         return $role->users->count();
     })->addColumn('actions', function ($role) {
         return $role->action_buttons;
     })->make(true);
 }
示例#6
0
    /**
     * @return mixed
     */
    public function data()
    {
        $categories = Categories::select('id', 'name', 'description', 'slug')->orderBy('id', 'desc');
        return Datatables::of($categories)->editColumn('name', '
				<a href="#"><b>{{$name}}</b></a>
				<div class="row-actions hide">
					<a href="{{{ URL::to(\'admin/categories/edit/\' . $id . \'/\') }}}">Edit</a>
					|
					<a class="delete-tag" href="{{ URL::to(\'admin/categories/delete/\' . $id .\'/\') }}"
						onclick=" return confirm(\'Are you want to delete\')">Delete</a>
					|
					<a href="#">View</a>
				</div>
			')->editColumn('id', '<input id="cb-select-all-1" type="checkbox" data="{{$id}}">')->make();
    }
示例#7
0
 /**
  * @param int $corporation_id
  *
  * @return mixed
  */
 public function getMarketData(int $corporation_id)
 {
     $orders = $this->getCorporationMarketOrders($corporation_id, false);
     $states = $this->getEveMarketOrderStates();
     return Datatables::of($orders)->addColumn('bs', function ($row) {
         return view('web::partials.marketbuysell', compact('row'))->render();
     })->addColumn('vol', function ($row) {
         return view('web::partials.marketvolume', compact('row'))->render();
     })->addColumn('state', function ($row) use($states) {
         return $states[$row->orderState];
     })->editColumn('price', function ($row) {
         return number($row->price);
     })->addColumn('total', function ($row) {
         return number($row->price * $row->volEntered);
     })->editColumn('typeName', function ($row) {
         return view('web::partials.markettype', compact('row'))->render();
     })->make(true);
 }
 /**
  * @param ManageUserRequest $request
  * @return mixed
  */
 public function get(ManageUserRequest $request)
 {
     return Datatables::of($this->users->getForDataTable($request->get('status'), $request->get('trashed')))->editColumn('confirmed', function ($user) {
         return $user->confirmed_label;
     })->addColumn('roles', function ($user) {
         $roles = [];
         if ($user->roles()->count() > 0) {
             foreach ($user->roles as $role) {
                 array_push($roles, $role->name);
             }
             return implode("<br/>", $roles);
         } else {
             return trans('labels.general.none');
         }
     })->addColumn('actions', function ($user) {
         return $user->action_buttons;
     })->make(true);
 }
 /**
  * @param ManageRoleRequest $request
  * @return mixed
  */
 public function get(ManageRoleRequest $request)
 {
     return Datatables::of($this->roles->getForDataTable())->addColumn('permissions', function ($role) {
         $permissions = [];
         if ($role->all) {
             return '<span class="label label-success">' . trans('labels.general.all') . '</span>';
         }
         if (count($role->permissions) > 0) {
             foreach ($role->permissions as $permission) {
                 array_push($permissions, $permission->display_name);
             }
             return implode("<br/>", $permissions);
         } else {
             return '<span class="label label-danger">' . trans('labels.general.none') . '</span>';
         }
     })->addColumn('users', function ($role) {
         return $role->users()->count();
     })->addColumn('actions', function ($role) {
         return $role->action_buttons;
     })->make(true);
 }
 public function getCharDataCkey($ckey, Request $request)
 {
     if ($request->user()->cannot('server_chars_show')) {
         abort('403', 'You do not have the required permission');
     }
     $chars = ServerCharacter::where('ckey', $ckey)->select(['id', 'name', 'ckey']);
     return Datatables::of($chars)->removeColumn('id')->editColumn('name', '<a href="{{route(\'server.chars.show.get\',[\'char\'=>$id])}}">{{$name}}</a>')->addColumn('action', '<p><a href="{{route(\'server.chars.show.get\',[\'char\'=>$id])}}" class="btn btn-success" role="button">Show</a>@can(\'ccia_record_edit\')<a href="{{route(\'server.chars.edit.cr.get\',[\'book\'=>$id])}}" class="btn btn-info" role="button">Edit CCIA Record</a>@endcan()</p>')->make();
 }
示例#11
0
 /**
  * 
  * @param Project $project
  * @param Request $request
  * @return string
  */
 public function getAllStatus($project, Request $request)
 {
     $parameters = ['project_id' => $project->id, 'org_id' => $project->org_id];
     $column = DB::select(DB::raw("SELECT GROUP_CONCAT(DISTINCT CONCAT('MAX(IF(results.section_id = ',results.section_id,', results.information, NULL)) AS s', results.section_id)) AS sections  FROM results WHERE (results.project_id = {$project->id});"));
     $query = ['pcode.id', 'pcode.pcode', 'pcode.state', 'pcode.district', 'pcode.township', 'pcode.village'];
     if (!empty($column[0]->sections)) {
         $query[] = DB::raw($column[0]->sections);
     }
     $project_id = $project->id;
     $org_id = $project->org_id;
     $status = PLocation::select($query)->where('pcode.org_id', $org_id)->with(['participants'])->leftjoin('results', function ($pcode) use($project_id) {
         $pcode->on('pcode.id', '=', 'results.resultable_id')->where('results.project_id', '=', $project_id);
     })->groupBy('pcode.id')->get();
     return Datatables::of($status)->filter(function ($instance) use($request) {
         if ($request->has('pcode')) {
             $code = $request->get('pcode');
             $instance->collection = $instance->collection->filter(function ($row) use($request) {
                 return Str::contains($row['pcode'], $request->get('pcode')) ? true : false;
             });
         }
         if ($request->has('region')) {
             $code = $request->get('region');
             $instance->collection = $instance->collection->filter(function ($row) use($request) {
                 return Str::contains($row['state'], $request->get('region')) ? true : false;
             });
         }
         if ($request->has('township')) {
             $code = $request->get('township');
             $instance->collection = $instance->collection->filter(function ($row) use($request) {
                 return Str::contains($row['township'], $request->get('township')) ? true : false;
             });
         }
         if ($request->has('station')) {
             $code = $request->get('station');
             $instance->collection = $instance->collection->filter(function ($row) use($request) {
                 return Str::contains($row['village'], $request->get('station')) ? true : false;
             });
         }
         if ($request->has('phone')) {
             $code = $request->get('phone');
             $instance->collection = $instance->collection->filter(function ($row) use($request) {
                 //dd($row->toArray());
                 return Str::contains($row['participants'], $request->get('phone')) ? true : false;
             });
         }
         if (!is_null($request->get('section')) && $request->get('section') >= 0) {
             $section = "s" . $request->get('section');
             // array key will be s0,s1,s2 etc..
             $status = $request->get('status');
             if ($status == 'missing') {
                 $instance->collection = $instance->collection->filter(function ($row) use($request, $section) {
                     return Str::is($row[$section], null) ? true : false;
                 });
             } else {
                 $instance->collection = $instance->collection->filter(function ($row) use($request, $section, $status) {
                     return Str::is($row[$section], $status) ? true : false;
                 });
             }
         }
     })->editColumn('pcode', function ($modal) use($project) {
         //if($modal->results){
         return $modal->pcode . "<a href='" . route('data.project.results.edit', [$project->id, $modal->id]) . "' title='Edit'> <i class='fa fa-edit'></i></a>";
         //}
     })->editColumn('state', function ($modal) use($project) {
         $state = !is_null($modal->state) ? $modal->state : '';
         return _t($state);
     })->editColumn('township', function ($modal) use($project) {
         $township = !is_null($modal->township) ? $modal->township : '';
         return _t($township);
     })->editColumn('village', function ($modal) use($project) {
         $village = !is_null($modal->village) ? $modal->village : '';
         return _t($village);
     })->make(true);
 }
 public function getDataAll(Request $request)
 {
     if ($request->user()->cannot('ccia_action_show')) {
         abort('403', 'You do not have permission to edit CCIA Actions.');
     }
     $data = CCIAAction::select(['id', 'title', 'expires_at']);
     return Datatables::of($data)->editColumn('title', '<a href="{{ route(\'ccia.actions.show.get\', [\'id\' => $id]) }}">{{$title}}</a>')->addColumn('action', '<p><a href="{{ route(\'ccia.actions.show.get\', [\'id\' => $id]) }}" class="btn btn-success" role="button">Show</a>  @can(\'ccia_action_edit\')<a href="{{route(\'ccia.actions.edit.get\', [\'id\' => $id]) }}" class="btn btn-info" role="button">Edit</a><a href="{{route(\'ccia.actions.delete\', [\'id\' => $id]) }}" class="btn btn-danger" role="button">Delete</a>@endcan()</p>')->make();
 }
示例#13
0
 /**
  * @return mixed
  */
 public function getData()
 {
     $model = $this->crud['model'];
     $data = $model::all();
     return Datatables::of($data)->make(true);
 }