|
|
<?php
|
|
|
class DataController extends ControllerBase{
|
|
|
|
|
|
/**
|
|
|
*NEOVOX NEOENXTO 20110126
|
|
|
*Funcion que genera un listado de un controlador especifico.
|
|
|
**/
|
|
|
|
|
|
public function dolist(){}
|
|
|
|
|
|
public function add(){
|
|
|
$name_form = $_REQUEST["name_form"];
|
|
|
$method = "";
|
|
|
$title = "";
|
|
|
switch ($name_form){
|
|
|
case "frm_01":
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'CRFApplicationModel.php';
|
|
|
require 'components'.DS.'com_subjects'.DS.'models'.DS.'subjectModel.php';
|
|
|
$subject = new subjectModel();
|
|
|
$application = new CRFApplicationModel;
|
|
|
|
|
|
$idsubject = $_SESSION['usersession']['idsubject'];
|
|
|
$result_crf = $application->getCRF($idsubject);
|
|
|
|
|
|
$result = $subject->getSubject($idsubject);
|
|
|
$data_result = $result->fetch();
|
|
|
|
|
|
if(($result_crf->rowCount()) == 1){
|
|
|
$data_crf = $result_crf->fetch();
|
|
|
$_SESSION['usersession']['idapplication'] = $data_crf['idapplication'];
|
|
|
$method = "view";
|
|
|
|
|
|
($data_result["gender"] == 1) ? $gender = "Male" : $gender = "Female";
|
|
|
//echo "hola".$data_result["race"]; die();
|
|
|
switch($data_result["race"]){
|
|
|
case 1:
|
|
|
$race = "American Indian or Alaska Native";
|
|
|
break;
|
|
|
case 2:
|
|
|
$race = "Asian";
|
|
|
break;
|
|
|
case 3:
|
|
|
$race = "Black or African American";
|
|
|
break;
|
|
|
case 4:
|
|
|
$race = "Native Hawaiin or Other Pacific Islander";
|
|
|
break;
|
|
|
case 5:
|
|
|
$race = "White";
|
|
|
break;
|
|
|
case 6:
|
|
|
$race = "Unknown";
|
|
|
break;
|
|
|
default:
|
|
|
$race = "Unknown";
|
|
|
}
|
|
|
switch($data_result["ethnicity"]){
|
|
|
case 1:
|
|
|
$ethnicity = "Hispanic or Latin";
|
|
|
break;
|
|
|
case 2:
|
|
|
$ethnicity = "Not Hispanic or latino";
|
|
|
break;
|
|
|
case 3:
|
|
|
$ethnicity = "Unknown";
|
|
|
break;
|
|
|
default:
|
|
|
$ethnicity = "Unknown";
|
|
|
}
|
|
|
|
|
|
$data_result['date_birth'] = $this->viewDateCRF($data_result['date_birth']);
|
|
|
//echo ">>".$race; die();
|
|
|
//var_dump($data_result); die();
|
|
|
$data['data_result'] = $data_result;
|
|
|
$data['race'] = $race;
|
|
|
$data['gender'] = $gender;
|
|
|
$data['ethnicity'] = $ethnicity;
|
|
|
|
|
|
$crf_appl = new CRFApplicationModel();
|
|
|
$result_crf = $crf_appl->getCRF($idsubject);
|
|
|
$data_crf = $result_crf->fetch();
|
|
|
$data_crf['screening_date'] = $this->viewDateCRF($data_crf['screening_date']);
|
|
|
$data_crf['date_consent'] = $this->viewDateCRF($data_crf['date_consent']);
|
|
|
|
|
|
$data['data_crf'] = $data_crf;
|
|
|
|
|
|
} else {
|
|
|
$method = "add";
|
|
|
list($result, $num_rows) = $subject->dolistWithoutCRF();
|
|
|
$data_list = $result->fetchAll();
|
|
|
$data['data_list'] = $data_list;
|
|
|
$data['data_result'] = $data_result;
|
|
|
}
|
|
|
$title = "Demografics";
|
|
|
break;
|
|
|
case "frm_02":
|
|
|
if(isset ($_SESSION['usersession']['idsubject']) || !empty($_SESSION['usersession']['idsubject'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'criteriaModel.php';
|
|
|
$criteria = new criteriaModel();
|
|
|
$category = 8;
|
|
|
$type = 1;
|
|
|
list($result_criteria, $num_rows_criteria) = $criteria->dolist($type, $category, $idapplication);
|
|
|
if($num_rows_criteria == 10){
|
|
|
$url = "index.php?option=com_data&controller=Data&action=view&name_form=frm_02";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}else{
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'dataGeneralModel.php';
|
|
|
$data_general = new dataGeneralModel();
|
|
|
|
|
|
list($result, $num_rows) = $data_general->dolist($category);
|
|
|
$data_list = $result->fetchAll();
|
|
|
$data['data_list'] = $data_list;
|
|
|
$method = "add";
|
|
|
}
|
|
|
}else{
|
|
|
|
|
|
}
|
|
|
break;
|
|
|
case "frm_03":
|
|
|
if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'criteriaModel.php';
|
|
|
$criteria = new criteriaModel();
|
|
|
$category = 9;
|
|
|
$type = 2;
|
|
|
list($result_criteria, $num_rows_criteria) = $criteria->dolist($type, $category, $idapplication);
|
|
|
if($num_rows_criteria == 14){
|
|
|
$url = "index.php?option=com_data&controller=Data&action=view&name_form=frm_03";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}else{
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'dataGeneralModel.php';
|
|
|
$criteria = new dataGeneralModel();
|
|
|
$category = 9;
|
|
|
list($result, $num_rows) = $criteria->dolist($category);
|
|
|
$data_list = $result->fetchAll();
|
|
|
$data['data_list'] = $data_list;
|
|
|
$method = "add";
|
|
|
}
|
|
|
}else{
|
|
|
|
|
|
}
|
|
|
break;
|
|
|
case "frm_04":
|
|
|
//************************************************
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'MedicalHistoryModel.php';
|
|
|
$MedicalHistory = new MedicalHistoryModel();
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
$list_history = $MedicalHistory->list_history($idapplication);
|
|
|
//************************************************
|
|
|
$method = "add";
|
|
|
$title = "Screening Medical History";
|
|
|
$data['list_history'] = $list_history;
|
|
|
$data['oculto'] = 1;
|
|
|
break;
|
|
|
case "frm_05":
|
|
|
//****************Traemos la data para mostrar********************************
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'dataMedicalModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'vitalSignsModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'physicalExamModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'testsModel.php';
|
|
|
$application_test = new applicationTestModel();
|
|
|
$data_medical = new dataMedicalModel();
|
|
|
$obj_vitalSigns = new vitalSignsModel();
|
|
|
$obj_physicalExam = new physicalExamModel();
|
|
|
$obj_test = new testsModel();
|
|
|
$arr_form = explode("frm_","frm_05");
|
|
|
$num_form = (int) $arr_form[1];
|
|
|
$listbool_existe = $application_test->Getappl_test($_SESSION['usersession']['idapplication'],$num_form);
|
|
|
$bool_existe = count($listbool_existe);
|
|
|
if ($bool_existe > 0){
|
|
|
$list_test = $obj_test->Getappl_test($num_form);
|
|
|
$idappl_test = $list_test[0]->idtest ;
|
|
|
$lista_appl_test = $application_test->info($idappl_test);
|
|
|
//var_dump($lista_appl_test);
|
|
|
$items = count($lista_appl_test);
|
|
|
//$variable_veri = is_null($lista_appl_test);
|
|
|
//var_dump($variable_veri);
|
|
|
//if ($variable_veri == true){
|
|
|
if ($items > 0){
|
|
|
//echo "no hay nada";
|
|
|
$list_vitalSigns = $obj_vitalSigns->info_appltest($idappl_test);
|
|
|
$list_physicalExam = $obj_physicalExam->info_appltest($idappl_test);
|
|
|
$data['list_vitalSigns'] = $list_vitalSigns;
|
|
|
$data['lista_appl_test'] = $lista_appl_test;
|
|
|
$data['list_physicalExam'] = $list_physicalExam;
|
|
|
}
|
|
|
|
|
|
} //************************************************
|
|
|
$title = "Screening Vital Signs And Physical Exam (whitin 21 days of Dose 1)";
|
|
|
$data['oculto'] = 1;
|
|
|
//************************************************************
|
|
|
$number = 1;
|
|
|
if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
|
|
|
$application_test = new applicationTestModel();
|
|
|
$result = $application_test->getApplicationTest($number);
|
|
|
if(($result->rowCount()) == 1){
|
|
|
$url = "index.php?option=com_data&controller=Data&action=view&name_form=5";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}else{
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'testsModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'detailTestModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'categoryModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'dataMedicalModel.php';
|
|
|
$test = new testsModel();
|
|
|
$detail_test = new detailTestModel();
|
|
|
$category = new categoryModel();
|
|
|
$data_medical = new dataMedicalModel();
|
|
|
$id = 1;
|
|
|
|
|
|
$result_test = $test->getTest($id);
|
|
|
$data_test = $result_test->fetch();
|
|
|
|
|
|
list($result_detail, $num_rows_detail) = $detail_test->dolistbyTest($id);
|
|
|
$data_detail = $result_detail->fetchAll();
|
|
|
|
|
|
$i = 0;
|
|
|
foreach($data_detail as $detail){
|
|
|
list($result_dm, $num_rows_dm) = $data_medical->dolistbyCategory($detail['idcategory']);
|
|
|
$data_fields[$i] = $result_dm->fetchAll();
|
|
|
$i++;
|
|
|
}
|
|
|
|
|
|
$data['data_fields'] = $data_fields;
|
|
|
$method = "add";
|
|
|
}
|
|
|
}
|
|
|
break;
|
|
|
case "frm_05_op2":
|
|
|
//****************Traemos la data para mostrar********************************
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'dataMedicalModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'vitalSignsModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'physicalExamModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'testsModel.php';
|
|
|
$application_test = new applicationTestModel();
|
|
|
$data_medical = new dataMedicalModel();
|
|
|
$obj_vitalSigns = new vitalSignsModel();
|
|
|
$obj_physicalExam = new physicalExamModel();
|
|
|
$obj_test = new testsModel();
|
|
|
$arr_form = explode("frm_","frm_05");
|
|
|
$num_form = (int) $arr_form[1];
|
|
|
$listbool_existe = $application_test->Getappl_test($_SESSION['usersession']['idapplication'],$num_form);
|
|
|
$bool_existe = count($listbool_existe);
|
|
|
if ($bool_existe > 0){
|
|
|
$list_test = $obj_test->Getappl_test($num_form);
|
|
|
$idappl_test = $list_test[0]->idtest ;
|
|
|
$lista_appl_test = $application_test->info($idappl_test);
|
|
|
//var_dump($lista_appl_test);
|
|
|
$items = count($lista_appl_test);
|
|
|
//$variable_veri = is_null($lista_appl_test);
|
|
|
//var_dump($variable_veri);
|
|
|
//if ($variable_veri == true){
|
|
|
if ($items > 0){
|
|
|
//echo "no hay nada";
|
|
|
$list_vitalSigns = $obj_vitalSigns->info_appltest($idappl_test);
|
|
|
$list_physicalExam = $obj_physicalExam->info_appltest($idappl_test);
|
|
|
$data['list_vitalSigns'] = $list_vitalSigns;
|
|
|
$data['lista_appl_test'] = $lista_appl_test;
|
|
|
$data['list_physicalExam'] = $list_physicalExam;
|
|
|
}
|
|
|
|
|
|
} //************************************************
|
|
|
$title = "Screening Vital Signs And Physical Exam (whitin 21 days of Dose 1)";
|
|
|
$data['oculto'] = 1;
|
|
|
//************************************************************
|
|
|
$number = 1;
|
|
|
if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
|
|
|
$application_test = new applicationTestModel();
|
|
|
$result = $application_test->getApplicationTest($number);
|
|
|
if(($result->rowCount()) == 1){
|
|
|
$url = "index.php?option=com_data&controller=Data&action=view&name_form=5";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}else{
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'testsModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'detailTestModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'categoryModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'dataMedicalModel.php';
|
|
|
$test = new testsModel();
|
|
|
$detail_test = new detailTestModel();
|
|
|
$category = new categoryModel();
|
|
|
$data_medical = new dataMedicalModel();
|
|
|
$id = 1;
|
|
|
|
|
|
$result_test = $test->getTest($id);
|
|
|
$data_test = $result_test->fetch();
|
|
|
|
|
|
list($result_detail, $num_rows_detail) = $detail_test->dolistbyTest($id);
|
|
|
$data_detail = $result_detail->fetchAll();
|
|
|
|
|
|
$i = 0;
|
|
|
foreach($data_detail as $detail){
|
|
|
list($result_dm, $num_rows_dm) = $data_medical->dolistbyCategory($detail['idcategory']);
|
|
|
$data_fields[$i] = $result_dm->fetchAll();
|
|
|
$i++;
|
|
|
}
|
|
|
|
|
|
$data['data_fields'] = $data_fields;
|
|
|
$method = "add";
|
|
|
}
|
|
|
}
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
$data['content'] = "components".DS.COMPONENT.DS."views".DS.$name_form.".php";
|
|
|
$data['method'] = $method;
|
|
|
$data['title'] = $title;
|
|
|
|
|
|
$this->view->show("template.php", $data);
|
|
|
}
|
|
|
|
|
|
public function listdata(){
|
|
|
$name_form = $_GET["name_form"];
|
|
|
//************************************************
|
|
|
switch ($name_form){
|
|
|
case "frm_04":
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'MedicalHistoryModel.php';
|
|
|
$MedicalHistory = new MedicalHistoryModel();
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
$list_history = $MedicalHistory->list_history($idapplication);
|
|
|
//************************************************
|
|
|
$method = "view";
|
|
|
$title = "Screening Medical History";
|
|
|
$data['list_history'] = $list_history;
|
|
|
$data['content'] = "components".DS.COMPONENT.DS."views".DS.$name_form.".php";
|
|
|
$data['method'] = $method;
|
|
|
$data['title'] = $title;
|
|
|
$data['oculto'] = 1;
|
|
|
break;
|
|
|
case "frm_05":
|
|
|
//****************Traemos la data para mostrar********************************
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'dataMedicalModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'vitalSignsModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'physicalExamModel.php';
|
|
|
$application_test = new applicationTestModel();
|
|
|
$data_medical = new dataMedicalModel();
|
|
|
$obj_vitalSigns = new vitalSignsModel();
|
|
|
$obj_physicalExam = new physicalExamModel();
|
|
|
$idappl_test = $_GET['id'];
|
|
|
$lista_appl_test = $application_test->info($idappl_test);
|
|
|
$list_vitalSigns = $obj_vitalSigns->info_appltest($idappl_test);
|
|
|
$list_physicalExam = $obj_physicalExam->info_appltest($idappl_test);
|
|
|
//****************************************************************************
|
|
|
$number = 1;
|
|
|
if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
$result = $application_test->getApplicationTest($number);
|
|
|
if(($result->rowCount()) == 1){
|
|
|
$url = "index.php?option=com_data&controller=Data&action=view&name_form=5";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}else{
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'testsModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'detailTestModel.php';
|
|
|
require_once 'components'.DS.'com_data'.DS.'models'.DS.'categoryModel.php';
|
|
|
$test = new testsModel();
|
|
|
$detail_test = new detailTestModel();
|
|
|
$category = new categoryModel();
|
|
|
$id = 1;
|
|
|
|
|
|
$result_test = $test->getTest($id);
|
|
|
$data_test = $result_test->fetch();
|
|
|
|
|
|
list($result_detail, $num_rows_detail) = $detail_test->dolistbyTest($id);
|
|
|
$data_detail = $result_detail->fetchAll();
|
|
|
|
|
|
$i = 0;
|
|
|
foreach($data_detail as $detail){
|
|
|
list($result_dm, $num_rows_dm) = $data_medical->dolistbyCategory($detail['idcategory']);
|
|
|
$data_fields[$i] = $result_dm->fetchAll();
|
|
|
$i++;
|
|
|
}
|
|
|
|
|
|
$data['data_fields'] = $data_fields;
|
|
|
$method = "add";
|
|
|
}
|
|
|
}
|
|
|
//************************************************
|
|
|
//$method = "view";
|
|
|
$title = "Screening Vital Signs And Physical Exam (whitin 21 days of Dose 1)";
|
|
|
$data['list_vitalSigns'] = $list_vitalSigns;
|
|
|
$data['lista_appl_test'] = $lista_appl_test;
|
|
|
$data['list_physicalExam'] = $list_physicalExam;
|
|
|
$data['content'] = "components".DS.COMPONENT.DS."views".DS.$name_form.".php";
|
|
|
$data['method'] = $method;
|
|
|
$data['title'] = $title;
|
|
|
$data['oculto'] = 1;
|
|
|
break;
|
|
|
}
|
|
|
$this->view->show("template.php", $data);
|
|
|
}
|
|
|
public function save(){
|
|
|
$num_form = $_POST['num_form'];
|
|
|
switch ($num_form){
|
|
|
case 1:
|
|
|
|
|
|
$data_table = $_POST['datos'];
|
|
|
$data_table_1['date_birth'] = $this->formatDateCRF($data_table['db']);
|
|
|
$data_table_1['race'] = $data_table['race'];
|
|
|
$data_table_1['gender'] = $data_table['gender'];
|
|
|
$data_table_1['ethnicity'] = $data_table['ethnicity'];
|
|
|
$data_table_1['initials'] = $data_table['initials'];
|
|
|
|
|
|
$data_table_2['idsubject'] = $data_table['txt_code'];
|
|
|
$data_table_2['screening_date'] = $this->formatDateCRF($data_table['sd']);
|
|
|
$data_table_2['date_consent'] = $this->formatDateCRF($data_table['dics']);
|
|
|
$data_table_2['code'] = "CRF001";
|
|
|
|
|
|
require 'components'.DS.'com_subjects'.DS.'models'.DS.'subjectModel.php';
|
|
|
$subject = new subjectModel();
|
|
|
$subject->setIdValue($data_table['txt_code']);
|
|
|
list($result, $message) = $subject->UpdateItem($data_table_1);
|
|
|
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'CRFApplicationModel.php';
|
|
|
$crf_appl = new CRFApplicationModel();
|
|
|
list($result, $id, $message) = $crf_appl->addItem($data_table_2);
|
|
|
$_SESSION['usersession']['idapplication'] = $id;
|
|
|
|
|
|
$url = "index.php?option=com_data&controller=Data&action=add&name_form=frm_02";
|
|
|
break;
|
|
|
|
|
|
case 2:
|
|
|
$data_form = $_POST['datos'];
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'criteriaModel.php';
|
|
|
$criteria = new criteriaModel();
|
|
|
|
|
|
for($i=1; $i<=10; $i++){
|
|
|
$data_table['idapplication'] = $idapplication;
|
|
|
$data_table['iddata_general'] = $data_form["id_$i"];
|
|
|
$data_table['value'] = $data_form["criteria_$i"];
|
|
|
$data_table['type'] = 1;
|
|
|
list($result, $id, $message) = $criteria->addItem($data_table);
|
|
|
}
|
|
|
|
|
|
$url = "index.php?option=com_data&controller=Data&action=view&name_form=frm_02";
|
|
|
break;
|
|
|
|
|
|
case 3:
|
|
|
$data_form = $_POST['datos'];
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'criteriaModel.php';
|
|
|
$criteria = new criteriaModel();
|
|
|
|
|
|
for($i=1; $i<=14; $i++){
|
|
|
$data_table['idapplication'] = $idapplication;
|
|
|
$data_table['iddata_general'] = $data_form["id_$i"];
|
|
|
$data_table['value'] = $data_form["criteria_$i"];
|
|
|
$data_table['type'] = 2;
|
|
|
list($result, $id, $message) = $criteria->addItem($data_table);
|
|
|
}
|
|
|
|
|
|
$url = "index.php?option=com_data&controller=Data&action=view&name_form=frm_03";
|
|
|
break;
|
|
|
case 4:
|
|
|
$data_form = $_POST['datos'];
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'CRFApplicationModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'MedicalHistoryModel.php';
|
|
|
//var_dump($_SESSION);
|
|
|
$CRFApplication = new CRFApplicationModel();
|
|
|
$MedicalHistory = new MedicalHistoryModel();
|
|
|
if ($data_form['mh'] == "Y"){
|
|
|
$data_table['medical_history'] = 1;
|
|
|
$CRFApplication->setIdValue($_SESSION['usersession']['idapplication']);
|
|
|
list($result_crf, $message) = $CRFApplication->UpdateItem($data_table);
|
|
|
//print_r($result_crf); die();
|
|
|
//*****************Insertar en la 2 tabla *****************
|
|
|
$data_table2['idapplication'] = $_SESSION['usersession']['idapplication'];
|
|
|
$data_table2['description'] = $data_form['finding'];
|
|
|
$data_table2['bool_active'] = $data_form['finding_status'];
|
|
|
$data_table2['date_create'] = date("Y-m-d H:s:m");
|
|
|
$data_table2['date_update'] = date("Y-m-d H:s:m");
|
|
|
list($result, $id, $message) = $MedicalHistory->addItem($data_table2);
|
|
|
}else{
|
|
|
$data_table['medical_history'] = 0;
|
|
|
$CRFApplication->setIdValue($_SESSION['usersession']['idapplication']);
|
|
|
list($result_crf, $message) = $CRFApplication->UpdateItem($data_table);
|
|
|
}
|
|
|
|
|
|
$url = "index.php?option=com_data&controller=Data&action=listdata&name_form=frm_04";
|
|
|
break;
|
|
|
case 5:
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'dataMedicalModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'vitalSignsModel.php';
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'physicalExamModel.php';
|
|
|
//*********Guardando datos en sis_appl_test**********************************
|
|
|
$obj_applicationTest = new applicationTestModel();
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
$idtest = $_POST['num_form'];
|
|
|
$date_exam = $this->formatDateCRF($_POST['date_exam']);
|
|
|
$data_table['idapplication'] = $idapplication;
|
|
|
$data_table['idtest'] = $idtest;
|
|
|
$data_table['date'] = $date_exam;
|
|
|
list($result, $idappltest, $message) = $obj_applicationTest->addItem($data_table);
|
|
|
print_r($result);
|
|
|
//********Guardando datos en sis_vital_signs**********************************
|
|
|
$obj_dataMedical = new dataMedicalModel();
|
|
|
$obj_vSigns = new vitalSignsModel();
|
|
|
$list_vsigns = $obj_dataMedical->list_cat1();
|
|
|
$data_tablevs['idappl_test'] = $idappltest;
|
|
|
$num_items = count($list_vsigns) - 1;
|
|
|
$data_formvs = $_POST['datos']['v_signs'];
|
|
|
for ($i=0; $i<=$num_items; $i++){
|
|
|
$datavsigns = $list_vsigns[$i];
|
|
|
$id_vs = $datavsigns->iddm;
|
|
|
if (isset($data_formvs["value_".$id_vs])){
|
|
|
$data_tablevs['iddm'] = $id_vs;
|
|
|
$data_tablevs['value'] = $data_formvs["value_".$id_vs];
|
|
|
list($result, $idvSigns, $message) = $obj_vSigns->addItem($data_tablevs);
|
|
|
//print_r($result);
|
|
|
}
|
|
|
}//fin del for
|
|
|
//***********Guardando datos sis_physical_exam *******************************
|
|
|
$obj_pExam = new physicalExamModel();
|
|
|
$data_tablepexam['idappl_test'] = $idappltest;
|
|
|
$list_p_exam = $obj_dataMedical->list_cat2();
|
|
|
$num_items = count($list_vsigns) - 1;
|
|
|
$data_formpexam = $_POST['datos']['p_exam'];
|
|
|
for ($i=0; $i<=$num_items; $i++){
|
|
|
$datapexam = $list_p_exam[$i];
|
|
|
$id_pexam = $datapexam->iddm;
|
|
|
if (isset($data_formpexam["value_".$id_pexam])){
|
|
|
$data_tablepexam['iddm'] = $id_pexam;
|
|
|
echo $_POST["text".$id_pexam];
|
|
|
if ((isset($_POST["text".$id_pexam])) and (!empty($_POST["text".$id_pexam])))
|
|
|
$data_tablepexam['description'] = $_POST["text".$id_pexam];
|
|
|
else
|
|
|
$data_tablepexam['description'] = "";
|
|
|
$data_tablepexam['status'] = $data_formpexam["value_".$id_pexam];
|
|
|
list($result, $idvSigns, $message) = $obj_pExam->addItem($data_tablepexam);
|
|
|
//print_r($result);
|
|
|
}
|
|
|
}//fin del for
|
|
|
//****************************************************************************
|
|
|
$url = "index.php?option=com_data&controller=Data&action=listdata&name_form=frm_05&id=".$idappltest;
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}
|
|
|
|
|
|
public function view(){
|
|
|
$name_form = $_REQUEST["name_form"];
|
|
|
$method = "";
|
|
|
$title = "";
|
|
|
switch ($name_form){
|
|
|
case "frm_01":
|
|
|
require 'components'.DS.'com_subjects'.DS.'models'.DS.'subjectModel.php';
|
|
|
$subject = new subjectModel();
|
|
|
if(isset ($_SESSION['usersession']['idsubject']) || !empty($_SESSION['usersession']['idsubject'])){
|
|
|
$idsubject = $_SESSION['usersession']['idsubject'];
|
|
|
$method = "view";
|
|
|
$result = $subject->getSubject($idsubject);
|
|
|
$data_result = $result->fetch();
|
|
|
($data_result["gender"] == 1) ? $gender = "Male" : $gender = "Female";
|
|
|
switch($data_result["race"]){
|
|
|
case 1:
|
|
|
$race = "American Indian or Alaska Native";
|
|
|
break;
|
|
|
case 2:
|
|
|
$race = "Asian";
|
|
|
break;
|
|
|
case 3:
|
|
|
$race = "Black or African American";
|
|
|
break;
|
|
|
case 4:
|
|
|
$race = "Native Hawaiin or Other Pacific Islander";
|
|
|
break;
|
|
|
case 5:
|
|
|
$race = "White";
|
|
|
break;
|
|
|
case 6:
|
|
|
$race = "Unknown";
|
|
|
break;
|
|
|
}
|
|
|
switch($data_result["ethnicity"]){
|
|
|
case 1:
|
|
|
$ethnicity = "Hispanic or Latin";
|
|
|
break;
|
|
|
case 2:
|
|
|
$ethnicity = "Not Hispanic or latino";
|
|
|
break;
|
|
|
case 3:
|
|
|
$ethnicity = "Unknown";
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
$data_result['date_birth'] = $this->viewDateCRF($data_result['date_birth']);
|
|
|
|
|
|
$data['data_result'] = $data_result;
|
|
|
$data['race'] = $race;
|
|
|
$data['gender'] = $gender;
|
|
|
$data['ethnicity'] = $ethnicity;
|
|
|
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'CRFApplicationModel.php';
|
|
|
$crf_appl = new CRFApplicationModel();
|
|
|
$result_crf = $crf_appl->getCRF($idsubject);
|
|
|
$data_crf = $result_crf->fetch();
|
|
|
$data_crf['screening_date'] = $this->viewDateCRF($data_crf['screening_date']);
|
|
|
$data_crf['date_consent'] = $this->viewDateCRF($data_crf['date_consent']);
|
|
|
|
|
|
$data['data_crf'] = $data_crf;
|
|
|
|
|
|
}else{
|
|
|
$method = "add";
|
|
|
list($result, $num_rows) = $subject->dolistWithoutCRF();
|
|
|
$data_list = $result->fetchAll();
|
|
|
$data['data_list'] = $data_list;
|
|
|
}
|
|
|
$title = "Demografics";
|
|
|
break;
|
|
|
case "frm_02":
|
|
|
if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'criteriaModel.php';
|
|
|
$criteria = new criteriaModel();
|
|
|
$title = "Inclusion Criteria";
|
|
|
$type = 1;
|
|
|
$category = 8;
|
|
|
|
|
|
list($result_criteria, $num_rows) = $criteria->dolist($type, $category, $idapplication);
|
|
|
$data_table = $result_criteria->fetchAll();
|
|
|
$data['data_list'] = $data_table;
|
|
|
$method = "view";
|
|
|
}else{
|
|
|
$url = "index.php?option=com_data&controller=Data&action=add&name_form=frm_02";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}
|
|
|
break;
|
|
|
|
|
|
case "frm_03":
|
|
|
if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'criteriaModel.php';
|
|
|
$criteria = new criteriaModel();
|
|
|
$title = "Exclusion Criteria";
|
|
|
$type = 2;
|
|
|
$category = 9;
|
|
|
|
|
|
list($result_criteria, $num_rows) = $criteria->dolist($type, $category, $idapplication);
|
|
|
$data_table = $result_criteria->fetchAll();
|
|
|
$data['data_list'] = $data_table;
|
|
|
$method = "view";
|
|
|
}else{
|
|
|
$url = "index.php?option=com_data&controller=Data&action=add&name_form=frm_03";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}
|
|
|
break;
|
|
|
|
|
|
case "frm_04":
|
|
|
if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
|
|
|
$idapplication = $_SESSION['usersession']['idapplication'];
|
|
|
require 'components'.DS.'com_data'.DS.'models'.DS.'criteriaModel.php';
|
|
|
$criteria = new criteriaModel();
|
|
|
$title = "Screening Medical History";
|
|
|
$type = 2;
|
|
|
$category = 9;
|
|
|
|
|
|
list($result_criteria, $num_rows) = $criteria->dolist($type, $category, $idapplication);
|
|
|
$data_table = $result_criteria->fetchAll();
|
|
|
$data['data_list'] = $data_table;
|
|
|
$method = "view";
|
|
|
}else{
|
|
|
$url = "index.php?option=com_data&controller=Data&action=add&name_form=frm_04";
|
|
|
header("location: ".$url);
|
|
|
exit();
|
|
|
}
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
$data['content'] = "components".DS.COMPONENT.DS."views".DS.$name_form.".php";
|
|
|
$data['method'] = $method;
|
|
|
$data['title'] = $title;
|
|
|
|
|
|
$this->view->show("template.php", $data);
|
|
|
}
|
|
|
/**
|
|
|
*NEOVOX NEOENXTO 20110126
|
|
|
*Funcion que llama al formulario de edicion de datos (view).
|
|
|
**/
|
|
|
public function edit(){}
|
|
|
/**
|
|
|
*NEOVOX NEOENXTO 20110126
|
|
|
*Funcion que recibe los datos que se ingresaron en el formulario de edicion y los almacena.
|
|
|
**/
|
|
|
public function upgrade(){}
|
|
|
/**
|
|
|
*NEOVOX NEOENXTO 20110126
|
|
|
*Funcion que permite eliminar indivualmente los datos de un listado.
|
|
|
**/
|
|
|
public function remove(){}
|
|
|
/**
|
|
|
*NEOVOX NEOENXTO 20110126
|
|
|
*Funcion que permite eliminar una lista de datos seleccionados.
|
|
|
**/
|
|
|
public function removelist(){}
|
|
|
|
|
|
|
|
|
public function home(){
|
|
|
$idsubject = $_REQUEST['idsubject'];
|
|
|
|
|
|
$_SESSION['usersession']['idsubject'] = $idsubject;
|
|
|
unset($_SESSION['usersession']['idapplication']);
|
|
|
$data = array();
|
|
|
$data['content'] = "components".DS.COMPONENT.DS."views".DS."home.php";
|
|
|
$data['title'] = "RFC";
|
|
|
|
|
|
$this->view->show("template.php", $data);
|
|
|
}
|
|
|
|
|
|
public function formatDateCRF($date_tmp){
|
|
|
|
|
|
$array_date = explode ("/", $date_tmp);
|
|
|
$mes = $array_date[1];
|
|
|
|
|
|
if ($mes == "Jan") $mes2 = "01";
|
|
|
if ($mes == "Feb") $mes2 = "02";
|
|
|
if ($mes == "Mar") $mes2 = "03";
|
|
|
if ($mes == "Apr") $mes2 = "04";
|
|
|
if ($mes == "May") $mes2 = "05";
|
|
|
if ($mes == "Jun") $mes2 = "06";
|
|
|
if ($mes == "Jul") $mes2 = "07";
|
|
|
if ($mes == "Aug") $mes2 = "08";
|
|
|
if ($mes == "Set") $mes2 = "09";
|
|
|
if ($mes == "Oct") $mes2 = "10";
|
|
|
if ($mes == "Nov") $mes2 = "11";
|
|
|
if ($mes == "Dec") $mes2 = "12";
|
|
|
|
|
|
$a = explode ("/", $date_tmp);
|
|
|
$date_tmp = $a[2]."-".$mes2."-".$a[0];
|
|
|
|
|
|
return $date_tmp;
|
|
|
}
|
|
|
|
|
|
public function viewDateCRF($date_tmp){
|
|
|
$array_date = explode ("-", $date_tmp);
|
|
|
$mes = $array_date[1];
|
|
|
|
|
|
if ($mes == "01") $mes2 = "Jan";
|
|
|
if ($mes == "02") $mes2 = "Feb";
|
|
|
if ($mes == "03") $mes2 = "Mar";
|
|
|
if ($mes == "04") $mes2 = "Apr";
|
|
|
if ($mes == "05") $mes2 = "May";
|
|
|
if ($mes == "06") $mes2 = "Jun";
|
|
|
if ($mes == "07") $mes2 = "Jul";
|
|
|
if ($mes == "08") $mes2 = "Aug";
|
|
|
if ($mes == "09") $mes2 = "Set";
|
|
|
if ($mes == "10") $mes2 = "Oct";
|
|
|
if ($mes == "11") $mes2 = "Nov";
|
|
|
if ($mes == "12") $mes2 = "Dec";
|
|
|
if ($mes == "00") $mes2 = "Nn";
|
|
|
|
|
|
$a = explode ("-", $date_tmp);
|
|
|
$date_tmp = $a[2]."/".$mes2."/".$a[0];
|
|
|
|
|
|
return $date_tmp;
|
|
|
}
|
|
|
}
|
|
|
?>
|
|
|
|
