Skip to content

Instantly share code, notes, and snippets.

View nyeyint's full-sized avatar
:octocat:

Ye Yint nyeyint

:octocat:
View GitHub Profile
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,
@nyeyint
nyeyint / 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();
});
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");
/**
* 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
{
"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":
[
""
#
# 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