get_results(“select * from wp_posts where post_type LIKE ‘%entry%’ AND post_status = ‘publish’ order by ID”);
if ( $vfb_entries )
{
echo “* 점수는 에세이 / 봉사 의 포맷으로 표시되어 있습니다.”;
echo “
지원자\평가자 |
“;
$scorers = $wpdb->get_results(“select DISTINCT cuserid from _vscholar_scores ORDER BY cuserid”);
if ( $scorers )
{
foreach ( $scorers as $each )
{
$scorer = $wpdb->get_row(“select * from wp_users where ID = ‘”.$each->cuserid.”‘”);
$scorer_name = $scorer->user_login;
echo “
$scorer_name |
“;
}
}
echo “
에세이총점 |
서비스총점 |
합계총점 |
“;
foreach ( $vfb_entries as $post )
{
$eid = $post->ID;
$vfb_entry_fname = $wpdb->get_row(“select * from wp_postmeta where post_id = “.$eid.” AND meta_key = ‘_vfb_field-3′”);
$fname = $vfb_entry_fname->meta_value;
$vfb_entry_lname = $wpdb->get_row(“select * from wp_postmeta where post_id = “.$eid.” AND meta_key = ‘_vfb_field-4′”);
$lname = $vfb_entry_lname->meta_value;
echo “
$fname $lname |
“;
$total_score1 = 0;
$total_score2 = 0;
foreach ( $scorers as $each )
{
$vfb_entry_score = $wpdb->get_row(“select * from _vscholar_scores where eid = “.$eid.” AND cuserid = “.$each->cuserid);
if ( $vfb_entry_score )
{
echo “
“.$vfb_entry_score->score1.” / “.$vfb_entry_score->score2.” |
“;
$total_score1 = $total_score1 + $vfb_entry_score->score1;
$total_score2 = $total_score2 + $vfb_entry_score->score2;
} else {
echo “
|
“;
}
}
$total_score = $total_score1 + $total_score2;
echo “
$total_score1 |
$total_score2 |
$total_score |
“;
}
echo “
“;
}
else
{
?>
Not Found
댓글을 남겨주세요
Want to join the discussion?Feel free to contribute!