File: /home/barbeatleanalyti/public_html/manage.beatleanalytics.com/site/include/addattendant.php
<?php
/* <summary>
Class contains methods related to state module
<author>
Beatle Buddy 2017.
</author>
Version 1.0
</summary>
*/
class include_addattendant
{
/*
<summary>
Default constructor
</summary>
*/
function __CONSTRUCT(){
}
// Method to fetch all user info.
public function FetchAttendentData(){
global $objDB;
$SQL = "SELECT * FROM beatle_userlogin WHERE ";
if(!empty($this->UserID)){
$SQL .= " `userId` = ".$this->UserID." and lower(db_usertype) = 'attendent' ";
}else{
$SQL .= " lower(db_usertype) = 'attendent' ";
}
$rsAttendentInfo = $objDB->sql_query($SQL);
return $rsAttendentInfo;
}
public function fetchOrganization(){
global $objDB;
//$SQL = "SELECT OrgID,BranchID,IndustryID FROM beatle_userlogin WHERE 1 = 1 AND lower(db_usertype) = '".strtolower($_SESSION['UserInfo']['UType'])."' AND userId = ".$_SESSION['UserInfo']['UserID'];
//$rsOrg = $objDB->sql_query($SQL);
$SQL = "SELECT OrgId,db_Orgname FROM beatle_organization WHERE OrgId = ".$_SESSION['OtherInfo']['OrgID'];
$rsOrgInfo = $objDB->sql_query($SQL);
return $rsOrgInfo;
}
public function fetchBranches(){
global $objDB;
$SQL = "SELECT db_branchName,branchId FROM beatle_branch WHERE db_branchOrg = ".$_SESSION['OtherInfo']['OrgID'];
$rsBranches = $objDB->sql_query($SQL);
return $rsBranches;
}
public function fetchIndustrys($BranchID){
global $objDB;
/*if(!empty($OrgID)) {
$SQL = "SELECT * FROM beatle_industry WHERE db_bracnchid IN (SELECT GROUP_CONCAT(branchId) FROM beatle_branch WHERE db_branchOrg = ".$OrgID.")";
$rsBranches = $objDB->sql_query($SQL);
}else {
$SQL = "SELECT * FROM beatle_industry WHERE db_bracnchid IN (SELECT GROUP_CONCAT(branchId) FROM beatle_branch WHERE db_branchOrg = ".$_SESSION['OtherInfo']['OrgID'].")";
$rsBranches = $objDB->sql_query($SQL);
}*/
$SQL = "SELECT * FROM beatle_industry WHERE db_bracnchid = ".$BranchID;
$rsBranches = $objDB->sql_query($SQL);
return $rsBranches;
}
public function FetchOrganizationName($id){
global $objDB;
$SQL = "SELECT db_Orgname FROM beatle_organization WHERE OrgId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_Orgname'];
}
public function FetchBranchName($id){
global $objDB;
$SQL = "SELECT db_branchName FROM beatle_branch WHERE branchId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_branchName'];
}
public function FetchIndustryName($id){
global $objDB;
$SQL = "SELECT db_industry FROM beatle_industry WHERE IndId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_industry'];
}
public function SelectPageContentName($id){
global $objDB;
$SQL = "SELECT db_pageConTitle FROM beatle_pagecontent WHERE pageConId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_pageConTitle'];
}
public function SelectPageName($id){
global $objDB;
$SQL = "SELECT db_pagename FROM beatle_page WHERE pageId = ".$id;
$rsOwnerInfo = $objDB->sql_query($SQL);
return $rsOwnerInfo[0]['db_pagename'];
}
public function fetchStateName($sid){
global $objDB;
$SQL = "SELECT name from states WHERE id = ".$sid;
$rsData = $objDB->sql_query($SQL);;
return $rsData[0]['name'];
}
public function fetchCityName($sid){
global $objDB;
$SQL = "SELECT name from cities WHERE id = ".$sid;
$rsData = $objDB->sql_query($SQL);;
return $rsData[0]['name'];
}
public function setAttendentData(){
global $objDB;
$_REQUEST['acn'] = 'FetchAttendentData';
/*ReturnPostFormData($_REQUEST,"addattendant.html","User name allready taken, please try agin with different user name ! ",1);
exit;*/
$SQL = "SELECT * FROM beatle_userlogin WHERE db_userLoginName = '".$_POST['username']."'";
$result = $objDB->sql_query($SQL);
if(count($result) > 0){
ReturnPostFormData($_REQUEST,"addattendant.html","User name already taken, please try again with different user name ! ",1);
exit;
}
$SQL = "SELECT * FROM beatle_userlogin WHERE db_phone = '".$_POST['contact_number']."'";
$result = $objDB->sql_query($SQL);
if(count($result) > 0){
ReturnPostFormData($_REQUEST,"addattendant.html","Phone no. already taken, please try again with different phone no ! ",1);
exit;
}
if(!empty($_POST['email'])) {
$SQL = "SELECT * FROM beatle_userlogin WHERE db_email = '".$_POST['email']."'";
$result = $objDB->sql_query($SQL);
if(count($result) > 0){
ReturnPostFormData($_REQUEST,"addattendant.html","Email already taken, please try again with different email id ! ",1);
exit;
}
}
$status = '1';
$date = date('Y-m-d H:i:s');
$uniq = rand(1,1000);
$unqId = 'ATD_'.$uniq;
$password = md5('123456789');
$SQL = "INSERT into beatle_userlogin (db_userRandId,db_pagepermistion,db_username,db_userLoginName,db_password,db_phone,db_email,db_status,db_usertype,db_valid_from,db_valid,updated_date,created_date,webprofileimage,OrgID,BranchID,IndustryID) values (
'".$unqId."',
'',
'".$_POST['name']."',
'".$_POST['username']."',
'".$password."',
'".$_POST['contact_number']."',
'".$_POST['email']."',
'".$status."',
'attendent',
'0000-00-00 00:00:00',
'0000-00-00 00:00:00',
'0000-00-00 00:00:00',
'".$date."',
'".$_POST['profilename']."',
'".$_POST['user_orgid']."',
'".$_POST['user_branch']."',
'".$_POST['user_ind']."')";
$atData = $objDB->sql_query($SQL);
if(count($atData) > 0){
unset($_REQUEST['acn']);
unset($_REQUEST['v']);
ReturnPostFormData($_REQUEST,"addattendant.html","Attendent data submitted successfuly.",0);
exit;
}else{
ReturnPostFormData($_REQUEST,"addattendant.html","Here is something wrong to update data.",1);
exit;
}
}
public function updateAttendentData(){
global $objDB;
$_REQUEST['acn'] = 'FetchAttendentData';
//ReturnPostFormData($_REQUEST,"addattendant.html","update attendent data ! ",1);
//exit;
//echo("id ".$_SESSION['AtteInfo']['UserID']);die();exit();
$SQL = "SELECT * FROM beatle_userlogin WHERE db_userLoginName = '".$_POST['username']."'";
if(!empty($_SESSION['AtteInfo']['UserID'])){
$SQL .= " and `userId` <> ".$_SESSION['AtteInfo']['UserID']."";
}
$result = $objDB->sql_query($SQL);
if(count($result) > 0){
ReturnPostFormData($_REQUEST,"addattendant.html","User name already taken, please try again with different user name ! ",1);
exit;
}
$SQL = "SELECT * FROM beatle_userlogin WHERE db_phone = '".$_POST['contact_number']."'";
if(!empty($_SESSION['AtteInfo']['UserID'])){
$SQL .= " and `userId` <> ".$_SESSION['AtteInfo']['UserID']."";
}
$result = $objDB->sql_query($SQL);
if(count($result) > 0){
ReturnPostFormData($_REQUEST,"addattendant.html","Phone no. already taken, please try again with different phone no ! ",1);
exit;
}
if(!empty($_POST['email'])) {
$SQL = "SELECT * FROM beatle_userlogin WHERE db_email = '".$_POST['email']."'";
if(!empty($_SESSION['AtteInfo']['UserID'])){
$SQL .= " and `userId` <> ".$_SESSION['AtteInfo']['UserID']."";
}
$result = $objDB->sql_query($SQL);
if(count($result) > 0){
ReturnPostFormData($_REQUEST,"addattendant.html","Email already taken, please try again with different email id ! ",1);
exit;
}
}
$status = '1';
$date = date('Y-m-d H:i:s');
$SQL = "UPDATE beatle_userlogin
set db_username = '".$_POST['name']."',
db_userLoginName = '".$_POST['username']."',
db_phone = '".$_POST['contact_number']."',
db_email = '".$_POST['email']."',
updated_date = '".$date."',
webprofileimage = '".$_POST['profilename']."',
OrgID = '".$_POST['user_orgid']."',
BranchID = '".$_POST['user_branch']."',
IndustryID = '".$_POST['user_ind']."' where userId = ".$_SESSION['AtteInfo']['UserID']." ";
$atData = $objDB->sql_query($SQL);
if(count($atData) > 0){
unset($_REQUEST['acn']);
unset($_REQUEST['v']);
unset($_SESSION['AtteInfo']);
ReturnPostFormData($_REQUEST,"addattendant.html","Attendant data updated successfuly.",0);
exit;
}else{
ReturnPostFormData($_REQUEST,"addattendant.html","Here is something wrong to update data.",1);
exit;
}
}
public function FetchWebProfileImage(){
global $objDB;
$SQL = "SELECT webprofileimage FROM beatle_userlogin WHERE ";
if(!empty($this->UserID)){
$SQL .= " `userId` = ".$this->UserID." and lower(db_usertype) = 'attendent' ";
}else{
$SQL .= " userId = '0' ";
}
$rsProfile = $objDB->sql_query($SQL);
return $rsProfile[0]['webprofileimage'];
}
}
?>