无法从db获取行，laravel

lc8prwob  于 2021-07-27  发布在  Java
关注(0)|答案(1)|浏览(373)

我想设置从表中的一行到第二个表和其中的行的值。我开始用这个做控制器方法，因为我试图首先从视图中获取值：

  1. public function duplicate(Request $request, Proform $proform)
  2. {
  3.     var_dump($proform);
  4.     var_dump($proform->id);
  6.     $proform = DB::table('proforms')->where('id', $proform->id)->first();
  8.     var_dump($proform);
  9. }

我从视图和这条线上获取值（第一个）

  1. var_dump($proform);

我得到这个身份证：

  1. object(App\Proform)[1349]
  2.   protected 'fillable' => 
  3.     array (size=24)
  4.       0 => string 'proformnumber' (length=13)
  5.       1 => string 'proformdate' (length=11)
  6.       2 => string 'id' (length=2)
  7.       3 => string 'selldate' (length=8)
  8.       4 => string 'user_id' (length=7)
  9.       5 => string 'paymentmethod' (length=13)
  10.       6 => string 'paymentdate' (length=11)
  11.       7 => string 'status' (length=6)
  12.       8 => string 'comments' (length=8)
  13.       9 => string 'city' (length=4)
  14.       10 => string 'autonumber' (length=10)
  15.       11 => string 'automonth' (length=9)
  16.       12 => string 'autoyear' (length=8)
  17.       13 => string 'name' (length=4)
  18.       14 => string 'PKWIU' (length=5)
  19.       15 => string 'quantity' (length=8)
  20.       16 => string 'unit' (length=4)
  21.       17 => string 'netunit' (length=7)
  22.       18 => string 'nettotal' (length=8)
  23.       19 => string 'VATrate' (length=7)
  24.       20 => string 'grossunit' (length=9)
  25.       21 => string 'grosstotal' (length=10)
  26.       22 => string 'form_id' (length=7)
  27.       23 => string 'currency_id' (length=11)
  28.   public 'sortable' => 
  29.     array (size=13)
  30.       0 => string 'proformnumber' (length=13)
  31.       1 => string 'proformdate' (length=11)
  32.       2 => string 'id' (length=2)
  33.       3 => string 'selldate' (length=8)
  34.       4 => string 'user_id' (length=7)
  35.       5 => string 'paymentmethod' (length=13)
  36.       6 => string 'paymentdate' (length=11)
  37.       7 => string 'status' (length=6)
  38.       8 => string 'comments' (length=8)
  39.       9 => string 'grosstotal' (length=10)
  40.       10 => string 'nettotal' (length=8)
  41.       11 => string 'form_id' (length=7)
  42.       12 => string 'currency_id' (length=11)
  43.   protected 'connection' => null
  44.   protected 'table' => null
  45.   protected 'primaryKey' => string 'id' (length=2)
  46.   protected 'keyType' => string 'int' (length=3)
  47.   public 'incrementing' => boolean true
  48.   protected 'with' => 
  49.     array (size=0)
  50.       empty
  51.   protected 'withCount' => 
  52.     array (size=0)
  53.       empty
  54.   protected 'perPage' => int 15
  55.   public 'exists' => boolean false
  56.   public 'wasRecentlyCreated' => boolean false
  57.   protected 'attributes' => 
  58.     array (size=0)
  59.       empty
  60.   protected 'original' => 
  61.     array (size=0)
  62.       empty
  63.   protected 'changes' => 
  64.     array (size=0)
  65.       empty
  66.   protected 'casts' => 
  67.     array (size=0)
  68.       empty
  69.   protected 'classCastCache' => 
  70.     array (size=0)
  71.       empty
  72.   protected 'dates' => 
  73.     array (size=0)
  74.       empty
  75.   protected 'dateFormat' => null
  76.   protected 'appends' => 
  77.     array (size=0)
  78.       empty
  79.   protected 'dispatchesEvents' => 
  80.     array (size=0)
  81.       empty
  82.   protected 'observables' => 
  83.     array (size=0)
  84.       empty
  85.   protected 'relations' => 
  86.     array (size=0)
  87.       empty
  88.   protected 'touches' => 
  89.     array (size=0)
  90.       empty
  91.   public 'timestamps' => boolean true
  92.   protected 'hidden' => 
  93.     array (size=0)
  94.       empty
  95.   protected 'visible' => 
  96.     array (size=0)
  97.       empty
  98.   protected 'guarded' => 
  99.     array (size=1)
  100.       0 => string '*' (length=1)

