<?php include 'connection.php';

session_start();

if (!isset($_SESSION['is_logged_in'])) {

    header("Location:login.php");

    die();

    }

$query2job = "select * from check_month";
$resultjob = mysql_query($query2job,$conn);
while($rowmonth=mysql_fetch_array($resultjob))
{
$check_month = $rowmonth['check_month'];
}

date_default_timezone_set('Asia/Calcutta');

$today = date("d/m/Y");

$today2 = date("Y-m-d");

$today1 = date("d/m");

$currentmonth = date(m);

date_default_timezone_set('Asia/Calcutta');

$today = date("Y-m-d");

 

							  

$month1=date("m");

if($month1>$check_month)

  {

  $currentyear = date("Y");

 $curr_full_year=date("Y");

$curr_short_year=date("y");

$future=$curr_short_year+1;

} else {

$currentyear1 = date("Y");

$currentyear = $currentyear1-1;

$curr_full_year1=date("Y");

 $curr_full_year=$curr_full_year1-1;

 $curr_short_year1=date("y");



$curr_short_year=$curr_short_year1-1;

$future=$curr_short_year+1;

}

?>





<?   $curr_fy=$currentyear .'-'. $future;?>



 <? include('sahavas_dropdown_function.php');?>



 <!DOCTYPE html>

<html>

<head>

  <meta charset="utf-8">

  <meta http-equiv="X-UA-Compatible" content="IE=edge">

  <title>shigmoda.com</title>

  <!-- Tell the browser to be responsive to screen width -->

 <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">

  <!-- Bootstrap 3.3.6 -->

  <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css"><link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">

  <!-- Font Awesome -->

  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">

  <!-- Ionicons -->

  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

  <!-- daterange picker -->

  <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css">

  <!-- bootstrap datepicker -->

  <link rel="stylesheet" href="plugins/datepicker/datepicker3.css">

  <!-- iCheck for checkboxes and radio inputs -->

  <link rel="stylesheet" href="plugins/iCheck/all.css">

  <!-- Bootstrap Color Picker -->

  <link rel="stylesheet" href="plugins/colorpicker/bootstrap-colorpicker.min.css">

  <!-- Bootstrap time Picker -->

  <link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">

  <!-- Select2 -->

  <link rel="stylesheet" href="plugins/select2/select2.min.css">

  <!-- Theme style -->

  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">

  <!-- AdminLTE Skins. Choose a skin from the css/skins

       folder instead of downloading all of them to reduce the load. -->

  <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>

		<script src="jquery.table2excel.min.js"></script><link rel="stylesheet" href="jquery-ui.css"> <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css"><link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">

  <!-- Font Awesome -->

  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.5.0/css/font-awesome.min.css">

  <!-- Ionicons -->

  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

  <!-- daterange picker -->

  <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css">

  <!-- bootstrap datepicker -->

  <link rel="stylesheet" href="plugins/datepicker/datepicker3.css">

  <!-- iCheck for checkboxes and radio inputs -->

  <link rel="stylesheet" href="plugins/iCheck/all.css">

  <!-- Bootstrap Color Picker -->

  <link rel="stylesheet" href="plugins/colorpicker/bootstrap-colorpicker.min.css">

  <!-- Bootstrap time Picker -->

  <link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">

  <!-- Select2 -->

  <link rel="stylesheet" href="plugins/select2/select2.min.css">

  <!-- Theme style -->

  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">

  <!-- AdminLTE Skins. Choose a skin from the css/skins

       folder instead of downloading all of them to reduce the load. -->

  <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>

		<script src="jquery.table2excel.min.js"></script><link rel="stylesheet" href="jquery-ui.css">



  <script src="jquery-ui.js"></script>




   <style>

  table {

  border: 1px solid #ccc;

  border-collapse: collapse;

  margin: 0;

  padding: 0;


}

table caption {

  font-size: 1.2em;

  margin: .5em 0 .75em;

}

table tr {

  

  border: 1px solid #ddd;

  padding: .35em;

}

table th,

table td {

  padding: .625em;

  

}

table th {

  font-size: 13px;;

  letter-spacing: 0em;

  text-transform: capitalize; margin-right:5px;

}

