Jump to content

Sticky footer!


liamloveslearning

Recommended Posts

Hi everyone, having a nightmare trying to get my sticky footer to anchor to the bttom of my browser window, it seems to just sit at the very bottom of the page, Im using a tutorial http://www.cssstickyfooter.com but it doesnt have a troubleshooting section!

 

I just need a floating footer bottom of my page, Heres my entire page with in page styles if anybody could see where im going wrong?

 

<?php require_once('Connections/intra_conn.php'); ?>

<?php


// Load the common classes
require_once('includes/common/KT_common.php');

// Load the tNG classes
require_once('includes/tng/tNG.inc.php');

// Load the required classes
require_once('includes/tfi/TFI.php');
require_once('includes/tso/TSO.php');
require_once('includes/nav/NAV.php');

// Make a transaction dispatcher instance
$tNGs = new tNG_dispatcher("");

// Make unified connection variable
$conn_intra_conn = new KT_connection($intra_conn, $database_intra_conn);

//Start Restrict Access To Page
$restrict = new tNG_RestrictAccess($conn_intra_conn, "");
//Grand Levels: Any
$restrict->Execute();
//End Restrict Access To Page

// Make unified connection variable
$conn_intra_conn = new KT_connection($intra_conn, $database_intra_conn);

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

// Filter
$tfi_listworksorders4 = new TFI_TableFilter($conn_intra_conn, "tfi_listworksorders4");
$tfi_listworksorders4->addColumn("worksorders.intrajobno", "NUMERIC_TYPE", "intrajobno", "=");
$tfi_listworksorders4->addColumn("worksorders.intratype", "NUMERIC_TYPE", "intratype", "=");
$tfi_listworksorders4->addColumn("worksorders.intrastatus", "NUMERIC_TYPE", "intrastatus", "=");
$tfi_listworksorders4->addColumn("worksorders.intracustomer", "STRING_TYPE", "intracustomer", "%");
$tfi_listworksorders4->addColumn("worksorders.intradescription", "STRING_TYPE", "intradescription", "%");
$tfi_listworksorders4->addColumn("worksorders.intraorder", "STRING_TYPE", "intraorder", "%");
$tfi_listworksorders4->addColumn("worksorders.intraartapproval", "STRING_TYPE", "intraartapproval", "%");
$tfi_listworksorders4->addColumn("worksorders.intraestimatedinstall", "STRING_TYPE", "intraestimatedinstall", "%");
$tfi_listworksorders4->addColumn("worksorders.intraprio", "STRING_TYPE", "intraprio", "%");
$tfi_listworksorders4->addColumn("worksorders.intrajobvalue", "STRING_TYPE", "intrajobvalue", "%");
$tfi_listworksorders4->addColumn("worksorders.intraterms", "STRING_TYPE", "intraterms", "%");
$tfi_listworksorders4->addColumn("worksorders.intrajobref", "STRING_TYPE", "intrajobref", "%");
$tfi_listworksorders4->Execute();

// Sorter
$tso_listworksorders4 = new TSO_TableSorter("rsworksorders1", "tso_listworksorders4");
$tso_listworksorders4->addColumn("worksorders.intrajobno");
$tso_listworksorders4->addColumn("worksorders.intratype");
$tso_listworksorders4->addColumn("worksorders.intrastatus");
$tso_listworksorders4->addColumn("worksorders.intracustomer");
$tso_listworksorders4->addColumn("worksorders.intradescription");
$tso_listworksorders4->addColumn("worksorders.intraorder");
$tso_listworksorders4->addColumn("worksorders.intraartapproval");
$tso_listworksorders4->addColumn("worksorders.intraestimatedinstall");
$tso_listworksorders4->addColumn("worksorders.intraprio");
$tso_listworksorders4->addColumn("worksorders.intrajobvalue");
$tso_listworksorders4->addColumn("worksorders.intraterms");
$tso_listworksorders4->addColumn("worksorders.intrajobref");
$tso_listworksorders4->setDefault("worksorders.intraartapproval");
$tso_listworksorders4->Execute();

// Navigation
$nav_listworksorders4 = new NAV_Regular("nav_listworksorders4", "rsworksorders1", "", $_SERVER['PHP_SELF'], 999);

