Category: Sói’s Tutorials

API for CCQ VINACAPITAL

Posted on by soiqualang_chentreu Posted in Mẹo vặt, Sói's Tutorials Tagged Leave a Comment on API for CCQ VINACAPITAL

API for CCQ VINACAPITAL VESAF | https://vinacapital.com/vi/investment-solutions/onshore-funds/vesaf/ VEOF | https://vinacapital.com/vi/investment-solutions/onshore-funds/veof/ VLBF | https://vinacapital.com/vi/investment-solutions/onshore-funds/vlbf/ VFF | https://vinacapital.com/vi/investment-solutions/onshore-funds/vff/ http://data.dothanhlong.org/vinacapital/?fundname=VFF Google Sheet /html/body/div[1]/div[2] =IMPORTXML(E25,"/html/body/div[1]/div[2]")*1 Source <?php // http://data.dothanhlong.org/vinacapital/?fundname=VFF if(isset($_REQUEST['fundname'])){ $fundname = $_REQUEST['fundname']; // VESAF // VEOF // VLBF // VFF $curl = curl_init(); […]

Read More

[Notes] Server script – Start, Stop, Restart with virtual machine

Posted on by soiqualang_chentreu Posted in Lang thang, Mẹo vặt, Sói's Tutorials Tagged , , Leave a Comment on [Notes] Server script – Start, Stop, Restart with virtual machine

[Notes] Server script – Start, Stop, Restart with virtual machine Continous from Bash script for starting VirtualBox VMs server_start.bat "C:\Program Files\Oracle\VirtualBox\VBoxManage" startvm "s1" –type headless "C:\Program Files\Oracle\VirtualBox\VBoxManage" startvm "agriweather" –type headless "C:\Program Files\Oracle\VirtualBox\VBoxManage" startvm "s2" –type headless Then make a […]

Read More

AdMob.java:243: error: cannot find symbol

Posted on by soiqualang_chentreu Posted in Sói's Tutorials Tagged , Leave a Comment on AdMob.java:243: error: cannot find symbol

AdMob.java:243: error: cannot find symbol [cordova] D:\sync\websvr\ionic\test\reader\envirotech_book_reader_mobile\platforms\android\app\src\main\java\name\ratson\cordova\admob\AdMob.java:243: error: cannot find symbol [cordova] @NonNull [cordova] ^ [cordova] symbol: class NonNull [cordova] location: class name.ratson.cordova.admob.AdMob [cordova] Note: Some input files use or override a deprecated API. [cordova] Note: Recompile with -Xlint:deprecation for […]

Read More

PostgreSQL xử lý chuỗi với xpath

Posted on by soiqualang_chentreu Posted in Công nghệ, Lang thang, Mẹo vặt, Sói's Tutorials Tagged , , , , Leave a Comment on PostgreSQL xử lý chuỗi với xpath

PostgreSQL xử lý chuỗi với xpath Tôi có bảng thế này Giờ tôi cần tách theo cấu trúc thế này Với cột định nghĩa cần cực kỳ ngắn gọn, 1 cụm từ thôi càng tốt Cột description trên kia thì […]

Read More

PostgreSQL – Terminate Client Connect View

Posted on by soiqualang_chentreu Posted in Lang thang, Mẹo vặt, Sói's Tutorials Tagged Leave a Comment on PostgreSQL – Terminate Client Connect View

PostgreSQL – Terminate Client Connect View To fix FATAL: sorry, too many clients already connection to server https://dothanhlong.org/postgresql-fatal-sorry-too-many-clients-already-connection-to-server/ — View: public.terminate_client_connect — DROP VIEW public.terminate_client_connect; CREATE OR REPLACE VIEW public.terminate_client_connect AS SELECT pg_terminate_backend(pg_stat_activity.pid) AS pg_terminate_backend FROM pg_stat_activity WHERE pg_stat_activity.pid <> […]

Read More

WebGIS Roadmap by Do Thanh Long (soiqualang_chentreu)

Posted on by soiqualang_chentreu Posted in Công nghệ, GIS, Sói's Tutorials, WebGIS Tagged , Leave a Comment on WebGIS Roadmap by Do Thanh Long (soiqualang_chentreu)

