Category Archives: PHP

Sort by array values

    static function items_by_ids($ids){
        $result = self::whereIn('id', $ids)
            ->orderBy(DB::raw('field(id, ' . implode(',', $ids) . ')'))
            ->get();
        return $result;
    }

static function items_by_ids($ids){

$result = self::whereIn('id', $ids)

->orderBy(DB::raw('field(id, ' . implode(',', $ids) . ')'))

->get();

return $result;

}

Reference:

https://stackoverflow.com/questions/8055138/mysql-sort-order-by-array-value

Laravel Cookie

Save cookie with redirect or response

use Illuminate\Support\Facades\Cookie;

// Save cookie for 120 minutes
$cookie = Cookie::make('table_id', $table_id, 120);
return redirect('/menu/' . $table->store_id)->withCookie($cookie);

use Illuminate\Support\Facades\Cookie;

// Save cookie for 120 minutes

$cookie = Cookie::make('table_id', $table_id, 120);

return redirect('/menu/' . $table->store_id)->withCookie($cookie);

Get cookie

    private function check_partner_order($req){
        $table_id = $req->cookie('table_id');
        if($table_id != false && is_numeric($table_id)){
            $table = PartnerTableM::find($table_id);
        }
    }

private function check_partner_order($req){

$table_id = $req->cookie('table_id');

if($table_id != false && is_numeric($table_id)){

$table = PartnerTableM::find($table_id);

}

Reference:

AES Decrypt

AES/CBC/PKCS5Padding encryption

    private function decrypt($str){
        //return $this->fake_response();
        $key = '927e88094c83c6b66487da5def1';
        //$key = hash('sha256', $key);
        //logg($key);
        $key =pack('H*', hash('sha256', $key));
        $iv = array_fill(0,16,chr(0));

        $iv1=implode('',$iv);

        $output = openssl_decrypt(
            base64_decode($str), 
            "AES-256-CBC", 
            $key, 
            OPENSSL_RAW_DATA, 
            $iv1
        );

        return $output;
    }

private function decrypt($str){

//return $this->fake_response();

$key = '927e88094c83c6b66487da5def1';

//$key = hash('sha256', $key);

//logg($key);

$key =pack('H*', hash('sha256', $key));

$iv = array_fill(0,16,chr(0));

$iv1=implode('',$iv);

$output = openssl_decrypt(

base64_decode($str),

"AES-256-CBC",

$key,

OPENSSL_RAW_DATA,

$iv1

);

return $output;

}

MD5 Digest the password(REST_API_KEY) using SHA-256
iv parameter is empty
Decrypt the encrypted contents using AES/CBC/PKCS5Padding

Laravel verifycsrftoken except not working

Path issue

Example URL: http://localhost:8000/wingpay/listener

    protected $except = [
        '/aba/listener',
        '/chipmong/return/*',
        '/chipmong/listener/*',
        '/wingpay/listener/*', // Not working
        '/wingpay/listener', // Works
        '/payments/*', 
    ];

protected $except = [

'/aba/listener',

'/chipmong/return/*',

'/chipmong/listener/*',

'/wingpay/listener/*', // Not working

'/wingpay/listener', // Works

'/payments/*',

];

Reference:

https://stackoverflow.com/questions/32751063/laravel-verifycsrftoken-exception-not-working

Transaction and lock tables in Laravel

Example

        try {
            DB::beginTransaction();
            DB::raw('LOCK TABLES order WRITE, tickets WRITE');

            //logg(count($buy_tickets) > count($sell_tickets));
            if(count($buy_tickets) > count($sell_tickets)){
                //N筆買單對1筆賣單
                $this->sell_to_N($sell_tickets[0], $buy_tickets, $product);
            }else{
                //N筆賣單對1筆買單(機率應該最高)
                $this->buy_from_N($buy_tickets[0], $sell_tickets, $product);
            }

            DB::commit();
            //DB::raw('UNLOCK TABLES');

            return true;
        } catch (\Exception $e) {
            DB::rollback();
            $this->err = '撮合失敗: ' . $e->getMessage();
            return false;
        }

try {

DB::beginTransaction();

DB::raw('LOCK TABLES order WRITE, tickets WRITE');

//logg(count($buy_tickets) > count($sell_tickets));

if(count($buy_tickets) > count($sell_tickets)){

//N筆買單對1筆賣單

$this->sell_to_N($sell_tickets[0], $buy_tickets, $product);

}else{

//N筆賣單對1筆買單(機率應該最高)

$this->buy_from_N($buy_tickets[0], $sell_tickets, $product);

}

DB::commit();

//DB::raw('UNLOCK TABLES');

return true;

} catch (\Exception $e) {

DB::rollback();

$this->err = '撮合失敗: ' . $e->getMessage();

return false;

}

Reference:

Laravel Storage Extension Issue

Script

// Origin name: video1234.mp4
$file = $req->file('video');

// Result: bin
logg($file->extension());

// Result mp4
logg($file->getClientOriginalExtension());

// Origin name: video1234.mp4

$file = $req->file('video');

// Result: bin

logg($file->extension());

// Result mp4

logg($file->getClientOriginalExtension());

Get correct MIME Type

$mime_type = $file->getClientMimeType();

1	$mime_type = $file->getClientMimeType();

Reference:

Read CSV File

Don’t use phpspreadsheet to read .csv file because there could be some bugs and get incorrect result.

    private function get_value($row, $index){
        $value = mb_convert_encoding($row[$index], 'UTF-8', 'Big5');
        $value = str_replace('\'', '', $value);
        $value = trim($value);
        return $value;
    }

    public function import(Request $req){
        $file = $req->file('file');
        //logg($file->getClientOriginalName());

        $file_name = 'import_shipping_orders.csv';
        $dest = storage_path('app');
        $file->move($dest, $file_name);
        $file_path = $dest . '/' . $file_name;
        //logg($dest);

        $row_index = 1;
        $debug = false;
        if (($handle = fopen($file_path, "r")) !== FALSE) {
            while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
                if($row_index == 1){
                    if($debug == true){
                        foreach ($row as $key => $value) {
                            echo $this->get_value($row, $key) . '<br/>';
                        }
                        exit();
                    }

                    $row_index++;
                    continue;
                }

                $order_no = $this->get_value($row, 2);
                if($order_no == false){
                    echo 'Row ' . $row_index . ' has no order no.<br/>';
                    continue;
                }

                $order = OrderM::where('order_no', $order_no)->first();
                if($order == false){
                    echo 'Row ' . $row_index . ' has no matched order.<br/>';
                    continue;
                }

                $order->process_status = 1;
                $order->ship_date = $this->get_value($row, 0);
                $order->est_date = $this->get_value($row, 1);
                $order->ship_no = $this->get_value($row, 3);
                $order->ship_note = $this->get_value($row, 6);
                $order->save();
                
                echo 'Row ' . $row_index . ' is updated successfully.<br/>';
                $row_index++;
            }
            fclose($handle);
        }

        echo 'Done';
    }

