<?php
class urinalysisController extends ControllerBase{

    public function dolist(){}

    public function add(){
        $name_form = $_REQUEST["name_form"];
        $method = "";
        $title = "";
        switch ($name_form){
            case "frm_09":
                $number = 9;
                if(isset ($_SESSION['usersession']['idapplication']) || !empty($_SESSION['usersession']['idapplication'])){
                    $idapplication = $_SESSION['usersession']['idapplication'];

                    require_once 'components'.DS.'com_data'.DS.'models'.DS.'testsModel.php';
                    $test           = new testsModel();
                    $result_test    = $test->getTestbyNumForm($number);
                    $data_result    = $result_test->fetch();
                    $idtest         = $data_result['idtest'];

                    require_once 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
                    $application_test = new applicationTestModel();
                    $result = $application_test->getApplicationTestChecked($idtest, $idapplication);
                    
                    if(($result->rowCount()) == 1){
                        $url = "index.php?option=com_data&controller=urinalysis&action=view&name_form=frm_09";
                        header("location: ".$url);
                        exit();
                    }else{
                        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';
                        
                        $detail_test    = new detailTestModel();
                        $category       = new categoryModel();
                        $data_medical   = new dataMedicalModel();
                        
                        list($result_detail, $num_rows_detail)  = $detail_test->dolistbyTest($data_result['idtest']);
                        $data_detail    = $result_detail->fetchAll();
                        //var_dump($result_detail); die();
                        $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['idtest']         = $idtest;
                        $data['data_fields']    = $data_fields;
                        $data['flag_edit']      = TRUE;
                        $method                 = "add";
                        $title                  = "Screening Urinalysis and Toxicology (within 21 Days prior to Dose 1)";
                    }
                }
                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 save(){
        $num_form = $_POST['num_form'];
        switch ($num_form){
            case 9:
                $data_table = $_POST['datos'];
                $lst_ids    = $_POST['var_ids'];
                
                $data_application['date']   = $this->formatDateCRF($data_table['txt_date']);
                $data_application['idtest'] = $data_table['idtest'];
                $data_application['idapplication']  = $_SESSION['usersession']['idapplication'];
                
                require 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
                $application_test = new applicationTestModel();
                list($result, $idappl_test, $message) = $application_test->addItem($data_application);

                require 'components'.DS.'com_data'.DS.'models'.DS.'chemistryModel.php';
                $chemistry = new chemistryModel();
                
                for($i = 0; $i<count($lst_ids); $i++){
                    $data_chemistry['idappl_test']      = $idappl_test;
                    $data_chemistry['iddm']             = $lst_ids[$i];
                    $data_chemistry['results']          = $data_table["txt_value_$lst_ids[$i]"];
                    $data_chemistry['clinically_significant'] = $data_table["sign_$lst_ids[$i]"];
                    $data_chemistry['repeated']         = $data_table["repeat_$lst_ids[$i]"];
                    $data_chemistry['description']      = $data_table["comment_$lst_ids[$i]"];

                    list($result, $id, $message) = $chemistry->addItem($data_chemistry);
                }
                
                $url = "index.php?option=com_data&controller=chemistry&action=view&name_form=frm_08";
                break;
        }

        header("location: ".$url);
        exit();
    }

    public function view(){
        $name_form = $_REQUEST["name_form"];
        $method = "";
        $title = "";
        switch ($name_form){
            case "frm_08":
                $number = 8;
                $idapplication = $_SESSION['usersession']['idapplication'];

                require_once 'components'.DS.'com_data'.DS.'models'.DS.'testsModel.php';
                $test           = new testsModel();
                $result_test    = $test->getTestbyNumForm($number);
                $data_result    = $result_test->fetch();
                $idtest         = $data_result['idtest'];
                
                require 'components'.DS.'com_data'.DS.'models'.DS.'applicationTestModel.php';
                $appl_test = new applicationTestModel();
                $result = $appl_test->getApplicationTestChecked($idtest, $idapplication);
                $data_appl_test = $result->fetch();
                
                if(($result->rowCount()) == 0){
                    $url = "index.php?option=com_data&controller=urinalysis&action=add&name_form=frm_09";
                    header("location: ".$url);
                    exit();
                }else{
                    require 'components'.DS.'com_data'.DS.'models'.DS.'chemistryModel.php';
                    $chemistry = new chemistryModel();

                    list($result_chemistry, $num_rows) = $chemistry->getChemistry($data_appl_test['idappl_test']);
                    $data_chemistry = $result_chemistry->fetchAll();
                    
                    $method = "view";
                    $data['flag_edit']          = FALSE;
                    $data['lst_chemistry']      = $data_chemistry;
                    $data['date_test']          = $this->viewDateCRF($data_appl_test['date']);
                }
                $title = "Screening Urinalysis and Toxicology (within 21 Days prior to Dose 1)";
                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";

        $a = explode ("-", $date_tmp);
        $date_tmp = $a[2]."/".$mes2."/".$a[0];

        return $date_tmp;
    }
}
?>