$sarr_count = count($s_val_arr); if ($sarr_count < 2) { $result = db_query("select * from pms_employee\n\t\t\t\t\t\t\t\t where first_name LIKE '%" . $s_val_arr[0] . "%'\n\t\t\t\t\t\t order by employee_id\n\t\t\t\t\t\t \t "); } else { if ($sarr_count == 3) { $result = db_query("select * from pms_employee\n\t\t\t\t\t\t\t\t where first_name LIKE '%" . $s_val_arr[1] . "%'\n\t\t\t\t\t\t\t\t\tand last_name LIKE '%" . $s_val_arr[2] . "%'\n\t\t\t\t\t\t order by employee_id\n\t\t\t\t\t\t \t "); } else { $result = db_query("select * from pms_employee\n\t\t\t\t\t\t\t\t where first_name LIKE '%" . $s_val_arr[0] . "%'\n\t\t\t\t\t\t\t\t\tand last_name LIKE '%" . $s_val_arr[1] . "%'\n\t\t\t\t\t\t order by employee_id\n\t\t\t\t\t\t \t "); } } $i = 0; foreach ($result as $record) { $empid[$i] = $record->employee_id; $erid[$i] = $record->erid; $profile_pic[$i] = get_profile_image($record->profile_picture); $emp_name[$i] = get_empname_wtmn($record->employee_id); $company[$i] = get_description_detail('PMS_MASTER_COMPANY', 'name', 'code', $record->company_id); $location[$i] = get_description_detail('PMS_MASTER_ENTITY', 'name', 'code', $record->location_id); if ($record->designation_id == '' || $record->designation_id == null) { $designation[$i] = '-- NA --'; } else { $designation[$i] = get_description_detail('PMS_MASTER_DESIGNATION', 'designation_name', 'designation_id', $record->designation_id); } if ($record->category_id == '' || $record->category_id == null) { $category[$i] = '-- NA --'; } else { $category[$i] = get_description_detail('PMS_MASTER_CATEGORY', 'description', 'category_id', $record->category_id); } if ($record->grade_id == '' || $record->grade_id == null) { $grade[$i] = '-- NA --'; } else {
print render($title_suffix); ?> <div class="content"<?php print $content_attributes; ?> > <ul> <?php $result = db_query("select * from pms_employee where extract(month from marriage_date) ='" . date("m") . "' and extract(day from marriage_date) ='" . date("d") . "' \n\t\t\t\t\t\t and marital_status = 'Married' "); $i = 0; foreach ($result as $record) { $emp_id = $record->employee_id; $mobile = get_description_detail('pms_employee_address', 'mobile', 'employee_id', $emp_id); $name = get_empname_wtmn($emp_id); $image = get_profile_image($record->profile_picture); $imgurl = 'sites/default/files/profile/'; if (empty($image)) { $image = 'User_0.png'; } ?> <li> <div class="left_div"> <div class="b_image"> <?php print "<img src=" . $imgurl . $image . " />"; ?> </div> <div class="b_title">
</div> <ul> <li><?php print get_empname_wtmn($emp_id); ?> <a href="#">(<?php print $emp_id; ?> )</a></li> <?php } else { ?> <li><?php print get_empname_wtmn($emp_id); ?> <a href="#">(<?php print $emp_id; ?> )</a></li> <?php } $temp_marriage_date = $marriage_date; ?> <?php $i++; } if ($i == 0) { ?>