From 3023c48771293fe8e3b431cd8ef1ab0323a52333 Mon Sep 17 00:00:00 2001 From: Hugo Sampaio Date: Tue, 4 Jun 2024 15:03:53 -0300 Subject: [PATCH 1/3] link file to assets provides hability to add link on Files to Assets, so later we can show this related files on Asset View --- client_file_link_asset_modal.php | 84 ++++++++++++++++++++++++++++++++ client_files.php | 5 ++ post/file.php | 37 ++++++++++++++ 3 files changed, 126 insertions(+) create mode 100644 client_file_link_asset_modal.php diff --git a/client_file_link_asset_modal.php b/client_file_link_asset_modal.php new file mode 100644 index 000000000..754e2b992 --- /dev/null +++ b/client_file_link_asset_modal.php @@ -0,0 +1,84 @@ + diff --git a/client_files.php b/client_files.php index f21eca9fa..ff6ab8128 100644 --- a/client_files.php +++ b/client_files.php @@ -331,6 +331,9 @@ Move + + Asset +
Archive @@ -348,6 +351,8 @@ require "client_file_move_modal.php"; + require "client_file_link_asset_modal.php"; + } ?> diff --git a/post/file.php b/post/file.php index dd6b28e8b..7f3d6b4b8 100644 --- a/post/file.php +++ b/post/file.php @@ -182,3 +182,40 @@ header("Location: " . $_SERVER["HTTP_REFERER"]); } + +if (isset($_POST['link_asset_to_file'])) { + + validateTechRole(); + + $client_id = intval($_POST['client_id']); + $file_id = intval($_POST['file_id']); + $asset_id = intval($_POST['asset_id']); + + // Contact add query + mysqli_query($mysqli,"INSERT INTO asset_files SET asset_id = $asset_id, file_id = $file_id"); + + // Logging + mysqli_query($mysqli,"INSERT INTO logs SET log_type = 'File', log_action = 'Link', log_description = 'Created File Asset link', log_ip = '$session_ip', log_user_agent = '$session_user_agent', log_client_id = $client_id, log_user_id = $session_user_id"); + + $_SESSION['alert_message'] = "Asset linked with File"; + + header("Location: " . $_SERVER["HTTP_REFERER"]); + +} + +if (isset($_GET['unlink_asset_from_file'])) { + + validateTechRole(); + $asset_id = intval($_GET['asset_id']); + $file_id = intval($_GET['file_id']); + + mysqli_query($mysqli,"DELETE FROM asset_files WHERE asset_id = $asset_id AND file_id = $file_id"); + + //Logging + mysqli_query($mysqli,"INSERT INTO logs SET log_type = 'File', log_action = 'unLink', log_description = 'File Asset link removed', log_ip = '$session_ip', log_user_agent = '$session_user_agent', log_user_id = $session_user_id"); + + $_SESSION['alert_message'] = "Asset has been unlinked"; + + header("Location: " . $_SERVER["HTTP_REFERER"]); + +} \ No newline at end of file From 87069b7ebb8106023fcf9815255bc7f1d7d807c6 Mon Sep 17 00:00:00 2001 From: Hugo Sampaio Date: Tue, 4 Jun 2024 15:55:57 -0300 Subject: [PATCH 2/3] forgoten modal identifier --- client_file_link_asset_modal.php | 2 +- client_files.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/client_file_link_asset_modal.php b/client_file_link_asset_modal.php index 754e2b992..a002f16f4 100644 --- a/client_file_link_asset_modal.php +++ b/client_file_link_asset_modal.php @@ -1,4 +1,4 @@ -