Jérémy Halin jeremyhalin

Full Stack Developer

jeremyhalin / exportjson.js

Last active January 26, 2021 10:05 — forked from pamelafox/exportjson.js

Google Spreadsheet JSON ExportHow-to at http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html

	// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible).
	// Tweak the makePrettyJSON_ function to customize what kind of JSON to export.

	var FORMAT_ONELINE = 'One-line';
	var FORMAT_MULTILINE = 'Multi-line';
	var FORMAT_PRETTY = 'Pretty';

	var LANGUAGE_JS = 'JavaScript';
	var LANGUAGE_PYTHON = 'Python';

jeremyhalin / PhpStorm settings.md

Last active October 28, 2018 22:09

My PhpStorm settings

PhpStorm Settings

File Types => PHP => Add .ctp extension

Ctrl + Shift + N => Ctrl + P

jeremyhalin / update_image_links_to_ssl.sql

Last active June 15, 2017 14:05

Replace images URL to HTTPS ones in WordPress

	UPDATE wp_posts
	SET post_content = ( Replace (post_content, 'src="http://', 'src="//') )
	WHERE Instr(post_content, 'jpeg') > 0
	OR Instr(post_content, 'jpg') > 0
	OR Instr(post_content, 'gif') > 0
	OR Instr(post_content, 'png') > 0;

	UPDATE wp_posts
	SET post_content = ( Replace (post_content, "src='http://", "src='//") )
	WHERE Instr(post_content, 'jpeg') > 0

jeremyhalin / remove_thumbnail_wordpress.sql

Created May 9, 2017 09:39

Remove thumbnail meta value from posts

	/* Delete all meta values '_thumnbail_id' for posts not IN category */
	DELETE FROM wp_postmeta WHERE post_id IN (
	SELECT ID
	FROM wp_posts p
	JOIN wp_term_relationships tr ON (p.ID = tr.object_id)
	JOIN wp_term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
	JOIN wp_terms t ON (tt.term_id = t.term_id)
	WHERE p.post_type='post'
	AND p.post_status = 'publish'
	AND p.id NOT IN (...)

jeremyhalin / clear_products_table_woocommerce.sql

Last active May 9, 2017 09:40

Clear all products table WooCommerce WordPress

	-- Remove all attributes from WooCommerce
	DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%');
	DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%';
	DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);
	-- Delete all WooCommerce products
	DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
	DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
	DELETE FROM wp_posts WHERE post_type IN ('product','product_variation');
	-- Delete orphaned postmeta
	DELETE pm

jeremyhalin / ChartFrame.java

Created December 15, 2015 09:55

ChartFrame

	/*
	* Copyright (c) 2014, 2015, Formation Tablettes. All rights reserved.
	* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
	*
	* Please contact us or visit www.britweb.fr if you need additional information or have any questions.
	*/
	package com.logic;

	import com.entity.Proposal;
	import com.entity.Question;