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

	$hash = &quot;SELECT install_hash FROM 202_users WHERE user_id = &#039;1&#039;&quot;;
	$result = $db-&gt;query($hash);
	$row = $result-&gt;fetch_assoc();

	if ($row[&#039;install_hash&#039;] != $_GET[&#039;hash&#039;]) {
		die(&quot;Unautorized!&quot;);
	}

    $database = DB::getInstance();
	$db = $database-&gt;getConnection();
	
	$user_sql = &#039;SELECT user_email, user_daily_email FROM 202_users LEFT JOIN 202_users_pref USING (user_id) WHERE user_id = 1&#039;;
	$user_result = $db-&gt;query($user_sql);
	$user_row = $user_result-&gt;fetch_assoc();
	
	if (!$user_row[&#039;user_daily_email&#039;]) {
		die();
	}
    $domain = rtrim($protocol . &#039;&#039; . getTrackingDomain(). get_absolute_url(), &#039;/&#039;);
	$data = array(&#039;to&#039; =&gt; $user_row[&#039;user_email&#039;], &#039;domain&#039; =&gt; $domain, &#039;campaigns&#039; =&gt; array());
	$ids = array();

	$time[&#039;from_today&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time()));
	$time[&#039;to_today&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()),date(&#039;d&#039;,time()),date(&#039;Y&#039;,time()));
	
	$time[&#039;from_yesterday&#039;] = mktime(0,0,0,date(&#039;m&#039;,time()-86400),date(&#039;d&#039;,time()-86400),date(&#039;Y&#039;,time()-86400));
	$time[&#039;to_yesterday&#039;] = mktime(23,59,59,date(&#039;m&#039;,time()-86400),date(&#039;d&#039;,time()-86400),date(&#039;Y&#039;,time()-86400));
		
	$sql_today = &quot;SELECT 
			2ca.aff_campaign_id,
			2ca.aff_campaign_name,
			COUNT(*) AS clicks,
			SUM(2cr.click_out) AS click_throughs,
			(SUM(2cr.click_out)/COUNT(*))*100 AS ctr,
			SUM(2c.click_lead) AS leads,
			(SUM(2c.click_lead)/COUNT(*))*100 as su_ratio,
			SUM(2c.click_payout*2c.click_lead) AS income,
			SUM(2c.click_cpc) AS cost,
			(SUM(2c.click_payout*2c.click_lead)-SUM(2c.click_cpc)) AS net,
			((SUM(2c.click_payout*2c.click_lead)-SUM(2c.click_cpc))/SUM(2c.click_cpc)*100 ) as roi 
			FROM 202_clicks AS 2c
			LEFT JOIN 202_clicks_record AS 2cr USING (click_id)
			LEFT JOIN 202_aff_campaigns AS 2ca USING (aff_campaign_id)
			WHERE 2c.click_time &gt;= &quot;.$time[&#039;from_today&#039;].&quot;
			AND 2c.click_time &lt;= &quot;.$time[&#039;to_today&#039;].&quot;
			GROUP BY 2ca.aff_campaign_id
			ORDER BY net DESC
			LIMIT 5&quot;;
	$result_today = $db-&gt;query($sql_today);

	if ($result_today-&gt;num_rows &gt; 0) {
		while ($row_today = $result_today-&gt;fetch_assoc()) {
			$columns_today = array();
			$ids[] = $row_today[&#039;aff_campaign_id&#039;];
			foreach ($row_today as $key =&gt; $value) {
				if ($key == &#039;aff_campaign_id&#039; || $key == &#039;aff_campaign_name&#039;) {
					$columns_today[$key] = $value;
				} else {
					$columns_today[$key] = @round($value, 2);
				}
			}

			$data[&#039;campaigns&#039;][$row_today[&#039;aff_campaign_id&#039;]][&#039;today&#039;] = $columns_today;

		}
	}

	$sql_yesterday = &quot;SELECT
		2c.aff_campaign_id, 
		2ca.aff_campaign_name,
		COUNT(*) AS clicks,
		SUM(2cr.click_out) AS click_throughs,
		(COUNT(*)/SUM(2cr.click_out))*100 AS ctr,
		SUM(2c.click_lead) AS leads,
		(SUM(2c.click_lead)/COUNT(*))*100 as su_ratio,
		SUM(2c.click_payout*2c.click_lead) AS income,
		SUM(2c.click_cpc) AS cost,
		(SUM(2c.click_payout*2c.click_lead)-SUM(2c.click_cpc)) AS net,
		((SUM(2c.click_payout*2c.click_lead)-SUM(2c.click_cpc))/SUM(2c.click_cpc)*100 ) as roi 
		FROM 202_clicks AS 2c
		LEFT JOIN 202_clicks_record AS 2cr USING (click_id)
		LEFT JOIN 202_aff_campaigns AS 2ca USING (aff_campaign_id)
		WHERE 2c.aff_campaign_id IN (&quot;.implode(&quot;,&quot;, $ids).&quot;)
		AND 2c.click_time &gt;= &quot;.$time[&#039;from_yesterday&#039;].&quot;
		AND 2c.click_time &lt;= &quot;.$time[&#039;to_yesterday&#039;].&quot;
		GROUP BY 2c.aff_campaign_id&quot;;
	$result_yesterday = $db-&gt;query($sql_yesterday);
	
	if ($result_yesterday-&gt;num_rows &gt; 0) {
		while ($row_yesterday = $result_yesterday-&gt;fetch_assoc()) {
			$difference = array();

			foreach ($row_yesterday as $key =&gt; $value) {
				if ($key == &#039;aff_campaign_id&#039; || $key == &#039;aff_campaign_name&#039;) {
					continue;
				}

				$today_value = $data[&#039;campaigns&#039;][$row_yesterday[&#039;aff_campaign_id&#039;]][&#039;today&#039;][$key];

				$math = 0;

				if ($today_value != $value) {
					$math = @round((($today_value - $value) / $value * 100),2);
				}
				
				if ($math != 0) {
					$difference[$key] = $math.&#039;%&#039;;
				}
			}

			$data[&#039;campaigns&#039;][$row_yesterday[&#039;aff_campaign_id&#039;]][&#039;difference&#039;] = $difference;
		}
	}

	if (count($data[&#039;campaigns&#039;]) &gt; 0) {
		$curl = curl_init(&#039;https://my.tracking202.com/api/v2/send-daily-email&#039;);
		curl_setopt($curl, CURLOPT_HEADER, false);
		curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
		curl_setopt($curl, CURLOPT_HTTPHEADER, array(&quot;Content-type: application/json&quot;));
		curl_setopt($curl, CURLOPT_POST, true);
		curl_setopt($curl, CURLOPT_POSTFIELDS, json_encode($data, true));
		$response = curl_exec($curl);
		print_r(json_decode($response));
	}
	
?&gt;	</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fpublic_html%2Ftracking%2F202-cronjobs'>⬅ Back to Directory</a>