MIS-PROEJCT กำลังปรับปรุงการแสดงผลข้อมูล..."; echo "

Sale Summary By Days

"; switch($zone){ case "ALL";{ $SqlView = "ts.zone=tg.zone"; $SqlView3 = "ts.zone"; break; } default:{ $SqlView = "ts.area = tg.area"; $SqlView2 = "and ts.zone='$zone'"; $SqlView3 = "ts.area"; break; } } switch($view){ case "Qty";{ $Sview = "qty_ctn"; $Tview = "TTG"; $tbl = "transale"; //$ni = "and channel in('CA','CR','MT')"; $ni = "and channel in($list_channel)"; $aView = "ts.channel"; break; } case "Amount";{ if($vat=="on"){ $Sview = "(orderamount*100/107)"; $Tview = "(SP01*100/107)"; }else{ $Sview = "orderamount"; $Tview = "SP01"; } $tbl = "tranhead"; //$ni = "and ordertype in('CA','CR','MT')"; $ni = "and ordertype in($list_channel)"; $aView = "ts.ordertype"; break; } } switch($zone){ case "ALL";{ $ct=0; $list_area = array('B','C','E','N','N/E','S','IDS','MT'); $list_s = "'B','C','E','N','N/E','S','IDS','MT'"; for($i==0;$i"2016"){ $sql = <<"; //Generate Head Field $lineHead = "Date/Area"; $wb=0; for($wx==0;$wx<$col-2;$wx++){ $lineHead.="".$list_area[$wb].""; $wb++; } $lineHead.="Summary"; //hilight value=0; while($row = @mysql_fetch_array($rs)){ $lineData.= ""; $b=0; for($a==0;$a<$col;$a++){ if($b==0){ $lineData.="

".$row[$b]."

"; $JDT = $row[$b]; }else{ if($row[$b]<=0){ $lineData.=""; }else{ if((substr($list_area[$b-1],-3,1)=='2')){ $link="ps/ps_sa_get_detail_by_day.php"; }else{ $link="ps/ps_sa_get_detail_credit_by_day.php"; } $s1 = ""; $s2 = ""; $lineData.="

".number_format($row[$b],2)."

"; } } $xTotal[$b]+=$row[$b]; $b++; } $lineData.=""; $a=0; } //Summary End $b2=0; $lineSum.= ""; for($a2==0;$a2<$col;$a2++){ if($b2==0){ $lineSum.="

Total

"; }else{ if($xTotal[$b2]<=0){ $lineSum.=""; }else if($b2>=$col-1){ $lineSum.="".number_format($xTotal[$b2],2).""; } else{ $lineSum.="".number_format($xTotal[$b2],2).""; } } $b2++; } $lineSum.=""; echo ""; echo $lineHead; echo $lineData; echo $lineSum; echo "
"; //---------------------------------------------------------------------- To Target ------------------------------------------------------------------------------------------------------// //Generate Head Field 2 Target echo "

"; echo "

Percent To Target (View : $view)

"; echo "

จำนวนวันทำงานไปแล้ว [$cDay] วัน

