basic framwork：Laravel 11 + PHP 8.3 + MySQL 8.0 + （android /iOS）+ AI + UI/UX Pro Max

The document includes: project overview, global system specifications, detailed page details for all modules (page name, functions, design purpose, business logic), database design, DeepSeek AI integration solution, UI/UX professional design standards, phased development and implementation plan, reserved feature expansion plan, testing plan, deployment and operation & maintenance, delivery list, and detailed development quotation

Preface to the document

This document is fully grounded on all business requirements provided by the client, implementing each item without any code, covering the entire page logic of the PC management backend and the learner’s mobile end; Reserved long-term functional expansion interfaces and data table fields to support new services in later iterations; Built-in complete DeepSeek AI intelligent empowerment module, paired with a professional-grade UI/UX Pro Max interactive visual system, and supported by a standardized phased implementation development plan.

1. Overall Project Overview and Global System Specifications

1.1 Project Overview

This system is a hospital-specific integrated training and assessment SaaS platform, targeting management personnel from multiple departments including science and education, medical affairs, nursing, and pharmacy. It covers online courseware training, offline training appointment check-in, millions of medical question banks, tiered online exams, intelligent grading, big data analysis of mistakes, questionnaire surveys, announcements and notifications, and hierarchical permission management for personnel organization. It integrates the DeepSeek large model to achieve full-process AI-assisted teaching.

Cloud-based elastic architecture: hospitals do not need to purchase server hardware, site-wide HTTPS encryption, CDN full acceleration, and multi-terminal adaptation for computers, phones, and tablets; No account limit, no courseware storage capacity, the system automatically upgrades and iterates remotely every quarter, accompanied by upgrade documentation.

1.2 Global Hard Technical Specifications

1. Hardware deployment: cloud-based elastic computing power, automatic storage scaling, automatic expansion in high-concurrency scenarios, hospitals require zero hardware investment;
2. Transmission security: mandatory HTTPS SSL encryption across the entire site, signature verification for interface requests, and encrypted storage of sensitive data;
3. Network optimization: CDN acceleration for site-wide static resources, courseware, and image access, solving access lag and concurrent congestion;
4. Storage rules: No storage limit for documents, images, and audio; Teaching videos are only recorded via Tencent Video external links and played via plugins, without occupying platform storage space;
5. Account capacity: There is no limit on the number of system personnel accounts, adapting to the annual addition and departure of hospital staff;
6. Iteration mechanism: Quarterly automatic remote upgrades, full database backup before upgrades, automatic rollback after failed upgrades, and synchronized generation of visual upgrade documentation.

1.3 Terminal Division

1. PC management backend (Laravel web version, administrator operation)
2. Mobile app (Android + iOS, core user base for medical students)
3. WeChat Mini Program Supporting Interface (reuses backend business logic, frontend pages offer optional extensions)

1.4 Long-term Functional Extension Design Description

All system data tables, backend interfaces, and front-end pages are reserved for extended fields, extended routing, and expansion pop-up modules, supporting non-intrusive new features later without restructuring the underlying architecture:

1. Reserved expansion fields for multi-hospital isolation, with the possibility of adding multi-hospital group versions later;
2. Reserve extended credit management fields for quick addition of automatic training credit statistics and credit ledgers;
3. Reserved expansion interface for online live training, allowing integration of live streaming plugins;
4. Reserved certificate automatic generation module, automatic export of electronic training certificates after passing exams;
5. Reserved third-party HIS system interface to support personnel information synchronization;
6. Reserve AI training plan automatic push and intelligent job assessment recommendation expansion logic;
7. Reserved independent expansion modules for data large screens to meet hospital smart teaching display needs.

2. System Full Business Modules + Detailed Page Description (Functions, Objectives, Business Logic)

Part One: PC Manages All Backend Pages

Module 0: System Global Foundation Module

Page 0-1 Administrator login page

1. Functions: Account and password login, graphic verification codes, password recovery, role permission differentiation, login log recording
2. Design purpose: Identity authentication, intercepting illegal access, and distinguishing data permissions between super administrators and department administrators
3. Business logic: Account and password backend are salted and verified with hash verification; if you enter the wrong type five times consecutively, the account will be locked for 30 minutes; Log in to receive time-limited tokens, and jump to the corresponding homepage by role; Password recovery, binding phone verification code; All login operations are written to the system log, and HTTPS is fully encrypted for transmission.
4. Expansion reservation: Later expansion can be extended to WeCom/DingTalk single sign-on interfaces.

Page 0-2 System General Data Dashboard Homepage

1. Features: Completion rate of all training sessions, exam pass rate, offline sessions pending sign-in, statistics of those not assessed, AI data calls, quick entry for quarterly upgrade reminders, multi-dimensional visual charts
2. Design Purpose: Administrators can access the overall operational data of training and assessment for the entire institute in one place, without the need for multiple page redirects
3. Business Logic: Automatically aggregates nearly 30 days of business data, with visualization of lines, bars, and pie charts; Data is isolated by the department to which the administrator belongs; department administrators only view data within their own department; Red alert for those who have not completed training or failed; Click the chart block to directly go to the corresponding management page.
4. Extended Reservation: Reserve multi-campus data switching filtering controls, which can be directly activated for group deployments later.

Pages 0-3 System Global Configuration Page

1. Features: HTTPS switch, CDN acceleration configuration, file upload size limits, video playback parameters, global pass scores, basic anti-cheat parameters, DeepSeek AI daily call limits, automatic database backup cycle configuration
2. Design Purpose: To unify the underlying operating parameters of the management system to meet different hospital management requirements
3. Business Logic Parameter modifications take effect in real time, recording the operator and modification time; When AI call quota is exhausted, all AI generation functions are automatically disabled; Backup intervals support daily or weekly custom switching.
4. Extended reservation: Added third-party docking key configuration area and credit rule configuration area.

Page 0-4 version upgrade management page

