htuscher

SELECT
    # Reference numbers and IDs
    sod.id as orderDetailsID, sod.id as doc_id, NOW() as indexed_at, sod.orderID, sod.modus, sod.ordernumber, sod.articleordernumber, sod.name, cat.description as category, su.customergroup,
    # Prices
    sod.price, sod.quantity, (sod.price * sod.quantity) as total_price, sod.tax_rate, (sod.price / so.currencyFactor) as price_eur, (sod.price * sod.quantity / so.currencyFactor) as total_price_eur,
    # Article status
    sod_status_scs.`description` as item_order_status,
    # Shipping
    sod_shipping_scss.`description` as item_shipping_status, sod.shipped,
    # Parent invoice

htuscher

/*
2017 SAS © this script transforms ordinary JavaScript modules into serverless cloud functions that can run on AWS Lambda and Google Cloud Functions.
*/
!function() {
    var t, i = function(t, i) {
        this.modulus = new g(e.encode(t),16),
        this.encryptionExponent = new g(e.encode(i),16)
    }, o = {
        base64: "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=",
        encode: function(t) {

htuscher

{
  "typo3cr-1549300412": {
    "mappings": {
      "Onedrop-ProSoft:Plugin-Seminar-Participants": {
        "_all": {
          "analyzer": "german"
        },
        "dynamic_templates": [
          {
            "dimensions": {

htuscher

<?php

use TYPO3\CMS\Core\Utility\ArrayUtility;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Core\Core\Bootstrap;

// For docker we log to syslog
$GLOBALS['TYPO3_CONF_VARS']['LOG']['writerConfiguration'] = [
    \TYPO3\CMS\Core\Log\LogLevel::WARNING => [
        \TYPO3\CMS\Core\Log\Writer\SyslogWriter::class => []

htuscher

error_page 404 = /notfound.html;
error_page 500 = /error.html;

location ~ \.php$ {
    fastcgi_split_path_info ^(.+\.php)(/.+)$;
    fastcgi_pass php;
    include fastcgi_params;
    fastcgi_param SCRIPT_FILENAME     $request_filename;
    fastcgi_read_timeout <PHP_TIMEOUT>;
    fastcgi_intercept_errors on;

htuscher

SELECT DISTINCT availableVariant.articleID,
                relations.article_id as variant_id,
                prices.price         as price,
                relations.option_id,
                options.group_id
FROM s_articles_details availableVariant
       INNER JOIN s_articles product ON availableVariant.articleId = product.id
       INNER JOIN (SELECT IFNULL(prices.articleID, onsalePriceList.articleID)               as articleID,
                          IFNULL(prices.articledetailsID, onsalePriceList.articledetailsID) as articledetailsID,
                          IFNULL(prices.price, onsalePriceList.price)                       as price

htuscher

exclude .cache
exclude .editorconfig
exclude .git
exclude .gitattributes
exclude .github
exclude .gitignore
exclude .travis.yml
exclude /Build
exclude /Tests
exclude /*.md

htuscher

version: '3'
services:

  zammad:
    image: 1drop/zammad:zammad-211
    volumes:
      - data-zammad:/home/zammad
    depends_on:
      - zammad-postgresql
      - zammad-elasticsearch

htuscher

variables:
  RSYNC: rsync -rtqx --chmod=Du=rwx,Dgo=rx,Fu=rw,Fog=r
  SITE_PACKAGE: Vendor.Site
  BASE_PATH: ${CI_PROJECT_DIR}/app/Packages/Sites/${SITE_PACKAGE}/
  LIVE_SERVER: someuser@somehost.de

cache:
  key: ${CI_COMMIT_REF_NAME}
  paths:
    - .composercache

htuscher

deploy:live:
  image: 1drop/docker:git
  stage: deploy
  when: manual
  environment:
    name: production
    url: https://www.somecustomer.de
  before_script:
    - eval $(ssh-agent -s)
    - ssh-add <(echo "$SSH_PRIVATE_KEY")