5 Script Otomasi Pekerjaan: Panduan Skrip Otomatisasi Python Dasar untuk Efisiensi Kerja

import os
import shutil
import sys
from datetime import datetime

SOURCE_DIR = "/Users/kamu/Downloads"
TARGET_DIR = "/Users/kamu/Dokumen/Terorganisir"

EXTENSIONS = {
    "Gambar": [".jpg", ".jpeg", ".png", ".gif", ".webp", ".svg"],
    "Dokumen": [".pdf", ".docx", ".xlsx", ".pptx", ".txt", ".csv"],
    "Video": [".mp4", ".mov", ".avi", ".mkv"],
    "Audio": [".mp3", ".wav", ".flac", ".aac"],
}

def organize_files():
    """Memindai direktori dan memindahkan berkas berdasarkan kategori ekstensi."""
    try:
        if not os.path.exists(SOURCE_DIR):
            raise FileNotFoundError(f"Direktori sumber tidak ditemukan: {SOURCE_DIR}")

        os.makedirs(TARGET_DIR, exist_ok=True)
        files = [f for f in os.listdir(SOURCE_DIR) if os.path.isfile(os.path.join(SOURCE_DIR, f))]
        
        if not files:
            print("ℹ️ Tidak ada berkas baru di direktori sumber.")
            return

        total_moved = 0
        for filename in files:
            filepath = os.path.join(SOURCE_DIR, filename)
            ext = os.path.splitext(filename)[1].lower()
            category_folder = "Lainnya"

            for category, ext_list in EXTENSIONS.items():
                if ext in ext_list:
                    category_folder = category
                    break

            dest_folder = os.path.join(TARGET_DIR, category_folder)
            os.makedirs(dest_folder, exist_ok=True)

            timestamp = datetime.now().strftime("%Y%m%d_%H%M%S")
            new_name = f"{timestamp}_{filename}"
            dest_filepath = os.path.join(dest_folder, new_name)

            try:
                shutil.move(filepath, dest_filepath)
                print(f"✅ [{category_folder}] {filename} → {new_name}")
                total_moved += 1
            except PermissionError:
                print(f"⚠️ Izin ditolak untuk memindahkan berkas: {filename}", file=sys.stderr)
            except Exception as e:
                print(f"❌ Gagal memindahkan {filename}: {e}", file=sys.stderr)

        print(f"\n🎉 Selesai! Berhasil mengorganisir {total_moved} berkas.")

    except FileNotFoundError as fnf_err:
        print(f"❌ Kesalahan Path: {fnf_err}", file=sys.stderr)
    except PermissionError:
        print("❌ Kesalahan Izin: Akses ke folder ditolak. Jalankan dengan hak akses yang sesuai.", file=sys.stderr)
    except Exception as general_err:
        print(f"❌ Terjadi kesalahan tak terduga: {general_err}", file=sys.stderr)

if __name__ == "__main__":
    organize_files()

import smtplib
import os
import sys
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from email.mime.base import MIMEBase
from email import encoders
from datetime import date

# === KONFIGURASI PENGIRIMAN ===
SMTP_HOST      = "smtp.gmail.com"
SMTP_PORT      = 465
EMAIL_PENGIRIM = "emailkamu@gmail.com"
PASSWORD_APP   = "xxxx xxxx xxxx xxxx"  # 16 digit Gmail App Password
EMAIL_PENERIMA = ["atasan@perusahaan.com", "klien@email.com"]
FILE_LAPORAN   = "/path/ke/laporan_harian.xlsx"

