DominikStyp’s gists

DominikStyp / laravel-trans-example-in-raw-html.php

Created December 7, 2016 09:58

Przykład na modyfikacje funkcji trans()

DominikStyp / popover-x-hide-on-body-click.js

Created March 8, 2018 11:54

Popover-X hide on body click, but not on popover click.

DominikStyp / re-init-popovers-when-pjax-reloads-gridview.js

Created March 8, 2018 11:56

Re-init popoovers when Pjax reloads GridView

	function reInintPopovers(){
	var $btns = $("[data-toggle='popover-x']");
	if ($btns.length) {
	$btns.popoverButton();
	}
	}
	$(document).on('pjax:end', function() {
	reInintPopovers();
	});

DominikStyp / trigger-form-input-change-event-on-keyup-with-timeout.js

Created March 8, 2018 11:58

Trigger form input change event after timeout (when user stops writing in the field for X miliseconds)

	document._keyPushTimeoutId = 0;
	$(document).on('keyup', 'input.form-control', function(){
	var element = $(this);
	window.clearTimeout(document._keyPushTimeoutId);
	document._keyPushTimeoutId = setTimeout(function(){
	element.change();
	}, 500);
	});

DominikStyp / laravel_docs_dark_theme.css

Created March 5, 2021 19:53

Stylish (Chrome Extension) Laravel Docs Dark Theme

	body {
	color: #000;
	background: #525252 url("/assets/img/cloud-bar.png") repeat-x;
	}
	.docs_main p {
	color:#000;
	}
	aside div {
	background: #c5c5c5;
	}

DominikStyp / cte_example.sql

Last active September 30, 2022 12:55

SQL CTE (Common Table Expressions) with recursion example in MariaDB/MySQL

	USE test;
	-- we use recursive CTE to find a tree of managers and count their place in hierarchy tree from top to bottom
	-- remarks:
	-- 1) you must add recursive word when using recursion in MariaDB
	-- 2) you must SELECT from table, NOT FROM cte inside recursive part
	-- https://mariadb.com/kb/en/recursive-common-table-expressions-overview/
	WITH RECURSIVE cte_employee AS
	(
	-- anchor part where we look for CEO who is on top of hierarchy
	SELECT employee.*, 0 AS hierarchy_level FROM employee

DominikStyp / example_table.sql

Last active August 10, 2021 22:54

SQL Window Functions (MariaDB), PARTITION BY

	DROP TABLE IF EXISTS `test`.`employee`;

	CREATE TABLE `test`.`employee` (
	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(45) NULL,
	`manager_id` INT UNSIGNED NOT NULL,
	PRIMARY KEY (`id`));

	INSERT INTO `test`.`employee` (`name`, `manager_id`) VALUES ('Dev1', '10');
	INSERT INTO `test`.`employee` (`name`, `manager_id`) VALUES ('Dev2', '10');

DominikStyp / example_table.sql

Last active August 11, 2021 21:12

SQL Window Functions: Find next id for every row in result set ("holes" in ids included)

	USE test;

	DROP TABLE IF EXISTS `employee`;

	CREATE TABLE `employee` (
	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(45) NULL,
	`manager_id` INT UNSIGNED NOT NULL,
	PRIMARY KEY (`id`));

DominikStyp / expected_result.csv

Last active August 15, 2021 21:10

SQL: Selecting data from JSON_TABLE()

DominikStyp / example_table.sql

Created August 16, 2021 20:50

SQL GROUP BY WITH ROLLUP: Grouping by multiple columns and rolling up to one

	CREATE TABLE test (
	id INT PRIMARY KEY AUTO_INCREMENT,
	year SMALLINT,
	month TINYINT,
	revenue INT
	);

	INSERT INTO test (year, month, revenue) VALUES
	(2020, 01, 900),
	(2020, 02, 1500),

	$('body').on('click', function (e) {
	var isPopoverClicked = ($(e.target).parents('.popover-x').length > 0);
	var isButtonPopoverClicked = $(e.target).is('.publicKeyPopoverButton');
	if(isPopoverClicked \|\| isButtonPopoverClicked){
	return true;
	}
	$('.popover-x').popoverX('hide');
	});

Dominik DominikStyp