Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15743 Rev 15744
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', 'details']);
 113 
                $select->columns(['user_id', 'activity', 'details', 'added_on']);
114 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details']);
 114 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE], ['activity', 'details', 'added_on']);
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 135... Línea 135...
135 
 
 135 
 
136 
                $items = [];
 136 
                $items = [];
137 
                $records = $paginator->getCurrentItems();
 137 
                $records = $paginator->getCurrentItems();
Línea 138... Línea 138...
138 
                foreach ($records as $record) {
 138 
                foreach ($records as $record) {
139 
 
 139 
 
140 
                    // $dt_added_on = \DateTime::createFromFormat('Y-m-d H:i:s', $record['added_on']);
 140 
                    $dt_added_on = \DateTime::createFromFormat('Y-m-d H:i:s', $record['added_on']);
141 
                    // $added_on = $dt_added_on->format('d/m/Y h:i a');
 141 
                    $added_on = $dt_added_on->format('d/m/Y h:i a');
142 
                    $item = [
 142 
                    $item = [
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 
                        'details' => $record['details'],
 149 
                        'details' => $record['details'],
150 
                        //'text' => $record['text'],
 150 
                        //'text' => $record['text'],
Línea 151... Línea 151...
151 
                        //'added_on' => $added_on,
 151 
                        'added_on' => $added_on,
152 
                    ];
 152 
                    ];