$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>";
}
