1,//代理商状态 1正常 2关闭 'm.status' => 1,//商户状态 1正常 2禁用 3删除 's.store_status' => 0,//门店行业状态 0正常 1关闭 's.state' => 0,//门店状态 0正常 1删除 's.store_class' => 2,//账号类型：1直营 2加盟 'f.account_type' => 1,//账号类型：1加盟商 2商户 ); $storeList = $this->alias('f') ->join('ls_retail_store as s on s.id=f.store_id') ->join('ls_retail_merchant as m on m.id=s.merchantid') ->join('ls_retail_agent as a on a.id=m.agentid') ->where($map) ->field('f.store_id,f.merchant_id,f.rate,f.type,f.add_time') ->select(); return $storeList; } }