main.py 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939
  1. import xml.etree.ElementTree as ET
  2. from typing import Union
  3. from fastapi import FastAPI
  4. import os
  5. import uuid
  6. import re
  7. import zipfile
  8. import json
  9. from fastapi.middleware.cors import CORSMiddleware
  10. from fastapi.middleware.gzip import GZipMiddleware
  11. from sentence_transformers import SentenceTransformer
  12. model = SentenceTransformer("BAAI/bge-small-zh-v1.5")
  13. import base64
  14. from pydantic import BaseModel
  15. from subdir import service
  16. from subdir import db
  17. from subdir import util
  18. import xml.dom.minidom as MD
  19. import numpy as np
  20. from fastapi.staticfiles import StaticFiles
  21. from pymongo import AsyncMongoClient
  22. client = AsyncMongoClient()
  23. from fastapi.responses import FileResponse
  24. from fastapi_cache import FastAPICache
  25. from inmemory import InMemoryBackend
  26. from fastapi_cache.decorator import cache
  27. from contextlib import asynccontextmanager
  28. from fastapi import WebSocket, WebSocketDisconnect
  29. from fastapi import UploadFile
  30. from collections.abc import AsyncIterator
  31. class ConnectionManager:
  32. """Class defining socket events"""
  33. def __init__(self):
  34. """init method, keeping track of connections"""
  35. self.active_connections = []
  36. async def connect(self, websocket: WebSocket):
  37. """connect event"""
  38. await websocket.accept()
  39. self.active_connections.append(websocket)
  40. async def send_personal_message(self, message: str, websocket: WebSocket):
  41. """Direct Message"""
  42. await websocket.send_text(message)
  43. def disconnect(self, websocket: WebSocket):
  44. """disconnect event"""
  45. self.active_connections.remove(websocket)
  46. @asynccontextmanager
  47. async def lifespan(_: FastAPI) -> AsyncIterator[None]:
  48. FastAPICache.init(InMemoryBackend(), prefix="default")
  49. yield
  50. app = FastAPI(lifespan=lifespan)
  51. origins = [
  52. "http://localhost.tiangolo.com",
  53. "https://localhost.tiangolo.com",
  54. "http://localhost",
  55. "http://localhost:9002",
  56. "http://127.0.0.1:9002",
  57. ]
  58. app.add_middleware(
  59. CORSMiddleware,
  60. allow_origins=["*"],
  61. allow_credentials=True,
  62. allow_methods=["*"],
  63. allow_headers=["*"],
  64. )
  65. ##app.add_middleware(GZipMiddleware, minimum_size=1000, compresslevel=5)
  66. ##app.mount("/static", StaticFiles(directory="front/dist"), name="static")
  67. ##manager = ConnectionManager()
  68. class Info(BaseModel):
  69. name: str
  70. class DingeshuRequest(BaseModel):
  71. value: int
  72. class DingeXilieRequest(BaseModel):
  73. value: int
  74. id: str
  75. class SingleDingeXilieRequest(BaseModel):
  76. zhuanye: int
  77. debh: str
  78. class InfoWithID(BaseModel):
  79. name: str
  80. id: str
  81. class Tiaojia(BaseModel):
  82. biao_id: str
  83. bh: str
  84. bm: str
  85. mingcheng: str
  86. danwei: str
  87. jiage: str
  88. glf: str
  89. lr: str
  90. bz: int
  91. class SearchDe(BaseModel):
  92. zhuanye: str
  93. text: str
  94. class UpdateZjcs(BaseModel):
  95. biao_id: str
  96. bh: str
  97. mc: str
  98. fl: str
  99. class Item(BaseModel):
  100. bh: str
  101. bt: str
  102. name: str
  103. class Rcj(BaseModel):
  104. bh: str
  105. bt: str
  106. bm: str
  107. name: str
  108. class Dercj(BaseModel):
  109. bh: str
  110. bt: str
  111. qdbm: str
  112. debm: str
  113. name: str
  114. class Zjcs(BaseModel):
  115. bh: str
  116. name: str
  117. @app.post("/outline2")
  118. async def read_root2(info: Info):
  119. return await db.getOutline(client, info.name)
  120. @app.post("/detail2")
  121. async def read_detail2(info: Info):
  122. return await db.getDetail(client, info.name)
  123. @app.post("/baojiahuizong2/")
  124. async def read_bjhz2(info: InfoWithID):
  125. raw = await db.getBjhz(client, info.name, info.id)
  126. raw2 = []
  127. for entry in raw:
  128. if "__children" in entry:
  129. entry["_children"] = entry["__children"]
  130. for grandchild in entry["_children"]:
  131. if "__children" in grandchild:
  132. grandchild['_children'] = grandchild['__children']
  133. del grandchild['__children']
  134. del entry["__children"]
  135. raw2.append(entry)
  136. return raw2
  137. @app.post("/guifeishuijin2/")
  138. async def read_gfsj2(info: InfoWithID):
  139. raw = await db.getGfsj(client, info.name, info.id)
  140. raw2 = []
  141. for entry in raw:
  142. if "__children" in entry:
  143. entry["_children"] = entry["__children"]
  144. del entry["__children"]
  145. raw2.append(entry)
  146. return raw2
  147. @app.post("/qitaxiangmu2/")
  148. async def read_qtxm2(info: InfoWithID):
  149. raw = await db.getQtxm(client, info.name, info.id)
  150. raw2 = []
  151. for entry in raw:
  152. if "__children" in entry:
  153. entry["_children"] = entry["__children"]
  154. del entry["__children"]
  155. raw2.append(entry)
  156. return raw2
  157. @app.post("/zygczgj/")
  158. async def zygczgj(info: InfoWithID):
  159. return await db.getZygczgj(client, info.name, info.id)
  160. @app.post("/zanliejine2/")
  161. async def read_zlje2(info: InfoWithID):
  162. return await db.getZlje(client, info.name, info.id)
  163. @app.post("/jirigong2/")
  164. async def read_jrg2(info: InfoWithID):
  165. return await db.getJrg(client, info.name, info.id)
  166. @app.post("/zongchengbaofuwufei2/")
  167. async def read_zcbfwf2(info: InfoWithID):
  168. return await db.getZcbfwf(client, info.name, info.id)
  169. @app.post("/fabaorengongyingcailiao2/")
  170. async def read_fbrgycl2(info: InfoWithID):
  171. return await db.getFbrgycl(client, info.name, info.id)
  172. @app.post("/rencaijihuizong2/")
  173. async def read_rcjhz2(info: InfoWithID):
  174. return await db.getRcjhz(client, info.name, info.id)
  175. @app.post("/qingdanxiangmu2/")
  176. async def read_qdxm2(info: InfoWithID):
  177. return await db.getQdxm(client, info.name, info.id)
  178. @app.post("/qingdanmingxi/")
  179. async def read_qdmx(item : Item):
  180. return await db.getQdmx(client, item.name, item.bh, item.bt)
  181. @app.post("/qingdanrcj/")
  182. async def read_rcj(item : Rcj):
  183. if item.bt == "Djcs":
  184. return await db.getDjcsQingdanrcj(client, item.name, item.bh, item.bt, item.bm)
  185. return await db.getQingdanrcj(client, item.name, item.bh, item.bt, item.bm)
  186. @app.get("/qingdantuijian/{bm}")
  187. @cache(expire=86400)
  188. async def read_tuijian(bm: str):
  189. return service.getQingdanTuijian("", "", bm)
  190. @app.post("/dingercj/")
  191. async def read_dercj(item : Dercj):
  192. if item.bt == "Djcs":
  193. return await db.getDjcsDingercj(client, item.name, item.bh, item.bt, item.qdbm, item.debm)
  194. return await db.getDingercj(client, item.name, item.bh, item.bt, item.qdbm, item.debm)
  195. @app.post("/zjcs/")
  196. async def read_zjcs(item : Zjcs):
  197. raw = await db.getZjcs(client, item.name, item.bh)
  198. raw2 = []
  199. for entry in raw:
  200. if "__children" in entry:
  201. entry["_children"] = entry["__children"]
  202. del entry["__children"]
  203. raw2.append(entry)
  204. return raw2
  205. @app.post("/djcs/")
  206. async def read_djcs(item : Zjcs):
  207. raw = await db.getDjcs(client, item.name, item.bh)
  208. raw2 = []
  209. for entry in raw:
  210. if "__children" in entry:
  211. entry["_children"] = entry["__children"]
  212. del entry["__children"]
  213. raw2.append(entry)
  214. return raw2
  215. @app.post("/files2/")
  216. async def read_files2():
  217. result = await db.list_files(client)
  218. return result
  219. @app.post("/deleteFile/")
  220. async def delete(r: Info):
  221. result = await db.delete_files(client, r.name)
  222. return result
  223. @app.get("/des/{value}")
  224. @cache(expire=86400)
  225. async def read_des(value: int):
  226. result = service.getDes(value)
  227. if value == 30:
  228. result.append({
  229. "id": "2075",
  230. "key" : "2075",
  231. "value" : "2075",
  232. "label" : "安装费用",
  233. "title" : "安装费用",
  234. "children" : [
  235. {
  236. "id": "2076",
  237. "key" : "2076",
  238. "value" : "2076",
  239. "label" : "脚手架搭拆费",
  240. "title" : "脚手架搭拆费",
  241. "children" : []
  242. },
  243. {
  244. "id": "2077",
  245. "key" : "2077",
  246. "value" : "2077",
  247. "label" : "施工超高增加费",
  248. "title" : "施工超高增加费",
  249. "children" : []
  250. },
  251. {
  252. "id": "2080",
  253. "key" : "2080",
  254. "value" : "2080",
  255. "label" : "高层建筑增加费",
  256. "title" : "高层建筑增加费",
  257. "children" : [
  258. {
  259. "id": "2081",
  260. "key" : "2081",
  261. "value" : "2081",
  262. "label" : "第四册",
  263. "title" : "第四册",
  264. "children" : []
  265. },
  266. {
  267. "id": "2082",
  268. "key" : "2082",
  269. "value" : "2082",
  270. "label" : "第五册",
  271. "title" : "第五册",
  272. "children" : []
  273. },
  274. {
  275. "id": "2083",
  276. "key" : "2083",
  277. "value" : "2083",
  278. "label" : "第七册",
  279. "title" : "第七册",
  280. "children" : []
  281. },
  282. {
  283. "id": "2084",
  284. "key" : "2084",
  285. "value" : "2084",
  286. "label" : "第九册",
  287. "title" : "第九册",
  288. "children" : []
  289. },
  290. {
  291. "id": "2085",
  292. "key" : "2085",
  293. "value" : "2085",
  294. "label" : "第十册",
  295. "title" : "第十册",
  296. "children" : []
  297. },
  298. {
  299. "id": "2086",
  300. "key" : "2086",
  301. "value" : "2086",
  302. "label" : "第十一册",
  303. "title" : "第十一册",
  304. "children" : []
  305. },
  306. ]
  307. },
  308. {
  309. "id": "2078",
  310. "key" : "2078",
  311. "value" : "2078",
  312. "label" : "安装生产同时增加费",
  313. "title" : "安装生产同时增加费",
  314. "children" : []
  315. },
  316. {
  317. "id": "2079",
  318. "key" : "2079",
  319. "value" : "2079",
  320. "label" : "有害环境操作增加费",
  321. "title" : "有害环境操作增加费",
  322. "children" : []
  323. },
  324. {
  325. "id": "2087",
  326. "key" : "2087",
  327. "value" : "2087",
  328. "label" : "系统调试费",
  329. "title" : "系统调试费",
  330. "children" : []
  331. },
  332. ]
  333. })
  334. if value == 60:
  335. result.append({
  336. "id": "184",
  337. "key" : "184",
  338. "value" : "184",
  339. "label" : "安装费用",
  340. "title" : "安装费用",
  341. "children" : [
  342. {
  343. "id": "185",
  344. "key" : "185",
  345. "value" : "185",
  346. "label" : "脚手架搭拆费",
  347. "title" : "脚手架搭拆费",
  348. "children" : []
  349. },
  350. {
  351. "id": "186",
  352. "key" : "186",
  353. "value" : "186",
  354. "label" : "施工超高增加费",
  355. "title" : "施工超高增加费",
  356. "children" : []
  357. },
  358. {
  359. "id": "187",
  360. "key" : "187",
  361. "value" : "187",
  362. "label" : "高层建筑增加费",
  363. "title" : "高层建筑增加费",
  364. "children" : []
  365. }
  366. ]
  367. })
  368. return result
  369. @app.get("/pbs/{value}")
  370. @cache(expire=86400)
  371. async def read_pbs(value:int):
  372. result = service.getPbs(value)
  373. #print(result)
  374. result.insert(0, {"id": "0","key": "0", "label": "全部", "title": "全部"})
  375. return result
  376. @app.get("/jxs/{value}")
  377. @cache(expire=86400)
  378. async def read_jxs(value:int):
  379. result = service.getJxs(value)
  380. #print(result)
  381. result.insert(0, {"id": "0","key": "0", "label": "全部", "title": "全部"})
  382. return result
  383. @app.get("/cls/{value}")
  384. @cache(expire=86400)
  385. async def read_cls(value:int):
  386. result = service.getCls(value)
  387. #print(result)
  388. result.insert(0, {"id": "0","key": "0", "label": "全部", "title": "全部"})
  389. return result
  390. @app.get("/pbxl/{name}/{zhuanye}")
  391. @cache(expire=86400)
  392. async def read_pbxl(name: str, zhuanye: int):
  393. result = service.getPbxl(name, zhuanye)
  394. #print(result)
  395. return result
  396. @app.get("/jxxl/{name}/{zhuanye}")
  397. @cache(expire=86400)
  398. async def read_jxxl(name: str, zhuanye: int):
  399. result = service.getJxxl(name, zhuanye)
  400. #print(result)
  401. return result
  402. @app.get("/clxl/{name}/{zhuanye}")
  403. @cache(expire=86400)
  404. async def read_clxl(name: str, zhuanye: int):
  405. result = service.getClxl(name, zhuanye)
  406. #print(result)
  407. return result
  408. @app.get("/cankao/")
  409. @cache(expire=86400)
  410. async def cankao():
  411. result = service.getCankao()
  412. #print(result)
  413. return result
  414. @app.post("/qufei/")
  415. async def read_qufei(r: Info):
  416. return await db.getQufei(client, r.name)
  417. @app.post("/jiagongcai/")
  418. async def read_jiagongcai(r: Info):
  419. return await db.getJiagongcai(client, r.name)
  420. @app.get("/dexilie/{value}/{id}")
  421. @cache(expire=86400)
  422. async def read_dexilie(value: int, id: str):
  423. if value == 30 and int(id) > 2074:
  424. return service.getDeXilie_azfy(value, id)
  425. if value == 60 and int(id) > 183:
  426. return service.getDeXilie_xsazfy(value, id)
  427. result = service.getDeXilie(value, id)
  428. #print(result)
  429. return result
  430. @app.get("/singledexilie2/{zhuanye}/{debh}")##debh = debh!description
  431. @cache(expire=86400)
  432. async def read_singledexilie2(zhuanye: int, debh: str):
  433. if debh.startswith("D") :
  434. return json.dumps({
  435. "reverse": "None",
  436. "rgde": None,
  437. "jxde": None,
  438. "clde": None,
  439. "actual_zhuanye": zhuanye,
  440. "bz_selected": {"BZBH": {}},
  441. "bz_selected2": {"BZBH": {}}
  442. }, ensure_ascii=False)
  443. if "-F" in debh and zhuanye == 30:
  444. return service.read_singledexilie_azfy(debh)
  445. if "-F" in debh and zhuanye == 60:
  446. return service.read_singledexilie_xsazfy(debh)
  447. r_debh = debh.split("!")[0]
  448. if "附注" in r_debh:
  449. position = r_debh.find("附注")
  450. r_debh = r_debh[:position]
  451. ##print(r_debh)
  452. result1, result2, rgde, jxde, clde, bz_selected, bz_selected2, actual_zhuanye= service.getSingleDeXilie(zhuanye, r_debh)
  453. ##print("get result ***************************************")
  454. if result1:
  455. result3 = json.loads(result1)
  456. else:
  457. result3 = {}
  458. result3["reverse"] = str(result2)
  459. result3["rgde"] = rgde
  460. result3["jxde"] = jxde
  461. result3["clde"] = clde
  462. result3["actual_zhuanye"] = actual_zhuanye
  463. if bz_selected != None:
  464. result3["bz_selected"] = json.loads(bz_selected)
  465. else:
  466. result3["bz_selected"] = {"BZBH": {}}
  467. if bz_selected2 != None:
  468. result3["bz_selected2"] = json.loads(bz_selected2)
  469. else:
  470. result3["bz_selected2"] = {"BZBH": {}}
  471. ####14-227+[14-228]*-2
  472. ####3-409*1.2
  473. ##print(r_debh)
  474. if "[" in r_debh:
  475. position3 = r_debh.find("*")
  476. coef = 1
  477. if position3 == -1:
  478. pass
  479. else:
  480. coef = r_debh[1 + position3:]
  481. ##print(coef)
  482. tail = 0
  483. for i in range(0, len(coef) + 1):
  484. if i == len(coef):
  485. tail = i
  486. break
  487. if (coef[i] > '9' or coef[i] < '0') and coef[i] != '-' and coef[i] != '.':
  488. tail = i
  489. break
  490. if tail == 0:
  491. ##print("1113111")
  492. result3["reverse"] = 'None'
  493. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  494. coef = float(coef[0:tail])
  495. position1 = r_debh.find("[")
  496. position2 = r_debh.find("]")
  497. if position2 == -1:
  498. ##print("1121111")
  499. result3["reverse"] = 'None'
  500. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  501. if r_debh[position1-1] == "+":
  502. pass
  503. elif r_debh[position1-1] == "-":
  504. coef = -coef
  505. else:
  506. ##print("111111")
  507. result3["reverse"] = 'None'
  508. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  509. debh = r_debh[position1+1: position2]
  510. if result3['GLDE']: ##csv文件里的字段,表示这个定额有没有配套的增减定额
  511. hit = False
  512. for key, value in result3['GLDE'].items():
  513. if value == debh:
  514. hit = True
  515. if not hit:
  516. result3["reverse"] = 'None'
  517. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  518. else:
  519. result3["reverse"] = 'None'
  520. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  521. result1_, result2_, rgde_, jxde_, clde_, bz_selected_, bz_selected2_, actual_zhuanye_ = service.getSingleDeXilie(zhuanye, debh)
  522. if result1_:
  523. util.mergerg(rgde, rgde_, coef)
  524. util.mergejx(jxde, jxde_, coef)
  525. util.mergecl(clde, clde_, coef)
  526. result3["rgde"] = rgde
  527. result3["jxde"] = jxde
  528. result3["clde"] = clde
  529. item_ = None
  530. for item in result3['DW'].keys():
  531. item_ = item
  532. result3['DEBH'] = {item_: util.cleanBM(r_debh)}
  533. else:
  534. result3["reverse"] = 'None'
  535. elif "*" in r_debh:##1-234*1.2
  536. position3 = r_debh.find("*")
  537. coef = 1
  538. coef = r_debh[1 + position3:]
  539. ##print(coef)
  540. tail = 0
  541. for i in range(0, len(coef) + 1):
  542. if i == len(coef):
  543. tail = i
  544. break
  545. if (coef[i] > '9' or coef[i] < '0') and coef[i] != '-' and coef[i] != '.':
  546. tail = i
  547. break
  548. if tail == 0:
  549. ##print("1113111")
  550. result3["reverse"] = 'None'
  551. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  552. coef = float(coef[0:tail])
  553. util.multirg(result3["rgde"], coef)
  554. util.multijx(result3["jxde"], coef)
  555. util.multicl(result3["clde"], coef)
  556. item_ = None
  557. for item in result3['DW'].keys():
  558. item_ = item
  559. result3['DEBH'] = {item_: (r_debh)}
  560. ##print(result3)
  561. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  562. @app.get("/singledexilie/{zhuanye}/{debh}/{mc}")
  563. @cache(expire=86400)
  564. async def read_singledexilie(zhuanye: int, debh: str, mc: str):
  565. if debh.startswith("D") :
  566. return json.dumps({
  567. "reverse": "None",
  568. "rgde": None,
  569. "jxde": None,
  570. "clde": None,
  571. "actual_zhuanye": zhuanye,
  572. "bz_selected": {"BZBH": {}},
  573. "bz_selected2": {"BZBH": {}}
  574. }, ensure_ascii=False)
  575. if "-F" in debh:
  576. if mc == '第一章' or mc == '第二章' or mc == '第三章':
  577. return service.read_singledexilie_xsazfy(debh)
  578. return service.read_singledexilie_azfy(debh)
  579. r_debh = debh.split("!")[0]
  580. if "附注" in r_debh:
  581. position = r_debh.find("附注")
  582. r_debh = r_debh[:position]
  583. ##print(r_debh)
  584. result1, result2, rgde, jxde, clde, bz_selected, bz_selected2, actual_zhuanye= await db.getSingleDeXilie(model, client, zhuanye, r_debh, mc)
  585. ###print("get result ***************************************")
  586. if result1:
  587. result3 = json.loads(result1)
  588. else:
  589. result3 = {}
  590. result3["reverse"] = str(result2)
  591. result3["rgde"] = rgde
  592. result3["jxde"] = jxde
  593. result3["clde"] = clde
  594. result3["actual_zhuanye"] = actual_zhuanye
  595. if bz_selected != None:
  596. result3["bz_selected"] = json.loads(bz_selected)
  597. else:
  598. result3["bz_selected"] = {"BZBH": {}}
  599. if bz_selected2 != None:
  600. result3["bz_selected2"] = json.loads(bz_selected2)
  601. else:
  602. result3["bz_selected2"] = {"BZBH": {}}
  603. ####14-227+[14-228]*-2
  604. ####3-409*2
  605. ##print(r_debh)
  606. if "[" in r_debh:
  607. position3 = r_debh.find("*")
  608. coef = 1
  609. if position3 == -1:
  610. pass
  611. else:
  612. coef = r_debh[1 + position3:]
  613. ##print(coef)
  614. tail = 0
  615. for i in range(0, len(coef) + 1):
  616. if i == len(coef):
  617. tail = i
  618. break
  619. if (coef[i] > '9' or coef[i] < '0') and coef[i] != '-' and coef[i] != '.':
  620. tail = i
  621. break
  622. if tail == 0:
  623. ##print("1113111")
  624. result3["reverse"] = 'None'
  625. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  626. coef = float(coef[0:tail])
  627. position1 = r_debh.find("[")
  628. position2 = r_debh.find("]")
  629. if position2 == -1:
  630. ##print("1121111")
  631. result3["reverse"] = 'None'
  632. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  633. if r_debh[position1-1] == "+":
  634. pass
  635. elif r_debh[position1-1] == "-":
  636. coef = -coef
  637. else:
  638. ##print("111111")
  639. result3["reverse"] = 'None'
  640. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  641. debh = r_debh[position1+1: position2]
  642. if result3['GLDE']: ##csv文件里的字段,表示这个定额有没有配套的增减定额
  643. hit = False
  644. for key, value in result3['GLDE'].items():
  645. if value == debh:
  646. hit = True
  647. if not hit:
  648. result3["reverse"] = 'None'
  649. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  650. else:
  651. result3["reverse"] = 'None'
  652. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  653. result1_, result2_, rgde_, jxde_, clde_, bz_selected_, bz_selected2_, actual_zhuanye_ = await db.getSingleDeXilie(model, client, zhuanye, debh, mc)
  654. if result1_:
  655. util.mergerg(rgde, rgde_, coef)
  656. util.mergejx(jxde, jxde_, coef)
  657. util.mergecl(clde, clde_, coef)
  658. result3["rgde"] = rgde
  659. result3["jxde"] = jxde
  660. result3["clde"] = clde
  661. item_ = None
  662. for item in result3['DW'].keys():
  663. item_ = item
  664. result3['DEBH'] = {item_: util.cleanBM(r_debh)}
  665. else:
  666. result3["reverse"] = 'None'
  667. elif "*" in r_debh:##1-234*1.2
  668. position3 = r_debh.find("*")
  669. coef = 1
  670. coef = r_debh[1 + position3:]
  671. ##print(coef)
  672. tail = 0
  673. for i in range(0, len(coef) + 1):
  674. if i == len(coef):
  675. tail = i
  676. break
  677. if (coef[i] > '9' or coef[i] < '0') and coef[i] != '-' and coef[i] != '.':
  678. tail = i
  679. break
  680. if tail == 0:
  681. ##print("1113111")
  682. result3["reverse"] = 'None'
  683. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  684. coef = float(coef[0:tail])
  685. util.multirg(result3["rgde"], coef)
  686. util.multijx(result3["jxde"], coef)
  687. util.multicl(result3["clde"], coef)
  688. item_ = None
  689. for item in result3['DW'].keys():
  690. item_ = item
  691. result3['DEBH'] = {item_: (r_debh)}
  692. ##print(result3)
  693. return json.dumps(service.chaifen(result3, actual_zhuanye), ensure_ascii=False)
  694. @app.post("/save/")
  695. async def save(r: Info):
  696. data = json.loads(r.name)
  697. ##print(data)
  698. return await db.save(client, data)
  699. @app.post("/savedjcs/")
  700. async def savedjcs(r: Info):
  701. data = json.loads(r.name)
  702. ##print(data)
  703. return await db.savedjcs(client, data)
  704. @app.post("/applyFL/")
  705. async def applyFL(r: InfoWithID):
  706. data = json.loads(r.name)
  707. ##print(data)
  708. return await db.applyFL(client, r.id, data)
  709. @app.post("/tiaojia/")
  710. async def tiaojia(r: Tiaojia):
  711. ##return []
  712. glf = r.glf
  713. lr = r.lr
  714. if r.glf == '':
  715. glf = '0'
  716. if r.lr == "":
  717. lr = '0'
  718. return await db.tiaojia(client, r.biao_id, r.bh, r.bm, r.mingcheng, r.danwei, r.jiage, glf, lr, r.bz)
  719. @app.post("/searchde/")
  720. async def searchde(r: SearchDe):
  721. ##return []
  722. return await db.searchde(client, r.zhuanye, r.text)
  723. @app.post("/updatezjcs/")
  724. async def updatezjcs(r: UpdateZjcs):
  725. ##return []
  726. return await db.updatezjcs(client, r.biao_id, r.bh, r.mc, r.fl)
  727. @app.post("/upload/")
  728. async def upload(file: UploadFile):
  729. if file.filename.endswith('13jz') or file.filename.endswith("13jt"):
  730. content = await file.read()
  731. string = content.decode('utf-8')
  732. await resolve(string)
  733. return [file.filename]
  734. elif file.filename.endswith("jszf"):
  735. content = await file.read()
  736. string = content.decode('utf-8')
  737. root = ET.fromstring(string)
  738. for child in root:
  739. ##print(child)
  740. if child.tag == "ZBFileContent":
  741. base64_bytes = child.text.encode("ascii")
  742. sample_string_bytes = base64.b64decode(base64_bytes)
  743. tmp = str(uuid.uuid4())
  744. os.mkdir(os.path.join("tmp", tmp))
  745. with open(tmp, "wb") as file_:
  746. file_.write(sample_string_bytes)
  747. with zipfile.ZipFile(tmp, 'r') as zip_ref:
  748. zip_ref.extractall(os.path.join("tmp", tmp))
  749. dir_list = os.listdir(os.path.join("tmp", tmp))
  750. ##print(dir_list)
  751. for entry in dir_list:
  752. if entry.endswith("13jz"):
  753. with open(os.path.join("tmp", tmp, entry), 'r') as f:
  754. await resolve(f.read())
  755. return [file.filename]
  756. else:
  757. return [file.filename]
  758. @app.get("/download/{item_id}")
  759. async def download_file(item_id):
  760. tmp = str(uuid.uuid4())
  761. file_path = "export/contacts.xml.b"
  762. # Create the root element
  763. root = ET.Element("JingJiBiao")
  764. # Create a sub-element
  765. ##TouBiaoXx = ET.SubElement(root, "TouBiaoXx")
  766. await db.build(client, root, item_id)
  767. # Create the tree and write to a file
  768. tree = ET.ElementTree(root)
  769. tree.write("export/contacts.xml"+tmp, encoding="utf-8")
  770. dom = MD.parse("export/contacts.xml"+tmp)
  771. with open("export/contacts.xml.b" + tmp, 'w') as f:
  772. f.write("<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n")
  773. content = (dom.toprettyxml(indent=" "))
  774. content_ = content.split("\n")
  775. f.write("\n".join(content_[1:]))
  776. return FileResponse(file_path+tmp, media_type='application/octet-stream', filename="contacts.xml")
  777. async def resolve(data):
  778. await db.resolve(data, client)##manager.send_personal_message(f"You wrote: {data}", websocket)
  779. ##@app.websocket("/ws")
  780. ##async def websocket_endpoint(websocket: WebSocket):
  781. ## await manager.connect(websocket)
  782. ## try:
  783. ## while True:
  784. ## data = await websocket.receive_text()
  785. ## await resolve(websocket, data)
  786. ## ##await manager.broadcast(f"Client #{client_id} says: {data}")
  787. ## except WebSocketDisconnect:
  788. ## manager.disconnect(websocket)
  789. ## ##await manager.broadcast(f"Client left the chat")