当前位置: 首页>>代码示例>>PHP>>正文


PHP Customer::leftJoin方法代码示例

本文整理汇总了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');
 }
开发者ID:jbs321,项目名称:affiliate-reporting-v1,代码行数:17,代码来源:CustomerReportService.php


注:本文中的app\models\Customer::leftJoin方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。