Gecko [ www.jdcpatala.org ]

Name	Size	Permission
ad_jquery	[ DIR ]	drwxr-xr-x
admin_task	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
doc	[ DIR ]	drwxr-xr-x
highslide	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
misc	[ DIR ]	drwxr-xr-x
reports	[ DIR ]	drwxr-xr-x
simplexlsx-master	[ DIR ]	drwxr-xr-x
uploads	[ DIR ]	drwxr-xr-x
Bank_Transfer_Admission.php	3.17 KB	-rw-r--r--
Distrcits.php	6.43 KB	-rw-r--r--
ICM1401.jpg	20.16 KB	-rw-r--r--
Library_membership.php	2.92 KB	-rw-r--r--
Qualification.php	5.72 KB	-rw-r--r--
Request_leave.php	3.99 KB	-rw-r--r--
Student_reports.php	1.54 KB	-rw-r--r--
University.php	6.15 KB	-rw-r--r--
add_new_user.php	5.51 KB	-rw-r--r--
add_subjects.php	2.84 KB	-rw-r--r--
admin_task.php	5.63 KB	-rw-r--r--
admin_task_leave.php	6 KB	-rw-r--r--
admission_dashborad.php	5.56 KB	-rw-r--r--
admission_preview.php	19.35 KB	-rw-r--r--
admission_report.php	13.55 KB	-rw-r--r--
ajaximage.php	984 B	-rw-r--r--
attendance.php	4.34 KB	-rw-r--r--
auth.php	249 B	-rw-r--r--
back.php	1.2 KB	-rw-r--r--
bank.php	5.67 KB	-rw-r--r--
blank.php	834 B	-rw-r--r--
calendar.php	1.46 KB	-rw-r--r--
card.php	406 B	-rw-r--r--
caste.php	6.35 KB	-rw-r--r--
category.php	5.65 KB	-rw-r--r--
change.php	494 B	-rw-r--r--
change_salary.php	4.83 KB	-rw-r--r--
character.php	2.05 KB	-rw-r--r--
chart.php	4.45 KB	-rw-r--r--
chief.png	5.98 KB	-rw-r--r--
city.php	7.58 KB	-rw-r--r--
client_door.php	2.44 KB	-rw-r--r--
college_info.php	7.44 KB	-rw-r--r--
da.php	5.47 KB	-rw-r--r--
dash_admission.php	10.71 KB	-rw-r--r--
date.js	11.66 KB	-rw-r--r--
department.php	5.63 KB	-rw-r--r--
designations.php	5.54 KB	-rw-r--r--
editSalary.php	29.6 KB	-rw-r--r--
edit_student_admission.php	27.24 KB	-rw-r--r--
emp_dash.php	2.56 KB	-rw-r--r--
emply_load.php	43 B	-rw-r--r--
emptype.php	5.51 KB	-rw-r--r--
enter_attendance.php	7.19 KB	-rw-r--r--
error.php	1.84 KB	-rw-r--r--
fee_edit.php	18.57 KB	-rw-r--r--
fee_receipts.php	6.17 KB	-rw-r--r--
fee_s.php	23.02 KB	-rw-r--r--
file-manager.php	1.19 KB	-rw-r--r--
filter_admno.php	479 B	-rw-r--r--
filter_studid.php	732 B	-rw-r--r--
footer.php	3.3 KB	-rw-r--r--
form.php	13.22 KB	-rw-r--r--
foundation.php	5.68 KB	-rw-r--r--
functions.php	1.03 KB	-rw-r--r--
functions_hr.php	947 B	-rw-r--r--
gallery.php	1.42 KB	-rw-r--r--
gender.php	5.49 KB	-rw-r--r--
gender_admission_report.php	4.96 KB	-rw-r--r--
gender_admission_report_old.ph...	3.63 KB	-rw-r--r--
getClassDetail.php	1.47 KB	-rw-r--r--
getStudentRegistrationDetails....	1.22 KB	-rw-r--r--
grid.php	8.81 KB	-rw-r--r--
grn_new_add.php	25.5 KB	-rw-r--r--
header.php	5.53 KB	-rw-r--r--
hr.php	2.52 KB	-rw-r--r--
icon.php	312.57 KB	-rw-r--r--
index.php	3.71 KB	-rw-r--r--
info.php	23 B	-rw-r--r--
last_stream.php	5.67 KB	-rw-r--r--
leave_managment.php	1.23 KB	-rw-r--r--
list_job.php	5.83 KB	-rw-r--r--
load_data.php	1.27 KB	-rw-r--r--
loader.gif	10.57 KB	-rw-r--r--
login.php	8.15 KB	-rw-r--r--
logout.php	254 B	-rw-r--r--
mcm_admin	330 B	-rw-r--r--
mcm_admission.php	52.06 KB	-rw-r--r--
mcm_admission_record.php	7.76 KB	-rw-r--r--
meerutCollegeHome.jpg	304.11 KB	-rw-r--r--
new_emp.php	24.74 KB	-rw-r--r--
new_emp_Gyan.php	24.86 KB	-rw-r--r--
new_subject.php	3.34 KB	-rw-r--r--
notice.php	11.71 KB	-rw-r--r--
paper.php	8 KB	-rw-r--r--
payBill_reports.php	4.1 KB	-rw-r--r--
pay_scale.php	5.52 KB	-rw-r--r--
pay_slip.php	2.54 KB	-rw-r--r--
payroll_period.php	8.16 KB	-rw-r--r--
persnal_details.php	3.02 KB	-rw-r--r--
pf.php	5.46 KB	-rw-r--r--
postal.php	7.43 KB	-rw-r--r--
practical.php	5.63 KB	-rw-r--r--
profile.php	954 B	-rw-r--r--
read_msg.php	8.27 KB	-rw-r--r--
religion.php	5.57 KB	-rw-r--r--
reports.php	5.4 KB	-rw-r--r--
salary_gen.php	28.52 KB	-rw-r--r--
salary_management.php	2.32 KB	-rw-r--r--
salary_transfer.php	8.51 KB	-rw-r--r--
send_msg.php	8.02 KB	-rw-r--r--
session.php	5.61 KB	-rw-r--r--
shift.php	5.63 KB	-rw-r--r--
state.php	5.78 KB	-rw-r--r--
stream.php	6.16 KB	-rw-r--r--
student_transfer.php	7.8 KB	-rw-r--r--
subjects.php	4.83 KB	-rw-r--r--
submit_atten_sms.php	5.91 KB	-rw-r--r--
totalSalary_reports.php	4.11 KB	-rw-r--r--
total_salary.php	5.65 KB	-rw-r--r--
tour.php	1.04 KB	-rw-r--r--
transfer.php	11.26 KB	-rw-r--r--
transfer1.php	11.21 KB	-rw-r--r--
transferSalary.php	4.9 KB	-rw-r--r--
transfer_certificates.php	5.81 KB	-rw-r--r--
typography.php	8.34 KB	-rw-r--r--
ui.php	11.77 KB	-rw-r--r--
update_emp.php	22.95 KB	-rw-r--r--
update_image.php	8.97 KB	-rw-r--r--
update_img.php	2.81 KB	-rw-r--r--
update_salary.php	4.96 KB	-rw-r--r--
upload_merit_list.php	6.38 KB	-rw-r--r--
upload_photo.php	529 B	-rw-r--r--
view_attendacne.php	6.02 KB	-rw-r--r--
view_leave.php	1.85 KB	-rw-r--r--
view_sms_attendacne.php	6.04 KB	-rw-r--r--
wampmanager.ini	142.65 KB	-rw-r--r--
withdrawl_list.php	73.5 KB	-rw-r--r--
x.php	4.71 KB	-rw-r--r--

