<?php

	session_start();				
$flag=$_REQUEST['flag'];
include('../link/databaseconnection.php');
switch($flag)
{
	case 1:
	
error_reporting(0);
$referid=$_POST['referid'];
$refername=$_POST['refername'];
$uplineid=$_POST['uplineid'];
$uplinename=$_POST['uplinename'];
$distributor=$_POST['distributor'];
$address=$_POST['address'];
$pass=$_POST['pass'];
$mobile=$_POST['mobile'];
$email=$_POST['email'];
$nominee=$_POST['nominee'];
$app=$_POST['app'];
$dob=$_POST['dob'];
$naddress=$_POST['naddress'];
$relation=$_POST['relation'];
$gender=$_POST['gnd'];
$side=$_POST['side'];

$imgname=$_FILES['picture']['name'];
//echo"$imgname";
$size=$_FILES['picture']['size'];
//echo"$size";
$type=$_FILES['picture']['type'];
//echo"$type";
$tempname=$_FILES['picture']['tmp_name'];
//echo"$tempname";
$pathinfo=pathinfo($imgname,PATHINFO_EXTENSION);
  //echo"$pathinfo";
  if($pathinfo!=""|| $pathinfo!=null)
  {
	  $newimgname=time()."_".$distributor.".".$pathinfo;
	  //echo$newimgname;
  }
  else
  {
	  $newimgname="";
  }

$date=date("d-m-Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
$location="img/";

$size=$size/1024;

$sel3="select * from registration order by id desc";
$res3=mysqli_query($conn,$sel3);
$row3=mysqli_fetch_array($res3,MYSQLI_BOTH);
$identy1=$row3['identy'];
$idd3=$row3['id'];
$sel="select * from registration where app='$app' order by id desc";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$idd=$row['id'];

$id=$idd+1;
$mobile1=$row['mobile'];
$identy2='84'.$idd3;

			
//--------------------------------------------------------------------
				if($mobile1!=$mobile)
				{
					if($gender!="" and $side!="")
					{
				$ins="insert into  registration(identy,app,referid,refername,uplineid,uplinename,distributor,address,picture,mobile,email,naddress,relation,gender,datetime,dob,password,nominee,side) values('$identy2','$app','$referid','$refername','$uplineid','$uplinename','$distributor','$address','$newimgname','$mobile','$email','$naddress','$relation','$gender','$datetime','$dob','$pass','$nominee','$side')";
				if(mysqli_query($conn,$ins))
				{
					move_uploaded_file($tempname,$location.$newimgname);
			
                        $to=$mobile;
$message='Welcome in SARKMART , Your identification Id '  ."$identy2". "and     password is" .  "$password". 
"Regards 
SARKMART";

$msg=urlencode($message);


$api="http://bulksms.jupitersms.com/index.php/smsapi/httpapi/?uname=brkweb&password=india&sender=SARKMR&receiver=$to&route=TA&msgtype=1&sms=$msg";

$result=file_get_contents($api);

$to1='7521016460';
$message1='New Entry in SARKMART , His identification Id '  ."$identy2".  "and      password is" . "$password". 
"Regards 
SARKMART";

$msg1=urlencode($message1);


$api1="http://bulksms.jupitersms.com/index.php/smsapi/httpapi/?uname=brkweb&password=india&sender=SARKMR&receiver=$to1&route=TA&msgtype=1&sms=$msg1";

$result1=file_get_contents($api1);
					
					
					echo"Submit";
					
					
				}
				else
				{
					echo"not insert";
				}
				}
				else
				{
					echo"Gender or Side Required";
				}
				}
				else
				{
					echo"Mobile Exist Use another Mobile";
				}
				
//-------------------------------------------------------------
			
		
	
break;
case 2:
$email=$_POST['rowid'];
echo $email;

break;

case 3:
$up=$_REQUEST['id'];
//echo $up;
$sel="select * from  registration where identy='$up' ";
	$res=mysqli_query($conn,$sel);
	$row=mysqli_fetch_array($res,MYSQLI_BOTH);
	$dist=$row['distributor'];
	echo $dist;

break;
//refer id 
case 4:
$refer=$_REQUEST['id'];
//echo $refer;
$sel="select * from  registration where identy='$refer' ";
	$res=mysqli_query($conn,$sel);
	$row=mysqli_fetch_array($res,MYSQLI_BOTH);
	$dist=$row['distributor'];
	echo $dist;

break;
case 5:
$left=$_POST['left'];
$identy=$_POST['rowid'];
//echo $left;
//echo $identy;
$sel="select * from  registration where uplineid='$identy' and side='$left' ";
	$res=mysqli_query($conn,$sel);
	$row=mysqli_fetch_array($res,MYSQLI_BOTH);
	$lef=$row['side'];
	if($lef==$left)
	{
		echo "Left side Already Attached";
	}
	else
	{
		echo "Left side Empty";
	}

break;

case 6:
$right=$_POST['right'];
$identy=$_POST['rowid'];
//echo $right;
//echo $identy;
$sel="select * from  registration where uplineid='$identy' and side='$right' ";
	$res=mysqli_query($conn,$sel);
	$row=mysqli_fetch_array($res,MYSQLI_BOTH);
	$righ=$row['side'];
	if($righ==$right)
	{
		echo "Right side Already Attached";
	}
	else
	{
		echo "Right side Empty";
	}

break;

case 8:

$name=$_POST['name'];
$acount=$_POST['acn'];
$acountname=$_POST['acname'];

$branch=$_POST['branch'];
$ifc=$_POST['ifc'];
$dis=$_POST['dis'];

$ins="insert into  account(name,acname,disnu,acn,branch,ifc) values('$name','$acountname','$dis','$acount','$branch','$ifc')";
				if(mysqli_query($conn,$ins))
				{
					
					

					
					
					echo"Submit";
					
					
					
					
				}
				else
				{
					echo"not insert";
				}
break;

}

?>