1. Functions: Quarterly new version detection, upgrade log list, preview of upgrade documentation, manual trigger of upgrade, upgrade rollback record query
2. Design Purpose: To enable automatic remote upgrades on the platform quarterly, visualize iteration content, and one-click rollback of faults to ensure data security
3. Business Logic: System-based scheduled tasks automatically pull official upgrade packages every quarter; Automatically performs a full database backup before the upgrade, automatically generating illustrated and updated update instructions; If the upgrade fails, the rollback script will be automatically executed and the data before the upgrade will be restored; All upgrade operations are permanently retained and supported for export and archiving.
4. Extended reserves: Grayscale upgrade grouped configuration module, enabling batch hospital grayscale updates in the future.

Pages 0-5 Administrator operation log page

1. Features: Platform-wide operation record search, filtering by operator / time / operation type, batch log export
2. Design Purpose: Full-process operational behavior traceability, meeting hospital information security audit and in-hospital inspection requirements
3. Business Logic: Automatic recording of all additions, deletions, modifications, querys, AI batch generation of test questions, batch import and export, system upgrades, and permission change operations; Logs are permanently stored, impossible to delete or tamper.
4. Extended reservation: Hierarchical anonymized log export configuration, interfaces for internal security audit system interfaces.

Module 1: Personnel, Organization, and Role Permission Management Module

Page 1-1 Personnel Management List Page

1. Features: Add medical staff per entry, batch import personnel files into Excel, edit / enable / disable / cancel resignations, display staff in tree formats, multi-condition filtering (department/title/nurse level/work experience), and batch export personnel ledgers
2. Design purpose: Unified maintenance of all medical and nursing accounts in the hospital, with no account limit, adapting to personnel mobility and new personnel addition scenarios
3. Business Logic: Personnel files are bound to department, professional title, nurse level, position, and years of service; Departing employees only disable their account; historical training and exam data are permanently retained; Batch import automatically verifies duplicate conflicts between employee and mobile numbers, and pop-up warnings for abnormal data; Section administrators can only operate staff within their own department and do not have the authority to edit staff from other departments.
4. Extended reservations: HIS personnel data synchronization button, personnel electronic file attachment upload area, employee credit ledger display column.

Page 1-2 Department / Professional Title / Nurse Level / Position Configuration Page

1. Features: Add / edit / delete multi-level departments, professional titles, nurse levels, and job categories; Drag and drop the architecture tree to sort and adjust the hierarchy
2. Design purpose: To adapt to the differentiated organizational structure of each hospital to achieve personnel hierarchical and categorized management
3. Business Logic: Departments/titles that have already bound personnel, training, or exam data cannot be deleted directly; the associated data must be unbound first; The architecture tree synchronizes with training and exam filter criteria.
4. Extension Reservation: Binds to multi-hospital group tags and department heads to expand fields.

Page 1-3: Role permission management page

1. Features: Customizable administrator roles (Science and Education Administrator, Nursing Administrator, Medical Administrator, Read-Only Observer); Refined permission selection (question bank, paper compilation, grading, training, exams, questionnaires, announcements, personnel management); Roles are assigned to administrator accounts
2. Design purpose: Hierarchical data isolation and control, with administrators in different positions only having corresponding operation permissions available
3. Business logic: Permission granularity with independent switch, automatically hiding pages without permissions; Permission changes take effect instantly, no need to restart the service; Super administrators have all permissions that cannot be deleted or revoked.
4. Extended reservations: Added exclusive permission switches for credit management, live streaming management, electronic certificates, and data dashboards.

Module 2: Training Program Management Module

Page 2-1 Training Program List Page

1. Functions: Create new teaching plans, edit, archive, delete; Filter by department, cycle, or plan status; View the overall progress of plan execution; Batch export of training plan lists
2. Design purpose: Each department independently formulates annual, quarterly, and monthly training plans, manages them uniformly for archiving, and meets the needs of internal teaching inspections
3. Business Logic: The Science and Education Department, Nursing Department, and Medical Affairs Department can only create and view their department’s training plans; Plan status is divided into Draft, Pending, In Progress, Completed, and Archived; Plans to prohibit editing after archiving; Each plan can be bound to supporting attachments, online courses, offline training sessions, and assessment exam papers.
4. Extended reservation: AI generates annual training plan shortcut buttons and training credit configuration fields with one click.

Page 2-2 Add / Edit Form Page for Training Plans

1. Functions: Fill in the plan name, training type, execution cycle, responsible person, training objectives, and target audience; Uploading supporting teaching attachments; Bind and link online courses, offline training, and assessment exam papers
2. Design Purpose: Standardize the entry of training planning information and bind the full set of supporting teaching resources with one click
3. Business Logic: Target Groups Support batch screening by department, professional title, and nurse level; Attachments support doc, pdf, and image formats, and are automatically stored in cloud object storage; After saving, it is a draft by default; after manual publishing, it becomes visible to the learner.
4. Extended reservations: training credit setting, live course binding, automatic issuance of electronic graduation certificates.

Page 2-3: Details page for plan execution supervision

1. Features: Visualizes all online courses, offline training sessions, and supporting exams under the program; Display course completion rates, offline sign-in rates, and exam passers; One-click jump to relevant training/exam details; Filter out those who did not participate and send notifications in bulk
2. Design Purpose: Managers can monitor training implementation in real time and quickly locate those who have not completed assessments
3. Business Logic: The system automatically and real-time statistics on each course’s completion rate, offline attendance rate, and exam pass rate; Highlighting those not involved supports one-click batch push of system announcement reminders.
4. Extended reservation: One-click generation of training execution briefs (AI automatic generation), export training credit summary tables.

Module 3: Online Training Courseware Management Module

Page 3-1 Online Course List Page

1. Functions: Create new courses, edit, remove and delet, delete; Course cover preview; Filtered by department / open status; Batch export course logs
2. Design purpose: To centrally manage online teaching courses within the institute and precisely control the scope of course access and viewing
3. Business Logic Course supports setting visibility for all staff / designated departments; After being removed, the learner end cannot view the learning session; A single course can be linked to multiple courseware and after-class self-assessment exercises.
4. Extended reservations: live course association, course credit allocation, course evaluation module entry.

Page 3-2 Course Add/Edit Page

