Widoyo widoyo

Python Developer @ sweet home

widoyo / gist:10946079

Created April 17, 2014 01:02

	CREATE OR REPLACE PROCEDURE insert_a
	AS
	tgl varchar2(12);
	msg varchar2(3500);
	JAM DATE;
	file UTL_FILE.FILE_TYPE;
	bat UTL_FILE.FILE_TYPE;
	file_scripts UTL_FILE.FILE_TYPE;
	begin
	file := UTL_FILE.FOPEN('C:\TEMP', 'insert A.txt','w', 8000);

widoyo / upload.php

Last active August 29, 2015 14:01

	<?
	date_default_timezone_set('Asia/Jakarta');
	error_reporting(E_ERROR);

	//################
	//Connect ke Mysql
	// $db = mysql_connect("localhost" , "root", "root") or die ("could not connect to mysql.");
	$db = mysql_connect("www.sparelog.com" , "rachmatg_tinem", "tinem") or die (date("Y M D d H:i:s") ." >> could not connect to sparelog db.\r\n");

	echo date("Y M D d H:i:s") . " >> Sparelog Connection OK \r\n";

widoyo / nec_take.js

Created May 30, 2014 02:05

Stocktake Script

	$(document).ready(function(){
	var currentBin = '',
	latestScanned = '';
	var bin = [];
	var binContent = [],
	scanned = [];
	var req;
	var stocktake_id = $('#id_stocktake').text();
	var au_success = $('#ding'),
	au_load = $('#load'),

widoyo / collect_pra_recon.py

Created June 5, 2014 07:15

Collect Pra Recon

	import os, datetime

	from django.core.management.base import BaseCommand, CommandError
	from django.db import connections
	from django.conf import settings

	import paramiko

	SSH_USERNAME = getattr(settings, 'SSH_USERNAME', 'mulyo')
	SSH_PASSWORD = getattr(settings, 'SSH_PASSWORD', 'toha123')

widoyo / publish.html

Last active August 29, 2015 14:10

Demo pubnub Kuliah Umum Informatika UNS

	<!doctype>
	<html>
	<head>
	<!-- Include the PubNub Library -->
	<script src="https://cdn.pubnub.com/pubnub.min.js"></script>
	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>

	<!-- Instantiate PubNub -->
	<script type="text/javascript">

widoyo / create_num.py

Created February 11, 2016 07:26

	def create_num(num):
	'''
	Script Pythonfu untuk Gimp
	'''
	img = gimp.Image(384, 160, 1)
	pdb.gimp_context_push()
	text_layer = pdb.gimp_text_fontname(img, None, 60, 0, num, -1, True, 142, 0, "Ubuntu Bold Italic")
	pdb.gimp_layer_resize_to_image(text_layer)
	layer = pdb.gimp_image_flatten(img)
	pdb.file_png_save_defaults(img, layer, "/tmp/%s.png" % num, "/tmp/%s.png" % num)

widoyo / PrintFloat.cc

Created April 13, 2016 20:56

PrintFloat, Arduino/Genuino

	// printFloat prints out the float 'value' rounded to 'places' places after the decimal point
	void printFloat(float value, int places) {
	// this is used to cast digits
	int digit;
	float tens = 0.1;
	int tenscount = 0;
	int i;
	float tempfloat = value;

	// make sure we round properly. this could use pow from <math.h>, but doesn't seem worth the import

widoyo / main.py

Last active March 12, 2017 05:45

MarketPlace Stats

	# -- coding: utf-8 --

	from urllib2 import urlopen
	from HTMLParser import HTMLParser


	products = open('produk.txt').readlines()
	STATS_START = '<dl class=\'c-deflist\''
	STATS_END = '</dl>'

widoyo / anomaly_detect.py

Last active May 22, 2018 23:20

Pencari data Anomali

	def anomaly_detect(nama_pos, sampling_awal, sampling_akhir):
	'''Return [('SamplingDate', 'SamplingTime', oldval, newval)]'''
	pass


	if __name__ == "__main__":
	anomaly_detect('dengkeng', '2016-01-01', '2016-01-31')

widoyo / anomaly_recomended.py

Created May 21, 2018 22:46

Temukan Saran Data ketika ketemu data anomaly

	#Anomali Data Detection
	import pandas as pd

	#----------Data Preparation
	df = pd.read_csv("E:/2.KULIAH/KP2_BBWS/DEBIT/tma_wonogiri.csv",header=None)

	#colNaming
	df.columns = ["DATE", "TIME", "OLD_VAL"]
	#Combine column
	df["DATETIME"] = df["DATE"].map(str) + " " + df["TIME"]