Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 283 Rev 284
Línea 15... Línea 15...
15 
use LeadersLinked\Library\Functions;
 15 
use LeadersLinked\Library\Functions;
16 
use LeadersLinked\Mapper\CompanySelfEvaluationFormMapper;
 16 
use LeadersLinked\Mapper\CompanySelfEvaluationFormMapper;
17 
use LeadersLinked\Mapper\CompanySelfEvaluationTestMapper;
 17 
use LeadersLinked\Mapper\CompanySelfEvaluationTestMapper;
18 
use LeadersLinked\Form\CompanySelfEvaluationFormForm;
 18 
use LeadersLinked\Form\CompanySelfEvaluationFormForm;
19 
use LeadersLinked\Model\CompanySelfEvaluationForm;
 19 
use LeadersLinked\Model\CompanySelfEvaluationForm;
20 
use LeadersLinked\Model\UserMapper;
 20 
use LeadersLinked\Mapper\UserMapper;
21 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
 21 
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
22 
use LeadersLinked\Mapper\CompanySelfEvaluationFormUserMapper;
 22 
use LeadersLinked\Mapper\CompanySelfEvaluationFormUserMapper;
Línea 23... Línea 23...
23 
 
 23 
 
Línea 96... Línea 96...
96 
 
 96 
 
97 
                $select = $queryMapper->getSql()->select();
 97 
                $select = $queryMapper->getSql()->select();
98 
                $select->columns(['uuid', 'content','status','user_id']);
 98 
                $select->columns(['uuid', 'content','status','user_id']);
99 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
 99 
                $select->from(['test' => CompanySelfEvaluationTestMapper::_TABLE]);
- 
 
 100 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
Línea 100... Línea 101...
100 
                $select->join(['form' => CompanySelfEvaluationFormMapper::_TABLE], 'test.form_id = form.id', ['name','language']);
 101 
                $select->join(['user' => UserMapper::_TABLE], 'test.user_id = user.id', ['last_name'], Select::JOIN_LEFT_OUTER);
Línea 101... Línea 102...
101 
 
 102 
 
102 
                $select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
 103 
                $select->where->equalTo('form.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
103 
 
 104 
 
104 
                if ($search) {
 105 
                if ($search) {
Línea 105... Línea 106...
105 
                    $select->where->NEST->like('name', '%' . $search . '%');
 106 
                    $select->where->NEST->like('name', '%' . $search . '%');
106 
                }
 107 
                }
107 
                $select->order('name ASC, language ASC');
 - 
 
108 
 
 - 
 
109 
                $records = $queryMapper->fetchAll($select);
 - 
 
110 
                $items = [];
 - 
 
111 
                foreach ($records as $record) {
 - 
 
112 
                    switch ($record['language']) {
 - 
 
113 
                        case CompanySelfEvaluationForm::LANGUAGE_ENGLISH :
 - 
 
114 
                            $language = 'LABEL_ENGLISH';
 - 
 
115 
                            break;
 - 
 
116 
 
 - 
 
117 
                        case CompanySelfEvaluationForm::LANGUAGE_SPANISH :
 - 
 
118 
                            $language = 'LABEL_SPANISH';
 - 
 
119 
                            break;
 - 
 
120 
 
 - 
 
121 
                        default :
 - 
 
122 
                            $language = '';
 - 
 
123 
                            break;
 - 
 
124 
                    }
 - 
 
125 
 
 - 
 
126 
                    switch ($record['status']) {
 - 
 
127 
 
 - 
 
128 
                        case CompanySelfEvaluationTest::STATUS_DRAFT :
 - 
 
129 
                            $status = 'LABEL_DRAFT';
 - 
 
130 
                            break;
 - 
 
131 
 
 - 
 
132 
                        case CompanySelfEvaluationTest::STATUS_COMPLETED :
 - 
 
133 
                            $status = 'LABEL_COMPLETED';
 - 
 
134 
                            break;
 - 
 
135 
 
 - 
 
136 
                        case CompanySelfEvaluationTest::STATUS_PENDING :
 - 
 
137 
                            $status = 'LABEL_PENDING';
 - 
 
138 
                            break;
 - 
 
139 
 
 - 
 
140 
                        case CompanySelfEvaluationTest::STATUS_REVIEW :
 - 
 
141 
                            $status = 'LABEL_REVIEW';
 - 
 
142 
                            break;
 - 
 
143 
 
 - 
 
144 
 
 - 
 
145 
                        default :
 - 
 
146 
                            $status = 'LABEL_AVAILABLE';
 - 
 
147 
                            break;
 - 
 
148 
                    }
 - 
 
149 
 
 - 
 
150 
                    $UserMapper = UserMapper::getInstance($this->adapter);
 - 
 
151 
        $user = $UserMapper->fetchOne($record['user_id']);
 - 
 
152 
        if($user){
 - 
 
153 
 
 - 
 
154 
            $item = [
 - 
 
155 
                'name' => $record['name'],
 - 
 
156 
                'text' => $record['text'],
 - 
 
157 
                'language' => $language,
 - 
 
158 
                'status' => $status,
 - 
 
159 
                'user'=>$user->email,
 - 
 
160 
                'link_edit' => $this->url()->fromRoute('self-evaluation/reviews/edit/', ['id' => $record['uuid']]),
 - 
 
161 
            ];
 - 
 
162 
 
 - 
 
163 
            array_push($items, $item);
 - 
 
164 
 
 - 
 
165 
        }
 - 
 
166 
 
 - 
 
167
- 
 
Línea -... Línea 108...
- 
 
 108 
                $select->order('name ASC, language ASC');
168 
 
 109 
 
Línea 169... Línea 110...
169 
 
 110 
                $records = $queryMapper->fetchAll($select);
170
111 
                $items = [];
171 
                }
 112 
 
172 
 
 113
173
114
174 
 
 115
175 
 
 116 
 
176 
                return new JsonModel([
 117 
                return new JsonModel([