insaurabh’s gists

insaurabh / Magento clear sql

Last active July 25, 2019 07:53

	# Tested on Magento CE 1.4.1.1 - 1.9.2

	SET FOREIGN_KEY_CHECKS=0; # important

	##############################
	# SALES RELATED TABLES
	##############################
	TRUNCATE `sales_flat_creditmemo`;
	TRUNCATE `sales_flat_creditmemo_comment`;
	TRUNCATE `sales_flat_creditmemo_grid`;

insaurabh / getBaseUrl

Created April 20, 2017 07:14

	Under every function there is an example of the output value:

	Output : http://example.com/
	<?php echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB); ?>

	Output : http://example.com/js/
	<?php echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS); ?>

	Output : http://example.com/index.php/
	<?php echo Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK); ?>

insaurabh / function.php

Last active May 8, 2018 06:09

Custom additional values using pmpro-register-helper

	function my_pmprorh_init()
	{

	$last_university = get_option('last_university');
	$last_university = explode(',', $last_university);
	$highest_level_of_education = get_option('highest_level_of_education');
	$highest_level_of_education = explode(',', $highest_level_of_education);
	// print_r($last_university);

	if (!function_exists('pmprorh_add_registration_field'))

insaurabh / extend.php

Last active June 16, 2018 14:57

Magento 2 file extend

	#File name : /your-custom-module/view/frontend/layout/catalog_product_view.xml

	<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
	<body>
	<referenceContainer name="product.info.main">
	<block class="[Namespace]\[Modulename]\Block\Product\View\SomeName"
	after="-"
	name="customname.somename"
	template="product/view/custom_template_name.phtml" />
	</referenceContainer>

insaurabh / title-and-meta-ajax-search-wordpress.php

Last active September 25, 2018 12:24

ajax search for title and custom meta in wordpress

	/**
	* Shortcode for property serach form
	* @author Saurabh Ranjan
	* <button type="button">Review Property</button>
	*/

	TODO:
	1) chagne `post_type` as per your need
	2) change `custom_meta` as per your need
	3) Update $HTML as per need

insaurabh / meta-box-filed-repeater.php

Created August 21, 2018 09:32

add meta box with input field repeater wordpress

	<?php
	/**
	* Create custom meta box
	*/

	// code is taken from stackoverflow and did some changes as per requirements.

	add_action( 'add_meta_boxes', 'dynamic_add_box' );

	/* Do something with the data entered */

insaurabh / cli-commands-magento-1.9.txt

Created August 24, 2018 06:45

	These is Individual commands for re-indexing:-

	php shell/indexer.php --reindex catalog_category_flat

	php shell/indexer.php --reindex catalog_category_product

	php shell/indexer.php --reindex catalogsearch_fulltext

	OR run all re-indexing:-

insaurabh / xml-to-array.php

Last active September 26, 2018 18:51

Practising xml to array and php loops

	<?php

	$url = 'fileName.xml';
	$xml = simplexml_load_file($url); // load
	$jsonEncode = json_encode($xml); // encode
	$arrayData = json_decode($jsonEncode,TRUE); // decode , that's it now every thing is in array no need to query as object or parse to string

	dump($arrayData['residential'][0]['agentID']);
	dump($arrayData['residential'][0]['uniqueID']);
	dump($arrayData['residential'][0]['tenancy']);

insaurabh / InsertDate.gs

Created October 1, 2018 06:05 — forked from thomxc/InsertDate.gs

Google Docs Script Macro: Insert Date

	/**
	* The onOpen function runs automatically when the Google Docs document is
	* opened. Use it to add custom menus to Google Docs that allow the user to run
	* custom scripts. For more information, please consult the following two
	* resources.
	*
	* Extending Google Docs developer guide:
	* https://developers.google.com/apps-script/guides/docs
	*
	* Document service reference documentation:

insaurabh / get-attribute-woocomerce.php

Created October 14, 2018 08:46

	<?php
	// get the attribute


	add_action( 'woocommerce_shop_loop_item_title', 'show_attribute_custom_action', 15 );

	function show_attribute_custom_action() {
	global $product;

	$sizeAttribute = array_shift( wc_get_product_terms( $product->id, 'pa_size', array( 'fields' => 'names' ) ) );

Saurabh Ranjan insaurabh