FATCHIP-GmbH / plugin-shopware5-klarna-checkout

     * @param string $userId

     * @return string $orderNumber

     */

    protected function getKlarnaOrderNumber($transactionId, $paymentUniqueId, $userId) {

        $sql = '

            SELECT ordernumber FROM s_order

            WHERE transactionID=? AND temporaryID=?

            AND status!=-1 AND userID=?

        ';

        $orderNumber = Shopware()->Db()->fetchOne($sql, array(

            $transactionId,

            $paymentUniqueId,

            $userId

        ));

        return $orderNumber;

    }

    /**

     *

     * @param string $userId

     * @return string $orderId

     */

    protected function getKlarnaOrderId($transactionId, $paymentUniqueId, $userId) {

        $sql = '

            SELECT id FROM s_order

            WHERE transactionID=? AND temporaryID=?

            AND status!=-1 AND userID=?

        ';

        $orderId = Shopware()->Db()->fetchOne($sql, array(

            $transactionId,

            $paymentUniqueId,

            $userId

        ));

        return $orderId;

    }

    /**