Caruso's questions

I have the following code in my .html file of my sale component:

<div>
<mat-card class="mat-elevation-z0">
    <div style="text-align:center;">
        <mat-card-title>Nueva Venta</mat-card-title>
    </div>
    <mat-card-content>
      <mat-label class="title"> Fecha/Hora:        {{ jstoday }}</mat-label>
      <br>
      <form [formGroup]="ventaForm">
        <div class="container" fxLayout="column" fxLayout.gt-xs="row" fxLayoutGap="20px" >
          <ng-template matStepLabel>Condicion de Venta</ng-template>
          <mat-form-field appearance="fill" fxFlex="25">
          <mat-label>Condicion.:</mat-label>
          <mat-select #condVenta placeholder="Condicion de Venta"  formControlName="condicionVenta" (selectionChange)="selectCV($event.value)" cdkFocusInitial>
            <mat-option value=undefined>Seleccione</mat-option>
            <mat-option value=1>Contado</mat-option>
            <mat-option value=2>Cuenta Corriente</mat-option>
          </mat-select>
          </mat-form-field>
            <span class="fill-space"></span>
          <mat-form-field appearance="fill" class="example-full-width" fxFlex="75" >
          <mat-label>Cliente</mat-label>
          <input matInput #icliente
                 aria-label="Cliente"
                 [matAutocomplete]="auto"
                 [formControl]="clienteCtrl"
                 formControlName="nombre_cliente">
          <mat-autocomplete #auto="matAutocomplete"  >
                <ng-container *ngFor="let c of filteredClientes | async" >
                <mat-option id="c.idcliente" *ngIf="c.nombre_cliente=='CONSUMIDOR FINAL'" [value]="c.nombre_cliente" (onSelectionChange)="selectC(c)">

                  <span>{{c.nombre_cliente}}</span> 
                
                </mat-option>
                <mat-option *ngIf="c.nombre_cliente!=='CONSUMIDOR FINAL'" [value]="c.nombre_cliente + '  CUIT: '+  c.CUIT" (onSelectionChange)="selectC(c)">

                  <span>{{c.nombre_cliente}}</span> |
                  <small>CUIT.: {{c.CUIT}}</small>

                </mat-option>
              </ng-container>
              </mat-autocomplete>
            </mat-form-field>
          <br>
     
            
          <table mat-table tabindex="4" #table [dataSource]="carritoDataSource$" class="mat-el" class="mat-elevation-z1" matSort class="mat-elevation-z8" matSortActive="nombreProducto" matSortDirection="asc" matSortDisableClear>
              
                  <caption style="font-size: 20px;height: 4vh;border: 10px; color: rgb(54, 11, 211);"> DETALLE </caption>
              
                  <ng-container matColumnDef="nombreProducto">
              
                    <th mat-header-cell *matHeaderCellDef mat-sort-header>Descripcion</th>
                    <td mat-cell *matCellDef="let element">{{element.NombreProducto}}</td>
              
                  </ng-container>
              
                  <ng-container matColumnDef="precio">
              
                    <th mat-header-cell *matHeaderCellDef>Precio</th>
                    <td mat-cell *matCellDef="let element">{{element.precio | currency:'$'}}</td>
              
                  </ng-container>
                  <ng-container matColumnDef="categoria">
              
                    <th mat-header-cell *matHeaderCellDef>Categoria</th>
                    <td mat-cell *matCellDef="let element">{{element.nombre_categoria}}</td>
              
                  </ng-container>
                  <ng-container matColumnDef="subcategoria">
              
                    <th mat-header-cell *matHeaderCellDef>Subcategoria</th>
                    <td mat-cell *matCellDef="let element">{{element.nombre_subcategoria}}</td>
              
                  </ng-container>
                  <ng-container matColumnDef="marca">
              
                    <th mat-header-cell *matHeaderCellDef>Marca</th>
                    <td mat-cell *matCellDef="let element">{{element.nombre_marca}}</td>
              
                  </ng-container>
                  <ng-container matColumnDef="stock">
              
                    <th mat-header-cell *matHeaderCellDef>Stock</th>
                    <td mat-cell *matCellDef="let element">{{element.stock}}</td>
              
                  </ng-container>
                  <ng-container matColumnDef="actions">
              
                    <th mat-header-cell *matHeaderCellDef>Acciones</th>
                    <td mat-cell *matCellDef="let element">
              
                      <button mat-raised-button color="basic">Editar</button> |
                      <!-- <button (click)="delete(element)" mat-raised-button color="warn">Eliminar</button>-->
                    </td>
              
              
                  </ng-container>
                  <tr mat-header-row *matHeaderRowDef="columnas"></tr>
                  <tr mat-row *matRowDef="let row; columns:columnas"></tr>
              
                </table>
                <mat-paginator #productsPaginator [pageSizeOptions]="[50, 100,200]" showFirstLastButtons aria-label="Seleccionar pagina">
                </mat-paginator>
          
            </div>
          </form>
     
      </mat-card-content>
 </mat-card>

</div>

But I don't understand why it appears as in the image:

The idea is that the sale condition select occupies 25% of the line or row and the rest of the space (75%) is occupied by the Customer name input, for example.

I am working in net core 3.1 with a database, and I want to obtain the products but with their respective category, subcategory and brand, in the database I only have the id obviously, that is, in the articles table I have idcategory idsubcategory and idbrand.

I have the following: IproductService interface:

using APIGESTION.model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace APIGESTION.Services
{
    public interface IProductoService
    {
        public void Add(ProductoRequest model)
        {

        }
        List<Producto> GetProductos();
    }
}

And its implementation with LINQ:

