$queryresult = $db->query($querystatement);
return $queryresult;
}
$phpbms->cssIncludes[] = "pages/files.css";
$phpbms->jsIncludes[] = "modules/base/javascript/file.js";
//Form Elements
//==============================================================
$theform = new phpbmsForm();
$theform->enctype = "multipart/form-data";
if (isset($therecord["id"])) {
$theinput = new inputField("name", $therecord["name"], NULL, true, NULL, 64, 128);
$theinput->setAttribute("class", "important");
$theform->addField($theinput);
}
$theinput = new inputField("type", $therecord["type"], "file type", false, null, 25);
$theinput->setAttribute("readonly", "readonly");
$theinput->setAttribute("class", "uneditable");
$theform->addField($theinput);
$theinput = new inputRolesList($db, "roleid", $therecord["roleid"], "access (role)");
$theform->addField($theinput);
if (isset($_GET["tabledefid"]) && !isset($therecord["id"])) {
$theinput = new inputSmartSearch($db, "fileid", "Pick File", "", "exisiting file", false, 40);
$theform->addField($theinput);
}
//end if
$thetable->getCustomFieldInfo();
$theform->prepCustomFields($db, $thetable->customFieldsQueryResult, $therecord);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
$therecord = $thetable->processAddEditPage();
if (isset($therecord["phpbmsStatus"])) {
$statusmessage = $therecord["phpbmsStatus"];
}
$pageTitle = "Scheduler";
$currentpath = getcwd();
$phpbms->cssIncludes[] = "pages/scheduler.css";
$phpbms->jsIncludes[] = "modules/base/javascript/scheduler.js";
//Form Elements
//==============================================================
$theform = new phpbmsForm();
$theform->id = $theform->name;
$theinput = new inputCheckbox("inactive", $therecord["inactive"]);
$theform->addField($theinput);
$theinput = new inputField("name", $therecord["name"], NULL, true, NULL, 32, 64);
$theinput->setAttribute("class", "important");
$theform->addField($theinput);
if (moduleExists("mod:b2d42220-443b-fe74-dbdb-ed2c0968c38c", $phpbms->modules)) {
$list = array("file" => "job", "push record" => "pushrecord");
$theinput = new inputBasicList("scripttype", $therecord["scripttype"], $list, "script type");
$theform->addField($theinput);
$theinput = new inputSmartSearch($db, "pushrecordid", "Pick Push Record For Cron", $therecord["pushrecordid"]);
$theform->addField($theinput);
}
//end if
$theinput = new inputField("job", $therecord["job"], "script", false, NULL, 32, 128, false);
$theform->addField($theinput);
$theinput = new inputDatePicker("startdate", $therecord["startdate"], "start date", true, 11, 15, false);
$theform->addField($theinput);
$theinput = new inputTimePicker("starttime", $therecord["starttime"], "start time", true, 11, 15, false);
$theform->addField($theinput);
function getFields($therecord)
{
global $db;
$theinput = new inputField("shipping_markup", $therecord["shipping_markup"], "shipping markup", false, "real", 4, 4);
$fields[] = $theinput;
$theinput = new inputField("shipping_postalcode", $therecord["shipping_postalcode"], "shipping origination zip/postal code", false, NULL, 32, 128);
$fields[] = $theinput;
$theinput = new inputDataTableList($db, "default_payment", $therecord["default_payment"], "paymentmethods", "uuid", "name", "inactive=0 AND (`type` != 'receivable' OR `type` IS NULL)", "priority,name", true, "default payment method", true, "");
$fields[] = $theinput;
$theinput = new inputDataTableList($db, "default_shipping", $therecord["default_shipping"], "shippingmethods", "uuid", "name", "inactive=0", "priority,name", true, "default shipping method", true, "");
$fields[] = $theinput;
$theinput = new inputDataTableList($db, "default_discount", $therecord["default_discount"], "discounts", "uuid", "name", "inactive=0", "name", true, "default discount", true, "");
$fields[] = $theinput;
$theinput = new inputDataTableList($db, "default_taxarea", $therecord["default_taxarea"], "tax", "uuid", "name", "inactive=0", "name", true, "default tax area", true, "");
$fields[] = $theinput;
$theinput = new inputBasicList("default_clienttype", $therecord["default_clienttype"], array("prospect" => "prospect", "client" => "client"), "default type");
$fields[] = $theinput;
$theinput = new inputCheckbox("default_hascredit", $therecord["default_hascredit"], "has credit by default");
$fields[] = $theinput;
$theinput = new inputCurrency("default_creditlimit", $therecord["default_creditlimit"], "default credit limit");
$fields[] = $theinput;
$theinput = new inputField("term1_days", $therecord["term1_days"], "term 1 length", false, "integer", 4, 4);
$theinput->setAttribute("class", "important");
$fields[] = $theinput;
$theinput = new inputField("term1_percentage", $therecord["term1_percentage"], "term 1 percentage", false, "real", 4, 4);
$fields[] = $theinput;
$theinput = new inputField("term2_days", $therecord["term2_days"], "term 2 length", false, "integer", 4, 4);
$theinput->setAttribute("class", "important");
$fields[] = $theinput;
$theinput = new inputField("term2_percentage", $therecord["term2_percentage"], "term 2 percentage", false, "real", 4, 4);
$fields[] = $theinput;
$theinput = new inputField("term3_days", $therecord["term3_days"], "term 3 length", false, "integer", 4, 4);
$theinput->setAttribute("class", "important");
$fields[] = $theinput;
$theinput = new inputField("term3_percentage", $therecord["term3_percentage"], "term 3 percentage", false, "real", 4, 4);
$fields[] = $theinput;
$theinput = new inputCheckbox("prospects_on_orders", $therecord["prospects_on_orders"], "allow prospects on sales orders");
$fields[] = $theinput;
$theinput = new inputCheckbox("encrypt_payment_fields", $therecord["encrypt_payment_fields"], "encrypt/obfuscate payment information");
$fields[] = $theinput;
$theinput = new inputField("encryption_key_path", $therecord["encryption_key_path"], "absolute server path to a file containing the encryption key", false, NULL, 64);
$fields[] = $theinput;
$theinput = new inputCheckbox("show_payment_instructions", $therecord["show_payment_instructions"], "show payment instrucions");
$fields[] = $theinput;
return $fields;
}
function prepCustomFields($db, $queryresult, $therecord)
{
while ($fieldInfo = $db->fetchArray($queryresult)) {
$id = $fieldInfo["field"];
$name = $fieldInfo["name"];
$required = (bool) $fieldInfo["required"];
$format = $fieldInfo["format"] ? $fieldInfo["format"] : null;
$size = "40";
$value = isset($therecord[$id]) ? $therecord[$id] : "";
//need to handle roleid
$disabled = !hasRights($fieldInfo["roleid"]);
//different custom fields (based on number) have different types
switch (substr($id, 6)) {
case 1:
case 2:
if ($value === "") {
$value = 0;
}
if ($format == "currency") {
$theinput = new inputCurrency($id, $value, $name, $required);
} else {
$theinput = new inputField($id, $value, $name, $required, $format, 8, 128);
}
$generator = true;
if ($disabled) {
$theinput->setAttribute("readonly", "readonly");
$theinput->setAttribute("class", "uneditable");
$generator = false;
}
//endif
break;
case 3:
case 4:
if ($disabled) {
$theinput = new inputField($id, $value, $name, $required, null, 10, 15);
$theinput->setAttribute("readonly", "readonly");
$theinput->setAttribute("class", "uneditable");
$generator = false;
} else {
if ($format == "date") {
$theinput = new inputDatePicker($id, $value, $name, $required);
} else {
$value = explode(" ", $value);
$value = count($value) > 1 ? $value[1] : "";
$theinput = new inputTimePicker($id, $value, $name, $required);
}
//endif
$generator = true;
}
//endif
break;
case 5:
case 6:
if ($format == "list" && !$disabled) {
$theinput = new inputChoiceList($db, $id, $value, $id . "-" . $fieldInfo["tabledefid"], $name);
$generator = false;
} else {
$theinput = new inputField($id, $value, $name, $required, $format, 40, 254);
$generator = true;
}
//endif
if ($disabled) {
$theinput->setAttribute("readonly", "readonly");
$theinput->setAttribute("class", "uneditable");
$generator = false;
}
//endif
break;
case 7:
case 8:
$generator = false;
$theinput = new inputCheckbox($id, $value, $name, $disabled);
break;
}
//endswitch
//need to handle creation of onload js for generator, but only if type
// not = checkbox or list.
if ($generator && $fieldInfo["generator"]) {
$this->onload[] = "var " . $id . "Button = getObjectFromID('" . $id . "Button'); connect(" . $id . "Button, 'onclick', function(){var " . $id . " = getObjectFromID('" . $id . "');" . $id . ".value = " . $fieldInfo["generator"] . "})";
}
$this->addField($theinput);
}
//endwile
//rewind the queryresult pointer (if not false)
if ($queryresult) {
$db->seek($queryresult, 0);
}
}
function getFields($therecord)
{
global $db;
$theinput = new inputField("mailchimp_apikey", $therecord["mailchimp_apikey"], "mailchimp apikey", false, NULL, 48);
$fields[] = $theinput;
$theinput = new inputCheckbox("mailchimp_secure", $therecord["mailchimp_secure"], "use ssl connection");
$fields[] = $theinput;
$theinput = new inputField("mailchimp_list_id", $therecord["mailchimp_list_id"], "list id");
$fields[] = $theinput;
$theinput = new inputField("mailchimp_last_sync_date", $therecord["mailchimp_last_sync_date"], "last sync date");
$theinput->setAttribute("class", "uneditable");
$theinput->setAttribute("readonly", "readonly");
$fields[] = $theinput;
return $fields;
}
$theinput->setAttribute("title", "Enter the email address to send site mail from. Will also be used as part of your contact details.");
$theform->addField($theinput);
$theinput = new inputField("sendmail", $_SESSION["userinfo"]["sendmail"], "sendmail path", false, null, 32, 255);
$theinput->setAttribute("title", "Enter the path to the sendmail program directory on the host server. Defaults to: '/usr/sbin/sendmail -bs'");
$theform->addField($theinput);
$theinput = new inputField("smtphost", $_SESSION["userinfo"]["smtphost"], "SMTP host", false, null, 32, 255);
$theinput->setAttribute("title", "Enter the name of the SMTP host. Defaults to: 'localhost'");
$theform->addField($theinput);
$theinput = new inputField("smtpport", $_SESSION["userinfo"]["smtpport"], "SMTP port", false, "integer", 10, 10);
$theinput->setAttribute("title", "Enter the port number of your SMTP server. Use 25 for most unsecure servers and 465 for most secure servers. Defaults to: 25");
$theform->addField($theinput);
$theinput = new inputField("smtpuser", $_SESSION["userinfo"]["smtpuser"], "SMTP username", false, NULL, 32, 255);
$theinput->setAttribute("title", "Enter the username for access to the SMTP host.");
$theform->addField($theinput);
$theinput = new inputField("smtppass", $_SESSION["userinfo"]["smtppass"], "SMTP password", false, "password", 32, 255);
$theinput->setAttribute("title", "Enter the password for the SMTP host.");
$theform->addField($theinput);
$theform->jsMerge();
//==============================================================
//End Form Elements
include "header.php";
?>
<div class="bodyline">
<form action="<?php
echo htmlentities($_SERVER["PHP_SELF"]);
?>
" method="post" name="record" id="record" onsubmit="return false">
<input type="hidden" id="command" name="command" value=""/>
<h1><span><?php
echo $pageTitle;
