Electrification & Public Lighting - Dolibarr

Electrification & Public Lighting Enterprise is a comprehensive business solution specifically designed for companies specializing in electrification work, public lighting, low and medium voltage electrical networks, rural electrification, the installation of urban electrical equipment, and the maintenance and modernization of energy infrastructure. Fully integrated with Dolibarr ERP & CRM, this solution allows you to centralize, plan, control, and optimize all technical, commercial, logistical, and financial activities related to electrification and public lighting projects.

The module was developed specifically to meet the needs of companies involved in public procurement, local authorities, municipalities, public offices, property developers, and private companies specializing in electrical work. Unlike a simple project management module, each feature, indicator, and business object has been designed to efficiently manage poles, LED and solar lighting, electrical cabinets, cables, transformers, photovoltaic cells, protective equipment, field teams, and electrification sites.

The module features a modern decision-making dashboard that allows managers and technical staff to monitor project progress in real time, including the number of active sites, installed equipment, completed interventions, inventory consumption, financial performance, and critical alerts. Interactive charts enable analysis of purchases, sales, material consumption, and operational performance to facilitate decision-making.

At the heart of the solution lies a powerful site management system that tracks each project from inception to completion. Each site can be associated with a client, a Dolibarr project, a public tender, or a specific contract. Managers can track budgets, estimated and actual costs, technical and financial progress rates, assigned teams, and the various phases of work execution. The module covers, in particular, the installation of public lighting, low-voltage (LV) and medium-voltage (MV) electrification, network extensions, cable laying, electrical cabinet installation, pole erection, solar lighting, smart lighting, and urban renewal projects.

The integrated technical equipment catalog allows for the management of all equipment used on construction sites. Each piece of equipment has its own technical data sheet containing technical specifications, suppliers, purchase and sale prices, warranties, stock levels, and maintenance information. The system supports LED luminaires, solar luminaires, lighting poles, transformers, electrical cabinets, circuit breakers, photoelectric cells, cables, junction boxes, concrete foundations, and many other industry-specific equipment items.

The module also integrates advanced management of Unit Price Schedules (UPS), Estimated Quantity Details (EQD), and Bills of Quantities (BOQ). Users can develop their financial estimates, automatically calculate costs, margins, and selling prices, and then generate fully integrated Dolibarr quotes with a single click. This functionality significantly simplifies the preparation of technical and financial bids for public and private tenders.

Purchasing and supplier management ensures accurate tracking of material needs for each project. Managers can compare supplier prices, track orders, deliveries, and supply requirements, while optimizing purchasing costs and project completion times.

To ensure rigorous resource management, the module offers comprehensive control over stock consumption and material movements. Stock withdrawals, returns, transfers, and reservations can be directly allocated to worksites to accurately measure actual consumption and discrepancies from initial forecasts.

The solution also includes a comprehensive team management and site log system for tracking human resources assigned to projects. Managers can record teams, skills, hourly costs, daily work completed, materials consumed, incidents encountered, and hours worked. This functionality significantly improves traceability and operational management of construction sites.

For maintenance activities, the module includes a powerful work order management tool for tracking corrective and preventive maintenance on electrical installations and public lighting equipment. Technicians can record their diagnoses, parts used, labor hours, work orders, and associated invoices. The system covers emergency troubleshooting, light fixture replacement, cable repair, cabinet inspections, solar maintenance, and network diagnostics.

To ensure the quality and compliance of installations, the module offers a dedicated quality control space for conducting technical inspections, electrical continuity tests, grounding checks, lighting verifications, cable installation checks, and work acceptance. Results can be recorded, printed, and archived to guarantee the conformity of the completed work.

The module also features a comprehensive reporting system that generates detailed reports on site status, project profitability, purchases, sales, inventory consumption, installed equipment, technical interventions, delays, supplier performance, and variances between budget forecasts and actual results. Reports can be exported in PDF, Excel, and CSV formats to facilitate analysis and information sharing.

Thanks to its native integration with Dolibarr modules such as Third Parties, Products, Inventory, Warehouses, Projects, Tasks, Quotes, Orders, Invoices, Interventions, Contracts, Calendar, and Accounting, the solution offers centralized and consistent management of all business activities. Advanced automations, scheduled tasks, and intelligent alerts improve productivity and secure daily operations.

