?> " /></td> <td height="30"><?php echo $row['name']; ?> </td> <td height="30"><?php echo $row['email']; ?> </td> <td height="30"><?php echo $row['mobile']; ?> </td> <td height="30"><?php echo toshowformatdatetime($row['add_date']); ?> </td> </tr> <?php $j++; } ?> </table> <br></td> </tr> </table> <div class="rws-pagination"><?php echo generate_pagination("view_requests.php?page=requests", $totalrows, $perpage, $currentpage); ?> </div>
$rs = mysql_query_with_throw($sql); $perpage = 20; $currentpage = $_REQUEST['currentpage'] ? $_REQUEST['currentpage'] : '1'; $startrecord = ($currentpage - 1) * $perpage; $totalrows = mysql_num_rows($rs); $result = mysql_query_with_throw($sql . " order by add_date desc LIMIT {$startrecord}, {$perpage}") or die(mysql_error()); $header = '<div class="jobsdata"><div class="row header"><div class="checkboxdiv"><input name="chkSelectAll" type="checkbox" id="chkSelectAll" value="1" onClick="selectAllChk()"></div><div class="column">First Name</div><div class="column">Mobile</div><div class="column" style="width:200px;">Email ID</div><div class="column">Resume</div><div class="column">Posted on</div><div class="column">Operation</div></div>'; $repeat = ''; $j = 1; while ($row = mysql_fetch_assoc($result)) { if ($row['jobstatus'] == '1') { $js = 'Active'; } else { $js = 'Inactive'; } $repeat .= '<div class="row"><div class="checkboxdiv"><input name="chkjobid[' . $j . ']" type="checkbox" value="' . $row['ApplicantID'] . '"></div><div class="column">' . $row['applicantfirstname'] . '</div><div class="column">' . $row['applicantmobile'] . '</div><div class="column" style="width:200px;">' . $row['applicantemail'] . '</div><div class="column"><a href="useruploads/' . togetpath($row["add_date"]) . $row['applicantcvattachment'] . '" target="_blank">View Resume</a></div><div class="column">' . toshowformatdatetime($row["add_date"]) . '</div><div class="column"><a href="index.php?p=applicantdetails&aptid=' . $row['ApplicantID'] . '&jobid=' . $_GET['jobid'] . '">View Details</a></div></div>'; $j++; } echo $header . $repeat . '</div>'; ?> <div class="clear"></div> <div class="row"> <em><strong>With selected</strong> </em>: <a href="javascript:del_rec();">Delete</a></div> <hr/> </form> <div class="row" align="center"><br /> <?php echo generate_pagination("index.php?p=viewapplicants&jobid=" . $_GET["jobid"], $totalrows, $perpage, $currentpage); ?> <br />
if ($totalrows > 0) { $header = '<div class="jobsdata"><div class="row header"><div class="checkboxdiv"><input name="chkSelectAll" type="checkbox" id="chkSelectAll" value="1" onClick="selectAllChk()"></div><div class="column">Job Title</div><div class="column">Town/City</div><div class="column">Expiry Date</div><div class="column">Hits</div><div class="column">Status</div><div class="column">View Applicants</div><div class="column">Last Updated</div><div class="column">Add Date</div><div class="column">Posted by</div><div class="column">Respond Email</div><div class="column">Functions</div></div>'; $repeat = ''; $j = 1; while ($row = mysql_fetch_assoc($result)) { if ($row['jobstatus'] == '1') { $js = '<span style="color:#009e1e; font-weight:bold;">Active</span>'; } else { $js = '<span style="color:#FF0000; font-weight:bold;">Inactive</span>'; } if (in_array($row["JobID"], $chkididtest)) { $checked = 'checked="checked"'; } else { $checked = ''; } $repeat .= '<div class="row"><div class="checkboxdiv"><input name="chkjobid[' . $j . ']" type="checkbox" value="' . $row['JobID'] . '" ' . $checked . '></div><div class="column">' . $row['jobpostsubject'] . '</div><div class="column">' . $row['jobpostlocationtowncity'] . '</div><div class="column">' . $row['enddate'] . '</div><div class="column">' . $row['hits'] . '</div><div class="column">' . $js . '</div><div class="column">' . togettotalappyrec($row['JobID']) . '</div><div class="column">' . toshowformatdatetime($row['last_edit']) . ' </div><div class="column">' . toshowformatdatetime($row['postjobdatetime']) . '</div><div class="column">' . $row['jobpostrecruitercontactperson'] . '</div><div class="column">' . $row['jobpostrecruiteremployeremail'] . '</div><div class="column"><a href="index.php?p=editjobs&jobid=' . $row['JobID'] . '">Edit</a> || <a href="index.php?p=viewjobdetails&jobid=' . $row['JobID'] . '">View</a></div></div>'; $j++; } echo $header . $repeat . '</div>'; } else { echo "<script>document.location.href='index.php';</script>"; } ?> <div class="clear"></div> <hr/> </form> <div class="row" align="center"><br /> <?php echo generate_pagination("index.php?p=viewjobsstatus&sid=" . $sid, $totalrows, $perpage, $currentpage);
togetaccounttype($row['product_type']); ?> </td> <td height="30"><?php echo togetbankname($row['ac_id']); ?> </td> <td style="text-align:right; padding-right:20px;" height="30"><a href="view-userdetailsnew.php?page=users&id=<?php echo $row['ac_id']; ?> &lightbox[width]=500&lightbox[height]=70p" title="View Details" class="lightbox"><?php echo $row['account_no']; ?> </a></td> <td height="30"><?php echo toshowformatdatetime($row['account_date']); ?> </td> <td><?php if ($row['status'] == "1") { echo '<span style="color:#009e1e; font-weight:bold;">Verified</span>'; } elseif ($row['status'] == "2") { echo '<span style="color:#FF0000; font-weight:bold;">Rejected</span>'; } else { echo '<span style="color:#0068b1; font-weight:bold;">Pending</span>'; } ?> </td> <td><?php echo $row['resolve_status']; ?>