label:1.update_info:1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
checking status for  1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
result SELECT * FROM myTracker WHERE wpreferer='1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8' :
sending https://sandbox.finpay.co.id/servicescode/api/checkFinpay.php
[{"merchant_id":"ZORA484","pay_date":"","invoice":"273-16-Mtx5","amount":0,"sof_id":null,"payment_code":null,"ref_no":null,"result_code":"99","result_desc":"Unknown Status","add_info1":"info1","add_info2":"info1","add_info3":"info5","add_info4":"273","add_info5":"1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8","payment_source":null}]
<pre>Array
(
    [0] => Array
        (
            [merchant_id] => ZORA484
            [pay_date] => 
            [invoice] => 273-16-Mtx5
            [amount] => 0
            [sof_id] => 
            [payment_code] => 
            [ref_no] => 
            [result_code] => 99
            [result_desc] => Unknown Status
            [add_info1] => info1
            [add_info2] => info1
            [add_info3] => info5
            [add_info4] => 273
            [add_info5] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
            [payment_source] => 
        )

)
UPDATE myTracker SET trxStatus='',fullResponse='[{"merchant_id":"ZORA484","pay_date":"","invoice":"273-16-Mtx5","amount":0,"sof_id":null,"payment_code":null,"ref_no":null,"result_code":"99","result_desc":"Unknown Status","add_info1":"info1","add_info2":"info1","add_info3":"info5","add_info4":"273","add_info5":"1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8","payment_source":null}]' WHERE invoiceNo=''
end of checking status for 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
<pre>Array
(
    [0] => Array
        (
            [merchant_id] => ZORA484
            [pay_date] => 
            [invoice] => 273-16-Mtx5
            [amount] => 0
            [sof_id] => 
            [payment_code] => 
            [ref_no] => 
            [result_code] => 99
            [result_desc] => Unknown Status
            [add_info1] => info1
            [add_info2] => info1
            [add_info3] => info5
            [add_info4] => 273
            [add_info5] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
            [payment_source] => 
        )

)
<pre>Array
(
    [e_reg_url_link] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
    [ee_payment_method] => paypal_standard
    [mc_gross] => 
    [protection_eligibility] => Eligible
    [item_number1] => 
    [tax] => 
    [item_number2] => 
    [payer_id] => 
    [payment_date] => 
    [option_name2_2] => 
    [payment_status] => Completed
    [option_selection1_2] => 
    [charset] => windows-1252
    [mc_shipping] => 0
    [first_name] => 
    [mc_fee] => 0
    [notify_version] => 3.9
    [custom] => 
    [payer_status] => verified
    [business] => 
    [num_cart_items] => 2
    [verify_sign] => AvhaW0DUifN7xX6fk5ErDQ53UzaHARjU.mZ9WduYK9mgWGZrs-iHcmv4
    [payer_email] => sb-47ev38606994@personal.example.com
    [mc_shipping1] => 0
    [mc_shipping2] => 0
    [option_name1_2] => 
    [txn_id] => 
    [payment_type] => instant
    [last_name] => 
    [option_selection2_2] => 
    [item_name1] => 
    [receiver_email] => sb-sleau269987@business.example.com
    [item_name2] => 
    [payment_fee] => 0
    [shipping_discount] => 0
    [quantity1] => 
    [insurance_amount] => 0
    [quantity2] => 1
    [receiver_id] => 
    [txn_type] => cart
    [discount] => 0
    [mc_gross_1] => 
    [mc_currency] => 
    [mc_gross_2] => 
    [residence_country] => ID
    [test_ipn] => 1
    [shipping_method] => Default
    [transaction_subject] => 
    [payment_gross] => 
    [ipn_track_id] => 
)
case1:empty(update_info[payment_status]) || empty(update_info[txn_id]

label:1.update_info:1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
checking status for  1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
result SELECT * FROM myTracker WHERE wpreferer='1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8' :
sending http://finpaySim.apollo-soft.com/checkStatus.php


{"merchant_id":null,"pay_date":null,"invoice":null,"amount":null,"sof_id":null,"result_code":"101","result_desc":"POST DATA doesnt exist","payment_code":null,"ref_no":null,"add_info1":null,"add_info2":null,"add_info3":null,"add_info4":null,"add_info5":null,"payment_source":null}
<pre>Array
(
    [merchant_id] => 
    [pay_date] => 
    [invoice] => 
    [amount] => 
    [sof_id] => 
    [result_code] => 101
    [result_desc] => POST DATA doesnt exist
    [payment_code] => 
    [ref_no] => 
    [add_info1] => 
    [add_info2] => 
    [add_info3] => 
    [add_info4] => 
    [add_info5] => 
    [payment_source] => 
)
</pre>UPDATE myTracker SET trxStatus='101',fullResponse='

{"merchant_id":null,"pay_date":null,"invoice":null,"amount":null,"sof_id":null,"result_code":"101","result_desc":"POST DATA doesnt exist","payment_code":null,"ref_no":null,"add_info1":null,"add_info2":null,"add_info3":null,"add_info4":null,"add_info5":null,"payment_source":null}' WHERE invoiceNo='273-16-Mtx5'
end of checking status for 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
<pre>Array
(
    [e_reg_url_link] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
    [ee_payment_method] => paypal_standard
    [mc_gross] => 
    [protection_eligibility] => Eligible
    [item_number1] => 
    [tax] => 0
    [item_number2] => 
    [payer_id] => duff_mcKagan
    [payment_date] => 
    [option_name2_2] => RETURN URL
    [payment_status] => Completed
    [option_selection1_2] => hgc.apollo-soft.com/transactions/?e_reg_url_link=1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8&ee_payment_method=paypal_standard
    [charset] => windows-1252
    [mc_shipping] => 0
    [first_name] => 
    [mc_fee] => 0
    [notify_version] => 3.9
    [custom] => 
    [payer_status] => verified
    [business] => sb-sleau269987@business.example.com
    [num_cart_items] => 2
    [verify_sign] => AvhaW0DUifN7xX6fk5ErDQ53UzaHARjU.mZ9WduYK9mgWGZrs-iHcmv4
    [payer_email] => sb-47ev38606994@personal.example.com
    [mc_shipping1] => 0
    [mc_shipping2] => 0
    [option_name1_2] => NOTIFY URL
    [txn_id] => 
    [payment_type] => instant
    [last_name] => Duff McKagan
    [option_selection2_2] => hgc.apollo-soft.com/?uts=&step=payment_options&action=process_gateway_response&selected_method_of_payment=paypal_standard&spco_txn=273#checkout
    [item_name1] => 
    [receiver_email] => sb-sleau269987@business.example.com
    [item_name2] => DEBUG INFO (this item only added in sandbox mode
    [payment_fee] => 0
    [shipping_discount] => 0
    [quantity1] => 1
    [insurance_amount] => 0
    [quantity2] => 1
    [receiver_id] => 
    [txn_type] => cart
    [discount] => 0
    [mc_gross_1] => 100.000
    [mc_currency] => USD
    [mc_gross_2] => 0
    [residence_country] => ID
    [test_ipn] => 1
    [shipping_method] => Default
    [transaction_subject] => 
    [payment_gross] => 100.000
    [ipn_track_id] => 
)
</pre>label:1.update_info:1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
checking status for  1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
result SELECT * FROM myTracker WHERE wpreferer='1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8' :
sending https://sandbox.finpay.co.id/servicescode/api/checkFinpay.php
[{"merchant_id":"ZORA484","pay_date":"","invoice":"273-16-Mtx5","amount":0,"sof_id":null,"payment_code":null,"ref_no":null,"result_code":"99","result_desc":"Unknown Status","add_info1":"info1","add_info2":"info1","add_info3":"info5","add_info4":"273","add_info5":"1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8","payment_source":null}]
<pre>Array
(
    [0] => Array
        (
            [merchant_id] => ZORA484
            [pay_date] => 
            [invoice] => 273-16-Mtx5
            [amount] => 0
            [sof_id] => 
            [payment_code] => 
            [ref_no] => 
            [result_code] => 99
            [result_desc] => Unknown Status
            [add_info1] => info1
            [add_info2] => info1
            [add_info3] => info5
            [add_info4] => 273
            [add_info5] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
            [payment_source] => 
        )

)
UPDATE myTracker SET trxStatus='',fullResponse='[{"merchant_id":"ZORA484","pay_date":"","invoice":"273-16-Mtx5","amount":0,"sof_id":null,"payment_code":null,"ref_no":null,"result_code":"99","result_desc":"Unknown Status","add_info1":"info1","add_info2":"info1","add_info3":"info5","add_info4":"273","add_info5":"1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8","payment_source":null}]' WHERE invoiceNo=''
end of checking status for 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
<pre>Array
(
    [0] => Array
        (
            [merchant_id] => ZORA484
            [pay_date] => 
            [invoice] => 273-16-Mtx5
            [amount] => 0
            [sof_id] => 
            [payment_code] => 
            [ref_no] => 
            [result_code] => 99
            [result_desc] => Unknown Status
            [add_info1] => info1
            [add_info2] => info1
            [add_info3] => info5
            [add_info4] => 273
            [add_info5] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
            [payment_source] => 
        )

)
<pre>Array
(
    [e_reg_url_link] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
    [ee_payment_method] => paypal_standard
    [mc_gross] => 
    [protection_eligibility] => Eligible
    [item_number1] => 
    [tax] => 
    [item_number2] => 
    [payer_id] => 
    [payment_date] => 
    [option_name2_2] => 
    [payment_status] => Completed
    [option_selection1_2] => 
    [charset] => windows-1252
    [mc_shipping] => 0
    [first_name] => 
    [mc_fee] => 0
    [notify_version] => 3.9
    [custom] => 
    [payer_status] => verified
    [business] => 
    [num_cart_items] => 2
    [verify_sign] => AvhaW0DUifN7xX6fk5ErDQ53UzaHARjU.mZ9WduYK9mgWGZrs-iHcmv4
    [payer_email] => sb-47ev38606994@personal.example.com
    [mc_shipping1] => 0
    [mc_shipping2] => 0
    [option_name1_2] => 
    [txn_id] => 
    [payment_type] => instant
    [last_name] => 
    [option_selection2_2] => 
    [item_name1] => 
    [receiver_email] => sb-sleau269987@business.example.com
    [item_name2] => 
    [payment_fee] => 0
    [shipping_discount] => 0
    [quantity1] => 
    [insurance_amount] => 0
    [quantity2] => 1
    [receiver_id] => 
    [txn_type] => cart
    [discount] => 0
    [mc_gross_1] => 
    [mc_currency] => 
    [mc_gross_2] => 
    [residence_country] => ID
    [test_ipn] => 1
    [shipping_method] => Default
    [transaction_subject] => 
    [payment_gross] => 
    [ipn_track_id] => 
)
case1:empty(update_info[payment_status]) || empty(update_info[txn_id]

label:1.update_info:1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
checking status for  1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
result SELECT * FROM myTracker WHERE wpreferer='1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8' :
sending http://finpaySim.apollo-soft.com/checkStatus.php


{"merchant_id":null,"pay_date":null,"invoice":null,"amount":null,"sof_id":null,"result_code":"101","result_desc":"POST DATA doesnt exist","payment_code":null,"ref_no":null,"add_info1":null,"add_info2":null,"add_info3":null,"add_info4":null,"add_info5":null,"payment_source":null}
<pre>Array
(
    [merchant_id] => 
    [pay_date] => 
    [invoice] => 
    [amount] => 
    [sof_id] => 
    [result_code] => 101
    [result_desc] => POST DATA doesnt exist
    [payment_code] => 
    [ref_no] => 
    [add_info1] => 
    [add_info2] => 
    [add_info3] => 
    [add_info4] => 
    [add_info5] => 
    [payment_source] => 
)
</pre>UPDATE myTracker SET trxStatus='101',fullResponse='

{"merchant_id":null,"pay_date":null,"invoice":null,"amount":null,"sof_id":null,"result_code":"101","result_desc":"POST DATA doesnt exist","payment_code":null,"ref_no":null,"add_info1":null,"add_info2":null,"add_info3":null,"add_info4":null,"add_info5":null,"payment_source":null}' WHERE invoiceNo='273-16-Mtx5'
end of checking status for 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
<pre>Array
(
    [e_reg_url_link] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
    [ee_payment_method] => paypal_standard
    [mc_gross] => 
    [protection_eligibility] => Eligible
    [item_number1] => 
    [tax] => 0
    [item_number2] => 
    [payer_id] => duff_mcKagan
    [payment_date] => 
    [option_name2_2] => RETURN URL
    [payment_status] => Completed
    [option_selection1_2] => hgc.apollo-soft.com/transactions/?e_reg_url_link=1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8&ee_payment_method=paypal_standard
    [charset] => windows-1252
    [mc_shipping] => 0
    [first_name] => 
    [mc_fee] => 0
    [notify_version] => 3.9
    [custom] => 
    [payer_status] => verified
    [business] => sb-sleau269987@business.example.com
    [num_cart_items] => 2
    [verify_sign] => AvhaW0DUifN7xX6fk5ErDQ53UzaHARjU.mZ9WduYK9mgWGZrs-iHcmv4
    [payer_email] => sb-47ev38606994@personal.example.com
    [mc_shipping1] => 0
    [mc_shipping2] => 0
    [option_name1_2] => NOTIFY URL
    [txn_id] => 
    [payment_type] => instant
    [last_name] => Duff McKagan
    [option_selection2_2] => hgc.apollo-soft.com/?uts=&step=payment_options&action=process_gateway_response&selected_method_of_payment=paypal_standard&spco_txn=273#checkout
    [item_name1] => 
    [receiver_email] => sb-sleau269987@business.example.com
    [item_name2] => DEBUG INFO (this item only added in sandbox mode
    [payment_fee] => 0
    [shipping_discount] => 0
    [quantity1] => 1
    [insurance_amount] => 0
    [quantity2] => 1
    [receiver_id] => 
    [txn_type] => cart
    [discount] => 0
    [mc_gross_1] => 100.000
    [mc_currency] => USD
    [mc_gross_2] => 0
    [residence_country] => ID
    [test_ipn] => 1
    [shipping_method] => Default
    [transaction_subject] => 
    [payment_gross] => 100.000
    [ipn_track_id] => 
)
</pre>label:1.update_info:1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
checking status for  1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
result SELECT * FROM myTracker WHERE wpreferer='1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8' :
sending https://sandbox.finpay.co.id/servicescode/api/checkFinpay.php
[{"merchant_id":"ZORA484","pay_date":"","invoice":"273-16-Mtx5","amount":0,"sof_id":null,"payment_code":null,"ref_no":null,"result_code":"99","result_desc":"Unknown Status","add_info1":"info1","add_info2":"info1","add_info3":"info5","add_info4":"273","add_info5":"1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8","payment_source":null}]
<pre>Array
(
    [0] => Array
        (
            [merchant_id] => ZORA484
            [pay_date] => 
            [invoice] => 273-16-Mtx5
            [amount] => 0
            [sof_id] => 
            [payment_code] => 
            [ref_no] => 
            [result_code] => 99
            [result_desc] => Unknown Status
            [add_info1] => info1
            [add_info2] => info1
            [add_info3] => info5
            [add_info4] => 273
            [add_info5] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
            [payment_source] => 
        )

)
UPDATE myTracker SET trxStatus='',fullResponse='[{"merchant_id":"ZORA484","pay_date":"","invoice":"273-16-Mtx5","amount":0,"sof_id":null,"payment_code":null,"ref_no":null,"result_code":"99","result_desc":"Unknown Status","add_info1":"info1","add_info2":"info1","add_info3":"info5","add_info4":"273","add_info5":"1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8","payment_source":null}]' WHERE invoiceNo=''
end of checking status for 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
<pre>Array
(
    [0] => Array
        (
            [merchant_id] => ZORA484
            [pay_date] => 
            [invoice] => 273-16-Mtx5
            [amount] => 0
            [sof_id] => 
            [payment_code] => 
            [ref_no] => 
            [result_code] => 99
            [result_desc] => Unknown Status
            [add_info1] => info1
            [add_info2] => info1
            [add_info3] => info5
            [add_info4] => 273
            [add_info5] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
            [payment_source] => 
        )

)
<pre>Array
(
    [e_reg_url_link] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
    [ee_payment_method] => paypal_standard
    [mc_gross] => 
    [protection_eligibility] => Eligible
    [item_number1] => 
    [tax] => 
    [item_number2] => 
    [payer_id] => 
    [payment_date] => 
    [option_name2_2] => 
    [payment_status] => Completed
    [option_selection1_2] => 
    [charset] => windows-1252
    [mc_shipping] => 0
    [first_name] => 
    [mc_fee] => 0
    [notify_version] => 3.9
    [custom] => 
    [payer_status] => verified
    [business] => 
    [num_cart_items] => 2
    [verify_sign] => AvhaW0DUifN7xX6fk5ErDQ53UzaHARjU.mZ9WduYK9mgWGZrs-iHcmv4
    [payer_email] => sb-47ev38606994@personal.example.com
    [mc_shipping1] => 0
    [mc_shipping2] => 0
    [option_name1_2] => 
    [txn_id] => 
    [payment_type] => instant
    [last_name] => 
    [option_selection2_2] => 
    [item_name1] => 
    [receiver_email] => sb-sleau269987@business.example.com
    [item_name2] => 
    [payment_fee] => 0
    [shipping_discount] => 0
    [quantity1] => 
    [insurance_amount] => 0
    [quantity2] => 1
    [receiver_id] => 
    [txn_type] => cart
    [discount] => 0
    [mc_gross_1] => 
    [mc_currency] => 
    [mc_gross_2] => 
    [residence_country] => ID
    [test_ipn] => 1
    [shipping_method] => Default
    [transaction_subject] => 
    [payment_gross] => 
    [ipn_track_id] => 
)
case1:empty(update_info[payment_status]) || empty(update_info[txn_id]

label:1.update_info:1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
checking status for  1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
result SELECT * FROM myTracker WHERE wpreferer='1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8' :
sending http://finpaySim.apollo-soft.com/checkStatus.php


{"merchant_id":null,"pay_date":null,"invoice":null,"amount":null,"sof_id":null,"result_code":"101","result_desc":"POST DATA doesnt exist","payment_code":null,"ref_no":null,"add_info1":null,"add_info2":null,"add_info3":null,"add_info4":null,"add_info5":null,"payment_source":null}
<pre>Array
(
    [merchant_id] => 
    [pay_date] => 
    [invoice] => 
    [amount] => 
    [sof_id] => 
    [result_code] => 101
    [result_desc] => POST DATA doesnt exist
    [payment_code] => 
    [ref_no] => 
    [add_info1] => 
    [add_info2] => 
    [add_info3] => 
    [add_info4] => 
    [add_info5] => 
    [payment_source] => 
)
</pre>UPDATE myTracker SET trxStatus='101',fullResponse='

{"merchant_id":null,"pay_date":null,"invoice":null,"amount":null,"sof_id":null,"result_code":"101","result_desc":"POST DATA doesnt exist","payment_code":null,"ref_no":null,"add_info1":null,"add_info2":null,"add_info3":null,"add_info4":null,"add_info5":null,"payment_source":null}' WHERE invoiceNo='273-16-Mtx5'
end of checking status for 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
<pre>Array
(
    [e_reg_url_link] => 1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8
    [ee_payment_method] => paypal_standard
    [mc_gross] => 
    [protection_eligibility] => Eligible
    [item_number1] => 
    [tax] => 0
    [item_number2] => 
    [payer_id] => duff_mcKagan
    [payment_date] => 
    [option_name2_2] => RETURN URL
    [payment_status] => Completed
    [option_selection1_2] => hgc.apollo-soft.com/transactions/?e_reg_url_link=1-IwqR2SqY4LtxAIlsbVFaWNdSG5bo2sI8&ee_payment_method=paypal_standard
    [charset] => windows-1252
    [mc_shipping] => 0
    [first_name] => 
    [mc_fee] => 0
    [notify_version] => 3.9
    [custom] => 
    [payer_status] => verified
    [business] => sb-sleau269987@business.example.com
    [num_cart_items] => 2
    [verify_sign] => AvhaW0DUifN7xX6fk5ErDQ53UzaHARjU.mZ9WduYK9mgWGZrs-iHcmv4
    [payer_email] => sb-47ev38606994@personal.example.com
    [mc_shipping1] => 0
    [mc_shipping2] => 0
    [option_name1_2] => NOTIFY URL
    [txn_id] => 
    [payment_type] => instant
    [last_name] => Duff McKagan
    [option_selection2_2] => hgc.apollo-soft.com/?uts=&step=payment_options&action=process_gateway_response&selected_method_of_payment=paypal_standard&spco_txn=273#checkout
    [item_name1] => 
    [receiver_email] => sb-sleau269987@business.example.com
    [item_name2] => DEBUG INFO (this item only added in sandbox mode
    [payment_fee] => 0
    [shipping_discount] => 0
    [quantity1] => 1
    [insurance_amount] => 0
    [quantity2] => 1
    [receiver_id] => 
    [txn_type] => cart
    [discount] => 0
    [mc_gross_1] => 100.000
    [mc_currency] => USD
    [mc_gross_2] => 0
    [residence_country] => ID
    [test_ipn] => 1
    [shipping_method] => Default
    [transaction_subject] => 
    [payment_gross] => 100.000
    [ipn_track_id] => 
)
</pre>