ec.edu.espe.distribuidas.factnosql.test.consultaTotalVentas.java Source code

Introduction

Here is the source code for ec.edu.espe.distribuidas.factnosql.test.consultaTotalVentas.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package ec.edu.espe.distribuidas.factnosql.test;

import ec.edu.espe.distribuidas.factnosql.modelo.Factura;
import ec.edu.espe.distribuidas.factnosql.modelo.ProductoSum;
import ec.edu.espe.distribuidas.factnosql.modelo.VentasDiarias;
import ec.edu.espe.distribuidas.factnosql.persistencia.PersistenceManager;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Iterator;
import java.util.List;
import org.apache.commons.collections.IteratorUtils;
import org.mongodb.morphia.aggregation.Accumulator;
import org.mongodb.morphia.aggregation.Group;
import org.mongodb.morphia.query.Query;

/**
 *
 * @author RAUL
 */
public class consultaTotalVentas {
    public static void main(String[] args) throws ParseException {
        PersistenceManager persistence = new PersistenceManager();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Query q = persistence.context().createQuery(Factura.class).field("fechaEmision")
                .equal(sdf.parse("2016-01-27"));
        Iterator<VentasDiarias> aggregate = persistence.context().createAggregation(Factura.class)
                .group("fechaEmision", Group.grouping("total", Group.sum("total")),
                        Group.grouping("count", new Accumulator("$sum", 1)),
                        Group.grouping("fechaEmision", Group.first("fechaEmision")))
                .aggregate(VentasDiarias.class);
        List<VentasDiarias> totalVentas = IteratorUtils.toList(aggregate);
        for (VentasDiarias p : totalVentas)
            System.out.println(p);

    }
}