Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15720 Rev 15721
Línea 102... Línea 102...
102 
            $records = $discoveryContactMapper->fetchAll();
 102 
            $records = $discoveryContactMapper->fetchAll();
103 
            $items = [];
 103 
            $items = [];
104 
            //$records = $paginator->getCurrentItems();
 104 
            //$records = $paginator->getCurrentItems();
Línea 105... Línea 105...
105 
 
 105 
 
106 
            foreach ($records as $record) {
 106 
            foreach ($records as $record) {
107 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 107 
                // $queryMapper = QueryMapper::getInstance($this->adapter);
108 
                $sql = $queryMapper->getSql();
 108 
                // $sql = $queryMapper->getSql();
109 
                $select = $sql->select();
 109 
                // $select = $sql->select();
110 
                $select->columns(['user_id']);
 110 
                // $select->columns(['user_id']);
111 
                $select->from(['tb1' => DiscoveryContactMapper::_TABLE]);
 111 
                // $select->from(['tb1' => DiscoveryContactMapper::_TABLE]);
112 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
 112 
                // $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
113 
                $select->where->equalTo('tb1.company_id', $record->company_id);
 113 
                // $select->where->equalTo('tb1.company_id', $record->company_id);
114 
                $select->where->equalTo('tb1.topic_id', $record->topic_id);
 114 
                // $select->where->equalTo('tb1.topic_id', $record->topic_id);
115 
                $select->where->equalTo('tb1.capsule_id', $record->id);
 115 
                // $select->where->equalTo('tb1.capsule_id', $record->id);
116 
                $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
 116 
                // $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
117 
                $select->order('first_name ASC, last_name ASC');
 117 
                // $select->order('first_name ASC, last_name ASC');
118 
                return new JsonModel([
 118 
                return new JsonModel([
119 
                    'success' => true,
 119 
                    'success' => true,
120 
                    'message' => $record->company_id
 120 
                    'message' => $record->company_id
121 
                ]);
 121 
                ]);