Public feed
#723227
<?php header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: filename=\"RENOMBRAR.XLS\";"); error_reporting("E_ALL & ~E_NOTICE"); $numfactura = $_POST["numfactura"]; ?> <table CELLPADDING=1 CELLSPACING=0 border="1" style="border-collapse: collapse; border-spacing:0.5em;"> <tr> <th>itemno</th> <th>codigo_de_barra</th> <th>Fecha de Compra</th> <th>Num. Fact.Proveed.</th> <th>Ubicacion</th> <th>Clave del Proveedor</th> <th>Departamento</th> <th>Clase</th> <th>KT</th> <th>Linea de Producto</th> <th>Corte</th> <th>Forma o Figura Principal</th> <th>Forma o Figura Complementaria</th> <th>Diseño</th> <th>Otros</th> <th>Peso Pieza</th> <th>Descripcion Detallada</th> <th>Nombre Piedra Central</th> <th>Corte Piedra</th> <th>Num Piedras</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso_Piedra</th> <th>Costo Piedra</th> <th>Qty</th> <th>Piezas</th> <th>Precio de Compra</th> <th>Factor</th> <th>Precio de Venta</th> <th>Consignacion</th> <th>Proveedor1</th> <th>Proveedor2</th> <th>Comentarios</th> <th>BTAG_1</th> <th>BTAG_2</th> <th>BTAG_3</th> <th>BTAG_4</th> <th>BTAG_5</th> <th>BTAG_6</th> <th>BTAG_7</th> <th>Foto</th> <th>Nombre Piedra1</th> <th>Corte Piedra</th> <th>Num Piedras</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso Piedra</th> <th>Costo Piedra</th> <th>Nombre Piedra3</th> <th>Corte Piedra</th> <th>Num Piedras</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso Piedra</th> <th>Costo Piedra</th> <th>Nombre Piedra4</th> <th>Corte Piedra</th> <th>Num Piedras</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso Piedra</th> <th>Costo Piedra</th> <th>Diamante1</th> <th>Corte Dia</th> <th>Num Dia</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso Dia</th> <th>Costo Dia</th> <th>Diamante2</th> <th>Corte Dia</th> <th>Num Dia</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso Dia</th> <th>Costo Dia</th> <th>Diamante3</th> <th>Corte Dia</th> <th>Num Dia</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso Dia</th> <th>Costo Dia</th> <th>Diamante4</th> <th>Corte Dia</th> <th>Num Dia</th> <th>Carats</th> <th>Color</th> <th>Claridad</th> <th>Medida</th> <th>Peso Dia</th> <th>Costo Dia</th> <th>Metal 1</th> <th>m1pcs</th> <th>m1qty</th> <th>m1costo</th> <th>Metal 2</th> <th>m2pcs</th> <th>m2qty</th> <th>m2costo</th> </tr> <?php $db = dbase_open('inventry.dbf', 0); if ($db) { $numero_registros = dbase_numrecords($db); for ($i=$numero_registros;$i>($numero_registros - 10);$i--) { $row = dbase_get_record_with_names($db, $i); if ($row['deleted'] == "deleted" and $row['INVOICE'] == $numfactura){ $ITEMNO = trim ($row['ITEMNO']); $ITEMCODE = trim ($row['ITEMCODE']); $FACTURAPROVEEDOR = trim ($row['INVOICE']); $UBICACION = trim ($row['LOCATION']); $QTY_INSTCK = trim ($row['QTY_INSTCK']); $PCS_INSTCK = trim ($row['PCS_INSTCK']); $PRECIOCOMPRA = trim ($row['PURCHPRICE']); $FACTOR = trim ($row['MARKUP']); $PRECIOVENTA = trim ($row['SALESPRICE']); $PROVEEDOR1 = trim ($row['VENDOR1']); $PROVEEDOR2 = trim ($row['VENDOR2']); $BTAG_1= trim ($row['BTAG_1']); $BTAG_2= trim ($row['BTAG_2']); $BTAG_3= trim ($row['BTAG_3']); $BTAG_4= trim ($row['BTAG_4']); $BTAG_5= trim ($row['BTAG_5']); $BTAG_6= trim ($row['BTAG_6']); $BTAG_7= trim ($row['BTAG_7']); echo "<tr>"; echo "<td>$ITEMNO</td>"; echo "<td>$ITEMCODE</td>"; echo "<td></td>"; echo "<td>$FACTURAPROVEEDOR</td>"; echo "<td>$UBICACION</td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td>$QTY_INSTCK</td>"; echo "<td>$PCS_INSTCK</td>"; echo "<td>$PRECIOCOMPRA</td>"; echo "<td>$FACTOR</td>"; echo "<td>$PRECIOVENTA</td>"; echo "<td></td>"; echo "<td>$PROVEEDOR1</td>"; echo "<td>$PROVEEDOR2</td>"; echo "<td></td>"; echo "<td>$BTAG_1</td>"; echo "<td>$BTAG_2</td>"; echo "<td>$BTAG_3</td>"; echo "<td>$BTAG_4</td>"; echo "<td>$BTAG_5</td>"; echo "<td>$BTAG_6</td>"; echo "<td>$BTAG_7</td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "</tr>"; } } dbase_close($db); } ?> </table>