Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 3471 | Rev 5050 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 3471 Rev 4776
Línea 88... Línea 88...
88 
        $select->order('first_name');
 88 
        $select->order('first_name');
Línea 89... Línea 89...
89
89
90 
        return $this->executeFetchAllObject($select, $prototype);
 90 
        return $this->executeFetchAllObject($select, $prototype);
Línea 91... Línea -...
91 
    }
 - 
 
92 
 
 - 
 
93 
    /**
 - 
 
94 
     *
 - 
 
95 
     * @param int $vacancy_id
 - 
 
96 
     * @return RecruitmentSelectionCandidate
 - 
 
97 
     */
 - 
 
98 
    public function fetchAllBySelectionId($vacancy_id)
 - 
 
99 
    {
 - 
 
100 
        $prototype = new RecruitmentSelectionCandidate();
 - 
 
101
- 
 
102 
        $select = $this->sql->select(self::_TABLE);
 - 
 
103 
        $select->where->equalTo('vacancy_id', $vacancy_id);
 - 
 
104 
        $select->order('first_name');
 - 
 
105
- 
 
106 
        return $this->executeFetchAllObject($select, $prototype);
 - 
 
107 
    }
 - 
 
108 
 
 - 
 
109 
    /**
 - 
 
110 
     *
 - 
 
111 
     * @return RecruitmentSelectionCandidate[]
 - 
 
112 
     */
 - 
 
113 
    public function fetchAllActive($vacancy_id) {
 - 
 
114 
        $prototype = new RecruitmentSelectionCandidate();
 - 
 
115 
        $select = $this->sql->select(self::_TABLE);
 - 
 
116 
        $select->where->equalTo('vacancy_id', $vacancy_id);
 - 
 
117 
        $select->where->equalTo('status', RecruitmentSelectionCandidate::STATUS_ACEPTED);
 - 
 
118 
        $select->order('first_name');
 - 
 
119 
 
 - 
 
120 
        return $this->executeFetchAllObject($select, $prototype);
 - 
 
121 
    }
 - 
 
122 
 
 - 
 
123 
    /**
 - 
 
124 
     *
 - 
 
125 
     * @param int $candidate_id
 - 
 
126 
     * @return RecruitmentSelectionCandidate[]
 - 
 
127 
     */
 - 
 
128 
    public function fetchAllByVacancyIdAndStatus($vacancy_id)
 - 
 
129 
    {
 - 
 
130 
        $prototype = new RecruitmentSelectionCandidate();
 - 
 
131
- 
 
132 
        $select = $this->sql->select(self::_TABLE);
 - 
 
133 
        $select->where->equalTo('vacancy_id', $vacancy_id);
 - 
 
134 
        $select->where->equalTo('status', RecruitmentSelectionCandidate::STATUS_ACCEPTED);
 - 
 
135 
        $select->order('first_name');
 - 
 
136
- 
 
137 
        return $this->executeFetchAllObject($select, $prototype);
 - 
 
138 
    }
 - 
 
139 
 
 - 
 
140 
     /**
 - 
 
141 
     *
 - 
 
142 
     * @param int $company_id
 - 
 
143 
     * @param int $vacancy_id
 - 
 
144 
     * @return RecruitmentSelectioncandidate[]
 - 
 
145 
     */
 - 
 
146 
    public function fetchAllByCompanyIdAndVacancyId($company_id, $vacancy_id)
 - 
 
147 
    {
 - 
 
148 
        $prototype = new RecruitmentSelectioncandidate();
 - 
 
149
- 
 
150 
        $select = $this->sql->select(self::_TABLE);
 - 
 
151 
        $select->where->equalTo('company_id', $company_id);
 - 
 
152 
        $select->where->equalTo('vacancy_id', $vacancy_id);
 - 
 
153 
        $select->order(['first_name']);
 - 
 
154
- 
 
155 
       // echo $select->getSqlString($this->adapter->platform); exit;
 - 
 
156
- 
 
157 
        return $this->executeFetchAllObject($select, $prototype);
 - 
 
158 
    }
 - 
 
