Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15738 Rev 15739
Línea 108... Línea 108...
108 
 
 108 
 
109 
            foreach ($contactLogMappers as $contactLogMapper) {
 109 
            foreach ($contactLogMappers as $contactLogMapper) {
110 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 110 
                $queryMapper = QueryMapper::getInstance($this->adapter);
111 
                $sql = $queryMapper->getSql();
 111 
                $sql = $queryMapper->getSql();
112 
                $select = $sql->select();
 112 
                $select = $sql->select();
113 
                $select->columns(['user_id', 'activity']);
 113 
                $select->columns(['user_id']);
114 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
 114 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity']);
115 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
 115 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
116 
                $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
 116 
                $select->join(['tb3' => CompanyMapper::_TABLE], 'tb1.company_id = tb3.id', ['name']);
Línea 117... Línea 117...
117 
                //$select->where->equalTo('tb1.company_id', $contactLogMapper->company_id);
 117 
                //$select->where->equalTo('tb1.company_id', $contactLogMapper->company_id);
Línea 143... Línea 143...
143 
                        'uuid' => $record['uuid'],
 143 
                        'uuid' => $record['uuid'],
144 
                        'first_name' => ucwords(strtolower($record['first_name'])),
 144 
                        'first_name' => ucwords(strtolower($record['first_name'])),
145 
                        'last_name' => ucwords(strtolower($record['last_name'])),
 145 
                        'last_name' => ucwords(strtolower($record['last_name'])),
146 
                        'email' => strtolower($record['email']),
 146 
                        'email' => strtolower($record['email']),
147 
                        'company' => $record['name'],
 147 
                        'company' => $record['name'],
148 
                        //'activity' => $record['activity'],
 148 
                        'activity' => $record['activity'],
149 
                        //'text' => $record['text'],
 149 
                        //'text' => $record['text'],
150 
                        //'added_on' => $added_on,
 150 
                        //'added_on' => $added_on,
151 
                    ];
 151 
                    ];