$css->CrearSelectChosen("TxtTercero", $VarSelect);
$sql = "SELECT * FROM clientes";
$Consulta = $obVenta->Query($sql);
while ($DatosProveedores = $obVenta->FetchArray($Consulta)) {
$Sel = 0;
$css->CrearOptionSelect($DatosProveedores["idClientes"], "{$DatosProveedores['RazonSocial']} {$DatosProveedores['Num_Identificacion']}", $Sel);
}
$css->CerrarSelect();
print "</td>";
$css->CierraFilaTabla();
$css->FilaTabla(14);
print "<td colspan='2' style='text-align:center'>";
$css->CrearTextArea("TxtConcepto", "Concepto:<br>", "", "Concepto", "black", "", "", 200, 80, 0, 1);
print "</td>";
print "<td colspan='2' style='text-align:center'>";
$css->CrearInputNumber("TxtTotal", "Number", "Total:<br>", "", "Total", "Black", "", "", 120, 30, 0, 1, 1, "", 1);
print "<br>";
$css->CrearBotonConfirmado("BtnGuardarAnticipo", "Guardar");
print "</td>";
$css->CierraFilaTabla();
$css->CerrarTabla();
$css->CerrarForm();
$css->CerrarDiv();
//Cerramos contenedor Secundario
$css->CerrarDiv();
//Cerramos contenedor Principal
$css->AgregaJS();
//Agregamos javascripts
$css->AgregaSubir();
$css->Footer();
print "</body></html>";
$css->CrearOptionSelect($DatosProveedores['idPUC'] . ';' . $NombreCuenta, "{$DatosProveedores['idPUC']} {$DatosProveedores['Nombre']}", $Sel);
}
//En subcuentas se debera cargar todo el PUC
$sql = "SELECT * FROM subcuentas";
$Consulta = $obVenta->Query($sql);
while ($DatosProveedores = $obVenta->FetchArray($Consulta)) {
$Sel = 0;
$NombreCuenta = str_replace(" ", "_", $DatosProveedores['Nombre']);
$css->CrearOptionSelect($DatosProveedores['PUC'] . ';' . $NombreCuenta, "{$DatosProveedores['PUC']} {$DatosProveedores['Nombre']}", $Sel);
}
$css->CerrarSelect();
print "</td>";
$css->CierraFilaTabla();
$css->FilaTabla(16);
print "<td>";
$css->CrearInputNumber("TxtValorItem", "number", "<strong>Valor:</strong><br>", "", "Valor", "black", "", "", 220, 30, 0, 1, 1, "", 1);
print "<br>";
$css->CrearSelect("CmbDebitoCredito", "");
$css->CrearOptionSelect("D", "Debito", 1);
$css->CrearOptionSelect("C", "Credito", 0);
$css->CerrarSelect();
print "</td>";
print "<td>";
$css->CrearTextArea("TxtConceptoEgreso", "<strong>Concepto:</strong><br>", "", "Escriba el Concepto", "black", "", "", 300, 100, 0, 1);
print "</td>";
print "<td>";
$css->CrearInputText("TxtNumFactura", "text", 'Numero del Documento soporte:<br>', "", "Numero del documento", "black", "", "", 300, 30, 0, 1);
echo "<br>";
$css->CrearUpload("foto");
echo "<br>";
echo "<br>";
$css->CrearInputText("TxtIVA", "number", 'IVA:<br>', "0", "IVA", "IVA", "onkeyup", "CalculeTotal()", 150, 30, 0, 1);
$css->CrearSelect("CmbIVADes", "", "black", "", 1);
$css->CrearOptionSelect(2408, "Descontable", 1);
$css->CrearOptionSelect(521570, "No Descontable", 0);
$css->CerrarSelect();
print "<br>";
$css->CrearInputText("TxtTotal", "number", 'Total:<br>', "", "Total", "black", "", "", 150, 30, 1, 1);
print "<br>";
print "Aplicar retenciones?<br>";
$css->CrearSelect("CmbRetenciones", "MuestraOculta('DivRetenciones')");
$css->CrearOptionSelect("NO", "NO", 0);
$css->CrearOptionSelect("SI", "SI", 0);
$css->CerrarSelect();
print "<br>";
$css->CrearDiv("DivRetenciones", "container", "left", 0, 1);
$css->CrearInputNumber("TxtRetefuente", "number", "Retefuente:<br>", 0, "", "black", "", "", 150, 30, 0, 1, 0, "", "any");
print "<br>";
$css->CrearInputNumber("TxtReteICA", "number", "Rete-ICA:<br>", 0, "", "black", "", "", 150, 30, 0, 1, 0, "", "any");
print "<br>";
$css->CrearInputNumber("TxtReteIVA", "number", "ReteIVA:<br>", 0, "", "black", "", "", 150, 30, 0, 1, 0, "", "any");
print "<br>";
$css->CerrarDiv();
$css->CrearBotonConfirmado("BtnGuardarEgreso", "Guardar");
print "</td>";
$css->CierraFilaTabla();
$css->CierraFilaTabla();
$css->CerrarTabla();
$css->CerrarForm();
} else {
$css->CrearTabla();
$css->CrearFilaNotificacion("No se ha seleccionado un tipo de egreso", 16);
$Total = round($Total + $DatosItems["Total"]);
$css->FilaTabla(14);
$css->ColTabla($DatosItems["Referencia"], 1);
$css->ColTabla($DatosItems["Descripcion"], 1);
$css->ColTabla($DatosItems["Cantidad"], 1);
$css->ColTabla($DatosItems["Multiplicador"], 1);
$css->ColTabla(number_format($DatosItems["Subtotal"]), 1);
$css->CierraFilaTabla();
}
$css->FilaTabla(16);
//$css->ColTabla('AGREGAR UNIDADES AL MULTIPLICADOR',3);
//print("<td>");
$css->CrearInputText("TxtSubtotalH", "hidden", "", $Subtotal, "", "", "", "", 300, 30, 0, 1);
$css->CrearInputText("TxtIVAH", "hidden", "", $IVA, "", "", "", "", 300, 30, 0, 1);
$css->CrearInputText("TxtTotalH", "hidden", "", $Total, "", "", "", "", 300, 30, 0, 1);
$css->CrearInputNumber("TxtDias", "hidden", "", 1, "Dias", "black", "onchange", "calculetotaldias()", 80, 30, 0, 1, 1, 1000, "any");
//print("</td>");
$css->CierraFilaTabla();
$css->FilaTabla(16);
$css->ColTabla('SUBTOTAL', 3);
print "<td>";
$css->CrearInputNumber("TxtSubtotal", "number", "", $Subtotal, "Subtotal", "black", "", "", 200, 30, 1, 1, 0, "", "any");
print "</td>";
$css->CierraFilaTabla();
$css->FilaTabla(16);
$css->ColTabla('IVA', 3);
print "<td>";
$css->CrearInputNumber("TxtIVA", "number", "", $IVA, "IVA", "black", "", "", 200, 30, 1, 1, 0, "", "any");
print "</td>";
$css->CierraFilaTabla();
$css->FilaTabla(16);
$css->ColTabla("<strong>Descripcion</strong>", 1);
$css->ColTabla("<strong>Valor Unitario / Cantidad</strong>", 1);
$css->ColTabla("<strong>Total Item</strong>", 1);
$css->ColTabla("<strong>Borrar</strong>", 1);
$css->CierraFilaTabla();
while ($DatosItemsCotizacion = mysql_fetch_array($consulta)) {
$idItem = $DatosItemsCotizacion["ID"];
$css->FilaTabla(16);
$css->ColTabla($DatosItemsCotizacion["Referencia"], 1);
$css->ColTabla($DatosItemsCotizacion["Descripcion"], 1);
$DatosProducto = $obVenta->DevuelveValores($DatosItemsCotizacion["TablaOrigen"], "Referencia", $DatosItemsCotizacion["Referencia"]);
print "<td>";
$css->CrearForm("FormEditarCotizacion{$idItem}", $myPage, "post", "_self");
$css->CrearInputText("TxtIdCotizacion", "hidden", "", $idCotizacion, "", "", "", "", "", "", 0, 0);
$css->CrearInputText("TxtIdItemCotizacion", "hidden", "", $idItem, "", "", "", "", "", "", 0, 0);
$css->CrearInputNumber("TxtValorUnitario", "number", "", $DatosItemsCotizacion["ValorUnitario"], "ValorUnitario", "black", "", "", 120, 30, 0, 1, $DatosProducto["CostoUnitario"], $DatosItemsCotizacion["ValorUnitario"] . "0", "any");
$css->CrearInputNumber("TxtCantidad", "number", "", $DatosItemsCotizacion["Cantidad"], "ValorUnitario", "black", "", "", 80, 30, 0, 1, 1.0E-5, "", "any");
$css->CrearBotonVerde("BtnEditar", "E");
$css->CerrarForm();
print "</td>";
$css->ColTabla($DatosItemsCotizacion["Subtotal"], 1);
$css->ColTablaDel($myPage, "cot_itemscotizaciones", "ID", $DatosItemsCotizacion['ID'], $idCotizacion);
$css->CierraFilaTabla();
}
$css->CerrarTabla();
/////////////////Mostramos Totales y Se crea el formulario para guardar la devolucion
////
////
$Subtotal = $obVenta->Sume("cot_itemscotizaciones", "Subtotal", "WHERE NumCotizacion='{$idCotizacion}'");
$IVA = $obVenta->Sume("cot_itemscotizaciones", "IVA", "WHERE NumCotizacion='{$idCotizacion}'");
$Total = $obVenta->Sume("cot_itemscotizaciones", "Total", "WHERE NumCotizacion='{$idCotizacion}'");
$css->CrearSelect2($DatosSelect);
$css->CrearOptionSelect("", "SELECCIONE UNA CUENTA", 0);
$Consulta = $obVenta->ConsultarTabla("cuentasfrecuentes", "WHERE ClaseCuenta='ACTIVOS'");
while ($DatosCuentas = $obVenta->FetchArray($Consulta)) {
$css->CrearOptionSelect($DatosCuentas["CuentaPUC"], $DatosCuentas["Nombre"], 0);
}
$css->CerrarSelect();
print "<br>";
print "<br><strong>Te Realizaron Retenciones? </strong><br>";
$css->CrearSelect("CmbRetenciones", "MuestraOculta('DivRetenciones')");
$css->CrearOptionSelect("NO", "NO", 1);
$css->CrearOptionSelect("SI", "SI", 0);
$css->CerrarSelect();
print "<br>";
$css->CrearDiv("DivRetenciones", "", "center", 0, 1);
$css->CrearInputNumber("TxtRetefuente", "number", "Retefuente:<br>", 0, "", "black", "onkeyup", "CalculeTotalPagoIngreso()", 150, 30, 0, 1, 0, "", "any");
print "<br>";
$css->CrearInputNumber("TxtReteICA", "number", "Rete-ICA:<br>", 0, "", "black", "onkeyup", "CalculeTotalPagoIngreso()", 150, 30, 0, 1, 0, "", "any");
print "<br>";
$css->CrearInputNumber("TxtReteIVA", "number", "ReteIVA:<br>", 0, "", "black", "onkeyup", "CalculeTotalPagoIngreso()", 150, 30, 0, 1, 0, "", "any");
print "<br>";
$css->CerrarDiv();
print "<br>";
$css->CrearInputNumber("TxtPagoH", "hidden", "", $DatosCartera["Saldo"], "", "", "", "", "", 30, 1, 1, 1, 1, "", "any");
$css->CrearInputNumber("TxtPago", "number", "Total Pago: <br>", $DatosCartera["Saldo"], "", "black", "", "", 200, 30, 0, 0, 1, $DatosCartera["Saldo"], 1);
print "<br>";
$css->CrearBotonConfirmado("BtnGuardarPago", "Guardar");
print "</td>";
$css->CerrarTabla();
$css->CerrarForm();
} else {
$css->CerrarTabla();
/////////////////Cuadro de dialogo de Clientes create
$css->CrearCuadroDeDialogo("AgregarItemOC", "Agregar un Item a Esta OC");
$css->CrearForm2("FrmAgregaItemsOC", $myPage, "post", "_self");
$css->CrearInputText("TxtIdOT", "hidden", "", $idOT, "", "", "", "", "", "", "", "");
$VarSelect["Ancho"] = 200;
$VarSelect["PlaceHolder"] = "Seleccione un Producto";
$css->CrearSelectChosen("CmbProducto", $VarSelect);
$Consulta = $obVenta->ConsultarTabla("productosventa", "");
$css->CrearOptionSelect("NO", "SELECCIONE EL PRODUCTO A AGREGAR", 0);
while ($DatosProducto = $obVenta->FetchArray($Consulta)) {
$css->CrearOptionSelect($DatosProducto[0], $DatosProducto["Nombre"] . " " . $DatosProducto["Referencia"], 0);
}
$css->CerrarSelect();
print "<br><br>";
$css->CrearInputNumber("TxtCantidad", "number", "Cantidad:", 1, "Valor Unitario", "black", "", "", 200, 30, 0, 1, 0, 100000000, "any");
print "<br><br>";
$css->CrearInputNumber("TxtValorUnitario", "number", "Valor Unitario:", "", "Valor Unitario", "black", "", "", 200, 30, 0, 1, 0, 100000000, "any");
print "<br><br>";
$VarSelect["Ancho"] = 200;
$VarSelect["PlaceHolder"] = "Seleccione el IVA";
$css->CrearSelectChosen("CmbIVA", $VarSelect);
$Consulta = $obVenta->ConsultarTabla("porcentajes_iva", "");
$css->CrearOptionSelect("NO", "SELECCIONE EL IVA DE ESTE PRODUCTO", 0);
while ($DatosIVA = $obVenta->FetchArray($Consulta)) {
$css->CrearOptionSelect($DatosIVA[0], $DatosIVA["Nombre"], 0);
}
$css->CerrarSelect();
print "<br><br>";
$css->CrearBotonVerde("BtnAgregarItemOT", "Agregar Item");
$css->CerrarForm();
$css->ColTabla('Referencia', 1);
$css->ColTabla('Descripcion', 1);
$css->ColTabla('Cantidad _ Multiplicador _ ValorUnitario', 2);
$css->ColTabla('Subtotal', 1);
$css->ColTabla('Borrar', 1);
$css->CierraFilaTabla();
while ($row = mysql_fetch_array($pa)) {
$css->FilaTabla(16);
$css->ColTabla($row['Referencia'], 1);
$css->ColTabla($row['Descripcion'], 1);
print "<td colspan=2>";
$css->CrearForm2("FrmEdit{$row['ID']}", $myPage, "post", "_self");
$css->CrearInputText("TxtIdCliente", "hidden", "", $idClientes, "", "", "", "", 0, 0, 0, 0);
$css->CrearInputText("TxtTabla", "hidden", "", $row["Tabla"], "", "", "", "", 0, 0, 0, 0);
$css->CrearInputText("TxtPrecotizacion", "hidden", "", $row["ID"], "", "", "", "", 0, 0, 0, 0);
$css->CrearInputNumber("TxtEditar", "number", "", $row["Cantidad"], "", "black", "", "", 100, 30, 0, 1, 0, "", "any");
$css->CrearInputNumber("TxtMultiplicador", "number", "", $row["Multiplicador"], "", "black", "", "", 100, 30, 0, 1, 1, "", "any");
$css->CrearInputNumber("TxtValorUnitario", "number", "", $row["ValorUnitario"], "", "black", "", "", 150, 30, 0, 1, $row["PrecioCosto"], $row["ValorUnitario"] * 10, "any");
$css->CrearBoton("BtnEditar", "E");
$css->CerrarForm();
print "</td>";
$css->ColTabla(number_format($row['SubTotal']), 1);
$css->ColTablaDel($myPage, "precotizacion", "ID", $row['ID'], $idClientes);
$css->CierraFilaTabla();
}
}
$css->CerrarTabla();
$Subtotal = $obVenta->SumeColumna("precotizacion", "SubTotal", "idUsuario", $idUser);
$IVA = $obVenta->SumeColumna("precotizacion", "IVA", "idUsuario", $idUser);
$Total = $Subtotal + $IVA;
$css->CrearForm("FrmGuarda", $myPage, "post", "_self");
$DatosItems = $obVenta->DevuelveValores("cot_itemscotizaciones", "ID", $DatosItemRemision["idItemCotizacion"]);
$Entregas = $obVenta->Sume('rem_relaciones', "CantidadEntregada", " WHERE idItemCotizacion={$DatosItemRemision['idItemCotizacion']} AND idRemision={$idRemision}");
$Salidas = $obVenta->Sume("rem_pre_devoluciones", "Cantidad", " WHERE idItemCotizacion={$DatosItemRemision['idItemCotizacion']} AND idRemision={$idRemision}");
$Salidas2 = $obVenta->Sume("rem_devoluciones", "Cantidad", " WHERE idItemCotizacion={$DatosItemRemision['idItemCotizacion']} AND idRemision={$idRemision}");
$PendienteDevolver = $Entregas - $Salidas - $Salidas2;
///////////////Creo Formulario para edicion
$css->FilaTabla(14);
$css->ColTabla($DatosItems["Referencia"], 1);
$css->ColTabla($DatosItems["Descripcion"], 1);
$css->ColTabla($DatosItemRemision["FechaEntrega"], 1);
$css->ColTabla($Entregas, 1);
print "<td width='40%'>";
$css->CrearFormularioEvento("FrmEditar{$DatosItems['ID']}", $myPage, "post", "_self", "");
$css->CrearInputText("TxtIdItem", "hidden", "", $DatosItems["ID"], "", "black", "", "", 150, 30, 0, 0);
$css->CrearInputText("TxtAsociarRemision", "hidden", "", $idRemision, "", "black", "", "", 150, 30, 0, 0);
$css->CrearInputNumber("TxtSubtotalUnitario", "number", "Valor: ", $DatosItems["ValorUnitario"], "Valor Unitario", "black", "", "", 80, 30, 0, 1, '', '', "any");
$css->CrearInputNumber("TxtCantidadDevolucion", "number", " Cantidad: ", $PendienteDevolver, "Devuelve", "black", "", "", 70, 30, 0, 1, 1, $PendienteDevolver, "any");
$css->CrearInputNumber("TxtDias", "number", " X: ", $DatosItems["Multiplicador"], "Dias", "black", "", "", 70, 30, 0, 1, 1, 1000, "any");
$css->CrearBotonVerde("BtnEditar", "+");
$css->CerrarForm();
print "</td>";
if ($PendienteDevolver > 0) {
$cstyle = "color:RED;";
} else {
$cstyle = "color:Black;";
}
print "<td style={$cstyle}><h4>{$PendienteDevolver}</h4></td>";
$css->CierraFilaTabla();
}
/////Creamos el boton para agregar toda la remision a la devolucion
/// Pensado a futuro
print "<td>";
$css->CreaBotonDesplegable("AgregarItemOT", "Agregar un Item a Esta OT");
print "</td>";
$css->CierraFilaTabla();
$css->CerrarTabla();
/////////////////Cuadro de dialogo de Clientes create
$css->CrearCuadroDeDialogo("AgregarItemOT", "Agregar un Item a Esta OT");
$css->CrearForm2("FrmAgregaItemsOT", $myPage, "post", "_self");
$css->CrearInputText("TxtIdOT", "hidden", "Actividad:", $idOT, "", "", "", "", "", "", "", "");
$css->CrearTextArea("TxtActividad", "", "", "Describa la actividad a realizar", "", "", "", 200, 100, 0, 1);
print "<br>";
$css->CrearInputText("TxtFechaIni", "text", "Fecha de Inicio:", date("Y-m-d"), "Fecha Inicio", "black", "", "", 200, 30, 0, 1);
print "<br>";
$css->CrearInputText("TxtFechaFin", "text", "Fecha Final:", date("Y-m-d"), "Fecha Fin", "black", "", "", 200, 30, 0, 1);
print "<br>";
$css->CrearInputNumber("TxtHoras", "number", "Tiempo Estimado para esta Actividad:", 1, "Tiempo Estimado", "black", "", "", 200, 30, 0, 1, 0, 100000000, "any");
print "<br>";
$css->CrearTextArea("TxtObservaciones", "", "", "Observaciones a tener en cuenta", "", "", "", 200, 100, 0, 0);
print "<br>";
$VarSelect["Ancho"] = 200;
$VarSelect["PlaceHolder"] = "Seleccione un Colaborador";
$css->CrearSelectChosen("CmbColaborador", $VarSelect);
$Consulta = $obVenta->ConsultarTabla("colaboradores", "");
while ($DatosColaboradores = $obVenta->FetchArray($Consulta)) {
$css->CrearOptionSelect($DatosColaboradores[0], $DatosColaboradores["Nombre"], 0);
}
$css->CerrarSelect();
$css->CrearBotonVerde("BtnAgregarItemOT", "Agregar Item");
$css->CerrarForm();
$css->CerrarCuadroDeDialogo();
$css->CrearTabla();