27 require
'../main.inc.php';
28 require_once DOL_DOCUMENT_ROOT.
'/holiday/class/holiday.class.php';
29 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
31 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
32 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
35 $langs->loadLangs(array(
'holiday',
'hrm'));
41 if ($user->socid > 0) {
47 $action =
GETPOST(
'action',
'aZ09') ?
GETPOST(
'action',
'aZ09') :
'view';
48 $massaction =
GETPOST(
'massaction',
'alpha');
49 $contextpage =
GETPOST(
'contextpage',
'aZ');
50 $optioncss =
GETPOST(
'optioncss',
'aZ');
52 $search_ref =
GETPOST(
'search_ref',
'alphanohtml');
53 $search_employee =
GETPOST(
'search_employee',
'int');
54 $search_type =
GETPOST(
'search_type',
'int');
55 $search_description =
GETPOST(
'search_description',
'alphanohtml');
57 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
58 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
59 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
62 $sortfield =
"cp.rowid";
69 if (empty($page) || $page == -1) {
73 $hookmanager->initHooks(array(
'leavemovementlist'));
75 $arrayfields = array();
76 $arrayofmassactions = array();
82 if (
GETPOST(
'cancel',
'alpha')) {
83 $action =
'list'; $massaction =
'';
85 if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
89 $parameters = array();
90 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
95 if (empty($reshook)) {
97 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
100 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
102 $search_employee =
'';
104 $search_description =
'';
106 $search_array_options = array();
109 if (
GETPOST(
'button_removefilter_x',
'alpha')
110 ||
GETPOST(
'button_removefilter.x',
'alpha')
111 ||
GETPOST(
'button_removefilter',
'alpha')
112 ||
GETPOST(
'button_search_x',
'alpha')
113 ||
GETPOST(
'button_search.x',
'alpha')
114 ||
GETPOST(
'button_search',
'alpha')) {
119 $arrayfields = array(
120 'cp.ref'=>array(
'label'=>$langs->trans(
'Ref'),
'checked'=>1),
121 'cp.fk_user'=>array(
'label'=>$langs->trans(
'Employee'),
'checked'=>1),
122 'cp.fk_type'=>array(
'label'=>$langs->trans(
'Type'),
'checked'=>1),
123 'cp.date_debut'=>array(
'label'=>$langs->trans(
'DateDebCP'),
'checked'=>1),
124 'cp.date_fin'=>array(
'label'=>$langs->trans(
'DateFinCP'),
'checked'=>1),
125 'used_days'=>array(
'label'=>$langs->trans(
'NbUseDaysCPShort'),
'checked'=>1),
126 'date_start_month'=>array(
'label'=>$langs->trans(
'DateStartInMonth'),
'checked'=>1),
127 'date_end_month'=>array(
'label'=>$langs->trans(
'DateEndInMonth'),
'checked'=>1),
128 'used_days_month'=>array(
'label'=>$langs->trans(
'NbUseDaysCPShortInMonth'),
'checked'=>1),
129 'cp.description'=>array(
'label'=>$langs->trans(
'DescCP'),
'checked'=>1),
139 $holidaystatic =
new Holiday($db);
141 $listhalfday = array(
'morning'=>$langs->trans(
"Morning"),
"afternoon"=>$langs->trans(
"Afternoon"));
143 $title = $langs->trans(
'CPTitreMenu');
147 $search_month =
GETPOST(
"remonth",
'int') ?
GETPOST(
"remonth",
'int') : date(
"m", time());
148 $search_year =
GETPOST(
"reyear",
'int') ?
GETPOST(
"reyear",
'int') : date(
"Y", time());
149 $year_month = sprintf(
"%04d", $search_year).
'-'.sprintf(
"%02d", $search_month);
151 $sql =
"SELECT cp.rowid, cp.ref, cp.fk_user, cp.date_debut, cp.date_fin, cp.fk_type, cp.description, cp.halfday";
152 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday cp";
153 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"user u ON cp.fk_user = u.rowid";
154 $sql .=
" WHERE cp.rowid > 0";
155 $sql .=
" AND cp.statut = ".Holiday::STATUS_APPROVED;
157 $sql .=
" (date_format(cp.date_debut, '%Y-%m') = '".$db->escape($year_month).
"' OR date_format(cp.date_fin, '%Y-%m') = '".$db->escape($year_month).
"')";
159 $sql .=
" (date_format(cp.date_debut, '%Y-%m') < '".$db->escape($year_month).
"' AND date_format(cp.date_fin, '%Y-%m') > '".$db->escape($year_month).
"') ";
161 if (!empty($search_ref)) {
164 if (!empty($search_employee) && $search_employee > 0) {
165 $sql .=
" AND cp.fk_user = ".((int) $search_employee);
167 if (!empty($search_type) && $search_type !=
'-1') {
168 $sql .=
' AND cp.fk_type IN ('.$db->sanitize($search_type).
')';
170 if (!empty($search_description)) {
174 $sql .= $db->order($sortfield, $sortorder);
176 $resql = $db->query($sql);
182 $num = $db->num_rows(
$resql);
185 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
186 $param .=
'&contextpage='.urlencode($contextpage);
188 if ($limit > 0 && $limit != $conf->liste_limit) {
189 $param .=
'&limit='.urlencode($limit);
191 if (!empty($search_ref)) {
192 $param .=
'&search_ref='.urlencode($search_ref);
194 if (!empty($search_employee)) {
195 $param .=
'&search_employee='.urlencode($search_employee);
197 if (!empty($search_type)) {
198 $param .=
'&search_type='.urlencode($search_type);
200 if (!empty($search_description)) {
201 $param .=
'&search_description='.urlencode($search_description);
204 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">';
205 if ($optioncss !=
'') {
206 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
208 print
'<input type="hidden" name="token" value="'.newToken().
'">';
209 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
210 print
'<input type="hidden" name="action" value="list">';
211 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
212 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
213 print
'<input type="hidden" name="page" value="'.$page.
'">';
214 print
'<input type="hidden" name="contextpage" value="'.$contextpage.
'">';
219 print
'<div class="tabBar">';
220 print $formother->select_month($search_month,
'remonth', 0, 0,
'minwidth50 maxwidth75imp valignmiddle',
true);
221 print $formother->selectyear($search_year,
'reyear', 0, 10, 5, 0, 0,
'',
'valignmiddle width75',
true);
222 print
'<input type="submit" class="button" value="'.dol_escape_htmltag($langs->trans(
"Search")).
'" />';
228 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
229 $selectedfields =
'';
230 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
231 $selectedfields .= (count($arrayofmassactions) ?
$form->showCheckAddButtons(
'checkforselect', 1) :
'');
233 print
'<div class="div-table-responsive">';
234 print
'<table class="noborder centpercent">';
236 print
'<tr class="liste_titre">';
239 if (!empty($arrayfields[
'cp.ref'][
'checked'])) {
240 print
'<td class="liste_titre">';
241 print
'<input class="flat maxwidth100" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
246 if (!empty($arrayfields[
'cp.fk_user'][
'checked'])) {
247 print
'<td class="liste_titre">';
248 print
$form->select_dolusers($search_employee,
"search_employee", 1,
null, 0,
'',
'', 0, 0, 0,
'', 0,
'',
'maxwidth200');
253 if (!empty($arrayfields[
'cp.fk_type'][
'checked'])) {
254 $typeleaves = $holidaystatic->getTypes(1, -1);
255 $arraytypeleaves = array();
256 foreach ($typeleaves as $key => $val) {
257 $labeltoshow = ($langs->trans($val[
'code']) != $val[
'code'] ? $langs->trans($val[
'code']) : $val[
'label']);
258 $arraytypeleaves[$val[
'rowid']] = $labeltoshow;
261 print
'<td class="liste_titre">';
262 print
$form->selectarray(
'search_type', $arraytypeleaves, $search_type, 1, 0, 0,
'', 0, 0, 0,
'',
'', 1);
266 if (!empty($arrayfields[
'cp.date_debut'][
'checked'])) {
267 print
'<td class="liste_titre"></td>';
269 if (!empty($arrayfields[
'cp.date_fin'][
'checked'])) {
270 print
'<td class="liste_titre"></td>';
272 if (!empty($arrayfields[
'used_days'][
'checked'])) {
273 print
'<td class="liste_titre"></td>';
275 if (!empty($arrayfields[
'date_start_month'][
'checked'])) {
276 print
'<td class="liste_titre"></td>';
278 if (!empty($arrayfields[
'date_end_month'][
'checked'])) {
279 print
'<td class="liste_titre"></td>';
281 if (!empty($arrayfields[
'used_days_month'][
'checked'])) {
282 print
'<td class="liste_titre"></td>';
286 if (!empty($arrayfields[
'cp.description'][
'checked'])) {
287 print
'<td class="liste_titre">';
288 print
'<input type="text" class="maxwidth100" name="search_description" value="'.$search_description.
'">';
293 print
'<td class="liste_titre maxwidthsearch">';
294 $searchpicto =
$form->showFilterButtons();
299 print
'<tr class="liste_titre">';
300 if (!empty($arrayfields[
'cp.ref'][
'checked'])) {
301 print_liste_field_titre($arrayfields[
'cp.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'cp.ref',
'',
'',
'', $sortfield, $sortorder);
303 if (!empty($arrayfields[
'cp.fk_user'][
'checked'])) {
304 print_liste_field_titre($arrayfields[
'cp.fk_user'][
'label'], $_SERVER[
"PHP_SELF"],
'cp.fk_user',
'',
'',
'', $sortfield, $sortorder);
306 if (!empty($arrayfields[
'cp.fk_type'][
'checked'])) {
307 print_liste_field_titre($arrayfields[
'cp.fk_type'][
'label'], $_SERVER[
"PHP_SELF"],
'cp.fk_type',
'',
'',
'', $sortfield, $sortorder);
309 if (!empty($arrayfields[
'ct.label'][
'checked'])) {
310 print_liste_field_titre($arrayfields[
'ct.label'][
'label'], $_SERVER[
"PHP_SELF"],
'ct.label',
'',
'',
'', $sortfield, $sortorder);
312 if (!empty($arrayfields[
'cp.date_debut'][
'checked'])) {
313 print_liste_field_titre($arrayfields[
'cp.date_debut'][
'label'], $_SERVER[
"PHP_SELF"],
'cp.date_debut',
'',
'',
'', $sortfield, $sortorder);
315 if (!empty($arrayfields[
'cp.date_fin'][
'checked'])) {
316 print_liste_field_titre($arrayfields[
'cp.date_fin'][
'label'], $_SERVER[
"PHP_SELF"],
'cp.date_fin',
'',
'',
'', $sortfield, $sortorder);
318 if (!empty($arrayfields[
'used_days'][
'checked'])) {
319 print_liste_field_titre($arrayfields[
'used_days'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder);
321 if (!empty($arrayfields[
'date_start_month'][
'checked'])) {
322 print_liste_field_titre($arrayfields[
'date_start_month'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder);
324 if (!empty($arrayfields[
'date_end_month'][
'checked'])) {
325 print_liste_field_titre($arrayfields[
'date_end_month'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder);
327 if (!empty($arrayfields[
'used_days_month'][
'checked'])) {
328 print_liste_field_titre($arrayfields[
'used_days_month'][
'label'], $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder);
330 if (!empty($arrayfields[
'cp.description'][
'checked'])) {
331 print_liste_field_titre($arrayfields[
'cp.description'][
'label'], $_SERVER[
"PHP_SELF"],
'cp.description',
'',
'',
'', $sortfield, $sortorder);
333 print
getTitleFieldOfList($selectedfields, 0, $_SERVER[
"PHP_SELF"],
'',
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ').
"\n";
337 print
'<tr><td colspan="10" class="opacitymedium">'.$langs->trans(
'None').
'</td></tr>';
339 while ($obj = $db->fetch_object(
$resql)) {
340 $user =
new User($db);
341 $user->fetch($obj->fk_user);
343 $date_start = $db->jdate($obj->date_debut,
true);
344 $date_end = $db->jdate($obj->date_fin,
true);
349 $starthalfday = ($obj->halfday == -1 || $obj->halfday == 2) ?
'afternoon' :
'morning';
350 $endhalfday = ($obj->halfday == 1 || $obj->halfday == 2) ?
'morning' :
'afternoon';
352 $halfdayinmonth = $obj->halfday;
353 $starthalfdayinmonth = $starthalfday;
354 $endhalfdayinmonth = $endhalfday;
359 $date_start_inmonth = $db->jdate($obj->date_debut,
true);
360 $date_end_inmonth = $db->jdate($obj->date_fin,
true);
361 if ($tmpstart[
'year'] < $search_year || $tmpstart[
'mon'] < $search_month) {
363 $starthalfdayinmonth =
'morning';
364 if ($halfdayinmonth == 2) {
367 if ($halfdayinmonth == -1) {
371 if ($tmpend[
'year'] > $search_year || $tmpend[
'mon'] > $search_month) {
372 $date_end_inmonth =
dol_get_last_day($search_year, $search_month,
true) - ((24 * 3600) - 1);
373 $endhalfdayinmonth =
'afternoon';
374 if ($halfdayinmonth == 2) {
375 $halfdayinmonth = -1;
377 if ($halfdayinmonth == 1) {
383 $holidaystatic->id = $obj->rowid;
384 $holidaystatic->ref = $obj->ref;
386 print
'<tr class="oddeven">';
388 if (!empty($arrayfields[
'cp.ref'][
'checked'])) {
389 print
'<td>'.$holidaystatic->getNomUrl(1, 1).
'</td>';
391 if (!empty($arrayfields[
'cp.fk_user'][
'checked'])) {
392 print
'<td>'.$user->getFullName($langs).
'</td>';
394 if (!empty($arrayfields[
'cp.fk_type'][
'checked'])) {
395 print
'<td>'.$arraytypeleaves[$obj->fk_type].
'</td>';
398 if (!empty($arrayfields[
'cp.date_debut'][
'checked'])) {
399 print
'<td class="center">'.dol_print_date($db->jdate($obj->date_debut),
'day');
400 print
' <span class="opacitymedium">('.$langs->trans($listhalfday[$starthalfday]).
')</span>';
404 if (!empty($arrayfields[
'cp.date_fin'][
'checked'])) {
405 print
'<td class="center">'.dol_print_date($db->jdate($obj->date_fin),
'day');
406 print
' <span class="opacitymedium">('.$langs->trans($listhalfday[$endhalfday]).
')</span>';
410 if (!empty($arrayfields[
'used_days'][
'checked'])) {
411 print
'<td class="right">'.num_open_day($date_start, $date_end, 0, 1, $obj->halfday).
'</td>';
414 if (!empty($arrayfields[
'date_start_month'][
'checked'])) {
415 print
'<td class="center">'.dol_print_date($date_start_inmonth,
'day');
416 print
' <span class="opacitymedium">('.$langs->trans($listhalfday[$starthalfdayinmonth]).
')</span>';
420 if (!empty($arrayfields[
'date_end_month'][
'checked'])) {
421 print
'<td class="center">'.dol_print_date($date_end_inmonth,
'day');
422 print
' <span class="opacitymedium">('.$langs->trans($listhalfday[$endhalfdayinmonth]).
')</span>';
426 if (!empty($arrayfields[
'used_days_month'][
'checked'])) {
427 print
'<td class="right">'.num_open_day($date_start_inmonth, $date_end_inmonth, 0, 1, $halfdayinmonth).
'</td>';
429 if (!empty($arrayfields[
'cp.description'][
'checked'])) {
430 print
'<td class="maxwidth300 small">'.dolGetFirstLineOfText(
dol_string_nohtmltag($obj->description, 1)).
'</td>';