1. Functions: Upload course cover images, fill in course name and description, set access permissions; Drag and drop to sort courseware sequence; Linked to post-class self-assessment exercises
2. Design Purpose: To build a standardized online curriculum system, supplemented with after-class exercises to reinforce knowledge points
3. Business Logic: The courseware supports dragging and dropping to customize playback order, allowing learners to learn in order of order; Exercises after class can be freely selected from public question banks or private hospital question banks, and students can automatically push exercises upon completion of the course.
4. Extended reservations: AI automatically generates course summaries and quick operation of supporting after-class exercises.

Page 3-3 Courseware Material Upload Management Page

1. Functions: Upload documents, images, audio materials; Import Tencent Video backlinks; Online preview and deletion of materials; Automatically verifies file formats and video parameters
2. Design purpose: Unified storage of training multimedia materials, video backlinks hosting Tencent Video, without occupying platform storage space
3. Business logic Document validation formats: doc, docx, xls, xlsx, ppt, pptx, pdf, jpg; Only Tencent Video links are recorded for video, with front-end plugins loading and playback. Video rules are forcibly verified: single video ≤16GB, duration 3 minutes~1 hour, resolution ≥1080P; Courseware materials have no storage capacity limit and are permanently stored in the cloud.
4. Extended reserves: batch import of short videos and AI parsing of audio-to-text conversion.

Pages 3-4 Student Learning Progress Statistics Page

1. Functions: Filter all students’ viewing progress, cumulative viewing time, and completion status by course; Screening those who have not completed their studies; Export a complete learning progress report
2. Design Purpose: To compile statistics on trainees’ completion of online learning and serve as the basis for archiving training assessments
3. Business Logic: The system automatically records each playback node and resume position, with progress data synchronized in real time to PC management and Flutter mobile devices.
4. Extended reservations: automatic credit conversion of study hours, AI-generated special review papers for those who have not completed the work.

Module 4: Offline Training Management Module

Page 4-1 Offline Training Session List Page

1. Functions: Create new offline training sessions, edit sessions, close sessions; Filter by time and department; Real-time display of total reservations and sign-ins for the event; Batch export session ledgers
2. Design Purpose: To centrally manage all offline on-site training activities and control basic information for sessions
3. Business logic: After the session closes, trainees cannot make reservations or check in; Each offline training session automatically generates an independent, exclusive check-in QR code; Each session is bound to a corresponding training plan.
4. Extended reservations: live streaming of offline training and automatic calculation of offline training credits.

Page 4-2 Added an editing page for offline sessions

1. Functions: Fill in the course leader, instructor, training location, start and end times, and planned capacity; Splitting multiple batch reservations; Bind to your assigned training plan
2. Design Purpose: Improve the basic information for offline training, support staggered appointments in batches, and alleviate on-site crowding
3. Business logic: The same session can be split into multiple scheduled batches; Once the number of batch reservations reaches the planned limit, the reservation entry will automatically close.
4. Extended reservations: Offline training consumables registration, training sign-in electronic certificate issuance configuration.

Page 4-3 Check-in Real-Time Monitoring Page

1. Function: List of all reserved participants for this session; Distinguish between unreserved / reserved / checked in / absent individuals; Real-time check-in times are refreshed; Manual supplementary sign-in operation; Screening absentees
2. Design purpose: Real-time monitoring of attendees at the training site, rapid counting of absentees for subsequent assessments
3. Business logic: Students check in via QR code via Flutter APP or WeChat, with check-in data pushed to the backend in real time; Administrators support manual check-ins, and all check-in operations are logged in as a result.
4. Extended reservation: Batch push notifications for make-up exams or make-up study to absent participants.

Page 4-4 Check-in Data Statistics Export Page

1. Function: Aggregate and query of check-in data for multiple sessions; Filter by department and time period; Standardized export of Excel (appointment time, sign-in time, name, department, sign-in status)
2. Design Objective: To generate a standardized offline check-in ledger for hospital inspection archiving
3. Business logic: Export files adapted for A4 printing, fields must be complete and not omitted; Historical check-in data is permanently archived, and years of data can be retrieved and exported.
4. Extended Reservation: One-click synchronization of check-in data to the personnel credit ledger.

Module 5: Question Bank and Test Paper Management Module

Page 5-1 Public Medical Question Bank Browsing Page (2 Million Shared Exam Questions)

1. Function: Filter questions by major, knowledge point, and question type; Preview test questions, explanations, multimedia materials; View only, not edit; Single questions / batch addition to the hospital’s private question bank
2. Design Purpose: To standardize the massive medical exam questions on the multiplexing platform, reducing the workload of hospitals independently creating questions
3. Business logic: The public question bank platform automatically updates quarterly; Hospitals only have viewing and referencing permissions, not modification or deletion permissions; Supports drawing questions across public and private question banks during compilation.
4. Extended reservation: Public question bank AI batch screening of weak knowledge point test questions.

Page 5-2 Hospital Private Question Bank List Page

1. Features: Manually add questions, batch import questions into Excel, batch delete questions, edit questions; Filter by question type, difficulty, and knowledge points; DeepSeek AI Batch Generation Quick Entry
2. Design purpose: To store hospital-owned customized test questions and flexibly maintain dedicated question bank resources within the hospital
3. Business Logic: Supports single choice, multiple choice, true/false, fill-in-the-blank, and Q&A; Each question is bound by difficulty, images, audio, and video analysis; Call DeepSeek AI to batch generate test questions and store them with one click; Batch import automatically checks table formats, with separate error rows displayed.
4. Expansion Reservation: Multi-level expansion by question bank category, test question sharing to other branches for expansion.

Page 5-3 Test Questions Add / Edit Form Pages

1. Functions: Enter question stems, options, and standard answers; Set difficulty and knowledge point categories; Upload image/audio/video analysis materials; AI automatically generates professional analysis buttons with one click
2. Design purpose: Standardized single-question entry, multimedia assisted explanation, AI automatically fills in missing analysis content
3. Business logic: Click AI to generate parsing, Laravel backend calls the DeepSeek interface to return the medical professional analysis for automatic filling; All multimedia materials are linked to the test ID stored in a unified manner.
4. Extended reservation: AI automatically identifies key points in exam questions and automatically corrects textual errors in the question stem.

