Proyectos de Subversion LeadersLinked - Backend

Rev

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

Rev 15726 Rev 15727
Línea 10... Línea 10...
10 
use LeadersLinked\Mapper\UserMapper;
 10 
use LeadersLinked\Mapper\UserMapper;
11 
use LeadersLinked\Mapper\QueryMapper;
 11 
use LeadersLinked\Mapper\QueryMapper;
12 
use LeadersLinked\Mapper\DiscoveryContactMapper;
 12 
use LeadersLinked\Mapper\DiscoveryContactMapper;
13 
use LeadersLinked\Mapper\DiscoveryContactLogMapper;
 13 
use LeadersLinked\Mapper\DiscoveryContactLogMapper;
14 
use Laminas\Mvc\Controller\AbstractActionController;
 14 
use Laminas\Mvc\Controller\AbstractActionController;
- 
 
 15 
use Laminas\Hydrator\ArraySerializableHydrator;
- 
 
 16 
use Laminas\Db\ResultSet\HydratingResultSet;
- 
 
 17 
use Laminas\Paginator\Adapter\DbSelect;
- 
 
 18 
use Laminas\Paginator\Paginator;
Línea 15... Línea 19...
15 
 
 19 
 
16 
// Create an action controller.
 20 
// Create an action controller.
17 
class DiscoveryContactProgressController extends AbstractActionController
 21 
class DiscoveryContactProgressController extends AbstractActionController
18 
{
 22 
{
Línea 96... Línea 100...
96 
                $order_direction = 'ASC';
 100 
                $order_direction = 'ASC';
97 
            }
 101 
            }
Línea 98... Línea 102...
98 
 
 102 
 
99 
 
 103 
 
100 
            //Quede aqui en el mapper
 104 
            //Quede aqui en el mapper
101 
            $discoveryContactMapper = DiscoveryContactLogMapper::getInstance($this->adapter);
 - 
 
102 
            $records = $discoveryContactMapper->fetchAll();
 - 
 
Línea 103... Línea 105...
103 
            $items = [];
 105 
            $discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);
104 
            //$records = $paginator->getCurrentItems();
 106 
            $ContactLogMapper = $discoveryContactLogMapper->fetchAll();
105 
 
 107 
 
106 
            foreach ($records as $record) {
 108 
            foreach ($records as $record) {
107 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 109 
                $queryMapper = QueryMapper::getInstance($this->adapter);
108 
                $sql = $queryMapper->getSql();
 110 
                $sql = $queryMapper->getSql();
109 
                $select = $sql->select();
 111 
                $select = $sql->select();
110 
                $select->columns(['user_id']);
 112 
                $select->columns(['user_id']);
- 
 
 113 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
- 
 
 114 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
- 
 
 115 
                $select->where->equalTo('tb1.company_id', $record->company_id);
- 
 
 116 
 
- 
 
 117 
                if ($search) {
- 
 
 118 
                    $select->where->nest()
- 
 
 119 
                        ->like('first_name', '%' . $search . '%')
- 
 
 120 
                        ->or->like('last_name', '%' . $search . '%')
- 
 
 121 
                        ->or->like('email', '%' . $search . '%')
- 
 
 122 
                        ->unnest();
- 
 
 123 
                }
- 
 
 124 
 
- 
 
 125 
                $select->order($order_field . ' ' . $order_direction);
- 
 
 126 
                hydrator   = new ArraySerializableHydrator();
- 
 
 127 
                $resultset  = new HydratingResultSet($hydrator);
- 
 
 128 
 
- 
 
 129 
                $adapter = new DbSelect($select, $sql, $resultset);
- 
 
 130 
                $paginator = new Paginator($adapter);
- 
 
 131 
                $paginator->setItemCountPerPage($records_x_page);
- 
 
 132 
                $paginator->setCurrentPageNumber($page);
- 
 
 133 
 
111 
                $select->from(['tb1' => DiscoveryContactLogMapper::_TABLE]);
 134 
 
112 
                $select->join(['tb2' => UserMapper::_TABLE], 'tb1.user_id = tb2.id', ['uuid', 'first_name', 'last_name', 'email']);
 135 
                $items = [];
113 
                $select->where->equalTo('tb1.company_id', $record->company_id);
 136 
                $records = $paginator->getCurrentItems();
114 
                return new JsonModel([
 137 
                return new JsonModel([
115 
                    'success' => true,
 138 
                    'success' => true,
116 
                    'message' => $select
 139 
                    'message' => $records
117 
                ]);
 140 
                ]);
118 
            }
 141 
            }