api.py 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733
  1. from natsort.natsort import order_by_index
  2. from sqlalchemy import func
  3. from models import *
  4. import requests
  5. import json
  6. from logger import logger
  7. from serial.tools import list_ports
  8. from model import PhotoRecord
  9. import settings, datetime
  10. import pandas as pd
  11. from utils.hlm_http_request import forward_request
  12. from utils.utils_func import check_path
  13. from sockets.socket_client import socket_manager
  14. from mcu.DeviceControl import DeviceControl
  15. import time, shutil, os
  16. from sqlalchemy import and_, asc, desc
  17. from functools import partial
  18. from service.deal_image import DealImage
  19. from databases import DeviceConfig, SysConfigs, SqlQuery, CRUD, select,DeviceConfigTabs
  20. from service.run_main import RunMain
  21. import importlib
  22. from service.auto_deal_pics.upload_pic import UploadPic
  23. from service.OnePicTest import OnePicTest
  24. import hashlib
  25. import win32api, win32gui, win32con
  26. from win32gui import EnumWindows, GetWindowText
  27. # from service.AutoDealPics import AutoDealPics
  28. # for plugin in settings.plugins:
  29. # module_path, class_name = plugin.rsplit(".", 1)
  30. # print("module_path", module_path, class_name)
  31. # module = importlib.import_module(module_path)
  32. # getattr(module, class_name)
  33. def calculate_md5(filepath):
  34. # 打开文件,以二进制只读模式打开
  35. with open(filepath, "rb") as f:
  36. # 创建MD5哈希对象
  37. md5hash = hashlib.md5()
  38. # 循环读取文件的内容并更新哈希对象
  39. for chunk in iter(lambda: f.read(4096), b""):
  40. md5hash.update(chunk)
  41. # 返回MD5哈希的十六进制表示
  42. return md5hash.hexdigest()
  43. @app.get("/")
  44. async def index():
  45. # await socket_manager.send_message(msg="测试")
  46. return {"message": "Hello World"}
  47. @app.get("/scan_serials", description="扫描可用的设备端口")
  48. async def scanSerials():
  49. """扫描串口"""
  50. ports = list_ports.comports()
  51. print("Scanning", ports)
  52. return {"message": "Hello World"}
  53. @app.api_route("/forward_request", methods=["GET", "POST"], description="代理转发hlm项目得请求")
  54. async def forwardRequest(request: HlmForwardRequest):
  55. """
  56. 转发HTTP请求到目标URL
  57. :param request: FastAPI Request对象
  58. :return: 目标接口的响应
  59. """
  60. try:
  61. if request.method == "GET":
  62. params = request.query_params
  63. elif request.method == "POST":
  64. params = json.dump(request.query_params)
  65. else:
  66. raise UnicornException("仅支持GET和POST方法")
  67. target_url = request.target_url
  68. method = request.method.upper()
  69. headers = request.headers
  70. if not target_url:
  71. raise UnicornException("目标url地址不能为空")
  72. # 调用 hlm_http_request 中的 forward_request 函数
  73. response = forward_request(target_url, params=params, method=method, headers=headers)
  74. return response
  75. except requests.RequestException as e:
  76. raise UnicornException(e)
  77. except Exception as e:
  78. raise UnicornException(e)
  79. def fromExcelHandler(params: HandlerDetail):
  80. excel_path = params.excel_path
  81. excel_df = pd.read_excel(excel_path, sheet_name=0, header=0)
  82. handler_result = []
  83. handler_result_folder = ""
  84. if "文件夹名称" not in excel_df.columns:
  85. raise UnicornException("缺失 [文件夹名称] 列")
  86. if "商品货号" not in excel_df.columns:
  87. raise UnicornException("缺失 [商品货号] 列")
  88. for index, row in excel_df.iterrows():
  89. goods_art_no_image_dir = str(row["文件夹名称"])
  90. goods_art_no = str(row["商品货号"])
  91. try:
  92. if not goods_art_no:
  93. raise UnicornException("货号不能为空")
  94. token = "Bearer " + params.token
  95. session = SqlQuery()
  96. pr = CRUD(PhotoRecord)
  97. images = pr.read_all(session, conditions={"goods_art_no": goods_art_no})
  98. if not images:
  99. raise UnicornException("没有可用货号数据")
  100. image_dir = "{}/data/".format(os.getcwd()).replace("\\", "/")
  101. check_path(image_dir)
  102. for itemImg in images:
  103. if itemImg.image_path == "" or itemImg.image_path == None:
  104. raise UnicornException(
  105. f"货号【{goods_art_no}】存在没有拍摄完成的图片,请重拍或删除后重试"
  106. )
  107. if not os.path.exists(image_dir + "/" + os.path.basename(itemImg.image_path)):
  108. shutil.copy(itemImg.image_path, image_dir)
  109. dealImage = DealImage(image_dir)
  110. resFlag, path = dealImage.dealMoveImage(
  111. image_dir=image_dir,
  112. callback_func=None,
  113. goods_art_no=goods_art_no_image_dir,
  114. )
  115. if not resFlag:
  116. raise UnicornException(path)
  117. temp_class = {}
  118. temp_name_list = []
  119. for tempItem in params.temp_list:
  120. temp_class[tempItem.template_id] = tempItem.template_local_classes
  121. temp_name_list.append(tempItem.template_id)
  122. # if goods_art_no_image_dir not in path:
  123. # path = path + "/" + goods_art_no_image_dir
  124. config_data = {
  125. "image_dir": path,
  126. "image_order": params.template_image_order,
  127. "goods_art_no": goods_art_no,
  128. "is_check_number": False,
  129. "resize_image_view": "后跟",
  130. "cutout_mode": settings.CUTOUT_MODE,
  131. "logo_path": params.logo_path,
  132. "special_goods_art_no_folder_line": "",
  133. "is_use_excel": (
  134. False if params.excel_path == "" else True
  135. ), # 是否使用excel
  136. "excel_path": params.excel_path, # excel路径
  137. "is_check_color_is_all": False,
  138. "cutout_is_pass": False,
  139. "assigned_page_dict": {},
  140. "detail_is_pass": False,
  141. "upload_is_pass": False,
  142. "upload_is_enable": False,
  143. "is_filter": False,
  144. "temp_class": temp_class,
  145. "temp_name": params.temp_name,
  146. "temp_name_list": temp_name_list,
  147. "target_error_folder": f"{path}/软件-生成详情错误",
  148. }
  149. # 动态导入类
  150. temp_class_dict = {}
  151. for key, class_path in config_data["temp_class"].items():
  152. module_path, class_name = class_path.rsplit(".", 1)
  153. module = importlib.import_module(module_path)
  154. cls = getattr(module, class_name)
  155. temp_class_dict[key] = cls
  156. config_data["temp_class"] = temp_class_dict
  157. obj = None
  158. run_main = RunMain(obj, token)
  159. return_data = run_main.check_before_cutout(config_data)
  160. cutout_res = run_main.check_for_cutout_image_first_call_back(return_data)
  161. check_for_detail_first_res = None
  162. if cutout_res == True:
  163. return_data_check_before_detail = run_main.check_before_detail(config_data)
  164. print(
  165. "return_data_check_before_detail======> 测试 ==>",
  166. return_data_check_before_detail,
  167. )
  168. check_for_detail_first_res = run_main.check_for_detail_first_call_back(
  169. return_data_check_before_detail
  170. )
  171. if isinstance(check_for_detail_first_res, partial):
  172. result = check_for_detail_first_res()
  173. try:
  174. config_data = result["config_data"]
  175. except:
  176. config_data = result
  177. if config_data["sign_text"] == "已结束详情处理":
  178. # at_pic = AutoDealPics()
  179. print("config_data", config_data)
  180. if config_data["upload_is_enable"]:
  181. to_deal_dir = "{}/软件-详情图生成".format(config_data["image_dir"])
  182. check_path(to_deal_dir)
  183. print("to_deal_dir", to_deal_dir)
  184. if os.path.exists(to_deal_dir):
  185. upload_pic = UploadPic(
  186. windows=None,
  187. to_deal_dir=to_deal_dir,
  188. config_data=config_data,
  189. token=token,
  190. )
  191. upload_pic.run()
  192. out_put_dir = config_data["out_put_dir"]
  193. out_put_dir_path = "{}/{}".format(os.getcwd(), out_put_dir).replace("\\", "/")
  194. handler_result_folder = os.path.dirname(out_put_dir_path)
  195. handler_result.append({"goods_art_no": goods_art_no, "success": True, "info": "处理成功"})
  196. else:
  197. handler_result.append({"goods_art_no": goods_art_no, "success": False, "info": "处理失败"})
  198. except Exception as e:
  199. handler_result.append({"goods_art_no": goods_art_no, "success": False, "info": str(e)})
  200. handler_result_folder = "/".join(handler_result_folder.split("/")[:-1])
  201. return {
  202. "code": 0,
  203. "msg": "",
  204. "data": {"output_folder": handler_result_folder, "list": handler_result},
  205. }
  206. @app.post("/handle_detail")
  207. async def handle_detail(request: Request, params: HandlerDetail):
  208. goods_art_no_array = params.goods_art_no
  209. is_only_cutout = params.is_only_cutout
  210. handler_result = []
  211. handler_result_folder = ""
  212. if params.excel_path != "" and params.excel_path != None:
  213. return fromExcelHandler(params)
  214. for goods_art_no in goods_art_no_array:
  215. try:
  216. if not goods_art_no:
  217. raise UnicornException("货号不能为空")
  218. token = "Bearer " + params.token
  219. session = SqlQuery()
  220. pr = CRUD(PhotoRecord)
  221. images = pr.read_all(session, conditions={"goods_art_no": goods_art_no})
  222. if not images:
  223. raise UnicornException("没有可用货号数据")
  224. image_dir = "{}/data/".format(os.getcwd()).replace("\\", "/")
  225. check_path(image_dir)
  226. for itemImg in images:
  227. if itemImg.image_path == "" or itemImg.image_path == None:
  228. raise UnicornException(
  229. f"货号【{goods_art_no}】存在没有拍摄完成的图片,请重拍或删除后重试"
  230. )
  231. if not os.path.exists(image_dir + "/" + os.path.basename(itemImg.image_path)):
  232. shutil.copy(itemImg.image_path, image_dir)
  233. dealImage = DealImage(image_dir)
  234. resFlag, path = dealImage.dealMoveImage(
  235. image_dir=image_dir, callback_func=None, goods_art_no=goods_art_no
  236. )
  237. if not resFlag:
  238. raise UnicornException(path)
  239. temp_class = {}
  240. temp_name_list = []
  241. for tempItem in params.temp_list:
  242. temp_class[tempItem.template_id] = tempItem.template_local_classes
  243. temp_name_list.append(tempItem.template_id)
  244. config_data = {
  245. "image_dir": path,
  246. "image_order": params.template_image_order,
  247. "goods_art_no": goods_art_no,
  248. "is_check_number": False,
  249. "resize_image_view": "后跟",
  250. "cutout_mode": settings.CUTOUT_MODE,
  251. "logo_path": params.logo_path,
  252. "special_goods_art_no_folder_line": "",
  253. "is_use_excel": (
  254. False if params.excel_path == "" else True
  255. ), # 是否使用excel
  256. "excel_path": params.excel_path, # excel路径
  257. "is_check_color_is_all": False,
  258. "cutout_is_pass": False,
  259. "assigned_page_dict": {},
  260. "detail_is_pass": False,
  261. "upload_is_pass": False,
  262. "upload_is_enable": False,
  263. "is_filter": False,
  264. "temp_class": temp_class,
  265. "temp_name": params.temp_name,
  266. "temp_name_list": temp_name_list,
  267. "target_error_folder": f"{path}/软件-生成详情错误",
  268. }
  269. # 动态导入类
  270. temp_class_dict = {}
  271. for key, class_path in config_data["temp_class"].items():
  272. module_path, class_name = class_path.rsplit(".", 1)
  273. module = importlib.import_module(module_path)
  274. cls = getattr(module, class_name)
  275. temp_class_dict[key] = cls
  276. config_data["temp_class"] = temp_class_dict
  277. obj = None
  278. run_main = RunMain(obj, token)
  279. return_data = run_main.check_before_cutout(config_data)
  280. cutout_res = run_main.check_for_cutout_image_first_call_back(return_data)
  281. check_for_detail_first_res = None
  282. if is_only_cutout == 1 and cutout_res == True:
  283. out_put_dir = return_data["data"]["image_dir"] + "/" + goods_art_no
  284. out_put_dir_path = "{}/{}".format(os.getcwd(), out_put_dir).replace(
  285. "\\", "/"
  286. )
  287. # print("out_put_dir_path", out_put_dir_path)
  288. handler_result_folder = out_put_dir_path
  289. handler_result.append(
  290. {"goods_art_no": goods_art_no, "success": True, "info": "处理成功"}
  291. )
  292. # print("检测到需要裁剪图片,开始裁剪图片", return_data)
  293. continue
  294. if cutout_res == True:
  295. return_data_check_before_detail = run_main.check_before_detail(config_data)
  296. print(
  297. "return_data_check_before_detail======> 测试 ==>",
  298. return_data_check_before_detail,
  299. )
  300. check_for_detail_first_res = run_main.check_for_detail_first_call_back(
  301. return_data_check_before_detail
  302. )
  303. if isinstance(check_for_detail_first_res, partial):
  304. result = check_for_detail_first_res()
  305. try:
  306. config_data = result["config_data"]
  307. except:
  308. config_data = result
  309. if config_data["sign_text"] == "已结束详情处理":
  310. # at_pic = AutoDealPics()
  311. print("config_data", config_data)
  312. if config_data["upload_is_enable"]:
  313. to_deal_dir = "{}/软件-详情图生成".format(config_data["image_dir"])
  314. check_path(to_deal_dir)
  315. print("to_deal_dir", to_deal_dir)
  316. if os.path.exists(to_deal_dir):
  317. upload_pic = UploadPic(
  318. windows=None,
  319. to_deal_dir=to_deal_dir,
  320. config_data=config_data,
  321. token=token,
  322. )
  323. upload_pic.run()
  324. out_put_dir = config_data["out_put_dir"]
  325. out_put_dir_path = "{}/{}".format(os.getcwd(), out_put_dir).replace("\\", "/")
  326. handler_result_folder = os.path.dirname(out_put_dir_path)
  327. handler_result.append({"goods_art_no": goods_art_no, "success": True, "info": "处理成功"})
  328. else:
  329. handler_result.append({"goods_art_no": goods_art_no, "success": False, "info": "处理失败"})
  330. except Exception as e:
  331. handler_result.append({"goods_art_no": goods_art_no, "success": False, "info": str(e)})
  332. return {
  333. "code": 0,
  334. "msg": "",
  335. "data": {"output_folder": handler_result_folder, "list": handler_result},
  336. }
  337. @app.get("/get_device_tabs", description="获取可执行程序命令列表")
  338. def get_device_tabs(type:int):
  339. session = SqlQuery()
  340. statement = (
  341. select(DeviceConfigTabs)
  342. .where(DeviceConfigTabs.mode_type == type).order_by(asc("id"))
  343. )
  344. result = session.exec(statement).all()
  345. session.close()
  346. sys = CRUD(SysConfigs)
  347. action_configs = sys.read(session, conditions={"key": "action_configs"})
  348. session.close()
  349. return {
  350. "code": 0,
  351. "msg": "",
  352. "data": {"tabs": result, "select_configs": json.loads(action_configs.value)},
  353. }
  354. @app.post("/update_tab_name", description="更改tab名称")
  355. def update_tab_name(params: DeviceConfigTabsReq):
  356. if params.mode_name == "":
  357. return {"code": 1, "msg": "名称不能为空", "data": {}}
  358. session = SqlQuery()
  359. tabModel = CRUD(DeviceConfigTabs)
  360. kwargs = {"mode_name": params.mode_name}
  361. tabModel.updateConditions(session, conditions={"id": params.id}, **kwargs)
  362. session.close()
  363. return {
  364. "code": 0,
  365. "msg": "",
  366. "data": None,
  367. }
  368. @app.post("/get_device_configs", description="获取可执行程序命令列表")
  369. def get_device_configs(params: ModelGetDeviceConfig):
  370. tab_id = params.tab_id
  371. session = SqlQuery()
  372. configModel = CRUD(DeviceConfig)
  373. configList = configModel.read_all(
  374. session,
  375. conditions={"tab_id": tab_id},
  376. order_by="action_index",
  377. ascending=True,
  378. )
  379. return {
  380. "code": 0,
  381. "msg": "",
  382. "data": {"list": configList},
  383. }
  384. @app.post("/device_config_detail", description="获取可执行程序详情")
  385. def get_device_configs(params: ModelGetDeviceConfigDetail):
  386. action_id = params.id
  387. session = SqlQuery()
  388. configModel = CRUD(DeviceConfig)
  389. model = configModel.read(session, conditions={"id": action_id})
  390. if model == None:
  391. return {"code": 1, "msg": "数据不存在", "data": None}
  392. return {"code": 0, "msg": "", "data": model}
  393. @app.post("/device_config_detail_query", description="通过条件获取可执行程序详情")
  394. def device_config_detail_query():
  395. # tab_id = params.tab_id
  396. # action_name = params.action_name
  397. session = SqlQuery()
  398. sys = CRUD(SysConfigs)
  399. action_configs = sys.read(session, conditions={"key": "action_configs"})
  400. action_configs_value = json.loads(action_configs.value)
  401. left_config = action_configs_value.get("left")
  402. configModel = CRUD(DeviceConfig)
  403. model = configModel.read(
  404. session, conditions={"tab_id": left_config, "action_name": "侧视"}
  405. )
  406. if model == None:
  407. model = configModel.read(
  408. session, conditions={"tab_id": left_config}
  409. )
  410. return {"code": 0, "msg": "", "data": model}
  411. @app.post("/remove_config", description="删除一条可执行命令")
  412. def get_device_configs(params: ModelGetDeviceConfigDetail):
  413. action_id = params.id
  414. session = SqlQuery()
  415. configModel = CRUD(DeviceConfig)
  416. model = configModel.read(session, conditions={"id": action_id})
  417. if model == None:
  418. return {"code": 1, "msg": "数据不存在", "data": None}
  419. if model.is_system == True:
  420. return {"code": 1, "msg": "系统配置不允许删除", "data": None}
  421. configArray = configModel.read_all(session, conditions={"tab_id": model.tab_id})
  422. if len(configArray) == 1:
  423. return {"code": 1, "msg": "请至少保留一个配置", "data": None}
  424. configModel.delete(session, obj_id=action_id)
  425. return {"code": 0, "msg": "删除成功", "data": None}
  426. @app.post("/save_device_config", description="创建或修改一条可执行命令")
  427. def save_device_config(params: SaveDeviceConfig):
  428. action_id = params.id
  429. session = SqlQuery()
  430. deviceConfig = CRUD(DeviceConfig)
  431. if action_id == None or action_id == 0:
  432. # 走新增逻辑
  433. params.id = None
  434. save_device_config = deviceConfig.create(session, obj_in=params)
  435. else:
  436. model = deviceConfig.read(session, conditions={"id": action_id})
  437. if model == None:
  438. return {"code": 1, "msg": "数据不存在", "data": None}
  439. # 走编辑逻辑
  440. kwargs = params.__dict__
  441. save_device_config = deviceConfig.update(session, obj_id=action_id, **kwargs)
  442. return {"code": 0, "msg": "操作成功", "data": save_device_config}
  443. @app.post("/reset_config", description="创建或修改一条可执行命令")
  444. def reset_config(params: ModelGetDeviceConfig):
  445. tab_id = params.tab_id
  446. if tab_id == None or tab_id == "":
  447. return {"code": 1, "msg": "参数错误", "data": None}
  448. session = SqlQuery()
  449. deviceConfig = CRUD(DeviceConfig)
  450. first_config = deviceConfig.read(session, conditions={"tab_id": tab_id})
  451. res = deviceConfig.deleteConditions(session, conditions={"tab_id": tab_id})
  452. if res is False:
  453. return {"code": 1, "msg": "操作失败", "data": None}
  454. actions = json.load(open("action.json", encoding="utf-8"))
  455. for data in actions:
  456. data["tab_id"] = tab_id
  457. data["is_system"] = first_config.is_system
  458. device_config = DeviceConfig(**data)
  459. session.add(device_config)
  460. session.commit()
  461. session.close()
  462. return {"code": 0, "msg": "操作成功", "data": None}
  463. @app.get("/get_photo_records", description="获取拍照记录")
  464. def get_photo_records(page: int = 1, size: int = 5):
  465. session = SqlQuery()
  466. photos = CRUD(PhotoRecord)
  467. print("准备查询拍摄记录", datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
  468. statement = (
  469. select(PhotoRecord)
  470. .offset((page - 1) * size)
  471. .limit(size)
  472. .order_by(desc("id"))
  473. .group_by("goods_art_no")
  474. )
  475. list = []
  476. result = session.exec(statement).all()
  477. print("group 完成 ", datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
  478. join_conditions = [
  479. {
  480. "model": DeviceConfig,
  481. "on": PhotoRecord.action_id == DeviceConfig.id,
  482. "is_outer": False, # 可选,默认False,设为True则为LEFT JOIN
  483. }
  484. ]
  485. for item in result:
  486. print(item)
  487. # list_item = photos.read_all(
  488. # session,
  489. # conditions={"goods_art_no": item.goods_art_no},
  490. # join_conditions=join_conditions,
  491. # )
  492. query = (
  493. select(PhotoRecord, DeviceConfig.action_name)
  494. .where(PhotoRecord.goods_art_no == item.goods_art_no)
  495. .join(DeviceConfig, PhotoRecord.action_id == DeviceConfig.id)
  496. )
  497. list_item = session.exec(query).mappings().all()
  498. session.close()
  499. list.append(
  500. {
  501. "goods_art_no": item.goods_art_no,
  502. "action_time": item.create_time,
  503. "items": list_item,
  504. }
  505. )
  506. session.close()
  507. print("循环查询 完成 ", datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
  508. return {
  509. "code": 0,
  510. "msg": "",
  511. "data": {"list": list, "page": page, "size": size},
  512. }
  513. @app.get("/get_last_photo_record", description="获取最后一条拍照记录")
  514. def get_last_photo_record():
  515. session = SqlQuery()
  516. statement = select(PhotoRecord).where(PhotoRecord.image_path != None).order_by(desc("photo_create_time"))
  517. result = session.exec(statement).first()
  518. session.close()
  519. return {
  520. "code": 0,
  521. "msg": "",
  522. "data": result,
  523. }
  524. @app.get("/get_photo_record_detail", description="通过货号获取拍照记录详情")
  525. def get_photo_records(goods_art_no: str = None):
  526. if goods_art_no == None:
  527. return {"code": 1, "msg": "参数错误", "data": None}
  528. session = SqlQuery()
  529. photos = CRUD(PhotoRecord)
  530. items = photos.read_all(session, conditions={"goods_art_no": goods_art_no})
  531. session.close()
  532. return {
  533. "code": 0,
  534. "msg": "",
  535. "data": {"list": items},
  536. }
  537. @app.post("/delect_goods_arts", description="通过货号删除记录")
  538. def delect_goods_arts(params: PhotoRecordDelete):
  539. session = SqlQuery()
  540. photos = CRUD(PhotoRecord)
  541. for item in params.goods_art_nos:
  542. photos.deleteConditions(session, conditions={"goods_art_no": item})
  543. session.close()
  544. return {
  545. "code": 0,
  546. "msg": "操作成功",
  547. "data": None,
  548. }
  549. @app.get("/get_sys_config", description="查询系统配置")
  550. def get_sys_config(key: str = None):
  551. if key == None:
  552. return {"code": 1, "msg": "参数错误", "data": None}
  553. session = SqlQuery()
  554. photos = CRUD(SysConfigs)
  555. item = photos.read(session, conditions={"key": key})
  556. session.close()
  557. return {
  558. "code": 0,
  559. "msg": "",
  560. "data": json.loads(item.value),
  561. }
  562. @app.post("/update_left_right_config", description="更新左右脚配置")
  563. def update_left_right_config(params: LeftRightParams):
  564. session = SqlQuery()
  565. sysConfig = CRUD(SysConfigs)
  566. model = sysConfig.read(session, conditions={"key": "action_configs"})
  567. if model == None:
  568. return {"code": 1, "msg": "配置不存在", "data": None}
  569. config_value = json.loads(model.value)
  570. config_value[params.type] = params.id
  571. update_value = json.dumps(config_value)
  572. # 走编辑逻辑
  573. kwargs = {"key": "action_configs", "value": update_value}
  574. save_device_config = sysConfig.updateConditions(
  575. session, conditions={"key": "action_configs"}, **kwargs
  576. )
  577. # return {"code": 0, "msg": "操作成功", "data": save_device_config}
  578. return {"code": 0, "msg": "操作成功", "data": None}
  579. @app.post("/update_sys_configs", description="创建或修改系统配置")
  580. def save_sys_configs(params: SysConfigParams):
  581. session = SqlQuery()
  582. sysConfig = CRUD(SysConfigs)
  583. model = sysConfig.read(session, conditions={"key": params.key})
  584. if model == None:
  585. return {"code": 1, "msg": "配置不存在", "data": None}
  586. # 走编辑逻辑
  587. kwargs = params.__dict__
  588. save_device_config = sysConfig.updateConditions(session, conditions={"key": params.key}, **kwargs)
  589. return {"code": 0, "msg": "操作成功", "data": save_device_config}
  590. @app.post("/create_main_image", description="创建主图测试")
  591. def create_main_image(params: MaineImageTest):
  592. file_path = params.file_path
  593. onePic = OnePicTest(pic_path=file_path)
  594. # session = SqlQuery()
  595. # sysConfig = CRUD(SysConfigs)
  596. # model = sysConfig.read(session, conditions={"key": params.key})
  597. # if model == None:
  598. # return {"code": 1, "msg": "配置不存在", "data": None}
  599. # # 走编辑逻辑
  600. # kwargs = params.__dict__
  601. # save_device_config = sysConfig.updateConditions(
  602. # session, conditions={"key": params.key}, **kwargs
  603. # )
  604. main_out_path = onePic.HandlerMainImage()
  605. return {"code": 0, "msg": "操作成功", "data": {"main_out_path": main_out_path}}
  606. def insertEmptyLogoList(session):
  607. """插入空logo列表"""
  608. data = {"key": "logo_configs", "value": "[]"}
  609. config = SysConfigs(**data)
  610. session.add(config)
  611. session.commit()
  612. session.close()
  613. item = SysConfigs()
  614. item.key = "logo_configs"
  615. item.value = "[]"
  616. return item
  617. @app.get("/logo_list", description="logo列表")
  618. def logo_list():
  619. logo_dir = "{}/data/logo/".format(os.getcwd()).replace("\\", "/")
  620. check_path(logo_dir)
  621. logo_files = os.listdir(logo_dir)
  622. logo_list = []
  623. for logoItem in logo_files:
  624. logo_list.append(f"{logo_dir}{logoItem}")
  625. return {"code": 0, "msg": "操作成功", "data": logo_list}
  626. @app.post("/add_logo", description="添加logo")
  627. def add_logo(params: LogoParams):
  628. logo_path = params.logo_path.replace("\\", "/")
  629. session = SqlQuery()
  630. sysConfig = CRUD(SysConfigs)
  631. item = sysConfig.read(session, conditions={"key": "logo_configs"})
  632. if item == None:
  633. item = insertEmptyLogoList(session)
  634. if os.path.isfile(logo_path) == False:
  635. return {"code": 1, "msg": "logo文件不存在", "data": None}
  636. logo_dir = "{}/data/logo/".format(os.getcwd()).replace("\\", "/")
  637. check_path(logo_dir)
  638. fpath, fname = os.path.split(logo_path)
  639. logo_path_info = logo_dir + fname
  640. shutil.copy(logo_path, logo_path_info) # 复制文件
  641. logo_files = os.listdir(logo_dir)
  642. logo_list = []
  643. for logoItem in logo_files:
  644. logo_list.append(f"{logo_dir}{logoItem}")
  645. return {
  646. "code": 0,
  647. "msg": "",
  648. "data": {"logo": logo_path_info},
  649. }
  650. @app.post("/delete_logo", description="删除logo")
  651. def delete_logo(params: LogoParamsupdate):
  652. logo_path = params.path
  653. if os.path.isfile(logo_path) == False:
  654. return {"code": 1, "msg": "logo文件不存在", "data": None}
  655. os.remove(logo_path)
  656. logo_dir = "{}/data/logo/".format(os.getcwd()).replace("\\", "/")
  657. check_path(logo_dir)
  658. logo_files = os.listdir(logo_dir)
  659. logo_list = []
  660. for logoItem in logo_files:
  661. logo_list.append(f"{logo_dir}{logoItem}")
  662. return {"code": 0, "msg": "操作成功", "data": logo_list}
  663. @app.post("/close_other_window", description="关闭窗口")
  664. def close_other_window():
  665. hwnd_list = []
  666. def callback(hwnd, _):
  667. title = GetWindowText(hwnd)
  668. if title == "digiCamControl by Duka Istvan":
  669. hwnd_list.append(hwnd)
  670. EnumWindows(callback, None)
  671. if hwnd_list:
  672. hwnd = hwnd_list[0]
  673. win32gui.PostMessage(hwnd, win32con.WM_CLOSE, 0, 0)
  674. return {"code": 0, "msg": "关闭成功", "data": {"status":True}}
  675. return {"code": 0, "msg": "关闭失败", "data": {"status": False}}