<?php 

function call_shipping($browsessionid){
if(isset($_SESSION['country'])){
	include("settings/db_ini.php");
	include '../include/conf.php';
 $_SESSION["userid"];

 /*if($_SESSION["userid"]=="")
 {
 header("location:login-cart.php");
 
 
 }*/
 $pundai=0;
 //header("location:checkout.php");
 //$sessionid_free=$_SESSION["userid"];
 
 $_SESSION["userid"];
 session_start();
 
  $sessionid_free_man=$_SESSION["mobile"];
  
  $ses_u_id=$_SESSION["mobile"];
   
  
  
    $ses_u_id="12358974444";
   
   $objqrynewsubee    = "SELECT * FROM shop_user where phone='$ses_u_id'";
 $objResultnewsubee    = mysql_query($objqrynewsubee);
 
 $rows_mal = mysql_num_rows($objResultnewsubee);
 $Fetchnewww        = mysql_fetch_array($objResultnewsubee);
 $gender=$Fetchnewww['gender'];
  $language=$Fetchnewww['language'];
   $dob=$Fetchnewww['dob'];
  $id_lang=$Fetchnewww['language'];
	   $country=$_SESSION["country"];
	   $state=$_SESSION["state"];
	   

 $new_pho=$_SESSION["mobile"];
?>

 <?php

$objitem    = mysql_query("SELECT * from shop_user where phone='$new_pho'");

 
$Fetitem      = mysql_fetch_array($objitem);

$cust_id=$Fetitem['user_id'];
$new_status=$Fetitem['new_status'];

$country=$_SESSION["country"];
$new_sataus=$Fetitem['new_status'];
  $new_state=$_SESSION["state"];
  
  $country=$_SESSION["country"];
$city=$Fetitem['city'];
$address=$Fetitem['address'];
$state=$_SESSION["state"];
$pin=$Fetitem['postcode'];
$new_sataus=$Fetitem['new_status'];
  $new_state=$_SESSION["state"];
  
   $dif_cuntry;
  if($dif_cuntry!='0' || $dif_cuntry!='')
  {  
 // $Updatecart_a	=	mysql_query("UPDATE  shop_cart SET `billing`='0',del_country='$country',del_city='$city',del_address='$address',del_state='$state',del_inp='$pin' where session_id='$browsessionid' ");
  
  }
  
  
  


							?>
							
							<?php
											
											if($rows_mal==0)
											{
											 $country=$_SESSION["country"];
											$state=$_SESSION["state"];
											$new_state=$_SESSION["state"];
											}
											else
											{
											}
											?>
					
							
							   
						 <?php 
						 
						 $objqrynewsubee    = "SELECT SUM(totprice) AS amtTotal FROM shop_cart where session_id='$browsessionid'";
 $objResultnewsubee    = mysql_query($objqrynewsubee);
 $Fetchnewww        = mysql_fetch_array($objResultnewsubee);
  
   $subtotal=$Fetchnewww['amtTotal'];
						 
						 $tx=   "Txn" . rand(10000,99999999);
$me_kay="iz3S9EJU";
$amount=$subtotal;
 $fname=$Fetitem['name'];
$pinfo=$Fetitem['name'];
$email=$Fetitem['email'];
$udf5="BOLT_KIT_PHP7";
$salt="BwgrLSotC7";


 $hash=hash('sha512', $me_kay.'|'.$me_kay.'|'.$amount.'|'.$pinfo.'|'.$fname.'|'.$email.'|||||'.$udf5.'||||||'.$salt);
						 
						 ?>	   
 
 <?php

 $_SESSION["userid"];
 session_start();
 /*if($_SESSION["userid"]=="")
 {
 header("location:index.php");
 }*/
 $sessionid_free=$_SESSION["userid"];
 
?>
<?php 
include_once('config.php');
?>



<?php

  $_SERVER['HTTP_HOST'];
 
 $view="/para/doctor-demo/";

$link = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 
                "https" : "http") . "://" . $_SERVER['HTTP_HOST'] .  
                $view; 
  
 $link; 
?>

  

  



							
							<?php
							
							$sessionid_free_man_mal=$_SESSION["mobile"];
							 $objitem    = mysql_query("SELECT * from shop_user where phone='$sessionid_free_man_mal'");

 
$Fetitem      = mysql_fetch_array($objitem);

$cust_id=$Fetitem['user_id'];

$country=$_SESSION["country"];


							?>
							
							<?php
											
											if($rows_mal==0)
											{
											 $country=$_SESSION["country"];
											$state=$_SESSION["state"];
											$new_state=$_SESSION["state"];
											}
											else
											{
											}
											?>
                            
							   
						
						 

 
 
 
							 			
											<?php


  $Query_sp_in = mysql_query("SELECT * from shop_country");

                                              

											    $num_max_job_sp_in=mysql_num_rows($Query_sp_in);

												

											    while ($name_j_sp_in = mysql_fetch_array($Query_sp_in)) {
												
												$cat_id=$name_j_sp_in['country_id'];
												
												
												$name_coun=$name_j_sp_in['name'];
 
 
 


												?>
											
                                                
												
												<?php
												}
												?>     
                                                
                                                

                                
                                       
                                        

                                       
                                        <?php if($country=="India")
											{
											?>
                                   
                                        <?php
											}else{
												?>
												
												
										<?php	}
												?>
                                     
                                            
											
                                         		
											<?php if($country=="India")
											{
											?>
										
									
                                        <?php


  $Query_sp_in = mysql_query("SELECT * from tbl_state     ");

                                              

											    $num_max_job_sp_in=mysql_num_rows($Query_sp_in);

												

											    while ($name_j_sp_in = mysql_fetch_array($Query_sp_in)) {
												
												$cat_id=$name_j_sp_in['id'];
												
												
												$name_sta=$name_j_sp_in['state'];
 
 
 $Query_job_move_courier= mysql_query("SELECT *  from tbl_courier_charges where state='$name_sta' ");
   

$row_job_move_courier= mysql_fetch_array($Query_job_move_courier);

 $courier_fees=$row_job_move_courier['amount'];
 $name_sta_1=$row_job_move_courier['state'];
 
 $packing_charges1=round((($subtotal*$pundai)/100));
 
 
  if($name_sta_1=="Puducherry")
   {
   $packing_charges1=0;
   }
   if($name_sta_1=="Tamilnadu")
   {
   $packing_charges1=0;
   }

if($name_sta_1=='')
{


 $Query_job_move_courier_1= mysql_query("SELECT *  from tbl_courier_charges where state='Others' ");
   

$row_job_move_courier_1= mysql_fetch_array($Query_job_move_courier_1);

$courier_fees=$row_job_move_courier_1['amount'];

$packing_charges1=round((($subtotal*$pundai)/100));

}
  $courier_fees;
  
  $courier_fees_1=(($courier_fees*$weight)+$packing_charges1);
  
  $new_subtotal=($courier_fees+$subtotal+$packing_charges1);
												
												$manufacturer_id
												?>


 
									
    
   <?php
                                        
									
									
								}
								
							
									
									?>
                                
									
									<?php
									}
									else
									{
									?>
									
								
									
									
									<?php
									}
									?>
                                    
										
										
										
										<?php
										if($country =='India'){
											?>
											

								<?php		}else{
											?>
												  
									<?php	}
										?>
										
                                     
										
													
							<?php
							
							$Query_jobmal = mysql_query("SELECT id  from shop_cart where session_id='$browsessionid' ");
			 
  

$qty=mysql_num_rows($Query_jobmal);

 $objqrynewsubee    = "SELECT SUM(totprice) AS amtTotal FROM shop_cart where session_id='$browsessionid'";
 $objResultnewsubee    = mysql_query($objqrynewsubee);
 $Fetchnewww        = mysql_fetch_array($objResultnewsubee);
 
   $subtotal=$Fetchnewww['amtTotal'];
   $dis_amount=0;
   
   ?>
   
  
                              
                                   		
											<?php
	
											
											
											
				$objitem    = mysql_query("SELECT * from shop_cart where session_id='$browsessionid'");
$i=1;
$j=1;
$si=0;
 $num_rows = mysql_num_rows($objitem);
 $totprice1=0;
 $new_price=0;
 $new_kilo_3=0;
 $tot_weight_2=0;
if($num_rows > 0)
{
while($Fetitem      = mysql_fetch_array($objitem))
{
$menuid=$Fetitem['id'];
$menuid_d_s=$Fetitem['productid'];
$si=$si+1;

 $qty=$Fetitem['qty'];

  
 


$objmenu=mysql_query("SELECT * from  shop_product where product_id='$menuid_d_s'");
$resmenu=mysql_fetch_array($objmenu);
$menuname=$resmenu['name'];
$productprice=$resmenu['price'];
$productprice_int=$resmenu['points'];
$totprice=($qty*$resmenu['price']);
$totprice_int=($qty*$resmenu['points']);

$new_price +=$totprice;
$country;

if($country=="India")
{
 

}
else
{
}


$vstatus=$resmenu['vstatus'];

 $weight=$resmenu['stock_status_id'];

										$vid_type = $resmenu['v_s'];
											   if($vid_type !=1){
												  if($weight=='' || $weight==0)
{
$weight=100;
} 
											   }
												   else{
													  
												 $weight = 0;  
											   }


if($new_status==1)
 {



 if($vstatus==1)
{

 $v_qty=($qty/2);
 
 }
 
 if($vstatus==6)
{

 $v_qty=($qty/2);
 
 }
 
 
 if($vstatus==7)
{

 $v_qty=($qty/2);
 
 }
 
 if($vstatus==2)
{

 $v_qty=($qty/4);
 
 }

  $x = (int)$v_qty;
  
  }
  
  else
  {
  $x=0;
  
  }
  $x;
 
   $new_qty=($weight*($qty+$x));

 $new_kilo=($new_qty/1000);
$new_kilo_1 = explode('.',$new_kilo);
 $new_kilo_2=$new_kilo_1[0];  // Before the Decimal point

 $new_kilo_3  +=$new_kilo_2;


$totprice1 +=$totprice;
$tot_weight_2 +=$new_qty;
$Query_job_move_product = mysql_query("SELECT *  from shop_product_image where product_id='$menuid_d_s' order by product_id asc ");
   

$row_job_move_product_id = mysql_fetch_array($Query_job_move_product);


?>
											
												
												
												
												<?php if($new_sataus==1)
												{
												?>
												
                             	   
							   <?php
							   
							   }
							   else
							   {
							   ?>
							  
							   
							    <?php if($country=="India")
													{
													?>
							 
							   
							   <?php
							   }
							   else
							   {
							   ?>
							   
						
							   
							   <?php
							   }
							   ?>
							   
							   
							   
							   
							   <?php
							   }
							   ?> 
                                                 





												
												
												<?php if($country=="India")
													{
													?>
												
													
												
													
													<?php  $totprice;?></strong></span>
													
													<?php
													}
													
													else
													{
													?>
													
													
													<?php  $totprice;?>
													<?php
													}
													?>
													
												
												<?php
												}
												}
												?>
                                               
                                         
													
													<?php if($country=="India")
													{
													?>
													
												
													
													<?php
													}
													else
													{
													?>
													
													
													
													<?php
													}
													?>
													
													
                                           
												
												<?php if($country=="India")
													{
													?>
													
													<?php
													}
													else
													{
													?>
											
										
													
													<?php 
													
												$int_weight=($tot_weight_2/1000);
												if($int_weight > 0){

												
 $get_or = mysqli_query($conn, "select * from tbl_adc_courier_charges where id=1");
 $get_adc = mysqli_fetch_array($get_or, MYSQLI_ASSOC);													
									 if($int_weight <= 0.5){
								 $tot_ship = $get_adc['courier_500g'] +  $get_adc['adc_3.5kg'] ;
									 }elseif($int_weight > 0.5 ){
										 $no_of_units = ceil($int_weight/0.5);
										 $courier_kirupa = $no_of_units *  $get_adc['courier_500g'];
									   $adc = $int_weight / 3.5;
									   $split = ceil($adc);
									  $tot_ship =  $courier_kirupa + ($split * $get_adc['adc_3.5kg']);
									 
									 
								 }
								}else{
									$tot_ship = 0;
								}			 
													?>
													
													
													
												
													
													
												
												
												<?php
												}
												?>
                                          
												
												 <?php
											   $new_kilo_41=($tot_weight_2/1000);
$new_kilo_5 = explode('.',$new_kilo_41);
 $new_kilo_6=$new_kilo_5[0];
 
 
   $new_state;
   
   $packing_charges=round((($subtotal*$pundai)/100));
   
   if($new_state=="Puducherry")
   {
   $packing_charges=0;
   }
   if($new_state=="Tamilnadu")
   {
   $packing_charges=0;
   }
   
   
 
 $Query_job_move_courier= mysql_query("SELECT *  from tbl_courier_charges where state='$new_state' ");
   

$row_job_move_courier= mysql_fetch_array($Query_job_move_courier);

 $courier_fees=$row_job_move_courier['amount'];

if($courier_fees=='')
{


 $Query_job_move_courier_1= mysql_query("SELECT *  from tbl_courier_charges where state='Others' ");
   

$row_job_move_courier_1= mysql_fetch_array($Query_job_move_courier_1);

 $courier_fees=$row_job_move_courier_1['amount'];

  
$courier_fees=($courier_fees);

}
  $courier_fees;
 
 
 
 
 
 
 
 ?>
                                                   
													
														<?php if($country=="India")
													{
													?>
													
													
													
													
													<?php
													}
													else
													{
													?>
														
														
														<?php
														}
														?>
													<?php if($country=="India")
													{
													
$Query_jobmal_shipping_devidiya = mysql_query("SELECT id  from shop_cart as a,shop_product as b where a.session_id='$browsessionid' and a.productid=b.product_id and b.v_s='0' ");
			 
  

$qty_devidiya=mysql_num_rows($Query_jobmal_shipping_devidiya);
													?>
													
													<?php if($qty_devidiya==0)
													{
													?>
													<?php echo $new_kilo_4=0.00;?>
													<?php
													}
													else
													{
													?>
													
													<?php 
													if( $new_kilo_41 >0 ){

														echo $new_kilo_4=	(revised_shipping($new_kilo_41, $new_state, $conn) + $packing_charges);
														// echo $new_kilo_4=((($new_kilo_6+1)*$courier_fees)+$packing_charges);
													}else{
														echo $new_kilo_4 = "0.00";
													}
													
													
													
													}
												
													}
													else
													{
													
													$tot_weight_2_int=$tot_weight_2;
													
													 $Query_job_move_courier_country= mysql_query("SELECT *  from tbl_courier_charges_country where state='$country' ");
   

$row_job_move_courier_country= mysql_fetch_array($Query_job_move_courier_country);
  $num_max_ship_int=mysql_num_rows($Query_job_move_courier_country);
  
  if($num_max_ship_int>0)
  {

 $courier_fees_country=$row_job_move_courier_country['amount'];
 $courier_fees_country_extra=$row_job_move_courier_country['additional_amount'];
 }
 else
 {
 
 $Query_job_move_courier_country= mysql_query("SELECT *  from tbl_courier_charges_country where state='Others' ");
   

$row_job_move_courier_country= mysql_fetch_array($Query_job_move_courier_country);

$courier_fees_country=$row_job_move_courier_country['amount'];
 $courier_fees_country_extra=$row_job_move_courier_country['additional_amount'];
 
 }
													
													
													if($tot_weight_2_int<=500)
													{
													 $courier_fees_country_1=$courier_fees_country;
													}
													else
													{
													 $tot_weight_2_int_1=($tot_weight_2_int-500);
													 $tot_weight_2_int_1_2=($tot_weight_2_int_1/250);
													
													 $new_kilo_5_int = explode('.',$tot_weight_2_int_1_2);
  $new_kilo_6_int=$new_kilo_5_int[0];
 
  $new_kilo_6_int_7=($new_kilo_6_int+1);
 
 $new_kilo_6_int_7_8=($courier_fees_country_extra*$new_kilo_6_int_7);
 $courier_fees_country_1=($courier_fees_country+$new_kilo_6_int_7_8);
													
													}
													
													
													
													?>
													
													<?php  $new_kilo_4=($tot_ship);?><?php  echo sprintf('%0.2f', $new_kilo_4);?>

													
													
													<?php
													}
												}
											}
													?>
													
												
                                               
                                                   <?php
function revised_shipping($weight, $state, $conn){
$state_arr = array('Tamilnadu','Andhra Pradesh', 'Karnataka', 'Kerala', 'Puducherry', 'Telangana');
if (in_array($state, $state_arr)) {
	$get_c = mysqli_query($conn, "SELECT * FROM tbl_courier_charges WHERE state = '$state'");
	$set_c = mysqli_fetch_assoc($get_c);
} else {
	$get_c = mysqli_query($conn, "SELECT * FROM tbl_courier_charges WHERE state = 'Others'");
	$set_c = mysqli_fetch_assoc($get_c);
}	

if($weight  == 0){
	$courier = 0;
}elseif($weight > 0 && $weight <=1){
	$courier = $set_c['amount'];
}elseif($weight > 1 && $weight <=2){
	$courier = $set_c['amount'] *2;
}elseif($weight > 2){
	$extra = $weight - 2;
	$courier = ($set_c['amount'] * 2) + (ceil($extra) * $set_c['3_rd_kg']);
}
return $courier;
}
?>