using APIGESTION.model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace APIGESTION.Services
{
    public class ProductoService : IProductoService
    {
        public void Add(ProductoRequest model)
        {

            using (gestionContext db = new gestionContext())
            {
                using (var transaction = db.Database.BeginTransaction())
                    try
                    {

                        var producto = new Producto();

                        producto.IdProducto = model.IdProducto;
                        producto.Precio = model.Precio;
                        producto.Stock = model.Stock;
                        producto.IdCategoria = model.idCategoria;
                        producto.nombreCategoria = model.nombreCategoria;
                        producto.idSubCategoria = model.idSubCategoria;
                        producto.nombreSubCategoria = model.nombreSubCategoria;
                        producto.idMarca = model.idMarca;
                        producto.nombreMarca = model.nombreMarca;
                        producto.CodAlfanumerico = model.CodAlfanumerico;
                        producto.CodBarra = model.CodBarra;
                        producto.Aliiva = model.Aliiva;
                        producto.Unidad = model.Unidad;
                        producto.Contenido = model.Contenido;
                        producto.costo = model.costo;
                      
                        db.Productos.Add(producto);
                        db.SaveChanges();

                   
                        transaction.Commit();

                    }
                    catch (Exception)
                    {
                        transaction.Rollback();
                        throw new Exception("Ocurrio un error en la insercion");
                    }
            }

        }

        public List<Producto> GetProductos()
        {
            using (gestionContext db = new gestionContext())
            {
              var productos=(from p in db.Productos join cat in db.Categoria on p.idCategoria equals cat.IdCategoria join
                subcat in db.Subcategoria on p.idSubCategoria equals subcat.IdSubcategoria join m in db.Marcas on
                p.idMarca equals m.IdMarca
                select new
                {
                    IdProducto = p.IdProducto,
                    Precio = p.Precio,
                    Stock = p.Stock,
                    IdCategoria = p.idCategoria,
                    IdSubcategoria = p.idSubCategoria,
                    IdMarca = p.idMarca,
                    CodAlfanumerico = p.CodAlfanumerico,
                    CodBarra = p.CodBarra,
                    Aliiva = p.Aliiva,
                    Unidad = p.Unidad,
                    Contenido = p.Contenido,
                    costo = p.costo,
                    NombreProducto = p.NombreProducto,
                    nombreCategoria = p.nombreCategoria,
                    nombreMarca = p.nombreMarca,
                });
                return (List<Producto>)productos;
            }

         
           
       
           
        }
    }
}

Now, how do I call the method that obtains the list in the item or product controller?

namespace APIGESTION.Controllers
{


    [Route("[controller]")]
    [ApiController]
    [Authorize]
    public class ProductoController : ControllerBase
    {
        private readonly gestionContext _context;
        private IProductoService _producto;
        public ProductoController(gestionContext context)
        {
            _context = context;
        }

        // GET: api/Cliente

        [HttpGet]
        public IActionResult GetProducto()
        {
           var Producto = _producto.GetProductos();
            return Producto;
        }
..demas codigo

I don't know if it's okay like that. It does not give a compilation error but when I go to my client application and request the data it tells me:

System.NullReferenceException: 'Object reference not set to an instance of an object.' _product was null.

I have a Customer component and a Dashboard component and then the login component, but I can't redirect to the login if it hasn't entered:

I have a security folder with an auth.guard.ts file:

import { Injectable } from "@angular/core";
import { Router,CanActivate,ActivatedRouteSnapshot } from "@angular/router";

@Injectable ({providedIn:'root'})
export class AuthGuard implements CanActivate{

    constructor(private route : Router){


    }
    canActivate(route: ActivatedRouteSnapshot){
        this.route.navigate(['login']);
        return false;
    }
}

And this is my app.module.ts:

import { BrowserModule } from "@angular/platform-browser";
import { NgModule,Input } from "@angular/core";
import { BrowserAnimationsModule } from "@angular/platform-browser/animations";
import { Routes, RouterModule } from "@angular/router";
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
// material
import { MatSidenavModule } from "@angular/material/sidenav";
import { MatIconModule } from "@angular/material/icon";
import { MatListModule } from "@angular/material/list";
import { MatTooltipModule } from "@angular/material/tooltip";
import { MatButtonModule } from "@angular/material/button";
import { MatTableModule } from '@angular/material/table' ;
import { MatCardModule } from '@angular/material/card' ;
import { MatDialogModule} from '@angular/material/dialog' ;
import {MatInputModule} from '@angular/material/input';
import {MatSnackBarModule} from '@angular/material/snack-bar';
// components
import { AppComponent } from "./app.component";
import { SidenavComponent } from "./sidenav/sidenav.component";
import { HomeComponent } from "./home/home.component";
import { ClienteComponent } from './cliente/cliente.component';
import { HttpClientModule } from "@angular/common/http";
import { DialogClienteComponent } from "./cliente/dialog/dialogcliente.component";
import { FormsModule,ReactiveFormsModule } from "@angular/forms";
import { DialogDeleteComponent } from "./cliente/common/dialogdelete.component";
import { LoginComponent } from "./login/login.component";

export const ROUTES: Routes = [
  {
    path: "Home",
    component: HomeComponent,
  },
  {
    path: "login",
    component: LoginComponent,
  },
  {
    path: "Clientes",
    component: ClienteComponent,
  },
  
];

@NgModule({
  declarations: [
    AppComponent,
    DialogClienteComponent,
    DialogDeleteComponent,
    SidenavComponent,
    LoginComponent,
    ClienteComponent
  ],
  imports: [
    RouterModule.forRoot(ROUTES, { relativeLinkResolution: 'legacy' }),
    BrowserModule,
    BrowserAnimationsModule,
    MatSidenavModule,
    MatListModule,
    MatIconModule,
    MatTooltipModule,
    MatButtonModule,
    MatTableModule,
    MatDialogModule,
    MatInputModule,
    MatSnackBarModule,
    MatCardModule,
    HttpClientModule,
    FormsModule,
    ReactiveFormsModule,


   
  ],
  bootstrap: [AppComponent],
})
export class AppModule {}

I don't know if someone can help me, if you need another code I'll edit the question.

My app.routing has the following:

import { NgModule } from '@angular/core';
import { RouterModule, Routes } from '@angular/router';
import { ClienteComponent } from './cliente/cliente.component';
import { HomeComponent } from './home/home.component';
import { LoginComponent } from './login/login.component';
import { AuthGuard } from './security/auth.guard';
const routes: Routes = [
  { path: '', redirectTo: 'login', pathMatch: 'full' },
  { path: '**', redirectTo: 'login' },
  {path: 'home',component:HomeComponent,canActivate:[AuthGuard]},
  {path: 'Clientes',component:ClienteComponent,canActivate:[AuthGuard]},
  {path: 'login',component:LoginComponent}
];

@NgModule({
  imports: [RouterModule.forRoot(routes)],
  exports: [RouterModule]
})
export class AppRoutingModule { }

There I show my login component:

import {Component,  OnInit } from "@angular/core";

import { Router } from "@angular/router";

import { ApiAuthService } from "../services/apiauth.service";

@Component({templateUrl:'login.component.html'})
export class LoginComponent implements OnInit{
  
