Skip to content

Instantly share code, notes, and snippets.

View ardianta's full-sized avatar
👋
hi!

Ahmad Muhardian ardianta

👋
hi!
596 followers · 355 following
View GitHub Profile
@ardianta
ardianta / select_most_booking_hours.sql
Created November 11, 2024 02:46
Query to show the most active booking hours
SELECT
HOUR(CONVERT_TZ(`bookingCreatedAt`, '+00:00', '+08:00')) AS jam, -- convert UTC time to local time +08:00
COUNT(*) AS total_booking
FROM
Booking -- table name
WHERE
YEAR(`bookingCreatedAt`) = 2024 AND MONTH(`bookingCreatedAt`) = 10 -- month of year 2024
GROUP BY
jam
ORDER BY
@ardianta
ardianta / remove-pdf-cover-batch.sh
Created December 6, 2023 05:46
Remove the first page of PDFs using pdftk
mkdir out
for i in *pdf; do pdftk "$i" cat 2-end output "out/$i"; done
@ardianta
ardianta / static-pages-hosting.md
Last active October 26, 2021 15:27
List tempat hosting web statis
@ardianta
ardianta / zoom-dl.sh
Created June 3, 2021 13:52
Zoom video recorded downloader
#!/bin/sh
url="$1"
jar=$(mktemp)
mp4=$(curl -s -c "$jar" "$url" | grep video/mp4 | grep -o 'https:[^"]*')
file=$(echo "$mp4" | grep -o "[^/? ]*\.mp4")
echo "Downloading $file"
curl -b "$jar" -o "$file" -e "$url" "$mp4"
rm "$jar"
@ardianta
ardianta / medium-text-styles.css
Last active August 28, 2020 09:39
Medium like Typography style for Callibre Ebook Reader
p {
text-align: left;
overflow-wrap: break-word;
margin-top: 2em;
margin-bottom: 0.46em;
word-break: break-word;
font-style: normal;
font-weight: 400;
letter-spacing: -0.003em;
line-height: 32px;
@ardianta
ardianta / Remove_MIUI_Bloatware.CMD
Created August 16, 2020 08:08 — forked from Biswa96/Remove_MIUI_Bloatware.CMD
Remove bloatware applications from MIUI ROM in Xiaomi phones
@echo off
set /p Y=Enter adb.exe folder path:
cd /d %Y%
adb devices
pause
for %%X in (
"com.amazon.appmanager"
"com.android.browser"
"com.android.chrome"
"com.android.email"
@ardianta
ardianta / hugo-shortcode-bulk-replace.md
Last active August 28, 2020 08:41
VS Code Find and Replace using Regex

I want to find this string:

{{< img "/img/image-name.png" "Image Caption" >}}

And replace with:

![Image Caption](/img/image-name.png)
@ardianta
ardianta / clear_screen.c
Created January 2, 2020 01:03
Clear Screen in C
#include <stdlib.h>
#include <stdio.h>
void clear_screen(){
#ifdef _WIN32
system("cls");
#elif defined(unix) || defined(__unix__) || defined(__unix) || (defined(__APPLE__) && defined(__MACH__))
system("clear");
//add some other OSes here if needed
#else
@ardianta
ardianta / TodoListApp.java
Last active January 9, 2020 01:59
Simple Todo List App using Java and File
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Scanner;
public class TodoListApp {
static String fileName;
@ardianta
ardianta / wacom-linux.md
Created June 12, 2019 12:21
Multimonitor Wacom Linux Kubuntu

Gunakan driver: https://github.com/linuxwacom/xf86-input-wacom/wiki/xsetwacom

dian@petanikode~> xrandr
Screen 0: minimum 320 x 200, current 3286 x 1080, maximum 8192 x 8192
eDP-1 connected 1366x768+0+0 (normal left inverted right x axis y axis) 309mm x 173mm
   1366x768      59.97*+
   1360x768      59.80    59.96  
   1280x720      60.00    59.99    59.86    59.74  
   1024x768      60.04    60.00