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 ?>