Skip to content
Alzubair Alojali
WhatsApp
ALL WORK · 03
Field rewards

Decakila Coupon System

Client
Decakila
Status
Delivered
Platform
Web
Stack
PHP (PHPRunner)MySQLRBACAppend-only audit

Screens are faithful reconstructions of an archived system, rebuilt from its real database schema.

Coupons issued vs activated, redemption rate, total value, by branch and status
Coupons issued vs activated, redemption rate, total value, by branch and status
The brief

Field technicians earn reward coupons for every repair: issued, capped, activated and audited, across every branch.

Rewarding field technicians across branches means real money moving on paper: coupons need caps, activation records, and a straight answer to “who approved this?”.

A coupon with a biography

Each coupon shows its value against its cap, its technician, its branch and its full activation history: real money, fully explained.

A single coupon: value against its cap, technician, branch, activation history
A single coupon: value against its cap, technician, branch, activation history

Technicians, measured fairly

Specialisation, rate, branch and coupons earned per technician. Rewards follow recorded repairs, not memory.

Technicians by specialisation, rate, branch and coupons earned
Technicians by specialisation, rate, branch and coupons earned

"Who approved this?" has an answer

An append-only audit log over every table plus a role-permission matrix down to view / add / edit / delete per group.

The append-only audit log and the role-permission matrix
The append-only audit log and the role-permission matrix

Repairs drive the rewards

Repair operations generate the coupons they justify: issued against a technician, a branch and an amount, capped at a maximum.

Repair operations and the coupons they generated
Repair operations and the coupons they generated
The hard part

A coupon lifecycle with a value cap and activation tracking; role-based permissions down to view / add / edit / delete per group; and an append-only audit trail over every table.

PHP (PHPRunner)MySQLRBACAppend-only audit
Outcome

Every coupon accounted for: issued, capped, activated, audited.

Outcome

Role-based permissions down to the single action.

Outcome

A straight answer to "who approved this?".

Status

Delivered

Have something like this in mind?

Usually replies within a day.
NEXT PROJECT · ARChive · 10/15

A physical archive that finally knows where everything is: 14,525 student files tracked to the exact cabinet and drawer, scanned with OCR, and checked out by QR code.

READ THE CASE STUDY