} elseif (isset($_GET['StockID'])) {
$StockID = trim(mb_strtoupper($_GET['StockID']));
}
echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/inventory.png" title="' . _('Inventory') . '" alt="" />' . ' ' . $title . '</p>';
if (isset($_POST['Search'])) {
search($db, $StockID);
} elseif (isset($_POST['submit'])) {
submit($db, $StockID, $DemandID);
} elseif (isset($_GET['delete'])) {
delete($db, $DemandID, '', $StockID);
} elseif (isset($_POST['deletesome'])) {
delete($db, '', $_POST['MRPDemandtype'], $StockID);
} elseif (isset($_GET['listall'])) {
listall($db, '', '');
} elseif (isset($_POST['listsome'])) {
listall($db, $StockID, $_POST['MRPDemandtype']);
} else {
display($db, $StockID, $DemandID);
}
function search(&$db, &$StockID)
{
//####SEARCH_SEARCH_SEARCH_SEARCH_SEARCH_SEARCH_SEARCH_#####
// Search by partial part number or description. Display the part number and description from
// the stockmaster so user can select one. If the user clicks on a part number
// MRPDemands.php is called again, and it goes to the display() routine.
// Work around to auto select
if ($_POST['Keywords'] == '' and $_POST['StockCode'] == '') {
$_POST['StockCode'] = '%';
}
if ($_POST['Keywords'] and $_POST['StockCode']) {
$msg = _('Stock description keywords have been used in preference to the Stock code extract entered');
$title = _('MRP Calendar');
include 'includes/header.inc';
if (isset($_POST['ChangeDate'])) {
$ChangeDate = trim(mb_strtoupper($_POST['ChangeDate']));
} elseif (isset($_GET['ChangeDate'])) {
$ChangeDate = trim(mb_strtoupper($_GET['ChangeDate']));
}
echo '<p class="page_title_text">
<img src="' . $rootpath . '/css/' . $theme . '/images/inventory.png" title="' . _('Inventory') . '" alt="" />' . ' ' . $title . '
</p>';
if (isset($_POST['submit'])) {
submit($db, $ChangeDate);
} elseif (isset($_POST['update'])) {
update($db, $ChangeDate);
} elseif (isset($_POST['listall'])) {
listall($db);
} else {
display($db, $ChangeDate);
}
function submit(&$db, &$ChangeDate)
{
//initialize no input errors
$InputError = 0;
/* actions to take once the user has clicked the submit button
ie the page has called itself with some user input */
//first off validate inputs sensible
if (!Is_Date($_POST['FromDate'])) {
$InputError = 1;
prnMsg(_('Invalid From Date'), 'error');
}
if (!Is_Date($_POST['ToDate'])) {
}
if ($dcount == "") {
$dcount = 0;
}
echo "<br><div align=center>{$pubcount} " . _PUBLICENTRIES . " - " . "{$prvcount} " . _PRIVATEENTRIES . " - " . "{$dcount} " . _TOTALENTRIES . "</div>";
closeTable();
}
if (!isset($disp)) {
$disp = "";
}
switch ($disp) {
case "last":
list20($username, $bgcolor1, $bgcolor2, $bgcolor3);
break;
case "all":
listall($username, $bgcolor1, $bgcolor2, $bgcolor3, $sitename);
break;
default:
list20($username, $bgcolor1, $bgcolor2, $bgcolor3);
break;
}
journalfoot();
} else {
$pagetitle = "- " . _YOUMUSTBEMEMBER . "";
$pagetitle = filter($pagetitle, "nohtml");
OpenTable();
echo "<center><b>" . _YOUMUSTBEMEMBER . "</b></center>";
CloseTable();
include "footer.php";
die;
}
#
#The full software license can be found here:
#http://www.accounting-123.com/a.php?a=153/GPLv3
#
#
#
#
#
#
#
#
#
#
#
require "settings.php";
$OUTPUT = listall();
$OUTPUT .= "<p>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Quick Links</th></tr>\r\n\t<tr class='bg-even'><td align=center><a href='index.php'>My Business</a></td></tr>\r\n\t<tr class='bg-odd'><td align=center><a href='../main.php'>Main Menu</a></td></tr>\r\n\t</table>";
require "template.php";
function listall()
{
$i = 0;
db_conn('crm');
$Sl = "SELECT * FROM pokens ORDER BY id";
$Ry = db_exec($Sl) or errDie("Unable to get unallocated queries from system.");
if (pg_numrows($Ry) < 1) {
return "There are no unallocated queries.";
}
$out = "<h3>Unallocated Queries</h3>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Subject</th><th>Body</th><th>Date</th><th>Time</th><th>Options</th></tr>";
while ($pdata = pg_fetch_array($Ry)) {
$i++;
$out .= "<tr class='" . bg_class() . "'><td>{$pdata['sub']}</td><td><pre>{$pdata['notes']}</pre></td><td>{$pdata['rdate']}</td>\r\n\t\t<td>" . substr($pdata['rtime'], 0, 5) . "</td><td><a href='tokens-allocate.php?id={$pdata['id']}'>Allocate</a></td></tr>";
listall($my_findstr);
break;
case 'search':
listall($my_findstr, $my_findpass);
break;
case 'nossi':
_listnossi();
break;
case 'edit':
echo setPageTitle('Spieler Eintrag Bearbeiten');
_edit($player_id);
break;
case "save":
_insupdplayer($player_id, $last_name);
if ($usertoken['usertype_id'] != 0) {
listall($last_name);
} else {
echo 'Data edited successfuly.';
}
break;
case 'updatesip':
_InsUpd_SSIVAL($vsid, $vssipoints);
echo setPageTitle('UPDATE DONE');
break;
case 'new':
echo setPageTitle('Spieler Eintrag NEU');
_newplayer();
break;
case 'delete':
echo dso_delplayer($player_id);
break;
echo "<br />";
if ($op == "addnew") {
addnew($add_new_from);
} elseif ($op == "search") {
ob_end_flush();
search();
} elseif ($op == "view") {
ob_end_flush();
view();
} elseif ($op == "delete") {
del();
} elseif ($op == "edit") {
edit();
} else {
ob_end_flush();
listall();
}
include XOOPS_ROOT_PATH . "/footer.php";
function listall()
{
global $xoopsDB, $xoopsUser, $userid, $cb_index, $email_send;
OpenTable();
$countlimit = 20;
$query = "select * FROM " . $xoopsDB->prefix('webmail_contactbook') . " where uid = {$userid} order by firstname";
if (!($result = $xoopsDB->query($query))) {
echo "ERROR";
}
$res = $xoopsDB->query($query);
echo "<form name=\"listform\" method=\"post\" action='contactbook.php'>\n\t<input type=\"hidden\" name=\"op\" value=\"delete\">\n\t<table width=\"100%\" align=\"center\" border=\"0\"><tr class='bg2' bgcolor=\"{$bgcolor2}\"><td width=\"3%\" align=\"center\"><b>" . _MD_WEBMAIL_VIEW . "</b></td><td width=\"3%\" align=\"center\"><b>" . _MD_WEBMAIL_EDIT . "</b></td><td width=\"3%\"> </td><td width=\"28%\"><b>" . _MD_WEBMAIL_NAME . "</b></td><td width=\"30%\"><b>" . _MD_WEBMAIL_EMAIL . "</b></td><td width=\"15%\"><b>" . _MD_WEBMAIL_PHONERES . "</b></td><td width=\"15%\"><b>" . _MD_WEBMAIL_PHONEWORK . "</b></td></tr>";
$numrows = $xoopsDB->getRowsNum($res);
if ($numrows == 0) {
