Category Archives: Laravel

Client sent AUTH, but no password is set (Redis issue)

Try to change redis setting in database.php

Laravel 5.0升级Predis之后使用密码报错

Laravel Queue and Job

Official Doc: https://laravel.com/docs/5.3/queues#introduction

Command to build job class:

php artisan make:job SendReminderEmail

1	php artisan make:job SendReminderEmail

Command to dispatch job:

dispatch(new FakePriceData(10));

1	dispatch(new FakePriceData(10));

Command to execute start queue worker:

php artisan queue:work database --queue=daemon --tries=3

1	php artisan queue:work database --queue=daemon --tries=3

Note:

Every time related scripts are changed, the queue worker must be restarted or the job will always read the script in some cache.

Advanced where clause – pass variable into annonymous function

if(val($options, 'extra_options') != false){
	$ex_list = val($options, 'extra_options');

	$result = $result->where(function($query) use ($ex_list){
		if(in_array(1, $ex_list) == true){
			$query->orWhere('remain_quota', '>', 0);
		}

		if(in_array(2, $ex_list) == true){
			$query->orWhere('remain_quota', '<=', 0);
		}

		if(in_array(3, $ex_list) == true){
			$query->orWhere('status', 3);
		}

		if(in_array(4, $ex_list) == true){
			$query->orWhere('status', 2);
		}
	});
}

if(val($options, 'extra_options') != false){

$ex_list = val($options, 'extra_options');

$result = $result->where(function($query) use ($ex_list){

if(in_array(1, $ex_list) == true){

$query->orWhere('remain_quota', '>', 0);

}

if(in_array(2, $ex_list) == true){

$query->orWhere('remain_quota', '<=', 0);

}

if(in_array(3, $ex_list) == true){

$query->orWhere('status', 3);

}

if(in_array(4, $ex_list) == true){

$query->orWhere('status', 2);

}

});

}

DB Migration – To Create a new table

Command:

php artisan make:migration create_user_table --create=user

1	php artisan make:migration create_user_table --create=user

