Ejemplo n.º 1
0
 /**
  * 执行类型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);
 }