<?php

use Illuminate\Database\Seeder;

class BasicSetupSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $timezone= DB::table('system_timezone')->insert([
            ['name'=>'London','value'=>'Europe/London'],
            ['name'=>'Bangladesh','value'=>'Asia/Dhaka']
        ]);

        $designation= DB::table('system_designations')->insert([
            ['title'=>'CEO','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Software Engineer','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Programmer','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Web Developer','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'System Engineer','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Manager','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()]
        ]);

        $event= DB::table('system_event_type')->insert([
            ['title'=>'Training','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Meeting','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Weekend','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
        ]);
        $event= DB::table('system_leave_type')->insert([
            ['title'=>'Casual leave','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Sick Leave','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Maternity Leave','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Paternity Leave','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
        ]);
        $holiday= DB::table('system_holidays')->insert([
            ['title'=>'Religion Holiday','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['title'=>'Public Holiday','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
        ]);

        $roles= DB::table('system_roles')->insert([
            ['role_name'=>'Administrator','title'=>'System Administrator',
                'menus'=>'{"dashboard#dashboard#pe-7s-graph":"null","basic_setup#null#pe-7s-unlock":["designation#designation.index","holiday_type#holiday-type.index","leave_type#client-leave-type.index","user_group#user-group.index","event_type#event-type.index"],"my_rota#my-rota#pe-7s-news-paper":"null","my_report#my-report#pe-7s-news-paper":"null","user#user#pe-7s-users":"null","event_setup#event#pe-7s-date":"null","leave_or_exchange#user-leave#pe-7s-next-2":["leave#user-leave","exchange#exchange"],"leave_exchange_manage#leave-manage#pe-7s-next-2":"null","reports#null#pe-7s-note2":["attendance#attendance-details","leave#leave-reports","exchange#exchange-reports"],"rota_setup#rota-setup#pe-7s-news-paper":"null","access_control#acl#pe-7s-unlock":"null"}',
                'routes'=>'{"0":"designation.index","1":"designation.create","2":"designation.store","3":"designation.edit","4":"designation.update","5":"deleteDesignation","6":"holiday-type.index","7":"holiday-type.create","8":"holiday-type.store","9":"holiday-type.edit","10":"holiday-type.update","11":"holidayTypeDelete","12":"client-leave-type.index","13":"client-leave-type.create","14":"client-leave-type.store","15":"client-leave-type.edit","16":"client-leave-type.update","17":"clientLeaveTypeDelete","18":"user-group.index","19":"user-group.create","20":"user-group.store","21":"user-group.edit","22":"user-group.update","23":"userGroupDelete","24":"event-type.index","25":"event-type.create","26":"event-type.store","27":"event-type.edit","28":"event-type.update","29":"clientEventTypeDelete","30":"user-leave","31":"user-leave.post","32":"user-leave-apply","33":"user-leave-apply.post","34":"leave-notification-view","35":"leave_apply_edit","36":"leave_apply_edit.post","37":"leave-apply-delete","38":"exchange","39":"exchange.post","40":"exchange-apply","41":"exchange-apply.post","42":"exchange-notification-view","43":"exchange-edit","44":"exchange-edit.post","45":"exchange-delete","46":"attendance-details","47":"attendance-details.post","48":"leave-reports","49":"leave-reports.post","50":"exchange-reports","51":"exchange-reports.post","52":"in","53":"out","54":"taskSubmit","55":"taskUpdate","56":"userWiseEvent","57":"user.index","58":"user.create","59":"user.edit","60":"user.update","61":"userDelete","62":"user-details-report","63":"updateUserAttendance","64":"loadCalendar","65":"selectEventType","66":"getEvent","67":"saveEvent","68":"getMembersByUserGroup","69":"getEventByMonth","70":"deleteEvent","71":"leave-manage","72":"leave-manage.post","73":"exchange-manage","74":"reply-exchange-comment","75":"acl","76":"roleSave","77":"roleEditModal","78":"deleteRole","79":"roleUpdate","80":"roleCreateModal","81":"permission","82":"permission.post","83":"dashboard","84":"getMyRotaData","85":"my-rota","86":"my-report.post","87":"my-report","88":"details-view-report","91":"event","93":"shift-assign-modal","94":"rota-setup","95":"shift-edit-modal","97":"shift-edit-modal.post","99":"shift-assign-modal-all","101":"shift-assign","103":"shift-assign-all","105":"rotaNextWeek","107":"rotaPrevWeek","109":"deleteRota","111":"copyRota","113":"pasteRota","115":"clearWeekRota","117":"weekShift"}','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
            ['role_name'=>'Employee','title'=>'Office Employee',
                'menus'=>'{"dashboard#dashboard#pe-7s-graph":"null","my_rota#my-rota#pe-7s-news-paper":"null","my_report#my-report#pe-7s-news-paper":"null","leave_or_exchange#user-leave#pe-7s-next-2":["leave#user-leave","exchange#exchange"]}',
                'routes'=>'["user-leave","user-leave.post","user-leave-apply","user-leave-apply.post","leave-notification-view","leave_apply_edit","leave_apply_edit.post","leave-apply-delete","exchange","exchange.post","exchange-apply","exchange-apply.post","exchange-notification-view","exchange-edit","exchange-edit.post","exchange-delete","in","out","taskSubmit","taskUpdate","userWiseEvent","dashboard","getMyRotaData","my-rota","my-report.post","my-report","details-view-report"]','created_at'=>\Carbon\Carbon::now(),'updated_at'=>\Carbon\Carbon::now()],
        ]);


    }
}
