Beiträge von Michaela

$data['html'] = '
                    <table cellpadding="0" cellspacing="0">
                        <tr style="background-color:#EEEEEE;">
                            <td>Pos.</td>
                            <td>Artikel</td>
                            <td>Art.Nr.</td>
                            <td>Menge</td>
                            <td style="text-align:right;">Preis</td>
                            <td style="text-align:right;">Summe</td>
                        </tr>'.
                        $eintrag = wbb($mysqli, $userSessionID);
                        foreach($eintrag  as $array_wbk){.'




                        <tr>
                            <td style="text-align:right;">1</td>
                            <td>Bezeichnug</td>
                            <td>Nummer</td>
                            <td style="text-align:center;">1</td>
                            <td style="text-align:right;">9,02 Euro</td>
                            <td style="text-align:right;">9,02 Euro</td>
                        </tr>
                        '.}.'
                </body>
            </html>';

function tmp_TestAusgabe($mysqli, $UserCode, $datum) {

		$stmt = $mysqli->prepare("SELECT kd_id, kd_code, kd_userID, kd_status, kd_datum, kd_uhrzeit 
									FROM kunden
									WHERE kd_userID =?
									AND kd_datum =? ");

		$stmt->bind_param("ss", $UserCode, $datum);
		$stmt->execute();
		$stmt->bind_result($kd_id, $kd_code, $kd_userID, $kd_status, $kd_datum, $kd_uhrzeit);
		$stmt->store_result();

		if($stmt->num_rows() >  0) {     
			while ($stmt->fetch()){
				$tmp_TestAusgabe[] = array( 
					'kd_id' 		=> $kd_id, 
					'kd_code' 		=> $kd_code, 
					'kd_userID' 	=> $kd_userID,
					'kd_status' 	=> $kd_status, 
					'kd_datum' 	=> $kd_datum, 
					'kd_uhrzeit'	=> $kd_uhrzeit
				);
			}
			return $tmp_TestAusgabe;
			}
	}

$UserCode 	= "49d7bd088c3e5dca8a6f0a6cff2e556b";
$datum 		= "2015-12-15";




$tmp_TestAusgabe = tmp_TestAusgabe($mysqli, $UserCode, $datum);

	if($tmp_TestAusgabe > 0) {
		foreach($tmp_TestAusgabe as $array){ 
			$Datum = explode("-", $array['kd_datum']);

			if ($array['kd_status'] == 0) {
	        	$KundenStatus= str_replace ("0", "Aktiv", $array['kd_status']);
	      	}

	      	if ($array['kd_status'] == 1) {
	        	$KundenStatus= str_replace ("1", "Gesperrt", $array['kd_status']);
	      	}
?>
			<p><?php echo htmlspecialchars($Datum[2] .".".$Datum[1].".".$Datum[0]);?> - <?php echo htmlspecialchars($array['kd_uhrzeit']); ?> - Kd.Nr.: <?php echo htmlspecialchars($array['kd_id']); ?> - Status: <?php echo htmlspecialchars($KundenStatus); ?></p>
<?php } 
}
else { echo "<p>Keine Daten vorhanden</p>"; }

function tmp_TestAusgabe($mysqli, $UserCode, $datum) {

		$stmt = $mysqli->prepare("SELECT kd_id, kd_code, kd_userID, kd_status, kd_datum, kd_uhrzeit 
									FROM kunden
									WHERE kd_userID =?
									AND kd_datum =? ");

		$stmt->bind_param("ss", $UserCode, $datum);
		$stmt->execute();
		$stmt->bind_result($kd_id, $kd_code, $kd_userID, $kd_status, $kd_datum, $kd_uhrzeit);
		$stmt->store_result();

		if($stmt->num_rows() >  0) {     
			while ($stmt->fetch()){
				$tmp_TestAusgabe[] = array( 
					'kd_id' 		=> $kd_id, 
					'kd_code' 		=> $kd_code, 
					'kd_userID' 	=> $kd_userID,
					'kd_status' 	=> $kd_status, 
					'kd_datum' 		=> $kd_datum, 
					'kd_uhrzeit'	=> $kd_uhrzeit
				);
			}
			return $tmp_TestAusgabe;
			}
	}







function ErinnerungenUpdate($mysqli, $UserCode, $datum) {

		$stmt = $mysqli->prepare("SELECT ke_id, ke_userCode, ke_Kdnr, ke_update_d, ke_update_u, kd_id, kd_code, kd_firma
									FROM kundenerinnerungen
									LEFT JOIN web_kunden ON web_kunden.kd_code = web_kundenerinnerungen.ke_Kdnr
									WHERE ke_userCode =?
									AND ke_update_d =? ");

		$stmt->bind_param("ss", $UserCode, $datum);
		$stmt->execute();
		$stmt->bind_result($ke_id, $ke_userCode, $ke_Kdnr, $ke_update_d, $ke_update_u, $kd_id, $kd_code, $kd_firma);
		$stmt->store_result();

		if($stmt->num_rows() >  0) {     
			while ($stmt->fetch()){
				$ErinnerungenUpdate[] = array( 
					'ke_id' 		=> $ke_id, 
					'ke_userCode' 	=> $ke_userCode, 
					'ke_Kdnr' 		=> $ke_Kdnr,
					'ke_update_d' 	=> $ke_update_d, 
					'ke_update_u' 	=> $ke_update_u, 
					'kd_id'			=> $kd_id,
					'kd_code' 		=> $kd_code, 
					'kd_firma' 		=> $kd_firma, 
				);
			}
			return $ErinnerungenUpdate;
			}
	}




function NeueErinnerungen($mysqli, $UserCode, $datum) {

		$stmt = $mysqli->prepare("SELECT ke_id, ke_userCode, ke_Kdnr, ke_eingetragen_d, ke_eingetragen_u, kd_id, kd_code, kd_firma
									FROM kundenerinnerungen
									LEFT JOIN web_kunden ON web_kunden.kd_code = web_kundenerinnerungen.ke_Kdnr
									WHERE ke_userCode =?
									AND ke_eingetragen_d =? ");

		$stmt->bind_param("ss", $UserCode, $datum);
		$stmt->execute();
		$stmt->bind_result($ke_id, $ke_userCode, $ke_Kdnr, $ke_eingetragen_d, $ke_eingetragen_u, $kd_id, $kd_code, $kd_firma);
		$stmt->store_result();

		if($stmt->num_rows() >  0) {     
			while ($stmt->fetch()){
				$NeueErinnerungen[] = array( 
					'ke_id' 			=> $ke_id, 
					'ke_userCode' 		=> $ke_userCode, 
					'ke_Kdnr' 			=> $ke_Kdnr,
					'ke_eingetragen_d' 	=> $ke_eingetragen_d, 
					'ke_eingetragen_u' 	=> $ke_eingetragen_u, 
					'kd_id'				=> $kd_id,
					'kd_code' 			=> $kd_code, 
					'kd_firma' 			=> $kd_firma, 
				);
			}
			return $NeueErinnerungen;
			}
	}