<?php
	$nomFicAppelant = basename(__FILE__);
	// -----------------------------------------------------
	// 1 - recup idClient 123clients
	// -----------------------------------------------------
	include ($includePathAdmin. "/req/reqRecupClient123.php");
	$tabResult2=	array();

	// -----------------------------------------------------
	// Select  ligne avec module 1
	// -----------------------------------------------------
	$reqSelect="SELECT * FROM `123projets` WHERE idModule=21 AND idClient=" .$idClient123. ";";
	if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqSelect Presta' => $reqSelect], 'reqSelectFormules.php');}
	$resConn2=$connexion->query($reqSelect);
	if ($resConn2) {
		while ($tabResult2 = $resConn2->fetch(PDO::FETCH_ASSOC)) {
			$paye=$tabResult2['is_payed'];
			$siteName=$tabResult2['siteName'];
			$idFormule=$tabResult2['param1'];
			$desc=$tabResult2['description'];
			// $stripePaiement_id=$tabResult2['stripePaiement_id'];
			// $stripePortal_id=$tabResult2['stripePortal_id'];
			// $stripeSubscription_id=$tabResult2['stripeSubscription_id'];
			// if (isset($tabResult2['stripeClient_id'])) $stripeClient_custId=$tabResult2['stripeClient_id'];
			$statut=$tabResult2['statut'];
			// $desc=$tabResult2['description'];
			if (isset($debug[2]) && $debug[2] == '1') {
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['stripePaiement_id' => $stripePaiement_id], '');}
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['stripeSubscription_id' => $stripeSubscription_id], '');}
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['statut' => $statut], '');}
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['desc' => $desc], '');}
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['idFormule' => $idFormule], '');}
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['stripeClient_custId' => $stripeClient_custId], '');}
			}
			// $_SESSION['checkOutSession_id']=$stripePaiement_id;
			// $_SESSION['stripeSubscription_id']=$stripeSubscription_id;
			// $_SESSION['idFormule']=$idFormule;
			// $_SESSION['statut']=$statut;
			// if (isset($stripeClient_custId)) $_SESSION['custId']=$stripeClient_custId;
		}
	}
	else {
		$admMsg .= 'Echec de la reqSelectPresta.php';
		if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['SESSION[idClient123]=' => $_SESSION['idClient123']], '');}
	}
?>