Company directory was not deleted after company removal.
[fa-stable.git] / admin / attachments.php
index fb5b5e68b1ee80c057a753079b12cdb270be5911..6febfb70c92c77b922204d9162178abc65472275 100644 (file)
@@ -1,16 +1,16 @@
 <?php
 /**********************************************************************
     Copyright (C) FrontAccounting, LLC.
-       Released under the terms of the GNU Affero General Public License,
-       AGPL, as published by the Free Software Foundation, either version 
-       of the License, or (at your option) any later version.
+       Released under the terms of the GNU General Public License, GPL, 
+       as published by the Free Software Foundation, either version 3 
+       of the License, or (at your option) any later version.
     This program is distributed in the hope that it will be useful,
     but WITHOUT ANY WARRANTY; without even the implied warranty of
     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
-    See the License here <http://www.gnu.org/licenses/agpl-3.0.html>.
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
 $path_to_root="..";
-$page_security = 8;
+$page_security = 'SA_ATTACHDOCUMENT';
 
 include_once($path_to_root . "/includes/session.inc");
 
@@ -18,36 +18,50 @@ include_once($path_to_root . "/includes/date_functions.inc");
 include_once($path_to_root . "/includes/ui.inc");
 include_once($path_to_root . "/includes/data_checks.inc");
 
+if (isset($_GET['vw']))
+       $view_id = $_GET['vw'];
+else
 $view_id = find_submit('view');
 if ($view_id != -1)
 {
        $row = get_attachment($view_id);
        if ($row['filename'] != "")
        {
-               $type = ($row['filetype']) ? $row['filetype'] : 'application/octet-stream';     
-       header("Content-type: ".$type);
-       header('Content-Length: '.$row['filesize']);
-       if ($type == 'application/octet-stream')
-               header('Content-Disposition: attachment; filename='.$row['filename']);
-       else
-                       header("Content-Disposition: inline");
-       echo $row["bin_data"];
-       exit();
+               if(in_ajax()) {
+                       $Ajax->popup($_SERVER['PHP_SELF'].'?vw='.$view_id);
+               } else {
+                       $type = ($row['filetype']) ? $row['filetype'] : 'application/octet-stream';     
+               header("Content-type: ".$type);
+               header('Content-Length: '.$row['filesize']);
+               if ($type == 'application/octet-stream')
+                       header('Content-Disposition: attachment; filename='.$row['filename']);
+               else
+                               header("Content-Disposition: inline");
+               echo file_get_contents($comp_path."/".user_company(). "/attachments/".$row['unique_name']);
+               exit();
+               }
        }       
 }
+if (isset($_GET['dl']))
+       $download_id = $_GET['dl'];
+else
+       $download_id = find_submit('download');
 
-$download_id = find_submit('download');
 if ($download_id != -1)
 {
        $row = get_attachment($download_id);
        if ($row['filename'] != "")
        {
-               $type = ($row['filetype']) ? $row['filetype'] : 'application/octet-stream';     
-       header("Content-type: ".$type);
-       header('Content-Length: '.$row['filesize']);
-       header('Content-Disposition: attachment; filename='.$row['filename']);
-       echo $row["bin_data"];
-       exit();
+               if(in_ajax()) {
+                       $Ajax->redirect($_SERVER['PHP_SELF'].'?dl='.$download_id);
+               } else {
+                       $type = ($row['filetype']) ? $row['filetype'] : 'application/octet-stream';     
+               header("Content-type: ".$type);
+               header('Content-Length: '.$row['filesize']);
+               header('Content-Disposition: attachment; filename='.$row['filename']);
+               echo file_get_contents($comp_path."/".user_company(). "/attachments/".$row['unique_name']);
+               exit();
+               }
        }       
 }
 
@@ -69,27 +83,37 @@ if ($Mode == 'ADD_ITEM' || $Mode == 'UPDATE_ITEM')
        {
                //$content = base64_encode(file_get_contents($_FILES['filename']['tmp_name']));
                $tmpname = $_FILES['filename']['tmp_name'];
-               $fp      = fopen($tmpname, 'r');
-               $content = fread($fp, filesize($tmpname));
-               $content = addslashes($content);
-               fclose($fp);
 
-               //$content = addslashes(file_get_contents($_FILES['filename']['tmp_name']));
+               $dir =  $comp_path."/".user_company(). "/attachments";
+               if (!file_exists($dir))
+               {
+                       mkdir ($dir,0777);
+                       $index_file = "<?php\nheader(\"Location: ../index.php\");\n?>";
+                       $fp = fopen($dir."/index.php", "w");
+                       fwrite($fp, $index_file);
+                       fclose($fp);
+               }
+               if ($Mode == 'UPDATE_ITEM' && file_exists($dir."/".$_POST['unique_name']))
+                       unlink($dir."/".$_POST['unique_name']);
+
+               $unique_name = uniqid('');
+               move_uploaded_file($tmpname, $dir."/".$unique_name);
+               //save the file
                $filename = $_FILES['filename']['name'];
                $filesize = $_FILES['filename']['size'];
                $filetype = $_FILES['filename']['type'];
        }
        else
        {
-               $content = $filename = $filetype = "";
+               $unique_name = $filename = $filetype = "";
                $filesize = 0;
        }
        $date = date2sql(Today());
        if ($Mode == 'ADD_ITEM')
        {
-               $sql = "INSERT INTO ".TB_PREF."attachments (type_no, trans_no, description, bin_data, filename,
+               $sql = "INSERT INTO ".TB_PREF."attachments (type_no, trans_no, description, filename, unique_name,
                        filesize, filetype, tran_date) VALUES (".$_POST['filterType'].",".$_POST['trans_no'].",".
-                       db_escape($_POST['description']).",'$content', '$filename', '$filesize', '$filetype', '$date')";
+                       db_escape($_POST['description']).", '$filename', '$unique_name', '$filesize', '$filetype', '$date')";
                db_query($sql, "Attachment could not be inserted");             
                display_notification(_("Attachment has been inserted.")); 
        }
@@ -101,8 +125,8 @@ if ($Mode == 'ADD_ITEM' || $Mode == 'UPDATE_ITEM')
                        description=".db_escape($_POST['description']).", ";
                if ($filename != "")
                {
-                       $sql .= "bin_data='$content',
-                       filename='$filename',
+                       $sql .= "filename='$filename',
+                       unique_name='$unique_name',
                        filesize='$filesize',
                        filetype='$filetype', ";
                }       
@@ -115,6 +139,10 @@ if ($Mode == 'ADD_ITEM' || $Mode == 'UPDATE_ITEM')
 
 if ($Mode == 'Delete')
 {
+       $row = get_attachment($selected_id);
+       $dir =  $comp_path."/".user_company(). "/attachments";
+       if (file_exists($dir."/".$row['unique_name']))
+               unlink($dir."/".$row['unique_name']);
        $sql = "DELETE FROM ".TB_PREF."attachments WHERE id = $selected_id";
        db_query($sql, "Could not delete attachment");
        display_notification(_("Attachment has been deleted.")); 
@@ -130,7 +158,7 @@ if ($Mode == 'RESET')
 
 function viewing_controls()
 {
-    start_form(false, true);
+    start_form();
 
     start_table("class='tablestyle_noborder'");
 
@@ -199,7 +227,7 @@ if (isset($_POST['filterType']))
 
 start_form(true);
 
-start_table("$table_style2 width=30%");
+start_table($table_style2);
 
 if ($selected_id != -1)
 {
@@ -209,6 +237,7 @@ if ($selected_id != -1)
                $_POST['trans_no']  = $row["trans_no"];
                $_POST['description']  = $row["description"];
                hidden('trans_no', $row['trans_no']);
+               hidden('unique_name', $row['unique_name']);
                label_row(_("Transaction #"), $row['trans_no']);
        }       
        hidden('selected_id', $selected_id);
@@ -224,7 +253,7 @@ end_table(1);
 if (isset($_POST['filterType']))
        hidden('filterType', $_POST['filterType']);
 
-submit_add_or_update_center($selected_id == -1, '', true);
+submit_add_or_update_center($selected_id == -1, '', 'both');
 
 end_form();