X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fmaintenance_db.inc;h=18bcf3aad4aec88c7dcd71e6a3649d4379e1b672;hb=c70823611ef71079c28542f4810cc50c183a8cd5;hp=a4f6157fb8ca85f1b9a142dfa1909c82c289c0fc;hpb=adee9be958cc89d23329807cc2dfbe76e647b83d;p=fa-stable.git

diff --git a/admin/db/maintenance_db.inc b/admin/db/maintenance_db.inc
index a4f6157f..18bcf3aa 100644
--- a/admin/db/maintenance_db.inc
+++ b/admin/db/maintenance_db.inc
@@ -10,6 +10,50 @@
     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
 
+/**
+ * @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_config_db($new = false)
 {
 	global $path_to_root, $def_coy, $db_connections, $tb_pref_counter;
@@ -76,6 +120,85 @@ function write_config_db($new = false)
 	return 0;
 }
 
+function write_extensions($extensions=null, $company = null)
+{
+	global $path_to_root, $installed_extensions;
+
+	if (!isset($extensions)) {
+		$extensions = $installed_extensions;
+	}
+	
+	$exts = array_natsort($extensions, 'name', 'name');
+	$extensions = $exts;
+
+	$n = count($exts);
+
+	$msg = "<?php\n\n";
+	if ($company != -1)
+		$msg .=
+"/* List of installed additional modules and plugins. If adding extensions at the beginning 
+	of the list, make sure it's index is set to 0 (it has ' 0 => ');
+	
+	'name' - name for identification purposes;
+	'type' - type of extension: 'module' or 'plugin'
+	'path' - FA root based installation path
+	'filename' - name of module menu file, or plugin filename; related to path.
+	'tab' - index of the module tab (new for module, or one of standard module names for plugin);
+	'title' - is the menu text (for plugin) or new tab name
+	'active' - current status of extension
+	'acc_file' - (optional) file name with \$security_areas/\$security_sections extensions; 
+		related to 'path'.
+*/\n\n";
+	else 
+		$msg .=
+"/*
+	Do not edit this file manually. This copy of global file is overwritten
+	by extensions editor.
+*/\n\n";
+
+	$msg .= "\$installed_extensions = array (\n";
+	if ($n > 0)
+	    $msg .= "\t0 => ";
+	for ($i = 0; $i < $n; $i++)
+	{
+		if ($i > 0)
+			$msg .= "\t\t";
+		$msg .= "array ( ";
+		$t = '';
+		foreach($extensions[$i] as $key => $val) {
+			$msg .= $t."'$key' => '$val',\n";
+			$t = "\t\t\t";
+		}
+		$msg .= "\t\t),\n";
+	}
+	$msg .= "\t);\n?>";
+
+	$filename = $path_to_root . (isset($company) ? '/company/'.$company : '')
+		.'/installed_extensions.php';
+
+	// Check if the file is writable first.
+	if (!$zp = @fopen($filename, 'w'))
+	{
+		display_error(sprintf(_("Cannot open the extension setup file '%s' for writing."),
+			 $filename));
+		return false;
+	}
+	else
+	{
+		if (!fwrite($zp, $msg))
+		{
+			display_error(sprintf(_("Cannot write to the extensions setup file '%s'."),
+				$filename));
+			fclose($zp);
+			return false;
+		}
+		// Close file
+		fclose($zp);
+	}
+	return true;
+}
+
+
 function db_create_db($connection)
 {
 	$db = mysql_connect($connection["host"] ,
@@ -298,6 +421,16 @@ function db_unzip($mode, $path)
     	return explode("\n", $file_data);
 }
 
+function db_backup($conn, $ext='no', $comm='', $tbpref = TB_PREF)
+{
+	if ($conn['tbpref'] != "")
+		$filename = $conn['dbname'] . "_" . $conn['tbpref'] . date("Ymd_Hi") . ".sql";
+	else
+		$filename = $conn['dbname'] . "_" . date("Ymd_Hi") . ".sql";
+
+	return db_export($conn, $filename, $ext, $comm, $tbpref);
+}
+
 // generates a dump of $db database
 // $drop and $zip tell if to include the drop table statement or dry to pack
 function db_export($conn, $filename, $zip='no', $comment='', $tbpref = TB_PREF)