foreach ($values as $com => $values1) {
foreach ($values1 as $etat => $jour) {
if ($etat == 2 && $debutSR == true) {
$tableau .= '<strong>Congés acceptés sous réserves</strong><br />';
$debutSR = false;
} elseif ($etat == 3 && $debutR == true) {
$tableau .= '<strong>Congés refusés</strong><br />';
$debutR = false;
}
$tableau .= implode(',', $jour) . ':<br />' . $com . '<br />';
}
}
}
$tableau .= '</td>';
}
$tableau .= '<td class="not_printed">' . bouton('Gérer', 'voir', $row_coll['COL_NO']) . '</td>';
echo $tableau . '</tr>';
}
?>
</table>
</div>
</div>
<!-- <form action="#" method="post">
<input type="hidden" name="col_id" value="0"/>
<input type="hidden" name="mode" value="0"/>
<input type="hidden" name="annee" value="<?php
echo $_POST['annee'];
?>
"/>
<input type="hidden" name="mois" value="<?php
echo $_POST['mois'];
} else {
echo '<td>' . bouton('V', 'valider', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . ' ' . bouton('R', 'refuser', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . ' ' . bouton('A', 'attente', $row_note['NOF_NSEQUENTIEL'], 'btn-primary') . '</td>';
}
} else {
if ($row_note['NOF_ETAT'] == 'V') {
echo '<td>' . bouton('V', 'valider', $row_note['NOF_NSEQUENTIEL'], 'btn-success') . ' ' . bouton('R', 'refuser', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . ' ' . bouton('A', 'attente', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . '</td>';
} elseif ($row_note['NOF_ETAT'] == 'R') {
echo '<td>' . bouton('V', 'valider', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . ' ' . bouton('M', $row_note['TYF_NO'] . 'modifier', $row_coll['COL_NO'], 'btn-black') . ' ' . bouton('R', 'refuser', $row_note['NOF_NSEQUENTIEL'], 'btn-danger') . ' ' . bouton('A', 'attente', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . '</td>';
} else {
echo '<td>' . bouton('V', 'valider', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . ' ' . bouton('M', $row_note['TYF_NO'] . 'modifier', $row_coll['COL_NO'], 'btn-black') . ' ' . bouton('R', 'refuser', $row_note['NOF_NSEQUENTIEL'], 'btn-black') . ' ' . bouton('A', 'attente', $row_note['NOF_NSEQUENTIEL'], 'btn-primary') . '</td>';
}
}
if ($row_note['NOF_REGLER'] == 0) {
echo '<td>' . bouton('Non Payée', 'nonpayee', $row_note['NOF_NSEQUENTIEL'], 'btn-danger') . '</td>';
} else {
echo '<td>' . bouton('Payée', 'payee', $row_note['NOF_NSEQUENTIEL'], 'btn-success') . '</td>';
}
echo '</tr>';
}
}
} else {
echo '<td class="nomColl" id="' . $row_coll['COL_NO'] . '" style="width: 300px">' . $row_coll['COL_NOM'] . " " . $row_coll['COL_PRENOM'] . " </td>";
echo '<td></td><td></td><td></td>';
echo '</tr>';
}
}
?>
</table>
<br/>
<br/>
</div>
$result_coll = $GLOBALS['connexion']->query($query_coll);
function bouton($texte, $classe, $valeur)
{
return '<button style="display: none" type="button" class="btn btn-primary ' . $classe . '" value="' . $valeur . '">' . $texte . '</button>';
}
while ($row_coll = $result_coll->fetch_assoc()) {
echo '<tr>';
echo '<td class="nomColl" id="coll' . $row_coll['COL_NO'] . '" style="width: 300px">' . $row_coll['COL_NOM'] . " " . $row_coll['COL_PRENOM'] . " </td>";
echo '<td style="width: 15px"><i id=chk-' . $row_coll['COL_NO'] . ' class="icon-remove"></i></td>';
echo '<td>' . bouton('Visualiser le RAM', 'voir', $row_coll['COL_NO']) . '</td>';
if ($_SESSION['accreditation'] < 4) {
echo '<td>' . bouton('Valider le RAM', 'valider', $row_coll['COL_NO']) . bouton('Invalider le RAM', 'invalider', $row_coll['COL_NO']) . '</td>';
echo '<td>' . bouton('Modifier le RAM', 'modifier', $row_coll['COL_NO']) . '</td>';
echo '<td>' . bouton('Supprimer le RAM', 'supprimer', $row_coll['COL_NO']) . '</td>';
}
echo '<td>' . bouton('Imprimer le RAM', 'imprimer', $row_coll['COL_NO']) . '</td>';
echo '</tr>';
}
$query_ram = "SELECT * FROM RAM WHERE RAM_MOIS = " . $_POST['mois'] . " AND RAM_ANNEE = " . $_POST['annee'];
echo $query_ram;
$result_ram = $GLOBALS['connexion']->query($query_ram);
$invalide = '';
$valide = '';
if (mysqli_num_rows($result_ram) >= 1) {
$precedent = '';
while ($row_ram = $result_ram->fetch_assoc()) {
if ($row_ram['COL_NO'] != $precedent) {
if ($row_ram['RAM_VALIDATION'] == 0) {
$invalide .= $row_ram['COL_NO'] . ', ';
} elseif ($row_ram['RAM_VALIDATION'] == 1) {
$valide .= $row_ram['COL_NO'] . ', ';
foreach ($listeInvisible as $ligne) {
echo '<input class="hidden" name="' . $ensNomInvisible[$j] . '" value="' . $ligne . '"/>';
$j++;
}
echo '<input class="hidden" name="ensNomVisible" value="' . $listeNomVisible . '"/>';
echo '<input class="hidden" name="ensNomInvisible" value="' . $listeNomInvisible . '"/>';
?>
<fieldset>
<legend>Element(s) supplémentaire(s) à facturer</legend>
<table id='tableau0' border="1" class="table-bordered table-condensed" width="85%" align="center">
<tr>
<th>Désignation</th>
<th>Détail projet</th>
<th>Montant à facturer</th>
<th><?php
echo bouton('Ajouter une ligne', 'btn', 'primary', 'ajoutElement', 'ajout_element()');
?>
</th>
</tr>
</table>
</fieldset>
</br>
<div class="text-center">
<input class="btn btn-primary" type="submit" value="Generer et stocker une facture officiel" name="Generer"/><i class="icon-ok"></i></input>
<input class="btn btn-primary" type="submit" value="Generer et stocker une facture au pro-format" name="Stocker"/><i class="icon-ok"></i></input>
</div>
</fieldset>
</form>
<?php
}
function bouton($texte, $classe, $classeCouleur, $name, $fonction)
echo '<td id="PROFORMA' . $ligne['COL_NO'] . '">' . $ligne['PROFORMA'] . '</td>';
echo '<td id="FACTURE' . $ligne['COL_NO'] . '">' . $ligne['FACTURE'] . '</td>';
echo '<td id="AVOIR' . $ligne['COL_NO'] . '">' . $ligne['AVOIR'] . '</td>';
echo '</tr>';
}
echo '</tbody></table><br><br><br><br>';
$query_ext = "SELECT F.FAC_NO, F.FAC_DEV, F.FAC_NUM, C.COL_NOM, C.COL_PRENOM, 1 AS INT_FACTURABLE, F.FAC_NOMCLI, F.FAC_NOMPRO, F.COL_NO, F.PRO_NO\n FROM FACTURE F, COLLABORATEUR C, EXTERNE E \n WHERE E.COL_NO = C.COL_NO\n AND F.COL_NO = C.COL_NO\n AND F.FAC_MOIS = '" . $mois . "'\n AND F.FAC_ANNEE = '" . $annee . "'\n GROUP BY F.COL_NO, F.PRO_NO \n ORDER BY C.COL_NOM, C.COL_PRENOM";
$result_ext = $GLOBALS['connexion']->query($query_ext);
$tableau_ext = array();
while ($row_ext = $result_ext->fetch_assoc()) {
$valeur_ext = $row_ext['COL_NO'] . '.' . $row_ext['PRO_NO'];
$valmod = $row_ext['FAC_NUM'] != '' ? '' : bouton('Modifier', 'valider', 'modif(' . $row_ext['FAC_NO'] . ');', 'btn-primary');
$valpro = $row_ext['FAC_NUM'] != '' ? '' : bouton2($row_ext['FAC_DEV'], 'valider', $row_ext['FAC_NO'], 'proforma', 'btn-primary');
$valfac = '';
if ($row_ext['FAC_NUM'] == '' && $row_ext['FAC_AVO'] == '') {
$valfac = bouton('Facturer', 'valider', 'facturer(' . $row_ext['FAC_NO'] . ');', 'btn-primary');
} else {
if ($row_ext['FAC_NUM'] != '' && $row_ext['FAC_AVO'] == '') {
$valfac = bouton2($row_ext['FAC_NUM'], 'valider', $row_ext['FAC_NO'], 'facture', 'btn-primary');
}
}
$tableau_ext[] = array('COL_NO' => $valeur_ext, 'COL_NOM' => $row_ext['COL_NOM'] . ' ' . $row_ext['COL_PRENOM'], 'INT_FACTURABLE' => $row_ext['INT_FACTURABLE'] == 1 ? 'Oui' : 'Non', 'CLI_NOM' => $row_ext['FAC_NOMCLI'], 'PRO_NOM' => $row_ext['FAC_NOMPRO'], 'MODIFIER' => $valmod, 'PROFORMA' => $valpro, 'FACTURE' => $valfac);
}
//On remplace le mot "internes" par externes pour le deuxième tableau
$table = str_replace('internes', 'externes', $table);
//On change l'id
$table = str_replace('tableau1', 'tableau2', $table);
echo $table;
foreach ($tableau_ext as $ligne_ext) {
echo '<tr id=' . $ligne_ext['COL_NO'] . '>';
echo '<td id="COL_NOM' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['COL_NOM'] . '</td>';
}
if ($_SESSION['config']['affiche_bouton_config_absence_pour_admin']) {
bouton_popup(_('admin_button_config_abs_2'), 'tux_config_22x22.png', ROOT_PATH . 'config/config_type_absence.php?session=' . $session, 'configabs', 800, 600);
}
if ($_SESSION['config']['affiche_bouton_config_pour_admin']) {
bouton_popup(_('admin_button_config_2'), 'tux_config_22x22.png', ROOT_PATH . 'config/configure.php?session=' . $session, 'config', 800, 600);
}
}
bouton('All config', 'tux_config_22x22.png', ROOT_PATH . 'config/index.php?session=' . $session);
break;
case 'utilisateur':
if ($_SESSION['config']['export_ical_vcal']) {
bouton_popup(_('Exporter cal'), 'export-22x22.png', ROOT_PATH . 'export/export_vcalendar.php?session=' . $session . '&user_login='******'userlogin'], 'icalvcal', 457, 280);
}
if ($_SESSION['config']['editions_papier']) {
bouton(_('button_editions'), 'edition-22x22.png', ROOT_PATH . 'edition/edit_user.php?session=' . $session);
}
break;
}
echo '</div>';
if (false) {
if ($info == "responsable") {
if ($_SESSION['config']['resp_affiche_calendrier']) {
// bouton calendrier
if ($_SESSION['config']['resp_affiche_calendrier']) {
echo '<div style="float: right;">';
echo "<a href=\"javascript:void(0);\" onClick=\"javascript:OpenPopUp('../calendrier.php?session={$session}','calendrier',1050,600);\">" . "<img src=\"" . TEMPLATE_PATH . "img/rebuild.png\" width=\"17\" height=\"17\" border=\"0\" title=\"" . _('button_calendar') . "\" alt=\"" . _('button_calendar') . "\">" . _('button_calendar') . "</a>\n";
echo '</div>';
}
// bouton imprim calendrier
echo '<div style="float: right;">';
$query_abs_ext = $rq_abs_ext . ' AND COL_NO=' . $row_ext['COL_NO'] . ';';
$result_we_ext = $GLOBALS['connexion']->query($query_we_ext);
$row_we_ext = mysqli_fetch_assoc($result_we_ext);
$result_abs_ext = $GLOBALS['connexion']->query($query_abs_ext);
$row_abs_ext = mysqli_fetch_assoc($result_abs_ext);
if ($row_we_ext['WE'] == null) {
$row_we_ext['WE'] = 0;
}
if ($row_abs_ext['ABS'] == null) {
$row_abs_ext['ABS'] = 0;
}
$prefacturation_ext = $row_ext['MIS_TJM'] * ($row_ext['JW'] - $row_we_ext['WE']);
$prefacturation_ext += $nbSamedi * $row_ext['MIS_TJM'] * 1.5;
$prefacturation_ext += ($nbDimanche + $nbFerie) * $row_ext['MIS_TJM'] * 2;
$valeur_ext = $row_ext['COL_NO'] . '.' . $row_ext['PRO_NO'];
$tableau_ext[] = array('COL_NO' => $valeur_ext, 'COL_NOM' => $row_ext['COL_NOM'] . ' ' . $row_ext['COL_PRENOM'] . ' ­', 'INT_FACTURABLE' => 'Oui', 'COL_JW' => $row_ext['JW'], 'COL_ABS' => $row_abs_ext['ABS'], 'COL_WE' => $row_we_ext['WE'], 'RAM_SAMEDI' => !empty($samedi_travaille) ? implode($samedi_travaille, ',') : ' ­', 'RAM_DIMANCHE' => !empty($dimanche_travaille) ? implode($dimanche_travaille, ',') : ' ­', 'RAM_FERIE' => !empty($ferie_travaille) ? implode($ferie_travaille, ',') : ' ­', 'RAM_CLIENT' => $row_ext['RAM_CLIENT'], 'PRO_NOM' => $row_ext['PRO_NOM'], 'MIS_TJM' => $row_ext['MIS_TJM'], 'PRO_PREFAC' => $row_ext['JW'] * $row_ext['MIS_TJM'], 'BOUTON' => bouton('Générer', 'valider', $valeur_ext, 'btn-primary'), 'MNEMONIC' => $row_ext['COL_MNEMONIC']);
}
echo $table;
foreach ($tableau_ext as $ligne_ext) {
echo '<tr id=' . $ligne_ext['COL_NO'] . '>';
echo '<td id="COL_NOM' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['COL_NOM'] . '</td>';
echo '<td id="INT_FACTURABLE' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['INT_FACTURABLE'] . '</td>';
echo '<td id="COL_JW' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['COL_JW'] . '</td>';
echo '<td id="COL_ABS' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['COL_ABS'] . '</td>';
echo '<td id="COL_WE' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['COL_WE'] . '</td>';
echo '<td id="RAM_SAMEDI' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['RAM_SAMEDI'] . '</td>';
echo '<td id="RAM_DIMANCHE' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['RAM_DIMANCHE'] . '</td>';
echo '<td id="RAM_FERIE' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['RAM_FERIE'] . '</td>';
echo '<td id="RAM_CLIENT' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['RAM_CLIENT'] . '</td>';
echo '<td id="PRO_NOM' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['PRO_NOM'] . '</td>';
echo '<td id="MIS_TJM' . $ligne_ext['COL_NO'] . '">' . $ligne_ext['MIS_TJM'] . '</td>';