    public user!: string;
    public password!: string;
    constructor(public apiauth:ApiAuthService,
        private router:Router){
          if (this.apiauth.usuarioData){
              this.router.navigate(['/']);
          }
    }
    ngOnInit(){
        
         
       
    }
    login(){
        this.apiauth.login(this.user,this.password).subscribe(response =>{
            if (response.exito===1)   {
                 this.router.navigate(['/']);
            }
            });
       
    }
}

And my apiauthservice.ts:

import { HttpClient, HttpHeaders } from "@angular/common/http";
import { Injectable } from "@angular/core";

import { BehaviorSubject,  map,  Observable } from "rxjs";
import { Usuario } from "../models/usuario";
import { Response } from "../models/response";
const httpOption = {
    headers :new HttpHeaders({
   
   
      'Content-Type' : 'application/json'
    })
  }
@Injectable({
    providedIn:'root'
})
export class ApiAuthService{
   url: string = 'https://localhost:44355/Login' ;
   private usuarioSubject!: BehaviorSubject<Usuario>;
   public get usuarioData():Usuario{
     return this.usuarioSubject.value;
   }
   constructor(private http : HttpClient){
        this.usuarioSubject = new BehaviorSubject<Usuario>(JSON.parse(localStorage.getItem('usuario')!));
   }
   login(user: string, password:string):Observable<Response>{
       return this.http.post<Response>(this.url, {user,password},httpOption).pipe(map(res=>{
         if(res.exito === 1){
            const usuario:Usuario = res.data;
            localStorage.setItem('usuario',JSON.stringify(usuario));
            this.usuarioSubject.next(usuario);
         }
         return res;
       }));
  
   }
   logout(){
     localStorage.removeItem('usuario');
     this.usuarioSubject.next(null!);
   }
}

The canActivate stayed like this but it still doesn't work:

canActivate(route: ActivatedRouteSnapshot){
        const usuario = this.apiauthservice.usuarioData;
        if (usuario){
            return true;
        }else{
        this.route.navigate(['login']);
        return false;
    } 

Follow the steps and the tutorial on this page: sidenav

But I'm left like this:

That is to say, the icons or the menu options are not seen. This is my sidenav.component.ts file:

import { Component, Input, Output, EventEmitter } from "@angular/core";

@Component({
  selector: "side-nav",
  styleUrls: ["./sidenav.component.scss"],
  template: `
    <section [class.sidenav]="isExpanded">
      <div class="toggle">
        <mat-icon (click)="toggleMenu.emit(null)">
          {{ isExpanded ? "keyboard_backspace" : "dehaze" }}
        </mat-icon>
      </div>
      <mat-list class="nav" *ngFor="let route of routeLinks">
        <a
          mat-list-item
          routerLinkActive="active-link"
          class="hover"
          routerLink="{{ route.link }}"
        >
          <mat-icon
            mat-list-icon
            [matTooltip]="!isExpanded ? route.name :'home'",
            matTooltipPosition="right"
          >
            {{ route.icon }}</mat-icon
          >
          <p matLine *ngIf="isExpanded">{{ route.name }}</p>
        </a>
      </mat-list>
    </section>
  `,
})
export class SidenavComponent {
  @Input()
  isExpanded!: string;
  @Output() toggleMenu = new EventEmitter();

  public routeLinks = [
    { link: "home", name: "home", icon: "dashboard" },
    { link: "locations", name: "Locations", icon: "account_balance" },
  ];
}

The sidenav.component.scss file:

.sidenav {
    width: 250px;
  }
  
  .toggle {
    width: 100%;
    display: flex;
    justify-content: space-around;
    padding: 25px 0;
    &:hover {
      cursor: pointer;
    }
  }
  
  .nav {
    .active-link {
      background-color: #fafafa;
      border-left: solid 3px #1976d2;
    }
  
    .hover {
      transition-duration: 400ms;
      transition-timing-function: cubic-bezier(0.25, 0.8, 0.25, 1);
      transition-property: transform, border, background-color;
    }
  
    mat-list-item,
    a {
      border: none;
      box-sizing: border-box;
      text-decoration: none;
      &:hover {
        cursor: pointer;
        background-color: #fafafa;
        border-left: solid 3px #1976d2;
      }
    }
    mat-icon {
      color: #1976d2;
    }
  }

And also apply the styles in the global style.css file:

html,
body {
 height: 100%;
}
body {
 margin: 0;
 font-family: Roboto, "Helvetica Neue", sans-serif;
}

// override material inline style to allow mini nav state
mat-sidenav[style] {
 visibility: visible !important;
}
.mat-drawer {
 transform: none !important;
}

This is my app.component.ts file:

import { Component } from "@angular/core";

@Component({
  selector: "app-root",
  styles: [
    `
      .content-container {
        min-height: 100vh;
        box-sizing: border-box;
        padding: 25px;
      }
    `,
  ],
  template: `
    <mat-sidenav-container autosize>
      <mat-sidenav #sidenav fixedInViewport="true" mode="side" opened>
        <side-nav></side-nav>
      </mat-sidenav>
      <mat-sidenav-content>
        <div class="content-container">
          <button type="button" mat-button (click)="sidenav.toggle()">
            Toggle sidenav
          </button>
          <router-outlet></router-outlet>
        </div>
      </mat-sidenav-content>
    </mat-sidenav-container>
  `,
})
export class AppComponent {
  title(title: any) {
    throw new Error('Method not implemented.');
  } 
   public isExpanded = false;

  public toggleMenu() {
    this.isExpanded = !this.isExpanded;
  }}

But I don't know what I'm doing wrong.

I have contracted a VPS where I have a mysql database to use my application made in Delphi.

The fact is that I already have it configured, in fact I can open the data base from any manager. But when my app is opened in Delphi, a desktop application, before any update or insert a message appears:

MySQL Server has gone away.

The thing is that I work with TClientDataSet, and with the local database it didn't give that error. I don't know what configuration of my server I should modify.

Hello, I have an order form for a distributor, it has the associated customer, the details of the order products, and the order ID in a DBEDit. The initial idea of ​​the form is that when creating it (opening it from the main one) the last created order ID appears, that is, the last one loaded.

I have in the OnCreate event the following:

procedure TPEDIDO.FormCreate(Sender: TObject);
var
 idpedido: Integer;

begin

 Position := poScreenCenter;
 // obtengo el pedido actual

 if DBEdit1.Text <> '' then
 begin
    
    // hago la consulta con este id y obtengo el detalle
    idpedido := StrToInt(DBEdit1.Text);
    DataModule1.qdetpedido.Close;
    DataModule1.qdetpedido.ParamByName('idp').AsInteger := idpedido;
    DataModule1.qdetpedido.ExecSQL();

  end;
   // edito el dataset de cliente para mostrar el nombre en el dbedit
   DataModule1.cdscp.Edit;
   DataModule1.cdscpIdCliente.AsInteger :=
   DataModule1.cdspedidosIdCliente.AsInteger;
   DataModule1.cdsproductos.First;
   // agrego los codigos de articulos a las columnas
   while not DataModule1.cdsproductos.eof do
     begin
       PEDIDO.gpedidotemp.Columns[2].PickList.Add
      (DataModule1.cdsproductosCodigo.AsString);

       PEDIDO.gpedidotemp.Columns[3].PickList.Add
      (DataModule1.cdslistasNombre.AsString);

      DataModule1.cdsproductos.Next;
     end;
end;

As you can see, "qdetpedido" is a TSQLQuery (I work with MySQL) that has an "idp" parameter, which is the idpedido to fetch its data. The query is as follows:

 select * from detallepedido where detallepedido.Idpedido=:idp;

I have a DBEdit to display the name of the associated client, what I am trying to do is position the DataSet cursor so that the name appears, but it does not work either.

And lastly, I charge the alphanumeric codes in the form of a combo in the "gpedidotemp" grid, but the details do not appear.

I am working in Delphi and I have the following code:

    try
     conexion:=TConexion.Create();

    finally
       with DataModule1.qinsertproducto do
      begin
        close;
        sql.Clear;
        SQL.Add('INSERT INTO producto (nombre,unidad,precio,stock,idcat,idmarca,codalfa,aliiva,idsubcat,granel,contenido)');
        SQL.Add(' VALUES  (nombre=:nombre,unidad="u",precio=:precio,stock=:stock,idcat=:idcat,idmarca=:idmarca,codalfa=:codalfa,aliiva=:aliiva,idsubcat=0,granel="n",contenido="1")');
        Params.ParamByName('nombre').Value:=nombre;
        Params.ParamByName('precio').AsFloat:=precio;
        Params.ParamByName('stock').AsFloat:=stock;
        Params.ParamByName('idcat').AsInteger:=cat;
        Params.ParamByName('idmarca').AsInteger:=marca;
        Params.ParamByName('codalfa').AsString:=codalfa;
        Params.ParamByName('aliiva').AsFloat:=iva;

        ExecSQL();
      end;
  end;
end;

For the connection I use the singleton pattern. I share it just in case if it has something to do with it:

unit SingleConexion;

interface

type
TConexion = class
 private
class var _instance: TConexion;
 public
//Global point of access to the unique instance
class function Create: TConexion;

destructor Destroy; override;
 end;

 implementation

 { TSingleton }

 uses MODULODATOS,IniFiles,Forms,Dialogs,Sysutils;

class function TConexion.Create: TConexion;
var
 ini:TIniFile;

begin
  if (_instance = nil) then
   begin
     ini:=TInifile.Create(ExtractFilePath(Application.ExeName) + 'caja.ini');
   with DataModule1.CONEXION do
   begin
        Close;
        DriverName:='MySQL';
        Params.Values['UserName']:=ini.ReadString('admin','User','');
        Params.Values['Password']:=ini.ReadString('admin','Pass','');

        Params.Values['HostName']:=ini.ReadString('admin','IP','');
        Params.Values['DataBase']:=ini.ReadString('admin','bd','');
        Params.Values['Port']:=ini.ReadString('admin','Port','3306');
        Open;

 end;


   _instance:= inherited Create as Self;

  end;
 result:= _instance;
end;

destructor TConexion.Destroy;
 begin
  _instance:= nil;
 inherited;
 end;

end.

The thing is that the idproduct is autoincremental and the values ​​of the variables assigned to the parameters do arrive because I tested them with a ShowMessage. But it inserts a new record with all empty fields.

I want to show a pdf generated from an invoice in a modal, and I want to do this so that the user can send it by email if they want it, and do it as soon as it is issued. The fact is that it is a system in a webhosting in the cloud, so I do not download each invoice. I want to show it when broadcasting it to print it and/or send it by email/whatsapp or download it.

Currently I use fpdf but I see symbols on the screen.

So how could this be achieved:

I currently have this code:

        $('.modal-body').load('/views/modules/facta/imprimeA.php? 
          id='+data,function(){
          $('#myModalPDF').modal({show:true});
      });                
                 

I go to a php file with the invoice id, and get the data.

I appreciate your help.

I'm going to edit the question.

$('.modal-body').load('contentPDF.php?id='+data,function(){
    $('#myModalPDF').modal({show:true});
});  

