Extract objects in Ionic

Question

Extract objects in Ionic

Navigation

#1 by (3 votes)

1

I'm trying to get the selected data from a Checkbox on Ionic.

My View is like this with CheckBox :

<ion-view view-title="Comprar Bebidas Adicionais" hide-nav-bar="false">

    <div class="bar bar-subheader">
        <h2 class="title">{{'Sub-Total R$ ' + getTotalSelected() }}</h2>
    </div>

    <ion-content delegate-handle="top" lazy-scroll id="lista-bebidas" class="has-header lista-bebidass" ng-controller="exBebidasCtrl">

        <ion-refresher pulling-text="Puxe para atualizar..." on-refresh="doRefresh()"></ion-refresher>
        <ion-list class="card list">
            <div class="item item-input">
                <i class="icon ion-search placeholder-icon"></i>
                <input type="search" ng-model="q" placeholder="Procurar" aria-label="filter bebidasextras" />
            </div>
        </ion-list>

        <ion-list>

            <div ng-repeat="bebida in bebidasextras">
                <ion-checkbox ng-model="bebida.selected" ng-checked="bebida.selected">
                    <h2>{{bebida.ad_bebida_titulo}}</h2>
                    <p>R$ {{bebida.ad_bebida_valor}}</p>
                </ion-checkbox>
            </div>

        </ion-list>

        <button class="button button-block button-balanced" ng-click="updateBebida()">
                        Continuar Comprando
                    </button> {{ selectedItems | json }}

    </ion-content>

</ion-view>

This JSON is printing on the screen just to see if it really caught.

And my Controller looks like this:

.controller("exBebidasCtrl", function($scope, $rootScope, $state, $ionicScrollDelegate, $http, $httpParamSerializer, $stateParams, $timeout, $ionicLoading, $ionicPopup, $ionicPopover, $ionicSlideBoxDelegate, $ionicHistory, ionicMaterialInk, ionicMaterialMotion, sharedCartService, CartServiceBebidasEx, $location, DBLocal) {

            // VERIFICA SE HÁ BEBIDAS EXTRAS

            $scope.bebidasextras = [];

            var promise = $http.get('http://nhac.esy.es/api_carrinho/lista_bebida_extra.php?json=restaurantes')
                .success(function(retorno) {
                    console.log(retorno);
                    $scope.bebidasextras = retorno; // não precisa fazer retorno.data

                    $scope.user = {
                        bebidasextras: [$scope.bebidasextras[1]]
                    };
                    $scope.checkAll = function() {
                        $scope.user.bebidasextras = angular.copy($scope.bebidasextras);
                    };
                    $scope.uncheckAll = function() {
                        $scope.user.bebidasextras = [];
                    };
                    $scope.checkFirst = function() {
                        $scope.user.bebidasextras = [];
                        $scope.user.bebidasextras.push($scope.bebidasextras[0]);
                    };
                    $scope.setToNull = function() {
                        $scope.user.bebidasextras = null;
                    };



                    // CALCULA TOTAL DOS ITENS SELECIONADOS NA LISTA
                    $scope.sub = function(i) {
                        i.quantity--;
                    }

                    $scope.add = function(i) {
                        i.quantity++;
                    }

                    $scope.getTotalSelected = function() {
                        var total = 0;

                        for (var i = 0; i < $scope.bebidasextras.length; i++) {
                            var bebida = $scope.bebidasextras[i];
                            total += bebida.selected ? Number(bebida.ad_bebida_valor) : 0;
                        }


                        return total;
                    }

                })
                .error(function(erro) {
                    console.log(erro);
                });


            // PEGA BEBIDAS SELECIONADAS      
            $scope.updateBebida = function() {
                var p = [];
                for (var i = 0; i < $scope.bebidasextras.length; i++) {
                    var item = $scope.bebidasextras[i];
                    console.log(item);
                    if (item.selected) {
                        p.push(item)
                    }

                }

                $scope.selectedItems = p;
                console.log(p);

                var titulo = data.filter(function(e) {
                    return e.titulo_promo == p.ad_bebida_titulo
                    conlole.log(titulo);
                })


                // TESTA SE GUARDA A BEBIDA SELECIONADA

                // INSERINDO DADOS LOCALMENTE
                DBLocal.localdb();

                //            var len = $scope.p.ad_bebida_titulo;
                //            console.log(len);

                //          var dados =  p.filter(function(e){
                //              return e.ad_bebida_titulo == bebida.ad_bebida_titulo;
                //          })

                DBLocal.db.transaction(function(res) {
                    res.executeSql("INSERT INTO AD_BEBIDAS (nome_bebida_ad) VALUES(?);", [p.ad_bebida_titulo]);
                });



            }

Note that I want to store the data of the% selected% in a WEBSQL, but I can not get it, see its console:

Idonotknowhowtogetdatafromthisobjecttoplayinmylocaldatabase.Therein:

DBLocal.db.transaction(function(res){res.executeSql("INSERT INTO AD_BEBIDAS (nome_bebida_ad) VALUES(?);",[p.ad_bebida_titulo]);

How can I get this data?

angularjs ionic websql

asked by anonymous 26.08.2016 / 18:33

1 answer

Read the name or type of a remote file opened with "fopen" Relationship of two tables

score 3 · Accepted Answer

Your variable p is an array.

Here in this code snippet

DBLocal.db.transaction(function(res){
          res.executeSql("INSERT INTO AD_BEBIDAS (nome_bebida_ad) VALUES(?);", [p.ad_bebida_titulo]);              
});

You are trying to access the ad_bebida_titulo property of the Array object, as it does not exist you end up getting a undefined .

To get it right it would have to be something like:

// PEGA BEBIDAS SELECIONADAS      
$scope.updateBebida = function() {
    var p = [];
    for (var i = 0; i < $scope.bebidasextras.length; i++) {
        var item = $scope.bebidasextras[i];
        console.log(item);
        if (item.selected) {
            p.push(item)
        }

    }

    $scope.selectedItems = p;
    var item;

    //aqi vai percorrer todo o conteudo da vriavep p, poderia ate dar
    //uma otimaizada e deixar junto com o p.push(item), ai "economiza" um for
    for(var i in p){
        item = p[i];
        console.log(item);
        var titulo = data.filter(function(e) {
            return e.titulo_promo == item.ad_bebida_titulo
            conlole.log(titulo);
        })


        // TESTA SE GUARDA A BEBIDA SELECIONADA

        // INSERINDO DADOS LOCALMENTE
        DBLocal.localdb();

        DBLocal.db.transaction(function(res) {
            res.executeSql("INSERT INTO AD_BEBIDAS (nome_bebida_ad) VALUES(?);", [item.ad_bebida_titulo]);
        });
    }
}