- $result = get_stock_transfer_items($trans_no);
- if (db_num_rows($result) < 2)
- {
- display_db_error("transfer with less than 2 items : $trans_no", "");
- }
+ // retrieve common data from any two from/to move records
+ $sql = "SELECT loc_from.*, loc_to.*
+ FROM
+ (SELECT trans_no, type, tran_date, reference, move.loc_code as from_loc, loc.location_name as from_name
+ FROM ".TB_PREF."stock_moves move
+ LEFT JOIN ".TB_PREF."locations loc ON loc.loc_code=move.loc_code
+ WHERE type=".ST_LOCTRANSFER." AND trans_no=".db_escape($trans_no). " AND qty<0 LIMIT 1) loc_from,
+
+ (SELECT move.loc_code as to_loc, loc.location_name as to_name
+ FROM ".TB_PREF."stock_moves move
+ LEFT JOIN ".TB_PREF."locations loc ON loc.loc_code=move.loc_code
+ WHERE type=".ST_LOCTRANSFER." AND trans_no=".db_escape($trans_no). " AND qty>0 LIMIT 1) loc_to";
+
+ $result = db_query($sql, "Could not get transfer common data");
+
+ $data = db_fetch($result);