package main

import "github.com/mansoldof/plyGO"

type Person struct {
    Name   string
    Age    int
    City   string
    Salary float64
}

func main() {

    people := []Person{
        {"Frank", 43, "FL", 88000},
        {"Alice", 30, "NYC", 75000},
        {"Bob", 25, "LA", 60000},
        {"Charlie", 35, "NYC", 90000},
    }

    // Display with elegant formatting
    plygo.From(people).Show()

    // Filter and show
    plygo.From(people).
        Where("Age").GreaterThan(30).
        Show(plygo.WithTitle("Age > 30"))

}

    // Display with elegant formatting
    plygo.From(people).Show(plygo.WithStyle("rounded"))

    // Filter and show
    plygo.From(people).
        Where("Salary").LessThan(80000).
        Show(plygo.WithTitle("Salary < $80,000"),
            plygo.WithStyle("rounded"))

package main

import (
    "github.com/mansoldof/plyGO"
    "github.com/mansoldof/goTableView"
)

type Person struct {
    Name   string
    Age    int
    City   string
    Salary float64
}

func main() {
    people := []Person{
        {"Frank", 43, "FL", 88000},
        {"Alice", 30, "NYC", 75000},
        {"Bob", 25, "LA", 60000},
        {"Charlie", 35, "NYC", 90000},
    }

	// Display initial table
	gotableview.FromStructs("Initial table", people).Show(false)

    // Filter, sort, and display in GUI
    result := plygo.From(people).
        Where("Age").GreaterThan(30).
        OrderBy("Salary").Desc().
        Collect()

    gotableview.FromStructs("High Earners", result).Show()
}

// Rounded borders
plygo.From(people).Show(plygo.WithStyle("rounded"))

// Double borders
plygo.From(people).Show(plygo.WithStyle("double"))

// Minimal (no borders)
plygo.From(people).Show(plygo.WithStyle("minimal"))

// Markdown format
plygo.From(people).Show(plygo.WithStyle("markdown"))

// With title
plygo.From(people).Show(plygo.WithTitle("Employee Data"))

// With row numbers
plygo.From(people).Show(plygo.WithRowNumbers(true))

// Show original indices after filtering
plygo.From(people).
    Where("Age").GreaterThan(30).
    Show(plygo.WithOriginalIndices(true))

// Custom float precision
plygo.From(people).Show(plygo.WithFloatPrecision(0))

// Boolean as symbols (✓/✗)
plygo.From(people).Show(plygo.WithBoolStyle("symbols"))

// Limit displayed rows
plygo.From(people).Show(plygo.WithMaxRows(10))

// Combined options
plygo.From(people).Show(
    plygo.WithTitle("Report"),
    plygo.WithStyle("rounded"),
    plygo.WithRowNumbers(true),
    plygo.WithFloatPrecision(2),
)

// Display at any point in the pipeline
plygo.From(people).
    Show(plygo.WithTitle("Original")).
    Where("Age").GreaterThan(30).
    Show(plygo.WithTitle("Filtered")).
    OrderBy("Salary").Desc().
    Show(plygo.WithTitle("Sorted"))

// Get specific rows (1-based indexing)
plygo.From(people).AtRow(1, 3, 5).Collect()

// Negative indices (Python-style)
plygo.From(people).AtRow(-1).Collect()        // Last element
plygo.From(people).AtRow(1, -1).Collect()     // First and last

// Range of rows
plygo.From(people).RowRange(2, 5).Collect()   // Rows 2-4
plygo.From(people).RowRange(3, -1).Collect()  // From row 3 to end

// Tail - last n rows
plygo.From(people).Tail(3).Collect()

// Slice with step
plygo.From(people).Slice(1, -1, 2).Collect()  // Every other row

// Get specific columns by position
plygo.From(people).AtCol(1, 3).Collect()      // Name and City

// Range of columns
plygo.From(people).ColRange(2, 4).Collect()   // Age and City

// Field introspection
fields := plygo.From(people).FieldNames()     // ["Name", "Age", "City", "Salary"]
count := plygo.From(people).FieldCount()       // 4

// Get original indices after filtering
positions := plygo.From(people).
    Where("Age").GreaterThan(30).
    Positions()

// Display positions elegantly
plygo.ShowPositions(positions)

// AND (implicit)
Where("Age").GreaterThan(30).
Where("Active").IsTrue()

// OR
Where("City").Equals("NYC").Or("City").Equals("LA")

// OneOf (cleaner OR)
Where("City").OneOf("NYC", "LA", "Chicago")

// Between
Where("Age").Between(25, 35)

// String operations
Where("Name").Contains("Smith")
Where("Name").StartsWith("A")
Where("Name").EndsWith("son")

GroupBy("City").Count()
GroupBy("City").Sum("Salary")
GroupBy("City").Avg("Age")
GroupBy("City").Min("Salary")
GroupBy("City").Max("Salary")

OrderBy("Salary").Desc()
OrderBy("Age").Asc().ThenBy("Salary").Desc()

Transform(func(p Person) Person {
    p.Salary *= 1.1
    return p
})