5 include_once($path_to_root . "/includes/session.inc");
7 page(_("Install/Update Modules"));
9 include_once($path_to_root . "/includes/date_functions.inc");
10 include_once($path_to_root . "/admin/db/company_db.inc");
11 include_once($path_to_root . "/admin/db/maintenance_db.inc");
12 include_once($path_to_root . "/modules/installed_modules.php");
13 include_once($path_to_root . "/includes/ui.inc");
15 $tabs = array('orders', 'AP', 'stock', 'manuf', 'proj', 'GL', 'system');
16 $names = array(_("Sales"), _("Purchases"), _("Items and Inventory"), _("Manufacturing"),
17 _("Dimensions"), _("Banking and General Ledger"), _("Setup"));
19 //---------------------------------------------------------------------------------------------
21 if (isset($_GET['selected_id']))
23 $selected_id = $_GET['selected_id'];
25 elseif (isset($_POST['selected_id']))
27 $selected_id = $_POST['selected_id'];
32 //---------------------------------------------------------------------------------------------
34 function get_tab_title($tab)
37 for ($i = 0; $i < count($tabs); $i++)
39 if ($tabs[$i] == $tab)
45 function tab_list_row($label, $name, $selected)
50 echo "<td>$label</td>\n";
51 if ($selected == null)
52 $selected = (!isset($_POST[$name]) ? "orders" : $_POST[$name]);
53 echo "<td><select name='$name'>";
54 for ($i = 0; $i < count($tabs); $i++)
56 if ($selected == $tabs[$i])
57 echo "<option selected value='".$tabs[$i]."'>" . $names[$i]. "</option>\n";
59 echo "<option value='".$tabs[$i]."'>" . $names[$i]. "</option>\n";
61 echo "</select></td>\n";
65 //---------------------------------------------------------------------------------------------
73 * @return Returns the array sorted as required
74 * @param $aryData Array containing data to sort
75 * @param $strIndex name of column to use as an index
76 * @param $strSortBy Column to sort the array by
77 * @param $strSortType String containing either asc or desc [default to asc]
78 * @desc Naturally sorts an array using by the column $strSortBy
80 function array_natsort($aryData, $strIndex, $strSortBy, $strSortType=false)
82 // if the parameters are invalid
83 if (!is_array($aryData) || !$strIndex || !$strSortBy)
87 // create our temporary arrays
88 $arySort = $aryResult = array();
90 // loop through the array
91 foreach ($aryData as $aryRow)
92 // set up the value in the array
93 $arySort[$aryRow[$strIndex]] = $aryRow[$strSortBy];
95 // apply the natural sort
98 // if the sort type is descending
99 if ($strSortType=="desc")
103 // loop through the sorted and original data
104 foreach ($arySort as $arySortKey => $arySorted)
105 foreach ($aryData as $aryOriginal)
106 // if the key matches
107 if ($aryOriginal[$strIndex]==$arySortKey)
108 // add it to the output array
109 array_push($aryResult, $aryOriginal);
115 function write_modules()
117 global $path_to_root, $installed_modules;
119 $mods = array_natsort($installed_modules, 'tab', 'tab');
120 $installed_modules = $mods;
121 //reset($installed_languages);
122 $n = count($installed_modules);
125 $msg .= "/*****************************************************************\n";
126 $msg .= "External modules for FrontAccounting\n";
127 $msg .= "******************************************************************/\n";
130 $msg .= "\$installed_modules = array (\n";
132 for ($i = 0; $i < $n; $i++)
135 $msg .= "\t\tarray ";
138 $msg .= "('tab' => '" . $installed_modules[$i]['tab'] . "', ";
139 $msg .= "'name' => '" . $installed_modules[$i]['name'] . "', ";
140 $msg .= "'path' => '" . $installed_modules[$i]['path'] . "', ";
141 $msg .= "'filename' => '" . $installed_modules[$i]['filename'] . "'";
146 $filename = $path_to_root . "/modules/installed_modules.php";
147 // Check if the file exists and is writable first.
148 if (file_exists($filename) && is_writable($filename))
150 if (!$zp = fopen($filename, 'w'))
152 display_error(_("Cannot open the modules file - ") . $filename);
157 if (!fwrite($zp, $msg))
159 display_error(_("Cannot write to the modules file - ") . $filename);
169 display_error(_("The modules file ") . $filename . _(" is not writable. Change its permissions so it is, then re-run the operation."));
175 //---------------------------------------------------------------------------------------------
177 function handle_submit()
179 global $path_to_root, $installed_modules, $db_connections;
186 $installed_modules[$id]['tab'] = $_POST['tab'];
187 $installed_modules[$id]['name'] = $_POST['name'];
188 $installed_modules[$id]['path'] = $_POST['path'];
189 $directory = $path_to_root . "/modules/" . $_POST['path'];
190 if (!file_exists($directory))
194 if (is_uploaded_file($_FILES['uploadfile']['tmp_name']))
196 $installed_modules[$id]['filename'] = $_FILES['uploadfile']['name'];
197 $file1 = $_FILES['uploadfile']['tmp_name'];
198 $file2 = $directory . "/".$_FILES['uploadfile']['name'];
199 if (file_exists($file2))
201 move_uploaded_file($file1, $file2);
204 $installed_modules[$id]['filename'] = $_POST['filename'];
205 if (is_uploaded_file($_FILES['uploadfile2']['tmp_name']))
207 $file1 = $_FILES['uploadfile2']['tmp_name'];
208 $file2 = $directory . "/".$_FILES['uploadfile2']['name'];
209 if (file_exists($file2))
211 move_uploaded_file($file1, $file2);
212 $db_name = $_SESSION["wa_current_user"]->company;
213 db_import($file2, $db_connections[$db_name]);
215 if (!write_modules())
220 //---------------------------------------------------------------------------------------------
222 function handle_delete()
224 global $path_to_root, $installed_modules;
228 $path = $installed_modules[$id]['path'];
229 $filename = "$path_to_root/modules/$path";
230 if ($h = opendir($filename))
232 while (($file = readdir($h)) !== false)
234 if (is_file("$filename/$file"))
235 unlink("$filename/$file");
241 unset($installed_modules[$id]);
242 $mods = array_values($installed_modules);
243 $installed_modules = $mods;
245 if (!write_modules())
247 meta_forward($_SERVER['PHP_SELF']);
250 //---------------------------------------------------------------------------------------------
252 function display_modules()
254 global $table_style, $installed_modules;
257 <script language='javascript'>
258 function deleteModule(id, name) {
259 if (!confirm('" . _("Are you sure you want to delete module: ") . "'+name))
261 document.location.replace('inst_module.php?c=df&id='+id)
264 start_table($table_style);
265 $th = array(_("Tab"), _("Name"), _("Folder"), _("Filename"), "", "");
269 $mods = $installed_modules;
271 for ($i = 0; $i < $n; $i++)
273 alt_table_row_color($k);
275 label_cell(get_tab_title($mods[$i]['tab']));
276 label_cell($mods[$i]['name']);
277 label_cell($mods[$i]['path']);
278 label_cell($mods[$i]['filename']);
279 edit_link_cell("selected_id=" . $i);
280 label_cell("<a href='javascript:deleteModule(".$i.", \"" . $mods[$i]['name'] . "\")'>" . _("Delete") . "</a>");
287 //---------------------------------------------------------------------------------------------
289 function display_module_edit($selected_id)
291 global $installed_modules, $table_style2;
293 if ($selected_id != -1)
296 $n = count($installed_modules);
298 start_form(true, true);
301 <script language='javascript'>
302 function updateModule() {
303 document.forms[0].action='inst_module.php?c=u&id=" . $n . "'
304 document.forms[0].submit()
308 start_table($table_style2);
310 if ($selected_id != -1)
312 $mod = $installed_modules[$selected_id];
313 $_POST['tab'] = $mod['tab'];
314 $_POST['name'] = $mod['name'];
315 $_POST['path'] = $mod['path'];
316 $_POST['filename'] = $mod['filename'];
317 hidden('selected_id', $selected_id);
318 hidden('filename', $_POST['filename']);
320 tab_list_row(_("Menu Tab"), 'tab', null);
321 text_row_ex(_("Name"), 'name', 30);
322 text_row_ex(_("Folder"), 'path', 20);
324 label_row(_("Module File"), "<input name='uploadfile' type='file'>");
325 label_row(_("SQL File"), "<input name='uploadfile2' type='file'>");
328 display_note(_("Select your module PHP file from your local harddisk."), 0, 1);
329 echo "<center><input onclick='javascript:updateModule()' type='button' style='width:150' value='". _("Save"). "'>";
336 //---------------------------------------------------------------------------------------------
338 if (isset($_GET['c']))
340 if ($_GET['c'] == 'df')
345 if ($_GET['c'] == 'u')
349 //meta_forward($_SERVER['PHP_SELF']);
354 //---------------------------------------------------------------------------------------------
358 hyperlink_no_params($_SERVER['PHP_SELF'], _("Create a new module"));
360 display_module_edit($selected_id);
362 //---------------------------------------------------------------------------------------------