//print_r ($shopInfoObj);
$db->query($sql);
$last_insert_id = $db->insert_id();
//print_r($transferGoodsOjbArrList_de);
$arrlen = count($transferGoodsOjbArrList_de);
echo '1<br>';
for ($r = 0; $r < $arrlen; $r++) {
echo '2<br>';
$qty = (int) $transferGoodsOjbArrList_de[$r]->qty;
if ($transferGoodsOjbArrList_de[$r]->is_acc == 1) {
//if 電話
$imei = $transferGoodsOjbArrList_de[$r]->imei;
$z = getMobileDetail($imei);
print_r($z['poDetail_no']);
//getMobilePoNo
$po_date = getMobilePoDate($z['poDetail_no']);
$sql = "INSERT INTO transdetail (`trans_qty`, `IMEI`, `transfer_no`,`po_date`) \r\n VALUES ({$qty}, {$imei}, {$last_insert_id},'{$po_date}')";
$db->query($sql);
$sql = "UPDATE phone SET retailShop_no=9999 WHERE IMEI='{$imei}'";
$db->query($sql);
//editing
} else {
//if not 電話
$bcode = $transferGoodsOjbArrList_de[$r]->bcode;
$acc_no = getAccNo($bcode);
//2013-10-30
//because is normal transfer, use 0 or it isforshop = self shop code
$isforshop = array($_SESSION['retail_no'], 0);
// 0=not point to any shop, 1= point to a retailshop
$stockin_arr = getStockin($acc_no, $fromRetail_no, $isforshop);
$stockin_arr_length = count($stockin_arr);
function add_mobiletotransfer($from_shopinfo, $okphonedata)
{
global $db;
$DATE2 = date("Y-m-d");
$create_date = date("Y-m-d H:i:s");
$fromRetail_no = $from_shopinfo->fromretail;
$toRetail_no = $from_shopinfo->toretail;
$staff_no = $from_shopinfo->staffno;
$sql = "INSERT INTO transfer (`transDate`, `fromRetail_no`, `toRetail_no`, `staff_no`, `transState_no`, `tranReson`) \r\n VALUES ('{$create_date}', '{$fromRetail_no}', '{$toRetail_no}', {$staff_no}, 1, '普通轉貨')";
$db->query($sql);
$last_insert_id = $db->insert_id();
foreach ($okphonedata as $key => $phonedata) {
$imei = $phonedata->IMEI;
$poDetail_no = $phonedata->poDetail_no;
$po_date = getMobilePoDate($poDetail_no);
$v_sql[] = "(1,'{$imei}','{$last_insert_id}','{$po_date}')";
}
$sql = "INSERT INTO transdetail (`trans_qty`, `IMEI`, `transfer_no`,`po_date`) \r\n VALUES" . implode(',', $v_sql);
$db->query($sql);
/*
print_r('<br>');
print_r($last_insert_id);
print_r('<br>');
*
*/
return $last_insert_id;
}
