mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2026-04-02 14:24:27 -04:00
1328b4d9b8
- Added TODO where we need to convert to querybuilder - Converted to switch statement. - Removed unnecessary local variable - Replaced Qualifiers with imports - Replaced isset() call with null coalescing operator - Replaced strpos function calls in if statements with str_contains calls - Removed unnecessary leading \ in use statement - Replaced deprecated functions - Updated PHPdocs to match function signature - Added missing type declarations - Made class variables private. - Explicitly declared dynamic properties - use https:// links instead of http:// - Fixed type error from sending null when editing transactions - Fixed Search Suggestion function name in Employees, Persons, Suppliers controller - Fixed function name on Receivings Controller Signed-off-by: objecttothis <objecttothis@gmail.com>
61 lines
1.8 KiB
PHP
61 lines
1.8 KiB
PHP
<?php
|
|
|
|
namespace App\Models\Reports;
|
|
|
|
class Summary_suppliers extends Summary_report
|
|
{
|
|
/**
|
|
* @return array[]
|
|
*/
|
|
protected function _get_data_columns(): array //TODO: hungarian notation
|
|
{
|
|
return [
|
|
['supplier_name' => lang('Reports.supplier')],
|
|
['quantity' => lang('Reports.quantity')],
|
|
['subtotal' => lang('Reports.subtotal'), 'sorter' => 'number_sorter'],
|
|
['tax' => lang('Reports.tax'), 'sorter' => 'number_sorter'],
|
|
['total' => lang('Reports.total'), 'sorter' => 'number_sorter'],
|
|
['cost' => lang('Reports.cost'), 'sorter' => 'number_sorter'],
|
|
['profit' => lang('Reports.profit'), 'sorter' => 'number_sorter']
|
|
];
|
|
}
|
|
|
|
/**
|
|
* @param array $inputs
|
|
* @param object $builder
|
|
* @return void
|
|
*/
|
|
protected function _select(array $inputs, object &$builder): void //TODO: hungarian notation
|
|
{
|
|
parent::_select($inputs, $builder); //TODO: hungarian notation
|
|
|
|
$builder->select('
|
|
MAX(CONCAT(supplier_c.company_name, " (", supplier_p.first_name, " ", supplier_p.last_name, ")")) AS supplier,
|
|
SUM(sales_items.quantity_purchased) AS quantity_purchased
|
|
');
|
|
}
|
|
|
|
/**
|
|
* @param object $builder
|
|
* @return void
|
|
*/
|
|
protected function _from(object &$builder): void //TODO: hungarian notation
|
|
{
|
|
parent::_from($builder); //TODO: hungarian notation
|
|
|
|
$builder->join('items AS items', 'sales_items.item_id = items.item_id');
|
|
$builder->join('suppliers AS supplier_c', 'items.supplier_id = supplier_c.person_id ');
|
|
$builder->join('people AS supplier_p', 'items.supplier_id = supplier_p.person_id');
|
|
}
|
|
|
|
/**
|
|
* @param object $builder
|
|
* @return void
|
|
*/
|
|
protected function _group_order(object &$builder): void //TODO: hungarian notation
|
|
{
|
|
$builder->groupBy('items.supplier_id');
|
|
$builder->orderBy('MAX(CONCAT(supplier_c.company_name, " (", supplier_p.first_name, " ", supplier_p.last_name, ")"))');
|
|
}
|
|
}
|