public function __construct(UserService $userService)
{
$this->userService = $userService;
$this->loadRawQueryParams();
$this->query = $this->getRawQuery($this->getRawQueryParams());
$this->isRaw = true;
parent::__construct($this->userService);
}
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');
}