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, $deposit, $bank_only)
  52 {
  53         $sql = "INSERT INTO ".TB_PREF."quick_entries (description, deposit, bank_only) VALUES
  54                 (".db_escape($description).", $deposit, $bank_only)";
  55
  56         db_query($sql, "could not insert quick entry for $description");
  57 }
  58
  59 //---------------------------------------------------------------------------------------------
  60
  61 function update_quick_entry($selected_id, $description, $deposit, $bank_only)
  62 {
  63         $sql = "UPDATE ".TB_PREF."quick_entries SET description = ".db_escape($description).",
  64                 deposit=$deposit, bank_only=$bank_only  WHERE id = $selected_id";
  65
  66         db_query($sql, "could not update quick entry for $selected_id");
  67 }
  68
  69 //---------------------------------------------------------------------------------------------
  70
  71 function delete_quick_entry($selected_id)
  72 {
  73         $sql = "DELETE FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
  74
  75         db_query($sql,"could not delete quick entry $selected_id");
  76 }
  77
  78 //---------------------------------------------------------------------------------------------
  79
  80 function add_quick_entry_line($qid, $account, $tax_acc, $pct, $amount, $dim, $dim2)
  81 {
  82         $sql = "INSERT INTO ".TB_PREF."quick_entry_lines (qid, account, tax_acc, pct, amount, dimension_id, dimension2_id) VALUES
  83                 ($qid, ".db_escape($account).", $tax_acc, $pct, $amount, $dim, $dim2)";
  84
  85         db_query($sql, "could not insert quick entry line for $qid");
  86 }
  87
  88 //---------------------------------------------------------------------------------------------
  89
  90 function update_quick_entry_line($selected_id, $qid, $account, $tax_acc, $pct, $amount, $dim, $dim2)
  91 {
  92         $sql = "UPDATE ".TB_PREF."quick_entry_lines     SET qid = $qid, account=".db_escape($account).",
  93                 tax_acc=$tax_acc, pct=$pct, amount=$amount, dimension_id=$dim, dimension2_id=$dim2
  94                 WHERE id = $selected_id";
  95
  96         db_query($sql, "could not update quick entry line for $selected_id");
  97 }
  98
  99 //---------------------------------------------------------------------------------------------
 100
 101 function delete_quick_entry_line($selected_id)
 102 {
 103         $sql = "DELETE FROM ".TB_PREF."quick_entry_lines WHERE id=$selected_id";
 104
 105         db_query($sql,"could not delete quick entry line $selected_id");
 106 }
 107 //---------------------------------------------------------------------------------------------
 108
 109 function get_quick_entries($deposit=null, $bank_only=null)
 110 {
 111         $where = false;
 112         $sql = "SELECT * FROM ".TB_PREF."quick_entries";
 113         if ($deposit != null)
 114         {
 115                 $sql .= " WHERE deposit=$deposit";
 116                 $where = true;
 117         }
 118         if ($bank_only != null)
 119         {
 120                 if ($where)
 121                         $sql .= " AND bank_only=$bank_only";
 122                 else
 123                         $sql .= " WHERE bank_only=$bank_only";
 124         }
 125         $sql .= " ORDER BY description";
 126
 127         return db_query($sql, "could not retreive quick entries");
 128 }
 129
 130 function get_quick_entry($selected_id)
 131 {
 132         $sql = "SELECT * FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
 133
 134         $result = db_query($sql, "could not retreive quick entry $selected_id");
 135
 136         return db_fetch($result);
 137 }
 138
 139 function get_quick_entry_lines($qid)
 140 {
 141         $sql = "SELECT ".TB_PREF."quick_entry_lines.*, ".TB_PREF."chart_master.account_name
 142                 FROM ".TB_PREF."quick_entry_lines, ".TB_PREF."chart_master
 143                 WHERE ".TB_PREF."quick_entry_lines.account = ".TB_PREF."chart_master.account_code
 144                 AND qid=$qid";
 145
 146         return db_query($sql, "could not retreive quick entries");
 147 }
 148
 149 function has_quick_entry_lines($qid)
 150 {
 151         $sql = "SELECT id FROM ".TB_PREF."quick_entry_lines WHERE qid=$qid";
 152
 153         $result = db_query($sql, "could not retreive quick entries");
 154         return db_num_rows($result) > 0;
 155 }
 156
 157 //---------------------------------------------------------------------------------------------
 158
 159 function get_quick_entry_line($selected_id)
 160 {
 161         $sql = "SELECT * FROM ".TB_PREF."quick_entry_lines WHERE id=$selected_id";
 162
 163         $result = db_query($sql, "could not retreive quick entry for $selected_id");
 164
 165         return db_fetch($result);
 166 }
 167
 168 //---------------------------------------------------------------------------------------------
 169
 170 ?>