$Type = "01"; $Group = "01"; $asset = "001"; /* $year = $_GET['assetYear']; $Type = $_GET['assetType']; $Group = $_GET['assetGroup']; $asset = $_GET['assetCode']; */ $yearS = $year - 543; $command = "WHERE assetAddDate LIKE '%" . $year . "%' AND assetTypeCode = '" . $type . "' AND assetGroupCode = '" . $group . "'"; $arrYear = $showAsset->getShowAssetYear(); $arrType = $showType->getAssetType(); //$showGroup->setAssetTypeCode($arrType); $arrGroup = $showGroup->getAssetGroupByType("01"); $arrAsset = $showAsset->getAssetBy($command); ?> <select id="assetYearQR" onchange="changePrintQR();"> <option value="0000">ประจำปี</option> <?php while ($row = $dbAsset->fetch_array($arrYear)) { $selDate = $row['years']; $year = $selDate + 543; echo "<option value='" . $year . "'>"; echo $year . "</option>"; } ?> </select> <select id="assetTypeQR" onchange="changePrintQR();">
$yearFull = $_GET["assetYear"]; $type = $_GET["assetTypeCode"]; $group = $_GET["assetGroupCode"]; //$year = $yearFull-543; $commandSearch = "AND CONCAT(SUBSTR(C.assetYear,3,4),'/',A.assetTypeCode,'-',A.assetTypeCode,B.assetGroupCode,'-',C.assetCode) LIKE '%" . $searchCode . "%'"; $commandYear = "AND C.assetYear = '" . $yearFull . "'"; $commandType = "AND A.assetTypeCode = '" . $type . "'"; $commandGroup = "AND B.assetGroupCode = '" . $group . "'"; $commandYT = "AND C.assetYear = '" . $yearFull . "' AND A.assetTypeCode = '" . $type . "'"; $commandYTG = "AND C.assetYear = '" . $yearFull . "' AND A.assetTypeCode = '" . $type . "' AND B.assetGroupCode = '" . $group . "'"; $commandTG = "AND C.assetTypeCode = '" . $type . "' AND B.assetGroupCode = '" . $group . "'"; $commandYG = "AND C.assetYear = '" . $yearFull . "' AND B.assetGroupCode = '" . $group . "'"; //$typeCode = $_GET["id"]; //$typeCode = $_GET["id"]; $arrAll = $asset->getAsset(); $arrYear = $asset->getAssetBy($commandYear); $arrType = $asset->getAssetBy($commandType); $arrGroup = $asset->getAssetBy($commandGroup); $arrYT = $asset->getAssetBy($commandYT); $arrTG = $asset->getAssetBy($commandTG); $arrYTG = $asset->getAssetBy($commandYTG); $arrYG = $asset->getAssetBy($commandYG); $arrSearch = $asset->getAssetBy($commandSearch); if ($searchCode != null) { $cmd = $arrSearch; } else { if ($yearFull == null && $type == null && $group == null) { $cmd = $arrAll; } else { if ($yearFull != "0000" && $type == "00" && $group == "00") { $cmd = $arrYear;
session_start(); include_once '../configuration/db.php'; include_once '../configuration/ClassUser.php'; include_once '../configuration/ClassAsset.php'; include_once '../configuration/ClassCustomer.php'; include_once '../function/funcs.php'; //setup user $user = new User(); setupUser($user); //setup tkt $Asset = new Asset(); //get input id if (isset($_GET['id'])) { $token = $_GET['id']; $Asset->getAssetBy($token); } echo "\n <html>\n <head>"; if (isset($_GET['new'])) { echo "<title>OpenTroubleTicketing | New Asset </title>"; } else { echo "<title>OpenTroubleTicketing | View Asset : " . $Asset->code[0] . " </title>"; } echo "\n <meta charset='utf-8'>\n <meta name='viewport' content='width=device-width, initial-scale=1'>\n <link rel='icon' href='icon/icon.png'/>\n <link rel='stylesheet' href='../style/bootstrap.min.css'>\n <link rel='stylesheet' href='windowAssetStyle.css'>\n <link rel='stylesheet' href='../style/defaultStyle.css'>\n <script src='../js/jquery.min.js'></script>\n <script src='../js/bootstrap.min.js'></script>\n <script src='windowAssetScript.js'></script>\n <script src='../js/defaultScript.js'></script>\n </head>\n <body>\n <div class='container-fluid'>"; echo "\n <div class='row'>\n <div class='col-sm-3 col-md-3 col-lg-3>\n <label for='customerID'>ID</label><br>"; if (isset($_GET['new'])) { echo "<input type='text' class='disabled editable' id='assetCODE' value=''>"; } else { echo "<input type='text' class='disabled editable' id='assetCODE' value='" . $Asset->code[0] . "'>"; } echo " \n </div>\n <div class='col-sm-3 col-md-3 col-lg-3>\n <label for='assetType'>TYPE</label>\n <input type='text' class='disabled editable' id='assetType' value='" . $Asset->type[0] . "'>\n </div>\n <div class='col-sm-3 col-md-3 col-lg-3>\n <label for='assetModel'>MODEL</label>\n <input type='text' class='disabled editable' id='assetModel' value='" . $Asset->model[0] . "'>\n </div>\n <div class='col-sm-3 col-md-3 col-lg-3>\n <label for='assetBrand'>BRAND</label>\n <input type='text' class='disabled editable' id='assetBrand' value='" . $Asset->brand[0] . "'>\n </div>\n </div>\n <div class='row'>\n <div class='col-sm-3 col-md-3 col-lg-3>\n <label for='assetSite'>SITE</label>\n <input type='text' class='disabled editable' id='assetSite' value='" . $Asset->site[0] . "'>\n </div>\n <div class='col-sm-3 col-md-3 col-lg-3>\n <label for='assetIp'>IP</label>\n <input type='text' class='disabled editable' id='assetIp' value='" . $Asset->ip[0] . "'>\n </div>\n <div class='col-sm-3 col-md-3 col-lg-3>\n <label for='assetStatus'>STATUS</label><br>";
include_once '../configuration/ClassCustomer.php'; $token = $_POST['token']; $customer = new Customer(); if ($customer->getCustomerBy($token)) { $customer->printTabledCustomerList('active'); } else { echo 0; } } //function: search asset if (isset($_POST['searchASSETbyTOKEN'])) { include_once '../configuration/db.php'; include_once '../configuration/ClassAsset.php'; $token = $_POST['token']; $asset = new Asset(); if ($asset->getAssetBy($token)) { $asset->printTabledAssetList('active'); } else { echo 0; } } //function: update tkt if (isset($_POST['updateTKT'])) { include_once '../configuration/db.php'; include_once '../function/funcs.php'; include_once '../configuration/ClassTicket.php'; $id = $_POST['id']; $asset = sanitizeInput($_POST['asset']); $category = sanitizeInput($_POST['category']); $status = sanitizeInput($_POST['status']); $assignedTo = sanitizeInput($_POST['assignedTo']);
} $counter++; } } else { echo "No customers found"; } echo "</div>"; } } if (isset($_POST['searchAsset'])) { $str = $_POST['code']; if (strlen($str) < 3) { echo "Hints are avaiable for 3 or more chars"; } else { $assets = new Asset(); $assets->getAssetBy($str); echo "<div id='hints'>"; if ($assets->number > 0 && in_array('active', $assets->status)) { $counter = 0; while ($counter < $assets->number) { if ($assets->status[$counter] == 'active') { echo "<li><a class='assetHint' href='#" . $assets->code[$counter] . "'>" . $assets->code[$counter] . "</a></li>"; } $counter++; } } else { echo "No asset found"; } echo "</div>"; } }