Odenktools – Page 3 – Happy on research, love codings, opensource enthusiast.

Installing Laravel Homestead On Windows Machine

February 27, 2017February 27, 2017 odenktools Leave a comment

Prerequisites

Windows 7 / 8
Internet
Virtual Box 5.1.14r112924. Download here
Vagrant 1.9.1. Download here
Laravel Homestead Box 1.1.0. Download here (name it virtualbox.box)

After downloading Laravel Homestead Box 1.1.0, save virtualbox.box file to C:\virtualbox.box

Install Virtualbox

Install Vagrant too then reboot your machine

After your machine already boot, Run Windows Command Prompt and add vagrantbox :

cd C:
vagrant box add laravel/homestead virtualbox.box

1 2	cd C: vagrant box add laravel/homestead virtualbox.box

If vagrantbox success installed, open Windows Explorer then go to :

%userprofile%\.vagrant.d\boxes\laravel-VAGRANTSLASH-homestead

rename folder 0 (zero) to 1.1.0

Back to Windows Command Prompt, create vagrant homestead folder

git clone https://github.com/laravel/homestead.git D:\homestead-laravel

1	git clone https://github.com/laravel/homestead.git D:\homestead-laravel

Open Windows Explorer then go to D:\homestead-laravel

Run init.bat

Clone your Laravel Project, example from official laravel git

git clone https://github.com/laravel/laravel.git C:\htdocs\laravelhomestead\

1	git clone https://github.com/laravel/laravel.git C:\htdocs\laravelhomestead\

cd C:\htdocs\laravelhomestead\

1	cd C:\htdocs\laravelhomestead\

composer require laravel/homestead --dev

1	composer require laravel/homestead --dev

After finish installing, run this command

vendor\\bin\\homestead make

1	vendor\\bin\\homestead make

Goback to Windows Explorer navigate D:\homestead-laravel

Edit Homestead.yaml file and find this code

folders:
	- map: C:/Code

1 2	folders: - map: C:/Code

Change to

folders:
    - map: C:/htdocs/laravelhomestead
      to: "/home/vagrant/laravelhomestead"

folders:

- map: C:/htdocs/laravelhomestead

to: "/home/vagrant/laravelhomestead"

Time to running laravel homestead

Go back to Windows Command Prompt

cd C:
cd C:\htdocs\laravelhomestead\
vagrant up

cd C:

cd C:\htdocs\laravelhomestead\

vagrant up

Shutdown Vagrant

vagrant halt

1	vagrant halt

Best Laravel 5.1.x Auth Packages (For Me…)

February 8, 2016February 8, 2016 odenktools 2 Comments

Laravel 5 auth, there are so many authentification packages on this framework make me feel sick, hahhahaha! on trial and error process, and also their package codes are clean for me. This is my best choise

Sentry [DEPRECATED]

Source : https://github.com/cartalyst/sentry/tree/feature/laravel-5

How to install?

Add this code on your composer.json

"cartalyst/sentry": "dev-feature/laravel-5"

1	"cartalyst/sentry": "dev-feature/laravel-5"

Then run command

php composer.phar update

1	php composer.phar update

Entrust

Source : https://github.com/Zizaco/entrust

How to install?

Add this code on your composer.json

"zizaco/entrust": "dev-laravel-5"

1	"zizaco/entrust": "dev-laravel-5"

Then run command

php composer.phar update

1	php composer.phar update

Defender

Source : https://github.com/artesaos/defender

How to install?

Add this code on your composer.json

"artesaos/defender": "~0.4"

1	"artesaos/defender": "~0.4"

Then run command

php composer.phar update

1	php composer.phar update

Verify

Source : https://github.com/Toddish/Verify

How to install?

Add this code on your composer.json

"toddish/verify": "~5"

1	"toddish/verify": "~5"

Then run command

php composer.phar update

1	php composer.phar update

BeatSwitch

Source : https://github.com/BeatSwitch/lock-laravel

How to install?

Add this code on your composer.json

"beatswitch/lock-laravel": "^0.4.1"

1	"beatswitch/lock-laravel": "^0.4.1"

Then run command

php composer.phar update

1	php composer.phar update

Installing NodeJS On Ubuntu 14.x

February 4, 2016February 4, 2016 odenktools Leave a comment

How to install NodeJS On Your VPS (Ubuntu)? I have 3 way for installing this. Okay lets checkout this way

From Official

