CORE POS - Fannie
The CORE POS back end
|
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 () | |
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
|
protected |