public function act_postalldate()
{
$sku = isset($_POST['sku']) ? trim($_POST['sku']) : '';
$sku = get_goodsSn($sku);
$num = intval($_POST['num']);
if ($num < 0) {
$res['res_code'] = '502';
$res['res_msg'] = "{$sku}入库数量{$num}有误,请重新扫描订单!";
$res['sku'] = $sku;
echo json_encode($res);
exit;
}
if (empty($ebay_id) || empty($sku)) {
$res['res_code'] = '502';
$res['res_msg'] = "入库数据有误,请重新扫描订单!";
$res['sku'] = $sku;
echo json_encode($res);
exit;
}
$sql = "SELECT * FROM ebay_onhandle WHERE goods_sn ='{$sku}' AND ebay_user ='******'";
$sql = $dbcon->execute($sql);
$checkonhandle = $dbcon->num_rows($sql);
if ($checkonhandle == 0) {
$res['res_code'] = '502';
$res['res_msg'] = "{$sku}产品未导入库存信息表!";
$res['sku'] = $sku;
echo json_encode($res);
exit;
}
$ss = "select * from ebay_order_scan_record where ebay_id={$ebay_id} and sku='{$sku}' and is_show = 0";
$ss = $dbcon->execute($ss);
$ss = $dbcon->fetch_one($ss);
if ($ss['amount'] < $num) {
$res['res_code'] = '502';
$res['res_msg'] = "实际配货数量为{$ss['amount']}比输入的数量小!";
$res['sku'] = $sku;
echo json_encode($res);
exit;
}
if ($ss['amount'] == $num) {
$sql = "update ebay_order_scan_record set amount=0,is_show=1,canceltime='{$mctime}' where ebay_id={$ebay_id} and sku= '{$sku}' and is_show = 0 ";
} else {
$sql = "update ebay_order_scan_record set amount=amount-{$num} where ebay_id={$ebay_id} and sku= '{$sku}' and is_show = 0 ";
}
$update_sql = "UPDATE ebay_onhandle SET goods_count=goods_count+{$num} WHERE store_id ={$defaultstoreid} AND goods_sn ='{$sku}' AND ebay_user ='******'";
$note = "PDA异常退货入库sku[{$sku}]{$num}个!";
if ($dbcon->execute($update_sql) && $dbcon->execute($sql)) {
into_warehouse_log($sku, $num, $note, '异常订单PDA扫描入库', $truename, $ebay_id);
$res['res_code'] = "200";
$res['res_msg'] = "{$sku}入库{$num}个成功！";
$res['sku'] = $sku;
echo json_encode($res);
exit;
} else {
$res['res_code'] = '001';
$res['res_msg'] = "入库失败,请重新扫描订单!";
echo json_encode($res);
exit;
}
}
function addreturnscan($ebayid)
{
global $dbcon, $user, $mctime, $truename;
$ss = "select ebay_ordersn,ebay_warehouse,ebay_userid from ebay_order where ebay_id = '{$ebayid}' ";
$ss = $dbcon->execute($ss);
$ss = $dbcon->getResultArray($ss);
$ebay_ordersn = $ss[0]['ebay_ordersn'];
$ebay_userid = $ss[0]['ebay_userid'];
$ss = "select sku,ebay_amount from ebay_orderdetail where ebay_ordersn='{$ebay_ordersn}'";
$ss = $dbcon->execute($ss);
$ss = $dbcon->getResultArray($ss);
for ($i = 0; $i < count($ss); $i++) {
$goods_sn = $ss[$i]['sku'];
$ebay_amount = $ss[$i]['ebay_amount'];
$sql = "\tselect goods_name,goods_sn,goods_cost,goods_unit,goods_id\n\t\t\t\t\t\t\t\t\tfrom ebay_goods where goods_sn='{$goods_sn}' and ebay_user='******'";
$sql = $dbcon->execute($sql);
$sql = $dbcon->getResultArray($sql);
if (count($sql) == 0) {
$rr = "\tselect goods_sncombine from ebay_productscombine \n\t\t\t\t\t\t\t\t\twhere ebay_user='******' and goods_sn='{$goods_sn}'";
$rr = $dbcon->execute($rr);
$rr = $dbcon->getResultArray($rr);
if (count($rr) > 0) {
$goods_sncombine = $rr[0]['goods_sncombine'];
$goods_sncombine = explode(',', $goods_sncombine);
for ($e = 0; $e < count($goods_sncombine); $e++) {
$pline = explode('*', $goods_sncombine[$e]);
$goods_sn = $pline[0];
$goddscount = $pline[1] * $ebay_amount;
$sql = "\tselect goods_name,goods_sn,goods_cost,goods_unit,goods_id\n\t\t\t\t\t\t\t\t\t\t\t\tfrom ebay_goods \n\t\t\t\t\t\t\t\t\t\t\t\twhere goods_sn='{$goods_sn}' and ebay_user='******'";
$sql = $dbcon->execute($sql);
$sql = $dbcon->getResultArray($sql);
$goods_name = $sql[0]['goods_name'];
$goods_sn = $sql[0]['goods_sn'];
$goods_price = $sql[0]['goods_cost'];
$goods_unit = $sql[0]['goods_unit'];
$goods_id = $sql[0]['goods_id'];
$getcount = "select goods_count from ebay_onhandle where goods_sn='{$goods_sn}' ";
$getcount = $dbcon->execute($getcount);
$getcount = $dbcon->getResultArray($getcount);
//$sq = "update ebay_onhandle set goods_count=goods_count+$goddscount where goods_sn='$goods_sn' and goods_id='$goods_id'";
$sq = "update ebay_onhandle set goods_count=goods_count+{$goddscount} where goods_sn='{$goods_sn}'";
if ($dbcon->execute($sq)) {
$res_array[$i] = $goods_sn . '*' . $goddscount . ',';
} else {
$res_array = array('res_code' => '001', 'res_msg' => '库存更新失败！');
}
into_warehouse_log($goods_sn, $ebay_amount, '订单退回扫描入库', '退货扫描入库', $truename, $ebayid);
}
}
} else {
$goods_name = $sql[0]['goods_name'];
$goods_sn = $sql[0]['goods_sn'];
$goods_price = $sql[0]['goods_cost'];
$goods_unit = $sql[0]['goods_unit'];
$goods_id = $sql[0]['goods_id'];
$getcount = "select goods_count from ebay_onhandle where goods_sn='{$goods_sn}' ";
$getcount = $dbcon->execute($getcount);
$getcount = $dbcon->getResultArray($getcount);
//$sq = "update ebay_onhandle set goods_count=goods_count+$ebay_amount where goods_sn='$goods_sn' and goods_id='$goods_id'";
$sq = "update ebay_onhandle set goods_count=goods_count+{$ebay_amount} where goods_sn='{$goods_sn}'";
if ($dbcon->execute($sq)) {
$res_array[$i] = $goods_sn . '*' . $ebay_amount . ',';
} else {
$res_array = array('res_code' => '001', 'res_msg' => '库存更新失败！');
}
into_warehouse_log($goods_sn, $ebay_amount, '订单退回扫描入库', '退货扫描入库', $truename, $ebayid);
}
}
return $res_array;
}
