<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
//include "../includes/functions.php";
include "includes/db.php";
require_once "Objects/FunctionClass.php";
$username = isset($_GET['username']) ? $_GET['username'] : "";
$password = isset($_GET['password']) ? $_GET['password'] : "";
//$idrepresentant = 3;
$json = array();
try {
$functionObject = new FunctionClass('./');
$member_id = $functionObject->getIdMembre($username, $password);
$STH = $DBH->prepare("\n\t\tSELECT editions.id, editions.id_journal, editions.datePublication, editions.downloadPath, editions.imagePath, editions.quantite, \n\tjournal.nom, journal.type, journal.categorie \n\t\tFROM member \n\t\tLEFT JOIN package_association ON package_association.member_id = member.id \n\t\tLEFT JOIN editions ON editions.id_journal = package_association.journal_id \n\t\tLEFT JOIN editions_download_member ON editions_download_member.member_id = member.id AND editions_download_member.edition_id = editions.id \n\t\tLEFT JOIN achats_package ON achats_package.user_id = member.id AND achats_package.package_id = member.package_id \n\t\tLEFT JOIN journal ON journal.id = editions.id_journal \n\t\tWHERE member.id = :memberId \n\t\tAND editions_download_member.id IS NULL\n\t\tAND editions.datePublication BETWEEN achats_package.date_achat AND achats_package.date_fin \n\t\tAND editions.id_journal = package_association.journal_id \n\t\tORDER BY editions.datePublication ASC\n\t\t");
$STH->bindParam(":memberId", $member_id);
$STH->execute();
$STH->setFetchMode(PDO::FETCH_ASSOC);
$x = 0;
while ($row = $STH->fetch()) {
//print_r($row);
$temp_journal = array();
$temp_journal['id'] = $row['id'];
$temp_journal['id_journal'] = $row['id_journal'];
$temp_journal['nom'] = $row['nom'];
$temp_journal['type'] = $row['type'];
$temp_journal['categorie'] = $row['categorie'];
$temp_journal['id_journal'] = $row['id_journal'];
$temp_journal['datePublication'] = $row['datePublication'];
$temp_journal['downloadPath'] = $row['downloadPath'];
$temp_journal['coverPath'] = $row['imagePath'];
