# CineFlow Pro: Ultimate Production OS

## 🎨 Design System & Visual Identity
*   **Theme:** "Cinema Dark" (Dark mode enabled).
*   **Icon Set:** Uniform minimalist style (e.g., `Remix Icon` or `Simple Icons` style).
    *   *Projects:* 🎬
    *   *CRM:* 🤝
    *   *Finance:* 💳
    *   *Tasks:* ✅
    *   *Pre-Production:* 📋
    *   *Versions:* 📼
*   **Color Coding:**
    *   *Green:* Completed / Paid / Delivered.
    *   *Blue:* In Progress / Filming.
    *   *Orange:* Review / Pending Payment.
    *   *Red:* Overdue / Scope Creep / Lost Lead.

---

## 1. Mission Control Dashboard
The central nervous system of your business. This dashboard aggregates CRM health, production status, and financial metrics in a single glance.

**Layout Configuration:**
*   **Row 1: Business Health**
    *   *Left:* **Sales Pipeline** (Board view from CRM DB, grouped by Status).
    *   *Center:* **Cash Flow Forecast** (Calendar view from Finance DB, filtered by "Invoice Due Date").
    *   *Right:* **Scope Creep Alert** (List view from Projects DB, filtered where `Revisions Remaining` ≤ 0).
*   **Row 2: Active Production**
    *   *Main:* **Master Production Board** (Board view from Projects DB, grouped by Status).
*   **Row 3: Task Execution**
    *   *Bottom:* **Action Items** (List view from Tasks DB, grouped by Assignee, filtered to show "To Do" and "In Progress").

---

## 2. Module: Sales & CRM (Leads)
Captures opportunities before they become projects. Ensures no revenue is lost in the DMs.

**Database Schema:**
| Property Name | Type | Description |
| :--- | :--- | :--- |
| **Company Name** | Title | Lead Name. |
| **Contact Person** | Text | Primary point of contact. |
| **Status** | Select | `New Lead`, `Meeting Scheduled`, `Proposal Sent`, `Contract Sent`, `Won`, `Lost`. |
| **Project Value** | Number | Estimated quote value. |
| **Source** | Select | `Referral`, `Instagram`, `Cold Outreach`, `Repeat Client`. |
| **Linked Project** | Relation | Connects to *Projects Database*. |

**Views:**
*   **Sales Pipeline:** Kanban Board grouped by `Status`.
*   **Won Deals:** List view filtered by `Status` is "Won".

**Automation (Template Button):**
*   *Button Name:* "Send Proposal"
*   *Action:* Creates a new page in the "Projects Database" with the Company Name pre-filled and sets the Project Status to "Pre-Production".

---

## 3. Module: Project Hub
The core database that connects CRM, Finance, and Production.

**Database Schema:**
| Property Name | Type | Options/Formula |
| :--- | :--- | :--- |
| **Project Name** | Title | - |
| **Client** | Relation | Links to *CRM Database*. |
| **Status** | Select | `Pre-Production`, `Filming`, `Editing`, `Color`, `Client Review`, `Final Delivery`, `On Hold`. |
| **Budget** | Number | Total contract value. |
| **Total Invoiced** | Rollup | Sum of `Amount` from *Finance Database* (Filter: Type=Invoice). |
| **Total Expenses** | Rollup | Sum of `Amount` from *Finance Database* (Filter: Type=Expense). |
| **Net Profit** | Formula | `prop("Total Invoiced") - prop("Total Expenses")` |
| **Revisions Allowed** | Number | Contract limit (e.g., 3). |
| **Revisions Used** | Rollup | Count of pages in *Version History Database*. |
| **Revisions Remaining** | Formula | `prop("Revisions Allowed") - prop("Revisions Used")` |
| **Deadline** | Date | Final delivery date. |

**Views:**
*   **Active Projects:** Board grouped by `Status`.
*   **Profitability:** Table sorted by `Net Profit` (High to Low).

---

## 4. Module: Pre-Production Studio
Dedicated space for logistics, ensuring shoots happen without a hitch.

### A. Shot List Database
| Property Name | Type | Description |
| :--- | :--- | :--- |
| **Scene / Shot** | Title | e.g., "1A - Wide Master". |
| **Project** | Relation | Links to *Project Hub*. |
| **Shot Type** | Select | `Wide`, `Medium`, `Close-Up`, `Drone`, `B-Roll`. |
| **Camera Movement** | Select | `Static`, `Pan`, `Tilt`, `Dolly`, `Handheld`. |
| **Audio** | Select | `Boom`, `Lav`, `MOS` (No sound). |
| **Notes** | Text | Specific direction for DP. |

### B. Call Sheet & Crew Database
| Property Name | Type | Description |
| :--- | :--- | :--- |
| **Role** | Select | `Director`, `DP`, `Sound`, `Talent`, `PA`. |
| **Name** | Text | Crew member name. |
| **Call Time** | Date | When they arrive on set. |
| **Project** | Relation | Links to *Project Hub*. |
| **Status** | Select | `Booked`, `Confirmed`, `Paid`. |

