require "../settings.php"; require_lib("docman"); # decide what to do if (isset($_POST["key"])) { switch ($_POST["key"]) { case "confirm": $OUTPUT = con_data($_POST); break; case "write": $OUTPUT = write_data($_POST); break; default: $OUTPUT = view_data($_GET); } } else { $OUTPUT = view_data($_GET); } # check department-level access # display output require "../template.php"; # enter new data function view_data($_GET) { # Get vars global $_FILES, $DOCLIB_DOCTYPES; foreach ($_GET as $key => $value) { ${$key} = $value; } # Validate input require_lib("validate"); $v = new validate();
if ($key != 'from_sample_id' && $key != 'to_sample_id') { $other_wheree = $other_wheree . ' ' . $key . ' like \'' . $value . '\' and'; } } $other_where = substr($other_wheree, 0, -3); if (strlen($sample_id_where) > 0 && strlen($other_where) > 0) { $search_str = $search_str . ' where ' . $sample_id_where . ' and ' . $other_where; } elseif (strlen($sample_id_where) > 0 && strlen($other_where) == 0) { $search_str = $search_str . ' where ' . $sample_id_where; } elseif (strlen($sample_id_where) == 0 && strlen($other_where) > 0) { $search_str = $search_str . ' where ' . $other_where; } $printed = array(); if (isset($_POST['submit']) && substr($search_str, -7) != 'sample ') { $link = start_nchsls(); if (!($search_result = mysql_query($search_str, $link))) { echo mysql_error(); } while ($ar = mysql_fetch_assoc($search_result)) { if (get_sample_status($ar['sample_id']) == 'verified') { print_sample($ar['sample_id'], 'eReport, not signed', 'eReport, not signed'); echo '<h2 style="page-break-before: always;"></h2>'; } else { echo '<h2 style="page-break-before: always; color:red; ">Sample ID ' . $ar['sample_id'] . ' is not verified(Call the lab)</h2>'; } } } else { echo '<h1>No coditions are given for selecting records</h1>'; } view_data(15);
function con_data($_POST) { # get vars extract($_POST); if (isset($back)) { return view_data($_POST); } # validate input require_lib("validate"); $v = new validate(); $v->isOk($id, "num", 0, 100, "Invalid number."); $v->isOk($depamt, "float", 0, 14, "Invalid Depreciation Amount."); $v->isOk($depmonths, "num", 0, 3, "Invalid auto depreciation period."); $v->isOk("{$depmonths}{$depamt}", "float", 1, 14, "Enter one of Depreciation amount or period."); if (!empty($depamt) && $netval < $depamt) { $v->isOk("###", "float", 1, 1, "Error : Depreciation amount must not be more than the Net Value."); } else { if (!empty($depmonths) && $depperc <= 0) { $v->addError("###", "Depriaction percentage has to be more than 0 if depreciating by period."); } } $v->isOk($date, "date", 1, 14, "Invalid account open date."); # 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; } db_conn('cubit'); $user = USER_NAME; $Sql = "SELECT * FROM assets WHERE (id='{$id}' AND div = '" . USER_DIV . "')"; $Rslt = db_exec($Sql) or errDie("Unable to access database."); if (pg_numrows($Rslt) < 1) { return "Asset not Found"; } $led = pg_fetch_array($Rslt); # Get group $sql = "SELECT * FROM assetgrp WHERE grpid = '{$led['grpid']}' AND div = '" . USER_DIV . "'"; $grpRslt = db_exec($sql); $grp = pg_fetch_array($grpRslt); # get last ref number $refnum = getrefnum($date); if ($led["dep_acc"]) { $dep_acc = $led["dep_acc"]; } else { // Maintain backwards compatibiltiy $sql = "\r\n\t\tSELECT accid FROM core.accounts\r\n\t\tWHERE topacc='2200' AND accnum='000'"; $acc_rslt = db_exec($sql) or errDie("Unable to retrieve account."); $dep_acc = pg_fetch_result($acc_rslt, 0); } if ($led["accdep_acc"]) { $accdep_acc = $led["accdep_acc"]; } else { // Maintain backwards compatibiltiy $accdep_acc = $grp["accdacc"]; } pglib_transaction("BEGIN"); # dt(depacc) ct(accdep) writetrans($dep_acc, $accdep_acc, $date, $refnum, $depamt, "{$led['des']} Depreciation"); db_connect(); $sql = "UPDATE assets SET accdep = (accdep + '{$depamt}') WHERE (id='{$id}' AND div = '" . USER_DIV . "')"; $up = db_exec($sql) or errdie("Could not update assets table."); $snetval = $netval - $depamt; $sdate = date("Y-m-d"); $sql = "INSERT INTO assetledger(assetid, asset, date, depamt, netval, div) \r\n\t\t\tVALUES ('{$id}', '{$led['des']}', '{$date}', '{$depamt}', '{$snetval}', '" . USER_DIV . "')"; $rec = db_exec($sql) or errdie("Could not write to asset ledger."); $cc = "<script> CostCenter('ct', 'Asset Depreciation', '{$date}', '{$led['des']} Depreciation', '{$depamt}', ''); </script>"; pglib_transaction("COMMIT"); $write = "\r\n\t\t\t\t{$cc}\r\n\t\t\t\t<table " . TMPL_tblDflts . " width='50%'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Asset Depreciation</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='datacell'>\r\n\t\t\t\t\t\t<td>Asset Depreciation has been recorded</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t\t<p>\r\n\t\t\t\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Quick Links</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='asset-new.php'>New Asset</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='asset-view.php'>View Assets</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\r\n\t\t\t\t</table>"; return $write; }
} } } } } //$sql = "SELECT reagent_name,reagent_status,sum(`pack_size`) FROM `reagent`group by reagent_name,reagent_status LIMIT 0, 30 "; //SELECT reagent_name,reagent_status,sum(`pack_size`) FROM `reagent`group by reagent_name,reagent_status main_menu(); save_reagent($_POST); delete_reagent($_POST); save_inserted($_POST); group_save($_POST); if (isset($_POST['submit'])) { if ($_POST['submit'] == 'edit') { edit_form($_POST['id']); } } show_reagent($_POST); echo '<table><tr><td>'; search_form(); echo '</td><td>'; group_edit(); echo '</td><tr><td colspan=2>'; insert_reagent(); echo '</td></tr>'; view_data(17); /* echo '<pre>'; print_r($GLOBALS); echo '</pre>'; */
$first_data='no'; } foreach($array as $key=>$value) { if($key=='id') { echo '<td><input type=submit name=id value=\''.$value.'\'></td>'; } else { echo '<td>'.$value.'</td>'; } } echo '</tr>'; } echo '</table>'; echo '</form>'; } echo '<h2 style="page-break-before: always;"></h2>'; if(isset($_POST['id'])) { view_data($_POST['id']); } get_sql(); ?>
function con_data($_POST) { # get vars extract($_POST); if (isset($back)) { return view_data($_POST); } # validate input require_lib("validate"); $v = new validate(); $v->isOk($id, "num", 0, 100, "Invalid number."); $v->isOk($depamt, "float", 1, 14, "Invalid Depreciation Amount."); if ($netval < $depamt) { $v->isOk("###", "float", 1, 1, "Error : Depreciation amount must not be more than the Net Value."); } $v->isOk($date, "date", 1, 14, "Invalid account open date."); # display errors, if any if ($v->isError()) { $confirmCust = ""; $errors = $v->getErrors(); foreach ($errors as $e) { $confirmCust .= "<li class='err'>" . $e["msg"] . "</li>"; } $confirmCust .= "<p><input type='button' onClick='JavaScript:history.back();' value='« Correct submission'>"; return $confirmCust; } db_conn('cubit'); $user = USER_NAME; $Sql = "SELECT * FROM assets WHERE (id='{$id}' AND div = '" . USER_DIV . "')"; $Rslt = db_exec($Sql) or errDie("Unable to access database."); if (pg_numrows($Rslt) < 1) { return "Asset not Found"; } $led = pg_fetch_array($Rslt); # Get group $sql = "SELECT * FROM assetgrp WHERE grpid = '{$led['grpid']}' AND div = '" . USER_DIV . "'"; $grpRslt = db_exec($sql); $grp = pg_fetch_array($grpRslt); # get last ref number $refnum = getrefnum($date); if ($led["dep_acc"]) { $dep_acc = $led["dep_acc"]; } else { // Maintain backwards compatibiltiy $dep_acc = $grp["depacc"]; } if ($led["accdep_acc"]) { $accdep_acc = $led["accdep_acc"]; } else { // Maintain backwards compatibiltiy $accdep_acc = $grp["accdacc"]; } # dt(depacc) ct(accdep) writetrans($accdep_acc, $dep_acc, $date, $refnum, $depamt, "{$led['des']} Appreciation"); db_connect(); $sql = "UPDATE assets SET accdep = (accdep - '{$depamt}') WHERE (id='{$id}' AND div = '" . USER_DIV . "')"; $up = db_exec($sql) or errdie("Could not update assets table."); $snetval = $netval + $depamt; $sdate = date("Y-m-d"); $sql = "INSERT INTO assetledger(assetid, asset, date, depamt, netval, div) VALUES ('{$id}', '{$led['des']}', '{$sdate}', '-{$depamt}', '{$snetval}', '" . USER_DIV . "')"; $rec = db_exec($sql) or errdie("Could not write to asset ledger."); #resort date $cdarr = explode("-", $date); $cyear = $cdarr[2]; $cmonth = $cdarr[1]; $cday = $cdarr[0]; $cdate = "{$cyear}-{$cmonth}-{$cday}"; $cc = "<script> CostCenter('dt', 'Asset Appreciation', '{$cdate}', '{$led['des']} Appreciation', '{$depamt}', ''); </script>"; $write = "\r\n\t\t\t\t{$cc}\r\n\t\t\t\t<table " . TMPL_tblDflts . " width='50%'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Asset Appreciation</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='datacell'>\r\n\t\t\t\t\t\t<td>Asset Appreciation has been recorded</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t\t<p>\r\n\t\t\t\t<table border=0 cellpadding='2' cellspacing='1'>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th>Quick Links</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='asset-new.php'>New Asset</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr class='" . bg_class() . "'>\r\n\t\t\t\t\t\t<td><a href='asset-view.php'>View Assets</a></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<script>document.write(getQuicklinkSpecial());</script>\r\n\t\t\t\t</table>"; return $write; }
echo 'layer=mapnik&marker=' . $lat . '%2C' . $lng . '" style="border: 1px solid black"></iframe>'; echo '<br/><small><a href="http://www.openstreetmap.org/?mlat=' . $lat . '&mlon=' . $lng . '#map=15/' . $lat . '/' . $lng . '" target="_blank">'; echo '大きな地図を表示</a></small>'; echo '</div>'; } echo '<div>' . "\n"; echo '<h2>ENDPOINT : <a href=' . $url . '>' . $url . '</a></h2>' . "\n"; echo '<h3>[' . $resource . ']が参照しているリソース一覧</h3>' . "\n"; $data = $json_refer["results"]["bindings"]; echo '<div>' . "\n"; view_data($data, 'p', 'Predicate', 'o', 'Object'); echo '</div>' . "\n"; echo '<h3>[' . $resource . ']を参照しているリソース一覧</h3>' . "\n"; $data = $json_referred["results"]["bindings"]; echo '<div>' . "\n"; view_data($data, 's', 'Subject', 'p', 'Predicate'); echo '</div>' . "\n"; echo '</div>' . "\n"; } function view_data($data, $c1, $c1n, $c2, $c2n) { if (count($data) == 0) { echo 'なし' . "\n"; return; } echo '<table class="table">' . "\n"; echo '<tr><th>' . $c1n . '</th><th>' . $c2n . '</th></tr>' . "\n"; for ($i = 0; $i < count($data); $i++) { echo '<tr>' . "\n"; if ($data[$i][$c1] != null) { echo '<td>';
<?php if (file_exists("../inc/common.inc")) { require_once "../inc/common.inc"; } elseif (file_exists("inc/common.inc")) { require_once "inc/common.inc"; } elseif (file_exists("common.inc")) { require_once "common.inc"; } $file = $_REQUEST["dat"]; $fthumb = $_REQUEST["fthumb"]; view_data($file, $fthumb); function view_data($file, $fthumb = null) { if (!$fthumb) { $fthumb = 400; } // Check if this is a continual or sensor network station if (preg_match("/conti/i", "substr({$file},0,4)")) { $url = UPLOADPATH . "/trigger/continual/"; } else { $url = UPLOADPATH . "/trigger/"; } // Set file name $file_orig = $url . $file; //echo $file_orig; if (!file_exists($file_orig)) { echo "Waveform Not Found. Try again later."; return; } // Set base directory:
echo '<td><input type=text name=code ></td>'; echo '<td>result</td>'; echo '<td><input type=text name=result ></td>'; echo '<td>analysis_time</td>'; echo '<td><input type=text name=analysis_time value=\'' . strftime('%Y-%m-%d %H:%M:%S') . '\' ></td>'; echo '</tr>'; echo '<tr><td align=center><button type=submit name=submit>submit</button></td></tr>'; echo '</form></table>'; } function insert_repeat($sample_id, $code, $result, $analysis_time) { $link = start_nchsls(); $all_data = get_all_data_of_examination($code, $sample_id); $sql = 'insert into repeat_examination (sample_id,code,analysis_time,result,previous_result,previous_result_analysis_time) values(\'' . $sample_id . '\',\'' . $code . '\',\'' . $analysis_time . '\',\'' . $result . '\',\'' . $all_data['result'] . '\',\'' . $all_data['sample_receipt_time'] . '\')'; //echo $sql; if (!mysql_query($sql, $link)) { echo mysql_error(); } } if (!login_varify()) { exit; } main_menu(); if (isset($_POST['submit'])) { insert_repeat($_POST['sample_id'], $_POST['code'], $_POST['result'], $_POST['analysis_time']); } read_data(); view_data(16);
/** * Acts as a default (catch-all) exception handler. * * @param object $objException A thrown exception */ function caffeine_exception($objException) { $strMessage = $objException->getMessage(); switch ($strMessage) { case '404': view(get_config('404_view')); break; default: write_log('error', $strMessage); view_data('strMessage', $strMessage); view(get_config('error_view')); break; } }