= '".$my_income_from_date."' AND DATE(income_date) <= '".$my_income_to_date."'"; } $my_income_search = $_REQUEST['my_income_search']; } $egSql = "SELECT * FROM ".APM_MY_INCOME." WHERE 1$where_clause"; $egSql = $egSql . " ORDER BY ID DESC"; $egRecord = array(); $total_record = count($wpdb->get_results($egSql, ARRAY_A)); //--> Pagination Section $items_per_page = 50; $page = isset( $_GET['cpage'] ) ? abs( (int) sanitize_text_field($_GET['cpage']) ) : 1; $offset = ( $page * $items_per_page ) - $items_per_page; $limit_query = " LIMIT ".$items_per_page." OFFSET ".$offset; $egRecord = $wpdb->get_results($egSql.$limit_query,OBJECT); // return OBJECT ?>

My Income

0) { $i = 1; $total_amount = 0; $total_ccommission_amount = 0; foreach ($egRecord as $record) { $bgColor = $redColor = $append = ''; $commision_amount = $record->inc_commision_amt; $total_amount += $record->inc_ctransamount; if($record->inc_ctransaction == 'RFND' || $record->inc_ctransaction == 'CGBK' || $record->inc_ctransaction == 'INSF') { $bgColor = ' style="boarder:1px solid #F00"'; $redColor = ' style="color: #F00"'; $append = '-'; $total_ccommission_amount -= $commision_amount; } else { $total_ccommission_amount += $commision_amount; } if(is_numeric($record->inc_caffitid)) { $inc_caffitid = $record->inc_caffitid; } else { $inc_caffitid = ""; } ?> > cron_status) == 'No'){ echo "Pending"; } else { ?> $
# Name Item Clickid Type Transaction Payment Method Amount Commission Amount Processed JVZoo Captured Date ClickMagick Proceed Date
# Name Item Clickid Type Transaction Payment Method Amount Commission Amount Processed JVZoo Captured Date ClickMagick Proceed Date
inc_ccustname); ?> inc_cproditem); ?> inc_cprodtype); ?> inc_ctransaction); ?> inc_ctranspaymentmethod); ?> $inc_ctransamount), 2, '.', ''); ?> cron_status) == 'No'){ echo "Pending"; } else { ?>inc_processed) == 'Yes'){ echo "Yes"; } else { ?> Untraceable income_date))); ?> magic_postback_date != "0000-00-00 00:00:00" && $record->magic_postback_date != ""){ echo date("m-d-Y H:i:s", strtotime(esc_html($record->magic_postback_date))); }?>
Totals $ $
add_query_arg( 'cpage', '%#%' ), 'format' => '', 'prev_text' => __('«'), 'next_text' => __('»'), 'total' => ceil($total_record / $items_per_page), 'current' => $page, 'add_args' => array( 'my_income_from_date' => sanitize_text_field($my_income_from_date), 'my_income_to_date' => sanitize_text_field($my_income_to_date), 'my_income_search' => sanitize_text_field($my_income_search)), )); ?>
X

This income cannot be traced back to Clickmagick perhaps customer originated from an organic traffic source