\SalesReport
- Author: Nicolaas [at] sunnysideup.co.nz
Synopsis
class SalesReport
extends SS_Report
{
- // members
- protected static array $full_export_select_statement = ;
- protected static string $full_export_join_statement = ' INNER JOIN `Order` ON `Order`.`ID` = `OrderAttribute`.`OrderID` INNER JOIN `Member` On `Order`.`MemberID` = `Member`.`ID` LEFT JOIN `Payment` ON `Payment`.`OrderID` = `Order`.`ID` LEFT JOIN `Product_versions` ProductForProducts ON `Product_OrderItem`.`ProductID` = ProductForProducts.`RecordID` AND `Product_OrderItem`.`ProductVersion` = ProductForProducts.`Version` LEFT JOIN `SiteTree_versions` SiteTreeForProducts ON SiteTreeForProducts.`RecordID` = `Product_OrderItem`.`ProductID` AND `Product_OrderItem`.`ProductVersion` = SiteTreeForProducts.`Version` LEFT JOIN `ProductVariation_versions` ProductVariationsForVariations ON `ProductVariation_OrderItem`.`ProductVariationID` = ProductVariationsForVariations.`RecordID` AND `ProductVariation_OrderItem`.`ProductVariationVersion` = ProductVariationsForVariations.`Version` LEFT JOIN `SiteTree_versions` ProductSiteTreeForVariations ON `ProductSiteTreeForVariations`.`RecordID` = `Product_OrderItem`.`ProductID` AND `Product_OrderItem`.`ProductVersion` = `ProductSiteTreeForVariations`.`Version` LEFT JOIN `OrderStatusLog` ON `OrderStatusLog`.`OrderID` = `Order`.`ID` LEFT JOIN `OrderStatusLogWithDetails` ON `OrderStatusLogWithDetails`.`ID` = `OrderStatusLog`.`ID`';
- protected static string $full_export_file_name = "SalesExport";
- protected string $title = 'All Orders';
- protected static array $sales_array = ;
- protected string $description = 'Search Orders';
- // methods
- public static void set_full_export_select_statement()
- public static void get_full_export_select_statement()
- public static void set_full_export_join_statement()
- public static void get_full_export_join_statement()
- public static void set_full_export_file_name()
- public static void get_full_export_file_name()
- public ComplexTableField getReportField()
- public void getCustomQuery()
- public void getExportFields()
- public void getExportQuery()
- protected void statistic()
- public void processform()
Hierarchy
Extends
- SS_Report
Members
protected
- $description
- $full_export_file_name
- $full_export_join_statement
- $full_export_select_statement
- $sales_array
- $title
Methods
protected
public
- getCustomQuery()
- getExportFields()
- getExportQuery()
- getReportField() — Return a {@link ComplexTableField} that shows all Order instances that are not printed. That is, Order instances with the property "Printed" value set to "0".
- get_full_export_file_name()
- get_full_export_join_statement()
- get_full_export_select_statement()
- processform()
- set_full_export_file_name()
- set_full_export_join_statement()
- set_full_export_select_statement()