Gecko [ school.pilasatech.net ]

Name	Size	Permission	Date
Auth	[ DIR ]	drwxr-xr-x	2024-04-21 07:39
AboutController.php	6.3 KB	-rw-r--r--	2018-10-11 22:20
AdminController.php	547 B	-rw-r--r--	2017-08-23 13:44
AdminManageUserController.php	6.72 KB	-rw-r--r--	2017-08-28 22:04
AdminPostController.php	8.95 KB	-rw-r--r--	2017-09-03 04:35
AdminProfileController.php	3.63 KB	-rw-r--r--	2017-09-13 00:37
BlogController.php	2.06 KB	-rw-r--r--	2017-08-25 15:44
CategoryController.php	4.01 KB	-rw-r--r--	2017-08-25 15:38
CommentsController.php	3.56 KB	-rw-r--r--	2017-09-08 11:38
Controller.php	361 B	-rw-r--r--	2017-07-11 04:08
CustomerController.php	1.48 KB	-rw-r--r--	2017-08-10 01:29
GalleryController.php	4 KB	-rw-r--r--	2017-08-28 15:51
HomeController.php	640 B	-rw-r--r--	2017-08-25 15:31
HostingOrderController.php	3.26 KB	-rw-r--r--	2018-03-28 06:48
LogoController.php	3.5 KB	-rw-r--r--	2018-02-18 04:17
MessagesController.php	2.63 KB	-rw-r--r--	2017-09-18 01:33
PagesController.php	2.92 KB	-rw-r--r--	2018-10-05 00:09
PortfolioController.php	4.97 KB	-rw-r--r--	2017-08-28 17:43
PostController.php	6.48 KB	-rw-r--r--	2018-02-18 04:18
ProfileController.php	4.18 KB	-rw-r--r--	2017-08-27 07:16
ServiceController.php	5.69 KB	-rw-r--r--	2018-10-05 00:06
TagController.php	3.33 KB	-rw-r--r--	2017-08-25 18:01
TeamController.php	4.69 KB	-rw-r--r--	2017-08-28 17:45
VideoController.php	3.16 KB	-rw-r--r--	2017-09-08 23:38

Rename

<?php

namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
use App\Admin;
use Session;
use Hash;
use DB;
use App\Message;
// PdfReport Aliases
use PdfReport;
class AdminManageUserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function __construct(){

$this->middleware('auth:admin');
    }
    public function index()
    {
        $messages=Message::all();
        $admin=Admin::all();
        $users=User::orderBy('id','asc')->paginate('4');
        return view('Admin.manageusers.index')->withUsers($users)->withAdmin($admin)->withMessages($messages);
    }

/**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $messages=Message::all();
       $users=User::all();
       return view('Admin.manageusers.create')->withUsers($users)->withMessages($messages);
    }

/**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
       $this->validate($request,array(
            'name'=>'required|max:50',
            'email'=>'required|string|email|max:255|unique:users',
            'password'=>'required|string|min:6|max:50',
            'password2'=>'required|string|min:6|max:50'
        ));
    
       $dbusers=DB::table('users')->get();
       foreach ($dbusers as $dbuser) {
           $username=$dbuser->name;
           if ($request->name==$username) {
           Session::flash('danger','This name has already been taken.');
           return redirect()->route('manageuser.create');
       }
       }
       $users=new User;
       $users->name=$request->name;
       $users->email=$request->email;
       $users->password=$request->password;
       
       if ($users->password!=$request->password2) {
           Session::flash('danger','The password confirmation does not match.!');
           return redirect()->route('manageuser.create');
       }
       else{
        $users->password=Hash::make($request->password);
        $users->save();
        Session::flash('success','User created successfully!');
        return redirect()->route('manageuser.index');
       }
      
    }

/**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

/**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        $messages=Message::all();
        $user=User::find($id);
        return view('Admin.manageusers.edit')->withUser($user)->withMessages($messages);
    }

/**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
         $this->validate($request,array(
            'name'=>'required|string|max:255',
            'email' => 'required|string|email|max:255'
            ));
        $users=User::find($id);
        $user=User::where('id','!=',$id)->get();
        foreach($user as $u){
            if($u->email==$request->email){
                Session::flash('danger','This email has alredy been taken.');
                return redirect()->route('manageuser.edit',$id);
            }
        }
        $users->name=$request->name;
        $users->email=$request->email;
        $users->save();

Session::flash('success','User successfully updated!');
        //echo $users;
       return redirect()->route('manageuser.index');

}

/**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        $user=User::find($id);
        $user->delete();
        Session::flash('success','User deleted successfully!');
        return redirect()->route('manageuser.index');
    }
    public function generatereport(Request $request){
     // Retrieve any filters
    $fromDate = $request->input('from_date');
    $toDate = $request->input('to_date');
    $sortBy = $request->input('sort_by');   
    if ($sortBy!='name' && $sortBy!='email' && $sortBy!='id') {
        Session::flash('danger','The column name'." ".$sortBy." ".'doesn\'t exist.');
        return redirect()->route('manageuser.index');
    }
      // Report title
    $title = 'Registered User Report';
    // For displaying filters description on header
    $meta = [
        'Registered on' => $fromDate . ' To ' . $toDate,
        'Sort By' => $sortBy
    ];
    // Do some querying..
    $queryBuilder = User::select(['name', 'email', 'created_at'])
                        ->whereBetween('created_at', [$fromDate, $toDate])
                        ->orderBy($sortBy);

// Set Column to be displayed
    $columns = [
        'Name' => 'name',
        'Created At', // if no column_name specified, this will automatically seach for snake_case of column created_at (will be created_at) column from query result
        'Email Address' => 'email',
        'Status' => function($result) { // You can do if statement or any action do you want inside this closure
            return (strlen($result->email) > 10) ? 'Strong Email Address' : 'Weak Email Address';
        }
    ];

/*
        Generate Report with flexibility to manipulate column class even manipulate column value (using Carbon, etc).

- of()         : Init the title, meta (filters description to show), query, column (to be shown)
        - editColumn() : To Change column class or manipulate its data for displaying to report
        - editColumns(): Mass edit column
        - showTotal()  : Used to sum all value on specified column on the last table (except using groupBy method). 'point' is a type for displaying total with a thousand separator
        - groupBy()    : Show total of value on specific group. Used with showTotal() enabled.
        - limit()      : Limit record to be showed
        - make()       : Will producing DomPDF / SnappyPdf instance so you could do any other DomPDF / snappyPdf method such as stream() or download()
    */

return PdfReport::of($title, $meta, $queryBuilder, $columns)
                    ->editColumn('Created At', [
                        'displayAs' => function($result) {
                            return $result->created_at->format('d M Y');
                        }
                    ])->groupBy('Email Address')
                    ->stream(); // or download('filename here..') to download pdf
 }
}