<?php
$other_orders="active";
$quote_cash="active";



?>
<?php

include '../../include/conf.php';
include '../../include/generate_inv_no.php';
require_once '../template/superadmin/action_connection.php' ;
include("../settings/adminsession.php");
session_start();
?>

 

<?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
 
  $dt2 = date('Y-m-d H:i:s ', time());
   
   
if(isset($_POST['sumbit']))
{
    $professional = array("Andhra Pradesh", "Telangana", "Karnataka", "Kerala");
date_default_timezone_set('Asia/Kolkata');
   
   
    $dt2 = date('Y-m-d H:i:s ', time());
   
  
   
  $v_id_order=$_REQUEST["v_id_order"];;
 
     $courier_status=$_REQUEST["courier_status_".$v_id_order.""];
   
   mysql_query("update tbl_job_new set job_status = 1 where id = '$v_id_order'");
      $Query_pay_date_new = "SELECT * from  shop_cart_admin_demo_1 where v_id='$v_id_order'";

	$name_pay_date_new=$DB->query($Query_pay_date_new);
$row_12_123=mysql_fetch_array($name_pay_date_new);

 

$name=$row_12_123['user_id'];
$productid=$row_12_123['productid'];
$qty=$row_12_123['qty'];
$price=$row_12_123['price'];
$totprice=$row_12_123['totprice'];
$country=$row_12_123['del_country'];
$state=$row_12_123['del_state'];
$address=$row_12_123['del_address'];

$pin=$row_12_123['del_inp'];

 $mobile=$row_12_123['d_mobile'];

if (in_array($state, $professional)) {
    $no_note = "PROFESSIONAL COURIER";
} elseif($del_state !='Tamilnadu') {
    $no_note ="";
}else{
	$no_note="";
}



 $Query="INSERT INTO shop_user(
	 `name` ,
	  `email` ,
	 `password` ,
	 `phone`,
	 `city`,
	 `postcode` ,
	 `country`,
	 `dob`,
	 `address`,
	 `state`,
	 `date`,
	 `gender`,
	 `status`,
	 `skypeid`
	 ) VALUES ('$name','','','$mobile','','$pin','$country','0','$address','$state','$dt2','','1','$mobile')";

	$DB->query($Query);	
	
	 $mysql_insert_id= mysql_insert_id();
	 
	 
	
	
	
	
	/*orderid*/
	
	$objcorderid_new    ="SELECT * FROM `tbl_confirmorder` WHERE varstatus!='Cash' and company_name='Energy Foods' and `orid` in (select orderid from tbl_order)  ";
	
	$name_pay_date_123=$DB->query($objcorderid_new);

	   
   $nosnewcid_new=mysql_num_rows($name_pay_date_123);
 $nosnewcid_new_1=$nosnewcid_new+11;
  $orderid_new_s=generate('2',$conn);
//   $orderid_new_s=HC.$nosnewcid_new_1;
 
 
//$Fetcorderid_new      = mysql_fetch_array($objcorderid_new);

if($nosnewcid_new=='0')
{
	 $maxcorderid='1';
	 $maxcorderid1=HC.$maxcorderid;
}
else
{
 $objmaxcorder_iyya    = "SELECT max(orid)+1 as newordid from tbl_confirmorder ";
//$Fetmaxcorder      = mysql_fetch_array($objmaxcorder);
$row_12_123=$DB->query($objmaxcorder_iyya);
$Fetmaxcorder=mysql_fetch_array($row_12_123);


   $maxcorderid=$Fetmaxcorder['newordid'];
 $maxcorderid1=HC.$maxcorderid;	
}
	
	/*orderid*/
	
	
	
	 $Query_pay_date_new = "SELECT * from  shop_cart_admin_demo_1 where v_id='$v_id_order'";

	$name_pay_date_new=$DB->query($Query_pay_date_new);
