Download Laravel-xCRUD Integration Full Code that includes this full demo
Get Started
Simple Example Base Fields Tabs Nested Tabs Multiple InstancesForm Controls
Columns and fields Labels and classes Dependent dropdowns Date range CKEditor and custom Select2 usage Tooltips Radio Switch buttons Grouping Form Fields Edit - ModalGrid
One million rows Column width/cut Ordering example Cells & Row Highlights Subselect and sum row Column Grouping Inline EditingTable Joins & Relations
Join other table Simple relation Relation Field Grouping Many-to-many relationsUploads & Images
Uploads demo GalleryValidations
Simple validation Parsley ValidationTricks
Buttons Simple Ajax Buttons Bulk Delete JS tricks
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
class xSubselectController extends Controller
{
public function index()
{
$xcrud = Xcrud_get_instance();
$xcrud->table('customers');
$xcrud->columns('customerName,city,creditLimit,Paid,Profit'); // specify only some columns
$xcrud->subselect('Paid','SELECT SUM(amount) FROM payments WHERE customerNumber = {customerNumber}'); // other table
$xcrud->subselect('Profit','{Paid}-{creditLimit}'); // current table
$xcrud->sum('creditLimit,Paid,Profit'); // sum row(), receives data from full table (ignores pagination)
$xcrud->change_type('Profit','price','0',array('prefix'=>'$')); // number format
$render = $xcrud->render();
return view('xcrud_simple', ['render' => $render]);
}
}
Customers
| # | Customername | City | Creditlimit | Paid | Profit | |
|---|---|---|---|---|---|---|
| 1 | Atelier graphique | Nantes | 21000 | 14191.12 | $-6,808.88 | View Edit Remove |
| 2 | Signal Gift Stores | Las Vegas | 71800 | 150 | $-71,650.00 | View Edit Remove |
| 3 | Australian Collectors, Co. | Melbourne | 117300 | 134720 | $17,420.00 | View Edit Remove |
| 4 | La Rochelle Gifts | Nantes | 118200 | 116949.687 | $-1,250.31 | View Edit Remove |
| 5 | Baane Mini Imports | Stavern | 81700 | 104224.79 | $22,524.79 | View Edit Remove |
| 6 | Mini Gifts Distributors Ltd. | San Rafael | 210500 | 584188.2400000001 | $373,688.24 | View Edit Remove |
| 7 | Zbyszek Zbyszek Piestrzeniewicz | Warszawa | 1230 | $0.00 | View Edit Remove | |
| 8 | Blauer See Auto, Co. | Frankfurt | 59700 | 75937.76000000001 | $16,237.76 | View Edit Remove |
| 9 | Mini Wheels Co. | San Francisco | 64600 | 66710.56 | $2,110.56 | View Edit Remove |
| 10 | Land of Toys Inc. | NYC | 114900 | 107639.94 | $-7,260.06 | View Edit Remove |
| Σ | 8172230.12 | 8588124.657000002 | $417,124.54 |