Tip: Be specific about your Model names and column names in your prompts to get the run-ready code.
Bar & Line Charts
For time-series or categorical comparisons, ask for labels and values arrays.
Prompt: Users per Month
Use this prompt to generate a query for time-series data grouped by month.
1I am using Laravel and the Beartropy Charts package. 2I need a PHP Array ready for the chart component. 3The array must have keys: 'labels' (array of strings) and 'values' (array of numbers). 4 5Task: 6Write a Laravel Controller method that queries the 'User' model. 7Get the count of users created per month for the current year. 8Format the labels as full month names (e.g., "January", "February"). 910Return ONLY the PHP code for the controller method.Pie & Donut Charts
For distribution data, the structure is similar to Bar charts but often simpler.
Prompt: Order Status Distribution
Use this prompt to get a simple breakdown of categories.
1I am using Laravel and the Beartropy Charts package. 2I need a PHP Array for a Pie Chart. 3The array must have keys: 'labels' and 'values'. 4 5Task: 6Query the 'Order' model. 7Group by 'status' column and count the number of orders in each status. 8Return the result formatted for the chart. 910Return ONLY the PHP code.Polar & Radar Charts
These charts often require more complex data structures, including colors or specific dataset keys.
Prompt: Regional Sales with Colors
This prompt asks for an array of objects with custom colors mapped to data keys.
1I am using Laravel and the Beartropy Charts package for a Polar Area Chart. 2I need an array of objects, each having: 'label' (string), 'value' (number), and 'color' (string). 3 4Task: 5Query 'Sale' model, grouped by 'region'. 6Sum the 'amount' for each region. 7Assign a specific color to each region: 8- North: blue 9- South: green10- East: orange11- West: purple1213Return the PHP code for the controller method.Prompt: Multi-Dataset Product Comparison
Use this for generating complex multi-dataset structures for comparison charts.
1I am using Laravel and the Beartropy Charts package for a Radar Chart. 2I need to compare 3 different products based on their ratings. 3Metrics: Speed, Quality, Price, Design, Support. 4 5Task: 6Create a method that accepts an array of product IDs. 7Fetch products with their reviews. 8Calculate average rating for each metric. 9Return an array where each item represents a dataset for a product, with keys: 'label', 'color', and the metrics as keys with their values.1011Return ONLY the PHP code.