?>
<script>
alert("PLz Select file");
</script>
<?php
return false;
}
$type = explode(".", $_FILES['filename']['tmp_name']);
if (strtolower(end($type)) != 'csv') {
echo "Plz enter csv file";
return false;
} else {
echo $handle = fopen($_FILES['filename']['tmp_name'], "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
if (!empty($data[34])) {
$date = getdbDate($data[34]);
$date = str_replace("/", "-", $date);
$date = explode("-", $date);
echo $year = $date[0];
echo $month = $date[1];
}
$sql1 = "SELECT `emp_id` FROM `mpc_employee_master` WHERE `ticket_no` = {$data['1']}";
$result = mysql_query($sql1) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$empid = $row[0];
$j = 1;
for ($c = 3; $c < 34; $c++) {
echo $status = $data[$c];
echo $date = $year . '-' . $month . '-' . $j;
$j++;
emp_id = '$emp_id',
skills_name = '$skill_name',
experience = '$experience'";
$result_family_education = mysql_query($sql_insert_education) or die("Error in query:".$sql_insert_education."<br>".mysql_error()."<br>".mysql_errno());
*/
if(isset($_POST['emp_offical']))
{
if($_POST['no_refresh'] == $_SESSION['no_refresh'])
{
//echo "WARNING: Do not try to refresh the page.";
}
else
{
$date_joining = getdbDate($_POST['date_joining']);
$plant_name = $_POST['plant_name'];
$department = $_POST['department'];
$sub_department = $_POST['sub_department'];
$grade = $_POST['grade'];
$authority_name = $_POST['authority_name'];
$pan_no = $_POST['pan_no'];
$emp_type = $_POST['emp_type'];
$emp_category = $_POST['emp_category'];
$designation = $_POST['designation'];
$emp_id=$_POST['emp_id'];
$pf_no=$_POST['pf_no'];
$pf_rate=$_POST['pf_rate'];
$date_pf=$_POST['date_pf'];
$pf_nominee=$_POST['pf_nominee'];
$pf_relationship=$_POST['pf_relationship'];
$mode = 'personal_detail';
}
}
if (isset($_POST['emp_family'])) {
if ($_POST['no_refresh'] == $_SESSION['no_refresh']) {
} else {
$father_name = $_POST['father_name'];
$Dependant_member1 = $_POST['Dependant_member1'];
$mother_name = $_POST['mother_name'];
$Dependant_member2 = $_POST['Dependant_member2'];
$father_dob = $_POST['father_dob'];
$mother_dob = getdbDate($_POST['mother_dob']);
$wife_name = $_POST['wife_name'];
$Dependant_member3 = $_POST['Dependant_member3'];
$wife_dob = getdbDate($_POST['wife_dob']);
if (isset($_POST['child_name'])) {
}
$child_name = $_POST['child_name'];
$count = count($child_name);
$child_name = implode(",", $child_name);
$child_dob = $_POST['child_dob'];
for ($i = 0; $i < $count; $i++) {
$child_dependent[] = $_POST['child_dependent' . $i][0];
}
$child_dependent = implode(",", $child_dependent);
for ($i = 0; $i < $count; $i++) {
$child_gender[] = $_POST['child_gender' . $i][0];
}
else
{
$salary_basic=($total_salary_basic/31)/8;
}
$good_work=getGoodWorkBydate($emp_id,getdbDate($month));
if($good_work!="")
{
?>
<tr <? if ($sno%2==1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt">
<td width="5%" align="center"><?=$sno?></td>
<td width="5%" align="center"><?=$row['ticket_no']?></td>
<td width="5%" align="left">
<?=$row['first_name']?> <?=$row['last_name']?><br/>
</td>
<td>
<?=getdesignationMaster('designation_name','rec_id',getdesignationDetail('designation_id',$emp_id,getdbDate($month)));?>
</td>
<td>
<?=$total_salary_basic?></td>
<td>
<?=$good_work?>
</td>
<td>
<?
$good_work=explode(':',$good_work);
$good_work_hour=$good_work[0];
$net_pay=$salary_basic*$good_work[0];
if($good_work[1]=="30")
{
$net_pay=$net_pay+($salary_basic/2);
}
</tr>
<tr>
<td class="text_1">To Date</td>
<td align="left"><input type="text" name="ToDate" id="ToDate" style="width:150px; height:20px;" value="" data-beatpicker="true" /></td>
</tr>
<tr>
<td>
<input type="submit" value="Submit" name="btn_submit" id="btn_submit"/>
</td>
</tr>
</table>
</form>
<?php
if (isset($_POST['btn_submit'])) {
$FromDate = getdbDate($_POST['FromDate']);
$ToDate = getdbDate($_POST['ToDate']);
include "inc/dbconnection.php";
?>
<div style="overflow:scroll;height:300px;">
<table border="0" align="center" width="100%" style="overflow-y:scroll;" class="border">
<tbody><tr class="blackHead">
<td align="center" width="6%">Employee Id</td>
<td align="center" width="7%">Insert Date</td>
<td align="center" width="8%">Employee Name</td>
<td align="center" width="21%">AttandanceStatus</td>
<td align="center" width="19%">Shift</td>
<?php
/* $que = mysql_query("SELECT mpc_attendence_master.*,mpc_employee_master.first_name,mpc_employee_master.last_name
FROM `mpc_attendence_master` inner join `mpc_employee_master` on mpc_employee_master.emp_id = mpc_attendence_master.emp_id
WHERE `date` between '$FromDate' and '$ToDate'"); */
echo $sno_d;
?>
</td>
<td width="5%" align="center"><?php
echo $row['ticket_no'];
?>
<input type="hidden" name="cardNo" id="cardNo" value="<?php
echo $sno_d;
?>
" /></td>
<td width="5%" align="left"><? $empName = $row['first_name'].' '.$row['last_name']?><input type="hidden" name="empName" id="empName" value="<?php
echo $empName;
?>
" /><br/></td>
<td><?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $emp_id, getdbDate($date_upto)));
echo $desig;
?>
<input type="hidden" name="designation" id="designation" value="<?php
echo $desig;
?>
" /></td>
<td><?php
echo $total_salary_basic;
?>
</td>
<td><?php
echo $good_work;
?>
<input type="hidden" name="goodWork" id="goodWork" value="<?php
echo $good_work;
<? include ("inc/dbconnection.php");?>
<? include ("inc/function.php");?>
<?
$date=$_POST['txt_date'];
$db_date=getdbDate($date);
$where_string_sub_department="";
if($_POST["department"]!="")
{
$department=$_POST["department"];
$where_string_department=" rec_id ='$department'";
}
else
{
$where_string_department=" reference_id='0'";
}
if($_POST["sub_department"]!="" and $_POST["department"]!="")
{
$sub_department=$_POST["sub_department"];
$where_string_sub_department="and rec_id ='$sub_department'";
}
if((isset($_POST["employee_type"])!=""))
{
$select_string=",mpc_designation_employee.*,mpc_designation_master.*";
$employee_type=$_POST["employee_type"];
$table_list= ",mpc_designation_employee,mpc_designation_master";
$where_string="and mpc_designation_employee.emp_id = mpc_department_employee.emp_id and mpc_designation_employee.designation_id=mpc_designation_master.rec_id and mpc_designation_master.emp_category='$employee_type' and mpc_designation_employee.to_date='0000-00-00'";
}
?>
<?
<?php
//if (isset($_POST['mon_submit'])) {
include ("inc/dbconnection.php");
include ("inc/function.php");
//eND OF THE PAGE...
$id = "";
$add_div = "";
$hidden_value = "";
$ticket_id = $_REQUEST['id'];
$type = $_REQUEST['type'];
$to = getdbDate($_REQUEST['str']);
$from = getdbDate($_REQUEST['sdate']);
$from_date = str_replace("/", "-", $from);
$to_date = str_replace("/", "-", $to);
$id = getemployeeDetailByTicket('emp_id', $ticket_id);
$shift = $_GET["shift"];
if (isset($_GET['start'])) {
if ($_GET['start'] == 'All') {
echo $start = 0;
} else {
echo $start = $_GET['start'];
}
} else {
$start = 0;
}
$day = substr($_GET["str"], 0, 2);
$month = substr($_GET["str"], 3, 2);
$year = substr($_GET["str"], 6, 4);
$weekly_day = date("l", mktime(0, 0, 0, $month, $day, $year));
$holiday = getHoliday('holiday_name', $date);
<? include ("inc/hr_header.php"); ?>
<?
$date="";
?>
<?
////////////////////// Markin attendence //////////////
if(isset($_POST['btn_attend']))
{
$emp_id=$_POST['emp_id'];
$txt_date=getdbDate($_POST['txt_date']);
$ip = $_SERVER['REMOTE_ADDR'];
$i=1;
foreach($emp_id as $id)
{
$id;
$hr=$_POST['fldHour_'.$i];
$min=$_POST['fldMin_'.$i];
$hr_out=$_POST['out_Hour_'.$i];
$min_out=$_POST['out_Min_'.$i];
$status=$_POST['attendace'.$id];
$good_work=$_POST['good_work_'.$id];
$sec="00";
$time=$hr.":".$min.":".$sec;
$date = "";
?>
<script type="text/javascript" src="javascript/form.js"></script>
<script type="text/javascript" src="javascript/popup.js"></script>
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.css">
<script src="http://code.jquery.com/jquery-1.10.2.min.js"></script>
<script src="http://code.jquery.com/mobile/1.4.2/jquery.mobile-1.4.2.min.js"></script>
<?
////////////////////// Markin attendence //////////////
if (isset($_POST['btn_attend'])) {
$emp_id = $_POST['emp_id'];
$emp_name = $_POST['emp_name'];
echo $txt_date = getdbDate($_POST['txt_date']);
echo $txt_todate = getdbDate($_POST['txt_todate']);
$ip = $_SERVER['REMOTE_ADDR'];
$i = 1;
foreach ($emp_id as $id) {
$id;
$hr = $_POST['fldHour_' . $i];
$min = $_POST['fldMin_' . $i];
$hr_out = $_POST['out_Hour_' . $i];
$min_out = $_POST['out_Min_' . $i];
$status = $_POST['attendace' . $id];
$good_work = $_POST['good_work_' . $id];
$sec = "00";
$time = $hr . ":" . $min . ":" . $sec;
$time_out = $hr_out . ":" . $min_out . ":" . $sec;
<? include ("inc/dbconnection.php");?>
<? include ("inc/function.php");?>
<?
//header("Content-type: application/vnd.ms-excel");
//header("Content-Disposition: attachment; filename=shift_wise_long_leave_report.xls");
?>
<?
$date=$_POST['txt_date'];
$shift=$_POST['shift_detail'];
$data_date=getdbDate($date);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<link href="style/hr_style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td>
DEPTT/SHIFT WISE LONG LEAVE REPORT OF DATE:<?=$date?>
</td>
<td>
SHIFT:<?=$shift?>
</td>
</tr>
<tr>
<td colspan="2">
<table width="100%">
<tr>
<td width="5%" align="center"><b>S.No.</b></td>
<td width="5%" align="center"><b>Department Name.</b></td>
<td align="center"><b>Gratuity Amount</b></td>
</tr>
<?php
while ($row = mysql_fetch_array($result_prj)) {
$total_emp_gratuity = 0;
$dept_net = 0;
$sql = "SELECT * FROM mpc_department_employee,mpc_official_detail where to_date='0000-00-00' and dept_id='" . $row['rec_id'] . "' and mpc_department_employee.emp_id=mpc_official_detail.emp_id";
$result = mysql_query($sql) or die("Error in sql : " . $sql . " : " . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row_dept = mysql_fetch_array($result)) {
$total_salary_basic = 0;
$emp_id = $row_dept['emp_id'];
$total_salary_basic = getSalaryDetail("basic", $emp_id, getdbDate($date_upto));
$date2 = $row_dept['date_joining'];
$date_result = dateDifference($date_upto, $date2);
$date_result['years'];
$emp_gratuity = round($total_salary_basic / 26 * 15 * $date_result['years'], 2);
$total_emp_gratuity = $total_emp_gratuity + $emp_gratuity;
}
}
?>
<tr <?php
if ($sno % 2 == 1) {
?>
bgcolor="#F8F8F8" <?php
}
?>
class="tableTxt">
<td>
SNO
</td>
<td>
EMPLOYEE ID
</td>
<td>
NAME
</td>
<td>
Good Work
</td>
</tr>
<?
$sql_emp = "select mpc_good_work_master.*, mpc_employee_master.rec_id as id,mpc_employee_master.ticket_no,mpc_employee_master.first_name,mpc_employee_master.last_name $select_string from ".$mysql_table_prefix."employee_master,mpc_good_work_master $table_list where mpc_employee_master.rec_id = mpc_good_work_master.emp_id and date='".getdbDate($date)."' and shift='".$shift."' and mpc_good_work_master.good_work!='0:0' $where_string order by ticket_no ASC";
$result_emp = mysql_query($sql_emp) or die("Error in Query :".$sql_emp."<br>".mysql_error().":".mysql_errno());
if(mysql_num_rows($result_emp)>0)
{
$s=1;
while($row_emp=mysql_fetch_array($result_emp))
{
?>
<tr>
<td><?=$s?></td>
<td><?=$row_emp['ticket_no']?></td>
<td>
<?=$row_emp['first_name']?> <?=$row_emp['last_name']?>
</td>
<td>
<? include ("inc/dbconnection.php");?>
<? include ("inc/function.php");?>
<?
$id="";
$add_div = "";
$hidden_value = "";
$ticket_id = $_GET["id"];
$type = $_GET["type"];
$date1 = getdbDate($_GET["str"]);
$date2 = getdbDate($_GET["sdate"]);
$date = str_replace("/","-",$date);
$id=getemployeeDetailByTicket('rec_id',$ticket_id);
$shift=$_GET["shift"];
//$date11=date_create($date1);
//$date1=date_create("2013-03-15");
//$date2=date_create("2013-12-12");
//$diff=date_diff($date1,$date2);
//echo $diff->format("%R%a days");
//$date22=date_create($date2);
//$diff=date_diff($date1,$date2);
//echo $diff;
//echo $diff->format("%R%a days");
?>
<?
if(isset($_GET['start']))
{
if($_GET['start']=='All')
{
$start = 0;
}
else
<? include ("inc/dbconnection.php");?>
<? include ("inc/function.php");?>
<?
if(isset($_GET['submit']))
{
$id="";
$add_div = "";
$hidden_value = "";
$ticket_id = $_GET["id"];
$type = $_GET["type"];
$date = getdbDate($_GET["str"]);
$date = str_replace("/","-",$date);
$id=getemployeeDetailByTicket('emp_id',$ticket_id);
$shift=$_GET["shift"];
?>
<?
if(isset($_GET['start']))
{
if($_GET['start']=='All')
{
$start = 0;
}
else
{
$start = $_GET['start'];
}
}
else
{
}
} else {
if ($mode == "edit") {
$tablename = "ms_purchase_company_master";
$tableColumns = array("company_id", "name", "city");
$tableData = array("'{$PageKeyValue}'", "'{$name}'", "'{$city}'");
updateDataIntoTable($tablename, $tableColumns, $tableData);
$sql_del = "delete from ms_purchase_company_product_master where company_id = '{$PageKeyValue}' ";
$result_del = mysql_query($sql_del) or die("Error in Query: " . $sql_del . "<br/>" . mysql_error() . "<br/>" . mysql_errno());
if (isset($_POST['product_id'])) {
$count = count($_POST['product_id']);
}
for ($i = 0; $i < $count; $i++) {
$product_id = $_POST['product_id'][$i];
$opening_stock = $_POST['opening_stock'][$i];
$opening_date = getdbDate($_POST['opening_date'][$i]);
if ($product_id != "") {
$sql_2 = "INSERT INTO ms_purchase_company_product_master SET\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t company_id = '{$PageKeyValue}',\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t product_id = '{$product_id}',\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t opening_stock = '{$opening_stock}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t opening_date = '{$opening_date}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t InsertDate = now()";
mysql_query($sql_2) or die("Error in query" . mysql_errno() . ":" . mysql_error());
}
}
$Message = "{$PageFor} Updated";
}
}
//redirect("$Page?Message=$Message");
}
$ReferenceId = "";
$product_id = "";
if (isset($_GET["Message"])) {
$Message = $_GET["Message"];
}
