switch ($objModulo->getId()) { case 'listaTecnicas': $db = TBase::conectaDB(); $rs = $db->Execute("select * from otrastecnicas a join item b using(idItem)"); $datos = array(); while (!$rs->EOF) { $rs->fields['json'] = json_encode($rs->fields); array_push($datos, $rs->fields); $rs->moveNext(); } $smarty->assign("lista", $datos); break; case 'tecnicasPrecios': $obj = new TTecnicas($_GET['id']); $smarty->assign("nombre", $obj->getNombre()); $smarty->assign("id", $obj->getId()); $db = TBase::conectaDB(); $rs = $db->Execute("select * from limite where idTipoItem = 7"); $datos = array(); while (!$rs->EOF) { $aux = $db->Execute("select precio from preciootrastecnicas where idLimite = " . $rs->fields['idLimite'] . " and idItem = " . $obj->getId()); $rs->fields['precio'] = $aux->fields['precio'] == '' ? 0 : $aux->fields['precio']; array_push($datos, $rs->fields); $rs->moveNext(); } $smarty->assign("limites", $datos); break; case 'cTecnicas': switch ($objModulo->getAction()) { case 'add': $db = TBase::conectaDB();