/app/controllers/analytics_controller.php

Large files files are truncated, but you can click here to view the full file

<?php
class AnalyticsController extends AppController {

	var $name = 'Analytics';
	var $etime = NULL;
	var $uses = array('User','Band','Lfm','Lfmtrack','Lfmalbum','Lfmlistener','Mss','Mssstat','Msscomm','Msslogin','Fb','Fbpage','Yt','Ytstat','Ytcommstat');
	var $helpers = array('Html', 'Error', 'Javascript' , 'FlashChart');

	var $components = array('Cookie'); //  use component email




	/**
	 * Name: beforeFilter
	 * Desc: Performs necessary steps and function calls prior to executing
	 *       any view function calls.
	 */
	function beforeFilter() {
		$this->auth();

	} // function beforeFilter() {

	/* Name: index
	 * Desc: set MySpace , Facebook , Last.fm , Youtube ID's by select option box.
	 */

	function index()
	{

		$this->layout = "analytics";	
		if($this->data)
		{
			$this->Session->write('mssvideo', $this->data['data']['mssvideo']);
			$this->Session->write('video', $this->data['data']['video']);
			$this->Session->write('topalbum', $this->data['data']['album']);
			$this->Session->write('toptrack', $this->data['data']['tracks']);

			$this->redirect('/analytics/cmslist/');
			exit;

		} // if($this->data)
		else
		{
			
			
			$mmm_id = $this->Session->read('id');
	
			if(@$this->params['url']['bandid'])
			{
				$band_id = $this->params['url']['bandid'];
			} // if(@$this->params['url']['bandid'])
			else
			{
				$band = $this->Band->find(array('mmm_id'=>$mmm_id,'status'=>'1'));
				if($band)
				{
					$band_id = $band['Band']['band_id'];
					
				}
				else
				{
					$this->Session->setFlash('Please Add Band');
					$this->redirect('/band/index/');	
				}
			} // if(@$this->params['url']['bandid'])
			
			$band = $this->Band->findAll(array('mmm_id'=>$mmm_id,'status'=>'1'));
			if($band)
			{
				
				$this->set('band',$band);
				foreach($band as $bandkey =>$bandval)
				{
					if($bandval['Band']['band_id']==$band_id)
					{
						$bandname = 	$bandval['Band']['name'];
						break;
					}
				}
				
				$this->set('bandname',$bandname);
				$this->Session->write('bandname',$bandname);
			}
			
			
				
			$this->Session->write('band_id',$band_id);
			
			$qry_mss = "select p.title from mss_play_stat p , mss_login m where p.mss_id = m.mss_id and m.mmm_id='$mmm_id' and m.band_id=$band_id";
			$mss_plays = $this->Mssstat->findBySql($qry_mss);
			if($mss_plays)
			{
				$this->set('mss_plays',$mss_plays);
			} // if($results)
			else
			{
				$mss_plays[0]['p']['title'] = 'No data';
				$this->set('mss_plays',$mss_plays);
			}
			
			
			$qry_lfm_album = "select a.name from lfm_top_album a , lfm_music m where a.lfm_m_id = m.lfm_m_id and m.mmm_id='$mmm_id' and m.band_id=$band_id";
			$lfm_album = $this->Lfmalbum->findBySql($qry_lfm_album);
			if($lfm_album)
			{
				$this->set('lfm_album',$lfm_album);
			} // if($results)
			else
			{
				$lfm_album[0]['a']['name'] = 'No data';
				$this->set('lfm_album',$lfm_album);
			}
			
			
			$qry_lfm_track = "select t.name from lfm_top_tracks t , lfm_music m where t.lfm_m_id = m.lfm_m_id and m.mmm_id='$mmm_id' and m.band_id=$band_id";
			$lfm_track = $this->Lfmalbum->findBySql($qry_lfm_track);
			if($lfm_track)
			{
				$this->set('lfm_track',$lfm_track);
			} // if($results)
			else
			{
				$lfm_track[0]['t']['name'] = 'No data';
				$this->set('lfm_track',$lfm_track);
			}
			
			$qry_yt_video= "select y.title from yt_comments_stat y , yt_login l  where y.yt_id = l.yt_id and l.mmm_id='$mmm_id' and l.band_id=$band_id";
			$ytvideo = $this->Ytcommstat->findBySql($qry_yt_video);
			if($ytvideo)
			{
				$this->set('ytvideo',$ytvideo);
			} // if($results)	
			else
			{
				$ytvideo[0]['y']['title'] = 'No data';
				$this->set('ytvideo',$ytvideo);
			}
	
			$fb = $this->Fb->find(array('mmm_id'=>$mmm_id , 'band_id'=>$band_id , 'status'=>1));
			if($fb)
			{
				
				$page = $fb['Fb']['page'];
				$group = $fb['Fb']['group'];
				
				if($page)
				{
					$this->Session->write('fbpages', $page);
				}
				else
				{
					$page = 'No data';
					$this->Session->write('fbpages', $page);
				}
				
				if($group)
				{
					$this->Session->write('fbgroups', $group);
				}
				else
				{
						$group = 'No data';
						$this->Session->write('fbgroups', $group);
					
				}
				
			} // if($results)
			else
			{
				$page  = 'No data';
				$group = 'No data';
				
				$this->Session->write('fbpages', $page);
				$this->Session->write('fbgroups', $group);
				
			}

		} // if($this->data)
			
	} // 	function index()


	/*
	 Name : album
	 Desc :	Ajax Album  to get top album against last.fm Music Group
	 */
	function album()
	{
		if(!empty($this->params['url']['id']))
		{
			$id = $this->params['url']['id'];
			$qry="select distinct l.name from lfm_top_album l where l.lfm_m_id = $id";
			$result = $this->Lfmalbum->findBySql($qry);
			$data = "[";
			foreach($result as $key =>$val)
			{
				$nm = str_replace(array("\"","'"),array(" "," "),$val['l']['name']);
				$data.= "{ optionValue:'$nm' , optionDisplay:'$nm'},";
			}
			$data= substr($data,0,strlen($data)-1);
			$data.="]";
			echo $data;
			exit;

		}

	} // function album


	/*
	 Name : tracks
	 Desc :	Ajax Album  to get top tracks against last.fm Music Group
	 */
	function tracks()
	{
		if(!empty($this->params['url']['id']))
		{
			$id = $this->params['url']['id'];
			$qry="select distinct l.name from lfm_top_tracks l where l.lfm_m_id = $id";
			$result = $this->Lfmalbum->findBySql($qry);
			$data = "[";
			foreach($result as $key =>$val)
			{
				$nm = str_replace(array("\"","'"),array(" "," "),$val['l']['name']);
				$data.= "{ optionValue:'$nm' , optionDisplay:'$nm'},";
			}
			$data= substr($data,0,strlen($data)-1);
			$data.="]";
			echo $data;
			exit;

		}

	} // function tracks

	/*
	 Name : comments
	 Desc :	Ajax to get youtube video title
	 */
	function comments()
	{
		if(!empty($this->params['url']['id']))
		{
			$id = $this->params['url']['id'];
			$qry="select distinct y.title from yt_comments_stat y where y.yt_id = $id";
			$result = $this->Lfmalbum->findBySql($qry);
			$data = "[";
			foreach($result as $key =>$val)
			{
				$nm = str_replace(array("\"","'"),array(" "," "),$val['y']['title']);
				$data.= "{ optionValue:'$nm' , optionDisplay:'$nm'},";
			}
			$data= substr($data,0,strlen($data)-1);
			$data.="]";
			echo $data;
			exit;

		}

	} // function comments()


