Gecko [ www.ctm-euromeuble.fr ]

Name	Size	Permission	Date
ripcord	[ DIR ]	drwxrwxrwx	2022-04-21 13:44
api.php	1.66 KB	-rwxrwxrwx	2022-04-21 13:44
channels.php	508 B	-rwxrwxrwx	2022-04-21 13:44
console.php	553 B	-rwxrwxrwx	2022-04-21 13:44
web.php	12.18 KB	-rwxrwxrwx	2022-04-21 13:44

Rename

<?php

use App\Http\Controllers\CalendarController;
use App\Http\Controllers\CustomersController;
use App\Http\Controllers\UserController;
use App\Http\Controllers\TeamsController;
use App\Http\Controllers\TeamHistoryController;
use App\Http\Controllers\CarsController;
use App\Http\Controllers\CarHistoryController;
use App\Http\Controllers\DevisController;
use App\Http\Controllers\DocumentsController;
use App\Http\Controllers\InterventionsController;
use App\Http\Controllers\AddressController;
use App\Models\User;
use App\Models\Rules;
use App\Models\Devis;
use App\Models\DevisLines;
use App\Models\Clients;
use App\Models\Address;
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
function replaceSpecialChar($str) {
    $ch0 = array( 
            "œ"=>"oe",
            "Œ"=>"OE",
            "æ"=>"ae",
            "à" => "a",
            "á" => "a",
            "â" => "a",
            "à" => "a",
            "ä" => "a",
            "å" => "a",
            "ç" => "c",
            "è" => "e",
            "é" => "e",
            "ê" => "e",
            "ë" => "e",
            "ī" => "i",
            "į" => "i",
            "í" => "i",
            "ì" => "i",
            "ï" => "i",
            "î" => "i",
            "ò" => "o",
            "ó" => "o",
            "ô" => "o",
            "õ" => "o",
            "ö" => "o",
            "ø" => "o",
            "ð" => "o",
            "ù" => "u",
            "ú" => "u",
            "û" => "u",
            "ü" => "u",
            "ý" => "y",
            "ÿ" => "y",
      		" " => "_"
            );
    $str = strtr($str,$ch0);
    return strtolower($str);
}

Route::get('/', function () {
    return view('auth.login');
});

Auth::routes();

Route::get('/home', [App\Http\Controllers\HomeController::class, 'index'])->name('home');

