absences_viewVacationCalendarCls::getnextuser() - Code Metrics - Inspection of "Add the limit parameter" - cantico/absences - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Push — master ( 907983...ba4b0b )

by Paul
created 2016-03-24 16:40 UTC
absences_viewVacationCalendarCls::getnextuser() B

↳ Parent: absences_viewVacationCalendarCls
Complexity

Conditions	6
Paths	24
Size

Total Lines	39
Code Lines	23
Duplication

Lines	0
Ratio	0 %
Metric	Value
dl	0
loc	39
rs	8.439
cc	6
eloc	23
nc	24
nop	0
<?php
/************************************************************************
 * OVIDENTIA http://www.ovidentia.org                                   *
 ************************************************************************
 * Copyright (c) 2003 by CANTICO ( http://www.cantico.fr )              *
 *                                                                      *
 * This file is part of Ovidentia.                                      *
 *                                                                      *
 * 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.																	*
************************************************************************/


require_once dirname(__FILE__).'/vacincl.php';





/**
 * Get period index from database
 *
 * @param	int		$id_user
 * @param	int		$month
 * @param	int		$year
 * @param   string  $dateb      ISO date
 * @param   string  $datee      ISO date
 *
 * @return array
 */
function absences_getPeriodIndex($id_user, $month, $year, $dateb, $datee)
{
	require_once $GLOBALS['babInstallPath'].'utilit/settings.class.php';
	global $babDB;

	$req = "
	SELECT 
		c.id_user,
		c.cal_date,
		c.ampm,
		c.period_type,
		c.id_entry,
		c.color,
		c.title,
		e.status 
	FROM
		".ABSENCES_CALENDAR_TBL." c
		LEFT JOIN ".ABSENCES_ENTRIES_TBL." e ON e.id = c.id_entry 
	WHERE
		monthkey=".$babDB->quote($month.$year)."
		AND c.id_user=".$babDB->quote($id_user)."
	ORDER BY c.cal_date, c.ampm 
	";
	$res = $babDB->db_query($req);


	if (0 === $babDB->db_num_rows($res))
	{
		// cache not found

		absences_updateCalendar($id_user, $year, $month);
		$res = $babDB->db_query($req);
	}


	$periodIndex = array();
	
	while ($arr = $babDB->db_fetch_assoc($res)) {
	    
	    if ('0000-00-00' !== $dateb && $dateb > $arr['cal_date']) {
	        continue;
	    }
	    
	    if ('0000-00-00' !== $datee && $datee < $arr['cal_date']) {
	        continue;
	    }
		
		$arr['period_type'] = (int) $arr['period_type'];
		$arr['ampm'] = (int) $arr['ampm'];
		$arr['id_user'] = (int) $arr['id_user'];
		
		$key = 'd.'.$arr['cal_date'];
		$key .= $arr['ampm'] ? '.1' : '.0';
		$periodIndex[$key] = $arr;
	}


	return $periodIndex;
}





/**
 * 
 */
function absences_getEntites()

{
    $id_chart = absences_getVacationOption('id_chart');
    $org = new bab_OrgChartUtil($id_chart);
    if (!$org->isAccessValid()) {
        return array();
    }
    return bab_OCGetEntities($id_chart);
}

/**
 * 
 * @param int $ide
 */
function absences_getChildsEntities($ide)

{
    $id_chart = absences_getVacationOption('id_chart');
    $org = new bab_OrgChartUtil($id_chart);
    if (!$org->isAccessValid()) {
        return array();
    }
    return bab_OCGetChildsEntities($ide, $id_chart);
}




class absences_viewVacationCalendarCls
{
	var $entries = array();
	var $fullname;
	var $vacwaitingtxt;
	var $vacapprovedtxt;
	var $print;
	var $close;
	var $emptylines = true;

	public $display_types;
	
	
	public $public = false;
	public $total = null;
	
	public $loadmore = null;
	
	
	public $nbmonth;
	
	public $limit;


	/**
	 * 
	 * @param array 	$users			Users displayed by default
	 * @param bool 		$period			Allow period selection (vacation request creation first step)
	 * @param bool 		$display_types	Display types color and legend on planning
	 * @param int		$nbmonth		Number of month to load
	 * @param bool		$dispusers		Display user names column
	 */
	public function __construct($users, $period, $display_types, $nbmonth, $dispusers, $shiftmonth = 0, $legend = true)
	{
		global $babBody;

		include_once $GLOBALS['babInstallPath']."utilit/dateTime.php";
		include_once $GLOBALS['babInstallPath']."utilit/urlincl.php";

		$month = isset($_REQUEST['month']) ? (int) $_REQUEST['month'] : (date("n") + $shiftmonth);
		$year = isset($_REQUEST['year']) ? (int) $_REQUEST['year'] : date("Y");

		global $babDB;
		$this->month = $month;
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->year = $year;
class MyClass { }

$x = new MyClass();
$x->foo = true;

		$this->dispusers = $dispusers;
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->display_types = $display_types;
		$this->display_legend = $legend;
class MyClass { }

$x = new MyClass();
$x->foo = true;

		$this->userNameArr = array();
class MyClass { }

$x = new MyClass();
$x->foo = true;
		
		foreach ($users as $uid)
		{
			$uid = (int) $uid;
			$this->userNameArr[$uid] = bab_getUserName($uid);
		}

		bab_sort::natcasesort($this->userNameArr);


		$this->idusers 		= array_keys($this->userNameArr);
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->nbusers 		= count($this->idusers);
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->firstuser 	= bab_toHtml(current($this->userNameArr));
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->display_firstuser = 1 === $this->nbusers;


		$this->period = $period;
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->vacwaitingtxt = absences_translate("Waiting vacation request");
		$this->vacapprovedtxt = absences_translate("Approved vacation request");
		$this->t_selected = absences_translate("Selected period");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->print = absences_translate("Print");
		$this->close = absences_translate("Close");
		$this->t_noresult = absences_translate("No results found for this search query");
class MyClass { }

$x = new MyClass();
$x->foo = true;

		$this->t_previousmonth = absences_translate("Previous month");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_previousyear = absences_translate("Previous year");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_nextmonth = absences_translate("Next month");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_nextyear = absences_translate("Next year");
class MyClass { }

$x = new MyClass();
$x->foo = true;

		$this->t_nonworking = absences_translate("Non-working day");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_weekend = absences_translate("Week-end");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_rotate = absences_translate("Print in landscape");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_non_used = $this->display_types ? absences_translate("Non-used days") : absences_translate("Absences");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_waiting = absences_translate("Waiting vacation request");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_previsional = absences_translate("Previsional vacation request");
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_waiting_vac = absences_translate("Waiting vacation request");

		$this->t_legend = absences_translate("Legend");
class MyClass { }

$x = new MyClass();
$x->foo = true;

		$this->id_request = isset($_REQUEST['id']) ? $_REQUEST['id'] : 0;
class MyClass { }

$x = new MyClass();
$x->foo = true;

		$this->nbmonth = $nbmonth;
		
		$this->limit = absences_getSearchLimit($nbmonth);

		$urltmp = bab_url::get_request_gp();
		$this->nwd_color = 'yellow'; // default color for non working days if no categories
class MyClass { }

$x = new MyClass();
$x->foo = true;

		if( $GLOBALS['babBody']->babsite['id_calendar_cat'] != 0)
		{
			include_once $GLOBALS['babInstallPath']."utilit/calapi.php";
			$idcat = bab_calGetCategories($GLOBALS['babBody']->babsite['id_calendar_cat']);
			if( isset($idcat[0]['color']))
			{
				$this->nwd_color = $idcat[0]['color'];
			}
		}

		if (!empty($_REQUEST['popup']))
		{
			$this->popup = true;
class MyClass { }

$x = new MyClass();
$x->foo = true;
		}

		if (!isset($_REQUEST['ide']))
		{
			$urltmp->idu = implode(',',$this->idusers);
		}

		$switchurl = clone $urltmp;

		if (1 == $this->nbmonth) {

			$switchurl->nbmonth = 12;
			$this->switchurl = $switchurl->toString();
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->switchlabel = absences_translate("Year view");
class MyClass { }

$x = new MyClass();
$x->foo = true;
			
			
			
			$this->prevmonthclass = 'prev1';
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->prevyearclass = 'prev2';
class MyClass { }

$x = new MyClass();
$x->foo = true;
			
			$this->nextmonthclass = 'next1';
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->nextyearclass = 'next2';
class MyClass { }

$x = new MyClass();
$x->foo = true;
			
		} else {
			$switchurl->nbmonth = 1;
			$this->switchurl = $switchurl->toString();
			$this->switchlabel = absences_translate("Month view");
			
			$this->prevmonthclass = 'prev2';
			$this->prevyearclass = 'prev1';
			
			$this->nextmonthclass = 'next2';
			$this->nextyearclass = 'next1';
		}

		$urltmp->nbmonth = $this->nbmonth;


		$previousmonth = clone $urltmp;
		$previousmonth->month = date("n", mktime( 0,0,0, $month-1, 1, $year));
		$previousmonth->year = date("Y", mktime( 0,0,0, $month-1, 1, $year));
		$this->previousmonth	= $previousmonth->toString();


		$nextmonth = clone $urltmp;
		$nextmonth->month = date("n", mktime( 0,0,0, $month+1, 1, $year));
		$nextmonth->year = date("Y", mktime( 0,0,0, $month+1, 1, $year));
		$this->nextmonth = $nextmonth->toString();


		$previousyear = clone $urltmp;
		$previousyear->month = date("n", mktime( 0,0,0, $month, 1, $year-1));
		$previousyear->year = date("Y", mktime( 0,0,0, $month, 1, $year-1));
		$this->previousyear = $previousyear->toString();


		$nextyear = clone $urltmp;
		$nextyear->month = date("n", mktime( 0,0,0, $month, 1, $year+1));
		$nextyear->year = date("Y", mktime( 0,0,0, $month, 1, $year+1));
		$this->nextyear = $nextyear->toString();


		$dateb = new BAB_DateTime($year, $month, 1);
		$datee = $dateb->cloneDate();
		$datee->add($this->nbmonth, BAB_DATETIME_MONTH);
		
		

		$this->yearname = $this->getTitle($dateb, $datee);
class MyClass { }

$x = new MyClass();
$x->foo = true;
		
		





		if ($this->display_types)
		{
			$this->restypes = $babDB->db_query("
class MyClass { }

$x = new MyClass();
$x->foo = true;

				SELECT
					t.*
					FROM
					".ABSENCES_TYPES_TBL." t,
					absences_rights r,
					absences_users_rights ur,
					".ABSENCES_PERSONNEL_TBL." p
				WHERE
					p.id_user IN(".$babDB->quote($this->idusers).")
					AND p.id_user=ur.id_user
					AND ur.id_right=r.id
					AND r.id_type=t.id
				GROUP BY
					t.id
					");

		}
		
		
		// filtre par service
		
		$W = bab_Widgets();
		$departments = $W->Multiselect();
		$departments->setName('departments')->setValue(bab_rp('departments'));
		
		$entities = absences_getEntites();
		foreach($entities as $e) {
		    $departments->addOption($e['id'], $e['name']);
		}
		
		$this->departments = '';
class MyClass { }

$x = new MyClass();
$x->foo = true;

		if (count($entities) > 0) {
		    $this->departments = $departments->display($W->HtmlCanvas());
		}
		
		
		// filtre recherche par date
		
		$this->datefilter = $this->getDateFilter()->display($W->HtmlCanvas());
class MyClass { }

$x = new MyClass();
$x->foo = true;
	}
	
	
	
	private function getDateFilter()
	{
	    $W = bab_Widgets();
	    
	    switch (bab_rp('searchtype')) {
	        case '2':

    	       $dateb = bab_rp('dateb');
    	       $datee = bab_rp('datee');
    	       $_date = null;
    	       break;
    	      
	        default:
	        case '1':
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
	           $dateb = null;
	           $datee = null;
	           $_date = bab_rp('date');
	           break;
	    }
	    
	    $period = $W->LabelledWidget(
	            absences_translate('Date'),
	            $W->PeriodPicker()->setNames('dateb', 'datee')->setValues($dateb, $datee)
	    );
	    
	    $date = $W->LabelledWidget(
	            absences_translate('Date'),
	            $picker = $W->DatePicker()->setValue($_date)->addClass('absences-search-by-date'),
	            'date'
	    );
	    
	    $begin = $picker->getISODate($dateb);
	    $end = $picker->getISODate($datee);
	    $d = $picker->getISODate($_date);
	    
	    if ('0000-00-00' !== $d) {
	        $begin = $d;
	        $end = $d;
	    }
	    
	    if ('0000-00-00' !== $begin && '0000-00-00' !== $end) {
	        $picker->setMetadata('dateb', $begin);
	        $picker->setMetadata('datee', $end);
	    }
	    
	    
	    $frame = $W->Frame(null , $W->HBoxItems());
	    
	    
	    $frame->addItem(
	            $W->LabelledWidget(
	                    absences_translate('Search by date'),
	                    $W->Select()
	                    ->setAssociatedDisplayable($date, array('1'))
	                    ->setAssociatedDisplayable($period, array('2'))
	                    ->addOption('1', absences_translate("Absences on a date"))
	                    ->addOption('2', absences_translate("Absences in a period"))
	                    ->setValue(bab_rp('searchtype', 1)),
	                    'searchtype'
	            )
	    );
	    
	    
	    $frame->addItem($period);
	    $frame->addItem($date);
	    
	    return $frame;
	}
	
	
	/**
	 * @param BAB_DateTime $dateb
	 * @param BAB_DateTime $datee
	 * 
	 * @return string
	 */
	private function getTitle(BAB_DateTime $dateb, BAB_DateTime $datee)
	{
	    $months = bab_DateStrings::getMonths();
	    $duration = (int) round(($datee->getTimeStamp() - $dateb->getTimeStamp()) / 86400);

	    if ($duration > 33) {
	        
	        $end = $datee->cloneDate();
	        $end->less(1, BAB_DATETIME_DAY);
	        
	        return $months[$dateb->getMonth()].' '.$dateb->getYear()."-".$months[$end->getMonth()].' '.$end->getYear();
	    }
	    
	    return $months[$dateb->getMonth()].' '.$dateb->getYear();
	}
	
	
	
	
	public function getnexthidden()
	{
		if (list($name, $value) = each($_GET))
		{
			if (is_array($value))
			{
				return true;
			}
			
			$this->name = bab_toHtml($name);
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->value = bab_toHtml($value);
class MyClass { }

$x = new MyClass();
$x->foo = true;
			return true;
		}
		
		reset($_GET);
		return false;
	}
	
	

	public function getdayname()
	{
		static $i = 1;
		if( $i <= 31)
		{
			$this->dayname = sprintf('%02d',$i);
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$i++;
			return true;
		}
		else
			return false;
	}
	
	
	/**
	 *
	 */
	public function getmonth()
	{
		static $i = 0;
		if( $i < $this->nbmonth)
		{
	
			$dateb = new BAB_DateTime($this->year, $this->month + $i, 1);
	
			$this->curyear = $dateb->getYear();
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->curmonth = $dateb->getMonth();
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$months = bab_DateStrings::getMonths();
			$this->monthname = bab_toHtml($months[$this->curmonth]);
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->totaldays = date("t", $dateb->getTimeStamp());
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->previous_period = NULL;

			$i++;
			return true;
		}
		else
			return false;
	}
	
	
	
	

	public function getnextuser()
	{
		static $i = 0;

		$n = $this->nbusers;

		if ( $n == 0 )
			$n = 1;

		$this->rowspan = $this->emptylines ? $this->nbusers : $n;
class MyClass { }

$x = new MyClass();
$x->foo = true;

		if ($i < $n)
		{
			$this->first = $i == 0 ;
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->id_user = $this->idusers[$i];
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->username = bab_toHtml($this->userNameArr[$this->id_user]);

			try {
				$agent = absences_Agent::getCurrentUser();
				if ($agent->isManager())
				{
					$this->userurl = bab_toHtml('?tg=addon/absences/vacadm&idx=modp&idp='.$this->idusers[$i]);
class MyClass { }

$x = new MyClass();
$x->foo = true;
				} else {
					$this->userurl = false;
				}
			} catch(Exception $e)
			{
				$this->userurl = false;
			}
			

			$i++;
			return true;
		}
		else
		{
			$i = 0;
			return false;
		}
	}


	/**
	 * 
	 * @return boolean
	 */
	public function getday()
	{
		static $d = 1;
		static $total = 0;
		if( $d <= 31)
		{
			$time = mktime(0, 0, 0, $this->curmonth, $d, $this->curyear);
            $this->day = bab_formatDate('%D', $time).' '.date('j', $time);
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$d++;
			return true;
		}
		else
		{
			$d = 1;
			return false;
		}
	}

	public function getnexttype()
	{

		if (!$this->display_types) {
			return false;
		}

		global $babDB;
		if ($this->arr = $babDB->db_fetch_array($this->restypes)) {
			$this->arr['name'] 			= bab_toHtml($this->arr['name']);
class MyClass { }

$x = new MyClass();
$x->foo = true;
			$this->arr['description'] 	= bab_toHtml($this->arr['description']);
			return true;
		}
		else {
			return false;
		}
	}
	
	
	public function entity($ide, $all = false)
	{
	    // permettre de charger les sous-entites fusionnes dans le meme planning
	    
	    $url = bab_url::get_request_gp();
	    $url->all = $all ? '0' : '1';
	    
	    $this->mergedurl = false;
class MyClass { }

$x = new MyClass();
$x->foo = true;
	    
	    if (bab_OCGetChildCount($ide)) {
	        $this->mergedurl = bab_toHtml($url->toString());
	    }
	    
	    if ($all) {
	        $this->t_merged = absences_translate('View the entity only');
class MyClass { }

$x = new MyClass();
$x->foo = true;
	    } else {
	        $this->t_merged = absences_translate('View users from all entities');
	    }
	}
	
	
	public function publiccalendar($total)
	{
		$this->display_firstuser = false;

		$this->public = true;
		$this->t_search_name = absences_translate('Search by name');
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_search_entity = absences_translate('By entity');
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->keyword = bab_rp('keyword');
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_ok = absences_translate('Ok');
class MyClass { }

$x = new MyClass();
$x->foo = true;
		
		$this->total = $total;
		$this->t_total = sprintf(absences_translate('%d result found', '%d results found', $total), $total);
class MyClass { }

$x = new MyClass();
$x->foo = true;
		
		
		// prepare button for first load
		
		$this->t_use_month_view = false;
class MyClass { }

$x = new MyClass();
$x->foo = true;
		
		$this->t_loadall = absences_translate('View all results');
class MyClass { }

$x = new MyClass();
$x->foo = true;
		$this->t_viewBegin = absences_translate('View the first 30 only');
class MyClass { }

$x = new MyClass();
$x->foo = true;
		
		if ($total > $this->nbusers)
		{
			$last = $total - $this->nbusers;
			
			if (1 < $this->nbmonth)
			{
				$this->t_use_month_view = sprintf(absences_translate('The planning display only %d results from %d total results, use the month view to fetch next results'), $this->nbusers, $total);
				$this->loadmore = false;
			} else {

				$this->loadmore = $this->limit < $last ? $this->limit : $last;
				$this->t_loadmore = sprintf(absences_translate('Load the next %d results'), $this->loadmore);

			}
		} else {
			$this->loadmore = false;
		}
	}
	
	
	public function getHtml()
	{
		return bab_printTemplate($this, absences_addon()->getRelativePath()."vacuser.html", "calendarbyuser");

	}
	
	

	public function printhtml()
	{
		global $babBody;
		
		/*@var $babBody babBody */
		
		$html = $this->getHtml();
		
		/*@var $jquery Func_Jquery */
		$jquery = bab_functionality::get('jquery');
		$jquery->includeCore();

		$babBody->addStyleSheet(absences_addon()->getStylePath().'vacation.css');
		$babBody->addJavascriptFile(absences_addon()->getTemplatePath().'calendar.jquery.js', true);

		if (isset($_REQUEST['popup']) && $_REQUEST['popup'] == 1) {
			$babBody->babpopup($html);
		}
		else {
			$babBody->babecho($html);
		}
	}
}







/**
 * Display a vacation calendar
 * @param	array		$users			array of id_user to display
 * @param	boolean		$period			allow period selection, first step of vacation request
 * @param	boolean		$display_types	Display types color and legend on planning
 * @param	int			$nbmonth		Number of month to display
 * @param	bool		$dispusers		display a column with user names
 * @param 	int			$total			Total number of results in search
 */
function absences_viewVacationCalendar($users, $period, $display_types, $nbmonth = 12, $dispusers = true, $total = null )
{
	global $babBody;

	$temp = new absences_viewVacationCalendarCls($users, $period, $display_types, $nbmonth, $dispusers);

	if (count($users) == 0)
	{
		$babBody->addError(absences_translate("ERROR: No members"));
	}
	
	if (bab_rp('idx') == 'entity_cal')
	{
	    $temp->entity(bab_rp('ide'), (bool) bab_rp('all', false));
	}
	
	if (bab_rp('idx') == 'public')
	{
		$temp->publiccalendar($total);
	}
	
	$temp->printhtml();
}



/**
 * Serach in active users to display the public calendar
 * @param string $keyword
 * @param array $departments
 * @param string $dateb
 * @param string $datee
 * @param string $date
 */
function absences_publicCalendarUsers($keyword, $departments, $searchtype, $dateb, $datee, $date)
{
	global $babDB;
	require_once $GLOBALS['babInstallPath'].'utilit/userinfosincl.php';
	
	
	$W = bab_Widgets();
	$datePicker = $W->DatePicker();
	
	switch($searchtype) {
	    default:
	    case 1:
	        $dateb = '0000-00-00';
	        $datee = '0000-00-00';
	        $date = $datePicker->getISODate($date);
	        break;
	        
	    case 2:
	        $dateb = $datePicker->getISODate($dateb);
	        $datee = $datePicker->getISODate($datee);
	        $date = '0000-00-00';
	        break;
	}
	
	$dateb = $datePicker->getISODate($dateb);
	$datee = $datePicker->getISODate($datee);
	$date = $datePicker->getISODate($date);
	
	if ('0000-00-00' !== $date && false !== $date) {
	    $dateb = $date;
	    $datee = $date;
	}
	
	
	$query = 'SELECT
			u.id,
			u.lastname,
			u.firstname
		FROM
			bab_users u
	           LEFT JOIN bab_oc_roles_users ru ON ru.id_user=u.id 
	           LEFT JOIN bab_oc_roles r ON r.id=ru.id_role,
			absences_personnel p
	
		WHERE
			p.id_user=u.id AND '.bab_userInfos::queryAllowedUsers('u');

	
	if (isset($keyword))
	{
		$query .= ' AND (u.lastname LIKE \'%'.$babDB->db_escape_like($keyword).'%\' OR u.firstname LIKE \'%'.$babDB->db_escape_like($keyword).'%\')';
	}
	
	if (isset($departments))
	{
	    $query .= ' AND r.id_entity IN('.$babDB->quote($departments).')';
	}
	
	if ('0000-00-00' !== $dateb && '0000-00-00' !== $datee && false !== $dateb && false !== $datee) {
	    $subquery = 'SELECT id_user FROM absences_entries WHERE date_begin<'.$babDB->quote($datee.' 23:59:59').' AND date_end>'.$babDB->quote($dateb.' 00:00:00').' GROUP BY id_user';
	    $query .= ' AND u.id IN('.$subquery.')';
	}
	
	
	$query .= 'GROUP BY u.id ORDER BY u.lastname, u.firstname';
	
	$res = $babDB->db_query($query);
	
	return $res;
}


function absences_getSearchLimit($nbmonth)
{
    $initusers = (int) bab_rp('limit');
    if (empty($initusers)) {
        // preload the 30 first users if limit not set
        $initusers = 1 === $nbmonth ? 30 : 10;
    }
    
    return $initusers;
}

1			<?php
2			/************************************************************************
3			* OVIDENTIA http://www.ovidentia.org *
4			************************************************************************
5			* Copyright (c) 2003 by CANTICO ( http://www.cantico.fr ) *
6			* *
7			* This file is part of Ovidentia. *
8			* *
9			* Ovidentia 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 2, or (at your option) *
12			* any later version. *
13			* *
14			* This program is distributed in the hope that it will be useful, but *
15			* WITHOUT ANY WARRANTY; without even the implied warranty of *
16			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. *
17			* See the 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, write to the Free Software *
21			* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307,*
22			* USA. *
23			************************************************************************/
24
25
26			require_once dirname(__FILE__).'/vacincl.php';
27
28
29
30
31
32			/**
33			* Get period index from database
34			*
35			* @param int $id_user
36			* @param int $month
37			* @param int $year
38			* @param string $dateb ISO date
39			* @param string $datee ISO date
40			*
cantico / absences

Push — master ( 907983...ba4b0b )

absences_viewVacationCalendarCls::getnextuser() B

Complexity

Size

Duplication

Duplication Side-by-Side

Filter issues like
