Topic: How to modify this function add_po
created a new page called purchase request but my problems is i copied original file from purchase order now my problems is the purchase request insert its data into purch_order instead of my new database purch_request how do i make my new page purchase request go into databse purch_request?
//-----> this for my purch_request database how or where do i find the function name for add_po so i could change it?.
function add_po_request(&$po_obj)
{
global $Refs;
begin_transaction();
hook_db_prewrite($po_obj, ST_PURCHORDER);
/*Insert to purchase order header record */
$sql = "INSERT INTO ".TB_PREF."purch_request (supplier_id, request_name, Comments, ord_date, reference,
requisition_no, into_stock_location, delivery_address, total, tax_included, prep_amount) VALUES (";
$sql .= db_escape($po_obj->supplier_id) . "," .
db_escape($po_obj->request_name) . "," .
db_escape($po_obj->Comments) . ",'" .
date2sql($po_obj->orig_order_date) . "', " .
db_escape($po_obj->reference) . ", " .
db_escape($po_obj->supp_ref) . ", " .
db_escape($po_obj->Location) . ", " .
db_escape($po_obj->delivery_address) . ", " .
db_escape($po_obj->get_trans_total()). ", " .
db_escape($po_obj->tax_included). ", " .
db_escape($po_obj->prep_amount). ")";
db_query($sql, "The purchase order header record could not be inserted");
/*Get the auto increment value of the order number created from the sql above */
$po_obj->order_no = db_insert_id();
/*Insert the purchase order detail records */
foreach ($po_obj->line_items as $line_no => $po_line)
{
$sql = "INSERT INTO ".TB_PREF."purch_order_request (order_no, item_code, description, delivery_date, unit_price, quantity_ordered) VALUES (";
$sql .= $po_obj->order_no . ", " . db_escape($po_line->stock_id). "," .
db_escape($po_line->item_description). ",'" .
date2sql($po_line->req_del_date) . "'," .
db_escape($po_line->price) . ", " .
db_escape($po_line->quantity). ")";
db_query($sql, "One of the purchase order detail records could not be inserted");
$po_obj->line_items[$line_no]->po_detail_rec = db_insert_id();
}
$Refs->save(ST_PURCHORDER, $po_obj->order_no, $po_obj->reference);
add_audit_trail(ST_PURCHORDER, $po_obj->order_no, $po_obj->orig_order_date);
hook_db_postwrite($po_obj, ST_PURCHORDER);
commit_transaction();
return $po_obj->order_no;
}