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; }