ENTrack-MICS
MY DASHBOARD
Your numbers and what needs your attention right now.
⚡ Needs your attention
🕐 Attendance — Today
Open full log →📷 LIVE ALL DEVICE MONITORING KPI GRID
🔌 LIVE ALL SWITCH MONITORING KPI GRID
🖥️ LIVE ALL VMD MONITORING KPI GRID
DEVICE STATUS BREAKDOWN
% of Excl. Maintenance (5658 devices = 100%)OVERALL HEALTH (EXCL. MAINTENANCE)
DEVICE STATUS TREND
Whether things are trending better or worse over time, not just where things stand right now. Only shows days from when this feature was added onward.
LIVE DEVICE MONITORING DATA
| # | IP Address⇅ | Monitor / Device Name⇅ | AMC ID⇅ | Status⇅ | Category / Ticket | Site Type⇅ | Zone⇅ | Action |
|---|---|---|---|---|---|---|---|---|
| Loading device records from MongoDB... | ||||||||
👋 Welcome Back, Field Engineer
Smart City Ahmedabad Development Limited (SCADL) • Material Operations Portal
🖥️ LIVE ALL VMD MONITORING KPI GRID
📋 VMD Ticket Records
| # | Ticket ID | Requestor Email | Subject | Description | Status | Created | Closed | Down Reason |
|---|---|---|---|---|---|---|---|---|
| Loading VMD ticket records... | ||||||||
⚠️ MY PENDING ACTIONS — Reconciliation Needed
These have been dispatched to you — close the loop with Consumed / Return / Multiple Sites so Inventory's records stay accurate.
🎉 RECENTLY APPROVED BY MANAGER
Great news — these requests were just approved and are moving toward dispatch.
📦 YOUR ACTIVE REQUESTS — LIVE STATUS
Track each request's journey, just like an order tracker.
New Material Requirement Request
Look up a site by AMC ID or Device IP, then tag the materials each device needs.
Manual Material Requirement Request
For a site the Auto Fetch search can't find — enter every detail by hand instead.
⚡ Quick Request
No ticket needed — just who it's for and what's needed.
📋 Material Request History
| AMC ID⇅ | Site Name⇅ | Device IP⇅ | Zone⇅ | Material Name⇅ | Qty & Unit | Requested By | Total Site | Used Qty | Returned Qty | Raw Material Qty | Status⇅ | Reconciliation | Requested Date & Time⇅ | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading material requests... | ||||||||||||||
🔄 INVENTORY RETURN/COLLECT — SITE RAW MATERIALS
Raw materials submitted/returned by Field Engineers & VMD Engineers and collected by Inventory Executives, within your assigned Zone (Your Zone)
| Collection ID | Return Date⇅ | Site Name⇅ | Zone | Field Engineer⇅ | Returned Materials & Condition | Photo | Received By⇅ | Action |
|---|---|---|---|---|---|---|---|---|
| Loading zone return records... | ||||||||
OPERATOR PANEL - FIELD ENGINEER REQUEST VERIFICATION QUEUE
Field Engineer requests land here first. Verify the details and forward to Manager — forwarding is blocked automatically if the material isn't currently in stock. Records stay visible after you act on them, showing their live status further down the pipeline.
| AMC ID⇅ | Site Name⇅ | Device IP⇅ | Zone⇅ | Material Requested⇅ | Qty & Unit | Requested By (Field Engineer) | Total Site | Used Qty | Returned Qty | Raw Material Qty | Status⇅ | Requested Date & Time⇅ | Action | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading verification queue... | ||||||||||||||
📊 Operator Verification Analytics
Your own verification work — pending/forwarded/rejected, broken down by zone, Field Engineer, or material.
| Zone⇅ | Total⇅ | Pending Verification⇅ | Forwarded⇅ | Rejected⇅ | Forward Rate⇅ |
|---|---|---|---|---|---|
| Loading operator analytics... | |||||
📊 MATERIAL CONSUMPTION ANALYTICS — DISPATCH HISTORY
Material Consumption Breakdown
🔄 RAW MATERIAL RETURNED — FIELD COLLECTION HISTORY
Material Return Breakdown
MATERIAL TRACKING - STOCK DISPATCH HISTORY
Showing latest 50 dispatched material records. Search or filter (Zone / Category / Material / Date range) to see the complete matching dispatch history — this doubles as the downloadable material consumption report.
| AMC ID⇅ | Site Name⇅ | Device IP⇅ | Zone⇅ | Material Name⇅ | Qty & Unit | Dispatched By⇅ | Dispatched On⇅ |
|---|---|---|---|---|---|---|---|
| Loading material dispatch history... | |||||||
MANAGER PANEL — FINAL REVIEW & SIGN-OFF
| AMC ID⇅ | Site Name⇅ | Zone⇅ | Material Requested⇅ | Qty & Unit⇅ | Requested By⇅ | Total Site | Used Qty | Returned Qty | Raw Material Qty | Status⇅ | Requested Date & Time⇅ | Actions / Remarks | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading requests pending manager approval... | |||||||||||||
↩️ FIELD RETURNS — AWAITING FINAL APPROVAL
Every field-return line the Inventory Executive has reviewed (Accepted / Adjusted / Not Received). Approve to finalise, Reject to flag (no stock reversal), or Send Back to the Inventory Executive to redo.
📥 INVENTORY COLLECT — AWAITING FINAL APPROVAL
Raw-material return items the Inventory Executive has verified into stock.
🧪 QUARANTINE — AWAITING FINAL APPROVAL
Lab-inspection decisions (Passed to stock / Scrapped) the Inventory Executive has made.
📊 Approval Analytics
Approve/reject rates broken down by zone, operator, or material.
| Zone⇅ | Total⇅ | Approved⇅ | Rejected⇅ | Pending⇅ | Dispatched⇅ | Approval Rate⇅ |
|---|---|---|---|---|---|---|
| Loading approval analytics... | ||||||
⏱️ Turnaround Time Analytics
Average time from request submission to dispatch — broken down by zone, operator, or material.
| Zone⇅ | Requests Dispatched⇅ | Avg. Turnaround⇅ | Fastest⇅ | Slowest⇅ |
|---|---|---|---|---|
| Loading turnaround analytics... | ||||
🛠️ Device MTTR (Mean Time To Repair)
Average time a device stays Down before coming back Up — grouped by zone or by down category, so you can spot which zone/category causes the longest outages.
| Zone⇅ | Downtime Episodes⇅ | Avg. MTTR⇅ |
|---|---|---|
| Loading MTTR analytics... | ||
NOTIFICATION - DISPATCH & WAREHOUSE BUCKET
| AMC ID⇅ | Site Location⇅ | Device IP⇅ | Zone⇅ | Requested Date & Time⇅ | Material Item⇅ | Approved Qty⇅ | Total Site | Used Qty | Returned Qty | Raw Material Qty | Workflow Status⇅ | Photo | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading manager approved requests... | |||||||||||||
📊 MATERIAL CONSUMPTION ANALYTICS & USAGE TRENDS
Material Consumption by Category
Category Consumption Trend Over Time
🛒 SUGGESTED REORDER LIST
| Material Name | Category | Current Qty | Threshold | Suggested Reorder Qty |
|---|---|---|---|---|
| Loading… | ||||
LIVE MATERIAL STOCK INVENTORY & AVAILABILITY
| Item Code⇅ | Material Name⇅ | Category⇅ | Series⇅ | Series Types⇅ | Available Stock⇅ | Unit⇅ | Last Restocked Date (Added)⇅ | Last Out Qty & Date (Issued) | Stock Status⇅ | Actions | Input Action |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading stock inventory... | |||||||||||
🆕 NEW STOCK — LAST RESTOCK PER MATERIAL
Shows only the most recent restock event for each material — quantity added and when. Gets replaced the next time that material is restocked. (Overall running total stays in "Current Stock" tab.)
| Item Code⇅ | Material Name⇅ | Category⇅ | Qty Added (Last Restock)⇅ | Date Added⇅ | Current Overall Stock⇅ |
|---|---|---|---|---|---|
| Loading new stock... | |||||
📥 RAW MATERIAL INVENTORY COLLECT RECORDS
Received & cataloged raw materials returned from field sites by Field Engineers
| Collection ID | Date & Time⇅ | Site Name⇅ | Zone⇅ | Field Engineer⇅ | Collected Materials (Qty, Unit & Condition) | Photo | Logged By⇅ | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading collected material records... | ||||||||
🛠️ QUARANTINE & REPAIR STOCK BUCKET
Faulty and repairable raw materials held for lab inspection. Does NOT inflate usable stock until passed.
| Quarantine ID | Date Logged⇅ | Location & Zone⇅ | Field Engineer⇅ | Material & Quantity | Fault Reason / Condition | Status⇅ | Lab Action |
|---|---|---|---|---|---|---|---|
| Loading quarantine stock items... | |||||||
📊 RETURN ANALYTICS & MATERIAL DAMAGE RATE DASHBOARD
Visual insights on raw material returns, condition ratios, and site-wise damage percentages.
🍩 Material Condition Breakdown Ratio
📊 Top 10 Returned Raw Materials (Volume)
📍 Site-Wise Damage & Faulty Rate % (High-Damage Risk Sites)
| Site Name⇅ | Total Return Items⇅ | Damaged / Faulty Items⇅ | Damage Rate %⇅ | Risk Badge |
|---|---|---|---|---|
| Loading site damage analytics... | ||||
↩️ FIELD RETURN VERIFICATION
Field Engineers submit a Return here after their dispatched material is used — review each one below: Accept as submitted, accept with an adjusted quantity, or mark it Not Received.
| Type⇅ | AMC ID⇅ | Site Name⇅ | Material⇅ | Given from Stock⇅ | Qty Submitted⇅ | Remark | Submitted By⇅ | Submitted At⇅ | Action |
|---|---|---|---|---|---|---|---|---|---|
| Loading pending field returns... | |||||||||
| Type⇅ | AMC ID⇅ | Site Name⇅ | Material⇅ | Given from Stock⇅ | Qty Submitted | Qty Accepted | Outcome⇅ | Remark | Reviewed By⇅ | Reviewed At⇅ | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading field return history... | |||||||||||
📑 REPORTS
Zone-wise and material-wise reports for a chosen date range — preview the chart, then download as a 2-sheet Excel (Summary + Details).
🗺️ Zone-Wise Breakdown
📊 Material-Wise Breakdown (Top 15)
📋 Detail Records
| Choose filters above to preview a report. |
📒 INVENTORY IN/OUT — STOCK MOVEMENT LEDGER
Every stock quantity change — restocks, manual adjustments, and dispatches — in one running record, like a bank statement.
| Date & Time | Item Code | Material | Category | Change | Balance After | Reason | Performed By | 🧾 Invoice | Action |
|---|---|---|---|---|---|---|---|---|---|
| Loading inventory ledger... | |||||||||
👷 ALL FIELD, VMD & PROJECT ENGINEERS
Field Engineers assigned per zone are offered to the Inventory Executive when dispatching material for a request in that zone. VMD Engineers are shown here too (managed under Admin → User Management).
| Engineer Name⇅ | Zone⇅ | Username⇅ | Password | Mobile No.⇅ | Vendor Name⇅ | Joining Date⇅ | Action |
|---|---|---|---|---|---|---|---|
| Loading field engineers... | |||||||
🗄️ MONGO DB DATABASE ADMINISTRATION & INSPECTOR
Live MongoDB Database: materials_management_ccc
📤 Manual Dashboard Update
Normally the dashboard updates by watching for these files over email. Admin can instead upload them here to force an immediate recompute — drag & drop or click to browse.
⚙️ Email Watcher Settings & System Health
Tune the background scan without touching code, and check at a glance whether it's actually keeping the dashboard fresh.
MONGODB TABLES / COLLECTIONS
Click any collection grid card to open complete details & record data viewerdb_export/ folder (not your browser Downloads folder)
— copy the whole project folder to another system to carry this data with it.🗑️ RECYCLE BIN
Material requests deleted by Admin — kept indefinitely (nothing is ever permanently removed). Restore any entry back into its original panel.| AMC ID⇅ | Site Name⇅ | Material⇅ | Qty⇅ | Status at Deletion⇅ | Delete Reason | Deleted By⇅ | Deleted At⇅ | Action |
|---|---|---|---|---|---|---|---|---|
| Loading Recycle Bin... | ||||||||
⚙️ MATERIAL REQUEST POLICY
On by default — Field Engineers can submit a material request even for a device already reporting Up (e.g. preventive/ spare-part stocking). Turn this off if requests should be blocked for online devices instead.
ADMIN SETTING - ROLE PERMISSIONS & ACCESS CONTROL
Toggle which dashboard panels each system role is permitted to view:
🔌 DASHBOARD SWITCH KPI GRID ROLE VISIBILITY
Admin decides which user roles can view the dedicated Live All Switch Monitoring KPI Grid on their main dashboard.
🖥️ DASHBOARD VMD KPI GRID ROLE VISIBILITY
Admin decides which user roles can view the dedicated Live All VMD Monitoring KPI Grid on their main dashboard.
👤 INDIVIDUAL USER PERMISSIONS & ACCESS CONTROL
Manage dashboard panel access permissions individually for each user account.
👁️ EXECUTIVE VIEWER — ACTION PERMISSIONS
| Executive Viewer Account | ➕✏️ Add / Edit | 🗑️ Delete | ⬇️ Download / Export | |
|---|---|---|---|---|
| Loading Executive Viewer accounts... | ||||
🔐 USER ACCOUNT CREDENTIALS & PASSWORD MANAGEMENT
| Username⇅ | User Full Name⇅ | Assigned Role⇅ | Department⇅ | Stored Password | Account Access⇅ | Action |
|---|---|---|---|---|---|---|
| Loading user account credentials... | ||||||
🕵️ ADMIN AUDIT LOG
| Date & Time⇅ | Action⇅ | Target⇅ | Performed By⇅ | Details |
|---|---|---|---|---|
| Loading audit log... | ||||
🕐 Attendance Sign In
Pick Present at the start of your day (records your location), or mark yourself On Leave.
iPhone: also turn on Settings ▸ Privacy & Security ▸ Location Services and allow location for Safari/Chrome — choosing Present will show the exact steps if it's off.
📊 My Monthly Summary
📝 Attendance Corrections
⏱️ Overtime (OT)
📅 My Attendance History
Last 90 days · newest first📝 Attendance Corrections
Engineers asking to be marked present for a day they missed on the app. Approve → a manual attendance row is written for that date.
| Engineer | Zone | For Date | Reason | Requested | Action |
|---|
⏱️ Overtime (OT) Requests
Engineers requesting a fixed 4h / 8h OT block. Approve → the hours attach to that day's attendance and count towards their total.
| Engineer | Zone | For Date | OT | Reason | Requested | Action |
|---|
📧 Daily Attendance Email Report
How many engineers were Present / Absent today, sent automatically every day from —.
🕐 Attendance Sign-In Log
Every Field / VMD Engineer attendance toggle — name, zone, phone, enable / disable times, and the GPS location. Click a card to filter by zone; click a row for the full day detail. Records are kept 90 days.
| Date & Time | User | Role | Zone | Mobile Device | Location Name | Lat / Long | Map | Action |
|---|
| Engineer Name | Role | Zone | Status | Action |
|---|