" . "

" . "

" . "

" . "

";

              // print_r($AwayTeam);

}





function clean($string) {

   $string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens.

   $string = preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.



   return preg_replace('/-+/', '-', $string); // Replaces multiple hyphens with single one.

}

public function copyfromprevAction(){

    $this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

		

		$reQuest = $this->getRequest();

	if($reQuest->isPost()){

                    $pfid = $reQuest->getParam("pfid");

                     $cfid = $reQuest->getParam("cfid");

                    $sid = $reQuest->getParam("sid");

                

                

                $FixtureTbl = new Model_Fixture;

		

                 

                 //GET FIXTURE

                $pFixture = $FixtureTbl->fetchRow("(FID = '".$pfid."' ) AND (HomeTeam ='".$sid."' OR AwayTeam ='".$sid."' )");

                $Lineup = $pFixture["TeamH"];

                if($pFixture["AwayTeam"]==$sid){

                   $Lineup = $pFixture["TeamA"]; 

                }

                

                

                $cFixture = $FixtureTbl->fetchRow("(FID = '".$cfid."' ) AND (HomeTeam ='".$sid."' OR AwayTeam ='".$sid."' )");

                

                if($cFixture["HomeTeam"]==$sid){

                   $FixtureTbl->update(array("DateModified"=>date("Y-m-d H:i:s"),"TeamH"=>$Lineup), "FID = '".$cfid."'") ;

                }

                if($cFixture["AwayTeam"]==$sid){

                    $FixtureTbl->update(array("DateModified"=>date("Y-m-d H:i:s"),"TeamA"=>$Lineup), "FID = '".$cfid."'") ;

                }

                $TeamHistory =  json_decode($cFixture["History"],true);

                    ;

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." copied line-up from previous fixture   ");

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s"),"TeamH"=>  json_encode($NewList)), $fid);

                

                

                }

                

}













public function getmembersAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

		

		$reQuest = $this->getRequest();

		if($reQuest->isPost()){

		$sid = $reQuest->getParam("sid");

		$type = $reQuest->getParam("type");

			

		$SquadsTbl = new Model_Squad;      

		$squad = $SquadsTbl->getSquad($sid);

			

			if($type==1){

			$listPlayers = json_decode($squad["Coaches"],true);

			}else{

			$listPlayers = json_decode($squad["Players"],true);

			}

			

			$NewplaersArray = array();

			

			$i = 0;

			foreach ($listPlayers as $player) {

				$profileDB = new Model_Profile;

				if($type==1) {

					

					

					$getProfile = $profileDB->GetPesonnalByPositions($player['ID'], $player['Position']);

					

					

					$NewplaersArray[$i]["UserID"] = $getProfile["UserID"];

					$NewplaersArray[$i]["Avatar"] = $getProfile["Avatar"];

					$NewplaersArray[$i]["FirstName"] = $getProfile["FirstName"];

					$NewplaersArray[$i]["LastName"] = $getProfile["LastName"];

					$NewplaersArray[$i]["Postion"] = $getProfile["POS"];

					$NewplaersArray[$i]["boksmart"] = $player["boksmart"];

					$NewplaersArray[$i]["PID"] = $getProfile["PID"];

					

					

				}else{/* give palyers */

					$getProfile = $profileDB->GetPlayersByPositions($player['ID'], $player['Position']);

					

					$NewplaersArray[$i]["UserID"] = $getProfile["UserID"];

					$NewplaersArray[$i]["Avatar"] = $getProfile["Avatar"];

					$NewplaersArray[$i]["FirstName"] = $getProfile["FirstName"];

					$NewplaersArray[$i]["LastName"] = $getProfile["LastName"];

					$NewplaersArray[$i]["Postion"] = $getProfile["POS"];

					$NewplaersArray[$i]["Jersey"] = $player["Jersey"];

					$NewplaersArray[$i]["Ethnicity"] = $player["Ethnicity"];

						$NewplaersArray[$i]["weight"] = $player["weight"];

							$NewplaersArray[$i]["height"] = $player["height"];

					$NewplaersArray[$i]["PID"] = $getProfile["PID"];

				}

				

				$i++;

			}

	

			echo json_encode($NewplaersArray);

		}

	}

	public function getfixturesAction() {

		$this->_helper->viewRenderer->setNoRender();

      	$this->_helper->layout->disableLayout();

		

		$request = $this->getRequest();

		$tid = $request->getParam("tid");

		

		$fixtureDB = new Model_Fixture;

		$fixtures = $fixtureDB->getAllFixtures($tid);

		$teamH = json_decode($fixtures["TeamH"],true);

		$teamA = json_decode($fixtures["TeamA"],true);

		

		$aTeamH = array();

		

		$i = 0;

			foreach ($fixtures as $f) {

				

				$fixtureDate = $f['FixtureDate'];

				echo '
';

				print_r($f['FixtureDate']);

				

			}

		/*echo '
';

		print_r($fixtures->toArray());*/

		echo json_encode($fixtureDate);

		

		

		

	}



