gilour

Back Back Up Advanced Editor

<?php
use phpformbuilder\Form;
use phpformbuilder\Validator\Validator;
use phpformbuilder\database\DB;
use common\Utils;
use secure\Secure;

include_once ADMIN_DIR . 'secure/class/secure/Secure.php';

$debug_content = '';

/* =============================================
    validation if posted
============================================= */

if ($_SERVER["REQUEST_METHOD"] == "POST" && Form::testToken('form-edit-phpcg-users-profiles') === true) {
    $validator = Form::validate('form-edit-phpcg-users-profiles', FORMVALIDATION_PHP_LANG);
    $validator->required()->validate('profile_name');
    $validator->maxLength(100)->validate('profile_name');
    $validator->required()->validate('r_assess_bi');
    $validator->integer()->validate('r_assess_bi');
    $validator->min(-9)->validate('r_assess_bi');
    $validator->max(9)->validate('r_assess_bi');
    $validator->required()->validate('u_assess_bi');
    $validator->integer()->validate('u_assess_bi');
    $validator->min(-9)->validate('u_assess_bi');
    $validator->max(9)->validate('u_assess_bi');
    $validator->required()->validate('cd_assess_bi');
    $validator->integer()->validate('cd_assess_bi');
    $validator->min(-9)->validate('cd_assess_bi');
    $validator->max(9)->validate('cd_assess_bi');
    $validator->maxLength(255)->validate('cq_assess_bi');
    $validator->required()->validate('r_assessment');
    $validator->integer()->validate('r_assessment');
    $validator->min(-9)->validate('r_assessment');
    $validator->max(9)->validate('r_assessment');
    $validator->required()->validate('u_assessment');
    $validator->integer()->validate('u_assessment');
    $validator->min(-9)->validate('u_assessment');
    $validator->max(9)->validate('u_assessment');
    $validator->required()->validate('cd_assessment');
    $validator->integer()->validate('cd_assessment');
    $validator->min(-9)->validate('cd_assessment');
    $validator->max(9)->validate('cd_assessment');
    $validator->maxLength(255)->validate('cq_assessment');
    $validator->required()->validate('r_assessment_by_assessor');
    $validator->integer()->validate('r_assessment_by_assessor');
    $validator->min(-9)->validate('r_assessment_by_assessor');
    $validator->max(9)->validate('r_assessment_by_assessor');
    $validator->required()->validate('u_assessment_by_assessor');
    $validator->integer()->validate('u_assessment_by_assessor');
    $validator->min(-9)->validate('u_assessment_by_assessor');
    $validator->max(9)->validate('u_assessment_by_assessor');
    $validator->required()->validate('cd_assessment_by_assessor');
    $validator->integer()->validate('cd_assessment_by_assessor');
    $validator->min(-9)->validate('cd_assessment_by_assessor');
    $validator->max(9)->validate('cd_assessment_by_assessor');
    $validator->maxLength(255)->validate('cq_assessment_by_assessor');
    $validator->required()->validate('r_behavioral_indicator');
    $validator->integer()->validate('r_behavioral_indicator');
    $validator->min(-9)->validate('r_behavioral_indicator');
    $validator->max(9)->validate('r_behavioral_indicator');
    $validator->required()->validate('u_behavioral_indicator');
    $validator->integer()->validate('u_behavioral_indicator');
    $validator->min(-9)->validate('u_behavioral_indicator');
    $validator->max(9)->validate('u_behavioral_indicator');
    $validator->required()->validate('cd_behavioral_indicator');
    $validator->integer()->validate('cd_behavioral_indicator');
    $validator->min(-9)->validate('cd_behavioral_indicator');
    $validator->max(9)->validate('cd_behavioral_indicator');
    $validator->maxLength(255)->validate('cq_behavioral_indicator');
    $validator->required()->validate('r_company');
    $validator->integer()->validate('r_company');
    $validator->min(-9)->validate('r_company');
    $validator->max(9)->validate('r_company');
    $validator->required()->validate('u_company');
    $validator->integer()->validate('u_company');
    $validator->min(-9)->validate('u_company');
    $validator->max(9)->validate('u_company');
    $validator->required()->validate('cd_company');
    $validator->integer()->validate('cd_company');
    $validator->min(-9)->validate('cd_company');
    $validator->max(9)->validate('cd_company');
    $validator->maxLength(255)->validate('cq_company');
    $validator->required()->validate('r_competency');
    $validator->integer()->validate('r_competency');
    $validator->min(-9)->validate('r_competency');
    $validator->max(9)->validate('r_competency');
    $validator->required()->validate('u_competency');
    $validator->integer()->validate('u_competency');
    $validator->min(-9)->validate('u_competency');
    $validator->max(9)->validate('u_competency');
    $validator->required()->validate('cd_competency');
    $validator->integer()->validate('cd_competency');
    $validator->min(-9)->validate('cd_competency');
    $validator->max(9)->validate('cd_competency');
    $validator->maxLength(255)->validate('cq_competency');
    $validator->required()->validate('r_competency_type');
    $validator->integer()->validate('r_competency_type');
    $validator->min(-9)->validate('r_competency_type');
    $validator->max(9)->validate('r_competency_type');
    $validator->required()->validate('u_competency_type');
    $validator->integer()->validate('u_competency_type');
    $validator->min(-9)->validate('u_competency_type');
    $validator->max(9)->validate('u_competency_type');
    $validator->required()->validate('cd_competency_type');
    $validator->integer()->validate('cd_competency_type');
    $validator->min(-9)->validate('cd_competency_type');
    $validator->max(9)->validate('cd_competency_type');
    $validator->maxLength(255)->validate('cq_competency_type');
    $validator->required()->validate('r_field');
    $validator->integer()->validate('r_field');
    $validator->min(-9)->validate('r_field');
    $validator->max(9)->validate('r_field');
    $validator->required()->validate('u_field');
    $validator->integer()->validate('u_field');
    $validator->min(-9)->validate('u_field');
    $validator->max(9)->validate('u_field');
    $validator->required()->validate('cd_field');
    $validator->integer()->validate('cd_field');
    $validator->min(-9)->validate('cd_field');
    $validator->max(9)->validate('cd_field');
    $validator->maxLength(255)->validate('cq_field');
    $validator->required()->validate('r_industry');
    $validator->integer()->validate('r_industry');
    $validator->min(-9)->validate('r_industry');
    $validator->max(9)->validate('r_industry');
    $validator->required()->validate('u_industry');
    $validator->integer()->validate('u_industry');
    $validator->min(-9)->validate('u_industry');
    $validator->max(9)->validate('u_industry');
    $validator->required()->validate('cd_industry');
    $validator->integer()->validate('cd_industry');
    $validator->min(-9)->validate('cd_industry');
    $validator->max(9)->validate('cd_industry');
    $validator->maxLength(255)->validate('cq_industry');
    $validator->required()->validate('r_position');
    $validator->integer()->validate('r_position');
    $validator->min(-9)->validate('r_position');
    $validator->max(9)->validate('r_position');
    $validator->required()->validate('u_position');
    $validator->integer()->validate('u_position');
    $validator->min(-9)->validate('u_position');
    $validator->max(9)->validate('u_position');
    $validator->required()->validate('cd_position');
    $validator->integer()->validate('cd_position');
    $validator->min(-9)->validate('cd_position');
    $validator->max(9)->validate('cd_position');
    $validator->maxLength(255)->validate('cq_position');
    $validator->required()->validate('r_position_competency');
    $validator->integer()->validate('r_position_competency');
    $validator->min(-9)->validate('r_position_competency');
    $validator->max(9)->validate('r_position_competency');
    $validator->required()->validate('u_position_competency');
    $validator->integer()->validate('u_position_competency');
    $validator->min(-9)->validate('u_position_competency');
    $validator->max(9)->validate('u_position_competency');
    $validator->required()->validate('cd_position_competency');
    $validator->integer()->validate('cd_position_competency');
    $validator->min(-9)->validate('cd_position_competency');
    $validator->max(9)->validate('cd_position_competency');
    $validator->maxLength(255)->validate('cq_position_competency');
    $validator->required()->validate('r_project');
    $validator->integer()->validate('r_project');
    $validator->min(-9)->validate('r_project');
    $validator->max(9)->validate('r_project');
    $validator->required()->validate('u_project');
    $validator->integer()->validate('u_project');
    $validator->min(-9)->validate('u_project');
    $validator->max(9)->validate('u_project');
    $validator->required()->validate('cd_project');
    $validator->integer()->validate('cd_project');
    $validator->min(-9)->validate('cd_project');
    $validator->max(9)->validate('cd_project');
    $validator->maxLength(255)->validate('cq_project');
    $validator->required()->validate('r_phpcg_users');
    $validator->integer()->validate('r_phpcg_users');
    $validator->min(-9)->validate('r_phpcg_users');
    $validator->max(9)->validate('r_phpcg_users');
    $validator->required()->validate('u_phpcg_users');
    $validator->integer()->validate('u_phpcg_users');
    $validator->min(-9)->validate('u_phpcg_users');
    $validator->max(9)->validate('u_phpcg_users');
    $validator->required()->validate('cd_phpcg_users');
    $validator->integer()->validate('cd_phpcg_users');
    $validator->min(-9)->validate('cd_phpcg_users');
    $validator->max(9)->validate('cd_phpcg_users');
    $validator->maxLength(255)->validate('cq_phpcg_users');
    $validator->required()->validate('r_phpcg_users_profiles');
    $validator->integer()->validate('r_phpcg_users_profiles');
    $validator->min(-9)->validate('r_phpcg_users_profiles');
    $validator->max(9)->validate('r_phpcg_users_profiles');
    $validator->required()->validate('u_phpcg_users_profiles');
    $validator->integer()->validate('u_phpcg_users_profiles');
    $validator->min(-9)->validate('u_phpcg_users_profiles');
    $validator->max(9)->validate('u_phpcg_users_profiles');
    $validator->required()->validate('cd_phpcg_users_profiles');
    $validator->integer()->validate('cd_phpcg_users_profiles');
    $validator->min(-9)->validate('cd_phpcg_users_profiles');
    $validator->max(9)->validate('cd_phpcg_users_profiles');
    $validator->maxLength(255)->validate('cq_phpcg_users_profiles');

// check for errors
    if ($validator->hasErrors()) {
        $_SESSION['errors']['form-edit-phpcg-users-profiles'] = $validator->getAllErrors();
    } else {
        require_once CLASS_DIR . 'phpformbuilder/database/db-connect.php';
        require_once CLASS_DIR . 'phpformbuilder/database/DB.php';
        $db = new DB(DEBUG);
        $db->setDebugMode('register');
        $values = array();
        $values['profile_name'] = $_POST['profile_name'];
        if (is_array($_POST['r_assess_bi'])) {
            $json_values = json_encode($_POST['r_assess_bi'], JSON_UNESCAPED_UNICODE);
            $values['r_assess_bi'] = $json_values;
        } else {
            $values['r_assess_bi'] = intval($_POST['r_assess_bi']);
        }
        if (is_array($_POST['u_assess_bi'])) {
            $json_values = json_encode($_POST['u_assess_bi'], JSON_UNESCAPED_UNICODE);
            $values['u_assess_bi'] = $json_values;
        } else {
            $values['u_assess_bi'] = intval($_POST['u_assess_bi']);
        }
        if (is_array($_POST['cd_assess_bi'])) {
            $json_values = json_encode($_POST['cd_assess_bi'], JSON_UNESCAPED_UNICODE);
            $values['cd_assess_bi'] = $json_values;
        } else {
            $values['cd_assess_bi'] = intval($_POST['cd_assess_bi']);
        }
        $values['cq_assess_bi'] = $_POST['cq_assess_bi'];
        if (is_array($_POST['r_assessment'])) {
            $json_values = json_encode($_POST['r_assessment'], JSON_UNESCAPED_UNICODE);
            $values['r_assessment'] = $json_values;
        } else {
            $values['r_assessment'] = intval($_POST['r_assessment']);
        }
        if (is_array($_POST['u_assessment'])) {
            $json_values = json_encode($_POST['u_assessment'], JSON_UNESCAPED_UNICODE);
            $values['u_assessment'] = $json_values;
        } else {
            $values['u_assessment'] = intval($_POST['u_assessment']);
        }
        if (is_array($_POST['cd_assessment'])) {
            $json_values = json_encode($_POST['cd_assessment'], JSON_UNESCAPED_UNICODE);
            $values['cd_assessment'] = $json_values;
        } else {
            $values['cd_assessment'] = intval($_POST['cd_assessment']);
        }
        $values['cq_assessment'] = $_POST['cq_assessment'];
        if (is_array($_POST['r_assessment_by_assessor'])) {
            $json_values = json_encode($_POST['r_assessment_by_assessor'], JSON_UNESCAPED_UNICODE);
            $values['r_assessment_by_assessor'] = $json_values;
        } else {
            $values['r_assessment_by_assessor'] = intval($_POST['r_assessment_by_assessor']);
        }
        if (is_array($_POST['u_assessment_by_assessor'])) {
            $json_values = json_encode($_POST['u_assessment_by_assessor'], JSON_UNESCAPED_UNICODE);
            $values['u_assessment_by_assessor'] = $json_values;
        } else {
            $values['u_assessment_by_assessor'] = intval($_POST['u_assessment_by_assessor']);
        }
        if (is_array($_POST['cd_assessment_by_assessor'])) {
            $json_values = json_encode($_POST['cd_assessment_by_assessor'], JSON_UNESCAPED_UNICODE);
            $values['cd_assessment_by_assessor'] = $json_values;
        } else {
            $values['cd_assessment_by_assessor'] = intval($_POST['cd_assessment_by_assessor']);
        }
        $values['cq_assessment_by_assessor'] = $_POST['cq_assessment_by_assessor'];
        if (is_array($_POST['r_behavioral_indicator'])) {
            $json_values = json_encode($_POST['r_behavioral_indicator'], JSON_UNESCAPED_UNICODE);
            $values['r_behavioral_indicator'] = $json_values;
        } else {
            $values['r_behavioral_indicator'] = intval($_POST['r_behavioral_indicator']);
        }
        if (is_array($_POST['u_behavioral_indicator'])) {
            $json_values = json_encode($_POST['u_behavioral_indicator'], JSON_UNESCAPED_UNICODE);
            $values['u_behavioral_indicator'] = $json_values;
        } else {
            $values['u_behavioral_indicator'] = intval($_POST['u_behavioral_indicator']);
        }
        if (is_array($_POST['cd_behavioral_indicator'])) {
            $json_values = json_encode($_POST['cd_behavioral_indicator'], JSON_UNESCAPED_UNICODE);
            $values['cd_behavioral_indicator'] = $json_values;
        } else {
            $values['cd_behavioral_indicator'] = intval($_POST['cd_behavioral_indicator']);
        }
        $values['cq_behavioral_indicator'] = $_POST['cq_behavioral_indicator'];
        if (is_array($_POST['r_company'])) {
            $json_values = json_encode($_POST['r_company'], JSON_UNESCAPED_UNICODE);
            $values['r_company'] = $json_values;
        } else {
            $values['r_company'] = intval($_POST['r_company']);
        }
        if (is_array($_POST['u_company'])) {
            $json_values = json_encode($_POST['u_company'], JSON_UNESCAPED_UNICODE);
            $values['u_company'] = $json_values;
        } else {
            $values['u_company'] = intval($_POST['u_company']);
        }
        if (is_array($_POST['cd_company'])) {
            $json_values = json_encode($_POST['cd_company'], JSON_UNESCAPED_UNICODE);
            $values['cd_company'] = $json_values;
        } else {
            $values['cd_company'] = intval($_POST['cd_company']);
        }
        $values['cq_company'] = $_POST['cq_company'];
        if (is_array($_POST['r_competency'])) {
            $json_values = json_encode($_POST['r_competency'], JSON_UNESCAPED_UNICODE);
            $values['r_competency'] = $json_values;
        } else {
            $values['r_competency'] = intval($_POST['r_competency']);
        }
        if (is_array($_POST['u_competency'])) {
            $json_values = json_encode($_POST['u_competency'], JSON_UNESCAPED_UNICODE);
            $values['u_competency'] = $json_values;
        } else {
            $values['u_competency'] = intval($_POST['u_competency']);
        }
        if (is_array($_POST['cd_competency'])) {
            $json_values = json_encode($_POST['cd_competency'], JSON_UNESCAPED_UNICODE);
            $values['cd_competency'] = $json_values;
        } else {
            $values['cd_competency'] = intval($_POST['cd_competency']);
        }
        $values['cq_competency'] = $_POST['cq_competency'];
        if (is_array($_POST['r_competency_type'])) {
            $json_values = json_encode($_POST['r_competency_type'], JSON_UNESCAPED_UNICODE);
            $values['r_competency_type'] = $json_values;
        } else {
            $values['r_competency_type'] = intval($_POST['r_competency_type']);
        }
        if (is_array($_POST['u_competency_type'])) {
            $json_values = json_encode($_POST['u_competency_type'], JSON_UNESCAPED_UNICODE);
            $values['u_competency_type'] = $json_values;
        } else {
            $values['u_competency_type'] = intval($_POST['u_competency_type']);
        }
        if (is_array($_POST['cd_competency_type'])) {
            $json_values = json_encode($_POST['cd_competency_type'], JSON_UNESCAPED_UNICODE);
            $values['cd_competency_type'] = $json_values;
        } else {
            $values['cd_competency_type'] = intval($_POST['cd_competency_type']);
        }
        $values['cq_competency_type'] = $_POST['cq_competency_type'];
        if (is_array($_POST['r_field'])) {
            $json_values = json_encode($_POST['r_field'], JSON_UNESCAPED_UNICODE);
            $values['r_field'] = $json_values;
        } else {
            $values['r_field'] = intval($_POST['r_field']);
        }
        if (is_array($_POST['u_field'])) {
            $json_values = json_encode($_POST['u_field'], JSON_UNESCAPED_UNICODE);
            $values['u_field'] = $json_values;
        } else {
            $values['u_field'] = intval($_POST['u_field']);
        }
        if (is_array($_POST['cd_field'])) {
            $json_values = json_encode($_POST['cd_field'], JSON_UNESCAPED_UNICODE);
            $values['cd_field'] = $json_values;
        } else {
            $values['cd_field'] = intval($_POST['cd_field']);
        }
        $values['cq_field'] = $_POST['cq_field'];
        if (is_array($_POST['r_industry'])) {
            $json_values = json_encode($_POST['r_industry'], JSON_UNESCAPED_UNICODE);
            $values['r_industry'] = $json_values;
        } else {
            $values['r_industry'] = intval($_POST['r_industry']);
        }
        if (is_array($_POST['u_industry'])) {
            $json_values = json_encode($_POST['u_industry'], JSON_UNESCAPED_UNICODE);
            $values['u_industry'] = $json_values;
        } else {
            $values['u_industry'] = intval($_POST['u_industry']);
        }
        if (is_array($_POST['cd_industry'])) {
            $json_values = json_encode($_POST['cd_industry'], JSON_UNESCAPED_UNICODE);
            $values['cd_industry'] = $json_values;
        } else {
            $values['cd_industry'] = intval($_POST['cd_industry']);
        }
        $values['cq_industry'] = $_POST['cq_industry'];
        if (is_array($_POST['r_position'])) {
            $json_values = json_encode($_POST['r_position'], JSON_UNESCAPED_UNICODE);
            $values['r_position'] = $json_values;
        } else {
            $values['r_position'] = intval($_POST['r_position']);
        }
        if (is_array($_POST['u_position'])) {
            $json_values = json_encode($_POST['u_position'], JSON_UNESCAPED_UNICODE);
            $values['u_position'] = $json_values;
        } else {
            $values['u_position'] = intval($_POST['u_position']);
        }
        if (is_array($_POST['cd_position'])) {
            $json_values = json_encode($_POST['cd_position'], JSON_UNESCAPED_UNICODE);
            $values['cd_position'] = $json_values;
        } else {
            $values['cd_position'] = intval($_POST['cd_position']);
        }
        $values['cq_position'] = $_POST['cq_position'];
        if (is_array($_POST['r_position_competency'])) {
            $json_values = json_encode($_POST['r_position_competency'], JSON_UNESCAPED_UNICODE);
            $values['r_position_competency'] = $json_values;
        } else {
            $values['r_position_competency'] = intval($_POST['r_position_competency']);
        }
        if (is_array($_POST['u_position_competency'])) {
            $json_values = json_encode($_POST['u_position_competency'], JSON_UNESCAPED_UNICODE);
            $values['u_position_competency'] = $json_values;
        } else {
            $values['u_position_competency'] = intval($_POST['u_position_competency']);
        }
        if (is_array($_POST['cd_position_competency'])) {
            $json_values = json_encode($_POST['cd_position_competency'], JSON_UNESCAPED_UNICODE);
            $values['cd_position_competency'] = $json_values;
        } else {
            $values['cd_position_competency'] = intval($_POST['cd_position_competency']);
        }
        $values['cq_position_competency'] = $_POST['cq_position_competency'];
        if (is_array($_POST['r_project'])) {
            $json_values = json_encode($_POST['r_project'], JSON_UNESCAPED_UNICODE);
            $values['r_project'] = $json_values;
        } else {
            $values['r_project'] = intval($_POST['r_project']);
        }
        if (is_array($_POST['u_project'])) {
            $json_values = json_encode($_POST['u_project'], JSON_UNESCAPED_UNICODE);
            $values['u_project'] = $json_values;
        } else {
            $values['u_project'] = intval($_POST['u_project']);
        }
        if (is_array($_POST['cd_project'])) {
            $json_values = json_encode($_POST['cd_project'], JSON_UNESCAPED_UNICODE);
            $values['cd_project'] = $json_values;
        } else {
            $values['cd_project'] = intval($_POST['cd_project']);
        }
        $values['cq_project'] = $_POST['cq_project'];
        if (is_array($_POST['r_phpcg_users'])) {
            $json_values = json_encode($_POST['r_phpcg_users'], JSON_UNESCAPED_UNICODE);
            $values['r_phpcg_users'] = $json_values;
        } else {
            $values['r_phpcg_users'] = intval($_POST['r_phpcg_users']);
        }
        if (is_array($_POST['u_phpcg_users'])) {
            $json_values = json_encode($_POST['u_phpcg_users'], JSON_UNESCAPED_UNICODE);
            $values['u_phpcg_users'] = $json_values;
        } else {
            $values['u_phpcg_users'] = intval($_POST['u_phpcg_users']);
        }
        if (is_array($_POST['cd_phpcg_users'])) {
            $json_values = json_encode($_POST['cd_phpcg_users'], JSON_UNESCAPED_UNICODE);
            $values['cd_phpcg_users'] = $json_values;
        } else {
            $values['cd_phpcg_users'] = intval($_POST['cd_phpcg_users']);
        }
        $values['cq_phpcg_users'] = $_POST['cq_phpcg_users'];
        if (is_array($_POST['r_phpcg_users_profiles'])) {
            $json_values = json_encode($_POST['r_phpcg_users_profiles'], JSON_UNESCAPED_UNICODE);
            $values['r_phpcg_users_profiles'] = $json_values;
        } else {
            $values['r_phpcg_users_profiles'] = intval($_POST['r_phpcg_users_profiles']);
        }
        if (is_array($_POST['u_phpcg_users_profiles'])) {
            $json_values = json_encode($_POST['u_phpcg_users_profiles'], JSON_UNESCAPED_UNICODE);
            $values['u_phpcg_users_profiles'] = $json_values;
        } else {
            $values['u_phpcg_users_profiles'] = intval($_POST['u_phpcg_users_profiles']);
        }
        if (is_array($_POST['cd_phpcg_users_profiles'])) {
            $json_values = json_encode($_POST['cd_phpcg_users_profiles'], JSON_UNESCAPED_UNICODE);
            $values['cd_phpcg_users_profiles'] = $json_values;
        } else {
            $values['cd_phpcg_users_profiles'] = intval($_POST['cd_phpcg_users_profiles']);
        }
        $values['cq_phpcg_users_profiles'] = $_POST['cq_phpcg_users_profiles'];
        $where = $_SESSION['phpcg_users_profiles_editable_primary_keys'];

// begin transaction
        $db->transactionBegin();

try {
            // update phpcg_users_profiles
            if (DEMO !== true && !$db->update('phpcg_users_profiles', $values, $where, DEBUG_DB_QUERIES)) {
                $error = $db->error();
                throw new \Exception($error);
            } else {
                // ALL OK
                if (!DEBUG_DB_QUERIES) {
                    $db->transactionCommit();

$_SESSION['msg'] = Utils::alert(UPDATE_SUCCESS_MESSAGE, 'alert-success has-icon');

// reset form values
                    Form::clear('form-edit-phpcg-users-profiles');

// redirect to list page
                    if (isset($_SESSION['active_list_url'])) {
                        header('Location:' . $_SESSION['active_list_url']);
                    } else {
                        header('Location:' . ADMIN_URL . 'phpcgusersprofiles');
                    }

// if we don't exit here, $_SESSION['msg'] will be unset
                    exit();
                } else {
                    $debug_content .= $db->getDebugContent();
                    $db->transactionRollback();

$_SESSION['msg'] = Utils::alert(UPDATE_SUCCESS_MESSAGE . ' (' . DEBUG_DB_QUERIES_ENABLED . ')', 'alert-success has-icon');
 }
 }
 } catch (\Exception $e) {
 $db->transactionRollback();
 $msg_content = DB_ERROR;
 if (DEBUG) {
 $msg_content .= ' ' . $e->getMessage() . ' ' . $db->getLastSql();
 }
 $_SESSION['msg'] = Utils::alert($msg_content, 'alert-danger has-icon');
 }
 } // END else
} // END if POST

