"
."| ".$count." | "
." | "
."".$orderselection['product_name']." | "
."".$orderselection['description']." | "
."".$orderselection['packaging_quantity']." | "
."".$orderselection['packaging_type']." | "
."".getPOItem($orderselection['po_item_id'],"subtotal")." | "
."
";
$count++;
}
return $table;
});
$app->post('/custom-declarations/add-custom-declaration', function (Request $request) {
global $db;
$user_id = $_SESSION['user_id'];
$company_id = $_SESSION['company_id'];
$so_id = $request->get('so_id');
$ref_no = $request->get('ref_no');
$exporter_name = $request->get('exporter_name');
$custom_declaration_items = $request->get('custom_declaration_items');
$db->bind("user_id", $user_id);
$db->bind("company_id", $company_id);
$db->bind("so_id", $so_id);
$db->bind("ref_no", $ref_no);
$db->bind("exporter_name", $exporter_name);
$customdeclarationCreate = $db->query("INSERT INTO `custom_declarations`(`ref_no`, `exporter_name`, `so_id`, `user_id`, `company_id`) VALUES (:ref_no,:exporter_name,:so_id,:user_id,:company_id)");
$custom_declaration_id = $db->lastInsertId();
if($customdeclarationCreate){
foreach ($custom_declaration_items as $key => $custom_declaration_item) {
$db->bind("hs_code", $custom_declaration_item['hs_code']);
$db->bind("so_item_id", $custom_declaration_item['so_item_id']);
$db->bind("custom_declaration_id", $custom_declaration_id);
$custom_declaration_itemsCreate = $db->query("INSERT INTO custom_declaration_items (hs_code, so_item_id, custom_declaration_id) VALUES (:hs_code, :so_item_id, :custom_declaration_id);");
}
}
if($custom_declaration_itemsCreate){
return new Response("SUCCESS", 200);
}else {
return new Response('FAILED', 201);
}
});
}
include 'declaration.func.php';