Changeset 1666 in ExiteCMS for branches/PLi-Fusion/administration/reports.php

Timestamp:

08/21/08 21:06:15 (4 years ago)

Author:

hverton

Message:

Merged trunk revisions 1588:1665 into the PLi-Fusion branch

File:

• branches/PLi-Fusion/administration/reports.php (modified) (4 diffs)

branches/PLi-Fusion/administration/reports.php

@@ -5 +5 @@
 | Copyright 2007 Harro "WanWizard" Verton, Exite BV  |
 | for support, please visit http://exitecms.exite.eu |
-+----------------------------------------------------+
-| Some portions copyright 2002 - 2006 Nick Jones     |
-| http://www.php-fusion.co.uk/                       |
 +----------------------------------------------------+
 | Released under the terms & conditions of v2 of the |
@@ -30 +27 @@
 // check if the report_id variable is defined, if not, assign a default
 if (!isset($report_id) || !isNum($report_id)) $report_id = 0;
+$variables['report_id'] = $report_id;
 
-// process the action requested
-switch ($action) {
+// save requested?
+if (isset($_POST['save'])) {
+    $visibility = isset($_POST['report_visibility']) && isNum($_POST['report_visibility']) ? $_POST['report_visibility'] : 103;
+    switch ($_POST['action']) {
+        case "add":
+            // not implemented yet
+            break;
+        case "edit":
+            $result = dbquery("UPDATE ".$db_prefix."reports SET report_visibility='$visibility' WHERE report_id = '$report_id'");
+            $action = "";
+            break;
+        default:
+            die('invalid action passed!');
+    }       
+}
 
-    case "add":
-        $variables['report'] = array(
-            'report_id' => 0,
-            'report_mod_id' => 0,
-            'report_name' => "",
-            'report_title' => "",
-            'report_version' => "",
-            'report_active' => 0,
-            'report_visibility' => 103
-        );
-        break;
+// add a new report definition
+if ($action == "add" && !isset($variables['report'])) {
+    $variables['report'] = array(
+        'report_id' => 0,
+        'report_mod_id' => 0,
+        'report_mod_core' => 0,
+        'report_name' => "",
+        'report_title' => "",
+        'report_version' => "",
+        'report_active' => 0,
+        'report_visibility' => 103
+    );
+}
 
-    case "edit":
-        $result = dbquery("SELECT * FROM ".$db_prefix."reports WHERE report_id = '".$report_id."'");
-        if ($variables['report'] = dbarray($result)) {
-            _debug($variables, true);
-            // found the record
+// edit an existing report definition
+if ($action == "edit" && !isset($variables['report'])) {
+    $result = dbquery("SELECT r.*, m.mod_folder FROM ".$db_prefix."reports r LEFT JOIN ".$db_prefix."modules m ON r.report_mod_id = m.mod_id");
+    if ($data = dbarray($result)) {
+        // get the title for this report
+        if ($data['report_mod_id']) {
+            $data['custom'] = false;
+            locale_load("modules.".$data['mod_folder']);
+            $data['report_title'] = $locale[$data['report_title']];
+            $locales[] = "modules.".$data['mod_folder'];
         } else {
-            // return to the overview screen
-            $action = "";
+            if ($data['report_mod_core']) {
+                $data['mod_folder'] = "ExiteCMS";
+                $data['custom'] = false;
+            } else {
+                $data['mod_folder'] = "-";
+                $data['custom'] = true;
+            }
+            // it's a core report, get the title for the module locales
+            locale_load("main.reports");
+            if (isset($locale[$data['report_title']])) {
+                $data['report_title'] = $locale[$data['report_title']];
+            } else {
+                // not found, assume it's a static title
+            }
         }
-        break;
-
-    case "setstatus":
-        // if a status is passed, validate it
-        if (isset($status) && isNum($status) && $status >= 0 && $status <= 1) {
-            $result = dbquery("UPDATE ".$db_prefix."reports SET report_active = '".$status."' WHERE report_id = '".$report_id."'");
-        }
+        $variables['report'] = $data;
+    } else {
         // return to the overview screen
         $action = "";
-        break;
+    }
+}
+//_debug($variables, true);
+// add a new or edit an existing report definition
+if ($action == "add" || $action == "edit") {
+    // get the list of defined user groups
+    $variables['usergroups'] = getusergroups(true);
+}
+
+// toggle the report status
+if ($action == "setstatus") {
+    // if a status is passed, validate it
+    if (isset($status) && isNum($status) && $status >= 0 && $status <= 1) {
+        $result = dbquery("UPDATE ".$db_prefix."reports SET report_active = '".$status."' WHERE report_id = '".$report_id."'");
+    }
+    // return to the overview screen
+    $action = "";
 }
 
@@ -79 +120 @@
             $data['report_title'] = $locale[$data['report_title']];
         } else {
-            // make sure this field is not NULL
-            $data['mod_folder'] = "";
+            // make sure this field is not NULL, we need it later
+            $variables['mod_folder'] = "";
+            // it's a core report, get the title for the module locales
+            locale_load("main.reports");
+            if (isset($locale[$data['report_title']])) {
+                $data['report_title'] = $locale[$data['report_title']];
+            } else {
+                // not found, assume it's a static title
+            }
         }
         $data['groupname'] = getgroupname($data['report_visibility']);
@@ -97 +145 @@
 }
 
-//_debug($variables, true);
+// store the action variable
+$variables['action'] = $action;
 
 // define the admin body panel