1 AND
o.data_abertura >= :start AND
o.data_abertura <= :end
{$terms}
{$terms2}
{$filter_areas}
";
try {
$res = $conn->prepare($sql);
$res->bindParam(':start', $post['start']);
$res->bindParam(':end', $post['end']);
if (!empty($worker_id)) {
$res->bindParam(':worker_id', $worker_id);
}
$res->execute();
}
catch (Exception $e) {
$exception .= "
" . $e->getMessage();
echo $exception;
return;
}
$data = array();
$i = 0;
foreach ($res->fetchAll() AS $row) {
$data[$i]['textColor'] = $post['color'];
$data[$i]['borderColor'] = $post['borderColor'];
$data[$i]['backgroundColor'] = $post['bgColor'];
$data[$i]['id'] = $row['numero'];
// $data[$i]['title'] = truncateText(noHtml($row['descricao']), 100);
// $data[$i]['title'] = noHtml($row['descricao']);
$data[$i]['title'] = noHtml($row['numero']);
$data[$i]['descricao'] = $row['descricao'] ?? '';
// $data[$i]['start'] = $row['oco_scheduled_to'];
$data[$i]['start'] = $row['data_abertura'];
// $data[$i]['end'] = $row['data_fechamento'] ?? date('Y-m-d H:i:s');
$data[$i]['url'] = getGlobalUri($conn, $row['numero']);
$data[$i]['contato'] = $row['contato'] ?? '';
$data[$i]['cliente'] = $row['cliente'] ?? '';
$data[$i]['status'] = $row['status'];
$data[$i]['operador'] = $row['operador'] ?? '';
$data[$i]['aberto_por'] = $row['aberto_por'];
$data[$i]['departamento'] = $row['local'] ?? '';
$data[$i]['problema'] = $row['problema'] ?? '';
$data[$i]['area_atendimento'] = $row['area_atendimento'] ?? '';
$data[$i]['area_solicitante'] = $row['area_solicitante'];
$data[$i]['data_abertura'] = dateScreen($row['data_abertura']);
$data[$i]['oco_scheduled_to'] = (!empty($row['oco_scheduled_to']) ? dateScreen($row['oco_scheduled_to']) : '');
$data[$i]['data_fechamento'] = (!empty($row['data_fechamento']) ? dateScreen($row['data_fechamento']) : '');
// $data[$i]['start_date'] = $post['start'];
$workersList = "";
$data[$i]['funcionarios'] = $workersList;
if (!empty($ticketWorkers = getTicketWorkers($conn, $row['numero']))) {
foreach ($ticketWorkers as $worker) {
if (strlen((string)$workersList))
$workersList .= ", ";
$workersList .= $worker['nome'];
}
$data[$i]['funcionarios'] = $workersList;
}
$i++;
// $data[] = $row;
}
// $data[]['start_date'] = $post['start'];
echo json_encode($data);
// echo json_encode([]);
?>