#!/usr/bin/php
<?php

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

if(empty($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($verNum){

echo "\nCreating Dev pack\n";
echo "Syncing contents\n";
echo  "SCP'ing to <192.168.1.3>\n";

        shell_exec("
        cd ~/
        mkdir '$mach'-'$verNum'
        rsync -av  /var/www/lol.com/public_html/deployment ~/'$mach'-'$verNum'
        tar -cvzf $mach'-'$verNum.tar.gz $mach'-'$verNum
        scp -r $mach'-'$verNum.tar.gz  cmondragon@$ipAdd:

          ");
        }

}
function getVerNum(){

$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 LIMIT 1";
$result = $conn->query($sql);

if ($result->num_rows > 0){
  while($row = $result->fetch_assoc()) {
        $rowVersion = $row["versionNumber"];
        print "Version Number: " . $rowVersion;
  }
} else {
    echo "No Version Number\n";
  }

}

//------------------------------------------------------------------
}
switch (true)
{
  case "vpaks":
  echo "Returning Current Version Number from Database";
  getVerNum();
  //ideally this would be split into frontend/backend/dmz content
  echo "Bundling Contents from ../public_html/deployment";
  echo "Sending tar package to $ipAdd";

    bundleDevPackage()

    break;
  case "automatedInstall":

    break;
  case "rollback":
    echo "Rolling Back to a previous version";
    break;
}

?>