<?php
header('Access-Control-Allow-Origin: https://jodhpurstation.in');
//header('Access-Control-Allow-Origin: *');
//header('Access-Control-Allow-Credentials: true');
// 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["reviewId"],$_GET["fromdate"],$_GET["todate"])) {
    $reviewId    = $_GET["reviewId"];
	$FromDate = $_GET["fromdate"];
	$ToDate   = $_GET["todate"];
  
  $result = mysql_query("SET NAMES utf8"); //the main trick form hindi languages
	$SQL = "SELECT * FROM beatle_review_feedback WHERE reviewId LIKE '$reviewId' ";
  if(!empty($FromDate) && !empty($ToDate))
  $SQL .= "AND feedbackDate BETWEEN '".date("Y-m-d",strtotime($FromDate))." 00:00:00' AND '".date("Y-m-d",strtotime($ToDate))." 23:59:59' ";

  $SQL .= "ORDER BY feedbackDate DESC";
	//echo $SQL;
	$result = mysql_query($SQL);
	//$SQL .= " AND created_date BETWEEN '".$FromDate." 00:00:00' AND '".$ToDate." 23:59:59' ";
	 if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {

			$response["feedbackDetail"] = array();
			$no = 1;
			while ($row = mysql_fetch_array($result)) {

				$feedbackDetail = array();
				$feedbackDetail["id"] = $no++;
                $feedbackDetail["userId"] = $row["userId"];
                $feedbackDetail["username"] = $row["username"];
				$feedbackDetail["avgRating"] = $row["avgRating"];
				$feedbackDetail["comment"] = $row["feedbackDetail"];
                $feedbackDetail["tokenid"] = $row["tokenid"];
				$feedbackDetail["feedbackDate"] = $row["feedbackDate"];

				// push single product into final response array
				array_push($response["feedbackDetail"], $feedbackDetail);
			}

            // success
            $response["success"] = 1;
            $response["message"] = "success";
            $response["feedbackCount"] = mysql_num_rows($result);

            // echoing JSON response
            echo json_encode($response);
        } else {
            // no product found
            $response["success"] = 0;
            $response["message"] = "No feedback found";

            // echo no users JSON
            echo json_encode($response);
        }
    }else{
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No feedback found";

        // echo no users JSON
        echo json_encode($response);
    }
}else{

    $response["success"] = 0;
    $response["message"] = "Required field(s) is missing";

    echo json_encode($response);
}


 ?>