adibenc

INSERT INTO `wilayah` (`id`, `kelurahan`, `kecamatan`, `kabupaten`, `provinsi`, `kodepos`) VALUES
(1, '', '', 'KABUPATEN PACITAN', 'JAWA TIMUR', '-'),
(2, '', '', 'KABUPATEN PONOROGO', 'JAWA TIMUR', '-'),
(3, '', '', 'KABUPATEN TRENGGALEK', 'JAWA TIMUR', '-'),
(4, '', '', 'KABUPATEN TULUNGAGUNG', 'JAWA TIMUR', '-'),
(5, '', '', 'KABUPATEN BLITAR', 'JAWA TIMUR', '-'),
(6, '', '', 'KABUPATEN KEDIRI', 'JAWA TIMUR', '-'),
(7, '', '', 'KABUPATEN MALANG', 'JAWA TIMUR', '-'),
(8, '', '', 'KABUPATEN LUMAJANG', 'JAWA TIMUR', '-'),
(9, '', '', 'KABUPATEN JEMBER', 'JAWA TIMUR', '-'),

adibenc

<?php

namespace App\Helpers;

/**
 * 
 * Static form helper
 * 
 */
class AppForm{

adibenc

public function cyclicAlpha($size,$n=0){
        $arr = range('A','Z');
        $gen = [];
        $cnt = 0;
        $strlen = 1;
        for($i=$n;$i<=$size;$i++){
            if($cnt >= sizeof($arr)){
                $cnt=0;
            }
            // echo $strlen;

adibenc

import json
from collections import namedtuple

trelloFileName = "trello-ehSCdYmQ.json"

def parse(isi):
	data = json.loads(isi, object_hook=lambda d: namedtuple('X', d.keys())(*d.values()))
	return data
	
isi = open(trelloFileName,"r").read()

adibenc

INSERT INTO `wilayah` VALUES ('41748', 'KEPUTIH', 'SUKOLILO', 'SURABAYA', 'JAWA TIMUR', '60111');
INSERT INTO `wilayah` VALUES ('41749', 'KALISARI', 'MULYOREJO', 'SURABAYA', 'JAWA TIMUR', '60112');
INSERT INTO `wilayah` VALUES ('41750', 'KEJAWEN PUTIH TAMBAK', 'MULYOREJO', 'SURABAYA', 'JAWA TIMUR', '60112');
INSERT INTO `wilayah` VALUES ('41751', 'DUKUH SUTOREJO', 'MULYOREJO', 'SURABAYA', 'JAWA TIMUR', '60113');
INSERT INTO `wilayah` VALUES ('41752', 'KALIJUDAN', 'MULYOREJO', 'SURABAYA', 'JAWA TIMUR', '60114');
INSERT INTO `wilayah` VALUES ('41753', 'MULYOREJO', 'MULYOREJO', 'SURABAYA', 'JAWA TIMUR', '60115');
INSERT INTO `wilayah` VALUES ('41754', 'MANYAR SABRANGAN', 'MULYOREJO', 'SURABAYA', 'JAWA TIMUR', '60116');
INSERT INTO `wilayah` VALUES ('41755', 'GEBANG PUTIH', 'SUKOLILO', 'SURABAYA', 'JAWA TIMUR', '60117');
INSERT INTO `wilayah` VALUES ('41756', 'KLAMPIS NGASEM', 'SUKOLILO', 'SURABAYA', 'JAWA TIMUR', '60117');
INSERT INTO `wilayah` VALUES ('41757', 'MENUR PUMPUNGAN', 'SUKOLILO', 'SURABAYA', 'JAWA TI

adibenc

/*
base : https://chandranrahul.wordpress.com/2017/12/04/extract-images-from-spreadsheet-using-phpexcel/
modified : Rab Apr 22 21:32:00 WIB 2020

- require
composer require phpoffice/phpspreadsheet

- imports
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing;

adibenc

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class AlterAddIdSekolah extends Migration
{
    /**
     * Run the migrations.

adibenc

<?php

// $get=$_GET;
$post=$_POST;

$num=isset($post['num'])?$post['num']:0;

?>
<form method="post" action="">
    <div>

adibenc

#append imgs
# thx for the thread! https://stackoverflow.com/questions/30227466/combine-several-images-horizontally-with-python
from PIL import Image,ImageDraw

images = [Image.open(x) for x in [str(i)+'.png' for i in range(1,901)]]
widths, heights = zip(*(i.size for i in images))

new_im = Image.new('RGB', (12*30, 12*30))

x_offset = 0

adibenc

<?php
$const=[
    [0,'Semua'],
    [1,'Pending'],
    [2,'Diterima'],
    [3,'Ditolak']
];
$const2=[
	"peg_nama"=>"Nama peg",
	"peg_id"=>"Id peg",