29 require
'../main.inc.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.form.class.php';
31 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
32 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
33 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
34 require_once DOL_DOCUMENT_ROOT.
'/user/class/usergroup.class.php';
35 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
36 require_once DOL_DOCUMENT_ROOT.
'/core/lib/usergroups.lib.php';
37 if (!empty($conf->deplacement->enabled)) {
38 require_once DOL_DOCUMENT_ROOT.
'/compta/deplacement/class/deplacement.class.php';
40 if (!empty($conf->expensereport->enabled)) {
41 require_once DOL_DOCUMENT_ROOT.
'/expensereport/class/expensereport.class.php';
43 if (!empty($conf->recruitment->enabled)) {
44 require_once DOL_DOCUMENT_ROOT.
'/recruitment/class/recruitmentcandidature.class.php';
45 require_once DOL_DOCUMENT_ROOT.
'/recruitment/class/recruitmentjobposition.class.php';
47 if (!empty($conf->holiday->enabled)) {
48 require_once DOL_DOCUMENT_ROOT.
'/holiday/class/holiday.class.php';
52 $hookmanager->initHooks(
'hrmindex');
55 $langs->loadLangs(array(
'users',
'holiday',
'trips',
'boxes'));
57 $socid =
GETPOST(
"socid",
"int");
60 if ($user->socid > 0) {
64 if (empty($conf->global->MAIN_INFO_SOCIETE_NOM) || empty($conf->global->MAIN_INFO_SOCIETE_COUNTRY)) {
65 $setupcompanynotcomplete = 1;
68 $max = $conf->global->MAIN_SIZE_SHORTLIST_LIMIT;
76 if (!empty($conf->holiday->enabled) && !empty($setupcompanynotcomplete)) {
77 $holidaystatic =
new Holiday($db);
78 $result = $holidaystatic->updateBalance();
86 $childids = $user->getAllChildIds();
87 $childids[] = $user->id;
89 $title = $langs->trans(
'HRMArea');
96 if (!empty($setupcompanynotcomplete)) {
97 $langs->load(
"errors");
98 $warnpicto =
img_warning($langs->trans(
"WarningMandatorySetupNotComplete"));
99 print
'<br><div class="warning"><a href="'.DOL_URL_ROOT.
'/admin/company.php?mainmenu=home'.(empty($setupcompanynotcomplete) ?
'' :
'&action=edit&token='.newToken()).
'">'.$warnpicto.
' '.$langs->trans(
"WarningMandatorySetupNotComplete").
'</a></div>';
106 print
'<div class="fichecenter"><div class="fichethirdleft">';
108 if (!empty($conf->global->MAIN_SEARCH_FORM_ON_HOME_AREAS)) {
109 if (!empty($conf->holiday->enabled) && $user->rights->holiday->read) {
110 $langs->load(
"holiday");
111 $listofsearchfields[
'search_holiday'] = array(
'text'=>
'TitreRequestCP');
113 if (!empty($conf->deplacement->enabled) && $user->rights->deplacement->lire) {
114 $langs->load(
"trips");
115 $listofsearchfields[
'search_deplacement'] = array(
'text'=>
'ExpenseReport');
117 if (!empty($conf->expensereport->enabled) && $user->rights->expensereport->lire) {
118 $langs->load(
"trips");
119 $listofsearchfields[
'search_expensereport'] = array(
'text'=>
'ExpenseReport');
121 if (count($listofsearchfields)) {
122 print
'<form method="post" action="'.DOL_URL_ROOT.
'/core/search.php">';
123 print
'<input type="hidden" name="token" value="'.newToken().
'">';
124 print
'<div class="div-table-responsive-no-min">';
125 print
'<table class="noborder nohover centpercent">';
127 foreach ($listofsearchfields as $key => $value) {
129 print
'<tr class="liste_titre"><td colspan="3">'.$langs->trans(
"Search").
'</td></tr>';
131 print
'<tr '.$bc[
false].
'>';
132 print
'<td class="nowrap"><label for="'.$key.
'">'.$langs->trans($value[
"text"]).
'</label></td><td><input type="text" class="flat inputsearch" name="'.$key.
'" id="'.$key.
'" size="18"></td>';
134 print
'<td rowspan="'.count($listofsearchfields).
'"><input type="submit" value="'.$langs->trans(
"Search").
'" class="button"></td>';
147 if (!empty($conf->holiday->enabled)) {
148 if (empty($conf->global->HOLIDAY_HIDE_BALANCE)) {
149 $holidaystatic =
new Holiday($db);
150 $user_id = $user->id;
152 print
'<div class="div-table-responsive-no-min">';
153 print
'<table class="noborder nohover centpercent">';
154 print
'<tr class="liste_titre"><th colspan="3">'.$langs->trans(
"Holidays").
'</th></tr>';
155 print
'<tr class="oddeven">';
160 $typeleaves = $holidaystatic->getTypes(1, 1);
161 foreach ($typeleaves as $key => $val) {
162 $nb_type = $holidaystatic->getCPforUser($user->id, $val[
'rowid']);
163 $nb_holiday += $nb_type;
164 $out .=
' - '.($langs->trans($val[
'code']) != $val[
'code'] ? $langs->trans($val[
'code']) : $val[
'label']).
': <strong>'.($nb_type ?
price2num($nb_type) : 0).
'</strong><br>';
166 $balancetoshow = $langs->trans(
'SoldeCPUser',
'{s1}');
167 print
'<div class="valignmiddle div-balanceofleave">'.str_replace(
'{s1}',
img_picto(
'',
'holiday',
'class="paddingleft pictofixedwidth"').
'<span class="balanceofleave valignmiddle'.($nb_holiday > 0 ?
' amountpaymentcomplete' : ($nb_holiday < 0 ?
' amountremaintopay' :
' amountpaymentneutral')).
'">'.round($nb_holiday, 5).
'</span>', $balancetoshow).
'</div>';
168 print
'<span class="opacitymedium">'.$out.
'</span>';
172 print
'</table></div><br>';
173 } elseif (!is_numeric($conf->global->HOLIDAY_HIDE_BALANCE)) {
174 print $langs->trans($conf->global->HOLIDAY_HIDE_BALANCE).
'<br>';
179 print
'</div><div class="fichetwothirdright">';
184 if (!empty($conf->holiday->enabled) && $user->rights->holiday->read) {
185 $sql =
"SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.photo, u.statut as user_status,";
186 $sql .=
" x.rowid, x.ref, x.fk_type, x.date_debut as date_start, x.date_fin as date_end, x.halfday, x.tms as dm, x.statut as status";
187 $sql .=
" FROM ".MAIN_DB_PREFIX.
"holiday as x, ".MAIN_DB_PREFIX.
"user as u";
188 $sql .=
" WHERE u.rowid = x.fk_user";
189 $sql .=
" AND x.entity = ".$conf->entity;
190 if (empty($user->rights->holiday->readall)) {
191 $sql .=
' AND x.fk_user IN ('.$db->sanitize(join(
',', $childids)).
')';
195 $sql .= $db->order(
"x.tms",
"DESC");
196 $sql .= $db->plimit($max, 0);
198 $result = $db->query($sql);
201 $num = $db->num_rows($result);
203 $holidaystatic =
new Holiday($db);
204 $userstatic =
new User($db);
206 $listhalfday = array(
'morning'=>$langs->trans(
"Morning"),
"afternoon"=>$langs->trans(
"Afternoon"));
207 $typeleaves = $holidaystatic->getTypes(1, -1);
211 print
'<div class="div-table-responsive-no-min">';
212 print
'<table class="noborder centpercent">';
213 print
'<tr class="liste_titre">';
214 print
'<th colspan="3">'.$langs->trans(
"BoxTitleLastLeaveRequests", min($max, $num)).
'</th>';
215 print
'<th>'.$langs->trans(
"from").
'</th>';
216 print
'<th>'.$langs->trans(
"to").
'</th>';
217 print
'<th class="right" colspan="2"><a href="'.DOL_URL_ROOT.
'/holiday/list.php?sortfield=cp.tms&sortorder=DESC">'.$langs->trans(
"FullList").
'</th>';
220 while ($i < $num && $i < $max) {
221 $obj = $db->fetch_object($result);
223 $holidaystatic->id = $obj->rowid;
224 $holidaystatic->ref = $obj->ref;
225 $holidaystatic->statut = $obj->status;
226 $holidaystatic->date_debut = $db->jdate($obj->date_start);
228 $userstatic->id = $obj->uid;
229 $userstatic->lastname = $obj->lastname;
230 $userstatic->firstname = $obj->firstname;
231 $userstatic->login = $obj->login;
232 $userstatic->photo = $obj->photo;
233 $userstatic->email = $obj->email;
234 $userstatic->statut = $obj->user_status;
236 print
'<tr class="oddeven">';
237 print
'<td class="nowraponall">'.$holidaystatic->getNomUrl(1).
'</td>';
238 print
'<td class="tdoverflowmax100">'.$userstatic->getNomUrl(-1,
'leave').
'</td>';
240 $leavecode = empty($typeleaves[$obj->fk_type]) ?
'Undefined' : $typeleaves[$obj->fk_type][
'code'];
241 print
'<td class="tdoverflowmax100" title="'.dol_escape_htmltag($langs->trans($leavecode)).
'">'.
dol_escape_htmltag($langs->trans($leavecode)).
'</td>';
243 $starthalfday = ($obj->halfday == -1 || $obj->halfday == 2) ?
'afternoon' :
'morning';
244 $endhalfday = ($obj->halfday == 1 || $obj->halfday == 2) ?
'morning' :
'afternoon';
246 print
'<td>'.dol_print_date($db->jdate($obj->date_start),
'day').
' <span class="opacitymedium">'.$langs->trans($listhalfday[$starthalfday]).
'</span>';
247 print
'<td>'.dol_print_date($db->jdate($obj->date_end),
'day').
' <span class="opacitymedium">'.$langs->trans($listhalfday[$endhalfday]).
'</span>';
248 print
'<td class="right">'.dol_print_date($db->jdate($obj->dm),
'day').
'</td>';
249 print
'<td class="right nowrap" width="16">'.$holidaystatic->LibStatut($obj->status, 3, $holidaystatic->date_debut).
'</td>';
255 print
'<tr class="oddeven"><td colspan="7" class="opacitymedium">'.$langs->trans(
"None").
'</td></tr>';
267 if (!empty($conf->expensereport->enabled) && $user->rights->expensereport->lire) {
268 $sql =
"SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.statut as user_status, u.photo,";
269 $sql .=
" x.rowid, x.ref, x.date_debut as date, x.tms as dm, x.total_ttc, x.fk_statut as status";
270 $sql .=
" FROM ".MAIN_DB_PREFIX.
"expensereport as x, ".MAIN_DB_PREFIX.
"user as u";
272 $sql .=
" WHERE u.rowid = x.fk_user_author";
273 $sql .=
" AND x.entity = ".$conf->entity;
274 if (empty($user->rights->expensereport->readall) && empty($user->rights->expensereport->lire_tous)) {
275 $sql .=
' AND x.fk_user_author IN ('.$db->sanitize(join(
',', $childids)).
')';
279 $sql .= $db->order(
"x.tms",
"DESC");
280 $sql .= $db->plimit($max, 0);
282 $result = $db->query($sql);
284 $num = $db->num_rows($result);
288 print
'<div class="div-table-responsive-no-min">';
289 print
'<table class="noborder centpercent">';
290 print
'<tr class="liste_titre">';
291 print
'<th colspan="2">'.$langs->trans(
"BoxTitleLastModifiedExpenses", min($max, $num)).
'</th>';
292 print
'<th class="right">'.$langs->trans(
"TotalTTC").
'</th>';
293 print
'<th class="right" colspan="2"><a href="'.DOL_URL_ROOT.
'/expensereport/list.php?sortfield=d.tms&sortorder=DESC">'.$langs->trans(
"FullList").
'</th>';
296 $total_ttc = $totalam = $total = 0;
299 $userstatic =
new User($db);
300 while ($i < $num && $i < $max) {
301 $obj = $db->fetch_object($result);
303 $expensereportstatic->id = $obj->rowid;
304 $expensereportstatic->ref = $obj->ref;
305 $expensereportstatic->statut = $obj->status;
306 $expensereportstatic->status = $obj->status;
308 $userstatic->id = $obj->uid;
309 $userstatic->lastname = $obj->lastname;
310 $userstatic->firstname = $obj->firstname;
311 $userstatic->email = $obj->email;
312 $userstatic->login = $obj->login;
313 $userstatic->statut = $obj->user_status;
314 $userstatic->photo = $obj->photo;
316 print
'<tr class="oddeven">';
317 print
'<td class="tdoverflowmax200">'.$expensereportstatic->getNomUrl(1).
'</td>';
318 print
'<td class="tdoverflowmax150">'.$userstatic->getNomUrl(-1).
'</td>';
319 print
'<td class="right amount">'.price($obj->total_ttc).
'</td>';
320 print
'<td class="right">'.dol_print_date($db->jdate($obj->dm),
'day').
'</td>';
321 print
'<td class="right nowraponall" width="16">'.$expensereportstatic->LibStatut($obj->status, 3).
'</td>';
327 print
'<tr class="oddeven"><td colspan="5" class="opacitymedium">'.$langs->trans(
"None").
'</td></tr>';
339 if (!empty($conf->recruitment->enabled) && $user->rights->recruitment->recruitmentjobposition->read) {
342 $sql =
"SELECT rc.rowid, rc.ref, rc.email, rc.lastname, rc.firstname, rc.date_creation, rc.tms, rc.status,";
343 $sql.=
" rp.rowid as jobid, rp.ref as jobref, rp.label";
344 $sql .=
" FROM ".MAIN_DB_PREFIX.
"recruitment_recruitmentcandidature as rc";
345 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"recruitment_recruitmentjobposition as rp ON rc.fk_recruitmentjobposition = rp.rowid";
346 if (
isModEnabled(
'societe') && empty($user->rights->societe->client->voir) && !$socid) {
347 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
349 $sql .=
" WHERE rc.entity IN (".getEntity($staticrecruitmentcandidature->element).
")";
350 if (
isModEnabled(
'societe') && empty($user->rights->societe->client->voir) && !$socid) {
351 $sql .=
" AND rp.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
354 $sql .=
" AND rp.fk_soc = $socid";
356 $sql .= $db->order(
"rc.tms",
"DESC");
357 $sql .= $db->plimit($max, 0);
359 $resql = $db->query($sql);
361 $num = $db->num_rows(
$resql);
364 print
'<div class="div-table-responsive-no-min">';
365 print
'<table class="noborder centpercent">';
366 print
'<tr class="liste_titre">';
367 print
'<th colspan="3">';
368 print $langs->trans(
"BoxTitleLatestModifiedCandidatures", min($max, $num));
370 print
'<th class="right" colspan="2"><a href="'.DOL_URL_ROOT.
'/recruitment/recruitmentcandidature_list.php?sortfield=t.tms&sortorder=DESC">'.$langs->trans(
"FullList").
'</th>';
374 $objp = $db->fetch_object(
$resql);
375 $staticrecruitmentcandidature->id = $objp->rowid;
376 $staticrecruitmentcandidature->ref = $objp->ref;
377 $staticrecruitmentcandidature->email = $objp->email;
378 $staticrecruitmentcandidature->status = $objp->status;
379 $staticrecruitmentcandidature->date_creation = $objp->date_creation;
380 $staticrecruitmentcandidature->firstname = $objp->firstname;
381 $staticrecruitmentcandidature->lastname = $objp->lastname;
383 $staticrecruitmentjobposition->id = $objp->jobid;
384 $staticrecruitmentjobposition->ref = $objp->jobref;
385 $staticrecruitmentjobposition->label = $objp->label;
387 print
'<tr class="oddeven">';
388 print
'<td class="nowraponall">'.$staticrecruitmentcandidature->getNomUrl(1,
'').
'</td>';
389 print
'<td class="tdoverflowmax150">'.$staticrecruitmentcandidature->getFullName($langs).
'</td>';
390 print
'<td class="nowraponall">'.$staticrecruitmentjobposition->getNomUrl(1).
'</td>';
391 print
'<td class="right nowrap">'.dol_print_date($db->jdate($objp->tms),
'day').
'</td>';
392 print
'<td class="right nowrap" width="16">';
393 print $staticrecruitmentcandidature->getLibStatut(3);
401 print
'<tr class="oddeven"><td colspan="4" class="opacitymedium">'.$langs->trans(
"None").
'</td></tr>';
411 print
'</div></div>';
414 $parameters = array(
'user' => $user);
415 $reshook = $hookmanager->executeHooks(
'dashboardHRM', $parameters, $object);