AGV断电后服务需要重启，堡垒机IP：172.27.34.199
完全退出程序后，打开软件，先点“连接控制器”，1分钟后再点“开始运行”
仓库平面图
agv预拣选流程
agv复核下架流程
1. dps-agv接口表
–1.DPS任务下达头
SELECT A.,A.rowid FROM df_pickbasket_task_w2c A;
SELECT A.,A.rowid FROM Df_Pickbasket_Task_W2c_His A where A.TASKID=’28252’ ORDER BY A.CREATE_DATE DESC;–拣选篮子号
–2.DPS任务下达明细
SELECT A.,A.rowid FROM df_pickbasket_task_dtl_w2c A;
SELECT A.,A.rowid FROM Df_Pickbasket_Task_Dtl_W2c_His A where A.DETAILID=’472806’;–出入库ID
–3.预检下架完成表
SELECT A.,A.rowid FROM df_prepick_down_c2w A;
SELECT A.,A.rowid FROM Df_Prepick_Down_C2w_His A WHERE A.TASKID=’33176’;–拣选篮子号
–4.预检上架完成表
SELECT A.,A.rowid FROM df_prepick_up_c2w A;
SELECT A.,A.rowid FROM df_prepick_up_c2w_his A where a.taskid=’16670’;–拣选篮子号
–5.周转箱开始下架
SELECT A.,A.rowid FROM df_pick_start_w2c A;
SELECT A.,A.rowid FROM Df_Pick_Start_W2c_His A WHERE A.TASKID=’34494’;–周装箱，拣选篮子号
–6.dps拣选完成
SELECT A.,A.rowid FROM df_pick_finish_c2w A;
SELECT A.,A.rowid FROM df_pick_finish_c2w_his A WHERE A.TASKID=’34494’;–拣选篮子号
SELECT A.,A.rowid FROM df_pick_finish_c2w_his A order by a.receive_date desc;
–7.wms复核刷新是判断
–wms下架标识 tmpflag 2 wms复核刷新是判断
SELECT a.tmpflag, A.SENDWCSDOWN, A.,A.rowid FROM wms_pickbasket_doc A WHERE A.PICKBASKETID=’24057’;–拣选篮子号
–8.wms任务是否下发标志 0未发 1已发，2不发
SELECT a.sendtowcsflag, A.,A.rowid FROM wms_turnbox_doc A where a.containerid=’1972’;
———————-路劲表——————–
–1.周装箱路劲
SELECT A.,A.rowid FROM df_carry_path_c2w A;
SELECT A.,A.rowid FROM df_carry_path_c2w_his A WHERE A.VAR_BARCODE=’ZBNA0637’;–周转箱
–2.条码路劲
SELECT A.,A.rowid FROM df_workbin_transinfo_c2w A;
———————–agv和播种墙任务相关表—————–wms先下发播种墙任务，播种前回传后下发agv任务，agv到站后触发亮灯，拍灯后给agv实操完成
–1。分组
SELECT A.,A.rowid FROM qt_task_group_rel A WHERE A.SOURCEID=’33604’ ;–出入库id
SELECT A.,A.rowid FROM qt_task_group_summary A where a.posid=’33842’;–0显示
–2.播种墙任务下发
SELECT A.,A.rowid FROM qt_sowingwall_task A;
SELECT A.,A.rowid FROM qt_sowingwall_task_his A WHERE A.BASKETNUM=’24699’;–拣选篮子号
–3.分播点亮
SELECT A.,A.rowid FROM qt_sowingwall_light A;
SELECT A.,A.rowid FROM qt_sowingwall_light_his A WHERE A.BASKETNUM=’34723’;–拣选篮子号 posid是wms拣选货位编码
–4.拍灯回传
SELECT A.,A.rowid FROM qt_sowingwall_claplamp_back A WHERE A.BASKETNUM=’34723’;–拣选篮子号
SELECT A.,A.rowid FROM qt_sowingwall_claplamp_back A WHERE A.BASKETNUM=’35367’;–拣选篮子号
–5.暂存货位下架
SELECT A.,A.rowid FROM qt_sowingwall_down_send A WHERE A.BASKETNUM=’21031’;–周转箱任务ID
–6.快仓货架搬运任务
SELECT A.,A.rowid FROM qt_task_bucketmove A;
SELECT A.,A.rowid FROM qt_task_bucketmove_his A WHERE A.ROBOTJOBID LIKE ‘%491922%’;–出入库id
SELECT A.,A.rowid FROM qt_task_bucketmove_his A WHERE a.bucketcode=’073’ order by a.create_date desc;–出入库id
–7.快仓货架搬运任务完成
SELECT A.,A.rowid FROM qt_task_bucketmove_back A where A.ROBOTJOBID LIKE ‘%491922%’;–出入库id
–SELECT A.,A.rowid FROM qt_task_bucketmove_back A where A.ROBOTJOBID LIKE ‘%463660%’;–出入库id
–8.查询AGV货架状态
SELECT A.*,A.rowid FROM wms_container_def A where a.containerno=’105’–货架号，1：在线（移动中，不可叫出做任务）0：离线（可被叫出做任务）
篮子号14795应该亮AGV02-304，但是AGV02-204也同时量了
篮子号14782
2.接口地址
—————————-wms播种墙接口
http://172.27.34.196:8070/wmsapi/sowingwall/bindpos--绑定回传
http://172.27.34.196:8070/wmsapi/sowingwall/clapLamp--拍灯回传
—————————-wcs播种墙接口—–
http://172.27.34.199:10001/wcs/api/taskDistribution--分播墙任务下发
http://172.27.34.199:10001/wcs/api/lightUp--分播点亮
http://172.27.34.199:10001/wcs/api/mergeOrderTask--分播墙暂存下架
–isPostBackWms 拍灯是否回传wms
SELECT isPostBackWms,* from [dbo].[lightUpTaskMx] where basketnum=’12998’;–拣选篮子号
————————-agv回报wms——————
http://172.27.34.196:8070/wmsapi/callback/quicktron/task/report
————————-wms给agv——————–
http://172.27.40.200:10080/api/quicktron/wcs/standardized.robot.job.submit--快仓任务下发
http://172.27.40.200:10080/api/quicktron/wcs/standardized.operation.notice--快仓实操任务完成通知
3.wcs相关地址
大幅wcs网页地址： http://172.27.34.200:8090/dgate/
账号：daifuku 密码：daifuku
大幅fcm网页地址：http://172.27.34.200:8095/dgate/
账号：daifuku 密码：daifuku
agv网页地址：http://172.27.40.200/web/amr/user/login?redirect=http%3A%2F%2F172.27.40.200%2Fweb%2Famr%2Fbase%2Fhome
账号：admin 密码：admin
