Category Archives: PHP

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);

}

RoleC 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\Http\Request;

use App\Http\Controllers\Controller;
use App\Http\Controllers\Admin\ParentC;

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;


class RoleC extends Controller
{
    use AjaxResponse;
    use PermissionCheck;

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

    public function __construct(){
        //parent::__construct();
    }

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

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

        $data['page_title'] = '角色';
        return view('admin.' . $this->view_control . '.index', $data);
    }

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

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

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

        $data = RoleM::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'] = 'role';
        $user = $this->guard()->user();

        $id = $req->input('id');
        $role = Role::find($id);
        $data['row'] = $role;

        $pms = Config::get('admin.role_permissions');
        $data['pms'] = $pms;

        $role_pms = $role->getPermissionNames();
        $data['role_pms'] = $role_pms->toArray();
        //logg($role_pms);

        $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'] = 'role';
        $user = $this->guard()->user();

        $data['row'] = new Role;
        $data['role_pms'] = [];

        $pms = Config::get('admin.role_permissions');
        $data['pms'] = $pms;

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

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

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

        if(is_numeric($name) == true){
            return $this->fail_response('角色名稱不可為數字');
        }

        $role = Role::find($id);
        $role->name = $name;
        $role->save();

        //刪除role的所有permission
        $role->syncPermissions();

        if($pms != false){
            foreach ($pms as $pname => $values) {
                foreach ($values as $key => $value) {
                    $permission = Permission::firstOrCreate(['name' => $pname . ' ' . $value]);
                    $permission->assignRole($role);
                }
            }
        }

        return $this->success_response(true);
    }

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

        $name = $req->input('name');
        if($name == false){
            return $this->fail_response('請輸入名稱');
        }elseif(is_numeric($name) == true){
            return $this->fail_response('角色名稱不可為數字');
        }

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

        $role = new Role();
        $role->name = $name;
        $role->save();

        if($pms != false){
            foreach ($pms as $pname => $values) {
                foreach ($values as $key => $value) {
                    $permission = Permission::firstOrCreate(['name' => $pname . ' ' . $value]);
                    $permission->assignRole($role);
                }
            }
        }

        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');
        }

        $role = Role::find($id);

        $users = User::role($role->name)->get();
        foreach ($users as $key => $user) {
            
        }

        //刪除role的所有permission
        $role->syncPermissions();

        $role->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

<?php

namespace App\Http\Controllers\Admin\Permission;

use Illuminate\Support\Facades\DB;

use Illuminate\Support\Facades\Config;

use Illuminate\Support\Facades\Auth;

use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use App\Http\Controllers\Admin\ParentC;

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;

class RoleC extends Controller

{

use AjaxResponse;

use PermissionCheck;

protected $controller = 'role';

protected $pms_key = 'role ';

protected $view_control = 'role';

public function __construct(){

//parent::__construct();

}

protected function guard(){

return Auth::guard('web');

}

public function index(Request $req){

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

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

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

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

//logg($data);

$data['page_title'] = '角色';

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

}

public function all_data(Request $req){

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

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

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

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

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

$keyword = $search['value'];

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

//logg($sort);

$options = [

'start' => $start,

'limit' => $length,

'sort' => $sorting,

'keyword' => $keyword,

];

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

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

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

$data = RoleM::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'] = 'role';

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

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

$role = Role::find($id);

$data['row'] = $role;

$pms = Config::get('admin.role_permissions');

$data['pms'] = $pms;

$role_pms = $role->getPermissionNames();

$data['role_pms'] = $role_pms->toArray();

//logg($role_pms);

$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'] = 'role';

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

$data['row'] = new Role;

$data['role_pms'] = [];

$pms = Config::get('admin.role_permissions');

$data['pms'] = $pms;

$data['page_title'] = '新增角色';

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

}

public function edit_save(Request $req){

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

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

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

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

if(is_numeric($name) == true){

return $this->fail_response('角色名稱不可為數字');

}

$role = Role::find($id);

$role->name = $name;

$role->save();

//刪除role的所有permission

$role->syncPermissions();

if($pms != false){

foreach ($pms as $pname => $values) {

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

$permission = Permission::firstOrCreate(['name' => $pname . ' ' . $value]);

$permission->assignRole($role);

}

return $this->success_response(true);

}

public function create_save(Request $req){

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

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

if($name == false){

return $this->fail_response('請輸入名稱');

}elseif(is_numeric($name) == true){

return $this->fail_response('角色名稱不可為數字');

}

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

$role = new Role();

$role->name = $name;

$role->save();

if($pms != false){

foreach ($pms as $pname => $values) {

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

$permission = Permission::firstOrCreate(['name' => $pname . ' ' . $value]);

$permission->assignRole($role);

}

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');

}

$role = Role::find($id);

$users = User::role($role->name)->get();

foreach ($users as $key => $user) {

}

//刪除role的所有permission

$role->syncPermissions();

$role->delete();

return $this->success_response(true);

}

There is no role with id `123` Issue

With laravel-permission package, if you wanna delete a role and the role name is “123”, it seems the package will find it by ID automatically because it’s numerical.

Solution:

Change name from “123” to “v123”, etc.

Share data to all views

Middleware

namespace App\Http\Middleware;
use Illuminate\Support\Facades\Auth;
use Closure;

class ShareInfoToView
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        //logg(Auth::guard('web')->check());
        if (Auth::guard('web')->check()) {
            \View::share('user', Auth::guard('web')->user());
        }

        return $next($request);
    }
}