Main features

✔ Complete management of electrification and public lighting projects
✔ Management of public procurement and works contracts
✔ Management of technical teams and site logs
✔ Monitoring of budgets, actual costs, and project profitability
✔ Management of electrical equipment and technical catalogs
✔ Management of LED, solar, and smart lighting fixtures
✔ Management of poles, cables, transformers, and electrical cabinets
✔ Preparation of unit price schedules, bills of quantities, and bills of quantities
✔ Automatic generation of Dolibarr quotes from price lists
✔ Management of purchases and supplies per site
✔ Comparison of supplier prices
✔ Management of stock consumption and material movements
✔ Management of interventions and preventive and corrective maintenance
✔ Quality control and acceptance of works
✔ Dashboards with KPIs and business graphs
✔ Advanced reporting and PDF, Excel, and CSV exports
✔ Multi-project management and Multi-site
✔ Full integration with native Dolibarr modules
✔ Compatible with multiple companies and entities
✔ Available in French, English, Italian, German, Spanish and Arabic.

The Electrification & Public Lighting Enterprise thus constitutes a powerful business ERP solution enabling companies specializing in electrical infrastructure and public lighting to improve the management of their projects, control their costs, optimize their resources and strengthen their profitability while guaranteeing the quality and traceability of their achievements.

 

A complete and detailed description of all features

1. Module Identity

Element	Value
Trade name	Electrification & Public Lighting Company
Technical name	electrificationlighting
Editor	DoliResources
Website	https://www.doliresources.com
Copyright	© 2026 DoliResources
Current version	1.3
Module number	500700 (unique)
Family	Projects / Construction Sites
Compatibility	Dolibarr v16 → v23+
PHP minimum	7.1
License	GPL v3+
LANGUAGES	French, English, Italian, German, Spanish, Arabic (6 languages, 220 keys each)
graphic charter	Midnight blue / Electric yellow / Bright orange / White
Addictions	Native Modules: Products/Services and Third Parties

The module is designed specifically for the electrification and public lighting industry — it is not a generic project management module. Each object, field, status, report and indicator is tailored to the sector (poles, LED/sodium/solar luminaires, electrical cabinets, cables, transformers, teams, worksites).

2. Professional Dashboard

Home page of the module ( dashboard.php ), with a dark blue/yellow hero banner and 4 thematic areas.

Zone A — Activity & Production (10 indicators)

• Active projects
• Construction sites in progress
• Construction projects completed
• Construction sites are behind schedule
• Posts installed
• Light fixtures installed
• Enclosures installed
• Meters of cable used
• Number of interventions
• Maintenance operations

Zone B — Financial Performance (6 indicators)

• Total amount of quotes
• Quotes accepted
• Monthly revenue
• Purchase amount
• Profitability (budget − actual cost)
• Completed work not billed

Zone C — Stock & equipment (4 indicators)

• Stock value
• Number of devices
• Critical stock alerts
• Pending supplier orders

Zone D — Alerts & Delays (4 clickable tiles)

• Construction sites are behind schedule
• Critical stock
• Pending supplier orders
• Work completed, not billed

Graphics (DolGraph)

• Purchases vs. sales (12 months)
• Construction sites by status
• Equipment installed by category
• Stock consumption per construction site

The financial indicators are based on native Dolibarr invoices/proposals when these modules are active, with automatic fallback to the module data.

3. Construction site management (hub object)

Each construction site ( elecworksite ) contains:

• Reference, wording
• Client (Dolibarr third party), Project (linked Dolibarr project)
• Location, GPS Latitude, GPS Longitude
• Market reference / contract
• Type of work
• Start date, planned end date, actual end date
• Project Manager, Technical Lead, Assigned Team
• Budget, Estimated Cost, Actual Cost
• Technical progress (%), Financial progress (%)
• Note
• Status: Draft → Validated/In Progress → Completed/Closed → Cancelled

Site cockpit: KPI cards Budget / Actual cost / Profitability / Technical progress.
Site phases ( elecworksiteline ): linked sub-lines (stage, type, planned/actual quantity, unit, date, progress).

13 types of work managed: public lighting installation, public lighting maintenance, LV electrification, MV electrification, network extension, cabinet installation, cable laying, pole installation, solar lighting, decorative lighting, intelligent lighting, rural electrification, urban rehabilitation.

