Startsida Utforska Hjälp
Logga in
pagobo
/
UV_SAIC_CORE
1
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 832c401f6e
Grenar Taggar
UV_SAIC_CORE
/
src
/
main
/
resources
/
templates
/
dataImport.html

dataImport.html 25 KB
Historik Rå

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602 
  1. <!DOCTYPE html>
    2. 

  2. <html xmlns="http://www.w3.org/1999/xhtml"
    3. 

  3. 	xmlns:th="http://www.thymeleaf.org">
    4. 

  4. 

  5. <head th:replace="~{layouts/common.html :: head}"></head>
    6. 

  6. 

  7. <style>
    8. 

  8.       .file-drop-area {
    9. 

  9.         position: relative;
    10. 

  10.         display: flex;
    11. 

  11.         align-items: center;
    12. 

  12.         width: 100%;
    13. 

  13.         min-width: 100%;
    14. 

  14.         max-width: 100%;
    15. 

  15.         padding: 25px;
    16. 

  16.         border: 1px dashed black;
    17. 

  17.         border-radius: 3px;
    18. 

  18.         transition: 0.2s;
    19. 

  19. 

  20.       }
    21. 

  21. 

  22.       .choose-file-button {
    23. 

  23.         flex-shrink: 0;
    24. 

  24.         padding: 8px 15px;
    25. 

  25.         margin-right: 20px;
    26. 

  26.         font-size: 12px;
    27. 

  27.         text-transform: uppercase;
    28. 

  28.         width: 100%;
    29. 

  29.         min-width: 100%;
    30. 

  30.         max-width: 100%;
    31. 

  31.         text-align: center;
    32. 

  32.       }
    33. 

  33. 

  34.       .file-message {
    35. 

  35.         font-size: small;
    36. 

  36.         font-weight: 300;
    37. 

  37.         line-height: 1.4;
    38. 

  38.         white-space: nowrap;
    39. 

  39.         overflow: hidden;
    40. 

  40.         text-overflow: ellipsis;
    41. 

  41.       }
    42. 

  42. 

  43.       .file-input {
    44. 

  44.         position: absolute;
    45. 

  45.         left: 0;
    46. 

  46.         top: 0;
    47. 

  47.         height: 100%;
    48. 

  48.         width: 100%;
    49. 

  49.         cursor: pointer;
    50. 

  50.         opacity: 0;
    51. 

  51. 

  52.       }
    53. 

  53. 

  54.       .mt-100{
    55. 

  55.           margin-top:100px;
    56. 

  56.       }
    57. 

  57. 	
    58. 

  58. </style>
    59. 

  59. 

  60. <body id="page-top">
    61. 

  61. 

  62. 	<!-- Navigation -->
    63. 

  63. 	<nav th:replace="~{layouts/common.html :: navbar}"></nav>
    64. 

  64.  
    65. 

  65.  	<!-- Content -->
    66. 

  66. 	<div class="content uv-content d-flex" id="uv-wrapper">
    67. 

  67. 		<div class="bg-light border-right" id="uv-sidebar-wrapper" th:replace="~{layouts/sidebar.html :: sidebar}"></div>
    68. 

  68. 		
    69. 

  69. 		<div class="container uv-home-section navVisible" id="uv-content-wrapper">
    70. 

  70. 			<div class="uv-loading-spinner" th:text="#{global.loading}"></div>
    71. 

  71. 			<div class="col-sm-12"></div>
    72. 

  72. 			<div class="uv-container">
    73. 

  73. 				<div class="uv-table-group-procedure-info" style="margin-bottom:20px;">
    74. 

  74. 					<div class="uv-table-title">
    75. 

  75. 						<h6 class="uv-table-header-h6" th:text="#{data.import.title}"></h6>
    76. 

  76. 						<hr class="uv-procedure-hr">
    77. 

  77. 						<span th:text="#{data.import.subtitle}"></span><br>
    78. 

  78. 					</div>
    79. 

  79. 				</div>
    80. 

  80. 				<form enctype='multipart/form-data' method="POST" action="/data/import">
    81. 

  81. 					<div class="uv-table-group-procedure row" style="padding:20px;cursor:auto;">
    82. 

  82. 						<div class="col-12 row">
    83. 

  83. 							<div class="col-5" id="databaseContainer">
    84. 

  84. 								<label th:text="#{data.input.source}">Origen</label>
    85. 

  85. 								<select class="selectpicker" id="databaseSelector" name="database" data-live-search="true" data-width="100%" data-actions-box="true" th:attr="data-none-selected-text=#{global.selectors.noData}" required>
    86. 

  86. 							        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    87. 

  87. 							        <option value="grado">Encuestas Grado</option>
    88. 

  88. 							        <option value="master">Encuestas Máster</option>
    89. 

  89. 							        <option value="doctorado">Encuestas Doctorado</option>
    90. 

  90. 							        <option value="pas">Encuestas PAS</option>
    91. 

  91. 							        <option value="evalprof">Encuestas Evaluación Profesorado</option>
    92. 

  92. 							        <option value="otros">Indicadores</option>
    93. 

  93. 							    </select>
    94. 

  94. 							</div>
    95. 

  95. 							<div class="col-5">
    96. 

  96. 								<label th:text="#{data.input.survey}">Encuesta</label>
    97. 

  97. 								<div class="subselect" id="gradoSelector">
    98. 

  98. 									<select class="form-control" name="enquesta" required style="cursor:pointer;">
    99. 

  99. 								        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    100. 

  100. 								        <option value="dades_1er">Estudiantes primero</option>
    101. 

  101. 								        <option value="dades_3er">Estudiantes tercero</option>
    102. 

  102. 								        <option value="dades_graduats">Graduados</option>
    103. 

  103. 								        <option value="profes">Profesores</option>
    104. 

  104. 								    </select>
    105. 

  105. 								</div>
    106. 

  106. 								<div class="subselect" id="masterSelector">
    107. 

  107. 								    <select class="form-control" name="enquesta" required style="cursor:pointer;">
    108. 

  108. 								        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    109. 

  109. 								        <option value="data">Estudiantes</option>
    110. 

  110. 								        <option value="data_g">Graduados</option>
    111. 

  111. 								        <option value="profes_tancades">Profesores</option>
    112. 

  112. 								    </select>
    113. 

  113. 								</div>
    114. 

  114. 								<div class="subselect" id="doctoradoSelector">
    115. 

  115. 								    <select class="form-control" name="enquesta" required style="cursor:pointer;">
    116. 

  116. 								        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    117. 

  117. 								        <option value="doc_estud">Estudiantes</option>
    118. 

  118. 								        <option value="doc_etesi">Graduados</option>
    119. 

  119. 								        <option value="doc_prof">Profesores</option>
    120. 

  120. 								        <option value="doc_tasas">Tasas</option>
    121. 

  121. 								        <option value="doc_inds">Indicadores</option>
    122. 

  122. 								        <option value="doc_recom">Recomendaciones</option>
    123. 

  123. 								    </select>
    124. 

  124. 								</div>
    125. 

  125. 								<div class="subselect" id="evalprofSelector">
    126. 

  126. 								    <select class="form-control" name="enquesta" required style="cursor:pointer;">
    127. 

  127. 								        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    128. 

  128. 								        <option value="evalprof">Evaluación del profesorado</option>
    129. 

  129. 								    </select>
    130. 

  130. 								</div>
    131. 

  131. 								<div class="subselect" id="otrosSelector">
    132. 

  132. 								    <select class="form-control" name="enquesta" required style="cursor:pointer;">
    133. 

  133. 								        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    134. 

  134. 								        <option value="otros">Profesorado + Tasas</option>
    135. 

  135. 								        <option value="docentia">Docentia</option>
    136. 

  136. 								        <option value="enquestes">Encuestas (SAE/SAEM)</option>
    137. 

  137. 										<option value="sprodw">Indicadores</option>
    138. 

  138. 								    </select>
    139. 

  139. 								</div>
    140. 

  140. 								<div class="subselect" id="pasSelector">
    141. 

  141. 								    <select class="form-control" name="enquesta" required style="cursor:pointer;">
    142. 

  142. 								        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    143. 

  143. 								        <option value="dadespas">PAS</option>
    144. 

  144. 								    </select>
    145. 

  145. 								</div>
    146. 

  146. 							</div>
    147. 

  147. 							<div class="col-2">
    148. 

  148. 								<label th:text="#{data.input.year}">Curso</label>
    149. 

  149. 								<input class="form-control" type="number" value="" name="curs">
    150. 

  150. 								<small class="importType importType-db" th:text="#{data.import.note4}">* Solo para consultar</small>
    151. 

  151. 							</div>
    152. 

  152. 						</div>
    153. 

  153. 						<div class="col-12 row" style="margin-top:20px;">
    154. 

  154. 							<div class="col-4">
    155. 

  155. 								<label th:text="#{data.input.scope}">Ámbito</label>
    156. 

  156. 								<select class="form-control" name="ambit" required style="cursor:pointer;">
    157. 

  157. 							        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    158. 

  158. 							        <option value="T" th:text="#{data.input.scope.t}">Titulación</option>
    159. 

  159. 							        <option value="C" th:text="#{data.input.scope.c}">Centro</option>
    160. 

  160. 							        <option value="U" th:text="#{data.input.scope.u}">Universidad</option>
    161. 

  161. 								</select>
    162. 

  162. 							</div>
    163. 

  163. 							<div class="col-4">
    164. 

  164. 								<label th:text="#{data.input.type}">Tipo Titulación</label>
    165. 

  165. 								<select class="form-control" name="estudi" required style="cursor:pointer;">
    166. 

  166. 							        <option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    167. 

  167. 							        <option value="g" th:text="#{data.input.type.g}">Grado</option>
    168. 

  168. 							        <option value="m" th:text="#{data.input.type.m}">Máster</option>
    169. 

  169. 							        <option value="d" th:text="#{data.input.type.d}">Doctorado</option>
    170. 

  170. 							        <option value="u" th:text="#{data.input.type.u}">Global</option>
    171. 

  171. 								</select>
    172. 

  172. 							</div>
    173. 

  173. 							<div class="col-4">
    174. 

  174. 								<label th:text="#{data.input.importType}">Tipo de importación</label>
    175. 

  175. 								<select class="selectpicker" id="importTypeSelector" name="tipus" data-live-search="false" data-width="100%" data-actions-box="true" th:attr="data-none-selected-text=#{global.selectors.noData}" required>
    176. 

  176. 									<option value="file" th:text="#{data.input.importType.file}" selected>Fichero CSV</option>
    177. 

  177. 									<option value="db" th:text="#{data.input.importType.db}">Base de datos</option>
    178. 

  178. 								</select>
    179. 

  179. 								<small th:text="#{data.import.note3}">* Solo para importar</small>
    180. 

  180. 							</div>
    181. 

  181. 						</div>
    182. 

  182. 

  183. 						<div class="col-12 row" style="margin-top:20px;"></div>
    184. 

  184. 							<div class="col-2 importType importType-db">
    185. 

  185. 								<label th:text="'DB Origen'">DB origen</label>
    186. 

  186. 								<select class="form-control" name="dbOrigen" required style="cursor:pointer;">
    187. 

  187. 									<option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    188. 

  188. 									<option th:each="i : ${sources}" th:value="${i.id}" th:text="${i.nom}">
    189. 

  189. 								</select>
    190. 

  190. 								<small th:text="#{data.import.note3}">* Solo para importar</small>
    191. 

  191. 							</div>
    192. 

  192. 							<div class="col-4 importType importType-db">
    193. 

  193. 								<label th:text="#{data.input.view}">Nombre de la vista a importar</label>
    194. 

  194. 								<input class="form-control" type="text" value="" name="vista">
    195. 

  195. 								<small th:text="#{data.import.note3}">* Solo para importar</small>
    196. 

  196. 							</div>
    197. 

  197. 							<div class="col-2 importType importType-file">
    198. 

  198. 								<label th:text="#{data.input.delim}">Delimitador</label>
    199. 

  199. 								<select class="selectpicker" id="delimSelector" name="delim" data-live-search="false" data-width="100%" data-actions-box="true" th:attr="data-none-selected-text=#{global.selectors.noData}" required onchange="fileLoaded();">
    200. 

  200. 									<option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    201. 

  201. 									<option value=";">Punto y coma [ ; ]</option>
    202. 

  202. 									<option value=",">Coma [ , ]</option>
    203. 

  203. 									<option value="\t">Tabulador [ \t ]</option>
    204. 

  204. 								</select>
    205. 

  205. 								<small th:text="#{data.import.note3}">* Solo para importar</small>
    206. 

  206. 							</div>
    207. 

  207. 							<div class="col-2">
    208. 

  208. 								<label th:text="#{data.input.key}">Clave</label>
    209. 

  209. 								<select class="form-control" name="clau" required style="cursor:pointer;">
    210. 

  210. 									<option disabled selected th:text="#{data.input.option}">Selecciona una opción</option>
    211. 

  211. 									<option value="ruct">RUCT</option>
    212. 

  212. 									<option value="cod">Cod. Intern</option>
    213. 

  213. 								</select>
    214. 

  214. 								<small th:text="#{data.import.note3}">* Solo para importar</small>
    215. 

  215. 							</div>
    216. 

  216. 							<div class="col-2 importType importType-db">
    217. 

  217. 								<label th:text="#{data.input.dstyear}">Curso a imputar</label>
    218. 

  218. 								<input class="form-control" type="text" value="" name="dstCurs">
    219. 

  219. 								<small th:text="#{data.import.note3}">* Solo para importar</small>
    220. 

  220. 							</div>
    221. 

  221. 						</div>
    222. 

  222. 

  223. 						<div class="col-12 row importType importType-file" style="margin-top:20px;">
    224. 

  224. 							<div class="tab-pane fade show active tab_item" style="width: 100%;min-width: 100%;max-width: 100%;">
    225. 

  225. 					            <div class="file-drop-area">
    226. 

  226. 					              <span class="filename choose-file-button" th:text="#{data.input.file}">Selecciona o suelta aquí el archivo CSV</span>
    227. 

  227. 					              <input class="file-input" type="file" name="file" id="filecsv">
    228. 

  228. 					            </div>
    229. 

  229. 					        </div>
    230. 

  230. 				        </div>
    231. 

  231. 				        <div>
    232. 

  232. 					        * <small th:text="#{data.import.note1}"> El fichero debe de contener las columnas "titulacio", "centre" y "tipus".</small>
    233. 

  233. 					        <br/>
    234. 

  234. 					        ** <small th:text="#{data.import.note2}"> Las columnas "titulacio" y "centre" deben de ser numéricas. La columna "tipus" puede ser "avg", "min" o "max".</small>
    235. 

  235. 				        </div>
    236. 

  236. 					</div>
    237. 

  237. 					<div id="fileInfoContainer" class="uv-table-group-procedure" style="padding-left:20px;cursor:auto;">
    238. 

  238. 					
    239. 

  239. 					</div>
    240. 

  240. 					<div class="uv-table-group-procedure" style="padding-left:20px;padding-top:20px;cursor:auto;">
    241. 

  241. 						<span id="btn-checkConn" class="btn btn-primary pointer" onclick="listTableColumns();"><i class="fas fa-plug"></i> <span th:text="#{data.btn.connect}">Comprobar conexión</span></span>
    242. 

  242. 						<button id="btn-import" class="btn btn-primary pointer" type="submit" value="Importar"><i class="fas fa-upload"></i> <span th:text="#{data.btn.import}">Importar</span></button>
    243. 

  243. 						<span class="btn btn-info pointer" onclick="showData();"><i class="fas fa-eye"></i> <span th:text="#{data.btn.show}">Ver</span></span>
    244. 

  244. 						<!-- <span class="btn btn-success pointer" onclick="checkData();"><i class="fas fa-clipboard-check"></i> <span th:text="#{data.btn.check}">Comprobar</span></span>  -->
    245. 

  245. 						<span class="btn btn-danger pointer" onclick="removeData();" style="float:right;margin-right:30px;"><i class="fas fa-trash"></i> <span th:text="#{data.btn.delete}">Eliminar</span></span>
    246. 

  246. 					</div>
    247. 

  247. 				</form>
    248. 

  248. 				<div id="resultsContainer" class="uv-table-group-procedure" style="padding-left:20px;padding-top:20px;cursor:auto;">
    249. 

  249. 					
    250. 

  250. 				</div>
    251. 

  251. 			</div>
    252. 

  252. 		</div>
    253. 

  253. 	</div>
    254. 

  254. 	
    255. 

  255. 	<!-- contactModal -->
    256. 

  256. 	<div th:replace="~{layouts/common.html :: contactModal}"></div>
    257. 

  257. 	
    258. 

  258. 	<!-- Footer -->
    259. 

  259. 	<footer class="uv-footer uv-footer-text" th:replace="~{layouts/common.html :: footer}"></footer>
    260. 

  260. 	
    261. 

  261. 	<script th:src="@{/js/jquery/jquery.min.js}"></script>
    262. 

  262. 	<script th:src="@{/js/popper.js}"></script>
    263. 

  263. 	<script th:src="@{/js/bootstrap/bootstrap.min.js}"></script>
    264. 

  264. 	<script th:src="@{/js/fa/all.js}"></script>
    265. 

  265. 	<script th:src="@{/js/jquery/jquery.dataTables.min.js}"></script>
    266. 

  266. 	<script th:src="@{/js/jquery/jquery.dataTables.responsive.min.js}"></script>
    267. 

  267. 	<script th:src="@{/js/jquery/jquery.dataTables.rowReorder.min.js}"></script>
    268. 

  268. 	<script th:src="@{/js/bootstrap/dataTables.bootstrap4.min.js}"></script>
    269. 

  269. 	<script th:src="@{/js/jquery-easing/jquery.easing.min.js}"></script>
    270. 

  270. 	<script th:src="@{/js/saic.js}"></script>
    271. 

  271. 	<script th:src="@{/js/datepicker/bootstrap-datepicker.min.js}"></script>
    272. 

  272. 	<script th:src="@{/js/bootstrap-select/bootstrap-select.js}"></script>
    273. 

  273. 	<script th:src="@{/js/bootstrap-select/i18n/defaults-es_ES.js}" th:if="${#locale.language} == 'es'"></script>
    274. 

  274. 	<script th:src="@{/js/bootstrap-select/i18n/defaults-ca_CA.js}" th:if="${#locale.language} != 'es'"></script>
    275. 

  275. 	
    276. 

  276. 	<script type="text/javascript">
    277. 

  277. 

  278. 		var locale = '[[${#locale.language}]]';
    279. 

  279. 		var orderCol1 = [3, 'asc'], orderCol2 = [1, 'asc'];
    280. 

  280. 		var cursorPosition;
    281. 

  281. 		var reader = new FileReader();
    282. 

  282. 		var tabParams = {
    283. 

  283. 				paging: true, 
    284. 

  284. 				language:{
    285. 

  285. 					"lengthMenu": "[[#{admin.stats.table.lengthMenu}]]", 
    286. 

  286. 		            "zeroRecords": "[[#{admin.stats.table.zeroRecords}]]",
    287. 

  287. 		            "info": "[[#{admin.stats.table.info}]]",
    288. 

  288. 		            "infoEmpty": "[[#{admin.stats.table.infoEmpty}]]",
    289. 

  289. 		            "infoFiltered": "[[#{admin.stats.table.infoFiltered}]]",
    290. 

  290. 		            "paginate": {
    291. 

  291. 		                "previous": "[[#{admin.stats.table.previous}]]",
    292. 

  292. 		                "next": "[[#{admin.stats.table.next}]]"
    293. 

  293. 		            }
    294. 

  294. 				},
    295. 

  295. 				searching: true,
    296. 

  296. 				order:[orderCol1, orderCol2],
    297. 

  297. 				orderCellsTop: true,
    298. 

  298. 				//fixedHeader: true, // Not compatible with android
    299. 

  299. 				info: false,
    300. 

  300. 				scrollX: true,
    301. 

  301. 				responsive: false,
    302. 

  302. 				initComplete: function () {
    303. 

  303. 					var api = this.api();
    304. 

  304. 		        	this.api()
    305. 

  305. 		        	.columns()
    306. 

  306. 	                .eq(0)
    307. 

  307. 	                .each(function (colIdx) {
    308. 

  308. 	                    var cell = $('.filters th').eq(
    309. 

  309. 	                        $(api.column(colIdx).header()).index()
    310. 

  310. 	                    );
    311. 

  311. 	                    var title = $(cell).text();
    312. 

  312. 	                    $(cell).html('<input type="text" placeholder="' + title + '" />');
    313. 

  313. 	                    $('input', $('.filters th').eq($(api.column(colIdx).header()).index()))
    314. 

  314. 	                        .off('keyup change')
    315. 

  315. 	                        .on('change', function (e) {
    316. 

  316. 	                            $(this).attr('title', $(this).val());
    317. 

  317. 	                            var regexr = '({search})'; 
    318. 

  318. 	                            cursorPosition = this.selectionStart;
    319. 

  319. 	                            api.column(colIdx)
    320. 

  320. 	                               .search(   
    321. 

  321. 	                                    this.value != ''
    322. 

  322. 	                                        ? regexr.replace('{search}', '(((' + this.value + ')))')	
    323. 

  323. 	                                        : '',
    324. 

  324. 	                                    this.value != '',
    325. 

  325. 	                                    this.value == ''
    326. 

  326. 	                                )
    327. 

  327. 	                                .draw();
    328. 

  328. 	                        })
    329. 

  329. 	                        .on('keyup', function (e) {
    330. 

  330. 								e.preventDefault();
    331. 

  331. 	                            e.stopPropagation();
    332. 

  332. 	                            $(this).trigger('change');
    333. 

  333. 	                            $(this)
    334. 

  334. 	                                .focus()[0]
    335. 

  335. 	                                .setSelectionRange(cursorPosition, cursorPosition);
    336. 

  336. 	                        });
    337. 

  337. 	                });
    338. 

  338. 		        	$('.table').DataTable().draw();
    339. 

  339. 	    		}
    340. 

  340. 			};
    341. 

  341. 	
    342. 

  342. 		
    343. 

  343. 		$(document).ready(function(){ 
    344. 

  344. 			layout = new Layout("");
    345. 

  345. 			layout.initTableLayout({paging:false});
    346. 

  346. 			layout.closeLoadingSpinner(".uv-loading-spinner");
    347. 

  347. 			$('.subselect').hide();
    348. 

  348. 			$('#btn-checkConn').hide();
    349. 

  349. 			$('.subselect  > select').attr('disabled', true);
    350. 

  350. 			
    351. 

  351. 			$('#databaseSelector').change(function(){
    352. 

  352. 				$('.subselect').hide();
    353. 

  353. 				$('.subselect > select').attr('disabled', true);
    354. 

  354. 				$('#'+$(this).val()+'Selector  > select').attr('disabled', false);
    355. 

  355. 				$('#'+$(this).val()+'Selector').show();
    356. 

  356. 			});
    357. 

  357. 

  358. 			$('#importTypeSelector').change(function(){
    359. 

  359. 				$('.importType').hide();
    360. 

  360. 				$('.importType-'+$(this).val()).show();
    361. 

  361. 				if($(this).val() == 'file'){
    362. 

  362. 					$('#btn-import').attr('disabled', false);
    363. 

  363. 					$('#btn-checkConn').hide();
    364. 

  364. 				}
    365. 

  365. 				else{
    366. 

  366. 					$('#btn-import').attr('disabled', true);
    367. 

  367. 					$('#btn-checkConn').show();
    368. 

  368. 				}
    369. 

  369. 			});
    370. 

  370. 

  371. 			$('#importTypeSelector').trigger('change');
    372. 

  372. 			
    373. 

  373. 			reader.addEventListener("loadend", fileLoaded);
    374. 

  374. 			
    375. 

  375. 			$("#filecsv").change(function(){
    376. 

  376. 				$(".filename").text(this.files[0].name);
    377. 

  377. 				reader.readAsText(document.getElementById('filecsv').files[0]);
    378. 

  378. 			});
    379. 

  379. 			
    380. 

  380. 			
    381. 

  381. 			$("form").submit(function (event) {
    382. 

  382. 				event.preventDefault();
    383. 

  383. 				event.stopPropagation();
    384. 

  384. 				if($('#importTypeSelector').val() == 'file'){
    385. 

  385. 					if($('#filecsv').val().trim().length == 0 ||
    386. 

  386. 						$('select[name="database"] option:not([disabled]):selected').length == 0 ||
    387. 

  387. 						$('select[name="enquesta"] option:not([disabled]):selected').length == 0 ||
    388. 

  388. 						$('select[name="delim"] option:not([disabled]):selected').length == 0 ||
    389. 

  389. 						$('select[name="ambit"] option:not([disabled]):selected').length == 0 ||
    390. 

  390. 						$('select[name="estudi"] option:not([disabled]):selected').length == 0){
    391. 

  391. 							alert("Falta rellenar campos obligatorios");
    392. 

  392. 							hideSpinner();
    393. 

  393. 							return false;
    394. 

  394. 					}
    395. 

  395. 				}
    396. 

  396. 				else{ 
    397. 

  397. 					if($('select[name="database"] option:not([disabled]):selected').length == 0 ||
    398. 

  398. 						$('select[name="enquesta"] option:not([disabled]):selected').length == 0 ||
    399. 

  399. 						$('select[name="ambit"] option:not([disabled]):selected').length == 0 ||
    400. 

  400. 						$('select[name="estudi"] option:not([disabled]):selected').length == 0 || 
    401. 

  401. 						$('select[name="dbOrigen"] option:not([disabled]):selected').length == 0 ||
    402. 

  402. 						$('input[name="curs"]').val().length == 0 ||
    403. 

  403. 						$('input[name="vista"]').val().length == 0){
    404. 

  404. 							alert("Falta rellenar campos obligatorios");
    405. 

  405. 							hideSpinner();
    406. 

  406. 							return false;
    407. 

  407. 					}
    408. 

  408. 				}
    409. 

  409. 				showSpinner();
    410. 

  410. 				var ignoredColumns = [];
    411. 

  411. 				$("input:checkbox:not(:checked)").each(function(i){
    412. 

  412. 					ignoredColumns.push($(this).val());
    413. 

  413. 				});
    414. 

  414. 				var data = new FormData(this);
    415. 

  415. 				data.append('ignoredColumns', ignoredColumns);
    416. 

  416. 				$.ajax({
    417. 

  417. 					type: "POST",
    418. 

  418. 					enctype: 'multipart/form-data',
    419. 

  419. 					contentType: false,
    420. 

  420. 					url: $(this).attr('action'),
    421. 

  421. 					processData: false,
    422. 

  422. 					cache: false,
    423. 

  423. 					data: data,
    424. 

  424. 				})
    425. 

  425. 				.done(function (d) {
    426. 

  426. 					console.log(d);
    427. 

  427. 					var t = d.replace(/\[INFO\]/g, '<span style="color:green;">[INFO]</span>')
    428. 

  428. 							 .replace(/\[ERROR\]/g, '<span style="color:red;">[ERROR]</span>')
    429. 

  429. 							 .replace(/\[WARNING\]/g, '<span style="color:orange;">[WARNING]</span>');
    430. 

  430. 					$('#resultsContainer').html(t);
    431. 

  431. 					window.scrollTo(0, document.body.scrollHeight);
    432. 

  432. 				})
    433. 

  433. 				.fail( function(xhr, textStatus, errorThrown) {
    434. 

  434. 					$('#resultsContainer').html('<span style="color:red;">[ERROR] Se ha producido un error en la importación.</span>');
    435. 

  435. 					window.scrollTo(0, document.body.scrollHeight);
    436. 

  436. 				});
    437. 

  437. 			});
    438. 

  438. 			
    439. 

  439. 		});
    440. 

  440. 		
    441. 

  441. 		function fileLoaded(){
    442. 

  442. 			if(reader.result == null){
    443. 

  443. 				return false;
    444. 

  444. 			}
    445. 

  445. 			var header = reader.result.split('\n')[0];
    446. 

  446. 			var colsArr = header.split($('select[name="delim"]').val());
    447. 

  447. 			var cols = '[[#{data.import.note5}]] <br> <div class="row">';
    448. 

  448. 			colsArr.forEach(function(d){
    449. 

  449. 				var v = d.replaceAll('"', '');
    450. 

  450. 				cols += `<div class="col-3" style="text-align:left;">
    451. 

  451. 						 	<input type="checkbox" checked name="filecolumns" value="${v}"/> ${v}
    452. 

  452. 						 </div>`;
    453. 

  453. 			});
    454. 

  454. 			$('#fileInfoContainer').html(cols);
    455. 

  455. 		}
    456. 

  456. 		
    457. 

  457. 		function removeData(){
    458. 

  458. 			showSpinner();	
    459. 

  459. 			$.post("/data/delete", {enquesta:$('select[name="enquesta"]:enabled').val(), 
    460. 

  460. 								    curs:$('input[name="curs"]').val(), 
    461. 

  461. 								    ambit:$('select[name="ambit"]').val(), 
    462. 

  462. 								    estudi:$('select[name="estudi"]').val()})
    463. 

  463. 				.done(function(d) {
    464. 

  464. 					var t = d.replace('[INFO]', '<span style="color:green;">[INFO]</span>')
    465. 

  465. 	    			 .replace('[ERROR]', '<span style="color:red;">[ERROR]</span>')
    466. 

  466. 	    			 .replace('[WARNING]', '<span style="color:orange;">[WARNING]</span>');
    467. 

  467. 	    			$('#resultsContainer').html(t);
    468. 

  468. 	    			window.scrollTo(0, document.body.scrollHeight);
    469. 

  469. 				}
    470. 

  470. 			);
    471. 

  471. 		}
    472. 

  472. 		
    473. 

  473. 		function showSpinner(){
    474. 

  474. 			var spinner = `<div class="d-flex justify-content-center" style="position:fixed;z-index:9999;top:0;left:0;right:0;bottom:0;margin:auto;width:100%;height:100%;background:rgba(0,0,0,0.25);align-items: center;justify-content:center;">
    475. 

  475. 								<div class="spinner-border text-primary" role="status" style="font-size:150%;text-align:center;width:100px;height:100px;display:flex;margin:0 auto;">
    476. 

  476. 									<span class="sr-only">Loading...</span>
    477. 

  477. 								</div>
    478. 

  478. 							</div>
    479. 

  479. 						  `;
    480. 

  480. 			$('#resultsContainer').html(spinner);
    481. 

  481. 		}
    482. 

  482. 

  483. 		function hideSpinner(){
    484. 

  484. 			$('#resultsContainer').html('');
    485. 

  485. 		}
    486. 

  486. 

  487. 		function listTableColumns(){
    488. 

  488. 

  489. 			if($('select[name="database"] option:not([disabled]):selected').length == 0 ||
    490. 

  490. 				$('select[name="enquesta"] option:not([disabled]):selected').length == 0 ||
    491. 

  491. 				$('select[name="ambit"] option:not([disabled]):selected').length == 0 ||
    492. 

  492. 				$('select[name="estudi"] option:not([disabled]):selected').length == 0 || 
    493. 

  493. 				$('select[name="dbOrigen"] option:not([disabled]):selected').length == 0 ||
    494. 

  494. 				$('input[name="curs"]').val().length == 0 ||
    495. 

  495. 				$('input[name="vista"]').val().length == 0){
    496. 

  496. 					alert("Falta rellenar campos obligatorios");
    497. 

  497. 					hideSpinner();
    498. 

  498. 					return false;
    499. 

  499. 			}
    500. 

  500. 

  501. 			showSpinner();
    502. 

  502. 			$.post("/data/view/columns", {vista:$('input[name="vista"]').val(), 
    503. 

  503. 										  dbOrigen:$('select[name="dbOrigen"]').val()})
    504. 

  504. 				.done(function(data) {
    505. 

  505. 					console.log(data);
    506. 

  506. 					if(data.length == 0){
    507. 

  507. 						$('#btn-import').attr('disabled', true);
    508. 

  508. 						alert('[[#{data.alert.connect}]]');
    509. 

  509. 					}
    510. 

  510. 					else{
    511. 

  511. 						$('#btn-import').attr('disabled', false);
    512. 

  512. 						var cols = '[[#{data.import.note5}]] <br> <div class="row">';
    513. 

  513. 						data.forEach(function(d){
    514. 

  514. 							var v = d.replaceAll('"', '');
    515. 

  515. 							cols += `<div class="col-3" style="text-align:left;">
    516. 

  516. 										<input type="checkbox" checked name="filecolumns" value="${v}"/> ${v}
    517. 

  517. 									</div>`;
    518. 

  518. 						});
    519. 

  519. 						$('#fileInfoContainer').html(cols);
    520. 

  520. 					}
    521. 

  521. 					$('#resultsContainer').html('');
    522. 

  522. 				}
    523. 

  523. 			);
    524. 

  524. 		}
    525. 

  525. 		
    526. 

  526. 		function showData(){
    527. 

  527. 			showSpinner();
    528. 

  528. 			$.post("/data/show", {enquesta:$('select[name="enquesta"]:enabled').val(), 
    529. 

  529. 								  curs:$('input[name="curs"]').val(), 
    530. 

  530. 								  ambit:$('select[name="ambit"]').val(), 
    531. 

  531. 								  estudi:$('select[name="estudi"]').val()})
    532. 

  532. 				.done(function(data) {
    533. 

  533. 					var trs = '';
    534. 

  534. 					data.forEach(function(d){
    535. 

  535. 						trs += `
    536. 

  536. 							<tr>
    537. 

  537. 								<td>${d.titulacio}</td>
    538. 

  538. 								<td>${d.centre}</td>
    539. 

  539. 							    <td>${d.ambit}</td>
    540. 

  540. 							    <td>${d.tipus}</td>
    541. 

  541. 							    <td>${d.indicador}</td>
    542. 

  542. 							    <td>${d.valor}</td>
    543. 

  543. 							    <td>${d.nenq}</td>
    544. 

  544. 							    <td>${d.titulacioOrigen}</td>
    545. 

  545. 							    <td>${d.centreOrigen}</td>
    546. 

  546. 							    <td>${d.ruct}</td>
    547. 

  547. 							    <td>${d.usuari}</td>
    548. 

  548. 						  	</tr>
    549. 

  549. 						`;
    550. 

  550. 					});
    551. 

  551. 					
    552. 

  552. 					$('#resultsContainer').html(`
    553. 

  553. 							<div class="uv-table-group-procedure" style="margin-bottom:25px;">
    554. 

  554. 								<table class="table table-striped table-bordered display responsive no-wrap">
    555. 

  555. 									<thead>
    556. 

  556. 										<tr>
    557. 

  557. 											<th class="uv-table">[[#{data.table.1}]]</th>
    558. 

  558. 										  	<th class="uv-table">[[#{data.table.2}]]</th>
    559. 

  559. 										  	<th class="uv-table">[[#{data.table.3}]]</th>
    560. 

  560. 										  	<th class="uv-table">[[#{data.table.4}]]</th>
    561. 

  561. 										  	<th class="uv-table">[[#{data.table.5}]]</th>
    562. 

  562. 										  	<th class="uv-table">[[#{data.table.6}]]</th>
    563. 

  563. 										  	<th class="uv-table">[[#{data.table.7}]]</th>
    564. 

  564. 										  	<th class="uv-table">[[#{data.table.8}]]</th>
    565. 

  565. 										  	<th class="uv-table">[[#{data.table.9}]]</th>
    566. 

  566. 										  	<th class="uv-table">[[#{data.table.10}]]</th>
    567. 

  567. 										  	<th class="uv-table">[[#{data.table.11}]]</th>
    568. 

  568. 										</tr>
    569. 

  569. 									</thead>
    570. 

  570. 									<tbody>
    571. 

  571. 									  ${trs}
    572. 

  572. 									</tbody>
    573. 

  573. 								</table>
    574. 

  574. 							</div>
    575. 

  575. 					`);
    576. 

  576. 					
    577. 

  577. 					$('.table thead tr').clone(true)
    578. 

  578. 								        .addClass('filters')
    579. 

  579. 								        .appendTo('.table thead');
    580. 

  580. 					
    581. 

  581. 					$('.table').DataTable({
    582. 

  582. 						searching: tabParams.searching, 
    583. 

  583. 						paging: tabParams.paging, 
    584. 

  584. 						orderCellsTop: tabParams.orderCellsTop,
    585. 

  585. 						// fixedHeader: tabParams.fixedHeader, // Not compatible with Android
    586. 

  586. 						info: tabParams.info,
    587. 

  587. 				        responsive: tabParams.responsive,
    588. 

  588. 				        order: tabParams.order,
    589. 

  589. 				        scrollX: tabParams.scrollX,
    590. 

  590. 				        "language": ((!("language" in tabParams)) ? { "emptyTable": this.emptyMsg } : tabParams.language),
    591. 

  591. 				        initComplete: tabParams.initComplete
    592. 

  592. 					});
    593. 

  593. 					
    594. 

  594. 				}
    595. 

  595. 			);
    596. 

  596. 		}
    597. 

  597. 		
    598. 

  598. 	</script>
    599. 

  599. 

  600. </body>
    601. 

  601. 

  602. </html>
    603.