Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 1 | | Comparar con el anterior | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 www 1 
<?php
2 
 
3 
declare(strict_types=1);
4 
 
5 
namespace LeadersLinked\Mapper;
6 
 
7 
 
8 
use Laminas\Db\Adapter\AdapterInterface;
9 
use Laminas\Db\ResultSet\HydratingResultSet;
10 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
11 
use Laminas\Log\LoggerInterface;
12 
use Laminas\Paginator\Paginator;
13 
use Laminas\Paginator\Adapter\DbSelect;
14 
 
15 
use LeadersLinked\Model\Language;
16 
use LeadersLinked\Mapper\Common\MapperCommon;
17 
 
18 
class LanguageMapper extends MapperCommon
19 
{
20 
    const _TABLE = 'tbl_languages';
21 
 
22 
 
23 
    /**
24 
     *
25 
     * @var LanguageMapper
26 
     */
27 
    private static $_instance;
28 
 
29 
    /**
30 
     *
31 
     * @param AdapterInterface $adapter
32 
     */
33 
    private function __construct($adapter)
34 
    {
35 
        parent::__construct($adapter);
36 
    }
37 
 
38 
    /**
39 
     *
40 
     * @param AdapterInterface $adapter
41 
     * @return \LeadersLinked\Mapper\LanguageMapper
42 
     */
43 
    public static function getInstance($adapter)
44 
    {
45 
        if(self::$_instance == null) {
46 
            self::$_instance = new LanguageMapper($adapter);
47 
        }
48 
        return self::$_instance;
49 
    }
50 
 
51 
    /**
52 
     *
53 
     * @return Language[]
54 
     */
55 
    public function fetchAll()
56 
    {
57 
        $prototype = new Language();
58 
        $select = $this->sql->select(self::_TABLE);
59 
 
60 
        return $this->executeFetchAllObject($select, $prototype);
61 
    }
62 
 
63 
    /**
64 
     *
65 
     * @return Language[]
66 
     */
3454 efrain 67 
    public function fetchAllActive()
1 www 68 
    {
69 
        $prototype = new Language();
70 
        $select = $this->sql->select(self::_TABLE);
71 
        $select->where->equalTo('status', Language::STATUS_ACTIVE);
72 
        $select->order('name');
73 
 
74 
        return $this->executeFetchAllObject($select, $prototype);
75 
    }
76 
 
77 
 
78 
 
79 
 
80 
    /**
81 
     *
82 
     * @param int $id
83 
     * @return Language
84 
     */
85 
    public function fetchOne($id)
86 
    {
87 
        $select = $this->sql->select(self::_TABLE);
88 
        $select->where->equalTo('id', $id);
89 
        $select->limit(1);
90 
 
91 
        $prototype = new Language();
92 
        return $this->executeFetchOneObject($select, $prototype);
93 
    }
94 
 
95 
    /**
96 
     *
97 
     * @param string $search
98 
     * @param int $page
99 
     * @param int $records_per_page
100 
     * @param string $order_field
101 
     * @param string $order_direction
102 
     * @return Paginator
103 
     */
104 
    public function fetchAllDataTable($search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
105 
    {
106 
        $prototype = new Language();
107 
        $select = $this->sql->select(self::_TABLE);
108 
 
109 
        if($search) {
110 
            $select->where->like('name', '%' . $search . '%');
111 
        }
112 
        $select->order($order_field . ' ' . $order_direction);
113 
 
114 
        $hydrator   = new ObjectPropertyHydrator();
115 
        $resultset  = new HydratingResultSet($hydrator, $prototype);
116 
 
117 
        $adapter = new DbSelect($select, $this->sql, $resultset);
118 
        $paginator = new Paginator($adapter);
119 
        $paginator->setItemCountPerPage($records_per_page);
120 
        $paginator->setCurrentPageNumber($page);
121 
 
122 
 
123 
        return $paginator;
124 
    }
125 
 
126 
    /**
127 
     *
128 
     * @param Language $language
129 
     * @return boolean
130 
     */
131 
    public function insert($language)
132 
    {
133 
        $hydrator = new ObjectPropertyHydrator();
134 
        $values = $hydrator->extract($language);
135 
 
136 
        $insert = $this->sql->insert(self::_TABLE);
137 
        $insert->values($values);
138 
 
139 
        $result = $this->executeInsert($insert);
140 
        if($result) {
141 
            $language->id = $this->lastInsertId;
142 
        }
143 
 
144 
        return $result;
145 
 
146 
    }
147 
 
148 
    /**
149 
     *
150 
     * @param Language $language
151 
     * @return boolean
152 
     */
153 
    public function update($language)
154 
    {
155 
        $hydrator = new ObjectPropertyHydrator();
156 
        $values = $hydrator->extract($language);
157 
 
158 
        $update = $this->sql->update(self::_TABLE);
159 
        $update->set($values);
160 
        $update->where->equalTo('id', $language->id);
161 
 
162 
        return $this->executeUpdate($update);
163 
    }
164 
 
165 
    /**
166 
     *
167 
     * @param Language $language
168 
     * @return boolean
169 
     */
170 
    public function delete($language)
171 
    {
172 
        $delete = $this->sql->delete(self::_TABLE);
173 
        $delete->where->equalTo('id', $language->id);
174 
 
175 
        return $this->executeDelete($delete);
176 
 
177 
    }
178 
 
179 
 
180 
 
181 
 
182 
    /**
183 
     *
184 
     * @return boolean
185 
     */
186 
    public function truncate()
187 
    {
188 
        $sql = 'DELETE FROM ' . self::_TABLE;
189 
        if($this->executeSentenceWithParameters($sql)) {
190 
            $sql = 'ALTER TABLE ' . self::_TABLE . ' AUTO_INCREMENT = 1 ';
191 
            return $this->executeSentenceWithParameters($sql);
192 
        }
193 
        return false;
194 
    }
195 
}