File: /home/barbeatleanalyti/public_html/api.beatleanalytics.com/live/service.php 1-9-2018
<?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["dept_id"])) {
$dept_id = $_GET['dept_id'];
// get a deptId from beatle_industry table
$result = mysql_query("SELECT * FROM beatle_industry WHERE db_IndLoginId LIKE '$dept_id'")or die(mysql_error());
if (!empty($result)) {
// check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$deptDetail = array();
$deptDetail["dept_id"] = $result["db_IndLoginId"];
$deptDetail["ind_id"] = $result["IndId"];
$deptDetail["ind_name"] = $result["db_industry"];
$deptDetail["branch_id"] = $result["db_bracnchid"];
$rsOrg = mysql_query("SELECT db_branchOrg, db_branchName FROM beatle_branch WHERE branchId LIKE '$result[db_bracnchid]' ")or die(mysql_error());
$orgID = "";
$branchName = "";
if(!empty($rsOrg)){
$row = mysql_fetch_row($rsOrg);
$orgID = $row[0];
$branchName = $row[1];
}
$deptDetail["branchName"] = $branchName;
$deptDetail["org_id"] = $orgID;
$deptDetail["ind_type"] = fetchIndType($result["db_ind_type_id"]);
$deptDetail["keyword"] = $result["keywordName"];
$deptDetail["keywordServer"] = $result["keywordServer"];
$deptDetail["keywordPax"] = $result["keywordPax"];
$deptDetail["keyword4"] = $result["keyword4"];
// success
$response["success"] = 1;
// user node
$response["deptDetail"] = array();
array_push($response["deptDetail"], $deptDetail);
// 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["phoneno"],$_GET["pass"])) {
$phoneno = $_GET['phoneno'];
$password = $_GET['pass'];
$pass = md5($password);
// get a deptId from beatle_industry table
$result = mysql_query("SELECT * FROM beatle_userlogin WHERE db_phone LIKE '$phoneno' AND db_password LIKE '$pass'")or die(mysql_error());
$result2 = mysql_query("SELECT * FROM beatle_userlogin WHERE db_userLoginName LIKE '$phoneno' AND db_password LIKE '$pass'")or die(mysql_error());
if (!empty($result)) {
// check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$userDetail = array();
$userDetail["userid"] = $result["userId"];
$userDetail["db_phone"] = $result["db_phone"];
$userDetail["userLoginName"] = $result["db_userLoginName"];
$userDetail["username"] = $result["db_username"];
$userDetail["password"] = $result["db_password"];
$userDetail["usertype"] = $result["db_usertype"];
$userDetail["orgID"] = $result["OrgID"];
$userDetail["branchID"] = $result["BranchID"];
$userDetail["industryID"] = $result["IndustryID"];
// success
$response["success"] = 1;
// user node
$response["userDetail"] = array();
array_push($response["userDetail"], $userDetail);
// 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);
if (!empty($result2)) {
if (mysql_num_rows($result2) > 0) {
$result = mysql_fetch_array($result2);
$userDetail = array();
$userDetail["userid"] = $result["userId"];
$userDetail["db_phone"] = $result["db_phone"];
$userDetail["userLoginName"] = $result["db_userLoginName"];
$userDetail["username"] = $result["db_username"];
$userDetail["password"] = $result["db_password"];
$userDetail["usertype"] = $result["db_usertype"];
$userDetail["orgID"] = $result["OrgID"];
$userDetail["branchID"] = $result["BranchID"];
$userDetail["industryID"] = $result["IndustryID"];
// success
$response["success"] = 1;
// user node
$response["userDetail"] = array();
array_push($response["userDetail"], $userDetail);
// echoing JSON response
echo json_encode($response);
}else {
// no industry found
$response["success"] = 0;
$response["message"] = "No user found...";
// echo no users JSON
echo json_encode($response);
}
}
}
} else {
// no industry found
$response["success"] = 0;
$response["message"] = "No user found.";
// echo no users JSON
echo json_encode($response);
}
}else if (isset($_GET["fullname"],$_GET["phoneno"],$_GET["emailid"],$_GET["orgid"],$_GET["branchid"],$_GET["indid"])) {
$name = $_GET['fullname'];
$phoneno = $_GET['phoneno'];
$emailid = $_GET['emailid'];
$orgID = $_GET['orgid'];
$branchId = $_GET['branchid'];
$indId = $_GET['indid'];
$password = md5("123456789");
$status = '1';
$date = date('Y-m-d H:i:s');
$uniq = rand(1,1000);
$unqId = 'END_'.$uniq;
$usertype = 'End_user';
// get a deptId from beatle_industry table
$result = mysql_query("SELECT * FROM beatle_userlogin WHERE db_phone LIKE '$phoneno' or db_email LIKE '$emailid'")or die(mysql_error());
//$result2 = mysql_query("SELECT * FROM beatle_userlogin WHERE db_userLoginName LIKE '$phoneno' AND db_password LIKE '$pass'")or die(mysql_error());
// check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$userDetail = array();
$userDetail["userid"] = $result["userId"];
$userDetail["db_email"] = $result["db_email"];
$userDetail["db_phone"] = $result["db_phone"];
$userDetail["userLoginName"] = $result["db_userLoginName"];
$userDetail["username"] = $result["db_username"];
$userDetail["password"] = $result["db_password"];
$userDetail["usertype"] = $result["db_usertype"];
$userDetail["orgID"] = $result["OrgID"];
$userDetail["branchID"] = $result["BranchID"];
$userDetail["industryID"] = $result["IndustryID"];
if($result["db_phone"] != $phoneno){
$response["success"] = 0;
$response["message"] = "you have entered wrong phone number.";
}elseif($result["db_email"] != $emailid){
if(empty($result["db_email"])){
$result = mysql_query("UPDATE beatle_userlogin SET db_email = '$emailid' WHERE userId = ".$result['userId']." ")or die(mysql_error());
$userDetail["db_email"] = $emailid;
$response["success"] = 1;
$response["message"] = "login successfully and your emailid has been registered.";
$response["userDetail"] = array();
array_push($response["userDetail"], $userDetail);
}else{
$response["success"] = 0;
$response["message"] = "you have entered wrong email id.";
}
}else{
$response["success"] = 1;
$response["message"] = "login successfully.";
$response["userDetail"] = array();
array_push($response["userDetail"], $userDetail);
}
// echoing JSON response
echo json_encode($response);
} else {
$result = mysql_query("INSERT INTO beatle_userlogin(db_userRandId,db_pagepermistion,db_username,db_userLoginName,db_email,db_phone, db_password, db_valid, db_valid_from, created_date, updated_date, webprofileimage, db_usertype, BranchID, IndustryID, OrgID, db_city, db_state, db_pincode) VALUES('$unqId','','$name','','$emailid', '$phoneno', '$password', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '$date', '0000-00-00 00:00:00', '', '$usertype', '$branchId', '$indId', '$orgID', '0', '0', '0')")or die(mysql_error());
// check if row inserted or not
if ($result) {
// successfully inserted into database
$last_id = mysql_insert_id();
$rs = mysql_query("SELECT * FROM beatle_userlogin WHERE userId LIKE '$last_id'")or die(mysql_error());
if (mysql_num_rows($rs) > 0) {
$result = mysql_fetch_array($rs);
$userDetail = array();
$userDetail["userid"] = $result["userId"];
$userDetail["db_email"] = $result["db_email"];
$userDetail["db_phone"] = $result["db_phone"];
$userDetail["userLoginName"] = $result["db_userLoginName"];
$userDetail["username"] = $result["db_username"];
$userDetail["password"] = $result["db_password"];
$userDetail["usertype"] = $result["db_usertype"];
$userDetail["orgID"] = $result["OrgID"];
$userDetail["branchID"] = $result["BranchID"];
$userDetail["industryID"] = $result["IndustryID"];
}
$response["success"] = 1;
$response["message"] = "user successfully created.";
$response["userDetail"] = array();
array_push($response["userDetail"], $userDetail);
// 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 if (isset($_GET["user_id"])) {
$user_id = $_GET['user_id'];
// get a deptId from beatle_industry table
$result = mysql_query("SELECT * FROM beatle_userlogin WHERE userId LIKE '$user_id' ")or die(mysql_error());
if (!empty($result)) {
// check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$city = '';
$state ='';
$rescity = mysql_query("SELECT name FROM cities WHERE id LIKE ".$result["db_city"]." ")or die(mysql_error());
if (!empty($rescity)) {
$row = mysql_fetch_row($rescity);
$test = $row[0];
$city = $test;
}
$restate = mysql_query("SELECT name FROM states WHERE id LIKE ".$result["db_state"]." ")or die(mysql_error());
if (!empty($restate)) {
$row = mysql_fetch_row($restate);
$test = $row[0];
$state = $test;
}
$userDetail = array();
$userDetail["userid"] = $result["userId"];
$userDetail["username"] = $result["db_username"];
$userDetail["userLoginName"] = $result["db_userLoginName"];
$userDetail["password"] = $result["db_password"];
$userDetail["usertype"] = $result["db_usertype"];
$userDetail["orgID"] = $result["OrgID"];
$userDetail["branchID"] = $result["BranchID"];
$userDetail["industryID"] = $result["IndustryID"];
$userDetail["db_phone"] = $result["db_phone"];
$userDetail["email"] = $result["db_email"];
$userDetail["address"] = $result["db_address"];
$userDetail["pincode"] = $result["db_pincode"];
$userDetail["city"] = $city;
$userDetail["state"] = $state;
// success
$response["success"] = 1;
// user node
$response["userDetail"] = array();
array_push($response["userDetail"], $userDetail);
// echoing JSON response
echo json_encode($response);
} else {
// no industry found
$response["success"] = 0;
$response["message"] = "No user found...";
// echo no users JSON
echo json_encode($response);
}
} else {
// no industry found
$response["success"] = 0;
$response["message"] = "No user 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 fetchIndType($indTypeid){
$SQL = "SELECT name FROM beatle_industry_type WHERE indtypeid = ".$indTypeid;
$row1 = mysql_fetch_array(mysql_query($SQL));
return $row1['name'];
}
?>