<?php $search = $this->session->userdata('search_form');
 if($search['startdate']){
 echo '<h4>'.date('M d, Y',strtotime($search['startdate'])).' - '.date('M d, Y',strtotime($search['enddate'])).'</h4>';
 }
 ?>
             <table cellspacing="0" cellpadding="1" border="1">
                
                     <tr style="background-color:#428bca;color:#fff;">
                        <th width="8%">Sl.No.</th>
                        <th width="30%">Name</th>                                          
                         <th width="10%">Total Hits</th>
                         <th width="10%">Total Time Watched</th>	
                         <th width="15%">Browser</th>	
                         <th width="10%">IP</th>	
                         <th width="15%">Date</th>	
                     </tr>
                
                     <?php foreach ($result as $value) { $i++;?>
                     <tr>
                             <td width="8%"><?php echo $i;?></td>
                             <td  width="30%"><!--a href="<?php echo base_url(); ?>analytics/user/<?php echo $value->id; ?>"--><?php echo ($value->name!='') ? $value->name : 'guest'; ?></td>                                               
                             <td  width="10%"><?php echo $value->total_hits; ?></td>
                             <td width="10%"><?php echo time_from_seconds($value->total_watched_time); ?></td>                                                                                        
                             <td width="15%"><?php echo $value->browser; ?></td>                                                                                        
                             <td width="10%"><?php echo $value->ip; ?></td>                                                                                        
                             <td width="15%"><?php echo date("d/m/Y H:i:s", strtotime($value->created)); ?></td>                                                                                           
                         </tr>
                     <?php } ?>                                    
             </table>                                                    
        
 function editChannelCuePoints()
 {
     //$new_array = array();
     $channel_cue_points = $this->videos_model->getChannelCuePoints($_POST['channel_id']);
     if (count($channel_cue_points) > 0) {
         $i = 1;
         foreach ($channel_cue_points as $key => $val) {
             $new_array[$i]['title'] = $val->title;
             $new_array[$i]['cuepoint'] = time_from_seconds($val->cue_points);
             $i++;
         }
     }
     echo json_encode($new_array);
     exit;
 }
 function export()
 {
     $search = $this->session->userdata('search_form');
     //echo $this->uri->segment(4);die;
     //-- sorting input --//
     $sort_i = $this->uri->segment(5);
     $sort_by = $this->uri->segment(6);
     $type = $this->uri->segment(8);
     if ($this->uri->segment(9) == 'country') {
         $country = $this->uri->segment(10);
     } else {
         $id = $this->uri->segment(10);
     }
     $sort = $this->sort_input($sort_i, $sort_by);
     //-----//
     //-- result --//
     $this->data['result'] = $this->Analytics_model->getReport(array('code' => $country, 'id' => $id, 'type' => $type, 'search' => $search), $sort, $sort_by);
     //echo '<pre>';print_r($this->data['result']);die;
     if ($type == 'content') {
         if ($this->uri->segment(4) == 'pdf') {
             $content = $this->load->view('templates/pdf_content', $this->data, true);
             //-- create pdf --//
             create_pdf($content, 'Content Base Report');
         } elseif ($this->uri->segment(4) == 'csv') {
             $heading = array('Name', 'Content Provider', 'Platform', 'Browser', 'Location', 'Date', 'Total Hits', 'Total time watched');
             //$content =  $this->load->view('templates/pdf_content',$this->data,true);
             $dataRpt = array();
             $num = 0;
             foreach ($this->data['result'] as $p) {
                 $dataRpt[$num]['title'] = $p->title;
                 $dataRpt[$num]['content_provider'] = $p->content_provider;
                 $dataRpt[$num]['platform'] = $p->platform;
                 $dataRpt[$num]['browser'] = $p->browser;
                 $dataRpt[$num]['location'] = $p->country;
                 $dataRpt[$num]['date'] = $p->created;
                 $dataRpt[$num]['hits'] = $p->total_hits;
                 $dataRpt[$num]['watched time'] = time_from_seconds($p->total_watched_time);
                 $num++;
             }
             query_to_csv($dataRpt, $heading);
             //echo query_to_csv($content);
             //exit;
         }
     }
     if ($type == 'usercontent') {
         if ($this->uri->segment(4) == 'pdf') {
             $content = $this->load->view('templates/pdf_usercontent', $this->data, true);
             //-- create pdf --//
             create_pdf($content, 'User Content Report');
         } elseif ($this->uri->segment(4) == 'csv') {
             $heading = array('Name', 'Content Provider', 'Platform', 'Browser', 'Location', 'Date', 'Total Hits', 'Total time watched');
             //$content =  $this->load->view('templates/pdf_content',$this->data,true);
             //print_r($this->data['result']);die;
             $dataRpt = array();
             $num = 0;
             foreach ($this->data['result'] as $p) {
                 $dataRpt[$num]['title'] = $p->title;
                 $dataRpt[$num]['content_provider'] = $p->content_provider;
                 $dataRpt[$num]['platform'] = $p->platform;
                 $dataRpt[$num]['browser'] = $p->browser;
                 $dataRpt[$num]['location'] = $p->country;
                 $dataRpt[$num]['date'] = $p->created;
                 $dataRpt[$num]['hits'] = $p->total_hits;
                 $dataRpt[$num]['watched time'] = time_from_seconds($p->total_watched_time);
                 $num++;
             }
             query_to_csv($dataRpt, $heading);
             //echo query_to_csv($content);
             //exit;
         }
     }
     if ($type == 'user') {
         if ($this->uri->segment(4) == 'pdf') {
             $user = $this->load->view('templates/pdf_user', $this->data, true);
             //-- create pdf --//
             create_pdf($user, 'User Based Report');
         } elseif ($this->uri->segment(4) == 'csv') {
             $heading = array('Name', 'Total Hits', 'Total time watched', 'Browser', 'IP', 'Date');
             //$content =  $this->load->view('templates/pdf_content',$this->data,true);
             $dataRpt = array();
             $num = 0;
             foreach ($this->data['result'] as $p) {
                 $dataRpt[$num]['name'] = $p->name != '' ? $p->name : 'guest';
                 $dataRpt[$num]['hits'] = $p->total_hits;
                 $dataRpt[$num]['watched time'] = time_from_seconds($p->total_watched_time);
                 $dataRpt[$num]['browser'] = $p->browser;
                 $dataRpt[$num]['ip'] = $p->ip;
                 $dataRpt[$num]['date'] = date("d/m/Y H:i:s", strtotime($p->created));
                 $num++;
             }
             query_to_csv($dataRpt, $heading);
             //echo query_to_csv($content);
             //exit;
         }
     }
     if ($type == 'useragent') {
         if ($this->uri->segment(4) == 'pdf') {
             $content = $this->load->view('templates/pdf_device', $this->data, true);
             //-- create pdf --//
             create_pdf($content, 'Device Base Report');
         } elseif ($this->uri->segment(4) == 'csv') {
             $heading = array('Platform', 'Browser', 'Total Hits', 'Total time watched');
             //$content =  $this->load->view('templates/pdf_content',$this->data,true);
             $dataRpt = array();
             $num = 0;
             foreach ($this->data['result'] as $p) {
                 $dataRpt[$num]['platform'] = $p->platform;
                 $dataRpt[$num]['browser'] = $p->browser;
                 $dataRpt[$num]['hits'] = $p->total_hits;
                 $dataRpt[$num]['watched time'] = time_from_seconds($p->total_watched_time);
                 $num++;
             }
             query_to_csv($dataRpt, $heading);
             //echo query_to_csv($content);
             //exit;
         }
     }
     if ($type == 'region') {
         if ($this->uri->segment(4) == 'pdf') {
             $geomap = $this->load->view('templates/pdf_geomap', $this->data, true);
             //-- create pdf --//
             create_pdf($geomap, 'Region Based Report');
         } elseif ($this->uri->segment(4) == 'csv') {
             $heading = array('Country', 'Region', 'Total Hits', 'Total time watched');
             //$content =  $this->load->view('templates/pdf_content',$this->data,true);
             $dataRpt = array();
             $num = 0;
             foreach ($this->data['result'] as $p) {
                 $dataRpt[$num]['country'] = $p->country;
                 $dataRpt[$num]['state'] = $p->state;
                 $dataRpt[$num]['hits'] = $p->total_hits;
                 $dataRpt[$num]['watched time'] = time_from_seconds($p->total_watched_time);
                 $num++;
             }
             query_to_csv($dataRpt, $heading);
             //echo query_to_csv($content);
             //exit;
         }
     }
     if ($type == 'country') {
         $this->data['c'] = 1;
         if ($this->uri->segment(4) == 'pdf') {
             $geomap = $this->load->view('templates/pdf_geomap', $this->data, true);
             //-- create pdf --//
             create_pdf($geomap, 'Country Based Report');
         } elseif ($this->uri->segment(4) == 'csv') {
             $heading = array('Location', 'Country', 'Total Hits', 'Total time watched');
             //$content =  $this->load->view('templates/pdf_content',$this->data,true);
             $dataRpt = array();
             $num = 0;
             foreach ($this->data['result'] as $p) {
                 $dataRpt[$num]['Location'] = $p->city != '' ? $p->city : 'Unknown';
                 $dataRpt[$num]['country'] = $p->country;
                 $dataRpt[$num]['hits'] = $p->total_hits;
                 $dataRpt[$num]['watched time'] = time_from_seconds($p->total_watched_time);
                 $num++;
             }
             query_to_csv($dataRpt, $heading);
             //echo query_to_csv($content);
             //exit;
         }
     }
 }
                                </div>
                                <div class="table-responsive">
                                        <!-- .table - Uses sparkline charts-->
                                        <table class="table table-striped">
                                            <tr>
                                                <th>Location</th>
                                                <th>Hits</th>
                                                <th>Time Watched</th>                                                
                                            </tr>
					    <?php foreach($geomap as $row){
                                             //if($row->state !=''){
                                             ?>
                                            <tr>
                                                <td><?php echo ($row->city!='') ? $row->city : 'Unknown';?></td>
                                                <td><?php echo $row->total_hits;?></td>
						<td><?php echo time_from_seconds($row->total_watched_time);?></td>
                                            </tr>
					    <?php //} 
                                            
                                             }?>
                                            <tr><td>
                                            <!-- Pagination start --->
                                        <?php
                                        if ($this->pagination->total_rows == '0') {
                                            echo "<tr><td colspan=\"7\"><h4>" . $welcome->loadPo('No Record Found') . "</td></tr></h4>";
                                        } else {
                                            ?>
                                            

                                            <div class="row pull-left">
                                                <div class="dataTables_info" id="example2_info"><br>
                                            <tr>
                                                <th>City</th>
                                                <th>Country</th>
                                                <th>State</th>
                                                <th>Impresion</th>
                                                <!--th>Watch time</th-->
                                                
                                                <!--th>Time Watched</th-->                                                
                                            </tr>
					    <?php foreach($country as $row){?>
                                            <tr>
                                                <td><?=($row->city=='')?'Unknow':$row->city?></td>
                                                <td><?=($row->country=='')?'Unknow':$row->country?></td>
                                                <td><?=($row->state=='')?'Unknow':$row->state?></td>
                                                <td><?=$row->total_hits?></td>
                                                <!--td><?=time_from_seconds($row->total_watched_time)?></td-->
                                            </tr>
					    <?php }?>
                                            
                                        </table><!-- /.table -->
                                    </div>
			
		    </div><!-- /.box-body -->
		    <div><a href='<?php echo base_url()?>ads_analytics/geographic?c=1' style="float:right;">View All</a></div>
		</div><!-- /.box -->
		
		<div class="box box-primary">
                                <div class="box-header">
                                   <!-- tools box -->
                                    <div class="pull-right box-tools">
                                        <button class="btn btn-danger btn-sm" data-widget='collapse' data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>