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>'; } }
$authorsql_conditions .= " and p.post_author = '" . $_REQUEST['id'] . "'"; } $authorinfo = $wpdb->get_results($authorsql_select . $authorsql_from . $authorsql_conditions); if ($authorinfo) { foreach ($authorinfo as $authorObj) { echo "ID,Seller,Deal,Sale,Customer\r "; echo "{$authorObj->ID},{$authorObj->user_nicename}," . deal_count_post($authorObj->ID) . "," . deal_salecount_post($authorObj->ID) . "," . deal_salecount_post($authorObj->ID) . " \r\n\r\n"; $deal_cnt = $wpdb->get_results("select ID,post_title from {$post_table} where post_author = '" . $authorObj->ID . "' and post_type='seller' and post_status = 'publish'"); if ($deal_cnt) { $cnt = 0; $count = count($deal_cnt); echo "Post ID,Title,Original Price,Discounted Price,Start Time,End Time,Status\r\n"; foreach ($deal_cnt as $postObj) { $cnt++; $post_title = str_replace(',', ' ', $postObj->post_title); $status = ifetch_status(get_post_meta($postObj->ID, 'status', true), get_post_meta($postObj->ID, 'is_expired', true)); if (get_post_meta($postObj->ID, 'coupon_start_date_time', true) != '') { $start_date = date("Y-m-d H:i:s", get_post_meta($postObj->ID, 'coupon_start_date_time', true)); } if (get_post_meta($postObj->ID, 'coupon_end_date_time', true) != '') { $end_date = date("Y-m-d H:i:s", get_post_meta($postObj->ID, 'coupon_start_date_time', true)); } echo "{$postObj->ID},{$post_title}," . get_post_meta($postObj->ID, 'current_price', true) . "," . get_post_meta($postObj->ID, 'our_price', true) . ",{$start_date},{$end_date},{$status}\r\n"; if ($cnt == $count) { echo "\r\n"; } } } } } else { echo "No record available";
$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";