the admin website doesn't show the "order" that was placed.

Code: Select all

               $sql = "select `order_status_id` from `order_status` where `name` = '?' and `language_id` = '?'";
                $parsed = $this->database->parse($sql, $this->language->get('order_status_pending'), $this->language->getId()); 
                $results = $this->database->getRow($parsed);
                if ($results)
                {
                    $pendingStatus = $results['order_status_id'];
                }
                //
                //  Perhaps the IPN from paypal has arrived before the user has returned from
                //  the paypal web site OR the user has not returned at all. 
                //  In response to either case, we should load and process the order.
                //             
		$reference = $this->request->get('invoice', 'post');
                if ($this->order->load($reference))
                {
                    //  IPN is winner or customer never returned and IPN arrived.
                    //  default status should be Pending so the update below will have no
                    //  effect if we process the order here but the end result is still correct.
                    $this->order->process(); 
                }
                
                $sql = "update `order` set `order_status_id` = '?' where `reference` = '?' and `order_status_id` = '?'";
                // bug fix from asif
	            //$parsed = $this->database->parse($sql, $paidUnconfirmedStatus, $reference, $pendingStatus);
                $parsed = $this->database->parse($sql,  $pendingStatus, $reference, $paidUnconfirmedStatus);
                $this->database->query($parsed);
			}

Code: Select all

<?php
// Text
$_['text_paypal_title'] = 'PayPal and Credit Card';
$_['order_status_paid_unconfirmed'] = 'Paid Unconfirmed';
$_['order_status_pending'] = 'Pending';
?>

Code: Select all

                //
                //  The payment is verified so we try to change the status from Paid Unconfirmed to Pending
                //  but only if the status is currently Paid Unconfirmed. A change to any other value
                //  has probably been made by the store administrator.
                //
                //  Remember also, that we are not relying on this to succeed and that it is being 
                //  executed by a callback from paypal. Hence there is no error recovery required.
                //  
                $paidUnconfirmedStatus = 0;
                $pendingStatus = 0;
                                   
                $sql = "select `order_status_id` from `order_status` where `name` = '?' and `language_id` = '?'";
                $parsed = $this->database->parse($sql, $this->language->get('order_status_paid_unconfirmed'), $this->language->getId()); 
                $results = $this->database->getRow($parsed);
                if ($results)
                {
                    $paidUnconfirmedStatus = $results['order_status_id'];
                }

                $sql = "select `order_status_id` from `order_status` where `name` = '?' and `language_id` = '?'";
                $parsed = $this->database->parse($sql, $this->language->get('order_status_pending'), $this->language->getId()); 
                $results = $this->database->getRow($parsed);
                if ($results)
                {
                    $pendingStatus = $results['order_status_id'];
                }

				$reference = $this->request->get('invoice', 'post');
                $sql = "update `order` set `order_status_id` = '?' where `reference` = '?' and `order_status_id` = '?'";
                // bug fix from asif
                //$parsed = $this->database->parse($sql, $paidUnconfirmedStatus, $reference, $pendingStatus);
                $parsed = $this->database->parse($sql,  $pendingStatus, $reference, $paidUnconfirmedStatus);
                $this->database->query($parsed);
			}
		}
  	}
}
?>