Johan .V Hotfirenet

## nb_product_customer_order_by_manufacturer.sql
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

## hfn_crontask.php
<?php
/*
Plugin Name: HFN test schedule
Version: 0.0.1
Plugin URI: http://hotfirenet.com/
Description: Plugin qui test le cron
Author: Johan VIVIEN
Author URI: http://hotfirenet.com
*/
defined( 'ABSPATH' ) or die( 'Cheatin&#8217; uh?' );

## slack.sh
#!/usr/bin/env bash
####################################################################################
# Slack Bash console script for sending messages.
####################################################################################
# Installation
#    $ curl -s https://gist.githubusercontent.com/andkirby/67a774513215d7ba06384186dd441d9e/raw --output /usr/bin/slack
#    $ chmod +x /usr/bin/slack
####################################################################################
# USAGE
# Send message to slack channel/user

## dev_prestashop_docker.sh
# create a network for containers to communicate
docker network create prestashop-net
# launch latest mysql container
docker run -ti --name prestashop-mysql --network prestashop-net -e MYSQL_ROOT_PASSWORD=admin -p 3306:3306 -d mysql:latest
# launch prestashop container
sudo docker run -ti --name my-prestashop --network prestashop-net -e DB_SERVER=prestashop-mysql -e PS_DOMAIN=maboutique.local -e PS_SHOP_URL=maboutique.local --volume /var/www/html/prestashop:/var/www/html -p 80:80 -d prestashop/prestashop:1.6
# Run mailcatcher
sudo docker run -d --name prestashop-mailcatcher --network prestashop-net -p 1080:1080 schickling/mailcatcher

## wpa_supplicant.conf
country=FR
ctrl_interface=DIR=/var/run/wpa_supplicant GROUP=netdev
update_config=1
network={
ssid="SSID_LAN"
psk="PASSWORD"
key_mgmt=WPA-PSK
}

## remove_all_product_category_in_cart_rule.sql
DELETE FROM ps_cart_rule_product_rule_value WHERE id_item IN (SELECT id_product FROM ps_category_product WHERE id_category = 53) AND id_product_rule = 1076

## resetJeedomMPD.php
<?php

require_once dirname(__FILE__) . 'core/php/core.inc.php';

$user = user::byLogin('MonLogin');

$user->setPassword(sha1('monMDP'));

$user->save();

## updateRFLINKCommand.sh
sudo /Applications/Arduino.app/Contents/Java/hardware/tools/avr/bin/avrdude -C/Applications/Arduino.app/Contents/Java/hardware/tools/avr/etc/avrdude.conf -v -patmega2560 -cwiring -P/dev/cu.usbmodem1411 -b115200 -D -Uflash:w:/Users/djo/Downloads/RFLink_v1.1_r48/RFLink.cpp.hex

## resultUpdateRFLINKCommand.txt
vrdude: Version 6.3-20171130
         Copyright (c) 2000-2005 Brian Dean, http://www.bdmicro.com/
         Copyright (c) 2007-2014 Joerg Wunsch

         System wide configuration file is "/Applications/Arduino.app/Contents/Java/hardware/tools/avr/etc/avrdude.conf"
         User configuration file is "/Users/djo/.avrduderc"
         User configuration file does not exist or is not a regular file, skipping

         Using Port                    : /dev/cu.usbmodem1411
         Using Programmer              : wiring

## installNvmCommandLine.sh
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/master/install.sh | bash
	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
	<?php
	/*
	Plugin Name: HFN test schedule
	Version: 0.0.1
	Plugin URI: http://hotfirenet.com/
	Description: Plugin qui test le cron
	Author: Johan VIVIEN
	Author URI: http://hotfirenet.com
	*/
	defined( 'ABSPATH' ) or die( 'Cheatin’ uh?' );
	#!/usr/bin/env bash
	####################################################################################
	# Slack Bash console script for sending messages.
	####################################################################################
	# Installation
	# $ curl -s https://gist.githubusercontent.com/andkirby/67a774513215d7ba06384186dd441d9e/raw --output /usr/bin/slack
	# $ chmod +x /usr/bin/slack
	####################################################################################
	# USAGE
	# Send message to slack channel/user
	# create a network for containers to communicate
	docker network create prestashop-net
	# launch latest mysql container
	docker run -ti --name prestashop-mysql --network prestashop-net -e MYSQL_ROOT_PASSWORD=admin -p 3306:3306 -d mysql:latest
	# launch prestashop container
	sudo docker run -ti --name my-prestashop --network prestashop-net -e DB_SERVER=prestashop-mysql -e PS_DOMAIN=maboutique.local -e PS_SHOP_URL=maboutique.local --volume /var/www/html/prestashop:/var/www/html -p 80:80 -d prestashop/prestashop:1.6
	# Run mailcatcher
	sudo docker run -d --name prestashop-mailcatcher --network prestashop-net -p 1080:1080 schickling/mailcatcher
	country=FR
	ctrl_interface=DIR=/var/run/wpa_supplicant GROUP=netdev
	update_config=1
	network={
	ssid="SSID_LAN"
	psk="PASSWORD"
	key_mgmt=WPA-PSK
	}
	<?php

	require_once dirname(__FILE__) . 'core/php/core.inc.php';

	$user = user::byLogin('MonLogin');

	$user->setPassword(sha1('monMDP'));

	$user->save();
	vrdude: Version 6.3-20171130
	Copyright (c) 2000-2005 Brian Dean, http://www.bdmicro.com/
	Copyright (c) 2007-2014 Joerg Wunsch

	System wide configuration file is "/Applications/Arduino.app/Contents/Java/hardware/tools/avr/etc/avrdude.conf"
	User configuration file is "/Users/djo/.avrduderc"
	User configuration file does not exist or is not a regular file, skipping

	Using Port : /dev/cu.usbmodem1411
	Using Programmer : wiring