$ret = self::$db->select($tables, $fields, $where, $bind); if (!empty($ret)) { $retIds = array(); $ids = array(); while (!empty($ret)) { $_sub = array_splice($ret, 0, 10000); //每次取出10000个 foreach ($_sub as $v) { array_push($retIds, $v['pt_AccountKey']); } unset($_sub); /*过滤非快速登陆类型*/ $place_holders = implode(',', array_fill(0, count($retIds), '?')); array_unshift($retIds, 'autoregs'); $PT_Account = self::$db->select('PT_Account', 'pt_AccountKey', 'pt_RegisteSource=? AND pt_AccountKey IN (' . $place_holders . ')', $retIds); if (!empty($PT_Account)) { array_push($ids, $v['pt_AccountKey']); } } unset($ret); if (!empty($ids)) { $num = count($ids); $_sub = array_splice($ids, $get['start'], $get['limit']); $place_holders = implode(',', array_fill(0, count($_sub), '?')); $where = 'pt_AccountKey IN (' . $place_holders . ')'; $list = self::$db->select('PT_Account', 'pt_AccountID,pt_Password', $where, $_sub); $grid = array(); $grid['rows'] = $list; $grid['total'] = $num; return $grid; } }