";

               // print_r( $AllFixtures->toArray());

                



	}



        public  function smallerimgAction(){

           

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

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

            // The file

        $reqest = $this->getRequest();

        $id = $reqest->getParam("IMG");

        $SquadDB = new Model_Squad;

        $Squad = $SquadDB->getSquadImg($id);

        $image = imagecreatefromstring(base64_decode($Squad["SquadImage"]));

            $filename = $image;

         /*   $percent = 0.5;



            // Content type

            header('Content-Type: image/jpeg');



            // Get new dimensions

            list($width, $height) = getimagesize($filename);

            $new_width = $width * $percent;

            $new_height = $height * $percent;



            // Resample

            $image_p = imagecreatetruecolor($new_width, $new_height);

            $image = imagecreatefromjpeg($filename);

            imagecopyresampled($image_p, $image, 0, 0, 0, 0, $new_width, $new_height, $width, $height);



            // Output

            imagejpeg($image_p, null, 100);

        * */



            list($type, $data) = explode(';', $data);

list(, $data)      = explode(',', $data);

$data = base64_decode($data);



file_put_contents('/tmp/image.png', $data);

            $data = base64_decode(preg_replace('#^data:image/\w+;base64,#i', '', $Squad["SquadImage"]));

header('Content-Type: image/jpeg');

      imagejpeg($data, null, 100);



        }

        /*

		GET OFFICIALS

	*/

	

	public function getofficialsAction(){

		

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

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

		

		$requestData= $_REQUEST;

        $tournamentDB = new Model_DarioFixtures;

        $PlayersHistoryDB = new Model_PlayerCareer;

        $ProfileDB = new Model_DarioFixtures;

        $TournOffPosDB = new Model_DarioFixtures;

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

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



        $aOfficialIDs = array();

        $aOffProf = array();

		$aOfficials = array();

		

       // $ListOfficials = array(); used

		$i=1;

        if(count($squads)>0){

			 

            foreach ($squads as $squad) {

				

                $Officials = $tournamentDB->getMyOfficials($squad['SID']);

					

					foreach ($Officials as $official) {



                    	$officials = json_decode($official["Officials"],true); //array

					

						if(count($officials) >0) {

							foreach ($officials as $k=>$v) {

								$aOfficialIDs["TitleID"] = $k; //

								

								$aOffProf = $ProfileDB->getName($v["UserID"]);

								

								foreach ($aOfficialIDs as $o) {

									$ListOfficials = $tournamentDB->getOffPos($o);							

									foreach ($ListOfficials as $oficial) {

										$OfficialProfile[$i]["UserID"] = array_merge($aOffProf->toArray(), $ListOfficials->toArray());

									}

								}

								$aOfficials[] = $OfficialProfile[$i]["UserID"];

								$i++;		

							}

						}

					}

            	}

        	}

			

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

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

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

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

		

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

		echo $DataTable;



	}

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

		$data = array();

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

		

		foreach( $dataArray as $row) {

		$nestedData=array(); 

    	$nestedData[] = $i ;

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

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

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

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

		

		

		/*$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 profileAction()

	{

		$FixtureTbl = new Model_Fixture;

		$SquadsTbl = new Model_Squad;

		$ProfileDB = new Model_Profile;

		$PositionsDB = new Model_Positions;

		$PlayersHistoryDB = new Model_PlayerCareer;

		$InstTypeDB = new Model_OrganizationTypes;

		$Conditions = new Model_PlayersHistory;

		$CountryDB = new Model_Country;

		$TitleDB = new Model_Title;

		$RelationDB = new Model_RelationshipStatus;

		$DocumentsDB = new Model_Documents;

		$EthnicityDB = new Model_Ethnicity;



		$request = $this->getRequest();

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



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

		$InstType = $InstTypeDB->getAll();

		$OrgType = 	$InstTypeDB->getTypes($id);



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

		$mySquads = array();

		foreach($squads as $squad){

			$mySquads[]=$squad;

		}





		//Conditioning Info

		$Player_Condition = $Conditions->fetchRow($id);

		$jConditions = json_decode($Player_Condition["Condition"], true);

		$aConditions = array();

		foreach($jConditions as $cond){

			$aConditions[]=$cond;

		}



		//Country

		$Country = $CountryDB->getAll();

		//Accreditation

		$Accr = $ProfileDB->getAccredByID($id);

		//Title

		$Title = $TitleDB->getAll();

		//Relationship

		$RelStatus = $RelationDB->getAll();

		//Docs

		//$Documents = $DocumentsDB->getForMember($id);

		$Documents = $DocumentsDB->getForMember($this->identity->UserID);

		//Get User Datails

		$UserProfile = $ProfileDB->getRow($id);

		//Get Positions 1-24

		$AllPos = $PositionsDB->getAll();

		//Ethnicity

		$Ethnicity = $EthnicityDB->getAll();



		$this->view->assign("CurrrentSquad",$mySquads[count($mySquads)-1]);

		$this->view->assign("Profile",$UserProfile);

		$this->view->assign("getCareer",$PlayerCareer);

		$this->view->assign("Hist",$mySquads);

		$this->view->assign("Positions", $AllPos);

		$Accred = $ProfileDB->getAccredByID($id);

		$this->view->assign("Accred", $Accred);

		$this->view->assign("InstType", $InstType);

		$this->view->assign("OrgType", $OrgType);

		$this->view->assign("PlayerCond", $aConditions);

		$this->view->assign("Country", $Country);

		$this->view->assign("Accr", $Accr);

		$this->view->assign("Title", $Title);

		$this->view->assign("RelStatus", $RelStatus);

		$this->view->assign("Documents", $Documents);

		$this->view->assign("Ethnicity", $Ethnicity);

	}



	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);

		}

	}





	//Dario

	//Tournaments AJAX

	public function gettourntableAction() {



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

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



		$request = $this->getRequest();

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

		$columns = array(

			// datatable column index  => database column name

			0=> 'T.TournImage',

			1=> 'T.TournName',

			2=> '',

			3=> 'T.StartDate',

			4=> 'T.EndDate'



		);



		$requestData= $_REQUEST;

		$unionID  =1;

		$fixtureDB = new Model_Tournament;

		$PlayersHistoryDB = new Model_PlayerCareer;

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

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



		$ListTournaments = array();



		if(count($squads)>0){



			foreach ($squads as $squad) {

				$SquadTourn = $fixtureDB->getMyTournaments(@$squad["SID"]);



				foreach ($SquadTourn->toArray() as $tourn) {

					$tourn["Squad_count"]	 = count(json_decode($tourn["Squads"],true));					

					$ListTournaments[$tourn["TID"]] = $tourn;

				}

			}



		}









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

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

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

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



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

		echo $DataTable;



	}



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

		$data = array();

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



		foreach( $dataArray as $row) {

			$nestedData=array();

			$nestedData[] = $i ;

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

			$nestedData[] = '';

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

			$nestedData[] = '';

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

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



			/*$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

	}



//Tournament Profile Fixtures AJAX

	public function gettournprofilefixsAction() {



		$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'

		);



		$requestData= $_REQUEST;

		$unionID  =1;

		$fixtureDB = new Model_DarioFixtures;

		$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->gettournprofilefixsdt($paginator,$requestData,$total);

		echo $DataTable;



	}



	private function gettournprofilefixsdt($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[] = $row['ShortName2'];

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





			/*$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

	}



	//gettournprofilesquads

	public function gettournprofilesquadsAction() {

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

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



		$fixtureDB = new Model_DarioFixtures;

		$squadDB = new	Model_DarioFixtures;

		$PlayersHistoryDB = new Model_PlayerCareer;

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



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

		$aSquad = array();



		$i = 0;





		if(count($squads)>0){

			foreach ($squads as $squad) {

				$Squads = $squadDB->getSquad($squad["SID"]);

				$aSquad[$i]["SquadImage"] = '';

				$aSquad[$i]["ShortName"] = $Squads["ShortName"];

				$aSquad[$i]["un_name"] = $Squads["un_name"];



				$i++;

			}

		}

		echo json_encode($aSquad);



	}

	

	//Get TEAM MANAGERS

	public function getteammanagersAction() {

		

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

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

		

		$columns = array( //UNUSED

		// datatable column index  => database column name

			0=> 'P.FullName',

		    1=> 'P.Mobile', 

		    2=> 'P.Email',

		   	3=> 'S.ShorName'

		);

		

		$requestData= $_REQUEST;

		$unionID  =1; //not used

		$fixtureDB = new Model_DarioFixtures;

		$squadDB = new	Model_DarioFixtures;

		$PlayersHistoryDB = new Model_PlayerCareer;

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

		

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

		$aManager = array();

		if(count($squads)>0){

			foreach ($squads as $squad) {

				$TeamMan = $squadDB->GetTeamMan(@$squad["SID"]); //object

				

				foreach ($TeamMan->toArray() as $m) { //convert object to array

					

					$aManager[] = $m;

				}

			}

		}

		/*echo json_encode($aManager);*/

		

		$total = count($aManager); 

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

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

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

		

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

		echo $DataTable;

		

	}

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

		

		$data = array();

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

		

		foreach( $dataArray as $row) {

		$nestedData=array(); 

    	$nestedData[] = $i ;

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

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

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

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

		$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

	}





}