wget -qO- https://deb.nodesource.com/setup_4.x | sudo bash -
or
wget -qO- https://deb.nodesource.com/setup_5.x | sudo bash -
apt-get install -y nodejs

wget -qO- https://deb.nodesource.com/setup_4.x | sudo bash -

wget -qO- https://deb.nodesource.com/setup_5.x | sudo bash -

apt-get install -y nodejs

Using ppa:chris-lea

sudo apt-get install -y python-software-properties python g++ make
sudo add-apt-repository ppa:chris-lea/node.js
sudo apt-get update
sudo apt-get install nodejs npm

sudo apt-get install -y python-software-properties python g++ make

sudo add-apt-repository ppa:chris-lea/node.js

sudo apt-get update

sudo apt-get install nodejs npm

From Source Code

wget https://nodejs.org/dist/v4.2.6/node-v4.2.6.tar.gz
sudo tar -xzf node-v4.2.6.tar.gz
cd node-v4.2.6/
sudo ./configure
sudo make
sudo make install

wget https://nodejs.org/dist/v4.2.6/node-v4.2.6.tar.gz

sudo tar -xzf node-v4.2.6.tar.gz

cd node-v4.2.6/

sudo ./configure

sudo make

sudo make install

From Binary

wget https://nodejs.org/dist/v4.3.2/node-v4.3.2-linux-x64.tar.xz
apt-get install xz-utils
tar -C /usr/local --strip-components 1 -xJf node-v4.3.2-linux-x64.tar.xz
ls -l /usr/local/bin/node
ls -l /usr/local/bin/npm

wget https://nodejs.org/dist/v4.3.2/node-v4.3.2-linux-x64.tar.xz

apt-get install xz-utils

tar -C /usr/local --strip-components 1 -xJf node-v4.3.2-linux-x64.tar.xz

ls -l /usr/local/bin/node

ls -l /usr/local/bin/npm

Installing CURL On Ubuntu 14.0x

January 19, 2016January 19, 2016 odenktools Leave a comment

Downloading and Installing Composer

curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/local/bin --filename=composer

1	curl -sS https://getcomposer.org/installer \| sudo php -- --install-dir=/usr/local/bin --filename=composer

Let’s testing

composer --version

1	composer --version

cd /var/www/odenktools.com

composer require mashape/unirest-php

cd /var/www/odenktools.com

composer require mashape/unirest-php

Check your project’s directory now, it will contain two new files and one directory

composer.json
composer.lock
vendor directory

Dynamic Crosstab With Store Procedure

October 29, 2015October 29, 2015 odenktools 3 Comments

Let’s assume that we have table with data like this bellow :

and we want to view data like this

for that we can write query like this

SELECT 
   SUM(IF(category='1991', value, 0)) as '1991',
   SUM(IF(category='1992', value, 0)) as '1992',
   SUM(IF(category='1993', value, 0)) as '1993' 
FROM dynamic_crosstab;

SELECT

SUM(IF(category='1991', value, 0)) as '1991',

SUM(IF(category='1992', value, 0)) as '1992',

SUM(IF(category='1993', value, 0)) as '1993'

FROM dynamic_crosstab;

But, what we can do if the data going bigger and category added, e.g. 1995, 1996. Yes of course we can add

SUM(IF(category='1993', value, 0)) as '1995'

1	SUM(IF(category='1993', value, 0)) as '1995'

once again but, how if we have many category value which are similary. i think this is a waste, so ot will usefull if we write crosstab dynamicly. let’s check it out

CREATE DEFINER = 'root'@'localhost'
PROCEDURE usefull.dynamic_crosstab()
BEGIN
    SELECT GROUP_CONCAT( DISTINCT CONCAT("SUM( IF( category ='", category,"', value ,0 )) as '", category, "'")) FROM dynamic_crosstab into @crosstab_column;
    
    set @query  = concat("SELECT ", @crosstab_column, " FROM dynamic_crosstab");
     prepare  stmt FROM @query;
     execute  stmt;

END

CREATE DEFINER = 'root'@'localhost'

PROCEDURE usefull.dynamic_crosstab()

BEGIN

SELECT GROUP_CONCAT( DISTINCT CONCAT("SUM( IF( category ='", category,"', value ,0 )) as '", category, "'")) FROM dynamic_crosstab into @crosstab_column;

set @query = concat("SELECT ", @crosstab_column, " FROM dynamic_crosstab");

prepare stmt FROM @query;

execute stmt;

END

the query above will transform all category value into column, wich distinct will prevent the redundance. just keep in mind and hope this helpfull.