function getInstancesQueryComps($params, $logic, $order)
{
$res = parent::getInstancesQueryComps($params, $logic, $order);
$res['from'] = '(' . $res['from'] . ') LEFT OUTER JOIN person creator ON note_comment.creator = creator.id';
$res['select'][] = 'creator.first_name as creator_fn';
$res['select'][] = 'creator.last_name as creator_ln';
return $res;
}
function getInstancesQueryComps($params, $logic, $order)
{
$res = parent::getInstancesQueryComps($params, $logic, $order);
$res['from'] = '(' . $res['from'] . ') LEFT OUTER JOIN person creator ON abstract_note.creator = creator.id';
$res['from'] = '(' . $res['from'] . ') LEFT OUTER JOIN person assignee ON abstract_note.assignee = assignee.id';
$res['select'][] = 'creator.first_name as creator_fn';
$res['select'][] = 'creator.last_name as creator_ln';
$res['select'][] = 'assignee.first_name as assignee_fn';
$res['select'][] = 'assignee.last_name as assignee_ln';
return $res;
}
function getInstancesQueryComps($params, $logic, $order)
{
$res = parent::getInstancesQueryComps($params, $logic, $order);
$res['select'][] = 'f.family_name, f.address_street, f.address_suburb, f.address_state, f.address_postcode, f.home_tel, c.name as congregation';
$res['from'] = '((' . $res['from'] . ')
JOIN family f ON person.familyid = f.id)
LEFT OUTER JOIN congregation c ON person.congregationid = c.id';
return $res;
}