Page 5-4 Test Paper Management List Page

1. Functions: Create new test papers, edit, copy test papers, delete them; View exam question types and difficulty distribution; Batch export of printable test paper files
2. Design purpose: Unified management of all assessment papers, supporting paper reuse and secondary reorganization and compilation
3. Business Logic The page has six built-in unified entry points for document grouping modes; Supports two-stage paper generation (generating new exam papers based on existing ones); Exam papers can be linked to corresponding training plans for assessment.
4. Expansion Reservation: Exam papers are encrypted in tiers, with scheduled release of test papers and extended configurations.

Page 5-5 Intelligent Unified Paper Formation Configuration Page (Six Paper Formation Modes)

1. Function: Select public question bank / private question bank; Check key points and set the difficulty ratio; Fill in the total number of questions; Enable anti-duplicate extraction of test questions; Preview the test paper and save to generate the test paper
2. Design purpose: Flexibly adapt to different assessment scenarios, automate question selection, and reduce manual question creation costs
3. Business Logic: Six modes of freely switching: manual paper-building, quantitative paper-building, random paper-building, knowledge point paper-building, proportional paper-based paper-building, and secondary paper-based paper-building; Supports multi-question bank randomization, with the system automatically filtering out duplicate questions; After generating the exam paper, manual fine-tuning of adding or deleting questions is supported.
4. Extended reservation: AI intelligent matching of weak knowledge points across the entire institute with automatic paper compilation function.

Module 6: Online Exam Management Module

Page 6-1 Exam Release List Page

1. Functions: Publish new exams, edit exams, close exams; Check the number of candidates and overall pass rate for this session; Screening for historical archival exams; Batch export of transcripts
2. Design Purpose: To centrally control all online assessments and visually view overall exam completion
3. Business Logic: After the exam is closed, students cannot enter to answer questions; Historical exams are permanently archived and preserved; The page displays the candidates who failed the current session, allowing batch re-exam initiation with one click.
4. Extended reservations: automatic electronic certificate generation for exams, HIS system interface for exam data synchronization.

Page 6-2 Exam Publishing Configuration Page

1. Function: Select the corresponding test paper; Fill in the exam name and set a valid login time slot; Tiered screening of candidates (department/professional title/nurse level/department); Equipped with a full set of anti-cheating rules; Set make-up test switches and maximum number of make-up exams; Control whether scores and answers are shown to students; Exclusive quiz terminals (PC/APP/Mini Program)
2. Design Purpose: Finely control all exam rules, achieve tiered and targeted assessment, and ensure fairness and justice in the exam
3. Business logic: Only people within the filtered scope receive exam notifications; external personnel cannot view the exam; Anti-cheating configuration options: test questions are out of order, options are in random order, page departure count monitoring, exam password lock, and prohibition of copying test text; Custom make-up exam on/off, make-up exam limit, and make-up exam passing score line.
4. Extended reservations: Exam answer time tiered configuration, automatic exam credit conversion configuration options.

Page 6-3 Overview of Single Exam Results

1. Function: Complete score list for all candidates; Displays exam duration, submission time, score, make-up exam status, and pass mark; Multi-condition screening; Export the complete Excel transcript
2. Design purpose: Quickly review the assessment results of all personnel at this site and generate standardized archiving records
3. Business Logic: Objective questions are automatically scored; subjective questions are marked with orange reminders by graders; Supports screening personnel by score range, department, and professional title.
4. Extended reservation: batch generation of training certificates and AI analysis presentations of score data for batch generation.

Page 6-4 Subjective Questions Multi-person Collaborative Grading Page

1. Function: Assigns grading tasks; Batch scoring and filling out grading comments; DeepSeek AI assisted scoring reference; Review and modify scores; Marking grading completed
2. Design Purpose: Multiple people collaborate to grade Q&A, AI-assisted reduction of manual grading workload
3. Business logic Laravel’s backend calls DeepSeek to identify candidate keywords and outputs score ranges for reference, serving only as assistance, with final scores manually confirmed; All grading records are permanently retained and support for secondary review.
4. Expansion Reservations: Automatic grading task distribution, grading performance statistics expansion module.

Page 6-5: Multidimensional data analysis page for the exam

1. Functions: Overall test paper analysis, individual candidate analysis, score range distribution bar chart; Statistics on single question error rates; Detailed accuracy and accuracy for each question; Export a full set of analytical reports
2. Design purpose: To identify weak knowledge points unified throughout the institute and provide data support for subsequent targeted training
3. Business Logic: The system automatically counts the number of errors on each question and the proportion of options selected; AI automatically recommends specialized review papers based on mistakes and summaries.
4. Expanded reserves: annual exam data summary dashboard, AI-generated teaching rectification reports.

Pages 6-6 Print and export the test paper

1. Function: Select the target test paper to generate a streamlined paper-saving printing format; Black and white / color switching; One-click download PDF print files
2. Design purpose: To provide paper exam paper archives to meet hospital testing needs
3. Business Logic: Automatically removes unnecessary navigation and blank redundant areas, optimizes layout, saves printing paper; Typesetting compatible with standard A4 printing paper.
4. Extended reservations: batch printing of exam papers, encrypted export of test papers.

Module 7: Survey Management Module

Page 7-1 Questionnaire List Page

1. Functions: Create new questionnaires, edit, delist shelves and deletions, archive; Check the number of questionnaire responses received; Batch export of survey summary data
2. Design Purpose: To centrally manage various in-hospital survey questionnaires and collect medical staff opinions and suggestions
3. Business logic: After the questionnaire is taken down, trainees cannot fill it out; After archiving, only historical data can be viewed; editing is prohibited; Supports setting questionnaires to be filled out only by designated department personnel.
4. Expansion Reservation: AI intelligent analysis of questionnaire data and scheduled survey push expansion features.

Page 7-2 Added an editing page for the questionnaire

