Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 17160 Rev 17161
Línea 240... Línea 240...
240 
                        $select = $sql->select();
 240 
                        $select = $sql->select();
241 
                        $select->columns(['access', 'paid_from', 'paid_to', 'added_on', 'updated_on']);
 241 
                        $select->columns(['access', 'paid_from', 'paid_to', 'added_on', 'updated_on']);
242 
                        $select->from(['tb1' => MicrolearningCapsuleUserMapper::_TABLE] );
 242 
                        $select->from(['tb1' => MicrolearningCapsuleUserMapper::_TABLE] );
243 
                        $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
 243 
                        $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
244 
                        $select->where->equalTo('tb1.company_id', $capsule->company_id);
 244 
                        $select->where->equalTo('tb1.company_id', $capsule->company_id);
245 
                        $select->where->equalTo('tb1.topic_id', $capsule->topic_id);
 245 
                        $select->where->equalTo('tb1.topic_id', $topic->id);
246 
                        $select->where->equalTo('tb1.capsule_id', $capsule->id);
 246 
                        $select->where->equalTo('tb1.capsule_id', $capsule->id);
Línea 247... Línea 247...
247
247
248 
                        if($search) {
 248 
                        if($search) {
249 
                            $select->where->nest()
 249 
                            $select->where->nest()