<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/3/13
 * Time: 17:22
 */

namespace App\Repositories\Backend\ManageRent;

use App\Access\Model\User\User;
use App\Modules\Repositories\ManageRent\BaseManageRentRepository;
class ManageRentRepository      extends BaseManageRentRepository
{

    public function getinfo()
    {
        $user_id = session()->get('login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d');
        $res =User::find($user_id)->toArray();
        $business_id = $res['business_id'];
        return $this->query()->select('rent.id','rent.rent_no', 'rent.real_total','rent.add_time','rent.rent_type' ,'production.return_time','spot.spotname','machine.mac_no','customers.phone','production.is_return')

            ->leftjoin('spot','rent.spot_id','=','spot.id')
            ->leftjoin('machine','rent.machine_id','=','machine.id')
            ->leftjoin('production','rent.id','=','production.rent_id')
            ->leftjoin('customers', 'rent.customer_id', '=', 'customers.id')
            ->where('rent.business_id',$business_id)
            ->get();
    }
    
}