<?php

class PG_Controller_Plugin_LOC
extends Zend_Controller_Plugin_Abstract
{
    
	public function Check($UserID){
	$Number =0;
	$ProfileDB = new Model_Profile;
                        $Profile = $ProfileDB->fetchRow("UserID ='".$UserID."'");
                        $LOCDATA = json_decode($Profile["LOC"],true);	
                        if(count($LOCDATA)>0){
                        foreach ($LOCDATA as $data){
                            $Tourn = new Model_Tournament;
                            $Tournament = $Tourn->getEndDate($data["TID"]);
                            if(strtotime($Tournament["EndDate"])> strtotime(date("Y-m-d H:i:s"))){
                                $Number++;
                            }
                        }
                        }
			return $Number;	
	}
        
        public function getTournLoc($UserID){
	$Number =0;
	$ProfileDB = new Model_Profile;
                        $Profile = $ProfileDB->fetchRow("UserID ='".$UserID."'");
                        $LOCDATA = json_decode($Profile["LOC"],true);	
                        $LISTTOURN = array();
                        if(count($LOCDATA)>0){
                        foreach ($LOCDATA as $data){
                            $Tourn = new Model_Tournament;
                            $Tournament = $Tourn->getEndDate($data["TID"]);
                            if(strtotime($Tournament["EndDate"])> strtotime(date("Y-m-d H:i:s"))){
                              $LISTTOURN[]=$data;
                            }
                        }
                        }
			return $LISTTOURN;	
	}
        
}