<?php
declare(strict_types=1);
require_once __DIR__ . '/../../authentication/api/connect.php';
$user = require_auth();
$db = db();
$id = (int)$user['id'];

if (($_SERVER['REQUEST_METHOD'] ?? '') === 'GET') {
    $with = (int)($_GET['with'] ?? 0);
    if ($with < 1) {
        $q = $db->prepare('SELECT u.id user_id,COALESCE(NULLIF(u.full_name,\'\'),u.username) full_name,u.role,MAX(m.sent_at) last_message_at FROM users u LEFT JOIN conversation_members cm ON cm.user_id=u.id LEFT JOIN conversations c ON c.id=cm.conversation_id AND c.conversation_type=\'direct\' AND EXISTS(SELECT 1 FROM conversation_members own WHERE own.conversation_id=c.id AND own.user_id=?) LEFT JOIN messages m ON m.conversation_id=c.id WHERE u.id<>? AND u.is_active=1 GROUP BY u.id,u.full_name,u.username,u.role ORDER BY (MAX(m.sent_at) IS NULL),MAX(m.sent_at) DESC,full_name LIMIT 500');
        $q->execute([$id,$id]);
        reply(200,['status'=>'success','contacts'=>$q->fetchAll()]);
    }
    $valid=$db->prepare('SELECT 1 FROM users WHERE id=? AND is_active=1 AND id<>?');
    $valid->execute([$with,$id]);
    if (!$valid->fetch()) reply(404,['status'=>'error','message'=>'This account is unavailable.']);
    $q=$db->prepare('SELECT c.id FROM conversations c JOIN conversation_members a ON a.conversation_id=c.id AND a.user_id=? JOIN conversation_members b ON b.conversation_id=c.id AND b.user_id=? WHERE c.conversation_type=\'direct\' ORDER BY c.id DESC LIMIT 1');
    $q->execute([$id,$with]);
    $conversation=(int)($q->fetchColumn() ?: 0);
    if (!$conversation) reply(200,['status'=>'success','messages'=>[]]);
    $q=$db->prepare('SELECT m.id,m.message_text,m.sent_at,m.sender_user_id,COALESCE(NULLIF(u.full_name,\'\'),u.username) sender_name FROM messages m JOIN users u ON u.id=m.sender_user_id JOIN conversation_members cm ON cm.conversation_id=m.conversation_id AND cm.user_id=? WHERE m.conversation_id=? ORDER BY m.id DESC LIMIT 200');
    $q->execute([$id,$conversation]);
    reply(200,['status'=>'success','messages'=>array_reverse($q->fetchAll())]);
}

if (($_SERVER['REQUEST_METHOD'] ?? '') !== 'POST') reply(405,['status'=>'error','message'=>'Use GET or POST.']);
start_auth_session();
if (!hash_equals($_SESSION['csrf_token'] ?? '', $_SERVER['HTTP_X_CSRF_TOKEN'] ?? '')) reply(403,['status'=>'error','message'=>'Refresh the page and try again.']);
$input=json_decode((string)file_get_contents('php://input'),true);
if (!is_array($input)) reply(400,['status'=>'error','message'=>'Invalid message request.']);
$recipient=(int)($input['recipient_user_id']??0);
$text=trim((string)($input['message_text']??''));
if ($recipient<1||$recipient===$id||$text==='') reply(422,['status'=>'error','message'=>'Choose a colleague and enter a message.']);
$valid=$db->prepare('SELECT 1 FROM users WHERE id=? AND is_active=1 AND id<>?');$valid->execute([$recipient,$id]);
if (!$valid->fetch()) reply(404,['status'=>'error','message'=>'This account is unavailable.']);
$q=$db->prepare('SELECT c.id FROM conversations c JOIN conversation_members a ON a.conversation_id=c.id AND a.user_id=? JOIN conversation_members b ON b.conversation_id=c.id AND b.user_id=? WHERE c.conversation_type=\'direct\' ORDER BY c.id DESC LIMIT 1');$q->execute([$id,$recipient]);$conversation=(int)($q->fetchColumn()?:0);
if (!$conversation) {
    $db->beginTransaction();
    try {$db->prepare("INSERT INTO conversations(conversation_type) VALUES('direct')")->execute();$conversation=$db->lastInsertId();$db->prepare('INSERT INTO conversation_members(conversation_id,user_id) VALUES(?,?),(?,?)')->execute([$conversation,$id,$conversation,$recipient]);$db->commit();}
    catch(Throwable $e){$db->rollBack();reply(503,['status'=>'error','message'=>'Could not open this conversation. Please retry.']);}
}
$db->prepare('INSERT INTO messages(conversation_id,sender_user_id,message_text) VALUES(?,?,?)')->execute([$conversation,$id,mb_substr($text,0,5000)]);
reply(201,['status'=>'success','message'=>'Message sent.']);
