| Línea 15... |
Línea 15... |
| 15 |
use Laminas\Paginator\Paginator;
|
15 |
use Laminas\Paginator\Paginator;
|
| 16 |
use Laminas\Paginator\Adapter\DbSelect;
|
16 |
use Laminas\Paginator\Adapter\DbSelect;
|
| 17 |
use Laminas\Db\ResultSet\HydratingResultSet;
|
17 |
use Laminas\Db\ResultSet\HydratingResultSet;
|
| 18 |
use LeadersLinked\Model\UserType;
|
18 |
use LeadersLinked\Model\UserType;
|
| 19 |
use LeadersLinked\Model\CompanyUser;
|
19 |
use LeadersLinked\Model\CompanyUser;
|
| 20 |
use LeadersLinked\Model\CompanyMicrolearningCapsuleUser;
|
20 |
use LeadersLinked\Model\MicrolearningCapsuleUser;
|
| Línea 21... |
Línea 21... |
| 21 |
|
21 |
|
| 22 |
|
22 |
|
| 23 |
class UserMapper extends MapperCommon
|
23 |
class UserMapper extends MapperCommon
|
| Línea 845... |
Línea 845... |
| 845 |
|
845 |
|
| 846 |
$update = $this->sql->update(self::_TABLE);
|
846 |
$update = $this->sql->update(self::_TABLE);
|
| 847 |
$update->set($values);
|
847 |
$update->set($values);
|
| Línea 848... |
Línea 848... |
| 848 |
$update->where->equalTo('id', $user->id);
|
848 |
$update->where->equalTo('id', $user->id);
|
| Línea 849... |
Línea 849... |
| 849 |
|
849 |
|
| 850 |
//echo $update->getSqlString($this->adapter->platform); exit;
|
850 |
//echo $update->getSqlString($this->adapter->platform); exit;
|
| Línea 851... |
Línea 851... |
| 851 |
|
851 |
|
| Línea 1077... |
Línea 1077... |
| 1077 |
{
|
1077 |
{
|
| 1078 |
$date = date('Y-m-d');
|
1078 |
$date = date('Y-m-d');
|
| Línea 1079... |
Línea 1079... |
| 1079 |
|
1079 |
|
| 1080 |
$selectCapsuleUser = $this->getSql()->select();
|
1080 |
$selectCapsuleUser = $this->getSql()->select();
|
| 1081 |
$selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')]);
|
1081 |
$selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')]);
|
| 1082 |
$selectCapsuleUser->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
|
1082 |
$selectCapsuleUser->from(MicrolearningCapsuleUserMapper::_TABLE);
|
| 1083 |
$selectCapsuleUser->where->equalTo('company_id', $company_id);
|
1083 |
$selectCapsuleUser->where->equalTo('company_id', $company_id);
|
| 1084 |
$selectCapsuleUser->where->nest->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
|
1084 |
$selectCapsuleUser->where->nest->equalTo('access', MicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
|
| 1085 |
->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
|
1085 |
->equalTo('access', MicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
|
| 1086 |
->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)
|
1086 |
->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)
|
| Línea 1087... |
Línea 1087... |
| 1087 |
->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date)->unnest()->unnest();
|
1087 |
->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date)->unnest()->unnest();
|
| Línea 1133... |
Línea 1133... |
| 1133 |
|
1133 |
|
| Línea 1134... |
Línea 1134... |
| 1134 |
$date = date('Y-m-d');
|
1134 |
$date = date('Y-m-d');
|
| 1135 |
|
1135 |
|
| 1136 |
$selectCapsuleUser = $this->getSql()->select();
|
1136 |
$selectCapsuleUser = $this->getSql()->select();
|
| 1137 |
$selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')]);
|
1137 |
$selectCapsuleUser->columns(['user_id' => new Expression('DISTINCT(user_id)')]);
|
| 1138 |
$selectCapsuleUser->from(CompanyMicrolearningCapsuleUserMapper::_TABLE);
|
1138 |
$selectCapsuleUser->from(MicrolearningCapsuleUserMapper::_TABLE);
|
| 1139 |
$selectCapsuleUser->where->equalTo('company_id', $company_id);
|
1139 |
$selectCapsuleUser->where->equalTo('company_id', $company_id);
|
| 1140 |
$selectCapsuleUser->where->nest->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
|
1140 |
$selectCapsuleUser->where->nest->equalTo('access', MicrolearningCapsuleUser::ACCESS_UNLIMITED)->or->nest()
|
| 1141 |
->equalTo('access', CompanyMicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
|
1141 |
->equalTo('access', MicrolearningCapsuleUser::ACCESS_PAY_PERIOD)
|
| Línea 1142... |
Línea 1142... |
| 1142 |
->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)
|
1142 |
->and->lessThanOrEqualTo(new Expression('DATE(paid_from)'), $date)
|
| 1143 |
->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date)->unnest()->unnest();
|
1143 |
->and->greaterThanOrEqualTo(new Expression('DATE(paid_to)'), $date)->unnest()->unnest();
|
| Línea 1689... |
Línea 1689... |
| 1689 |
|
1689 |
|
| Línea 1690... |
Línea 1690... |
| 1690 |
$prototype = User();
|
1690 |
$prototype = User();
|
| 1691 |
|
1691 |
|
| - |
|
1692 |
return $this->executeFetchAllObject($select, $prototype);
|
| - |
|
1693 |
}
|
| - |
|
1694 |
|
| - |
|
1695 |
|
| - |
|
1696 |
|
| - |
|
1697 |
/**
|
| - |
|
1698 |
*
|
| - |
|
1699 |
* @param string $username_inmail
|
| - |
|
1700 |
* @param int $network_id
|
| - |
|
1701 |
* @return void|User
|
| - |
|
1702 |
*/
|
| - |
|
1703 |
public function fetchOneByUsernameInmailAndNetworkId($username_inmail, $network_id)
|
| - |
|
1704 |
{
|
| - |
|
1705 |
$prototype = new User();
|
| - |
|
1706 |
$select = $this->sql->select(self::_TABLE);
|
| - |
|
1707 |
$select->where->equalTo('username_inmail', $username_inmail);
|
| - |
|
1708 |
$select->where->equalTo('network_id', $network_id);
|
| - |
|
1709 |
$select->where->equalTo('status', User::STATUS_ACTIVE);
|
| - |
|
1710 |
|
| - |
|
1711 |
|
| - |
|
1712 |
//echo $select->getSqlString($this->adapter->platform); exit;
|
| - |
|
1713 |
|
| 1692 |
return $this->executeFetchAllObject($select, $prototype);
|
1714 |
return $this->executeFetchOneObject($select, $prototype);
|