>[info] 循環每次查詢指定數據集（yii2） ~~~ $salesPerformOrderBindId = 0;// 銷售訂單綁定id while (true) { // 根據時間區域獲取企業主體訂單 $enterpriseEntityOrder = SalesPerformOrderBindDao::getEnterpriseEntityOrderByTime($startTime, $endTime, $salesId, $salesPerformOrderBindId); if (empty($enterpriseEntityOrder)) { break; } foreach ($enterpriseEntityOrder as $key => $value) { // 如果用戶關聯企業免押優先取數 if (!empty($value['user_id'])) { $enterpriseEntityOrderCount++; } // 如果用戶不在關聯企業免押 并且 該訂單存在補充企業關聯的資料 取數 if (empty($value['user_id']) && !empty($value['extra_info_order_id'])) { $enterpriseEntityOrderCount++; } } $salesPerformOrderBindId = $value['id']; } ~~~ ~~~ public static function getEnterpriseEntityOrderByTime($startTime, $endTime, $salesId, $id, $limit = 300) { $data = (new Query())->select(' b.id, b.sales_id, b.sales_name, o.order_id as v2_order_id, i.order_id as extra_info_order_id, smd.user_id, ')->from('sales_perform_order_bind b') ->leftJoin(V3OrderDao::tableName().' o', 'b.order_id = o.order_id') ->leftJoin('server_minus_deposit smd', 'o.user_id = smd.user_id') ->leftJoin('sales_order_extra_info i', 'b.order_id = i.order_id') ->andWhere(['between', 'b.pay_at', $startTime, $endTime]) ->andWhere(['b.sales_id' => $salesId]) ->andWhere(['>', 'b.id', $id]) ->orderBy('b.id ASC') ->limit($limit) ->all() ?? []; return $data; } ~~~