<?php require "_header.php";?>
 <style type="text/css">
  *{  padding:0px;
   margin:0px;}
#content
{
    min-height: 330px;

   /* overflow: hidden;*/
    width: 100%;
}
#content a {
    color: #336797;
    text-decoration: none;
}
#content a:hover {
    color: #478ED0;
    text-decoration: underline;
}
.flL{float:left;}
.flR
{
float:right;	
}
#content .left-content
{
	width:300px;
	height: auto;
}
#content .right-content
{
	width:300px;
	padding-right:5px;
	
}
#content .right-inout
{
	width:100px;
	padding-right:5px;
	
} 
.mstpplr {
    background-color: #393939;
    color: #FFFFFf;
    font-family: Arial Black,Arial,georgia;
    font-size: 14px;
    padding: 3px 0 3px 5px;
    text-align: left;
}
.latdatadiv {
    border-bottom: 1px solid #D7D7D7;
    border-left: 1px solid #D7D7D7;
    border-right: 1px solid #D7D7D7;
     display: block;
    text-align: left;
    width: 298px;
	overflow-x: hidden;
    overflow-y: auto;
	height:900px;
}
  .clrb {
    clear: both;
    content: ".";
    display: block;
    height: 0;
  
}
.mstcom 
{
	padding:0 7px;
}
.mstcom div {
      /*georgia*/
    font-family: Arial, Helvetica, sans-serif;  
    font-size: 14px;
    margin-top: 7px;
    padding: 0 0 5px 9px;
    width: 264px;
} 
#newscontent
{
	padding:20px 0px 20px 5px;
	margin-left: 5px;
}
.hd {
     border-bottom: 2px solid #93BF35;
    float: left;
    min-width: 550px;
	
   
}
.hd h4 {
   text-align: left;
   float:left;
}
h4 {
    font: 26px Georgia,"Times New Roman",Times,serif;
    
}
.newslongdec
{
	text-align:left;
	
	padding-top:10px;
	clear:both;
}
#newscontent .datedisp{
	color: #660066;
    display: block;
    float: left;
    
    padding-top: 6px;
    text-decoration: none;}
#newscontent p
{
	margin-top:10px;
	margin-bottom:10px;
}
.jsconfirm 
{
	font-weight:bold;
	color:#C00;
}
</style>
<script type="text/javascript" src="js/themes.js"></script>
<div id="theme">
    <form id="styleswitcher">
        <label for="styleswitcher_select">Choose Theme: </label>
        <select name="styleswitcher_select" id="styleswitcher_select">
            <option value="blue" selected="true">Blue Theme</option>
            <option value="gray">Gray Theme</option>
            <option value="access">Accessibility Theme</option>
            <option value="yourtheme">Your Theme</option>
            <option value="slate">Slate</option>
        </select>
    </form>
</div>

<div id="main-content" align="center">  
    
<script type="text/javascript" src="jquery/ux/fileuploadfield/FileUploadField.js"></script>
<link rel="stylesheet" type="text/css" href="jquery/ux/fileuploadfield/css/fileuploadfield.css"/>
<link rel="stylesheet" type="text/css" href="css/ext-all.css" />
<link rel="stylesheet" type="text/css" href="jquery/ux/css/statusbar.css"/>
 <link rel="stylesheet" type="text/css" href="css/xtheme-gray.css" />
<!-- Theme includes -->
 <!--header end-->
 
<script type="text/javascript" src="webcamjs/webcam.js"></script>
 <script src="js/photocapture.js" type="text/javascript"></script>
 <script type="text/javascript" src="js/jquery.min1.js" ></script>

<!--
    <script src="cropjs/prototype.js" type="text/javascript"></script>
	<script src="cropjs/scriptaculous.js?load=effects,builder,dragdrop" type="text/javascript"></script>
	<script src="cropjs/cropper.js" type="text/javascript"></script> 
-->
 <?php 
// 	$qry = "SELECT A.*,B.customer_orgname,c.user_name FROM `lms_cust` A join lms_customer B join lms_usermaster c on A.customer_id = B.customer_id";	
$qry = "SELECT A.*,B.customer_orgname,c.user_name FROM `lms_cust` A join lms_customer B on A.customer_id = B.customer_id  join lms_usermaster c on A.user_id = c.user_id";

	$rs =dbQuery($qry);
	 $disNewsString = "";	

		if(dbRows($rs) > 0)
		{
			while($row = dbArray($rs))
			{ 
			 
			  $disNewsString1 .='<div class="mstcom"><div> '.$row["status"].'  </span> </div> </div>';	
			  if( $row["status"]  == "Pending")  {
 $disNewsString .='<div class="mstcom"><div><a href="view-custsupport.php?customer_id='.$row["customer_id"].'" >'.$row["customer_orgname"].' - '.date('d M, Y',strtotime($row["date1"])).'  <br/></a> </span> </div> </div>';	
			  }
			  if( $row["status"]  == "on work")  {
$disNewsString.='<div class="mstcom"><div><a href="view-custsupport.php?customer_id='.$row["customer_id"].'" >'.$row["customer_orgname"].'<br/>(process and user_id='.$row["user_name"].')</a> </span> </div> </div>';	
			  }
                  		 
			}
		}
   ?>
<div id="content" class="flL">
  <div class="flL left-content">
   </div>
   <div class="flR right-content">
 
         <div class="mstpplr">
           <blockquote>
             <blockquote>
               <p>School</p>
             </blockquote>
           </blockquote>
         </div>
         <div class="latdatadiv" style="float:left;">
         	<div class="clrb"></div>
		 	<?php   echo $disNewsString;    ?>          
        	 </div>
  </div>
 <?php require "_footer.php";?>