Vfrdtyky

i have an excel file and i want to upload it and save data to database.

And data will be updated based on IC Number (Identity card).

If in excel file there are 4 IC are matched with IC from the database, it will count and there will be a notification if 4 data match and update to database.

The question is how to count matched ic from excel and database?
it always show zero (0)

  if($request->hasFile('file')){

        $extension = File::extension($request->file->getClientOriginalName());

        

        if ($extension == "xlsx" || $extension == "xls" || $extension == "csv") {

 

            $path = $request->file->getRealPath();

            $data = Excel::load($path, function($reader) {

            })->get();



            if(!empty($data) && $data->count()){

               

                foreach ($data as $value) {

                    $insert['data'] = [

                    'no'  => $value->no,

                    'name'  => $value->name,

                    'ic_no' => $value->ic_no,

                    'disburse_date' => $value->disburse_date,

                    'product_type_description' => $value->product_type_description,

                    'amount_release' => $value->amount_release,

                    'amount' => $value->amount,

                    'date_disburse' => $value->date_disburse,

                    'net_disbursement' => $value->net_disbursement,

                    ];

                

 

                if(!empty($insert))

                  {

                        $user = Auth::user()->id;



                          $request                  = new DisburseFromMbsb;



                            //$request->cus_id           = $data->id_cus;  

                            $request->ic_no               = $value['ic_no'];

                            $request->name               = $value['name'];

                            $request->disburse_date    = $value['disburse_date'];

                            $request->product_type_description    = $value['product_type_description'];

                            $request->amount_release   = $value['amount_release'];

                            $request->amount           = $value['amount'];

                            $request->date_disburse    = $value['date_disburse'];

                            $request->net_disbursement = $value['net_disbursement'];

                            $request->user_id           = $user;

                                

                            $request->save();*/



                             Loandisburse::where('ic', $value['ic_no'])->where('stage','W11')->where('status_upload',0)->update(array(

                                'status_upload'=>'1',

                                'amount_release' => $value['amount_release'],

                                'amount' => $value['amount'],

                                'date_disburse' => $value['date_disburse'], 

                                'net_disbursement' => $value['net_disbursement'],

                                'disburse_date' => $value['disburse_date'],

                                'product_type_description' => $value['product_type_description']



                            ));



                               

                    

$number = Loandisburse::where('ic', $value['ic_no'])->where('stage','W11')->where('status_upload',1)->count(); // this is my code to count

                        

                }

             

            }

             

             return redirect('/upload/amount')->with(['update' => 'Data saved successfully '.$number.'  rows' ]);

            }

 

this is my code to count

$number = Loandisburse::where('ic', $value['ic_no'])->where('stage','W11')->where('status_upload',1)->count();

Assuming all Code you wrote is correct (I have no idea how the Excel Package works ),
there are a few lines that need altering and you are good to go.

First you have to declare the variable number outside the scope of forEach
After that, instead of

$number = Loandisburse.......

You have to use

$number += Loandisburse.........

In order not to overwrite your previous values.

That means you have to try the following code:

if($request->hasFile('file')){

    $extension = File::extension($request->file->getClientOriginalName());



    $number = 0;

    if ($extension == "xlsx" || $extension == "xls" || $extension == "csv") {



        $path = $request->file->getRealPath();

        $data = Excel::load($path, function($reader) {

        })->get();



        if(!empty($data) && $data->count()){



            foreach ($data as $value) {

                $insert['data'] = [

                'no'  => $value->no,

                'name'  => $value->name,

                'ic_no' => $value->ic_no,

                'disburse_date' => $value->disburse_date,

                'product_type_description' => $value->product_type_description,

                'amount_release' => $value->amount_release,

                'amount' => $value->amount,

                'date_disburse' => $value->date_disburse,

                'net_disbursement' => $value->net_disbursement,

                ];





                if(!empty($insert)) {

                    $user = Auth::user()->id;



                    $request                  = new DisburseFromMbsb;  

                    $request->ic_no               = $value['ic_no'];

                    $request->name               = $value['name'];

                    $request->disburse_date    = $value['disburse_date'];

                    $request->product_type_description    = $value['product_type_description'];

                    $request->amount_release   = $value['amount_release'];

                    $request->amount           = $value['amount'];

                    $request->date_disburse    = $value['date_disburse'];

                    $request->net_disbursement = $value['net_disbursement'];

                    $request->user_id           = $user;



                    $request->save();



                    Loandisburse::where('ic', $value['ic_no'])

                                  ->where('stage','W11')

                                  ->where('status_upload',0)->update(array(

                                        'status_upload'=>'1',

                                        'amount_release' => $value['amount_release'],

                                        'amount' => $value['amount'],

                                        'date_disburse' => $value['date_disburse'], 

                                        'net_disbursement' => $value['net_disbursement'],

                                        'disburse_date' => $value['disburse_date'],

                                        'product_type_description' => $value['product_type_description']



                    ));

                    $number += Loandisburse::where('ic', $value['ic_no'])

                                            ->where('stage','W11')

                                            ->where('status_upload',1)

                                            ->count(); // this is my code to count     

                }//Closing If Not Empty

            }//Closing For Each

        }//Closing If

    }//Closing If

return redirect('/upload/amount')->with(['update' => 'Data saved successfully '.$number.'  rows' ]);

}//Closing If