chamilo /
chamilo-lms
| Conditions | 52 |
| Paths | 134 |
| Total Lines | 487 |
| Code Lines | 361 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 750 | public function obtenerAccion($obtenerAccionInput) |
||
| 751 | { |
||
| 752 | /* Tracking Log */ |
||
| 753 | $tableLog = Database::get_main_table('plugin_sepe_log'); |
||
| 754 | $paramsLog = [ |
||
| 755 | 'ip' => $_SERVER['REMOTE_ADDR'], |
||
| 756 | 'action' => "obtenerAccion", |
||
| 757 | 'fecha' => date("Y-m-d H:i:s"), |
||
| 758 | ]; |
||
| 759 | Database::insert($tableLog, $paramsLog); |
||
| 760 | |||
| 761 | /* End tracking log */ |
||
| 762 | |||
| 763 | $actionOrigin = $obtenerAccionInput->ID_ACCION->ORIGEN_ACCION; |
||
| 764 | $actionCode = $obtenerAccionInput->ID_ACCION->CODIGO_ACCION; |
||
| 765 | |||
| 766 | if (empty($actionOrigin) || empty($actionCode)) { |
||
| 767 | return [ |
||
| 768 | "RESPUESTA_OBT_ACCION" => [ |
||
| 769 | "CODIGO_RETORNO" => "2", |
||
| 770 | "ETIQUETA_ERROR" => "Error en parametro", |
||
| 771 | "ACCION_FORMATIVA" => "", |
||
| 772 | ], |
||
| 773 | ]; |
||
| 774 | } |
||
| 775 | |||
| 776 | $table = Database::get_main_table('plugin_sepe_actions'); |
||
| 777 | $tableCenters = Database::get_main_table('plugin_sepe_centers'); |
||
| 778 | $classRoomTable = Database::get_main_table('plugin_sepe_specialty_classroom'); |
||
| 779 | $tutorTable = Database::get_main_table('plugin_sepe_tutors'); |
||
| 780 | $specialityTutorTable = Database::get_main_table('plugin_sepe_specialty_tutors'); |
||
| 781 | $participantsSpecialityTable = Database::get_main_table('plugin_sepe_participants_specialty'); |
||
| 782 | $participantsSpecialityTutorialsTable = Database::get_main_table('plugin_sepe_participants_specialty_tutorials'); |
||
| 783 | $tableTutorsCompany = Database::get_main_table('plugin_sepe_tutors_company'); |
||
| 784 | |||
| 785 | $actionOrigin = Database::escape_string($actionOrigin); |
||
| 786 | $actionCode = Database::escape_string($actionCode); |
||
| 787 | |||
| 788 | // Comprobamos si existen datos almacenados previamente |
||
| 789 | $sql = "SELECT * |
||
| 790 | FROM $table |
||
| 791 | WHERE |
||
| 792 | action_origin='".$actionOrigin."' AND |
||
| 793 | action_code='".$actionCode."';"; |
||
| 794 | $rs = Database::query($sql); |
||
| 795 | if (Database::num_rows($rs) > 0) { |
||
| 796 | $row = Database::fetch_assoc($rs); |
||
| 797 | $mainSpecialty = [ |
||
| 798 | 'ORIGEN_ESPECIALIDAD' => $row['specialty_origin'], |
||
| 799 | 'AREA_PROFESIONAL' => $row['professional_area'], |
||
| 800 | 'CODIGO_ESPECIALIDAD' => $row['specialty_code'], |
||
| 801 | ]; |
||
| 802 | $actionDescription = [ |
||
| 803 | 'DENOMINACION_ACCION' => $row['action_name'], |
||
| 804 | 'INFORMACION_GENERAL' => $row['global_info'], |
||
| 805 | 'HORARIOS' => $row['schedule'], |
||
| 806 | 'REQUISITOS' => $row['requirements'], |
||
| 807 | 'CONTACTO_ACCION' => $row['contact_action'], |
||
| 808 | ]; |
||
| 809 | |||
| 810 | $tableSpeciality = Database::get_main_table('plugin_sepe_specialty'); |
||
| 811 | $tableParticipants = Database::get_main_table('plugin_sepe_participants'); |
||
| 812 | $sql = "SELECT * FROM $tableSpeciality |
||
| 813 | WHERE action_id ='".$row['id']."'"; |
||
| 814 | $rs = Database::query($sql); |
||
| 815 | $specialty = []; |
||
| 816 | if (Database::num_rows($rs) > 0) { |
||
| 817 | while ($aux = Database::fetch_assoc($rs)) { |
||
| 818 | $specialtyId = $aux['id']; |
||
| 819 | $sql = "SELECT * FROM $classRoomTable |
||
| 820 | WHERE specialty_id='".$specialtyId."'"; |
||
| 821 | $resultClassroom = Database::query($sql); |
||
| 822 | if (Database::num_rows($resultClassroom) === 0) { |
||
| 823 | return [ |
||
| 824 | "RESPUESTA_OBT_ACCION" => [ |
||
| 825 | "CODIGO_RETORNO" => "-1", |
||
| 826 | "ETIQUETA_ERROR" => "Problema base de datos - consulta de centros presenciales", |
||
| 827 | "ACCION_FORMATIVA" => '', |
||
| 828 | ], |
||
| 829 | ]; |
||
| 830 | } |
||
| 831 | |||
| 832 | $classroomCenterList = new ArrayObject(); |
||
| 833 | while ($tmp = Database::fetch_assoc($resultClassroom)) { |
||
| 834 | $sql = "SELECT * FROM $tableCenters WHERE id='".$tmp['center_id']."';"; |
||
| 835 | $resultCenter = Database::query($sql); |
||
| 836 | $auxCenter = Database::fetch_assoc($resultCenter); |
||
| 837 | |||
| 838 | $classroomCenter = new stdClass(); |
||
| 839 | $classroomCenter->ORIGEN_CENTRO = $auxCenter['center_origin']; |
||
| 840 | $classroomCenter->CODIGO_CENTRO = $auxCenter['center_code']; |
||
| 841 | $classroomCenter = new SoapVar( |
||
| 842 | $classroomCenter, |
||
| 843 | SOAP_ENC_OBJECT, |
||
| 844 | null, |
||
| 845 | null, |
||
| 846 | 'CENTRO_PRESENCIAL' |
||
| 847 | ); |
||
| 848 | $classroomCenterList->append($classroomCenter); |
||
| 849 | } |
||
| 850 | $sql = "SELECT * FROM $specialityTutorTable |
||
| 851 | WHERE specialty_id='".$specialtyId."'"; |
||
| 852 | $resultSpecialtyTutor = Database::query($sql); |
||
| 853 | |||
| 854 | $trainingTutors = new ArrayObject(); |
||
| 855 | if (Database::num_rows($resultSpecialtyTutor)) { |
||
| 856 | while ($tmp_aux = Database::fetch_assoc($resultSpecialtyTutor)) { |
||
| 857 | $sql = "SELECT * FROM $tutorTable |
||
| 858 | WHERE id='".$tmp_aux['tutor_id']."' |
||
| 859 | LIMIT 1"; |
||
| 860 | $rs_tutor = Database::query($sql); |
||
| 861 | if (Database::num_rows($rs_tutor)) { |
||
| 862 | $tmp = Database::fetch_assoc($rs_tutor); |
||
| 863 | |||
| 864 | $obj = new stdClass(); |
||
| 865 | $obj->ID_TUTOR = new stdClass(); |
||
| 866 | $obj->ID_TUTOR->TIPO_DOCUMENTO = $tmp['document_type']; |
||
| 867 | $obj->ID_TUTOR->NUM_DOCUMENTO = $tmp['document_number']; |
||
| 868 | $obj->ID_TUTOR->LETRA_NIF = $tmp['document_letter']; |
||
| 869 | |||
| 870 | $obj->ACREDITACION_TUTOR = $tmp_aux['tutor_accreditation']; |
||
| 871 | $obj->EXPERIENCIA_PROFESIONAL = $tmp_aux['professional_experience']; |
||
| 872 | $obj->COMPETENCIA_DOCENTE = $tmp_aux['teaching_competence']; |
||
| 873 | $obj->EXPERIENCIA_MODALIDAD_TELEFORMACION = $tmp_aux['experience_teleforming']; |
||
| 874 | $obj->FORMACION_MODALIDAD_TELEFORMACION = $tmp_aux['training_teleforming']; |
||
| 875 | |||
| 876 | $obj = new SoapVar($obj, SOAP_ENC_OBJECT, null, null, 'TUTOR_FORMADOR'); |
||
| 877 | $trainingTutors->append($obj); |
||
| 878 | } |
||
| 879 | } |
||
| 880 | } |
||
| 881 | |||
| 882 | $params = new ArrayObject(); |
||
| 883 | $idEspecialidad = new stdClass(); |
||
| 884 | $idEspecialidad->ORIGEN_ESPECIALIDAD = $aux['specialty_origin']; |
||
| 885 | $idEspecialidad->AREA_PROFESIONAL = $aux['professional_area']; |
||
| 886 | $idEspecialidad->CODIGO_ESPECIALIDAD = $aux['specialty_code']; |
||
| 887 | |||
| 888 | $params[0] = new SoapVar( |
||
| 889 | $idEspecialidad, |
||
| 890 | SOAP_ENC_OBJECT, |
||
| 891 | null, |
||
| 892 | null, |
||
| 893 | 'ID_ESPECIALIDAD', |
||
| 894 | null |
||
| 895 | ); |
||
| 896 | |||
| 897 | $centroImparticion = new stdClass(); |
||
| 898 | $centroImparticion->ORIGEN_CENTRO = $aux['center_origin']; |
||
| 899 | $centroImparticion->CODIGO_CENTRO = $aux['center_code']; |
||
| 900 | |||
| 901 | $params[1] = new SoapVar( |
||
| 902 | $centroImparticion, |
||
| 903 | SOAP_ENC_OBJECT, |
||
| 904 | null, |
||
| 905 | null, |
||
| 906 | 'CENTRO_IMPARTICION', |
||
| 907 | null |
||
| 908 | ); |
||
| 909 | $params[2] = new SoapVar( |
||
| 910 | self::undoFixDate($aux['start_date']), |
||
| 911 | XSD_STRING, |
||
| 912 | null, |
||
| 913 | null, |
||
| 914 | 'FECHA_INICIO', |
||
| 915 | null |
||
| 916 | ); |
||
| 917 | $params[3] = new SoapVar( |
||
| 918 | self::undoFixDate($aux['end_date']), |
||
| 919 | XSD_STRING, |
||
| 920 | null, |
||
| 921 | null, |
||
| 922 | 'FECHA_FIN', |
||
| 923 | null |
||
| 924 | ); |
||
| 925 | $params[4] = new SoapVar( |
||
| 926 | $aux['modality_impartition'], |
||
| 927 | XSD_STRING, |
||
| 928 | null, |
||
| 929 | null, |
||
| 930 | 'MODALIDAD_IMPARTICION', |
||
| 931 | null |
||
| 932 | ); |
||
| 933 | |||
| 934 | $obj = new stdClass(); |
||
| 935 | $obj->HORAS_PRESENCIAL = $aux['classroom_hours']; |
||
| 936 | $obj->HORAS_TELEFORMACION = $aux['distance_hours']; |
||
| 937 | |||
| 938 | $params[5] = new SoapVar( |
||
| 939 | $obj, |
||
| 940 | SOAP_ENC_OBJECT, |
||
| 941 | null, |
||
| 942 | null, |
||
| 943 | 'DATOS_DURACION', |
||
| 944 | null |
||
| 945 | ); |
||
| 946 | $params[6] = new SoapVar( |
||
| 947 | $classroomCenterList, |
||
| 948 | SOAP_ENC_OBJECT, |
||
| 949 | null, |
||
| 950 | null, |
||
| 951 | 'CENTROS_SESIONES_PRESENCIALES', |
||
| 952 | null |
||
| 953 | ); |
||
| 954 | $params[7] = new SoapVar( |
||
| 955 | $trainingTutors, |
||
| 956 | SOAP_ENC_OBJECT, |
||
| 957 | null, |
||
| 958 | null, |
||
| 959 | 'TUTORES_FORMADORES', |
||
| 960 | null |
||
| 961 | ); |
||
| 962 | |||
| 963 | $obj = new stdClass(); |
||
| 964 | |||
| 965 | if (!empty($aux['mornings_participants_number']) || |
||
| 966 | !empty($aux['mornings_access_number']) || |
||
| 967 | !empty($aux['morning_total_duration']) |
||
| 968 | ) { |
||
| 969 | $obj->HORARIO_MANANA = new stdClass(); |
||
| 970 | $obj->HORARIO_MANANA->NUM_PARTICIPANTES = $aux['mornings_participants_number']; |
||
| 971 | $obj->HORARIO_MANANA->NUMERO_ACCESOS = $aux['mornings_access_number']; |
||
| 972 | $obj->HORARIO_MANANA->DURACION_TOTAL = $aux['morning_total_duration']; |
||
| 973 | } |
||
| 974 | |||
| 975 | if (!empty($aux['afternoon_participants_number']) || |
||
| 976 | !empty($aux['afternoon_access_number']) || |
||
| 977 | !empty($aux['afternoon_total_duration']) |
||
| 978 | ) { |
||
| 979 | $obj->HORARIO_TARDE = new stdClass(); |
||
| 980 | $obj->HORARIO_TARDE->NUM_PARTICIPANTES = $aux['afternoon_participants_number']; |
||
| 981 | $obj->HORARIO_TARDE->NUMERO_ACCESOS = $aux['afternoon_access_number']; |
||
| 982 | $obj->HORARIO_TARDE->DURACION_TOTAL = $aux['afternoon_total_duration']; |
||
| 983 | } |
||
| 984 | |||
| 985 | if (!empty($aux['night_participants_number']) || |
||
| 986 | !empty($aux['night_access_number']) || |
||
| 987 | !empty($aux['night_total_duration']) |
||
| 988 | ) { |
||
| 989 | $obj->HORARIO_NOCHE = new stdClass(); |
||
| 990 | $obj->HORARIO_NOCHE->NUM_PARTICIPANTES = $aux['night_participants_number']; |
||
| 991 | $obj->HORARIO_NOCHE->NUMERO_ACCESOS = $aux['night_access_number']; |
||
| 992 | $obj->HORARIO_NOCHE->DURACION_TOTAL = $aux['night_total_duration']; |
||
| 993 | } |
||
| 994 | |||
| 995 | if (!empty($aux['attendees_count']) || |
||
| 996 | !empty($aux['learning_activity_count']) || |
||
| 997 | !empty($aux['attempt_count']) || |
||
| 998 | !empty($aux['evaluation_activity_count']) |
||
| 999 | ) { |
||
| 1000 | $obj->SEGUIMIENTO_EVALUACION = new stdClass(); |
||
| 1001 | $obj->SEGUIMIENTO_EVALUACION->NUM_PARTICIPANTES = $aux['attendees_count']; |
||
| 1002 | $obj->SEGUIMIENTO_EVALUACION->NUMERO_ACTIVIDADES_APRENDIZAJE = $aux['learning_activity_count']; |
||
| 1003 | $obj->SEGUIMIENTO_EVALUACION->NUMERO_INTENTOS = $aux['attempt_count']; |
||
| 1004 | $obj->SEGUIMIENTO_EVALUACION->NUMERO_ACTIVIDADES_EVALUACION = $aux['evaluation_activity_count']; |
||
| 1005 | } |
||
| 1006 | |||
| 1007 | $params[8] = new SoapVar( |
||
| 1008 | $obj, |
||
| 1009 | SOAP_ENC_OBJECT, |
||
| 1010 | null, |
||
| 1011 | null, |
||
| 1012 | 'USO', |
||
| 1013 | null |
||
| 1014 | ); |
||
| 1015 | $specialty[] = new SoapVar( |
||
| 1016 | $params, |
||
| 1017 | SOAP_ENC_OBJECT, |
||
| 1018 | null, |
||
| 1019 | null, |
||
| 1020 | 'ESPECIALIDAD' |
||
| 1021 | ); |
||
| 1022 | } |
||
| 1023 | } else { |
||
| 1024 | return [ |
||
| 1025 | "RESPUESTA_OBT_ACCION" => [ |
||
| 1026 | "CODIGO_RETORNO" => "-1", |
||
| 1027 | "ETIQUETA_ERROR" => "Problema base de datos - consulta especialidad de accion", |
||
| 1028 | "ACCION_FORMATIVA" => '', |
||
| 1029 | ], |
||
| 1030 | ]; |
||
| 1031 | } |
||
| 1032 | |||
| 1033 | $sql = "SELECT * FROM $tableParticipants |
||
| 1034 | WHERE action_id ='".$row['id']."'"; |
||
| 1035 | $resultParticipants = Database::query($sql); |
||
| 1036 | $specialtyMainParticipant = []; |
||
| 1037 | if (Database::num_rows($resultParticipants)) { |
||
| 1038 | while ($aux = Database::fetch_assoc($resultParticipants)) { |
||
| 1039 | $participantId = $aux['id']; |
||
| 1040 | |||
| 1041 | $sql = "SELECT * FROM $participantsSpecialityTable |
||
| 1042 | WHERE participant_id='".$participantId."'"; |
||
| 1043 | $resultParticipantSpecialty = Database::query($sql); |
||
| 1044 | |||
| 1045 | $namespace = null; |
||
| 1046 | $specialtyParticipant = []; |
||
| 1047 | while ($tmp = Database::fetch_assoc($resultParticipantSpecialty)) { |
||
| 1048 | $participantSpecialtyId = $tmp['id']; |
||
| 1049 | $sql = "SELECT * FROM $participantsSpecialityTutorialsTable |
||
| 1050 | WHERE participant_specialty_id='".$participantSpecialtyId."'"; |
||
| 1051 | $resultTutorials = Database::query($sql); |
||
| 1052 | $classroomTutorials = new ArrayObject(); |
||
| 1053 | |||
| 1054 | while ($tmp2 = Database::fetch_assoc($resultTutorials)) { |
||
| 1055 | $obj = new stdClass(); |
||
| 1056 | $obj->CENTRO_PRESENCIAL_TUTORIA = new stdClass(); |
||
| 1057 | $obj->CENTRO_PRESENCIAL_TUTORIA->ORIGEN_CENTRO = $tmp2['center_origin']; |
||
| 1058 | $obj->CENTRO_PRESENCIAL_TUTORIA->CODIGO_CENTRO = $tmp2['center_code']; |
||
| 1059 | $startDate = self::undoFixDate($tmp2['start_date']); |
||
| 1060 | if (!empty($startDate)) { |
||
| 1061 | $obj->FECHA_INICIO = $startDate; |
||
| 1062 | } |
||
| 1063 | $endDate = self::undoFixDate($tmp2['end_date']); |
||
| 1064 | if (!empty($endDate)) { |
||
| 1065 | $obj->FECHA_FIN = $endDate; |
||
| 1066 | } |
||
| 1067 | |||
| 1068 | $obj = new SoapVar( |
||
| 1069 | $obj, |
||
| 1070 | SOAP_ENC_OBJECT, |
||
| 1071 | null, |
||
| 1072 | null, |
||
| 1073 | 'TUTORIA_PRESENCIAL' |
||
| 1074 | ); |
||
| 1075 | $classroomTutorials->append($obj); |
||
| 1076 | } |
||
| 1077 | |||
| 1078 | $obj = new stdClass(); |
||
| 1079 | $obj->ID_ESPECIALIDAD = new stdClass(); |
||
| 1080 | $obj->ID_ESPECIALIDAD->ORIGEN_ESPECIALIDAD = $tmp['specialty_origin']; |
||
| 1081 | $obj->ID_ESPECIALIDAD->AREA_PROFESIONAL = $tmp['professional_area']; |
||
| 1082 | $obj->ID_ESPECIALIDAD->CODIGO_ESPECIALIDAD = $tmp['specialty_code']; |
||
| 1083 | |||
| 1084 | $registrationDate = self::undoFixDate($tmp['registration_date']); |
||
| 1085 | |||
| 1086 | // @todo check which is correct send 0000/00/00 or empty |
||
| 1087 | if (!empty($registrationDate)) { |
||
| 1088 | $obj->FECHA_ALTA = $registrationDate; |
||
| 1089 | } |
||
| 1090 | |||
| 1091 | $leavingDate = self::undoFixDate($tmp['leaving_date']); |
||
| 1092 | if (!empty($leavingDate)) { |
||
| 1093 | $obj->FECHA_BAJA = $leavingDate; |
||
| 1094 | } |
||
| 1095 | |||
| 1096 | $obj->TUTORIAS_PRESENCIALES = new SoapVar( |
||
| 1097 | $classroomTutorials, |
||
| 1098 | SOAP_ENC_OBJECT, |
||
| 1099 | null, |
||
| 1100 | null, |
||
| 1101 | 'TUTORIAS_PRESENCIALES', |
||
| 1102 | null |
||
| 1103 | ); |
||
| 1104 | $obj->EVALUACION_FINAL = new stdClass(); |
||
| 1105 | |||
| 1106 | if (!empty($tmp['center_origin']) && !empty($tmp['center_code'])) { |
||
| 1107 | $obj->EVALUACION_FINAL->CENTRO_PRESENCIAL_EVALUACION = new stdClass(); |
||
| 1108 | $obj->EVALUACION_FINAL->CENTRO_PRESENCIAL_EVALUACION->ORIGEN_CENTRO = $tmp['center_origin']; |
||
| 1109 | $obj->EVALUACION_FINAL->CENTRO_PRESENCIAL_EVALUACION->CODIGO_CENTRO = $tmp['center_code']; |
||
| 1110 | } |
||
| 1111 | |||
| 1112 | $startDate = self::undoFixDate($tmp['start_date']); |
||
| 1113 | if (!empty($startDate)) { |
||
| 1114 | $obj->EVALUACION_FINAL->FECHA_INICIO = $startDate; |
||
| 1115 | } |
||
| 1116 | |||
| 1117 | $endDate = self::undoFixDate($tmp['end_date']); |
||
| 1118 | |||
| 1119 | if (!empty($endDate)) { |
||
| 1120 | $obj->EVALUACION_FINAL->FECHA_FIN = $endDate; |
||
| 1121 | } |
||
| 1122 | |||
| 1123 | $obj->RESULTADOS = new stdClass(); |
||
| 1124 | |||
| 1125 | if (isset($tmp['final_result']) && $tmp['final_result'] != '') { |
||
| 1126 | $obj->RESULTADOS->RESULTADO_FINAL = $tmp['final_result']; |
||
| 1127 | } |
||
| 1128 | if (isset($tmp['final_qualification']) && $tmp['final_qualification'] != '') { |
||
| 1129 | $obj->RESULTADOS->CALIFICACION_FINAL = $tmp['final_qualification']; |
||
| 1130 | } |
||
| 1131 | |||
| 1132 | if (isset($tmp['final_score']) && $tmp['final_score'] != '') { |
||
| 1133 | $obj->RESULTADOS->PUNTUACION_FINAL = $tmp['final_score']; |
||
| 1134 | } |
||
| 1135 | $specialtyParticipant[] = new SoapVar( |
||
| 1136 | $obj, |
||
| 1137 | SOAP_ENC_OBJECT, |
||
| 1138 | null, |
||
| 1139 | null, |
||
| 1140 | 'ESPECIALIDAD' |
||
| 1141 | ); |
||
| 1142 | } |
||
| 1143 | |||
| 1144 | $params = new stdClass(); |
||
| 1145 | $params->ID_PARTICIPANTE = new stdClass(); |
||
| 1146 | $params->ID_PARTICIPANTE->TIPO_DOCUMENTO = $aux['document_type']; |
||
| 1147 | $params->ID_PARTICIPANTE->NUM_DOCUMENTO = $aux['document_number']; |
||
| 1148 | $params->ID_PARTICIPANTE->LETRA_NIF = $aux['document_letter']; |
||
| 1149 | $params->INDICADOR_COMPETENCIAS_CLAVE = $aux['key_competence']; |
||
| 1150 | |||
| 1151 | $params->CONTRATO_FORMACION = new stdClass(); |
||
| 1152 | |||
| 1153 | if (!empty($aux['contract_id'])) { |
||
| 1154 | $params->CONTRATO_FORMACION->ID_CONTRATO_CFA = $aux['contract_id']; |
||
| 1155 | } |
||
| 1156 | |||
| 1157 | if (!empty($aux['company_fiscal_number'])) { |
||
| 1158 | $params->CONTRATO_FORMACION->CIF_EMPRESA = $aux['company_fiscal_number']; |
||
| 1159 | } |
||
| 1160 | |||
| 1161 | if (!empty($aux['company_tutor_id'])) { |
||
| 1162 | $resultCompany = Database::query("SELECT * FROM $tableTutorsCompany WHERE id='".$aux['company_tutor_id']."';"); |
||
| 1163 | $auxCompany = Database::fetch_assoc($resultCompany); |
||
| 1164 | if (!empty($auxCompany['document_type']) || |
||
| 1165 | !empty($auxCompany['document_number']) || |
||
| 1166 | !empty($auxCompany['document_letter']) |
||
| 1167 | ) { |
||
| 1168 | $params->CONTRATO_FORMACION->ID_TUTOR_EMPRESA = new stdClass(); |
||
| 1169 | $params->CONTRATO_FORMACION->ID_TUTOR_EMPRESA->TIPO_DOCUMENTO = $auxCompany['document_type']; |
||
| 1170 | $params->CONTRATO_FORMACION->ID_TUTOR_EMPRESA->NUM_DOCUMENTO = $auxCompany['document_number']; |
||
| 1171 | $params->CONTRATO_FORMACION->ID_TUTOR_EMPRESA->LETRA_NIF = $auxCompany['document_letter']; |
||
| 1172 | } |
||
| 1173 | } |
||
| 1174 | if (!empty($aux['training_tutor_id'])) { |
||
| 1175 | $resultTraining = Database::query("SELECT * FROM $tableTutorsCompany WHERE id='".$aux['training_tutor_id']."';"); |
||
| 1176 | $auxTraining = Database::fetch_assoc($resultTraining); |
||
| 1177 | if (!empty($auxTraining['document_type']) || |
||
| 1178 | !empty($auxTraining['document_number']) || |
||
| 1179 | !empty($auxTraining['document_letter']) |
||
| 1180 | ) { |
||
| 1181 | $params->CONTRATO_FORMACION->ID_TUTOR_FORMACION = new stdClass(); |
||
| 1182 | $params->CONTRATO_FORMACION->ID_TUTOR_FORMACION->TIPO_DOCUMENTO = $auxTraining['document_type']; |
||
| 1183 | $params->CONTRATO_FORMACION->ID_TUTOR_FORMACION->NUM_DOCUMENTO = $auxTraining['document_number']; |
||
| 1184 | $params->CONTRATO_FORMACION->ID_TUTOR_FORMACION->LETRA_NIF = $auxTraining['document_letter']; |
||
| 1185 | } |
||
| 1186 | } |
||
| 1187 | |||
| 1188 | $params->ESPECIALIDADES_PARTICIPANTE = new SoapVar( |
||
| 1189 | $specialtyParticipant, |
||
| 1190 | SOAP_ENC_OBJECT, |
||
| 1191 | null, |
||
| 1192 | null, |
||
| 1193 | 'ESPECIALIDADES_PARTICIPANTE' |
||
| 1194 | ); |
||
| 1195 | $specialtyMainParticipant[] = new SoapVar( |
||
| 1196 | $params, |
||
| 1197 | SOAP_ENC_OBJECT, |
||
| 1198 | null, |
||
| 1199 | null, |
||
| 1200 | 'PARTICIPANTE' |
||
| 1201 | ); |
||
| 1202 | } |
||
| 1203 | } |
||
| 1204 | |||
| 1205 | $result = new stdClass(); |
||
| 1206 | |||
| 1207 | $result->RESPUESTA_OBT_ACCION = new stdClass(); |
||
| 1208 | $result->RESPUESTA_OBT_ACCION->CODIGO_RETORNO = 0; |
||
| 1209 | $result->RESPUESTA_OBT_ACCION->ETIQUETA_ERROR = 'Correcto'; |
||
| 1210 | |||
| 1211 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA = new stdClass(); |
||
| 1212 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->ID_ACCION = new stdClass(); |
||
| 1213 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->ID_ACCION->ORIGEN_ACCION = $actionOrigin; |
||
| 1214 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->ID_ACCION->CODIGO_ACCION = $actionCode; |
||
| 1215 | |||
| 1216 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->SITUACION = $row['situation']; |
||
| 1217 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->ID_ESPECIALIDAD_PRINCIPAL = $mainSpecialty; |
||
| 1218 | |||
| 1219 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->DURACION = $row['duration']; |
||
| 1220 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->FECHA_INICIO = self::undoFixDate($row['start_date']); |
||
| 1221 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->FECHA_FIN = self::undoFixDate($row['end_date']); |
||
| 1222 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->IND_ITINERARIO_COMPLETO = $row['full_itinerary_indicator']; |
||
| 1223 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->TIPO_FINANCIACION = $row['financing_type']; |
||
| 1224 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->NUMERO_ASISTENTES = $row['attendees_count']; |
||
| 1225 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->DESCRIPCION_ACCION = $actionDescription; |
||
| 1226 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->ESPECIALIDADES_ACCION = $specialty; |
||
| 1227 | $result->RESPUESTA_OBT_ACCION->ACCION_FORMATIVA->PARTICIPANTES = $specialtyMainParticipant; |
||
| 1228 | |||
| 1229 | return $result; |
||
| 1230 | } else { |
||
| 1231 | // Existe la accion |
||
| 1232 | return [ |
||
| 1233 | "RESPUESTA_OBT_ACCION" => [ |
||
| 1234 | "CODIGO_RETORNO" => "1", |
||
| 1235 | "ETIQUETA_ERROR" => "Acción inexistente", |
||
| 1236 | "ACCION_FORMATIVA" => "", |
||
| 1237 | ], |
||
| 1375 |
Loading history...