how can i get branch_id value but with different program_id condition? $data = Peserta::where(‘branch_id’,$branch_id) ->select(‘program_id’)->distinct() ->with(‘program’,’branch’); return DataTables::of($data) ->addColumn(‘program’, function ($data) { return $data->program->name; }) ->addColumn(‘action’, function ($data) { $btn = ‘<a href="/halaman-data-peserta-berdasarkan-cabang-dan-program/’.$branch_id.’/’.$data->program->id.’" class="btn btn-sm btn-info"> check </a>’; return $btn; }) ->rawColumns([‘program’,’action’]) ->make(true); Sourc..
Category : datatable
I am a beginner of laravel. I want to join some of the tables and getting it displayed in datatables, I am using yajra datatables. I have three tables which are Area, Branch and Branch Manager. My problem is I want to display Branch table in a blade view, but instead of displaying area_id and ..
The current search input of the datatables using Yajra is just accepting string/numbers that contains with, not starts with. I wanted to make it search by Starts With. Yajra Datatables has a snippet in their docs but I doen’t understand a thing on how to use it: https://yajrabox.com/docs/laravel-datatables/master/starts-with-search Does anyone know how to use this? ..
I am using InfyOmLabs-laravel-generator for my project. that helps me to generate my datatables and it using yajra-laravel-datatables. but i have a problem : my code working on my local machine but when i put my project in the server, all my datatables encounter an error, Invalid JSON response! i checked my response, it is ..
I am using adminLTE package for laravel. I use the datatables plugin, I need to show a column that shows an image in the list, I can’t get it. I have reviewed the documentation and I can’t find help. anyone have any idea about it? Sourc..
I’m developing a big medical project generating thousands of reports and I need to create a custom button for each database page. The picture below contains my table. enter image description here If for example using that data (on the picture) I have 104 entries displayed and on the PDF column a report is generated ..
I have Data table and large data set and want to set server side script to true, it is working fine on localhost but when I moved the code to server it is showing Data table error. I have inspected the loading script it returns page not found and if Serverside is set to false ..
I am a laravel beginner. I currently have a project in progressing which need to have two data tables in one page. In my past project, I only know how to make just a datatable to display ine one view page. For now, I need to have Branch Manager Table and Bus Driver Table to ..
I have been using this table package lately, MedicOneSystems/livewire-datatables and I cannot seem to grab information from pivot tables. public function builder() { return $this->model::query(); } This is in their base livewire controller, then you can create your own controller by using some of the functions they offer you. My problem is that once I ..
I get the serverside data from controller, and get data using ajax. This is my datatable script. // Data table var table = $(‘.data-table’).DataTable({ processing: true, serverSide: true, responsive: true, ajax: "quotation", dom: ‘<"top"fB>rt<"bottom"lip><"clear">’, columns: [{ data: ‘quotation_no’, name: ‘quotation_no’ }, { data: ‘remarks’, name: ‘remarks’ }, { data: ‘quotation_date’, name: ‘quotation_date’ }, { data: ..
I have stats section where I want to show the count of records in datatable, there is filtering option after which datatable records get filteredout, I want to show stats section should update as the data table is filtered. For e.g. if Datatable shows 100 records the count in stats should be 100, if 8 ..
I have a jquery datatable with select date range filter on it and I want to add a custom datepicker. but when I select a date range it dose not apply and it won’t change the datatable records the datatable that i use is Jquery Datatables https://datatables.net/extensions/datetime/examples/integration/datatables.html var minDate , maxDate ; // Custom filtering ..
The exit status code ‘127’ says something went wrong: stderr: "sh: /usr/bin/wkhtmltopdf: not found " stdout: "" command: /usr/bin/wkhtmltopdf –lowquality –margin-bottom ’10mm’ –margin-left ‘0’ –margin-right ‘0’ –margin-top ’10mm’ –orientation ‘landscape’ –no-outline ‘/tmp/knp_snappy61546419828074.33085429.html’ ‘/tmp/knp_snappy615464198289a1.61220237.pdf’. How do I resolve this error? which wkhtmltopdf snappy config Sourc..
Edit and delete button not working with jquery datatable in vue js.Cannot create button on td tag in template,have to create those buttons in jquery function.Bellow is my delete button code. getTests() { this.$http.get(‘http://127.0.0.1:8000/api/getTest’) .then((response) => { $("#myTable").DataTable({ data: response.data.columns, columns: [ { data: "id" }, { data: "name" }, { data: "price" }, { ..
Here loading orders data using below code but it takes too much time to load and I’m also using serverSide and there are only 320 data’s something and TTFB are very high and I also tried "pageLength": 30, "stateSave": true, but same result please let me know how i fix this issue. Controller.php $orders = ..
I am using datatable in Laravel Project. I use it on many pages. But on two pages I need to show almost 20 columns. and it automatically adds a plus sign to show more details. I have filters on table and following is my JavaScript. $(document).ready(function() { initDatatable(‘/deals/deals_table’, ‘deals_table’); }); function quickFilter(elementId) { var fnServerParams ..
I added a search in each column of the table using the initComplete method. But I need to change something, and I don’t know how. How to add search cells to the table header (under the column names); How to make search cells only on the second and third columns, and not on all. public ..
Hellooo i am using a datatable with laravel and I have the following doubt … $query = DB::table(‘categories’)->select(‘id’,’name’,’parent_id’)->orderBy(‘id’); I have this code that returns me all the categories … columns: [ { data: ‘id’ }, { data: ‘image’, render: function ( data, type, row ) { return data ? ‘<img src="/images/product/’+data+’" height="80" width="80">’ : ‘<img ..
I am using laravel and data table here i am using 2 data table in same page. Now i need to filter both at a same time using dropdown. The dropdown filter located out side in my table. one table content revenue another one content Expense for same account number. i also want subtract the ..
I am working with laravel and vuejs I show the data with dataTable, in the mobile version it does not show me the api data, the problem is in the mobile version that is not shown, in the desktop version if the data is shown, the edit buttons do not open in mobile version either. ..
Hi i am working on a Laravel project and setup relationship between the following tables permissions table permissions_modules public function moduleAddPermissions(Request $request, $id) { $model = PermissionsModule::with(‘module_permissions’)->find($id); if ($request->ajax()) { return Datatables::of($model ? [$model] : []) ->addIndexColumn() ->make(true); } return view(‘admin.users.permissions.module_permissions_create’, compact(‘model’)); } what i am trying to do here is open a Module detail ..
I am using Datatables from : https://datatables.net/ My Datatable has column search, so when i resize the window, my column search field dont collpased, they go out. Without Column search it works fine but when i add column search code, i got the responsiveness issue. My Html file : <div class="table-responsive"> <table class="table table-bordered collapsed ..
I used laravel data table. to show some of data from database base on laravel data table. I got a error and i dont understand from where this error come. can any pleease help me what is the issue? Please take a look of the image: https://prnt.sc/1qumgyp https://prnt.sc/1qumj6u Sourc..
I implemented DataTables for my Admin Users Dashboard, but it was working like Search, Order, Show and Entries Buttons are Displaying but not working. Like it was only displaying but not working for my data. For Example, if we search anything it was showing no data available even through the data was there, and even ..
I used Datatables in laravel and getting above warning message Here is my Datatable controller class DatatableController extends Controller { public function index(Request $request) { if ($request->ajax()) { $data = User::select(‘*’); return Datatables::of($data) ->addIndexColumn() ->addColumn(‘action’, function($row){ $btn = ‘<a href="javascript:void(0)" class="edit btn btn-primary btn-sm">View</a>’; return $btn; }) ->rawColumns([‘action’]) ->make(true); } return view(‘datatable’); } } Route ..
Web Development Company
Free Hosting Company
