cantico / absences

programs/init.php

<?php
//-------------------------------------------------------------------------
// OVIDENTIA http://www.ovidentia.org
// Ovidentia 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 2, or (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, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,
// USA.
//-------------------------------------------------------------------------
/**
 * @license http://opensource.org/licenses/gpl-license.php GNU General Public License (GPL)
 * @copyright Copyright (c) 2011 by CANTICO ({@link http://www.cantico.fr})
 */

include_once dirname(__FILE__).'/functions.php';


function absences_onDeleteAddon()
{
	include_once $GLOBALS['babInstallPath'].'utilit/eventincl.php';
	require_once $GLOBALS['babInstallPath'].'utilit/functionalityincl.php';

	bab_removeAddonEventListeners('absences');
	
	$functionalities = new bab_functionalities();
	$functionalities->unregister('PortletBackend/Absences');
	$functionalities->unregister('AbsencesAgent');
	
	return true;
}



function absences_upgrade($version_base, $version_ini)
{
	global $babDB;
	
	include_once $GLOBALS['babInstallPath'].'utilit/eventincl.php';
	include_once $GLOBALS['babInstallPath'].'utilit/devtools.php';
	
	$addon = bab_getAddonInfosInstance('absences');
	

    bab_removeAddonEventListeners('absences');
    
    $addon->addEventListener('bab_eventUserDeleted'                   , 'absences_onUserDeleted'                 , 'events.php');
    $addon->addEventListener('bab_eventBeforeSiteMapCreated'          , 'absences_onBeforeSiteMapCreated'        , 'events.php');
    $addon->addEventListener('bab_eventUserModified'                  , 'absences_onUserModified'                , 'events.php');
    $addon->addEventListener('bab_eventBeforeWaitingItemsDisplayed'   , 'absences_onBeforeWaitingItemsDisplayed' , 'events.php');
    $addon->addEventListener('bab_eventConfirmMultipleWaitingItems'   , 'absences_onConfirmMultipleWaitingItems' , 'events.php');
    $addon->addEventListener('bab_eventPeriodModified'                , 'absences_onModifyPeriod'                , 'events.php');
    $addon->addEventListener('bab_eventBeforePeriodsCreated'          , 'absences_onBeforePeriodsCreated'        , 'events.php');
    $addon->addEventListener('LibTimer_eventHourly'                   , 'absences_onHourly'                      , 'events.php');
    $addon->addEventListener('bab_eventAfterEventCategoryDeleted'     , 'absences_onAfterEventCategoryDeleted'   , 'events.php');
    $addon->addEventListener('bab_eventOrgChartEntityAfterDeleted'    , 'absences_onOrgChartEntityAfterDeleted'  , 'events.php');
    $addon->addEventListener('bab_eventDirectory'                     , 'absences_onDirectory'                   , 'events.php');
    

	
	$tables = new bab_synchronizeSql(dirname(__FILE__).'/sql/dump.sql');
	//var_dump($tables->getDifferences());
	
	if ($tables->isCreatedTable('absences_rights') && bab_isTable('bab_vac_managers'))
	{
		include_once dirname(__FILE__).'/olddata.php';
		
		absence_copy_table('bab_vac_managers'		, ABSENCES_MANAGERS_TBL);
		absence_copy_table('bab_vac_types'			, ABSENCES_TYPES_TBL);
		absence_copy_table('bab_vac_collections'	, ABSENCES_COLLECTIONS_TBL);
		absence_copy_table('bab_vac_coll_types'		, ABSENCES_COLL_TYPES_TBL);
		absence_copy_table('bab_vac_personnel'		, ABSENCES_PERSONNEL_TBL);
		absence_copy_table('bab_vac_rights'			, ABSENCES_RIGHTS_TBL);
		absence_copy_table('bab_vac_rights_rules'	, ABSENCES_RIGHTS_RULES_TBL);
		absence_copy_table('bab_vac_rights_inperiod', ABSENCES_RIGHTS_INPERIOD_TBL);
		absence_copy_table('bab_vac_users_rights'	, ABSENCES_USERS_RIGHTS_TBL);
		absence_copy_table('bab_vac_entries'		, ABSENCES_ENTRIES_TBL);
		absence_copy_table('bab_vac_entries_elem'	, ABSENCES_ENTRIES_ELEM_TBL);
		absence_copy_table('bab_vac_planning'		, ABSENCES_PLANNING_TBL);
		absence_copy_table('bab_vac_options'		, ABSENCES_OPTIONS_TBL);
		absence_copy_table('bab_vac_calendar'		, ABSENCES_CALENDAR_TBL);
		absence_copy_table('bab_vac_rgroup'			, ABSENCES_RGROUPS_TBL);
		absence_copy_table('bab_vac_comanager'		, ABSENCES_COMANAGER_TBL);
		
		bab_installWindow::message(absences_translate('Import vacations data to addon... done.'));
	}
	
	
	// verifier les cles de la table absences_users_rights
	
	if (bab_isKeyExists('absences_users_rights', 'id_user'))
	{
		$babDB->db_query('ALTER TABLE absences_users_rights DROP INDEX id_user');
	}
	
	if (bab_isKeyExists('absences_users_rights', 'id_right'))
	{
		$babDB->db_query('ALTER TABLE absences_users_rights DROP INDEX id_right');
	}
	
	if (!bab_isKeyExists('absences_users_rights', 'user_right'))
	{
		bab_installWindow::message(absences_translate('Error, the program was not able to create the unique key "user_right", duplicated entries in table absences_users_rights must be removed manually before continue'));
		return false;
	}

	
	// fix the kind field if not set
	
	$res = $babDB->db_query("SELECT id, kind, date_begin_fixed FROM absences_rights WHERE kind='0'");
	while ($arr = $babDB->db_fetch_assoc($res))
	{
		if ($arr['date_begin_fixed'] !== '0000-00-00 00:00:00')
		{
			$babDB->db_query("UPDATE absences_rights SET kind='2' WHERE id=".$babDB->quote($arr['id']));
		} else {
			$babDB->db_query("UPDATE absences_rights SET kind='1' WHERE id=".$babDB->quote($arr['id']));
		}
	}
	
	
	// mises a jour des demandes pour les droits a date fixe
	
	$res = $babDB->db_query("SELECT e.id FROM 
			absences_entries e, 
			absences_entries_elem ee, 
			absences_rights r
			WHERE 
				ee.id_entry=e.id 
				AND r.id=ee.id_right 
				AND r.kind='2'
			GROUP BY e.id 
	");
	
	while ($arr = $babDB->db_fetch_assoc($res))
	{
		$babDB->db_query("UPDATE absences_entries SET creation_type='1' WHERE id=".$babDB->quote($arr['id'])); 
	}
	
	
	
	// correction des demandes n'ayant pas de date de creation
	
	$res = $babDB->db_query("SELECT `id`, `date` FROM absences_entries WHERE createdOn='0000-00-00 00:00:00'");
	while ($arr = $babDB->db_fetch_assoc($res))
	{
		$babDB->db_query("UPDATE absences_entries SET createdOn=".$babDB->quote($arr['date'])." WHERE id=".$babDB->quote($arr['id']));
	}
	
	$typescount = 0;
	$res = $babDB->db_query('SELECT COUNT(*) FROM '.$babDB->backTick('absences_types'));
	if ($arr = $babDB->db_fetch_array($res))
	{
	    $typescount = (int) $arr[0];
	}
	
	
	// default types
	
	if (0 === $typescount)
	{
		bab_execSqlFile(dirname(__FILE__).'/sql/types.sql', 'UTF-8');
		bab_installWindow::message(absences_translate('Import vacations types... done.'));
	}
	
	
	
	$collectionscount = 0;
	$res = $babDB->db_query('SELECT COUNT(*) FROM '.$babDB->backTick('absences_collections'));
	if ($arr = $babDB->db_fetch_array($res))
	{
	    $collectionscount = (int) $arr[0];
	}
	
	// default collections
	
	if (0 === $collectionscount)
	{
	    bab_execSqlFile(dirname(__FILE__).'/sql/collections.sql', 'UTF-8');
	    bab_installWindow::message(absences_translate('Import collections... done.'));
	}
	
	
	
	// considerer toutes demandes anciennes deja notifiees, ne pas toucher aux demandes du jour pour si on notifie une fois par jour
	
	$babDB->db_query("UPDATE absences_entries SET appr_notified='1' WHERE appr_notified='0' AND status='' AND createdOn<DATE_SUB(NOW(),INTERVAL 1 DAY)");
	
	
	
	// essayer de creer les liaisons droit-regimes a partir des liaisons types-regimes qui n'exisents plus dans l'application
	// pour cela on a les liaisons utilisateur-droit, si tout les utilisateur d'un regime sont relie a un droit alors on peut crer la liaison regime-droit
	// on effectue le test que si l'ancienne liaison regime-type-droit est presente
	
	if ($tables->isCreatedTable('absences_coll_rights'))
	{
	
		$res = $babDB->db_query('
			SELECT 
				ct.id_coll, 
				r.id 
			FROM 
				absences_coll_types ct,
				absences_rights r
			WHERE 
				r.id_type=ct.id_type 
				
		');
	
		while ($link = $babDB->db_fetch_assoc($res))
		{
			// chercher les membres du regime qui ne sont pas associes au droit
			$res2 = $babDB->db_query('SELECT * FROM 
					absences_personnel p 
						LEFT JOIN absences_users_rights ur ON p.id_user=ur.id_user AND ur.id_right='.$babDB->quote($link['id']).' 
				WHERE 
					p.id_coll='.$babDB->quote($link['id_coll']).'
					AND ur.id IS NULL 
			');
			
			if ($babDB->db_num_rows($res2) == 0)
			{
				$babDB->db_query('INSERT INTO absences_coll_rights (id_coll, id_right) VALUES ('.$babDB->quote($link['id_coll']).','.$babDB->quote($link['id']).')');
			}
		}
	}
	
	
	
	
	if ($tables->isCreatedTable('absences_public_planning_groups')) {
	    // dans les version precedente, le planing public etait active par checkbox
	    $res = $babDB->db_query('SELECT public_calendar FROM absences_options');
	    if ($arr = $babDB->db_fetch_assoc($res)) {
	        if ($arr['public_calendar']) {
	            require_once $GLOBALS['babInstallPath'].'admin/acl.php';
	            aclSetGroups_all('absences_public_planning_groups', 1);
	        }
	    }
	}
	
	
	// add missing UUID
	
	require_once $GLOBALS['babInstallPath'].'utilit/uuid.php';
	$res = $babDB->db_query("SELECT id FROM absences_rights WHERE uuid=''");
	while ($arr = $babDB->db_fetch_assoc($res))
	{
		$babDB->db_query('UPDATE absences_rights SET uuid='.$babDB->quote(bab_uuid()).' WHERE id='.$babDB->quote($arr['id']));
	}
	
	$res = $babDB->db_query("SELECT id FROM absences_rights_inperiod WHERE uuid=''");
	while ($arr = $babDB->db_fetch_assoc($res))
	{
		$babDB->db_query('UPDATE absences_rights_inperiod SET uuid='.$babDB->quote(bab_uuid()).' WHERE id='.$babDB->quote($arr['id']));
	}
	
	
	// reprise des gestionnaires en tant que groupe avec ACL, faire la reprise si la table absences_options contient des lignes
	
	$res = $babDB->db_query("SELECT * FROM absences_managers");
	if ($babDB->db_num_rows($res) > 0)
	{
		require_once $GLOBALS['babInstallPath'].'admin/acl.php';
		
		$users = aclGetAccessUsers('absences_managers_groups', 1);
		if (0 === count($users))
		{
			$groupname = absences_translate('Vacations managers');
			$i = 1;
			
			$rootgroups = bab_getGroups(BAB_REGISTERED_GROUP, false);
			$names = array_flip($rootgroups['name']);
			
			while(isset($names[$groupname])) {
				$groupname .= ' '.$i;
				$i++;
			}
	
			$id_group = bab_createGroup($groupname, absences_translate('Created automatically while upgrading to the new absences addon'), 0);
			
			while ($arr = $babDB->db_fetch_assoc($res))
			{
				bab_addUserToGroup($arr['id_user'], $id_group);
			}
			
			
			aclAdd('absences_managers_groups', $id_group, 1);
			
			$babDB->db_query('TRUNCATE absences_managers');
		}
	}
	
	
	// selection de l'organigramme par defaut
	require_once $GLOBALS['babInstallPath'].'utilit/ocapi.php';
	if ($idprimaryoc = bab_OCgetPrimaryOcId())
	{
		$babDB->db_query('UPDATE absences_options SET id_chart='.$babDB->quote($idprimaryoc)." WHERE id_chart='0'");
	}
	
	
	
	// reprise des dates lors de l'ajout des dates dans la table absences_entries_elem
	require_once dirname(__FILE__).'/upgrade/entry_elem.php';
	absences_upgradeEntryElemDates::onUpgrade();
	
	
	$addon = bab_getAddonInfosInstance('absences');
	bab_functionality::includefile('PortletBackend');

It seems like you code against a specific sub-type and not the parent class bab_functionality as the method includefile() does only exist in the following sub-classes of bab_functionality: Func_Archive, Func_Archive_Zip, Func_Archive_Zip_ZipArchive, Func_Archive_Zip_Zlib, Func_CalendarBackend, Func_CalendarBackend_Ovi, Func_ContextActions, Func_ContextActions_Article, Func_ContextActions_ArticleTopic, Func_Home, Func_Home_Ovidentia, Func_Icons, Func_Icons_Default, Func_Ovml, Func_Ovml_Container, Func_Ovml_Container_Addon, Func_Ovml_Container_Article, Func_Ovml_Container_ArticleCategories, Func_Ovml_Container_ArticleCategory, Func_Ovml_Container_ArticleCategoryNext, Func_Ovml_Container_ArticleCategoryPrevious, Func_Ovml_Container_ArticleFiles, Func_Ovml_Container_ArticleNext, Func_Ovml_Container_ArticlePrevious, Func_Ovml_Container_ArticleTopic, Func_Ovml_Container_ArticleTopicNext, Func_Ovml_Container_ArticleTopicPrevious, Func_Ovml_Container_ArticleTopics, Func_Ovml_Container_Articles, Func_Ovml_Container_ArticlesHomePages, Func_Ovml_Container_CalendarCategories, Func_Ovml_Container_CalendarEventDomains, Func_Ovml_Container_CalendarEvents, Func_Ovml_Container_CalendarGroupEvents, Func_Ovml_Container_CalendarResourceEvents, Func_Ovml_Container_CalendarUserEvents, Func_Ovml_Container_Calendars, Func_Ovml_Container_DbDirectories, Func_Ovml_Container_DbDirectory, Func_Ovml_Container_DbDirectoryAcl, Func_Ovml_Container_DbDirectoryEntry, Func_Ovml_Container_DbDirectoryEntryFields, Func_Ovml_Container_DbDirectoryFields, Func_Ovml_Container_DbDirectoryMemberFields, Func_Ovml_Container_DbDirectoryMembers, Func_Ovml_Container_Delegation, Func_Ovml_Container_DelegationAdministrators, Func_Ovml_Container_DelegationItems, Func_Ovml_Container_DelegationManaged, Func_Ovml_Container_Delegations, Func_Ovml_Container_DelegationsCategories, Func_Ovml_Container_DelegationsCategory, Func_Ovml_Container_DelegationsManaged, Func_Ovml_Container_Faq, Func_Ovml_Container_FaqNext, Func_Ovml_Container_FaqPrevious, Func_Ovml_Container_FaqQuestion, Func_Ovml_Container_FaqQuestionNext, Func_Ovml_Container_FaqQuestionPrevious, Func_Ovml_Container_FaqQuestions, Func_Ovml_Container_FaqSubCategories, Func_Ovml_Container_FaqSubCategory, Func_Ovml_Container_Faqs, Func_Ovml_Container_File, Func_Ovml_Container_FileFields, Func_Ovml_Container_FileNext, Func_Ovml_Container_FilePrevious, Func_Ovml_Container_Files, Func_Ovml_Container_Folder, Func_Ovml_Container_FolderNext, Func_Ovml_Container_FolderPrevious, Func_Ovml_Container_Folders, Func_Ovml_Container_Forum, Func_Ovml_Container_ForumNext, Func_Ovml_Container_ForumPrevious, Func_Ovml_Container_Forums, Func_Ovml_Container_IfEqual, Func_Ovml_Container_IfGreaterThan, Func_Ovml_Container_IfGreaterThanOrEqual, Func_Ovml_Container_IfIsSet, Func_Ovml_Container_IfLessThan, Func_Ovml_Container_IfLessThanOrEqual, Func_Ovml_Container_IfNotEqual, Func_Ovml_Container_IfNotIsSet, Func_Ovml_Container_IfUserMemberOfGroups, Func_Ovml_Container_Multipages, Func_Ovml_Container_ObjectsInfo, Func_Ovml_Container_OrgPathToEntity, Func_Ovml_Container_OrgUserEntities, Func_Ovml_Container_OvmlArray, Func_Ovml_Container_OvmlArrayFields, Func_Ovml_Container_OvmlSoap, Func_Ovml_Container_ParentsArticleCategory, Func_Ovml_Container_Post, Func_Ovml_Container_PostFiles, Func_Ovml_Container_RecentArticles, Func_Ovml_Container_RecentComments, Func_Ovml_Container_RecentFaqQuestions, Func_Ovml_Container_RecentFiles, Func_Ovml_Container_RecentPosts, Func_Ovml_Container_RecentThreads, Func_Ovml_Container_SitemapCustomNode, Func_Ovml_Container_SitemapEntries, Func_Ovml_Container_SitemapEntry, Func_Ovml_Container_SitemapPath, Func_Ovml_Container_Soap, Func_Ovml_Container_SubFolders, Func_Ovml_Container_Tags, Func_Ovml_Container_Thread, Func_Ovml_Container_TmProjects, Func_Ovml_Container_TmSpaces, Func_Ovml_Container_TmTaskFields, Func_Ovml_Container_TmTasks, Func_Ovml_Container_WaitingArticles, Func_Ovml_Container_WaitingComments, Func_Ovml_Container_WaitingFiles, Func_Ovml_Container_WaitingPosts, Func_Ovml_Function, Func_Ovml_Function_AOAddition, Func_Ovml_Function_AODivision, Func_Ovml_Function_AOModulus, Func_Ovml_Function_AOMultiplication, Func_Ovml_Function_AOSubtraction, Func_Ovml_Function_AddStyleSheet, Func_Ovml_Function_Addon, Func_Ovml_Function_Ajax, Func_Ovml_Function_ArticleTree, Func_Ovml_Function_CurrentNode, Func_Ovml_Function_FileTree, Func_Ovml_Function_Get, Func_Ovml_Function_GetCookie, Func_Ovml_Function_GetCsrfProtectToken, Func_Ovml_Function_GetCurrentAdmGroup, Func_Ovml_Function_GetLanguage, Func_Ovml_Function_GetPageTitle, Func_Ovml_Function_GetPath, Func_Ovml_Function_GetSelectedSkinPath, Func_Ovml_Function_GetSessionVar, Func_Ovml_Function_GetVar, Func_Ovml_Function_Header, Func_Ovml_Function_IfNotIsSet, Func_Ovml_Function_Include, Func_Ovml_Function_NextArticle, Func_Ovml_Function_Post, Func_Ovml_Function_PreviousArticle, Func_Ovml_Function_PreviousOrNextArticle, Func_Ovml_Function_PutArray, Func_Ovml_Function_PutSoapArray, Func_Ovml_Function_PutVar, Func_Ovml_Function_Recurse, Func_Ovml_Function_Request, Func_Ovml_Function_SetCookie, Func_Ovml_Function_SetSessionVar, Func_Ovml_Function_SitemapCustomNodeId, Func_Ovml_Function_SitemapMenu, Func_Ovml_Function_SitemapPosition, Func_Ovml_Function_SitemapUrl, Func_Ovml_Function_Translate, Func_Ovml_Function_UrlContent, Func_Ovml_Function_WebStat, Func_PortalAuthentication, Func_PortalAuthentication_AuthOvidentia, Func_PwdComplexity, Func_PwdComplexity_DefaultPortal, Func_SearchUi, Func_SitemapDynamicNode, Func_SitemapDynamicNode_Topic, Func_UserEditor, Func_WorkingHours, Func_WorkingHours_Ovidentia, Ovml_Container_Sitemap, bab_ArithmeticOperator, bab_Ovml_Container_Operator, bab_rgp. Maybe you want to instanceof check for one of these explicitly?

    if (class_exists('Func_PortletBackend')) {
       $addon->registerFunctionality('PortletBackend/Absences', 'portletbackend.class.php');
    }
    $addon->registerFunctionality('AbsencesAgent', 'utilit/agent.api.php');
    $addon->registerFunctionality('AbsencesRequest', 'utilit/request.api.php');


	
	
	
	// T8341 Reprise des droits de recuperation creer avec une date de fin= a la date de debut
	
	$babDB->db_query("UPDATE absences_rights_inperiod SET period_end=DATE_ADD(period_end,INTERVAL 1 YEAR) 
	    WHERE period_start = period_end AND id_right IN(
	       SELECT id FROM absences_rights WHERE kind='16')");
	$babDB->db_query("UPDATE absences_rights SET date_end=DATE_ADD(date_end,INTERVAL 1 YEAR) 
	    WHERE kind='16' AND date_begin=date_end");
	
	
	// reprise des declaration de jours travaille approuvees par auto-approbation sans droit cree
	// avant la version 2.67 id_right n'existait pas
	// Utiliser ce code seulement si il y a des droit a recuperation manquant, il peut etre dangereux si le format du nom du droit change
	// la method restoreMissingRight cree le droit manquant ou cree la liaison manquante
	
	/*
	$res = $babDB->db_query("SELECT * FROM absences_workperiod_recover_request WHERE id_right='0' AND status='Y' AND modifiedOn>'2015-05-30 00:00:00'");
	require_once dirname(__FILE__).'/utilit/workperiod_recover_request.class.php';
	while ($arr = $babDB->db_fetch_assoc($res)) {
	    $request = new absences_WorkperiodRecoverRequest();
	    $request->setRow($arr);
	    $request->restoreMissingRight();
	}
	*/
	
	
	
	
	$babDB->db_query("UPDATE absences_cet_deposit_request SET firstconfirm='1' WHERE status='Y'");
	$babDB->db_query("UPDATE absences_workperiod_recover_request SET firstconfirm='1' WHERE status='Y'");
	$babDB->db_query("UPDATE absences_entries SET firstconfirm='1' WHERE status='Y'");
	
	
	// T9250 Export des soldes a une date donnee
	
	$babDB->db_query("UPDATE absences_rights SET createdOn=date_entry WHERE createdOn='0000-00-00 00:00:00'");
	
	
	
	// verification de l'historique des status
	
	absences_fixRequestLastMovement('absences_entries', 'absences_Entry');
	absences_fixRequestLastMovement('absences_workperiod_recover_request', 'absences_WorkperiodRecoverRequest');
	absences_fixRequestLastMovement('absences_cet_deposit_request', 'absences_CetDepositRequest');
	
	absences_deleteAgentsWithNoUser();
	absence_rePrimary();
	
	return true;
}