Added using per company customized report files.

[fa-stable.git] / admin / create_coy.php

diff --git a/admin/create_coy.php b/admin/create_coy.php
index 85579e0f92f1c37eae2ac47247911a492ed94bef..af3cffd299cf1c696e594baef0f5b0875a32d666 100644 (file)
--- a/admin/create_coy.php
+++ b/admin/create_coy.php
@@ -11,6 +11,7 @@ include_once($path_to_root . "/includes/ui.inc");
 
 page(_("Create/Update Company"));
 
+$comp_subdirs = array('images', 'pdf_files', 'backup','js_cache', 'reporting');
 
 //---------------------------------------------------------------------------------------------
 
@@ -29,14 +30,43 @@ else
 
 function check_data()
 {
-       return true;
+       global $db_connections, $tb_pref_counter;
+
+       foreach($db_connections as $id=>$con) {
+         if ($_POST['host'] == $con['host'] && $_POST['dbname'] == $con['dbname']) {
+               if ($_POST['tbpref'] == $con['tbpref']) {
+                       display_error(_("This database settings are already used by another company."));
+                       return false;
+               }
+               if ($_POST['tbpref'] == 0 || $con['tbpref'] == '') {
+                       display_error(_("You cannot have table set without prefix together with prefixed sets in the same database."));
+                       return false;
+               }
+         }
+       }
+         return true;
 }
 
 //---------------------------------------------------------------------------------------------
 
+function remove_connection($id) {
+       global $db_connections;
+
+       $dbase = $db_connections[$id]['dbname'];
+       $err = db_drop_db($db_connections[$id]);
+
+       unset($db_connections[$id]);
+       $conn = array_values($db_connections);
+       $db_connections = $conn;
+       //$$db_connections = array_values($db_connections);
+    return $err;
+}
+//---------------------------------------------------------------------------------------------
+
 function handle_submit()
 {
-       global $db_connections, $def_coy, $tb_pref_counter, $db;
+       global $db_connections, $def_coy, $tb_pref_counter, $db,
+           $comp_path, $comp_subdirs;
 
        $new = false;
 
@@ -52,9 +82,10 @@ function handle_submit()
        $db_connections[$id]['dbname'] = $_POST['dbname'];
        if (isset($_GET['ul']) && $_GET['ul'] == 1)
        {
-               if ($_POST['tbpref'] == 1)
+               if (is_numeric($_POST['tbpref']))
                {
-                       $db_connections[$id]['tbpref'] = $tb_pref_counter."_";
+                       $db_connections[$id]['tbpref'] = $_POST['tbpref'] == 1 ?
+                         $tb_pref_counter."_" : '';
                        $new = true;
                }
                else if ($_POST['tbpref'] != "")
@@ -64,21 +95,13 @@ function handle_submit()
        }
        if ((bool)$_POST['def'] == true)
                $def_coy = $id;
-       $error = write_config_db($new);
-       if ($error == -1)
-               display_error(_("Cannot open the configuration file - ") . $path_to_root . "/config_db.php");
-       else if ($error == -2)
-               display_error(_("Cannot write to the configuration file - ") . $path_to_root . "/config_db.php");
-       else if ($error == -3)
-               display_error(_("The configuration file ") . $path_to_root . "/config_db.php" . _(" is not writable. Change its permissions so it is, then re-run the operation."));
-       if ($error != 0)
-               return false;
        if (isset($_GET['ul']) && $_GET['ul'] == 1)
        {
                $conn = $db_connections[$id];
                if (($db = db_create_db($conn)) == 0)
                {
                        display_error(_("Error creating Database: ") . $conn['dbname'] . _(", Please create it manually"));
+                       remove_connection($id);
                        set_global_connection();
                        return false;
                }
@@ -98,6 +121,31 @@ function handle_submit()
                }
                set_global_connection();
        }
+       $error = write_config_db($new);
+       if ($error == -1)
+               display_error(_("Cannot open the configuration file - ") . $path_to_root . "/config_db.php");
+       else if ($error == -2)
+               display_error(_("Cannot write to the configuration file - ") . $path_to_root . "/config_db.php");
+       else if ($error == -3)
+               display_error(_("The configuration file ") . $path_to_root . "/config_db.php" . _(" is not writable. Change its permissions so it is, then re-run the operation."));
+       if ($error != 0)
+       {
+               return false;
+       }
+       $index = "<?php\nheader(\"Location: ../../index.php\");\n?>";
+
+       if ($new)
+       {
+           $cdir = $comp_path.'/'.$id;
+           @mkdir($cdir);
+           save_to_file($cdir.'/'.'index.php', 0, $index);
+
+           foreach($comp_subdirs as $dir)
+           {
+                       @mkdir($cdir.'/'.$dir);
+                       save_to_file($cdir.'/'.$dir.'/'.'index.php', 0, $index);
+           }
+       }
        return true;
 }
 
@@ -105,18 +153,14 @@ function handle_submit()
 
 function handle_delete()
 {
-       global $def_coy, $db_connections;
+       global $comp_path, $def_coy, $db_connections, $comp_subdirs;
 
        $id = $_GET['id'];
 
-       $dbase = $db_connections[$id]['dbname'];
-       $err = db_drop_db($db_connections[$id]);
-
-       unset($db_connections[$id]);
-       $conn = array_values($db_connections);
-       $db_connections = $conn;
+       $err = remove_connection($id);
+       if ($err == 0)
+               display_error(_("Error removing Database: ") . $dbase . _(", please remove it manuallly"));
 
-       //$$db_connections = array_values($db_connections);
        if ($def_coy == $id)
                $def_coy = 0;
        $error = write_config_db();
@@ -128,10 +172,16 @@ function handle_delete()
                display_error(_("The configuration file ") . $path_to_root . "/config_db.php" . _(" is not writable. Change its permissions so it is, then re-run the operation."));
        if ($error != 0)
                return;
-       if ($err == 0)
-               display_error(_("Error removing Database: ") . $dbase . _(", please remove it manuallly"));
-       else
-               meta_forward($_SERVER['PHP_SELF']);
+
+       $cdir = $comp_path.'/'.$id;
+       flush_dir($cdir);
+       if (!rmdir($cdir))
+       {
+               display_error(_("Cannot remove company data directory ") . $cdir);
+               return;
+       }
+
+       meta_forward($_SERVER['PHP_SELF']);
 }
 
 //---------------------------------------------------------------------------------------------