src/Controller/SuiviFacturationController.php line 39

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  4. use App\Entity\Projects;
  5. use App\Entity\ProjectFacturation;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Symfony\Component\HttpFoundation\Response;
  9. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  10. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  11. use Symfony\Component\Translation\TranslatorInterface;
  12. use Doctrine\ORM\EntityManagerInterface;
  13. use Symfony\Component\HttpFoundation\Session\Session;
  14. use Symfony\Component\HttpFoundation\RequestStack;
  15. use App\Service\ServiceTeaminfo;
  16. use Symfony\Component\HttpFoundation\JsonResponse;
  17. use Symfony\Component\HttpFoundation\StreamedResponse;
  18. use Symfony\Component\Filesystem\Filesystem;
  21. class SuiviFacturationController extends Controller
  22. {    
  23.     private $ServiceTeaminfo;
  24.     private $entityManager;
  25.     
  26.     
  27.     public function __construct(ServiceTeaminfo $ServiceTeaminfo,EntityManagerInterface $entityManager){
  28.         $this->ServiceTeaminfo = $ServiceTeaminfo;
  29.         $this->entityManager = $entityManager;
  30.     }
  31.     
  32.     
  33.     
  34.     
  35.     public function index($id, Request $request, TokenStorageInterface $tokenStorage, TranslatorInterface $translator )
  36.     {        
  37.         $projets = $this->getDoctrine()->getRepository(Projects::class)->findOneBy(["id"=>$id]);
  38.         $id_client = $projets->getClient()->getId();
  39.         $checkClientAccess = $this->ServiceTeaminfo->checkClientAccess($id_client);
  40.         
  41.         if ( $checkClientAccess == "home" )         return $this->redirectToRoute('home');
  42.         
  43.         $projet_facturation = $this->getDoctrine()->getRepository(ProjectFacturation::class)->findBy(["project"=>$projets]);
  44.         
  45.         return $this->render('projects/suivi_facturation/index.html.twig', [
  46.             'add_js_files' =>"suivi_facturation_js",
  47.             'projet_facturation' =>$projet_facturation,
  48.             'projets' =>$projets,
  49.             'titre_page' =>"Suivi de facturation",
  50.             'uniqid' => uniqid(),
  51.         ]);
  52.     }
  57.     public function add_edit_facturation_projet_ajax(Request $request)
  58.     {
  59.         $dateReglement = $request->get("DateReglement");
  60.         $dateFacturation = $request->get("DateFacturation");
  61.         
  62.         $montantRegle = 0;
  63.         if( $request->get("MontantRegle") != "" )$montantRegle = $request->get("MontantRegle");
  64.         
  65.         $montantFacture = $request->get("MontantFacture");
  66.         $designation = $request->get("Designation");
  67.         $id = $request->get("id");
  68.         $id_projet = $request->get("id_projet");
  69.         
  70.         if($id != null and $id != ""){
  71.             $edit = true;
  72.             $projet_facturation = $this->getDoctrine()->getRepository(ProjectFacturation::class)->findOneBy(["id"=>$id]);
  73.         }else{
  74.             $edit = false;
  75.             $projet_facturation = new ProjectFacturation();
  76.             $projet = $this->getDoctrine()->getRepository(Projects::class)->findOneBy(["id"=>$id_projet]);
  77.             $projet_facturation->setProject($projet);
  78.         }
  79.         
  80.         $projet_facturation->setDesignation($designation);
  81.         
  82.         $date_dateFacturation = new \DateTime(str_replace("/","-",$dateFacturation));
  83.         $date_dateFacturation->setTimezone(new \DateTimeZone("Europe/Paris"));
  84.         $date_dateFacturation->format("Y-m-d");
  85.         $projet_facturation->setDateFacturation($date_dateFacturation);
  86.         
  87.         $projet_facturation->setMontantFacture($montantFacture);
  88.         $projet_facturation->setMontantRegle($montantRegle);
  89.         
  90.         if($dateReglement){
  91.             $date_dateReglement = new \DateTime(str_replace("/","-",$dateReglement));
  92.             $date_dateReglement->setTimezone(new \DateTimeZone("Europe/Paris"));
  93.             $date_dateReglement->format("Y-m-d");
  94.             $projet_facturation->setDateReglement($date_dateReglement);
  95.         }
  96.         
  97.         $this->entityManager->persist($projet_facturation);
  98.         $this->entityManager->flush();
  99.         $newId = $projet_facturation->getId();
  100.         
  101.         $response =  new Response(json_encode(array($newId,$edit)));
  102.         $response->headers->set('Content-Type', 'application/json');
  104.         return $response;
  105.     }
  111.     
  112.     public function deleted_facturation_projet_ajax(Request $request)
  113.     {
  114.         $ids = $request->get("ids");
  115.         $type = $request->get("type");
  116.         
  117.         $img_templat = $this->renderView('projects/suivi_facturation/icone_image_template.html.twig', array(    
  118.             'input_document_template' => "input_document_template",
  119.         ));
  120.         
  121.         $status = array('status' => "success","img_templat" => $img_templat);
  122.         $response = new JsonResponse($status);
  123.         
  124.         if($ids != ""){
  125.             if($type != "item"){
  126.                 $projet_facturation = $this->getDoctrine()->getRepository(ProjectFacturation::class)->findOneBy(["id"=>$ids]);
  127.                 $projet_facturation->setDocumentPath(null);
  128.                 $this->entityManager->flush();
  129.             }else{
  130.                 foreach($ids as $id){
  131.                     $projet_facturation = $this->getDoctrine()->getRepository(ProjectFacturation::class)->findOneBy(["id"=>$id]);
  132.                     $this->entityManager->remove($projet_facturation);
  133.                     $this->entityManager->flush();
  134.                 }
  135.                 
  136.                 $response = new Response("deleted");
  137.             }
  138.         }
  139.         
  140.         return $response;
  141.     }
  142.     
  143.     
  144.     
  145.     
  146.     public function upload_facturation_projet_ajax(Request $request)
  147.     {    
  148.         if($request->get("id") == "")
  149.             $id = "";
  150.         else
  151.             $id = $request->get("id");
  152.         
  153.         $files = $request->files->get('file');
  154.         
  155.     
  156.         $num = $request->get("num");
  157.         $type_file = $request->get("type_file");
  158.         $uniqid = $request->get("uniqid");
  159.         $data_file = $request->get("data_file");
  160.         $validite = $request->get("validite");
  161.         
  162.         if($files){
  163.             $originalFileName = $files->getClientOriginalName();
  164.             $extension_file = $this->ServiceTeaminfo->get_extension_file($originalFileName);
  165.             $type_img = $this->ServiceTeaminfo->getIconFile($extension_file);
  166.         }
  167.         
  168.         if($validite == "false"){
  169.             $data = $this->ServiceTeaminfo->decode_img_base64($data_file);
  170.             $extension_file = $this->ServiceTeaminfo->get_extension_file($files->getClientOriginalName());
  172.             $response = $this->renderView('projects/suivi_facturation/icone_image_template.html.twig', [
  173.                 'id' =>$id,
  174.                 'path'=>$data_file,
  175.                 'upload'=>true,
  176.                 'extension'=>$type_img,
  177.                 "file_name"=>$uniqid."_".$num,
  178.                 "extension_file"=>$extension_file,
  179.                 "upload_not_save"=>"true",                
  180.             ]);
  181.         }
  182.         
  183.         if( $id != "" and $id!= null){
  184.             if($request->get("data_save") == "false" ){
  185.                 $extension_file = $type_file;
  186.                 
  187.                 if( $type_file == "pdf")
  188.                     $data = $this->ServiceTeaminfo->decode_PDF_base64($data_file);                    
  189.                 else    
  190.                     $data = $this->ServiceTeaminfo->decode_img_base64($data_file,$extension_file);
  191.                 
  192.                 $files = null;
  193.             }else{
  194.                 $extension_file = null;
  195.                 $data = null;
  196.                 $files = $files;                
  197.             }
  198.             
  199.             $path = $this->ServiceTeaminfo->upload_image($data,$files,false,false,[true,false],$extension_file);
  201.             $file_name = $this->ServiceTeaminfo->get_name_file($path);
  202.             $extension_file =  $this->ServiceTeaminfo->get_extension_file($path);
  203.             
  204.             if($request->get("data_save") != "false" and $validite != "false"){
  205.                 $response = $this->renderView('projects/suivi_facturation/icone_image_template.html.twig', [
  206.                     'id' =>$id,
  207.                     'path'=>$path,
  208.                     'upload'=>true,
  209.                     'extension'=>$type_img,
  210.                     "file_name"=>$file_name,
  211.                     "extension_file"=>$extension_file,
  212.                 ]);
  213.             }else{
  214.                 $response = 200;
  215.             }
  216.             
  217.             $projet_facturation = $this->getDoctrine()->getRepository(ProjectFacturation::class)->findOneBy(["id"=>$id]);
  219.             $projet_facturation->setDocumentPath($path);
  220.             $this->entityManager->persist($projet_facturation);
  221.             $this->entityManager->flush();
  222.         }
  223.         
  224.         return new Response($response);
  225.     }
  228.     public function exportFacture(Request $request)
  229.     {
  230.         if($request->get("ids")!=[]){
  231.             $projet_facturation = $this->getDoctrine()->getRepository(ProjectFacturation::class)->findBy(["id"=>  $request->get("ids")]);
  232.         }
  233.         else{
  234.             $projet_facturation = $this->getDoctrine()->getRepository(ProjectFacturation::class)->findBy(["project"=> $request->get("id_projet")]);
  236.           }
  237.         
  238.         $file_name = uniqid("tmp/Facture_export_").".csv";
  239.         $handle = fopen($file_name, 'w');
  240.         fwrite($handle, chr(0xEF) . chr(0xBB) . chr(0xBF));
  242.         fputcsv($handle, [
  243.             "Désignation",
  244.             "Document",
  245.             "Date de facture",
  246.             "Montant facturé",
  247.             "Montant réglé  ",
  248.             "Date de réglement",
  249.         ], ';');
  251.         
  252.         foreach ($projet_facturation as $project) {
  253.             
  254.             fputcsv($handle, [
  255.                 $project->getDesignation(),
  256.                 ($project->getDocumentPath() !== null) ? $request->getSchemeAndHttpHost() . $project->getDocumentPath() : '',
  257.                 $project->getDateFacturation()->format('Y-m-d'),
  258.                 $project->getMontantFacture()." €",
  259.                 $project->getMontantRegle()." €",
  260.                 $project->getDateReglement()->format('Y-m-d'),
  261.                 
  262.             
  263.             ], ';');
  264.         }
  266.         fclose($handle);
  267.         $filePath = "/".$file_name;
  269.         return new JsonResponse(["path" => $filePath]);
  270.     }
  273. }