Pottery Rating

Metadata form for rating PotteryRecords

Pottery Rating form

Name:	Type:	Size:	Values:	Description:	Attributes:	Default:
Who	user	40		Who made the rating	d h	Main.WikiGuest
Reference	topic	40		The reference pottery piece	h	Applications/LocalApps.PotteryRating
Form	slider	1	min="1" max="5"	Points given for aspect	d	3
Trimming	slider	1	min="1" max="5"	Points given for aspect	d	3
Glazing	slider	1	min="1" max="5"	Points given for aspect	d	3
Surface	slider	1	min="1" max="5"	Points given for aspect	d	3
Execution	slider	1	min="1" max="5"	Points given for aspect	d	3
Concept	slider	1	min="1" max="5"	Points given for aspect	d	3
Comment	textarea	30x4

Render Rating Button

%STARTSECTION{"rate"}%%NEWMETADATA{"PotteryRating"
   topic="%BASEWEB%.%BASETOPIC%"
   buttontitle="Rate This Piece"
   icon="fa-thumbs-up"
}%%ENDSECTION{"rate"}%

Render Rating Table

%STARTSECTION{"rating_table"}%%SET{"RATINGS"
   value="%RENDERMETADATA{"PotteryRating"
      mode="view"
      separator="#"
      header=""
      footer=""
      format="Reference:$Reference~Who:$Who~Form:$Form~Trimming:$Trimming~Glazing:$Glazing~Surface:$Surface~Execution:$Execution~Concept:$Concept" 
   }%"
}%%SET{"HEADINGS"
   value="%FORMATLIST{"%RATINGS%"
             split="#"
             pattern="Reference:.*?~Who:.*?~(.*?):[^~]*~(.*?):[^~]*~(.*?):[^~]*~(.*?):[^~]*~(.*?):[^~]*~(.*?):.*"
             format="$1#$2#$3#$4#$5#$6"
             limit="1"
          }%"
}%
%FORMATLIST{"%RATINGS%"
   split="#"
   pattern="Reference:.*?~Who:(.*?)~(.*)"
   header="$percntFORMATLIST{\"%HEADINGS%\" split=\"#\" format=\" *$1* \" header=\"| *Item* |\" separator=\" |\" footer=\" | *Overall Rating* | *Comment*  |$n\"}$percnt"
   format="| $1 | $percntFORMATLIST{\"$2\" "
                           +"split=\"~\" "
                           +"pattern=\"(.*?):(.*)\" "
                           +"format=\"$dollarpercntCALC{\\"$SET(this_$dollar1,$dollar2)$SET(all_$1, $GET(all_$1),$GET(this_$dollar1))"
                                             +"$SET(all_$dollar1,$GET(all_$dollar1),$GET(this_$dollar1))$GET(this_$dollar1)\\" "
                                      +"}$dollarpercnt\" "
                           +"separator=\"|\" "
                   +"}$percnt | $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($GET(all_$1)))\"}$percnt | $Comment |"
   separator="$n"
   footer="$n| Rating Avgs  | $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($ABOVE()))\"}$percnt | $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($ABOVE()))\"}$percnt "
         +"| $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($ABOVE()))\"}$percnt | $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($ABOVE()))\"}$percnt "
         +"| $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($ABOVE()))\"}$percnt | $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($ABOVE()))\"}$percnt "
         +"| $percntCALC{\"$FORMAT(NUMBER, 1, $AVERAGE($ABOVE()))\"}$percnt |   |"
}%%ENDSECTION{"rating_table"}%

Render Overall Rating

• WHO - optional Filter by who made rating

%STARTSECTION{"rating"}%%CALCULATE{"$FORMAT(NUMBER, 1, $AVERAGE(%RENDERMETADATA{"PotteryRating"
      mode="view" %IF{"defined WHO" then="filter=\"Who='%WHO%'\""}%
      separator=","
      header=""
      footer=""
      format="$Form,$Trimming,$Glazing,$Surface,$Execution,$Concept" 
   }%))"}%%ENDSECTION{"rating"}%