$result = $conn->query($sqlcommand);
$apospasiarray[] = array();
while ($row = $result->fetch_assoc()) {
$apospasiarray[] = $row;
}
echo json_encode($apospasiarray);
} else {
if ($sub == 'statistics') {
$sql1 = "SELECT YEAR_APOSPASI AS A, COUNT(*) AS N {$where} GROUP BY YEAR_APOSPASI ORDER BY YEAR_APOSPASI";
$sql2 = "SELECT TYPE AS A, COUNT(*) AS N {$where} GROUP BY TYPE ORDER BY N DESC";
$sql3 = "SELECT VATHMIDA AS A, COUNT(*) AS N {$where} GROUP BY VATHMIDA ORDER BY VATHMIDA";
$sql4 = "SELECT KLADOS AS A, COUNT(*) AS N {$where} GROUP BY KLADOS ORDER BY KLADOS";
printtable($sql1, $conn);
printtable($sql3, $conn);
printtable($sql4, $conn);
printtable($sql2, $conn);
}
}
$conn->close();
function buildq($typeforeas, $klados, $vathmida, $yearapospasi, $pou, $mitroo, $ln, $organiki, $fn)
{
$where = "FROM TEACHER, FOREAS, APOSPASI WHERE ";
if ($typeforeas != "") {
$where = "{$where} TYPE = '{$typeforeas}' AND";
}
if ($klados != "") {
$where = "{$where} KLADOS= '{$klados}' AND";
}
if ($vathmida != "") {
$where = "{$where} VATHMIDA= '{$vathmida}' AND";
}
}
echo "</tbody>";
echo "</table>";
echo "</div>";
echo "</div></div></div>";
} else {
$sql1 = "SELECT YEAR_APOSPASI AS A, COUNT(*) AS N {$where} GROUP BY YEAR_APOSPASI ORDER BY YEAR_APOSPASI";
$sql2 = "SELECT TYPE AS A, COUNT(*) AS N {$where} GROUP BY TYPE ORDER BY N DESC";
$sql3 = "SELECT VATHMIDA AS A, COUNT(*) AS N {$where} GROUP BY VATHMIDA ORDER BY VATHMIDA";
$sql4 = "SELECT KLADOS AS A, COUNT(*) AS N {$where} GROUP BY KLADOS ORDER BY KLADOS";
echo "<div class='row'><div class='box'>";
echo "<div class='col-lg-12 text-center' >";
printtable("Έτος", $sql1, $conn);
printtable("Βαθμίδα", $sql3, $conn);
printtable("Ειδικότητα", $sql4, $conn);
printtable("Τύπος απόσπασης", $sql2, $conn);
echo "</div>";
echo "</div></div>";
}
echo "</div>";
$conn->close();
}
function buildq($typeforeas, $klados, $vathmida, $yearapospasi, $pou, $mitroo, $ln, $organiki, $fn)
{
$where = "FROM TEACHER, FOREAS, APOSPASI WHERE ";
$pr = '';
if ($typeforeas != "") {
$where = "{$where} TYPE = '{$typeforeas}' AND";
$pr = $pr . "Τύπος απόσπασης: " . $typeforeas . " | ";
}
if ($klados != "") {
{
if (is_array($nresult)) {
echo "<table border=1 cellspacing=0 cellpadding=5>";
$keys = array_keys($nresult[0]);
echo "<tr bgcolor='cccccc'>";
foreach ($keys as $key) {
echo "<td>" . $key . "</td>";
}
echo "</tr>";
foreach ($nresult as $row) {
echo "<tr>";
foreach ($row as $value) {
echo "<td>" . $value . "</td>";
}
echo "</tr>";
}
echo "</table><br>";
} else {
echo "<table border=1 cellspacing=0 cellpadding=5><tr bgcolor='cccccc'><td>{$ntablename} No Data</td></tr></table><br>";
}
}
// read the slow queries table
$result = doSQL("select * from mysql.slow_log order by start_time asc;") or die("Query failed : " . mysql_error());
printtable($result, "slow_log");
?>
</center>
</body>
</html>
echo "<input type='hidden' value='{$month}' id='monthval' />";
?>
<?php
$sql = "SELECT `Project Group`, SUM(`Total Completed Iterations`) as 'Total Completed Iterations', SUM(`Total Saving`) as 'Total Saving' FROM (\n\t\t\tSELECT \tp.pgroup AS 'Project Group', COUNT(r.pid) AS 'Total Completed Iterations',\n\t\t\tp.psaving * COUNT(r.pid) AS 'Total Saving' FROM runs r JOIN project p ON \n\t\t\tp.pid = r.pid WHERE r.currentstatus = 'Completed' \n\t\t\tAND MONTH(r.rundate) = {$month} AND YEAR(r.rundate) = {$year}\n\t\t\tGROUP BY p.pid) tab GROUP BY `Project Group` ORDER BY `Project Group` ASC ";
printtable($conn, $sql, "myTable2");
?>
<br><br><br>
<h2> Report Project Wise </h2>
<?php
$sql = "SELECT \tr.pid AS 'Project ID', p.pname AS 'Project Name', p.pgroup as 'Project Group', COUNT(r.pid) AS 'Total Completed Iterations',\n\t\t\tp.psaving AS 'Saving Per Run', p.psaving * COUNT(r.pid) AS 'Total Saving' FROM runs r JOIN project p ON \n\t\t\tp.pid = r.pid WHERE r.currentstatus = 'Completed' \n\t\t\tAND MONTH(r.rundate) = {$month} AND YEAR(r.rundate) = {$year}\n\t\t\tGROUP BY r.pid ORDER BY r.pid ASC ";
printtable($conn, $sql, "myTable");
function printtable($conn, $sql, $tableid)
{
$result = $conn->query($sql);
//$row = mysqli_fetch_assoc($result);
//var_dump($row);
echo "<table width='100%' class='imagetable' id='{$tableid}'>";
$columnsprinted = false;
while ($row = mysqli_fetch_assoc($result)) {
if (!$columnsprinted) {
echo "<thead>";
echo "<tr>";
foreach ($row as $key => $value) {
print strtoupper("<th><a href='#'>{$key}</a></td>");
}
echo "</tr>";
}
echo "<div id='filter-box' >";
echo '<div class="filterarea"></div></div>';
//View Part starts
//start the table
$table = new html_table();
$table->id = 'entitytable';
$table->head = array(
get_string('e_name', 'local_prefix'),
get_string('editop', 'local_examtype'));
$table->size = array('15%', '15%', '15%', '15%');
$table->align = array('left', 'left', 'left', 'center');
$table->width = '49%';
$table->data = $data;
echo html_writer::table($table);
}
//end of function
$entity_list = $DB->get_records('local_create_entity');
if (empty($entity_list)) {
$e = get_string('no_records', 'local_prefix');
throw new Exception($e);
}
printtable($entity_list);
} //end of try block
catch (Exception $e) {
echo $e->getMessage();
}
echo $OUTPUT->footer();
?>
