<?php
include('dbconnect.php');
session_start();
$user=$_SESSION['clid'];
$perm=$_SESSION['cper'];
$mid=$_REQUEST['mid'];
$smid=$_REQUEST['smid'];
$pid=$_REQUEST['pid'];
$comp_name=$_SESSION['comp_name'];


//expload view
if($pid=="5_1_1")
{
$id=$_REQUEST['id'];
$sql="update etaapp_expview set status='N' where exp_id=".$id."";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//error code
if($pid=="5_1_2")
{
$id=$_REQUEST['id'];
$sql="update etaapp_errorcode set status='N' where error_id=".$id."";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//expload view
if($pid=="5_1_3")
{
$id=$_REQUEST['id'];
$sql="update etaapp_service set status='N' where sp_id=".$id."";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

// spec

if($pid=="5_1_7")
{
$id=$_REQUEST['id'];
$sql="update etaapp_spc set status='N' where sp_id=".$id."";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

// spec

if($pid=="5_1_8")
{
$id=$_REQUEST['id'];
$sql="update etaapp_agg set status='N' where agg_id=".$id."";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//Access Page Master
if($pid=="6_1_5")
{
$id=$_REQUEST['id'];
$sql="update serviceapp_pages set status='N' where page_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//User Creation
elseif($pid=="6_1_2")
{
$id=$_REQUEST['id'];
//$sql="update etaapp_login set status='Denied' where user_name='".$id."'";
$sql="update serviceapp_login set status='Denied' where user_name='".$id."'";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Access Level Creation
elseif($pid=="6_1_1")
{
$id=$_REQUEST['id'];
$sql="update serviceapp_levels set status='N' where level_name='".$id."'";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//Branch Master
elseif($pid=="7_1_1")
{
$id=$_REQUEST['id'];
$sql="update employee set EMP_UPDATE='2' where EMP_ID=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Branch Master
elseif($pid=="7_1_3")
{
$id=$_REQUEST['id'];
$sql="update area set AREA_UPDATE='2' where AREA_ID=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Technician Master
elseif($pid=="7_1_4")
{
$id=$_REQUEST['id'];
$sql="update model set status='2' where MODEL_ID=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Dealer Master
elseif($pid=="7_1_5")
{
$id=$_REQUEST['id'];
$sql="update make set status='2' where MAKE_ID=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//Tax Master
elseif($pid=="7_1_7")
{
$id=$_REQUEST['id'];
$sql="update serviceapp_tax set status='2' where tax_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}




//Customer Master
elseif($pid=="7_1_8")
{
$id=$_REQUEST['id'];
$sql="update etaapp_customers set status='N' where cust_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//symptom Master
elseif($pid=="7_1_10")
{
$id=$_REQUEST['id'];
$sql="update etaapp_symptom set status='N' where symptom_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//Dealer Type Master
elseif($pid=="7_1_12")
{
$id=$_REQUEST['id'];
$sql="update etaapp_dealertype set status='N' where dtype_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Item Master
elseif($pid=="7_1_13")
{
$id=$_REQUEST['id'];
//$sql="update etaapp_items set status='N' where item_id=".$id."";
$sql="update etaapp_sparemaster set status='N' where spare_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Zone Master
elseif($pid=="7_1_14")
{
$id=$_REQUEST['id'];
$sql="update etaapp_zone set status='N' where zone_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Location Master
elseif($pid=="7_1_15")
{
$id=$_REQUEST['id'];
$sql="update location_master set status='N' where loc_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//Company Master
elseif($pid=="7_1_16")
{
$id=$_REQUEST['id'];
$sql="update etaapp_company set status='N' where comp_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//Brand Name Creation
elseif($pid=="7_2_1")
{
$id=$_REQUEST['id'];
$sql="update etaapp_brand set status='N' where brand_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//Product Type Master
elseif($pid=="7_2_2")
{
$id=$_REQUEST['id'];
$sql="update etaapp_products set status='N' where product_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}
//model master

if($pid=="7_2_3")
{
$id=$_REQUEST['id'];
$sql="update  etaapp_compressormaster set status='N' where comp_id=".$id."";
//echo $sql;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}



//VRF Series Type Master
elseif($pid=="7_2_4")
{
$id=$_REQUEST['id'];
$sql="update etaapp_vrftypes set status='N' where vrf_srid=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}


//VRF idu model
elseif($pid=="7_3_4")
{
$id=$_REQUEST['id'];
$sql="update vrf_modelidukw set status='N' where vrf_iduid=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}




//Call registration
elseif($pid=="2_1_1")
{
$id=$_REQUEST['id'];
$sql="update etaapp_callreg set status='N' where reg_id=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:home.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

//Afx/sss Master

elseif($pid=="7_1_10")
{
$id=$_REQUEST['id'];
$sql="update serviceapp_apx set status='2' where apx_modelid=".$id."";
//echo $sqlt;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}

elseif($pid=="7_1_11")
{
$id=$_REQUEST['id'];
$time_now=time(date('h')+5,date('i')+30,date('s'));
$time=date('Y-m-d h:i:s',$time_now);


//echo $id; die;
$sql="update amc_model_list set status='N' where model_list_id=".$id."";
//echo $sql; die;
if(mysql_query($sql)==1)
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=5");
}
else
{
header("Location:landing.php?mid=$mid&smid=$smid&pid=$pid&nav=6");
}
}
?>