<?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["branch_id"])) {
    $branch_id = $_GET['branch_id'];
 
    // get a deptId from beatle_industry table
    $result = mysql_query("SELECT * FROM beatle_branch WHERE branchId  LIKE '$branch_id'")or die(mysql_error());
 
    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
 
            $result = mysql_fetch_array($result);

            $branchDetail = array();
            $branchDetail["branch_id"] = $result["branchId"];
			$branchDetail["branchName"] = $result["db_branchName"];
            $branchDetail["branchOrg"] = $result["db_branchOrg"];
			$branchDetail["branchManager"] = $result["db_branchManager"];
			$branchDetail["Branchcreated_date"] = $result["Branchcreated_date"];
			
			$result1 = mysql_query("SELECT db_Orgpics FROM beatle_organization WHERE OrgId  LIKE '$result[db_branchOrg]' ")or die(mysql_error());
            $orgLogo = "";
						if (!empty($result1)) {
							$row = mysql_fetch_row($result1);
							$orgLogo = $row[0];
						 }
			$branchDetail["orgLogo"] = $orgLogo;
			
			$result2 = mysql_query("SELECT db_pagepermistion FROM beatle_userlogin WHERE db_usertype  LIKE 'owner' AND OrgID LIKE '$result[db_branchOrg]' ")or die(mysql_error());
            $pagepermission = "";
						if (!empty($result2)) {
							$row = mysql_fetch_row($result2);
							$pagepermission = $row[0];
						 }
			$branchDetail["pagepermission"] = $pagepermission;
		
			// success
            $response["success"] = 1;
 
            // user node
            $response["branchDetail"] = array();
 
            array_push($response["branchDetail"], $branchDetail);
 
            // echoing JSON response
            echo json_encode($response);
        } else {
            // no product found
            $response["success"] = 0;
            $response["message"] = "No product found";
 
            // echo no users JSON
            echo json_encode($response);
        }
    }  else {
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No product found.";
 
        // echo no users JSON
        echo json_encode($response);
    }
}else if (isset($_GET["branch_ids"],$_GET["ind_id"])) {
    $branch_id = $_GET['branch_ids'];
    $ind_id    = $_GET['ind_id'];
 
    // get a deptId from beatle_industry table
    $result = mysql_query("SELECT * FROM beatle_branch WHERE branchId  LIKE '$branch_id'")or die(mysql_error());
 
    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
 
            $result = mysql_fetch_array($result);

            $branchDetail = array();
            $branchDetail["branch_id"] = $result["branchId"];
            $branchDetail["branchName"] = $result["db_branchName"];
            $branchDetail["branchOrg"] = $result["db_branchOrg"];
            $branchDetail["branchManager"] = $result["db_branchManager"];
            $branchDetail["Branchcreated_date"] = $result["Branchcreated_date"];
            
            $result1 = mysql_query("SELECT db_Orgpics FROM beatle_organization WHERE OrgId  LIKE '$result[db_branchOrg]' ")or die(mysql_error());
            $orgLogo = "";
                        if (!empty($result1)) {
                            $row = mysql_fetch_row($result1);
                            $orgLogo = $row[0];
                         }
            $branchDetail["orgLogo"] = $orgLogo;
            
            $result2 = mysql_query("SELECT db_pagepermistion FROM beatle_userlogin WHERE db_usertype  LIKE 'owner' AND OrgID LIKE '$result[db_branchOrg]' ")or die(mysql_error());
            $pagepermissionOrg = "";
                        if (!empty($result2)) {
                            $row = mysql_fetch_row($result2);
                            $pagepermissionOrg = $row[0];
                         }
            $branchDetail["pagepermissionOrg"] = $pagepermissionOrg;

            $result3 = mysql_query("SELECT db_pagepermistion FROM beatle_userlogin WHERE db_usertype LIKE 'line_manager' AND IndustryID LIKE '$ind_id' ")or die(mysql_error());  
            $pagepermissionIng = "";
                        if (!empty($result3)) {
                            $row = mysql_fetch_row($result3);
                            $pagepermissionIng = $row[0];
                         }
            $branchDetail["pagepermissionIng"] = $pagepermissionIng;

            // success
            $response["success"] = 1;
 
            // user node
            $response["branchDetail"] = array();
 
            array_push($response["branchDetail"], $branchDetail);
 
            // echoing JSON response
            echo json_encode($response);
        } else {
            // no product found
            $response["success"] = 0;
            $response["message"] = "No product found";
 
            // echo no users JSON
            echo json_encode($response);
        }
    }  else {
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No product 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);
}


?>