# -*- codeing = utf-8 -*- # @Time : 2022/10/29 15:01 # @Author : Clown # @File : demo_20221029.py # @Software : PyCharm import re import pandas as pd import hashlib import requests import json import random import pymysql import execjs from dateutil.parser import parse from datetime import datetime,timedelta # df = pd.read_excel('C:/Users/ClownHe/Desktop/随机分配.xlsx') # # # dudaos = list(set(list(df['督导']))) # a = df.to_dict('records') # # print(a) # # print(df[df['督导']=='李雷'].to_dict('records')) # a = [] # shezhi = {'李雷':6, # '关杰彬':6, # '廖祥模':6, # '高洋':5, # '孟召春':6, # '刘梦奇':5} # import torrentp # # torrent_file = torrentp.TorrentDownloader('magnet:?xt=urn:btih:0fee1f3f78603ef0ae8b8183078d13734f97a2be',r'D:\天翼云盘同步盘\down') # torrent_file.start_download() # torrent_file.start_download() # df_out = [] # if 1==0: # for dudao in dudaos: # print ('---------------------') # dudao_shops = {} # dudao_shops['督导'] = dudao # print('当前督导：',dudao,'\n分配门店如下') # random_num = shezhi[dudao] # shops = list(df[df['督导'] ==dudao]['门店名']) # shops_random_out = [] # x = 1 # while len(shops_random_out) < random_num: # shop = shops[random.randint(0,len(shops)-1)] # if shop in shops_random_out: # ... # else: # shops_random_out.append(shop) # print(x,'.',shop) # x += 1 # print('---------------------') # dudao_shops['稽查门店'] = shops_random_out # a = {'a':{'a':{'a':2},'b':3},'c':4} # d = a # b = 0 # c = True # while c : # try: # value = a['a'] # c = True # a = value # print(value) # b += 1 # except: # c = False # print(b,d) # json_path = r'C:\Users\ClownHe\Desktop\新建 文本文档.json' # json_value = open(json_path,mode='r',encoding='utf-8-sig').read() # json_data = json.loads(json_value) # print(json_data['data']['session']['APLUS_CORE_0.21.68_20221206171442_30766bff']) # # #生成JavaScript运行环境，环境名可以指定 # node = execjs.get() #安装nodejs后，会得到运行环境名为：Node.js (V8) # with open('测试.js',encoding='utf-8') as f: # js_code = f.read() # #编译js代码 # ctx = node.compile(js_code, cwd=r'E:\Nodejs\node_modules\npm\node_modules') #compile方法去加载js代码，参数cwd指定本地安装模块所在目录 # #两种方式执行js函数 # data1 = ctx.eval('getParam({"city":"北京"})') #eval方法中，整个函数调用包含在字符串内 # data2 = ctx.call('getParam',{'city':'北京'}) #call方法中，第一个参数是函数名（str）,后面接参数 # f = open(r'C:\Users\ClownHe\Desktop\title.json',mode='a', encoding='utf-8-sig',newline='') # formin = r'C:\Users\ClownHe\Desktop\导出\selectShopDailyOperationFormHeadMT.xlsx' # df_in = pd.read_excel(formin) # rows = df_in.shape[0] # df_in_dict = df_in.loc # a = {} # for i in range(rows): # rowinfo = dict(df_in_dict[i]) # json_col = json.loads(rowinfo['json']) # json_col[rowinfo['id']]['平台'] = '美团' # a.update(json_col) # f = open(r'C:\Users\ClownHe\Desktop\title.json',mode='w', encoding='utf-8-sig',newline='') # f.write(json.dumps(a,ensure_ascii=False)) # a = [1,2,3,4] # b = [2,2,3] # c = list(set(a)|set(b)) # for b1 in b: # try: # d = a.remove(b1) # except: # ... # print(a) # # a1 = 2 # a2 = 3 # # if a1 != a2 and a1 != 1: # print(a1) import math # startTime = '2022-11-30 14:12:41' # endTime = '2022-12-31 14:12:41' # x = endTime.replace(' ','T') # print(x) # n = math.ceil((parse (str (endTime)).timestamp () -parse (str (startTime)).timestamp ()) / 3600 / 24 / 30) # x = 1 # crmIds = '' # json_params = [] # for i in range (n): # if x < n: # m = parse (str (parse (str (startTime)) + timedelta (days=30))).strftime ('%Y-%m-%d %H:%M:%S') # x += 1 # else: # m = endTime # json_param = {'crmIds':str(crmIds), # 'date':{'startTime':startTime, # 'endTime':m}} # json_params.append(json_param) # print(json_param) # startTime = parse (str (parse (str (m)) + timedelta (seconds=1))).strftime ('%Y-%m-%d %H:%M:%S') # url = "http://124.222.188.59:63307/selectcustomers1" # headers = {'Content-Type': 'application/json'} # params = { # "followUserId": '', # "mobile": "15073889961", # "name": "未知", # 'memo': '测试' # } # resp = requests.post(url,headers=headers,json = params).text # print(resp) # 'http://124.222.188.59:63307/addcustomers1?followUserId=张秋卫&name=客户测试&mobile=13783746560&memo=【客户来源：400热线】【意向品牌：浆小白；】【客户归属地：测试】【客户备注：测试一下 测试】&row_id=7129765867546673152' # 获取表单信息 # url_page = f'https://qiqiao.do1.com.cn/plus/cgi-bin/open/applications/{applicationId}/form_models' # # b = ['b'] # a = len(b) # d = 'a' # for i in range(a): # if i == 0: # s = d # e = b[i] # else: # s = b[i-1] # e = b[i] # # print(s,e) # # a = '2023-03-01' # b = '2023-03-02' # # a = [1,2,3,4,5,6] # for i in a: # if i >= 1: # break # print (i) # dingdan = [1,2,3,4,4,6,7] # dinghuo = [1,1,4,4,5,0,0] # # # dingdan = [0,2,4,5,0,0,0] # # dinghuo = [1,2,3,4,5,6,7] # # x = 0 # y = 0 # dingdanT = 0 # dinghuoT = 0 # # dingdan_1 = 0 # dinghuo_1 = 0 # # #如果开始为正常，持续推算，直到异常 # #如果开始为异常，持续推算，直到正常，持续推算，直到异常 # # for i in range(6): # dingdanT = dingdanT + dingdan[i] # dinghuoT = dinghuoT + dinghuo[i] # # if (dingdanT <= dinghuoT) and (dingdan_1 <= dinghuo_1): # dingdan_1 = dingdanT # dinghuo_1 = dinghuoT # a = '正常' # x = 0 # y = x + 1 # else: # dingdan_1 = dingdanT # dinghuo_1 = dinghuoT # a = '异常' # x = -1 # # if x + y == 0: # break # print (a, i, dingdanT, dinghuoT,x,y,dinghuoT-dingdanT) # dingdan = [1,2,3,4,4,6,7] # dinghuo = [1,1,4,4,5,0,0] # # # dingdan = [0,2,4,5,0,0,0] # # dinghuo = [1,2,3,4,5,6,7] # # x = 0 # y = 0 # dingdanT = 0 # dinghuoT = 0 # # dingdan_1 = 0 # dinghuo_1 = 0 # # s = [] # #从近至远，排查门店订货于订单差异，按最远一次合格为基础，计算当前库存量 # # for i in range(6): # dingdanT = dingdanT + dingdan[i] # dinghuoT = dinghuoT + dinghuo[i] # # if dingdanT <= dinghuoT: # x = i # else: # ... # s_0 = dinghuoT - dingdanT # s.append(s_0) # print(s) # print(s[x]) # a = [8,7,6,5,4,3,2,1] # v = [1,2,3,4,5,6,7,8] # # b = 9 # # for i in range(len(a)): # if i == 0: # if b == a[i]: # continue # else: # max = b # min = a[i] # else: # max = a[i-1] # min = a[i] # print(f'{min}至{max}值为{v[i]}') # # path = 'E:/chrome下载文件/浆小白•豆浆夜市_订单明细下载_2023-03-18_2023-03-18.xlsx' # path_csv = 'E:/chrome下载文件/浆小白•豆浆夜市_订单明细下载_2023-03-18_2023-03-18.csv' # df = pd.read_excel(path,dtype='str',sheet_name=0) # df = pd.DataFrame(df,dtype='str') # df.to_csv(path_csv,index=False) # a = ''' # {"data": [{"clueId": "155920809", "commitTime": "2023-03-27 09:33:51", "solutionType": "phone", "clueName": "未知", "cluePhoneNumber": "15092182342", "flowChannelName": "信息流推广", "area": "山东\n青岛", "searchWord": "", "keyword": "-", "userName": "vip浆小白", "brandName": "浆小白", "routeName": "baidu"}, {"clueId": "230327292902802589", "commitTime": "2023-03-27 09:33:31", "solutionType": "form", "clueName": "王丹阳", "cluePhoneNumber": "17336286479", "flowChannelName": "信息流推广", "area": "湖北\n荆州", "searchWord": "", "keyword": "-", "userName": "vip浆小白", "brandName": "浆小白", "routeName": "baidu"}, {"clueId": "230327292901901882", "commitTime": "2023-03-27 09:30:35", "solutionType": "form", "clueName": "王先生", "cluePhoneNumber": "19941330384", "flowChannelName": "信息流推广", "area": "浙江\n温州", "searchWord": "", "keyword": "-", "userName": "vip浆小白", "brandName": "浆小白", "routeName": "baidu"}, {"clueId": "230327292901813907", "commitTime": "2023-03-27 09:30:19", "solutionType": "form", "clueName": "陈", "cluePhoneNumber": "19577687972", "flowChannelName": "信息流推广", "area": "福建\n莆田", "searchWord": "", "keyword": "-", "userName": "vip浆小白", "brandName": "浆小白", "routeName": "baidu"}, {"clueId": "230327292901807750", "commitTime": "2023-03-27 09:30:18", "solutionType": "form", "clueName": "李佳", "cluePhoneNumber": "16537312348", "flowChannelName": "信息流推广", "area": "湖北\n荆州", "searchWord": "", "keyword": "-", "userName": "vip浆小白", "brandName": "浆小白", "routeName": "baidu"}]} # ''' # print(len(a)) # c = 5 # b = [1,2,3,4,5,6] # e = b # d = len(str(e)) # n = round(len(b)/round(d/c,0),0) # print(d) # print(n) # # while d > c: # # print('\033[1;32m 新增商品失败 \033[0m')