<?php
function numOnly($str){
	return @preg_replace("/[^0-9]/", "", $str);
}
function makeUrl($url_str){
	return strtolower(trim(@preg_replace('/[\W]+/','-',$url_str),"-"));
}
function getBusinessType($btype){
	return getSingleResult("SELECT business_type FROM mstr_business_type where business_id='$btype'");
}
function getSubType($psubtype){
	return getSingleResult("SELECT subtype FROM mstr_subtype where subtype_id='$psubtype'");
}
function getProjectName($project_name){
	return getSingleResult("SELECT project_title FROM mstr_project where project_id='$project_name'");
}
function getProjectImage($project_name){
	return getSingleResult("SELECT project_logo FROM mstr_project where project_id='$project_name'");
}
function getBuilder($builder){
	return getSingleResult("SELECT builder_name FROM mstr_builder where builder_id='$builder'");
}
function getBuilderImage($builder){
	return getSingleResult("SELECT image_thumb FROM mstr_builder where builder_id='$builder'");
}
function getCity($city){
	return getSingleResult("SELECT city_name FROM mstr_city_state where city_id='$city'");
}
function getState($state){
	return getSingleResult("SELECT state_name FROM mstr_city_state where city_id='$state'");
}
function getPropertyLocation($property_location){
	return getSingleResult("SELECT location_name FROM mstr_location where location_id='$property_location'");
}
function getPropertyType($property_type){
	return getSingleResult("SELECT property_type FROM mstr_prop_type where type_id='$property_type'");
}
function getPrice($price){
	//return getSingleResult("SELECT price_range FROM mstr_price where price_id='$price'");
	return price2word($price);
}
function getUserName($user_id){
	if($user_id=="" && $user_id=="0")
		return "Site Guest";
	else
		return getSingleResult("SELECT user_name FROM mstr_user where user_id='$user_id'");
}
function getFloor($min,$max){
	$response="";
	if($min!=""){
		//if($min=="0") $response = "Ground";
		//else
			$response = $min;
	}
	if($max!=""){
		if($min!="") $response .= " - ";
		$response .= $max;
	}
	//if($min!="" || $max!="")
	//	$response = "Floor(".$response.")";
	return $response;
}

function getMinMaxPrice($min,$max){
	$response="";
	if($min!="")
		$response = price2word($min);
	if($max!=""){
		if($min!="") $response .= " - ";
		$response .= price2word($max);
	}
	return $response;
}

function getRoleName($role_name){
	return getSingleResult("SELECT role_name FROM mstr_role where role_id='$role_name'");
}
function getDeptName($dept_name){
	return getSingleResult("SELECT dept_name FROM mstr_dept where dept_id='$dept_name'");
}
function getDesiName($desi_name){
	return getSingleResult("SELECT desi_name FROM mstr_designation where desi_id='$desi_name'");
}

function getRoleByUser($user_id){
	$UserRole = getSingleResult("SELECT role_id FROM mstr_user where user_id='$user_id'");
	return getRoleName($UserRole);
}
function getRoleIdByUserId($user_id){
	$UserRoleId = getSingleResult("SELECT role_id FROM mstr_user where user_id='$user_id'");
	return $UserRoleId;
}
function getLeadStatus($value)
{
	$array = array('0' => 'Unassigned','1' => 'Assigned','2' => 'Interested','3' => 'Not Interested','4' => 'Follow UP','5' => 'Reassign','6' => 'Forwarded to Sales','7' => 'Meeting Scheduled','8' => 'No Response','9' => 'No Reachable','10' => 'Not Converted','11' => 'Converted','12' => 'Assign','13' => 'Assign','14'=>'New Lead');
    for ($i = 0; $i < count($array); $i++) {
    $key=key($array);
    $val=$array[$key];
    if ($key == $value ) {
       echo $val ." <br> ";
       }
     next($array);
    }
}
function getMeetingLoc($value)
{
	$array = array('1' => 'Client’s Office','2' => 'Client’s Residence','3' => 'Own Office','4' => 'Own residence','5' => 'On Site','5' => 'Coffee House');
    for ($i = 0; $i < count($array); $i++) {
    $key=key($array);
    $val=$array[$key];
    if ($key == $value ) {
       echo $val ." <br> ";
       }
     next($array);
    }
}
function getLeadBtnStatus($value)
{
	$array = array('0' => 'btn-primary','1' => 'btn-success','2' => 'btn-info','3' => 'btn-danger','4' => 'btn-warning','5' => 'btn-default','6' => 'btn-default','7' => 'btn-info','8' => 'btn-warning','9' => 'btn-warning','10' => 'btn-danger','11' => 'btn-primary','12' => 'btn-success');
    for ($i = 0; $i < count($array); $i++) {
    $key=key($array);
    $val=$array[$key];
    if ($key == $value ) {
       echo $val ." <br> ";
       }
     next($array);
    }
}
function getLeadHistoryStatus($value)
{
	$array = array('0' => 'primary','1' => 'success','2' => 'info','3' => 'danger','4' => 'warning','5' => 'default','6' => 'default','7' => 'info','8' => 'warning','9' => 'warning','10' => 'danger','11' => 'primary');
    for ($i = 0; $i < count($array); $i++) {
    $key=key($array);
    $val=$array[$key];
    if ($key == $value ) {
       echo $val ." <br> ";
       }
     next($array);
    }
}
function getUserName2($user_id){
	if($user_id=="" && $user_id=="0")
		return "Site Guest";
	else
		return getSingleResult("SELECT name FROM mstr_user where user_id='$user_id'");
}
function getActiveUser($user_id){
		return getSingleResult("SELECT COUNT(*) From mstr_user where status='Active' and company_id ='$user_id'");
}
function getLeadCode($lead_id){
	return getSingleResult("SELECT lead_code FROM mstr_leads where lead_id='$lead_id'");
}
function getTokenByUserid($user_id){
	return getSingleResult("SELECT tokenString FROM mstr_user where user_id='$$user_id'");
}
function getCompanyCode($company_id){
	return getSingleResult("SELECT client_id FROM mstr_company where company_id='$company_id'");
}
?>