<?php
require __DIR__.'/common.php';
$joined=$q('SELECT a.menu_date,a.number,a.weight,b.raw_flag,b.raw_flag_weight,b.ssb,d.food_weight,e.edible_part,e.protein,e.cooking_food FROM ydy_date_menu a LEFT JOIN ydy_dishes b ON a.dishes_uuid=b.uuid LEFT JOIN ydy_dish d ON d.dishes_uuid=b.uuid LEFT JOIN ydy_foods_composition e ON e.id=d.composition_id WHERE a.staff_uuid=? ORDER BY a.id',[$u]);
$save('numeric-zero-diagnostic.json',['lane'=>$lane,'joined'=>$joined,'PHP_empty_decimal_string'=>empty('0.00'),'PHP_empty_float_zero'=>empty(0.0),'proposed_zero_check_string'=>(float)'0.00'===0.0,'original_ssb_sum'=>0,'proposed_ssb_sum'=>100/1,'proposed_weight'=>array_sum(array_map(static function($r){return $r['weight']*$r['number']*100/(100/1)*100/100;},$joined)),'expected_protein'=>array_sum(array_map(static function($r){return $r['weight']*$r['food_weight']/(100/1)*$r['edible_part']/100*$r['protein']/100*$r['number'];},$joined)),'HTTP'=>0,'DML'=>0,'DDL'=>0]);$save('numeric-zero-diagnostic-oracle.json',$GLOBALS['NR_ORACLE']);echo json_encode(['lane'=>$lane,'diagnostic_rows'=>count($joined),'HTTP'=>0,'DML'=>0,'DDL'=>0]),"\n";