Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 3471 | Rev 5050 | 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;
705 eleazar 8
use LeadersLinked\Model\RecruitmentSelectionCandidate;
647 efrain 9
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
10
use Laminas\Paginator\Paginator;
11
use Laminas\Db\ResultSet\HydratingResultSet;
12
use Laminas\Paginator\Adapter\DbSelect;
13
 
14
 
15
class RecruitmentSelectionCandidateMapper extends MapperCommon
16
{
17
    const _TABLE = 'tbl_recruitment_selection_candidates';
18
 
19
    /**
20
     *
707 eleazar 21
     * @var RecruitmentSelectionCandidateMapper
647 efrain 22
     */
23
    private static $_instance;
24
 
25
    /**
26
     *
27
     * @param AdapterInterface $adapter
28
     */
29
    private function __construct($adapter)
30
    {
31
        parent::__construct($adapter);
32
    }
33
 
34
    /**
35
     *
36
     * @param AdapterInterface $adapter
37
     * @return RecruitmentSelectionCandidateMapper
38
     */
39
    public static function getInstance($adapter)
40
    {
41
        if(self::$_instance == null) {
42
            self::$_instance = new RecruitmentSelectionCandidateMapper($adapter);
43
        }
44
        return self::$_instance;
45
    }
46
 
47
    /**
48
     *
49
     * @param int $id
704 eleazar 50
     * @return RecruitmentSelectionCandidate
647 efrain 51
     */
52
    public function fetchOne($id)
53
    {
704 eleazar 54
        $prototype = new RecruitmentSelectionCandidate();
647 efrain 55
 
56
        $select = $this->sql->select(self::_TABLE);
57
        $select->where->equalTo('id', $id);
58
 
59
        return $this->executeFetchOneObject($select, $prototype);
60
    }
61
 
62
 
63
    /**
64
     *
65
     * @param int $uuid
704 eleazar 66
     * @return RecruitmentSelectionCandidate
647 efrain 67
     */
68
    public function fetchOneByUuid($uuid)
69
    {
704 eleazar 70
        $prototype = new RecruitmentSelectionCandidate();
647 efrain 71
        $select = $this->sql->select(self::_TABLE);
72
        $select->where->equalTo('uuid', $uuid);
73
 
74
        return $this->executeFetchOneObject($select, $prototype);
75
    }
76
 
77
    /**
78
     *
79
     * @param int $company_id
704 eleazar 80
     * @return RecruitmentSelectionCandidate
647 efrain 81
     */
82
    public function fetchAllByCompanyId($company_id)
83
    {
704 eleazar 84
        $prototype = new RecruitmentSelectionCandidate();
647 efrain 85
 
86
        $select = $this->sql->select(self::_TABLE);
87
        $select->where->equalTo('company_id', $company_id);
1059 eleazar 88
        $select->order('first_name');
647 efrain 89
 
90
        return $this->executeFetchAllObject($select, $prototype);
91
    }
721 eleazar 92
 
4776 efrain 93
 
863 eleazar 94
 
647 efrain 95
 
96
    /**
97
     *
4776 efrain 98
     * @param RecruitmentSelectionCandidate $record
647 efrain 99
     * @return boolean
100
     */
4776 efrain 101
    public function insert($record)
647 efrain 102
    {
103
        $hydrator = new ObjectPropertyHydrator();
4776 efrain 104
        $values = $hydrator->extract($record);
647 efrain 105
        $values = $this->removeEmpty($values);
106
 
107
        $insert = $this->sql->insert(self::_TABLE);
698 eleazar 108
        $insert->values($values);
696 eleazar 109
 
647 efrain 110
        $result = $this->executeInsert($insert);
111
        if($result) {
4776 efrain 112
            $record->id = $this->lastInsertId;
647 efrain 113
        }
114
        return $result;
115
    }
116
 
117
    /**
118
     *
4776 efrain 119
     * @param RecruitmentSelectionCandidate $record
647 efrain 120
     * @return boolean
121
     */
4776 efrain 122
    public function update($record)
647 efrain 123
    {
124
        $hydrator = new ObjectPropertyHydrator();
4776 efrain 125
        $values = $hydrator->extract($record);
647 efrain 126
        $values = $this->removeEmpty($values);
127
 
128
        $update = $this->sql->update(self::_TABLE);
129
        $update->set($values);
4776 efrain 130
        $update->where->equalTo('id', $record->id);
647 efrain 131
 
132
        return $this->executeUpdate($update);
133
    }
134
 
135
    /**
136
     *
4776 efrain 137
     * @param int $id
647 efrain 138
     * @return boolean
139
     */
4776 efrain 140
    public function delete($id)
647 efrain 141
    {
142
        $delete = $this->sql->delete(self::_TABLE);
4776 efrain 143
        $delete->where->equalTo('id', $id);
647 efrain 144
 
145
        return $this->executeDelete($delete);
146
    }
147
 
148
 
149
    /**
150
     *
151
     * @param int $companyId
152
     * @param string $search
153
     * @param int $page
154
     * @param int $records_per_page
155
     * @param string $order_field
156
     * @param string $order_direction
157
     * @return Paginator
158
     */
159
    public function fetchAllDataTableByCompanyId($companyId, $search, $page = 1, $records_per_page = 10, $order_field= 'name', $order_direction = 'ASC')
160
    {
704 eleazar 161
        $prototype = new RecruitmentSelectionCandidate();
647 efrain 162
        $select = $this->sql->select(self::_TABLE);
163
        $select->where->equalTo('company_id', $companyId);
164
 
165
        if($search) {
166
            $select->where->like('name', '%' . $search . '%');
167
        }
168
        $select->order($order_field . ' ' . $order_direction);
169
 
170
        //echo $select->getSqlString($this->adapter->platform); exit;
171
 
172
        $hydrator   = new ObjectPropertyHydrator();
173
        $resultset  = new HydratingResultSet($hydrator, $prototype);
174
 
175
        $adapter = new DbSelect($select, $this->sql, $resultset);
176
        $paginator = new Paginator($adapter);
177
        $paginator->setItemCountPerPage($records_per_page);
178
        $paginator->setCurrentPageNumber($page);
179
 
180
 
181
        return $paginator;
182
    }
183
 
184
 
185
}