DB_app/app/Http/Controllers/PostsController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class PostsController extends Controller
{
    public function get_emp_inf(){
        $emp = new \App\Empoyees_inf;
        $employee = $emp::all();
        
    	return view('posts.index', ['employee'=>$employee]);
    }

    public function get_products(){
        $prod = new \App\Products;
        $products = $prod::all();
    	return view('posts.prod', ['products'=>$products]);
    }
    public function formemp()
    {
        return view('posts.daily');
    }
    public function addprod()
    {
        return view('posts.products');
    }
    public function ind(Request $request)
    {
        $emp = new \App\Empoyees_inf;
        $emp->second_name=$request->second_name;
        $emp->first_name=$request->first_name;
        $emp->last_name=$request->last_name;
        $emp->phone=$request->phone;
        $emp->address=$request->address;
        $emp->dbirth=$request->dbirth;
        $emp->position=$request->position;
        $emp->save();
        $employee = $emp::all();
        return view('posts.index', ['employee'=>$employee]);
    }
    public function pro(Request $request)
    {
        $prod = new \App\Products;
        $prod->product=$request->product;
        $prod->price=$request->price;
        $prod->automobile=$request->automobile;
        $prod->in_stock=$request->in_stock;
        $prod->save();
        $products = $prod::all();
        return view('posts.prod', ['products'=>$products]);
    }

    public function sp()
    {
        // $sp = new \App\Sold_products;
        $sps = \App\Sold_products::all();
        foreach ($sps as $sp) {
            $array[$sp['id']] = array(
                'id' => $sp['id'],
                'product' => $sp->products['product'],
                'employee' => $sp->empoyees_infs['second_name'],
                'customer' => $sp['customer'],
                'count' => $sp['amount']
            );
        }
        
    	return view('posts.sold')->with(['sps'=>$array]);
    }
    public function duties()
    {
        // $sp = new \App\Sold_products;
        // $sps = \App\Sold_products::all();
        // foreach ($sps as $sp) {
        //     $array[$sp['id']] = array(
        //         'id' => $sp['id'],
        //         'product' => $sp->products['product'],
        //         'employee' => $sp->empoyees_infs['second_name'],
        //         'customer' => $sp['customer'],
        //         'count' => $sp['amount']
        //     );
        // }
        
            $employees = \App\Empoyees_inf::all();
            foreach ($employees as $emp) {
                $array[$emp['id']] = array(
                    'name' => $emp['second_name'],
                    'duty' => $emp->duties
                );
            }

    	return view('posts.duties')->with(['duties'=>$array]);
    }

}