FATCHIP-GmbH / plugin-shopware5-klarna-checkout

     * @param string $sessionID

     * @return bool

     */

    protected function checkKlarnaOrderExistsBySession($sessionID) {

        $sql = '

            SELECT * FROM s_order

            WHERE userID=?

        ';

        $order = Shopware()->Db()->fetchAll($sql, array(

                $sessionID

        ));

        $orderExists = (empty($order)) ? false : true;

        $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession:",3);   

        if ($orderExists){

            $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsBySession: Order Found: ",3, $order);   

        }

        return $orderExists;

    }    

    /**

     * Method checks if certain klarna order exists or not

     * @param string $paymentUniqueId

     * @return bool

     */

    protected function checkKlarnaOrderExistsByReference($paymentUniqueId) {

        $sql = '

            SELECT * FROM s_order

            WHERE temporaryID=?

        ';

        $order = Shopware()->Db()->fetchAll($sql, array(

                $paymentUniqueId

        ));

        $orderExists = (empty($order)) ? false : true;

        $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference:",3);   

        if ($orderExists){

            $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReference: Order Found: ",3, $order);   

        }

        return $orderExists;

    }

    /**

     * Method checks if certain klarna order exists or not

     * @param string $paymentUniqueId

     * @return bool

     */

    protected function checkKlarnaOrderExistsByReservation($transactionId) {

        $sql = '

            SELECT * FROM s_order

            WHERE transactionID=?

        ';

        $order = Shopware()->Db()->fetchAll($sql, array(

                $transactionId

        ));

        $orderExists = (empty($order)) ? false : true;

        $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation:",3);   

        if ($orderExists){

            $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderExistsByReservation: Order Found: ",3, $order);   

        }

        return $orderExists;

    }    

    /**

     * Method checks if certain klarna order exists or not

     * @param string $sessionID

     * @return bool

     */

    protected function checkKlarnaOrderDetailsBySession($sessionID) {

        $sql = '

            SELECT * FROM s_order

            LEFT JOIN s_order_details ON s_order.id = s_order_details.orderID

            WHERE userID=?

        ';

        $orderDetails = Shopware()->Db()->fetchAll($sql, array(

                $sessionID

        ));

        $orderExists = (empty($orderDetails)) ? false : true;

        $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession:",3);   

        if ($orderExists){

            $this->plugin->klarnaLog("Shopware_Controllers_Frontend_PaymentKlarna::checkKlarnaOrderDetailsBySession: OrderDetails Found: ",3, $orderDetails);

        }

        return $orderExists;

    }     

    /**

     * Notify action method