4. Management of technical equipment

Equipment catalogue ( elecequipment ), each entry contains:

• Reference, designation
• Category, related Dolibarr product
• Technical specifications, unit, brand
• Supplier (third party)
• Purchase price, selling price
• Quantity in stock, minimum stock
• Warranty period (months)
• Note

Categories covered: poles, LED lights, solar lights, electrical boxes, circuit breakers/contactors, photoelectric cells, transformers, concrete foundations, connectors, brackets/supports, junction boxes, cables, etc.

5. Price Schedule / Bill of Quantities / Unit Price Schedule (hub object)

elecboq object (BOQ / BPU / DQE):

• Reference, description, client, construction site, project
• Type (BOQ / BPU / DQE)
• Date
• Total purchase, total sale, margin (automatically recalculated)

Cockpit: Total purchase / Total sale / Margin.
Lines ( elecboqline ): reference, description, line type (works / equipment / labor / transport / machinery), unit, quantity, unit purchase price, unit selling price, margin %, VAT rate, total including tax, linked Dolibarr product, linked supplier.

⭐ Automatic quote generation

The "Generate a Dolibarr quote" button on the BOQ form creates a native quote (Propal) with one line per line of the bill of quantities, linked to the client and the project, and then redirects to the quote form. ( genquote.php )

6. Purchases and Suppliers

Purchases page ( achats.php ):

• KPIs: Amount of requirements, amount ordered, pending deliveries
• Purchase requirements per project: reference table / project / description / selected supplier / quantity required / ordered / received / best price
• Comparison of supplier prices: equipment / category / supplier / brand / purchase price (sorted by category and price ascending)

Subject: Purchase needs ( elecpurchaseneed ): site, BOQ, product, selected supplier, quantity required/ordered/received, unit, best price, Dolibarr supplier order link.

7. Stock Consumption

Consumption stock page ( stockconso.php ):

• KPIs: inventory value, theoretical quantity, actual quantity, variance
• Summary by project: theoretical vs. actual vs. discrepancy
• Detailed recent movements: reference / site / equipment / type of movement / actual quantity / date

Subject: Stock movements ( elecstockmove ): site, product, equipment, warehouse, type of movement (out/return/transfer/reservation), theoretical quantity, actual quantity, unit, date. → feeds the "installed equipment" counters on the dashboard.

8. Site Teams & Logs

Teams ( electeam ): reference, name, manager, members, skills, assigned site, hourly cost, productivity.

Daily logs ( elecdailylog ): reference, site, team, date, weather conditions, work carried out, equipment installed, materials used, incidents, hours worked, supervisor, supervisor validation.

9. Interventions & maintenance

Interventions ( elecintervention , hub object): reference, description, client, site, type of intervention, location, equipment involved, priority, technician, scheduled date, completed date, diagnosis, labor hours, intervention report, related invoice.
Cockpit: type / hours / priority. Lines ( elecinterventionline ): materials used (product, equipment, quantity, unit, price excluding VAT).

8 types: corrective maintenance, preventive maintenance, emergency troubleshooting, light fixture replacement, cable repair, cabinet inspection, solar maintenance, network diagnostics.

Dedicated Maintenance page ( maintenance.php ): filtered cockpit on maintenance interventions with KPIs (total, in progress, completed, hours) and coloured priority badges.

10. Quality control

Subject elecqualitycheck : reference, site, type of control, date, controller, result (compliant / compliant with reservations / non-compliant), note, observations, detailed checklist.

8 types of checklists: pole installation check, cable laying check, electrical box check, lighting installation check, grounding test, electrical continuity test, lighting level check, final acceptance checklist. (Printable via the print function.)

11. Reporting (12 reports)

Reporting page ( reporting.php ) with tabs, filters and export.

Available reports:

1. Status of active construction sites
2. Profitability per project
3. Purchases by construction site
4. Sales by construction site
5. Stock consumption per construction site
6. Equipment installed
7. Report of interventions
8. Construction sites are behind schedule
9. Supplier performance
10. BOQ vs. Actual Comparison
11. Critical stock
12. Equipment warranties

For each report:

• Filter by project and by date (from / to)
• Dynamic KPI banner
• Export CSV (UTF-8 with BOM), Export Excel, Export PDF (landscape, dark blue chart)
• Impression

