<?php

session_start();

require "include/config.inc.php";

require "include/db.inc.php";

require "include/template2.inc.php";

$body = new Template("resi-admin");

$sideBar = new Template("side-bar");

$mysqli = DB::getInstance();

$statement = $mysqli->prepare(

"SELECT reso.id, codice, data_richiesta, reso.stato, motivazione, codice_ordine

FROM reso

JOIN ordine ON reso.ordine = ordine.id

ORDER BY data_richiesta DESC

");

$statement->execute();

$result = $statement->get_result();

if($result->num_rows > 0 ){

for($i = 0; $i < $result->num_rows; $i++){

$row = $result->fetch_assoc();

$body->setContent("id", $row['id']);

$body->setContent("codice", $row['codice']);

$body->setContent("data", $row['data_richiesta']);

$body->setContent("stato", $row['stato']);

$body->setContent("motivo", $row['motivazione']);

$body->setContent("ordine", $row['codice_ordine']);

}

}

$body->setContent("sideBar", $sideBar->get());

$body->close();

// echo print_r($_SESSION);

?>