	/*
	 Name : mssplays
	 Desc :	Ajax to get Myspace title
	 */
	function mssplays()
	{
		if(!empty($this->params['url']['id']))
		{
			$id = $this->params['url']['id'];
			$qry="select distinct m.title from mss_play_stat m where m.mss_id = $id";
			$result = $this->Lfmalbum->findBySql($qry);
			$data = "[";
			foreach($result as $key =>$val)
			{
				$nm = str_replace(array("\"","'"),array(" "," "),$val['m']['title']);
				$data.= "{ optionValue:'$nm' , optionDisplay:'$nm'},";
			}
			$data= substr($data,0,strlen($data)-1);
			$data.="]";
			echo $data;
			exit;

		}

	} // function comments()


	/*
	 Name : Facebook Pages
	 Desc :	Ajax to get Fbs pages
	 */
	function fbspages()
	{
		if(!empty($this->params['url']['id']))
		{
			$id = $this->params['url']['id'];
			$qry="select distinct f.name from fb_pages f where f.login_id = $id and f.is_admin=1";
			$result = $this->Lfmalbum->findBySql($qry);
			$data = "[";
			foreach($result as $key =>$val)
			{
				$nm = str_replace(array("\"","'"),array(" "," "),$val['f']['name']);
				$data.= "{ optionValue:'$nm' , optionDisplay:'$nm'},";
			}
			$data= substr($data,0,strlen($data)-1);
			$data.="]";
			echo $data;
			exit;

		}

	} // function fbspages()


	/*
	 Name : Facebook Groups
	 Desc :	Ajax to get Fbs Groups
	 */
	function fbsgroups()
	{
		if(!empty($this->params['url']['id']))
		{
			$id = $this->params['url']['id'];
			$qry="select distinct f.name from fb_group f where f.login_id = $id and f.isCreator='Yes'";
			$result = $this->Lfmalbum->findBySql($qry);
			$data = "[";
			foreach($result as $key =>$val)
			{
				$nm = str_replace(array("\"","'"),array(" "," "),$val['f']['name']);
				$data.= "{ optionValue:'$nm' , optionDisplay:'$nm'},";
			}
			$data= substr($data,0,strlen($data)-1);
			$data.="]";
			echo $data;
			exit;

		}

	} // function fbspages()

	/*
	 Name 	:	cmslist
	 Desc	:	link hits , view , plays and comments
	 */
	function cmslist()
	{
		
		if($this->Session->check('id') and $this->Session->check('band_id') and $this->Session->check('bandname') and $this->Session->check('toptrack') and $this->Session->check('topalbum') and $this->Session->check('video') and $this->Session->check('mssvideo'))
		{
			$bandname = $this->Session->read('bandname');
			$this->set('bandname',$bandname);
			
			
			if($this->Session->read('mssvideo')!='No data')
			{	$this->Session->write('msh','msh');
				$this->Session->write('msv','msv');
				$this->Session->write('msp','msp');
				$this->Session->write('msc','msc');
			}
	
			if($this->Session->read('video')!='No data')
			{
				$this->Session->write('yth','yth');
				$this->Session->write('ytv','ytv');
				$this->Session->write('ytp','ytp');
				$this->Session->write('ytc','ytc');
			}	
			
			if(($this->Session->read('topalbum')!='No data') and ($this->Session->read('toptrack')!='No data'))
			{
				$this->Session->write('lfmsh','lfmsh');
				$this->Session->write('lfmsv','lfmsv');
				$this->Session->write('lfmsp','lfmsp');
			}
	
			if($this->Session->read('fbpages')!='No data')					
				$this->Session->write('fbspages','fbspages');
				
			if($this->Session->read('fbgroups')!='No data')										
				$this->Session->write('fbsgroups','fbsgroups');
			
			$this->layout = 'analyticcms';
		} // if($this->Session->check('id') and $this->Session->check('band_id') and $this->Session->check('bandname') and $this->Session->check('toptrack') and $this->Session->check('topalbum') and $this->Session->check('video') and $this->Session->check('mssvideo'))
		else
		{
			$this->redirect('/analytics/index');
		} // if($this->Session->check('email') and $this->Session->check('band_id') and $this->Session->check('bandname') and $this->Session->check('toptrack') and $this->Session->check('topalbum') and $this->Session->check('video') and $this->Session->check('mssvideo'))
		
	} // function cmslist()

