Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. // build query to get their order details
  2. $orderEntity = $em->createQueryBuilder()
  3. ->select('oh.orderHeaderId','oh.orderDate', 'oh.orderTotal', 'od.createdDate', 'od.productName', 'od.flashSalePrice', 'od.itemQuantity')
  4. ->from('FLOEcommerceBundle:OrderHeader','oh')
  5. ->leftJoin('FLOEcommerceBundle:OrderDetail', 'od' ,'WITH', 'oh.orderHeaderId = od.orderHeaderId')
  6. ->where('oh.memberId = ?1')
  7. ->orderby('oh.orderDate' , 'desc')
  8. ->setParameter(1, $memberId)
  9. ->getQuery()
  10. ->getArrayResult();
  11.  
  12. array:3 [▼
  13. 0 => array:7 [▼
  14. "orderHeaderId" => 25
  15. "orderDate" => DateTime {#3906 ▼
  16. +"date": "2015-07-15 11:27:59.000000"
  17. +"timezone_type": 3
  18. +"timezone": "America/Tegucigalpa"
  19. }
  20. "orderTotal" => "33.9600"
  21. "createdDate" => DateTime {#3904 ▼
  22. +"date": "2015-07-15 11:28:00.000000"
  23. +"timezone_type": 3
  24. +"timezone": "America/Tegucigalpa"
  25. }
  26. "productName" => "Plain Skirt"
  27. "flashSalePrice" => "10.9900"
  28. "itemQuantity" => 1
  29. ]
  30.  
  31. foreach ( $orderEntity as $items ) {
  32.  
  33.  
  34.  
  35. foreach ( $items as $key => $value ) {
  36.  
  37. if( 'orderHeaderId' == $key) {
  38.  
  39.  
  40. $orders .= ' OrderId: ' . $value . $br;
  41.  
  42. }
  43. }
  44.  
  45.  
  46. foreach ( $items as $key => $value ) {
  47.  
  48. if( 'orderDate' == $key ) {
  49.  
  50.  
  51.  
  52.  
  53.  
  54.  
  55. $orders .= ' OrderDate: ' . $value . $br;
  56.  
  57. }
  58.  
  59. }
  60.  
  61. }
  62.  
  63. /**
  64. * @return DateTime
  65. */
  66. public function getcreatedDate()
  67. {
  68. $returnValue = $this->createdDate->format('y:m:d') //You can change it to your needed format.
  69. return $returnValue
  70. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement