
<?php
$orders="active";
$caller1="open";
?>
<?php
require_once '../template/superadmin/action_connection.php' ;
include("../settings/adminsession.php");
include '../../include/conf.php';
session_start();
?>

<?php

if($_REQUEST['ids']=='')
{
$oro_de="active";

}


if($_REQUEST['ids']==1)
{
$oro_de1="active";

}

if($_REQUEST['ids']==24)
{
$oro_de24="active";

}


if($_REQUEST['ids']=='2')
{
$oro_de2="active";

}


if($_REQUEST['ids']=='3')
{
$oro_de3="active";

}


if($_REQUEST['ids']=='4')
{
$oro_de4="active";

}

if($_REQUEST['ids']=='5')
{
$oro_de5="active";

}
if($_REQUEST['ids']=='24')
{
$oro_de24="active";

}
?>





<?php /*?><?php
if(isset($_POST['submit'])){//to run PHP script on submit

if(!empty($_POST['check_list'])){

// Loop to store and display values of individual checked checkbox.

$man='0';

$ttt="sacpara21@gmail.com";

foreach($_POST['check_list'] as $selected_view   )

{
$input = "$selected_view ";

list($selected, $bdfffff) = explode('_', $input);



echo  $selected; // "5"

 $bdfffff; // "8"


}


}
}

?><?php */?>

 <?php include("header.php"); ?>
 
 <?php
 $pundai_erumai_devidiya=$_REQUEST['ids'];
 
 if($pundai_erumai_devidiya=="")
 {
 $ommala_mavan="New Order";
 }
 
 if($pundai_erumai_devidiya=="1")
 {
 $ommala_mavan="Verified Order";
 }
 
 if($pundai_erumai_devidiya=="5")
 {
 $ommala_mavan="Packing Order";
 }
 
 if($pundai_erumai_devidiya=="15")
 {
 $ommala_mavan="Ready to Dispatch Order";
 }
 
  if($pundai_erumai_devidiya=="2")
 {
 $ommala_mavan="Dispatched Order";
 }
 
 if($pundai_erumai_devidiya=="3")
 {
 $ommala_mavan="Delivered Order";
 }
 
  if($pundai_erumai_devidiya=="4")
 {
 $ommala_mavan="Cancelled Order";
 }
 
 if($pundai_erumai_devidiya=="4")
 {
 $ommala_mavan="Cancelled Order";
 }
  ?>
  
   <?php
if(isset($_POST['sumbit_note_para'])){

date_default_timezone_set('Asia/Kolkata');
$date_ss = date('Y-m-d H:i:s ', time());

$dis_phone=$_REQUEST['dis_phone'];

 $v_id_order=$_REQUEST["v_id_order"];

 $note=trim(addslashes($_REQUEST["c_note_".$v_id_order.""]));
 
 
  $Query="UPDATE `tbl_confirmorder` SET `no_note`='" .$note. "' WHERE  `orid`='".$v_id_order."'";
	   $DB->query($Query);
	   
	  
	  

 header("location:view_order.php");
 
 
 
 
 

}

?>
  
   <?php
if(isset($_POST['sumbit'])){//to run PHP script on submit
date_default_timezone_set('Asia/Kolkata');
$date_ss = date('Y-m-d H:i:s ', time());
  
   $dis_phone=$_REQUEST['dis_phone'];

 $v_id_order=$_REQUEST["v_id_order"];
 
   $courier_status=$_REQUEST["courier_status_".$v_id_order.""];
   $courier_no=trim(addslashes($_REQUEST["c_no_".$v_id_order.""]));
   $get_q = mysqli_query($conn, "select * from tbl_confirmorder where orid='$v_id_order'");
   $get_qo = mysqli_fetch_array($get_q, MYSQLI_ASSOC);
   $orid = $get_qo['refid'];
   $courier_amount = $_REQUEST["courier_amount"];
   
   $date_ss = date('Y-m-d H:i:s ', time());
   
  
   $message = "Hi ".$orid." Courier from Dr.ANBUGANAPATHI is dispatched through ".$courier_status.". Shipment no. is ".$courier_no.". ANBUDR"; //enter Your Message 

   $message = urlencode($message);
	   $curl = curl_init();
   curl_setopt_array($curl, array(
	 CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=DRANBU&Message='.$message.'&MobileNumbers='.$dis_phone.'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb',
	 CURLOPT_RETURNTRANSFER => true,
	 CURLOPT_ENCODING => '',
	 CURLOPT_MAXREDIRS => 10,
	 CURLOPT_TIMEOUT => 0,
	 CURLOPT_FOLLOWLOCATION => true,
	 CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
	 CURLOPT_CUSTOMREQUEST => 'GET',
   ));
   
   $response = curl_exec($curl);
   
   curl_close($curl);
		
   
   $Query="UPDATE `tbl_confirmorder` SET `deliverytime`='" .$date_ss. "', `courier_amount`='".$courier_amount."', `couriername`='" .$courier_status. "',`courier_no`='" .$courier_no. "',`orderstatus`='2' WHERE  `orid`='".$v_id_order."'";
	   $DB->query($Query);
	   
	  
	    //$ids=$_REQUEST['ids'];
	  
	 // header("location:view_order.php?ids=15");
	  

 //$cour="courier_status".$v_id_order."";

 header("location:view_order.php?ids=15");
}

?>


<?php if($_REQUEST['msg1']=="sucess")
{

?>
<div class="alert alert-success">
  <strong>Success!</strong> Order Deleted Sucessfully.
</div>
<?php
}
?>
  
            <div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-lg-10">
                    <!-- <h2>Order Details </h2> -->
                    <ol class="breadcrumb">
                        <li>
                            <a href="#">Orders</a>
                        </li>
                       <!-- <li>
                            <a>Product Details</a>
                        </li>-->
                        <li class="active">
                            <strong><?php echo $ommala_mavan;?></strong>
                        </li>
                    </ol>
                </div>
                <div class="col-lg-2">

                </div>
            </div>
        <div class="wrapper wrapper-content animated fadeInRight">
            
            <div class="row">
            <div class="col-lg-12">
            <div class="ibox float-e-margins">
            <!--<div class="ibox-title">
                <h5>Editable Table in- combination with jEditable</h5>
                <div class="ibox-tools">
                    <a class="collapse-link">
                        <i class="fa fa-chevron-up"></i>
                    </a>
                    <a class="dropdown-toggle" data-toggle="dropdown" href="#">
                        <i class="fa fa-wrench"></i>
                    </a>
                    <ul class="dropdown-menu dropdown-user">
                        <li><a href="#">Config option 1</a>
                        </li>
                        <li><a href="#">Config option 2</a>
                        </li>
                    </ul>
                    <a class="close-link">
                        <i class="fa fa-times"></i>
                    </a>
                </div>
            </div>-->
            <div class="ibox-content">
            <div class="">
            <!--<a  href="add_available_time.php" class="btn btn-primary ">Add a new Product</a>-->
			
			<!--<a onClick="fnClickAddRow();" href="javascript:void(0);" class="btn btn-primary ">Add a new row</a>-->
            </div>
			
			  <SCRIPT LANGUAGE="JavaScript">

<!-- 	

<!-- Begin

function CheckAll(chk)

{

	

	

	 formblock= document.getElementById('check_list');

	/*alert(forminputs.length);*/

	

for (i = 0; i < chk.length; i++)



	chk[i].checked = true ;

}



function UnCheckAll(chk)

{



for (i = 0; i < chk.length; i++)

	chk[i].checked = false ;

}

//  End -->

</script> 
			
			<div class="dataTable_wrapper table-responsive">
			
			 
            <table class="table table-striped table-bordered table-hover dataTables-example">
            <thead>
            <tr>
			
                <th>S.No.</th>
				<th>Invoice No</th>
				
				<th>Order Date & Time</th>
				<th>Name</th>
				<th>State</th>
				<th>Mobile No</th>
				<?php if($_REQUEST['ids']!=15)
				{
					
					
				?>
				<!--<th>Type</th>-->
				<?php
				}
				?>
                
                <!--<th>Order Status</th>-->
				
				
				<?php if($_REQUEST['ids']==2)
				{
				?>
					<th>Courier Company</th>
					
					<?php
					}
					?>
				
				<?php if($_REQUEST['ids']==3)
				{
				?>
					<th>Courier Company</th>
						
					
					<?php
					}
					?>
					<?php if($_REQUEST['ids']=="")
				{
				?>
				<th>Payment Mode</th>
				<!-- <th>Notes</th> -->
				
				<?php
				}
				?>
					
					<?php if($_REQUEST['ids']==1)
				{
				?>
				<th>Payment Mode</th>
				
				<!-- <th>Notes</th> -->
				<?php
				}
				?>
				<?php if($_REQUEST['ids']==2)
				{
				?>
					<th>Courier No</th>
					
					<?php
					}
					
					?>
					<?php if($_REQUEST['ids']==3)
				{
				?>
					<th>Courier No</th>
					<th>We Paid</th>
					<th>Shipping</th>
					<?php
					}
					
					?>
					
					
					
					
				<?php if($_REQUEST['ids']=="")
				{
				?>
				
				<th>Amount</th>
				
				<?php
				}
				?>
				
					
				<?php if($_REQUEST['ids']=="15")
				{
				?>
				
				<th>Amount</th>
				
				<?php
				}
				?>
				
				<?php if($_REQUEST['ids']=="5")
				{
				?>
				
				<th>Amount</th>
				
				<?php
				}
				?>
				<?php if($_REQUEST['ids']==1)
				{
				?>
				
				<th>Amount </th>
				
				<?php
				}
				?>
				
				<?php if($_REQUEST['ids']==4)
				{
				?>
				
				<th>Amount </th>
				
				<?php
				}
				?>
				
				<?php if($_REQUEST['ids']=="5")
				{
				?>
				
				<th>Qty</th>
				
				<?php
				}
				?>
				
				<?php if($_REQUEST['ids']==2)
				{
				?>
				
				<th>Time</th>
				
				<?php
				}
				?>
				
				<?php if($_REQUEST['ids']==15)
				{
				?>
				
				<th>Packed Time</th>
				<?php
				}
				?>
				<?php if($_REQUEST['ids']==15)
				{
				?>
				
				<th>Pickup By</th>
				<?php
				}
				?>
				
			<?php if($_REQUEST['ids']=="")
				{
				?>
				
				<th>Note</th>
				<?php
				}
				?>
				
				
				
            </tr>
            </thead>
            <tbody>
			
			<?php
$si=0;




if($_REQUEST['ids']=='')
{
$or_s=0;

}

else
{
$or_s=$_REQUEST['ids'];
}
									
									$table_name="tbl_confirmorder";
									
  $Query = "SELECT * from tbl_confirmorder where orderstatus='$or_s' and varstatus!='Cash' and  company_name='Energy Foods' and orderid IN(SELECT orderid from tbl_order)  order by orid desc limit 400";
                                               $namesss=$DB->query($Query);
											   
											   $nsssss=mysql_num_rows($namesss);
												$manssss='0';
$kjjj=0;
											   
											   while ($rowsss = mysql_fetch_array($namesss)) {
												$xyz = $rowsss['order_date_time'];
											   
											    $pundai_order_id=$rowsss['orid'];
												
												$country_id =$rowsss['country_id'];
												
												if( $rowsss['no_note'] == 'nonote'){
													$dnotes = '';
												}else{
													$dnotes = $rowsss['no_note'];	
												}
												
											   
											   
											   
$new_orid =$rowsss['orid'];											   
$userid =$rowsss['userid'];


 $Query_jobmal_shipping_devidiya = "SELECT a.ordid  from tbl_order as a,shop_product as b where  a.productid=b.product_id and b.v_s='0' and a.orderid='$new_orid' ";
		$name_pundai=$DB->query($Query_jobmal_shipping_devidiya);
		$qty_devidiya=mysql_num_rows($name_pundai);

$varstatus =$rowsss['varstatus'];
 $varstatus =$rowsss['varstatus'];
$orderid=$rowsss['orderid'];

$orderid_coun=$rowsss['contry'];


 $Query_pundai_myql_id = "SELECT * from tbl_order where orderid='$pundai_order_id' and (productid='146' ||  productid='101')  ";
                                               $namesss_pundai_id=$DB->query($Query_pundai_myql_id);
											   
											   $nsssss_pundai_id=mysql_num_rows($namesss_pundai_id);


$contry=$rowsss['contry'];
$state=$rowsss['state'];
$order_tc_id =$rowsss['order_tc_id'];

$orderstatus =$rowsss['orderstatus'];

if($contry=="India")
				{
				$sss="Rs";
				}
				else
				{
				$sss="$";
				}

 $Query = "SELECT * from `shop_user` where user_id='$userid'   ";
                                               $name=$DB->query($Query);
											     $no=mysql_num_rows($name);
											   $row = mysql_fetch_array($name);
											   
											   $new_status=$row['new_status'];
											   
											   
											  /*weight calculation*/
											  
											   $Query_new = "SELECT * from tbl_order where orderid='$orderid'";
                                               $namesss_new=$DB->query($Query_new);
											   
											   $nsssss_new=mysql_num_rows($namesss_new);
											   
											   $x=0;
											   $qty_new=0;
											   $qty_new1=0;
												

											   $new_qty_1_1=0;
											   while ($rowsss_new = mysql_fetch_array($namesss_new)) {
											   
											   
											   $product_id_new=$rowsss_new['productid'];
											   $qty_new=$rowsss_new['qty'];
											   $unit_pr_new=$rowsss_new['price'];
											   $tot_price_new=$rowsss_new['totprice'];
											   
											    $Query_12_new = "SELECT * from `shop_product` where product_id='$product_id_new'   ";
                                               $name_12_new=$DB->query($Query_12_new);
											     $no_new=mysql_num_rows($name_12_new);
											   $row_12_new = mysql_fetch_array($name_12_new);
											   
											   
											   
											   
											   $vstatus=$row_12_new['vstatus'];
											   
											   
											    if($new_status==1)
 {



 if($vstatus==1)
{

 $v_qty=($qty_new/2);
 
 }
 
 if($vstatus==7)
{

 $v_qty=($qty_new/2);
 
 }
 
 if($vstatus==6)
{

 $v_qty=($qty_new/2);
 
 }
 
 if($vstatus==2)
{

 $v_qty=($qty_new/4);
 
 }

  $x = (int)$v_qty;
  
  }
  
  else
  {
  $x=0;
  
  }
  
  
  $weight=$row_12_new['stock_status_id'];
												
												
											   
										$vid_type = $row_12_new['v_s'];
											   if($vid_type !=1){
												  if($weight=='' || $weight==0)
{
$weight=100;
} 
											   }
												   else{
													  
												 $weight = 0;  
											   }
											
$qty_new_1=($qty_new+$x);
 $new_qty=($weight*$qty_new_1);
 
 
  $new_qty_1_1 +=$new_qty;
//mark here											   
  $weight_shift = $new_qty_1_1;								 
  }
											   
											  
											  
											  
											  /*weight calculation*/
											   
											    $new_qty_1_1;
												
												$new_kilo_41=($new_qty_1_1/1000);
$new_kilo_5 = explode('.',$new_kilo_41);
   $new_kilo_6=($new_kilo_5[0]+1);
											 if($pundai_order_id>495)
											  {
											  $kudhi=0;
											  }
											  else
											  {
											  $kudhi=10;
											  }
											 
											   
											   $Query_oo = "SELECT * from `tbl_order` where orderid='$orderid'   ";
                                               $name_oo=$DB->query($Query_oo);
	
											     $no_oo=mysql_num_rows($name_oo);
		 $objqrynewsubee    = "SELECT SUM(totprice) AS amtTotal FROM tbl_order where orderid='$orderid'";
$name_12_123=$DB->query($objqrynewsubee);
 $Fetchnewww        = mysql_fetch_array($name_12_123);
   $subtotal_123=$Fetchnewww['amtTotal'];
   
   $offer=$rowsss['offer'];
   
     $subtotal_123=($subtotal_123-($subtotal_123*($offer/100)));
										$subtotal_123=number_format((float)$subtotal_123, 2, '.', '');
									
  
  
  
  /*shipping*/
   $contry;
  
  $state;

if($contry=="India")
{

  $packing_charges=round((($subtotal_123*$kudhi)/100));
if($state=="Puducherry")
   {
   $packing_charges=0;
   }
   if($state=="Tamilnadu")
   {
   $packing_charges=0;
   }
   
    $new_date_mal =$rowsss['order_date_time'];
 
 $new_date_mal_1 = date("Y-m-d",strtotime($new_date_mal));
 
  date_default_timezone_set('Asia/Kolkata');

  $date_mal_1 = date('2020-09-20', time());
  
  $curdate_mal_1 = strtotime($new_date_mal_1);
  
  $curdate_mal_2 = strtotime($date_mal_1);
     $Query_job_move_courier= "SELECT *  from tbl_courier_charges where state='$state' ";
  $name_12=$DB->query($Query_job_move_courier); 

$row_job_move_courier= mysql_fetch_array($name_12);

 

    //$courier_fees=$row_job_move_courier['amount'];
   
    //$courier_fees_para_1=$row_job_move_courier['amount'];
	 $pundai_order_id;
	if($pundai_order_id>495)
{
$courier_fees=$row_job_move_courier['amount'];
   
    $courier_fees_para_1=$row_job_move_courier['amount'];
}
else
{
	
	if($curdate_mal_1<$curdate_mal_2)
  {
   $courier_fees=$row_job_move_courier['amount'];
   
    $courier_fees_para_1=$row_job_move_courier['amount'];
	if($state=="Puducherry")
	{
	$courier_fees=60;
   
    $courier_fees_para_1=60;
	}
	if($state=="Tamilnadu")
	{
	$courier_fees=40;
   
    $courier_fees_para_1=40;
	}
	if($state=="Andhra Pradesh")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	if($state=="Karnataka")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	if($state=="Kerala")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	if($state=="Telangana")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	
  }
  else
  {
  
   $courier_fees=$row_job_move_courier['amount'];
   
    $courier_fees_para_1=$row_job_move_courier['amount'];
	
	
	if($state=="Puducherry")
	{
	$courier_fees=60;
   
    $courier_fees_para_1=60;
	}
	if($state=="Tamilnadu")
	{
	$courier_fees=40;
   
    $courier_fees_para_1=40;
	}
	if($state=="Andhra Pradesh")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	if($state=="Karnataka")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	if($state=="Kerala")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	if($state=="Telangana")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	
  }
  
}
	
	 $courier_fees;
	
	if($courier_fees=='')
{


    $Query_job_move_courier_1= "SELECT *  from tbl_courier_charges where state='Others' ";
   
$name_12_w=$DB->query($Query_job_move_courier_1); 


$row_job_move_courier_1= mysql_fetch_array($name_12_w);

  $new_date_mal =$rowsss['order_date_time'];
 
 $new_date_mal_1 = date("Y-m-d",strtotime($new_date_mal));
 $_SESSION['mydate']=$new_date_mal_1;
 
  date_default_timezone_set('Asia/Kolkata');

  $date_mal_1 = date('2020-10-06', time());
  
  $curdate_mal_1 = strtotime($new_date_mal_1);
  
  $curdate_mal_2 = strtotime($date_mal_1);
  
   if($curdate_mal_1<$curdate_mal_2)
  {
  $courier_fees=300;
  }
  
  else
  {

$courier_fees=$row_job_move_courier_1['amount'];

}
 $subtotal_123;
 
   $packing_charges123=round((($subtotal_123*$kudhi)/100));
 $packing_charges=round((($subtotal_123*$kudhi)/100));
 $courier_fees=($courier_fees);

}
   
    
   
}

else
{

  
    $tot_weight_2_int=$new_qty_1_1;
													
													 $Query_q= "SELECT *  from tbl_courier_charges_country where state='$contry' ";
   $Query_job_move_courier_country=$DB->query($Query_q); 

$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_jo= "SELECT *  from tbl_courier_charges_country where state='Others' ";
   $Query_job_move_courier_country=$DB->query($Query_jo); 

$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;
													  $new_kilo_4=$courier_fees_country_1;
													}
													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);
   $new_kilo_4=$courier_fees_country_1;
													
													}
  
}

 $subtotal_123;
 if($rowsss['need_shipping']==2){
	$new_courier=$rowsss['custom_charge'];
}elseif($rowsss['need_shipping']==0){
	$new_courier=(($courier_fees*$new_kilo_6)+$packing_charges);
}elseif($rowsss['need_shipping']==1){
	$new_courier = 0;
}else{
	$new_courier=(($courier_fees*$new_kilo_6)+$packing_charges);
}
  
  
  
  /*shipping*/
												 
												 
												 if($no_oo>0)
	{

											   
											   if($orderstatus==0)
											   {
											   $par_status="Placed";
											   }
											   if($orderstatus==1)
											   {
											   $par_status="Confirmed";
											   }
											   if($orderstatus==2)
											   {
											   $par_status="Dispatched";
											   }
											    if($orderstatus==3)
											   {
											   $par_status="Delivered";
											   }
											   
											   if($orderstatus==4)
											   {
											   $par_status="Refund";
											   }
											   
											   if($orderstatus==5)
											   {
											   $par_status="Packed";
											   }
											   
												   
					//sprintf("%02d", $to_hour);
					
					$mala_pundai =$row['name'];
					$pundai_name=	$rowsss['dif_name'];
					
					
					 $row['phone'];
					
					if($pundai_name=="name")
					{
					
					$mala_pundai_name =$row['name'];
					}
					else
					{
					
					$mala_pundai_name =	$rowsss['dif_name'];
					}
					
					$pundai_phone=$rowsss['dif_phone'];
					
					if($pundai_phone=="phone")
					{
					
					$mala_pundai_phone =$row['phone'];
					}
					else
					{
					
					$mala_pundai_phone =	$rowsss['dif_phone'];
					}
					
					
												//$pundai_phone=	$rowsss['dif_phone'];
												
																	  
	

	?>
			
			
			<?php /*?><?php
			if($nsssss_pundai_id>0)
			{
			?>
            <tr class="gradeX">
			
			<?php
			}
			else
			{
			
			?>
			<tr class="gradeX" style="color:#990066">
			<?php
			
			}
			?><?php */?>
			     
				 
				 
				 <?php
			if($orderid_coun=="India")
			{
			?>
            <tr class="gradeX">
			
			<?php
			}
			else
			{
			
			?>
			<tr class="gradeX" style="color:#FF0000">
			<?php
			
			}
			?>

			<td><?php echo $nsssss;?></td>
			
			
                <td><a href="order_details.php?id=<?php echo $rowsss['orid'];?>&ids=<?php echo $_REQUEST['ids'];?>"><?php echo $rowsss['refid'];?></a></td>
				
				<td><?php echo $rowsss['order_date_time'];?></td>
				<td><?php  strtoupper($mala_pundai_name);
				echo $mala_pundai_name= ucwords($mala_pundai_name);
				?>
				
				</td>
				
					<td><? 	if($contry =="India"){
					if($row['state']!=''){
						echo $row['state'];
					}else{
						echo $rowsss['state'];
					}
				}else{
					echo $rowsss['contry'];
				}?></td>
				<!-- <td><?php echo strtoupper($rowsss['state']);?></td> -->
				
				<?php 
                 if($row['country'] == "India"){
				?>
				<td><?php 
				echo $mala_pundai_phone;?>
				</td>
				<?php
				 }else{
					?>
	<td><?php 
				echo $mala_pundai_phone;?>
                 <button type = "button" id="<?php echo $rowsss['orid'];?>" class="btn-sm danger mybtn"><i class="fa fa-upload" aria-hidden="true"></i>
</button>
				</td>
				<form id="uploadFile<?php echo $pundai_order_id;?>" >
				<input type="hidden" name="upl_key" value="<?php echo $pundai_order_id;?>" />
				<div class="modal myModal" id="mycap<?php echo $pundai_order_id;?>" tabindex="-1" role="dialog">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title">View & Upload Files <?php echo $pundai_order_id;?></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
	  <div class="form-group">
		<?php
          $check = mysqli_query($conn, "select * from tbl_confirmorder where orid = '$pundai_order_id'");
		  $check_f = mysqli_fetch_array($check, MYSQLI_ASSOC);
		  $file_arr = explode("$$$", $check_f['passport_file']);
		  if(count($file_arr) > 0 && $check_f['passport_file']!=''){
			foreach($file_arr as $arr){
				$path = 'phpaction/uploads/'.$arr;
				echo '<a href="'.$path.'" target="_blank">'.$arr.'</a> <a href="delete_pass.php?img='.$arr.'&orid='.$pundai_order_id.'"><i class="fa fa-trash"></i></a><br>';
			}
		  }
		?>
    <label for="exampleFormControlFile1">choose files</label>
    <input type="file" class="form-control-file" name="file<?php echo $pundai_order_id;?>[]" id="file<?php echo $pundai_order_id;?>" multiple>
  </div>
      </div>
      <div class="modal-footer">
        <button type="button" id="<?php echo $pundai_order_id;?>" class="btn btn-primary upload_btn">Upload</button>
        <button type="button" id="<?php echo $pundai_order_id;?>" class="btn btn-secondary close_file" data-dismiss="modal">Close</button>
      </div>
    </div>
  </div>
</div>
				 </form>
					<?php
				 }
				?>
				<?php if($_REQUEST['ids']!=15)
				{
				?>
				<!-- <td>PATIENT</td>-->
				 
				 <?php
				 }
				 ?>
                <!--<td><span class="label label-primary"><?php echo $par_status;?></span>
                </td>-->
				
				<?php
				$ccc_name=$rowsss['couriername'];
				if($ccc_name=="Franch Express")
				{
				
				$co_url="http://www.franchexpress.com/";
				}
				if($ccc_name=="DHL Express")
				{
				$co_url="https://www.dhl.com/en/express.html";
				}
				if($ccc_name=="Professional")
				{
				$co_url="https://www.tpcindia.com/";
				}
				if($ccc_name=="India Post")
				{
				$co_url="https://www.indiapost.gov.in/vas/Pages/IndiaPostHome.aspx";
				}
				if($ccc_name=="Dtdc")
				{
				$co_url="https://www.dtdc.in/";
				}
				
					if($ccc_name=="Blue Dart")
				{
				$co_url="https://www.bluedart.com/";
				}
				
				if($ccc_name=="Trackon")
				{
				$co_url="https://trackon.in/";
				}
				
				if($ccc_name=="Doubt")
				{
				$co_url="";
				}
				
				if($ccc_name=="Dunzo")
				{
				$co_url="https://www.dunzo.com/chennai";
				}
				
				
				?>
				<?php if($_REQUEST['ids']==2)
				{
				?>
				
				<td>
				<?php echo $rowsss['couriername'];?>			</td>
				
				<?php
				}
				?>
				
				<?php if($_REQUEST['ids']==3)
				{
				?>
				
				<td>
				<?php 
					
					if($new_kilo_41 == 0.1 && $rowsss['courier_no']==NULL && $rowsss['courier_amount']==NULL){
						echo 'Yoga Video';
					}else{
						echo $rowsss['couriername'];
					}
					
					?>			
					
					</td>
				
				
				<?php
				}
				?>
				
				
				
				
				<?php if($_REQUEST['ids']=="")
				{
				?>
				
				<td>
				<?php
				if($contry=="India")
{
if($varstatus!='0')
{
echo $ss=$varstatus;
}
else
{
//echo $ss="Payumoney";
	echo $ss=$varstatus;
}
}
else
{
 
 
 
 if($country_id==0)
 {
//echo  $ss="Paypal";
	 echo $ss=$varstatus;
 }
 
  if($country_id==1)
 {
echo  $ss=$varstatus;
 }
 
}
?></td>
<!-- <td><?= $dnotes; ?></td> -->
				<?php
				}
				?>
				<?php if($_REQUEST['ids']==1)
				{
				?>
				
				<td>
				<?php
				if($contry=="India")
{
if($varstatus!='0')
{
echo $ss=$varstatus;
}
else
{
echo $ss="Payumoney";
}
}
else
{
 if($country_id==0)
 {
echo  $ss="Paypal";
 }
 
  if($country_id==1)
 {
echo  $ss=$varstatus;
 }
}
?></td>
				<?php
				}
				?>
				
				<?php if($_REQUEST['ids']==2)
				{
				?>
				<td>
				
				
				
				<?php echo $rowsss['courier_no'];?>                </td>
				
				<?php
				}
				
				?>
				
				
				<?php if($_REQUEST['ids']==3)
				{
				?>
				<td>
				
				<?php
				$d_stat=$rowsss['d_stat'];
				
				?>
				<?php
				if($d_stat==0)
				{
				?>
				
				<?php
					if($new_kilo_41 == 0.1 && $rowsss['courier_no']==NULL && $rowsss['courier_amount']==NULL){
						echo 'Digital';
					}else{
						echo $rowsss['courier_no'];
					}
					
				
					?>
				
				<?php
				}
				
				?>
				
				<?php
				if($d_stat==5)
				{
				?>
				
				Own Delivery
				
				<?php
				}
				
				?>
					
				
				
				
				<?php
				if($d_stat==6)
				{
				?>
				
				Confirmed by Call
				
				<?php
				}
				
				?>                </td>
				<td><?php 
					if($new_kilo_41 == 0.1 && $rowsss['courier_no']==NULL && $rowsss['courier_amount']==NULL){
						echo 'NIL';
					}else{
				echo	$rowsss['courier_amount'];	
					}
					
					?></td>
									<td align="right"><?php //WIP
											if($weight!=0){
											
									 if($contry=="India" && $rowsss['need_shipping']=='0')
  {
	 
  ?>
									<?php  $id;
	  
									if($id == 36)
									{
									 $new_kilo_4=80;
								//	echo $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', '');
										echo $new_kilo_4;
									}
									else
									{
									?>
									
									<?php
									if($id == 37)
									{
									 $new_kilo_4=120;
									//echo $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', '');
										echo $new_kilo_4;
									}
									else
									{
									
									?>
									
									<?php  $new_kilo_4=(($new_kilo_6+1)*$courier_fees);
								//	echo $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', '');
										echo $new_kilo_4;
									?>
									
									<?php
									}
									}
									
									}else if($contry=="India" && $rowsss['need_shipping']=='2'){
	//  echo $new_kilo_4=number_format((float)$rows_order['custom_charge'], 2, '.', '');
	  echo $new_kilo_4=$rowsss['custom_charge'];
	  
  }elseif($contry=="India" && $rows_order['need_shipping']=='1')
  {
	echo $new_kilo_4 = 0;
  }elseif($contry!="India"){
	

	  echo $new_kilo_4 = calc_ship($tot_weight_2_int, $rowsss['order_date_time'], $conn);
  }
									else
									{
									?>
									<?php  $new_kilo_4;
								//	echo $new_kilo_4=number_format((float)$new_kilo_4, 2, '.', '');
											echo $new_kilo_4;
										//echo calc_ship($tot_weight_2_int);
									?>
									<?php
									}
										}else{
											echo $new_kilo_4 = 0;
												
										}
								$tot_kilo_4+=$new_kilo_4;	
		$tot_courier+=$rowsss['courier_amount'];
									?>
		</td>
				
				<?php
				}
				
				?>
				
				<?php if($_REQUEST['ids']=="4")
				{
				?>
				
				<td align="right">
				
				<?php
				if($contry=="India")
{
?>
				
				<?php echo $sss;?>
				
				 
				
				<?php 
				if($order_tc_id==0)
{

if($qty_devidiya==0)
									{
									$new_courier=0;
									}


				 echo ($subtotal_123+$new_courier);
				 
				 }
				 
				 else
				 {
				 echo $subtotal_123;
				 }
				 
				 
				 
				 
				 
				 }
				 ?>                </td>
				<?php }
				?> 
				
				
				
								
				<?php if($_REQUEST['ids']=="5")
				{
				?>
				
				<td align="right">
				
				<?php
				if($contry=="India")
{
?>
				
				<?php echo $sss;?>
				
				 
				
				<?php 
				if($order_tc_id==0)
{

if($qty_devidiya==0)
									{
									$new_courier=0;
									}

				 echo ($subtotal_123+$new_courier);
				 
				 }
				 
				 else
				 {
				 echo $subtotal_123;
				 }
				 
				 }
				 ?>                </td>
				<?php }
				?> 
				
				<?php if($_REQUEST['ids']=="")
				{
				?>
				
				<td align="right">
				
				<?php
				if($contry=="India")
{
?>
				
				<?php echo $sss;?> <?php 
				if($order_tc_id==0)
{


if($qty_devidiya==0)
									{
									$new_courier=0;
									}
				 echo ($subtotal_123+$new_courier);
				 
				 }
				 
				 else
				 {
				 
				 
				 
				 echo $subtotal_123;
				 }
				 ?>
				 <?php
				 }
				 ?>
				 
				 
				 <?php
				if($contry!="India")
{
?>

<?php //echo $rowsss['paypalamount'];
//mark here
if($weight_shift !=0){
	if($rowsss['need_shipping']==0){
		
		
	echo 'Rs '. (calc_ship($tot_weight_2_int, $rowsss['order_date_time'], $conn) + $subtotal_123);
	}elseif($rowsss['need_shipping']==2){
		echo 'Rs '. ( $subtotal_123 + $rowsss['custom_charge']);
	}else{
		echo 'Rs '. ($subtotal_123);
	}

}else{
	echo 'Rs '. ($subtotal_123);
}

 //echo calc_ship($tot_weight_2_int, $new_date_mal_1, $conn);
					?>
<?php
}
?>                </td>
				
				
				
				<?php }
				?> 
				
				
				<?php if($_REQUEST['ids']=="15")
				{
				?>
				
				<td align="right">
				
				<?php
				if($contry=="India")
{
?>
				
				<?php echo $sss;?> <?php 
				if($order_tc_id==0)
{


if($qty_devidiya==0)
									{
									$new_courier=0;
									}
				 echo ($subtotal_123+$new_courier);
				 
				 }
				 
				 else
				 {
				 
				 
				 
				 echo $subtotal_123;
				 }
				 ?>
				 <?php
				 }
				 ?>
				 
				 
				 <?php
				if($contry!="India")
{
?>

<?php //echo $rowsss['paypalamount'];
//This will display the international amount
	echo calc_ship($tot_weight_2_int, $GLOBALS["xyz"], $conn, $rowsss['need_shipping']) + $subtotal_123;?>
<?php
}
?>                </td>
				
				
				
				<?php }
				?> 
				
				<?php if($_REQUEST['ids']=="5")
				{
				$nsssss_new
				?>
											   
											   
						<td align="right">
						<?php echo $nsssss_new;?>						</td>					   
											   <?php
											   }
											   ?>
				
				
				<?php if($_REQUEST['ids']==1)
				{
				?>
				
				<td align="right">
				
				<?php
				if($contry=="India")
{
?>
				
				<?php echo $sss;?> <?php 
				if($order_tc_id==0)
{


if($qty_devidiya==0)
									{
									$new_courier=0;
									}
				 echo ($subtotal_123+$new_courier);
				 
				 }
				 
				 else
				 {
				 echo $subtotal_123;
				 }
			
				 
			
				 }else{
				
					
//echo $rowsss['paypalamount'];
	//headache
	if($weight_shift !=0){
		$mydate = date('Y-m-d', strtotime($rowsss['order_date_time']));
		echo 'Rs '. (calc_ship($tot_weight_2_int, $mydate, $conn) + $subtotal_123);
	}else{
		echo 'Rs '. ($subtotal_123);
	}
	
	 //echo calc_ship($tot_weight_2_int, $new_date_mal_1, $conn);



				 }
				 ?>                </td>
				<?php }
				?> 
				<?php if($_REQUEST['ids']==2)
				{
				?>
				
				<td>
				
				
				
				<?php echo $rowsss['deliverytime'];?>                </td>
				<?php }
				?> 
				
				
				<?php if($_REQUEST['ids']==15)
				{
				?>
				
				<td><?php echo $rowsss['packing_date'];?> </td>
				<?php
				}
				?>
				
				
				<?php if($_REQUEST['ids']==15)
				{
				?>
				
				<td>
				<button type="button" class="btn-primary" data-toggle="modal" data-target="#exampleModal<?php echo $pundai_order_id;?>">

		
  <?php echo $rowsss['couriername'];
  if ($rowsss['dif_name']=='name'){
	$get_user = mysqli_query($conn, "select `name` from shop_user where user_id='".$rowsss['userid']."'");
	$set_user = mysqli_fetch_assoc($get_user);
	$user_name = $set_user['name'];
  }else{
	$user_name=$rowsss['dif_name'];
  }
 
 ?>
</button>


<div class="modal fade" id="exampleModal<?php echo $pundai_order_id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h3 class="modal-title" id="exampleModalLabel"><?= $rowsss['refid'].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$user_name ?> &nbsp;&nbsp;&nbsp;&nbsp; Shipping Rs. <?php
		 $weight= calc_weight($rowsss['orderid'], $conn);
		 if($rowsss['need_shipping']==2){
			echo $rowsss['custom_charge'];
		 }else if($rowsss['need_shipping']==0){
			if($rowsss['contry'] == "India"){
				echo calc_india_shipping($weight, $rowsss['state'], $conn);
				 }else{
					echo calc_intl_shipping($weight, date('Y-m-d', strtotime($rowsss['order_date_time'])), $conn);
				 }
		 }else{
			echo '0';
		 }
		 
		
		?></h3>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
	  
	  <script type="text/javascript">
	  function  validation1_<?php echo $pundai_order_id;?>(){
	
	
//alert(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value);

if(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please Select the Courier Name");
document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.focus();
return false;
}

if(document.register_<?php echo $pundai_order_id;?>.c_no_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please enter the Courier No");
document.register_<?php echo $pundai_order_id;?>.c_no_<?php echo $pundai_order_id;?>.focus();
return false;
}


}
</script>
	 
	  <form name="register_<?php echo $pundai_order_id;?>" method="post" onSubmit="return validation_<?php echo $pundai_order_id;?>();" class="form-horizontal" enctype="multipart/form-data" >
      <div class="modal-body">
	  
        <div class="form-group"><label class="col-sm-2 control-label">Courier</label>

                                    <div class="col-sm-10">
									<?php
									$c_name=$rowsss['couriername'];
									
									?>
									
									
									
									
									
									<select class="form-control m-b" name="courier_status_<?php echo $pundai_order_id;?>" id="courier_name" required>
									<option value="">Select</option>
									
									<?php
									 $Query_courier = "SELECT * from tbl_courier ";
                                               $namesss_qurier=$DB->query($Query_courier);
											   
											   
											   
											   while ($rowsss_qurier = mysql_fetch_array($namesss_qurier)) {
											   $new_co=$rowsss_qurier['courier_name'];
											   
											   ?>
											   
	   <option class="form-control"     value="<?php echo $new_co;?>" <?php if($c_name==$new_co) { ?>  selected="selected" <?php } ?>>
	   
	   <?php echo $rowsss_qurier['courier_name'];?></option>										   
											   <?php
											   }
											   ?>



 
									
 <!--<option class="form-control"     value="Franch Express" <?php if($c_name=="Franch Express") { ?>  selected="selected" <?php } ?>>Franch Express</option>
 <option class="form-control"      value="DHL Express" <?php if($c_name=="DHL Express") { ?>  selected="selected" <?php } ?>>DHL Express</option>
 <option class="form-control"      value="Professional" <?php if($c_name=="Professional") { ?>  selected="selected" <?php } ?>>Professional</option>
 <option class="form-control"      value="India Post" <?php if($c_name=="India Post") { ?>  selected="selected" <?php } ?>>India Post</option>
 
 <option class="form-control"      value="Dtdc"  <?php if($c_name=="Dtdc") { ?>  selected="selected" <?php } ?>>Dtdc</option>
 
 <option class="form-control"      value="Blue Dart" <?php if($c_name=="Blue Dart") { ?>  selected="selected" <?php } ?> >Blue Dart</option>
 <option class="form-control"      value="Trackon" <?php if($c_name=="Trackon") { ?>  selected="selected" <?php } ?> >Trackon</option>
 <option class="form-control"      value="Dunzo" <?php if($c_name=="Dunzo") { ?>  selected="selected" <?php } ?> >Dunzo</option>
 <option class="form-control"      value="Doubt" <?php if($c_name=="Doubt") { ?>  selected="selected" <?php } ?> >Doubt</option>-->
 
   
   
                                </select>
								
									<!--<input type="text" name="product_name_<?php echo $kkkasss;?>" value=""  class="form-control">-->
									
																		</div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<br />
								
									<div class="form-group"><label class="col-sm-2 control-label">Amount</label>

                                    <div class="col-sm-10"><input type="text" name="courier_amount" id="courier_amount" class="form-control" maxlength="5" value = "" required></div>
                                </div>
                                <br/>
								<div class="form-group"><label class="col-sm-2 control-label">Courier No</label>

                                    <div class="col-sm-10"><input type="text" name="c_no_<?php echo $pundai_order_id;?>" id="courier_no" value="" class="form-control" required></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <!--<button type="button" class="btn btn-primary">Save changes</button>-->
		

		<input type="submit" class="btn btn-primary" name="sumbit" id="login"  value="Submit" />
		
		<input type="hidden" name="dis_phone" value="<?php echo $mala_pundai_phone;?>"/>
		
		<?php  $mala_pundai_phone;?>
		
		<input type="hidden" name="v_id_order" value="<?php echo $pundai_order_id;?>"/>
      </div>
	  
	  </form>
    </div>
  </div>
</div>
				
				</td>
				<?php
				}
				?>
				
				
				 	<?php if($_REQUEST['ids']=="")
				{
				?>
				
				<td>
				<button type="button" class="btn-primary" data-toggle="modal" data-target="#exampleModal<?php echo $pundai_order_id;?>">

		
 Note
</button>


<div class="modal fade" id="exampleModal<?php echo $pundai_order_id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Add Notes</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
	  
	  <script type="text/javascript">
	  function  validation_<?php echo $pundai_order_id;?>(){
	
	
//alert(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value);

if(document.register_<?php echo $pundai_order_id;?>.c_note_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please Add the Notes");
document.register_<?php echo $pundai_order_id;?>.c_note_<?php echo $pundai_order_id;?>.focus();
return false;
}




}
</script>
	 
	  <form name="register_<?php echo $pundai_order_id;?>" method="post" onSubmit="return validation_<?php echo $pundai_order_id;?>();" class="form-horizontal" enctype="multipart/form-data" >
      <div class="modal-body">
	  
        <div class="form-group"><label class="col-sm-2 control-label">Note</label>

                                    <div class="col-sm-10">
									
									
									<textarea name="c_note_<?php echo $pundai_order_id;?>" class="form-control"></textarea>
									<!--<input type="text" name="c_no_<?php echo $pundai_order_id;?>" value="" class="form-control">-->
								
									<!--<input type="text" name="product_name_<?php echo $kkkasss;?>" value=""  class="form-control">-->
									
																		</div>
                                </div>
                               
								
								
								
								
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <!--<button type="button" class="btn btn-primary">Save changes</button>-->
		

		<input type="submit" class="btn btn-primary" name="sumbit_note_para" id="login"  value="Submit" />
		
		<input type="hidden" name="dis_phone" value="<?php echo $mala_pundai_phone;?>"/>
		
		<?php  $mala_pundai_phone;?>
		
		<input type="hidden" name="v_id_order" value="<?php echo $pundai_order_id;?>"/>
      </div>
	  
	  </form>
    </div>
  </div>
</div>
				
				</td>
				<?php
				}
				?>
				
				
				
               <!-- <td>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
            </tr>
			
			
			
			<?php
			$nsssss=$nsssss-1;
			
			}
			}
			?>
            </tbody>
            <!--<tfoot>
            <tr>
                <th>Rendering engine</th>
                <th>Browser</th>
                <th>Platform(s)</th>
                
            </tr>
            </tfoot>-->
            </table>
			
			
</div>
           <?php
				if($_REQUEST['retu']=='24')
				{
					?>
				<h4 align="center"><b>RETURNED ORDERS</b></h4>
					
								<div class="dataTable_wrapper table-responsive">
			
			 
            <table class="table table-striped table-bordered table-hover "  >
            <thead>
            <tr>
			
                <th>S.No.</th>
				<th>Invoice No</th>
				
				<th>Order Date & Time</th>
				<th>Name</th>
				<th>State</th>
				<th>Mobile No</th>
			
                <th>Returned Time</th>
                 <th>Reason</th>
                <!--<th>Order Status</th>-->
					
				 <th>Pickup By</th>	
				
				
			
			
				
				
            </tr>
            </thead>
            <tbody>
			
			<?php
$si=0;




if($_REQUEST['retu']=='')
{
$or_s=0;

}

else
{
$or_s=$_REQUEST['retu'];
}
									
									$table_name="tbl_confirmorder";
									
  $Query = "SELECT * from tbl_confirmorder where orderstatus='24' and varstatus!='Cash' and  company_name='Energy Foods' and orderid IN(SELECT orderid from tbl_order)  order by orid desc";
                                               $namesss=$DB->query($Query);
											   
											   $nsssss=mysql_num_rows($namesss);
												$manssss='0';
$kjjj=0;
											   
											   while ($rowsss = mysql_fetch_array($namesss)) {
											   
											    $pundai_order_id=$rowsss['orid'];
												
												$country_id =$rowsss['country_id'];
												
												 
		
												
											   
											   
											   
$new_orid =$rowsss['orid'];											   
$userid =$rowsss['userid'];


 $Query_jobmal_shipping_devidiya = "SELECT a.ordid  from tbl_order as a,shop_product as b where  a.productid=b.product_id and b.v_s='0' and a.orderid='$new_orid' ";
		$name_pundai=$DB->query($Query_jobmal_shipping_devidiya);
		$qty_devidiya=mysql_num_rows($name_pundai);

$varstatus =$rowsss['varstatus'];
 $varstatus =$rowsss['varstatus'];
$orderid=$rowsss['orderid'];

$orderid_coun=$rowsss['contry'];


 $Query_pundai_myql_id = "SELECT * from tbl_order where orderid='$pundai_order_id' and (productid='146' ||  productid='101')  ";
                                               $namesss_pundai_id=$DB->query($Query_pundai_myql_id);
											   
											   $nsssss_pundai_id=mysql_num_rows($namesss_pundai_id);


$contry=$rowsss['contry'];
$state=$rowsss['state'];

$order_tc_id =$rowsss['order_tc_id'];

$orderstatus =$rowsss['orderstatus'];

if($contry=="India")
				{
				$sss="Rs";
				}
				else
				{
				$sss="$";
				}

 $Query = "SELECT * from `shop_user` where user_id='$userid'   ";
                                               $name=$DB->query($Query);
											     $no=mysql_num_rows($name);
											   $row = mysql_fetch_array($name);
											   
											   $new_status=$row['new_status'];
											   
											   
											  /*weight calculation*/
											  
											   $Query_new = "SELECT * from tbl_order where orderid='$orderid'";
                                               $namesss_new=$DB->query($Query_new);
											   
											   $nsssss_new=mysql_num_rows($namesss_new);
											   
											   $x=0;
											   $qty_new=0;
											   $qty_new1=0;
												

											   $new_qty_1_1=0;
											   while ($rowsss_new = mysql_fetch_array($namesss_new)) {
											   
											   
											   $product_id_new=$rowsss_new['productid'];
											   $qty_new=$rowsss_new['qty'];
											   $unit_pr_new=$rowsss_new['price'];
											   $tot_price_new=$rowsss_new['totprice'];
											   
											    $Query_12_new = "SELECT * from `shop_product` where product_id='$product_id_new'   ";
                                               $name_12_new=$DB->query($Query_12_new);
											     $no_new=mysql_num_rows($name_12_new);
											   $row_12_new = mysql_fetch_array($name_12_new);
											   
											   
											   
											   
											   $vstatus=$row_12_new['vstatus'];
											   
											   
											    if($new_status==1)
 {



 if($vstatus==1)
{

 $v_qty=($qty_new/2);
 
 }
 
 if($vstatus==7)
{

 $v_qty=($qty_new/2);
 
 }
 
 if($vstatus==6)
{

 $v_qty=($qty_new/2);
 
 }
 
 if($vstatus==2)
{

 $v_qty=($qty_new/4);
 
 }

  $x = (int)$v_qty;
  
  }
  
  else
  {
  $x=0;
  
  }
  
  
  $weight=$row_12_new['stock_status_id'];
												
												$vid_type = $row_12_new['v_s'];
											   
											  											   if($vid_type !=1){
												  if($weight=='' || $weight==0)
{
$weight=100;
} 
											   }
												   else{
													  
												 $weight = 0;  
											   }
$qty_new_1=($qty_new+$x);
 $new_qty=($weight*$qty_new_1);
 
 
  $new_qty_1_1 +=$new_qty;
  $weight_shift =  $new_qty_1_1;
											   
											   }
											   
											  
											  
											  
											  /*weight calculation*/
											   
											    $new_qty_1_1;
												
												$new_kilo_41=($new_qty_1_1/1000);
$new_kilo_5 = explode('.',$new_kilo_41);
   $new_kilo_6=($new_kilo_5[0]+1);
											 if($pundai_order_id>495)
											  {
											  $kudhi=0;
											  }
											  else
											  {
											  $kudhi=10;
											  }
											 
											   
											   $Query_oo = "SELECT * from `tbl_order` where orderid='$orderid'   ";
                                               $name_oo=$DB->query($Query_oo);
	
											     $no_oo=mysql_num_rows($name_oo);
		 $objqrynewsubee    = "SELECT SUM(totprice) AS amtTotal FROM tbl_order where orderid='$orderid'";
$name_12_123=$DB->query($objqrynewsubee);
 $Fetchnewww        = mysql_fetch_array($name_12_123);
   $subtotal_123=$Fetchnewww['amtTotal'];
   
   $offer=$rowsss['offer'];
   
     $subtotal_123=($subtotal_123-($subtotal_123*($offer/100)));
										$subtotal_123=number_format((float)$subtotal_123, 2, '.', '');
									
  
  
  
  /*shipping*/
   $contry;
  
  $state;

if($contry=="India")
{

  $packing_charges=round((($subtotal_123*$kudhi)/100));
if($state=="Puducherry")
   {
   $packing_charges=0;
   }
   if($state=="Tamilnadu")
   {
   $packing_charges=0;
   }
   
    $new_date_mal =$rowsss['order_date_time'];
 
 $new_date_mal_1 = date("Y-m-d",strtotime($new_date_mal));
 
  date_default_timezone_set('Asia/Kolkata');

  $date_mal_1 = date('2020-09-20', time());
  
  $curdate_mal_1 = strtotime($new_date_mal_1);
  
  $curdate_mal_2 = strtotime($date_mal_1);
     $Query_job_move_courier= "SELECT *  from tbl_courier_charges where state='$state' ";
  $name_12=$DB->query($Query_job_move_courier); 

$row_job_move_courier= mysql_fetch_array($name_12);

 

    //$courier_fees=$row_job_move_courier['amount'];
   
    //$courier_fees_para_1=$row_job_move_courier['amount'];
	 $pundai_order_id;
	if($pundai_order_id>495)
{
$courier_fees=$row_job_move_courier['amount'];
   
    $courier_fees_para_1=$row_job_move_courier['amount'];
}
else
{
	
	if($curdate_mal_1<$curdate_mal_2)
  {
   $courier_fees=$row_job_move_courier['amount'];
   
    $courier_fees_para_1=$row_job_move_courier['amount'];
	if($state=="Puducherry")
	{
	$courier_fees=60;
   
    $courier_fees_para_1=60;
	}
	if($state=="Tamilnadu")
	{
	$courier_fees=40;
   
    $courier_fees_para_1=40;
	}
	if($state=="Andhra Pradesh")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	if($state=="Karnataka")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	if($state=="Kerala")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	if($state=="Telangana")
	{
	$courier_fees=150;
   
    $courier_fees_para_1=150;
	}
	
  }
  else
  {
  
   $courier_fees=$row_job_move_courier['amount'];
   
    $courier_fees_para_1=$row_job_move_courier['amount'];
	
	
	if($state=="Puducherry")
	{
	$courier_fees=60;
   
    $courier_fees_para_1=60;
	}
	if($state=="Tamilnadu")
	{
	$courier_fees=40;
   
    $courier_fees_para_1=40;
	}
	if($state=="Andhra Pradesh")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	if($state=="Karnataka")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	if($state=="Kerala")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	if($state=="Telangana")
	{
	$courier_fees=100;
   
    $courier_fees_para_1=100;
	}
	
  }
  
}
	
	 $courier_fees;
	
	if($courier_fees=='')
{


    $Query_job_move_courier_1= "SELECT *  from tbl_courier_charges where state='Others' ";
   
$name_12_w=$DB->query($Query_job_move_courier_1); 


$row_job_move_courier_1= mysql_fetch_array($name_12_w);

  $new_date_mal =$rowsss['order_date_time'];
 
 $new_date_mal_1 = date("Y-m-d",strtotime($new_date_mal));
 
  date_default_timezone_set('Asia/Kolkata');

  $date_mal_1 = date('2020-10-06', time());
  
  $curdate_mal_1 = strtotime($new_date_mal_1);
  
  $curdate_mal_2 = strtotime($date_mal_1);
  
   if($curdate_mal_1<$curdate_mal_2)
  {
  $courier_fees=300;
  }
  
  else
  {

$courier_fees=$row_job_move_courier_1['amount'];

}
 $subtotal_123;
 
   $packing_charges123=round((($subtotal_123*$kudhi)/100));
 $packing_charges=round((($subtotal_123*$kudhi)/100));
 $courier_fees=($courier_fees);

}
   
    
   
}

else
{

  
    $tot_weight_2_int=$new_qty_1_1;
													
													 $Query_q= "SELECT *  from tbl_courier_charges_country where state='$contry' ";
   $Query_job_move_courier_country=$DB->query($Query_q); 

$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_jo= "SELECT *  from tbl_courier_charges_country where state='Others' ";
   $Query_job_move_courier_country=$DB->query($Query_jo); 

$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;
													  $new_kilo_4=$courier_fees_country_1;
													}
													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);
   $new_kilo_4=$courier_fees_country_1;
													
													}
  
}

 $subtotal_123;


   $new_courier=(($courier_fees*$new_kilo_6)+$packing_charges);
  
  
  /*shipping*/
												 
												 
												 if($no_oo>0)
	{

											   
											   if($orderstatus==0)
											   {
											   $par_status="Placed";
											   }
											   if($orderstatus==1)
											   {
											   $par_status="Confirmed";
											   }
											   if($orderstatus==2)
											   {
											   $par_status="Dispatched";
											   }
											    if($orderstatus==3)
											   {
											   $par_status="Delivered";
											   }
											   
											   if($orderstatus==4)
											   {
											   $par_status="Refund";
											   }
											   
											   if($orderstatus==5)
											   {
											   $par_status="Packed";
											   }
											   
												   
					//sprintf("%02d", $to_hour);
					
					$mala_pundai =$row['name'];
					$pundai_name=	$rowsss['dif_name'];
					
					
					 $row['phone'];
					
					if($pundai_name=="name")
					{
					
					$mala_pundai_name =$row['name'];
					}
					else
					{
					
					$mala_pundai_name =	$rowsss['dif_name'];
					}
					
					$pundai_phone=$rowsss['dif_phone'];
					
					if($pundai_phone=="phone")
					{
					
					$mala_pundai_phone =$row['phone'];
					}
					else
					{
					
					$mala_pundai_phone =	$rowsss['dif_phone'];
					}
					
					
												//$pundai_phone=	$rowsss['dif_phone'];
												
																	  
	

	?>
			
			
			<?php /*?><?php
			if($nsssss_pundai_id>0)
			{
			?>
            <tr class="gradeX">
			
			<?php
			}
			else
			{
			
			?>
			<tr class="gradeX" style="color:#990066">
			<?php
			
			}
			?><?php */?>
			     
				 
				 
				 <?php
			if($orderid_coun=="India")
			{
			?>
            <tr class="gradeX">
			
			<?php
			}
			else
			{
			
			?>
			<tr class="gradeX" style="color:#FF0000">
			<?php
			
			}
			?>

			<td><?php echo $nsssss;?></td>
			
			
                <td><a href="order_details.php?id=<?php echo $rowsss['orid'];?>&ids=<?php echo $_REQUEST['retu'];?>"><?php echo $rowsss['refid'];?></a></td>
				
				<td><?php echo $rowsss['order_date_time'];?></td>
				<td><?php  strtoupper($mala_pundai_name);
				echo $mala_pundai_name= ucwords($mala_pundai_name);
				?>
				
				</td>
				<td><?php echo strtoupper($rowsss['state']);?></td>
				<td><?php echo $mala_pundai_phone;?></td>
			
               <?php if($_REQUEST['retu']==24)
				{
				?>
				 <td><?= $rowsss['deliverydate']; ?></td>
				 
				 <?php
				 }
				 ?>
               
               <?php if($_REQUEST['retu']==24)
				{
				?>
				<td><?php echo $rowsss['returned_reason'];?></td>
				<td>
				<button type="button" class="btn-primary" data-toggle="modal" data-target="#exampleModal<?php echo $pundai_order_id;?>">

		
Select Courier
</button>


<div class="modal fade" id="exampleModal<?php echo $pundai_order_id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel"><?= $rowsss['refid'] ?></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
	  
	  <script type="text/javascript">
	  function  validation_<?php echo $pundai_order_id;?>(){
	
	
//alert(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value);

if(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please Select the Courier Name");
document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.focus();
return false;
}

if(document.register_<?php echo $pundai_order_id;?>.c_no_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please enter the Courier No");
document.register_<?php echo $pundai_order_id;?>.c_no_<?php echo $pundai_order_id;?>.focus();
return false;
}


}
</script>
	 
	  <form name="register_<?php echo $pundai_order_id;?>" method="post" onSubmit="return validation_<?php echo $pundai_order_id;?>();" class="form-horizontal" enctype="multipart/form-data" >
      <div class="modal-body">
	  
        <div class="form-group"><label class="col-sm-2 control-label">Courier</label>

                                    <div class="col-sm-10">
									<?php
									$c_name=$rowsss['couriername'];
									
									?>
									
									
									
									
									
									<select class="form-control m-b" name="courier_status_<?php echo $pundai_order_id;?>" >
									<option value="">Select</option>
									
									<?php
									 $Query_courier = "SELECT * from tbl_courier ";
                                               $namesss_qurier=$DB->query($Query_courier);
											   
											   
											   
											   while ($rowsss_qurier = mysql_fetch_array($namesss_qurier)) {
											   $new_co=$rowsss_qurier['courier_name'];
											   
											   ?>
											   
	   <option class="form-control"     value="<?php echo $new_co;?>" <?php if($c_name==$new_co) { ?>  selected="selected" <?php } ?>>
	   
	   <?php echo $rowsss_qurier['courier_name'];?></option>										   
											   <?php
											   }
											   ?>



 
									
 <!--<option class="form-control"     value="Franch Express" <?php if($c_name=="Franch Express") { ?>  selected="selected" <?php } ?>>Franch Express</option>
 <option class="form-control"      value="DHL Express" <?php if($c_name=="DHL Express") { ?>  selected="selected" <?php } ?>>DHL Express</option>
 <option class="form-control"      value="Professional" <?php if($c_name=="Professional") { ?>  selected="selected" <?php } ?>>Professional</option>
 <option class="form-control"      value="India Post" <?php if($c_name=="India Post") { ?>  selected="selected" <?php } ?>>India Post</option>
 
 <option class="form-control"      value="Dtdc"  <?php if($c_name=="Dtdc") { ?>  selected="selected" <?php } ?>>Dtdc</option>
 
 <option class="form-control"      value="Blue Dart" <?php if($c_name=="Blue Dart") { ?>  selected="selected" <?php } ?> >Blue Dart</option>
 <option class="form-control"      value="Trackon" <?php if($c_name=="Trackon") { ?>  selected="selected" <?php } ?> >Trackon</option>
 <option class="form-control"      value="Dunzo" <?php if($c_name=="Dunzo") { ?>  selected="selected" <?php } ?> >Dunzo</option>
 <option class="form-control"      value="Doubt" <?php if($c_name=="Doubt") { ?>  selected="selected" <?php } ?> >Doubt</option>-->
 
   
   
                                </select>
								
									<!--<input type="text" name="product_name_<?php echo $kkkasss;?>" value=""  class="form-control">-->
									
																		</div>
                                </div>
								<div class="hr-line-dashed"></div>
								
								<br />
								
								
								<div class="form-group"><label class="col-sm-2 control-label">Courier Amount</label>

                                    <div class="col-sm-10"><input type="text" maxlength="5" name="courier_amount" id="courier_amount" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<br />
								
								
								<div class="form-group"><label class="col-sm-2 control-label">Courier No</label>

                                    <div class="col-sm-10"><input type="text" name="c_no_<?php echo $pundai_order_id;?>" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <!--<button type="button" class="btn btn-primary">Save changes</button>-->
		

		<input type="submit" class="btn btn-primary" name="sumbit" id="login"  value="Submit" />
		
		<input type="hidden" name="dis_phone" value="<?php echo $mala_pundai_phone;?>"/>
		
		<?php  $mala_pundai_phone;?>
		
		<input type="hidden" name="v_id_order" value="<?php echo $pundai_order_id;?>"/>
      </div>
	  
	  </form>
    </div>
  </div>
</div>
				
				</td>
				<?php
				}
				?>
				
                <!--<td><span class="label label-primary"><?php echo $par_status;?></span>
                </td>-->
				
				<?php
				$ccc_name=$rowsss['couriername'];
				if($ccc_name=="Franch Express")
				{
				
				$co_url="http://www.franchexpress.com/";
				}
				if($ccc_name=="DHL Express")
				{
				$co_url="https://www.dhl.com/en/express.html";
				}
				if($ccc_name=="Professional")
				{
				$co_url="https://www.tpcindia.com/";
				}
				if($ccc_name=="India Post")
				{
				$co_url="https://www.indiapost.gov.in/vas/Pages/IndiaPostHome.aspx";
				}
				if($ccc_name=="Dtdc")
				{
				$co_url="https://www.dtdc.in/";
				}
				
					if($ccc_name=="Blue Dart")
				{
				$co_url="https://www.bluedart.com/";
				}
				
				if($ccc_name=="Trackon")
				{
				$co_url="https://trackon.in/";
				}
				
				if($ccc_name=="Doubt")
				{
				$co_url="";
				}
				
				if($ccc_name=="Dunzo")
				{
				$co_url="https://www.dunzo.com/chennai";
				}
				
				
				?>
				<?php if($_REQUEST['ids']==2)
				{
				?>
				
				


<div class="modal fade" id="exampleModal<?php echo $pundai_order_id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Status</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
	  
	  <script type="text/javascript">
	  function  validation_<?php echo $pundai_order_id;?>(){
	
	
//alert(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value);

if(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please Select the Courier Name");
document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.focus();
return false;
}

if(document.register_<?php echo $pundai_order_id;?>.c_no_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please enter the Courier No");
document.register_<?php echo $pundai_order_id;?>.c_no_<?php echo $pundai_order_id;?>.focus();
return false;
}


}
</script>
	 
	  <form name="register_<?php echo $pundai_order_id;?>" method="post" onSubmit="return validation_<?php echo $pundai_order_id;?>();" class="form-horizontal" enctype="multipart/form-data" >
      <div class="modal-body">
	  
        <div class="form-group"><label class="col-sm-2 control-label">Courier</label>

                                    <div class="col-sm-10">
									<?php
									$c_name=$rowsss['couriername'];
									
									?>
									
									
									
									
									
									<select class="form-control m-b" name="courier_status_<?php echo $pundai_order_id;?>" >
									<option value="">Select</option>
									
									<?php
									 $Query_courier = "SELECT * from tbl_courier ";
                                               $namesss_qurier=$DB->query($Query_courier);
											   
											   
											   
											   while ($rowsss_qurier = mysql_fetch_array($namesss_qurier)) {
											   $new_co=$rowsss_qurier['courier_name'];
											   
											   ?>
											   
	   <option class="form-control"     value="<?php echo $new_co;?>" <?php if($c_name==$new_co) { ?>  selected="selected" <?php } ?>>
	   
	   <?php echo $rowsss_qurier['courier_name'];?></option>										   
											   <?php
											   }
											   ?>



 
									
 <!--<option class="form-control"     value="Franch Express" <?php if($c_name=="Franch Express") { ?>  selected="selected" <?php } ?>>Franch Express</option>
 <option class="form-control"      value="DHL Express" <?php if($c_name=="DHL Express") { ?>  selected="selected" <?php } ?>>DHL Express</option>
 <option class="form-control"      value="Professional" <?php if($c_name=="Professional") { ?>  selected="selected" <?php } ?>>Professional</option>
 <option class="form-control"      value="India Post" <?php if($c_name=="India Post") { ?>  selected="selected" <?php } ?>>India Post</option>
 
 <option class="form-control"      value="Dtdc"  <?php if($c_name=="Dtdc") { ?>  selected="selected" <?php } ?>>Dtdc</option>
 
 <option class="form-control"      value="Blue Dart" <?php if($c_name=="Blue Dart") { ?>  selected="selected" <?php } ?> >Blue Dart</option>
 <option class="form-control"      value="Trackon" <?php if($c_name=="Trackon") { ?>  selected="selected" <?php } ?> >Trackon</option>
 <option class="form-control"      value="Dunzo" <?php if($c_name=="Dunzo") { ?>  selected="selected" <?php } ?> >Dunzo</option>
 <option class="form-control"      value="Doubt" <?php if($c_name=="Doubt") { ?>  selected="selected" <?php } ?> >Doubt</option>-->
 
   
   
                                </select>
								
									<!--<input type="text" name="product_name_<?php echo $kkkasss;?>" value=""  class="form-control">-->
									
																		</div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
								<br />
								
								
								<div class="form-group"><label class="col-sm-2 control-label">Courier No</label>

                                    <div class="col-sm-10"><input type="text" name="c_no_<?php echo $pundai_order_id;?>" value="" class="form-control"></div>
                                </div>
                                <div class="hr-line-dashed"></div>
								
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <!--<button type="button" class="btn btn-primary">Save changes</button>-->
		

		<input type="submit" class="btn btn-primary" name="sumbit" id="login"  value="Submit" />
		
		<input type="hidden" name="dis_phone" value="<?php echo $mala_pundai_phone;?>"/>
		
		<?php  $mala_pundai_phone;?>
		
		<input type="hidden" name="v_id_order" value="<?php echo $pundai_order_id;?>"/>
      </div>
	  
	  </form>
    </div>
  </div>
</div>
				
			
				<?php
				}
				?>
				
				
				 	<?php if($_REQUEST['ids']=="")
				{
				?>
				
				


<div class="modal fade" id="exampleModal<?php echo $pundai_order_id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Add Notes</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
	  
	  <script type="text/javascript">
	  function  validation_<?php echo $pundai_order_id;?>(){
	
	
//alert(document.register_<?php echo $pundai_order_id;?>.courier_status_<?php echo $pundai_order_id;?>.value);

if(document.register_<?php echo $pundai_order_id;?>.c_note_<?php echo $pundai_order_id;?>.value == "")
{
alert("Please Add the Notes");
document.register_<?php echo $pundai_order_id;?>.c_note_<?php echo $pundai_order_id;?>.focus();
return false;
}




}
</script>
	 
	  <form name="register_<?php echo $pundai_order_id;?>" method="post" onSubmit="return validation_<?php echo $pundai_order_id;?>();" class="form-horizontal" enctype="multipart/form-data" >
      <div class="modal-body">
	  
        <div class="form-group"><label class="col-sm-2 control-label">Note</label>

                                    <div class="col-sm-10">
									
									
									<textarea name="c_note_<?php echo $pundai_order_id;?>" class="form-control"></textarea>
									<!--<input type="text" name="c_no_<?php echo $pundai_order_id;?>" value="" class="form-control">-->
								
									<!--<input type="text" name="product_name_<?php echo $kkkasss;?>" value=""  class="form-control">-->
									
																		</div>
                                </div>
                               
								
								
								
								
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
        <!--<button type="button" class="btn btn-primary">Save changes</button>-->
		

		<input type="submit" class="btn btn-primary" name="sumbit_note_para" id="login"  value="Submit" />
		
		<input type="hidden" name="dis_phone" value="<?php echo $mala_pundai_phone;?>"/>
		
		<?php  $mala_pundai_phone;?>
		
		<input type="hidden" name="v_id_order" value="<?php echo $pundai_order_id;?>"/>
      </div>
	  
	  </form>
    </div>
  </div>
</div>
				
				<?php
				}
				?>
				
				
				
               <!-- <td>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
            </tr>
			
			
			
			<?php
			$nsssss=$nsssss-1;
			
			}
			}
			?>
            </tbody>
            <!--<tfoot>
            <tr>
                <th>Rendering engine</th>
                <th>Browser</th>
                <th>Platform(s)</th>
                
            </tr>
            </tfoot>-->
            </table>
			
			