Migration Class:

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateChildAccountTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('member_child', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('parent_id')->comment('主帳號ID');
            $table->tinyInteger('type');
            $table->string('username', 30);
            $table->string('child', 20);
            $table->string('password', 20);
            $table->string('name', 50);
            $table->longText('description');
            $table->tinyInteger('permission')->comment('1:view, 2:inherit');
            $table->tinyInteger('enabled')->comment('狀態 ( 1: 啟用 2:停用)');
            $table->integer('login_count')->nullable();
            $table->dateTime('login_time')->nullable();
            $table->string('ip', 30)->nullable();
            $table->string('location', 100)->nullable();
            $table->decimal('fee', 10, 2)->nullable()->comment('手續費');
            $table->dateTime('created_time');
            $table->dateTime('updated_time')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('member_child');
    }
}

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateChildAccountTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::create('member_child', function (Blueprint $table) {

$table->increments('id');

$table->integer('parent_id')->comment('主帳號ID');

$table->tinyInteger('type');

$table->string('username', 30);

$table->string('child', 20);

$table->string('password', 20);

$table->string('name', 50);

$table->longText('description');

$table->tinyInteger('permission')->comment('1:view, 2:inherit');

$table->tinyInteger('enabled')->comment('狀態 ( 1: 啟用 2:停用)');

$table->integer('login_count')->nullable();

$table->dateTime('login_time')->nullable();

$table->string('ip', 30)->nullable();

$table->string('location', 100)->nullable();

$table->decimal('fee', 10, 2)->nullable()->comment('手續費');

$table->dateTime('created_time');

$table->dateTime('updated_time')->nullable();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('member_child');

}

Disable Csrf Token

Modify this middleware: VerifyCsrfToken.php

class VerifyCsrfToken extends BaseVerifier
{
    /**
     * The URIs that should be excluded from CSRF verification.
     *
     * @var array
     */
    protected $except = [
        //
    	'*'
    ];
}

class VerifyCsrfToken extends BaseVerifier

{

/**

* The URIs that should be excluded from CSRF verification.

* @var array

protected $except = [

'*'

];

}

Reference:

https://stackoverflow.com/questions/31223189/in-laravel5-how-to-disable-verifycsrftoken-middleware-for-specific-route

Show last query

	static function actions_logs($type, $options=null){
		DB::enableQueryLog();

		$result = DB::table('member_action_log as a')
			->join('member as b', 'b.id', '=', 'a.editor')
			->leftJoin('member as c', 'c.id', '=', 'a.member')
			->join('options as d', 'd.id', '=', 'a.action_id')
			->select('a.*', 'b.username as editor_name', 'c.username as member_name', 'd.name as action_name')
			->where('b.type', '=', $type);

		if(val($options, 'keyword') != false){
			$keyword = val($options, 'keyword');
			$result = $result->where(function ($query) use ($keyword) {
                $query->orWhere('b.username', 'like', "%" . $keyword . "%")
                      ->orWhere('b.name', 'like', "%" . $keyword . "%");
            });
		}

		$result = $result->orderBy('a.created_time', 'desc')
			->get();

		$queries = DB::getQueryLog();
		logg(end($queries));

		return $result;
	}

static function actions_logs($type, $options=null){

DB::enableQueryLog();

$result = DB::table('member_action_log as a')

->join('member as b', 'b.id', '=', 'a.editor')

->leftJoin('member as c', 'c.id', '=', 'a.member')

->join('options as d', 'd.id', '=', 'a.action_id')

->select('a.*', 'b.username as editor_name', 'c.username as member_name', 'd.name as action_name')

->where('b.type', '=', $type);

if(val($options, 'keyword') != false){

$keyword = val($options, 'keyword');

$result = $result->where(function ($query) use ($keyword) {

$query->orWhere('b.username', 'like', "%" . $keyword . "%")

->orWhere('b.name', 'like', "%" . $keyword . "%");

});

}

$result = $result->orderBy('a.created_time', 'desc')

->get();

$queries = DB::getQueryLog();

logg(end($queries));

return $result;

}

Reference:

Define BASE_URL globally

/app/Providers/AppServiceProvider.php

public function boot()
    {
        //
        $base_url = url('/');
        define('BASE_URL', $base_url . '/');
    }

public function boot()

{

$base_url = url('/');

define('BASE_URL', $base_url . '/');

}

Group Example

Route::group(['prefix' => '/admin'], function(){
	Route::get('/', 'AdminC@index');
});

Route::group(['prefix' => '/admin'], function(){

Route::get('/', 'AdminC@index');

});

Laravel in IIS (url rewrite example)

Notes:

Destination in IIS should point to public folder
Avoid creating folders in public with the same name as prefix in routes.
e.g. public/admin and URI “/admin” will cause error.

<configuration>
  <system.webServer>
    <rewrite>
      <rules>
        <rule name="Imported Rule 1" stopProcessing="true">
          <match url="^(.*)/$" ignoreCase="false" />
          <conditions>
            <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" negate="true" />
          </conditions>
          <action type="Redirect" redirectType="Permanent" url="/{R:1}" />
        </rule>
        <rule name="Imported Rule 2" stopProcessing="true">
          <match url="^" ignoreCase="false" />
          <conditions>
            <add input="{REQUEST_FILENAME}" matchType="IsDirectory" ignoreCase="false" negate="true" />
            <add input="{REQUEST_FILENAME}" matchType="IsFile" ignoreCase="false" negate="true" />
          </conditions>
          <action type="Rewrite" url="index.php" />
        </rule>
      </rules>
    </rewrite>
  </system.webServer>
</configuration>

<system.webServer>

<rules>

</conditions>

</rule>

</conditions>

</rule>

</rules>

</rewrite>

</system.webServer>

</configuration>

Laravel helpers (composer)

Add “files” in composer.json:

{
    "name": "laravel/laravel",
    "description": "The Laravel Framework.",
    "keywords": ["framework", "laravel"],
    "license": "MIT",
    "type": "project",
    "require": {
        "php": ">=5.6.4",
        "laravel/framework": "5.3.*"
    },
    "require-dev": {
        "fzaninotto/faker": "~1.4",
        "mockery/mockery": "0.9.*",
        "phpunit/phpunit": "~5.0",
        "symfony/css-selector": "3.1.*",
        "symfony/dom-crawler": "3.1.*"
    },
    "autoload": {
        "classmap": [
            "database"
        ],
        "psr-4": {
            "App\\": "app/"
        }, 
        "files":[
            "app/Support/Helpers/helper.php"
        ]
    },
    "autoload-dev": {
        "classmap": [
            "tests/TestCase.php"
        ]
    },
    "scripts": {
        "post-root-package-install": [
            "php -r \"file_exists('.env') || copy('.env.example', '.env');\""
        ],
        "post-create-project-cmd": [
            "php artisan key:generate"
        ],
        "post-install-cmd": [
            "Illuminate\\Foundation\\ComposerScripts::postInstall",
            "php artisan optimize"
        ],
        "post-update-cmd": [
            "Illuminate\\Foundation\\ComposerScripts::postUpdate",
            "php artisan optimize"
        ]
    },
    "config": {
        "preferred-install": "dist",
        "sort-packages": true
    }
}

{

"name": "laravel/laravel",

"description": "The Laravel Framework.",

"keywords": ["framework", "laravel"],

"license": "MIT",

"type": "project",

"require": {

"php": ">=5.6.4",

"laravel/framework": "5.3.*"

"require-dev": {

"fzaninotto/faker": "~1.4",

"mockery/mockery": "0.9.*",

"phpunit/phpunit": "~5.0",

"symfony/css-selector": "3.1.*",

"symfony/dom-crawler": "3.1.*"

"autoload": {

"classmap": [

"database"

"psr-4": {

"App\\": "app/"

"files":[

"app/Support/Helpers/helper.php"

]

"autoload-dev": {

"classmap": [

"tests/TestCase.php"

]

"scripts": {

"post-root-package-install": [

"php -r \"file_exists('.env') || copy('.env.example', '.env');\""

"post-create-project-cmd": [

"php artisan key:generate"

"post-install-cmd": [

"Illuminate\\Foundation\\ComposerScripts::postInstall",

"php artisan optimize"

"post-update-cmd": [

"Illuminate\\Foundation\\ComposerScripts::postUpdate",

"php artisan optimize"

]

"config": {

"preferred-install": "dist",

"sort-packages": true

}

Update autoload.php

$ composer dump-autoload

1	$ composer dump-autoload

Reference:

https://kejyuntw.gitbooks.io/laravel-5-learning-notes/services/helpers/services-custom-helpers-README.html

M	T	W	T	F	S	S
« Aug
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Category Archives: Laravel

Client sent AUTH, but no password is set (Redis issue)

Laravel Queue and Job

Advanced where clause – pass variable into annonymous function

DB Migration – To Create a new table

Disable Csrf Token

Show last query

Define BASE_URL globally

Group Example

Laravel in IIS (url rewrite example)

Laravel helpers (composer)