£Á°èZ¨Ä…–K§‚«“ô4“ÒÙ´dîfUÙÃÅ WKbyʦ•êŽ…È®FÒ¿ÊÎóCozá¬S@6{Í:›œêZÌ:Š•_%:¢¾¾~;‘Ã~芩ÊÇí`ÔÑ©ú뙵'5I¿fš×WO%ø9¾«¾DK|€ùÍD”Ýs]nHÕ¶ê×Ӽ㞪éUWŸÈË%DÒÕ¬ï‘]/Åcx ‰ï2ß]ä6G[]S£Ôϯrs{úëóµmÒï#UQxo·õÞCe]"±/aÙ&Eã4ú9Jé_ÞåëdãöKë)AÞ ¯¹ægƒÛowÐø^d™ý½ßB7áyMä9ÜÖUã
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
dateStart = date('Y-m-d',time());
if(isset($_GET["v"]))
$this->v = Video::LoadByCode($_GET["v"]);
if (!isset($this->v) || $this->v===FALSE)
$this->AddError("Sorry, video not found.");
else
if ($this->v->userid != $user->id)
$this->AddError("Access denied.");
if (count($this->errors) != 0)
{
$k=0;
foreach($this->errors as $er)
{
echo "".$er[$k]."
";
$k++;
}
include '../footer.inc.php';
die;
}
}
public function getData()
{
//echo mysql_num_rows($res);
//for search key
$query ='';
if(isset($_POST['periodTime']) && $_POST['periodTime'] != 'All')
{
$this->periodTime = $_POST['periodTime'];
switch($this->periodTime)
{
case "yesterday";
$ptime = strtotime("-1 day");
$this->showRef = '1';
break;
case "1week";
$ptime = strtotime("-1 week");
$this->showRef = '0';
break;
case "1month";
$ptime = strtotime("-1 month");
$this->showRef = '0';
break;
default:
$ptime = strtotime("now");
$this->showRef = '1';
break;
}
$ptime = date('Y-m-d',$ptime);
}
if(isset($_POST['vidIndex']) && @$_POST['vidIndex'] != '')
{
$Vstr = " AND videoIndex = '".$_POST['vidIndex']."'";
$groupBy = ",videoIndex";
}
else if(isset($_POST['vidIndex2']) && @$_POST['vidIndex2'] != '')
{
$Vstr = " AND videoIndex = '".$_POST['vidIndex2']."'";
$groupBy = ",videoIndex";
}
else { $Vstr = ''; }
// query construction begin here
$defaultQuery = "SELECT time as timeAll ,videoIndex,
(select avg(`timeSpent`) from stat_details where event!='open' and time=a.time AND video_id=".$this->v->id." ".$Vstr." ) as avgTime,
(select count(track_id) from stat_details where isCompleted='Y' and time=a.time AND video_id=".$this->v->id." ".$Vstr." ) as completed,
(select count(track_id) from stat_details where event='ping' and time=a.time AND video_id=".$this->v->id." ".$Vstr." ) as noOfTimesPing,
(select count(track_id) from stat_details where event='play' and time=a.time AND video_id=".$this->v->id." ".$Vstr." ) as playEvent,
(select count(DISTINCT(referrer)) from stat_details where time=a.time AND video_id=".$this->v->id." ".$Vstr." ) as referrerCount,
(select count(track_id) from stat_details where event='open' and time=a.time AND video_id=".$this->v->id." ".$Vstr." ) as noOfTimesOpen from stat_details a where video_id = '".$this->v->id."' ".$Vstr;
if(isset($_POST['dateStart']) && isset($_POST['dateEnd']))
{
$this->dateStart = @$_POST['dateStart'];
$this->dateEnd = @$_POST['dateEnd'];
$this->searchOption = '1';
$query1 =$defaultQuery." and time >= '".$this->dateStart."' and time <= '".$this->dateEnd."' group by time";
}
else if(isset($_POST['periodTime']) || isset($_POST['eventType']))
{
$this->searchOption = '0';
if($this->showRef == '1' && $_POST['periodTime'] != 'All')
{
$query1 = "select referrer as referrerCount, timeSpent as avgTime, event as playEvent,isCompleted as completed, time as timeAll,videoIndex from stat_details";
$query1.= " where time = '$ptime' and video_id = '".$this->v->id."'".$Vstr;
}
else if($this->periodTime == "All")
{
$this->showRef = '0';
$query1 =$defaultQuery." group by time";
}
else
{
$query1 =$defaultQuery." AND time >= '$ptime' AND time <= CURDATE() group by time";
}
}
else
{
$query1 =$defaultQuery." group by time";
}
//echo $query1; die;
//query end here
//echo $query1;
$res = mysql_query($query1) or die(mysql_error());
$knot = array();
while($fn = mysql_fetch_array($res))
{
$innner = array();
if($fn['avgTime'] > 60)
{
$mins = floor ($fn['avgTime'] / 60);
$secs = $fn['avgTime'] % 60;
if(strlen($secs) == 1)
{
$secs = "0".$secs;
}
$innner['avgTime'] = $mins.":".$secs;
}
else { $innner['avgTime'] = round($fn['avgTime']); }
if($this->showRef == 0)
{
$innner['opens'] = $fn['noOfTimesOpen'];
}
$innner['plays'] = $fn['playEvent'];
$innner['completed'] = $fn['completed'];
$innner['referrer'] = $fn['referrerCount'];
$innner['date'] = $fn['timeAll'];
$innner['videoIndex'] = $fn['videoIndex'];
array_push($knot,$innner);
}
return $knot;
}
function FillFromPost()
{
ObjectFromArray($this, $_POST);
if ($this->v->VideoTracking == "Y")
$this->stats = "true";
else
$this->stats = "false";
}
function Validate()
{
return TRUE;
}
function Save()
{
}
}
$log = new logDetail();
$log->FillFromPost();
if ($log->Validate())
$log->Save();
$mainData = $log->getData();
/*echo "";
print_r($mainData);*/
$sxml = simplexml_load_string($log->v->xml);
$videos = $sxml->playlist;
$dropD = array();
foreach($videos->children() as $mXml)
{
$files =(array) $mXml->attributes();
array_push($dropD,$files['@attributes']);
}
?>
Video stat details for : v->title; ?>
Search Criteria
1) { ?>
Video Index :
Result : searchOption == 0) { echo $log->periodTime; } else { echo $log->dateStart." To ".$log->dateEnd; } ?>
0) { ?>
