protected function checkRankReferred($appId, $local) { $rankList = ShopRank::whereRaw("appid=:appid", array(":appid" => $appId))->get(); $rankCategory = array(); foreach ($rankList as $v) { if ($v instanceof ShopRank) { $rankCategory[] = $v->categoryId(); } } $categoryList = ShopRankCategory::whereRaw("categoryid in (:categoryid)", array(":categoryid" => implode(",", $rankCategory)))->get(); $locals = array(); foreach ($categoryList as $v) { if ($v instanceof ShopRankCategory) { $locals[] = $v->local(); } } if (in_array($local, $locals)) { throw new DeepInException("排行榜里面提交引用到该应用~!"); } }