摘要: import requests as req from openpyxl import Workbook import re session_wms = req.Session() login_url = "https://apollo-api.xtw-tech.com/v1/auth/token" 阅读全文
posted @ 2022-12-03 18:34 烦恼1234 阅读(31) 评论(0) 推荐(0) 编辑
摘要: # @author xjf # 用途:打印发货单明细 import requests from openpyxl import Workbook wb = Workbook() ws = wb.active # title = ['发货仓','订单类型','发货单号','发货单号状态','SP',' 阅读全文
posted @ 2022-12-02 18:34 烦恼1234 阅读(35) 评论(0) 推荐(0) 编辑
摘要: import time import requests from apscheduler.schedulers.blocking import BlockingScheduler from warnings import filterwarnings from pytz_deprecation_sh 阅读全文
posted @ 2022-11-03 11:52 烦恼1234 阅读(46) 评论(0) 推荐(0) 编辑
摘要: import time from dingtalkchatbot.chatbot import DingtalkChatbot import requests webhook ='https://oapi.dingtalk.com/robot/send?access_token=b7527b37d5 阅读全文
posted @ 2022-11-03 11:50 烦恼1234 阅读(24) 评论(0) 推荐(0) 编辑
摘要: select t4.sp码, t4.zaitu as '在途', t4.仓库名称 AS '中心仓', t4.标品名称, t4.库存成本, t4.货主, t4.分类名称, t4.一级分类名称, t4.库存数量 as '中心仓库存', t4.前置仓, t4.城市, IFNULL(t1.有库存天数, 0) 阅读全文
posted @ 2022-11-03 11:47 烦恼1234 阅读(25) 评论(0) 推荐(0) 编辑
摘要: https://blog.csdn.net/I_peter/article/details/117066758 阅读全文
posted @ 2022-06-12 14:37 烦恼1234 阅读(4) 评论(0) 推荐(0) 编辑
摘要: https://www.sohu.com/a/295090391_120046629 阅读全文
posted @ 2022-03-15 17:14 烦恼1234 阅读(85) 评论(0) 推荐(0) 编辑
摘要: import glob, os import re file = glob.glob(os.path.join(r'G:\data\stock\2', "*.csv")) dl = [] for f in file: dl.append(pd.read_csv(f)) df = pd.concat( 阅读全文
posted @ 2022-03-08 11:45 烦恼1234 阅读(38) 评论(0) 推荐(0) 编辑
摘要: import pandas as pd # 计算中心仓调拨出库到货差异 bj = pd.read_excel('G:/2月调拨对账/1.xlsx', index_col=False) sh = pd.read_excel('G:/2月调拨对账/2.xlsx', index_col=False) cd 阅读全文
posted @ 2022-03-08 11:22 烦恼1234 阅读(35) 评论(0) 推荐(0) 编辑
摘要: https://blog.csdn.net/qq_38890412/article/details/104536357?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_title~default-0.pc_rele 阅读全文
posted @ 2022-01-15 01:20 烦恼1234 阅读(129) 评论(0) 推荐(0) 编辑