      <iframe src="/views/modules/facta/imprimeA.php?id="+<?php $_GET['id']; 
    ?>+" style="border: none;">

    </iframe>

And it actually worked. But it looks small AND the options that I mentioned before are not seen:

I have a ticket table in MySQL, the client can pay a little by card and another part in cash. For that I have a movement table with the movement id that leads to another table (card, cash, current account, etc). But when I want to consult with group by, it returns the tickets once but only shows me the cash delivered:

   $query="SELECT * from ticket left join tipocomprobante on 
   tipocomprobante.idtipocomp=ticket.idtipocomp left join cliente on 
   ticket.idc=cliente.idcliente left join movimiento on movimiento.idticket=ticket.idticket 
    WHERE cajero=".$idcajero." AND sesion=".$idsesion." group by ticket.idticket;";

I have tried the query in phpMyAdmin and it does not return the card movements:

  CREATE TABLE `movimiento` (
  `idmov` int(11) NOT NULL,
  `tipomov` int(11) DEFAULT NULL,
  `importe` decimal(10,2) DEFAULT NULL,
  `idticket` int(11) NOT NULL,
  `idcliente` int(11) DEFAULT NULL,
  `idsesion` int(11) DEFAULT NULL,
  `fecha` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL
)

CREATE TABLE `ticket` (
  `idticket` int(11) NOT NULL,
  `fecha` varchar(11) COLLATE utf8_spanish_ci DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `vuelto` decimal(10,2) DEFAULT NULL,
  `hora` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
  `idtipocomp` int(11) DEFAULT NULL,
  `idc` int(11) NOT NULL,
  `cae` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `fechavto` date DEFAULT NULL,
  `cajero` int(11) DEFAULT NULL,
  `sesion` int(11) DEFAULT NULL,
  `pago` varchar(11) COLLATE utf8_spanish_ci DEFAULT NULL
) 

CREATE TABLE `tipomov` (
  `idtipomov` int(11) NOT NULL,
  `nombre` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL
) 

I edit the question:

I have that table where I show the movements of the session. There the idea is that all the tickets appear, with the amount paid in cash, and the amount with a debit or credit card. As you can see, it generates 2 rows in the table for the same ticket, I would like to have each ticket in a single row. Otherwise, you would have to modify the structure of the ticket table and directly add the amount of cash and card. And then check if they are different from 0.

I have a tournament class file and the method of inserting a new one, after inserting makes a query of the id. Said id I want to return it to create the view of groups of players of said tournament, I work with MVC.