159
- 
 
160 
     /**
 - 
 
161 
     *
 - 
 
162 
     * @param int $company_id
 - 
 
163 
     * @param int $selection_id
 - 
 
164 
     * @param int $user_id
 - 
 
165 
     * @return RecruitmentSelectionCandidate
 - 
 
166 
     */
 - 
 
167 
    public function fetchAllByCompanyIdAndSelectionIdAndUserId($company_id, $vacancy_id, $user_id)
 - 
 
168 
    {
 - 
 
169 
        $prototype = new RecruitmentSelectionCandidate();
 - 
 
170
- 
 
171 
        $select = $this->sql->select(self::_TABLE);
 - 
 
172 
        $select->where->equalTo('company_id', $company_id);
 - 
 
173 
        $select->where->equalTo('vacancy_id', $vacancy_id);
 - 
 
174 
        $select->where->equalTo('user_id', $user_id);
 - 
 
175
- 
 
176
- 
 
Línea -... Línea 91...
- 
 
 91 
    }
Línea 177... Línea 92...
177 
        return $this->executeFetchOneObject($select, $prototype);
 92 
 
178 
    }
 93
179
94 
 
180
95
181 
    /**
 96 
    /**
182 
     *
97 
     *
183 
     * @param RecruitmentSelectionCandidate $candidate
 98 
     * @param RecruitmentSelectionCandidate $record
184 
     * @return boolean
 99 
     * @return boolean
185 
     */
 100 
     */
186 
    public function insert($candidate)
 101 
    public function insert($record)
Línea 187... Línea 102...
187 
    {
 102 
    {
188 
        $hydrator = new ObjectPropertyHydrator();
 103 
        $hydrator = new ObjectPropertyHydrator();
Línea 189... Línea 104...
189 
        $values = $hydrator->extract($candidate);
 104 
        $values = $hydrator->extract($record);
190 
        $values = $this->removeEmpty($values);
 105 
        $values = $this->removeEmpty($values);
191
106
192 
        $insert = $this->sql->insert(self::_TABLE);
 107 
        $insert = $this->sql->insert(self::_TABLE);
193 
        $insert->values($values);
 108 
        $insert->values($values);
194 
 
 109 
 
Línea 195... Línea 110...
195 
        $result = $this->executeInsert($insert);
 110 
        $result = $this->executeInsert($insert);
196 
        if($result) {
 111 
        if($result) {
197 
            $candidate->id = $this->lastInsertId;
 112 
            $record->id = $this->lastInsertId;
198 
        }
 113 
        }
199 
        return $result;
 114 
        return $result;
200 
    }
 115 
    }
201
116
202 
    /**
 117 
    /**
203 
     *
 118 
     *
204 
     * @param RecruitmentSelectionCandidate $candidate
 119 
     * @param RecruitmentSelectionCandidate $record
Línea 205... Línea 120...
205 
     * @return boolean
 120 
     * @return boolean
206 
     */
 121 
     */
207 
    public function update($candidate)
 122 
    public function update($record)
Línea 208... Línea 123...
208 
    {
 123 
    {
209 
        $hydrator = new ObjectPropertyHydrator();
 124 
        $hydrator = new ObjectPropertyHydrator();
Línea 210... Línea 125...
210 
        $values = $hydrator->extract($candidate);
 125 
        $values = $hydrator->extract($record);
211 
        $values = $this->removeEmpty($values);
 126 
        $values = $this->removeEmpty($values);
212
127
213 
        $update = $this->sql->update(self::_TABLE);
 128 
        $update = $this->sql->update(self::_TABLE);
214 
        $update->set($values);
 129 
        $update->set($values);
215 
        $update->where->equalTo('id', $candidate->id);
 130 
        $update->where->equalTo('id', $record->id);
216
131
217 
        return $this->executeUpdate($update);
132 
        return $this->executeUpdate($update);
218 
    }
 133 
    }
Línea 219... Línea 134...
219
134
220 
    /**
 135 
    /**