=INDEX('[Healh-Factor-product list_Health-lookup.xlsx]Sheet1'!$A:$A,MATCH(""&TRIM(E313)&"",'[Healh-Factor-product list_Health-lookup.xlsx]Sheet1'!$D:$D,),0)
View add_custom_column_to_edit_tag.php
/* | |
Purpose: add custom column header and custom column content to respective custom header in Manage Category Editing Page | |
Version Tested: 3.8 | |
Story: | |
Because I found no explanation nor documents in Wordpress.org, I tried to trace the code in wp-admin folder | |
after understanding the operation of apply_filter(), add_action() and add_filter() | |
Logic: | |
The table list in edit_tag.php is based on |
View date-validation.js
Examples | |
let date = '31-12-2004' | |
date_regex = /^(0[1-9]|[1-2][0-9]|3[0-1])-(0[1-9]|1[0-2])-[0-9]{4}$/; | |
date_regex.test( date ) | |
let date = 31 | |
let date_regex = /^(0[1-9]|[1-2][0-9]|3[0-1])$/; | |
date_regex.test( date ) | |
let date = 12 |
View read-csv.sh
#!/bin/bash | |
# Purpose: Read Comma Separated CSV File | |
# Author: Vivek Gite under GPL v2.0+ | |
# Site: https://www.cyberciti.biz/faq/unix-linux-bash-read-comma-separated-cvsfile/ | |
# ------------------------------------------ | |
INPUT=bridge-category.csv | |
OLDIFS=$IFS | |
IFS=',' | |
[ ! -f $INPUT ] && { echo "$INPUT file not found"; exit 99; } | |
while read cat_en cat_zht |
View css-table.scss
.table { | |
// display: table; | |
width: 100%; | |
background: red; | |
.tbl-col-group { | |
display: table-column-group; | |
.tbl-col { | |
display: table-column; |
View delete-all-woocommerce-products.php
<?php | |
require dirname(__FILE__).'/wp-blog-header.php'; | |
$wpdb->query("DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%')"); | |
$wpdb->query("DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'"); | |
$wpdb->query("DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy)"); | |
$wpdb->query("DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))"); | |
$wpdb->query("DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))"); | |
$wpdb->query("DELETE FROM wp_posts WHERE post_type IN ('product','product_variation')"); |
View batch.sh
for file in *.po; do | |
po-to-xls ${file%.*}.po -o ${file%.*}.xlsx | |
done | |
# https://stackoverflow.com/questions/2664740/extract-file-basename-without-path-and-extension-in-bash | |
# $file is the file original name | |
# no extension: ${file%.*}.po | |
# s=/the/path/foo.txt | |
# echo "${s##*/}" | |
# foo.txt |
View ExportAllCSVinOneSpreadsheet.gs
/* | |
* script to export data in all sheets in the current spreadsheet as individual csv files | |
* files will be named according to the name of the sheet | |
* Note: This script uses the DocsList.createFile() method, which is only available for Google Apps accounts. | |
* author: Michael Derazon | |
*/ | |
function onOpen() { | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}]; |
View mysql-notes.md
// reset table id from 1 ALTER TABLE tablename AUTO_INCREMENT = 1
MySQL multiple columns in IN clause https://stackoverflow.com/questions/44706196/mysql-multiple-columns-in-in-clause (x0, y0, x1, y1) IN ((4, 3, 5, 6),(9, 3, 2, 1))
for string, need to be ... IN ('something1', 'something2') ...
able to search taxonomies with specific keywords, this is part of the clause
View WP-Trace-Intercept-codes.php
<?php | |
var_dump($this->request); | |
if( strpos( $this->request, 'SQL_CALC_FOUND_ROWS' ) > 0 ) { | |
file_put_contents('/volumes/ram/test_'. time() .'.txt', $this->request); | |
} |
NewerOlder