@@ 569-585 (lines=17) @@ | ||
566 | * @param string $sessionID |
|
567 | * @return bool |
|
568 | */ |
|
569 | protected function checkKlarnaOrderExistsBySession($sessionID) { |
|
570 | $sql = ' |
|
571 | SELECT * FROM s_order |
|
572 | WHERE userID=? |
|
573 | '; |
|
574 | ||
575 | $order = Shopware()->Db()->fetchAll($sql, array( |
|
576 | $sessionID |
|
577 | )); |
|
578 | ||
579 | $orderExists = (empty($order)) ? false : true; |
|
580 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession:",3); |
|
581 | if ($orderExists){ |
|
582 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession: Order Found: ",3, $order); |
|
583 | } |
|
584 | return $orderExists; |
|
585 | } |
|
586 | ||
587 | /** |
|
588 | * Method checks if certain klarna order exists or not |
|
@@ 594-610 (lines=17) @@ | ||
591 | * @param string $paymentUniqueId |
|
592 | * @return bool |
|
593 | */ |
|
594 | protected function checkKlarnaOrderExistsByReference($paymentUniqueId) { |
|
595 | $sql = ' |
|
596 | SELECT * FROM s_order |
|
597 | WHERE temporaryID=? |
|
598 | '; |
|
599 | ||
600 | $order = Shopware()->Db()->fetchAll($sql, array( |
|
601 | $paymentUniqueId |
|
602 | )); |
|
603 | ||
604 | $orderExists = (empty($order)) ? false : true; |
|
605 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference:",3); |
|
606 | if ($orderExists){ |
|
607 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference: Order Found: ",3, $order); |
|
608 | } |
|
609 | return $orderExists; |
|
610 | } |
|
611 | ||
612 | /** |
|
613 | * Method checks if certain klarna order exists or not |
|
@@ 619-635 (lines=17) @@ | ||
616 | * @param string $paymentUniqueId |
|
617 | * @return bool |
|
618 | */ |
|
619 | protected function checkKlarnaOrderExistsByReservation($transactionId) { |
|
620 | $sql = ' |
|
621 | SELECT * FROM s_order |
|
622 | WHERE transactionID=? |
|
623 | '; |
|
624 | ||
625 | $order = Shopware()->Db()->fetchAll($sql, array( |
|
626 | $transactionId |
|
627 | )); |
|
628 | ||
629 | $orderExists = (empty($order)) ? false : true; |
|
630 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation:",3); |
|
631 | if ($orderExists){ |
|
632 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation: Order Found: ",3, $order); |
|
633 | } |
|
634 | return $orderExists; |
|
635 | } |
|
636 | ||
637 | /** |
|
638 | * Method checks if certain klarna order exists or not |
|
@@ 669-686 (lines=18) @@ | ||
666 | * @param string $sessionID |
|
667 | * @return bool |
|
668 | */ |
|
669 | protected function checkKlarnaOrderDetailsBySession($sessionID) { |
|
670 | $sql = ' |
|
671 | SELECT * FROM s_order |
|
672 | LEFT JOIN s_order_details ON s_order.id = s_order_details.orderID |
|
673 | WHERE userID=? |
|
674 | '; |
|
675 | ||
676 | $orderDetails = Shopware()->Db()->fetchAll($sql, array( |
|
677 | $sessionID |
|
678 | )); |
|
679 | ||
680 | $orderExists = (empty($orderDetails)) ? false : true; |
|
681 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession:",3); |
|
682 | if ($orderExists){ |
|
683 | $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession: OrderDetails Found: ",3, $orderDetails); |
|
684 | } |
|
685 | return $orderExists; |
|
686 | } |
|
687 | ||
688 | /** |
|
689 | * Method checks if certain klarna order exists or not |