Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
Api	[ DIR ]	drwxrwxrwx	2022-04-21 13:43
Auth	[ DIR ]	drwxrwxrwx	2022-04-21 13:43
ripcord	[ DIR ]	drwxrwxrwx	2022-04-21 13:43
AddressController.php	4.36 KB	-rwxrwxrwx	2022-04-21 13:43
BuildingFloorsController.php	1.9 KB	-rwxrwxrwx	2022-04-21 13:43
BuildingTypesController.php	1.88 KB	-rwxrwxrwx	2022-04-21 13:43
BuildingsController.php	4.48 KB	-rwxrwxrwx	2022-04-21 13:43
CalendarController.php	467 B	-rwxrwxrwx	2022-04-21 13:43
CarHistoryController.php	3.01 KB	-rwxrwxrwx	2022-04-21 13:43
CarsController.php	2.78 KB	-rwxrwxrwx	2022-04-21 13:43
CheckInController.php	1.74 KB	-rwxrwxrwx	2022-04-21 13:43
Controller.php	361 B	-rwxrwxrwx	2022-04-21 13:43
CustomersController.php	4.75 KB	-rwxrwxrwx	2022-04-21 13:43
DevisController.php	4.99 KB	-rwxrwxrwx	2022-04-21 13:43
DevisLinesController.php	2 KB	-rwxrwxrwx	2022-04-21 13:43
DocumentsController.php	2.14 KB	-rwxrwxrwx	2022-04-21 13:43
HomeController.php	2.54 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionAddressesController.php	2.07 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionBuildingsController.php	2.07 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionContactsController.php	2.04 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionStatusController.php	2 KB	-rwxrwxrwx	2022-04-21 13:43
InterventionsController.php	15.03 KB	-rwxrwxrwx	2022-04-21 13:43
OddoController.php	6.5 KB	-rwxrwxrwx	2022-06-02 16:29
PassesController.php	1.72 KB	-rwxrwxrwx	2022-04-21 13:43
ProfileController.php	1.1 KB	-rwxrwxrwx	2022-04-21 13:43
RulesController.php	1.69 KB	-rwxrwxrwx	2022-04-21 13:43
StatusController.php	1.72 KB	-rwxrwxrwx	2022-04-21 13:43
TeamHistoryController.php	3.09 KB	-rwxrwxrwx	2022-04-21 13:43
TeamLogsController.php	1.76 KB	-rwxrwxrwx	2022-04-21 13:43
TeamMembersController.php	1.83 KB	-rwxrwxrwx	2022-04-21 13:43
TeamsController.php	6.69 KB	-rwxrwxrwx	2022-04-21 13:43
UserController.php	4.55 KB	-rwxrwxrwx	2022-04-21 13:43

Rename

<?php

namespace App\Http\Controllers;

use App\Models\Clients;
use App\Models\Address;
use App\Models\BuildingFloors;
use App\Models\Buildings;
use App\Http\Requests\StoreClientsRequest;
use App\Http\Requests\UpdateClientsRequest;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;

class CustomersController extends Controller
{
  /**
   * Display a listing of the resource.
   *
   * @return \Illuminate\Http\Response
   */
  public function index(Request $request)
  {

if ((($request->ref) == 1) && ((($request->customer) != 1) && (!empty($request->customer)))) {
      //ref:0 - client:detected';
      $customers = Clients::where('client_name', 'like', '%' . $request->customer . '%')->paginate(25);
      
      return view('customers/index', ['customers' => $customers]);
    }
    if ((($request->customer) == 1) && ((($request->ref) != 1) && (!empty($request->ref)))) {
      //ref:detected - client:0';
      $customers = Clients::where('ODDO_ref', 'like', '%' . $request->ref . '%')->paginate(25);
      return view('customers/index', ['customers' => $customers]);
    }
    if (((($request->customer) != 1) && (!empty($request->customer))) && ((($request->ref) != 1) && (!empty($request->ref)))) {
      //ref:detected - client:detected';
      $customers = Clients::where('client_name', 'like', '%' . $request->customer . '%')->where('ODDO_ref', 'like', '%' . $request->ref . '%')->paginate(25);
      return view('customers/index', ['customers' => $customers]);
    }

if (((($request->customer) == 1) || empty($request->customer)) && ((($request->ref) == 1) || empty($request->ref)) && ((($request->customer) == 1) || empty($request->customer))) {
      //ref:0 - client:0';
      $customers = Clients::paginate(25);
      return view('customers/index', ['customers' => $customers]);
    }
  }

/**
   * Show the form for creating a new resource.
   *
   * @return \Illuminate\Http\Response
   */
  public function create()
  {
    //
  }

/**
   * Store a newly created resource in storage.
   *
   * @param \App\Http\Requests\StoreCustomersRequest $request
   * @return \Illuminate\Http\Response
   */
  public function store(StoreCustomersRequest $request)
  {
    //
  }

/**
   * Display the specified resource.
   *
   * @param \App\Models\Clients $customers
   * @return \Illuminate\Http\Response
   */
  public function show(Request $request)
  {

$customers = DB::table("clients")
      ->where('ODDO_ref', '=', $request->ref)
      ->get();

$user = DB::table("users")
      ->join('clients', 'clients.user_id', '=', 'users.id')
      ->where('clients.ODDO_ref', '=', $request->ref)
      ->get();

$addresses = [];

foreach ($customers as $customer){
      $address = Address::where('id', $customer->address_id)->first();
      $address["building_name"] = Buildings::where('address_id', $address->id)->get();
      if ($address["building_name"]) {
        foreach ($address["building_name"] as $building){
          $building["floors"] = BuildingFloors::where('building_id', $building->id)->get();
        }
      }
      array_push($addresses, $address);
    }
    
    return view('customers/show', ['customer' => $customers, 'user' => $user, 'addresses' => $addresses]);
  }

/**
   * Show the form for editing the specified resource.
   *
   * @param \App\Models\Clients $clients
   * @return \Illuminate\Http\Response
   */
  public function edit(Request $request, Clients $clients)
  {
    if ($request->password && $request->email && $request->ref) {
      if ($request->password !== "Password") {
        $passwordHash = Hash::make($request->password);
        $update = DB::table('users')
            ->join('clients', 'clients.user_id', '=', 'users.id')
            ->where('clients.ODDO_ref', '=', $request->ref)
            ->update(['email' => $request->email, 'password' => $passwordHash]);
        return redirect("/customers/" . $request->ref);
      }else{
        $update = DB::table('users')
          ->join('clients', 'clients.user_id', '=', 'users.id')
          ->where('clients.ODDO_ref', '=', $request->ref)
          ->update(['email' => $request->email]);
          return redirect("/customers/" . $request->ref);
      }
    }else{
      return redirect("/customers/" . $request->ref . "?message=error");
    }
  }

/**
   * Update the specified resource in storage.
   *
   * @param \App\Http\Requests\UpdateClientsRequest $request
   * @param \App\Models\Clients $clients
   * @return \Illuminate\Http\Response
   */

public function update(UpdateClientsRequest $request, Clients $clients)
  {
    //
  }

/**
   * Remove the specified resource from storage.
   *
   * @param \App\Models\Customers $customers
   * @return \Illuminate\Http\Response
   */
  public function destroy(Customers $customers)
  {
    //
  }
}