Skip to content

Instantly share code, notes, and snippets.

View widoyo's full-sized avatar

Widoyo widoyo

View GitHub Profile
@widoyo
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
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'),
<?
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";
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
widoyo / index.js
Created March 28, 2014 09:08
Client Side Chatting
function init() {
var serverBaseUrl = document.domain;
/*
On client init, try to connect to the socket.IO server.
Note we don't specify a port since we set up our server
to run on port 8080
*/
var socket = io.connect(serverBaseUrl);
@widoyo
widoyo / api.js
Created December 27, 2013 18:57 — forked from fwielstra/api.js
/* The API controller
Exports 3 methods:
* post - Creates a new thread
* list - Returns a list of threads
* show - Displays a thread and its posts
*/
var Thread = require('../models/thread.js');
var Post = require('../models/post.js');
@widoyo
widoyo / query_2_csv.ps1
Created October 24, 2013 03:17
Export hasil query MS SQL ke CSV
#Connection Strings
$Database = "Database"
$Server = "SQLServer"
#Export File
$AttachmentPath = "C:\SQLData.csv"
# Connect to SQL and query data, extract data to SQL Adapter
$SqlQuery = "SELECT * FROM dbo.Test_Table"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
#Connection Strings
$Database = "Database"
$Server = "SQLServer"
#SMTP Relay Server
$SMTPServer = "smtp.domain.com"
#Export File
$AttachmentPath = "C:\SQLData.csv"
# Connect to SQL and query data, extract data to SQL Adapter
$SqlQuery = "SELECT * FROM dbo.Test_Table"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
@widoyo
widoyo / AGA3.py
Created September 26, 2013 23:07 — forked from giljunqueira/AGA3.py
# -*- coding: utf-8 -*-
"""
Created on Fri Aug 27 09:16:20 2010
@author: g.junqueira
AGA3 METER GAS CALCULATION IMPLEMENTATION as a callable Python function
"""
import math
[ui]
username = 'Widoyo <[email protected]>'
[paths]
default-push = http://[email protected]/widoyo/sparelog-hsm
[hooks]
precommit.put_rev = .hg/put_rev.sh