Monthly Archives: July 2020

Append Params to Current URL

Laravel:

if(!function_exists('append_params')){
	function append_params($params){
		$url = url()->current();
		$new_params = array_merge(request()->all(), $params);
		$url .= '?' . http_build_query($new_params);
		//logg($url);

		return $url;
	}
}

if(!function_exists('append_params')){

function append_params($params){

$url = url()->current();

$new_params = array_merge(request()->all(), $params);

$url .= '?' . http_build_query($new_params);

//logg($url);

return $url;

}

https://stackoverflow.com/questions/54762882/how-to-add-extra-parameter-with-full-url-in-laravel-blade

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.

Get Search Value of Datatable

$('.dataTables_filter input').val();

1	$('.dataTables_filter input').val();

https://stackoverflow.com/questions/26590778/how-to-get-value-entered-in-search-box-in-datatables

Set explicit value of a cell (alphabet coordinate)

By data type

if($field[3] == 'int'){
	$sheet->setCellValue($coordinate, $value);
}elseif($field[3] == 'date'){
	$sheet->setCellValue($coordinate, $value);

	$sheet->getStyle($coordinate)
		->getNumberFormat()
		->setFormatCode(
			\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME
		);
}else{
	$sheet->setCellValueExplicit(
		$coordinate,
		$value,
		\PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING
	);
}

if($field[3] == 'int'){

$sheet->setCellValue($coordinate, $value);

}elseif($field[3] == 'date'){

$sheet->setCellValue($coordinate, $value);

$sheet->getStyle($coordinate)

->getNumberFormat()

->setFormatCode(

\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME

);

}else{

$sheet->setCellValueExplicit(

$coordinate,

$value,

\PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING

);

}

https://phpspreadsheet.readthedocs.io/en/latest/topics/accessing-cells/

Copy & Paste not working in anydesk

Restart rdpclip.exe

Windows工作管理員
處理程序tab: 如果有rdpclip的話就把它關閉
應用程式tab: 新增工作 -> rdpclip.exe
關閉anydesk連線
重新連線anydesk

https://support.jumpdesktop.com/hc/en-us/articles/216425123-RDP-Clipboard-syncing-stops-working-occasionally

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 UI Datepicker & DateTimePicker Addon

Download

https://jqueryui.com/download

https://github.com/trentrichardson/jQuery-Timepicker-Addon

https://www.dropbox.com/s/qhwuvv3asnr0vs8/jquery_datetimepicker.zip?dl=0

HTML

<link href="{{BASE_URL}}/plugins/jquery-ui/jquery-ui.min.css" rel="stylesheet" />
<link href="{{BASE_URL}}/plugins/DateTimePicker/jquery-ui-timepicker-addon.min.css" rel="stylesheet" />

<script src="{{BASE_URL}}/plugins/jquery-ui-1.10.4.custom.min.js"></script>
<script src="{{BASE_URL}}/plugins/jquery-ui-timepicker-addon.js"></script>

Javascript:

$('.datetimepicker').datetimepicker({
	"dateFormat": "yy-mm-dd",
	"timeFormat": "HH:mm"
});

$('.datepicker').datepicker({
	dateFormat: "yy-mm-dd"
});

$('.datetimepicker').datetimepicker({

"dateFormat": "yy-mm-dd",

"timeFormat": "HH:mm"

});

$('.datepicker').datepicker({

dateFormat: "yy-mm-dd"

});

Datatable with buttons

Download with extensions

https://datatables.net/download/

HTML

<link href="{{BASE_URL}}/plugins/DataTables/datatables.min.css" rel="stylesheet" />


<script src="{{BASE_URL}}/plugins/DataTables/datatables.js"></script>

Javascript

var dt_app = function(){
    var $c = null;
    var $t = null;
    var datatable = null;

    function init(){
        $c = $("main");
        $t = $c.find('#dt_table');
        
        init_actions();
        init_dt();
    }

    function init_dt(){
        datatable = $t.DataTable({
            "searching": true,
            "info": true,
            "lengthChange": true,
            "paging": true,
            'serverSide': true, 
            'processing': true, 
            "order": [[ 0, "desc" ]], 
            "ajax": {
                'url': base_url + '/admin/' + controller + '/all',
                'data': function(d){
                    //d.pid = pid;
                }
            },
            'columns': [
                {
                    'data': 'id', 
                    'title': 'ID'
                },
                {
                    'data': 'action', 
                    'title': '動作'
                },
                {
                    'data': 'd_name', 
                    'title': '設備名稱'
                },
                {
                    'data': 'alias', 
                    'title': '別名'
                },
                {
                    'data': 'tag_id', 
                    'title': 'Tag ID'
                },
                {
                    'data': 'device_id', 
                    'title': '設備編號'
                },
                {
                    'data': 'created_at', 
                    'title': '建立時間'
                }
            ],  
            "drawCallback": function( settings ) {
                var api = this.api();
                //wrap.loaded(settings);
                loaded(settings);
            }, 
            'initComplete': function(settings, json){
                //loaded(settings);
            },
            dom: 'lBfrtip',
            buttons: [
                'copy',
                {
                    extend: 'csv',
                    title: 'WashHandRecords',
                    bom : true
                }, 
                {
                    extend: 'excel',
                    title: 'WashHandRecords',
                    bom : true
                }, 
                //'excel',
                //{
                    //extend: 'pdf',
                    //text: 'PDF',
                    //bom : true,
                    //'chartset':'utf-8'},
                'print'
            ]
        });
    }

    function loaded(oSettings){

    }

    function refresh(){
        if(datatable != null){
            datatable.destroy();
        }
        
        init_dt();
    }

    function init_actions(){
        $t.delegate('tbody tr .action.edit', 'click', function(e){
            e.preventDefault();
            var $this = $(this);
            var id = $this.data('id');
            var params = {
                id: id
            }

            window.location.href = base_url + '/admin/' + controller + '/edit?' + $.param(params);
        });

        $t.delegate('tbody tr .action.delete', 'click', function(e){
            e.preventDefault();
            var $this = $(this);
            var id = $this.data('id');

            if(confirm('確定刪除這筆資料?') == true){
                delete_item(id);
            }
        });
    }

    function delete_item(id){
        var params = {
            id: id
        }
        //console.log(params);
        //return;

        $.ajax({
            type: 'post',
            url: base_url + '/admin/' + controller + '/delete',
            data: params,
            dataType: 'json',
            success: function(data){
                if(typeof data.status == 'undefined'){
                    alert(data);
                }else if(data.status == 'fail'){
                    alert(data.message);
                }else{
                    //alert('Item is deleted.');
                    refresh();
                }
            },
            error: function(data){
                console.log(data);
                var errors = data.responseJSON;
                show_response_error(errors);
            }
        });
    }

    return {
        init: init, 
        refresh: refresh
    }
}();

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

var dt_app = function(){

var $c = null;

var $t = null;

var datatable = null;

function init(){

$c = $("main");

$t = $c.find('#dt_table');

init_actions();

init_dt();

}

function init_dt(){

datatable = $t.DataTable({

"searching": true,

"info": true,

"lengthChange": true,

"paging": true,

'serverSide': true,

'processing': true,

"order": [[ 0, "desc" ]],

"ajax": {

'url': base_url + '/admin/' + controller + '/all',

'data': function(d){

//d.pid = pid;

}

'columns': [

{

'data': 'id',

'title': 'ID'

{

'data': 'action',

'title': '動作'

{

'data': 'd_name',

'title': '設備名稱'

{

'data': 'alias',

'title': '別名'

{

'data': 'tag_id',

'title': 'Tag ID'

{

'data': 'device_id',

'title': '設備編號'

{

'data': 'created_at',

'title': '建立時間'

}

"drawCallback": function( settings ) {

var api = this.api();

//wrap.loaded(settings);

loaded(settings);

'initComplete': function(settings, json){

//loaded(settings);

dom: 'lBfrtip',

buttons: [

'copy',

{

extend: 'csv',

title: 'WashHandRecords',

bom : true

{

extend: 'excel',

title: 'WashHandRecords',

bom : true

//'excel',

//{

//extend: 'pdf',

//text: 'PDF',

//bom : true,

//'chartset':'utf-8'},

'print'

]

});

}

function loaded(oSettings){

}

function refresh(){

if(datatable != null){

datatable.destroy();

}

init_dt();

}

function init_actions(){

$t.delegate('tbody tr .action.edit', 'click', function(e){

e.preventDefault();

var $this = $(this);

var id = $this.data('id');

var params = {

id: id

}

window.location.href = base_url + '/admin/' + controller + '/edit?' + $.param(params);

});

$t.delegate('tbody tr .action.delete', 'click', function(e){

e.preventDefault();

var $this = $(this);

var id = $this.data('id');

if(confirm('確定刪除這筆資料?') == true){

delete_item(id);

}

});

}

function delete_item(id){

var params = {

id: id

}

//console.log(params);

//return;

$.ajax({

type: 'post',

url: base_url + '/admin/' + controller + '/delete',

data: params,

dataType: 'json',

success: function(data){

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

alert(data);

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

alert(data.message);

}else{

//alert('Item is deleted.');

refresh();

}

error: function(data){

console.log(data);

var errors = data.responseJSON;

show_response_error(errors);

}

});

}

return {

init: init,

refresh: refresh

}

}();

Rex's Personal Site

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

Monthly Archives: July 2020

Append Params to Current URL

UserC for Laravel-Permission

RoleC for Laravel-Permission

There is no role with id `123` Issue

Get Search Value of Datatable

Set explicit value of a cell (alphabet coordinate)

Copy & Paste not working in anydesk

Share data to all views

jQuery UI Datepicker & DateTimePicker Addon

Datatable with buttons