<?
//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;
}
?>