<?
$orders="active";
$quote_cash="active";



?>
<?


require_once '../template/superadmin/action_connection.php' ;
include("../settings/adminsession.php");
session_start();
?>

 

<?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"); ?>
 
 
 <?
 
  $dt2 = date('Y-m-d H:i:s ', time());
   
   
if(isset($_POST['sumbit']))
{
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.""];
   
   
     $Query_pay_date_new = "SELECT * from  shop_cart_admin_demo_1 where session_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'];





$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=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 session_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' );
   $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`) VALUES ('$mysql_insert_id','12','$maxcorderid','$orderid_new_s','$courier_status','0','0','0','','$dt2','name','phone')";
   
   $DB->query($Insert_memberord);	
   
    $attachmentfileid= mysql_insert_id();
	
	
	$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 session_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`='phone' 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 `session_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); 
	 
	 /*new_quert*/
	
  // $inexeord=mysql_query($Insert_memberord);
   //$attachmentfileid = mysql_insert_id();



}


}
?>
 

  
  
  
            <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="#">Quote</a>
                        </li>
                       <!-- <li>
                            <a>Product Details</a>
                        </li>-->
                        <li class="active">
                            <strong><? 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>Ref #</th>
				
				<th>Name</th>
				<th>Quoted Date</th>
				<th>Mobile No</th>
				<th>Country</th>
				<th>Amount</th>
				<th>Edit</th>
				<th>Status</th>
				
            </tr>
            </thead>
            <tbody>
			
			<?php
$si=0;




								
									$table_name="tbl_confirmorder";
									
  $Query = "SELECT * from tbl_job_new    ";
                                               $namesss=$DB->query($Query);
											   
											   $nsssss=mysql_num_rows($namesss);
												$manssss='0';
$kjjj=0;
											   
											   while ($rowsss = mysql_fetch_array($namesss)) {
											   
											   
											    $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);
											   
											   
											   $new_price=	($row_12_new_price['new_price']+$row_12_new['qty_free']);
												 
		
												
											   
											   
											   

			?>
			<tr class="gradeX" style="color:#990066">
			

			<td><? echo $nsssss;?></td>
			
			
                <td>QT<? echo $nsssss;?></td>
				
				<td><? echo $row_12_new['user_id'];?></td>
				<td><? echo $row_12_new['dateadded'];?></td>
				<td><? echo $row_12_new['d_mobile'];?></td>
				
				<td><? echo $row_12_new['del_country'];?></td>
				<td><? echo $new_price;?></td>
				
				<td></td>
				<td>
				<button type="button" class="btn-primary" data-toggle="modal" data-target="#exampleModal<? echo $pundai_order_id;?>">

		
  Paid
</button>


<div class="modal fade" id="exampleModal<? 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_<? echo $pundai_order_id;?>(){
	
	
//alert(document.register_<? echo $pundai_order_id;?>.courier_status_<? echo $pundai_order_id;?>.value);

if(document.register_<? echo $pundai_order_id;?>.courier_status_<? echo $pundai_order_id;?>.value == "")
{
alert("Please Select the Payment Mode");
document.register_<? echo $pundai_order_id;?>.courier_status_<? echo $pundai_order_id;?>.focus();
return false;
}




}
</script>
	 
	  <form name="register_<? echo $pundai_order_id;?>" method="post" onSubmit="return validation_<? 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_<? 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_<? 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="<? echo $mala_pundai_phone;?>"/>
		
		<?  $mala_pundai_phone;?>
		
		<input type="hidden" name="v_id_order" value="<? echo $pundai_order_id;?>"/>
      </div>
	  
	  </form>
    </div>
  </div>
</div>
				</td>
				
				
				
				
				
				
				
				<?
				}
				?>
				
				
				
               <!-- <td>Win 95+</td>
                <td class="center">4</td>
                <td class="center">X</td>-->
            </tr>
			
			
			
			<?
			$nsssss=$nsssss-1;
			
			
			
			?>
            </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>



    <!-- 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>
<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>