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 ('$account_code', $account_type, '$bank_account_name', '$bank_name', '$bank_account_number',
  10                 '$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='$bank_account_name', bank_name='$bank_name',
  22                 bank_account_number='$bank_account_number', bank_curr_code='$bank_curr_code',
  23                 bank_address='$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 ?>