=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G01B/TG01) END AS COM_G01, G02A as 'SA_G02',G02C as 'CN_G02',G02B as 'NET_G02',TG02 as 'TAR_G02', (G02B*100)/TG02 as PER_G02, CASE WHEN (((G02B*100)/TG02)<$MinP) THEN '0' WHEN (((G02B*100)/TG02)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G02B/TG02) END AS COM_G02, G03A as 'SA_G03',G03C as 'CN_G03',G03B as 'NET_G03',TG03 as 'TAR_G03', (G03B*100)/TG03 as PER_G03, CASE WHEN (((G03B*100)/TG03)<$MinP) THEN '0' WHEN (((G03B*100)/TG03)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G03B/TG03) END AS COM_G03, G04A as 'SA_G04',G04C as 'CN_G04',G04B as 'NET_G04',TG04 as 'TAR_G04', (G04B*100)/TG04 as PER_G04, CASE WHEN (((G04B*100)/TG04)<$MinP) THEN '0' WHEN (((G04B*100)/TG04)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G04B/TG04) END AS COM_G04, G05A as 'SA_G05',G05C as 'CN_G05',G05B as 'NET_G05',TG05 as 'TAR_G05', (G05B*100)/TG05 as PER_G05, CASE WHEN (((G05B*100)/TG05)<$MinP) THEN '0' WHEN (((G05B*100)/TG05)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G05B/TG05) END AS COM_G05, G06A as 'SA_G06',G06C as 'CN_G06',G06B as 'NET_G06',TG06 as 'TAR_G06', (G06B*100)/TG06 as PER_G06, CASE WHEN (((G06B*100)/TG06)<$MinP) THEN '0' WHEN (((G06B*100)/TG06)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G06B/TG06) END AS COM_G06, G07A as 'SA_G07',G07C as 'CN_G07',G07B as 'NET_G07',TG07 as 'TAR_G07', (G07B*100)/TG07 as PER_G07, CASE WHEN (((G07B*100)/TG07)<$MinP) THEN '0' WHEN (((G07B*100)/TG07)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G07B/TG07) END AS COM_G07, G08A as 'SA_G08',G08C as 'CN_G08',G08B as 'NET_G08',TG08 as 'TAR_G08', (G08B*100)/TG08 as PER_G08, CASE WHEN (((G08B*100)/TG08)<$MinP) THEN '0' WHEN (((G08B*100)/TG08)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G08B/TG08) END AS COM_G08, G09A as 'SA_G09',G09C as 'CN_G09',G09B as 'NET_G09',TG09 as 'TAR_G09', (G09B*100)/TG09 as PER_G09, CASE WHEN (((G09B*100)/TG09)<$MinP) THEN '0' WHEN (((G09B*100)/TG09)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G09B/TG09) END AS COM_G09, G10A as 'SA_G10',G10C as 'CN_G10',G10B as 'NET_G10',TG10 as 'TAR_G10', (G10B*100)/TG10 as PER_G10, CASE WHEN (((G10B*100)/TG10)<$MinP) THEN '0' WHEN (((G10B*100)/TG10)>=$MaxP) THEN ((t.pa01/5)+t.pa01) ELSE t.pa01*(G10B/TG10) END AS COM_G10 FROM commission c LEFT JOIN sale_target_all b ON ((c.AREA=b.area) and mn='$mn' and yr='$yr') LEFT JOIN tcomission t ON ((c.channel=t.channel) and t.period='$period') WHERE c.AREA like '$area%' AND c.PERIOD='$period' ORDER By c.AREA SQL; //echo $sql; $rs=mysql_query($sql); $VCom1 = 800; echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //Loop column for($x1==0;$x1<=9;$x1++){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //ท้ายตาราง echo ""; echo ""; while($row = mysql_fetch_array($rs)) { $salecode = $row["SALECODE"]; $salename = $row["SALENAME"]; $salearea = $row["AREA"]; $salezone = $row["ZONE"]; /** $a=1; for($y1==0;$y<=9;$y++){ $sa[$a] = number_format($row["SA_G0$a"],2); $cn[$a] = number_format($row["CN_G0$a"],2); $net[$a] = number_format($row["NET_G0$a"],2); $tar[$a] = number_format($row["TAR_G0$a"],2); $per[$a] = number_format($row["PER_G0$a"],2); $com[$a] = number_format($row["COM_G0$a"],2); $groupCom+=$com[$a]; $a++; } **/ $sa[1] = number_format($row["SA_G01"],2); $cn[1] = number_format($row["CN_G01"],2); $net[1] = number_format($row["NET_G01"],2); $tar[1] = number_format($row["TAR_G01"],2); $per[1] = number_format($row["PER_G01"],2); $com[1] = number_format($row["COM_G01"],2); $sa[2] = number_format($row["SA_G02"],2); $cn[2] = number_format($row["CN_G02"],2); $net[2] = number_format($row["NET_G02"],2); $tar[2] = number_format($row["TAR_G02"],2); $per[2] = number_format($row["PER_G02"],2); $com[2] = number_format($row["COM_G02"],2); $sa[3] = number_format($row["SA_G03"],2); $cn[3] = number_format($row["CN_G03"],2); $net[3] = number_format($row["NET_G03"],2); $tar[3] = number_format($row["TAR_G03"],2); $per[3] = number_format($row["PER_G03"],2); $com[3] = number_format($row["COM_G03"],2); $sa[4] = number_format($row["SA_G04"],2); $cn[4] = number_format($row["CN_G04"],2); $net[4] = number_format($row["NET_G04"],2); $tar[4] = number_format($row["TAR_G04"],2); $per[4] = number_format($row["PER_G04"],2); $com[4] = number_format($row["COM_G04"],2); $sa[5] = number_format($row["SA_G05"],2); $cn[5] = number_format($row["CN_G05"],2); $net[5] = number_format($row["NET_G05"],2); $tar[5] = number_format($row["TAR_G05"],2); $per[5] = number_format($row["PER_G05"],2); $com[5] = number_format($row["COM_G05"],2); $sa[6] = number_format($row["SA_G06"],2); $cn[6] = number_format($row["CN_G06"],2); $net[6] = number_format($row["NET_G06"],2); $tar[6] = number_format($row["TAR_G06"],2); $per[6] = number_format($row["PER_G06"],2); $com[6] = number_format($row["COM_G06"],2); $sa[7] = number_format($row["SA_G07"],2); $cn[7] = number_format($row["CN_G07"],2); $net[7] = number_format($row["NET_G07"],2); $tar[7] = number_format($row["TAR_G07"],2); $per[7] = number_format($row["PER_G07"],2); $com[7] = number_format($row["COM_G07"],2); $sa[8] = number_format($row["SA_G08"],2); $cn[8] = number_format($row["CN_G08"],2); $net[8] = number_format($row["NET_G08"],2); $tar[8] = number_format($row["TAR_G08"],2); $per[8] = number_format($row["PER_G08"],2); $com[8] = number_format($row["COM_G08"],2); $sa[9] = number_format($row["SA_G09"],2); $cn[9] = number_format($row["CN_G09"],2); $net[9] = number_format($row["NET_G09"],2); $tar[9] = number_format($row["TAR_G09"],2); $per[9] = number_format($row["PER_G09"],2); $com[9] = number_format($row["COM_G09"],2); $sa[10] = number_format($row["SA_G10"],2); $cn[10] = number_format($row["CN_G10"],2); $net[10] = number_format($row["NET_G10"],2); $tar[10] = number_format($row["TAR_G10"],2); $per[10] = number_format($row["PER_G10"],2); $com[10] = number_format($row["COM_G10"],2); $groupCom=($com[1]+$com[2]+$com[3]+$com[4]+$com[5]+$com[6]+$com[7]+$com[8]+$com[9]+$com[10]); //สะสมทำข้อมูล total $TOT_COML+=$groupCom; $TOT_SA[1]+=$row["SA_G01"]; $TOT_SA[2]+=$row["SA_G02"]; $TOT_SA[3]+=$row["SA_G03"]; $TOT_SA[4]+=$row["SA_G04"]; $TOT_SA[5]+=$row["SA_G05"]; $TOT_SA[6]+=$row["SA_G06"]; $TOT_SA[7]+=$row["SA_G07"]; $TOT_SA[8]+=$row["SA_G08"]; $TOT_SA[9]+=$row["SA_G09"]; $TOT_SA[10]+=$row["SA_G10"]; $TOT_CN[1]+=$row["CN_G01"]; $TOT_CN[2]+=$row["CN_G02"]; $TOT_CN[3]+=$row["CN_G03"]; $TOT_CN[4]+=$row["CN_G04"]; $TOT_CN[5]+=$row["CN_G05"]; $TOT_CN[6]+=$row["CN_G06"]; $TOT_CN[7]+=$row["CN_G07"]; $TOT_CN[8]+=$row["CN_G08"]; $TOT_CN[9]+=$row["CN_G09"]; $TOT_CN[10]+=$row["CN_G10"]; $TOT_NET[1]+=$row["NET_G01"]; $TOT_NET[2]+=$row["NET_G02"]; $TOT_NET[3]+=$row["NET_G03"]; $TOT_NET[4]+=$row["NET_G04"]; $TOT_NET[5]+=$row["NET_G05"]; $TOT_NET[6]+=$row["NET_G06"]; $TOT_NET[7]+=$row["NET_G07"]; $TOT_NET[8]+=$row["NET_G08"]; $TOT_NET[9]+=$row["NET_G09"]; $TOT_NET[10]+=$row["NET_G10"]; $TOT_TAR[1]+=$row["TAR_G01"]; $TOT_TAR[2]+=$row["TAR_G02"]; $TOT_TAR[3]+=$row["TAR_G03"]; $TOT_TAR[4]+=$row["TAR_G04"]; $TOT_TAR[5]+=$row["TAR_G05"]; $TOT_TAR[6]+=$row["TAR_G06"]; $TOT_TAR[7]+=$row["TAR_G07"]; $TOT_TAR[8]+=$row["TAR_G08"]; $TOT_TAR[9]+=$row["TAR_G09"]; $TOT_TAR[10]+=$row["TAR_G10"]; $TOT_COM[1]+=$row["COM_G01"]; $TOT_COM[2]+=$row["COM_G02"]; $TOT_COM[3]+=$row["COM_G03"]; $TOT_COM[4]+=$row["COM_G04"]; $TOT_COM[5]+=$row["COM_G05"]; $TOT_COM[6]+=$row["COM_G06"]; $TOT_COM[7]+=$row["COM_G07"]; $TOT_COM[8]+=$row["COM_G08"]; $TOT_COM[9]+=$row["COM_G09"]; $TOT_COM[10]+=$row["COM_G10"]; echo ""; echo ""; echo ""; //Data $b1=1; for($z1==0;$z1<=9;$z1++){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $b1++; } $a1=0; $x1=0; $y1=0; $z1=0; $b1=0; echo ""; echo ""; } //end While //SUMMARY TOTAL echo ""; echo ""; echo ""; $v1=1; for($p1==0;$p1<=9;$p1++){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $v1++; } echo ""; echo ""; echo "
กลุ่ม 10g,80g,170g ($VCom1)กลุ่ม 450g,900g,1200g,20KG ($VCom1)กลุ่มเติมทิพ ($VCom1)กลุ่มพ่อครัวทอง ($VCom1)กลุ่มน้ำมะนาว ($VCom1)กลุ่มน้ำก๋วยเตี๋ยวสำเร็จรูป ($VCom1)กลุ่มน้ำจิ้มสุกี้ ($VCom1)กลุ่มซอสหมัก,ซอสปรุง ($VCom1)กลุ่มน้ำจิ้มไก่ ($VCom1)กลุ่มผงชูรส ($VCom1)รวมรางวัลกลุ่ม
เขตพนักงานยอดขายยอด CNทำได้เป้าหมายทำได้ %ได้เงินรวมรางวัลกลุ่ม
$salearea$salename$sa[$b1]$cn[$b1]$net[$b1]$tar[$b1]$per[$b1] %$com[$b1]".number_format($groupCom,2)."
TOTAL".number_format($TOT_SA[$v1],2)."".number_format($TOT_CN[$v1],2)."".number_format($TOT_NET[$v1],2)."".number_format($TOT_TAR[$v1],2)."".number_format($TOT_COM[$v1],2)."".number_format($groupCom,2)."
"; echo "

"; ?>