?> </th><th><?php te("Buyer"); ?> </th><th><?php te("Date"); ?> </th> <th><?php te("Order No"); ?> </th><th><?php te("Description"); ?> </th><th><?php te("Associated Files"); ?> </th></tr> </thead> <tbody> <?php $i = 0; /// print actions list while ($r = $sth->fetch(PDO::FETCH_ASSOC)) { $i++; $f = invid2files($r['id'], $dbh); //create file links $flnk = ""; for ($lnk = "", $c = 0; $c < count($f); $c++) { $fname = $f[$c]['fname']; $fid = $f[$c]['id'];
} ?> </select> </td> </tr> <tr> <th><?php te('LABEL_DAYLIGHT_SAVING'); ?> :</th> <td> <input type="checkbox" name="enable_daylight_saving" <?php echo $config['enable_daylight_saving'] ? 'checked' : ''; ?> ><?php te('TEXT_OBSERVE_DAYLIGHT_SAVINGS'); ?> </td> </tr> </table> <table width="100%" border="0" cellspacing=0 cellpadding=2 class="tform"> <tr class="header"><td colspan=2>Ticket Options & Settings</td></tr> <tr class="subheader"><td colspan=2>If enabled ticket lock get auto-renewed on form activity.</td></tr> <tr><th valign="top">Ticket IDs:</th> <td> <input type="radio" name="random_ticket_ids" value="0" <?php echo !$config['random_ticket_ids'] ? 'checked' : ''; ?> /> Sequential <input type="radio" name="random_ticket_ids" value="1" <?php
?> <sup>*</sup></th> <th><?php te("Depth"); ?> </th> <th><?php te("Location"); ?> </th> <th><?php te("Area/Room"); ?> </th> <th><?php te("Label"); ?> </th> </tr> </thead> <tbody> <?php $i = 0; /// print actions list while ($r = $sth->fetch(PDO::FETCH_ASSOC)) { $i++; $occupation = (int) $r['occupation']; echo "\n<tr>"; //echo "<td class='tdc' ><a href='$scriptname?action=viewrack&id={$r['id']}'><img src='images/eye.png' width=20></a></td>\n"; echo "<td><a class='editid' href='{$scriptname}?action=editrack&id=" . $r['id'] . "'>{$r['id']}</a></td>\n";
?> <option value="close" <?php echo $info['do'] == 'close' ? 'selected' : ''; ?> ><?php te('LABEL_STAFF_VIEWTICKET_CLOSE_TICKET'); ?> </option> <?php } else { ?> <option value="reopen" <?php echo $info['do'] == 'reopen' ? 'selected' : ''; ?> ><?php te('LABEL_STAFF_VIEWTICKET_REOPEN_TICKET'); ?> </option> <?php } } ?> <?php if ($thisuser->canManageBanList()) { if (!$emailBanned) { ?> <option value="banemail"> Ban Email <?php echo $ticket->isOpen() ? '& Close' : ''; ?>
</th><th><?php te("Supports<br>Software"); ?> <sup>1</sup></th></tr> <tr><td colspan=1><?php te("New"); ?> :</td><td> <input name='newtype' type='text'></td> <td><select name='newhassoftware'> <option value='0'><?php te("No"); ?> </option> <option value='1'><?php te("Yes"); ?> </option></select></td> </tr> <tr><td style='text-align: right' colspan=4><button type="submit"><img src="images/save.png" alt="Save" > Save</button></td></tr> <tr><td style='text-align: left' colspan=4> <sup>1</sup><?php te("Select 'YES' if software can be installed <b>on</b> this item.<br> Only items supporting software are listed when <br>performing software - item associations"); ?> </td></tr> </tbody> </table> </form>
</button></td></tr> <tr><td style='text-align: left' colspan=4> </td></tr> </table> </form> </div> <div style='text-align:left;float:left;margin-left:50px;min-width:350px;max-width:500px;min-height:300px;border:1px solid #fff;' id='itemresults'><?php te("Click on Item count column on the left to display associated items"); ?> </div> <div style='text-align:left;float:left;margin-left:50px;min-width:350px;max-width:500px;min-height:300px;border:1px solid #fff;' id='softwareresults'><?php te("Click on Software count column on the left to display associated software"); ?> </div> <script> $(document).ready(function(){ $(".showitems" ).click(function() { $("#itemresults").html('<center><img src="images/ajaxload.gif"></center>').load('php/tag2item_ajaxlist.php?tagid='+ $(this).attr('href')); return false; }); $(".showsoftware" ).click(function() { $("#softwareresults").html('<center><img src="images/ajaxload.gif"></center>').load('php/tag2software_ajaxlist.php?tagid='+ $(this).attr('href')); return false; });
<?php /* Spiros Ioannou 2009 , sivann _at_ gmail.com */ require "../init.php"; if ($itemid == "new") { te("Cannot add log entries to unsaved items."); exit; } ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" > <script> function filltoday() { var mydate= new Date() var theyear=mydate.getFullYear() var themonth=mydate.getMonth()+1 var thetoday=mydate.getDate() var x=document.getElementById('newdate').value; if (x.length==0) { <?php if ($settings['dateformat'] == "ymd") { ?> document.getElementById('newdate').value=theyear+"-"+themonth+"-"+thetoday; <?php } elseif ($settings['dateformat'] == "dmy") { ?>
?> </th> <th><?php te("Type"); ?> </th> <th style='min-width:300px'><?php te("Title"); ?> </th> <th><?php te("File"); ?> </th> <th><?php te("Associations"); ?> </th> </tr> </thead> <tbody> <?php $i = 0; /// print actions list while ($r = $sth->fetch(PDO::FETCH_ASSOC)) { $i++; $nlinks = countfileidlinks($r['id'], $dbh); $type = $r['typedesc']; if ($type == "invoice") { $type = "<span style='color:#0076A0'>{$type}</span>"; }
?> </th> <th width='20%' nowrap><?php te("Location Name/Building Name"); ?> </th> <th width='10%'><?php te("Floor"); ?> </th> <th width='40%'><?php te("Area Names/Offices"); ?> </th> <th><?php te("Floor Plan"); ?> </th> </tr> </thead> <tbody> <?php $i = 0; /// print actions list while ($r = $sth->fetch(PDO::FETCH_ASSOC)) { $i++; echo "\n<tr>"; echo "<td><a class='editid' href='{$scriptname}?action=editlocation&id=" . $r['id'] . "'>{$r['id']}</a></td>\n"; echo "<td>{$r['name']}</td>\n"; echo "<td>{$r['floor']}</td>\n"; echo "<td>{$r['areaname']}</td>\n";
function strto($to, $str) { define('cs', 'utf-8'); if (!function_exists('rp')) { function rp($i, $str) { $B = array('I', 'Ğ', 'Ü', 'Ş', 'İ', 'Ö', 'Ç'); $k = array('ı', 'ğ', 'ü', 'ş', 'i', 'ö', 'ç'); $Bi = array(' I', ' ı', ' İ', ' i'); $ki = array(' I', ' I', ' İ', ' İ'); if ($i == 1) { return str_replace($B, $k, $str); } elseif ($i == 2) { return str_replace($k, $B, $str); } elseif ($i == 3) { return str_replace($Bi, $ki, $str); } } } if (!function_exists('cf')) { function cf($c = array(), $str) { foreach ($c as $cc) { $s = explode($cc, $str); foreach ($s as $k => $ss) { $s[$k] = strto('ucfirst', $ss); } $str = implode($cc, $s); } return $str; } } if (!function_exists('te')) { function te() { return trigger_error('Lütfen geçerli bir strto() parametresi giriniz.', E_USER_ERROR); } } $to = explode('|', $to); if ($to) { foreach ($to as $t) { if ($t == 'lower') { $str = mb_strtolower(rp(1, $str), cs); } elseif ($t == 'upper') { $str = mb_strtoupper(rp(2, $str), cs); } elseif ($t == 'ucfirst') { $str = mb_strtoupper(rp(2, mb_substr($str, 0, 1, cs)), cs) . mb_substr($str, 1, mb_strlen($str, cs) - 1, cs); } elseif ($t == 'ucwords') { $str = ltrim(mb_convert_case(rp(3, ' ' . $str), MB_CASE_TITLE, cs)); } elseif ($t == 'capitalizefirst') { $str = cf(array('. ', '.', '? ', '?', '! ', '!', ': ', ':'), $str); } else { $str = te(); } } } else { $str = te(); } return $str; }
<input type=hidden name="table" value="contractevents"> <input type=hidden name="contractid" value="<?php echo $id; ?> "> <input type=submit> </form> </div> <div id="ev_deldialog" title="Delete Event" method="post" style='display:none'> <form name="evtdelfrm" method="post" id="evtdelfrm" action="php/contractevents.php"> <b><?php te("Delete Event?"); ?> <br></b> <input type=text name='deleventid' value='new' readonly> <input type=hidden name="contractid" value="<?php echo $id; ?> "> <input type=submit value='<?php te("Delete"); ?> '> </form> </div>
</ul> <input type=hidden name='action' value='<?php echo $action; ?> '> </form> </td></tr> </table> <?php echo "\n<form id='mainform' method=post action='{$scriptname}?action={$action}' enctype='multipart/form-data' name='transfrm'>\n"; ?> <table class="tbl2" > <tr><td class="tdt"><?php te("Language"); ?> </td><td> <select id='langsel' name='lang'> <?php if ($lang == "en") { $s = "SELECTED"; } else { $s = ""; } ?> <option <?php echo $s; ?> value=''>en</option> <?php
</script> <?php if (!isset($_POST['update'])) { ?> <div id=messagetxt style='margin-left:auto;margin-right:auto;width:800px;'> <div style='background-color:#eee;border:1px solid #aaa;padding:5px;'> <?php if ($fordbversion < dbversion()) { echo "It seems that you have replaced the ITDB installation with an older version, but not the the database which is newer version than the software. This will probably lead to data corruption. Please update ITDB files to the newest version<br>\n"; } else { ?> You have updated your ITDB installation (files). To complete the upgrade, database to the same version.<br> Please take a backup of your database if you haven't done so yet right now, by downloading the file: <a style='font-size:12px;' title='<?php te("Download DataBase file. Contains all data except uploaded files/documents"); ?> ' href='getdb.php'> <img src='images/database_save.png'> Download Database (SQLite)</a><br> When finished, click <button id='updtbtn' type=submit>update</button> to update the database to the latest version. <br> </div> <div style='background-color:#fee;margin-top:10px;border:1px solid #aaa;padding:5px;' > <?php echo "Database version=" . dbversion() . "<br>"; echo "Installation version={$fordbversion}"; echo "</div>"; echo "</div>"; } } else {
$iid = $ri[$i]['id']; $idate = date($dateparam, $ri[$i]['id']); for ($flnk = "", $c = 0; $c < count($f); $c++) { $fname = $f[$c]['fname']; $ftitle = $f[$c]['title']; $flnk .= " <a target=_blank title='View FILE: {$ftitle} {$fname}' href='" . $uploaddirwww . $fname . "'><img src='images/down.png'></a>"; } $invinfo .= "<div style='min-width:70px;'><a title='Edit INVOICE' href='{$scriptname}?action=editinvoice&id={$iid}'><div class='editid'>{$iid}</div><div>{$flnk}</div></a></div>"; $flnk = ""; } //if (!($row%2)) $s=" class='dark' "; else $s=""; ?> <tr> <td><div class='editid'><a title='<?php te("Edit Software"); ?> ' href='<?php echo $scriptname; ?> ?action=editsoftware&id=<?php echo $r['id']; ?> '><?php echo $id; ?> </a></div> </td> <?php if ($licqty < $licitems) {
?> </th> <th width='5%'><?php te("Username"); ?> </th> <th><?php te("User Description"); ?> </th> <th><?php te("Type"); ?> </th> <th width='5%'><?php te("Items"); ?> </th> </tr> </thead> <tbody> <?php $usertype[0] = t("Full Access"); $usertype[1] = t("Read Only"); $usertype[2] = t("copied from LDAP (read only)"); $i = 0; while ($r = $sth->fetch(PDO::FETCH_ASSOC)) { $i++; $itemcount = countitemsofuser($r['id']); echo "\n<tr>";
//showlist1("agents","title"); ?> <li id='agents:items' class='jstree-closed'><?php te("H/W Manufacturers"); ?> </li> <li id='agents:software' class='jstree-closed'><?php te("S/W Manufacturers"); ?> </li> <li id='agents:vendors' class='jstree-closed'><?php te("Vendors"); ?> </li> <li id='agents:buyers' class='jstree-closed'><?php te("Buyers"); ?> </li> <?php } elseif (strstr($id, "users:")) { $x = explode(":", $id); $user_id = $x[1]; $sql = "select items.id,agents.title || ' ' || items.model || ' [' || itemtypes.typedesc || ', ID:' || items.id || ']' " . " AS nodetext from items,agents,itemtypes " . " WHERE items.itemtypeid=itemtypes.id AND userid={$user_id} AND agents.id=items.manufacturerid ORDER BY agents.title"; showlist2($sql, "items", "jstree-leaf", "{$wscriptdir}/index.php?action=edititem&id="); } elseif (strstr($id, "itemtypes:")) { $x = explode(":", $id); $type_id = $x[1]; $sql = "select items.id,agents.title || ' ' || items.model || ' [' || itemtypes.typedesc || ', ID:' || items.id || ']' " . " as nodetext FROM items,agents,itemtypes " . " WHERE items.itemtypeid=itemtypes.id AND agents.id=items.manufacturerid " . " AND items.itemtypeid={$type_id} ORDER BY agents.title"; showlist2($sql, "items", "jstree-leaf", "{$wscriptdir}/index.php?action=edititem&id="); } elseif (strstr($id, "agents:items")) { $sql = "SELECT id,agents.title as nodetext FROM agents WHERE type&8 order by nodetext";
?> </th> <th><?php te("Number"); ?> </th> <th width='40%'><?php te("Title"); ?> </th> <th><?php te("Start Date"); ?> </th> <th><?php te("End Date"); ?> </th> </tr> </thead> <tbody> <?php $i = 0; /// print actions list while ($r = $sth->fetch(PDO::FETCH_ASSOC)) { $i++; echo "\n<tr id='trid{$r['id']}'>"; echo "<td><a class='editid' href='{$scriptname}?action=editcontract&id=" . $r['id'] . "'>{$r['id']}</a></td>\n"; echo "<td>{$r['parentid']}</td>\n"; echo "<td>{$r['name']}</td>\n"; echo "<td>{$r['number']}</td>\n";
?> </th> <th><?php te("Type"); ?> </th> <th style='width:160px'><?php te("Title"); ?> </th> <th style='width:150px'><?php te("Contact"); ?> </th> <th><?php te("Contacts"); ?> </th> </tr> </thead> <tbody> <?php $i = 0; /// print actions list while ($r = $sth->fetch(PDO::FETCH_ASSOC)) { $i1++; $type = ""; if ($r['type'] & 1) { $type .= "<span style='color:#b00;'>Buyer</span>"; } if ($r['type'] & 2) {
&type=invoice&assoctable=invoice2file&colname=invoiceid&defdate=<?php echo urlencode($d); ?> " frameborder="0" allowtransparency="true"></iframe> </td> </tr> </table> </div><!-- tab5 --> </div><!-- tab container --> <table> <tr><td><button type="submit"><img src="images/save.png" alt="Save" > <?php te("Save Invoice"); ?> </button></td> <?php echo "\n<td><button type='button' onclick='javascript:delconfirm2(\"{$r['id']}\",\"{$scriptname}?action={$action}&delid={$r['id']}\");'>" . "<img title='delete' src='images/delete.png' border=0> Delete Invoice</button></td>\n</tr>\n"; echo "\n</table>\n"; echo "\n<input type=hidden name='action' value='{$action}'>"; echo "\n<input type=hidden name='id' value='{$id}'>"; ?> </form> </body> </html>
<h1><?php te("Data Browser"); ?> </h1> <script type="text/javascript"> </script> <?php if (!isset($initok)) { echo "do not run this script directly"; exit; } ?> <script> $(function () { $("#tree1").jstree({ "themes" : { "theme" : "apple", //apple, classic, default "dots" : true, "icons" : true }, "core" : { "animation" : 0 }, "html_data" : { "ajax" : {
if ($wantraligntext) { echo "CHECKED"; } ?> name=wantraligntext></td></tr> <tr><td class='tdt'><label for=labelskip><?php te("Skip"); ?> :</label></td><td title='<?php te("use when the top labels have already been printed"); ?> ' ><input size=4 value='<?php echo $labelskip; ?> ' name=labelskip> <?php te("labels"); ?> </td></tr> </table> </div> </form> </div><!-- container --> </body> </html>
} else { $sqlsrch = ""; $where = ""; } $reports = array('itemperagent' => t('Number of items per Manufacturer (Agent)'), 'softwareperagent' => t('Number of installed Software per Manufacturer (Agent)'), 'invoicesperagent' => t('Number of invoices per Vendor (Agent)'), 'itemsperlocation' => t('Number of items per Location'), 'percsupitems' => t('Number of Items under support'), 'itemlistperlocation' => t('Item list per location'), 'itemsendwarranty' => t('Items with warranty end date close to (before or after) today'), 'allips' => t('List items with defined IPv4 numbers'), 'noinvoice' => t('Items without invoices'), 'nolocation' => t('Items without location'), 'depreciation3' => t('Item depreciation value 3 years'), 'depreciation5' => t('Item depreciation value 5 years')); ?> <h1><?php te("Reports"); ?> </h1> <div style='width:100%;clear:both;'> <div style='float:left;text-align:left;padding:5px;height:350px;overflow-y:auto;width:300px;border:1px solid #cecece;'> <h2><?php te("Select Report"); ?> </h2> <ul> <?php $curdesc = ""; foreach ($reports as $q => $desc) { if ($q == $query) { echo "<li><b><a href='{$scriptname}?action={$action}&query={$q}'>{$desc}</a></b></li>"; $curdesc = $desc; } else { echo "<li><a href='{$scriptname}?action={$action}&query={$q}'>{$desc}</a></li>"; } } ?>
<div><a title='<?php te("Tags"); ?> ' href='<?php echo $scriptname; ?> ?action=edittags'><img class='bigblocklnk' src='images/big/tag.png'> <span class="lnktxt"><?php te("Tags"); ?> </span></a></div> </div> <div class='bigblockdesc'> <div class='bigblocktitle'><?php te("Settings"); ?> </div> <?php te("Manage various parameters"); ?> <br> <?php te("Users, Tags, Dates, Currency,..."); ?> </div> </div> <div style='clear:both'> </div>
<input type=hidden name='action' value='<?php echo $action; ?> '> <input type=hidden name='id' value='<?php echo $id; ?> '> </form> </td> <td class="tdtop"> <h3><?php te("Areas: rooms, offices"); ?> </h3> <div class='scrltblcontainer4' id='locareas'> <?php //include ajax form which returns itself updated if ($id != "new") { require 'php/locareas.php'; } else { echo t("Save new location first to define areas onto it"); } ?> </div>
<?php } if (strstr($authmsg, "elcome") || strstr($authmsg, "thenticated")) { echo "<div class=info>{$authmsg}</div><br>"; } elseif (!strstr($authmsg, "elcome")) { echo "<br><div class=warning>{$authmsg}</div>"; } if ($authstatus) { ?> <a title='<?php te("Download DataBase file. Contains all data except uploaded files/documents"); ?> ' class='ahdr' href='getdb.php'><img src='images/database_save.png'>DB (SQLite)</a><br> <a title='<?php te("Download a complete installation backup (much larger)"); ?> ' class='ahdr' href='gettar.php'><img src='images/backup.gif' width=20>Full Backup</a><br> <?php } echo "<br> <small>" . "<a href='CHANGELOG.txt' class='ahdr'>Version {$version}</a><br><a style='color:white' href='http://www.sivann.gr/software/itdb/'>sivann</a></small>\n"; ?> <br> <a title='phpinfo' href='phpinfo.php'><img src='images/infosmall.png'></a> </div> <!-- END OF #leftcolumn --> <div id='mainpage'> <?php if ($authstatus) {
</td> </tr> <?php $class = $class == 'row2' ? 'row1' : 'row2'; } //end of while. } else { //not tickets found!! ?> <tr class="<?php echo $class; ?> "><td><b><?php te('LABEL_SYSTEM_LOGS_NO_RESULTS'); ?> </b></td></tr> <?php } ?> </table> </td></tr> <?php if ($num > 0) { ?> <tr><td style="padding-left:20px">page:<?php echo $pageNav->getPageLinks(); ?> </td></tr> <?php
} else { $bcolor = "#ffffff"; } $institems .= "\t<div style='margin:0;padding:0;background-color:{$bcolor}'>" . "<a href='{$scriptname}?action=edititem&id={$ri[$i]['id']}'>{$x}</a></div>\n"; } echo $institems; } ?> </div> </div> </td> </tr> <tr> <td colspan=2> <button type="submit"><img src="images/save.png" alt="Save"> <?php te("Save"); ?> </button> <?php if ($id != 1) { echo "\n<button type='button' onclick='javascript:delconfirm2(\"{$r['id']}\",\"{$scriptname}?action={$action}&delid={$id}\",\"All items will be assigned to user [id:1].\");'>" . "<img title='delete' src='images/delete.png' border=0>" . t("Delete") . "</button>\n"; } ?> </td> </tr> </table> <input type=hidden name='id' value='<?php
<?php te('LABEL_HELPDESK_MAKE_URLS_CLICKABLE'); ?> </td> </tr> <tr><th><?php te('LABEL_HELPDESK_ENABLE_AUTO_CRON'); ?> </th> <td> <input type="checkbox" name="enable_auto_cron" <?php echo $config['enable_auto_cron'] ? 'checked' : ''; ?> > <?php te('TEXT_HELPDESK_ENABLE_CRON_CALL_ON_STAFF_ACTIVITY'); ?> </td> </tr> </table> <table width="100%" border="0" cellspacing=0 cellpadding=2 class="tform"> <tr class="header"><td colspan=2>Date & Time</td></tr> <tr class="subheader"> <td colspan=2>Please refer to <a href="http://php.net/date" target="_blank">PHP Manual</a> for supported parameters.</td> </tr> <tr><th>Time Format:</th> <td> <input type="text" name="time_format" value="<?php echo $config['time_format']; ?>
<thead> <tr><th style='width:40px;'><?php te("Edit"); ?> </th><th>ID</th><th><?php te("Related"); ?> </th> <th><?php te("Start"); ?> </th><th><?php te("End"); ?> </th><th><?php te("Description"); ?> </th></tr> </thead> <tbody> <?php if (!isset($id)) { $id = $contractid; } $sql = "SELECT * from contractevents WHERE contractid='{$id}' order by startdate,id DESC"; $sth = db_execute($dbh, $sql); while ($ir = $sth->fetch(PDO::FETCH_ASSOC)) { $rowid = $ir['id']; echo "\n<tr>"; echo "<td><img src='images/delete.png' onClick=\"javascript:\$('#ev_deldialog').data('rowid',{$rowid}).dialog({ position: {my:'left',at:'right',of:event,offset:'20 60'} }).dialog('open')\">"; echo "<img src='images/edit.png' onClick=\"javascript:\$('#ev_dialog').data('rowid',{$rowid}).dialog({ position: {my:'left',at:'right',of:event,offset:'20 60'} }).dialog('open')\"></td> ";
<th class='colhead'><?php te("IPv4"); ?> </th> <th class='colhead'><?php te("IPv6"); ?> </th> <th class='colhead'><?php te("RemAdmIP"); ?> </th> <th class='colhead'><?php te("Tags"); ?> </th> <th class='colhead'><?php te("Software"); ?> </th> </tr> </thead> <tbody> <tr> <td colspan="21" class="dataTables_empty"><?php te("Loading data from server"); ?> </td> </tr> </tbody> </table>