$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><?php
$theform->showField("type");
?>
</p>
<p><?php
$theform->showField("default");
?>
</p>
<p><?php
$theform->showField("moduleid");
?>
</p>
<p><?php
$theform->showField("roleid");
$thetable->getCustomFieldInfo();
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><?php
$theform->showField("inactive");
?>
</p>
<p>
script last run<br />
<strong><?php
if ($therecord["lastrun"]) {
echo $therecord["lastrun"];
} else {
echo "never";
}
?>
</strong>
</p>
</fieldset>
function showOptions()
{
include "include/fields.php";
global $phpbms;
$db =& $this->db;
$phpbms->cssIncludes[] = "pages/aritems_clientstatement.css";
$phpbms->jsIncludes[] = "modules/bms/javascript/aritem_clientstatement.js";
$phpbms->showMenu = false;
$formSubmit = htmlentities($_SERVER['REQUEST_URI']);
$theform = new phpbmsForm();
$theinput = new inputDatePicker("statementdate", dateToString(mktime(0, 0, 0), "SQL"), "statement date", true);
$theform->addField($theinput);
$theinput = new inputCheckbox("showpayments", true, "show new payments");
$theform->addField($theinput);
$theinput = new inputCheckbox("showclosed", false, "show closed items (history)");
$theform->addField($theinput);
$theform->jsMerge();
include "header.php";
?>
<div class="bodyline" id="dialog">
<h1><span>AR Summary Report</span></h1>
<form action="<?php
echo $formSubmit;
?>
" id="record" method="post">
<input type="hidden" id="command" name="command" />
<fieldset>
<legend>options</legend>
<p><?php
$theform->showField("statementdate");
?>
</p>
<p><?php
$theform->showField("showclosed");
?>
</p>
<p><?php
$theform->showField("showpayments");
?>
</p>
</fieldset>
<!-- THIS NO WORKY -->
<!--<fieldset>
<legend>payments</legend>
<p>
<input type="radio" name="payments" id="paymentsNew" value="new" class="radiochecks" checked="checked"/>
<label for="paymentsNew">show new payments</label>
</p>
<p>
<input type="radio" name="payments" id="paymentsAll" value="all" class="radiochecks"/>
<label for="paymentsAll">show all payments</label>
</p>
<p>
<input type="radio" name="payments" id="paymentsNone" value="none" class="radiochecks"/>
<label for="paymentsNone">show no payments</label>
</p>
</fieldset>-->
<fieldset>
<legend>Records</legend>
<p>
<input type="radio" name="selrecords" id="allOpen" value="allOpen" class="radiochecks" checked="checked"/>
<label for="allOpen">all clients with open items</label>
</p>
<p>
<input type="radio" name="selrecords" id="allClients" value="allClients" class="radiochecks"/>
<label for="allClients">all clients with any credit history</label>
</p>
<p>
<input type="radio" name="selrecords" id="fromPrint" value="fromPrint" class="radiochecks"/>
<label for="fromPrint">clients based on records from print screen</label>
</p>
</fieldset>
<p align="right">
<button type="button" class="Buttons" id="printButton">print</button>
<button type="button" class="Buttons" id="cancelButton">cancel</button>
</p>
</form>
</div>
<?php
include "footer.php";
}
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><br /><?php
$theform->showField("inactive");
?>
</p>
<p><?php
$theform->showField("priority");
?>
</p>
<p class="notes">Lower priority numbered items are displayed first.</p>
</fieldset>
<div id="nameDiv">
<fieldset >
<legend>name</legend>
?>
</ul>
</div>
<h2 class="moduleButtons">Main System (Base Module)</h2>
<div class="moduleSections">
<div class="containers">
<div class="moduleTab" title="general">
<fieldset>
<legend>general</legend>
<p class="big"><?php
$theform->showField("application_name");
?>
</p>
<p class="notes">
<strong>Example:</strong> Replace this with your company name + BMS (e.g. "Kreotek BMS"). Replacing
the application name will reset the session cookie, and require you to log in again.
</p>
<p><?php
$theform->showfield("application_uuid");
?>
</p>
<p><?php
$theform->showfield("auto_check_update");
?>
<div id="topButtons"><?php
showSaveCancel(1);
?>
</div>
<h1 class="h1Title"><span><?php
echo $pageTitle;
?>
</span></h1>
<div id="rightSide">
<fieldset>
<legend>attributes</legend>
<p><?php
$theform->showField("theid");
?>
</p>
<p><?php
$theform->showField("receiptdate");
?>
</p>
<?php
if ($therecord["posted"]) {
?>
<p><?php
$theform->showField("posted");
?>
</p>
<?php
} else {
?>
<tr class="norecords"><td colspan="4" align="center">No Prerequisites to Display</td></tr>
<?php
}
//end if
?>
</table>
</div>
<fieldset>
<legend>add new prerequisite</legend>
<div class="preqAdd fauxP"><?php
$theform->showField("productid");
?>
</div>
<p id="addButtonP"><br />
<button type="submit" class="graphicButtons buttonPlus" onclick="return addLine()"><span>+</span></button>
</p>
</fieldset>
<fieldset>
<legend>notes</legend>
<p class="notes">
Prerequisites are products that must be purchased by the client
on a prior order before this product can be purchased.
</p>
<p class="notes">
<form action="<?php
echo htmlentities($_SERVER["PHP_SELF"]);
?>
" method="post" name="record" id="record" onsubmit="return false">
<input type="hidden" id="cmd" name="cmd" value=""/>
<h1><span><?php
echo $pageTitle;
?>
</span></h1>
<fieldset>
<legend>posting date range</legend>
<p class="dateranges"><?php
$theform->showField("startdate");
?>
</p>
<p class="dateranges"><?php
$theform->showField("enddate");
?>
</p>
<p>
<br />
<button id="changeDateRange" type="button" class="Buttons">find</button>
</p>
</fieldset>
<fieldset>
</span></h1>
<input type="hidden" id="id" name="id" value="<?php
echo $therecord["id"];
?>
"/>
<input type="hidden" id="eachlist" name="eachlist" value=""/>
<input type="hidden" id="command" name="command" />
<input type="hidden" id="referrer" name="referrer" value="<?php
echo str_replace("&", "&", $_SERVER['HTTP_REFERER']);
?>
" />
<fieldset>
<legend>Invoice Recurrence</legend>
<p><?php
$theform->showField("recurr");
?>
</p>
<?php
if ($invoiceDate == NULL) {
?>
<p class="notes">The invoice cannot be repeated until an invoice date has been set.</p>
<?php
}
?>
</fieldset>
<div id="recurrDetails">
<div id="rightSideDiv">
<fieldset>
</legend>
<input id="columnid" name="columnid" type="hidden" value="<?php
echo $thecolumn["id"];
?>
" />
<input id="displayorder" name="displayorder" type="hidden" value="<?php
if ($action == "add column") {
echo $topdisplayorder + 1;
} else {
echo $thecolumn["displayorder"];
}
?>
" />
<p><?php
$theform->showField("name");
?>
</p>
<p>
<label for="column">field</label><br />
<textarea id="column" name="column" cols="64" rows="2"><?php
echo $thecolumn["column"];
?>
</textarea><br />
<span class="notes">This can be a simple SQL field name (e.g notes.title) or a complex SQL field clause (e.g. concat(clients.firstname," ",clients.lastname)</span>
</p>
<p><?php
$theform->showField("roleid");
?>
<input name="gotoinvoice" id="gotoinvoice" type="button" value="return to order" onclick="location.href='<?php
echo getAddEditFile($db, "tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883");
?>
?id=<?php
echo $_GET["invoiceid"];
?>
'" class="Buttons" />
</p>
<?php
}
?>
<fieldset>
<legend>attributes</legend>
<p><?php
$theform->showField("type");
?>
</p>
<p><?php
$theform->showField("inactive");
?>
</p>
<p id="becameclientDiv" <?php
if ($therecord["type"] == "prospect") {
echo "style=\"display:none;\"";
}
?>
>
<label for="becameclient">became a client</label><br />
-->
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p>
<label for="id">id</label><br />
<input name="id" id="id" type="text" value="<?php
echo $therecord["id"];
?>
" size="5" maxlength="5" readonly="readonly" class="uneditable" />
</p>
<p><?php
$theform->showField("inactive");
?>
</p>
</fieldset>
<div id="nameDiv">
<fieldset >
<legend>name / percentage</legend>
<p><?php
$theform->showField("name");
?>
</p>
<p><?php
$theform->showField("percentage");
function showDialog()
{
include_once "include/fields.php";
global $phpbms;
$db =& $this->db;
$phpbms->cssIncludes[] = "pages/aging.css";
$phpbms->jsIncludes[] = "modules/bms/javascript/aritem_aging.js";
$phpbms->showMenu = false;
$formSubmit = str_replace("&", "&", $_SERVER['REQUEST_URI']);
$theform = new phpbmsForm();
$theinput = new inputDatePicker("agingdate", dateToString(mktime(0, 0, 0), "SQL"), "aging date", true);
$theform->addField($theinput);
$theform->jsMerge();
include "header.php";
?>
<div class="bodyline" id="dialog">
<h1><span>AR Aging</span></h1>
<form action="<?php
echo $formSubmit;
?>
" id="record" method="post">
<fieldset>
<legend>options</legend>
<p><?php
$theform->showField("agingdate");
?>
</p>
</fieldset>
<fieldset>
<legend>Current Items Needing Aging</legend>
<?php
$this->_showNeedingAgingTotals();
?>
</fieldset>
<fieldset>
<legend>Report Options</legend>
<p>
<input type="checkbox" value="1" id="printStatements" name="printStatements" class="radiochecks"/>
<label for="printStatements">Print client statements for clients with open items.</label>
</p>
<p>
<input type="checkbox" value="1" id="printSummary" name="printSummary" class="radiochecks"/>
<label for="printSummary">Print a statement summary.</label>
</p>
</fieldset>
<p class="notes">
Aging should be run in a consistent timeframe. Although
running again will not result in duplicate service charges
for an invoice in the same aging period, not running
the aging on the same specified date may result in client
statements showing the service charges too early or too late.
</p>
<p align="right">
<input type="hidden" name="command" id="command" />
<button type="button" class="Buttons" id="runButton">run aging</button>
<button type="button" class="Buttons" id="cancelButton">cancel</button>
</p>
</form>
</div>
<?php
include "footer.php";
}
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><br /><?php
$theform->showField("inactive");
?>
</p>
<p><?php
$theform->showField("priority");
?>
</p>
<p class="notes">
Lower priority numbered items are displayed first.
</p>
</fieldset>
<div id="nameDiv">
<fieldset >
<div id="topButtons"><?php
showSaveCancel(1);
?>
</div>
<h1 id="topTitle"><?php
echo $pageTitle;
?>
</h1>
<div id="rightsideDiv">
<fieldset>
<legend>attributes</legend>
<p><?php
$theform->showField("inactive");
?>
</p>
<p>
<label for="categoryid">master category</label><br />
<?php
$thetable->displayProductCategories($therecord["categoryid"]);
?>
</p>
<p><?php
$theform->showField("type");
?>
</p>
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><?php
$theform->showField("inactive");
?>
</p>
<p><?php
$thetable->showParentsSelect($therecord["uuid"], $therecord["parentid"]);
?>
</p>
<p><?php
$theform->showField("displayorder");
?>
</p>
</fieldset>
$theform->jsMerge();
//==============================================================
//End Form Elements
$pageTitle = "Smart Search";
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<div id="rightSideDiv">
<fieldset>
<legend>attributes</legend>
<p><?php
$theform->showField("moduleid");
?>
</p>
<p><?php
$theform->showField("tabledefid");
?>
</p>
</fieldset>
</div>
<div id="leftSideDiv">
<fieldset>
<legend><label for="name">name</label></legend>
<p class="big"><?php
$theform->showField("name");
//==============================================================
//End Form Elements
$phpbms->bottomJS[] = "showTypeDetails();";
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p>
<?php
$theform->showField("displayorder");
?>
<br />
<span class="notes">Lower numbers are displayed first.</span>
</p>
<p><?php
$theform->showField("roleid");
?>
</p>
</fieldset>
<div id="leftSideDiv">
<fieldset>
<legend><label for="name">name</label></legend>
$thetable->getCustomFieldInfo();
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>Attributes</legend>
<p><?php
$theform->showField("type");
?>
</p>
<p>
<label for="tabledefid">report table</label><br />
<?php
$thetable->displayTables("tabledefid", $therecord["tabledefid"]);
?>
<br />
</p>
<p>
<?php
$theform->showField("displayorder");
?>
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<div id="fsAttributes">
<fieldset>
<legend>attributes</legend>
<p>
<?php
$theform->showField("inactive");
?>
</p>
</fieldset>
<fieldset>
<legend>statistics</legend>
<p>
<strong>Orders</strong> (<?php
echo $stats["Order"]["total"];
?>
)<br/>
total: <?php
echo numberToCurrency($stats["Order"]["sum"]);
?>
</p>
<?php
if (isset($therecord["addressid"])) {
?>
<p>
<input type="hidden" name="addressid" id="addressid" value="<?php
echo $therecord["addressid"];
?>
" />
<input type="hidden" name="tabledefid" id="tabledefid" value="<?php
echo $therecord["tabledefid"];
?>
" />
<?php
$theform->showField("table");
?>
</p>
<p>
<?php
$theform->showField("recordid");
?>
</p>
<?php
}
//endif - addressid
?>
<?php
function displayOptions()
{
global $phpbms;
$db =& $this->db;
require "include/fields.php";
$pageTitle = "Product Sales History";
$phpbms->cssIncludes[] = "pages/historyreports.css";
$phpbms->showMenu = false;
//Form Elements
//==============================================================
$theform = new phpbmsForm();
$thedate = dateToString(mktime(0, 0, 0, date("m"), 1), "SQL");
$theinput = new inputDatePicker("fromdate", $thedate, "from", true);
$theform->addField($theinput);
$thedate = dateToString(mktime(0, 0, 0, date("m") + 1, 0, date("Y")), "SQL");
$theinput = new inputDatePicker("todate", $thedate, "to", true);
$theform->addField($theinput);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<form action="<?php
echo htmlentities($_SERVER["REQUEST_URI"]);
?>
" method="post" name="totals" onsubmit="return validateForm(this)">
<div class="bodyline" id="reportOptions">
<h1 id="topTitle"><span>Product Sales History Options</span></h1>
<fieldset>
<legend>time frame</legend>
<p id="fromP"><?php
$theform->showField("fromdate");
?>
</p>
<p><?php
$theform->showField("todate");
?>
</p>
</fieldset>
<p>
<label for="status">include products from...<br /></label>
<select id="status" name="status">
<option value="Orders and Invoices" selected="selected">Orders and Invoices</option>
<option value="Invoices">Invoices</option>
<option value="Orders">Orders</option>
</select>
</p>
<div align="right">
<input name="command" type="submit" class="Buttons" id="print" value="print" />
<input name="cancel" type="button" class="Buttons" id="cancel" value="cancel" onclick="window.close();" />
</div>
</div>
</form>
<?php
include "footer.php";
}
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsTop">
<legend>Attributes</legend>
<p>
<?php
$theform->showField("thetype");
?>
<input type="hidden" id="typeCheck" name="typeCheck" value="<?php
echo $therecord["type"];
?>
" />
</p>
<p class="big"><?php
$theform->showField("subject");
?>
</p>
</fieldset>
<div id="rightSideDiv">
<fieldset>
$phpbms->topJS[] = "requiredArray[requiredArray.length]=new Array('querytable','Search/Display SQL FROM clause cannot be blank.');";
$phpbms->topJS[] = "requiredArray[requiredArray.length]=new Array('defaultwhereclause','default search cannot be blank.');";
$phpbms->topJS[] = "requiredArray[requiredArray.length]=new Array('defaultsortorder','default sort order cannot be blank.');";
include "header.php";
$phpbms->showTabs("tabledefs entry", "tab:fdf064e0-f2d9-6c67-b64f-449e72e859b9", $therecord["id"]);
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><?php
$theform->showField("type");
?>
</p>
<p><?php
$theform->showField("moduleid");
?>
</p>
<p>
<label for="deletebutton">delete record display name</label><br />
<input id="deletebutton" name="deletebutton" type="text" value="<?php
echo htmlQuotes($therecord["deletebutton"]);
?>
" size="20" maxlength="20" /><br />
</p>
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><?php
$theform->showField("inactive");
?>
</p>
</fieldset>
<div id="leftSideDiv">
<fieldset>
<legend>name</legend>
<p class="big"><?php
$theform->showField("name");
?>
</p>
</fieldset>
<fieldset>
$theinput->setAttribute("onchange", "checkScript(this);");
$theform->addField($theinput);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><br/><?php
$theform->showField("inactive");
?>
</p>
<p><?php
$theform->showField("priority");
?>
</p>
<p class="notes">
Lower priority numbered items are displayed first.
</p>
</fieldset>
<div id="nameDiv">
<fieldset >
<legend>name</legend>
?>
" />
<input type="hidden" id="clientEdit" value="<?php
echo getAddEditFile($db, "tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083");
?>
" />
<input type="hidden" id="clientid" value="<?php
echo $clientInfo["id"];
?>
" />
<div id="rightSideDiv">
<fieldset id="fsAttributes">
<legend>attributes</legend>
<p><?php
$theform->showField("theid");
?>
</p>
<p><?php
$theform->showField("status");
?>
</p>
<p><?php
$theform->showField("posted");
?>
</p>
</fieldset>
</div>
echo htmlentities($_SERVER["PHP_SELF"]) . "?id=" . $_GET["id"];
?>
" method="post" name="record" onsubmit="return validateForm(this);">
<fieldset>
<legend><?php
echo $action;
?>
</legend>
<input id="id" name="id" type="hidden" value="<?php
echo $therecord["id"];
?>
" />
<p>
<?php
$theform->showField("field");
?>
<br />
<span class="notes">This can be a simple SQL field name (e.g notes.title) or a complex SQL field clause (e.g. concat(clients.firstname," ",clients.lastname)</span>
</p>
<p><?php
$theform->showField("name");
?>
</p>
<p><?php
$theform->showField("roleid");
?>
</p>
$thetable->getCustomFieldInfo();
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<?php
$theform->startForm($pageTitle);
?>
<fieldset id="fsAttributes">
<legend>Attributes</legend>
<p id="roleidP"><?php
$theform->showField("roleid");
?>
</p>
<p><?php
$theform->showField("type");
?>
</p>
</fieldset>
<div id="leftSideDiv">
<fieldset>
<legend>file</legend>
<?php
if (isset($_GET["tabledefid"])) {
<legend><?php
echo $title;
?>
</legend>
<input type="hidden" id="command" name="command" value="<?php
echo $command;
?>
"/>
<input id="id" name="id" type="hidden" value="<?php
echo $therecord["id"];
?>
" />
<p><?php
$theform->showField("type");
?>
</p>
<div id="ifDiv">
<p class="notes">
Integrated features allow you to set and access to
main buttons on the table definitions search screen.
</p>
<p><?php
$theform->showField("ifName");
?>
</p>
