path: root/src/gemini/Controller/Village.php

<?php

namespace App\gemini\Controller;

use App\DB;
use App\Guard;
use App\Model\Event;
use App\Model\Event\SendResources;
use App\Model\Event\SendResourcesCarriers;
use App\Model\Event\SendUnits;
use App\Model\Event\TrainUnits;
use App\Model\Event\UpgradeBuilding;
use App\Model\Unit;
use App\Model\Unit\MailCarrier;
use App\Model\Village as Model;
use App\Support\ResourceType;
use App\View;
use GeminiFoundation\Request;
use GeminiFoundation\Response;
use GeminiFoundation\Status;

class Village
{
  // #[Route(path: '/villages', methods: ['GET'])]
  public function list(): Response
  {
    $villages = DB::fetch(
      Model::class,
      <<<SQL
      select *,villages.id from villages
      join user_villages on villages.id = user_villages.village_id
      where user_villages.user_id=:id
      SQL,
      ['id' => $_SESSION['user']['id']]
    );


    return new Response(body: View::render('villages.twig', [
      'villages' => $villages,
    ]));
  }

  //#[Route(path: '/village/{x}/{y}', methods: ['GET'])]
  public function show(Request $request): Response
  {
    $village = Model::getByCoordinates($request->get('x'), $request->get('y'));

    if (! Guard::ownsVillage($village->id)) {
      return new Response(body: View::render('error.twig', ['message' => 'Insufficient permission']));
    }

    $events = [];

    $eventsBuilding = DB::query(
      <<<SQL
      select * from events_upgrade_building as event
      left join events on event.event_id = events.id
      where events.village_id=:id
      SQL, ['id' => $village->id]
    )->fetchAll();

    foreach ($eventsBuilding as $row) {
      $events['UpgradeBuilding'][$row['type']][] = DB::convertToModel(UpgradeBuilding::class, $row);
    }

    $eventsUnits = DB::query(
      <<<SQL
      select * from events_train_units as event
      left join events on event.event_id = events.id
      where village_id=:id
      SQL, ['id' => $village->id]
    )->fetchAll();

    foreach ($eventsUnits as $row) {
      $events['TrainUnits'][] = DB::convertToModel(TrainUnits::class, $row);
    }

    $eventsUnitsSendOwn = DB::query(
      <<<SQL
      select * from events_send_units as event
      left join events on event.event_id = events.id
      where village_id=:id
      SQL, ['id' => $village->id]
    )->fetchAll();

    $eventsUnitsSendOther = DB::query(
      <<<SQL
      select * from events_send_units as event
      left join events on event.event_id = events.id
      where (destination=:id or source=:id) and village_id!=:id and is_canceled=false
      SQL, ['id' => $village->id]
    )->fetchAll();

    foreach ([...$eventsUnitsSendOwn, ...$eventsUnitsSendOther] as $row) {
      $events['SendUnits'][] = DB::convertToModel(SendUnits::class, $row);;
    }

    $eventsResourcesSendOwn = DB::query(
      <<<SQL
      select * from events_send_resources as event
      left join events on event.event_id = events.id
      where village_id=:id
      SQL, ['id' => $village->id]
    )->fetchAll();

    $eventsResourcesSendOther = DB::query(
      <<<SQL
      select * from events_send_resources as event
      left join events on event.event_id = events.id
      where (destination=:id or source=:id) and village_id!=:id and is_canceled=false
      SQL, ['id' => $village->id]
    )->fetchAll();

    foreach ([...$eventsResourcesSendOwn, ...$eventsResourcesSendOther] as $row) {
      $events['SendResources'][] = DB::convertToModel(SendResources::class, $row);;
    }

    $eventsResourcesCarriersSendOwn = DB::query(
      <<<SQL
      select * from events_send_resources_carriers as event
      left join events on event.event_id = events.id
      where village_id=:id
      SQL, ['id' => $village->id]
    )->fetchAll();

    $eventsResourcesCarriersSendOther = DB::query(
      <<<SQL
      select * from events_send_resources_carriers as event
      left join events on event.event_id = events.id
      where (destination=:id or source=:id) and village_id!=:id
      SQL, ['id' => $village->id]
    )->fetchAll();

    foreach ([...$eventsResourcesCarriersSendOwn, ...$eventsResourcesCarriersSendOther] as $row) {
      $events['SendResourcesCarriers'][] = DB::convertToModel(SendResourcesCarriers::class, $row);;
    }

    $buildings = [];
    foreach (Model::getBuildings($village->id, true) as $building) {
      $buildings[$building->type] = $building;
    }


    return new Response(body: View::render('village.twig', [
      'village' => $village,
      'events' => $events,
      'buildings' => $buildings,
      'villages' => DB::fetch(Model::class, "select * from villages where id!=:id", ['id' => $village->id]),
      'postOffice' => $village->getBuilding($village->id, 'PostOffice'),
    ]));
  }

