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, $type, $base_amount, $base_desc)
  65 {
  66         $sql = "INSERT INTO ".TB_PREF."quick_entries (description, type, base_amount, base_desc)
  67         VALUES (".db_escape($description).", $type, "
  68                 .db_escape($base_amount).", ".db_escape($base_desc).")";
  69
  70         db_query($sql, "could not insert quick entry for $description");
  71 }
  72
  73 //---------------------------------------------------------------------------------------------
  74
  75 function update_quick_entry($selected_id, $description, $type, $base_amount, $base_desc)
  76 {
  77         $sql = "UPDATE ".TB_PREF."quick_entries SET description = ".db_escape($description).",
  78                 type=$type, base_amount=".db_escape($base_amount).", base_desc=".db_escape($base_desc)."
  79                 WHERE id = $selected_id";
  80
  81         db_query($sql, "could not update quick entry for $selected_id");
  82 }
  83
  84 //---------------------------------------------------------------------------------------------
  85
  86 function delete_quick_entry($selected_id)
  87 {
  88         $sql = "DELETE FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
  89
  90         db_query($sql,"could not delete quick entry $selected_id");
  91 }
  92
  93 //---------------------------------------------------------------------------------------------
  94
  95 function add_quick_entry_line($qid, $action, $dest_id, $amount, $dim, $dim2)
  96 {
  97         $sql = "INSERT INTO ".TB_PREF."quick_entry_lines
  98                 (qid, action, dest_id, amount, dimension_id, dimension2_id)
  99         VALUES
 100                 ($qid, ".db_escape($action).",".db_escape($dest_id).",
 101                         $amount, $dim, $dim2)";
 102
 103         db_query($sql, "could not insert quick entry line for $qid");
 104 }
 105
 106 //---------------------------------------------------------------------------------------------
 107
 108 function update_quick_entry_line($selected_id, $qid, $action, $dest_id, $amount, $dim, $dim2)
 109 {
 110         $sql = "UPDATE ".TB_PREF."quick_entry_lines     SET qid = $qid, action=".db_escape($action).",
 111                 dest_id=".db_escape($dest_id).", amount=$amount, dimension_id=$dim, dimension2_id=$dim2
 112                 WHERE id = $selected_id";
 113
 114         db_query($sql, "could not update quick entry line for $selected_id");
 115 }
 116
 117 //---------------------------------------------------------------------------------------------
 118
 119 function delete_quick_entry_line($selected_id)
 120 {
 121         $sql = "DELETE FROM ".TB_PREF."quick_entry_lines WHERE id=$selected_id";
 122
 123         db_query($sql,"could not delete quick entry line $selected_id");
 124 }
 125 //---------------------------------------------------------------------------------------------
 126
 127
 128 function has_quick_entries($type=null)
 129 {
 130         $sql = "SELECT id FROM ".TB_PREF."quick_entries";
 131         if ($type != null)
 132                 $sql .= " WHERE type=$type";
 133
 134         $result = db_query($sql, "could not retreive quick entries");
 135         return db_num_rows($result) > 0;
 136 }
 137
 138 function get_quick_entries($type = null)
 139 {
 140         $sql = "SELECT * FROM ".TB_PREF."quick_entries";
 141         if ($type != null)
 142                 $sql .= " WHERE type=$type";
 143         $sql .= " ORDER BY description";
 144
 145         return db_query($sql, "could not retreive quick entries");
 146 }
 147
 148 function get_quick_entry($selected_id)
 149 {
 150         $sql = "SELECT * FROM ".TB_PREF."quick_entries WHERE id=$selected_id";
 151
 152         $result = db_query($sql, "could not retreive quick entry $selected_id");
 153
 154         return db_fetch($result);
 155 }
 156
 157 function get_quick_entry_lines($qid)
 158 {
 159         $sql = "SELECT ".TB_PREF."quick_entry_lines.*, ".TB_PREF."chart_master.account_name,
 160                         ".TB_PREF."item_tax_types.name as tax_name
 161                 FROM ".TB_PREF."quick_entry_lines
 162                 LEFT JOIN ".TB_PREF."chart_master ON
 163                         ".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."chart_master.account_code
 164                 LEFT JOIN ".TB_PREF."item_tax_types ON
 165                         ".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."item_tax_types.id
 166                 WHERE
 167                         qid=$qid
 168                 ORDER by id";
 169
 170         return db_query($sql, "could not retreive quick entries");
 171 }
 172
 173 function has_quick_entry_lines($qid)
 174 {
 175         $sql = "SELECT id FROM ".TB_PREF."quick_entry_lines WHERE qid=$qid";
 176
 177         $result = db_query($sql, "could not retreive quick entries");
 178         return db_num_rows($result) > 0;
 179 }
 180
 181 //---------------------------------------------------------------------------------------------
 182
 183 function get_quick_entry_line($selected_id)
 184 {
 185         $sql = "SELECT * FROM ".TB_PREF."quick_entry_lines WHERE id=$selected_id";
 186
 187         $result = db_query($sql, "could not retreive quick entry for $selected_id");
 188
 189         return db_fetch($result);
 190 }
 191
 192 //---------------------------------------------------------------------------------------------
 193
 194 ?>