duanguilin2007 2019-06-23 01:56
浏览 270
已采纳

如何根据Laravel中的数据库值循环输入字段值并插入其行?

My problem is that I want to update the quantity_served based on quantity and insert the last loop value into the last record based on the input value.

Current Database record

For example, my input value has 180.

Expected Result

My code doesn't insert the last value of loop instead of the full value of quantity.

$var = $request->get('id');
$data = bulkcorporatemodel::orderBy('id', 'asc');

foreach ($data as $item)
{
    if ($var == 0 || $var < 0)
    {
        break;
    }

    $bulkcorp = bulkcorporatemodel::find($item->id);
    $dummyHolder = $bulkcorp->quantity;
    $bulkcorp->quantity_served = $dummyHolder;
    $bulkcorp->save();

    $success_output = '<div class="alert alert-success">BULK DATA UPDATED</div>';
    $var = $var - $dummyHolder;
} 
  • 写回答

1条回答 默认 最新

  • doudang1890 2019-06-23 05:02
    关注

    (edit: I noticed that $item is in fact already in your $data collection, there is no need to find the item, it's already there. I have adapted the code accordingly and shorten the code all together :) )

    $var = $request->get('id');
    $data = bulkcorporatemodel::orderBy('id', 'asc')->get();
    foreach ($data as $bulkcorp)
    {
        if ($var <= 0)
        {
            break;
        }
    
        $bulkcorp->update(
            ['quantity_served' => $bulkcorp->quantity]
        );
    
        $success_output = '<div class="alert alert-success">BULK DATA UPDATED</div>';
        $var = $var - $bulkcorp->quantity;
    }
    

    The keyword is update()

    The thing not clear to me is what the relationship between $var and $bulkcorp->quantity is. If the var is indeed an id, you will get under 0 in one cycle and the rest of the $data collection won't be executed. If $request->get('id') is a high number, no problem.

    But, this is what you really want to achieve. Normally, we should provide you this code, but ok, for once:

    $stock = $request->get('id');
    $data = bulkcorporatemodel::orderBy('id', 'asc')->get();
    foreach ($data as $bulkcorp)
    {
        if ($stock <= 0)
        {
            break;
        }
        $stock >= $bulkcorp->quantity ? $served = $bulkcorp->quantity : $served = $stock;
    
        $bulkcorp->update(
            ['quantity_served' => $served]
        );
    
        $success_output = '<div class="alert alert-success">BULK DATA UPDATED</div>';
        $stock = $stock - $bulkcorp->quantity;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 应用简单的Python代码完成一个学生成绩管理系统
  • ¥15 用matlab求微分方程初值问题
  • ¥15 vscode下编写第三方库opencv与pcl代码时没有代码提示
  • ¥15 能够跑通不报错,如何解决?(标签-matlab)
  • ¥15 MOS在RDS较大,频率高时开关波形异常
  • ¥15 SCENIC分析报错求解答
  • ¥15 ceph初始化mon不成功 下图不报错 这个是什么元
  • ¥15 数学建模数学建模少ai
  • ¥35 这个等效电路图是什么意思?(答疑)(有没有不是chat的,我就是在chat搜不到才来问的,chat还开了VIP)(可以追加酬金)
  • ¥200 基于同花顺supermind的量化策略脚本编辑