File: /home/cafsindia/refimac_cafsjobs_com/access_pages.php
<script type="text/JavaScript">
<!--
function formget1()
{
var major_head = document.getElementById("menu").value;
if(major_head=="Other")
{
document.getElementById("menu1").disabled=false;
document.getElementById("menu1").value="";
}
else
{
document.getElementById("menu1").disabled=true;
document.getElementById("menu1").value="NIL";
}
}
function formget2()
{
var major_head = document.getElementById("submenu").value;
if(major_head=="Other")
{
document.getElementById("submenu1").disabled=false;
document.getElementById("submenu1").value="";
}
else
{
document.getElementById("submenu1").disabled=true;
document.getElementById("submenu1").value="NIL";
}
}
function formValidator(){
// Make quick references to our fields
var menu = document.getElementById('menu');
var submenu = document.getElementById('submenu');
var page_name = document.getElementById('page_name');
// Check each input in the order that it appears in the form!
if(madeSelection(menu, "Please Select Menu Name!")){
if(madeSelection(submenu, "Please Select Submenu Name!")){
if(notEmpty(page_name, "Please enter Page Name !")){
return true;
}
}
}
return false;
}
function notEmpty(elem, helperMsg){
if(elem.value.length == 0){
alert(helperMsg);
elem.focus(); // set the focus to this input
return false;
}
return true;
}
function madeSelection(elem, helperMsg){
if(elem.value == "Select"){
alert(helperMsg);
elem.focus();
return false;
}else{
return true;
}
}
//-->
</script>
<div id="contentwrapper">
<div class="main_content">
<?php
$up=$_REQUEST['up'];
$id=$_REQUEST['id'];
if($up==1)
{
$sql="select * from serviceapp_pages where page_id=".$id." and status='Y'";
$qu=mysql_query($sql);
while($r=mysql_fetch_array($qu))
{
$menu=$r['menu_name'];
$menu1="NIL";
$submenu=$r['submenu_name'];
$submenu1="NIL";
$page_name=$r['page_name'];
$ava_trans=$r['ava_trans'];
$refer=$r['refer_name'];
$ap_id=$r['ap_id'];
$remarks=$r['remarks'];
$trans=explode("|",$ava_trans);
}
}
?>
<div class="page-head">
<div class="container">
<!-- BEGIN PAGE TITLE -->
<div class="page-title">
<h1>Page Creation
<small>Create your pages.</small></h1>
</div>
</div>
</div>
<div class="page-content">
<div class="container">
<div class="row-fluid">
<div class="span12">
<?php
if($nav=="1"||$nav=="3")
echo "<div class='alert alert-success'>
<span>Given information successfully updated !</span>
</div>";
elseif($nav=="2"||$nav=="4"||$nav=="6")
echo "<div class='alert alert-warning'>
<span>sorry, given information not updated, please try again !</span>
</div>";
elseif($nav=="5")
echo "<div class='alert alert-danger'>
<span>Selected Record successfully deleted !</span>
</div>";
?>
</div>
</div>
<div class="page-content-inner">
<form name="form1" action="<?php if($up==1)echo "up"; else echo "ad";?>d_details.php?mid=<?php echo $mid;?>&smid=<?php echo $smid;?>&pid=<?php echo $pid;?>" method="post">
<div class="portlet light">
<div class="row">
<div class="col-md-12">
<div class="col-md-3">
<label> Menu Name :</label>
<select name="menu" class="form-control " id="menu" onchange="formget1()">
<option value="Select">Select Menu</option>
<?php
$sql1="select distinct(menu_name) from serviceapp_pages where status='Y' order by refer_name,menu_name";
$qu1=mysql_query($sql1);
while($r1=mysql_fetch_array($qu1))
{
?>
<option <?php if($menu==$r1['menu_name']) echo "Selected='Selected'";?> value="<?php echo $r1['menu_name'];?>"><?php echo $r1['menu_name'];?></option>
<?php } ?>
<option value="Other">Other</option>
</select>
<br />
<input name="menu1" type="text" id="menu1" class="form-control" value="<?php echo $menu1;?>" />
<span class="table_text_13px1">
<input name="page_id" type="hidden" value="<?php if($up==1) echo $id;?>" />
</span>
<span class="help-block">Please select / enter main menu name </span>
</div>
<div class="col-md-3">
<label>Sub Menu name <span class="f_req">*</span></label>
<select name="submenu" class="form-control " id="submenu" onchange="formget2()">
<option value="Select">Select Sub Menu</option>
<?php
$sql1="select distinct(submenu_name) from serviceapp_pages where status='Y' order by refer_name,submenu_name";
$qu1=mysql_query($sql1);
while($r1=mysql_fetch_array($qu1))
{
?>
<option <?php if($submenu==$r1['submenu_name']) echo "Selected='Selected'";?> value="<?php echo $r1['submenu_name'];?>"><?php echo $r1['submenu_name'];?></option>
<?php } ?>
<option value="Other">Other</option>
</select>
<br />
<input type="text" id="submenu1" name="submenu1" class="form-control" value="<?php echo $submenu1;?>" />
<span class="help-block">Please select / enter sub menu name </span>
</div>
<div class="col-md-3">
<label>Page name <span class="f_req">*</span></label>
<input name="page_name" type="text" class="form-control" id="page_name" value="<?php echo $page_name;?>" />
<span class="help-block">Please enter page name </span>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="col-md-6">
<label>Available Transactions<span class="f_req">*</span></label>
<input name="but_add" type="checkbox" id="but_add" value="Y" <?php if($trans[0]=="Y")echo "checked='checked'";?> />
<label>Add </label>
<input name="but_upd" type="checkbox" id="but_upd" value="Y" <?php if($trans[1]=="Y")echo "checked='checked'";?> />
<label>Update </label>
<input name="but_del" type="checkbox" id="but_del" value="Y" <?php if($trans[2]=="Y")echo "checked='checked'";?> />
<label>Delete </label>
<input name="but_view" type="checkbox" id="but_view" value="Y" <?php if($trans[3]=="Y")echo "checked='checked'";?> />
<label class="checkbox inline">View </label>
<input name="but_admin" type="checkbox" id="but_admin" value="Y" <?php if($trans[4]=="Y")echo "checked='checked'";?> />
<label class="checkbox inline">Admin </label>
</div>
<div class="col-md-3">
<label>Page Reference No <span class="f_req">*</span></label>
<input name="refer" type="text" class="form-control" id="refer" size="50" value="<?php echo $refer;?>" />
</div>
<div class="col-md-3">
<label>Action Page ID <span class="f_req">*</span></label>
<input name="ap_id" type="text" class="form-control" id="ap_id" size="50" value="<?php echo $ap_id;?>" />
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="col-md-3">
<label>Page Purpose </label>
<textarea name="remarks" cols="50" rows="3" class="form-control" id="remarks"><?php echo $remarks;?></textarea>
</div>
</div>
</div>
<div class="form-actions">
<div class="row">
<div class="col-md-offset-3 col-md-9">
<button type="submit" class="btn green">Submit</button>
<button type="button" class="btn grey-salsa btn-outline">Cancel</button>
</div>
</div>
</div>
</div>
</form>
<div class="row portlet light">
<div class="col-md-12">
<h3 class="heading">View / Search / Update Pages </h3>
<table class="table table-striped table-bordered table-hover dt-responsive" id="sample">
<thead>
<tr>
<th>Page ID </th>
<th>Menu Name </th>
<th>Sub Menu Name </th>
<th>Page Name </th>
<th>Operations</th>
<th>Update</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php
$sql1="select * from serviceapp_pages where status='Y' order by refer_name,menu_name,submenu_name,page_name";
$qu1=mysql_query($sql1);
$i=1;
while($rd=mysql_fetch_array($qu1))
{
$trans1=explode("|",$rd['ava_trans']);
?>
<tr>
<td><?php echo $i;?></td>
<td><?php echo $rd['menu_name'];?></td>
<td><?php echo $rd['submenu_name'];?></td>
<td><?php echo $rd['page_name'];?></td>
<td class="center"><?php if($trans1[0]=='Y')echo "<span class='icon-shield' title='Add Option Available' />"; else echo "<img src='img/Unverified.png' title='Add Option Unavailable' width='18' height='18' />"; echo " | "; if($trans1[1]=='Y')echo "<span class='icon-shield' title='Update option Available' />"; else echo "<img src='img/Unverified.png' title='Update option Unavailable' width='18' height='18' />"; echo " | "; if($trans1[2]=='Y')echo "<span class='icon-shield' title='Delete Option Available' width='18' height='18' />"; else echo "<img src='img/Unverified.png' title='Delete Option Unavailable' width='18' height='18' />"; echo " | "; if($trans1[3]=='Y')echo "<span class='icon-shield' title='View Option Available'/>"; else echo "<img src='img/Unverified.png' title='View Option Unavailable' width='18' height='18' />"; echo " | "; if($trans1[4]=='Y')echo "<span class='icon-shield' title='Admin Option Available' />"; else echo "<img src='img/Unverified.png' title='Admin Option Unavailable' width='18' height='18' />";?></td>
<td class="center"><a href="landing.php?mid=<?php echo $mid;?>&smid=<?php echo $smid;?>&pid=<?php echo $pid;?>&id=<?php echo $rd['page_id'];?>&up=1" class="sepV_a" title="Edit"><i class="icon-pencil"></i></a></td>
<td class="center"><a href="del_detail.php?mid=<?php echo $mid;?>&smid=<?php echo $smid;?>&pid=<?php echo $pid;?>&id=<?php echo $rd['page_id'];?>" onclick="return confirm('Are you sure you wish to delete this record ?')" title="Delete"><i class="icon-trash"></i></a></td>
</tr>
<?php $i++; }?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function()
{
if ( $.fn.dataTable.isDataTable( '#sample' ) ) {
table = $('#sample').DataTable();
}
else {
table = $('#sample').DataTable( {
dom: 'Bfrtip',
buttons: [
'copy', 'csv', 'excel', 'pdf', 'print','pageLength'
], lengthMenu: [
[ 10, 25, 50, -1 ],
[ '10 rows', '25 rows', '50 rows', 'Show all' ]
]
} );
}
});
// Wait for the DOM to be ready
$(function() {
// Initialize form validation on the registration form.
// It has the name attribute "registration"
$("form[name='form1']").validate({
// Specify validation rules
rules: {
// The key name on the left side is the name attribute
// of an input field. Validation rules are defined
// on the right side
refer: "required",
ap_id: "required",
remarks: {
required: true,
// Specify that email should be validated
// by the built-in "email" rule
//email: true
},
page_name: {
required: true,
// minlength: 5
}
},
// Specify validation error messages
messages: {
refer: "Please enter page reference number",
ap_id: "Please enter Action Page ID",
remarks: {
required: "Please provide a Page Purpose",
},
page_name: "Please enter a page name"
},
// Make sure the form is submitted to the destination defined
// in the "action" attribute of the form when valid
submitHandler: function(form) {
form.submit();
}
});
});
</script>