@media screen and (max-width: 600px) {

  table {

    border: 0;

  }

  table caption {

    font-size: 1.8em;

  }

  table thead {

    border: none;

    clip: rect(0 0 0 0);

    height: 1px;

    margin: -1px;

    overflow: hidden;

    padding: 0;

    position: absolute;

    width: 1px;

  }

  table tr {

    border-bottom: 3px solid #ddd;

    display: block;

    margin-bottom: .625em;

  }

  table td {

    border-bottom: 1px solid #ddd;

    display: block;

    font-size: .9em;

    

  }

  table td:before {

    /*

    * aria-label has no advantage, it won't be read inside a table

    content: attr(aria-label);

    */

    content: attr(data-label);

    float: left;

    font-weight: bold;

    text-transform: uppercase;

  }

  table td:last-child {

    border-bottom: 0;

  }

}



  .style1 {color: #000066}

  </style> 





</head><link rel="stylesheet" href="jquery-ui.css">

<body class="hold-transition skin-blue sidebar-mini">

<div class="wrapper">

<?php depat_check($department_name,$designation);?>



	

<div class="content-wrapper">

    <!-- Content Header (Page header) --->



<section class="content-header">

      <h1>

Invoice  Report  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<? back_toindex($department_name,$designation);?>

        

      </h1>

	  </section>

   

	

			

<section class="content"> 

<div class="row">

 <div>

		

					

			<div class="col-sm-12" id="squareboxcontent1" style="">

				<div class="filter-view">

					<div class="table-responsive">

						<form name="frmSearch" method="post" action="report_services.php">

						

			<table width="100%" class="table2excel table table-striped table-bordered table-hover" data-tableName="Test Table 1">		
					
					



  	<tr>	<td bgcolor="#e6e6e6" colspan="2">Consignor</td>

			<td bgcolor="#e6e6e6" colspan="2">Consignee</td>
			<td bgcolor="#e6e6e6" colspan="2">Vehicle No</td>

			<td bgcolor="#e6e6e6" colspan="2">Articles No.</td>

			<td bgcolor="#e6e6e6" colspan="2">Loaded</td>
			<td bgcolor="#e6e6e6" colspan="2">Booking No.</td>

<td bgcolor="#e6e6e6" colspan="2">Shipping Agent</td>

			<td bgcolor="#e6e6e6" colspan="2">Seal No.</td>

									<td bgcolor="#e6e6e6" colspan="2" >Destination</td>
									<td>#</td>

									
								  </tr>  
								      </thead>

				<tbody>

					<?php
                                    $i=1;
                                      $queryls = "select * from challan2";
                                        $resultls = mysql_query($queryls,$conn);
                                     while($row=mysql_fetch_array($resultls))
                                                   {
                                      $challan_id = $row['challan_id'];
       


	$consignor_name= $row['consignor_name'];
$consignee_name= $row['consignee_name'];
$vehicle_no= $row['vehicle_no'];
$articles_no= $row['articles_no'];
$loaded= $row['loaded'];
$seal_no= $row['seal_no'];
$destination= $row['destination'];
$shipping_agent= $row['shipping_agent'];
$booking_no= $row['booking_no'];
	
                                                
													
 ?>										



	

		 <tr>
		 	<td colspan="2"><?php echo $consignor_name;?></td>

		   <td colspan="2"><?php echo $consignee_name;?></td>
		   <td colspan="2"><?php echo $vehicle_no;?></td>

						<td colspan="2"><?php echo $articles_no; ?></td>

								  <td colspan="2"><?php echo $loaded;?></td>
								  <td colspan="2"><? echo $booking_no;?></td>
								  <td colspan="2"><? echo $shipping_agent;?></td>
								  <td colspan="2"><? echo $seal_no;?></td>
								  <td colspan="2"><? echo $destination;?></td>
								  <td><a href="print_pws_challan.php?challan_id=<? echo $challan_id?>"style="color:#0000FF" data-toggle="modal"><button type="button" class="btn btn-success">Print</button></td>
								  							

									
								 </tr><?php $i++; }?>

</tbody>
</table>
</form>
</div>
</div>
</div>
</div>
</div>
</section>
</div>
</div>


    <script src="dist/js/app.min.js"></script>



		<script src="plugins/sparkline/jquery.sparkline.min.js"></script>

<!-- jvectormap -->

<!-- SlimScroll 1.3.0 -->

<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>

<!-- AdminLTE for demo purposes -->

<script src="dist/js/demo.js"></script>

<!-- Bootstrap 3.3.6 -->

<!-- FastClick -->

<!-- AdminLTE App -->