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