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, [

            $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, [

            $transactionId,

            $paymentUniqueId,

            $userId,

        ]);

        return $orderId;

    }