1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
| $Facts = Factures::where('DateFacture','>=',$request->Datef)->get();
if(count($Facts) > 0){
foreach($Facts as $F){
$FacturerHTVA=0;
$Facture = DB::table('Elements')
->rightjoin('Factures', 'Elements.IdFactureRef', '=', 'Factures.NumFacture')
->where('Factures.NumFacture','=',$F->NumFacture)
->select('Elements.*','Factures.*')
->get();
$cpt=0;
$Factures = array();
foreach($Facture as $element){
$FacturerHTVA += ($element->PrixElement * $element->Quantite);
$elem = array('NomElement' => $element->NomElement,'Description' => $element->Description,'Quantite'=> $element->Quantite , 'PrixElement'=> $element->PrixElement, 'cpt' => $cpt);
array_push($Factures,$elem);
$cpt++;
}
switch (strtoupper($Facture[0]->Pays)) {
case 'LUXEMBOURG':
$FacturerTVAC = round((floatval($FacturerHTVA) * 1.17), 2);
$Tva = round($FacturerHTVA * 0.17, 2);
break;
default :
if (trim($Facture[0]->NumTVAClient) == "" || trim($Facture[0]->NumTVAClient) == "NA" || trim($Facture[0]->NumTVAClient) == "na") {
$FacturerTVAC = round((floatval($FacturerHTVA) * 1.17), 2);
$Tva = round($FacturerHTVA * 0.17, 2);
} else {
$FacturerTVAC = $FacturerHTVA;
$Tva = 0;
}
}
$UneFacture = array (
"Facture" =>$Facture,
"FacturerHTVA" => $FacturerHTVA,
"FacturerTVAC" => $FacturerTVAC,
"Tva" => $Tva,
"Factures" => $Factures
);
array_push($ArrayFactures,$UneFacture);
}
$pdf = App::make('dompdf.wrapper');
$data =compact('ArrayFactures');
$pdf->loadView('pages/Allfacturepdf',$data);
return $pdf->stream('AllFacturesAfter'.$request->Datef.'pdf'); |
Partager