function getBySystemLogIdAndCompanyId($id, $company_id, $where = NULL, $order = NULL)
{
if ($id == '') {
return FALSE;
}
if ($company_id == '') {
return FALSE;
}
if ($order == NULL) {
$order = array('a.field' => 'asc');
$strict = FALSE;
} else {
$strict = TRUE;
}
$uf = new UserFactory();
$lf = new LogFactory();
$ph = array('id' => $id, 'company_id' => $company_id);
$query = '
select a.*
from ' . $this->getTable() . ' as a
LEFT JOIN ' . $lf->getTable() . ' as lf on a.system_log_id = lf.id
LEFT JOIN ' . $uf->getTable() . ' as uf on lf.user_id = uf.id
where a.system_log_id = ?
AND uf.company_id = ?';
$query .= $this->getWhereSQL($where);
$query .= $this->getSortSQL($order);
$this->ExecuteSQL($query, $ph);
return $this;
}