window.location = "paywait.php" '; } ?>
prepare("SELECT * from notifications ORDER BY `id` DESC LIMIT 100"); $notificationSql->execute(); $i = 1; while ($notificationData = $notificationSql->fetch()) { // print_r($notificationData); $usersArray = explode(',', $notificationData['user_id']); if ($i <= 10) { if (in_array($userdata['id'], $usersArray)) { echo $notificationData['notification']; $i++; } else { if ($userdata['usertype'] == $notificationData['user_id'] || $userdata['id'] == $notificationData['user_id']) { echo $notificationData['notification']; $i++; } } } } ?>
prepare("select * from loginusers WHERE username = ?"); $disql->execute([$userdata['createby']]); $dis_data = $disql->fetch(); ?>
Service Enabled/Disabled Status
EKO Code => Aeps Balance
BPCC Branch Code =>
Vendor-

Recharge Service

Pan Card Service

Mobile App Service

Online App & Token Service

UTI Service

Cropping Service

AEPS Service

Order Request Service

Camera Service

User Management

NEW PAN PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='newpan' "); $sql->execute(['process']); $result = $sql->fetchColumn(); echo $result; ?>
CSF PAN PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='csfpan' "); $sql->execute(['process']); $result = $sql->fetchColumn(); echo $result; ?>
NEW HOLD PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='newpan' "); $sql->execute(['holdprocess']); $result = $sql->fetchColumn(); echo $result; ?>
CSF HOLD PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='csfpan' "); $sql->execute(['holdprocess']); $result = $sql->fetchColumn(); echo $result; ?>
Node Server Status
Online

"; } else { fclose($connection); echo "

Offline

"; } } catch (Exception $e) { echo "

Error

"; } ?>
Protean Balance
NEW Order Pending
prepare("select count(*) from order_request WHERE status = ?"); $sql->execute(['pending']); $result = $sql->fetchColumn(); echo $result; ?>
NEW Users Pending
prepare("select count(*) from loginusers WHERE status = ?"); $sql->execute(['pending']); $result = $sql->fetchColumn(); echo $result; ?>
Ticket Pending
prepare("select count(*) from tickets WHERE status = ?"); $sql->execute(['open']); $result = $sql->fetchColumn(); echo $result; ?>
Mobile Apply Pending
prepare("select count(*) from mobile_application WHERE status=?"); $sql->execute(['pending']); $result = $sql->fetchColumn(); echo $result; ?>
UTI Users Pending
prepare("select count(*) from loginusers WHERE utistatus = ?"); $sql->execute(['pending']); $result = $sql->fetchColumn(); echo $result; ?>
UTI Coupons Pending
prepare("select count(*) from couponreq WHERE status = ?"); $sql->execute(['pending']); $result = $sql->fetchColumn(); echo $result; ?>
PSA Password Pending
prepare("select count(*) from psapassreq WHERE status = ?"); $sql->execute(['pending']); $result = $sql->fetchColumn(); echo $result; ?>
Payment Pending
prepare("select count(*) from paymentreq WHERE status=? AND type = ? AND web_url=?"); $sql->execute(['pending', 'payment', $_SERVER['SERVER_NAME']]); $result = $sql->fetchColumn(); echo $result; ?>
NEW VERIFY PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='newpan' AND verification_status = ? AND bo_status = ? AND apply_status = ? and formType = ? "); $sql->execute(['process', 'pending', 'pending', 'pending', 'bpcc']); $result = $sql->fetchColumn(); echo $result; ?>
CSF VERIFY PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='csfpan' AND verification_status = ? AND bo_status = ? AND apply_status = ? "); $sql->execute(['process', 'pending', 'pending', 'pending']); $result = $sql->fetchColumn(); echo $result; ?>
NEW PAN BPCC PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='newpan' AND verification_status = ? AND bo_status = ? AND apply_status = ? "); $sql->execute(['process', 'success', 'pending', 'pending']); $result = $sql->fetchColumn(); echo $result; ?>
CSF PAN BPCC PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='csfpan' AND verification_status = ? AND bo_status = ? AND apply_status = ? "); $sql->execute(['process', 'success', 'pending', 'pending']); $result = $sql->fetchColumn(); echo $result; ?>
NEW B.O. PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='newpan' AND verification_status = ? AND bo_status = ? AND apply_status = ? "); $sql->execute(['success', 'success', 'pending', 'success']); $result = $sql->fetchColumn(); echo $result; ?>
CSF B.O. PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='csfpan' AND verification_status = ? AND bo_status = ? AND apply_status = ? "); $sql->execute(['success', 'success', 'pending', 'success']); $result = $sql->fetchColumn(); echo $result; ?>
NEW HOLD PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='newpan' "); $sql->execute(['holdprocess']); $result = $sql->fetchColumn(); echo $result; ?>
CSF HOLD PENDING
prepare("select count(*) from bpccpancard WHERE status = ? AND type='csfpan' "); $sql->execute(['holdprocess']); $result = $sql->fetchColumn(); echo $result; ?>
Retailer(Employee)
prepare("select count(*) from loginusers WHERE usertype = ?"); $sql->execute(['retailer']); $result = $sql->fetchColumn(); echo $result . "-"; $sql = $conn->prepare("select count(*) from loginusers WHERE usertype = ?"); $sql->execute(['employee']); $result = $sql->fetchColumn(); echo "" . $result . ""; ?>
Distributor(Super Distributor)
prepare("select count(*) from loginusers WHERE usertype = ?"); $sql->execute(['distributor']); $result = $sql->fetchColumn(); echo "" . $result . ""; echo "-"; $sql = $conn->prepare("select count(*) from loginusers WHERE usertype = ?"); $sql->execute(['supdistributor']); $result = $sql->fetchColumn(); echo "" . $result . ""; ?>
BPCC:PAN Track
Status
UTI: PAN Track
Status
BPCC: e-PAN Download
e-PAN
UTIITSL: e-PAN Download
e-PAN
COURIER Track
Status
REPRINT UTI PAN
Apply
REPRINT BPCC PAN
Apply
How To Fill PAN Applications
1. PAN Application form and Supporting Documents to be scanned in Color Format with 200 DPI.
2. Use Cropping Tool to Crop Photo & Signature also sign sholud be in black ink.
3.For Major Correction in Pan Anexure A form with Id card is compulsory.
Support
Contact Us: /
Email- /
Notification From ADMIN
prepare("SELECT * from portal_msgs WHERE `created_by` = ? ORDER BY `id` DESC LIMIT 100"); $notificationSql->execute(['mainadmin']); $i = 1; while ($notificationData = $notificationSql->fetch()) { // print_r($notificationData); $usersArray = explode(',', $notificationData['user_id']); if ($i <= 10) { if (in_array($userdata['id'], $usersArray) || $userdata['usertype'] == $notificationData['user_id']) { echo $notificationData['notification']; $i++; } } } ?>
Notification From BRANCH
prepare("SELECT * from portal_msgs WHERE `created_by` != ? ORDER BY `id` DESC LIMIT 100"); $notificationSql->execute(['mainadmin']); $i = 1; while ($notificationData = $notificationSql->fetch()) { // print_r($notificationData); $usersArray = explode(',', $notificationData['user_id']); if ($i <= 10) { if (in_array($userdata['id'], $usersArray) || $userdata['usertype'] == $notificationData['user_id']) { echo $notificationData['notification']; $i++; } } } ?>