Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15725 Rev 15726
Línea 108... Línea 108...
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);
 - 
 
115 
                // $select->where->equalTo('tb1.capsule_id', $record->id);
 - 
 
116 
                // $select->where->equalTo('tb2.status', User::STATUS_ACTIVE);
 - 
 
117 
                // $select->order('first_name ASC, last_name ASC');
 - 
 
118 
                return new JsonModel([
 114 
                return new JsonModel([
119 
                    'success' => true,
 115 
                    'success' => true,
120 
                    'message' => $sql
 116 
                    'message' => $select
121 
                ]);
 117 
                ]);
122 
            }
 118 
            }
123 
            // } else {
 119 
            // } else {
124 
            // }
 120 
            // }
125 
        }
 121 
        }