cantico / absences

		$types = array();

		$organization = '';

		if(isset($this->filter['organization']) && $this->filter['organization']){

			$organization = 'AND p.id_organization='.$babDB->quote($this->filter['organization']);

		}

		$res = $babDB->db_query('

			SELECT

				$where[] = 'YEAR(e.date_begin)='.$babDB->quote($this->year);

			}

			if (isset($this->organization) && $this->organization)

			{

				$req .= ', absences_personnel p';

				$where[] = 'e.id_user=p.id_user';

				$where[] = 'p.id_organization='.$babDB->quote($this->organization);

			}

			if (isset($this->archived))

			{