Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. $query->where('ec.codeModePrelevement IN (:cbMode)')
  2. ->setParameter('cbMode', $modes)
  3.  
  4. ->andWhere('ec.idStatusPaiement = :status')
  5. ->setParameter('status', EcheancesStatut::__EN_ATTENTE_PAIEMENT__)
  6.  
  7.  
  8. ->andWhere($query->expr()->eq('ec.idProduit',1))
  9. ->andWhere('ec.idProduit = :idProduit')
  10. ->setParameter('idProduit', 1 )
  11. ;
  12.  
  13. $modes = array('VM','VMMANO');
  14. $query->where('ec.codeModePrelevement IN (:cbMode)')
  15. ->setParameter('cbMode', $modes)
  16.  
  17. ->andWhere('ec.idStatusPaiement = :status')
  18. ->setParameter('status', EcheancesStatut::__EN_ATTENTE_PAIEMENT__)
  19.  
  20. /*->andWhere('ec.idProduit = :idProduit')
  21. ->setParameter('idProduit', 1 )*/
  22. ;
  23.  
  24. $query/*->where('ec.codeModePrelevement IN (:cbMode)')
  25. ->setParameter('cbMode', $modes)*/
  26.  
  27. ->where('ec.idStatusPaiement = :status')
  28. ->setParameter('status', EcheancesStatut::__EN_ATTENTE_PAIEMENT__)
  29.  
  30. ->andWhere('ec.idProduit = :idProduit')
  31. ->setParameter('idProduit', 1 )
  32. ;
  33.  
  34. $query->where('ec.codeModePrelevement IN (:cbMode)')
  35. ->setParameter('cbMode', $modes)
  36.  
  37. /*->where('ec.idStatusPaiement = :status')
  38. ->setParameter('status', EcheancesStatut::__EN_ATTENTE_PAIEMENT__)*/
  39.  
  40. ->andWhere('ec.idProduit = :idProduit')
  41. ->setParameter('idProduit', 1 )
  42. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement