sales/includes/db/cust_trans_details_db.inc

   1 <?php
   2
   3 //----------------------------------------------------------------------------------------
   4
   5 function add_customer_trans_detail_item_base($debtor_trans_type, $debtor_trans_no, $stock_id, $description, $quantity,
   6         $unit_price, $unit_tax, $discount_percent, $standard_cost)
   7 {
   8         $sql = "INSERT INTO ".TB_PREF."debtor_trans_details (debtor_trans_no, debtor_trans_type, stock_id, description, quantity, unit_price, unit_tax, discount_percent, standard_cost)
   9                 VALUES ($debtor_trans_no, $debtor_trans_type, '$stock_id', '$description', $quantity, $unit_price, $unit_tax, $discount_percent, $standard_cost)";
  10
  11         db_query($sql, "The debtor transaction detail could not be added");
  12 }
  13
  14 //----------------------------------------------------------------------------------------
  15
  16 function get_customer_trans_details($debtor_trans_type, $debtor_trans_no)
  17 {
  18         $sql = "SELECT ".TB_PREF."debtor_trans_details.*, ".TB_PREF."debtor_trans_details.unit_price+".TB_PREF."debtor_trans_details.unit_tax AS FullUnitPrice,
  19                 ".TB_PREF."debtor_trans_details.description As StockDescription,
  20                 ".TB_PREF."stock_master.units
  21                 FROM ".TB_PREF."debtor_trans_details,".TB_PREF."stock_master
  22                 WHERE debtor_trans_no=$debtor_trans_no
  23                 AND debtor_trans_type=$debtor_trans_type
  24                 AND ".TB_PREF."stock_master.stock_id=".TB_PREF."debtor_trans_details.stock_id";
  25
  26         return db_query($sql, "The debtor transaction detail could not be queried");
  27 }
  28
  29 //----------------------------------------------------------------------------------------
  30
  31 function void_customer_trans_details($type, $type_no)
  32 {
  33         $sql = "UPDATE ".TB_PREF."debtor_trans_details SET quantity=0, unit_price=0,
  34                 unit_tax=0, discount_percent=0, standard_cost=0
  35                 WHERE debtor_trans_no=$type_no
  36                 AND debtor_trans_type=$type";
  37
  38         db_query($sql, "The debtor transaction details could not be voided");
  39
  40         // clear the stock move items
  41         void_stock_move($type, $type_no);
  42 }
  43
  44 //----------------------------------------------------------------------------------------
  45
  46 function add_customer_trans_detail_item($debtor_trans_type, $debtor_trans_no, $stock_id, $description,
  47         $Location, $date_, $quantity, $unit_price, $unit_tax, $discount_percent,
  48         $reference,     $std_cost)
  49 {
  50         add_customer_trans_detail_item_base($debtor_trans_type, $debtor_trans_no, $stock_id, $description,
  51                 $quantity, $unit_price, $unit_tax, $discount_percent, $std_cost);
  52
  53         add_stock_move_customer($debtor_trans_type, $stock_id, $debtor_trans_no, $Location,
  54                 $date_, $reference, $quantity, $std_cost, 1, $unit_price+$unit_tax, $discount_percent);
  55
  56         return $std_cost;
  57 }
  58
  59 //----------------------------------------------------------------------------------------
  60
  61 function add_customer_trans_detail_item_writeoff($debtor_trans_type, $debtor_trans_no, $stock_id, $description,
  62         $Location, $date_, $quantity, $unit_price, $unit_tax, $discount_percent,
  63         $reference, $std_cost)
  64 {
  65         $retCost = add_customer_trans_detail_item($debtor_trans_type, $debtor_trans_no, $stock_id, $description,
  66                 $Location, $date_, $quantity, $unit_price, $unit_tax, $discount_percent,
  67                 $reference,     $std_cost);
  68
  69         $reference = _("Write off") . " " . $reference;
  70
  71         add_stock_move_customer($debtor_trans_type, $stock_id, $debtor_trans_no, $Location,
  72                 $date_, $reference, -$quantity, $std_cost, 0, $unit_price+$unit_tax, $discount_percent);
  73
  74         return $retCost;
  75 }
  76
  77 //----------------------------------------------------------------------------------------
  78
  79 function add_customer_trans_tax_detail_item($debtor_trans_type, $debtor_trans_no,
  80         $tax_type_id, $rate, $included_in_price, $amount)
  81 {
  82         $sql = "INSERT INTO ".TB_PREF."debtor_trans_tax_details (debtor_trans_no, debtor_trans_type, tax_type_id, rate, included_in_price, amount)
  83                 VALUES ($debtor_trans_no, $debtor_trans_type, $tax_type_id, $rate, $included_in_price, $amount)";
  84
  85         db_query($sql, "The debtor transaction tax detail could not be added");
  86 }
  87
  88 //----------------------------------------------------------------------------------------
  89
  90 function get_customer_trans_tax_details($debtor_trans_type, $debtor_trans_no)
  91 {
  92         $sql = "SELECT ".TB_PREF."debtor_trans_tax_details.*, ".TB_PREF."tax_types.name AS tax_type_name
  93                 FROM ".TB_PREF."debtor_trans_tax_details,".TB_PREF."tax_types
  94                 WHERE debtor_trans_no=$debtor_trans_no
  95                 AND debtor_trans_type=$debtor_trans_type
  96                 AND ".TB_PREF."tax_types.id = ".TB_PREF."debtor_trans_tax_details.tax_type_id";
  97
  98         return db_query($sql, "The debtor transaction tax details could not be queried");
  99 }
 100
 101 //----------------------------------------------------------------------------------------
 102
 103 function void_customer_trans_tax_details($type, $type_no)
 104 {
 105         $sql = "UPDATE ".TB_PREF."debtor_trans_tax_details SET amount=0
 106                 WHERE debtor_trans_no=$type_no
 107                 AND debtor_trans_type=$type";
 108
 109         db_query($sql, "The debtor transaction tax details could not be voided");
 110 }
 111
 112 //----------------------------------------------------------------------------------------
 113
 114 ?>