Skip to content

Instantly share code, notes, and snippets.

View rafirh's full-sized avatar
🎯
Focusing

Muhammad Rafi Rahman Habibi rafirh

🎯
Focusing
View GitHub Profile
// test api, show to console https://api-portal-jatim.pisdev.my.id/api/users
// jquery request
$.ajax({
url: 'https://klinikhoaks.jatimprov.go.id/api/mobile/getjmlhoaksytd',
type: 'GET',
success: function(response) {
console.log(response);
},
error: function(xhr) {
@rafirh
rafirh / query.sql
Created May 20, 2024 04:42
Grant Access to a Schema
GRANT USAGE ON SCHEMA "user" TO username;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA "user" TO username;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA "user" TO username;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA "user" TO username;
SELECT
terminal.name as terminal,
city.name as kota,
COALESCE(count(
CASE
WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
ELSE null
END), 0::bigint) AS ar_vehicle_akap,
COALESCE(sum(
CASE
SELECT
terminal.name as terminal,
city.name as kota,
COALESCE(count(
CASE
WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
ELSE null
END), 0::bigint) AS ar_vehicle_akap,
COALESCE(sum(
CASE
SELECT
terminal.name as terminal,
city.name as kota,
COALESCE(count(
CASE
WHEN r.is_arrival = true AND r.tvehicle_type_id = 4 THEN r.id
ELSE null
END), 0::bigint) AS ar_vehicle_akap,
COALESCE(sum(
CASE
import java.io.*;
import java.util.*;
public class Solution {
public static String formatRupiah(int nominal) {
String strNominal = String.valueOf(nominal);
String strNominalFormatted = "";
int counter = 0;
for (int i = strNominal.length() - 1; i >= 0; i--) {
strNominalFormatted = strNominal.charAt(i) + strNominalFormatted;
import java.util.Scanner;
public class Solution {
public static void main(String[] args) {
Scanner scanner = new Scanner(System.in);
String kelas = scanner.nextLine();
String nama = scanner.nextLine();
System.out.println("Nama : " + nama);
import java.util.Scanner;
public class Solution {
public static void main(String[] args) {
Scanner scanner = new Scanner(System.in);
int jumlahOrang = scanner.nextInt();
scanner.nextLine();
String[][] jadwalTV = new String[3][3];
import java.util.Scanner;
public class Solution {
public static void main(String[] args) {
Scanner scanner = new Scanner(System.in);
String kalimat = scanner.nextLine();
String hasil = removeVowels(kalimat);
System.out.println(hasil);
import java.util.*;
public class Solution {
public static void main(String[] args) {
Scanner scanner = new Scanner(System.in);
int batasMaksimal = scanner.nextInt();
scanner.nextLine();
String kalimat = scanner.nextLine();