session_start(); if ($user <> "") { $_SESSION['username'] = $user; } function schoenertag($datum) { return strftime('%d.%m.%g', strtotime($datum)); } function schoenezeit($datum) { return strftime('%R', strtotime($datum)); } $username = $_SESSION['username']; $page = $_SERVER[ 'SCRIPT_NAME' ] ; $page = explode("/", $page); $kat = $page[2]; $page = $page[3]; include("includes/_config_mysqli.php"); //mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $con); if($action == "pausieren") { $update_pause = mysqli_query($mysqli_vvw,"update vvw_master set pause = '1' where vvw_master_id = '$vvw_master_id' "); } if($action == "aktivieren") { $update_pause = mysqli_query($mysqli_vvw,"update vvw_master set pause = '0' where vvw_master_id = '$vvw_master_id' "); } if($action == "markasread") { $datetime = date("Y-m-d H:i:s"); foreach($vvw_info_ids AS $vvw_info ) { $update = mysqli_query($mysqli_vvw,"update vvw_infos set gelesen = '$datetime' where vvw_infos_id = '$vvw_info' "); } } if($action == "loeschen") { $datetime = date("Y-m-d H:i:s"); foreach($vvw_info_ids AS $vvw_info ) { $update = mysqli_query($mysqli_vvw,"delete from vvw_infos where vvw_infos_id = '$vvw_info' "); } } $select_mme = mysqli_query($mysqli_mm,"select * from bestellungen where status = 'geldeingang'"); $count_mme = mysqli_num_rows($select_mme); $select_alle = mysqli_query($mysqli_mm,"select * from bestellungen where lieferung_per = 'Selbstabholung' and status != 'verschickt' and status != 'storniert' and geldeingang!='0000-00-00 00:00:00'"); $count_abholer = mysqli_num_rows($select_alle); $select_alle = mysqli_query($mysqli_mm,"select * from bestellungen where lieferung_per = 'Selbstabholung' and zahlart = 'Barzahlung' and status != 'storniert' and status != 'verschickt'"); $count_abholerunpaid = mysqli_num_rows($select_alle); $count_mme_abholer = $count_abholer+$count_abholerunpaid; ?>