  // #[Route(path: '/village/{x}/{y}/storage/config', methods: ['POST'])]
  public function storageConfig(Request $request): Response
  {
    $village = Model::getByCoordinates($request->get('x'), $request->get('y'));
    $type = $request->get('type');

    if (empty($type)) {
      return new Response(body: View::render('storage.twig', [
        'village' => $village,
      ]));
    }

    if (empty($request->get('input'))) {
      return new Response(statusCode: Status::INPUT, meta: "$type percent?");
    }

    $input = intval($request->get('input'));

    // calculate to max 100%
    $allTypes = ResourceType::asProperties();
    $allOtherTypes = array_diff($allTypes, [$type]);

    $storageConfig = $village->getStorageConfig($village->id);

    $values = [];
    foreach ($allTypes as $resourceType) {
      $values[$resourceType] = $storageConfig->$resourceType;
    }
    $values[$type] = $input;

    $total = 0;
    foreach ($values as $value) {
      $total += $value;
    }

    foreach ($values as $resourceType => $value) {
      $values[$resourceType] = round(($value / $total) * 100);
    }

    if ($values[$type] !== $input) {
      $values[$type] = $input;
    }

    $newTotal = array_sum($values);
    $values['food'] += (100 - $newTotal);

    DB::query(
      <<<SQL
      update village_storage_config
      set wood=:wood, clay=:clay, iron=:iron, food=:food
      where village_id=:id
      SQL,
      ['wood' => $values['wood'], 'clay' => $values['clay'], 'iron' => $values['iron'], 'food' => $values['food'], 'id' => $village->id]
    );


    return new Response(
      statusCode: Status::REDIRECT_TEMPORARY,
      meta: "/village/{$village->x}/{$village->y}/storage/config"
    );
  }

  // #[Route(path: '/village/{x}/{y}/send-resources', methods: ['POST'])]
  public function sendResources(Request $request): Response
  {
    $village = Model::getByCoordinates($request->get('x'), $request->get('y'));

    $selectedResourceType = $request->get('selectedResourceType');
    if (empty($selectedResourceType)) {
      return new Response(body: View::render('send-resources/01-resource-types.twig', [
        'village' => $village,
        'postOffice' => $village->getBuilding($village->id, 'PostOffice'),
      ]));
    }

    if (empty($request->get('selectedVillageX'))) {
      return new Response(body: View::render('send-resources/02-villages.twig', [
        'village' => $village,
        'villages' => DB::fetch(Model::class, "select * from villages where id!=:id", ['id' => $village->id]),
        'selectedResourceType' => $selectedResourceType,
        'postOffice' => $village->getBuilding($village->id, 'PostOffice'),
      ]));
    }
    $selectedVillage = Model::getByCoordinates($request->get('selectedVillageX'), $request->get('selectedVillageY'));

    $amount = intval($request->get('input'));
    if (empty($amount)) {
      return new Response(statusCode: Status::INPUT, meta: 'Amount');
    }

    $resourceCapabilities = MailCarrier::getResourceCapabilities($village);
    $necessaryMailCarriers = ceil($amount / $resourceCapabilities);
    $mailCarriers = DB::fetch(MailCarrier::class, 'select sum(amount) as amount from village_units where type=:type and residence_village_id=:villageId and is_traveling=false', ['villageId' => $village->id, 'type' => 'MailCarrier'])[0]->amount ?? 0;
    if ($mailCarriers === 0 || $amount > $resourceCapabilities) {
      return new Response(
        statusCode: Status::REDIRECT_TEMPORARY,
        meta: "/village/{$village->x}/{$village->y}/send-resources/type/$selectedResourceType"
      );
    }

    $destination = $selectedVillage;

    // event
    $event = new Event();
    $event->time = (new \DateTime())->add(
      \DateInterval::createFromDateString(
        Unit::getTravelTime(new MailCarrier(), Model::getDistance($village->x, $village->y, $destination->x, $destination->y))
        . ' seconds'
      )
    );
    $event->villageId = $village->id;
    $sendResourcesEvent = new SendResources();
    $sendResourcesEvent->event = $event;
    $sendResourcesEvent->$selectedResourceType = $amount;
    $sendResourcesEvent->source = $village->id;
    $sendResourcesEvent->destination = $destination->id;
    $sendResourcesEvent->dbInsert();


    return new Response(
      statusCode: Status::REDIRECT_TEMPORARY,
      meta: "/village/{$village->x}/{$village->y}"
    );
  }
}