public function __construct(UserService $userService) { $this->userService = $userService; $this->url = route('customer-api'); $this->query = Customer::leftJoin('country', 'customers.Country', '=', 'country.id')->leftJoin('campaigns', 'campaigns.id', '=', 'customers.campaignId')->selectSub('SELECT sum(amountUSD) FROM customer_deposits WHERE customerId = customers.id AND paymentMethod <> "Bonus" ', 'sumAmountUSD'); // ->leftJoin('(SELECT sum(amountUSD) FROM customer_deposits cs WHERE cs.paymentMethod<>"Bonus") as sumAmountUSD' , 'customers.id','=','sumAmountUSD.customerId') // ->selectSub('SELECT sum(amountUSD) FROM customer_deposits WHERE customerId = customers.id AND paymentMethod <> "Bonus" ','sumAmountUSD') // ->selectSub('SELECT sum(amountUSD) FROM `customer_deposits` WHERE `customerId` = `customers`.`id` AND `customer_deposits`.`paymentMethod` <> "Bonus" ','sumAmountUSD') // $this->query = Customer // ::leftJoin('country', 'customers.Country', '=','country.id' ) // ->leftJoin('customer_balance', 'customers.id', '=','customer_balance.customerId' ) // ->leftJoin('campaigns', 'campaigns.id', '=','customers.campaignId' ); $this->customNavButtons = array('exportCsv'); parent::__construct($this->userService); $this->grid->setSortName('id'); $this->grid->setSortOrder('DESC'); }