$result = $mysqli->query($query);
if (count($result) <= 0 || is_null($result)) {
echo '0';
exit;
}
if (!$result) {
echo 'ko';
exit;
}
foreach ($result as $i => $row) {
$result[$i]['employer'] = htmlspecialchars_decode($row['employer']);
}
$response = array('purchases' => array('purchase' => $result));
header('Content-type: text/xml');
echo $xml_dom->get_xml_from_array($response);
exit;
}
if ($_POST['action'] == 'confirm_payment') {
$employer = new Employer($_POST['id']);
$mysqli = Database::connect();
$query = "SELECT number_of_slot FROM employer_slots_purchases \n WHERE employer = '" . $employer->id() . "' AND transaction_id = '" . $_POST['txn_id'] . "' LIMIT 1";
$result = $mysqli->query($query);
$employer->add_slots($result[0]['number_of_slot']);
$query = "UPDATE employer_slots_purchases SET \n transaction_id = '" . $_POST['payment_id'] . "', \n purchased_on = NOW(), \n on_hold = 0 \n WHERE employer = '" . $employer->id() . "' AND transaction_id = '" . $_POST['txn_id'] . "'";
if ($mysqli->execute($query) === false) {
echo 'ko';
exit;
}
echo 'ok';
exit;
}
// fwrite($handle, 'Subject: '. $subject. "\n\n");
// fwrite($handle, $message);
// fclose($handle);
// 2. Update the purchase history
$query = "INSERT INTO employer_slots_purchases SET \n employer = '" . $employer_id . "', \n transaction_id = '" . $txn_id . "', \n purchased_on = '" . $purchased_on . "', \n price_per_slot = " . $price . ", \n number_of_slot = " . $qty . ", \n total_amount = " . $amount . ", \n on_hold = 0";
if ($mysqli->execute($query) === false) {
$handle = fopen($error_log_file, 'a');
fwrite($handle, date('Y-m-d H:i:s') . ' Unable to log transaction (txn_id: ' . $txn_id . ') for employer ' . $employer_id . '.' . "\n");
fclose($handle);
exit;
}
$handle = fopen($txn_log_file, 'a');
fwrite($handle, date('Y-m-d H:i:s') . ' Logged transaction (txn_id: ' . $txn_id . ') for employer ' . $employer_id . '.' . "\n");
fclose($handle);
// 3. Update the slots
if ($employer->add_slots($qty) === false) {
$handle = fopen($error_log_file, 'a');
fwrite($handle, date('Y-m-d H:i:s') . ' Unable to add ' . $qty . ' slots for employer ' . $employer_id . '.' . "\n");
fclose($handle);
exit;
}
$handle = fopen($txn_log_file, 'a');
fwrite($handle, date('Y-m-d H:i:s') . ' Added ' . $qty . ' slots for employer ' . $employer_id . '.' . "\n");
fclose($handle);
} else {
$handle = fopen($error_log_file, 'a');
fwrite($handle, date('Y-m-d H:i:s') . ' Either _POST[txn_id] or _POST[custom] is not found.' . "\n");
fclose($handle);
// $handle = fopen('/tmp/ipn_feedback.txt', 'w');
// foreach ($_POST as $key=>$value) {
// fwrite($handle, '['. $key. '] => '. $value. "\n");
