Pie Chart NEW
1.7.27 Bootstrap 5 theme
Simply create charts and pie chart
HIDE CODE
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 | <style> canvas{ height: 600px!important; } </style> <?php // Bar Chart Example - First Instance $xcrud1 = Xcrud::get_instance(); $xcrud1 ->table( 'orderdetails' ); $xcrud1 ->chart_labels( [ 'S24_2841' , 'S24_3420' , 'S24_3949' , 'S24_4278' , 'S32_4289' , 'S50_1341' ], // Labels [ // Multiple datasets (even if there's just one) [ 'label' => '# of Quantity Ordered' , // Dataset label 'data' => '#select quantityOrdered from orderdetails where id IN (60,61,62,63,64,65)' , // Data points 'backgroundColor' => [ // Different colors for each segment 'rgba(255, 99, 132, 0.2)' , // Red - S24_2841 'rgba(54, 162, 235, 0.2)' , // Blue - S24_3420 'rgba(255, 206, 86, 0.2)' , // Yellow - S24_3949 'rgba(75, 192, 192, 0.2)' , // Green - S24_4278 'rgba(153, 102, 255, 0.2)' , // Purple - S32_4289 'rgba(255, 159, 64, 0.2)' // Orange - S50_1341 ], 'borderColor' => [ // Different border colors for each segment 'rgba(255, 99, 132, 1)' , // Red - S24_2841 'rgba(54, 162, 235, 1)' , // Blue - S24_3420 'rgba(255, 206, 86, 1)' , // Yellow - S24_3949 'rgba(75, 192, 192, 1)' , // Green - S24_4278 'rgba(153, 102, 255, 1)' , // Purple - S32_4289 'rgba(255, 159, 64, 1)' // Orange - S50_1341 ], 'borderWidth' => 1 // Border width for each segment ] ], 'pie' , // Chart type (e.g., 'pie') [ 'plugins' => [ 'legend' => [ 'display' => true] // Display the legend ] ] // Custom options (e.g., legend display) ); $xcrud1 ->chart_view(true); $xcrud1 ->unset_add(); $xcrud1 ->unset_edit(); $xcrud1 ->unset_remove(); $xcrud1 ->unset_view(); $xcrud1 ->unset_csv(); $xcrud1 ->unset_limitlist(); $xcrud1 ->unset_numbers(); $xcrud1 ->unset_pagination(); $xcrud1 ->unset_print(); $xcrud1 ->unset_search(); $xcrud1 ->unset_title(); $xcrud1 ->unset_sortable(); echo $xcrud1 ->render(); ?> |