hasPermission("access_to_update_section")) { header('location: '.get_absolute_url().'tracking202/'); die(); } function about_revenue_upload() { echo '

Upload Revenue Report '; showHelp("update"); echo '

This area allows you to upload the revenue reports from your affiliate networks. You can now upload the exact sale amount that each subid generated, unlike before were Prosper202 summed the flat-payout on each item, you can now upload the exact revenue that was generated per subid. This is specifcally helpfull if you are receiving a commission of a percentage based or if you constantly get more than one lead for each subid.

'; } $upload_dir = dirname(__FILE__) . '/reports/'; switch ($_GET['case']) { case 1: #else it worked ok, save the csv to file, and then ask them what fields are what $file = $upload_dir . $_GET['file']; if (!file_exists($file)) { template_top('Upload Revenue Reports',NULL,NULL,NULL); about_revenue_upload(); echo '

This file does not exist that you are trying to import
or you have already successfully uploaded it.

'; template_bottom(); die(); } template_top('Upload Revenue Reports',NULL,NULL,NULL); about_revenue_upload(); echo '

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; $handle = fopen($file, 'rb'); $row = @fgetcsv($handle, 100000, ","); for ($x = 0; $x < count($row); $x++) { $html = array_map('htmlentities', $row); echo ''; echo ''; echo ''; echo ''; } echo '

Column Name	Subid Column	Commission Column
'.$html[$x].'	'; echo '

'; echo '

'; echo ''; echo '

'; template_bottom(); break; case 2: if ( (!is_numeric($_GET['click_id'])) or (!is_numeric($_GET['click_payout'])) ) { $file = $_GET['file']; template_top('Upload Revenue Reports',NULL,NULL,NULL); about_revenue_upload(); echo '

You forgot to check the subid and the commission column, please try again

'; template_bottom(); die(); } $file = $upload_dir . $_GET['file']; if (!file_exists($file)) { template_top('Upload Revenue Reports',NULL,NULL,NULL); about_revenue_upload(); echo '

This file does not exist that you are trying to import or you have already successfully uploaded it.

'; template_bottom(); die(); } $click_payouts = array(); $handle = fopen($file, 'rb'); $de = new DataEngine(); while ($row = @fgetcsv($handle, 100000, ",")) { #store all the subid values and payouts $click_id = $row[ $_GET['click_id'] ]; $click_payout = $row[ $_GET['click_payout'] ]; $click_payout = str_replace('$','', $click_payout); if (is_numeric($click_id)) { if (!$click_payouts[$click_id]) $click_payouts[$click_id] = $click_payout; else $click_payouts[$click_id] = $click_payout + $click_payouts[$click_id]; #now upload each row into prosper202 and update the subids accordingly $mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']); $mysql['click_id'] = $db->real_escape_string($click_id); $mysql['click_payout'] = $db->real_escape_string($click_payouts[$click_id]); $mysql['click_update_time'] = time(); $mysql['click_update_type'] = 'upload'; $click_sql = " SELECT 2c.aff_campaign_id, 2c.click_time FROM 202_clicks AS 2c WHERE 2c.click_id ='". $mysql['click_id']."' AND 2c.user_id='".$mysql['user_id']."'"; $click_result = $db->query($click_sql) or record_mysql_error($click_sql); $click_row = $click_result->fetch_assoc(); $mysql['aff_campaign_id'] = $db->real_escape_string($click_row['aff_campaign_id']); $mysql['click_time'] = $db->real_escape_string($click_row['click_time']); addConversionLog($mysql['click_id'], '', $mysql['aff_campaign_id'], $mysql['click_payout'], $mysql['user_id'], $mysql['click_time'], $_SERVER['HTTP_X_FORWARDED_FOR'], $_SERVER['HTTP_USER_AGENT'],'', 0); $update_sql = "UPDATE 202_clicks SET click_lead='1', `click_filtered`='0', `click_payout`='".$mysql['click_payout']."' WHERE click_id='" . $mysql['click_id'] ."' AND user_id='".$mysql['user_id']."'"; $update_result = _mysqli_query($update_sql); $de->setDirtyHour($mysql['click_id']); } } #update is now complete, delete the .csv unlink ($file); template_top('Upload Revenue Reports',NULL,NULL,NULL); about_revenue_upload(); echo '

Your report has been uploaded successfully

The subids have been marked and set accordingly: '; foreach( $click_payouts as $key => $row ) { printf("", $key, $row); } echo '

SUBID	COMMISSION
%s	$%s

'; echo '

'; template_bottom(); break; default: if ($_SERVER['REQUEST_METHOD'] == 'POST') { if(!in_array(end(explode('.', $_FILES['csv']['name'])), array('csv'))) { template_top('Upload Revenue Reports',NULL,NULL,NULL); about_revenue_upload(); echo '

Uploaded file should be .csv file.

'; template_bottom(); die(); } //get file extension, checks to see if the image file, if not, do not allow to upload the file $pext = getFileExtension($_FILES['csv']['name']); $pext = strtolower($pext); if (($pext != "txt") and ($pext !="csv")) $error = true; //open the tmp file, that was uploaded, the csv $tmp_name = $_FILES['csv']['tmp_name']; $handle = fopen($tmp_name, "rb"); //this counter, will help us determine the first row of the array $row = @fgetcsv($handle, 100000, ","); #if there was no row detected, an error occured on this uploaded if (!$row) $error = true; if (!$error) { #now write the csv to the reports folder $handle = fopen($tmp_name, "rb"); $data = fread($handle, 100000); $file = rand(0,100) . time() . rand(0,100) .'.csv'; $newHandle = fopen($upload_dir . $file, 'w'); fwrite($newHandle, $data); fclose($newHandle); header('location: '.get_absolute_url().'tracking202/update/upload.php?case=1&file='.$file); die(); } } template_top('Upload Revenue Reports',NULL,NULL,NULL); about_revenue_upload(); //check to see if the directory is writable if ( !is_writable( $upload_dir )) { echo '

'. "

Sorry, I can't write to the directory: ". $upload_dir ."
In order to upload Revenue reports we need to be able to write to this directory, you'll need to modify the permissions.

"; template_bottom(); die(); } ?>