<?php require_once('Connections/kingsconn.php'); ?>
<?php require_once('Connections/kingsconn.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
  session_start();
}

// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
  //to fully log out a visitor we need to clear the session varialbles
  $_SESSION['MM_Username'] = NULL;
  $_SESSION['MM_UserGroup'] = NULL;
  $_SESSION['PrevUrl'] = NULL;
  unset($_SESSION['MM_Username']);
  unset($_SESSION['MM_UserGroup']);
  unset($_SESSION['PrevUrl']);
	
  $logoutGoTo = "sales_login.php";
  if ($logoutGoTo) {
    header("Location: $logoutGoTo");
    exit;
  }
}
?>
<?php
if (!isset($_SESSION)) {
  session_start();
}
$MM_authorizedUsers = "sales";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "sales_login.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];

$colname_Recordset1 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_kingsconn, $kingsconn);
$query_Recordset1 = sprintf("SELECT * FROM tb_user_accounts WHERE username = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $kingsconn) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$maxRows_Recordset2 = 10;
$pageNum_Recordset2 = 0;
if (isset($_GET['pageNum_Recordset2'])) {
  $pageNum_Recordset2 = $_GET['pageNum_Recordset2'];
}
$startRow_Recordset2 = $pageNum_Recordset2 * $maxRows_Recordset2;

mysql_select_db($database_kingsconn, $kingsconn);
$query_Recordset2 = "SELECT * FROM tb_so WHERE so_status LIKE 'For Checking of Stock' OR so_status LIKE 'Partial Delivery' OR so_status LIKE 'For Delivery'";
$query_limit_Recordset2 = sprintf("%s LIMIT %d, %d", $query_Recordset2, $startRow_Recordset2, $maxRows_Recordset2);
$Recordset2 = mysql_query($query_limit_Recordset2, $kingsconn) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);

if (isset($_GET['totalRows_Recordset2'])) {
  $totalRows_Recordset2 = $_GET['totalRows_Recordset2'];
} else {
  $all_Recordset2 = mysql_query($query_Recordset2);
  $totalRows_Recordset2 = mysql_num_rows($all_Recordset2);
}
$totalPages_Recordset2 = ceil($totalRows_Recordset2/$maxRows_Recordset2)-1;

$queryString_Recordset2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Recordset2") == false && 
        stristr($param, "totalRows_Recordset2") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Recordset2 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Recordset2 = sprintf("&totalRows_Recordset2=%d%s", $totalRows_Recordset2, $queryString_Recordset2);
?>

<!--
.style32 {	color: #FF0000;
	font-size: 10px;
}
-->	

<!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" />
<link rel="icon" href="images/favicon.png" type="image/x-icon" />

<title>CRB SOFTWARE</title>

<link rel='stylesheet' type='text/css' href='css/style.css' />

<!-- DATE PICKER TO-->
<link rel="stylesheet" href="themes/base/jquery.ui.all.css">
<link rel="stylesheet" href="demos.css">

<!-- CLOCK TO-->
<script type="text/javascript" src="js/oras.js"></script>
<script type='text/javascript' src='js/clock.js'></script>

<!-- DATE PICKER-->
<script type="text/javascript" src="js/jquery-1.5.1.js"></script>
<script type="text/javascript" src="ui/jquery.ui.core.js"></script>
<script type="text/javascript" src="ui/jquery.ui.widget.js"></script>	
<script type="text/javascript" src="ui/jquery.ui.datepicker.js"></script>		
<script type="text/javascript" src="js/datepicker.js"></script>

<!-- MENU MAGIC-->
<script type='text/javascript' src="rainbow.css"></script>
<script type='text/javascript' src='js/jquery.color-RGBa-patch.js'></script>
<script type='text/javascript' src='js/example.js'></script>

<!-- OPENWINDOW-->
<script type="text/javascript" src="js/openwindow.js"></script>

<!-- validate search-->
<script type="text/javaScript" src="js/validate_search.js"></script>


<style type="text/css">
<!--
.style32 {	color: #FF0000;
	font-size: 10px;
}
-->
</style>
</head>

<body>
<table width="1250" align="center" bordercolor="#FFFFFF">
  <tr>
    <td width="1087" height="118" background="images/HEADS.jpg"><table width="400" height="92" align="right">
      <tr>
        <td width="232" height="21">&nbsp;</td>
      </tr>
      <tr>
        <th height="63" scope="col"> 
			<div class="clock">
            <div id="Date"></div>
          <ul>
              <li id="hours"> </li>
              <li id="point">:</li>
              <li id="min"> </li>
              <li id="point">:</li>
              <li id="sec"> </li>
			</ul> </th>
      </tr>
    </table></td>
  </tr>
</table>
<table width="1250" align="center" bordercolor="#FFFFFF">
  <tr>
    <td width="899" height="23" background="images/body-deisgn.jpg">
	
	<div class="nav-wrap" align="center">
	<ul class="group" id="example-two">
     <li class="current_page_item_two">
		

<!--
.style32 {	color: #FF0000;
	font-size: 10px;
}
-->		
			<a rel="#A41322" href="sales_portal.php"> ALLOCATION </a>
     <li>
			
			&nbsp;
			&nbsp;
			&nbsp;
			&nbsp;
			
		<li><a rel="#A41322" href="sales_sales_order.php">SALES ORDER</a></li>
			 
			 
			 
			 
			 
			 