def kirim_laporan():
    """Mengirim email laporan harian beserta lampiran dengan exception handling terperinci."""
    hari_ini = date.today().strftime("%d %B %Y")
    
    msg = MIMEMultipart()
    msg["From"]    = EMAIL_PENGIRIM
    msg["To"]      = ", ".join(EMAIL_PENERIMA)
    msg["Subject"] = f"Laporan Operasional Harian - {hari_ini}"

    body = f"Halo Tim,\n\nTerlampir laporan operasional untuk periode {hari_ini}.\nMohon dicek dan dikonfirmasi.\n\nSalam,\nSistem Otomasi InfoKoding"
    msg.attach(MIMEText(body, "plain"))

    # Validasi lampiran berkas
    if os.path.exists(FILE_LAPORAN):
        try:
            with open(FILE_LAPORAN, "rb") as attachment:
                part = MIMEBase("application", "octet-stream")
                part.set_payload(attachment.read())
            encoders.encode_base64(part)
            part.add_header(
                "Content-Disposition",
                f"attachment; filename={os.path.basename(FILE_LAPORAN)}"
            )
            msg.attach(part)
        except IOError as io_err:
            print(f"⚠️ Gagal membaca berkas lampiran ({FILE_LAPORAN}): {io_err}", file=sys.stderr)
    else:
        print(f"⚠️ Berkas lampiran tidak ditemukan pada path: {FILE_LAPORAN}. Mengirim email tanpa lampiran.")

    # Eksekusi pengiriman via SMTP SSL
    try:
        print(f"🔄 Menghubungkan ke server SMTP {SMTP_HOST}:{SMTP_PORT}...")
        with smtplib.SMTP_SSL(SMTP_HOST, SMTP_PORT, timeout=20) as server:
            server.login(EMAIL_PENGIRIM, PASSWORD_APP)
            server.sendmail(EMAIL_PENGIRIM, EMAIL_PENERIMA, msg.as_string())
        print(f"✅ Laporan berhasil terkirim ke: {', '.join(EMAIL_PENERIMA)}")

    except smtplib.SMTPAuthenticationError:
        print("❌ Otentikasi Gagal: Password App salah atau 2-Step Verification belum aktif.", file=sys.stderr)
    except smtplib.SMTPConnectError:
        print(f"❌ Koneksi Gagal: Tidak dapat menghubungi server {SMTP_HOST}.", file=sys.stderr)
    except smtplib.SMTPServerDisconnected:
        print("❌ Terputus: Koneksi ke server SMTP terputus di tengah proses.", file=sys.stderr)
    except Exception as err:
        print(f"❌ Terjadi kesalahan pengiriman email: {err}", file=sys.stderr)

if __name__ == "__main__":
    kirim_laporan()

#!/usr/bin/env bash
# ==============================================================================
# Script Otomasi Pencadangan Data dengan Error Trap & Integrity Check
# ==============================================================================
set -euo pipefail
IFS=$'\n\t'

trap 'echo "❌ [ERROR] Terjadi kegagalan pada baris $LINENO. Proses dihentikan!" >&2' ERR

# === KONFIGURASI DIREKTORI ===
SOURCE_DIR="/var/www/html/project_utama"
BACKUP_DIR="/mnt/backup/web"
MAX_BACKUP_RETENTION=7   # Kuota arsip yang disimpan
DATE_TAG=$(date +"%Y-%m-%d_%H-%M-%S")
BACKUP_FILE="${BACKUP_DIR}/backup_${DATE_TAG}.tar.gz"

echo "🔄 [$(date)] Memulai proses pencadangan..."

if [ ! -d "$SOURCE_DIR" ]; then
    echo "❌ [ERROR] Direktori sumber tidak ditemukan: $SOURCE_DIR" >&2
    exit 1
fi

mkdir -p "$BACKUP_DIR"

echo "📦 Mengompresi berkas dari: $SOURCE_DIR"
tar -czf "$BACKUP_FILE" -C "$(dirname "$SOURCE_DIR")" "$(basename "$SOURCE_DIR")"

if [ -f "$BACKUP_FILE" ] && [ -s "$BACKUP_FILE" ]; then
    FILE_SIZE=$(du -sh "$BACKUP_FILE" | cut -f1)
    echo "✅ [SUKSES] Arsip berhasil dibuat: $BACKUP_FILE ($FILE_SIZE)"
else
    echo "❌ [ERROR] Berkas arsip rusak atau berukuran 0 byte!" >&2
    exit 1
