X-Git-Url: http://git.cyclocoop.org/?p=velocampus%2Fweb%2Fwww.git;a=blobdiff_plain;f=www%2Fplugins%2Fauto%2Ffullcalendar%2Fbase%2Ffullcalendar.php;fp=www%2Fplugins%2Fauto%2Ffullcalendar%2Fbase%2Ffullcalendar.php;h=3d0fd836df67c9f2a787e0e9f7948b8914ec9c6e;hp=0000000000000000000000000000000000000000;hb=80b4d3e85f78d402ed2e73f8f5d1bf4c19962eed;hpb=aaf970bf4cdaf76689ecc10609048e18d073820c

diff --git a/www/plugins/auto/fullcalendar/base/fullcalendar.php b/www/plugins/auto/fullcalendar/base/fullcalendar.php
new file mode 100644
index 0000000..3d0fd83
--- /dev/null
+++ b/www/plugins/auto/fullcalendar/base/fullcalendar.php
@@ -0,0 +1,125 @@
+<?php
+
+/* * * * * * * * * * * * * * * * * * * *
+ * 
+ *     - FullCalendar pour SPIP -
+ * 
+ * Description des tables à créer dans MySQL
+ * 
+ * Auteur : Grégory PASCAL - ngombe at gmail dot com
+ * Modifs : 05/04/2011
+ * 
+ */
+
+global $tables_principales;
+
+/*
+ * spip_fullcalendar_main
+ *
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | Field           | Type       | Null | Key | Default | Extra          |
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | id_fullcalendar | int(11)    | NO   | PRI | NULL    | auto_increment |
+ * | type            | varchar(7) | NO   |     | NULL    |                |
+ * | nom             | text       | NO   |     | NULL    |                |
+ * +-----------------+------------+------+-----+---------+----------------+
+ */ 
+
+$spip_fullcalendar_main = array(
+    "id_fullcalendar" => "BIGINT(21) NOT NULL auto_increment",
+    "type" => "VARCHAR(7) NOT NULL",
+    "nom" => "TEXT NOT NULL"
+);
+
+$spip_fullcalendar_key = array(
+	"PRIMARY KEY" => "id_fullcalendar"
+);
+
+$tables_principales['spip_fullcalendar_main'] = array(
+	'field' => &$spip_fullcalendar_main,
+	'key' => &$spip_fullcalendar_key
+);
+
+/*
+ * spip_fullcalendar_events
+ *
+ * +-----------------+----------+------+-----+---------+----------------+
+ * | Field           | Type     | Null | Key | Default | Extra          |
+ * +-----------------+----------+------+-----+---------+----------------+
+ * | id_event        | int(11)  | NO   | PRI | NULL    | auto_increment |
+ * | id_fullcalendar | int(11)  | NO   |     | NULL    |                |
+ * | id_style        | int(11)  | NO   |     | NULL    |                |
+ * | titre           | text     | NO   |     | NULL    |                |
+ * | lien            | text     | NO   |     | NULL    |                |
+ * | start           | datetime | NO   |     | NULL    |                |
+ * | end             | datetime | NO   |     | NULL    |                |
+ * +-----------------+----------+------+-----+---------+----------------+
+ */
+
+$spip_fullcalendar_events = array(
+    "id_event" => "BIGINT(21) NOT NULL auto_increment",
+    "id_fullcalendar" => "BIGINT(21) NOT NULL",
+    "id_style" => "BIGINT(21) NOT NULL",
+    "titre" => "TEXT NOT NULL",
+    "lien" => "TEXT NOT NULL",
+    "start" => "DATETIME NOT NULL",
+    "end" => "DATETIME NOT NULL"
+);
+
+$spip_fullcalendar_events_key = array(
+	"PRIMARY KEY" => "id_event"
+);
+
+$tables_principales['spip_fullcalendar_events'] = array(
+	'field' => &$spip_fullcalendar_events,
+	'key' => &$spip_fullcalendar_events_key
+);
+
+
+/*
+ * spip_fullcalendar_styles
+ *
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | Field           | Type       | Null | Key | Default | Extra          |
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | id_style        | int(11)    | NO   | PRI | NULL    | auto_increment |
+ * | titre           | text       | NO   |     | NULL    |                |
+ * | bordercolor     | varchar(7) | NO   |     | NULL    |                |
+ * | bgcolor         | varchar(7) | NO   |     | NULL    |                |
+ * | textcolor       | varchar(7) | NO   |     | NULL    |                |
+ * +-----------------+------------+------+-----+---------+----------------+
+ */
+
+$spip_fullcalendar_styles = array(
+    "id_style" => "BIGINT(21) NOT NULL auto_increment",
+    "titre" => "TEXT NOT NULL",
+    "bordercolor" => "VARCHAR(7) NOT NULL",
+    "bgcolor" => "VARCHAR(7) NOT NULL",
+    "textcolor" => "VARCHAR(7) NOT NULL"
+);
+
+$spip_fullcalendar_styles_key = array(
+	"PRIMARY KEY" => "id_style"
+);
+
+$tables_principales['spip_fullcalendar_styles'] = array(
+	'field' => &$spip_fullcalendar_styles,
+	'key' => &$spip_fullcalendar_styles_key
+);
+
+/*
+ function boucle_fullcalendar_dist($id_boucle, &$boucles) {
+		$boucle = &$boucles[$id_boucle];
+		$id_table = $boucle->id_table;
+		$boucle->from[$id_table] =  "spip_fullcalendar";  
+
+		if (!$GLOBALS['var_preview']) {
+			if (!$boucle->statut) {
+				$boucle->where[]= array("'IN'", "'$id_table.id_fullcalendar'", "''");
+			}
+		}
+		return calculer_boucle($id_boucle, $boucles); 
+}
+*/
+
+?>