W 2.2

1 files changed, 251 insertions, 0 deletions

diff --git a/class/class.w.app.php b/class/class.w.app.php
new file mode 100644
index 0000000..d668c2b
--- /dev/null
+++ b/class/class.w.app.php
@@ -0,0 +1,251 @@
+<?php
+class App
+{
+	private $bdd;
+	private $admin;
+	private $secure;
+
+	public function __construct($config)
+	{
+		$this->admin = $config['admin'];
+		$this->secure = $config['secure'];
+
+		try {
+			$this->bdd = new PDO('mysql:host=' . $config['host'] . ';dbname=' . $config['dbname'] . ';charset=utf8', $config['user'], $config['password']);
+		} catch (Exeption $e) {
+			die('Erreur : ' . $e->getMessage());
+		}
+	}
+
+	public function add(Art $art)
+	{
+
+		if ($this->exist($art->id())) {
+			echo '<h4>cet id existe deja</h4>';
+		} else {
+
+			$now = new DateTimeImmutable(null, timezone_open("Europe/Paris"));
+
+			$q = $this->bdd->prepare('INSERT INTO art(id, titre, soustitre, intro, tag, datecreation, datemodif, css, html, secure, couleurtext, couleurbkg, couleurlien, couleurlienblank, lien, template) VALUES(:id, :titre, :soustitre, :intro, :tag, :datecreation, :datemodif, :css, :html, :secure, :couleurtext, :couleurbkg, :couleurlien, :couleurlienblank, :lien, :template)');
+
+			$q->bindValue(':id', $art->id());
+			$q->bindValue(':titre', $art->titre());
+			$q->bindValue(':soustitre', $art->soustitre());
+			$q->bindValue(':intro', $art->intro());
+			$q->bindValue(':tag', $art->tag('string'));
+			$q->bindValue(':datecreation', $now->format('Y-m-d H:i:s'));
+			$q->bindValue(':datemodif', $now->format('Y-m-d H:i:s'));
+			$q->bindValue(':css', $art->css());
+			$q->bindValue(':html', $art->md());
+			$q->bindValue(':secure', $art->secure());
+			$q->bindValue(':couleurtext', $art->couleurtext());
+			$q->bindValue(':couleurbkg', $art->couleurbkg());
+			$q->bindValue(':couleurlien', $art->couleurlien());
+			$q->bindValue(':couleurlienblank', $art->couleurlienblank());
+			$q->bindValue(':lien', $art->lien('string'));
+			$q->bindValue(':template', $art->template());
+
+			$q->execute();
+		}
+	}
+
+	public function delete(Art $art)
+	{
+		$req = $this->bdd->prepare('DELETE FROM art WHERE id = :id ');
+		$req->execute(array('id' => $art->id()));
+		$req->closeCursor();
+	}
+
+	public function get($id)
+	{
+		$req = $this->bdd->prepare('SELECT * FROM art WHERE id = :id ');
+		$req->execute(array('id' => $id));
+		$donnees = $req->fetch(PDO::FETCH_ASSOC);
+
+		return new Art($donnees);
+
+		$req->closeCursor();
+
+	}
+
+	public function getlister(array $selection = ['id', 'titre'], $tri = 'id', $desc = 'ASC')
+	{
+		$list = [];
+		$option = ['datecreation', 'titre', 'id', 'intro', 'datemodif'];
+		if (is_array($selection) && is_string($tri) && strlen($tri) < 16 && is_string($desc) && strlen($desc) < 5 && in_array($tri, $option)) {
+
+			$selection = implode(", ", $selection);
+
+			$select = 'SELECT ' . $selection . ' FROM art ORDER BY ' . $tri . ' ' . $desc;
+			$req = $this->bdd->query($select);
+			while ($donnees = $req->fetch(PDO::FETCH_ASSOC)) {
+				$list[] = new Art($donnees);
+			}
+			return $list;
+		}
+	}
+
+	public function lister()
+	{
+		$req = $this->bdd->query(' SELECT * FROM art ORDER BY id ');
+		$donnees = $req->fetchAll(PDO::FETCH_ASSOC);
+		return $donnees;
+
+		$req->closeCursor();
+
+	}
+
+	public function count()
+	{
+		return $this->bdd->query(' SELECT COUNT(*) FROM art ')->fetchColumn();
+	}
+
+	public function exist($id)
+	{
+		$req = $this->bdd->prepare(' SELECT COUNT(*) FROM art WHERE id = :id ');
+		$req->execute(array('id' => $id));
+		$donnees = $req->fetch(PDO::FETCH_ASSOC);
+
+		return (bool)$donnees['COUNT(*)'];
+	}
+
+	public function update(Art $art)
+	{
+		$now = new DateTimeImmutable(null, timezone_open("Europe/Paris"));
+		$art->updatelien();
+
+		$q = $this->bdd->prepare('UPDATE art SET titre = :titre, soustitre = :soustitre, intro = :intro, tag = :tag, datecreation = :datecreation, datemodif = :datemodif, css = :css, html = :html, secure = :secure, couleurtext = :couleurtext, couleurbkg = :couleurbkg, couleurlien = :couleurlien, couleurlienblank = :couleurlienblank, lien = :lien, template = :template WHERE id = :id');
+
+		$q->bindValue(':id', $art->id());
+		$q->bindValue(':titre', $art->titre());
+		$q->bindValue(':soustitre', $art->soustitre());
+		$q->bindValue(':intro', $art->intro());
+		$q->bindValue(':tag', $art->tag('string'));
+		$q->bindValue(':datecreation', $art->datecreation('string'));
+		$q->bindValue(':datemodif', $now->format('Y-m-d H:i:s'));
+		$q->bindValue(':css', $art->css());
+		$q->bindValue(':html', $art->md());
+		$q->bindValue(':secure', $art->secure());
+		$q->bindValue(':couleurtext', $art->couleurtext());
+		$q->bindValue(':couleurbkg', $art->couleurbkg());
+		$q->bindValue(':couleurlien', $art->couleurlien());
+		$q->bindValue(':couleurlienblank', $art->couleurlienblank());
+		$q->bindValue(':lien', $art->lien('string'));
+		$q->bindValue(':template', $art->template());
+
+		$q->execute();
+	}
+
+
+
+
+// __________________________________________ M E D ________________________________________________________
+
+	public function addmedia(array $file, $maxsize, $id)
+	{
+		$message = 'runing';
+		$maxsize = 2 ** 40;
+		$id = strtolower(strip_tags($id));
+		$id = str_replace(' ', '_', $id);
+		if (isset($file) and $file['media']['error'] == 0 and $file['media']['size'] < $maxsize) {
+			$infosfichier = pathinfo($file['media']['name']);
+			$extension_upload = $infosfichier['extension'];
+			$extensions_autorisees = array('jpeg', 'jpg', 'JPG', 'png', 'gif', 'mp3', 'mp4', 'mov', 'wav', 'flac');
+			if (in_array($extension_upload, $extensions_autorisees)) {
+				if (!file_exists('../media/' . $id . '.' . $extension_upload)) {
+
+					$extension_upload = strtolower($extension_upload);
+					$uploadok = move_uploaded_file($file['media']['tmp_name'], '../media/' . $id . '.' . $extension_upload);
+					if ($uploadok) {
+						$message = 'uploadok';
+					} else {
+						$message = 'uploadokerror';
+					}
+				} else {
+					$message = 'filealreadyexist';
+
+				}
+			}
+		} else {
+			$message = 'filetoobig';
+
+		}
+
+		return $message;
+	}
+
+
+	public function getmedia($entry)
+	{
+		$fileinfo = pathinfo($entry);
+
+		$filepath = $fileinfo['dirname'] . '.' . $fileinfo['extension'];
+
+		list($width, $height, $type, $attr) = getimagesize($filepath);
+
+		echo 'filepath : ' . $filepath;
+
+		$donnes = array(
+			'id' => str_replace('.' . $fileinfo['extension'], '', $fileinfo['filename']),
+			'path' => $fileinfo['dirname'],
+			'extension' => $fileinfo['extension']
+		);
+
+
+
+		return new Art($donnees);
+
+	}
+
+	public function getlistermedia($dir)
+	{
+		if ($handle = opendir($dir)) {
+			$list = [];
+			while (false !== ($entry = readdir($handle))) {
+				if ($entry != "." && $entry != "..") {
+					$fileinfo = pathinfo($entry);
+
+					$filepath = $dir . $fileinfo['filename'] . '.' . $fileinfo['extension'];
+
+					list($width, $height, $type, $attr) = getimagesize($filepath);
+					$filesize = filesize($filepath);
+
+					$donnees = array(
+						'id' => str_replace('.' . $fileinfo['extension'], '', $fileinfo['filename']),
+						'path' => $fileinfo['dirname'],
+						'extension' => $fileinfo['extension'],
+						'size' => $filesize,
+						'width' => $width,
+						'height' => $height
+					);
+
+					$list[] = new Media($donnees);
+
+				}
+			}
+			return $list;
+		}
+
+		return $list;
+
+	}
+
+
+	//_________________________________________________________ S E S ________________________________________________________
+
+	public function login($pass)
+	{
+		if (strip_tags($pass) == $this->admin) {
+			return $level = 2;
+		} elseif (strip_tags($pass) == $this->secure) {
+			return $level = 1;
+		}
+	}
+
+	public function logout()
+	{
+		return $level = 0;
+	}
+
+}
+?>
\ No newline at end of file