/**
* 根据订单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);
}
}
