<?php
	$nomFicAppelant = basename(__FILE__);

	if (!empty($themeToDelete)) {

		// -----------------------------------------------------
		// Trouver le idTheme
		// -----------------------------------------------------
		if (empty($idThemeToDelete)) {
			$reqSelect="SELECT idTh, `description`  from cssthemes WHERE nom='" .$themeToDelete. "';";
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Select id du Site a supprimer' => $reqSelect], 'theme.reqDelete.php');}
			$resConn='';
			$resConn = $idPdo->query($reqSelect);
			if ($resConn) {
				$result=$resConn->fetch(PDO::FETCH_ASSOC);
				$idThemeToDelete=$result['idTh'];
				$descTheme=$result['description'];
				if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Site a supprimer' => $idThemeToDelete, 'Site a supprimer desc ' => $descTheme, 'Table a supprimer' => $themeToDelete], '');}
				$admMsgClass='ok';
			}
		}

		// -----------------------------------------------------
		// Supression de la table css
		// -----------------------------------------------------
		$reqDelete="DROP TABLE IF EXISTS `" .$themeToDelete. "`;";
		$continuer=0;
		if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');
		try{
			$idPdo->exec($reqDelete);
			// $admMsg .='Supression dans la table css pour '.$themeToDelete. ' ok !' ;
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Table' => $themeToDelete, ' supprimée avec succès !' => ''], '');}
			$continuer=1;
	    }
	    catch(PDOException $e) {
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur lors de la supression de la table:' => $e->getMessage()], '');}
	    }

		if ($continuer==1) {
			// -----------------------------------------------------
			// Supression de la ligne dans la table cssthemes
			// -----------------------------------------------------
			$reqDelete="DELETE from cssthemes WHERE nom='" .$themeToDelete. "';";
			if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');
			try{
	      		$idPdo->exec($reqDelete);
	      		// $admMsg .='Supression du site pour '.$themeToDelete. ' ok !' ;
				if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression de la ligne dans la table des themes' => $themeToDelete, ' ok!' => ''], '');}
				$admMsgClass='ok';
				// -----------------------------------------------------
				// Activation du site par defaut ou celui actif
				// -----------------------------------------------------
				include ($includePathAdmin. "/req/themesCss.reqSelect.Liste.php");
		    }
		    catch(PDOException $e) {
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression de la ligne dans la table cssthemes' => $descTheme, 'err. PDO!' => $e->getMessage() ], '');}
				$admMsgClass='ko';
		    }

			// -----------------------------------------------------
			// Supression dans les autres tables
			// -----------------------------------------------------
			if (!empty($idThemeToDelete)) {

				// -----------------------------------------------------
				// Supression des lignes dans la table thmParam
				// -----------------------------------------------------
				$reqDelete="DELETE FROM `thmParam` WHERE idTheme=" .$idThemeToDelete. ";";
				if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');
				try{
			      	$idPdo->exec($reqDelete);
			      	// $admMsg .='Supression dans la table parametre pour '.$themeToDelete. ' ok !' ;
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression dans la table thmParam pour ' => $themeToDelete, ' idTheme' => $idThemeToDelete], '');}
					$admMsgClass='ok';
			    }
			    catch(PDOException $e) {
			    	$admMsgClass='ko';
				if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur lors de la supression de la ligne dans la table des themes :' => $e->getMessage()], '');}
			    }

				// -----------------------------------------------------
				// Supression des lignes dans la table design
				// -----------------------------------------------------
				$reqDelete="DELETE from design WHERE idTheme=" .$idThemeToDelete. ";";
				if (isset($debug[2]) && $debug[2] == '1') $debugMsg .= monDebug(2,['reqDelete' => $reqDelete],'');

				try{
		      		$idPdo->exec($reqDelete);
					$admMsg .='Supression du site `'.$descTheme. '` ok !' ;
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Supression dans la table design pour '.$themeToDelete => $idThemeToDelete ], '');}
					$admMsgClass='ok';
			    }
			    catch(PDOException $e) {
					$admMsgClass='ko';
					if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur lors de la supression de la ligne dans la table des themes :' => $e->getMessage()], '');}
			    }
			}
		}
		else {
			if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Echec de la supression de la table du Site' => $descTheme, 'idThemeToDelete' => $idThemeToDelete, 'themeToDelete' => $themeToDelete ], '');}
			$admMsgClass='ko';
		}
	}
	else {
		if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Aucun Site à supprimer! : themeToDelete' => $themeToDelete], '');}
		$admMsgClass='ko';
	}
?>