'.__('You need to enter an affiliate ID', 'affiliates-manager').'
';; } $commission_amt = trim($_POST["wpam_commission_amt"]); if(!is_numeric($commission_amt)){ $error_msg .= ''.__('You need to enter a numeric commission amount', 'affiliates-manager').'
';; } $purchase_amt = trim($_POST["wpam_purchase_amt"]); if(!is_numeric($purchase_amt)){ $error_msg .= ''.__('You need to enter a numeric purchase amount', 'affiliates-manager').'
';; } $txn_id = trim($_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 $currency = WPAM_MoneyHelper::getCurrencyCode(); $description = "Credit for sale of $purchase_amt $currency (PURCHASE LOG ID = $txn_id)"; $data = array(); $data['dateModified'] = $mysql_date_created; $data['dateCreated'] = $mysql_date_created; $data['referenceId'] = $txn_id; $data['affiliateId'] = $aff_id; $data['type'] = 'credit'; $data['description'] = $description; $data['amount'] = $commission_amt; $data['email'] = $buyer_email; $wpdb->insert( $table, $data); echo ''; echo __('Commission added!', 'affiliates-manager'); echo '
'; echo $error_msg; echo '