	/*
	 name : chart
	 set : get and set data for fans , hits , tracks & comments
	 */
	function chart()
	{
		/*
			get and set light box & graph width & height
		*/
		if(!empty($this->params['url']['width']) and !empty($this->params['url']['height']))
		{
			$width 	= $this->params['url']['width'] ;
			$height = $this->params['url']['height'] ;
		}
		else
		{
			$width = 600;
			$height=400;
		}
		
		$this->set('cwidth',$width);
		$this->set('cheight',$height);
		
		$this->set('width',round($width/1.25));
		$this->set('height',round($height/1.5));
		
		// 	End  get and set light box & graph width & height
	
	
	
			$mmm_id = $this->Session->read('id');
	
			// get and set band ID
	
			if(!empty($this->params['url']['bandid']))
			{
				$band_id = $this->params['url']['bandid'];
				$this->Session->write('band_id',$band_id);
			} // if(@$this->params['url']['bandid'])
			elseif($this->Session->check('band_id'))
			{
				$band_id = $this->Session->read('band_id');
			}
			else
			{
				$this->set('flag',1);
						
			}//if(@$this->params['url']['bandid'])
			
			$band = $this->Band->find(array('mmm_id'=>$mmm_id,'status'=>'1','band_id'=>$band_id));
			if($band)
			{
				$bandname = $band['Band']['name'];
				$this->set('bandname',$bandname);
				$this->Session->write('bandname',$bandname);
			}
			
			$this->Session->write('band_id',$band_id);
			
			
			// Get and set values for Myspace , youtube , last.fm
			
			
			// Get and set values for MySpace Tracks Tab
			$qry_mss = "select distinct p.title from mss_play_stat p , mss_login m where p.mss_id = m.mss_id and m.mmm_id='$mmm_id' and m.band_id=$band_id and m.status=1";
			
			$mss_plays = $this->Mssstat->findBySql($qry_mss);
			$mss = NULL;
			if($mss_plays)
			{
				if(!empty($this->params['url']['mss'])) // if option select from light box
				{
					$this->Session->write('mssvideo', $this->params['url']['mss']); 
					$this->set('mssval',$this->params['url']['mss']); // to select dropdown list value
				}
				else
				{
					$this->Session->write('mssvideo', $mss_plays[0]['p']['title']);
					$this->set('mssval',$mss_plays[0]['p']['title']);
				}
				
				foreach($mss_plays as $key => $mssval)
				{
					$mss[$mssval['p']['title']] =  $mssval['p']['title'] ;
				}
				$this->set('mss',$mss);
			} // if($results)
			else
			{
				$mss_plays[0]['p']['title'] = 'No data';
				$this->Session->write('mssvideo', $mss_plays[0]['p']['title']);
				$mss['No data'] = 'No data';
				$this->set('mssval','No data');
				$this->set('mss',$mss);
			}
			
			
			// Get and set values for Last.fm Tracks Tab		
			$qry_lfm_track = "select distinct  t.name from lfm_top_tracks t , lfm_music m where t.lfm_m_id = m.lfm_m_id and m.mmm_id='$mmm_id' and m.band_id=$band_id and m.status=1";
			$lfm_track = $this->Lfmalbum->findBySql($qry_lfm_track);
			$lfmt=NULL;
			if($lfm_track)
			{
				if(!empty($this->params['url']['lfmt']))
				{
					$this->Session->write('toptrack', $this->params['url']['lfmt']);
					$this->set('lfmtval',$this->params['url']['lfmt']);
				}
				else
				{
					$this->Session->write('toptrack', $lfm_track[0]['t']['name']);
					$this->set('lfmtval',$lfm_track[0]['t']['name']);
				}
				
				
				foreach($lfm_track as $key => $lfmval)
				{
					$lfmt[$lfmval['t']['name']] =  $lfmval['t']['name'];
				}
				$this->set('lfmt',$lfmt);
			} // if($results)
			else
			{
				$lfm_track[0]['t']['name'] = 'No data';
				$this->Session->write('toptrack', $lfm_track[0]['t']['name']);
				$lfmt['No data'] = 'No data';
				$this->set('lfmt',$lfmt);
				$this->set('lfmtval','No data');
			}
			
			// Get and set values for Youtubne Tracks & comments Tab
			$qry_yt_video= "select distinct y.title from yt_comments_stat y , yt_login l  where y.yt_id = l.yt_id and l.mmm_id='$mmm_id' and l.band_id=$band_id and l.status=1";
			
			
			$ytvideo = $this->Ytcommstat->findBySql($qry_yt_video);
			
			$yt=NULL;
			if($ytvideo)
			{
				if(!empty($this->params['url']['yt']))
				{
					$this->Session->write('video', $this->params['url']['yt']);
					$this->set('ytval',$this->params['url']['yt']);
				}
				else
				{
					$this->Session->write('video', $ytvideo[0]['y']['title']);
					$this->set('ytval',$ytvideo[0]['y']['title']);
				}
				
				
				foreach($ytvideo as $key => $ytval)
				{
					$yt[$ytval['y']['title']] =  $ytval['y']['title'];
				}
				$this->set('yt',$yt);
			} // if($results)	
			else
			{
				$ytvideo[0]['y']['title'] = 'No data';
				$this->Session->write('video', $ytvideo[0]['y']['title']);
				$yt['No data'] = 'No data';
				$this->set('yt',$yt);
				$this->set('ytval','No data');
			}
	
			
			// Get and set facebook pages & group data for Fans Tab
			$fb = $this->Fb->find(array('mmm_id'=>$mmm_id , 'band_id'=>$band_id , 'status'=>1));
			if($fb)
			{
				
				$page = $fb['Fb']['page'];
				$group = $fb['Fb']['group'];
				
				if($page)
				{
					$this->Session->write('fbpages', $page);
				}
				else
				{
					$page = 'No data';
					$this->Session->write('fbpages', $page);
				}
				
				if($group)
				{
					$this->Session->write('fbgroups', $group);
				}
				else
				{
						$group = 'No data';
						$this->Session->write('fbgroups', $group);
					
				}
				
			} // if($results)
			else
			{
				$page  = 'No data';
				$group = 'No data';
				
				$this->Session->write('fbpages', $page);
				$this->Session->write('fbgroups', $group);
				
			}
	
	
		/*
			if in case chart call within the chart
			else in case of chart first time call without dates then default date & option applied 
		*/
		if(!empty($this->params['url']['date']))
		{
				
				$lastdate = $this->params['url']['date'];
				$this->Session->write('lastdate',$lastdate);
				$this->set('lastdate',$lastdate );
				
				
				
				if(!empty($this->params['url']['id']))
				{
					$id = $this->params['url']['id'];
					
					// set On / Off buttons
					switch($id)
					{
						case 'hall' :
								$this->Session->write('msv','msv');// Myspace hits
								$this->Session->write('ytv','ytv');// Youtube hits
								$this->Session->write('lfmsv','lfmsv'); // last.fm hits
								$this->Session->write('hnone',0);
								break;
						case 'hnone' :
								$this->Session->delete('msv');// Myspace hits
								$this->Session->delete('ytv');// Youtube hits
								$this->Session->delete('lfmsv');// last.fm hits
								if($this->Session->read('hnone')==1)
								{
									$this->Session->write('hnone',0);
								}
								else
								{
									$this->Session->write('hnone',1);
								}
								break;
						case 'fall'  :
								$this->Session->write('msh','msh');// Myspace fans
								$this->Session->write('yth','yth');// Youtube fans
								$this->Session->write('lfmsh','lfmsh'); // last.fm fans
								$this->Session->write('fbspages','fbspages'); // facebook page flag
								$this->Session->write('fbsgroups','fbsgroups'); // facebook group flag
								$this->Session->write('fnone',0);
								break;
						case 'fnone' :
								$this->Session->delete('msh');// Myspace fans
								$this->Session->delete('yth');// Youtube fans
								$this->Session->delete('lfmsh'); // last.fm fans
								$this->Session->delete('fbspages'); // facebook page flag
								$this->Session->delete('fbsgroups'); // facebook group flag
								if($this->Session->read('fnone')==1)
								{
									$this->Session->write('fnone',0);
								}
								else
								{
									$this->Session->write('fnone',1);
								}
								
								break;
						case 'tall' :
								$this->Session->write('msp','msp');// Myspace tracks
								$this->Session->write('ytp','ytp');// Youtube tracks
								$this->Session->write('lfmsp','lfmsp'); // last.fm tracks
								$this->Session->write('tnone',0);
								break;
			
						case 'tnone' :
								$this->Session->delete('msp');// Myspace tracks
								$this->Session->delete('ytp');// Youtube tracks
								$this->Session->delete('lfmsp'); // last.fm tracks
								
								if($this->Session->read('tnone')==1)
								{
									$this->Session->write('tnone',0);
								}
								else
								{
									$this->Session->write('tnone',1);
								}
								break;
						
						case 'call' :
								$this->Session->write('msc','msc');// Myspace comments
								$this->Session->write('ytc','ytc');// Youtube comments
								$this->Session->write('cnone',0);
								break;
				
						case 'cnone' :
							$this->Session->delete('msc');// Myspace comments
							$this->Session->delete('ytc');// Youtube comments
							
							if($this->Session->read('cnone')==1)
							{
								$this->Session->write('cnone',0);
							}
							else
							{
								$this->Session->write('cnone',1);
							}
							break;
						default :
						
							$type = $this->params['url']['type'];
							if($type=='fans')
							{
								$this->Session->write('fnone',0);	
							}
							elseif($type=='hits')
							{
								$this->Session->write('hnone',0);	
							}
							elseif($type=='tracks')
							{
								$this->Session->write('tnone',0);	
							}
							elseif($type=='comments')
							{
								$this->Session->write('cnone',0);	
							}
							
							
							if (!$this->Session->check($id))
							{
								$this->Session->write($id,$id);
				
							}
							else
							{
								$this->Session->delete($id);
							}
							break;
							
					}
					$this->set('id',$id);
				} // if(!empty($this->params['url']['id']))
				
				
				$this->sethitschart(); // get fans for facebook pages & groups , youtueb , myspace , last.fm
				if($this->params['url']['type']=='fans')
				{
					$this->Session->write('type','fans');
				}
				
				
				
				$this->setviewschart(); // get hits for youtube , myspace , last.fm
				if($this->params['url']['type']=='hits')
				{
					$this->Session->write('type','hits');
				}
				
				
				$this->setplayschart(); // get tracks for youtube , myspace , last.fm
				if($this->params['url']['type']=='tracks')
				{
					$this->Session->write('type','tracks');
				}
				
				$this->setcommentchart();  // get comments for youtube , myspace				
				if($this->params['url']['type']=='comments')
				{
					$this->Session->write('type','comments');
				}
				
				
			
		} // if(!empty($this->params['url']['date']) and !empty($this->params['url']['opt']))
		else   
		{
			
			
			
			if($this->Session->check('lastdate'))
			{
				$this->Session->delete('lastdate');
			}
			
			$this->Session->write('lastdate','w');
			$this->set('lastdate','w');
					
					
			
				$this->Session->write('msh','msh');// Myspace fans
				$this->Session->write('msv','msv');// Myspace hits
				$this->Session->write('msp','msp');// Myspace tracks
				$this->Session->write('msc','msc');// Myspace comments
			
				$this->Session->write('yth','yth');// Youtube fans
				$this->Session->write('ytv','ytv');// Youtube hits
				$this->Session->write('ytp','ytp');// Youtube tracks
				$this->Session->write('ytc','ytc');// Youtube comments
				
			
				$this->Session->write('lfmsh','lfmsh'); // last.fm fans
				$this->Session->write('lfmsv','lfmsv'); // last.fm hits
				$this->Session->write('lfmsp','lfmsp'); // last.fm tracks
			
	
				$this->Session->write('fbspages','fbspages'); // facebook page flag
				$this->Session->write('fbsgroups','fbsgroups'); // facebook group flag
			
			
			$this->Session->write('type','fans');
			
			$this->setcommentchart();  // get comments for youtube , myspace
			$this->setviewschart(); // get hits for youtube , myspace , last.fm
			$this->setplayschart(); // get tracks for youtube , myspace , last.fm
			$this->sethitschart(); // get fans for facebook , youtube , myspace & last.fm 
		
					
		} // if(!empty($this->params['url']['date']) and !empty($this->params['url']['opt']))
		
		$this->layout="stats";
	} // function chart()


