admin/db/attachments_db.inc

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12
  13 //----------------------------------------------------------------------------------------
  14
  15 function add_attachment($filterType, $trans_no, $description,
  16         $filename, $unique_name, $filesize, $filetype)
  17 {
  18         $date = date2sql(Today());
  19         $sql = "INSERT INTO ".TB_PREF."attachments (type_no, trans_no, description, filename, unique_name,
  20                 filesize, filetype, tran_date) VALUES (".db_escape($filterType).","
  21                 .db_escape($trans_no).",".db_escape($description).", "
  22                 .db_escape($filename).", ".db_escape($unique_name).", ".db_escape($filesize)
  23                 .", ".db_escape($filetype).", '$date')";
  24         db_query($sql, "Attachment could not be inserted");
  25 }
  26 //----------------------------------------------------------------------------------------
  27
  28 function update_attachment($selected_id, $filterType, $trans_no, $description,
  29         $filename, $unique_name, $filesize, $filetype)
  30 {
  31         $date = date2sql(Today());
  32         $sql = "UPDATE ".TB_PREF."attachments SET
  33                 type_no=".db_escape($filterType).",
  34                 trans_no=".db_escape($trans_no).",
  35                 description=".db_escape($description).", ";
  36         if ($filename != "")
  37         {
  38                 $sql .= "filename=".db_escape($filename).",
  39                 unique_name=".db_escape($unique_name).",
  40                 filesize=".db_escape($filesize).",
  41                 filetype=".db_escape($filetype);
  42         }
  43         $sql .= "tran_date='$date' WHERE id=".db_escape($selected_id);
  44         db_query($sql, "Attachment could not be updated");
  45 }
  46
  47 //----------------------------------------------------------------------------------------
  48
  49 function delete_attachment($id)
  50 {
  51         $sql = "DELETE FROM ".TB_PREF."attachments WHERE id = ".db_escape($id);
  52         db_query($sql, "Could not delete attachment");
  53 }
  54 //----------------------------------------------------------------------------------------
  55
  56 function get_attached_documents($type)
  57 {
  58         $sql = "SELECT * FROM ".TB_PREF."attachments WHERE type_no=".db_escape($type)
  59         ." ORDER BY trans_no";
  60         return db_query($sql, "Could not retrieve attachments");
  61 }
  62
  63 function get_attachment($id)
  64 {
  65         $sql = "SELECT * FROM ".TB_PREF."attachments WHERE id=".db_escape($id);
  66         $result = db_query($sql, "Could not retrieve attachments");
  67         return db_fetch($result);
  68 }
  69
  70
  71 ?>