<?php
include 'db.php';

$sql= "
    SELECT offer.*, clients.* FROM offer
    INNER JOIN clients ON (offer.idClient = clients.idClient)
    ORDER BY idOffer DESC";
$result = $conn->query($sql);

if (!$result) {
  $response['status'][] = "Invalid query";
}

if ($result) {
  // extrage detaliile ofertei
  while($row = $result->fetch_assoc()) {
    $response['items'][$row['idOffer']] = array(
      'idOffer' => $row['idOffer'],
      'nameOffer' => $row['nameOffer'],
      'nameClient' => $row['nameClient'],
      'dateOffer' => $row['dateOffer']
    );

    $idOffer=$row['idOffer'];
    $sqli= "SELECT * FROM offeritem WHERE idOffer = '$idOffer'";
    $resultInner = $conn->query($sqli);

    if ($resultInner) {
      //extrage elementele ofertei pt id $idOffer
      while($rowInner = $resultInner->fetch_assoc()) {
        $response['items'][$row['idOffer']]['offerItem'][] = array(
          'priceOfferItem' => $rowInner['priceOfferItem'],
          'quantityOfferItem' => $rowInner['quantityOfferItem']
        );
      }
    }
  }
}

else {
  $response['status'][] = "0 results";
}

$conn->close();

echo json_encode($response);
die();
?>