<?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';

date_default_timezone_set('Asia/Kolkata'); 

// connecting to db
$db = new DB_CONNECT();
$test = '';

if(isset($_GET["userid"],$_GET["branchId"],$_GET["indId"],$_GET["orgID"],$_GET["keyword"],$_GET["noOfPax"],$_GET["totalBill"],$_GET["servername"],$_GET['values'])){

	$userid 	= $_GET['userid'];
	$orgID 		= $_GET['orgID'];
	$branchId 	= $_GET['branchId'];
	$indId 		= $_GET['indId'];
	$keyword 	= $_GET["keyword"];
	$noOfPax	= '';
	$totalBill	= '';
	$tokenid 	= random_string(32);
	$is_submit 	= 'Y';
	$date		= date('Y-m-d H:i:s');
	
	if($_GET["noOfPax"] == ""){
		$noOfPax = "0";
	}else{
		$noOfPax = $_GET["noOfPax"];
	}
	if($_GET["totalBill"] == ""){
		$totalBill = "0";
	}else{
		$totalBill = $_GET["totalBill"];
	}
	if($_GET["servername"] == ""){
		$servername = "NA";
	}else{
		$servername = $_GET["servername"];
	}

	//array of content values
	$rate1 = "";
	for ($r=0; $r <= count($_GET['values'])-1; $r++){ 
    	//$rate1 .= $_GET['values'][$r]."\n";
    	$myArray = explode('@!#!@', $_GET['values'][$r]);
    	/*foreach ($myArray as $value) {
    		$rate1 .= $value."  ";
    	}
    	$rate1 .= "\n";*/
    	$result = mysql_query("INSERT INTO beatle_survey(db_surveyBranchid,db_surveyUserid,db_surveyIndId,db_surveyPageid,db_surveyContentId,db_surveyValue, created_date, updated_date, tokenid,orgid,is_submit,keyword,paxNo,totalBill,servername) VALUES
					('$branchId','$userid', '$indId', '$myArray[0]', '$myArray[1]', '$myArray[2]', '$date', '0000-00-00 00:00:00', '$tokenid','$orgID','$is_submit', '$keyword', '$noOfPax', '$totalBill', '$servername')")or die(mysql_error());
    } 

	$pointValue = '';
	$userType = '';
	
	$resultConfig = mysql_query("SELECT ConfigValue FROM appconfig WHERE ConfigName LIKE 'RECORDS_PER_PAGE'")or die(mysql_error());	
	if (!empty($resultConfig)) {
					$row = mysql_fetch_row($resultConfig);
					$test = $row[0];
					$pointValue = $test;
					
	}
	$resultUserType = mysql_query("SELECT db_usertype FROM beatle_userlogin WHERE userId LIKE ".$userid." ")or die(mysql_error());	
	if (!empty($resultUserType)) {
					$row = mysql_fetch_row($resultUserType);
					$test = $row[0];
					$userType = $test;
					
	}
    
     $result = mysql_query("INSERT INTO beatle_points (UserID,OrgID,BranchID,IndustryID,UserType,tokenid,Amount,AddedDate,IsRedeem)VALUES('$userid','$orgID','$branchId','$indId','$userType','$tokenid','$pointValue','$date','N')");
 
					// check if row inserted or not
					if ($result) {
						// successfully inserted into database
						$response["success"] = 1;
						$response["message"] = "feedback successfully submitted.";
					
						// echoing JSON response
						echo json_encode($response);
					} else {
						// failed to insert row
						$response["success"] = 0;
						$response["message"] = "feedback has not submitted.";
				 
						// echoing JSON response
						echo json_encode($response);
					}	
	
	/*$response["success"] = 1;
	// $response["message"] = "feedback successfully submitted.";
	$response["message"] = $rate1;
	$response["userData"] = $userid."\n".$orgID."\n".$branchId."\n".$indId."\n".$keyword."\n".$noOfPax."\n".$totalBill."\n".$servername;*/
	//$response["value"]   = $all_arraylist;
	// echo json_encode($response);
}else{
	$response["success"] = 0;
	$response["message"] = "Oops! An error occurred.";
	 echo json_encode($response);
}
//tokenid genarator 
 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;
}
?>