$row_12_123=mysql_fetch_array($name_pay_date_new);
   $numrows_ma = mysql_num_rows($name_pay_date_new);
   
   
   
   
   
   
   
   
   if($numrows_ma>0)
{

$date = date_default_timezone_set('Asia/Kolkata');
    $dt2=date('Y-m-d H:i:s' );
	
	if($country!="India")
	{
	$country_id=1;
	}
	else
	{
	$country_id=0;
	}
    $get_new = mysql_query("select * from tbl_job_new where id='$v_id_order'");
	$new_rows=mysql_num_rows($get_new);
	if($new_rows > 0){
		$set_new = mysql_fetch_array($get_new);
		$dage = $set_new['dage'];
		$dgender = $set_new['dgender'];
	}else{
		$dage = NULL;
		$dgender =NULL;
	}


    $get_ship = "select * from tbl_job_new where id='$v_id_order'";
    $set_ship = $DB->query($get_ship);
	$swal_ship = mysql_fetch_array($set_ship);
   
   $Insert_memberord = "INSERT INTO tbl_confirmorder (`userid`,`intsessionid`,`orderid`,`refid`,`varstatus`,`order_tc_id`,`orderstatus`,`res_id`,`type`,`order_date_time`,`dif_name`,`dif_phone`,`country_id`, `need_shipping`, `custom_charge`, `dage`, `dgender`, `no_note`) VALUES ('$mysql_insert_id','12','$maxcorderid','$orderid_new_s','$courier_status','0','0','0','','$dt2','name','phone','$country_id', '$swal_ship[need_shipping]', '$swal_ship[custom_charge]', '$dage', '$dgender', '$no_note')";
   
   $DB->query($Insert_memberord);	
   
    $attachmentfileid= mysql_insert_id();
	
    $update_tbl_job = "update tbl_job_new set job_status=1, refid='$orderid_new_s' where `id`='$v_id_order'";
    /*new_quert*/
    mysql_query($update_tbl_job);

	$Updatecart	=	"UPDATE  tbl_confirmorder SET `orderid`='$attachmentfileid' where orid='$attachmentfileid' ";
	
	 $DB->query($Updatecart);
	 
	 
	 /*new_query*/
	 
	 
	  $objRe_ewq    = "SELECT * from shop_cart_admin_demo_1 where v_id='$v_id_order'";
	  
	  $name_pay_date_new_para=$DB->query($objRe_ewq);

   $numrows_ma = mysql_num_rows($name_pay_date_new_para);
while($Fetchneword      = mysql_fetch_array($name_pay_date_new_para))
{

$del_country=$Fetchneword['del_country'];
$del_city=$Fetchneword['del_city'];
$del_state=$Fetchneword['del_state'];
$del_address=$Fetchneword['del_address'];
$del_inp=$Fetchneword['del_inp'];
$dif_name=$Fetchneword['dif_name'];
$dif_phone=$Fetchneword['dif_phone'];


 "UPDATE  tbl_confirmorder SET `contry`='$del_country',`city`='$del_city',`state`='$del_state',`address`='$del_address',`pin`='$del_inp' where orid='$attachmentfileid' ";
 $Updatecart	=	"UPDATE  tbl_confirmorder SET `contry`='$del_country',`city`='$del_city',`varstatus`='$courier_status',`state`='$del_state',`address`='$del_address',`pin`='$del_inp',`dif_name`='$name',`dif_phone`='$mobile' where orid='$attachmentfileid' ";
 
 $DB->query($Updatecart);
 
$productid= $Fetchneword['productid'];
$qty= $Fetchneword['qty'];
$price= $Fetchneword['price'];
$totprice= $Fetchneword['totprice'];
$date = date_default_timezone_set('Asia/Kolkata');
    $dt2=date('Y-m-d H:i:s' );

   $Insert_member = "INSERT INTO tbl_order(`user_id`,`res_id`,`productid`,`qty`, `price`,`totprice`,`orderdate`,`type`,`session_id`,`ordertime`,`orderid`) VALUES ('$mysql_insert_id','0','$productid','$qty' ,'$price' ,'$totprice','$dt2','','12','','$attachmentfileid')";
   
   $DB->query($Insert_member);	
   
   //$inexe=mysql_query($Insert_member);

}

	
	
	$Delete_Question	=	"DELETE FROM shop_cart_admin_demo_1 WHERE `v_id`='$v_id_order'";

//$Result_Question	=	mysql_query($Delete_Question); 

//$Delete_Question_1	=	"DELETE FROM tbl_job_new WHERE `id`='$v_id_order'";

//$Result_Question_1	=	mysql_query($Delete_Question_1); 
	 $update = "update tbl_job_new set job_status=1, refid='$orderid_new_s' where `v_id`='$v_id_order'";
	 /*new_quert*/
     mysql_query($update);
	
  // $inexeord=mysql_query($Insert_memberord);
   //$attachmentfileid = mysql_insert_id();



}
$message = "Hi ".$name." Your Order ".$orderid_new_s." confirmed.  Once dispatched you will get courier details by SMS. Check order status on our website. 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=ANBUDR&Message='.$message.'&MobileNumbers='.$mobile.'&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);

}
header('Location view_order.php');
?>
 

  
  
  
            <div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-lg-10">
                    <!-- <h2>Quote Details </h2> -->
                    <ol class="breadcrumb">
                    <li>
                            <a href="#">Orders</a>
                        </li>
                        <li>
                            <a href="#">Quote</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 "  >
            <thead>
            <tr>
			
                <th>S.No.</th>
				
				
				<th>Name</th>
				<th>Quoted Date</th>
				<th>Mobile No</th>
				<th>Country</th>
				<th>Amount</th>
                <!-- <th>Notes</th> -->
				<th>Action</th>
				<th>Status</th>
				
            </tr>
            </thead>
            <tbody>
			
			<?php
$si=0;




								
									$table_name="tbl_confirmorder";
									
  $Query = "SELECT * from tbl_job_new where job_status=0    ";
                                               $namesss=$DB->query($Query);
											   
											   $nsssss=mysql_num_rows($namesss);
											  
                                           
											   $si=0;
												$manssss='0';
