Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 285 Rev 286
Línea 93... Línea 93...
93 
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
 93 
                $search = empty($search['value']) ? '' : filter_var($search['value'], FILTER_SANITIZE_STRING);
Línea 94... Línea 94...
94 
 
 94 
 
Línea 95... Línea 95...
95 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 95 
                $queryMapper = QueryMapper::getInstance($this->adapter);
96 
 
 96 
 
97 
                $select = $queryMapper->getSql()->select();
 97 
                $select = $queryMapper->getSql()->select();
98 
                $select->columns(['uuid', 'content','status','user_id']);
 98 
                $select->columns(['uuid','status','user_id']);
99 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
 99 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
Línea 100... Línea 100...
100 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
 100 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
Línea 101... Línea 101...
101 
                $select->join(['user' => UserMapper::_TABLE], 'test.user_id = user.id', ['last_name','first_name'], Select::JOIN_LEFT_OUTER);
 101 
                $select->join(['user' => UserMapper::_TABLE], 'test.user_id = user.id', ['first_name','last_name'], Select::JOIN_LEFT_OUTER);
102 
 
 102 
 
Línea 108... Línea 108...
108 
                $select->order('name ASC, language ASC');
 108 
                $select->order('name ASC, language ASC');
Línea 109... Línea 109...
109 
 
 109 
 
110 
                $records = $queryMapper->fetchAll($select);
 110 
                $records = $queryMapper->fetchAll($select);
Línea -... Línea 111...
- 
 
 111 
                $items = [];
- 
 
 112 
 
- 
 
 113 
                foreach ($records as $record) {
- 
 
 114 
                    switch ($record['language']) {
- 
 
 115 
                        case CompanySelfEvaluationForm::LANGUAGE_ENGLISH :
- 
 
 116 
                            $language = 'LABEL_ENGLISH';
- 
 
 117 
                            break;
- 
 
 118 
 
- 
 
 119 
                        case CompanySelfEvaluationForm::LANGUAGE_SPANISH :
- 
 
 120 
                            $language = 'LABEL_SPANISH';
- 
 
 121 
                            break;
- 
 
 122 
 
- 
 
 123 
                        default :
- 
 
 124 
                            $language = '';
- 
 
 125 
                            break;
- 
 
 126 
                    }
- 
 
 127 
 
- 
 
 128 
                    switch ($record['status']) {
- 
 
 129 
 
- 
 
 130 
                        case CompanySelfEvaluationTest::STATUS_DRAFT :
- 
 
 131 
                            $status = 'LABEL_DRAFT';
- 
 
 132 
                            break;
- 
 
 133 
 
- 
 
 134 
                        case CompanySelfEvaluationTest::STATUS_COMPLETED :
- 
 
 135 
                            $status = 'LABEL_COMPLETED';
- 
 
 136 
                            break;
- 
 
 137 
 
- 
 
 138 
                        case CompanySelfEvaluationTest::STATUS_PENDING :
- 
 
 139 
                            $status = 'LABEL_PENDING';
- 
 
 140 
                            break;
- 
 
 141 
 
- 
 
 142 
                        case CompanySelfEvaluationTest::STATUS_REVIEW :
- 
 
 143 
                            $status = 'LABEL_REVIEW';
- 
 
 144 
                            break;
- 
 
 145 
 
- 
 
 146 
 
- 
 
 147 
                        default :
- 
 
 148 
                            $status = 'LABEL_AVAILABLE';
- 
 
 149 
                            break;
- 
 
 150 
                    }
- 
 
 151 
 
- 
 
 152 
 
- 
 
 153 
                    $item = [
- 
 
 154 
                        'name' => $record['name'],
- 
 
 155 
                        'user' => $record['first_name'].' '.$record['last_name'],
- 
 
 156 
                        'language' => $language,
- 
 
 157 
                        'status' => $status,
111 
                $items = [];
 158 
                        'link_edit' => $this->url()->fromRoute('profile/self-evaluation/reviews/edit', ['id' => $record['uuid']]),
- 
 
 159 
                    ];
- 
 
 160 
 
112 
 
 161 
                    array_push($items, $item);
113
162 
                }
Línea 114... Línea 163...
114
163 
 
115
164
116 
 
 165 
 
117 
                return new JsonModel([
 166 
                return new JsonModel([
118 
                    'success' => true,
 167 
                    'success' => true,
119 
                    'data' => [
 168 
                    'data' => [
120 
                        'items' => $records,
 169 
                        'items' => $items,
121 
                        'total' => 10,
 170 
                        'total' => 10,