'aj_review',
'description' => __('AJ Review 목록', 'ajreview' ),
);
parent::__construct('aj_review', 'AJ Review', $widget_ops);
}
public $args = array(
'before_widget' => "",
'after_widget' => "
"
);
public function widget($args, $instance){
global $table_prefix, $post;
$ajrv_category = $table_prefix . 'ajrv_category';
$ajrv_review = $table_prefix . 'ajrv_review';
$ajrv_review_item = $table_prefix . 'ajrv_review_item';
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$ajrv_opt_maxval = get_option('ajrv_opt_maxval', "10");
$title = !empty($instance['title']) ? $instance['title'] : "";
$group = !empty($instance['group']) ? $instance['group'] : "";
$filtervalue = !empty($instance['filtervalue']) ? $instance['filtervalue'] : "";
$itemcount = !empty($instance['itemcount']) ? $instance['itemcount'] : "3";
$skin = !empty($instance['skin']) ? $instance['skin'] : "basic_1";
$morelinktext = !empty($instance['morelinktext']) ? $instance['morelinktext'] : "";
$morelinklink = !empty($instance['morelinklink']) ? $instance['morelinklink'] : "";
//wp_enqueue_style('ajrvcss_basic_1', plugins_url("views/skins/".$skin."/style.css", __FILE__));
include(AJRV_PLUGIN_PATH."views/skins/".$skin."/widgetitem.php");
$categorytitle = "";
if($filtervalue == "RELATED"){
if(is_single()){
$sql = "select categoryid, b.title as title from $ajrv_review as a join $ajrv_category as b on a.categoryid = b.id where postid = ".$post->ID;
$rescate = $mysqli->query($sql);
if(mysqli_num_rows($rescate)){
$datacate = mysqli_fetch_assoc($rescate);
$filtervalue = $datacate["categoryid"];
$categorytitle = $datacate["title"];
}else{
$filtervalue = "";
}
}else{
$filtervalue = "";
}
}
echo "";
if($title){
echo "
".$title."
";
}
$sql_where = "";
if($filtervalue){
$sql_where = " and categoryid = " . $filtervalue;
}
if($group){
$sql_where = " and groupid = " . $group;
}
$sql = "select postid, overall, useramount, title from $ajrv_review where 0 = 0 " . $sql_where . " order by overall desc limit ".$itemcount;
$res = $mysqli->query($sql);
if(mysqli_num_rows($res)){
$itemdata = "";
$i = 1;
while($data = mysqli_fetch_assoc($res)){
$ovalper = ((float)$data["overall"] * 100) / (int)$ajrv_opt_maxval;
$starttemplate = $ajrv_widget_item;
$itemdata = str_replace("[RANK]", $i, $starttemplate);
$itemdata = str_replace("[PRODUCT]", $data["title"] ? $data["title"] : "", $itemdata);
if($i == 1){
$itemdata = str_replace("[CROWN]", "
", $itemdata);
$itemdata = str_replace("[TOPNO]", "", $itemdata);
}else{
$itemdata = str_replace("[CROWN]", "", $itemdata);
$itemdata = str_replace("[TOPNO]", $i, $itemdata);
}
$itemdata = str_replace("[ONLYONE]", "", $itemdata);
$itemdata = str_replace("[TONEDOWN-SKIN1]", "background:#f3f3f3", $itemdata);
$itemdata = str_replace("[TONEDOWN-SKIN2]", "background:#4c4f5d", $itemdata);
if($data["postid"]){
$itemdata = str_replace("[URL]", get_permalink($data["postid"]), $itemdata);
$itemdata = str_replace("[URLTAG]", "a", $itemdata);
$itemdata = str_replace("[URLCURSOR]", "cursor: pointer;", $itemdata);
$itemdata = str_replace("[URLCSS]", "arjv_url", $itemdata);
$itemdata = str_replace("[DOCICON]", "", $itemdata);
}else{
$itemdata = str_replace("[URL]", "#", $itemdata);
$itemdata = str_replace("[URLTAG]", "span", $itemdata);
$itemdata = str_replace("[URLCURSOR]", "cursor: initial;", $itemdata);
$itemdata = str_replace("[URLCSS]", "", $itemdata);
$itemdata = str_replace("[DOCICON]", "", $itemdata);
}
$itemdata = str_replace("[TITLE]", $data["title"], $itemdata);
$itemdata = str_replace("[OVAL]", $ovalper, $itemdata);
$itemdata = str_replace("[OVERALL]", round($data["overall"],1), $itemdata);
if($data['postid']){
$postitem = get_post($data['postid']);
$img = get_the_post_thumbnail_url($postitem->ID,'medium');
if($postitem->ID){
$itemdata = str_replace("[URL]", get_permalink($postitem->ID), $itemdata);
}else{
$itemdata = str_replace("[URL]", "#", $itemdata);
}
$itemdata = str_replace("[IMG]", get_the_post_thumbnail_url($postitem->ID,'medium'), $itemdata);
}
$i++;
echo $itemdata;
}
if($morelinktext && $morelinklink){
$ajrv_widget_morelink = str_replace("[MORETEXT]", $morelinktext, $ajrv_widget_morelink);
$ajrv_widget_morelink = str_replace("[MORELINK]", $morelinklink, $ajrv_widget_morelink);
echo $ajrv_widget_morelink;
}
}else{
echo esc_html__( '리뷰가 없습니다.', 'ajreview' );
}
echo "";
}
public function form($instance){
global $table_prefix;
$ajrv_group = $table_prefix . 'ajrv_group';
$ajrv_category = $table_prefix . 'ajrv_category';
$ajrv_review = $table_prefix . 'ajrv_review';
$ajrv_review_item = $table_prefix . 'ajrv_review_item';
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$title = !empty( $instance['title'] ) ? $instance['title'] : esc_html__( __('Top 3 Items', 'ajreview' ), 'ajreview' );
$group = !empty( $instance['group'] ) ? $instance['group'] : esc_html__( __('리뷰 그룹', 'ajreview' ), 'ajreview' );
$skin = !empty( $instance['skin'] ) ? $instance['skin'] : esc_html__( __('스킨', 'ajreview' ), 'ajreview' );
$itemcount = !empty( $instance['itemcount'] ) ? $instance['itemcount'] : esc_html__( 3, 'ajreview' );
$filtervalue = !empty( $instance['filtervalue'] ) ? $instance['filtervalue'] : esc_html__( __('모두', 'ajreview' ), 'ajreview' );
$morelinktext = !empty( $instance['morelinktext'] ) ? $instance['morelinktext'] : esc_html__( __('더보기', 'ajreview' ), 'ajreview' );
$morelinklink = !empty( $instance['morelinklink'] ) ? $instance['morelinklink'] : '';
?>
>