<?php 
$header_file=APPPATH.'views/include/header.php';
require($header_file);
?>
<!-- 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">Location Wise Report</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">Location Wise Report
                            </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">
                                    	<form autocomplete="off" method="POST" action="<?php echo site_url('ExcelReport/searchLocationWise/');?>">
					            <div class="row">
							<div class="col-md-3">
									<div class="form-group">
										<!--<input class="form-control pickadate datepicker picker__input picker__input--active" type="text" name="fmonth"  id="fmonth" required data-uk-datepicker="{format:'DD-MM-YYYY'}" placeholder="From Date">-->
									<input type="text" name="fmonth" id="fmonth" class="form-control date-picker">
									<?php 
                                    //$my_string = "Hello World!";//echo json_encode($my_string);
									?>
									</div>
								</div>
								<div class="col-md-3">
									<div class="form-group">
										<!--<input class="form-control pickadate datepicker picker__input picker__input--active" type="text" name="tmonth"  id="tmonth" required data-uk-datepicker="{format:'DD-MM-YYYY'}" placeholder="To Date">-->
										<input type="text" name="tmonth" id="tmonth" class="form-control date-picker">
									</div>
								</div>
								<div class="col-md-2">
									<div class="form-group">
										<select id="branch" name="branch" class="form-control select2" >
											<option value="">Branch</option>
											<?php  foreach($branch as $row)
												{
											?>
												<option value="<?php echo $row->branch_id; ?>"><?php echo $row->branch_name; ?></option>
											<?php
												} 
											?>
										</select>
									</div>
								</div>
							
								<div class="col-md-1">
									<div class="form-group">
										<input type="submit" name="submit" class="btn btn-primary " value="Search">
									</div>
								</div>
							</div>
						</form>
                                    <div class="table-responsive">
                                        	<?php
				if(isset($_POST['submit'])) {
					 
					if (isset($result_display)) {
						//echo "<p><u>Result</u></p>";
						if ($result_display == 'No record found !') {
							echo $result_display;
							} else {
						?>
						
						<table class="table table-striped table-bordered dataex-html5-export">
                                            <thead>
                                                <tr>
                                                    <th >Sl No</th>
                                                    <th >Branch</th>
                                                    <th >Item Name</th>
                                                    <th >Opening Stock</th>
                                                    <th >Issue</th>
                                                    <th >Closing Stock</th>
                                                    <th >Price</th>
                                                    <th >Total</th>
                                                    
                                                </tr>
                                                
                                            </thead>
                                        <tbody>
                                            <?php
                                            $branch=$_POST['branch'];
                                                if(isset($result_display) && is_array($result_display) && count($result_display)): $i=1;
						                    	foreach ($result_display as $data) {
                                            ?>
                                            <tr>
                                                <td><?php echo $i; ?></td>
                                                <td><?php echo $data['branchname']; ?></td>
                                                <td><?php echo $data['item_name']; ?></td>
                                               <td><?php echo $data['opening_stock']; ?></td>
                                               <td><?php echo $data['outward']; ?></td>
                                               <td><?php echo $data['closing_stock']; ?></td>
                                               <td><?php echo $data['item_price']; ?></td>
                                               <td><?php echo $data['Total']; ?></td>
                                            </tr>
                                            	<?php
									$i++;
									} ?>
									<?php else:
								?>
								<tr>
									<td colspan="3" align="center" >No Records Found..</td>
								</tr>
								<?php
									endif;
								?>
                                            </tbody>
                                        </table>
						
						<?php }
					}
				}else{ ?>
                                        
                                        <?php } ?>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </div>
</div>
<?php 
    $footer_file=APPPATH.'views/include/footer.php';
    require($footer_file);
?>
<script>
    $('.param_check').each(function() { $(this).on( {'click contextmenu': function() {
        //contextmenu
        var i = $(this).data('value');
        var anchor = $("a");
        var anchorTarget = $(this).parent().find('.parmetre').val();
        var submodid = $(this).parent().find('.submod_id').val();
        var link = $(this).attr('href');
        $(this).attr("href", link + submodid +'/'+anchorTarget);
        location.reload();
        }
        })
    })
</script>  
<script type="text/javascript">
	$(function() {
		$('.date-picker').datepicker({
			changeMonth: true,
			changeYear: true,
			showButtonPanel: true,
			dateFormat: 'MM yy',
			onClose: function(dateText, inst) { 
				$(this).datepicker('setDate', new Date(inst.selectedYear, inst.selectedMonth, 1));
			}
		});
	});	
</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>