<?php
/**
* Copyright Maarch since 2008 under licence GPLv3.
* See LICENCE.txt file at the root folder for more details.
* This file is part of Maarch software.
*
*/
/**
* @brief Link Controller
* @author dev@maarch.org
*/
namespace Resource\controllers;
use Contact\controllers\ContactController;
use Contact\models\ContactModel;
use Convert\controllers\ConvertPdfController;
use Entity\models\EntityModel;
use Entity\models\ListInstanceModel;
use Group\controllers\PrivilegeController;
use History\controllers\HistoryController;
use Resource\models\ResModel;
use Resource\models\ResourceContactModel;
use Respect\Validation\Validator;
use Slim\Http\Request;
use Slim\Http\Response;
use Status\models\StatusModel;
use User\models\UserModel;
class LinkController
{
public function getLinkedResources(Request $request, Response $response, array $args)
{
if (!Validator::intVal()->validate($args['resId']) || !ResController::hasRightByResId(['resId' => [$args['resId']], 'userId' => $GLOBALS['id']])) {
return $response->withStatus(403)->withJson(['errors' => 'Resource out of perimeter']);
}
$resource = ResModel::getById(['resId' => $args['resId'], 'select' => ['linked_resources']]);
$linkedResourcesIds = json_decode($resource['linked_resources'], true);
$linkedResources = [];
if (!empty($linkedResourcesIds)) {
$linkedResourcesIds = ResController::getAuthorizedResources(['resources' => $linkedResourcesIds, 'userId' => $GLOBALS['id']]);
if (!empty($linkedResourcesIds)) {
$linkedResources = ResModel::get([
'select' => ['res_id as "resId"', 'subject', 'doc_date as "documentDate"', 'status', 'dest_user as "destUser"', 'destination', 'alt_identifier as chrono', 'category_id as "categoryId"', 'filename', 'format', 'confidentiality'],
'where' => ['res_id in (?)'],
'data' => [$linkedResourcesIds]
]);
}
foreach ($linkedResources as $key => $value) {
$linkedResources[$key]['hasDocument'] = !empty($value['filename']);
$linkedResources[$key]['confidentiality'] = $value['confidentiality'] == 'Y';
if (!empty($value['status'])) {
$status = StatusModel::getById(['id' => $value['status'], 'select' => ['label_status', 'img_filename']]);
$linkedResources[$key]['statusLabel'] = $status['label_status'];
$linkedResources[$key]['statusImage'] = $status['img_filename'];
}
if (!empty($value['destUser'])) {
$linkedResources[$key]['destUserLabel'] = UserModel::getLabelledUserById(['id' => $value['destUser']]);
}
if (!empty($value['destination'])) {
$linkedResources[$key]['destinationLabel'] = EntityModel::getByEntityId(['entityId' => $value['destination'], 'select' => ['short_label']])['short_label'];
}
$correspondents = ResourceContactModel::get([
'select' => ['item_id', 'type', 'mode'],
'where' => ['res_id = ?'],
'data' => [$value['resId']]
]);
$linkedResources[$key]['senders'] = [];
$linkedResources[$key]['recipients'] = [];
foreach ($correspondents as $correspondent) {
if ($correspondent['res_id'] == $resource['resId']) {
if ($correspondent['type'] == 'contact') {
$contactRaw = ContactModel::getById(['select' => ['firstname', 'lastname', 'company'], 'id' => $correspondent['item_id']]);
$contactToDisplay = ContactController::getFormattedOnlyContact(['contact' => $contactRaw]);
$formattedCorrespondent = $contactToDisplay['contact']['otherInfo'];
} elseif ($correspondent['type'] == 'user') {
$formattedCorrespondent = UserModel::getLabelledUserById(['id' => $correspondent['item_id']]);
} else {
$entity = EntityModel::getById(['id' => $correspondent['item_id'], 'select' => ['entity_label']]);
$formattedCorrespondent = $entity['entity_label'];
}
$linkedResources[$key]["{$correspondent['mode']}s"][] = $formattedCorrespondent;
}
}
$linkedResources[$key]['visaCircuit'] = ListInstanceModel::get(['select' => ['item_id', 'item_mode'], 'where' => ['res_id = ?', 'difflist_type = ?'], 'data' => [$value['resId'], 'VISA_CIRCUIT']]);
foreach ($linkedResources[$key]['visaCircuit'] as $keyCircuit => $valueCircuit) {
$linkedResources[$key]['visaCircuit'][$keyCircuit]['userLabel'] = UserModel::getLabelledUserById(['id' => $valueCircuit['item_id']]);
}
$linkedResources[$key]['canConvert'] = false;
if (!empty($value['format'])) {
$linkedResources[$key]['canConvert'] = ConvertPdfController::canConvert(['extension' => $value['format']]);
}
}
}
return $response->withJson(['linkedResources' => $linkedResources]);
}
public function linkResources(Request $request, Response $response, array $args)
{
if (!PrivilegeController::hasPrivilege(['privilegeId' => 'add_links', 'userId' => $GLOBALS['id']])) {
return $response->withStatus(403)->withJson(['errors' => 'Service forbidden']);
}
if (!Validator::intVal()->validate($args['resId']) || !ResController::hasRightByResId(['resId' => [$args['resId']], 'userId' => $GLOBALS['id']])) {
return $response->withStatus(403)->withJson(['errors' => 'Resource out of perimeter']);
}
$body = $request->getParsedBody();
if (!Validator::arrayType()->notEmpty()->validate($body['linkedResources'])) {
return $response->withStatus(403)->withJson(['errors' => 'Body linkedResources is empty or not an array']);
} elseif (!ResController::hasRightByResId(['resId' => $body['linkedResources'], 'userId' => $GLOBALS['id']])) {
return $response->withStatus(403)->withJson(['errors' => 'Body linkedResources out of perimeter']);
} elseif (in_array($args['resId'], $body['linkedResources'])) {
return $response->withStatus(400)->withJson(['errors' => 'Body linkedResources contains resource']);
}
$resource = ResModel::getById(['resId' => $args['resId'], 'select' => ['linked_resources', 'alt_identifier']]);
$linkedResources = json_decode($resource['linked_resources'], true);
$linkedResources = array_merge($linkedResources, $body['linkedResources']);
$linkedResources = array_unique($linkedResources);
foreach ($linkedResources as $key => $value) {
$linkedResources[$key] = (string)$value;
}
ResModel::update([
'set' => ['linked_resources' => json_encode($linkedResources)],
'where' => ['res_id = ?'],
'data' => [$args['resId']]
]);
ResModel::update([
'postSet' => ['linked_resources' => "jsonb_insert(linked_resources, '{0}', '\"{$args['resId']}\"')"],
'where' => ['res_id in (?)', "(linked_resources @> ?) = false"],
'data' => [$body['linkedResources'], "\"{$args['resId']}\""]
]);
$linkedResourcesInfo = ResModel::get([
'select' => ['alt_identifier', 'res_id'],
'where' => ['res_id in (?)'],
'data' => [$body['linkedResources']]
]);
$linkedResourcesAltIdentifier = array_column($linkedResourcesInfo, 'alt_identifier', 'res_id');
foreach ($body['linkedResources'] as $value) {
HistoryController::add([
'tableName' => 'res_letterbox',
'recordId' => $args['resId'],
'eventType' => 'UP',
'info' => _LINK_ADDED . " : {$linkedResourcesAltIdentifier[$value]}",
'moduleId' => 'resource',
'eventId' => 'resourceModification'
]);
HistoryController::add([
'tableName' => 'res_letterbox',
'recordId' => $value,
'eventType' => 'UP',
'info' => _LINK_ADDED . " : {$resource['alt_identifier']}",
'moduleId' => 'resource',
'eventId' => 'resourceModification'
]);
}
return $response->withStatus(204);
}
public function unlinkResources(Request $request, Response $response, array $args)
{
if (!PrivilegeController::hasPrivilege(['privilegeId' => 'add_links', 'userId' => $GLOBALS['id']])) {
return $response->withStatus(403)->withJson(['errors' => 'Service forbidden']);
}
if (!Validator::intVal()->validate($args['resId']) || !ResController::hasRightByResId(['resId' => [$args['resId']], 'userId' => $GLOBALS['id']])) {
return $response->withStatus(403)->withJson(['errors' => 'Resource out of perimeter']);
}
if (!Validator::intVal()->validate($args['id']) || !ResController::hasRightByResId(['resId' => [$args['id']], 'userId' => $GLOBALS['id']])) {
return $response->withStatus(403)->withJson(['errors' => 'Resource to unlink out of perimeter']);
}
ResModel::update([
'postSet' => ['linked_resources' => "linked_resources - '{$args['id']}'"],
'where' => ['res_id = ?'],
'data' => [$args['resId']]
]);
ResModel::update([
'postSet' => ['linked_resources' => "linked_resources - '{$args['resId']}'"],
'where' => ['res_id = ?'],
'data' => [$args['id']]
]);
$linkedResourcesInfo = ResModel::get([
'select' => ['alt_identifier', 'res_id'],
'where' => ['res_id in (?)'],
'data' => [[$args['resId'], $args['id']]]
]);
$linkedResourcesAltIdentifier = array_column($linkedResourcesInfo, 'alt_identifier', 'res_id');
HistoryController::add([
'tableName' => 'res_letterbox',
'recordId' => $args['resId'],
'eventType' => 'UP',
'info' => _LINK_DELETED . " : {$linkedResourcesAltIdentifier[$args['id']]}",
'moduleId' => 'resource',
'eventId' => 'resourceModification'
]);
HistoryController::add([
'tableName' => 'res_letterbox',
'recordId' => $args['id'],
'eventType' => 'UP',
'info' => _LINK_DELETED . " : {$linkedResourcesAltIdentifier[$args['resId']]}",
'moduleId' => 'resource',
'eventId' => 'resourceModification'
]);
return $response->withStatus(204);
}
}