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([]); ?>