本文整理匯總了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');
}