jro_apps/pbase Files · trunk/components/com_data/DataController.php

modificada la instancia de la clase SessionModel

arturo - - Load All Authors

File last commit:

r0:1


                r11:12

Download file

             DataController.php
        
                    774 lines
            
             | 42.2 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / trunk / components / com_data / DataController.php
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        arturo
    
creando directorios base para el desarrollo

              r0
            
      <?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;

              }

          }

      ?>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages