How to map data to fields in bacheInsert?

Question

Yii

public static  $columnsInsert =
        [
            'id',
            'customer_id',
            'summary',
            'description',
            'color',
            'favourite',
            'update_at',
            'create_at',
            'personEmail'
        ];


    $sql = $db->queryBuilder->batchInsert(self::$table, self::$columnsInsert, $data);

An array of strings comes to the server, the string contains the same keys as the base fields. But for some reason the data is not compared, do you really have to compare the fields with the orders in the rows in the request.

Answer 1

arrow_keys($data[0])

/* 
$data = [
0 => ['id' => ..., 'customer_id' => ...],
1 => ['id' => ..., 'customer_id' => ...]
...
]
*/
$sql = $db->queryBuilder->batchInsert(self::$table, arrow_keys($data[0]), $data);

Also, $data can be an array of models to insert, in which case arrow_keys($data[0]->attributes) should be written instead of arrow_keys($data[0]).