Skip to content

Instantly share code, notes, and snippets.

View Hotfirenet's full-sized avatar

Johan .V Hotfirenet

6 followers · 41 following
View GitHub Profile
@Hotfirenet
Hotfirenet / prestashop_order_day_by_day.sql
Created October 2, 2017 08:15
Cette requête sql permet de connaitre le nombre de commande et le chiffre d'affaire TTC par jour et par paiement
SELECT COUNT(id_order) AS nbOrder
, SUM(total_paid_tax_incl) AS 'CA_TTC'
, DATE(date_add) AS 'Date'
, payment
FROM ps_orders
WHERE YEAR(date_add) = 2017
GROUP BY DATE(date_add), payment
@Hotfirenet
Hotfirenet / blacklist.conf
Created October 11, 2017 19:03
Fichier de nginx qui permet de retourner dans la variable bad_referer 0 ou 1 si il match avec un site défini.
map $http_referer $bad_referer {
hostnames;
default 0;
# Put regexes for undesired referers here
"~site_a_bloquer.com" 1;
}
@Hotfirenet
Hotfirenet / default_hotlink.conf
Created October 11, 2017 19:05
Rajoute pour nginx une conditionqui evite le hotlink en fonction d'une blacklist, contrairement a ce que l'on voit dans les tuto ici il s'agit de bloquer un ou plusieurs sites qui aurait piller votre contenu.
@Hotfirenet
Hotfirenet / .htaccess_hotlink
Last active October 11, 2017 19:06
Rajoute pour apache une condition dans htaccess qui evite le hotlink, contrairement a ce que l'on voit dans les tuto ici il s'agit de bloquer un ou plusieurs sites qui aurait piller votre contenu.
@Hotfirenet
Hotfirenet / list_order_by_carriers.sql
Last active October 19, 2017 07:35
Liste les commandes en fonction d'un ou plusieurs transporteurs avec montant ou non
SELECT A.reference, B.lastname, A.total_paid_tax_incl, A.date_add, C.name,D.*
FROM ps_orders A
INNER JOIN ps_customer B ON B.id_customer = A.id_customer
INNER JOIN ps_carrier C ON C.id_carrier = A.id_carrier
LEFT OUTER JOIN ps_socolissimo_delivery_info D ON D.id_cart = A.id_cart
WHERE A.date_add BETWEEN '2017-06-01' AND '2017-09-31'
# AND C.name IN ('Colissimo Suivi International','Colissimo Suivi Europe')
# AND A.total_paid_tax_incl <= 50
# AND C.name <> 'Colissimo Suivi International'
# AND D.cecountry NOT IN ('AT', 'BE')
@Hotfirenet
Hotfirenet / merge_dev2prod_git.sh
Created November 3, 2017 14:40
Merging develop branch into master
git checkout develop
git pull origin develop
git checkout master
git merge develop
git push origin master
@Hotfirenet
Hotfirenet / update_select_sum.sql
Created January 19, 2018 10:14
Mysql UPDATE, SELECT With SUM
UPDATE ps_affiliate A
INNER JOIN
(
SELECT id_order, SUM(product_quantity) AS nb_article_order
FROM ps_order_detail
GROUP BY id_order
) B
ON B.id_order = A.id_order
SET A.nb_article_order = B.nb_article_order
@Hotfirenet
Hotfirenet / backup_mysql_docker.sh
Last active March 19, 2018 10:18
Use this shell to backup your docker mysql databases
#!/bin/sh
date=$(date +%y-%m-%d)
bckdir=REPLACE
keep_day=2
container=REPLACE
docker exec -ti ${container} mysqldump --login-path=local --single-transaction --all-databases | gzip > "${bckdir}/${container}_${date}.sql.gz
find "${bckdir}"/* -mtime +${keep_day} -exec rm {} \;
exit 0
@Hotfirenet
Hotfirenet / clean_chrome_for_macos.sh
Created July 4, 2018 07:40
Shell qui permet de revenir à une installation toute fraiche de chrome sur MacOs
#!/bin/sh
rm -r ~/Library/Application Support
rm -r ~/Library/Caches
rm -r ~/Library/Google
@Hotfirenet
Hotfirenet / nb_product_customer_order_by_manufacturer.sql
Created July 10, 2018 08:47
Cette requete permet de connaitre le nombre de produits vendus par client pour un Fabriquant / Marque sur Prestashop
SELECT SUM(OD.product_quantity) AS 'OD.product_quantity',
OD.product_name,
C.firstname,
C.lastname,
C.email
FROM ps_order_detail OD
INNER JOIN ps_product P ON P.id_product = OD.product_id
LEFT OUTER JOIN ps_orders O ON O.id_order = OD.id_order
LEFT OUTER JOIN ps_customer C ON C.id_customer = O.id_customer
WHERE P.id_manufacturer = 216