Ejemplo n.º 1
0
         $rs->moveNext();
     }
     $smarty->assign("clientes", $datos);
     $rs = $db->Execute("select * from otrastecnicas a join item b using(idItem)");
     while (!$rs->EOF) {
         $smarty->assign(strtr(strtolower($rs->fields['nombre']), 'àáâãäçèéêëìíîïñòóôõöùúûüýÿÀÁÂÃÄÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝ', 'aaaaaceeeeiiiinooooouuuuyyAAAAACEEEEIIIINOOOOOUUUUY'), $rs->fields['idItem']);
         $rs->moveNext();
     }
     break;
 case 'cotizador_tallas':
     $db = TBase::conectaDB();
     $rs = $db->Execute("select * from talla where idItem = " . $_GET['id']);
     $datos = array();
     while (!$rs->EOF) {
         $obj = new TTalla($rs->fields['idTalla']);
         $rs->fields['neto'] = $obj->getNeto();
         array_push($datos, $rs->fields);
         $rs->moveNext();
     }
     $smarty->assign("tallas", $datos);
     break;
 case 'listaCotizaciones':
     $db = TBase::conectaDB();
     $rs = $db->Execute("select * from cotizacion a join cliente b using(idCliente)");
     $datos = array();
     while (!$rs->EOF) {
         $rs->fields['comentarios'] = '';
         array_push($datos, $rs->fields);
         $rs->moveNext();
     }
     $smarty->assign("cotizaciones", $datos);