"; $lineHead2 = "Zone/Area"; $lineHead2.="เป้ารายเดือน"; $lineHead2.="ยอดขายปัจจุบัน"; $lineHead2.="+/- จากเป้าหมาย"; $lineHead2.="%จาก
เป้าหมาย"; $lineHead2.="เป้า
ยอดขายต่อวัน"; $lineHead2.="เฉลี่ยยอดขาย
ที่ทำได้จริงต่อวัน"; $lineHead2.="%เทียบ
ยอดเฉลี่ยต่อวัน"; if($zone<>"ALL"){ $sql2 = <<=1){ $fc="fontg"; }else{ $fc="fontr"; //$to_target = $to_target-($to_target * 2); } $lineData2.= ""; $lineData2.="".$row2[0].""; $lineData2.="".number_format($row2[2],2).""; $lineData2.="".number_format($row2[1],2).""; $lineData2.="".number_format($to_target,2).""; $lineData2.="".number_format($row2[3],2).""; $lineData2.="".number_format($Avg_per_day,2).""; $lineData2.="".number_format($Avg_sale_per_day,2).""; $lineData2.="".number_format($Avg_per_daily,2).""; $lineData2.=""; $b2++; } $Tot_Goal = $Tot_Now-$Tot_Target; @$Tot_Percent = ($Tot_Now*100)/$Tot_Target; @$Tot_Avg_per_daily = ($Tot_Avg_sale_per_day*100)/$Tot_Avg_per_day; if($Tot_Goal>=1){ $fc1="fontg"; }else{ $fc1="fontr"; //$Tot_Goal = $Tot_Goal-($Tot_Goal * 2); } $lineSum2.= ""; $lineSum2.="Total"; $lineSum2.="".number_format($Tot_Target,2).""; $lineSum2.="".number_format($Tot_Now,2).""; $lineSum2.="".number_format($Tot_Goal,2).""; $lineSum2.="".number_format($Tot_Percent,2).""; $lineSum2.="".number_format($Tot_Avg_per_day,2).""; $lineSum2.="".number_format($Tot_Avg_sale_per_day,2).""; $lineSum2.="".number_format($Tot_Avg_per_daily,2).""; $lineSum2.=""; echo ""; echo $lineHead2; echo $lineData2; echo $lineSum2; echo "
"; }else{ //=================================================== For Year To Date ========================================================// echo "Report YTD อยู่ในระหว่างการพัฒนา "; //zone in ดึงจาก $zone > $list_channel | group by ดึงจาก $SqlView if($zone=="ALL"){ $grpBy = "zone"; }else{ $grpBy = "area"; $byList = "AND area in($list_s)"; } /** switch($view){ case "Qty";{ $Sview = "qty_ctn"; $Tview = "TTG"; $tbl = "transale"; //$ni = "and channel in('CA','CR','MT')"; $ni = "and channel in($list_channel)"; $aView = "ts.channel"; break; } case "Amount";{ if($vat=="on"){ $Sview = "(orderamount*100/107)"; $Tview = "(SP01*100/107)"; }else{ $Sview = "orderamount"; $Tview = "SP01"; } $tbl = "tranhead"; //$ni = "and ordertype in('CA','CR','MT')"; $ni = "and ordertype in($list_channel)"; $aView = "ts.ordertype"; break; } } **/ $sql_Ytd = <<$sql_Ytd"; //echo $sql; $rsw=@mysql_query($sql_Ytd); $col3 = @mysql_num_fields($rsw)."
"; //Generate Head Field $lineHead2 = "Area/Month"; $wb2=0; for($wx2==0;$wx2<$col3-2;$wx2++){ $lineHead2.="".$list_mn[$wb2].""; $wb2++; } $lineHead2.="Summary"; //Generate Row while($row2 = @mysql_fetch_array($rsw)){ $lineData2.= ""; $b2=0; for($a2==0;$a2<$col3;$a2++){ if($b2==0){ $lineData2.="

".$row2[$b2]."

"; $JDT2 = $row2[$b2]; }else{ if($row2[$b2]<=0){ $lineData2.=""; }else{ if((substr($list_area[$b-1],-3,1)=='2')){ $link="ps/ps_sa_get_detail_by_day.php"; }else{ $link="ps/ps_sa_get_detail_credit_by_day.php"; } $s1 = ""; $s2 = ""; $lineData2.="

".number_format($row2[$b2],2)."

"; } } $xTotal2[$b2]+=$row2[$b2]; $b2++; } $lineData2.=""; $a2=0; } //Summary End $b3=0; $lineSum3.= ""; for($a3==0;$a3<$col3;$a3++){ if($b3==0){ $lineSum3.="

Total

"; }else{ if($xTotal2[$b3]<=0){ $lineSum3.=""; }else if($b3>=$col3-1){ $lineSum3.="".number_format($xTotal2[$b3],2).""; } else{ $lineSum3.="".number_format($xTotal2[$b3],2).""; } } $b3++; } $lineSum3.=""; echo ""; echo $lineHead2; echo $lineData2; echo $lineSum3; echo "
"; } ?>