laravel分享一个根据主键进行批量更新的方法

有时候很需要一个能够实现批量更新的方法,但是laravel没有提供这样的实现,所以自己弄了一个,还是可以用的。

/**
   * 根据Id批量更新数据,可以放在model里面,使得每个model都是调用这个方法
   * @author yezi
   * @param array $multipleData
   * @return bool
   */

  public static function updateBatch($multipleData = array())
  {
    $tableName = \DB::getTablePrefix() . app(Contract::class)->getTable();
    if(!is_array($multipleData)){
      throw new CustomValidationException('must be an array',null,'6001');
    }
    foreach ($multipleData as &$row){

      if(!array_key_exists('id',$row)){

        throw new CustomValidationException('参数错误,缺少主键',null,'6001');

      }

      $row[Model::FIELD_UPDATED_AT] = Carbon::now();

    }

    if ($tableName && !empty($multipleData)) {

      $updateColumn  = array_keys($multipleData[0]);

      $referenceColumn = $updateColumn[0];

      unset($updateColumn[0]);

      $whereIn = "";

      $q = "UPDATE " . $tableName . " SET ";

      foreach ($updateColumn as $uColumn) {

        $q .= $uColumn . " = CASE ";

        foreach ($multipleData as $data) {

          $q .= "WHEN " . $referenceColumn . " = " . $data[$referenceColumn] . " THEN '" . $data[$uColumn] . "' ";

        }

        $q .= "ELSE " . $uColumn . " END, ";

      }

      foreach ($multipleData as $data) {

        $whereIn .= "'" . $data[$referenceColumn] . "', ";

      }

      $q = rtrim($q, ", ") . " WHERE " . $referenceColumn . " IN (" . rtrim($whereIn, ', ') . ")";

      return \DB::update(\DB::raw($q));

    } else {

      return false;

    }

  }
登录后进行讨论

vinshaw

vinshaw 发表于 2019-04-15 16:58:48

坦白说,很有用,正好最近有程序用到这个。

点赞 0