/** * 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); }