128 lines
5.3 KiB
PHP
128 lines
5.3 KiB
PHP
|
<?
|
||
|
|
//require_once("modules/EcmDocuments/guid.php");
|
||
|
|
function copySmbFile($from,$to)
|
||
|
|
{
|
||
|
|
$data=file_get_contents(str_replace("[s]"," ",$from));
|
||
|
|
$h = fopen($to,'w+');
|
||
|
|
fwrite($h,$data);
|
||
|
|
}
|
||
|
|
function copyToOcr($file_id)
|
||
|
|
{
|
||
|
|
$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select filename from ecmfiles_versions where file_id='".$file_id."' and deleted='0' order by date_entered desc limit 1"));
|
||
|
|
$exp=explode(".",$r['filename']);
|
||
|
|
$roz=$exp[count($exp)-1];
|
||
|
|
$exp1=explode("/",$r['filename']);
|
||
|
|
$filename=$exp1[count($exp1)-1];
|
||
|
|
if($roz=="pdf")copy("/srv/www/htdocs/crm/".$r['filename'],"/srv/www/htdocs/crm/extras/OCR/IN/".$filename);
|
||
|
|
}
|
||
|
|
function upload_file($nazwa,$gdzie)
|
||
|
|
{
|
||
|
|
$time=create_guid();
|
||
|
|
$plik_tmp = $_FILES[$nazwa]['tmp_name'];
|
||
|
|
$plik_nazwa = $_FILES[$nazwa]['name'];
|
||
|
|
$plik_rozmiar = $_FILES[$nazwa]['size'];
|
||
|
|
|
||
|
|
$file_extension = strtolower(substr(strrchr($plik_nazwa,"."),1));
|
||
|
|
if(is_uploaded_file($plik_tmp))
|
||
|
|
{
|
||
|
|
if(file_exists($gdzie.$data.".".$file_extension))$time.="n";
|
||
|
|
move_uploaded_file($plik_tmp,$gdzie.$time.".".$file_extension);
|
||
|
|
}
|
||
|
|
return $gdzie.$time.".".$file_extension;
|
||
|
|
}
|
||
|
|
function add_samba_file($samba_file)
|
||
|
|
{
|
||
|
|
$exp=explode("/",str_replace("[s]"," ",$samba_file));
|
||
|
|
$sname=$exp[count($exp)-1];
|
||
|
|
$sexp=explode(".",$sname);
|
||
|
|
$samba_file="modules/EcmDocs/files/".create_guid().".".$sexp[count($sexp)-1];
|
||
|
|
|
||
|
|
copySmbFile("smb://janek:test55...@192.168.1.3/Celtic/CRM/Files/".str_replace("[s]"," ",$_REQUEST['samba_file']),$samba_file);
|
||
|
|
$file_id=create_guid();
|
||
|
|
$GLOBALS['db']->query("insert into ecmfiles(id,name,date_entered,deleted) values('".$file_id."','".$sname."','".date("Y-m-d H:m:s")."','0')");
|
||
|
|
$GLOBALS['db']->query("insert into ecmfiles_versions(id,version,filename,name,file_id,date_entered,deleted) values('".create_guid()."','1.0','".$samba_file."','".$sname."','".$file_id."','".date("Y-m-d H:m:s")."','0')");
|
||
|
|
copyToOcr($file_id);
|
||
|
|
return $file_id;
|
||
|
|
}
|
||
|
|
function add_file($input_name,$record,$table,$dir)
|
||
|
|
{
|
||
|
|
error_reporting(E_ALL);
|
||
|
|
if($_FILES[$input_name]['name'] || $_SESSION['emails_files'])
|
||
|
|
{
|
||
|
|
if($record)
|
||
|
|
{
|
||
|
|
$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query($z="select file_id from ".$table." where id='".$record."'"));
|
||
|
|
$file_id=$r['file_id'];
|
||
|
|
}
|
||
|
|
else $file_id="";
|
||
|
|
|
||
|
|
if($file_id=="" || !$file_id)
|
||
|
|
{
|
||
|
|
$file_id=create_guid();
|
||
|
|
if($GLOBALS['db']->query("insert into ecmfiles(id,name,date_entered,deleted) values('".$file_id."','".$_FILES[$input_name]['name']."','".date("Y-m-d H:m:s")."','0')"))
|
||
|
|
{
|
||
|
|
if($_SESSION['emails_files'])
|
||
|
|
{
|
||
|
|
$ver=1.0;
|
||
|
|
for($i=0;$i<count($_REQUEST['efiles']);$i++)
|
||
|
|
{
|
||
|
|
$nn=explode("/",$_REQUEST['efiles'][$i]);
|
||
|
|
$nid=$nn[count($nn)-1];
|
||
|
|
$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select filename from notes where id='".$nid."'"));
|
||
|
|
$nname=$r['filename'];
|
||
|
|
$GLOBALS['db']->query("insert into ecmfiles_versions(id,version,filename,name,file_id,date_entered,deleted) values('".create_guid()."','".$ver."','".$_REQUEST['efiles'][$i]."','".$nname."','".$file_id."','".date("Y-m-d H:m:s")."','0')");
|
||
|
|
$ver+=0.1;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
elseif($name=upload_file($input_name,$dir))
|
||
|
|
{
|
||
|
|
$GLOBALS['db']->query("insert into ecmfiles_versions(id,version,filename,name,file_id,date_entered,deleted) values('".create_guid()."','1.0','".$name."','".$_FILES[$input_name]['name']."','".$file_id."','".date("Y-m-d H:m:s")."','0')");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select max(version) as max from ecmfiles_versions where file_id='".$file_id."' and deleted='0'"));
|
||
|
|
$version=$r['max'];
|
||
|
|
$version=$version+0.1;
|
||
|
|
if($_SESSION['emails_files'])
|
||
|
|
{
|
||
|
|
for($i=0;$i<count($_REQUEST['efiles']);$i++)
|
||
|
|
{
|
||
|
|
$nn=explode("/",$_REQUEST['efiles'][$i]);
|
||
|
|
$nid=$nn[count($nn)-1];
|
||
|
|
$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select filename from notes where id='".$nid."'"));
|
||
|
|
$nname=$r['filename'];
|
||
|
|
$GLOBALS['db']->query("insert into ecmfiles_versions(id,version,filename,name,file_id,date_entered,deleted) values('".create_guid()."','".$version."','".$_REQUEST['efiles'][$i]."','".$nname."','".$file_id."','".date("Y-m-d H:m:s")."','0')");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
elseif($name=upload_file($input_name,$dir))
|
||
|
|
{
|
||
|
|
$GLOBALS['db']->query("insert into ecmfiles_versions(id,version,filename,name,file_id,date_entered,deleted) values('".create_guid()."','".$version."','".$name."','".$_FILES[$input_name]['name']."','".$file_id."','".date("Y-m-d H:m:s")."','0')");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if(isset($_POST['inbound_email_id']))
|
||
|
|
{
|
||
|
|
for($i=0;$i<count($_POST['efiles']);$i++)
|
||
|
|
{
|
||
|
|
$nn=explode("/",$_POST['efiles'][$i]);
|
||
|
|
$nid=$nn[count($nn)-1];
|
||
|
|
$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select id,name from notes where id='".$nid."'"));
|
||
|
|
if($_POST['emaildel']==1)$GLOBALS['db']->query("delete from notes where id='".$nid."'");
|
||
|
|
$nname=$r['id'];
|
||
|
|
$namef=explode(".",$r['name']);
|
||
|
|
$fname=$namef[count($namef)-1];
|
||
|
|
//print "mmm";
|
||
|
|
if(copy("cache/upload/".$nname,"modules/EcmDocs/files/".$nname.".".$fname))print "ok";
|
||
|
|
if($_POST['emaildel']==1)unlink("cache/upload/".$nname);
|
||
|
|
$GLOBALS['db']->query("update ecmfiles_versions set filename='modules/EcmDocs/files/".$nname.".".$fname."' where filename='cache/upload/".$nname."'");
|
||
|
|
}
|
||
|
|
if($_POST['emaildel']==1)$GLOBALS['db']->query("delete from emails where id='".$_POST['inbound_email_id']."'");
|
||
|
|
}
|
||
|
|
$_SESSION['filename_email']="";
|
||
|
|
//copyToOcr($file_id);
|
||
|
|
return $file_id;
|
||
|
|
}
|
||
|
|
?>
|