function write($_POST) { # Get vars global $DOCLIB_DOCTYPES; foreach ($_POST as $key => $value) { ${$key} = $value; } # Validate input require_lib("validate"); $v = new validate(); $v->isOk($docid, "string", 1, 20, "Invalid document number."); # Display errors, if any if ($v->isError()) { $confirmCust = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirmCust .= "<li class=err>" . $e["msg"]; } $confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>"; return $confirmCust; } # Connect to db db_conn("cubit"); $docRs = get("cubit", "*", "documents", "docid", $docid); $doc = pg_feTch_array($docRs); # Write to db $sql = "DELETE FROM documents WHERE docid = '{$docid}' AND div = '" . USER_DIV . "'"; $docRslt = db_exec($sql) or errDie("Unable to remove {$doc['docname']} from system.", SELF); if (pg_cmdtuples($docRslt) < 1) { return "<li class=err>Unable to remove {$doc['docname']} from Cubit."; } /* //new db_conn('cubit'); */ # write to db $Sql = "INSERT INTO document(typeid,typename,xin,docref,docdate,docname,filename,mimetype,descrip,docu,div) VALUES ('{$doc['typeid']}', '{$doc['typename']}', '{$doc['xin']}', '{$doc['docref']}', '{$doc['docdate']}', '{$doc['docname']}', '{$doc['filename']}', '{$doc['mimetype']}', '{$doc['descrip']}', '{$doc['docu']}', '" . USER_DIV . "')"; $Rslt = db_exec($Sql) or errDie("Unable to access database."); $write = "<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\r\n\t\t<tr><th>Document removed</th></tr>\r\n\t\t<tr class=datacell><td>Document <b>{$doc['docname']}</b>, has been successfully removed from the system.</td></tr>\r\n\t</table>\r\n\t<p>\r\n\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t\t<tr><th>Quick Links</th></tr>\r\n\t\t<tr class='bg-odd'><td><a href='tdocadd.php'>Add Document</a></td></tr>\r\n\t\t<tr class='bg-odd'><td><a href='tdocview.php'>View Documents</a></td></tr>\r\n\t\t<tr class='bg-odd'><td><a href='../main.php'>Main Menu</a></td></tr>\r\n\t</table>"; return $write; }
function write($_POST) { # Get vars foreach ($_POST as $key => $value) { ${$key} = $value; } # Validate input require_lib("validate"); $v = new validate(); $v->isOk($typeid, "string", 1, 20, "Invalid document type number."); # Display errors, if any if ($v->isError()) { $confirmCust = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirmCust .= "<li class=err>" . $e["msg"]; } $confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>"; return $confirmCust; } $doctRs = get("yr2", "*", "doctypes", "typeid", $typeid); $doct = pg_feTch_array($doctRs); # Write to db db_conn("yr2"); $sql = "DELETE FROM doctypes WHERE typeid = '{$typeid}'"; $dRslt = db_exec($sql) or errDie("Unable to remove {$doct['typename']} to system.", SELF); $write = "<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\r\n\t<tr><th>Document type removed</th></tr>\r\n\t<tr class=datacell><td>Document type <b>{$doct['typename']}</b>, has been successfully removed from the system.</td></tr>\r\n\t</table>\r\n\t<p>\r\n\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t\t<tr><th>Quick Links</th></tr>\r\n\t\t<tr class='bg-odd'><td><a href='doctype-view.php'>View Document types</a></td></tr>\r\n\t\t<tr class='bg-odd'><td><a href='../main.php'>Main Menu</a></td></tr>\r\n\t</table>"; return $write; }
function edit($VARS = array(), $errors = "") { # Get vars global $DOCLIB_DOCTYPES; foreach ($VARS as $key => $value) { ${$key} = $value; } # Validate input require_lib("validate"); $v = new validate(); $v->isOk($docid, "string", 1, 20, "Invalid document number."); # Display errors, if any if ($v->isError()) { $confirmCust = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirmCust .= "<li class=err>" . $e["msg"]; } $confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>"; return $confirmCust; } if (!isset($typeid)) { $docRs = get("yr2", "*", "documents", "docid", $docid); $doc = pg_feTch_array($docRs); $xin = $doc['xin']; $typeid = $doc['typeid']; $docname = $doc['docname']; $docref = $doc['docref']; list($year, $mon, $day) = explode("-", $doc['docdate']); $descrip = $doc['descrip']; } # Extra in $xin = isset($xin) ? $xin : ""; $xins = $xin; $xin = xin_gw($typeid, $xin); # Select Type db_conn("yr2"); $typs = "<select name='typeid' onchange='document.form1.submit();'>"; # User types $sql = "SELECT * FROM doctypes WHERE div = '" . USER_DIV . "' ORDER BY typename ASC"; $typRslt = db_exec($sql); if (pg_numrows($typRslt) < 1) { if (preg_match("/\\d/", $typeid)) { $typeid = 'inv'; } $xin = xin_gw($typeid, $xins); } else { while ($typ = pg_fetch_array($typRslt)) { $sel = ""; if ($typ['typeid'] == $typeid) { $sel = "selected"; } $typs .= "<option value='{$typ['typeid']}' {$sel}>({$typ['typeref']}) {$typ['typename']}</option>"; } } # Built-in types foreach ($DOCLIB_DOCTYPES as $tkey => $val) { $sel = ""; if ($tkey == $typeid) { $sel = "selected"; } $typs .= "<option value='{$tkey}' {$sel}>{$DOCLIB_DOCTYPES[$tkey]}</option>"; } $typs .= "</select>"; $enter = "<h3>Edit Document</h3>\r\n\t<form name=form1 action='" . SELF . "' method=post>\r\n\t<table cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<input type=hidden name=key value=confirm>\r\n\t<input type=hidden name=docid value='{$docid}'>\r\n\t<tr><td colspan=2>{$errors}</td></tr>\r\n\t<tr><th>Field</th><th>Value</th></tr>\r\n\t<tr class='even'><td>Type</td><td>{$typs}</td></tr>\r\n\t{$xin}\r\n\t<tr class='odd'><td>Ref</td><td><input type=text size=10 name=docref value='{$docref}'></td></tr>\r\n\t<tr class='even'><td>Document Name</td><td><input type=text size=20 name=docname value='{$docname}'></td></tr>\r\n\t<tr class='odd'><td>Date</td><td><input type=text size=2 name=day maxlength=2 value='{$day}'>-<input type=text size=2 name=mon maxlength=2 value='{$mon}'>-<input type=text size=4 name=year maxlength=4 value='{$year}'></td></tr>\r\n\t<tr class='even'><td>Decription</td><td><textarea name=descrip rows=4 cols=18>{$descrip}</textarea></td></tr>\r\n\t<tr><td><br></td></tr>\r\n\t<tr><td colspan=2 align=right><input type=submit name=conf value='Confirm »'></td></tr>\r\n\t</table></form>"; return $enter; }
function write($_POST) { # Get vars global $DOCLIB_DOCTYPES; foreach ($_POST as $key => $value) { ${$key} = $value; } # Validate input require_lib("validate"); $v = new validate(); $v->isOk($docid, "string", 1, 20, "Invalid document number."); # Display errors, if any if ($v->isError()) { $confirmCust = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirmCust .= "<li class=err>" . $e["msg"]; } $confirmCust .= "<p><input type=button onClick='JavaScript:history.back();' value='« Correct submission'>"; return $confirmCust; } # Connect to db db_conn("yr2"); $docRs = get("yr2", "*", "documents", "docid", $docid); $doc = pg_feTch_array($docRs); # Connect to db db_conn("yr2"); # Write to db $sql = "DELETE FROM documents WHERE docid = '{$docid}' AND div = '" . USER_DIV . "'"; $docRslt = db_exec($sql) or errDie("Unable to remove {$doc['docname']} from system.", SELF); if (pg_cmdtuples($docRslt) < 1) { return "<li class=err>Unable to remove {$doc['docname']} from Cubit."; } $write = "<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "' width='50%'>\r\n\t\t<tr><th>Document removed</th></tr>\r\n\t\t<tr class=datacell><td>Document <b>{$doc['docname']}</b>, has been successfully removed from the system.</td></tr>\r\n\t</table>"; return $write; }