How to set Laravel Spatie permission setting method to define a set of permissions for each user based on role?

I have 4 types of users using my system: 1. Super Admins 2. Team Super Admins, 3. Administrators and 4. Managing team members, since I use spatie to handle roles and permissions, I have a set of modules (permissions) that are common to all types of users, and another set of modules (permissions) tha...

P粉197639753 2023-11-14 12:58:58 0 1 292

MySQL InnoDB does not free disk space after deleting data rows from table

I have a MySQL table using the InnoDB storage engine; it contains approximately 2M rows of data. When I delete data rows from the table, it does not free the allocated disk space. After running the optimizetable command, the size of the ibdata1 file has not been reduced. Is there any way to reclaim ...

P粉148434742 2023-10-15 00:02:19 0 2 222

What is the way to get the client's IP address in ASP.NET MVC?

I'm completely new to the ASP.NET MVC stack and I'd like to know what's going on with the simple Page object and the RequestServerVariables object? Basically, I want to extract the IP address of the client PC, but I can't understand how the current MVC structure changes this. As far as I know, most ...

P粉232409069 2023-10-14 09:01:56 0 2 220

How to use multiple databases in Laravel

I want to combine multiple databases in my system. Most of the time the database is MySQL; but it may be different in the future, i.e. the administrator can generate such reports, this is the source of using heterogeneous database systems. So my question is does Laravel provide any Facade to handle ...

P粉919464207 2023-10-13 09:54:58 0 2 313

Looking for a php middleware

Is it possible that the data parameter submitted by the post is a piece of json? This json fully meets the requirements of mysql. That is, the node name is the column name and the data type also completely matches. Then can I parse the json in a loop and write it to mysql at once? This way of develo...

果果和多多 2023-10-02 13:14:52 0 0 206

Problems encountered when using strpos() PHP function for information retrieval and cropping

I'm getting raw data from an API that contains a JSON and I'm trying to crop out the JSON-only part from the returned data. I used PHP's strpos() function to write a function to trim the JSON from the beginning (the position of the opening brace) to the end (the position of the closing brace). But I...

P粉692052513 2023-09-21 10:35:25 0 1 263

Console.log returns 'undefined' when trying to update status with fetched data

When I get the data on render or when some dependencies change, it updates correctly into the Reduxstore, but when I console.log it says 'undefined'. I'm developing a booking system and want to get the number of hours booked on a specified date /// Get the data when the component renders and tried u...

P粉925239921 2023-09-21 09:52:52 0 1 240

"Converting JavaScript Variables to PHP: JavasScript variables converted to PHP"

So I'm wondering if there is a way to pass Javascript variables into PHP. I'm making a script that gets a location from a website and inserts this location into MySQL to get some analytics data. This is my Javascript function: functiongetPosition(position){constlatitude=position.coords.latitude;cons...

P粉904405941 2023-09-18 11:50:08 0 1 183

Creating Vertically Connected Dendrograms: Echart Implementation Guide

The code below is an example of using Echart's treemap, I want each series to be arranged in vertical order and then concatenated to each series and then resized based on the data. In this example, each series will be randomized by its size. https://echarts.apache.org/examples/an/editor.html?c=treem...

P粉071559609 2023-09-15 15:25:10 0 1 412

"Laravel One-To-Many relationships require data to be in the Model::all() output"

I'm building an application that contains information about trees. Trees belong to many zones. So to solve this problem, I created two data tables called Trees and TreeZones, which have matching primary keys and foreign keys. I used the "hasMany" and "belongsTo" operators to esta...

P粉310754094 2023-09-14 22:56:53 0 1 346

Select a routing model and store routing data

I'm trying to do something like a comprehensive system of automated activities. The program should have many modules. I plan to organize them according to windows principles. If desired, you can open a new module which you can then close, or open a new module without closing it and return later. For...

P粉949267121 2023-09-14 11:22:24 0 1 287

For MySQL, I need a report of rows that deviate more than 1 standard deviation from the mean (expressed as a percentage)

I'm trying to write a MySQL query to count rows that are significantly different from the most common row for each product and report the percentage difference, with less than 100% having a lower price than that product's average price and more than 100% having a lower price than high. Prices less t...

P粉002572690 2023-09-13 22:06:57 0 1 265

SQL processing to clean and sum duplicate data in joined tables

I'm pulling reports from an accounting system. The system has a nasty habit of putting duplicates in the database, which it handles internally (instead of cleaning them up in the first place!) Take the totals table for invoice 125 as an example: +----- -------+-----------+----------+|invoice_id|code...

P粉354948724 2023-09-13 15:15:50 0 1 228

Compare values in duplicate tables

I have a query that generates a table of duplicate records from a larger data set, and I would like to be able to perform further analysis on this output data. Here's an example of what you can use. I would like to be able to identify, for each property, instances where the property's oldest rating ...

P粉811329034 2023-09-13 08:52:32 0 2 259

Can I add the "with" query option to my model-directed requests?

I have a query, I wrote a query that queries data withlast_sent_atas(Selectoffer_id,lead_id,max(created_at)assent_atFromoffer_historyGroupbyoffer_id,lead_id) and I need to connect it with laravel model system. So I have three tables: leads=>history=>offers and I have a request Lead::with

P粉311563823 2023-09-11 00:37:19 0 1 183

I'm having trouble using polymorphic relationships in Laravel 9.x

I have 5 tables named "Users", "Chats", "Buletins", "Hartas" and "Owners". All these tables have a many-to-many relationship with another table called Medias through a pivot table called Mediaables. I need to use a polymorphic relationship because al...

P粉366946380 2023-09-10 13:33:41 0 1 245

How to convert mcrypt_crypt to openssl_crypt?

I'd like to improve a certain WordPress plugin that uses the now obsolete "mcrypt". Instead, I want to use the OpenSSL library to encrypt the submitted data, but during the encryption process I have problems, namely: the openssl_encrypt function returns a different value than mcrypt_encryp...

P粉287345251 2023-09-09 17:35:02 0 1 211

Rewrite title as: Extract HTML and WordPress shortcodes as array of objects

I'm developing a headless WordPress website using Nuxt as the frontend. The website has thousands of articles with shortcodes. I get all the page data via graphql and render the content using v-html and everything is fine, but the shortcode apparently only renders as plain text. Most of them are ver...

P粉504920992 2023-09-08 11:18:41 0 1 224

Retrieve all data with specific information from pivot table using Eloquent

I have a many to many relationship between users and courses with a pivot table Users_Courses which contains the isComplete value but I can't seem to retrieve the isComplete value without looping through each user and getting their courses and then looping Get pivot data per class. All the examples ...

P粉464208937 2023-09-07 21:40:28 0 1 245

Shortest way to convert all PHP types to string

I'm writing a general system that I hope can one day be applied to fields like medicine (i.e. it's "scientific"). I think the best way is to represent all the data in php with strings (true will be "true", false will be "false" and so on). The reason for this is that in...

P粉369196603 2023-09-05 15:34:44 0 1 359