{% extends "base.html" %}
{% load i18n %}
{% block title %}{% translate "Create PostgreSQL User" %} - Eenos{% endblock %}
{% block content %}
<div class="eenos-page-header flex-wrap gap-3"><div><h1 class="eenos-page-title">{% translate "Create PostgreSQL User" %}</h1><div class="eenos-page-subtitle">{% translate "Create a PostgreSQL database login." %}</div></div><div class="col-12 col-sm-auto"><a href="{% url 'pgsql_users' %}" class="btn btn-outline-primary d-flex align-items-center justify-content-center gap-2 w-100"><i data-lucide="users"></i>{% translate "PostgreSQL Users" %}</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 "Create PostgreSQL User" %}</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 "Server assignment" %}</div><div class="eenos-amber-notice-text">{% translate "A database user can only be assigned to databases hosted on the same PostgreSQL server." %}</div></div></div>
<div class="eenos-amber-notice mb-4" role="status"><div class="eenos-amber-notice-icon"><i data-lucide="info"></i></div><div class="eenos-amber-notice-content"><div class="eenos-amber-notice-title">{% translate "Assign the user after creation" %}</div><div class="eenos-amber-notice-text">{% translate "Creating a PostgreSQL user does not automatically grant database access. After creation, assign the user to the required database." %}</div></div></div>
<form method="post" id="pgsqlUserForm" class="eenos-form" data-parsley-validate>
{% csrf_token %}<input type="hidden" name="user" value="{{ user }}" class="myuser"><input type="hidden" name="create_user" id="createuser">
<div class="eenos-card">
<div class="eenos-card-header"><div><h2 class="eenos-card-title">{% translate "User Details" %}</h2><p class="eenos-card-subtitle">{% translate "Set the username, PostgreSQL server, and password." %}</p></div><div class="eenos-card-action-icon"><i data-lucide="user-round-plus"></i></div></div>
<div class="row g-4">
<div class="col-12 col-lg-6"><label class="form-label" for="pgsqlUsername">{% translate "Database Username" %}</label><div class="input-group"><span class="input-group-text font-monospace">{{ user }}_</span><input type="text" id="pgsqlUsername" class="form-control" name="name" value="{{ form.name.value|default:'' }}" maxlength="{{ user_name_limit }}" autocomplete="off" placeholder="{% translate 'Enter username' %}" required data-parsley-pattern="^((?![_-]).)[\w-]*$(?<![_-])" data-parsley-required-message="{% translate 'Please enter a database username.' %}" data-parsley-pattern-message="{% translate 'Please enter a valid database username.' %}"></div></div>
<div class="col-12 col-lg-6"><label class="form-label" for="pgsqlUserServer">{% translate "PostgreSQL Server" %}</label><select id="pgsqlUserServer" class="form-select eenos-select-search" name="server" required data-parsley-required-message="{% translate 'Please select a PostgreSQL server.' %}"><option value="">{% translate "Select PostgreSQL server" %}</option>{% for server, settings in servers.items %}<option value="{{ server }}" {% if form.server.value == server %}selected{% endif %}>{{ server }} (PostgreSQL {{ settings.version }})</option>{% endfor %}</select></div>
<div class="col-12 col-lg-7 col-xl-6"><label class="form-label" for="pgsqlUserPassword">{% translate "Password" %}</label><div class="eenos-password-generator"><div class="input-group"><div class="eenos-password-control"><input type="password" id="pgsqlUserPassword" class="form-control eenos-password-input" name="password" required minlength="8" autocomplete="new-password" placeholder="{% translate 'Enter a password' %}" data-parsley-required-message="{% translate 'Please enter a password for the PostgreSQL user.' %}" data-parsley-minlength-message="{% translate 'The password must contain at least 8 characters.' %}"></div><button type="button" class="btn btn-outline-secondary eenos-password-toggle" title="{% translate 'Show password' %}" aria-label="{% translate 'Show password' %}"><i data-lucide="eye"></i></button><button type="button" class="btn btn-outline-primary eenos-password-generate" title="{% translate 'Generate secure password' %}"><i data-lucide="wand-sparkles"></i><span class="d-none d-sm-inline">{% translate "Generate" %}</span></button></div><div class="eenos-password-strength mt-2"><div class="progress" style="height:5px"><div class="progress-bar eenos-password-strength-progress"></div></div><small class="eenos-password-strength-text text-muted"></small></div></div></div>
</div></div>
<div class="d-flex flex-column flex-sm-row gap-2 mt-3"><button type="button" id="reviewPgsqlUser" class="btn btn-primary"><i data-lucide="user-round-plus"></i>{% translate "Create PostgreSQL User" %}</button><a href="{% url 'pgsql_users' %}" class="btn btn-outline-secondary"><i data-lucide="arrow-left"></i>{% translate "Go Back" %}</a></div>
</form>
<div class="modal fade" id="createPgsqlUserModal" tabindex="-1" aria-labelledby="createPgsqlUserTitle" 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" id="createPgsqlUserTitle">{% translate "Create PostgreSQL User" %}</h2><div class="small text-muted mt-1">{% translate "Confirm the new database login." %}</div></div><button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="{% translate 'Close' %}"></button></div>
<div class="modal-body"><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="pgsqlUserLabel"></div></div></div></div>
<div class="modal-footer"><button type="button" class="btn btn-outline-secondary" data-bs-dismiss="modal">{% translate "Cancel" %}</button><button type="button" id="confirmPgsqlUser" class="btn btn-primary"><i data-lucide="check"></i>{% translate "Create User" %}</button></div>
</div></div></div>
{% endblock %}
{% block extra_js %}
<script>
(function($){"use strict";$(function(){
const form=$("#pgsqlUserForm");
$("#reviewPgsqlUser").on("click",function(){const validator=form.parsley();validator.validate();if(!validator.isValid())return;$("#pgsqlUserLabel").text($(".myuser").val()+"_"+$("#pgsqlUsername").val().trim());bootstrap.Modal.getOrCreateInstance(document.getElementById("createPgsqlUserModal")).show()});
$("#confirmPgsqlUser").on("click",function(){$("#createuser").val("yes");document.getElementById("pgsqlUserForm").submit()});
})})(jQuery);
</script>
{% endblock %}