Roni Saha roniemicro

roniemicro / jquery-pattern-validator.js

Created December 9, 2015 11:33

Pattern validator

	jQuery.validator.addMethod("pattern", function (b, a, c) {
	if (this.optional(a)) {
	return true
	}
	if (typeof c === "string") {
	c = new RegExp("^(?:" + c + ")$")
	}
	return c.test(b)
	}, "Invalid format.");

roniemicro / Entity.php

Last active December 5, 2015 08:46

Uploadable extention example

	<?php

	use Doctrine\ORM\Mapping as ORM;
	use Symfony\Component\HttpFoundation\File\UploadedFile;
	use Symfony\Component\Validator\Constraints as Assert;
	use Gedmo\Mapping\Annotation as Gedmo;

	/**
	*
	* @ORM\Table()

roniemicro / tablespace.sql

Created December 3, 2015 06:53 — forked from phpfour/tablespace.sql

Oracle

	SELECT * FROM DBA_DATA_FILES;

	ALTER TABLESPACE TBS_DB
	ADD DATAFILE 'D:\APP\RBS\PRODUCT\11.2.0\DBHOME_1\DATABASE\TBS_DB5.DBF'
	SIZE 10G
	AUTOEXTEND ON;

	ALTER DATABASE DATAFILE 'D:\APP\RBS\PRODUCT\11.2.0\DBHOME_1\DATABASE\TITAS_DB2.DBF' AUTOEXTEND ON;

roniemicro / placeholder.js

Last active October 27, 2015 05:08

Modify placeholder.js to allow dropdown(with dynamic item)

	/*
	Copyright (c) 2003-2015, CKSource - Frederico Knabben. All rights reserved.
	For licensing, see LICENSE.md or http://ckeditor.com/license
	*/
	CKEDITOR.dialog.add("placeholder", function (a) {
	var b = a.lang.placeholder;
	a = a.lang.common.generalTab;
	return {
	title: b.title,
	minWidth: 300,

roniemicro / Oracle create USER

Created September 2, 2015 10:17

	CREATE USER TITAS
	IDENTIFIED BY TITAS_PASSWORD
	DEFAULT TABLESPACE TITAS_DB
	TEMPORARY TABLESPACE temp
	QUOTA UNLIMITED ON TITAS_DB;

	GRANT create session TO TITAS;
	GRANT create table TO TITAS;
	GRANT create view TO TITAS;
	GRANT create trigger TO TITAS;

roniemicro / index.pgp

Created August 24, 2015 05:06

WWW Project Browser

	<?php

	// Page créé par Shepard [Fabian Pijcke] <[email protected]>
	// Arno Esterhuizen <[email protected]>
	// et Romain Bourdon <[email protected]>
	// et Hervé Leclerc <[email protected]>
	//
	// Mise a jour par Herve Leclerc [email protected]
	// Ici par Mark James <http://www.famfamfam.com/lab/icons/silk/>

roniemicro / Appkernel.php

Last active August 29, 2015 14:20

Doctrine Uploadable extention uses

	...
	new Stof\DoctrineExtensionsBundle\StofDoctrineExtensionsBundle(),
	...

roniemicro / Dependent script start.sh

Created January 15, 2015 06:27

	while true
	do
	if nc -w 2 server2 9999 < /dev/null > /dev/null 2>&1
	then
	# Service is currently running
	[ "$PREV" = "NOT" ] && /path/to/your/script
	PREV="RUNNING"
	else
	# Service 2 is not running on server2
	PREV="NOT"

roniemicro / MYSQL Funciton example.sql

Created January 11, 2015 12:08

Example block for creating function in MySql

	CREATE FUNCTION func01(value1 INT , monto DECIMAL (10,2))
	RETURNS DECIMAL(10,2)
	DETERMINISTIC
	BEGIN
	DECLARE var_name DECIMAL(10,2);
	SET var_name = 0;
	SELECT if(value1 = 1,monto divisa_dolar,monto divisa_euro) INTO var_name
	FROM table
	WHERE data_init = 1;
	RETURN var_name;

roniemicro / mci.sql

Last active August 29, 2015 14:11 — forked from phpfour/mci.sql


	CREATE TABLE `patient` (
	`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	`national_id` varchar(17) DEFAULT NULL,
	`uid` varchar(11) DEFAULT NULL,
	`bin_brn` varchar(19) DEFAULT NULL,
	`given_name` varchar(255) DEFAULT NULL,
	`sur_name` varchar(255) DEFAULT NULL,
	`full_name_bangla` varchar(255) DEFAULT NULL,
	`address_line` varchar(255) DEFAULT NULL,