1 <?php
 2 
 3 namespace PLus\Orders\Repositories\Entities;
 4 
 5 
 6 /**
 7  * Description of UnitRepository
 8  *
 9  * @author Petr
10  */
11 class UnitRepository extends \PLus\Orders\Repositories\Repository {
12     
13     /**
14      * 
15      * @return type
16      * vraci parove data (pro select nabidky
17      */
18     function getPairData(){
19     return $this->getTable()->select('id, name')->order('name ASC')->fetchPairs('id', 'name');
20     }
21     
22     /**
23      * 
24      * @return type
25      * vraci $selection pro datagrid
26      */
27     function getGridSelection(){
28     return $this->getTable()
29             ->select('unit.*,  department.name AS dname');
30     }
31     
32     /**
33      * 
34      * @param type $id
35      * @return type
36      * vraci radek podle primarniho klice
37      */
38     public function findById($id) {
39         return $this->getTable()->select('unit.*,  department.name AS dname')->wherePrimary($id)->fetch();
40     }
41     
42     
43     /**
44      * 
45      * @param type $user_id
46      * @return type
47      * vraci vsechny pole unit_id ke kterym je $user_id vedouci
48      * vyuzivam v OrderPresenter, abych mohl vedoucimu zobrazit objednavky z jemu podrizenych oddeleni
49      */
50     public function getUnits($user_id) {
51     return $this->getTable()
52             ->select('unit.id')
53             ->where('department:department_user.user_id',$user_id);
54     }
55     
56     
57     /**
58      * 
59      * @param type $user_id
60      * @return type
61      * vraci seznam jednotek (unit), ke kterym je $user_id vedouci
62      * vypis v UserPresenter
63      */
64     public function getFullUnits($user_id) {
65     return $this->getTable()
66         ->select('unit.id, CONCAT_WS(\' \',unit.ns,unit.name) AS nsname')
67         ->where('unit.validity = 1')
68         ->where('department:department_user.user_id', $user_id)
69         ->order('unit.id ASC')
70         ->fetchPairs('id', 'nsname');
71     }
72     
73     
74     /**
75      * 
76      * @param type $user_id
77      * @return type
78      * vraci parovy seznam user.id -> unit pro naplneni selectu NewBForm, ke kterym je $user_id vedouci
79      */
80     public function getPairUserUnit($user_id) {
81     return $this->getTable()
82         ->select(':unit_user.user.id, CONCAT_WS(\' \',unit.ns,unit.name) AS nsname')
83         ->where('unit.validity = 1')
84         ->where('department:department_user.user_id', $user_id)
85         ->order('unit.id ASC')
86         ->fetchPairs('id', 'nsname');
87     }
88 }
89 

IS objednávky API documentation generated by ApiGen