</div>
			<?php		
				}
				?>
            </div>
            </div>
            </div>
            </div>
        </div>
        <div class="footer">
            <div class="pull-right">
                10GB of <strong>250GB</strong> Free.
            </div>
            <div>
                <strong>Copyright</strong> dranbuganapathi.com  &copy; 2019-2020
            </div>
        </div>

        </div>
        </div>

		

    <!-- Mainly scripts -->
	<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>

    <script src="js/jquery-2.1.1.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <script src="js/plugins/metisMenu/jquery.metisMenu.js"></script>
    <script src="js/plugins/slimscroll/jquery.slimscroll.min.js"></script>
    <script src="js/plugins/jeditable/jquery.jeditable.js"></script>

    <!-- Data Tables -->
    <?php
    if($_REQUEST['ids']==3)
		{
		?>
				
    <script src="js/plugins/dataTables/jquery.dataTables.js"></script>
    <script src="js/plugins/dataTables/dataTables.bootstrap.js"></script>
    <script src="js/plugins/dataTables/dataTables.responsive.js"></script>
    <script src="js/plugins/dataTables/dataTables.tableTools.min.js"></script>
  
<?php
		}
?>
    <!-- Custom and plugin javascript -->
    <script src="js/inspinia.js"></script>
    <script src="js/plugins/pace/pace.min.js"></script>

    <!-- Page-Level Scripts -->
    <script>
        $(document).ready(function() {
            $('.dataTables-example1').dataTable({
                responsive: true,
                "dom": 'T<"clear">lfrtip',
                "tableTools": {
                    "sSwfPath": "js/plugins/dataTables/swf/copy_csv_xls_pdf.swf"
                }
            });

            /* Init DataTables */
            var oTable = $('#editable').dataTable();

            /* Apply the jEditable handlers to the table */
            oTable.$('td').editable( '../example_ajax.php', {
                "callback": function( sValue, y ) {
                    var aPos = oTable.fnGetPosition( this );
                    oTable.fnUpdate( sValue, aPos[0], aPos[1] );
                },
                "submitdata": function ( value, settings ) {
                    return {
                        "row_id": this.parentNode.getAttribute('id'),
                        "column": oTable.fnGetPosition( this )[2]
                    };
                },

                "width": "90%",
                "height": "100%"
            } );


        });

        function fnClickAddRow() {
            $('#editable').dataTable().fnAddData( [
                "Custom row",
                "New row",
                "New row",
                "New row",
                "New row" ] );

        }
    </script>
     <script>
        $(document).ready(function(){
            $('.dataTables-example').DataTable({
                pageLength: 25,
                responsive: true,
                dom: '<"html5buttons"B>lTfgitp',
                buttons: [
                    { extend: 'copy'},
                    {extend: 'csv'},
                    {extend: 'excel', title: 'ExampleFile'},
                    {extend: 'pdf', title: 'ExampleFile'},

                    {extend: 'print',
                     customize: function (win){
                            $(win.document.body).addClass('white-bg');
                            $(win.document.body).css('font-size', '10px');

                            $(win.document.body).find('table')
                                    .addClass('compact')
                                    .css('font-size', 'inherit');
                    }
                    }
                ]

            });

        });

    </script>
    <script>
