function _execute($sql, $values = null, $insert_id = false)
{
if ($values != null && count($values) == 0) {
$values = null;
}
#log
error_log(getDatetime() . " db->sql:" . $sql . " ->values:" . json_encode($values) . "\n", "3", getPath() . "console.log");
#con
$con = getConnection();
$stmt = $con->prepare($sql);
#bind param
if ($values) {
$args = "";
for ($i = 0; $i < count($values); $i++) {
$value = $values[$i];
if (is_integer($value)) {
$args .= 'i';
} else {
if (is_double($value) || is_float($value)) {
$args .= 'd';
} else {
if (is_string($value)) {
$args .= 's';
} else {
$args .= 'b';
}
}
}
}
if (!empty($args) && !empty($stmt)) {
call_user_func_array(array($stmt, 'bind_param'), array_merge((array) $args, $values));
}
}
$stmt->execute();
if ($insert_id) {
$id = $stmt->insert_id;
#close
$stmt->close();
closeConnection($con);
#return
return $id;
} else {
#close
$stmt->close();
closeConnection($con);
}
}
<td align="center">
<?php
echo getdeptDetail('department_name', 'rec_id', $row["dept_id"]);
?>
</td>
<td align="center">
<?php
echo getDatetime($row["from_date"]);
?>
</td>
<td align="center">
<?
if ($row["to_date"] == '0000-00-00') {
echo 'TODAY';
} else {
echo getDatetime($row["to_date"]);
}
?>
</td>
<td align="center"><a href="javascript:;" onClick="get_frm('edit_department_list.php', '<?php
echo $row["department_id"];
?>
', 'div_edit', '')"><img src="images/Modify.png" alt="Edit" title="Edit" border="0"></a>
</td>
<td align="center"><a href="javascript:;" onClick="overlay(<?php
echo $row["department_id"];
?>
);">
<img src="images/Delete.png" alt="Delete" title="Delete" border="0"></a>
</td>
</tr>
if ($id == 0) {
?>
<form action="" method="post" name="frm_releaving" id="frm_releaving">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td colspan="2" class="blackHead">Releaving Detail</td>
</tr>
<tr>
<td align="left" valign="top">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td class="text_1">Date of Leaving</td>
<!-- my code -->
<!--<td><input type="text" name="releaving_date" id="releaving_date" style="width:150px; height:20px;" value="<?php
echo getDatetime($date_releaving);
?>
" data-beatpicker="true" data-beatpicker-position="['right','*']" data-beatpicker-format="['DD','MM','YYYY']" /></td> -->
<!--My code End Here -->
<td><input type="text" name="releaving_date" id="releaving_date" style="width:180px; height:20px;" readonly="readonly" value="<?php
//=getDatetime($date_releaving)
?>
" data-beatpicker="true" data-beatpicker-position="['right','*']" data-beatpicker-format="['DD','MM','YYYY']" />
<a href="javascript:void(0)" onclick="gfPop.fPopCalendar(document.frm_releaving.releaving_date);"><img name="popcal" align="absbottom" src="./calendar/calbtn.gif" width="27" height="22" border="0" alt=""/></a></td>
</tr>
</table>
</td>
<td>
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td>
<?php
echo $row_emp['first_name'];
?>
<?php
echo $row_emp['last_name'];
?>
</td>
<td>
<?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row_emp['emp_id'], $db_date));
?>
</td>
<td>
<?php
echo getDatetime($row_emp['date_joining']);
?>
</td>
</tr>
<?
$s++;
}
}
}
}
}
}
?>
</table>
</td>
</tr>
</tr>
</table>
</td>
<td valign="top">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0">
<tr>
<td width="50%" class="text_1">Other Deduction's</td>
<td width="50%"><input type="text" name="other_deduction" id="other_deduction" style="width:180px; height:20px;" value="<?php
echo $other_deductions;
?>
" onblur="sum_salary()"/></td>
</tr>
<tr>
<td width="50%" class="text_1">Effective Date</td>
<td width="50%"><form name="frm_emp_list" id="frm_emp_list"><input type="text" name="from_date" id="from_date" style="width:130px; height:20px;" value="<?php
echo getDatetime($from_date);
?>
"/> <a href="javascript:void(0)" onclick="gfPop.fPopCalendar(document.frm_emp_list.from_date);"><img name="popcal" align="absbottom" src="./calendar/calbtn.gif" width="27" height="22" border="0" alt=""/></a> </form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0">
<tr>
<td width="49%" class="text_1"><strong>Earnings</strong></td>
<td width="51%"><input type="text" name="total_earning" id="total_earning" style="width:180px; height:20px;" value="<?php
echo $total_earning;
?>
$designation_from_date = "";
$sql = "SELECT * FROM mpc_designation_employee where emp_id = '{$id}' and to_date='0000-00-00'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
$designation_id = $row['designation_id'];
$designation_from_date = getDatetime($row['from_date']);
}
}
$sql = "SELECT * FROM mpc_department_employee where emp_id = '{$id}' and to_date='0000-00-00'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
$dept_id = $row['dept_id'];
$main_dept_id = getdeptDetail('reference_id', 'rec_id', $dept_id);
$dept_from_date = getDatetime($row['from_date']);
}
}
?>
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td colspan="2" class="blackHead">Department / Designation Detail</td>
</tr>
<tr>
<td align="left">
<div id="div_department_edit">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td class="text_1" width="40%">Department</td>
<td align="left" width="60%">
<?php
</tr>
<?
while ($row = mysql_fetch_array($result_prj)) {
$present = 0;
$absent = 0;
$h = 0;
$wo = 0;
$Pl = 0;
$Cl = 0;
$HalfCl = 0;
$Total = 0;
?>
<tr <? if ($sno % 2 == 1) { ?> bgcolor="#F8F8F8" <? } ?> class="tableTxt">
<td align="center"><?= $sno ?><br/><?= $off_day = getweeklyoffDetail('off_day', $row['id'], $start_date) ?></td>
<td align="center"><?= $row['ticket_no'] ?></td>
<td align="left" ><?= $row['first_name'] ?> <?= getfamilyDetail('father_name', $row['id']) ?><br/><?= getDatetime(getofficeDetail('date_joining', $row['id'])) ?>/<?= getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['id'], $start_date)); ?></td>
<?
$start_date = "01";
$day1 = $start_date;
$month1 = $month;
$year1 = $year;
$day1 = $day1 + 1;
$end_date = date("t", strtotime($year . "-" . $month . "-01"));
$day2 = $end_date;
$month2 = $month;
$year2 = $year;
<? include ("inc/function.php");?>
<?
$url = "list_advance.php";
$advance = "";
$ad_date = "";
$adv_id = "";
if(isset($_GET["id"]))
{
$adv_id = $_GET["id"];
$sql = "select * from mpc_advance_employee where rec_id = '$adv_id'";
$result = mysql_query($sql) or die("Error in sql : ".mysql_errno()." : ".mysql_error()." : ".$sql);
$row = mysql_fetch_array($result);
$advance = $row["advance"];
$ad_date = getDatetime($row["ad_date"]);
}
?>
<form name="frm" action="<?php
echo $url;
?>
" method="post">
<table width="60%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td align="center" valign="middle">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="left" class="text_1" style="padding-left:15px;"><b>Advance</b></td>
<td align="left"><input type="text" name="txt_advance" id="txt_advance" value="<?php
echo $advance;
?>
<div <?php
if ($mode == 'education_detail') {
echo 'class="current"';
} else {
echo 'class="simpleTabsContent"';
}
?>
>
<form name="offical_profile" id="offical_profile" action="employee_detail.php" method="post" enctype="multipart/form-data" onSubmit="return valid_customer(this);">
<table align="center" width="100%" cellpadding="2" cellspacing="2" class="border" border="0" style="padding-top:10px;">
<tr>
<td width="50%" valign="top"><table align="center" width="100%" cellpadding="2" cellspacing="2" class="border">
<tr>
<td class="text_1">Date of Joining</td>
<td align="left"><input type="text" name="date_joining" id="date_joining" style="width:150px; height:20px;" value="<?php
echo getDatetime($date_joining);
?>
"/>
<a href="javascript:void(0)" onClick="gfPop.fPopCalendar(document.offical_profile.date_joining);" HIDEFOCUS><img name="popcal" align="absbottom" src="./calendar/calbtn.gif" width="34" height="22" border="0" alt=""></a></td>
</tr>
<tr>
<td class="text_1">Plant</td>
<td align="left"><?php
$sql = "SELECT * FROM mpc_plant_master order by plant_name";
$result = mysql_query($sql) or die("Error in sql : " . $sql . " : " . mysql_errno() . " : " . mysql_error());
?>
<select name="plant_name" id="plant_name" style="width:150px; height:20px;">
<option value="">Select</option>
<?php
while ($row = mysql_fetch_array($result)) {
?>
<td><input type="text" name="pf_no" id="pf_no" style="width:180px; height:20px;" value="<?php
echo $pf_number;
?>
"/></td>
</tr>
<tr>
<td class="text_1">PF Rate</td>
<td><input type="text" name="pf_rate" id="pf_rate" style="width:180px; height:20px;" value="<?php
echo $pf_rate;
?>
"/></td>
</tr>
<tr>
<td class="text_1">Date of PF Membership</td>
<td align="left"><input type="text" name="date_pf" id="date_pf" style="width:150px; height:20px;" value="<?php
echo getDatetime($date_pf);
?>
" data-beatpicker="true" />
</td>
</tr>
</table></td>
<td width="50%"><table width="100%" height="100px" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td class="text_1">PF Nominee</td>
<td><input type="text" name="pf_nominee" id="pf_nominee" style="width:180px; height:20px;" value="<?php
echo $pf_nominee;
?>
"/></td>
</tr>
<tr>
<td class="text_1">RelationShip</td>
<td>
:<?php
echo getemployeeDetail('first_name', $emp_id);
?>
<?php
echo getemployeeDetail('last_name', $emp_id);
?>
</td>
</tr>
<tr>
<td>
DATE OF JOINING
</td>
<td>
:<?php
echo getDatetime(getofficeDetail('date_joining', $emp_id));
?>
</td>
</tr>
</table>
</td>
<td>
DESIGNATION :<?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $emp_id, $date_month));
?>
</td>
<td>
DEPARTMENT:<?php
echo getdeptDetail('department_name', 'rec_id', getdepartmentDetail('dept_id', $emp_id, $date_month));
?>
</td>
<?
$url = "list_advance_deduction.php";
$txt_deduction = "";
$deduction_by = "";
$deduction_date = "";
$ded_id = "";
if(isset($_GET["id"]))
{
$ded_id = $_GET["id"];
$sql = "select * from mpc_advance_employee where rec_id = '$ded_id'";
$result = mysql_query($sql) or die("Error in sql : ".mysql_errno()." : ".mysql_error()." : ".$sql);
$row = mysql_fetch_array($result);
$txt_deduction = $row["deduction"];
$deduction_date = getDatetime($row["deduction_date"]);
$deduction_by = $row["deduction_by"];
}
?>
<form name="frm" action="<?php
echo $url;
?>
" method="post">
<table width="60%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td align="center" valign="middle">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="left" class="text_1" style="padding-left:15px;"><b>Advance Deduction</b></td>
<td align="left"><input type="text" name="txt_deduction" id="txt_deduction" value="<?php
echo $txt_deduction;
</td>
<td width="15%" align="left">
<?php
echo getSalaryDetail('basic', $emp_id, getdbDateSepretoe($txt_from_date));
?>
</td>
<td width="15%" align="left">
<?php
echo getDatetime(getofficeDetail('date_joining', $emp_id));
?>
</td>
<td width="15%" align="left">
<?php
echo getDatetime($row['dob']);
?>
</td>
</tr>
<?
$sno++;
}
?>
</tbody>
</table> </div>
</td>
</tr>
<?
}
if (isset($_POST["btn_delete"])) {
$PageKeyValue = $_POST["hidden_overlay"];
$sql = "delete from ms_purchase_product_master where {$PageKey} = '" . $PageKeyValue . "'";
mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
$Message = "{$PageFor} Sucessfully Deleted";
redirect("{$Page}?Message={$Message}");
}
if (isset($_GET[$PageKey])) {
$sql = "select * from ms_purchase_product_master where {$PageKey} = '" . $_GET[$PageKey] . "'";
$result = mysql_query($sql) or die("Invalid query : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$PageKeyValue = $row[$PageKey];
$name = $row["product_name"];
$existing_stock = $row["opening_stock"];
$opening_date = getDatetime($row["opening_date"]);
}
}
?>
<table width="98%" cellpadding="0" cellspacing="0" align="center" border="0">
<tr>
<td align="left" valign="top" width="230px" style="padding-top:5px;">
<?php
include "inc/purchase_snb.php";
?>
</td>
<td style="padding-left:5px; padding-top:5px;">
<table width="100%" cellpadding="0" cellspacing="0" align="center" border="0">
<tr>
<td align="center" class="gray_bg"><img src="images/bullet.gif" width="15" height="22"/> Add Product</td>
<?
$url = "list_loan_installment.php";
$txt_deduction = "";
$deduction_by = "";
$deduction_date = "";
$install_id = "";
if(isset($_GET["id"]))
{
$install_id = $_GET["id"];
$sql = "select * from mpc_loan_installments where rec_id = '$install_id'";
$result = mysql_query($sql) or die("Error in sql : ".mysql_errno()." : ".mysql_error()." : ".$sql);
$row = mysql_fetch_array($result);
$installments = $row["installments"];
$installment_date = getDatetime($row["installment_date"]);
$installment_by = $row["installment_by"];
}
?>
<form name="frm" action="<?php
echo $url;
?>
" method="post">
<table width="60%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td align="center" valign="middle">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="left" class="text_1" style="padding-left:15px;"><b>Loan Deduction</b></td>
<td align="left"><input type="text" name="txt_installments" id="txt_installments" value="<?php
echo $installments;
<td><?=$s?></td>
<td><?=$row_emp['ticket_no']?></td>
<td>
<?=$row_emp['first_name']?> <?=$row_emp['last_name']?>
</td>
<td>
<?=$leave_type?>
</td>
<td>
<?=dateDiffDB("-", $end_date,$start_date)?>
</td>
<td>
<?=getDatetime($start_date)?>
</td>
<td>
<?=getDatetime($end_date)?>
</td>
</tr>
<?
}
$s++;
}
}
}
}
}
}
?>
</table>
</td>
</tr>
<td width="15%" align="center"><b>Advance</b></td>
<td width="15%" align="center"><b>Advance Date</b></td>
</tr>
</thead>
<?
$sno=1;
while($row=mysql_fetch_array($result_prj))
{
?>
<tr>
<td align="center"><?=$sno?></td>
<td align="center"><?=$row['ticket_no']?></td>
<td align="left"><?=$row['first_name']?> <?=$row['last_name']?></td>
<td align="center"><?=$row['advance']?></td>
<td align="center"><?=getDatetime($row["ad_date"]);?></td>
</tr>
<?
$sno++;
}
}
else
{
?>
<tr class="table_rows">
<td align="center" colspan="8">No records found</td>
</tr>
<?
}
?>
</table>
if ($check != "") {
$k++;
if ($temp == "") {
$from_date = $check;
$temp = $check;
} else {
if ($temp2 != "") {
$to_date = $check;
}
}
} else {
if ($temp != "" and $temp2 != "") {
if ($k == 1) {
$to_date = $from_date;
}
echo getDatetime($from_date) . " to " . getDatetime($to_date);
$total_cl = $total_cl + dateDiffDB("-", $to_date, $from_date) + 1;
echo "<br/>";
$temp = "";
$temp2 = "";
$k = 0;
} else {
$temp2 = "0";
}
}
}
}
?>
</td>
<td><?php
echo $total_cl;
$id = "";
$id = $_GET["id"];
$date_releaving = "";
$reason_realeaving = "";
$sql = "SELECT * FROM mpc_account_detail where emp_id = '{$id}'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result)) {
$date_releaving = $row['date_releaving'];
$reason_realeaving = $row['reason_realeaving'];
$reason_realeaving = $reason_realeaving;
}
}
if ($date_releaving != "0000-00-00 00:00:00") {
if ($date_releaving != "") {
$date_releaving = getDatetime($date_releaving);
}
//$reason_realeaving = nl2br($reason_realeaving);
?>
<div id="div_update_releave">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td colspan="2" class="blackHead">Releaving Detail</td>
</tr>
<tr>
<td align="left" valign="top">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td class="text_1">Date of Leaving</td>
<td><?php
echo $date_releaving;
<td width="15%" align="center"><b>Deduction Date</b></td>
<td width="15%" align="center"><b>Deduction By</b></td>
</tr>
</thead>
<?
$sno=1;
while($row=mysql_fetch_array($result_prj))
{
?>
<tr>
<td align="center"><?=$sno?></td>
<td align="center"><?=$row['ticket_no']?></td>
<td align="left"><?=$row['first_name']?> <?=$row['last_name']?></td>
<td align="center"><?=$row['deduction']?></td>
<td align="center"><?=getDatetime($row["deduction_date"]);?></td>
<td align="center"><?=$row["deduction_by"];?></td>
</tr>
<?
$sno++;
}
}
else
{
?>
<tr class="table_rows">
<td align="center" colspan="8">No records found</td>
</tr>
<?
}
?>
$sql = "select * from mpc_designation_employee where designation_id = '$emp_designation_id'";
$result = mysql_query($sql) or die("Error in sql : ".mysql_errno()." : ".mysql_error()." : ".$sql);
$row = mysql_fetch_array($result);
//$emp_id = $row["emp_id"];
//$emp_designation_id = $row["designation_id"];
$emp_type=getdesignationMaster('emp_category','rec_id',$emp_designation_id);
$from_date = getDatetime($row["from_date"]);
if($row["to_date"]=='0000-00-00')
{
$to_date = date('d/m/Y');
}
else
{
$to_date = getDatetime($row["to_date"]);
}
//$emp_id = $row["emp_id"];
$rec_id=$row['rec_id'];
}
?>
<form name="frm" action="<?php
echo $url;
?>
" method="post">
<table width="100%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td align="center" valign="middle">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="left" class="text_1" style="padding-left:15px;"><b>Category</b></td>
include "inc/dbconnection.php";
include "inc/function.php";
$url = "list_loan.php";
$loan_amount = "";
$installments_decided = "";
$loan_date = "";
$loan_id = "";
if (isset($_GET["id"])) {
$loan_id = $_GET["id"];
$sql = "select * from mpc_loan_employee where rec_id = '{$loan_id}'";
$result = mysql_query($sql) or die("Error in sql : " . mysql_errno() . " : " . mysql_error() . " : " . $sql);
$row = mysql_fetch_array($result);
$loan_amount = $row["loan_amount"];
$installments_decided = $row["installments_decided"];
$loan_date = getDatetime($row["loan_date"]);
}
?>
<form name="frm" action="<?php
echo $url;
?>
" method="post">
<table width="60%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td align="center" valign="middle">
<table align="center" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="left" class="text_1" style="padding-left:15px;"><b>Loan Amount</b></td>
<td align="left"><input type="text" name="txt_loan" id="txt_loan" value="<?php
echo $loan_amount;
?>
}
?>
</div>
</td>
</tr>
<tr>
<td class="text_1">Pin Code<span class="red">*</span></td>
<td align="left"><input type="text" name="pin_code" id="pin_code" style="width:150px; height:20px;" value="<?php
echo $pincode;
?>
"/></td>
</tr>
<tr>
<td class="text_1">Date Of Birth<span class="red">*</span></td>
<td align="left"><input type="text" name="dob" id="dob" style="width:150px; height:20px;" value="<?php
echo getDatetime($dob);
?>
"/>
<a href="javascript:void(0)" onClick="gfPop.fPopCalendar(document.empolyee_profile.dob);" HIDEFOCUS><img name="popcal" align="absbottom" src="./calendar/calbtn.gif" width="34" height="22" border="0" alt=""></a>
</td>
</tr>
</table>
</td>
<td width="50%" valign="top">
<table align="center" width="100%" cellpadding="2" cellspacing="2" class="border" border="0">
<tr>
<td width="43%" class="text_1">Gender<span class="red">*</span></td>
<td width="57%" align="left" class="text_1" style="padding-left:0px;">
<?php
echo $gender;
?>
echo $off_day = getweeklyoffDetail('off_day', $row['id'], $start_date);
?>
</td>
<td width="5%" align="center"><?php
echo $row['ticket_no'];
?>
</td>
<td width="15%" align="left"><?php
echo $row['first_name'];
?>
<?php
echo getfamilyDetail('father_name', $row['id']);
?>
<br/>
<?php
echo getDatetime(getofficeDetail('date_joining', $row['id']));
?>
/
<?php
echo getdesignationMaster('designation_name', 'rec_id', getdesignationDetail('designation_id', $row['id'], $start_date));
?>
</td>
<?php
$start_date = "01";
$day1 = $start_date;
$month1 = $month;
$year1 = $year;
$day1 = $day1 + 1;
$end_date = date("t", strtotime($year . "-" . $month . "-01"));
$day2 = $end_date;
$month2 = $month;
</td>
<td><?php
echo $row_emp['ticket_no'];
?>
</td>
<td>
<?php
echo $row_emp['first_name'];
?>
<?php
echo $row_emp['last_name'];
?>
</td>
<td>
<?php
echo getDatetime(getLastLeaveByEmpID($row_emp['emp_id']));
?>
</td>
<td>
</td>
<td>
<?php
echo getLeavestatus($row_emp['emp_id'], 'PL');
?>
</td>
<td>
<?php
echo getLeavestatus($row_emp['emp_id'], 'CL');
?>
</td>
<td>
?>
</table>
</td>
<td width="50%" valign="top">
<table align="center" width="100%" cellpadding="2" cellspacing="2" class="border">
<tr>
<td class="text_1" width="35%">Father's DOB</td>
<td align="left" width="65%"><input type="text" name="father_dob" id="father_dob" style="width:210px; height:26px;" value="<?php
echo $father_dob;
?>
" data-beatpicker="true"></td>
</tr>
<tr>
<td class="text_1">Mother's DOB</td>
<td align="left"><input type="text" name="mother_dob" id="mother_dob" style="width:210px; height:26px;" value="<?php
echo getDatetime($mother_dob);
?>
" data-beatpicker="true" data-beatpicker-format="['DD','MM','YYYY']" />
</td>
</tr>
<?php
if ($_SESSION['marital_sta'] === 'yes') {
?>
<tr>
<td class="text_1">Spouse DOB </td>
<td align="left"><input type="text" name="wife_dob" id="wife_dob" style="width:210px; height:26px;" value="<?php
echo $wife_dob;
?>
" data-beatpicker="true" data-beatpicker-format="['DD','MM','YYYY']" /></td>
</tr>
<?php
<?php
include_once 'common.php';
#log
error_log(getDatetime() . " action->" . phpSelfname() . "\n", "3", getPath() . "console.log");
#check session
$user = !empty($_SESSION['user']) ? $_SESSION['user'] : header("Location:" . htaccess('admin/core/login.php?t=timeout'));
#main
include_once getTPL();
echo $row['first_name'];
?>
<?php
echo $row['last_name'];
?>
</td>
<td align="center"><?php
echo $row['loan_amount'];
?>
</td>
<td align="center"><?php
echo $row['installments_decided'];
?>
</td>
<td align="center"><?php
echo getDatetime($row["loan_date"]);
?>
</td>
<td align="center"><a href="javascript:;" onClick="get_frm('edit_loan.php','<?php
echo $row["loan_id"];
?>
','div_edit','')">
<img src="images/Modify.png" alt="Edit" title="Edit" border="0"></a></td>
<td align="center"><a href="javascript:;" onClick="overlay(<?php
echo $row["loan_id"];
?>
);">
<img src="images/Delete.png" alt="Delete" title="Delete" border="0"></a>
</td>
</tr>
<?php
</table>
</div>
<?
} else if ($id == 0) {
?>
<form action="" method="post" name="frm_releaving" id="frm_releaving">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td colspan="2" class="blackHead">Relieving Detail</td>
</tr>
<tr>
<td align="left" valign="top">
<table width="100%" cellpadding="2" cellspacing="2" align="center" border="0" class="border">
<tr>
<td class="text_1">Date</td>
<td><input type="text" name="releaving_date" id="releaving_date" style="width:180px; height:20px;" readonly="readonly" value="<?= getDatetime($date_releaving) ?>"/>
<a href="javascript:void(0)" onclick="gfPop.fPopCalendar(document.frm_releaving.releaving_date);"><img name="popcal" align="absbottom" src="./calendar/calbtn.gif" width="27" height="22" border="0" alt=""/></a></td>
</tr>
<tr>
<td class="text_1" valign="top">Reason</td>
<td>
<select id="releaving_reason" name="releaving_reason">
<option value="1" selected="selected">Retirement</option>
<option value="2" selected="selected">Department Disablement</option>
<option value="3" selected="selected">Death in Service</option>
<option value="4" selected="selected">Resignation</option>
<option value="5" selected="selected">Termination</option>
</select>
</td>
</tr>
?>
</td>
<td>
<table align="center" cellpadding="0" cellspacing="0" border="1" width="100%">
<?php
$sql_1 = "select * from ms_purchase_company_product_master where company_id = '" . $row["company_id"] . "' ";
$result_1 = mysql_query($sql_1) or die("Error in sql : " . $sql_1 . " : " . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result_1) > 0) {
while ($row_1 = mysql_fetch_array($result_1)) {
$product_id = $row_1['product_id'];
$sql_item = "select * from ms_purchase_product_master where product_id='{$product_id}'";
$sql_res = mysql_query($sql_item) or die(mysql_error());
$row_item = mysql_fetch_array($sql_res);
$product_name = $row_item['product_name'];
$opening_stock = $row_1['opening_stock'];
$opening_date = getDatetime($row_1['opening_date']);
?>
<tr>
<td>
<?php
echo $product_name;
?>
</td>
<td>
<?php
echo $opening_stock;
?>
</td>
<td>
<?php
echo $opening_date;
