1 <?php
 2 
 3 namespace PLus\Orders\Repositories\Order;
 4 
 5 /**
 6  * Description of ItemareastateRepository
 7  *
 8  * @author Petr
 9  */
10 class ItemareastateRepository extends \PLus\Orders\Repositories\Repository {
11     
12     
13     function addAreaState($itemorder_id, $area_id, $user_id) {
14     try {
15         $this->getTable()->insert(array('itemorder_id' => $itemorder_id, 'area_id' => $area_id, 'user_id' => $user_id));
16         
17     } catch (\PDOException $ex) {
18         throw $ex;
19     }
20     }
21     
22     /**
23      * 
24      * @param type $itemorder_id
25      * @param type $area_id
26      * @return type
27      * vraci zda ma polozka v dane oblasti posudek (teoreticky 0 = pro oblast existuje posudek, 1 = oblast jeste neposouzena)
28      */
29     public function countAreaState($itemorder_id, $area_id) {
30     return $this->getTable()
31             ->select('COUNT(*) AS cnt')
32             ->where('itemorder_id ? AND area_id ? AND isresult ?', $itemorder_id, $area_id, NULL)
33             ->fetch();
34         
35     }
36     
37     /**
38      * 
39      * @param type $itemorder_id
40      * @return type
41      * vraci zda polozka ma vsechny posudky ve vsech oblastech (0 = vse je posouzeno, >0 = jeste existuji oblasti bez posudku  
42      */
43     public function countItemState($itemorder_id) {
44     return $this->getTable()
45         ->select('COUNT(*) AS cnt')
46         ->where('itemorder_id ? AND isresult ?', $itemorder_id, NULL)
47         ->fetch();
48     }
49     
50     /**
51      * 
52      * @param type $itemorder_id
53      * @param type $area_id
54      * @param type $user_id
55      * @throws \PLus\Orders\Repositories\Order\Exception
56      * zapis o vlozenem expertnim posudku
57      */
58     public function updateState($itemorder_id, $area_id, $user_id) {
59     try {
60         $this->getTable()->where(array('itemorder_id' => $itemorder_id, 'area_id' => $area_id, 'isresult' => NULL))
61             ->update(array('isresult' => 1, 'user_id' => $user_id, 'created' => date('Y-m-d H:i:s')));
62     } catch (Exception $ex) {
63         throw $ex;
64     }
65     }
66     
67     /**
68      * 
69      * @param type $itemorder_id
70      * @return type
71      * vraci neposouzene oblasti objednavky
72      */
73     public function findAreaNotResult($itemorder_id) {
74     return $this->getTable()
75         ->select('item_area_state.*,area.name')
76         ->where('isresult', NULL)
77         ->where('itemorder_id', $itemorder_id);
78     }
79 }
80 

IS objednávky API documentation generated by ApiGen