public function listCompanyBranchsByUserProfile($id_user, $id_profile, $isActive = NULL)
{
$select_company_branch = $this->buildSelectFields('cb_', 'cb', 'company_branch');
$sql = '
SELECT
' . $select_company_branch . '
FROM
"' . $this->table . '" AS "upcb"
INNER JOIN "user_profile" AS "up" ON "up"."id" = "upcb"."id_user_profile"
INNER JOIN "profile" AS "p" ON "p"."id" = "up"."id_profile"
INNER JOIN "user" AS "u" ON "u"."id" = "up"."id_user"
INNER JOIN "company_branch" AS "cb" ON "cb"."id" = "upcb"."id_company_branch"
WHERE 1=1
AND "p"."id" = ' . $this->db->escape($id_profile) . '
AND "u"."id" = ' . $this->db->escape($id_user) . '
' . (is_null($isActive) ? '' : " AND \"cb\".\"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();
$eCompanyBranches = array();
if (!empty($rows)) {
foreach ($rows as $row) {
$eCompanyBranch = new eCompanyBranch();
$eCompanyBranch->parseRow($row, 'cb_');
$eCompanyBranches[] = $eCompanyBranch;
}
}
return $eCompanyBranches;
}
function filter(filterCompanyBranch $filter, &$eCompanyBranches, &$count = NULL)
{
$eCompanyBranches = 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) {
$eCompanyBranch = new eCompanyBranch();
$eCompanyBranch->parseRow($row, 'cb_');
$eCompanyBranches[] = $eCompanyBranch;
}
}
}
