index.php 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233
  1. <?php
  2. declare(strict_types=1);
  3. use App\Auth\LocalAdmin;
  4. use App\Auth\OidcClient;
  5. use App\Auth\SessionGuard;
  6. use App\Controllers\AuditController;
  7. use App\Controllers\AuthController;
  8. use App\Controllers\SettingsController;
  9. use App\Controllers\SprintController;
  10. use App\Controllers\TaskController;
  11. use App\Controllers\UserController;
  12. use App\Controllers\WorkerController;
  13. use App\Db\Connection;
  14. use App\Db\Migrator;
  15. use App\Http\Request;
  16. use App\Http\Response;
  17. use App\Http\Router;
  18. use App\Http\View;
  19. use App\Repositories\AppSettingsRepository;
  20. use App\Repositories\AuditRepository;
  21. use App\Repositories\SprintRepository;
  22. use App\Repositories\SprintWeekRepository;
  23. use App\Repositories\SprintWorkerDayRepository;
  24. use App\Repositories\SprintWorkerRepository;
  25. use App\Repositories\TaskAssignmentRepository;
  26. use App\Repositories\TaskRepository;
  27. use App\Repositories\UserRepository;
  28. use App\Repositories\WorkerRepository;
  29. use App\Services\AuditLogger;
  30. // Buffer output so a stray warning/notice can't send headers before
  31. // Response::send() gets a chance to set them. send() will flush.
  32. ob_start();
  33. define('APP_ROOT', dirname(__DIR__));
  34. // ---------------------------------------------------------------------------
  35. // Autoload
  36. // ---------------------------------------------------------------------------
  37. $autoload = APP_ROOT . '/vendor/autoload.php';
  38. if (!is_file($autoload)) {
  39. http_response_code(500);
  40. header('Content-Type: text/plain; charset=utf-8');
  41. echo "Composer dependencies are not installed.\n";
  42. echo "Run: composer install (or rebuild the container).\n";
  43. exit;
  44. }
  45. require $autoload;
  46. // ---------------------------------------------------------------------------
  47. // Environment
  48. // ---------------------------------------------------------------------------
  49. if (is_file(APP_ROOT . '/.env')) {
  50. $dotenv = Dotenv\Dotenv::createImmutable(APP_ROOT);
  51. $dotenv->safeLoad();
  52. }
  53. $appEnv = getenv('APP_ENV') ?: 'production';
  54. if ($appEnv !== 'production') {
  55. ini_set('display_errors', '1');
  56. error_reporting(E_ALL);
  57. } else {
  58. ini_set('display_errors', '0');
  59. }
  60. // ---------------------------------------------------------------------------
  61. // Migrations — cheap no-op when already current
  62. // ---------------------------------------------------------------------------
  63. try {
  64. $pdo = Connection::pdo();
  65. (new Migrator($pdo))->migrate();
  66. } catch (\Throwable $e) {
  67. http_response_code(500);
  68. header('Content-Type: text/plain; charset=utf-8');
  69. echo "Database bootstrap failed.\n";
  70. if ($appEnv !== 'production') {
  71. echo $e->getMessage() . "\n";
  72. }
  73. exit;
  74. }
  75. // ---------------------------------------------------------------------------
  76. // Shared services
  77. // ---------------------------------------------------------------------------
  78. $twigCacheDir = APP_ROOT . '/data/twig-cache';
  79. if (!is_dir($twigCacheDir)) {
  80. @mkdir($twigCacheDir, 0775, true);
  81. }
  82. $view = new View(APP_ROOT . '/views', $twigCacheDir);
  83. $users = new UserRepository($pdo);
  84. $workers = new WorkerRepository($pdo);
  85. $sprints = new SprintRepository($pdo);
  86. $sprintWeeks = new SprintWeekRepository($pdo);
  87. $sprintWorkers = new SprintWorkerRepository($pdo);
  88. $swDays = new SprintWorkerDayRepository($pdo);
  89. $tasks = new TaskRepository($pdo);
  90. $taskAssign = new TaskAssignmentRepository($pdo);
  91. $auditRepo = new AuditRepository($pdo);
  92. $appSettings = new AppSettingsRepository($pdo);
  93. $audit = new AuditLogger($pdo);
  94. $auth = new AuthController($pdo, $users, $audit, $view);
  95. $workerCtrl = new WorkerController($pdo, $users, $workers, $audit, $view);
  96. $sprintCtrl = new SprintController(
  97. $pdo, $users, $sprints, $sprintWeeks, $sprintWorkers, $swDays,
  98. $tasks, $taskAssign, $workers, $audit, $view, $appSettings,
  99. );
  100. $taskCtrl = new TaskController(
  101. $pdo, $users, $sprints, $sprintWorkers, $swDays,
  102. $tasks, $taskAssign, $workers, $audit, $appSettings,
  103. );
  104. $auditCtrl = new AuditController($users, $auditRepo, $view);
  105. $userCtrl = new UserController($pdo, $users, $audit, $view);
  106. $settingsCtrl = new SettingsController($pdo, $users, $appSettings, $audit, $view);
  107. // ---------------------------------------------------------------------------
  108. // Routing
  109. // ---------------------------------------------------------------------------
  110. $router = new Router();
  111. $router->get('/', function (Request $req) use ($view, $pdo, $users, $sprints, $appEnv): Response {
  112. $currentUser = SessionGuard::currentUser($users);
  113. $schemaVersion = (int) $pdo->query(
  114. 'SELECT COALESCE(MAX(version), 0) FROM schema_version'
  115. )->fetchColumn();
  116. $sprintRows = $currentUser === null ? [] : $sprints->allWithCounts();
  117. return Response::html($view->render('home', [
  118. 'title' => 'Sprint Planner',
  119. 'currentUser' => $currentUser,
  120. 'schemaVersion' => $schemaVersion,
  121. 'dbPath' => Connection::path(),
  122. 'appEnv' => $appEnv,
  123. 'oidcConfigured' => OidcClient::isConfigured(),
  124. 'localAdminEnabled' => LocalAdmin::isEnabled(),
  125. 'authError' => isset($req->query['auth_error']),
  126. 'csrfToken' => SessionGuard::csrfToken(),
  127. 'sprintRows' => $sprintRows,
  128. ]));
  129. });
  130. $router->get('/healthz', fn() => Response::text('ok'));
  131. $router->get('/auth/login', $auth->login(...));
  132. $router->get('/auth/callback', $auth->callback(...));
  133. $router->post('/auth/logout', $auth->logout(...));
  134. $router->get('/auth/local', $auth->loginLocalForm(...));
  135. $router->post('/auth/local', $auth->loginLocal(...));
  136. $router->get('/workers', $workerCtrl->index(...));
  137. $router->post('/workers', $workerCtrl->create(...));
  138. $router->post('/workers/{id}', $workerCtrl->update(...));
  139. $router->get('/users', $userCtrl->index(...));
  140. $router->post('/users/{id}', $userCtrl->update(...));
  141. $router->get('/sprints/new', $sprintCtrl->newForm(...));
  142. $router->post('/sprints', $sprintCtrl->create(...));
  143. $router->get('/sprints/{id}', $sprintCtrl->show(...));
  144. $router->get('/sprints/{id}/present', $sprintCtrl->present(...));
  145. $router->get('/sprints/{id}/settings', $sprintCtrl->settings(...));
  146. // JSON mutation endpoints (admin, CSRF via X-CSRF-Token header):
  147. $router->patch('/sprints/{id}', $sprintCtrl->updateMeta(...));
  148. $router->post('/sprints/{id}/weeks', $sprintCtrl->replaceWeeks(...));
  149. $router->post('/sprints/{id}/workers', $sprintCtrl->addWorker(...));
  150. $router->delete('/sprints/{id}/workers/{sw_id}', $sprintCtrl->removeWorker(...));
  151. $router->post('/sprints/{id}/workers/reorder', $sprintCtrl->reorderWorkers(...));
  152. $router->patch('/sprints/{id}/workers/{sw_id}', $sprintCtrl->updateWorker(...));
  153. // Phase 5 — Arbeitstage grid:
  154. $router->patch('/sprints/{id}/week-cells', $sprintCtrl->updateWeekCells(...));
  155. $router->patch('/sprints/{id}/week/{week_id}', $sprintCtrl->updateWeekDays(...));
  156. // Phase 6 — Task list:
  157. $router->get('/audit', $auditCtrl->index(...));
  158. $router->post('/sprints/{id}/tasks', $taskCtrl->create(...));
  159. $router->post('/sprints/{id}/tasks/reorder', $taskCtrl->reorder(...));
  160. $router->patch('/tasks/{id}', $taskCtrl->update(...));
  161. $router->delete('/tasks/{id}', $taskCtrl->delete(...));
  162. $router->patch('/tasks/{id}/assignments', $taskCtrl->updateAssignments(...));
  163. // Phase 18 — task-cell status (any signed-in user, gated by global flag):
  164. $router->patch('/tasks/{id}/assignments/status', $taskCtrl->updateAssignmentsStatus(...));
  165. // Phase 18 — global app settings (admin):
  166. $router->get('/settings', $settingsCtrl->show(...));
  167. $router->post('/settings', $settingsCtrl->update(...));
  168. // ---------------------------------------------------------------------------
  169. // Dispatch
  170. // ---------------------------------------------------------------------------
  171. $request = Request::fromGlobals();
  172. $response = $router->dispatch($request);
  173. // Apply security headers to every response (spec §9). Kept here (instead of
  174. // Response::send) so the policy is visible + editable in one place.
  175. $isHttps = str_starts_with((string) (getenv('APP_BASE_URL') ?: ''), 'https://');
  176. // Strict CSP (Phase 11 + Phase 19). Tailwind is pre-compiled at image-build
  177. // time, jQuery / jQuery UI are gone, and Alpine (CSP build), htmx, and
  178. // SortableJS are vendored under /assets/js/vendor/ — so script-src and
  179. // style-src are 'self' only, no 'unsafe-eval', no 'unsafe-inline', no CDN
  180. // hosts. font-src keeps `data:` for the few inline data-URL glyphs.
  181. $csp = implode('; ', [
  182. "default-src 'self'",
  183. "script-src 'self'",
  184. "style-src 'self'",
  185. "img-src 'self' data:",
  186. "font-src 'self' data:",
  187. "connect-src 'self'",
  188. "frame-ancestors 'none'",
  189. "base-uri 'self'",
  190. "form-action 'self' https://login.microsoftonline.com",
  191. ]);
  192. $response
  193. ->withHeader('X-Content-Type-Options', 'nosniff')
  194. ->withHeader('X-Frame-Options', 'DENY')
  195. ->withHeader('Referrer-Policy', 'strict-origin-when-cross-origin')
  196. ->withHeader('Content-Security-Policy', $csp);
  197. if ($isHttps) {
  198. $response->withHeader('Strict-Transport-Security', 'max-age=31536000; includeSubDomains');
  199. }
  200. $response->send();
  201. // Flush the output buffer opened at the top.
  202. if (ob_get_level() > 0) {
  203. @ob_end_flush();
  204. }