";
}
}
public function mytestAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$request = $this->getRequest();
$data = $request->getParams();
$Player = new Model_Profile;
if($data["op"]==1){
$details =$Player->fetchRow("IDNumber ='".$data["id"]."'");
if($details["UserID"]>0){
echo json_encode(array("Details"=>$details->toArray(),"UserID"=>$details["UserID"]));
}else{
echo json_encode(array("UserID"=>0));
}
}else{
$details =$Player->fetchRow("PassportNumber ='".$data["id"]."'");
if($details["UserID"]>0){
echo json_encode(array("Details"=>$details->toArray(),"UserID"=>$details["UserID"]));
}else{
echo json_encode(array("UserID"=>0));
}
}
}
public function squadcheckAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$SquadsTable = new Model_Squad;
$allSquas = $SquadsTable->fetchAll();
echo "";
foreach ($allSquas as $Squad){
$PLAYERSLIST = json_decode($Squad["Players"],true);
$newPlayers = array();
foreach($PLAYERSLIST as $Player){
$newPlayers[$Player["ID"]]["ID"]=$Player["ID"];
$newPlayers[$Player["ID"]]["Position"]=$Player["Position"];
$newPlayers[$Player["ID"]]["Rank"]=$Player["Rank"];
$newPlayers[$Player["ID"]]["Jersey"]=$Player["Jersey"];
}
$PLAYERSLISTCoaches = json_decode($Squad["Coaches"],true);
$newPlayersCoaches = array();
foreach($PLAYERSLISTCoaches as $Coaches){
$newPlayersCoaches[$Coaches["ID"]]["ID"]=$Coaches["ID"];
$newPlayersCoaches[$Coaches["ID"]]["Position"]=$Coaches["Position"];
}
$data = array("Players"=> json_encode($newPlayers),"Coaches"=> json_encode($newPlayersCoaches));
$SquadsTable->updateSquad($data, $Squad["SID"]);
print_r($newPlayers);
print_r($newPlayersCoaches);
}
}
public function mysquadsnotAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$SquadsTable = new Model_Squad;
$MYSQUADS = $SquadsTable->fetchAll();
foreach($MYSQUADS as $MYSQUAD){
$ProfileDB = new Model_Profile;
$teammanger = 0;
$awner = 0;
$Coaches = json_decode($MYSQUAD["Coaches"],true);
foreach($Coaches as $Coache){
if($Coache["Position"]==200){
$awner =$Coache["ID"];
}
if($Coache["Position"]==42){
$teammanger =$Coache["ID"];
}
}
if($teammanger==0 && $awner>0){
$teammanger = $awner;
}
if($teammanger>0 && $awner==0){
$awner = $teammanger;
}
if($teammanger >0 && $awner>0){
echo "AUner: ".$awner. "
";
echo "Manager: ".$teammanger. "
";
echo "........................
";
$dateCreated =$MYSQUAD["DateCreated"];
if(empty($dateCreated)){
$dateCreated =$MYSQUAD["FormDate"];
}
$SquadsTable->updateSquad(array("TeamManager"=>$teammanger,"Author"=>$awner,"DateCreated"=>$dateCreated), $MYSQUAD["SID"]);
}else{
echo "AUner: ".$awner. "
";
echo "Manager: ".$teammanger. "
";
echo $MYSQUAD["SID"]."........................
";
}
}
}
public function mysquadsAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$PlayerCareer = new Model_PlayerCareer;
$SquadsTable = new Model_Squad;
$allplayers = $PlayerCareer->fetchAll();
$i =0;
echo "";
$list = array();
foreach ($allplayers as $player){
while ($i <100){
$MYSQUADS = json_decode($player["Squads"],true);
foreach($MYSQUADS as $MYSQUAD){
$list[$player["UserID"]]["squad"] = $MYSQUADS[$MYSQUAD["SID"]];
$squad = $SquadsTable->getSquad($MYSQUAD["SID"]);
$PLAYERSLIST = json_decode($squad["Players"],true);
print_r($PLAYERSLIST[$player["UserID"]]);
if(isset($PLAYERSLIST[$player["UserID"]])){
$list[$player["UserID"]]["Found"] = $player["UserID"];
}else{
$list[$player["UserID"]]["Found"] = 0;
}
$list[$player["UserID"]]["List"] = $PLAYERSLIST;
$i++;
}
print_r($list);
}
}
echo "Count: ".$i;
}
function in_array_r($key, $value, $data){
$return = false;
if(count($data)>0){
foreach($data as $row){
if($row[$key]==$value){
$return = true;
break;
}
}
}
return $return ;
}
public function mailAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$config = array('auth' => 'login',
'username' => 'support@footprintapp.net',
'password' => 'evolveav');
$transport = new Zend_Mail_Transport_Smtp('mail.footprintapp.net', $config);
$mail = new Zend_Mail();
$mail->setBodyText('This is the text of the mail.');
$mail->setFrom('support@footprintapp.net', 'Some Sender');
$mail->addTo('andre.ferraz@evolveav.co.za', 'Some Recipient');
$mail->setSubject('TestSubject');
$mail->send($transport);
}
public function updateauthorsAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$PlayerCareer = new Model_PlayerCareer;
$SquadsTable = new Model_Squad;
$mySquads = $SquadsTable->fetchAll();
$squadsL = array();
$n = 1;
foreach ($mySquads as $squad)
{
if($squad["Author"]>0){
echo "". $n." : ". $squad["SID"]."-". $squad["Author"]."
";
$profile = $PlayerCareer->fetchRow("UserID ='".$squad["Author"]."'");
if($profile["UserID"]==$squad["Author"]){
$squadsList = json_decode($profile["Squads"],true);
print_r($squadsList);
$list = array();
foreach($squadsList as $squ){
if($squ["SID"]==$squad["SID"]){
$squadsL[$squad["Author"]]["Data"][$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"200","DATE"=>$squ["DATE"]);
}else{
$squadsL[$squad["Author"]]["Data"][$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"200","DATE"=>$squ["DATE"]);
}
}
// echo "". $n." : ". $squad["SID"]."- Updated
";
// $PlayerCareer->updateData(array("Squads"=> json_encode($list)), $squad["Author"]);
}else{
// echo "". $n." : ". $squad["SID"]."- Inserted
";
$squadsL[$squad["Author"]]["Data"][$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"200","DATE"=>date("Y-m-d H:i:s"));
//$PlayerCareer->insertData(array("Squads"=> json_encode($list),"UserID"=>$squad["Author"]));
}
}else{
// echo "". $n." : ". $squad["SID"]."- None
";
}
$n++;
$squadsL[$squad["Author"]]["UserID"] = $squad["Author"];
}
foreach ($squadsL as $squad)
{
if(isset($squad["Data"]))
{
$list = json_encode($squad["Data"]);;
$profile = $PlayerCareer->fetchRow("UserID ='".$squad["UserID"]."'");
if($profile["UserID"]>0){
$PlayerCareer->updateData(array("Squads"=>$list), $squad["UserID"]);
}else{
$PlayerCareer->insertData(array("Squads"=>$list,"UserID"=>$squad["UserID"]));
}
}
}
}
public function updatemembersAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$PlayerCareer = new Model_PlayerCareer;
$SquadsTable = new Model_Squad;
$mySquads = $SquadsTable->fetchAll();
$squadsL = array();
$n = 1;
foreach ($mySquads as $squad)
{
if($squad["TeamManager"]>0){
echo "". $n." : ". $squad["SID"]."-". $squad["TeamManager"]."
";
$profile = $PlayerCareer->fetchRow("UserID ='".$squad["Author"]."'");
if($profile["UserID"]==$squad["TeamManager"]){
$squadsList = json_decode($profile["Squads"],true);
print_r($squadsList);
$list = array();
foreach($squadsList as $squ){
if($squ["SID"]==$squad["SID"]){
$squadsL[$squad["TeamManager"]]["Data"][$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"42","DATE"=>$squ["DATE"]);
}else{
$squadsL[$squad["TeamManager"]]["Data"][$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>$squ["Pos"],"DATE"=>$squ["DATE"]);
}
}
// echo "". $n." : ". $squad["SID"]."- Updated
";
// $PlayerCareer->updateData(array("Squads"=> json_encode($list)), $squad["Author"]);
}else{
// echo "". $n." : ". $squad["SID"]."- Inserted
";
$squadsL[$squad["TeamManager"]]["Data"][$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"42","DATE"=>date("Y-m-d H:i:s"));
//$PlayerCareer->insertData(array("Squads"=> json_encode($list),"UserID"=>$squad["Author"]));
}
}else{
// echo "". $n." : ". $squad["SID"]."- None
";
}
$n++;
$squadsL[$squad["TeamManager"]]["UserID"] = $squad["TeamManager"];
}
foreach ($squadsL as $squad)
{
if(isset($squad["Data"]))
{
$list = json_encode($squad["Data"]);;
$profile = $PlayerCareer->fetchRow("UserID ='".$squad["UserID"]."'");
if($profile["UserID"]>0){
$PlayerCareer->updateData(array("Squads"=>$list), $squad["UserID"]);
}else{
$PlayerCareer->insertData(array("Squads"=>$list,"UserID"=>$squad["UserID"]));
}
}
}
}
public function updatecoachesAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$PlayerCareer = new Model_PlayerCareer;
$SquadsTable = new Model_Squad;
$mySquads = $SquadsTable->fetchAll();
$n = 1;
foreach ($mySquads as $squad)
{
$members = json_decode($squad["Players"],true);
if(count($members)>0){
foreach($members as $member){
if($member["ID"]>0){
echo "". $n." : ". $squad["SID"]."-". $member["ID"]."
";
$profile = $PlayerCareer->fetchRow("UserID ='".$member["ID"]."'");
if($profile["UserID"]==$member["ID"]){
$squadsList = json_decode($profile["Squads"],true);
print_r($squadsList);
$list = array();
foreach($squadsList as $squ){
if($squ["SID"]==$squad["SID"]){
$list[$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"200","DATE"=>$squ["DATE"]);
}else{
$list[$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"200","DATE"=>$squ["DATE"]);
}
}
echo "". $n." : ". $squad["SID"]."- Updated
";
$PlayerCareer->updateData(array("Squads"=> json_encode($list)), $member["ID"]);
}else{
echo "". $n." : ". $squad["SID"]."- Inserted
";
$list[$squad["SID"]] = array("SID"=>$squad["SID"],"Squad"=>$squad["SquadName"],"Pos"=>"200","DATE"=>date("Y-m-d H:i:s"));
$PlayerCareer->insertData(array("Squads"=> json_encode($list),"UserID"=>$member["ID"]));
}
}else{
echo "". $n." : ". $squad["SID"]."- None
";
}
$n++;
}
}
}
}
public function playersAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$ProfleTable = new Model_GirProfile;
$SquadsTable = new Model_Squad;
$mySquads = $SquadsTable->fetchAll("SquadType >12");
$n = 0;
foreach ($mySquads as $squad)
{
echo "
TEAM : ". $squad["FormDate"]."
";
$listPlayers = json_decode($squad["Players"],true);
if(count($listPlayers)>0){
if(empty($squad["FormDate"])){
$squad["FormDate"] = $mySquads[$n-1]["FormDate"];
$SquadsTable->update(array("FormDate"=>$squad["FormDate"]),"SID ='".$squad["SID"]."'");
}
foreach ($listPlayers as $pla){
$myProfile = $ProfleTable->update(array("DateCreated"=>$squad["FormDate"]),"UserID ='".$pla["ID"]."'");
echo $myProfile["UserID"]."
";
}
}
$n++;
}
}
public function playerstbAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$ProfleTable = new Model_GirProfile;
$mySquads = $ProfleTable->fetchAll();
$n = 0;
$date = "0000-00-00 00:00:00";
foreach ($mySquads as $squad)
{
echo "
TEAM : ". $squad["DateCreated"]."
";
if($squad["DateCreated"]!="0000-00-00 00:00:00" && $squad["DateCreated"]!="1970-01-01 00:00:00"){
$date =$squad["DateCreated"] ;
}
$myProfile = $ProfleTable->update(array("DateCreated"=>$date),"UserID ='".$squad["UserID"]."'");
$n++;
}
}
public function getsquadstestAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$request = $this->getRequest();
$type = $request->getParam("type");
$org = $request->getParam("org");
$year = $request->getParam("year");
$SquadTable = new Model_Squad;
$squads =$SquadTable->getMyAllSquads($org,$year);
$SquadIDs = array();
if(count($squads) >0){
foreach ($squads as $sqd) {
if(! in_array(@$sqd["SID"], $SquadIDs) && @$sqd["SID"] >0 ){
$SquadIDs[] = @$sqd["SID"];
$tourn = $SquadTable->getSquadByTypeGir(@$sqd["SID"]);
$count = 0;
if($tourn){
$count++;
if(empty($tourn["Wallpaper"])){
$wallpaer = "";
}else{
$wallpaer = $tourn["Wallpaper"];
}
if(empty($tourn["SquadImage"])){
$SquadImage = "/IMGS/no-image.jpg";
}else{
$SquadImage = $tourn["SquadImage"];
}
$SquadName = $tourn["ShortName"];
if(empty($tourn["ShortName"])){
$SquadName = $tourn["SquadName"];
}
echo '
';
}
}
}
if($count==0){
echo 'No Squads found
';
}
}else{
echo '
';
}
}
public function indexAction(){
echo "";
$SquadsTable = new Model_Squad;
$mySquads = $SquadsTable->fetchAll();
foreach ($mySquads as $mySquad) {
if(!empty($mySquad["Players"])){
$players = json_decode($mySquad["Players"],true);
if(count($players)>0){
foreach($players AS $player){
if(empty($mySquad["ShortName"])){ $mySquad["ShortName"]= $mySquad["SquadName"];}
$newSquad = array("DATE"=>$mySquad["DateCreated"],"SID"=>$mySquad["SID"],"Squad"=>$mySquad["ShortName"],"Pos"=>$player["Position"],"SquadType"=>$mySquad["SquadType"] );
$PlayerCareerDb = new Model_PlayerCareer;
$MyCarriar = $PlayerCareerDb->fetchRow("UserID ='".$player["ID"]."'");
$json_Squads = json_decode($MyCarriar["Squads"],true);
print_r($json_Squads);
}
}
}
}
}
public function index111Action(){
$SquadsTable = new Model_Squad;
$mySquads = $SquadsTable->fetchAll();
foreach ($mySquads as $mySquad) {
if(!empty($mySquad["Players"])){
$players = json_decode($mySquad["Players"],true);
if(empty($mySquad["ShortName"])){ $mySquad["ShortName"]= $mySquad["SquadName"];}
foreach($players as $player){
if(empty($mySquad["ShortName"])){ $mySquad["ShortName"] = $mySquad["SquadName"]; }
if(strlen($mySquad["ShortName"]) >3 && $mySquad["SID"]>0 && $mySquad["SID"] !=null){
$PlayerCareerDb = new Model_PlayerCareer;
$MyCarriar = $PlayerCareerDb->fetchRow("UserID ='".$player["ID"]."'");
if(isset($MyCarriar["UserID"]) && $MyCarriar["UserID"]>0){
// Update
$squadHistory = json_decode($MyCarriar["Squads"],true);
$newHistory = array();
$i =0;
if(count($squadHistory)>0){
foreach ($squadHistory as $history) {
$newHistory[$i] = array("DATE"=>$history["DATE"],"SID"=>$history["SID"],"Squad"=>$history["Squad"],"Pos"=>$history["Pos"],"SquadType"=>$history["SquadType"] );
$i++;
}
}
echo "";
print_r($newHistory);
$newHistory[count($newHistory)]=array("DATE"=>$mySquad["DateCreated"],"SID"=>$mySquad["SID"],"Squad"=>$mySquad["ShortName"],"Pos"=>$player["Position"],"SquadType"=>$mySquad["SquadType"] );
$PlayerCareerDb->update(array("Squads"=>json_encode($newHistory)),"UserID ='".$player["ID"]."'");
echo "Check";
}else{
//Create
echo "Update";
$newSquad = array("DATE"=>$mySquad["DateCreated"],"SID"=>$mySquad["SID"],"Squad"=>$mySquad["ShortName"],"Pos"=>$player["Position"],"SquadType"=>$mySquad["SquadType"] );
$PlayerCareerDb->insert(array("UserID"=>$player["ID"],"Squads"=>json_encode($newSquad)));
}
print_r($newSquad);
}
}
print_r($players);
}
}
}
public function quickmatchreportAction()
{
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$request = $this->getRequest();
//if($request->isPost()){
$fid = $request->getParam("fid");
$sid = $request->getParam("sid");
$data = $request->getParam("data");
/* $db = new Model_QuickMatchReport;
$fdb = new Model_Fixture;
$fixture = $fdb->getFixture($fid);
$prefix = "A_";
if($fixture["HomeTeam"]==$sid){
$prefix = "H_";
}
$newData["F_ID"] = $fid;
$newData["LastUpdate"] = date("Y-m-d H:i:s");
$newData["HomeID"] = $fixture["HomeTeam"];
$newData["AwayID"] = $fixture["AwayTeam"];
foreach($data as $key=>$val){
$newData[$prefix.$key]=$val;
}
// $insert = $db->insertData($newData);
*/
$mactDB = new Model_MatchReport;
$report = $mactDB->getReport($sid,$fid);
$MatchReportdata["LastUpdate"] = date("Y-m-d H:i:s");
$MatchReportdata["Total_tries"] = $data["Tries"];
$MatchReportdata["Total_Convertions"] = $data["Conversion"];
$MatchReportdata["Total_Penalties"] = $data["Penalties"];
$MatchReportdata["Total_Dropgoals"] = $data["DropGoals"];
$MatchReportdata["PenaltyTries"] = $data["PenaltyTries"];
$MatchReportdata["HHS"] = $data["HalfScore"];
$MatchReportdata["HFS"] = $data["FullScore"];
$MatchReportdata["DateModified"] = date("Y-m-d H:i:s");
//$MRinsert = $mactDB->updateData($MatchReportdata,$report["MID"]);
if($report){
$DisputeDB = new Model_Fixture;
$Dispute = $DisputeDB->getDisputes_by_Fixture($fid);
if($Dispute){
$DB_Score = new Model_TeamScore;
if($Dispute["TeamA_Submitted"]==$sid){
//home team
$DB_Score->justUpdate(array("FID"=>$fid,"SID"=>$sid,"Home_DisputeSolved"=>1));
//check if away team is resisolved
if($Dispute["Away_DisputeSolved"]>0){
// resolve dispute
$Audit_DB = new Model_TeamScoreAudit;
$Audit_DB->updateData(array("FID"=>$fid,"Dispute_Started"=>0));
}
}else if($Dispute["TeamA_Submitted"]==$sid){
//Away team
//home team
$DB_Score->justUpdate(array("FID"=>$fid,"SID"=>$sid,"Away_DisputeSolved"=>1));
//check if away team is resisolved
if($Dispute["Home_DisputeSolved"]>0){
// resolve dispute
$Audit_DB = new Model_TeamScoreAudit;
$Audit_DB->updateData(array("FID"=>$fid,"Dispute_Started"=>0));
}
}
echo "";
print_r($Dispute);
}
echo 1;
}else{
// $update = $db->updateData($newData, $fid);
echo 2;
}
// }
}
}