Server : Apache System : Linux host44.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64 User : vapecompany ( 2719) PHP Version : 7.4.33 Disable Function : NONE Directory : /home/vapecompany/demo.vapecompany.com.bd/resources/views/backend/reports/ |
Upload File : |
@extends('backend.layout.app') @section('content') <style type="text/css"> @media screen and (max-width: 767px){ #dtables_filter{ margin-top: 10px; } } </style> <!-- ============================================================== --> <!-- Page wrapper --> <!-- ============================================================== --> <div class="page-wrapper"> <!-- ============================================================== --> <!-- Bread crumb and right sidebar toggle --> <!-- ============================================================== --> <div class="page-breadcrumb"> <div class="row"> <div class="col-5 align-self-center"> <h4 class="page-title">Sales Report</h4> <div class="d-flex align-items-center"> <nav aria-label="breadcrumb"> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="#">Home</a></li> <li class="breadcrumb-item active" aria-current="page">Reports</li> </ol> </nav> </div> </div> </div> </div> <!-- ============================================================== --> <!-- End Bread crumb and right sidebar toggle --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- Container fluid --> <!-- ============================================================== --> <div class="container-fluid"> <!-- ============================================================== --> <!-- Start Page Content --> <!-- ============================================================== --> <div class="row"> <div class="col-md-12"> <div class="card"> <div class="card-body"> <h4 class="card-title">Price History</h4> <div id="education_fields" class=" m-t-20"></div> <form id="search" method="GET" class="row"> <div class="col-sm-12 col-lg-4"> <div class="form-group row"> <label for="email2" class="col-sm-4 text-right control-label col-form-label">Start Date</label> <div class="col-sm-8"> <input autocomplete="off" id="start_date" name="start_date" value="{{$s_date}}" type="text" class="form-control mydatepicker" placeholder="yyyy-mm-dd"> </div> </div> </div> <div class="col-sm-12 col-lg-4"> <div class="form-group row"> <label for="email2" class="col-sm-3 text-right control-label col-form-label">End Date</label> <div class="col-sm-9"> <input autocomplete="off" id="end_date" name="end_date" value="{{$e_date}}" type="text" class="form-control mydatepicker" placeholder="yyyy-mm-dd"> </div> </div> </div> {{-- <div class="col-sm-12 col-lg-4"> <div class="form-group row"> <label for="email2" class="col-sm-4 text-right control-label col-form-label">Brand</label> <div class="col-sm-8"> <select onchange="get_product()" class="form-control" id="brand" name="brand"> <option value="0">Select Brand</option> @foreach($brands as $brand) <option value="{{$brand->brand_id}}">{{$brand->brand_name}}</option> @endforeach </select> </div> </div> </div> --}} <div class="col-sm-12 col-lg-4"> <div class="form-group row"> <label for="email2" class="col-sm-4 text-right control-label col-form-label">Product</label> <div class="col-sm-8"> <select id="product" name="product" class="form-control select2"> <option value="">Select Product</option> @foreach ($product as $item) <option value="{{ $item -> product_id }}">{{ $item -> product_name }}</option> @endforeach </select> </div> </div> </div> <div class="col-sm-2"> <div class="form-group"> <button id="btnsearch" class="btn btn-success" type="submit" >Search</button> </div> </div> </form> </div> </div> </div> <div class="col-12" id="search_result"> @include('backend.reports.tables.price_history_table') </div> </div> <!-- ============================================================== --> <!-- End PAge Content --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- Right sidebar --> <!-- ============================================================== --> <!-- .right-sidebar --> <!-- ============================================================== --> <!-- End Right sidebar --> <!-- ============================================================== --> </div> <!-- ============================================================== --> <!-- End Container fluid --> @endsection @section('script') <link rel="stylesheet" type="text/css" href="{{url('/public/backend/css/bootstrap-datepicker.min.css')}}"> <script src="{{url('/public/backend/js/bootstrap-datepicker.min.js')}}"></script> <script src="{{url('/public/backend/js/select2.min.js')}}"></script> <script src="{{url('/public/backend/js/jquery.validate.min.js')}}"></script> <script type="text/javascript"> var date = new Date(); var today = new Date(date.getFullYear(), date.getMonth(), date.getDate()); $('.mydatepicker').datepicker({ format: 'yyyy-mm-dd', autoclose: true, todayHighlight: true }); //$( '.mydatepicker').datepicker( 'setDate', today ); function get_product(){ var id=$('#brand').val(); //console.log("{{url('get_productById')}}/"+id); $.ajax({ type : 'POST', url : "{{url('get_productById')}}", data:{brand_id:id}, dataType: 'json', success : function (data) { //var d=JSON.parse(data); var color="<option value=''>Select Product</option>"; $.each(data,function(){ console.log(this.product_id); color +="<option value='"+this.product_id+"'> "+this.product_name+" </option>"; }); // console.log(color); $('#product').html(color); }, error : function (data) { //console.log(data); } }); } //search $("#search").validate({ rules: { start_date: { required: true, }, }, submitHandler: submitForm }); function submitForm(url='') { event.preventDefault(); getdata(); return false; } $('#customer,#division,#district,#product,#start_date,#end_date').change(function(){ getdata(); }) //end search function getdata(page = 1){ //var data1 = new FormData(document.getElementById('search')); var s_date= $('#start_date').val(); var e_date= $('#end_date').val(); var product= $('#product').val(); //if(url == ''){ var url="{{url('admin/price_history')}}?page="+page+"&s_date="+s_date+"&e_date="+e_date+"&product="+product; // } $.ajax({ type : 'GET', url : url, data : {s_date:s_date}, cache:false, //datatype: "json", contentType: false, processData: false, success : function (data) { $("#search_result").html(data); },error: function(response) { console.log(response); } }); } $(document).on('click', '.pagination a',function(event) { event.preventDefault(); $('li').removeClass('active'); $(this).parent('li').addClass('active'); var myurl = $(this).attr('href'); var page=$(this).attr('href').split('page=')[1]; getdata(page); }); </script> @endsection