	/*
	 Name	:	commentchart
	 Desc	:	Get graph values from sessions and display graph
	 */

	function commentchart()
	{

		$dt = $this->Session->read('dt');
		$mscomment = $this->Session->read('mscomment');
		$ytcomment = $this->Session->read('ytcomment');

		$this->set('dt',$dt);
		$this->set('mscomment',$mscomment);
		$this->set('ytcomment',$ytcomment);
	} // function setcommentchart()

	/*
	 Name	:	setcommentchart
	 Desc	:	Get graph values and return to comment()
	*/
	function setcommentchart()
	{


		
		if($this->Session->check('id') and $this->Session->check('band_id') and $this->Session->check('video'))
		{
		
		
		$mmm_id  =	$this->Session->read('id');
		$band_id =	$this->Session->read('band_id');
		$video =	$this->Session->read('video');
		
		} 
		else
		{
			//$this->Session->setFlash('Session Expired');
			//$this->redirect('/analytics/index/');
			return ;
		} // 		if($this->Session->check('email') and $this->Session->check('band_id') and $this->Session->check('video'))

		$mss= NULL;
		$yt=NULL;
		$album=NULL;

		if($this->Session->read('lastdate')=='w') // weekly graphs quries
		{

			$qry_mss = "select s.comments , s.etime from mss_stat s , mss_login l where s.mss_id = l.mss_id and l.band_id=$band_id and l.mmm_id = '$mmm_id' and l.status=1 and FROM_UNIXTIME(s.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) order by etime";

			$qry_yt = "select y.total_comments comments , y.etime from yt_comments_stat y , yt_login l where title='$video' and y.yt_id = l.yt_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and 	FROM_UNIXTIME(y.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) order by etime";

			if(!empty($this->params['url']['id']))
			{

				if ($this->Session->check('msc'))
				{
					
					$mss = $this->Mss->findBySql($qry_mss);
				}

				if ($this->Session->check('ytc'))
				{
					$yt = $this->Ytstat->findBySql($qry_yt);
				}

			} // 		if(!empty($this->params['url']['id']))
			else
			{


				$mss = $this->Mss->findBySql($qry_mss);
				$yt = $this->Ytstat->findBySql($qry_yt);


			} //		if(!empty($this->params['url']['id']))


			$qry= "select DATE_SUB(CURDATE(), INTERVAL 7 DAY) last, CURDATE() curr";
			$tfdate = $this->Ytstat->findBySql($qry);

			$dt =NULL;
			$date = NULL;
			$c=0;
			$dt[$c]=$tfdate['0']['0']['last'];

			while($tfdate['0']['0']['curr']!=$date)
			{
				$date = date('Y-m-d',strtotime(date("Y-m-d", strtotime($dt[$c])) . " +1 day"));
				$c ++;
				if($c==7)	 // i.e 0-6 last 7 days
				{
					break;
				}
				$dt[$c]= $date;

			} // while($tfdate['0']['0']['curr']!=$date)

		} // if($this->Session->read('lastdate')=='w') // weekly graphs quries
		elseif($this->Session->read('lastdate')=='m') // monthly graphs quries
		{

			$qry_mss = "select s.comments , s.etime from mss_stat s , mss_login l where s.mss_id = l.mss_id and l.band_id=$band_id and l.mmm_id = '$mmm_id' and l.status=1 and FROM_UNIXTIME(s.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Month) AND CURDATE( ) order by etime";

			$qry_yt = "select y.total_comments comments , y.etime from yt_comments_stat y , yt_login l where y.title='$video' and y.yt_id = l.yt_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and 	FROM_UNIXTIME(y.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Month) AND CURDATE( ) order by etime";


			if(!empty($this->params['url']['id']))
			{

				if ($this->Session->check('msc'))
				{
					$mss = $this->Mss->findBySql($qry_mss);
				}

				if ($this->Session->check('ytc'))
				{
					$yt = $this->Ytstat->findBySql($qry_yt);
				}

			} // 		if(!empty($this->params['url']['id']))
			else
			{
				$mss = $this->Mss->findBySql($qry_mss);
				$yt = $this->Ytstat->findBySql($qry_yt);
			} //		if(!empty($this->params['url']['id']))

			$qry= "select DATE_SUB(CURDATE(), INTERVAL 1 Month) last, CURDATE() curr";
			$tfdate = $this->Ytstat->findBySql($qry);

			$dt =NULL;
			$date = NULL;
			$c=0;
			
			$cdate= $tfdate['0']['0']['curr'];
			$curdate = date('Y-m-d',strtotime(date("Y-m-d", strtotime($cdate)) . " -1 day"));

			$d=$tfdate['0']['0']['last'];
			$dt[$c]=date('Y-m-d',strtotime(date("Y-m-d", strtotime($d)) . " +1 day"));

			while($curdate!=$date)
			{
				$date = date('Y-m-d',strtotime(date("Y-m-d", strtotime($dt[$c])) . " +1 day"));
				$c ++;
				$dt[$c]= $date;

			} // while($tfdate['0']['0']['curr']!=$date)

			$this->Session->write('mm',count($dt));

		} // elseif($this->Session->read('lastdate')=='m') // monthly graphs quries

		elseif($this->Session->read('lastdate')=='y') // yearly graphs quries
		{
			$qry_mss = "select s.comments , s.etime from mss_stat s , mss_login l where  s.mss_id = l.mss_id and l.band_id=$band_id and l.mmm_id = '$mmm_id' and l.status=1 and FROM_UNIXTIME(s.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Year) AND CURDATE( ) order by etime";

			$qry_yt = "select y.total_comments comments , y.etime from yt_comments_stat y , yt_login l where  y.title='$video' and y.yt_id = l.yt_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and 	FROM_UNIXTIME(y.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Year) AND CURDATE( ) order by etime";


			if(!empty($this->params['url']['id']))
			{

				if ($this->Session->check('msc'))
				{
					$mss = $this->Mss->findBySql($qry_mss);
					$mss_data = $this->getyear($mss,'s','comments');					
				}
				if ($this->Session->check('ytc'))
				{
					$yt = $this->Ytstat->findBySql($qry_yt);
					$yt_data =$this->getyear($yt,'y','comments');
					
				}

			} // 		if(!empty($this->params['url']['id']))
			else
			{
				/*
				 select sum(s.views) , date_format(FROM_UNIXTIME(s.etime),'%m') from mss_stat s group by date_format(FROM_UNIXTIME(s.etime),'%m')
				 */

				$mss = $this->Mss->findBySql($qry_mss);
				$yt = $this->Ytstat->findBySql($qry_yt);
				
				$mss_data = $this->getyear($mss,'s','comments');
				$yt_data =$this->getyear($yt,'y','comments');


			} //		if(!empty($this->params['url']['id']))

				
			

	
				/*
				Month Wise Yearly date create
				*/

			$qry= "select DATE_SUB(CURDATE(), INTERVAL 1 Year) last, CURDATE() curr";
			$tfdate = $this->Ytstat->findBySql($qry);

			$dt =NULL;
			$date = NULL;
			$c=0;
			$td= $tfdate['0']['0']['curr'];
			$td=date('M',strtotime(date("Y-m-d", strtotime($td))));


			$d=$tfdate['0']['0']['last'];
			$edate=date('Y-m-d',strtotime(date("Y-m-d", strtotime($d)). " +1 Month"));
			$dt[$c]=date('M',strtotime(date("Y-m-d", strtotime($d)). " +1 Month"));

			while($td!=$date)
			{
				$date = date('M',strtotime(date("Y-m-d", strtotime($edate)) . " +1 Month"));

				$c ++;
				$dt[$c]= $date;
				$edate=date('Y-m-d',strtotime(date("Y-m-d", strtotime($edate)). " +1 Month"));
				if($c>12)
				{
				 break;
				} // 			if($c>12)
			} // while($tfdate['0']['0']['curr']!=$date)



		} // elseif($this->Session->read('lastdate')=='y') // yearly graphs quries

		$mscommentcount=NULL;
		$ytcommentcount=NULL;
			
		if($this->Session->read('lastdate')=='y') // set data according to date for yearly graph
		{

			$flg=0;
			if(empty($mss_data))
			{
				$mscount = 0;
			}
			else
			{
				$mscount = count($mss_data);
			}

			if(empty($yt_data))
			{
				$ytcount = 0;
			}
			else
			{
				$ytcount = count($yt_data);
			}
	
			$cnt=0;
			$ycnt=0;
			$lfcnt=0;
		

			foreach($dt as $key => $val)  // main date loop
			{
				$flg=0;

				for($i=0 ; $i < $mscount ; $i++)  // set Myspace views according to main loop date
				{
					if($mss_data[$i]['s']['etime']==$val)
					{
						$mscomment[$cnt]= $mss_data[$i]['s']['comments'] ;
						$mscommentcount	+= $mscomment[$cnt] ;
						$flg=1;
						$cnt++;
						break;
					} //	if($mss_data[$i]['s']['etime'])==$val)
				} // for($i=0 ; $i < $mscount-1 ; $i++)

				if($flg==0)
				{
					$mscomment[$cnt]=0;
					$cnt++;

				}


				$flg=0;
				$count=0;
				for($i=0 ; $i < $ytcount ; $i++) // set Youtube views according to main loop date
				{

					if($yt_data[$i]['y']['etime']==$val)
					{
						$ytcomment[$ycnt]= $yt_data[$i]['y']['comments'] ;
						$ytcommentcount+=$ytcomment[$ycnt] ;
						$flg=1;
						$ycnt ++;
						break;
					} //	if($yt_data[$i]['y']['etime']==$val)

				} // for($i=0 ; $i < $ytcount-1 ; $i++)

				if($flg==0)
				{
					$ytcomment[$ycnt]=0;
					$ycnt++;

				}
					

			
				/*	if($flg==0 and $albumcount!=0)
				 {
					$album_play[]= 0;
					} // if($flg==0)
					*/
			} // foreach($dt as $key => $val)
		} // if($this->Session->read('lastdate')=='y')
		else   // // set data according to date for Weekly & Monthly Graph
		{

			$flg=0;
			$mscount = count($mss);
			$ytcount = count($yt);
			$mscomment = NULL;
			$ytcomment=NULL;
			$flg=0;
			$cnt=0;
			$ycnt=0;
			$lfcnt=0;

			foreach($dt as $key => $val)  // main date loop
			{
				$flg=0;

				for($i=0 ; $i < $mscount ; $i++)  // set Myspace views according to main loop date
				{
					if(date('Y-m-d',$mss[$i]['s']['etime'])==$val)
					{

						if($i!=0)
						{
							$mscomment[$cnt]= $mss[$i]['s']['comments']-$mss[$i-1]['s']['comments'];
							$mscommentcount += $mscomment[$cnt] ;
						}
						else
						{
							$mscomment[$cnt] = 0;
						}
						$flg=1;
						$cnt++;

						break;

					} //	if(date('Y-m-d',$mss[$i]['s']['etime'])==$val)
				} // for($i=0 ; $i < $mscount-1 ; $i++)

				if($flg==0)
				{
					$mscomment[$cnt]=0;
					$cnt++;

				}


				$flg=0;
				$count=0;
				for($i=0 ; $i < $ytcount ; $i++) // set Youtube views according to main loop date
				{

					if(date('Y-m-d',$yt[$i]['y']['etime'])==$val)
					{

						if($i!=0)
						{
							$ytcomment[$ycnt]= $yt[$i]['y']['comments']-$yt[$i-1]['y']['comments'];
							$ytcommentcount = $ytcomment[$ycnt] ;

						}else
						{
							$ytcomment[$ycnt]=0;
						}
						$flg=1;
						$ycnt ++;
						break;
					} //	if(date('Y-m-d',$yt[$i]['y']['etime'])==$val)

				} // for($i=0 ; $i < $ytcount-1 ; $i++)

				if($flg==0)
				{
					$ytcomment[$ycnt]=0;
					$ycnt++;

				}
					
			} // foreach($dt as $key => $val)
		} // if($this->Session->read('lastdate')=='y')

		/*
		*	Session to set Average hits
		*/
		$this->Session->write('ytcommentcount',$ytcommentcount);
		$this->Session->write('mscommentcount',$mscommentcount);				

		/*
		*	youtube and myspace data
		*/
		$this->Session->write('dt',$dt);
		$this->Session->write('mscomment',$mscomment);
		$this->Session->write('ytcomment',$ytcomment);
		
		$msaverage  = 0;
		$ytaverage  = 0;
		$lfmaverage = 0;


		if($this->Session->read('lastdate')=='w')
		{
			$msaverage = round($mscommentcount/7,2);
			$ytaverage = round($ytcommentcount/7,2);
		}
		elseif($this->Session->read('lastdate')=='m')
		{
			$mm=$this->Session->read('mm');
			$msaverage = round($mscommentcount/$mm,2);
			$ytaverage = round($ytcommentcount/$mm,2);
		}
		elseif($this->Session->read('lastdate')=='y')
		{
			$msaverage = round($mscommentcount/12,2);
			$ytaverage = round($ytcommentcount/12,2);
		}

		$this->Session->write('msaverage',$msaverage);
		$this->Session->write('ytaverage',$ytaverage);
		$this->Session->write('lfmaverage',$lfmaverage);
		
		return true;		

	} // function setcommentchart()


	
	/*
	 Name	:	viewschart
	 Desc	:	Get graph values from Session and display graph
	 */
	function viewschart()
	{

		$dt = $this->Session->read('dt');
		$msview = $this->Session->read('msview');
		$ytview = $this->Session->read('ytview');
		$lfmplay = $this->Session->read('lfmplay');

		$this->set('dt',$dt);
		$this->set('msview',$msview);
		$this->set('ytview',$ytview);
		$this->set('lfmplay',$lfmplay);
	}



