//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; }