function form_content()
{
$dbc = $this->connection;
$dbc->selectDB($this->config->get('OP_DB'));
$deptsQ = $dbc->prepare_statement("select dept_no,dept_name from departments order by dept_no");
$deptsR = $dbc->exec_statement($deptsQ);
$deptsList = "";
while ($deptsW = $dbc->fetch_array($deptsR)) {
$deptsList .= "<option value={$deptsW['0']}>{$deptsW['0']} {$deptsW['1']}</option>";
}
ob_start();
?>
<form method="get" action="NonMovementReport.php" class="form-horizontal">
<div class="col-sm-6">
<?php
echo FormLib::standardDepartmentFields();
?>
<div class="form-group">
<label class="control-label col-sm-4">
Excel
<input type=checkbox name=excel value=xls id="excel" />
</label>
<label class="control-label col-sm-4">
Netted
<input type=checkbox name=netted id="netted" />
</label>
</div>
<div class="form-group">
<button type=submit name=submit value="Submit" class="btn btn-default btn-core">Submit</button>
<button type=reset name=reset class="btn btn-default btn-reset"
onclick="$('#super-id').val('').trigger('change');">Start Over</button>
</div>
</div>
<div class="col-sm-5">
<div class="form-group">
<label class="col-sm-4 control-label">Start Date</label>
<div class="col-sm-8">
<input type=text id=date1 name=date1 class="form-control date-field" required />
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">End Date</label>
<div class="col-sm-8">
<input type=text id=date2 name=date2 class="form-control date-field" required />
</div>
</div>
<div class="form-group">
<?php
echo FormLib::date_range_picker();
?>
</div>
</div>
</form>
<?php
return ob_get_clean();
}
function form_content()
{
global $FANNIE_OP_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$deptQ = $dbc->prepare_statement("select dept_no,dept_name from departments order by dept_no");
$deptR = $dbc->exec_statement($deptQ);
$depts = array();
while ($deptW = $dbc->fetch_array($deptR)) {
$depts[$deptW['dept_no']] = $deptW['dept_name'];
}
$superQ = $dbc->prepare_statement("SELECT superID,super_name FROM superDeptNames \n ORDER BY superID");
$superR = $dbc->exec_statement($superQ);
$supers = array();
while ($superW = $dbc->fetch_row($superR)) {
$supers[$superW['superID']] = $superW['super_name'];
}
$subs = array();
if (count($depts) > 0) {
$dept_numbers = array_keys($depts);
$first = $dept_numbers[0];
$subsP = $dbc->prepare('
SELECT subdept_no,
subdept_name
FROM subdepts
WHERE dept_ID=?
ORDER BY subdept_no');
$subsR = $dbc->execute($subsP, array($first));
while ($subsW = $dbc->fetch_row($subsR)) {
$subs[$subsW['subdept_no']] = $subsW['subdept_name'];
}
}
ob_start();
?>
<form method="get" action="ProductListPage.php">
<ul class="nav nav-tabs" role="tablist">
<li class="active"><a href="#dept-tab" data-toggle="tab"
onclick="$('#supertype').val('dept');">By Department</a></li>
<li><a href="#manu-tab" data-toggle="tab"
onclick="$('#supertype').val('manu');">By Brand</a></li>
<li><a href="#vendor-tab" data-toggle="tab"
onclick="$('#supertype').val('vendor');">By Vendor</a></li>
</ul>
<input id="supertype" name="supertype" type="hidden" value="dept" />
<div class="tab-content">
<p>
<div class="tab-pane active" id="dept-tab">
<div class="row form-horizontal">
<div class="col-sm-8">
<?php
echo FormLib::standardDepartmentFields('deptSub');
?>
</div>
</div>
</div>
<div class="tab-pane" id="manu-tab">
<div class="form-group form-inline">
<label><?php
echo _('Brand');
?>
</label>
<input type=text name=manufacturer class="form-control" />
</div>
<div class="form-group form-inline">
<label><input type=radio name=mtype value=prefix checked />
UPC prefix</label>
<label><input type=radio name=mtype value=name />
<?php
echo _('Brand name');
?>
</label>
</div>
</div>
<div class="tab-pane" id="vendor-tab">
<div class="form-group form-inline">
<label>Vendor</label>
<select name="vendor" class="form-control">
<?php
$vendors = new VendorsModel($dbc);
foreach ($vendors->find('vendorName') as $v) {
printf('<option value="%d">%s</option>', $v->vendorID(), $v->vendorName());
}
?>
</select>
</div>
</div>
</p>
</div>
<div class="form-group form-inline">
<label>Sort by</label>
<select name="sort" class="form-control">
<option>Department</option>
<option>UPC</option>
<option>Description</option>
</select>
<label>
<input type=checkbox name="inUse" value="1" checked />
In Use
</label>
|
<label>
<input type=checkbox name=excel />
Excel
</label>
</div>
<?php
if ($this->config->get('STORE_MODE') == 'HQ') {
$picker = FormLib::storePicker();
echo '<div class="form-group form-inline">
<label>Store</label> ' . $picker['html'] . '</div>';
}
?>
<p>
<button type=submit name=submit class="btn btn-default btn-core">Submit</button>
<button type=reset id="reset-btn" class="btn btn-default btn-reset"
onclick="$('#super-id').val('').trigger('change');">Start Over</button>
</p>
</form>
<?php
return ob_get_clean();
}
public function form_content()
{
ob_start();
?>
<form method="get" class="form-horizontal">
<div class="row">
<div class="col-sm-6">
<?php
echo FormLib::standardDepartmentFields('buyer');
?>
<div class="form-group">
<label class="col-sm-4 control-label">
Group by weekday?
<input type=checkbox name=weekday value=1>
</label>
</div>
<div class="form-group">
<label class="control-label col-sm-4">Save to Excel
<input type=checkbox name=excel id=excel value=1>
</label>
<label class="col-sm-4 control-label">Store</label>
<div class="col-sm-4">
<?php
$ret = FormLib::storePicker();
echo $ret['html'];
?>
</div>
</div>
</div>
<div class="col-sm-5">
<div class="form-group">
<label class="col-sm-4 control-label">Start Date</label>
<div class="col-sm-8">
<input type=text id=date1 name=date1 class="form-control date-field" required />
</div>
</div>
<div class="form-group">
<label class="col-sm-4 control-label">End Date</label>
<div class="col-sm-8">
<input type=text id=date2 name=date2 class="form-control date-field" required />
</div>
</div>
<div class="form-group">
<?php
echo FormLib::date_range_picker();
?>
</div>
</div>
</div>
<p>
<button type=submit name=submit value="Submit" class="btn btn-default btn-core">Submit</button>
<button type=reset name=reset class="btn btn-default btn-reset"
onclick="$('#super-id').val('').trigger('change');">Start Over</button>
</p>
</form>
<?php
$this->addOnloadCommand("\$('#subdepts').closest('.form-group').hide();");
return ob_get_clean();
}
public function form_content()
{
$ret = '<form method="get" class="form-horizontal pull-left">' . FormLib::standardDepartmentFields() . '<p>
<button type="submit" name="submit" value="1"
class="btn btn-default">Get Report</button>
</p>
</form>';
return $ret;
}
