=$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 "กลุ่ม 10g,80g,170g ($VCom1) | ";
echo "กลุ่ม 450g,900g,1200g,20KG ($VCom1) | ";
echo "กลุ่มเติมทิพ ($VCom1) | ";
echo "กลุ่มพ่อครัวทอง ($VCom1) | ";
echo "กลุ่มน้ำมะนาว ($VCom1) | ";
echo "กลุ่มน้ำก๋วยเตี๋ยวสำเร็จรูป ($VCom1) | ";
echo "กลุ่มน้ำจิ้มสุกี้ ($VCom1) | ";
echo "กลุ่มซอสหมัก,ซอสปรุง ($VCom1) | ";
echo "กลุ่มน้ำจิ้มไก่ ($VCom1) | ";
echo "กลุ่มผงชูรส ($VCom1) | ";
echo "รวมรางวัลกลุ่ม | ";
echo "
";
echo "";
echo "เขต | ";
echo "พนักงาน | ";
//Loop column
for($x1==0;$x1<=9;$x1++){
echo "ยอดขาย | ";
echo "ยอด CN | ";
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 "$salearea | ";
echo "$salename | ";
//Data
$b1=1;
for($z1==0;$z1<=9;$z1++){
echo "$sa[$b1] | ";
echo "$cn[$b1] | ";
echo "$net[$b1] | ";
echo "$tar[$b1] | ";
echo "$per[$b1] % | ";
echo "$com[$b1] | ";
$b1++;
}
$a1=0;
$x1=0;
$y1=0;
$z1=0;
$b1=0;
echo "".number_format($groupCom,2)." | ";
echo "
";
} //end While
//SUMMARY TOTAL
echo "";
echo "TOTAL | ";
echo " | ";
$v1=1;
for($p1==0;$p1<=9;$p1++){
echo "".number_format($TOT_SA[$v1],2)." | ";
echo "".number_format($TOT_CN[$v1],2)." | ";
echo "".number_format($TOT_NET[$v1],2)." | ";
echo "".number_format($TOT_TAR[$v1],2)." | ";
echo " | ";
echo "".number_format($TOT_COM[$v1],2)." | ";
$v1++;
}
echo "".number_format($groupCom,2)." | ";
echo "
";
echo "
";
echo "";
?>