<template>
  <div class="main-content">
    <breadcumb :page="$t('PurchaseInvoice')" :folder="$t('Reports')" />

    <div v-if="isLoading" class="loading_page spinner spinner-primary mr-3"></div>

    <b-col md="12" class="text-center" v-if="!isLoading">
      <date-range-picker v-model="dateRange" :startDate="startDate" :endDate="endDate" @update="Submit_filter_dateRange"
        :locale-data="locale">

        <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>

    <b-card class="wrapper" v-if="!isLoading">
      <vue-good-table mode="remote" :columns="columns" :totalRows="totalRows" :rows="rows" :group-options="{
        enabled: true,
        headerPosition: 'bottom',
      }" @on-page-change="onPageChange" @on-per-page-change="onPerPageChange" @on-sort-change="onSortChange"
        @on-search="onSearch" :search-options="{
          placeholder: $t('Search_this_table'),
          enabled: true,
        }" :pagination-options="{
          enabled: true,
          mode: 'records',
          nextLabel: 'next',
          prevLabel: 'prev',
        }" styleClass="table-hover tableOne vgt-table">
        <div slot="table-actions" class="mt-2 mb-3">
          <b-button variant="outline-info ripple m-1" size="sm" v-b-toggle.sidebar-right>
            <i class="i-Filter-2"></i>
            {{ $t("Filter") }}
          </b-button>
          <b-button @click="Payment_PDF()" size="sm" variant="outline-success ripple m-1">
            <i class="i-File-Copy"></i> PDF
          </b-button>
          <vue-excel-xlsx class="btn btn-sm btn-outline-danger ripple m-1" :data="payments" :columns="columns"
            :file-name="'payments'" :file-type="'xlsx'" :sheet-name="'payments'">
            <i class="i-File-Excel"></i> EXCEL
          </vue-excel-xlsx>
        </div>
        <template slot="table-row" slot-scope="props">
          <div v-if="props.column.field == 'provider_name'">
            <router-link :to="'/app/reports/detail_supplier/' + props.row.provider_id">
              <span class="ul-btn__text ml-1">{{ props.row.provider_name }}</span>
            </router-link>
          </div>
          <div v-else-if="props.column.field == 'Ref_Purchase'">
            <router-link :to="'/app/purchases/detail/' + props.row.purchase_id">
              <span class="ul-btn__text ml-1">{{ props.row.Ref_Purchase }}</span>
            </router-link>
          </div>
          <div v-else-if="props.column.field == 'Reglement'">
            <span class="ul-btn__text ml-1">{{ $t(props.row.Reglement) }}</span>
          </div>
        </template>
      </vue-good-table>
    </b-card>

    <!-- Sidebar Filter -->
    <b-sidebar id="sidebar-right" :title="$t('Filter')" bg-variant="white" right shadow>
      <div class="px-3 py-2">
        <b-row>

          <!-- Reference -->
          <b-col md="12">
            <b-form-group :label="$t('Reference')">
              <b-form-input label="Reference" :placeholder="$t('Reference')" v-model="Filter_Ref"></b-form-input>
            </b-form-group>
          </b-col>

          <!--  N° Attachment -->
          <b-col md="12">
            <b-form-group :label="$t('n_attachment')">
              <b-form-input label="n_attachment" :placeholder="$t('n_attachment')"
                v-model="Filter_Attachment"></b-form-input>
            </b-form-group>
          </b-col>

          <!-- Societe  -->
          <b-col md="12">
            <b-form-group :label="$t('Societe')">
              <v-select :reduce="label => label.value" :placeholder="$t('Choose_Societe')" v-model="Filter_societe"
                :options="societes.map(societes => ({ label: societes.name, value: societes.id }))" />
            </b-form-group>
          </b-col>

          <!-- Supplier  -->
          <b-col md="12">
            <b-form-group :label="$t('Supplier')">
              <v-select :reduce="label => label.value" :placeholder="$t('Choose_Supplier')" v-model="Filter_Supplier"
                :options="suppliers.map(suppliers => ({ label: suppliers.name, value: suppliers.id }))" />
            </b-form-group>
          </b-col>

          <!-- Purchase  -->
          <b-col md="12">
            <b-form-group :label="$t('Purchase')">
              <v-select :reduce="label => label.value" :placeholder="$t('PleaseSelect')" v-model="Filter_purchase"
                :options="purchases.map(purchases => ({ label: purchases.Ref, value: purchases.id }))" />
            </b-form-group>
          </b-col>

          <!-- Payment choice -->
          <b-col md="12">
            <b-form-group :label="$t('Paymentchoice')">
              <v-select v-model="Filter_Reg" :reduce="label => label.value" :placeholder="$t('PleaseSelect')" :options="[
                { label: $t('Cash'), value: 'Cash' },
                { label: $t('credit card'), value: 'credit card' },
                { label: $t('tpe'), value: 'tpe' },
                { label: $t('cheque'), value: 'cheque' },
                { label: $t('Western Union'), value: 'Western Union' },
                { label: $t('bank transfer'), value: 'bank transfer' },
                { label: $t('LCN'), value: 'LCN' },
                { label: $t('other'), value: 'other' },
              ]"></v-select>
            </b-form-group>
          </b-col>

          <b-col md="6" sm="12">
            <b-button @click="Payments_Purchases(serverParams.page)" variant="primary ripple m-1" size="sm" block>
              <i class="i-Filter-2"></i>
              {{ $t("Filter") }}
            </b-button>
          </b-col>
          <b-col md="6" sm="12">
            <b-button @click="Reset_Filter()" variant="danger ripple m-1" size="sm" block>
              <i class="i-Power-2"></i>
              {{ $t("Reset") }}
            </b-button>
          </b-col>
        </b-row>
      </div>
    </b-sidebar>
  </div>
