gistfile1.php

<?php

if (!defined('sugarEntry') || !sugarEntry)
die('Not A Valid Entry Point');

require_once 'modules/Accounts/Account.php';

class AccountDetailView extends Account {

function AccountDetailView() {
parent::Account();
}

function get_all_meetings_related() {

$return_array['select'] = " SELECT meetings.id ";
$return_array['from'] = " FROM meetings ";
$return_array['join'] = " JOIN meetings_contacts ON meetings.id = meetings_contacts.meeting_id ";
$return_array['join'] .= " JOIN accounts_contacts ON meetings_contacts.contact_id = accounts_contacts.contact_id";
$return_array['where'] = " accounts_contacts.account_id = '" . $this->id . "'";

return $return_array;
}

}
?>