Marle
/
webAdministracion
Слідкувати 1
В обрані 0
Форк 0
Код Проблеми 0 Запити на злиття 0 Релізи 0 Вікі Активність
Без опису
13 Коміти
1 Гілка
Гілка: master
Гілки Теги
${ item.name }
Створити гілку ${ searchTerm }
з 'master'
${ noResults }
webAdministracion/viewExperience.php

viewExperience.php 56KB
Постійне посилання Історія Неформатований

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593 
  1. <?php

  2. 

  3. 	// Description: EXTRACT EXPERIENCE ID, AND IF VALID, DISPLAY ITS INFO

  4. 

  5. 	require_once 'processes/config.php';

  6. 	require_once 'processes/dbh.inc.php';

  7. 	require_once 'processes/checkLogin.php';

  8. 

  9. 	// IF VIEW VARIABLE NOT GIVEN, EXIT

  10. 	if(!isset($_GET['view'])) {

  11. 		exit();

  12. 	}

  13. 

  14. 	// FETCH EXPERIENCE

  15. 	$experienceID = mysqli_real_escape_string($connection, trim($_GET['view'])); 

  16. 	$query1 = "SELECT * FROM `experience` WHERE `id` = '$experienceID';";

  17. 	$result1 = mysqli_query($connection, $query1) or die("Error: ".mysqli_error($connection));

  18. 	$row1 = mysqli_fetch_array($result1);

  19. 	

  20. 	// IF EXPERIENCE NOT IN DATABASE, EXIT

  21. 	if($result1->num_rows !== 1) {

  22. 		echo "Requested experience does not exist.";

  23. 		exit();

  24. 	}

  25. 	

  26. 	// IF EXPERIENCE DOESN'T BELONG TO USER (WHO IS NOT AN ADMIN), EXIT

  27. 	if($_SESSION['dbUserData']['admin'] !== '1') {

  28. 	

  29. 		$queryCheckUser = "SELECT id FROM experience WHERE id = '$experienceID' AND id IN (SELECT id_experience FROM researcher_experience WHERE id_researcher = '" . $_SESSION['dbUserData']['id_researcher'] . "');";

  30. 		if(mysqli_query($connection, $queryCheckUser)->num_rows === 0) {

  31. 			echo "You are not authorized to view this experience.";

  32. 			exit();

  33. 		}

  34. 		

  35. 	}

  36. 	

  37. 	// FETCH EXPERIENCE'S PROJECT ID

  38. 	$queryProject = "SELECT id_project FROM project_experience WHERE id_experience = '$experienceID';";

  39. 	$resultProject = mysqli_query($connection, $queryProject);

  40. 	$rowProject = mysqli_fetch_assoc($resultProject);

  41. 

  42. 

  43. 	// FETCH NUMBER OF STUDENTS ENROLLED IN EXPERIENCE

  44. 	$queryTotalStudents = "SELECT * FROM student_participate_experience WHERE id_experience = '$experienceID'";

  45. 	$resultTotalStudents = mysqli_query($connection, $queryTotalStudents);

  46. 	$studentCount = $resultTotalStudents->num_rows;

  47. 

  48. 

  49. 	include_once 'header.php';

  50. 	

  51. ?>

  52. 	<!--START OF viewExperience.php -->

  53. 	<body>

  54. 	

  55.     	<header id="main-header">

  56.         	<a id="logo" href=".">

  57. 				TANIA

  58.             	<img src="./img/pen_800x800.png" alt="tania logo pen" width="25" height="25">

  59.         	</a>

  60.         	<div id="account">

  61.         		<a class="nav-link" style="margin-right: 1rem;" href="./home.php"><i class="fas fa-arrow-left"></i> Back</a>

  62.             	<a class="sign-out" href="./processes/logout.php">Sign Out</a>

  63.         	</div>

  64.     	</header>

  65. 		

  66. 		<div class="container-fluid" id="view-experience-showcase">

  67. 			<div class="row">

  68. 				<div class="col-sm-12">

  69.         	

  70.         			<h2><?php echo $row1['title']; ?></h2>

  71.         			<div class="row">

  72.         			

  73.         				<div class="col-sm-7 col-md-8 col-lg-9">

  74.         		

  75.         		    		<blockquote style="color:rgb(216,216,216); margin: 0;">

  76. 								<h4><b style="color:#fff;">Description:</b> <span style="color:rgb(216,216,216);"><?php echo $row1['description']; ?></span></h4>

  77. 								<h4><b style="color:#fff;">Type:</b> <span style="color:rgb(216,216,216);"><?php echo $row1['type']; ?></span></h4>

  78. 								<h4><b style="color:#fff;">Duration:</b> <span style="color:rgb(216,216,216);"><?php echo $row1['duration_weeks']; ?> week<?php if((int)$row1['duration_weeks'] > 1) echo "s"; ?></span></h4>

  79. 								<h4><b style="color:#fff;">Participants Enrolled:</b> <span style="color:rgb(216,216,216);"><?php echo $studentCount; ?></span></h4>

  80. 							</blockquote>

  81.             	

  82. 						</div><!--col-->

  83.             	

  84.             	

  85. 						<div class="col-sm-5 col-md-4 col-lg-3">

  86.             		

  87. 							<div id="view-experience-buttons">

  88. 								<div data-toggle="tooltip" data-placement="top" title="View Results" id="experience-pen" onclick="window.location='respuestas.php?exp=<?php echo $experienceID; ?>'">

  89. 									<span class="fas fa-poll-h"></span>

  90. 								</div>

  91. 								<div data-toggle="tooltip" data-placement="top" title="Edit Experience" id="experience-pen" onclick="nextModal('#Edit')">

  92. 									<span class="fas fa-pen"></span>

  93. 								</div>

  94. 								<div data-toggle="tooltip" data-placement="top" title="Share Experience" id="experience-pen" onclick="prompt('Press Ctrl + C to copy to clipboard!','https://tania.uprrp.edu/enrollInExp.php?id=<?php echo $row1['hash_id']; ?>')">

  95. 									<span class="fas fa-link"></span>

  96. 								</div>

  97. 							</div>

  98.             	

  99.           			  	</div><!--col-->

  100.           			  	

  101.         			</div><!--row-->

  102.         	

  103. 		        	<br>

  104.         	

  105.         			<div class="row hidden-xs" id="view-experience-tabs">

  106. 						<a class="active" href="#calendar">Calendar</a>

  107. 						<a href="#questionnaires">Questionnaires</a>

  108. 						<a href="#moments">Moments</a>

  109. 						<a href="#milestones">Milestones</a>

  110. 					</div><!--row-->

  111.         	

  112.         		</div><!--col-->

  113.         	</div><!--row-->

  114.     	</div><!--container-->

  115. 	

  116. 		<br>

  117. 			

  118. 		<!-- CALENDAR-->

  119. 		<div id="calendar" class="main-content-box show hidden-xs">

  120. 			<div class="container">

  121. 		

  122. 				<div class="row">

  123. 					<h3 class="col-sm-12">

  124. 						Schedule Your Experience

  125. 						<button type="button" class="btn btn-link btn-lg" data-toggle="popover" title="Calendar Tips" data-content="Drag and drop existing events to change their dates. Toggle month & week views for finer control." data-placement="bottom">

  126. 							<span class="glyphicon glyphicon-question-sign" aria-hidden="true"></span>

  127. 						</button>

  128. 					</h3>

  129. 				</div><!--row-->

  130. 			

  131. 				<br>

  132. 			

  133. 				<div class="row">

  134. 					<div class="col-sm-12">

  135. 						<div id="actualCalendar"></div>

  136. 					</div>

  137. 				</div>

  138. 			

  139. 				<br><br><br><br>

  140. 			

  141. 			</div><!--container-->

  142. 		</div>

  143. 			

  144. 			

  145. 			

  146. 		<!--QUESTIONNAIRES-->

  147. 		<div id="questionnaires" class="main-content-box">

  148. 			<div class="container">

  149. 		

  150. 				<div class="row">

  151. 					<h3 class="col-xs-7 col-sm-9 col-md-9">Active Questionnaires</h3>

  152. 					<div class="col-xs-5 col-sm-3 col-md-3">

  153. 						<!-- 

  154. <span data-toggle="modal" data-target="#Import" style="margin-right: 1em;">

  155. 							<button type="button" class="btn btn-lg btn-default" data-toggle="tooltip" data-placement="top" title="Import Questionnaire">

  156. 								<span class="glyphicon glyphicon-open-file"></span>

  157. 							</button>

  158. 						</span>

  159. 						<span data-toggle="modal" data-target="#Duplicate">

  160. 							<button type="button" class="btn btn-lg btn-default" data-toggle="tooltip" data-placement="top" title="Duplicate Questionnaire">

  161. 								<span class="glyphicon glyphicon-paste"></span>

  162. 							</button>

  163. 						</span>

  164.  -->

  165. 							<div id="view-experience-buttons">

  166. 								<div data-toggle="tooltip" data-placement="top" title="Import Questionnaire" id="experience-pen" onclick="nextModal('#Import')" style="padding: 0.5em; margin: 0 auto; width: 60px;">

  167. 									<span class="fas fa-file-import"></span>

  168. 								</div>

  169. 								<div data-toggle="tooltip" data-placement="top" title="Duplicate Questionnaire" id="experience-pen" onclick="nextModal('#Duplicate')" style="padding: 0.5em; margin: 0 auto; width: 60px;">

  170. 									<span class="fas fa-copy"></span>

  171. 								</div>

  172. 							</div>

  173. 					</div>

  174. 				</div><!--row-->

  175. 				

  176. 				<br>

  177. 								

  178. 				<div class="row">

  179. 				

  180. 					<div class="col-sm-12">

  181. 						<?php

  182. 						

  183.   							$query2 = "SELECT * FROM questionnair WHERE `id` IN (SELECT `id_questionnair` FROM experience_questionnair WHERE `id_experience` = '$experienceID');";

  184. 							$result2 = mysqli_query($connection, $query2);

  185. 							

  186. 							// IF THE EXPERIENCE HAS AT LEAST ONE QUESTIONNAIRE ASSOCIATED TO IT, SHOW IT

  187. 							// ELSE, DISPLAY A MESSAGE TO THE USER LETTING THEM KNOW THEY DON'T HAVE ONE

  188. 							if(mysqli_num_rows($result2) > 0):

  189. 							

  190. 						?>

  191. 						<table class="table table-hover table-striped table-responsive">

  192.   							<thead>

  193.   								<tr>

  194.   									<th style="text-align: center;"><h4>Questionnaire</h4></th>

  195.   									<th style="text-align: center;"><h4>Questions</h4></th>

  196.   								</tr>

  197.   							</thead>

  198.   							<tbody>

  199.   								<?php while($row2 = mysqli_fetch_assoc($result2)): ?>

  200.   								<tr style="cursor: pointer;" onclick="location='viewQuestionnaire.php?view=<?php echo $row2['id']?>'">

  201.   									<td style="text-align: center;"><h5><?php echo $row2['q_title']; ?></h5></td>

  202.   									<?php

  203.   										$query3 = "SELECT * FROM questionnair_question WHERE id_questionnair = ".$row2['id'];

  204.   										$result3 = mysqli_query($connection, $query3);

  205.   									?>

  206.   									<td style="text-align: center;"><h5><?php echo mysqli_num_rows($result3); ?></h5></td>

  207.   								</tr>

  208.   								<?php endwhile; ?>

  209. 							</tbody>

  210.   						</table>

  211. 

  212.     					<?php else: ?>

  213.   							<h3 class="text-center"><small>It seems you still haven't added a questionnaire to this experience...</small></h3>

  214.   						<?php endif; ?>

  215.   						 

  216.   						<br>

  217.   						<div class="row">

  218.   							<div class="col-sm-2 col-sm-offset-5">

  219.   								<div data-toggle="tooltip" data-placement="top" title="Create Questionnaire" onclick="nextModal('#NewQuestionnaire')" id="experience-pen" style="padding: 0.5em; margin: 0 auto; width: 60px;">

  220.   									<span class="fas fa-plus"></span>

  221.   								</div>

  222.   							</div>

  223.   						</div>

  224.   						

  225.   					</div><!--col-sm-12-->

  226.   					

  227.   				</div><!--row-->

  228.  

  229. 				<br><br>

  230. 			

  231. 				<div class="row">	

  232. 					<div class="col-sm-offset-2 col-sm-8">	

  233. 						<div class="alert alert-warning alert-dismisible mb-1 hidden-xs" role="alert">

  234. 							<button type="button" class="close" data-dismiss="alert" aria-label="Close">

  235. 								<span aria-hidden="true">&times;</span>

  236. 							</button>

  237. 							<h4>Tips on Questionnaires</h4>

  238. 							<hr>

  239. 							<ul>

  240. 								<li>These are the questionnaires that are associated to this experience.</li>

  241. 								<br>

  242. 								<li>Once you have your questionnaire, you can create your moments.</li>

  243. 								<br>

  244. 								<li>You can create new questionnaires with the plus button...

  245. 									<ul>

  246. 										<li>or import questionnaires from an Excel file!</li>

  247. 										<li>or copy a questionnaire from one experience to another!</li>

  248. 									</ul>

  249. 								</li>

  250. 								<br>

  251. 							</ul>

  252. 						</div><!--alert-->

  253. 					</div><!--col-sm-8-->

  254. 				</div><!--row-->

  255.   			

  256.   				<br>

  257.   			

  258.   			</div><!--container-->

  259.   		

  260. 		</div>

  261. 			

  262. 			

  263. 			

  264. 		<!--MOMENTS-->

  265. 		<div id="moments" class="main-content-box">

  266. 			<div class="container">

  267. 			

  268. 				<div class="row">

  269. 					<h3 class="col-sm-12">Active Moments</h3>

  270. 				</div>

  271. 				

  272. 				

  273. 				<div class="row">

  274. 				

  275. 				

  276. 					<div class="col-sm-12">

  277. 						<?php

  278. 						

  279. //   							$query4 = "SELECT * FROM subquestionnair WHERE `id_questionnair` IN (SELECT `id_questionnair` FROM experience_questionnair WHERE `id_experience` = '$experienceID') ORDER BY date_to_administer ASC;";

  280.   							$query4 = "SELECT SQ.* FROM subquestionnair AS SQ JOIN experience_subquestionnair AS ES WHERE SQ.id = ES.id_subquestionnair AND ES.id_experience = '$experienceID' ORDER BY SQ.date_to_administer ASC;";

  281. 							$result4 = mysqli_query($connection, $query4);

  282. 							

  283. 							// IF THE EXPERIENCE HAS AT LEAST ONE MOMENT ASSOCIATED TO IT, SHOW IT

  284. 							// ELSE, DISPLAY A MESSAGE TO THE USER LETTING THEM KNOW THEY DON'T HAVE ONE

  285. 							if(mysqli_num_rows($result4) > 0):

  286. 							

  287. 

  288. 								

  289. 						?>

  290. 						<table class="table table-hover table-striped table-responsive">

  291.   							<thead>

  292.   								<tr>

  293.   									<th style="text-align: center;"><h4>Moment</h4></th>

  294.   									<th style="text-align: center;"><h4>Questions</h4></th>

  295.   									<th style="text-align: center;"><h4>Date</h4></th>

  296.   									<th style="text-align: center;"><h4>Answer Rate</h4></th>

  297.   								</tr>

  298.   							</thead>

  299.   							<tbody>

  300.   								<?php while($row4 = mysqli_fetch_assoc($result4)): ?>

  301.   								<tr style="cursor: pointer;" onclick="location='viewMoment.php?view=<?php echo $row4['id']; ?>'">

  302.   									<td style="text-align: center;"><h5><?php echo $row4['title']; ?></h5></td>

  303.   									<?php

  304.   										$query5 = "SELECT * FROM subquestionnair_question WHERE `id_subquestionnair` = ".$row4['id'];

  305.   										$result5 = mysqli_query($connection, $query5);

  306.   									?>

  307.   									<td style="text-align: center;"><h5><?php echo mysqli_num_rows($result5); ?></h5></td>

  308. 									<td style="text-align: center;"><h5><?php echo date("M j, Y (g:i A)", strtotime($row4['date_to_administer'])); ?></h5></td>

  309. 									

  310. 									<?php if($studentCount === 0): ?>

  311. 									

  312. 									<td style="text-align: center;"><h5 class="text-danger">Register students!</h5></td>

  313. 									

  314. 									<?php elseif(strtotime($row4['date_to_administer']) > strtotime('now')): ?>

  315. 									

  316. 									<td style="text-align: center;"><h5 class="text-warning">Still not sent</h5></td>

  317. 									

  318. 									<?php

  319. 									else:

  320. 										$queryAnswers = "SELECT * FROM student_subquestionnair WHERE id_subquestionnair = '" . $row4['id'] . "';";

  321. 										$resultAnswers = mysqli_query($connection, $queryAnswers);

  322. 										$answerCount = $resultAnswers->num_rows;

  323. 									?>

  324. 									

  325. 									<td style="text-align: center;"><h5 class="text-muted"><?php echo "$answerCount out of $studentCount"; ?></h5></td>

  326. 									

  327. 									<?php endif; ?>

  328.   								</tr>

  329.   								<?php endwhile; ?>

  330.   							</tbody>

  331.   						</table>

  332.   					

  333.     					<?php else: ?>

  334.  						<h3 class="text-center"><small>It seems you still haven't added any moments to this experience...</small></h3>

  335.   						<?php endif; ?>

  336.   							 

  337.   						<br>

  338.   					

  339.   						<div class="row">

  340.   							<div class="col-sm-2 col-sm-offset-5">

  341.   								<div data-toggle="tooltip" data-placement="top" title="Create Moment" onclick="nextModal('#NewMoment')" id="experience-pen" style="padding: 0.5em; margin: 0 auto; width: 60px;">

  342.   									<span class="fas fa-plus"></span>

  343.   								</div>

  344.   							</div>

  345.   						</div>

  346.   						

  347.   						

  348.   					</div><!--col-sm-12-->

  349.   				

  350.   				</div><!--row-->

  351. 

  352.   			

  353. 				<br><br>

  354. 				

  355. 				<div class="row">

  356. 					<div class="col-sm-offset-2 col-sm-8">

  357. 						<div class="alert alert-warning alert-dismisible mb-1 hidden-xs" role="alert">

  358. 							<button type="button" class="close" data-dismiss="alert" aria-label="Close">

  359. 								<span aria-hidden="true">&times;</span>

  360. 							</button>

  361. 							<h4>Tips on Moments</h4>

  362. 							<hr>

  363. 							<ul>

  364. 								<li>These are the moments that are associated to this experience.</li>

  365. 								<br>

  366. 								<li>Once they're answered, you can track the results with the results button above.</li>

  367. 								<br>

  368. 								<li>You can create new moments with the plus button.</li>

  369. 								<br>

  370. 							</ul>

  371. 						</div><!--alert-->

  372. 					</div><!--col-sm-8-->

  373. 				</div><!--row-->

  374.   				

  375.   				<br>

  376.   			

  377. 			</div><!--container-->

  378. 			

  379. 		</div>

  380. 			

  381. 			

  382. 			

  383. 		<!--MILESTONES-->

  384. 		<div id="milestones" class="main-content-box">

  385. 			<div class="container">

  386. 		

  387. 				<div class="row">

  388. 					<h3 class="col-sm-12">Active Milestones</h3>

  389. 				</div>

  390. 				

  391. 				<div class="row">

  392. 					

  393. 					

  394. 					<div class="col-sm-12">

  395. 						<?php

  396. 						

  397.   							$query6 = "SELECT * FROM `milestone` WHERE `id_experience` = '$experienceID' ORDER BY date ASC;";

  398. 							$result6 = mysqli_query($connection, $query6);

  399. 							

  400. 							// IF THE EXPERIENCE HAS AT LEAST ONE MILESTONE ASSOCIATED TO IT, SHOW IT

  401. 							// ELSE, DISPLAY A MESSAGE TO THE USER LETTING THEM KNOW THEY DON'T HAVE ONE

  402. 							if(mysqli_num_rows($result6) > 0):

  403. 							

  404. 						?>

  405. 						<table class="table table-hover table-striped table-responsive">

  406.   							<thead>

  407.   								<tr>

  408.   									<th style="text-align: center;"><h4>Milestone</h4></th>

  409.   									<th style="text-align: center;"><h4>Date</h4></th>

  410.   								</tr>

  411.   							</thead>

  412.   							<tbody>

  413. 								<?php while($row6 = mysqli_fetch_assoc($result6)): ?>

  414.   								<tr style="cursor: pointer;">

  415.   									<td style="text-align: center;"><h5><?php echo $row6['title']; ?></h5></td>

  416.   									<td style="text-align: center;"><h5><?php echo date("M j, Y", strtotime($row6['date'])); ?></h5></td>

  417.   								</tr>

  418.    								<?php endwhile; ?>

  419.   							</tbody>

  420.   						</table>

  421.   					

  422.     					<?php else: ?>

  423.  							<h3 class="text-center"><small>It seems you still haven't added any milestones to this experience...</small></h3>

  424.   						<?php endif; ?>

  425.   					

  426.   						<br>

  427.   						

  428.   						<div class="row">

  429.   							<div class="col-sm-2 col-sm-offset-5">

  430.   								<div data-toggle="tooltip" data-placement="top" title="Create Milestone" onclick="nextModal('#NewMilestone')" id="experience-pen" style="padding: 0.5em; margin: 0 auto; width: 60px;">

  431.   									<span class="fas fa-plus"></span>

  432.   								</div>

  433.   							</div>

  434.   						</div>

  435.   						

  436.   						

  437.   					</div><!--col-sm-12-->

  438.   				</div><!--row-->

  439. 

  440. 				<br><br>

  441. 			

  442. 				<div class="row">

  443. 					<div class="col-sm-offset-2 col-sm-8">	

  444. 						<div class="alert alert-warning alert-dismisible mb-1 hidden-xs" role="alert">

  445. 							<button type="button" class="close" data-dismiss="alert" aria-label="Close">

  446. 								<span aria-hidden="true">&times;</span>

  447. 							</button>

  448. 							<h4>Tips on Milestones</h4>

  449. 							<hr>

  450. 							<ul>

  451. 								<li>These are the milestones of the students involved in this experience.</li>

  452. 								<br>

  453. 								<li>Once your moments are answered you can track the impact the milestones had on the answers, if any.</li>

  454. 								<br>

  455. 								<li>You can create new milestones with the plus button.</li>

  456. 								<br>

  457. 							</ul>

  458. 						</div><!--alert-->

  459. 					</div><!--col-sm-8-->

  460. 				</div><!--row-->

  461. 

  462. 	  			<br>

  463. 

  464. 			</div><!--container-->

  465. 		

  466. 		</div>

  467. 

  468. 

  469. 

  470. 		<br><br><br><br><br>

  471. 

  472. 

  473. 		

  474. 		<!-- POPUP FOR EDIT EXPERIENCE -->

  475. <form id="editForm"><!--method='POST' action='processes/updateExperience.php'-->

  476. 		<div class="modal fade" id="Edit" tabindex="-1" role="dialog" aria-labelledby="EditLabel" aria-hidden="true">

  477. 			<div class="modal-dialog modal-lg" role="document">

  478.  				<div class="modal-content">

  479.  				

  480.  					<div class="modal-body">

  481.  						

  482.  						<!-- CLOSE BUTTON -->

  483.  						<button type="button" class="close" data-dismiss="modal" aria-label="Close">

  484.  							<span aria-hidden="true">&times;</span>

  485.  						</button>

  486. 						

  487. 						<div class="row">

  488. 							<div class="col-sm-10">

  489. 								<h2>Edit Experience <small>(Basic Info)</small></h2>

  490. 							</div>

  491. 						</div><!--row--> 						

  492. 

  493. 						<hr><br>

  494. 

  495. 						<div class="form-horizontal">

  496. 	

  497. 							<!-- ID -->

  498. 							<input type="hidden" name="id" value="<?php echo $row1['id']; ?>"> 

  499. 				

  500. 							<!-- NEW TITLE -->

  501. 							<div class="form-group">

  502. 								<label class="control-label col-sm-2 col-sm-offset-1">Title:</label>

  503. 								<div class="col-sm-7">

  504. 									<input type="text" class="form-control text-center" name="newTitle" maxlength="60" value="<?php echo $row1['title']; ?>" required>

  505. 								</div>

  506. 							</div>

  507. 				

  508. 							<!-- NEW DESCRIPTION -->

  509. 							<div class="form-group">

  510. 								<label class="control-label col-sm-2 col-sm-offset-1">Description:</label>

  511. 								<div class="col-sm-7">

  512. 									<textarea class="form-control text-center" name="newDescription" rows="4" style="resize: vertical;" maxlength="100" required><?php echo $row1['description']; ?></textarea>

  513. 								</div>

  514. 							</div>

  515. 							

  516. 							<!-- NEW TYPE -->

  517. 							<div class="form-group">

  518. 								<label class="control-label col-sm-2 col-sm-offset-1">Type:</label>

  519. 								<div class="col-sm-7">

  520. 									<select class="form-control text-center" style="text-align-last: center;" name="newType" required>

  521. 										<option <?php echo ($row1['type'] === 'Course-Based Research Experience' ? 'selected' : ''); ?> value="Course-Based Research Experience">Course-Based Research Experience</option>

  522. 										<option <?php echo ($row1['type'] === 'Undergraduate Research Experience' ? 'selected' : ''); ?> value="Undergraduate Research Experience">Undergraduate Research Experience</option>

  523. 										<?php if($_SESSION['dbUserData']['admin'] === '1'): ?>

  524. 											<option selected value="Test">Test</option>

  525. 										<?php endif; ?>

  526. 									</select>

  527. 								</div>

  528. 							</div>

  529. 

  530. <!-- 

  531. 							<!~~ NEW DURATION ~~>

  532. 							<div class='form-group'>

  533. 								<label class='control-label col-sm-2 col-sm-offset-1'>Duration:</label>

  534. 								<div class='col-sm-7'>

  535. 									<input type='number' class='form-control text-center' name='newDuration' required value="<?php echo $row1['duration_weeks']; ?>" readonly>

  536. 								</div>

  537. 							</div>

  538.  -->

  539. 

  540. 

  541. 							<!-- NEW START DATE -->

  542. 							<div class='form-group'>

  543. 								<label class='control-label col-sm-2 col-sm-offset-1'>Start Date:</label>

  544. 								<div class='col-sm-7'>

  545. 									<input disabled type='date' class='form-control text-center' name='newStart' required value="<?php echo $row1['start_date']; ?>">

  546. 								</div>

  547. 							</div>

  548. 

  549. 							<!-- NEW END DATE -->

  550. 							<div class='form-group'>

  551. 								<label class='control-label col-sm-2 col-sm-offset-1'>End Date:</label>

  552. 								<div class='col-sm-7'>

  553. 									<input type='date' class='form-control text-center' name='newEnd' required value="<?php echo $row1['end_date']; ?>">

  554. 								</div>

  555. 							</div>

  556. 

  557. 

  558. 

  559. 

  560. 						</div><!--form-horizontal-->

  561. 

  562. 

  563. 

  564. 						<!-- ERROR ALERT FOR USER -->			

  565. 						<div id="error-editForm" class="row" style="display: none;">

  566. 							<div class="col-sm-12">

  567. 								<div class="alert alert-danger mb-1" role="alert">

  568. 									<h4 class="error-lead">Error!</h4>

  569. 									<p class="error-description"></p>

  570. 								</div>

  571. 							</div>

  572. 						</div>

  573. 

  574. 

  575.       				</div><!--modal-body-->

  576.       				

  577.       				<!-- SUBMIT OR CANCEL -->

  578.      				<div class="modal-footer">

  579.        					<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>

  580.         				<button type="submit" class="btn btn-primary" name="updateExperience">Save Changes</button>

  581.       				</div>

  582.       				

  583.     			</div><!--modal-content-->

  584.   			</div><!--modal-dialog-->

  585. 		</div><!--modal-->

  586. </form><!--form-->

  587. 		

  588. 		

  589. 		<!--FORM VALIDATION FOR EDIT EXPERIENCE-->

  590. 		<script>

  591. 		

  592. 		let newTitle = document.querySelector('[name=newTitle]');

  593. 		let newDescription = document.querySelector('[name=newDescription]');

  594. // 		let newType = document.querySelector('[name=newType]');

  595. 		

  596. 		newTitle.addEventListener('keyup', validateEditExperience);

  597. 		newTitle.addEventListener('change', validateEditExperience);

  598. 		newDescription.addEventListener('keyup', validateEditExperience);

  599. 		newDescription.addEventListener('change', validateEditExperience);

  600. // 		newType.addEventListener('keyup', validateEditExperience);

  601. // 		newType.addEventListener('change', validateEditExperience);

  602. 		

  603. 		// Only enable submit button when:

  604. 		// 1) changes are detected,

  605. 		// 2) and both strings (title and description) are not empty

  606. 		function validateEditExperience() {

  607. 			let updateExperience = document.querySelector('[name=updateExperience]');

  608. // 			updateExperience.disabled = !newTitle.checkValidity() || !newDescription.checkValidity();

  609. 		}

  610. 		

  611. 		</script>

  612. 		

  613. 		

  614. 		

  615. 		<!-- POPUP FOR NEW QUESTIONNAIRE 1 -->

  616. 		<div class="modal fade" id="NewQuestionnaire" tabindex="-1" role="dialog" aria-labelledby="NewQuestionnaireLabel" aria-hidden="true">

  617. 			<div class="modal-dialog modal-lg" role="document">

  618.  				<div class="modal-content">

  619.  				

  620.  					<div class="modal-body">

  621.  						

  622.  						<!-- CLOSE BUTTON -->

  623.  						<button type="button" class="close" data-dismiss="modal" aria-label="Close">

  624.  							<span aria-hidden='true'>&times;</span>

  625.  						</button>

  626. 						

  627. 						<div class="row">

  628. 							<div class="col-sm-10">

  629. 								<h2>New Questionnaire <small>(Basic Info – <em>Part 1</em>)</small></h2>

  630. 							</div>

  631. 						</div><!--row--> 						

  632. 

  633. 						<hr><br>

  634. 

  635. 						<div class="form-horizontal">

  636. 				

  637. 				

  638. 							<!-- TITLE -->

  639. 							<div class="form-group">

  640. 								<label class="control-label col-sm-2">Title:</label>

  641. 								<div class="col-sm-9">

  642. 									<input type="text" class="form-control text-center" name="q_title_tentative" placeholder="Title" maxlength="100" required>

  643. 								</div>

  644. 							</div>

  645. 				

  646. 							<!-- DESCRIPTION -->

  647. 							<div class="form-group">

  648. 								<label class="control-label col-sm-2">Description:</label>

  649. 								<div class="col-sm-9">

  650. 									<textarea class="form-control text-center" name="description_tentative" rows="1" placeholder="Description" maxlength="200" required></textarea>

  651. 								</div>

  652. 							</div>

  653. 

  654. 							<!-- REFERENCE -->

  655. 							<div class="form-group">

  656. 								<label class="control-label col-sm-2">Reference:</label>

  657. 								<div class="col-sm-9">

  658. 									<input type="text" class="form-control text-center" name="referencia_tentative" placeholder="Reference" maxlength="60" required>

  659. 								</div>

  660. 							</div>

  661. 							

  662. 							<br>

  663. 							

  664. 							<!-- CATEGORIES -->

  665. 							<div class="form-group">

  666. 								<label class="control-label col-sm-2">Categories:</label>

  667. 								<div class="col-sm-9">

  668. 									<textarea id="q_categories_tentative" class="form-control text-center" name="q_categories_tentative" rows="1" placeholder="Categories (comma separated)" required></textarea>

  669. 								</div>

  670. 							</div>

  671. 				

  672. 							<!-- SUBCATEGORIES -->

  673. 							<div class="form-group">

  674. 								<label class="control-label col-sm-2">Subcategories:</label>

  675. 								<div class="col-sm-9">

  676. 									<textarea id="q_subcategories_tentative" class="form-control text-center" name="q_subcategories_tentative" rows="1" placeholder="Subcategories (comma separated)" required></textarea>

  677. 								</div>

  678. 							</div>

  679. 							

  680. 						</div>

  681. 			

  682. 						<div class="row">

  683. 							<div class="col col-sm-offset-2 col-sm-9">

  684. 								<p class="alert alert-warning text-justify">

  685. 									<strong>Note:</strong> You should at least have the same number of subcategories as categories.

  686. 								</p>

  687. 							</div>

  688. 						</div>

  689. 						

  690. 			

  691.       				</div><!--modal-body-->

  692.       				

  693.       				<!-- NEXT OR CANCEL -->

  694.      				<div class="modal-footer">

  695.        					<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>

  696.         				<button id="nextQuestionnaire" type="button" class='btn btn-primary' data-dismiss="modal" onclick="nextModal('#NewQuestionnaire_2')" disabled>Next</button>

  697.       				</div>

  698.       				

  699.     			</div><!--modal-content-->

  700.   			</div><!--modal-dialog-->

  701. 		</div><!--modal-->

  702. 

  703. 

  704. 		<!-- FORM VALIDATION FOR NEW QUESTIONNAIRE (BASIC INFO) -->

  705. 		<script>

  706. 		

  707. 		

  708. 		// Fetch the inputs in the first modal

  709. 		let questionnaireTitle = document.querySelector('[name=q_title_tentative]');

  710. 		let questionnaireDescription = document.querySelector('[name=description_tentative]');

  711. 		let questionnaireReference = document.querySelector('[name=referencia_tentative]');

  712. 		let categories = document.querySelector('[name=q_categories_tentative]');

  713. 		let subcategories = document.querySelector('[name=q_subcategories_tentative]');

  714. 		

  715. 		

  716. 		// Add onchange and onkeyup event listeners to each input in the first modal

  717. 		questionnaireTitle.addEventListener('keyup', validateNewQuestionnaire);

  718. 		questionnaireTitle.addEventListener('change', validateNewQuestionnaire);

  719. 		questionnaireDescription.addEventListener('keyup', validateNewQuestionnaire);

  720. 		questionnaireDescription.addEventListener('change', validateNewQuestionnaire);

  721. 		questionnaireReference.addEventListener('keyup', validateNewQuestionnaire);

  722. 		questionnaireReference.addEventListener('change', validateNewQuestionnaire);

  723. 		categories.addEventListener('keyup', validateNewQuestionnaire);

  724. 		categories.addEventListener('change', validateNewQuestionnaire);

  725. 		subcategories.addEventListener('keyup', validateNewQuestionnaire);

  726. 		subcategories.addEventListener('change', validateNewQuestionnaire);

  727. 		

  728. 		

  729. 		// Pass the values from the first modal to the second, where the actual (hidden) inputs reside

  730. 		questionnaireTitle.addEventListener('keyup', function() {

  731. 			document.querySelector('[name=q_title]').value = questionnaireTitle.value;

  732. 		});

  733. 		questionnaireDescription.addEventListener('keyup', function() {

  734. 			document.querySelector('[name=description]').value = questionnaireDescription.value;

  735. 		});

  736. 		questionnaireReference.addEventListener('keyup', function() {

  737. 			document.querySelector('[name=referencia]').value = questionnaireReference.value;

  738. 		});

  739. 		categories.addEventListener('keyup', function() {

  740. 			document.querySelector('[name=q_categories]').value = categories.value;

  741. 		});

  742. 		subcategories.addEventListener('keyup', function() {

  743. 			document.querySelector('[name=q_subcategories]').value = subcategories.value;

  744. 		});

  745. 		

  746. 		

  747. 		// First modal's validation function

  748. 		// This basically enables the "Next" button if certain conditions are met

  749. 		function validateNewQuestionnaire() {

  750. 		

  751. 		

  752. 			// Fetch "Next" button in modal

  753. 			let nextButton = document.querySelector('#nextQuestionnaire');

  754. 			

  755. 			

  756. 			// Check validity of each input (valid if not empty strings)

  757. 			let validity = questionnaireTitle.checkValidity();

  758. 			validity &= questionnaireDescription.checkValidity();

  759. 			validity &= questionnaireReference.checkValidity();

  760. 			validity &= categories.checkValidity();

  761. 			validity &= subcategories.checkValidity();

  762. 			

  763. 			

  764. 			// Questionnaire should have at least the same number of subcategories as categories

  765. 			let rawCategories = categories.value.split(',');

  766. 			let rawSubcategories = subcategories.value.split(',');

  767. 			let categoriesArray = new Array();

  768. 			let subcategoriesArray = new Array();

  769. 			

  770. 			

  771. 			// IF clause is necessary to avoid array WARNINGS and ERRORS

  772. 			if(categories.value != '' && subcategories.value != '') {

  773. 			

  774. 				// Store the "trimmed" categories in categoriesArray

  775. 				for(let i = 0; i < rawCategories.length; i++) {

  776. 			

  777. 					rawCategories[i] = rawCategories[i].trim();

  778. 				

  779. 					// if string not empty and not whitespace, insert as category option

  780. 					if(/\S/.test(rawCategories[i])) {

  781. 						categoriesArray.push(rawCategories[i]);

  782. 					}

  783. 				

  784. 				}

  785. 			

  786. 				// Store the "trimmed" subcategories in subcategoriesArray

  787. 				for(let i = 0; i < rawSubcategories.length; i++) {

  788. 			

  789. 					rawSubcategories[i] = rawSubcategories[i].trim();

  790. 				

  791. 					// if string not empty and not whitespace, insert as subcategory option

  792. 					if(/\S/.test(rawSubcategories[i])) {

  793. 						subcategoriesArray.push(rawSubcategories[i]);

  794. 					}

  795. 				

  796. 				}

  797. 			

  798. 				// Only valid if there are less or equal number of categories to subcategories

  799. 				validity &= categoriesArray.length <= subcategoriesArray.length;

  800. 				

  801. 			}

  802. 			

  803. 			

  804. 			// Disabled if not valid, enabled otherwise

  805. 			nextButton.disabled = !validity;

  806. 			

  807. 		}

  808. 		</script>

  809. 

  810. 

  811. <form id="newQuestionnaire"><!--method="POST" action="processes/insertQuestionnaire.php"-->

  812. 		<!-- POPUP FOR NEW QUESTIONNAIRE 2 -->

  813. 		<div class="modal fade" id="NewQuestionnaire_2" tabindex="-1" role="dialog" aria-labelledby="NewQuestionnaireLabel_2" aria-hidden="true">

  814. 			<div class="modal-dialog modal-lg" role="document">

  815.  				<div class="modal-content">

  816.  				

  817.  					<div class="modal-body">

  818.  						

  819.  						<!-- CLOSE BUTTON -->

  820.  						<button type="button" class="close" data-dismiss="modal" aria-label="Close">

  821.  							<span aria-hidden="true">&times;</span>

  822.  						</button>

  823. 						

  824. 						<div class="row">

  825. 							<div class="col-sm-10">

  826. 								<h2>New Questionnaire <small>(Questions – <em>Part 2</em>)</small></h2>

  827. 							</div>

  828. 						</div><!--row--> 						

  829. 

  830. 						<hr>

  831. 

  832. 					

  833. 						<!-- EXPERIENCE ID -->

  834. 						<input type="hidden" name="id_experience" value="<?php echo $experienceID; ?>">

  835. 						

  836. 						<!-- QUESTIONNAIRE TITLE -->

  837. 						<input type="hidden" name="q_title" maxlength="100" required>

  838. 

  839. 						<!-- QUESTIONNAIRE DESCRIPTION --->

  840. 						<input type="hidden" name="description" maxlength="200" required>

  841. 

  842. 						<!-- QUESTIONNAIRE REFERENCE -->

  843. 						<input type="hidden" name="referencia" maxlength="60" required>

  844. 						

  845. 						<!-- QUESTIONNAIRE CATEGORIES -->

  846. 						<input id="q_categories" type="hidden" name="q_categories" required>

  847. 

  848. 						<!-- QUESTIONNAIRE SUBCATEGORIES -->

  849. 						<input id="q_subcategories" type="hidden" name="q_subcategories" required>

  850. 

  851. 

  852. 						<!-- QUESTION -->

  853.  						<div id="q1">

  854. 						

  855. 							<div class="row">

  856. 								<div class="col col-sm-offset-1">

  857. 									<h4>Question 1</h4>

  858. 								</div>

  859. 							</div>

  860. 							

  861. 							<div class="form-horizontal">

  862. 							

  863. 								<!-- PREMISE -->

  864. 								<div class="form-group">

  865. 									<label class="col-sm-offset-1 control-label col-sm-2">Premise:</label>

  866. 									<div class="col-sm-8">

  867. 										<input id="q_premise1" type="text" class="form-control text-center" name="q_premise1" placeholder="Premise" maxlength="600" required>

  868. 									</div>

  869. 								</div>

  870. 						

  871. 								<!-- TYPE -->

  872. 								<div class="form-group">

  873. 									<label class="col-sm-offset-1 control-label col-sm-2">Question Type:</label>

  874. 									<div class="col-sm-8">

  875. 										<select class="form-control text-center" id="q_type1" name="q_type1" style="width:100%; text-align-last:center;" onchange="newThing(event)" required>

  876. <!-- 											<option disabled selected value="">Type</option> -->

  877. 											<option value="1">Scaled</option>

  878. 											<option value="2">Open Answer</option>

  879. 										</select>

  880. 									</div>

  881. 								</div>

  882. 							

  883. 							</div>

  884. 							

  885. 							<!-- MIN/MAX VALUES/TEXT (OPTIONAL) -->

  886. 							<div id="range1">

  887. 								<div class="form-inline col col-sm-offset-2">

  888. 									<div class="form-group">

  889. 										<label class="control-label col-sm-2">Min. Value:</label>

  890. 										<div class="col-sm-8">

  891. 											<input type="number" class="form-control text-center" id="min_val1" name="min_val1" value="1" readonly>

  892. 										</div>

  893. 									</div>

  894. 									<div class="form-group">

  895. 										<label class="control-label col-sm-2">Min. Text:</label>

  896. 										<div class="col-sm-8">

  897. 											<input type="text" class="form-control text-center" id="min_text1" name="min_text1" maxlength="40" placeholder="Very Dissatisfied">

  898. 										</div>

  899. 									</div>

  900. 								</div>

  901. 							

  902. 								<div class="form-inline col col-sm-offset-2">

  903. 									<div class="form-group">

  904. 										<label class="control-label col-sm-2">Max. Value:</label>

  905. 										<div class="col-sm-1">

  906. 											<input type="number" class="form-control text-center" id="max_val1" name="max_val1" value="5" min="2">

  907. 										</div>

  908. 									</div>

  909. 									<div class="form-group">

  910. 										<label class="control-label col-sm-2">Max. Text:</label>

  911. 										<div class="col-sm-1">

  912. 											<input type="text" class="form-control text-center" id="max_text1" name="max_text1" maxlength="40" placeholder="Very Satisfied">

  913. 										</div>

  914. 									</div>

  915. 								</div>

  916. 								

  917. 								<br>

  918. 								

  919. 							</div>

  920. 							

  921. 							<div class="form-horizontal">

  922. 							

  923. 								<!-- CORRESPONDING CATEGORY -->

  924. 								<div class="form-group">

  925. 									<label class="col-sm-offset-1 control-label col-sm-2">Category:</label>

  926. 									<div class="col-sm-8">

  927. 										<select class="form-control text-center" id="q_category1" name="q_category1" style="width: 100%; text-align-last:center;" required>

  928. <!-- 											<option disabled selected value="">Category</option> -->

  929. 										</select>

  930. 									</div>

  931. 								</div>

  932. 								

  933. 								<!-- CORRESPONDING SUBCATEGORY -->

  934. 								<div class="form-group">

  935. 									<label class="col-sm-offset-1 control-label col-sm-2">Subcategory:</label>

  936. 									<div class="col-sm-8">

  937. 										<select class="form-control text-center" id="q_subcategory1" name="q_subcategory1" style="width: 100%; text-align-last:center;" required>

  938. <!-- 											<option disabled selected value="">Subcategory</option> -->

  939. 										</select>

  940. 									</div>

  941. 								</div>

  942. 							

  943. 							</div>

  944. 							

  945.  						</div>

  946. 

  947. 

  948. 						<br>

  949. 

  950.  						<div class="row">

  951.  							<div class="col-sm-offset-9 col-sm-2">

  952. 								<button type="button" class="btn btn-xs btn-default" onclick="addQuestion()">Add Question</button>

  953. 							</div>

  954. 						</div>

  955. 						

  956. 						

  957. 						

  958. 						

  959. 						<!-- ERROR ALERT FOR USER -->			

  960. 						<div id="error-newQuestionnaire" class="row" style="display: none;">

  961. 							<div class="col-sm-12">

  962. 								<div class="alert alert-danger mb-1" role="alert">

  963. 									<h4 class="error-lead">Error!</h4>

  964. 									<p class="error-description"></p>

  965. 								</div>

  966. 							</div>

  967. 						</div>

  968. 			

  969. 			

  970.       				</div><!--modal-body-->

  971.       				

  972.       				<!-- SUBMIT OR PREVIOUS -->

  973.      				<div class="modal-footer">

  974.        					<button type="button" class="btn btn-default" data-dismiss="modal" onclick="nextModal('#NewQuestionnaire')">Previous</button>

  975.         				<button type="submit" class="btn btn-primary" name="createQuestionnaire">Create</button>

  976.       				</div>

  977.       				

  978.     			</div><!--modal-content-->

  979.   			</div><!--modal-dialog-->

  980. 		</div><!--modal-->

  981. </form>

  982. 

  983. 

  984. 

  985. 

  986. 

  987. 		<!-- POPUP FOR IMPORT QUESTIONNAIRE -->

  988. 		<form id="importQuestionnaire" method="post" action="processes/importQuestionnaire.php" class='form-horizontal' enctype="multipart/form-data">

  989. 			<div class='modal fade' id='Import' tabindex='-1' role='dialog' aria-labelledby='ImportLabel' aria-hidden='true'>

  990. 				<div class='modal-dialog modal-dialog-centered modal-md' role='document'>

  991.  					<div class='modal-content'>

  992. 						

  993. 						<div class='modal-header'>

  994. 			  	 	  		<h3 class='modal-title' id='ImportLabel'>Import Questionnaire<button type='button' class='close' data-dismiss='modal' aria-label='Close'><span aria-hidden='true'>&times;</span></button></h3>

  995.    						</div>

  996.  						

  997.  						<div class='modal-body'>

  998. 

  999. 							<div class="form-horizontal">

  1000. 		

  1001. 								<!-- EXPERIENCE ID -->					

  1002. 								<input type="hidden" name="id_experience" value="<?php echo $experienceID; ?>" required>

  1003. 								

  1004. 

  1005. 								<!-- PROJECT ID (0 IF THERE'S NONE) -->

  1006. 								<input type="hidden" name="projectID" value="<?php echo ($rowProject['id_project'] ? $rowProject['id_project'] : 0); ?>" required>

  1007. 							

  1008. 							

  1009. 								<div class="row">

  1010. 									<div class="col-sm-12">

  1011. 										<h4>Download Template</h4>

  1012. 										<p>Use this template to fill out your questionnaire and we'll do the heavy lifting for you! Once you're done, <strong>submit</strong> it using the "<em>import</em>" button below.</p>

  1013. 										<a class="btn btn-primary btn-sm btn-block" href="nameOfTheQuestionnair.xlsx">Download Template</a>

  1014. 									</div>

  1015. 								</div><!--row-->

  1016. 							

  1017. 								<br>

  1018. 								<br>

  1019. 							

  1020. 								<div class="form-group">

  1021. 									<div class="col-sm-10 col-sm-offset-2">

  1022.    										<label for="exampleInputFile">Questionnaire in xlsx format</label>

  1023. 										<input type="file" name='import'>

  1024. 										<p class="help-block">Choose your .xlsx file (remember it has to have the correct format).</p>

  1025. 									</div>

  1026. 								</div><!--form-group-->

  1027. 								

  1028. 							</div>

  1029. 

  1030. 

  1031. 						<!-- ERROR ALERT FOR USER -->			

  1032. 						<div id="error-importQuestionnaire" class="row" style="display: none;">

  1033. 							<div class="col-sm-12">

  1034. 								<div class="alert alert-danger mb-1" role="alert">

  1035. 									<h4 class="error-lead">Error!</h4>

  1036. 									<p class="error-description"></p>

  1037. 								</div>

  1038. 							</div>

  1039. 						</div>

  1040. 

  1041. 

  1042.       					</div><!--modal-body-->

  1043.      					

  1044.      					<div class='modal-footer'>

  1045.        						<button type='button' class='btn btn-default' data-dismiss='modal'>Cancel</button>

  1046.         					<button type='submit' class='btn btn-primary' name='insertQuestionnaire'>Import</button>

  1047.       					</div>  					

  1048.     			

  1049.     				</div><!--modal-content-->

  1050.   				</div><!--modal-dialog-->

  1051. 			</div><!--modal-->

  1052. 		</form>

  1053. 			

  1054. 			

  1055. 			

  1056. 			

  1057. 		<!-- POPUP FOR DUPLICATE QUESTIONNAIRE -->

  1058. 		<form id="duplicateQuestionnaire" class='form-horizontal'>

  1059. 			<div class='modal fade' id='Duplicate' tabindex='-1' role='dialog' aria-labelledby='DuplicateLabel' aria-hidden='true'>

  1060. 				<div class='modal-dialog modal-dialog-centered' role='document'>

  1061.  					<div class='modal-content'>

  1062. 

  1063. 						<div class='modal-header'>

  1064. 			  	 	  		<h3 class='modal-title' id='DuplicateLabel'>Duplicate Questionnaire<button type='button' class='close' data-dismiss='modal' aria-label='Close'><span aria-hidden='true'>&times;</span></button></h3>

  1065.    						</div>

  1066. 

  1067.  						<div class='modal-body'>

  1068.  							

  1069. 							<span class='text-center'>

  1070. 								<h4>Copy a questionnaire from one experience to another</h4>

  1071. 							</span>

  1072. 							

  1073. 							<br>

  1074. 							

  1075. 

  1076. 							<!-- PROJECT ID (0 IF THERE'S NONE) -->

  1077. 							<input type="hidden" name="projectID" value="<?php echo ($rowProject['id_project'] ? $rowProject['id_project'] : 0); ?>">

  1078. 							

  1079. 							

  1080. 							<!-- FROM QUESTIONNAIRE -->

  1081. 							<label for="fromQuestionnaireID">Which Questionnaire:</label>

  1082. 							<?php

  1083. 								// FIRST ASSUME FALSE

  1084. 								$errorDuplicate = false;

  1085. 								

  1086. 								$queryQuestionnaires = "SELECT * FROM `questionnair` WHERE id IN (SELECT id_questionnair FROM experience_questionnair WHERE id_experience = '$experienceID');";

  1087. 								$resultQuestionnaires = mysqli_query($connection, $queryQuestionnaires);

  1088. 								

  1089. 								if($resultQuestionnaires->num_rows > 0):

  1090. 							?>

  1091. 							<select class="form-control text-center" id="fromQuestionnaireID" name="fromQuestionnaireID" style="text-align-last:center;" required>

  1092. 								<?php while($rowQuestionnaires = mysqli_fetch_assoc($resultQuestionnaires)): ?>

  1093. 									<option value="<?php echo $rowQuestionnaires['id']; ?>"><?php echo $rowQuestionnaires['q_title']; ?></option>

  1094. 								<?php endwhile; ?>

  1095. 							</select>

  1096. 							<?php

  1097. 								else:							

  1098. 									$errorDuplicate = true;

  1099. 							?>

  1100. 							<h3 class="text-center"><small>It seems you still haven't added any questionnaires to this experience...</small></h3>

  1101. 							<?php endif; ?>

  1102. 							

  1103. 							<br>

  1104. 							

  1105. 							<!-- TO EXPERIENCE -->

  1106. 							<label for="toExperienceID">To What Experience:</label>

  1107. 							<?php

  1108. 

  1109. 								// CHANGE QUERY DEPENDING ON IF USER IS ADMIN OR NOT

  1110. 								if($_SESSION['dbUserData']['admin'] === '1') {

  1111. 									$queryExperience2 = "SELECT * FROM `experience` WHERE id != '$experienceID';";

  1112. 								} else {

  1113. 									$queryExperience2 = "SELECT * FROM `experience` WHERE id != '$experienceID' AND id IN (SELECT id_experience FROM researcher_experience WHERE id_researcher = '" . $_SESSION['dbUserData']['id_researcher'] . "');";

  1114. 								}							

  1115. 							

  1116. 								$resultExperience2 = mysqli_query($connection, $queryExperience2);

  1117. 								

  1118. 								if($resultExperience2->num_rows > 0):

  1119. 							?>

  1120. 							<select class="form-control text-center" id="toExperienceID" name="toExperienceID" style="text-align-last:center;" required>

  1121. 								<?php while($rowExperience2 = mysqli_fetch_assoc($resultExperience2)): ?>

  1122. 								<option value="<?php echo $rowExperience2['id']; ?>"><?php echo $rowExperience2['title']; ?></option>

  1123. 								<?php endwhile; ?>

  1124. 							</select>							

  1125. 							<?php

  1126. 								else:

  1127. 									$errorDuplicate = true;	

  1128. 							?>

  1129. 							<h3 class="text-center"><small>You don't have another experience to duplicate to...</small></h3>

  1130. 							<?php endif; ?>

  1131. 							

  1132. 							

  1133. 						<br>

  1134. 							

  1135. 							

  1136. 						<!-- ERROR ALERT FOR USER -->			

  1137. 						<div id="error-duplicateQuestionnaire" class="row" style="display: none;">

  1138. 							<div class="col-sm-12">

  1139. 								<div class="alert alert-danger mb-1" role="alert">

  1140. 									<h4 class="error-lead">Error!</h4>

  1141. 									<p class="error-description"></p>

  1142. 								</div>

  1143. 							</div>

  1144. 						</div>

  1145. 							

  1146. 							

  1147. 							

  1148. 							

  1149.       					</div><!--modal-body-->

  1150.       					

  1151.       					<!-- SUBMIT OR CANCEL -->

  1152.      					<div class='modal-footer'>

  1153.        						<button type='button' class='btn btn-default' data-dismiss='modal'>Cancel</button>

  1154.         					<button type='submit' class='btn btn-primary' name='duplicateQuestionnaire' <?php if($errorDuplicate === true) echo "disabled"; ?>>Confirm</button>

  1155.       					</div>

  1156.       					

  1157.     				</div><!--modal-content-->

  1158.   				</div><!--modal-dialog-->

  1159. 			</div><!--modal-->

  1160. 		</form>

  1161. 			

  1162. 

  1163. 

  1164. 

  1165. 

  1166. <!-- POPUP FOR NEW MOMENT 1 -->

  1167. <form id="newMoment"><!--method='POST' action='processes/insertMoment.php'-->

  1168. 		<div class="modal fade" id="NewMoment" tabindex="-1" role="dialog" aria-labelledby="NewMomentLabel" aria-hidden="true">

  1169. 			<div class="modal-dialog modal-lg" role="document">

  1170.  				<div class="modal-content">

  1171.  				

  1172.  					<div class="modal-body">

  1173.  						

  1174.  						<!-- CLOSE BUTTON -->

  1175.  						<button type="button" class="close" data-dismiss="modal" aria-label="Close">

  1176.  							<span aria-hidden='true'>&times;</span>

  1177.  						</button>

  1178. 						

  1179. 						<div class="row">

  1180. 							<div class="col-sm-10">

  1181. 								<h2>New Moment <small>(Basic Info – <em>Part 1</em>)</small></h2>

  1182. 							</div>

  1183. 						</div><!--row--> 						

  1184. 

  1185. 						<hr><br>

  1186. 

  1187. 						

  1188. 						<div class="form-horizontal">

  1189. 				

  1190. 							<!--EXPERIENCE ID-->

  1191. 							<input type="hidden" name="id_experience" value="<?php echo $experienceID; ?>">

  1192. 						

  1193. 							<!-- TITLE -->

  1194. 							<div class="form-group">

  1195. 								<label class="control-label col-sm-2">Title:</label>

  1196. 								<div class="col-sm-9">

  1197. 									<input type="text" class="form-control text-center" name="m_title" maxlength="60" placeholder="Title" required>

  1198. 								</div>

  1199. 							</div>

  1200. 				

  1201. 							<!-- DESCRIPTION -->

  1202. 							<div class="form-group">

  1203. 								<label class="control-label col-sm-2">Description:</label>

  1204. 								<div class="col-sm-9">

  1205. 									<textarea class="form-control text-center" name="m_description" rows="1" style="resize:vertical;" maxlength="100" placeholder="Description" required></textarea>

  1206. 								</div>

  1207. 							</div>

  1208. 

  1209. 							<!-- DATE TO ADMINISTER -->

  1210. 							<div class="form-group">

  1211. 								<label class="control-label col-sm-2">Date to Administer:</label>

  1212. 								<div class="col-sm-9">

  1213. 									<input type="datetime-local" class="form-control text-center" name="m_date" placeholder="YYYY-MM-DDThh:mm" required>

  1214. 								</div>

  1215. 							</div>

  1216. 							

  1217. 							<!-- CORRESPONDING QUESTIONNAIRE -->

  1218. 							<?php 

  1219. 							

  1220. 								$query7 = "SELECT * FROM `questionnair` WHERE `id` IN (SELECT `id_questionnair` FROM `experience_questionnair` WHERE `id_experience` = '$experienceID');";

  1221. 								$result7 = mysqli_query($connection, $query7);

  1222. 								

  1223. 								// IF THE EXPERIENCE HAS AT LEAST ONE QUESTIONNAIRE ASSOCIATED TO IT, SHOW IT

  1224. 								// ELSE, DISPLAY A MESSAGE TO THE USER LETTING THEM KNOW THEY DON'T HAVE ONE

  1225. 								if(mysqli_num_rows($result7) > 0):

  1226. 								

  1227. 							?>

  1228. 							<div class="form-group">

  1229. 								<label class="control-label col-sm-2">Questionnaire:</label>

  1230. 								<div class="col-sm-9">

  1231. 									<select class="form-control" id="m_questionnaire" name="m_questionnaire" style="width:100%; text-align-last:center;" required>

  1232. 										<option disabled selected value>Corresponding Questionnaire</option>

  1233. 										<?php while($row7 = mysqli_fetch_assoc($result7)): ?>

  1234. 										<option value="<?php echo $row7['id']; ?>"><?php echo $row7['q_title']; ?></option>

  1235. 										<?php endwhile; ?>

  1236. 									</select>

  1237. 								</div>

  1238. 							</div>

  1239. 							<?php else: ?>

  1240. 							<div class="text-center">

  1241. 								<h3><small>First add a questionnaire!</small></h3>

  1242. 							</div>

  1243. 							<?php endif; ?>

  1244. 				

  1245. 

  1246. 						</div><!--form-horizontal-->

  1247. 			

  1248.       				</div><!--modal-body-->

  1249.       				

  1250.       				<!-- NEXT OR CANCEL -->

  1251.      				<div class="modal-footer">

  1252.        					<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>

  1253.         				<button id="nextMoment" type="button" class="btn btn-primary" data-dismiss="modal" onclick="nextModal('#NewMoment_2')" disabled>Next</button>

  1254.       				</div>

  1255.       				

  1256.     			</div><!--modal-content-->

  1257.   			</div><!--modal-dialog-->

  1258. 		</div><!--modal-->

  1259. 		

  1260. 		

  1261. 		

  1262. 		<!-- FORM VALIDATION FOR NEW MOMENT (BASIC INFO) -->

  1263. 		<script>

  1264. 		

  1265. 		

  1266. 		// Fetch the inputs in the first modal

  1267. 		let momentTitle = document.querySelector('[name=m_title]');

  1268. 		let momentDescription = document.querySelector('[name=m_description]');

  1269. 		let momentDate = document.querySelector('[name=m_date]');

  1270. 		let momentQuestionnaire = document.querySelector('[name=m_questionnaire]');

  1271. 		

  1272. 		

  1273. 		// Add onchange and onkeyup event listeners to each input in the first modal

  1274. 		momentTitle.addEventListener('keyup', validateNewMoment);

  1275. 		momentTitle.addEventListener('change', validateNewMoment);

  1276. 		momentDescription.addEventListener('keyup', validateNewMoment);

  1277. 		momentDescription.addEventListener('change', validateNewMoment);

  1278. 		momentDate.addEventListener('keyup', validateNewMoment);

  1279. 		momentDate.addEventListener('change', validateNewMoment);

  1280. 		

  1281. 		

  1282. 		// User may not have a questionnaire yet, thus momentQuestionnaire might be null

  1283. 		if(momentQuestionnaire) {

  1284. 			momentQuestionnaire.addEventListener('keyup', validateNewMoment);

  1285. 			momentQuestionnaire.addEventListener('change', validateNewMoment);

  1286. 		}

  1287. 

  1288. 		

  1289. 		// First modal's validation function

  1290. 		// This basically enables the "Next" button if certain conditions are met

  1291. 		function validateNewMoment() {

  1292. 		

  1293. 			// Fetch "Next" button in modal

  1294. 			let nextButton = document.querySelector('#nextMoment');

  1295. 			

  1296. 			// Check validity of each input (valid if not empty strings & "maxlength" is set)

  1297. 			let validity = momentTitle.checkValidity();

  1298. 			validity &= momentDescription.checkValidity();

  1299. 			validity &= momentDate.checkValidity();

  1300. 			

  1301. 			// If user doesn't have a questionnaire yet, he can't create a moment

  1302. 			if(momentQuestionnaire) {

  1303. 				validity &= momentQuestionnaire.checkValidity();

  1304. 			} else {

  1305. 				validity = false;

  1306. 			}

  1307. 			

  1308. 			// Disabled if not valid, enabled otherwise

  1309. 			nextButton.disabled = !validity;

  1310. 			

  1311. 		}

  1312. 		

  1313. 		

  1314. 		</script>

  1315. 		

  1316. 		

  1317. 		

  1318. 		<!-- POPUP FOR NEW MOMENT 2 -->

  1319. 		<div class="modal fade" id="NewMoment_2" tabindex="-1" role="dialog" aria-labelledby="NewMomentLabel_2" aria-hidden="true">

  1320. 			<div class="modal-dialog modal-lg" role="document">

  1321.  				<div class="modal-content">

  1322.  				

  1323.  					<div class="modal-body">

  1324.  						

  1325.  						<!-- CLOSE BUTTON -->

  1326.  						<button type="button" class="close" data-dismiss="modal" aria-label="Close">

  1327.  							<span aria-hidden='true'>&times;</span>

  1328.  						</button>

  1329. 						

  1330. 						<div class="row">

  1331. 							<div class="col-sm-10">

  1332. 								<h2>New Moment <small>(Questions – <em>Part 2</em>)</small></h2>

  1333. 							</div>

  1334. 						</div><!--row--> 						

  1335. 

  1336. 						<hr><br>

  1337. 						

  1338. 						<!-- QUESTION -->

  1339. 						<div id="qq1">

  1340. 						

  1341. 							<div class="row">

  1342. 								<div class="col-sm-11 col-sm-offset-1">

  1343. 									<h4>Question 1</h4>

  1344. 								</div>

  1345. 							</div>

  1346. 

  1347. 						

  1348. 							<!-- CHOOSE QUESTION FROM CORRESPONDING QUESTIONNAIRE -->

  1349. 							<div class="form-horizontal">

  1350. 								<div class="form-group">

  1351. 									<div class='col-sm-offset-2 col-sm-9'>

  1352. 										<select class="form-control" id="m_question_1" name="m_question_1" style="width:100%; text-align-last:center;" required>

  1353. 											<option disabled selected value>Select Question</option>

  1354. 										</select>

  1355. 									</div>

  1356. 								</div>

  1357. 							</div>

  1358. 

  1359. 						<br>

  1360. 							

  1361. 						</div><!--#qq-->						

  1362. 

  1363. 						

  1364. 						 <div class="row">

  1365.  							<div class="col-sm-offset-9 col-sm-2">

  1366. 								<button type='button' class='btn btn-xs btn-default' onclick='addSelectableQuestion()'>Add Question</button>

  1367. 							</div>

  1368. 						</div>

  1369. 						

  1370. 

  1371. 

  1372. 						<!-- ERROR ALERT FOR USER -->			

  1373. 						<div id="error-newMoment" class="row" style="display: none;">

  1374. 							<div class="col-sm-12">

  1375. 								<div class="alert alert-danger mb-1" role="alert">

  1376. 									<h4 class="error-lead">Error!</h4>

  1377. 									<p class="error-description"></p>

  1378. 								</div>

  1379. 							</div>

  1380. 						</div>

  1381. 

  1382. 

  1383. 

  1384.       				</div><!--modal-body-->

  1385.       				

  1386.       				<!-- NEXT OR CANCEL -->

  1387.      				<div class="modal-footer">

  1388.        					<button type="button" class="btn btn-default" data-dismiss="modal" onclick="nextModal('#NewMoment')">Previous</button>

  1389.         				<button type="submit" class="btn btn-primary" name="newMoment" <?php if(mysqli_num_rows($result7) == 0) { echo 'disabled'; } ?>>Create</button>

  1390.       				</div>

  1391.       				

  1392.     			</div><!--modal-content-->

  1393.   			</div><!--modal-dialog-->

  1394. 		</div><!--modal-->

  1395. </form>

  1396. 

  1397. 

  1398. 

  1399. <!-- POPUP FOR NEW MILESTONE -->

  1400. <form id="newMilestone">

  1401. 		<div class="modal fade" id="NewMilestone" tabindex="-1" role="dialog" aria-labelledby="NewMilestoneLabel" aria-hidden="true">

  1402. 			<div class="modal-dialog" role="document"">

  1403.  				<div class="modal-content">

  1404.  				

  1405.  					<div class="modal-body">

  1406.  						

  1407.  						<!-- CLOSE BUTTON -->

  1408.  						<button type="button" class="close" data-dismiss="modal" aria-label="Close">

  1409.  							<span aria-hidden="true">&times;</span>

  1410.  						</button>

  1411. 						

  1412. 						<div class="row">

  1413. 							<div class="col-sm-10">

  1414. 								<h2>New Milestone</h2>

  1415. 							</div>

  1416. 						</div><!--row--> 						

  1417. 

  1418. 						<hr><br>

  1419. 

  1420. 						

  1421. 						<div class="form-horizontal">

  1422. 				

  1423. 							<!-- EXPERIENCE ID -->

  1424. 							<input type="hidden" name="id_experience" value="<?php echo $experienceID; ?>">

  1425. 							

  1426. 							<!-- TITLE -->

  1427. 							<div class="form-group">

  1428. 								<label class="control-label col-sm-2">Title:</label>

  1429. 								<div class="col-sm-9">

  1430. 									<input type="text" class="form-control text-center" name="mil_title" maxlength="256" placeholder="Title" required>

  1431. 								</div>

  1432. 							</div>

  1433. 				

  1434. 							<!-- DATE -->

  1435. 							<div class="form-group">

  1436. 								<label class="control-label col-sm-2">Date:</label>

  1437. 								<div class="col-sm-9">

  1438. 									<input type="date" class="form-control text-center" name="mil_date" placeholder="YYYY-MM-DD" required>

  1439. 								</div>

  1440. 							</div>

  1441. 						

  1442. 						</div>

  1443. 						

  1444. 

  1445. 						<!-- ERROR ALERT FOR USER -->			

  1446. 						<div id="error-newMilestone" class="row" style="display: none;">

  1447. 							<div class="col-sm-12">

  1448. 								<div class="alert alert-danger mb-1" role="alert">

  1449. 									<h4 class="error-lead">Error!</h4>

  1450. 									<p class="error-description"></p>

  1451. 								</div>

  1452. 							</div>

  1453. 						</div>

  1454. 			

  1455. 			

  1456.       				</div><!--modal-body-->

  1457.       				

  1458.       				<!-- NEXT OR CANCEL -->

  1459.      				<div class="modal-footer">

  1460.        					<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>

  1461.         				<button type="submit" class="btn btn-primary" name="newMilestone">Create</button>

  1462.       				</div>

  1463.       				

  1464.     			</div><!--modal-content-->

  1465.   			</div><!--modal-dialog-->

  1466. 		</div><!--modal-->		

  1467. </form>

  1468. 		

  1469. 

  1470. 

  1471. 

  1472. 		<!-- STORE START DATE FOR CALENDAR RERENDERING LATER -->

  1473. 		<input id="experience_start_date" type="hidden" value="<?php echo $row1['start_date']; ?>">

  1474. 

  1475. 

  1476. 

  1477. 		<!-- FULL CALENDAR IMPORTS -->

  1478.     	<script src="processes/fullcalendar/packages/core/main.min.js"></script>

  1479.     	<script src="processes/fullcalendar/packages/daygrid/main.min.js"></script>

  1480.     	<script src="processes/fullcalendar/packages/timegrid/main.min.js"></script>

  1481.     	<script src="processes/fullcalendar/packages/interaction/main.min.js"></script>

  1482. <!-- 		<script src="https://unpkg.com/@fullcalendar/core/main.min.js"></script> -->

  1483. <!-- 		<script src="https://unpkg.com/@fullcalendar/daygrid/main.min.js"></script> -->

  1484. <!-- 		<script src="https://unpkg.com/@fullcalendar/timegrid@4.3.0/main.min.js"></script> -->

  1485. <!-- 		<script src="https://unpkg.com/@fullcalendar/interaction@4.3.0/main.min.js"></script> -->

  1486. 	

  1487. 	

  1488. 		

  1489. 		<script src="js/viewExperience.js"></script>

  1490. 		<script src="js/handleSubmit.js"></script>

  1491. 	

  1492. <script>

  1493. 

  1494. 

  1495. // Enable popovers

  1496. $(function () {

  1497.   $('[data-toggle="popover"]').popover();

  1498. });

  1499. 

  1500. 

  1501. 

  1502. 		// Removed "importQuestionnaire" because of weird non-fetching behaviour of importQuestionnaire.php

  1503. 		["editForm", "newQuestionnaire", "newMoment", "newMilestone", "duplicateQuestionnaire"].forEach(function(formName) {

  1504. 			

  1505. 			var form = document.getElementById(formName);

  1506. 			

  1507. 			if(form) {

  1508. 				form.addEventListener('submit', function(e) {

  1509. 					handleSubmit(e, formName);

  1510. 				});

  1511. 			}

  1512. 			

  1513. 		});

  1514. 		

  1515. 

  1516. //window.onload = function() {

  1517. 

  1518. // First load an empty calendar

  1519. var calendarElement = document.getElementById('actualCalendar');

  1520. var calendar = new FullCalendar.Calendar(calendarElement, {

  1521. 	plugins: [ 'dayGrid', 'timeGrid', 'interaction' ],

  1522. 	header: {

  1523. 		left: 'prev,next today',

  1524. 		center: 'title',

  1525. 		right: 'dayGridMonth,timeGridWeek'//,timeGridDay

  1526. 	},

  1527. 	defaultDate: document.getElementById('experience_start_date').value,

  1528. 	businessHours: true,

  1529. 	editable: true,

  1530. 	dragScroll: true,

  1531. 	eventDrop: function(eventDropInfo) {

  1532. 		$.post(document.location.protocol + "//tania.uprrp.edu/admin_nuevo/special4.php", {

  1533. 			id: eventDropInfo.event.id,

  1534. 			experienceID: document.querySelector('input[name=id_experience]').value,

  1535. 			newStartDate: Date.parse(eventDropInfo.event.start), // convert to UNIX timestamp

  1536. 			newEndDate: Date.parse(eventDropInfo.event.end) // convert to UNIX timestamp

  1537. 		}).fail(function() {

  1538. 			alert('An error occurred! Resetting calendar...');

  1539. 			eventDropInfo.revert();

  1540. 		});

  1541. 	},

  1542. 	eventClick: function(info) {

  1543. 		const eventObj = info.event;

  1544. 		

  1545. 		// If clicked event is a milstone, change view to "milestones" tab

  1546. 		if(eventObj.id.includes('milestone')) {

  1547. 			document.location.hash = '#milestones';

  1548. 		}

  1549. 	}

  1550. });

  1551. calendar.render();

  1552. 

  1553. 

  1554. // After the rest of the page has loaded, fetch events from DB & re-render calendar

  1555. var calendarConfig;

  1556. 					

  1557. $.post(document.location.protocol + "//tania.uprrp.edu/admin_nuevo/special2.php", 

  1558. 	{

  1559.  		experienceID: document.querySelector('input[name=id_experience]').value

  1560. 	},

  1561. 	function(data, status) {

  1562. 		if(!isJSON(data)) {

  1563. 			return;

  1564. 		}

  1565. 		calendarConfig = JSON.parse(data);

  1566. 	}

  1567. ).done(function() {

  1568. 	

  1569. // 	console.log(calendarConfig);

  1570. 	

  1571. 	if(calendarConfig === undefined) {

  1572. 		alert("Couldn't fetch your events! Please refresh this page. If this keeps ocurring, contact the page administrator.");

  1573. 		return;

  1574. 	}

  1575. 

  1576. 	calendarConfig.events.forEach(calendarEvent => {

  1577. 		calendar.addEvent(calendarEvent);

  1578. 	});

  1579. 

  1580. 	calendar.render();	

  1581. 

  1582. }).fail(function() { 

  1583. 	alert("Couldn't fetch your events! Please refresh this page. If this keeps ocurring, contact the page administrator.");

  1584. });

  1585. 

  1586. 

  1587. //}//domcontentloaded//onload

  1588. 

  1589. </script>

  1590. 

  1591. 

  1592. 

  1593. <?php include_once 'footer.php'; ?>