|
| |
| |
| ความพึงพอใจของผู้ใช้บริการรถแทรกเตอร์และเครื่องจักรกลการเกษตร |
|
|
 สรุปผลความพึงพอใจต่อการใช้บริการ |
| |
ปี 2566 |
ระดับความคิดเห็น |
แปลค่า |
'2022-12-31' and SP_Post <'2023-02-01' order by SP_ID asc ";
$dbP1=mysql_db_query($dbname, $SelP1);
$numP1=mysql_num_rows($dbP1);
for($p1=1;$p1<=$numP1;$p1++){
$rsP1=mysql_fetch_array($dbP1);
$SP1_ID=$rsP1['SP_ID'];
$SP1_Purpose=$rsP1['SP_Purpose'];
$SP1_No1=$rsP1['SP_No1'];
$SP1_Comment=$rsP1['SP_Comment'];
if($SP1_No1=="5"){ $SP1_No1_5=$SP1_No1_5+1;}
if($SP1_No1=="4"){ $SP1_No1_4=$SP1_No1_4+1;}
if($SP1_No1=="3"){ $SP1_No1_3=$SP1_No1_3+1;}
if($SP1_No1=="2"){ $SP1_No1_2=$SP1_No1_2+1;}
if($SP1_No1=="1"){ $SP1_No1_1=$SP1_No1_1+1;}
}
if($numP1==0){
$PointP1=0;
$mPer1="-";
}else{
$SumP1=($SP1_No1_5*5)+($SP1_No1_4*4)+($SP1_No1_3*3)+($SP1_No1_2*2)+($SP1_No1_1*1);
$PointP1=$SumP1/$numP1;
if($PointP1>4.5){ $mPer1="ดีมาก";}elseif($PointP1>3.5){ $mPer1="ดี";}elseif($PointP1>2.5){ $mPer1="ปานกลาง";}elseif($PointP1>1.5){ $mPer1="พอใช้";}else{ $mPer1="ปรับปรุง";}
}
?>
| |
มกราคม |
|
|
'2023-01-31' and SP_Post <'2023-03-01' order by SP_ID asc ";
$dbP2=mysql_db_query($dbname, $SelP2);
$numP2=mysql_num_rows($dbP2);
for($p2=1;$p2<=$numP2;$p2++){
$rsP2=mysql_fetch_array($dbP2);
$SP2_ID=$$rsP2['SP_ID'];
$SP2_Purpose=$$rsP2['SP_Purpose'];
$SP2_No1=$$rsP2['SP_No1'];
$SP2_Comment=$$rsP2['SP_Comment'];
if($SP2_No1=="5"){ $SP2_No1_5=$SP2_No1_5+1;}
if($SP2_No1=="4"){ $SP2_No1_4=$SP2_No1_4+1;}
if($SP2_No1=="3"){ $SP2_No1_3=$SP2_No1_3+1;}
if($SP2_No1=="2"){ $SP2_No1_2=$SP2_No1_2+1;}
if($SP2_No1=="1"){ $SP2_No1_1=$SP2_No1_1+1;}
}
if($numP2==0){
$PointP2=0;
$mPer2="-";
}else{
$SumP2=($SP2_No1_5*5)+($SP2_No1_4*4)+($SP2_No1_3*3)+($SP2_No1_2*2)+($SP2_No1_1*1);
$PointP2=$SumP2/$numP2;
if($PointP2>4.5){ $mPer2="ดีมาก";}elseif($PointP2>3.5){ $mPer2="ดี";}elseif($PointP2>2.5){ $mPer2="ปานกลาง";}elseif($PointP2>1.5){ $mPer2="พอใช้";}else{ $mPer2="ปรับปรุง";}
}
?>
| |
กุมภาพันธ์ |
|
|
'2023-02-29' and SP_Post<'2023-04-01' order by SP_ID asc ";
$dbP3=mysql_db_query($dbname, $SelP3);
$numP3=mysql_num_rows($dbP3);
for($p3=1;$p3<=$numP3;$p3++){
$rsP3=mysql_fetch_array($dbP3);
$SP3_ID=$rsP3['SP_ID'];
$SP3_Purpose=$rsP3['SP_Purpose'];
$SP3_No1=$rsP3['SP_No1'];
$SP3_Comment=$rsP3['SP_Comment'];
if($SP3_No1=="5"){ $SP3_No1_5=$SP3_No1_5+1;}
if($SP3_No1=="4"){ $SP3_No1_4=$SP3_No1_4+1;}
if($SP3_No1=="3"){ $SP3_No1_3=$SP3_No1_3+1;}
if($SP3_No1=="2"){ $SP3_No1_2=$SP3_No1_2+1;}
if($SP3_No1=="1"){ $SP3_No1_1=$SP3_No1_1+1;}
}
if($numP3==0){
$PointP3=0;
$mPer3="-";
}else{
$SumP3=($SP3_No1_5*5)+($SP3_No1_4*4)+($SP3_No1_3*3)+($SP3_No1_2*2)+($SP3_No1_1*1);
$PointP3=$SumP3/$numP3;
if($PointP3>4.5){ $mPer3="ดีมาก";}elseif($PointP3>3.5){ $mPer3="ดี";}elseif($PointP3>2.5){ $mPer3="ปานกลาง";}elseif($PointP3>1.5){ $mPer3="พอใช้";}else{ $mPer3="ปรับปรุง";}
}
?>
| |
มีนาคม |
|
|
'2023-03-31' and SP_Post<'2023-05-01' order by SP_ID asc ";
$dbP4=mysql_db_query($dbname, $SelP4);
$numP4=mysql_num_rows($dbP4);
for($p4=1;$p4<=$numP4;$p4++){
$rsP4=mysql_fetch_array($dbP4);
$SP4_ID=$rsP4['SP_ID'];
$SP4_Purpose=$rsP4['SP_Purpose'];
$SP4_No1=$rsP4['SP_No1'];
$SP4_Comment=$rsP4['SP_Comment'];
if($SP4_No1=="5"){ $SP4_No1_5=$SP4_No1_5+1;}
if($SP4_No1=="4"){ $SP4_No1_4=$SP4_No1_4+1;}
if($SP4_No1=="3"){ $SP4_No1_3=$SP4_No1_3+1;}
if($SP4_No1=="2"){ $SP4_No1_2=$SP4_No1_2+1;}
if($SP4_No1=="1"){ $SP4_No1_1=$SP4_No1_1+1;}
}
if($numP4==0){
$PointP4=0;
$mPer4="-";
}else{
$SumP4=($SP4_No1_5*5)+($SP4_No1_4*4)+($SP4_No1_3*3)+($SP4_No1_2*2)+($SP4_No1_1*1);
$PointP4=$SumP4/$numP4;
if($PointP4>4.5){ $mPer4="ดีมาก";}elseif($PointP4>3.5){ $mPer4="ดี";}elseif($PointP4>2.5){ $mPer4="ปานกลาง";}elseif($PointP4>1.5){ $mPer4="พอใช้";}else{ $mPer4="ปรับปรุง";}
}
?>
| |
เมษายน |
|
|
'2023-04-30' and SP_Post<'2023-06-01' order by SP_ID asc ";
$dbP5=mysql_db_query($dbname, $SelP5);
$numP5=mysql_num_rows($dbP5);
for($p5=1;$p5<=$numP5;$p5++){
$rsP5=mysql_fetch_array($dbP5);
$SP5_ID=$rsP5['SP_ID'];
$SP5_Purpose=$rsP5['SP_Purpose'];
$SP5_No1=$rsP5['SP_No1'];
$SP5_Comment=$rsP5['SP_Comment'];
if($SP5_No1=="5"){ $SP5_No1_5=$SP5_No1_5+1;}
if($SP5_No1=="4"){ $SP5_No1_4=$SP5_No1_4+1;}
if($SP5_No1=="3"){ $SP5_No1_3=$SP5_No1_3+1;}
if($SP5_No1=="2"){ $SP5_No1_2=$SP5_No1_2+1;}
if($SP5_No1=="1"){ $SP5_No1_1=$SP5_No1_1+1;}
}
if($numP5==0){
$PointP5=0;
$mPer5="-";
}else{
$SumP5=($SP5_No1_5*5)+($SP5_No1_4*4)+($SP5_No1_3*3)+($SP5_No1_2*2)+($$SP5_No1_1*1);
$PointP5=$SumP5/$numP5;
if($PointP5>4.5){ $mPer5="ดีมาก";}elseif($PointP5>3.5){ $mPer5="ดี";}elseif($PointP5>2.5){ $mPer5="ปานกลาง";}elseif($PointP5>1.5){ $mPer5="พอใช้";}else{ $mPer5="ปรับปรุง";}
}
?>
| |
พฤษภาคม |
|
|
'2023-05-31' and SP_Post<'2023-07-01' order by SP_ID asc ";
$dbP6=mysql_db_query($dbname, $SelP6);
$numP6=mysql_num_rows($dbP6);
for($p6=1;$p6<=$numP6;$p6++){
$rsP6=mysql_fetch_array($dbP6);
$SP6_ID=$rsP6['SP_ID'];
$SP6_Purpose=$rsP6['SP_Purpose'];
$SP6_No1=$rsP6['SP_No1'];
$SP6_Comment=$rsP6['SP_Comment'];
if($SP6_No1=="5"){ $SP6_No1_5=$SP6_No1_5+1;}
if($SP6_No1=="4"){ $SP6_No1_4=$SP6_No1_4+1;}
if($SP6_No1=="3"){ $SP6_No1_3=$SP6_No1_3+1;}
if($SP6_No1=="2"){ $SP6_No1_2=$SP6_No1_2+1;}
if($SP6_No1=="1"){ $SP6_No1_1=$SP6_No1_1+1;}
}
if($numP6==0){
$PointP6=0;
$mPer6="-";
}else{
$SumP6=($SP6_No1_5*5)+($SP6_No1_4*4)+($SP6_No1_3*3)+($SP6_No1_2*2)+($SP6_No1_1*1);
$PointP6=$SumP6/$numP6;
if($PointP6>4.5){ $mPer6="ดีมาก";}elseif($PointP6>3.5){ $mPer6="ดี";}elseif($PointP6>2.5){ $mPer6="ปานกลาง";}elseif($PointP6>1.5){ $mPer6="พอใช้";}else{ $mPer6="ปรับปรุง";}
}
?>
| |
มิถุนายน |
|
|
'2023-06-30' and SP_Post<'2023-08-01' order by SP_ID asc ";
$dbP7=mysql_db_query($dbname, $SelP7);
$numP7=mysql_num_rows($dbP7);
for($p7=1;$p7<=$numP7;$p7++){
$rsP7=mysql_fetch_array($dbP7);
$SP7_ID=$rsP7['SP_ID'];
$SP7_Purpose=$rsP7['SP_Purpose'];
$SP7_No1=$rsP7['SP_No1'];
$SP7_Comment=$rsP7['SP_Comment'];
if($SP7_No1=="5"){ $SP7_No1_5=$SP7_No1_5+1;}
if($SP7_No1=="4"){ $SP7_No1_4=$SP7_No1_4+1;}
if($SP7_No1=="3"){ $SP7_No1_3=$SP7_No1_3+1;}
if($SP7_No1=="2"){ $SP7_No1_2=$SP7_No1_2+1;}
if($SP7_No1=="1"){ $SP7_No1_1=$SP7_No1_1+1;}
}
if($numP7==0){
$PointP7=0;
$mPer7="-";
//$PerP7=0;
//$widthP7=0;
}else{
$SumP7=($SP7_No1_5*5)+($SP7_No1_4*4)+($SP7_No1_3*3)+($SP7_No1_2*2)+($SP7_No1_1*1);
$PointP7=$SumP7/$numP7;
if($PointP7>4.5){ $mPer7="ดีมาก";}elseif($PointP7>3.5){ $mPer7="ดี";}elseif($PointP7>2.5){ $mPer7="ปานกลาง";}elseif($PointP7>1.5){ $mPer7="พอใช้";}else{ $mPer7="ปรับปรุง";}
//$PerP7=($numP7*100)/$numP;
//$widthP7=number_format($PerP7, 0, '.', ',');
}
?>
| |
กรกฏาคม |
|
|
'2023-07-31' and SP_Post<'2023-09-01' order by SP_ID asc ";
$dbP8=mysql_db_query($dbname, $SelP8);
$numP8=mysql_num_rows($dbP8);
for($p8=1;$p8<=$numP8;$p8++){
$rsP8=mysql_fetch_array($dbP8);
$SP8_ID=$rsP8['SP_ID'];
$SP8_Purpose=$rsP8['SP_Purpose'];
$SP8_No1=$rsP8['SP_No1'];
$SP8_Comment=$rsP8['SP_Comment'];
if($SP8_No1=="5"){ $SP8_No1_5=$SP8_No1_5+1;}
if($SP8_No1=="4"){ $SP8_No1_4=$SP8_No1_4+1;}
if($SP8_No1=="3"){ $SP8_No1_3=$SP8_No1_3+1;}
if($SP8_No1=="2"){ $SP8_No1_2=$SP8_No1_2+1;}
if($SP8_No1=="1"){ $SP8_No1_1=$SP8_No1_1+1;}
}
if($numP8==0){
$PointP8=0;
$mPer8="-";
}else{
$SumP8=($SP8_No1_5*5)+($SP8_No1_4*4)+($SP8_No1_3*3)+($SP8_No1_2*2)+($SP8_No1_1*1);
$PointP8=$SumP8/$numP8;
if($PointP8>4.5){ $mPer8="ดีมาก";}elseif($PointP8>3.5){ $mPer8="ดี";}elseif($PointP8>2.5){ $mPer8="ปานกลาง";}elseif($PointP8>1.5){ $mPer8="พอใช้";}else{ $mPer8="ปรับปรุง";}
}
?>
| |
สิงหาคม |
|
|
'2023-08-31' and SP_Post<'2023-10-01' order by SP_ID asc ";
$dbP9=mysql_db_query($dbname, $SelP9);
$numP9=mysql_num_rows($dbP9);
for($p9=1;$p9<=$numP9;$p9++){
$rsP9=mysql_fetch_array($dbP9);
$SP9_ID=$$rsP9['SP_ID'];
$SP9_Purpose=$$rsP9['SP_Purpose'];
$SP9_No1=$$rsP9['SP_No1'];
$SP9_Comment=$$rsP9['SP_Comment'];
if($SP9_No1=="5"){ $SP9_No1_5=$SP9_No1_5+1;}
if($SP9_No1=="4"){ $SP9_No1_4=$SP9_No1_4+1;}
if($SP9_No1=="3"){ $SP9_No1_3=$SP9_No1_3+1;}
if($SP9_No1=="2"){ $SP9_No1_2=$SP9_No1_2+1;}
if($SP9_No1=="1"){ $SP9_No1_1=$SP9_No1_1+1;}
}
if($numP9==0){
$PointP9=0;
$mPer9="-";
}else{
$SumP9=($SP9_No1_5*5)+($SP9_No1_4*4)+($SP9_No1_3*3)+($SP9_No1_2*2)+($SP9_No1_1*1);
$PointP9=$SumP9/$numP9;
if($PointP9>4.5){ $mPer9="ดีมาก";}elseif($PointP9>3.5){ $mPer9="ดี";}elseif($PointP9>2.5){ $mPer9="ปานกลาง";}elseif($PointP9>1.5){ $mPer9="พอใช้";}else{ $mPer9="ปรับปรุง";}
}
?>
| |
กันยายน |
|
|
'2023-09-30' and SP_Post<'2023-11-01' order by SP_ID asc ";
$dbP10=mysql_db_query($dbname, $SelP10);
$numP10=mysql_num_rows($dbP10);
for($p10=1;$p10<=$numP10;$p10++){
$rsP10=mysql_fetch_array($dbP10);
$SP10_ID=$rsP10['SP_ID'];
$SP10_Purpose=$rsP10['SP_Purpose'];
$SP10_No1=$rsP10['SP_No1'];
$SP10_Comment=$rsP10['SP_Comment'];
if($SP10_No1=="5"){ $SP10_No1_5=$SP10_No1_5+1;}
if($SP10_No1=="4"){ $SP10_No1_4=$SP10_No1_4+1;}
if($SP10_No1=="3"){ $SP10_No1_3=$SP10_No1_3+1;}
if($SP10_No1=="2"){ $SP10_No1_2=$SP10_No1_2+1;}
if($SP10_No1=="1"){ $SP10_No1_1=$SP10_No1_1+1;}
}
if($numP10==0){
$PointP10=0;
$mPer10="-";
}else{
$SumP10=($SP10_No1_5*5)+($SP10_No1_4*4)+($SP10_No1_3*3)+($SP10_No1_2*2)+($SP10_No1_1*1);
$PointP10=$SumP10/$numP10;
if($PointP10>4.5){ $mPer10="ดีมาก";}elseif($PointP10>3.5){ $mPer10="ดี";}elseif($PointP10>2.5){ $mPer10="ปานกลาง";}elseif($PointP10>1.5){ $mPer10="พอใช้";}else{ $mPer10="ปรับปรุง";}
}
?>
| |
ตุลาคม |
|
|
'2023-10-31' and SP_Post<'2023-12-01' order by SP_ID asc ";
$dbP11=mysql_db_query($dbname, $SelP11);
$numP11=mysql_num_rows($dbP11);
for($p11=1;$p11<=$numP11;$p11++){
$rsP11=mysql_fetch_array($dbP11);
$SP11_ID=$rsP11['SP_ID'];
$SP11_Purpose=$rsP11['SP_Purpose'];
$SP11_No1=$rsP11['SP_No1'];
$SP11_Comment=$rsP11['SP_Comment'];
if($SP11_No1=="5"){ $SP11_No1_5=$SP11_No1_5+1;}
if($SP11_No1=="4"){ $SP11_No1_4=$SP11_No1_4+1;}
if($SP11_No1=="3"){ $SP11_No1_3=$SP11_No1_3+1;}
if($SP11_No1=="2"){ $SP11_No1_2=$SP11_No1_2+1;}
if($SP11_No1=="1"){ $SP11_No1_1=$SP11_No1_1+1;}
}
if($numP11==0){
$PointP11=0;
$mPer11="-";
}else{
$SumP11=($SP11_No1_5*5)+($SP11_No1_4*4)+($SP11_No1_3*3)+($SP11_No1_2*2)+($SP11_No1_1*1);
$PointP11=$SumP11/$numP11;
if($PointP11>4.5){ $mPer11="ดีมาก";}elseif($PointP11>3.5){ $mPer11="ดี";}elseif($PointP11>2.5){ $mPer11="ปานกลาง";}elseif($PointP11>1.5){ $mPer11="พอใช้";}else{ $mPer11="ปรับปรุง";}
}
?>
| |
พฤศจิกายน |
|
|
'2023-11-30' and SP_Post<'2024-01-01' order by SP_ID asc ";
$dbP12=mysql_db_query($dbname, $SelP12);
$numP12=mysql_num_rows($dbP12);
for($p12=1;$p12<=$numP12;$p12++){
$rsP12=mysql_fetch_array($dbP11);
$SP11_ID=$rsP11['SP_ID'];
$SP11_Purpose=$rsP11['SP_Purpose'];
$SP11_No1=$rsP11['SP_No1'];
$SP11_Comment=$rsP11['SP_Comment'];
if($SP11_No1=="5"){ $SP11_No1_5=$SP11_No1_5+1;}
if($SP11_No1=="4"){ $SP11_No1_4=$SP11_No1_4+1;}
if($SP11_No1=="3"){ $SP11_No1_3=$SP11_No1_3+1;}
if($SP11_No1=="2"){ $SP11_No1_2=$SP11_No1_2+1;}
if($SP11_No1=="1"){ $SP11_No1_1=$SP11_No1_1+1;}
}
if($numP12==0){
$PointP12=0;
$mPer12="-";
}else{
$SumP12=($SP11_No1_5*5)+($SP11_No1_4*4)+($SP11_No1_3*3)+($SP11_No1_2*2)+($SP11_No1_1*1);
$PointP12=$SumP12/$numP12;
if($PointP12>4.5){ $mPer12="ดีมาก";}elseif($PointP12>3.5){ $mPer12="ดี";}elseif($PointP12>2.5){ $mPer12="ปานกลาง";}elseif($PointP12>1.5){ $mPer12="พอใช้";}else{ $mPer12="ปรับปรุง";}
}
?>
| |
ธันวาคม |
|
|
|
|
 สรุปราย 6 เดือน |
