My account Get a quote

Mayerdem

Bilingual site for a telecom and energy field services firm, with progress billing, customer accounts, warehouse panel and automated acceptance reports.

Mayerdem

The need

May Erdem is a field service company in telecom and energy infrastructure. For each job, whether radio link, pole, cabinet or transformer work, progress billing, invoices and acceptance files are needed. These documents were prepared by hand in Excel and Word, which took time and led to errors. We developed the company's promotional website and the systems that run its daily work together.

What we built

  • Corporate site: a mobile-friendly promotional site in Turkish and English.
  • Progress billing and customer accounts: jobs, progress billing, invoices, customer accounts and warehouse tracking in a single panel. Price lists by company and year, VAT and VAT withholding calculations, and exchange rates are handled.
  • Acceptance automation: a step-by-step wizard fills in Word templates. Formatting and photos are preserved. Documents are converted to PDF and the signing process is managed.
  • Reading measurements: values in screenshots are read with AI and offline OCR. Conflicting fields are flagged.
  • Linking systems: acceptance data is passed to progress billing as suggested line items. Data is entered once across both systems.
  • Security: two-step verification, passkeys and role-based access.

How we built it

The progress billing system is written in PHP 8 and MySQL without a framework. The acceptance system is also written in PHP and uses PhpWord and PhpSpreadsheet for Word and Excel work. PDF conversion runs on the server as a separate service using LibreOffice. This way, Word formatting is not broken. Telegram and Google Drive connections were added for notifications and backups.

We set up the server on Plesk, with Cloudflare in front. Internal systems are closed to search engines. The corporate site does not link to these systems. We wrote an upload tool that updates files with a single command. The tool backs up the old file, sets ownership and checks the PHP syntax.

The result

The corporate site is live at mayerdem.com in Turkish and English. The progress billing and acceptance systems are available only to company staff. Incoming data is backed up every night, and backups are kept for 14 days. Server setup and maintenance are handled by us.

More projects

All →
Portly
Open sourceWindows · macOS · Linux

Portly

A free, open-source local web development environment for Windows, macOS and Linux that gives each project its own HTTPS address.

View →
Teacher Assignment Robot
Admin panelEducation

Teacher Assignment Robot

Turn-based, reasoned and transparent teacher assignment under the Turkish Ministry of Education (MEB) rules, with admin, teacher and school panels.

View →
WapFlow
WhatsAppAutomation

WapFlow

WhatsApp bulk messaging, campaign and AI-assisted auto-reply platform that runs in the cloud or as a Windows application.

View →