FM / reports

/home/techb158/dev.balacoffee.com/resources/src/views/app/pages/reports/

/home/techb158/dev.balacoffee.com/resources/src/views/app/pages/reports

Name	Size	Mode	Actions
payments/	-	0755	rm
customers_report.vue	8008	0644	edit dl rm
detail_Customer_Report.vue	27460	0644	edit dl rm
detail_stock_report.vue	37107	0644	edit dl rm
detail_Supplier_Report.vue	21265	0644	edit dl rm
detail_user_report.vue	45102	0644	edit dl rm
index.vue	46	0644	edit dl rm
profit_and_loss.vue	13189	0644	edit dl rm
providers_report.vue	8003	0644	edit dl rm
purchase_report.vue	14909	0644	edit dl rm
quantity_alerts.vue	4934	0644	edit dl rm
sales_report.vue	14753	0644	edit dl rm
stock_report.vue	5802	0644	edit dl rm
top_customers.vue	4949	0644	edit dl rm
top_selling_products.vue	7866	0644	edit dl rm
users_report.vue	6314	0644	edit dl rm
warehouse_report.vue	39170	0644	edit dl rm

Edit: /home/techb158/dev.balacoffee.com/resources/src/views/app/pages/reports/top_selling_products.vue (7866B)

<template v-slot:input="picker" style="min-width: 350px;">
              {{ picker.startDate.toJSON().slice(0, 10)}} - {{ picker.endDate.toJSON().slice(0, 10)}}
          </template>        
        </date-range-picker>
      </b-col>

<vue-good-table
        v-if="!isLoading"
        mode="remote"
        :columns="columns"
        :totalRows="totalRows"
        :rows="products"
        @on-page-change="onPageChange"
        @on-per-page-change="onPerPageChange"
        :pagination-options="{
        enabled: true,
        mode: 'records',
        nextLabel: 'next',
        prevLabel: 'prev',
      }"
        styleClass="mt-5 table-hover tableOne vgt-table"
      >
      <div slot="table-actions" class="mt-2 mb-3">
        <b-button @click="export_PDF()" size="sm" variant="outline-success ripple m-1">
          <i class="i-File-Copy"></i> PDF
        </b-button>
      </div>
        <template slot="table-row" slot-scope="props">
          <div v-if="props.column.field == 'quantity'">
            <span>{{props.row.quantity}} {{props.row.unit_product}}</span>
          </div>
          <div v-else-if="props.column.field == 'price'">
            <span>{{currentUser.currency}} {{props.row.price}}</span>
          </div>
          <div v-else-if="props.column.field == 'total'">
            <span>{{currentUser.currency}} {{props.row.total}}</span>
          </div>
        </template>
      </vue-good-table>
      
    </div>
</template>

export default {
  metaInfo: {
    title: "Top Selling Products"
  },
  components: { DateRangePicker },
  data() {
    return {
      isLoading: true,
      serverParams: {
        sort: {
          field: "id",
          type: "desc"
        },
        page: 1,
        perPage: 10
      },
      limit: "10",
      totalRows: "",
      products: [],
      today_mode: true,
      startDate: "", 
      endDate: "", 
      dateRange: { 
       startDate: "", 
       endDate: "" 
      }, 
      locale:{ 
          //separator between the two ranges apply
          Label: "Apply", 
          cancelLabel: "Cancel", 
          weekLabel: "W", 
          customRangeLabel: "Custom Range", 
          daysOfWeek: moment.weekdaysMin(), 
          //array of days - see moment documenations for details 
          monthNames: moment.monthsShort(), //array of month names - see moment documenations for details 
          firstDay: 1 //ISO first day of week - see moment documenations for details
        },
    };
  },

computed: {
    ...mapGetters(["currentUser"]),
    columns() {
      return [
        {
          label: this.$t("ProductCode"),
          field: "code",
          tdClass: "text-left",
          thClass: "text-left",
          sortable: false
        },
        {
          label: this.$t("ProductName"),
          field: "name",
          tdClass: "text-left",
          thClass: "text-left",
          sortable: false
        },
        {
          label: this.$t("Price"),
          field: "price",
          tdClass: "text-left",
          thClass: "text-left",
          sortable: false
        },
        {
          label: this.$t("TotalSales"),
          field: "total_sales",
          tdClass: "text-left",
          thClass: "text-left",
          sortable: false
        },

{
          label: this.$t("Quantity"),
          field: "quantity",
          tdClass: "text-left",
          thClass: "text-left",
          sortable: false
        },

{
          label: this.$t("TotalAmount"),
          field: "total",
          tdClass: "text-left",
          thClass: "text-left",
          sortable: false
        }
      ];
    }
  },

methods: {

//----------------------------------- Export PDF ------------------------------\\
    export_PDF() {
      var self = this;
      let pdf = new jsPDF("p", "pt");
      let columns = [
        { title: "Product Code", dataKey: "code" },
        { title: "Product Name", dataKey: "name" },
        { title: "Price", dataKey: "price" },
        { title: "Total Sales", dataKey: "total_sales" },
        { title: "Quantity", dataKey: "quantity" },
        { title: "Total Amount", dataKey: "total" },
      ];
      pdf.autoTable(columns, self.products);
      pdf.text("Top Selling Products", 40, 25);
      pdf.save("Top_Selling_Products.pdf");
    },

//---- update Params Table
    updateParams(newProps) {
      this.serverParams = Object.assign({}, this.serverParams, newProps);
    },

//---- Event Page Change
    onPageChange({ currentPage }) {
      if (this.serverParams.page !== currentPage) {
        this.updateParams({ page: currentPage });
        this.Get_top_products(currentPage);
      }
    },

//---- Event Per Page Change
    onPerPageChange({ currentPerPage }) {
      if (this.limit !== currentPerPage) {
        this.limit = currentPerPage;
        this.updateParams({ page: 1, perPage: currentPerPage });
        this.Get_top_products(1);
      }
    },

//----------------------------- Submit Date Picker -------------------\\
    Submit_filter_dateRange() {
      var self = this;
      self.startDate =  self.dateRange.startDate.toJSON().slice(0, 10);
      self.endDate = self.dateRange.endDate.toJSON().slice(0, 10);
      self.Get_top_products(1);
    },

get_data_loaded() {
      var self = this;
      if (self.today_mode) {
        let today = new Date()

self.startDate = today.getFullYear();
        self.endDate = new Date().toJSON().slice(0, 10);

self.dateRange.startDate = today.getFullYear();
        self.dateRange.endDate = new Date().toJSON().slice(0, 10);
        
      }
    },

//----------------------------- Get_top_products------------------\\
    Get_top_products(page) {
      // Start the progress bar.
      NProgress.start();
      NProgress.set(0.1);
      this.get_data_loaded();

axios
        .get(
          "report/top_products?page=" +
            page +
            "&limit=" +
            this.limit +
            "&to=" +
            this.endDate +
            "&from=" +
            this.startDate
        )
        .then(response => {
          this.products = response.data.products;
          this.totalRows = response.data.totalRows;
          // Complete the animation of theprogress bar.
          NProgress.done();
          this.isLoading = false;
          this.today_mode = false;
        })
        .catch(response => {
          // Complete the animation of theprogress bar.
          NProgress.done();
          setTimeout(() => {
            this.isLoading = false;
            this.today_mode = false;
          }, 500);
        });
    }
  }, //end Methods

//----------------------------- Created function------------------- \\

created: function() {
    this.Get_top_products(1);
  }
};
</script>

cmd: