File name : Userregister.php
<?php
namespace App\Http\Controllers\admin;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use DB;
use App\Registeruser;
use Session;
//use Validator;
class UserRegister extends Controller
{
public function notification(){
$notification = array(
'message' => 'Thanks! We shall get back to you soon.',
'alert-type' => 'success'
);
session()->set('notification',$notification);
return view('admin.userregister');
}
public function __construct()
{
//$this->middleware('auth');
/* if (session()->has('username')) {
return redirect('home');
}
else {
return redirect('/');
}
*/
/*
if (!$request->session()->exists('user')) {
// user value cannot be found in session
return redirect('/');
}*/
}
public function registrationform()
{
/*if (Session()->has('username')) {
//echo Session()->get('userkey');
return view('admin/userregister');
//return view('admin.userregister');
}
else {
return redirect('/');
}
*/
//return view('admin/userregister');
return view('admin.userregister');
}
public function register_user(Request $request)
{
/* ###################### Form Validation ################### */
/* $this->validate(request(),[
//put fields to be validated here
]);
*/
$this->validate($request,[
'name' => 'required',
'email' => 'required|email|unique:registerusers',
'password' => 'required|alphaNum|max:12|min:4',
//'password' => 'required|confirmed|alphaNum|max:12|min:4',
'mobile' => 'required|Numeric|digits:10',
// 'phone' => 'required|regex:/^([0-9\s\-\+\(\)]*)$/|min:10',
'address'=> 'required',
'gender'=> 'required',
'state'=> 'required',
'dob'=> 'required|date',
'thumbnail' => 'required|image|mimes:jpeg,png,jpg,gif',
//'dob'=> 'required|date|date_format:YYYY-mm-dd',
//'phone' => 'required|digits:10',
//'phone' => 'required|regex:/^([0-9\s\-\+\(\)]*)$/|min:10',
]);
/*
$request->validate([
'name' => 'required',
'phone' => 'required|regex:/^([0-9\s\-\+\(\)]*)$/|min:10',
'email' => 'required|email|unique:users'
]);
$input = $request->all();
$user = User::create($input);
return back()->with('success', 'User created successfully.');
*/
/*
$rules = array(
'email' => 'required|email',
'password' => 'required|alphaNum|min:3'
);
//$validator = Validator::make(Input::all(), $rules);
$validator = \Validator::make($request->all(), $rules);
// if the validator fails, redirect back to the form
if ($validator->fails()) {
return Redirect::back()
->withErrors($validator)->withInput();
/*if ($validator->fails()) {
return Redirect::to('login')
->withErrors($validator) // send back all errors to the login form
->withInput(Input::except('password')); // send back the input (not the password) so that we can repopulate the form
}
*/
/* ########################## End Form Validation #################### */
/* ################### Insert Record First method ################### */
//dd(request()->all());
/* $data_array = $request->all();
DB::table('registerusers')->insert($data_array);
//echo "Record inserted successfully.<br/>";
return redirect()->back()->with('message', 'Your Data is successfully Submitted!');
*/
/* ########## Insert Record second method ################ */
if ($request->input('submit') != null ){
if($request->input('editid') !=null ){
$token = $request->input('_token');
$name = $request->input('name');
$email = $request->get('email');
$password = $request->get('password');
$mobile = $request->input('mobile');
$address = $request->input('address');
$gender = $request->get('gender');
$state = $request->input('state');
$dob = $request->input('dob');
if($name !='' && $email != ''){
$data = array('name'=>$name,"email"=>$email);
// Update
Registeruser::updateData($editid, $data);
Session::flash('message','Update successfully.');
}
}
}
else
{
// Insert record
$token = $request->input('_token');
$name = $request->input('name');
$email = $request->get('email');
$password = $request->get('password');
$mobile = $request->input('mobile');
$address = $request->input('address');
$gender = $request->get('gender');
$state = $request->input('state');
$dob = $request->input('dob');
/* $hobbies = $request->merge(['hobbies' => implode(',', (array) $request->get('hobbies'))]);
laravel::create($request->all());
*/
$hobbies = implode(',',$request->input('hobbies'));
//$hobbies = implode(",", $request->get('hobbies'));
$image = $request->file('thumbnail');
$image_name = uniqid() . '_' . time(). '.' . $image->getClientOriginalExtension();
//$uploaded_path = public_path('gallery');
$uploaded_path = storage_path('app\public\images');
$image->move($uploaded_path,$image_name);
if($name !='' && $mobile !='' && $email != ''){
$data=array('name'=>$name,"email"=>$email,"password"=>$password,"mobile"=>$mobile,"address"=>$address,'gender'=>$gender,'state'=>$state,'dob'=>$dob,'hobbies'=>$hobbies,'profilepic'=>$image_name,'_token'=>$token);
$result = DB::table('registerusers')->insert($data);
//echo "Record inserted successfully.<br/>";
return redirect()->back()->with('message', 'Your Data is successfully Submitted!');
//DB::insert('insert into registerusers (name,email) values(?,?)',[$name,$email]);
/* ############### insert by using model class ###################
$result = Registeruser::insertData($data);
if($result){
Session::flash('message','Insert successfully.');
}else{
Session::flash('message','Username already exists.');
}
/* ################################## */
} // if close
} // else close
/* ##################################################### */
//return redirect()->action('UserRegister@fetchdata',['id'=>0]);
}
/* ################### Show User List ############# */
public function showuser()
{
//$data['data'] = DB::table('registerusers')->get();
/*$data['data'] = DB::table('registerusers')->orderBy('id', 'desc')->get();
if(count($data) > 0)
{
return view('admin/registerusershow',$data);
//return view('admin.registerusershow',$data);
}
else {
return view('admin/registerusershow');
//return view('admin.registerusershow');
}
*/
// ###############################################
//$data = Registeruser::where('id', 1)->get();
//$data = Registeruser::where('id', 5)->get();
$data = Registeruser::get();
return view('admin/registerusershow',compact('data'));
// ###############################################
}
public function showuser_info(Request $request)
{
$uid = $request->post('uid');
//return Response::json($uid);
$users = Registeruser::find($uid);
return response()->json(array($users));
exit;
}
/* ############################################# */
public function fetchdata($id=0){
// Fetch all records
$userData['data'] = Registeruser::getuserData();
$userData['edit'] = $id;
// Fetch edit record
if($id>0){
$userData['editData'] = Registeruser::getuserData($id);
}
// Pass to view
return view('index')->with("userData",$userData);
}
/* ############################################# */
public function deleteUser($id=0){
if($id != 0){
// Delete
Registeruser::deleteData($id);
Session::flash('message','Delete successfully.');
}
//return redirect()->action('UserRegister@fetchdata',['id'=>0]);
return redirect('/getregisteruser');
}
public function deletedata($id)
{
DB::table('registerusers')->where('id',$id)->delete();
return redirect('/getregisteruser');
// DB::delete('delete from registerusers where id = ?',[$id]);
}
public function ajaxdeletedata($id)
{
$Users = Registeruser::find($id); // Can chain this line with the next one
$Users->delete($id);
exit;
// Employee_detail::find($id)->delete();
// DB::table('employee_details')->where('id',$id)->delete();
/*
$item = employee_details::findOrFail($id);
$item->delete();
return redirect()->route('admin.products')->with('flashSuccess', 'deleted');
*/
// return response()->json(['success' => 'Record has been deleted successfully!']);
}
public function show($id)
{
$users = DB::select('select * from registerusers where id = ?',[$id]);
return view('admin/user_update',['users'=>$users]);
}
public function userdataupdate(Request $request)
{
if($request->input('submit') != null)
{
$id = $request->input('id');
$name = $request->input('name');
$email = $request->input('email');
$password = $request->input('password');
$mobile = $request->input('mobile');
$address = $request->input('address');
$gender = $request->input('gender');
$state = $request->input('state');
$dob = $request->input('dob');
$data=array('name'=>$name,"email"=>$email,'password'=>$password,"mobile"=>$mobile,"address"=>$address,'gender'=>$gender,'state'=>$state,'dob'=>$dob);
//DB::table('employee_details')->update($data);
//DB::table('employee_details')->whereIn('id', $id)->update($request->all());
//DB::update('update registerusers set name=?,email=?,password=?,mobile=?,address=?,gender=?,state=?,dob=? where id = ?',[$name,$email,$password,$mobile,$address,$gender,$state,$dob,$id]);
/* ########### Update another method ################ */
Registeruser::updateData($id, $data);
Session::flash('message','Update successfully.');
/* ########### End Update another method ################ */
//return redirect()->back()->with('message', 'Your Data is successfully Submitted!');
//return view('employeeshow');
return redirect('/getregisteruser');
}
}
public function approveuser($id)
{
DB::table('registerusers')->where("registerusers.id", '=', $id)
->update(['registerusers.status'=> '1']);
// DB::update('update registerusers set status = ? where id = ?',['1',$id]);
// DB::table('registerusers')->where(['id' => $id])->update(['status' => '1']);
Session::flash('message','Approve User successfully.');
//return redirect()->back()->with('message', 'Your Data is successfully Submitted!');
return redirect('/getregisteruser');
}
public function notapproveuser($id)
{
DB::table('registerusers')->where("registerusers.id", '=', $id)
->update(['registerusers.status'=> '0']);
// DB::update('update registerusers set status = ? where id = ?',['0',$id]);
// DB::table('registerusers')->where(['id' => $id])->update(['status' => '0']);
Session::flash('message','Not Approve User successfully.');
//return redirect()->back()->with('message', 'Your Data is successfully Submitted!');
return redirect('/getregisteruser');
}
} // class close