<?php

session_start();

require_once 'initializeMollie.php';
include("all_kms_con.inc.php");


$payment    = $mollie->payments->get($_POST["id"]);

/*
 * The order ID saved in the payment can be used to load the order and update it's status
 */
$order_id = $payment->metadata->order_id;

if ($payment->isPaid())
{

 	$q_order_prijs = sprintf("SELECT kms_orders.totaalprijs, kms_orders.verzendwijze, kms_orders.status FROM kms_orders WHERE kms_orders.order_id = '%s'", $order_id);
	    $r_order_prijs = mysql_query($q_order_prijs);
		$rec_order_prijs = mysql_fetch_assoc($r_order_prijs);

        $betaald = "yes";

		if($rec_order_prijs['status'] != "voltooid"){

			if($rec_order_prijs['verzendwijze'] == "ophalen"){
				$status = "nog op te halen";
			}else{
				$status = "wacht op verzending";
			}

			$q_set_betaald = sprintf("UPDATE kms_orders SET betaald = '%s', status = '%s' WHERE kms_orders.order_id='%s'", $betaald, $status, $order_id);
			$r_set_betaald = mysql_query($q_set_betaald);
		}

}
elseif (! $payment->isOpen())
{
    /*
     * The payment isn't paid and isn't open anymore. We can assume it was aborted.
     */
	 
	 $q_set_betaald = sprintf("UPDATE kms_orders SET betaalstatus = '%s' WHERE kms_orders.order_id='%s'", $payment->status, $order_id);
	 $r_set_betaald = mysql_query($q_set_betaald);
}