12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253 |
- <?php
- /* Copyright (C) 2011 Dimitri Mouillard <dmouillard@teclib.com>
- * Copyright (C) 2012-2016 Laurent Destailleur <eldy@users.sourceforge.net>
- * Copyright (C) 2012-2016 Regis Houssin <regis.houssin@capnetworks.com>
- * Copyright (C) 2013 Juanjo Menent <jmenent@2byte.es>
- * Copyright (C) 2014 Ferran Marcet <fmarcet@2byte.es>
- * Copyright (C) 2017 Alexandre Spangaro <aspangaro@zendsi.com>
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published by
- * the Free Software Foundation; either version 3 of the License, orwrite
- * (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- * GNU General Public License for more details.
- *
- * You should have received a copy of the GNU General Public License
- * along with this program. If not, see <http://www.gnu.org/licenses/>.
- */
- /**
- * \file htdocs/holiday/card.php
- * \ingroup holiday
- * \brief Form and file creation of paid holiday.
- */
- require('../main.inc.php');
- require_once DOL_DOCUMENT_ROOT.'/core/class/html.form.class.php';
- require_once DOL_DOCUMENT_ROOT.'/user/class/usergroup.class.php';
- require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
- require_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';
- require_once DOL_DOCUMENT_ROOT.'/core/class/html.formmail.class.php';
- require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
- require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
- require_once DOL_DOCUMENT_ROOT.'/core/lib/holiday.lib.php';
- require_once DOL_DOCUMENT_ROOT.'/holiday/common.inc.php';
- // Get parameters
- $myparam = GETPOST("myparam");
- $action=GETPOST('action', 'alpha');
- $id=GETPOST('id', 'int');
- $userid = GETPOST('userid')?GETPOST('userid'):$user->id;
- // Protection if external user
- if ($user->societe_id > 0) accessforbidden();
- $now=dol_now();
- $langs->load("holiday");
- /*
- * Actions
- */
- // If create a request
- if ($action == 'create')
- {
- $object = new Holiday($db);
- // If no right to create a request
- if (($userid == $user->id && empty($user->rights->holiday->write)) || ($userid != $user->id && empty($user->rights->holiday->write_all)))
- {
- $error++;
- setEventMessages($langs->trans('CantCreateCP'), null, 'errors');
- $action='request';
- }
- if (! $error)
- {
- $db->begin();
- $date_debut = dol_mktime(0, 0, 0, GETPOST('date_debut_month'), GETPOST('date_debut_day'), GETPOST('date_debut_year'));
- $date_fin = dol_mktime(0, 0, 0, GETPOST('date_fin_month'), GETPOST('date_fin_day'), GETPOST('date_fin_year'));
- $date_debut_gmt = dol_mktime(0, 0, 0, GETPOST('date_debut_month'), GETPOST('date_debut_day'), GETPOST('date_debut_year'), 1);
- $date_fin_gmt = dol_mktime(0, 0, 0, GETPOST('date_fin_month'), GETPOST('date_fin_day'), GETPOST('date_fin_year'), 1);
- $starthalfday=GETPOST('starthalfday');
- $endhalfday=GETPOST('endhalfday');
- $type=GETPOST('type');
- $halfday=0;
- if ($starthalfday == 'afternoon' && $endhalfday == 'morning') $halfday=2;
- else if ($starthalfday == 'afternoon') $halfday=-1;
- else if ($endhalfday == 'morning') $halfday=1;
- $valideur = GETPOST('valideur');
- $description = trim(GETPOST('description'));
- $userID = GETPOST('userID');
- // If no type
- if ($type <= 0)
- {
- setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Type")), null, 'errors');
- $error++;
- $action='create';
- }
- // If no start date
- if (empty($date_debut))
- {
- setEventMessages($langs->trans("NoDateDebut"), null, 'errors');
- $error++;
- $action='create';
- }
- // If no end date
- if (empty($date_fin))
- {
- setEventMessages($langs->trans("NoDateFin"), null, 'errors');
- $error++;
- $action='create';
- }
- // If start date after end date
- if ($date_debut > $date_fin)
- {
- setEventMessages($langs->trans("ErrorEndDateCP"), null, 'errors');
- $error++;
- $action='create';
- }
- // Check if there is already holiday for this period
- $verifCP = $object->verifDateHolidayCP($userID, $date_debut, $date_fin, $halfday);
- if (! $verifCP)
- {
- setEventMessages($langs->trans("alreadyCPexist"), null, 'errors');
- $error++;
- $action='create';
- }
- // If there is no Business Days within request
- $nbopenedday=num_open_day($date_debut_gmt, $date_fin_gmt, 0, 1, $halfday);
- if($nbopenedday < 0.5)
- {
- setEventMessages($langs->trans("ErrorDureeCP"), null, 'errors');
- $error++;
- $action='create';
- }
- // If no validator designated
- if ($valideur < 1)
- {
- setEventMessages($langs->transnoentitiesnoconv('InvalidValidatorCP'), null, 'errors');
- $error++;
- }
- $result = 0;
- $result = 0;
- if (! $error)
- {
- $object->fk_user = $userid;
- $object->description = $description;
- $object->date_debut = $date_debut;
- $object->date_fin = $date_fin;
- $object->fk_validator = $valideur;
- $object->halfday = $halfday;
- $object->fk_type = $type;
- $result = $object->create($user);
- }
- // If no SQL error we redirect to the request card
- if (! $error && $result > 0)
- {
- $db->commit();
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- else
- {
- $db->rollback();
- }
- }
- }
- if ($action == 'update')
- {
- $date_debut = dol_mktime(0, 0, 0, GETPOST('date_debut_month'), GETPOST('date_debut_day'), GETPOST('date_debut_year'));
- $date_fin = dol_mktime(0, 0, 0, GETPOST('date_fin_month'), GETPOST('date_fin_day'), GETPOST('date_fin_year'));
- $date_debut_gmt = dol_mktime(0, 0, 0, GETPOST('date_debut_month'), GETPOST('date_debut_day'), GETPOST('date_debut_year'), 1);
- $date_fin_gmt = dol_mktime(0, 0, 0, GETPOST('date_fin_month'), GETPOST('date_fin_day'), GETPOST('date_fin_year'), 1);
- $starthalfday=GETPOST('starthalfday');
- $endhalfday=GETPOST('endhalfday');
- $halfday=0;
- if ($starthalfday == 'afternoon' && $endhalfday == 'morning') $halfday=2;
- else if ($starthalfday == 'afternoon') $halfday=-1;
- else if ($endhalfday == 'morning') $halfday=1;
- // If no right to modify a request
- if (! $user->rights->holiday->write)
- {
- header('Location: '.$_SERVER["PHP_SELF"].'?action=request&error=CantUpdate');
- exit;
- }
- $object = new Holiday($db);
- $object->fetch($id);
- $canedit=(($user->id == $object->fk_user && $user->rights->holiday->write) || ($user->id != $object->fk_user && $user->rights->holiday->write_all));
- // If under validation
- if ($object->statut == 1)
- {
- // If this is the requestor or has read/write rights
- if ($canedit)
- {
- $valideur = $_POST['valideur'];
- $description = trim($_POST['description']);
- // If no start date
- if (empty($_POST['date_debut_'])) {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=edit&error=nodatedebut');
- exit;
- }
- // If no end date
- if (empty($_POST['date_fin_'])) {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=edit&error=nodatefin');
- exit;
- }
- // If start date after end date
- if ($date_debut > $date_fin) {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=edit&error=datefin');
- exit;
- }
- // If no validator designated
- if ($valideur < 1) {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=edit&error=Valideur');
- exit;
- }
- // If there is no Business Days within request
- $nbopenedday=num_open_day($date_debut_gmt, $date_fin_gmt, 0, 1, $halfday);
- if ($nbopenedday < 0.5)
- {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=edit&error=DureeHoliday');
- exit;
- }
- $object->description = $description;
- $object->date_debut = $date_debut;
- $object->date_fin = $date_fin;
- $object->fk_validator = $valideur;
- $object->halfday = $halfday;
- // Update
- $verif = $object->update($user);
- if ($verif > 0)
- {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- else
- {
- // Otherwise we display the request form with the SQL error message
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=edit&error=SQL_Create&msg='.$object->error);
- exit;
- }
- }
- } else {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- }
- // If delete of request
- if ($action == 'confirm_delete' && GETPOST('confirm') == 'yes' && $user->rights->holiday->delete)
- {
- $error=0;
- $db->begin();
- $object = new Holiday($db);
- $object->fetch($id);
- $canedit=(($user->id == $object->fk_user && $user->rights->holiday->write) || ($user->id != $object->fk_user && $user->rights->holiday->write_all));
- // If this is a rough draft
- if ($object->statut == 1 || $object->statut == 3)
- {
- // Si l'utilisateur à le droit de lire cette demande, il peut la supprimer
- if ($canedit)
- {
- $result=$object->delete($user);
- }
- else
- {
- $error = $langs->trans('ErrorCantDeleteCP');
- }
- }
- if (! $error)
- {
- $db->commit();
- header('Location: list.php');
- exit;
- }
- else
- {
- $db->rollback();
- }
- }
- // Si envoi de la demande
- if ($action == 'confirm_send')
- {
- $object = new Holiday($db);
- $object->fetch($id);
- $canedit=(($user->id == $object->fk_user && $user->rights->holiday->write) || ($user->id != $object->fk_user && $user->rights->holiday->write_all));
- // Si brouillon et créateur
- if($object->statut == 1 && $canedit)
- {
- $object->statut = 2;
- $verif = $object->update($user);
- // Si pas d'erreur SQL on redirige vers la fiche de la demande
- if ($verif > 0)
- {
- // To
- $destinataire = new User($db);
- $destinataire->fetch($object->fk_validator);
- $emailTo = $destinataire->email;
- if (!$emailTo)
- {
- dol_syslog("Expected validator has no email, so we redirect directly to finished page without sending email");
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- // From
- $expediteur = new User($db);
- $expediteur->fetch($object->fk_user);
- $emailFrom = $expediteur->email;
- // Subject
- $societeName = $conf->global->MAIN_INFO_SOCIETE_NOM;
- if (! empty($conf->global->MAIN_APPLICATION_TITLE)) $societeName = $conf->global->MAIN_APPLICATION_TITLE;
- $subject = $societeName." - ".$langs->transnoentitiesnoconv("HolidaysToValidate");
- // Content
- $message = $langs->transnoentitiesnoconv("Hello")." ".$destinataire->firstname.",\n";
- $message.= "\n";
- $message.= $langs->transnoentities("HolidaysToValidateBody")."\n";
- $delayForRequest = $object->getConfCP('delayForRequest');
- //$delayForRequest = $delayForRequest * (60*60*24);
- $nextMonth = dol_time_plus_duree($now, $delayForRequest, 'd');
- // Si l'option pour avertir le valideur en cas de délai trop court
- if($object->getConfCP('AlertValidatorDelay'))
- {
- if($object->date_debut < $nextMonth)
- {
- $message.= "\n";
- $message.= $langs->transnoentities("HolidaysToValidateDelay",$object->getConfCP('delayForRequest'))."\n";
- }
- }
- // Si l'option pour avertir le valideur en cas de solde inférieur à la demande
- if ($object->getConfCP('AlertValidatorSolde'))
- {
- $nbopenedday=num_open_day($object->date_debut_gmt,$object->date_fin_gmt,0,1,$object->halfday);
- if ($nbopenedday > $object->getCPforUser($object->fk_user, $object->fk_type))
- {
- $message.= "\n";
- $message.= $langs->transnoentities("HolidaysToValidateAlertSolde")."\n";
- }
- }
- $message.= "\n";
- $message.= "- ".$langs->transnoentitiesnoconv("Name")." : ".dolGetFirstLastname($expediteur->firstname, $expediteur->lastname)."\n";
- $message.= "- ".$langs->transnoentitiesnoconv("Period")." : ".dol_print_date($object->date_debut,'day')." ".$langs->transnoentitiesnoconv("To")." ".dol_print_date($object->date_fin,'day')."\n";
- $message.= "- ".$langs->transnoentitiesnoconv("Link")." : ".$dolibarr_main_url_root."/holiday/card.php?id=".$object->id."\n\n";
- $message.= "\n";
- $mail = new CMailFile($subject,$emailTo,$emailFrom,$message);
- // Envoi du mail
- $result=$mail->sendfile();
- if (!$result)
- {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=mail&error_content='.$mail->error);
- exit;
- }
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- else
- {
- // Sinon on affiche le formulaire de demande avec le message d'erreur SQL
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=SQL_Create&msg='.$object->error);
- exit;
- }
- }
- }
- // Si Validation de la demande
- if ($action == 'confirm_valid')
- {
- $object = new Holiday($db);
- $object->fetch($id);
- // Si statut en attente de validation et valideur = utilisateur
- if ($object->statut == 2 && $user->id == $object->fk_validator)
- {
- $object->date_valid = dol_now();
- $object->fk_user_valid = $user->id;
- $object->statut = 3;
- $verif = $object->update($user);
- // Si pas d'erreur SQL on redirige vers la fiche de la demande
- if ($verif > 0)
- {
- // Calculcate number of days consummed
- $nbopenedday=num_open_day($object->date_debut_gmt,$object->date_fin_gmt,0,1,$object->halfday);
- $soldeActuel = $object->getCpforUser($object->fk_user, $object->fk_type);
- $newSolde = $soldeActuel - ($nbopenedday * $object->getConfCP('nbHolidayDeducted'));
- // On ajoute la modification dans le LOG
- $object->addLogCP($user->id, $object->fk_user, $langs->transnoentitiesnoconv("Holidays"), $newSolde, $object->fk_type);
- // Mise à jour du solde
- $object->updateSoldeCP($object->fk_user, $newSolde, $object->fk_type);
- // To
- $destinataire = new User($db);
- $destinataire->fetch($object->fk_user);
- $emailTo = $destinataire->email;
- if (!$emailTo)
- {
- dol_syslog("User that request leave has no email, so we redirect directly to finished page without sending email");
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- // From
- $expediteur = new User($db);
- $expediteur->fetch($object->fk_validator);
- $emailFrom = $expediteur->email;
- // Subject
- $societeName = $conf->global->MAIN_INFO_SOCIETE_NOM;
- if (! empty($conf->global->MAIN_APPLICATION_TITLE)) $societeName = $conf->global->MAIN_APPLICATION_TITLE;
- $subject = $societeName." - ".$langs->transnoentitiesnoconv("HolidaysValidated");
- // Content
- $message = $langs->transnoentitiesnoconv("Hello")." ".$destinataire->firstname.",\n";
- $message.= "\n";
- $message.= $langs->transnoentities("HolidaysValidatedBody", dol_print_date($object->date_debut,'day'),dol_print_date($object->date_fin,'day'))."\n";
- $message.= "- ".$langs->transnoentitiesnoconv("ValidatedBy")." : ".dolGetFirstLastname($expediteur->firstname, $expediteur->lastname)."\n";
- $message.= "- ".$langs->transnoentitiesnoconv("Link")." : ".$dolibarr_main_url_root."/holiday/card.php?id=".$object->id."\n\n";
- $message.= "\n";
- $mail = new CMailFile($subject,$emailTo,$emailFrom,$message);
- // Envoi du mail
- $result=$mail->sendfile();
- if(!$result) {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=mail&error_content='.$mail->error);
- exit;
- }
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- } else {
- // Sinon on affiche le formulaire de demande avec le message d'erreur SQL
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=SQL_Create&msg='.$object->error);
- exit;
- }
- }
- }
- if ($action == 'confirm_refuse')
- {
- if (! empty($_POST['detail_refuse']))
- {
- $object = new Holiday($db);
- $object->fetch($id);
- // Si statut en attente de validation et valideur = utilisateur
- if ($object->statut == 2 && $user->id == $object->fk_validator)
- {
- $object->date_refuse = date('Y-m-d H:i:s', time());
- $object->fk_user_refuse = $user->id;
- $object->statut = 5;
- $object->detail_refuse = $_POST['detail_refuse'];
- $verif = $object->update($user);
- // Si pas d'erreur SQL on redirige vers la fiche de la demande
- if ($verif > 0)
- {
- // To
- $destinataire = new User($db);
- $destinataire->fetch($object->fk_user);
- $emailTo = $destinataire->email;
- if (!$emailTo)
- {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- // From
- $expediteur = new User($db);
- $expediteur->fetch($object->fk_validator);
- $emailFrom = $expediteur->email;
- // Subject
- $societeName = $conf->global->MAIN_INFO_SOCIETE_NOM;
- if (! empty($conf->global->MAIN_APPLICATION_TITLE)) $societeName = $conf->global->MAIN_APPLICATION_TITLE;
- $subject = $societeName." - ".$langs->transnoentitiesnoconv("HolidaysRefused");
- // Content
- $message = $langs->transnoentitiesnoconv("Hello")." ".$destinataire->firstname.",\n";
- $message.= "\n";
- $message.= $langs->transnoentities("HolidaysRefusedBody", dol_print_date($object->date_debut,'day'), dol_print_date($object->date_fin,'day'))."\n";
- $message.= GETPOST('detail_refuse','alpha')."\n\n";
- $message.= "- ".$langs->transnoentitiesnoconv("ModifiedBy")." : ".dolGetFirstLastname($expediteur->firstname, $expediteur->lastname)."\n";
- $message.= "- ".$langs->transnoentitiesnoconv("Link")." : ".$dolibarr_main_url_root."/holiday/card.php?id=".$object->id."\n\n";
- $message.= "\n";
- $mail = new CMailFile($subject,$emailTo,$emailFrom,$message);
- // Envoi du mail
- $result=$mail->sendfile();
- if(!$result) {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=mail&error_content='.$mail->error);
- exit;
- }
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- } else {
- // Sinon on affiche le formulaire de demande avec le message d'erreur SQL
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=SQL_Create&msg='.$object->error);
- exit;
- }
- }
- } else {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=NoMotifRefuse');
- exit;
- }
- }
- // Si Validation de la demande
- if ($action == 'confirm_cancel' && GETPOST('confirm') == 'yes')
- {
- $object = new Holiday($db);
- $object->fetch($id);
- // Si statut en attente de validation et valideur = utilisateur
- if (($object->statut == 2 || $object->statut == 3) && ($user->id == $object->fk_validator || $user->id == $object->fk_user))
- {
- $db->begin();
- $oldstatus = $object->statut;
- $object->date_cancel = dol_now();
- $object->fk_user_cancel = $user->id;
- $object->statut = 4;
- $result = $object->update($user);
- if ($result >= 0 && $oldstatus == 3) // holiday was already validated, status 3, so we must increase back sold
- {
- // Calculcate number of days consummed
- $nbopenedday=num_open_day($object->date_debut_gmt,$object->date_fin_gmt,0,1,$object->halfday);
- $soldeActuel = $object->getCpforUser($object->fk_user, $object->fk_type);
- $newSolde = $soldeActuel + ($nbopenedday * $object->getConfCP('nbHolidayDeducted'));
- // On ajoute la modification dans le LOG
- $result1=$object->addLogCP($user->id, $object->fk_user, $langs->transnoentitiesnoconv("HolidaysCancelation"), $newSolde, $object->fk_type);
- // Mise à jour du solde
- $result2=$object->updateSoldeCP($object->fk_user, $newSolde, $object->fk_type);
- if ($result1 < 0 || $result2 < 0)
- {
- $error = $langs->trans('ErrorCantDeleteCP');
- }
- }
- if (! $error)
- {
- $db->commit();
- }
- else
- {
- $db->rollback();
- }
- // Si pas d'erreur SQL on redirige vers la fiche de la demande
- if (! $error && $result > 0)
- {
- // To
- $destinataire = new User($db);
- $destinataire->fetch($object->fk_user);
- $emailTo = $destinataire->email;
- if (!$emailTo)
- {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- // From
- $expediteur = new User($db);
- $expediteur->fetch($object->fk_user_cancel);
- $emailFrom = $expediteur->email;
- // Subject
- $societeName = $conf->global->MAIN_INFO_SOCIETE_NOM;
- if (! empty($conf->global->MAIN_APPLICATION_TITLE)) $societeName = $conf->global->MAIN_APPLICATION_TITLE;
- $subject = $societeName." - ".$langs->transnoentitiesnoconv("HolidaysCanceled");
- // Content
- $message = $langs->transnoentitiesnoconv("Hello")." ".$destinataire->firstname.",\n";
- $message.= "\n";
- $message.= $langs->transnoentities("HolidaysCanceledBody", dol_print_date($object->date_debut,'day'), dol_print_date($object->date_fin,'day'))."\n";
- $message.= "- ".$langs->transnoentitiesnoconv("ModifiedBy")." : ".dolGetFirstLastname($expediteur->firstname, $expediteur->lastname)."\n";
- $message.= "- ".$langs->transnoentitiesnoconv("Link")." : ".$dolibarr_main_url_root."/holiday/card.php?id=".$object->id."\n\n";
- $message.= "\n";
- $mail = new CMailFile($subject,$emailTo,$emailFrom,$message);
- // Envoi du mail
- $result=$mail->sendfile();
- if(!$result)
- {
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=mail&error_content='.$mail->error);
- exit;
- }
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id);
- exit;
- }
- else
- {
- // Sinon on affiche le formulaire de demande avec le message d'erreur SQL
- header('Location: '.$_SERVER["PHP_SELF"].'?id='.$object->id.'&error=SQL_Create&msg='.$object->error);
- exit;
- }
- }
- }
- /*
- * View
- */
- $form = new Form($db);
- $object = new Holiday($db);
- $listhalfday=array('morning'=>$langs->trans("Morning"),"afternoon"=>$langs->trans("Afternoon"));
- llxHeader('', $langs->trans('CPTitreMenu'));
- if (empty($id) || $action == 'add' || $action == 'request' || $action == 'create')
- {
- // Si l'utilisateur n'a pas le droit de faire une demande
- if (($userid == $user->id && empty($user->rights->holiday->write)) || ($userid != $user->id && empty($user->rights->holiday->write_all)))
- {
- $errors[]=$langs->trans('CantCreateCP');
- }
- else
- {
- // Formulaire de demande de congés payés
- print load_fiche_titre($langs->trans('MenuAddCP'), '', 'title_hrm.png');
- // Si il y a une erreur
- if (GETPOST('error')) {
- switch(GETPOST('error')) {
- case 'datefin' :
- $errors[] = $langs->trans('ErrorEndDateCP');
- break;
- case 'SQL_Create' :
- $errors[] = $langs->trans('ErrorSQLCreateCP').' <b>'.htmlentities($_GET['msg']).'</b>';
- break;
- case 'CantCreate' :
- $errors[] = $langs->trans('CantCreateCP');
- break;
- case 'Valideur' :
- $errors[] = $langs->trans('InvalidValidatorCP');
- break;
- case 'nodatedebut' :
- $errors[] = $langs->trans('NoDateDebut');
- break;
- case 'nodatefin' :
- $errors[] = $langs->trans('NoDateFin');
- break;
- case 'DureeHoliday' :
- $errors[] = $langs->trans('ErrorDureeCP');
- break;
- case 'alreadyCP' :
- $errors[] = $langs->trans('alreadyCPexist');
- break;
- }
- setEventMessages($errors, null, 'errors');
- }
- $delayForRequest = $object->getConfCP('delayForRequest');
- //$delayForRequest = $delayForRequest * (60*60*24);
- $nextMonth = dol_time_plus_duree($now, $delayForRequest, 'd');
- print '<script type="text/javascript">
- function valider()
- {
- if(document.demandeCP.date_debut_.value != "")
- {
- if(document.demandeCP.date_fin_.value != "")
- {
- if(document.demandeCP.valideur.value != "-1") {
- return true;
- }
- else {
- alert("'.dol_escape_js($langs->transnoentities('InvalidValidatorCP')).'");
- return false;
- }
- }
- else
- {
- alert("'.dol_escape_js($langs->transnoentities('NoDateFin')).'");
- return false;
- }
- }
- else
- {
- alert("'.dol_escape_js($langs->transnoentities('NoDateDebut')).'");
- return false;
- }
- }
- </script>'."\n";
- // Formulaire de demande
- print '<form method="POST" action="'.$_SERVER['PHP_SELF'].'" onsubmit="return valider()" name="demandeCP">'."\n";
- print '<input type="hidden" name="action" value="create" />'."\n";
- print '<input type="hidden" name="userID" value="'.$userid.'" />'."\n";
- dol_fiche_head();
- $out='';
- $typeleaves=$object->getTypes(1,1);
- foreach($typeleaves as $key => $val)
- {
- $nb_type = $object->getCPforUser($user->id, $val['rowid']);
- $nb_holiday += $nb_type;
- $out .= ' - '.$val['label'].': <strong>'.($nb_type?price2num($nb_type):0).'</strong><br>';
- }
- print $langs->trans('SoldeCPUser', round($nb_holiday,5)).'<br>';
- print $out;
- dol_fiche_end();
- dol_fiche_head();
- //print '<span>'.$langs->trans('DelayToRequestCP',$object->getConfCP('delayForRequest')).'</span><br /><br />';
- print '<table class="border" width="100%">';
- print '<tbody>';
- // User
- print '<tr>';
- print '<td class="titlefield fieldrequired">'.$langs->trans("User").'</td>';
- print '<td>';
- if (empty($user->rights->holiday->write_all))
- {
- print $form->select_dolusers($userid, 'useridbis', 0, '', 1, '', '', 0, 0, 0, '', 0, '', 'maxwidth300');
- print '<input type="hidden" name="userid" value="'.$userid.'">';
- }
- else print $form->select_dolusers(GETPOST('userid')?GETPOST('userid'):$user->id,'userid',0,'',0);
- print '</td>';
- print '</tr>';
- // Type
- print '<tr>';
- print '<td class="fieldrequired">'.$langs->trans("Type").'</td>';
- print '<td>';
- $typeleaves=$object->getTypes(1,-1);
- $arraytypeleaves=array();
- foreach($typeleaves as $key => $val)
- {
- $labeltoshow = $val['label'];
- $labeltoshow .= ($val['delay'] > 0 ? ' ('.$langs->trans("NoticePeriod").': '.$val['delay'].' '.$langs->trans("days").')':'');
- $arraytypeleaves[$val['rowid']]=$labeltoshow;
- }
- print $form->selectarray('type', $arraytypeleaves, (GETPOST('type')?GETPOST('type'):''), 1);
- if ($user->admin) print info_admin($langs->trans("YouCanChangeValuesForThisListFromDictionarySetup"),1);
- print '</td>';
- print '</tr>';
- // Date start
- print '<tr>';
- print '<td class="fieldrequired">';
- print $langs->trans("DateDebCP");
- print ' ('.$langs->trans("FirstDayOfHoliday").')';
- print '</td>';
- print '<td>';
- // Si la demande ne vient pas de l'agenda
- if (! GETPOST('date_debut_')) {
- $form->select_date(-1, 'date_debut_', 0, 0, 0, '', 1, 1);
- } else {
- $tmpdate = dol_mktime(0, 0, 0, GETPOST('date_debut_month'), GETPOST('date_debut_day'), GETPOST('date_debut_year'));
- $form->select_date($tmpdate, 'date_debut_', 0, 0, 0, '', 1, 1);
- }
- print ' ';
- print $form->selectarray('starthalfday', $listhalfday, (GETPOST('starthalfday')?GETPOST('starthalfday'):'morning'));
- print '</td>';
- print '</tr>';
- // Date end
- print '<tr>';
- print '<td class="fieldrequired">';
- print $langs->trans("DateFinCP");
- print ' ('.$langs->trans("LastDayOfHoliday").')';
- print '</td>';
- print '<td>';
- // Si la demande ne vient pas de l'agenda
- if (! GETPOST('date_fin_')) {
- $form->select_date(-1,'date_fin_', 0, 0, 0, '', 1, 1);
- } else {
- $tmpdate = dol_mktime(0, 0, 0, GETPOST('date_fin_month'), GETPOST('date_fin_day'), GETPOST('date_fin_year'));
- $form->select_date($tmpdate,'date_fin_', 0, 0, 0, '', 1, 1);
- }
- print ' ';
- print $form->selectarray('endhalfday', $listhalfday, (GETPOST('endhalfday')?GETPOST('endhalfday'):'afternoon'));
- print '</td>';
- print '</tr>';
- // Approved by
- print '<tr>';
- print '<td class="fieldrequired">'.$langs->trans("ReviewedByCP").'</td>';
- print '<td>';
- print $form->select_dolusers((GETPOST('valideur')>0?GETPOST('valideur'):$user->fk_user), "valideur", 1, ($user->admin ? '' : array($user->id)), 0, '', 0, 0, 0, 0, '', 0, '', '', 1); // By default, hierarchical parent
- print '</td>';
- print '</tr>';
- // Description
- print '<tr>';
- print '<td>'.$langs->trans("DescCP").'</td>';
- print '<td class="tdtop">';
- $doleditor = new DolEditor('description', GETPOST('description'), '', 80, 'dolibarr_notes', 'In', 0, false, true, ROWS_3, '90%');
- print $doleditor->Create(1);
- print '</td></tr>';
- print '</tbody>';
- print '</table>';
- dol_fiche_end();
- print '<div class="center">';
- print '<input type="submit" value="'.$langs->trans("SendRequestCP").'" name="bouton" class="button">';
- print ' ';
- print '<input type="button" value="'.$langs->trans("Cancel").'" class="button" onclick="history.go(-1)">';
- print '</div>';
- print '</from>'."\n";
- }
- }
- else
- {
- if ($error)
- {
- print '<div class="tabBar">';
- print $error;
- print '<br><br><input type="button" value="'.$langs->trans("ReturnCP").'" class="button" onclick="history.go(-1)" />';
- print '</div>';
- }
- else
- {
- // Affichage de la fiche d'une demande de congés payés
- if ($id > 0)
- {
- $object->fetch($id);
- $canedit=(($user->id == $object->fk_user && $user->rights->holiday->write) || ($user->id != $object->fk_user && $user->rights->holiday->write_all));
- $valideur = new User($db);
- $valideur->fetch($object->fk_validator);
- $userRequest = new User($db);
- $userRequest->fetch($object->fk_user);
- //print load_fiche_titre($langs->trans('TitreRequestCP'));
- // Si il y a une erreur
- if (GETPOST('error'))
- {
- switch(GETPOST('error'))
- {
- case 'datefin' :
- $errors[] = $langs->transnoentitiesnoconv('ErrorEndDateCP');
- break;
- case 'SQL_Create' :
- $errors[] = $langs->transnoentitiesnoconv('ErrorSQLCreateCP').' '.$_GET['msg'];
- break;
- case 'CantCreate' :
- $errors[] = $langs->transnoentitiesnoconv('CantCreateCP');
- break;
- case 'Valideur' :
- $errors[] = $langs->transnoentitiesnoconv('InvalidValidatorCP');
- break;
- case 'nodatedebut' :
- $errors[] = $langs->transnoentitiesnoconv('NoDateDebut');
- break;
- case 'nodatefin' :
- $errors[] = $langs->transnoentitiesnoconv('NoDateFin');
- break;
- case 'DureeHoliday' :
- $errors[] = $langs->transnoentitiesnoconv('ErrorDureeCP');
- break;
- case 'NoMotifRefuse' :
- $errors[] = $langs->transnoentitiesnoconv('NoMotifRefuseCP');
- break;
- case 'mail' :
- $errors[] = $langs->transnoentitiesnoconv('ErrorMailNotSend')."\n".$_GET['error_content'];
- break;
- }
- setEventMessages($errors, null, 'errors');
- }
- // On vérifie si l'utilisateur à le droit de lire cette demande
- if ($canedit)
- {
- if ($action == 'delete')
- {
- if ($user->rights->holiday->delete)
- {
- print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id,$langs->trans("TitleDeleteCP"),$langs->trans("ConfirmDeleteCP"),"confirm_delete", '', 0, 1);
- }
- }
- // Si envoi en validation
- if ($action == 'sendToValidate' && $object->statut == 1)
- {
- print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id,$langs->trans("TitleToValidCP"),$langs->trans("ConfirmToValidCP"),"confirm_send", '', 1, 1);
- }
- // Si validation de la demande
- if ($action == 'valid')
- {
- print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id,$langs->trans("TitleValidCP"),$langs->trans("ConfirmValidCP"),"confirm_valid", '', 1, 1);
- }
- // Si refus de la demande
- if ($action == 'refuse')
- {
- $array_input = array(array('type'=>"text",'label'=> $langs->trans('DetailRefusCP'),'name'=>"detail_refuse",'size'=>"50",'value'=>""));
- print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id."&action=confirm_refuse", $langs->trans("TitleRefuseCP"), $langs->trans('ConfirmRefuseCP'), "confirm_refuse", $array_input, 1, 0);
- }
- // Si annulation de la demande
- if ($action == 'cancel')
- {
- print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id,$langs->trans("TitleCancelCP"),$langs->trans("ConfirmCancelCP"),"confirm_cancel", '', 1, 1);
- }
- $head=holiday_prepare_head($object);
- if ($action == 'edit' && $object->statut == 1)
- {
- $edit = true;
- print '<form method="post" action="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'">'."\n";
- print '<input type="hidden" name="action" value="update"/>'."\n";
- print '<input type="hidden" name="id" value="'.$object->id.'" />'."\n";
- }
- dol_fiche_head($head,'card',$langs->trans("CPTitreMenu"),0,'holiday');
- $linkback='<a href="'.DOL_URL_ROOT.'/holiday/list.php">'.$langs->trans("BackToList").'</a>';
-
- dol_banner_tab($object, 'id', $linkback, 1, 'rowid', 'ref');
-
-
- print '<div class="fichecenter">';
- print '<div class="fichehalfleft">';
- print '<div class="underbanner clearboth"></div>';
-
- print '<table class="border centpercent">';
- print '<tbody>';
- print '<tr>';
- print '<td class="titlefield">'.$langs->trans("User").'</td>';
- print '<td>';
- print $userRequest->getNomUrl(-1, 'leave');
- print '</td></tr>';
- // Type
- print '<tr>';
- print '<td>'.$langs->trans("Type").'</td>';
- print '<td>';
- $typeleaves=$object->getTypes(1,-1);
- print empty($typeleaves[$object->fk_type]['label']) ? $langs->trans("TypeWasDisabledOrRemoved",$object->fk_type) : $typeleaves[$object->fk_type]['label'];
- print '</td>';
- print '</tr>';
- $starthalfday=($object->halfday == -1 || $object->halfday == 2)?'afternoon':'morning';
- $endhalfday=($object->halfday == 1 || $object->halfday == 2)?'morning':'afternoon';
- if(!$edit)
- {
- print '<tr>';
- print '<td>'.$langs->trans('DateDebCP').' ('.$langs->trans("FirstDayOfHoliday").')</td>';
- print '<td>'.dol_print_date($object->date_debut,'day');
- print ' ';
- print $langs->trans($listhalfday[$starthalfday]);
- print '</td>';
- print '</tr>';
- }
- else
- {
- print '<tr>';
- print '<td>'.$langs->trans('DateDebCP').' ('.$langs->trans("FirstDayOfHoliday").')</td>';
- print '<td>';
- $form->select_date($object->date_debut,'date_debut_');
- print ' ';
- print $form->selectarray('starthalfday', $listhalfday, (GETPOST('starthalfday')?GETPOST('starthalfday'):$starthalfday));
- print '</td>';
- print '</tr>';
- }
- if (!$edit)
- {
- print '<tr>';
- print '<td>'.$langs->trans('DateFinCP').' ('.$langs->trans("LastDayOfHoliday").')</td>';
- print '<td>'.dol_print_date($object->date_fin,'day');
- print ' ';
- print $langs->trans($listhalfday[$endhalfday]);
- print '</td>';
- print '</tr>';
- }
- else
- {
- print '<tr>';
- print '<td>'.$langs->trans('DateFinCP').' ('.$langs->trans("LastDayOfHoliday").')</td>';
- print '<td>';
- $form->select_date($object->date_fin,'date_fin_');
- print ' ';
- print $form->selectarray('endhalfday', $listhalfday, (GETPOST('endhalfday')?GETPOST('endhalfday'):$endhalfday));
- print '</td>';
- print '</tr>';
- }
- print '<tr>';
- print '<td>'.$langs->trans('NbUseDaysCP').'</td>';
- print '<td>'.num_open_day($object->date_debut_gmt, $object->date_fin_gmt, 0, 1, $object->halfday).'</td>';
- print '</tr>';
- if ($object->statut == 5)
- {
- print '<tr>';
- print '<td>'.$langs->trans('DetailRefusCP').'</td>';
- print '<td>'.$object->detail_refuse.'</td>';
- print '</tr>';
- }
- // Description
- if (!$edit)
- {
- print '<tr>';
- print '<td>'.$langs->trans('DescCP').'</td>';
- print '<td>'.nl2br($object->description).'</td>';
- print '</tr>';
- }
- else
- {
- print '<tr>';
- print '<td>'.$langs->trans('DescCP').'</td>';
- print '<td class="tdtop">';
- $doleditor = new DolEditor('description', $object->description, '', 80, 'dolibarr_notes', 'In', 0, false, true, ROWS_3, '90%');
- print $doleditor->Create(1);
- print '</td></tr>';
- }
- print '</tbody>';
- print '</table>'."\n";
- print '</div>';
- print '<div class="fichehalfright">';
- print '<div class="ficheaddleft">';
-
- print '<div class="underbanner clearboth"></div>';
-
- // Info workflow
- print '<table class="border centpercent">'."\n";
- print '<tbody>';
- if (! empty($object->fk_user_create))
- {
- $userCreate=new User($db);
- $userCreate->fetch($object->fk_user_create);
- print '<tr>';
- print '<td class="titlefield">'.$langs->trans('RequestByCP').'</td>';
- print '<td>'.$userCreate->getNomUrl(-1).'</td>';
- print '</tr>';
- }
- if (!$edit) {
- print '<tr>';
- print '<td class="titlefield">'.$langs->trans('ReviewedByCP').'</td>';
- print '<td>'.$valideur->getNomUrl(-1).'</td>';
- print '</tr>';
- } else {
- print '<tr>';
- print '<td class="titlefield">'.$langs->trans('ReviewedByCP').'</td>';
- print '<td>';
- print $form->select_dolusers($object->fk_user, "valideur", 1, ($user->admin ? '' : array($user->id))); // By default, hierarchical parent
- print '</td>';
- print '</tr>';
- }
- print '<tr>';
- print '<td>'.$langs->trans('DateCreateCP').'</td>';
- print '<td>'.dol_print_date($object->date_create,'dayhour').'</td>';
- print '</tr>';
- if ($object->statut == 3) {
- print '<tr>';
- print '<td>'.$langs->trans('DateValidCP').'</td>';
- print '<td>'.dol_print_date($object->date_valid,'dayhour').'</td>';
- print '</tr>';
- }
- if ($object->statut == 4) {
- print '<tr>';
- print '<td>'.$langs->trans('DateCancelCP').'</td>';
- print '<td>'.dol_print_date($object->date_cancel,'dayhour').'</td>';
- print '</tr>';
- }
- if ($object->statut == 5) {
- print '<tr>';
- print '<td>'.$langs->trans('DateRefusCP').'</td>';
- print '<td>'.dol_print_date($object->date_refuse,'dayhour').'</td>';
- print '</tr>';
- }
- print '</tbody>';
- print '</table>';
- print '</div>';
- print '</div>';
- print '</div>';
-
- print '<div class="clearboth"></div>';
-
- dol_fiche_end();
-
- if ($action == 'edit' && $object->statut == 1)
- {
- print '<div align="center">';
- if ($canedit && $object->statut == 1)
- {
- print '<input type="submit" value="'.$langs->trans("Save").'" class="button">';
- }
- print '</div>';
- print '</form>';
- }
- if (! $edit)
- {
- print '<div class="tabsAction">';
- // Boutons d'actions
- if ($canedit && $object->statut == 1)
- {
- print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=edit" class="butAction">'.$langs->trans("EditCP").'</a>';
- }
- if ($canedit && $object->statut == 1)
- {
- print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=sendToValidate" class="butAction">'.$langs->trans("Validate").'</a>';
- }
- if ($user->rights->holiday->delete && $object->statut == 1) // If draft
- {
- print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=delete" class="butActionDelete">'.$langs->trans("DeleteCP").'</a>';
- }
- if ($user->id == $object->fk_validator && $object->statut == 2)
- {
- print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=valid" class="butAction">'.$langs->trans("Approve").'</a>';
- print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=refuse" class="butAction">'.$langs->trans("ActionRefuseCP").'</a>';
- }
- if (($user->id == $object->fk_validator || $user->id == $object->fk_user) && ($object->statut == 2 || $object->statut == 3)) // Status validated or approved
- {
- if (($object->date_debut > dol_now()) || $user->admin) print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=cancel" class="butAction">'.$langs->trans("ActionCancelCP").'</a>';
- else print '<a href="#" class="butActionRefused" title="'.$langs->trans("HolidayStarted").'">'.$langs->trans("ActionCancelCP").'</a>';
- }
- print '</div>';
- }
- } else {
- print '<div class="tabBar">';
- print $langs->trans('ErrorUserViewCP');
- print '<br /><br /><input type="button" value="'.$langs->trans("ReturnCP").'" class="button" onclick="history.go(-1)" />';
- print '</div>';
- }
- } else {
- print '<div class="tabBar">';
- print $langs->trans('ErrorIDFicheCP');
- print '<br /><br /><input type="button" value="'.$langs->trans("ReturnCP").'" class="button" onclick="history.go(-1)" />';
- print '</div>';
- }
- }
- }
- // End of page
- llxFooter();
- if (is_object($db)) $db->close();
|