Health Care Optical
保健視力 Health Care Optical
TVP Demo Control
79 条 OPT 需求汇报 · Web / App / ERP 分离演示

眼镜铺 TVP 系统汇报与演示入口

这页用于演示时统一说明 79 条需求覆盖、客户商城、移动 App、员工 ERP、 单据报表和反馈收集。三端入口分离展示,讲解时可直接从这里进入重点页面。

79
OPT 需求点
3
角色界面
1
订单付款单据闭环
Requirement Coverage

按 79 条 OPT 需求实现的模块

页面只做汇报摘要;正式 requirement mapping 仍以原始需求 PDF 和 OPT 文档为准,原文不在此页改写。

平台 / Web / App / Responsive
已实现

OPT-001 至 OPT-006:客户 Web、移动 App-like 路由、员工 ERP 分离展示;App Store 上架属于后续真实发布决策。

首页 / 商品展示 / 镜片处方
已实现

OPT-007、OPT-013 至 OPT-016:首页广告与分类入口、镜框/隐形眼镜商品、颜色/镜片/处方来源、购物车和付款资料。

会员中心 / App 账户
已实现

OPT-008 至 OPT-012:注册、个人资料、地址、订单历史、光学处方、优惠券、收藏和退款入口。

销售订单 / 付款 / 单据
已实现

OPT-017 至 OPT-023、OPT-047 至 OPT-063:订单、付款凭证、人工批准/拒绝、报价单、发票、收据、送货单和售后维修。

用户 / 商品 / 库存
已实现

OPT-028 至 OPT-046:ERP 导航、用户 CRUD、商品资料、照片、售价/成本、促销价/成本、实时库存、安全库存和盘点调整。

CRM / 优惠 / 评价 / WhatsApp
已实现

OPT-024 至 OPT-027、OPT-064 至 OPT-069:评价展示与审核、WhatsApp 查询、促销码、会员券、生日/到期提醒口径。

报表 / 数据勾稽
已实现

OPT-070 至 OPT-079:销售毛利、应收、客户/产品偏好、促销活动、库存和盈利分析,来源于订单/库存/优惠/收藏数据。

云端回归 / 证据
持续补证

当前页用于演示汇报;云端 A3 仍需覆盖 Web、App、ERP、API、SQLite、PDF 和图片性能证据。

Original Requirement Ledger

79 条原始需求逐条可见

以下使用 Health Care Optical 原始需求 PDF 的 OPT 编号与英文原文。TVP PM 门禁要求:大模块不能替代子项,每条都要能看到界面、控件、数据和演示入口。