### C. Equipment Checklist
*   *Template Button:* "New Shoot Day"
*   *Pre-filled Tasks:* "Charge Batteries", "Format SD Cards", "Pack Lighting Kit", "Test Mics".

---

## 5. Module: Production Pipeline (Tasks)
Granular task management for the post-production workflow.

**Database Schema:**
| Property Name | Type | Options |
| :--- | :--- | :--- |
| **Task Name** | Title | - |
| **Project** | Relation | Links to *Project Hub*. |
| **Assignee** | Person | Editor, Colorist, PM. |
| **Status** | Select | `To Do`, `In Progress`, `Awaiting Assets`, `Review`, `Done`. |
| **Priority** | Select | `High`, `Medium`, `Low`. |
| **Due Date** | Date | - |

**Views:**
*   **My Tasks:** Board grouped by `Assignee`.
*   **By Project:** List grouped by `Project`.

**Automation (Template Buttons):**
1.  **"New Commercial Edit"**
    *   *Creates:* "Ingest Footage", "Sync Audio", "Assembly Cut", "Rough Cut v1", "Client Review", "Color Grade", "Sound Mix", "Final Export".
2.  **"New Social Cut"**
    *   *Creates:* "Select Best Moments", "Add Captions", "Resize for 9:16", "Export".

---

## 6. Module: Post-Production & Versions
Tracks every iteration of the video to manage scope creep and client feedback.

**Database Schema:**
| Property Name | Type | Description |
| :--- | :--- | :--- |
| **Version Name** | Title | e.g., "v1.0", "v1.1", "Final". |
| **Project** | Relation | Links to *Project Hub*. |
| **Status** | Select | `Internal Draft`, `Sent for Review`, `Approved`, `Changes Requested`. |
| **Video Link** | URL | Frame.io, Vimeo, or Drive link. |
| **Feedback Summary** | Text | Client notes. |
| **Date Sent** | Date | Timestamp of delivery. |

**Notion AI Integration:**
*   *Prompt:* "Summarize the following client feedback into actionable bullet points for the editor:" [Paste Feedback Here]

---

## 7. Module: Finance & P&L
Complete financial tracking to ensure profitability.

**Database Schema:**
| Property Name | Type | Options |
| :--- | :--- | :--- |
| **Entry Title** | Title | e.g., "Invoice #001 - Deposit", "Catering". |
| **Project** | Relation | Links to *Project Hub*. |
| **Type** | Select | `Invoice` (Money In), `Expense` (Money Out). |
| **Category** | Select | `Equipment`, `Labor`, `Location`, `Software`, `Travel`. |
| **Amount** | Number | Value. |
| **Status** | Select | `Draft`, `Sent`, `Paid`, `Overdue`. |
| **Date** | Date | Transaction date. |

**Views:**
*   **Invoices:** Gallery view filtered by `Type` is "Invoice".
*   **Expenses:** List view filtered by `Type` is "Expense".
*   **P&L Report:** Table view grouped by `Project`, showing Rollups of Total Income vs. Total Expense.

---

## 8. Setup & Construction Guide

Follow these steps to build the system architecture.

### Phase 1: Core Databases
1.  **Create 6 Databases:** CRM, Projects, Tasks, Versions, Finance, Pre-Production (Shot List).
2.  **Establish Relations:**
    *   *CRM* ↔ *Projects* (One-to-One).
    *   *Projects* ↔ *Tasks* (One-to-Many).
    *   *Projects* ↔ *Versions* (One-to-Many).
    *   *Projects* ↔ *Finance* (One-to-Many).
    *   *Projects* ↔ *Pre-Production* (One-to-Many).

### Phase 2: Financial Formulas (In Projects DB)
1.  Create Property `Total Invoiced` (Rollup) → Relation: `Finance` → Property: `Amount` → Filter: `Type` = "Invoice".
2.  Create Property `Total Expenses` (Rollup) → Relation: `Finance` → Property: `Amount` → Filter: `Type` = "Expense".
3.  Create Property `Net Profit` (Formula) → `prop("Total Invoiced") - prop("Total Expenses")`.

### Phase 3: Revision Logic (In Projects DB)
1.  Create Property `Revisions Used` (Rollup) → Relation: `Versions` → Property: `Title` (Calculate: Count).
2.  Create Property `Revisions Remaining` (Formula) → `prop("Revisions Allowed") - prop("Revisions Used")`.

### Phase 4: Automation Setup
1.  Open the **Tasks Database**.
2.  Click "New" → "Template Button".
3.  Name it "Standard Commercial Workflow".
4.  Add the tasks listed in Section 5.
5.  Repeat for **Pre-Production** to generate a standard Shot List template.

### Phase 5: Dashboard Assembly
1.  Create a new Page titled "Mission Control".
2.  Use "Linked Views" to pull in the specific views configured in Section 1.
3.  Toggle "Show Icon" and "Show Cover" for a premium look.