$kate = sprintf('%.2f', 100 * ($row["rivihinta"] * -1 - $ostohinta) / $row["rivihinta"]) . "%"; } else { $kate = "100.00%"; } $kate_eur = $row["rivihinta"] * -1 - $ostohinta; $kate_yht += $kate_eur; } else { $kate = "N/A"; } } elseif ($kukarow['extranet'] == '') { if ($row["rivihinta"] != 0) { $kate = sprintf('%.2f', 100 * ($row["rivihinta"] - kehahin($row["tuoteno"]) * ($row["varattu"] + $row["jt"] + $row['määrä'])) / $row["rivihinta"]) . "%"; } elseif (kehahin($row["tuoteno"]) != 0) { $kate = "-100.00%"; } $kate_eur = $row["rivihinta"] - kehahin($row["tuoteno"]) * ($row["varattu"] + $row["jt"] + $row['määrä']); $kate_yht += $kate_eur; } $row[$i] = $kate; $worksheet->writeNumber($excelrivi, $excelsarake, $kate_eur, $format_num); echo "<{$ero} align='right' valign='top' nowrap {$class}>" . sprintf("%.2f", $kate_eur) . "</{$ero}>"; echo "<{$ero} align='right' valign='top' nowrap {$class}>{$kate}</{$ero}>"; } $excelsarake++; } elseif (mysql_field_name($result, $i) == 'hinta' or mysql_field_name($result, $i) == 'rivihinta') { echo "<{$ero} valign='top' align='right' nowrap {$class}>" . sprintf("%.2f", $row[$i]) . "</{$ero}>"; } else { echo "<{$ero} valign='top' {$class}>{$row[$i]}</td>"; } if (is_numeric($row[$i]) and mysql_field_name($result, $i) != 'ytunnus') { $worksheet->writeNumber($excelrivi, $excelsarake, $row[$i]);
if ($nayta_rivit_row["tyyppi"] != "V" and $nayta_rivit_row["tuoteno"] != $yhtiorow["ennakkomaksu_tuotenumero"]) { $kate_yht += $nayta_rivit_row["rivihinta"] * -1 - $ostohinta; } } else { $kate = "N/A"; } } elseif ($kukarow['extranet'] == '') { if ($nayta_rivit_row["tyyppi"] == "V") { $kate = ""; } elseif ($nayta_rivit_row["rivihinta"] != 0) { $kate = sprintf('%.2f', 100 * ($nayta_rivit_row["rivihinta"] - kehahin($nayta_rivit_row["tuoteno"]) * ($nayta_rivit_row["varattu"] + $nayta_rivit_row["jt"] + $nayta_rivit_row['kpl'])) / $row["rivihinta"]) . "%"; } elseif (kehahin($nayta_rivit_row["tuoteno"]) != 0) { $kate = "-100.00%"; } if ($nayta_rivit_row["tyyppi"] != "V" and $nayta_rivit_row["tuoteno"] != $yhtiorow["ennakkomaksu_tuotenumero"]) { $kate_yht += $nayta_rivit_row["rivihinta"] - kehahin($nayta_rivit_row["tuoteno"]) * ($nayta_rivit_row["varattu"] + $nayta_rivit_row["jt"] + $nayta_rivit_row['kpl']); } } echo "<td align='right' valign='top' nowrap>{$kate}</td>"; } if ($nayta_rivit_row["alv"] >= 600) { echo "<td align='right' valign='top' nowrap>", t("K.V."), "</td>"; } elseif ($nayta_rivit_row["alv"] >= 500) { echo "<td align='right' valign='top' nowrap>", t("M.V."), "</td>"; } else { echo "<td align='right' valign='top' nowrap>", $nayta_rivit_row["alv"] * 1, "</td>"; } $chk = (!isset($valitse_rivit) or in_array($nayta_rivit_row['tunnus'], $valitse_rivit)) ? "checked" : ""; echo "<td><input class='{$row['tilaus']}' type='checkbox' name='valitse_rivit[{$row['tilaus']}][]' value='{$nayta_rivit_row['tunnus']}' {$chk} /></td>"; echo "</tr>"; }