with( [
'refer'
] )
->whereRaw( 'id <> refer_id' )
->when(!empty(\request()->input('month')), function($q) {
$date = Carbon::createFromFormat('d/m/Y', '01/'.\request()->input('month'));
$q->whereBetween('refer_date', [
$date->copy()->startOfMonth()->startOfDay(),
$date->copy()->endOfMonth()->endOfDay()
]);
})
->whereNotNull( 'refer_id' );
return Datatables::of( $items )
->addIndexColumn()
->editColumn( 'refer_name', function ( $item ) {
return $item->refer->name;
} )
->editColumn( 'refer_phone', function ( $item ) {
return $item->refer->phone;
} )
->editColumn( 'refer_status', function ( $item ) {
return $item->refer_status_text;
} )
->editColumn( 'refer_reason', function ( $item ) {
return $item->refer_reason_text;
} )
->editColumn( 'refer_date', function ( $item ) {
return optional( $item->refer_date )->format( 'd/m/Y H:i' );
} )
->make( true );
}
public function getStaffByAttribute() {
$items = User::query()
->where( 'type', User::ADMIN )
->where( function ( $q ) {
$q->orWhere( 'email', '<>', 'admin@itro.vn' );
$q->orWhereNull( 'email' );
} );
return Datatables::of( $items )
->addIndexColumn()
->editColumn( 'name', function ( $item ) {
return $item->name_text;
} )
->editColumn( 'image', function ( $item ) {
return '
';
} )
->addColumn( 'action', function ( $item ) {
return '';
} )->make( true );
}
public function deleteStaff( Request $request ) {
$id = $request->input( 'id' );
$user = User::find( $id );
if ( $user ) {
$user->delete();
}
return response( [
'status' => 1,
'message' => 'Thành công'
] );
}
public function editStaffPermission( $id, Request $request ) {
$user = User::find( $id );
return response( [
'status' => 1,
'data' => view( 'admin.user.permission', compact( 'user' ) )->render()
] );
}
public function updateStaffPermission( Request $request ) {
$id = $request->input( 'id' );
$permissions = $request->input( 'permissions' );
$user = User::find( $id );
$user->syncPermissions( $permissions );
return response( [
'status' => 1,
'message' => 'Thành công'
] );
}
public function updateStaff( Request $request ) {
$data = $request->all();
$password = $request->input( 'password' );
$user = User::find( $data['user_id'] );
if ( ! empty( $password ) ) {
$data['password'] = \Hash::make( $password );
}
$user->update( $data );
if ( $request->ajax() ) {
return response( [
'status' => 1,
'message' => 'Thành công'
] );
}
return redirect()->to( url( 'admin/login' ) )->with( 'success', 'Đăng ký thành công' );
}
public function editStaff( $id, Request $request ) {
$user = User::find( $id );
if ( ! $user ) {
return response( [
'status' => 0,
'message' => 'Dữ liệu không hợp lệ'
] );
}
return response( [
'status' => 1,
'data' => view( 'admin.user.edit_staff', compact( 'user' ) )->render()
] );
}
}