Row Ordering on importation

[bob2609-dev]

first of all, great work with this one, makes life a whole lot easier.
i have one question, whenever i import more than one row to the database, the rows are reflected in reverse order and i am not sure why.

please assist.

notice the change in order of the rows

[patrickbrouwers]

Seems correct to me as your db is sorted desc and excel asc. (Looking at the 26, 25 column)

[patrickbrouwers]

So 25, 26, 27 are not the primary keys?

[patrickbrouwers]

If you are really sure they are in reverse order, please show more of your code.

[bob2609-dev]

@patrickbrouwers , something must be up with my database the select statement wasn't right.
normally it would order by primary key in ascending order. it is not until i forced the order to be ascending that i got the expected results.
thank you for noticing

[bob2609-dev]

If you are really sure they are in reverse order, please show more of your code.

this is the code just for reference as requested

Imports

<?php

namespace App\Imports;

//use App\GroupMember;
use App\Models\GroupMember;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class GroupMembersImport implements ToModel, WithHeadingRow
{
    /**
     * @param array $row
     *
     * @return GroupMember
     */
    public function model(array $row)
    {
        return new GroupMember([

                                   'member_id'              => $row['member_id'],
                                   'first_name'             => $row['first_name'],
                                   'middle_name'            => $row['middle_name'],
                                   'last_name'              => $row['last_name'],
                                   'email_address'          => $row['email_address'],
                                   'mobile_number'          => $row['mobile_number'],
                                   'account_number'         => $row['account_number'],
                                   'date_joined'            => $row['date_joined'],
                                   'membership_status'      => $row['membership_status'],
                                   'organization'           => $row['organization'],
                                   'physical_address'       => $row['physical_address'],
                                   'postcode'               => $row['postcode'],
                                   'district'               => $row['district'],
                                   'region'                 => $row['region'],
                                   'primary_phone_number'   => $row['primary_phone_number'],
                                   'secondary_phone_number' => $row['secondary_phone_number'],
                                   'group_name'             => $row['group_name'],
                                   'gender'                 => $row['gender']

                               ]);
    }
}

Controller

/**
     * Upload the specified file to database.
     *
     *
     * @param \Illuminate\Http\Request $request
     *
     * @return \Illuminate\Http\Response
     *
     *
     */

    public function members_upload(Request $request)
    {


        $members_file = $request->file('members_file');

        Excel::import(new GroupMembersImport(),$members_file);

        return redirect('/member');


    }

[bob2609-dev]

This is where my confusion began