Please ask for an eloquent related query in laravel

Table structure {code...} Now we need to query the permission_id list in the permission table based on the user_id in the Auth::user()->id where role table and then based on the role_id. . . How to write this using eloquent?

ringa_lee 2017-05-16 16:55:49 0  2  403

MySql and SQL settings before update trigger Updates of different tables/columns cannot update tables in stored functions/triggers

I have a join table with 2 tables (A and C) with n:m relationship. The connection table (B) also holds some information. A-----B------C In table A, I have a when_modified column that I always want to keep up to date if anything changes. This should include changes on Table B. So I have a pre-update ...

P粉677684876 2023-09-14 21:54:36 0  1  586

Regarding php business logic and mysql optimization issues

There is a usr table that stores uid, username business table 1, the stored information includes field uid, username business table 2, the stored information is only uid, (multiple data in business table 2 corresponds to one piece of data in business table 1) Existing: Query Traverse business table ...

赵。。。。赵得住 2018-07-11 11:43:28 0  3  1210

java - How to optimize the interface to return large amounts of data?

Requirement description: The peripheral platform calls the interface to query the user's song list recommendation information based on the mobile phone number. Each user will have about a thousand pieces of recommendation information. Each piece of recommendation information includes the fields of s...

世界只因有你 2017-05-17 10:00:33 0  4  938

How to manage MySQL slow queries when comparing two tables in a master-detail relationship: A step-by-step guide

Please help me.. I have a query as follows: This is a table: delivery_orderdelivery_order_itembstbst_item I want to show items that exist in delivery_order/item table but not in bst/item table, comparing based on KODE_BARANG and JUMLAH. I have the query below, but it's still very slow if there's alr...

P粉724256860 2023-09-13 16:56:06 0  1  488

MySQL: How to use CASE with ORDER BY clause

I have a stored procedure that has to return a table after filtering rows based on input. Two of the inputs are sort_column and sort_dir. The query must ORDERBY sort_column in the sort_dir direction (ASC or DESC). I tried the following query without success. The query below has been simplified to in...

P粉463291248 2023-11-01 17:44:15 0  1  659

mysql - How to implement multi-table association query?

{Code...} The above are three tables in the database, related through UserID. Table A is a user login information table with LogID as the primary key; Table B stores user active status, and Table C stores user geographical location information. Now I want to get the cumulative sum of the number of o...

巴扎黑 2017-07-04 13:44:12 0  1  1123

The "v-model" directive requires valid attribute values ​​as LHS

I have a Vue application and I have a table where each row has its own id. I then need to show/hide some elements based on a condition in the v-model directive which compares the row ID to the value in the model. The code looks like <b-loadingv-model="actionLoading===table.row.id">&l...

P粉011912640 2024-03-27 15:53:34 0  1  456

About querying the picture of another table corresponding to the product table id based on the product table id

Teacher, based on the product table id, query the picture corresponding to the product table id in another table. Is there any other way to achieve this? Give me some ideas. I think all the methods are written in the public folder. If you re-assign another field in the volist loop, it doesn't seem t...

靖哥哥 2019-05-29 11:47:49 0  2  1321

Get the start date and end date of the creation time

Need help, I need to get start_date and end_date from creation_time based on is_active status. I tried several queries but didn't get the correct results. Table example iduser_id name leader_nameis_active creation time 629DFAS02021-10-1062029DFRB02022-02-09108829DFAS12022-06-30 The result should loo...

P粉265724930 2024-02-21 18:25:26 0  1  443

Experiment with sorting after query limit

So this is my first question here, please forgive me if something is wrong. I'm trying to make a sort query based on constraints. So there is a Customers table with 90 records. I want to first perform a query limited to 3 records, and then sort the results of this query by a column called ContactNam...

P粉237125700 2023-09-05 14:46:42 0  1  724

The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values

EDIT: The formula should be the "value" column - the "value" column with the lowest user_id based on the category. So row 2 will be 0.04 because the "value" column of the lowest "user_id" for category "A" is 0.01. Feel sorry. I want to retrieve every...

P粉178894235 2024-04-06 21:23:40 0  2  872

Safe way to update mysql table entries using dictionary in python (prevent SQL injection)

I'm writing a helper function for my web application that updates the database based on some information obtained from an external API (not user input). I have the following code, but it is marked as "unsafe" by the Banditpython package. Ideally I could write a function in a way that hardc...

P粉627427202 2023-09-08 20:06:07 0  1  698

cypress - How to get selection element by selected value?

I'm trying to use Cypress in a Vue project. I have a page that has a table with many rows. Each row has a selection label. This selection label has different options and the current status of each row, such as: "Processing", "Awaiting review", etc. By changing this, there are som...

P粉034571623 2023-09-01 14:36:33 0  1  574

Ways to fix issue 2003 (HY000): Unable to connect to MySQL server 'db_mysql:3306' (111)

I recently tried to containerize my FastAPIPython server (also for replication/doubling purposes). Before, I had just a MySQL server in a Docker container and everything was fine, but when I also made my web server a service, it couldn't connect to the MySQL server, so now the application doesn't wo...

P粉178132828 2023-09-05 11:18:47 0  1  822

CSS Grid: Create new row when child content overflows column width

I have a two column layout based on CSS grid. When the content of the second column exceeds 1fr I want to create a new row. As it currently stands, the content simply overflows the column. One requirement of this layout is that the items in the right menu column are in one row. I achieve this with: ...

P粉212114661 2023-09-05 15:18:28 0  1  613

PHP full text search functionality using AND, OR and NOT operators

Newbie question: I'm trying to implement a full text search on a search string using php and eloquent. $searchstring="+(victimsuspect)+crime-covid";$searchresult=RssItem::whereRaw("MATCH(description)AGAINST('$searchstring'INBOOLEANMODE)")->ge

P粉076987386 2023-09-05 15:06:32 0  1  577

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  1003

How to get average of DATETIME column in MySQL while grouping by other columns

I'm creating and populating a MySQL table using the following query: SETtime_zone='+00:00';CREATETABLEtimestamp_n_datetime(idINT,timeDATETIME,avg_timeDATETIME);INSERTINTOtimestamp_n_datetime(id,time,avg_time)VALUES("1","2023-01-0310:

P粉460377540 2023-09-05 11:46:21 0  1  506