<?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["orgId"],$_GET["branchId"],$_GET["induId"],$_GET["status"])) {
    $org_id = $_GET['orgId'];
	$branch_id = $_GET['branchId'];
	$ind_id = $_GET['induId'];
	//$usertype = $_GET["usertype"];
	$status = $_GET['status'];
	$test = '"new","forward"';
 
    // get a deptId from beatle_industry table
	if(empty($branch_id) and empty($ind_id)){
    //$result = mysql_query("SELECT * FROM beatle_ticket WHERE orgid = '$org_id' AND status = '$status' AND usertype = 'End_user' AND active = 'Y' ")or die(mysql_error());
		if($status == "new"){
			$result = mysql_query("SELECT * FROM beatle_ticket WHERE orgid = '$org_id' AND status in ('new', 'forward') AND usertype = 'End_user' ")or die(mysql_error());
		}else{
			$result = mysql_query("SELECT * FROM beatle_ticket WHERE orgid = '$org_id' AND status = '$status' AND usertype = 'End_user' AND active = 'Y' ")or die(mysql_error());
		}
	}elseif(empty($ind_id)){
		if($status == "new"){
			$result = mysql_query("SELECT * FROM beatle_ticket WHERE orgid = '$org_id' AND branchid = '$branch_id' AND status in ('new', 'forward') AND usertype = 'End_user' ")or die(mysql_error());
		}else{
			$result = mysql_query("SELECT * FROM beatle_ticket WHERE orgid = '$org_id' AND branchid = '$branch_id' AND status = '$status' AND usertype = 'End_user' AND active = 'Y' ")or die(mysql_error());
		}
	}else{
		if($status == "new"){
			$result = mysql_query("SELECT * FROM beatle_ticket WHERE orgid = '$org_id' AND branchid = '$branch_id' AND indid = '$ind_id' AND status in ('new', 'forward') AND usertype = 'End_user' ")or die(mysql_error());
		}else{
			$result = mysql_query("SELECT * FROM beatle_ticket WHERE orgid = '$org_id' AND branchid = '$branch_id' AND indid = '$ind_id' AND status = '$status' AND usertype = 'End_user' AND active = 'Y' ")or die(mysql_error());
		}
	}
	
	    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
 
			 $response["ticketsDetail"] = array();
			 
			  while ($row = mysql_fetch_array($result)) {
				$ticketsDetail = array();
				$username = '';
				$usermobileno = '';
				$useremail = '';
				$userprofile = '';
				$result1 = mysql_query("SELECT * FROM beatle_userlogin where userId LIKE ".$row["userid"]." ")or die(mysql_error());
				if (!empty($result1)) {
					$row1 = mysql_fetch_array($result1);
					if($row1['db_username'] == ""){
						$username = $row1['db_phone'];
						$usermobileno = $row1['db_phone'];
						$useremail = $row1['db_email'];
						$userprofile = $row1['db_userprofilepic'];
					}else{
						$username = $row1['db_username'];
						$usermobileno = $row1['db_phone'];
						$useremail = $row1['db_email'];
						$userprofile = $row1['db_userprofilepic'];
					}
				}
				$orgname = '';
				$result2 = mysql_query("SELECT * FROM beatle_organization where OrgId LIKE ".$row["orgid"]." ")or die(mysql_error());
				if (!empty($result2)) {
					$row1 = mysql_fetch_array($result2);
					$orgname = $row1['db_Orgname'];

				}
				$branchname = '';
				$result3 = mysql_query("SELECT * FROM beatle_branch where branchId LIKE ".$row["branchid"]." ")or die(mysql_error());
				if (!empty($result3)) {
					$row1 = mysql_fetch_array($result3);
					$branchname = $row1['db_branchName'];

				}
				$indname = '';
				$result4 = mysql_query("SELECT * FROM beatle_industry where IndId LIKE ".$row["indid"]." ")or die(mysql_error());
				if (!empty($result4)) {
					$row1 = mysql_fetch_array($result4);
					$indname = $row1['db_industry'];

				}

				$content = $row["contentselection"];
				$original_array=unserialize($content);
				
				$ticketsDetail["ticketid"] = $row["ticketid"];
				$ticketsDetail["id"] = $row["id"];
				$ticketsDetail["ticketuid"] = $row["ticketuid"];
				$ticketsDetail["userid"] = $row["userid"];
				$ticketsDetail["username"] = $username;
				$ticketsDetail["usertype"] = $row["usertype"];
				$ticketsDetail["usermobileno"] = $usermobileno;
				$ticketsDetail["useremail"] = $useremail;
				$ticketsDetail["userprofile"] = $userprofile;
				$ticketsDetail["orgid"] = $row["orgid"];
				$ticketsDetail["orgname"] = $orgname;
				$ticketsDetail["branchid"] = $row["branchid"];
				$ticketsDetail["branchname"] = $branchname;
				$ticketsDetail["indid"] = $row["indid"];
				$ticketsDetail["indname"] = $indname;				
				$ticketsDetail["assignto"] = $row["assignto"];
				$ticketsDetail["assignto_type"] = $row["assignto_type"];
				$ticketsDetail["message"] = $row["message"];
				$ticketsDetail["forward"] = $row["forward"];
				$ticketsDetail["status"] = $row["status"];
				$ticketsDetail["tokenid"] = $row["tokenid"];
				$ticketsDetail["created_date"] = $row["created_date"];
				$ticketsDetail["level"] = $row["level"];
				$ticketsDetail["contentselection"] = $row["contentselection"];
				$ticketsDetail["pageid"] = $original_array[0]['pageid'];
				$ticketsDetail["pagecid"] = $original_array[0]['pagecid'];
				$ticketsDetail["pagename"] = fetchPageName($original_array[0]['pageid']);
				$ticketsDetail["pagecname"] = fetchPageContentName($original_array[0]['pagecid']);
				$ticketsDetail["parentid"] = $row["parentid"];
				$ticketsDetail["active"] = $row["active"];
				$ticketsDetail["customer_contact"] = $row["customer_contact"];
				
				// push single product into final response array
				array_push($response["ticketsDetail"], $ticketsDetail);
			}
          
            // success
            $response["success"] = 1;

            // echoing JSON response
            echo json_encode($response);
        } else {
            // no product found
            $response["success"] = 0;
            $response["message"] = "No tickets found";
 
            // echo no users JSON
            echo json_encode($response);
        }
    }  else {
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No tickets found.";
 
        // echo no users JSON
        echo json_encode($response);
    }
	
}else{
	
	// no product found
            $response["success"] = 0;
            $response["message"] = "Required field(s) is missing";
 
            // echo no users JSON
            echo json_encode($response);
}
 function fetchPageName($pageid){
		$SQL = "SELECT db_pagename FROM beatle_page WHERE pageId = ".$pageid;
		$row1 = mysql_fetch_array(mysql_query($SQL));
		return $row1['db_pagename'];
	}
 function fetchPageContentName($pagecid){
		$SQL = "SELECT db_pageConTitle FROM beatle_pagecontent WHERE pageConId = ".$pagecid;
		$row1 = mysql_fetch_array(mysql_query($SQL));
		return $row1['db_pageConTitle'];
	}
?>