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;