Orders Found: " . db_num_rows($orders) . "
\n"); echo("Payment validated ok - updating database
\n"); // Update paypal_payments database table $now = time(); $p_mc_fee = floatval($p_mc_fee); $query = "UPDATE user_online_payments " . "SET status = 'Paid', payment_amount = balance_owing, reference = '{$p_txn_id}', trx_fee = {$p_mc_fee}, completed_time = $now " . "WHERE record_num = $trxID"; db_query($query); $today = date("Y-m-d",$now); $order_payments = ""; $snum = 0; if (db_num_rows($orders) > 0) { while ($row = db_fetch_array($orders)) { $onum = $row['record_num']; $ototal = $row['order_total']; $opaid = $row['amount_paid']; $snum = $row['schedule_num']; $amt = number_format($ototal - $opaid,2); if (strlen($order_payments) > 0) $order_payments .= "|"; $order_payments .= "{" . $onum . ":" . $amt . "}"; $query = "UPDATE hotlunch_order_header " . "SET amount_paid = order_total, " . "status = 'Paid', " . "paid_date = '$today', " . "payment_method = 'PayPal' " . "WHERE record_num = {$onum}"; db_query($query); } } // Post transaction to the user_account date_default_timezone_set($school_record['timezone']); $trx_time = date("Y-m-d H:i:s",$now); $entered_time = $now; // Post transaction fee if there is one if (isset($p_transaction_fee) && $p_transaction_fee != 0) { if ($p_transaction_fee > 0) { $query = "INSERT INTO user_account " . "(school_num,user_num,schedule_num,transaction_datetime,transaction_type,transaction_status,note,transaction_amount,amount_paid,transaction_fee,payment_method,payment_reference,order_payments,deleted,entered_time) " . "VALUES ($p_school_num,$p_user_num,$snum,'$trx_time','PayPal Transaction Fee','Closed','',$p_transaction_fee,$p_transaction_fee,0,'PayPal','$p_txn_id',NULL,'N',$entered_time)"; } else { $query = "INSERT INTO user_account " . "(school_num,user_num,schedule_num,transaction_datetime,transaction_type,transaction_status,note,transaction_amount,amount_paid,transaction_fee,payment_method,payment_reference,order_payments,deleted,entered_time) " . "VALUES ($p_school_num,$p_user_num,$snum,'$trx_time','PayPal Transaction Credit','Closed','',$p_transaction_fee,$p_transaction_fee,0,'PayPal','$p_txn_id',NULL,'N',$entered_time)"; } pp_query($query); $entered_time += 1; $trx_time = date("Y-m-d H:i:s",$entered_time); } $amount = $p_mc_gross * -1; $query = "INSERT INTO user_account " . "(school_num,user_num,schedule_num,transaction_datetime,transaction_type,note,transaction_amount,transaction_fee,payment_method,payment_reference,order_payments,deleted,entered_time,transaction_status) " . "VALUES ($p_school_num,$p_user_num,$snum,'$trx_time','Payment','PayPal Payment',$amount,$p_mc_fee,'PayPal','$p_txn_id','$order_payments','N',$entered_time,'Closed')"; db_query($query); // Make activity_log entry $username = db_getVal("SELECT userid FROM users WHERE school_num = $base_school_num AND record_num = $p_user_num"); $activity = "PayPal Payment"; $additional_info = "TRX ID: $p_txn_id\nAmount: " . number_format(abs($amount),2) . "\n"; $curr_time = $now; $activity_datetime = date("Y-m-d H:i:s",$curr_time); $query = "insert into activity_log (school_num,userid,user_ip,activity_time,activity_datetime,activity,information) " . "values($p_school_num,'$username','0.0.0.0',$curr_time,'$activity_datetime','$activity','$additional_info')"; db_query($query); $query = "update users set trx_status = NULL where school_num = $p_school_num and record_num = $p_user_num"; db_query($query); // Update user_paypal_transactions db_query("UPDATE user_paypal_transactions SET posting_message = 'Payment processed ok' WHERE record_num = $trxID"); db_query("UPDATE user_paypal_transactions SET posting_result = 'Posted' WHERE record_num = $trxID"); echo("Payment processed and posted ok
\n"); echo("\n"); header("Location: ?action=paypal-log-errors"); exit(); endTemplate(); ?>