/**
* Return number of company users
*
* @access public
* @param void
* @return integer
*/
function countUsers()
{
$users_table = Users::instance()->getTableName(true);
$contacts_table = Contacts::instance()->getTableName(true);
$escaped_pk = is_array($pk_columns = Companies::getPkColumns()) ? '*' : DB::escapeField($pk_columns);
$users = array();
$sql = "SELECT COUNT({$users_table}.{$escaped_pk}) AS 'row_count' FROM {$users_table}, {$contacts_table} WHERE ({$users_table}.`id` = {$contacts_table}.`user_id` AND {$contacts_table}.`company_id` = " . DB::escape($this->getId()) . " )";
$row = DB::executeOne($sql);
return (int) array_var($row, 'row_count', 0);
}