 public function registrarTorneo($nombreTorneo,$Fecha,$Localidad,$iddisciplina){
   try

{
                $sqltorneo="INSERT INTO torneo(idtorneo,nombretorneo,Fecha,Localidad,Iddisciplina) VALUES (null,'".$nombreTorneo."','".$Fecha."','".$Localidad."',".$iddisciplina.");";
                $sqlidtorneo='select max(idtorneo) as id from torneo order by idtorneo desc;';
             
                $conexion = Conexion::singleton_conexion();
                $conexion->beginTransaction();
                $conexion->query($sqltorneo);
                $conexion->commit();
                $stm=$conexion->prepare($sqlidtorneo);
          
                $stm->execute();
                $array=$stm->fetchAll(PDO::FETCH_ASSOC);


                 return $array;
         

}catch(Exception $e){
    die($e->getMessage());
    
}
}

then I have the Tournament process where I create an object of that type:

 if (isset($_POST['opcion'])=='crear'){
    $c=new Torneo();
    $nombre=$_POST['nombre'];
    $fecha=$_POST['fecha'];
    $localidad=$_POST['localidad'];
    $dis=$_POST['dis'];
    $grupos=$_POST['grupos'];
    $jpg=$_POST['jxg'];
    $id=$c->registrarTorneo($nombre,$fecha,$localidad,$dis);

 echo json_encode($id);
}

And when I try to get the id I do:data[0].id

If I do: console.log(data)I get: [{"id":"56"}]

$("#nuevotorneo").on("click",function(){
if (validaForm()==true){

    $.ajax({
      type: "POST",
data:{'opcion':'crear','nombre':$("#nombre").val(),'fecha':$("#fechahora").val(),'localidad':$('select[id="localidad"] option:selected').text(),
'dis':$("#disciplina").val(),'grupos':$("#numGrupos").val(),'jxg':$("#numjp").val()},
        url: '/billar/views/modules/torneo/procesoTorneo.php', 
        
        beforeSend: function(){
            /*
            * Esta función se ejecuta durante el envió de la petición al
            * servidor.
            * */
  
      
            },
        complete:function(){
          
          
        },          
        success: function(data){
            /*
            * Se ejecuta cuando termina la petición y esta ha sido
            * correcta
            * */
            console.log(data);

       //   window.location.href="index.php?controller=torneo&action=fasegrupos";
        },
        error: function(){
            /*
            * Se ejecuta si la peticón ha sido erronea
            * */
            alert("Problemas al tratar de enviar el formulario");
        }
    });
    // Nos permite cancelar el envio del formulario
    return false;}    });

So what is the proper way to access the id value?

I have a program in Delphi and in the database I have a table of statistics categories (it has idand nombre), with the idea of ​​assigning each record productoa idcategory to group them.

I want to develop a form where when selecting a category of statistics from a grid or combo it shows me, in another grid, the products in that list (that is, those that have the one idin that list in the table productos) and, finally, another grid with those that are not associated, to be able to associate them.

I have a TClientDataSetand a TDataSetProvidernext to a TDataSourcefor the stat category table.

Then I did 1 TSQLQuerywith a parameter 'id':