public function fixturesprofileAction() {

	

}







	//Fixtures AJAX

	public function gettableAction() {



		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();



		/*

		$request = $this->getRequest();

		$sid=$request->getParam("sid");*/

		

		$columns = array(

			// datatable column index  => database column name

			0=> 'F.FixtureDate',

			1=> 'F.StartTime',

			2=> 'F.ShortName1',

			3=> 'F.ShortName2',

			4=> 'F.Location',

			5=> 'F.TournName'

		);



		$requestData= $_REQUEST;

		$unionID  =1;

		$fixtureDB = new Model_Fixture;

		$PlayersHistoryDB = new Model_PlayerCareer;

		$getCurrent = $PlayersHistoryDB->fetchRow("UserID ='".$this->identity->UserID."'");

		$squads = json_decode($getCurrent["Squads"],true);



		/*echo "
";*/

		$ListFixtures = array();

		if(count($squads)>0){



			foreach ($squads as $squad) {

				$Fixtures = $fixtureDB->getMyFixtures(@$squad["SID"]);

				foreach ($Fixtures->toArray() as $fixture) {

					$ListFixtures[$fixture["FID"]] = $fixture;

				}

			}

		}



		$total = count($ListFixtures); //?

		$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_Array($ListFixtures));

		$paginator->setCurrentPageNumber(($requestData["start"]/$requestData["length"])+1);

		$paginator->setItemCountPerPage($requestData["length"]);



		$DataTable = $this->datatable($paginator,$requestData,$total);

		echo $DataTable;



	}



