Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
 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;
 }
Ejemplo n.º 3
0
    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;
    }