Blame | Letzte Änderung | Log anzeigen | RSS feed
<?php// Dateiname: $URL: http://server2/svn/content-management/trunk/Warenwirtschaft/statistik_detail.php $// Revision: $Rev: 3931 $// letzter Bearbeiter: $Author: tiefland $// letztes Bearbeitungsdatum: $Date: 2011-09-16 10:17:57 +0200 (Fr, 16 Sep 2011) $$s_ind = 0;//Gesamtdaten auslesen$b_ges = get_anz_bestellungen( $start, $ende, $filter["shopID"], 0, $filter["bestellart"] );$b_ges_v = get_anz_bestellungen( $start_v, $ende_v, $filter["shopID"], 0, $filter["bestellart"] );$u_ges = get_umsatz( $start, $ende, $filter["shopID"], 0, $filter["bestellart"] );$u_ges_v = get_umsatz( $start_v, $ende_v, $filter["shopID"], 0, $filter["bestellart"] );$b_ges_p = number_format( $b_ges, 0, ',', '.' );$b_ges_v_p = number_format( $b_ges_v, 0, ',', '.' );$u_ges_p = number_format( $u_ges, 2, ',', '.' );$u_ges_v_p = number_format( $u_ges_v, 2, ',', '.' );$daten[0] = array( "b_ges" => $b_ges_p, "b_ges_v" => $b_ges_v_p, "u_ges" =>$u_ges_p, "u_ges_v" => $u_ges_v_p, "timeframe" => $time_frame, );foreach ( $shops as $shop ){//Daten je Shop auslesen$b_anz = get_anz_bestellungen( $start, $ende, $shop["ID"], 0, $filter["bestellart"] );$b_anz_v = get_anz_bestellungen( $start_v, $ende_v, $shop["ID"], 0, $filter["bestellart"] );$umsatz = get_umsatz( $start, $ende, $shop["ID"], 0, $filter["bestellart"] );$umsatz_v = get_umsatz( $start_v, $ende_v, $shop["ID"], 0, $filter["bestellart"] );$u_ges_s[$shop["ID"]] = $umsatz;$u_ges_s_v[$shop["ID"]] = $umsatz_v;//Daten aufbereiten$umsatz_p = number_format( $umsatz, 2, ',', '.' );$umsatz_v_p = number_format( $umsatz_v, 2, ',', '.' );$u_ges_p = number_format( $u_ges, 2, ',', '.' );$u_ges_v_p = number_format( $u_ges_v, 2, ',', '.' );$b_anz_p = number_format( $b_anz, 0, ',', '.' );$b_anz_v_p = number_format( $b_anz_v, 0, ',', '.' );$b_ges_p = number_format( $b_ges, 0, ',', '.' );$b_ges_v_p = number_format( $b_ges_v, 0, ',', '.' );//Daten zwischenspeichernif ( $umsatz || $umsatz_v ){$shopdaten[$s_ind][$c_year]["gesamt"]["b_anz"] = $b_anz_p;$shopdaten[$s_ind][$c_year]["gesamt"]["ges_b_anz"] = $b_ges_p;$shopdaten[$s_ind][$c_year]["gesamt"]["umsatz"] = $umsatz_p;$shopdaten[$s_ind][$c_year]["gesamt"]["ges_umsatz"] = $u_ges_p;$shopdaten[$s_ind][$p_year]["gesamt"]["b_anz"] = $b_anz_v_p;$shopdaten[$s_ind][$p_year]["gesamt"]["ges_b_anz"] = $b_ges_v_p;$shopdaten[$s_ind][$p_year]["gesamt"]["umsatz"] = $umsatz_v_p;$shopdaten[$s_ind][$p_year]["gesamt"]["ges_umsatz"] = $u_ges_v_p;$s_ind++;}}//Daten zusammenführen//Detailanzeige für Tage des Montas / der Woche$z_ind = 0;for ( $dat = $start; $dat < $ende; $dat += 86400 ){//Daten für jeden einzelnen Tag beschaffen$s_ind = 0;$start_c = $dat;$ende_c = strtotime( "1 day", $dat );$ende_v = strtotime( "1 day", $start_v );$date = ( WEEK ) ? strftime( "%a", $dat ) : strftime( "%d.%m.", $dat );$c_day = ( WEEK ) ? strftime( "%d.%m.", $dat ) : strftime( "%a", $dat );$v_day = ( WEEK ) ? strftime( "%d.%m.", $start_v ) : strftime( "%a", $start_v );$b_ges = get_anz_bestellungen( $start_c, $ende_c, $filter["shopID"], 0, $filter["bestellart"] );$b_ges_v = get_anz_bestellungen( $start_v, $ende_v, $filter["shopID"], 0, $filter["bestellart"] );$u_ges = get_umsatz( $start_c, $ende_c, $filter["shopID"], 0, $filter["bestellart"] );$u_ges_v = get_umsatz( $start_v, $ende_v, $filter["shopID"], 0, $filter["bestellart"] );$start_c7 = $start_c;$ende_c7 = strtotime( "-7 days", $start_c7 );$start_v7 = $start_v;$ende_v7 = strtotime( "-7 days", $start_v7 );$umsatz_ges_c7 = get_umsatz( $ende_c7, $start_c7, $filter["shopID"], 0, $filter["bestellart"] );$umsatz_ges_v7 = get_umsatz( $ende_v7, $start_v7, $filter["shopID"], 0, $filter["bestellart"] );$b_anz_ges_c7 = get_anz_bestellungen( $ende_c7, $start_c7, $filter["shopID"],0, $filter["bestellart"] );$b_anz_ges_v7 = get_anz_bestellungen( $ende_v7, $start_v7, $filter["shopID"],0, $filter["bestellart"] );if ( $b_anz_ges_c7 ){$quot_c7_b_ges = round( $b_ges / ($b_anz_ges_c7 / 7), 1 );}else{$qout_c7_b_ges = 0;}if ( $b_anz_ges_v7 ){$quot_v7_b_ges = round( $b_ges_v / ($b_anz_ges_v7 / 7), 1 );}else{$qout_v7_b_ges = 0;}if ( $umsatz_ges_c7 > 0.00 ){// $res_c7 = $umsatz_c7 /7;$quot_c7_ges = round( $u_ges / ($umsatz_ges_c7 / 7), 1 );}else{$quot_c7_ges = 0.0;}if ( $umsatz_ges_v7 > 0.00 ){// $res_v7 = $umsatz_v7 /7;$quot_v7_ges = round( $u_ges_v / ($umsatz_ges_v7 / 7), 1 );}else{$quot_v7_ges = 0.0;}if ( $quot_c7_ges >= 0.6 ){$class_c_ges = "gruen";} elseif ( $quot_c7_ges >= 0.4 and $quot_c7_ges < 0.6 ){$class_c_ges = "gelb";} elseif ( $quot_c7_ges >= 0.0 and $quot_c7_ges < 0.4 ){$class_c_ges = "rot";}if ( $quot_v7_ges >= 0.6 ){$class_v_ges = "gruen";} elseif ( $quot_v7_ges >= 0.4 and $quot_v7_ges < 0.6 ){$class_v_ges = "gelb";} elseif ( $quot_v7_ges >= 0.0 and $quot_v7_ges < 0.4 ){$class_v_ges = "rot";}if ( $quot_c7_b_ges >= 0.6 ){$class_c_b_ges = "gruen";} elseif ( $quot_c7_b_ges >= 0.4 and $quot_c7_b_ges < 0.6 ){$class_c_b_ges = "gelb";} elseif ( $quot_c7_ges >= 0.0 and $quot_c7_ges < 0.4 ){$class_c_b_ges = "rot";}if ( $quot_v7_b_ges >= 0.6 ){$class_v_b_ges = "gruen";} elseif ( $quot_v7_b_ges >= 0.4 and $quot_v7_b_ges < 0.6 ){$class_v_b_ges = "gelb";} elseif ( $quot_v7_b_ges >= 0.0 and $quot_v7_b_ges < 0.4 ){$class_v_b_ges = "rot";}foreach ( $shops as $shop ){//Daten für jeden Shop bestimmen$b_anz = get_anz_bestellungen( $start_c, $ende_c, $shop["ID"], 0, $filter["bestellart"] );$b_anz_v = get_anz_bestellungen( $start_v, $ende_v, $shop["ID"], 0, $filter["bestellart"] );$umsatz = get_umsatz( $start_c, $ende_c, $shop["ID"], 0, $filter["bestellart"] );$umsatz_v = get_umsatz( $start_v, $ende_v, $shop["ID"], 0, $filter["bestellart"] );$umsatz_c7 = get_umsatz( $ende_c7, $start_c7, $shop["ID"], 0, $filter["bestellart"] );$umsatz_v7 = get_umsatz( $ende_v7, $start_v7, $shop["ID"], 0, $filter["bestellart"] );$b_anz_c7 = get_anz_bestellungen( $ende_c7, $start_c7, $shop["ID"], 0, $filter["bestellart"] );$b_anz_v7 = get_anz_bestellungen( $ende_v7, $start_v7, $shop["ID"], 0, $filter["bestellart"] );if ( $b_anz_c7 ){$quot_c7_b = round( $b_anz / ($b_anz_c7 / 7), 1 );}else{$qout_c7_b = 0;}if ( $b_anz_v7 ){$quot_v7_b = round( $b_anz_v / ($b_anz_v7 / 7), 1 );}else{$qout_v7_b = 0;}if ( $umsatz_c7 > 0.00 ){// $res_c7 = $umsatz_c7 /7;$quot_c7 = round( $umsatz / ($umsatz_c7 / 7), 1 );}else{$quot_c7 = 0.0;}if ( $umsatz_v7 > 0.00 ){// $res_v7 = $umsatz_v7 /7;$quot_v7 = round( $umsatz_v / ($umsatz_v7 / 7), 1 );}else{$quot_v7 = 0.0;}if ( $quot_c7 >= 0.6 ){$class_c = "gruen";} elseif ( $quot_c7 >= 0.4 and $quot_c7 < 0.6 ){$class_c = "gelb";} elseif ( $quot_c7 >= 0.0 and $quot_c7 < 0.4 ){$class_c = "rot";}if ( $quot_v7 >= 0.6 ){$class_v = "gruen";} elseif ( $quot_v7 >= 0.4 and $quot_v7 < 0.6 ){$class_v = "gelb";} elseif ( $quot_v7 >= 0.0 and $quot_v7 < 0.4 ){$class_v = "rot";}if ( $quot_c7_b >= 0.6 ){$class_c_b = "gruen";} elseif ( $quot_c7_b >= 0.4 and $quot_c7_b < 0.6 ){$class_c_b = "gelb";} elseif ( $quot_c7_b >= 0.0 and $quot_c7_b < 0.4 ){$class_c_b = "rot";}if ( $quot_v7_b >= 0.6 ){$class_v_b = "gruen";} elseif ( $quot_v7_b >= 0.4 and $quot_v7_b < 0.6 ){$class_v_b = "gelb";} elseif ( $quot_v7_b >= 0.0 and $quot_v7_b < 0.4 ){$class_v_b = "rot";}//Daten aufbereiten$umsatz_p = number_format( $umsatz, 2, ',', '.' );$umsatz_v_p = number_format( $umsatz_v, 2, ',', '.' );$u_ges_p = number_format( $u_ges, 2, ',', '.' );$u_ges_v_p = number_format( $u_ges_v, 2, ',', '.' );$b_anz_p = number_format( $b_anz, 0, ',', '.' );$b_anz_v_p = number_format( $b_anz_v, 0, ',', '.' );//Daten zwischenspeichernif ( $u_ges_s[$shop["ID"]] || $u_ges_s_v[$shop["ID"]] ){$shops_dat[$s_ind++] = array( "umsatz" => $umsatz_p, "umsatz_v" => $umsatz_v_p,"b_anz" => $b_anz_p, "b_anz_v" => $b_anz_v_p, "class_c" => $class_c,"class_v" => $class_v, "class_c_b" => $class_c_b, "class_v_b" => $class_v_b, );}}$start_v += 86400;//Daten zusammenführen$zahlen_tag[$z_ind++] = array( "b_ges" => $b_ges, "b_ges_v" => $b_ges_v,"u_ges" => $u_ges_p, "u_ges_v" => $u_ges_v_p, "timeframe" => $date, "shops" =>$shops_dat, "class_c" => $class_c_ges, "class_c_b" => $class_c_b_ges,"class_v" => $class_v_ges, "class_v_b" => $class_v_b_ges, "c_dat" => $c_day,"v_dat" => $v_day, );//exit;}$daten["shops"] = $shopdaten;//Daten an Smarty übergeben$GLOBALS["ui"]->assign( "c_year", $c_year );$GLOBALS["ui"]->assign( "p_year", $p_year );$GLOBALS["ui"]->assign( "d_type", (WEEK) ? "Tag" : "Datum" );$GLOBALS["ui"]->assign( "daten", $daten );$GLOBALS["ui"]->assign( "zahlen_tag", $zahlen_tag );$GLOBALS["ui"]->assign( "shops", $shops );//Daten darstellen$GLOBALS["ui"]->assign( "file", "statistik-v2.tpl" );?>