<?php
ob_start();
session_start();
include 'conn.php';  

function selectPass()
  {
    if ($_SESSION['loginUser'] == 'admin@siimatechnologies.com')
    {  
    $selPass = executework("SELECT * FROM login WHERE mailId = '".$_SESSION['loginUser']."'");
      }  
      else{     
    $selPass = executework("SELECT * FROM userLogins WHERE mailId = '".$_SESSION['loginUser']."'");
      }  
    return $selPass;
  } 
function change_password()
  {  
    $pasChange = executework("UPDATE login set password ='".$_POST['newpassword']."', update_date='".date('Y-m-d')."' where id='".$_POST['id']."'");
    redirect('change_password.php?upd=1'); 
  }  

function addAdmin()
  {

    $selectUserMail = executework("SELECT * FROM userLogins where mailId = '".$_POST['mailId']."'"); 
     if(mysqli_num_rows($selectUserMail) > 0)
     { 
         redirect('addAdmin.php?mailIdSame=1');
     } 
     else
     {

    $insert = executework("INSERT INTO addAdmin(adminId,firstName,lastName,phoneNo,mailId,password,companyName,create_date)values('".$_POST['adminId']."','".$_POST['firstName']."','".$_POST['lastName']."','".$_POST['phoneNo']."','".$_POST['mailId']."','".$_POST['password']."','".$_POST['companyName']."','".date('Y-m-d H:i:s')."')");

      $insert2 = executework("INSERT INTO userLogins(adminId,status,create_date,mailId,password,type)
              values('".$_POST['adminId']."','1','".date('Y-m-d H:i:s')."','".$_POST['mailId']."','".$_POST['password']."','admin')");  
      redirect('addAdmin.php?succ=1');
    }
  }


function addPartner()
  {
    $selectUserMail = executework("SELECT * FROM userLogins where mailId = '".$_POST['mailId']."' || partnerId = '".$_POST['partnerId']."'"); 
     if(mysqli_num_rows($selectUserMail) > 0)
     { 
         redirect('addPartner.php?failed=1');
     } 
     else
     {

    $insert = executework("INSERT INTO addPartner(adminId,partnerId,firstName,lastName,phoneNo,mailId,password,status,create_date,companyName)values('1','".$_POST['partnerId']."','".$_POST['firstName']."','".$_POST['lastName']."','".$_POST['phoneNo']."','".$_POST['mailId']."','".$_POST['password']."','1','".date('Y-m-d H:i:s')."','".$_POST['companyName']."')");

      $insert2 = executework("INSERT INTO userLogins(adminId,partnerId,status,create_date,mailId,password,type)
              values('1','".$_POST['partnerId']."','1','".date('Y-m-d H:i:s')."','".$_POST['mailId']."','".$_POST['password']."','partner')");  
      redirect('addPartner.php?succ=1');
    }
  }
function selectAdminLimit()
  {
    $selAdmin = executework("SELECT * FROM addAdmin order by id desc LIMIT 1");
    return $selAdmin;
  }
function selectPartnerLimit()
  {
    $selPartner = executework("SELECT * FROM addPartner order by id desc LIMIT 1");
    return $selPartner;
  }
function select_addPartner()
  {
    $addPartner_select = executework("SELECT * FROM addPartner");
    return $addPartner_select;
  } 

function addPartnerData($editId){
    $addPartnerData = executework("SELECT * FROM addPartner where id ='".$editId."'");

   return $addPartnerData;
  }

function addUserData($editId){
    $addUserData = executework("SELECT * FROM addUser where id ='".$editId."'");

   return $addUserData;
  }
  function addInstance_edit($editId){
    $addInstance_edit = executework("SELECT * FROM addInstance where id ='".$editId."'"); 
   return $addInstance_edit;
  }
 

function addPartnerEdit(){   
     $select_edit_data = executework("UPDATE addPartner SET firstName = '".$_POST['firstName']."',lastName ='".$_POST['lastName']."',phoneNo = '".$_POST['phoneNo']."',mailId ='".$_POST['mailId']."',password = '".$_POST['password']."', status = '".$_POST['status']."', companyName = '".$_POST['companyName']."',update_date = '".date('Y-m-d')."' WHERE id = '".$_POST['edittId']."'");  

     $selectPartnerData = executework("UPDATE userLogins SET mailId ='".$_POST['mailId']."',password = '".$_POST['password']."', status = '".$_POST['status']."', update_date = '".date('Y-m-d')."' WHERE adminId = '".$_POST['adminId']."' and partnerId = '".$_POST['partnerId']."' and type = 'partner'");
    redirect('partnerReport.php?upd=1');
} 

function addUserEdit(){   
     $select_userData = executework("UPDATE addUser SET firstName = '".$_POST['firstName']."',lastName ='".$_POST['lastName']."',phoneNo = '".$_POST['phoneNo']."',mailId ='".$_POST['mailId']."',password = '".$_POST['password']."', status = '".$_POST['status']."' ,updated_date = '".date('Y-m-d')."' WHERE id = '".$_POST['edittId']."'"); 


     $selectuserData = executework("UPDATE userLogins SET mailId ='".$_POST['mailId']."',password = '".$_POST['password']."', status = '".$_POST['status']."', update_date = '".date('Y-m-d')."' WHERE adminId = '".$_POST['adminId']."' and partnerId = '".$_POST['partnerId']."' and userId = '".$_POST['userId']."' and type = 'user'");  

     $selectinstData = executework("UPDATE addInstance SET mailId ='".$_POST['mailId']."',loginPass = '".$_POST['password']."' WHERE adminId = '".$_POST['adminId']."' and partnerId = '".$_POST['partnerId']."' and userId = '".$_POST['userId']."'"); 

    redirect('userList.php?upd=1');
} 


function addInstanceAdmin()
  {   
    $dateofcreation = date("Y-m-d", strtotime($_POST['dateofcreation']));
    $instanceExpiryDate = date("Y-m-d", strtotime($_POST['instanceExpiryDate']));
    $billGeneratedDate = date("Y-m-d", strtotime($_POST['billGeneratedDate']));
    $tssExpiryDate = date("Y-m-d", strtotime($_POST['tssExpiryDate']));
    $selectInst = executework("SELECT * FROM addInstance where instanceId = '".$_POST['instanceId']."'"); 
     if(mysqli_num_rows($selectInst) > 0)
     {  
        redirect('addInstance.php?failed=1'); 
     } 
     else
     {
        if($_POST['partnerName'] != '' && $_POST['userId'] != '')
        {  
            $insert = executework("INSERT INTO addInstance(adminId,partnerId,instanceId,userId,companyName,dateofcreation,instanceExpiryDate,instancePeriod,totalUsers,activeUsers,ratePerUser,cloudId,totalDue,billGeneratedDate,amountPaidDetails,UPILink,tallyLicenseSlNo,tallyVersion,tallyRelease,tallyDotNetId,tallyDotNetPassword,tssExpiryDate,contactPersonName,mobileNo,serverIp,port,rdpLoginId,password,filezillaId,password1,status,create_date,mailId,loginPass)values('1','".$_POST['partnerName']."','".$_POST['instanceId']."','".$_POST['userId']."','".$_POST['companyName']."','$dateofcreation','$instanceExpiryDate','".$_POST['instancePeriod']."','".$_POST['totalUsers']."','".$_POST['activeUsers']."','".$_POST['ratePerUser']."','".$_POST['cloudId']."','".$_POST['totalDue']."','$billGeneratedDate','".$_POST['amountPaidDetails']."','".$_POST['UPILink']."','".$_POST['tallyLicenseSlNo']."','".$_POST['tallyVersion']."','".$_POST['tallyRelease']."','".$_POST['tallyDotNetId']."','".$_POST['tallyDotNetPassword']."','$tssExpiryDate','".$_POST['contactPersonName']."','".$_POST['mobileNo']."','".$_POST['serverIp']."','".$_POST['port']."','".$_POST['rdpLoginId']."','".$_POST['password']."','".$_POST['filezillaId']."','".$_POST['password1']."','1','".date('Y-m-d H:i:s')."','".$_POST['emailId']."','".$_POST['loginPass']."')"); 
              
              redirect('addInstance.php?succ=1'); 
         }
     } 
  }
  function addInstancePartner()
  {   
    $dateofcreation = date("Y-m-d", strtotime($_POST['dateofcreation']));
    $instanceExpiryDate = date("Y-m-d", strtotime($_POST['instanceExpiryDate']));
    $billGeneratedDate = date("Y-m-d", strtotime($_POST['billGeneratedDate']));
    $tssExpiryDate = date("Y-m-d", strtotime($_POST['tssExpiryDate']));
    $selectInst = executework("SELECT * FROM addInstance where instanceId = '".$_POST['instanceId']."'"); 
     if(mysqli_num_rows($selectInst) > 0)
     {  
        redirect('addInstance.php?failed=1'); 
     } 
     else
     {
        if($_POST['partnerName'] != '' && $_POST['userId'] != '')
        {  
            $insert = executework("INSERT INTO addInstance(adminId,partnerId,instanceId,userId,companyName,dateofcreation,instanceExpiryDate,instancePeriod,totalUsers,activeUsers,cloudId,UPILink,tallyLicenseSlNo,tallyVersion,tallyRelease,tallyDotNetId,tallyDotNetPassword,tssExpiryDate,contactPersonName,mobileNo,rdpLoginId,password,filezillaId,password1,status,create_date,mailId,loginPass)values('1','".$_POST['partnerName']."','".$_POST['instanceId']."','".$_POST['userId']."','".$_POST['companyName']."','$dateofcreation','$instanceExpiryDate','".$_POST['instancePeriod']."','".$_POST['totalUsers']."','".$_POST['activeUsers']."','".$_POST['cloudId']."','".$_POST['UPILink']."','".$_POST['tallyLicenseSlNo']."','".$_POST['tallyVersion']."','".$_POST['tallyRelease']."','".$_POST['tallyDotNetId']."','".$_POST['tallyDotNetPassword']."','$tssExpiryDate','".$_POST['contactPersonName']."','".$_POST['mobileNo']."','".$_POST['rdpLoginId']."','".$_POST['password']."','".$_POST['filezillaId']."','".$_POST['password1']."','1','".date('Y-m-d H:i:s')."','".$_POST['emailId']."','".$_POST['loginPass']."')");  
              redirect('addInstance.php?succ=1'); 
         }
     } 
  } 

  function addInstanceUpdateUserEnd()
  { 
    $dateofcreation = date("Y-m-d", strtotime($_POST['dateofcreation']));
    $instanceExpiryDate = date("Y-m-d", strtotime($_POST['instanceExpiryDate'])); 

     $select_edit_data = executework("UPDATE addInstance SET companyName = '".$_POST['companyName']."', dateofcreation = '$dateofcreation', instancePeriod = '".$_POST['instancePeriod']."', instanceExpiryDate = '$instanceExpiryDate',totalUsers = '".$_POST['totalUsers']."',activeUsers = '".$_POST['activeUsers']."', tallyLicenseSlNo = '".$_POST['tallyLicenseSlNo']."',tallyVersion = '".$_POST['tallyVersion']."', tallyRelease = '".$_POST['tallyRelease']."', tallyDotNetId = '".$_POST['tallyDotNetId']."', tallyDotNetPassword = '".$_POST['tallyDotNetPassword']."', update_date = '".date('Y-m-d H:i:s')."' WHERE id = '".$_POST['editId']."'");
    redirect('addInstance.php?update=1'); 
} 

function selectInstanceLimit()
  {
   $seladdInstance = executework("SELECT * FROM addInstance order by id desc LIMIT 1");
   return $seladdInstance;
  }
function select_addInstance()
  { 
    $addInstance_select = executework("SELECT * FROM addInstance"); 
    return $addInstance_select; 
  } 

 
// function select_Log()
//   {
//     $loginHistory = executework("SELECT * FROM loginHistory where logouTime != '0000-00-00 00:00:00'");
//     return $loginHistory;
//   }

function selectUserLimit()
  {
    $selUser = executework("SELECT * FROM addUser order by id desc LIMIT 1");
    return $selUser;
  }

function addUser()
  { 

    $selectUserMail = executework("SELECT * FROM userLogins where mailId = '".$_POST['mailId']."' || userId = '".$_POST['userId']."'"); 
     if(mysqli_num_rows($selectUserMail) > 0)
     { 
         redirect('addUser.php?failed=1');
     } 
     else
     {

    $insert = executework("INSERT INTO addUser(adminId,userId,partnerId,firstName,lastName,phoneNo,mailId,password,status,create_date)values('1','".$_POST['userId']."','".$_POST['partnerName']."','".$_POST['firstName']."','".$_POST['lastName']."','".$_POST['phoneNo']."','".$_POST['mailId']."','".$_POST['password']."','1','".date('Y-m-d H:i:s')."')"); 
    $insert2 = executework("INSERT INTO userLogins(adminId,userId,partnerId,mailId,password,status,type,create_date)values('1','".$_POST['userId']."','".$_POST['partnerName']."','".$_POST['mailId']."','".$_POST['password']."','1','user','".date('Y-m-d H:i:s')."')");
      redirect('addUser.php?succ=1');
    }
  }
function selectProfile()
 {
    $selProfile = executework("SELECT * FROM addUser WHERE mailId = '".$_SESSION['loginUser']."' ");
    return $selProfile; 
 }

function selAddIns()
 {
    $selAddIns = executework("SELECT * FROM addInstance WHERE mailId = '".$_SESSION['loginUser']."' ");
    return $selAddIns; 
 }

 function selSubUserIns()
 {
    $selSubUserIns = executework("SELECT * FROM addSubUser WHERE mailId = '".$_SESSION['loginUser']."' ");
    
    return $selSubUserIns; 
 }



 function profile()
 {
 	if ($_SESSION['loginUser'] == 'admin@siimatechnologies.com')
    {  
    $selProf = executework("SELECT * FROM login WHERE mailId = '".$_SESSION['loginUser']."'");
      }  else {
    $selProf = executework("SELECT * FROM userLogins WHERE mailId = '".$_SESSION['loginUser']."'");

      }
      return $selProf;

    }
 

function addSubUser()
  { 
    $selectUserMail = executework("SELECT * FROM userLogins where mailId = '".$_POST['mailId']."'"); 
     if(mysqli_num_rows($selectUserMail) > 0)
     { 
         redirect('addInstance.php?mailIdSame=1');
     } 
     else
     {

    $addSubUserInsert = executework("INSERT INTO addSubUser(firstName,lastName,phoneNo,create_date,mailId,password,userId,partnerId,adminId,instanceId)values('".$_POST['firstName']."','".$_POST['lastName']."','".$_POST['phoneNo']."','".date('Y-m-d H:i:s')."','".$_POST['mailId']."','".$_POST['password']."','".$_POST['userId']."','".$_POST['partnerId']."','".$_POST['adminId']."','".$_POST['instanceId']."')");

    $addSubUserUserLog = executework("INSERT INTO userLogins(type,status,create_date,mailId,password,userId,partnerId,adminId,instanceId)values('subuser','1','".date('Y-m-d H:i:s')."','".$_POST['mailId']."','".$_POST['password']."','".$_POST['userId']."','".$_POST['partnerId']."','".$_POST['adminId']."','".$_POST['instanceId']."')"); 
}

    redirect('index.php?subUserStored=1'); 
  }

  function addinstanceAdminUpdateData()
  {
    $update_instance = executework("UPDATE addInstance SET companyName = '".$_POST['companyName']."',dateofcreation = '".date('Y-m-d',strtotime($_POST['dateofcreation']))."',instancePeriod = '".$_POST['instancePeriod']."',instanceExpiryDate = '".date('Y-m-d',strtotime($_POST['instanceExpiryDate']))."',totalUsers = '".$_POST['totalUsers']."',activeUsers = '".$_POST['activeUsers']."',ratePerUser = '".$_POST['ratePerUser']."',cloudId = '".$_POST['cloudId']."',totalDue = '".$_POST['totalDue']."',billGeneratedDate = '".date('Y-m-d',strtotime($_POST['billGeneratedDate']))."',amountPaidDetails = '".$_POST['amountPaidDetails']."',UPILink = '".$_POST['UPILink']."',tallyLicenseSlNo = '".$_POST['tallyLicenseSlNo']."',tallyVersion = '".$_POST['tallyVersion']."',tallyRelease = '".$_POST['tallyRelease']."',tallyDotNetId = '".$_POST['tallyDotNetId']."',tallyDotNetPassword = '".$_POST['tallyDotNetPassword']."',tssExpiryDate = '".date('Y-m-d',strtotime($_POST['tssExpiryDate']))."',contactPersonName = '".$_POST['contactPersonName']."',mobileNo = '".$_POST['mobileNo']."',mailId = '".$_POST['emailId']."',loginPass = '".$_POST['loginPass']."',serverIp = '".$_POST['serverIp']."',port = '".$_POST['port']."',rdpLoginId = '".$_POST['rdpLoginId']."',password = '".$_POST['password']."',filezillaId = '".$_POST['filezillaId']."',password1 = '".$_POST['password1']."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id = '".$_POST['edit_data']."'");  

      redirect('instance.php?updated=1');
  } 



  function addinstancePartnerUpdateData()
  {

    $update_instance1 = executework("UPDATE addInstance SET companyName = '".$_POST['companyName']."',dateofcreation = '".date('Y-m-d',strtotime($_POST['dateofcreation']))."',instancePeriod = '".$_POST['instancePeriod']."', instanceExpiryDate = '".date('Y-m-d',strtotime($_POST['instanceExpiryDate']))."',totalUsers = '".$_POST['totalUsers']."',activeUsers = '".$_POST['activeUsers']."',cloudId = '".$_POST['cloudId']."',tallyLicenseSlNo = '".$_POST['tallyLicenseSlNo']."',tallyVersion = '".$_POST['tallyVersion']."',tallyRelease = '".$_POST['tallyRelease']."',tallyDotNetId = '".$_POST['tallyDotNetId']."',tallyDotNetPassword = '".$_POST['tallyDotNetPassword']."',tssExpiryDate = '".date('Y-m-d',strtotime($_POST['tssExpiryDate']))."',contactPersonName = '".$_POST['contactPersonName']."',mobileNo = '".$_POST['mobileNo']."',mailId = '".$_POST['emailId']."',loginPass = '".$_POST['loginPass']."',status = '".$_POST['status']."',update_date = '".date('Y-m-d H:i:s')."' where id = '".$_POST['edit_data']."'");
      redirect('instance.php?updated=1');
  } 




    function addinstanceUserUpdateData()
  {
    $dateofcreation = date("Y-m-d", strtotime($_POST['dateofcreation']));
    $instanceExpiryDate = date("Y-m-d", strtotime($_POST['instanceExpiryDate'])); 

    $update_instance2 = executework("UPDATE addInstance SET companyName = '".$_POST['companyName']."',dateofcreation = '$dateofcreation',instancePeriod = '".$_POST['instancePeriod']."',instanceExpiryDate = '$instanceExpiryDate',totalUsers = '".$_POST['totalUsers']."',activeUsers = '".$_POST['activeUsers']."',tallyLicenseSlNo = '".$_POST['tallyLicenseSlNo']."',tallyVersion = '".$_POST['tallyVersion']."',tallyRelease = '".$_POST['tallyRelease']."',tallyDotNetId = '".$_POST['tallyDotNetId']."',tallyDotNetPassword = '".$_POST['tallyDotNetPassword']."',tssExpiryDate = '".date('Y-m-d',strtotime($_POST['tssExpiryDate']))."',contactPersonName = '".$_POST['contactPersonName']."',mobileNo = '".$_POST['mobileNo']."',mailId = '".$_POST['emailId']."',update_date = '".date('Y-m-d H:i:s')."' where id = '".$_POST['edit_data2']."'");
      redirect('index.php?updated=1');
  }