	/*
	 Name	:	setviewschart
	 Desc	:	Get graph values and return to views()
	 */
	function setviewschart()
	{
		
		if($this->Session->check('id') and $this->Session->check('band_id'))
		{
		
		$mmm_id  =	$this->Session->read('id');
		$band_id =	$this->Session->read('band_id');
		
		} 
		else
		{
			//$this->Session->setFlash('Session Expired');
			//$this->redirect('/analytics/index/');
			return ;
		} // 		if($this->Session->check('music') and $this->Session->check('profile') and $this->Session->check('channel') and $this->Session->check('email') and $this->Session->check('topalbum'))


		$mss= NULL;
		$yt=NULL;
		$album=NULL;
		
		if($this->Session->read('lastdate')=='w') // weekly graphs quries
		{

			$qry_mss = "select s.views , s.etime from mss_stat s , mss_login l where s.mss_id = l.mss_id and l.band_id=$band_id and l.mmm_id = '$mmm_id' and l.status=1 and FROM_UNIXTIME(s.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) order by etime";

			$qry_yt = "select y.views , y.etime from yt_stat y , yt_login l where y.yt_id = l.yt_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and 	FROM_UNIXTIME(y.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) order by etime";

			$qry_lfm = "select sum(t.playcount) playcount  , t.etime from lfm_top_tracks t , lfm_music l where l.lfm_m_id =t.lfm_m_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and FROM_UNIXTIME(t.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) group by t.etime order by etime";
			
			
		   			
			if(!empty($this->params['url']['id']))
			{

				if ($this->Session->check('msv'))
				{
					$mss = $this->Mss->findBySql($qry_mss);
				}

				if ($this->Session->check('ytv'))
				{
					$yt = $this->Ytstat->findBySql($qry_yt);
				}

				if ($this->Session->check('lfmsv'))
				{


					$album = $this->Lfmalbum->findBySql($qry_lfm);
				}
			} // 		if(!empty($this->params['url']['id']))
			else
			{
				
				$mss = $this->Mss->findBySql($qry_mss);
				$yt = $this->Ytstat->findBySql($qry_yt);
				$album = $this->Lfmalbum->findBySql($qry_lfm);

			} //		if(!empty($this->params['url']['id']))
			
			
			
			$qry= "select DATE_SUB(CURDATE(), INTERVAL 7 DAY) last, CURDATE() curr";
			$tfdate = $this->Ytstat->findBySql($qry);

			$dt =NULL;
			$date = NULL;
			$c=0;
			$dt[$c]=$tfdate['0']['0']['last'];

			while($tfdate['0']['0']['curr']!=$date)
			{
				$date = date('Y-m-d',strtotime(date("Y-m-d", strtotime($dt[$c])) . " +1 day"));
				$c ++;
				if($c==7)	 // i.e 0-6 last 7 days
				{
					break;
				}
				$dt[$c]= $date;

			} // while($tfdate['0']['0']['curr']!=$date)

		} // if($this->Session->read('lastdate')=='w') // weekly graphs quries
		elseif($this->Session->read('lastdate')=='m') // monthly graphs quries
		{

				$qry_mss = "select s.views , s.etime from mss_stat s , mss_login l where  s.mss_id = l.mss_id and l.band_id=$band_id and l.mmm_id ='$mmm_id' and l.status=1 and FROM_UNIXTIME(s.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Month) AND CURDATE( ) order by etime";

				$qry_yt = "select y.views , y.etime from yt_stat y , yt_login l where  y.yt_id = l.yt_id  and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and 	FROM_UNIXTIME(y.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Month) AND CURDATE( ) order by etime";

				$qry_lfm = "select sum(t.playcount) playcount  , t.etime from lfm_top_tracks t , lfm_music l where l.lfm_m_id =t.lfm_m_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and FROM_UNIXTIME(t.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Month) AND CURDATE( ) group by t.etime order by etime";
				

			if(!empty($this->params['url']['id']))
			{

				if ($this->Session->check('msv'))
				{
					$mss = $this->Mss->findBySql($qry_mss);
	

				}

				if ($this->Session->check('ytv'))
				{
					$yt = $this->Ytstat->findBySql($qry_yt);
				}

				if ($this->Session->check('lfmsv'))
				{

					$album = $this->Lfmalbum->findBySql($qry_lfm);
				}
			} // 		if(!empty($this->params['url']['id']))
			else
			{


				$mss = $this->Mss->findBySql($qry_mss);
				$yt = $this->Ytstat->findBySql($qry_yt);
				$album = $this->Lfmalbum->findBySql($qry_lfm);

			} //		if(!empty($this->params['url']['id']))


			$qry= "select DATE_SUB(CURDATE(), INTERVAL 1 Month) last, CURDATE() curr";
			$tfdate = $this->Ytstat->findBySql($qry);

			$dt =NULL;
			$date = NULL;

			
			$c=0;
			$cdate= $tfdate['0']['0']['curr'];
			$curdate = date('Y-m-d',strtotime(date("Y-m-d", strtotime($cdate)) . " -1 day"));
			$d=$tfdate['0']['0']['last'];
			$dt[$c]=date('Y-m-d',strtotime(date("Y-m-d", strtotime($d))));

			while($curdate!=$date)
			{
				$date = date('Y-m-d',strtotime(date("Y-m-d", strtotime($dt[$c])) . " +1 day"));
				$c ++;
				$dt[$c]= $date;

			} // while($tfdate['0']['0']['curr']!=$date)

			$this->Session->write('mm',count($dt));

		} // elseif($this->Session->read('lastdate')=='m') // monthly graphs quries

		elseif($this->Session->read('lastdate')=='y') // yearly graphs quries
		{

			$qry_mss = "select s.views , s.etime from mss_stat s , mss_login l where  s.mss_id = l.mss_id and l.band_id=$band_id and l.mmm_id = '$mmm_id' and l.status=1 and FROM_UNIXTIME(s.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Year) AND CURDATE( ) order by etime";

			$qry_yt = "select y.views , y.etime from yt_stat y , yt_login l where  y.yt_id = l.yt_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and FROM_UNIXTIME(y.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Year) AND CURDATE( ) order by etime";

			// special condition applied in getyear function because of sum(t.playcount) reutrn [0][playcount] instead of [t][playcount]
			$qry_lfm = "select sum(t.playcount) playcount  , t.etime etime from lfm_top_tracks t , lfm_music l where l.lfm_m_id =t.lfm_m_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and FROM_UNIXTIME(t.etime) between DATE_SUB(CURDATE(), INTERVAL 1 Year) AND CURDATE( ) group by t.etime order by t.etime"; 

			

			if(!empty($this->params['url']['id']))
			{

				if ($this->Session->check('msv'))
				{
					$mss = $this->Mss->findBySql($qry_mss);
					$mss_data = $this->getyear($mss,'s','views');
					
				}

				if ($this->Session->check('ytv'))
				{
					$yt = $this->Ytstat->findBySql($qry_yt);
					$yt_data =$this->getyear($yt,'y','views');
					
				}

				if ($this->Session->check('lfmsv'))
				{

					$album = $this->Lfmalbum->findBySql($qry_lfm);
					$album_data = $this->getyear($album,'t','playcount');
					
						
				}
			} // 		if(!empty($this->params['url']['id']))
			else
			{

				$mss = $this->Mss->findBySql($qry_mss);
				$yt = $this->Ytstat->findBySql($qry_yt);
				$album = $this->Lfmalbum->findBySql($qry_lfm);
				
				
				$mss_data = $this->getyear($mss,'s','views');
				$yt_data =$this->getyear($yt,'y','views');
				$album_data = $this->getyear($album,'t','playcount');
			} //		if(!empty($this->params['url']['id']))

			

			/*
				Month Wise Yearly date create
				*/

			$qry= "select DATE_SUB(CURDATE(), INTERVAL 1 Year) last, CURDATE() curr";
			$tfdate = $this->Ytstat->findBySql($qry);

			$dt =NULL;
			$date = NULL;
			$c=0;
			$td= $tfdate['0']['0']['curr'];
			$td=date('M',strtotime(date("Y-m-d", strtotime($td))));


			$d=$tfdate['0']['0']['last'];
			$edate=date('Y-m-d',strtotime(date("Y-m-d", strtotime($d)). " +1 Month"));
			$dt[$c]=date('M',strtotime(date("Y-m-d", strtotime($d)). " +1 Month"));

			while($td!=$date)
			{
				$date = date('M',strtotime(date("Y-m-d", strtotime($edate)) . " +1 Month"));

				$c ++;
				$dt[$c]= $date;
				$edate=date('Y-m-d',strtotime(date("Y-m-d", strtotime($edate)). " +1 Month"));
				if($c>12)
				{
				 break;
				} // 			if($c>12)
			} // while($tfdate['0']['0']['curr']!=$date)



		} // elseif($this->Session->read('lastdate')=='y') // yearly graphs quries

			$msviewscount = NULL;
			$ytviewscount = NULL;
			$lfmviewscount = NULL;
			
		if($this->Session->read('lastdate')=='y') // set data according to date for yearly graph
		{

			$flg=0;
			if(empty($mss_data))
			{
				$mscount = 0;
			}
			else
			{
				$mscount = count($mss_data);
			}

			if(empty($yt_data))
			{
				$ytcount = 0;
			}
			else
			{
				$ytcount = count($yt_data);
			}
	
			if(empty($album_data))
			{
				$albumcount = 0;
			}
			else
			{
				$albumcount = count($album_data);
			}

			
			
			$flg=0;
			$cnt=0;
			$ycnt=0;
			$lfcnt=0;


			foreach($dt as $key => $val)  // main date loop
			{
				$flg=0;

				for($i=0 ; $i < $mscount ; $i++)  // set Myspace views according to main loop date
				{
					if($mss_data[$i]['s']['etime']==$val)
					{
						$msview[$cnt]= $mss_data[$i]['s']['views'] ;
						$msviewscount+=$msview[$cnt];
						
						$flg=1;
						$cnt++;
						break;
					} //	if($mss_data[$i]['s']['etime'])==$val)
				} // for($i=0 ; $i < $mscount-1 ; $i++)

				if($flg==0)
				{
					$msview[$cnt]=0;
					$cnt++;

				}


				$flg=0;
				$count=0;
				for($i=0 ; $i < $ytcount ; $i++) // set Youtube views according to main loop date
				{

					if($yt_data[$i]['y']['etime']==$val)
					{
						$ytview[$ycnt]= $yt_data[$i]['y']['views'] ;
						$ytviewscount+=$ytview[$ycnt];
						$flg=1;
						$ycnt ++;
						break;
						
					} //	if($yt_data[$i]['y']['etime']==$val)

				} // for($i=0 ; $i < $ytcount-1 ; $i++)

				if($flg==0)
				{
					$ytview[$ycnt]=0;
					$ycnt++;

				}
					

				
				$flg=0;
				for($i=0 ; $i < $albumcount ; $i++)	// set Las.fm top album playcount according to main loop date
				{
					if($album_data[$i]['t']['etime']==$val)
					{

						$lfmplay[$lfcnt]= $album_data[$i]['t']['playcount'];
						$lfmviewscount+=$album_play[$lfcnt];
						$flg=1;
						$lfcnt++;
						break;
					} //	if($album_data[$i]['t']['etime']==$val)

				} // for($i=0 ; $i < $ytcount-1 ; $i++)

				if($flg==0)
				{
					$lfmplay[$lfcnt]=0;
					$lfcnt++;

				}

					
				/*	if($flg==0 and $albumcount!=0)
				 {
					$album_play[]= 0;
					} // if($flg==0)
					*/
			} // foreach($dt as $key => $val)
		} // if($this->Session->read('lastdate')=='y')
		else   // // set data according to date for Weekly & Monthly Graph
		{

			$flg=0;
			$mscount = count($mss);
			$ytcount = count($yt);
			$albumcount = count($album);
		
			
			
			$flg=0;
			$cnt=0;
			$ycnt=0;
			$lfcnt=0;
			
			
			
			foreach($dt as $key => $val)  // main date loop
			{
				$flg=0;

				for($i=0 ; $i < $mscount ; $i++)  // set Myspace views according to main loop date
				{
					if(date('Y-m-d',$mss[$i]['s']['etime'])==$val)
					{

						if($i!=0)
						{
							$msview[$cnt]= $mss[$i]['s']['views']-$mss[$i-1]['s']['views'];
							$msviewscount+=$msview[$cnt];
						}
						else
						{
							$msview[$cnt] = 0;
						}
						$flg=1;
						$cnt++;

						break;

					} //	if(date('Y-m-d',$mss[$i]['s']['etime'])==$val)
				} // for($i=0 ; $i < $mscount-1 ; $i++)

				if($flg==0)
				{
					$msview[$cnt]=0;
					$cnt++;

				}


				$flg=0;
				$count=0;
				for($i=0 ; $i < $ytcount ; $i++) // set Youtube views according to main loop date
				{

					if(date('Y-m-d',$yt[$i]['y']['etime'])==$val)
					{

						if($i!=0)
						{
							$ytview[$ycnt]= $yt[$i]['y']['views']-$yt[$i-1]['y']['views'];
							$ytviewscount+=$ytview[$ycnt];

						}else
						{
							$ytview[$ycnt]=0;
						}
						$flg=1;
						$ycnt ++;
						break;
					} //	if(date('Y-m-d',$yt[$i]['y']['etime'])==$val)

				} // for($i=0 ; $i < $ytcount-1 ; $i++)

				if($flg==0)
				{
					$ytview[$ycnt]=0;
					$ycnt++;

				}
					


				$flg=0;
				for($i=0 ; $i < $albumcount ; $i++)	// set Las.fm top album playcount according to main loop date
				{
					if(date('Y-m-d',$album[$i]['t']['etime'])==$val)
					{
						if($i!=0)
						{
							$lfmplay[$lfcnt]= $album[$i][0]['playcount']-$album[$i-1][0]['playcount'];
							$lfmviewscount+=$lfmplay[$lfcnt];

						}
						else
						{
							$lfmplay[$lfcnt]=0;
						}
						$flg=1;
						$lfcnt++;
						break;
					} //	if(date('Y-m-d',$yt[$i]['y']['etime'])==$val)

				} // for($i=0 ; $i < $ytcount-1 ; $i++)

				if($flg==0)
				{
					
					$lfmplay[$lfcnt]=0;
					$lfcnt++;

				}

				/*	if($flg==0 and $albumcount!=0)
				 {
					$album_play[]= 0;
					} // if($flg==0)
					*/
			} // foreach($dt as $key => $val)
		} // if($this->Session->read('lastdate')=='y')



		/*
		*	Session set to get weekly , monthly & yearly average / Percentage
		*/			
		$this->Session->write('msviewscount',$msviewscount);
		$this->Session->write('ytviewscount',$ytviewscount);
		$this->Session->write('lfmviewscount',$lfmviewscount);


		
	
		/*
		*	Session to set Graph data
		*/
		$this->Session->write('dt',$dt);
		$this->Session->write('msview',$msview);
		$this->Session->write('ytview',$ytview);
		$this->Session->write('lfmplay',$lfmplay);

			$msaverage = 0;
			$ytaverage = 0;
			$lfmaverage = 0;

			if($this->Session->read('lastdate')=='w')
			{
				$msaverage = round($msviewscount/7,2);
				$ytaverage = round($ytviewscount/7,2);
				$lfmaverage = round($lfmviewscount/7,2);
	
			}
			elseif($this->Session->read('lastdate')=='m')
			{
				$mm=$this->Session->read('mm');
				$msaverage = round($msviewscount/$mm,2);
				$ytaverage = round($ytviewscount/$mm,2);
				$lfmaverage = round($lfmviewscount/$mm,2);
	
			}
			elseif($this->Session->read('lastdate')=='y')
			{
				$msaverage = round($msviewscount/12,2);
				$ytaverage = round($ytviewscount/12,2);
				$lfmaverage = round($lfmviewscount/12,2);
	
			}
	
			$this->Session->write('msaverage',$msaverage);
			$this->Session->write('ytaverage',$ytaverage);
			$this->Session->write('lfmaverage',$lfmaverage);
			
		return true;

	} // function viewschart()


