MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
-$page_security = 20;
+$page_security = 'SA_CREATEMODULES';
$path_to_root="..";
include_once($path_to_root . "/includes/session.inc");
-page(_("Install/Update Modules"));
+page(_($help_context = "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 . "/admin/db/maintenance_db.inc");
-include_once($path_to_root . "/modules/installed_modules.php");
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"));
+simple_page_mode(true);
//---------------------------------------------------------------------------------------------
-
-if (isset($_GET['selected_id']))
-{
- $selected_id = $_GET['selected_id'];
-}
-elseif (isset($_POST['selected_id']))
-{
- $selected_id = $_POST['selected_id'];
-}
-else
- $selected_id = -1;
-
-//---------------------------------------------------------------------------------------------
-
-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 "<tr>\n";
- if ($label != null)
- echo "<td>$label</td>\n";
- if ($selected == null)
- $selected = (!isset($_POST[$name]) ? "orders" : $_POST[$name]);
- echo "<td><select name='$name'>";
- for ($i = 0; $i < count($tabs); $i++)
+ // update per company files
+ $cnt = count($db_connections);
+ for($i = 0; $i < $cnt; $i++)
{
- if ($selected == $tabs[$i])
- echo "<option selected value='".$tabs[$i]."'>" . $names[$i]. "</option>\n";
- else
- echo "<option value='".$tabs[$i]."'>" . $names[$i]. "</option>\n";
+ $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;
+ }
}
- echo "</select></td>\n";
- echo "</tr>\n";
-}
-
-//---------------------------------------------------------------------------------------------
-
-function check_data()
-{
- if ($_POST['name'] == "" || $_POST['path'] == "")
- 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 = "<?php\n\n";
-
- $msg .= "/*****************************************************************\n";
- $msg .= "External modules for FrontAccounting\n";
- $msg .= "******************************************************************/\n";
- $msg .= "\n\n";
-
- $msg .= "\$installed_modules = array (\n";
- if ($n > 0)
- $msg .= "\t0 => ";
- 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;
}
function handle_submit()
{
- global $path_to_root, $installed_modules, $db_connections;
+ 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;
- $id = $_GET['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;
+ }
- $installed_modules[$id]['tab'] = $_POST['tab'];
- $installed_modules[$id]['name'] = $_POST['name'];
- $installed_modules[$id]['path'] = $_POST['path'];
+ $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');
+
+ // Currently we support only plugin extensions here.
+ $extensions[$id]['type'] = 'plugin';
$directory = $path_to_root . "/modules/" . $_POST['path'];
if (!file_exists($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))
move_uploaded_file($file1, $file2);
}
else
- $installed_modules[$id]['filename'] = $_POST['filename'];
+ $extensions[$id]['filename'] = get_post('filename');
if (is_uploaded_file($_FILES['uploadfile2']['tmp_name']))
{
$file1 = $_FILES['uploadfile2']['tmp_name'];
$db_name = $_SESSION["wa_current_user"]->company;
db_import($file2, $db_connections[$db_name]);
}
- if (!write_modules())
+
+ 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 "
- <script language='javascript'>
- function deleteModule(id, name) {
- if (!confirm('" . _("Are you sure you want to delete module: ") . "'+name))
- return
- document.location.replace('inst_module.php?c=df&id='+id)
- }
- </script>";
+ global $table_style;
+
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(get_tab_title($mods[$i]['tab']));
- label_cell($mods[$i]['name']);
- label_cell($mods[$i]['path']);
- label_cell($mods[$i]['filename']);
- $edit = _("Edit");
- $delete = _("Delete");
- if (user_graphic_links())
+ label_cell($mod['name']);
+ label_cell( $is_mod ?
+ $mod['title'] : access_string($_SESSION['App']->applications[$mod['tab']]->name, true));
+ $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)
{
- $edit = set_icon(ICON_EDIT, $edit);
- $delete = set_icon(ICON_DELETE, $delete);
+ label_cell(''); // not implemented (yet)
}
- label_cell("<a href='" . $_SERVER['PHP_SELF']. "?selected_id=$i'>$edit</a>");
- label_cell("<a href='javascript:deleteModule(".$i.", \"" . $mods[$i]['name'] . "\")'>$delete</a>");
+ 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();
+ end_table(1);
+}
+
+function company_extensions($id)
+{
+ global $table_style;
+
+ 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'] : access_string($_SESSION['App']->applications[$mod['tab']]->name, true));
+ $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(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 "
- <script language='javascript'>
- function updateModule() {
- document.forms[0].action='inst_module.php?c=u&id=" . $n . "'
- document.forms[0].submit()
- }
- </script>";
+ $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, true);
+ text_row_ex(_("Menu Link Text"), 'title', 30);
+
+ record_status_list_row(_("Default status"), 'active');
+
label_row(_("Module File"), "<input name='uploadfile' type='file'>");
+ label_row(_("Access Levels Extensions"), "<input name='uploadfile3' type='file'>");
label_row(_("SQL File"), "<input name='uploadfile2' type='file'>");
end_table(0);
display_note(_("Select your module PHP file from your local harddisk."), 0, 1);
- echo "<center><input onclick='javascript:updateModule()' type='button' style='width:150px' value='". _("Save"). "'></center>";
-
-
- 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 "<center>" . _('Extensions:') . " ";
+echo extset_list('extset', null, true);
+echo "</center><br>";
-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();
projects / fa-stable.git / blobdiff