{"id":1044,"date":"2026-02-12T07:24:58","date_gmt":"2026-02-12T07:24:58","guid":{"rendered":"https:\/\/www.rajeshkumar.xyz\/blog\/?p=1044"},"modified":"2026-02-12T07:25:00","modified_gmt":"2026-02-12T07:25:00","slug":"codex-master-prompt-1","status":"publish","type":"post","link":"https:\/\/www.rajeshkumar.xyz\/blog\/codex-master-prompt-1\/","title":{"rendered":"Codex Master Prompt. – 1"},"content":{"rendered":"
Below is a **complete end-to-end Requirements Specification** you can copy\/paste into Codex (or<\/span> any code generator) to build the Laravel app in one go. I kept your original requirements, filled the missing parts, and<\/span> made everything **implementation-ready** (routes, modules, DB schema, validations, permissions, SEO rules, and<\/span> acceptance criteria).\n\n---\n\n## 1) Project Overview<\/span>\n\n### Product name<\/span>\n\n**bestorthohospitals.com Directory App** (Laravel)\n\n### Purpose<\/span>\n\nA global<\/span> directory listing website for<\/span> **Orthopedic Hospitals** and<\/span> **Orthopedic Doctors** with:\n\n* Country & city based SEO URLs\n* Search\/filter on every page\n* Hospital\/Doctor profiles\n* Appointment slot management (Hospitals\/Doctors)\n* User bookings with live availability\n* Admin moderation (block\/unblock, manage content)\n* Home page aggregation (featured doctors\/hospitals + latest posts from WordPress blog + Flarum forum)\n\n### Primary user journeys<\/span>\n\n1.<\/span> Visitor searches doctors\/hospitals \u2192 opens profile \u2192 logs in with Google \u2192 books a slot.\n2.<\/span> Hospital logs in with Google \u2192 creates\/updates hospital profile \u2192 creates slots \u2192 receives bookings \u2192 approves\/cancels.\n3.<\/span> Doctor logs in with Google \u2192 creates\/updates doctor profile \u2192 creates slots \u2192 receives bookings \u2192 approves\/cancels.\n4.<\/span> Admin logs in with password \u2192 manages users\/profiles \u2192 blocks\/unblocks \u2192 controls featured ranking \u2192 reviews bookings.\n\n---\n\n## 2) Tech Stack & Constraints<\/span>\n\n* PHP **8.2<\/span>**\n* Laravel **12<\/span>**\n* DB: **SQLite (latest)**\n* UX: **Bootstrap (latest)**\n* Auth: **Google OAuth only** for<\/span> Users\/Hospitals\/Doctors\n* Admin auth: **Email\/Username + Password** (separate guard, separate URL)\n* Deployment mode: **No `\/public<\/span>` in URL** (Flarum-style)\n\n---\n\n## 3) Top\/Bottom Menus (Global)<\/span>\n\nTop Menu & Bottom Menu:\n**Home | Hospitals | Doctors | Blog | Forum | Surgery | Treatments | Diseases | Procedures | About | Contact us**\n\nRules:\n\n* \u201cBlog\u201d menu links to the WordPress blog (external).\n* \u201cForum\u201d menu links to the Flarum forum (external).\n* All other items are served from Laravel app.\n\n---\n\n## 4) Roles & Permissions (RBAC)<\/span>\n\n### Roles<\/span>\n\n* **USER**: can book appointments; manage own profile basics\n* **HOSPITAL**: manage hospital profile + slots + bookings\n* **DOCTOR**: manage doctor profile + slots + bookings\n* **ADMIN**: manage everything; block\/unblock accounts; feature\/rank; view logs\/bookings\n\n### Permission matrix (must)<\/span>\n\n| Action                          |     User |                 Hospital |                   Doctor |       Admin |\n| ------------------------------- | -------: | -----------------------: | -----------------------: | ----------: |\n| Google login                    |        \u2705 |                        \u2705 |                        \u2705 |           \u274c |\n| Admin password login            |        \u274c |                        \u274c |                        \u274c |           \u2705 |\n| View directory                  |        \u2705 |                        \u2705 |                        \u2705 |           \u2705 |\n| Create\/update own profile       | \u2705(basic) |              \u2705(hospital) |                \u2705(doctor) |           \u2705 |\n| Create slots                    |        \u274c |                        \u2705 |                        \u2705 |           \u2705 |\n| Book slot                       |        \u2705 | \u274c(unless also USER role) | \u274c(unless also USER role) | \u2705(optional) |\n| Manage bookings for<\/span> own profile |        \u274c |                        \u2705 |                        \u2705 |           \u2705 |\n| Block\/unblock accounts          |        \u274c |                        \u274c |                        \u274c |           \u2705 |\n| Manage featured\/top ranking     |        \u274c |                        \u274c |                        \u274c |           \u2705 |\n\n**Important rule:** One Google account = one primary role chosen during onboarding (USER\/HOSPITAL\/DOCTOR). Admin is separate login system.\n\n---\n\n## 5) Authentication Requirements<\/span>\n\n### Google OAuth (mandatory for non-admin)<\/span>\n\n* Use<\/span> Laravel<\/span> Socialite<\/span> with<\/span> Google<\/span>.\n* Only<\/span> Google<\/span> login<\/span>: **no<\/span> password<\/span> login<\/span>** for<\/span> USER<\/span>\/HOSPITAL<\/span>\/DOCTOR<\/span>.\n\nRequired<\/span> `.env<\/span>` keys<\/span> (example<\/span>; keep in code block):\n\n```env\nAPP_URL=http:\/\/localhost\/bestcanow<\/span>\nGOOGLE_CLIENT_ID=\nGOOGLE_CLIENT_SECRET=\nGOOGLE_REDIRECT_URI=http:\/\/localhost\/bestcanow\/auth\/google\/callback<\/span>\n```\n\n### Onboarding after first Google login<\/span>\n\nIf<\/span> first-time login:\n\n1.<\/span> Ask user to select account type: **User \/ Hospital \/ Doctor**\n2.<\/span> Create user row with role\n3.<\/span> Redirect to role dashboard:\n\n   * USER \u2192 \u201cMy Bookings\u201d\n   * HOSPITAL \u2192 \u201cHospital Dashboard\u201d\n   * DOCTOR \u2192 \u201cDoctor Dashboard\u201d\n\n### Account block\/unblock<\/span>\n\n* Admin can set `is_blocked = true<\/span>`.\n* Blocked accounts cannot login (show message: \u201cAccount blocked. Contact support.\u201d).\n\n### Admin auth (separate)<\/span>\n\n* Separate admin guard and<\/span> routes, e.g.:\n\n  * `\/admin\/login` (password)\n  * `\/admin` (dashboard)\n* Admin credentials seeded via seeder or<\/span> created with CLI.\n* Admin accounts stored in `admin_users` table (separate from users).\n\n---\n\n## 6) Global UI Components (Must)<\/span>\n\n### Global Search\/Filter (Must appear at top of EVERY page)<\/span>\n\nFilter supports:\n\n* Search keyword (doctor\/hospital name)\n* Country (dropdown)\n* City (dependent dropdown or<\/span> autocomplete)\n* Type toggle (Doctors \/ Hospitals \/ Both)\n* Optional filters (recommended MVP):\n\n  * Specialty tags (orthopedic sub-specialty)\n  * Treatments\/Procedures tags\n  * \u201cHas available slots\u201d checkbox\n\nBehavior:\n\n* Submitting search takes user to a combined results page OR<\/span> stays within page context:\n\n  * If<\/span> user is on `\/doctors`, show doctor results.\n  * If<\/span> on `\/hospitals`, show hospital results.\n  * If<\/span> on home, show combined results with tabs.\n\n---\n\n## 7) Pages & Content Requirements<\/span>\n\n### 7.1 Home (`\/`)<\/span>\n\nSections:\n\n1.<\/span> **Search\/Filter bar** (global<\/span> component)\n2.<\/span> **Bootstrap Carousel\/Slider**\n\n   * Admin-manageable slides (title, subtitle, CTA link)\n3.<\/span> **Top 20<\/span> Doctors**\n4.<\/span> **Top 20<\/span> Hospitals**\n5.<\/span> **Top 20<\/span> Blog posts** from WordPress blog\n6.<\/span> **Top 20<\/span> Forum posts** from Flarum forum\n\nRules for<\/span> \u201cTop\u201d:\n\n* Only `published` profiles\n* Ordered by:\n\n  1.<\/span> `is_featured DESC`\n  2.<\/span> `featured_rank ASC` (admin-controlled)\n  3.<\/span> `profile_views DESC` (optional)\n  4.<\/span> `updated_at DESC`\n\n### 7.2 Hospitals listing (`\/hospitals`)<\/span>\n\n* Search\/Filter bar (global<\/span>)\n* List<\/span> **Top 30<\/span> hospitals** with pagination\n* Each item: name, city\/country, thumbnail, short summary, \u201cBook Appointment\u201d button, profile link\n\n### 7.3 Doctors listing (`\/doctors`)<\/span>\n\n* Search\/Filter bar (global<\/span>)\n* List<\/span> **Top 30<\/span> doctors** with pagination\n* Each item: name, specialization, city\/country, thumbnail, short summary, \u201cBook Appointment\u201d button, profile link\n\n### 7.4 Blog menu item<\/span>\n\n* Clicking \u201cBlog\u201d opens external WP blog.\n* Home page also shows \u201cTop 20<\/span> Blog posts\u201d via feed integration (see Section 12<\/span>).\n\n### 7.5 Forum menu item<\/span>\n\n* Clicking \u201cForum\u201d opens external Flarum forum.\n* Home page shows \u201cTop 20<\/span> Forum posts\u201d via feed integration (see Section 12<\/span>).\n\n### 7.6 Medical Library Pages (Surgery\/Treatments\/Diseases\/Procedures)<\/span>\n\nMVP requirement:\n\n* Each of these menu items goes to a list<\/span> page:\n\n  * `\/surgery`\n  * `\/treatments`\n  * `\/diseases`\n  * `\/procedures`\n* Each item has detail page:\n\n  * `\/{type}\/{slug}`\n* Admin can create\/edit\/delete items.\n* Each detail page has SEO meta + optional related doctors\/hospitals.\n\n### 7.7 About (`\/about`)<\/span>\n\nStatic<\/span> CMS page editable by Admin.\n\n### 7.8 Contact (`\/contact`)<\/span>\n\n* Contact form fields: Name, Email, Subject, Message\n* Save in DB + optional email notification to site admin\n* Add anti-spam protections (minimum):\n\n  * rate limit per IP\n  * honeypot field\n\n---\n\n## 8) SEO & Slug Requirements (Strict)<\/span>\n\n### 8.1 Profile URL patterns (Must)<\/span>\n\n**Doctor profile URL:**\n`\/doctors\/{country}\/{city}\/{ca-name}`\n\n**Hospital profile URL:**\n`\/hospitals\/{country}\/{city}\/{ca-name}`\n\nExamples:\n\n* `\/doctors\/india\/delhi\/doctor-name`\n* `\/hospitals\/india\/delhi\/hospital-name`\n\n### 8.2 Slug generation rules<\/span>\n\n* `country` = slug from country name (lowercase)\n* `city` = **city_slug** (lowercase)\n* `{ca-name}` = slug from doctor\/hospital name (lowercase)\n* Also store a **combined unique slug key** internally:\n\n  * `slug_key = \"{country_slug}-{city_slug}-{name_slug}\"<\/span>`\n\n### 8.3 City normalization (Must)<\/span>\n\n* Store:\n\n  * `city_display` = Title Case<\/span> (\u201cNew<\/span> Delhi\u201d)\n  * `city_slug` = lowercase slug (\u201cnew<\/span>-delhi\u201d)\n* When saving, normalize inputs to avoid duplicates like \u201cdelhi\u201d, \u201cDELHI\u201d, \u201cDelhi\u201d.\n* Search must be case<\/span>-insensitive; URLs always use<\/span> `city_slug<\/span>`.\n\n### 8.4 Top<\/span> pages<\/span> (Must<\/span>)\n\nImplement<\/span> these<\/span> routes<\/span>:\n\n* `\/top<\/span>-hospitals<\/span>` \u2192 shows<\/span> all<\/span> countries<\/span> (country<\/span> cards<\/span> with<\/span> counts<\/span>)\n* `\/top<\/span>-doctors<\/span>\/{country<\/span>}` \u2192 shows<\/span> 45 doctors<\/span> for<\/span> that<\/span> country<\/span> in<\/span> **3 columns<\/span> x<\/span> 15 rows<\/span>**\n* `\/{doctors<\/span>|hospitals<\/span>}\/{country<\/span>}\/{city<\/span>}` \u2192 list<\/span> for<\/span> that<\/span> city<\/span>\n\n> Even<\/span> if<\/span> naming<\/span> feels<\/span> inconsistent<\/span>, implement<\/span> exactly<\/span> as<\/span> above<\/span> since<\/span> you<\/span> requested<\/span> these<\/span> patterns<\/span>.\n\n### 8.5 SEO<\/span> tags<\/span> (Must<\/span> on<\/span> ALL<\/span> pages<\/span>)\n\nEvery<\/span> page<\/span> must<\/span> output<\/span>:\n\n* `<title<\/span>>`\n* meta<\/span> description<\/span>\n* meta<\/span> keywords<\/span>\n* canonical<\/span> URL<\/span>\n* Open<\/span> Graph<\/span> tags<\/span>\n* Twitter<\/span> Card<\/span> tags<\/span>\n\nAlso<\/span> required<\/span>:\n\n* `robots<\/span>.txt<\/span>`\n* `sitemap<\/span>.xml<\/span>` (auto<\/span>-generated<\/span>, includes<\/span> all<\/span> public<\/span> profiles<\/span> + medical<\/span> library<\/span> pages<\/span>)\n\n---\n\n## 9) \u201cNo<\/span> Public<\/span> Directory<\/span>\u201d Installation<\/span> Requirement<\/span> (Strict<\/span>)\n\nMust<\/span> run<\/span> as<\/span>:\n\n* `http<\/span>:\/\/localhost<\/span>\/bestcanow<\/span>\/` (no<\/span> `\/public<\/span>`)\n* No<\/span> vhost<\/span> required<\/span>\n* Root<\/span> `.htaccess<\/span>` handles<\/span> routing<\/span> + serves<\/span> assets<\/span>\n* Root<\/span> `index<\/span>.php<\/span>` boots<\/span> Laravel<\/span>\n\nAcceptance<\/span> criteria<\/span>:\n\n* Visiting<\/span> `\/` loads<\/span> home<\/span> page<\/span>\n* Visiting<\/span> `\/css<\/span>\/app<\/span>.css<\/span>` (or<\/span> compiled<\/span> assets<\/span> path<\/span>) works<\/span>\n* Visiting<\/span> any<\/span> route<\/span> works<\/span> without<\/span> `\/public<\/span>`\n\n(Implementation<\/span> may<\/span> either<\/span> move<\/span> public<\/span> assets<\/span> to<\/span> root<\/span> or<\/span> forward<\/span> requests<\/span> to<\/span> `public<\/span>\/` while<\/span> keeping<\/span> URL<\/span> root<\/span> clean<\/span>\u2014your<\/span> spec<\/span> requires<\/span> the<\/span> final<\/span> behavior<\/span>, not<\/span> a<\/span> specific<\/span> internal<\/span> technique<\/span>.)\n\n---\n\n## 10) Profiles<\/span> (Hospitals<\/span> & Doctors<\/span>)\n\n### 10.1 Hospital<\/span> Profile<\/span> Fields<\/span> (MVP<\/span> + validation<\/span>-ready<\/span>)\n\nRequired<\/span> fields<\/span>:\n\n* Hospital<\/span> name<\/span>\n* About<\/span>\/Description<\/span> (rich<\/span> text<\/span> optional<\/span>)\n* Country<\/span>\n* City<\/span> (city_display<\/span> + city_slug<\/span>)\n* Full<\/span> address<\/span>\n* Phone<\/span>\n* Email<\/span> (optional<\/span>)\n* Website<\/span> (optional<\/span>)\n* 1\u20132 photos<\/span> (upload<\/span>)\n\nRecommended<\/span> fields<\/span>:\n\n* Latitude<\/span>\/Longitude<\/span> (optional<\/span>)\n* Services<\/span>\/Treatments<\/span> tags<\/span>\n* Working<\/span> hours<\/span> text<\/span>\n* Emergency<\/span> available<\/span> (yes<\/span>\/no<\/span>)\n\n### 10.2 Doctor<\/span> Profile<\/span> Fields<\/span> (MVP<\/span> + validation<\/span>-ready<\/span>)\n\nRequired<\/span> fields<\/span>:\n\n* Doctor<\/span> full<\/span> name<\/span>\n* About<\/span>\/Description<\/span>\n* Country<\/span>\n* City<\/span> (city_display<\/span> + city_slug<\/span>)\n* Clinic<\/span>\/Hospital<\/span> association<\/span> (optional<\/span>)\n* Specialization<\/span> (orthopedics<\/span> + subspecialty<\/span>)\n* Experience<\/span> years<\/span> (number<\/span>)\n* Phone<\/span> (optional<\/span>)\n* Email<\/span> (optional<\/span>)\n* 1\u20132 photos<\/span> (upload<\/span>)\n\nRecommended<\/span> fields<\/span>:\n\n* Degrees<\/span>\/Qualifications<\/span>\n* Languages<\/span> spoken<\/span>\n* Consultation<\/span> fee<\/span> (optional<\/span>)\n\n### 10.3 Profile<\/span> publishing<\/span> workflow<\/span>\n\n* New<\/span> profiles<\/span> start<\/span> as<\/span> `draft<\/span>`.\n* Owner<\/span> can<\/span> submit<\/span> for<\/span> publishing<\/span> \u2192 becomes<\/span> `pending_review<\/span>`.\n* Admin<\/span> can<\/span> approve<\/span> \u2192 `published<\/span>` or<\/span> reject<\/span> \u2192 `draft<\/span>` with<\/span> reason<\/span>.\n\n---\n\n## 11) Appointment<\/span> Booking<\/span> & Slot<\/span> System<\/span> (Core<\/span> Feature<\/span>)\n\n### 11.1 Core<\/span> concepts<\/span>\n\n* **Slot<\/span>**: A<\/span> time<\/span> window<\/span> available<\/span> for<\/span> booking<\/span> (date<\/span> + start_time<\/span> + end_time<\/span>).\n* Slots<\/span> belong<\/span> to<\/span> either<\/span>:\n\n  * a<\/span> Hospital<\/span> profile<\/span>, or<\/span>\n  * a<\/span> Doctor<\/span> profile<\/span>\n* **Booking<\/span>**: A<\/span> user<\/span> reserves<\/span> a<\/span> slot<\/span>.\n\n### 11.2 Slot<\/span> management<\/span> (Hospital<\/span>\/Doctor<\/span>)\n\nMust<\/span> allow<\/span>:\n\n* Create<\/span> slots<\/span>:\n\n  * single<\/span> slot<\/span>\n  * bulk<\/span> create<\/span> (e<\/span>.g<\/span>., \u201cevery<\/span> day<\/span> 10:00\u201313:00 for<\/span> next<\/span> 14 days<\/span>\u201d)\n* Edit<\/span> future<\/span> slots<\/span>\n* Delete<\/span> future<\/span> slots<\/span> (if<\/span> not<\/span> booked<\/span>)\n* View<\/span> slot<\/span> calendar<\/span>\/list<\/span>\n\nConstraints<\/span>:\n\n* No<\/span> overlapping<\/span> slots<\/span> for<\/span> same<\/span> owner<\/span> (doctor<\/span>\/hospital<\/span>)\n* Slot<\/span> duration<\/span> min<\/span> 10 mins<\/span>, max<\/span> 4 hours<\/span> (configurable<\/span>)\n\n### 11.3 Booking<\/span> flow<\/span> (User<\/span>)\n\n* On<\/span> profile<\/span> page<\/span>: show<\/span> available<\/span> dates<\/span>\/slots<\/span>\n* User<\/span> chooses<\/span> slot<\/span> \u2192 must<\/span> be<\/span> logged<\/span> in<\/span> (Google<\/span>)\n* Booking<\/span> form<\/span> fields<\/span>:\n\n  * Patient<\/span> name<\/span> (default<\/span> from<\/span> Google<\/span> profile<\/span>, editable<\/span>)\n  * Email<\/span> (from<\/span> Google<\/span>, read<\/span>-only<\/span>)\n  * Phone<\/span> (required<\/span>)\n  * Reason<\/span>\/Notes<\/span> (optional<\/span>)\n* Booking<\/span> statuses<\/span>:\n\n  * `pending<\/span>` (default<\/span>)\n  * `confirmed<\/span>` (owner<\/span> confirms<\/span>)\n  * `cancelled_by_user<\/span>`\n  * `cancelled_by_owner<\/span>`\n  * `completed<\/span>` (optional<\/span>)\n\nRules<\/span>:\n\n* One<\/span> slot<\/span> can<\/span> be<\/span> booked<\/span> by<\/span> only<\/span> one<\/span> user<\/span>.\n* Prevent<\/span> double<\/span>-book<\/span> by<\/span> DB<\/span> unique<\/span> constraints<\/span> + transaction<\/span> lock<\/span>.\n* User<\/span> can<\/span> cancel<\/span> up<\/span> to<\/span> configurable<\/span> cutoff<\/span> (e<\/span>.g<\/span>. 2 hours<\/span> before<\/span> start<\/span>).\n\n### 11.4 Notifications<\/span> (MVP<\/span>)\n\nAt<\/span> minimum<\/span>:\n\n* Show<\/span> dashboard<\/span> notifications<\/span> (in<\/span>-app<\/span>)\n  Recommended<\/span> (if<\/span> possible<\/span>):\n* Email<\/span> notification<\/span> on<\/span> booking<\/span> create<\/span>\/confirm<\/span>\/cancel<\/span>\n\n### 11.5 Timezone<\/span>\n\n* Store<\/span> slot<\/span> times<\/span> in<\/span> UTC<\/span> in<\/span> DB<\/span>\n* Display<\/span> using<\/span>:\n\n  * profile<\/span> timezone<\/span> (default<\/span> from<\/span> country<\/span>) OR<\/span>\n  * site<\/span> timezone<\/span> setting<\/span>\n\n---\n\n## 12) External<\/span> Content<\/span> Integration<\/span> (Home<\/span> Page<\/span>)\n\n### 12.1 WordPress<\/span> blog<\/span> \u201cTop<\/span> 20 posts<\/span>\u201d\n\nUse<\/span> WordPress<\/span> REST<\/span> API<\/span> (cache<\/span> results<\/span>).\nExample<\/span> endpoint<\/span> format<\/span> (put<\/span> in<\/span> code<\/span>\/config<\/span>; shown here as<\/span> requirement):\n\n```text\nhttps:\/\/bestorthohospitals.com\/blog\/wp-json\/wp\/v2\/posts?per_page=20<\/span>\n```\n\nData displayed:\n\n* Title\n* Publish date\n* Featured image (if<\/span> available)\n* Short excerpt\n* Link to original post (open external)\n\nCaching:\n\n* Cache for<\/span> 15<\/span> minutes (configurable)\n* If<\/span> API fails: show \u201cView all blog posts\u201d link only\n\n### 12.2 Flarum forum \u201cTop 20 posts\/discussions\u201d<\/span>\n\nUse<\/span> Flarum<\/span> JSON<\/span>:API<\/span> (cache<\/span> results<\/span>).\nExample<\/span> endpoint<\/span> format<\/span>:\n\n```text<\/span>\nhttps<\/span>:\/\/bestorthohospitals<\/span>.com<\/span>\/forum<\/span>\/api<\/span>\/discussions<\/span>?page<\/span>[limit<\/span>]=20&sort<\/span>=-createdAt<\/span>\n```\n\nData<\/span> displayed<\/span>:\n\n* Discussion<\/span> title<\/span>\n* Created<\/span> date<\/span>\n* Comment<\/span>\/reply<\/span> count<\/span> if<\/span> available<\/span>\n* Link<\/span> to<\/span> original<\/span> discussion<\/span> (external<\/span>)\n\nCaching<\/span>:\n\n* Cache<\/span> for<\/span> 15 minutes<\/span>\n* Failure<\/span> fallback<\/span> similar<\/span> to<\/span> blog<\/span>\n\n---\n\n## 13) Database<\/span> Schema<\/span> (SQLite<\/span>)\n\n### 13.1 Tables<\/span> (minimum<\/span>)\n\n**users<\/span>**\n\n* id<\/span> (pk<\/span>)\n* google_id<\/span> (unique<\/span>)\n* name<\/span>\n* email<\/span> (unique<\/span>)\n* avatar_url<\/span> (nullable<\/span>)\n* role<\/span> (enum<\/span>: user<\/span>\/hospital<\/span>\/doctor<\/span>)\n* is_blocked<\/span> (bool<\/span> default<\/span> false<\/span>)\n* last_login_at<\/span> (nullable<\/span>)\n* created_at<\/span>, updated_at<\/span>\n\n**admin_users<\/span>**\n\n* id<\/span>\n* username<\/span>\/email<\/span> (unique<\/span>)\n* password_hash<\/span>\n* is_active<\/span>\n* last_login_at<\/span>\n* created_at<\/span>, updated_at<\/span>\n\n**hospital_profiles<\/span>**\n\n* id<\/span>\n* user_id<\/span> (unique<\/span> FK<\/span> users<\/span>)\n* name<\/span>\n* name_slug<\/span>\n* slug_key<\/span> (unique<\/span>)\n* country_name<\/span>\n* country_slug<\/span>\n* city_display<\/span>\n* city_slug<\/span>\n* address<\/span>\n* description<\/span>\n* phone<\/span>\n* email<\/span> (nullable<\/span>)\n* website<\/span> (nullable<\/span>)\n* photo1_path<\/span> (nullable<\/span>)\n* photo2_path<\/span> (nullable<\/span>)\n* status<\/span> (draft<\/span>\/pending_review<\/span>\/published<\/span>)\n* is_featured<\/span> (bool<\/span>)\n* featured_rank<\/span> (int<\/span> nullable<\/span>)\n* profile_views<\/span> (int<\/span> default<\/span> 0)\n* created_at<\/span>, updated_at<\/span>\n\n**doctor_profiles<\/span>**\n\n* id<\/span>\n* user_id<\/span> (unique<\/span> FK<\/span> users<\/span>)\n* full_name<\/span>\n* name_slug<\/span>\n* slug_key<\/span> (unique<\/span>)\n* country_name<\/span>\n* country_slug<\/span>\n* city_display<\/span>\n* city_slug<\/span>\n* specialization<\/span>\n* experience_years<\/span>\n* description<\/span>\n* phone<\/span> (nullable<\/span>)\n* email<\/span> (nullable<\/span>)\n* photo1_path<\/span> (nullable<\/span>)\n* photo2_path<\/span> (nullable<\/span>)\n* status<\/span> (draft<\/span>\/pending_review<\/span>\/published<\/span>)\n* is_featured<\/span>\n* featured_rank<\/span>\n* profile_views<\/span>\n* created_at<\/span>, updated_at<\/span>\n\n**slots<\/span>**\n\n* id<\/span>\n* owner_type<\/span> (enum<\/span>: doctor<\/span>\/hospital<\/span>)\n* owner_id<\/span> (doctor_profiles<\/span>.id<\/span> or<\/span> hospital_profiles<\/span>.id<\/span>)\n* start_at_utc<\/span> (datetime<\/span>)\n* end_at_utc<\/span> (datetime<\/span>)\n* status<\/span> (available<\/span>\/booked<\/span>\/cancelled<\/span>)\n* created_at<\/span>, updated_at<\/span>\n\nIndexes<\/span>:\n\n* unique<\/span>(owner_type<\/span>, owner_id<\/span>, start_at_utc<\/span>, end_at_utc<\/span>)\n\n**bookings<\/span>**\n\n* id<\/span>\n* slot_id<\/span> (unique<\/span> FK<\/span> slots<\/span>)  \u2190 ensures<\/span> single<\/span> booking<\/span> per<\/span> slot<\/span>\n* user_id<\/span> (FK<\/span> users<\/span>)\n* owner_type<\/span> \/ owner_id<\/span> (redundant<\/span> for<\/span> quick<\/span> access<\/span>)\n* patient_name<\/span>\n* patient_phone<\/span>\n* patient_email<\/span>\n* notes<\/span> (nullable<\/span>)\n* status<\/span> (pending<\/span>\/confirmed<\/span>\/cancelled_by_user<\/span>\/cancelled_by_owner<\/span>\/completed<\/span>)\n* created_at<\/span>, updated_at<\/span>\n\n**medical_library_items<\/span>**\n\n* id<\/span>\n* type<\/span> (surgery<\/span>\/treatment<\/span>\/disease<\/span>\/procedure<\/span>)\n* title<\/span>\n* slug<\/span> (unique<\/span> within<\/span> type<\/span>)\n* content<\/span>\n* seo_title<\/span>, seo_description<\/span>, seo_keywords<\/span>\n* status<\/span> (draft<\/span>\/published<\/span>)\n* created_at<\/span>, updated_at<\/span>\n\n**pages<\/span>** (About<\/span>\/Contact<\/span> content<\/span> blocks<\/span>)\n\n* id<\/span>\n* key<\/span> (about<\/span>\/contact<\/span> etc<\/span>) unique<\/span>\n* title<\/span>\n* content<\/span>\n* seo_title<\/span>, seo_description<\/span>, seo_keywords<\/span>\n* updated_at<\/span>\n\n**contact_messages<\/span>**\n\n* id<\/span>\n* name<\/span>\n* email<\/span>\n* subject<\/span>\n* message<\/span>\n* created_at<\/span>\n\n---\n\n## 14) Validation<\/span> Rules<\/span> (Must<\/span>)\n\n### 14.1 Shared<\/span> validation<\/span>\n\n* All<\/span> slugs<\/span>: lowercase<\/span>, hyphen<\/span>-separated<\/span>, max<\/span> 120 chars<\/span>\n* City<\/span> normalization<\/span> required<\/span>\n* Country<\/span> required<\/span> from<\/span> configured<\/span> list<\/span>\n\n### 14.2 Hospital<\/span> profile<\/span> validation<\/span>\n\n* name<\/span>: required<\/span>, min<\/span> 3, max<\/span> 120\n* country_name<\/span>: required<\/span>\n* city_display<\/span>: required<\/span>, min<\/span> 2, max<\/span> 80\n* address<\/span>: required<\/span>, min<\/span> 5, max<\/span> 255\n* phone<\/span>: required<\/span>, min<\/span> 7, max<\/span> 20\n* email<\/span>: nullable<\/span>, valid<\/span> email<\/span>, max<\/span> 120\n* website<\/span>: nullable<\/span>, valid<\/span> URL<\/span>, max<\/span> 255\n* description<\/span>: required<\/span>, min<\/span> 20\n* photos<\/span>: max<\/span> 2\n\n  * types<\/span>: jpg<\/span>\/png<\/span>\/webp<\/span>\n  * max<\/span> size<\/span>: 2MB<\/span> each<\/span>\n\n### 14.3 Doctor<\/span> profile<\/span> validation<\/span>\n\n* full_name<\/span>: required<\/span>, min<\/span> 3, max<\/span> 120\n* specialization<\/span>: required<\/span>, max<\/span> 120\n* experience_years<\/span>: required<\/span> integer<\/span>, 0\u201380\n* country<\/span>\/city<\/span>: required<\/span>\n* description<\/span>: required<\/span>, min<\/span> 20\n* phone<\/span>\/email<\/span>\/photos<\/span> similar<\/span> rules<\/span>\n\n### 14.4 Slot<\/span> validation<\/span>\n\n* start_at<\/span> < end_at<\/span>\n* start_at<\/span> must<\/span> be<\/span> in<\/span> future<\/span> (for<\/span> creating<\/span>)\n* no<\/span> overlap<\/span> with<\/span> existing<\/span> slots<\/span> (same<\/span> owner<\/span>)\n* duration<\/span> 10\u2013240 minutes<\/span> (configurable<\/span>)\n\n### 14.5 Booking<\/span> validation<\/span>\n\n* must<\/span> be<\/span> logged<\/span> in<\/span> USER<\/span> role<\/span>\n* slot<\/span> must<\/span> be<\/span> `available<\/span>`\n* patient_name<\/span>: required<\/span>, 2\u2013120\n* patient_phone<\/span>: required<\/span>, 7\u201320\n* patient_email<\/span>: required<\/span>, valid<\/span> email<\/span>\n* notes<\/span>: optional<\/span> max<\/span> 500\n\n---\n\n## 15) Admin<\/span> Panel<\/span> Requirements<\/span>\n\n### Admin<\/span> modules<\/span>\n\n1. Dashboard<\/span> (counts<\/span>: users<\/span>, doctors<\/span>, hospitals<\/span>, bookings<\/span>)\n2. Users<\/span> management<\/span>\n\n   * list<\/span>\/filter<\/span> by<\/span> role<\/span>\/status<\/span>\n   * view<\/span> details<\/span>\n   * block<\/span>\/unblock<\/span>\n3. Doctors<\/span> management<\/span>\n\n   * approve<\/span>\/reject<\/span> profiles<\/span>\n   * set<\/span> featured<\/span> + featured_rank<\/span>\n4. Hospitals<\/span> management<\/span>\n\n   * approve<\/span>\/reject<\/span> profiles<\/span>\n   * set<\/span> featured<\/span> + featured_rank<\/span>\n5. Bookings<\/span> viewer<\/span>\n\n   * filter<\/span> by<\/span> status<\/span>\/date<\/span>\/owner<\/span>\n6. Medical<\/span> library<\/span> CMS<\/span>\n\n   * CRUD<\/span> items<\/span> for<\/span> surgery<\/span>\/treatments<\/span>\/diseases<\/span>\/procedures<\/span>\n7. Carousel<\/span> manager<\/span>\n\n   * CRUD<\/span> slides<\/span>\n\nAdmin<\/span> acceptance<\/span> criteria<\/span>:\n\n* Admin<\/span> pages<\/span> inaccessible<\/span> without<\/span> admin<\/span> login<\/span>\n* Admin<\/span> can<\/span> block<\/span> a<\/span> user<\/span> and<\/span> that<\/span> user<\/span> cannot<\/span> login<\/span> via<\/span> Google<\/span> afterward<\/span>\n\n---\n\n## 16) Performance<\/span> & Security<\/span> Requirements<\/span>\n\n### Performance<\/span>\n\n* Pagination<\/span> everywhere<\/span> (doctors<\/span>\/hospitals<\/span> lists<\/span>)\n* Cache<\/span> external<\/span> WP<\/span>\/Flarum<\/span> feeds<\/span>\n* Index<\/span> commonly<\/span> filtered<\/span> fields<\/span>:\n\n  * country_slug<\/span>, city_slug<\/span>, is_featured<\/span>, status<\/span>\n\n### Security<\/span>\n\n* CSRF<\/span> protection<\/span> enabled<\/span>\n* Rate<\/span> limiting<\/span>:\n\n  * login<\/span> attempts<\/span> (admin<\/span>)\n  * contact<\/span> form<\/span> submissions<\/span>\n  * booking<\/span> attempts<\/span>\n* File<\/span> upload<\/span> security<\/span>:\n\n  * restrict<\/span> MIME<\/span> + extension<\/span>\n  * store<\/span> outside<\/span> web<\/span> root<\/span> via<\/span> Laravel<\/span> storage<\/span>\n* Authorization<\/span> checks<\/span>:\n\n  * hospital<\/span> cannot<\/span> edit<\/span> doctor<\/span> profile<\/span> and<\/span> vice<\/span> versa<\/span>\n  * owners<\/span> can<\/span> only<\/span> manage<\/span> their<\/span> own<\/span> slots<\/span>\/bookings<\/span>\n\n---\n\n## 17) Deployment<\/span> & Environment<\/span>\n\n### No<\/span>-public<\/span>-directory<\/span> mode<\/span> acceptance<\/span> checklist<\/span>\n\n* Works<\/span> from<\/span> `htdocs<\/span>\/bestcanow<\/span>`\n* No<\/span> vhost<\/span> needed<\/span>\n* Root<\/span> routing<\/span> works<\/span>\n* Assets<\/span> load<\/span>\n\n### Environment<\/span> config<\/span>\n\n* `.env<\/span>` drives<\/span> all<\/span> secrets<\/span> (Google<\/span> OAuth<\/span>, mail<\/span> settings<\/span>, cache<\/span> TTLs<\/span>)\n\n---\n\n## 18) Testing<\/span> & Acceptance<\/span> Criteria<\/span> (Must<\/span>)\n\n### Automated<\/span> tests<\/span> (minimum<\/span>)\n\n* Slug<\/span> generation<\/span> tests<\/span> (city<\/span> normalization<\/span>, uniqueness<\/span>)\n* Booking<\/span> conflict<\/span> test<\/span> (double<\/span>-book<\/span> prevention<\/span>)\n* Role<\/span> authorization<\/span> tests<\/span> (hospital<\/span> cannot<\/span> book<\/span>, user<\/span> cannot<\/span> create<\/span> slots<\/span>)\n* Admin<\/span> block<\/span>\/unblock<\/span> test<\/span>\n\n### Manual<\/span> acceptance<\/span> tests<\/span>\n\n1. Google<\/span> login<\/span> creates<\/span> user<\/span> and<\/span> routes<\/span> to<\/span> correct<\/span> dashboard<\/span>\n2. Hospital<\/span> creates<\/span> profile<\/span> \u2192 submits<\/span> for<\/span> review<\/span> \u2192 admin<\/span> publishes<\/span> \u2192 appears<\/span> in<\/span> listings<\/span>\n3. Doctor<\/span> creates<\/span> slots<\/span> \u2192 user<\/span> books<\/span> slot<\/span> \u2192 doctor<\/span> confirms<\/span> \u2192 status<\/span> updates<\/span>\n4. `\/doctors<\/span>\/{country<\/span>}\/{city<\/span>}\/{name<\/span>}` works<\/span> and<\/span> SEO<\/span> meta<\/span> present<\/span>\n5. `\/top<\/span>-hospitals<\/span>` shows<\/span> all<\/span> countries<\/span>\n6. `\/top<\/span>-doctors<\/span>\/{country<\/span>}` shows<\/span> 45 entries<\/span> in<\/span> 3x15<\/span> layout<\/span>\n7. Home<\/span> shows<\/span> WP<\/span> + Flarum<\/span> items<\/span> (or<\/span> graceful<\/span> fallback<\/span>)\n\n---\n\n## 19) Recommended<\/span> \u201cNice<\/span>-to<\/span>-have<\/span>\u201d (Optional<\/span>, not<\/span> required<\/span> for<\/span> MVP<\/span>)\n\n* Reviews<\/span> & ratings<\/span>\n* Verified<\/span> badge<\/span> for<\/span> doctors<\/span>\/hospitals<\/span>\n* Multi<\/span>-language<\/span> SEO<\/span> fields<\/span>\n* Advanced<\/span> search<\/span> (full<\/span>-text<\/span> index<\/span>)\n* Map<\/span> view<\/span> (lat<\/span>\/lng<\/span>)\n\n---\n\n### If<\/span> you<\/span> want<\/span>, I<\/span> can<\/span> also<\/span> produce<\/span> a<\/span> **single<\/span> \u201cCodex<\/span> Master<\/span> Prompt<\/span>\u201d** version<\/span> of<\/span> the<\/span> above<\/span> (condensed<\/span>, no<\/span> repetition<\/span>, written<\/span> like<\/span> a<\/span> build<\/span> instruction<\/span> to<\/span> generate<\/span> the<\/span> full<\/span> Laravel<\/span> project<\/span> structure<\/span> + migrations<\/span> + controllers<\/span> + views<\/span>).\n<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1044","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts\/1044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/comments?post=1044"}],"version-history":[{"count":1,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts\/1044\/revisions"}],"predecessor-version":[{"id":1045,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/posts\/1044\/revisions\/1045"}],"wp:attachment":[{"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/media?parent=1044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/categories?post=1044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rajeshkumar.xyz\/blog\/wp-json\/wp\/v2\/tags?post=1044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}