private function datatable($dataArray,$requestData,$total) {

		

		$data = array();

		$i=1+$requestData['start'];

		

		foreach( $dataArray as $row) {

		$nestedData=array(); 

    	$nestedData[] = $i ;

		/*$nestedData[] = $status;*/

		/*$nestedData[] = '';*/

		$nestedData[] = 'Statusa';

 		$nestedData[] = $row['FixtureDate'];

		$nestedData[] = $row['StartTime'];

    	$nestedData[] = ''.$row['ShortName1'].'';

		$nestedData[] = '0 0';

		$nestedData[] = ''.$row['ShortName2'].'';

        $nestedData[] = $row['Location'];

        $nestedData[] = ''.$row['TournName'].'';

		

		/*$nestedData[] = 0;*///need to fix caps

		$nestedData[] = '


                              

                              	

                              

                              


                                 


                                 


                                 


                                 


                                 

                              

                           
';

   		$data[] = $nestedData;

   		$i++;

		

	}

	

		$json_data = array(

						

		"search" => $requestData["search"]["value"],

		"column" => $requestData["order"][0]["column"],	

		"dir" => intval( $requestData["order"][0]["dir"]),	

		"start" => intval( $requestData['start']),	

		"page" => intval( $requestData["start"]/$requestData["length"]),

		"length" => intval( $requestData['length']),	

	    "draw"            => intval( $requestData['draw']+1),   // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.

	    "recordsTotal"    => intval( $total ),  // total number of records

	    "recordsFiltered" => intval( $total ), // total number of records after searching, if there is no searching then totalFiltered = totalData

	    "data"            => $data,   // total data array,

    );

 

		echo json_encode($json_data);  // send data as json format

	}



        public function getplayersAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

                $UL ="";

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

		$pos = $reQuest->getParam("pos");

                $fid = $reQuest->getParam("fid");

			

		$SquadsTbl = new Model_Squad;      

		$squad = $SquadsTbl->getSquad($sid);

		

                 $profileDB = new Model_Profile;

                 $listPlayers = json_decode($squad["Players"],true);

                 

                 $FixtureTbl = new Model_Fixture;

                 $Fixture = $FixtureTbl->getFixture($fid);

                 if($Fixture["HomeTeam"]==$sid){

                 $listHomeTeam =  json_decode($Fixture["TeamH"],true);

                 }

                 if($Fixture["AwayTeam"]==$sid){

                 $listHomeTeam =  json_decode($Fixture["TeamA"],true);

                 }

                 $AvailableCount = 0;

                 $demographics = array();

                 if(count($listPlayers)>0){

                     foreach($listPlayers as $player){

                         $Check = $this->in_list($listHomeTeam, $player['ID']);

                         if($Check==false){

                         

                         $Image = "data:2;base64,/9j/4AAQSkZJRgABAQAAAQABAAD//gA+Q1JFQVRPUjogZ2QtanBlZyB2MS4wICh1c2luZyBJSkcgSlBFRyB2NjIpLCBkZWZhdWx0IHF1YWxpdHkK/9sAQwAIBgYHBgUIBwcHCQkICgwUDQwLCwwZEhMPFB0aHx4dGhwcICQuJyAiLCMcHCg3KSwwMTQ0NB8nOT04MjwuMzQy/9sAQwEJCQkMCwwYDQ0YMiEcITIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIy/8AAEQgAZABkAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29/j5+v/aAAwDAQACEQMRAD8A9+zRmkzRmgBc0ZpM0ZoAXNGaTNGaAFzRSZozQAuaM0maM0ALmjNJmjNAC5opM0UANzRmkzRmgBc0ZpMijIoAXNQy3UUJwzc+g5qC9ujH+7Q/MRyfQVmZJJJoA1BqMRPIYfhU6XEUn3XBPpWJQDg5FAHQZozVO0u/N+R/vjofWreaAFzRmkyKMigBc0UmaKAGUUlGaAFozxSUdsUAY0jl5WY85NNpWXa7D0NJQAUUUUASQHbPGQf4hWxmsqzTfcDPQc1qUALRSZooAWikooAbmjNJRQA7NIeRikooAx2GGI9DRVq9QK4dRy3WqtABRRRQBasB+8Y+gq/mobeNUiUgYJGTUtAC5pc03NFADs0U3NFACZozTMmjJoAfmjNRlsdTj61E90i9DuPtQA66UNCfbms+nyzPKfm6egplABSqu5gPU0lFAGsOABS1Riu2UAPyPXvVgTow4cfjQBNRmmBs9DmjJ9aAH0UzJ9aKAEqCefy/lX738qlJwCT2rPZtzFj3oAGZmOSSaSiigAooooAKKKKACiiigBUdo2ypq9DMJF9D3FUKfE22QGgDQzRTc0UAMk/1bfSqNFFABRRRQAUUUUAFFFFABRRRQAUDqKKKAL+aKKKAP//Z";

                         $getProfile = $profileDB->GetPlayersByPositions($player['ID'], $player['Position']);

                                        if(empty($getProfile["Avatar"]) || $getProfile["Avatar"]=="null"){

                                            $getProfile["Avatar"]=$Image;

                                        }

					

					if($getProfile["UserID"] >0){

                                            $AvailableCount++;

                                            if(!empty($getProfile["NickName"])){

                                            $getProfile["FirstName"]=$getProfile["NickName"];

                                            }

                                            $PlayerInjury = new Model_PlayerInjury;	

									$getIngetRy= $PlayerInjury->fetchRow("UserID ='".$getProfile["UserID"]."' AND ReturnToPlay > '".date("Y-m-d")."'");

									$injury = 0;

									if($getIngetRy){

										

                                                                                if($getIngetRy["ReturnToTraining"] <= date("Y-m-d")){

                                                                                $injury = 1;

                                                                                }else{

                                                                                        $injury = 2; 

                                                                                }

                                                                        }

                                                                        

                                                                        

																		

																		

												// Check for University PLayers Bonafide Nomber

							$AllowedToPlay = 0;

							if ($squad["un_type"] == 8) {

								if ($getProfile["Play_Year"] != date("Y")) {

									$AllowedToPlay = 1;

								} else {

									// date if file



									if ($getProfile["At_Risc"] == 1) {

										$AllowedToPlay = 2;

									} else {

										if ($getProfile["Bonified_no"] == "") {

											$AllowedToPlay = 1;

										}



									}

								}



							}						

																		

																		

																		

                                             $addtosquad = "";  

                                             $style = "border: 3px solid red";

                                             $text = 'Player Not Available';

                                           if($injury==0){

                                              $addtosquad = "AddPlayerToTeam(this)";  

                                              $style = "";

                                              $text ='';

                                           }

										   if($AllowedToPlay > 0){

										     $addtosquad = ""; 

											   $style = "border: 3px solid red";

                                             $text = 'Player Not Available';

										   }

                         

                                            $UL .='


                                                


                                                       


                                                           

                                                       

                                                       


                                                           
'. $getProfile["FirstName"].', '. $getProfile["LastName"].'

                                                           
POS: '. $getProfile["POS"].'
 (J '. $player["Jersey"].')
'.$text.'

                                                       



                                                   



                                            
';

                                        }

                     }

                        }

                      

                    }

                    

                    if($AvailableCount==0){

                        $UL = '
No Players Available
';

                    }

                    

                   echo "