Route::group(['middleware' => 'auth'], function () {
	Route::get('table-list', function () {
		return view('pages.table_list');
	})->name('table');

Route::get('typography', function () {
		return view('pages.typography');
	})->name('typography');

Route::get('icons', function () {
		return view('pages.icons');
	})->name('icons');

Route::get('map', function () {
		return view('pages.map');
	})->name('map');

Route::get('notifications', function () {
		return view('pages.notifications');
	})->name('notifications');

Route::get('rtl-support', function () {
		return view('pages.language');
	})->name('language');

Route::get('upgrade', function () {
		return view('pages.upgrade');
	})->name('upgrade');

// calendar routes:
	Route::get('planning/fetch-interventions', [CalendarController::class, 'calendarEvents']);
	Route::get('planning', [CalendarController::class, 'index'])->name('planning');

// customer routes:
	Route::get('/customers', [CustomersController::class, "index"])->name("customers");
	Route::get('/customers/search', [CustomersController::class, "index"])->name('customersSearch404');
	Route::get('/customers/search/{ref}/{customer}', [CustomersController::class, "index"])->name('customersSearch');
	Route::get('/customers/{ref}', [CustomersController::class, "show"])->name("customersShow");
	Route::patch('/customers/update/{ref}', [CustomersController::class, 'edit'])->name("customerUpdate");
	Route::post('/customers/add/address/{id}', [AddressController::class, 'create'])->name("createAddress");
	Route::post('/customers/update/address/{client_id}/{address_id}', [AddressController::class, 'update'])->name("updateAddress");

// users routes
    Route::get('/users', [UserController::class, 'show'])->name('users');
	Route::post('/users/add', [UserController::class, 'add'])->name('add');
	Route::post('/users/update/{id}', [UserController::class, 'update'])->name('update');
	Route::get('/users/delete/{id}', [UserController::class, 'delete'])->name('delete');
 	Route::get('/users/actives', [UserController::class, 'showActives'])->name('activesUsers');

//teams routes
	Route::get('/teams', [TeamsController::class, 'index'])->name('teams');
	Route::get('/teams/{id}', [TeamsController::class, 'show'])->name('team');
	Route::post('/teams/{id}/history/member/add', [TeamHistoryController::class, 'create'])->name('addMemberHistory');
	Route::get('/teams/{team_id}/history/member/delete/{history_number}', [TeamHistoryController::class, 'delete'])->name('deleteMembersHistory');
	Route::get('/teams/{team_id}/history/member/delete/{history_number}/{member_id}', [TeamHistoryController::class, 'deleteMember'])->name('deleteMemberHistory');
	Route::post('/teams/{id}/history/car/add', [CarHistoryController::class, 'create'])->name('addCarHistory');
	Route::get('/teams/{team_id}/history/car/delete/{history_number}', [CarHistoryController::class, 'delete'])->name('deleteCarsHistory');
	Route::get('/teams/{team_id}/history/car/delete/{history_number}/{car_id}', [CarHistoryController::class, 'deleteCar'])->name('deleteCarHistory');

Route::post('/teams/add', [TeamsController::class, 'store'])->name('store');
	Route::post('/teams/update/{id}', [TeamsController::class, 'update'])->name('update');
	Route::get('/teams/delete/{id}', [TeamsController::class, 'delete'])->name('delete');
  	Route::get('/teams/actives', [TeamsController::class, 'showActives'])->name('activesTeams');

Route::post('/member/add', [UserController::class, 'addMember'])->name('addMember');
	Route::post('/member/update/{id}', [UserController::class, 'updateMember'])->name('updateMember');
	Route::get('/member/delete/{id}', [UserController::class, 'deleteMember'])->name('deleteMember');

Route::post('/car/add', [CarsController::class, 'store'])->name('addCar');
	Route::post('/car/update/{id}', [CarsController::class, 'update'])->name('updateCar');
	Route::get('/car/delete/{id}', [CarsController::class, 'delete'])->name('deleteCar');

//devis route
	Route::get('/devis', [DevisController::class, 'show'])->name('devis');
	Route::post('/devis/create_intervention/{ref}', [DevisController::class, 'store'])->name('store_intervention_from_devis');
	Route::get('/devis/search/{ref}/{customer}/{validity_date}', [DevisController::class, "index"])->name('devisSearch');

//devis lines route
	Route::get('devis/{id}', [App\Http\Controllers\DevisLinesController::class, 'show'])->name('devis-details');

// Route::get('/oddo/import-data', [App\Http\Controllers\OddoController::class, 'import'])->name('import-devis');

//documents routes
	Route::get('documents', [DocumentsController::class, 'index'])->name('documents');
    Route::get('documents/generate-doc/{id}', [DocumentsController::class, 'generateDoc'])->name('generate-doc');

Route::get('/oddo/import-data', function()
	{

set_time_limit(3600);

$url = "https://nettyclean-services4.odoo.com";
		$db = "nettyclean-services4";
		$username = "a.murati@nettyclean-services.fr";
		$password = "Babette92";

require_once('ripcord/ripcord.php');

$common = ripcord::client("$url/xmlrpc/2/common");
		$common->version();
		$uid = $common->authenticate($db, $username, $password, array());

$models = ripcord::client("$url/xmlrpc/2/object");

$devis_id_from_odoo = $models->execute_kw(
			$db,
			$uid,
			$password,
			'sale.order',
			'search',
			array(array()),
		);

$devis_id_from_db = DB::table('devis')->pluck('ODDO_ref')->toarray();

$devis_id_to_add_on_db = [];

//Check if devis already exists on db
		for ($i = 0; $i < count($devis_id_from_odoo); $i++) {
			if (!in_array($devis_id_from_odoo[$i], $devis_id_from_db)) {
				$devis_id_to_add_on_db[] = $devis_id_from_odoo[$i];
			};
		}
		$count = 0;
		for ($i = 0; $i < count($devis_id_to_add_on_db); $i += 10)
		{
			$sliced_devis_id_to_add_on_db = array_slice($devis_id_to_add_on_db, $i, 10);

$devis_list = $models->execute_kw(
				$db,
				$uid,
				$password,
				'sale.order',
				'read',
				array($sliced_devis_id_to_add_on_db),
				array('fields'=>array(
					'name',
					'validity_date',
					'partner_id',
					'order_line',
				))
			);

if ($devis_list) {
				foreach ($devis_list as $devis){
					$address;
					$client;
					$client_on_db = DB::table('clients')->where('ODDO_ref', '=', $devis['partner_id'][0])->first();

if (!$client_on_db) {
						$client_from_odoo = $models->execute_kw(
							$db,
							$uid,
							$password,
							'res.partner',
							'read',
							array($devis['partner_id'][0]),
							array('fields'=>array(
								'name',
								'street',
								'zip',
								'city',
								'country_id'
							))
						);

$address = Address::create([
							"address" => $client_from_odoo[0]['street'] ?? "",
							"zip" => $client_from_odoo[0]['zip'] ?? "",
							"city" =>  $client_from_odoo[0]['city'] ?? "",
							"country" => $client_from_odoo[0]['country_id'][1] ?? ""
						]);

$username = str_replace(' ', '_', $client_from_odoo[0]['name']);

$user = DB::table('users')->where('name', '=', $username)->first();
						if (!$user) {
							$user = User::create([
								"name" => $username,
								"email" => replaceSpecialChar($username) . "@nettyclean.fr",
								"password" => replaceSpecialChar($username) . $devis['name'],
							]);
						}

Rules::create([
							"user_id" => $user->id,
							"role" => 'client',
						]);

$client = Clients::create([
							"user_id" => $user->id,
							"address_id" => $address->id,
							"ODDO_ref" => $client_from_odoo[0]['id'],
							"client_name" => $client_from_odoo[0]['name'],
						]);

}else{
						$address = DB::table('addresses')->where('id', '=', $client_on_db->address_id)->first();
						$client = $client_on_db;
					}

$new_devis = Devis::create([
						"client_id" => $client->id,
						"ODDO_ref" => $devis['id'],
						"ref" => $devis['name'],
						"validity_date" => $devis['validity_date']
					]);

$devis_lines_id = $devis['order_line'];
					foreach ($devis_lines_id as $line_id)
					{
						$line = $models->execute_kw(
							$db,
							$uid,
							$password,
							'sale.order.line',
							'read',
							array($line_id),
							array('fields'=>array(
								'name',
								'product_uom_qty'
							))
						);

if ($line) {
							DevisLines::create([
								"devis_id" => $new_devis->id,
								"line" => $line[0]['id'],
								"description" => $line[0]['name'],
								"qty" => $line[0]['product_uom_qty'],
							]);
						}
					}

$count++;

}
			}
		}
		echo $count . "<br>";
		echo "import done";
	}
	)->name('import-devis');

//interventions route
	Route::get('/interventions', [App\Http\Controllers\InterventionsController::class, 'index'])->name('interventions');
	Route::get('/interventions/{id}', [App\Http\Controllers\InterventionsController::class, 'show'])->name('intervention');
	Route::post('/interventions/create', [App\Http\Controllers\InterventionsController::class, 'store'])->name('create');
	Route::post('/interventions/update/{id}', [App\Http\Controllers\InterventionsController::class, 'update'])->name('update');
	Route::get('/interventions/delete/{id}', [App\Http\Controllers\InterventionsController::class, 'delete'])->name('delete');
	Route::get('/interventions/search/{ref}/{start_date}/{end_date}/{place}/{team_id}', [InterventionsController::class, "search"])->name('interventionsSearch');
  	Route::get('/interventions/details/progress', [App\Http\Controllers\InterventionsController::class, 'progress'])->name('progress');
  	Route::get('/interventions/details/finish', [App\Http\Controllers\InterventionsController::class, 'finish'])->name('finish');
  	Route::get('/interventions/details/toInvoice', [App\Http\Controllers\InterventionsController::class, 'toInvoice'])->name('toInvoice');
});

Route::group(['middleware' => 'auth'], function () {
	Route::resource('user', 'App\Http\Controllers\UserController', ['except' => ['show']]);
	Route::get('profile', ['as' => 'profile.edit', 'uses' => 'App\Http\Controllers\ProfileController@edit']);
	Route::put('profile', ['as' => 'profile.update', 'uses' => 'App\Http\Controllers\ProfileController@update']);
	Route::put('profile/password', ['as' => 'profile.password', 'uses' => 'App\Http\Controllers\ProfileController@password']);
});