36 lines
1.4 KiB
Python
36 lines
1.4 KiB
Python
|
|
|||
|
|
import os
|
|||
|
|
import io
|
|||
|
|
import logging
|
|||
|
|
from lawrisk.services.licensing_repo import _parse_import_workbook
|
|||
|
|
from lawrisk.utils.env_loader import load_env
|
|||
|
|
|
|||
|
|
# Configure logging to see the import details
|
|||
|
|
logging.basicConfig(level=logging.INFO)
|
|||
|
|
|
|||
|
|
def diagnose_import():
|
|||
|
|
load_env()
|
|||
|
|
file_path = r"c:\Users\WIN10\Desktop\work\11th-week\法律风险提示-new\市监局-lawRisk-backend\市级初版-20251219\许可风险提示\101（生产科） 风险提示表(食品小作坊登记，市场监管部门) (1)_转自XLS.xlsx"
|
|||
|
|
|
|||
|
|
with open(file_path, "rb") as f:
|
|||
|
|
content = f.read()
|
|||
|
|
|
|||
|
|
# We want to catch the logger output
|
|||
|
|
logger = logging.getLogger('lawrisk.services.licensing_repo')
|
|||
|
|
|
|||
|
|
print("Starting diagnostic parse...")
|
|||
|
|
grouped = _parse_import_workbook(content, "101_test.xlsx")
|
|||
|
|
|
|||
|
|
# After parsing, we want to see the results for the relevant sheets
|
|||
|
|
for sheet_name, permits in grouped.items():
|
|||
|
|
if "高明区" in sheet_name or "三水区" in sheet_name:
|
|||
|
|
print(f"\nResults for Sheet: {sheet_name}")
|
|||
|
|
for permit_name, rows in permits.items():
|
|||
|
|
if "食品小作坊" in permit_name:
|
|||
|
|
print(f" Permit: {permit_name} ({len(rows)} risks)")
|
|||
|
|
for i, r in enumerate(rows):
|
|||
|
|
print(f" Risk {i+1}: Serial=[{r.get('serial_number')}] | Content=[{r.get('risk_content')[:50]}...]")
|
|||
|
|
|
|||
|
|
if __name__ == "__main__":
|
|||
|
|
diagnose_import()
|