".$UL."
";

                   

                    

        }

        

        

        public function getplayerslineupAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

                $UL ="";

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

		$pos = $reQuest->getParam("pos");

                $fid = $reQuest->getParam("fid");

			

		$SquadsTbl = new Model_Squad;      

		$squad = $SquadsTbl->getSquad($sid);

		

                 $profileDB = new Model_Profile;

                 $listPlayers = json_decode($squad["Players"],true);

                 

                 $FixtureTbl = new Model_Fixture;

                 $Fixture = $FixtureTbl->getFixture($fid);

                 if($Fixture["HomeTeam"]==$sid){

                 $listHomeTeam =  json_decode($Fixture["TeamH"],true);

                 }

                 if($Fixture["AwayTeam"]==$sid){

                 $listHomeTeam =  json_decode($Fixture["TeamA"],true);

                 }

                 $AvailableCount = 0;

                 $demographics = array();

                 if(count($listPlayers)>0){

                     foreach($listPlayers as $player){

                         $Check = $this->in_list($listHomeTeam, $player['ID']);

                         if($Check==false){

                         

                         $Image = "/IMGS/no-image.jpg";

                         $getProfile = $profileDB->GetPlayersByPositions($player['ID'], $player['Position']);

                                        if(empty($getProfile["Avatar"]) || $getProfile["Avatar"]=="null"){

                                            $getProfile["Avatar"]=$Image;

                                        }

					

					if($getProfile["UserID"] >0){

                                            $AvailableCount++;

                                            if(!empty($getProfile["NickName"])){

                                            $getProfile["FirstName"]=$getProfile["NickName"];

                                            }

                                            

                                                $demographics[$getProfile["Ethinicity"]]++;

                                                

                                            

                                           

                         

                                            $UL .='


                                                


                                                       


                                                           

                                                       

                                                       


                                                           
'. $getProfile["FirstName"].', '. $getProfile["LastName"].'

                                                           
'. $getProfile["POS"].'
 '. $player["Jersey"].'

                                                       



                                                   



                                            
';

                                        }

                     }

                        }

                      

                    }

                    

                    if($AvailableCount==0){

                        $UL = '
No Players Available
';

                    }

                    

                   $lineup = "
