<?php 
session_start();
require_once("../../includes/display_internal_user_dryout.inc.php");
require_once("../../includes/functions_internal_user_dryout.inc.php");
$obj = new data();
$connect = $obj->funConnect();
$display = new display();
$display->logout_iu();
$pagename = basename($_SERVER['PHP_SELF']);
$msg = NULL;

if (isset($_REQUEST['selBType']) && $_REQUEST['selBType']!="")
{
	$selBType = $_REQUEST['selBType'];
}
else if(isset($_SESSION['selBType']))
{
	$selBType = $_SESSION['selBType'];
}
else
{
	$selBType = '';
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title><?php $display->title(); ?></title>
<?php $display->favicon(); ?>
<meta content='width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no' name='viewport'>
<?php $display->css(); ?>

<link href="https://cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/buttons/2.2.2/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />


<!-- <link href="../../css/datatables/dataTables.bootstrap.css" rel="stylesheet" type="text/css" /> -->
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
  <script src="../js/html5shiv.js"></script>
  <script src="../js/respond.min.js"></script>
<![endif]-->
</head>
    <body class="skin-blue fixed">
        <!-- header logo: style can be found in header.less -->
        <?php $display->header_tag(); ?>
		<div class="wrapper row-offcanvas row-offcanvas-left">
            <?php $display->leftmenu(7,1); ?>
			<aside class="right-side">                
                <!-- Content Header (Page header) -->
                <section class="content-header">
                    <h1>
                        <i class="fa fa-leaf"></i>&nbsp;Reports&nbsp;&nbsp;&nbsp;&nbsp;<small><div class="headline text-center" id="time" style="color:#000; font-weight:bold; font-size:12px;"></div></small>
                    </h1>
                    <ol class="breadcrumb">
                         <li><a href="../"><i class="fa fa-home"></i> Home</a></li>
                         <li>Reports</li>
						 <li>Chartering</li>
						 <li class="active">Spot Fixtures Report</li>
                    </ol>
                </section>

                <!-- Main content -->
                <section class="content">
				<!--   content put here..................-->
				<div class="box box-primary">
				<h3 style=" text-align:center;">Spot Fixtures Report</h3>
				<form name="frm1" id="frm1" enctype="multipart/form-data" action="<?php echo $pagename;?>"/>
					<div class="row invoice-info" style="margin-left:10px;">
                        <div class="col-sm-3 invoice-col">
						Date From<span style="font-size:10px; font-style:italic;">  (financial year)</span>
							<address>
								<input type="text" name="txtFrom_Date" id="txtFrom_Date" class="form-control" value="" placeholder="dd-mm-yyyy">
							 </address>
						</div>
						
						<div class="col-sm-3 invoice-col">
						Date To<span style="font-size:10px; font-style:italic;">  (financial year)</span>
							<address>
								<input type="text" name="txtTo_Date" id="txtTo_Date" class="form-control" value="" placeholder="dd-mm-yyyy">
							 </address>
						</div>
                        <div class="col-xs-3">
                            Business Type
                            <address>
                             <select name="selBType" id="selBType" class="form-control">
                               <?php echo $obj->getBusinessTypeList1($selBType);?>
                              </select>  
                           </address>                
                        </div><!-- /.col -->
                        <div class="col-sm-3 invoice-col">
						&nbsp;
                            <address>
                              <button type="button" class="btn btn-primary btn-flat" onClick="getData();" >Search</button>
                            </address>
                        </div><!-- /.col -->
					</div>
					<div align="right">
                        <a href="#" title="Pdf" onClick="getExcel();"><button class="btn btn-default" style="margin-right: 5px;" type="button"><i class="fa fa-download"></i>Generate Excel</button></a>
						<!-- <a href="#" title="Pdf" onClick="getPdf();"><button class="btn btn-default" style="margin-right: 5px;" type="button"><i class="fa fa-download"></i>Generate PDF</button></a> -->
					</div>  
					<div style="height:10px;">
						<input name="txttblid" id="txttblid" type="hidden" value="" />
						<input name="txttblstatus" id="txttblstatus" type="hidden" value="" />
						<input type="hidden" name="action" value="submit" />
					</div>
                    
					<div  class="box-body table-responsive" style="overflow:auto">
						<table id="sf_list" class="table table-bordered table-striped dataTable">
							<thead>
							<tr>
								<th align="left" valign="top" width="10%">Sr. No</th>
								<th align="left" valign="top" width="10%">Nom ID</th>
								<th align="left" valign="top" width="10%">Vessel Name</th>	
								<th align="left" valign="top" width="10%">CP Date</th>
								<th align="left" valign="top" width="10%">Owner</th>
								<th align="left" valign="top" width="10%">Broker</th>
								<th align="left" valign="top" width="10%">Owners P&I </th>
								<th align="left" valign="top" width="10%">Charterers  P&I </th>
								<th align="left" valign="top" width="10%">Vessel Type</th>
								<th align="left" valign="top" width="10%">CARGO</th>
								<th align="left" valign="top" width="10%">Cargo  Qty (MT)</th>
								<th align="left" valign="top" width="10%">Load Port</th>
								<th align="left" valign="top" width="10%">Discharge Port</th>
								<th align="left" valign="top" width="10%">Freight (USD)</th>
								
								<th align="left" valign="top" width="10%">Delivery Port</th>
								<th align="left" valign="top" width="10%">Delivery Date</th>
								<th align="left" valign="top" width="10%">DWT</th>
								<th align="left" valign="top" width="10%">GRT</th>
								<th align="left" valign="top" width="10%">NRT</th>
								<th align="left" valign="top" width="10%">Charterers</th>
								<th align="left" valign="top" width="10%">Propel P&I club</th>
								<th align="left" valign="top" width="10%">Redelivery Date</th>
								<!-- <th align="left" valign="top" width="40%">&nbsp;LP&nbsp;Stay  (Days)</th>
								<th align="left" valign="top" width="40%">&nbsp;LP&nbsp;Cargo&nbsp;Ops  (Days)</th>
								<th align="left" valign="top" width="40%">&nbsp;DP&nbsp;Stay   (Days)</th>
								<th align="left" valign="top" width="40%">&nbsp;DP&nbsp;Cargo&nbsp;Ops (Days)</th> -->
								
								
							</tr>

							</thead>
							<tbody id="DivOwner">
								
							</tbody>
							
						</table>
					</div>
				</form>
				</div>
				<!--   content ends here..................-->
                </section><!-- /.content -->
            </aside><!-- /.right-side -->
			
        </div><!-- ./wrapper -->
<?php $display->footer(); ?>
<?php $display->js(); ?>
<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/2.2.2/js/dataTables.buttons.min.js" type="text/javascript"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
	<script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.html5.min.js" type="text/javascript"></script>
	<script src="https://cdn.datatables.net/buttons/2.2.2/js/buttons.print.min.js" type="text/javascript"></script>

	
<script src="../../js/plugins/datatables/dataTables.bootstrap.js" type="text/javascript"></script>
<script src="../../js/timer.js" type="text/javascript"></script>
<link href="../../css/jquery.alerts.css" rel="stylesheet" type="text/css" />
<link href="../../css/datepicker/datepicker.css" rel="stylesheet" type="text/css" />
<script src="../../js/bootstrap-datepicker.js" type="text/javascript"></script>
<script language="JavaScript" type="text/javascript" src="../../js/jquery.alerts.js"></script>
<script type="text/javascript">
$(document).ready(function(){
	
	$("#sf_list").dataTable({
    "iDisplayLength": 100
    });
	
	$('#txtFrom_Date,#txtTo_Date').datepicker({
		format: 'dd-mm-yyyy',
		autoclose: true
	});
});

function getData()
{
	if($("#txtFrom_Date").val() != "" && $("#txtTo_Date").val() != "")
	{
	    var table = $('#sf_list').DataTable();
		if(table != null)$('#sf_list').dataTable().fnDestroy();
		$('#DivOwner').html("");
		$('#DivOwner').html('<tr><td align="center" colspan="11" style="color:red;"><span style="text-align:center;display:block;"><img src="../../img/loading.gif" /></span></td></tr>');


		$.post("options.php?id=19",{txtFrom_Date:""+$("#txtFrom_Date").val()+"",txtTo_Date:""+$("#txtTo_Date").val()+"",selBType:""+$("#selBType").val()+""}, function(html) {
			$('#DivOwner').html("");
			$('#DivOwner').html(html);

			// var new_row = $("<tr class='search-header'/>");
				// $('#sf_list thead th').each(function(i) {
				// var title = $(this).text();
				// var new_th = $('<th style="' + $(this).at.tr('style') + '" />');
				// $(new_th).append('<input type="text" placeholder="' + title + '" data-index="'+i+'"/>');
				// $(new_row).append(new_th);
				// });
				// $('#sf_list thead').prepend(new_row);


				var table = $('#sf_list').DataTable({
							"scrollX": true,
							"searching": true,
							paging: true, 
       
						// dom: 'Bfrtip',
					// buttons: [
					// 	{
					// 		extend: 'excel',
					// 		messageTop: "From Date :  "+$('#txtFrom_Date').val()+" -------- To Date : "+$('#txtTo_Date').val(),			
					// 		title:"Spot Fixture Report",
					// 		sFileName: "Spot Fixture Report",
					// 		className : "text-left",
					// 		customize:function(xlsx){

					// 			var sheet = xlsx.xl.worksheets['sheet1.xml'];

								
					// 			// $('row c[r^="C"]', sheet).attr( 's', '2' );
								
					// 			$('row:eq(2) c', sheet).attr('s','32');
					// 			$('row c', sheet).each(function() {
					// 				$(this).attr('s','2');

					// 			});
							



					// 		// var numero=	$(sheet).find('row c');
					// 		// var table_head=$(numero).parent()[2];

					// 		// $(table_head).find('c').attr('s','32');
								

					// 			// $('row c', sheet).each(function() {
					// 			// 	//select the index of the row
					// 			// 	var numero=$(this).parent().index() ;
					// 			// 	// var residuo = numero%2;
					// 			// 	// if (numero==1){           
					// 			// 	// 	$(this).attr('s','22');//22 - Bold, blue background
					// 			// 	// }else if (numero>1){
					// 			// 	// 	if(residuo ==0  ){//'is t',
					// 			// 	// 	$(this).attr('s','25');//25 - Normal text, fine black border
					// 			// 	// 	}else{
					// 			// 	// 	$(this).attr('s','32');//32 - Bold, gray background, fine black border
					// 			// 	// 	}
					// 			// 	// }
					// 			// });

					// 		}
					// 	}
					
						
					// 		]
						});
				// $("#sf_list").dataTable({
				// "iDisplayLength": 100
				// });
		});
	}else{
		jAlert('Please select Date From & Date To', 'Alert Dialog');
	}
}

function getPdf()
{
	location.href='allPdf.php?id=30&txtFrom_Date='+$("#txtFrom_Date").val()+'&txtTo_Date='+$("#txtTo_Date").val()+'&selBType='+$("#selBType").val();
}

function getExcel()
{
	location.href='allExcel.php?id=10&txtFrom_Date='+$("#txtFrom_Date").val()+'&txtTo_Date='+$("#txtTo_Date").val()+'&selBType='+$("#selBType").val();
}
</script>
		
</body>
</html>