<?php
include "local.php";
$sf = new scaffold("pedidos_paso");
$sf->setCondition("idpedido", $r->pedido_id);
$sf->__query = "SELECT * FROM pedidos_paso where idpedido=" . $r->pedido_id . " ORDER BY id ASC";
header("content-type:text/xml");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
echo "<puertas_paso>";
foreach ($sf->getList() as $puerta) {
$madera = new scaffold("maderas");
$modelo = new scaffold("modelos");
$madera->open($puerta["idmadera"]);
$modelo->open($puerta["idmodelo"]);
echo "\n<puerta_paso\nid=\"" . $puerta["id"] . "\" \nunidades=\"" . $puerta["unidades"] . "\"\nmadera=\"" . $madera->referencia . "\"\nmodelo=\"" . $modelo->referencia . "\"\npuerta_largo=\"" . $puerta["puerta_largo"] . "\"\npuerta_ancho=\"" . $puerta["puerta_ancho"] . "\"\npuerta_grueso=\"" . $puerta["puerta_grueso"] . "\"\nregrueso_dm=\"" . $puerta["regrueso_dm"] . "\"\nregrueso_macizo=\"" . $puerta["regrueso_macizo"] . "\"\nregrueso_medidas=\"" . $puerta["regrueso_medidas"] . "\"\njamba_dm=\"" . $puerta["jamba_dm"] . "\"\njamba_macizo=\"" . $puerta["jamba_macizo"] . "\"\njamba_medidas=\"" . $puerta["jamba_medidas"] . "\"\nmano_izq=\"" . $puerta["mano_izq"] . "\"\nmano_dch=\"" . $puerta["mano_dch"] . "\"\ncondena=\"" . $puerta["condena"] . "\"\nmaterial_inox=\"" . $puerta["material_inox"] . "\"\nmaterial_laton=\"" . $puerta["material_laton"] . "\"\n/>";
}
echo "</puertas_paso>";
<?php
include "local.php";
$sf = new scaffold("pedidos_ventanas");
$sf->setCondition("idpedido", $r->pedido_id);
$sf->__query = "SELECT * FROM pedidos_ventanas where idpedido=" . $r->pedido_id . " ORDER BY id ASC";
header("content-type:text/xml");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>";
echo "<ventanas>";
foreach ($sf->getList() as $ventana) {
$madera = new scaffold("maderas");
$modelo = new scaffold("modelos");
$madera->open($ventana["idmadera"]);
$modelo->open($ventana["idmodelo"]);
echo "\n<ventana\nid=\"" . $ventana["id"] . "\" \nunidades=\"" . $ventana["unidades"] . "\"\nmadera=\"" . $madera->referencia . "\"\nmodelo=\"" . $modelo->referencia . "\"\nhojas=\"" . $ventana["hojas"] . "\"\nventana_largo=\"" . $ventana["ventana_largo"] . "\"\nventana_ancho=\"" . $ventana["ventana_ancho"] . "\"\nventana_grueso=\"" . $ventana["ventana_grueso"] . "\"\njamba_dm=\"" . $ventana["jamba_dm"] . "\"\njamba_macizo=\"" . $ventana["jamba_macizo"] . "\"\njamba_medidas=\"" . $ventana["jamba_medidas"] . "\"\noscilante=\"" . $ventana["oscilante"] . "\"\nbatiente=\"" . $ventana["batiente"] . "\"\ncristal=\"" . $ventana["cristal"] . "\"\ncristal_mate=\"" . $ventana["cristal_mate"] . "\"\ncristal_carglass=\"" . $ventana["cristal_carglass"] . "\"\ncristal_grueso=\"" . $ventana["cristal_grueso"] . "\"\nmaterial_inox=\"" . $ventana["material_inox"] . "\"\nmaterial_laton=\"" . $ventana["material_laton"] . "\"\n/>";
}
echo "</ventanas>";
<?php
include "local.php";
$sf = new scaffold("pedidos");
$sf->setCondition("tracking", "AW/" . $r->prefix . "/" . strtoupper($r->suffix));
$list = $sf->getList();
if ($list[0]["id"] == "") {
header("location:tracking.php?error=1&prefix=" . $r->prefix . "&suffix=" . $r->suffix);
die;
}
$p = new aworkstrackpage();
$sf->open($list[0]["id"]);
$ew = new estadolistwidget();
$ew->drop($sf);
$d_pedido = new date();
$d_pedido->timestamp = $sf->fecha_pedido;
$d_pedido->parse();
$d_entrega_estimada = new date();
$d_entrega_estimada->timestamp = $sf->fecha_entrega_prevista;
$d_entrega_estimada->parse();
$d_entrega = new date();
$d_entrega->timestamp = $sf->fecha_entrega;
$d_entrega->parse();
$out .= "\n<br /><br /><center><div style=\"background:rgb(239,237,222);width:640px;padding:12px;border:outset 2px;\">\n<center><br />\n<h2>Pedido " . $sf->tracking . "</h2>\n<table style=\"width:560px;\"><tr><td style=\"width:220px;\">Pedido</td><td> <b>" . $sf->tracking;
$out .= "</td></tr><tr><td> Cliente </td><td><b>" . $sf->cliente;
$out .= "</td></tr><tr><td> Referencia Cliente </td><td> <b>" . $sf->referencia;
$out .= "</td></tr><tr><td> Estado </td><td>" . $ew->draw();
$out .= "</td></tr><tr><td> Fecha Pedido</td><td>" . $d_pedido->string;
$out .= "</td></tr><tr><td> Fecha Entrega Estimada</td><td>" . $d_entrega_estimada->string;
$out .= "</td></tr><tr><td> Fecha Entrega</td><td>" . $d_entrega->string;
$out .= "</table>\n\n";
<?php
include "local.php";
header("content-type: text/xml");
echo "<?xml version=\"1.0\"?>";
echo "\n<results>";
$r = new request();
$sf = new scaffold($r->entity);
$sf->setCondition($r->condition_entity, $r->condition_value);
foreach ($sf->getList() as $item) {
echo "\n\t<result id=\"" . $item["id"] . "\" name=\"" . $item["referencia"] . "\" />";
}
echo "\n</results>";
function draw()
{
$o = $this->popMailBox();
$id = $o->id;
$es = new estadowidget();
$es->drop($o);
$out .= $es->draw();
$sf = new scaffold("pedidos_eventos");
$sf->__query = "SELECT * FROM pedidos_eventos WHERE idpedido=" . $id . " ORDER BY fecha DESC";
$out .= "<div style=\"overflow:auto;border:inset 1px;background:white;height:250px;\">";
$out .= "<table style=\"font-size:12px;\" class=\"eventos\"><thead><td>Fecha</td><td>Estado Antiguo</td><td>Estado Nuevo</td><td>Fecha Prevista</td><td>Descripción</td></thead>";
foreach ($sf->getList() as $evento) {
$d = new date();
$d->timestamp = $evento["fecha"];
$d->parse();
$d2 = new date();
$d2->timestamp = $evento["fecha_entrega_prevista"];
$d2->parse();
$ewa = new estadolistwidget();
$ewn = new estadolistwidget();
$o = new oobject();
$o->estado = $evento["estado_viejo"];
$ewa->drop($o);
$o = new oobject();
$o->estado = $evento["estado_nuevo"];
$ewn->drop($o);
$out .= "<tr><td style=\"width:110px\">" . $d->string . "</td><td style=\"width:158px;\">" . $ewa->draw() . "</td><td style=\"width:158px;\">" . $ewn->draw() . "</td><td style=\"width:110px;\">" . $d2->short_string . "</td><td style=\"font-size:9px;\">" . $evento["descripcion"] . "</td></tr>";
}
$out .= "</table>";
$out .= "</div>";
return $out;
}