//NeXTenesio3 Special List Recordset
$maxRows_rsworksorders1 = $_SESSION['max_rows_nav_listworksorders4'];
$pageNum_rsworksorders1 = 0;
if (isset($_GET['pageNum_rsworksorders1'])) {
  $pageNum_rsworksorders1 = $_GET['pageNum_rsworksorders1'];
}
$startRow_rsworksorders1 = $pageNum_rsworksorders1 * $maxRows_rsworksorders1;

// Defining List Recordset variable
$NXTFilter_rsworksorders1 = "1=1";
if (isset($_SESSION['filter_tfi_listworksorders4'])) {
  $NXTFilter_rsworksorders1 = $_SESSION['filter_tfi_listworksorders4'];
}
// Defining List Recordset variable
$NXTSort_rsworksorders1 = "worksorders.intrajobno";
if (isset($_SESSION['sorter_tso_listworksorders4'])) {
  $NXTSort_rsworksorders1 = $_SESSION['sorter_tso_listworksorders4'];
}
mysql_select_db($database_intra_conn, $intra_conn);

$query_rsworksorders1 = "SELECT worksorders.intrajobno, worksorders.intratype, worksorders.intrastatus, worksorders.intracustomer, worksorders.intradescription, worksorders.intraorder, worksorders.intraartapproval, worksorders.intraestimatedinstall, worksorders.intraprio, worksorders.intrajobvalue, worksorders.intraterms, worksorders.intrajobref, worksorders.id, worksorders.intradelete FROM worksorders WHERE {$NXTFilter_rsworksorders1} AND worksorders.intradelete != 0 ORDER BY {$NXTSort_rsworksorders1}";
$query_limit_rsworksorders1 = sprintf("%s LIMIT %d, %d", $query_rsworksorders1, $startRow_rsworksorders1, $maxRows_rsworksorders1);
$rsworksorders1 = mysql_query($query_limit_rsworksorders1, $intra_conn) or die(mysql_error());
$row_rsworksorders1 = mysql_fetch_assoc($rsworksorders1);

if (isset($_GET['totalRows_rsworksorders1'])) {
  $totalRows_rsworksorders1 = $_GET['totalRows_rsworksorders1'];
} else {
  $all_rsworksorders1 = mysql_query($query_rsworksorders1);
  $totalRows_rsworksorders1 = mysql_num_rows($all_rsworksorders1);
}
$totalPages_rsworksorders1 = ceil($totalRows_rsworksorders1/$maxRows_rsworksorders1)-1;
//End NeXTenesio3 Special List Recordset//NeXTenesio3 Special List Recordset
mysql_select_db($database_intra_conn, $intra_conn);

$query_rsworksorders1 = "SELECT worksorders.intrajobno, worksorders.intratype, worksorders.intrastatus, worksorders.intracustomer, worksorders.intradescription, worksorders.intraorder, worksorders.intraartapproval, worksorders.intraestimatedinstall, worksorders.intraprio, worksorders.intrajobvalue, worksorders.intraterms, worksorders.intrajobref, worksorders.id, worksorders.intradelete FROM worksorders WHERE {$NXTFilter_rsworksorders1} AND worksorders.intradelete != 1 ORDER BY {$NXTSort_rsworksorders1}";
$rsworksorders1 = mysql_query($query_rsworksorders1, $intra_conn) or die(mysql_error());
$row_rsworksorders1 = mysql_fetch_assoc($rsworksorders1);
$totalRows_rsworksorders1 = mysql_num_rows($rsworksorders1);
//End NeXTenesio3 Special List Recordset

mysql_select_db($database_intra_conn, $intra_conn);
$query_roweffct = "SELECT worksorders.intraestimatedinstall FROM worksorders";
$roweffct = mysql_query($query_roweffct, $intra_conn) or die(mysql_error());
$row_roweffct = mysql_fetch_assoc($roweffct);
$totalRows_roweffct = mysql_num_rows($roweffct);

