1 <?php
 2 
 3 namespace PLus\Orders\Repositories\Order;
 4 
 5 
 6 /**
 7  * Description of ItemorderRealizationRepository
 8  *
 9  * @author Petr
10  */
11 class ItemorderRealizationRepository extends \PLus\Orders\Repositories\Repository {
12     
13     
14     /**
15      * 
16      * @param type $itemorder_realization_id
17      * @param type $user_id
18      * @throws \PDOException
19      * priradi resitele pro realizaci polozky
20      */
21     function assignImplementer($itemorder_realization_id, $user_id) {
22     try {
23         $this->connection->table('itemorder_realization_user')->insert(array('itemorder_realization_id' => $itemorder_realization_id, 'user_id' => $user_id));
24     } catch (\PDOException $e) {
25         if ($e->getCode() == '23000')
26         $this->connection->table('itemorder_realization_user')->where(array('itemorder_realization_id' => $itemorder_realization_id))
27             ->update(array('user_id' => $user_id));
28         else
29         throw $e;
30     }
31     }
32     
33     
34     /**
35      * 
36      * @param type $itemorder_id
37      * @return type
38      * vraci prideleneho resitele polozky
39      */
40     function getAssignImplementerByItemorderId($itemorder_id) {
41     return $this->getTable()->select(':itemorder_realization_user.user.firstname, '
42             . ':itemorder_realization_user.user.lastname, :itemorder_realization_user.user.email')
43             ->where('itemorder_realization.itemorder_id', $itemorder_id);
44     }
45     
46     /**
47      * 
48      * @param type $itemorder_id
49      * @return type
50      * vraci id resitele
51      */
52     function getAssignImplementerId($itemorder_id) {
53     return $this->getTable()->select(':itemorder_realization_user.user.id')
54             ->where('itemorder_realization.itemorder_id', $itemorder_id)
55             ->fetch();
56     }
57     
58     
59     /**
60      * 
61      * @param type $itemorder_id
62      * @return type
63      * ziska zaznam o realizaci podle id polozky
64      */
65     public function findById($itemorder_id) {
66     return $this->getTable()->select('itemorder_realization.*')->where('itemorder_realization.itemorder_id',$itemorder_id)->fetch();
67     }
68     
69     
70     /**
71      * 
72      * @param type $itemorder_id
73      * @return type
74      * vraci zaznam o realizaci podle id polozky a udaj o resiteli
75      */
76     public function getRecordOfImplementation($itemorder_id) {
77     return $this->getTable()->select('itemorder_realization.*, CONCAT_WS(\' \',:itemorder_realization_user.user.firstname,'
78             . ':itemorder_realization_user.user.lastname) AS iname,:itemorder_realization_user.user.email')
79             ->where('itemorder_realization.itemorder_id', $itemorder_id)
80             ->fetch();
81     }
82 
83 }
84 

IS objednávky API documentation generated by ApiGen