index.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429
  1. <?php
  2. /* Copyright (C) 2011 Dimitri Mouillard <dmouillard@teclib.com>
  3. * Copyright (C) 2013-2015 Laurent Destailleur <eldy@users.sourceforge.net>
  4. * Copyright (C) 2012-2014 Regis Houssin <regis.houssin@inodbox.com>
  5. * Copyright (C) 2015-2016 Alexandre Spangaro <aspangaro@open-dsi.fr>
  6. * Copyright (C) 2019 Nicolas ZABOURI <info@inovea-conseil.com>
  7. * Copyright (C) 2021 Frédéric France <frederic.france@netlogic.fr>
  8. *
  9. * This program is free software; you can redistribute it and/or modify
  10. * it under the terms of the GNU General Public License as published by
  11. * the Free Software Foundation; either version 3 of the License, or
  12. * (at your option) any later version.
  13. *
  14. * This program is distributed in the hope that it will be useful,
  15. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  16. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  17. * GNU General Public License for more details.
  18. *
  19. * You should have received a copy of the GNU General Public License
  20. * along with this program. If not, see <https://www.gnu.org/licenses/>.
  21. */
  22. /**
  23. * \file htdocs/hrm/index.php
  24. * \ingroup hrm
  25. * \brief Home page for HRM area.
  26. */
  27. // Load Dolibarr environment
  28. require '../main.inc.php';
  29. require_once DOL_DOCUMENT_ROOT.'/core/class/html.form.class.php';
  30. require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
  31. require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
  32. require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
  33. require_once DOL_DOCUMENT_ROOT.'/core/lib/usergroups.lib.php';
  34. require_once DOL_DOCUMENT_ROOT.'/user/class/user.class.php';
  35. require_once DOL_DOCUMENT_ROOT.'/user/class/usergroup.class.php';
  36. if (isModEnabled('deplacement')) {
  37. require_once DOL_DOCUMENT_ROOT.'/compta/deplacement/class/deplacement.class.php';
  38. }
  39. if (isModEnabled('expensereport')) {
  40. require_once DOL_DOCUMENT_ROOT.'/expensereport/class/expensereport.class.php';
  41. }
  42. if (isModEnabled('recruitment')) {
  43. require_once DOL_DOCUMENT_ROOT.'/recruitment/class/recruitmentcandidature.class.php';
  44. require_once DOL_DOCUMENT_ROOT.'/recruitment/class/recruitmentjobposition.class.php';
  45. }
  46. if (isModEnabled('holiday')) {
  47. require_once DOL_DOCUMENT_ROOT.'/holiday/class/holiday.class.php';
  48. }
  49. // Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context
  50. $hookmanager = new HookManager($db);
  51. $hookmanager->initHooks('hrmindex');
  52. // Load translation files required by the page
  53. $langs->loadLangs(array('users', 'holiday', 'trips', 'boxes'));
  54. // Get Parameters
  55. $socid = GETPOST("socid", "int");
  56. // Protection if external user
  57. if ($user->socid > 0) {
  58. accessforbidden();
  59. }
  60. if (!getDolGlobalString('MAIN_INFO_SOCIETE_NOM') || !getDolGlobalString('MAIN_INFO_SOCIETE_COUNTRY')) {
  61. $setupcompanynotcomplete = 1;
  62. }
  63. $max = getDolGlobalInt('MAIN_SIZE_SHORTLIST_LIMIT');
  64. /*
  65. * Actions
  66. */
  67. // Update sold
  68. if (isModEnabled('holiday') && !empty($setupcompanynotcomplete)) {
  69. $holidaystatic = new Holiday($db);
  70. $result = $holidaystatic->updateBalance();
  71. }
  72. /*
  73. * View
  74. */
  75. $listofsearchfields = array();
  76. $childids = $user->getAllChildIds();
  77. $childids[] = $user->id;
  78. $title = $langs->trans('HRMArea');
  79. llxHeader('', $title, '');
  80. print load_fiche_titre($langs->trans("HRMArea"), '', 'hrm');
  81. if (!empty($setupcompanynotcomplete)) {
  82. $langs->load("errors");
  83. $warnpicto = img_warning($langs->trans("WarningMandatorySetupNotComplete"));
  84. 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>';
  85. llxFooter();
  86. exit;
  87. }
  88. print '<div class="fichecenter"><div class="fichethirdleft">';
  89. if (getDolGlobalString('MAIN_SEARCH_FORM_ON_HOME_AREAS')) { // This is useless due to the global search combo
  90. if (isModEnabled('holiday') && $user->hasRight('holiday', 'read')) {
  91. $langs->load("holiday");
  92. $listofsearchfields['search_holiday'] = array('text'=>'TitreRequestCP');
  93. }
  94. if (isModEnabled('deplacement') && $user->hasRight('deplacement', 'lire')) {
  95. $langs->load("trips");
  96. $listofsearchfields['search_deplacement'] = array('text'=>'ExpenseReport');
  97. }
  98. if (isModEnabled('expensereport') && $user->hasRight('expensereport', 'lire')) {
  99. $langs->load("trips");
  100. $listofsearchfields['search_expensereport'] = array('text'=>'ExpenseReport');
  101. }
  102. if (count($listofsearchfields)) {
  103. print '<form method="post" action="'.DOL_URL_ROOT.'/core/search.php">';
  104. print '<input type="hidden" name="token" value="'.newToken().'">';
  105. print '<div class="div-table-responsive-no-min">';
  106. print '<table class="noborder nohover centpercent">';
  107. $i = 0;
  108. foreach ($listofsearchfields as $key => $value) {
  109. if ($i == 0) {
  110. print '<tr class="liste_titre"><td colspan="3">'.$langs->trans("Search").'</td></tr>';
  111. }
  112. print '<tr>';
  113. 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>';
  114. if ($i == 0) {
  115. print '<td rowspan="'.count($listofsearchfields).'"><input type="submit" value="'.$langs->trans("Search").'" class="button"></td>';
  116. }
  117. print '</tr>';
  118. $i++;
  119. }
  120. print '</table>';
  121. print '</div>';
  122. print '</form>';
  123. print '<br>';
  124. }
  125. }
  126. if (isModEnabled('holiday')) {
  127. if (!getDolGlobalString('HOLIDAY_HIDE_BALANCE')) {
  128. $holidaystatic = new Holiday($db);
  129. $user_id = $user->id;
  130. print '<div class="div-table-responsive-no-min">';
  131. print '<table class="noborder nohover centpercent">';
  132. print '<tr class="liste_titre"><th colspan="3">'.$langs->trans("Holidays").'</th></tr>';
  133. print '<tr class="oddeven">';
  134. print '<td>';
  135. $out = '';
  136. $nb_holiday = 0;
  137. $typeleaves = $holidaystatic->getTypes(1, 1);
  138. foreach ($typeleaves as $key => $val) {
  139. $nb_type = $holidaystatic->getCPforUser($user->id, $val['rowid']);
  140. $nb_holiday += $nb_type;
  141. $out .= ' - '.($langs->trans($val['code']) != $val['code'] ? $langs->trans($val['code']) : $val['label']).': <strong>'.($nb_type ? price2num($nb_type) : 0).'</strong><br>';
  142. }
  143. $balancetoshow = $langs->trans('SoldeCPUser', '{s1}');
  144. 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>';
  145. print '<span class="opacitymedium">'.$out.'</span>';
  146. print '</td>';
  147. print '</tr>';
  148. print '</table></div><br>';
  149. } elseif (!is_numeric($conf->global->HOLIDAY_HIDE_BALANCE)) {
  150. print $langs->trans($conf->global->HOLIDAY_HIDE_BALANCE).'<br>';
  151. }
  152. }
  153. print '</div><div class="fichetwothirdright">';
  154. // Latest modified leave requests
  155. if (isModEnabled('holiday') && $user->hasRight('holiday', 'read')) {
  156. $sql = "SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.photo, u.statut as user_status,";
  157. $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";
  158. $sql .= " FROM ".MAIN_DB_PREFIX."holiday as x, ".MAIN_DB_PREFIX."user as u";
  159. $sql .= " WHERE u.rowid = x.fk_user";
  160. $sql .= " AND x.entity = ".$conf->entity;
  161. if (!$user->hasRight('holiday', 'readall')) {
  162. $sql .= ' AND x.fk_user IN ('.$db->sanitize(join(',', $childids)).')';
  163. }
  164. //if (empty($user->rights->societe->client->voir) && !$user->socid) $sql.= " AND x.fk_soc = s. rowid AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
  165. //if (!empty($socid)) $sql.= " AND x.fk_soc = ".((int) $socid);
  166. $sql .= $db->order("x.tms", "DESC");
  167. $sql .= $db->plimit($max, 0);
  168. $result = $db->query($sql);
  169. if ($result) {
  170. $var = false;
  171. $num = $db->num_rows($result);
  172. $holidaystatic = new Holiday($db);
  173. $userstatic = new User($db);
  174. $listhalfday = array('morning'=>$langs->trans("Morning"), "afternoon"=>$langs->trans("Afternoon"));
  175. $typeleaves = $holidaystatic->getTypes(1, -1);
  176. $i = 0;
  177. print '<div class="div-table-responsive-no-min">';
  178. print '<table class="noborder centpercent">';
  179. print '<tr class="liste_titre">';
  180. print '<th colspan="3">'.$langs->trans("BoxTitleLastLeaveRequests", min($max, $num)).'</th>';
  181. print '<th>'.$langs->trans("from").'</th>';
  182. print '<th>'.$langs->trans("to").'</th>';
  183. print '<th class="right" colspan="2"><a href="'.DOL_URL_ROOT.'/holiday/list.php?sortfield=cp.tms&sortorder=DESC">'.$langs->trans("FullList").'</th>';
  184. print '</tr>';
  185. if ($num) {
  186. while ($i < $num && $i < $max) {
  187. $obj = $db->fetch_object($result);
  188. $holidaystatic->id = $obj->rowid;
  189. $holidaystatic->ref = $obj->ref;
  190. $holidaystatic->statut = $obj->status;
  191. $holidaystatic->date_debut = $db->jdate($obj->date_start);
  192. $userstatic->id = $obj->uid;
  193. $userstatic->lastname = $obj->lastname;
  194. $userstatic->firstname = $obj->firstname;
  195. $userstatic->login = $obj->login;
  196. $userstatic->photo = $obj->photo;
  197. $userstatic->email = $obj->email;
  198. $userstatic->statut = $obj->user_status;
  199. $userstatic->status = $obj->user_status;
  200. print '<tr class="oddeven">';
  201. print '<td class="nowraponall">'.$holidaystatic->getNomUrl(1).'</td>';
  202. print '<td class="tdoverflowmax100">'.$userstatic->getNomUrl(-1, 'leave').'</td>';
  203. $leavecode = empty($typeleaves[$obj->fk_type]) ? 'Undefined' : $typeleaves[$obj->fk_type]['code'];
  204. print '<td class="tdoverflowmax100" title="'.dol_escape_htmltag($langs->trans($leavecode)).'">'.dol_escape_htmltag($langs->trans($leavecode)).'</td>';
  205. $starthalfday = ($obj->halfday == -1 || $obj->halfday == 2) ? 'afternoon' : 'morning';
  206. $endhalfday = ($obj->halfday == 1 || $obj->halfday == 2) ? 'morning' : 'afternoon';
  207. print '<td class="tdoverflowmax125">'.dol_print_date($db->jdate($obj->date_start), 'day').' <span class="opacitymedium">'.$langs->trans($listhalfday[$starthalfday]).'</span>';
  208. print '<td class="tdoverflowmax125">'.dol_print_date($db->jdate($obj->date_end), 'day').' <span class="opacitymedium">'.$langs->trans($listhalfday[$endhalfday]).'</span>';
  209. print '<td class="right">'.dol_print_date($db->jdate($obj->dm), 'day').'</td>';
  210. print '<td class="right nowrap" width="16">'.$holidaystatic->LibStatut($obj->status, 3, $holidaystatic->date_debut).'</td>';
  211. print '</tr>';
  212. $i++;
  213. }
  214. } else {
  215. print '<tr class="oddeven"><td colspan="7"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
  216. }
  217. print '</table>';
  218. print '</div>';
  219. print '<br>';
  220. } else {
  221. dol_print_error($db);
  222. }
  223. }
  224. // Latest modified expense report
  225. if (isModEnabled('expensereport') && $user->hasRight('expensereport', 'read')) {
  226. $sql = "SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.statut as user_status, u.photo,";
  227. $sql .= " x.rowid, x.ref, x.date_debut as date, x.tms as dm, x.total_ttc, x.fk_statut as status";
  228. $sql .= " FROM ".MAIN_DB_PREFIX."expensereport as x, ".MAIN_DB_PREFIX."user as u";
  229. //if (empty($user->rights->societe->client->voir) && !$user->socid) $sql.= ", ".MAIN_DB_PREFIX."societe as s, ".MAIN_DB_PREFIX."societe_commerciaux as sc";
  230. $sql .= " WHERE u.rowid = x.fk_user_author";
  231. $sql .= " AND x.entity = ".$conf->entity;
  232. if (!$user->hasRight('expensereport', 'readall') && !$user->hasRight('expensereport', 'lire_tous')) {
  233. $sql .= ' AND x.fk_user_author IN ('.$db->sanitize(join(',', $childids)).')';
  234. }
  235. //if (empty($user->rights->societe->client->voir) && !$user->socid) $sql.= " AND x.fk_soc = s. rowid AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
  236. //if (!empty($socid)) $sql.= " AND x.fk_soc = ".((int) $socid);
  237. $sql .= $db->order("x.tms", "DESC");
  238. $sql .= $db->plimit($max, 0);
  239. $result = $db->query($sql);
  240. if ($result) {
  241. $num = $db->num_rows($result);
  242. $i = 0;
  243. print '<div class="div-table-responsive-no-min">';
  244. print '<table class="noborder centpercent">';
  245. print '<tr class="liste_titre">';
  246. print '<th colspan="2">'.$langs->trans("BoxTitleLastModifiedExpenses", min($max, $num)).'</th>';
  247. print '<th class="right">'.$langs->trans("TotalTTC").'</th>';
  248. print '<th class="right" colspan="2"><a href="'.DOL_URL_ROOT.'/expensereport/list.php?sortfield=d.tms&sortorder=DESC">'.$langs->trans("FullList").'</th>';
  249. print '</tr>';
  250. if ($num) {
  251. $total_ttc = $totalam = $total = 0;
  252. $expensereportstatic = new ExpenseReport($db);
  253. $userstatic = new User($db);
  254. while ($i < $num && $i < $max) {
  255. $obj = $db->fetch_object($result);
  256. $expensereportstatic->id = $obj->rowid;
  257. $expensereportstatic->ref = $obj->ref;
  258. $expensereportstatic->statut = $obj->status;
  259. $expensereportstatic->status = $obj->status;
  260. $userstatic->id = $obj->uid;
  261. $userstatic->lastname = $obj->lastname;
  262. $userstatic->firstname = $obj->firstname;
  263. $userstatic->email = $obj->email;
  264. $userstatic->login = $obj->login;
  265. $userstatic->statut = $obj->user_status;
  266. $userstatic->photo = $obj->photo;
  267. print '<tr class="oddeven">';
  268. print '<td class="tdoverflowmax200">'.$expensereportstatic->getNomUrl(1).'</td>';
  269. print '<td class="tdoverflowmax150">'.$userstatic->getNomUrl(-1).'</td>';
  270. print '<td class="right amount">'.price($obj->total_ttc).'</td>';
  271. print '<td class="right">'.dol_print_date($db->jdate($obj->dm), 'day').'</td>';
  272. print '<td class="right nowraponall" width="16">'.$expensereportstatic->LibStatut($obj->status, 3).'</td>';
  273. print '</tr>';
  274. $i++;
  275. }
  276. } else {
  277. print '<tr class="oddeven"><td colspan="5"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
  278. }
  279. print '</table>';
  280. print '</div>';
  281. print '<br>';
  282. } else {
  283. dol_print_error($db);
  284. }
  285. }
  286. // Last modified job position
  287. if (isModEnabled('recruitment') && $user->hasRight('recruitment', 'recruitmentjobposition', 'read')) {
  288. $staticrecruitmentcandidature = new RecruitmentCandidature($db);
  289. $staticrecruitmentjobposition = new RecruitmentJobPosition($db);
  290. $sql = "SELECT rc.rowid, rc.ref, rc.email, rc.lastname, rc.firstname, rc.date_creation, rc.tms, rc.status,";
  291. $sql.= " rp.rowid as jobid, rp.ref as jobref, rp.label";
  292. $sql .= " FROM ".MAIN_DB_PREFIX."recruitment_recruitmentcandidature as rc";
  293. $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."recruitment_recruitmentjobposition as rp ON rc.fk_recruitmentjobposition = rp.rowid";
  294. if (isModEnabled('societe') && !$user->hasRight('societe', 'client', 'voir') && !$socid) {
  295. $sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
  296. }
  297. $sql .= " WHERE rc.entity IN (".getEntity($staticrecruitmentcandidature->element).")";
  298. if (isModEnabled('societe') && !$user->hasRight('societe', 'client', 'voir') && !$socid) {
  299. $sql .= " AND rp.fk_soc = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
  300. }
  301. if ($socid) {
  302. $sql .= " AND rp.fk_soc = $socid";
  303. }
  304. $sql .= $db->order("rc.tms", "DESC");
  305. $sql .= $db->plimit($max, 0);
  306. $resql = $db->query($sql);
  307. if ($resql) {
  308. $num = $db->num_rows($resql);
  309. $i = 0;
  310. print '<div class="div-table-responsive-no-min">';
  311. print '<table class="noborder centpercent">';
  312. print '<tr class="liste_titre">';
  313. print '<th colspan="3">';
  314. print $langs->trans("BoxTitleLatestModifiedCandidatures", min($max, $num));
  315. print '</th>';
  316. print '<th class="right" colspan="2"><a href="'.DOL_URL_ROOT.'/recruitment/recruitmentcandidature_list.php?sortfield=t.tms&sortorder=DESC">'.$langs->trans("FullList").'</th>';
  317. print '</tr>';
  318. if ($num) {
  319. while ($i < $num) {
  320. $objp = $db->fetch_object($resql);
  321. $staticrecruitmentcandidature->id = $objp->rowid;
  322. $staticrecruitmentcandidature->ref = $objp->ref;
  323. $staticrecruitmentcandidature->email = $objp->email;
  324. $staticrecruitmentcandidature->status = $objp->status;
  325. $staticrecruitmentcandidature->date_creation = $objp->date_creation;
  326. $staticrecruitmentcandidature->firstname = $objp->firstname;
  327. $staticrecruitmentcandidature->lastname = $objp->lastname;
  328. $staticrecruitmentjobposition->id = $objp->jobid;
  329. $staticrecruitmentjobposition->ref = $objp->jobref;
  330. $staticrecruitmentjobposition->label = $objp->label;
  331. print '<tr class="oddeven">';
  332. print '<td class="nowraponall">'.$staticrecruitmentcandidature->getNomUrl(1, '').'</td>';
  333. print '<td class="tdoverflowmax150">'.$staticrecruitmentcandidature->getFullName($langs).'</td>';
  334. print '<td class="nowraponall">'.$staticrecruitmentjobposition->getNomUrl(1).'</td>';
  335. print '<td class="right nowrap">'.dol_print_date($db->jdate($objp->tms), 'day').'</td>';
  336. print '<td class="right nowrap" width="16">';
  337. print $staticrecruitmentcandidature->getLibStatut(3);
  338. print "</td>";
  339. print '</tr>';
  340. $i++;
  341. }
  342. $db->free($resql);
  343. } else {
  344. print '<tr class="oddeven"><td colspan="4"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
  345. }
  346. print "</table>";
  347. print "</div>";
  348. print "<br>";
  349. } else {
  350. dol_print_error($db);
  351. }
  352. }
  353. print '</div></div>';
  354. // Initialize technical object to manage hooks. Note that conf->hooks_modules contains array
  355. $parameters = array('user' => $user);
  356. $reshook = $hookmanager->executeHooks('dashboardHRM', $parameters, $object); // Note that $action and $object may have been modified by hook
  357. // End of page
  358. llxFooter();
  359. $db->close();