/** * 执行类型1:基金总体盈利 */ public static function saveType1() { $sql = "SELECT fund_num,SUM(rate+0) AS r FROM fund_history GROUP BY fund_num HAVING r>0"; $connection = \Yii::$app->db; $command = $connection->createCommand($sql); $posts = $command->queryAll(); $nums = ArrayHelper::getColumn($posts, 'fund_num'); FundFilter::saveFilter(self::TYPE_1, $nums); }