}
$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">';
Пример #2
0
     print '<input type="submit" class="button" name="ajoutercolonne" value="' . dol_escape_htmltag($langs->trans("Add")) . '">';
     print ' &nbsp; &nbsp; ';
     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 '&nbsp;';
     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) {
Пример #4
0
 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">&nbsp;</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>";
Пример #5
0
    $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;