opensupports/server/controllers/ticket/change-department.php
Maximiliano Redigonda c5d6068e97
Add statistics (#904)
* Adds first_closed_at and last_closed_at to Ticket

* Fixes ticket isClosed function

* Adds reopened column to Ticket table

* Adds stats path

* Adds stats for instant tickets

* Adds basic connection with frontend

* Creates cards to display ticketData

* Adds tooltips with descriptions and i18n

* Adds date range filter to backend

* Adds DateRange filter on frontend

* Documents and better structures code

* Makes $dateRange local

* Adds departments filter on backend

* Adds stats path to menu

* Adds first UI for departments filter in stats

* Implements departments filter on frontend

* Improves styling by adding bootstrap rows

* Improves structure of dynamics queries

* Adds tags filter on backend

* Adding TagFilter for statistics WIP

* Adds missing `id` to propTypes TagSelector

* Removes console.warns

* Adapts form to pass tagnames as value as FormField

* Sends tags to API too

* Makes tag-selector change form with tagnames only

* Fixes tag-selector from ticket-viewer

* Removes console.warn

* Removes logs

* Adds owner filter on backend

* Connects owners frontend with backend for stats

* Style changes for date-selector

* Adds tickets by hours stat to /system/stats path

* Adds chart for tickets created on each hour

* Adds better wrap for ticketdata cards

* Adds getAverageFirstReply to backend stats path

* Adds getNumberOfCreatedTicketsByWeekday to backend

* Adds created tickets by weekday chart

* Disables clicking on the legend to toggle data

* Adds base functions for efficiency stats

* Adds getAverageFirstClosed to backend stats

* Adds getAverageLastClosed to backend stats

* Adds table, filters, and groupBy variables to queries

* Adds response structure with mocks

* Adds totalOwners and totalDepartments

* Adds SQL queries to get department/staff hops of a ticket

* Changes incorrect name

* Rolls back addition of near useless function

* Improves tag array management from redux store

* Fix bug in autocomplete filters.

* Sets default date range to current month.

improves date.js.

* Adds i18n

* wip

* Add media query in admin-panel-stats.scss

* Updates date handling in search-ticket-utils

* Makes tooltip open on hover of the entire block

* Fix date range mobile style.

* Add Loading

* Add submit button and clear button in admin panel stats

* Adds tests for stats and comments old ones

* Add test for stats after a ticket has been created

* Makes default dateRange for stats go to the end of the day

* Factors out function to create ticket and adds test

* Adds instant ticket test

* Adds reopened test

* Commit to save technique to test created_by_hour but is prohibitively slow.

* Updates test of created_by_hour to be more lightweight

* Adds test for created_by_weekday

* Fixes default date and renames a function

* Fixes hover bug by extracting card-stat to its own component

* Fix drawbacks with previous change in style - mobile

Co-authored-by: LautaroCesso <lautaro_cesso@hotmail.com>

* Set up 0 as a minimum number for bar chart

* Moves styles from stats cards to the component

* Removes old /system/get-stats path

* Changes name from /system/stats to /system/get-stats

* Restore getCurrentDate in date transformer

Co-authored-by: LautaroCesso <lautaro_cesso@hotmail.com>
Co-authored-by: Ivan Diaz <ivan@opensupports.com>
2020-12-27 16:22:55 -03:00

88 lines
2.7 KiB
PHP
Executable File

<?php
use Respect\Validation\Validator as DataValidator;
DataValidator::with('CustomValidations', true);
/**
* @api {post} /ticket/change-department Change department
* @apiVersion 4.8.0
*
* @apiName Change department
*
* @apiGroup Ticket
*
* @apiDescription This path changes the department of a ticket.
*
* @apiPermission staff1
*
* @apiParam {Number} ticketNumber The number of the ticket.
* @apiParam {Number} departmentId The id of the new department of the ticket.
*
* @apiUse NO_PERMISSION
* @apiUse INVALID_TICKET
* @apiUse INVALID_DEPARTMENT
*
* @apiSuccess {Object} data Empty object
*
*/
class ChangeDepartmentController extends Controller {
const PATH = '/change-department';
const METHOD = 'POST';
public function validations() {
return [
'permission' => 'staff_1',
'requestData' => [
'ticketNumber' => [
'validation' => DataValidator::validTicketNumber(),
'error' => ERRORS::INVALID_TICKET
],
'departmentId' => [
'validation' => DataValidator::dataStoreId('department'),
'error' => ERRORS::INVALID_DEPARTMENT
]
]
];
}
public function handler() {
$ticketNumber = Controller::request('ticketNumber');
$departmentId = Controller::request('departmentId');
$ticket = Ticket::getByTicketNumber($ticketNumber);
$department = Department::getDataStore($departmentId);
$user = Controller::getLoggedUser();
if(!$ticket->authorStaffId && $department->private){
throw new Exception(ERRORS::NO_PERMISSION);
}
if(!$user->canManageTicket($ticket)){
throw new RequestException(ERRORS::NO_PERMISSION);
}
if($ticket->owner && !$ticket->owner->sharedDepartmentList->includesId($department->id)) {
$unAssignTicketController = new UnAssignStaffController($user);
$unAssignTicketController->validate();
$unAssignTicketController->handler();
}
$ticket = Ticket::getByTicketNumber($ticketNumber);
$event = Ticketevent::getEvent(Ticketevent::DEPARTMENT_CHANGED);
$event->setProperties(array(
'authorStaff' => $user,
'content' => $department->name,
'date' => Date::getCurrentDate()
));
$ticket->addEvent($event);
$ticket->department = $department;
$ticket->totalDepartments++;
$ticket->unread = !$ticket->isAuthor($user);
$ticket->store();
Log::createLog('DEPARTMENT_CHANGED', $ticket->ticketNumber);
Response::respondSuccess();
}
}