fi

echo "🧹 Memeriksa kuota penyimpanan arsip (retensi: $MAX_BACKUP_RETENTION berkas)..."
cd "$BACKUP_DIR"
TOTAL_FILES=$(ls -1 backup_*.tar.gz 2>/dev/null | wc -l || true)

if [ "$TOTAL_FILES" -gt "$MAX_BACKUP_RETENTION" ]; then
    ls -t backup_*.tar.gz | tail -n +$((MAX_BACKUP_RETENTION + 1)) | while read -r old_file; do
        rm -f "$old_file"
        echo "🗑️ Dihapus: $old_file"
    done
fi

echo "✨ [$(date)] Seluruh rangkaian pencadangan selesai dengan sukses."

function buatLaporanMingguan() {
  try {
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    const sheetData = ss.getSheetByName("Data");
    
    if (!sheetData) {
      throw new Error("Sheet dengan nama 'Data' tidak ditemukan! Pastikan nama sheet sesuai.");
    }

    const sheetLaporan = ss.getSheetByName("Laporan") || ss.insertSheet("Laporan");
    const data = sheetData.getDataRange().getValues();

    if (data.length <= 1) {
      Logger.log("⚠️ Tidak ada baris data untuk diproses.");
      return;
    }

    const header = data[0];
    const rows = data.slice(1);
    const totals = {};

    header.forEach((colName, index) => {
      const numericValues = rows
        .map(row => Number(row[index]))
        .filter(val => !isNaN(val) && val !== 0);

      if (numericValues.length > 0) {
        const sum = numericValues.reduce((acc, curr) => acc + curr, 0);
        totals[colName] = {
          total: sum,
          rata: (sum / numericValues.length).toFixed(2),
          count: numericValues.length
        };
      }
    });

    sheetLaporan.clearContents();
    const now = new Date();
    sheetLaporan.getRange("A1").setValue(`📊 Laporan Mingguan Otomatis - ${now.toLocaleDateString("id-ID")}`);
    sheetLaporan.getRange("A1").setFontSize(14).setFontWeight("bold");

    let currentRow = 3;
    sheetLaporan.getRange(currentRow, 1, 1, 4)
      .setValues([["Nama Kolom", "Total Nilai", "Rata-rata", "Jumlah Baris"]])
      .setFontWeight("bold")
      .setBackground("#4285F4")
      .setFontColor("#FFFFFF");
    currentRow++;

    Object.entries(totals).forEach(([col, stat]) => {
      sheetLaporan.getRange(currentRow++, 1, 1, 4).setValues([[col, stat.total, stat.rata, stat.count]]);
    });

    const targetEmail = Session.getActiveUser().getEmail() || "admin@perusahaan.com";
    GmailApp.sendEmail(
      targetEmail,
      `Laporan Mingguan Otomatis - ${now.toLocaleDateString("id-ID")}`,
      `Halo,\n\nRingkasan laporan data mingguan Anda telah berhasil dikompilasi.\nAkses sheet: ${ss.getUrl()}\n\nSalam,\nSistem Otomasi Google Workspace`
    );

    Logger.log("✅ Laporan berhasil dibuat dan dikirim ke: " + targetEmail);

  } catch (err) {
    Logger.log("❌ Terjadi kesalahan pada script: " + err.toString());
    SpreadsheetApp.getUi().alert("Gagal memproses laporan: " + err.message);
  }
}

function jadwalkanOtomatis() {
  try {
    const existingTriggers = ScriptApp.getProjectTriggers();
    existingTriggers.forEach(t => {
      if (t.getHandlerFunction() === "buatLaporanMingguan") {
        ScriptApp.deleteTrigger(t);
      }
    });

    ScriptApp.newTrigger("buatLaporanMingguan")
      .timeBased()
      .onWeekDay(ScriptApp.WeekDay.FRIDAY)
      .atHour(17)
      .create();

    SpreadsheetApp.getUi().alert("✅ Jadwal otomatis setiap Jumat pukul 17.00 berhasil diaktifkan!");
  } catch (err) {
    Logger.log("❌ Gagal membuat jadwal otomatis: " + err.toString());
  }
}

