Skip to content

Instantly share code, notes, and snippets.

View khaeransori's full-sized avatar
👋

Khaer Ansori khaeransori

👋
View GitHub Profile
@khaeransori
khaeransori / gist:8399227
Last active January 3, 2016 02:59
subquery
SELECT
a.*,
(SELECT nama FROM penduduk WHERE nik=a.nik_kadus) as nama_kadus,
(SELECT COUNT(*) FROM rw WHERE id_dusun=a.id) as jumlah_rw,
(SELECT COUNT(*) FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id)) as jumlah_rt,
(SELECT COUNT(*) FROM kk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw = (SELECT id FROM rw WHERE id_dusun=a.id))) as jumlah_kk,
(SELECT COUNT(*) FROM penduduk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id))) as jumlah_jiwa,
(SELECT COUNT(*) FROM penduduk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id)) && jenis_kelamin='laki - laki') as jumlah_jiwa,
(SELECT COUNT(*) FROM penduduk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id)) && jenis_kelamin='perempuan') as jumlah_jiwa
FROM dusun AS a
@khaeransori
khaeransori / daftarkonsultasi.php
Created July 12, 2014 10:08
autocomplete buat jati
<div class="container-non-responsive" id="content" data-baseurl="<?php echo base_url();?>">
<?php
if (isset($_POST['negara']) or isset($_POST['provinsi']) or isset($_POST['kota']) or isset($_POST['klinik']) or isset($_POST['dokter']) or isset($_POST['spesialis'])) {
$negara = $this->input->post('negara');
$prop = $this->input->post('provinsi');
$kota = $this->input->post('kota');
$klinik = $this->input->post('klinik');
$dokter = $this->input->post('dokter');
$spesialis = $this->input->post('spesialis');
@khaeransori
khaeransori / anggota.php
Last active August 29, 2015 14:03
remote anggota buat jati
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Anggota extends CI_Controller {
public function __construct()
{
parent::__construct();
header('Content-type: application/json');
header('Access-Control-Allow-Origin: *');
$this->load->model('model_konsultasi');
@khaeransori
khaeransori / gist:3b82d4d024f8c6463428
Created July 18, 2014 20:42
konsultasi online anggota
// url nya sama kayak kemarin, /remote/anggota/..
public function get_jadwal_konsultasi_online()
{
$negara = $this->input->post('negara');
$prop = $this->input->post('provinsi');
$kota = $this->input->post('kota');
$klinik = $this->input->post('klinik');
$dokter = $this->input->post('dokter');
$spesialis = $this->input->post('spesialis');
@khaeransori
khaeransori / Antrian.java
Last active August 29, 2015 14:05
Tugas SP Strukdat #3
public class Antrian {
node genapdepan;
node ganjildepan;
node genapbelakang;
node ganjilbelakang;
int jumlahgenap;
int jumlahganjil;
@khaeransori
khaeransori / Node.java
Created August 21, 2014 14:36
Tugas Struktur Data SP 2014 (pengganti kuliah hari Rabu 20 Agustus 2014)
public class Node {
Node kanan, kiri;
Integer data;
public Node(){
}
public Node(Integer x) {
data = x;
@khaeransori
khaeransori / gist:8c785df237a4ea97f003
Last active August 29, 2015 14:07
query menghitung jarak dengan koordinat
SELECT *,
(
3959
* acos( cos( radians( {$lat} ) )
* cos( radians( `lat` ) )
* cos( radians( `long` )
- radians( {$long} ) )
+ sin( radians( {$lat} ) )
* sin( radians( `lat` ) ) )
* 1.609344
@khaeransori
khaeransori / kpk_dan_fpb.php
Last active September 21, 2016 14:03
Fungsi menghitung KPK dan FPB
<?php
//untuk menentukan FPB 2 bilangan maka panggil fungsi gcf(angka1, angka2);
function gcf($a, $b) {
return ( $b == 0 ) ? ($a):( gcf($b, $a % $b) );
}
//untuk menentukan KPK 2 bilangan maka panggil fungsi lcm(angka1, angka2);
function lcm($a, $b) {
return ( $a / gcf($a,$b) ) * $b;
}
echo "Soal Nomor 1-3. <br/>";
@khaeransori
khaeransori / terbilang.php
Last active August 29, 2015 14:09
Fungsi Mencari Bilangan Terbilang
<?php
function kekata($x) {
$x = abs($x);
$angka = array("", "satu", "dua", "tiga", "empat", "lima",
"enam", "tujuh", "delapan", "sembilan", "sepuluh", "sebelas");
$temp = "";
if ($x <12) {
$temp = " ". $angka[$x];
} else if ($x <20) {
$temp = kekata($x - 10). " belas";
angular.module('app.resources', ['ngResource'])
.factory('api', function ($resource) {
var api = {
defaultConfig : {id: '@id'},
extraMethods: {
'update' : {
method: 'PUT'
}