require_once 'include/database/PearDatabase.php'; global $current_user; if ($current_user->is_admin != 'on') { echo 'NOT_PERMITTED'; die; } else { $new_folderid = $_REQUEST['folderid']; $idlist = vtlib_purify($_REQUEST['idlist']); $excludedRecords = vtlib_purify($_REQUEST['excludedRecords']); if (isset($_REQUEST['idlist']) && $_REQUEST['idlist'] != '') { $id_array = array(); $id_array = getSelectedRecords($_REQUEST, 'Documents', $idlist, $excludedRecords); //explode(';',$_REQUEST['idlist']); $id_array = array_filter($id_array); for ($i = 0; $i < count($id_array); $i++) { ChangeFolder($id_array[$i], $new_folderid); } header("Location: index.php?action=DocumentsAjax&file=ListView&mode=ajax&module=Documents"); } } /** To Change the Documents to another folder * @param $recordid -- The file id * @param $new_folderid -- The folderid to which the file to be moved * @returns nothing */ function ChangeFolder($recordid, $new_folderid) { global $adb; $sql = "update vtiger_notes set folderid=" . $new_folderid . " where notesid in (" . $recordid . ")"; $res = $adb->pquery($sql, array()); }
* The Initial Developer of the Original Code is vtiger. * Portions created by vtiger are Copyright (C) vtiger. * All Rights Reserved. * ********************************************************************************/ require_once 'include/logging.php'; require_once 'include/database/PearDatabase.php'; $folderid = vtlib_purify($_REQUEST['folderid']); if (isset($_REQUEST['idlist']) && $_REQUEST['idlist'] != '') { $id_array = array(); $id_array = explode(':', $_REQUEST['idlist']); for ($i = 0; $i < count($id_array) - 1; $i++) { ChangeFolder($id_array[$i], $folderid); } header("Location: index.php?action=ReportsAjax&file=ListView&mode=ajaxdelete&module=Reports"); } elseif (isset($_REQUEST['record']) && $_REQUEST['record'] != '') { $id = vtlib_purify($_REQUEST["record"]); ChangeFolder($id, $folderid); header("Location: index.php?action=ReportsAjax&file=ListView&mode=ajaxdelete&module=Reports"); } /** To Change the Report to another folder * @param $reportid -- The report id * @param $folderid -- The folderid the which the report to be moved * @returns nothing */ function ChangeFolder($reportid, $folderid) { global $adb; $imovereportsql = "update vtiger_report set folderid=? where reportid=?"; $imovereportsqlresult = $adb->pquery($imovereportsql, array($folderid, $reportid)); }