<?php
	// ---------------------------------------------------
	// liste des modes de livraison
	// ---------------------------------------------------
	if (!isset($refresh)) $refresh='N';
	if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['refresh' => $refresh],  '31-modeLiv.reqSelect.php');	}

	if (empty($lg)) $lg=$_SESSION['lg'];
	if (empty($_SESSION['tabIdMl']) || empty($_SESSION['tabLibelleMl']) || empty($_SESSION['tabTypeML']) || empty($_SESSION['tabTypeML']) || $refresh=="Oui") {
		$tabIdMl=array();
		$tabTypeML=array();
		$tabIdTvaML=array();
		$tabAfficherMl=array();
		$tabIcoML=array();
		$tabLibelleMl=array();
		
		if (isset($filtreActiv) && $filtreActiv==0) {$reqSelect="SELECT * FROM `modeliv` order by idModeLiv;";}
		else {$reqSelect="SELECT * FROM `modeliv` WHERE activ=1 order by idModeLiv; ";}

		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['reqSelect' => $reqSelect], '');}
		$resConn='';
		$resConn=$idPdo->query($reqSelect);
		if ($resConn) {
			if ($resConn->rowCount()>0) {
				$i=0;
				While ($result=$resConn->fetch(PDO::FETCH_ASSOC)) {
					$tabIdMl[$i]=$result['idModeLiv'];
					$tabDescMl[$i]=$result['description'];
					$tabTypeML[$i]=$result['type'];
					$tabIdTvaML[$i]=$result['idTva'];
					$tabAfficherMl[$i]=$result['activ'];
					$tabIcoML[$i]=$result['icoLiv'];
					$tabSiteML[$i]=$result['siteLien'];
					if (isset($debug[10]) && $debug[10] == '1' || isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['tabIdMl' .$i => $tabIdMl[$i] ],'31-modeLiv.reqSelect.php');}

					// ---------------------------------------------------
					// Libelle mode de livraison
					// ---------------------------------------------------
					$reqSelect2="SELECT libelle FROM `modelivlibelle` WHERE idLg='" .$lg. "' AND idModeLiv=" .$tabIdMl[$i]. " order by idModeLiv;";
					if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['reqSelect2' => $reqSelect2], '');}
					$resConn2='';
					$resConn2=$idPdo->query($reqSelect2);
					if ($resConn2) {
						if ($resConn->rowCount()>0) {
							// $i=0;
							$result2=$resConn2->fetch(PDO::FETCH_ASSOC);
							$tabLibelleMl[$i]=$result2['libelle'];
							if (isset($debug[10]) && $debug[10] == '1' || isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['tabLibelleMl' .$i => $tabLibelleMl[$i] ],'');}
						}
						else {if (isset($debug[10]) && $debug[10] == '1' || isset($debug[9]) && $debug[9] == '1' ) $debugMsg .= monDebug (1,['reqSelect' => $reqSelect],''); $admMsgClass='ko';}
					}
					else {if (isset($debug[10]) && $debug[10] == '1' || isset($debug[9]) && $debug[9] == '1' ) $debugMsg .= monDebug (1,['reqSelect' => $reqSelect],''); $admMsgClass='ko';}
					$i++;
				}
				$_SESSION['tabIdMl']=$tabIdMl;
				$_SESSION['tabIcoML']=$tabIcoML;
				$_SESSION['tabLibelleMl']=$tabLibelleMl;
				$_SESSION['tabIdTvaML']=$tabIdTvaML;
				$_SESSION['tabAfficherMl']=$tabAfficherMl;
				$_SESSION['tabDescMl']=$tabDescMl;
				$_SESSION['tabSiteML']=$tabSiteML;
				if (isset($debug[10]) && $debug[10] == '1' || isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['session re-chargée' => 'Oui'],'');}
			}
		}
	}
	else {
		if (empty($tabIdMl))		$tabIdMl=$_SESSION['tabIdMl'];
		if (empty($tabIcoML))		$tabIcoML=$_SESSION['tabIcoML'];
		if (empty($tabLibelleMl))	$tabLibelleMl=$_SESSION['tabLibelleMl'];
		if (empty($tabIdTvaML))		$tabIdTvaML=$_SESSION['tabIdTvaML'];
		if (empty($tabAfficherMl))	$tabAfficherMl=$_SESSION['tabAfficherMl'];
		if (empty($tabDescMl))		$tabDescMl=$_SESSION['tabDescMl'];
		if (empty($tabSiteML))		$tabSiteML=$_SESSION['tabSiteML'];
		if (isset($debug[10]) && $debug[10] == '1' || isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['>Mode Liv remplit' => ''],'');}
	}
?>