Skip to content

Instantly share code, notes, and snippets.

A. A. Sumitro aasumitro

Block or report user

Report or block aasumitro

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:e4f9f7a89db39fdd5c7e1d3d75d8ba8d
SELECT concat(CONCAT(CONCAT(concat(CONCAT(concat(a.KD_PROPINSI, a.KD_DATI2), a.KD_KECAMATAN), a.KD_KELURAHAN), a.KD_BLOK), a.NO_URUT), a.KD_JNS_OP) AS nop,
a.STATUS_PEMBAYARAN_SPPT AS st_lunas, b.SUBJEK_PAJAK_ID AS nik, c.NM_WP AS nama
FROM SPPT a, DAT_OBJEK_PAJAK b, DAT_SUBJEK_PAJAK c
WHERE concat(CONCAT(CONCAT(concat(CONCAT(concat(a.KD_PROPINSI, a.KD_DATI2), a.KD_KECAMATAN), a.KD_KELURAHAN), a.KD_BLOK), a.NO_URUT), a.KD_JNS_OP) = concat(CONCAT(CONCAT(concat(CONCAT(concat(b.KD_PROPINSI, b.KD_DATI2), b.KD_KECAMATAN), b.KD_KELURAHAN), b.KD_BLOK), a.NO_URUT), b.KD_JNS_OP)
AND b.SUBJEK_PAJAK_ID=c.SUBJEK_PAJAK_ID
AND EXTRACT(YEAR FROM TO_DATE(a.TGL_TERBIT_SPPT, 'DD-MON-RR')) = 2018;
@aasumitro
aasumitro / lumen-filesystem.md
Created Sep 2, 2019 — forked from deividaspetraitis/lumen-filesystem.md
Lumen flysystem ( filesystem ) integration
View lumen-filesystem.md

Lumen flysystem integration

By default lumen doesn't support laravel file system. In order to integrate to lumen we need follow these instructions:

  1. composer require league/flysystem
  2. Copy filesystems config file from Laravel ( https://github.com/laravel/laravel/blob/master/config/filesystems.php ) to your local Lumen installation document_root/config
  3. Bind filesystem to IoC for example in document_root/bootstrap/app.php by adding this code lines:

`` $app->singleton('filesystem', function ($app) {

@aasumitro
aasumitro / multi-ci.conf
Created Aug 17, 2019
Codeigniter in subfolder with nginx
View multi-ci.conf
server {
listen 80;
listen [::]:80;
server_name _;
root /var/www/{root_folder};
index index.php index.html;
location / {
access_log {access_log_file{;
@aasumitro
aasumitro / ci.conf
Last active Sep 1, 2019
codeigniter in main and subfolder with nginx
View ci.conf
server {
listen 80;
listen [::]:80;
server_name dev.seanesia.com www.dev.seanesia.com;
root /var/www/dev/frontoffice;
index index.php index.html;
location / {
access_log /var/www/dev/log/fo/access.log;
@aasumitro
aasumitro / sms-minicom.txt
Last active Aug 7, 2019
send sms with minicom
View sms-minicom.txt
Connect Sim800l v2 by rohs with minicom (raspberry pi 3 b+)
#1 download minicom package
apt install minicom
#2 activate hardware serial interface by opening the raspberry config
raspi-config
- interfacing options
View custom-tabs.html
<!-- Start contain wrapp -->
<div class="contain-wrapp padding-bot30">
<div class="container">
<div class="row">
<div class="col-md-12">
<!-- Start Tabs -->
<div class="custom-tabs tabs-icon">
<ul class="nav nav-tabs" role="tablist">
<li class="active">
<a href="#first2" data-toggle="tab">
@aasumitro
aasumitro / nginx.conf
Created Jul 22, 2019
conf for codeigniter 3.x
View nginx.conf
server {
listen 80;
listen [::]:80;
server_name {domain};
root {folder/location};
index index.php index.html index.htm;
location / {
View AdvancePermission.kt
class PermissionManager(
private val activity: FragmentActivity
) {
private var lastRequestId = 0
@SuppressLint("UseSparseArrays")
private val permissionRequests = HashMap<Int, PermissionRequest>()
fun requestPermission(
View gist:066101434396c2138d3b6ec3062236c9
enum class PermissionState { GRANTED, NOT_GRANTED, REJECTED }
fun checkPermissionState(
activity: Activity,
permissionName: String
) = when {
ContextCompat.checkSelfPermission(activity, permissionName)
== PackageManager.PERMISSION_GRANTED -> PermissionState.GRANTED
ActivityCompat.shouldShowRequestPermissionRationale(
activity,
You can’t perform that action at this time.