class Business < ApplicationRecord
 belongs_to :user, optional: true
end

class User < ApplicationRecord
 has_many :businesses
end

class Admin::BusinessesController < Admin::BaseController
 include EmailHelper
 after_action :verify_authorized
 def index
 authorize [:admin, Business]
 @datatable = BusinessDatatable.new(params, view_context: view_context)
 respond_to do |format|
 format.html
 format.json { render json: @datatable }
 end
 end
end

class Admin::BusinessPolicy < ApplicationPolicy
 class Scope < Scope
 def index?
 !@user.moderator?
 end
 
 def resolve
 #using includes to businesses with no location are shown
 scope.includes(
 locations: :city
 ).where(
 cities: {
 id: @user.accessible_city_ids
 }
 )
 end
 end
end

class BusinessDatatable < AjaxDatatablesRails::ActiveRecord
 extend Forwardable
 def_delegators :@view, :current_admin, :session
 def initialize(params, opts = {})
 @view = opts[:view_context]
 super
 end
 def view_columns
 @view_columns ||= {
 id: { source: "Business.id", cond: :eq },
 name: { source: "Business::Translation.name", cond: :like },
 cities: { source: "City::Translation.name", cond: :like },
 categories: { source: "Category::Translation.name", cond: :like },
 user: { source: "Business.user", cond: :like, searchable: true, orderable: true },
 updated_at: { source: "Business.updated_at", cond: :like },
 created_at: { source: "Business.created_at", cond: :like },
 disabled: { source: "Business.disabled", cond: :eq },
 approved: { source: "Business.approved", cond: :eq },
 flagged: { source: "Business.flagged", cond: :eq },
 verified: { source: "Business.user", cond: :eq },
 role: { source: "Admin.role", cond: :eq },
 actions: { source: "Business.id", cond: :null_value }
 }
 end
 def data
 records.map do |record|
 {
 id: record.id,
 name: record.name,
 cities: record.cities.map { |city| { id: city.id, name: city.name } }.uniq.to_json.html_safe,
 categories: record.categories.distinct.map { |category| { id: category.id, name: category.name } }.to_json.html_safe,
 user: record.user.present? ? record.user.as_json(only: [:id, :name]).to_json.html_safe : nil,
 updated_at: record.updated_at,
 created_at: record.created_at,
 disabled: record.disabled?,
 approved: record.approved?,
 paid: record.user && record.user.business_subscription_data.has_key?("subscription") ? true : false,
 flagged: record.flagged?,
 verified: record.verified? || false,
 role: @view.current_admin.role,
 actions: "",
 }
 end
 end
 private
 def get_raw_records
 
 # Extract search values
 user_search = params.dig(:columns, "3", :search, :value).to_s
 verified_search = params[:verified].to_s
 
 # Initial query setup
 query = Admin::BusinessPolicy::Scope.new(current_admin, Business).resolve
 
 if verified_search.present?
 if verified_search == "true"
 query = query.where.not(user_id: nil) # Businesses that are verified
 elsif verified_search == "false"
 query = query.where(user_id: nil) # Businesses that are not verified
 end
 end
 # Apply user filter if present
 if user_search.present?
 query = query.includes(:translations, locations: { city: :translations }, categories: :translations)
 .left_joins(:user) # Use left_joins to include records where user may be nil
 .where("users.name ILIKE ?", "%#{user_search}%") # Use ILIKE for case-insensitive matching
 .references(:location, :city, :translation, :category, :user)
 else
 query = query.includes(
 :translations,
 :user,
 locations: { city: :translations },
 categories: :translations
 )
 
 # Filter by country if needed
 query = query.joins(locations: :country).where('countries.id' => session[:admin_country_id]) if session[:admin_country_id]
 
 # Select required fields
 query = query.select('businesses.*, users.name as user_name, city_translations.name as city_name, category_translations.name as category_name')
 end
 
 query
 end
end

