<?
include("admin/classes/initial.php");
include("admin/classes/secure-user.php");
include("admin/classes/config.php");
include("admin/classes/functions.php");
include("admin/classes/verifyemail.php");


$id = trim($_REQUEST['id']);
if ($id=="") die("Invalid trace");
if (!is_numeric($id)) die("Invalid trace");


if ($_REQUEST['action']=="followme") {
    $chksql = "select FollowId from companyfollowers where CompanyId='".$id."' and FollowerId ='".$_SESSION['MASTER_ID']."'";
    $chkrsq = mysqli_query($con,$chksql);
    if (mysqli_num_rows($chkrsq)==0) { 
        $sql = "insert into companyfollowers set CompanyId='".$id."', FollowerId ='".$_SESSION['MASTER_ID']."', CreatedOn='".gmdate("Y-m-d H:i:s")."'";    
        if (!mysqli_query($con,$sql)) {
            $response = '{"status":"technical_error", "message":"Oops! We\'ve hit a technical glitch along the way."}';
            die($response);
        }else {
            $sql = "update companies set Followers = Followers + 1 where CompanyId='".mysqli_real_escape_string($con,$id)."'";
            mysqli_query($con,$sql);

            $sql = "select a.Company from companyfollowers a where a.CompanyId='".mysqli_real_escape_string($con,$id)."'";
            $rsq = mysqli_query($con,$sql);
            $rs = mysqli_fetch_assoc($rsq);
            $message = "You are now following " . $rs['Company'];
            $response = '{"status":"success", "message":"'.$message.'"}';
            die($response);
        }
    }else {
        $sql = "select a.Company from companyfollowers a where a.CompanyId='".mysqli_real_escape_string($con,$id)."'";
        $rsq = mysqli_query($con,$sql);
        $rs = mysqli_fetch_assoc($rsq);
        $message = "You are already following " . $rs['Company'];
        $response = '{"status":"success", "message":"'.$message.'"}';
        die($response);
    }

  
}

if ($_REQUEST['action']=="unfollow") {
    $chksql = "select FollowId from companyfollowers where CompanyId='".$id."' and FollowerId ='".$_SESSION['MASTER_ID']."'";
    $chkrsq = mysqli_query($con,$chksql);
    if (mysqli_num_rows($chkrsq)>0) {        
        $sql = "delete from companyfollowers where CompanyId='".$id."' and FollowerId ='".$_SESSION['MASTER_ID']."'";    
        if (!mysqli_query($con,$sql)) {
            $response = '{"status":"technical_error", "message":"Oops! We\'ve hit a technical glitch along the way."}';
            die($response);
        }else {
            $sql = "update companies set Followers = Followers - 1 where CompanyId='".mysqli_real_escape_string($con,$id)."'";
            mysqli_query($con,$sql);
            $sql = "select a.Company from companies a where a.CompanyId='".mysqli_real_escape_string($con,$id)."'";
            $rsq = mysqli_query($con,$sql);
            $rs = mysqli_fetch_assoc($rsq);
            $message = "You are not following " . $rs['Company'] . " now.";
            $response = '{"status":"success", "message":"'.$message.'"}';
            die($response);
        }
    }else {
        $response = '{"status":"technical_error", "message":"You are not following."}';
        die($response);
    }

  
}


//$sql = "select a.*,b.EmployeeStrength,c.Category,d.nicename from companies a join employeestrenths b on b.EmployeeStrengthId=a.EmployeeStrength join categories c on c.CategoryId=a.CategoryId join countries d on d.iso=a.CountryOfIncorporation where a.CompanyId='".mysqli_real_escape_string($con,$id)."'";

$sql = "select a.*,b.EmployeeStrength,c.Category from companies a join employeestrenths b on b.EmployeeStrengthId=a.EmployeeStrength join categories c on c.CategoryId=a.CategoryId where a.CompanyId='".mysqli_real_escape_string($con,$id)."'";

$rsq = mysqli_query($con,$sql);
if (mysqli_num_rows($rsq)==0) die("Invalid trace");
$rs = mysqli_fetch_assoc($rsq);

$ersq = mysqli_query($con,"select * from members where MemberId='".$rs['CreatedBy']."'");
if (mysqli_num_rows($ersq)==0) die("Invalid trace");
$ers = mysqli_fetch_assoc($ersq);

$irsq = mysqli_query($con,"select nicename from countries where iso='".$rs['CountryOfIncorporation']."'");
$irs = mysqli_fetch_assoc($irsq);
$CountryOfIncorporation = $irs['nicename'];


$frssql = "select FollowId from companyfollowers where CompanyId='".$id."' and FollowerId ='".$_SESSION['MASTER_ID']."'";
$frsq = mysqli_query($con,$frssql);
if (mysqli_num_rows($frsq)>0) {
    $following = 1;
}


?>

<!doctype html>
<html lang="en">
    <head>        
        <meta charset="utf-8" />
        <title> - PROJECT_TITLE</title>
        <link href="assets/libs/choices.js/public/assets/styles/choices.min.css" rel="stylesheet" type="text/css" />
        <link href="assets/libs/flatpickr/flatpickr.min.css" rel="stylesheet">
        <?include_once("includes/style.php");?>
        <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jquery-flexdatalist/2.3.0/jquery.flexdatalist.css" />
        <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.css"/>            
    </head>

    
    <body data-topbar="dark">

    <!-- <body data-layout="horizontal"> -->

        <!-- Begin page -->
        <div id="layout-wrapper">

            <?include_once("includes/header.php");?>

            <!-- ============================================================== -->
            <!-- Start right Content here -->
            <!-- ============================================================== -->
            <div class="main-content">

                <div class="page-content p-4">
                    <div class="container-fluid">

                        <div class="row">
                            <div class="col-xxl-3 col-lg-4">
                                <div class="card overflow_hidden">
                                    <div class="card-body p-0">
                                        <div class="user-profile-img">
                                            <img src="assets/images/pattern-bg.jpg" class="profile-img profile-foreground-img rounded-top" style="height: 120px;" alt="">
                                            
                                        </div>
                                        <!-- end user-profile-img -->
        
                                        <div class="mt-n5 position-relative">
                                            <div class="text-center mb-5">
                                                <? if ($rs['Logo']=="") { ?>
                                                    <div id="propic"><img src="assets/images/icon.png" alt="" class="avatar-xl rounded-circle img-thumbnail"></div>
                                                <? } else { ?>
                                                    <div id="propic"><img src="lib/logo/thumb/" alt="" class="avatar-xl rounded-circle img-thumbnail"></div>
                                                <? } ?>

                                                 <div class="mt-3">
                                                    <h4 class="mb-1 fw-bold text-black"></h4>                                                    
                                                </div>
                                                
                                                <div class="mt-3">
                                                    <div class="mb-1 text-muted">Created on: