Skip to content
TOLGA İLERİ

Home/Work/Press Card Tracking

Project / 112026Press Card Administration

Press Card Tracking

An administrative platform for receiving, reviewing and deciding press-card applications, with regional review, commission decisions and renewal tracking.

Role
Full-Stack Development
Type
Internal tool
Stack
Node.js / Express / Prisma / Microsoft SQL Server / JavaScript / Tailwind CSS / Chart.js / Docker
Repository

Overview

Press Card Tracking digitizes the press-card application lifecycle. It records incoming applications, supports regional document review, captures commission decisions and tracks card validity so renewal work can start before expiry.

Role
Full-Stack Development
Year
2026
Type
Internal tool
Stack
Node.js / Express / Prisma / Microsoft SQL Server / JavaScript / Tailwind CSS / Chart.js / Docker

01 / Context

Press-card administration depends on a staged workflow: intake, regional review, central commission decision and ongoing validity tracking. The system was built to keep that process visible in one panel.

02 / Challenge

The application needed a clear status path from intake to decision, while also surfacing cards approaching expiry so renewal work is not missed.

03 / Solution

A Node.js and Express API with Prisma persists applications, regions, organizations and members in SQL Server. A lightweight web panel lists records, updates review and commission states, and highlights cards due for renewal within 30 days.

Responsibilities

  1. 01Built the application, region, organization and member data model.
  2. 02Implemented the Express API for intake, regional review and commission decisions.
  3. 03Developed the administrative panel and operational statistics views.
  4. 04Packaged the API, web panel and SQL Server environment with Docker Compose.

Key areas

  • Application intake and status tracking
  • Regional review workflow
  • Commission decision flow
  • Renewal reminders for cards nearing expiry
  • Operational statistics

Technology

Architecture

  • Express API with a static web panel
  • Prisma data access against SQL Server

Frontend

  • Vanilla JavaScript
  • Tailwind CSS
  • Chart.js

Backend

  • Node.js
  • Express
  • Prisma

Database

  • Microsoft SQL Server

Infra

  • Docker
  • Docker Compose