src/Service/Statistiques/StatsService.php line 97

Open in your IDE?
  1. <?php
  3. namespace App\Service\Statistiques;
  5. use Doctrine\ORM\EntityManager;
  6. use Doctrine\ORM\EntityManagerInterface;
  7. use Symfony\Component\DependencyInjection\Container;
  8. use App\Entity\GestionComerciale\Commande;
  9. use App\Entity\GestionComerciale\ArticleCommande;
  10. use App\Entity\Articles\MouvementStock;
  12. use Symfony\Component\Form\FormError;
  13. use Symfony\Component\Validator\ExecutionContext;
  15. class StatsService {
  17.     private $em;
  19.     public function __construct(EntityManagerInterface $em)
  20.     {
  21.         $this->em = $em;
  22.     }
  23.     
  24.     public function calculCaPeriode($type,$periode,$integreBl=false,$n1=false) {
  25.         //echo "[".$type["libelle"]."] :".$periode;
  26.         
  27.         $repo_commande = $this->em->getRepository(Commande::class);
  28.         
  29.         $totalCa = $repo_commande->calculCaPeriode($type,$periode,$integreBl,$n1);
  30.         return round($totalCa,2);
  31.     }
  32.     
  33.       
  34.         
  35.     public function getTopClientn1Details($parametres = [], $article_id, $transporteur_id) {
  36.         
  37.         
  38.         $parametres["details_ajax"]=1;
  39.         $parametres["n1"]=0;
  40.         
  41.         
  42.         $retour = ["total" =>"", "total_qte" =>""];
  43.         
  44.         $parametres["client"]=$parametres["client_id"];
  45.         $parametres["article"]=$article_id;
  46.         
  47.         
  48.         $dateDebutN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_debut']);
  49.         $dateDebutN1->setTime(00,00,00);
  50.         $dateDebutN1->modify('-1 year');
  51.         $parametres["date_debut"]=$dateDebutN1->format("d/m/Y");
  52.         
  53.         
  54.         $dateFinN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_fin']);
  55.         $dateFinN1->setTime(23,59,59);
  56.         $dateFinN1->modify('-1 year');        
  57.         $parametres["date_fin"]=$dateFinN1->format("d/m/Y");
  58.         
  59.         $repoCommande = $this->em->getRepository(Commande::class);
  60.         
  61.         if($transporteur_id != "") {
  62.             $parametres_transport = $parametres;
  63.             $parametres_transport["transporteur_id"]=$transporteur_id;        
  64.             $transport =  $repoCommande->topClientsDetailsTransport($parametres_transport);    
  65.             
  66.                     
  67.             if(is_array($transport) && count($transport)==1) {
  68.                 $retour["total"] = $transport[0]["total"];
  69.                 $retour["total_qte"] = $transport[0]["total_qte"];
  70.                 //return $client[0]["total"];
  71.             }
  72.                     
  73.         }
  74.         else {
  75.             $article =  $repoCommande->topClientsDetails($parametres);        
  76.             
  77.             /*
  78.             if($article_id == 213111) {
  79.                 echo "<br></br>";
  80.                 print_r($parametres);
  81.                 echo "<br></br>";
  82.                 print_r($article);
  83.                 exit;
  84.             }
  85.             */
  86.             
  87.             if(is_array($article) && count($article)==1) {
  88.                 $retour["total"] = $article[0]["total"];
  89.                 $retour["total_qte"] = $article[0]["total_qte"];
  90.                 //return $client[0]["total"];
  91.             }            
  92.         }
  94.         return $retour;
  95.     }
  96.     
  97.     public function getTopClientn1($parametres = [], $client_id) {
  98.         
  99.         $retour = ["total" =>"", "qte" =>""];
  100.         
  101.         $parametres["client"]=$client_id;
  102.         
  103.         $dateDebutN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_debut']);
  104.         $dateDebutN1->setTime(00,00,00);
  105.         $dateDebutN1->modify('-1 year');
  106.         $parametres["date_debut"]=$dateDebutN1->format("d/m/Y");
  107.         
  108.         
  109.         $dateFinN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_fin']);
  110.         $dateFinN1->setTime(23,59,59);
  111.         $dateFinN1->modify('-1 year');        
  112.         $parametres["date_fin"]=$dateFinN1->format("d/m/Y");
  113.         
  114.         $repoCommande = $this->em->getRepository(Commande::class);
  115.         $client = [];
  116.         $client =  $repoCommande->topClients($parametres);
  117.         
  118.         //print_r($client);
  119.         
  120.         if(is_array($client) && count($client)==1) {
  121.             $retour["total"] = $client[0]["total"];
  122.             $retour["qte"] = $client[0]["qte"];
  123.             //return $client[0]["total"];
  124.         }
  125.         
  126.         return $retour;
  127.     }
  128.     
  129.     
  130.     public function getTopArticlen1($parametres = [], $article_id) {
  131.         
  132.         $retour = ["total" =>"", "total_quantite" =>""];
  133.         
  134.         $parametres["article"]=$article_id;
  135.         
  136.         $dateDebutN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_debut']);
  137.         $dateDebutN1->setTime(00,00,00);
  138.         $dateDebutN1->modify('-1 year');
  139.         $parametres["date_debut"]=$dateDebutN1->format("d/m/Y");
  140.         
  141.         
  142.         $dateFinN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_fin']);
  143.         $dateFinN1->setTime(23,59,59);
  144.         $dateFinN1->modify('-1 year');        
  145.         $parametres["date_fin"]=$dateFinN1->format("d/m/Y");
  146.         
  147.         $repoCommande = $this->em->getRepository(Commande::class);
  148.         
  149.         $article =  $repoCommande->topArticles($parametres);
  150.         
  151.         //print_r($article);
  152.         /*
  153.            total total_quantite 
  154.          */
  155.         
  156.         if(is_array($article) && count($article)==1) {
  157.             $retour["total"] = $article[0]["total"];
  158.             $retour["total_quantite"] = $article[0]["total_quantite"];
  159.             //return $client[0]["total"];
  160.         }
  161.         
  162.         return $retour;
  163.         
  164.     }  
  165.     
  166.       public function getTopMarquen1Details($parametres = [], $article_id) {
  167.                           
  168.         $parametres["details_ajax"]=1;
  169.         $parametres["n1"]=0;                
  170.         $retour = ["total" =>"", "total_qte" =>""];
  171.         
  172.         $parametres["marque"]=$parametres["marque_id"];
  173.         $parametres["article"]=$article_id;
  174.         
  175.         
  176.         $dateDebutN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_debut']);
  177.         $dateDebutN1->setTime(00,00,00);
  178.         $dateDebutN1->modify('-1 year');
  179.         $parametres["date_debut"]=$dateDebutN1->format("d/m/Y");
  180.         
  181.         
  182.         $dateFinN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_fin']);
  183.         $dateFinN1->setTime(23,59,59);
  184.         $dateFinN1->modify('-1 year');        
  185.         $parametres["date_fin"]=$dateFinN1->format("d/m/Y");
  186.         
  187.         $repoCommande = $this->em->getRepository(Commande::class);
  188.         $article =  $repoCommande->topMarquesDetails($parametres);        
  190.         if(is_array($article) && count($article)==1) {
  191.             $retour["total"] = $article[0]["total"];
  192.             $retour["total_qte"] = $article[0]["total_qte"];
  193.             //return $client[0]["total"];
  194.         }            
  195.         
  196.         return $retour;
  197.     }
  198.     
  199.     
  200.     
  201.     
  202.     
  203.     public function getTopMarquen1($parametres = [], $marque_id) {
  204.         
  205.         $retour = ["total" =>"", "total_quantite" =>""];
  206.         
  207.         $parametres["marque"]=$marque_id;
  208.         
  209.         $dateDebutN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_debut']);
  210.         $dateDebutN1->setTime(00,00,00);
  211.         $dateDebutN1->modify('-1 year');
  212.         $parametres["date_debut"]=$dateDebutN1->format("d/m/Y");
  213.         
  214.         
  215.         $dateFinN1 = \DateTime::createFromFormat('d/m/Y',$parametres['date_fin']);
  216.         $dateFinN1->setTime(23,59,59);
  217.         $dateFinN1->modify('-1 year');        
  218.         $parametres["date_fin"]=$dateFinN1->format("d/m/Y");
  219.         
  220.         $repoCommande = $this->em->getRepository(Commande::class);
  221.         
  222.         $article =  $repoCommande->topMarques($parametres);
  223.         
  224.         //print_r($article);
  225.         /*
  226.            total total_quantite 
  227.          */
  228.         
  229.         if(is_array($article) && count($article)==1) {
  230.             $retour["total"] = $article[0]["total"];
  231.             $retour["total_quantite"] = $article[0]["total_quantite"];
  232.             //return $client[0]["total"];
  233.         }
  234.         
  235.         return $retour;
  236.         
  237.     }  
  238.     
  239.     
  240.     /*public function estRembourse(Commande $avoir) {
  241.          $repo_acompte = $this->em->getRepository('DTCGestionComercialeBundle:Acompte');
  242.          $acompteAvoir = $repo_acompte->findBy(array("commande"=>$avoir->getId()));
  243.                  $montantrembourse = 0;
  244.         foreach($acompteAvoir as $acompte){
  245.                     $montantrembourse += $acompte->getMontant();
  246.                     
  247.                     
  248.                 }
  249.                 $acompteAvoir = $repo_acompte->findBy(array("commande"=>$avoir->getCommande()->getId()));
  250.                 foreach( $acompteAvoir as $acompte){
  251.                     $montantrembourse += $acompte->getMontant();
  252.                     
  253.                     
  254.                 }
  255.                 
  256.                
  257.                 
  258.                 if($montantrembourse <= $avoir->getTotalTtc()){
  259.                      
  260.                      return true;
  261.                 }else{
  262.                     
  263.                 return false;
  264.                 }
  265.          
  266.     }
  267.     */
  268.   
  269.     
  270. }