sales/includes/db/sales_points_db.inc

   1 <?php
   2
   3 function add_sales_point($name, $location, $account, $cash, $credit)
   4 {
   5         $sql = "INSERT INTO ".TB_PREF."sales_pos (pos_name, pos_location, pos_account, cash_sale, credit_sale) VALUES (".db_escape($name)
   6                         . ",".db_escape($location).",".db_escape($account)
   7                         . ",$cash,$credit)";
   8         db_query($sql, "could not add point of sale");
   9 }
  10
  11 function update_sales_point($id, $name, $location, $account, $cash, $credit)
  12 {
  13
  14         $sql = "UPDATE ".TB_PREF."sales_pos SET pos_name=".db_escape($name)
  15                                 .",pos_location=".db_escape($location)
  16                                 .",pos_account=".db_escape($account)
  17                                 .",cash_sale =$cash"
  18                                 .",credit_sale =$credit"
  19                                 ." WHERE id = $id";
  20
  21         db_query($sql, "could not update sales type");
  22 }
  23
  24 function get_all_sales_points()
  25 {
  26         $sql = "SELECT pos.*, loc.location_name, acc.bank_account_name FROM "
  27                 .TB_PREF."sales_pos as pos,"
  28                 .TB_PREF."locations as loc,"
  29                 .TB_PREF."bank_accounts as acc"
  30                 ." WHERE pos.pos_location=loc.loc_code AND pos.pos_account=acc.id";
  31
  32         return db_query($sql, "could not get all POS definitions");
  33 }
  34
  35 function get_sales_point($id)
  36 {
  37         $sql = "SELECT pos.*, loc.location_name, acc.bank_account_name, acc.account_code FROM "
  38                 .TB_PREF."sales_pos as pos,"
  39                 .TB_PREF."locations as loc,"
  40                 .TB_PREF."bank_accounts as acc"
  41                 ." WHERE pos.id=$id AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.id";
  42
  43         $result = db_query($sql, "could not get POS definition");
  44
  45         return db_fetch($result);
  46 }
  47
  48 function get_sales_point_name($id)
  49 {
  50         $sql = "SELECT pos_name FROM ".TB_PREF."sales_pos WHERE id=$id";
  51
  52         $result = db_query($sql, "could not get POS name");
  53
  54         $row = db_fetch_row($result);
  55         return $row[0];
  56 }
  57
  58 function delete_sales_point($id)
  59 {
  60         $sql="DELETE FROM ".TB_PREF."sales_pos WHERE id=$id";
  61         db_query($sql,"The point of sale record could not be deleted");
  62 }
  63
  64 ?>