Skip to content

Instantly share code, notes, and snippets.

View oshanz's full-sized avatar
On vacation

Oshan Wisumperuma oshanz

On vacation
View GitHub Profile
oshanz / ssh message
Created January 23, 2014 16:10
Send message to remote PC via SSH
ssh -X login
export DISPLAY=:0
xmessage 'hi'
xdialog 'hi'
libnotify 'hi'
notify-send 'hi'
oshanz / jquery date range
Created January 25, 2014 05:05
jquery date range
$(document).ready(function() {
dateFormat: "yy-mm-dd",
changeMonth: true,
changeYear: true,
maxDate: new Date(),
onClose: function(selectedDate) {
$("#To").datepicker("option", "minDate", selectedDate);
oshanz / jquery date as sql format
Created January 25, 2014 05:08
jquery date as sql format
var now = new Date();
var day = ("0" + now.getDate()).slice(-2);
var month = ("0" + (now.getMonth() + 1)).slice(-2);
var today = now.getFullYear()+"-"+(month)+"-"+(day) ;
oshanz / ajax
Last active January 4, 2016 10:59
type: 'post',
url: URL + 'index/updateDetails',
data: $('#form_updateUserDetails').serialize(),
//data: {'page': page, 'from': $('#From').val(), 'to': $('#To').val()},
success: function(data) {
// console.log(data);
oshanz / htm tabl 2 excel - function
Last active January 4, 2016 10:59
client side html table export to excel
function ExportExcel(table) {
if (!table.nodeType) {
table = document.getElementById(table);
download(table.outerHTML, "ftable.xls", "application/");
alert('not a tbl');
oshanz / java se proxy
Created January 25, 2014 06:36
java se proxy
//use manual settings
System.setProperty("http.proxyHost", host);
System.setProperty("http.proxyPort", port);
//use system proxy
System.setProperty("", "true");
oshanz / 3cpo log off
Last active January 4, 2016 10:59
3cpo log off
turning off the default log (optional)
Properties p = new Properties(System.getProperties());
p.put("com.mchange.v2.log.MLog", "com.mchange.v2.log.FallbackMLog");
p.put("com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL", "OFF");
oshanz / git
Last active January 4, 2016 15:49
git instaweb --httpd=apache2
git_stats generate
gitstats generate
gitstats generate -o stats
gitstats -o stats
gitstats -o
oshanz / mysql variable
Created January 27, 2014 05:00
mysql variable
$query = "SELECT * ,
@amount:=(SELECT SUM((`ghi_qty`*`g_price`)) FROM `tbl_grn_has_item` ghi WHERE ghi.`idgrn`= grn.`idgrn`) AS amount,
(@amount-(@amount*(grn.g_discount/100))) AS `grandtotal`,
(@amount*(grn.g_discount/100)) AS `discount`
FROM `tbl_grn` grn
INNER JOIN `tbl_delivery_note` dn ON grn.`iddelivery_note`= dn.`iddelivery_note`
INNER JOIN `tbl_purchase_order` po ON dn.`idpurchase_order`= po.`idpurchase_order`
INNER JOIN `tbl_user` tu ON po.`idposition`=tu.`iduser` WHERE grn.`g_status`='0' aND po.`idposition`='{$user_id}'{$querypart}";
oshanz / java post request
Created January 28, 2014 01:23
java post request
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
package send_sms;