Skip to content

Instantly share code, notes, and snippets.

View rajitha-bandara's full-sized avatar

Rajitha Bandara rajitha-bandara

View GitHub Profile
@rajitha-bandara
rajitha-bandara / handlebarjs-notes
Created March 23, 2018 01:57
Handlebar.js notes
1. Add dynamic css, js
https://github.com/ericf/express-handlebars/issues/15
https://stackoverflow.com/questions/25300017/how-to-ensure-the-javascript-is-at-the-bottom-of-the-code-in-express-handlebars
@rajitha-bandara
rajitha-bandara / gist:ce5f0f58547f9968b5d8f086b010f36b
Created June 3, 2018 04:13
Laravel eloquent delete with handling integrity constraint violation
try {
$category->delete();
}
catch (\Illuminate\Database\QueryException $e) {
if($e->getCode() == "23000"){ //23000 is sql code for integrity constraint violation
// return error to user here
}
}
@rajitha-bandara
rajitha-bandara / gist:e74d5be20541751a06a8187da8f46130
Created June 19, 2018 04:46
Mysql Load Data
LOAD DATA INFILE 'V:/Downloads/Temp/Homes DB(1).csv'
INTO TABLE land_developers FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(name, email, phone_1, street, suburb, estate)
@rajitha-bandara
rajitha-bandara / gist:c372d0d9b5e6ac793217494721a671a2
Created June 23, 2018 15:02
VS 2017 Report Viewer
http://shashangka.com/2017/05/17/enable-rdlc-reporting-in-visual-studio-2017/
@rajitha-bandara
rajitha-bandara / gist:f7527346999ef957b3baabc24d5c9827
Created July 3, 2018 06:14
Bootstrap Month & Year Picker
http://bootstrap-datepicker.readthedocs.io
$('.datepicker_y_M').datepicker({
format: "M yyyy",
startView: "year",
minViewMode: "months",
autoclose: true
})
@rajitha-bandara
rajitha-bandara / HTML Table Filter with jQuery
Created July 5, 2018 05:01
function filter_by_project(){
var input, filter, table, tr, td, i;
input = $("#project_filter").val();
filter = input.toUpperCase();
table = document.getElementById("receivings_table");
tr = table.getElementsByTagName("tr");
for (i = 0; i < tr.length; i++) {
td = tr[i].getElementsByTagName("td")[3];
if (td) {
@rajitha-bandara
rajitha-bandara / ngrok
Created October 2, 2018 03:47
https://helgesverre.com/blog/expose-local-webserver/
@rajitha-bandara
rajitha-bandara / gist:7ba899c498878fc79e32ee4a2b13c6b3
Last active November 15, 2018 06:13
Report tools
https://www.koolreport.com
https://github.com/PHPJasper
http://reportico.org/laravel/public/index.php/getting-started
http://www.metabase.com/
apache c
reportserver.net‎
@rajitha-bandara
rajitha-bandara / amazon-ec2-ftp.md
Last active October 21, 2018 15:36 — forked from gunjanpatel/amazon-ec2-ftp.md
amazon ec2 LAMP and FTP installation and setup
@rajitha-bandara
rajitha-bandara / gist:cfae596d9062f1a1f463c2ea2d48df70
Last active October 28, 2018 15:30
BI
https://www.youtube.com/watch?v=0zhQ52BQQ5s
https://www.metabase.com
apache superset
https://www.spagobi.org/documentation/
https://www.predictiveanalyticstoday.com/open-source-free-business-intelligence-solutions/
https://www.metabase.com/docs/latest/operations-guide/running-the-metabase-jar-file.html