From d7f3313ff4514e38c9f53439cd1a1287e56e45f7 Mon Sep 17 00:00:00 2001
From: vincent-peugnet <v.peugnet@free.fr>
Date: Sun, 11 Nov 2018 17:19:26 +0100
Subject: reboot folder

---
 app/class/modelart.php | 178 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 178 insertions(+)
 create mode 100644 app/class/modelart.php

(limited to 'app/class/modelart.php')

diff --git a/app/class/modelart.php b/app/class/modelart.php
new file mode 100644
index 0000000..ef4d61d
--- /dev/null
+++ b/app/class/modelart.php
@@ -0,0 +1,178 @@
+<?php
+class Modelart extends Modeldb
+{
+
+	const SELECT = ['title', 'id', 'description', 'tag', 'date', 'datecreation', 'datemodif', 'daterender', 'css', 'quickcss', 'javascript', 'html', 'header', 'section', 'nav', 'aside', 'footer', 'render', 'secure', 'invitepassword', 'interface', 'linkfrom', 'linkto', 'template', 'affcount', 'editcount'];
+	const BY = ['datecreation', 'title', 'id', 'description', 'datemodif', 'secure'];
+	const ORDER = ['DESC', 'ASC'];
+
+
+	public function __construct()
+	{
+		parent::__construct();
+	}
+
+
+
+	public function exist(Art2 $art)
+	{
+		$artdata = $this->artstore->get($art->id());
+		if($artdata === false) {
+			return false;
+		} else {
+			return true;
+		}
+		
+	}
+
+
+	public function add(Art2 $art)
+	{
+
+		$artdata = new \JamesMoss\Flywheel\Document($art->dry());
+		$artdata->setId($art->id());
+		$this->artstore->store($artdata);
+	}
+
+	public function get($id)
+	{
+		if($id instanceof Art2) {
+			$id = $id->id();
+		}
+		if(is_string($id)) {
+			$artdata = $this->artstore->findById($id);
+			if($artdata !== false) {
+				return new Art2($artdata);
+			} else {
+				return false;
+			}
+		} else {
+			return false;
+		}
+	}
+
+	public function delete(Art2 $art)
+	{
+		$this->artstore->delete($art->id());
+	}
+
+	public function update(Art2 $art)
+	{
+		$artdata = new \JamesMoss\Flywheel\Document($art->dry());
+		$artdata->setId($art->id());
+		$this->artstore->store($artdata);
+	}
+
+	public function getlisteropt(Opt $opt)
+	{
+
+		$artlist = [];
+
+		$select = 'SELECT ' . $opt->col('string') . ' FROM ' . Config::arttable();
+		$req = $this->bdd->query($select);
+		while ($donnees = $req->fetch(PDO::FETCH_ASSOC)) {
+			$artlist[] = new Art2($donnees);
+		}
+		return $artlist;
+
+	}
+
+	public function artcompare($art1, $art2, $method = 'id', $order = 1)
+	{
+		$result = ($art1->$method('sort') <=> $art2->$method('sort'));
+		return $result * $order;
+
+	}
+
+	public function buildsorter($sortby, $order)
+	{
+		return function ($art1, $art2) use ($sortby, $order) {
+			$result = $this->artcompare($art1, $art2, $sortby, $order);
+			return $result;
+		};
+	}
+
+
+
+	public function artlistsort(&$artlist, $sortby, $order = 1)
+	{
+		return usort($artlist, $this->buildsorter($sortby, $order));
+	}
+
+
+
+
+
+
+	public function filtertagfilter(array $artlist, array $tagchecked, $tagcompare = 'OR')
+	{
+
+		$filteredlist = [];
+		foreach ($artlist as $art) {
+			if (empty($tagchecked)) {
+				$filteredlist[] = $art->id();
+			} else {
+				$inter = (array_intersect($art->tag('array'), $tagchecked));
+				if ($tagcompare == 'OR') {
+					if (!empty($inter)) {
+						$filteredlist[] = $art->id();
+					}
+				} elseif ($tagcompare == 'AND') {
+					if (!array_diff($tagchecked, $art->tag('array'))) {
+						$filteredlist[] = $art->id();
+					}
+				}
+			}
+		}
+		return $filteredlist;
+	}
+
+	public function filtersecure(array $artlist, $secure)
+	{
+		$filteredlist = [];
+		foreach ($artlist as $art) {
+			if ($art->secure() == intval($secure)) {
+				$filteredlist[] = $art->id();
+			} elseif (intval($secure) >= 4) {
+				$filteredlist[] = $art->id();
+			}
+		}
+		return $filteredlist;
+	}
+
+
+	public function lister()
+	{
+		$req = $this->bdd->query(' SELECT * FROM ' . Config::arttable() . ' ORDER BY id ');
+		$donnees = $req->fetchAll(PDO::FETCH_ASSOC);
+		$req->closeCursor();
+		return $donnees;
+
+	}
+
+	public function tag(array $artlist, $tagchecked)
+	{
+		$artcheckedlist = [];
+		foreach ($artlist as $art) {
+			if (in_array($tagchecked, $art->tag('array'))) {
+				$artcheckedlist[] = $art;
+			}
+		}
+		return $artcheckedlist;
+	}
+
+	public function taglist(array $artlist, array $tagcheckedlist)
+	{
+		$taglist = [];
+		foreach ($tagcheckedlist as $tag) {
+			$taglist[$tag] = $this->tag($artlist, $tag);
+		}
+		return $taglist;
+	}
+
+	public function count()
+	{
+		return $this->bdd->query(' SELECT COUNT(*) FROM ' . $this->arttable . ' ')->fetchColumn();
+	}
+
+}
-- 
cgit v1.2.3