| Línea 153... |
Línea 153... |
| 153 |
$records_x_page = intval($this->params()->fromQuery('length', 10), 10);
|
153 |
$records_x_page = intval($this->params()->fromQuery('length', 10), 10);
|
| 154 |
$order = $this->params()->fromQuery('order', []);
|
154 |
$order = $this->params()->fromQuery('order', []);
|
| 155 |
$order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);
|
155 |
$order_field = empty($order[0]['column']) ? 99 : intval($order[0]['column'], 10);
|
| 156 |
$order_direction = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));
|
156 |
$order_direction = empty($order[0]['dir']) ? 'ASC' : strtoupper(filter_var($order[0]['dir'], FILTER_SANITIZE_STRING));
|
| Línea 157... |
Línea 157... |
| 157 |
|
157 |
|
| 158 |
$fields = ['last_date_of_application', 'titlte'];
|
158 |
$fields = ['last_date_of_application', 'title'];
|
| Línea 159... |
Línea 159... |
| 159 |
$order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'last_date_of_application';
|
159 |
$order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'last_date_of_application';
|
| 160 |
|
160 |
|
| 161 |
if (!in_array($order_direction, ['ASC', 'DESC'])) {
|
161 |
if (!in_array($order_direction, ['ASC', 'DESC'])) {
|
| Línea 368... |
Línea 368... |
| 368 |
$job->job_category_id = $jobCategory->id;
|
368 |
$job->job_category_id = $jobCategory->id;
|
| 369 |
$job->description = '';
|
369 |
$job->description = '';
|
| Línea 370... |
Línea 370... |
| 370 |
|
370 |
|
| Línea 371... |
Línea 371... |
| 371 |
$last_date_of_application = $job->last_date_of_application;
|
371 |
$last_date_of_application = $job->last_date_of_application;
|
| 372 |
|
372 |
|
| 373 |
$dt = \DateTime::createFromFormat('d/m/Y', $last_date_of_application);
|
373 |
$dt = \DateTime::createFromFormat('m/d/Y', $last_date_of_application);
|
| 374 |
if ($dt) {
|
374 |
if ($dt) {
|
| Línea 1998... |
Línea 1998... |
| 1998 |
if ($request->isGet()) {
|
1998 |
if ($request->isGet()) {
|
| 1999 |
$dt = \DateTime::createFromFormat('Y-m-d', $job->last_date_of_application);
|
1999 |
$dt = \DateTime::createFromFormat('Y-m-d', $job->last_date_of_application);
|
| Línea 2000... |
Línea 2000... |
| 2000 |
|
2000 |
|
| 2001 |
$data = [
|
2001 |
$data = [
|
| 2002 |
'success' => true,
|
2002 |
'success' => true,
|
| 2003 |
'data' => $dt->format('d/m/Y'),
|
2003 |
'data' => $dt->format('m/d/Y'),
|
| Línea 2004... |
Línea 2004... |
| 2004 |
];
|
2004 |
];
|
| 2005 |
|
2005 |
|
| Línea 2012... |
Línea 2012... |
| 2012 |
$form->setData($dataPost);
|
2012 |
$form->setData($dataPost);
|
| Línea 2013... |
Línea 2013... |
| 2013 |
|
2013 |
|
| 2014 |
if ($form->isValid()) {
|
2014 |
if ($form->isValid()) {
|
| Línea 2015... |
Línea 2015... |
| 2015 |
$this->logger->info('Se actualizo la última fecha de aplicación de la empresa: ' . $company->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
|
2015 |
$this->logger->info('Se actualizo la última fecha de aplicación de la empresa: ' . $company->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);
|
| 2016 |
|
2016 |
|
| Línea 2017... |
Línea 2017... |
| 2017 |
$dt = \DateTime::createFromFormat('d/m/Y', $form->get('last_date_of_application')->getValue());
|
2017 |
$dt = \DateTime::createFromFormat('m/d/Y', $form->get('last_date_of_application')->getValue());
|
| 2018 |
$job->last_date_of_application = $dt->format('Y-m-d');
|
2018 |
$job->last_date_of_application = $dt->format('Y-m-d');
|
| 2019 |
|
2019 |
|
| Línea 2126... |
Línea 2126... |
| 2126 |
$select->columns(['id', 'user_uuid' => 'uuid', 'first_name', 'last_name', 'email']);
|
2126 |
$select->columns(['id', 'user_uuid' => 'uuid', 'first_name', 'last_name', 'email']);
|
| 2127 |
$select->from(['u' => UserMapper::_TABLE]);
|
2127 |
$select->from(['u' => UserMapper::_TABLE]);
|
| 2128 |
$select->join(['ja' => JobApplicationMapper::_TABLE], 'ja.user_id = u.id', ['user_profile_id']);
|
2128 |
$select->join(['ja' => JobApplicationMapper::_TABLE], 'ja.user_id = u.id', ['user_profile_id']);
|
| 2129 |
$select->join(['up' => UserProfileMapper::_TABLE], 'ja.user_profile_id = up.id', ['user_profile_uuid' => 'uuid']);
|
2129 |
$select->join(['up' => UserProfileMapper::_TABLE], 'ja.user_profile_id = up.id', ['user_profile_uuid' => 'uuid']);
|
| 2130 |
$select->where->equalTo('u.status', User::STATUS_ACTIVE);
|
2130 |
$select->where->equalTo('u.status', User::STATUS_ACTIVE);
|
| - |
|
2131 |
$select->where->equalTo('ja.job_id', $job->id);
|
| 2131 |
$select->order(['first_name', 'last_name']);
|
2132 |
$select->order(['first_name', 'last_name']);
|
| - |
|
2133 |
|
| - |
|
2134 |
|
| Línea 2132... |
Línea 2135... |
| 2132 |
|
2135 |
|
| 2133 |
$items = [];
|
2136 |
$items = [];
|
| Línea 2134... |
Línea 2137... |
| 2134 |
$records = $queryMapper->fetchAll($select);
|
2137 |
$records = $queryMapper->fetchAll($select);
|