Carbon Storage (2)
function loadEventSurveyData() {
//if(document.getElementById("ddEvents").value == ""){
// document.getElementById("ddEvents").selectedIndex = "0";
//}
console.log("SurveyID: "+ document.getElementById("sid").value);
console.log("Selected Event ID: "+ document.getElementById("ddEvents").value);
location.href= document.getElementById("frmSurveyData").action + '?eid='+document.getElementById("ddEvents").value+'&sid='+document.getElementById("sid").value;
//document.getElementById("frmSurveyData").submit();
}
function sortTable(n, st) {
var table, rows, switching, i, x, y, shouldSwitch, dir, switchcount = 0;
table = document.getElementById("myTable");
switching = true;
//Set the sorting direction to ascending:
dir = "asc";
/*Make a loop that will continue until
no switching has been done:*/
while (switching) {
//start by saying: no switching is done:
switching = false;
rows = table.rows;
/*Loop through all table rows (except the
first, which contains table headers):*/
for (i = 1; i (rows.length - 1); i++) {
//start by saying there should be no switching:
shouldSwitch = false;
/*Get the two elements you want to compare,
one from current row and one from the next:*/
x = rows[i].getElementsByTagName("TD")[n].children[0];
y = rows[i + 1].getElementsByTagName("TD")[n].children[0];
/*check if the two rows should switch place,
based on the direction, asc or desc:*/
//console.log("Sort values x: " + x + " y: " + y);
//console.log("Sort values x: " + x.innerHTML + " y: " + y.innerHTML);
if(st == 1){
x = Number((x.innerHTML).replace(":", ""));
y = Number((y.innerHTML).replace(":", ""));
}else{
x = x.innerHTML.toLowerCase();
y = y.innerHTML.toLowerCase();
}
//console.log("x: "+x+" y: "+y);
if (dir == "asc") {
if (x > y) {
//if so, mark as a switch and break the loop:
shouldSwitch= true;
break;
}
} else if (dir == "desc") {
if (x < y) {
//if so, mark as a switch and break the loop:
houldSwitch = true;
break;
}
}
}
if (shouldSwitch) {
/*If a switch has been marked, make the switch
and mark that a switch has been done:*/
rows[i].parentNode.insertBefore(rows[i + 1], rows[i]);
switching = true;
//Each time a switch is done, increase this count by 1:
switchcount ++;
} else {
/*If no switching has been done AND the direction is "asc",
set the direction to "desc" and run the while loop again.*/
if (switchcount == 0 && dir == "asc") {
dir = "desc";
switching = true;
}
}
}
}
id.'|'.$user->name);*/
$uid = $user->id;
$tfid = $app->getUserStateFromRequest("tf_id", "tf_id", 0 );
//print_r('TF_IID :: ' . $tfid);
$postData = $app->input->post;
//$getData = $app->input->get;
///get event id
$eventid = $postData->get('ddEvents', '', 'string');
if(strlen($eventid ?? '') == 0){
$eventid = $app->input->get('eid', '');
}
//echo 'ddEvents-selected value : ' . $eventid;
//get surveyId
$surveyid = $app->input->get('sid', 0);
if(strlen($surveyid ?? '') == 0){
$surveyid = $postData->get('sid', '0', 'int');
}
//echo 'SID : ' . $surveyid;
if($tfid == 0){
$app->redirect(JRoute::_("https://tinyforest.earthwatch.org.uk/tiny-forest-admin-screen"));
}
echo '
';
//Event dates dropdown - START
$baseUrl = 'https://tinyforest.earthwatch.org.uk/event-management/';
$formAction = "";
switch ($surveyid) {
case 10:
//echo "Carbon Capture";
$formAction = $baseUrl . 'carbon-capture';
break;
case 20:
//echo "Thermal Comfort";
$formAction = $baseUrl . 'thermal-comfort';
break;
case 30:
//echo "Flood Management A";
$formAction = $baseUrl . 'flood-management-infiltration-rate-and-moisture';
break;
case 40:
//echo "Flood Management B";
$formAction = $baseUrl . 'flood-management-compaction-colour-and-texture';
break;
case 50:
//echo "Butterfly Time Count";
$formAction = $baseUrl . 'butterflies-timed-count';
break;
case 60:
//echo "Butterfly Species List";
$formAction = $baseUrl . 'butterflies-species-list';
break;
case 70:
//echo "Soil Dwellers";
$formAction = $baseUrl . 'soil-dwellers';
break;
case 80:
//echo "Pollinators";
$formAction = $baseUrl . 'pollinator-timed-count';
break;
//default:
//Survey Id == 0
//$app->redirect(JRoute::_("https://tinyforest.earthwatch.org.uk/tiny-forest-admin-screen"));
}
//get survey record Id which needs to be marked as deleted
$delSurveyid = $app->input->get('delid', 0);
if(strlen($delSurveyid ?? '') == 0){
$delSurveyid = $postData->get('delid', '0', 'int');
}
if($delSurveyid > 0){
$sql = 'call bitnami_joomla.ew_tf_survey_status_update('.$db->quote($delSurveyid).');';
//print_r('Q1 : ' . $sql);
$query = $db->getQuery(true);
$db->setQuery($sql);
$row = $db->loadObject();
$retVal = $row->result;
$msg='Successfuly updated survey status';
$baseSurveyResultUrl = $formAction;
$app->enqueueMessage($msg);
$app->redirect(JRoute::_($formAction.'?sid='.$surveyid.'&eid='.$app->input->get('eid', '')));
}
//echo 'form action: ' . $formAction;
//RETRIEVE - Survey Data - START
$query = $db->getQuery(true);
$sql = "call bitnami_joomla.ew_tf_event_get(". $db->quote($tfid) . ", 3)";
$db->setQuery($sql);
//print_r('qyery : ' .$sql);
$rows = $db->loadObjectList();
if(empty($rows) == false){
echo '';
if(strlen($eventid ?? '') == 0){
//trigger ddEventDates on change function
//echo '';
$eventid = $latestEventId;
//echo 'event id: ' . $latestEventId;
}
//row empty check -END
}
else
{
echo '
'; //Survey Data Display - START $baseSurveyUrl = 'https://tinyforest.earthwatch.org.uk/event-surveys/'; $surveyUrl = ""; switch ($surveyid) { case 10: //echo "Carbon Capture"; $surveyUrl = $baseSurveyUrl . 'carbon-capture-update'; break; case 20: //echo "Thermal Comfort"; $surveyUrl = $baseSurveyUrl . 'thermal-comfort-update'; break; case 30: //echo "Flood Management A"; $surveyUrl = $baseSurveyUrl . 'flood-managment-a-update'; break; case 40: //echo "Flood Management B"; $surveyUrl = $baseSurveyUrl . 'flood-managment-b-update'; break; case 50: //echo "Butterfly Time Count"; $surveyUrl = $baseSurveyUrl . 'butterflies-timed-count-update'; break; case 60: //echo "Butterfly Species List"; $surveyUrl = $baseSurveyUrl . 'butterflies-free-count-update'; break; case 70: //echo "Soil Dwellers"; $surveyUrl = $baseSurveyUrl . 'soil-dwellers-update'; break; case 80: //echo "Pollinators"; $surveyUrl = $baseSurveyUrl . 'pollinators-update'; break; //default: //Survey Id == 0 //$app->redirect(JRoute::_("https://tinyforest.earthwatch.org.uk/tiny-forest-admin-screen")); } if(strlen($eventid ?? '') > 0 && $surveyid > 0){ //RETRIEVE - Survey Data - START $query = $db->getQuery(true); $sql = "call bitnami_joomla.ew_survey_data_get(". $db->quote($eventid) . ", " . $db->quote($surveyid) .")"; $db->setQuery($sql); //print_r('qyery : ' .$sql); $rows = $db->loadObjectList(); $surveyCount = count($rows); if(empty($rows) == false){ // KS: Added class surv-resp-cnt to div echo '';
echo '';
echo '
';
//row empty check -END
}
else
{
echo '
';
//Survey Data Display - END
?>
No events created yet.
';
}
//Event dates dropdown - END
// KS: Added HR tag
echo ''; //Survey Data Display - START $baseSurveyUrl = 'https://tinyforest.earthwatch.org.uk/event-surveys/'; $surveyUrl = ""; switch ($surveyid) { case 10: //echo "Carbon Capture"; $surveyUrl = $baseSurveyUrl . 'carbon-capture-update'; break; case 20: //echo "Thermal Comfort"; $surveyUrl = $baseSurveyUrl . 'thermal-comfort-update'; break; case 30: //echo "Flood Management A"; $surveyUrl = $baseSurveyUrl . 'flood-managment-a-update'; break; case 40: //echo "Flood Management B"; $surveyUrl = $baseSurveyUrl . 'flood-managment-b-update'; break; case 50: //echo "Butterfly Time Count"; $surveyUrl = $baseSurveyUrl . 'butterflies-timed-count-update'; break; case 60: //echo "Butterfly Species List"; $surveyUrl = $baseSurveyUrl . 'butterflies-free-count-update'; break; case 70: //echo "Soil Dwellers"; $surveyUrl = $baseSurveyUrl . 'soil-dwellers-update'; break; case 80: //echo "Pollinators"; $surveyUrl = $baseSurveyUrl . 'pollinators-update'; break; //default: //Survey Id == 0 //$app->redirect(JRoute::_("https://tinyforest.earthwatch.org.uk/tiny-forest-admin-screen")); } if(strlen($eventid ?? '') > 0 && $surveyid > 0){ //RETRIEVE - Survey Data - START $query = $db->getQuery(true); $sql = "call bitnami_joomla.ew_survey_data_get(". $db->quote($eventid) . ", " . $db->quote($surveyid) .")"; $db->setQuery($sql); //print_r('qyery : ' .$sql); $rows = $db->loadObjectList(); $surveyCount = count($rows); if(empty($rows) == false){ // KS: Added class surv-resp-cnt to div echo '
Survey response count : ' . $surveyCount . '
';
echo '| Full name | '; echo 'Species Name:Tag Id | '; echo 'Dead Tree? | '; echo 'Recommmended Species | '; echo 'Tree Height in cm | '; echo 'No. of Stems | '; echo 'Stems [dbh , ddh] in mm | '; echo 'Event/Survey Date | '; echo 'Submitted on | '; echo 'Edit | '; echo 'Status | '; echo '||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
' . $fullName . ' | ';
echo '' . $tagSpecies . ' | ';
echo '' . $isTreeDead . ' | ';
echo '' . $recommendedSpecies . ' | ';
echo '' . $treeHeight . ' | ';
echo '' . $stemCount . ' | ';
echo '' . $stemText . ' | ';
echo '' . $eventSurveyDate . ' | ';
echo '' . $submittedOn . ' | ';
if($isTreeDead == 'Yes'){
echo ''; }else{ echo ' | EDIT | '; } if($itemrow->status == 1){ echo 'Delete | '; }else{ echo 'Restore | '; } echo '
No survey data submitted yet
';
}
}else{
//redirect user to the home page
echo '';
}
echo '- Hits: 31