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

	// -----------------------------------------------------
	// Select  ligne avec module 1 : Sms
	// -----------------------------------------------------
	$reqSelect="SELECT * FROM `123projets` WHERE idModule=3 and idClient=" .$idClient123. ";";
	if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reqSelect' => $reqSelect], 'reqSelectSms.php');}
	$resConn='';
	$resConn=$connexion->query($reqSelect);
	if ($resConn) {
		while ($tabResult = $resConn->fetch(PDO::FETCH_ASSOC)) {
			$idModule=$tabResult['idModule'];
			$paye=$tabResult['is_payed'];
			$idSms=$tabResult['param1'];
			$param2=$tabResult['param2'];
			$statut=$tabResult['statut'];
			$desc=$tabResult['description'];
			$stripePaiement_id=$tabResult['stripePaiement_id'];
			$stripePortal_id=$tabResult['stripePortal_id'];
			$stripeSubscription_id=$tabResult['stripeSubscription_id'];
			$stripeClient_id=$tabResult['stripeClient_id'];
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['modDesc' => $desc], '');}
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['statut' => $statut], '');}
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['param1' => $param1], '');}
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['param2' => $param2], '');}
			$_SESSION['desc'] = $desc;
			$_SESSION['checkOutSession_id']=$stripePaiement_id;
			$_SESSION['stripeSubscription_id']=$stripeSubscription_id;
			$_SESSION['statut']=$statut;
			$_SESSION['custId']=$stripeClient_id;
		}
	}
	else {
		$admMsg .= 'Echec de la reqSelectSms.php';
		if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['SESSION[idClient123]=' => $_SESSION['idClient123']], '');}
	}
?>