| |
ปี |
ม.ค.-มิ.ย. |
ก.ค.-ธ.ค. |
| |
2566 |
0){ $CP1="1";}else{ $CP1="0";}
if($PointP2>0){ $CP2="1";}else{ $CP2="0";}
if($PointP3>0){ $CP3="1";}else{ $CP3="0";}
if($PointP4>0){ $CP4="1";}else{ $CP4="0";}
if($PointP5>0){ $CP5="1";}else{ $CP5="0";}
if($PointP6>0){ $CP6="1";}else{ $CP6="0";}
$CP1=$CP1+$CP2+$CP3+$CP4+$CP5+$CP6;
$PointPR1=($PointP1+$PointP2+$PointP3+$PointP4+$PointP5+$PointP6)/$CP1;
if($PointPR1>4.5){ $mPR1="ดีมาก";}elseif($PointPR1>3.5){ $mPR1="ดี";}elseif($PointPR1>2.5){ $mPR1="ปานกลาง";}elseif($PointPR1>1.5){ $mPR1="พอใช้";}else{ $mPR1="ปรับปรุง";}
}
echo $mPR1;
?> |
0){ $CP7="1";}else{ $CP7="0";}
if($PointP8>0){ $CP8="1";}else{ $CP8="0";}
if($PointP9>0){ $CP9="1";}else{ $CP9="0";}
if($PointP10>0){ $CP10="1";}else{ $CP10="0";}
if($PointP11>0){ $CP11="1";}else{ $CP11="0";}
if($PointP12>0){ $CP12="1";}else{ $CP12="0";}
$CP2=$CP7+$CP8+$CP9+$CP10+$CP11+$CP12;
$PointPR2=($PointP7+$PointP8+$PointP9+$PointP10+$PointP11+$PointP12)/$CP2;
if($PointPR2>4.5){ $mPR2="ดีมาก";}elseif($PointPR2>3.5){ $mPR2="ดี";}elseif($PointPR2>2.5){ $mPR2="ปานกลาง";}elseif($PointPR2>1.5){ $mPR2="พอใช้";}else{ $mPR2="ปรับปรุง";}
}
echo $mPR2;
?> |
|
|
 ข้อเสนอแนะอื่นๆ |
'' and SP_Post>'2022-12-31' order by SP_ID desc";
$dbMent=mysql_db_query($dbname, $SelMent);
$numMent=mysql_num_rows($dbMent);
for($Ment=1;$Ment<=$numMent;$Ment++){
$rsMent=mysql_fetch_array($dbMent);
$SP_Comment=$rsMent['SP_Comment'];
?>
|
|
| |
|
| |
|
|
