error_reporting(E_ALL);
ini_set('display_errors', '1');
include "../includes/db.php";
require_once "../Objects/InsertAchatAndroidPayloadClass.php";
require_once "../Objects/FunctionClass.php";
//$json = json_decode($_GET['data']);
$username = isset($_POST['username']) ? $_POST['username'] : "";
$password = isset($_POST['password']) ? $_POST['password'] : "";
$sku = isset($_POST['sku']) ? $_POST['sku'] : "";
$quantite = isset($_POST['quantite']) ? $_POST['quantite'] : "";
$prix = isset($_POST['prix']) ? $_POST['prix'] : "";
$payload = isset($_POST['payload']) ? $_POST['payload'] : "";
$functionObject = new FunctionClass('./../');
$user_id = $functionObject->getIdMembre($username, $password);
$virtual_currency_bought = $functionObject->getVirtualCurrencyBundleIdForAndroidWithQuantite($quantite);
try {
$DBH->query('BEGIN');
$dateheure = date('Y-m-d H:i:s', time());
/*
enregistrer la transaction
*/
$STH = $DBH->prepare("\n\tINSERT IGNORE INTO `achats_android` (\n\t`user_id`, `sku`, `virtual_currency_bought`, `quantite`, `prix`, `payload`, `date`) \n\tVALUES (\n\t:user_id, :sku, :virtual_currency_bought, :quantite, :prix, :payload, :date)\n\t");
//print_r($json);
$achatAndroidPayloadClass = new InsertAchatAndroidPayloadClass($user_id, $sku, $virtual_currency_bought, $quantite, $prix, $payload, $dateheure);
$STH->execute((array) $achatAndroidPayloadClass);
$achatAndroidPayloadClass_affected = $STH->rowCount();
$idachat = $DBH->lastInsertId('id');
if ($achatAndroidPayloadClass_affected == 1) {
$DBH->query('COMMIT');
echo json_encode(array("resultat" => "true", "data" => array('idachat' => $idachat)));