$kjjj=0;
											   
											   while ($rowsss = mysql_fetch_array($namesss)) {
											    $discount = $rowsss['discount'];
											   
											    $id=$rowsss['id'];
												
												$pundai_order_id=$rowsss['id'];
											   
											    $rowsss['qty_free'];
											   
											    $Query_12_new = "SELECT * from `shop_cart_admin_demo_1` where v_id='$id'   ";
                                               $name_12_new=$DB->query($Query_12_new);
											     
											   $row_12_new = mysql_fetch_array($name_12_new);
											   
											   
											      $row_12_new['qty_free'];
											   
											   
											  $Query_12_new_price = "SELECT sum(totprice) as new_price from `shop_cart_admin_demo_1` where v_id='$id'";
                                               $name_12_new_price=$DB->query($Query_12_new_price);
											     
											   $row_12_new_price = mysql_fetch_array($name_12_new_price);
											   
											   $session_id = $row_12_new['session_id'];
									//	$new_price=	($row_12_new_price['new_price']+$row_12_new['qty_free']);
                                    $curl = curl_init();
                                    curl_setopt_array($curl, array(
                                        CURLOPT_URL => 'https://drganbuganapathi.com/superadmin/order-admin/calc_quote_shipping_charges.php?session_id='.$session_id.'&v_id_must='.$id,
                                        CURLOPT_RETURNTRANSFER => true,
                                        CURLOPT_ENCODING => '',
                                        CURLOPT_MAXREDIRS => 10,
                                        CURLOPT_TIMEOUT => 0,
                                        CURLOPT_FOLLOWLOCATION => true,
                                        CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                                        CURLOPT_CUSTOMREQUEST => 'POST',
                                      ));
                                      
                                      $response = curl_exec($curl);
                                      $data = json_decode($response);
                                      curl_close($curl);

												if(isset($discount)){
                                                    $dis_price = $row_12_new_price['new_price'] * ($discount/100);
                                                }else{
                                                    $dis_price = 0;
                                                }
												 
                                                  $new_price=	($row_12_new_price['new_price'] + $data->shipping - $dis_price);
												
											   
											   
											   

			?>
			<tr class="gradeX" style="color:#990066">
			

			<td><?php echo $si=$si+1;?></td>
			
			
                
				
				<td><?php echo $row_12_new['user_id'];?></td>
				<td><?php echo $row_12_new['dateadded'];?></td>
				<td><?php echo $row_12_new['d_mobile'];?></td>
				
				<td><?php echo $row_12_new['del_country'];?></td>
				<td><?php echo $new_price;?></td>
				<!-- <td><?php echo $rowsss['dnotes'];?></td> -->
				<td><button type="button" class="btn btn-danger btn-sm delete_quote" data-punch="<?= $id ?>"><i class="fa fa-trash"></i></button>&nbsp;
					<a href="<?= htmlspecialchars($row_12_new['url'])?>" target="_blank" class="btn btn-info btn-sm"><i class="fa fa-bars"></i></a>&nbsp;
                    <a href="edit_quote.php?session_id=<?=$row_12_new['session_id']?>&v_id=<?= $row_12_new['v_id']?>" class="btn btn-info btn-sm"><i class="fa fa-edit"></i></a>&nbsp;</td>
				<td>
				<button type="button" class="btn-primary" data-toggle="modal" data-target="#exampleModal<?php echo $pundai_order_id;?>">

		
  Paid
</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">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 Payment Mode");
document.register_<?php echo $pundai_order_id;?>.courier_status_<?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">Payment Mode </label>

                                    <div class="col-sm-10">
									
									
									
									
									
									
									<select class="form-control m-b" name="courier_status_<?php echo $pundai_order_id;?>" >
									<option value="">Select</option>
									
									
									
											   
	   <option value="Cash">Cash</option>
  <option value="Swiping Machine">Swiping Machine</option>
   <option value="G-pay">G-pay</option>
    <option value="Razorpay">Razorpay</option>
    <option value="Payumoney">Payumoney</option>
	 <option value="Bank Transfer">Bank Transfer</option>
	   
	   </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>
      <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>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
            </tr>
			
			
			
			<?php
			
			
			
			
			?>
            </tbody>
            <!--<tfoot>
            <tr>
                <th>Rendering engine</th>
                <th>Browser</th>
                <th>Platform(s)</th>
                
            </tr>
            </tfoot>-->
            </table>
			
			
</div>
            </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>
<!-- set up the modal to start hidden and fade in and out -->

        


    <!-- Mainly scripts -->
    <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 -->
    <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>

    <!-- 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-example').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>
	$(".delete_quote").on('click', function(){
		var id = $(this).attr("data-punch");
	$.ajax({
			type: "POST",
			url: "quote_ajax.php",
      		data: {delete_quote_id : id},
      success: function(resultData){
       alert('The quote got deleted successfully');
       location.reload();
      }
});
	});
</script>
</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>