但我不知道为什么我在这个（秒）上得到空值

  1. var_dump($proform->id);

之后呢

  1. $proform = DB::table('proforms')->where('id', $proform->id)->first();

此为空（第三个）

  1. var_dump($proform);
  3. /home/laravel/web/laravel.swt101.eu/public_html/abonamenty/app/Http/Controllers/ProformController.php:33:null
  4. /home/laravel/web/laravel.swt101.eu/public_html/abonamenty/app/Http/Controllers/ProformController.php:37:null

首先，我通过按“复制”按钮从该视图中获取值：

  1. @extends('layouts.app')
  3. @section('content')
  4.     <div class="row">
  5.         <div class="col-lg-12 margin-tb">
  6.             <div class="pull-left">
  7.                 <h2>Szczegóły abonamentu</h2>
  8.             </div>
  9.             <div class="pull-right">
  10.                 <a class="btn btn-primary" href="{{ route('proforms.index') }}"> Wstecz</a>
  11.             </div>
  12.         </div>
  13.     </div>
  15. <div class="col-md-4">
  16. <form action="/duplicate" method="get">
  17. <div class="input-group">
  18. <input type="button" value="$proform->id" name="duplicate" class="form-control">
  19. <span class="input-group-prepend">
  20. <button type="submit" class="btn btn-primary">Wystaw fakturę</button>
  21. </span>
  22. </div>
  23. </form>
  24. </div>   
  26.     <div class="row">
  27.         <div class="col-xs-12 col-sm-12 col-md-12">
  28.             <div class="form-group">
  29.                 <strong>Data wystawienia:</strong>
  30.                 {{ $proform->proformdate }}
  31.             </div>
  32.         </div>
  33.         <div class="col-xs-12 col-sm-12 col-md-12">
  34.             <div class="form-group">
  35.                 <strong>Kontrahent:</strong>
  36.                 {{ $proform->user_id }}
  37.             </div>
  38.         </div>
  39.        <div class="col-xs-12 col-sm-12 col-md-12">
  40.             <div class="form-group">
  41.                 <strong>Data sprzedaży:</strong>
  42.                 {{ $proform->selldate }}
  43.             </div>
  44.         </div>
  45.         <div class="col-xs-12 col-sm-12 col-md-12">
  46.             <div class="form-group">
  47.                 <strong>Termin płatności:</strong>
  48.                 {{ $proform->paymentdate }}
  49.             </div>
  50.         </div>
  51.                 <div class="col-xs-12 col-sm-12 col-md-12">
  52.             <div class="form-group">
  53.                 <strong>Forma płatności:</strong>
  54.                 {{ $proform->paymentmethod }}
  55.             </div>
  56.         </div>
  57.         <div class="col-xs-12 col-sm-12 col-md-12">
  58.             <div class="form-group">
  59.                 <strong>Miejsce wystawienia:</strong>
  60.                 {{ $proform->city }}
  61.             </div>
  62.         </div>
  63.         <div class="col-xs-12 col-sm-12 col-md-12">
  64.             <div class="form-group">
  65.                 <strong>Status:</strong>
  66.                 {{ $proform->status }}
  67.             </div>
  68.         </div>
  69.        <div class="col-xs-12 col-sm-12 col-md-12">
  70.             <div class="form-group">
  71.                 <strong>Uwagi:</strong>
  72.                 {{ $proform->comments }}
  73.             </div>
  74.         </div>
  75.             <div class="pull-left" style="margin: 15px;">
  76.                 <h3>Pozycje proformy</h3>
  77.             </div>
  78.         <div class="col-xs-12 col-sm-12 col-md-12">
  79.             <div class="form-group">
  80.                 <strong>Nazwa towaru lub usługi:</strong>
  81.                 {{ $proform->name }}
  82.             </div>
  83.         </div>
  84.         <div class="col-xs-12 col-sm-12 col-md-12">
  85.             <div class="form-group">
  86.                 <strong>PKWiU:</strong>
  87.                 {{ $proform->PKWIU }}
  88.             </div>
  89.         </div>
  90.        <div class="col-xs-12 col-sm-12 col-md-12">
  91.             <div class="form-group">
  92.                 <strong>Ilość:</strong>
  93.                 {{ $proform->quantity }}
  94.             </div>
  95.         </div>
  96.         <div class="col-xs-12 col-sm-12 col-md-12">
  97.             <div class="form-group">
  98.                 <strong>Jednostka:</strong>
  99.                 {{ $proform->unit }}
  100.             </div>
  101.         </div>
  102.                 <div class="col-xs-12 col-sm-12 col-md-12">
  103.             <div class="form-group">
  104.                 <strong>Cena netto jednostki:</strong>
  105.                 {{ $proform->netunit }}
  106.             </div>
  107.         </div>
  108.         <div class="col-xs-12 col-sm-12 col-md-12">
  109.             <div class="form-group">
  110.                 <strong>Netto razem:</strong>
  111.                 {{ $proform->nettotal }}
  112.             </div>
  113.         </div>
  114.        <div class="col-xs-12 col-sm-12 col-md-12">
  115.             <div class="form-group">
  116.                 <strong>Stawka VAT:</strong>
  117.                 {{ $proform->VATrate }}
  118.             </div>
  119.         </div>
  120.         <div class="col-xs-12 col-sm-12 col-md-12">
  121.             <div class="form-group">
  122.                 <strong>Brutto jednostka:</strong>
  123.                 {{ $proform->grossunit }}
  124.             </div>
  125.         </div>
  126.        <div class="col-xs-12 col-sm-12 col-md-12">
  127.             <div class="form-group">
  128.                 <strong>Brutto razem:</strong>
  129.                 {{ $proform->grosstotal }}
  130.             </div>
  131.         </div>
  133.     </div>
  134. @endsection
  135. <p class="text-center text-primary"><small>Artplus 2020</small></p>