 SELECT * FROM productos WHERE Categoria_E=':id';

And this other one:

 SELECT * FROM productos WHERE Categoria_E<>':id';

to associate them to the grids; also via a TClientDataSety provider .

It's okay like that?

If yes, in which event can I associate the value of the parameter idto refresh the grid?

I have a price field in a TClientDataSet that comes from the database but it is calculated, that is, it is saved, but it respects a formula according to freight cost and taxes.

The formula works well mathematically and I have it in the afterpost event:

procedure TDataModule1.cdsproductosAfterPost(DataSet: TDataSet);
begin
 with DataModule1 do
 begin
DataModule1.cdsproductos.Open;

DataModule1.cdsproductos.Edit;
cdsproductosprecioactual.AsFloat:=cdsproductosCosto.AsFloat* 
(cdsproductosGanancia.AsFloat/100)+       
cdsproductosCosto.AsFloat+cdsproductosRedondeo.AsFloat + (cdsproductosCosto.AsFloat * 
(cdsproductosImpuesto.AsFloat/100))+cdsproductosFlete.AsFloat;


end;
end;

So my question is: how do I update the price DBEdit when changing any DBEDit that influences the formula, example: when changing the cost, the price must change and be saved without having to click on the save button.

I have a billing application where if there is no internet, the ticket is saved in an xml file. In the main window I have a DBgrid with the last movements of the day.

The idea is to be able to reprint or send to invoice with the webservice if there was no internet, for example, apart from accounting for the total money entered on the day or shift.

Now, if I load a TClientDataSet with a ticket xml, only "that ticket" will appear. How can I make a query or loop to load all the tickets in a single grid?

Could you iterate over all the files that have today's date? In fact I save the file with the date in the name.

I get Internal Check Error when trying to download Fast Report in GetIt from Delphi 10.3:

Could it be the version of the IDE? How do I update it if yes? I tried with fortes Report and I get the same error.

I have Delphi 10.3 and I want to develop for Android, the thing is that I want to fill a grid (like the DBGrid of desktop applications). With which component could I do it? I tried a TGrid but it doesn't have a Datasource or anything. Thank you

I have a floating button which displays options: open box, close box, and/or print respectively.

But I have the problem that all the buttons print, that is, they send the one submitof the form:

<form method="POST" action="views/modules/caja/reportecaja.php" >
    <div class="row">
        <div class="col-sm-12">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title" style="text-align: center;height: 10px;">DATOS DE SESION</h5>  
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-sm-3">
                            <label>CAJERO.:</label>
                        </div>
                        <div class="col-sm-3">
                            <input type="hidden" name="nombre" value="<?php if (isset($_SESSION['username'])){echo $_SESSION['username'];}?>"/>
                            <label><?php if (isset($_SESSION['username'])){echo $_SESSION['username'];}?></label>
                        </div>
                        <div class="col-sm-3">
                            <label>HORA INICIO:<?php if (isset($_SESSION['inicio'])){echo $_SESSION['inicio'];}?></label>
                        </div> 
                        <div class="col-sm-3">
                            <label>HORA FIN:<?php  date_default_timezone_set("America/Argentina/Buenos_Aires");$horaactual=date("H:i:s"); echo $horaactual;?></label>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-sm-3">
                            <label> Efectivo:</label>
                            <label id="subtotal"></label>
                        </div>
                        <div class="col-sm-3">
                            <label>Cambio:</label>
                        </div>
                        <div class="col-sm-2">
                            <input class="form-control" type="text" name="cambio" placeholder="QUEDA EN CAJA" id="cambio"/>
                        </div>
                        <div class="col-sm-3">
                            <label>Total</label>
                            <label id="total"></label>
                        </div> 
                    </div>
                </div>
            </div> 
        </div> 
    </div>
	<div class="row">
        <div class="col-sm-12">
            <div class="card">
                <div class="card-header">
                    <h5 class="card-title" style="text-align: center;height: 10px;">LISTADO DE MOVIMIENTOS DEL TURNO</h5>  
                </div>
            	<div class="card-body">
                <div class="table-responsive" >                  
                  <table id="resumen" class="table table-hover">
                    <title>Comprobantes</title>
                    <thead class="thead-dark">

                    </thead>
                    <tfoot>
                      <tr>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                        <td></td>
                      </tr>
                    </tfoot>
                    <tbody>

