function getReportByCompanyIdAndUserIDList($company_id, $user_ids, $order = NULL)
{
if ($company_id == '') {
return FALSE;
}
if ($user_ids == '') {
return FALSE;
}
/*
if ( $order == NULL ) {
$order = array( 'status_id' => 'asc', 'last_name' => 'asc' );
$strict = FALSE;
} else {
$strict = TRUE;
}
*/
// $utf = new UserTaxFactory();
// LEFT JOIN '. $utf->getTable() .' as b ON a.id = b.user_id AND (b.deleted=0 OR b.deleted IS NULL)
$baf = new BankAccountFactory();
$ph = array('company_id' => $company_id);
$query = '
select c.*,a.*
from ' . $this->getTable() . ' as a
LEFT JOIN ' . $baf->getTable() . ' as c ON a.id = c.user_id AND (c.deleted=0 OR c.deleted IS NULL)
where
a.company_id = ?
AND a.id in (' . $this->getListSQL($user_ids, $ph) . ')
AND ( a.deleted = 0 )
';
$query .= $this->getSortSQL($order, FALSE);
$this->ExecuteSQL($query, $ph);
return $this;
}
