/*DataServer.js*/
Meteor.publishComposite('data', function(doc, sort) {
    doc.appId = App.id;
    console.log("subscribing some Data with it's relation in App Id = " + App.id);
    return{
        find: function() {
            return Data.find(doc, sort);
        },
        children: [
            /* return all related Users */
            {
                find: function(collection) {
                    return Meteor.users.find({
                        $or: [
                            {_id: collection.createdUserId},
                            {_id: collection.updatedUserId},
                        ]
                    });
                }
            },
        ],
    }
});


Meteor.methods({
    "Data.insert": function(doc) {
        var _id = Data.insert(doc);
        return {
            _id: _id,
        }
    },
    "Data.getSumTersus": function(){
      return Data.find({tersus_tuks:"TERSUS"}).count();
    }
});

/* observing collection */
/* uncomment to use
var query = Data.find({});
var handle = query.observe({
    removed: function(model) {
        //removing related image, when post removed
        Images.remove(model.imageId);
    }
});
*/


/*BidangController.js*/
BidangController = MeteorisController.extend({
  /* get subscribtion from server with parameter criteria, and sort/limit */
  subscriptions: function() {
    this.subscription = this.subs.subscribe('data', this.getCriteria());
  },
  /* passing data from controllers to view */
  data: function() {
    return {
    };
  },
  getSumTersusAll: function(){
    Meteor.call("Data.getSumTersus", function(err, result){
      if(err){
        MeteorisFlash.set('danger', err);
        throw new Meteor.Error(err);
      }
      //harus pake session untuk get return valuenya
      Session.set('Data.getSumTersus', result);
    });
    return Session.get('Data.getSumTersus');
  },
  getSumTuksAll: function(){
    return Data.find({tersus_tuks:"TUKS"}).count();
  },
  getTuksByProvinsi: function(){
    var sKategori = this.getCategory();
    var tuks = Data.find({kategori_usaha:sKategori, tersus_tuks:"TUKS"}).fetch();
    return tuks;
  },
  getSumTuks:function(){
    var sKategori = this.getCategory();
    var total = Data.find({kategori_usaha:sKategori, tersus_tuks:"TUKS"}).count();
    return total;
  },
  getTuks:function(){
    var data = [];
    var sKategori = this.getCategory();
    var _i = 1;
    Data.find({kategori_usaha:sKategori, tersus_tuks:"TUKS"}).forEach(function(p) {
      p.position = _i;
      _i++;
      data.push(p);
    });
    return data;
  },
  getTersusByProvinsi: function(){
    var sKategori = this.getCategory();
    var tersus = Data.find({kategori_usaha:sKategori, tersus_tuks:"TERSUS"}).fetch();
    return tersus;
  },
  getSumTersus:function(){
    var sKategori = this.getCategory();
    var total = Data.find({kategori_usaha:sKategori, tersus_tuks:"TERSUS"}).count();
    return total;
  },
  getTersus:function(){
    var data = [];
    var sKategori = this.getCategory();
    var _i = 1;
    Data.find({kategori_usaha:sKategori, tersus_tuks:"TERSUS"}).forEach(function(p) {
      p.position = _i;
      _i++;
      data.push(p);
    });
    return data;
  },
  getCategory: function(){
    var search = this.params.query.q ? this.params.query.q : "";
    var kategori = [];
    kategori["mineral"] = "MINERAL";
    kategori["batubara"] = "BATUBARA";
    kategori["migas"] = "MIGAS";
    kategori["pltu"] = "PLTU";
    kategori["kehutanan"] = "KEHUTANAN";
    kategori["cpo"] = "CPO";
    kategori["perkebunan"] = "PERKEBUNAN";
    kategori["kehutanan"] = "KEHUTANAN";
    kategori["perikanan"] = "PERIKANAN";
    kategori["industri"] = "INDUSTRI";
    kategori["pariwisata"] = "PARIWISATA";
    kategori["gkapal"] = "GALANGAN KAPAL";
    kategori["lainnya"] = "LAINNYA";
    if(typeof kategori[search] === 'undefined') {
      MeteorisFlash.set('danger', 'Kategori Bidang Usaha Tidak Cocok Dengan Database');
      Router.go('/');
    }
    else {
      var sKategori = kategori[search];
      return sKategori;
    }
  },
  /* @override getCriteria */
  getCriteria: function() {
    var sKategori = this.getCategory();
    return {
      $or: [{kategori_usaha: sKategori},]
    };
  }

});