<?php
	$nomFicAppelant = basename(__FILE__);
	$resConn='';
	include ($includePathAdmin. "/123connect.php");

	// -----------------------------------------------------
	// 1 - recup idClient 123clients
	// -----------------------------------------------------
	include ($includePathAdmin. "/req/reqRecupClient123.php");
	
	// -----------------------------------------------------
	// 1.2 - verif si la ligne existe pas deja dans 123projets
	// -----------------------------------------------------
	$resConn='';
	$idClientExist="";
	$reqSelect="SELECT idClient FROM `123projets` WHERE idClient=" .$idClient123. " and idModule=2;";
	if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqSelect' => $reqSelect], 'domain.reqUpdateToAchat.php');}
	$resConn=$connexion->query($reqSelect);
	if ($resConn) {
		$tabResult=$resConn->fetch(PDO::FETCH_ASSOC);
		$idClientExist=$tabResult['idClient'];
	}
	if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['pas de connect' => ''], '');}
	
	// -----------------------------------------------------
	// 1.3 - update 123Projets ou insert 123projets
	// -----------------------------------------------------
	if (empty($today)) {
		date_default_timezone_set( 'Europe/Paris' );
		$dateTimeObj = new DateTime('now', new DateTimeZone('Europe/Paris'));
		$today = IntlDateFormatter::formatObject( $dateTimeObj, "y-MM-dd_HH-mm", 'fr' );
	}
	$next = date('Y-m-d', strtotime('+1 year', strtotime($today)) );
	if ($idClientExist=="" || $resConn=="") {
		// 1.3.1 requete insert
		$reqInsert="INSERT INTO `123projets` (numModule, idClient, siteName, idModule, prix, is_payed, param1, param2, stripePaiement_id, stripePortal_id, stripeSubscription_id, stripeClient_id, statut, dateAchat,  dateRenouvellement, description, commentaires)
		VALUES (0, " .$idClient123. ",'" .$_SESSION['siteNomTech']. "',  '2', '0.00', 0, '3', '" .$domToBuy. "', 'pay_id', 'portail_id', 'sub_id','cust_id,'panier', '" .$today. "', 'sans', 'Achat de domaine dédié','Action a faire' );";

		if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqInsert' => $reqInsert], 'domain.reqUpdateToAchat.php');}
		$resConn='';

		$resConn=$connexion->query($reqInsert);
		if ($resConn) {
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Insert module domain Achat ok' => ''], '');}
		}
		if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqInsert' => $reqInsert], 'domain.reqUpdateToAchat.php');}
	}
	else {
		// 1.3.2 - update 123Projets
		$reqUpdate="UPDATE `123projets` SET param1='3', param2='" .$domToBuy. "', statut='panier', description='Achat de domaine dédié', commentaire='Action a faire' WHERE idClient=" .$idClient123. " AND idModule=2;";
		if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqUpdate' => $reqUpdate], 'domain.reqUpdateToAchat.php');}
		$resConn='';

		$resConn=$connexion->query($reqUpdate);
		if ($resConn) {
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Update module domain Achat ok' => ''], '');}
		}
		if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['pb de update module domain Achat : reqUpdateToAchat' => '', 'reqUpdate' => $reqUpdate], 'domain.reqUpdateToAchat.php');}
	}
	
	// -----------------------------------------------------
	// Etape 7 to done
	// -----------------------------------------------------
	if ($resConn) {
		include ("reqUpdateEtape7.php");
	}
?>