<?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();
 
// check for post data
if (isset($_GET["org_id"])) {
    $org_id = $_GET['org_id'];
 
    // get a deptId from beatle_industry table
    $result = mysql_query("SELECT * FROM beatle_offers WHERE orgid  LIKE '$org_id'")or die(mysql_error());
 
	    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
 
			 $response["offersDetail"] = array();
			  while ($row = mysql_fetch_array($result)) {
				  
				$offersDetail = array();
				$offersDetail["offerid"] = $row["offerid"];
				$offersDetail["offeruid"] = $row["offeruid"];
				$offersDetail["orgid"] = $row["orgid"];
				$offersDetail["title"] = $row["title"];
				$offersDetail["startdate"] = $row["startdate"];
				$offersDetail["enddate"] = $row["enddate"];
				$offersDetail["description"] = $row["description"];
				$offersDetail["comment"] = $row["comment"];
				$offersDetail["active"] = $row["active"];
				$offersDetail["onhold"] = $row["onhold"];
				$offersDetail["created_date"] = $row["created_date"];
				$offersDetail["offer_image"] = $row["offer_image"];
				$offersDetail["epoint"] = $row["epoint"];
				$offersDetail["offertempid"] = $row["offertempid"];
			
				// push single product into final response array
				array_push($response["offersDetail"], $offersDetail);
			}
          
            // success
            $response["success"] = 1;

            // echoing JSON response
            echo json_encode($response);
        } else {
            // no product found
            $response["success"] = 0;
            $response["message"] = "No offers found";
 
            // echo no users JSON
            echo json_encode($response);
        }
    }  else {
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No offers found.";
 
        // echo no users JSON
        echo json_encode($response);
    }
	
}else {
	
	$sdate = date("Y-m-d H:i:s");
   // get a deptId from beatle_industry table
    $result = mysql_query("SELECT * FROM beatle_offers where enddate >= '$sdate' ")or die(mysql_error());
 
	    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
 
			 $response["offersDetail"] = array();
			  while ($row = mysql_fetch_array($result)) {
				  
				$offersDetail = array();
				$offersDetail["offerid"] = $row["offerid"];
				$offersDetail["offeruid"] = $row["offeruid"];
				$offersDetail["orgid"] = $row["orgid"];
				$offersDetail["title"] = $row["title"];
				$offersDetail["startdate"] = $row["startdate"];
				$offersDetail["enddate"] = $row["enddate"];
				$offersDetail["description"] = $row["description"];
				$offersDetail["comment"] = $row["comment"];
				$offersDetail["active"] = $row["active"];
				$offersDetail["onhold"] = $row["onhold"];
				$offersDetail["created_date"] = $row["created_date"];
				$offersDetail["offer_image"] = $row["offer_image"];
				$offersDetail["spoint"] = $row["spoint"];
				$offersDetail["epoint"] = $row["epoint"];
				$offersDetail["offertempid"] = $row["offertempid"];
			
				// push single product into final response array
				array_push($response["offersDetail"], $offersDetail);
			}
          
            // success
            $response["success"] = 1;

            // echoing JSON response
            echo json_encode($response);
        } else {
            // no product found
            $response["success"] = 0;
            $response["message"] = "No offers found";
 
            // echo no users JSON
            echo json_encode($response);
        }
    }  else {
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No offers found.";
 
        // echo no users JSON
        echo json_encode($response);
    }
}
?>