Quisiera saber si el insert que estoy haciendo está bien
public function crearCotizacion(){
$c= new conectar();
$conexion=$c->conexion();
date_default_timezone_set("America/Lima");
$fecha = date("d-m-Y H:i:s");
//$idventa = self::creaFolio();
//$idclient= self::nombreCliente($idCliente);
$datos=$_SESSION['tablaCotizacionTemp'] && $_SESSION['tablaCotizacionCienteTemp'];
//$datos2=$_SESSION['tablaCotizacionCienteTemp'];
$idusuario=$_SESSION['iduser'];
$id_cotizacion = "1";
$r=0;
for ($j=0; $j < count($datos2) ; $j++) {
$e=explode("||", $datos2[$j]);
for ($i=0; $i < count($datos) ; $i++) {
$d=explode("||", $datos[$i]);
$mysqli->query("INSERT INTO prints(
id_user,
dateOrder,
delivery_term,
delivery_method,
warehouse)
VALUES(
'$idusuario',
'$fecha',
'$e[5]',
'$e[6]',
'$e[7]')");
$mysqli->query("INSERT INTO quotes(
id_clients,
id_print,
dateQuo,
way_to_pay,
comments,
type_of_currency
)VALUES(
'$e[8]',
'$mysqli->id_print',
'$e[1],
'$e[2]',
'$e[4]',
'$e[3]')");
$mysqli->query("INSERT INTO detail_quo(
id_quotation,
description,
unit_of_measurement,
time_garanty,
quantity,
price_unit,
price_discount,
sub_total
)VALUES(
'id_cotizacion',
'$d[0]',
'$d[1]',
'$d[2]',
'$d[3]',
'$d[4]',
'$d[5]',
'$d[6]')");
$mysqli->query("INSERT INTO pay(
id_detail_quo,
quo_total,
igv,
total_igv,
)VALUES(
'$mysqli->id_detail_quo',
'$d[8]',
'$d[9]',
'$d[10]')");
$r=$r + $result=mysqli_query($conexion,$mysqli)or die(mysqli_error($db));
}
}
return $r;
//self::descuentaCantidad($d[0], 1);
}public function crearCotizacion(){
$c= new conectar();
$conexion=$c->conexion();
date_default_timezone_set("America/Lima");
$fecha = date("d-m-Y H:i:s");
//$idventa = self::creaFolio();
//$idclient= self::nombreCliente($idCliente);
$datos=$_SESSION['tablaCotizacionTemp'] && $_SESSION['tablaCotizacionCienteTemp'];
//$datos2=$_SESSION['tablaCotizacionCienteTemp'];
$idusuario=$_SESSION['iduser'];
$id_cotizacion = "1";
$r=0;
for ($j=0; $j < count($datos2) ; $j++) {
$e=explode("||", $datos2[$j]);
for ($i=0; $i < count($datos) ; $i++) {
$d=explode("||", $datos[$i]);
$mysqli->query("INSERT INTO prints(
id_user,
dateOrder,
delivery_term,
delivery_method,
warehouse)
VALUES(
'$idusuario',
'$fecha',
'$e[5]',
'$e[6]',
'$e[7]')");
$mysqli->query("INSERT INTO quotes(
id_clients,
id_print,
dateQuo,
way_to_pay,
comments,
type_of_currency
)VALUES(
'$e[8]',
'$mysqli->id_print',
'$e[1],
'$e[2]',
'$e[4]',
'$e[3]')");
$mysqli->query("INSERT INTO detail_quo(
id_quotation,
description,
unit_of_measurement,
time_garanty,
quantity,
price_unit,
price_discount,
sub_total
)VALUES(
'id_cotizacion',
'$d[0]',
'$d[1]',
'$d[2]',
'$d[3]',
'$d[4]',
'$d[5]',
'$d[6]')");
$mysqli->query("INSERT INTO pay(
id_detail_quo,
quo_total,
igv,
total_igv,
)VALUES(
'$mysqli->id_detail_quo',
'$d[8]',
'$d[9]',
'$d[10]')");
$r=$r + $result=mysqli_query($conexion,$mysqli)or die(mysqli_error($db));
}
}
return $r;
//self::descuentaCantidad($d[0], 1);
}