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; }