function filter(filterProfile $filter, &$eProfiles, &$eRols = NULL, &$count = NULL)
{
$eProfiles = array();
$eRols = array();
$count = 0;
$queryR = $this->db->query($this->filterQuery($filter));
if ($queryR === FALSE) {
Helper_Log::write($this->messageError(__FUNCTION__, FALSE), Helper_Log::LOG_DB);
throw new Exception("Problema ejecución en Base de Datos, ver log de errores. Consulte con Sistemas");
}
$queryC = $this->db->query($this->filterQuery($filter, TRUE));
if ($queryC === FALSE) {
Helper_Log::write($this->messageError(__FUNCTION__, FALSE), Helper_Log::LOG_DB);
throw new Exception("Problema ejecución en Base de Datos, ver log de errores. Consulte con Sistemas");
}
$row = $queryC->row_array();
$count = $row['count'];
$rows = $queryR->result_array();
if (!empty($rows)) {
foreach ($rows as $row) {
$eProfile = new eProfile();
$eRol = new eRol();
$eProfile->parseRow($row, 'p_');
$eRol->parseRow($row, 'r_');
$eProfiles[] = $eProfile;
$eRols[] = $eRol;
}
}
}
public function listProfilesByUser($id_user, $isActive = NULL)
{
$select_profile = $this->buildSelectFields('p_', 'p', 'profile');
$sql = '
SELECT
' . $select_profile . '
FROM
"' . $this->table . '" AS "up"
INNER JOIN "profile" AS "p" ON "p"."id" = "up"."id_profile"
INNER JOIN "user" AS "u" ON "u"."id" = "up"."id_user"
WHERE 1=1
AND "u"."id" = ' . $this->db->escape($id_user) . '
' . (is_null($isActive) ? '' : " AND \"p\".\"isActive\"='" . $isActive . "'") . '
';
$query = $this->db->query($sql);
if ($query === FALSE) {
Helper_Log::write($this->messageError(__FUNCTION__, FALSE), Helper_Log::LOG_DB);
throw new Exception("Problema ejecución en Base de Datos, ver log de errores. Consulte con Sistemas");
}
$rows = $query->result_array();
$eProfiles = array();
if (!empty($rows)) {
foreach ($rows as $row) {
$eProfile = new eProfile();
$eProfile->parseRow($row, 'p_');
$eProfiles[] = $eProfile;
}
}
return $eProfiles;
}