打开 BI 报表
No.SourceOriginal RequirementScreen / AreaControlsDataDemo LinkStatus
OPT-001HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.1Web+ Mobile APP+ Responsive:Platform shell / App readinessView switch, language switch, responsive previewtvp_tenants, UI config/app/homePASS
OPT-002HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.1i) ERP System for Sales, Inventory, Workflow managementWeb Backend / ERP DashboardModule navigation, order pipeline, inventory cards, payment review, reportstvp_orders_wide, tvp_products, tvp_users, SQL views/optical/staffPASS
OPT-003HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.1ii) Mobile App for iOS, and;Platform shell / App readinessView switch, language switch, responsive previewtvp_tenants, UI config/app/homePASS
OPT-004HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.1iii) to be listed on Apple App Store.Platform shell / App readinessView switch, language switch, responsive previewtvp_tenants, UI config/app/homePASS_WITH_RISK
OPT-005HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.1Suggested features:Platform shell / App readinessView switch, language switch, responsive previewtvp_tenants, UI config/app/homePASS
OPT-006HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.1Frontend (Web+ Mobile APP):Platform shell / App readinessView switch, language switch, responsive previewtvp_tenants, UI config/app/homePASS
OPT-007HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.11 HomepageWeb Frontend / HomepageShop Frames, Book Consultation, WhatsApp Inquirytvp_tenants, tvp_products/optical/shopPASS
OPT-008HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.12 Member CentreWeb Frontend / Member CentreCreate member, Save profile, Set default, View ordertvp_members, tvp_orders_wide/optical/shop/member/profilePASS
OPT-009HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.12.1 RegistrationWeb Frontend / Member CentreCreate member, Save profile, Set default, View ordertvp_members, tvp_orders_wide/optical/shop/member/profilePASS
OPT-010HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.12.2 Member profile managementWeb Frontend / Member CentreCreate member, Save profile, Set default, View ordertvp_members, tvp_orders_wide/optical/shop/member/profilePASS
OPT-011HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.12.3 Default delivery address settingWeb Frontend / Member CentreCreate member, Save profile, Set default, View ordertvp_members, tvp_orders_wide/optical/shop/member/profilePASS
OPT-012HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.12.4 Membership historyWeb Frontend / Member CentreCreate member, Save profile, Set default, View ordertvp_members, tvp_orders_wide/optical/shop/member/historyPASS
OPT-013HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13 Sales SystemWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/shop/framesPASS
OPT-014HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.1 Product displayWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/shop/framesPASS
OPT-015HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.2 Shopping cartWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/shop/cartPASS
OPT-016HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.3 Payment integration with “FPS”, “PayMe” & “Alipay”Web Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/shop/paymentPASS
OPT-017HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.4 Sales historyWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/shop/member/historyPASS
OPT-018HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.5 Sales quotationWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/staff/documentsPASS
OPT-019HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.6 Sales invoiceWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/staff/documentsPASS
OPT-020HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.7 Sales receiptWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/staff/documentsPASS
OPT-021HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.8 Delivery noteWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/staff/documentsPASS
OPT-022HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.9 Order managementWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/shop/framesPASS
OPT-023HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.13.10 Maintenance recordWeb Frontend / Sales SystemAdd to Cart, Proceed, Upload Proof, Generate Docs, Request Maintenancetvp_products, tvp_orders_wide, tvp_attachments/optical/staff/maintenancePASS
OPT-024HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.14 Product ReviewsWeb Frontend / Product ReviewsView review, WhatsApp consulttvp_orders_wide review summary later/optical/shop/reviewsPASS
OPT-025HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.15 Contact UsWeb Frontend / Contact UsWhatsApp, map/contact CTAtvp_tenants/optical/shop/store-contactPASS
OPT-026HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.16 About UsWeb Frontend / About UsSocial links, shop infotvp_tenants/optical/shop/store-contactPASS
OPT-027HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.17 WhatsApp Chat integration for customer inquiryWeb Frontend / WhatsApp InquiryWhatsApp, Create order, Member profiletvp_tenants, tvp_orders_wide/optical/shop/whatsappPASS
OPT-028HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.2Backend (ERP system):Web Backend / ERP ShellModule navigation, Create, Export, Printall backend tables/views/optical/staffPASS
OPT-029HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.28 User managementWeb Backend / User ManagementView, Create, Edit, Delete, Set Roletvp_users, tvp_audit_logs/optical/staff/usersPASS
OPT-030HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.28.1 View UsersWeb Backend / User ManagementView, Create, Edit, Delete, Set Roletvp_users, tvp_audit_logs/optical/staff/usersPASS
OPT-031HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.28.2 Create UsersWeb Backend / User ManagementView, Create, Edit, Delete, Set Roletvp_users, tvp_audit_logs/optical/staff/usersPASS
OPT-032HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.28.3 Edit UsersWeb Backend / User ManagementView, Create, Edit, Delete, Set Roletvp_users, tvp_audit_logs/optical/staff/usersPASS
OPT-033HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.28.4 Delete UsersWeb Backend / User ManagementView, Create, Edit, Delete, Set Roletvp_users, tvp_audit_logs/optical/staff/usersPASS
OPT-034HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29 Product & Inventory ManagementWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/inventoryPASS
OPT-035HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1 Product ManagementWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-036HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1.1 Item No., HS Code, UPC CodeWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-037HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1.2 Product photosWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-038HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1.3 Product descriptionWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-039HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1.4 Sales priceWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-040HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1.5 Product costWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-041HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1.6 Promotion priceWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-042HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.1.7 Promotion costWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/productsPASS
OPT-043HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.2 Inventory ManagementWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/inventoryPASS
OPT-044HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.2.1 Real-Time stock balance enquiryWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/inventoryPASS
OPT-045HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.2.2 Stock adjustmentWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/inventoryPASS
OPT-046HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.29.2.3 Safety stock level alarmWeb Backend / Product & InventoryCreate/Edit product, Upload photo, Stock adjustment, Stock takingtvp_products, tvp_orders_wide/optical/staff/inventoryPASS
OPT-047HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210 Sales & Order ManagementWeb Backend / Sales & Order ManagementView, Create, Edit, Delete, Accept order, Mark readytvp_orders_wide, tvp_members, tvp_products/optical/staff/ordersPASS
OPT-048HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.1 Order ManagementWeb Backend / Sales & Order ManagementView, Create, Edit, Delete, Accept order, Mark readytvp_orders_wide, tvp_members, tvp_products/optical/staff/ordersPASS
OPT-049HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.1.1 View orderWeb Backend / Sales & Order ManagementView, Create, Edit, Delete, Accept order, Mark readytvp_orders_wide, tvp_members, tvp_products/optical/staff/ordersPASS
OPT-050HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.1.2 Create orderWeb Backend / Sales & Order ManagementView, Create, Edit, Delete, Accept order, Mark readytvp_orders_wide, tvp_members, tvp_products/optical/staff/ordersPASS
OPT-051HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.1.3 Edit orderWeb Backend / Sales & Order ManagementView, Create, Edit, Delete, Accept order, Mark readytvp_orders_wide, tvp_members, tvp_products/optical/staff/ordersPASS
OPT-052HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.1.4 Delete orderWeb Backend / Sales & Order ManagementView, Create, Edit, Delete, Accept order, Mark readytvp_orders_wide, tvp_members, tvp_products/optical/staff/ordersPASS
OPT-053HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.1.5 Order Taking functionWeb Backend / Sales & Order ManagementView, Create, Edit, Delete, Accept order, Mark readytvp_orders_wide, tvp_members, tvp_products/optical/staff/ordersPASS
OPT-054HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2 Payment ManagementWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-055HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.1 Payment ManagementWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-056HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.1.1 View paymentWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-057HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.1.2 Create paymentWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-058HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.1.3 Edit paymentWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-059HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.1.4 Delete paymentWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-060HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.2 Payment gateway settingWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-061HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.2.1 FPSWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-062HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.2.2 PayMeWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-063HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.210.2.2.3 AlipayWeb Backend / Payment ManagementView, Create, Edit, Delete, Approve, Reject, Edit settingstvp_orders_wide, tvp_attachments, tvp_tenants/optical/staff/paymentsPASS
OPT-064HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.211 CRM SystemWeb Backend / CRM SystemView, Create, Edit, Delete promotiontvp_promotions, tvp_orders_wide/optical/staff/promotionsPASS
OPT-065HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.211.1 PromotionWeb Backend / CRM SystemView, Create, Edit, Delete promotiontvp_promotions, tvp_orders_wide/optical/staff/promotionsPASS
OPT-066HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.211.1.1 View promotionWeb Backend / CRM SystemView, Create, Edit, Delete promotiontvp_promotions, tvp_orders_wide/optical/staff/promotionsPASS
OPT-067HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.211.1.2 Create promotionWeb Backend / CRM SystemView, Create, Edit, Delete promotiontvp_promotions, tvp_orders_wide/optical/staff/promotionsPASS
OPT-068HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.211.1.3 Edit promotionWeb Backend / CRM SystemView, Create, Edit, Delete promotiontvp_promotions, tvp_orders_wide/optical/staff/promotionsPASS
OPT-069HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.211.1.4 Delete promotionWeb Backend / CRM SystemView, Create, Edit, Delete promotiontvp_promotions, tvp_orders_wide/optical/staff/promotionsPASS
OPT-070HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212 Reports & analysesWeb Backend / Reports & AnalysesFilter, Export, Print, Drill downSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
OPT-071HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.1 ReportsWeb Backend / Reports & AnalysesFilter, Export, Print, Drill downSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
OPT-072HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.1.1 Sales & Gross Profit reportWeb Backend / Reports & AnalysesFilter, Export, Print, Drill downSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
OPT-073HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.1.2 Accounts Receivable reportWeb Backend / Reports & AnalysesFilter, Export, Print, Drill downSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
OPT-074HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.1.3 Preference reportWeb Backend / Reports & AnalysesFilter, Export, Print, Drill downSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
OPT-075HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.1.4 Promotion campaign reportWeb Backend / Reports & AnalysesFilter, Export, Print, Drill down, Open promotionSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
OPT-076HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.2 Inventory AnalysisWeb Backend / Reports & AnalysesFilter, Export, Print, Drill downSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
OPT-077HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.2.1 Real-Time Stock Balance EnquiryWeb Backend / Reports & AnalysesFilter, Export, Print, Drill down, Open stock itemSQL views over tvp_products and tvp_orders_wide/optical/staff/reportsPASS
OPT-078HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.2.2 Stock takingWeb Backend / Reports & AnalysesFilter, Export, Print, Drill down, Open stock takingSQL views over tvp_products and tvp_orders_wide/optical/staff/reportsPASS
OPT-079HEALTH CARE OPTICAL - IT spec requirement (Finalised).pdf p.212.2.3 Inventory and Profitability AnalysisWeb Backend / Reports & AnalysesFilter, Export, Print, Drill downSQL views over tvp_orders_wide/products/members/promotions/optical/staff/reportsPASS
Demo Story

核心闭环讲解顺序

01

客户从商城或 App 浏览镜框、镜片和隐形眼镜

02

选择镜框颜色、镜片类型和处方来源

03

加入购物车并填写取货/配送资料

04

上传 FPS / PayMe / Alipay / Bank 付款凭证

05

ERP 人工审核付款并同步订单状态

06

生成报价单、发票、收据和送货单

07

售后维修、退款和评价继续回写客户记录

08

库存、应收、毛利、偏好和促销报表同步呈现

Feedback

演示意见反馈

反馈会写入 Demo 后端 `tvp_demo_feedback`,用于后续 Bella PMO / A2 / A3 整理问题和回归。

支持短中文、电话和粘贴文本;提交失败会显示错误。