Skip to content

Instantly share code, notes, and snippets.

View ken-muturi's full-sized avatar

muturiken ken-muturi

View GitHub Profile

onadata Install Instructions

Ubuntu 14.04

1. Basic System Libraries and Packages

$ sudo apt-get update; sudo apt-get upgrade -y
$ sudo apt-get install -y git build-essential python-all-dev \
  python-pip python-lxml python-magic python-imaging default-jre \
function validatePassword(password){
var re = /^(?=.*[A-Z])[A-Za-z\d$@$!%*#?&^()-_+=`~|]{8,}$/;
if(re.test(password)){
return true;
}else{
return false;
}
};
function validateEmail(email){
var re = /^(([^<>()[\]\\.,;:\s@\"]+(\.[^<>()[\]\\.,;:\s@\"]+)*)|(\".+\"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/;
if(re.test(email)){
return true;
}else{
return false;
}
};
@ken-muturi
ken-muturi / Chomefixforunexpectedtoken
Last active August 29, 2015 14:03
Chrome Uncaught SyntaxError: Unexpected token =
stackoverflow.com/questions/19699257/uncaught-syntaxerror-unexpected-token-in-google-chrome
You are using a default parameter feature which is supported only by Firefox now.
function errorNotification(text) {
text = text || "Something went wrong!";
$.pnotify({
title: 'Error',
text: text,
type: 'error'
@ken-muturi
ken-muturi / gist:066b3f4b4623d9aaec3b
Last active August 29, 2015 14:03
Sencha Grid Manual Filter
//default filter params
var filters = {
ftype: 'filters',
autoReload: false,
local : false,
encode: false, // json encode the filter query
};
// docked elements
@ken-muturi
ken-muturi / gist:8da2bd99973458eb8df6
Created July 3, 2014 11:39
Left Join Null Column
What Comes
-------------------------------------------------
id | type | pet_name
1 | aardvark | NULL
2 | dog | Charlie
3 | dog | Rover
4 | cat | Tabby
5 | cat | Sandy
6 | cat | MeowMeow
@ken-muturi
ken-muturi / sencha-grid-config
Created May 26, 2014 11:47
sencha grid config
<script type="text/javascript">
var BASE_URL = '<?php echo base_url(); ?>';
var BASE_ICONS = BASE_URL+'assets/icons/';
var grid_state_id = 'grid_<?php echo $section_id;?>';
var grid_panel_id = 'tab-grid-<?php echo $section_id;?>';
Ext.Loader.setConfig({enabled: true});
Ext.Loader.setPath('Ext.ux', BASE_URL+'assets/js/ext/ux/');
@ken-muturi
ken-muturi / group-concat
Last active August 29, 2015 14:01
group concat
<?php
$sql_query = array();
foreach ($select_columns as $column)
{
$sql_query [] = "( SELECT group_concat( DISTINCT $column ) FROM $master_grid_section_table WHERE 1 {$_search_filter_query} {$created_by} {$denied_data_entries} ) as $column";
}
if( $result = $this->db->query("SELECT ". join(', ', $sql_query )))
{
@ken-muturi
ken-muturi / export-to-excel
Last active August 29, 2015 14:01
Export to excel
<?php
$actual_headers = array();
foreach ($data['fields'] as $field)
{
$actual_headers [] = $data['actual_headers'][$field];
}
$path = realpath(BASEPATH."../assets/fmt/xls/");
$fname = $title."-".time().".csv";
@ken-muturi
ken-muturi / csv-mysql-import
Created May 26, 2014 11:40
import CSv file to Mysql
LOAD DATA LOCAL INFILE 'G:/Floyd/small/small.csv' INTO TABLE `csv_data`
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r'
IGNORE 1 LINES;