iesoretania / atica

                find_array();

}

function getPersonsByOrganization($orgId) {

    $data = ORM::for_table('person')->

                select('person.id', 'id')->

                select('person.display_name')->

                select('person.user_name')->

                select('person_organization.is_active')->

                inner_join('person_organization', array('person_organization.person_id', '=', 'person.id'))->

                where('person_organization.organization_id', $orgId)->

                order_by_desc('person_organization.is_active')->

                order_by_asc('person.display_name')->

                find_array();

    return parseArray($data);

}

function getProfilesByGroup($id, $orgId, $filter = true) {

    $data = ORM::for_table('profile')->

    return $folders;

}

function getSnapshotsFromFolder($folderId) {

    return ORM::for_table('folder_delivery')->

            distinct()->

            select('snapshot_id')->

            select('snapshot.display_name')->

            select('snapshot.order_nr')->

            inner_join('snapshot', array('snapshot.id', '=', 'folder_delivery.snapshot_id'))->

            where_not_null('snapshot_id')->

            where('folder_id', $folderId)->

            where('snapshot.visible', 1)->

            order_by_desc('snapshot.order_nr')->

            find_many();

}

function getDeliveriesFromFolders($folders, $userProfiles, &$profileGender, $userId, $snapshot = null) {