Code Editor : salary_transfer.php

<?php

include('header.php');
      include('functions.php');
	  include('include/config.php');
      if($_GET['val']=="show"){
	  $empid=$_GET['id'];
	  $res=mysqli_query($conn, "Select * from employee_entry where emplyoee_code='$empid'");
	  $data=mysqli_fetch_array($res);
	}
	  
?>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>

<div>
				<ul class="breadcrumb">
					<li>
						<a href="index.php">Home</a> <span class="divider">/</span>
					</li>
					<li>
						<a href="pay_slip.php">Pay Slip DashBoard</a> <span class="divider">/</span>
					</li>
					<li>
						<a href="#">Salary Transfer</a>
					</li>
				</ul>
			</div>
                      <center><?php echo $_SESSION['msg']; unset($_SESSION['msg']); ?></center>
              <div class="row-fluid sortable">
				<div class="box span12">
					<div class="box-header well" data-original-title>
						<h2>Salary Transfer</h2>
						<div class="box-icon">
							<a href="#" class="btn btn-setting btn-round"><i class="icon-cog"></i></a>
							<a href="#" class="btn btn-minimize btn-round"><i class="icon-chevron-up"></i></a>
							<a href="#" class="btn btn-close btn-round"><i class="icon-remove"></i></a>
						</div>
					</div>
					
					<div class="box-content">
					
					
					
		<form action="" method="POST" class="form-horizontal" >
		<div id="myTabContent" class="tab-content">
		<br>
							<table>
							<tr>
							  <td><label class="control-label" for="focusedInput" style="width:170px;">Month:</label></td>
							  <td>
								  <select id="month" name="fmonth"  onchange="change()" size="1" style="width:170px;">
									    <option value="January">January</option>
										<option value="February">February</option>
										<option value="March">March</option>
										<option value="April">April</option>
										<option value="May">May</option>
										<option value="June">June</option>
										<option value="July">July</option>
										<option value="August">August</option>
										<option value="September">September</option>
										<option value="October">October</option>
										<option value="November">November</option>
										<option value="December">December</option>
									</select>
								</td>
	                        <td> 					
						
							<label class="control-label" for="focusedInput" style="width:170px;">Year:</label></td>
							<td>
						 <Select name="fyear" id="year" onchange="chnge()" style="width:170px;">
										 <?php 
                                    $res=mysqli_query($conn, "select distinct year from year");	
                                    while($row=mysqli_fetch_array($res)){ ?>
								  <option value="<?php echo $row['year']; ?>"  ><?php echo $row['year']; ?></option>
								  <?php } ?>
										  </select>
								
									</td>
									
					     <td>&nbsp;</td>
					      <td>&nbsp;</td>
						<td><button type="submit" name="show" class="btn btn-primary">Show</button></td>
						
						</tr>
					
                       </table>
								
					
		</div>
		                       
		</form>
		</div>
	
	<?php if(isset($_POST['show'])) {    
	    
	    $month = $_POST['fmonth'];
	    $year  = $_POST['fyear'];
	    $staff  = $_POST['staff_type'];
	    
	    $sdata = $year.'-'.$month;
	
	  $res=mysqli_query($conn,"Select * from pay_slip WHERE payrollprds = '$sdata' "); 
	
     $count = mysqli_num_rows($res);
	
	if(!$count) { echo "<center><span style='color:red' >No Record Found.</span></center>"; }
	
	?>
	
	
		<form action="transferSalary.php" method="POST" class="form-horizontal" >
		  <div class="tab-content">
		
							<table>
						<tr>
						 <td>&nbsp;</td>  
						 <td>&nbsp;</td>
						<td><center><b>T r a n s f e r - T o</b></center></td>  
						    
						</tr>
						<tr><td>&nbsp;</td>
						</tr>
						
						<tr>
						<td>
				<label class="control-label" for="focusedInput" style="width:170px;">Month :</label></td>
								<td> <div class="input-append">
							<select id="month" name="tmonth"  onchange="change()" size="1"  style="width:170px;" required>
									    <option value="">Select</option>
									      <option value="January">January</option>
										<option value="February">February</option>
										<option value="March">March</option>
										<option value="April">April</option>
										<option value="May">May</option>
										<option value="June">June</option>
										<option value="July">July</option>
										<option value="August">August</option>
										<option value="September">September</option>
										<option value="October">October</option>
										<option value="November">November</option>
										<option value="December">December</option>
									</select>
								  </div>
								</td>
						
						<td><label class="control-label" for="focusedInput" style="width:170px;">Year :</label></td>
							<td><Select name="tyear" id="year" onchange="chnge()" style="width:170px;" required>
							     <option value="">Select</option>
										 <?php 
                                    $res1=mysqli_query($conn, "select distinct year from year");	
                                    while($row1=mysqli_fetch_array($res1)){ ?>
								  <option value="<?php echo $row1['year']; ?>"  ><?php echo $row1['year']; ?></option>
								  <?php } ?>
										  </select>
								</td>
					
					
					       <td> 	<button type="submit" name="submit" class="btn btn-primary">Transfer</button>
								<button class="btn">Cancel</button></td>
						</tr>
						<tr><td>&nbsp;</td></tr>
                       </table>
								
						
						
						
		</div>	    
		    
		<table class="table table-striped table-bordered ">
						  <thead>
							  <tr>
							      <th><input type="checkbox" id="selectall" /> Select All</th>
								  <th>Employee Code</th>
								  <th>Courtesy title</th>
								  <th>FullName</th>
								  <th>Basic Pay</th>
								  <th>Total Earning</th>
								  <th>Total Deductions</th>
								   <th>Net Salary</th>
							  </tr>
						  </thead>   
						  <tbody>
						  <?php
                          
							while($row=mysqli_fetch_assoc($res)){
						  ?>
						  
							<tr>
							    <td><input type="checkbox" class="case"  name="transfer[]" value="<?php echo $row['id']; ?>"></td>
								<td><?php echo $row['emply_code']; ?></td>
								<td class="center"><?php echo $row['staff_Type']; ?></td>
								<td class="center"><?php echo $row['Name']; ?></td>
								<td class="center"><?php echo $row['basicpay']; ?></td>
								<td class="center"><?php echo $row['allowances']; ?></td>
								<td class="center"><?php echo $row['deduction']; ?></td>
								<td class="center"><?php echo $row['net_salary']; ?></td>
							</tr>
							<?php  } ?>
						</tbody>
					</table> 	
					
		              
					
					</form>
		
		  <?php } else {  echo "<center><span style='color:red' >Please Select Month and Year.</span></center>"; } ?>    
		  
		  <br> 
		
			</div>
		
		</div>
<SCRIPT language="javascript">
$(function(){

// add multiple select / deselect functionality
	$("#selectall").click(function () {
		  $('.case').attr('checked', this.checked);
	});

// if all checkbox are selected, check the selectall checkbox
	// and viceversa
	$(".case").click(function(){

if($(".case").length == $(".case:checked").length) {
			$("#selectall").attr("checked", "checked");
		} else {
			$("#selectall").removeAttr("checked");
		}

});
});
</SCRIPT>		
		
                            <?php /////include('footer.php');  ?>

${this.title}

Code Editor : salary_transfer.php