.
*/
include("./include/include.php");
include("./include/Appl.php");
include("./include/Persons.php");
include("./include/ApplicationUI.php");
require_once("./include/Popup.php");
require_once("./include/AjaxResponse.php");
define("POPUP_HEIGHT", 600);
define("POPUP_WIDTH", 580);
define("POPUP_TOP", 50);
define("POPUP_TITLE", "View all data");
$logForm = "";
if( in_array("application_logadd", $_SESSION['sess_functions']) && $_SERVER['REQUEST_METHOD']=="POST" ) {
$msg = "";
sleep(2);
if( strlen($_POST['Log'])>0 ) {
$query = "UPDATE `persons` SET `Log`=CONCAT(`Log`,'\n".date("Y-m-d H:i:s").": ".addslashes("(".$_SESSION['sess_name'].") ".stripslashes($_POST['Log']))."') WHERE `PersonID`=".addslashes(get_int('id'));
if( doquery($query) ) {
$msg = "Added log entry successfully.";
}else {
$msg = "Failed adding log entry.";
}
}else {
$msg = "You should specify a log message.";
}
$response = new AjaxResponse();
$response->addRefresh("logForm", $msg . $logForm);
include(dirname($_SERVER['SCRIPT_FILENAME'])."/include/PersonsFields/900Log.php");
$query = "SELECT `Log` FROM `persons` WHERE `PersonID`=".addslashes(get_int('id'));
if( @mysql_num_rows( $res=doquery($query) )==1 ) {
$row = mysql_fetch_assoc($res);
$personsLog = new PersonsLog(get_int('id'));
$response->addRefresh("Log_".get_int('id'), $personsLog->display($row['Log']));
}
$response->setFocus("InputLog");
header("Content-type: text/xml; charset=utf-8");
echo $response->createResponse();
}else {
if( !in_array("application_viewdetail", $_SESSION['sess_functions']) ) {
$popup = new Popup(POPUP_TITLE, "You are not authorized to see this page.");
$popup->setHeight(POPUP_HEIGHT)->setWidth(POPUP_WIDTH)->setTop(POPUP_TOP);
echo $popup->createPopup();
}else {
admin_header(true, true);
$query = "SELECT 1";
// Create user interface
$ui = new ApplicationUI(get_int('id'));
$content = $ui->Open();
if( in_array("application_logadd", $_SESSION['sess_functions']) ) {
// add log entry
$content .= $ui->Add("Add log entry", "".$logForm."
", false, true);
$content .= $ui->Separator();
}
$classes = array();
// Read the files from ./include/PersonFields/*.php
$dir = dirname($_SERVER['SCRIPT_FILENAME'])."/include/PersonsFields/*.php";
if( is_dir(dirname($dir)) ) {
foreach( glob($dir) as $file ) {
if( is_file($file) ) {
$i = count($classes);
if( substr(basename($file, ".php"), 3)=="Separator" ) {
$classes[$i]['name'] = "separator";
}else {
include($file);
$name = substr(basename($file, ".php"), 3);
$classname = "Persons".$name;
$class = new $classname(get_int('id'));
if( $class->get_access(false) AND $class->is_sqlcolumn() ) {
$query .= ", ".$class->sql_columnname();
$classes[$i]['name'] = $name;
$classes[$i]['class'] = $class;
}
}
}
}
$i = count($classes);
$classes[$i]['name'] = "separator";
}else {
debug(dirname($dir)." does not exist, failed loading fields");
}
// Read the files from ./include/ApplFields/*.php
$dir = dirname($_SERVER['SCRIPT_FILENAME'])."/include/ApplFields/*.php";
if( is_dir(dirname($dir)) ) {
foreach( glob($dir) as $file ) {
if( is_file($file) ) {
$i = count($classes);
if( substr(basename($file, ".php"), 3)=="Separator" ) {
$classes[$i]['name'] = "separator";
}else {
include($file);
$name = substr(basename($file, ".php"), 3);
$classname = "Appl".$name;
if( $name == "ExtraQuestion" ) {
$queryAnswers = "SELECT `question_id`, `question`, `answer`, `maxlength` FROM `appl_extraquestions` ";
$queryAnswers .= "LEFT JOIN `appl_extraanswers` ON `appl_extraanswers`.`question_id` = `appl_extraquestions`.`id` AND `appl_extraanswers`.`appl_id` = " . addslashes(get_int('id')) . " ";
$queryAnswers .= "ORDER BY `appl_extraquestions`.`order`";
if( @mysql_num_rows( $res=doquery($queryAnswers) )>0 ) {
while( $row = mysql_fetch_assoc($res) ) {
$i = count($classes);
$class = new $classname(get_int('id'), $row['question_id'], $row['question'], $row['maxlength']);
if( $class->get_access(false) ) {
$classes[$i]['name'] = $name . "_" . get_int('id');
$classes[$i]['class'] = $class;
$classes[$i]['value'] = $row['answer'];
}
}
}
}else {
$class = new $classname(get_int('id'));
if( $class->get_access(false) && $class->is_sqlcolumn() ) {
$query .= ", ".$class->sql_columnname();
$classes[$i]['name'] = $name;
$classes[$i]['class'] = $class;
}
}
}
}
}
}else {
debug(dirname($dir)." does not exist, failed loading fields");
}
$query .= " FROM `persons` WHERE `PersonID`=".addslashes(get_int('id'));
if( @mysql_num_rows( $res=doquery($query) )!=1 ) {
$content .= "Failed loading application.";
}else {
$values = mysql_fetch_array($res);
for( $i=0; $iSeparator();
}elseif( substr($classes[$i]['name'], 0, 14) == "ExtraQuestion_" ) {
$content .= $ui->Add($classes[$i]['class']->get_print_name(), $classes[$i]['class']->display($classes[$i]['value'], get_int('id')), false, $classes[$i]['class']->get_compulsory(), $classes[$i]['class']->displayoptions(get_int('id')));
}else {
$content .= $ui->Add($classes[$i]['class']->get_print_name(), $classes[$i]['class']->display($values[ $classes[$i]['name'] ], get_int('id')), false, $classes[$i]['class']->get_compulsory(), $classes[$i]['class']->displayoptions(get_int('id')));
}
}
}
$content .= $ui->Close();
$content .= "Close popup";
$popup = new Popup(POPUP_TITLE, $content);
$popup->setHeight(POPUP_HEIGHT)->setWidth(POPUP_WIDTH)->setTop(POPUP_TOP);
echo $popup->createPopup();
admin_footer(true, true);
}
}
?>