1. Functions: fill in the questionnaire name, effective start and end dates, and survey purpose; Added single-choice/multiple-choice/Q&A questions; Drag and drop to sort questions and set required fields
2. Design purpose: To standardize the creation of survey questionnaires, flexibly configuring question types and filling rules
3. Business Logic Marking required fields; students who did not fill them out could not submit questionnaires; The questionnaire will not be automatically hidden within the effective time period.
4. Extended reservations: Questionnaire attachment upload, questionnaire answer credit reward configuration.

Page 7-3 Questionnaire Results Statistics Page

1. Features: Visualized pancake chart of each question with option proportions; Summary of all written opinions; Screening and filling out personnel; Export complete answer data to Excel
2. Design Purpose: To visually display research feedback results and summarize all written suggestions
3. Business Logic: All answer data is automatically and automatically calculated in real time, with no need for manual calculation; The exported file contains each person’s complete answer record.
4. Extended Reservation: AI automatically compiles survey comments and generates research summary reports.

Module 8: Notification and Announcement Management Module

Page 8-1 Announcement List Page

1. Functions: publish new announcements, edit, take down shelves; View the total number of page views for announcements; Screening those who have not read the books; Batch push announcement reminders
2. Design purpose: Unified issuance of training, exam reminders, and in-hospital teaching notices
3. Business Logic: Announcements support selective push to all staff / targeted push to designated departments; Flutter APP and WeChat Mini Program homepages are pinned to the top; The system automatically records the browsing status of each person.
4. Extended Reservation: Scheduled announcement release, announcement attachment upload, announcement reading receipt export.

Page 8-2 Announcement Release Editorial Page

1. Function: Fill in announcement titles and graphic content; Select the recipient population; Set a scheduled release time
2. Design Purpose: Visualize editing announcement content and push targeted notifications to relevant personnel
3. Business logic: Real-time push notifications to mobile devices after announcements are published; Supports scheduled publishing with automatic push notifications when needed.
4. Extended reservation: AI automatically generates announcement notification copy, and links to exam/training links linked to announcements.

Part Two: All pages of the mobile learner app

Page: F1 APP login page

1. Features: Employee ID / mobile number and password login, remember account, recover forgotten password, and cache login information locally
2. Design Purpose: Student identity verification and entry into the learning assessment system
3. Business logic: Interact with Laravel backend authentication interfaces to issue mobile time-sensitive tokens; Local cache login information ensures no repeated login when opened next time.
4. Expansion reservation: WeChat Work / DingTalk one-click login expansion logic.

Page: F2 APP homepage (bottom Tab: main homepage)

1. Features: Pending courses, pending exams, pending check-in offline sessions, latest announcements, AI Q&A quick entry, red dot counting for unread messages, training to-do reminders
2. Design Purpose: Centrally display all to-do items for students, quickly redirecting to core function pages
3. Business logic: backend real-time synchronization of students’ unfinished tasks, automatic counting of unread messages with red dots; Click the card to go directly to the corresponding function page.
4. Extended reservations: Credit overview, electronic certificate entry, quick access to live courses.

Page F3 Online Course List Page

1. Features: All courses, My Selected Courses, fuzzy course search; Course cover, introduction, and progress of learning
2. Design purpose: Browse open online courses within the hospital and independently carry out online learning
3. Business logic: Filter courses according to the department’s permissions; Learning progress is cached offline locally, and you can view your learning history without network connection.
4. Extended reservations: course collections, course reviews, course credit display.

Page F4 Course Details & Courseware Playback Page

1. Features: Courseware list switching, online document preview, audio and video speed / full screen / resume, post-class practice entry
2. Design purpose: Watch the training courseware fully on mobile devices and complete the accompanying exercises to reinforce knowledge points
3. Business logic: playback progress synchronized in real time on the backend; Videos are embedded and played via Tencent Video plugins; Preview documents online without downloading local files.
4. Extended reservations: video notes, AI knowledge point explanation pop-ups.

Page F5 Offline Training Appointment List Page

1. Features: Display of scheduled sessions, filtering by time, reservation/cancellation, viewing reserved sessions
2. Design Purpose: Trainees independently choose suitable training batches to book and participate in off-peak training sessions
3. Business logic: When the reservation batch is full, the reservation button automatically closes; Expired sessions are automatically hidden.
4. Extended reservations: appointment reminder push, offline training check-in credit display.

Page F6 QR code check-in page

1. Features: QR code recognition box, QR code zoom preview, successful check-in pop-up notification, personal check-in history query
2. Design purpose: Quick check-in for offline training sites, replacing traditional paper sign-in forms
3. Business logic: After scanning the code, the backend verifies session and personnel permissions, and check-in records are synchronized in real time to the PC management backend.
4. Extended reservations: offline check-in caching, check-in electronic voucher storage.

Page F7 Online Exam List Page

1. Functions: Display by pending, completed, and make-up exam zones; Exam deadline countdown reminder
2. Design purpose: View all assigned assessments and quickly navigate to the answer page
3. Business logic: Test-to-gray during valid login periods is not used, and entry to answer questions is prohibited; Expired exams are automatically archived.
4. Extended reservations: Quick entry for pre-exam self-test practice and preview of exam credits.

Page F8 online exam answer page

1. Functions: Left or right swipe to switch questions, pop-up display on answer sheets, temporary save for answers, and paper submission; Front-end anti-cutting screen monitoring and prohibition of text copying
2. Design purpose: Standardized mobile answering interface, multiple front-end anti-cheating restrictions
3. Business logic: Answer records are synchronized in real time in the cloud, so switching devices does not result in missing answer content; If the number of page departures exceeds the limit, the system will automatically submit the exam paper.
4. Extended reservations: local cache of answer drafts, AI real-time error prompts (displayed after the exam).

Page F9 Score and Error Overview page

1. Features: Summary of historical exam scores, unified summary of mistakes, statistics of unanswered questions, personal answer accuracy, and error practice entry
2. Design Purpose: Students independently review weak knowledge points in past assessments
3. Business logic: The backend aggregates all personal error data and calls DeepSeek to generate personalized summaries of weak knowledge points.
4. Extended reservation: One-click generation of special test papers for mistakes, export and print for error questions.

