1#@!#!123s

: / home / tattooscyy / test / app / Http / Controllers /
Filename : UsersController.php
back
<?php

namespace App\Http\Controllers;

use App\Role;
use App\User;
use App\Orders;
use App\Contract;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Mail;
use Auth;

class UsersController extends Controller
{
    /**
     * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
     */
    public function index()
    {
        $users = User::all();

        return view('admin.users.index', compact('users'));
    }

    /**
     * Show a page of user creation
     * @return \Illuminate\View\View
     */
    public function create()
    {
        $roles = Role::pluck('title', 'id');

        return view('admin.users.create', compact('roles'));
    }

    /**
     * Insert new user into the system
     *
     * @param Request $request
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function store(Request $request)
    {
        $input = $request->all();
        $input['password'] = Hash::make($input['password']);
        $user = User::create($input);

        return redirect()->route('users.index')->withMessage(trans('quickadmin::admin.users-controller-successfully_created'));
    }

    /**
     * Show a user edit page
     *
     * @param $id
     *
     * @return \Illuminate\View\View
     */
    public function edit($id)
    {
        $user = User::findOrFail($id);
        $roles = Role::where('title', '!=', 'Administrator')->pluck('title', 'id');

        return view('admin.users.edit', compact('user', 'roles'));
    }

    /**
     * Update our user information
     *
     * @param Request $request
     * @param         $id
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function update(Request $request, $id)
    {
        $user = User::findOrFail($id);
        $input = $request->all();
        $input['password'] = Hash::make($input['password']);
        $user->update($input);

        return redirect()->route('users.index')->withMessage(trans('quickadmin::admin.users-controller-successfully_updated'));
    }

    /**
     * Destroy specific user
     *
     * @param $id
     *
     * @return \Illuminate\Http\RedirectResponse
     */
    public function destroy($id)
    {
        $user = User::findOrFail($id);
        User::destroy($id);

        return redirect()->route('users.index')->withMessage(trans('quickadmin::admin.users-controller-successfully_deleted'));
    }

    public function getMails()
    {
        $orders = Orders::where('putdate', 'LIKE', Carbon::yesterday()->format('d-m-Y') . '%')->where('status', 'payd20')->get();
        foreach ($orders as $one) {
            echo $one->user->email;
            echo '<br />';
        }

    }

    public function mailsToJSON()
    {
        $orders = Orders::where('putdate', 'LIKE', Carbon::yesterday()->format('d-m-Y') . '%')->where('status', 'payd20')->get();
        //$orders = Orders::orderBy('id','DESC')->limit(2)->get();
        $arr = [];
        $arr_sal = [];
        foreach ($orders as $one) {
            if (isset($one->user)) {
                $email = $one->user->email;
                $name = $one->user->name;
            } elseif (isset($one->clients)) {
                $email = $one->clients->email;
                $name = $one->clients->name;
            } else {
                $email = 'mikhalkevich@ya.ru';
                $name = 'Mikhalkevich';
            }
            $arr[$email] = $name;
            $arr_sal[$email] = [$one->saloon_id, $one->saloons->name, $one->saloons->address, $one->saloons->companies->name];
        }
        $big_arr = [$arr, $arr_sal];
        return response()->json($big_arr);
    }

    public function contractsToJSON()
    {
        $orders = Contract::where('created_at', 'LIKE', Carbon::yesterday()->format('Y-m-d') . '%')->get();
        //$orders = Orders::orderBy('id','DESC')->limit(2)->get();
        $arr = [];
        $arr_sal = [];
        foreach ($orders as $one) {
            $name = (isset($one->saloons->companies->name)) ? $one->saloons->name : '';
            $saloon_address = (isset($one->saloons->address)) ? $one->saloons->address : '';
            $email = $one->email;
            $client_name = $one->name; //company_name
            $arr[$email] = $name;
            $arr_sal[$email] = [$one->id, $one->phone, $one->saloon_id, $name, $saloon_address, $one->type, $client_name];
        }
        $big_arr = [$arr, $arr_sal];
        return response()->json($big_arr);
    }
    public function piersingToJson(){
        $orders = Orders::with(['user','saloons.companies'])->where('putdate', 'LIKE', Carbon::yesterday()->format('d-m-Y') . '%')->whereNull('size')->get();
        return response()->json($orders);
    }
    public function confirmationUserMail(){
        $user = Auth::user();
        Mail::to($user->email)->send(new \App\Mail\ConfirmationUser($user));
        return redirect('/home');
    }
}