When a resource has a type field Relationship, especially the BelongsToMany field, a list of associated models is always displayed. That list always has 5 items and their respective "Previous" and "Next" buttons.
For example, if I have a resource of Clientand a relation to another resource Product,
How can I change the number of product rows displayed?
I have this line of code in a relatively simple Laravel command
User::where('nda_approved', 0)->whereRaw('(mod(DATEDIFF(`created_at`,\''.Carbon::now().'\'),7) = 0')->get();
When doing a little test in Tinker, I get the following error
Illuminate/Database/QueryException with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (SQL: select * from
userswherenda_approved= 0 and (mod(DATEDIFF(created_at,'2021-02-09 12:59:09' ),7) = 0)'
However, if I copy the query and paste it directly into Workbench (which is connected to the same database)
select * from `users` where `nda_approved` = 0 and (mod(DATEDIFF(`created_at`,'2021-02-09 12:59:09'),7) = 0)
Everything works fine, and I get the desired rows. Any idea why this happens?
I am using my own tables and models for user registration. The goal is that each user can have their user type information. It sounds very simple. For the purposes of the question, I will only show the necessary code.
my model userlooks like this
class User extends Model implements AuthenticatableContract, AuthorizableContract
{
use Authenticatable, Authorizable;
protected $fillable = [
'token',
'active',
];
protected $hidden = [
'password',
];
/**
* Get the Person record associated with the user.
*/
public function person()
{
return $this->hasOne(Person::class, 'id');
}
/**
* Get the User Type record associated with the user.
*/
public function type()
{
return $this->hasOne(Type::class, 'id');
}
}
My model Typeis even simpler at the moment:
class Type extends Model implements AuthenticatableContract, AuthorizableContract
{
use Authenticatable, Authorizable;
protected $fillable = [
'name',
];
protected $hidden = [ ];
/**
* Get the User Type record associated with the user.
*/
public function user()
{
return $this->belongsTo(User::class);
}
}
In one of my controllers, I am sending the information of all users in this way:
public function showAllUsers(Request $request)
{
$users = User::orderBy('id', 'asc')->with('person', 'type')->where('active', 'yes')->get();
return response()->json($users, 200);
}
And the result I get is strange:
[
{
"id": 1,
"token": "userUniqueToken",
"active": "yes",
"persons_id": 3,
"types_id": 1,
"images_id": null,
"created_at": "2021-01-27T06:58:04.000000Z",
"updated_at": "2021-01-27T06:58:04.000000Z",
"person": {
"id": 1,
"name": "Kenny",
"lastname": "",
"phone1": "35555555",
"phone2": "",
"email": "[email protected]",
"created_at": "2021-01-27T06:56:31.000000Z",
"updated_at": "2021-01-27T06:56:31.000000Z"
},
"type": {
"id": 1,
"name": "Empleado",
"created_at": null,
"updated_at": null
}
},
{
"id": 2,
"token": "userUniqueToken",
"active": "yes",
"persons_id": 4,
"types_id": 1,
"images_id": null,
"created_at": "2021-01-27T07:00:11.000000Z",
"updated_at": "2021-01-27T07:00:11.000000Z",
"person": {
"id": 2,
"name": "Josue",
"lastname": "",
"phone1": "35555555",
"phone2": "",
"email": "[email protected]",
"created_at": "2021-01-27T06:57:33.000000Z",
"updated_at": "2021-01-27T06:57:33.000000Z"
},
"type": null
}
]
If I put two, three or four records, only the first one brings all the information of the type of user. Why from the second record the object typecomes empty?
My method looks like this:
createTip: function (tip) {
this.$axios.post(this.$API_URL + 'tips', {
name: tip.name,
description: tip.description
}, {
headers: {
'Api-Token': this.$store.state.token
}
})
.then( (response) => {
this.tip_temporal.tip_id = response.data.tip_id
this.$toastr.success('The Tip has been created successfully!', "Success!");
this.finishAction()
})
.catch(error => {
this.errorAction(error)
});
},
What I want to do is, instead of assigning
this.tip_temporal.tip_id = response.data.tip_id
my method can return that value, something like this:
return response.data.tip_id
The idea is that somewhere else in the code I can do something like this:
let id = this.createTip(tip)
I tried to do the returnin thenof the promise that generates axios, but as we all know, promises are asynchronous, so whenever I try to assign the value that the method should return, it assigns me an undefined value.
Any ideas?
I am implementing a payment service on my website, and one of the last ones is to make a request httpwith curl, but I don't fully understand how to do it.
The documentation says that the request must have the following form:
https://sandbox.affirm.com/api/v2/charges
-X POST
-u "<public_api_key>:<private_api_key>"
-H "Content-Type: application/json"
-d '{"checkout_token": "<checkout_token>","order_id": "JKLM4321"}'
The way I have to do this with curl would be the following:
// Iniciar curl
$curl = curl_init();
$headers[] = 'Content-Type: application/json';
// Agregar las opciones y datos
curl_setopt_array($curl, [
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => 'https://sandbox.affirm.com/api/v2/charges',
CURLOPT_POST => 1,
CURLOPT_HEADER => $headers,
CURLOPT_POSTFIELDS => [
checkout_token => 'value',
order_id => 'value2'
]
]);
// Enviar la petición y obtener la respuesta
$resp = curl_exec($curl);
// Cerrar la peticion
curl_close($curl);
But, as you can see, I have no idea how to include the public and private keys (which I already have, that's NOT the problem) in the request with curl, and I don't know what that "-u" they describe in the documentation means either. Any ideas?
I am using this code to send the information of a inputtype fileto my data server
let formData = new FormData();
let files = document.querySelector('[type=file]').files;
formData.append('files[]', files[0]);
fetch(url, {
method: 'POST',
body: formData
}).then(response => {
console.log(response);
});
I have reviewed the fetch documentation for POST requests, and also the specific documentation for the body property . These indicate that the body can be any of these types of structures (ArrayBuffer, ArrayBufferView, (Uint8Array and friends), Blob/File, string, URLSearchParams, FormData) but it does not say how to combine them.
So my question is, how do I send a FormData and a string at the same time?
On the official Bootstrap page, there is an example of an accordion, which, we could say, is a specific case of a set of elements collapse.
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<div id="accordion">
<div class="card">
<div class="card-header" id="headingOne">
<h5 class="mb-0">
<button class="btn btn-link" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
Collapsible Group Item #1
</button>
</h5>
</div>
<div id="collapseOne" class="collapse show" aria-labelledby="headingOne" data-parent="#accordion">
<div class="card-body">
Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird
on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table,
raw denim aesthetic synth nesciunt you probably haven't heard of them accusamus labore sustainable VHS.
</div>
</div>
</div>
<div class="card">
<div class="card-header" id="headingTwo">
<h5 class="mb-0">
<button class="btn btn-link collapsed" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="false" aria-controls="collapseTwo">
Collapsible Group Item #2
</button>
</h5>
</div>
<div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordion">
<div class="card-body">
Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird
on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table,
raw denim aesthetic synth nesciunt you probably haven't heard of them accusamus labore sustainable VHS.
</div>
</div>
</div>
<div class="card">
<div class="card-header" id="headingThree">
<h5 class="mb-0">
<button class="btn btn-link collapsed" data-toggle="collapse" data-target="#collapseThree" aria-expanded="false" aria-controls="collapseThree">
Collapsible Group Item #3
</button>
</h5>
</div>
<div id="collapseThree" class="collapse" aria-labelledby="headingThree" data-parent="#accordion">
<div class="card-body">
Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird
on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table,
raw denim aesthetic synth nesciunt you probably haven't heard of them accusamus labore sustainable VHS.
</div>
</div>
</div>
</div>As you can see, whenever an element is displayed, the other two are hidden without exception. I understand that I could well put one collapseon top of another, but I really don't want to, for reasons of time and effort (and here it is clear that Boostrap is not my thing, maybe this is extremely easy).
So my question is, is there any modification that can be made to an accordion in Bootstrap 4 so that the hide and show behavior isn't mutually exclusive?
I have a table, in which I have hundreds of rows, and in which each row looks something like this (with different information for each row, of course)
<tr>
<input class="prodId" hidden value="<?php echo $product['id']; ?>">
<td class="thead"><?php echo $product['prod_name']; ?></td>
<td class="thead"><?php echo $product['prod_price']; ?></td>
<td class="thead"><?php echo $product['prod_qty']; ?></td>
<td class="thead">
<select class="availability-options">
</select>
</td>
</tr>
Everything is working fine in the option change event of the select. What I am trying to do is get the value of the id that is in the input. i'm trying this
$(".availability-options").on("change", function(){
let optionSelected = $(this).val();
let _id = $(this).closest("input .prodId").val();
....
And also try this
let _id = $(this).parent().parent().children(".prodId").val();
I understand that both selectors return a Jquery type object, but I can't figure out how to get the one valuefrom the input. It always returns an undefined value. How do I get the value of input?
When the hover event is detected in any of the menus, the options should slide down. When the mouse leaves the options, I'm trying to hide the options, but for some reason it doesn't work. Because? I don't see anything wrong with the implementation of mouseout() in my code.
$(document).ready(function() {
$(".level1-option").hover(function(){
$(".sub-menu1-container").slideDown();
});
$(".sub-menu1-container").mouseout(function(){
$(".sub-menu1-container").slideUp();
});
});* {
padding: 0;
margin: 0;
}
.header {
background: white;
height: 147px;
box-shadow: 1px 1px 15px grey;
position: relative;
}
.header-menu {
color: grey;
position: absolute;
right: 100px;
bottom: 20px;
}
.level1-option {
padding: 0 10px;
display: inline-block;
color: grey;
}
.level1-option:hover {
color: #e6b800;
cursor: all-scroll;
}
.sub-menu1-container {
margin: 0 5%;
background: white;
height: 337px;
box-shadow: 1px 1px 15px #8f8a8a;
position: relative;
z-index: -1;
}<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<link rel="stylesheet" href="style.css">
<script src="jquery-3.2.1.min.js"></script>
<script src="jquery.js"></script>
</head>
<body>
<div class="header">
<div class="header-menu">
<ul style="list-style: none;">
<li class="level1-option">option 1</li>
<li class="level1-option">option 2</li>
<li class="level1-option">option 3</li>
<li class="level1-option">option 4</li>
<li class="level1-option">option 5</li>
<li class="level1-option">option 6</li>
</ul>
</div>
</div>
<div class="sub-menu1-container" hidden>
</div>
</body>
</html>I'm trying to make a menu with pure CSS, and I'm making progress little by little, but I have a problem. In the first level options (and well, in all the other options too), why does the background color appear bigger than the image?
This is my code:
/*Padding y margin para todos los elements*/
* {
padding: 0;
margin: 0;
}
/*Position y color de fondo de barra de navegación*/
nav {
position: relative;
background: white;
}
/*Bloque para opciones de primer nivel*/
.options {
list-style: none;
box-shadow: 1px 1px 15px grey;
color: #e6b800;
}
/*Opciones de primer nivel*/
.level1 {
display: inline-block;
}
a {
padding: 20px;
text-decoration: none;
color: grey;
}
a:hover {
color: white;
background: #e6b800;
}
li div {
visibility: hidden;
width: 100%;
position: absolute;
left: 0;
background: white;
z-index: -1;
}
li:hover div {
visibility: visible;
}
li div ul {
display: inline-block;
vertical-align: top;
}
li div ul li {
display: block;
}
li div ul li a {
color: grey;
}<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<nav>
<ul class="options">
<li class="level1"><a href="#">Menu 1</a>
<div>
<ul>
<li><a href="#">This is a long sub item 1</a></li>
<li><a href="#">sub item 2</a></li>
<li><a href="#">sub item 3</a></li>
</ul>
<ul>
<li><a href="#">Part two: sub item 1</a></li>
<li><a href="#">Part two: sub item 2</a></li>
<li><a href="#">Part two: sub item 3</a></li>
<li><a href="#">Part two: sub item 4</a></li>
</ul>
</div>
</li>
<li class="level1"><a href="#">Menu 2</a>
<div>
<ul>
<li><a href="#">different sub item 1</a></li>
<li><a href="#">different sub item 2</a></li>
</ul>
</div>
</li>
<li class="level1"><a href="#">Menu 3</a>
<div>
<ul>
<li><a href="#">some more items 1</a></li>
<li><a href="#">here's a really long item 2</a></li>
<li><a href="#">some more items 3</a></li>
<li><a href="#">short item 4</a></li>
<li><a href="#">some more items 5</a></li>
<li><a href="#">item 6</a></li>
</ul>
</div>
</li>
</ul>
</nav>
</body>
</html>For the sake of simplicity, my "form" looks something like this:
import tkinter as tk
ventana = tk.Tk()
mensaje = tk.Text(ventana, background="white", width=165, height=25)
mensaje.config(state="disable")
mensaje.pack(padx=0, pady=125)
mensaje.insert(INSERT, "Hola Mundo")
ventana.mainloop()
I understand that I mensaje.insert(INSERT, "Hola Mundo")should add the required text to my widget, but I get this error:
File "search.py", line 5, in message.insert(INSERT, "Hello World") NameError: name 'INSERT' is not defined
What am I doing wrong?
In my project, people can include a personal photo so they can be easily identified.
What I am doing at the moment is the following:
inputwith type filethat I have so that, when it changes value, the action of saving said photograph is executed.$.ajax()to send the file to the server and from there it is processed.pathwhere the photo was stored so you can replace the value of my imgwhere it should be displayed.Now in a little more detail:
Everything in numeral 1 and 2 works fine. Then, for number 3, I have the following. In my php file I move the file and give a response with the following code (simplified for obvious reasons):
move_uploaded_file($_FILES['usuariofoto']['tmp_name'],$directorio.$nombre_img);
$full_path = $directorio.$nombre_img;
$response = array(1,$full_path);
echo json_encode($response);
I understand that, if not specified otherwise, it move_uploaded_fileoverwrites the file, which is good, since I don't want to have a bunch of photos for the same person. ( $nombre_imgit is a unique id for each person and $directorioit is the name of the folder)
Back in JQuery, I'm trying to update the img with
var response = JSON.parse(postresult);
$("#usuariovistafoto").attr("src", response[1]);
So far so good, but the image does not change. When I inspect the element img, I see that it has the same name as always, but this is normal, since I am overwriting the photo. I refresh the page manually and, indeed, if the photograph has been saved correctly, the new photo I have uploaded is displayed.
So, here is the problem. I suppose that since the file has the same name, the image is not updated and you still see the same photograph, although, in effect, all the changes have been carried out.
What do I have to do so that, so to speak, my img"render" again even though it has the same file name in the src?
I recently answered the question How to add elements to an array in C#? and while I was proposing the alternative solution which was to use the class List, I reminded myself that there is also a class called ArrayList.
When comparing the documentation of ArrayList and List , in some parts of these articles it says:
"The ArrayList class is designed to hold heterogeneous collections of objects. However, it does not always offer the best performance."
And also
"The List class performs best in most cases and is type-safe."
Then the article Listtries to explain why it performs Listbetter, but this is the part I don't understand. It literally says:
"For a List, if a value type is used for type T, the compiler generates an implementation of the List class specifically for that value type. That means a list element of a List object does not have to be boxed before the element can be used."
"For a List, if a type is used for the type in the list, the compiler generates an implementation of the List class specifically for that type value. That means that a list element of the List object does not have to be encased before it can to be used."
*Free translation by me
What is really the difference between ArrayList and List and why does it say List has better performance?
PS: +10 brownie points to anyone who tells me what I should understand by "boxed" in that paragraph, that the truth is I couldn't translate it very well. Edit: Flxtr has taken the brownie points.
I have a table called usuario. The code I used to create it is as follows:
CREATE TABLE IF NOT EXISTS `cumplimiento`.`usuario` (
`idusuario` VARCHAR(10) NOT NULL,
`pass` VARCHAR(100) NOT NULL,
`rol` INT NOT NULL,
`activo` TINYINT(1) NOT NULL,
`pregunta` VARCHAR(55) NULL,
`respuesta` VARCHAR(200) NULL,
PRIMARY KEY (`idusuario`),
INDEX `fk_usuario_rol1_idx` (`rol` ASC),
CONSTRAINT `fk_usuario_rol1`
FOREIGN KEY (`rol`)
REFERENCES `cumplimiento`.`rol` (`rol`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
The table is created successfully and everything is fine. The situation is the following. I need to make an UPDATEa idusuarioand that change is reflected in the tables where this field is a foreign key.
I found that the way to do that is to use the statement:
ON UPDATE CASCADE
For example, I have this other person table, whose code is as follows:
CREATE TABLE IF NOT EXISTS `cumplimiento`.`persona` (
`cif` INT NOT NULL,
`idusuario` VARCHAR(10) NOT NULL,
`numero_impresiones` INT NULL,
INDEX `fk_persona_usuario1_idx` (`idusuario` ASC),
PRIMARY KEY (`cif`),
CONSTRAINT `fk_persona_usuario1`
FOREIGN KEY (`idusuario`)
REFERENCES `cumplimiento`.`usuario` (`idusuario`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
And I understand that under the REFERENCESis my field idusuario. I also understand that it is in this table that I have to change the ON UPDATE NO ACTIONto ON UPDATE CASCADE, and so on in other tables where I have this field as a foreign key.
Now, basically I haven't done it because I'm a little scared that something might happen to my tables and I guess there's an easy way to do it. How do I go about changing that? Do I have to use the same script and only change that part of each table? or maybe, can it be done somehow in Workbench?
When I have scripts that have to do extensive searching, I usually divide the work into threads with the help of the threading. Since my main program is the one in charge of the searches, also this main program should be in charge of serving the results to the user, not the threads .
As an example, suppose I have a script, which is responsible for knowing if a number is within the range of 1 and 1 billion. Each thread is performing comparisons and might find the result.
My example script looks something like this:
import threading
def busqueda1(num):
for i in range(500000000):
if(num == i):
print("Busqueda1 confirmó el número")
def busqueda2(num):
for i in range(500000001,1000000000):
if(num == i):
print("Busqueda2 confirmó el número")
numero = 123456789
thread1 = threading.Thread(target=busqueda1,args=(numero,))
thread2 = threading.Thread(target=busqueda2,args=(numero,))
thread1.start()
thread2.start()
What I need is to know in my main program which of the two threads has found the number and show it to the user.
Since they are different execution threads, how do I make the main program and other threads have access to the possible results that are being generated?
I have an associative array in my php script to which I have to add elements depending on some conditions. My setup starts like this:
$arreglo = ["id" => $_POST["id"]];
When a certain condition is met, I have to add more elements so that the array has the information, for example, what is in $_POST["nombre"], $_POST["apellido"], etc. The goal is to use that associative array in an object PDOto safely execute a query. How do I do it?
In my project, if the user has forgotten their password, I force them to type their username and using Javascript and windows.locationopen a new web page with a type request GETand send their username as a variable. On this page, once you have answered the security question, you can change your password.
After a review, I realized that this action opens a big security hole, because anyone can request this same web page and send a valid user, and if they know the answer to the security question, change the user's password .
I thought of sending a kind of security "token", that only I know of, but I can't think of something that is unique and unrepeatable, apart of course from the date or time.
If I write something in the HMTL, even if it is of type hidden, when reviewing the source code you can see it, and the date or time would be very predictable, even if I modified it in some way, since the source code can be accessed in JS .
It could be that you are not thinking very well about the solution and there is another way to do it. With all these details, is there any variable that is unique and unrepeatable that I can generate with Javascript and decrypt with PHP?