Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 4114 Rev 4283
Línea 6... Línea 6...
6 
use LeadersLinked\Mapper\UserMapper;
 6 
use LeadersLinked\Mapper\UserMapper;
7 
use LeadersLinked\Model\UserType;
 7 
use LeadersLinked\Model\UserType;
8 
use LeadersLinked\Mapper\ConnectionMapper;
 8 
use LeadersLinked\Mapper\ConnectionMapper;
9 
use LeadersLinked\Mapper\LocationMapper;
 9 
use LeadersLinked\Mapper\LocationMapper;
10 
use LeadersLinked\Mapper\ProfileVisitMapper;
 10 
use LeadersLinked\Mapper\ProfileVisitMapper;
11 
use LeadersLinked\Model\CompanySelfEvaluationFormUser;
 11 
use LeadersLinked\Model\SelfEvaluationFormUser;
12 
use LeadersLinked\Mapper\CompanySelfEvaluationFormUserMapper;
 12 
use LeadersLinked\Mapper\SelfEvaluationFormUserMapper;
13 
use LeadersLinked\Mapper\QueryMapper;
 13 
use LeadersLinked\Mapper\QueryMapper;
14 
use Laminas\Db\Sql\Expression;
 14 
use Laminas\Db\Sql\Expression;
15 
use LeadersLinked\Mapper\CompanySelfEvaluationFormMapper;
 15 
use LeadersLinked\Mapper\SelfEvaluationFormMapper;
16 
use LeadersLinked\Model\CompanySelfEvaluationForm;
 16 
use LeadersLinked\Model\SelfEvaluationForm;
Línea 17... Línea 17...
17 
 
 17 
 
18 
class MenuHelper extends AbstractHelper
 18 
class MenuHelper extends AbstractHelper
19 
{
 19 
{
20 
    /**
 20 
    /**
Línea 56... Línea 56...
56 
            /*
 56 
            /*
57 
            $queryMapper = QueryMapper::getInstance($this->adapter);
 57 
            $queryMapper = QueryMapper::getInstance($this->adapter);
Línea 58... Línea 58...
58
58
59 
            $select = $queryMapper->getSql()->select();
 59 
            $select = $queryMapper->getSql()->select();
60 
            $select->columns(['total' => new Expression('COUNT(*)')]);
 60 
            $select->columns(['total' => new Expression('COUNT(*)')]);
61 
            $select->from(['u' => CompanySelfEvaluationFormUserMapper::_TABLE]);
 61 
            $select->from(['u' => SelfEvaluationFormUserMapper::_TABLE]);
62 
            $select->join(['f' => CompanySelfEvaluationFormMapper::_TABLE], 'u.form_id  = f.id');
 62 
            $select->join(['f' => SelfEvaluationFormMapper::_TABLE], 'u.form_id  = f.id');
63 
            $select->where->equalTo('u.user_i', $user_id);
 63 
            $select->where->equalTo('u.user_i', $user_id);
Línea 64... Línea 64...
64 
            $select->where->equalTo('f.status', CompanySelfEvaluationForm::STATUS_ACTIVE);
 64 
            $select->where->equalTo('f.status', SelfEvaluationForm::STATUS_ACTIVE);
65
65