mysql_select_db($database_intra_conn, $intra_conn);
$query_getsum = "SELECT SUM(worksorders.intrajobvalue) AS SUM_value, worksorders.intradelete FROM worksorders WHERE worksorders.intradelete = 0";
$getsum = mysql_query($query_getsum, $intra_conn) or die(mysql_error());
$row_getsum = mysql_fetch_assoc($getsum);
$totalRows_getsum = mysql_num_rows($getsum);

$colname_testif = "-1";
if (isset($_POST['id'])) {
  $colname_testif = $_POST['id'];
}
mysql_select_db($database_intra_conn, $intra_conn);
$query_testif = sprintf("SELECT id, intraartapproval FROM worksorders WHERE id = %s", GetSQLValueString($colname_testif, "int"));
$testif = mysql_query($query_testif, $intra_conn) or die(mysql_error());
$row_testif = mysql_fetch_assoc($testif);
$totalRows_testif = mysql_num_rows($testif);

// Make an instance of the transaction object
$del_workorders = new tNG_delete($conn_intra_conn);
$tNGs->addTransaction($del_workorders);
// Register triggers
$del_workorders->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "id");
$del_workorders->registerTrigger("END", "Trigger_Default_Redirect", 99, "workorders.php?message=Delete Successfully!");
// Add columns
$del_workorders->setTable("worksorders");
$del_workorders->setPrimaryKey("id", "NUMERIC_TYPE", "POST", "id");

// Execute all the registered transactions
$tNGs->executeTransactions();

$nav_listworksorders4->checkBoundries();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<?php header('Content-type: text/html; charset=utf-8'); ?>
<title>Work Orders</title>
<link href="includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" />
<script src="includes/common/js/base.js" type="text/javascript"></script>
<script src="includes/common/js/utility.js" type="text/javascript"></script>
<script src="includes/skins/style.js" type="text/javascript"></script>
<script src="includes/nxt/scripts/list.js" type="text/javascript"></script>
<script src="includes/nxt/scripts/list.js.php" type="text/javascript"></script>
<script type="text/javascript">
$NXT_LIST_SETTINGS = {
  duplicate_buttons: false,
  duplicate_navigation: false,
  row_effects: true,
  show_as_buttons: true,
  record_counter: false
}
</script>







