Skip to content

Instantly share code, notes, and snippets.

View hprobotic's full-sized avatar
🌴
On vacation

John Pham hprobotic

🌴
On vacation
64 followers · 167 following
View GitHub Profile
@hprobotic
hprobotic / payout.md
Last active November 15, 2021 01:21
query to get payout history

during Reap Pay admin payout, when Maker marks a transaction using any intermediary review status (rec_payout, Q12345, R12345, rec_complete), does this get stored in the DB even after such transaction is moved to Completed Transfers as either SUCCESS or REFUND? If so, which column is this in the DB?

The values of rec_payout, rec_complete meaning:

# NULL: unprocessed
# 1: Successfully
# 0: Failed
  1. Find all failed payout transactions:
@hprobotic
hprobotic / wg.conf
Last active July 26, 2021 05:19
JTW41K35-eI6C1x25-m24lJ18D
[Interface]
PrivateKey = qIlPpcDo6YmFd7vgE6xwjrKcqjzxMERNzd6sJrDyy1U=
Address = 172.16.0.2/32
Address = fd01:5ca1:ab1e:8048:2daa:4e28:6a87:3e37/128
DNS = 1.1.1.1
MTU = 1280
[Peer]
PublicKey = bmXOC+F1FxEMF9dyiK2H5/1SUtzH0JuVo51h2wPfgyo=
AllowedIPs = 0.0.0.0/0
AllowedIPs = ::/0
@hprobotic
hprobotic / iptv.m3u
Last active July 24, 2021 05:32
#EXTM3U url-tvg="http://gg.gg/Iichphatsongiptv" tvg-shift=0 m3uautoload=1
#EXTINF:-1 group-title="KÊNH ĐỊA PHƯƠNG" tvg-logo="https://i.ibb.co/ZYCZxNn/qrfbvovanloc.jpg", QR Facebook Ad
#EXTVLCOPT:http-user-agent="Mozilla/5.0 (Windows NT 10.0; WOW64) (byiptv247T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
https://i.ibb.co/ZYCZxNn/qrfbvovanloc.jpg
#EXTINF:-1 group-title="KÊNH ĐỊA PHƯƠNG" tvg-logo="https://i.ibb.co/R0tqK7Y/angiangtvlogobyvovanloc.png", An Giang
#EXTVLCOPT:http-user-agent="Mozilla/5.0 (Windows NT 10.0; WOW64) (byiptv247T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
http://livecdn.fptplay.net/sda/angiang_2000.stream/playlist.m3u8
#EXTINF:-1 group-title="KÊNH ĐỊA PHƯƠNG" tvg-logo="https://i.ibb.co/gZw9XQG/brvttvlogobyvovanloc.png", Bà Rịa Vũng Tàu HD
#EXTVLCOPT:http-user-agent="Mozilla/5.0 (Windows NT 10.0; WOW64) (byiptv247T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
@hprobotic
hprobotic / holidays_wk_ts_query.sql
Last active May 25, 2021 01:37
-- HK
SELECT DISTINCT scheduled_transactions.id AS scheduled_transactions_id,
user.country_id AS user_country_id,
scheduled_transactions.user_id
FROM scheduled_transactions
INNER JOIN user ON user.id = scheduled_transactions.user_id
WHERE user.country_id = 1
AND scheduled_transactions.deleted IS FALSE
AND scheduled_transactions.arrival_date IN(
'2021-05-19',
@hprobotic
hprobotic / psql.md
Created January 10, 2018 04:01
Fix Postgres `connections on Unix domain socket "/tmp/.s.PGSQL.5432"?`

run rm /usr/local/var/postgres/postmaster.pid

@hprobotic
hprobotic / result.md
Last active November 11, 2020 12:46
Transferwise debug

Outdated cuz we use personal account id

Get quote

{
   "id":1526617,
   "source":"HKD",
   "target":"SGD",
   "sourceAmount":5925.25,
   "targetAmount":1000.0,
@hprobotic
hprobotic / installer.php
Last active August 3, 2020 14:47
<?php
/* ------------------------------ NOTICE ----------------------------------
If you're seeing this text when browsing to the installer, it means your
web server is not set up properly.
Please contact your host and ask them to enable "PHP" processing on your
account.
----------------------------- NOTICE ---------------------------------*/
@hprobotic
hprobotic / report_template.md
Last active July 27, 2020 16:11

Hi

Here is your today report

  1. All Terminals belonging to the merchants are inactive for 10 <= x >= 2 days <List: machant, terminal_id, tid, name, last_transaction date... /> Danh sách các terminal không có transaction trong 2 ngày tính từ ngày có transaction cuối cùng.
30 <= current_date >= last_transaction_date + 2 => true else false
@hprobotic
hprobotic / init.vim
Created May 19, 2020 08:16
" plugins
call plug#begin('~/.config/nvim/plugged')
"colorschemes
Plug 'arcticicestudio/nord-vim'
Plug 'chriskempson/base16-vim'
Plug 'joshdick/onedark.vim'
"airline
Plug 'vim-airline/vim-airline'
Plug 'vim-airline/vim-airline-themes'
@hprobotic
hprobotic / commits.log
Last active May 11, 2020 08:13
commit 1193410b550e6ed49f1630359ac5bf3156bc96eb (HEAD -> develop, origin/develop, origin/HEAD)
Merge: 888ec575 6a3e9007
Author: John Pham <hprobotic@gmail.com>
Merge pull request #840 from reaphq/fix/registration_country_error
commit 888ec57526ac5c9b3dcbdc1ea3ecd9d6d9a2a509
Merge: e794913e 8cfd9786
Author: Dennis Tse <23326758+yktse3@users.noreply.github.com>