api.py 29 KB

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