1 AND
o.oco_scheduled = 1 AND
o.oco_scheduled_to >= :start AND
o.oco_scheduled_to <= :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) {
if (!empty($worker_id)) {
$data[$i]['textColor'] = $row['mainworker_textcolor'];
$data[$i]['borderColor'] = 'white';
$data[$i]['backgroundColor'] = $row['mainworker_bgcolor'];
} else {
$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]['descricao'] = html2text($row['descricao']);
$data[$i]['start'] = $row['oco_scheduled_to'];
$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'] = dateScreen($row['oco_scheduled_to']);
$data[$i]['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[]['novo'] = "teste";
// $data[]['start_date'] = $post['start'];
echo json_encode($data);
?>