Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15724 Rev 15725
Línea 107... Línea 107...
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' => DiscoveryContactLogMapper::_TABLE]);
 111 
                $select->from(['tb1' => DiscoveryContactLogMapper::_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' => $select
 120 
                    'message' => $sql
121 
                ]);
 121 
                ]);
122 
            }
 122 
            }
123 
            // } else {
 123 
            // } else {
124 
            // }
 124 
            // }
125 
        }
 125 
        }