CORE POS - Fannie
The CORE POS back end
Public Member Functions | Protected Attributes | List of all members
ObfWeeklyReportV2 Class Reference
Inheritance diagram for ObfWeeklyReportV2:
ObfWeeklyReport FannieReportPage FanniePage

Public Member Functions

 preprocess ()
 
 fetch_report_data ()
 
- Public Member Functions inherited from ObfWeeklyReport
 preprocess ()
 
 report_description_content ()
 
 fetch_report_data ()
 
 form_content ()
 
- Public Member Functions inherited from FannieReportPage
 preprocess ()
 
 form_content ()
 
 bodyContent ()
 
 report_content ()
 
 both_content ()
 
 calculate_footers ($data)
 
 assign_headers ()
 
 select_headers ($incrIndex=False)
 
 report_description_content ()
 
 report_end_content ()
 
 fetch_report_data ()
 
 render_data ($data, $headers=array(), $footers=array(), $format='html')
 
 dekey_array ($arr)
 
 htmlLine ($row, $header=False)
 
 csvLine ($row)
 
 excelFormat ($item, $style='')
 
 xlsMeta ($data)
 
 setForm (COREPOS\common\mvc\ValueContainer $f)
 
 requiredFields ()
 
 drawPage ()
 
 draw_page ()
 
 baseUnitTest ($phpunit)
 

Protected Attributes

 $sortable = false
 
 $no_sort_but_style = true
 
 $report_headers
 
 $class_lib = 'ObfLibV2'
 
- Protected Attributes inherited from ObfWeeklyReport
 $header = 'OBF: Weekly Report'
 
 $title = 'OBF: Weekly Report'
 
 $required_fields = array('weekID')
 
 $new_tablesorter = false
 
 $report_headers
 
 $class_lib = 'ObfLib'
 
 $colors
 
 $salesP = null
 
 $quarterSalesP = null
 
 $quarterLaborP = null
 
 $quarterSplhP = null
 
 $stockP = null
 
 $trendP = null
 
- Protected Attributes inherited from FannieReportPage
 $content_function = "form_content"
 
 $required_fields = array()
 
 $report_headers = array()
 
 $report_format = 'html'
 
 $report_cache = 'none'
 
 $multi_report_mode = False
 
 $multi_counter = 1
 
 $header_index = 0
 
 $sortable = true
 
 $no_sort_but_style = false
 
 $sort_column = 0
 
 $sort_direction = 0
 
 $new_tablesorter = false
 
 $no_jquery = false
 
 $chart_label_column = 0
 
 $chart_data_columns = array()
 
 $form
 

Additional Inherited Members

- Public Attributes inherited from ObfWeeklyReport
 $page_set = 'Plugin :: Open Book Financing'
 
 $report_set = 'Sales Reports'
 
 $description = '[OBF Weekly Report] shows open book financing sales and labor data for a given week.'
 
 $themed = true
 
- Public Attributes inherited from FannieReportPage
 $required = True
 
 $description
 
 $page_set = 'Reports'
 
 $report_set = ''
 
 $discoverable = true
 
const META_BOLD = 1
 
const META_BLANK = 2
 
const META_REPEAT_HEADERS = 4
 
const META_CHART_DATA = 8
 
const META_COLOR = 16
 
- Protected Member Functions inherited from ObfWeeklyReport
 initTotalSales ()
 
 initTotalTrans ()
 
 initTotalHours ()
 
 initTotalWages ()
 
 getAverageWage ($labor)
 
 projectHours ($splhGoal, $dept_proj, $dept_trend)
 
 projectWages ($labor, $proj_hours, $trend_hours)
 
 rewritePercentageOfSales ($data, $total_sales)
 
 headerRow ($header, $text='black')
 
 percentGrowth ($a, $b)
 
 findYearMonth ($start_ts, $end_ts)
 
 updateSalesCache ($week, $num_cached, $dateInfo)
 
 prepareStatements ($dbc)
 
 prepTrendsStatement ($dbc, $week)
 
 getStock ($dbc, $args)
 
 ownershipThisWeek ($dbc, $start_ts, $end_ts, $start_ly, $end_ly)
 
 ownershipThisYear ($dbc, $end_ts)
 
 calculateTrend ($dbc, $categoryID, $superID)
 
- Protected Member Functions inherited from FannieReportPage
 hasAllFields ($fields)
 
 hasWarehouseSource ()
 
 getData ()
 
 multiContent ($data)
 
 singleContent ($data)
 
 format ($data)
 
 checkDataCache ()
 
 freshenCache ($data)
 
 defaultDescriptionContent ($rowcount, $datefields=array())
 
 formatCheck ()
 

Member Function Documentation

ObfWeeklyReportV2::fetch_report_data ( )

Timestamps for the start and end of the current week

Use the entire month from the previous calendar year as the time period for year-over-year comparisons

Sales information is cached to avoid expensive aggregate queries

LOOP ONE Examine OBF Categories that have sales. These will include both sales and labor information

Go through sales records for the category

total sales for the category

Now labor values based on sales calculationsabove

LOOP TWO Examine OBF Categories without sales. These will include only labor information

Storewide totals section

Organization totals section

Member Data Documentation

ObfWeeklyReportV2::$report_headers
protected
Initial value:
= array(
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Last Year', 'Plan Goal', '% Store', 'Trend', 'Actual', '% Growth', '% Store', 'Current O/U', 'Long-Term O/U'),
array('', 'Current Year', 'Last Year', '', '', '', '', '', '', ''),
)

The documentation for this class was generated from the following file: