| 1 |  |  | <?php | 
            
                                                                                                            
                            
            
                                    
            
            
                | 2 |  |  | 	namespace core; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 3 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 4 |  |  | 	class Configuration { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 5 |  |  | 		//pour la configuration générale du site | 
            
                                                                                                            
                            
            
                                    
            
            
                | 6 |  |  | 		private $mail_site; //-> pour le gérant du site contact@nomdedomaine;com | 
            
                                                                                                            
                            
            
                                    
            
            
                | 7 |  |  | 		private $mail_administrateur; //-> mail de l'administrateur [email protected] | 
            
                                                                                                            
                            
            
                                    
            
            
                | 8 |  |  | 		private $last_save; //-> derniere sauvegarde de la bdd | 
            
                                                                                                            
                            
            
                                    
            
            
                | 9 |  |  | 		private $acces_admin; //-> si == 1 on a acces à l'admin | 
            
                                                                                                            
                            
            
                                    
            
            
                | 10 |  |  | 		private $contenu_dynamique; //->savoir si es contenus sont dynamique (stockés in DB) | 
            
                                                                                                            
                            
            
                                    
            
            
                | 11 |  |  | 		private $cache; //-> si == 1 alors on mets les pages du site en cache | 
            
                                                                                                            
                            
            
                                    
            
            
                | 12 |  |  | 		private $desactiver_navigation; //-> si == 1 alors on n'affichera pas la nav dans principal.php | 
            
                                                                                                            
                            
            
                                    
            
            
                | 13 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 14 |  |  | 		//pour la configuration des comptes | 
            
                                                                                                            
                            
            
                                    
            
            
                | 15 |  |  | 		private $valider_inscription; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 16 |  |  | 		private $activer_inscription; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 17 |  |  | 		private $activer_connexion; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 18 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 19 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 20 |  |  | 		//-------------------------- CONSTRUCTEUR ----------------------------------------------------------------------------// | 
            
                                                                                                            
                            
            
                                    
            
            
                | 21 |  |  | 		public function __construct() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 22 |  |  | 			//pour la configuration générale du site | 
            
                                                                                                            
                            
            
                                    
            
            
                | 23 |  |  | 			$arr = $this->getConfigurationGenerale(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 24 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 25 |  |  | 			//pour la configuration des comptes | 
            
                                                                                                            
                            
            
                                    
            
            
                | 26 |  |  | 			$arr1 = $this->getConfigurationCompte(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 27 |  |  | 			 | 
            
                                                                                                            
                            
            
                                    
            
            
                | 28 |  |  | 			App::setValues(["configuration" => array_merge($arr, $arr1)]); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 29 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 30 |  |  | 		//-------------------------- FIN CONSTRUCTEUR ----------------------------------------------------------------------------// | 
            
                                                                                                            
                            
            
                                    
            
            
                | 31 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 32 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 33 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 34 |  |  | 		//-------------------------- GETTER ----------------------------------------------------------------------------// | 
            
                                                                                                            
                            
            
                                    
            
            
                | 35 |  |  | 		/** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 36 |  |  | 		 * @return string|null | 
            
                                                                                                            
                            
            
                                    
            
            
                | 37 |  |  | 		 */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 38 |  |  | 		public function getMailSite() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 39 |  |  | 			return $this->mail_site; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 40 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 41 |  |  | 		public function getMailAdministrateur() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 42 |  |  | 			return $this->mail_administrateur; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 43 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 44 |  |  | 		public function getLastSave() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 45 |  |  | 			return $this->last_save; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 46 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 47 |  |  | 		public function getAccesAdmin() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 48 |  |  | 			return $this->acces_admin; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 49 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 50 |  |  | 		public function getContenusDynamique() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 51 |  |  | 			return $this->contenu_dynamique; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 52 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 53 |  |  | 		public function getCache() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 54 |  |  | 			return $this->cache; | 
            
                                                                                                            
                                                                
            
                                    
            
            
                | 55 |  |  | 		} | 
            
                                                                        
                            
            
                                    
            
            
                | 56 |  |  | 		public function getDesactiverNavigation(){ | 
            
                                                                        
                            
            
                                    
            
            
                | 57 |  |  | 		    return $this->desactiver_navigation; | 
            
                                                                        
                            
            
                                    
            
            
                | 58 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 59 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 60 |  |  | 		//pour la configuration des comptes | 
            
                                                                                                            
                            
            
                                    
            
            
                | 61 |  |  | 		public function getValiderInscription() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 62 |  |  | 			return $this->valider_inscription; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 63 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 64 |  |  | 		public function getActiverInscription() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 65 |  |  | 			return $this->activer_inscription; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 66 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 67 |  |  | 		public function getActiverConnexion() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 68 |  |  | 			return $this->activer_connexion; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 69 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 70 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 71 |  |  | 		private function getConfigurationGenerale() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 72 |  |  | 			$dbc = App::getDb(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 73 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 74 |  |  | 			$query = $dbc->select()->from("configuration")->where("ID_configuration", "=", 1)->get(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 75 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 76 |  |  | 			if ((is_array($query)) && (count($query) > 0)) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 77 |  |  | 				foreach ($query as $obj) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 78 |  |  | 					$this->mail_site = $obj->mail_site; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 79 |  |  | 					$this->mail_administrateur = $obj->mail_administrateur; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 80 |  |  | 					$this->last_save = $obj->last_save; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 81 |  |  | 					$this->acces_admin = $obj->acces_admin; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 82 |  |  | 					$this->contenu_dynamique = $obj->contenu_dynamique; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 83 |  |  | 					$this->cache = $obj->cache; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 84 |  |  | 					$this->desactiver_navigation = $obj->desactiver_navigation; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 85 |  |  | 					 | 
            
                                                                                                            
                            
            
                                    
            
            
                | 86 |  |  | 					return [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 87 |  |  | 						"nom_site" => $obj->nom_site, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 88 |  |  | 						"mail_site" => $obj->mail_site, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 89 |  |  | 						"gerant_site" => $obj->gerant_site, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 90 |  |  | 						"mail_administrateur" => $obj->mail_administrateur, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 91 |  |  | 						"last_save" => $obj->last_save, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 92 |  |  | 						"acces_admin" => $obj->acces_admin, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 93 |  |  | 						"contenu_dynamique" => $obj->contenu_dynamique, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 94 |  |  | 						"cache" => $obj->cache, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 95 |  |  | 						"desactiver_navigation" => $obj->desactiver_navigation | 
            
                                                                                                            
                            
            
                                    
            
            
                | 96 |  |  | 					]; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 97 |  |  | 				} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 98 |  |  | 			} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 99 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 100 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 101 |  |  | 		private function getConfigurationCompte() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 102 |  |  | 			$dbc = App::getDb(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 103 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 104 |  |  | 			$query = $dbc->select()->from("configuration_compte")->where("ID_configuration_compte", "=", 1)->get(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 105 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 106 |  |  | 			if ((is_array($query)) && (count($query) > 0)) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 107 |  |  | 				foreach ($query as $obj) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 108 |  |  | 					$this->valider_inscription = $obj->valider_inscription; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 109 |  |  | 					$this->activer_inscription = $obj->activer_inscription; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 110 |  |  | 					$this->activer_connexion = $obj->activer_connexion; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 111 |  |  | 					 | 
            
                                                                                                            
                            
            
                                    
            
            
                | 112 |  |  | 					return [ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 113 |  |  | 						"valider_inscription" => $obj->valider_inscription, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 114 |  |  | 						"activer_inscription" => $obj->activer_inscription, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 115 |  |  | 						"activer_connexion" => $obj->activer_connexion, | 
            
                                                                                                            
                            
            
                                    
            
            
                | 116 |  |  | 					]; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 117 |  |  | 				} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 118 |  |  | 			} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 119 |  |  | 		} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 120 |  |  | 		//-------------------------- FIN GETTER ----------------------------------------------------------------------------// | 
            
                                                                                                            
                            
            
                                    
            
            
                | 121 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 122 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 123 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 124 |  |  | 		//-------------------------- SETTER ----------------------------------------------------------------------------// | 
            
                                                                                                            
                            
            
                                    
            
            
                | 125 |  |  | 		/** | 
            
                                                                                                            
                            
            
                                    
            
            
                | 126 |  |  | 		 * fonction qui permet de mettre à jour la date de la derniere save de la bdd | 
            
                                                                                                            
                            
            
                                    
            
            
                | 127 |  |  | 		 * + supprimer la sauverde ancienne d'il y a 1 mois | 
            
                                                                                                            
                            
            
                                    
            
            
                | 128 |  |  | 		 */ | 
            
                                                                                                            
                            
            
                                    
            
            
                | 129 |  |  | 		public function setDateSaveToday() { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 130 |  |  | 			$dbc = App::getDb(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 131 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 132 |  |  | 			$dbc->update("last_save", date("Y-m-d"))->from("configuration")->where("ID_configuration", "=", 1)->set(); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 133 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 134 |  |  | 			$today = new \DateTime(date("Y-m-d")); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 135 |  |  | 			$today->sub(new \DateInterval('P32D')); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 136 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 137 |  |  | 			$nom_save = "save-".$today->format("Y-m-d").".sql"; | 
            
                                                                                                            
                            
            
                                    
            
            
                | 138 |  |  |  | 
            
                                                                                                            
                            
            
                                    
            
            
                | 139 |  |  | 			if (file_exists(ROOT."bdd_backup/".$nom_save)) { | 
            
                                                                                                            
                            
            
                                    
            
            
                | 140 |  |  | 				unlink(ROOT."bdd_backup/".$nom_save); | 
            
                                                                                                            
                            
            
                                    
            
            
                | 141 |  |  | 			} | 
            
                                                                                                            
                            
            
                                    
            
            
                | 142 |  |  | 		} | 
            
                                                                                                            
                                                                
            
                                    
            
            
                | 143 |  |  | 		//-------------------------- FIN SETTER ----------------------------------------------------------------------------// | 
            
                                                        
            
                                    
            
            
                | 144 |  |  | 	} |