Save multidimensional array using Laravel and ajax

Question

I am building a pharmacy management system. I have a condition where I need to build a section

As shown in the picture, I need to store the data where the upper three should be same for all of the rows inputted below. The form data is submitted as in the below picture.

But the data when looped and saved is not being saved as desired. Only the last row of the data is being inserted and I am also confused to store supplier, purchase date and note since these data should be repeated as many as the number of rows are added.

PurchaseController.php

public function storePurchase(PurchaseStoreRequest $request)
{
   
    $purchase = new Purchase();

    $count = count($request->name);

    // return response()->json($request->all());

    for ($i = 0; $i < $count; $i++) {

        $purchase->supplier = $request->supplier;
        $purchase->purchase_date =  $request->purchase_date;
        $purchase->description = $request->description;

        $purchase->category = $request->category[$i];
        $purchase->name = $request->name[$i];
        $purchase->generic_name = $request->generic_name[$i];
        $purchase->batch_number = $request->batch_number[$i];
        $purchase->company = $request->company[$i];
        $purchase->strength = $request->strength[$i];
        $purchase->expiry_date = $request->expiry_date[$i];
        $purchase->quantity = $request->quantity[$i];
        $purchase->selling_price = $request->selling_price[$i];
        $purchase->purchase_price = $request->purchase_price[$i];

        $purchase->save();

    }

    return response()->json(['message'  =>  'Purchase Saved Successfully']);
}

Can someone help me to store these three fields in the database repeating the number of rows submitted ? Currently only the last row is being inserted into the database.

$purchase = new Purchase(); write this line inside the loop, you did it outside. Thats whay only last low inserted. Anyway, its will $purchase = new Purchase; — STA
– STA, Commented Oct 24, 2020 at 5:16

Ozan Kurt · Accepted Answer · 2020-10-24 06:13:19Z

1

This might be an another way to accomplish what you're looking for.

$sharedKeys = ['supplier', 'purchase_date', 'description'];
$sharedData = $request->only($sharedKeys);

$multiKeys = ['category', 'name', 'generic_name', 'batch_number', 'company', 'strength', 'expiry_date', 'quantity', 'selling_price', 'purchase_price'];
$multiData = $request->only($multiKeys);

for ($i = 0; $i < count($request->name); $i++) {
    $individualData = array_combine($multiKeys, array_column($multiData, $i));

    Purchase::create($sharedData + $individualData);
}

answered Oct 24, 2020 at 6:13

Ozan Kurt

3,8634 gold badges22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kaushik · Accepted Answer · 2020-10-26 12:42:19Z

0

For every loop, you need to create a new instance, then It will create a new record on each loop :

public function storePurchase(PurchaseStoreRequest $request)
{
    // $purchase = new Purchase();

    $count = count($request->name);

    // return response()->json($request->all());
    for ($i = 0; $i < $count; $i++) {
        $purchase = new Purchase();  // create new instance end with (); on each loop
        $purchase->supplier = $request->supplier;
        $purchase->purchase_date =  $request->purchase_date;
        $purchase->description = $request->description;
        $purchase->category = $request->category[$i];
        $purchase->name = $request->name[$i];
        $purchase->generic_name = $request->generic_name[$i];
        $purchase->batch_number = $request->batch_number[$i];
        $purchase->company = $request->company[$i];
        $purchase->strength = $request->strength[$i];
        $purchase->expiry_date = $request->expiry_date[$i];
        $purchase->quantity = $request->quantity[$i];
        $purchase->selling_price = $request->selling_price[$i];
        $purchase->purchase_price = $request->purchase_price[$i];
        $purchase->save();
    }
    return response()->json(['message' => 'Purchase Saved Successfully']);
}

edited Oct 26, 2020 at 12:42

kaushik

9337 silver badges16 bronze badges

answered Oct 24, 2020 at 5:23

STA

35.3k9 gold badges49 silver badges62 bronze badges

3 Comments

Meeraj Adhikari Over a year ago

Thank you for your response. I was wondering why the data was not submitted. And just pushing that line inside did the trick.

Meeraj Adhikari Over a year ago

Can you share me any idea to store total of the purchase without having another table to do so? I mean total of every rows (Quantity * CP)

STA Over a year ago

Do you want to store Quantity * CP on another table?

Collectives™ on Stack Overflow

Save multidimensional array using Laravel and ajax

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related