1 <?php
 2 
 3 namespace PLus\Orders\Repositories\Documents;
 4 
 5 
 6 /**
 7  * Description of DocumentRepository
 8  *
 9  * @author Petr
10  */
11 class DocumentRepository extends \PLus\Orders\Repositories\Repository {
12    
13     function getPairData(){
14     return $this->getTable()->select('id, name')->order('name ASC')->fetchPairs('id', 'name');
15     }
16 
17     
18     /**
19     * Vraci META informace pro dokument
20     *
21     * @param int $id_document ID dokumentu
22     * @return mixed
23     */
24    function getDocumentsMeta($id_document) {
25        return $this->getTable()
26             ->select('OCTET_LENGTH(document.data) AS size, document.mime, document.lastmod, document.name, document.filename, '
27                 . 'CASE WHEN user.isunit=1 THEN user:unit_user.unit.name ELSE CONCAT_WS(\' \',user.firstname, user.lastname) END AS uname,'
28                 . 'document.user_id')
29             ->where(array('document.id' => $id_document))->fetch();
30    }
31     
32 }
33 

IS objednávky API documentation generated by ApiGen