Hello,
This is my code in "after record added" from "reception" table. Query, Update and Insert not working in popup page.They work fine if I use the normal page (not popup).
Version 10.91 build 41242
Thank you,
$reception_id = $values['reception_id'];
$date = $values['date'];
// Fetch reception details
$rsReception = DB::Query("SELECT product_id, qty FROM reception_detail WHERE reception_id = $reception_id");
while ($dataReception = $rsReception->fetchAssoc()) {
$product_id = $dataReception["product_id"];
$qty = $dataReception["qty"];
// Fetch purchase order details for the given product
$rsPurchaseOrder = DB::Query("SELECT purchase_order_detail_id, qty AS qty_purchase
FROM purchase_order_detail
WHERE product_id = $product_id");
while ($dataPurchaseOrder = $rsPurchaseOrder->fetchAssoc()) {
$purchase_order_detail_id = $dataPurchaseOrder["purchase_order_detail_id"];
$qty_purchase = $dataPurchaseOrder["qty_purchase"];
if ($qty >= $qty_purchase) {
$dataUpdate["purchase_order_status_id"] = 2; // Received
} elseif ($qty < $qty_purchase and $qty > 0) {
$dataUpdate["purchase_order_status_id"] = 3; // Partially Received
} else {
$dataUpdate["purchase_order_status_id"] = 1; // Pending
}
$keyValuesUpdate["purchase_order_detail_id"] = $purchase_order_detail_id;
DB::Update("purchase_order_detail", $dataUpdate, $keyValuesUpdate);
// Insert into movement
$dataMovement = array(
"date" => "'".$date."'", // Enclosing in quotes for SQL
"product_id" => $product_id,
"qty" => $qty,
"movement_type_id" => 2, // Reception
"sector_id" => 1,
"origin_id" => $reception_id
);
// Insert into movement
DB::Insert("movement", $dataMovement);
}
}