<?php
/*
 * Following code will get single department details
 * A industry is identified by dept_id
 */
 
// array for JSON response
$response = array();
 
// include db connect class
require_once 'db_connect.php';
 
// connecting to db
$db = new DB_CONNECT();
 
if (isset($_GET["orgid"])) {
    $orgid = $_GET['orgid'];
    $result = mysql_query("SELECT beatle_userlogin.created_date, beatle_userlogin.db_valid, beatle_userlogin.db_valid_from FROM beatle_userlogin 
		WHERE OrgID = ".$orgid." AND beatle_userlogin.userId = (SELECT db_ownerId FROM beatle_organization WHERE OrgId = ".$orgid.")")or die(mysql_error());
    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
 
            $result = mysql_fetch_array($result);
			
			$datetime1 = new DateTime($result['db_valid_from']);
			$datetime2 = new DateTime($result['db_valid']);
			$datetime3 = new DateTime(date("Y-m-d H:i:s"));
			$interval = $datetime1->diff($datetime2);
			$diff = $interval->format('%a');
			
			$interval1 = $datetime1->diff($datetime3);
			$diff1 = $interval1->format('%a');
			
			// $returnArr['totalday'] = $diff;
			// $returnArr['used'] = $diff1;
			
            $subDateDetail = array();
			$subDateDetail["totalday"] = $diff;
            $subDateDetail["used"] = $diff1;
			$subDateDetail["left"] = $diff-$diff1;
			
            // success
            $response["success"] = 1;
 
            // user node
            $response["subDateDetail"] = array();
 
            array_push($response["subDateDetail"], $subDateDetail);
 
            // echoing JSON response
            echo json_encode($response);
        } else {
           
					// no industry found
					$response["success"] = 0;
					$response["message"] = "No data found...";
			 
					// echo no users JSON
					echo json_encode($response); 
			
			}
    }  else {
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No data found.";
 
        // echo no users JSON
        echo json_encode($response);
    }
}else {
    // required field is missing
    $response["success"] = 0;
    $response["message"] = "Required field(s) is missing";
 
    // echoing JSON response
    echo json_encode($response);
}
?>