Viewing file: transaction.blade.php (11.52 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
@extends('layouts.app', ['title' => __('Add user')])
@section('content') @include('users.partials.header', [ ]) <style> .js-example-placeholder-single{ height:32px; } .fil_select{ margin:3px; width:19%; } </style> <div class="container-fluid mt--7"> <div class="row"> <div class="col"> <div class="card shadow"> <div class="card-header border-0"> <div class="row align-items-left"> <div class="fil_select" style="margin-bottom:6px;"> <input type="text" class="form-control" id="vmsisdn" placeholder="{{ __('Enter Vmsisdn') }}" style="height: 30px;"> <!-- <select class="js-example-placeholder-single js-states form-control" name="vmsisdn" id="vmsisdn" > <option selected value="all">All (Vmsisdn)</option> <option value="Level 3">Level 3</option> <option value="Level 2">Level 2</option> <option value="Level 1">Level 1</option> </select> --> </div> <div class="fil_select" style="margin-bottom:6px;"> <select class="js-example-placeholder-single js-states form-control" name="hook" id="hook" > <option selected value="all">All (Hook)</option> <option value="yes">YES</option> <option value="no">NO</option> </select> </div> <div class="fil_select" style="margin-bottom:6px;"> <select class="js-example-placeholder-single js-states form-control" name="pid" id="pid" > <option selected value="all">All (PID)</option> @if(isset($pid_list)) @foreach($pid_list as $pid_list) <option value="{{$pid_list->pid}}">{{$pid_list->pid}}</option> @endforeach @endif <!-- <option value="Level 3">Level 3</option> <option value="Level 2">Level 2</option> <option value="Level 1">Level 1</option> --> </select> </div> <div class="fil_select" style="margin-bottom:6px;"> <select class="js-example-placeholder-single js-states form-control" name="campaign_id" id="campaign_id" > <option selected value="all" >All (Campaign) </option> @if(isset($campaignid_list)) @foreach($campaignid_list as $campaignid_list) <option value="{{$campaignid_list->campaignid}}">{{$campaignid_list->campaignid}}</option> @endforeach @endif </select> </div> <div class="fil_select" style="margin-bottom:6px;"> <select class="js-example-placeholder-single js-states form-control" name="zone_id" id="zone_id" > <option selected value="all">All (Zone)</option> @if(isset($zoneid_list)) @foreach($zoneid_list as $zoneid_list) <option value="{{$zoneid_list->zoneid}}">{{$zoneid_list->zoneid}}</option> @endforeach @endif </select> </div> </div> <div class="row align-items-left"> <div class="fil_select" style="margin-bottom:6px;"> <select class="js-example-placeholder-single js-states form-control" name="message" id="message" > <option selected value="all">All (Message)</option> <option value="yes">YES</option> <option value="no">NO</option> </select> </div> <div class="fil_select" style="margin-bottom:6px;"> <select class="js-example-placeholder-single js-states form-control" name="msisdn" id="msisdn" > <option selected value="all">All (Vmsisdn)</option> <option value="yes">YES</option> <option value="no">NO</option> </select> </div> <div class="col-md-4" style="margin-top:3px;"> <div class="date" style="width:40%; display: inline-block;"> <!-- <label class="date_label" for="from_date" style="display: inline-block;">From:</label> --> <input class="form-control" type="date" id="from_date" name="from_date" style="width:100%; display: inline-block; height: 30px;" value="{{ date('Y-m-d') }}" > </div> <div class="date" style="width:56%; display: inline-block;"> <label class="date_label" for="to_date" style="display: inline-block;">To</label> <input class="form-control" type="date" id="to_date" name="to_date" style="width:70%; display: inline-block; height: 30px;" value="{{ date('Y-m-d') }}"> </div> </div> <div class="col-1 text-left"> <button class="btn btn-sm btn-primary" id="date_filter" onclick="searchByDate()" >Submit</button> </div> <div class="col-2 text-left"> <p style="font-size:20;">Total Count :<span id="total_count"></span></p> </div> </div> </div> <div class="col-12"> </div>
<div class="table-responsive" style="max-height:450px;overflow: scroll"> <table class="table align-items-center table-flush" > <thead class="thead-light"> <tr> <th scope="col">Time</th> <th scope="col">Country</th> <th scope="col">Region</th> <th scope="col">Campaign</th> <th scope="col">Zone</th> <th scope="col">Carrier</th> <th scope="col">Cost</th> <th scope="col">Message</th> <th scope="col">pid</th> <th scope="col">Vmsisdn</th> <th scope="col">Hooked</th> </tr> </thead> <tbody id="tabledata"> @foreach($transaction as $value) <tr> <td>{{$value['time']}}</td> <td>{{$value['country']}}</td> <td>{{$value['region']}}</td> <td>{{$value['campaignid']}}</td> <td>{{$value['zoneid']}}</td> <td>{{$value['carrier']}}</td> <td>{{$value['cost']}}</td> <td>{{$value['message']}}</td> <td>{{$value['pid']}}</td> <td>{{$value['vmsisdn']}}</td> <td>{{$value['hooked']}}</td> <!-- <td><button type="button" class="btn btn-info btn" data-toggle="modal" data-target="#payment-modal" id="btn_payment" onclick="payment_modal_open('{{$value[0]}}','{{$value[3]}}')" >Payment</button></td> --> </tr> @endforeach </tbody> </table> </div>
<!-- {{--New coustomer modal end--}} --> <div class="card-footer py-4"> <nav class="d-flex justify-content-end" aria-label="..."> </nav> </div> </div> </div> </div> @include('layouts.footers.auth') </div> @endsection <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script> $.ajaxSetup({ headers: { 'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content') } }); $( document ).ready(function() { $(".js-example-placeholder-single").select2({ placeholder: "Select a state", // minimumResultsForSearch: 5 allowClear: false }); }); function searchByDate() { var from_date=document.getElementById("from_date").value; var to_date=document.getElementById("to_date").value; var vmsisdn=$("#vmsisdn").val(); var hook=$("#hook").val(); var pid=$("#pid").val(); var campaign_id=$("#campaign_id").val(); var zone_id=$("#zone_id").val(); var msisdn =$("#msisdn").val(); var message=$("#message").val(); // console.log(from_date+"=="+to_date+"=="+vmsisdn+"=="+hook+"=="+pid+"=="+campaign_id+"=="+zone_id+"=="); if (from_date===""|| to_date==="") { alert("No date is selected") } else{ $.ajax({ type: "POST", url: "{{ route('report.transaction') }}", data: {'_token': '{{csrf_token()}}','from_date':from_date,'to_date':to_date,'vmsisdn':vmsisdn,'hook':hook,'pid':pid,'campaign_id':campaign_id,'zone_id':zone_id,'msisdn':msisdn,'message':message},
// cache:false, success: function(response){ // $("#payment").html(response) // $("#payment-modal").modal('hide'); // location.reload(); $("#total_count").text(response.length); $("#tabledata").empty(); for(var i=0;i<response.length;i++){ // console.log(response[i][j]); $("#tabledata").append('<tr><td>' + response[i].time+ '</td><td>'+ response[i].country + '</td><td>'+ response[i].region + '</td><td>'+ response[i].campaignid +'</td><td>'+ response[i].zoneid +'</td><td>'+ response[i].carrier +'</td><td>'+ response[i].cost +'</td><td>'+ response[i].message +'</td><td>'+ response[i].pid +'</td><td>'+ response[i].vmsisdn +'</td><td>'+ response[i].hooked +'</td></tr>'); } }, error: function(){ alert("Error"); } }); } } </script>
|