CORE POS - Fannie
The CORE POS back end
|
Public Member Functions | |
preprocess () | |
fetch_report_data () | |
![]() | |
preprocess () | |
report_description_content () | |
fetch_report_data () | |
form_content () | |
![]() | |
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' | |
![]() | |
$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 | |
![]() | |
$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 | |
![]() | |
$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 | |
![]() | |
$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 |
![]() | |
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) | |
![]() | |
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 |