api.py 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739
  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. detail_counts = len(params.template_image_order.split(","))
  225. image_counts = len(images)
  226. if image_counts < detail_counts:
  227. raise UnicornException(
  228. f"货号:[{goods_art_no}],实际照片数量:{image_counts}张,小于详情图要求数量:{detail_counts}张"
  229. )
  230. image_dir = "{}/data/".format(os.getcwd()).replace("\\", "/")
  231. check_path(image_dir)
  232. for itemImg in images:
  233. if itemImg.image_path == "" or itemImg.image_path == None:
  234. raise UnicornException(
  235. f"货号【{goods_art_no}】存在没有拍摄完成的图片,请重拍或删除后重试"
  236. )
  237. if not os.path.exists(image_dir + "/" + os.path.basename(itemImg.image_path)):
  238. shutil.copy(itemImg.image_path, image_dir)
  239. dealImage = DealImage(image_dir)
  240. resFlag, path = dealImage.dealMoveImage(
  241. image_dir=image_dir, callback_func=None, goods_art_no=goods_art_no
  242. )
  243. if not resFlag:
  244. raise UnicornException(path)
  245. temp_class = {}
  246. temp_name_list = []
  247. for tempItem in params.temp_list:
  248. temp_class[tempItem.template_id] = tempItem.template_local_classes
  249. temp_name_list.append(tempItem.template_id)
  250. config_data = {
  251. "image_dir": path,
  252. "image_order": params.template_image_order,
  253. "goods_art_no": goods_art_no,
  254. "is_check_number": False,
  255. "resize_image_view": "后跟",
  256. "cutout_mode": settings.CUTOUT_MODE,
  257. "logo_path": params.logo_path,
  258. "special_goods_art_no_folder_line": "",
  259. "is_use_excel": (
  260. False if params.excel_path == "" else True
  261. ), # 是否使用excel
  262. "excel_path": params.excel_path, # excel路径
  263. "is_check_color_is_all": False,
  264. "cutout_is_pass": False,
  265. "assigned_page_dict": {},
  266. "detail_is_pass": False,
  267. "upload_is_pass": False,
  268. "upload_is_enable": False,
  269. "is_filter": False,
  270. "temp_class": temp_class,
  271. "temp_name": params.temp_name,
  272. "temp_name_list": temp_name_list,
  273. "target_error_folder": f"{path}/软件-生成详情错误",
  274. }
  275. # 动态导入类
  276. temp_class_dict = {}
  277. for key, class_path in config_data["temp_class"].items():
  278. module_path, class_name = class_path.rsplit(".", 1)
  279. module = importlib.import_module(module_path)
  280. cls = getattr(module, class_name)
  281. temp_class_dict[key] = cls
  282. config_data["temp_class"] = temp_class_dict
  283. obj = None
  284. run_main = RunMain(obj, token)
  285. return_data = run_main.check_before_cutout(config_data)
  286. cutout_res = run_main.check_for_cutout_image_first_call_back(return_data)
  287. check_for_detail_first_res = None
  288. if is_only_cutout == 1 and cutout_res == True:
  289. out_put_dir = return_data["data"]["image_dir"] + "/" + goods_art_no
  290. out_put_dir_path = "{}/{}".format(os.getcwd(), out_put_dir).replace(
  291. "\\", "/"
  292. )
  293. # print("out_put_dir_path", out_put_dir_path)
  294. handler_result_folder = os.path.dirname(out_put_dir_path)
  295. handler_result.append(
  296. {"goods_art_no": goods_art_no, "success": True, "info": "处理成功"}
  297. )
  298. # print("检测到需要裁剪图片,开始裁剪图片", return_data)
  299. continue
  300. if cutout_res == True:
  301. return_data_check_before_detail = run_main.check_before_detail(config_data)
  302. print(
  303. "return_data_check_before_detail======> 测试 ==>",
  304. return_data_check_before_detail,
  305. )
  306. check_for_detail_first_res = run_main.check_for_detail_first_call_back(
  307. return_data_check_before_detail
  308. )
  309. if isinstance(check_for_detail_first_res, partial):
  310. result = check_for_detail_first_res()
  311. try:
  312. config_data = result["config_data"]
  313. except:
  314. config_data = result
  315. if config_data["sign_text"] == "已结束详情处理":
  316. # at_pic = AutoDealPics()
  317. print("config_data", config_data)
  318. if config_data["upload_is_enable"]:
  319. to_deal_dir = "{}/软件-详情图生成".format(config_data["image_dir"])
  320. check_path(to_deal_dir)
  321. print("to_deal_dir", to_deal_dir)
  322. if os.path.exists(to_deal_dir):
  323. upload_pic = UploadPic(
  324. windows=None,
  325. to_deal_dir=to_deal_dir,
  326. config_data=config_data,
  327. token=token,
  328. )
  329. upload_pic.run()
  330. out_put_dir = config_data["out_put_dir"]
  331. out_put_dir_path = "{}/{}".format(os.getcwd(), out_put_dir).replace("\\", "/")
  332. handler_result_folder = os.path.dirname(out_put_dir_path)
  333. handler_result.append({"goods_art_no": goods_art_no, "success": True, "info": "处理成功"})
  334. else:
  335. handler_result.append({"goods_art_no": goods_art_no, "success": False, "info": "处理失败"})
  336. except Exception as e:
  337. handler_result.append({"goods_art_no": goods_art_no, "success": False, "info": str(e)})
  338. return {
  339. "code": 0,
  340. "msg": "",
  341. "data": {"output_folder": handler_result_folder, "list": handler_result},
  342. }
  343. @app.get("/get_device_tabs", description="获取可执行程序命令列表")
  344. def get_device_tabs(type:int):
  345. session = SqlQuery()
  346. statement = (
  347. select(DeviceConfigTabs)
  348. .where(DeviceConfigTabs.mode_type == type).order_by(asc("id"))
  349. )
  350. result = session.exec(statement).all()
  351. session.close()
  352. sys = CRUD(SysConfigs)
  353. action_configs = sys.read(session, conditions={"key": "action_configs"})
  354. session.close()
  355. return {
  356. "code": 0,
  357. "msg": "",
  358. "data": {"tabs": result, "select_configs": json.loads(action_configs.value)},
  359. }
  360. @app.post("/update_tab_name", description="更改tab名称")
  361. def update_tab_name(params: DeviceConfigTabsReq):
  362. if params.mode_name == "":
  363. return {"code": 1, "msg": "名称不能为空", "data": {}}
  364. session = SqlQuery()
  365. tabModel = CRUD(DeviceConfigTabs)
  366. kwargs = {"mode_name": params.mode_name}
  367. tabModel.updateConditions(session, conditions={"id": params.id}, **kwargs)
  368. session.close()
  369. return {
  370. "code": 0,
  371. "msg": "",
  372. "data": None,
  373. }
  374. @app.post("/get_device_configs", description="获取可执行程序命令列表")
  375. def get_device_configs(params: ModelGetDeviceConfig):
  376. tab_id = params.tab_id
  377. session = SqlQuery()
  378. configModel = CRUD(DeviceConfig)
  379. configList = configModel.read_all(
  380. session,
  381. conditions={"tab_id": tab_id},
  382. order_by="action_index",
  383. ascending=True,
  384. )
  385. return {
  386. "code": 0,
  387. "msg": "",
  388. "data": {"list": configList},
  389. }
  390. @app.post("/device_config_detail", description="获取可执行程序详情")
  391. def get_device_configs(params: ModelGetDeviceConfigDetail):
  392. action_id = params.id
  393. session = SqlQuery()
  394. configModel = CRUD(DeviceConfig)
  395. model = configModel.read(session, conditions={"id": action_id})
  396. if model == None:
  397. return {"code": 1, "msg": "数据不存在", "data": None}
  398. return {"code": 0, "msg": "", "data": model}
  399. @app.post("/device_config_detail_query", description="通过条件获取可执行程序详情")
  400. def device_config_detail_query():
  401. # tab_id = params.tab_id
  402. # action_name = params.action_name
  403. session = SqlQuery()
  404. sys = CRUD(SysConfigs)
  405. action_configs = sys.read(session, conditions={"key": "action_configs"})
  406. action_configs_value = json.loads(action_configs.value)
  407. left_config = action_configs_value.get("left")
  408. configModel = CRUD(DeviceConfig)
  409. model = configModel.read(
  410. session, conditions={"tab_id": left_config, "action_name": "侧视"}
  411. )
  412. if model == None:
  413. model = configModel.read(
  414. session, conditions={"tab_id": left_config}
  415. )
  416. return {"code": 0, "msg": "", "data": model}
  417. @app.post("/remove_config", description="删除一条可执行命令")
  418. def get_device_configs(params: ModelGetDeviceConfigDetail):
  419. action_id = params.id
  420. session = SqlQuery()
  421. configModel = CRUD(DeviceConfig)
  422. model = configModel.read(session, conditions={"id": action_id})
  423. if model == None:
  424. return {"code": 1, "msg": "数据不存在", "data": None}
  425. if model.is_system == True:
  426. return {"code": 1, "msg": "系统配置不允许删除", "data": None}
  427. configArray = configModel.read_all(session, conditions={"tab_id": model.tab_id})
  428. if len(configArray) == 1:
  429. return {"code": 1, "msg": "请至少保留一个配置", "data": None}
  430. configModel.delete(session, obj_id=action_id)
  431. return {"code": 0, "msg": "删除成功", "data": None}
  432. @app.post("/save_device_config", description="创建或修改一条可执行命令")
  433. def save_device_config(params: SaveDeviceConfig):
  434. action_id = params.id
  435. session = SqlQuery()
  436. deviceConfig = CRUD(DeviceConfig)
  437. if action_id == None or action_id == 0:
  438. # 走新增逻辑
  439. params.id = None
  440. save_device_config = deviceConfig.create(session, obj_in=params)
  441. else:
  442. model = deviceConfig.read(session, conditions={"id": action_id})
  443. if model == None:
  444. return {"code": 1, "msg": "数据不存在", "data": None}
  445. # 走编辑逻辑
  446. kwargs = params.__dict__
  447. save_device_config = deviceConfig.update(session, obj_id=action_id, **kwargs)
  448. return {"code": 0, "msg": "操作成功", "data": save_device_config}
  449. @app.post("/reset_config", description="创建或修改一条可执行命令")
  450. def reset_config(params: ModelGetDeviceConfig):
  451. tab_id = params.tab_id
  452. if tab_id == None or tab_id == "":
  453. return {"code": 1, "msg": "参数错误", "data": None}
  454. session = SqlQuery()
  455. deviceConfig = CRUD(DeviceConfig)
  456. first_config = deviceConfig.read(session, conditions={"tab_id": tab_id})
  457. res = deviceConfig.deleteConditions(session, conditions={"tab_id": tab_id})
  458. if res is False:
  459. return {"code": 1, "msg": "操作失败", "data": None}
  460. actions = json.load(open("action.json", encoding="utf-8"))
  461. for data in actions:
  462. data["tab_id"] = tab_id
  463. data["is_system"] = first_config.is_system
  464. device_config = DeviceConfig(**data)
  465. session.add(device_config)
  466. session.commit()
  467. session.close()
  468. return {"code": 0, "msg": "操作成功", "data": None}
  469. @app.get("/get_photo_records", description="获取拍照记录")
  470. def get_photo_records(page: int = 1, size: int = 5):
  471. session = SqlQuery()
  472. photos = CRUD(PhotoRecord)
  473. print("准备查询拍摄记录", datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
  474. statement = (
  475. select(PhotoRecord)
  476. .offset((page - 1) * size)
  477. .limit(size)
  478. .order_by(desc("id"))
  479. .group_by("goods_art_no")
  480. )
  481. list = []
  482. result = session.exec(statement).all()
  483. print("group 完成 ", datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
  484. join_conditions = [
  485. {
  486. "model": DeviceConfig,
  487. "on": PhotoRecord.action_id == DeviceConfig.id,
  488. "is_outer": False, # 可选,默认False,设为True则为LEFT JOIN
  489. }
  490. ]
  491. for item in result:
  492. print(item)
  493. # list_item = photos.read_all(
  494. # session,
  495. # conditions={"goods_art_no": item.goods_art_no},
  496. # join_conditions=join_conditions,
  497. # )
  498. query = (
  499. select(PhotoRecord, DeviceConfig.action_name)
  500. .where(PhotoRecord.goods_art_no == item.goods_art_no)
  501. .join(DeviceConfig, PhotoRecord.action_id == DeviceConfig.id)
  502. )
  503. list_item = session.exec(query).mappings().all()
  504. session.close()
  505. list.append(
  506. {
  507. "goods_art_no": item.goods_art_no,
  508. "action_time": item.create_time,
  509. "items": list_item,
  510. }
  511. )
  512. session.close()
  513. print("循环查询 完成 ", datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
  514. return {
  515. "code": 0,
  516. "msg": "",
  517. "data": {"list": list, "page": page, "size": size},
  518. }
  519. @app.get("/get_last_photo_record", description="获取最后一条拍照记录")
  520. def get_last_photo_record():
  521. session = SqlQuery()
  522. statement = select(PhotoRecord).where(PhotoRecord.image_path != None).order_by(desc("photo_create_time"))
  523. result = session.exec(statement).first()
  524. session.close()
  525. return {
  526. "code": 0,
  527. "msg": "",
  528. "data": result,
  529. }
  530. @app.get("/get_photo_record_detail", description="通过货号获取拍照记录详情")
  531. def get_photo_records(goods_art_no: str = None):
  532. if goods_art_no == None:
  533. return {"code": 1, "msg": "参数错误", "data": None}
  534. session = SqlQuery()
  535. photos = CRUD(PhotoRecord)
  536. items = photos.read_all(session, conditions={"goods_art_no": goods_art_no})
  537. session.close()
  538. return {
  539. "code": 0,
  540. "msg": "",
  541. "data": {"list": items},
  542. }
  543. @app.post("/delect_goods_arts", description="通过货号删除记录")
  544. def delect_goods_arts(params: PhotoRecordDelete):
  545. session = SqlQuery()
  546. photos = CRUD(PhotoRecord)
  547. for item in params.goods_art_nos:
  548. photos.deleteConditions(session, conditions={"goods_art_no": item})
  549. session.close()
  550. return {
  551. "code": 0,
  552. "msg": "操作成功",
  553. "data": None,
  554. }
  555. @app.get("/get_sys_config", description="查询系统配置")
  556. def get_sys_config(key: str = None):
  557. if key == None:
  558. return {"code": 1, "msg": "参数错误", "data": None}
  559. session = SqlQuery()
  560. photos = CRUD(SysConfigs)
  561. item = photos.read(session, conditions={"key": key})
  562. session.close()
  563. return {
  564. "code": 0,
  565. "msg": "",
  566. "data": json.loads(item.value),
  567. }
  568. @app.post("/update_left_right_config", description="更新左右脚配置")
  569. def update_left_right_config(params: LeftRightParams):
  570. session = SqlQuery()
  571. sysConfig = CRUD(SysConfigs)
  572. model = sysConfig.read(session, conditions={"key": "action_configs"})
  573. if model == None:
  574. return {"code": 1, "msg": "配置不存在", "data": None}
  575. config_value = json.loads(model.value)
  576. config_value[params.type] = params.id
  577. update_value = json.dumps(config_value)
  578. # 走编辑逻辑
  579. kwargs = {"key": "action_configs", "value": update_value}
  580. save_device_config = sysConfig.updateConditions(
  581. session, conditions={"key": "action_configs"}, **kwargs
  582. )
  583. # return {"code": 0, "msg": "操作成功", "data": save_device_config}
  584. return {"code": 0, "msg": "操作成功", "data": None}
  585. @app.post("/update_sys_configs", description="创建或修改系统配置")
  586. def save_sys_configs(params: SysConfigParams):
  587. session = SqlQuery()
  588. sysConfig = CRUD(SysConfigs)
  589. model = sysConfig.read(session, conditions={"key": params.key})
  590. if model == None:
  591. return {"code": 1, "msg": "配置不存在", "data": None}
  592. # 走编辑逻辑
  593. kwargs = params.__dict__
  594. save_device_config = sysConfig.updateConditions(session, conditions={"key": params.key}, **kwargs)
  595. return {"code": 0, "msg": "操作成功", "data": save_device_config}
  596. @app.post("/create_main_image", description="创建主图测试")
  597. def create_main_image(params: MaineImageTest):
  598. file_path = params.file_path
  599. onePic = OnePicTest(pic_path=file_path)
  600. # session = SqlQuery()
  601. # sysConfig = CRUD(SysConfigs)
  602. # model = sysConfig.read(session, conditions={"key": params.key})
  603. # if model == None:
  604. # return {"code": 1, "msg": "配置不存在", "data": None}
  605. # # 走编辑逻辑
  606. # kwargs = params.__dict__
  607. # save_device_config = sysConfig.updateConditions(
  608. # session, conditions={"key": params.key}, **kwargs
  609. # )
  610. main_out_path = onePic.HandlerMainImage()
  611. return {"code": 0, "msg": "操作成功", "data": {"main_out_path": main_out_path}}
  612. def insertEmptyLogoList(session):
  613. """插入空logo列表"""
  614. data = {"key": "logo_configs", "value": "[]"}
  615. config = SysConfigs(**data)
  616. session.add(config)
  617. session.commit()
  618. session.close()
  619. item = SysConfigs()
  620. item.key = "logo_configs"
  621. item.value = "[]"
  622. return item
  623. @app.get("/logo_list", description="logo列表")
  624. def logo_list():
  625. logo_dir = "{}/data/logo/".format(os.getcwd()).replace("\\", "/")
  626. check_path(logo_dir)
  627. logo_files = os.listdir(logo_dir)
  628. logo_list = []
  629. for logoItem in logo_files:
  630. logo_list.append(f"{logo_dir}{logoItem}")
  631. return {"code": 0, "msg": "操作成功", "data": logo_list}
  632. @app.post("/add_logo", description="添加logo")
  633. def add_logo(params: LogoParams):
  634. logo_path = params.logo_path.replace("\\", "/")
  635. session = SqlQuery()
  636. sysConfig = CRUD(SysConfigs)
  637. item = sysConfig.read(session, conditions={"key": "logo_configs"})
  638. if item == None:
  639. item = insertEmptyLogoList(session)
  640. if os.path.isfile(logo_path) == False:
  641. return {"code": 1, "msg": "logo文件不存在", "data": None}
  642. logo_dir = "{}/data/logo/".format(os.getcwd()).replace("\\", "/")
  643. check_path(logo_dir)
  644. fpath, fname = os.path.split(logo_path)
  645. logo_path_info = logo_dir + fname
  646. shutil.copy(logo_path, logo_path_info) # 复制文件
  647. logo_files = os.listdir(logo_dir)
  648. logo_list = []
  649. for logoItem in logo_files:
  650. logo_list.append(f"{logo_dir}{logoItem}")
  651. return {
  652. "code": 0,
  653. "msg": "",
  654. "data": {"logo": logo_path_info},
  655. }
  656. @app.post("/delete_logo", description="删除logo")
  657. def delete_logo(params: LogoParamsupdate):
  658. logo_path = params.path
  659. if os.path.isfile(logo_path) == False:
  660. return {"code": 1, "msg": "logo文件不存在", "data": None}
  661. os.remove(logo_path)
  662. logo_dir = "{}/data/logo/".format(os.getcwd()).replace("\\", "/")
  663. check_path(logo_dir)
  664. logo_files = os.listdir(logo_dir)
  665. logo_list = []
  666. for logoItem in logo_files:
  667. logo_list.append(f"{logo_dir}{logoItem}")
  668. return {"code": 0, "msg": "操作成功", "data": logo_list}
  669. @app.post("/close_other_window", description="关闭窗口")
  670. def close_other_window():
  671. hwnd_list = []
  672. def callback(hwnd, _):
  673. title = GetWindowText(hwnd)
  674. if title == "digiCamControl by Duka Istvan":
  675. hwnd_list.append(hwnd)
  676. EnumWindows(callback, None)
  677. if hwnd_list:
  678. hwnd = hwnd_list[0]
  679. win32gui.PostMessage(hwnd, win32con.WM_CLOSE, 0, 0)
  680. return {"code": 0, "msg": "关闭成功", "data": {"status":True}}
  681. return {"code": 0, "msg": "关闭失败", "data": {"status": False}}