Subselect and sum row Default theme
Subselect() will create a new column with some value from other (or current) table. You can use any columns from current tables as parameters. Subselect will be called for each row
HIDE CODE
<?php $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 echo $xcrud->render(); ?>
Customers
# | Customername | City | Creditlimit | Paid | Profit | |
---|---|---|---|---|---|---|
1 | Signal Gift Storess | Las Vegas | 71800 | $0.00 | View Edit Remove | |
2 | Australian Collectors, Co. | Melbourne | 117300 | $0.00 | View Edit Remove | |
3 | La Rochelle Gifts | Nantes | 118200 | 2 | $-118,198.00 | View Edit Remove |
4 | Zbyszek Zbyszek Piestrzeniewicz | Warszawa | 1230 | $0.00 | View Edit Remove | |
5 | Blauer See Auto, Co. | Frankfurt | 59700 | 75937.76000000001 | $16,237.76 | View Edit Remove |
6 | Mini Wheels Co. | San Francisco | 64600 | 66710.56 | $2,110.56 | View Edit Remove |
7 | Land of Toys Inc. | NYC | 114900 | 107639.94 | $-7,260.06 | View Edit Remove |
8 | Euro+ Shopping Channel | Madrid | 227600 | 715738.9800000001 | $488,138.98 | View Edit Remove |
9 | Danish Wholesale Imports | Kobenhavn | 83400 | 107446.5 | $24,046.50 | View Edit Remove |
10 | Saveley & Henriot, Co. | Lyon | 123900 | 130305.9 | $6,405.90 | View Edit Remove |
Σ | 7820630.12 | 7666140.750000002 | $35,840.63 |