Im implementing bulk insert cakephp data is been successfully inserted to database table
however i cannot get the last inserted id
$po_data[] = [
'product_id' => $product_id,
'crm_purchase_order_id' => $po_id,
'price' => $price,
'qty' => $quantity,
'crm_quotation_product_id' => $query->id,
'admin_id' => $admin_id,
'additional' => 0, // 0 since it is not an additional quotation
'created_at' => date('Y-m-d H:i:s')
];
//bulk insert
$poProducts = TableRegistry::get('CrmPoProducts');
$poentities = $poProducts->newEntities($po_data);
$poResult = $this->CrmPoProducts->saveMany($poentities, array('atomic' => false));
if( $poResult ){
$last_po_product_id = $poResult->id; //this is where the error came from
$pom_data[] = [
'crm_quotation_id' => $query->crm_quotation_id,
'crm_purchase_order_id' => $po_id,
'crm_purchase_order_product_id' => $last_po_product_id,
'qty' => $quantity,
'created_at' => date('Y-m-d H:i:s')
];
$pom = TableRegistry::get('CrmPurchaseOrderMonitorings');
$pomentities = $pom->newEntities($pom_data);
$resultInsert = $this->CrmPurchaseOrderMonitorings->saveMany($pomentities, array('atomic' => false));