$("#courier_name").on('change', function(){
	var check = $(this).val();
	if(check =='Own Delivery'){
		$('#courier_amount').prop('required',false);
		$('#courier_no').prop('required',false);
	}else{
		$('#courier_amount').prop('required',true);
		$('#courier_no').prop('required',false);
	}
});

</script>
<script>
	$(document).on('click','.mybtn', function(){
		var des = $(this).attr("id");
		var grudge = 'mycap'+des;
   $('#'+grudge).modal("show");
	});
	</script>
	<script>
	$(document).on('click','.close_file', function(){
		var des = $(this).attr("id");
		var grudge = 'file'+des;
		$('#'+grudge).val("");
	});
	</script>
	 <script>
   
            $(".upload_btn").on("click", function() {
                // Prevent the default form submission
                event.preventDefault();
				var des = $(this).attr("id");
				var files = $("#file"+des)[0].files;
		var grudge = 'uploadFile'+des;
		var mechanic = $('#'+grudge);

                // Get the form data
                var formData = new FormData($('#'+grudge)[0]);
				for (var i = 0; i < files.length; i++) {
                    formData.append("files[]", files[i]);
                }

                // Make the AJAX request
                $.ajax({
                    url: "phpaction/process_files.php",
                    type: "POST",
					enctype: 'multipart/form-data',
                    data: formData,
                    processData: false,
                    contentType: false,
                    success: function(response) {
						var grudge1 = 'mycap'+des;
						$('#'+grudge1).modal("hide");
						var dataObj = JSON.parse(response);
                      //  $("#result").html(response);
					  Swal.fire({
  title: dataObj.title,
  text: dataObj.text,
  icon: dataObj.icon,
  button: 'OK',
}).then((response) => {
      // This will be triggered when the user clicks the "OK" button
      location.reload();
    });



                    },
                    error: function(xhr, status, error) {
                        console.error(xhr.responseText);
                    }
                });
            });
     
    </script>
