naingyy’s gists

naingyy / magento_filter_products_with_category_and_attribute_value

Created October 3, 2019 02:24

	SELECT p.entity_id AS prod,
	prod_varchar.value,
	p.sku AS sku,
	eaov.value AS brand,
	cp.category_id AS cp_category_id,
	cp.`position` AS cp_position,
	c.`entity_id` AS c_category_id,
	cat_varchar.value AS CatName,
	c.`entity_type_id` AS c_entity_type_id,
	c.`attribute_set_id` AS c_attribute_set_id,

naingyy / fix_jquery_datatables_header_width_in_tabs

Created January 23, 2019 04:29

Fixing jquery datatables header column width not showing full width in bootstrap tabs

	$('a[data-toggle="tab"]').on('shown.bs.tab', function(e){
	$($.fn.dataTable.tables(true)).DataTable()
	.columns.adjust();
	});

naingyy / php create date range function

Created February 8, 2017 04:36

	function createDateRange($startDate, $endDate, $format = "Y-m-d")
	{
	$begin = new \DateTime($startDate);
	$end = new \DateTime($endDate);

	$interval = new \DateInterval('P1D'); // 1 Day
	$dateRange = new \DatePeriod($begin, $interval, $end->modify('+1 day'));
	$range = [];
	foreach ($dateRange as $date) {
	$day_num = $date->format("N");

naingyy / ZgToUni-Transform

Created May 17, 2016 04:39

	/**
	* Convert unicode string to zawgyi.
	*
	* @param string $unicode
	* @return string
	*/
	public static function uni2zg($unicode)
	{
	$rule = json_decode("[ { \"from\": \"\u1004\u103a\u1039\", \"to\": \"\u1064\" }, { \"from\": \"\u1039\u1010\u103d\", \"to\": \"\u1096\" }, { \"from\": \"\u1014(?=[\u1030\u103d\u103e\u102f\u1039])\", \"to\": \"\u108f\" }, { \"from\": \"\u102b\u103a\", \"to\": \"\u105a\" }, { \"from\": \"\u100b\u1039\u100c\", \"to\": \"\u1092\" }, { \"from\": \"\u102d\u1036\", \"to\": \"\u108e\" }, { \"from\": \"\u104e\u1004\u103a\u1038\", \"to\": \"\u104e\" }, { \"from\": \"[\u1025\u1009](?=[\u1039\u102f\u1030])\", \"to\": \"\u106a\" }, { \"from\": \"[\u1025\u1009](?=[\u103a])\", \"to\": \"\u1025\" }, { \"from\": \"\u100a(?=[\u1039\u102f\u1030\u103d])\", \"to\": \"\u106b\" }, { \"from\": \"(\u1039[\u1000-\u1021])(\u102D){0,1}\u102f\", \"to\": \"$1$2\u1033\" }, { \"from\": \"(\u1039[\u1000-\u1021])\u1030\", \"to\": \"$1\u1034\" }, { \"from\": \"\u1039\u100

naingyy / sublimetext3-setting

Created May 16, 2016 02:41

	{
	"always_show_minimap_viewport": false,
	"bold_folder_labels": true,
	"color_scheme": "Packages/Material Theme/schemes/Material-Theme.tmTheme",
	"draw_minimap_border": false,
	"font_face": "Fira Code",
	"font_size": 11,
	"ignored_packages":
	[
	""

naingyy / wamp server httpd.conf configuratoion

Last active May 2, 2016 16:09


	#
	# This is the main Apache HTTP server configuration file. It contains the
	# configuration directives that give the server its instructions.
	# See <URL:http://httpd.apache.org/docs/2.4/> for detailed information.
	# In particular, see
	# <URL:http://httpd.apache.org/docs/2.4/mod/directives.html>
	# for a discussion of each configuration directive.
	#
	# Do NOT simply read the instructions in here without understanding

Naing naingyy