function prepare_items() { global $wpdb; global $table_prefix; global $date_format; $per_page = 30; $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); //======== Search code $usersearch = isset($_REQUEST['search']) ? trim($_REQUEST['search']) : ''; extract($_REQUEST); if (!isset($epin_status) && !isset($search) && !isset($epin_value)) { $sql = "SELECT * FROM {$table_prefix}mlm_epins ORDER BY id ASC"; } else { if (isset($epin_status) && $epin_status != '' && isset($epin_value) && $epin_value != '' && !empty($search)) { $amt = $epin_value; $where = " WHERE status='" . $epin_status . "' AND p_id='" . $amt . "' AND epin_no like '%" . trim($search) . "%'"; } else { if (isset($epin_status) && $epin_status != '' && isset($epin_value) && $epin_value != '') { $amt = $epin_value; $where = " WHERE status='" . $epin_status . "' AND p_id='" . $amt . "'"; } else { if (isset($epin_value) && $epin_value != '' && !empty($search)) { $amt = $epin_value; $where = " WHERE p_id='" . $amt . "' AND epin_no like '%" . trim($search) . "%'"; } else { if (isset($epin_status) && $epin_status != '' && !empty($search)) { $where = " WHERE status='" . $epin_status . "' AND epin_no like '%" . trim($search) . "%'"; } else { if (isset($epin_status) && $epin_status != '') { $where = " WHERE status='" . $epin_status . "' "; } else { if (isset($epin_value) && $epin_value != '') { $amt = $epin_value; $where = " WHERE p_id='" . $amt . "' "; } else { if (!empty($search)) { $where = " WHERE epin_no like '%" . trim($search) . "%' "; } } } } } } } $sql = "SELECT * FROM {$table_prefix}mlm_epins {$where} ORDER BY id ASC"; } $this->_column_headers = array($columns, $hidden, $sortable); $rs = mysql_query($sql); $i = 0; //$ID = 1; $listArr = array(); if (mysql_num_rows($rs) > 0) { while ($row = mysql_fetch_array($rs)) { $user_id = getuseruidbykey($row['user_key']); $firstname = get_user_meta($user_id, 'first_name', true); $lastname = get_user_meta($user_id, 'last_name', true); $genaral_date = get_option('links_updated_date_format'); if ($row['date_used'] == '0000-00-00 00:00:00') { $used_date = ''; } else { $used_date = date("{$genaral_date}", strtotime($row['date_used'])); } if ($row['date_generated'] == '0000-00-00 00:00:00') { $genarated_on = ''; } else { $genarated_on = date("{$genaral_date}", strtotime($row['date_generated'])); } $price = $wpdb->get_var("select product_price from {$table_prefix}mlm_product_price where p_id='" . $row['p_id'] . "'"); $type = $row['point_status'] == '1' ? 'Regular' : 'Free'; $listArr[$i]['epin'] = $row['epin_no']; $listArr[$i]['epinprice'] = $price; $listArr[$i]['username'] = getusernamebykey($row['user_key']); $listArr[$i]['firstname'] = $firstname; $listArr[$i]['lastname'] = $lastname; $listArr[$i]['type'] = $type; $listArr[$i]['genarated_on'] = $genarated_on; $listArr[$i]['date_used'] = $used_date; $i++; } } /*if(!empty($usersearch)){ extract($_REQUEST); $epin_status=isset($epin_status) &&!empty($epin_status)? " AND status='$epin_status'":""; $this->_column_headers = array($columns, $hidden, $sortable); if(isset($epin_value) && ($epin_value!='')) { $amount=10000*$epin_value; $epin_status.=" AND epin_price=$amount"; } $sql = "SELECT * FROM {$table_prefix}mlm_epins where epin_no like '%$usersearch%' $epin_status"; $rs = mysql_query($sql); $listArr = array(); if(mysql_num_rows($rs)>0){ $i=0; while($row = mysql_fetch_array($rs)){ $user_id=empty($row['user_key'])?'':getuseruidbykey($row['user_key']); $firstname=empty($user_id)?'':get_user_meta($user_id, 'first_name', true); $lastname=empty($user_id)?'':get_user_meta($user_id, 'last_name', true); $genaral_date=get_option('links_updated_date_format'); if($row['date_used']=='0000-00-00 00:00:00') { $used_date=''; } else { $used_date=date("$genaral_date",strtotime($row['date_used'])); } if($row['date_generated']=='0000-00-00 00:00:00') { $genarated_on=''; } else { $genarated_on=date("$genaral_date",strtotime($row['date_generated'])); } $type=$row['point_status']=='1'?'Regular':'Free'; $listArr[$i]['epin'] = $row['epin_no']; $listArr[$i]['epinprice'] = $row['epin_price']; $listArr[$i]['username'] = getusernamebykey($row['user_key']); $listArr[$i]['firstname'] = $firstname; $listArr[$i]['lastname'] = $lastname; $listArr[$i]['type'] = $type; $listArr[$i]['genarated_on'] = $genarated_on; $listArr[$i]['date_used'] = $used_date; $i++; } }} else { //=search code end $this->_column_headers = array($columns, $hidden, $sortable); extract($_REQUEST); if(isset($epin_status) && !empty($epin_status)) { if($epin_status==1 || $epin_status==0) $status=" WHERE status=$epin_status"; } else { $status=""; } if(isset($epin_value) && ($epin_value!='')) { if($status!='') { $amount=10000*$epin_value; $status.= " AND epin_price=$amount"; } else { $amount=10000*$epin_value; $status=" WHERE epin_price=$amount"; } } $sql = "SELECT * FROM {$table_prefix}mlm_epins $status ORDER BY id ASC"; $rs = mysql_query($sql); $i = 0; //$ID = 1; $listArr = array(); if(mysql_num_rows($rs)>0){ while($row = mysql_fetch_array($rs)) { $user_id=getuseruidbykey($row['user_key']); $firstname=get_user_meta($user_id, 'first_name', true); $lastname=get_user_meta($user_id, 'last_name', true); $genaral_date=get_option('links_updated_date_format'); if($row['date_used']=='0000-00-00 00:00:00') { $used_date=''; } else { $used_date=date("$genaral_date",strtotime($row['date_used'])); } if($row['date_generated']=='0000-00-00 00:00:00') { $genarated_on=''; } else { $genarated_on=date("$genaral_date",strtotime($row['date_generated'])); } $type=$row['point_status']=='1'?'Regular':'Free'; $listArr[$i]['epin'] = $row['epin_no']; $listArr[$i]['epinprice'] = $row['epin_price']; $listArr[$i]['username'] = getusernamebykey($row['user_key']); $listArr[$i]['firstname'] = $firstname; $listArr[$i]['lastname'] = $lastname; $listArr[$i]['type'] = $type; $listArr[$i]['genarated_on'] = $genarated_on; $listArr[$i]['date_used'] = $used_date; $i++; } } }*/ $data = $listArr; /* function usort_reorder($a,$b){ $orderby = (!empty($_REQUEST['orderby'])) ? $_REQUEST['orderby'] : 'id'; $order = (!empty($_REQUEST['order'])) ? $_REQUEST['order'] : 'DESC'; $result = strcmp($a[$orderby], $b[$orderby]); return ($order==='ASC') ? $result : -$result; } usort($data, 'usort_reorder'); */ $current_page = $this->get_pagenum(); $total_items = count($data); $data = array_slice($data, ($current_page - 1) * $per_page, $per_page); $this->items = $data; $this->set_pagination_args(array('total_items' => $total_items, 'per_page' => $per_page, 'total_pages' => ceil($total_items / $per_page))); }
function mlm_ePins_reports() { global $wpdb, $table_prefix; require_once 'epin-reports-list-table.php'; $objEpinList = new EpinReports_List_Table(); $objEpinList->prepare_items(); extract($_REQUEST); if (isset($page)) { $url = 'page=' . $page; } if (isset($epin_status)) { $url .= '&epin_status=' . $epin_status; } else { $url .= ''; } $epin_status1 = isset($epin_status) ? $epin_status : ''; $epin_value1 = isset($epin_value) ? $epin_value : ''; ?> <div class='wrap'> <div id="icon-users" class="icon32"></div><h1><?php _e('ePin Report', 'unilevel-mlm-pro'); ?> </h1></div> <div class="notibar msginfo" style="margin:10px;"> <a class="close"></a> <p><?php _e('The report below lists all the ePins that have been generated on your site. Filter the results to see just the Used Pins or Unused Pins. To revert back to the default listing click the Reset Button.', 'unilevel-mlm-pro'); ?> </p> <p><?php _e('The <strong>Search</strong> and <strong>Export to CSV</strong> funtions will work on the currently active Recordset i.e. if you are currently on the Used ePin Filter then performing a search or Exporting to CSV will apply only to the Used ePins.', 'unilevel-mlm-pro'); ?> </p> </div> <?php $mlm_settings = get_option('wp_mlm_general_settings'); if (isset($mlm_settings['ePin_activate']) && $mlm_settings['ePin_activate'] == '1') { ?> <div style="margin-left:10px;float:left;text-decoration:none;"> <a class="button" style="text-decoration: none;" href="<?php echo admin_url() . "admin.php?page=" . $_REQUEST['page'] . "&tab=epinreports"; ?> "><?php _e('Reset', 'unilevel-mlm-pro'); ?> </a> </div> <div style="margin-right:10px;float:right"> <form action="" method="get" style="float:right;"> <input type="hidden" name="page" value="admin-reports" /> <input type="hidden" name="tab" value="epinreports" /> <input type="hidden" name="epin_status" value="<?php echo $epin_status1; ?> " /> <input type="hidden" name="epin_value" value="<?php echo $epin_value1; ?> " /> <input type="text" name="search"/><input type="submit" value="<?php _e('Search', 'unilevel-mlm-pro'); ?> " class="button"/> </form> </div> <form id="project-filter" method="GET" action=""> <input type="hidden" name="page" value="<?php echo $_REQUEST['page']; ?> " /> <input type="hidden" name="tab" value="epinreports" /> <?php $objEpinList->display(); ?> </form> <?php if (!isset($epin_status) && !isset($search) && !isset($epin_value)) { $sql = "SELECT * FROM {$table_prefix}mlm_epins ORDER BY id ASC"; } else { if (isset($epin_status) && $epin_status != '' && isset($epin_value) && $epin_value != '' && !empty($search)) { $amt = $epin_value; $where = " WHERE status='" . $epin_status . "' AND p_id='" . $amt . "' AND epin_no like '%" . trim($search) . "%'"; } else { if (isset($epin_status) && $epin_status != '' && isset($epin_value) && $epin_value != '') { $amt = $epin_value; $where = " WHERE status='" . $epin_status . "' AND p_id='" . $amt . "'"; } else { if (isset($epin_value) && $epin_value != '' && !empty($search)) { $amt = $epin_value; $where = " WHERE p_id='" . $amt . "' AND epin_no like '%" . trim($search) . "%'"; } else { if (isset($epin_status) && $epin_status != '' && !empty($search)) { $where = " WHERE status='" . $epin_status . "' AND epin_no like '%" . trim($search) . "%'"; } else { if (isset($epin_status) && $epin_status != '') { $where = " WHERE status='" . $epin_status . "' "; } else { if (isset($epin_value) && $epin_value != '') { $amt = $epin_value; $where = " WHERE p_id='" . $amt . "' "; } else { if (!empty($search)) { $where = " WHERE epin_no like '%" . trim($search) . "%' "; } } } } } } } /* $status=(isset($epin_status) && $epin_status!='')? " status='$epin_status'":""; $usersearch =!empty($search)? " epin_no like '%".trim($search)."%'" : ''; if(isset($epin_value) && $epin_value!='') { $amt=10000*$epin_value; $price="epin_price='".$amt."'"; } else { $price=""; } $where=isset($status) || !empty($usersearch) ? ' WHERE' : ''; $and=isset($status) && !empty($usersearch) ? ' AND' : ''; echo $status; if($and=='') { $epinPrice=' AND '.$price; } else { if($status=='') { $epinPrice=$price; } else { $epinPrice=' AND '.$price; } }*/ //$status=" WHERE status=$epin_status"; //$status $and $usersearch $epinPrice $sql = "SELECT * FROM {$table_prefix}mlm_epins {$where} ORDER BY id ASC"; } //echo $sql; $rs = mysql_query($sql); $i = 0; $listArr = array(); $listArr[-1]['epin'] = __('Pin No.', 'unilevel-mlm-pro'); $listArr[-1]['epinprice'] = __('Pin Price', 'unilevel-mlm-pro'); $listArr[-1]['username'] = __('User Name', 'unilevel-mlm-pro'); $listArr[-1]['firstname'] = __('First Name', 'unilevel-mlm-pro'); $listArr[-1]['lastname'] = __('Last Name', 'unilevel-mlm-pro'); $listArr[-1]['type'] = __('Type', 'unilevel-mlm-pro'); $listArr[-1]['genarated_on'] = __('Generated On', 'unilevel-mlm-pro'); $listArr[-1]['date_used'] = __('Used Date', 'unilevel-mlm-pro'); if (mysql_num_rows($rs) > 0) { while ($row = mysql_fetch_array($rs)) { $user_id = getuseruidbykey($row['user_key']); $firstname = get_user_meta($user_id, 'first_name', true); $lastname = get_user_meta($user_id, 'last_name', true); $genaral_date = get_option('links_updated_date_format'); if ($row['date_used'] == '0000-00-00 00:00:00') { $used_date = ''; } else { $used_date = date("{$genaral_date}", strtotime($row['date_used'])); } if ($row['date_generated'] == '0000-00-00 00:00:00') { $genarated_on = ''; } else { $genarated_on = date("{$genaral_date}", strtotime($row['date_generated'])); } $price = $wpdb->get_var("select product_price from {$table_prefix}mlm_product_price where p_id='" . $row['p_id'] . "'"); $type = $row['point_status'] == '1' ? 'Regular' : 'Free'; $listArr[$i]['epin'] = $row['epin_no']; $listArr[$i]['epinprice'] = $price; $listArr[$i]['username'] = getusernamebykey($row['user_key']); $listArr[$i]['firstname'] = $firstname; $listArr[$i]['lastname'] = $lastname; $listArr[$i]['type'] = $type; $listArr[$i]['genarated_on'] = $genarated_on; $listArr[$i]['date_used'] = $used_date; $i++; } } $value = serialize($listArr); ?> <form method="post" action="<?php echo plugins_url(); ?> /unilevel-mlm-pro/mlm_html/export.php"> <input type="hidden" name ="listarray" value='<?php echo $value; ?> ' /> <input type="hidden" name ="filename" value='epin-report' /> <input type="submit" name="export_csv" value="<?php _e('Export to CSV', 'unilevel-mlm-pro'); ?> " class="button-primary"/></form> <?php } else { ?> <div style="padding: 20px;width: 84%;margin: 0 auto;"> <?php _e('It seems you have not activated the ePin functionality under Settings -> General. ePin Report is accessible only with that setting set to Yes.', 'unilevel-mlm-pro'); ?> <br> <?php _e('Click', 'unilevel-mlm-pro'); ?> <a href="<?php echo admin_url() . "admin.php?page=admin-settings"; ?> "><?php _e('<strong>Here</strong>', 'unilevel-mlm-pro'); ?> </a> <?php _e(' to go to Settings -> General and activate the ePin functionality.', 'unilevel-mlm-pro'); ?> </div> <?php } }