$("#js-businesses-table").dataTable({
 serverSide: true,
 bLengthChange: false,
 bInfo: false,
 order: [[5, "desc"]],
 ajax: {
 url: $("#js-businesses-table").data("source"),
 data: function (d) {
 console.log(d);
 d.approved = $("#approved_filter").val();
 d.flagged = $("#flagged_filter").val();
 d.verified = $("#verified_filter").val();
 console.log("Approved:", $("#approved_filter").val());
 console.log("Flagged:", $("#flagged_filter").val());
 console.log("Verified:", $("#verified_filter").val());
 },
 },
 fnRowCallback: function (nRow, aData, iDisplayIndex) {
 $(nRow).removeClass("unapproved paid");
 if (!aData.approved) {
 $(nRow).addClass("unapproved");
 }
 if (aData.paid) {
 $(nRow).addClass("paid");
 }
 },
 columns: [
 {
 data: "name",
 render: function (data, type, row, meta) {
 return (
 '<a href="/admin/businesses/' + row.id + '/edit">' + data + "</a>"
 );
 },
 },
 {
 data: "cities",
 render: function (data, type, row, meta) {
 let newData = JSON.parse(data);
 let cities = newData
 .map(function (city, i) {
 return (
 '<a href="/admin/cities/' +
 city.id +
 '/edit">' +
 city.name +
 "</a>" +
 (i != newData.length - 1 ? ", " : "")
 );
 })
 .join("");
 return cities;
 },
 defaultContent: "-",
 },
 {
 data: "categories",
 render: function (data, type, row, meta) {
 let newData = JSON.parse(data);
 categories = [];
 $(newData).map(function (i) {
 categories +=
 '<a href="/admin/categories/' +
 newData[i].id +
 '/edit">' +
 newData[i].name +
 "</a>" +
 (i != newData.length - 1 ? ", " : "") +
 "";
 });
 return categories;
 },
 },
 {
 data: "user",
 render: function (data, type, row, meta) {
 if (!data) {
 return "no vendor";
 }
 if (typeof data === "string") {
 try {
 data = JSON.parse(data);
 } catch (e) {
 console.error("Error parsing JSON:", e);
 return "no vendor";
 }
 }
 if (data && data.id && data.name) {
 return (
 '<a href="/admin/users/' + data.id + '/edit">' + data.name + "</a>"
 );
 } else {
 return "no vendor";
 }
 },
 sortable: true,
 orderable: true,
 },
 {
 data: "created_at",
 render: function (data, type, row, meta) {
 return moment(data).format("DD/MM/YY");
 },
 },
 {
 data: "updated_at",
 render: function (data, type, row, meta) {
 return moment(data).format("DD/MM/YY");
 },
 },
 {
 data: "actions",
 sortable: false,
 render: function (data, type, row, meta) {
 return (
 '<a class="tooltip" title="Edit" href="/admin/businesses/' +
 row.id +
 '/edit"><%= image_tag("icons/pencil.svg", class: "icon icon--dark icon--small") %></a> ' +
 (data.role === "superadmin"
 ? '<a class="tooltip" title="Delete" rel="nofollow" data-method="delete" href="/admin/businesses/' +
 row.id +
 '" data-confirm="Are you sure?"><%= image_tag("icons/trash.svg", class: "icon icon--dark icon--small") %></a> '
 : "") +
 '<a class="tooltip" title="Public profile" target="_blank" href="/businesses/' +
 row.id +
 '"><%= image_tag("icons/eye.svg", class: "icon icon--dark icon--small") %></a> ' +
 (row.disabled
 ? '<a class="tooltip" title="Enable" data-method="put" href="/admin/businesses/' +
 row.id +
 '/enable"><%= image_tag("icons/verified.svg", class: "icon icon--dark icon--small") %></a>'
 : '<a class="tooltip" title="Disable" data-method="put" href="/admin/businesses/' +
 row.id +
 '/disable"><%= image_tag("icons/close-small.svg", class: "icon icon--dark icon--small") %></a>')
 );
 },
 },
 {
 data: "disabled",
 visible: false,
 },
 {
 data: "approved",
 visible: false,
 sortable: true,
 },
 {
 data: "flagged",
 visible: false,
 },
 {
 data: "verified",
 visible: false,
 },
 ],
 dom: "ritp",
 pageLength: 30,
 initComplete: function () {
 var table = this;
 // Select filters
 $(".js-select-filter").each(function () {
 var $filterSelect = $(this);
 var columnIndex = +$filterSelect.data("column");
 var column = table.api().column(columnIndex);
 // Filter the column when the user picks an option
 $filterSelect.on("change", function () {
 var val = $filterSelect.val();
 if (val === "true" || val === "false") {
 val = val === "true";
 }
 column.search(val ? val : "", false, false).draw();
 });
 // Add all possible options to the select
 $filterSelect.append(
 '<option value="">' + column.header().innerHTML + "</option>"
 );
 var entries = column
 .data()
 .unique()
 .sort()
 .map(function (d, j) {
 if (typeof d === "string") {
 try {
 return JSON.parse(d);
 } catch (e) {
 return [];
 }
 } else {
 return d || [];
 }
 });
 entries = _.uniqBy(_.flattenDeep(entries), "id").filter(function (value) {
 return value && value.id !== undefined;
 });
 entries.forEach(function (entry) {
 if (entry.name === true || entry.name === false) {
 entry.name = entry.name === true ? "Yes" : "No";
 }
 $filterSelect.append(
 '<option value="' + entry.name + '">' + entry.name + "</option>"
 );
 });
 // Add options for boolean columns
 if (columnIndex === 8 || columnIndex === 9 || columnIndex === 10) {
 $filterSelect.append('<option value="true">True</option>');
 $filterSelect.append('<option value="false">False</option>');
 }
 });
 // Text filters
 $(".js-text-filter").each(function () {
 var $filterInput = $(this);
 var columnIndex = +$filterInput.data("column");
 var column = table.api().column(columnIndex);
 $filterInput.on("keyup change", function () {
 if (column.search() !== this.value) {
 column.search(this.value).draw();
 }
 });
 });
 },
});
$("#js-businesses-table").on("draw.dt", function () {
 $(".tooltip").tooltipster({
 delay: 0,
 animationDuration: 100,
 });
});