Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.17 KB | None | 0 0
  1. $this->Purchase->find('all',array(
  2. 'order' => array('Purchase.date_generated ASC'),
  3. 'fields' => array('DISTINCT Purchase.date_generated')));
  4.  
  5. Array
  6. (
  7. [0] => Array
  8. (
  9. [Invoice] => Array
  10. (
  11. [date_generated] => 1970-01-01
  12. )
  13.  
  14. )
  15.  
  16. [1] => Array
  17. (
  18. [Invoice] => Array
  19. (
  20. [date_generated] => 2014-06-17
  21. )
  22.  
  23. )
  24.  
  25. [2] => Array
  26. (
  27. [Invoice] => Array
  28. (
  29. [date_generated] => 2014-06-18
  30. )
  31.  
  32. )
  33.  
  34. [3] => Array
  35. (
  36. [Invoice] => Array
  37. (
  38. [date_generated] => 2014-06-19
  39. )
  40.  
  41. )
  42.  
  43. [4] => Array
  44. (
  45. [Invoice] => Array
  46. (
  47. [date_generated] => 2014-06-22
  48. )
  49.  
  50. )
  51.  
  52. [5] => Array
  53. (
  54. [Invoice] => Array
  55. (
  56. [date_generated] => 2014-06-29
  57. )
  58.  
  59. )
  60.  
  61. [6] => Array
  62. (
  63. [Invoice] => Array
  64. (
  65. [date_generated] => 2014-08-01
  66. )
  67.  
  68. )
  69.  
  70. )
  71.  
  72. $this->Purchase->find('all',array(
  73. 'order' => array('Purchase.date_generated ASC'),
  74. 'fields' => array('DISTINCT Purchase.date_generated','Purchase.id')));
  75.  
  76. Array
  77. (
  78. [0] => Array
  79. (
  80. [Purchase] => Array
  81. (
  82. [date_generated] => 1970-01-01
  83. [id] => 9
  84. )
  85.  
  86. )
  87.  
  88. [1] => Array
  89. (
  90. [Purchase] => Array
  91. (
  92. [date_generated] => 2014-06-17
  93. [id] => 1
  94. )
  95.  
  96. )
  97.  
  98. [2] => Array
  99. (
  100. [Purchase] => Array
  101. (
  102. [date_generated] => 2014-06-18
  103. [id] => 2
  104. )
  105.  
  106. )
  107.  
  108. [3] => Array
  109. (
  110. [Purchase] => Array
  111. (
  112. [date_generated] => 2014-06-19
  113. [id] => 3
  114. )
  115.  
  116. )
  117.  
  118. [4] => Array
  119. (
  120. [Purchase] => Array
  121. (
  122. [date_generated] => 2014-06-22
  123. [id] => 4
  124. )
  125.  
  126. )
  127.  
  128. [5] => Array
  129. (
  130. [Purchase] => Array
  131. (
  132. [date_generated] => 2014-06-29
  133. [id] => 5
  134. )
  135.  
  136. )
  137.  
  138. [6] => Array
  139. (
  140. [Purchase] => Array
  141. (
  142. [date_generated] => 2014-06-29
  143. [id] => 6
  144. )
  145.  
  146. )
  147.  
  148. [7] => Array
  149. (
  150. [Purchase] => Array
  151. (
  152. [date_generated] => 2014-06-29
  153. [id] => 7
  154. )
  155.  
  156. )
  157.  
  158. [8] => Array
  159. (
  160. [Purchase] => Array
  161. (
  162. [date_generated] => 2014-08-01
  163. [id] => 8
  164. )
  165.  
  166. )
  167.  
  168. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement