cantico / absences

    $url->location();

}

function absences_getPlanningName($id)

{

    global $babDB;

    $res = $babDB->db_query("SELECT name FROM absences_custom_planning WHERE id=".$babDB->quote($id));

    $arr = $babDB->db_fetch_assoc($res);

    return $arr['name'];

}

function absences_getPlanningUsers($id)

{

	 * this method must not modify the organizations ID

	 * 

	 */

	public static function createFromDirectory()

	{

	    global $babDB;

	    $res = $babDB->db_query("

	        SELECT 

	           e.organisationname name, 

	           o.id 

	        FROM bab_dbdir_entries e

	               LEFT JOIN absences_organization o ON o.name LIKE e.organisationname, 

	           absences_personnel p 

	        WHERE e.id_user=p.id_user 

	           AND e.organisationname<>'' 

	        GROUP BY organisationname

	    ");

	    while ($arr = $babDB->db_fetch_assoc($res)) {

	        $org = new absences_Organization();

	        $org->setRow($arr);

	        $org->save();

	    }

	}

}