public static function getCategorieById($bdd, $id)
{
$req = $bdd->prepare("SELECT * FROM categorie_frais WHERE id = :id");
$req->execute(array(":id" => $id));
$cloneFrais = new CategorieFrais();
while ($array = $req->fetch()) {
$cloneFrais->setId($array['id']);
$cloneFrais->setName($array['name']);
}
return $cloneFrais;
}
?>
</div>
<div class="actions">
<button class="note-<?php echo $note['id'] ?> btn btn-danger">Supprimer</button>
<a class="btn btn-default" href="<?php echo $basePath. '?page=note&id=' . $note['id']; ?>">editer</a><br/>
<a href="<?php echo $basePath . "?page=impression&id=" . $note['id']; ?>" class="btn btn-success">Imprimer</a>
<button class="btn-show-frais btn btn-info" data-frais="list-frais-<?php echo $note['id'] ?>"><span class="glyphicon glyphicon-plus"></span> Frais (<span class="count-frais"><?php echo count($allFrais); ?></span>)</button>
</div>
</div>
<div class="list-frais list-frais-<?php echo $note['id'] ?>">
<ul>
<?php
//boucle des frais de la note
foreach ($allFrais as $frais) {
$categorie = CategorieFrais::getCategorieById($bdd, $frais['categorie_id']);
?>
<li class="frais-<?php echo $frais['id'] ?>">
<div class="infos-frais">
<img class="img-frais" src="<?php echo $basePath . 'image/uploads/' . $frais['image'] ?>"/>
<span><?php echo $frais['description'] ?></span>
</div>
<div class="total">
<?php
$fdevise = Devise::getDeviseById($bdd, $frais['devise_id']);
echo $frais['montant'] . ' ' . $fdevise->getSigne() . '<br/>';
echo '(<span class="total-frais">' . Devise::getValueOfChangedDevise($frais['montant'],$fdevise->getTaux(),$devise->getTaux()) . '</span> ' . $devise->getSigne() . ')';
?><br/>
<span><?php echo date("d-m-Y", strtotime($frais['date'])); ?></span><br/>
<span class="categorie-frais"><?php echo $categorie->getName(); ?></span>
</div>
break;
}
$result = Frais::deleteFraisById($bdd, $value);
$data = ["updated" => $result];
break;
default:
break;
}
}
} else {
if (isset($_GET) && !empty($_GET)) {
foreach ($_GET as $key => $value) {
switch ($key) {
case 'statistique':
//couts par categorie
$allCategorie = CategorieFrais::getAllCategorie($bdd);
$userDevise = Devise::getDeviseById($bdd, $sessionUser->getDevise())->getTaux();
//couts pour les 10 premiers utilisateurs
$userCouts = Note::getCoutOfUser($bdd);
//incrementation pour lesfrais par mois de l'année
$i = 1;
//couleur des categories
$color = 30;
foreach ($allCategorie as $categorie) {
$categorieCout = Frais::getCoutByCategorieId($bdd, $categorie["id"]);
$fdevise = Devise::getDeviseById($bdd, $categorieCout['devise_id'])->getTaux();
$data["categorie"]["labels"][] = $categorie["name"];
$data["categorie"]["cout"][] = Devise::getValueOfChangedDevise($categorieCout["totalCat"], $fdevise, $userDevise);
$data["categorie"]["all"][] = ["value" => Devise::getValueOfChangedDevise($categorieCout["totalCat"], $fdevise, $userDevise), "color" => "rgb(" . $color . ", " . $color * 2 . ", " . $color / 2 . ")", "highlight" => "rgb(" . ($color + 15) . ", " . ($color * 2 + 15) . ", " . ($color + 15) . ")", "label" => $categorie["name"]];
$color += 30;
}
$CloneDevise = Devise::getDeviseById($bdd, $sessionUser->getDevise());
//Ecrit le nom et le login de l'utilisateur ainsi que sa devise
$nomUtilisateur = str_replace(" ", "", $sessionUser->getName());
$objPHPExcel->getActiveSheet()->setCellValue('B8', $nomUtilisateur);
$objPHPExcel->getActiveSheet()->setCellValue('F8', $sessionUser->getLogin());
$objPHPExcel->getActiveSheet()->setCellValue('J8', $CloneDevise->getName());
$datePremierFrais;
$dateDernierFrais;
$totalAvance = 0;
$totalCase = 0;
$totalTTC = 0;
$baseRow = 16;
//On boucle pour afficher les informations de chaques frais de la note dans le tableau excel
foreach ($allFraisFromThisNote as $r => $fraisFromNote) {
$row = $baseRow + $r;
$CategorieName = CategorieFrais::getCategorieById($bdd, $fraisFromNote['categorie_id']);
$objPHPExcel->getActiveSheet()->insertNewRowBefore($row, 1);
//Affiche dans la bonne devise
$deviseFrais = Devise::getDeviseById($bdd, $fraisFromNote['devise_id']);
$montantDeviseUser = Devise::getValueOfChangedDevise($fraisFromNote['montant'], $deviseFrais->getTaux(), $CloneDevise->getTaux());
//Verifie si on a une avance
if ($fraisFromNote['categorie_id'] == 4) {
$totalAvance += $montantDeviseUser;
$tva = $montantDeviseUser;
$totalTTC -= $montantDeviseUser;
} else {
$tva = $montantDeviseUser * 1.2;
$totalTTC += $tva;
}
$objPHPExcel->getActiveSheet()->setCellValue('A' . $row, $fraisFromNote['id'])->setCellValue('B' . $row, $fraisFromNote['date'])->setCellValue('C' . $row, $fraisFromNote['description'])->setCellValue('E' . $row, $montantDeviseUser)->setCellValue('F' . $row, $tva)->setCellValue('H' . $row, $CategorieName->getName());
$dateFrais = $fraisFromNote['date'];
} ?>
</select>
</div>
<select class = "formulaire deroulantFrais form-control champ-form deroulantId" name="note_id">
<?php
$uid = $sessionUser->getId();
foreach ( (Note::getNotesByUser($bdd, $uid)) as $donnee ) {
if ( 1 != $donnee['statut_id'] )
{ continue; } ?>
<option value="<?php echo $donnee['id'];?>" <?php if(isset($_POST[$noteid]) && !empty($_POST[$noteid]) && filter_input(INPUT_POST, $noteid) == $donnee['id'])
{echo "selected.='selected'";} ?>><?php echo $donnee['name'];?></option>
<?php } ?>
</select>
<select class = "formulaire deroulantFrais form-control champ-form deroulantId" name="categorie_id">
<?php
$reponseCategorie = CategorieFrais::getAllCategorie($bdd);
while($donnee = $reponseCategorie->fetch())
{
?>
<option value ="<?php echo $donnee['id'];?>" <?php if(isset($_POST[$categori]) && !empty($_POST[$categori]) && filter_input(INPUT_POST, $categori) == $donnee['id']){echo "selected='selected'"; } ?>><?php echo $donnee['name'];?></option>
<?php
}
$reponseCategorie->closeCursor();
?>
</select>
<br>
<input class="btn btn-primary" type="submit" value="Valider" name = "valider"/>
</p>
</form>
