I need to know which folios are duplicated within a date range, from a specific department, I have this query but I get some errors:
select n.numero, n.nombre from Empleado as n where n.Fecha = '2022-05-29 00:00:00.000' between n.Fecha = '2022-05-30 00:00:00.000'
and n.ID_departamento = '123'
group by numero,nombre having COUNT(*)>1
incorrect syntax near between
incorrect syntax near '*'. Specting '(' or SELECT
Also how can I remove those duplicates?
I have a table of products:
id | descripcion
1 latas
and a service table:
id | id_producto | cantidad | fecha
1 1 2 2022-04-27 11:41:17.327
2 1 5 2022-04-26 11:45:23.327
3 1 1 2022-04-27 11:48:17.327
4 1 2 2022-04-18 11:41:17.327
I need to calculate the quantity sold for the current week, that is, my week starts on Monday 25and my week close is the following Monday.
Since you can only see one sale on 18, but that is from last week, you would only need to add the sales of the current week until the week ends.
I have this query, it's not complete, but I don't know how else to do it:
SELECT sum(cantidad) FROM servicios where id_producto = '1' and datepart >= 1 then datepart <= 1
What I have tried is to add the quantities that go from this Monday to the next of a specific product, from the day 25to the day 2of May, it would have to give me 8 as a result, since there is only one quantity from yesterday and 2from the day today, and if more are done tomorrow that should also be added to the total.
For the closing and beginning of the following week it will have to be different depending on the quantities of that current week
I am filling a table one by one, but in case you don't want some data, just delete it, this is my table with jquery
var row = '';
row += '<tr >';
row += '<td style="padding:2px">' + XXXX+ '</td>';
row += '<td style="padding:2px;">' + XXXX+ '</td>';
row += '<td style="padding:2px;">' + XXX+ '</td>';
row += '<td style="padding:2px;">' + XXX+ '</td>';
row += '<td style="padding:2px;"><button class="btn btn-danger" onclick=\"Eliminar(\'' + ID+ '\')\">Eliminar</button> </td>';
$('#table').append(row);
When clicking on the delete button, I send as a parameter the id of the row that you want to delete to a function
function Eliminar(ID)
{
$("#table" + unidad).parent().parent().remove();
}
I try to delete the row in this way, but nothing happens, however if I inspect the code, if it is taking the ID, how can I delete the row?
I have my table in html, and through javascript and a button, I can add as many rows as I want, when the row is created, how can I make it in the action column where a button with an "X" is created, when pressing it has a sub row that expands and collapses, like the jquery examples https://datatables.net/examples/server_side/row_details.html , but without using it
function agregarFila() {
document.getElementById("example").insertRow(-1).innerHTML = '<td><button type="button" class="btn btn-success" onclick="expandir()">+</button></td><td contenteditable="true">x</td><td contenteditable="true">x</td><td contenteditable="true">x</td><td contenteditable="true">x</td></td>';
}
function expandir() {
//subfila con textfield, label etc
}<body>
<div class="row">
<div class="col-md-12 ml-auto">
<button id="enviar" type="button" class="btn btn-success" onclick="agregarFila()" style="float:right">Agregar Direccion</button>
</div>
</div>
<br>
<table id="example" class="table table-striped table-bordered table-responsive">
<thead>
<tr>
<th style="width:10px;">Acciones</th>
<th style="width:10px;">Calle</th>
<th style="width:10px;">Colonia</th>
<th style="width:10px;">Numero Exterior</th>
<th style="width:10px;">Numero Interior</th>
</tr>
</thead>
<tbody id="example">
<tr>
</tr>
</tbody>
</table>
<script src="../Js/table.js"></script>
</body>
I am filling a table by js, this is my code:
$('#table').append(//recorremos la lista llenando la tabla
'<tr>' +
' <td>' + lista[i].nombre + '</td>' +
' <td>' + lista[i].estatus + '</td>' +
'</tr>'
);
The data I receive from estatusis a falseor a true. I need that instead of the phrase appearing ; when it is false put a green circle and when it is true, put a red one. I have this part of the code:
"class", "fa fa-circle text-danger"
Where would I have to put the condition to know the result, and how to integrate that in my tdfor estatus?
I would like to delete a row from the datagrid when pressing a "Delete" button
I have this:
private void btnEliminar_Click(object sender, EventArgs e)
{
if (Id != "")
{
XXXXX Item = new XXXXX();
using (var context = new PruebaEnti())
{
Item = context.xxxxx.FirstOrDefault(x => x.Id == Id);
dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index);
context.SaveChanges();
}
}
}
I get this error:
Additional information: Rows cannot be deleted programmatically unless the DataGridView is data-bound with an IBindingList that supports change notification and allows deletion.
I have a list of folder addresses, which I then loop through with a foreach. The routes look like this
C:\XXX\XXX\XXX\XXX\XXX\10-21-2020
C:\XXX\XXX\XXX\XXX\XXX\10-20-2020
At a certain moment I get the current date, when going through the foreachname that is at the end of the route, for example , it "10-21-2020"corresponds to October 10, 2020, which must be equal to the current date.
if (Path.GetDirectoryName(item) == fecha_actual)
{
}
I've tried to get this name, but I still can't, I keep sending the entire route and I just need"10-21-2020"
I have this date format:
Thu Apr 18, 2019 12:44 pm
I am reading this information from a file... When it finds the first word in this case Thu, it enters if, and I start collecting the information at the end I have a variable tacTimewhere I combine the variables, leaving as a result
18 Apr 2019
-- Is there some type of conversion that in the end obtains the date in this way:
04/18/2018 (mes/dia/año)
--
if (arreglo[0] == "Thu")
{
string m = arreglo[1].Substring(0, 3);
string month = m;
string d = arreglo[2].Substring(0, 2);
string day = d;
string y = arreglo[3].Substring(0, 4);
string year = y;
tacTime = day + " " + month + " " + year;
}
I am going through the rows of an excel file and increasing the row to go to the next row, it should be clarified that the excel file reads each cell of each row correctly, what happens is that when it reaches Add(info)each rowit should be added, and that is that When the first one is read, everything is fine. At the end, it remains saved, but when it advances to the next row and reads the data, these data are saved, but the previous one that was saved is lost, and so on.
When it arrives at Save()what it is functionto do a insertto the DB with a foreachI go through the list with all the rows, and if it brings me all the rows but in all it is the last one that was read, that is to say; If I have 100 rows that should be different, the 100 rows are the last and have the same information.
public string RecorrerExcel()
{
DataTable excelTable = new DataTable("ExcelFile");
DataTable original = GetDataTableExcel();
int renglon = 1;
ExcelInformation info = new ExcelInformation();
List<ExcelInformation> listaInformation = new List<ExcelInformation>();
foreach (DataRow item in original.Rows)
{
for (int i = 0; i < original.Columns.Count; i++)
{
//
switch (original.Rows[0][i].ToString())
{
case "XXXXX":
info.XXXXX = item[i].ToString();
break;
case "XXXXX":
info.XXXXX = item[i].ToString();
break;
case "XXXXX":
info.XXXXX = item[i].ToString();
break;
case "XXXXX":
info.XXXXX = item[i].ToString();
break;
case "XXXXX":
info.XXXXX = item[i].ToString();
renglon += 1;
break;
default:
break;
}
}
Add(info); //agrega a la lista
}
Save(); //function para hacer insert
return "";
}
When reading an excel file, there is information that contains hyphens "-"and when going through the rows and reaching one that has a hyphen it shows it as �, so when looking for none matches and does not perform any processing that I have.
Like what method can I use to remove the script when reading the rows, or replace it, some effective method.
I tried to use this string[] data = line.Split('-');but it didn't work.
I have a table that has these columns, comprapurchase date serial yserial date query` :.
Necesito sacar los datos deyde acuerdo a la última
he intentado hacerlo mediante este
SELECT compra,serial FROM warehouse where MAX(fecha);
But it sends me this error:
group function is not allowed here
I don't need to obtain the information by means of an id or something similar, only the last purchase and serial according to the date.
I am getting the path of the folder where several files will be found, then I read the files and lastly I need to save the names in an array..how do I do that?
//ruta del folder
string folder_save = ConfigurationManager.AppSettings["folder"];
/*leer todos los archivos del folder*/
string[] files = Directory.GetFiles(folder_save);
string[] name_folder;
//guardar en arreglo
How can I save the name of the file that is being read and save it in a variable?
string[] lineas = System.IO.File.ReadAllLines(@"XXXXX");
I am inserting a grid, with a debbug I realize that if I am receiving the data, some are decimal, as you can see I do the conversion, but it turns out that there may be an 'X' in these, so it throws an exception,
So I need that if its value is an X, I change it to 0 (zero) and that in this way I can do the insert correctly.
How can I achieve it?
foreach (DataGridViewRow item in datagrid.Rows)
{
comando.Parameters.Add(":Stock", item.Cells[2].Value.ToString());
comando.Parameters.Add(":Cant", float.Parse(item.Cells[3].Value.ToString()));
comando.Parameters.Add(":Units", float.Parse(item.Cells[4].Value.ToString()));
.
.
.
}
I have this form to upload a txt file:
Button code, this is where I upload the file:
private void button1_Click(object sender, EventArgs e)
{
//lines contiene todas las lineas del archivo
string[] lines = System.IO.File.ReadAllLines(@"C:\\Users\\JR\\Desktop\\TXTS\\MX19080253005013GNNPN8ACYN.htd");
//estamos mandando las lineas a una cadena string a la clase read
r.lineas = lines;
//estamos llenando la el grid con la informacion
r.readFile(dataGridView1, ' ');
}
Result:
I have this read class:
class read
{
public string[] lineas; //creamos una cadena de string
public void readFile(DataGridView tabla, char caracter) //metodo para leer y llenar el grid
{
foreach (var linea in lineas) //mandamos la informacion y la muestra en el grid
{
int columnas = tabla.Columns.Count;
foreach (DataGridViewRow fila in tabla.Rows)
{
int vacios = 0;
for (int i = 0; i < columnas; i++) //quitar espacios
{
if (Convert.ToString(fila.Cells[i].Value) == string.Empty)
{
vacios++;
}
}
if (vacios == columnas)
{
tabla.Rows.RemoveAt(fila.Index);
}
}
AddRowDataGrid(tabla,linea,caracter);
}
} //public readFile
public static void nombrarTitulo(DataGridView tabla, string [] titulos)
{
int x = 0;
for (x = 0; x <= tabla.ColumnCount - 1; x++ )
{
tabla.Columns[x].HeaderText = titulos[x];
}
} // public nombrarTitulo
public static void AddRowDataGrid(DataGridView tabla, string linea, char caracter)
{
string[] arreglo = linea.Split(new string[] { caracter.ToString(),"\t" }, StringSplitOptions.RemoveEmptyEntries);
tabla.Rows.Add(arreglo);
} //public AddRowGrid
}
This is what the txt file looks like:
*** DATE: 3/7/2019 TIME: 6:42 AM SN: MX19080344405013GNNPN8ACYN SW VER: 9.07 Station: ATE08-FOXCONN TX Cal: 23.42 Individual Tests: FALSE ***
TEST DESCRIPTION MIN MEASURED MAX UNITS RESULTS TIME
**********************************************************************************************************************************
1 XXXXX XXXXX XXXXXX XXXX XXXX XXXX XXXXX
XXXXX XXXXX XXXXXX XXXX XXXX XXXX XXXXX
XXXXX XXXXX XXXXXX XXXX XXXX XXXX XXXXX
XXXXX XXXXX XXXXXX XXXX XXXX XXXX XXXXX
2 XXXXX XXXXX XXXXXX XXXX XXXX XXXX XXXXX
XXXXX XXXXX XXXXXX XXXX XXXX XXXX XXXXX
This is line 4:
*** DATE: 3/7/2019 TIME: 6:42 AM SN: MX19080344405013GNNPN8ACYN SW VER: 9.07 Station: ATE08-FOXCONN TX Cal: 23.42 Individual Tests: FALSE ***
What I need to do is obtain the information of each one, that is, 3/7/2019 from Date:, 6:42 AM from TIME: etc... and put them in the form where there are some labels which will be filled with said information, the name of these are:
labelDate
LabelTime LabelSn
LabelSw
LabelStation
LabelTx
How can I perform this action?
I have this collectionin mongo, but my question is is there any way that when doing one collectionwith insertno I get the _iddefault since this time I use my idas the second line.
{
"_id" : ObjectId("5ca1abb6ce037511f000628e"),
"id" : "sjohnson",
"name" : "Steve Johnson"
}
I need it to be like this:
{
"id" : "sjohnson",
"name" : "Steve Johnson"
}
I am starting in Mongodb, and as you know this does not have relaciones, there is no joins tablasetc.
I'm trying to pass a relational diagram to NOSQL. I have the following tables.
users
id
name
messages
idUserFrom
idUserTo
messages
As you can see, the table messageshas as foreign the id of users, how can I create it although there is not in mongo pksand fkshow can I carry out this step.
So far I have created the database and one collectionwith the insertion of the table users.
> use mongodb
switched to db mongodb
> db
mongodb
> db.users.insert({id:"1",name:"Jorge"})
WriteResult({ "nInserted" : 1 })
> show collections
users
> db.users.find().pretty();
{
"_id" : ObjectId("5c9bbc275a56aa679bb06155"),
"id" : "1",
"name" : "Jorge"
}
collectionsHow can I make it look like this messages: This table contains the id of some user, which can be the idFromoridTo
db.messages.find().pretty();
{
"_id" : ObjectId("5c9bbc275a56aa679bb06155"),
"idFrom" : "xxxxxxxxxx",
"idTo" : "xxxxxxxxxx",
"message" : "Hola"
}
I have this statement, but my question is what does select 1 do, and how would it look, some example, that you could provide me with an explanation.
insert into grades (idStudent,idCourse)
select 1, id from courses where idGroup=groupId;
In my button "Descargar excel"I have a onclickthat leads to the following function in JS:
function downloadExcel(status)
{
$.ajax({
url: "http://localhost/WareHouse/reporte.php?status="+status,
type: "GET",
success:function(status)
{
console.log("Entre a download excel");
var tmpElemento = document.createElement('a');
var data_type = 'data:application/vnd.ms-excel';
var tabla_div = document.getElementById('actives');
tmpElemento.href = data_type + ', ' + tabla_div;
//Asignamos el nombre a nuestro EXCEL
tmpElemento.download = 'InventoryToReorder.xls';
tmpElemento.click();
}
});
}
I am calling a file called the reporte.phpsame that was used to generate a PDF, the problem I have is that if I download excelit but when I open it it is in the cell A1, that is, in the first one it only says nullno more. What could be the problem why it doesn't even show me the column names?
reporte.php:
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<?php echo'<title>Inventory To Reorder</title>';?>
</head>
<body onload="window.print()">
<?php echo '<img src="http://localhost/WareHouse/assets/img/Esterline.png" style="position: absolute; top: 0; left: 0; height:6%; width:23%; margin-top:40px; margin-left:40px;"/>';?>
<?php echo '<center style="margin-top:120px; font-size:14pt;"><strong>Inventory To Reorder</strong></center>';?>
<?php echo '<label><center>____________________________________________________________________________</center></label><br>';?>
<?php
require_once('apis/connection.php');
if(isset($_GET['status']))
{
$status = $_GET["status"];
//Trae todos los item que esten por debajo de su minimo en stock.
$connection = new MySqlServerConnection();
$query = "SELECT i.description_item,i.quantity,u.name_unit,i.reorder_Level,i.target_Stock,l.name_location,i.commentt,io.quantity_s,i.status
FROM inventory_list AS i
INNER JOIN unit_mesurement AS u ON id_unit = fkUnit
INNER JOIN location AS l on id_location = fkLocation
INNER JOIN inventory_output as io on id_output = fkInventory
WHERE i.quantity <= i.reorder_Level OR i.status = 1";
$result = $connection->executeQuery($query,array($status));
if ($result > 0) {
var_dump($result);
//echo $query;
?>
<center>
<table class="table table-striped xd" border="1px;" id="actives">
<thead>
<tr>
<th style="width: 3%;">Description</th>
<th style="width: 3%;">Quantity</th>
<th style="width: 3%;">Usage</th>
<th style="width: 3%;">Name Unit</th>
<th style="width: 3%;">Reorder Level</th>
<th style="width: 3%;">Target Stock</th>
<th style="width: 3%;">Area</th>
<th style="width: 3%;">Comment</th>
</tr>
</thead>
<?php
$arraycount=count($result);
$i=0;
$total=0;
while ($i < $arraycount)
{
?>
<tr>
<td><center><?php echo $result[$i]['description_item']; ?></td>
<td><p style="color:red;" ><?php echo $result[$i]['quantity']; ?></p></td>
<td>
<?php
$qs = $result[$i]['quantity_s'];
switch (true) {
case ($qs >= 1000 && $qs <= 2000) :
echo " 1000 a 2000 SEMANAL";
break;
case ($qs >= 100 && $qs <= 200) :
echo " 100 a 200 SEMANAL Y/O QUINCENAL";
break;
}
?>
</td>
<td><?php echo $result[$i]['name_unit']; ?></td>
<td><?php echo $result[$i]['reorder_Level']; ?></td>
<td><?php echo $result[$i]['target_Stock']; ?></td>
<td><?php echo $result[$i]['name_location']; ?></td>
<td><?php echo $result[$i]['commentt']; ?></center></td>
</tr>
<?php $i++;
}
?>
</table><br><br>
</center>
<?php
}
//}
}
?>
</body>
Does anyone know how to generate random numbers every minute?
Right now I only have a for loop where it sends 3 pieces of data, nothing more, but it sends them instantly, and I need it to return a random number every minute.
for(int i =0; i<3; i++){
int numero = (int) (Math.random() * 100) + 1;
System.out.println(numero);
}
Result is:
56
32
49
BUILD SUCCESSFUL (total time: 0 seconds)