                    </tbody>
                  </table>
                </div>
              </div>
            </div>  
          </div>
          <div class="contenedor">
            <button class="botonF11" id="opciones" data-container="body" data-toggle="popover" data-trigger="hover" data-placement="left" data-content="OPCIONES" style="color: black;">
              <span><i class="fas fa-tasks"></i></span>
            </button>
            <button class="btn2 botonF2" id="abrircaja" data-container="body" data-toggle="popover" data-trigger="hover" data-placement="left" data-content="ABRIR CAJA" style="color: black;">
              <span><i class="fas fa-lock-open"></i></span>
            </button>
            <button class="btn2 botonF3" id="cerrarcaja" data-container="body" data-toggle="popover" data-trigger="hover" data-placement="left" data-content="CERRAR CAJA" style="color: black;">
              <span><i class="fas fa-lock"></i></span>
            </button>
            <button class="btn2 botonF4" id="es" data-container="body" data-toggle="popover" data-trigger="hover" data-placement="left" data-content="ENTRADA/SALIDA" style="color: black;">
              <span><i class="fas fa-dollar-sign"></i></span>
            </button>
            <button class="btn2 botonF5" id="imprimir"  data-container="body" data-toggle="popover" data-trigger="hover" data-placement="left" data-content="IMPRIMIR" style="color: black;">
              <span><i class="fas fa-print"></i></span>
            </button>
          </div>
        </div>
      </form>

How can I include a button and only this one calls the form.

I work with FPDF.

I have this code to list items inside a modal:

function listar(){

    tipofiltro="todos";
	 $.ajax({
	  
            type: "POST",
            url: "../gestionweb/includes/php/filtroP.php",
            data: { "tf": tipofiltro}, 
            dataType: "json",
            error: function(){
                alert("error petición ajax");
            },
            success: function(data){
           content=data;
               for (var i = 0; i < data.length; i++) {
          
                var newRow =
                    "<tr>" +
                    "<td>" + data[i].codalfa + "</td>" +
                    "<td>" + data[i].nombre + "</td>" +
                    "<td>" + data[i].marca + "</td>" +
                    "<td>" + data[i].detalle + "</td>" +
                    "<td>" + data[i].precio + "</td>" +
                         "<td>"+"<input type='text' class='form-control input-sm-2' id='cant' tabindex='3' placeholder='cant'/>" + "</td>" +
   
          
                     "<td>"+
           " <a  class='btn btn-primary' name='agregar' id='"+data.idproducto+"'  >+</a></td>"+
          
                  
                    "</tr>";
                  
                $(newRow).appendTo("#resultadomodal tbody");                 
       
    
               
            }
        
  

        }  
});
};

And as you can see it has an element "a" with the same name and product id, the idea is to add it to the cart, but I can't detect the click. What I did was:

  $("a[name=agregar]").click(function(){

   
      alert('hh');   

    });

I select by name, then I would like to get the id of the item which is the id of the product. Full js code:

$(document).ready(function() {
listar();

$("a[name=agregar]").on('click',function(){


  alert('hh');   

});


var nombreBusqueda;

 $("#nombre").keyup(function() {
            
        nombreBusqueda=$("#nombre").val();
        filtrar(nombreBusqueda);
    });
   $("#cod").keyup(function() {
       
        codBusqueda=$("#cod").val();
        filtrarcod(codBusqueda);
    });
  var id;
  var nombre;
  var marca;
  var producto;
    var precio;


$("#Agregar").click(function(event){
  var cantidad=$("#cant").val();
  
  if (cantidad!==""){
    var accion = "agregar";
    $.ajax({
	  
            type: "POST",
            url: "../gestionweb/includes/php/procesoDetalle.php",
            data: {accion,id,cantidad,nombre,marca,precio}, 
  dataType:'html',
            error: function(){
                alert("error petición ajax");
            },
            success: function(data){
             alert('agre');      
                      
            }
        }).fail( function( jqXHR, textStatus, errorThrown ) {

  if (jqXHR.status === 0) {

    alert('Not connect: Verify Network.');

  } else if (jqXHR.status == 404) {

    alert('Requested page not found [404]');

  } else if (jqXHR.status == 500) {

    alert('Internal Server Error [500].');

  } else if (textStatus === 'parsererror') {

    alert('Requested JSON parse failed.');

  } else if (textStatus === 'timeout') {

    alert('Time out error.');

  } else if (textStatus === 'abort') {

    alert('Ajax request aborted.');

  } else {

    alert('Uncaught Error: ' + jqXHR.responseText);

  }

});

    
  } else{
    alert("ingrese cantidad");
  }
});



function filtrarcod(dato){
        var filtrado=[];
        var existe;
    for(var i = 0; i < content.length; i++) {
 if (content[i].codalfa.toLowerCase().indexOf(dato.toLowerCase())!=-1) {
        filtrado.push(content[i]);
        
       
    }
}
     if (filtrado.length>0) {
        
            $("#resultadomodal tbody").empty();
        
            for (var i = 0; i < filtrado.length; i++) {
          
                var newRow =
                    "<tr>" +
                    "<td>" + filtrado[i].codalfa + "</td>" +
                    "<td>" + filtrado[i].nombre + "</td>" +
                    "<td>" + filtrado[i].marca + "</td>" +
                    "<td>" + filtrado[i].detalle + "</td>" +
                    "<td>" + filtrado[i].precio + "</td>" +
                          "<td>"+"<input type='text'class='form-control input-sm' id='cant'tabindex='3' placeholder='cant'/>" + "</td>" +
   
          
                     "<td>"+
           " <a  class='btn btn-primary' name='agregar' id='"+filtrado.idproducto+"'>+</a></td>"+
          
                  
                    "</tr>";
                  
                $(newRow).appendTo("#resultadomodal tbody");                 
       }
	
  
}};
function filtrar(dato){
        var filtrado=[];
        var existe;
    for(var i = 0; i < content.length; i++) {
    if (content[i].nombre.toLowerCase().indexOf(dato.toLowerCase())!=-1) {
        filtrado.push(content[i]);
        
       
    }
}
     if (filtrado.length>0) {
        
      $("#resultadomodal tbody").empty();
        
            for (var i = 0; i < filtrado.length; i++) {
          
                var newRow =
                    "<tr>" +
                    "<td>" + filtrado[i].codalfa + "</td>" +
                    "<td>" + filtrado[i].nombre + "</td>" +
                    "<td>" + filtrado[i].marca + "</td>" +
                    "<td>" + filtrado[i].detalle + "</td>" +
                    "<td>" + filtrado[i].precio + "</td>" +
                    "<td>"+"<input type='text' class='form-control input-sm' id='cant'tabindex='3' placeholder='cant'/>" + "</td>" +
   
          
                     "<td>"+
           " <a  class='btn btn-primary' name='agregar' id='"+filtrado.idproducto+"' >+</a></td>"+
          
                  
                    "</tr>";
                  
                $(newRow).appendTo("#resultadomodal tbody");                 
       }
 
	
  
}};
function listar(){

    tipofiltro="todos";
	 $.ajax({
	  
            type: "POST",
            url: "../gestionweb/includes/php/filtroP.php",
            data: { "tf": tipofiltro}, 
            dataType: "json",
            error: function(){
                alert("error petición ajax");
            },
            success: function(data){
           content=data;
               for (var i = 0; i < data.length; i++) {
          
                var newRow =
                    "<tr>" +
                    "<td>" + data[i].codalfa + "</td>" +
                    "<td>" + data[i].nombre + "</td>" +
                    "<td>" + data[i].marca + "</td>" +
                    "<td>" + data[i].detalle + "</td>" +
                    "<td>" + data[i].precio + "</td>" +
                         "<td>"+"<input type='text' class='form-control input-sm-2' id='cant' tabindex='3' placeholder='cant'/>" + "</td>" +
   
          
                     "<td>"+
           " <a  class='btn btn-primary' name='agregar' id='"+data.idproducto+"'  >+</a></td>"+
          
                  
                    "</tr>";
                  
                $(newRow).appendTo("#resultadomodal tbody");                 
       
    
               
            }
        
  

        }  
});
}
});

I am making a sales module and with a button I go to the list of clients. When you click on a row in the table, in the AJAX request I want to call the index and pass the idcliente as a parameter to consult it in the ready. Because I don't want to use sessions because it's not a sales cart, it's a spontaneous sale in a store.

$('#clientes tbody').on('click','tr', function(evt){
    
       $(this).find('input:radio').prop('checked', true);
 var idc= $('input:radio[name=seleccion]:checked').attr("id");
alert(idc);
    var accion = 'asociar';
    $.ajax({
	  
            type: "POST",
  
            data: {"idc":idc,"accion":accion}, 
            

            error: function(){
                alert("error petición ajax");
            },
           success: function(data){
          
            window.location.href ="index.php?controller=venta&action=index?id=".idc;
           }
           
        });
}); });

