gl/includes/db/gl_db_bank_accounts.inc

   1 <?php
   2
   3 //---------------------------------------------------------------------------------------------
   4
   5 function add_bank_account($account_code, $account_type, $bank_account_name, $bank_name, $bank_account_number,
   6         $bank_address, $bank_curr_code)
   7 {
   8         $sql = "INSERT INTO ".TB_PREF."bank_accounts (account_code, account_type, bank_account_name, bank_name, bank_account_number, bank_address, bank_curr_code)
   9                 VALUES (".db_escape($account_code).", $account_type, ".db_escape($bank_account_name).", ".db_escape($bank_name).", ".db_escape($bank_account_number).",
  10                 ".db_escape($bank_address).", '$bank_curr_code')";
  11
  12         db_query($sql, "could not add a bank account for $account_code");
  13 }
  14
  15 //---------------------------------------------------------------------------------------------
  16
  17 function update_bank_account($account_code, $account_type, $bank_account_name, $bank_name, $bank_account_number,
  18         $bank_address, $bank_curr_code)
  19 {
  20         $sql = "UPDATE ".TB_PREF."bank_accounts SET account_type = $account_type,
  21                 bank_account_name=".db_escape($bank_account_name).", bank_name=".db_escape($bank_name).",
  22                 bank_account_number=".db_escape($bank_account_number).", bank_curr_code='$bank_curr_code',
  23                 bank_address=".db_escape($bank_address)." WHERE account_code = '$account_code'";
  24
  25         db_query($sql, "could not update bank account for $account_code");
  26 }
  27
  28 //---------------------------------------------------------------------------------------------
  29
  30 function delete_bank_account($account_code)
  31 {
  32         $sql = "DELETE FROM ".TB_PREF."bank_accounts WHERE account_code='$account_code'";
  33
  34         db_query($sql,"could not delete bank account for $account_code");
  35 }
  36
  37
  38 //---------------------------------------------------------------------------------------------
  39
  40 function get_bank_account($account_code)
  41 {
  42         $sql = "SELECT * FROM ".TB_PREF."bank_accounts WHERE account_code='$account_code'";
  43
  44         $result = db_query($sql, "could not retreive bank account for $account_code");
  45
  46         return db_fetch($result);
  47 }
  48
  49 //---------------------------------------------------------------------------------------------
  50
  51 function add_quick_entry($description, $account, $deposit)
  52 {
  53         $sql = "INSERT INTO ".TB_PREF."quick_entries (description, account, deposit) VALUES
  54                 (".db_escape($description).", ".db_escape($account).", $deposit)";
  55
  56         db_query($sql, "could not insert quick entry for $description");
  57 }
  58
  59 //---------------------------------------------------------------------------------------------
  60
  61 function update_quick_entry($selected_id, $description, $account, $deposit)
  62 {
  63         $sql = "UPDATE ".TB_PREF."quick_entries SET description = ".db_escape($description).",
  64                 account=".db_escape($account).", deposit=$deposit
  65                 WHERE id = $selected_id";
  66
  67         db_query($sql, "could not update quick entry for $selected_id");
  68 }
  69
  70 //---------------------------------------------------------------------------------------------
  71
  72 function delete_quick_entry($selected_id)
  73 {
  74         $sql = "DELETE FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
  75
  76         db_query($sql,"could not delete quick entry $selected_id");
  77 }
  78
  79 //---------------------------------------------------------------------------------------------
  80
  81 function get_quick_entries($type=false)
  82 {
  83         $sql = "SELECT ".TB_PREF."quick_entries.*, ".TB_PREF."chart_master.account_name
  84                 FROM ".TB_PREF."quick_entries, ".TB_PREF."chart_master WHERE
  85                 ".TB_PREF."quick_entries.account = ".TB_PREF."chart_master.account_code";
  86         if ($type == "deposit")
  87                 $sql .= " AND deposit=1";
  88         elseif ($type == "payment")
  89                 $sql .= " AND deposit=0";
  90
  91         return db_query($sql, "could not retreive quick entries");
  92 }
  93
  94 //---------------------------------------------------------------------------------------------
  95
  96 function get_quick_entry($selected_id)
  97 {
  98         $sql = "SELECT * FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
  99
 100         $result = db_query($sql, "could not retreive quick entry for $selected_id");
 101
 102         return db_fetch($result);
 103 }
 104
 105 //---------------------------------------------------------------------------------------------
 106
 107 ?>