Skip to content

Instantly share code, notes, and snippets.

View svschannak's full-sized avatar

Sven Schannak svschannak

View GitHub Profile
<pap name="Lohnsteuer2019Big" version="1.0" versionnummer="1.0">
<variables>
<!-- Stand: 2018-11-12 -->
<!-- ITZBund Düsseldorf-->
<!-- EINGABEPARAMETER -->
<inputs>
<!-- 1, wenn die Anwendung des Faktorverfahrens gewählt wurden (nur in Steuerklasse IV) -->
<input name="af" type="int" default="1"/>
@svschannak
svschannak / update_pickware.sql
Created June 14, 2019 12:44
update_pickware.sql
UPDATE db_web1_1.pickware_erp_warehouse_article_detail_configurations pew
JOIN (SELECT sod.name name,
pew.articleDetailId detailID,
pew.minimumStock minimumStock,
SUM(sod.quantity) sum_quantity
FROM db_web1_1.s_order_details sod
JOIN db_web1_1.s_order so ON sod.orderID = so.id
JOIN db_web1_1.s_articles_details sad ON sod.articleordernumber = sad.ordernumber
JOIN db_web1_1.s_articles_attributes saa ON sad.id = saa.articledetailsID
@svschannak
svschannak / _redirects
Created January 22, 2019 12:24
Redirects for netlify and react router
/* /index.html 200
@svschannak
svschannak / dokku-subtree.sh
Created January 16, 2019 09:06
Dokku & netlify subdirectory deployment
git subtree push --prefix backend subdomain master
(cd frontend && exec yarn run build)
(cd frontend && exec netlify deploy --dir=./build --prod)
@svschannak
svschannak / xd_text_randomizer.js
Created October 25, 2018 15:47
XD text randomizer
function randomizeText(selection, documentRoot) {
documentRoot.children.forEach(node => {
// [1]
if (node instanceof Artboard) {
// [2]
let artboard = node;
let rectangles = artboard.children.filter(artboardChild => {
// [3]
return artboardChild instanceof Text;
@svschannak
svschannak / selenium_remote_chrome_driver.py
Last active October 15, 2018 12:11
Selenium Remote chrome Driver in python
chrome_settings = webdriver.DesiredCapabilities.CHROME.copy()
remote_chrome_driver = webdriver.Remote(desired_capabilities=chrome_settings)
@svschannak
svschannak / docker-compose.yml
Created October 15, 2018 12:03
Zalenium on Mac OS
# Usage:
# docker-compose up --force-recreate
version: "2.1"
services:
#--------------#
zalenium:
image: "dosel/zalenium"
container_name: zalenium
hostname: zalenium
@svschannak
svschannak / react-router-typescript.js
Created September 5, 2018 17:40
React Router Match and Typescript
interface NewsletterDetailProps extends RouteComponentProps<any>, React.Props<any> {
}
const NewsletterDetail: React.StatelessComponent<NewsletterDetailProps> = props => {
const match = props.match;
return (
...
);
};
@svschannak
svschannak / minio_client_max_body_size.sh
Created June 28, 2018 10:07
Minio client_max_body_size
mkdir /home/dokku/minio/nginx.conf.d/
echo 'client_max_body_size 50m;' > /home/dokku/minio/nginx.conf.d/upload.conf
chown dokku:dokku /home/dokku/minio/nginx.conf.d/upload.conf
service nginx reload
@svschannak
svschannak / dokku_ssl.sh
Created June 28, 2018 10:04
Dokku Minio SSL
dokku plugin:install https://github.com/dokku/dokku-letsencrypt.git
dokku config:set --no-restart minio DOKKU_LETSENCRYPT_EMAIL=you@example.com
dokku letsencrypt minio