print '<input class="flat" size="6" type="text" name="search_ref" value="' . $search_ref . '">'; print '</td>'; print '<td class="liste_titre">'; print '<input class="flat" size="6" type="text" name="search_refcustomer" value="' . $search_refcustomer . '">'; print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="12" name="search_societe" value="' . $search_societe . '">'; print '</td>'; print '<td class="liste_titre"><input class="flat" type="text" size="10" name="search_town" value="' . $search_town . '"></td>'; // Date print '<td class="liste_titre" colspan="1" align="center">'; //print $langs->trans('Month').': '; print '<input class="flat" type="text" size="1" maxlength="2" name="month" value="' . $month . '">'; //print ' '.$langs->trans('Year').': '; $syear = $year; $formother->select_year($syear, 'year', 1, 20, 5); print '</td>'; print '<td class="liste_titre" colspan="1"> </td>'; // Amount print '<td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="6" name="search_montant_ht" value="' . $search_montant_ht . '">'; print '</td>'; // Author print '<td class="liste_titre" align="center">'; print '<input class="flat" size="6" type="text" name="search_author" value="' . $search_author . '">'; print '</td>'; print '<td class="liste_titre" align="right">'; $formpropal->selectProposalStatus($viewstatut, 1); print '</td>'; print '<td class="liste_titre" align="right">'; print '<input type="image" name="button_search" class="liste_titre" src="' . img_picto($langs->trans("Search"), 'search.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("Search")) . '" title="' . dol_escape_htmltag($langs->trans("Search")) . '">';
print '<form method="get" action="'.$_SERVER["PHP_SELF"].'">'; print '<tr class="liste_titre">'; print '<td class="liste_titre" valign="right">'; print '<input class="flat" size="10" type="text" name="search_ref" value="'.$_GET['search_ref'].'">'; print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="40" name="search_societe" value="'.$_GET['search_societe'].'">'; print '</td>'; print '<td class="liste_titre" colspan="1" align="right">'; print $langs->trans('Month').': <input class="flat" type="text" size="2" maxlength="2" name="month" value="'.$month.'">'; print ' '.$langs->trans('Year').': '; $syear = $year; if($syear == '') $syear = date("Y"); $htmlother->select_year($syear,'year',1, 20, 5); print '</td>'; print '<td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="10" name="search_montant_ht" value="'.$_GET['search_montant_ht'].'">'; print '</td>'; print '<td class="liste_titre" align="right">'; $html->select_propal_statut($viewstatut); print '</td>'; print '<td class="liste_titre" align="right"><input class="liste_titre" type="image" src="'.DOL_URL_ROOT.'/theme/'.$conf->theme.'/img/search.png" value="'.dol_escape_htmltag($langs->trans("Search")).'" title="'.dol_escape_htmltag($langs->trans("Search")).'">'; print '</td>'; print "</tr>\n"; print '</form>'; while ($i < min($num, $limit)) { $objp = $db->fetch_object($result);
print_liste_field_titre($langs->trans("Account"), $_SERVER["PHP_SELF"], "ba.label", "", $params, "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("NbOfCheques"), $_SERVER["PHP_SELF"], "bc.nbcheque", "", $params, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Amount"), $_SERVER["PHP_SELF"], "bc.amount", "", $params, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "bc.statut", "", $params, 'align="right"', $sortfield, $sortorder); print "</tr>\n"; // Lignes des champs de filtre print '<tr class="liste_titre">'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="4" name="search_ref" value="' . $search_ref . '">'; print '</td>'; print '<td class="liste_titre" align="center">'; if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) { print '<input class="flat" type="text" size="1" maxlength="2" name="day" value="' . $day . '">'; } print '<input class="flat" type="text" size="1" maxlength="2" name="month" value="' . $month . '">'; $formother->select_year($year ? $year : -1, 'year', 1, 20, 5); print '</td>'; print '<td>'; $form->select_comptes($search_account, 'search_account', 0, '', 1); print '</td>'; print '<td class="liste_titre"> </td>'; print '<td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="6" name="search_amount" value="' . $search_amount . '">'; print '</td>'; print '<td class="liste_titre" align="right"><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("RemoveFilter")) . '" title="' . dol_escape_htmltag($langs->trans("RemoveFilter")) . '">'; print "</td></tr>\n"; $var = true; while ($i < min($num, $limit)) { $objp = $db->fetch_object($resql); $var = !$var;
$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 '<td colspan="5">' . $langs->trans('None') . '</td>';
print_liste_field_titre($langs->trans("ValidatorCP"), $_SERVER["PHP_SELF"], "cp.fk_validator", "", '', '', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateDebCP"), $_SERVER["PHP_SELF"], "cp.date_debut", "", '', 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("DateFinCP"), $_SERVER["PHP_SELF"], "cp.date_fin", "", '', 'align="center"', $sortfield, $sortorder); print_liste_field_titre($langs->trans("Duration")); print_liste_field_titre($langs->trans("Status"), $_SERVER["PHP_SELF"], "cp.statut", "", '', 'align="center"', $sortfield, $sortorder); print '<td></td>'; print "</tr>\n"; // FILTRES print '<tr class="liste_titre">'; print '<td class="liste_titre" align="left" width="50">'; print '<input class="flat" size="4" type="text" name="search_ref" value="' . $search_ref . '">'; print '</td>'; // DATE CREATE print '<td class="liste_titre" colspan="1" align="center">'; print '<input class="flat" type="text" size="1" maxlength="2" name="month_create" value="' . $month_create . '">'; $formother->select_year($year_create, 'year_create', 1, $min_year, 0); print '</td>'; // UTILISATEUR if ($user->rights->holiday->write_all) { print '<td class="liste_titre" align="left">'; $form->select_users($search_employe, "search_employe", 1, "", 0, ''); print '</td>'; } else { print '<td class="liste_titre"> </td>'; } // VALIDEUR if ($user->rights->holiday->write_all) { print '<td class="liste_titre" align="left">'; $validator = new UserGroup($db); $excludefilter = $user->admin ? '' : 'u.rowid <> ' . $user->id; $valideurobjects = $validator->listUsersForGroup($excludefilter);
print_liste_field_titre($langs->trans('Received'),$_SERVER['PHP_SELF'],'am','',$param,'align="right"',$sortfield,$sortorder); print_liste_field_titre($langs->trans('Status'),$_SERVER['PHP_SELF'],'fk_statut,paye,am','',$param,'align="right"',$sortfield,$sortorder); //print '<td class="liste_titre"> </td>'; print '</tr>'; // Filters lines print '<tr class="liste_titre">'; print '<td class="liste_titre" align="left">'; print '<input class="flat" size="10" type="text" name="search_ref" value="'.$search_ref.'">'; print '</td>'; print '<td class="liste_titre" align="center">'; print '<input class="flat" type="text" size="1" maxlength="2" name="month" value="'.$month.'">'; //print ' '.$langs->trans('Year').': '.$syear; //print 'xx'.$syear.'zz'; //if ($syear == '') $syear = date("Y"); $htmlother->select_year($syear?$syear:-1,'year',1, 20, 5); print '</td>'; print '<td class="liste_titre" align="left"> </td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_societe" value="'.$_GET['search_societe'].'">'; print '</td><td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="10" name="search_montant_ht" value="'.$_GET['search_montant_ht'].'">'; print '</td><td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="10" name="search_montant_ttc" value="'.$_GET['search_montant_ttc'].'">'; print '</td>'; print '<td class="liste_titre" align="right">'; print ' '; print '</td>'; print '<td class="liste_titre" align="right"><input type="image" class="liste_titre" name="button_search" src="'.DOL_URL_ROOT.'/theme/'.$conf->theme.'/img/search.png" value="'.dol_escape_htmltag($langs->trans("Search")).'" title="'.dol_escape_htmltag($langs->trans("Search")).'">'; print "</td></tr>\n";
print '<tr class="liste_titre">'; print '<td class="liste_titre">'; print '<input class="flat" size="6" type="text" name="search_ref" value="' . $search_ref . '">'; print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" size="6" name="search_ref_customer" value="' . $search_ref_customer . '">'; print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_company" value="' . $search_company . '">'; print '</td>'; print '<td class="liste_titre" align="center">'; if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) { print '<input class="flat" type="text" size="1" maxlength="2" name="orderday" value="' . $orderday . '">'; } print '<input class="flat" type="text" size="1" maxlength="2" name="ordermonth" value="' . $ordermonth . '">'; $formother->select_year($orderyear ? $orderyear : -1, 'orderyear', 1, 20, 5); print '</td>'; if (empty($conf->global->ORDER_DISABLE_DELIVERY_DATE)) { print '<td class="liste_titre" align="center">'; if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) { print '<input class="flat" type="text" size="1" maxlength="2" name="deliveryday" value="' . $deliveryday . '">'; } print '<input class="flat" type="text" size="1" maxlength="2" name="deliverymonth" value="' . $deliverymonth . '">'; $formother->select_year($deliveryyear ? $deliveryyear : -1, 'deliveryyear', 1, 20, 5); print '</td>'; } print '<td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="6" name="search_total_ht" value="' . $search_total_ht . '">'; print '</td>'; print '<td align="right">'; $liststatus = array('0' => $langs->trans("StatusOrderDraftShort"), '1' => $langs->trans("StatusOrderValidated"), '2' => $langs->trans("StatusOrderSentShort"), '3' => $langs->trans("StatusOrderDelivered"), '-1' => $langs->trans("StatusOrderCanceledShort"));
$num = $db->num_rows($resql); $i = 0; print_barre_liste($langs->trans("Bookkeeping"), $page, $_SERVER["PHP_SELF"], "", $sortfield, $sortorder, '', $num); /*print '<form name="add" action="' . $_SERVER["PHP_SELF"] . '" method="POST">'; print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">'; print '<input type="hidden" name="action" value="delbookkeeping">'; print $formventilation->select_bookkeeping_importkey('importkey', GETPOST('importkey')); print '<div class="inline-block divButAction"><input type="submit" class="butAction" value="' . $langs->trans("DelBookKeeping") . '" /></div>'; print '</form>';*/ print '<form name="add" action="' . $_SERVER["PHP_SELF"] . '" method="POST">'; print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">'; print '<input type="hidden" name="action" value="delbookkeepingyear">'; print $formother->select_year(GETPOST('delyear'), 'delyear'); print '<div class="inline-block divButAction"><input type="submit" class="butAction" value="' . $langs->trans("DelBookKeeping") . '" /></div>'; print '</form>'; print '<form name="add" action="' . $_SERVER["PHP_SELF"] . '" method="POST">'; print '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">'; print '<input type="hidden" name="action" value="export_csv">'; print '<input type="submit" class="button" style="float: right;" value="' . $langs->trans("Export") . '" onclick="launch_export();" />'; print '</form>'; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("Doctype"), $_SERVER['PHP_SELF'], "bk.doc_type", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Docdate"), $_SERVER['PHP_SELF'], "bk.doc_date", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Docref"), $_SERVER['PHP_SELF'], "bk.doc_ref", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Numerocompte"), $_SERVER['PHP_SELF'], "bk.numero_compte", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Code_tiers"), $_SERVER['PHP_SELF'], "bk.code_tiers", "", "", "", $sortfield, $sortorder); print_liste_field_titre($langs->trans("Labelcompte"), $_SERVER['PHP_SELF'], "bk_label_compte", "", "", "", $sortfield, $sortorder);
print_liste_field_titre('', $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'maxwidthsearch '); print "</tr>\n"; // Filters lines print '<tr class="liste_titre">'; print '<td class="liste_titre" align="left">'; print '<input class="flat" size="6" type="text" name="search_ref" value="' . $search_ref . '">'; print '</td>'; print '<td class="liste_titre">'; print '<input class="flat" size="6" type="text" name="search_refcustomer" value="' . $search_refcustomer . '">'; print '</td>'; print '<td class="liste_titre" align="center">'; if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) { print '<input class="flat" type="text" size="1" maxlength="2" name="day" value="' . $day . '">'; } print '<input class="flat" type="text" size="1" maxlength="2" name="month" value="' . $month . '">'; $formother->select_year($year ? $year : -1, 'year', 1, 20, 5); print '</td>'; print '<td class="liste_titre" align="center">'; if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) { print '<input class="flat" type="text" size="1" maxlength="2" name="day_lim" value="' . $day_lim . '">'; } print '<input class="flat" type="text" size="1" maxlength="2" name="month_lim" value="' . $month_lim . '">'; $formother->select_year($year_lim ? $year_lim : -1, 'year_lim', 1, 20, 5); print '<br><input type="checkbox" name="option" value="late"' . ($option == 'late' ? ' checked' : '') . '> ' . $langs->trans("Late"); print '</td>'; print '<td class="liste_titre" align="left"><input class="flat" type="text" size="8" name="search_societe" value="' . $search_societe . '"></td>'; print '<td class="liste_titre" align="left">'; $form->select_types_paiements($search_paymentmode, 'search_paymentmode', '', 0, 0, 1, 10); print '</td>'; print '<td class="liste_titre" align="right"><input class="flat" type="text" size="6" name="search_montant_ht" value="' . $search_montant_ht . '"></td>'; print '<td class="liste_titre"></td>';
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 '</SELECT>' . "\n"; print '<br><br>' . $langs->trans("AddEndHour") . ': <br><br>' . "\n";
print_liste_field_titre($langs->trans('AmountTTC'), $_SERVER['PHP_SELF'], 'f.total_ttc', '', $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Received'), $_SERVER['PHP_SELF'], 'am', '', $param, 'align="right"', $sortfield, $sortorder); print_liste_field_titre($langs->trans('Status'), $_SERVER['PHP_SELF'], 'fk_statut,paye,am', '', $param, 'align="right"', $sortfield, $sortorder); //print '<td class="liste_titre"> </td>'; print '</tr>'; // Filters lines print '<tr class="liste_titre">'; print '<td class="liste_titre" align="left">'; print '<input class="flat" size="10" type="text" name="search_ref" value="' . $search_ref . '">'; print '</td>'; print '<td class="liste_titre" align="center">'; if (!empty($conf->global->MAIN_LIST_FILTER_ON_DAY)) { print '<input class="flat" type="text" size="1" maxlength="2" name="day" value="' . $day . '">'; } print '<input class="flat" type="text" size="1" maxlength="2" name="month" value="' . $month . '">'; $html->select_year($year ? $year : -1, 'year', 1, 20, 5); print '</td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_terminal" value="' . $search_terminal . '"></td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_user" value="' . $search_user . '"></td>'; print '<td class="liste_titre" align="left">'; print '<input class="flat" type="text" name="search_societe" value="' . $search_societe . '">'; print '</td><td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="10" name="search_montant_ht" value="' . $search_montant_ht . '">'; print '</td><td class="liste_titre" align="right">'; print '<input class="flat" type="text" size="10" name="search_montant_ttc" value="' . $search_montant_ttc . '">'; print '</td>'; print '<td class="liste_titre" align="right">'; print ' '; print '</td>';
} /* * 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; }