WebGIS Roadmap by Do Thanh Long (soiqualang_chentreu) Tình hình là hồi trước mình có làm một cái WebGIS Roadmap cho các bạn mới tìm hiểu về WebGIS có một cái nhìn hệ thống về mảng này. Bẵng một thời gian […]

Read More

PostgreSQL – Column to Json/Jsonb

Posted on by soiqualang_chentreu Posted in Dữ liệu, Lang thang, Mẹo vặt, Sói's Tutorials, Web Tagged , , , , , Leave a Comment on PostgreSQL – Column to Json/Jsonb

PostgreSQL – Column to Json/Jsonb I have a table coso_nhayen like this row_to_json select row_to_json(row) from (select * from coso_nhayen) row LIMIT 5; to_jsonb SELECT id, to_jsonb(t.*) – 'id' AS data FROM coso_nhayen t LIMIT 5; json_agg SELECT json_agg(t) FROM coso_nhayen t; […]

Read More

QGIS merge points within distance

Posted on by soiqualang_chentreu Posted in GIS, Mẹo vặt, QGIS Tutorials and Tips, Sói's Tutorials Tagged , , , Leave a Comment on QGIS merge points within distance

QGIS merge points within distance Issue How One possible approach consists in the following steps: draw a buffer of 5m around points; dissolve the buffers which overlap; calculate the centroids of dissolved buffers. You can choose the tools with which you’re more comfortable. Example\ For […]

Read More

Filter in WMS servering by QGIS Server

Posted on by soiqualang_chentreu Posted in GIS, Mẹo vặt, Sói's Tutorials, WebGIS Tagged , , Leave a Comment on Filter in WMS servering by QGIS Server

Filter in WMS servering by QGIS Server Full query https://geoviet_mapserv.dothanhlong.org/?MAP=/gis/mbgis/api.qgs&service=WMS&request=GetMap&layers=vn_vunghanhchinh&styles=&format=image%2Fpng&transparent=true&version=1.1.1&tiled=true&width=256&height=256&srs=EPSG%3A3857&bbox=11897270.578531114,1252344.2714243277,12523442.714243278,1878516.4071364922 Filter query https://geoviet_mapserv.dothanhlong.org/?MAP=/gis/mbgis/api.qgs&service=WMS&request=GetMap&layers=vn_vunghanhchinh&styles=&format=image/png&transparent=true&version=1.1.1&tiled=true&width=256&height=256&srs=EPSG:3857&bbox=11897270.578531114,1252344.2714243277,12523442.714243278,1878516.4071364922&filter=vn_vunghanhchinh: "ten_vi" = 'Phú Yên' Refernces https://docs.qgis.org/3.22/en/docs/server_manual/services/wms.html

Read More

[Linux] Adjust and increase the capacity of VDI virtual drive to install Ubuntu on VirtualBox

Posted on by soiqualang_chentreu Posted in Công nghệ, Lang thang, Linux, Mẹo vặt, Sói's Tutorials Tagged , , , Leave a Comment on [Linux] Adjust and increase the capacity of VDI virtual drive to install Ubuntu on VirtualBox

[Linux] Adjust and increase the capacity of VDI virtual drive to install Ubuntu on VirtualBox Problems encountered I have deployed an ubuntu server on the virtualbox virtualization platform, I divided the hard drive space is 200GB, but after creating and […]

Read More

[Bản đồ họ Việt P2] Lập bản đồ các dòng họ Việt Nam phần 2 – Xử lý dữ liệu

Posted on by soiqualang_chentreu Posted in Lang thang, Sói's Tutorials, Ý tưởng Tagged , , , Leave a Comment on [Bản đồ họ Việt P2] Lập bản đồ các dòng họ Việt Nam phần 2 – Xử lý dữ liệu

[Bản đồ họ Việt P2] Lập bản đồ các dòng họ Việt Nam phần 2 – Xử lý dữ liệu Danh sách các phần ở đây: https://dothanhlong.org/p1-lap-ban-do-cac-dong-ho-viet-nam-phan-1/ https://dothanhlong.org/ban-do-ho-viet-p2-lap-ban-do-cac-dong-ho-viet-nam-phan-2-xu-ly-du-lieu/ Sau khi xem sơ dữ liệu, khối lượng khá lớn ~ 1.3 […]

Read More