{% extends "base.html" %}
{% load i18n %}
{% block title %}{% translate "Assign PostgreSQL User" %} - Eenos{% endblock %}
{% block content %}
<div class="eenos-page-header flex-wrap gap-3"><div><h1 class="eenos-page-title">{% translate "Assign User to Database" %}</h1><div class="eenos-page-subtitle">{% translate "Grant a PostgreSQL user access to a database on the same server." %}</div></div><div class="col-12 col-sm-auto"><a href="{% url 'pgsql_dbs' %}" class="btn btn-outline-primary d-flex align-items-center justify-content-center gap-2 w-100"><i data-lucide="database"></i>{% translate "PostgreSQL Databases" %}</a></div></div>
<nav class="eenos-breadcrumb" aria-label="{% translate 'Breadcrumb' %}"><a href="{% url 'dashboard' %}">{% translate "Dashboard" %}</a><span class="eenos-breadcrumb-separator"><i data-lucide="chevron-right"></i></span><span>{% translate "Databases" %}</span><span class="eenos-breadcrumb-separator"><i data-lucide="chevron-right"></i></span><span>{% translate "PostgreSQL" %}</span><span class="eenos-breadcrumb-separator"><i data-lucide="chevron-right"></i></span><span class="eenos-breadcrumb-current">{% translate "Assign User to Database" %}</span></nav>
{% include "includes/form_alerts.html" %}
<div class="eenos-amber-notice eenos-amber-notice-warning mb-4" role="alert"><div class="eenos-amber-notice-icon"><i data-lucide="server"></i></div><div class="eenos-amber-notice-content"><div class="eenos-amber-notice-title">{% translate "Same server required" %}</div><div class="eenos-amber-notice-text">{% translate "The selected user and database must be hosted on the same PostgreSQL server." %}</div></div></div>
<form method="post" id="pgsqlAssignmentForm" class="eenos-form" data-parsley-validate>
{% csrf_token %}
<input type="hidden" name="user" value="{{ user }}" class="myuser">
<input type="hidden" name="assign_user" id="assignuser">
<div class="eenos-card">
<div class="eenos-card-header"><div><h2 class="eenos-card-title">{% translate "Database Access" %}</h2><p class="eenos-card-subtitle">{% translate "Select the database and PostgreSQL user." %}</p></div><div class="eenos-card-action-icon"><i data-lucide="user-round-cog"></i></div></div>
<div class="row g-4">
<div class="col-12 col-lg-6"><label class="form-label" for="assignDatabase">{% translate "Database" %}</label><select class="form-select eenos-select-search" id="assignDatabase" name="db" required data-parsley-required-message="{% translate 'Please select a database.' %}"><option value="">{% translate "Select database" %}</option>{% for database, settings in dbs.items %}<option value="{{ database }}">{{ database }} ({{ settings.host }})</option>{% endfor %}</select></div>
<div class="w-100"></div>
<div class="col-12 col-lg-6"><label class="form-label" for="assignDatabaseUser">{% translate "Database User" %}</label><select class="form-select eenos-select-search" id="assignDatabaseUser" name="dbuser" required data-parsley-required-message="{% translate 'Please select a database user.' %}"><option value="">{% translate "Select database user" %}</option>{% for dbuser, settings in users.items %}<option value="{{ dbuser }}">{{ dbuser }} ({{ settings.host }})</option>{% endfor %}</select></div>
</div></div>
<div class="d-flex flex-column flex-sm-row gap-2 mt-3"><button type="button" id="reviewPgsqlAssignment" class="btn btn-primary"><i data-lucide="user-check"></i>{% translate "Assign User" %}</button><a href="{% url 'pgsql_dbs' %}" class="btn btn-outline-secondary"><i data-lucide="arrow-left"></i>{% translate "Go Back" %}</a></div>
</form>
<div class="modal fade" id="assignPgsqlUserModal" tabindex="-1" aria-labelledby="assignPgsqlUserTitle" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered"><div class="modal-content">
<div class="modal-header"><div><h2 class="modal-title fs-5 d-flex align-items-center gap-2" id="assignPgsqlUserTitle"><i data-lucide="user-check"></i>{% translate "Grant Database Access" %}</h2><div class="small text-muted mt-1">{% translate "Review the user and database before continuing." %}</div></div><button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="{% translate 'Close' %}"></button></div>
<div class="modal-body">
<div class="d-grid gap-3 mb-4">
<div class="eenos-modal-info"><div class="eenos-modal-info-icon"><i data-lucide="user"></i></div><div class="eenos-modal-info-content"><div class="eenos-modal-info-label">{% translate "PostgreSQL user" %}</div><div class="eenos-modal-info-value font-monospace" id="pgsqlAssignmentUser"></div></div></div>
<div class="eenos-modal-info"><div class="eenos-modal-info-icon"><i data-lucide="database"></i></div><div class="eenos-modal-info-content"><div class="eenos-modal-info-label">{% translate "Database" %}</div><div class="eenos-modal-info-value font-monospace" id="pgsqlAssignmentDatabase"></div></div></div>
</div>
<div class="eenos-amber-notice eenos-amber-notice-warning mb-0" role="alert"><div class="eenos-amber-notice-icon"><i data-lucide="triangle-alert"></i></div><div class="eenos-amber-notice-content"><div class="eenos-amber-notice-title">{% translate "Database access will be granted" %}</div><div class="eenos-amber-notice-text">{% translate "The user will immediately receive access to this PostgreSQL database." %}</div></div></div>
</div>
<div class="modal-footer"><button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal"><i data-lucide="arrow-left"></i>{% translate "Review Selection" %}</button><button type="button" id="confirmPgsqlAssignment" class="btn btn-primary"><i data-lucide="user-check"></i>{% translate "Grant Access" %}</button></div>
</div></div></div>
{% endblock %}
{% block extra_js %}<script>
(function($){"use strict";$(function(){
const form=$("#pgsqlAssignmentForm");
$("#reviewPgsqlAssignment").on("click",function(){const validator=form.parsley();validator.validate();if(!validator.isValid())return;$("#pgsqlAssignmentUser").text($("#assignDatabaseUser").val());$("#pgsqlAssignmentDatabase").text($("#assignDatabase").val());bootstrap.Modal.getOrCreateInstance(document.getElementById("assignPgsqlUserModal")).show()});
$("#confirmPgsqlAssignment").on("click",function(){$("#assignuser").val("yes");document.getElementById("pgsqlAssignmentForm").submit()});
})})(jQuery);
</script>{% endblock %}