top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_basics_only.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 1); use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $post = (isset($_POST) ? $_POST : []); if (!isset($post['numero']) && !isset($post['project_id'])) { return false; } $data = []; $exception = ""; $data['success'] = true; $data['message'] = ""; $user = (isset($_SESSION['s_uid']) ? (int)$_SESSION['s_uid'] : ''); $data['numero'] = (isset($post['numero']) && !empty($post['numero']) ? (int)$post['numero'] : ''); $data['project_id'] = (isset($post['project_id']) && !empty($post['project_id']) ? (int)$post['project_id'] : ''); $data['name'] = (isset($post['name']) && !empty($post['name']) ? noHtml($post['name']) : ''); $data['description'] = (isset($post['description']) && !empty($post['description']) ? noHtml($post['description']) : ''); $data['action'] = (isset($post['action']) && !empty($post['action']) ? $post['action'] : ''); if (empty($data['action'])) { $data['success'] = false; $data['message'] = message('warning', '', TRANS('MSG_EMPTY_DATA'), ''); $data['field_id'] = "action"; echo json_encode($data); return false; } if (empty($data['name'])) { $data['success'] = false; $data['message'] = message('warning', '', TRANS('MSG_EMPTY_DATA'), ''); $data['field_id'] = "project_name"; echo json_encode($data); return false; } if (empty($data['description'])) { $data['success'] = false; $data['message'] = message('warning', '', TRANS('MSG_EMPTY_DATA'), ''); $data['field_id'] = "project_description"; echo json_encode($data); return false; } /* Checa se de fato pode-se definir um projeto com base no número do chamado informado */ if ($data['action'] == 'new') { $sql = "SELECT * FROM ocodeps WHERE (dep_pai = {$data['numero']} OR dep_filho = {$data['numero']}) AND proj_id IS NULL "; $res = $conn->query($sql); if (!$res->rowCount()) { $data['success'] = false; $data['message'] = message('warning', '', TRANS('MSG_DATA_NOT_QUALIFIED_TO_PROJECT') . "
" . TRANS('MSG_HELPER_NOT_QUALIFIED_TO_PROJECT'), ''); echo json_encode($data); return false; } } if ($data['action'] == "new") { /* Gravação das definições do projeto */ $sql = "INSERT INTO projects SET name = '{$data['name']}', description = '{$data['description']}' "; try { $conn->exec($sql); $data['project_id'] = $conn->lastInsertId(); $data['success'] = true; $storeParent = []; $storeSons = []; $relations = []; $firstOfAll = getFirstFather($conn, $data['numero'], $storeParent); if ($firstOfAll) { $relations = getTicketDownRelations($conn, $firstOfAll, $storeSons); } $ticketNumbers = array_keys($relations); foreach ($ticketNumbers as $ticket) { /* Atualizar a tabela ocodeps com o id do projeto criado */ $sql = "UPDATE ocodeps SET proj_id = {$data['project_id']} WHERE dep_pai = {$ticket} OR dep_filho = {$ticket}"; try { $conn->exec($sql); } catch (Exception $e) { $exception .= "
" . $e->getMessage(); $data['success'] = false; $data['message'] = message('danger', '', TRANS('MSG_ERR_DATA_UPDATE') . $exception, ''); echo json_encode($data); return false; } } } catch (Exception $e) { $exception .= "
" . $e->getMessage(); $data['success'] = false; $data['message'] = message('danger', '', TRANS('MSG_ERR_DATA_UPDATE') . $exception, ''); echo json_encode($data); return false; } } elseif ($data['action'] == "update") { /* Gravação das definições do projeto */ $sql = "UPDATE projects SET name = '{$data['name']}', description = '{$data['description']}' WHERE id = {$data['project_id']} "; try { $conn->exec($sql); $data['success'] = true; } catch (Exception $e) { $exception .= "
" . $e->getMessage(); $data['success'] = false; $data['message'] = message('danger', '', TRANS('MSG_ERR_DATA_UPDATE') . $exception, ''); echo json_encode($data); return false; } } $msgKey = "MSG_SUCCESS_PROJECT_CREATED"; if ($data['action'] == 'update') { $msgKey = "MSG_SUCCESS_PROJECT_UPDATED"; } $_SESSION['flash'] = message('success', '', TRANS($msgKey) . $exception, '', ''); echo json_encode($data); return true;