namespace App\Http\Middleware;

use Illuminate\Support\Facades\Auth;

use Closure;

class ShareInfoToView

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure $next

* @return mixed

public function handle($request, Closure $next)

{

//logg(Auth::guard('web')->check());

if (Auth::guard('web')->check()) {

\View::share('user', Auth::guard('web')->user());

}

return $next($request);

}

Kernel

    protected $middlewareGroups = [
        'web' => [
            \App\Http\Middleware\EncryptCookies::class,
            \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
            \Illuminate\Session\Middleware\StartSession::class,
            // \Illuminate\Session\Middleware\AuthenticateSession::class,
            \Illuminate\View\Middleware\ShareErrorsFromSession::class,
            \App\Http\Middleware\VerifyCsrfToken::class,
            \Illuminate\Routing\Middleware\SubstituteBindings::class,
            \App\Http\Middleware\ShareInfoToView::class,
        ],

        'api' => [
            'throttle:60,1',
            \Illuminate\Routing\Middleware\SubstituteBindings::class,
        ],
    ];

protected $middlewareGroups = [

'web' => [

\App\Http\Middleware\EncryptCookies::class,

\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,

\Illuminate\Session\Middleware\StartSession::class,

// \Illuminate\Session\Middleware\AuthenticateSession::class,

\Illuminate\View\Middleware\ShareErrorsFromSession::class,

\App\Http\Middleware\VerifyCsrfToken::class,

\Illuminate\Routing\Middleware\SubstituteBindings::class,

\App\Http\Middleware\ShareInfoToView::class,

'api' => [

'throttle:60,1',

\Illuminate\Routing\Middleware\SubstituteBindings::class,

];

Jquery Repeater

Github:

https://github.com/DubFriend/jquery.repeater

Javascript

<script src="/plugins/jquery.repeater.min.js"></script>
<script>
var valid_products = '{!! $row->valid_products !!}';

$(document).ready(function(){
    $('#bt_submit').on('click', function(e){
        $('#iform').submit();
    });

    $('#iform').ajaxForm({
        dataType: 'json',
        beforeSubmit: function(arr, $form, options) {
            //console.log(arr);
            var new_arr = [];
            for(var i = 0; i < arr.length; i++){
              var name = arr[i];
              var pattern = /valid_products.+/;
              if(pattern.test(name) == false){
                new_arr.push(arr[i]);
              }
            }

            var values = $('.repeater').repeaterVal();
            var item = {
              name: 'valid_products', 
              value: values
            }
            new_arr.push(item);
            //console.log(values);
            //return false;

            return new_arr;
        },
        success: function(data, statusText, xhr, $form){
            //console.log(data);
            if(typeof data.status == 'undefined'){
                alert(data);
            }else if(data.status == 'fail'){
                alert(data.message);
            }else{
                //console.log(data);
                window.location.href = base_url + 'store/{{$controller}}';
            }
        },
        error: function(data){
            console.log(data);
            var res = data.responseJSON;
            show_response_error(res.errors);
        }
    });

    $('[name="discount_type"]').trigger('change');

    var $repeater = $('.repeater').repeater({
      isFirstItemUndeletable: true,
      defaultValues: {
          'discount': 100
      },
    });

    valid_products = $.parseJSON(valid_products);
    console.log(valid_products);
    $repeater.setList(valid_products);
});
</script>

var valid_products = '{!! $row->valid_products !!}';

$(document).ready(function(){

$('#bt_submit').on('click', function(e){

$('#iform').submit();

});

$('#iform').ajaxForm({

dataType: 'json',

beforeSubmit: function(arr, $form, options) {

//console.log(arr);

var new_arr = [];

for(var i = 0; i < arr.length; i++){

var name = arr[i];

var pattern = /valid_products.+/;

if(pattern.test(name) == false){

new_arr.push(arr[i]);

}

var values = $('.repeater').repeaterVal();

var item = {

name: 'valid_products',

value: values

}

new_arr.push(item);

//console.log(values);

//return false;

return new_arr;

success: function(data, statusText, xhr, $form){

//console.log(data);

if(typeof data.status == 'undefined'){

alert(data);

}else if(data.status == 'fail'){

alert(data.message);

}else{

//console.log(data);

window.location.href = base_url + 'store/{{$controller}}';

}

error: function(data){

console.log(data);

var res = data.responseJSON;

show_response_error(res.errors);

}

});

$('[name="discount_type"]').trigger('change');

var $repeater = $('.repeater').repeater({

isFirstItemUndeletable: true,

defaultValues: {

'discount': 100

});

valid_products = $.parseJSON(valid_products);

console.log(valid_products);

$repeater.setList(valid_products);

});

</script>

HTML

<div class="form-group {{$field[0]}} repeater">
    <label for="{{$field[0]}}" class="col-md-3 control-label">
        {{$field[1]}}
        @if(isset($field[2]) && $field[2] == true)
        *
        @endif
    </label>
    <div class="col-md-9 filled">
        <input data-repeater-create type="button" value="Add"/>
        <table class="table table-hover dynamic_values">
            <thead>
                <tr>
                    <th>Item</th>
                    <th>Discount</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody data-repeater-list="{{$field[0]}}">
                <tr data-repeater-item>
                    <td>
                        <select class="form-control product-list" name="item_code">
                            <option value="">-- Select --</option>
                            @foreach($options as $key => $item)
                                @php
                                    $opt_value = $item->item_code;
                                    $display = $item->name . ' (' . $item->subtitle . ') : $' . $item->price;
                                @endphp
                                <option value="{{$opt_value}}">{{$display}}</option>
                            @endforeach
                        </select>
                    </td>
                    <td>
                        <input type="text" class="form-control" name="discount" value="100">
                    </td>
                    <td>
                        <input data-repeater-delete type="button" value="Delete"/>
                    </td>
                </tr>
            </tbody>
        </table>
    </div>
</div>

@if(isset($field[2]) && $field[2] == true)

@endif

</label>

<thead>

<tr>

<th>Discount</th>

<th>Action</th>

</tr>

</thead>

<td>

<option value="">-- Select --</option>

@foreach($options as $key => $item)

@php

$opt_value = $item->item_code;

$display = $item->name . ' (' . $item->subtitle . ') : $' . $item->price;

@endphp

<option value="{{$opt_value}}">{{$display}}</option>

@endforeach

</select>

</td>

<td>

</td>

<td>

</td>

</tr>

</tbody>

</table>

</div>

Product Catalog for Facebook

Use XMLWriter

	//https://developers.facebook.com/docs/marketing-api/dynamic-product-ads/product-catalog#feed-format
	function catalog(){
		$writer = new XMLWriter();  
		$writer->openURI('php://output');  
		$writer->startDocument('1.0','UTF-8');  
		$writer->setIndent(4);   
		$writer->startElement('rss');
			$writer->writeAttribute('xmlns:g', 'http://base.google.com/ns/1.0');
			$writer->writeAttribute('version', '2.0');

			$site = $this->options_m->get_site_settings(2);
			$writer->startElement('channel');
				$writer->writeElement('title', $site->title);
				$writer->writeElement('link', 'https://wecharming.life');
				$writer->writeElement('description', $site->site_desc);

				$prods = $this->products_m->catalog();
				foreach ($prods as $key => $prod) {
					$writer->startElement('item');
						$writer->writeElement('g:id', $prod->id);
						$writer->writeElement('g:title', $prod->title);
						$writer->writeElement('g:description', $prod->summary);
						$writer->writeElement('g:link', base_url() . 'shop/product/' . $prod->id);
						$writer->writeElement('g:image_link', $prod->photo);
						$writer->writeElement('g:brand', 'WeCharming');
						$writer->writeElement('g:condition', 'new');
						$writer->writeElement('g:availability', 'in stock');
						$writer->writeElement('g:price', $prod->price . ' TWD');
						
						//https://www.google.com/basepages/producttype/taxonomy-with-ids.en-US.txt
						$writer->writeElement('g:google_product_category', 'Health & Beauty > Personal Care > Cosmetics > Skin Care');
					$writer->endElement();
				}
			$writer->endElement();

		$writer->endElement();
		$writer->endDocument();
		$writer->flush();
	}

//https://developers.facebook.com/docs/marketing-api/dynamic-product-ads/product-catalog#feed-format

function catalog(){

$writer = new XMLWriter();

$writer->openURI('php://output');

$writer->startDocument('1.0','UTF-8');

$writer->setIndent(4);

$writer->startElement('rss');

$writer->writeAttribute('xmlns:g', 'http://base.google.com/ns/1.0');

$writer->writeAttribute('version', '2.0');

$site = $this->options_m->get_site_settings(2);

$writer->startElement('channel');

$writer->writeElement('title', $site->title);

$writer->writeElement('link', 'https://wecharming.life');

$writer->writeElement('description', $site->site_desc);

$prods = $this->products_m->catalog();

foreach ($prods as $key => $prod) {

$writer->startElement('item');

$writer->writeElement('g:id', $prod->id);

$writer->writeElement('g:title', $prod->title);

$writer->writeElement('g:description', $prod->summary);

$writer->writeElement('g:link', base_url() . 'shop/product/' . $prod->id);

$writer->writeElement('g:image_link', $prod->photo);

$writer->writeElement('g:brand', 'WeCharming');

$writer->writeElement('g:condition', 'new');

$writer->writeElement('g:availability', 'in stock');

$writer->writeElement('g:price', $prod->price . ' TWD');

//https://www.google.com/basepages/producttype/taxonomy-with-ids.en-US.txt

$writer->writeElement('g:google_product_category', 'Health & Beauty > Personal Care > Cosmetics > Skin Care');

$writer->endElement();

}

$writer->endElement();

$writer->endDocument();

$writer->flush();

}

Catalog Format
https://developers.facebook.com/docs/marketing-api/dynamic-product-ads/product-catalog#feed-format
Google product category
https://www.google.com/basepages/producttype/taxonomy-with-ids.en-US.txt
Example
https://stackoverflow.com/questions/3212982/need-to-write-xml-using-php-how

Black list to hide .env values from debug mode

Append this array to config/app.php

'debug_blacklist' => [
        '_ENV' => [
            'APP_KEY',
            'DB_HOST',
            'DB_PORT',
            'DB_DATABASE',
            'DB_USERNAME',
            'DB_PASSWORD',
            'DB_HOST_TW',
            'DB_PORT_TW',
            'DB_DATABASE_TW',
            'DB_USERNAME_TW',
            'DB_PASSWORD_TW',
            'DB_HOST_DE',
            'DB_PORT_DE',
            'DB_DATABASE_DE',
            'DB_USERNAME_DE',
            'DB_PASSWORD_DE',
            'DB_HOST_US',
            'DB_PORT_US',
            'DB_DATABASE_US',
            'DB_USERNAME_US',
            'DB_PASSWORD_US',
            'MAIL_USERNAME',
            'MAIL_PASSWORD',
        ],

        '_SERVER' => [
            'APP_KEY',
            'DB_HOST',
            'DB_PORT',
            'DB_DATABASE',
            'DB_USERNAME',
            'DB_PASSWORD',
            'DB_HOST_TW',
            'DB_PORT_TW',
            'DB_DATABASE_TW',
            'DB_USERNAME_TW',
            'DB_PASSWORD_TW',
            'DB_HOST_DE',
            'DB_PORT_DE',
            'DB_DATABASE_DE',
            'DB_USERNAME_DE',
            'DB_PASSWORD_DE',
            'DB_HOST_US',
            'DB_PORT_US',
            'DB_DATABASE_US',
            'DB_USERNAME_US',
            'DB_PASSWORD_US',
            'MAIL_USERNAME',
            'MAIL_PASSWORD',
        ],

        '_POST' => [
            'password',
        ],
    ],

'debug_blacklist' => [

'_ENV' => [

'APP_KEY',

'DB_HOST',

'DB_PORT',

'DB_DATABASE',

'DB_USERNAME',

'DB_PASSWORD',

'DB_HOST_TW',

'DB_PORT_TW',

'DB_DATABASE_TW',

'DB_USERNAME_TW',

'DB_PASSWORD_TW',

'DB_HOST_DE',

'DB_PORT_DE',

'DB_DATABASE_DE',

'DB_USERNAME_DE',

'DB_PASSWORD_DE',

'DB_HOST_US',

'DB_PORT_US',

'DB_DATABASE_US',

'DB_USERNAME_US',

'DB_PASSWORD_US',

'MAIL_USERNAME',

'MAIL_PASSWORD',

'_SERVER' => [

'APP_KEY',

'DB_HOST',

'DB_PORT',

'DB_DATABASE',

'DB_USERNAME',

'DB_PASSWORD',

'DB_HOST_TW',

'DB_PORT_TW',

'DB_DATABASE_TW',

'DB_USERNAME_TW',

'DB_PASSWORD_TW',

'DB_HOST_DE',

'DB_PORT_DE',

'DB_DATABASE_DE',

'DB_USERNAME_DE',

'DB_PASSWORD_DE',

'DB_HOST_US',

'DB_PORT_US',

'DB_DATABASE_US',

'DB_USERNAME_US',

'DB_PASSWORD_US',

'MAIL_USERNAME',

'MAIL_PASSWORD',

'_POST' => [

'password',

Upload Multiple Images

HTML

<form name="upload_image_form" action="{{ BASE_URL }}event/image" method="POST">
	<input type="file" class="form-control" name="images[]" multiple>
	<input type="hidden" name="id" value="{{$event->id}}">
	<button type="submit" class="btn btn-secondary">新增圖片</button>
</form>

</form>

Laravel:

    public function upload_image(Request $req){
        $user = $this->guard()->user();

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

        $event = EventM::find($eid);

        if($this->check_pms($event->pid) == false){
            return $this->fail_response('權限錯誤');
        }

        $allow_mime = ['image/png', 'image/jpg', 'image/gif', 'image/jpeg'];
        $event_images = json_decode($event->images);

        $images = $req->file('images');
        foreach($images as $key => $image){
            //logg($image->getSize()/1024/1024);//mb
            $mime = $image->getMimeType();
            if(in_array($mime, $allow_mime) == false){
                continue;
            }
            
            $path = $image->store('public/' . $user->id);
            $image = str_replace('public', '', $path);

            self::make_thumb($image);

            $event_images[] = $image;
        }

        $event->images = json_encode($event_images);
        $event->save();

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

public function upload_image(Request $req){

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

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

if($eid == false){

return $this->fail_response('ID錯誤');

}

$event = EventM::find($eid);

if($this->check_pms($event->pid) == false){

return $this->fail_response('權限錯誤');

}

$allow_mime = ['image/png', 'image/jpg', 'image/gif', 'image/jpeg'];

$event_images = json_decode($event->images);

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

foreach($images as $key => $image){

//logg($image->getSize()/1024/1024);//mb

$mime = $image->getMimeType();

if(in_array($mime, $allow_mime) == false){

continue;

}

$path = $image->store('public/' . $user->id);

$image = str_replace('public', '', $path);

self::make_thumb($image);

$event_images[] = $image;

}

$event->images = json_encode($event_images);

$event->save();

return $this->success_response($eid);

}

Response with UTF-8 format without Encode Chinese Chars

Example

    protected function success_response($data, $extra=null){
        $response = [
            'status' => 'success', 
            'data' => $data, 
            'extra' => $extra
        ];

        //header('Content-Type: application/json');
        //echo json_encode($response);
        //exit();
        return response()->json($response, 
            200,
            ['Content-Type' => 'application/json;charset=UTF-8', 'Charset' => 'utf-8'],
            JSON_UNESCAPED_UNICODE
        );
    }

protected function success_response($data, $extra=null){

$response = [

'status' => 'success',

'data' => $data,

'extra' => $extra

];

//header('Content-Type: application/json');

//echo json_encode($response);

//exit();

return response()->json($response,

200,

['Content-Type' => 'application/json;charset=UTF-8', 'Charset' => 'utf-8'],

JSON_UNESCAPED_UNICODE

);

}

Reference:

https://dev.admin.topeak.com/api/tw/orders?api_token=rjWbsioNC6UmhCMx6hor4kr7LG46WUD1fOBGTtwVliiYzK7GWPMF6wK7SN5b&from=2020-06-01

Laravel Mail Bugs

Some variable failed to pass to Mailable objects for unknown reason.
Laravel 6.x seems to fix this issue.
url() helper will use APP_URL in .env. url() won’t use this in controllers.

Rex's Personal Site

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

Category Archives: PHP

UserC for Laravel-Permission

RoleC for Laravel-Permission

There is no role with id `123` Issue

Share data to all views

Jquery Repeater

Product Catalog for Facebook

Black list to hide .env values from debug mode

Upload Multiple Images

Response with UTF-8 format without Encode Chinese Chars

Laravel Mail Bugs

July 2020
M	T	W	T	F	S	S
« Jun
		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	31