Sigma Inspection and Testing Pvt Ltd
Plot No.1607. Phase I & II, Lions School Road, GIDC, Naroda -
Dashboard
Live summary from the existing production, employee, and master data.
Production by Type of Job - OK / Reshoot Sq.In
Monthly Production - OK / Reshoot Sq.In
Employee Productivity - OK / Reshoot Sq.In
Pending vs Completed Jobs
Company Production Report
Employee Production Report
| Employees Name | Total Sq.In Film Processed | Total OK Sq.In | Total Reshoot Sq.In | Reshoot % |
|---|
Darkroom Report
| Darkroom Technician Name | Total Sq.In Film Processed | Total OK Sq.In | Total Reshoot Sq.In | Reshoot % |
|---|
Masters
Dropdown Master Form
Values saved here are shared for all users through MySQL.
Masters
Employee Master
Create, edit, search, view, and deactivate employee details. Active employees appear in Production Entry role dropdowns.
| Employee ID | Name | Designation | Department | Mobile | Status | Documents | Action |
|---|
Masters
Film Size Form
| Film Size | Length | Width | Sq.In | Date |
|---|
Masters
Client Master
Maintain client contact and address details for office records.
| Client Name | Contact Person | Mobile | City | Status | Action |
|---|
Instrument Calibration Management
Maintain instrument calibration due dates and daily email reminders.
| Instrument ID | Name | Serial No. | Location | Last Calibration | Next Due | Status | Responsible | Action |
|---|
Admin Email Settings
For automatic daily reminders, schedule api/calibration_reminder.php in GoDaddy Cron Job or Windows Task Scheduler.
Email Reminder Log
| Instrument ID | Due Date | Reminder Type | Recipient | Sent Date & Time | Status | Error Details |
|---|
Calibration History
| Instrument ID | Previous Last Date | Previous Due Date | New Last Date | New Due Date | Updated By | Created |
|---|
Production Data Entry Form
Search Production Entry
Search or filter saved Production IDs. Click any ID to open it in Production Entry.
Month Wise Production Report
Shooting total includes accepted and reshoot production. Reshoot is calculated from Production Remark.
| Month | Shooting Sq.In | Reshoot Sq.In | Reshoot % | Entries |
|---|
Employee Wise Production Report
| Employee Name | Total Sq.In | Reshoot Sq.In | Reshoot % | Entries |
|---|
Print Report
Print-ready production reports using shared database data.
Month Wise Employee Production Report
Month Wise Employee Production Report
Production and reshoot percentage for all employees.
| Employee Name | Total Production Sq.In | OK Sq.In | Reshoot Sq.In | Reshoot % | Entries |
|---|
Employee Wise Graph Report
Employee Wise Graph Report
Employee-wise total film Sq.In, total reshoot Sq.In, and reshoot percentage.
Graph
| Employee Name | Total Film Sq.In | Total Reshoot Sq.In | Reshoot Percentage |
|---|
Employee Individual Print Report
Employee Individual Production Report
Date-wise merged production and reshoot percentage.
| Date | Sq.In | OK Sq.In | Reshoot Sq.In | Reshoot % |
|---|
Year Wise Monthly Test Report
Year Wise Monthly Test Report
Total production and reshoot percentage without employee breakdown.
| Year | Month | Total Sq.In | OK Sq.In | Total Reshoot Sq.In | Reshoot % | Entries |
|---|
Type of Job Wise Monthly Print Report
Type of Job wise Monthly Production Report
Type of Job Wise Monthly Production Report
Month-wise production and reshoot percentage grouped by type of job for all employees.
| Year | Month | Type of Job | Total Sq.In | Total Reshoot Sq.In | Reshoot % | Entries |
|---|
Commercial and Inventory
Enquiry
| No. | Date | Customer | Service | Type | Location | Expected | Status | Action |
|---|
Quotation
| No. | Date | Enquiry | Customer | Amount | Tax | Total | Status | Action |
|---|
Customer PO
| PO No. | Date | Quotation | Customer | Value | Delivery | Status | Action |
|---|
Material Inventory Tracking
Inventory Dashboard
Site Wise Inventory
Equipment Distribution
Monthly Issue vs Return
Category Wise and Location Wise
Calibration Schedule
Maintenance Trend
Stock Movement by Site
Recent Transactions
| Date | No. | Type | From | To | Material | Qty | Unit | Status |
|---|
Site Master
| Site / Location | Materials | Available Qty | In Transit | Low Stock Items | Status |
|---|
Old Manual Stock Entry - Hidden
Return Material Register
| Date | Return No. | Material | Returned | Damaged | Balance | Employee | Remarks |
|---|
Stock Ledger
| Date | Voucher | Type | Item | Opening | Received | Issued | Returned | Damaged | Adjust | Closing | Location | Employee |
|---|
Batch / Serial / Calibration Tracking
| Material | Category | Batch / Serial / IQI | Packet Sr.No | Receipt Date | Location | Status |
|---|
Testing Location Wise Consumption
| Testing Location | Customer | Project / Site | Material | Issued Qty | Unit | Employee |
|---|
Material Request & Approval
| Request No. | Date | From | To | Material | Requested | Approved | Unit | Status | Action |
|---|
Material Request Approval
| Request No. | Date | From | To | Material | Requested | Approved | Unit | Status | Action |
|---|
Location Low Stock Setup
| Location | Material | Minimum | Available | Unit | Status | Remarks | Action |
|---|
Material Movement Entry
Pending Receipt
Stock at Each Site
| Location | Material | Category | Batch | Available | Transit | Unit | Packets | Films | Sq.In | Responsible |
|---|
Current Location
| Material | Category | Current Location | Available | In Transit | Unit | Last Movement |
|---|
Movement History
| No. | Request | Date | Type | From | To | Material | Qty | Received | Unit | Status | Challan | Action |
|---|
Audit Trail
| Date Time | Transaction | Action | Previous | New | Reason | User |
|---|
Movement Report
Inventory Movement Report
Date-wise, location-wise and item-wise material movement.
| Date | No. | Type | From | To | Material | Qty | Received | Unit | Status |
|---|
Stock Transfer Challan / Gate Pass
Inventory material movement document.
| Material | Batch | Quantity | Unit | From | To |
|---|
-
-
Inventory Reports
| Report | Total Records | Total Quantity | Important Count |
|---|
Purchase
| No. | Date | Supplier | Item | Qty | Rate | Total | Status | Action |
|---|
Invoice
Payment Tracking
Customer Outstanding
ISO 17025 Quality System
Document Control
| Document No. | Title | Type | Revision | Status | Review Due | File | Action |
|---|
NCR
| NCR No. | Date | Source | Department | Responsible | Target | Status | Attachment | Action |
|---|
Corrective Action
| Action No. | Date | Source | Related NCR | Responsible | Target | Status | Attachment | Action |
|---|
Risk Register
| Risk ID | Date | Department | Source | Score | Level | Responsible | Status | Review | Attachment | Action |
|---|
Internal Audit
| Audit No. | Date | Area | Type | Auditor | Responsible | Status | Attachment | Action |
|---|
MRM
| MRM No. | Date | Title | Chaired By | Responsible | Target | Status | Attachment | Action |
|---|
Customer Complaint
| Complaint No. | Date | Customer | Source | Responsible | Target | Status | Attachment | Action |
|---|
Supplier Evaluation
| Evaluation No. | Date | Supplier | Type | Total | Grade | Evaluated By | Status | Attachment | Action |
|---|
PT and ILC
| No. | Date | Type | Provider | Method | Participant | Result | Next Due | Attachment | Action |
|---|
Method Validation
Measurement Uncertainty
User Form
Create admin users or limited users with selected permissions.
Admin Reset Password
Set a temporary password. The selected user must create a new password after next login.
| Login ID | Name | Role | Dashboard Location | Permissions | Action |
|---|