[SPIP] +2.1.12

[velocampus/web/www.git] / www / plugins / auto / fullcalendar / base / fullcalendar.php

diff --git a/www/plugins/auto/fullcalendar/base/fullcalendar.php b/www/plugins/auto/fullcalendar/base/fullcalendar.php
new file mode 100644 (file)
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); 
+}
+*/
+
+?>