function upcoming_transaction_dashboard_widget() { $args = array('meta_key' => 'is_expired', 'meta_value' => '0', 'post_status' => 'publish', 'post_type' => CUSTOM_POST_TYPE1, 'orderby' => 'DESC'); $live_posts = get_posts($args); if ($live_posts) { echo '<link href="' . get_template_directory_uri() . '/monetize/admin.css" rel="stylesheet" type="text/css" />'; echo '<table class="widefat" width="100%" > <thead> <tr> <th valign="top" align="left">ID</th> <th valign="top" align="left">Deal Title</th> <th valign="top" align="left">Total Transaction</th> <th valign="top" align="left">Original Price</th> <th valign="top" align="left">Discounted Price</th> <th valign="top" align="left">Status</th> </tr>'; foreach ($live_posts as $post) { if (get_post_meta($post->ID, 'status', true) == '1' || get_post_meta($post->ID, 'status', true) == '2') { $status = ifetch_status(get_post_meta($post->ID, 'status', true), get_post_meta($post->ID, 'is_expired', true)); if ($status == 'Pending') { $status_dis = "<span class='color_pending'>Pending</span>"; } else { if ($status == 'Expired') { $status_dis = "<span class='color_expire'>Expired</span>"; } else { if ($status == 'Accepted') { $status_dis = "<span class='color_active'>Accepted</span>"; } else { if ($status == 'Active') { $status_dis = "<span class='color_active'>Active</span>"; } else { if ($status == 'Rejected') { $status_dis = "<span class='color_reject'><strong>Rejected</strong></span>"; } else { $status_dis = "<span class='color_terminate'><strong>Terminated</strong></span>"; } } } } } echo '<tr> <td valign="top" align="left">' . $post->ID . '</td> <td valign="top" align="left"><a href="' . site_url() . '/wp-admin/admin.php?page=report&deal_id=' . $post->ID . '#option_deal_report">' . $post->post_title . '</a></td> <td valign="top" align="left">' . deal_transaction($post->ID) . '</td> <td valign="top" align="left">' . get_currency_sym() . get_post_meta($post->ID, 'current_price', true) . '</td> <td valign="top" align="left">' . get_currency_sym() . get_post_meta($post->ID, 'our_price', true) . '</td> <td valign="top" align="left">' . $status_dis . '</td>'; } } echo '</thead> </table>'; } }
function templatic_manage_seller_columns($column, $post_id) { echo '<link href="' . get_template_directory_uri() . '/monetize/admin.css" rel="stylesheet" type="text/css" />'; global $post; switch ($column) { /* If displaying the 'status' column. */ case 'status': /* Get the post meta. */ $status = fetch_status(get_post_meta($post_id, 'status', true), get_post_meta($post_id, 'is_expired', true)); /* If no status is found, output a default message. */ _e($status, 'templatic'); break; /* If displaying the 'coupon_start_date_time' column. */ /* If displaying the 'coupon_start_date_time' column. */ case 'coupon_start_date_time': /* Get the coupon_start_date_time for the post. */ $coupon_start_date_time = get_post_meta($post_id, 'coupon_start_date_time', true); /* If coupon_start_date_time were found. */ if ($coupon_start_date_time != '') { echo date('Y-m-d H:i:s', $coupon_start_date_time); } else { _e('Unknown'); } break; case 'coupon_end_date_time': /* Get the coupon_end_date_time for the post. */ $coupon_end_date_time = get_post_meta($post_id, 'coupon_end_date_time', true); /* If coupon_end_date_time were found. */ if (!empty($coupon_end_date_time)) { echo date('Y-m-d H:i:s', $coupon_end_date_time); } else { _e('Continue deal'); } break; case 'deal_sold': /* Get the deal_sold for the post. */ $deal_sold = deal_transaction($post_id); /* If deal_sold were found. */ if (!empty($deal_sold)) { echo $deal_sold; } else { _e('0'); } break; case 'post_category': /* Get the post_category for the post. */ if (templ_is_show_post_category()) { $category = get_the_taxonomies($post); $category_display = str_replace(CUSTOM_MENU_CAT_TITLE . ':', '', $category['seller_category']); $category_display = str_replace(' and ', ', ', $category_display); echo $category_display = str_replace(',,', ', ', $category_display); } else { _e('Uncategorized'); } break; case 'post_tags': /* Get the post_tags for the post. */ $tags = get_the_taxonomies($post); $tags_display = str_replace(CUSTOM_MENU_TAG_TITLE . ':', '', $tags['seller_tags']); $tags_display = str_replace(' and ', ', ', $tags_display); echo $tags_display = str_replace(',,', ', ', $tags_display); break; case 'total_item': /* Get the total_item for the post. */ $total_item = get_post_meta($post_id, 'no_of_coupon', true); /* If terms were found. */ if (!empty($total_item)) { echo $total_item; } else { _e('0'); } break; /* Just break out of the switch statement for everything else. */ /* Just break out of the switch statement for everything else. */ default: break; } }
} } } } ?> <tr> <td><?php echo $priceinfoObj->ID; ?> </td> <td><?php echo $priceinfoObj->post_title; ?> </td> <td><?php echo deal_transaction($priceinfoObj->ID); ?> </td> <td><?php echo $status_dis; ?> </td> <td><a href="javascript:void(0);dealshowdetail('<?php echo $priceinfoObj->ID; ?> ');"><?php _e('Details', 'templatic'); ?> </a> | <a href="<?php echo get_template_directory_uri() . '/monetize/report/export_dealreport.php?deal_id=' . $priceinfoObj->ID; ?>
$trans_table = $wpdb->prefix . "deal_transaction"; $post_table = $wpdb->prefix . "posts"; $ordersql_select = "select t.*,p.ID "; $ordersql_from = " from {$trans_table} t,{$post_table} p "; $ordersql_conditions = " where p.ID = t.post_id and t.status = '1'"; if ($_REQUEST['deal_id'] != '') { $id = $_REQUEST['deal_id']; $ordersql_conditions .= " and t.post_id = {$id}"; } $ordersql_conditions .= " group by p.ID"; $priceinfo_count = $wpdb->get_results($ordersql_select . $ordersql_from . $ordersql_conditions); if ($priceinfo_count > 0) { foreach ($priceinfo_count as $priceinfoObj) { $post_title = str_replace(',', ' ', $priceinfoObj->post_title); echo "ID,Title,Total Transaction,Status\r "; echo "{$priceinfoObj->ID},{$post_title}," . deal_transaction($priceinfoObj->ID) . "," . ($status = ifetch_status(get_post_meta($post->ID, 'status', true), get_post_meta($post->ID, 'is_expired', true)) . " \r\n \r\n"); $deal_cnt = $wpdb->get_results("select * from {$trans_table} where post_id = '" . $priceinfoObj->ID . "' and status = '1'"); if (count($deal_cnt) > 0) { echo "Title,Deal Coupon,Pay Date,Billing name,Billing address,Shipping name, Shipping address,Pay Method,Amount\r\n"; $trans_table = $wpdb->prefix . "deal_transaction"; foreach ($deal_cnt as $postObj) { $sub_post_title = str_replace(',', ' ', $postObj->post_title); $billing_add = str_replace(array(',', '<br />'), ' ', $postObj->billing_add); $shipping_add = str_replace(array(',', '<br />'), ' ', $postObj->shipping_add); echo "{$sub_post_title},{$postObj->deal_coupon}," . date('d/m/Y', strtotime($postObj->payment_date)) . ",{$postObj->billing_name},{$billing_add},{$postObj->shipping_name},{$shipping_add},{$postObj->payment_method}," . get_currency_sym() . number_format($postObj->payable_amt, 2) . " \r"; } } echo "\r\n"; } } else { echo "No record available";