85 lines
2.6 KiB
PHP
85 lines
2.6 KiB
PHP
<?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 = $_REQUEST['record'];
|
|
$foldername = utf8RawUrlDecode($_REQUEST["foldername"]);
|
|
$folderdesc = utf8RawUrlDecode($_REQUEST["folderdesc"]);
|
|
|
|
if(isset($_REQUEST['savemode']) && $_REQUEST['savemode'] == 'Save')
|
|
{
|
|
if($folderid == "")
|
|
{
|
|
$params=array();
|
|
$sqlfid="select max(folderid) from vtiger_attachmentsfolder";
|
|
$fid=$adb->query_result($adb->pquery($sqlfid,$params),0,'max(folderid)')+1;
|
|
$params=array();
|
|
$sqlseq="select max(sequence) from vtiger_attachmentsfolder";
|
|
$sequence=$adb->query_result($adb->pquery($sqlseq,$params),0,'max(sequence)')+1;
|
|
$params=array();
|
|
$dbQuery="select * from vtiger_attachmentsfolder";
|
|
$result1=$adb->pquery($dbQuery,array());
|
|
$flag=0;
|
|
for($i=0;$i<$adb->num_rows($result1);$i++)
|
|
{
|
|
$dbfldrname=$adb->query_result($result1,$i,'foldername');
|
|
if($dbfldrname == $foldername)
|
|
$flag = 1;
|
|
}
|
|
if($flag == 0)
|
|
{
|
|
$sql="insert into vtiger_attachmentsfolder (folderid,foldername,description,createdby,sequence)values ($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&module=Documents");
|
|
}
|
|
elseif($flag == 1)
|
|
echo "DUPLICATE_FOLDERNAME";
|
|
}
|
|
elseif($folderid != "")
|
|
{
|
|
$dbQuery="select * from vtiger_attachmentsfolder";
|
|
$result1=$adb->pquery($dbQuery,array());
|
|
$flag=0;
|
|
for($i=0;$i<$adb->num_rows($result1);$i++)
|
|
{
|
|
$dbfldrname=$adb->query_result($result1,$i,'foldername');
|
|
if($dbfldrname == $foldername)
|
|
$flag = 1;
|
|
}
|
|
if($flag == 0)
|
|
{
|
|
$sql="update vtiger_attachmentsfolder set foldername= ? where folderid= ? ";
|
|
$result=$adb->pquery($sql,array($foldername,$folderid));
|
|
if(!$result)
|
|
{
|
|
echo "Failure";
|
|
}
|
|
else
|
|
echo 'Success';
|
|
}
|
|
elseif($flag == 1)
|
|
echo "DUPLICATE_FOLDERNAME";
|
|
}
|
|
}
|
|
|
|
?>
|