import { Component, Input, OnInit } from '@angular/core';
import { ActivatedRoute, Router } from '@angular/router';
import { DbConnectionService } from '../db-connection.service';
import { LightgalleryModule } from 'lightgallery/angular/13';
import { BeforeSlideDetail } from 'lightgallery/lg-events';

@Component({
  selector: 'app-accomodationdescription',
  templateUrl: './accomodationdescription.component.html',
  styleUrls: ['./accomodationdescription.component.scss']
})
export class AccomodationdescriptionComponent implements OnInit {

  trip: Object = null;
  tripId: number;
  activityId: number;
  mobile: boolean = false;
  tripSummary: Object[] = [];
  accommodationName = "";
  @Input() accommodation: object;
  accommodationPictures: Object[] = [];

  settings = {
    counter: false,
  };
  onBeforeSlide = (detail: BeforeSlideDetail): void => {
    const { index, prevIndex } = detail;
    console.log(index, prevIndex);
  };


  constructor(private route: ActivatedRoute,
    private db: DbConnectionService,
    private router: Router) { }

  ngOnInit(): void {

    if (/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent)) {
      this.mobile = true
    }
    
    this.route.params.subscribe(r => {

      // error handling
      if (!r["tripId"] || isNaN(Number(r["tripId"])))
        return alert("Invalid TripID");
      if (!r["activityId"] || isNaN(Number(r["activityId"])))
        return alert("Invalid activityId");
      // extract tripID and activityID from url
      this.tripId = Number(r["tripId"]);
      this.activityId = Number(r["activityId"]);
      if (!r["accommodation"])
        return alert("Invalid accommodation");
      this.accommodationName = r['accommodation']

    })
    this.fetchAccommodationDetails();
    this.fetchAccommodationPictures()
    // this.fetchDayByDayView();
    
  }

  fetchAccommodationDetails() {
    this.db.executeQuery(`SELECT tripID, name, activityID, nights, tagline, level, pricePerNight, persons, description FROM ActivityAccomodationView WHERE activityID = ${this.activityId} and name="${this.accommodationName}"`).then(r => {
      this.accommodation = r["data"][0];
      // console.log(this.accommodation)
    })
  }

  fetchAccommodationPictures() {
    this.db.executeQuery(`SELECT * FROM AccommodationPicture WHERE accommodation = "${this.accommodationName}"`).then(r => {
      this.accommodationPictures = r["data"]
    })
  }

  fetchDayByDayView() {
    this.db.executeQuery(`SELECT * from DayByDayView WHERE tripID=${this.tripId}`).then(r => {
      this.tripSummary = r["data"];
    })
  }

  async chooseAccommodation(){
      await this.db.executeQuery(`UPDATE MainActivity SET accomodation = '${this.accommodation['name']}' WHERE activityID = ${this.activityId}`)
      // console.log(`UPDATE HistoricPrice set price = (select totalPrice from TotalPriceView where activityID = ${this.activityId})) WHERE mainActivityID = ${this.activityId};`)
      
      // await this.db.executeQuery(`INSERT INTO HistoricPrice (mainActivityID, price) VALUES (${this.activityId}, (select totalPrice from TotalPriceView where activityID = ${this.activityId}));`)
      await this.db.executeQuery(`UPDATE HistoricPrice set price = (select totalPrice from TotalPriceView where activityID = ${this.activityId}) WHERE mainActivityID = ${this.activityId};`)
      console.log(`UPDATE HistoricPrice set price = (select totalPrice from TotalPriceView where activityID = ${this.activityId}) WHERE mainActivityID = ${this.activityId};`)
      // navigate to activities page
      this.router.navigateByUrl(`/trip/${this.tripId}/activities`);
    
  }

}