/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$user = new Employee();
$user->name = 'Administrator';
$user->email = '*****@*****.**';
$user->password = bcrypt('marktimbol');
$user->save();
}
/**
* Deletes employee from database and returns status in json response
*
* @param $id
* @return array
*/
public function delete($id)
{
if ($employee = $this->employee->find($id)) {
if ($employee->delete()) {
return ['status' => 200];
}
return ['status' => 500];
}
return ['status' => 404];
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$this->validate($request, ['first_name' => 'required|max:100', 'middle_name' => 'required|max:100', 'last_name' => 'required|max:100', 'emp_id' => 'required|max:100', 'card_no' => 'required|max:100']);
$employee = new Employee();
$employee->first_name = $request->first_name;
$employee->middle_name = $request->middle_name;
$employee->last_name = $request->last_name;
$employee->emp_id = $request->emp_id;
$employee->card_no = $request->card_no;
$employee->active = 1;
$employee->save();
Session::flash('flash_message', 'Terminal successfully added!');
return redirect()->route("employee.index");
}
public function create()
{
$input = Input::all();
$customers = Customer::all();
$salesmen = Employee::all();
return view('return.create', compact('input', 'customers', 'salesmen'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$employee = Employee::findOrFail($id);
$name = $employee->name . " " . $employee->lastname;
Employee::destroy($id);
return redirect(route('employees.index'))->with('message', 'Empleado ' . $name . ' eliminado corectamente');
}
public function achievement()
{
$AMIds = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
$MRs = Employee::whereIn('manager_id', $AMIds)->get();
$dataView = ['MRs' => $MRs];
return view('sm.line.history.search', $dataView);
}
public function __construct()
{
$count = Employee::count();
$countProj = Project::count();
$data = Employee::all();
$YourRole = "";
if (count(Auth::user()) > 0) {
$YourRole = Auth::user()->UserRoles->role;
}
$Role2 = $this->Role1;
// Count Unconfirmed
$cc = 0;
foreach ($data as $da) {
if ($da->confirm == 0) {
$cc++;
}
}
$countConf = $cc;
// Count Confirmed
$cc1 = 0;
foreach ($data as $dat) {
if ($dat->confirm == 1) {
$cc1++;
}
}
$countConfirmed = $cc1;
View::share('countConf', $countConf);
View::share('YourRole', $YourRole);
View::share('countConfirmed', $countConfirmed);
View::share('count', $count);
View::share('countProj', $countProj);
}
public function search()
{
$AMs = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
$MRs = Employee::whereIn('manager_id', $AMs)->get();
$dataView = ['MRs' => $MRs];
return view('sm.search.plans.search', $dataView);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$suppliers = Supplier::orderBy('name')->get();
$employees = Employee::orderBy('firstname')->get();
$customers = Customer::orderBy('name')->get();
return view('inventory.home', compact(['suppliers', 'employees', 'customers']));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
$transaction = $request->all();
$empId = $transaction["empId"]['id'];
$siteId = $transaction["siteId"]['id'];
$workDate = $transaction["workDate"];
$day = (double) $transaction["day"];
$ot = (double) $transaction["ot"];
$advance = (double) $transaction["advance"];
//$wage = DB::select(DB::raw("select employee.wage from employee where employee.id=$empId "));
$wage = Employee::where('id', $empId)->first()->wage;
//dd($wage);
$amount = (double) (($day + $ot / 8.0) * $wage);
$transact = SiteEmployeeRel::create(['siteId' => $siteId, 'empId' => $empId, 'workDate' => $workDate, 'day' => $day, 'ot' => $ot, 'advance' => $advance, 'amount' => $amount, 'advance' => $advance]);
//return $transact;
//getting current date
$currentDate = Carbon::now();
//getting current year
$currentYear = $currentDate->year;
//getting current month
$currentMonth = $currentDate->month;
//getting the employee transaction according to current month and year
$transactions = DB::select(DB::raw("select e.name as empName,e.wage, s.name as siteName, t.workDate, t.day ,t.ot,t.advance,t.amount from siteemployeerel as t\n inner join employee as e on t.empId = e.id\n inner join site as s on t.siteId = s.id\n where year(t.workDate) = {$currentYear} and month(t.workDate) = {$currentMonth}\n order by t.created_at;"));
return json_encode(array('transactions' => $transactions));
}
public function testCanRemoveScope()
{
factory(User::class)->create(['type' => null]);
factory(User::class)->create(['type' => Employee::class]);
$users = Employee::withoutGlobalScope(\App\SingleTableInheritanceScope::class)->get();
$this->assertCount(2, $users);
}
public function edit($salarySheetId, $salarySheetRecordId)
{
$salary_sheet = SalarySheet::find($salarySheetId);
$employees = Employee::lists('name', 'id')->sort();
$salary_sheet_record = SalarySheetRecord::find($salarySheetRecordId);
return view('hr.salary_sheet.edit', compact('salary_sheet', 'employees', 'salary_sheet_record'));
}
public function update($id)
{
$task = Task::findOrFail($id);
$employees = Employee::where('level_id', '<>', 1)->get();
$dataView = ['task' => $task, 'employees' => $employees];
return view('admin.task.edit', $dataView);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$employee_ids = Employee::all()->lists('id')->toArray();
$order_states = OrderState::lists('id')->toArray();
$products = Product::all();
$municipalities = Municipality::all();
factory(App\Customer::class, 50)->create()->each(function ($customer) use($employee_ids, $products, $municipalities, $order_states) {
shuffle($employee_ids);
shuffle($order_states);
$customer->user()->save(factory(User::class, 'customer')->create());
$customer->city_id = $municipalities->shuffle()->first()->id;
$customer->save();
$customer->products()->attach($products->shuffle()->first(), ['vote' => rand(1, 5), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
$customer->orders()->save(factory(App\Order::class)->create(['acquired_by' => $employee_ids[0], 'state_id' => $order_states[0]]));
});
$user = new User();
$user->name = 'Vid';
$user->surname = 'Mahovic';
$user->email = '*****@*****.**';
$user->password = '******';
$user->verified = true;
$user->save();
$customer = new Customer();
$customer->street = 'Celovška 21';
$customer->city_id = $municipalities->shuffle()->first()->id;
$customer->phone = '+38640850993';
$customer->save();
$customer->user()->save($user);
}
public function listAll()
{
$employees = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
$customers = Customer::whereIn('mr_id', $employees)->get();
$dataView = ['customers' => $customers];
return view('am.customer.list', $dataView);
}
/**
* Bind data to the view.
*
* @param View $view
* @return void
*/
public function compose(View $view)
{
$view->with('disposition_check', ['use as is', 'ncmr#', 'rework', 'split lot', 'shutdown', 'shipback']);
$view->with('cod_check', ['production', 'process', 'maintenance', 'facilities', 'quality assurance', 'others']);
$view->with('approvers', ['production', 'process', 'quality assurance', 'others']);
$view->with('names', Employee::select('name')->orderBy('name')->where('name', '<>', Auth::User()->employee->name)->get());
}
public function update($id)
{
$customer = Customer::findOrFail($id);
$mrs = Employee::where('level_id', 7)->active()->get();
$dataView = ['customer' => $customer, 'mrs' => $mrs];
return view('admin.customer.edit', $dataView);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function getIndex()
{
$employee = Employee::all();
$categories = Event::all();
$userdetails = User::all();
$targets = Targetassign::all();
$deals = Deal::all();
$userData = array();
$key = 0;
foreach ($targets as $target) {
$achieved = 0;
$userData[$key]['eventcode'] = $target->Eventcode;
$userData[$key]['event'] = $target->Eventname;
$userData[$key]['employee'] = $target->Employeeid;
$userData[$key]['targetVal'] = $target->Targetvalue;
foreach ($deals as $deal) {
if ($target->Eventcode == $deal->Eventcode && $target->Employeeid == $deal->Empid) {
$achieved = $achieved + $deal->Dealvalue;
}
}
$userData[$key]['achieved'] = $achieved;
$userData[$key]['variance'] = $achieved - $target->Targetvalue;
$userData[$key]['cur'] = $target->Currency;
$key++;
}
return View('targetmodule/assigntarget')->with(array('categories' => $categories, 'employee' => $employee, 'userdata' => $userData, 'targets' => $targets, 'eventtable' => $categories));
}
public function search()
{
$products = Product::where('line_id', Employee::find(\Auth::user()->id)->line_id)->get();
$doctors = Customer::where('mr_id', \Auth::user()->id)->get();
$dataView = ['products' => $products, 'doctors' => $doctors];
return view('mr.search.sales.search', $dataView);
}
/**
* Bind data to the view.
*
* @param View $view
* @return void
*/
public function compose(View $view)
{
$view->with('select_failure_mode', ['Assembly', 'Environment', 'Machine', 'Man', 'Material', 'Method / Process']);
$view->with('customers', Option::orderBy('customer')->select('customer')->get());
$view->with('machines', Machine::orderBy('name')->select('name')->get());
$view->with('stations', Station::select('station')->get());
$view->with('employees', Employee::orderBy('name')->select('name')->where('name', '<>', Auth::user()->employee->name)->get());
}
public function getIndex()
{
$categories = Event::all();
$employee = Employee::all();
$invoice = Invoice::all();
$invnull = Invoice::where('Status', '=', 'Null')->get();
return View('home2')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice, 'invnull' => $invnull));
}
public function listAll()
{
$AMsIds = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
$MRs = Employee::whereIn('manager_id', $AMsIds)->get();
$AMs = Employee::where('manager_id', \Auth::user()->id)->get();
$dataView = ['MRs' => $MRs, 'AMs' => $AMs];
return view('sm.employee.list', $dataView);
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function getData()
{
if (!\Request::ajax()) {
\App::abort(404, 'not found naja');
}
$data = App\Employee::all();
return \Response::json($data);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
factory(App\Employee::class, 20)->create()->each(function ($employee) {
$employee->user()->save(factory(User::class, 'employee')->create());
});
$user = new User();
$user->name = 'Erik';
$user->surname = 'Drobne';
$user->email = '*****@*****.**';
$user->password = '******';
$user->verified = true;
$user->save();
$employee = new Employee();
$employee->cert_auth = '*****@*****.**';
$employee->save();
$employee->user()->save($user);
}
public function search()
{
$employeesLines = Employee::select('line_id')->where('manager_id', \Auth::user()->id)->get();
$products = Product::where('line_id', $employeesLines)->get();
$MRs = Employee::where('manager_id', \Auth::user()->id)->get();
$dataView = ['products' => $products, 'MRs' => $MRs];
return view('am.search.sales.search', $dataView);
}
public function update($id)
{
$territory = Territory::findOrFail($id);
$areas = Area::all();
$MRs = Employee::where('level_id', 7)->active()->get();
$dataView = ['territory' => $territory, 'areas' => $areas, 'MRs' => $MRs];
return view('admin.territory.edit', $dataView);
}
public function update($id)
{
$area = Area::findOrFail($id);
$AMs = Employee::where('level_id', 3)->active()->get();
$lines = Line::all();
$dataView = ['area' => $area, 'AMs' => $AMs, 'lines' => $lines];
return view('admin.area.edit', $dataView);
}
public function index()
{
$title = 'HOME';
$repository = $this->repository;
$employees = Employee::where('license_expire', '<', Carbon::now()->addDays(30))->orWhere('visa_expire', '<', Carbon::now()->addDays(30))->get();
$vehicles = Vehicles::where('registration_expire', '<', Carbon::now()->addDays(30))->get();
return view('pages.home', compact('title', 'employees', 'vehicles', 'repository'));
}
public function search()
{
$MRs = Employee::where('level_id', 7)->active()->get();
$AMs = Employee::where('level_id', 3)->active()->get();
$SMs = Employee::where('level_id', 2)->active()->get();
$dataView = ['MRs' => $MRs, 'AMs' => $AMs, 'SMs' => $SMs];
return view('admin.search.plans.search', $dataView);
}
public function listAll()
{
$employees = Employee::select('line_id')->where('manager_id', \Auth::user()->id)->get();
$products = Product::whereIn('line_id', $employees)->get();
$dataView = ['products' => $products];
return view('am.product.list', $dataView);
}
