X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Finst_module.php;h=2329146cf05af39c4ac60adbbb82f917221cdd6f;hb=45a035785b9a820621da56dec93078b3ccd9832e;hp=5f8e236361d36e44c3b4e8195750f6938cea03a6;hpb=cb8cf10b735342399abfce9384565a7474b92947;p=fa-stable.git
diff --git a/admin/inst_module.php b/admin/inst_module.php
index 5f8e2363..2329146c 100644
--- a/admin/inst_module.php
+++ b/admin/inst_module.php
@@ -1,173 +1,83 @@
.
+***********************************************************************/
+$page_security = 'SA_CREATEMODULES';
$path_to_root="..";
include_once($path_to_root . "/includes/session.inc");
-page(_("Install/Update Modules"));
+page(_("Install/Activate extensions"));
include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/admin/db/company_db.inc");
-include_once($path_to_root . "/modules/installed_modules.php");
+include_once($path_to_root . "/admin/db/maintenance_db.inc");
include_once($path_to_root . "/includes/ui.inc");
-$tabs = array('orders', 'AP', 'stock', 'manuf', 'proj', 'GL', 'system');
-$names = array(_("Sales"), _("Purchases"), _("Items and Inventory"), _("Manufacturing"),
- _("Dimensions"), _("Banking and General Ledger"), _("Setup"));
-
-//---------------------------------------------------------------------------------------------
-
-if (isset($_GET['selected_id']))
-{
- $selected_id = $_GET['selected_id'];
-}
-elseif (isset($_POST['selected_id']))
-{
- $selected_id = $_POST['selected_id'];
-}
-else
- $selected_id = -1;
+simple_page_mode(true);
//---------------------------------------------------------------------------------------------
-
-function get_tab_title($tab)
-{
- global $tabs, $names;
- for ($i = 0; $i < count($tabs); $i++)
- {
- if ($tabs[$i] == $tab)
- return $names[$i];
+function update_extensions($extensions) {
+ global $db_connections;
+
+ if (!write_extensions($extensions)) {
+ display_notification(_("Cannot update system extensions list."));
+ return false;
}
- return "";
-}
-function tab_list_row($label, $name, $selected)
-{
- global $tabs, $names;
- echo "
\n";
- if ($label != null)
- echo "$label | \n";
- if ($selected == null)
- $selected = (!isset($_POST[$name]) ? "orders" : $_POST[$name]);
- echo " | \n";
- echo "
\n";
-}
-
-//---------------------------------------------------------------------------------------------
-
-function check_data()
-{
+ $newexts = $extensions;
+ // update 'active' status
+ $exts = get_company_extensions($i);
+ foreach ($exts as $key => $ext)
+ {
+ if (isset($newexts[$key]))
+ $newexts[$key]['active'] = $exts[$key]['active'];
+ }
+ if(!write_extensions($newexts, $i))
+ {
+ display_notification(sprintf(_("Cannot update extensions list for company '%s'."),
+ $db_connections[$i]['name']));
+ return false;
+ }
+ }
return true;
}
-/**
- * @return Returns the array sorted as required
- * @param $aryData Array containing data to sort
- * @param $strIndex name of column to use as an index
- * @param $strSortBy Column to sort the array by
- * @param $strSortType String containing either asc or desc [default to asc]
- * @desc Naturally sorts an array using by the column $strSortBy
- */
-function array_natsort($aryData, $strIndex, $strSortBy, $strSortType=false)
-{
- // if the parameters are invalid
- if (!is_array($aryData) || !$strIndex || !$strSortBy)
- // return the array
- return $aryData;
-
- // create our temporary arrays
- $arySort = $aryResult = array();
-
- // loop through the array
- foreach ($aryData as $aryRow)
- // set up the value in the array
- $arySort[$aryRow[$strIndex]] = $aryRow[$strSortBy];
-
- // apply the natural sort
- natsort($arySort);
-
- // if the sort type is descending
- if ($strSortType=="desc")
- // reverse the array
- arsort($arySort);
-
- // loop through the sorted and original data
- foreach ($arySort as $arySortKey => $arySorted)
- foreach ($aryData as $aryOriginal)
- // if the key matches
- if ($aryOriginal[$strIndex]==$arySortKey)
- // add it to the output array
- array_push($aryResult, $aryOriginal);
-
- // return the return
- return $aryResult;
-}
-
-function write_modules()
+function check_data($id, $exts)
{
- global $path_to_root, $installed_modules;
-
- $mods = array_natsort($installed_modules, 'tab', 'tab');
- $installed_modules = $mods;
- //reset($installed_languages);
- $n = count($installed_modules);
- $msg = " ";
- for ($i = 0; $i < $n; $i++)
- {
- if ($i > 0)
- $msg .= "\t\tarray ";
- else
- $msg .= "array ";
- $msg .= "('tab' => '" . $installed_modules[$i]['tab'] . "', ";
- $msg .= "'name' => '" . $installed_modules[$i]['name'] . "', ";
- $msg .= "'path' => '" . $installed_modules[$i]['path'] . "', ";
- $msg .= "'filename' => '" . $installed_modules[$i]['filename'] . "'";
- $msg .= "),\n";
+ if ($_POST['name'] == "") {
+ display_error(_("Extension name cannot be empty."));
+ return false;
}
- $msg .= "\t);\n?>";
-
- $filename = $path_to_root . "/modules/installed_modules.php";
- // Check if the file exists and is writable first.
- if (file_exists($filename) && is_writable($filename))
- {
- if (!$zp = fopen($filename, 'w'))
- {
- display_error(_("Cannot open the modules file - ") . $filename);
+ foreach($exts as $n =>$ext) {
+ if ($_POST['name'] == $ext['name'] && $id != $n) {
+ display_error(_("Extension name have to be unique."));
return false;
- }
- else
- {
- if (!fwrite($zp, $msg))
- {
- display_error(_("Cannot write to the modules file - ") . $filename);
- fclose($zp);
- return false;
- }
- // Close file
- fclose($zp);
}
- }
- else
- {
- display_error(_("The modules file ") . $filename . _(" is not writable. Change its permissions so it is, then re-run the operation."));
+ }
+
+ if ($_POST['title'] == "") {
+ display_error(_("Extension title cannot be empty."));
return false;
}
+ if ($_POST['path'] == "") {
+ display_error(_("Extension folder name cannot be empty."));
+ return false;
+ }
+ if ($id == -1 && !is_uploaded_file($_FILES['uploadfile']['tmp_name'])) {
+ display_error(_("You have to select plugin file to upload"));
+ return false;
+ }
return true;
}
@@ -175,24 +85,34 @@ function write_modules()
function handle_submit()
{
- global $path_to_root, $installed_modules;
+ global $path_to_root, $db_connections, $selected_id, $next_extension_id;
- if (!check_data())
+ $extensions = get_company_extensions();
+ if (!check_data($selected_id, $extensions))
return false;
+ $id = $selected_id==-1 ? $next_extension_id : $selected_id;
+
+ if ($selected_id != -1 && $extensions[$id]['type'] != 'plugin') {
+ display_error(_('Module installation support is not implemented yet. You have to do it manually.'));
+ return;
+ }
- $id = $_GET['id'];
+ $extensions[$id]['tab'] = $_POST['tab'];
+ $extensions[$id]['name'] = $_POST['name'];
+ $extensions[$id]['path'] = $_POST['path'];
+ $extensions[$id]['title'] = $_POST['title'];
+ $extensions[$id]['active'] = check_value('active');
- $installed_modules[$id]['tab'] = $_POST['tab'];
- $installed_modules[$id]['name'] = $_POST['name'];
- $installed_modules[$id]['path'] = $_POST['path'];
- $directory = $path_to_root . "/modules/" . $_POST['path'];
+ // Currently we support only plugin extensions here.
+ $extensions[$id]['type'] = 'plugin';
+ $directory = $path_to_root . "/modules/" . $_POST['path'];
if (!file_exists($directory))
{
mkdir($directory);
- }
+ }
if (is_uploaded_file($_FILES['uploadfile']['tmp_name']))
{
- $installed_modules[$id]['filename'] = $_FILES['uploadfile']['name'];
+ $extensions[$id]['filename'] = $_FILES['uploadfile']['name'];
$file1 = $_FILES['uploadfile']['tmp_name'];
$file2 = $directory . "/".$_FILES['uploadfile']['name'];
if (file_exists($file2))
@@ -200,154 +120,245 @@ function handle_submit()
move_uploaded_file($file1, $file2);
}
else
- $installed_modules[$id]['filename'] = $_POST['filename'];
- if (!write_modules())
+ $extensions[$id]['filename'] = get_post('filename');
+ if (is_uploaded_file($_FILES['uploadfile2']['tmp_name']))
+ {
+ $file1 = $_FILES['uploadfile2']['tmp_name'];
+ $file2 = $directory . "/".$_FILES['uploadfile2']['name'];
+ if (file_exists($file2))
+ unlink($file2);
+ move_uploaded_file($file1, $file2);
+ $db_name = $_SESSION["wa_current_user"]->company;
+ db_import($file2, $db_connections[$db_name]);
+ }
+
+ if (is_uploaded_file($_FILES['uploadfile3']['tmp_name']))
+ {
+ $extensions[$id]['acc_file'] = $_FILES['uploadfile3']['name'];
+ $file1 = $_FILES['uploadfile3']['tmp_name'];
+ $file2 = $directory . "/".$_FILES['uploadfile3']['name'];
+ if (file_exists($file2))
+ unlink($file2);
+ move_uploaded_file($file1, $file2);
+ }
+ else
+ $extensions[$id]['acc_file'] = get_post('acc_file');
+
+ // security area guess for plugins
+ if ($extensions[$id]['type'] == 'plugin'){
+ $exttext = file_get_contents($path_to_root.'/modules/'
+ .$extensions[$id]['path'].'/'.$extensions[$id]['filename']);
+ $area = 'SA_OPEN';
+ if (preg_match('/.*\$page_security\s*=\s*[\'"]([^\'"]*)/', $exttext, $match)) {
+ $area = trim($match[1]);
+ }
+ $extensions[$id]['access'] = $area;
+ }
+
+ if ($selected_id == -1)
+ {
+ $next_extension_id++;
+ }
+ if (!update_extensions($extensions))
return false;
return true;
}
-//---------------------------------------------------------------------------------------------
-
function handle_delete()
{
- global $path_to_root, $installed_modules;
-
- $id = $_GET['id'];
+ global $path_to_root, $db_connections, $selected_id;
+
+ $extensions = get_company_extensions();
- $path = $installed_modules[$id]['path'];
- $filename = "$path_to_root/modules/$path";
- if ($h = opendir($filename))
- {
- while (($file = readdir($h)) !== false)
- {
- if (is_file("$filename/$file"))
- unlink("$filename/$file");
- }
- closedir($h);
- }
- rmdir($filename);
+ $id = $selected_id;
- unset($installed_modules[$id]);
- $mods = array_values($installed_modules);
- $installed_modules = $mods;
+ $filename = $path_to_root
+ . ($extensions[$id]['type']=='plugin' ? "/modules/": '/')
+ . $extensions[$id]['path'];
- if (!write_modules())
- return;
- meta_forward($_SERVER['PHP_SELF']);
+ flush_dir($filename);
+ rmdir($filename);
+ unset($extensions[$id]);
+ if (update_extensions($extensions))
+ display_notification(_("Selected extension has been successfully deleted"));
+ return true;
}
//---------------------------------------------------------------------------------------------
-function display_modules()
+function display_extensions()
{
- global $table_style, $installed_modules;
-
- echo "
- ";
+ global $table_style, $tabs;
+
start_table($table_style);
- $th = array(_("Tab"), _("Name"), _("Folder"), _("Filename"), "", "");
+ $th = array(_("Name"),_("Tab"), _("Link text"), _("Folder"), _("Filename"),
+ _("Access extensions"),"", "");
table_header($th);
$k = 0;
- $mods = $installed_modules;
- $n = count($mods);
- for ($i = 0; $i < $n; $i++)
+ $mods = get_company_extensions();
+ $mods = array_natsort($mods, null, 'name');
+
+ foreach($mods as $i => $mod)
{
+ $is_mod = $mod['type'] == 'module';
alt_table_row_color($k);
+ label_cell($mod['name']);
+ label_cell( $is_mod ? $mod['title'] : $tabs[$mod['tab']]);
+ $ttl = access_string($mod['title']);
+ label_cell($ttl[0]);
+ label_cell($mod['path']);
+ label_cell($mod['filename']);
+ label_cell(@$mod['acc_file']);
+ if ($is_mod)
+ {
+ label_cell(''); // not implemented (yet)
+ }
+ else
+ {
+ edit_button_cell("Edit".$i, _("Edit"));
+ }
+ delete_button_cell("Delete".$i, _("Delete"));
+ submit_js_confirm('Delete'.$i, _('You are about to delete this extension\nDo you want to continue?'));
+ end_row();
+ }
+
+ end_table(1);
+}
- label_cell(get_tab_title($mods[$i]['tab']));
- label_cell($mods[$i]['name']);
- label_cell($mods[$i]['path']);
- label_cell($mods[$i]['filename']);
- edit_link_cell("selected_id=" . $i);
- label_cell("" . _("Delete") . "");
+function company_extensions($id)
+{
+ global $table_style, $tabs;
+
+ start_table($table_style);
+
+ $th = array(_("Name"),_("Tab"), _("Link text"), _("Active"));
+
+ // get all available extensions and display
+ // with current status stored in company directory.
+
+ $mods = get_company_extensions();
+ $exts = get_company_extensions($id);
+ foreach($mods as $key => $ins) {
+ foreach($exts as $ext)
+ if ($ext['name'] == $ins['name']) {
+ $mods[$key]['active'] = @$ext['active'];
+ continue 2;
+ }
+ }
+ $mods = array_natsort($mods, null, 'name');
+ table_header($th);
+ $k = 0;
+ foreach($mods as $i => $mod)
+ {
+ alt_table_row_color($k);
+ label_cell($mod['name']);
+ label_cell($mod['type'] == 'module' ? $mod['title'] : $tabs[$mod['tab']]);
+ $ttl = access_string($mod['title']);
+ label_cell($ttl[0]);
+ check_cells(null, 'Active'.$i, @$mod['active'] ? 1:0,
+ false, false, "align='center'");
end_row();
}
- end_table();
+ end_table(1);
+ submit_center('Update', _('Update'), true, false, 'default');
}
//---------------------------------------------------------------------------------------------
-function display_module_edit($selected_id)
+function display_ext_edit($selected_id)
{
- global $installed_modules, $table_style2;
+ global $table_style2, $Mode;
- if ($selected_id != -1)
- $n = $selected_id;
- else
- $n = count($installed_modules);
-
- start_form(true, true);
- echo "
- ";
-
+ $extensions = get_company_extensions();
+
start_table($table_style2);
- if ($selected_id != -1)
+ if ($selected_id != -1 && $extensions[$selected_id]['type'] == 'plugin')
{
- $mod = $installed_modules[$selected_id];
- $_POST['tab'] = $mod['tab'];
- $_POST['name'] = $mod['name'];
- $_POST['path'] = $mod['path'];
- $_POST['filename'] = $mod['filename'];
+ if ($Mode == 'Edit') {
+ $mod = $extensions[$selected_id];
+ $_POST['tab'] = $mod['tab'];
+ $_POST['name'] = $mod['name'];
+ $_POST['title'] = $mod['title'];
+ $_POST['path'] = $mod['path'];
+ $_POST['filename'] = $mod['filename'];
+ $_POST['acc_file'] = @$mod['acc_file'];
+ hidden('filename', $_POST['filename']);
+ hidden('acc_file', $_POST['acc_file']);
+ }
hidden('selected_id', $selected_id);
- hidden('filename', $_POST['filename']);
- }
- tab_list_row(_("Menu Tab"), 'tab', null);
+ }
text_row_ex(_("Name"), 'name', 30);
text_row_ex(_("Folder"), 'path', 20);
+ tab_list_row(_("Menu Tab"), 'tab', null);
+ text_row_ex(_("Menu Link Text"), 'title', 30);
+
+ record_status_list_row(_("Default status"), 'active');
+
label_row(_("Module File"), "");
+ label_row(_("Access Levels Extensions"), "");
+ label_row(_("SQL File"), "");
end_table(0);
display_note(_("Select your module PHP file from your local harddisk."), 0, 1);
- echo "";
-
-
- end_form();
+ submit_add_or_update_center($selected_id == -1, '', 'both');
}
-
//---------------------------------------------------------------------------------------------
-
-if (isset($_GET['c']))
+if ($Mode=='ADD_ITEM' || $Mode == 'UPDATE_ITEM') {
+ if(handle_submit()) {
+ if ($selected_id != -1)
+ display_notification(_("Extension data has been updated."));
+ else
+ display_notification(_("Extension has been installed."));
+ $Mode = 'RESET';
+ }
+}
+if ($Mode == 'Delete')
{
- if ($_GET['c'] == 'df')
- {
- handle_delete();
+ handle_delete();
+ $Mode = 'RESET';
+}
+if (get_post('Update')) {
+ $exts = get_company_extensions();
+ foreach($exts as $i => $ext) {
+ $exts[$i]['active'] = check_value('Active'.$i);
}
+ write_extensions($exts, get_post('extset'));
+ if (get_post('extset') == user_company())
+ $installed_extensions = $exts;
+ display_notification(_('Current active extensions set has been saved.'));
+}
- if ($_GET['c'] == 'u')
- {
- if (handle_submit())
- {
- //meta_forward($_SERVER['PHP_SELF']);
- }
- }
+if ($Mode == 'RESET')
+{
+ $selected_id = -1;
+ unset($_POST);
}
//---------------------------------------------------------------------------------------------
+start_form(true);
+if (list_updated('extset'))
+ $Ajax->activate('_page_body');
-display_modules();
-
-hyperlink_no_params($_SERVER['PHP_SELF'], _("Create a new module"));
+echo "" . _('Extensions:') . " ";
+extset_list('extset', null, true);
+echo "
";
-display_module_edit($selected_id);
+$set = get_post('extset', -1);
+if ($set == -1) {
+ display_extensions();
+ display_ext_edit($selected_id);
+} else {
+ company_extensions($set);
+}
//---------------------------------------------------------------------------------------------
+end_form();
end_page();