<?php
ini_set("display_errors","1");
ini_set("display_startup_errors","1");
set_magic_quotes_runtime(0);
include("include/dbcommon.php");
include("include/patients_variables.php");
// check if logged in
if(!@$_SESSION["UserID"] || !CheckSecurity(@$_SESSION["OwnerID"],"Add"))
{
$_SESSION["MyURL"]=$_SERVER["SCRIPT_NAME"]."?".$_SERVER["QUERY_STRING"];
header("Location: login.php?message=expired");
return;
}
$filename="";
$message="";
$error_happened=false;
$readavalues=false;
//connect database
$conn = db_connect();
// insert new record if we have to
if(@$_POST["a"]=="added")
{
$afilename_values=array();
$avalues=array();
$files_move=array();
// add filenames to values
foreach($afilename_values as $akey=>$value)
$avalues[$akey]=$value;
// make SQL string
$strSQL = "insert into ".AddTableWrappers($strOriginalTableName)." ";
$strFields="(";
$strValues="(";
// before Add event
$retval = true;
if(function_exists("BeforeAdd"))
$retval=BeforeAdd($avalues);
if($retval)
{
foreach($avalues as $akey=>$value)
{
$strFields.=AddFieldWrappers($akey).", ";
$strValues.=add_db_quotes($akey,$value).", ";
}
if(substr($strFields,-2)==", ")
$strFields=substr($strFields,0,strlen($strFields)-2);
if(substr($strValues,-2)==", ")
$strValues=substr($strValues,0,strlen($strValues)-2);
$strSQL.=$strFields.") values ".$strValues.")";
LogInfo($strSQL);
set_error_handler("add_error_handler");
db_exec($strSQL,$conn);
set_error_handler("error_handler");
// move files
if(!$error_happened)
{
foreach ($files_move as $file)
move_uploaded_file($file[0],$file[1]);
$message="<div class=message><<< "."Record was added"." >>></div>";
// after add event
if(function_exists("AfterAdd"))
AfterAdd();
}
}
else
$readavalues=true;
}
$defvalues=array();
$keys=array();
$keys["Primary"]=postvalue("copyid1");
// copy record
if(array_key_exists("copyid1",$_REQUEST))
{
$strWhere=KeyWhere($keys);
$strSQL=$gstrSQL;
$strSQL=AddWhere($strSQL,$strWhere);
LogInfo($strSQL);
$rs=db_query($strSQL,$conn);
$defvalues=db_fetch_array($rs);
// clear key fields
$defvalues["Primary"]="";
//call CopyOnLoad event
if(function_exists("CopyOnLoad"))
CopyOnLoad($defvalues,$strWhere);
}
else if(!count($defvalues))
{
}
if($readavalues)
{
}
include('libs/Smarty.class.php');
$smarty = new Smarty();
foreach($defvalues as $key=>$value)
$smarty->assign("value_".GoodFieldName($key),$value);
// include files
$includes="";
// validation stuff
$bodyonload="";
$onsubmit="";
if($bodyonload)
{
$onsubmit="return validate();";
$bodyonload="onload=\"".$bodyonload."\"";
}
$includes.="<script language=\"JavaScript\" src=\"include/jsfunctions.js\"></script>\r\n";
$includes.="<script language=\"JavaScript\">\r\n".
"var locale_dateformat = ".$locale_info["LOCALE_IDATE"].";\r\n".
"var locale_datedelimiter = \"".$locale_info["LOCALE_SDATE"]."\";\r\n".
"var bLoading=false;\r\n".
"var TEXT_PLEASE_SELECT='".addslashes("Please select")."';\r\n".
"</script>\r\n";
$smarty->assign("includes",$includes);
$smarty->assign("bodyonload",$bodyonload);
if(strlen($onsubmit))
$onsubmit="onSubmit=\"".$onsubmit."\"";
$smarty->assign("onsubmit",$onsubmit);
$smarty->assign("message",$message);
$max_filesize_set=0;
$readonlyfields=array();
// show readonly fields
$linkdata="";
$smarty->assign("linkdata",$linkdata);
$smarty->display("patients_add.htm");
function add_error_handler($errno, $errstr, $errfile, $errline)
{
global $readavalues, $message, $error_happened;
$message="<div class=message><<< Record was NOT added >>><br><br>".$errstr."</div>";
$readavalues=true;
$error_happened=true;
}
?>