__('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 .= '
';
foreach($wpam_commission_tabs as $location => $tabname)
{
if($current == $location){
$class = ' nav-tab-active';
} else{
$class = '';
}
$content .= ''.$tabname.'';
}
$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();
}
?>
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 '
';
}
}
?>
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;
}
?>