/** * 根据订单id获取订单数据(产品类型) *@param $order_id订单id * @access public * @return bool */ public function get_order_by_id($order_id) { if ($order_id) { $order_arg = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->youpzt_order} where order_id=%d;", $order_id), ARRAY_A, 0); $order_meta_config = array('order_more_att', 'product_count', 'total_price'); //要获取的订单meta属性值 foreach ($order_meta_config as $key => $order_meta) { $order_arg[$order_meta] = get_order_meta($order_id, $order_meta, true); } return $order_arg; } }
/** * Define what data to show on each column of the table * * @param Array $item Data * @param String $column_name - Current column name * * @return Mixed */ public function column_default($item, $column_name) { switch ($column_name) { case 'product_thumb': $post_id = $item['product_id']; if (has_post_thumbnail($post_id)) { //如果有缩略图,则显示缩略图 $timthumb_src_arr = wp_get_attachment_image_src(get_post_thumbnail_id($post_id), 'full'); $timthumb_src = $timthumb_src_arr[0]; } else { $product_gallery = get_post_meta($post_id, 'product_gallery', true); if ($product_gallery) { //$attachment_img=wp_get_attachment_image($product_gallery[0], 'large'); $attachment_src = wp_get_attachment_image_src($product_gallery[0], 'full'); //$post_timthumb ='<img src="'.youpzt_timthumb($attachment_src[0],300,300).'" >'; $timthumb_src = $attachment_src[0]; } else { $timthumb_src = get_bloginfo("template_url") . '/images/noimage-thumbnail.jpg'; } } echo '<a href="admin.php?page=paimai_order_manage&status=product&productid=' . $post_id . '" title="查询该产品订单"><img src="' . $timthumb_src . '" class="product_thumb" width="70" height="60">'; break; case 'consumer': return get_the_author_meta('display_name', $item['consumer']); break; case 'total_price': return get_order_meta($item['order_id'], 'total_price', true) . '元'; break; case 'product_count': return get_order_meta($item['order_id'], 'product_count', true); break; case 'product_name': $product_obj = get_post($item['product_id']); return '<a href="' . get_permalink($item['product_id']) . '" target="_blank">' . $product_obj->post_title . '</a>'; break; case 'order_status': switch ($item[$column_name]) { case -1: echo '<span class="color-info">已取消</span>'; break; case 0: echo '<span class="color-info">购物车</span>'; break; case 1: echo '<span class="color-warning">待付款</span>'; break; case 2: echo '<span class="color-primary">待发货</span>'; break; case 3: echo '<span class="color-warning">已发货</span>'; break; case 4: echo '<span class="color-success">完成已收货</span>'; break; default: echo '<span class="color-info">暂无</span>'; break; } break; case 'youpzt_list_option': return '<a href="/wp-admin/admin.php?page=orders_manage&order_id=' . $item['order_id'] . '">查看编辑</a> '; //<a href="?page=paimai_order_manage&action=delete&order['.$item['id'].']"><abbr title="删除" rel="tooltip"><i class="iconfont icon-clean fb f20"></i></abbr></a> break; case 'user_id': case 'order_time': return $item[$column_name]; default: return print_r($item, true); } }