<style>
    body.DTTT_Print {
        background: #fff;

    }
    .DTTT_Print #page-wrapper {
        margin: 0;
        background:#fff;
    }

    button.DTTT_button, div.DTTT_button, a.DTTT_button {
        border: 1px solid #e7eaec;
        background: #fff;
        color: #676a6c;
        box-shadow: none;
        padding: 6px 8px;
    }
    button.DTTT_button:hover, div.DTTT_button:hover, a.DTTT_button:hover {
        border: 1px solid #d2d2d2;
        background: #fff;
        color: #676a6c;
        box-shadow: none;
        padding: 6px 8px;
    }

    .dataTables_filter label {
        margin-right: 5px;

    }
</style>
</body>

</html>
<?php
function calc_ship($tot_weight_2, $new_date, $conn, $shipping_yes_no){

	$get_adc = mysqli_query($conn, "select * from tbl_adc_courier_charges where '$new_date' >= date(start_date) and  '$new_date'<=date(end_date)");
$set_adc = mysqli_fetch_array($get_adc, MYSQLI_ASSOC);

	if($shipping_yes_no == 1){
		$tot_ship = 0;
	}else{
		$int_weight=($tot_weight_2/1000);
		$get_ship = mysqli_query($conn, "select * from shipping_charges where chart_id='".$set_adc['id']."'");
															while($sel_ship = mysqli_fetch_array($get_ship, MYSQLI_ASSOC)){
																if($int_weight <= $sel_ship['weight']){
																	$tot_ship = $sel_ship['total'];
																	break;
																}
															}	
	}
		
														return $tot_ship;
}
?>
<?php
function calc_weight($orderid, $conn){
	
	$get_prods = mysqli_query($conn, "select t3.name, t2.qty, t2.totprice, t3.weight, t3.vstatus, t3.stock_status_id, t1.dif_phone from tbl_confirmorder t1 inner join tbl_order t2 on t1.orid = t2.orderid inner join shop_product t3 on t2.productid = t3.product_id where t1.orid = '$orderid';");
	
		while($get_prod_det = mysqli_fetch_array($get_prods,MYSQLI_ASSOC)){
		
		$get_stat = mysqli_query($conn, "SELECT new_status from `shop_user` where phone='$get_prod_det[dif_phone]'");
		$get_stat_new = mysqli_fetch_array($get_stat, MYSQLI_ASSOC);
		$new_status = $get_stat_new['new_status'];
		$qty = $get_prod_det['qty'];
		$vstatus=$get_prod_det['vstatus'];
 		$weight=$get_prod_det['stock_status_id'];
		if($weight=='' || $weight==0)
if($weight=='' || $weight==0){
$weight=100;
}
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));
		$tot_weight_2 +=$new_qty;
	}
	return $tot_weight_2;
}
function calc_india_shipping($tot_weight_2, $state, $conn){
	
 $new_kilo_41=($tot_weight_2/1000);
$new_kilo_5 = explode('.',$new_kilo_41);
 $new_kilo_6=$new_kilo_5[0];
   $new_state;
   $new_state=$state;
   if($new_state=="Puducherry")
   {
   $packing_charges=0;
   }
   if($new_state=="Tamilnadu")
   {
   $packing_charges=0;
   }
 $Query_job_move_courier= mysqli_query($conn, "SELECT *  from tbl_courier_charges where state='$new_state' ");
$row_job_move_courier= mysqli_fetch_array($Query_job_move_courier, MYSQLI_ASSOC);
 $courier_fees=$row_job_move_courier['amount'];

if($courier_fees=='')
{
 $Query_job_move_courier_1= mysqli_query($conn, "SELECT *  from tbl_courier_charges where state='Others' ");
$row_job_move_courier_1= mysqli_fetch_array($Query_job_move_courier_1, MYSQLI_ASSOC);

 $courier_fees=$row_job_move_courier_1['amount'];

$courier_fees=($courier_fees);

}
   $packing_charges;
	
	return $new_kilo_4=((($new_kilo_6+1)*$courier_fees)+$packing_charges);
	
}
function calc_intl_shipping($tot_weight_2, $new_date, $conn){
	$adc_date = date('Y-m-d', strtotime($new_date));
										
			$get_adc = mysqli_query($conn, "select * from tbl_adc_courier_charges where '$adc_date' >= date(start_date) and  '$adc_date'<=date(end_date)");
			$set_adc = mysqli_fetch_array($get_adc, MYSQLI_ASSOC);
			if($tot_weight_2 !=0){
				$int_weight=($tot_weight_2/1000);
				$get_ship = mysqli_query($conn, "select * from shipping_charges where chart_id='".$set_adc['id']."'");
				while($sel_ship = mysqli_fetch_array($get_ship, MYSQLI_ASSOC)){
					if($int_weight <= $sel_ship['weight']){
						$tot_ship = $sel_ship['total'];
						break;
					}
				}	

				 $new_kilo_4=number_format((float)$tot_ship, 2, '.', '');
					   }else{
						   $new_kilo_4 = 0;
					   }
					   return $new_kilo_4;

}
?>