Page F10 Error Practice Page

1. Features: Redoing wrong questions, standard answers + AI easy-to-understand analysis, question collection, personal error rate statistics
2. Design Purpose: Repeatedly review frequently mistaken knowledge points and reinforce weak content
3. Business logic: DeepSeek large model simplifies medical professional knowledge points and outputs easy-to-understand explanations.
4. Extended Reservation: Mistakes are categorized and filtered by knowledge points, with scheduled review reminders for errors.

Page: F11 AI Q&A Assistant Conversation Page

1. Functions: Enter medical knowledge points to ask questions, chat bubbles display Q&A content, historical Q&A records, and clear conversation records
2. Design Purpose: Students can consult at any time about training and exam-related medical professional knowledge
3. Business logic: Front-end requests forward Laravel AI middleware, which filters sensitive words and returns professional medical answers, with Q&A records stored in the database for permanent retention.
4. Extended reservations: voice questioning, AI knowledge point mind map generation.

Page F12 questionnaire filling page

1. Functions: Single choice / multiple choice / Q&A filling out, temporary draft saving, questionnaire submission
2. Design purpose: Complete various research questionnaires within the hospital via mobile devices
3. Business logic: Required fields are not filled in to prevent questionnaire submission; after submission, data is synchronized in real time to the backend statistics module.
4. Extended reservation: Small credits will be awarded upon completion of the questionnaire.

Page F13 announcement message page

1. Features: Filters all announcements separately, unread announcements separately, detailed announcement text and images, personal browsing history
2. Design purpose: To receive various announcements such as in-hospital training, examinations, and upgrade notifications
3. Business logic: Click the announcement to automatically mark as read, synchronously update backend browsing statistics.
4. Expansion and reservation: announcement keyword search, announcement favorites.

Page F14 Personal Center page

1. Functions: View personal basic information, password modification, study history, check-in records, push message toggle, local cache cleaning
2. Design Purpose: Unified management of personal account information and local offline cached data
3. Business logic: Local cache for courseware and error records; cleaning the cache only deletes local files, unaffected cloud data.
4. Extended reservations: personal credit ledger, electronic certificate downloads, account unbinding operations.

3. Complete MySQL 8.0 Database Design Specifications (No Code)

3.1 Sharded and Database Sharding Storage Strategies

1. Basic business slip table: department, professional title, nurse level, position, personnel account, administrator role, role permissions, system global configuration, upgrade log, administrator operation log
2. Training Business Data Sheet: Main course schedule, courseware material appendix, trainee learning progress schedule, offline training session schedule, appointment record form, sign-in record form
3. Question bank tables: public_question (2 million public medicine questions), private_question (hospital private questions), question_media (test image / audio / video link), paper main table, paper_question exam question association table
4. Exam annual scoring tables: exam_info Exam Release Form, exam_answer Candidate Answer Record Sheet, exam_score Score Statistics Sheet, exam_error_stat Error Analysis Sheet, exam_retest Retest Record Sheet
5. Survey announcement data tables: main survey, survey_item questionnaire question table, survey_answer questionnaire response sheet, notice announcement form, notice_read announcement browsing record table
6. DeepSeek AI dedicated data tables: ai_api_log large model call logs, ai_question_cache AI-generated question cache, ai_user_chat learner mobile Q&A records
7. Expansion reserved tables: sys_extend Global expansion field table, allowing new business expansion fields to be added without modifying the main table, supporting multi-campus, credit, certificate, and HIS integration data storage.

3.2 Database Performance and Security Specifications

1. All associated ID, time, and high-frequency filter fields are indexed together to speed up millions of data queries;
2. User password fields are encrypted with salted hash code, and plaintext storage is prohibited;
3. Large text and multimedia external links are uniformly stored in independent tables, reducing the burden on main table queries;
4. Deploys MySQL master-slave read-write separation architecture, offloading exam query traffic to slave databases to support high-concurrency access;
5. The system automatically backs up all databases daily, with multiple copies stored in different locations;
6. All tables reserve extend_json extension fields for later functional expansion, without modifying the table structure.

4. DeepSeek AI Large Model Integration Comprehensive Solution

4.1 Transit-Architecture Logic

Flutter mobile and PC management frontends do not directly connect to the official DeepSeek API; all AI requests are forwarded uniformly through the Laravel11 backend middleware; Unified key management, call rate limiting, sensitive word filtering, and operation log storage to avoid key leakage risks.

4.2 Eight Core AI Business Logics

1. AI batch generation of medical exam questions: administrators input department, knowledge points, difficulty, and question types, then assemble a professional prompt to call DeepSeek, which returns standardized questions and automatically formats them into a private question bank;
2. AI automatic question analysis: Select questions without explanations and instantly generate professional medical explanations to fill in the questions;
3. AI Question Correction and Optimization: Automatically detects typos in the question stem and medical knowledge errors, and outputs correction suggestions;
4. Intelligent training copy generation: Enter annual training objectives to automatically generate course summaries and complete quarterly training plans;
5. Intelligent analysis of college-wide / individual mistakes: aggregates data on students’ mistakes, AI-generated weak knowledge points summarized, and automatically recommends specialized review papers;
6. Subjective AI-assisted grading: Extracts answers to short-answer questions from candidates, matches keywords for reference answers, outputs score range references, and provides only manual grading assistance;
7. Mobile learner AI Q&A: Students ask about medical knowledge points; the backend filters out illegal medical content and returns popular, professional answers;
8. Automatic generation of course-supporting exercises: Read the content of the course courseware and automatically generate corresponding post-class self-assessment exercises.

4.3 AI Control and Extension Rules

1. Daily AI call quotas are allocated based on hospital accounts, with automatic AI interception over limits;
2. All AI requests and returns are fully stored in ai_api_log data tables for permanent traceability;
3. Built-in medical sensitive word filtering database that directly blocks violating content and does not return to the frontend;
4. Interface timeout automatically fuses and retries to avoid server resource usage;
5. Extended reservations: AI-generated training briefs, AI-generated teaching rectification reports, AI-generated electronic certificate copywriting interfaces.

