merchant-commission/jsonMerchantCommission.php at master · bd-php/merchant-commission · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<?php

require "connect.php";

$query = "SELECT pay_time, bin_issuer, payment_type, pay_status, ROUND(50 - charge) AS amount FROM m_transaction
	WHERE pay_time > '1499146533'
	  AND pay_time < '1502981285'
		AND pay_status = 'Successful'
			LIMIT 10";

$stmt = $pdo->query($query);

$var = "";

$var = "{" . "\n";
$i = 1;

// Json Response

$var = $var . '"data"' . ":[" . "\n";
while ($row = $stmt->fetch()) {
    $var = $var . "[" . "\n";
    $var = $var . '"' . $i . '",' . "\n";
    $payTime = $row['pay_time'];
    $var = $var . '"' . $payTime . '",' . "\n";

    $binIssuer = $row['bin_issuer'];
    $binIssuer = ($binIssuer == null) ? 'NA' : $binIssuer;
    $var = $var . '"' . $binIssuer . '",' . "\n";

    $paymentType = $row['payment_type'];
    $paymentType = ($paymentType == null) ? 'NA' : $paymentType;
    $var = $var . '"' . $paymentType . '",' . "\n";

    $payStatus = $row['pay_status'];
    $payStatus = ($payStatus == null) ? 'NA' : $payStatus;
    $var = $var . '"' . $payStatus . '",' . "\n";

    $amount = $row['amount'];
    $var = $var . '"' . $amount . '"' . "\n";
    $var = $var . "]," . "\n";
    $i++;
}
$var = $var . "]" . "\n";
$var = $var . "}";


$var[strlen($var) - 5] = " ";
echo $var;