Exemplo n.º 1
0
global $objModulo;
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':