5. UI/UX Pro Max Professional Visual Interaction Design Standards

5.1 PC Management Backend Design Standards

1. Overall layout: Side foldable navigation bar + top operation bar + main content area, supports one-click switching between dark and light color modes;
2. Data visualization: training sessions, exams, and error statistics are unified into a unified chart component, with warning data highlighted in red;
3. Interaction specifications: batch operation secondary confirmation pop-ups, import/export progress pop-ups, real-time form input verification, and dedicated navigation-free streamlined print layouts;
4. Screen compatibility: 1920 large screen, 1366 narrow screen, adaptive responsive tablet layout;
5. Extended reservations: independent UI component library for data dashboards, multi-campus switching control design specifications.

5.2 Flutter Mobile UI/UX Standard

1. Page layout: Bottom 5 columns with fixed tabs (Home, Courses, Exams, AI Q&A, My);
2. Exclusive custom components: video player, floating pop-up answer sheet, QR code check-in component, AI bubble chat card;
3. Interaction optimization: skeleton screen loading animations, data-friendly blank prompt pages, successful and failed light animations, local offline caching mechanism;
4. Screen adaptation: prioritizes vertical screen layout for phones, tablet devices automatically display dual-bar split-screen display, and font size is adjusted accordingly;
5. Extended reservations: live player components, electronic certificate preview components, credit counting card design specifications.

5.3 Universal UX Pro Max Enhanced Interaction (Unified across the Entire End)

1. Global fuzzy search: one-click global search of question banks, personnel, courses, and test papers;
2. Unified batch operation entry: batch import, batch delete, batch assignment exam, batch export;
3. Message red dots are counted as unread, and all to-do items are centrally reminded;
4. Real-time data synchronization across multiple ends, with seamless delay and seamless communication of PC backend and app operation status;
5. Split forms in stages and load long data in pagination, reducing page lag.

6. Phased refined development and implementation of a complete plan

Total development cycle: 180 working days

Stage 1: Finalizing requirements + full UI/UX Pro Max design + MySQL 8.0 database architecture design (18 working days)

Job responsibilities

1. Sort through all PC functions, page functions, business logic, and reserved expansion requirements item by line, and output standardized requirements specifications;
2. UI/UX Pro Max complete visual interaction design: PC backend full-page high-fidelity design drafts, Flutter mobile full-page design drafts, global component libraries, and interactive effect specification documents;
3. MySQL 8.0 provides complete table segmentation structure, indexes, association relationships, extended field planning, and outputs detailed database design documents;
4. Define Laravel front-end and back-end interface specifications, DeepSeek AI middleware interaction protocols, and extended interface reservation standards;

Deliverables

Requirement specifications, complete UI design drafts, database design documents, interface specification documents, AI integration solutions, and reserved specification documents for feature extensions;

Acceptance criteria

All page functions, business logic, and expansion requirements are finalized, with no risk of database structure changes.

Stage 2: Laravel 11 + PHP 8.3 Underlying Backend Framework Development (32 working days)

Job responsibilities

1. Construction of the project foundational framework, full-site HTTPS authentication gateway, RSA interface signature verification;
2. Development of underlying business logic for personnel, departments, and role permissions;
3. File upload services, CDN resource integration, Tencent Video playback plugin integration;
4. DeepSeek AI fully encapsulates the middleware: API forwarding, call rate limiting, sensitive word filtering, log storage, exception circuit breakers;
5. System scheduled task development: quarterly upgrade inspection, automatic database backup, automatic submission of exam overtime, and cleaning expired logs;
6. Global expansion field underlying logic development, with reserved interfaces for future functional expansion;

Deliverables

Backend basic services, AI middleware, database initialization scripts, and underlying extension interfaces;

Acceptance criteria

Login authentication, file upload, AI basic calls, scheduled tasks, and the underlying logic for extended fields all run normally.

Phase 3: Full business module backend interface development (45 working days)

Job responsibilities

1. A complete set of business interfaces for training plans, online courses, courseware materials, and learning progress;
2. Offline training sessions, appointments, QR code check-in, and check-in statistics interface;
3. 2 million public question banks, private hospital question banks, and six intelligent paper-building complete interfaces;
4. Online exam publishing, multi-layer anti-cheating, automatic grading, and multi-dimensional data statistics interfaces;
5. Questionnaires, announcements, batch import and export, test paper printing interface development;
6. DeepSeek AI fully implements its full business functions: question generation, error analysis, subjective question grading assistance, and training copy generation;
7. All extended functions are reserved for interface development;

Deliverables

Complete set of business backend interface and supporting interface documentation;

Acceptance criteria

All page backend business logic can be called normally, AI is fully functional, and expansion interfaces are fully reserved.

Stage 4: Full-page development of Android + iOS dual-platform APP (40 working days)

Job responsibilities

1. Basic underlying framework: login authentication, token management, local offline caching, message push, public barcode scanning components;
2. Comprehensive development of homepage, course learning, and video playback pages;
3. Development of offline training reservations and QR code check-in interaction pages;
4. Online exam answers, answer sheets, front-end anti-cheating page development;
5. Score inquiry, error practice, AI Q&A dialogue page development;
6. Questionnaire completion, announcement browsing, personal center page development;
7. Dual-platform adaptation and debugging for Android and iOS, tablet layout compatibility, and a full set of UI animations implemented;
8. Reserved layout for mobile extension feature pages;

Deliverables

Android and iOS test installation packages;

Acceptance criteria

All student pages are fully functional, with smooth integration with backend interfaces, UI strictly matching design drafts, and a complete layout for extended reservations.

Stage 5: PC Management Web Backend Full Page Development (28 working days)

Job responsibilities

1. Login page, global data dashboard, system configuration, upgrade management, operation log page development;
2. Comprehensive management page for personnel organizational structure and role permissions;
3. Training plans, course courseware, and offline sign-in management pages;
4. Question bank, test papers, intelligent paper compilation, exam publishing, grading, and multi-dimensional data statistics pages;
5. Questionnaire and announcement management pages;
6. Batch import and export, test paper printing, and AI batch generation test question operation pages;
7. Backend extension function reserved page module development;