private function get_value($row, $index){

$value = mb_convert_encoding($row[$index], 'UTF-8', 'Big5');

$value = str_replace('\'', '', $value);

$value = trim($value);

return $value;

}

public function import(Request $req){

$file = $req->file('file');

//logg($file->getClientOriginalName());

$file_name = 'import_shipping_orders.csv';

$dest = storage_path('app');

$file->move($dest, $file_name);

$file_path = $dest . '/' . $file_name;

//logg($dest);

$row_index = 1;

$debug = false;

if (($handle = fopen($file_path, "r")) !== FALSE) {

while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {

if($row_index == 1){

if($debug == true){

foreach ($row as $key => $value) {

echo $this->get_value($row, $key) . '<br/>';

}

exit();

}

$row_index++;

continue;

}

$order_no = $this->get_value($row, 2);

if($order_no == false){

echo 'Row ' . $row_index . ' has no order no.<br/>';

continue;

}

$order = OrderM::where('order_no', $order_no)->first();

if($order == false){

echo 'Row ' . $row_index . ' has no matched order.<br/>';

continue;

}

$order->process_status = 1;

$order->ship_date = $this->get_value($row, 0);

$order->est_date = $this->get_value($row, 1);

$order->ship_no = $this->get_value($row, 3);

$order->ship_note = $this->get_value($row, 6);

$order->save();

echo 'Row ' . $row_index . ' is updated successfully.<br/>';

$row_index++;

}

fclose($handle);

}

echo 'Done';

}