<li><a rel="#A41322" href="closed_sales_order.php">CLOSED SO</a></li>
		     
			 
			 
			 
			 
			 
			<li><a rel="#A41322" href="sales_client_list.php">CLIENT LIST</a></li>
			 
			 
			 
			 
			 
			 <li><a rel="#A41322" href="sales_item_list.php">ITEM LIST</a></li>
			 
			 
			 
			 
			 
			 <li><a rel="#A41322" href="sales_so_reports.php"> SO REPORTS</a></li>
			 
			 
			 
			 
			 
			 
			<li><a href="<?php echo $logoutAction ?>" rel="#A41322">LOGOUT</a></li>
</ul>
	
	</td>
  </tr>
</table>
<table width="1250" align="center" bordercolor="#FFFFFF">
  <tr>
    <td width="899" height="393" valign="top" background="images/body.jpg"><table width="1230" align="center">
      <tr>
        <td width="1222" bgcolor="#FFFFFF"><table width="1222" align="center">
            <tr>
              <td bgcolor="#FFFFFF"><table width="1211" height="24" align="center">
                <tr>
                  <td width="10">&nbsp;</td>
                  <td width="10">&nbsp;</td>
                  <td width="938"><form id="form4" name="form4" method="post" action="sales_search3.php">
                    <table width="934" height="30">
                      <tr>
                        <td width="683"><div align="right"><span class="style32">NOTE: You can search here using Company Name, PO Number, SO number: </span></div></td>
                        <td width="192"><input name="search2" type="text" placeholder="Search Here!" size="32" /></td>
                        <td width="43"><label>
                          <input type="submit" name="Submit4" value="Go" />
                        </label></td>
                      </tr>
                    </table>
                      </form>                  </td>
                  <td width="233"><form id="form1" name="form1" method="post" action="search_request2.php">
                      <table width="233" height="32" align="right">
                        <tr>
                          <td width="185" height="26"><div align="right">
                              <select name="search" id="search">
                                <option value="For Delivery">For Delivery</option>
                                <option value="Partial Delivery">Partial Delivery</option>
								<option value="For Checking of Stock">For Checking of Stock</option>
                                <option value="Checked by Warehouse">Checked by Warehouse</option>

                              </select>
                          </div></td>
                          <td width="36"><label>
                            <input type="submit" name="Submit" value="Go" />
                          </label></td>
                        </tr>
                      </table>
                  </form></td>
                </tr>
              </table></td>
            </tr>
          </table>
            
          <table width="1218" align="center">
            <tr bgcolor="#333333">
              <td width="158"><div align="center"><span class="style22">SO Number </span></div></td>
              <td width="166"><div align="center"><span class="style22">CPO Number</span></div></td>
              <td width="394" bgcolor="#333333"><div align="center"><span class="style22">Customer Name</span></div></td>
              <td width="133"><div align="center"><span class="style22">Registered Date</span></div></td>
              <td width="248"><div align="center"><span class="style22"> Status </span></div></td>
              <td width="29">&nbsp;</td>
              </tr>
            <tr>
              <?php $i=0;do { echo "<tr class=".($i%2==0? '"even"':'"odd"').">";?>
              <td><div align="center"><?php echo $row_Recordset2['so_number']; ?></div></td>
              <td><div align="center"><?php echo $row_Recordset2['cpo_number']; ?></div></td>
              <td><div align="center"><?php echo $row_Recordset2['customer_name']; ?></div></td>
              <td><div align="center"><?php echo $row_Recordset2['registered_date']; ?></div></td>
              <td><div align="center"><?php echo $row_Recordset2['so_status']; ?></div></td>
              <td><a href="sales_check_so_per_item.php?so_number=<?php echo $row_Recordset2['so_number']; ?> "><img src="images/view.png" width="25" height="25" /></a></td>
              </tr>
            <?php $i++;} while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>
          </table></td>
      </tr>
      <tr>
        <td><table border="0" width="50%" align="center">
            <tr>
              <td width="23%" align="center"><?php if ($pageNum_Recordset2 > 0) { // Show if not first page ?>
                    <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, 0, $queryString_Recordset2); ?>">First</a>
                    <?php } // Show if not first page ?>
              </td>
              <td width="31%" align="center"><?php if ($pageNum_Recordset2 > 0) { // Show if not first page ?>
                    <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, max(0, $pageNum_Recordset2 - 1), $queryString_Recordset2); ?>">Previous</a>
                    <?php } // Show if not first page ?>
              </td>
              <td width="23%" align="center"><?php if ($pageNum_Recordset2 < $totalPages_Recordset2) { // Show if not last page ?>
                    <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, min($totalPages_Recordset2, $pageNum_Recordset2 + 1), $queryString_Recordset2); ?>">Next</a>
                    <?php } // Show if not last page ?>
              </td>
              <td width="23%" align="center"><?php if ($pageNum_Recordset2 < $totalPages_Recordset2) { // Show if not last page ?>
                    <a href="<?php printf("%s?pageNum_Recordset2=%d%s", $currentPage, $totalPages_Recordset2, $queryString_Recordset2); ?>">Last</a>
                    <?php } // Show if not last page ?>
              </td>
            </tr>
          </table></td>
      </tr>

    </table></td>
  </tr>
</table>
<table width="1250" align="center" bordercolor="#FFFFFF">
  <tr>
    <td width="899" height="43" background="images/footer-deisgn.jpg">&nbsp;</td>
  </tr>
</table>
</body>
</html>
<?php

mysql_free_result($Recordset1);

mysql_free_result($Recordset2);
?>