12. Module Configuration

Configuration page ( admin/setup.php ):

• Default warehouse
• Default VAT rate
• Default margin rate
• Critical stock threshold
• Enable/disable maintenance
• Enable/disable BOQ/BPU/DQE
• Enable/disable quality control
• Enable/disable GPS fields
• Enable/disable status invoices
• "Populate demo datasets" button
• "Clear demo datasets" button

About page ( admin/about.php ): publisher information + roadmap.

13. Demonstration Datasets

Automatically generated upon first activation (and resettable via the configuration buttons). Realistic and consistent content:

• 5 clients (municipalities/local authorities) + 4 suppliers (native Dolibarr third parties)
• 16 Dolibarr products + 16 catalogued equipment
• 1 warehouse + native stock movements
• 5 Dolibarr projects
• 4 teams, 8 projects (various statuses, one behind schedule, GPS, budgets) + phases
• 6 BOQ/DQE + lines
• ~28 consumer movements
• ~14 purchasing needs
• 12 interventions + lines
• 14 construction site logs
• 10 quality checks

Secure deletion: only data marked ELECDEMO is deleted (including third-party/product/native projects created by the generator). Your real data is never touched.

14. Detailed Permissions

9 groups of rights + administration:

Band	Read	Create/edit	DELETE
Construction sites	✓	✓	○
BOQ / BPU / DQE	✓	✓	○
Equipment	✓	✓	○
Purchases	✓	✓	○
Consumption stock	✓	✓	○
Teams & newspapers	✓	✓	○
Interventions & maintenance	✓	✓	○
Quality control	✓	✓	○
Reporting	✓	Export	—
Administration	—	—	○

Read and write access granted by default upon activation (the module is usable immediately); deletion and administration left at 0.

15. Native integrations & hooks

• Integrated native modules: Third parties, Contacts, Products/Services, Stock, Warehouses, Projects, Tasks, Quotes, Customer/supplier orders, Customer/supplier invoices, Interventions, Contracts, Users/Permissions, Documents, Calendar, Accounting (if available).
• Hooks: a contextual "Electrification" block is added to the Third Party, Project, Product, Invoice, Order and Quote records, displaying the number of linked construction sites / BOQ / interventions with direct links.
• Scheduled task (cron): daily scan of critical stock, delayed projects and warranties ( ElecMaintenanceEngine::runScan ).
• Triggers: automatic link consistency when a native product or project is deleted.
• Dashboard box: summary widget (ongoing projects, delayed projects, critical stock).

16. Left menu

Dashboard · Sites · BOQ/BPU/DQE · Equipment · Purchases · Purchase requirements · Stock consumption · Stock movements · Teams · Site logs · Interventions · Maintenance · Quality control · Customers · Suppliers · Reporting · Configuration.

Tab ↔ menu synchronization (v1.2): clicking a tab at the top automatically selects the corresponding entry in the left menu.

17. Interface & Technical Quality

Interface (UI/UX):

• Internal navigation tab bar on all pages
• Colored KPI cards, badges, progress bars, charts, graphs
• Export and print buttons
• Column show/hide selector for all lists (v1.2), elegantly grouped with the Search/Delete filter icons (v1.3)
• Font Awesome 5 icons, title icon reduced to 24px (v1.3)
• Responsive, conforms to the Dolibarr style, active tab text in readable white

Code quality:

• Secured against SQL injection (systematic escaping, getEntity() )
• Compatible with multiple companies/entities
• Respect for Dolibarr rights
• The schema is automatically repaired on each activation (missing columns are added during updates).
• Commented, structured, maintainable, production-ready code
• 59 PHP files, all syntactically validated

18. Generable PDF documents

Site sheet, BOQ/DQE, technical report, intervention report, maintenance report, quality checklist, monthly activity report, project profitability report — via PDF exports of reporting and printing of sheets.

19. Deliverables included in the ZIP file

Complete source code · Installation SQL · 6 language files · Configuration page · Dashboard · CRUD pages (generic list/form engine) · Business classes · Hooks · Menus · Permissions · Demo data generator + cleaner · Reporting pages · README.md · INSTALL.md · CHANGELOG.md · User/administrator guides · COPYING (GPL v3).

Final file: module_electrificationlighting-1.3.zip (download folder).