Query($sql); if ( $rs ) { $clientes = $GLOBALS['dbSQL']->getAll(); if( is_array($clientes)&&count($clientes)>0 ) { /*for($i=0,$t=count($clientes);$i<$t;$i++) { //Pagos $esp = array(); $pagoslst = getClientePagos($clientes[$i]["cod"]); if($pagoslst==EMPTY_LST) { $clientes[$i]["pglst"] = array(); } else { $clientes[$i]["pglst"] = $pagoslst; // print_r($esp);print_r("\n"); // print_r($esplst);print_r("\n"); // print_r($profesionales[$i]["esplst"]);die; } //Atenciones $grilla = getProfesionalSMIGrilla($profesionales[$i]["cod"]); if($esplst==EMPTY_LST) { $profesionales[$i]["gri"] = $esp; } else { $profesionales[$i]["gri"] = $grilla; } }*/ //print_r($clientes);die; return $clientes; } return EMPTY_LST; } return false; } function getFerHcPaciente($idcliente) { $result = array( "hcmed" => array() ,"estbaja" => array() ,"estalta" => array() ,"estudios" => array() ,"espermograma" => array() ); //--------------------------------------------------------- // ESTIMACION BAJA //--------------------------------------------------------- /* ,clfeeb_fumOvI_1 as fumovi1 ,clfeeb_fumOvI_2 as fumovi2 ,clfeeb_fumOvI_3 as fumovi3 ,clfeeb_fumOvI_4 as fumovi4 ,clfeeb_fumOvI_5 as fumovi5 ,clfeeb_fumOvI_6 as fumovi6 ,clfeeb_fumOvI_7 as fumovi7 ,clfeeb_fumOvI_8 as fumovi8 ,clfeeb_fumOvI_9 as fumovi9 ,clfeeb_fumOvI_10 as fumovd10 ,clfeeb_fumOvI_11 as fumovd11 ,clfeeb_fumOvI_12 as fumovd12 ,clfeeb_fumOvI_13 as fumovd13 ,clfeeb_fumOvI_14 as fumovd14 ,clfeeb_fumOvI_15 as fumovd15 ,clfeeb_fumOvI_16 as fumovd16 ,clfeeb_fumOvI_17 as fumovd17 ,clfeeb_fumOvI_18 as fumovd18 ,clfeeb_fumOvI_19 as fumovd19 ,clfeeb_fumOvI_20 as fumovd20 ,clfeeb_fumOvI_21 as fumovd21 ,clfeeb_fumOvI_22 as fumovd22 ,clfeeb_fumOvI_23 as fumovd23 ,clfeeb_fumOvI_24 as fumovd24 ,clfeeb_fumOvI_25 as fumovd25 ,clfeeb_fumOvI_26 as fumovd26 ,clfeeb_fumOvI_28 as fumovd28 ,clfeeb_fumOvD_1 as fumovd1 ,clfeeb_fumOvD_2 as fumovd2 ,clfeeb_fumOvD_3 as fumovd3 ,clfeeb_fumOvD_4 as fumovd4 ,clfeeb_fumOvD_5 as fumovd5 ,clfeeb_fumOvD_6 as fumovd6 ,clfeeb_fumOvD_7 as fumovd7 ,clfeeb_fumOvD_8 as fumovd8 ,clfeeb_fumOvD_9 as fumovd9 ,clfeeb_fumOvD_10 as fumovd10 ,clfeeb_fumOvD_11 as fumovd11 ,clfeeb_fumOvD_12 as fumovd12 ,clfeeb_fumOvD_13 as fumovd13 ,clfeeb_fumOvD_14 as fumovd14 ,clfeeb_fumOvD_15 as fumovd15 ,clfeeb_fumOvD_16 as fumovd16 ,clfeeb_fumOvD_17 as fumovd17 ,clfeeb_fumOvD_18 as fumovd18 ,clfeeb_fumOvD_19 as fumovd19 ,clfeeb_fumOvD_20 as fumovd20 ,clfeeb_fumOvD_21 as fumovd21 ,clfeeb_fumOvD_22 as fumovd22 ,clfeeb_fumOvD_23 as fumovd23 ,clfeeb_fumOvD_24 as fumovd24 ,clfeeb_fumOvD_25 as fumovd25 ,clfeeb_fumOvD_26 as fumovd26 ,clfeeb_fumOvD_27 as fumovd27 ,clfeeb_fumOvD_28 as fumovd28 */ // ,FORMAT(clfeeb_fum, 'dd/MM/yyyy' ) as fum $sql = "SELECT clfeeb_numero as cod ,cli_codigo as clicod ,clfeeb_estadoitem as estado ,clfeeb_fum as fum ,clfeeb_tipoembarazo as tembarazo ,clfeeb_droga1 as droga ,clfeeb_droga2 as droga2 ,clfeeb_droga3 as droga3 ,clfeeb_embarazo as tembarazo_ ,clfeeb_tipoproc as tproc ,clfeeb_ritmenstrual as ritmen ,clfeeb_muestrasemen as muessrmen ,clfeeb_origenms as orgsemen ,clfeeb_subundbeta as subbeta ,clfeeb_diag1 as diag1 ,clfeeb_diag2 as diag2 ,clfeeb_comentario as coment ,clfeeb_aih1 as aih1 ,clfeeb_aih2 as aih2 ,clfeeb_aih3 as aih3 ,clfeeb_fum_1 as fum1 ,clfeeb_fum_2 as fum2 ,clfeeb_fum_3 as fum3 ,clfeeb_fum_4 as fum4 ,clfeeb_fum_5 as fum5 ,clfeeb_fum_6 as fum6 ,clfeeb_fum_7 as fum7 ,clfeeb_fum_8 as fum8 ,clfeeb_fum_9 as fum9 ,clfeeb_fum_10 as fum10 ,clfeeb_fum_11 as fum11 ,clfeeb_fum_12 as fum12 ,clfeeb_fum_13 as fum13 ,clfeeb_fum_14 as fum14 ,clfeeb_fum_15 as fum15 ,clfeeb_fum_16 as fum16 ,clfeeb_fum_17 as fum17 ,clfeeb_fum_18 as fum18 ,clfeeb_fum_19 as fum19 ,clfeeb_fum_20 as fum20 ,clfeeb_fum_21 as fum21 ,clfeeb_fum_22 as fum22 ,clfeeb_fum_23 as fum23 ,clfeeb_fum_24 as fum24 ,clfeeb_fum_25 as fum25 ,clfeeb_fum_26 as fum26 ,clfeeb_fum_27 as fum27 ,clfeeb_fum_28 as fum28 ,clfeeb_fumDosis_1 as fumdosis1 ,clfeeb_fumDosis_2 as fumdosis2 ,clfeeb_fumDosis_3 as fumdosis3 ,clfeeb_fumDosis_4 as fumdosis4 ,clfeeb_fumDosis_5 as fumdosis5 ,clfeeb_fumDosis_6 as fumdosis6 ,clfeeb_fumDosis_7 as fumdosis7 ,clfeeb_fumDosis_8 as fumdosis8 ,clfeeb_fumDosis_9 as fumdosis9 ,clfeeb_fumDosis_10 as fumdosis10 ,clfeeb_fumDosis_11 as fumdosis11 ,clfeeb_fumDosis_12 as fumdosis12 ,clfeeb_fumDosis_13 as fumdosis13 ,clfeeb_fumDosis_14 as fumdosis14 ,clfeeb_fumDosis_15 as fumdosis15 ,clfeeb_fumDosis_16 as fumdosis16 ,clfeeb_fumDosis_17 as fumdosis17 ,clfeeb_fumDosis_18 as fumdosis18 ,clfeeb_fumDosis_19 as fumdosis19 ,clfeeb_fumDosis_20 as fumdosis20 ,clfeeb_fumDosis_21 as fumdosis21 ,clfeeb_fumDosis_22 as fumdosis22 ,clfeeb_fumDosis_23 as fumdosis23 ,clfeeb_fumDosis_24 as fumdosis24 ,clfeeb_fumDosis_25 as fumdosis25 ,clfeeb_fumDosis_26 as fumdosis26 ,clfeeb_fumDosis_27 as fumdosis27 ,clfeeb_fumDosis_28 as fumdosis28 ,clfeeb_fumDosis2_1 as fumdosis2_1 ,clfeeb_fumDosis2_2 as fumdosis2_2 ,clfeeb_fumDosis2_3 as fumdosis2_3 ,clfeeb_fumDosis2_4 as fumdosis2_4 ,clfeeb_fumDosis2_5 as fumdosis2_5 ,clfeeb_fumDosis2_6 as fumdosis2_6 ,clfeeb_fumDosis2_7 as fumdosis2_7 ,clfeeb_fumDosis2_8 as fumdosis2_8 ,clfeeb_fumDosis2_9 as fumdosis2_9 ,clfeeb_fumDosis2_10 as fumdosis2_10 ,clfeeb_fumDosis2_11 as fumdosis2_11 ,clfeeb_fumDosis2_12 as fumdosis2_12 ,clfeeb_fumDosis2_13 as fumdosis2_13 ,clfeeb_fumDosis2_14 as fumdosis2_14 ,clfeeb_fumDosis2_15 as fumdosis2_15 ,clfeeb_fumDosis2_16 as fumdosis2_16 ,clfeeb_fumDosis2_17 as fumdosis2_17 ,clfeeb_fumDosis2_18 as fumdosis2_18 ,clfeeb_fumDosis2_19 as fumdosis2_19 ,clfeeb_fumDosis2_20 as fumdosis2_20 ,clfeeb_fumDosis2_21 as fumdosis2_21 ,clfeeb_fumDosis2_22 as fumdosis2_22 ,clfeeb_fumDosis2_23 as fumdosis2_23 ,clfeeb_fumDosis2_24 as fumdosis2_24 ,clfeeb_fumDosis2_25 as fumdosis2_25 ,clfeeb_fumDosis2_26 as fumdosis2_26 ,clfeeb_fumDosis2_27 as fumdosis2_27 ,clfeeb_fumDosis2_28 as fumdosis2_28 ,clfeeb_fumDay_1 as fumdia1 ,clfeeb_fumDay_2 as fumdia2 ,clfeeb_fumDay_3 as fumdia3 ,clfeeb_fumDay_4 as fumdia4 ,clfeeb_fumDay_5 as fumdia5 ,clfeeb_fumDay_6 as fumdia6 ,clfeeb_fumDay_7 as fumdia7 ,clfeeb_fumDay_8 as fumdia8 ,clfeeb_fumDay_9 as fumdia9 ,clfeeb_fumDay_10 as fumdia10 ,clfeeb_fumDay_11 as fumdia11 ,clfeeb_fumDay_12 as fumdia12 ,clfeeb_fumDay_13 as fumdia13 ,clfeeb_fumDay_14 as fumdia14 ,clfeeb_fumDay_15 as fumdia15 ,clfeeb_fumDay_16 as fumdia16 ,clfeeb_fumDay_17 as fumdia17 ,clfeeb_fumDay_18 as fumdia18 ,clfeeb_fumDay_19 as fumdia19 ,clfeeb_fumDay_20 as fumdia20 ,clfeeb_fumDay_21 as fumdia21 ,clfeeb_fumDay_22 as fumdia22 ,clfeeb_fumDay_23 as fumdia23 ,clfeeb_fumDay_24 as fumdia24 ,clfeeb_fumDay_25 as fumdia25 ,clfeeb_fumDay_26 as fumdia26 ,clfeeb_fumDay_27 as fumdia27 ,clfeeb_fumDay_28 as fumdia28 ,clfeeb_fumEA_1 as fumEA_1 ,clfeeb_fumEA_2 as fumEA_2 ,clfeeb_fumEA_3 as fumEA_3 ,clfeeb_fumEA_4 as fumEA_4 ,clfeeb_fumEA_5 as fumEA_5 ,clfeeb_fumEA_6 as fumEA_6 ,clfeeb_fumEA_7 as fumEA_7 ,clfeeb_fumEA_8 as fumEA_8 ,clfeeb_fumEA_9 as fumEA_9 ,clfeeb_fumEA_10 as fumEA_10 ,clfeeb_fumEA_11 as fumEA_11 ,clfeeb_fumEA_12 as fumEA_12 ,clfeeb_fumEA_13 as fumEA_13 ,clfeeb_fumEA_14 as fumEA_14 ,clfeeb_fumEA_15 as fumEA_15 ,clfeeb_fumEA_16 as fumEA_16 ,clfeeb_fumEA_17 as fumEA_17 ,clfeeb_fumEA_18 as fumEA_18 ,clfeeb_fumEA_19 as fumEA_19 ,clfeeb_fumEA_20 as fumEA_20 ,clfeeb_fumEA_21 as fumEA_21 ,clfeeb_fumEA_22 as fumEA_22 ,clfeeb_fumEA_23 as fumEA_23 ,clfeeb_fumEA_24 as fumEA_24 ,clfeeb_fumEA_25 as fumEA_25 ,clfeeb_fumEA_26 as fumEA_26 ,clfeeb_fumEA_27 as fumEA_27 ,clfeeb_fumEA_28 as fumEA_28 ,clfeeb_fumendoesp_1 as fumendesp1 ,clfeeb_fumendoesp_2 as fumendesp2 ,clfeeb_fumendoesp_3 as fumendesp3 ,clfeeb_fumendoesp_4 as fumendesp4 ,clfeeb_fumendoesp_5 as fumendesp5 ,clfeeb_fumendoesp_6 as fumendesp6 ,clfeeb_fumendoesp_7 as fumendesp7 ,clfeeb_fumendoesp_8 as fumendesp8 ,clfeeb_fumendoesp_9 as fumendesp9 ,clfeeb_fumendoesp_10 as fumendesp10 ,clfeeb_fumendoesp_11 as fumendesp11 ,clfeeb_fumendoesp_12 as fumendesp12 ,clfeeb_fumendoesp_13 as fumendesp13 ,clfeeb_fumendoesp_14 as fumendesp14 ,clfeeb_fumendoesp_15 as fumendesp15 ,clfeeb_fumendoesp_16 as fumendesp16 ,clfeeb_fumendoesp_17 as fumendesp17 ,clfeeb_fumendoesp_18 as fumendesp18 ,clfeeb_fumendoesp_19 as fumendesp19 ,clfeeb_fumendoesp_20 as fumendesp20 ,clfeeb_fumendoesp_21 as fumendesp21 ,clfeeb_fumendoesp_22 as fumendesp22 ,clfeeb_fumendoesp_23 as fumendesp23 ,clfeeb_fumendoesp_24 as fumendesp24 ,clfeeb_fumendoesp_25 as fumendesp25 ,clfeeb_fumendoesp_26 as fumendesp26 ,clfeeb_fumendoesp_27 as fumendesp27 ,clfeeb_fumendoesp_28 as fumendesp28 ,clfeeb_fumendopat_1 as fumendpat1 ,clfeeb_fumendopat_2 as fumendpat2 ,clfeeb_fumendopat_3 as fumendpat3 ,clfeeb_fumendopat_4 as fumendpat4 ,clfeeb_fumendopat_5 as fumendpat5 ,clfeeb_fumendopat_6 as fumendpat6 ,clfeeb_fumendopat_7 as fumendpat7 ,clfeeb_fumendopat_8 as fumendpat8 ,clfeeb_fumendopat_9 as fumendpat9 ,clfeeb_fumendopat_10 as fumendpat10 ,clfeeb_fumendopat_11 as fumendpat11 ,clfeeb_fumendopat_12 as fumendpat12 ,clfeeb_fumendopat_13 as fumendpat13 ,clfeeb_fumendopat_14 as fumendpat14 ,clfeeb_fumendopat_15 as fumendpat15 ,clfeeb_fumendopat_16 as fumendpat16 ,clfeeb_fumendopat_17 as fumendpat17 ,clfeeb_fumendopat_18 as fumendpat18 ,clfeeb_fumendopat_19 as fumendpat19 ,clfeeb_fumendopat_20 as fumendpat20 ,clfeeb_fumendopat_21 as fumendpat21 ,clfeeb_fumendopat_22 as fumendpat22 ,clfeeb_fumendopat_23 as fumendpat23 ,clfeeb_fumendopat_24 as fumendpat24 ,clfeeb_fumendopat_25 as fumendpat25 ,clfeeb_fumendopat_26 as fumendpat26 ,clfeeb_fumendopat_27 as fumendpat27 ,clfeeb_fumendopat_28 as fumendpat28 ,clfeeb_fumOvI_1_v1 as fumOvI_1_v1 ,clfeeb_fumOvI_2_v1 as fumOvI_2_v1 ,clfeeb_fumOvI_3_v1 as fumOvI_3_v1 ,clfeeb_fumOvI_4_v1 as fumOvI_4_v1 ,clfeeb_fumOvI_5_v1 as fumOvI_5_v1 ,clfeeb_fumOvI_6_v1 as fumOvI_6_v1 ,clfeeb_fumOvI_7_v1 as fumOvI_7_v1 ,clfeeb_fumOvI_8_v1 as fumOvI_8_v1 ,clfeeb_fumOvI_9_v1 as fumOvI_9_v1 ,clfeeb_fumOvI_10_v1 as fumOvI_10_v1 ,clfeeb_fumOvI_11_v1 as fumOvI_11_v1 ,clfeeb_fumOvI_12_v1 as fumOvI_12_v1 ,clfeeb_fumOvI_13_v1 as fumOvI_13_v1 ,clfeeb_fumOvI_14_v1 as fumOvI_14_v1 ,clfeeb_fumOvI_15_v1 as fumOvI_15_v1 ,clfeeb_fumOvI_16_v1 as fumOvI_16_v1 ,clfeeb_fumOvI_17_v1 as fumOvI_17_v1 ,clfeeb_fumOvI_18_v1 as fumOvI_18_v1 ,clfeeb_fumOvI_19_v1 as fumOvI_19_v1 ,clfeeb_fumOvI_20_v1 as fumOvI_20_v1 ,clfeeb_fumOvI_21_v1 as fumOvI_21_v1 ,clfeeb_fumOvI_22_v1 as fumOvI_22_v1 ,clfeeb_fumOvI_23_v1 as fumOvI_23_v1 ,clfeeb_fumOvI_24_v1 as fumOvI_24_v1 ,clfeeb_fumOvI_25_v1 as fumOvI_25_v1 ,clfeeb_fumOvI_26_v1 as fumOvI_26_v1 ,clfeeb_fumOvI_27_v1 as fumOvI_27_v1 ,clfeeb_fumOvI_28_v1 as fumOvI_28_v1 ,clfeeb_fumOvI_1_v2 as fumOvI_1_v2 ,clfeeb_fumOvI_2_v2 as fumOvI_2_v2 ,clfeeb_fumOvI_3_v2 as fumOvI_3_v2 ,clfeeb_fumOvI_4_v2 as fumOvI_4_v2 ,clfeeb_fumOvI_5_v2 as fumOvI_5_v2 ,clfeeb_fumOvI_6_v2 as fumOvI_6_v2 ,clfeeb_fumOvI_7_v2 as fumOvI_7_v2 ,clfeeb_fumOvI_8_v2 as fumOvI_8_v2 ,clfeeb_fumOvI_9_v2 as fumOvI_9_v2 ,clfeeb_fumOvI_10_v2 as fumOvI_10_v2 ,clfeeb_fumOvI_11_v2 as fumOvI_11_v2 ,clfeeb_fumOvI_12_v2 as fumOvI_12_v2 ,clfeeb_fumOvI_13_v2 as fumOvI_13_v2 ,clfeeb_fumOvI_14_v2 as fumOvI_14_v2 ,clfeeb_fumOvI_15_v2 as fumOvI_15_v2 ,clfeeb_fumOvI_16_v2 as fumOvI_16_v2 ,clfeeb_fumOvI_17_v2 as fumOvI_17_v2 ,clfeeb_fumOvI_18_v2 as fumOvI_18_v2 ,clfeeb_fumOvI_19_v2 as fumOvI_19_v2 ,clfeeb_fumOvI_20_v2 as fumOvI_20_v2 ,clfeeb_fumOvI_21_v2 as fumOvI_21_v2 ,clfeeb_fumOvI_22_v2 as fumOvI_22_v2 ,clfeeb_fumOvI_23_v2 as fumOvI_23_v2 ,clfeeb_fumOvI_24_v2 as fumOvI_24_v2 ,clfeeb_fumOvI_25_v2 as fumOvI_25_v2 ,clfeeb_fumOvI_26_v2 as fumOvI_26_v2 ,clfeeb_fumOvI_27_v2 as fumOvI_27_v2 ,clfeeb_fumOvI_28_v2 as fumOvI_28_v2 ,clfeeb_fumOvI_1_v3 as fumOvI_1_v3 ,clfeeb_fumOvI_2_v3 as fumOvI_2_v3 ,clfeeb_fumOvI_3_v3 as fumOvI_3_v3 ,clfeeb_fumOvI_4_v3 as fumOvI_4_v3 ,clfeeb_fumOvI_5_v3 as fumOvI_5_v3 ,clfeeb_fumOvI_6_v3 as fumOvI_6_v3 ,clfeeb_fumOvI_7_v3 as fumOvI_7_v3 ,clfeeb_fumOvI_8_v3 as fumOvI_8_v3 ,clfeeb_fumOvI_9_v3 as fumOvI_9_v3 ,clfeeb_fumOvI_10_v3 as fumOvI_10_v3 ,clfeeb_fumOvI_11_v3 as fumOvI_11_v3 ,clfeeb_fumOvI_12_v3 as fumOvI_12_v3 ,clfeeb_fumOvI_13_v3 as fumOvI_13_v3 ,clfeeb_fumOvI_14_v3 as fumOvI_14_v3 ,clfeeb_fumOvI_15_v3 as fumOvI_15_v3 ,clfeeb_fumOvI_16_v3 as fumOvI_16_v3 ,clfeeb_fumOvI_17_v3 as fumOvI_17_v3 ,clfeeb_fumOvI_18_v3 as fumOvI_18_v3 ,clfeeb_fumOvI_19_v3 as fumOvI_19_v3 ,clfeeb_fumOvI_20_v3 as fumOvI_20_v3 ,clfeeb_fumOvI_21_v3 as fumOvI_21_v3 ,clfeeb_fumOvI_22_v3 as fumOvI_22_v3 ,clfeeb_fumOvI_23_v3 as fumOvI_23_v3 ,clfeeb_fumOvI_24_v3 as fumOvI_24_v3 ,clfeeb_fumOvI_25_v3 as fumOvI_25_v3 ,clfeeb_fumOvI_26_v3 as fumOvI_26_v3 ,clfeeb_fumOvI_27_v3 as fumOvI_27_v3 ,clfeeb_fumOvI_28_v3 as fumOvI_28_v3 ,clfeeb_fumOvI_1_v4 as fumOvI_1_v4 ,clfeeb_fumOvI_2_v4 as fumOvI_2_v4 ,clfeeb_fumOvI_3_v4 as fumOvI_3_v4 ,clfeeb_fumOvI_4_v4 as fumOvI_4_v4 ,clfeeb_fumOvI_5_v4 as fumOvI_5_v4 ,clfeeb_fumOvI_6_v4 as fumOvI_6_v4 ,clfeeb_fumOvI_7_v4 as fumOvI_7_v4 ,clfeeb_fumOvI_8_v4 as fumOvI_8_v4 ,clfeeb_fumOvI_9_v4 as fumOvI_9_v4 ,clfeeb_fumOvI_10_v4 as fumOvI_10_v4 ,clfeeb_fumOvI_11_v4 as fumOvI_11_v4 ,clfeeb_fumOvI_12_v4 as fumOvI_12_v4 ,clfeeb_fumOvI_13_v4 as fumOvI_13_v4 ,clfeeb_fumOvI_14_v4 as fumOvI_14_v4 ,clfeeb_fumOvI_15_v4 as fumOvI_15_v4 ,clfeeb_fumOvI_16_v4 as fumOvI_16_v4 ,clfeeb_fumOvI_17_v4 as fumOvI_17_v4 ,clfeeb_fumOvI_18_v4 as fumOvI_18_v4 ,clfeeb_fumOvI_19_v4 as fumOvI_19_v4 ,clfeeb_fumOvI_20_v4 as fumOvI_20_v4 ,clfeeb_fumOvI_21_v4 as fumOvI_21_v4 ,clfeeb_fumOvI_22_v4 as fumOvI_22_v4 ,clfeeb_fumOvI_23_v4 as fumOvI_23_v4 ,clfeeb_fumOvI_24_v4 as fumOvI_24_v4 ,clfeeb_fumOvI_25_v4 as fumOvI_25_v4 ,clfeeb_fumOvI_26_v4 as fumOvI_26_v4 ,clfeeb_fumOvI_27_v4 as fumOvI_27_v4 ,clfeeb_fumOvI_28_v4 as fumOvI_28_v4 ,clfeeb_fumOvI_1_v5 as fumOvI_1_v5 ,clfeeb_fumOvI_2_v5 as fumOvI_2_v5 ,clfeeb_fumOvI_3_v5 as fumOvI_3_v5 ,clfeeb_fumOvI_4_v5 as fumOvI_4_v5 ,clfeeb_fumOvI_5_v5 as fumOvI_5_v5 ,clfeeb_fumOvI_6_v5 as fumOvI_6_v5 ,clfeeb_fumOvI_7_v5 as fumOvI_7_v5 ,clfeeb_fumOvI_8_v5 as fumOvI_8_v5 ,clfeeb_fumOvI_9_v5 as fumOvI_9_v5 ,clfeeb_fumOvI_10_v5 as fumOvI_10_v5 ,clfeeb_fumOvI_11_v5 as fumOvI_11_v5 ,clfeeb_fumOvI_12_v5 as fumOvI_12_v5 ,clfeeb_fumOvI_13_v5 as fumOvI_13_v5 ,clfeeb_fumOvI_14_v5 as fumOvI_14_v5 ,clfeeb_fumOvI_15_v5 as fumOvI_15_v5 ,clfeeb_fumOvI_16_v5 as fumOvI_16_v5 ,clfeeb_fumOvI_17_v5 as fumOvI_17_v5 ,clfeeb_fumOvI_18_v5 as fumOvI_18_v5 ,clfeeb_fumOvI_19_v5 as fumOvI_19_v5 ,clfeeb_fumOvI_20_v5 as fumOvI_20_v5 ,clfeeb_fumOvI_21_v5 as fumOvI_21_v5 ,clfeeb_fumOvI_22_v5 as fumOvI_22_v5 ,clfeeb_fumOvI_23_v5 as fumOvI_23_v5 ,clfeeb_fumOvI_24_v5 as fumOvI_24_v5 ,clfeeb_fumOvI_25_v5 as fumOvI_25_v5 ,clfeeb_fumOvI_26_v5 as fumOvI_26_v5 ,clfeeb_fumOvI_27_v5 as fumOvI_27_v5 ,clfeeb_fumOvI_28_v5 as fumOvI_28_v5 ,clfeeb_fumOvI_1_v6 as fumOvI_1_v6 ,clfeeb_fumOvI_2_v6 as fumOvI_2_v6 ,clfeeb_fumOvI_3_v6 as fumOvI_3_v6 ,clfeeb_fumOvI_4_v6 as fumOvI_4_v6 ,clfeeb_fumOvI_5_v6 as fumOvI_5_v6 ,clfeeb_fumOvI_6_v6 as fumOvI_6_v6 ,clfeeb_fumOvI_7_v6 as fumOvI_7_v6 ,clfeeb_fumOvI_8_v6 as fumOvI_8_v6 ,clfeeb_fumOvI_9_v6 as fumOvI_9_v6 ,clfeeb_fumOvI_10_v6 as fumOvI_10_v6 ,clfeeb_fumOvI_11_v6 as fumOvI_11_v6 ,clfeeb_fumOvI_12_v6 as fumOvI_12_v6 ,clfeeb_fumOvI_13_v6 as fumOvI_13_v6 ,clfeeb_fumOvI_14_v6 as fumOvI_14_v6 ,clfeeb_fumOvI_15_v6 as fumOvI_15_v6 ,clfeeb_fumOvI_16_v6 as fumOvI_16_v6 ,clfeeb_fumOvI_17_v6 as fumOvI_17_v6 ,clfeeb_fumOvI_18_v6 as fumOvI_18_v6 ,clfeeb_fumOvI_19_v6 as fumOvI_19_v6 ,clfeeb_fumOvI_20_v6 as fumOvI_20_v6 ,clfeeb_fumOvI_21_v6 as fumOvI_21_v6 ,clfeeb_fumOvI_22_v6 as fumOvI_22_v6 ,clfeeb_fumOvI_23_v6 as fumOvI_23_v6 ,clfeeb_fumOvI_24_v6 as fumOvI_24_v6 ,clfeeb_fumOvI_25_v6 as fumOvI_25_v6 ,clfeeb_fumOvI_26_v6 as fumOvI_26_v6 ,clfeeb_fumOvI_27_v6 as fumOvI_27_v6 ,clfeeb_fumOvI_28_v6 as fumOvI_28_v6 ,clfeeb_fumOvI_1_v7 as fumOvI_1_v7 ,clfeeb_fumOvI_2_v7 as fumOvI_2_v7 ,clfeeb_fumOvI_3_v7 as fumOvI_3_v7 ,clfeeb_fumOvI_4_v7 as fumOvI_4_v7 ,clfeeb_fumOvI_5_v7 as fumOvI_5_v7 ,clfeeb_fumOvI_6_v7 as fumOvI_6_v7 ,clfeeb_fumOvI_7_v7 as fumOvI_7_v7 ,clfeeb_fumOvI_8_v7 as fumOvI_8_v7 ,clfeeb_fumOvI_9_v7 as fumOvI_9_v7 ,clfeeb_fumOvI_10_v7 as fumOvI_10_v7 ,clfeeb_fumOvI_11_v7 as fumOvI_11_v7 ,clfeeb_fumOvI_12_v7 as fumOvI_12_v7 ,clfeeb_fumOvI_13_v7 as fumOvI_13_v7 ,clfeeb_fumOvI_14_v7 as fumOvI_14_v7 ,clfeeb_fumOvI_15_v7 as fumOvI_15_v7 ,clfeeb_fumOvI_16_v7 as fumOvI_16_v7 ,clfeeb_fumOvI_17_v7 as fumOvI_17_v7 ,clfeeb_fumOvI_18_v7 as fumOvI_18_v7 ,clfeeb_fumOvI_19_v7 as fumOvI_19_v7 ,clfeeb_fumOvI_20_v7 as fumOvI_20_v7 ,clfeeb_fumOvI_21_v7 as fumOvI_21_v7 ,clfeeb_fumOvI_22_v7 as fumOvI_22_v7 ,clfeeb_fumOvI_23_v7 as fumOvI_23_v7 ,clfeeb_fumOvI_24_v7 as fumOvI_24_v7 ,clfeeb_fumOvI_25_v7 as fumOvI_25_v7 ,clfeeb_fumOvI_26_v7 as fumOvI_26_v7 ,clfeeb_fumOvI_27_v7 as fumOvI_27_v7 ,clfeeb_fumOvI_28_v7 as fumOvI_28_v7 ,clfeeb_fumOvI_1_v8 as fumOvI_1_v8 ,clfeeb_fumOvI_2_v8 as fumOvI_2_v8 ,clfeeb_fumOvI_3_v8 as fumOvI_3_v8 ,clfeeb_fumOvI_4_v8 as fumOvI_4_v8 ,clfeeb_fumOvI_5_v8 as fumOvI_5_v8 ,clfeeb_fumOvI_6_v8 as fumOvI_6_v8 ,clfeeb_fumOvI_7_v8 as fumOvI_7_v8 ,clfeeb_fumOvI_8_v8 as fumOvI_8_v8 ,clfeeb_fumOvI_9_v8 as fumOvI_9_v8 ,clfeeb_fumOvI_10_v8 as fumOvI_10_v8 ,clfeeb_fumOvI_11_v8 as fumOvI_11_v8 ,clfeeb_fumOvI_12_v8 as fumOvI_12_v8 ,clfeeb_fumOvI_13_v8 as fumOvI_13_v8 ,clfeeb_fumOvI_14_v8 as fumOvI_14_v8 ,clfeeb_fumOvI_15_v8 as fumOvI_15_v8 ,clfeeb_fumOvI_16_v8 as fumOvI_16_v8 ,clfeeb_fumOvI_17_v8 as fumOvI_17_v8 ,clfeeb_fumOvI_18_v8 as fumOvI_18_v8 ,clfeeb_fumOvI_19_v8 as fumOvI_19_v8 ,clfeeb_fumOvI_20_v8 as fumOvI_20_v8 ,clfeeb_fumOvI_21_v8 as fumOvI_21_v8 ,clfeeb_fumOvI_22_v8 as fumOvI_22_v8 ,clfeeb_fumOvI_23_v8 as fumOvI_23_v8 ,clfeeb_fumOvI_24_v8 as fumOvI_24_v8 ,clfeeb_fumOvI_25_v8 as fumOvI_25_v8 ,clfeeb_fumOvI_26_v8 as fumOvI_26_v8 ,clfeeb_fumOvI_27_v8 as fumOvI_27_v8 ,clfeeb_fumOvI_28_v8 as fumOvI_28_v8 ,clfeeb_fumOvI_1_v9 as fumOvI_1_v9 ,clfeeb_fumOvI_2_v9 as fumOvI_2_v9 ,clfeeb_fumOvI_3_v9 as fumOvI_3_v9 ,clfeeb_fumOvI_4_v9 as fumOvI_4_v9 ,clfeeb_fumOvI_5_v9 as fumOvI_5_v9 ,clfeeb_fumOvI_6_v9 as fumOvI_6_v9 ,clfeeb_fumOvI_7_v9 as fumOvI_7_v9 ,clfeeb_fumOvI_8_v9 as fumOvI_8_v9 ,clfeeb_fumOvI_9_v9 as fumOvI_9_v9 ,clfeeb_fumOvI_10_v9 as fumOvI_10_v9 ,clfeeb_fumOvI_11_v9 as fumOvI_11_v9 ,clfeeb_fumOvI_12_v9 as fumOvI_12_v9 ,clfeeb_fumOvI_13_v9 as fumOvI_13_v9 ,clfeeb_fumOvI_14_v9 as fumOvI_14_v9 ,clfeeb_fumOvI_15_v9 as fumOvI_15_v9 ,clfeeb_fumOvI_16_v9 as fumOvI_16_v9 ,clfeeb_fumOvI_17_v9 as fumOvI_17_v9 ,clfeeb_fumOvI_18_v9 as fumOvI_18_v9 ,clfeeb_fumOvI_19_v9 as fumOvI_19_v9 ,clfeeb_fumOvI_20_v9 as fumOvI_20_v9 ,clfeeb_fumOvI_21_v9 as fumOvI_21_v9 ,clfeeb_fumOvI_22_v9 as fumOvI_22_v9 ,clfeeb_fumOvI_23_v9 as fumOvI_23_v9 ,clfeeb_fumOvI_24_v9 as fumOvI_24_v9 ,clfeeb_fumOvI_25_v9 as fumOvI_25_v9 ,clfeeb_fumOvI_26_v9 as fumOvI_26_v9 ,clfeeb_fumOvI_27_v9 as fumOvI_27_v9 ,clfeeb_fumOvI_28_v9 as fumOvI_28_v9 ,clfeeb_fumOvD_1_v1 as fumOvD_1_v1 ,clfeeb_fumOvD_2_v1 as fumOvD_2_v1 ,clfeeb_fumOvD_3_v1 as fumOvD_3_v1 ,clfeeb_fumOvD_4_v1 as fumOvD_4_v1 ,clfeeb_fumOvD_5_v1 as fumOvD_5_v1 ,clfeeb_fumOvD_6_v1 as fumOvD_6_v1 ,clfeeb_fumOvD_7_v1 as fumOvD_7_v1 ,clfeeb_fumOvD_8_v1 as fumOvD_8_v1 ,clfeeb_fumOvD_9_v1 as fumOvD_9_v1 ,clfeeb_fumOvD_10_v1 as fumOvD_10_v1 ,clfeeb_fumOvD_11_v1 as fumOvD_11_v1 ,clfeeb_fumOvD_12_v1 as fumOvD_12_v1 ,clfeeb_fumOvD_13_v1 as fumOvD_13_v1 ,clfeeb_fumOvD_14_v1 as fumOvD_14_v1 ,clfeeb_fumOvD_15_v1 as fumOvD_15_v1 ,clfeeb_fumOvD_16_v1 as fumOvD_16_v1 ,clfeeb_fumOvD_17_v1 as fumOvD_17_v1 ,clfeeb_fumOvD_18_v1 as fumOvD_18_v1 ,clfeeb_fumOvD_19_v1 as fumOvD_19_v1 ,clfeeb_fumOvD_20_v1 as fumOvD_20_v1 ,clfeeb_fumOvD_21_v1 as fumOvD_21_v1 ,clfeeb_fumOvD_22_v1 as fumOvD_22_v1 ,clfeeb_fumOvD_23_v1 as fumOvD_23_v1 ,clfeeb_fumOvD_24_v1 as fumOvD_24_v1 ,clfeeb_fumOvD_25_v1 as fumOvD_25_v1 ,clfeeb_fumOvD_26_v1 as fumOvD_26_v1 ,clfeeb_fumOvD_27_v1 as fumOvD_27_v1 ,clfeeb_fumOvD_28_v1 as fumOvD_28_v1 ,clfeeb_fumOvD_1_v2 as fumOvD_1_v2 ,clfeeb_fumOvD_2_v2 as fumOvD_2_v2 ,clfeeb_fumOvD_3_v2 as fumOvD_3_v2 ,clfeeb_fumOvD_4_v2 as fumOvD_4_v2 ,clfeeb_fumOvD_5_v2 as fumOvD_5_v2 ,clfeeb_fumOvD_6_v2 as fumOvD_6_v2 ,clfeeb_fumOvD_7_v2 as fumOvD_7_v2 ,clfeeb_fumOvD_8_v2 as fumOvD_8_v2 ,clfeeb_fumOvD_9_v2 as fumOvD_9_v2 ,clfeeb_fumOvD_10_v2 as fumOvD_10_v2 ,clfeeb_fumOvD_11_v2 as fumOvD_11_v2 ,clfeeb_fumOvD_12_v2 as fumOvD_12_v2 ,clfeeb_fumOvD_13_v2 as fumOvD_13_v2 ,clfeeb_fumOvD_14_v2 as fumOvD_14_v2 ,clfeeb_fumOvD_15_v2 as fumOvD_15_v2 ,clfeeb_fumOvD_16_v2 as fumOvD_16_v2 ,clfeeb_fumOvD_17_v2 as fumOvD_17_v2 ,clfeeb_fumOvD_18_v2 as fumOvD_18_v2 ,clfeeb_fumOvD_19_v2 as fumOvD_19_v2 ,clfeeb_fumOvD_20_v2 as fumOvD_20_v2 ,clfeeb_fumOvD_21_v2 as fumOvD_21_v2 ,clfeeb_fumOvD_22_v2 as fumOvD_22_v2 ,clfeeb_fumOvD_23_v2 as fumOvD_23_v2 ,clfeeb_fumOvD_24_v2 as fumOvD_24_v2 ,clfeeb_fumOvD_25_v2 as fumOvD_25_v2 ,clfeeb_fumOvD_26_v2 as fumOvD_26_v2 ,clfeeb_fumOvD_27_v2 as fumOvD_27_v2 ,clfeeb_fumOvD_28_v2 as fumOvD_28_v2 ,clfeeb_fumOvD_1_v3 as fumOvD_1_v3 ,clfeeb_fumOvD_2_v3 as fumOvD_2_v3 ,clfeeb_fumOvD_3_v3 as fumOvD_3_v3 ,clfeeb_fumOvD_4_v3 as fumOvD_4_v3 ,clfeeb_fumOvD_5_v3 as fumOvD_5_v3 ,clfeeb_fumOvD_6_v3 as fumOvD_6_v3 ,clfeeb_fumOvD_7_v3 as fumOvD_7_v3 ,clfeeb_fumOvD_8_v3 as fumOvD_8_v3 ,clfeeb_fumOvD_9_v3 as fumOvD_9_v3 ,clfeeb_fumOvD_10_v3 as fumOvD_10_v3 ,clfeeb_fumOvD_11_v3 as fumOvD_11_v3 ,clfeeb_fumOvD_12_v3 as fumOvD_12_v3 ,clfeeb_fumOvD_13_v3 as fumOvD_13_v3 ,clfeeb_fumOvD_14_v3 as fumOvD_14_v3 ,clfeeb_fumOvD_15_v3 as fumOvD_15_v3 ,clfeeb_fumOvD_16_v3 as fumOvD_16_v3 ,clfeeb_fumOvD_17_v3 as fumOvD_17_v3 ,clfeeb_fumOvD_18_v3 as fumOvD_18_v3 ,clfeeb_fumOvD_19_v3 as fumOvD_19_v3 ,clfeeb_fumOvD_20_v3 as fumOvD_20_v3 ,clfeeb_fumOvD_21_v3 as fumOvD_21_v3 ,clfeeb_fumOvD_22_v3 as fumOvD_22_v3 ,clfeeb_fumOvD_23_v3 as fumOvD_23_v3 ,clfeeb_fumOvD_24_v3 as fumOvD_24_v3 ,clfeeb_fumOvD_25_v3 as fumOvD_25_v3 ,clfeeb_fumOvD_26_v3 as fumOvD_26_v3 ,clfeeb_fumOvD_27_v3 as fumOvD_27_v3 ,clfeeb_fumOvD_28_v3 as fumOvD_28_v3 ,clfeeb_fumOvD_1_v4 as fumOvD_1_v4 ,clfeeb_fumOvD_2_v4 as fumOvD_2_v4 ,clfeeb_fumOvD_3_v4 as fumOvD_3_v4 ,clfeeb_fumOvD_4_v4 as fumOvD_4_v4 ,clfeeb_fumOvD_5_v4 as fumOvD_5_v4 ,clfeeb_fumOvD_6_v4 as fumOvD_6_v4 ,clfeeb_fumOvD_7_v4 as fumOvD_7_v4 ,clfeeb_fumOvD_8_v4 as fumOvD_8_v4 ,clfeeb_fumOvD_9_v4 as fumOvD_9_v4 ,clfeeb_fumOvD_10_v4 as fumOvD_10_v4 ,clfeeb_fumOvD_11_v4 as fumOvD_11_v4 ,clfeeb_fumOvD_12_v4 as fumOvD_12_v4 ,clfeeb_fumOvD_13_v4 as fumOvD_13_v4 ,clfeeb_fumOvD_14_v4 as fumOvD_14_v4 ,clfeeb_fumOvD_15_v4 as fumOvD_15_v4 ,clfeeb_fumOvD_16_v4 as fumOvD_16_v4 ,clfeeb_fumOvD_17_v4 as fumOvD_17_v4 ,clfeeb_fumOvD_18_v4 as fumOvD_18_v4 ,clfeeb_fumOvD_19_v4 as fumOvD_19_v4 ,clfeeb_fumOvD_20_v4 as fumOvD_20_v4 ,clfeeb_fumOvD_21_v4 as fumOvD_21_v4 ,clfeeb_fumOvD_22_v4 as fumOvD_22_v4 ,clfeeb_fumOvD_23_v4 as fumOvD_23_v4 ,clfeeb_fumOvD_24_v4 as fumOvD_24_v4 ,clfeeb_fumOvD_25_v4 as fumOvD_25_v4 ,clfeeb_fumOvD_26_v4 as fumOvD_26_v4 ,clfeeb_fumOvD_27_v4 as fumOvD_27_v4 ,clfeeb_fumOvD_28_v4 as fumOvD_28_v4 ,clfeeb_fumOvD_1_v5 as fumOvD_1_v5 ,clfeeb_fumOvD_2_v5 as fumOvD_2_v5 ,clfeeb_fumOvD_3_v5 as fumOvD_3_v5 ,clfeeb_fumOvD_4_v5 as fumOvD_4_v5 ,clfeeb_fumOvD_5_v5 as fumOvD_5_v5 ,clfeeb_fumOvD_6_v5 as fumOvD_6_v5 ,clfeeb_fumOvD_7_v5 as fumOvD_7_v5 ,clfeeb_fumOvD_8_v5 as fumOvD_8_v5 ,clfeeb_fumOvD_9_v5 as fumOvD_9_v5 ,clfeeb_fumOvD_10_v5 as fumOvD_10_v5 ,clfeeb_fumOvD_11_v5 as fumOvD_11_v5 ,clfeeb_fumOvD_12_v5 as fumOvD_12_v5 ,clfeeb_fumOvD_13_v5 as fumOvD_13_v5 ,clfeeb_fumOvD_14_v5 as fumOvD_14_v5 ,clfeeb_fumOvD_15_v5 as fumOvD_15_v5 ,clfeeb_fumOvD_16_v5 as fumOvD_16_v5 ,clfeeb_fumOvD_17_v5 as fumOvD_17_v5 ,clfeeb_fumOvD_18_v5 as fumOvD_18_v5 ,clfeeb_fumOvD_19_v5 as fumOvD_19_v5 ,clfeeb_fumOvD_20_v5 as fumOvD_20_v5 ,clfeeb_fumOvD_21_v5 as fumOvD_21_v5 ,clfeeb_fumOvD_22_v5 as fumOvD_22_v5 ,clfeeb_fumOvD_23_v5 as fumOvD_23_v5 ,clfeeb_fumOvD_24_v5 as fumOvD_24_v5 ,clfeeb_fumOvD_25_v5 as fumOvD_25_v5 ,clfeeb_fumOvD_26_v5 as fumOvD_26_v5 ,clfeeb_fumOvD_27_v5 as fumOvD_27_v5 ,clfeeb_fumOvD_28_v5 as fumOvD_28_v5 ,clfeeb_fumOvD_1_v6 as fumOvD_1_v6 ,clfeeb_fumOvD_2_v6 as fumOvD_2_v6 ,clfeeb_fumOvD_3_v6 as fumOvD_3_v6 ,clfeeb_fumOvD_4_v6 as fumOvD_4_v6 ,clfeeb_fumOvD_5_v6 as fumOvD_5_v6 ,clfeeb_fumOvD_6_v6 as fumOvD_6_v6 ,clfeeb_fumOvD_7_v6 as fumOvD_7_v6 ,clfeeb_fumOvD_8_v6 as fumOvD_8_v6 ,clfeeb_fumOvD_9_v6 as fumOvD_9_v6 ,clfeeb_fumOvD_10_v6 as fumOvD_10_v6 ,clfeeb_fumOvD_11_v6 as fumOvD_11_v6 ,clfeeb_fumOvD_12_v6 as fumOvD_12_v6 ,clfeeb_fumOvD_13_v6 as fumOvD_13_v6 ,clfeeb_fumOvD_14_v6 as fumOvD_14_v6 ,clfeeb_fumOvD_15_v6 as fumOvD_15_v6 ,clfeeb_fumOvD_16_v6 as fumOvD_16_v6 ,clfeeb_fumOvD_17_v6 as fumOvD_17_v6 ,clfeeb_fumOvD_18_v6 as fumOvD_18_v6 ,clfeeb_fumOvD_19_v6 as fumOvD_19_v6 ,clfeeb_fumOvD_20_v6 as fumOvD_20_v6 ,clfeeb_fumOvD_21_v6 as fumOvD_21_v6 ,clfeeb_fumOvD_22_v6 as fumOvD_22_v6 ,clfeeb_fumOvD_23_v6 as fumOvD_23_v6 ,clfeeb_fumOvD_24_v6 as fumOvD_24_v6 ,clfeeb_fumOvD_25_v6 as fumOvD_25_v6 ,clfeeb_fumOvD_26_v6 as fumOvD_26_v6 ,clfeeb_fumOvD_27_v6 as fumOvD_27_v6 ,clfeeb_fumOvD_28_v6 as fumOvD_28_v6 ,clfeeb_fumOvD_1_v7 as fumOvD_1_v7 ,clfeeb_fumOvD_2_v7 as fumOvD_2_v7 ,clfeeb_fumOvD_3_v7 as fumOvD_3_v7 ,clfeeb_fumOvD_4_v7 as fumOvD_4_v7 ,clfeeb_fumOvD_5_v7 as fumOvD_5_v7 ,clfeeb_fumOvD_6_v7 as fumOvD_6_v7 ,clfeeb_fumOvD_7_v7 as fumOvD_7_v7 ,clfeeb_fumOvD_8_v7 as fumOvD_8_v7 ,clfeeb_fumOvD_9_v7 as fumOvD_9_v7 ,clfeeb_fumOvD_10_v7 as fumOvD_10_v7 ,clfeeb_fumOvD_11_v7 as fumOvD_11_v7 ,clfeeb_fumOvD_12_v7 as fumOvD_12_v7 ,clfeeb_fumOvD_13_v7 as fumOvD_13_v7 ,clfeeb_fumOvD_14_v7 as fumOvD_14_v7 ,clfeeb_fumOvD_15_v7 as fumOvD_15_v7 ,clfeeb_fumOvD_16_v7 as fumOvD_16_v7 ,clfeeb_fumOvD_17_v7 as fumOvD_17_v7 ,clfeeb_fumOvD_18_v7 as fumOvD_18_v7 ,clfeeb_fumOvD_19_v7 as fumOvD_19_v7 ,clfeeb_fumOvD_20_v7 as fumOvD_20_v7 ,clfeeb_fumOvD_21_v7 as fumOvD_21_v7 ,clfeeb_fumOvD_22_v7 as fumOvD_22_v7 ,clfeeb_fumOvD_23_v7 as fumOvD_23_v7 ,clfeeb_fumOvD_24_v7 as fumOvD_24_v7 ,clfeeb_fumOvD_25_v7 as fumOvD_25_v7 ,clfeeb_fumOvD_26_v7 as fumOvD_26_v7 ,clfeeb_fumOvD_27_v7 as fumOvD_27_v7 ,clfeeb_fumOvD_28_v7 as fumOvD_28_v7 ,clfeeb_fumOvD_1_v8 as fumOvD_1_v8 ,clfeeb_fumOvD_2_v8 as fumOvD_2_v8 ,clfeeb_fumOvD_3_v8 as fumOvD_3_v8 ,clfeeb_fumOvD_4_v8 as fumOvD_4_v8 ,clfeeb_fumOvD_5_v8 as fumOvD_5_v8 ,clfeeb_fumOvD_6_v8 as fumOvD_6_v8 ,clfeeb_fumOvD_7_v8 as fumOvD_7_v8 ,clfeeb_fumOvD_8_v8 as fumOvD_8_v8 ,clfeeb_fumOvD_9_v8 as fumOvD_9_v8 ,clfeeb_fumOvD_10_v8 as fumOvD_10_v8 ,clfeeb_fumOvD_11_v8 as fumOvD_11_v8 ,clfeeb_fumOvD_12_v8 as fumOvD_12_v8 ,clfeeb_fumOvD_13_v8 as fumOvD_13_v8 ,clfeeb_fumOvD_14_v8 as fumOvD_14_v8 ,clfeeb_fumOvD_15_v8 as fumOvD_15_v8 ,clfeeb_fumOvD_16_v8 as fumOvD_16_v8 ,clfeeb_fumOvD_17_v8 as fumOvD_17_v8 ,clfeeb_fumOvD_18_v8 as fumOvD_18_v8 ,clfeeb_fumOvD_19_v8 as fumOvD_19_v8 ,clfeeb_fumOvD_20_v8 as fumOvD_20_v8 ,clfeeb_fumOvD_21_v8 as fumOvD_21_v8 ,clfeeb_fumOvD_22_v8 as fumOvD_22_v8 ,clfeeb_fumOvD_23_v8 as fumOvD_23_v8 ,clfeeb_fumOvD_24_v8 as fumOvD_24_v8 ,clfeeb_fumOvD_25_v8 as fumOvD_25_v8 ,clfeeb_fumOvD_26_v8 as fumOvD_26_v8 ,clfeeb_fumOvD_27_v8 as fumOvD_27_v8 ,clfeeb_fumOvD_28_v8 as fumOvD_28_v8 ,clfeeb_fumOvD_1_v9 as fumOvD_1_v9 ,clfeeb_fumOvD_2_v9 as fumOvD_2_v9 ,clfeeb_fumOvD_3_v9 as fumOvD_3_v9 ,clfeeb_fumOvD_4_v9 as fumOvD_4_v9 ,clfeeb_fumOvD_5_v9 as fumOvD_5_v9 ,clfeeb_fumOvD_6_v9 as fumOvD_6_v9 ,clfeeb_fumOvD_7_v9 as fumOvD_7_v9 ,clfeeb_fumOvD_8_v9 as fumOvD_8_v9 ,clfeeb_fumOvD_9_v9 as fumOvD_9_v9 ,clfeeb_fumOvD_10_v9 as fumOvD_10_v9 ,clfeeb_fumOvD_11_v9 as fumOvD_11_v9 ,clfeeb_fumOvD_12_v9 as fumOvD_12_v9 ,clfeeb_fumOvD_13_v9 as fumOvD_13_v9 ,clfeeb_fumOvD_14_v9 as fumOvD_14_v9 ,clfeeb_fumOvD_15_v9 as fumOvD_15_v9 ,clfeeb_fumOvD_16_v9 as fumOvD_16_v9 ,clfeeb_fumOvD_17_v9 as fumOvD_17_v9 ,clfeeb_fumOvD_18_v9 as fumOvD_18_v9 ,clfeeb_fumOvD_19_v9 as fumOvD_19_v9 ,clfeeb_fumOvD_20_v9 as fumOvD_20_v9 ,clfeeb_fumOvD_21_v9 as fumOvD_21_v9 ,clfeeb_fumOvD_22_v9 as fumOvD_22_v9 ,clfeeb_fumOvD_23_v9 as fumOvD_23_v9 ,clfeeb_fumOvD_24_v9 as fumOvD_24_v9 ,clfeeb_fumOvD_25_v9 as fumOvD_25_v9 ,clfeeb_fumOvD_26_v9 as fumOvD_26_v9 ,clfeeb_fumOvD_27_v9 as fumOvD_27_v9 ,clfeeb_fumOvD_28_v9 as fumOvD_28_v9 FROM cli_fer_estbaja as e WHERE e.cli_codigo = '".addslashes($idcliente)."' ORDER BY clfeeb_numero DESC"; // print_r($sql);die; $rs = $GLOBALS['dbSQL']->Query($sql); if ( !$rs ) { return false; } $result["estbaja"] = $GLOBALS['dbSQL']->getAll(); //--------------------------------------------------------- //--------------------------------------------------------- // ESTIMACION ALTA //--------------------------------------------------------- $sql = "SELECT clfeea_numero as cod ,cli_codigo as clicod ,FORMAT(clfeea_fum, 'dd/MM/yyyy' ) as fum ,clfeea_droga as droga ,clfeea_embarazo as tembarazo ,clfeea_tipoproc as tproc ,clfeea_ritmenstrual as ritmen ,clfeea_muestrasemen as muessrmen ,clfeea_origenms as orgsemen ,clfeea_subundbeta as subbeta ,clfeea_diag1 as diag1 ,clfeea_diag2 as diag2 ,clfeea_comentario as coment ,clfeea_aih1 as aih1 ,clfeea_aih2 as aih2 ,clfeea_aih3 as aih3 ,ISNULL(clfeea_tese,0) AS tese ,ISNULL(clfeea_ionosforos,0) AS ionosforos ,ISNULL(clfeea_cgh,0) AS cgh ,ISNULL(clfeea_aneximas,0) AS aneximas ,ISNULL(clfeea_hatching,0) AS hatching ,ISNULL(clfeea_vitrificaovos,0) AS vitrificaovos ,ISNULL(clfeea_vitrificaemb,0) AS vitrificaemb ,clfeea_otros as otros ,clfeea_nroovos as nroovos ,clfeea_transf as transf ,clfeea_vitrificacion as vitrificacion ,clfeea_fum_1 as fum1 ,clfeea_fum_2 as fum2 ,clfeea_fum_3 as fum3 ,clfeea_fum_4 as fum4 ,clfeea_fum_5 as fum5 ,clfeea_fum_6 as fum6 ,clfeea_fum_7 as fum7 ,clfeea_fum_8 as fum8 ,clfeea_fum_9 as fum9 ,clfeea_fum_10 as fum10 ,clfeea_fum_11 as fum11 ,clfeea_fum_12 as fum12 ,clfeea_fum_13 as fum13 ,clfeea_fum_14 as fum14 ,clfeea_fum_15 as fum15 ,clfeea_fum_16 as fum16 ,clfeea_fum_17 as fum17 ,clfeea_fum_18 as fum18 ,clfeea_fum_19 as fum19 ,clfeea_fum_20 as fum20 ,clfeea_fum_21 as fum21 ,clfeea_fum_22 as fum22 ,clfeea_fum_23 as fum23 ,clfeea_fum_24 as fum24 ,clfeea_fum_25 as fum25 ,clfeea_fum_26 as fum26 ,clfeea_fum_27 as fum27 ,clfeea_fumDosis_1 as fumdosis1 ,clfeea_fumDosis_2 as fumdosis2 ,clfeea_fumDosis_3 as fumdosis3 ,clfeea_fumDosis_4 as fumdosis4 ,clfeea_fumDosis_5 as fumdosis5 ,clfeea_fumDosis_6 as fumdosis6 ,clfeea_fumDosis_7 as fumdosis7 ,clfeea_fumDosis_8 as fumdosis8 ,clfeea_fumDosis_9 as fumdosis9 ,clfeea_fumDosis_10 as fumdosis10 ,clfeea_fumDosis_11 as fumdosis11 ,clfeea_fumDosis_12 as fumdosis12 ,clfeea_fumDosis_13 as fumdosis13 ,clfeea_fumDosis_14 as fumdosis14 ,clfeea_fumDosis_15 as fumdosis15 ,clfeea_fumDosis_16 as fumdosis16 ,clfeea_fumDosis_17 as fumdosis17 ,clfeea_fumDosis_18 as fumdosis18 ,clfeea_fumDosis_19 as fumdosis19 ,clfeea_fumDosis_20 as fumdosis20 ,clfeea_fumDosis_21 as fumdosis21 ,clfeea_fumDosis_22 as fumdosis22 ,clfeea_fumDosis_23 as fumdosis23 ,clfeea_fumDosis_24 as fumdosis24 ,clfeea_fumDosis_25 as fumdosis25 ,clfeea_fumDosis_26 as fumdosis26 ,clfeea_fumDosis_27 as fumdosis27 ,clfeea_fumDay_1 as fumdia1 ,clfeea_fumDay_2 as fumdia2 ,clfeea_fumDay_3 as fumdia3 ,clfeea_fumDay_4 as fumdia4 ,clfeea_fumDay_5 as fumdia5 ,clfeea_fumDay_6 as fumdia6 ,clfeea_fumDay_7 as fumdia7 ,clfeea_fumDay_8 as fumdia8 ,clfeea_fumDay_9 as fumdia9 ,clfeea_fumDay_10 as fumdia10 ,clfeea_fumDay_11 as fumdia11 ,clfeea_fumDay_12 as fumdia12 ,clfeea_fumDay_13 as fumdia13 ,clfeea_fumDay_14 as fumdia14 ,clfeea_fumDay_15 as fumdia15 ,clfeea_fumDay_16 as fumdia16 ,clfeea_fumDay_17 as fumdia17 ,clfeea_fumDay_18 as fumdia18 ,clfeea_fumDay_19 as fumdia19 ,clfeea_fumDay_20 as fumdia20 ,clfeea_fumDay_21 as fumdia21 ,clfeea_fumDay_22 as fumdia22 ,clfeea_fumDay_23 as fumdia23 ,clfeea_fumDay_24 as fumdia24 ,clfeea_fumDay_25 as fumdia25 ,clfeea_fumDay_26 as fumdia26 ,clfeea_fumDay_27 as fumdia27 ,clfeea_fumOvI_1 as fumovi1 ,clfeea_fumOvI_2 as fumovi2 ,clfeea_fumOvI_3 as fumovi3 ,clfeea_fumOvI_4 as fumovi4 ,clfeea_fumOvI_5 as fumovi5 ,clfeea_fumOvI_6 as fumovi6 ,clfeea_fumOvI_7 as fumovi7 ,clfeea_fumOvI_8 as fumovi8 ,clfeea_fumOvI_9 as fumovi9 ,clfeea_fumOvI_10 as fumovd10 ,clfeea_fumOvI_11 as fumovd11 ,clfeea_fumOvI_12 as fumovd12 ,clfeea_fumOvI_13 as fumovd13 ,clfeea_fumOvI_14 as fumovd14 ,clfeea_fumOvI_15 as fumovd15 ,clfeea_fumOvI_16 as fumovd16 ,clfeea_fumOvI_17 as fumovd17 ,clfeea_fumOvI_18 as fumovd18 ,clfeea_fumOvI_19 as fumovd19 ,clfeea_fumOvI_20 as fumovd20 ,clfeea_fumOvI_21 as fumovd21 ,clfeea_fumOvI_22 as fumovd22 ,clfeea_fumOvI_23 as fumovd23 ,clfeea_fumOvI_24 as fumovd24 ,clfeea_fumOvI_25 as fumovd25 ,clfeea_fumOvI_26 as fumovd26 ,clfeea_fumOvI_27 as fumovd27 ,clfeea_fumOvD_1 as fumovd1 ,clfeea_fumOvD_2 as fumovd2 ,clfeea_fumOvD_3 as fumovd3 ,clfeea_fumOvD_4 as fumovd4 ,clfeea_fumOvD_5 as fumovd5 ,clfeea_fumOvD_6 as fumovd6 ,clfeea_fumOvD_7 as fumovd7 ,clfeea_fumOvD_8 as fumovd8 ,clfeea_fumOvD_9 as fumovd9 ,clfeea_fumOvD_10 as fumovd10 ,clfeea_fumOvD_11 as fumovd11 ,clfeea_fumOvD_12 as fumovd12 ,clfeea_fumOvD_13 as fumovd13 ,clfeea_fumOvD_14 as fumovd14 ,clfeea_fumOvD_15 as fumovd15 ,clfeea_fumOvD_16 as fumovd16 ,clfeea_fumOvD_17 as fumovd17 ,clfeea_fumOvD_18 as fumovd18 ,clfeea_fumOvD_19 as fumovd19 ,clfeea_fumOvD_20 as fumovd20 ,clfeea_fumOvD_21 as fumovd21 ,clfeea_fumOvD_22 as fumovd22 ,clfeea_fumOvD_23 as fumovd23 ,clfeea_fumOvD_24 as fumovd24 ,clfeea_fumOvD_25 as fumovd25 ,clfeea_fumOvD_26 as fumovd26 ,clfeea_fumOvD_27 as fumovd27 ,clfeea_fumendoesp_1 as fumendesp1 ,clfeea_fumendoesp_2 as fumendesp2 ,clfeea_fumendoesp_3 as fumendesp3 ,clfeea_fumendoesp_4 as fumendesp4 ,clfeea_fumendoesp_5 as fumendesp5 ,clfeea_fumendoesp_6 as fumendesp6 ,clfeea_fumendoesp_7 as fumendesp7 ,clfeea_fumendoesp_8 as fumendesp8 ,clfeea_fumendoesp_9 as fumendesp9 ,clfeea_fumendoesp_10 as fumendesp10 ,clfeea_fumendoesp_11 as fumendesp11 ,clfeea_fumendoesp_12 as fumendesp12 ,clfeea_fumendoesp_13 as fumendesp13 ,clfeea_fumendoesp_14 as fumendesp14 ,clfeea_fumendoesp_15 as fumendesp15 ,clfeea_fumendoesp_16 as fumendesp16 ,clfeea_fumendoesp_17 as fumendesp17 ,clfeea_fumendoesp_18 as fumendesp18 ,clfeea_fumendoesp_19 as fumendesp19 ,clfeea_fumendoesp_20 as fumendesp20 ,clfeea_fumendoesp_21 as fumendesp21 ,clfeea_fumendoesp_22 as fumendesp22 ,clfeea_fumendoesp_23 as fumendesp23 ,clfeea_fumendoesp_24 as fumendesp24 ,clfeea_fumendoesp_25 as fumendesp25 ,clfeea_fumendoesp_26 as fumendesp26 ,clfeea_fumendoesp_27 as fumendesp27 ,clfeea_fumendopat_1 as fumendpat1 ,clfeea_fumendopat_2 as fumendpat2 ,clfeea_fumendopat_3 as fumendpat3 ,clfeea_fumendopat_4 as fumendpat4 ,clfeea_fumendopat_5 as fumendpat5 ,clfeea_fumendopat_6 as fumendpat6 ,clfeea_fumendopat_7 as fumendpat7 ,clfeea_fumendopat_8 as fumendpat8 ,clfeea_fumendopat_9 as fumendpat9 ,clfeea_fumendopat_10 as fumendpat10 ,clfeea_fumendopat_11 as fumendpat11 ,clfeea_fumendopat_12 as fumendpat12 ,clfeea_fumendopat_13 as fumendpat13 ,clfeea_fumendopat_14 as fumendpat14 ,clfeea_fumendopat_15 as fumendpat15 ,clfeea_fumendopat_16 as fumendpat16 ,clfeea_fumendopat_17 as fumendpat17 ,clfeea_fumendopat_18 as fumendpat18 ,clfeea_fumendopat_19 as fumendpat19 ,clfeea_fumendopat_20 as fumendpat20 ,clfeea_fumendopat_21 as fumendpat21 ,clfeea_fumendopat_22 as fumendpat22 ,clfeea_fumendopat_23 as fumendpat23 ,clfeea_fumendopat_24 as fumendpat24 ,clfeea_fumendopat_25 as fumendpat25 ,clfeea_fumendopat_26 as fumendpat26 ,clfeea_fumendopat_27 as fumendpat27 FROM cli_fer_estalta as e WHERE e.cli_codigo = '".addslashes($idcliente)."' ORDER BY clfeea_numero DESC"; //print_r($sql);die; $rs = $GLOBALS['dbSQL']->Query($sql); if ( !$rs ) { return false; } $result["estalta"] = $GLOBALS['dbSQL']->getAll(); //--------------------------------------------------------- //--------------------------------------------------------- // HX MEDICA //--------------------------------------------------------- $sql = "SELECT clfehcm_numero as cod ,cli_codigo as clicod ,clfehcm_pareja as pareja ,clfehcm_modalidad as modalidad ,clfehcm_pacok as tipox ,FORMAT(clfehcm_1rafechaconsul, 'dd/MM/yyyy' ) as fecha1ercon ,clfehcm_trabajoactual as trabactual ,clfehcm_hijospareja as hijospareja ,clfehcm_referencia as referencia ,clfehcm_comentario as comentario ,clfehcm_comentariopriv as comentarioint ,clfehcm_diagnostico1 as diagnostico_1 ,clfehcm_diagnostico2 as diagnostico_2 ,clfehcm_ritmomenstrual as tm ,clfehcm_anapatologica as anatomiapato ,clfehcm_esterilidad as esterilidad ,clfehcm_esttiempo as tiempoesteril ,clfehcm_abortos as abortos ,clfehcm_saf as saf ,clfehcm_cardiolipinas as cardiolipinas ,clfehcm_aclupico as aclupico ,clfehcm_b2 as b2 ,clfehcm_gestacion as gestacion ,clfehcm_partos as partos ,clfehcm_hijosdeseados as hdeseados ,clfehcm_talla as talla ,clfehcm_peso as peso ,clfehcm_dismenorrea as dismenorrea ,clfehcm_hipermenorrea as hipermenorrea ,clfehcm_dispareunia as dispareunia ,clfehcm_frecrs as frecrs ,clfehcm_hirsutism as hirsutism ,clfehcm_medicamento as medicacion ,clfehcm_fuma as fuma ,clfehcm_genetico as genetico ,clfehcm_pap as pap ,clfehcm_cirugiasprevias as cirujprev ,clfehcm_hiv as hiv ,clfehcm_celiaquia as celiaquia ,clfehcm_pareja_edad as edadpareja ,clfehcm_pareja_medicacion as medpareja ,clfehcm_pareja_hipertension as hipertensionpareja ,clfehcm_pareja_obesidad as obesidadpareja ,clfehcm_pareja_fuma as fumapareja ,clfehcm_pareja_varicocele as varicocele ,clfehcm_pareja_genetico as geneticopareja ,clfehcm_endocrino_fsh as fsh ,clfehcm_endocrino_lh as lh ,clfehcm_endocrino_e2 as e2 ,clfehcm_endocrino_prol as prol ,clfehcm_endocrino_androg as androg ,clfehcm_endocrino_amh as amh ,clfehcm_endocrino_glucemia as glucemia ,clfehcm_endocrino_insulina as insulina ,clfehcm_endocrino_homa as homa ,clfehcm_endocrino_tsh as tsh ,clfehcm_endocrino_t4 as t4 ,clfehcm_tuboperitoneal_hsg as hsg ,clfehcm_tuboperitoneal_utero as utero ,FORMAT(clfehcm_tuboperitoneal_fecha1, 'dd/MM/yyyy' ) as fechatrompas ,clfehcm_tuboperitoneal_trompas as trompas ,clfehcm_tuboperitoneal_ecotv as ecotv ,clfehcm_tuboperitoneal_ecoutero as ecoutero ,clfehcm_tuboperitoneal_ovarios as ovarios ,FORMAT(clfehcm_tuboperitoneal_fecha2, 'dd/MM/yyyy' ) as fechatrompas2 ,clfehcm_tuboperitoneal_trompas2 as trompas2 ,clfehcm_cultivo_chlamydias as chlamydias ,clfehcm_cultivo_mycoplasma as mycoplasma ,clfehcm_cultivo_ureaplama as ureaplama ,clfehcm_tratferprev_tratamiento as tratamiento ,clfehcm_tratferprev_aid as aid ,clfehcm_tratferprev_fiv as fiv ,clfehcm_tratferprev_resultado as resultado ,clfehcm_trapropuesto_aih as aih ,clfehcm_trapropuesto_fiv as fiv2 ,clfehcm_trapropuesto_tratamiento1 as tratpro1 ,clfehcm_trapropuesto_tratamiento2 as tratpro2 ,clfehcm_trapropuesto_otros as otros ,clfehcm_trapropuesto_comentario as comentariotrprop ,clfehcm_hiscligin_motivoconsulta1 as hcginmotcon ,clfehcm_hiscligin_motivoconsulta2 as hcginmotcon2 ,clfehcm_hiscligin_motivoconsulta3 as hcginmotcon3 ,clfehcm_hiscligin_motivoconsulta4 as hcginmotcon4 ,clfehcm_hiscligin_papanicolau as papanicolau ,clfehcm_hiscligin_colposcopia as colposcopia ,clfehcm_hiscligin_examenginec1 as examgine ,clfehcm_hiscligin_examenginec2 as examgine2 ,clfehcm_hiscligin_ovarios1 as examgineova ,clfehcm_hiscligin_ovarios2 as examgineova2 ,clfehcm_hiscligin_examenmamario as examginemam ,clfehcm_hiscligin_estudiossolicit1 as hcginecoestsol1 ,clfehcm_hiscligin_estudiossolicit2 as hcginecoestsol2 ,clfehcm_hiscligin_estudiossolicit3 as hcginecoestsol3 ,clfehcm_hiscligin_cirugiasprevias as hcginecocirprev ,clfehcm_hiscligin_ecografiamamaria as hcginecoecomam ,clfehcm_hiscligin_ecografiagineco as hcginecoestado ,clfehcm_hiscligin_papanicolaou as papanicolaou ,clfehcm_hiscligin_mamografia as mamografia ,clfehcm_hiscligin_densitometria as densitometria ,clfehcm_hiscligin_comentario as hcginecocomentario FROM cli_fer_hxmedia as e WHERE e.cli_codigo = '".addslashes($idcliente)."' ORDER BY clfehcm_numero DESC"; //print_r($sql);die; $rs = $GLOBALS['dbSQL']->Query($sql); if ( !$rs ) { return false; } $result["hcmed"] = $GLOBALS['dbSQL']->getAll(); //--------------------------------------------------------- //--------------------------------------------------------- // HX ESPERMOGRAMA //--------------------------------------------------------- if( is_array($result["hcmed"]) && count($result["hcmed"])>0 && isset($result["hcmed"][0]) && isset($result["hcmed"][0]["cod"]) ) { $sql = "SELECT clhxmeesp_numero as cod ,clfehcm_numero as hxcod ,clhxmeesp_ml AS ml ,clhxmeesp_ab as ab ,clhxmeesp_terato as terato ,clhxmeesp_vol as vol ,clhxmeesp_fragmen as fragmentacion ,FORMAT(clhxmeesp_fecha, 'dd/MM/yyyy' ) as fecha FROM cli_fer_hxmedia_espermograma as e WHERE clfehcm_numero = '".$result["hcmed"][0]["cod"]."' ORDER BY clhxmeesp_numero DESC"; //print_r($sql);die; $rs = $GLOBALS['dbSQL']->Query($sql); if ( $rs ) { $result["espermograma"] = $GLOBALS['dbSQL']->getAll(); } } //--------------------------------------------------------- //--------------------------------------------------------- // HX ESTUDIOS //--------------------------------------------------------- if( is_array($result["hcmed"]) && count($result["hcmed"])>0 && isset($result["hcmed"][0]) && isset($result["hcmed"][0]["cod"]) ) { $sql = "SELECT clhxmeestsol_numero as cod ,clfehcm_numero as clicod ,clhxmeestsol_estudio AS estudio ,FORMAT(clhxmeestsol_fecha, 'dd/MM/yyyy' ) as fecha FROM cli_fer_hxmedia_estudios_solicitados as e WHERE clfehcm_numero = '".$result["hcmed"][0]["cod"]."' ORDER BY clhxmeestsol_numero DESC"; //print_r($sql);die; $rs = $GLOBALS['dbSQL']->Query($sql); if ( $rs ) { $result["estudios"] = $GLOBALS['dbSQL']->getAll(); } } //--------------------------------------------------------- //print_r($result);die; // print_r($result["hc"]);die; // print_r($result["estbaja"]);die; return $result; } function getFerHcMedica() { $where = ""; if(isset($_REQUEST["cli"])) { $resultado = getFerHcPaciente($_REQUEST["cli"]); if ( $resultado ) { if( is_array($resultado)&&count($resultado)>0 ) { return $resultado; } return EMPTY_LST; } } //print_r($sql);die; return false; } function existIFERHxMedGineco($clicod) { $sql = "SELECT clfehcm_numero FROM cli_fer_hxmedia WHERE cli_codigo = '".addslashes($clicod)."'"; //print_r($sql);print_r("\n");//die; $rs = $GLOBALS['dbSQL']->Query($sql); if ( $rs ) { $resultado = $GLOBALS['dbSQL']->getAll(); if(is_array($resultado)&&count($resultado)>0) { return $resultado[0]["clfehcm_numero"]; } } return false; } function saveFertilidadHx(&$resultInfo,$params) { try { $params["params"] = json_decode($params["params"]); //print_r($params);//die("-----#-----"); /* Array ( [items] => Array ( [0] => Array ( [clicod] => 93093 [hx] => Array ( [pareja] => 1 [modalidad] => 1 [fecha1ercon] => 06/03/2024 [diagnostico_1] => [diagnostico_2] => [tipox] => 2 [trabactual] => aaaaaaa [hijospareja] => 1 [esterilidad] => [tiempoesteril] => [abortos] => [saf] => [cardiolipinas] => [aclupico] => [tiempo] => [referencia] => bbbbbbbbbbb [comentario] => ccccccccccccc [comentarioint] => ddddddddddddddddd [anatomiapato] => [b2] => [gestacion] => [partos] => [hdeseados] => [talla] => [peso] => [imc] => [tm] => [dismenorrea] => [hipermenorrea] => [dispareunia] => [frecrs] => [hirsutism] => [medicacion] => [fuma] => [genetico] => [pap] => [cirujprev] => [fechacx] => [hiv] => [bmi] => [ecotv] => [edadpareja] => [medpareja] => [hipertensionpareja] => [obesidadpareja] => [fumapareja] => [varicocele] => [geneticopareja] => [fsh] => [androg] => [amh] => [glucemia] => [insulina] => [homa] => [ths] => [hsg] => [utero] => [futerocompletar] => [ftrompcompletar] => [fecotvuteopcompletar] => [ovarios] => [trompas] => [esp_ml] => [esp_ab] => [esp_terato] => [esp_vol] => [esp_fragmentacion] => [estsolicitado_1] => [estsolicitado_2] => [estsolicitado_3] => [estsolicitado_4] => [estsolicitado_5] => [estsolicitado_6] => [estsolicitado_7] => ) [hxesperma] => Array ( ) [hxestudios] => Array ( ) [estbaja] => Array ( [0] => Array ( [flagemb] => [temb] => 1 [droga] => 1 [tiprocedimiento] => [semen] => [semenorigen] => [subunidadbeta] => [fum] => 26/03/2024 [fum_1] => 27/03/2024 [fum_2] => 28/03/2024 [fum_3] => 29/03/2024 [fum_4] => 30/03/2024 [fum_5] => 31/03/2024 [fum_6] => 01/04/2024 [fum_7] => 02/04/2024 [fum_8] => 03/04/2024 [fum_9] => 04/04/2024 [fum_10] => 05/04/2024 [fum_11] => 06/04/2024 [fum_12] => 07/04/2024 [fum_13] => 08/04/2024 [fum_14] => 09/04/2024 [fum_15] => 10/04/2024 [fum_16] => 11/04/2024 [fum_17] => 12/04/2024 [fum_18] => 13/04/2024 [fum_19] => 14/04/2024 [fum_20] => 15/04/2024 [fum_21] => 16/04/2024 [fum_22] => 17/04/2024 [fum_23] => 18/04/2024 [fum_24] => 19/04/2024 [fum_25] => 20/04/2024 [fum_26] => 21/04/2024 [fum_27] => 22/04/2024 [fumDay_1] => Miercoles [fumDay_2] => Jueves [fumDay_3] => Viernes [fumDay_4] => Sabado [fumDay_5] => Domingo [fumDay_6] => Lunes [fumDay_7] => Martes [fumDay_8] => Miercoles [fumDay_9] => Jueves [fumDay_10] => Viernes [fumDay_11] => Sabado [fumDay_12] => Domingo [fumDay_13] => Lunes [fumDay_14] => Martes [fumDay_15] => Miercoles [fumDay_16] => Jueves [fumDay_17] => Viernes [fumDay_18] => Sabado [fumDay_19] => Domingo [fumDay_20] => Lunes [fumDay_21] => Martes [fumDay_22] => Miercoles [fumDay_23] => Jueves [fumDay_24] => Viernes [fumDay_25] => Sabado [fumDay_26] => Domingo [fumDay_27] => Lunes [fumVal_1] => 123 [fumVal_2] => [fumVal_3] => [fumVal_4] => 654 [fumVal_5] => [fumVal_6] => [fumVal_7] => [fumVal_8] => [fumVal_9] => [fumVal_10] => [fumVal_11] => [fumVal_12] => [fumVal_13] => [fumVal_14] => [fumVal_15] => [fumVal_16] => [fumVal_17] => [fumVal_18] => [fumVal_19] => [fumVal_20] => [fumVal_21] => [fumVal_22] => [fumVal_23] => [fumVal_24] => [fumVal_25] => [fumVal_26] => [fumVal_27] => [fumOvI_1] => [fumOvI_2] => 35 [fumOvI_3] => [fumOvI_4] => 10 [fumOvI_5] => [fumOvI_6] => [fumOvI_7] => [fumOvI_8] => [fumOvI_9] => [fumOvI_10] => [fumOvI_11] => [fumOvI_12] => [fumOvI_13] => [fumOvI_14] => [fumOvI_15] => [fumOvI_16] => [fumOvI_17] => [fumOvI_18] => [fumOvI_19] => [fumOvI_20] => [fumOvI_21] => [fumOvI_22] => [fumOvI_23] => [fumOvI_24] => [fumOvI_25] => [fumOvI_26] => [fumOvI_27] => [fumOvD_1] => [fumOvD_2] => 40 [fumOvD_3] => [fumOvD_4] => 20 [fumOvD_5] => [fumOvD_6] => [fumOvD_7] => [fumOvD_8] => [fumOvD_9] => [fumOvD_10] => [fumOvD_11] => [fumOvD_12] => [fumOvD_13] => [fumOvD_14] => [fumOvD_15] => [fumOvD_16] => [fumOvD_17] => [fumOvD_18] => [fumOvD_19] => [fumOvD_20] => [fumOvD_21] => [fumOvD_22] => [fumOvD_23] => [fumOvD_24] => [fumOvD_25] => [fumOvD_26] => [fumOvD_27] => [fumendoesp_1] => [fumendoesp_2] => 25 [fumendoesp_3] => [fumendoesp_4] => 78 [fumendoesp_5] => [fumendoesp_6] => [fumendoesp_7] => [fumendoesp_8] => [fumendoesp_9] => [fumendoesp_10] => [fumendoesp_11] => [fumendoesp_12] => [fumendoesp_13] => [fumendoesp_14] => [fumendoesp_15] => [fumendoesp_16] => [fumendoesp_17] => [fumendoesp_18] => [fumendoesp_19] => [fumendoesp_20] => [fumendoesp_21] => [fumendoesp_22] => [fumendoesp_23] => [fumendoesp_24] => [fumendoesp_25] => [fumendoesp_26] => [fumendoesp_27] => [fumendopat_1] => [fumendopat_2] => 1 [fumendopat_3] => [fumendopat_4] => 3 [fumendopat_5] => [fumendopat_6] => [fumendopat_7] => [fumendopat_8] => [fumendopat_9] => [fumendopat_10] => [fumendopat_11] => [fumendopat_12] => [fumendopat_13] => [fumendopat_14] => [fumendopat_15] => [fumendopat_16] => [fumendopat_17] => [fumendopat_18] => [fumendopat_19] => [fumendopat_20] => [fumendopat_21] => [fumendopat_22] => [fumendopat_23] => [fumendopat_24] => [fumendopat_25] => [fumendopat_26] => [fumendopat_27] => ) ) ) ) [params] => Array ( ) [userid] => 98 ) -----#----- */ if( is_array($params["items"]) && count($params["items"])>0 ) { //print_r($params);die("-----AAAAA-----"); $continue = false; //OBTENER EL MEDICO $medico=false; $sql = "SELECT med_codigo FROM medicos WHERE usu_mapeo = " . $params["userid"]; //print_r($sql);print_r("\n");//die; $rs = $GLOBALS['dbSQL']->Query($sql); if ( $rs ) { $resultado = $GLOBALS['dbSQL']->getAll(); if(is_array($resultado)&&count($resultado)>0) { $medico=$resultado[0]["med_codigo"]; $continue = true; } } if(true||$continue) { $cmpInsertSQL = false; $cmpUpdateSQL = false; $cmpInsertaccMedSQL = false; $sqllst = array(); $sqllstTblChild = array(); //HISTORIA CLINICA GINECO /* [estbaja] => Array ( [0] => Array ( [flagemb] => [temb] => 2 [droga] => 1 [droga2] => [tiprocedimiento] => [semen] => [semenorigen] => [subunidadbeta] => [fum_1] => 20/05/2024 [fum_2] => 21/05/2024 [fum_3] => 22/05/2024 [fum_4] => 23/05/2024 [fum_5] => 24/05/2024 [fum_6] => 25/05/2024 [fum_7] => 26/05/2024 [fum_8] => 27/05/2024 [fum_9] => 28/05/2024 [fum_10] => 29/05/2024 [fum_11] => 30/05/2024 [fum_12] => 31/05/2024 [fum_13] => 01/06/2024 [fum_14] => 02/06/2024 [fum_15] => 03/06/2024 [fum_16] => 04/06/2024 [fum_17] => 05/06/2024 [fum_18] => 06/06/2024 [fum_19] => 07/06/2024 [fum_20] => 08/06/2024 [fum_21] => 09/06/2024 [fum_22] => 10/06/2024 [fum_23] => 11/06/2024 [fum_24] => 12/06/2024 [fum_25] => 13/06/2024 [fum_26] => 14/06/2024 [fum_27] => 15/06/2024 [fum_28] => 16/06/2024 [fumDay_1] => Lunes [fumDay_2] => Martes [fumDay_3] => Miercoles [fumDay_4] => Jueves [fumDay_5] => Viernes [fumDay_6] => Sabado [fumDay_7] => Domingo [fumDay_8] => Lunes [fumDay_9] => Martes [fumDay_10] => Miercoles [fumDay_11] => Jueves [fumDay_12] => Viernes [fumDay_13] => Sabado [fumDay_14] => Domingo [fumDay_15] => Lunes [fumDay_16] => Martes [fumDay_17] => Miercoles [fumDay_18] => Jueves [fumDay_19] => Viernes [fumDay_20] => Sabado [fumDay_21] => Domingo [fumDay_22] => Lunes [fumDay_23] => Martes [fumDay_24] => Miercoles [fumDay_25] => Jueves [fumDay_26] => Viernes [fumDay_27] => Sabado [fumDay_28] => Domingo [fumVal_1] => 1 [fumVal_2] => [fumVal_3] => 3 [fumVal_4] => [fumVal_5] => 4 [fumVal_6] => [fumVal_7] => 7 [fumVal_8] => [fumVal_9] => 9 [fumVal_10] => [fumVal_11] => [fumVal_12] => [fumVal_13] => [fumVal_14] => [fumVal_15] => [fumVal_16] => [fumVal_17] => [fumVal_18] => [fumVal_19] => [fumVal_20] => [fumVal_21] => [fumVal_22] => [fumVal_23] => [fumVal_24] => [fumVal_25] => [fumVal_26] => [fumVal_27] => [fumVal_28] => [fumVal2_1] => 1 [fumVal2_2] => [fumVal2_3] => 3 [fumVal2_4] => [fumVal2_5] => 4 [fumVal2_6] => [fumVal2_7] => 7 [fumVal2_8] => [fumVal2_9] => 9 [fumVal2_10] => [fumVal2_11] => [fumVal2_12] => [fumVal2_13] => [fumVal2_14] => [fumVal2_15] => [fumVal2_16] => [fumVal2_17] => [fumVal2_18] => [fumVal2_19] => [fumVal2_20] => [fumVal2_21] => [fumVal2_22] => [fumVal2_23] => [fumVal2_24] => [fumVal2_25] => [fumVal2_26] => [fumVal2_27] => [fumVal2_28] => [fumOvI_1] => 1 [fumOvI_2] => [fumOvI_3] => [fumOvI_4] => 3 [fumOvI_5] => [fumOvI_6] => [fumOvI_7] => 5 [fumOvI_8] => [fumOvI_9] => [fumOvI_10] => 7 [fumOvI_11] => [fumOvI_12] => [fumOvI_13] => [fumOvI_14] => [fumOvI_15] => [fumOvI_16] => [fumOvI_17] => [fumOvI_18] => [fumOvI_19] => [fumOvI_20] => [fumOvI_21] => [fumOvI_22] => [fumOvI_23] => [fumOvI_24] => [fumOvI_25] => [fumOvI_26] => [fumOvI_27] => [fumOvI_28] => [fumOvD_1] => [fumOvD_2] => 2 [fumOvD_3] => [fumOvD_4] => [fumOvD_5] => 4 [fumOvD_6] => [fumOvD_7] => [fumOvD_8] => 6 [fumOvD_9] => [fumOvD_10] => [fumOvD_11] => 8 [fumOvD_12] => [fumOvD_13] => [fumOvD_14] => [fumOvD_15] => [fumOvD_16] => [fumOvD_17] => [fumOvD_18] => [fumOvD_19] => [fumOvD_20] => [fumOvD_21] => [fumOvD_22] => [fumOvD_23] => [fumOvD_24] => [fumOvD_25] => [fumOvD_26] => [fumOvD_27] => [fumOvD_28] => [fumendoesp_1] => 10 [fumendoesp_2] => [fumendoesp_3] => 11 [fumendoesp_4] => [fumendoesp_5] => [fumendoesp_6] => [fumendoesp_7] => [fumendoesp_8] => [fumendoesp_9] => [fumendoesp_10] => [fumendoesp_11] => [fumendoesp_12] => [fumendoesp_13] => [fumendoesp_14] => [fumendoesp_15] => [fumendoesp_16] => [fumendoesp_17] => [fumendoesp_18] => [fumendoesp_19] => [fumendoesp_20] => [fumendoesp_21] => [fumendoesp_22] => [fumendoesp_23] => [fumendoesp_24] => [fumendoesp_25] => [fumendoesp_26] => [fumendoesp_27] => [fumendoesp_28] => [fumendopat_1] => 1 [fumendopat_2] => [fumendopat_3] => [fumendopat_4] => 2 [fumendopat_5] => [fumendopat_6] => [fumendopat_7] => [fumendopat_8] => [fumendopat_9] => [fumendopat_10] => [fumendopat_11] => [fumendopat_12] => [fumendopat_13] => [fumendopat_14] => [fumendopat_15] => [fumendopat_16] => [fumendopat_17] => [fumendopat_18] => [fumendopat_19] => [fumendopat_20] => [fumendopat_21] => [fumendopat_22] => [fumendopat_23] => [fumendopat_24] => [fumendopat_25] => [fumendopat_26] => [fumendopat_27] => [fumendopat_28] => ) ) ) ) [params] => Array ( ) [userid] => 98 ) */ //celiaquia //--------------------------------------------------------- // HX MEDICA //--------------------------------------------------------- //VERIFICAR SI EXISTE UNA HX MED GINECO $idHxMedGineco = existIFERHxMedGineco($params["items"][0]["clicod"]); //print_r($params["items"][0]["hx"]);print_r("\n"); $pareja = getDBNullValue(trim($params["items"][0]["hx"]["pareja"])); $pareja =($pareja=='NULL'?'NULL':$pareja); $modalidad = getDBNullValue(trim($params["items"][0]["hx"]["modalidad"])); $modalidad =($modalidad=='NULL'?'NULL':$modalidad); $tipox = getDBNullValue(trim($params["items"][0]["hx"]["tipox"])); $tipox =($tipox=='NULL'?'NULL':$tipox); $fecha1ercon = getDBNullValue(getDBDateFormated(trim($params["items"][0]["hx"]["fecha1ercon"]))); $trabactual = getDBNullValue(trim($params["items"][0]["hx"]["trabactual"])); $trabactual =($trabactual=='NULL'?'NULL':$trabactual); $hijospareja = getDBNullValue(trim($params["items"][0]["hx"]["hijospareja"])); $hijospareja =($hijospareja=='NULL'?'NULL':$hijospareja); $referencia = getDBNullValue(trim($params["items"][0]["hx"]["referencia"])); $referencia =($referencia=='NULL'?'NULL':$referencia); $comentario = getDBNullValue(trim($params["items"][0]["hx"]["comentario"])); $comentario =($comentario=='NULL'?'NULL':$comentario); $comentarioint = getDBNullValue(trim($params["items"][0]["hx"]["comentarioint"])); $comentarioint =($comentarioint=='NULL'?'NULL':$comentarioint); $diagnostico_1 = getDBNullValue(trim($params["items"][0]["hx"]["diagnostico_1"])); $diagnostico_1 =($diagnostico_1=='NULL'?'NULL':$diagnostico_1); $diagnostico_2 = getDBNullValue(trim($params["items"][0]["hx"]["diagnostico_2"])); $diagnostico_2 =($diagnostico_2=='NULL'?'NULL':$diagnostico_2); $tm = getDBNullValue(trim($params["items"][0]["hx"]["tm"])); $tm =($tm=='NULL'?'NULL':$tm); $anatomiapato = getDBNullValue(trim($params["items"][0]["hx"]["anatomiapato"])); $anatomiapato =($anatomiapato=='NULL'?'NULL':$anatomiapato); $esterilidad = getDBNullValue(trim($params["items"][0]["hx"]["esterilidad"])); $esterilidad =($esterilidad=='NULL'?'NULL':$esterilidad); $tiempoesteril = getDBNullValue(trim($params["items"][0]["hx"]["tiempoesteril"])); $tiempoesteril =($tiempoesteril=='NULL'?'NULL':$tiempoesteril); $abortos = getDBNullValue(trim($params["items"][0]["hx"]["abortos"])); $abortos =($abortos=='NULL'?'NULL':$abortos); $saf = getDBNullValue(trim($params["items"][0]["hx"]["saf"])); $saf =($saf=='NULL'?'NULL':$saf); $cardiolipinas = getDBNullValue(trim($params["items"][0]["hx"]["cardiolipinas"])); $cardiolipinas =($cardiolipinas=='NULL'?'NULL':$cardiolipinas); $aclupico = getDBNullValue(trim($params["items"][0]["hx"]["aclupico"])); $aclupico =($aclupico=='NULL'?'NULL':$aclupico); $b2 = getDBNullValue(trim($params["items"][0]["hx"]["b2"])); $b2 =($b2=='NULL'?'NULL':$b2); $gestacion = getDBNullValue(trim($params["items"][0]["hx"]["gestacion"])); $gestacion =($gestacion=='NULL'?'NULL':$gestacion); $partos = getDBNullValue(trim($params["items"][0]["hx"]["partos"])); $partos =($partos=='NULL'?'NULL':$partos); $hdeseados = getDBNullValue(trim($params["items"][0]["hx"]["hdeseados"])); $hdeseados =($hdeseados=='NULL'?'NULL':$hdeseados); $talla = getDBNullValue(trim($params["items"][0]["hx"]["talla"])); $talla =($talla=='NULL'?'NULL':$talla); $peso = getDBNullValue(trim($params["items"][0]["hx"]["peso"])); $peso =($peso=='NULL'?'NULL':$peso); $dismenorrea = getDBNullValue(trim($params["items"][0]["hx"]["dismenorrea"])); $dismenorrea =($dismenorrea=='NULL'?'NULL':$dismenorrea); $hipermenorrea = getDBNullValue(trim($params["items"][0]["hx"]["hipermenorrea"])); $hipermenorrea =($hipermenorrea=='NULL'?'NULL':$hipermenorrea); $dispareunia = getDBNullValue(trim($params["items"][0]["hx"]["dispareunia"])); $dispareunia =($dispareunia=='NULL'?'NULL':$dispareunia); $frecrs = getDBNullValue(trim($params["items"][0]["hx"]["frecrs"])); $frecrs =($frecrs=='NULL'?'NULL':$frecrs); $hirsutism = getDBNullValue(trim($params["items"][0]["hx"]["hirsutism"])); $hirsutism =($hirsutism=='NULL'?'NULL':$hirsutism); $medicacion = getDBNullValue(trim($params["items"][0]["hx"]["medicacion"])); $medicacion =($medicacion=='NULL'?'NULL':$medicacion); $fuma = getDBNullValue(trim($params["items"][0]["hx"]["fuma"])); $fuma =($fuma=='NULL'?'NULL':$fuma); $genetico = getDBNullValue(trim($params["items"][0]["hx"]["genetico"])); $genetico =($genetico=='NULL'?'NULL':$genetico); $pap = getDBNullValue(trim($params["items"][0]["hx"]["pap"])); $pap =($pap=='NULL'?'NULL':$pap); $cirujprev = getDBNullValue(trim($params["items"][0]["hx"]["cirujprev"])); $cirujprev =($cirujprev=='NULL'?'NULL':$cirujprev); $hiv = getDBNullValue(trim($params["items"][0]["hx"]["hiv"])); $hiv =($hiv=='NULL'?'NULL':$hiv); $celiaquia = getDBNullValue(trim($params["items"][0]["hx"]["celiaquia"])); $celiaquia =($celiaquia=='NULL'?'NULL':$celiaquia); $edadpareja = getDBNullValue(getDBDateFormated(trim($params["items"][0]["hx"]["edadpareja"]),"Y-m-d")); $medpareja = getDBNullValue(trim($params["items"][0]["hx"]["medpareja"])); $medpareja =($medpareja=='NULL'?'NULL':$medpareja); $hipertensionpareja = getDBNullValue(trim($params["items"][0]["hx"]["hipertensionpareja"])); $hipertensionpareja =($hipertensionpareja=='NULL'?'NULL':$hipertensionpareja); $obesidadpareja = getDBNullValue(trim($params["items"][0]["hx"]["obesidadpareja"])); $obesidadpareja =($obesidadpareja=='NULL'?'NULL':$obesidadpareja); $fumapareja = getDBNullValue(trim($params["items"][0]["hx"]["fumapareja"])); $fumapareja =($fumapareja=='NULL'?'NULL':$fumapareja); $varicocele = getDBNullValue(trim($params["items"][0]["hx"]["varicocele"])); $varicocele =($varicocele=='NULL'?'NULL':$varicocele); $geneticopareja = getDBNullValue(trim($params["items"][0]["hx"]["geneticopareja"])); $geneticopareja =($geneticopareja=='NULL'?'NULL':$geneticopareja); $fsh = getDBNullValue(trim($params["items"][0]["hx"]["fsh"])); $fsh =($fsh=='NULL'?'NULL':$fsh); $lh = getDBNullValue(trim($params["items"][0]["hx"]["lh"])); $lh =($lh=='NULL'?'NULL':$lh); $e2 = getDBNullValue(trim($params["items"][0]["hx"]["e2"])); $e2 =($e2=='NULL'?'NULL':$e2); $prol = getDBNullValue(trim($params["items"][0]["hx"]["prol"])); $prol =($prol=='NULL'?'NULL':$prol); $androg = getDBNullValue(trim($params["items"][0]["hx"]["androg"])); $androg =($androg=='NULL'?'NULL':$androg); $amh = getDBNullValue(trim($params["items"][0]["hx"]["amh"])); $amh =($amh=='NULL'?'NULL':$amh); $glucemia = getDBNullValue(trim($params["items"][0]["hx"]["glucemia"])); $glucemia =($glucemia=='NULL'?'NULL':$glucemia); $insulina = getDBNullValue(trim($params["items"][0]["hx"]["insulina"])); $insulina =($insulina=='NULL'?'NULL':$insulina); $homa = getDBNullValue(trim($params["items"][0]["hx"]["homa"])); $homa =($homa=='NULL'?'NULL':$homa); $tsh = getDBNullValue(trim($params["items"][0]["hx"]["tsh"])); $tsh =($tsh=='NULL'?'NULL':$tsh); $t4 = getDBNullValue(trim($params["items"][0]["hx"]["t4"])); $t4 =($t4=='NULL'?'NULL':$t4); $hsg = getDBNullValue(trim($params["items"][0]["hx"]["hsg"])); $hsg =($hsg=='NULL'?'NULL':$hsg); $ecotv = getDBNullValue(trim($params["items"][0]["hx"]["ecotv"])); $ecotv =($ecotv=='NULL'?'NULL':$ecotv); $ecoutero = getDBNullValue(trim($params["items"][0]["hx"]["ecoutero"])); $ecoutero =($ecoutero=='NULL'?'NULL':$ecoutero); $utero = getDBNullValue(trim($params["items"][0]["hx"]["utero"])); $utero =($utero=='NULL'?'NULL':$utero);//clfehcm_futerocompletar $ovarios = getDBNullValue(trim($params["items"][0]["hx"]["ovarios"])); $ovarios =($ovarios=='NULL'?'NULL':$ovarios); $fechatrompas = getDBNullValue(getDBDateFormated(trim($params["items"][0]["hx"]["fechatrompas"]))); $trompas = getDBNullValue(trim($params["items"][0]["hx"]["trompas"])); $trompas =($trompas=='NULL'?'NULL':$trompas); $trompas2 = getDBNullValue(trim($params["items"][0]["hx"]["trompas2"])); $trompas2 =($trompas2=='NULL'?'NULL':$trompas2); $fechatrompas2= getDBNullValue(getDBDateFormated(trim($params["items"][0]["hx"]["fechatrompas2"]))); $chlamydias = getDBNullValue(trim($params["items"][0]["hx"]["chlamydias"])); $chlamydias =($chlamydias=='NULL'?'NULL':$chlamydias); $mycoplasma = getDBNullValue(trim($params["items"][0]["hx"]["mycoplasma"])); $mycoplasma =($mycoplasma=='NULL'?'NULL':$mycoplasma); $ureaplama = getDBNullValue(trim($params["items"][0]["hx"]["ureaplama"])); $ureaplama =($ureaplama=='NULL'?'NULL':$ureaplama); $tratamiento = getDBNullValue(trim($params["items"][0]["hx"]["tratamiento"])); $tratamiento =($tratamiento=='NULL'?'NULL':$tratamiento); $aid = getDBNullValue(trim($params["items"][0]["hx"]["aid"])); $aid =($aid=='NULL'?'NULL':$aid); $fiv = getDBNullValue(trim($params["items"][0]["hx"]["fiv"])); $fiv =($fiv=='NULL'?'NULL':$fiv); $resultado = getDBNullValue(trim($params["items"][0]["hx"]["resultado"])); $resultado =($resultado=='NULL'?'NULL':$resultado); $aih = getDBNullValue(trim($params["items"][0]["hx"]["aih"])); $aih =($aih=='NULL'?'NULL':$aih); $fiv2 = getDBNullValue(trim($params["items"][0]["hx"]["fiv2"])); $fiv2 =($fiv2=='NULL'?'NULL':$fiv2); $tratpro1 = getDBNullValue(trim($params["items"][0]["hx"]["tratpro1"])); $tratpro1 =($tratpro1=='NULL'?'NULL':$tratpro1); $tratpro2 = getDBNullValue(trim($params["items"][0]["hx"]["tratpro2"])); $tratpro2 =($tratpro2=='NULL'?'NULL':$tratpro2); $otros = getDBNullValue(trim($params["items"][0]["hx"]["otros"])); $otros =($otros=='NULL'?'NULL':$otros); $comentariotrprop = getDBNullValue(trim($params["items"][0]["hx"]["comentariotrprop"])); $comentariotrprop =($comentariotrprop=='NULL'?'NULL':$comentariotrprop); //$fechacx = getDBNullValue(trim($params["items"][0]["hx"]["fechacx"])); $fechacx =($fechacx=='NULL'?'NULL':$fechacx); //$bmi = getDBNullValue(trim($params["items"][0]["hx"]["bmi"])); $bmi =($bmi=='NULL'?'NULL':$bmi); $edadpareja = getDBNullValue(trim($params["items"][0]["hx"]["edadpareja"])); $edadpareja =($edadpareja=='NULL'?'NULL':$edadpareja); $utero = getDBNullValue(trim($params["items"][0]["hx"]["utero"])); $utero =($utero=='NULL'?'NULL':$utero); $hcginmotcon= getDBNullValue(trim($params["items"][0]["hx"]["hcginmotcon"])); $hcginmotcon =($hcginmotcon=='NULL'?'NULL':$hcginmotcon); $hcginmotcon2= getDBNullValue(trim($params["items"][0]["hx"]["hcginmotcon2"])); $hcginmotcon2 =($hcginmotcon2=='NULL'?'NULL':$hcginmotcon2); $hcginmotcon3= getDBNullValue(trim($params["items"][0]["hx"]["hcginmotcon3"])); $hcginmotcon3 =($hcginmotcon3=='NULL'?'NULL':$hcginmotcon3); $hcginmotcon4= getDBNullValue(trim($params["items"][0]["hx"]["hcginmotcon4"])); $hcginmotcon4 =($hcginmotcon4=='NULL'?'NULL':$hcginmotcon4); $papanicolau= getDBNullValue(trim($params["items"][0]["hx"]["papanicolau"])); $papanicolau =($papanicolau=='NULL'?'NULL':$papanicolau); $colposcopia= getDBNullValue(trim($params["items"][0]["hx"]["colposcopia"])); $colposcopia =($colposcopia=='NULL'?'NULL':$colposcopia); $examgine= getDBNullValue(trim($params["items"][0]["hx"]["examgine"])); $examgine =($examgine=='NULL'?'NULL':$examgine); $examgine2= getDBNullValue(trim($params["items"][0]["hx"]["examgine2"])); $examgine2 =($examgine2=='NULL'?'NULL':$examgine2); $examgineova= getDBNullValue(trim($params["items"][0]["hx"]["examgineova"])); $examgineova =($examgineova=='NULL'?'NULL':$examgineova); $examgineova2= getDBNullValue(trim($params["items"][0]["hx"]["examgineova2"])); $examgineova2 =($examgineova2=='NULL'?'NULL':$examgineova2); $examginemam= getDBNullValue(trim($params["items"][0]["hx"]["examginemam"])); $examginemam =($examginemam=='NULL'?'NULL':$examginemam); $hcginecoestsol1= getDBNullValue(trim($params["items"][0]["hx"]["hcginecoestsol1"])); $hcginecoestsol1 =($hcginecoestsol1=='NULL'?'NULL':$hcginecoestsol1); $hcginecoestsol2= getDBNullValue(trim($params["items"][0]["hx"]["hcginecoestsol2"])); $hcginecoestsol2 =($hcginecoestsol2=='NULL'?'NULL':$hcginecoestsol2); $hcginecoestsol3= getDBNullValue(trim($params["items"][0]["hx"]["hcginecoestsol3"])); $hcginecoestsol3 =($hcginecoestsol3=='NULL'?'NULL':$hcginecoestsol3); $hcginecocirprev= getDBNullValue(trim($params["items"][0]["hx"]["hcginecocirprev"])); $hcginecocirprev =($hcginecocirprev=='NULL'?'NULL':$hcginecocirprev); $hcginecoecomam= getDBNullValue(trim($params["items"][0]["hx"]["hcginecoecomam"])); $hcginecoecomam =($hcginecoecomam=='NULL'?'NULL':$hcginecoecomam); $hcginecoestado= getDBNullValue(trim($params["items"][0]["hx"]["hcginecoestado"])); $hcginecoestado =($hcginecoestado=='NULL'?'NULL':$hcginecoestado); $papanicolaou= getDBNullValue(trim($params["items"][0]["hx"]["papanicolaou"])); $papanicolaou =($papanicolaou=='NULL'?'NULL':$papanicolaou); $mamografia= getDBNullValue(trim($params["items"][0]["hx"]["mamografia"])); $mamografia =($mamografia=='NULL'?'NULL':$mamografia); $densitometria= getDBNullValue(trim($params["items"][0]["hx"]["densitometria"])); $densitometria =($densitometria=='NULL'?'NULL':$densitometria); $hcginecocomentario= getDBNullValue(trim($params["items"][0]["hx"]["hcginecocomentario"])); $hcginecocomentario =($hcginecocomentario=='NULL'?'NULL':$hcginecocomentario); if(!$idHxMedGineco) { $hxmedgineco = "INSERT INTO cli_fer_hxmedia( cli_codigo ,clfehcm_pareja ,clfehcm_modalidad ,clfehcm_pacok ,clfehcm_1rafechaconsul ,clfehcm_trabajoactual ,clfehcm_hijospareja ,clfehcm_referencia ,clfehcm_comentario ,clfehcm_comentariopriv ,clfehcm_diagnostico1 ,clfehcm_diagnostico2 ,clfehcm_ritmomenstrual ,clfehcm_anapatologica ,clfehcm_esterilidad ,clfehcm_esttiempo ,clfehcm_abortos ,clfehcm_saf ,clfehcm_cardiolipinas ,clfehcm_aclupico ,clfehcm_b2 ,clfehcm_gestacion ,clfehcm_partos ,clfehcm_hijosdeseados ,clfehcm_talla ,clfehcm_peso ,clfehcm_dismenorrea ,clfehcm_hipermenorrea ,clfehcm_dispareunia ,clfehcm_frecrs ,clfehcm_hirsutism ,clfehcm_medicamento ,clfehcm_fuma ,clfehcm_genetico ,clfehcm_pap ,clfehcm_cirugiasprevias ,clfehcm_hiv ,clfehcm_celiaquia ,clfehcm_pareja_edad ,clfehcm_pareja_medicacion ,clfehcm_pareja_hipertension ,clfehcm_pareja_obesidad ,clfehcm_pareja_fuma ,clfehcm_pareja_varicocele ,clfehcm_pareja_genetico ,clfehcm_endocrino_fsh ,clfehcm_endocrino_lh ,clfehcm_endocrino_e2 ,clfehcm_endocrino_prol ,clfehcm_endocrino_androg ,clfehcm_endocrino_amh ,clfehcm_endocrino_glucemia ,clfehcm_endocrino_insulina ,clfehcm_endocrino_homa ,clfehcm_endocrino_tsh ,clfehcm_endocrino_t4 ,clfehcm_tuboperitoneal_hsg ,clfehcm_tuboperitoneal_utero ,clfehcm_tuboperitoneal_fecha1 ,clfehcm_tuboperitoneal_trompas ,clfehcm_tuboperitoneal_ecotv ,clfehcm_tuboperitoneal_ecoutero ,clfehcm_tuboperitoneal_ovarios ,clfehcm_tuboperitoneal_fecha2 ,clfehcm_tuboperitoneal_trompas2 ,clfehcm_cultivo_chlamydias ,clfehcm_cultivo_mycoplasma ,clfehcm_cultivo_ureaplama ,clfehcm_tratferprev_tratamiento ,clfehcm_tratferprev_aid ,clfehcm_tratferprev_fiv ,clfehcm_tratferprev_resultado ,clfehcm_trapropuesto_aih ,clfehcm_trapropuesto_fiv ,clfehcm_trapropuesto_tratamiento1 ,clfehcm_trapropuesto_tratamiento2 ,clfehcm_trapropuesto_otros ,clfehcm_trapropuesto_comentario ,clfehcm_hiscligin_motivoconsulta1 ,clfehcm_hiscligin_motivoconsulta2 ,clfehcm_hiscligin_motivoconsulta3 ,clfehcm_hiscligin_motivoconsulta4 ,clfehcm_hiscligin_papanicolau ,clfehcm_hiscligin_colposcopia ,clfehcm_hiscligin_examenginec1 ,clfehcm_hiscligin_examenginec2 ,clfehcm_hiscligin_ovarios1 ,clfehcm_hiscligin_ovarios2 ,clfehcm_hiscligin_examenmamario ,clfehcm_hiscligin_estudiossolicit1 ,clfehcm_hiscligin_estudiossolicit2 ,clfehcm_hiscligin_estudiossolicit3 ,clfehcm_hiscligin_cirugiasprevias ,clfehcm_hiscligin_ecografiamamaria ,clfehcm_hiscligin_ecografiagineco ,clfehcm_hiscligin_papanicolaou ,clfehcm_hiscligin_mamografia ,clfehcm_hiscligin_densitometria ,clfehcm_hiscligin_comentario ,emp_codigo_registracion ,emp_codigo_ult_cambio ,clfehcm_tmsp_registracion ,clfehcm_tmsp_ult_cambio ) VALUES ( '".$params["items"][0]["clicod"]."' ,".$pareja." ,".$modalidad." ,".$tipox." ,".$fecha1ercon." ,".$trabactual." ,".$hijospareja." ,".$referencia." ,".$comentario." ,".$comentarioint." ,".$diagnostico_1." ,".$diagnostico_2." ,".$tm." ,".$anatomiapato." ,".$esterilidad." ,".$tiempoesteril." ,".$abortos." ,".$saf." ,".$cardiolipinas." ,".$aclupico." ,".$b2." ,".$gestacion." ,".$partos." ,".$hdeseados." ,".$talla." ,".$peso." ,".$dismenorrea." ,".$hipermenorrea." ,".$dispareunia." ,".$frecrs." ,".$hirsutism." ,".$medicacion." ,".$fuma." ,".$genetico." ,".$pap." ,".$cirujprev." ,".$hiv." ,".$celiaquia." ,".$edadpareja." ,".$medpareja." ,".$hipertensionpareja." ,".$obesidadpareja." ,".$fumapareja." ,".$varicocele." ,".$geneticopareja." ,".$fsh." ,".$lh." ,".$e2." ,".$prol." ,".$androg." ,".$amh." ,".$glucemia." ,".$insulina." ,".$homa." ,".$tsh." ,".$t4." ,".$hsg." ,".$utero." ,".$fechatrompas." ,".$trompas." ,".$ecotv." ,".$ecoutero." ,".$ovarios." ,".$fechatrompas2." ,".$trompas2." ,".$chlamydias." ,".$mycoplasma." ,".$ureaplama." ,".$tratamiento." ,".$aid." ,".$fiv." ,".$resultado." ,".$aih." ,".$fiv2." ,".$tratpro1." ,".$tratpro2." ,".$otros." ,".$comentariotrprop." ,".$hcginmotcon." ,".$hcginmotcon2." ,".$hcginmotcon3." ,".$hcginmotcon4." ,".$papanicolau." ,".$colposcopia." ,".$examgine." ,".$examgine2." ,".$examgineova." ,".$examgineova2." ,".$examginemam." ,".$hcginecoestsol1." ,".$hcginecoestsol2." ,".$hcginecoestsol3." ,".$hcginecocirprev." ,".$hcginecoecomam." ,".$hcginecoestado." ,".$papanicolaou." ,".$mamografia." ,".$densitometria." ,".$hcginecocomentario." ,".$params["userid"]." ,".$params["userid"]." ,GETDATE() ,GETDATE() )" ; //$x = array_push($sqllst,$hxmedgineco); } else { $hxmedgineco = "UPDATE cli_fer_hxmedia SET clfehcm_pareja =".$pareja." ,clfehcm_modalidad =".$modalidad." ,clfehcm_pacok =".$tipox." ,clfehcm_1rafechaconsul =".$fecha1ercon." ,clfehcm_trabajoactual =".$trabactual." ,clfehcm_hijospareja =".$hijospareja." ,clfehcm_referencia =".$referencia." ,clfehcm_comentario =".$comentario." ,clfehcm_comentariopriv =".$comentarioint." ,clfehcm_diagnostico1 =".$diagnostico_1." ,clfehcm_diagnostico2 =".$diagnostico_2." ,clfehcm_ritmomenstrual =".$tm." ,clfehcm_anapatologica =".$anatomiapato." ,clfehcm_esterilidad =".$esterilidad." ,clfehcm_esttiempo =".$tiempoesteril." ,clfehcm_abortos =".$abortos." ,clfehcm_saf =".$saf." ,clfehcm_cardiolipinas =".$cardiolipinas." ,clfehcm_aclupico =".$aclupico." ,clfehcm_b2 =".$b2." ,clfehcm_gestacion =".$gestacion." ,clfehcm_partos =".$partos." ,clfehcm_hijosdeseados =".$hdeseados." ,clfehcm_talla =".$talla." ,clfehcm_peso =".$peso." ,clfehcm_dismenorrea =".$dismenorrea." ,clfehcm_hipermenorrea =".$hipermenorrea." ,clfehcm_dispareunia =".$dispareunia." ,clfehcm_frecrs =".$frecrs." ,clfehcm_hirsutism =".$hirsutism." ,clfehcm_medicamento =".$medicacion." ,clfehcm_fuma =".$fuma." ,clfehcm_genetico =".$genetico." ,clfehcm_pap =".$pap." ,clfehcm_cirugiasprevias =".$cirujprev." ,clfehcm_hiv =".$hiv." ,clfehcm_celiaquia =".$celiaquia." ,clfehcm_pareja_edad =".$edadpareja." ,clfehcm_pareja_medicacion =".$medpareja." ,clfehcm_pareja_hipertension =".$hipertensionpareja." ,clfehcm_pareja_obesidad =".$obesidadpareja." ,clfehcm_pareja_fuma =".$fumapareja." ,clfehcm_pareja_varicocele =".$varicocele." ,clfehcm_pareja_genetico =".$geneticopareja." ,clfehcm_endocrino_fsh =".$fsh." ,clfehcm_endocrino_lh =".$lh." ,clfehcm_endocrino_e2 =".$e2." ,clfehcm_endocrino_prol =".$prol." ,clfehcm_endocrino_androg =".$androg." ,clfehcm_endocrino_amh =".$amh." ,clfehcm_endocrino_glucemia =".$glucemia." ,clfehcm_endocrino_insulina =".$insulina." ,clfehcm_endocrino_homa =".$homa." ,clfehcm_endocrino_tsh =".$tsh." ,clfehcm_endocrino_t4 =".$t4." ,clfehcm_tuboperitoneal_hsg =".$hsg." ,clfehcm_tuboperitoneal_utero =".$utero." ,clfehcm_tuboperitoneal_fecha1 =".$fechatrompas." ,clfehcm_tuboperitoneal_trompas =".$trompas." ,clfehcm_tuboperitoneal_ecotv =".$ecotv." ,clfehcm_tuboperitoneal_ecoutero =".$ecoutero." ,clfehcm_tuboperitoneal_ovarios =".$ovarios." ,clfehcm_tuboperitoneal_fecha2 =".$fechatrompas2." ,clfehcm_tuboperitoneal_trompas2 =".$trompas2." ,clfehcm_cultivo_chlamydias =".$chlamydias." ,clfehcm_cultivo_mycoplasma =".$mycoplasma." ,clfehcm_cultivo_ureaplama =".$ureaplama." ,clfehcm_tratferprev_tratamiento =".$tratamiento." ,clfehcm_tratferprev_aid =".$aid." ,clfehcm_tratferprev_fiv =".$fiv." ,clfehcm_tratferprev_resultado =".$resultado." ,clfehcm_trapropuesto_aih =".$aih." ,clfehcm_trapropuesto_fiv =".$fiv2." ,clfehcm_trapropuesto_tratamiento1 =".$tratpro1." ,clfehcm_trapropuesto_tratamiento2 =".$tratpro2." ,clfehcm_trapropuesto_otros =".$otros." ,clfehcm_trapropuesto_comentario =".$comentariotrprop." ,clfehcm_hiscligin_motivoconsulta1 =".$hcginmotcon ." ,clfehcm_hiscligin_motivoconsulta2 =".$hcginmotcon2." ,clfehcm_hiscligin_motivoconsulta3 =".$hcginmotcon3." ,clfehcm_hiscligin_motivoconsulta4 =".$hcginmotcon4." ,clfehcm_hiscligin_papanicolau =".$papanicolau." ,clfehcm_hiscligin_colposcopia =".$colposcopia." ,clfehcm_hiscligin_examenginec1 =".$examgine." ,clfehcm_hiscligin_examenginec2 =".$examgine2." ,clfehcm_hiscligin_ovarios1 =".$examgineova." ,clfehcm_hiscligin_ovarios2 =".$examgineova2." ,clfehcm_hiscligin_examenmamario =".$examginemam." ,clfehcm_hiscligin_estudiossolicit1 =".$hcginecoestsol1." ,clfehcm_hiscligin_estudiossolicit2 =".$hcginecoestsol2." ,clfehcm_hiscligin_estudiossolicit3 =".$hcginecoestsol3." ,clfehcm_hiscligin_cirugiasprevias =".$hcginecocirprev." ,clfehcm_hiscligin_ecografiamamaria =".$hcginecoecomam." ,clfehcm_hiscligin_ecografiagineco =".$hcginecoestado." ,clfehcm_hiscligin_papanicolaou =".$papanicolaou." ,clfehcm_hiscligin_mamografia =".$mamografia." ,clfehcm_hiscligin_densitometria =".$densitometria." ,clfehcm_hiscligin_comentario =".$hcginecocomentario." ,clfehcm_tmsp_ult_cambio = GETDATE() ,emp_codigo_ult_cambio = '".$params["userid"]."' WHERE cli_codigo = '".$params["items"][0]["clicod"]."'" ; $x = array_push($sqllst,$hxmedgineco); } //--------------------------------------------------------- // HX ESPERMOGRAMA //--------------------------------------------------------- if( isset($params["items"][0]["hxesperma"]) && is_array($params["items"][0]["hxesperma"]) && $params["items"][0]["hxesperma"]>0 ) { for($i=0,$total=count($params["items"][0]["hxesperma"]);$i<$total;$i++) { $sqlItem = "INSERT INTO cli_fer_hxmedia_espermograma( clfehcm_numero ,clhxmeesp_fecha ,clhxmeesp_ml ,clhxmeesp_ab ,clhxmeesp_terato ,clhxmeesp_vol ,clhxmeesp_fragmen ) VALUES ( '{{ID}}' ,".getDBNullValue(getDBDateFormated(trim($params["items"][0]["hxesperma"][$i]["fecha"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["hxesperma"][$i]["ml"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["hxesperma"][$i]["ab"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["hxesperma"][$i]["terato"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["hxesperma"][$i]["vol"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["hxesperma"][$i]["fragmentacion"])))." )"; $x = array_push($sqllstTblChild,$sqlItem); } } //--------------------------------------------------------- // HX ESTUDIOS //--------------------------------------------------------- if( isset($params["items"][0]["hxestudios"]) && is_array($params["items"][0]["hxestudios"]) && $params["items"][0]["hxestudios"]>0 ) { for($i=0,$total=count($params["items"][0]["hxestudios"]);$i<$total;$i++) { $sqlItem = "INSERT INTO cli_fer_hxmedia_estudios_solicitados( clfehcm_numero ,clhxmeestsol_fecha ,clhxmeestsol_estudio ) VALUES ( '{{ID}}' ,".getDBNullValue(getDBDateFormated(trim($params["items"][0]["hxestudios"][$i]["fecha"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["hxestudios"][$i]["estn"])))." )"; $x = array_push($sqllstTblChild,$sqlItem); } } //--------------------------------------------------------- // HX ESTIMULACION BAJA COMPLEJIDAD //--------------------------------------------------------- if( isset($params["items"][0]["estbaja"]) && is_array($params["items"][0]["estbaja"]) && count($params["items"][0]["estbaja"])>0 ) {//print_r($params["items"][0]["estbaja"]);die; $hxbaja = "DELETE FROM cli_fer_estbaja WHERE cli_codigo = '".$params["items"][0]["clicod"]."'" ; $x = array_push($sqllst,$hxbaja); if( !is_null($params["items"][0]["estbaja"][$i]["flagemb"]) && !empty($params["items"][0]["estbaja"][$i]["flagemb"]) ) { $estado = 1; } else { $estado = 0; } //print_r($params["items"][0]["estbaja"]);print_r("\n"); //,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["temb"])))." for($i=0,$total=count($params["items"][0]["estbaja"]);$i<$total;$i++) { $ovariosI = ""; $ovariosD = ""; // ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumOvD_8"])))." //,clfeeb_fumOvD_28_v9 for($x=1;$x<=9;$x++) { for($k=1;$k<=28;$k++) { if(isset($params["items"][0]["estbaja"][$i]["fumOvI_".$k."_v".$x])) { $val = getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumOvI_".$k."_v".$x]))); } else { $val = 'NULL'; } $ovariosI.= ",".$val; } } for($x=1;$x<=9;$x++) { for($k=1;$k<=28;$k++) { if(isset($params["items"][0]["estbaja"][$i]["fumOvD_".$k."_v".$x])) { $val = getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumOvD_".$k."_v".$x]))); } else { $val = 'NULL'; } $ovariosD.= ",".$val; } } $sqlItem = "INSERT INTO cli_fer_estbaja( cli_codigo ,clfeeb_estadoitem ,clfeeb_tipoembarazo ,clfeeb_fum ,clfeeb_droga1 ,clfeeb_droga2 ,clfeeb_droga3 ,clfeeb_tipoproc ,clfeeb_ritmenstrual ,clfeeb_muestrasemen ,clfeeb_origenms ,clfeeb_subundbeta ,clfeeb_diag1 ,clfeeb_diag2 ,clfeeb_comentario ,clfeeb_aih1 ,clfeeb_aih2 ,clfeeb_aih3 ,clfeeb_fum_1 ,clfeeb_fum_2 ,clfeeb_fum_3 ,clfeeb_fum_4 ,clfeeb_fum_5 ,clfeeb_fum_6 ,clfeeb_fum_7 ,clfeeb_fum_8 ,clfeeb_fum_9 ,clfeeb_fum_10 ,clfeeb_fum_11 ,clfeeb_fum_12 ,clfeeb_fum_13 ,clfeeb_fum_14 ,clfeeb_fum_15 ,clfeeb_fum_16 ,clfeeb_fum_17 ,clfeeb_fum_18 ,clfeeb_fum_19 ,clfeeb_fum_20 ,clfeeb_fum_21 ,clfeeb_fum_22 ,clfeeb_fum_23 ,clfeeb_fum_24 ,clfeeb_fum_25 ,clfeeb_fum_26 ,clfeeb_fum_27 ,clfeeb_fum_28 ,clfeeb_fumDay_1 ,clfeeb_fumDay_2 ,clfeeb_fumDay_3 ,clfeeb_fumDay_4 ,clfeeb_fumDay_5 ,clfeeb_fumDay_6 ,clfeeb_fumDay_7 ,clfeeb_fumDay_8 ,clfeeb_fumDay_9 ,clfeeb_fumDay_10 ,clfeeb_fumDay_11 ,clfeeb_fumDay_12 ,clfeeb_fumDay_13 ,clfeeb_fumDay_14 ,clfeeb_fumDay_15 ,clfeeb_fumDay_16 ,clfeeb_fumDay_17 ,clfeeb_fumDay_18 ,clfeeb_fumDay_19 ,clfeeb_fumDay_20 ,clfeeb_fumDay_21 ,clfeeb_fumDay_22 ,clfeeb_fumDay_23 ,clfeeb_fumDay_24 ,clfeeb_fumDay_25 ,clfeeb_fumDay_26 ,clfeeb_fumDay_27 ,clfeeb_fumDay_28 ,clfeeb_fumDosis_1 ,clfeeb_fumDosis_2 ,clfeeb_fumDosis_3 ,clfeeb_fumDosis_4 ,clfeeb_fumDosis_5 ,clfeeb_fumDosis_6 ,clfeeb_fumDosis_7 ,clfeeb_fumDosis_8 ,clfeeb_fumDosis_9 ,clfeeb_fumDosis_10 ,clfeeb_fumDosis_11 ,clfeeb_fumDosis_12 ,clfeeb_fumDosis_13 ,clfeeb_fumDosis_14 ,clfeeb_fumDosis_15 ,clfeeb_fumDosis_16 ,clfeeb_fumDosis_17 ,clfeeb_fumDosis_18 ,clfeeb_fumDosis_19 ,clfeeb_fumDosis_20 ,clfeeb_fumDosis_21 ,clfeeb_fumDosis_22 ,clfeeb_fumDosis_23 ,clfeeb_fumDosis_24 ,clfeeb_fumDosis_25 ,clfeeb_fumDosis_26 ,clfeeb_fumDosis_27 ,clfeeb_fumDosis_28 ,clfeeb_fumDosis2_1 ,clfeeb_fumDosis2_2 ,clfeeb_fumDosis2_3 ,clfeeb_fumDosis2_4 ,clfeeb_fumDosis2_5 ,clfeeb_fumDosis2_6 ,clfeeb_fumDosis2_7 ,clfeeb_fumDosis2_8 ,clfeeb_fumDosis2_9 ,clfeeb_fumDosis2_10 ,clfeeb_fumDosis2_11 ,clfeeb_fumDosis2_12 ,clfeeb_fumDosis2_13 ,clfeeb_fumDosis2_14 ,clfeeb_fumDosis2_15 ,clfeeb_fumDosis2_16 ,clfeeb_fumDosis2_17 ,clfeeb_fumDosis2_18 ,clfeeb_fumDosis2_19 ,clfeeb_fumDosis2_20 ,clfeeb_fumDosis2_21 ,clfeeb_fumDosis2_22 ,clfeeb_fumDosis2_23 ,clfeeb_fumDosis2_24 ,clfeeb_fumDosis2_25 ,clfeeb_fumDosis2_26 ,clfeeb_fumDosis2_27 ,clfeeb_fumDosis2_28 ,clfeeb_fumendoesp_1 ,clfeeb_fumendoesp_2 ,clfeeb_fumendoesp_3 ,clfeeb_fumendoesp_4 ,clfeeb_fumendoesp_5 ,clfeeb_fumendoesp_6 ,clfeeb_fumendoesp_7 ,clfeeb_fumendoesp_8 ,clfeeb_fumendoesp_9 ,clfeeb_fumendoesp_10 ,clfeeb_fumendoesp_11 ,clfeeb_fumendoesp_12 ,clfeeb_fumendoesp_13 ,clfeeb_fumendoesp_14 ,clfeeb_fumendoesp_15 ,clfeeb_fumendoesp_16 ,clfeeb_fumendoesp_17 ,clfeeb_fumendoesp_18 ,clfeeb_fumendoesp_19 ,clfeeb_fumendoesp_20 ,clfeeb_fumendoesp_21 ,clfeeb_fumendoesp_22 ,clfeeb_fumendoesp_23 ,clfeeb_fumendoesp_24 ,clfeeb_fumendoesp_25 ,clfeeb_fumendoesp_26 ,clfeeb_fumendoesp_27 ,clfeeb_fumendoesp_28 ,clfeeb_fumendopat_1 ,clfeeb_fumendopat_2 ,clfeeb_fumendopat_3 ,clfeeb_fumendopat_4 ,clfeeb_fumendopat_5 ,clfeeb_fumendopat_6 ,clfeeb_fumendopat_7 ,clfeeb_fumendopat_8 ,clfeeb_fumendopat_9 ,clfeeb_fumendopat_10 ,clfeeb_fumendopat_11 ,clfeeb_fumendopat_12 ,clfeeb_fumendopat_13 ,clfeeb_fumendopat_14 ,clfeeb_fumendopat_15 ,clfeeb_fumendopat_16 ,clfeeb_fumendopat_17 ,clfeeb_fumendopat_18 ,clfeeb_fumendopat_19 ,clfeeb_fumendopat_20 ,clfeeb_fumendopat_21 ,clfeeb_fumendopat_22 ,clfeeb_fumendopat_23 ,clfeeb_fumendopat_24 ,clfeeb_fumendopat_25 ,clfeeb_fumendopat_26 ,clfeeb_fumendopat_27 ,clfeeb_fumendopat_28 ,clfeeb_fumOvI_1_v1 ,clfeeb_fumOvI_2_v1 ,clfeeb_fumOvI_3_v1 ,clfeeb_fumOvI_4_v1 ,clfeeb_fumOvI_5_v1 ,clfeeb_fumOvI_6_v1 ,clfeeb_fumOvI_7_v1 ,clfeeb_fumOvI_8_v1 ,clfeeb_fumOvI_9_v1 ,clfeeb_fumOvI_10_v1 ,clfeeb_fumOvI_11_v1 ,clfeeb_fumOvI_12_v1 ,clfeeb_fumOvI_13_v1 ,clfeeb_fumOvI_14_v1 ,clfeeb_fumOvI_15_v1 ,clfeeb_fumOvI_16_v1 ,clfeeb_fumOvI_17_v1 ,clfeeb_fumOvI_18_v1 ,clfeeb_fumOvI_19_v1 ,clfeeb_fumOvI_20_v1 ,clfeeb_fumOvI_21_v1 ,clfeeb_fumOvI_22_v1 ,clfeeb_fumOvI_23_v1 ,clfeeb_fumOvI_24_v1 ,clfeeb_fumOvI_25_v1 ,clfeeb_fumOvI_26_v1 ,clfeeb_fumOvI_27_v1 ,clfeeb_fumOvI_28_v1 ,clfeeb_fumOvI_1_v2 ,clfeeb_fumOvI_2_v2 ,clfeeb_fumOvI_3_v2 ,clfeeb_fumOvI_4_v2 ,clfeeb_fumOvI_5_v2 ,clfeeb_fumOvI_6_v2 ,clfeeb_fumOvI_7_v2 ,clfeeb_fumOvI_8_v2 ,clfeeb_fumOvI_9_v2 ,clfeeb_fumOvI_10_v2 ,clfeeb_fumOvI_11_v2 ,clfeeb_fumOvI_12_v2 ,clfeeb_fumOvI_13_v2 ,clfeeb_fumOvI_14_v2 ,clfeeb_fumOvI_15_v2 ,clfeeb_fumOvI_16_v2 ,clfeeb_fumOvI_17_v2 ,clfeeb_fumOvI_18_v2 ,clfeeb_fumOvI_19_v2 ,clfeeb_fumOvI_20_v2 ,clfeeb_fumOvI_21_v2 ,clfeeb_fumOvI_22_v2 ,clfeeb_fumOvI_23_v2 ,clfeeb_fumOvI_24_v2 ,clfeeb_fumOvI_25_v2 ,clfeeb_fumOvI_26_v2 ,clfeeb_fumOvI_27_v2 ,clfeeb_fumOvI_28_v2 ,clfeeb_fumOvI_1_v3 ,clfeeb_fumOvI_2_v3 ,clfeeb_fumOvI_3_v3 ,clfeeb_fumOvI_4_v3 ,clfeeb_fumOvI_5_v3 ,clfeeb_fumOvI_6_v3 ,clfeeb_fumOvI_7_v3 ,clfeeb_fumOvI_8_v3 ,clfeeb_fumOvI_9_v3 ,clfeeb_fumOvI_10_v3 ,clfeeb_fumOvI_11_v3 ,clfeeb_fumOvI_12_v3 ,clfeeb_fumOvI_13_v3 ,clfeeb_fumOvI_14_v3 ,clfeeb_fumOvI_15_v3 ,clfeeb_fumOvI_16_v3 ,clfeeb_fumOvI_17_v3 ,clfeeb_fumOvI_18_v3 ,clfeeb_fumOvI_19_v3 ,clfeeb_fumOvI_20_v3 ,clfeeb_fumOvI_21_v3 ,clfeeb_fumOvI_22_v3 ,clfeeb_fumOvI_23_v3 ,clfeeb_fumOvI_24_v3 ,clfeeb_fumOvI_25_v3 ,clfeeb_fumOvI_26_v3 ,clfeeb_fumOvI_27_v3 ,clfeeb_fumOvI_28_v3 ,clfeeb_fumOvI_1_v4 ,clfeeb_fumOvI_2_v4 ,clfeeb_fumOvI_3_v4 ,clfeeb_fumOvI_4_v4 ,clfeeb_fumOvI_5_v4 ,clfeeb_fumOvI_6_v4 ,clfeeb_fumOvI_7_v4 ,clfeeb_fumOvI_8_v4 ,clfeeb_fumOvI_9_v4 ,clfeeb_fumOvI_10_v4 ,clfeeb_fumOvI_11_v4 ,clfeeb_fumOvI_12_v4 ,clfeeb_fumOvI_13_v4 ,clfeeb_fumOvI_14_v4 ,clfeeb_fumOvI_15_v4 ,clfeeb_fumOvI_16_v4 ,clfeeb_fumOvI_17_v4 ,clfeeb_fumOvI_18_v4 ,clfeeb_fumOvI_19_v4 ,clfeeb_fumOvI_20_v4 ,clfeeb_fumOvI_21_v4 ,clfeeb_fumOvI_22_v4 ,clfeeb_fumOvI_23_v4 ,clfeeb_fumOvI_24_v4 ,clfeeb_fumOvI_25_v4 ,clfeeb_fumOvI_26_v4 ,clfeeb_fumOvI_27_v4 ,clfeeb_fumOvI_28_v4 ,clfeeb_fumOvI_1_v5 ,clfeeb_fumOvI_2_v5 ,clfeeb_fumOvI_3_v5 ,clfeeb_fumOvI_4_v5 ,clfeeb_fumOvI_5_v5 ,clfeeb_fumOvI_6_v5 ,clfeeb_fumOvI_7_v5 ,clfeeb_fumOvI_8_v5 ,clfeeb_fumOvI_9_v5 ,clfeeb_fumOvI_10_v5 ,clfeeb_fumOvI_11_v5 ,clfeeb_fumOvI_12_v5 ,clfeeb_fumOvI_13_v5 ,clfeeb_fumOvI_14_v5 ,clfeeb_fumOvI_15_v5 ,clfeeb_fumOvI_16_v5 ,clfeeb_fumOvI_17_v5 ,clfeeb_fumOvI_18_v5 ,clfeeb_fumOvI_19_v5 ,clfeeb_fumOvI_20_v5 ,clfeeb_fumOvI_21_v5 ,clfeeb_fumOvI_22_v5 ,clfeeb_fumOvI_23_v5 ,clfeeb_fumOvI_24_v5 ,clfeeb_fumOvI_25_v5 ,clfeeb_fumOvI_26_v5 ,clfeeb_fumOvI_27_v5 ,clfeeb_fumOvI_28_v5 ,clfeeb_fumOvI_1_v6 ,clfeeb_fumOvI_2_v6 ,clfeeb_fumOvI_3_v6 ,clfeeb_fumOvI_4_v6 ,clfeeb_fumOvI_5_v6 ,clfeeb_fumOvI_6_v6 ,clfeeb_fumOvI_7_v6 ,clfeeb_fumOvI_8_v6 ,clfeeb_fumOvI_9_v6 ,clfeeb_fumOvI_10_v6 ,clfeeb_fumOvI_11_v6 ,clfeeb_fumOvI_12_v6 ,clfeeb_fumOvI_13_v6 ,clfeeb_fumOvI_14_v6 ,clfeeb_fumOvI_15_v6 ,clfeeb_fumOvI_16_v6 ,clfeeb_fumOvI_17_v6 ,clfeeb_fumOvI_18_v6 ,clfeeb_fumOvI_19_v6 ,clfeeb_fumOvI_20_v6 ,clfeeb_fumOvI_21_v6 ,clfeeb_fumOvI_22_v6 ,clfeeb_fumOvI_23_v6 ,clfeeb_fumOvI_24_v6 ,clfeeb_fumOvI_25_v6 ,clfeeb_fumOvI_26_v6 ,clfeeb_fumOvI_27_v6 ,clfeeb_fumOvI_28_v6 ,clfeeb_fumOvI_1_v7 ,clfeeb_fumOvI_2_v7 ,clfeeb_fumOvI_3_v7 ,clfeeb_fumOvI_4_v7 ,clfeeb_fumOvI_5_v7 ,clfeeb_fumOvI_6_v7 ,clfeeb_fumOvI_7_v7 ,clfeeb_fumOvI_8_v7 ,clfeeb_fumOvI_9_v7 ,clfeeb_fumOvI_10_v7 ,clfeeb_fumOvI_11_v7 ,clfeeb_fumOvI_12_v7 ,clfeeb_fumOvI_13_v7 ,clfeeb_fumOvI_14_v7 ,clfeeb_fumOvI_15_v7 ,clfeeb_fumOvI_16_v7 ,clfeeb_fumOvI_17_v7 ,clfeeb_fumOvI_18_v7 ,clfeeb_fumOvI_19_v7 ,clfeeb_fumOvI_20_v7 ,clfeeb_fumOvI_21_v7 ,clfeeb_fumOvI_22_v7 ,clfeeb_fumOvI_23_v7 ,clfeeb_fumOvI_24_v7 ,clfeeb_fumOvI_25_v7 ,clfeeb_fumOvI_26_v7 ,clfeeb_fumOvI_27_v7 ,clfeeb_fumOvI_28_v7 ,clfeeb_fumOvI_1_v8 ,clfeeb_fumOvI_2_v8 ,clfeeb_fumOvI_3_v8 ,clfeeb_fumOvI_4_v8 ,clfeeb_fumOvI_5_v8 ,clfeeb_fumOvI_6_v8 ,clfeeb_fumOvI_7_v8 ,clfeeb_fumOvI_8_v8 ,clfeeb_fumOvI_9_v8 ,clfeeb_fumOvI_10_v8 ,clfeeb_fumOvI_11_v8 ,clfeeb_fumOvI_12_v8 ,clfeeb_fumOvI_13_v8 ,clfeeb_fumOvI_14_v8 ,clfeeb_fumOvI_15_v8 ,clfeeb_fumOvI_16_v8 ,clfeeb_fumOvI_17_v8 ,clfeeb_fumOvI_18_v8 ,clfeeb_fumOvI_19_v8 ,clfeeb_fumOvI_20_v8 ,clfeeb_fumOvI_21_v8 ,clfeeb_fumOvI_22_v8 ,clfeeb_fumOvI_23_v8 ,clfeeb_fumOvI_24_v8 ,clfeeb_fumOvI_25_v8 ,clfeeb_fumOvI_26_v8 ,clfeeb_fumOvI_27_v8 ,clfeeb_fumOvI_28_v8 ,clfeeb_fumOvI_1_v9 ,clfeeb_fumOvI_2_v9 ,clfeeb_fumOvI_3_v9 ,clfeeb_fumOvI_4_v9 ,clfeeb_fumOvI_5_v9 ,clfeeb_fumOvI_6_v9 ,clfeeb_fumOvI_7_v9 ,clfeeb_fumOvI_8_v9 ,clfeeb_fumOvI_9_v9 ,clfeeb_fumOvI_10_v9 ,clfeeb_fumOvI_11_v9 ,clfeeb_fumOvI_12_v9 ,clfeeb_fumOvI_13_v9 ,clfeeb_fumOvI_14_v9 ,clfeeb_fumOvI_15_v9 ,clfeeb_fumOvI_16_v9 ,clfeeb_fumOvI_17_v9 ,clfeeb_fumOvI_18_v9 ,clfeeb_fumOvI_19_v9 ,clfeeb_fumOvI_20_v9 ,clfeeb_fumOvI_21_v9 ,clfeeb_fumOvI_22_v9 ,clfeeb_fumOvI_23_v9 ,clfeeb_fumOvI_24_v9 ,clfeeb_fumOvI_25_v9 ,clfeeb_fumOvI_26_v9 ,clfeeb_fumOvI_27_v9 ,clfeeb_fumOvI_28_v9 ,clfeeb_fumOvD_1_v1 ,clfeeb_fumOvD_2_v1 ,clfeeb_fumOvD_3_v1 ,clfeeb_fumOvD_4_v1 ,clfeeb_fumOvD_5_v1 ,clfeeb_fumOvD_6_v1 ,clfeeb_fumOvD_7_v1 ,clfeeb_fumOvD_8_v1 ,clfeeb_fumOvD_9_v1 ,clfeeb_fumOvD_10_v1 ,clfeeb_fumOvD_11_v1 ,clfeeb_fumOvD_12_v1 ,clfeeb_fumOvD_13_v1 ,clfeeb_fumOvD_14_v1 ,clfeeb_fumOvD_15_v1 ,clfeeb_fumOvD_16_v1 ,clfeeb_fumOvD_17_v1 ,clfeeb_fumOvD_18_v1 ,clfeeb_fumOvD_19_v1 ,clfeeb_fumOvD_20_v1 ,clfeeb_fumOvD_21_v1 ,clfeeb_fumOvD_22_v1 ,clfeeb_fumOvD_23_v1 ,clfeeb_fumOvD_24_v1 ,clfeeb_fumOvD_25_v1 ,clfeeb_fumOvD_26_v1 ,clfeeb_fumOvD_27_v1 ,clfeeb_fumOvD_28_v1 ,clfeeb_fumOvD_1_v2 ,clfeeb_fumOvD_2_v2 ,clfeeb_fumOvD_3_v2 ,clfeeb_fumOvD_4_v2 ,clfeeb_fumOvD_5_v2 ,clfeeb_fumOvD_6_v2 ,clfeeb_fumOvD_7_v2 ,clfeeb_fumOvD_8_v2 ,clfeeb_fumOvD_9_v2 ,clfeeb_fumOvD_10_v2 ,clfeeb_fumOvD_11_v2 ,clfeeb_fumOvD_12_v2 ,clfeeb_fumOvD_13_v2 ,clfeeb_fumOvD_14_v2 ,clfeeb_fumOvD_15_v2 ,clfeeb_fumOvD_16_v2 ,clfeeb_fumOvD_17_v2 ,clfeeb_fumOvD_18_v2 ,clfeeb_fumOvD_19_v2 ,clfeeb_fumOvD_20_v2 ,clfeeb_fumOvD_21_v2 ,clfeeb_fumOvD_22_v2 ,clfeeb_fumOvD_23_v2 ,clfeeb_fumOvD_24_v2 ,clfeeb_fumOvD_25_v2 ,clfeeb_fumOvD_26_v2 ,clfeeb_fumOvD_27_v2 ,clfeeb_fumOvD_28_v2 ,clfeeb_fumOvD_1_v3 ,clfeeb_fumOvD_2_v3 ,clfeeb_fumOvD_3_v3 ,clfeeb_fumOvD_4_v3 ,clfeeb_fumOvD_5_v3 ,clfeeb_fumOvD_6_v3 ,clfeeb_fumOvD_7_v3 ,clfeeb_fumOvD_8_v3 ,clfeeb_fumOvD_9_v3 ,clfeeb_fumOvD_10_v3 ,clfeeb_fumOvD_11_v3 ,clfeeb_fumOvD_12_v3 ,clfeeb_fumOvD_13_v3 ,clfeeb_fumOvD_14_v3 ,clfeeb_fumOvD_15_v3 ,clfeeb_fumOvD_16_v3 ,clfeeb_fumOvD_17_v3 ,clfeeb_fumOvD_18_v3 ,clfeeb_fumOvD_19_v3 ,clfeeb_fumOvD_20_v3 ,clfeeb_fumOvD_21_v3 ,clfeeb_fumOvD_22_v3 ,clfeeb_fumOvD_23_v3 ,clfeeb_fumOvD_24_v3 ,clfeeb_fumOvD_25_v3 ,clfeeb_fumOvD_26_v3 ,clfeeb_fumOvD_27_v3 ,clfeeb_fumOvD_28_v3 ,clfeeb_fumOvD_1_v4 ,clfeeb_fumOvD_2_v4 ,clfeeb_fumOvD_3_v4 ,clfeeb_fumOvD_4_v4 ,clfeeb_fumOvD_5_v4 ,clfeeb_fumOvD_6_v4 ,clfeeb_fumOvD_7_v4 ,clfeeb_fumOvD_8_v4 ,clfeeb_fumOvD_9_v4 ,clfeeb_fumOvD_10_v4 ,clfeeb_fumOvD_11_v4 ,clfeeb_fumOvD_12_v4 ,clfeeb_fumOvD_13_v4 ,clfeeb_fumOvD_14_v4 ,clfeeb_fumOvD_15_v4 ,clfeeb_fumOvD_16_v4 ,clfeeb_fumOvD_17_v4 ,clfeeb_fumOvD_18_v4 ,clfeeb_fumOvD_19_v4 ,clfeeb_fumOvD_20_v4 ,clfeeb_fumOvD_21_v4 ,clfeeb_fumOvD_22_v4 ,clfeeb_fumOvD_23_v4 ,clfeeb_fumOvD_24_v4 ,clfeeb_fumOvD_25_v4 ,clfeeb_fumOvD_26_v4 ,clfeeb_fumOvD_27_v4 ,clfeeb_fumOvD_28_v4 ,clfeeb_fumOvD_1_v5 ,clfeeb_fumOvD_2_v5 ,clfeeb_fumOvD_3_v5 ,clfeeb_fumOvD_4_v5 ,clfeeb_fumOvD_5_v5 ,clfeeb_fumOvD_6_v5 ,clfeeb_fumOvD_7_v5 ,clfeeb_fumOvD_8_v5 ,clfeeb_fumOvD_9_v5 ,clfeeb_fumOvD_10_v5 ,clfeeb_fumOvD_11_v5 ,clfeeb_fumOvD_12_v5 ,clfeeb_fumOvD_13_v5 ,clfeeb_fumOvD_14_v5 ,clfeeb_fumOvD_15_v5 ,clfeeb_fumOvD_16_v5 ,clfeeb_fumOvD_17_v5 ,clfeeb_fumOvD_18_v5 ,clfeeb_fumOvD_19_v5 ,clfeeb_fumOvD_20_v5 ,clfeeb_fumOvD_21_v5 ,clfeeb_fumOvD_22_v5 ,clfeeb_fumOvD_23_v5 ,clfeeb_fumOvD_24_v5 ,clfeeb_fumOvD_25_v5 ,clfeeb_fumOvD_26_v5 ,clfeeb_fumOvD_27_v5 ,clfeeb_fumOvD_28_v5 ,clfeeb_fumOvD_1_v6 ,clfeeb_fumOvD_2_v6 ,clfeeb_fumOvD_3_v6 ,clfeeb_fumOvD_4_v6 ,clfeeb_fumOvD_5_v6 ,clfeeb_fumOvD_6_v6 ,clfeeb_fumOvD_7_v6 ,clfeeb_fumOvD_8_v6 ,clfeeb_fumOvD_9_v6 ,clfeeb_fumOvD_10_v6 ,clfeeb_fumOvD_11_v6 ,clfeeb_fumOvD_12_v6 ,clfeeb_fumOvD_13_v6 ,clfeeb_fumOvD_14_v6 ,clfeeb_fumOvD_15_v6 ,clfeeb_fumOvD_16_v6 ,clfeeb_fumOvD_17_v6 ,clfeeb_fumOvD_18_v6 ,clfeeb_fumOvD_19_v6 ,clfeeb_fumOvD_20_v6 ,clfeeb_fumOvD_21_v6 ,clfeeb_fumOvD_22_v6 ,clfeeb_fumOvD_23_v6 ,clfeeb_fumOvD_24_v6 ,clfeeb_fumOvD_25_v6 ,clfeeb_fumOvD_26_v6 ,clfeeb_fumOvD_27_v6 ,clfeeb_fumOvD_28_v6 ,clfeeb_fumOvD_1_v7 ,clfeeb_fumOvD_2_v7 ,clfeeb_fumOvD_3_v7 ,clfeeb_fumOvD_4_v7 ,clfeeb_fumOvD_5_v7 ,clfeeb_fumOvD_6_v7 ,clfeeb_fumOvD_7_v7 ,clfeeb_fumOvD_8_v7 ,clfeeb_fumOvD_9_v7 ,clfeeb_fumOvD_10_v7 ,clfeeb_fumOvD_11_v7 ,clfeeb_fumOvD_12_v7 ,clfeeb_fumOvD_13_v7 ,clfeeb_fumOvD_14_v7 ,clfeeb_fumOvD_15_v7 ,clfeeb_fumOvD_16_v7 ,clfeeb_fumOvD_17_v7 ,clfeeb_fumOvD_18_v7 ,clfeeb_fumOvD_19_v7 ,clfeeb_fumOvD_20_v7 ,clfeeb_fumOvD_21_v7 ,clfeeb_fumOvD_22_v7 ,clfeeb_fumOvD_23_v7 ,clfeeb_fumOvD_24_v7 ,clfeeb_fumOvD_25_v7 ,clfeeb_fumOvD_26_v7 ,clfeeb_fumOvD_27_v7 ,clfeeb_fumOvD_28_v7 ,clfeeb_fumOvD_1_v8 ,clfeeb_fumOvD_2_v8 ,clfeeb_fumOvD_3_v8 ,clfeeb_fumOvD_4_v8 ,clfeeb_fumOvD_5_v8 ,clfeeb_fumOvD_6_v8 ,clfeeb_fumOvD_7_v8 ,clfeeb_fumOvD_8_v8 ,clfeeb_fumOvD_9_v8 ,clfeeb_fumOvD_10_v8 ,clfeeb_fumOvD_11_v8 ,clfeeb_fumOvD_12_v8 ,clfeeb_fumOvD_13_v8 ,clfeeb_fumOvD_14_v8 ,clfeeb_fumOvD_15_v8 ,clfeeb_fumOvD_16_v8 ,clfeeb_fumOvD_17_v8 ,clfeeb_fumOvD_18_v8 ,clfeeb_fumOvD_19_v8 ,clfeeb_fumOvD_20_v8 ,clfeeb_fumOvD_21_v8 ,clfeeb_fumOvD_22_v8 ,clfeeb_fumOvD_23_v8 ,clfeeb_fumOvD_24_v8 ,clfeeb_fumOvD_25_v8 ,clfeeb_fumOvD_26_v8 ,clfeeb_fumOvD_27_v8 ,clfeeb_fumOvD_28_v8 ,clfeeb_fumOvD_1_v9 ,clfeeb_fumOvD_2_v9 ,clfeeb_fumOvD_3_v9 ,clfeeb_fumOvD_4_v9 ,clfeeb_fumOvD_5_v9 ,clfeeb_fumOvD_6_v9 ,clfeeb_fumOvD_7_v9 ,clfeeb_fumOvD_8_v9 ,clfeeb_fumOvD_9_v9 ,clfeeb_fumOvD_10_v9 ,clfeeb_fumOvD_11_v9 ,clfeeb_fumOvD_12_v9 ,clfeeb_fumOvD_13_v9 ,clfeeb_fumOvD_14_v9 ,clfeeb_fumOvD_15_v9 ,clfeeb_fumOvD_16_v9 ,clfeeb_fumOvD_17_v9 ,clfeeb_fumOvD_18_v9 ,clfeeb_fumOvD_19_v9 ,clfeeb_fumOvD_20_v9 ,clfeeb_fumOvD_21_v9 ,clfeeb_fumOvD_22_v9 ,clfeeb_fumOvD_23_v9 ,clfeeb_fumOvD_24_v9 ,clfeeb_fumOvD_25_v9 ,clfeeb_fumOvD_26_v9 ,clfeeb_fumOvD_27_v9 ,clfeeb_fumOvD_28_v9 ,clfeeb_fumEA_1 ,clfeeb_fumEA_2 ,clfeeb_fumEA_3 ,clfeeb_fumEA_4 ,clfeeb_fumEA_5 ,clfeeb_fumEA_6 ,clfeeb_fumEA_7 ,clfeeb_fumEA_8 ,clfeeb_fumEA_9 ,clfeeb_fumEA_10 ,clfeeb_fumEA_11 ,clfeeb_fumEA_12 ,clfeeb_fumEA_13 ,clfeeb_fumEA_14 ,clfeeb_fumEA_15 ,clfeeb_fumEA_16 ,clfeeb_fumEA_17 ,clfeeb_fumEA_18 ,clfeeb_fumEA_19 ,clfeeb_fumEA_20 ,clfeeb_fumEA_21 ,clfeeb_fumEA_22 ,clfeeb_fumEA_23 ,clfeeb_fumEA_24 ,clfeeb_fumEA_25 ,clfeeb_fumEA_26 ,clfeeb_fumEA_27 ,clfeeb_fumEA_28 ) VALUES ( '".$params["items"][0]["clicod"]."' ,".$estado." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["temb"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["droga"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["droga2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["droga3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["tiprocedimiento"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["rm"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["semen"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["semenorigen"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["subunidadbeta"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["diag1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["diag2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["comentario"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["aih_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["aih_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["aih_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fum_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumDay_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumVal2_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendoesp_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumendopat_28"])))." ".$ovariosI." ".$ovariosD." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estbaja"][$i]["fumEAapl_28"])))." )"; $x = array_push($sqllst,$sqlItem); } } //--------------------------------------------------------- // HX ESTIMULACION ALTA COMPLEJIDAD //--------------------------------------------------------- if( isset($params["items"][0]["estalta"]) && is_array($params["items"][0]["estalta"]) && count($params["items"][0]["estalta"])>0 ) {//print_r($params["items"][0]["estbaja"]);die; $hxalta = "DELETE FROM cli_fer_estalta WHERE cli_codigo = '".$params["items"][0]["clicod"]."'" ; $x = array_push($sqllst,$hxalta); if( !is_null($params["items"][0]["estalta"][$i]["flagemb"]) && !empty($params["items"][0]["estalta"][$i]["flagemb"]) ) { $estado = 1; } else { $estado = 0; } for($i=0,$total=count($params["items"][0]["estalta"]);$i<$total;$i++) { $ovariosI = ""; $ovariosD = ""; for($x=1;$x<=9;$x++) { for($k=1;$k<=28;$k++) { if(isset($params["items"][0]["estalta"][$i]["fumOvI_".$k."_v".$x])) { $val = getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumOvI_".$k."_v".$x]))); } else { $val = 'NULL'; } $ovariosI.= ",".$val; } } for($x=1;$x<=9;$x++) { for($k=1;$k<=28;$k++) { if(isset($params["items"][0]["estalta"][$i]["fumOvD_".$k."_v".$x])) { $val = getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumOvD_".$k."_v".$x]))); } else { $val = 'NULL'; } $ovariosD.= ",".$val; } } $sqlItem = "INSERT INTO cli_fer_estalta( cli_codigo ,clfeeb_estadoitem ,clfeeb_tipoembarazo ,clfeeb_fum ,clfeeb_droga1 ,clfeeb_droga2 ,clfeeb_droga3 ,clfeeb_tipoproc ,clfeeb_ritmenstrual ,clfeeb_muestrasemen ,clfeeb_origenms ,clfeeb_subundbeta ,clfeeb_tese ,clfeeb_ionoforos ,clfeeb_cgh ,clfeeb_aneximas ,clfeeb_hatching ,clfeeb_vitrificaovos ,clfeeb_vitrificaembriones ,clfeeb_diag1 ,clfeeb_diag2 ,clfeeb_comentario ,clfeeb_aih1 ,clfeeb_aih2 ,clfeeb_aih3 ,clfeeb_fum_1 ,clfeeb_fum_2 ,clfeeb_fum_3 ,clfeeb_fum_4 ,clfeeb_fum_5 ,clfeeb_fum_6 ,clfeeb_fum_7 ,clfeeb_fum_8 ,clfeeb_fum_9 ,clfeeb_fum_10 ,clfeeb_fum_11 ,clfeeb_fum_12 ,clfeeb_fum_13 ,clfeeb_fum_14 ,clfeeb_fum_15 ,clfeeb_fum_16 ,clfeeb_fum_17 ,clfeeb_fum_18 ,clfeeb_fum_19 ,clfeeb_fum_20 ,clfeeb_fum_21 ,clfeeb_fum_22 ,clfeeb_fum_23 ,clfeeb_fum_24 ,clfeeb_fum_25 ,clfeeb_fum_26 ,clfeeb_fum_27 ,clfeeb_fum_28 ,clfeeb_fumDay_1 ,clfeeb_fumDay_2 ,clfeeb_fumDay_3 ,clfeeb_fumDay_4 ,clfeeb_fumDay_5 ,clfeeb_fumDay_6 ,clfeeb_fumDay_7 ,clfeeb_fumDay_8 ,clfeeb_fumDay_9 ,clfeeb_fumDay_10 ,clfeeb_fumDay_11 ,clfeeb_fumDay_12 ,clfeeb_fumDay_13 ,clfeeb_fumDay_14 ,clfeeb_fumDay_15 ,clfeeb_fumDay_16 ,clfeeb_fumDay_17 ,clfeeb_fumDay_18 ,clfeeb_fumDay_19 ,clfeeb_fumDay_20 ,clfeeb_fumDay_21 ,clfeeb_fumDay_22 ,clfeeb_fumDay_23 ,clfeeb_fumDay_24 ,clfeeb_fumDay_25 ,clfeeb_fumDay_26 ,clfeeb_fumDay_27 ,clfeeb_fumDay_28 ,clfeeb_fumDosis_1 ,clfeeb_fumDosis_2 ,clfeeb_fumDosis_3 ,clfeeb_fumDosis_4 ,clfeeb_fumDosis_5 ,clfeeb_fumDosis_6 ,clfeeb_fumDosis_7 ,clfeeb_fumDosis_8 ,clfeeb_fumDosis_9 ,clfeeb_fumDosis_10 ,clfeeb_fumDosis_11 ,clfeeb_fumDosis_12 ,clfeeb_fumDosis_13 ,clfeeb_fumDosis_14 ,clfeeb_fumDosis_15 ,clfeeb_fumDosis_16 ,clfeeb_fumDosis_17 ,clfeeb_fumDosis_18 ,clfeeb_fumDosis_19 ,clfeeb_fumDosis_20 ,clfeeb_fumDosis_21 ,clfeeb_fumDosis_22 ,clfeeb_fumDosis_23 ,clfeeb_fumDosis_24 ,clfeeb_fumDosis_25 ,clfeeb_fumDosis_26 ,clfeeb_fumDosis_27 ,clfeeb_fumDosis_28 ,clfeeb_fumDosis2_1 ,clfeeb_fumDosis2_2 ,clfeeb_fumDosis2_3 ,clfeeb_fumDosis2_4 ,clfeeb_fumDosis2_5 ,clfeeb_fumDosis2_6 ,clfeeb_fumDosis2_7 ,clfeeb_fumDosis2_8 ,clfeeb_fumDosis2_9 ,clfeeb_fumDosis2_10 ,clfeeb_fumDosis2_11 ,clfeeb_fumDosis2_12 ,clfeeb_fumDosis2_13 ,clfeeb_fumDosis2_14 ,clfeeb_fumDosis2_15 ,clfeeb_fumDosis2_16 ,clfeeb_fumDosis2_17 ,clfeeb_fumDosis2_18 ,clfeeb_fumDosis2_19 ,clfeeb_fumDosis2_20 ,clfeeb_fumDosis2_21 ,clfeeb_fumDosis2_22 ,clfeeb_fumDosis2_23 ,clfeeb_fumDosis2_24 ,clfeeb_fumDosis2_25 ,clfeeb_fumDosis2_26 ,clfeeb_fumDosis2_27 ,clfeeb_fumDosis2_28 ,clfeeb_fumendoesp_1 ,clfeeb_fumendoesp_2 ,clfeeb_fumendoesp_3 ,clfeeb_fumendoesp_4 ,clfeeb_fumendoesp_5 ,clfeeb_fumendoesp_6 ,clfeeb_fumendoesp_7 ,clfeeb_fumendoesp_8 ,clfeeb_fumendoesp_9 ,clfeeb_fumendoesp_10 ,clfeeb_fumendoesp_11 ,clfeeb_fumendoesp_12 ,clfeeb_fumendoesp_13 ,clfeeb_fumendoesp_14 ,clfeeb_fumendoesp_15 ,clfeeb_fumendoesp_16 ,clfeeb_fumendoesp_17 ,clfeeb_fumendoesp_18 ,clfeeb_fumendoesp_19 ,clfeeb_fumendoesp_20 ,clfeeb_fumendoesp_21 ,clfeeb_fumendoesp_22 ,clfeeb_fumendoesp_23 ,clfeeb_fumendoesp_24 ,clfeeb_fumendoesp_25 ,clfeeb_fumendoesp_26 ,clfeeb_fumendoesp_27 ,clfeeb_fumendoesp_28 ,clfeeb_fumendopat_1 ,clfeeb_fumendopat_2 ,clfeeb_fumendopat_3 ,clfeeb_fumendopat_4 ,clfeeb_fumendopat_5 ,clfeeb_fumendopat_6 ,clfeeb_fumendopat_7 ,clfeeb_fumendopat_8 ,clfeeb_fumendopat_9 ,clfeeb_fumendopat_10 ,clfeeb_fumendopat_11 ,clfeeb_fumendopat_12 ,clfeeb_fumendopat_13 ,clfeeb_fumendopat_14 ,clfeeb_fumendopat_15 ,clfeeb_fumendopat_16 ,clfeeb_fumendopat_17 ,clfeeb_fumendopat_18 ,clfeeb_fumendopat_19 ,clfeeb_fumendopat_20 ,clfeeb_fumendopat_21 ,clfeeb_fumendopat_22 ,clfeeb_fumendopat_23 ,clfeeb_fumendopat_24 ,clfeeb_fumendopat_25 ,clfeeb_fumendopat_26 ,clfeeb_fumendopat_27 ,clfeeb_fumendopat_28 ,clfeeb_fumOvI_1_v1 ,clfeeb_fumOvI_2_v1 ,clfeeb_fumOvI_3_v1 ,clfeeb_fumOvI_4_v1 ,clfeeb_fumOvI_5_v1 ,clfeeb_fumOvI_6_v1 ,clfeeb_fumOvI_7_v1 ,clfeeb_fumOvI_8_v1 ,clfeeb_fumOvI_9_v1 ,clfeeb_fumOvI_10_v1 ,clfeeb_fumOvI_11_v1 ,clfeeb_fumOvI_12_v1 ,clfeeb_fumOvI_13_v1 ,clfeeb_fumOvI_14_v1 ,clfeeb_fumOvI_15_v1 ,clfeeb_fumOvI_16_v1 ,clfeeb_fumOvI_17_v1 ,clfeeb_fumOvI_18_v1 ,clfeeb_fumOvI_19_v1 ,clfeeb_fumOvI_20_v1 ,clfeeb_fumOvI_21_v1 ,clfeeb_fumOvI_22_v1 ,clfeeb_fumOvI_23_v1 ,clfeeb_fumOvI_24_v1 ,clfeeb_fumOvI_25_v1 ,clfeeb_fumOvI_26_v1 ,clfeeb_fumOvI_27_v1 ,clfeeb_fumOvI_28_v1 ,clfeeb_fumOvI_1_v2 ,clfeeb_fumOvI_2_v2 ,clfeeb_fumOvI_3_v2 ,clfeeb_fumOvI_4_v2 ,clfeeb_fumOvI_5_v2 ,clfeeb_fumOvI_6_v2 ,clfeeb_fumOvI_7_v2 ,clfeeb_fumOvI_8_v2 ,clfeeb_fumOvI_9_v2 ,clfeeb_fumOvI_10_v2 ,clfeeb_fumOvI_11_v2 ,clfeeb_fumOvI_12_v2 ,clfeeb_fumOvI_13_v2 ,clfeeb_fumOvI_14_v2 ,clfeeb_fumOvI_15_v2 ,clfeeb_fumOvI_16_v2 ,clfeeb_fumOvI_17_v2 ,clfeeb_fumOvI_18_v2 ,clfeeb_fumOvI_19_v2 ,clfeeb_fumOvI_20_v2 ,clfeeb_fumOvI_21_v2 ,clfeeb_fumOvI_22_v2 ,clfeeb_fumOvI_23_v2 ,clfeeb_fumOvI_24_v2 ,clfeeb_fumOvI_25_v2 ,clfeeb_fumOvI_26_v2 ,clfeeb_fumOvI_27_v2 ,clfeeb_fumOvI_28_v2 ,clfeeb_fumOvI_1_v3 ,clfeeb_fumOvI_2_v3 ,clfeeb_fumOvI_3_v3 ,clfeeb_fumOvI_4_v3 ,clfeeb_fumOvI_5_v3 ,clfeeb_fumOvI_6_v3 ,clfeeb_fumOvI_7_v3 ,clfeeb_fumOvI_8_v3 ,clfeeb_fumOvI_9_v3 ,clfeeb_fumOvI_10_v3 ,clfeeb_fumOvI_11_v3 ,clfeeb_fumOvI_12_v3 ,clfeeb_fumOvI_13_v3 ,clfeeb_fumOvI_14_v3 ,clfeeb_fumOvI_15_v3 ,clfeeb_fumOvI_16_v3 ,clfeeb_fumOvI_17_v3 ,clfeeb_fumOvI_18_v3 ,clfeeb_fumOvI_19_v3 ,clfeeb_fumOvI_20_v3 ,clfeeb_fumOvI_21_v3 ,clfeeb_fumOvI_22_v3 ,clfeeb_fumOvI_23_v3 ,clfeeb_fumOvI_24_v3 ,clfeeb_fumOvI_25_v3 ,clfeeb_fumOvI_26_v3 ,clfeeb_fumOvI_27_v3 ,clfeeb_fumOvI_28_v3 ,clfeeb_fumOvI_1_v4 ,clfeeb_fumOvI_2_v4 ,clfeeb_fumOvI_3_v4 ,clfeeb_fumOvI_4_v4 ,clfeeb_fumOvI_5_v4 ,clfeeb_fumOvI_6_v4 ,clfeeb_fumOvI_7_v4 ,clfeeb_fumOvI_8_v4 ,clfeeb_fumOvI_9_v4 ,clfeeb_fumOvI_10_v4 ,clfeeb_fumOvI_11_v4 ,clfeeb_fumOvI_12_v4 ,clfeeb_fumOvI_13_v4 ,clfeeb_fumOvI_14_v4 ,clfeeb_fumOvI_15_v4 ,clfeeb_fumOvI_16_v4 ,clfeeb_fumOvI_17_v4 ,clfeeb_fumOvI_18_v4 ,clfeeb_fumOvI_19_v4 ,clfeeb_fumOvI_20_v4 ,clfeeb_fumOvI_21_v4 ,clfeeb_fumOvI_22_v4 ,clfeeb_fumOvI_23_v4 ,clfeeb_fumOvI_24_v4 ,clfeeb_fumOvI_25_v4 ,clfeeb_fumOvI_26_v4 ,clfeeb_fumOvI_27_v4 ,clfeeb_fumOvI_28_v4 ,clfeeb_fumOvI_1_v5 ,clfeeb_fumOvI_2_v5 ,clfeeb_fumOvI_3_v5 ,clfeeb_fumOvI_4_v5 ,clfeeb_fumOvI_5_v5 ,clfeeb_fumOvI_6_v5 ,clfeeb_fumOvI_7_v5 ,clfeeb_fumOvI_8_v5 ,clfeeb_fumOvI_9_v5 ,clfeeb_fumOvI_10_v5 ,clfeeb_fumOvI_11_v5 ,clfeeb_fumOvI_12_v5 ,clfeeb_fumOvI_13_v5 ,clfeeb_fumOvI_14_v5 ,clfeeb_fumOvI_15_v5 ,clfeeb_fumOvI_16_v5 ,clfeeb_fumOvI_17_v5 ,clfeeb_fumOvI_18_v5 ,clfeeb_fumOvI_19_v5 ,clfeeb_fumOvI_20_v5 ,clfeeb_fumOvI_21_v5 ,clfeeb_fumOvI_22_v5 ,clfeeb_fumOvI_23_v5 ,clfeeb_fumOvI_24_v5 ,clfeeb_fumOvI_25_v5 ,clfeeb_fumOvI_26_v5 ,clfeeb_fumOvI_27_v5 ,clfeeb_fumOvI_28_v5 ,clfeeb_fumOvI_1_v6 ,clfeeb_fumOvI_2_v6 ,clfeeb_fumOvI_3_v6 ,clfeeb_fumOvI_4_v6 ,clfeeb_fumOvI_5_v6 ,clfeeb_fumOvI_6_v6 ,clfeeb_fumOvI_7_v6 ,clfeeb_fumOvI_8_v6 ,clfeeb_fumOvI_9_v6 ,clfeeb_fumOvI_10_v6 ,clfeeb_fumOvI_11_v6 ,clfeeb_fumOvI_12_v6 ,clfeeb_fumOvI_13_v6 ,clfeeb_fumOvI_14_v6 ,clfeeb_fumOvI_15_v6 ,clfeeb_fumOvI_16_v6 ,clfeeb_fumOvI_17_v6 ,clfeeb_fumOvI_18_v6 ,clfeeb_fumOvI_19_v6 ,clfeeb_fumOvI_20_v6 ,clfeeb_fumOvI_21_v6 ,clfeeb_fumOvI_22_v6 ,clfeeb_fumOvI_23_v6 ,clfeeb_fumOvI_24_v6 ,clfeeb_fumOvI_25_v6 ,clfeeb_fumOvI_26_v6 ,clfeeb_fumOvI_27_v6 ,clfeeb_fumOvI_28_v6 ,clfeeb_fumOvI_1_v7 ,clfeeb_fumOvI_2_v7 ,clfeeb_fumOvI_3_v7 ,clfeeb_fumOvI_4_v7 ,clfeeb_fumOvI_5_v7 ,clfeeb_fumOvI_6_v7 ,clfeeb_fumOvI_7_v7 ,clfeeb_fumOvI_8_v7 ,clfeeb_fumOvI_9_v7 ,clfeeb_fumOvI_10_v7 ,clfeeb_fumOvI_11_v7 ,clfeeb_fumOvI_12_v7 ,clfeeb_fumOvI_13_v7 ,clfeeb_fumOvI_14_v7 ,clfeeb_fumOvI_15_v7 ,clfeeb_fumOvI_16_v7 ,clfeeb_fumOvI_17_v7 ,clfeeb_fumOvI_18_v7 ,clfeeb_fumOvI_19_v7 ,clfeeb_fumOvI_20_v7 ,clfeeb_fumOvI_21_v7 ,clfeeb_fumOvI_22_v7 ,clfeeb_fumOvI_23_v7 ,clfeeb_fumOvI_24_v7 ,clfeeb_fumOvI_25_v7 ,clfeeb_fumOvI_26_v7 ,clfeeb_fumOvI_27_v7 ,clfeeb_fumOvI_28_v7 ,clfeeb_fumOvI_1_v8 ,clfeeb_fumOvI_2_v8 ,clfeeb_fumOvI_3_v8 ,clfeeb_fumOvI_4_v8 ,clfeeb_fumOvI_5_v8 ,clfeeb_fumOvI_6_v8 ,clfeeb_fumOvI_7_v8 ,clfeeb_fumOvI_8_v8 ,clfeeb_fumOvI_9_v8 ,clfeeb_fumOvI_10_v8 ,clfeeb_fumOvI_11_v8 ,clfeeb_fumOvI_12_v8 ,clfeeb_fumOvI_13_v8 ,clfeeb_fumOvI_14_v8 ,clfeeb_fumOvI_15_v8 ,clfeeb_fumOvI_16_v8 ,clfeeb_fumOvI_17_v8 ,clfeeb_fumOvI_18_v8 ,clfeeb_fumOvI_19_v8 ,clfeeb_fumOvI_20_v8 ,clfeeb_fumOvI_21_v8 ,clfeeb_fumOvI_22_v8 ,clfeeb_fumOvI_23_v8 ,clfeeb_fumOvI_24_v8 ,clfeeb_fumOvI_25_v8 ,clfeeb_fumOvI_26_v8 ,clfeeb_fumOvI_27_v8 ,clfeeb_fumOvI_28_v8 ,clfeeb_fumOvI_1_v9 ,clfeeb_fumOvI_2_v9 ,clfeeb_fumOvI_3_v9 ,clfeeb_fumOvI_4_v9 ,clfeeb_fumOvI_5_v9 ,clfeeb_fumOvI_6_v9 ,clfeeb_fumOvI_7_v9 ,clfeeb_fumOvI_8_v9 ,clfeeb_fumOvI_9_v9 ,clfeeb_fumOvI_10_v9 ,clfeeb_fumOvI_11_v9 ,clfeeb_fumOvI_12_v9 ,clfeeb_fumOvI_13_v9 ,clfeeb_fumOvI_14_v9 ,clfeeb_fumOvI_15_v9 ,clfeeb_fumOvI_16_v9 ,clfeeb_fumOvI_17_v9 ,clfeeb_fumOvI_18_v9 ,clfeeb_fumOvI_19_v9 ,clfeeb_fumOvI_20_v9 ,clfeeb_fumOvI_21_v9 ,clfeeb_fumOvI_22_v9 ,clfeeb_fumOvI_23_v9 ,clfeeb_fumOvI_24_v9 ,clfeeb_fumOvI_25_v9 ,clfeeb_fumOvI_26_v9 ,clfeeb_fumOvI_27_v9 ,clfeeb_fumOvI_28_v9 ,clfeeb_fumOvD_1_v1 ,clfeeb_fumOvD_2_v1 ,clfeeb_fumOvD_3_v1 ,clfeeb_fumOvD_4_v1 ,clfeeb_fumOvD_5_v1 ,clfeeb_fumOvD_6_v1 ,clfeeb_fumOvD_7_v1 ,clfeeb_fumOvD_8_v1 ,clfeeb_fumOvD_9_v1 ,clfeeb_fumOvD_10_v1 ,clfeeb_fumOvD_11_v1 ,clfeeb_fumOvD_12_v1 ,clfeeb_fumOvD_13_v1 ,clfeeb_fumOvD_14_v1 ,clfeeb_fumOvD_15_v1 ,clfeeb_fumOvD_16_v1 ,clfeeb_fumOvD_17_v1 ,clfeeb_fumOvD_18_v1 ,clfeeb_fumOvD_19_v1 ,clfeeb_fumOvD_20_v1 ,clfeeb_fumOvD_21_v1 ,clfeeb_fumOvD_22_v1 ,clfeeb_fumOvD_23_v1 ,clfeeb_fumOvD_24_v1 ,clfeeb_fumOvD_25_v1 ,clfeeb_fumOvD_26_v1 ,clfeeb_fumOvD_27_v1 ,clfeeb_fumOvD_28_v1 ,clfeeb_fumOvD_1_v2 ,clfeeb_fumOvD_2_v2 ,clfeeb_fumOvD_3_v2 ,clfeeb_fumOvD_4_v2 ,clfeeb_fumOvD_5_v2 ,clfeeb_fumOvD_6_v2 ,clfeeb_fumOvD_7_v2 ,clfeeb_fumOvD_8_v2 ,clfeeb_fumOvD_9_v2 ,clfeeb_fumOvD_10_v2 ,clfeeb_fumOvD_11_v2 ,clfeeb_fumOvD_12_v2 ,clfeeb_fumOvD_13_v2 ,clfeeb_fumOvD_14_v2 ,clfeeb_fumOvD_15_v2 ,clfeeb_fumOvD_16_v2 ,clfeeb_fumOvD_17_v2 ,clfeeb_fumOvD_18_v2 ,clfeeb_fumOvD_19_v2 ,clfeeb_fumOvD_20_v2 ,clfeeb_fumOvD_21_v2 ,clfeeb_fumOvD_22_v2 ,clfeeb_fumOvD_23_v2 ,clfeeb_fumOvD_24_v2 ,clfeeb_fumOvD_25_v2 ,clfeeb_fumOvD_26_v2 ,clfeeb_fumOvD_27_v2 ,clfeeb_fumOvD_28_v2 ,clfeeb_fumOvD_1_v3 ,clfeeb_fumOvD_2_v3 ,clfeeb_fumOvD_3_v3 ,clfeeb_fumOvD_4_v3 ,clfeeb_fumOvD_5_v3 ,clfeeb_fumOvD_6_v3 ,clfeeb_fumOvD_7_v3 ,clfeeb_fumOvD_8_v3 ,clfeeb_fumOvD_9_v3 ,clfeeb_fumOvD_10_v3 ,clfeeb_fumOvD_11_v3 ,clfeeb_fumOvD_12_v3 ,clfeeb_fumOvD_13_v3 ,clfeeb_fumOvD_14_v3 ,clfeeb_fumOvD_15_v3 ,clfeeb_fumOvD_16_v3 ,clfeeb_fumOvD_17_v3 ,clfeeb_fumOvD_18_v3 ,clfeeb_fumOvD_19_v3 ,clfeeb_fumOvD_20_v3 ,clfeeb_fumOvD_21_v3 ,clfeeb_fumOvD_22_v3 ,clfeeb_fumOvD_23_v3 ,clfeeb_fumOvD_24_v3 ,clfeeb_fumOvD_25_v3 ,clfeeb_fumOvD_26_v3 ,clfeeb_fumOvD_27_v3 ,clfeeb_fumOvD_28_v3 ,clfeeb_fumOvD_1_v4 ,clfeeb_fumOvD_2_v4 ,clfeeb_fumOvD_3_v4 ,clfeeb_fumOvD_4_v4 ,clfeeb_fumOvD_5_v4 ,clfeeb_fumOvD_6_v4 ,clfeeb_fumOvD_7_v4 ,clfeeb_fumOvD_8_v4 ,clfeeb_fumOvD_9_v4 ,clfeeb_fumOvD_10_v4 ,clfeeb_fumOvD_11_v4 ,clfeeb_fumOvD_12_v4 ,clfeeb_fumOvD_13_v4 ,clfeeb_fumOvD_14_v4 ,clfeeb_fumOvD_15_v4 ,clfeeb_fumOvD_16_v4 ,clfeeb_fumOvD_17_v4 ,clfeeb_fumOvD_18_v4 ,clfeeb_fumOvD_19_v4 ,clfeeb_fumOvD_20_v4 ,clfeeb_fumOvD_21_v4 ,clfeeb_fumOvD_22_v4 ,clfeeb_fumOvD_23_v4 ,clfeeb_fumOvD_24_v4 ,clfeeb_fumOvD_25_v4 ,clfeeb_fumOvD_26_v4 ,clfeeb_fumOvD_27_v4 ,clfeeb_fumOvD_28_v4 ,clfeeb_fumOvD_1_v5 ,clfeeb_fumOvD_2_v5 ,clfeeb_fumOvD_3_v5 ,clfeeb_fumOvD_4_v5 ,clfeeb_fumOvD_5_v5 ,clfeeb_fumOvD_6_v5 ,clfeeb_fumOvD_7_v5 ,clfeeb_fumOvD_8_v5 ,clfeeb_fumOvD_9_v5 ,clfeeb_fumOvD_10_v5 ,clfeeb_fumOvD_11_v5 ,clfeeb_fumOvD_12_v5 ,clfeeb_fumOvD_13_v5 ,clfeeb_fumOvD_14_v5 ,clfeeb_fumOvD_15_v5 ,clfeeb_fumOvD_16_v5 ,clfeeb_fumOvD_17_v5 ,clfeeb_fumOvD_18_v5 ,clfeeb_fumOvD_19_v5 ,clfeeb_fumOvD_20_v5 ,clfeeb_fumOvD_21_v5 ,clfeeb_fumOvD_22_v5 ,clfeeb_fumOvD_23_v5 ,clfeeb_fumOvD_24_v5 ,clfeeb_fumOvD_25_v5 ,clfeeb_fumOvD_26_v5 ,clfeeb_fumOvD_27_v5 ,clfeeb_fumOvD_28_v5 ,clfeeb_fumOvD_1_v6 ,clfeeb_fumOvD_2_v6 ,clfeeb_fumOvD_3_v6 ,clfeeb_fumOvD_4_v6 ,clfeeb_fumOvD_5_v6 ,clfeeb_fumOvD_6_v6 ,clfeeb_fumOvD_7_v6 ,clfeeb_fumOvD_8_v6 ,clfeeb_fumOvD_9_v6 ,clfeeb_fumOvD_10_v6 ,clfeeb_fumOvD_11_v6 ,clfeeb_fumOvD_12_v6 ,clfeeb_fumOvD_13_v6 ,clfeeb_fumOvD_14_v6 ,clfeeb_fumOvD_15_v6 ,clfeeb_fumOvD_16_v6 ,clfeeb_fumOvD_17_v6 ,clfeeb_fumOvD_18_v6 ,clfeeb_fumOvD_19_v6 ,clfeeb_fumOvD_20_v6 ,clfeeb_fumOvD_21_v6 ,clfeeb_fumOvD_22_v6 ,clfeeb_fumOvD_23_v6 ,clfeeb_fumOvD_24_v6 ,clfeeb_fumOvD_25_v6 ,clfeeb_fumOvD_26_v6 ,clfeeb_fumOvD_27_v6 ,clfeeb_fumOvD_28_v6 ,clfeeb_fumOvD_1_v7 ,clfeeb_fumOvD_2_v7 ,clfeeb_fumOvD_3_v7 ,clfeeb_fumOvD_4_v7 ,clfeeb_fumOvD_5_v7 ,clfeeb_fumOvD_6_v7 ,clfeeb_fumOvD_7_v7 ,clfeeb_fumOvD_8_v7 ,clfeeb_fumOvD_9_v7 ,clfeeb_fumOvD_10_v7 ,clfeeb_fumOvD_11_v7 ,clfeeb_fumOvD_12_v7 ,clfeeb_fumOvD_13_v7 ,clfeeb_fumOvD_14_v7 ,clfeeb_fumOvD_15_v7 ,clfeeb_fumOvD_16_v7 ,clfeeb_fumOvD_17_v7 ,clfeeb_fumOvD_18_v7 ,clfeeb_fumOvD_19_v7 ,clfeeb_fumOvD_20_v7 ,clfeeb_fumOvD_21_v7 ,clfeeb_fumOvD_22_v7 ,clfeeb_fumOvD_23_v7 ,clfeeb_fumOvD_24_v7 ,clfeeb_fumOvD_25_v7 ,clfeeb_fumOvD_26_v7 ,clfeeb_fumOvD_27_v7 ,clfeeb_fumOvD_28_v7 ,clfeeb_fumOvD_1_v8 ,clfeeb_fumOvD_2_v8 ,clfeeb_fumOvD_3_v8 ,clfeeb_fumOvD_4_v8 ,clfeeb_fumOvD_5_v8 ,clfeeb_fumOvD_6_v8 ,clfeeb_fumOvD_7_v8 ,clfeeb_fumOvD_8_v8 ,clfeeb_fumOvD_9_v8 ,clfeeb_fumOvD_10_v8 ,clfeeb_fumOvD_11_v8 ,clfeeb_fumOvD_12_v8 ,clfeeb_fumOvD_13_v8 ,clfeeb_fumOvD_14_v8 ,clfeeb_fumOvD_15_v8 ,clfeeb_fumOvD_16_v8 ,clfeeb_fumOvD_17_v8 ,clfeeb_fumOvD_18_v8 ,clfeeb_fumOvD_19_v8 ,clfeeb_fumOvD_20_v8 ,clfeeb_fumOvD_21_v8 ,clfeeb_fumOvD_22_v8 ,clfeeb_fumOvD_23_v8 ,clfeeb_fumOvD_24_v8 ,clfeeb_fumOvD_25_v8 ,clfeeb_fumOvD_26_v8 ,clfeeb_fumOvD_27_v8 ,clfeeb_fumOvD_28_v8 ,clfeeb_fumOvD_1_v9 ,clfeeb_fumOvD_2_v9 ,clfeeb_fumOvD_3_v9 ,clfeeb_fumOvD_4_v9 ,clfeeb_fumOvD_5_v9 ,clfeeb_fumOvD_6_v9 ,clfeeb_fumOvD_7_v9 ,clfeeb_fumOvD_8_v9 ,clfeeb_fumOvD_9_v9 ,clfeeb_fumOvD_10_v9 ,clfeeb_fumOvD_11_v9 ,clfeeb_fumOvD_12_v9 ,clfeeb_fumOvD_13_v9 ,clfeeb_fumOvD_14_v9 ,clfeeb_fumOvD_15_v9 ,clfeeb_fumOvD_16_v9 ,clfeeb_fumOvD_17_v9 ,clfeeb_fumOvD_18_v9 ,clfeeb_fumOvD_19_v9 ,clfeeb_fumOvD_20_v9 ,clfeeb_fumOvD_21_v9 ,clfeeb_fumOvD_22_v9 ,clfeeb_fumOvD_23_v9 ,clfeeb_fumOvD_24_v9 ,clfeeb_fumOvD_25_v9 ,clfeeb_fumOvD_26_v9 ,clfeeb_fumOvD_27_v9 ,clfeeb_fumOvD_28_v9 ,clfeeb_fumEA_1 ,clfeeb_fumEA_2 ,clfeeb_fumEA_3 ,clfeeb_fumEA_4 ,clfeeb_fumEA_5 ,clfeeb_fumEA_6 ,clfeeb_fumEA_7 ,clfeeb_fumEA_8 ,clfeeb_fumEA_9 ,clfeeb_fumEA_10 ,clfeeb_fumEA_11 ,clfeeb_fumEA_12 ,clfeeb_fumEA_13 ,clfeeb_fumEA_14 ,clfeeb_fumEA_15 ,clfeeb_fumEA_16 ,clfeeb_fumEA_17 ,clfeeb_fumEA_18 ,clfeeb_fumEA_19 ,clfeeb_fumEA_20 ,clfeeb_fumEA_21 ,clfeeb_fumEA_22 ,clfeeb_fumEA_23 ,clfeeb_fumEA_24 ,clfeeb_fumEA_25 ,clfeeb_fumEA_26 ,clfeeb_fumEA_27 ,clfeeb_fumEA_28 ) VALUES ( '".$params["items"][0]["clicod"]."' ,".$estado." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["temb"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["droga"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["droga2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["droga3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["tiprocedimiento"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["rm"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["semen"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["semenorigen"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["subunidadbeta"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["tese"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["ionoforos"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["cgh"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["aneximas"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["hatching"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["vitrificaovos"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["vitrificaembriones"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["diag1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["diag2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["comentario"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["aih_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["aih_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["aih_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fum_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumDay_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumVal2_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendoesp_28"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumendopat_28"])))." ".$ovariosI." ".$ovariosD." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_1"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_2"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_3"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_4"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_5"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_6"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_7"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_8"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_9"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_10"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_11"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_12"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_13"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_14"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_15"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_16"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_17"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_18"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_19"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_20"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_21"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_22"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_23"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_24"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_25"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_26"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_27"])))." ,".getDBNullValue(trim(strtoupper($params["items"][0]["estalta"][$i]["fumEAapl_28"])))." )"; $x = array_push($sqllst,$sqlItem); } } //print_r($sqllst);print_r("\n");die; //print_r($sqllst);die; if( setConeccionTransaccion() ) { $flagTransactionInit = true; $GLOBALS['dbSQLTR']->setBeginTransaction(); $continue = true; if($idHxMedGineco) { //BORRAR TABLAS HIJAS $espermograma = "DELETE FROM cli_fer_hxmedia_espermograma WHERE clfehcm_numero = ".$idHxMedGineco; $x = array_push($sqllst,$espermograma); $estudios = "DELETE FROM cli_fer_hxmedia_estudios_solicitados WHERE clfehcm_numero = ".$idHxMedGineco; $x = array_push($sqllst,$estudios); //REEMPLAZAR IDs for($k=0,$totalK=count($sqllstTblChild);$k<$totalK;$k++) { $item = str_replace('{{ID}}',$idHxMedGineco,$sqllstTblChild[$k]); $x = array_push($sqllst,$item); } //print_r($sqllst); for($i=0,$total=count($sqllst);$i<$total&&$continue;$i++) { $resultado = $GLOBALS['dbSQLTR']->QueryTR($sqllst[$i],true); if ( !$resultado ) { print_r($sqllst[$i]);print_r("\n"); $res = $GLOBALS['dbSQLTR']->setRollbackTransaction(); $continue = false; $resultInfo['code'] = -1; $resultInfo['errorDes'] = "Error al grabar los cambios - [Codigo 1001]"; } } } else { //NUEVA HX GINECO //print_r($hxmedgineco);print_r("\n"); $resultado = $GLOBALS['dbSQLTR']->QueryTR($hxmedgineco,true); if ( !$resultado ) { print_r($hxmedgineco);print_r("\n"); $res = $GLOBALS['dbSQLTR']->setRollbackTransaction(); $continue = false; $resultInfo['code'] = -1; $resultInfo['errorDes'] = "Error al grabar los cambios - [Codigo 1001]"; } else { $idHxMedGineco = $GLOBALS['dbSQLTR']->getTRLastId('cli_fer_hxmedia','clfehcm_numero'); //print_r("idHxMedGineco[$idHxMedGineco]");print_r("\n"); if($idHxMedGineco) { //REEMPLAZAR IDs for($k=0,$totalK=count($sqllstTblChild);$k<$totalK;$k++) { $item = str_replace('{{ID}}',$idHxMedGineco,$sqllstTblChild[$k]); $x = array_push($sqllst,$item); } } else { print_r($hxmedgineco);print_r("\n"); $res = $GLOBALS['dbSQLTR']->setRollbackTransaction(); $continue = false; $resultInfo['code'] = -1; $resultInfo['errorDes'] = "Error al grabar los cambios - [Codigo 1009]"; } } if( $continue ) { for($i=0,$total=count($sqllst);$i<$total&&$continue;$i++) { //print_r($sqllst[$i]);print_r("\n"); $resultado = $GLOBALS['dbSQLTR']->QueryTR($sqllst[$i],true); if ( !$resultado ) { print_r($sqllst[$i]);print_r("\n"); $res = $GLOBALS['dbSQLTR']->setRollbackTransaction(); $continue = false; $resultInfo['code'] = -1; $resultInfo['errorDes'] = "Error al grabar los cambios - [Codigo 1001]"; } } } } if( $continue ) { $res = $GLOBALS['dbSQLTR']->setCommitTransaction(); $resultInfo['res'] = 1; return true; } } else { $resultInfo['code'] = -1; $resultInfo['errorDes'] = "Error al grabar los cambios - [Codigo 1004]"; } } else { $continue = false; $resultInfo['code'] = -1; $resultInfo['errorDes'] = "Error: El usuario actual no esta asociado a un Profesional - [Codigo 1001]"; } } else { $resultInfo['code'] = -1; $resultInfo['errorDes'] = "Error: parámetros faltantes - [Codigo 1003]"; } return true; } catch ( Exception $e ) { $resultInfo['code'] = CODE_RESULT_ERROR_FATAL; $resultInfo['errorDes'] = "Error:".($e->__toString()); //$this->logTrace(debug_backtrace(),$e->__toString()); //print_r($e->__toString()); return false; } } // -------------------------------------------- // END - HX FERTILIDAD // -------------------------------------------- // -------------------------------------------- // LANDAAGENT // -------------------------------------------- function listarFacturasVto($userId,&$resultInfo) { try { $orderBy = " cmpvto.faccomp_fecvto ASC "; $filters = ''; $continue=true; //Fecha $flagFecha = false; if( isset($_REQUEST["fd"]) && !is_null($_REQUEST["fd"]) && intval($_REQUEST["fd"])!==(-1) && isset($_REQUEST["fh"]) && !is_null($_REQUEST["fh"]) && intval($_REQUEST["fh"])!==(-1) ) { $flagFecha = true; $rango = array(); $rango[0] = DateTime::createFromFormat('d/m/Y', $_REQUEST["fd"]); $rango[1] = DateTime::createFromFormat('d/m/Y', $_REQUEST["fh"]); $desde = date("Y-m-d",strtotime($rango[0]->format('Y-m-d'))); $hasta = date("Y-m-d",strtotime($rango[1]->format('Y-m-d'))); } //Proveedor $flagProveedor = false; if( isset($_REQUEST["pro_d"])&&is_numeric($_REQUEST["pro_d"])&&intval($_REQUEST["pro_d"])!==(-1)&& isset($_REQUEST["pro_h"])&&is_numeric($_REQUEST["pro_h"])&&intval($_REQUEST["pro_h"])!==(-1) ) { $flagProveedor = true; } //APLICAR FILTROS $params = "NOT EXISTS (SELECT 1 FROM op_imputacion as c WHERE cmp.faccomp_sede=c.faccomp_sede AND cmp.faccomp_nroint=c.faccomp_nroint)"; $params = "cmp.faccomp_saldo>0"; $sep=" AND "; if($params==""){$sep="";} if($flagProveedor) { $params.= $sep . " ( cmp.pr_codigo BETWEEN '".addslashes($_REQUEST["pro_d"])."' AND '".addslashes($_REQUEST["pro_h"])."')"; } $sep=" AND "; if($params==""){$sep="";} if($flagFecha) { $params.= $sep . " ( LEFT(CONVERT(VARCHAR,cmpvto.faccomp_fecvto, 120), 10) BETWEEN LEFT(CONVERT(VARCHAR,'".$desde."', 120), 10) AND LEFT(CONVERT(VARCHAR,'".$hasta."', 120), 10) )"; } //------------------------------ //LISTAR FACTURAS CUYO VENTIMIENTO SE ENCUENTRE DENTRO DE UN RANGO ESPECIFICO //------------------------------ $GLOBALS['dbSQLAgent'] = new DataBaseSQLNew($GLOBALS['MSSQL']['DB_AGENT_HOST'], $GLOBALS['MSSQL']['DB_AGENT_DB_NAME'], $GLOBALS['MSSQL']['DB_AGENT_USER'], $GLOBALS['MSSQL']['DB_AGENT_PASS']); if( !$GLOBALS['dbSQLAgent']->initialize ) { //Error al conectar con la base de datos $continue=false; } if($continue) { $sql = "SELECT cmp.faccomp_sede as sede ,cmp.faccomp_nroint as nro ,cmp.faccomp_letra as letra ,cmp.pr_codigo as cod ,pr.PR_DENOM as denom ,pr.PR_CUIT as cuit ,FORMAT(cmpvto.faccomp_fecvto,'dd/MM/yyyy') AS vto ,cmp.faccomp_total as importe FROM comp_fact_vtos as cmpvto INNER JOIN comp_facturas as cmp ON cmp.faccomp_sede = cmpvto.faccomp_sede AND cmp.faccomp_nroint = cmpvto.faccomp_nroint LEFT JOIN proveedores as pr ON pr.pr_codigo = cmp.pr_codigo WHERE ".$params." ORDER BY ".$orderBy; //print_r($sql);die; $rs = $GLOBALS['dbSQLAgent']->Query($sql); if ( $rs ) { $lstfacturas = $GLOBALS['dbSQLAgent']->getAll(); if(is_array($lstfacturas)&&count($lstfacturas)>0) { return $lstfacturas; } else { return EMPTY_LST_OBJ; } } } return false; } catch ( Exception $e ) { $resultInfo['code'] = CODE_RESULT_ERROR_FATAL; $resultInfo['errorDes'] = "Error:".($e->__toString()); //$this->logTrace(debug_backtrace(),$e->__toString()); //print_r($e->__toString()); return false; } } function getFacturasAVencer(&$resultInfo) { if( isset($_REQUEST["token"]) && !empty($_REQUEST["token"]) && !is_null($_REQUEST["token"]) ) { //Validar el Token $defaultErrorMsj=false; $userId=false; $continue = validateToken($_REQUEST["token"],$resultInfo,$defaultErrorMsj,$userId); if( $continue ) { $resultInfo=false; $resultado = listarFacturasVto($userId,$resultInfo); if(!isset($_REQUEST["fdw"])&&!isset($_REQUEST["fse"])) { if( $resultado ) { $resultInfo['code'] = 0; $resultInfo['data'] = array( "total" =>(is_array($resultado)&&count($resultado)>0?count($resultado):0) ,"lst" =>(is_array($resultado)&&count($resultado)>0?$resultado:EMPTY_LST_OBJ) ); return true; } else { $resultInfo=array(); $resultInfo['code'] = 2; $resultInfo['errorDes'] = "SE PRODUJO UN ERROR EN EL SISTEMA AL CONSULTAR LOS COMPROBANTES"; } } elseif(isset($_REQUEST["fdw"])) { if(is_array($resultado)&&count($resultado)>0) { //$data = getFacturasVtoReporte($resultado); $data =$resultado; //print_r($data);die; $headers = array( "Sede", "Numero", "Letra", "Pro.cod.", "Proveedor", "CUIT", "Fecha Vto.", "Importe $", ); $fileName = $_REQUEST["fname"]; flush(); $spreadsheet = new Spreadsheet(); $activeWorksheet = $spreadsheet->getActiveSheet(); for ($i = 0, $l = sizeof($headers); $i < $l; $i++) { $activeWorksheet->setCellValueByColumnAndRow($i + 1, 1, $headers[$i]); } for ($i = 0, $l = sizeof($data); $i < $l; $i++) { // row $i $j = 0; foreach ($data[$i] as $k => $v) { // column $j $activeWorksheet->setCellValueByColumnAndRow($j + 1, ($i + 1 + 1), $v); $j++; } } $writer = new Xlsx($spreadsheet); header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment; filename="'. urlencode($fileName).'"'); header("Pragma: no-cache"); header("Expires: 0"); ob_clean(); $writer->save("./repodownload/".$fileName); } } elseif(isset($_REQUEST["fse"])) { if( $resultado ) { $resultadoEmail = false; if(is_array($resultado)&&count($resultado)>0) { $resultadoEmail = sendReporteFacVtoEmail($resultado,$GLOBALS['LISTA_DESTINATARIOS']); } $resultInfo['code'] = 0; $resultInfo['data'] = array( "total" =>(is_array($resultado)&&count($resultado)>0?count($resultado):0) ); return true; } else { $resultInfo=array(); $resultInfo['code'] = 2; $resultInfo['errorDes'] = "SE PRODUJO UN ERROR EN EL SISTEMA AL CONSULTAR LOS COMPROBANTES"; } } else { $resultInfo['code'] = 2; $resultInfo['errorDes'] = "Parametros Faltantes"; } } } else { $resultInfo['code'] = 1; $resultInfo['errorDes'] = "Parametros Faltantes"; } return true; } function saveLogEmailFacSVtoSemanal($result,$type='') { $uniq_id = md5(uniqid(time())); $path = "./logs/"; $logfilename = $path.'log_emailfacctosemanal_'.$type."_".$uniq_id.'_'.(date('dmY_His')).'.log'; $actual = print_r($result,true); file_put_contents($logfilename, $actual); } function getFacturasAVencerSemanal(&$resultInfo) { $_REQUEST["fd"] = date("d/m/Y", strtotime(date("Y-m-d"). ' + 1 days')); $_REQUEST["fh"] = date("d/m/Y", strtotime(date("Y-m-d"). ' + 7 days')); // $fi = date("dmY", strtotime($_REQUEST["fd"])); // $ff = date("dmY", strtotime($_REQUEST["fh"])); $fi = str_replace("/","",$_REQUEST["fd"]); $ff = str_replace("/","",$_REQUEST["fh"]); $date = $fi . "_" . $ff . "_" . date("dmY_His"); $fileName = "facturasvto_" . $date . ".xlsx"; $_REQUEST["fname"]=$fileName; $info = array( "total" => "-" ,"fecha" => date("d/m/Y H:i:s") ,"request" => $_REQUEST ); $resultInfo=false; $resultado = listarFacturasVto(false,$resultInfo); if( $resultado || $resultado==EMPTY_LST_OBJ ) { $resultadoEmail = false; if(is_array($resultado)&&count($resultado)>0) { // print_r("-----resultado-----");print_r("\n"); // print_r($resultado);print_r("\n"); // print_r("-------------------");print_r("\n"); $resultadoEmail = sendReporteFacVtoEmail($resultado,$GLOBALS['LISTA_DESTINATARIOS']); $info["total"] = count($resultado); $info["lst"] = base64_decode($resultado); } elseif($resultado==EMPTY_LST_OBJ) { // print_r("-----resultado-----");print_r("\n"); // print_r($resultado);print_r("\n"); // print_r("-------------------");print_r("\n"); $resultadoEmail = sendReporteFacVtoEmail('',$GLOBALS['LISTA_DESTINATARIOS']); $info["total"] = count($resultado); $info["lst"] = base64_decode($resultado); } $resultInfo['code'] = 0; $resultInfo['data'] = 1; $info["resinf"] = $resultInfo; $info["res"] = RESULT_SUCCESS; saveLogEmailFacSVtoSemanal($info,LOG_TYPE_ENVIO_EMAIL_SEMANAL); return true; } else { $resultInfo=array(); $resultInfo['code'] = 2; $resultInfo['errorDes'] = "SE PRODUJO UN ERROR EN EL SISTEMA AL CONSULTAR LOS COMPROBANTES"; } $info["resinf"] = $resultInfo; $info["res"] = RESULT_ERROR; saveLogEmailFacSVtoSemanal($info); return true; } function sendFacturasVtoSemanal() { $resultInfo=false; getFacturasAVencerSemanal($resultInfo); } function sendReporteFacVtoEmail($listadoFacturas,$emaillst=false) { //---------------------------------------------- //Enviar email //---------------------------------------------- //$clienteInfo = $clienteInfo[0]["cli_email"]; //-----!!!!!!!----- //$email=$email;//TEST!!!! COMENTAR EN PRODUCCION $email="juarezgustavoa@gmail.com";//TEST!!!! COMENTAR EN PRODUCCION //-----!!!!!!!----- $listado=""; /*for($i=0,$t=count($listadoFacturas);$i<$t;$i++) { $item = $listadoFacturas[$i]["sede"]; $item.= " ".$listadoFacturas[$i]["nro"]; $item.= " ".$listadoFacturas[$i]["letra"]; $item.= " ".$listadoFacturas[$i]["cod"]; $item.= " ".$listadoFacturas[$i]["denom"]; $item.= " ".$listadoFacturas[$i]["cuit"]; $item.= " ".$listadoFacturas[$i]["vto"]; $item.= " ".$listadoFacturas[$i]["importe"]; $listado.=$item."
"; }*/ $paramsEmail = array(); $paramsEmail["email"] = $email; $paramsEmail["lst"] = encodeDataB64($listado); $paramsEmail["ini"] = $_REQUEST["fd"]; $paramsEmail["fin"] = $_REQUEST["fh"]; $paramsEmail["total"] = ($listadoFacturas!=''?0:count($listadoFacturas)); $paramsEmail["nombre"] = encodeDataB64("GERENCIA IFER"); //----------------------- //CREAR EL ADJUNTO //----------------------- if($listadoFacturas!='') { $headers = array( "Sede", "Numero", "Letra", "Pro.cod.", "Proveedor", "CUIT", "Fecha Vto.", "Importe $", ); $fileName = $_REQUEST["fname"]; flush(); $spreadsheet = new Spreadsheet(); $activeWorksheet = $spreadsheet->getActiveSheet(); for ($i = 0, $l = sizeof($headers); $i < $l; $i++) { $activeWorksheet->setCellValueByColumnAndRow($i + 1, 1, $headers[$i]); } for ($i = 0, $l = sizeof($listadoFacturas); $i < $l; $i++) { // row $i $j = 0; foreach ($listadoFacturas[$i] as $k => $v) { // column $j $activeWorksheet->setCellValueByColumnAndRow($j + 1, ($i + 1 + 1), $v); $j++; } } $writer = new Xlsx($spreadsheet); //ob_clean(); $writer->save("./repodownload/".$fileName); $paramsEmail["file64"] = base64_encode(file_get_contents($GLOBALS['HOST_BE'].'repodownload/'.$fileName)); $paramsEmail["filename"] = $fileName; } else { } //-------------------------------------- $paramsEmail["subject"] = "REPORTE FACTURAS CTO"; $paramsEmail['customer']= "a340e4bd594ea87bf22c565d838ffc39";//$GLOBALS['WS_WHATSAPP_CUSTOMER'];//SPIDER $paramsEmail['template']= 25; //OBTENER DE LA BASE $paramsEmail['tipo'] = 34; //ENVIO DE LISTADO DE FACTURAS CON VTO //grabarLogErrorAfip($paramsEmail,"ENVIAR_EMAIL_FAC","_enviar_email_params"); $paramsEmail["fromn"] = $GLOBALS['FROMN']; $paramsEmail["from"] = $GLOBALS['FROM']; //print_r($paramsEmail);die(" <<<<<<<<< "); $result = false; try { if($emaillst) { $lst = explode(";",$emaillst); for($i=0;$iformat('Y-m-d'))); $hasta = date("Y-m-d",strtotime($rango[1]->format('Y-m-d'))); } //Proveedor $flagProveedor = false; if( isset($_REQUEST["pro_d"])&&is_numeric($_REQUEST["pro_d"])&&intval($_REQUEST["pro_d"])!==(-1)&& isset($_REQUEST["pro_h"])&&is_numeric($_REQUEST["pro_h"])&&intval($_REQUEST["pro_h"])!==(-1) ) { $flagProveedor = true; } //APLICAR FILTROS $params = " NOT EXISTS(SELECT 1 FROM comp_fact_vtos AS fvto WHERE fvto.faccomp_sede = fvto.faccomp_sede AND cmp.faccomp_nroint = fvto.faccomp_nroint)"; $sep=" AND "; if($params==""){$sep="";} if($flagProveedor) { $params.= $sep ." ( cmp.pr_codigo BETWEEN '".addslashes($_REQUEST["pro_d"])."' AND '".addslashes($_REQUEST["pro_h"])."')"; } $sep=" AND "; if($params==""){$sep="";} if($flagFecha) { $params.= $sep . " ( LEFT(CONVERT(VARCHAR,cmpvto.faccomp_fecvto, 120), 10) BETWEEN LEFT(CONVERT(VARCHAR,'".$desde."', 120), 10) AND LEFT(CONVERT(VARCHAR,'".$hasta."', 120), 10) )"; } //------------------------------ //LISTAR FACTURAS CUYO VENTIMIENTO SE ENCUENTRE DENTRO DE UN RANGO ESPECIFICO //------------------------------ $GLOBALS['dbSQLAgent'] = new DataBaseSQLNew($GLOBALS['MSSQL']['DB_AGENT_HOST'], $GLOBALS['MSSQL']['DB_AGENT_DB_NAME'], $GLOBALS['MSSQL']['DB_AGENT_USER'], $GLOBALS['MSSQL']['DB_AGENT_PASS']); if( !$GLOBALS['dbSQLAgent']->initialize ) { //Error al conectar con la base de datos $continue=false; } if($continue) { $sql = "SELECT cmp.faccomp_sede as sede ,cmp.faccomp_nroint as nro ,cmp.faccomp_letra as letra ,cmp.pr_codigo as cod ,pr.PR_DENOM as denom ,pr.PR_CUIT as cuit ,cmp.faccomp_total as importe FROM comp_facturas as cmp LEFT JOIN proveedores as pr ON pr.pr_codigo = cmp.pr_codigo WHERE ".$params." ORDER BY ".$orderBy; //print_r($sql);die; $rs = $GLOBALS['dbSQLAgent']->Query($sql); if ( $rs ) { $lstfacturas = $GLOBALS['dbSQLAgent']->getAll(); if(is_array($lstfacturas)&&count($lstfacturas)>0) { return $lstfacturas; } else { return EMPTY_LST_OBJ; } } } return false; } catch ( Exception $e ) { $resultInfo['code'] = CODE_RESULT_ERROR_FATAL; $resultInfo['errorDes'] = "Error:".($e->__toString()); //$this->logTrace(debug_backtrace(),$e->__toString()); //print_r($e->__toString()); return false; } } function getFacturasSinVto(&$resultInfo) { if( isset($_REQUEST["token"]) && !empty($_REQUEST["token"]) && !is_null($_REQUEST["token"]) ) { //Validar el Token $defaultErrorMsj=false; $userId=false; $continue = validateToken($_REQUEST["token"],$resultInfo,$defaultErrorMsj,$userId); if( $continue ) { $resultInfo=false; $resultado = listarFacturasSinVto($userId,$resultInfo); if(!isset($_REQUEST["fdw"])) { if( $resultado ) { $resultInfo['code'] = 0; $resultInfo['data'] = array( "total" =>(is_array($resultado)&&count($resultado)>0?count($resultado):0) ,"lst" =>(is_array($resultado)&&count($resultado)>0?$resultado:EMPTY_LST_OBJ) ); return true; } else { $resultInfo=array(); $resultInfo['code'] = 2; $resultInfo['errorDes'] = "SE PRODUJO UN ERROR EN EL SISTEMA AL CONSULTAR LOS COMPROBANTES"; } } elseif(isset($_REQUEST["fdw"])) { if(is_array($resultado)&&count($resultado)>0) { //$data = getFacturasVtoReporte($resultado); $data =$resultado; //print_r($data);die; $headers = array( "Sede", "Numero", "Letra", "Pro.cod.", "Proveedor", "CUIT", "Importe $", ); $fileName = $_REQUEST["fname"]; flush(); $spreadsheet = new Spreadsheet(); $activeWorksheet = $spreadsheet->getActiveSheet(); for ($i = 0, $l = sizeof($headers); $i < $l; $i++) { $activeWorksheet->setCellValueByColumnAndRow($i + 1, 1, $headers[$i]); } for ($i = 0, $l = sizeof($data); $i < $l; $i++) { // row $i $j = 0; foreach ($data[$i] as $k => $v) { // column $j $activeWorksheet->setCellValueByColumnAndRow($j + 1, ($i + 1 + 1), $v); $j++; } } $writer = new Xlsx($spreadsheet); header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment; filename="'. urlencode($fileName).'"'); header("Pragma: no-cache"); header("Expires: 0"); ob_clean(); $writer->save("./repodownload/".$fileName); } } else { $resultInfo['code'] = 2; $resultInfo['errorDes'] = "Parametros Faltantes"; } } } else { $resultInfo['code'] = 1; $resultInfo['errorDes'] = "Parametros Faltantes"; } return true; } // -------------------------------------------- // END - LANDAAGENT // -------------------------------------------- // -------------------------------------------- // OP // -------------------------------------------- // -------------------------------------------- // END - OP // -------------------------------------------- ?>