Keskustelu: Nettisivujen teko: php Palkan laskeminen työpäivästä

include "db.php";

$query = $handler->query('SELECT * FROM lisat');
$r = $query->fetch();

$TP = $r['TUNTIPALKKA'];	// TUNTIPALKKA
$YL = $r['YO_LISA'];		// YÖLISÄ, KERROIN
$IL = $r['IL_LISA'];		// ILTALISÄ, KERROIN
$LL = $r['LA_LISA'];		// LAUANTAILISÄ, KERROIN
$SL = $r['SU_LISA'];		// SUNNUNTAILISÄ, KERROIN
$PK = $r['NOLLAKERROIN'];	// PERUSKERROIN, KERROIN LISÄTTÖMILLE TUNNEILLE
$LI = $TP*$LL+$TP*$IL;		// LAUANTAIILTA TUNTI
$LY = $TP*$LL+$TP*$YL;		// LAUANTAIYÖ TUNTI
$SI = $TP*$SL+$TP*$IL;		// SUNNUNTAIILTA TUNTI
$SY = $TP*$SL+$TP*$YL;		// SUNNUNTAIYÖ TUNTI


$lisa=array(
  array("KLO","00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23"),
  array("ARK",$YL,$YL,$YL,$YL,$YL,$YL,$YL,$PK,$PK,$PK,$PK,$PK,$PK,$PK,$PK,$PK,$IL,$IL,$IL,$IL,$IL,$YL,$YL,$YL),
  array("LA",$LY,$LY,$LY,$LY,$LY,$LY,$LY,$LL,$LL,$LL,$LL,$LL,$LL,$LL,$LL,$LL,$LI,$LI,$LI,$LI,$LI,$LY,$LY,$LY),
  array("SU",$SY,$SY,$SY,$SY,$SY,$SY,$SY,$SL,$SL,$SL,$SL,$SL,$SL,$SL,$SL,$SL,$SI,$SI,$SI,$SI,$SI,$SY,$SY,$SY)
  );