!/usr/bin/php
<?php


$deploymentAction = $argv[1];
$verNum= $argv[2];


if($argv[1] && $argv[2] && $argv[3] ){

      echo "              DEPLOYMENT ACTIONS      \n ";
      echo "Please Choose a Function followed by Version Number and <IP>\n";

      echo "----------------------------------------------------\n";
      echo  "  (1)-vpaks: (2)-automatedInstall: (3)-Rollback    \n";
      echo "----------------------------------------------------\n";
      echo "     1.0(Dev)    |   2.0(QA)  |   3.0(Prod.)        \n";
}




function bundleDevPackage($verFile,$ipAdd){


        shell_exec("
        scp -r $verFile  blackout@$192.168.1.$ipAdd:

          ");
        }


function deployFE($rollout){

$servername = "localhost";
$username = "root";
$password = "chemistry";
$dbname = "Versions";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT frontEnd FROM Versions WHERE cast(versionNumber as decimal(2,1)) =$verNum";

$result = $conn->query($sql);

if ($result->num_rows > 0){
  while($row = $result->fetch_assoc()) {
        $rowVersion = $row["frontEnd"];
         echo  $rowVersion." is set to Deploy\n";
          //return $rowVersion;
        }

  }

  $rollout = argv[2];
  $ip = "1" . $rollout . "2";

  bundleDevPackage($rowVersion,$ip);

}


function deployBE(){


}


function deployDMZ(){


}
//------------------------------------------------------------------------------------

function checkVerNum($verNum){

$servername = "localhost";
$username = "root";
$password = "chemistry";
$dbname = "Versions";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT versionNumber FROM Versions WHERE cast(versionNumber as decimal(2,1)) =$verNum";
$sql2 = "SELECT versionNumber FROM Versions";

$result = $conn->query($sql);
$result2= $conn->query($sql2);

if ($result->num_rows > 0){
  while($row = $result->fetch_assoc()) {
        $rowVersion = $row["versionNumber"];
        if($rowVersion == $verNum){
          echo "Version: ".$rowVersion." is set to Deploy\n";
          //return $rowVersion;
        }

  }
        return true;

}
else{
    if ($result2->num_rows > 0){
        while($row = $result2->fetch_assoc()) {
          $rowVersion = $row["versionNumber"];
          echo "Invalid Version Number. Appropriate Versions include: ". $rowVersion."\n";
        }
     }
         return false;
}


}

//--------------------------------------------------------------------------------------------------

function deployInstall(){

  shell_exec("
    ssh blackout@$ipAdd
    cd ~/
    tar -xcvf Pak'-'$verNum.tar.gz");

}


//------------------------------------------------------------------
switch ($deploymentAction)
{
  case "vpaks":

   checkVerNum($verNum)



  break;

 case "automatedInstall":
      if(checkVerNum()){
        deployFE($argv[3]);
      }




    break;
  case "rollback":
    echo "Rolling Back to a previous version\n";
    break;
}
?>