<?php 
$header_file=APPPATH.'views/include/header.php';
require($header_file);
$this->db2 = $this->load->database('otherdb', TRUE);
?>
<!-- BEGIN: Content-->
<div class="app-content content">
    <div class="content-overlay"></div>
    <div class="content-wrapper">
        <div class="content-header row">
            <div class="content-header-left col-md-12 col-12 mb-2 breadcrumb-new">
                <h3 class="content-header-title mb-0 d-inline-block">Raw Material Consumption</h3>
                <div class="row breadcrumbs-top d-inline-block">
                    <div class="breadcrumb-wrapper col-12">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item">
                                <a href="#">Home</a>
                            </li>
                            <li class="breadcrumb-item">
                                <a href="#">Report</a>
                            </li>
                            <li class="breadcrumb-item active">Raw Material Consumption
                            </li>
                        </ol>
                    </div>
                </div>
            </div>
        </div>
        <div class="content-body"><!-- Zero configuration table -->
            <section id="configuration">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-content collapse show">
                                <div class="card-body card-dashboard">
                                    <div class="table-responsive">
                                        <?php $fdate = date('Y-m-d',strtotime($this->uri->segment(3)));
                                        $tdate = date('Y-m-d',strtotime($this->uri->segment(4)));
                                        $br_id = $this->uri->segment(5);
                                        ?>
                                        <button onclick="method(btn)" class="btn btn-info pull-left" style="margin-bottom: 10px;">Export</button>
                                        <table  id="tableID" border="1" style="border:1px solid!important;" class="table">
                                            <thead>
                                                <tr>
                                                    <th>Item</th>
                                                    <th>O/P</th>
                                                    <th>Inward</th>
                                                    <th>Wstg</th>
                                                    <th>C/L</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                            <?php foreach($rcons as $row)
											{
											?>
											
                                                <tr>
                                                    <td><?php echo $row['item_name']; ?></td>
                                                <td><?php echo $row['opening_stock']; ?></td>
                                                    <td><?php echo $row['tinward']; ?></td>
                                                    <td><?php echo $row['Wastage']; ?></td>
                                                    <td><?php echo $row['closing_stock']; ?></td>
                                                </tr>
                                            <?php } ?>
                                            </tbody>
                                        </table>	
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </div>
</div>
<?php 
    $footer_file=APPPATH.'views/include/footer.php';
    require($footer_file);
?>
<script type="text/javascript">
	$(function() {
		$('.date-picker').datepicker({
			changeMonth: true,
			changeYear: true,
			showButtonPanel: true,
		//	dateFormat: 'MM yy',
		    dateFormat: 'dd-mm-yy',
		/*	onClose: function(dateText, inst) { 
				$(this).datepicker('setDate', new Date(inst.selectedYear, inst.selectedMonth, 1));
			}*/
		});
	});	
</script>
<script>
    $("#branch").change(function (){
		var branch_code = $(this).find("option:selected").text();
		$("#bcode").val(branch_code);
	});
	
	$("#pcategory").change(function (){
		var pcat = $(this).find("option:selected").text();
		$("#pcat").val(pcat);
	});
</script>
</body>
<!-- END: Body-->

<!-- Mirrored from pixinvent.com/modern-admin-clean-bootstrap-4-dashboard-html-template/html/ltr/vertical-modern-menu-template/form-layout-basic.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 27 Apr 2020 09:38:02 GMT -->
</html>