{
  "version": "4.27.0",
  "title": "Excel Import Services & Products — Deep Audit Build",
  "audit": {
    "php_files": 142,
    "lint_errors": [],
    "tables": 60,
    "foreign_keys": 109,
    "fk_errors": [],
    "table_order_issues": [],
    "insert_checked": 157,
    "insert_errors": [],
    "update_checked": 88,
    "update_errors": [],
    "alter_checked": 95,
    "alter_errors": [],
    "post_forms": 151,
    "csrf_errors": [],
    "missing_links": [],
    "missing_includes": [],
    "xlsx_integrity": {
      "templates/template_import_service.xlsx": null,
      "templates/template_import_product.xlsx": null,
      "templates/template_import_user.xlsx": null,
      "templates/template_import_member.xlsx": null,
      "templates/template_import_pra_member.xlsx": null
    },
    "xlsx_parser_test": {
      "returncode": 0,
      "stdout": "template_import_service.xlsx:14:11\ntemplate_import_product.xlsx:4:12\ntemplate_import_user.xlsx:4:18\ntemplate_import_pra_member.xlsx:3:13",
      "stderr": ""
    }
  },
  "features": {
    "service_import": [
      "official XLSX template",
      "skip/update mode",
      "code/name matching",
      "barcode/code validation",
      "discount validation",
      "batch/row history"
    ],
    "product_import": [
      "official XLSX template",
      "skip/update by SKU",
      "usage_type validation",
      "barcode validation",
      "opening/adjustment stock movements",
      "operational recipe safety",
      "batch/row history"
    ],
    "access": {
      "catalog_import": "superadmin, manager",
      "user_import": "superadmin only"
    },
    "xlsx_reader": "ZipArchive when available; pure PHP+zlib fallback without SimpleXML"
  },
  "preserved": [
    "member_customization.php",
    "member_card.php",
    "card_designer.php",
    "payment_verification.php",
    "receipt_settings.php",
    "operational_inventory.php",
    "finance_ledger.php",
    "accounting.php",
    "payroll.php",
    "attendance.php",
    "zkteco_step_diagnostic.php",
    "zkteco_push.php",
    "renovation.php",
    "backup.php",
    "restore.php",
    "settings.php",
    "user_import.php",
    "catalog_import.php"
  ],
  "checks": {
    "php_lint": true,
    "tables": true,
    "foreign_keys": true,
    "table_order": true,
    "insert_columns": true,
    "update_columns": true,
    "alter_vs_fresh": true,
    "links": true,
    "includes": true,
    "csrf": true,
    "xlsx_integrity": true,
    "xlsx_parser_fallback": true,
    "catalog_tables": true,
    "service_template": true,
    "product_template": true,
    "service_import_link": true,
    "product_import_link": true,
    "service_import_update": true,
    "product_import_update": true,
    "stock_audit": true,
    "barcode_unique": true,
    "service_product_rule_safety": true,
    "catalog_access": true,
    "user_import_superadmin": true,
    "upload_policies": true,
    "template_protection": true,
    "previous_features": true,
    "no_create_database": true,
    "no_use_database": true,
    "schema_release": true
  },
  "notes": [
    "No CREATE DATABASE or USE database.",
    "Fresh database and upgrade schema synchronized.",
    "Template files are protected from direct URL and served via permission-checked endpoint."
  ]
}