我正在尝试使用选择选项更改订单状态。数据表的第一行工作正常。但是当更改二阶状态时,它不起作用。
选择选项代码:
<select name="status" id="status">status
<option value="Order Placed">{{$assign->status}}</option>
<option value="On Way">On Way...</option>
<option value="Delivered">Delivered...</option>
<option value="Cancelled">Cancelled...</option>
<input type="hidden" id="order_id" value="{{ $assign->order->id }}" name="order_id">
</select>
jQuery代码:
$(document).ready(function () {
$('#table_id').on('change','select',function() {
var status = $('#status').val();
var order_id = $('#order_id').val();
alert(status);
$.ajax({
type: "get",url: "{{ url ('/admin/abc')}}",data: {status: status,order_id: order_id},dataType: "JSON",success: function (response) {
$('.alert').show();
$('.alert').html(result.success);
}
});
});
});
Route.php:
Route::get('/admin/abc','AdminController@abc')->name('assign.abc');
控制器代码:
public function abc(Request $req){
DB::table('assigns')->WHERE('id',$req->order_id)->update(['status' => $req->status]);
}
}