/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$modules = Module::all();
$admin = Role::where('name', 'admin')->get()->first();
$tech = Role::where('name', 'tech')->get()->first();
$result = DB::table('permission_role')->insert(['role_id' => $admin->id, 'permission_id' => 1, 'action' => 34, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $tech->id, 'permission_id' => 1, 'action' => 34, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $admin->id, 'permission_id' => 2, 'action' => 34, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $tech->id, 'permission_id' => 2, 'action' => 34, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $admin->id, 'permission_id' => 3, 'action' => 34, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $tech->id, 'permission_id' => 3, 'action' => 34, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $admin->id, 'permission_id' => 4, 'action' => 34, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $tech->id, 'permission_id' => 4, 'action' => 34, 'access' => 'module']);
}
public function module()
{
$title = 'Module';
$css = $this->CSS('users');
$jH = $this->jS('module');
$result = Module::all();
$a = 0;
$footer = Setting::where('name', 'footer')->get();
if (count($footer) > 0) {
$footer = $footer->first()->value;
} else {
$footer = '(c) Ordent ' . date('Y');
}
$sB = $this->getPermission('1');
$sBa = $this->getDefault();
$sBe = $this->getDefault();
$sBd = $this->getDefault();
return view('backend.module', compact('css', 'jH', 'title', 'result', 'a', 'footer', 'sB'));
}
public function all()
{
return Module::all();
}
public function modules($presentationId)
{
$cancelled = CancelPresentation::findOrFail($presentationId);
$modules = Module::all();
$authorized = ModulePresentationAuthorized::where("cancelled_presentation_id", $presentationId)->get();
return view('internal.promoter.presentation.authorized', ['cancelled' => $cancelled, "modules" => $modules, "authorized" => $authorized]);
}
public function showAssigment()
{
//
$assigmentmodules = DB::table('module_assigments')->select(DB::raw('module_assigments.id as idAssigment, module_assigments.module_id as idModule, modules.name as nameModule, module_assigments.salesman_id as idSalesman, users.name as nameSalesman, users.lastName as lastnameSalesman, module_assigments.dateAssigments as dateAssigment'))->where('module_assigments.status', '=', 1)->leftJoin('modules', 'modules.id', '=', 'module_assigments.module_id')->leftJoin('users', 'users.id', '=', 'module_assigments.salesman_id')->get();
//->lists('modules.name as name','modules.id as id');
/* $modules_list = DB::table('modules')
//->select(DB::raw('modules.name as name, modules.id as id'))
//->where('module_assigments.status','=',2)
//-> where('module_assigments.status','is',null)
//->leftJoin('module_assigments', 'modules.id', '=', 'module_assigments.module_id')
//->get();
//->lists('modules.name as name','modules.id as id');*/
/*$salesmans_list = DB::table('users')
->select(DB::raw('users.name as name, users.id as id'))
// ->where('module_assigments.status','=',2)
-> where('module_assigments.status','is',null)-> where('Susers.role_id','=',2)
->leftJoin('module_assigments', 'users.id', '=', 'module_assigments.salesman_id')
->get();
//->lists('users.name as name','users.id as id');*/
$modEx = DB::table('module_assigments')->where('status', '=', 1)->get();
$modules_list = Module::all()->lists('name', 'id');
$salesmans_list = User::all()->where('role_id', 2)->where('module_id', null)->lists('di', 'id', 'name', 'lastname');
//$modules_list = [];
//$salesmans_list = [];
/*foreach ($modules as $module) {
array_push($modules_list,array($module->name, $module->id));
}
foreach ($salesmans as $salesman) {
array_push($salesmans_list,array($salesmans->name + ' ' + $salesmans->lastName, $salesman->id));
}*/
$array = ['modules_list' => $modules_list, 'salesmans_list' => $salesmans_list];
//$assigmentmodule->setPath('modules');
return view('internal.admin.moduleassigment', compact('assigmentmodules', 'modEx'), $array);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return Module::all();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$module = new Module();
$module->name = 'Home Site';
$module->route = "/";
$module->save();
$module = new Module();
$module->name = 'Login';
$module->route = "login";
$module->save();
$module = new Module();
$module->name = 'Backend User';
$module->route = "admin/user";
$module->save();
$module = new Module();
$module->name = 'Backend Role';
$module->route = "admin/role";
$module->save();
$module = new Module();
$module->name = 'Backend Permission';
$module->route = "admin/permission";
$module->save();
$module = new Module();
$module->name = 'Backend Module';
$module->route = "admin/module";
$module->save();
$module = new Module();
$module->name = 'Backend Dashboard';
$module->route = "admin/dashboard";
$module->save();
$module = new Module();
$module->name = 'Backend Menu';
$module->route = "admin/menu";
$module->save();
$module = new Module();
$module->name = 'Backend Preference';
$module->route = "admin/preference";
$module->save();
$module = new Module();
$module->name = 'Backend Grid';
$module->route = "admin/grid";
$module->save();
$module = new Module();
$module->name = 'Backend Gambar';
$module->route = "admin/gambar";
$module->save();
$module = new Module();
$module->name = 'Backend Menu Child';
$module->route = "admin/menu:child";
$module->save();
$module = new Module();
$module->name = 'Backend Preference Image';
$module->route = "admin/preference:image";
$module->save();
$module = new Module();
$module->name = 'Backend Preference Background';
$module->route = "admin/preference:background";
$module->save();
$module = new Module();
$module->name = 'Backend Preference Logo';
$module->route = "admin/preference:logo";
$module->save();
$module = new Module();
$module->name = 'Backend Preference Footer';
$module->route = "admin/preference:footer";
$module->save();
$modules = Module::all();
$admin = Role::where('name', 'admin')->get()->first();
$tech = Role::where('name', 'tech')->get()->first();
foreach ($modules as $key => $m) {
$permission = new Permission();
$permission->name = "can-access-module-" . $m->name;
$permission->display_name = 'Dapat mengakses ' . $m->name;
$permission->access = 'access';
$permission->action = $m->id;
$permission->type = 'module';
$permission->save();
$result = DB::table('permission_role')->insert(['role_id' => $admin->id, 'permission_id' => $permission->id]);
$result = DB::table('permission_role')->insert(['role_id' => $tech->id, 'permission_id' => $permission->id]);
}
}
public function system()
{
$system = Business::all()->first();
$modules = Module::all()->lists('name', 'id');
if ($modules->count() == 0) {
$modules = [0 => 'Sin canjeo'];
}
return view('internal.admin.system', compact('system', 'modules'));
}
/**
* Display the specified resource.
*
* @return \Illuminate\Http\Response
*/
public function showAssigment()
{
$moduleAssigments = ModuleAssigment::all();
$assiInformation = [];
foreach ($moduleAssigments as $moduleAssigment) {
// pueden ser muchos eventos. Necesito información para llenar la tabla
$module = Module::find($moduleAssigment->module_id);
$salesman = User::find($moduleAssigment->salesman_id);
$role = Role::find($salesman->role_id);
array_push($assiInformation, array($module->name, $salesman->name, $salesman->lastname, $moduleAssigment->dateAssigments, $moduleAssigment->dateMoveAssigments, $role->description));
}
//$array_module = [];
$modules_list = Module::all()->lists('name', 'id');
$array = ['modules_list' => $modules_list];
return view('internal.admin.reports.assignment', compact('assiInformation'), $array);
}
public function getUpdateModule(Request $request)
{
$data = $request->all();
$i = 0;
$role = Role_user::find($data['role_user']);
if (isset($data['semua_module'])) {
$module = Module::all();
foreach ($module as $value) {
$upload[$i]['module_id'] = $value->id;
$i++;
}
} else {
foreach ($data as $key => $value) {
if (substr($key, 0, 2) == 'x_') {
$upload[$i]['module_id'] = substr($key, 2);
$i++;
}
}
}
$role_1 = Role_user::where('id', $data['role_user'])->with('module_user')->firstOrFail()->toArray();
$array_user = $upload;
$array_db = $role_1['module_user'];
// dd($array_user);
$i = 0;
foreach ($array_user as $value) {
$collection = collect($array_db);
$bool = $collection->contains($value['module_id']);
if ($bool == false) {
$role->module_user()->attach($value['module_id'], ['created_by' => Auth::user()->id]);
}
$i++;
}
$i = 0;
foreach ($array_db as $value) {
$collection = collect($array_user);
$bool = $collection->contains($value['id']);
if ($bool == false) {
$role->module_user()->detach($value['id']);
}
$i++;
}
// if(count($role_1['module_user']) > count($upload)){
// for ($i=0; $i<count($role_1['module_user']); $i++){
// if($role_1['module_user'][$i]['id'] != $upload[$i]['module_id'] ){
// $role->module_user()->detach($upload[$i]['module_id']);
// }
// }
//
// }elseif(count($role_1['module_user']) > count($upload)){
// echo 'lebih besar';
// }
$role->module_user()->attach($upload, ['created_by' => Auth::user()->id]);
return redirect('hrga/role-module');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$module = new Module();
$module->name = 'Home';
$module->route = "'/', 'PagesController@index'";
$module->save();
$module = new Module();
$module->name = 'login';
$module->route = "'login', ['uses'=>'UsersController@login', 'as'=>'users.login.get']";
$module->save();
$module = new Module();
$module->name = 'admin/user';
$module->route = "'admin/user', ['uses'=>'PagesController@user', 'as'=>'admin.user.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/role';
$module->route = "'admin/role', ['uses'=>'PagesController@role', 'as'=>'admin.role.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/permission';
$module->route = "'admin/permission', ['uses'=>'PagesController@permission', 'as'=>'admin.permission.get']";
$module->save();
$module = new Module();
$module->name = 'admin/module';
$module->route = "'admin/module', ['uses'=>'PagesController@module', 'as'=>'admin.permission.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/tes';
$module->route = "'admin/tes', ['uses'=>'PagesController@tes', 'as'=>'admin.user.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/dashboard';
$module->route = "'admin/dashboard', ['uses'=>'PagesController@dashboard', 'as'=>'admin.dashboard.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/menu';
$module->route = "'admin/menu', ['uses'=>'PagesController@menu', 'as'=>'admin.menu.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/preference';
$module->route = "'admin/preference', ['uses'=>'PagesController@preference', 'as'=>'admin.preference.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/grid';
$module->route = "'admin/grid', ['uses'=>'PagesController@grid', 'as'=>'admin.grid.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'admin/form:child';
$module->route = "'admin/form:child', ['uses'=>'ChildController@formChild', 'as'=>'admin.grid.get', 'middleware'=>'auth']";
$module->save();
$module = new Module();
$module->name = 'Menu Images';
$module->route = "any admin/gambar";
$module->save();
$module = new Module();
$module->name = 'admin/users';
$module->route = "[Menu^=admin/users]";
$module->save();
$module = new Module();
$module->name = 'admin/roles';
$module->route = "[Menu^=admin/roles]";
$module->save();
$module = new Module();
$module->name = 'admin/menu:child';
$module->route = "admin/menu:child";
$module->save();
$module = new Module();
$module->name = 'admin/preference:image';
$module->route = "admin/preference:image";
$module->save();
$module = new Module();
$module->name = 'admin/preference:background';
$module->route = "admin/preference:background";
$module->save();
$module = new Module();
$module->name = 'admin/preference:logo';
$module->route = "admin/preference:logo";
$module->save();
$module = new Module();
$module->name = 'admin/preference:footer';
$module->route = "admin/preference:footer";
$module->save();
$modules = Module::all();
$admin = Role::where('name', 'admin')->get()->first();
$tech = Role::where('name', 'tech')->get()->first();
foreach ($modules as $key => $m) {
$permission = new Permission();
$permission->name = $m->name;
$permission->display_name = 'Dapat mengakses module ' . $m->name;
$permission->access = true;
$permission->action = 'access';
$permission->type = 'module';
$permission->save();
$result = DB::table('permission_role')->insert(['role_id' => $admin->id, 'permission_id' => $permission->id, 'action' => 1, 'access' => 'module']);
$result = DB::table('permission_role')->insert(['role_id' => $tech->id, 'permission_id' => $permission->id, 'action' => 1, 'access' => 'module']);
}
}
