iesoretania / atica

        max('order_nr');

}

function getAutoCleaningFolders($orgId) {

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

        select('folder.*')->

        select('category.display_name', 'category_display_name')->

        select_expr('COUNT(*)', 'total')->

        inner_join('folder', array('folder_delivery.folder_id', '=', 'folder.id'))->

        inner_join('category', array('folder.category_id', '=', 'category.id'))->

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

        where('folder.auto_clean', 1)->

        where_null('folder_delivery.snapshot_id')->

        group_by('folder_delivery.folder_id')->

        order_by_asc('folder.category_id')->

        find_array();

    return $data;

}

function archiveFolders($orgId, $snapId, $folders) {

        find_one();

}

function getProfilesByUser($orgId, $personId) {

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

                    select('profile.*')->

                    select('profile_group.display_name_neutral')->

                    select('profile_group.display_name_male')->

                    select('profile_group.display_name_female')->

                    select('profile_group.description', 'profile_group_description')->

                    inner_join('profile_group', array('profile_group.id', '=', 'profile.profile_group_id'))->

                    inner_join('person_profile', array('person_profile.profile_id', '=', 'profile.id'))->

                    where('person_profile.person_id', $personId)->

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

                    order_by_asc('profile_group.display_name_neutral')->

                    find_array();

}

function getProfilesListByUser($orgId, $personId) {

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