<?php

  include_once('header.php');
  if(headers_sent()) die('Should not output data before json');
  if(!isset($_SESSION['userid'])){
    header('Content-type: application/json');
    echo '{"success":"true","reirect":"1"}';
    exit();
  }
  @ob_clean();
  ob_start();

  $table=PREFIX.'connections';
  $where="friend_id=".cleaninputfield($_SESSION['userid'])." AND status=0";
  $friends=$db->count_records($table,$where);
  
  $table=PREFIX."users urs INNER JOIN ".PREFIX."club_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."clubs cb ON cb.id=perm.club_id ";
  $where="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";
  $records=$db->count_records($table,$where);
  
  $tables=PREFIX."users urs  INNER JOIN ".PREFIX."clubs cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."club_permissions perm ON cb.id=perm.club_id ";
  $wheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";
  $record=$db->count_records($tables,$wheres);

/*$grouptable=PREFIX."users urs INNER JOIN ".PREFIX."group_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."groups cb ON cb.id=perm.group_id ";
  $groupwhere="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";*/

  $grouptable=PREFIX."users urs INNER JOIN ".PREFIX."group_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."groups cb ON cb.id=perm.group_id ";
  $groupwhere="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";

  $grouprecords=$db->count_records($grouptable,$groupwhere,array('range'=>'distinct perm.id'));

/*$grouptables=PREFIX."users urs  INNER JOIN ".PREFIX."groups cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."group_permissions perm ON cb.id=perm.group_id ";
  $groupwheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";*/

  $grouptables=PREFIX."users urs  INNER JOIN ".PREFIX."groups cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."group_permissions perm ON cb.id=perm.group_id ";
  $groupwheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";
  $grouprecord=$db->count_records($grouptables,$groupwheres);
  
  $tables=PREFIX."notifications";
  $wheres="user_id=".cleaninputfield($_SESSION['userid'])." AND seen=0";
  $notifications=$db->count_records($tables,$wheres);
  
  $table=PREFIX."events_invite invites INNER JOIN ".PREFIX."events eve ON invites.event_id=eve.id INNER JOIN ".PREFIX."schedules sch ON sch.id=eve.sch_id";
  $wheres="invites.invitee=".cleaninputfield($_SESSION['userid'])." AND invites.status=0";
  $events=$db->count_records($table,$wheres);
 
  $companytable=PREFIX."users urs INNER JOIN ".PREFIX."comp_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."companies cb ON cb.id=perm.comp_id ";
  $companywhere="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";
  $companyrecords=$db->count_records($companytable,$companywhere);


  $companytables=PREFIX."users urs  INNER JOIN ".PREFIX."companies cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."comp_permissions perm ON cb.id=perm.comp_id ";
  $companywheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";
  $companyrecord=$db->count_records($companytables,$companywheres);

    
  $jsonResponse = new stdClass();
  $jsonResponse->success = true;
  $jsonResponse->friends = $record+$records+$friends+$events+$grouprecord+$grouprecords+$companyrecords+$companyrecord;
  $jsonResponse->notifications = $notifications;
  $jsonResponse->messages = 0;
  $jsonResponse->reirect = 0;

  ob_end_clean();
  header('Content-type: application/json');
  echo json_encode($jsonResponse);
  exit; 

?>