i have the following code with only 2 records of data my controller : if (request()->ajax()){ $spareparts = Sparepart::select(DB::raw('DATE_FORMAT(spareparts.created_at,"%d-%m-%Y") as order_date'), DB::raw("CONCAT(users.address, ', ', regencies.name, ', ', districts.name, ', ', provinces.name) as address"), DB::raw("CONCAT(shipping_addresses.full_address, ', ', r.name, ', ', d.name,…
I have a table that i need to filter based on multiple columns, the example i have uses checkboxes to filter on 5 columns, some of the columns are hidden and are not displayed in the table but can still…
Json Data in present format: currently I am getting data from a database in the following format which I am storing in a DataTable. Database format var data1 = [{"TheatreName":"AMEA","Country":"CANADA","Riskcount":50},{"TheatreName":"AMEA","Country":"UK","Riskcount":30},{"TheatreName":"AMER","Country":"Japan","Riskcount":80},{"TheatreName":"AMER","Country":"US","Riskcount":90},{"TheatreName":"APAC","Country":"Bangladesh","Riskcount":4},{"TheatreName":"APAC","Country":"Hong Kong","Riskcount":12},{"TheatreName":"APAC","Country":"India","Riskcount":126}] I want to convert it into a JSON object…
I'm having an issue with mix-blend-mode in my HTML/CSS table. I want to highlight rows and columns in a table when hovering over cells, but the mix-blend-mode effect only works as expected for rows, not columns. I applied mix-blend-mode to…
While Converting the DataTable to Json File, the field with DateTime is converting to a */Date(1722796200000)/*? there is any solution to convert the method to a real datetime or json datetime format "2024-08-05T00:00:00" Structure of DataTable DataTable dt = new…
I help organise a 'golf society' and each week we make a draw to decide who is playing with who, by pulling numbers out of a' hat'. I am in the process of building a website (app) and want to…
I've been trying to create a table that auto fill empty fields depending of the previous information provided but I don't know how to make it possible, do you have any idea? Here's an example of an array of fruits…
I have created a table with DateTables and at first the spaces defined in the table itself were not displayed, which was very important. I fixed it using the html tag pre. Now the problem I have is that when…
I am trying to teach myself ReactJS using PrimeReact. i am making a simple application to track crypto holdings in a wallet i own. i have this code to create a table with base data from a json file: import…
https://phpout.com/wp-content/uploads/2024/03/4PpsO.png This is very unique requirement that I want to make up/down (sort order row) functionality. I can able to do up/down using jQuery but I have required complicated requirement which I tried but can't able to do it. As…