Deliverables

Complete PC management backend testing system;

Acceptance criteria

All administrator pages are fully functional, data statistics and batch operations work normally, and reserved expansion modules are available.

Stage 6: Full-link joint debugging, multi-dimensional testing, full bug fixing (22 working days)

Job responsibilities

1. PC management backend + mobile full module front-end and back-end joint debugging, fixing business interaction bugs;
2. High Concurrency Stress Testing: Simulates thousands of people simultaneously taking exams online, batch imports tens of thousands of questions, and batch exports reports;
3. CDN elastic scalability, no account limit, no courseware storage limit, extreme scenario testing;
4. Site-wide HTTPS security penetration testing, interface anti-brushing, data encryption verification, and unauthorized access interception testing;
5. DeepSeek AI concurrent calls, rate limiting, and abnormal circuit breaker special tests;
6. Full-page feature regression testing item by item, closed-loop fixes for all blocking bugs;
7. Expansion reserved interfaces and expansion field compatibility testing;

Deliverables

Stress test reports, security inspection reports, bug fix acceptance checklists, and extension compatibility test reports;

Acceptance criteria

No blocking bugs, no system crashes in high-concurrency scenarios, stable AI calls, and no compatibility issues with extension fields.

Stage 7: Grayscale trial run, quarterly automatic upgrade development, complete delivery documentation output (15 working days)

Job responsibilities

1. Quarterly remote automatic upgrade of the entire service development system, with upgrade instructions automatically generated and implemented modules;
2. Single-hospital grayscale deployment trial runs to collect interaction detail optimization needs;
3. Complete set of delivery documents organized and output;
4. Authoring administrator operation manuals, mobile learner user manuals, and cloud deployment and operation manuals;

Deliverables

Deployment plans, complete standardized usage documentation, and operation and maintenance manuals;

Acceptance criteria

The quarterly automatic upgrade process is fully operational, with a full set of documentation covering all functions and extended notes.

Stage 8: Comprehensive project acceptance and delivery

1. Comprehensive demonstration and acceptance of all functions, including demonstrations of basic functions and reserved expansion modules;
2. Delivers complete source code, UI design source files, MySQL database initialization scripts, and complete development documentation;
3. Deliver Android/iOS test installation packages and PC management backend access addresses.

7. Comprehensive Testing Plan

1. Functional testing: verify PC items one by one, all basic page functions, business logic, and extended reserved modules;
2. Concurrent stress testing: thousands of people taking exams online simultaneously, batch import of tens of thousands of questions, and large-scale data export;
3. Security penetration testing: unauthorized access, file upload vulnerabilities, interface parameter tampering, password encryption verification;
4. DeepSeek AI specialized tests: batch generation of questions, concurrent Q&A, call rate limiting, and medical-sensitive word filtering;
5. Multi-device compatibility testing😛 C: multiple browsers, multiple versions of Android, multiple versions of iOS, and adaptation for both horizontal and vertical screens on mobile and tablet devices;
6. Extension function compatibility testing: Verify that reserved extension fields and extension interfaces can add new business functions normally without refactoring the underlying layer.

8. Cloud deployment, quarterly automatic upgrades, and long-term operation and maintenance solutions

8.1 Elastic Cloud Deployment Architecture

1. Laravel backend containerized deployment supports horizontal elastic scaling, automatically adding service instances for high concurrency;
2. MySQL 8.0 features a master-slave separation architecture, splitting read traffic to the slave database and enhancing exam query concurrent capacity;
3. Cloud object storage for courseware and image resources, CDN nationwide nodes distribute static resources, reducing source site pressure;
4. Teaching videos are centrally hosted by Tencent Video, storing only external links, significantly reducing platform bandwidth consumption.

8.2 Complete process for remote automatic upgrades throughout the quarter

1. The system has built-in scheduled tasks and automatically detects official new version upgrade packages every quarter;
2. Before the upgrade, it automatically triggers a full-database backup and generates an illustrated upgrade documentation;
3. Execute upgrade scripts in batches to ensure uninterrupted business;
4. If an abnormality occurs during the upgrade process, the rollback script will automatically execute and restore the stable version before the upgrade;
5. Expansion module upgrades isolate execution without affecting the original basic business operations.

8.3 Data Security Operation and Maintenance Standards

1. Daily automatic full database backup, multiple copies stored in different locations to prevent data loss;
2. Administrator operations, AI calls, system upgrades—full-link logs are permanently retained, supporting audit traceability;
3. Automatically clears expired caches at scheduled times, archives multi-year historical exam data into scoretables, improving query efficiency;
4. Exported personnel and sensitive data automatically desensitizes to avoid internal information leakage risks;
5. Extended field data is independently archived without interfering with core business data queries.

9. Complete set of project delivery document lists

1. “Hospital Medical Theory Knowledge Assessment System Requirements Specification (Full Page Functions + Expansion Reservation)”
2. “MySQL 8.0 Detailed Database Design Documentation (Including Extended Field Planning)”
3. “Laravel11 Unified Front-End and Backend Interface Specification Document (including Extended Interfaces)”
4. “DeepSeek AI Large Model Integration Complete Design Solution”
5. “UI/UX Pro Max Visual Interaction Design Specification + Complete Set of Page Design Source Files”
6. “Flutter Mobile Page Interaction Detailed Development Document”
7. “PC Management Backend Page Feature Development Document”
8. “180-Day Phased Refined Development Implementation Plan”
9. “Cloud Elastic Deployment and Concurrent Expansion Operation and Maintenance Plan”
10. “Complete Plan for Sitewide HTTPS Secure Encryption and Exam Anti-Cheating Measures”
11. “System Quarterly Automatic Upgrade and Maintenance Operation Manual”
12. Complete Backend Administrator Operation Manual (including Extended Function Usage Instructions)
13. “Mobile Learner’s User Manual”
14. “Concurrent Stress Testing and Safety Testing Standard Report Template”
15. “System Long-Term Function Extension Iteration Development Specification Document”

10. Project Development Quotation Details (Total Price 12000USD)