Home  • Online Tips • VCampus Help

VCampus CSS Framework - Layout and Report Design

<?php include("css_report.php")?>
<?php include("css_responsive.php")?>
<div class="row clearfix"> 
  <div class="colgroup colgroup1">   
    
     <div class="col col1">  
          <div class="section_wrapper">
                 <?php include("col1.php")?> 
         </div> <!--end section_wrapper-->
     </div><!--end col1-->
     
     <div class="col col2">
<div class="section_wrapper"> 
<div class="section"> 
          <form action="#" name="frm_search" method="post" style="overflow:auto;">
          <div class="form-header">
	     <?php 			
		  echo MENU_OPTION_NAME;
	     ?>
       <span id="loading" style="float:right;"></span>
       </div>                 
            
          <?php
		    if(isset($msg)){
          	  echo "<div>$msg</div>";
			}
		  ?>
           <div class="table">
           	<div class="table-row">
           		<div class="table-head">ID</div>
           		<div class="table-head">Account No</div>
                <div class="table-head">Code</div>
                <div class="table-head">Name</div>
           		<div class="table-head">Unit</div>
           		<div class="table-head">Level</div>
                <div class="table-head">Type</div>
                <div class="table-head">Status</div>
                <div class="table-head">Item/Page</div>
             </div>
           
           <div class="table-row">
               <div class="table-cell"><input type="text" style="max-width:50px;"  name="txtPayrollId" id="txtPayrollId"/></div>
               <div class="table-cell"><input type="text" style="max-width:60px;"  name="txtPayrollAccount" id="txtPayrollAccount"/></div>
               <div class="table-cell"><input type="text"  name="txtPersonCode" id="txtPersonCode" style="max-width:120px;"/></div>
               <div class="table-cell"><input type="text"  name="txtPersonName" id="txtPersonName" style="max-width:120px;"/></div>
               <div class="table-cell">
                    <select name="cmbUnit" id="cmbUnit" style="max-width:100px;" >
                    <option value="">All</option>
                    <?php 
                       // $db=new mysqli(SERVER,USER,PWD,DB);
                        //$menu_id=$_SESSION["m_id"];
                        $rs_com=$db->query("select id,name from company_master");
                            while($rows=$rs_com->fetch_array(MYSQLI_ASSOC)){
								echo "<optgroup label='$rows[name]'>";
								$rs_unit=$db->query("select id,short_title,abbr from unit_master where company_id='$rows[id]'");
								 while($row=$rs_unit->fetch_assoc()){
									 echo "<option value='$row[id]'>$row[id] $row[short_title]</option>";	 
								  }
								echo "</optgroup>";
                           
                         }
                    ?>
                
                    </select>
              	</div>
           
           <div class="table-cell">
               <select  name="cmbLevel" id="cmbLevel" style="max-width:100px;" >
                    
                <option value="">All</option>
                    <?php 
                       // $db=new mysqli(SERVER,USER,PWD,DB);
                        //$menu_id=$_SESSION["m_id"];
                        $rs_com=$db->query("select id,name from position_level_category");
                            while($rows=$rs_com->fetch_array(MYSQLI_ASSOC)){
								echo "<optgroup label='$rows[name]'>";
								$rs_unit=$db->query("select id,name from position_level_master where category_id='$rows[id]'");
								 while($row=$rs_unit->fetch_assoc()){
									 echo "<option value='$row[id]'>$row[id] $row[name]</option>";	 
								  }
								echo "</optgroup>";
                           
                         }
                    ?>
            </select>
            </div>
            <div class="table-cell">
             <select  name="cmbType" id="cmbType" style="max-width:100px;">                    
                <option value="">All</option>
                <?php
                $rs_type=$db->query("select id,name from position_category");
								 while($row=$rs_type->fetch_assoc()){
									 echo "<option value='$row[id]'>$row[id] $row[name]</option>";	 
								  }
				?>
                </select>
           </div>
            <div class="table-cell">
               <select  name="cmbStatus" id="cmbStatus" style="max-width:100px;">                    
                <option value="">All</option>
                  <option value="0">Vacant</option>
                  <option value="1">Occupied</option>
                  <option value="2">Put on hold</option>
                  <option value="3">Obsolute</option>
                </select>
           </div>
            <div class="table-cell"><input type="text"  name="txt_limit" value="10"  size="5" id="txt_limit" /></div>
        </div>
        
        </div>
    </form>            
       <div id="container">
        <div class="data"></div>
        <div class="pagination"></div>         
      </div>
    
    <footer class="form-footer"></footer> 
    </div> <!--section-->  
    </div>
    </div>
    </div>
</div>
<?php
include("js_report.php");
?>
<script type="text/javascript">

function getQueryString(page){
var id=document.frm_search.txtPayrollId.value;
var payroll_ac=document.frm_search.txtPayrollAccount.value;					
var code=document.frm_search.txtPersonCode.value;
var name=document.frm_search.txtPersonName.value;
var limit=document.frm_search.txt_limit.value;
var level=document.frm_search.cmbLevel.value;
var unit=document.frm_search.cmbUnit.value;
var type=document.frm_search.cmbType.value;
var status=document.frm_search.cmbStatus.value;
var url='modules/payroll/query_payroll_account.php';
//var vacant=$('input[name=chkVacant]').is(':checked')==true?1:0;
					
var json={
	'payrollId':id,
	'payrollAc':payroll_ac,
	'personCode':code,
	'personName':name,
	'positionLevel':level,
	'unit':unit,
	'type':type,
	'status':status,
	//mandatory keys
	'limit':limit,
	'page':page,
	'url':url,
	'method':'GET'
	}	
return json;					   
}

</script>

Comments 1


sifuddin lokman

Share

Copyright © 2024. Powered by Intellect Software Ltd