userManagement/CanvasManager.php at master · Paperdreamer/userManagement · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
<?php
	require_once("../userManagement/config.php");

	class CanvasManager {
		private $DB;

		public function __construct ($DB) {
			$this->DB = $DB;
		}

		function getCanvas ($ProjectID, $CanvasID) {
			$parameters = array();
			$parameters[":ProjectID"] = $ProjectID;
			$parameters[":CanvasID"] = $CanvasID;

			return $this->DB->getRow("SELECT * FROM " . CANVAS_TABLE . " WHERE ProjectID = :ProjectID AND ID = :CanvasID", $parameters);
		}

		function addCanvas ($ProjectID, $PositionIndex, $Title, $Description, $Notes) {
			$parameters = array();
			$parameters["ProjectID"] = $ProjectID;
			$parameters["PositionIndex"] = $PositionIndex;
			$parameters["Title"] = $Title;
			$parameters["Description"] = $Description;
			$parameters["Notes"] = $Notes;

			$this->DB->query("INSERT INTO " . CANVAS_TABLE . "(ProjectID, PositionIndex, Title, Description, Notes) VALUES(:ProjectID, :PositionIndex, :Title, :Description, :Notes)", $parameters);
		}

		function removeCanvas ($ProjectID, $CanvasID) {
			$parameters = array();
			$parameters[":ProjectID"] = $ProjectID;
			$parameters[":CanvasID"] = $CanvasID;

			return $this->DB->query("DELETE FROM " . CANVAS_TABLE . " WHERE ProjectID = :ProjectID AND ID = :CanvasID", $parameters);
		}

		function removeAll ($ProjectID) {
			$parameters = array();
			$parameters[":CanvasID"] = $CanvasID;

			return $this->DB->query("DELETE FROM " . CANVAS_TABLE . " WHERE ProjectID = :ProjectID", $parameters);
		}

		function updatePanel ($ProjectID, $panelData) {
			$parameters = array();
			$parameters[":ProjectID"] 		= $ProjectID;
			$parameters[":ID"] 				= $panelData["ID"];
			$parameters[":Title"] 			= $panelData["Title"];
			$parameters[":Description"] 	= $panelData["Description"];
			$parameters[":Notes"] 			= $panelData["Notes"];
			$parameters[":PositionIndex"] 	= $panelData["PositionIndex"];

			return $this->DB->query("UPDATE " . CANVAS_TABLE . " SET Title = :Title, Description = :Description, Notes = :Notes, PositionIndex = :PositionIndex WHERE ID = :ID AND ProjectID = :ProjectID", $parameters);
		}

		function updateAssets ($AssetID, $assets) {
			foreach ($assets as $asset) {
				$parameters = array();
				$parameters[":ID"] = $asset["ID"];
				$parameters[":Index"] = $asset["Index"];
				$parameters[":top"] = floatval($asset["top"]);
				$parameters[":left"] = floatval($asset["left"]);
				$parameters[":scaleX"] = floatval($asset["scaleX"]);
				$parameters[":scaleY"] = floatval($asset["scaleY"]);
				$parameters[":flipX"] = $asset["flipX"];
				$parameters[":flipY"] = $asset["flipY"];
				$parameters[":angle"] = $asset["angle"];

				$this->DB->query("UPDATE " . ASSETTOCANVAS_TABLE . " SET `Index` = :Index, top = :top, `left` = :left, scaleX = :scaleX, scaleY = :scaleY, flipX = :flipX, flipY = :flipY, angle = :angle WHERE ID = :ID", $parameters);
			}

		}

		function getPanels ($ProjectID) {
			$parameters = array();
			$parameters[":ProjectID"] = $ProjectID;

			return $this->DB->getList("SELECT * FROM " . CANVAS_TABLE . " WHERE ProjectID = :ProjectID ORDER BY PositionIndex ASC", $parameters);
		}

		function getAssets ($CanvasID) {
			$parameters = array();
			$parameters[":CanvasID"] = $CanvasID;

			return $this->DB->getList("SELECT *, " . ASSETTOCANVAS_TABLE . ".ID FROM " . ASSETTOCANVAS_TABLE . " JOIN " . ASSET_TABLE . " ON " . ASSETTOCANVAS_TABLE . ".AssetID = " . ASSET_TABLE . ".ID WHERE " . ASSETTOCANVAS_TABLE . ".CanvasID = :CanvasID ORDER BY " . ASSETTOCANVAS_TABLE . ".Index DESC", $parameters);
		}
	}
?>