?>
</td>
          <td><?php 
    echo $row['hits'];
    ?>
</td>
          <td><?php 
    echo toshowformatdate($row['postjobdatetime']);
    ?>
</td>
          <td><?php 
    echo toshowformatdate($row['last_edit']);
    ?>
</td>
          <td><?php 
    echo toshowformatdate($row['refresh_date']);
    ?>
</td>
          <td><?php 
    echo $row['jobpostrecruitercontactperson'];
    ?>
</td>
          <td><?php 
    echo $row['jobpostrecruiteremployeremail'];
    ?>
</td>
          <td><?php 
    echo togettotalappyrecn($row['JobID']);
    ?>
</td>
          <td width="20%"><a href="view_jobdetails.php?id=<?php 
                <td><?php 
echo togetfieldvalue($row['bank'], 'tbl_banks', 'bank');
?>
</td>
              </tr>
              
              <tr>
                <td>Last Payment Date</td>
                <td>Last Payment Done</td>
                <td>CMD ID</td>
                <td>&nbsp;</td>
              </tr>
              
              <tr>
                <td><?php 
echo toshowformatdate($row['last_payment_date']);
?>
</td>
                <td><?php 
echo $row['last_payment_done'];
?>
 Rs</td>
                <td><?php 
echo $row['unikdueid'];
?>
</td>
                <td>&nbsp;</td>
              </tr>
              
              <tr><td colspan="4">Notes by User</td></tr>
              <tr><td colspan="4"><?php 
    echo $row['account'];
    ?>
</td>
          <td  height="30"><?php 
    togetaccounttype($row['product_type']);
    ?>
</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 toshowformatdate($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 
    togetstatusofferlabel($row['ac_id'], $row['id'], "status");
    ?>
    ?>
</td>
          <td><?php 
    if ($row['status'] == "1") {
        echo "Active";
    } else {
        echo "In-Active";
    }
    ?>
</td>
          <td  height="30"><?php 
    echo togetrecruiterjobname($row['jobid']);
    ?>
</td>
          <td  height="30"><?php 
    echo toshowformatdate($row['add_date']);
    ?>
</td>
          <td width="15%"><a href="view_jobseekerdetails.php?id=<?php 
    echo $row['ApplicantID'];
    ?>
" >View Details</a><!--<a href="edit_category.php?id=<?php 
    echo $row['ApplicantID'];
    ?>
" >Edit</a>--></td>
        </tr>
        <?php 
    $j++;
}
?>
      </table>
                  <td align="left" class="blackbold" colspan="2"><h5>Current Offer EMI With Amount and Date</h5></td>
                </tr>
                          <tr>
                            <td style="padding:10px 0;" width="25%"><strong>Amount</strong></td>
                            <td style="padding:10px 0;"><strong>Date</strong></td>
                          </tr>
                          <?php 
        while ($rowfp = mysql_fetch_assoc($resultfp)) {
            ?>
                          <tr>
                            <td style="padding:10px 0;"><?php 
            echo $rowfp["emiamount"];
            ?>
 Rs.</td>
                            <td style="padding:10px 0;"><?php 
            echo toshowformatdate($rowfp["emidate"]);
            ?>
</td>
                          </tr>
                          <?php 
        }
        ?>
                    </table>                  
                  </td>
                </tr>
                <tr>
                  <td align="left" class="blackbold" height="1" colspan="2"></td>
                </tr>
                <?php 
    }
}
    ?>
</td> 
          <td  height="30"><?php 
    echo togetcasetype($row['case_type']);
    ?>
</td>
          <td  height="30"><?php 
    echo togetpaymentstatus($row['payin']);
    ?>
</td>
          <td  height="30"><?php 
    echo togetleadsource($row['source']);
    ?>
</td>
          <td  height="30"><?php 
    echo toshowformatdate($row['dateofbirth']);
    ?>
</td>
          <td  height="30"><?php 
    echo $row['phone'];
    ?>
</td>
          <td  height="30"><?php 
    echo $row['email'];
    ?>
</td>
          <td  height="30"><?php 
    echo togetcustomertype($row['type']);
    ?>
</td>
</span>&nbsp;</div>       
        <?php 
    if ($row1["counteroffer"] > 0) {
        ?>
<div class="rws-column"> <?php 
        echo '<i class="fa fa-inr"></i> ' . $row1["counteroffer"];
        ?>
&nbsp;</div> <?php 
    }
    ?>
  
        <?php 
    if ($row1["last_date"] != '0000-00-00') {
        ?>
<div class="rws-column"><?php 
        echo toshowformatdate($row1["last_date"]);
        ?>
&nbsp;</div><?php 
    }
    ?>
  
    </div>
    <?php 
    $i++;
}
?>
</div>
<?php 
/*}*/
?>
    </div>
    <!-- Field Content Ends -->
    
    <div class="gt-fields">
        <div class="gt-label">Account Caption<span class="error">*</span></div>
        <div class="gt-formfields"><?php 
    echo htmlspecialchars($_SESSION['myForm']['caption']);
    ?>
</div>
    </div>
    <!-- Field Content Ends -->
    
    <div class="gt-fields">
	<div class="gt-label">Date of birth<span class="error">*</span></div>
    <div class="gt-formfields"><?php 
    echo toshowformatdate(htmlspecialchars($_SESSION['myForm']['dateofbirth']));
    ?>
</div>
    </div>
    <!-- Field Content Ends -->
    
    <div class="gt-fields">
        <div class="gt-label">Pan Number<span class="error">*</span></div>
        <div class="gt-formfields"><?php 
    echo htmlspecialchars($_SESSION['myForm']['pancard']);
    ?>
</div>
    </div>
    <!-- Field Content Ends -->
    
</div>
        echo '<span style="color:#009e1e; font-weight:bold;">Active</span>';
    } else {
        echo '<span style="color:#FF0000; font-weight:bold;">Suspended</span>';
    }
    ?>
</td>
          <td><?php 
    if ($row['paystatus'] == "1") {
        echo '<span style="color:#009e1e; font-weight:bold;">Clear</span>';
    } else {
        echo '<span style="color:#FF0000; font-weight:bold;">Pending</span>';
    }
    ?>
</td>
          <td><?php 
    echo toshowformatdate($row['expiry_date']);
    ?>
</td>
          <td><?php 
    if ($date != "0000-00-00 00:00:00") {
        echo $row['add_date'];
    } else {
        echo "Never";
    }
    ?>
</td>
          <td><?php 
    if ($row['validate'] == "1") {
        echo "Yes";
    } else {
        echo '<span style="color:#FF0000;">No</span>';