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