function getScriptUrl()
{
$scriptName = explode('/', $_SERVER['SCRIPT_NAME']);
unset($scriptName[sizeof($scriptName) - 1]);
$scriptName = array_values($scriptName);
return getProtocol() . $_SERVER['SERVER_NAME'] . implode('/', $scriptName) . '/';
}
function getFlagSIEMPDF($url)
{
if ($url != '') {
return '<img src="' . getProtocol() . '//' . Util::get_default_admin_ip() . $url . '" />';
} else {
return '';
}
}
function login()
{
/* See: http://developer.yahoo.com/blogs/ydn/posts/2010/04/a_twolegged_oauth_serverclient_example/ */
$sig = getRequest('oauth_signature', TRUE);
$key = getRequest('oauth_consumer_key', TRUE);
$sig_method = new OAuthSignatureMethod_HMAC_SHA1();
$req_method = $_SERVER['REQUEST_METHOD'];
$url = getProtocol() . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
/* check if consumer key is in list of consumers */
$consumers = getConfig($this->config, 'oauth_consumers', TRUE);
if (!array_key_exists($key, $consumers)) {
throw new Exception("oauth consumer key not registered");
}
$consumer = new OAuthConsumer($key, $consumers[$key]);
$req = new OAuthRequest($req_method, $url);
$valid = $sig_method->check_signature($req, $consumer, NULL, $sig);
if (!$valid) {
throw new Exception('invalid oauth signature');
}
$this->userId = getRequest('userId', TRUE);
}
$page->description = 'Ascend is a one-day event focused on helping PTs, OTs, ' . 'and SLPs succeed in business. With two learning tracks to choose ' . 'from—one for starting a practice and the other for growing an existing ' . 'one—Ascend brings together renowned industry leaders to show you the ' . 'ropes for success in private practice.';
$page->body = array('class' => array('node-type-webform'));
$page->scripts = <<<JSC
<script type="text/javascript" src="{$base_url}js/jquery.formSelectStyle.js"></script>
<script type="text/javascript">
(function(\$) {
\$('.node-webform').find('select').formSelectStyle();
\$('#edit-submitted-are-you-a-webpt-member').on('change', function() {
\$('.form').addClass('hidden').filter('.' + \$(this).val()).removeClass('hidden');
});
}) (jQuery);
</script>
JSC;
$pardot_base = getProtocol() == 'http://' ? 'http://www2.webpt.com/' : 'https://go.pardot.com/';
include_once 'inc/head.php';
?>
<div id="nav-outer">
<nav id="nav" class="goodies">
<div class="container">
<a id="logo" href="<?php
echo $base_url;
?>
" title="WebPT">
<img itemprop="image" src="<?php
echo $base_url;
?>
images/logo.png" alt="WebPT Logo">
</a>
</div> <!-- end /.container -->
function getHttpRoot()
{
$app = Application::getInstance();
$protocol = getProtocol();
$host = $app->getHost();
$base = $app->getBase();
return $protocol . $host . $base . "/";
}
$GLOBAL_VARS = array();
/*
* 배포 환경에서 TRUE 상태가 되지 않도록 주의 하십시요.
* is_test TRUE : 에러 출력 등
* is_debug TRUE : 프로파일링, DB쿼리 저장 등
*/
$GLOBAL_VARS['is_test'] = TRUE;
$GLOBAL_VARS['is_debug'] = TRUE;
# 도메인 명
$GLOBAL_VARS['domain'] = 'noxportal.com';
$GLOBAL_VARS['cookie_domain'] = '.noxportal.com';
# 프로젝트 Document root path
$GLOBAL_VARS['document_root'] = filter_input(INPUT_SERVER, 'DOCUMENT_ROOT', FILTER_SANITIZE_SPECIAL_CHARS);
# 프로토콜 : http, https
$GLOBAL_VARS['is_secure'] = isSecure();
$GLOBAL_VARS['protocol'] = getProtocol($GLOBAL_VARS['is_secure']);
# DATABASE 관련 설정
$GLOBAL_VARS['db']['hostname'] = 'localhost';
$GLOBAL_VARS['db']['username'] = '******';
$GLOBAL_VARS['db']['password'] = '******';
$GLOBAL_VARS['db']['database'] = 'noxportal';
# DATABASE - TABLE 이름
$GLOBAL_VARS['db']['tables']['prefix'] = 'noxent_';
$GLOBAL_VARS['db']['tables']['members'] = $GLOBAL_VARS['db']['tables']['prefix'] . 'members';
$GLOBAL_VARS['db']['tables']['admin_members'] = $GLOBAL_VARS['db']['tables']['prefix'] . 'admin_members';
$GLOBAL_VARS['db']['tables']['board'] = $GLOBAL_VARS['db']['tables']['prefix'] . 'board';
$GLOBAL_VARS['db']['tables']['board_content'] = $GLOBAL_VARS['db']['tables']['prefix'] . 'board_content';
# autoload 설정 (콤마로 구분 문자열 배열에 추가)
$GLOBAL_VARS['autoload']['packages'] = array();
$GLOBAL_VARS['autoload']['libraries'] = array('database', 'session', 'app_lib');
$GLOBAL_VARS['autoload']['drivers'] = array();
');
$c = 0;
$conf = $GLOBALS['CONF'];
foreach ($ips as $country => $val) {
// type=6 Top Attackers from Country
$cou = explode(':', $country);
if ($cou[0] == '') {
$flag = $flag1 = '';
} else {
if ($cou[0] == 'me' || $cou[0] == 'eu' || $cou[0] == 'ap') {
$flag = $flag1 = '';
} elseif ($cou[0] == 'local') {
$flag = getProtocol() . '//' . Util::get_default_admin_ip() . '/ossim/forensics/images/homelan.png';
$flag1 = '../forensics/images/homelan.png';
} else {
$flag = getProtocol() . '//' . Util::get_default_admin_ip() . '/ossim/pixmaps/flags/' . $cou[0] . '.png';
$flag1 = '../pixmaps/flags/' . $cou[0] . '.png';
}
}
$porcent = round($val * 100 / $totalValue, 1);
$bc = $c++ % 2 != 0 ? "class='par'" : "";
/**/
$htmlPdfReport->set('
<tr ' . $bc . '>
<td style="width:50mm;font-size:11px">' . ($flag != '' ? "<img src='{$flag}' border='0' align='absmiddle' style='width:4mm'>" : "") . ' ' . $cou[1] . '</td>
<td style="width:18mm;text-align:center;font-size:11px">' . $val . '</td>
<td style="width:12mm;text-align:center;font-size:11px">' . $porcent . '%</td>
</tr>
');
}
$db->close();
$tool_user_name = 'validator';
$formats_supported = array('json', 'soap12', 'html');
$doctypes_supported = array('Inline', 'HTML5', 'XHTML 1.0 Strict', 'XHTML 1.0 Transitional', 'XHTML 1.0 Frameset', 'HTML 4.01 Strict', 'HTML 4.01 Transitional', 'HTML 4.01 Frameset', 'HTML 4.01 + RDFa 1.1', 'HTML 3.2', 'HTML 2.0', 'ISO/IEC 15445:2000 ("ISO HTML")', 'XHTML 1.1', 'XHTML + RDFa', 'XHTML Basic 1.0', 'XHTML Basic 1.1', 'XHTML Mobile Profile 1.2', 'XHTML-Print 1.0', 'XHTML 1.1 plus MathML 2.0', 'XHTML 1.1 plus MathML 2.0 plus SVG 1.1', 'MathML 2.0', 'SVG 1.0', 'SVG 1.1', 'SVG 1.1 Tiny', 'SVG 1.1 Basic', 'SMIL 1.0', 'SMIL 2.0');
require_once 'shared/common.php';
// error_reporting( E_ALL & ~E_NOTICE ); # Don't clutter the directory with unhelpful stuff
function startsWith($haystack, $needle)
{
// search backwards starting from haystack length characters from the end
return $needle === "" || strrpos($haystack, $needle, -strlen($haystack)) !== FALSE;
}
function endsWith($haystack, $needle)
{
// search forward starting from end minus needle length characters
return $needle === "" || ($temp = strlen($haystack) - strlen($needle)) >= 0 && strpos($haystack, $needle, $temp) !== FALSE;
}
$prot = getProtocol();
$url = $prot . "://tools.wmflabs.org/{$tool_user_name}/";
if (array_key_exists('HTTP_ORIGIN', $_SERVER)) {
$origin = $_SERVER['HTTP_ORIGIN'];
}
// Response Headers
header('Content-type: application/json; charset=utf-8');
header('Cache-Control: private, s-maxage=0, max-age=0, must-revalidate');
header('x-content-type-options: nosniff');
header('X-Frame-Options: SAMEORIGIN');
header('X-API-VERSION: 0.0.0.0');
if (isset($origin)) {
// Check protocol
$protOrigin = parse_url($origin, PHP_URL_SCHEME);
if ($protOrigin != $prot) {
header('HTTP/1.0 403 Forbidden');
function addUser($username, $origin, $status, $password = null, $email = null, $fullname = null)
{
global $mysql;
$username = mysql_html($username);
$origin = mysql_html($origin);
$status = mysql_html($status);
$email = mysql_html($email);
$fullname = mysql_html($fullname);
if ($fullname == null) {
$fullname = $username;
}
if ($password !== null) {
$password = password_hash($password, PASSWORD_DEFAULT);
}
$q1 = "INSERT INTO 1fx_users (username, origin, status, password, email, fullname) VALUES ('{$username}', '{$origin}', '{$status}', '{$password}', '{$email}', '{$fullname}')";
$q2 = "SELECT user_id FROM 1fx_users WHERE username='******'";
$res = mysqli_query($mysql, $q1);
if (!$res) {
die(mysqli_error($mysql));
}
$id = intval(mysqli_fetch_array(mysqli_query($mysql, $q2))['user_id']);
$q3 = "INSERT INTO 1fx_preferences (user_id) VALUES ({$id})";
mysqli_query($mysql, $q3);
$userdata = getAccounts($id)[0];
$emailBody = "Hello " . $userdata['fullname'] . ",<br><br>Your account has been registered to the serverpanel named <a href='" . getProtocol() . "://" . $_SERVER['SERVER_NAME'] . "'>" . substr($_SESSION['panel'], 0, -3) . "</a><br>Your account - {$username}<br>";
if (intval($origin) == 1) {
$emailBody .= "The account comes from IPS4 system, so you can log in with your forum password<br>";
}
$emailBody .= "<br>Best Regards!";
echo sendEmail($fullname, $userdata['email'], "You have been registered to " . substr($_SESSION['panel'], 0, -3), $emailBody);
if ($status === "3") {
$giveServerPermissions = "INSERT INTO 1fx_servers_user_map (server_id, user_id, can_see_rcon, can_update_mod, can_access_banlist, can_see_ftp, can_access_config, can_access_mapcycle_ents, can_stop_server) SELECT server_id, {$id} AS user_id, 1 AS can_see_rcon, 1 AS can_update_mod, 1 AS can_access_banlist, 1 AS can_see_ftp, 1 AS can_access_config, 1 AS can_access_mapcycle_ents, 1 AS can_stop_servers FROM 1fx_servers";
mysqli_query($mysql, $giveServerPermissions);
}
}
/**
* Compare two urls to see whether they refer to the same file,
* i.e., having the same protocol, host, port, and path.
* This method requires that none of its arguments is null. This is
* guaranteed by the fact that it is only called indirectly
* by java.net.URL class.
* @param u1 a URL object
* @param u2 a URL object
* @return boolean true if u1 and u2 refer to the same file
* @since 1.3
*/
public function sameFile(URL $u1, URL $u2)
{
// Compare the protocols.
if (!($u1 . getProtocol() == $u2 . getProtocol() || $u1 . getProtocol() != null && $u1 . getProtocol() . equalsIgnoreCase($u2 . getProtocol()))) {
return false;
}
// Compare the files.
if (!($u1 . getFile() == $u2 . getFile() || $u1 . getFile() != null && $u1 . getFile() . equals($u2 . getFile()))) {
return false;
}
// Compare the ports.
$port1 = $u1 . getPort() != -1 ? $u1 . getPort() : $u1 . handler . getDefaultPort();
$port2 = $u2 . getPort() != -1 ? $u2 . getPort() : $u2 . handler . getDefaultPort();
if ($port1 != $port2) {
return false;
}
// Compare the hosts.
if (!$this->hostsEqual($u1, $u2)) {
return false;
}
return true;
}
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
require_once 'utils.php';
require_once 'ext/opensocial-php-client/src/osapi/external/OAuth.php';
$key = 12345;
$secret = '54321';
$consumer = new OAuthConsumer($key, $secret);
$sig_method = new OAuthSignatureMethod_HMAC_SHA1();
/* Supports web and cli */
$protocol = getProtocol();
if ($protocol !== FALSE) {
$api_endpoint = $protocol . $_SERVER['HTTP_HOST'] . dirname($_SERVER['SCRIPT_NAME']) . "/index.php";
} else {
if (empty($argv[1])) {
die("specify API endpoint URL\n");
}
$api_endpoint = $argv[1];
}
$params = array('useRest' => '1', 'action' => 'showFiles', 'userId' => 'anonymous');
$req = OAuthRequest::from_consumer_and_token($consumer, null, "GET", $api_endpoint, $params);
$req->sign_request($sig_method, $consumer, null);
$ch = curl_init($req->to_url());
curl_exec($ch);
curl_close($ch);
function getAddress($params)
{
$protocol = getProtocol($params);
$url = empty($params['serverhostname']) ? $params['serverip'] : $params['serverhostname'];
return $protocol . $url;
}
<?php
//namespace includes\config;
session_start();
#---------------------------DEFINING DATABASE CONSTANTS-----------------------------------------------------#
// const HOST = 'localhost';
// const USER_NAME = 'root';
// const PASSWORD = '******';
// const DATABASE_NAME = 'dvo_test';
define('HOST', 'localhost');
define('USER_NAME', 'root');
define('PASSWORD', 'test');
define('DATABASE_NAME', 'dvo_test');
#-----------------------------------------------------------------------------------------------------------#
#---------------------------DEFINING BASE URL CONSTANTS-----------------------------------------------------#
define('HTTP_TYPE', getProtocol());
define('HTTP_ROOT', $_SERVER['HTTP_HOST']);
define('HTTP_FOLDER', '/dvo_test1');
define('BASE_URL', HTTP_TYPE . "://" . HTTP_ROOT . HTTP_FOLDER);
define('DOCUMENT_ROOT', $_SERVER['DOCUMENT_ROOT']);
define('WEBSITE_ROOT', HTTP_FOLDER === '' ? DOCUMENT_ROOT : DOCUMENT_ROOT . HTTP_FOLDER);
define('DEFAULT_CONTROLLER', 'users');
define('DEFAULT_ACTION', 'login');
#-----------------------------------------------------------------------------------------------------------#
#----------------------DEFINING DATABASE TABLE NAMES CONSTANTS----------------------------------------------#
$prefix = 'dvo_';
define("USERS_TABLE", $prefix . "users");
#-----------------------------------------------------------------------------------------------------------#
#-------------------------------------------------------------------------------------------------------#
#---------------------DEFINING SOME FUNCTION USED IN WITHIN CONFIG FILE--------------------------------#
function getProtocol()
function update($arr)
{
$zwave = new Zwave();
if (isset($arr['toggle'], $arr['value'])) {
$id = $arr['toggle'];
$cmd = $arr['value'];
$protocol = getProtocol($arr['toggle']);
switch ($protocol) {
case 'zwave':
echo $zwave->command($id, $cmd);
break;
}
}
if (isset($arr['device'], $arr['alias'], $arr['room'])) {
$arr['room'] == -1 ? $room = NULL : ($room = $arr['room']);
$arr['alias'] == '' ? $alias = NULL : ($alias = $arr['alias']);
$device = $arr['device'];
$bdd = getBDD();
$req = $bdd->exec("UPDATE at_sensors_devices SET `alias` = '{$alias}', `room` = '{$room}' WHERE id = '{$device}'");
if ($req == 1) {
http_response_code(202);
} else {
http_response_code(400);
}
}
if (isset($arr['sensor'], $arr['history'], $arr['ignore'])) {
$sensor = $arr['sensor'];
$history = $arr['history'];
$ignore = $arr['ignore'];
$bdd = getBDD();
$req = $bdd->exec("UPDATE at_sensors SET `history` = '{$history}', `ignore` = '{$ignore}' WHERE id = '{$sensor}'");
// echo json_encode ( $req );
if ($req == 1) {
http_response_code(202);
} else {
http_response_code(400);
}
}
if (isset($arr['sensor'], $arr['type'])) {
$sensor = $arr['sensor'];
$type = $arr['type'];
$bdd = getBDD();
$req = $bdd->exec("UPDATE at_sensors SET `type` = '{$type}' WHERE id = '{$sensor}'");
if ($req == 1) {
http_response_code(202);
} else {
http_response_code(400);
}
}
}
function updateFileInfo()
{
$button = getRequest("buttonPressed", TRUE);
switch ($button) {
/* called from the {File,Media}List page */
/* case "Download" :
return $this->downloadFile(); */
case "Delete Files":
$markedFiles = getRequest("markedFiles", FALSE, array());
return $this->confirmDelete($markedFiles);
/* called from the FileInfo page */
/* called from the FileInfo page */
case "Delete":
$id = getRequest("id", TRUE);
return $this->confirmDelete(array($id));
/* called from the ConfirmDelete page */
/* called from the ConfirmDelete page */
case "Confirm Delete":
$markedFiles = getRequest("markedFiles", FALSE, array());
return $this->deleteFiles($markedFiles);
/* called from the FileInfo page */
/* called from the FileInfo page */
case "Update":
/* continue with the rest of the function */
break;
case "Reexamine":
$id = getRequest("id", TRUE);
return $this->reExamineFile($id);
default:
throw new Exception("invalid button type");
}
$id = getRequest("id", TRUE);
$info = $this->storage->get($id)->body;
if ($info->fileOwner !== $this->auth->getUserId()) {
throw new Exception("access denied");
}
$fileName = getRequest('fileName', FALSE, $info->fileName);
$fileDescription = getRequest('fileDescription', FALSE, $info->fileDescription);
$fileTags = getRequest('fileTags', FALSE, implode(",", $info->fileTags));
$fileLicense = getRequest('fileLicense', FALSE, $info->fileLicense);
$fileTokens = getRequest('fileTokens', FALSE, implode(",", array_values((array) $info->fileTokens)));
$fileGroups = getRequest('fileGroups', FALSE, array());
/* not set means everything deselected! */
/* Name */
if ($fileName != $info->fileName) {
/* file name changed, update entry and file system */
$filePath = getConfig($this->config, 'file_storage_dir', TRUE) . "/" . base64_encode($info->fileOwner) . "/" . $info->fileName;
$newFilePath = getConfig($this->config, 'file_storage_dir', TRUE) . "/" . base64_encode($info->fileOwner) . "/" . $fileName;
rename($filePath, $newFilePath);
$info->fileName = $fileName;
}
/* Tags */
$tags = explode(",", $fileTags);
$info->fileTags = array();
foreach ($tags as $t) {
$t = trim(htmlspecialchars($t));
if (!empty($t) && !in_array($t, $info->fileTags, TRUE)) {
array_push($info->fileTags, $t);
}
}
/* Tokens */
$tokens = explode(",", $fileTokens);
/*
- We may have some tokens already stored ($info->fileTokens)
- The token consists of the email address with the key being the token
- Now we get only email addresses from the form submit
- We only keep the email addresses still in the form submit (intersect)
- For all the new addresses we generate tokens
- We find out now which ones are actually new (diff)
- Send an email invite to all the new addresses
- We add the new ones with their new tokens to the tokens in $info->fileTokens,
while keeping the old tokens if existing
*/
/* The new addresses, clean them all first! */
$newAddresses = array();
foreach ($tokens as $t) {
$t = trim($t);
if (!empty($t)) {
$address = filter_var($t, FILTER_VALIDATE_EMAIL);
if ($address === FALSE) {
throw new Exception("invalid email address specified");
}
if (!empty($address) && !in_array($address, $newAddresses, TRUE)) {
$newAddresses[generateToken()] = $address;
}
}
}
/* Woah, can this really not be made simpler? */
$isec = array_intersect((array) $info->fileTokens, $newAddresses);
$diff = array_diff($newAddresses, (array) $info->fileTokens);
$info->fileTokens = array_merge($isec, $diff);
/* Send an email to all new addresses (from diff) */
$this->smarty->assign('sender', $this->auth->getUserDisplayName());
$this->smarty->assign('fileName', $info->fileName);
foreach ($diff as $token => $address) {
$url = getProtocol() . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF'] . "?action=fileInfo&id={$info->_id}&token={$token}";
$this->smarty->assign('url', $url);
$content = $this->smarty->fetch('EmailInvite.tpl');
$message = wordwrap($content, 70);
/* send email */
$subject = '[FileTrader] A file has been shared with you!';
$from = getConfig($this->config, 'email_share_sender', FALSE, 'FileTrader <filetrader@' . $_SERVER['HTTP_HOST'] . '>');
$headers = "From: {$from}\r\n" . "Reply-To: {$from}\r\n" . "X-Mailer: PHP/" . phpversion();
$status = mail($address, $subject, $message, $headers);
if ($status !== TRUE) {
logHandler("Sending mail to {$address} failed!");
} else {
logHandler("User '" . $this->auth->getUserID() . "' is sharing file '" . $info->fileName . "' with '" . $address . "'");
}
}
/* Description */
$info->fileDescription = trim(htmlspecialchars($fileDescription));
/* Groups */
$info->fileGroups = $this->groups->memberOfGroups($fileGroups);
/* License */
if (!array_key_exists($fileLicense, $this->licenses)) {
throw new Exception("invalid license specified");
}
$info->fileLicense = $fileLicense;
$this->storage->put($id, $info);
return $this->fileInfo();
}
function generer_token($nom = '')
{
global $_url;
$token = uniqid(rand(), true);
$_SESSION['formulaire_token'][$nom . '_token'] = $token;
$_SESSION['formulaire_token'][$nom . '_token_time'] = time();
$_SESSION['formulaire_token'][$nom . '_token_referer'] = getProtocol() . '://' . getenv('HTTP_HOST') . getenv('REQUEST_URI');
return $token;
}
}
$rs_ultimo_documento = gaz_dbi_dyn_query("*", $gTables['tesdoc'], $sql_documento,$where,0,1);
$ultimo_documento = gaz_dbi_fetch_array($rs_ultimo_documento);
// se e' il primo documento dell'anno, resetto il contatore
if ($ultimo_documento) {
$form['numdoc'] = $ultimo_documento['numdoc'] + 1;
} else {
$form['numdoc'] = 1;
}
if (substr($form['tipdoc'],0,2) == 'DD'){ //ma se e' un ddt il protocollo è 0 così come il numero e data fattura
$form['protoc'] = 0;
$form['numfat'] = 0;
$form['datfat'] = 0;
} else { //in tutti gli altri casi si deve prendere quanto inserito nel form
$form['datfat'] = $initra;
$form['protoc'] = getProtocol($form['tipdoc'],$form['annemi'],$sezione);
$form['numdoc'] = $form['numfat'];
}
//inserisco la testata
$form['status'] = '';
$form['initra'] = $initra;
$form['datemi'] = $datemi;
tesdocInsert($form);
//recupero l'id assegnato dall'inserimento
$ultimo_id = gaz_dbi_last_id();
//inserisco i righi
foreach ($form['rows'] as $i => $value) {
$form['rows'][$i]['id_tes'] = $ultimo_id;
rigdocInsert($form['rows'][$i]);
$last_rigdoc_id = gaz_dbi_last_id();
if (isset($form["row_$i"])) { //se è un rigo testo lo inserisco il contenuto in body_text
function content($id, $code, $unit)
{
if (access($id, $_SESSION['us_id']) == true) {
if ($id == 1 or $id == 4 or $id == 7 or $id == 10 or $id == 13) {
if ($id == 1) {
$query = "SELECT pp_kod,pp_nama,pp_tkh_submit,pp_rs_kod_lab,pp_rs_kod_api,pp_rs_kod_product,rkatp_desc,rkatp_class FROM p_product,ref_kat_produk\n WHERE pp_rkatp_kod=rkatp_kod AND pp_rs_kod=1105 AND pp_rkatp_kod IN(3,23,24,1,25,26,27,7,8,29,30,33)";
} else {
$query = "SELECT pp_kod,pp_nama,pp_tkh_submit,pp_rs_kod_lab,pp_rs_kod_api,pp_rs_kod_product,rkatp_desc,rkatp_class FROM p_product,ref_kat_produk\n WHERE pp_rkatp_kod=rkatp_kod AND pp_rs_kod IN(1107,1110,1111,1112) AND pp_rkatp_kod IN(3,23,24,1,25,26,27,7,8,29,30,33)";
}
?>
<div class="tab-content pn br-n admin-form">
<div class="row">
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="primary" align="center">
<td width="5%">No</td>
<td width="10%">Call No</td>
<td width="25%">Product Name</td>
<td width="15%">Received Date</td>
<td width="15%">Lab Status</td>
<td width="15%">API Status</td>
<td width="15%">Product Status</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$result = selQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['pp_kod'];
?>
</td>
<td align="left">
<div class="text-primary">
<b><?php
echo $row['pp_nama'];
?>
</b>
</div>
<div class="text-muted">
<?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div>
</td>
<td><?php
echo displayDate($row['pp_tkh_submit']);
?>
</td>
<td align="left"><?php
echo protocolStatus($row['pp_rs_kod_lab'], $id);
?>
</td>
<td align="left"><?php
echo protocolStatus($row['pp_rs_kod_api'], $id);
?>
</td>
<td align="left"><?php
echo protocolStatus($row['pp_rs_kod_product'], $id);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
} elseif ($id == 2) {
?>
<div class="tab-content pn br-n admin-form">
<div class="row">
<input type="hidden" id="mainTitle" value="<?php
echo protocolTitle($code);
?>
">
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="primary" align="center">
<td width="5%">No</td>
<td width="10%">Call No</td>
<td width="45%">Product Name</td>
<td width="15%">Submission Date</td>
<td width="10%">Aging</td>
<td width="25%">Status</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
//echo getProtocol($code,$id,"A");
$result = selQuery(getProtocol($code, $id, "A"));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['pp_kod'];
?>
</td>
<td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php
echo $code;
?>
','<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a></b></div><div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div></td>
<td><?php
echo displayDate($row['pp_tkh_submit']);
?>
</td>
<td><?php
echo aging($row['pp_tkh_submit']);
?>
</td>
<td align="left"><?php
echo getStatus($row['pp_rs_kod_lab']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
} elseif ($id == 5 or $id == 8 or $id == 11 or $id == 14) {
?>
<div class="tab-content pn br-n admin-form">
<input type="hidden" id="mainTitle" value="<?php
echo protocolTitle($code);
?>
">
<div class="row">
<div class="alert alert-sm alert-border-left alert-danger"><b>Priority List</b></div>
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="primary" align="center">
<?php
if ($id == 5) {
?>
<td width="2%"> </td>
<td width="2%">No</td>
<td width="16%">Reference No</td>
<td width="50%">Product Name</td>
<td width="10%">Approve Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
} else {
?>
<td width="2%">No</td>
<td width="18%">Reference No</td>
<td width="50%">Product Name</td>
<td width="10%">Approve Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
$count = 1;
//echo getProtocol($id,$code,$_SESSION['ru_kod'],$_SESSION['us_id'],'P');
$result = selQuery(getProtocol($code, $id, 'P'));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<?php
if ($id == 5) {
?>
<td><input type="checkbox" value="<?php
echo $row["pp_kod"];
?>
"></td>
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['pp_ref_no'];
?>
</td>
<td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php
echo $code;
?>
','<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a></b></div><div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div></td>
<td><?php
echo displayDate($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo aging($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo checkStatus($row['pp_kod']);
?>
</td>
<?php
} else {
?>
<td><?php
echo $count++;
?>
</td>
<td align="left"><?php
echo $row['pp_ref_no'];
?>
</td>
<td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php
echo $code;
?>
','<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a></b></div><div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div></td>
<td><?php
echo displayDate($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo aging($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo checkStatus($row['pp_kod']);
?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
if ($id == 5) {
?>
<div class="row" align="right">
<div class="btn-group">
<button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
Move to
<span class="caret ml5"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li>
<a onclick="changePriority('primary','protocol','<?php
echo $code;
?>
')">Normal List</a>
</li>
</ul>
</div>
</div>
<?php
}
?>
<div class="row">
<div class="section-divider"></div>
</div>
<div class="row">
<div class="alert alert-sm alert-border-left alert-primary"><b>Normal List</b></div>
<table class="table table-striped table-bordered table-hover" id="second" cellspacing="0" width="100%">
<thead>
<tr class="primary" align="center">
<?php
if ($id == 5) {
?>
<td width="2%"> </td>
<td width="2%">No</td>
<td width="16%">Reference No</td>
<td width="50%">Product Name</td>
<td width="10%">Approve Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
} else {
?>
<td width="2%">No</td>
<td width="18%">Reference No</td>
<td width="50%">Product Name</td>
<td width="10%">Approve Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$result = selQuery(getProtocol($code, $id, 'N'));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<?php
if ($id == 5) {
?>
<td><input type="checkbox" value="<?php
echo $row["pp_kod"];
?>
"></td>
<td><?php
echo $count++;
?>
</td>
<td align="left"><?php
echo $row['pp_ref_no'];
?>
</td>
<td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php
echo $code;
?>
','<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a></b></div><div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div></td>
<td><?php
echo displayDate($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo aging($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo checkStatus($row['pp_kod']);
?>
</td>
<?php
} else {
if ($row['la_rs_kod'] == 443 and $row['la_us_id'] == $_SESSION['ru_kod']) {
echo $row['la_rs_kod'] . $row['la_us_id'];
} else {
?>
<td><?php
echo $count++;
?>
</td>
<td align="left"><?php
echo $row['pp_ref_no'];
?>
</td>
<td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php
echo $code;
?>
','<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a></b></div><div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div></td>
<td><?php
echo displayDate($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo aging($row['pp_tkh_approve']);
?>
</td>
<td><?php
echo checkStatus($row['pp_kod']);
?>
</td>
<?php
}
?>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
<?php
if ($id == 5) {
?>
<div class="row" align="right">
<div class="btn-group">
<button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
Move to
<span class="caret ml5"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li>
<a onclick="changePriority('second','protocol','<?php
echo $code;
?>
')">Priority List</a>
</li>
</ul>
</div>
</div>
<?php
}
?>
</div>
<?php
} elseif ($id == 3 or $id == 6 or $id == 9 or $id == 12 or $id == 15) {
?>
<div class="tab-content pn br-n admin-form">
<div class="row">
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="primary" align="center">
<td width="5%">No</td>
<td width='15%'>
<?php
if ($id == 3) {
echo "Call No";
} else {
echo "Reference No";
}
?>
</td>
<td width="35%">Product Name</td>
<td width="15%">
<?php
if ($id == 3) {
echo "Screening Date";
} else {
echo "Approve Date";
}
?>
</td>
<td width="15%">Status</td>
<td width="20%">Action</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$query = "SELECT pp_kod,pp_ref_no,pp_nama,pp_pkk_screen_tkh,rkatp_desc,rkatp_class FROM p_product\n LEFT JOIN ref_kat_produk ON pp_rkatp_kod = rkatp_kod";
if ($id == 12 || $id == 15) {
$query .= " LEFT JOIN lab_assign ON la_pp_kod=pp_kod";
}
if ($id == 3) {
$query .= " WHERE pp_rs_kod_lab in(9002,9003) AND pp_status_nopayment='1' AND pp_rs_kod in(1103,1105)";
} elseif ($id == 6) {
$query .= " WHERE pp_rs_kod_lab=402 AND pp_status_nopayment='2' AND pp_rs_kod=1103";
} elseif ($id == 12) {
$query .= " WHERE pp_rs_kod_lab=402 AND pp_status_nopayment='2' AND pp_rs_kod IN(1103,1110) AND la_ru_kod='" . $_SESSION['ru_kod'] . "' AND la_rs_kod IN (403,443) GROUP BY pp_kod";
} elseif ($id == 15) {
$query .= " WHERE pp_rs_kod_lab IN('1111','1112') AND pp_status_nopayment='2' AND pp_rs_kod IN (1112,1111,1110,1103) AND la_ru_kod='" . $_SESSION['ru_kod'] . "' AND la_rs_kod IN(408,1110) GROUP BY pp_kod";
}
$result = selQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $count++;
?>
</td>
<td>
<?php
if ($id == 3) {
echo $row['pp_kod'];
} else {
echo $row['pp_ref_no'];
}
?>
</td>
<td align="left"><div><b><a style="cursor:pointer;" onclick="viewDetail('<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a></b></div><div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</td>
<td><?php
echo displayDate($row['pp_pkk_screen_tkh']);
?>
</td>
<td align="left"><?php
echo checkStatus($row['pp_kod']);
?>
</td>
<td>
<?php
if ($id == 6) {
?>
<a style="cursor:pointer;" title="Reassign Lab" onclick="viewLab('<?php
echo $row['pp_kod'];
?>
')"><i class="fa fa-random fa-lg"></i></a>
<?php
} elseif ($id == 12) {
?>
<a style="cursor:pointer;" title="Reassign Pharmacist" onclick="viewPharmacist('<?php
echo $row['pp_kod'];
?>
')"><i class="fa fa-random fa-lg"></i></a>
<?php
}
?>
<a style="cursor:pointer;" title="View Checklist" class="ml10" data-toggle="popover" data-content="And here's some amazing content. It's very engaging. Right?" onclick="viewChecklist('<?php
echo $row['pp_kod'];
?>
')"><i class="fa fa-list fa-lg"></i></a>
<a style="cursor:pointer;" title="View Chronology" class="ml10" onclick="chronology(0,'<?php
echo $row['pp_kod'];
?>
')"><i class="fa fa-sort-alpha-asc fa-lg"></i></a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
} elseif ($id == 16) {
?>
<div class="tab-content pn br-n admin-form">
<input type="hidden" id="mainTitle" value="<?php
echo sampleTitle($code);
?>
">
<?php
if ($code == 3 || $code == 4) {
?>
<div class="row">
<div class="alert alert-sm alert-border-left alert-alert"><b>Pharma</b></div>
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<td width="5%">No</td>
<td width="15%">
<?php
if ($code == 3) {
echo "Complaint No";
} else {
echo "Surveillance No";
}
?>
</td>
<td width="15%">Registration No</td>
<td width="35%">Product Name</td>
<td width="15%">Send Date</td>
<td width="15%">Aging</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$result = selQuery(getSample($code, $id, 1));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['ref'];
?>
</td>
<td><?php
echo $row['reg'];
?>
</td>
<td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kod'];
?>
')"><?php
echo $row['product'];
?>
</a></b></td>
<td><?php
echo displayDate($row['lab_sent_date']);
?>
</td>
<td><?php
echo aging($row['lab_sent_date']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div class="row">
<div class="section-divider"></div>
</div>
<div class="row">
<div class="alert alert-sm alert-border-left alert-alert"><b>Cosmetic</b></div>
<table class="table table-striped table-bordered table-hover" id="second" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<td width="5%">No</td>
<td width="15%">
<?php
if ($code == 3) {
echo "Complaint No";
} else {
echo "Surveillance No";
}
?>
</td>
<td width="15%">Registration No</td>
<td width="35%">Product Name</td>
<td width="15%">Send Date</td>
<td width="15%">Aging</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$result = selQuery(getSample($code, $id, 2));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['ref'];
?>
</td>
<td><?php
echo $row['reg'];
?>
</td>
<td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kod'];
?>
')"><?php
echo $row['product'];
?>
</a></b></td>
<td><?php
echo displayDate($row['lab_sent_date']);
?>
</td>
<td><?php
echo aging($row['lab_sent_date']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
} else {
?>
<div class="row">
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<?php
if ($code == 1) {
?>
<td width="5%">No</td>
<td width="10%">Call No</td>
<td width="15%">Reference No</td>
<td width="40%">Product Name</td>
<td width="10%">Send Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
} elseif ($code == 2) {
?>
<td width="5%">No</td>
<td width="15%">ADR No</td>
<td width="15%">Registration No</td>
<td width="35%">Product Name</td>
<td width="15%">Send Date</td>
<td width="15%">Aging</td>
<?php
} else {
?>
<td width="5%">No</td>
<td width="65%">Product Name</td>
<td width="15%">Send Date</td>
<td width="15%">Aging</td>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
$count = 1;
//echo getSample($code,$id);
$result = selQuery(getSample($code, $id, "A"));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<?php
if ($code == 1) {
?>
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['pp_kod'];
?>
</td>
<td><?php
echo $row['pp_ref_no'];
?>
</td>
<td align="left"><div><b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a></b></div><div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div></td>
<td>-</td>
<td>-</td>
<td align="left"><?php
echo screeningStatus($row['pp_kod']);
?>
</td>
<?php
} elseif ($code == 2) {
?>
<td><?php
echo $count++;
?>
</td>
<td>
<?php
if (!$row['Adrno']) {
echo $row['adrFormID'];
} else {
echo $row['Adrno'];
}
?>
</td>
<td><?php
echo $row['MALnum'];
?>
</td>
<td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['adrSampleID'];
?>
')"><?php
echo $row['product_name'];
?>
</a></b></td>
<td><?php
echo displayDate($row['lab_sent_date']);
?>
</td>
<td><?php
echo aging($row['lab_sent_date']);
?>
</td>
<?php
} elseif ($code == 5) {
?>
<td><?php
echo $count++;
?>
</td>
<td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b></td>
<td>-</td>
<td>-</td>
<?php
} elseif ($code == 6) {
?>
<td><?php
echo $count++;
?>
</td>
<td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b></td>
<td><?php
echo displayDate($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
}
?>
<?php
if ($code == 1) {
?>
<div class="col-md-12"> </div>
<div class="row" align="right">
<div class="btn-group">
<button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
Action
<span class="caret ml5"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a style="cursor:pointer" onclick="screenList(1)">In Tray</a></li>
<li><a style="cursor:pointer" onclick="screenList(2)">Rejected List</a></li>
</ul>
</div>
</div>
<?php
}
?>
<?php
if ($code == 6) {
?>
<div class="col-md-12"> </div>
<div class="row" align="right"><button class="btn btn-alert" onclick="newSample()"><i class="fa fa-plus"></i> New</button></div>
<?php
}
?>
</div>
<?php
} elseif ($id == 19 or $id == 21 or $id == 23 or $id == 25 or $id == 27) {
?>
<div class="tab-content pn br-n admin-form">
<div class="row">
<input type="hidden" id="mainTitle" value="<?php
echo sampleTitle($code);
?>
">
<div class="alert alert-sm alert-border-left alert-danger"><b>Priority List</b></div>
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<?php
if ($id == 19) {
?>
<td width="5%"> </td>
<td width="5%">No</td>
<td width="10%">Sample No</td>
<td width="20%">Product Name</td>
<td width="10%">Approved Date</td>
<td width="10%">Expected Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
} else {
?>
<td width="5%">No</td>
<td width="10%">Sample No</td>
<td width="25%">Product Name</td>
<td width="10%">Received Date</td>
<td width="10%">Expected Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
$count = 1;
//echo getSample($code,$id,'P');
$result = selQuery(getSample($code, $id, 'P'));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<?php
if ($id == 19) {
?>
<td>
<input type="checkbox" value="<?php
echo $row['kp_id'];
?>
">
</td>
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b>
<div><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div>
</td>
<td><?php
echo displayDate($row['kp_tkh_approve']);
?>
</td>
<td><?php
echo addDayswithdate($row['kp_tkh_approve'], $row['kp_complete_day']);
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<td align="left"><?php
echo getStatus($row['kp_rs_level']);
?>
</td>
<?php
} else {
?>
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</b></a>
</td>
<td><?php
echo displayDate($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<td align="left"><?php
echo getStatus($row['kp_rs_level']);
?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
if ($id == 19) {
?>
<div class="row" align="right">
<div class="btn-group">
<button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
Move to
<span class="caret ml5"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li>
<a onclick="changePriority('primary','sample','<?php
echo $code;
?>
')">Normal List</a>
</li>
</ul>
</div>
</div>
<?php
}
?>
<div class="row">
<div class="section-divider"></div>
</div>
<div class="row">
<div class="alert alert-sm alert-border-left alert-alert"><b>Normal List</b></div>
<table class="table table-striped table-bordered table-hover" id="second" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<?php
if ($id == 19) {
?>
<td width="5%"> </td>
<td width="5%">No</td>
<td width="10%">Sample No</td>
<td width="20%">Product Name</td>
<td width="10%">Received Date</td>
<td width="10%">Expected Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
} else {
?>
<td width="5%">No</td>
<td width="10%">Sample No</td>
<td width="25%">Product Name</td>
<td width="10%">Received Date</td>
<td width="10%">Expected Date</td>
<td width="5%">Aging</td>
<td width="15%">Status</td>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$result = selQuery(getSample($code, $id, 'N'));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<?php
if ($id == 19) {
?>
<td>
<input type="checkbox" value="<?php
echo $row['kp_id'];
?>
">
</td>
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b>
<div><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div>
</td>
<td><?php
echo displayDate($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo getStatus($row['kp_rs_level']);
?>
</td>
<?php
} else {
?>
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<b><a style="cursor:pointer;" onclick="sampleDetail('<?php
echo $code;
?>
','<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b>
</td>
<td><?php
echo displayDate($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo getStatus($row['kp_rs_level']);
?>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
if ($id == 19) {
?>
<div class="row" align="right">
<div class="btn-group">
<button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
Move to
<span class="caret ml5"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li>
<a onclick="changePriority('second','sample','<?php
echo $code;
?>
')">Priority List</a>
</li>
</ul>
</div>
</div>
<?php
}
?>
</div>
<?php
} elseif ($id == 17 or $id == 20 or $id == 22 or $id == 24 or $id == 26 or $id == 28) {
?>
<div class="tab-content pn br-n admin-form">
<div class="row">
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<td width="5%">No</td>
<td width="10%">Sample No</td>
<td width="25%">Product Name</td>
<td width="15%">Received Date</td>
<td width="15%">Expected Date</td>
<td width="10%">Aging</td>
<td width="20%">Status</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$query = "SELECT kp_id,kp_sampel_no,kp_product_name,kp_tkh_terima,kp_complete_day,kp_rs_level FROM k_produk";
if ($id == 17) {
$query .= " WHERE kp_rs_level IN (401,402)";
} elseif ($id == 20) {
$query .= " WHERE kp_rs_level='402'";
} elseif ($id == 22) {
$query .= " WHERE kp_rs_level='411'";
} elseif ($id == 24) {
$query .= " JOIN k_lab ON k_lab.klb_kp_id=k_produk.kp_id\n WHERE kp_rs_level='402' AND klb_ru_kod='" . $_SESSION['ru_kod'] . "'";
} elseif ($id == 26) {
$query .= " JOIN k_lab ON k_lab.klb_kp_id=k_produk.kp_id\n WHERE kp_rs_level='402' AND klb_ru_kod='" . $_SESSION['ru_kod'] . "' AND klb_tp_kod='" . $_SESSION['us_id'] . "' AND klb_rs_level='404'";
} elseif ($id == 28) {
$query .= " JOIN k_lab ON k_lab.klb_kp_id=k_produk.kp_id\n JOIN k_lab_task_test ON k_lab_task_test.kltt_kp_id=k_produk.kp_id\n WHERE kp_rs_level='402' AND klb_ru_kod='" . $_SESSION['ru_kod'] . "' AND kltt_tp_kod='" . $_SESSION['us_id'] . "' AND klb_rs_level='405'\n GROUP BY kp_id";
}
$result = selQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $count++;
?>
</td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left"><a style="cursor:pointer;" onclick="viewSample('<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></td>
<td><?php
echo displayDate($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<td align="left"><?php
echo getStatus($row['kp_rs_level']);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
} elseif ($id == 18 or $id == 34) {
?>
<div class="tab-content pn br-n admin-form">
<input type="hidden" id="mainTitle" value="<?php
echo sampleTitle($code);
?>
">
<div class="row">
<div class="alert alert-sm alert-border-left alert-danger"><b>Priority List</b></div>
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<td width="5%"> </td>
<td width="10%">Sample No</td>
<td width="45%">Product Name</td>
<td width="15%">Received Date</td>
<td width="10%">Aging</td>
<td width="15%">Approve Date</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$result = selQuery(getSample($code, $id, "P"));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td>
<input type="checkbox" value="<?php
echo $row['kp_sampel_no'];
?>
">
</td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<div><b><a style="cursor:pointer;" onclick="sampleResult('<?php
echo $row['kp_id'];
?>
','<?php
echo $row['kp_sampel_no'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b></div><div class="text-muted"><?php
echo sampleCategory($row['kp_rsc_kod']);
?>
</div>
</td>
<td><?php
echo $row['kp_tkh_terima'];
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo $row[''];
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div class="row">
<div class="section-divider"></div>
</div>
<div class="row">
<div class="alert alert-sm alert-border-left alert-alert"><b>Normal List</b></div>
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="alert" align="center">
<td width="5%"> </td>
<td width="10%">Sample No</td>
<td width="45%">Product Name</td>
<td width="15%">Received Date</td>
<td width="10%">Aging</td>
<td width="15%">Approve Date</td>
</tr>
</thead>
<tbody>
<?php
$count = 1;
$result = selQuery(getSample($code, $id, "N"));
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td>
<input type="checkbox" value="<?php
echo $row['kp_sampel_no'];
?>
">
</td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<div><b><a style="cursor:pointer;" onclick="sampleResult('<?php
echo $row['kp_id'];
?>
','<?php
echo $row['kp_sampel_no'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b></div><div class="text-muted"><?php
echo sampleCategory($row['kp_rsc_kod']);
?>
</div>
</td>
<td><?php
echo $row['kp_tkh_terima'];
?>
</td>
<td><?php
echo aging($row['kp_tkh_terima']);
?>
</td>
<td><?php
echo $row[''];
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<!-- <div class="col-md-12"> </div>
<div class="col-md-12" align="right">
<div class="btn-group">
<button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
Action
<span class="caret ml5"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a style="cursor:pointer" onclick="selectPrint()">Print Selected</a></li>
</ul>
</div>
</div> -->
</div>
<?php
} elseif ($id == 29) {
?>
<div class="tab-content pn br-n admin-form">
<?php
if ($code == 1) {
?>
<input type="hidden" id="mainTitle" value="General Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-4">
<select class="form-control" id="searchBy" onchange="changeSearch(1)">
<option value="0">-- Please Select --</option>
<option value="1">Product Name</option>
<option value="11">Protocol Number</option>
<option value="2">Reference Number</option>
<option value="3">Registration Number</option>
<option value="4">Product Category</option>
<option value="5">Holder</option>
<option value="6">Manufacturer</option>
<option value="7">Active Substance</option>
<option value="8">Received Date</option>
<option value="9">Approval Date</option>
<option value="10">Reject Date</option>
</select>
</div>
<div class="col-md-12"> </div>
<div class="col-md-2">Search</div>
<div class="col-md-1">:</div>
<div class="col-md-4" id="changeSearch">
<label for="searchTxt" class="field prepend-icon">
<input type="text" id="searchTxt" class="gui-input" placeholder="Search">
<label class="field-icon">
<i class="fa fa-search"></i>
</label>
</label>
</div>
<div class="col-md-12"> </div>
<div class="col-md-12" align="right">
<button class="btn btn-primary btn-sm" onclick="carian(1)"><i class="fa fa-search"></i> Search</button>
</div>
<?php
} else {
?>
<input type="hidden" id="mainTitle" value="Status Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-9" id="ProtocolStatus">
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_01" name="ProtocolStatus" checked="true" onclick="changeSearching(3)">
<label for="ProtocolStatus_01">Protocol Under Evaluation</label>
</div>
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_02" name="ProtocolStatus" onclick="changeSearching(3)">
<label for="ProtocolStatus_02">Waiting for Approval</label>
</div>
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_03" name="ProtocolStatus" onclick="changeSearching(3)">
<label for="ProtocolStatus_03">Approval Protocol</label>
</div>
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_04" name="ProtocolStatus" onclick="changeSearching(3)">
<label for="ProtocolStatus_04">Rejected Protocol</label>
</div>
</div>
<div class="col-md-12"> </div>
<div class="col-md-2">
<label>Lab</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-7">
<select id="txt_lab" class="form-control" onchange="changeSearching(3)">
<option value='0'>-- Please Select --</option>
<option value='All'>All Unit</option>
<?php
getLab();
?>
</select>
</div>
<div class="col-md-12"> </div>
<div class="col-md-2">
<label>Year</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-2">
<select id="txt_year" class="form-control" onchange="changeSearching(3)">
<option value='0'>-- Please Select --</option>
<option value='All'>All Years</option>
<?php
$year = "2000";
$curYear = date("Y");
while ($curYear >= $year) {
echo "<option value='" . $curYear . "'>" . $curYear . "</option>";
$curYear--;
}
?>
</select>
</div>
<div class="col-md-12"> </div>
<div class="col-md-12" align="right">
<button class="btn btn-primary btn-sm" onclick="carian(3)"><i class="fa fa-search"></i> Search</button>
</div>
<?php
}
?>
<div class="col-md-12" id="viewSearch"></div>
</div>
<?php
} elseif ($id == 30) {
?>
<div class="tab-content pn br-n admin-form">
<?php
if ($code == 1) {
?>
<input type="hidden" id="mainTitle" value="General Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-4">
<select class="form-control" id="searchBy" onchange="changeSearch(2)">
<option value="0">-- Please Select --</option>
<option value="1">Product Name</option>
<option value="2">Sample Number</option>
<option value="3">Batch Number</option>
<option value="4">Reference Number</option>
<option value="5">Registration Number</option>
<option value="6">Product Category</option>
<option value="7">Holder</option>
<option value="8">Manufacturer</option>
<option value="9">Active Substance</option>
<option value="10">Received Date</option>
<option value="11">Approval Date</option>
<option value="12">Reject Date</option>
</select>
</div>
<div class="col-md-12"> </div>
<div class="col-md-2">Search</div>
<div class="col-md-1">:</div>
<div class="col-md-4" id="changeSearch">
<label for="searchTxt" class="field prepend-icon">
<input type="text" id="searchTxt" class="gui-input" placeholder="Search">
<label class="field-icon">
<i class="fa fa-search"></i>
</label>
</label>
</div>
<div class="col-md-12"> </div>
<div class="col-md-12" align="right">
<button class="btn btn-alert btn-sm" onclick="carian(2)"><i class="fa fa-search"></i> Search</button>
</div>
<?php
} else {
?>
<input type="hidden" id="mainTitle" value="Status Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-9" id="ProtocolStatus">
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_01" name="ProtocolStatus" checked="true" onclick="changeSearching(4)">
<label for="ProtocolStatus_01">Sample Under Testing</label>
</div>
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_02" name="ProtocolStatus" onclick="changeSearching(4)">
<label for="ProtocolStatus_02">Waiting for Result Approval</label>
</div>
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_03" name="ProtocolStatus" onclick="changeSearching(4)">
<label for="ProtocolStatus_03">Pass Samples</label>
</div>
<div class="radio-custom mb5">
<input type="radio" id="ProtocolStatus_04" name="ProtocolStatus" onclick="changeSearching(4)">
<label for="ProtocolStatus_04">Fail Samples</label>
</div>
</div>
<div class="col-md-12"> </div>
<div class="col-md-2">
<label>Lab</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-7">
<select id="txt_lab" class="form-control" onchange="changeSearching(4)">
<option value='0'>-- Please Select --</option>
<option value='All'>All Unit</option>
<?php
getLab();
?>
</select>
</div>
<div class="col-md-12"> </div>
<div class="col-md-2">
<label>Year</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-2">
<select id="txt_year" class="form-control" onchange="changeSearching(4)">
<option value='0'>-- Please Select --</option>
<option value='All'>All Years</option>
<?php
$year = "2000";
$curYear = date("Y");
while ($curYear >= $year) {
echo "<option value='" . $curYear . "'>" . $curYear . "</option>";
$curYear--;
}
?>
</select>
</div>
<div class="col-md-12"> </div>
<div class="col-md-12" align="right">
<button class="btn btn-alert btn-sm" onclick="carian(4)"><i class="fa fa-search"></i> Search</button>
</div>
<?php
}
?>
<div class="col-md-12" id="viewSearch"></div>
</div>
<?php
} elseif ($id == 31) {
$query = "SELECT pp_kod,pp_ref_no,pp_nama,pp_tkh_approve,pp_rs_kod,rkatp_class,rkatp_desc,pp_correspondence_counter,pp_correspondence_counter_max FROM p_product\n LEFT JOIN ref_kat_produk ON pp_rkatp_kod = rkatp_kod\n LEFT JOIN p_product_manu ON p_product_manu.ppm_pp_kod = p_product.pp_kod AND ppm_rmr_kod=1\n LEFT JOIN o_syarikat_add ON o_syarikat_add.osa_kod = p_product_manu.ppm_osa_kod\n LEFT JOIN o_syarikat ON o_syarikat.os_kod = o_syarikat_add.osa_os_kod\n LEFT JOIN lab_assign ON la_pp_kod=pp_kod\n WHERE pp_status_nopayment=2 AND pp_rs_kod IN (1110,1103,1107)\n AND la_ru_kod='" . $_SESSION['ru_kod'] . "' AND la_rs_kod IN (1110) AND la_us_id='" . $_SESSION['us_id'] . "' GROUP BY pp_kod";
$result = selQuery($query);
?>
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="primary" align="center">
<td width="15%">Reference No</td>
<td width="45%">Product Name</td>
<td width="30%">Status</td>
<td width="10%"> </td>
</tr>
</thead>
<tbody>
<?php
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $row['pp_ref_no'];
?>
</td>
<td align="left">
<div class="text-primary">
<b><?php
if ($row['pp_rs_kod'] == 1110) {
echo $row['pp_nama'];
} else {
?>
<a style="cursor:pointer;" onclick="corrDetail('<?php
echo $row['pp_kod'];
?>
')"><?php
echo $row['pp_nama'];
?>
</a>
<?php
}
?>
</b>
</div>
<div class="text-muted"><?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div>
</td>
<td>
<?php
if ($row['pp_rs_kod'] == 1110) {
echo "WAITING FOR USER REPLY";
} elseif ($row['pp_rs_kod'] == 1107) {
echo "USER CORRESPOND";
} else {
echo "WAITING FOR OTHER DEPARTMENT";
}
?>
</td>
<td>
<?php
echo $row['pp_correspondence_counter'] . " of " . $row['pp_correspondence_counter_max'];
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
} elseif ($id == 32) {
// $query = "SELECT kpd_kp_id,kpd_pp_kod,kpd_sender_name FROM k_produk_det limit 15000";
// $result = selQuery($query);
// $count = 0;
// while($row = mysqli_fetch_assoc($result)) {
// $upd = "UPDATE k_produk SET kp_sampleID='".$row['kpd_pp_kod']."',kp_sender='".$row['kpd_sender_name']."' WHERE kp_id='".$row['kpd_kp_id']."'";
// executeQuery($upd);
// $count++;
// }
// echo $count;
if ($code == 1) {
// $query = "SELECT kp_id,kp_rpjp_id FROM k_produk WHERE kp_rpjp_id IS NOT NULL order by kp_id asc LIMIT 10000";
// $result = selQuery($query);
// while($row = mysqli_fetch_assoc($result)) {
// $upd = "UPDATE k_produk SET kp_rsc_kod='".$row['kp_rpjp_id']."' WHERE kp_id='".$row['kp_id']."'";
// //echo $upd;
// executeQuery($upd);
//
// }
// echo $query;
// $query = "SELECT kpd_kp_id,kpd_pp_kod,kpd_sender_name FROM k_produk_det order by kpd_id ASC LIMIT 1500";
// $result = selQuery($query);
// while($row = mysqli_fetch_assoc($result)) {
// $upd = "UPDATE k_produk SET kp_sampleID='".$row['kpd_pp_kod']."',kp_sender='".$row['kpd_sender_name']."'
// WHERE kp_id='".$row['kpd_kp_id']."'";
// executeQuery($upd);
//
// }
//echo $upd;
?>
<div class="tab-content pn br-n admin-form">
<input type="hidden" id="mainTitle" value="Home" />
<div class="row">
<label class="field prepend-icon">
<input type="text" id="txt_scan" class="gui-input" placeholder="Scan Barcode" onchange="scanItem()">
<label for="txt_scan" class="field-icon">
<i class="fa fa-barcode"></i>
</label>
</label>
</div>
<div class="row" id="storeList">
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="system" align="center">
<td width="2%"> </td>
<td width="10%">Sample No</td>
<td width="45%">Product Name</td>
<td width="8%">Batch No</td>
<td width="10%">Quantity</td>
<td width="10%">Unit</td>
<td width="15%">Status</td>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT kp_id,kp_sampel_no,kp_batch_no,kp_product_name,kp_kuantiti_htr,\n kp_rskt_kod,kp_rkatp_kod,kp_requestSpl FROM k_lab\n LEFT JOIN k_produk ON kp_id=klb_kp_id\n WHERE klb_rlog_id IS NULL\n GROUP BY klb_ru_kod,klb_kp_id";
$result = selQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><input type="checkbox" value="<?php
echo $row["kp_id"];
?>
"></td>
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<div class="text-primary">
<b><a style="cursor:pointer;" onclick="viewSample('<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b>
</div>
<div class="text-muted">
<?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div>
</td>
<td align="left"><?php
echo $row['kp_batch_no'];
?>
</td>
<td align="left"><?php
echo $row['kp_kuantiti_htr'];
?>
</td>
<td align="left"><?php
echo getSukatan($row['kp_rskt_kod'], 1);
?>
</td>
<td align="left">
<?php
if ($row['kp_requestSpl'] == 0) {
echo "New Sample";
} else {
echo "Ready to Collect";
}
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div class="row" align="right">
<div class="btn-group">
<button type="button" class="btn btn-system dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
Action<span class="caret ml5"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a onclick="readyCollect()">Ready to Collect</a></li>
</ul>
</div>
</div>
<div class="row" id="scanList"><?php
scanList();
?>
</div>
</div>
<?php
} else {
?>
<input type="hidden" id="mainTitle" value="Collection History" />
<div class="row">
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
<thead>
<tr class="system" align="center">
<td width="10%">Sample No</td>
<td width="40%">Product Name</td>
<td width="30%">Lab</td>
<td width="10%">Date Collect</td>
<td width="10%">Collect By</td>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT kp_id,kp_sampel_no,kp_product_name,kp_batch_no,kp_kuantiti_htr,\n kp_rskt_kod,kst_ru_kod,kst_tkh_ambil,kst_collect_by,rkatp_class,rkatp_desc FROM k_stor\n LEFT JOIN k_produk ON k_produk.kp_id=k_stor.kst_kp_id\n LEFT JOIN ref_kat_produk ON rkatp_kod=kp_rkatp_kod\n ORDER BY kst_tkh_ambil";
$result = selQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td><?php
echo $row['kp_sampel_no'];
?>
</td>
<td align="left">
<div class="text-primary">
<b><a style="cursor:pointer;" onclick="viewSample('<?php
echo $row['kp_id'];
?>
')"><?php
echo $row['kp_product_name'];
?>
</a></b>
</div>
<div class="text-muted">
<?php
echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
?>
</div>
</td>
<td align="left"><?php
echo retriveLab($row['kst_ru_kod']);
?>
</td>
<td><?php
echo displayDate($row['kst_tkh_ambil']);
?>
</td>
<td align="left"><?php
echo $row['kst_collect_by'];
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
}
} elseif ($id == 33) {
?>
<div class="tab-content pn br-n admin-form">
<?php
if ($code == 1) {
$title = "Protocol";
} else {
$title = "Sample";
}
?>
<input type="hidden" id="mainTitle" value="<?php
echo $title;
?>
" />
<div class="col-md-12"> </div>
<div class="col-md-6">
<label for="reportName" class="field-label">Report Name</label>
<select id="reportName" class="form-control" onchange="viewReport()">
<option value="0" >-- Please Select --</option>
<?php
if ($code == 1) {
$query = "SELECT report_id,report_name FROM ref_lab_report\n WHERE report_type=1 AND report_active=1";
} else {
$query = "SELECT report_id,report_name FROM ref_lab_report\n WHERE report_type=2 AND report_active=1";
}
$result = selQuery($query);
while ($row = mysqli_fetch_assoc($result)) {
echo "<option value='" . $row['report_id'] . "'>" . $row['report_id'] . $row['report_name'] . "</option>";
}
?>
</select>
</div>
<div class="col-md-2">
<label for="reportYear" class="field-label">Year</label>
<select id="reportYear" class="form-control" onchange="viewReport()">
<?php
$year = "2000";
$curYear = date("Y");
while ($curYear >= $year) {
echo "<option value='" . $curYear . "'>" . $curYear . "</option>";
$curYear--;
}
?>
</select>
</div>
<div class="col-md-12"> </div>
<div class="col-md-12" id="showReport"></div>
</div>
<?php
}
}
}
/**
* Adds or updates services ports
*
* @throws iMSCP_Exception
* @param string $mode Mode in witch act (add or update)
* @return void
*/
function admin_addUpdateServices($mode = 'add')
{
/** @var $dbConfig iMSCP_Config_Handler_Db */
$dbConfig = iMSCP_Registry::get('dbConfig');
// Create a pool for error fields ids and gets a reference to him
$errorFieldsIds =& iMSCP_Registry::set('errorFieldsIds', array());
if ($mode == 'add') {
// Adds a service port
$port = $_POST['port_new'];
$protocol = $_POST['port_type_new'];
$name = strtoupper($_POST['name_new']);
$show = $_POST['show_val_new'];
$ip = $_POST['ip_new'];
if (admin_validatesService($name, $ip, $port, $protocol, $show)) {
$dbServiceName = "PORT_{$name}";
$dbConfig[$dbServiceName] = "{$port};{$protocol};{$name};{$show};{$ip}";
write_log($_SESSION['user_logged'] . ": Added service port {$name} ({$port})!", E_USER_NOTICE);
}
} elseif ($mode == 'update') {
// Updates one or more services ports
// Reset counter of update queries
$dbConfig->resetQueriesCounter('update');
foreach ($_POST['name'] as $index => $name) {
$port = $_POST['port'][$index];
$protocol = getProtocol($index);
$name = strtoupper($name);
$show = $_POST['show_val'][$index];
$ip = $_POST['ip'][$index];
if (admin_validatesService($name, $ip, $port, $protocol, $show, $index)) {
$dbServiceName = $_POST['var_name'][$index];
$dbConfig[$dbServiceName] = "{$port};{$protocol};{$name};{$show};{$ip}";
}
}
} else {
throw new iMSCP_Exception('admin_addUpdateServices(): Wrong argument for $mode');
}
if (!empty($errorFieldsIds)) {
toSession($mode);
} elseif ($mode == 'add') {
set_page_message(tr('Service port successfully addeds'), 'success');
} else {
$updateCount = $dbConfig->countQueries('update');
if ($updateCount > 0) {
set_page_message(tr('%d Service(s) port successfully updateds', $updateCount), 'success');
} else {
set_page_message(tr('Nothing has been changed.'), 'info');
}
}
}
*/
require_once 'config.php';
require_once 'utils.php';
if (!isset($config) || !is_array($config)) {
die("broken or missing configuration file?");
}
date_default_timezone_set(getConfig($config, 'time_zone', FALSE, 'Europe/Amsterdam'));
set_include_path(get_include_path() . PATH_SEPARATOR . getConfig($config, "smarty_lib_dir", TRUE));
$view = getRequest('fmt', FALSE, 'html');
if (!in_array($view, array('html', 'os'))) {
die("invalid view");
}
require_once "Smarty.class.php";
$smarty = new Smarty();
$smarty->template_dir = 'tpl';
$smarty->compile_dir = 'tpl_c';
$smarty->assign('css_url', getProtocol() . getServerName() . dirname($_SERVER['PHP_SELF']) . '/s/style.css');
$smarty->assign('js_url', getProtocol() . getServerName() . dirname($_SERVER['PHP_SELF']) . '/j/' . $view . '.js');
$smarty->assign('js_common_url', getProtocol() . getServerName() . dirname($_SERVER['PHP_SELF']) . '/j/common.js');
$smarty->assign('protocol', getProtocol());
$content = $smarty->fetch('content.tpl');
$smarty->assign('content', $content);
if ($view === "os") {
/* Disable Caching */
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
// Date in the past
header("Content-Type: text/xml");
}
$smarty->display($view . '.tpl');
*/
require_once 'config.php';
require_once 'utils.php';
require_once 'lib/StorageClient/StorageClient.class.php';
/* Disable Caching */
header("Cache-Control: no-cache, must-revalidate");
// HTTP/1.1
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
// Date in the past
if (!isset($config) || !is_array($config)) {
die("broken or missing configuration file?");
}
date_default_timezone_set(getConfig($config, 'time_zone', FALSE, 'Europe/Amsterdam'));
try {
if (getConfig($config, 'ssl_only', FALSE, FALSE)) {
if (getProtocol() != "https://") {
throw new Exception("only available through secure connection");
}
}
set_include_path(get_include_path() . PATH_SEPARATOR . getConfig($config, "oauth_lib_dir", TRUE));
$params = $_REQUEST;
$endpoint = $params['proxy_to'];
$key = $params['proxy_consumer_key'];
$secret = $params['proxy_consumer_secret'];
$action = $params['action'];
unset($params['proxy_to']);
unset($params['proxy_consumer_key']);
unset($params['proxy_consumer_secret']);
unset($params['action']);
$sc = new StorageClient(array('apiUrl' => $endpoint, 'consumerKey' => $key, 'consumerSecret' => $secret));
echo $sc->call($action, $params, $_SERVER['REQUEST_METHOD']);
function getUploadToken()
{
requireRequestMethod("POST");
/* FIXME: token should expire, based on server request? */
/* FIXME: what if upload size is not known in time? transcode web service for example... */
$absPath = $this->validatePath(getRequest('relativePath', TRUE), FTS_PARENT);
/* make sure the uploaded file name is unique */
$absPath = $this->getUniqueName($absPath);
/* verify fileSize
*
* NOTE: fileSize *is* required, but 0 is a valid file size, but also
* seen as "empty" by PHP, so we work around it like this...
*/
$fileSize = (int) getRequest('fileSize', FALSE, 0);
if ($fileSize < 0) {
throw new Exception("invalid filesize");
}
$token = generateToken();
try {
$stmt = $this->dbh->prepare("INSERT INTO uploadTokens (token, filePath, fileSize) VALUES (:token, :filePath, :fileSize)");
$stmt->bindParam(':token', $token);
$stmt->bindParam(':filePath', $absPath);
$stmt->bindParam(':fileSize', $fileSize);
$stmt->execute();
$uploadLocation = getProtocol() . getServerName() . $_SERVER['PHP_SELF'] . "?action=uploadFile&token={$token}";
return array("uploadLocation" => $uploadLocation, "absPath" => $absPath);
} catch (Exception $e) {
throw new Exception("database query failed");
}
}