".$UL."
";

                 echo  json_encode(array("lineup"=>$lineup,"demographic"=>$demographics));

                   

                    

        }

        

        

        

        

        

        function in_list($list, $id){

            $return = false;

            if(count($list)>0){

                foreach($list as $item){

                    if($item["ID"]==$id){

                        $return = true;

                    }

                }

            }

            return $return;

            

        }

            

        

        

        

	public function addplayerAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

               

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

		$pos = $reQuest->getParam("pos");

                $fid = $reQuest->getParam("fid");

                $pid  = $reQuest->getParam("pid");

                $FixtureTbl = new Model_Fixture;

		$SquadsTbl = new Model_Squad;

		

                

                //GET SQUADS

                $squad = $SquadsTbl->getSquadComp($sid);

		$SquadList=json_decode($squad["Players"],true);

                 

                 //GET FIXTURE

                $Fixture = $FixtureTbl->getFixture($fid);

                $this->view->assign("fixture",$Fixture);

                

                

                $tourn = new Model_Tournament;

                   $Tournment = $tourn->getTourny($Fixture["TID"]);

                   

                

                

                if($Fixture["HomeTeam"] ==$sid){

                    $listHomeTeam =  json_decode($Fixture["TeamH"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listHomeTeam)>0){

                        

                        foreach($listHomeTeam as $player){

                            if($player["ID"]!=$pid && $player["Pos"]!=$pos){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               $NewList[$n]["Vice"]= $player["Vice"];

                               $NewList[$n]["Cap"]= $player["Cap"];

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              $n++;

                            }

                        }

                    }

                    $Jersey = $SquadList[$pid]["Jersey"];

                   $AgeGroups = $squad["AgeGroup"];

                            if($Tournment["editjersey"]!=1){

                                if($AgeGroups>18 || $AgeGroups==0){

                                    $Jersey = $pos;

                                }

                            }

                    

                    $NewList[$n]["ID"]= $pid;

                    $NewList[$n]["Pos"]= $pos;

                    $NewList[$n]["Vice"]= 0;

                    $NewList[$n]["Cap"]= 0;

                    $NewList[$n]["Jersey"]= $Jersey;

                    

                    

                    

                    $TeamHistory =  json_decode($Fixture["History"],true);

                    $ProfileDB = new Model_Profile;

                    $Profile =$ProfileDB->getPerson($pid);

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." Added Player (".$Profile["FirstName"]." ".$Profile["LastName"].") to team");

                    

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s"),"TeamH"=>  json_encode($NewList)), $fid);

                }

                

                if($Fixture["AwayTeam"] ==$sid){

                    $listHomeTeam =  json_decode($Fixture["TeamA"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listHomeTeam)>0){

                        

                        foreach($listHomeTeam as $player){

                            if($player["ID"]!=$pid && $player["Pos"]!=$pos){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               $NewList[$n]["Vice"]= $player["Vice"];

                               $NewList[$n]["Cap"]= $player["Cap"];

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              $n++;

                            }

                        }

                    }

                     $Jersey = $SquadList[$pid]["Jersey"];

                    $AgeGroups = $squad["AgeGroup"];

                            if($Tournment["editjersey"]!=1){

                                if($AgeGroups>18 || $AgeGroups==0){

                                    $Jersey = $pos;

                                }

                            }

                            

                    

                    $NewList[$n]["ID"]= $pid;

                    $NewList[$n]["Pos"]= $pos;

                    $NewList[$n]["Vice"]= 0;

                    $NewList[$n]["Cap"]= 0;

                    $NewList[$n]["Jersey"]= $Jersey;

                    

                    

                    $TeamHistory =  json_decode($Fixture["History"],true);

                    $ProfileDB = new Model_Profile;

                    $Profile =$ProfileDB->getPerson($pid);

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." Added Player (".$Profile["FirstName"]." ".$Profile["LastName"].") to team");

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s"),"TeamA"=>  json_encode($NewList)), $fid);

                }

                

                

                

        }

        

        public function removeplayerAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

               

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

                $fid = $reQuest->getParam("fid");

                $pid  = $reQuest->getParam("pid");

                $FixtureTbl = new Model_Fixture;

                

                $Fixture = $FixtureTbl->getFixture($fid);

                $this->view->assign("fixture",$Fixture);

                

                if($Fixture["HomeTeam"] ==$sid){

                    $listHomeTeam =  json_decode($Fixture["TeamH"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listHomeTeam)>0){

                        

                        foreach($listHomeTeam as $player){

                            if($player["ID"]!=$pid){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               $NewList[$n]["Vice"]= $player["Vice"];

                               $NewList[$n]["Cap"]= $player["Cap"];

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              $n++;

                            }

                        }

                    }

                    

                    $TeamHistory =  json_decode($Fixture["History"],true);

                    $ProfileDB = new Model_Profile;

                    $Profile =$ProfileDB->getPerson($pid);

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." removed Player (".$Profile["FirstName"]." ".$Profile["LastName"].") from team");

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s"),"TeamH"=>  json_encode($NewList)), $fid);

                }

                

                if($Fixture["AwayTeam"] ==$sid){

                    $listHomeTeam =  json_decode($Fixture["TeamA"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listHomeTeam)>0){

                        

                        foreach($listHomeTeam as $player){

                            if($player["ID"]!=$pid){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               $NewList[$n]["Vice"]= $player["Vice"];

                               $NewList[$n]["Cap"]= $player["Cap"];

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              $n++;

                            }

                        }

                    }

                    

                    $TeamHistory =  json_decode($Fixture["History"],true);

                    $ProfileDB = new Model_Profile;

                    $Profile =$ProfileDB->getPerson($pid);

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." removed Player (".$Profile["FirstName"]." ".$Profile["LastName"].") from team");

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s"),"TeamA"=>  json_encode($NewList)), $fid);

                }

        }

        

        public function makecapAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

               

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

                $fid = $reQuest->getParam("fid");

                $pid  = $reQuest->getParam("pid");

                $type  = $reQuest->getParam("type");

                $FixtureTbl = new Model_Fixture;

                

                $Fixture = $FixtureTbl->getFixture($fid);

                $this->view->assign("fixture",$Fixture);

                

                if($Fixture["HomeTeam"] ==$sid){

                    $listHomeTeam =  json_decode($Fixture["TeamH"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listHomeTeam)>0){

                        

                        foreach($listHomeTeam as $player){

                            if($player["ID"]!=$pid){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               if($type==2){

                               $NewList[$n]["Vice"]= 0;

                               }else{

                                $NewList[$n]["Vice"]= $player["Vice"];

                               }

                                if($type==1){

                               

                               $NewList[$n]["Cap"]= 0;

                                }else{

                                    $NewList[$n]["Cap"]= $player["Cap"];

                                }

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              

                            }else{

                                $NewList[$n]["ID"]= $pid;

                                $NewList[$n]["Pos"]= $player["Pos"];

                                if($type==2){

                                $NewList[$n]["Vice"]= 1;

                                }else{

                                 $NewList[$n]["Vice"]= $player["Vice"];

                                }

                                 if($type==1){



                                $NewList[$n]["Cap"]= 1;

                                 }else{

                                     $NewList[$n]["Cap"]= $player["Cap"];

                                 }

                                $NewList[$n]["Jersey"]= $player["Jersey"];

                            }

                            $n++;

                        }

                    }

                    

                    $TeamHistory =  json_decode($Fixture["History"],true);

                    $ProfileDB = new Model_Profile;

                    $Profile =$ProfileDB->getPerson($pid);

                    if($type==1){

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." changed Player (".$Profile["FirstName"]." ".$Profile["LastName"].") role to captain");

                    }

                    if($type==2){

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." changed Player (".$Profile["FirstName"]." ".$Profile["LastName"].") role to vice captain");

                    }

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s"),"TeamH"=>  json_encode($NewList)), $fid);

                }

                

                if($Fixture["AwayTeam"] ==$sid){

                    $listHomeTeam =  json_decode($Fixture["TeamA"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listHomeTeam)>0){

                        

                        foreach($listHomeTeam as $player){

                            if($player["ID"]!=$pid){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               if($type==2){

                               $NewList[$n]["Vice"]= 0;

                               }else{

                                $NewList[$n]["Vice"]= $player["Vice"];

                               }

                                if($type==1){

                               

                               $NewList[$n]["Cap"]= 0;

                                }else{

                                    $NewList[$n]["Cap"]= $player["Cap"];

                                }

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              

                            }else{

                                $NewList[$n]["ID"]= $pid;

                                $NewList[$n]["Pos"]=  $player["Pos"];;

                                if($type==2){

                                $NewList[$n]["Vice"]= 1;

                                }else{

                                 $NewList[$n]["Vice"]= $player["Vice"];

                                }

                                 if($type==1){



                                $NewList[$n]["Cap"]= 1;

                                 }else{

                                     $NewList[$n]["Cap"]= $player["Cap"];

                                 }

                                $NewList[$n]["Jersey"]= $player["Jersey"];

                            }

                            $n++;

                        }

                    }

                    

                    $TeamHistory =  json_decode($Fixture["History"],true);

                    $ProfileDB = new Model_Profile;

                    $Profile =$ProfileDB->getPerson($pid);

                    if($type==1){

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." changed Player (".$Profile["FirstName"]." ".$Profile["LastName"].") role to captain");

                    }

                    if($type==2){

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." changed Player (".$Profile["FirstName"]." ".$Profile["LastName"].") role to vice captain");

                    }

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s"),"TeamA"=>  json_encode($NewList)), $fid);

                }

        }

        

         public function jerseyAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

               

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

                $fid = $reQuest->getParam("fid");

                $pid  = $reQuest->getParam("pid");

                $jersey  = $reQuest->getParam("jersey");

                $FixtureTbl = new Model_Fixture;

                

                $Fixture = $FixtureTbl->getFixture($fid);

                $this->view->assign("fixture",$Fixture);

                

                if($Fixture["HomeTeam"] ==$sid){

                    $listHomeTeam =  json_decode($Fixture["TeamH"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listHomeTeam)>0){

                        

                        foreach($listHomeTeam as $player){

                            if($player["ID"]!=$pid){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               $NewList[$n]["Vice"]= $player["Vice"];

                               $NewList[$n]["Cap"]= $player["Cap"];

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              

                            }else{

                                $NewList[$n]["ID"]= $pid;

                                $NewList[$n]["Pos"]= $player["Pos"];

                                $NewList[$n]["Vice"]= $player["Vice"];

                                $NewList[$n]["Cap"]= $player["Cap"];

                                $NewList[$n]["Jersey"]= $jersey;

                            }

                            $n++;

                        }

                    }

                    

                    $FixtureTbl->updateData(array("TeamH"=>  json_encode($NewList)), $fid);

                    

                    

                    

                    

                    

                }else if($Fixture["AwayTeam"] ==$sid){

                    $listAwayTeam =  json_decode($Fixture["TeamA"],true);

                    $NewList = array();

                    $n =0;

                    if(count($listAwayTeam)>0){

                        

                        foreach($listAwayTeam as $player){

                            if($player["ID"]!=$pid){

                               $NewList[$n]["ID"]= $player["ID"];

                               $NewList[$n]["Pos"]= $player["Pos"];

                               $NewList[$n]["Vice"]= $player["Vice"];

                               $NewList[$n]["Cap"]= $player["Cap"];

                               $NewList[$n]["Jersey"]= $player["Jersey"];

                              

                            }else{

                                $NewList[$n]["ID"]= $pid;

                                $NewList[$n]["Pos"]= $player["Pos"];

                                $NewList[$n]["Vice"]= $player["Vice"];

                                $NewList[$n]["Cap"]= $player["Cap"];

                                $NewList[$n]["Jersey"]= $jersey;

                            }

                            $n++;

                        }

                    }

                    

                    $FixtureTbl->updateData(array("TeamA"=>json_encode($NewList)), $fid);

                }

                

                    $TeamHistory =  json_decode($Fixture["History"],true);

                    $ProfileDB = new Model_Profile;

                    $Profile =$ProfileDB->getPerson($pid);

                    $TeamHistory[] = array("Date"=>date("Y-m-d H:i:s"),$this->identity->FirstName." ".$this->identity->LastName." changed jersey number for player (".$Profile["FirstName"]." ".$Profile["LastName"].") ");

                    $FixtureTbl->updateData(array("History"=>json_encode($TeamHistory),"Author"=>$this->identity->UserID,"DateModified"=>date("Y-m-d H:i:s")), $fid);

                

        }

        

        public function confirmAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

               

                $FixtureTbl = new Model_Fixture;

                

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

                $fid = $reQuest->getParam("fid");

                

                 $Fixture = $FixtureTbl->getFixture($fid);

                if($Fixture["HomeTeam"]==$sid){

                   

                   if(strtotime($Fixture["HomeConfirmDate"])<0 ){

                       $data =array("DateModified"=>date("Y-m-d H:i:s"),"HomeConfirmDate"=>date("Y-m-d H:i:s"),"HomeTeam_Confirmed"=>1,"HomeTeam_lineup"=>$Fixture["TeamH"]);

                   

                       //send email  Submittion 

                       

                       

                       

                   }else{

                        $data =array("DateModified"=>date("Y-m-d H:i:s"),"HomeUpdateDate"=>date("Y-m-d H:i:s"),"HomeTeam_Confirmed"=>1,"HomeTeam_lineup"=>$Fixture["TeamH"]);

                        //send email to Update tournament maneger 

                        

            $this->notifyDirector($Fixture);

                        

                   }

                }else if($Fixture["AwayTeam"]==$sid){

                    if(strtotime($Fixture["AwayConfirmDate"])<0 ){

                        $data =array("DateModified"=>date("Y-m-d H:i:s"),"AwayConfirmDate"=>date("Y-m-d H:i:s"),"AwayTeam_Confirmed"=>1,"AwayTeam_lineup"=>$Fixture["TeamA"]);

                    }else{

                        

                        $data =array("DateModified"=>date("Y-m-d H:i:s"),"AwayUpdateDate"=>date("Y-m-d H:i:s"),"AwayTeam_Confirmed"=>1,"AwayTeam_lineup"=>$Fixture["TeamA"]);

                    }

                   

                    

                }

                $done = $FixtureTbl->updateData($data, $fid);

                if($done){

                    echo json_encode(array("OK"=>1));

                }else{

                    echo json_encode(array("OK"=>0));

                }

                

        }

        public function notifyDirector($Fixture){

            $TournDB = new Model_Tournament;

                $Tournament = $TournDB->fetchRow("TID ='".$Fixture["TID"]."'");

            $Officials = json_decode($Tournament["Officials"],true);

                $Director = array();

                if(count($Officials)>0){

                    foreach($Officials as $Official){

                    if(@$Official["TA"]==1){

                            $profileDB = new Model_Profile;

                            $Profile = $profileDB->getPerson($Official["UserID"]);

                            $Director = $Profile;

                    }

                    }

                }

             

            $message = "A change was made to ".$Fixture["TournName"]." - round ".$Fixture["RoundNumber"]." -  match ".$Fixture["FixtureNumber"]."


".$Fixture["SquadName1"]." VS ".$Fixture["SquadName2"]."


".date("d/m/Y",strtotime($Fixture["FixtureDate"]))." ".date("H:i",strtotime($Fixture["StartTime"]))." @ ".$Fixture["Location"]."



 

Please logon to Footprint to review changes made.";

            

            

            

            

	   $EmailContent = new PG_Controller_Plugin_EmailLayout;

          $sent = $EmailContent->NotificationMassge(21, $message, $this->identity);

        }

        public function unconfirmAction()

	{

		$this->_helper->viewRenderer->setNoRender();

		$this->_helper->layout->disableLayout();

               

                $FixtureTbl = new Model_Fixture;

                

		$reQuest = $this->getRequest();

		

		$sid = $reQuest->getParam("sid");

                $fid = $reQuest->getParam("fid");

                

                 $Fixture = $FixtureTbl->getFixture($fid);

                if($Fixture["HomeTeam"]==$sid){

                   $data =array("HomeTeam_Confirmed"=>0,"HomeTeam_lineup"=>"");

                }else if($Fixture["AwayTeam"]==$sid){

                   $data =array("AwayTeam_Confirmed"=>0,"AwayTeam_lineup"=>"");

                }

                $done = $FixtureTbl->updateData($data, $fid);

                if($done){

                    echo json_encode(array("OK"=>1));

                }else{

                    echo json_encode(array("OK"=>0));

                }

                

        }

        public function getmatchreportAction()

    {

    	$this->_helper->viewRenderer->setNoRender();

      	$this->_helper->layout->disableLayout();

				

				

				require_once("dompdf/dompdf_config.inc.php");

				$request = $this->getRequest();

				$id = $request->getParam("fid");

				$FixtureDB = new Model_Fixture;

				$comms = new Model_MatchEvents;

				$fixture =$FixtureDB->getFixture($id);

				

				$url = "http://".$_SERVER["SERVER_NAME"]."/pdf/matchreport/id/".$id;

				

				    	

				

				$html = file_get_contents($url);

				

				$dompdf = new DOMPDF();

				$dompdf->load_html($html);

				$dompdf->set_paper('a4', $request->getParam("orientation"));

				$dompdf->render();

				$dompdf->stream($fixture["SquadName1"]." vs ".$fixture["SquadName2"]." Report.pdf");



    }

    

    

    

    public function teamsheetAction()

    {

        $this->_helper->viewRenderer->setNoRender();

        $this->_helper->layout->disableLayout();

				

        require_once("dompdf/dompdf_config.inc.php");

        $request = $this->getRequest();

        $SquadDB = new Model_Squad;

		$Squad = $SquadDB->getSquad($request->getParam("sid"));
if($Squad["un_type"]==7){
	 $url = "http://footprintapp.net/pdf/teamsheetpic/fid/".$request->getParam("fid")."/sid/".$request->getParam("sid");
}else{
	 $url = "http://footprintapp.net/pdf/teamsheet/fid/".$request->getParam("fid")."/sid/".$request->getParam("sid");
}
       

        

        $html = file_get_contents($url);

        

        $dompdf = new DOMPDF();

        $dompdf->load_html($html);

        $dompdf->set_paper('a3','portrait');

        $dompdf->render();

				

				

				$name = $Squad['SquadName'];

        $dompdf->stream($name."_".date("Y.m.d",time()).".pdf");

    }  

    

    

    

    

}