69 lines
2.3 KiB
PHP
69 lines
2.3 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/Reports/Reports.php');
|
||
|
|
require_once('include/logging.php');
|
||
|
|
require_once('include/database/PearDatabase.php');
|
||
|
|
|
||
|
|
global $adb;
|
||
|
|
global $default_charset;
|
||
|
|
$local_log =& LoggerManager::getLogger('index');
|
||
|
|
$focus = new Reports();
|
||
|
|
|
||
|
|
$rfid = vtlib_purify($_REQUEST['record']);
|
||
|
|
$mode = vtlib_purify($_REQUEST['savemode']);
|
||
|
|
$foldername = vtlib_purify($_REQUEST["foldername"]);
|
||
|
|
$foldername = function_exists(iconv) ? @iconv("UTF-8",$default_charset, $foldername) : $foldername;
|
||
|
|
$folderdesc = vtlib_purify($_REQUEST["folderdesc"]);
|
||
|
|
$foldername = str_replace('*amp*','&',$foldername);
|
||
|
|
$folderdesc = str_replace('*amp*','&',$folderdesc);
|
||
|
|
|
||
|
|
if($mode=="Save")
|
||
|
|
{
|
||
|
|
if($rfid=="")
|
||
|
|
{
|
||
|
|
$sql = "INSERT INTO vtiger_reportfolder ";
|
||
|
|
$sql .= "(FOLDERNAME,DESCRIPTION,STATE) VALUES (?,?,?)";
|
||
|
|
$sql_params = array(trim($foldername), $folderdesc,'CUSTOMIZED');
|
||
|
|
$result = $adb->pquery($sql, $sql_params);
|
||
|
|
if($result!=false)
|
||
|
|
{
|
||
|
|
header("Location: index.php?action=ReportsAjax&file=ListView&mode=ajax&module=Reports");
|
||
|
|
}else
|
||
|
|
{
|
||
|
|
include('modules/Vtiger/header.php');
|
||
|
|
$errormessage = "<font color='red'><B>Error Message<ul>
|
||
|
|
<li><font color='red'>Error while inserting the record</font>
|
||
|
|
</ul></B></font> <br>" ;
|
||
|
|
echo $errormessage;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}elseif($mode=="Edit")
|
||
|
|
{
|
||
|
|
if($rfid != "")
|
||
|
|
{
|
||
|
|
$sql = "update vtiger_reportfolder set ";
|
||
|
|
$sql .= "FOLDERNAME=?, DESCRIPTION=? where folderid=?";
|
||
|
|
$params = array(trim($foldername), $folderdesc, $rfid);
|
||
|
|
$result = $adb->pquery($sql, $params);
|
||
|
|
if($result!=false)
|
||
|
|
{
|
||
|
|
header("Location: index.php?action=ReportsAjax&file=ListView&mode=ajax&module=Reports");
|
||
|
|
}else
|
||
|
|
{
|
||
|
|
include('modules/Vtiger/header.php');
|
||
|
|
$errormessage = "<font color='red'><B>Error Message<ul>
|
||
|
|
<li><font color='red'>Error while updating the record</font>
|
||
|
|
</ul></B></font> <br>" ;
|
||
|
|
echo $errormessage;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|