这是我的路由器：

  1. ...
  2.     Route::get('/duplicate', 'ProformController@duplicate');
  3.   ...
sqlphplaraveleloquentorm

1条答案

按热度按时间
ujv3wf0j

ujv3wf0j1#

您的路由名称应该与要注入的模型的模型匹配。在这种情况下，路线应具有 proform 争论。在您的情况下，模型没有绑定，返回一个空的intance。
如果它是重复的@kurt说你的路线应该是这样的

  1. Route::get('/duplicate/{proform?}', 'ProformController@duplicate');

在这种情况下，它应该是可选的。
但我建议你像下面这样改变。为复制post创建post路由，并使用get路由显示表单

  1. Route::get('/duplicate/{proform}', 'ProformController@duplicateForm')->name('proforms.duplicateForm');
  2. Route::post('/duplicate', 'ProformController@duplicatePost')->name('proforms.duplicate');

控制器

  1. public function __construct(Proform $proform)
  2. {
  3.    $this->proform = $proform;
  4. }
  6. public function duplicateForm(Request $request, Proform $proform)
  7. {
  8.     return view('the form view here', ['proform' => $proform]);
  9. }
  11. public function duplicatePost(Request $request)
  12. {
  13.     $proform = $this->proform->findOrFail($request->duplicate);
  15.     //something like this
  16.     $duplicated = $this->proform->create($proform->toArray());
  18.     dump($duplicated);
  19. }

复制表单

  1. <div class="col-md-4">
  2. <form action="{{ route('proforms.duplicate') }}" method="POST">
  3. @csrf
  5. <div class="input-group">
  6. <input type="button" value="{{$proform->id}}" name="duplicate" class="form-control">
  7. <span class="input-group-prepend">
  8. <button type="submit" class="btn btn-primary">Wystaw fakturę</button>
  9. </span>
  10. </div>
  11. </form>
  12. </div>

此外，在laravel中，可以使用以下函数代替 var_dump() ```
dd() //die and dump, same as var_dump();exit;
dump() //dump, same as var_dump();

展开查看全部
赞(0）分享  回复(0）举报  2021-07-27
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com