118 lines
No EOL
4.3 KiB
PHP
118 lines
No EOL
4.3 KiB
PHP
<?php
|
|
|
|
error_reporting(E_ALL); ini_set('display_errors',0);
|
|
// echo "<pre>"; print_r($tarifi); echo "</pre>";
|
|
$tagp = strtotime("+0 day");
|
|
$tag = date("d",$tagp);
|
|
$monat = date("m",$tagp);
|
|
$jahr = date("Y",$tagp);
|
|
$datum=$tag.".".$monat.".".$jahr;
|
|
|
|
|
|
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
|
|
$tarifi = $GLOBALS['mysql']->query_single("SELECT * FROM tariftyp WHERE id='".$fahrer['tarifgtyp']."'");
|
|
|
|
|
|
|
|
|
|
|
|
//-----------------------
|
|
//--------------- Lohn
|
|
//-----------------------
|
|
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
|
|
$tarifi = $GLOBALS['mysql']->query_single("SELECT * FROM tariftyp WHERE id='".$fahrer['tarifgtyp']."'");
|
|
//-------- Grundlohn
|
|
if ($fahrer['einmonat']==$_GET['monat'] && $fahrer['einjahr']==$_GET['jahr']) {
|
|
$gtage=27-$fahrer['eintag']; $glohn=($fahrer['tarifg']/26); $glohn=$glohn*$gtage; $glohn=round($glohn,0);
|
|
//$glohn
|
|
} else {
|
|
$glohn=$fahrer['tarifg'];
|
|
}
|
|
$template->assign('grundgehalt', $glohn);
|
|
//----------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
//------------- Zählerausrechnung
|
|
$zz=0;
|
|
$temp2 = $GLOBALS['mysql']->query("SELECT * FROM tourentyp");
|
|
while($row = $temp2->fetch_assoc()) {
|
|
$tl=$GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9");
|
|
if($tl['num_rows']>0) { $tmpl=0;
|
|
$ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 ORDER BY tag");
|
|
while($rowl = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$rowl['tarif']; } $glohn=$glohn+$tmpl; $zz++;
|
|
$tml[$zz]['a']=$row['tname'];
|
|
$tml[$zz]['b']=$tl['num_rows']." Touren";
|
|
$tml[$zz]['c']=number_format($tmpl, 2, '.', '')." EUR";
|
|
}
|
|
$tl=$GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp=9");
|
|
if($tl['num_rows']>0) { $tmpl=0;
|
|
$ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp=9 ORDER BY tag");
|
|
while($rowl = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$rowl['tarif']; } $glohn=$glohn+$tmpl; $zz++;
|
|
$tml[$zz]['a']=$row['tname']." -Abn.";
|
|
$tml[$zz]['b']=$tl['num_rows']." Touren";
|
|
$tml[$zz]['c']=number_format($tmpl, 2, ',', '')." EUR";
|
|
}
|
|
}
|
|
$zb=1;
|
|
$template->assign('tml', $tml);
|
|
//----------------------------------------------
|
|
|
|
|
|
//----------------------------------------------
|
|
//$pdf->Cell(70,5,("Zwischenumme: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','1','R','0');
|
|
|
|
//lohnabzug
|
|
$ma_minus = $GLOBALS['mysql']->query_single("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
|
|
if($ma_minus['num_rows']>0) { $zv=0;
|
|
$temp8 = $GLOBALS['mysql']->query("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
|
|
while($row = $temp8->fetch_assoc()) {
|
|
$temp8[$zv]['a']=$row['summe'];
|
|
$temp8[$zv]['b']=$row['grund'];
|
|
$minuslohn=number_format($row['summe'], 2, ',', ''); // 2 nachkommastellen
|
|
$glohn=$glohn-$minuslohn;
|
|
}
|
|
$template->assign('temp8', $temp8);
|
|
|
|
|
|
$glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen
|
|
}
|
|
// $glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen
|
|
/*
|
|
if($tarifi['netto']>0) {
|
|
$pdf->Cell(70,5,("NETTO-Summe: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
|
|
} else {
|
|
$pdf->Cell(70,5,("Brutto-Summe: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
|
|
}
|
|
|
|
$pdf->Cell(10,4,(" "),'0','0','R','0'); $za++;
|
|
$pdf->Cell(10,4,(" "),'0','0','R','0');
|
|
$pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
|
|
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
|
|
$pdf->Output('Lohnvorschlag_'.($fahrer['name']).'.pdf','I');
|
|
|
|
|
|
*/
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$template->assign('datum', $datum);
|
|
$template->assign('kal', $maf1);
|
|
$template->assign('content', 'tpl/ajax/lohnausfall.tpl');
|
|
?>
|