Location: PHPKode > projects > AdRotate - WordPress Plugin > adrotate/dashboard/adrotate-advertiser-main.php
<?php
/*  
Copyright 2010-2012 Arnan de Gans - AJdG Solutions (email : hide@address.com)
*/
?>
		<?php
			$user_has_ads = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."adrotate_linkmeta` WHERE `group` = 0 AND `block` = 0 AND `user` = ".$current_user->ID.";");

			if($user_has_ads > 0) {
				$result = adrotate_prepare_advertiser_report($current_user->ID); 
				
				// Get Click Through Rate
				$ctr = adrotate_ctr($result['total_clicks'], $result['total_impressions']);						
		?>
	
				<h3><?php _e('Your ads', 'adrotate'); ?></h3>
				
				<table class="widefat" style="margin-top: .5em">
					<thead>
						<tr>
						<th width="2%"><center><?php _e('ID', 'adrotate'); ?></center></th>
						<th width="13%"><?php _e('Show from', 'adrotate'); ?></th>
						<th width="13%"><?php _e('Show until', 'adrotate'); ?></th>
						<th><?php _e('Title', 'adrotate'); ?></th>
						<th width="5%"><center><?php _e('Impressions', 'adrotate'); ?></center></th>
						<th width="5%"><center><?php _e('Today', 'adrotate'); ?></center></th>
						<th width="5%"><center><?php _e('Clicks', 'adrotate'); ?></center></th>
						<th width="5%"><center><?php _e('Today', 'adrotate'); ?></center></th>
						<th width="5%"><center><?php _e('CTR', 'adrotate'); ?></center></th>
						<th width="15%"><?php _e('Contact publisher', 'adrotate'); ?></th>
					</tr>
					</thead>
					
					<tbody>
				<?php
				if($result['ads']) {
					foreach($result['ads'] as $ad) {
						
						$class 			= ('alternate' != $class) ? 'alternate' : '';
						$expiredclass 	= ($ad['endshow'] <= $now OR $ad['endshow'] <= $in2days) ? ' error' : '';
				?>
					    <tr id='banner-<?php echo $ad['id']; ?>' class='<?php echo $class.$expiredclass; ?>'>
							<td><center><?php echo $ad['id'];?></center></td>
							<td><?php echo date_i18n("F d, Y", $ad['startshow']);?></td>
							<td><span style="color: <?php echo adrotate_prepare_color($ad['endshow']);?>;"><?php echo date_i18n("F d, Y", $ad['endshow']);?></span></td>
							<th><strong><?php echo stripslashes(html_entity_decode($ad['title']));?></strong></th>
							<td><center><?php echo $ad['impressions'];?></center></td>
							<td><center><?php echo $ad['impressions_today'];?></center></td>
							<td><center><?php echo $ad['clicks'];?></center></td>
							<td><center><?php echo $ad['clicks_today'];?></center></td>
							<?php if($ad['impressions'] == 0) $ad['impressions'] = 1; ?>
							<td><center><?php echo round((100/$ad['impressions']) * $ad['clicks'],2); ?> %</center></td>
							<td><a href="admin.php?page=adrotate-advertiser&view=message&request=renew&id=<?php echo $ad['id']; ?>"><?php _e('Renew', 'adrotate'); ?></a> - <a href="admin.php?page=adrotate-advertiser&view=message&request=remove&id=<?php echo $ad['id']; ?>"><?php _e('Remove', 'adrotate'); ?></a> - <a href="admin.php?page=adrotate-advertiser&view=message&request=other&id=<?php echo $ad['id']; ?>"><?php _e('Other', 'adrotate'); ?></a></td>
						</tr>
						<?php } ?>
				    <tr>
						<th width="10%" colspan="2"><?php _e('Export options', 'adrotate'); ?></th>
						<td width="40%" colspan="8">
				  			<form method="post" action="admin.php?page=adrotate">
				    			<input type="hidden" name="adrotate_export_id" value="<?php echo $current_user->ID; ?>" />
				    			<input type="hidden" name="adrotate_export_type" value="advertiser" />
				    			<input type="hidden" name="adrotate_export_month" value="0" />
				    			<input type="hidden" name="adrotate_export_year" value="0" />
								<input type="submit" name="adrotate_export_submit" class="button-primary" value="<?php _e('Export', 'adrotate'); ?>" /> <em><?php _e('Download this overview as a CSV file.', 'adrotate'); ?></em>
							</form>
						</td>
					</tr>
				<?php } else { ?>
					<tr id='no-ads'>
						<th>&nbsp;</th>
						<td colspan="10"><em><?php _e('No ads to show!', 'adrotate'); ?> <a href="admin.php?page=adrotate-advertiser&view=message&request=issue"><?php _e('Contact your publisher', 'adrotate'); ?></a>.</em></td>
					</tr>
				<?php } ?>
					</tbody>
				</table>

				<h3><?php _e('Summary', 'adrotate'); ?></h3>
				
				<table class="widefat" style="margin-top: .5em">					

					<thead>
					<tr>
						<th colspan="2"><?php _e('Overall statistics', 'adrotate'); ?></th>
						<th><?php _e('The last 8 clicks in the past 24 hours', 'adrotate'); ?></th>
					</tr>
					</thead>
					
					<tbody>

					<?php if($adrotate_debug['userstats'] == true) { ?>
					<tr>
						<td colspan="3">
							<?php 
							echo "<p><strong>User Report</strong><pre>"; 
							print_r($result); 
							echo "</pre></p>"; 
							?>
						</td>
					</tr>
					<?php } ?>
		
				    <tr>
						<th width="10%"><?php _e('General', 'adrotate'); ?></th>
						<td width="40%"><?php echo $result['ad_amount']; ?> <?php _e('ads, sharing a total of', 'adrotate'); ?> <?php echo $result['total_impressions']; ?> <?php _e('impressions.', 'adrotate'); ?></td>
						<td rowspan="5" style="border-left:1px #EEE solid;">
						<?php 
						if($result['last_clicks']) {
							foreach($result['last_clicks'] as $last) {
								$bannertitle = $wpdb->get_var("SELECT `title` FROM `".$wpdb->prefix."adrotate` WHERE `id` = '$last[bannerid]'");
								echo '<strong>'.date_i18n('d-m-Y', $last['timer']) .'</strong> - '. $bannertitle .'<br />';
							}
						} else {
							echo '<em>'.__('No recent clicks', 'adrotate').'</em>';
						} ?>
						</td>
					</tr>
				    <tr>
						<th><?php _e('The best', 'adrotate'); ?></th>
						<td><?php if($result['thebest']) {?>'<?php echo $result['thebest']['title']; ?>' <?php _e('with', 'adrotate'); ?> <?php echo $result['thebest']['clicks']; ?> <?php _e('clicks.', 'adrotate'); ?><?php } else { ?><?php _e('No ad stands out at this time.', 'adrotate'); ?><?php } ?></td>
					</tr>
				    <tr>
						<th><?php _e('The worst', 'adrotate'); ?></th>
						<td><?php if($result['theworst']) {?>'<?php echo $result['theworst']['title']; ?>' <?php _e('with', 'adrotate'); ?> <?php echo $result['theworst']['clicks']; ?> <?php _e('clicks.', 'adrotate'); ?><?php } else { ?><?php _e('All ads seem equally bad.', 'adrotate'); ?><?php } ?></td>
					</tr>
				    <tr>
						<th><?php _e('Average on all ads', 'adrotate'); ?></th>
						<td><?php echo $result['total_clicks']; ?> <?php _e('clicks.', 'adrotate'); ?></td>
					</tr>
				    <tr>
						<th><?php _e('Click-Through-Rate', 'adrotate'); ?></th>
						<td><?php echo $ctr; ?>%, <?php _e('based on', 'adrotate'); ?> <?php echo $result['total_impressions']; ?> <?php _e('impressions and', 'adrotate'); ?> <?php echo $result['total_clicks']; ?> <?php _e('clicks.', 'adrotate'); ?></td>
					</tr>
			      	<tr>
				        <th colspan="3">
				        	<?php
				        	$adstats = $wpdb->get_results("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `".$wpdb->prefix."adrotate_stats_tracker`, `".$wpdb->prefix."adrotate_linkmeta` WHERE `".$wpdb->prefix."adrotate_stats_tracker`.`ad` = `".$wpdb->prefix."adrotate_linkmeta`.`ad` AND `".$wpdb->prefix."adrotate_linkmeta`.`user` = $current_user->ID GROUP BY `thetime` DESC LIMIT 21;");
		        			
							if($adstats) {
								
								$adstats = array_reverse($adstats);
		
								if($adrotate_debug['userstats'] == true) { 
									echo "<p><strong>[DEBUG] 21 days (Or as much as is available) Ad stats</strong><pre>"; 
									print_r($adstats); 
									echo "</pre></p>"; 
								}
		
								foreach($adstats as $stat) {
									if($stat->clicks == null) $stat->clicks = '0';
									if($stat->impressions == null) $stat->impressions = '0';
								
									$clicks_array[date_i18n("M d", $stat->thetime)] = $stat->clicks;
									$impressions_array[date_i18n("M d", $stat->thetime)] = $stat->impressions;
								}
			
								if($adrotate_debug['userstats'] == true) { 
									echo "<p><strong>[DEBUG] Found clicks as presented to PHPGraphLib</strong><pre>"; 
									print_r($clicks_array); 
									echo "</pre></p>"; 
									echo "<p><strong>[DEBUG] Found impressions as presented to PHPGraphLib</strong><pre>"; 
									print_r($impressions_array); 
									echo "</pre></p>"; 
								}
			
								$impressions_title = urlencode(serialize(__('Impressions of all your ads over the past 21 days', 'adrotate')));
								$impressions_array = urlencode(serialize($impressions_array));
								echo "<img src=\"".plugins_url("adrotate/library/graph_all_ads.php?title=$impressions_title&data=$impressions_array", "AdRotate")."\" />";

								$clicks_title = urlencode(serialize(__('Clicks of all your ads over the past 21 days', 'adrotate')));
								$clicks_array = urlencode(serialize($clicks_array));
								echo "<img src=\"".plugins_url("adrotate/library/graph_all_ads.php?title=$clicks_title&data=$clicks_array", "AdRotate")."\" />";
							} else {
								_e('No data to show!', 'adrotate');
							} 
							?>
				        </th>
			      	</tr>
					</tbody>
				</table>
				
			<?php } else { ?>
				<table class="widefat" style="margin-top: .5em">
					<thead>
						<tr>
							<th><?php _e('Notice', 'adrotate'); ?></th>
						</tr>
					</thead>
					<tbody>
					    <tr>
							<td><?php _e('No ads for user. If you feel this to be in error please', 'adrotate'); ?> <a href="admin.php?page=adrotate-advertiser&view=message&request=issue"><?php _e('contact the site administrator', 'adrotate'); ?></a>.</td>
						</tr>
					</tbody>
				</table>
			<?php } ?>
Return current item: AdRotate - WordPress Plugin