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); }