/**
* This is run before each unit test; it empties the database.
*/
protected function setUp()
{
GepiDataPopulator::depopulate($this->con);
mysqli_query($GLOBALS["mysqli"], 'delete from setting');
mysqli_query($GLOBALS["mysqli"], 'delete from droits');
mysqli_query($GLOBALS["mysqli"], 'delete from droits_aid');
mysqli_query($GLOBALS["mysqli"], 'delete from aid_productions');
mysqli_query($GLOBALS["mysqli"], 'delete from edt_setting');
mysqli_query($GLOBALS["mysqli"], 'delete from lettres_tcs');
mysqli_query($GLOBALS["mysqli"], 'delete from etiquettes_formats');
mysqli_query($GLOBALS["mysqli"], 'delete from lettres_types');
mysqli_query($GLOBALS["mysqli"], 'delete from lettres_cadres');
mysqli_query($GLOBALS["mysqli"], 'delete from ct_types_documents');
mysqli_query($GLOBALS["mysqli"], 'delete from absences_motifs');
mysqli_query($GLOBALS["mysqli"], 'delete from model_bulletin');
mysqli_query($GLOBALS["mysqli"], 'delete from absences_actions');
$fd = fopen(dirname(__FILE__) ."/../../../../sql/data_gepi.sql", "r");
if (!$fd) {
echo "Erreur : fichier sql/data_gepi.sql non trouve\n";
die;
}
while (!feof($fd)) {
$query = fgets($fd, 5000);
$query = trim($query);
if((substr($query,-1)==";")&&(substr($query,0,3)!="-- ")) {
$reg = mysqli_query($GLOBALS["mysqli"], $query);
if (!$reg) {
echo "ERROR : '$query' \n";
echo "Erreur retournée : ".mysqli_error($GLOBALS["mysqli"])."\n";
$result_ok = 'no';
}
}
}
fclose($fd);
loadSettings();
AbsenceEleveSaisiePeer::disableAgregation();
AbsenceEleveTraitementPeer::disableAgregation();
parent::setUp();
}
public function testDelete()
{
$florence_eleve = EleveQuery::create()->findOneByLogin('Florence Michu');
$florence_eleve->updateAbsenceAgregationTable();
AbsenceEleveSaisiePeer::enableAgregation();
AbsenceEleveTraitementPeer::enableAgregation();
$traitement = new AbsenceEleveTraitement();
$traitement->setAbsenceEleveType(AbsenceEleveTypeQuery::create()->filterByNom('Infirmerie')->findOne());
$traitement->save();
$traitement->addAbsenceEleveSaisie($florence_eleve->getAbsenceEleveSaisiesDuJour(VENDREDI_s40j5)->getFirst());
$traitement->save();
$decompte = AbsenceAgregationDecompteQuery::create()->filterByEleve($florence_eleve)->filterByDateDemiJounee(VENDREDI_s40j5)->findOne();
$this->assertFalse($decompte->getManquementObligationPresence());
$j_traitement_saisie = $traitement->getJTraitementSaisieEleves()->getFirst();
$j_traitement_saisie->delete();
$decompte->reload();
$this->assertTrue($decompte->getManquementObligationPresence());
AbsenceEleveTraitementPeer::disableAgregation();
AbsenceEleveSaisiePeer::disableAgregation();
}
public function testDelete()
{
$florence_eleve = EleveQuery::create()->findOneByLogin('Florence Michu');
$traitement = AbsenceEleveTraitementQuery::create()->useJTraitementSaisieEleveQuery()
->useAbsenceEleveSaisieQuery()->filterByDebutAbs(JEUDI_s42j4.' 08:00:00')
->endUse()->endUse()->findOne();
//on va vérifier que le delete change bien le update_ad
$old_updated_at = $traitement->getUpdatedAt('U');
$traitement->delete();
$traitement = AbsenceEleveTraitementQuery::create()->useJTraitementSaisieEleveQuery()
->useAbsenceEleveSaisieQuery()->filterByDebutAbs(JEUDI_s42j4.' 08:00:00')
->endUse()->endUse()->findOne();
$this->assertNull($traitement);
$traitement = AbsenceEleveTraitementQuery::create()->includeDeleted()->useJTraitementSaisieEleveQuery()
->useAbsenceEleveSaisieQuery()->filterByDebutAbs(JEUDI_s42j4.' 08:00:00')
->endUse()->endUse()->findOne();
$this->assertNotNull($traitement);
$traitement->unDelete();
AbsenceEleveTraitementPeer::enableAgregation();
$traitement->setAbsenceEleveType(AbsenceEleveTypeQuery::create()->filterByNom('Infirmerie')->findOne());
$traitement->save();
$decompte = AbsenceAgregationDecompteQuery::create()->filterByEleve($florence_eleve)->filterByDateDemiJounee(JEUDI_s42j4)->findOne();
$this->assertFalse($decompte->getManquementObligationPresence());
$traitement->delete();
$decompte->reload();
$this->assertTrue($decompte->getManquementObligationPresence());
AbsenceEleveTraitementPeer::disableAgregation();
}
