move.tcl

Multiple move page. Supports any file-storage supported content_item Allows move of single or multiple items

Location:
/packages/file-storage/www/move.tcl
Author:

Dave Bauer dave@thedesignexperience.org
File Contents

ad_page_contract {

    Multiple move page.
    Supports any file-storage supported content_item
    Allows move of single or multiple items

    @author Dave Bauer dave@thedesignexperience.org

} -query {
    object_id:notnull,integer,multiple
    folder_id:naturalnum,optional
    {return_url:localurl ""}
    {root_folder_id:integer ""}
    {redirect_to_folder:boolean,notnull 0}
    {show_items:boolean,notnull 0}
} -errors {object_id:,notnull,integer,multiple {Please select at least one item to move.}
}

set peer_addr [ad_conn peeraddr]
set package_id [ad_conn package_id]
set copy_and_delete_p [parameter::get -parameter MoveByCopyDeleteP -package_id $package_id -default 0]

set objects_to_move $object_id
set object_id_list [join $object_id ","]

set user_id [ad_conn user_id]

set allowed_count 0
set not_allowed_count 0
set not_allowed_parents [list]
set not_allowed_children [list]

db_multirow -extend {move_message} move_objects get_move_objects [subst {
      select fs.object_id, fs.name, fs.type, fs.parent_id,
      acs_permission.permission_p(fs.object_id, :user_id, 'delete') as move_p
      from fs_objects fs
      where fs.object_id in ([ns_dbquotelist $object_id])
    order by move_p
}] {
    if {$move_p} {
    set move_message ""
    incr allowed_count
    } else {
    set move_message [_ file-storage.Not_Allowed]
    incr not_allowed_count
    }
    if {$type eq "folder"} {
        lappend not_allowed_children $object_id
    }
    # prevent people from selecting source folder as destination
    # folder
    lappend not_allowed_parents $parent_id
}

set total_count [template::multirow size move_objects]

if {$not_allowed_count > 0} {
    set show_items 1
}

if {[info exists folder_id]} {

    permission::require_permission \
        -party_id $user_id \
        -object_id $folder_id \
        -privilege "write"


    # check for WRITE permission on each object to be moved
    # DaveB: I think it should be DELETE instead of WRITE
    # but the existing file-move page checks for WRITE
    set error_items {}
    template::multirow foreach move_objects {

        if {[content::item::get_id_by_name \
                 -name $name -parent_id $folder_id] ne ""} {
            ns_log Notice "item $name exists already in folder $folder_id"
            lappend error_items $name
        } else {
            db_transaction {
                if {$copy_and_delete_p} {
                    # copy and delete file to move it
                    set file_id [content::item::copy -item_id $object_id \
                                     -target_folder_id $folder_id \
                                     -creation_user    $user_id \
                                     -creation_ip      $peer_addr]
                    if {$type ne "folder" } {
                        callback fs::file_revision_new \
                            -package_id $package_id \
                            -file_id    $file_id \
                            -parent_id  $folder_id
                        fs::delete_file \
                            -item_id   $object_id \
                            -parent_id $parent_id
                    } else {
                        fs::delete_folder \
                            -folder_id $object_id \
                            -parent_id $parent_id
                    }
                } else {
                    # execute move command
                    content::item::move \
                        -item_id          $object_id \
                        -target_folder_id $folder_id
                }
            } on_error {
                lappend error_items $name
            }
        }
    }

    if {[llength $error_items]} {
        set message "[_ file-storage.There_was_a_problem_moving_the_following_items]: [join $error_items ", "]"
    } else {
        set message [_ file-storage.Selected_items_have_been_moved]
    }
    ad_returnredirect -message $message $return_url
    ad_script_abort

 } else {

    template::list::create \
    -name move_objects \
    -multirow move_objects \
    -elements {
        name {label \#file-storage.Files_to_be_moved\#}
        move_message {}
    }

    template::list::create \
        -name folder_tree \
        -pass_properties { item_id redirect_to_folder return_url } \
        -multirow folder_tree \
        -key folder_id \
        -no_data [_ file-storage.No_valid_destination_folders_exist] \
        -elements {
            label {
                label "\#file-storage.Choose_Destination_Folder\#"
                display_template {
                    <if @folder_tree.move_url@ nil>
                    <div style="padding-left: @folder_tree.level_num@em;">@folder_tree.label@</div>
                    </if><else>@folder_tree.label@</else>
                }
                link_url_col move_url
                link_html {title "\#file-storage.Move_to_folder_title\#" style "padding-left: @folder_tree.level_num@em;"}
            }
        }

    if {$root_folder_id eq ""} {
    set root_folder_id [fs::get_root_folder]
    }
    set object_id $objects_to_move
    set cancel_url "[ad_conn url]?[ad_conn query]"
    db_multirow -extend {move_url} folder_tree get_folder_tree {
        with recursive folder_tree (folder_id, parent_id, label, level_num, tree_sortkey) as (
            select cf.folder_id, cif.parent_id, cf.label, 0 as level_num, cast(cif.parent_id as text) as tree_sortkey
            from cr_folders cf, cr_items cif
            where cf.folder_id = :root_folder_id
              and cf.folder_id = cif.item_id
            and acs_permission.permission_p(cf.folder_id, :user_id, 'write')

            union all

            select cf.folder_id, cif.parent_id, cf.label, level_num + 1 as level_num, t.tree_sortkey || '|' || cif.parent_id as tree_sortkey
            from cr_folders cf, cr_items cif, folder_tree t
            where cif.parent_id = t.folder_id
              and cf.folder_id = cif.item_id
              and acs_permission.permission_p(cf.folder_id, :user_id, 'write')
       ) select folder_id, parent_id, label, level_num
           from folder_tree
          order by tree_sortkey asc, label asc
    } {
    # teadams 2003-08-22 - change level to level num to avoid
    # Oracle issue with key words.
        if {$folder_id in [concat $not_allowed_parents $not_allowed_children]
        || $parent_id in $not_allowed_children
    } {
            if {$parent_id in $not_allowed_children} {
                lappend not_allowed_children $folder_id
            }
            set move_url ""
        } else {
            set target_url [export_vars -base "[ad_conn package_url]move" { object_id:multiple folder_id return_url }]
            #    set move_url [export_vars -base "file-upload-confirm" {folder_id cancel_url {return_url $target_url}}]
            set move_url $target_url
        }
    }

}

set context [list "\#file-storage.Move\#"]
set title "\#file-storage.Move\#"

# Local variables:
#    mode: tcl
#    tcl-indent-level: 4
#    indent-tabs-mode: nil
# End:
move.tcl

Related Files

File Contents