// register editable primary keys, which are NOT posted and will be the query update filter
// $params come from data-forms.php
// replace 'fieldname' with 'table.fieldname' to avoid ambigous query
$where_params = array_combine(
    array_map(function ($k) {
        return 'phpcg_users_profiles.' . $k;
    }, array_keys($params)),
    $params
);
$_SESSION['phpcg_users_profiles_editable_primary_keys'] = $where_params;

if (!isset($_SESSION['errors']['form-edit-phpcg-users-profiles']) || empty($_SESSION['errors']['form-edit-phpcg-users-profiles'])) { // If no error registered
    $from = 'phpcg_users_profiles';
    $columns = '*';

$where = $_SESSION['phpcg_users_profiles_editable_primary_keys'];

// if restricted rights
    if (ADMIN_LOCKED === true && Secure::canUpdateRestricted('phpcg_users_profiles')) {
        $where = array_merge($where, Secure::getRestrictionQuery('phpcg_users_profiles'));
    }

$db = new DB(DEBUG);
    $db->setDebugMode('register');

$db->select($from, $columns, $where, array(), DEBUG_DB_QUERIES);
 if ($db->rowCount() < 1) {
 if (DEBUG) {
 exit($db->getLastSql() . ' : No Record Found');
 } else {
 exit('No Record Found');
 }
 }
 if (DEBUG_DB_QUERIES) {
 $debug_content .= $db->getDebugContent();
 }
 $row = $db->fetch();
 $_SESSION['form-edit-phpcg-users-profiles']['id'] = $row->id;
 $_SESSION['form-edit-phpcg-users-profiles']['profile_name'] = $row->profile_name;
 $_SESSION['form-edit-phpcg-users-profiles']['r_assess_bi'] = $row->r_assess_bi;
 $_SESSION['form-edit-phpcg-users-profiles']['u_assess_bi'] = $row->u_assess_bi;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_assess_bi'] = $row->cd_assess_bi;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_assess_bi'] = $row->cq_assess_bi;
 $_SESSION['form-edit-phpcg-users-profiles']['r_assessment'] = $row->r_assessment;
 $_SESSION['form-edit-phpcg-users-profiles']['u_assessment'] = $row->u_assessment;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_assessment'] = $row->cd_assessment;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_assessment'] = $row->cq_assessment;
 $_SESSION['form-edit-phpcg-users-profiles']['r_assessment_by_assessor'] = $row->r_assessment_by_assessor;
 $_SESSION['form-edit-phpcg-users-profiles']['u_assessment_by_assessor'] = $row->u_assessment_by_assessor;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_assessment_by_assessor'] = $row->cd_assessment_by_assessor;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_assessment_by_assessor'] = $row->cq_assessment_by_assessor;
 $_SESSION['form-edit-phpcg-users-profiles']['r_behavioral_indicator'] = $row->r_behavioral_indicator;
 $_SESSION['form-edit-phpcg-users-profiles']['u_behavioral_indicator'] = $row->u_behavioral_indicator;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_behavioral_indicator'] = $row->cd_behavioral_indicator;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_behavioral_indicator'] = $row->cq_behavioral_indicator;
 $_SESSION['form-edit-phpcg-users-profiles']['r_company'] = $row->r_company;
 $_SESSION['form-edit-phpcg-users-profiles']['u_company'] = $row->u_company;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_company'] = $row->cd_company;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_company'] = $row->cq_company;
 $_SESSION['form-edit-phpcg-users-profiles']['r_competency'] = $row->r_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['u_competency'] = $row->u_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_competency'] = $row->cd_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_competency'] = $row->cq_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['r_competency_type'] = $row->r_competency_type;
 $_SESSION['form-edit-phpcg-users-profiles']['u_competency_type'] = $row->u_competency_type;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_competency_type'] = $row->cd_competency_type;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_competency_type'] = $row->cq_competency_type;
 $_SESSION['form-edit-phpcg-users-profiles']['r_field'] = $row->r_field;
 $_SESSION['form-edit-phpcg-users-profiles']['u_field'] = $row->u_field;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_field'] = $row->cd_field;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_field'] = $row->cq_field;
 $_SESSION['form-edit-phpcg-users-profiles']['r_industry'] = $row->r_industry;
 $_SESSION['form-edit-phpcg-users-profiles']['u_industry'] = $row->u_industry;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_industry'] = $row->cd_industry;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_industry'] = $row->cq_industry;
 $_SESSION['form-edit-phpcg-users-profiles']['r_position'] = $row->r_position;
 $_SESSION['form-edit-phpcg-users-profiles']['u_position'] = $row->u_position;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_position'] = $row->cd_position;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_position'] = $row->cq_position;
 $_SESSION['form-edit-phpcg-users-profiles']['r_position_competency'] = $row->r_position_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['u_position_competency'] = $row->u_position_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_position_competency'] = $row->cd_position_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_position_competency'] = $row->cq_position_competency;
 $_SESSION['form-edit-phpcg-users-profiles']['r_project'] = $row->r_project;
 $_SESSION['form-edit-phpcg-users-profiles']['u_project'] = $row->u_project;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_project'] = $row->cd_project;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_project'] = $row->cq_project;
 $_SESSION['form-edit-phpcg-users-profiles']['r_phpcg_users'] = $row->r_phpcg_users;
 $_SESSION['form-edit-phpcg-users-profiles']['u_phpcg_users'] = $row->u_phpcg_users;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_phpcg_users'] = $row->cd_phpcg_users;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_phpcg_users'] = $row->cq_phpcg_users;
 $_SESSION['form-edit-phpcg-users-profiles']['r_phpcg_users_profiles'] = $row->r_phpcg_users_profiles;
 $_SESSION['form-edit-phpcg-users-profiles']['u_phpcg_users_profiles'] = $row->u_phpcg_users_profiles;
 $_SESSION['form-edit-phpcg-users-profiles']['cd_phpcg_users_profiles'] = $row->cd_phpcg_users_profiles;
 $_SESSION['form-edit-phpcg-users-profiles']['cq_phpcg_users_profiles'] = $row->cq_phpcg_users_profiles;
}
// $params come from data-forms.php
$pk_url_params = http_build_query($params, '', '/');

