python_files/cppc_python脚本/服务器脚本/demo_20221029.py

# -*- 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')