Reference:

https://www.php.net/manual/zh/function.fgetcsv

PHP to handle 0 zero value

foreach($fields as $key => $field){
	$value = $this->input->post($key);

	if($value == false){
		if($value === "0"){
			$data[$key] = $value;
		}elseif($field[1] == true){
			$this->failed_response(0, $field[0] . ' 不正確');
		}else{
			$data[$key] = null;
		}
	}else{
		$data[$key] = $value;
	}
}

foreach($fields as $key => $field){

$value = $this->input->post($key);

if($value == false){

if($value === "0"){

$data[$key] = $value;

}elseif($field[1] == true){

$this->failed_response(0, $field[0] . ' 不正確');

}else{

$data[$key] = null;

}

}else{

$data[$key] = $value;

}

PHP Timezones

https://www.php.net/manual/en/timezones.php

Fine timezone name for a country

https://www.zeitverschiebung.net/en/

UserC for Laravel-Permission

Example

<?php
namespace App\Http\Controllers\Admin\Permission;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Config;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Hash;
use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use Carbon\Carbon;

use App\User;
use App\Models\RoleM;

use App\Traits\AjaxResponse;
use App\Traits\PermissionCheck;

//use App\Mail\B2bRegMail;

use Spatie\Permission\Models\Role;
use Spatie\Permission\Models\Permission;

use App\Http\Requests\UserNewReq;
use App\Http\Requests\UserUpdateReq;

class UserC extends Controller
{
    use AjaxResponse;
    use PermissionCheck;

    protected $controller = 'user';
    protected $pms_key = 'user ';
    protected $view_control = 'user';

    public function __construct(){
    }

    protected function guard(){
        return Auth::guard('web');
    }

    public function index(Request $req){
        //logg($this->guard()->user());
        $this->check_pms($this->pms_key .'view');
        $data['controller'] = $this->controller;
        $data['menu_key'] = 'user';
        $user = $this->guard()->user();
        //dd($user->getDirectPermissions());

        $data['page_title'] = '所有管理員';
        return view('admin.' . $this->view_control . '.index', $data);
    }

    public function all_data(Request $req){
        //logg(DB::connection()->getDatabaseName());
        //logg($req->input());
        $draw = $req->input('draw');
        $start = $req->input('start');
        $length = $req->input('length');
        $search = $req->input('search');
        $keyword = $search['value'];

        $sorting = User::get_sorting($req);
        //logg($sort);

        $options = [
            'start' => $start, 
            'limit' => $length, 
            'sort' => $sorting, 
            'keyword' => $keyword, 
        ];
        $total = User::items($options, User::DT_TOTAL);
        $filtered_total = User::items($options, User::DT_FILTERED);
        $data = User::items($options);

        $data = User::datatable_data($data);

        return $this->datatable_response($total, $filtered_total, $data, $draw);
    }

    public function edit_item(Request $req){
        $this->check_pms($this->pms_key .'edit');
        $data['controller'] = $this->controller;
        $data['menu_key'] = 'user';

        $id = $req->input('id');
        $row = User::find($id);
        //logg($row);
        $roles = RoleM::orderBy('name', 'asc')
            ->get();
        $arr = [];
        $user_roles = [];
        foreach ($roles as $key => $item) {
            if($row->hasRole($item->name) == true){
                $user_roles[] = $item->id;
            }

            $arr[$item->id] = $item->name;
        }
        $data['roles'] = $arr;

        $row->roles = $user_roles;
        $data['row'] = $row;
        //logg($user_roles);

        $data['page_title'] = '修改管理員';
        return view('admin.' . $this->view_control . '.edit', $data);
    }

    public function create_item(Request $req){
        $this->check_pms($this->pms_key .'edit');
        $data['controller'] = $this->controller;
        $data['menu_key'] = 'user';

        $row = new User;
        $row->roles = [];
        $data['row'] = $row;

        $roles = RoleM::orderBy('name', 'asc')
            ->get();
        $arr = [];
        foreach ($roles as $key => $item) {
            $arr[$item->id] = $item->name;
        }
        $data['roles'] = $arr;

        $data['page_title'] = '新增管理員';
        return view('admin.' . $this->view_control . '.create', $data);
    }

    public function edit_save(UserUpdateReq $req){
        $this->check_pms($this->pms_key.'edit', true);

        $data = $req->except(['_token', 'password2']);
        //logg($data);

        $id = $data['id'];
        $user = User::find($id);
        $user->name = $data['name'];
        $user->email = $data['email'];

        //如果修改帳號，要確定帳號不能重複
        if($data['email'] != $user->email){
            $other = User::where('email', $data['email'])
                ->where('id', '!=', $id)
                ->first();
            if($other != false){
                return $this->fail_response('帳號已經有人使用');
            }
        }

        //Validate tag_id
        if($data['tag_id'] != $user->tag_id){
            $result = $user->item_exists('tag_id', $data['tag_id']);
            if($result == true){
                return $this->fail_response('Tag ID已經存在');
            }
        }
        $user->tag_id = $data['tag_id'];

        $password = $data['password'];
        if(isset($data['password']) && $data['password'] != false){
            $user->password = Hash::make($data['password']);
        }

        $user->save();

        $roles = $data['roles'];
        $user->syncRoles($roles);

        return $this->success_response(true);
    }

    public function create_save(UserNewReq $req){
        $this->check_pms($this->pms_key.'edit', true);

        $data = $req->except(['_token', 'password2']);
        //logg($data);

        $user = new User;
        $user->name = $data['name'];
        $user->email = $data['email'];
        $user->tag_id = $data['tag_id'];
        $user->password = Hash::make($data['password']);
        $user->save();

        $roles = $data['roles'];
        $user->syncRoles($roles);

        return $this->success_response(true);
    }

    public function delete_item(Request $req){
        $this->check_pms($this->pms_key.'delete', true);

        $id = $req->input('id');
        if($id == false){
            return $this->fail_response('Invalid ID');
        }

        $admin = User::find($id);
        $admin->syncRoles();
        $admin->delete();

        return $this->success_response(true);
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

<?php

namespace App\Http\Controllers\Admin\Permission;

use Illuminate\Support\Facades\DB;

use Illuminate\Support\Facades\Config;

use Illuminate\Support\Facades\Auth;

use Illuminate\Support\Facades\Hash;

use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use Carbon\Carbon;

use App\User;

use App\Models\RoleM;

use App\Traits\AjaxResponse;

use App\Traits\PermissionCheck;

//use App\Mail\B2bRegMail;

use Spatie\Permission\Models\Role;

use Spatie\Permission\Models\Permission;

use App\Http\Requests\UserNewReq;

use App\Http\Requests\UserUpdateReq;

class UserC extends Controller

{

use AjaxResponse;

use PermissionCheck;

protected $controller = 'user';

protected $pms_key = 'user ';

protected $view_control = 'user';

public function __construct(){

}

protected function guard(){

return Auth::guard('web');

}

public function index(Request $req){

//logg($this->guard()->user());

$this->check_pms($this->pms_key .'view');

$data['controller'] = $this->controller;

$data['menu_key'] = 'user';

$user = $this->guard()->user();

//dd($user->getDirectPermissions());

$data['page_title'] = '所有管理員';

return view('admin.' . $this->view_control . '.index', $data);

}

public function all_data(Request $req){

//logg(DB::connection()->getDatabaseName());

//logg($req->input());

$draw = $req->input('draw');

$start = $req->input('start');

$length = $req->input('length');

$search = $req->input('search');

$keyword = $search['value'];

$sorting = User::get_sorting($req);

//logg($sort);

$options = [

'start' => $start,

'limit' => $length,

'sort' => $sorting,

'keyword' => $keyword,

];

$total = User::items($options, User::DT_TOTAL);

$filtered_total = User::items($options, User::DT_FILTERED);

$data = User::items($options);

$data = User::datatable_data($data);

return $this->datatable_response($total, $filtered_total, $data, $draw);

}

public function edit_item(Request $req){

$this->check_pms($this->pms_key .'edit');

$data['controller'] = $this->controller;

$data['menu_key'] = 'user';

$id = $req->input('id');

$row = User::find($id);

//logg($row);

$roles = RoleM::orderBy('name', 'asc')

->get();

$arr = [];

$user_roles = [];

foreach ($roles as $key => $item) {

if($row->hasRole($item->name) == true){

$user_roles[] = $item->id;

}

$arr[$item->id] = $item->name;

}

$data['roles'] = $arr;

$row->roles = $user_roles;

$data['row'] = $row;

//logg($user_roles);

$data['page_title'] = '修改管理員';

return view('admin.' . $this->view_control . '.edit', $data);

}

public function create_item(Request $req){

$this->check_pms($this->pms_key .'edit');

$data['controller'] = $this->controller;

$data['menu_key'] = 'user';

$row = new User;

$row->roles = [];

$data['row'] = $row;

$roles = RoleM::orderBy('name', 'asc')

->get();

$arr = [];

foreach ($roles as $key => $item) {

$arr[$item->id] = $item->name;

}

$data['roles'] = $arr;

$data['page_title'] = '新增管理員';

return view('admin.' . $this->view_control . '.create', $data);

}

public function edit_save(UserUpdateReq $req){

$this->check_pms($this->pms_key.'edit', true);

$data = $req->except(['_token', 'password2']);

//logg($data);

$id = $data['id'];

$user = User::find($id);

$user->name = $data['name'];

$user->email = $data['email'];

//如果修改帳號，要確定帳號不能重複

if($data['email'] != $user->email){

$other = User::where('email', $data['email'])

->where('id', '!=', $id)

->first();

if($other != false){

return $this->fail_response('帳號已經有人使用');

}

//Validate tag_id

if($data['tag_id'] != $user->tag_id){

$result = $user->item_exists('tag_id', $data['tag_id']);

if($result == true){

return $this->fail_response('Tag ID已經存在');

}

$user->tag_id = $data['tag_id'];

$password = $data['password'];

if(isset($data['password']) && $data['password'] != false){

$user->password = Hash::make($data['password']);

}

$user->save();

$roles = $data['roles'];

$user->syncRoles($roles);

return $this->success_response(true);

}

public function create_save(UserNewReq $req){

$this->check_pms($this->pms_key.'edit', true);

$data = $req->except(['_token', 'password2']);

//logg($data);

$user = new User;

$user->name = $data['name'];

$user->email = $data['email'];

$user->tag_id = $data['tag_id'];

$user->password = Hash::make($data['password']);

$user->save();

$roles = $data['roles'];

$user->syncRoles($roles);

return $this->success_response(true);

}

public function delete_item(Request $req){

$this->check_pms($this->pms_key.'delete', true);

$id = $req->input('id');

if($id == false){

return $this->fail_response('Invalid ID');

}

$admin = User::find($id);

$admin->syncRoles();

$admin->delete();

return $this->success_response(true);

}

Rex's Personal Site

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

Category Archives: PHP

Sort by array values

Laravel Cookie

AES Decrypt

Laravel verifycsrftoken except not working

Transaction and lock tables in Laravel

Laravel Storage Extension Issue

Read CSV File

PHP to handle 0 zero value

PHP Timezones

UserC for Laravel-Permission

September 2020
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