$form->add(‘label’, ‘label_description’, ‘_DESCRIPTION’, “CESDiscription”);
$obj = $form->add(‘textarea’, ‘_DESCRIPTION’, ”, array(
‘rows’ => 4
)
);
$obj->set_attributes(array(
‘class’ => ‘input-field control form-control’,
‘style’ => ‘width:950px’,
));
$obj->set_rule(array(
‘alphanumeric’ => array(‘#.,/+- ‘, ‘error’, ‘Invalid characters’)
));
if ($form->validate()) {
}
$form->render(‘inl_sev_048_T_wsg.php’);
// — Retrieve the list of categories —————————————–
$sql = “SELECT _CATEGORY, _SUBCATEGORY FROM categories WHERE _DEPT = ‘$dept'”;
$db = new MysqliDb(‘CES’);
$selectStatus = $db->rawQuery($sql); /
if ($selectStatus > 0) {
foreach ($selectStatus as $row) {
$categoryArray[] = $row[‘_CATEGORY’];
$subcategoryArray[] = $row[‘_SUBCATEGORY’];
}
}
$(document).ready( function () {
var subcategoryArray = <?php echo ‘[“‘ . implode(‘”, “‘, $subcategoryArray) . ‘”]’ ?>;
On select
$(‘#_CATEGORY_LIST0’).on(‘select2:select’, function (e) {
$(‘#SUB_CATEGORY_LIST0’).val(subcategoryArray[e.params.data.id]);
});
$cwarray = array($cw0, $cw1, $cw2, $cw3, $cw4, $cw5, $cw6, $cw7, $cw8, $cw9, $cw10, $cw11, $cw12, $cw13, $cw14, $cw15, $cw16, $cw17, $cw18, $cw19, $cw20, $cw21, $cw22, $cw23, $cw24, $cw25, $cw26, $cw27, $cw28, $cw29);
$upto30catw = serialize($cwarray); // MySQL field must be TEXT!!!
$sql = “UPDATE templates SET _UPTO30CATW=’$upto30catw’ WHERE temp_id=$isn”;
require_once($_SERVER[‘DOCUMENT_ROOT’].’/xyz/db/MysqliDb.php’);
// — Parameters input ——————————————————–
$dept = (isset($_REQUEST[‘DEPT’])) ? $_REQUEST[‘DEPT’] : ”;
$template = (isset($_REQUEST[‘TEMPLATE’])) ? $_REQUEST[‘TEMPLATE’] : ”;
// — Define containers ——————————————————-
$terugvoer = array();
$tmp = array();
// — Retrieve the present list of questions ———————————-
$sql = “SELECT _QUESTION, _YN, _COMMENTONLY FROM questions WHERE _DEPT = ‘$dept'”;
$db = new MysqliDb(‘CES’);
$selectStatus = $db->rawQuery($sql);
if ($selectStatus > 0) {
foreach ($selectStatus as $row) {
$questionArray[] = $row[‘_QUESTION’];
$ynArray[] = $row[‘_YN’];
$commentonlyArray[] = $row[‘_COMMENTONLY’];
}
}
// — Retrieve the list of categories —————————————–
$sql = “SELECT _CATEGORY, _SUBCATEGORY FROM categories WHERE _DEPT = ‘$dept'”;
$db = new MysqliDb(‘CES’);
$selectStatus = $db->rawQuery($sql);
if ($selectStatus > 0) {
foreach ($selectStatus as $row) {
$categoryArray[] = $row[‘_CATEGORY’];
$subcategoryArray[] = $row[‘_SUBCATEGORY’];
}
}
// — Retrieve the TEMPLATE selection data ————————————
$sql = “SELECT _TEMPLATE, _UPTO30CAT, _UPTO30CATW FROM templates WHERE _TEMPLATE = ‘$template'”;
$db = new MysqliDb(‘CES’);
$selectStatus = $db->rawQuery($sql);
if ($selectStatus > 0) {
foreach ($selectStatus as $row) { // Only one row ….. [0]
$tmp[‘_TEMPLATE’] = $row[‘_TEMPLATE’];
$tmp[‘_UPTO30CAT’] = unserialize($row[‘_UPTO30CAT’]);
$tmp[‘_UPTO30CATW’] = unserialize($row[‘_UPTO30CATW’]);
foreach ($tmp[‘_UPTO30CAT’] as $key=>$value) {
if ($value != ”) {
$tmp[‘_CATEGORY’] = $categoryArray[$value];
$tmp[‘_SUBCATEGORY’] = $subcategoryArray[$value];
$tmp[‘_CWEIGHT’] = $tmp[‘_UPTO30CATW’][$key];
$searchVal = $tmp[‘_CATEGORY’];
$sql = “SELECT _CATEGORY, _SUBCATEGORY, _UPTO15QSUBHEADING, _UPTO15QUES, _UPTO15PUNT, _UPTO15WEIGHTS FROM categories WHERE _CATEGORY = ‘$searchVal'”;
$db = new MysqliDb(‘CES’);
$selectStatus = $db->rawQuery($sql);
if ($selectStatus > 0) {
foreach ($selectStatus as $row) {
// — Store questions as HTML representation ——————–
foreach (unserialize($row[‘_UPTO15QUES’]) as $key=>$value) {
if ($value != ”) {
$tmp[‘myHeadingsArray’] = unserialize($row[‘_UPTO15QSUBHEADING’]);
$tmp[‘_QSUBHEADING’] = $tmp[‘myHeadingsArray’][$key];
$tmp[‘myPointsArray’] = unserialize($row[‘_UPTO15PUNT’]);
$tmp[‘_QWEIGHT’] = $tmp[‘myPointsArray’][$key];
$tmp[‘_QUESTION’] = $questionArray[$value];
$terugvoer[] = $tmp;
// ————————————
$tmp[‘_CATEGORY’] = ”;
$tmp[‘_SUBCATEGORY’] = ”;
$tmp[‘_CWEIGHT’] = ”;
// ————————————
} // End if
} // End store questions as HTML representation
} // End while
} // End of Question code
}
}
}
}
echo json_encode($terugvoer);
?>
document.getElementById(“categorysummary”).innerHTML = “”;
var newTable = “<table border=’1′ width=’99%’>”;
newTable += “<tr><th width=150px><b>” + cat + “</b></th><th width=200px><b>” + sub + “</b></th><th width=20px><b>” + actual + “</b></th><th width=20px><b>” + max + “</b></th><th width=20px><b>” + weight + “</b></th></tr>”;
for(var i=0; i<response.length; i++) {
myLabelarray[i] = response[i]._SUBCATEGORY;
cattofive = response[i]._CATTOFIVE;
myActualarray[i] = response[i]._CATTOFIVE;
catpoints = response[i]._CATPOINTS;
myMaxarray[i] = response[i]._CATPOINTS;
cat = response[i]._CAT;
catcalc = (cattofive / catpoints) * cat / 1;
catcalctot = catcalctot + catcalc;
catcalctot = round(catcalctot, 2);
newTable += “<tr><td>” + response[i]._CATEGORY + “</td><td>” + response[i]._SUBCATEGORY + “</td><td align=’right’>” + response[i]._CATTOFIVE + “</td><td align=’right’>” + response[i]._CATPOINTS + “</td><td align=’right’>” + response[i]._CAT + “</td></tr>”;
$(“#_OVERALLPERCENTAGE”).val(response[i]._OVERALL);
$(“#_WEIGHTEDPERCENTAGE”).val(catcalctot);
}
newTable += “</table>”;
document.getElementById(“categorysummary”).innerHTML = newTable;
myChartjs (myLabelarray, myMaxarray, myActualarray);
$(“#chart1”).hide();
$(“#chart2”).hide();
function myChartjs (myLabelarray, myMaxarray, myActualarray) {
myChart1 = ‘horizontalBar’;
var chartOptions1 = {
scales: {
xAxes: [{
id : ‘x-axis-0’,
gridLines : {
display : true,
lineWidth : 1,
color : “rgba(0,0,0,0.30)”
},
ticks: {
beginAtZero :true,
mirror :false,
}
}],
yAxes: [{
id: ‘y-axis-0’,
gridLines: {
display: false
},
ticks: {
beginAtZero: true
}
}]
},
legend: {
position : ‘right’
}
}
myChart2 = ‘radar’;
var chartOptions2 = {
scale: {
ticks: {
beginAtZero : true
}
},
legend: {
position : ‘right’
}
}
var myData = {
labels: myLabelarray,
datasets: [{
label: “<?php echo ‘CESMaximun’ ?>”,
backgroundColor: “rgba(255,204,51,0.2)”,
borderColor: “rgba(255,102,0,0.2)”,
borderWidth: 2,
radius: 6,
pointRadius: 6,
pointBorderWidth: 3,
pointBackgroundColor: “orange”,
pointBorderColor: “rgba(200,0,0,0.6)”,
pointHoverRadius: 10,
data: myMaxarray
}, {
label: “<?php echo ‘CESActual’ ?>”,
backgroundColor: “rgba(102,255,51,0.2)”, // Light green
borderColor: “rgba(0,153,0,0.2)”,
borderWidth: 2,
radius: 6,
pointRadius: 6,
pointBorderWidth: 3,
pointBackgroundColor: “cornflowerblue”,
pointBorderColor: “rgba(0,0,200,0.6)”,
pointHoverRadius: 10,
data: myActualarray
}]
};
var radarChart1 = new Chart(myCanvas1, {
type : myChart1,
data : myData ,
options : chartOptions1
});
var radarChart2 = new Chart(myCanvas2, {
type : myChart2,
data : myData ,
options : chartOptions2
});
}
if (points > outof) {
var $form1 = $(“#form1”).data(‘Zebra_Form’);
$form1.attach_tip($(“#_POINTS” + isn), ‘Mag nie groter wees as maksimum’);
}
try {
if (data[i + 1]._CATEGORY != ”) { /
mySwitch = 1;
}
} catch(err) {
}
$(‘#_QUESTIONNAIRES’).on(‘select2:select’, function (e) {
var data = e.params.data;
myQuestionnaire = data.text;
getVersion (myQuestionnaire);
$(‘#label_versionlist’).show();
$(‘#_VERSIONS’).next().show();
});
// ——————————————————
$(‘#_VERSIONS’).on(‘select2:select’, function (e) {
$(‘#label_branchlist’).show();
$(‘#_TAK’).next().show();
var data = e.params.data;
myVersion = data.text;
});
// ——————————————————
$(‘#_TAK’).on(‘select2:select’, function (e) {
document.getElementById(“btnEvaluasiestaat”).disabled = false;
var data = e.params.data;
myBranch = data.text;
});
function getVersion (questionnaire) {
$(‘#_VERSIONS’).children(‘option:not(:first)’).remove();
$.post(‘inl_sev_042_J_nvg.php’,{“QUESTIONNAIRE” : questionnaire}, function(data) {
var i;
for (i = 0; i < data.length; i++) {
text = data[i];
newOption = new Option(text, i, false, false);
$(‘#_VERSIONS’).append(newOption).trigger(‘change’);
}
}, ‘json’);
}
My PHP / Javascript / JQuery notes 
You must be logged in to post a comment.