Skip to content

Instantly share code, notes, and snippets.

View soiqualang's full-sized avatar
🙃
hihihaha

Đỗ Thành Long soiqualang

🙃
hihihaha
42 followers · 67 following
View GitHub Profile
@soiqualang
soiqualang / pg_add_fkey.sql
Created February 11, 2020 03:49
PostgreSQl add FOREIGN KEY
ALTER TABLE congtrinh.dap_hientrang_table
ADD CONSTRAINT dap_hientrang_table_maso_huyen_fkey FOREIGN KEY (maso_huyen) REFERENCES bandonen.hanhchinh_huyen_polygon(maso);
@soiqualang
soiqualang / filterObject.js
Created February 12, 2020 10:31
filter Object in Javascript
const developers = {
1: {
id: 1,
name: "Brendan",
family: "Eich"
},
2: {
id: 2,
name: "John",
family: "Resig"
@soiqualang
soiqualang / img.base64
Created February 16, 2020 14:41
PHP Save Base64 Image to File
data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/4gxYSUNDX1BST0ZJTEUAAQEAAAxITGlubwIQAABtbnRyUkdCIFhZWiAHzgACAAkABgAxAABhY3NwTVNGVAAAAABJRUMgc1JHQgAAAAAAAAAAAAAAAAAA9tYAAQAAAADTLUhQICAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABFjcHJ0AAABUAAAADNkZXNjAAABhAAAAGx3dHB0AAAB8AAAABRia3B0AAACBAAAABRyWFlaAAACGAAAABRnWFlaAAACLAAAABRiWFlaAAACQAAAABRkbW5kAAACVAAAAHBkbWRkAAACxAAAAIh2dWVkAAADTAAAAIZ2aWV3AAAD1AAAACRsdW1pAAAD+AAAABRtZWFzAAAEDAAAACR0ZWNoAAAEMAAAAAxyVFJDAAAEPAAACAxnVFJDAAAEPAAACAxiVFJDAAAEPAAACAx0ZXh0AAAAAENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueQAAZGVzYwAAAAAAAAASc1JHQiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAABJzUkdCIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWFlaIAAAAAAAAPNRAAEAAAABFsxYWVogAAAAAAAAAAAAAAAAAAAAAFhZWiAAAAAAAABvogAAOPUAAAOQWFlaIAAAAAAAAGKZAAC3hQAAGNpYWVogAAAAAAAAJKAAAA+EAAC2z2Rlc2MAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABkZXNjA
@soiqualang
soiqualang / filter-json-data-in-javascript.js
Created February 24, 2020 08:49
How to filter JSON Data in JavaScript or jQuery?
t1=[[{"type": "error", "info": "L\u1ed7i d\u00f2ng 8, gi\u00e1 tr\u1ecb \"2.9.3\" kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1."}, {"type": "error", "info": "L\u1ed7i d\u00f2ng 11, gi\u00e1 tr\u1ecb \"2,3\" kh\u00f4ng ph\u1ea3i l\u00e0 s\u1ed1."}, {"type": "warning", "info": "C\u1ea3nh b\u00e1o! D\u00f2ng 20 kh\u00f4ng c\u00f3 gi\u00e1 tr\u1ecb"}], {"filename": "file24-02-2020_15h27m16s-mucnuoc_20rec_number.xlsx"}]
var error = JSON.parse(JSON.stringify(t1[0])).filter(function (entry) {
return entry.type === 'error';
});
var filtered_json = find_in_object(JSON.parse(JSON.stringify(t1[0])), {type: 'error'});
//------------------------------
@soiqualang
soiqualang / Format SD card to use as Internal Storage.MD
Last active February 25, 2020 07:20
Kích hoạt tính năng dùng thẻ nhớ như bộ nhớ trong trên Zenfone Max và Laser LTE chạy Android 6 leak
@soiqualang
soiqualang / simple-compressing.md
Created February 28, 2020 02:33 — forked from profiprog/simple-compressing.md
Simple compressing base64 string in JavaScript

Story

In needed include base64 encoded simple image into HTML page in two formats:

1st as PNG format has length 196 characters and looks like this:

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAWElEQVR42mNkwA/qgbgRnwJGAgb8BwI7RkbGw5QYUAs0oGXUAPwGgKKqgYF0ANLTyAi1xhZI2WOYzsjYDJTbC2QewGHIwcERBsPcgHqgAX8pMQAcxfhyIwATTkxL+hgX2QAAAABJRU5ErkJggg==

2nd as CUR format has length 1536 characters and looks like this:

`AAACAAEAEBAAAAcABwBoBAAAFgAAACgAAAAQAAAAIAAAAAEAIAAAAAAAQAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP///z0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH////98AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD/////fAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/////3wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP////98AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

@soiqualang
soiqualang / ionic_github_actions_build_apk.md
Last active March 5, 2020 09:48
Github actions build ionic apk
@soiqualang
soiqualang / vector_tiles_leaflet.html
Created March 6, 2020 09:09
<!DOCTYPE html>
<html>
<head>
<title>GridLayer Test</title>
<meta charset="utf-8" />
<link rel="stylesheet" href="https://unpkg.com/leaflet@1.0.3/dist/leaflet.css" />
<style>
body {
padding: 0;
margin: 0;
@soiqualang
soiqualang / sql_get_view_column_comment.sql
Created March 11, 2020 08:46
PostgreSQL get comment of view column
SELECT a.attname As column_name, d.description
FROM pg_class As c
INNER JOIN pg_attribute As a ON c.oid = a.attrelid
LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
LEFT JOIN pg_tablespace t ON t.oid = c.reltablespace
LEFT JOIN pg_description As d ON (d.objoid = c.oid AND d.objsubid = a.attnum)
WHERE c.relkind IN('r', 'v') AND n.nspname = 'congtrinh' AND c.relname = 'view_cong_hientrang_geo_2'
ORDER BY n.nspname, c.relname, a.attname ;
@soiqualang
soiqualang / gmap_auto_action.js
Last active March 14, 2020 14:12
google map auto action crawl saved places list
function back2list(){
var url=window.location.href;
console.log(url);
//back_btn=document.getElementsByTagName('span')[11];
//back_btn.click();
}
function getElementByXpath(path) {
return document.evaluate(path, document, null, XPathResult.FIRST_ORDERED_NODE_TYPE, null).singleNodeValue;
}