Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 1264 | Rev 1266 | Ir a la última revisión | | Comparar con el anterior | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
647 efrain 1
<?php
2
declare(strict_types=1);
3
 
4
namespace LeadersLinked\Mapper;
5
 
6
use LeadersLinked\Mapper\Common\MapperCommon;
7
use Laminas\Db\Adapter\AdapterInterface;
1265 eleazar 8
use LeadersLinked\Model\RecruitmentSelectionCandidate;
852 eleazar 9
use LeadersLinked\Model\RecruitmentSelectionVacancy;
1092 eleazar 10
use LeadersLinked\Model\RecruitmentSelectionInterview;
647 efrain 11
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
12
use Laminas\Paginator\Paginator;
13
use Laminas\Db\ResultSet\HydratingResultSet;
14
use Laminas\Paginator\Adapter\DbSelect;
15
 
16
 
17
class RecruitmentSelectionInterviewMapper extends MapperCommon
18
{
19
    const _TABLE = 'tbl_recruitment_selection_candidate_interviews';
20
 
21
    /**
22
     *
23
     * @var RecruitmentInterviewMapper
24
     */
25
    private static $_instance;
26
 
27
    /**
28
     *
29
     * @param AdapterInterface $adapter
30
     */
31
    private function __construct($adapter)
32
    {
33
        parent::__construct($adapter);
34
    }
35
 
36
    /**
37
     *
38
     * @param AdapterInterface $adapter
39
     * @return RecruitmentSelectionInterviewMapper
40
     */
41
    public static function getInstance($adapter)
42
    {
43
        if(self::$_instance == null) {
1065 eleazar 44
            self::$_instance = new RecruitmentSelectionInterviewMapper($adapter);
647 efrain 45
        }
46
        return self::$_instance;
47
    }
48
 
49
    /**
50
     *
51
     * @param int $id
1065 eleazar 52
     * @return RecruitmentSelectionInterview
647 efrain 53
     */
54
    public function fetchOne($id)
55
    {
1065 eleazar 56
        $prototype = new RecruitmentSelectionInterview();
647 efrain 57
 
58
        $select = $this->sql->select(self::_TABLE);
59
        $select->where->equalTo('id', $id);
60
 
61
        return $this->executeFetchOneObject($select, $prototype);
62
    }
63
 
64
 
65
    /**
66
     *
67
     * @param int $uuid
1065 eleazar 68
     * @return RecruitmentSelectionInterview
647 efrain 69
     */
70
    public function fetchOneByUuid($uuid)
71
    {
1065 eleazar 72
        $prototype = new RecruitmentSelectionInterview();
647 efrain 73
        $select = $this->sql->select(self::_TABLE);
74
        $select->where->equalTo('uuid', $uuid);
75
 
76
        return $this->executeFetchOneObject($select, $prototype);
77
    }
78
 
79
 
80
    /**
81
     *
82
     * @param int $company_id
1065 eleazar 83
     * @return RecruitmentSelectionInterview
647 efrain 84
     */
85
    public function fetchAllByCompanyId($company_id)
86
    {
1065 eleazar 87
        $prototype = new RecruitmentSelectionInterview();
647 efrain 88
 
89
        $select = $this->sql->select(self::_TABLE);
90
        $select->where->equalTo('company_id', $company_id);
91
        $select->order('name');
92
 
93
        return $this->executeFetchAllObject($select, $prototype);
94
    }
852 eleazar 95
 
96
     /**
97
     *
1202 eleazar 98
     * @param int $candidate_id
99
     * @return RecruitmentSelectionInterview
100
     */
1204 eleazar 101
    public function fetchAllByVacancyId($vacancy_id)
1202 eleazar 102
    {
103
        $prototype = new RecruitmentSelectionInterview();
104
 
105
        $select = $this->sql->select(self::_TABLE);
1204 eleazar 106
        $select->where->equalTo('vacancy_id', $vacancy_id);
1202 eleazar 107
        $select->order('first_name');
108
 
109
        return $this->executeFetchAllObject($select, $prototype);
110
    }
111
 
1264 eleazar 112
 
1202 eleazar 113
     /**
114
     *
1264 eleazar 115
     * @param int $candidate_id
116
     * @return RecruitmentSelectionInterview
117
     */
118
    public function fetchAllByVacancyIdAndStatus($vacancy_id)
119
    {
120
        $prototype = new RecruitmentSelectionInterview();
121
 
122
        $select = $this->sql->select(self::_TABLE);
123
        $select->where->equalTo('vacancy_id', $vacancy_id);
1265 eleazar 124
        $select->where->equalTo('status', RecruitmentSelectionCandidate::STATUS_ACEPTED);
1264 eleazar 125
        $select->order('first_name');
126
 
127
        return $this->executeFetchAllObject($select, $prototype);
128
    }
129
 
130
     /**
131
     *
852 eleazar 132
     * @param int $company_id
1065 eleazar 133
     * @return RecruitmentSelectionInterview
991 eleazar 134
     */
135
    public function fetchOneByCompanyId($company_id)
136
    {
1065 eleazar 137
        $prototype = new RecruitmentSelectionInterview();
991 eleazar 138
 
139
        $select = $this->sql->select(self::_TABLE);
140
        $select->where->equalTo('company_id', $company_id);
141
        $select->order('name');
142
 
143
        return $this->executeFetchOneObject($select, $prototype);
144
    }
145
 
146
     /**
147
     *
148
     * @param int $company_id
852 eleazar 149
     * @param int $topic_id
150
     * @return RecruitmentSelectionVacancy[]
151
     */
152
    public function fetchAllByCompanyIdAndVacancyId($company_id, $vancacy_id)
153
    {
863 eleazar 154
        $prototype = new RecruitmentSelectionVacancy();
852 eleazar 155
 
156
        $select = $this->sql->select(self::_TABLE);
157
        $select->where->equalTo('company_id', $company_id);
1121 eleazar 158
        $select->where->equalTo('vacancy_id', $vacancy_id);
159
        $select->order(['name']);
852 eleazar 160
 
161
        //echo $select->getSqlString($this->adapter->platform); exit;
162
 
163
        return $this->executeFetchAllObject($select, $prototype);
164
    }
647 efrain 165
 
1121 eleazar 166
    /**
167
     * @param int $vacancy_id
168
     * @param int $candidate_id
1127 eleazar 169
     * @return RecruitmentSelectionInterview
1121 eleazar 170
     */
171
    public function fetchOneByCandidateIdAndVacancyId($candidate_id, $vacancy_id)
172
    {
173
        $prototype = new RecruitmentSelectionInterview();
174
 
175
        $select = $this->sql->select(self::_TABLE);
176
        $select->where->equalTo('candidate_id', $candidate_id);
177
        $select->where->equalTo('vacancy_id', $vacancy_id);
178
        $select->order(['uuid']);
179
 
180
        return $this->executeFetchOneObject($select, $prototype);
181
    }
1255 eleazar 182
 
183
        /**
184
     * @param int $vacancy_id
185
     * @param int $candidate_id
186
     * @return RecruitmentSelectionInterview
187
     */
188
    public function fetchAllByCandidateIdAndVacancyId($candidate_id, $vacancy_id)
189
    {
190
        $prototype = new RecruitmentSelectionInterview();
191
 
192
        $select = $this->sql->select(self::_TABLE);
193
        $select->where->equalTo('candidate_id', $candidate_id);
194
        $select->where->equalTo('vacancy_id', $vacancy_id);
195
        $select->order(['uuid']);
196
 
197
        return $this->executeFetchAllObject($select, $prototype);
198
    }
647 efrain 199
 
200
    /**
201
     *
1065 eleazar 202
     * @param RecruitmentSelectionInterview $form
647 efrain 203
     * @return boolean
204
     */
205
    public function insert($form)
206
    {
207
        $hydrator = new ObjectPropertyHydrator();
208
        $values = $hydrator->extract($form);
209
        $values = $this->removeEmpty($values);
210
 
211
        $insert = $this->sql->insert(self::_TABLE);
212
        $insert->values($values);
1064 eleazar 213
 
1091 eleazar 214
       // echo $insert->getSqlString($this->adapter->platform); exit;
647 efrain 215
 
216
        $result = $this->executeInsert($insert);
217
        if($result) {
218
            $form->id = $this->lastInsertId;
219
        }
220
        return $result;
221
    }
222
 
223
    /**
224
     *
225
     * @param RecruitmentInterview $form
226
     * @return boolean
227
     */
228
    public function update($form)
229
    {
230
        $hydrator = new ObjectPropertyHydrator();
231
        $values = $hydrator->extract($form);
232
        $values = $this->removeEmpty($values);
233
 
234
        $update = $this->sql->update(self::_TABLE);
235
        $update->set($values);
236
        $update->where->equalTo('id', $form->id);
237
 
238
        return $this->executeUpdate($update);
239
    }
240
 
241
    /**
242
     *
243
     * @param int $form_id
244
     * @return boolean
245
     */
246
    public function delete($form_id)
247
    {
248
        $delete = $this->sql->delete(self::_TABLE);
249
        $delete->where->equalTo('id', $form_id);
250
 
251
        return $this->executeDelete($delete);
252
    }
253
 
254
 
255
    /**
256
     *
257
     * @param int $companyId
258
     * @param string $search
259
     * @param int $page
260
     * @param int $records_per_page
261
     * @param string $order_field
262
     * @param string $order_direction
263
     * @return Paginator
264
     */
265
    public function fetchAllDataTableByCompanyId($companyId, $search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
266
    {
1246 eleazar 267
        $prototype = new RecruitmentSelectionCandidate();
268
        $select = $this->sql->select(self::_TABLE);
269
        $select->where->equalTo('company_id', $companyId);
647 efrain 270
 
271
        if($search) {
1246 eleazar 272
            $select->where->like('name', '%' . $search . '%');
647 efrain 273
        }
274
        $select->order($order_field . ' ' . $order_direction);
275
 
276
        //echo $select->getSqlString($this->adapter->platform); exit;
277
 
278
        $hydrator   = new ObjectPropertyHydrator();
279
        $resultset  = new HydratingResultSet($hydrator, $prototype);
280
 
281
        $adapter = new DbSelect($select, $this->sql, $resultset);
282
        $paginator = new Paginator($adapter);
283
        $paginator->setItemCountPerPage($records_per_page);
284
        $paginator->setCurrentPageNumber($page);
285
 
1246 eleazar 286
 
647 efrain 287
        return $paginator;
288
    }
289
 
290
 
291
}