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($id, $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                 account_code=".db_escape($account_code).",
  22                 bank_account_name=".db_escape($bank_account_name).", bank_name=".db_escape($bank_name).",
  23                 bank_account_number=".db_escape($bank_account_number).", bank_curr_code='$bank_curr_code',
  24                 bank_address=".db_escape($bank_address)." WHERE id = '$id'";
  25
  26         db_query($sql, "could not update bank account for $account_code");
  27 }
  28
  29 //---------------------------------------------------------------------------------------------
  30
  31 function delete_bank_account($id)
  32 {
  33         $sql = "DELETE FROM ".TB_PREF."bank_accounts WHERE id='$id'";
  34
  35         db_query($sql,"could not delete bank account for $id");
  36 }
  37
  38
  39 //---------------------------------------------------------------------------------------------
  40
  41 function get_bank_account($id)
  42 {
  43         $sql = "SELECT * FROM ".TB_PREF."bank_accounts WHERE id='$id'";
  44
  45         $result = db_query($sql, "could not retreive bank account for $id");
  46
  47         return db_fetch($result);
  48 }
  49
  50 //---------------------------------------------------------------------------------------------
  51 function get_bank_gl_account($id)
  52 {
  53         $sql = "SELECT account_code FROM ".TB_PREF."bank_accounts WHERE id='$id'";
  54
  55         $result = db_query($sql, "could not retreive bank account for $id");
  56
  57         $bank_account = db_fetch($result);
  58
  59         return $bank_account['account_code'];
  60 }
  61
  62 //---------------------------------------------------------------------------------------------
  63
  64 function add_quick_entry($description, $deposit, $bank_only)
  65 {
  66         $sql = "INSERT INTO ".TB_PREF."quick_entries (description, deposit, bank_only) VALUES
  67                 (".db_escape($description).", $deposit, $bank_only)";
  68
  69         db_query($sql, "could not insert quick entry for $description");
  70 }
  71
  72 //---------------------------------------------------------------------------------------------
  73
  74 function update_quick_entry($selected_id, $description, $deposit, $bank_only)
  75 {
  76         $sql = "UPDATE ".TB_PREF."quick_entries SET description = ".db_escape($description).",
  77                 deposit=$deposit, bank_only=$bank_only  WHERE id = $selected_id";
  78
  79         db_query($sql, "could not update quick entry for $selected_id");
  80 }
  81
  82 //---------------------------------------------------------------------------------------------
  83
  84 function delete_quick_entry($selected_id)
  85 {
  86         $sql = "DELETE FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
  87
  88         db_query($sql,"could not delete quick entry $selected_id");
  89 }
  90
  91 //---------------------------------------------------------------------------------------------
  92
  93 function add_quick_entry_line($qid, $account, $tax_acc, $pct, $amount, $dim, $dim2)
  94 {
  95         $sql = "INSERT INTO ".TB_PREF."quick_entry_lines (qid, account, tax_acc, pct, amount, dimension_id, dimension2_id) VALUES
  96                 ($qid, ".db_escape($account).", $tax_acc, $pct, $amount, $dim, $dim2)";
  97
  98         db_query($sql, "could not insert quick entry line for $qid");
  99 }
 100
 101 //---------------------------------------------------------------------------------------------
 102
 103 function update_quick_entry_line($selected_id, $qid, $account, $tax_acc, $pct, $amount, $dim, $dim2)
 104 {
 105         $sql = "UPDATE ".TB_PREF."quick_entry_lines     SET qid = $qid, account=".db_escape($account).",
 106                 tax_acc=$tax_acc, pct=$pct, amount=$amount, dimension_id=$dim, dimension2_id=$dim2
 107                 WHERE id = $selected_id";
 108
 109         db_query($sql, "could not update quick entry line for $selected_id");
 110 }
 111
 112 //---------------------------------------------------------------------------------------------
 113
 114 function delete_quick_entry_line($selected_id)
 115 {
 116         $sql = "DELETE FROM ".TB_PREF."quick_entry_lines WHERE id=$selected_id";
 117
 118         db_query($sql,"could not delete quick entry line $selected_id");
 119 }
 120 //---------------------------------------------------------------------------------------------
 121
 122
 123 function has_quick_entries($deposit=-1, $bank_only=-1)
 124 {
 125         $where = false;
 126         $sql = "SELECT id FROM ".TB_PREF."quick_entries";
 127         if ($deposit != -1)
 128         {
 129                 $sql .= " WHERE deposit=$deposit";
 130                 $where = true;
 131         }
 132         if ($bank_only != -1)
 133         {
 134                 if ($where)
 135                         $sql .= " AND bank_only=$bank_only";
 136                 else
 137                         $sql .= " WHERE bank_only=$bank_only";
 138         }
 139
 140         $result = db_query($sql, "could not retreive quick entries");
 141         return db_num_rows($result) > 0;
 142 }
 143
 144 function get_quick_entries($deposit=-1, $bank_only=-1)
 145 {
 146         $where = false;
 147         $sql = "SELECT * FROM ".TB_PREF."quick_entries";
 148         if ($deposit != -1)
 149         {
 150                 $sql .= " WHERE deposit=$deposit";
 151                 $where = true;
 152         }
 153         if ($bank_only != -1)
 154         {
 155                 if ($where)
 156                         $sql .= " AND bank_only=$bank_only";
 157                 else
 158                         $sql .= " WHERE bank_only=$bank_only";
 159         }
 160         $sql .= " ORDER BY description";
 161
 162         return db_query($sql, "could not retreive quick entries");
 163 }
 164
 165 function get_quick_entry($selected_id)
 166 {
 167         $sql = "SELECT * FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
 168
 169         $result = db_query($sql, "could not retreive quick entry $selected_id");
 170
 171         return db_fetch($result);
 172 }
 173
 174 function get_quick_entry_lines($qid)
 175 {
 176         $sql = "SELECT ".TB_PREF."quick_entry_lines.*, ".TB_PREF."chart_master.account_name
 177                 FROM ".TB_PREF."quick_entry_lines, ".TB_PREF."chart_master
 178                 WHERE ".TB_PREF."quick_entry_lines.account = ".TB_PREF."chart_master.account_code
 179                 AND qid=$qid";
 180
 181         return db_query($sql, "could not retreive quick entries");
 182 }
 183
 184 function has_quick_entry_lines($qid)
 185 {
 186         $sql = "SELECT id FROM ".TB_PREF."quick_entry_lines WHERE qid=$qid";
 187
 188         $result = db_query($sql, "could not retreive quick entries");
 189         return db_num_rows($result) > 0;
 190 }
 191
 192 //---------------------------------------------------------------------------------------------
 193
 194 function get_quick_entry_line($selected_id)
 195 {
 196         $sql = "SELECT * FROM ".TB_PREF."quick_entry_lines WHERE id=$selected_id";
 197
 198         $result = db_query($sql, "could not retreive quick entry for $selected_id");
 199
 200         return db_fetch($result);
 201 }
 202
 203 //---------------------------------------------------------------------------------------------
 204
 205 ?>