Laravel 5 集合问题：不等于的地方

Laravel 5 collection issue: Where not equal to

提问by Justin Boxem

I am currently working on a modal where a user can insert an excel file. The task of the system is to upload and/or add a new database record if the records are new or identical to what exists in the database. BUT it also needs a delete function for getting rid of those records where the slug column is not identical to the name column.

我目前正在研究一种用户可以插入 excel 文件的模式。如果记录是新的或与数据库中存在的记录相同，则系统的任务是上传和/或添加新的数据库记录。但是它还需要一个删除函数来删除那些 slug 列与 name 列不同的记录。

At the moment I am using Laravel 5.3, and this is my controlleras it is now:

目前我正在使用Laravel 5.3，这是我现在的控制器：

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Product;
use App\Http\Requests;
use Illuminate\Support\Facades\DB;
use Input;
use Maatwebsite\Excel\Facades\Excel;

class ProductsController extends Controller {

public function importExcel(Request $request) {
    if (Input::hasFile('productFile')) {
        $path = Input::file('productFile')->getRealPath();
        $checkbox = Input::get('productCheckbox');
        $data = Excel::load($path, function($reader) {
        })->get();

        if (!empty($data) && $data->count()) {
            foreach ($data as $key => $value) {
                $product = Product::all()->where('slug', $value->slug)->first();
                $product_false = Product::all()->where('slug', '!=' , 'name')->get();

                if ($product_false !== null){
                    //delete row if slug does not matches name
                    dd($product_false);
                }

The dd above returns all products, so the collection query is not working properly (see below for the raw SQL that I am trying to run in this collection)

上面的 dd 返回所有产品，因此集合查询无法正常工作（有关我尝试在此集合中运行的原始 SQL，请参见下文）

                if ($product !== null) {
                    //update row if exist
                    $product->name = $value->name;
                    $product->description = $value->description;
                    $product->price = $value->price;
                    $product->save();
                } else {
                    //add new row if not exist
                    $product = new Product;
                    $product->slug = $value->slug;
                    $product->name = $value->name;
                    $product->description = $value->description;
                    $product->price = $value->price;
                    $product->save();
                }

            }
            header("Location: /products");
        }
    }
}

}

This is the Product model:

这是产品型号：

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model
{

/**
 * The attributes that are mass assignable.
 *
 * @var array
 */
protected $fillable = [
    'slug', 'name', 'description', 'price',
];
}

Here is the PHPMyAdmin raw SQL (which works) that I basically am looking for to use in the collection:

这是我基本上希望在集合中使用的 PHPMyAdmin 原始 SQL（有效）：

SELECT * FROM `products` WHERE `slug` != `name`

I hope someone can help me out from this pit. I have been sailing the waves of the internet for about 12 hours now just to get this done.

希望有人能帮我走出这个坑。为了完成这件事，我已经在互联网的浪潮中航行了大约 12 个小时。

~ nitsuJ

〜尼苏J

采纳答案by Justin Boxem

I managed to solveit.

我设法解决了它。

$data = Excel::load($path, function($reader) {

            $importedSlugs = $data->select(array('slug'))->toArray();
                    //collection of imported slugs
                    $collectionOfImportedSlugs = collect($importedSlugs)->flatten()->all();

                    //get all product slugs
                    $productSlugs = Product::all()->pluck('slug');

                    //get all different slugs!
                    $diffSlugsArray = $productSlugs->diff($collectionOfImportedSlugs)->all();
                    //dd($diffSlugsArray);

                    foreach ($diffSlugsArray as $diffSlug) {
                        $product_false = Product::all()->where('slug',     $diffSlug)->first();

                        echo $product_false->slug . 'has been deleted!';

                        $product_false->delete();
                    }
        })->get();

回答by Liam

Change

改变

$product = Product::all()->where('slug', $value->slug)->first();
$product_false = Product::all()->where('slug', '!=' , 'name')->get();

Into

进入

$product = Product::where('slug', $value->slug)->first();
$product_false = Product::where('slug', '!=' , 'name')->get();

回答by f_i

Collections, eloquent and query builder are not the same. Collection provide a bunch of methods to work on arrays, rather then on the database or model.

集合、eloquent 和查询构建器是不一样的。集合提供了一系列处理数组的方法，而不是处理数据库或模型。

In collection context whereNot()is not available.

在集合上下文whereNot()中不可用。

but the same function can be achieved through whereNotIn('key', [value])

但同样的功能可以通过 whereNotIn('key', [value])

collect([
    [
      'name' => 'foo',
      'rank' => 2
    ],[
      'name' => 'bar',
      'rank' => 3
    ],[
      'name' => 'foobar',
      'rank' => 4
    ],
 ])->whereNotIn('rank', [4])

same as where rank not in (4)

与...一样 where rank not in (4)

回答by linuxartisan

Try this

尝试这个

$product = Product::where('slug', $value->slug)->first();
$product_false = Product::whereRaw('slug != name')->get();

Simple wherewon't work as it compares products.slugwith "name"(string).

与(string)where相比products.slug，Simple不起作用"name"。