/
SaveFolder.php
61 lines (58 loc) · 2.62 KB
/
SaveFolder.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<?php
/*+*******************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
********************************************************************************/
require_once 'modules/Documents/Documents.php';
require_once 'include/logging.php';
require_once 'include/database/PearDatabase.php';
global $adb;
$local_log = LoggerManager::getLogger('index');
$folderid = isset($_REQUEST['record']) ? vtlib_purify($_REQUEST['record']) : '';
$foldername = substr(vtlib_purify(trim(utf8RawUrlDecode($_REQUEST['foldername']))), 0, 20);
$folderdesc = substr(vtlib_purify(trim(utf8RawUrlDecode($_REQUEST['folderdesc']))), 0, 50);
if (isset($_REQUEST['savemode']) && $_REQUEST['savemode'] == 'Save') {
if ($folderid == '') {
$dbQuery = 'select foldername from vtiger_attachmentsfolder where foldername=?';
$result1 = $adb->pquery($dbQuery, array($foldername));
if ($result1 && $adb->num_rows($result1)>0) {
echo 'DUPLICATE_FOLDERNAME';
} else {
$rs = $adb->pquery('select max(folderid),max(sequence) from vtiger_attachmentsfolder', array());
$fid = (int)$adb->query_result($rs, 0, 0) + 1;
$sequence = (int)$adb->query_result($rs, 0, 1) + 1;
$sql = 'insert into vtiger_attachmentsfolder (folderid,foldername,description,createdby,sequence) values (?,?,?,?,?)';
$params = array($fid, $foldername, $folderdesc, $current_user->id, $sequence);
$result = $adb->pquery($sql, $params);
if (!$result) {
echo 'Failure';
} else {
header('Location: index.php?action=DocumentsAjax&file=ListView&mode=ajax&ajax=true&module=Documents');
}
}
} elseif ($folderid != '') {
$dbQuery = 'select count(*) from vtiger_attachmentsfolder where foldername=? and folderid!=?';
$result1 = $adb->pquery($dbQuery, array($foldername, $folderid));
if ($result1 && $adb->query_result($result1, 0, 0)==0) {
if (empty($folderdesc)) {
$sql = 'update vtiger_attachmentsfolder set foldername=? where folderid= ?';
$result = $adb->pquery($sql, array($foldername,$folderid));
} else {
$sql = 'update vtiger_attachmentsfolder set foldername=?, description=? where folderid= ?';
$result = $adb->pquery($sql, array($foldername, $folderdesc, $folderid));
}
if (!$result) {
echo 'Failure';
} else {
echo 'Success';
}
} else {
echo 'DUPLICATE_FOLDERNAME';
}
}
}
?>