import requests
import time
import sys

# === KONFIGURASI MONITORING ===
WEBSITES = [
    "https://infokoding.com",
    "https://google.com"
]
TELEGRAM_TOKEN = "ISI_TOKEN_BOT_TELEGRAM"
TELEGRAM_CHAT_ID = "ISI_CHAT_ID_TELEGRAM"
CHECK_INTERVAL_SEC = 300  # 5 menit
REQUEST_TIMEOUT_SEC = 15

def kirim_notifikasi_telegram(pesan):
    """Mengirim notifikasi ke Telegram dengan handling jaringan."""
    endpoint = f"https://api.telegram.org/bot{TELEGRAM_TOKEN}/sendMessage"
    payload = {
        "chat_id": TELEGRAM_CHAT_ID,
        "text": pesan,
        "parse_mode": "Markdown"
    }
    try:
        resp = requests.post(endpoint, json=payload, timeout=10)
        resp.raise_for_status()
    except requests.exceptions.HTTPError as http_err:
        print(f"⚠️ Gagal kirim Telegram (HTTP Error): {http_err}", file=sys.stderr)
    except requests.exceptions.RequestException as req_err:
        print(f"⚠️ Gagal kirim Telegram (Network Error): {req_err}", file=sys.stderr)

def cek_status_website(url):
    """Memeriksa status HTTP dan waktu respons server."""
    try:
        waktu_mulai = time.time()
        respons = requests.get(url, timeout=REQUEST_TIMEOUT_SEC, headers={"User-Agent": "InfoKodingUptimeBot/1.0"})
        latensi = int((time.time() - waktu_mulai) * 1000)
        return respons.status_code, latensi
    except requests.exceptions.Timeout:
        return -1, 0
    except requests.exceptions.ConnectionError:
        return 0, 0
    except requests.exceptions.RequestException:
        return -2, 0

def monitor_loop():
    """Looping monitoring berkala."""
    print("🚀 Monitoring website aktif berjalan. Tekan Ctrl+C untuk berhenti.")
    status_terakhir = {}

    while True:
        try:
            for site in WEBSITES:
                status_code, latensi = cek_status_website(site)
                is_up = 200 <= status_code < 400
                status_sebelumnya = status_terakhir.get(site)

                if is_up:
                    print(f"🟢 [UP] {site} | {latensi}ms (HTTP {status_code})")
                    if status_sebelumnya is False:
                        pesan = f"🟢 *LAYANAN PULIH!*\n\n🌐 URL: `{site}`\n⏱ Response Time: {latensi}ms\n🕐 Jam: {time.strftime('%H:%M:%S')}"
                        kirim_notifikasi_telegram(pesan)
                else:
                    keterangan = "Timeout" if status_code == -1 else ("Connection Error" if status_code == 0 else f"HTTP {status_code}")
                    print(f"🔴 [DOWN] {site} | Alasan: {keterangan}", file=sys.stderr)
                    if status_sebelumnya is not False:
                        pesan = f"🔴 *PERINGATAN DOWNTIME!*\n\n🌐 URL: `{site}`\n⚠️ Kendala: {keterangan}\n🕐 Jam: {time.strftime('%H:%M:%S')}"
                        kirim_notifikasi_telegram(pesan)

                status_terakhir[site] = is_up

            print(f"⏳ Pengecekan berikutnya dalam {CHECK_INTERVAL_SEC // 60} menit...\n")
            time.sleep(CHECK_INTERVAL_SEC)

        except KeyboardInterrupt:
            print("\n🛑 Monitoring dihentikan.")
            sys.exit(0)
        except Exception as loop_err:
            print(f"⚠️ Terjadi galat loop: {loop_err}", file=sys.stderr)
            time.sleep(10)

if __name__ == "__main__":
    monitor_loop()