<?php
/*
 * Following code will get single department details
 * create ticket
 */
 
// array for JSON response
$response = array();
 
// include db connect class
require_once 'db_connect.php';
 
// connecting to db
$db = new DB_CONNECT();
$test = '';
//if (isset($_GET["branchId"],$_GET["indId"],$_GET["orgID"])) {
if (isset($_GET["userid"],$_GET["usertype"],$_GET["branchId"],$_GET["indId"],$_GET["orgID"],$_GET["message"],$_GET["pagecontent"])) {    
    $pagecontent = $_GET['pagecontent'];
	
	$userid = $_GET['userid'];
	$usertype = $_GET['usertype'];
	$orgID = $_GET['orgID'];
	$branchId = $_GET['branchId'];
	$indId = $_GET['indId'];
	$assigntouid = ''; //get by select query
	$assignto_type = 'line_manager';
	$message = $_GET['message'];
	$forward = 'N';
	$status = 'new';
	$tokenid = random_string(25); 
	$date	= date('Y-m-d H:i:s');
	$level = 1;
		$pageid = '';
		$pagecid = '';
	//$contentselection = serialize(array(array('pageid'=>''.$pageid.'','pagecid'=>''.$pagecid.'')));
	$parentid = 0;
	$id = ''; //get by query
	$ticketuid = ''; 
	$active = 'Y';
	
	  // get a deptId from beatle_industry table
    $result = mysql_query("SELECT * FROM beatle_userlogin WHERE OrgID LIKE '$orgID' AND BranchID LIKE '$branchId' AND IndustryID LIKE '$indId' AND db_usertype LIKE 'line_manager'")or die(mysql_error());

    if (!empty($result)) {
        // check for empty result
        if (mysql_num_rows($result) > 0) {
 
            $result = mysql_fetch_array($result);

            $assigntouid = $result["userId"];
			
			$result2 = mysql_query("SELECT * FROM beatle_pagecontent WHERE db_pageConTitle LIKE '$pagecontent'")or die(mysql_error());

			if (!empty($result2)) {
				$result2 = mysql_fetch_array($result2);
				$pageid = $result2["db_pageid"];
				$pagecid =$result2["pageConId"];
				//$pageDetail["pageChoice"] = $result["db_pageChoice"];
				$contentselection = serialize(array(array('pageid'=>''.$pageid.'','pagecid'=>''.$pagecid.'')));
				$result3 = mysql_query("SELECT id FROM beatle_ticket WHERE parentid LIKE '0' ORDER BY ticketid DESC LIMIT 1")or die(mysql_error());
				if (!empty($result3)) {
					$row = mysql_fetch_row($result3);
					$id = $row[0]+1;
					$ticketuid = str_pad($id, 5, "0", STR_PAD_LEFT); //00012
					//echo $row[0]+1;
					
					
					$result4 = mysql_query("INSERT INTO beatle_ticket(id,ticketuid,userid,usertype,orgid,branchid, indid, assignto, assignto_type,message,forward,status,tokenid,created_date,level,contentselection,parentid,active,customer_contact) VALUES('$id','$ticketuid', '$userid', '$usertype', '$orgID', '$branchId', '$indId', '$assigntouid', '$assignto_type','$message','$forward','$status','$tokenid','$date','$level','$contentselection','$parentid','$active','no')")or die(mysql_error());
 
					// check if row inserted or not
					if ($result4) {
						// successfully inserted into database
						$response["success"] = 1;
						$response["message"] = "ticket successfully created.";
						
						$result5 = mysql_query("SELECT ticketuid FROM beatle_ticket WHERE ID LIKE '$id'")or die(mysql_error());
						$ticketNo = "";
						if (!empty($result5)) {
							$row = mysql_fetch_row($result5);
							$ticketNo = $row[0];
						 }
						 $response["ticketNo"] = $ticketNo;
						// echoing JSON response
						echo json_encode($response);
					} else {
						// failed to insert row
						$response["success"] = 0;
						$response["message"] = "Oops! An error occurred.";
				 
						// echoing JSON response
						echo json_encode($response);
					}					
				   
				}  else {
					// echo no users JSON
					echo 'ticket id not created';
				}
			
			}else{
				echo 'pageid and pagecontentid not found';
			}
					
        } else {
            // no branch found
            $response["success"] = 0;
            $response["message"] = "No assigntouid found";
 
            // echo no users JSON
            echo json_encode($response);
        }
    }  else {
        // no industry found
        $response["success"] = 0;
        $response["message"] = "No assigntouid 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);
}

 function random_string($length) {
    $key = '';
    $keys = array_merge(range(0, 9), range('a', 'z'));

    for ($i = 0; $i < $length; $i++) {
        $key .= $keys[array_rand($keys)];
    }

    return $key;
}
?>