$form = new Form('form-edit-phpcg-users-profiles', 'horizontal', 'novalidate');
$form->setAction(ADMIN_URL . 'phpcgusersprofiles/edit/' . $pk_url_params);

$form->addHtml(USERS_PROFILES_HELPER);

$form->startFieldset();

// id --

$form->setCols(2, 10);
$form->addInput('hidden', 'id', '');

// profile_name --

$form->setCols(2, 10);
$form->addInput('text', 'profile_name', '', 'Profile Name', 'required');

// r_assess_bi --
$form->groupElements('r_assess_bi', 'u_assess_bi');

$form->setCols(2, 4);
$form->addOption('r_assess_bi', '2', 'Yes');
$form->addOption('r_assess_bi', '1', 'Restricted');
$form->addOption('r_assess_bi', '0', 'No');
$form->addSelect('r_assess_bi', 'Read Assess Bi', 'required, data-slimselect=true');

// u_assess_bi --
$form->addOption('u_assess_bi', '2', 'Yes');
$form->addOption('u_assess_bi', '1', 'Restricted');
$form->addOption('u_assess_bi', '0', 'No');
$form->addSelect('u_assess_bi', 'Update Assess Bi', 'required, data-slimselect=true');

// cd_assess_bi --

$form->setCols(2, 10);
$form->addOption('cd_assess_bi', '2', 'Yes');
$form->addOption('cd_assess_bi', '1', 'Restricted');
$form->addOption('cd_assess_bi', '0', 'No');
$form->addSelect('cd_assess_bi', 'Create/Delete Assess Bi', 'required, data-slimselect=true');

// cq_assess_bi --
$form->addInput('text', 'cq_assess_bi', '', 'Constraint Query Assess Bi<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_assessment --
$form->groupElements('r_assessment', 'u_assessment');

$form->setCols(2, 4);
$form->addOption('r_assessment', '2', 'Yes');
$form->addOption('r_assessment', '1', 'Restricted');
$form->addOption('r_assessment', '0', 'No');
$form->addSelect('r_assessment', 'Read Assessment', 'required, data-slimselect=true');

// u_assessment --
$form->addOption('u_assessment', '2', 'Yes');
$form->addOption('u_assessment', '1', 'Restricted');
$form->addOption('u_assessment', '0', 'No');
$form->addSelect('u_assessment', 'Update Assessment', 'required, data-slimselect=true');

// cd_assessment --

$form->setCols(2, 10);
$form->addOption('cd_assessment', '2', 'Yes');
$form->addOption('cd_assessment', '1', 'Restricted');
$form->addOption('cd_assessment', '0', 'No');
$form->addSelect('cd_assessment', 'Create/Delete Assessment', 'required, data-slimselect=true');

// cq_assessment --
$form->addInput('text', 'cq_assessment', '', 'Constraint Query Assessment<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_assessment_by_assessor --
$form->groupElements('r_assessment_by_assessor', 'u_assessment_by_assessor');

$form->setCols(2, 4);
$form->addOption('r_assessment_by_assessor', '2', 'Yes');
$form->addOption('r_assessment_by_assessor', '1', 'Restricted');
$form->addOption('r_assessment_by_assessor', '0', 'No');
$form->addSelect('r_assessment_by_assessor', 'Read Assessment By Assessor', 'required, data-slimselect=true');

// u_assessment_by_assessor --
$form->addOption('u_assessment_by_assessor', '2', 'Yes');
$form->addOption('u_assessment_by_assessor', '1', 'Restricted');
$form->addOption('u_assessment_by_assessor', '0', 'No');
$form->addSelect('u_assessment_by_assessor', 'Update Assessment By Assessor', 'required, data-slimselect=true');

// cd_assessment_by_assessor --

$form->setCols(2, 10);
$form->addOption('cd_assessment_by_assessor', '2', 'Yes');
$form->addOption('cd_assessment_by_assessor', '1', 'Restricted');
$form->addOption('cd_assessment_by_assessor', '0', 'No');
$form->addSelect('cd_assessment_by_assessor', 'Create/Delete Assessment By Assessor', 'required, data-slimselect=true');

// cq_assessment_by_assessor --
$form->addInput('text', 'cq_assessment_by_assessor', '', 'Constraint Query Assessment By Assessor<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_behavioral_indicator --
$form->groupElements('r_behavioral_indicator', 'u_behavioral_indicator');

$form->setCols(2, 4);
$form->addOption('r_behavioral_indicator', '2', 'Yes');
$form->addOption('r_behavioral_indicator', '1', 'Restricted');
$form->addOption('r_behavioral_indicator', '0', 'No');
$form->addSelect('r_behavioral_indicator', 'Read Behavioral Indicator', 'required, data-slimselect=true');

// u_behavioral_indicator --
$form->addOption('u_behavioral_indicator', '2', 'Yes');
$form->addOption('u_behavioral_indicator', '1', 'Restricted');
$form->addOption('u_behavioral_indicator', '0', 'No');
$form->addSelect('u_behavioral_indicator', 'Update Behavioral Indicator', 'required, data-slimselect=true');

// cd_behavioral_indicator --

$form->setCols(2, 10);
$form->addOption('cd_behavioral_indicator', '2', 'Yes');
$form->addOption('cd_behavioral_indicator', '1', 'Restricted');
$form->addOption('cd_behavioral_indicator', '0', 'No');
$form->addSelect('cd_behavioral_indicator', 'Create/Delete Behavioral Indicator', 'required, data-slimselect=true');

// cq_behavioral_indicator --
$form->addInput('text', 'cq_behavioral_indicator', '', 'Constraint Query Behavioral Indicator<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_company --
$form->groupElements('r_company', 'u_company');

$form->setCols(2, 4);
$form->addOption('r_company', '2', 'Yes');
$form->addOption('r_company', '1', 'Restricted');
$form->addOption('r_company', '0', 'No');
$form->addSelect('r_company', 'Read Company', 'required, data-slimselect=true');

// u_company --
$form->addOption('u_company', '2', 'Yes');
$form->addOption('u_company', '1', 'Restricted');
$form->addOption('u_company', '0', 'No');
$form->addSelect('u_company', 'Update Company', 'required, data-slimselect=true');

// cd_company --

$form->setCols(2, 10);
$form->addOption('cd_company', '2', 'Yes');
$form->addOption('cd_company', '1', 'Restricted');
$form->addOption('cd_company', '0', 'No');
$form->addSelect('cd_company', 'Create/Delete Company', 'required, data-slimselect=true');

// cq_company --
$form->addInput('text', 'cq_company', '', 'Constraint Query Company<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_competency --
$form->groupElements('r_competency', 'u_competency');

$form->setCols(2, 4);
$form->addOption('r_competency', '2', 'Yes');
$form->addOption('r_competency', '1', 'Restricted');
$form->addOption('r_competency', '0', 'No');
$form->addSelect('r_competency', 'Read Competency', 'required, data-slimselect=true');

// u_competency --
$form->addOption('u_competency', '2', 'Yes');
$form->addOption('u_competency', '1', 'Restricted');
$form->addOption('u_competency', '0', 'No');
$form->addSelect('u_competency', 'Update Competency', 'required, data-slimselect=true');

// cd_competency --

$form->setCols(2, 10);
$form->addOption('cd_competency', '2', 'Yes');
$form->addOption('cd_competency', '1', 'Restricted');
$form->addOption('cd_competency', '0', 'No');
$form->addSelect('cd_competency', 'Create/Delete Competency', 'required, data-slimselect=true');

// cq_competency --
$form->addInput('text', 'cq_competency', '', 'Constraint Query Competency<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_competency_type --
$form->groupElements('r_competency_type', 'u_competency_type');

$form->setCols(2, 4);
$form->addOption('r_competency_type', '2', 'Yes');
$form->addOption('r_competency_type', '1', 'Restricted');
$form->addOption('r_competency_type', '0', 'No');
$form->addSelect('r_competency_type', 'Read Competency Type', 'required, data-slimselect=true');

// u_competency_type --
$form->addOption('u_competency_type', '2', 'Yes');
$form->addOption('u_competency_type', '1', 'Restricted');
$form->addOption('u_competency_type', '0', 'No');
$form->addSelect('u_competency_type', 'Update Competency Type', 'required, data-slimselect=true');

// cd_competency_type --

$form->setCols(2, 10);
$form->addOption('cd_competency_type', '2', 'Yes');
$form->addOption('cd_competency_type', '1', 'Restricted');
$form->addOption('cd_competency_type', '0', 'No');
$form->addSelect('cd_competency_type', 'Create/Delete Competency Type', 'required, data-slimselect=true');

// cq_competency_type --
$form->addInput('text', 'cq_competency_type', '', 'Constraint Query Competency Type<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_field --
$form->groupElements('r_field', 'u_field');

$form->setCols(2, 4);
$form->addOption('r_field', '2', 'Yes');
$form->addOption('r_field', '1', 'Restricted');
$form->addOption('r_field', '0', 'No');
$form->addSelect('r_field', 'Read Field', 'required, data-slimselect=true');

// u_field --
$form->addOption('u_field', '2', 'Yes');
$form->addOption('u_field', '1', 'Restricted');
$form->addOption('u_field', '0', 'No');
$form->addSelect('u_field', 'Update Field', 'required, data-slimselect=true');

// cd_field --

$form->setCols(2, 10);
$form->addOption('cd_field', '2', 'Yes');
$form->addOption('cd_field', '1', 'Restricted');
$form->addOption('cd_field', '0', 'No');
$form->addSelect('cd_field', 'Create/Delete Field', 'required, data-slimselect=true');

// cq_field --
$form->addInput('text', 'cq_field', '', 'Constraint Query Field<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_industry --
$form->groupElements('r_industry', 'u_industry');

$form->setCols(2, 4);
$form->addOption('r_industry', '2', 'Yes');
$form->addOption('r_industry', '1', 'Restricted');
$form->addOption('r_industry', '0', 'No');
$form->addSelect('r_industry', 'Read Industry', 'required, data-slimselect=true');

// u_industry --
$form->addOption('u_industry', '2', 'Yes');
$form->addOption('u_industry', '1', 'Restricted');
$form->addOption('u_industry', '0', 'No');
$form->addSelect('u_industry', 'Update Industry', 'required, data-slimselect=true');

// cd_industry --

$form->setCols(2, 10);
$form->addOption('cd_industry', '2', 'Yes');
$form->addOption('cd_industry', '1', 'Restricted');
$form->addOption('cd_industry', '0', 'No');
$form->addSelect('cd_industry', 'Create/Delete Industry', 'required, data-slimselect=true');

// cq_industry --
$form->addInput('text', 'cq_industry', '', 'Constraint Query Industry<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_position --
$form->groupElements('r_position', 'u_position');

$form->setCols(2, 4);
$form->addOption('r_position', '2', 'Yes');
$form->addOption('r_position', '1', 'Restricted');
$form->addOption('r_position', '0', 'No');
$form->addSelect('r_position', 'Read Position', 'required, data-slimselect=true');

// u_position --
$form->addOption('u_position', '2', 'Yes');
$form->addOption('u_position', '1', 'Restricted');
$form->addOption('u_position', '0', 'No');
$form->addSelect('u_position', 'Update Position', 'required, data-slimselect=true');

// cd_position --

$form->setCols(2, 10);
$form->addOption('cd_position', '2', 'Yes');
$form->addOption('cd_position', '1', 'Restricted');
$form->addOption('cd_position', '0', 'No');
$form->addSelect('cd_position', 'Create/Delete Position', 'required, data-slimselect=true');

// cq_position --
$form->addInput('text', 'cq_position', '', 'Constraint Query Position<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_position_competency --
$form->groupElements('r_position_competency', 'u_position_competency');

$form->setCols(2, 4);
$form->addOption('r_position_competency', '2', 'Yes');
$form->addOption('r_position_competency', '1', 'Restricted');
$form->addOption('r_position_competency', '0', 'No');
$form->addSelect('r_position_competency', 'Read Position Competency', 'required, data-slimselect=true');

// u_position_competency --
$form->addOption('u_position_competency', '2', 'Yes');
$form->addOption('u_position_competency', '1', 'Restricted');
$form->addOption('u_position_competency', '0', 'No');
$form->addSelect('u_position_competency', 'Update Position Competency', 'required, data-slimselect=true');

// cd_position_competency --

$form->setCols(2, 10);
$form->addOption('cd_position_competency', '2', 'Yes');
$form->addOption('cd_position_competency', '1', 'Restricted');
$form->addOption('cd_position_competency', '0', 'No');
$form->addSelect('cd_position_competency', 'Create/Delete Position Competency', 'required, data-slimselect=true');

// cq_position_competency --
$form->addInput('text', 'cq_position_competency', '', 'Constraint Query Position Competency<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_project --
$form->groupElements('r_project', 'u_project');

$form->setCols(2, 4);
$form->addOption('r_project', '2', 'Yes');
$form->addOption('r_project', '1', 'Restricted');
$form->addOption('r_project', '0', 'No');
$form->addSelect('r_project', 'Read Project', 'required, data-slimselect=true');

// u_project --
$form->addOption('u_project', '2', 'Yes');
$form->addOption('u_project', '1', 'Restricted');
$form->addOption('u_project', '0', 'No');
$form->addSelect('u_project', 'Update Project', 'required, data-slimselect=true');

// cd_project --

$form->setCols(2, 10);
$form->addOption('cd_project', '2', 'Yes');
$form->addOption('cd_project', '1', 'Restricted');
$form->addOption('cd_project', '0', 'No');
$form->addSelect('cd_project', 'Create/Delete Project', 'required, data-slimselect=true');

// cq_project --
$form->addInput('text', 'cq_project', '', 'Constraint Query Project<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');

// r_phpcg_users --
$form->groupElements('r_phpcg_users', 'u_phpcg_users');

$form->setCols(2, 4);
$form->addOption('r_phpcg_users', '2', 'Yes');
$form->addOption('r_phpcg_users', '1', 'Restricted');
$form->addOption('r_phpcg_users', '0', 'No');
$form->addSelect('r_phpcg_users', 'Read Phpcg Users', 'required, data-slimselect=true');

// u_phpcg_users --
$form->addOption('u_phpcg_users', '2', 'Yes');
$form->addOption('u_phpcg_users', '1', 'Restricted');
$form->addOption('u_phpcg_users', '0', 'No');
$form->addSelect('u_phpcg_users', 'Update Phpcg Users', 'required, data-slimselect=true');

// cd_phpcg_users --

$form->setCols(2, 10);
$form->addOption('cd_phpcg_users', '2', 'Yes');
$form->addOption('cd_phpcg_users', '0', 'No');
$form->addSelect('cd_phpcg_users', 'Create/Delete Phpcg Users', 'required, data-slimselect=true');

// cq_phpcg_users --
$form->addHelper('CREATE/DELETE rights on users table cannot be limited - this would be a nonsense', 'cq_phpcg_users', 'after');
$form->addInput('text', 'cq_phpcg_users', '', 'Constraint Query Phpcg Users', '');

// r_phpcg_users_profiles --
$form->groupElements('r_phpcg_users_profiles', 'u_phpcg_users_profiles');

$form->setCols(2, 4);
$form->addOption('r_phpcg_users_profiles', '2', 'Yes');
$form->addOption('r_phpcg_users_profiles', '1', 'Restricted');
$form->addOption('r_phpcg_users_profiles', '0', 'No');
$form->addSelect('r_phpcg_users_profiles', 'Read Phpcg Users Profiles', 'required, data-slimselect=true');

// u_phpcg_users_profiles --
$form->addOption('u_phpcg_users_profiles', '2', 'Yes');
$form->addOption('u_phpcg_users_profiles', '1', 'Restricted');
$form->addOption('u_phpcg_users_profiles', '0', 'No');
$form->addSelect('u_phpcg_users_profiles', 'Update Phpcg Users Profiles', 'required, data-slimselect=true');

// cd_phpcg_users_profiles --

$form->setCols(2, 10);
$form->addOption('cd_phpcg_users_profiles', '2', 'Yes');
$form->addOption('cd_phpcg_users_profiles', '1', 'Restricted');
$form->addOption('cd_phpcg_users_profiles', '0', 'No');
$form->addSelect('cd_phpcg_users_profiles', 'Create/Delete Phpcg Users Profiles', 'required, data-slimselect=true');

// cq_phpcg_users_profiles --
$form->addInput('text', 'cq_phpcg_users_profiles', '', 'Constraint Query Phpcg Users Profiles<a href="#" data-bs-toggle="tooltip" data-bs-html="true" data-bs-title="WHERE query if limited rights.Example: , users WHERE table.users_ID = users.ID AND users.ID = CURRENT_USER_IDCURRENT_USER_ID will be automatically replaced by the connected user\'s ID." class="append">?</a>', '');
$form->addBtn('button', 'cancel', 0, '' . CANCEL, 'class=btn btn-warning, data-ladda-button=true, data-style=zoom-in, onclick=history.go(-1)', 'btn-group');
$form->addBtn('submit', 'submit-btn', 1, SUBMIT . '', 'class=btn btn-success, data-ladda-button=true, data-style=zoom-in', 'btn-group');
$form->setCols(0, 12);
$form->centerContent();
$form->printBtnGroup('btn-group');
$form->endFieldset();
$form->addPlugin('pretty-checkbox', '#form-edit-phpcg-users-profiles');
$form->addPlugin('formvalidation', '#form-edit-phpcg-users-profiles', 'default', array('language' => FORMVALIDATION_JAVASCRIPT_LANG));