本文整理汇总了PHP中app\models\Customer::leftJoin方法的典型用法代码示例。如果您正苦于以下问题：PHP Customer::leftJoin方法的具体用法？PHP Customer::leftJoin怎么用？PHP Customer::leftJoin使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类app\models\Customer的用法示例。
在下文中一共展示了Customer::leftJoin方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: __construct
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');
}