} $sql = "SELECT cp.rowid, cp.fk_user, cp.date_debut, cp.date_fin, cp.halfday"; $sql .= " FROM " . MAIN_DB_PREFIX . "holiday cp"; $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "user u ON cp.fk_user = u.rowid"; $sql .= " WHERE cp.statut = 3"; // Approved // TODO Use BETWEEN instead of date_format $sql .= " AND (date_format(cp.date_debut, '%Y-%c') = '{$year}-{$month}' OR date_format(cp.date_fin, '%Y-%c') = '{$year}-{$month}')"; $sql .= " ORDER BY u.lastname,cp.date_debut"; $result = $db->query($sql); $num = $db->num_rows($result); print_fiche_titre($langs->trans('MenuReportMonth')); print '<div class="tabBar">'; print '<form method="POST" action="' . $_SERVER["PHP_SELF"] . '">' . "\n"; print $langs->trans('Month') . ': '; print $htmlother->select_month($month, 'month_start') . ' '; print $htmlother->select_year($year, 'year_start', 1, 10, 3); print '<input type="submit" value="' . $langs->trans("Refresh") . '" class="button" />'; print '</form>'; print '<br>'; $var = true; print '<table class="noborder" width="40%;">'; print '<tr class="liste_titre">'; print '<td>' . $langs->trans('Ref') . '</td>'; print '<td>' . $langs->trans('Employee') . '</td>'; print '<td>' . $langs->trans('DateDebCP') . '</td>'; print '<td>' . $langs->trans('DateFinCP') . '</td>'; print '<td align="right">' . $langs->trans('nbJours') . '</td>'; print '</tr>'; if ($num == '0') { print '<tr class="pair">';
print '<input type="submit" class="button" name="ajoutercolonne" value="' . dol_escape_htmltag($langs->trans("Add")) . '">'; print ' '; print '<input type="submit" class="button" name="retoursondage" value="' . dol_escape_htmltag($langs->trans("Cancel")) . '">'; print '<br><br>' . "\n"; } else { require_once DOL_DOCUMENT_ROOT . '/core/class/html.formother.class.php'; $formother = new FormOther($db); //ajout d'une date avec creneau horaire print $langs->trans("AddADate") . ':<br><br>' . "\n"; print '<select name="nouveaujour"> ' . "\n"; print '<OPTION VALUE="vide"></OPTION>' . "\n"; for ($i = 1; $i < 32; $i++) { print '<OPTION VALUE="' . $i . '">' . $i . '</OPTION>' . "\n"; } print '</SELECT>' . "\n"; print $formother->select_month('', 'nouveaumois', 1); print ' '; print $formother->select_year('', 'nouvelleannee', 1, 0, 5, 0, 1); print '<br><br>' . $langs->trans("AddStartHour") . ': <br><br>' . "\n"; print '<select name="nouvelleheuredebut"> ' . "\n"; print '<OPTION VALUE="vide"></OPTION>' . "\n"; for ($i = 0; $i < 24; $i++) { print '<OPTION VALUE="' . $i . '">' . $i . ' H</OPTION>' . "\n"; } print '</SELECT>' . "\n"; print '<select name="nouvelleminutedebut"> ' . "\n"; print '<OPTION VALUE="vide"></OPTION>' . "\n"; print '<OPTION VALUE="00">00</OPTION>' . "\n"; print '<OPTION VALUE="15">15</OPTION>' . "\n"; print '<OPTION VALUE="30">30</OPTION>' . "\n"; print '<OPTION VALUE="45">45</OPTION>' . "\n";
} print '<table class="liste" width="100%">' . "\n"; // Titles with sort buttons print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans('Ref'), $_SERVER['PHP_SELF'], 'doc_number', '', $param, 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Date'), $_SERVER['PHP_SELF'], 'dateprint', '', $param, 'align="center" width="150"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Product'), $_SERVER['PHP_SELF'], '', '', $param, 'align="left"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Quantity'), $_SERVER['PHP_SELF'], 'prod_qty', '', $param, 'align="right"', $sortfield, $sortorder); // Filters print '<tr class="liste_titre">'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="sref" size="8" value="' . $sref . '">'; print '</td>'; print '<td class="liste_titre">'; // date print $formother->select_month($month ? $month : -1, 'month', 1); $formother->select_year($year ? $year : -1, 'year', 1, 20, 1); print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="sprod_fulldescr" size="15" value="' . dol_escape_htmltag($sprod_fulldescr) . '">'; print '</td>'; print '<td class="liste_titre" align="right">'; print '<input type="image" class="liste_titre" name="button_search" src="' . img_picto($langs->trans("Search"), 'search.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '">'; print '<input type="image" class="liste_titre" name="button_removefilter" src="' . img_picto($langs->trans("Search"), 'searchclear.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("resetFilters")) . '" title="' . dol_escape_htmltag($langs->trans("resetFilters")) . '">'; print '</td>'; print '</tr>'; if ($sql_select) { $var = true; $num = $db->num_rows($resql); $i = 0; while (($objp = $db->fetch_object($resql)) && $i < $conf->liste_limit) {
print '<tr ' . $bc[$var] . '><td width="35%">' . $langs->trans("VATIntra") . '</td><td>'; print '<input name="tva" size="20" value="' . (!empty($conf->global->MAIN_INFO_TVAINTRA) ? $conf->global->MAIN_INFO_TVAINTRA : '') . '">'; print '</td></tr>'; print '</table>'; /* * Debut d'annee fiscale */ print '<br>'; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print '<td>' . $langs->trans("FiscalYearInformation") . '</td><td>' . $langs->trans("Value") . '</td>'; print "</tr>\n"; $var = true; $var = !$var; print '<tr ' . $bc[$var] . '><td width="35%">' . $langs->trans("FiscalMonthStart") . '</td><td>'; print $formother->select_month($conf->global->SOCIETE_FISCAL_MONTH_START, 'fiscalmonthstart', 1) . '</td></tr>'; print "</table>"; /* * Options fiscale */ print '<br>'; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print '<td>' . $langs->trans("VATManagement") . '</td><td>' . $langs->trans("Description") . '</td>'; print '<td align="right"> </td>'; print "</tr>\n"; $var = true; $var = !$var; print "<tr " . $bc[$var] . "><td width=\"140\"><label><input type=\"radio\" name=\"optiontva\" value=\"reel\"" . ($conf->global->FACTURE_TVAOPTION != "franchise" ? " checked" : "") . "> " . $langs->trans("VATIsUsed") . "</label></td>"; print '<td colspan="2">'; print "<table>";
$year = $_POST["reyear"]; } /* * View */ $formother = new FormOther($db); llxHeader(); $titre = $year ? $langs->trans("PaymentsReportsForYear", $year) : $langs->trans("PaymentsReports"); print load_fiche_titre($titre, '', 'title_accountancy.png'); // Formulaire de generation print '<form method="post" action="rapport.php?year=' . $year . '">'; print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">'; print '<input type="hidden" name="action" value="builddoc">'; $cmonth = GETPOST("remonth") ? GETPOST("remonth") : date("n", time()); $syear = GETPOST("reyear") ? GETPOST("reyear") : date("Y", time()); print $formother->select_month($cmonth, 'remonth'); print $formother->select_year($syear, 'reyear'); print '<input type="submit" class="button" value="' . $langs->trans("Create") . '">'; print '</form>'; print '<br>'; clearstatcache(); // Show link on other years $linkforyear = array(); $found = 0; if (is_dir($dir)) { $handle = opendir($dir); if (is_resource($handle)) { while (($file = readdir($handle)) !== false) { if (is_dir($dir . '/' . $file) && !preg_match('/^\\./', $file) && is_numeric($file)) { $found = 1; $linkforyear[] = $file;