예제 #1
0
    $tbl_users = $wpdb->get_var("SHOW TABLES LIKE \"%users\"");
    $user_db_table_name = $tbl_users;
} else {
    $user_db_table_name = $user_db_table_name1;
}
$authorsql_select = "select DISTINCT u.ID,u.user_nicename ";
$authorsql_from = " from {$user_db_table_name} u,{$post_table} p ";
$authorsql_conditions = " where u.ID = p.post_author and p.post_type = 'seller' ";
if ($_REQUEST['id'] != '') {
    $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));
                }
예제 #2
0
            ?>
</td>
      <td><?php 
            echo $priceinfoObj->user_nicename;
            ?>
</td>
      <td><?php 
            echo deal_count_post($priceinfoObj->ID);
            ?>
</td>
      <td><?php 
            echo deal_salecount_post($priceinfoObj->ID);
            ?>
</td>
      <td><?php 
            echo deal_salecount_post($priceinfoObj->ID);
            ?>
</td>
      <td><a href="javascript:void(0);showdetail('<?php 
            echo $priceinfoObj->ID;
            ?>
');"><?php 
            _e('Details', 'templatic');
            ?>
</a> | <a href="<?php 
            echo get_template_directory_uri() . '/monetize/report/export_report.php?id=' . $priceinfoObj->ID;
            ?>
"><?php 
            _e('Export', 'templatic');
            ?>
</a></td>
예제 #3
0
        echo FACEBOOK;
        ?>
</a>
        <?php 
    }
    ?>
      </p>
      <ul class="user_detail">
        <?php 
    if ($curauth->ID == $current_user->ID) {
        ?>
        <li><span><?php 
        echo DEAL_PURCHASE;
        ?>
 : </span><?php 
        echo deal_salecount_post($curauth->ID);
        ?>
</li>
        <?php 
    }
    ?>
        <li><span><?php 
    echo DEAL_PROVIDED;
    ?>
 : </span><?php 
    echo deal_count_post($curauth->ID);
    ?>
</li>
        <li><?php 
    echo get_user_meta($curauth->ID, 'user_about', true);
    ?>