集团问题排查¶
In [9]:
res:list[str] = []
with open(r'D:\dongdong_record\file\2024-04\20240411\20240411\em_invoice-04-10\2024-04-10\info-log.log', 'r', encoding='utf-8') as fpr:
for line in fpr:
if 'item:' in line and '91110108MA01QYY17G' in line:
res.append(line)
In [11]:
import json
_res = []
for it in res:
# print(it.split("item:")[-1])
if it.split("item:")[-1]:
_res.append(json.loads(it.split("item:")[-1]))
In [19]:
res_data = {
"buyerTaxpayerName": "艾普科创（北京）控股有限公司",
"buyerTaxpayerNo": "91110108MA01QYY17G",
"drawer": "王奥文",
"fullElectricInvoiceNo": "24312000000098371922",
"invTypeStr": "数电票（增值税专用发票）",
"invoiceDate": "2024-04-10 10:46:08",
"invoiceRiskLevel": "正常",
"invoiceStatus": "正常",
"itemCode": "3040303010600000000",
"itemName": "*广告服务*广告发布费",
"orderNum": "1",
"priceAmt": -94339.62,
"remark": "被红冲蓝字数电票号码：24312000000020591177 红字发票信息确认单编号：31011424041003510695",
"saleTaxpayerName": "东方财富信息股份有限公司",
"saleTaxpayerNo": "913100007714584745",
"taxAmt": "-5660.38",
"taxRateStr": "6%"
}
In [22]:
resBuyerTaxpayerName = res_data['buyerTaxpayerName']
resBuyerTaxpayerNo = res_data['buyerTaxpayerNo']
resSaleTaxpayerNo = res_data['saleTaxpayerNo']
resInvType = '10110'
print(resBuyerTaxpayerName, resBuyerTaxpayerNo, resSaleTaxpayerNo, resInvType)
for ind, it in enumerate(_res):
buyerTaxpayerName = it['buyerTaxpayerName']
buyerTaxpayerNo = it['buyerTaxpayerNo']
saleTaxpayerNo = it['saleTaxpayerNo']
buyerTaxpayerName = it['buyerTaxpayerName']
invType = it['invType']
print(ind, buyerTaxpayerName, buyerTaxpayerNo, saleTaxpayerNo, invType)
if resBuyerTaxpayerName == buyerTaxpayerName \
and resBuyerTaxpayerNo == buyerTaxpayerNo \
and resSaleTaxpayerNo == saleTaxpayerNo \
and invType == resInvType:
print(it)
艾普科创（北京）控股有限公司 91110108MA01QYY17G 913100007714584745 10110 0 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 1 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 2 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 3 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 4 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 5 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 6 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 7 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 8 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 9 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 10 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 11 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 12 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 13 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 14 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 15 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 16 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 17 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 18 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 19 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 20 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 21 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 22 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 23 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 24 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 25 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 26 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 27 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 28 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 29 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 30 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 31 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 32 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 33 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 34 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 35 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 36 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 37 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 38 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 39 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 40 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 41 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 42 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 43 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 44 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 45 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 46 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 47 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 48 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 49 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110 50 艾普科创（北京）科技有限公司 91110108MA01QYY17G 913100007714584745 10110
RPA问题排查¶
In [26]:
import requests
token = 'NkIzQkVCRDY2QzY1QUMyNDM3MTI0MEM2NzU5OTdEMDJDOEZGREMxMkZEMjZEOTJEQTlGN0E0QTI4QzQ1M0I5Rg=='
cookies = {
'token': token,
'sidebarStatus': '1',
}
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0',
'Accept': 'application/json, text/plain, */*',
'Accept-Language': 'zh-CN,zh;q=0.8,zh-TW;q=0.7,zh-HK;q=0.5,en-US;q=0.3,en;q=0.2',
'Accept-Encoding': 'gzip, deflate',
'Content-Type': 'application/json;charset=utf-8',
'token': token,
'client-type': 'management_portal',
'Origin': 'http://rpa.emnj',
'Connection': 'keep-alive',
'Referer': 'http://rpa.emnj/',
'Pragma': 'no-cache',
'Cache-Control': 'no-cache',
}
result_ls = []
for i in range(1, 10):
params = (
('pageIndex', i),
('pageSize', '50'),
('sortBy', 'id'),
('sortType', 'desc'),
)
data = '{"pluginId":"","startTimeFrom":"2024-04-10 00:00:00","startTimeTo":"2024-04-12 00:00:00","status":""}'
response = requests.post('http://rpa.emnj/rpa/task/listAllTaskExecuteRecords', headers=headers, params=params, cookies=cookies, data=data)
result_ls.extend(response.json()['data']['list'])
In [27]:
kws = ['阜阳颍淮大道证券营业部',
'合肥创新大道证券',
'合肥金寨路证券营业',
'芜湖文化路证券营业',
'西安科技路证券营',
'股份有限公司西北分公司',
'公司咸阳人民西路证券营业'
]
target_res = []
ind = 0
for it in result_ls:
account = it['account']
for kw in kws:
if kw in account:
ind += 1
target_res.append(it)
print(ind, "append", account)
1 append 东方财富证券股份有限公司西北分公司 2 append 东方财富证券股份有限公司咸阳人民西路证券营业部 3 append 东方财富证券股份有限公司西北分公司 4 append 东方财富证券股份有限公司西安科技路证券营业部 5 append 东方财富证券股份有限公司芜湖文化路证券营业部 6 append 东方财富证券股份有限公司阜阳颍淮大道证券营业部 7 append 东方财富证券股份有限公司合肥金寨路证券营业部 8 append 东方财富证券股份有限公司合肥创新大道证券营业部 9 append 东方财富证券股份有限公司咸阳人民西路证券营业部 10 append 东方财富证券股份有限公司西北分公司 11 append 东方财富证券股份有限公司西安科技路证券营业部 12 append 东方财富证券股份有限公司芜湖文化路证券营业部 13 append 东方财富证券股份有限公司阜阳颍淮大道证券营业部 14 append 东方财富证券股份有限公司合肥金寨路证券营业部 15 append 东方财富证券股份有限公司合肥创新大道证券营业部
In [35]:
import requests
import os
cookies = {
'token': token,
'sidebarStatus': '1',
}
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0',
'Accept': 'application/json, text/plain, */*',
'Accept-Language': 'zh-CN,zh;q=0.8,zh-TW;q=0.7,zh-HK;q=0.5,en-US;q=0.3,en;q=0.2',
'Accept-Encoding': 'gzip, deflate',
'token': token,
'client-type': 'management_portal',
'Connection': 'keep-alive',
'Referer': 'http://rpa.emnj/',
'Pragma': 'no-cache',
'Cache-Control': 'no-cache',
}
zip_names = []
for it in target_res:
params = (
('id', it['id']),
)
response = requests.get('http://rpa.emnj/rpa/task/downloadTaskResultFile', headers=headers, params=params, cookies=cookies)
response.raise_for_status()
zip_name = response.headers["Content-Disposition"].split("=")[-1]
zip_names.append((it['account'], zip_name))
with open(os.path.join(r"D:\WORK\RPA\20240411失败录屏", zip_name) , 'wb') as fpw:
print("write >>>", zip_name)
fpw.write(response.content)
write >>> TaskResult_2535.zip write >>> TaskResult_2531.zip write >>> TaskResult_2530.zip write >>> TaskResult_2529.zip write >>> TaskResult_2527.zip write >>> TaskResult_2524.zip write >>> TaskResult_2522.zip write >>> TaskResult_2521.zip write >>> TaskResult_2519.zip write >>> TaskResult_2516.zip write >>> TaskResult_2515.zip write >>> TaskResult_2514.zip write >>> TaskResult_2512.zip write >>> TaskResult_2510.zip write >>> TaskResult_2508.zip
In [41]:
target_res[8 - 1]
Out[41]:
{'id': 2521,
'plugin': {'id': 323,
'plugin': {'id': 40,
'name': '安徽个税',
'service': {'id': 15,
'serviceName': '个税申报',
'department': {'id': 22,
'departmentName': '证券财务部',
'additionalDesc': '证券税务业务人员'},
'additionalDesc': None},
'type': 'python',
'additionalDesc': '',
'latestVersion': None},
'showVersion': '8.1.7',
'releaseDate': '2024-03-08 17:38:58',
'additionalDesc': '查询按钮坐标变更'},
'terminal': {'id': 292,
'user': {'id': 76,
'userId': '18979',
'uid': 'b1cf5b118da5497a9579070e78b0f36c',
'userName': '陆君怡',
'workId': '18979',
'role': {'id': 10,
'roleType': '业务管理',
'roleName': '业务管理员',
'additionalDesc': None},
'phoneNumber': '15001780340',
'emailAddress': 'lujunyi@18.cn',
'additionalDesc': '',
'department': {'id': 22,
'departmentName': '证券财务部',
'additionalDesc': '证券税务业务人员'},
'bindServiceDefines': None,
'type': 2},
'mac': '70:b5:e8:34:23:2e',
'client': {'id': 58,
'versionName': '1.0.1',
'releaseDate': '2020-09-28 07:00:00',
'helpPage': None,
'additionalDesc': ''},
'plugins': '358,336,323,359',
'lastUpdateTime': '2024-04-10 20:53:29',
'additionalDesc': None},
'status': 1,
'statusDesc': '失败终止',
'startTime': '2024-04-10 21:17:44',
'endTime': '2024-04-10 21:35:42',
'additionalDesc': None,
'stepDetails': None,
'account': '东方财富证券股份有限公司合肥创新大道证券营业部'}
In [36]:
ind = 0
for ac, zip_file in zip_names:
ind += 1
print(ind, ac, zip_file)
1 东方财富证券股份有限公司西北分公司 TaskResult_2535.zip 2 东方财富证券股份有限公司咸阳人民西路证券营业部 TaskResult_2531.zip 3 东方财富证券股份有限公司西北分公司 TaskResult_2530.zip 4 东方财富证券股份有限公司西安科技路证券营业部 TaskResult_2529.zip 5 东方财富证券股份有限公司芜湖文化路证券营业部 TaskResult_2527.zip 6 东方财富证券股份有限公司阜阳颍淮大道证券营业部 TaskResult_2524.zip 7 东方财富证券股份有限公司合肥金寨路证券营业部 TaskResult_2522.zip 8 东方财富证券股份有限公司合肥创新大道证券营业部 TaskResult_2521.zip 9 东方财富证券股份有限公司咸阳人民西路证券营业部 TaskResult_2519.zip 10 东方财富证券股份有限公司西北分公司 TaskResult_2516.zip 11 东方财富证券股份有限公司西安科技路证券营业部 TaskResult_2515.zip 12 东方财富证券股份有限公司芜湖文化路证券营业部 TaskResult_2514.zip 13 东方财富证券股份有限公司阜阳颍淮大道证券营业部 TaskResult_2512.zip 14 东方财富证券股份有限公司合肥金寨路证券营业部 TaskResult_2510.zip 15 东方财富证券股份有限公司合肥创新大道证券营业部 TaskResult_2508.zip
In [5]:
import time
time.localtime(9202199074)
Out[5]:
time.struct_time(tm_year=2261, tm_mon=8, tm_mday=10, tm_hour=6, tm_min=24, tm_sec=34, tm_wday=5, tm_yday=222, tm_isdst=0)
In [3]:
import pandas as pd
pd.read_excel(r'D:\Temp\excel_\Longport_2023-09-27.xlsx')
Out[3]:
| sourceSite | createTime | author | likeCount | text | title | url | |
|---|---|---|---|---|---|---|---|
| 0 | longport | 2023-09-26 22:05:07 | BTCFREE | 6 | $苹果.US 可以买入啊，稳稳的幸福。。 | NaN | https://longportapp.com/topics/10012856 |
| 1 | longport | 2023-09-27 12:25:09 | 长湾资讯 | 0 | 9 月下跌 15% 的英伟达，为什么还是 AI 芯片股中的 “战斗机”？ Truist 喊出... | 9 月下跌 15% 的英伟达，为什么还是 AI 芯片股中的 “战斗机”？ | https://longportapp.com/news/98660027 |
| 2 | longport | 2023-09-27 16:30:25 | 新浪财经 | 0 | 【TechWeb】9月27日消息，据外媒报道，随着三季度接近尾声，各大厂商这一季度的业绩... | 分析师普遍预计特斯拉 Q3 交付 46.2 万辆电动汽车 不及 Q2 | https://finance.sina.com.cn/nextauto/hydt/2023... |
| 3 | longport | 2023-09-26 16:14:58 | 新韭菜盒子 | 2 | $苹果.US $苹果.US 涨不涨呢。 您的好友送给您一个股票红包。 | NaN | https://longportapp.com/topics/10007654 |
| 4 | longport | 2023-09-27 13:12:19 | kba977 | 1 | $哔哩哔哩-W.HK 看好哔哩哔哩 | NaN | https://longportapp.com/topics/10021107 |
| 5 | longport | 2023-09-22 16:51:29 | 投资之路 | 7 | 今天久违的大涨，即是意料之外也是意料之中，因为港股这么跌下去，跌久必弹，做空的迟早要买入平仓... | NaN | https://longportapp.com/topics/9961783 |
| 6 | longport | 2023-09-22 20:41:24 | BTCFREE | 3 | $特斯拉.US 看好特斯拉今天反弹一波，纳指也连续大跌三天，该反弹了，如果进一步下跌，那就是... | NaN | https://longportapp.com/topics/9964781 |
| 7 | longport | 2023-09-27 16:33:25 | 海豚投研 | 3 | 今日重点消息回顾｜海豚投研 0927 海豚君重点关注： 🐬 宏观/行业 1、国家统计局最新数... | 今日重点消息回顾｜海豚投研 | https://longportapp.com/topics/10023801 |
| 8 | longport | 2023-09-26 21:54:05 | BTCFREE | 4 | $纳斯达克综合指数.US 指数跳水成这样，但很多热门股已经开始明显抗跌了，好戏在后面。哈哈 | NaN | https://longportapp.com/topics/10012627 |
| 9 | longport | 2023-09-27 14:01:39 | Reuters | 0 | 《DOLAN 专栏》第四季 “未知的未知因素” 让市场畏惧 路透伦敦 9 月 27 日 - ... | 《DOLAN 专栏》第四季 “未知的未知因素” 让市场畏惧 | https://longportapp.com/news/98664948 |
| 10 | longport | 2023-09-23 18:46:57 | BTCFREE | 5 | $特斯拉.US 考验支撑的时候又要到了。。。 Preview | NaN | https://longportapp.com/topics/9973593 |
| 11 | longport | 2023-09-26 22:35:25 | 陈达美股投资 | 2 | 景林资产说，近期出现了继 “2014 年 930-2015 年 330” 期间以来最大幅度的... | NaN | https://longportapp.com/topics/10013333 |
| 12 | longport | 2023-09-27 15:37:47 | 芝能-烟烟 | 3 | 长安在深蓝之外，也平行开始推进启源这个品牌。 长安启源 A07 价格区间为 15.59 万元... | NaN | https://longportapp.com/topics/10023199 |
| 13 | longport | 2023-09-26 21:07:25 | 股神-叶 | 0 | $特斯拉.US236 一波 | NaN | https://longportapp.com/topics/10011938 |
| 14 | longport | 2023-09-26 17:57:06 | 长湾资讯 | 4 | 大行速睇 | “阿里妈妈 + 腾讯广告” 大获看好，股价还能涨 60%？ 中金认为，这一合作... | 大行速睇 | “阿里妈妈 + 腾讯广告” 大获看好，股价还能涨 60%？ | https://longportapp.com/news/98590942 |
| 15 | longport | 2023-09-27 00:22:32 | Reuters | 0 | BUZZ-美国联邦贸易委员会提起反垄断诉讼后，亚马逊损失扩大 ** 联邦贸易委员会指控 (l... | BUZZ-美国联邦贸易委员会提起反垄断诉讼后，亚马逊损失扩大 | https://longportapp.com/news/98628259 |
| 16 | longport | 2023-09-27 15:56:51 | DoDo_Go | 1 | $恒生指数.HK内资还不出手护盘一下 | NaN | https://longportapp.com/topics/10023328 |
| 17 | longport | 2023-09-27 11:20:50 | 长湾资讯 | 0 | 腾讯十年涨了 1623%！港股科技股新一轮上涨何时开始？ 恒生科技指数为什么可以成为港股消费... | 腾讯十年涨了 1623%！港股科技股新一轮上涨何时开始？ | https://longportapp.com/news/98655586 |
| 18 | longport | 2023-09-27 13:00:10 | Reuters | 0 | 分析 - 更高更长期 "利率的残酷现实笼罩美股 路透纽约 9 月 27 日 - 随着美联储的... | 分析 - 更高更长期 "利率的残酷现实笼罩美股 | https://longportapp.com/news/98661575 |
| 19 | longport | 2023-09-25 20:10:37 | 长湾资讯 | 0 | 自动驾驶还很遥远，但特斯拉 FSD 依旧是首选 马斯克相信，算力的指数级增长，即人工智能效应... | 自动驾驶还很遥远，但特斯拉 FSD 依旧是首选 | https://longportapp.com/news/98504287 |
| 20 | longport | 2023-09-27 18:44:39 | 不二研究 | 0 | 主品牌营收增速下滑，安踏何寻下一个 “安踏”？ 亚运会刷屏，国潮运动品牌 “出圈”。$安踏体... | 主品牌营收增速下滑，安踏何寻下一个 “安踏”？ | https://longportapp.com/topics/10025068 |
| 21 | longport | 2023-09-25 16:05:50 | 王海天港美互联网 | 4 | 双 11 前夕阿里腾讯合作深化，微信广告可直跳淘宝天猫 双 11 前夕，阿里妈妈与腾讯广告宣... | NaN | https://longportapp.com/topics/9992114 |
| 22 | longport | 2023-09-25 21:49:37 | 仙寻 | 12 | $特斯拉.US 长期还是看好的，短期内回调也能赚点零花钱 Preview | NaN | https://longportapp.com/topics/9996633 |
| 23 | longport | 2023-09-26 22:38:17 | 朱玉龙-YL | 4 | 本次华为回归，小米受影响不小。雷总也是积极应对，大环境不好加上华为强势归来，这事业还要打下去... | NaN | https://longportapp.com/topics/10013314 |
| 24 | longport | 2023-09-26 22:42:18 | MikeXu | 3 | 只分享挣钱的期权单子😂 $苹果.US Preview | NaN | https://longportapp.com/topics/10013352 |
| 25 | longport | 2023-09-26 22:05:49 | 估神MattC | 0 | 稳稳阵阵收息 Preview | NaN | https://longportapp.com/topics/10012867 |
| 26 | longport | 2023-09-27 15:01:54 | 朱玉龙-YL | 0 | 2023 年 1-8 月，汽车制造业利润率为 4.9% Preview | NaN | https://longportapp.com/topics/10022916 |
| 27 | longport | 2023-09-27 15:39:53 | 京城Z先生 | 16 | 菜鸟先飞，拆分上市；出海遇阻，前景存疑 阿里巴巴集团前几年处在舆论和监管的风口浪尖上，最终被... | 菜鸟先飞，拆分上市；出海遇阻，前景存疑 | https://longportapp.com/topics/10022174 |
| 28 | longport | 2023-09-27 13:58:04 | Black Start | 0 | @PortAI 如何看待腾讯大跌，后续走势分析 | NaN | https://longportapp.com/topics/10021641 |
| 29 | longport | 2023-09-26 20:40:02 | 朱玉龙-YL | 5 | 宝骏今天发布的具备智驾能力的云朵灵犀版，前段时间烟总已经去试驾过了。 先说这个版本主要的智驾... | NaN | https://longportapp.com/topics/10011525 |
| 30 | longport | 2023-09-11 07:37:06 | Tesla Fans | 6 | 游戏公司 Roblox$罗布乐思.US 透过网志公布，计划于 10 月在 Sony Play... | NaN | https://longportapp.com/topics/9775578 |
| 31 | longport | 2023-09-27 11:28:16 | 付轶啸 | 3 | 途虎-W 股价异动解读 途虎-W 在上市次日再次表现强劲，股价涨幅超过 6%，高见 31.4... | 途虎-W 股价异动解读 | https://longportapp.com/topics/10020090 |
| 32 | longport | 2023-09-27 10:35:04 | 朱玉龙-YL | 2 | 小鹏 X9（5293/1988/1785）相比极氪 009（5209/2024/1856）视... | NaN | https://longportapp.com/topics/10019012 |
| 33 | longport | 2023-09-27 11:25:40 | 付轶啸 | 4 | 医思健康 股价异动解读 医思健康的股价在开盘时涨幅超过 25%，截至发稿，涨幅为 10.31... | 医思健康 股价异动解读 | https://longportapp.com/topics/10020051 |
| 34 | longport | 2023-09-27 06:17:41 | Reuters | 0 | **** 主要国家经济指标预测--9 月 27 日 **** 以下为全球主要国家及地区今日稍... | **** 主要国家经济指标预测--9 月 27 日 **** | https://longportapp.com/news/98637197 |
| 35 | longport | 2023-09-27 18:29:30 | 新浪财经 | 0 | 来源：格隆汇 格隆汇9月27日丨腾讯控股(00700.HK)发布公告，公司将于2023年11... | 腾讯控股将于 11 月 15 日举行董事会会议以审批第三季度业绩 | https://finance.sina.com.cn/stock/hkstock/ggsc... |
| 36 | longport | 2023-09-26 09:25:21 | 乐观的小散户 | 6 | 美元预计仍将加息一次，对人民币资产造成较大冲击。虽然中概股估值水平普遍偏低，但预计后市在流动... | NaN | https://longportapp.com/topics/10000942 |
| 37 | longport | 2023-09-27 18:04:42 | 新浪财经 | 0 | 据官方消息，阿里云盘合作开发者再增一员，视频播放器Infuse在最新升级的版本中，已正式支持... | Infuse 重大更新，阿里云盘成国内首个接入的 “网盘” | https://finance.sina.com.cn/stock/relnews/us/2... |
| 38 | longport | 2023-09-27 17:02:59 | 新浪财经 | 0 | 快科技9月27日消息，此前有爆料称，苹果正在开发一款价格更便宜的Vision Pro，其价格... | 取代 iPhone 难上加难！曝苹果砍掉了低配版 Vision Pro：销量不被看好 | https://finance.sina.com.cn/tech/roll/2023-09-... |
| 39 | longport | 2023-09-08 00:01:18 | 冲57 | 6 | 我很兴奋，我终于从↪️ ALICIALEOFXX 平台赚取了我的第一笔利润，尤其是在由于缺乏... | NaN | https://longportapp.com/topics/9718973 |
| 40 | longport | 2023-09-25 18:28:16 | 陈达美股投资 | 3 | 好征兆！ 淘宝、天猫商家迎双 11 新流量红利。9 月 25 日，阿里妈妈与腾讯广告进一步深... | NaN | https://longportapp.com/topics/9993942 |
| 41 | longport | 2023-09-25 17:56:18 | Tesla Fans | 7 | $亚马逊.US 向 OpenAI 竞争对手，人工智能初创公司 Anthropic 投资最多 ... | NaN | https://longportapp.com/topics/9993466 |
In [6]:
import requests
cookies = {
'ems-tax-security': 'ba6f2222-03f1-4857-8efd-7894d4e4588d',
'token': '3V00iAe7Cg0f0U02M2TqWnau7V1juffWuF22KFN4zKDKp2q2G8bZ92ivJLbXARnq',
'em-tax-group': 'b0256f45-39b2-4e77-96a5-35136e17871b',
}
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0',
'Accept': 'application/json, text/plain, */*',
'Accept-Language': 'zh-CN,zh;q=0.8,zh-TW;q=0.7,zh-HK;q=0.5,en-US;q=0.3,en;q=0.2',
'Accept-Encoding': 'gzip, deflate, br',
'token': '3V00iAe7Cg0f0U02M2TqWnau7V1juffWuF22KFN4zKDKp2q2G8bZ92ivJLbXARnq',
'Content-Type': 'multipart/form-data; boundary=---------------------------3128275024212953721707238934',
'Origin': 'https://emtaxtest.dfcfw.com',
'Connection': 'keep-alive',
'Referer': 'https://emtaxtest.dfcfw.com/securitytaxmgr/invoiceTicket/invoicedSearch',
'Sec-Fetch-Dest': 'empty',
'Sec-Fetch-Mode': 'cors',
'Sec-Fetch-Site': 'same-origin',
'Pragma': 'no-cache',
'Cache-Control': 'no-cache',
}
data = '$-----------------------------3128275024212953721707238934\\r\\nContent-Disposition: form-data; name="fileList[0]"; filename="dzfp_24312000000035764749_\\xe4\\xb8\\x8a\\xe6\\xb5\\xb7\\xe4\\xbd\\xa0\\xe6\\x88\\x91\\xe4\\xbb\\x96\\xe5\\xbf\\xab\\xe9\\xa4\\x90\\xe9\\xa3\\x9f\\xe5\\x93\\x81\\xe6\\x9c\\x89 \\xe9\\x99\\x90\\xe5\\x85\\xac\\xe5\\x8f\\xb8_20240201193628.pdf"\\r\\nContent-Type: application/pdf\\r\\n\\r\\n-----------------------------3128275024212953721707238934--\\r\\n'
response = requests.post('http://localhost:20799/invoice/apply/allElectricInvoice/pdfImport', headers=headers, cookies=cookies, data=data)
response.json()
Out[6]:
{'code': '10001', 'data': None, 'msg': '文件列表不能为空', 'success': False}
In [1]:
import pandas as pd
In [34]:
tax = pd.read_csv('d:/temp/cw_tax.csv', dtype=str)
tax_sec = pd.read_csv('d:/temp/cw_tax_sec.csv', dtype=str)
In [65]:
res = tax.query("parent_id == '1599602568526499840'")
for it in res.itertuples():
print(it)
Pandas(Index=227, id='1599603925312540672', menu_name='蓝字发票开票申请单', menu_code='buleInvoiceApplyView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:17:50', update_time='2023-03-21 18:50:59', permission='buleInvoiceApplyView') Pandas(Index=228, id='1599604007831277568', menu_name='红字发票开票申请单', menu_code='redInvoiceApplyView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:18:09', update_time='2023-03-21 18:51:11', permission='redInvoiceApplyView') Pandas(Index=229, id='1599604208298037248', menu_name='蓝字发票待开票清单', menu_code='buleUnInvoicedView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:18:57', update_time='2023-03-21 18:51:39', permission='buleUnInvoicedView') Pandas(Index=230, id='1599604306495082496', menu_name='红字发票待开票清单', menu_code='redUnInvoicedView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:19:21', update_time='2023-03-21 18:51:53', permission='redUnInvoicedView') Pandas(Index=231, id='1599604442549915648', menu_name='已开发票查询', menu_code='invoicedView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1', create_time='2022-12-05 11:19:53', update_time='2022-12-05 11:19:53', permission='invoicedView')
In [36]:
# 使用外连接合并两个DataFrame，并设置indicator为True
merged = pd.merge(tax, tax_sec, on='id', how='outer', indicator=True)
# 筛选出仅在左边或右边DataFrame中的数据项
diff = merged.loc[merged['_merge'] != 'both']
# 如果你想分别看哪些是仅存在于第一个文件中和哪些是仅存在于第二个文件中的数据，可以这样做：
only_in_first = merged.loc[merged['_merge'] == 'left_only']
only_in_second = merged.loc[merged['_merge'] == 'right_only']
In [99]:
本月同比环比分析表
Out[99]:
| id | menu_name | menu_code | menu_type | api | parent_id | create_user | update_user | create_time | update_time | permission | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 549 | 1645349599270010880 | 本月同比环比分析表 | taxMY | 2 | NaN | 1645347411617513472 | 1 | 1 | 2023-04-10 16:54:48 | 2023-04-10 16:54:48 | taxMY |
In [110]:
ls = list(map(str.strip, '''本月同比环比分析表,申报任务定义,审批流配置,纳税优惠配置,管理地区定义,涉税文档类型配置,涉税文档管理,
综合管理服务台,发票开具管理,进项管理,土地基本信息统计表,房产基本信息统计表,装修原值统计表,房产租赁基础信息表,
房土税计提,房土税申报'''.split(",")))
ls
Out[110]:
['本月同比环比分析表', '申报任务定义', '审批流配置', '纳税优惠配置', '管理地区定义', '涉税文档类型配置', '涉税文档管理', '综合管理服务台', '发票开具管理', '进项管理', '土地基本信息统计表', '房产基本信息统计表', '装修原值统计表', '房产租赁基础信息表', '房土税计提', '房土税申报']
In [114]:
all_need_add_menu = []
for name in ls:
all_need_add_menu.append(tax.query("menu_name == @name"))
all_need_add_menu_df: pd.DataFrame = pd.concat(all_need_add_menu)
all_need_add_menu_df
Out[114]:
| id | menu_name | menu_code | menu_type | api | parent_id | create_user | update_user | create_time | update_time | permission | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 549 | 1645349599270010880 | 本月同比环比分析表 | taxMY | 2 | NaN | 1645347411617513472 | 1 | 1 | 2023-04-10 16:54:48 | 2023-04-10 16:54:48 | taxMY |
| 208 | 1592691550819512320 | 申报任务定义 | taskDefine | 2 | NaN | 1592690968444596224 | 1565274613801476096 | 1565274613801476096 | 2022-11-16 09:30:31 | 2022-11-16 14:05:18 | taskDefine |
| 469 | 1608289647016005632 | 审批流配置 | auditFlowConfig | 2 | NaN | 1592690968444596224 | 1 | 1 | 2022-12-29 10:31:47 | 2022-12-29 10:31:47 | auditFlowConfig |
| 23 | 1565270869751836672 | 纳税优惠配置 | basicInfomationTaxpayerPreference | 2 | NaN | 1592690968444596224 | 1 | 1572187849792675840 | 2022-09-01 17:30:31 | 2023-03-21 18:50:11 | basicInfomation:taxpayerPreference:view |
| 576 | 1693866848913960960 | 管理地区定义 | administrativearea | 2 | NaN | 1592690968444596224 | 1 | 1 | 2023-08-22 14:05:02 | 2023-08-22 14:05:02 | administrativearea |
| 8 | 1565266914233757696 | 涉税文档类型配置 | archivesConfig | 2 | NaN | 1565265413947994112 | 1 | 1 | 2022-09-01 17:14:48 | 2022-09-01 17:14:48 | archives:config:view |
| 9 | 1565267119624630272 | 涉税文档管理 | archivesManage | 2 | NaN | 1565265413947994112 | 1 | 1 | 2022-09-01 17:15:37 | 2022-09-01 17:15:37 | archives:manage:view |
| 3 | 1565264930571235328 | 综合管理服务台 | servicedesk | 1 | NaN | NaN | 1 | 1 | 2022-09-01 17:06:55 | 2022-09-01 17:06:55 | servicedesk:view |
| 220 | 1599602568526499840 | 发票开具管理 | invoiceApplyManageView | 2 | NaN | 1599601283165261824 | 1 | 1 | 2022-12-05 11:12:26 | 2022-12-05 11:12:26 | invoiceApplyManageView |
| 259 | 1600045102084108288 | 进项管理 | vatInput | 2 | NaN | 1600044503791808512 | 1565274613801476096 | 1 | 2022-12-06 16:30:54 | 2023-01-03 14:52:32 | vatInput |
| 127 | 1590613387347488768 | 土地基本信息统计表 | landInformation | 2 | NaN | 1589094565830381568 | 1 | 1 | 2022-11-10 15:52:38 | 2022-11-10 15:52:38 | landInformation |
| 116 | 1589095091057905664 | 房产基本信息统计表 | build | 2 | NaN | 1589094565830381568 | 1 | 1 | 2022-11-06 11:19:28 | 2022-11-06 11:19:28 | build |
| 117 | 1589095210415214592 | 装修原值统计表 | decoration | 2 | NaN | 1589094565830381568 | 1 | 1 | 2022-11-06 11:19:57 | 2022-11-06 11:19:57 | decoration |
| 118 | 1589095322541543424 | 房产租赁基础信息表 | lease | 2 | NaN | 1589094565830381568 | 1 | 1 | 2022-11-06 11:20:24 | 2022-11-06 11:20:24 | lease |
| 554 | 1647888849156833280 | 房土税计提 | buildingProvision | 2 | NaN | 1589094565830381568 | 1565274613801476096 | 1565274613801476096 | 2023-04-17 17:04:53 | 2023-04-17 17:04:53 | buildingProvision |
| 115 | 1589094565830381568 | 房土税申报 | buildingReportView | 1 | NaN | NaN | 1 | 1 | 2022-11-06 11:17:23 | 2022-11-06 11:17:23 | buildingReport |
| 120 | 1589096660079923200 | 房土税申报 | buildingReport | 2 | NaN | 1589094565830381568 | 1 | 1 | 2022-11-06 11:25:42 | 2022-11-06 11:25:42 | buildingReport |
In [93]:
len(tax), len(tax_sec)
Out[93]:
(580, 560)
In [115]:
data = []
ind = 0
def get_children(pid):
global ind
res = tax.query("parent_id == @pid")
for it in res.itertuples():
ind += 1
print(ind, it)
data.append(it)
get_children(it[1])
# for it in merged.loc[merged['_merge'] == 'left_only'].itertuples():
for it in all_need_add_menu_df.itertuples():
ind += 1
data.append(it)
# get_children('1599602568526499840')
get_children(it[1])
2 Pandas(Index=570, id='1681926435995951104', menu_name='按集团创建', menu_code='createMYByGroup', menu_type='3', api=nan, parent_id='1645349599270010880', create_user='1', update_user='1', create_time='2023-07-20 15:18:06', update_time='2023-07-20 15:18:06', permission='createMYByGroup') 3 Pandas(Index=571, id='1681927183710330880', menu_name='按税号创建', menu_code='createMYByTaxpayerNo', menu_type='3', api=nan, parent_id='1645349599270010880', create_user='1', update_user='1', create_time='2023-07-20 15:21:04', update_time='2023-07-20 15:21:04', permission='createMYByTaxpayerNo') 5 Pandas(Index=209, id='1592691943813214208', menu_name='添加申报任务定义', menu_code='taskDefineAdd', menu_type='3', api=nan, parent_id='1592691550819512320', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:32:05', update_time='2022-11-16 09:32:31', permission='taskDefineAdd') 6 Pandas(Index=210, id='1592692154837037056', menu_name='申报任务定义删除', menu_code='taskDefineDel', menu_type='3', api=nan, parent_id='1592691550819512320', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:32:55', update_time='2022-11-16 14:06:20', permission='taskDefineDel') 7 Pandas(Index=211, id='1592692222155616256', menu_name='申报任务定义导出', menu_code='taskDefineExport', menu_type='3', api=nan, parent_id='1592691550819512320', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:33:11', update_time='2022-11-16 09:33:11', permission='taskDefineExport') 8 Pandas(Index=212, id='1592692688188928000', menu_name='申报任务定义查看', menu_code='taskDefineSearch', menu_type='3', api=nan, parent_id='1592691550819512320', create_user='1565274613801476096', update_user='1565280124605255680', create_time='2022-11-16 09:35:02', update_time='2022-11-16 15:13:08', permission='taskDefineSearch') 9 Pandas(Index=213, id='1592692806657044480', menu_name='申报任务定义编辑', menu_code='taskDefineEdit', menu_type='3', api=nan, parent_id='1592691550819512320', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:35:31', update_time='2022-11-16 09:35:31', permission='taskDefineEdit') 11 Pandas(Index=470, id='1608328624041324544', menu_name='审批流配置查询', menu_code='auditFlowConfigSearch', menu_type='3', api=nan, parent_id='1608289647016005632', create_user='1', update_user='1', create_time='2022-12-29 13:06:40', update_time='2022-12-29 13:06:40', permission='auditFlowConfigSearch') 12 Pandas(Index=471, id='1608328714634096640', menu_name='审批流配置新增', menu_code='auditFlowConfigAdd', menu_type='3', api=nan, parent_id='1608289647016005632', create_user='1', update_user='1', create_time='2022-12-29 13:07:02', update_time='2022-12-29 13:07:02', permission='auditFlowConfigAdd') 13 Pandas(Index=472, id='1608329107388723200', menu_name='审批流配置删除', menu_code='auditFlowConfigDel', menu_type='3', api=nan, parent_id='1608289647016005632', create_user='1', update_user='1', create_time='2022-12-29 13:08:35', update_time='2022-12-29 13:08:35', permission='auditFlowConfigDel') 14 Pandas(Index=473, id='1608329249164587008', menu_name='审批流步骤配置', menu_code='auditFlowConfigStep', menu_type='3', api=nan, parent_id='1608289647016005632', create_user='1', update_user='1', create_time='2022-12-29 13:09:09', update_time='2022-12-29 13:09:09', permission='auditFlowConfigStep') 15 Pandas(Index=496, id='1612622837974106112', menu_name='审批流配置编辑', menu_code='auditFlowConfigEdit', menu_type='3', api=nan, parent_id='1608289647016005632', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2023-01-10 09:30:20', update_time='2023-01-10 09:30:20', permission='auditFlowConfigEdit') 17 Pandas(Index=59, id='1589080441700405248', menu_name='查询有效的纳税主体', menu_code='perfenrenceTaxpayerSearch', menu_type='3', api=nan, parent_id='1565270869751836672', create_user='1', update_user='1', create_time='2022-11-06 10:21:16', update_time='2022-11-06 10:21:16', permission='perfenrenceTaxpayerSearch') 18 Pandas(Index=60, id='1589080876473569280', menu_name='查询税收优惠', menu_code='taxpayerPreferenceSearch', menu_type='3', api=nan, parent_id='1565270869751836672', create_user='1', update_user='1', create_time='2022-11-06 10:22:59', update_time='2022-11-06 10:22:59', permission='taxpayerPreferenceSearch') 19 Pandas(Index=61, id='1589081201465020416', menu_name='纳税主体配置税收优惠', menu_code='taxpayerPreferenceAdd', menu_type='3', api=nan, parent_id='1565270869751836672', create_user='1', update_user='1', create_time='2022-11-06 10:24:17', update_time='2022-11-06 10:24:17', permission='taxpayerPreferenceAdd') 20 Pandas(Index=62, id='1589081339801554944', menu_name='纳税主体删除税收优惠', menu_code='taxpayerPreferenceDel', menu_type='3', api=nan, parent_id='1565270869751836672', create_user='1', update_user='1', create_time='2022-11-06 10:24:50', update_time='2022-11-06 10:24:50', permission='taxpayerPreferenceEdit') 21 Pandas(Index=63, id='1589081838755958784', menu_name='纳税主体编辑税收优惠', menu_code='taxpayerPreferenceEdit', menu_type='3', api=nan, parent_id='1565270869751836672', create_user='1', update_user='1', create_time='2022-11-06 10:26:49', update_time='2022-11-06 10:26:49', permission='taxpayerPreferenceEdit') 24 Pandas(Index=75, id='1589085282996768768', menu_name='添加涉税文档目录', menu_code='docRelatedClassifyAdd', menu_type='3', api=nan, parent_id='1565266914233757696', create_user='1', update_user='1', create_time='2022-11-06 10:40:30', update_time='2022-11-06 10:40:30', permission='docRelatedClassifyAdd') 25 Pandas(Index=76, id='1589085430200061952', menu_name='编辑涉税文档目录', menu_code='docRelatedClassifyEdit', menu_type='3', api=nan, parent_id='1565266914233757696', create_user='1', update_user='1', create_time='2022-11-06 10:41:05', update_time='2022-11-06 10:41:05', permission='docRelatedClassifyEdit') 26 Pandas(Index=77, id='1589086805902413824', menu_name='删除涉税文档目录', menu_code='docRelatedClassifyDel', menu_type='3', api=nan, parent_id='1565266914233757696', create_user='1', update_user='1', create_time='2022-11-06 10:46:33', update_time='2022-11-06 10:46:33', permission='docRelatedClassifyDel') 27 Pandas(Index=203, id='1592689391830888448', menu_name='查询涉税文档目录', menu_code='docRelatedClassifySearch', menu_type='3', api=nan, parent_id='1565266914233757696', create_user='1', update_user='1', create_time='2022-11-16 09:21:56', update_time='2022-11-16 09:21:56', permission='docRelatedClassifySearch') 29 Pandas(Index=78, id='1589087049411121152', menu_name='查询涉税文档', menu_code='docRelatedRecordSearch', menu_type='3', api=nan, parent_id='1565267119624630272', create_user='1', update_user='1', create_time='2022-11-06 10:47:31', update_time='2022-11-06 10:47:31', permission='docRelatedRecordSearch') 30 Pandas(Index=79, id='1589087194374656000', menu_name='涉税文档添加', menu_code='docRelatedRecordAdd', menu_type='3', api=nan, parent_id='1565267119624630272', create_user='1', update_user='1', create_time='2022-11-06 10:48:06', update_time='2022-11-06 10:48:06', permission='docRelatedRecordAdd') 31 Pandas(Index=80, id='1589087284166316032', menu_name='涉税文档导出', menu_code='docRelatedRecordExport', menu_type='3', api=nan, parent_id='1565267119624630272', create_user='1', update_user='1', create_time='2022-11-06 10:48:27', update_time='2022-11-06 10:48:27', permission='docRelatedRecordExport') 32 Pandas(Index=81, id='1589087432309133312', menu_name='涉税文档编辑', menu_code='docRelatedRecordEdit', menu_type='3', api=nan, parent_id='1565267119624630272', create_user='1', update_user='1', create_time='2022-11-06 10:49:02', update_time='2022-11-06 10:49:02', permission='docRelatedRecordEdit') 33 Pandas(Index=82, id='1589087610311200768', menu_name='涉税文档删除', menu_code='docRelatedRecordDel', menu_type='3', api=nan, parent_id='1565267119624630272', create_user='1', update_user='1', create_time='2022-11-06 10:49:45', update_time='2022-11-06 10:49:45', permission='docRelatedRecordDel') 35 Pandas(Index=12, id='1565268161066119168', menu_name='通知公告管理', menu_code='servicedeskNotice', menu_type='2', api=nan, parent_id='1565264930571235328', create_user='1', update_user='1', create_time='2022-09-01 17:19:46', update_time='2022-09-01 17:19:46', permission='servicedesk:notice:view') 36 Pandas(Index=83, id='1589088609176309760', menu_name='查询通知公告', menu_code='noticeInfoSearch', menu_type='3', api=nan, parent_id='1565268161066119168', create_user='1', update_user='1', create_time='2022-11-06 10:53:43', update_time='2022-11-06 10:53:43', permission='noticeInfoSearch') 37 Pandas(Index=84, id='1589088731142475776', menu_name='添加通知公告', menu_code='noticeInfoAdd', menu_type='3', api=nan, parent_id='1565268161066119168', create_user='1', update_user='1', create_time='2022-11-06 10:54:12', update_time='2022-11-06 10:54:12', permission='noticeInfoAdd') 38 Pandas(Index=85, id='1589088906095284224', menu_name='编辑通知公告', menu_code='noticeInfoEdit', menu_type='3', api=nan, parent_id='1565268161066119168', create_user='1', update_user='1', create_time='2022-11-06 10:54:54', update_time='2022-11-06 10:54:54', permission='noticeInfoEdit') 39 Pandas(Index=86, id='1589089017147871232', menu_name='删除通知公告', menu_code='noticeInfoDel', menu_type='3', api=nan, parent_id='1565268161066119168', create_user='1', update_user='1', create_time='2022-11-06 10:55:20', update_time='2022-11-06 10:55:20', permission='noticeInfoDel') 40 Pandas(Index=170, id='1590645624688287744', menu_name='管理员导出公告', menu_code='noticeInfoExport', menu_type='3', api=nan, parent_id='1565268161066119168', create_user='1', update_user='1', create_time='2022-11-10 18:00:44', update_time='2022-11-10 18:00:44', permission='noticeInfoExport') 41 Pandas(Index=13, id='1565268413919735808', menu_name='税务日历管理（管理员）', menu_code='servicedeskCalendarAdmin', menu_type='2', api=nan, parent_id='1565264930571235328', create_user='1', update_user='1', create_time='2022-09-01 17:20:46', update_time='2022-09-01 17:20:46', permission='servicedesk:calendarAdmin:view') 42 Pandas(Index=91, id='1589089994944991232', menu_name='查询管理员日历', menu_code='calendarAdminSearch', menu_type='3', api=nan, parent_id='1565268413919735808', create_user='1', update_user='1', create_time='2022-11-06 10:59:13', update_time='2022-11-06 10:59:13', permission='calendarAdminSearch') 43 Pandas(Index=92, id='1589090071843360768', menu_name='添加管理员日历', menu_code='calendarAdminAdd', menu_type='3', api=nan, parent_id='1565268413919735808', create_user='1', update_user='1', create_time='2022-11-06 10:59:32', update_time='2022-11-06 10:59:32', permission='calendarAdminAdd') 44 Pandas(Index=93, id='1589090227020025856', menu_name='编辑管理员日历', menu_code='calendarAdminEdit', menu_type='3', api=nan, parent_id='1565268413919735808', create_user='1', update_user='1', create_time='2022-11-06 11:00:09', update_time='2022-11-06 11:00:09', permission='calendarAdminEdit') 45 Pandas(Index=94, id='1589090352501018624', menu_name='删除管理员日历', menu_code='calendarAdminDel', menu_type='3', api=nan, parent_id='1565268413919735808', create_user='1', update_user='1', create_time='2022-11-06 11:00:39', update_time='2022-11-06 11:00:39', permission='calendarAdminDel') 46 Pandas(Index=14, id='1565268557432041472', menu_name='税务日历管理（个人）', menu_code='servicedeskCalendarPersonal', menu_type='2', api=nan, parent_id='1565264930571235328', create_user='1', update_user='1', create_time='2022-09-01 17:21:20', update_time='2022-09-01 17:21:20', permission='servicedesk:calendarPersonal:view') 47 Pandas(Index=87, id='1589089545340768256', menu_name='查询个人日历', menu_code='calendarPersonalSearch', menu_type='3', api=nan, parent_id='1565268557432041472', create_user='1', update_user='1', create_time='2022-11-06 10:57:26', update_time='2022-11-06 10:57:26', permission='calendarPersonalSearch') 48 Pandas(Index=88, id='1589089631810539520', menu_name='添加个人日历', menu_code='calendarPersonalAdd', menu_type='3', api=nan, parent_id='1565268557432041472', create_user='1', update_user='1', create_time='2022-11-06 10:57:47', update_time='2022-11-06 10:57:47', permission='calendarPersonalAdd') 49 Pandas(Index=89, id='1589089797040951296', menu_name='编辑个人日历', menu_code='calendarPersonalEdit', menu_type='3', api=nan, parent_id='1565268557432041472', create_user='1', update_user='1', create_time='2022-11-06 10:58:26', update_time='2022-11-06 10:58:26', permission='calendarPersonalEdit') 50 Pandas(Index=90, id='1589089862308515840', menu_name='删除个人日历', menu_code='calendarPersonalDel', menu_type='3', api=nan, parent_id='1565268557432041472', create_user='1', update_user='1', create_time='2022-11-06 10:58:42', update_time='2022-11-06 10:58:42', permission='calendarPersonalDel') 51 Pandas(Index=15, id='1565268937708613632', menu_name='个人消息', menu_code='servicedeskMessage', menu_type='2', api=nan, parent_id='1565264930571235328', create_user='1', update_user='1', create_time='2022-09-01 17:22:51', update_time='2022-09-01 17:22:51', permission='servicedesk:message:view') 52 Pandas(Index=95, id='1589090747814170624', menu_name='查询个人消息', menu_code='noticeMessageSearch', menu_type='3', api=nan, parent_id='1565268937708613632', create_user='1', update_user='1', create_time='2022-11-06 11:02:13', update_time='2022-11-06 11:02:13', permission='noticeMessageSearch') 53 Pandas(Index=96, id='1589090868563988480', menu_name='确认完成个人消息', menu_code='noticeMessageConfirm', menu_type='3', api=nan, parent_id='1565268937708613632', create_user='1', update_user='1', create_time='2022-11-06 11:02:42', update_time='2022-11-06 11:02:42', permission='noticeMessageConfirm') 54 Pandas(Index=97, id='1589091011728166912', menu_name='继续提醒个人消息', menu_code='noticeMessageStillNotify', menu_type='3', api=nan, parent_id='1565268937708613632', create_user='1', update_user='1', create_time='2022-11-06 11:03:16', update_time='2022-11-06 11:03:16', permission='noticeMessageStillNotify') 55 Pandas(Index=474, id='1608329999320051712', menu_name='审批信息', menu_code='approvalListView', menu_type='2', api=nan, parent_id='1565264930571235328', create_user='1', update_user='1', create_time='2022-12-29 13:12:08', update_time='2022-12-29 13:12:08', permission='approvalListView') 56 Pandas(Index=475, id='1608330333039849472', menu_name='待审批查询', menu_code='approvalListToAudit', menu_type='3', api=nan, parent_id='1608329999320051712', create_user='1', update_user='1', create_time='2022-12-29 13:13:27', update_time='2022-12-29 13:13:27', permission='approvalListToAudit') 57 Pandas(Index=476, id='1608330458478899200', menu_name='已审批查询', menu_code='approvalListAudited', menu_type='3', api=nan, parent_id='1608329999320051712', create_user='1', update_user='1', create_time='2022-12-29 13:13:57', update_time='2022-12-29 13:13:57', permission='approvalListAudited') 58 Pandas(Index=477, id='1608330574958915584', menu_name='我发起的审批查询', menu_code='approvalListMyFlow', menu_type='3', api=nan, parent_id='1608329999320051712', create_user='1', update_user='1', create_time='2022-12-29 13:14:25', update_time='2022-12-29 13:14:25', permission='approvalListMyFlow') 59 Pandas(Index=478, id='1608330825254006784', menu_name='批量通过审批', menu_code='approvalBatchPass', menu_type='3', api=nan, parent_id='1608329999320051712', create_user='1', update_user='1', create_time='2022-12-29 13:15:25', update_time='2022-12-29 13:15:25', permission='approvalBatchPass') 60 Pandas(Index=479, id='1608330908288643072', menu_name='批量拒绝审批', menu_code='approvalBatchReject', menu_type='3', api=nan, parent_id='1608329999320051712', create_user='1', update_user='1', create_time='2022-12-29 13:15:45', update_time='2022-12-29 13:15:45', permission='approvalBatchReject') 61 Pandas(Index=480, id='1608331069576409088', menu_name='查看审批详情', menu_code='approvalDetailSearch', menu_type='3', api=nan, parent_id='1608329999320051712', create_user='1', update_user='1', create_time='2022-12-29 13:16:23', update_time='2022-12-29 13:16:23', permission='approvalDetailSearch') 62 Pandas(Index=481, id='1608331179651723264', menu_name='审批申请单', menu_code='approvalAudit', menu_type='3', api=nan, parent_id='1608329999320051712', create_user='1', update_user='1', create_time='2022-12-29 13:16:49', update_time='2022-12-29 13:16:49', permission='approvalAudit') 64 Pandas(Index=227, id='1599603925312540672', menu_name='蓝字发票开票申请单', menu_code='buleInvoiceApplyView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:17:50', update_time='2023-03-21 18:50:59', permission='buleInvoiceApplyView') 65 Pandas(Index=275, id='1600054219758612480', menu_name='蓝票申请单查询', menu_code='buleInvoiceApplySearch', menu_type='3', api=nan, parent_id='1599603925312540672', create_user='1', update_user='1', create_time='2022-12-06 17:07:08', update_time='2022-12-06 17:07:08', permission='buleInvoiceApplySearch') 66 Pandas(Index=278, id='1600054625683353600', menu_name='蓝票申请单导出', menu_code='buleInvoiceApplyExport', menu_type='3', api=nan, parent_id='1599603925312540672', create_user='1', update_user='1', create_time='2022-12-06 17:08:45', update_time='2022-12-06 17:08:45', permission='buleInvoiceApplyExport') 67 Pandas(Index=280, id='1600054767526326272', menu_name='蓝票申请单明细查询', menu_code='buleInvoiceApplyItemSearch', menu_type='3', api=nan, parent_id='1599603925312540672', create_user='1', update_user='1', create_time='2022-12-06 17:09:19', update_time='2022-12-06 17:09:19', permission='buleInvoiceApplyItemSearch') 68 Pandas(Index=462, id='1606192975411429376', menu_name='蓝票申请单明细导出', menu_code='buleInvoiceItemExport', menu_type='3', api=nan, parent_id='1599603925312540672', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-12-23 15:40:22', update_time='2022-12-23 15:40:22', permission='buleInvoiceItemExport') 69 Pandas(Index=228, id='1599604007831277568', menu_name='红字发票开票申请单', menu_code='redInvoiceApplyView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:18:09', update_time='2023-03-21 18:51:11', permission='redInvoiceApplyView') 70 Pandas(Index=283, id='1600054929137053696', menu_name='红冲申请单查询', menu_code='redInvoiceApplySearch', menu_type='3', api=nan, parent_id='1599604007831277568', create_user='1', update_user='1', create_time='2022-12-06 17:09:57', update_time='2022-12-06 17:09:57', permission='redInvoiceApplySearch') 71 Pandas(Index=284, id='1600055141272367104', menu_name='红冲申请单导出', menu_code='redInvoiceApplyExport', menu_type='3', api=nan, parent_id='1599604007831277568', create_user='1', update_user='1', create_time='2022-12-06 17:10:48', update_time='2022-12-06 17:10:48', permission='redInvoiceApplyExport') 72 Pandas(Index=285, id='1600055268171034624', menu_name='红冲申请单明细查询', menu_code='redInvoiceApplyItemSearch', menu_type='3', api=nan, parent_id='1599604007831277568', create_user='1', update_user='1', create_time='2022-12-06 17:11:18', update_time='2022-12-06 17:11:18', permission='redInvoiceApplyItemSearch') 73 Pandas(Index=463, id='1606193114926563328', menu_name='红票申请单明细导出', menu_code='redInvoiceItemExport', menu_type='3', api=nan, parent_id='1599604007831277568', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-12-23 15:40:55', update_time='2022-12-23 15:40:55', permission='redInvoiceItemExport') 74 Pandas(Index=229, id='1599604208298037248', menu_name='蓝字发票待开票清单', menu_code='buleUnInvoicedView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:18:57', update_time='2023-03-21 18:51:39', permission='buleUnInvoicedView') 75 Pandas(Index=293, id='1600056640614412288', menu_name='蓝票待开票查询', menu_code='buleUninvoicedSearch', menu_type='3', api=nan, parent_id='1599604208298037248', create_user='1', update_user='1', create_time='2022-12-06 17:16:45', update_time='2022-12-06 17:16:45', permission='buleUninvoicedSearch') 76 Pandas(Index=296, id='1600056791802294272', menu_name='蓝票待开票导出', menu_code='buleUninvoicedExport', menu_type='3', api=nan, parent_id='1599604208298037248', create_user='1', update_user='1', create_time='2022-12-06 17:17:21', update_time='2022-12-06 17:17:21', permission='buleUninvoicedExport') 77 Pandas(Index=298, id='1600056947264172032', menu_name='蓝票待开票明细查询', menu_code='buleUninvoicedItemSearch', menu_type='3', api=nan, parent_id='1599604208298037248', create_user='1', update_user='1', create_time='2022-12-06 17:17:59', update_time='2022-12-06 17:17:59', permission='buleUninvoicedItemSearch') 78 Pandas(Index=300, id='1600057370175844352', menu_name='蓝票提交开票', menu_code='buleUninvoicedIssue', menu_type='3', api=nan, parent_id='1599604208298037248', create_user='1', update_user='1', create_time='2022-12-06 17:19:39', update_time='2022-12-06 17:19:39', permission='buleUninvoicedIssue') 79 Pandas(Index=460, id='1606174508079661056', menu_name='蓝票申请回退', menu_code='buleUninvoicedReturn', menu_type='3', api=nan, parent_id='1599604208298037248', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-12-23 14:26:59', update_time='2022-12-23 14:26:59', permission='buleUninvoicedReturn') 80 Pandas(Index=464, id='1606193266693259264', menu_name='蓝票未开票明细导出', menu_code='buleUnInvoicedItemExport', menu_type='3', api=nan, parent_id='1599604208298037248', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-12-23 15:41:31', update_time='2022-12-23 15:41:31', permission='buleUnInvoicedItemExport') 81 Pandas(Index=230, id='1599604306495082496', menu_name='红字发票待开票清单', menu_code='redUnInvoicedView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1572187849792675840', create_time='2022-12-05 11:19:21', update_time='2023-03-21 18:51:53', permission='redUnInvoicedView') 82 Pandas(Index=302, id='1600057504355823616', menu_name='红冲待开票查询', menu_code='redUninvoicedSearch', menu_type='3', api=nan, parent_id='1599604306495082496', create_user='1', update_user='1', create_time='2022-12-06 17:20:11', update_time='2022-12-06 17:20:11', permission='redUninvoicedSearch') 83 Pandas(Index=304, id='1600057624287752192', menu_name='红冲待开票导出', menu_code='redUninvoicedExport', menu_type='3', api=nan, parent_id='1599604306495082496', create_user='1', update_user='1', create_time='2022-12-06 17:20:40', update_time='2022-12-06 17:20:40', permission='redUninvoicedExport') 84 Pandas(Index=308, id='1600057883038560256', menu_name='红冲待开票明细查询', menu_code='redUninvoicedItemSearch', menu_type='3', api=nan, parent_id='1599604306495082496', create_user='1', update_user='1', create_time='2022-12-06 17:21:42', update_time='2022-12-06 17:21:42', permission='redUninvoicedItemSearch') 85 Pandas(Index=311, id='1600058036537503744', menu_name='红冲待开票开具发票', menu_code='redUninvoicedIssue', menu_type='3', api=nan, parent_id='1599604306495082496', create_user='1', update_user='1', create_time='2022-12-06 17:22:18', update_time='2022-12-06 17:22:18', permission='redUninvoicedIssue') 86 Pandas(Index=339, id='1600060756182937600', menu_name='红冲待开票明细导出', menu_code='redUnInvoicedItemExport', menu_type='3', api=nan, parent_id='1599604306495082496', create_user='1', update_user='1', create_time='2022-12-06 17:33:07', update_time='2022-12-06 17:33:07', permission='redUnInvoicedItemExport') 87 Pandas(Index=461, id='1606174639952773120', menu_name='红票申请退回', menu_code='redUninvoicedReturn', menu_type='3', api=nan, parent_id='1599604306495082496', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-12-23 14:27:30', update_time='2022-12-23 14:27:30', permission='redUninvoicedReturn') 88 Pandas(Index=231, id='1599604442549915648', menu_name='已开发票查询', menu_code='invoicedView', menu_type='2', api=nan, parent_id='1599602568526499840', create_user='1', update_user='1', create_time='2022-12-05 11:19:53', update_time='2022-12-05 11:19:53', permission='invoicedView') 89 Pandas(Index=314, id='1600058225151160320', menu_name='查询已开发票', menu_code='invoicedSearch', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:23:03', update_time='2022-12-06 17:23:03', permission='invoicedSearch') 90 Pandas(Index=317, id='1600058327097913344', menu_name='已开发票导出', menu_code='invoicedExport', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:23:27', update_time='2022-12-06 17:23:27', permission='invoicedExport') 91 Pandas(Index=318, id='1600058507427819520', menu_name='已开发票作废', menu_code='invoicedInvalid', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:24:10', update_time='2022-12-06 17:24:10', permission='invoicedInvalid') 92 Pandas(Index=319, id='1600058619109552128', menu_name='已开发票打印', menu_code='invoicedPrint', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:24:37', update_time='2022-12-06 17:24:37', permission='invoicedPrint') 93 Pandas(Index=321, id='1600058735228858368', menu_name='已开发票模板导入', menu_code='invoicedImport', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:25:05', update_time='2022-12-06 17:25:05', permission='invoicedImport') 94 Pandas(Index=324, id='1600059003949527040', menu_name='已开发票明细查询', menu_code='invoicedItemSearch', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:26:09', update_time='2022-12-06 17:26:09', permission='invoicedItemSearch') 95 Pandas(Index=326, id='1600059105720119296', menu_name='已开发票明细导出', menu_code='invoicedItemExport', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:26:33', update_time='2022-12-06 17:26:33', permission='invoicedItemExport') 96 Pandas(Index=328, id='1600059378605731840', menu_name='已开发票查看发票', menu_code='invoicedLook', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:27:38', update_time='2022-12-06 17:27:38', permission='invoicedLook') 97 Pandas(Index=329, id='1600059520570339328', menu_name='已开发票下载', menu_code='invoicedDownload', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1', create_time='2022-12-06 17:28:12', update_time='2022-12-06 17:28:12', permission='invoicedDownload') 98 Pandas(Index=331, id='1600059616758312960', menu_name='已开发票短链接获取', menu_code='invoicedGetLink', menu_type='3', api=nan, parent_id='1599604442549915648', create_user='1', update_user='1565274613801476096', create_time='2022-12-06 17:28:35', update_time='2022-12-23 14:28:17', permission='invoicedGetLink') 100 Pandas(Index=388, id='1600299138247020544', menu_name='发票底账库管理', menu_code='invoiceBtmAccLib', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='invoiceBtmAccLib') 101 Pandas(Index=395, id='1600299138247020552', menu_name='导入', menu_code='invoiceBtmAccLibImport', menu_type='3', api=nan, parent_id='1600299138247020544', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='invoiceBtmAccLibImport') 102 Pandas(Index=396, id='1600299138247020553', menu_name='批量删除', menu_code='invoiceBtmAccLibBatchDelete', menu_type='3', api=nan, parent_id='1600299138247020544', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='invoiceBtmAccLibBatchDelete') 103 Pandas(Index=397, id='1600299138247020554', menu_name='查询', menu_code='invoiceBtmAccLibSearch', menu_type='3', api=nan, parent_id='1600299138247020544', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='invoiceBtmAccLibSearch') 104 Pandas(Index=398, id='1600299138247020555', menu_name='导出', menu_code='invoiceBtmAccLibExport', menu_type='3', api=nan, parent_id='1600299138247020544', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='invoiceBtmAccLibExport') 105 Pandas(Index=389, id='1600299138247020545', menu_name='待勾选认证清单管理', menu_code='toBeCheckedList', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='toBeCheckedList') 106 Pandas(Index=399, id='1600299138247020558', menu_name='导入', menu_code='toBeCheckedListImport', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='toBeCheckedListImport') 107 Pandas(Index=400, id='1600299138247020559', menu_name='批量删除', menu_code='toBeCheckedListBatchDelete', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='toBeCheckedListBatchDelete') 108 Pandas(Index=401, id='1600299138247020560', menu_name='查询', menu_code='toBeCheckedListSearch', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='invoiceBtmAccLibSearch') 109 Pandas(Index=402, id='1600299138247020561', menu_name='导出', menu_code='toBeCheckedListExport', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='toBeCheckedListExport') 110 Pandas(Index=403, id='1600299138247020562', menu_name='删除', menu_code='toBeCheckedListDelete', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='toBeCheckedListDelete') 111 Pandas(Index=404, id='1600299138247020563', menu_name='编辑', menu_code='toBeCheckedListEdit', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='toBeCheckedListEdit') 112 Pandas(Index=436, id='1600299138247020605', menu_name='匹配', menu_code='toBeCheckedListMatch', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='toBeCheckedListEdit') 113 Pandas(Index=437, id='1600299138247020606', menu_name='导出待勾选清单', menu_code='ExportToBeCheckedList', menu_type='3', api=nan, parent_id='1600299138247020545', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='ExportToBeCheckedList') 114 Pandas(Index=390, id='1600299138247020546', menu_name='已认证清单管理', menu_code='certifiedList', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='certifiedList') 115 Pandas(Index=405, id='1600299138247020564', menu_name='导入', menu_code='certifiedListImport', menu_type='3', api=nan, parent_id='1600299138247020546', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='certifiedListImport') 116 Pandas(Index=406, id='1600299138247020565', menu_name='批量删除', menu_code='certifiedListBatchDelete', menu_type='3', api=nan, parent_id='1600299138247020546', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='certifiedListDelete') 117 Pandas(Index=407, id='1600299138247020566', menu_name='查询', menu_code='certifiedListSearch', menu_type='3', api=nan, parent_id='1600299138247020546', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='certifiedListSearch') 118 Pandas(Index=408, id='1600299138247020567', menu_name='导出', menu_code='certifiedListExport', menu_type='3', api=nan, parent_id='1600299138247020546', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='certifiedListExport') 119 Pandas(Index=409, id='1600299138247020568', menu_name='删除', menu_code='certifiedListDelete', menu_type='3', api=nan, parent_id='1600299138247020546', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='certifiedListDelete') 120 Pandas(Index=391, id='1600299138247020547', menu_name='根据用途进项转出清单', menu_code='inputTransOut', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='inputTransOut') 121 Pandas(Index=410, id='1600299138247020571', menu_name='重新计算', menu_code='inputTransOutRecal', menu_type='3', api=nan, parent_id='1600299138247020547', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='inputTransOutRecal') 122 Pandas(Index=411, id='1600299138247020572', menu_name='查询', menu_code='inputTransOutSearch', menu_type='3', api=nan, parent_id='1600299138247020547', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='inputTransOutSearch') 123 Pandas(Index=412, id='1600299138247020573', menu_name='导出', menu_code='inputTransOutExport', menu_type='3', api=nan, parent_id='1600299138247020547', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='inputTransOutExport') 124 Pandas(Index=413, id='1600299138247020574', menu_name='上传附件', menu_code='inputTransOutUpload', menu_type='3', api=nan, parent_id='1600299138247020547', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='inputTransOutUpload') 125 Pandas(Index=414, id='1600299138247020575', menu_name='编辑', menu_code='inputTransOutEdit', menu_type='3', api=nan, parent_id='1600299138247020547', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='inputTransOutEdit') 126 Pandas(Index=392, id='1600299138247020548', menu_name='代扣代缴凭证进项清单', menu_code='withholdRemitTax', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTax') 127 Pandas(Index=415, id='1600299138247020576', menu_name='导入', menu_code='withholdRemitTaxImport', menu_type='3', api=nan, parent_id='1600299138247020548', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTaxImport') 128 Pandas(Index=416, id='1600299138247020577', menu_name='批量删除', menu_code='withholdRemitTaxBatchDelete', menu_type='3', api=nan, parent_id='1600299138247020548', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTaxBatchDelete') 129 Pandas(Index=417, id='1600299138247020578', menu_name='查询', menu_code='withholdRemitTaxSearch', menu_type='3', api=nan, parent_id='1600299138247020548', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTaxSearch') 130 Pandas(Index=418, id='1600299138247020579', menu_name='导出', menu_code='withholdRemitTaxExport', menu_type='3', api=nan, parent_id='1600299138247020548', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTaxExport') 131 Pandas(Index=419, id='1600299138247020580', menu_name='删除', menu_code='withholdRemitTaxDelete', menu_type='3', api=nan, parent_id='1600299138247020548', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTaxDelete') 132 Pandas(Index=420, id='1600299138247020581', menu_name='编辑', menu_code='withholdRemitTaxEdit', menu_type='3', api=nan, parent_id='1600299138247020548', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTaxEdit') 133 Pandas(Index=421, id='1600299138247020582', menu_name='添加', menu_code='withholdRemitTaxAdd', menu_type='3', api=nan, parent_id='1600299138247020548', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='withholdRemitTaxAdd') 134 Pandas(Index=393, id='1600299138247020550', menu_name='红字专用发票信息表清单', menu_code='redLetter', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2023-03-21 19:05:21', permission='redLetter') 135 Pandas(Index=423, id='1600299138247020590', menu_name='导入', menu_code='redLetterImport', menu_type='3', api=nan, parent_id='1600299138247020550', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='redLetterImport') 136 Pandas(Index=424, id='1600299138247020591', menu_name='批量删除', menu_code='redLetterBatchDelete', menu_type='3', api=nan, parent_id='1600299138247020550', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='redLetterBatchDelete') 137 Pandas(Index=425, id='1600299138247020592', menu_name='查询', menu_code='redLetterSearch', menu_type='3', api=nan, parent_id='1600299138247020550', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='redLetterSearch') 138 Pandas(Index=426, id='1600299138247020593', menu_name='导出', menu_code='redLetterExport', menu_type='3', api=nan, parent_id='1600299138247020550', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='redLetterExport') 139 Pandas(Index=427, id='1600299138247020594', menu_name='删除', menu_code='redLetterDelete', menu_type='3', api=nan, parent_id='1600299138247020550', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='redLetterDelete') 140 Pandas(Index=428, id='1600299138247020595', menu_name='编辑', menu_code='redLetterEdit', menu_type='3', api=nan, parent_id='1600299138247020550', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='redLetterEdit') 141 Pandas(Index=429, id='1600299138247020596', menu_name='添加', menu_code='redLetterAdd', menu_type='3', api=nan, parent_id='1600299138247020550', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='redLetterAdd') 142 Pandas(Index=394, id='1600299138247020551', menu_name='税控设备购买登记台账', menu_code='taxControlEqup', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='taxControlEqup') 143 Pandas(Index=430, id='1600299138247020598', menu_name='批量删除', menu_code='taxControlEqupBatchDelete', menu_type='3', api=nan, parent_id='1600299138247020551', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='taxControlEqupDelete') 144 Pandas(Index=431, id='1600299138247020599', menu_name='查询', menu_code='taxControlEqupSearch', menu_type='3', api=nan, parent_id='1600299138247020551', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='taxControlEqupSearch') 145 Pandas(Index=432, id='1600299138247020600', menu_name='导出', menu_code='taxControlEqupExport', menu_type='3', api=nan, parent_id='1600299138247020551', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='taxControlEqupExport') 146 Pandas(Index=433, id='1600299138247020601', menu_name='删除', menu_code='taxControlEqupDelete', menu_type='3', api=nan, parent_id='1600299138247020551', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='taxControlEqupDelete') 147 Pandas(Index=434, id='1600299138247020602', menu_name='编辑', menu_code='taxControlEqupEdit', menu_type='3', api=nan, parent_id='1600299138247020551', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='taxControlEqupEdit') 148 Pandas(Index=435, id='1600299138247020603', menu_name='添加', menu_code='taxControlEqupAdd', menu_type='3', api=nan, parent_id='1600299138247020551', create_user='1', update_user='1', create_time='2022-12-07 16:39:11', update_time='2022-12-07 16:39:11', permission='taxControlEqupAdd') 149 Pandas(Index=438, id='1601022294973259776', menu_name='旅客运输进项清单', menu_code='psgTransport', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2022-12-09 09:13:55', update_time='2022-12-09 09:13:55', permission='psgTransport') 150 Pandas(Index=439, id='1601022763502182400', menu_name='查询', menu_code='psgTransportSearch', menu_type='3', api=nan, parent_id='1601022294973259776', create_user='1', update_user='1', create_time='2022-12-09 09:15:47', update_time='2022-12-09 09:15:47', permission='psgTransportSearch') 151 Pandas(Index=440, id='1601022853281259520', menu_name='导出', menu_code='psgTransportExport', menu_type='3', api=nan, parent_id='1601022294973259776', create_user='1', update_user='1', create_time='2022-12-09 09:16:08', update_time='2022-12-09 09:16:08', permission='psgTransportExport') 152 Pandas(Index=441, id='1601022956696018944', menu_name='批量删除', menu_code='psgTransportBatchDelete', menu_type='3', api=nan, parent_id='1601022294973259776', create_user='1', update_user='1', create_time='2022-12-09 09:16:33', update_time='2022-12-09 09:16:33', permission='psgTransportBatchDelete') 153 Pandas(Index=442, id='1601085009276215296', menu_name='导入', menu_code='psgTransportImport', menu_type='3', api=nan, parent_id='1601022294973259776', create_user='1', update_user='1', create_time='2022-12-09 13:23:08', update_time='2022-12-09 13:23:08', permission='psgTransportImport') 154 Pandas(Index=443, id='1601085331436511232', menu_name='编辑', menu_code='psgTransportEdit', menu_type='3', api=nan, parent_id='1601022294973259776', create_user='1', update_user='1', create_time='2022-12-09 13:24:24', update_time='2022-12-09 13:24:24', permission='psgTransportEdit') 155 Pandas(Index=444, id='1601085565344456704', menu_name='添加', menu_code='psgTransportAdd', menu_type='3', api=nan, parent_id='1601022294973259776', create_user='1', update_user='1', create_time='2022-12-09 13:25:20', update_time='2022-12-09 13:25:20', permission='psgTransportAdd') 156 Pandas(Index=577, id='1693879530522128384', menu_name='费控数据交互', menu_code='fkDataControl', menu_type='2', api=nan, parent_id='1600045102084108288', create_user='1', update_user='1', create_time='2023-08-22 14:55:25', update_time='2023-08-22 14:55:25', permission='fkDataControl') 158 Pandas(Index=128, id='1590613831482339328', menu_name='土地基本信息添加', menu_code='landBaseInformationAdd', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:54:24', update_time='2022-11-10 15:54:24', permission='landBaseInformationAdd') 159 Pandas(Index=129, id='1590613921127198720', menu_name='土地基本信息导入', menu_code='landBaseInformationImport', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:54:46', update_time='2022-11-10 15:54:46', permission='landBaseInformationImport') 160 Pandas(Index=130, id='1590613973946068992', menu_name='土地基本信息查询', menu_code='landBaseInformationSearch', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:54:58', update_time='2022-11-10 15:54:58', permission='landBaseInformationImport') 161 Pandas(Index=131, id='1590614157702721536', menu_name='土地基本信息模板下载', menu_code='landBaseInformationTemplateDownload', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:55:42', update_time='2022-11-10 15:55:42', permission='landBaseInformationTemplateDownload') 162 Pandas(Index=132, id='1590614816292335616', menu_name='土地关联一批房产', menu_code='landBaseInformationBuilding', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:58:19', update_time='2022-11-10 15:58:19', permission='landBaseInformationBuilding') 163 Pandas(Index=133, id='1590615038217154560', menu_name='土地基本信息导出', menu_code='landBaseInformationExport', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:59:12', update_time='2022-11-10 15:59:12', permission='landBaseInformationExport') 164 Pandas(Index=134, id='1590615305562091520', menu_name='土地基本信息上传文件', menu_code='landBaseInformationUpload', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 16:00:16', update_time='2022-11-10 16:00:16', permission='landBaseInformationUpload') 165 Pandas(Index=135, id='1590615422801276928', menu_name='土地基本信息编辑', menu_code='landBaseInformationEdit', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 16:00:44', update_time='2022-11-10 16:00:44', permission='landBaseInformationEdit') 166 Pandas(Index=216, id='1592695284278554624', menu_name='删除某个土地下的一个附件', menu_code='landFileListDelete', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:45:21', update_time='2022-11-16 09:45:21', permission='landFileListDelete') 168 Pandas(Index=136, id='1590615638476582912', menu_name='房产基本信息添加', menu_code='buildBaseInformationAdd', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:01:35', update_time='2022-11-10 16:01:35', permission='buildBaseInformationAdd') 169 Pandas(Index=137, id='1590617021187616768', menu_name='房产基本信息查询', menu_code='buildBaseInfomationSearch', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:07:05', update_time='2022-11-10 16:07:05', permission='buildBaseInfomationSearch') 170 Pandas(Index=138, id='1590617140758835200', menu_name='房产基本信息导入', menu_code='buildBaseInfomationImport', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:07:33', update_time='2022-11-10 16:07:33', permission='buildBaseInfomationImport') 171 Pandas(Index=139, id='1590617427900887040', menu_name='房产信息模板下载', menu_code='buildBaseInfomationTemplateDownload', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:08:42', update_time='2022-11-10 16:08:42', permission='buildBaseInfomationTemplateDownload') 172 Pandas(Index=140, id='1590617588047802368', menu_name='房产基本信息导出', menu_code='buildBaseInfomationExport', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:09:20', update_time='2022-11-10 16:09:20', permission='buildBaseInfomationExport') 173 Pandas(Index=141, id='1590617738157748224', menu_name='房产信息文件上传', menu_code='buildBaseInfomationUpload', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:09:56', update_time='2022-11-10 16:09:56', permission='buildBaseInfomationUpload') 174 Pandas(Index=142, id='1590617814158536704', menu_name='房产信息编辑', menu_code='buildBaseInfomationEdit', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:10:14', update_time='2022-11-10 16:10:14', permission='buildBaseInfomationEdit') 175 Pandas(Index=171, id='1592436107094298624', menu_name='房产信息附件删除', menu_code='buildingBaseInfomationDeleteFile', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-15 16:35:29', update_time='2022-11-15 16:35:29', permission='buildingBaseInfomationDeleteFile') 177 Pandas(Index=143, id='1590618003174846464', menu_name='装修原值添加', menu_code='decorationAdd', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1', create_time='2022-11-10 16:10:59', update_time='2022-11-10 16:10:59', permission='decorationAdd') 178 Pandas(Index=144, id='1590618121848483840', menu_name='装修原值查询', menu_code='decorationSearch', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1', create_time='2022-11-10 16:11:27', update_time='2022-11-10 16:11:27', permission='decorationSearch') 179 Pandas(Index=145, id='1590619071325663232', menu_name='装修原值导出', menu_code='decorationExport', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1', create_time='2022-11-10 16:15:14', update_time='2022-11-10 16:15:14', permission='decorationExport') 180 Pandas(Index=146, id='1590619220613525504', menu_name='使装修原值失效', menu_code='decorationEdit', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1565274613801476096', create_time='2022-11-10 16:15:49', update_time='2022-11-10 17:16:57', permission='decorationEdit') 182 Pandas(Index=147, id='1590619663527833600', menu_name='房产租赁基础信息查询', menu_code='buildingLeaseSearch', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:17:35', update_time='2022-11-10 16:17:35', permission='buildingLeaseSearch') 183 Pandas(Index=148, id='1590620128290271232', menu_name='房产租赁信息添加', menu_code='buildingLeaseAdd', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:19:26', update_time='2022-11-10 16:19:26', permission='buildingLeaseAdd') 184 Pandas(Index=149, id='1590622072455032832', menu_name='房产租赁基础信息文件上传', menu_code='buildingLeaseUpload', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:27:09', update_time='2022-11-10 16:27:09', permission='buildingLeaseUpload') 185 Pandas(Index=150, id='1590622167682510848', menu_name='房产租赁信息导出', menu_code='buildingLeaseExport', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:27:32', update_time='2022-11-10 16:27:32', permission='buildingLeaseExport') 186 Pandas(Index=151, id='1590622294082056192', menu_name='房产租赁信息编辑', menu_code='buildingLeaseEdit', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1565274613801476096', create_time='2022-11-10 16:28:02', update_time='2022-11-10 17:23:04', permission='buildingLeaseEdit') 187 Pandas(Index=214, id='1592694147756388352', menu_name='房产租赁信息附件删除', menu_code='buildingLeaseDelFile', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:40:50', update_time='2022-11-16 09:40:50', permission='buildingLeaseDelFile') 190 Pandas(Index=116, id='1589095091057905664', menu_name='房产基本信息统计表', menu_code='build', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1', update_user='1', create_time='2022-11-06 11:19:28', update_time='2022-11-06 11:19:28', permission='build') 191 Pandas(Index=136, id='1590615638476582912', menu_name='房产基本信息添加', menu_code='buildBaseInformationAdd', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:01:35', update_time='2022-11-10 16:01:35', permission='buildBaseInformationAdd') 192 Pandas(Index=137, id='1590617021187616768', menu_name='房产基本信息查询', menu_code='buildBaseInfomationSearch', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:07:05', update_time='2022-11-10 16:07:05', permission='buildBaseInfomationSearch') 193 Pandas(Index=138, id='1590617140758835200', menu_name='房产基本信息导入', menu_code='buildBaseInfomationImport', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:07:33', update_time='2022-11-10 16:07:33', permission='buildBaseInfomationImport') 194 Pandas(Index=139, id='1590617427900887040', menu_name='房产信息模板下载', menu_code='buildBaseInfomationTemplateDownload', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:08:42', update_time='2022-11-10 16:08:42', permission='buildBaseInfomationTemplateDownload') 195 Pandas(Index=140, id='1590617588047802368', menu_name='房产基本信息导出', menu_code='buildBaseInfomationExport', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:09:20', update_time='2022-11-10 16:09:20', permission='buildBaseInfomationExport') 196 Pandas(Index=141, id='1590617738157748224', menu_name='房产信息文件上传', menu_code='buildBaseInfomationUpload', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:09:56', update_time='2022-11-10 16:09:56', permission='buildBaseInfomationUpload') 197 Pandas(Index=142, id='1590617814158536704', menu_name='房产信息编辑', menu_code='buildBaseInfomationEdit', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1', update_user='1', create_time='2022-11-10 16:10:14', update_time='2022-11-10 16:10:14', permission='buildBaseInfomationEdit') 198 Pandas(Index=171, id='1592436107094298624', menu_name='房产信息附件删除', menu_code='buildingBaseInfomationDeleteFile', menu_type='3', api=nan, parent_id='1589095091057905664', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-15 16:35:29', update_time='2022-11-15 16:35:29', permission='buildingBaseInfomationDeleteFile') 199 Pandas(Index=117, id='1589095210415214592', menu_name='装修原值统计表', menu_code='decoration', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1', update_user='1', create_time='2022-11-06 11:19:57', update_time='2022-11-06 11:19:57', permission='decoration') 200 Pandas(Index=143, id='1590618003174846464', menu_name='装修原值添加', menu_code='decorationAdd', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1', create_time='2022-11-10 16:10:59', update_time='2022-11-10 16:10:59', permission='decorationAdd') 201 Pandas(Index=144, id='1590618121848483840', menu_name='装修原值查询', menu_code='decorationSearch', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1', create_time='2022-11-10 16:11:27', update_time='2022-11-10 16:11:27', permission='decorationSearch') 202 Pandas(Index=145, id='1590619071325663232', menu_name='装修原值导出', menu_code='decorationExport', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1', create_time='2022-11-10 16:15:14', update_time='2022-11-10 16:15:14', permission='decorationExport') 203 Pandas(Index=146, id='1590619220613525504', menu_name='使装修原值失效', menu_code='decorationEdit', menu_type='3', api=nan, parent_id='1589095210415214592', create_user='1', update_user='1565274613801476096', create_time='2022-11-10 16:15:49', update_time='2022-11-10 17:16:57', permission='decorationEdit') 204 Pandas(Index=118, id='1589095322541543424', menu_name='房产租赁基础信息表', menu_code='lease', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1', update_user='1', create_time='2022-11-06 11:20:24', update_time='2022-11-06 11:20:24', permission='lease') 205 Pandas(Index=147, id='1590619663527833600', menu_name='房产租赁基础信息查询', menu_code='buildingLeaseSearch', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:17:35', update_time='2022-11-10 16:17:35', permission='buildingLeaseSearch') 206 Pandas(Index=148, id='1590620128290271232', menu_name='房产租赁信息添加', menu_code='buildingLeaseAdd', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:19:26', update_time='2022-11-10 16:19:26', permission='buildingLeaseAdd') 207 Pandas(Index=149, id='1590622072455032832', menu_name='房产租赁基础信息文件上传', menu_code='buildingLeaseUpload', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:27:09', update_time='2022-11-10 16:27:09', permission='buildingLeaseUpload') 208 Pandas(Index=150, id='1590622167682510848', menu_name='房产租赁信息导出', menu_code='buildingLeaseExport', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1', create_time='2022-11-10 16:27:32', update_time='2022-11-10 16:27:32', permission='buildingLeaseExport') 209 Pandas(Index=151, id='1590622294082056192', menu_name='房产租赁信息编辑', menu_code='buildingLeaseEdit', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1', update_user='1565274613801476096', create_time='2022-11-10 16:28:02', update_time='2022-11-10 17:23:04', permission='buildingLeaseEdit') 210 Pandas(Index=214, id='1592694147756388352', menu_name='房产租赁信息附件删除', menu_code='buildingLeaseDelFile', menu_type='3', api=nan, parent_id='1589095322541543424', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:40:50', update_time='2022-11-16 09:40:50', permission='buildingLeaseDelFile') 211 Pandas(Index=119, id='1589096419582726144', menu_name='长期待摊当前成本台账', menu_code='longTerm', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1', update_user='1', create_time='2022-11-06 11:24:45', update_time='2022-11-06 11:24:45', permission='longTerm') 212 Pandas(Index=152, id='1590622987752828928', menu_name='长期待摊查询', menu_code='longTermDeferredSearch', menu_type='3', api=nan, parent_id='1589096419582726144', create_user='1', update_user='1', create_time='2022-11-10 16:30:47', update_time='2022-11-10 16:30:47', permission='longTermDeferredSearch') 213 Pandas(Index=153, id='1590623070070239232', menu_name='长期待摊添加', menu_code='longTermDeferredAdd', menu_type='3', api=nan, parent_id='1589096419582726144', create_user='1', update_user='1', create_time='2022-11-10 16:31:07', update_time='2022-11-10 16:31:07', permission='longTermDeferredAdd') 214 Pandas(Index=154, id='1590623316280078336', menu_name='长期待摊导入', menu_code='longTermDeferredImport', menu_type='3', api=nan, parent_id='1589096419582726144', create_user='1', update_user='1', create_time='2022-11-10 16:32:06', update_time='2022-11-10 16:32:06', permission='longTermDeferredImport') 215 Pandas(Index=155, id='1590624087251873792', menu_name='长期待摊模板下载', menu_code='longTermDeferredDownload', menu_type='3', api=nan, parent_id='1589096419582726144', create_user='1', update_user='1', create_time='2022-11-10 16:35:09', update_time='2022-11-10 16:35:09', permission='longTermDeferredDownload') 216 Pandas(Index=156, id='1590624775537160192', menu_name='长期待摊编辑', menu_code='longTermDeferredEdit', menu_type='3', api=nan, parent_id='1589096419582726144', create_user='1', update_user='1', create_time='2022-11-10 16:37:54', update_time='2022-11-10 16:37:54', permission='longTermDeferredEdit') 217 Pandas(Index=157, id='1590624872706600960', menu_name='长期待摊删除', menu_code='longTermDeferredDel', menu_type='3', api=nan, parent_id='1589096419582726144', create_user='1', update_user='1', create_time='2022-11-10 16:38:17', update_time='2022-11-10 16:38:17', permission='longTermDeferredDel') 218 Pandas(Index=215, id='1592694524899815424', menu_name='长期待摊导出', menu_code='longTermDefferredExport', menu_type='3', api=nan, parent_id='1589096419582726144', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:42:20', update_time='2022-11-16 09:42:20', permission='longTermDefferredExport') 219 Pandas(Index=120, id='1589096660079923200', menu_name='房土税申报', menu_code='buildingReport', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1', update_user='1', create_time='2022-11-06 11:25:42', update_time='2022-11-06 11:25:42', permission='buildingReport') 220 Pandas(Index=158, id='1590625101862400000', menu_name='房土税申报查询', menu_code='buildingReportSearch', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:39:11', update_time='2022-11-10 16:39:11', permission='buildingReportSearch') 221 Pandas(Index=159, id='1590625243273359360', menu_name='房土税申报添加', menu_code='buildingReportAdd', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:39:45', update_time='2022-11-10 16:39:45', permission='buildingReportAdd') 222 Pandas(Index=160, id='1590625370394324992', menu_name='房土税申报批量删除', menu_code='buildingReportBatchDel', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:40:15', update_time='2022-11-10 16:40:15', permission='buildingReportBatchDel') 223 Pandas(Index=161, id='1590625448861364224', menu_name='房土税申报导出', menu_code='buildingReportExport', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:40:34', update_time='2022-11-10 16:40:34', permission='buildingReportExport') 224 Pandas(Index=162, id='1590625642491408384', menu_name='房土税申报执行', menu_code='buildingReportExcute', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:41:20', update_time='2022-11-10 16:41:20', permission='buildingReportExcute') 225 Pandas(Index=163, id='1590626341723828224', menu_name='房土税申报提交审批', menu_code='buildingReportCommitApproval', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1565274613801476096', create_time='2022-11-10 16:44:07', update_time='2022-12-06 17:56:45', permission='buildingReportCommitApproval') 226 Pandas(Index=164, id='1590626512696242176', menu_name='房土税申报上传附件', menu_code='buildingReportUploadFiles', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:44:48', update_time='2022-11-10 16:44:48', permission='buildingReportUploadFiles') 227 Pandas(Index=165, id='1590626616698204160', menu_name='房土税申报归档', menu_code='buildingReportFiled', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:45:12', update_time='2022-11-10 16:45:12', permission='buildingReportFiled') 228 Pandas(Index=172, id='1592449962759483392', menu_name='房土税申报报表列表编辑', menu_code='buildingReportFormEdit', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-15 17:30:32', update_time='2022-11-15 17:30:32', permission='buildingReportFormEdit') 229 Pandas(Index=173, id='1592451798597955584', menu_name='房土税申报报表列表获取', menu_code='buildingReportFormGet', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-15 17:37:50', update_time='2022-11-15 17:37:50', permission='buildingReportFormGet') 230 Pandas(Index=206, id='1592689726125305856', menu_name='房土税申报任务编辑', menu_code='buildingReportEdit', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:23:16', update_time='2022-11-16 15:56:42', permission='buildingReportEdit') 231 Pandas(Index=127, id='1590613387347488768', menu_name='土地基本信息统计表', menu_code='landInformation', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1', update_user='1', create_time='2022-11-10 15:52:38', update_time='2022-11-10 15:52:38', permission='landInformation') 232 Pandas(Index=128, id='1590613831482339328', menu_name='土地基本信息添加', menu_code='landBaseInformationAdd', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:54:24', update_time='2022-11-10 15:54:24', permission='landBaseInformationAdd') 233 Pandas(Index=129, id='1590613921127198720', menu_name='土地基本信息导入', menu_code='landBaseInformationImport', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:54:46', update_time='2022-11-10 15:54:46', permission='landBaseInformationImport') 234 Pandas(Index=130, id='1590613973946068992', menu_name='土地基本信息查询', menu_code='landBaseInformationSearch', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:54:58', update_time='2022-11-10 15:54:58', permission='landBaseInformationImport') 235 Pandas(Index=131, id='1590614157702721536', menu_name='土地基本信息模板下载', menu_code='landBaseInformationTemplateDownload', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:55:42', update_time='2022-11-10 15:55:42', permission='landBaseInformationTemplateDownload') 236 Pandas(Index=132, id='1590614816292335616', menu_name='土地关联一批房产', menu_code='landBaseInformationBuilding', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:58:19', update_time='2022-11-10 15:58:19', permission='landBaseInformationBuilding') 237 Pandas(Index=133, id='1590615038217154560', menu_name='土地基本信息导出', menu_code='landBaseInformationExport', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 15:59:12', update_time='2022-11-10 15:59:12', permission='landBaseInformationExport') 238 Pandas(Index=134, id='1590615305562091520', menu_name='土地基本信息上传文件', menu_code='landBaseInformationUpload', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 16:00:16', update_time='2022-11-10 16:00:16', permission='landBaseInformationUpload') 239 Pandas(Index=135, id='1590615422801276928', menu_name='土地基本信息编辑', menu_code='landBaseInformationEdit', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1', update_user='1', create_time='2022-11-10 16:00:44', update_time='2022-11-10 16:00:44', permission='landBaseInformationEdit') 240 Pandas(Index=216, id='1592695284278554624', menu_name='删除某个土地下的一个附件', menu_code='landFileListDelete', menu_type='3', api=nan, parent_id='1590613387347488768', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:45:21', update_time='2022-11-16 09:45:21', permission='landFileListDelete') 241 Pandas(Index=482, id='1610156693790011392', menu_name='房屋固定资产当期成本', menu_code='fixedAsset', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1', update_user='1', create_time='2023-01-03 14:10:46', update_time='2023-01-03 14:10:46', permission='fixedAsset') 242 Pandas(Index=483, id='1610156875210436608', menu_name='房屋固定资产当期成本添加', menu_code='fixedAssetAdd', menu_type='3', api=nan, parent_id='1610156693790011392', create_user='1', update_user='1', create_time='2023-01-03 14:11:29', update_time='2023-01-03 14:11:29', permission='fixedAssetAdd') 243 Pandas(Index=484, id='1610156961625681920', menu_name='房屋固定资产当期成本查询', menu_code='fixedAssetSearch', menu_type='3', api=nan, parent_id='1610156693790011392', create_user='1', update_user='1', create_time='2023-01-03 14:11:50', update_time='2023-01-03 14:11:50', permission='fixedAssetSearch') 244 Pandas(Index=485, id='1610157058052730880', menu_name='房屋固定资产当期成本导出', menu_code='fixedAssetExport', menu_type='3', api=nan, parent_id='1610156693790011392', create_user='1', update_user='1', create_time='2023-01-03 14:12:13', update_time='2023-01-03 14:12:13', permission='fixedAssetExport') 245 Pandas(Index=486, id='1610157236721692672', menu_name='房屋固定资产当期成本删除', menu_code='fixedAssetDelete', menu_type='3', api=nan, parent_id='1610156693790011392', create_user='1', update_user='1', create_time='2023-01-03 14:12:55', update_time='2023-01-03 14:12:55', permission='fixedAssetDelete') 246 Pandas(Index=487, id='1610157303474040832', menu_name=' 房屋固定资产当期成本导入', menu_code='fixedAssetImport', menu_type='3', api=nan, parent_id='1610156693790011392', create_user='1', update_user='1', create_time='2023-01-03 14:13:11', update_time='2023-01-03 14:19:30', permission='fixedAssetImport') 247 Pandas(Index=488, id='1610157451197427712', menu_name='房屋固定资产当期成本模板下载', menu_code='fixedAssetDownloadTemp', menu_type='3', api=nan, parent_id='1610156693790011392', create_user='1', update_user='1', create_time='2023-01-03 14:13:46', update_time='2023-01-03 14:19:12', permission='fixedAssetDownloadTemp') 248 Pandas(Index=489, id='1610159419810787328', menu_name='房屋固定资产当期成本编辑', menu_code='fixedAssetEdit', menu_type='3', api=nan, parent_id='1610156693790011392', create_user='1', update_user='1', create_time='2023-01-03 14:21:36', update_time='2023-01-03 14:21:36', permission='fixedAssetEdit') 249 Pandas(Index=554, id='1647888849156833280', menu_name='房土税计提', menu_code='buildingProvision', menu_type='2', api=nan, parent_id='1589094565830381568', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2023-04-17 17:04:53', update_time='2023-04-17 17:04:53', permission='buildingProvision') 251 Pandas(Index=158, id='1590625101862400000', menu_name='房土税申报查询', menu_code='buildingReportSearch', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:39:11', update_time='2022-11-10 16:39:11', permission='buildingReportSearch') 252 Pandas(Index=159, id='1590625243273359360', menu_name='房土税申报添加', menu_code='buildingReportAdd', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:39:45', update_time='2022-11-10 16:39:45', permission='buildingReportAdd') 253 Pandas(Index=160, id='1590625370394324992', menu_name='房土税申报批量删除', menu_code='buildingReportBatchDel', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:40:15', update_time='2022-11-10 16:40:15', permission='buildingReportBatchDel') 254 Pandas(Index=161, id='1590625448861364224', menu_name='房土税申报导出', menu_code='buildingReportExport', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:40:34', update_time='2022-11-10 16:40:34', permission='buildingReportExport') 255 Pandas(Index=162, id='1590625642491408384', menu_name='房土税申报执行', menu_code='buildingReportExcute', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:41:20', update_time='2022-11-10 16:41:20', permission='buildingReportExcute') 256 Pandas(Index=163, id='1590626341723828224', menu_name='房土税申报提交审批', menu_code='buildingReportCommitApproval', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1565274613801476096', create_time='2022-11-10 16:44:07', update_time='2022-12-06 17:56:45', permission='buildingReportCommitApproval') 257 Pandas(Index=164, id='1590626512696242176', menu_name='房土税申报上传附件', menu_code='buildingReportUploadFiles', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:44:48', update_time='2022-11-10 16:44:48', permission='buildingReportUploadFiles') 258 Pandas(Index=165, id='1590626616698204160', menu_name='房土税申报归档', menu_code='buildingReportFiled', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1', update_user='1', create_time='2022-11-10 16:45:12', update_time='2022-11-10 16:45:12', permission='buildingReportFiled') 259 Pandas(Index=172, id='1592449962759483392', menu_name='房土税申报报表列表编辑', menu_code='buildingReportFormEdit', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-15 17:30:32', update_time='2022-11-15 17:30:32', permission='buildingReportFormEdit') 260 Pandas(Index=173, id='1592451798597955584', menu_name='房土税申报报表列表获取', menu_code='buildingReportFormGet', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-15 17:37:50', update_time='2022-11-15 17:37:50', permission='buildingReportFormGet') 261 Pandas(Index=206, id='1592689726125305856', menu_name='房土税申报任务编辑', menu_code='buildingReportEdit', menu_type='3', api=nan, parent_id='1589096660079923200', create_user='1565274613801476096', update_user='1565274613801476096', create_time='2022-11-16 09:23:16', update_time='2022-11-16 15:56:42', permission='buildingReportEdit')
In [119]:
# 证券税务 中还没有的菜单数据
not_in_tax_sec = set(map(lambda it: it[1], data)) - set(map(lambda it: it[1], tax_sec.itertuples()))
not_in_tax_sec
Out[119]:
{'1599603925312540672',
'1599604007831277568',
'1599604208298037248',
'1599604306495082496',
'1681926435995951104',
'1681927183710330880',
'1693866848913960960',
'1693879530522128384'}
In [141]:
tax_sec.query('id =="1600054918957477888"')
Out[141]:
| id | menu_name | menu_code | menu_type | api | parent_id | create_user | update_user | create_time | update_time | permission |
|---|
In [140]:
tax.query('id =="1600054918957477888"')
Out[140]:
| id | menu_name | menu_code | menu_type | api | parent_id | create_user | update_user | create_time | update_time | permission | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 282 | 1600054918957477888 | 视同销售台账 | vatOutComeRegardedAsSales | 2 | NaN | 1600045335685869568 | 1565274613801476096 | 1565274613801476096 | 2022-12-06 17:09:55 | 2022-12-06 17:09:55 | vatOutComeRegardedAsSales |
In [131]:
tax.query('id in @not_in_tax_sec')
Out[131]:
| id | menu_name | menu_code | menu_type | api | parent_id | create_user | update_user | create_time | update_time | permission | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 227 | 1599603925312540672 | 蓝字发票开票申请单 | buleInvoiceApplyView | 2 | NaN | 1599602568526499840 | 1 | 1572187849792675840 | 2022-12-05 11:17:50 | 2023-03-21 18:50:59 | buleInvoiceApplyView |
| 228 | 1599604007831277568 | 红字发票开票申请单 | redInvoiceApplyView | 2 | NaN | 1599602568526499840 | 1 | 1572187849792675840 | 2022-12-05 11:18:09 | 2023-03-21 18:51:11 | redInvoiceApplyView |
| 229 | 1599604208298037248 | 蓝字发票待开票清单 | buleUnInvoicedView | 2 | NaN | 1599602568526499840 | 1 | 1572187849792675840 | 2022-12-05 11:18:57 | 2023-03-21 18:51:39 | buleUnInvoicedView |
| 230 | 1599604306495082496 | 红字发票待开票清单 | redUnInvoicedView | 2 | NaN | 1599602568526499840 | 1 | 1572187849792675840 | 2022-12-05 11:19:21 | 2023-03-21 18:51:53 | redUnInvoicedView |
| 570 | 1681926435995951104 | 按集团创建 | createMYByGroup | 3 | NaN | 1645349599270010880 | 1 | 1 | 2023-07-20 15:18:06 | 2023-07-20 15:18:06 | createMYByGroup |
| 571 | 1681927183710330880 | 按税号创建 | createMYByTaxpayerNo | 3 | NaN | 1645349599270010880 | 1 | 1 | 2023-07-20 15:21:04 | 2023-07-20 15:21:04 | createMYByTaxpayerNo |
| 576 | 1693866848913960960 | 管理地区定义 | administrativearea | 2 | NaN | 1592690968444596224 | 1 | 1 | 2023-08-22 14:05:02 | 2023-08-22 14:05:02 | administrativearea |
| 577 | 1693879530522128384 | 费控数据交互 | fkDataControl | 2 | NaN | 1600045102084108288 | 1 | 1 | 2023-08-22 14:55:25 | 2023-08-22 14:55:25 | fkDataControl |
In [130]:
tax.query('id in @not_in_tax_sec')['menu_name'].to_list()
Out[130]:
['蓝字发票开票申请单', '红字发票开票申请单', '蓝字发票待开票清单', '红字发票待开票清单', '按集团创建', '按税号创建', '管理地区定义', '费控数据交互']
In [38]:
diff.to_excel("diff.xlsx")
In [11]:
only_in_first
Out[11]:
| id | menu_name_x | menu_code_x | menu_type_x | api_x | parent_id_x | create_user_x | update_user_x | create_time_x | update_time_x | ... | menu_code_y | menu_type_y | api_y | parent_id_y | create_user_y | update_user_y | create_time_y | update_time_y | permission_y | _merge | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 122 | 1589098195459428352 | NPO业务活动表管理 | npoBusinessActivityTableManage | 2.0 | NaN | 1.589097e+18 | 1.000000e+00 | 1.000000e+00 | 2022-11-06 11:31:48 | 2022-11-06 11:31:48 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 123 | 1589098381841715200 | NPO资产负债表 | npoBalanceSheetMange | 2.0 | NaN | 1.589097e+18 | 1.000000e+00 | 1.000000e+00 | 2022-11-06 11:32:33 | 2022-11-06 11:32:33 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 124 | 1589098889851621376 | 一般企业利润表管理 | generalIncomeStatementManage | 2.0 | NaN | 1.589097e+18 | 1.000000e+00 | 1.000000e+00 | 2022-11-06 11:34:34 | 2022-11-06 11:34:34 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 125 | 1589099065815257088 | 一般企业资产负债表管理 | generalBalanceSheetManage | 2.0 | NaN | 1.589097e+18 | 1.000000e+00 | 1.565275e+18 | 2022-11-06 11:35:16 | 2022-11-10 17:00:39 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 169 | 1590630781402943488 | 所得税申报 | generalReport | 2.0 | NaN | 1.589097e+18 | 1.565275e+18 | 1.565275e+18 | 2022-11-10 17:01:45 | 2022-11-10 17:01:45 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 223 | 1599603230874210304 | 发票分发 | invoiceDistributeView | 2.0 | NaN | 1.599602e+18 | 1.000000e+00 | 1.000000e+00 | 2022-12-05 11:15:04 | 2022-12-05 11:15:04 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 224 | 1599603425087262720 | 发票退回 | invoiceBackView | 2.0 | NaN | 1.599602e+18 | 1.000000e+00 | 1.000000e+00 | 2022-12-05 11:15:50 | 2022-12-05 11:15:50 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 226 | 1599603730424205312 | 库存预警日志 | invoiceStockWarningView | 2.0 | NaN | 1.599602e+18 | 1.000000e+00 | 1.000000e+00 | 2022-12-05 11:17:03 | 2022-12-05 11:17:03 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 227 | 1599603925312540672 | 蓝字发票开票申请单 | buleInvoiceApplyView | 2.0 | NaN | 1.599603e+18 | 1.000000e+00 | 1.572188e+18 | 2022-12-05 11:17:50 | 2023-03-21 18:50:59 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 228 | 1599604007831277568 | 红字发票开票申请单 | redInvoiceApplyView | 2.0 | NaN | 1.599603e+18 | 1.000000e+00 | 1.572188e+18 | 2022-12-05 11:18:09 | 2023-03-21 18:51:11 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 229 | 1599604208298037248 | 蓝字发票待开票清单 | buleUnInvoicedView | 2.0 | NaN | 1.599603e+18 | 1.000000e+00 | 1.572188e+18 | 2022-12-05 11:18:57 | 2023-03-21 18:51:39 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 230 | 1599604306495082496 | 红字发票待开票清单 | redUnInvoicedView | 2.0 | NaN | 1.599603e+18 | 1.000000e+00 | 1.572188e+18 | 2022-12-05 11:19:21 | 2023-03-21 18:51:53 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 271 | 1600046547940388864 | 科目余额表-计提版 | vatOutComeTaxGlaccBalances | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.000000e+00 | 2022-12-06 16:36:39 | 2023-03-21 19:06:56 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 272 | 1600047730822197248 | 科目余额表-申报版 | vatOutComeTaxGlaccReport | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.000000e+00 | 2022-12-06 16:41:21 | 2023-03-21 19:13:55 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 274 | 1600054164553183232 | 广告服务收入明细 | vatOutComeTaxAdvSerIncome | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.565275e+18 | 2022-12-06 17:06:55 | 2022-12-06 17:06:55 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 276 | 1600054383932059648 | 销项开票明细数据 | vatOutComeTaxInvInfo | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.565275e+18 | 2022-12-06 17:07:47 | 2022-12-06 17:07:47 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 277 | 1600054554363408384 | 金融数据收入明细 | vatOutComeFinanceDataIncome | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.565275e+18 | 2022-12-06 17:08:28 | 2022-12-06 17:08:28 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 279 | 1600054713981841408 | 资管产品收入计算台账 | vatOutComeAssetMagRevenue | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.565275e+18 | 2022-12-06 17:09:06 | 2022-12-06 17:09:06 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 281 | 1600054818034135040 | 资管产品收入扣除项目明细 | vatOutComeAssetDeduction | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.565275e+18 | 2022-12-06 17:09:31 | 2022-12-06 17:09:31 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 282 | 1600054918957477888 | 视同销售台账 | vatOutComeRegardedAsSales | 2.0 | NaN | 1.600045e+18 | 1.565275e+18 | 1.565275e+18 | 2022-12-06 17:09:55 | 2022-12-06 17:09:55 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 513 | 1633372809223962624 | 专项资质申请 | taxRddHighTech | 2.0 | NaN | 1.622498e+18 | 1.110000e+02 | 1.110000e+02 | 2023-03-08 15:43:19 | 2023-03-08 15:43:19 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 522 | 1633373832923545600 | 专项资质维护 | taxRddSpecialQualification | 2.0 | NaN | 1.622498e+18 | 1.110000e+02 | 1.110000e+02 | 2023-03-08 15:47:23 | 2023-03-08 15:47:23 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 534 | 1633374795369512960 | 资质维护指标口径汇总 | taxRddtaxPreIndex | 2.0 | NaN | 1.622498e+18 | 1.110000e+02 | 1.000000e+00 | 2023-03-08 15:51:13 | 2023-03-21 19:16:10 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 536 | 1638138281974792192 | 数据面板 | dashboard | 1.0 | NaN | NaN | 1.000000e+00 | 1.000000e+00 | 2023-03-21 19:19:36 | 2023-03-21 19:19:36 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 538 | 1645348054985998336 | 数据面板 | dashboard1 | 2.0 | NaN | 1.645347e+18 | 1.000000e+00 | 1.000000e+00 | 2023-04-10 16:48:40 | 2023-04-10 16:48:40 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 567 | 1681925508727611392 | 按税号创建 | createAnalyseInfoByTaxpayerNo | 3.0 | NaN | 1.645350e+18 | 1.000000e+00 | 1.000000e+00 | 2023-07-20 15:14:25 | 2023-07-20 15:14:25 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 568 | 1681925644077801472 | 按地区创建 | createAnalyseInfoByArea | 3.0 | NaN | 1.645350e+18 | 1.000000e+00 | 1.000000e+00 | 2023-07-20 15:14:57 | 2023-07-20 15:14:57 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 569 | 1681925760343908352 | 按集团创建 | createAnalyseInfoByGroup | 3.0 | NaN | 1.645350e+18 | 1.000000e+00 | 1.000000e+00 | 2023-07-20 15:15:25 | 2023-07-20 15:15:25 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 570 | 1681926435995951104 | 按集团创建 | createMYByGroup | 3.0 | NaN | 1.645350e+18 | 1.000000e+00 | 1.000000e+00 | 2023-07-20 15:18:06 | 2023-07-20 15:18:06 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 571 | 1681927183710330880 | 按税号创建 | createMYByTaxpayerNo | 3.0 | NaN | 1.645350e+18 | 1.000000e+00 | 1.000000e+00 | 2023-07-20 15:21:04 | 2023-07-20 15:21:04 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 572 | 1690992300782731264 | 风险管理模块 | risk | 1.0 | NaN | NaN | 1.000000e+00 | 1.000000e+00 | 2023-08-14 15:42:36 | 2023-08-14 15:42:36 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 573 | 1690992504055480320 | 风险指标配置 | risk-standard | 2.0 | NaN | 1.690992e+18 | 1.000000e+00 | 1.000000e+00 | 2023-08-14 15:43:25 | 2023-08-14 15:43:25 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 574 | 1690992591045345280 | Job管理 | risk-job | 2.0 | NaN | 1.690992e+18 | 1.000000e+00 | 1.000000e+00 | 2023-08-14 15:43:45 | 2023-08-14 15:43:45 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 575 | 1690992674952396800 | 风险应对结果 | risk-result | 2.0 | NaN | 1.690992e+18 | 1.000000e+00 | 1.000000e+00 | 2023-08-14 15:44:05 | 2023-08-14 15:44:05 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 576 | 1693866848913960960 | 管理地区定义 | administrativearea | 2.0 | NaN | 1.592691e+18 | 1.000000e+00 | 1.000000e+00 | 2023-08-22 14:05:02 | 2023-08-22 14:05:02 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 577 | 1693879530522128384 | 费控数据交互 | fkDataControl | 2.0 | NaN | 1.600045e+18 | 1.000000e+00 | 1.000000e+00 | 2023-08-22 14:55:25 | 2023-08-22 14:55:25 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 578 | 1719626759446691840 | 管理报表税种配置 | sjszpz | 2.0 | NaN | 1.592691e+18 | 1.000000e+00 | 1.593417e+18 | 2023-11-01 16:05:43 | 2023-11-03 16:29:00 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
| 579 | 1719626874219626496 | 管理报表币种及口径配置 | nsdszpz | 2.0 | NaN | 1.592691e+18 | 1.000000e+00 | 1.000000e+00 | 2023-11-01 16:06:11 | 2023-11-03 16:34:47 | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | left_only |
38 rows × 22 columns
1. 前端需要修改 CAS 登录逻辑¶
ipcMain.on('CASLogin', (event, data) => {
改为调用 /login 接口
- 初始密码 8个8
- 前端传过来的是 md5(pwd)
- 存入数据库的是，md5(md5(pwd) + RPA) （3c728b880ece6dc0dfa5ff6aa9a6d8dd）
md5(88888888) = 8ddcff3a80f4189ca1c9d4d902c3c909
- 增加 password 字段， 并为历史数据补充初始密码
ALTER TABLE rpa.user_detail ADD PASSWORD varchar(32) DEFAULT '3c728b880ece6dc0dfa5ff6aa9a6d8dd' NULL COMMENT '用户密码';
ALTER TABLE rpa.user_detail CHANGE PASSWORD PASSWORD varchar(32) DEFAULT '3c728b880ece6dc0dfa5ff6aa9a6d8dd' NULL COMMENT '用户密码' AFTER USER_ID;
登录成功的会返回 token,
{
"code": 0,
"msg": "OK",
"data": {
"token": "eyJhbGciOiJIUzI1NiJ9.eyJ1c2VySWQiOiIyMTA4OTEiLCJpYXQiOjE3MTExMDE4OTksImV4cCI6MTcxMTE4ODI5OX0.koLp-5_QeyefEdIm-HFxCMzXWEfDSjZB1sy7iJFzaIU"
}
}
后续所有请求 需要将 token 放入 请求头中， 此逻辑应该跟原来一样， 具体要不要改动，前端同事确认一下
// request interceptor
service.interceptors.request.use(
config => {
// do something before request is sent
config.headers['client-type'] = 'desktop'
if (store.getters.token) {
// let each request carry token
// ['X-Token'] is a custom headers key
// please modify it according to the actual situation
config.headers['token'] = store.getters.token
}
return config
},
error => {
// do something with request error
console.log(error) // for debug
return Promise.reject(error)
}
)
2. getmine¶
前端同事需要确认一下这个API还在不在用, 关于 CAS 的API 都要去除
export function getInfo (token) {
return request({
url: 'https://njcas.eastmoney.com/cas/getmine',
method: 'get',
params: { token }
})
}
用下面这个接口应该够了
export function getUserInfo () {
return request({
url: '/user/getCurrentUserDetail',
method: 'get'
})
}
3. logout¶
修改原调用 CASLogout 的逻辑
ipcMain.on('CASLogout', (event, data) => {
改为调用 /logout 接口
这里token也要通过请求头带过来
调用成功后，后端会将 token 禁用
系统登录相关接口¶
修改密码¶
接口地址:/changePwd
请求方式:POST
请求数据类型:application/json
响应数据类型:*/*
接口描述:
请求示例:
{
"newPwd": "",
"repeatNewPwd": ""
}
请求参数:
| 参数名称 | 参数说明 | in | 是否必须 | 数据类型 | schema |
|---|---|---|---|---|---|
| changePwdReq | changePwdReq | body | true | 修改密码 | 修改密码 |
| newPwd | false | string | |||
| repeatNewPwd | false | string |
响应状态:
| 状态码 | 说明 | schema |
|---|---|---|
| 200 | OK | RPA系统接口响应类«string» |
| 201 | Created | |
| 401 | Unauthorized | |
| 403 | Forbidden | |
| 404 | Not Found |
响应参数:
| 参数名称 | 参数说明 | 类型 | schema |
|---|---|---|---|
| code | 响应码 | integer(int32) | integer(int32) |
| data | 具体响应数据对象 | string | |
| msg | 响应描述 | string |
响应示例:
{
"code": 0,
"data": "",
"msg": ""
}
登录, 如果成功， 返回 token¶
接口地址:/login
请求方式:GET
请求数据类型:application/json
响应数据类型:*/*
接口描述:
请求参数:
| 参数名称 | 参数说明 | in | 是否必须 | 数据类型 | schema |
|---|---|---|---|---|---|
| userId | userId | query | true | string | |
| password | password | query | true | string |
响应状态:
| 状态码 | 说明 | schema |
|---|---|---|
| 200 | OK | RPA系统接口响应类«登录结果» |
| 401 | Unauthorized | |
| 403 | Forbidden | |
| 404 | Not Found |
响应参数:
| 参数名称 | 参数说明 | 类型 | schema |
|---|---|---|---|
| code | 响应码 | integer(int32) | integer(int32) |
| data | 具体响应数据对象 | 登录结果 | 登录结果 |
| token | token 如果登录成功 | string | |
| msg | 响应描述 | string |
响应示例:
{
"code": 0,
"data": {
"token": ""
},
"msg": ""
}
登出¶
接口地址:/logout
请求方式:GET
请求数据类型:application/json
响应数据类型:*/*
接口描述:
请求参数:
暂无
响应状态:
| 状态码 | 说明 | schema |
|---|---|---|
| 200 | OK | RPA系统接口响应类«string» |
| 401 | Unauthorized | |
| 403 | Forbidden | |
| 404 | Not Found |
响应参数:
| 参数名称 | 参数说明 | 类型 | schema |
|---|---|---|---|
| code | 响应码 | integer(int32) | integer(int32) |
| data | 具体响应数据对象 | string | |
| msg | 响应描述 | string |
响应示例:
{
"code": 0,
"data": "",
"msg": ""
}
重置密码¶
接口地址:/resetPwd
请求方式:PUT
请求数据类型:application/json
响应数据类型:*/*
接口描述:
请求参数:
| 参数名称 | 参数说明 | in | 是否必须 | 数据类型 | schema |
|---|---|---|---|---|---|
| id | id | query | true | integer(int64) |
响应状态:
| 状态码 | 说明 | schema |
|---|---|---|
| 200 | OK | RPA系统接口响应类«string» |
| 201 | Created | |
| 401 | Unauthorized | |
| 403 | Forbidden | |
| 404 | Not Found |
响应参数:
| 参数名称 | 参数说明 | 类型 | schema |
|---|---|---|---|
| code | 响应码 | integer(int32) | integer(int32) |
| data | 具体响应数据对象 | string | |
| msg | 响应描述 | string |
响应示例:
{
"code": 0,
"data": "",
"msg": ""
}
¶
1 登录¶
In [1]:
import requests
import hashlib
headers = {
'Accept': '*/*',
'Accept-Language': 'zh-CN,zh;q=0.9',
'Cache-Control': 'no-cache',
'Connection': 'keep-alive',
'Content-Type': 'application/x-www-form-urlencoded',
'Pragma': 'no-cache',
'Referer': 'http://127.0.0.1:7081/doc.html',
'Request-Origion': 'Knife4j',
'Sec-Fetch-Dest': 'empty',
'Sec-Fetch-Mode': 'cors',
'Sec-Fetch-Site': 'same-origin',
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36',
'sec-ch-ua': '"Chromium";v="122", "Not(A:Brand";v="24", "Google Chrome";v="122"',
'sec-ch-ua-mobile': '?0',
'sec-ch-ua-platform': '"Windows"',
}
params = (
('userId', '210891'),
('password', hashlib.md5('88888888'.encode("utf-8")).hexdigest()),
)
print('''hashlib.md5('88888888'.encode("utf-8")).hexdigest() = ''', hashlib.md5('88888888'.encode("utf-8")).hexdigest())
response = requests.get('http://127.0.0.1:7081/login', headers=headers, params=params)
#NB. Original query string below. It seems impossible to parse and
#reproduce query strings 100% accurately so the one below is given
#in case the reproduced version is not "correct".
# response = requests.get('http://127.0.0.1:7081/user/queryUser?id=64', headers=headers)
print(response.json())
token = response.json()['data']['token']
hashlib.md5('88888888'.encode("utf-8")).hexdigest() = 8ddcff3a80f4189ca1c9d4d902c3c909
{'code': 0, 'msg': 'OK', 'data': {'token': 'eyJhbGciOiJIUzI1NiJ9.eyJ1c2VySWQiOiIyMTA4OTEiLCJpYXQiOjE3MTExMDE4OTksImV4cCI6MTcxMTE4ODI5OX0.koLp-5_QeyefEdIm-HFxCMzXWEfDSjZB1sy7iJFzaIU'}}
In [2]:
response.text
Out[2]:
'{"code":0,"msg":"OK","data":{"token":"eyJhbGciOiJIUzI1NiJ9.eyJ1c2VySWQiOiIyMTA4OTEiLCJpYXQiOjE3MTExMDE4OTksImV4cCI6MTcxMTE4ODI5OX0.koLp-5_QeyefEdIm-HFxCMzXWEfDSjZB1sy7iJFzaIU"}}'
2. 根据Token查询当前用户¶
In [29]:
import requests
headers = {
'Accept': '*/*',
'Accept-Language': 'zh-CN,zh;q=0.9',
'Cache-Control': 'no-cache',
'Connection': 'keep-alive',
'Content-Type': 'application/x-www-form-urlencoded',
'Pragma': 'no-cache',
'Referer': 'http://127.0.0.1:7081/doc.html',
'Request-Origion': 'Knife4j',
'Sec-Fetch-Dest': 'empty',
'Sec-Fetch-Mode': 'cors',
'Sec-Fetch-Site': 'same-origin',
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36',
'sec-ch-ua': '"Chromium";v="122", "Not(A:Brand";v="24", "Google Chrome";v="122"',
'sec-ch-ua-mobile': '?0',
'sec-ch-ua-platform': '"Windows"',
'token': token,
'client-type': 'desktop',
'plugin-token': '98d3b074-c193-4d88-b0d8-9c709348a47b',
}
params = (
('id', '64'),
)
response = requests.get('http://127.0.0.1:7081/user/getCurrentUserDetail', headers=headers, params=params)
#NB. Original query string below. It seems impossible to parse and
#reproduce query strings 100% accurately so the one below is given
#in case the reproduced version is not "correct".
# response = requests.get('http://127.0.0.1:7081/user/queryUser?id=64', headers=headers)
response.json()
Out[29]:
{'code': 0,
'msg': 'OK',
'data': {'id': 71,
'userId': '210891',
'userName': '梁德胜',
'password': '3c728b880ece6dc0dfa5ff6aa9a6d8dd',
'workId': '210891',
'role': {'id': 9,
'roleType': '运维',
'roleName': '运维管理员',
'additionalDesc': '运维管理员'},
'phoneNumber': '17839757993',
'emailAddress': 'liangdesheng@eastmoney.com',
'additionalDesc': 'admin',
'department': {'id': 21,
'departmentName': '南京研发部',
'additionalDesc': '研发人员'},
'bindServiceDefines': [{'id': 15,
'serviceName': '个税申报',
'department': {'id': 22,
'departmentName': '证券财务部',
'additionalDesc': '证券税务业务人员'},
'additionalDesc': None},
{'id': 16,
'serviceName': '所得税申报',
'department': {'id': 22,
'departmentName': '证券财务部',
'additionalDesc': '证券税务业务人员'},
'additionalDesc': None}]}}
1.1 登录出错¶
In [30]:
import requests
import hashlib
headers = {
'Accept': '*/*',
'Accept-Language': 'zh-CN,zh;q=0.9',
'Cache-Control': 'no-cache',
'Connection': 'keep-alive',
'Content-Type': 'application/x-www-form-urlencoded',
'Pragma': 'no-cache',
'Referer': 'http://127.0.0.1:7081/doc.html',
'Request-Origion': 'Knife4j',
'Sec-Fetch-Dest': 'empty',
'Sec-Fetch-Mode': 'cors',
'Sec-Fetch-Site': 'same-origin',
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36',
'sec-ch-ua': '"Chromium";v="122", "Not(A:Brand";v="24", "Google Chrome";v="122"',
'sec-ch-ua-mobile': '?0',
'sec-ch-ua-platform': '"Windows"',
}
params = (
('userId', '210892'),
('password', hashlib.md5('88888888'.encode("utf-8")).hexdigest()),
)
print('''hashlib.md5('88888888'.encode("utf-8")).hexdigest() = ''', hashlib.md5('88888888'.encode("utf-8")).hexdigest())
response = requests.get('http://127.0.0.1:7081/login', headers=headers, params=params)
#NB. Original query string below. It seems impossible to parse and
#reproduce query strings 100% accurately so the one below is given
#in case the reproduced version is not "correct".
# response = requests.get('http://127.0.0.1:7081/user/queryUser?id=64', headers=headers)
print(response.json())
hashlib.md5('88888888'.encode("utf-8")).hexdigest() = 8ddcff3a80f4189ca1c9d4d902c3c909
{'code': -1, 'msg': '用户: 210892; 密码: 3c728b880ece6dc0dfa5ff6aa9a6d8dd 错误！origin_pwd: 8ddcff3a80f4189ca1c9d4d902c3c909', 'data': None}