Skip to content

Instantly share code, notes, and snippets.

View roniemicro's full-sized avatar

Roni Saha roniemicro

  • eMicroGraph Business Solutions & Right Brain Solution
  • Bangladesh
View GitHub Profile
@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
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
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
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,
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
roniemicro / index.pgp
Created August 24, 2015 05:06
WWW Project Browser
<?php
// Page créé par Shepard [Fabian Pijcke] <Shepard8@laposte.net>
// Arno Esterhuizen <arno.esterhuizen@gmail.com>
// et Romain Bourdon <rromain@romainbourdon.com>
// et Hervé Leclerc <herve.leclerc@alterway.fr>
//
// Mise a jour par Herve Leclerc herve.leclerc@alterway.fr
// Ici par Mark James <http://www.famfamfam.com/lab/icons/silk/>
@roniemicro
roniemicro / Appkernel.php
Last active August 29, 2015 14:20
Doctrine Uploadable extention uses
...
new Stof\DoctrineExtensionsBundle\StofDoctrineExtensionsBundle(),
...
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
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
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,