Skip to content

Instantly share code, notes, and snippets.

View koobitor's full-sized avatar
😁

Sakol Assawasagool koobitor

😁
88 followers · 284 following
View GitHub Profile
@koobitor
koobitor / magento_url_rewrite.patch
Created January 11, 2016 07:56 — forked from edannenberg/magento_url_rewrite.patch
Fixes the catalog url rewrite indexer in Magento 1.7.x-1.9.x See https://github.com/magento/bugathon_march_2013/issues/265 for details.Update: DexterDee in the ticket above noted that the previous patch had some side effects. This updated patch still feels like duct tape but at least it seems to be free of the mentioned side effects. It also fix…
diff -rupN mage_org/app/code/core/Mage/Catalog/Model/Url.php src_shop/app/code/core/Mage/Catalog/Model/Url.php
--- mage_org/app/code/core/Mage/Catalog/Model/Url.php 2013-11-19 00:48:25.679009391 +0100
+++ src_shop/app/code/core/Mage/Catalog/Model/Url.php 2013-11-19 00:49:24.188005601 +0100
@@ -643,13 +643,24 @@ class Mage_Catalog_Model_Url
$this->_rewrite = $rewrite;
return $requestPath;
}
+
+ // avoid unnecessary creation of new url_keys for duplicate url keys
+ $noSuffixPath = substr($requestPath, 0, -(strlen($suffix)));
@koobitor
koobitor / gist:613eb9ea14957e77577a2c6410fe52a0
Last active February 23, 2017 07:05
Ruby Note
# Create New Application
rails new <project-name>
rails new <project-name> --api
rails new <project-name> --database=postgresql
# Bundle
bundle install
# Gem
gem install <gem-name>
@koobitor
koobitor / minikube-cmd.md
Last active September 8, 2017 06:16

Check Version

minikube version

Start Minikube

minikube start
@koobitor
koobitor / kubectl-cmd.md
Last active January 3, 2018 07:32

Check Version

kubectl version

Get Docs Help

kubectl <cmd> --help
@koobitor
koobitor / logs-json-post.php
Created September 8, 2017 06:12
<?php
// Parse json body to array
$data = json_decode(file_get_contents("php://input"), true);
// Set logs file destination
$dir = getcwd()."/logs.log";
// Open file logs
$file = fopen($dir,"a");
@koobitor
koobitor / magento2-remove-order.sql
Created September 12, 2017 12:17
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `gift_message`;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;
@koobitor
koobitor / magento2-remove-customer.sql
Created September 12, 2017 12:17
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `customer_address_entity`;
TRUNCATE TABLE `customer_address_entity_datetime`;
TRUNCATE TABLE `customer_address_entity_decimal`;
TRUNCATE TABLE `customer_address_entity_int`;
TRUNCATE TABLE `customer_address_entity_text`;
TRUNCATE TABLE `customer_address_entity_varchar`;
TRUNCATE TABLE `customer_entity`;
TRUNCATE TABLE `customer_entity_datetime`;
TRUNCATE TABLE `customer_entity_decimal`;
@koobitor
koobitor / magento2-remove-review.sql
Last active September 12, 2017 12:18
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `review`;
TRUNCATE TABLE `review_detail`;
TRUNCATE TABLE `review_entity_summary`;
TRUNCATE TABLE `review_store`;
SET FOREIGN_KEY_CHECKS = 1;
@koobitor
koobitor / magento2-remove-product.sql
Created September 12, 2017 12:19
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
TRUNCATE TABLE `cataloginventory_stock_status_idx`;
TRUNCATE TABLE `cataloginventory_stock_status_tmp`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;
TRUNCATE TABLE `catalog_category_product_index_tmp`;
TRUNCATE TABLE `catalog_compare_item`;
TRUNCATE TABLE `catalog_product_bundle_option`;
@koobitor
koobitor / javascript-template-in-magento-2.phtml
Last active September 21, 2017 08:57
<!-- Custom Script Start Here -->
<script>
require([
"jquery"
], function ($){
console.log($(window))
})
</script>
<!-- Custom Script End Here -->