临时文件

wcs 登录

/logining?parameterMap=%7B%22userCode%22%3A%22gcwms%22%2C%22userName%22%3A%22gcwms%22%2C%22warehouseCode%22%3A%22USEA%22%7D&signStr=6164B269E16430347FBB64583A8935C9

import { router } from "@/router";

export const useJumpUrl = async (url) => {
  const route = router.currentRoute.value;
  await router.push(url + "?warehouseCode=" + route.query.warehouseCode);
};

查询历史商品上架后售后单还是处理中的售后单

select aftermarket_order.aftermarket_code,if(aftermarket_order.source=1,'历史数据迁移','非历史数据') as 来源 from aftermarket_order_product
join aftermarket_order on  aftermarket_order.aftermarket_code=aftermarket_order_product.aftermarket_code
where aftermarket_order_product.forecast_qty = aftermarket_order_product.putaway_qty+aftermarket_order_product.lose_qty+aftermarket_order_product.destruction_qty
and aftermarket_order.aftermarket_status = 1030

and aftermarket_order.aftermarket_code not in (
select aftermarket_order.aftermarket_code from aftermarket_order_product
join aftermarket_order on  aftermarket_order.aftermarket_code=aftermarket_order_product.aftermarket_code
where aftermarket_order_product.forecast_qty != aftermarket_order_product.putaway_qty+aftermarket_order_product.lose_qty+aftermarket_order_product.destruction_qty
and aftermarket_order.aftermarket_status = 1030
) group by aftermarket_order.aftermarket_code

数据处理： v1/process_aftermarket_err_data

/owms/api/v1/process_aftermarket_err_data

查容器

/web/v2/returns/returnQcCCode

查 mq

/owms/api/v1/mq_send_list?msg_id_fuzzy_right=aftermarket&code=R000010-211216-0008

推送售后单到队列

 /owms/api/v1/send_aftermarket_order_to_mq?aftermarket_code=RG898-210802-0001

修改数据

/owms/api/v1/modify_table_data?table_name=aftermarket_order&where=aftermarket_code%3D%27REL123-211001-0002%27

查数据强制完结没有待确认

select * from aftermarket_order_log join aftermarket_order on aftermarket_order.aftermarket_code= aftermarket_order_log.aftermarket_code where contents='强制完结'
and status_to='1030' and to_be_confirmed_time is null and is_confirm=0 and aftermarket_order.aftermarket_status=1030

# test 数据库

192.168.126.106
63307
fbg_admin_user
BYVtEfScCQjImjpPtfPB

退件网关修改(测试沙盒都需要做变更)(运维)

原退件 pc 网关配置 /web/v2 变更为 /web/v2/returns

原退件 pda 网关配置 /pda/v2 变更为 /web/v2/returns

代码路由修改(研发)

退件 pda 路由统一前缀/web/v2/returns

测试 jenkins

http://jenkins.dev.eminxing.com/login?from=%2F
 zt18497  T*1t8t4z9t7

测试密码

fcEsb6DFFQAKWRvhdkokk

/owms/api/v1/mq_send_list?code=R000010-211216-0004

238 服务器命令

/usr/local/n/sbin/nginx -s reload

pt 环境 nginx 重启

/data/sh/nginx.sh restart

office