<style type="text/css">
  /* Dynamic List row settings */
  .KT_col_intrajobno {width:auto; overflow:hidden;}
  .KT_col_intratype {width:auto; overflow:hidden;}
  .KT_col_intrastatus {width:auto; overflow:hidden;}
  .KT_col_intracustomer {width:auto; overflow:hidden;}
  .KT_col_intradescription {width:auto; overflow:hidden;}
  .KT_col_intraorder {width:auto; overflow:hidden;}
  .KT_col_intraartapproval {width:auto; overflow:hidden;}
  .KT_col_intraestimatedinstall {width:auto; overflow:hidden;}
  .KT_col_intraprio {width:auto; overflow:hidden;}
  .KT_col_intrajobvalue {width:auto; overflow:hidden;}
  .KT_col_intraterms {width:auto; overflow:hidden;}
  .KT_col_intrajobref {width:auto; overflow:hidden;}
  h1 {font-size:12px; font-weight:bold; color:#333;}
  
  
  a {font-size:12px; font-weight:bold; text-decoration:none; color:#333;}
  a:hover {font-size:12px; font-weight:bold; text-decoration:underline; color:#333;}
  
  body {background:url('http://www.signworldgroup.com/intranet/images/bg.jpg') repeat-x; font:Arial, Helvetica, sans-serif; font-size:11px;  color:#333;margin:0; }
  
#container {width:auto; margin:0 auto;}

.nav {
background-image: url(http://www.signworldgroup.com/intranet/images/topnav.jpg);
height: 50px;
width: 100%;
background-repeat: repeat-x;
background-color: #e0e8ea;
}


/*  
Sticky Footer Solution
by Steve Hatcher 
http://stever.ca
http://www.cssstickyfooter.com
*/

* {margin:0;padding:0;} 

/* must declare 0 margins on everything, also for main layout components use padding, not 
vertical margins (top and bottom) to add spacing, else those margins get added to total height 
and your footer gets pushed down a bit more, creating vertical scroll bars in the browser */

html, body {height: 100%;}

#wrap {min-height: 100%;}

#main {overflow:auto;
padding-bottom: 150px;}  /* must be same height as the footer */

#footer {position: relative;
margin-top: -150px; /* negative value of footer height */
height: 150px;
clear:both;} 

/*Opera Fix*/
body:before {/* thanks to Maleika (Kohoutec)*/
content:"";
height:100%;
float:left;
width:0;
margin-top:-32767px;/* thank you Erik J - negate effect of float*/
}



/* IMPORTANT

You also need to include this conditional style in the <head> of your HTML file to feed this style to IE 6 and lower and 8 and higher.

<!--[if !IE 7]>
<style type="text/css">
	#wrap {display:table;height:100%}
</style>
<![endif]-->

*/
</style>




<link href="http://www.signworldgroup.com/intranet/style.css" rel="stylesheet" type="text/css" />
<link href="includes/skins/mxkollection3.css" rel="stylesheet" type="text/css" media="all" />
<script src="includes/common/js/base.js" type="text/javascript"></script>
<script src="includes/common/js/utility.js" type="text/javascript"></script>
<script src="includes/skins/style.js" type="text/javascript"></script>
<link href="http://www.signworldgroup.com/intranet/style.css" rel="stylesheet" type="text/css" />
</head>



<body>



<div id="wrap">

<div id="main">





<?php
echo $tNGs->getErrorMsg();
?>






<div id="container"><a href="http://www.signworldgroup.com/intranet/workorders.php"><img src="http://www.signworldgroup.com/intranet/images/logo.png" border="0" style="margin:10px;" /></a>


<div class="nav">
<ul style="list-style-type:none; margin-left:-40px;">
<li style="float:left; padding:27px 8px 8px;"><a href="http://www.signworldgroup.com/intranet/workorders.php">View Jobs</a></li>
<li style="float:left;padding:27px 8px 8px;"><a href="http://www.signworldgroup.com/intranet/addjob.php">Add Job</a></li>
<li style="float:left;padding:27px 8px 8px;"><a href="http://www.signworldgroup.com/intranet/weeksorders.php">View Weeks Orders</a></li>
<li style="float:left; padding:27px 8px 8px;"></li>
</ul>
</div>


<div class="KT_tng" id="listworksorders4">

<div class="KT_tnglist">
   <form action="<?php echo KT_escapeAttribute(KT_getFullUri()); ?>" method="post" id="form1">
      <div class="KT_options"> <a href="<?php echo $nav_listworksorders4->getShowAllLink(); ?>"><?php echo NXT_getResource("Show"); ?>
        <?php 
  // Show IF Conditional region1
  if (@$_GET['show_all_nav_listworksorders4'] == 1) {
?>
          <?php echo $_SESSION['default_max_rows_nav_listworksorders4']; ?>
          <?php 
  // else Conditional region1
  } else { ?>
          <?php echo NXT_getResource("all"); ?>
          <?php } 
  // endif Conditional region1
?>
  <?php echo NXT_getResource("records"); ?></a>  
         
        <?php 
  // Show IF Conditional region2
  if (@$_SESSION['has_filter_tfi_listworksorders4'] == 1) {
?>
          <a href="<?php echo $tfi_listworksorders4->getResetFilterLink(); ?>"><?php echo NXT_getResource("Reset filter"); ?></a>
          <?php 
  // else Conditional region2
  } else { ?>
          <a href="<?php echo $tfi_listworksorders4->getShowFilterLink(); ?>"><?php echo NXT_getResource("Show filter"); ?></a>
          <?php } 
  // endif Conditional region2
?>
      </div>
      <table cellpadding="2" cellspacing="0" class="KT_tngtable">
        <thead>
          <tr class="KT_row_order">
            <th> </th>
            <th id="intrajobno" class="KT_sorter KT_col_intrajobno <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrajobno'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrajobno'); ?>">Job No.</a></th>
            <th id="intratype" class="KT_sorter KT_col_intratype <?php echo $tso_listworksorders4->getSortIcon('worksorders.intratype'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intratype'); ?>">Type</a></th>
            <th id="intrastatus" class="KT_sorter KT_col_intrastatus <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrastatus'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrastatus'); ?>">Job Status</a></th>
            <th id="intracustomer" class="KT_sorter KT_col_intracustomer <?php echo $tso_listworksorders4->getSortIcon('worksorders.intracustomer'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intracustomer'); ?>">Customer</a></th>
            <th id="intradescription" class="KT_sorter KT_col_intradescription <?php echo $tso_listworksorders4->getSortIcon('worksorders.intradescription'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intradescription'); ?>">Description</a></th>
            <th id="intraorder" class="KT_sorter KT_col_intraorder <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraorder'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraorder'); ?>">Order Date</a></th>
            <th id="intraartapproval" class="KT_sorter KT_col_intraartapproval <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraartapproval'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraartapproval'); ?>">Art Appr. Date</a></th>
            <th id="intraestimatedinstall" class="KT_sorter KT_col_intraestimatedinstall <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraestimatedinstall'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraestimatedinstall'); ?>">Est. Install</a></th>
            <th id="intraprio" class="KT_sorter KT_col_intraprio <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraprio'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraprio'); ?>">Cust Req. Date</a></th>
            <th id="intrajobvalue" class="KT_sorter KT_col_intrajobvalue <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrajobvalue'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrajobvalue'); ?>">Job Value</a></th>
            <th id="intraterms" class="KT_sorter KT_col_intraterms <?php echo $tso_listworksorders4->getSortIcon('worksorders.intraterms'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intraterms'); ?>">Terms</a></th>
            <th id="intrajobref" class="KT_sorter KT_col_intrajobref <?php echo $tso_listworksorders4->getSortIcon('worksorders.intrajobref'); ?>"> <a href="<?php echo $tso_listworksorders4->getSortLink('worksorders.intrajobref'); ?>">Job ref</a></th>
            <th> </th>
          </tr>
          <?php 
  // Show IF Conditional region3
  if (@$_SESSION['has_filter_tfi_listworksorders4'] == 1) {
?>
            <tr class="KT_row_filter">
              <td> </td>
              <td><input type="text" name="tfi_listworksorders4_intrajobno" id="tfi_listworksorders4_intrajobno" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrajobno']); ?>" size="20" maxlength="255" /></td>
              <td><select name="tfi_listworksorders4_intratype" id="tfi_listworksorders4_intratype">
                <option value="1" <?php if (!(strcmp(1, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intratype'])))) {echo "SELECTED";} ?>>Signworld</option>
                <option value="2" <?php if (!(strcmp(2, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intratype'])))) {echo "SELECTED";} ?>>Embroidaworld</option>
                <option value="3" <?php if (!(strcmp(3, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intratype'])))) {echo "SELECTED";} ?>>S. Media</option>
              </select></td>
              <td><select name="tfi_listworksorders4_intrastatus" id="tfi_listworksorders4_intrastatus">
                <option value="1" <?php if (!(strcmp(1, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrastatus'])))) {echo "SELECTED";} ?>>Artwork</option>
                <option value="2" <?php if (!(strcmp(2, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrastatus'])))) {echo "SELECTED";} ?>>Production</option>
              </select></td>
              <td><input type="text" name="tfi_listworksorders4_intracustomer" id="tfi_listworksorders4_intracustomer" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intracustomer']); ?>" size="20" maxlength="255" /></td>
              <td><input type="text" name="tfi_listworksorders4_intradescription" id="tfi_listworksorders4_intradescription" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intradescription']); ?>" size="20" maxlength="255" /></td>
              <td><input type="text" name="tfi_listworksorders4_intraorder" id="tfi_listworksorders4_intraorder" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraorder']); ?>" size="20" maxlength="255" /></td>
              <td><input type="text" name="tfi_listworksorders4_intraartapproval" id="tfi_listworksorders4_intraartapproval" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraartapproval']); ?>" size="20" maxlength="255" /></td>
              <td><input type="text" name="tfi_listworksorders4_intraestimatedinstall" id="tfi_listworksorders4_intraestimatedinstall" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraestimatedinstall']); ?>" size="20" maxlength="255" /></td>
              <td><input type="text" name="tfi_listworksorders4_intraprio" id="tfi_listworksorders4_intraprio" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraprio']); ?>" size="20" maxlength="100" /></td>
              <td><input type="text" name="tfi_listworksorders4_intrajobvalue" id="tfi_listworksorders4_intrajobvalue" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrajobvalue']); ?>" size="20" maxlength="255" /></td>
              <td><select name="tfi_listworksorders4_intraterms" id="tfi_listworksorders4_intraterms">
                <option value="1" <?php if (!(strcmp(1, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>Paid</option>
                <option value="2" <?php if (!(strcmp(2, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>Pro Forma</option>
                <option value="3" <?php if (!(strcmp(3, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>COD</option>
                <option value="4" <?php if (!(strcmp(4, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>14 Days</option>
                <option value="5" <?php if (!(strcmp(5, KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intraterms'])))) {echo "SELECTED";} ?>>28 Days</option>
              </select></td>
              <td><input type="text" name="tfi_listworksorders4_intrajobref" id="tfi_listworksorders4_intrajobref" value="<?php echo KT_escapeAttribute(@$_SESSION['tfi_listworksorders4_intrajobref']); ?>" size="20" maxlength="255" /></td>
              <td><input type="submit" name="tfi_listworksorders4" value="<?php echo NXT_getResource("Filter"); ?>" /></td>
            </tr>
            <?php } 
  // endif Conditional region3
?>
        </thead>
        <tbody>
          <?php if ($totalRows_rsworksorders1 == 0) { // Show if recordset empty ?>
            <tr>
              <td colspan="14"><?php echo NXT_getResource("The table is empty or the filter you've selected is too restrictive."); ?></td>
              </tr>
            <?php } // Show if recordset empty ?>
          <?php if ($totalRows_rsworksorders1 > 0) { // Show if recordset not empty ?>
            <?php do { ?>
           
           
           
           
           
           
           
           
           
           
           
           
           
            <tr class="<?php echo @$cnt1++%2==0 ? "" : "KT_even"; ?>">
                <td valign="middle"><input type="hidden" name="id" class="id_field" value="<?php echo $row_rsworksorders1['id']; ?>" /></td>
                <td valign="middle"><div class="KT_col_intrajobno"><a href="job.php?id=<?php echo $row_rsworksorders1['id']; ?>"><?php echo KT_FormatForList($row_rsworksorders1['intrajobno'], 20); ?></a></div></td>
                <td valign="middle"><div class="KT_col_intratype"><?php 
// Show IF Conditional region4 
if (KT_FormatForList(@$row_rsworksorders1['intratype'], 20) == 3) {
?>
                  <img src="http://www.signworldgroup.com/intranet/images/m.png" />
                    <?php 
// else Conditional region4
} elseif (KT_FormatForList(@$row_rsworksorders1['intratype'], 20) == 1) {
?>
                     <img src="http://www.signworldgroup.com/intranet/images/s.png" />
                <?php 
// endif Conditional region4
} else { ?>
                 <img src="http://www.signworldgroup.com/intranet/images/e.png" />
  <?php } 


?>
                </div></td>
              <td valign="middle"><div class="KT_col_intrastatus"><?php 
// Show IF Conditional region5 
if (@$row_rsworksorders1['intrastatus'] == 1) {
?>
               <img src="http://www.signworldgroup.com/intranet/images/aw.png" />
                    <?php 
// else Conditional region5
} else { ?>
                      <img src="http://www.signworldgroup.com/intranet/images/prod.png" />
  <?php } 
// endif Conditional region5
?>
                </div></td>
                <td valign="middle"><div class="KT_col_intracustomer"><?php echo KT_FormatForList($row_rsworksorders1['intracustomer'], 20); ?></div></td>
                <td valign="middle"><div class="KT_col_intradescription"><?php echo KT_FormatForList($row_rsworksorders1['intradescription'], 20); ?></div></td>
                <td valign="middle"><div class="KT_col_intraorder"><?php echo KT_FormatForList(date('d/m/Y',strtotime($row_rsworksorders1['intraorder'])), 20); ?></div></td>
                <td valign="middle"><div class="KT_col_intraartapproval"><?php 

if (@$row_rsworksorders1['intraartapproval'] != "") { ?>

<?php echo KT_FormatForList(date('d/m/Y',strtotime($row_rsworksorders1['intraartapproval'])), 20); ?>



<?php } else { ?>
                 
<?php } ?>
                </div></td>
                <td valign="middle">
			 <?php 
// Show IF Conditional region6 
if (@$row_rsworksorders1['intraartapproval'] == "") {
?>
              
                    <?php 
// else Conditional region6
} else { ?>
                                   
<?php $today = $row_rsworksorders1['intraartapproval'];
            $est = strtotime('+15 day', strtotime($today));
            print date('d/m/Y', $est); ?>
            
  <?php } 
// endif Conditional region6
?>
</td>
                <td valign="middle" style="color:#ff0000;"><div class="KT_col_intraprio"><?php 
// Show IF Conditional region8 
if (@$row_rsworksorders1['intraprio'] != "") {
?>
                    <?php echo KT_FormatForList(date('d/m/Y',strtotime($row_rsworksorders1['intraprio'])), 20); ?>
                    <?php 
// else Conditional region8
} else { ?>
                 
  <?php } 
// endif Conditional region8
?>
                </div></td>
                <td valign="middle"><div class="KT_col_intrajobvalue">
                
                
                
                
                
                
                			<?php



setlocale(LC_MONETARY, 'en_GB');



$amount = money_format('%#4n', $row_rsworksorders1['intrajobvalue']) . "\n";



echo htmlentities($amount, ENT_NOQUOTES, 'ISO-8859-1');
?>
                
                
                
                
                
                </div></td>
                <td valign="middle"><div class="KT_col_intraterms">


			<?php 

if (@$row_rsworksorders1['intraterms'] == 1) {
?>
                 Paid
                    <?php 

} elseif (@$row_rsworksorders1['intraterms'] == 2) {
?>
                  Pro Forma
                   
   <?php 

} elseif (@$row_rsworksorders1['intraterms'] == 3) {
?>
                COD
                
                   <?php 

} elseif (@$row_rsworksorders1['intraterms'] == 6) {
?>
                50% Paid
                   
                   
                     <?php 

} elseif (@$row_rsworksorders1['intraterms'] == 4) {
?>
                   14 Days
                   
                     <?php 

} elseif (@$row_rsworksorders1['intraterms'] == 7) {
?>
                   FOC/Charity
                   
                <?php 
// endif Conditional region4
} else { ?>
                   28 Days
  <?php } 


?>
               
               
               
               
          </div></td>
                <td valign="middle"><div class="KT_col_intrajobref"><?php echo KT_FormatForList($row_rsworksorders1['intrajobref'], 20); ?></div></td>
<td valign="middle"><a href="upd_workorders.php?id=<?php echo $row_rsworksorders1['id']; ?>">Update</a></td>
            </tr>
            
            
            
            
            
            
            
            
            
            
            
            
       
            
            
            
            
            
            
            
            
            
            
            
              <?php } while ($row_rsworksorders1 = mysql_fetch_assoc($rsworksorders1)); ?>
            <?php } // Show if recordset not empty ?>
        </tbody>     <tr>
                <td></td>
                <td></td>
                <td></td>
              <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td colspan="2" style="background-color:red; color:#fff; font:12px Arial, Helvetica, sans-serifbold; padding:10px; text-align:center;">Total Work In Progress  







			<?php



setlocale(LC_MONETARY, 'en_GB');



$amount = money_format('%#4n', $row_getsum['SUM_value']) . "\n";



echo htmlentities($amount, ENT_NOQUOTES, 'ISO-8859-1');
?>
                
                
                
                </td>
                <td></td>
                <td> </td>
<td></td>
            </tr>
            
      </table>
      <div class="KT_bottombuttons">
        <div class="KT_operations"></div>
        <span> </span></div>
    </form>
  </div>
  <br class="clearfixplain" />
</div>
<p><a href="upd_workorders.php"></a></p>
<p> </p></div></div>



</div>





    </div>

</div>

<div id="footer">
Footer
</div>




</body>
</html>
<?php
mysql_free_result($rsworksorders1);

mysql_free_result($roweffct);

mysql_free_result($getsum);

mysql_free_result($testif);
?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.