<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/2/9
 * Time: 11:13
 */

namespace App\Repositories\Backend\CouponOrder;

use App\Modules\Repositories\CouponOrder\BaseCouponOrderRepository;
class CouponOrderRepository    extends BaseCouponOrderRepository
{
    public function getForDataTable()
    {
        return $this->query()->get();
    }


    public function getinfo()
    {
      return   $this->query()->select('coupon_order.id','coupon_order.status', 'coupon_order.expire_time', 'coupon_type.type','coupon_type.discount','coupon_type.discount_money' ,'coupon_type.reason','spot.spotname','business.business_name', 'customers.nick_name')
        ->leftjoin('spot','coupon_order.spot_id','=','spot.id')
        ->leftjoin('business','coupon_order.business_id','=','business.id')
        ->leftjoin('customers', 'customers.id', '=', 'coupon_order.customer_id')
        ->leftjoin('coupon_type','coupon_order.coupon_type_id','=','coupon_type.id')
        ->get(); 
    }
}