$sales->lastYearTransactions($avg_trans);
} else {
$sales->lastYearTransactions(0);
}
/**
Sales last year, pro-rated
*/
$twoQ = str_replace('__table__', $dlog2, $salesQ);
$twoP = $dbc->prepare($twoQ);
$twoR = $dbc->execute($twoP, $args);
while ($row = $dbc->fetch_row($twoR)) {
$sales->obfCategoryID($row['id']);
$sales->superID($row['superID']);
$avg_sales = $row['sales'] / $num_days * 7;
$sales->lastYearSales($avg_sales);
if ($future) {
$sales->actualSales(0);
$labor = $class_lib::getLabor($dbc);
$labor->obfWeekID($week->obfWeekID());
$labor->obfCategoryID($row['id']);
foreach ($labor->find() as $l) {
$sales->growthTarget($l->growthTarget());
}
}
$sales->save();
}
}
}
}
FannieDispatch::conditionalExec();
$this->stats['done']++;
}
}
return $ret;
}
function form_content()
{
return '<div class="well"><legend>Instructions</legend>
Upload a CSV or XLS file containing likecode #s and prices. Cost
may also optionally be included.
<br />A preview helps you to choose and map columns to the database.
<br />The uploaded file will be deleted after the load.
</div><br />';
}
function results_content()
{
\COREPOS\Fannie\API\data\SyncLanes::pushTable('products');
$ret = '<p>Import Complete</p>';
$ret .= '<div class="alert alert-success">Updated ' . $this->stats['done'] . ' likecodes</div>';
if (count($this->stats['error']) > 0) {
$ret .= '<div class="alert alert-danger"><ul>';
foreach ($this->stats['error'] as $error) {
$ret .= '<li>' . $error . '</li>';
}
$ret .= '</ul></div>';
}
return $ret;
}
}
FannieDispatch::conditionalExec(false);