function findLastDate($annee)
{
$t = new Activites();
$db = $t->getAdapter();
$s = $t->select()->from('activite', array('activite.fin'))->join('participation', 'participation.activite = activite.id' . ' AND ' . $db->quoteInto('participation.unite = ?', $this->id), array())->order('activite.fin DESC')->limit(1);
if ($annee) {
$s->where('? < activite.fin', Strass_Controller_Action_Helper_Annee::dateDebut($annee))->where('activite.fin < ?', strftime('%Y-%m-%d', strtotime(Strass_Controller_Action_Helper_Annee::dateFin($annee) . ' -5 weeks')));
}
return $s->query()->fetchColumn();
}
function findActivites($annee = null)
{
$t = new Activites();
$db = $t->getAdapter();
$s = $t->select()->setIntegrityCheck(false)->distinct()->from('activite')->join('participation', 'participation.activite = activite.id', array())->join('unite', 'unite.id = participation.unite', array())->join('appartenance', $db->quoteInto("appartenance.individu = ?", $this->id) . " AND " . "appartenance.unite = unite.id", array())->order('activite.debut DESC');
if ($annee) {
$s->where("activite.debut >= ?", Strass_Controller_Action_Helper_Annee::dateDebut($annee));
$s->where("activite.fin <= ?", Strass_Controller_Action_Helper_Annee::dabteFin($annee));
}
return $t->fetchAll($s);
}
