Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15731 Rev 15732
Línea 14... Línea 14...
14 
use Laminas\Mvc\Controller\AbstractActionController;
 14 
use Laminas\Mvc\Controller\AbstractActionController;
15 
use Laminas\Hydrator\ArraySerializableHydrator;
 15 
use Laminas\Hydrator\ArraySerializableHydrator;
16 
use Laminas\Db\ResultSet\HydratingResultSet;
 16 
use Laminas\Db\ResultSet\HydratingResultSet;
17 
use Laminas\Paginator\Adapter\DbSelect;
 17 
use Laminas\Paginator\Adapter\DbSelect;
18 
use Laminas\Paginator\Paginator;
 18 
use Laminas\Paginator\Paginator;
- 
 
 19 
use LeadersLinked\Mapper\CompanyMapper;
Línea 19... Línea 20...
19 
 
 20 
 
20 
// Create an action controller.
 21 
// Create an action controller.
21 
class DiscoveryContactProgressController extends AbstractActionController
 22 
class DiscoveryContactProgressController extends AbstractActionController
22 
{
 23 
{
Línea 110... Línea 111...
110 
                $sql = $queryMapper->getSql();
 111 
                $sql = $queryMapper->getSql();
111 
                $select = $sql->select();
 112 
                $select = $sql->select();
112 
                $select->columns(['user_id']);
 113 
                $select->columns(['user_id']);
113 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
 114 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
114 
                $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']);
115 
                //$select->where->equalTo('tb1.company_id', $contactLogMapper->company_id);
 117 
                //$select->where->equalTo('tb1.company_id', $contactLogMapper->company_id);
Línea 116... Línea 118...
116 
 
 118 
 
117 
                if ($search) {
 119 
                if ($search) {
118 
                    $select->where->nest()
 120 
                    $select->where->nest()