</template>

<script>
import NProgress from "nprogress";
import jsPDF from "jspdf";
import "jspdf-autotable";
import DateRangePicker from 'vue2-daterange-picker'
//you need to import the CSS manually
import 'vue2-daterange-picker/dist/vue2-daterange-picker.css'
import moment from 'moment'

export default {
  metaInfo: {
    title: "Payment Purchases"
  },
  components: { DateRangePicker },
  data() {
    return {
      isLoading: true,
      serverParams: {
        sort: {
          field: "id",
          type: "desc"
        },
        page: 1,
        perPage: 10
      },
      limit: "10",
      search: "",
      totalRows: "",
      Filter_Supplier: "",
      Filter_societe: "",
      Filter_Ref: "",
      Filter_purchase: "",
      Filter_Reg: "",
      Filter_Attachment: "",
      payments: [],
      suppliers: [],
      societes: [],
      rows: [{
        Reglement: 'Total',

        children: [

        ],
      },],
      purchases: [],
      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: {
    columns() {
      return [
        {
          label: this.$t("date"),
          field: "date",
          tdClass: "text-left",
          thClass: "text-left"
        },
        {
          label: this.$t("Société"),
          field: "societe_name",
          tdClass: "text-left",
          thClass: "text-left"
        },
        {
          label: this.$t("Reference"),
          field: "Ref",
          tdClass: "text-left",
          thClass: "text-left"
        },
        {
          label: this.$t("Purchase"),
          field: "Ref_Purchase",
          tdClass: "text-left",
          thClass: "text-left"
        },
        {
          label: this.$t("Supplier"),
          field: "provider_name",
          tdClass: "text-left",
          thClass: "text-left"
        },
        {
          label: this.$t("ModePaiement"),
          field: "Reglement",
          tdClass: "text-left",
          thClass: "text-left"
        },
        {
          label: this.$t("n_attachment"),
          field: "n_attachment",
          tdClass: "text-left",
          thClass: "text-left"
        },
        {
          label: this.$t("Amount"),
          field: "montant",
          type: "decimal",
          headerField: this.sumCount,
          tdClass: "text-left",
          thClass: "text-left"
        }
      ];
    }
  },

  methods: {

    sumCount(rowObj) {

      let sum = 0;
      for (let i = 0; i < rowObj.children.length; i++) {
        sum += rowObj.children[i].montant;
      }
      return sum;
    },

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

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

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

    //---- Event on Sort Change

    onSortChange(params) {
      let field = "";
      if (params[0].field == "Ref_Purchase") {
        field = "purchase_id";
      } else {
        field = params[0].field;
      }
      this.updateParams({
        sort: {
          type: params[0].type,
          field: field
        }
      });
      this.Payments_Purchases(this.serverParams.page);
    },

    //---- Event Search

    onSearch(value) {
      this.search = value.searchTerm;
      this.Payments_Purchases(this.serverParams.page);
    },

    //------ Reset Filter
    Reset_Filter() {
      this.search = "";
      this.Filter_Supplier = "";
      this.Filter_societe = "";
      this.Filter_Ref = "";
      this.Filter_purchase = "";
      this.Filter_Reg = "";
      this.Filter_Attachment = "";
      this.Payments_Purchases(this.serverParams.page);
    },

    //---------------------------------------- Set To Strings-------------------------\\
    setToStrings() {
      // Simply replaces null values with strings=''
      if (this.Filter_Supplier === null) {
        this.Filter_Supplier = "";
      } else if (this.Filter_societe === null) {
        this.Filter_societe = "";
      } else if (this.Filter_purchase === null) {
        this.Filter_purchase = "";
      } else if (this.Filter_Attachment === null) {
        this.Filter_Attachment = "";
      }
    },

    //-------------------------------- Payments Purchases PDF ---------------------\\
    Payment_PDF() {
      var self = this;

      let pdf = new jsPDF("p", "pt");
      let columns = [
        { title: "Date", dataKey: "date" },
        { title: "Ref", dataKey: "Ref" },
        { title: "Purchase", dataKey: "Ref_Purchase" },
        { title: "Supplier", dataKey: "provider_name" },
        { title: "Paid by", dataKey: "Reglement" },
        { title: "Amount", dataKey: "montant" }
      ];
      pdf.autoTable(columns, self.payments);
      pdf.text("Payments Purchases List", 40, 25);
      pdf.save("Payments_Purchases_List.pdf");
    },

    //----------------------------- 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.Payments_Purchases(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 All Payments Purchases ---------------------\\
    Payments_Purchases(page) {
      // Start the progress bar.
      NProgress.start();
      NProgress.set(0.1);
      this.setToStrings();
      this.get_data_loaded();
      // alert(this.Filter_Reg);

      axios
        .get(
          "payment_purchase?page=" +
          page +
          "&Ref=" +
          this.Filter_Ref +
          "&societe_id=" +
          this.Filter_societe +
          "&provider_id=" +
          this.Filter_Supplier +
          "&purchase_id=" +
          this.Filter_purchase +
          "&Reglement=" +
          this.Filter_Reg +
          "&attachment=" +
          this.Filter_Attachment +
          "&SortField=" +
          this.serverParams.sort.field +
          "&SortType=" +
          this.serverParams.sort.type +
          "&search=" +
          this.search +
          "&limit=" +
          this.limit +
          "&to=" +
          this.endDate +
          "&from=" +
          this.startDate
        )

        .then(response => {
          console.log(response.data);
          this.payments = response.data.payments;
          this.societes = response.data.societes;
          this.suppliers = response.data.suppliers;
          this.purchases = response.data.purchases;
          this.totalRows = response.data.totalRows;
          this.rows[0].children = this.payments;
          // 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);
        });
    }
  },
  //----------------------------- Created function-------------------
  created: function () {
    this.Payments_Purchases(1);
  }
};
</script>