function ajout_user(&$tab_new_user, $tab_checkbox_sem_imp, $tab_checkbox_sem_p, &$tab_new_jours_an, &$tab_new_solde, $checkbox_user_groups, $DEBUG = FALSE)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
$session = session_id();
if ($DEBUG) {
echo "tab_new_jours_an = ";
print_r($tab_new_jours_an);
echo "<br>\n";
echo "tab_new_solde = ";
print_r($tab_new_solde);
echo "<br>\n";
}
// si pas d'erreur de saisie :
if (verif_new_param($tab_new_user, $tab_new_jours_an, $tab_new_solde, $DEBUG) == 0) {
echo $tab_new_user['login'] . "---" . $tab_new_user['nom'] . "---" . $tab_new_user['prenom'] . "---" . $tab_new_user['quotite'] . "\n";
echo "---" . $tab_new_user['is_resp'] . "---" . $tab_new_user['resp_login'] . "---" . $tab_new_user['is_admin'] . "---" . $tab_new_user['is_hr'] . "---" . $tab_new_user['see_all'] . "---" . $tab_new_user['email'] . "<br>\n";
foreach ($tab_new_jours_an as $id_cong => $jours_an) {
echo $tab_new_jours_an[$id_cong] . "---" . $tab_new_solde[$id_cong] . "<br>\n";
}
$new_date_deb_grille = $tab_new_user['new_year'] . "-" . $tab_new_user['new_mois'] . "-" . $tab_new_user['new_jour'];
echo "{$new_date_deb_grille}<br>\n";
/*****************************/
/* INSERT dans conges_users */
if ($_SESSION['config']['how_to_connect_user'] == "dbconges") {
$motdepasse = md5($tab_new_user['password1']);
} else {
$motdepasse = "none";
}
$sql1 = "INSERT INTO conges_users SET ";
$sql1 = $sql1 . "u_login='******'login'] . "', ";
$sql1 = $sql1 . "u_nom='" . addslashes($tab_new_user['nom']) . "', ";
$sql1 = $sql1 . "u_prenom='" . addslashes($tab_new_user['prenom']) . "', ";
$sql1 = $sql1 . "u_is_resp='" . $tab_new_user['is_resp'] . "', ";
if ($tab_new_user['resp_login'] == 'no_resp') {
$sql1 = $sql1 . "u_resp_login= NULL , ";
} else {
$sql1 = $sql1 . "u_resp_login='******'resp_login'] . "', ";
}
$sql1 = $sql1 . "u_is_admin='" . $tab_new_user['is_admin'] . "', ";
$sql1 = $sql1 . "u_is_hr='" . $tab_new_user['is_hr'] . "', ";
$sql1 = $sql1 . "u_see_all='" . $tab_new_user['see_all'] . "', ";
$sql1 = $sql1 . "u_passwd='{$motdepasse}', ";
$sql1 = $sql1 . "u_quotite=" . $tab_new_user['quotite'] . ",";
$sql1 = $sql1 . " u_email='" . $tab_new_user['email'] . "' ";
$result1 = SQL::query($sql1);
/**********************************/
/* INSERT dans conges_solde_user */
foreach ($tab_new_jours_an as $id_cong => $jours_an) {
$sql3 = "INSERT INTO conges_solde_user (su_login, su_abs_id, su_nb_an, su_solde, su_reliquat) ";
$sql3 = $sql3 . "VALUES ('" . $tab_new_user['login'] . "' , {$id_cong}, " . $tab_new_jours_an[$id_cong] . ", " . $tab_new_solde[$id_cong] . ", 0) ";
$result3 = SQL::query($sql3);
}
/*****************************/
/* INSERT dans conges_artt */
$list_colums_to_insert = "a_login";
$list_values_to_insert = "'" . $tab_new_user['login'] . "'";
// on parcours le tableau des jours d'absence semaine impaire
if ($tab_checkbox_sem_imp != "") {
while (list($key, $val) = each($tab_checkbox_sem_imp)) {
//echo "$key => $val<br>\n";
$list_colums_to_insert = "{$list_colums_to_insert}, {$key}";
$list_values_to_insert = "{$list_values_to_insert}, '{$val}'";
}
}
if ($tab_checkbox_sem_p != "") {
while (list($key, $val) = each($tab_checkbox_sem_p)) {
//echo "$key => $val<br>\n";
$list_colums_to_insert = "{$list_colums_to_insert}, {$key}";
$list_values_to_insert = "{$list_values_to_insert}, '{$val}'";
}
}
$sql2 = "INSERT INTO conges_artt ({$list_colums_to_insert}, a_date_debut_grille) VALUES ({$list_values_to_insert}, '{$new_date_deb_grille}')";
$result2 = SQL::query($sql2);
/***********************************/
/* ajout du user dans ses groupes */
$result4 = TRUE;
if ($_SESSION['config']['gestion_groupes'] && $checkbox_user_groups != "") {
$result4 = commit_modif_user_groups($tab_new_user['login'], $checkbox_user_groups, $DEBUG);
}
/*****************************/
if ($result1 && $result2 && $result3 && $result4) {
echo _('form_modif_ok') . "<br><br> \n";
} else {
echo _('form_modif_not_ok') . "<br><br> \n";
}
$comment_log = "ajout_user : "******" / " . addslashes($tab_new_user['nom']) . " " . addslashes($tab_new_user['prenom']) . " (" . $tab_new_user['quotite'] . " %)";
log_action(0, "", $tab_new_user['login'], $comment_log, $DEBUG);
/* APPEL D'UNE AUTRE PAGE */
echo " <form action=\"{$PHP_SELF}?session={$session}&onglet=admin-users\" method=\"POST\"> \n";
echo "<input type=\"submit\" value=\"" . _('form_retour') . "\">\n";
echo " </form> \n";
}
}
function modif_user_groups($choix_user, &$checkbox_user_groups, $DEBUG = FALSE)
{
$PHP_SELF = $_SERVER['PHP_SELF'];
$session = session_id();
$result_insert = commit_modif_user_groups($choix_user, $checkbox_user_groups, $DEBUG);
if ($result_insert) {
echo _('form_modif_ok') . " !<br><br> \n";
} else {
echo _('form_modif_not_ok') . " !<br><br> \n";
}
$comment_log = "mofification_des groupes auxquels {$choix_user} appartient";
log_action(0, "", $choix_user, $comment_log, $DEBUG);
/* APPEL D'UNE AUTRE PAGE */
echo " <form action=\"{$PHP_SELF}?session={$session}&onglet=admin-group-users\" method=\"POST\"> \n";
echo "<input type=\"submit\" value=\"" . _('form_retour') . "\">\n";
echo " </form> \n";
}
