mysql - larval ORM 模型使用find方法無法準確的查找到對應的數據

問題描述

mysql 數據表主鍵Order_ID為bigint(20),使用Order模型查找對應的訂單卻找到了其他的訂單。比如：Order:find(20170214006401)，卻查找到Order_ID為20161009000577的訂單.調用代碼如下：<?php$rsOrder = Order::find(20170214006401)->first()->toArray();?>

Order模型如下<?phpuse IlluminateDatabaseEloquentSoftDeletes;

class Order extends IlluminateDatabaseEloquentModel {

use SoftDeletes;protected $dates = [’deleted_at’];//protected $fillable = [’Order_Status’];protected $fillable = array(’Order_Status’,’Is_withdraw’,’Withdraw_Time’);protected $primaryKey = 'Order_ID';protected $table = 'user_order';public $timestamps = false;// 多wherepublic function scopeMultiwhere($query, $arr) { if (!is_array($arr)) {return $query; } foreach ($arr as $key => $value) {$query = $query->where($key, $value); } return $query;}

//無需日期轉換

public function getDates() { return array();}/** * 指定時間內的訂單 * @param $Users_ID 店鋪唯一標識 * @param $Begin_Time 開始時間 * @param $End_Time 結束時間 * @return array 訂單列表 */public function ordersBetween($Users_ID, $Begin_Time, $End_Time, $Order_Status) { $builder = $this::where(’Users_ID’, $Users_ID); if ($Order_Status != ’all’) {$builder = $builder->where(’Order_Status’, $Order_Status); }$builder->whereBetween(’Order_CreateTime’, [$Begin_Time, $End_Time])->orderBy(’Order_CreateTime’, ’desc’); return $builder;}

}

問題解答

代碼來自:/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php

public function find($id, $columns = [’*’]) {return $this->where(’id’, ’=’, $id)->first($columns); }

find方法好像默認為id為主鍵進行查找的

find方法默認搜索的是主鍵