__('Overall Commissions', 'affiliates-manager'), 'wpam-commission&action=manual-commission' => __('Manual Commission', 'affiliates-manager'), ); if(isset($_GET['page'])){ $current = sanitize_text_field($_GET['page']); if(isset($_GET['action'])){ $current .= "&action=".sanitize_text_field($_GET['action']); } } $content = ''; $content .= ''; echo $content; if(isset($_GET['action']) && $_GET['action'] == "manual-commission"){ wpam_display_manual_commission_tab(); } else if(isset($_GET['action']) && $_GET['action'] == "edit-commission"){ wpam_display_edit_commission_tab(); } else{ wpam_display_overall_commission_tab(); } ?>

prepare_items(); ?>
display() ?>
affiliateId; $data['type'] = 'credit'; $data['description'] = $description; $data['amount'] = $creditAmount; $wpdb->insert( $table, $data); */ if (isset($_POST['wpam_manual_commission_save'])) { $nonce = $_REQUEST['_wpnonce']; if ( !wp_verify_nonce($nonce, 'wpam_manual_commission_save')){ wp_die('Error! Nonce Security Check Failed! Go back to the manual commission menu and add a commission again.'); } $error_msg = ''; $aff_id = sanitize_text_field($_POST["wpam_aff_id"]); if(empty($aff_id)){ $error_msg .= '

'.__('You need to enter an affiliate ID', 'affiliates-manager').'

';; } $commission_amt = sanitize_text_field($_POST["wpam_commission_amt"]); if(!is_numeric($commission_amt)){ $error_msg .= '

'.__('You need to enter a numeric commission amount', 'affiliates-manager').'

';; } $purchase_amt = sanitize_text_field($_POST["wpam_purchase_amt"]); if(!is_numeric($purchase_amt)){ $error_msg .= '

'.__('You need to enter a numeric purchase amount', 'affiliates-manager').'

';; } $txn_id = sanitize_text_field($_POST["wpam_txn_id"]); if(empty($txn_id)){ $txn_id = uniqid(); } $buyer_email = sanitize_email($_POST["wpam_buyer_email"]); $date_created = sanitize_text_field($_POST["wpam_date_created"]); if(isset($date_created) && date("Y-m-d", strtotime($date_created)) === $date_created){ //valid date } else{ $date_created = date("Y-m-d"); } $time_created = date("H:i:s"); $selected_date = $date_created." ".$time_created; $mysql_date_created = date("Y-m-d H:i:s", strtotime($selected_date)); global $wpdb; $table = WPAM_TRANSACTIONS_TBL; $query = " SELECT * FROM ".$table." WHERE referenceId = %s "; $txn_record = $wpdb->get_row($wpdb->prepare($query, $txn_id)); if($txn_record != null) { //found a record $error_msg .= '

'.__('A commission with this transaction ID already exists', 'affiliates-manager').'

'; } if(empty($error_msg)){ //no error in form submission $args = array(); $args['date_modified'] = $mysql_date_created; $args['date_created'] = $mysql_date_created; $args['txn_id'] = $txn_id; $args['aff_id'] = $aff_id; $args['amount'] = $purchase_amt; $args['manual_comm_amount'] = $commission_amt; if(isset($buyer_email) && !empty($buyer_email)){ $args['email'] = $buyer_email; } WPAM_Commission_Tracking::award_commission($args); echo '

'; echo __('Commission added!', 'affiliates-manager'); echo '

'; } else{ echo '

'; echo $error_msg; echo '

'; } } ?>

1

5.00

15.00

1423

" class="regular-text">

2015-09-17

affiliateId; $data['type'] = 'credit'; $data['description'] = $description; $data['amount'] = $creditAmount; $wpdb->insert( $table, $data); */ global $wpdb; $table = WPAM_TRANSACTIONS_TBL; if(!isset($_GET['page']) || $_GET['page'] != "wpam-commission"){ return; } if(!isset($_GET['action']) || $_GET['action'] != "edit-commission"){ return; } if(!isset($_GET['edit_rowid']) || empty($_GET['edit_rowid'])){ return; } $edit_rowid = sanitize_text_field($_GET['edit_rowid']); if (isset($_POST['wpam_edit_commission_save'])) { $nonce = $_REQUEST['_wpnonce']; if(!wp_verify_nonce($nonce, 'wpam_edit_commission_save')){ wp_die(__('Error! Nonce Security Check Failed! Go back to the Commissions menu and edit the commission again.', 'affiliates-manager')); } $data = array(); $error = false; $aff_id = sanitize_text_field($_POST["wpam_aff_id"]); if(empty($aff_id)){ $error = true; echo '

'; echo __('You need to enter an affiliate ID', 'affiliates-manager'); echo '

'; } $data['affiliateId'] = $aff_id; $commission_amt = sanitize_text_field($_POST["wpam_commission_amt"]); if(!is_numeric($commission_amt)){ $error = true; echo '

'; echo __('You need to enter a numeric commission amount', 'affiliates-manager'); echo '

'; } $data['amount'] = $commission_amt; $txn_id = sanitize_text_field($_POST["wpam_txn_id"]); if(empty($txn_id)){ $error = true; echo '

'; echo __('You need to enter a unique transaction ID', 'affiliates-manager'); echo '

'; } $data['referenceId'] = $txn_id; $buyer_email = sanitize_email($_POST["wpam_buyer_email"]); $data['email'] = $buyer_email; $date_created = sanitize_text_field($_POST["wpam_date_created"]); if(isset($date_created) && date("Y-m-d H:i:s", strtotime($date_created)) === $date_created){ //valid date $data['dateModified'] = $date_created; $data['dateCreated'] = $date_created; } else{ $error = true; echo '

'; echo __('You need to enter a valid date', 'affiliates-manager'); echo '

'; } if(!$error){ $where = array('transactionId' => $edit_rowid); $updated = $wpdb->update($table, $data, $where); if(false === $updated) { echo '

'; echo __('Commission could not be updated', 'affiliates-manager'); echo '

'; } else{ echo '

'; echo __('Commission updated!', 'affiliates-manager'); echo '

'; } } } $query = " SELECT * FROM ".$table." WHERE transactionId = %s "; $result = $wpdb->get_row($wpdb->prepare($query, $edit_rowid)); if($result === null) { //no record found $error_msg .= '

'.__('Commission could not be found', 'affiliates-manager').'

'; return $error_msg; } ?>

1

5.00

1423

2022-01-20 05:04:54