74 lines
2.5 KiB
PHP
74 lines
2.5 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('include/logging.php');
|
|
require_once('include/database/PearDatabase.php');
|
|
require_once('modules/Documents/Documents.php');
|
|
|
|
global $adb;
|
|
global $current_user;
|
|
|
|
|
|
|
|
if(isset($_REQUEST['act']) && $_REQUEST['act'] == 'updateDldCnt')
|
|
{
|
|
global $adb;
|
|
$file_id=$_REQUEST['file_id'];
|
|
$sql = "select filedownloadcount from vtiger_notes where notesid= ?";
|
|
$download_count = $adb->query_result($adb->pquery($sql,array($file_id)),0,'filedownloadcount') + 1;
|
|
$sql="update vtiger_notes set filedownloadcount= ? where notesid= ?";
|
|
$res=$adb->pquery($sql,array($download_count,$file_id));
|
|
}
|
|
|
|
if(isset($_REQUEST['act']) && $_REQUEST['act'] == 'checkFileIntegrityDetailView')
|
|
{
|
|
global $adb,$root_directory;
|
|
$dbQuery = "SELECT * FROM vtiger_notes where notesid= ?";
|
|
$fileidQuery = "select attachmentsid from vtiger_seattachmentsrel where crmid = ? ";
|
|
$result = $adb->pquery($dbQuery,array($_REQUEST['noteid']));
|
|
$fileidResult = $adb->pquery($fileidQuery,array($_REQUEST['noteid']));
|
|
//$activeToinactive_count = 0;
|
|
|
|
$file_status = $adb->query_result($result,0,"filestatus");
|
|
$download_type = $adb->query_result($result,0,"filelocationtype");
|
|
$notesid = $adb->query_result($result,0,'notesid');
|
|
$fileid = $adb->query_result($fileidResult,0,"attachmentsid");
|
|
$folderid = $adb->query_result($result,0,"folderid");
|
|
$name = $adb->query_result($result,0,"filename");
|
|
|
|
if($download_type == 'I'){
|
|
$saved_filename = $fileid."_".$name;
|
|
$pathQuery = $adb->pquery("select path from vtiger_attachments where attachmentsid = ?",array($fileid));
|
|
$filepath = $adb->query_result($pathQuery,0,'path');
|
|
|
|
}
|
|
elseif($download_type == 'E'){
|
|
$saved_filename = $name;
|
|
}
|
|
else
|
|
$saved_filename = '';
|
|
|
|
|
|
if(!fopen($filepath.$saved_filename, "r"))
|
|
{
|
|
if($file_status == 1)
|
|
{
|
|
$dbQuery1 = "update vtiger_notes set filestatus = 0 where notesid= ?";
|
|
$result1 = $adb->pquery($dbQuery1,array($notesid));
|
|
echo "lost_integrity";
|
|
}
|
|
else
|
|
echo "file_not_available";
|
|
}else {
|
|
echo "file_available";
|
|
}
|
|
|
|
}
|
|
|
|
?>
|