cantico / absences

function absences_getPlanningValues($id)

{     

    require_once $GLOBALS['babInstallPath'].'admin/acl.php';

    global $babDB;

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

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

    $arr['groups'] = aclGetRightsString('absences_custom_planning_groups', $id);

    return $arr;

}

 * @param	int		$id_entry

 * @return string

 */

function absences_vacEntryQuantity($id_entry)

{

	global $babDB;

	$res = $babDB->db_query("

			SELECT

			SUM(e.quantity) quantity,

			r.quantity_unit

			FROM

			absences_entries_elem e,

			absences_rights r

			WHERE

			e.id_entry =".$babDB->quote($id_entry)."

			AND r.id = e.id_right

			GROUP BY r.quantity_unit

			ORDER BY r.quantity_unit DESC

			"

	);

	$list = array();

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

	{

		$list[] = absences_quantity($arr['quantity'], $arr['quantity_unit']);

	}

	return implode(', ', $list);

}