1 <?php
2
3 namespace PLus\Orders\Repositories\Order;
4
5
6 /**
7 * Description of TimelineRepository
8 *
9 * @author Petr
10 */
11 class TimelineRepository extends \PLus\Orders\Repositories\Repository {
12
13
14 /**
15 *
16 * @param type $id
17 * @return type
18 * vraci casove udalosti prislusne objednavky
19 */
20 function getTimelineRecords($id) {
21 return $this->getTable()
22 ->select('timeline.created, event.name, timeline.event_id, CASE WHEN user.isunit=1 THEN user:unit_user.unit.name '
23 . 'ELSE CONCAT_WS(\' \',user.firstname, user.lastname) END AS jname')
24 ->where('timeline.order_id', $id);
25 //->order('timeline.created ASC');
26 }
27
28 }
29