<?php

require_once "Functions.php";

$logined = Functions::checkIfLogedIn();
$rtnArray = array();
if ($logined['exist'] && !empty($_POST))
{
    $gymID = $_POST['gymId'];
    $packageID = $_POST['packageID'];
    $gymIDToEdit = $gymID;

    if($gymID == -1)
    {
        $ownerGyms = Functions::getOwnerGyms($logined['contract_id']);
        $gymIDToEdit = $ownerGyms[0]->gym_id;
    }

    if(deletePackage($packageID,$gymIDToEdit))
    {
        $rtn_json = array("success" => "True");
        echo json_encode($rtn_json);
    }
    else
    {
        $rtn_json = array("success" => "False");
        echo json_encode($rtn_json);
    }
}

function deletePackage($packageId,$gymId)
{
    return deletePackageObjects($packageId) && deletePackageDays($packageId) && deletePackagePermitedGyms($packageId,$gymId) && deletePackage($packageId);
}

function deletePackageObjects($packageId)
{
    $query = "DELETE FROM my_gym.package_objects WHERE package_package_id = ?";
    $stmt = Database::getInstance()->connect()->prepare($query);
    $stmt->bindParam(1, $packageId);

    if($stmt->execute())
    {
        Database::getInstance()->CloseConnection();
        return true;
    }
    else
    {
         Database::getInstance()->CloseConnection();
         return false;
    }
}

function deletePackageDays($packageId)
{
    $query = "DELETE FROM my_gym.package_days WHERE package_package_id = ?";
    $stmt = Database::getInstance()->connect()->prepare($query);
    $stmt->bindParam(1, $packageId);

    if($stmt->execute())
    {
        Database::getInstance()->CloseConnection();
        return true;
    }
    else
    {
         Database::getInstance()->CloseConnection();
         return false;
    }
}

function deletePackage($packageId)
{
    $query = "DELETE FROM my_gym.package WHERE package_id = ?";
    $stmt = Database::getInstance()->connect()->prepare($query);
    $stmt->bindParam(1, $packageId);

    if($stmt->execute())
    {
        Database::getInstance()->CloseConnection();
        return true;
    }
    else
    {
         Database::getInstance()->CloseConnection();
         return false;
    }
}

function deletePackagePermitedGyms($packageId,$gymId)
{
    $query = "DELETE FROM my_gym.package_permited_gyms WHERE package_package_id = ? AND gym_gym_id = ?";
    $stmt = Database::getInstance()->connect()->prepare($query);
    $stmt->bindParam(1, $packageId);
    $stmt->bindParam(2, $gymId);

    if($stmt->execute())
    {
        Database::getInstance()->CloseConnection();
        return true;
    }
    else
    {
         Database::getInstance()->CloseConnection();
         return false;
    }
}