top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_basics_only.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $post = $_POST; $exception = ""; $data = []; $data['success'] = true; /* update | create | delete */ $data['action'] = (isset($post['action']) && !empty($post['action']) ? noHtml($post['action']) : ""); if (empty($data['action'])) { $data['success'] = false; $data['field_id'] = "action"; $data['message'] = message('warning', 'Ooops!', TRANS('SOME_ERROR_DONT_PROCEED'),''); echo json_encode($data); return false; } $data['cod'] = (isset($post['cod']) ? intval($post['cod']) : ""); $data['message'] = ""; $data['field_id'] = ""; $data['author'] = $_SESSION['s_uid']; $data['csrf_session_key'] = (isset($post['csrf_session_key']) ? $post['csrf_session_key'] : "csrf_token"); $data['material'] = (isset($post['material']) && !empty($post['material']) ? noHtml($post['material']) : ""); $data['taker'] = (isset($post['taker']) && !empty($post['taker']) ? noHtml($post['taker']) : ""); $data['phone'] = (isset($post['phone']) && !empty($post['phone']) ? noHtml($post['phone']) : ""); $data['department'] = (isset($post['department']) && !empty($post['department']) ? (int)$post['department'] : ""); $data['authorizer'] = (isset($post['authorizer']) && !empty($post['authorizer']) ? (int)$post['authorizer'] : ""); $data['borrow_date'] = (isset($post['borrow_date']) && !empty($post['borrow_date']) ? noHtml($post['borrow_date']) : ""); $data['return_date'] = (isset($post['return_date']) && !empty($post['return_date']) ? noHtml($post['return_date']) : null); if ($data['action'] == "create" || $data['action'] == "update") { if (empty($data['material'])) { $data['success'] = false; $data['field_id'] = "material"; $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } if (empty($data['taker'])) { $data['success'] = false; $data['field_id'] = "taker"; $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } if (empty($data['phone'])) { $data['success'] = false; $data['field_id'] = "phone"; $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } if (empty($data['department'])) { $data['success'] = false; $data['field_id'] = "department"; $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } if (empty($data['authorizer'])) { $data['success'] = false; $data['field_id'] = "authorizer"; $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } if (empty($data['borrow_date'])) { $data['success'] = false; $data['field_id'] = "borrow_date"; $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),''); echo json_encode($data); return false; } $start_time = ' 00:00:00'; $end_time = ' 23:59:59'; if (!isValidDate($data['borrow_date'])) { $data['success'] = false; $data['field_id'] = "borrow_date"; $data['message'] = message('warning', 'Ooops!', TRANS('BAD_FIELD_FORMAT'),''); echo json_encode($data); return false; } $data['borrow_date'] = dateDB($data['borrow_date'] . date(' H:i:s')); if (!empty($data['return_date'])) { if (!isValidDate($data['return_date'])) { $data['success'] = false; $data['field_id'] = "return_date"; $data['message'] = message('warning', 'Ooops!', TRANS('BAD_FIELD_FORMAT'),''); echo json_encode($data); return false; } $data['return_date'] = dateDB($data['return_date'] . date(' H:i:s')); } } if ($data['action'] == "create") { if (!csrf_verify($post, $data['csrf_session_key'])) { $data['success'] = false; $data['message'] = message('warning', 'Ooops!', TRANS('FORM_ALREADY_SENT'),''); echo json_encode($data); return false; } $sql = "INSERT INTO emprestimos (material, responsavel, data_empr, data_devol, quem, local, ramal) VALUES (:material, :responsavel, :data_empr, :data_devol, :quem, :local, :ramal) "; try { $res = $conn->prepare($sql); $res->bindParam(':material', $data['material'], PDO::PARAM_STR); $res->bindParam(':responsavel', $data['authorizer'], PDO::PARAM_INT); $res->bindParam(':data_empr', $data['borrow_date'], PDO::PARAM_STR); $res->bindParam(':data_devol', $data['return_date']); $res->bindParam(':quem', $data['taker'], PDO::PARAM_STR); $res->bindParam(':local', $data['department'], PDO::PARAM_INT); $res->bindParam(':ramal', $data['phone'], PDO::PARAM_INT); $res->execute(); /* Notificação para o usuário marcado como responsável */ $sentNotification = false; if ($data['author'] != $data['authorizer']) { $sentNotification = setUserNotification($conn, $data['authorizer'], 1, TRANS('MSG_YOU_WERE_SET_AS_RESPONSIBLE_FOR_BORROWED_ITEM'), $data['author']); } $data['message'] = TRANS('MSG_SUCCESS_INSERT'); $_SESSION['flash'] = message('success', 'Yeahh!', $data['message'] . $exception, '', ''); echo json_encode($data); return false; } catch (PDOException $e) { $exception .= "