Items Details

Budget Details

0) { while ($row_utilized = @mysqli_fetch_assoc($result_utilized)) { $net_value= (float)$row_utilized['item_rate']; error_log('net_value'.$net_value); $qty= (float)$row_utilized['unit']; error_log('qty'.$qty); $indent_qty= (float)$row_utilized['indent_qty']; if( $qty!=0){ $item_price = (float)($net_value/$qty); $utilized+= (float)($item_price*$indent_qty); error_log('indent item :'.$row['item_id'].' unit price :'.$item_price.' current utilized budget :'.$utilized); }} } $utilized=round($utilized,2); //---------------------- $query_required = "SELECT a.item_id ,a.indent_qty,c.item_rate,c.unit FROM `indent_items`a LEFT JOIN indent_master b on a.`indent_id`=b.indent_id left join item_rate c on c.item_id=a.item_id where a.indent_id='".$_REQUEST['indent_id']."' "; error_log("'indent_id: ".$query_required); if (!$result_required = @mysqli_query($conn,$query_required)) { exit(mysqli_error($conn)); } $required=0; if(mysqli_num_rows($result_required) > 0) { while ($row_required = @mysqli_fetch_assoc($result_required)) { $net_value_required= (float)$row_required['item_rate']; // error_log('net_value_required'.$net_value_required); $qty_required= (float)$row_required['unit']; // error_log('qty_required'.$qty_required); $indent_qty_required= (float)$row_required['indent_qty']; // error_log('$indent_qty_required'.$indent_qty_required); if( $qty_required!=0){ $item_price_required = (float)($net_value_required/$qty_required); $required+= (float)($item_price_required*$indent_qty_required); error_log('indent item _required:'.$row_required['item_id'].' unit price _required:'.$item_price_required.' current _required budget :'.$required); }} } $required=round($required,2); // $required=400000000; //----------------- $yearly_budget=0; $sql_yearly = "SELECT sum(total_budget) as yearly_budget FROM yearly_budget where year ='" . $year . "'"; error_log('$sql_yearly'.$sql_yearly) ; $result_yearly = mysqli_query($conn, $sql_yearly); // $num_rows = @mysqli_num_rows($result_yearly); while ($row_yearly = @mysqli_fetch_array($result_yearly)) { $yearly_budget=$row_yearly['yearly_budget']; } $yearly_budget=round($yearly_budget,2); ?>

Yearly Budget	Utilized Budget	Available Budget	Total Indent Budgrt
			$yearly_budget-$utilized) echo 'style="background-color:#ff0000a6"' ?> id="child_item_unit">