- $sql = "INSERT INTO ".TB_PREF."sales_order_details
- (id, order_no, trans_type, stk_code, description, unit_price, quantity,
- discount_percent, qty_sent)
- VALUES (";
- $sql .= db_escape($line->id ? $line->id : 0) . ","
- .$order_no . ",".$order->trans_type.","
- .db_escape($line->stock_id) . ","
- .db_escape($line->item_description) . ", "
- .db_escape($line->price) . ", "
- .db_escape($line->quantity) . ", "
- .db_escape($line->discount_percent) . ", "
- .db_escape($line->qty_done) ." )";
-
- db_query($sql, "Old order Cannot be Inserted");
-
+ if (!$line->id) //new line
+ $sql = "INSERT INTO ".TB_PREF."sales_order_details
+ (order_no, trans_type, stk_code, description, unit_price, quantity,
+ discount_percent, qty_sent)
+ VALUES (".$order_no . ",".$order->trans_type.","
+ .db_escape($line->stock_id) . ","
+ .db_escape($line->item_description) . ", "
+ .db_escape($line->price) . ", "
+ .db_escape($line->quantity) . ", "
+ .db_escape($line->discount_percent) . ", "
+ .db_escape($line->qty_done) ." )";
+ else
+ $sql = "UPDATE ".TB_PREF."sales_order_details
+ SET id=".db_escape($line->id).",
+ order_no=$order_no,
+ trans_type=".$order->trans_type.",
+ stk_code=".db_escape($line->stock_id).",
+ description=".db_escape($line->item_description).",
+ unit_price=".db_escape($line->price).",
+ quantity=".db_escape($line->quantity).",
+ discount_percent=".db_escape($line->discount_percent).",
+ qty_sent=".db_escape($line->qty_done)."
+ WHERE id = ".db_escape($line->id);
+
+ db_query($sql, "Old order Cannot be updated");