{% extends "base.html" %}
{% load i18n %}
{% block title %}{% translate "Assign MySQL 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 MySQL user access to a database on the same server." %}</div></div><div class="col-12 col-sm-auto"><a href="{% url 'mysql_dbs' %}" class="btn btn-outline-primary d-flex align-items-center justify-content-center gap-2 w-100"><i data-lucide="database"></i>{% translate "MySQL 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 "MySQL" %}</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 MySQL server." %}</div></div></div>
<form method="post" id="mysqlAssignmentForm" 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, user, and privileges to grant." %}</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 class="col-12"><fieldset><legend class="form-label">{% translate "Privileges" %}</legend>
<div class="d-flex flex-column flex-sm-row gap-3 mb-3"><div class="form-check"><input class="form-check-input" type="radio" name="grant" value="all" id="grantAll" checked><label class="form-check-label" for="grantAll">{% translate "All privileges" %}</label></div><div class="form-check"><input class="form-check-input" type="radio" name="grant" value="custom" id="grantCustom"><label class="form-check-label" for="grantCustom">{% translate "Custom privileges" %}</label></div></div>
<div id="customPrivileges" class="row row-cols-2 row-cols-md-3 row-cols-xl-4 g-2 d-none">
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="ALTER" id="grantAlter"><label class="form-check-label" for="grantAlter">ALTER</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="ALTER ROUTINE" id="grantAlterRoutine"><label class="form-check-label" for="grantAlterRoutine">ALTER ROUTINE</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="CREATE" id="grantCreate"><label class="form-check-label" for="grantCreate">CREATE</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="CREATE ROUTINE" id="grantCreateRoutine"><label class="form-check-label" for="grantCreateRoutine">CREATE ROUTINE</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="CREATE TEMPORARY TABLES" id="grantTemp"><label class="form-check-label" for="grantTemp">CREATE TEMPORARY TABLES</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="CREATE VIEW" id="grantView"><label class="form-check-label" for="grantView">CREATE VIEW</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="DELETE" id="grantDelete"><label class="form-check-label" for="grantDelete">DELETE</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="DROP" id="grantDrop"><label class="form-check-label" for="grantDrop">DROP</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="EVENT" id="grantEvent"><label class="form-check-label" for="grantEvent">EVENT</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="EXECUTE" id="grantExecute"><label class="form-check-label" for="grantExecute">EXECUTE</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="INDEX" id="grantIndex"><label class="form-check-label" for="grantIndex">INDEX</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="INSERT" id="grantInsert"><label class="form-check-label" for="grantInsert">INSERT</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="LOCK TABLES" id="grantLock"><label class="form-check-label" for="grantLock">LOCK TABLES</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="REFERENCES" id="grantReferences"><label class="form-check-label" for="grantReferences">REFERENCES</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="SELECT" id="grantSelect"><label class="form-check-label" for="grantSelect">SELECT</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="SHOW VIEW" id="grantShowView"><label class="form-check-label" for="grantShowView">SHOW VIEW</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="TRIGGER" id="grantTrigger"><label class="form-check-label" for="grantTrigger">TRIGGER</label></div></div>
<div class="col"><div class="form-check"><input class="form-check-input grant_option" type="checkbox" name="grant_option" value="UPDATE" id="grantUpdate"><label class="form-check-label" for="grantUpdate">UPDATE</label></div></div>
</div><div id="grantError" class="text-danger small mt-2 d-none">{% translate "Please select at least one custom privilege." %}</div>
</fieldset></div>
</div></div>
<input type="hidden" name="grant" id="grantoption">
<div class="d-flex flex-column flex-sm-row gap-2 mt-3"><button type="button" id="reviewMysqlAssignment" class="btn btn-primary"><i data-lucide="user-check"></i>{% translate "Assign User" %}</button><a href="{% url 'mysql_dbs' %}" class="btn btn-outline-secondary"><i data-lucide="arrow-left"></i>{% translate "Go Back" %}</a></div>
</form>
<div class="modal fade" id="assignMysqlUserModal" tabindex="-1" aria-labelledby="assignMysqlUserTitle" 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="assignMysqlUserTitle"><i data-lucide="user-check"></i>{% translate "Grant Database Access" %}</h2><div class="small text-muted mt-1">{% translate "Review the user, database, and privileges 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 "MySQL user" %}</div><div class="eenos-modal-info-value font-monospace" id="mysqlAssignmentUser"></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="mysqlAssignmentDatabase"></div></div></div>
<div class="eenos-modal-info"><div class="eenos-modal-info-icon"><i data-lucide="shield-check"></i></div><div class="eenos-modal-info-content"><div class="eenos-modal-info-label">{% translate "Privileges" %}</div><div class="eenos-modal-info-value text-break" id="mysqlAssignmentPrivileges"></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 the selected privileges on this database. Review custom privileges carefully." %}</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="confirmMysqlAssignment" 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=$("#mysqlAssignmentForm"),custom=$("#customPrivileges"),error=$("#grantError");
function syncPrivileges(){const active=$("#grantCustom").is(":checked");custom.toggleClass("d-none",!active);error.addClass("d-none");if(active&&!$(".grant_option:checked").length)$(".grant_option").prop("checked",true)}
function grants(){return $("#grantAll").is(":checked")?"ALL":$(".grant_option:checked").map(function(){return this.value}).get().join(",")}
$("input[name=grant]").on("change",syncPrivileges);syncPrivileges();
$("#reviewMysqlAssignment").on("click",function(){const validator=form.parsley();validator.validate();if(!validator.isValid())return;const value=grants();if(!value){error.removeClass("d-none");return}$("#grantoption").val(value);$("#mysqlAssignmentUser").text($("#assignDatabaseUser").val());$("#mysqlAssignmentDatabase").text($("#assignDatabase").val());$("#mysqlAssignmentPrivileges").text(value);bootstrap.Modal.getOrCreateInstance(document.getElementById("assignMysqlUserModal")).show()});
$("#confirmMysqlAssignment").on("click",function(){$("#assignuser").val("yes");document.getElementById("mysqlAssignmentForm").submit()});
})})(jQuery);
</script>{% endblock %}