I use the model view controller. If I pass a fixed number inside the string it works perfectly... but not with the variable.

I get undefined repeatedly in a select. I load it this way:

function listarcategorias(){
    accion="listadocat";
    $.ajax({
	  
            type: "POST",
            url: "../gestionweb/includes/php/getcategoria.php",
            data: {"accion":accion}, 
            

            error: function(){
                alert("error petición ajax");
            },
            success: function(data){
                
       console.log(data);
               for (var i = 0; i < data.length; i++) {
                
        
                var newRow ="<option id="+data[i].idcategoria+">"+data[i].categoria+"</option>";
                  
                $(newRow).appendTo("#cat");                 
       
    
               
            }
           
        }
});}

So I have the select in html:

<label class="col-sm-1 control-label">CATEGORIA</label><select id="cat"></select>

And the console.log returns the array well:

[{"idcategoria":"1","categoria":"Fiambre"},{"idcategoria":"2","categoria":"Quesos"},{"idcategoria":"3","categoria":"general"},{"idcategoria":"4","categoria":"construccion en seco"}]

any help?

I have this JQUERY code:

$(document).ready(function() {
listarDetalle();

});
function listarDetalle(){
     var accion="listar";
       var URLprotocol = window.location.protocol;
    $.ajax({
     
            type: "POST",
            url: URLprotocol+"//gestionweb/includes/php/procesoDetalle.php",
            data: { "accion":accion}, 
            dataType:'json',
        
            error: function(){
                alert("error petición ajax");
               
            },
            
            success: function(data){
                console.log(data);
             
                                   
               for (var i = 0; i < data.length; i++) {
        
                var newRow =
                    "<tr>" +
                    "<td>" + data[i].idp + "</td>" +
                    "<td>" + data[i].nombre + "</td>" 
                    "<td>" + data[i].marca + "</td>" +
                    "<td>" + data[i].cantidad + "</td>" +
                    "<td><input type='radio' id='"+data[i].idproducto+"' name='seleccion'/></td>"+
                    "</tr>";
                $(newRow).appendTo("#ticket tbody");                 
       
    
               
            
        
  

        } }
        
}).fail( function( jqXHR, textStatus, errorThrown ) {

  if (jqXHR.status === 0) {

    alert('Not connect: Verify Network.');

  } else if (jqXHR.status == 404) {

    alert('Requested page not found [404]');
  

  } else if (jqXHR.status == 500) {

    alert('Internal Server Error [500].');

  } else if (textStatus === 'parsererror') {

    alert('Requested JSON parse failed.');

  } else if (textStatus === 'timeout') {

    alert('Time out error.');

  } else if (textStatus === 'abort') {

    alert('Ajax request aborted.');

  } else {

    alert('Uncaught Error: ' + jqXHR.responseText);

  }

});;

};

And I get this error:

Blocked Cross-Origin Request: The Same-Origin Policy does not allow reading the remote resource at http://gestionweb/includes/php/procesoDetalle.php . (Reason: CORS request was rejected.)

Try with:

dataType:'jsonp',

That I found on a website, but if I do that it tells me that the script load failed. I really don't know what to do. I enclose images of google chrome of the headers... the address appears well, let's say it is:

http://localhost/gestionweb/includes/php/procesoDetalle.php

As you can see, it gives the error 302 in DetailProcess.php as the resource was moved but I don't understand.

I call it from another script and all good