public function demoAction()
{
/*
* dataTable for Pie Chart for example (long way - 2 columns)
*/
$dataTable1 = new DataTable\DataTable(array('cols' => array(array('id' => 'id1', 'label' => 'label1', 'type' => 'string'), array('id' => 'id2', 'label' => 'label2', 'type' => 'number')), 'rows' => array(array(array('v' => 'auto'), array('v' => 10, 'f' => '10 per hours')), array(array('v' => 'auto row 2'), array('v' => 5, 'f' => '5 per hours')))));
/*
* dataTable for Bar Chart for example (3 columns)
*/
$dataTable2 = new DataTable\DataTable();
$dataTable2->addColumn('id1', 'label 1', 'string');
$dataTable2->addColumnObject(new DataTable\DataColumn('id2', 'label 2', 'number'));
$dataTable2->addColumnObject(new DataTable\DataColumn('id3', 'label 3', 'number'));
//test cells as array
$dataTable2->addRow(array(array('v' => 'row 1'), array('v' => 2, 'f' => '2 trucks'), array('v' => 4, 'f' => '4 bikes')));
//simple cell (not an array)
$dataTable2->addRow(array('row 2', 5, 1));
//mixed
$dataTable2->addRow(array('row 3', array('v' => 5), 10));
$dataTable2->addRow(array('row 4', array('v' => 2), 0));
$dataTable2->addRow(array('row 5', array('v' => 0), 10));
$dataTable2->addRow(array('row 5', 10, 0));
$dataTable2->addRow(array('row 5', 4, 5));
/*
* DataTable with 2 number colums (for Jauge)
*/
$dataTable3 = new DataTable\DataTable();
$dataTable3->addColumnObject(new DataTable\DataColumn('id2', 'label 1', 'number'));
$dataTable3->addColumnObject(new DataTable\DataColumn('id3', 'label 2', 'number'));
//test cells as array
$dataTable3->addRow(array(array('v' => 2, 'f' => '2 trucks'), array('v' => 4, 'f' => '4 bikes')));
//simple cell (not an array)
$dataTable3->addRow(array(5, 1));
//mixed
$dataTable3->addRow(array(array('v' => 2), 10));
$dataTable3->addRow(array(array('v' => 2), 10));
$dataTable4 = new DataTable\DataTable();
$dataTable4->addColumnObject(new DataTable\DataColumn('id11', 'x', 'number'));
$dataTable4->addColumnObject(new DataTable\DataColumn('id22', 'label 1', 'number'));
$dataTable4->addColumnObject(new DataTable\DataColumn('id33', 'label 2', 'number'));
//test cells as array
$dataTable4->addRow(array(2, 4, 3));
//simple cell (not an array)
$dataTable4->addRow(array(4, 5, 1));
//mixed
$dataTable4->addRow(array(6, 3, 4));
$dataTable4->addRow(array(8, 8, 3));
$dataTable5 = DataTable\DataTable::fromSimpleMatrix(array(array('col1', 'col2', 'col3'), array('row1', 1, 2), array('row2', 3, 4), array('row3', 4, 5)), true);
$dataTable6 = DataTable\DataTable::fromSimpleMatrix(array(array('row1', 1, 2), array('row2', 3, 4), array('row3', 4, 5)), false);
$dataTable7 = DataTable\DataTable::fromSimpleMatrix(array(array('col1', 'col2', 'col3'), array('row1', 1, true), array('row2', 3, false), array('row3', 4, true)), true);
$myArray[0]['idMonth'] = 'January';
$myArray[0]['idOne'] = 1;
$myArray[0]['idTwo'] = 2;
$myArray[1]['idMonth'] = 'February';
$myArray[1]['idThree'] = 33;
$myArray[2]['idMonth'] = 'March';
$myArray[2]['idTwo'] = 2;
$myArray[2]['idOne'] = 1;
$myArray[2]['idThree'] = 33;
//------------
$dt = new DataTable\DataTable();
$dt->addColumn('idMonth', 'Months', 'string');
$dt->addColumn('idOne', 'One', 'number');
$dt->addColumn('idTwo', 'Two', 'number');
$dt->addColumn('idThree', 'Three', 'number');
//------------
$dt->addRows($myArray);
$dataTable8 = new DataTable\DataTable();
$dataTable8->addColumnObject(new DataTable\DataColumn('id1', 'year', 'date'));
$dataTable8->addColumnObject(new DataTable\DataColumn('id2', 'movies', 'number'));
$dataTable8->addRow(array(new \DateTime('2009-01-01'), 12));
$dataTable8->addRow(array(new \DateTime('2009-02-01'), 9));
$dataTable8->addRow(array(new \DateTime('2009-03-01'), 16));
return $this->render('SaadTaziGChartBundle:Demo:demo.html.twig', array('dt' => $dt->toStrictArray(), 'dataTable1' => $dataTable1->toArray(), 'rawDataTable1' => $dataTable1, 'dataTable2' => $dataTable2->toArray(), 'dataTable3' => $dataTable3->toArray(), 'dataTable4' => $dataTable4->toArray(), 'dataTable5' => $dataTable5->toArray(), 'dataTable6' => $dataTable6->toArray(), 'dataTable7' => $dataTable7->toArray(), 'dataTable8' => $dataTable8->toArray()));
}
public function showTeacherAction($filter = null)
{
$filterArray = array();
if ($filter != null) {
array_push($filterArray, explode(".", $filter));
$filterArray = $filterArray[0];
$i = 0;
foreach ($filterArray as $Afilter) {
$filterArray[$i] = array_map('intval', explode(",", $Afilter));
$i++;
}
}
//Number of questions in the survey
$NUMBEROFQUESTIONS = 10;
//Questions in the survey
$resultQuestionsArray = ['Antall svar per skole', 'Klassetrinn', 'Det var nyttig å ha vektorassistentene i klassen.', 'Vektorassistentene var kvalifiserte for jobben.', 'Det var for mange studentassistenter tilstede.', 'Det var god kontakt og informasjonsflyt på forhånd.', 'Jeg ønsker at prosjektet fortsetter.', 'Jeg tror elevene har blitt mer motivert for matematikk som følge av prosjektet.', 'Arbeidsbelastningen ble mindre når vektorassistentene var på skolen.', 'Undervisning ble bedre tilpasset for elevene.', 'Har du noen kommentarer om vektorprogrammet som vi kan bruke videre?'];
//Connects with the SurveyTecher entity
$repositorySurvey = $this->getDoctrine()->getRepository('AppBundle:SurveyTeacher');
//Connects with the School entity
$repositorySchool = $this->getDoctrine()->getRepository('AppBundle:School');
//Finds numeber of surveys
if ($filter != null) {
$numberOfSurveys = $repositorySurvey->NumOfSurveysFiltered($filterArray);
} else {
//Finds number of survey answers for each school
$numberOfSurveys = $repositorySurvey->NumOfSurveys();
}
//Finds the textual feedback
$feedBack = $repositorySurvey->allFeedback();
//Creates the DataTable with two columns
$schoolChart = new DataTable();
$schoolChart->addColumn('1', 'Alternantive', 'string');
$schoolChart->addColumn('2', 'Quantity', 'number');
//Loops through the schools
foreach ($repositorySchool->findAll() as $school) {
//Finds the names for the schools
$schoolName = $repositorySchool->find($school)->getName();
if ($filter != null) {
$schoolNumber = $repositorySurvey->NumOfSchoolsByIdFiltered($school, $filterArray);
} else {
//Finds number of survey answers for each school
$schoolNumber = $repositorySurvey->NumOfSchoolsBySchool($school);
}
//Adds the information in the DataTable
$schoolChart->addRow([$schoolName, intval($schoolNumber)]);
}
//Creates two arrays that will be sent into the twig, with the information form the surveys, and the questions.
$diagramArray[0] = $schoolChart->toArray();
$questionArray[0] = $resultQuestionsArray[0];
//Loop through the question
for ($diagramCounter = 1; $diagramCounter < $NUMBEROFQUESTIONS; $diagramCounter++) {
//creates a new dataTable for the information from the surveys
$chart = new DataTable();
$chart->addColumn('1', 'Question', 'string');
$chart->addColumn('2', 'Quantity', 'number');
//Sets the correct alternatives for the respective questions
if ($diagramCounter == 1) {
$ALTERNATIVEARRAY = ['8. Klasse', '9. Klasse', '10. Klasse'];
$NUMBEROFALTERNATIVES = 3;
} else {
$ALTERNATIVEARRAY = ['Helt enig', 'Noe enig', 'Nøytral', 'Noe uenig', 'Helt Uenig'];
$NUMBEROFALTERNATIVES = 5;
}
for ($alternativeCounter = 1; $alternativeCounter < $NUMBEROFALTERNATIVES + 1; $alternativeCounter++) {
$alternative = $ALTERNATIVEARRAY[$alternativeCounter - 1];
if ($filter != null) {
$answerNumber = $repositorySurvey->NumOfAnswersByQuestionIdAndAlternativesFiltered($diagramCounter, $alternativeCounter, $filterArray);
} else {
$answerNumber = $repositorySurvey->NumOfAnswersByQuestionIdAndAlternatives($diagramCounter, $alternativeCounter);
}
$chart->addRow([$alternative, intval($answerNumber)]);
}
$diagramArray[$diagramCounter] = $chart->toArray();
$questionArray[$diagramCounter] = $resultQuestionsArray[$diagramCounter - 1];
}
$questionArray[10] = $resultQuestionsArray[9];
return $this->render('survey/survey_data.html.twig', array('id' => 'teacher', 'diagram' => $diagramArray, 'question' => $questionArray, 'numSurveys' => $numberOfSurveys, 'feedback' => $feedBack, 'info' => "Lærerundersøkelsene"));
}
public function resultSurveyAction(Survey $survey)
{
$surveyTakenList = $this->getDoctrine()->getRepository('AppBundle:SurveyTaken')->findBySurvey($survey);
//ADD SCHOOL CHART
$schoolCompletedCount = array();
foreach ($surveyTakenList as $surveyTaken) {
$school = $surveyTaken->getSchool()->getName();
if (array_key_exists($school, $schoolCompletedCount)) {
$schoolCompletedCount[$school]++;
} else {
$schoolCompletedCount[$school] = 1;
}
}
$chart = new DataTable();
$chart->addColumn('1', 'Label', 'string');
$chart->addColumn('2', 'Quantity', 'number');
$alternativeArray = array_keys($schoolCompletedCount);
foreach ($alternativeArray as $alternative) {
$chart->addRow([$alternative, $schoolCompletedCount[$alternative]]);
}
$diagramArray[] = $chart->toArray();
$questionArray[] = 'Skole';
//SCHOOL CHART END
$lablesArray = array();
$questionsArray = array();
$textQuestionArray = array();
$textQAarray = array();
$counter = 0;
//Create question charts
foreach ($survey->getSurveyQuestions() as $question) {
if ($question->getType() != "text") {
array_push($lablesArray, $question->getQuestion());
array_push($questionsArray, $question);
} else {
$textQuestionArray[] = $question;
}
}
foreach ($textQuestionArray as $textQuestion) {
$questionText = $textQuestion->getQuestion();
$textQAarray[$questionText] = array();
foreach ($textQuestion->getAnswers() as $answer) {
$textQAarray[$questionText][] = $answer->getAnswer();
}
}
foreach ($questionsArray as $question) {
$chart = new DataTable();
$chart->addColumn('1', 'Label', 'string');
$chart->addColumn('2', 'Quantity', 'number');
$alternativeArray = $question->getAlternatives();
foreach ($alternativeArray as $alternative) {
$alternative = $alternative->getAlternative();
$num = 0;
foreach ($question->getAnswers() as $answer) {
if ($answer->getAnswer() == $alternative) {
$num++;
}
}
$chart->addRow([$alternative, intval($num)]);
}
$diagramArray[] = $chart->toArray();
$questionArray[] = $lablesArray[$counter];
$counter++;
}
return $this->render('survey/survey_result.html.twig', array('textAnswers' => $textQAarray, 'numAnswered' => sizeof($surveyTakenList), 'survey' => $survey, 'diagram' => $diagramArray, 'question' => $questionArray));
}
public function demoAction()
{
/*
* dataTable for Pie Chart for example (long way - 2 columns)
*/
$dataTable1 = new DataTable\DataTable(array('cols' => array(array('id' => 'id1', 'label' => 'label1', 'type' => 'string'), array('id' => 'id2', 'label' => 'label2', 'type' => 'number')), 'rows' => array(array(array('v' => 'auto'), array('v' => 10, 'f' => '10 per hours')), array(array('v' => 'auto row 2'), array('v' => 5, 'f' => '5 per hours')))));
/*
* dataTable for Bar Chart for example (3 columns)
*/
$dataTable2 = new DataTable\DataTable();
$dataTable2->addColumn('id1', 'label 1', 'string');
$dataTable2->addColumnObject(new DataTable\DataColumn('id2', 'label 2', 'number'));
$dataTable2->addColumnObject(new DataTable\DataColumn('id3', 'label 3', 'number'));
//test cells as array
$dataTable2->addRow(array(array('v' => 'row 1'), array('v' => 2, 'f' => '2 trucks'), array('v' => 4, 'f' => '4 bikes')));
//simple cell (not an array)
$dataTable2->addRow(array('row 2', 5, 1));
//mixed
$dataTable2->addRow(array('row 3', array('v' => 5), 10));
$dataTable2->addRow(array('row 4', array('v' => 2), 0));
$dataTable2->addRow(array('row 5', array('v' => 0), 10));
$dataTable2->addRow(array('row 5', 10, 0));
$dataTable2->addRow(array('row 5', 4, 5));
/*
* DataTable with 2 number colums (for Jauge)
*/
$dataTable3 = new DataTable\DataTable();
$dataTable3->addColumnObject(new DataTable\DataColumn('id2', 'label 1', 'number'));
$dataTable3->addColumnObject(new DataTable\DataColumn('id3', 'label 2', 'number'));
//test cells as array
$dataTable3->addRow(array(array('v' => 2, 'f' => '2 trucks'), array('v' => 4, 'f' => '4 bikes')));
//simple cell (not an array)
$dataTable3->addRow(array(5, 1));
//mixed
$dataTable3->addRow(array(array('v' => 2), 10));
$dataTable3->addRow(array(array('v' => 2), 10));
$dataTable4 = new DataTable\DataTable();
$dataTable4->addColumnObject(new DataTable\DataColumn('id11', 'x', 'number'));
$dataTable4->addColumnObject(new DataTable\DataColumn('id22', 'label 1', 'number'));
$dataTable4->addColumnObject(new DataTable\DataColumn('id33', 'label 2', 'number'));
//test cells as array
$dataTable4->addRow(array(2, 4, 3));
//simple cell (not an array)
$dataTable4->addRow(array(4, 5, 1));
//mixed
$dataTable4->addRow(array(6, 3, 4));
$dataTable4->addRow(array(8, 8, 3));
$dataTable5 = DataTable\DataTable::fromSimpleMatrix(array(array('col1', 'col2', 'col3'), array('row1', 1, 2), array('row2', 3, 4), array('row3', 4, 5)), true);
$dataTable6 = DataTable\DataTable::fromSimpleMatrix(array(array('row1', 1, 2), array('row2', 3, 4), array('row3', 4, 5)), false);
$dataTable7 = DataTable\DataTable::fromSimpleMatrix(array(array('col1', 'col2', 'col3'), array('row1', 1, true), array('row2', 3, false), array('row3', 4, true)), true);
$myArray[0]['idMonth'] = 'January';
$myArray[0]['idOne'] = 1;
$myArray[0]['idTwo'] = 2;
$myArray[1]['idMonth'] = 'February';
$myArray[1]['idThree'] = 33;
$myArray[2]['idMonth'] = 'March';
$myArray[2]['idTwo'] = 2;
$myArray[2]['idOne'] = 1;
$myArray[2]['idThree'] = 33;
//------------
$dt = new DataTable\DataTable();
$dt->addColumn('idMonth', 'Months', 'string');
$dt->addColumn('idOne', 'One', 'number');
$dt->addColumn('idTwo', 'Two', 'number');
$dt->addColumn('idThree', 'Three', 'number');
//------------
$dt->addRows($myArray);
$dataTable8 = new DataTable\DataTable();
$dataTable8->addColumnObject(new DataTable\DataColumn('id1', 'year', 'date'));
$dataTable8->addColumnObject(new DataTable\DataColumn('id2', 'movies', 'number'));
$dataTable8->addRow(array(new \DateTime('2009-01-01'), 12));
$dataTable8->addRow(array(new \DateTime('2009-02-01'), 9));
$dataTable8->addRow(array(new \DateTime('2009-03-01'), 16));
// for candlestick: requires 5 cols: one string and 4 numbers
$dt9 = new DataTable\DataTable();
$dt9->addColumn('what', 'What', 'string');
$dt9->addColumn('idOne', 'One', 'number');
$dt9->addColumn('idTwo', 'Two', 'number');
$dt9->addColumn('idThree', 'Three', 'number');
$dt9->addColumn('idFour', 'Four', 'number');
$dt9->addRow(array('candle 1', 1, 2, 3, 4));
$dt9->addRow(array('candle 2', 1, 2.5, 3.5, 3.75));
$dt9->addRow(array('candle 3', 2, 2.5, 3.5, 3.75));
// for treemap: requires 4 cols
$dt10 = new DataTable\DataTable();
$dt10->addColumn('region', 'Region', 'string');
$dt10->addColumn('parent', 'Parent', 'string');
$dt10->addColumn('nb1', 'Number 1 (size)', 'number');
$dt10->addColumn('nb2', 'Number 2 (color - optional)', 'number');
$dt10->addRow(array("Global", null, 0, 0));
$dt10->addRow(array("America", "Global", 0, 0));
$dt10->addRow(array("Europe", "Global", 0, 0));
$dt10->addRow(array("Asia", "Global", 0, 0));
$dt10->addRow(array("Australia", "Global", 0, 0));
$dt10->addRow(array("Africa", "Global", 0, 0));
$dt10->addRow(array("Brazil", "America", 11, 10));
$dt10->addRow(array("USA", "America", 52, 31));
$dt10->addRow(array("Mexico", "America", 24, 12));
$dt10->addRow(array("Canada", "America", 16, -23));
$dt10->addRow(array("France", "Europe", 42, -11));
$dt10->addRow(array("Germany", "Europe", 31, -2));
$dt10->addRow(array("Sweden", "Europe", 22, -13));
$dt10->addRow(array("Italy", "Europe", 17, 4));
$dt10->addRow(array("UK", "Europe", 21, -5));
$dt10->addRow(array("China", "Asia", 36, 4));
$dt10->addRow(array("Japan", "Asia", 20, -12));
$dt10->addRow(array("India", "Asia", 40, 63));
$dt10->addRow(array("Laos", "Asia", 4, 34));
$dt10->addRow(array("Mongolia", "Asia", 1, -5));
$dt10->addRow(array("Israel", "Asia", 12, 24));
$dt10->addRow(array("Iran", "Asia", 18, 13));
$dt10->addRow(array("Pakistan", "Asia", 11, -52));
$dt10->addRow(array("Egypt", "Africa", 21, 0));
$dt10->addRow(array("S. Africa", "Africa", 30, 43));
$dt10->addRow(array("Sudan", "Africa", 12, 2));
$dt10->addRow(array("Congo", "Africa", 10, 12));
$dt10->addRow(array("Zair", "Africa", 10, 12));
return $this->render('SaadTaziGChartBundle:Demo:demo.html.twig', array('dt' => $dt->toStrictArray(), 'dataTable1' => $dataTable1->toArray(), 'rawDataTable1' => $dataTable1, 'dataTable2' => $dataTable2->toArray(), 'dataTable3' => $dataTable3->toArray(), 'dataTable4' => $dataTable4->toArray(), 'dataTable5' => $dataTable5->toArray(), 'dataTable6' => $dataTable6->toArray(), 'dataTable7' => $dataTable7->toArray(), 'dataTable8' => $dataTable8->toArray(), 'dt9' => $dt9->toArray(), 'dt10' => $dt10->toArray()));
}
public function showAction()
{
$NUMBEROFCHARTS = 7;
$lablesArray = ["Semester", "Kjønn", "Har vært vektorassistent tidligere", "Antall tatt opp", "Studieår", "Studie", "Avdeling"];
$repositoryApplicationStatistic = $this->getDoctrine()->getRepository('AppBundle:ApplicationStatistic');
$repositorySemester = $this->getDoctrine()->getRepository('AppBundle:Semester');
$repositoryFieldOfStudy = $this->getDoctrine()->getRepository('AppBundle:FieldOfStudy');
$repositoryDepartment = $this->getDoctrine()->getRepository('AppBundle:Department');
$numberOfApplications = $repositoryApplicationStatistic->NumOfApplications();
for ($diagramCounter = 0; $diagramCounter < $NUMBEROFCHARTS; $diagramCounter++) {
$chart = new DataTable();
$chart->addColumn('1', 'Label', 'string');
$chart->addColumn('2', 'Quantity', 'number');
$AlternativeArray = [];
if ($diagramCounter == 0) {
$semesterCounter = 0;
foreach ($repositorySemester->findAllSemesters() as $semester) {
array_push($AlternativeArray, $semester->getName() . ' ' . $semester->getDepartment()->getShortName());
$alternative = $AlternativeArray[$semesterCounter];
$semesterNumber = $repositoryApplicationStatistic->NumOfSemester($semester);
$chart->addRow([$alternative, intVal($semesterNumber)]);
$semesterCounter++;
}
} elseif ($diagramCounter == 1) {
$AlternativeArray = ['Gutt', 'Jente'];
for ($alternativeCounter = 0; $alternativeCounter < count($AlternativeArray); $alternativeCounter++) {
$alternative = $AlternativeArray[$alternativeCounter];
$genderNumber = $repositoryApplicationStatistic->numOfGender($alternativeCounter);
$chart->addRow([$alternative, intval($genderNumber)]);
}
} elseif ($diagramCounter == 2) {
$AlternativeArray = ['Nei', 'Ja'];
for ($alternativeCounter = 0; $alternativeCounter < count($AlternativeArray); $alternativeCounter++) {
$alternative = $AlternativeArray[$alternativeCounter];
$participationNumber = $repositoryApplicationStatistic->NumOfPreviousParticipation($alternativeCounter);
$chart->addRow([$alternative, intval($participationNumber)]);
}
} elseif ($diagramCounter == 3) {
$AlternativeArray = ['Ikke tatt opp', 'Tatt opp'];
for ($alternativeCounter = 0; $alternativeCounter < count($AlternativeArray); $alternativeCounter++) {
$alternative = $AlternativeArray[$alternativeCounter];
$acceptedNumber = $repositoryApplicationStatistic->NumOfAccepted($alternativeCounter);
$chart->addRow([$alternative, intval($acceptedNumber)]);
}
} elseif ($diagramCounter == 4) {
$AlternativeArray = ['1', '2', '3', '4', '5'];
for ($alternativeCounter = 0; $alternativeCounter < count($AlternativeArray); $alternativeCounter++) {
$alternative = "" . $AlternativeArray[$alternativeCounter] . ". året";
$acceptedNumber = $repositoryApplicationStatistic->NumOfYearOfStudy($alternativeCounter + 1);
$chart->addRow([$alternative, intval($acceptedNumber)]);
}
} elseif ($diagramCounter == 5) {
$semesterCounter = 0;
foreach ($repositoryFieldOfStudy->findAllFieldOfStudy() as $fieldOfStudy) {
array_push($AlternativeArray, $fieldOfStudy->getName());
$alternative = $AlternativeArray[$semesterCounter];
$fieldOfStudyNumber = $repositoryApplicationStatistic->NumOfFieldOfStudy($fieldOfStudy);
$chart->addRow([$alternative, intVal($fieldOfStudyNumber)]);
$semesterCounter++;
}
} else {
$semesterCounter = 0;
foreach ($repositoryDepartment->findAllDepartments() as $department) {
array_push($AlternativeArray, $department->getShortName());
$alternative = $AlternativeArray[$semesterCounter];
$semesterNumber = $repositoryApplicationStatistic->NumOfDepartment($department->getId());
$chart->addRow([$alternative, intVal($semesterNumber)]);
$semesterCounter++;
}
}
$diagramArray[$diagramCounter] = $chart->toArray();
$questionArray[$diagramCounter] = $lablesArray[$diagramCounter];
}
return $this->render('statistics/statistics.html.twig', array('diagram' => $diagramArray, 'question' => $questionArray));
}