	/*
	 Name	:	playschart
	 Desc	:	Get graph values from sessions and display graph
	 */

	function playschart()
	{

		$dt = $this->Session->read('dt');
		$msplays = $this->Session->read('msplays');
		$ytplays = $this->Session->read('ytplays');
		$lfmplays = $this->Session->read('lfmplays');

		
		$this->set('dt',$dt);
		$this->set('msplays',$msplays);
		$this->set('ytplays',$ytplays);
		$this->set('lfmplays',$lfmplays);
				
	} // function playschart()


/*
	 Name	:	setplayschart
	 Desc	:	Get graph values and return to plays()
	*/
	function setplayschart()
	{

		if($this->Session->check('id') and $this->Session->check('band_id') and $this->Session->check('mssvideo') and $this->Session->check('video') and $this->Session->check('toptrack'))
		{
		
		$mmm_id  =	$this->Session->read('id');
		$band_id =	$this->Session->read('band_id');
		
		$mssvideo = 	addslashes($this->Session->read('mssvideo'));
		$video =	addslashes($this->Session->read('video'));
		$lfm_track =	addslashes($this->Session->read('toptrack'));
		
		} 
		else
		{
			//$this->Session->setFlash('Session Expired');
			//$this->redirect('/analytics/index/');
			return ;
		} // 		if($this->Session->check('music') and $this->Session->check('profile') and $this->Session->ch


		$mss= NULL;
		$yt=NULL;
		$album=NULL;

		if($this->Session->read('lastdate')=='w') // weekly graphs quries
		{

			$qry_mss = "select s.plays , s.etime from mss_play_stat s , mss_login l where s.title='$mssvideo' and s.mss_id = l.mss_id and l.band_id=$band_id and l.mmm_id = '$mmm_id' and l.status=1 and FROM_UNIXTIME(s.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) order by etime";
			
			$qry_yt = "select y.views plays , y.etime from yt_comments_stat y , yt_login l where title='$video' and y.yt_id = l.yt_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and 	FROM_UNIXTIME(y.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) order by etime";

			$qry_lfm = "select t.playcount plays , t.etime from lfm_top_tracks t , lfm_music l where t.name='$lfm_track' and l.lfm_m_id =t.lfm_m_id and l.band_id=$band_id and l.mmm_id='$mmm_id' and l.status=1 and FROM_UNIXTIME(t.etime) between DATE_SUB(CURDATE(), INTERVAL 9 DAY) AND CURDATE( ) order by	etime";


			if(!empty($this->params['url']['id']))
			{

				if ($this->Session->check('msp'))
				{
					
					$mss = $this->Mss->findBySql($qry_mss);
				}

				if ($this->Session->check('ytp'))
				{
					$yt = $this->Ytstat->findBySql($qry_yt);
				}

				if ($this->Session->check('lfmsp'))
				{
					$lfm = $this->Ytstat->findBySql($qry_lfm);
				}


			} // 		if(!empty($this->params['url']['id']))
			else
			{


				$mss = $this->Mss->findBySql($qry_mss);
				$yt = $this->Ytstat->findBySql($qry_yt);
				$lfm = $this->Ytstat->findBySql($qry_lfm);


			} //		if(!empty($this->params['…