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.144.102.43
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 /
suk_discontinued /
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
DownloadExamAppFormApplication...
5.12
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
24.41
KB
-rwxr-xr-x
MarkEntry-Setup22.php
21.76
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.91
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.03
KB
-rwxr-xr-x
absententrysubjectwiseQP.js
16.34
KB
-rwxr-xr-x
ack_exam_app_form.php
15.86
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.58
KB
-rwxr-xr-x
ack_exam_app_form_oldformat.ph...
12.53
KB
-rwxr-xr-x
ack_rv_rt_application.php
8.35
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
admissionapplist.php
9.9
KB
-rwxr-xr-x
ansbookcancel.php
9.49
KB
-rwxr-xr-x
answer_book_issued.php
10.34
KB
-rwxr-xr-x
approve.php
23.86
KB
-rwxr-xr-x
attendance.php
9.7
KB
-rwxr-xr-x
attendance_freez.php
8.45
KB
-rwxr-xr-x
attendance_freez_old.php
8.55
KB
-rwxr-xr-x
attshort.php
6.29
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
basic_old.css
13.33
KB
-rwxr-xr-x
batch_close.php
4.31
KB
-rwxr-xr-x
bundle_dispatch.php
2.93
KB
-rwxr-xr-x
bundlereceive.php
1.08
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
45.51
KB
-rwxr-xr-x
candidate-entry_new.php
42.85
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-entrynewformat.php
44.16
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
candidate_list.js
39.62
KB
-rwxr-xr-x
cappcontext.php
3.19
KB
-rwxr-xr-x
challan_entries.php
15.41
KB
-rwxr-xr-x
challan_preparation.php
11.69
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_approve.php
5.61
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
connect.php
2.11
KB
-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.95
KB
-rwxr-xr-x
degree.php
6.51
KB
-rwxr-xr-x
display_details_in_grid.php
105.12
KB
-rwxr-xr-x
display_details_in_grid22.php
104.95
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.6
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
display_details_in_gridold.php
102.19
KB
-rwxr-xr-x
doc_verify.php
6.99
KB
-rwxr-xr-x
downloadFeeStatement.php
5.32
KB
-rwxr-xr-x
download_misc_files.php
4.59
KB
-rwxr-xr-x
download_misc_files_old.php
4.3
KB
-rwxr-xr-x
download_photo.php
3.54
KB
-rwxr-xr-x
download_photo22.php
6.83
KB
-rwxr-xr-x
download_photo_new.php
4.82
KB
-rwxr-xr-x
download_photo_sikkim.php
4.82
KB
-rwxr-xr-x
download_photoold.php
3.58
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.63
KB
-rwxr-xr-x
freeze_module_at_admin_college...
9.74
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.76
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
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getdata.php
33.59
KB
-rwxr-xr-x
getdata22.php
32.91
KB
-rwxr-xr-x
getdataold.php
28.7
KB
-rwxr-xr-x
getfeeinformation.php
7.03
KB
-rwxr-xr-x
getmoduledetails.php
23.59
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
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
index.php
5.06
KB
-rwxr-xr-x
json.php
33.22
KB
-rwxr-xr-x
login.php
10.94
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
mascomb.php
10.02
KB
-rwxr-xr-x
mcverifydet.php
14.26
KB
-rwxr-xr-x
message_board.php
4.7
KB
-rwxr-xr-x
messagetext.php
980
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
71.94
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
payment_gateway.php
7.78
KB
-rwxr-xr-x
pclzip.lib.php
192.53
KB
-rwxr-xr-x
photoupload.php
9.28
KB
-rwxr-xr-x
printexamform.php
11.54
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.57
KB
-rwxr-xr-x
report_admission_ticket.php
46.77
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
result.php
5.06
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
16.41
KB
-rwxr-xr-x
room_allotment_datewise.php
16.47
KB
-rwxr-xr-x
room_allotmentnew.php
9.24
KB
-rwxr-xr-x
room_allotmentold.php
15.27
KB
-rwxr-xr-x
roomdeclaration.php
1.88
KB
-rwxr-xr-x
rvdates.php
6.46
KB
-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
stringspliter.php
693
B
-rwxr-xr-x
student.php
43.89
KB
-rwxr-xr-x
student_entry.php
46.56
KB
-rwxr-xr-x
student_entry24.php
56.54
KB
-rwxr-xr-x
student_entry_24112017.php
42.7
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
subjectList_display.php
11.05
KB
-rwxr-xr-x
subject_freshExam.php
18.98
KB
-rwxr-xr-x
subjectfreez.php
13.16
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
9.95
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
79.94
KB
-rwxr-xr-x
teachers.php
14.51
KB
-rwxr-xr-x
teachersOLD.php
10.33
KB
-rwxr-xr-x
teachersnew.php
16.83
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.79
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updateexamcnt.php
2.92
KB
-rwxr-xr-x
upload_studentPhoto.php
8.61
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadzip.php
8.46
KB
-rwxr-xr-x
usersetup.php
25.06
KB
-rwxr-xr-x
usersetupold.php
24.36
KB
-rwxr-xr-x
usersubj_identification.php
4.88
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : usersetupold.php
<?php session_start(); function getUserSetupDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $user_id=($aobj_context->mobj_data["get_user_id"]); $get_user_type="select internal_code,value from s_ref_type where type='user_type'"; $lobj_get_user_type = $aobj_context->mobj_db->GetAll($get_user_type); $arr['user_type']=$lobj_get_user_type; $get_super_viser="select s.internal_code,sysusr as value,value as user_type from s_sysdb s inner join s_ref_type t on t.internal_code=user_type where t.value='Super Wiser' or t.value='User' "; $lobj_get_super_viser = $aobj_context->mobj_db->GetAll($get_super_viser); $arr['super_wiser']=$lobj_get_super_viser; $get_user_group="select s.internal_code,sysusr as value,value as user_type from s_sysdb s inner join s_ref_type t on t.internal_code=user_type where t.value='Group'"; $lobj_get_user_group = $aobj_context->mobj_db->GetAll($get_user_group); $arr['Group']=$lobj_get_user_group; $get_user_group="select s.internal_code,sysusr as value,value as user_type from s_sysdb s inner join s_ref_type t on t.internal_code=user_type where t.value='Department'"; $lobj_get_user_group = $aobj_context->mobj_db->GetAll($get_user_group); $arr['department']=$lobj_get_user_group; if($user_id=='0') { $get_user_details="select * from s_sysdb where internal_code=".$_SESSION['user_id']; $lobj_get_user_details = $aobj_context->mobj_db->GetRow($get_user_details); $arr['user_details']=$lobj_get_user_details; } else { $get_user_details="select * from s_sysdb where internal_code=".$user_id; $lobj_get_user_details = $aobj_context->mobj_db->GetRow($get_user_details); $arr['user_details']=$lobj_get_user_details; } echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function updateUserSetUpDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $is_normal_update=($aobj_context->mobj_data["is_normal_update"]); session_start(); $user_college_code=($aobj_context->mobj_data["user_college_code"]); $user_college_code=empty($user_college_code)?$_SESSION['collcode']:$user_college_code; $is_update_by_editing=($aobj_context->mobj_data["is_update_by_editing"]); $sysusr= addslashes($aobj_context->mobj_data["login_id"]); $sysusrkey=($aobj_context->mobj_data["sysusrkey"]); $user_type_id=($aobj_context->mobj_data["user_type_id"]); $user_type=($aobj_context->mobj_data["user_type_id"]); $user_theme=($aobj_context->mobj_data["user_theme"]); $user_theme=empty($user_theme)?"Tarka":$user_theme; $real_name=addslashes($aobj_context->mobj_data["user_real_name"]); $email_id=addslashes($aobj_context->mobj_data["user_email_id"]); $super_wiser=($aobj_context->mobj_data["super_wiser"]); $user_group=($aobj_context->mobj_data["user_group"]); $can_edit_help_text=($aobj_context->mobj_data["can_edit_help_text"]); $is_password_changed=($aobj_context->mobj_data["is_password_changed"]); if($is_update_by_editing=='0') $int_code=$_SESSION['user_id']; else $int_code=$is_update_by_editing; if($is_normal_update==1) { $update_user="update s_sysdb set sysusr='".($sysusr)."', user_type='".($user_type_id)."', real_name='".($real_name)."', email_id='".($email_id)."', super_wiser='".$super_wiser."', user_group='".$user_group."', user_theme='".$user_theme."', can_edit_help_text='".$can_edit_help_text."' where internal_code=".$int_code; $lobj_update_user = $aobj_context->mobj_db->Execute($update_user); if($is_password_changed==1) { $change_pwd="update s_sysdb set sysusrkey='{$sysusrkey}' where internal_code=".$int_code; $lobj_update_pwd = $aobj_context->mobj_db->Execute($change_pwd); } if($lobj_update_user) { $arr='Updated Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr='Updation Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } else { $check_dup="select count(*) as count from s_sysdb where user_type='{$user_type_id}' and sysusr='{$sysusr}' and college_code='{$user_college_code}'"; $lobj_check_dup = $aobj_context->mobj_db->getRow($check_dup); if($lobj_check_dup[count]==0) { $insert_new_user="insert into s_sysdb( college_code, sysusr, sysusrkey, user_type, real_name, email_id, super_wiser, user_group, can_edit_help_text, user_theme) values ( '{$user_college_code}', '{$sysusr}', '{$sysusrkey}', '{$user_type_id}', '{$real_name}', '{$email_id}', '{$super_wiser}', '{$user_group}', '{$can_edit_help_text}', '{$user_theme}' )"; $lobj_insert_user = $aobj_context->mobj_db->Execute($insert_new_user); if($lobj_insert_user) { $arr='New user has been inserted Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr='Insertion Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } else { $arr='User is allready Exists'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } } } function getUserRightsDetails($aobj_context) { session_start(); $college_code= $_SESSION['collcode'] ; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $get_user_type="select internal_code,value from s_ref_type where type='module_type'"; $college_code=$_SESSION['collcode']; $lobj_get_user_type = $aobj_context->mobj_db->GetAll($get_user_type); $arr['user_rights_module_type']=$lobj_get_user_type; $get_super_viser="select s.internal_code,sysusr as value from s_sysdb s where college_code='{$college_code}' order by sysusr"; $lobj_get_super_viser = $aobj_context->mobj_db->GetAll($get_super_viser); $arr['user_rights_user']=$lobj_get_super_viser; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } /* function getUserRightsModuleNames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $module_type=($aobj_context->mobj_data["module_type"]); $serach_value=($aobj_context->mobj_data["serach_value"]); $user_id=($aobj_context->mobj_data["user_id"]); if(($serach_value!='')) $serach=" where module_name like '%{$serach_value}%'"; else $serach=''; $get_user_type="select s.*,IFNULL(ur.is_view,0) as is_view, IFNULL(ur.is_add,0) as is_add, IFNULL(ur.is_edit,0) as is_edit, IFNULL(ur.is_del,0) as is_del from (select s.internal_code,module_name from s_user_schema s where s.module_type={$module_type}) s left join user_rights ur on ur.module_id=s.internal_code and ur.ref_s_sysdb_code={$user_id} and ur.module_type={$module_type} {$serach}"; $lobj_get_user_type = $aobj_context->mobj_db->GetAll($get_user_type); $module_data=''; $module_data.= "<tr>"; $module_data.="<td class=act_txtclr style='background-color:#0054a5; color:#fff; font-weight:700; width:150px; padding:3px 6px; letter-spacing:0.5pt;'>Module Name</td>"; $module_data.="<td class=act_txtclr style='background-color:#0054a5; color:#fff; font-weight:700; width:50px; padding:3px 6px; letter-spacing:0.5pt;'>View</td>"; $module_data.= "<td class=act_txtclr style='background-color:#0054a5; color:#fff; font-weight:700; width:50px; padding:3px 6px; letter-spacing:0.5pt;'>Add</td>"; $module_data.="<td class=act_txtclr style='background-color:#0054a5; color:#fff; font-weight:700; width:50px; padding:3px 6px; letter-spacing:0.5pt;'>Edit</td>"; $module_data.= "<td class=act_txtclr style='background-color:#0054a5; color:#fff; font-weight:700; width:50px; padding:3px 6px; letter-spacing:0.5pt;'>Delete</td>"; $module_data.= "</tr>"; $k=0; foreach($lobj_get_user_type as $key =>$value) { if($k%2==0) $class='tbl_row'; else $class='tbl_row1'; $is_view_checked=''; $is_add_checked=''; $is_edit_checked=''; $is_del_checked=''; if($value[is_view]==1) $is_view_checked='checked'; if($value[is_add]==1) $is_add_checked='checked'; if($value[is_edit]==1) $is_edit_checked='checked'; if($value[is_del]==1) $is_del_checked='checked'; $module_data.="<tr class={$class} >"; $module_data.="<td style='border-left:1px solid #ccc; padding:2px;' id=module_{$value[internal_code]}>{$value[module_name]}</td>"; $module_data.="<td align='center'><input {$is_view_checked} id=view_{$value[internal_code]} value ={$value[internal_code]} onclick='uncheckIsViewChecked(this.value);' type='checkbox' style='width: 20px;'></td>"; $module_data.="<td align='center'><input {$is_add_checked} id=add_{$value[internal_code]} value ={$value[internal_code]} onclick='checkIsViewChecked(this.value);' type='checkbox' style='width: 20px;'></td>"; $module_data.="<td align='center'><input {$is_edit_checked} id=edit_{$value[internal_code]} value ={$value[internal_code]} onclick='checkIsViewChecked(this.value);' type='checkbox' style='width: 20px;'></td>"; $module_data.="<td align='center'><input {$is_del_checked} id=delete_{$value[internal_code]} value ={$value[internal_code]} onclick='checkIsViewChecked(this.value);' type='checkbox' style='width: 20px;'></td>"; $module_data.="</tr>"; $k++; } $arr['module_data']=$module_data; $arr['module_id_details']=$lobj_get_user_type; //echo $module_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } */ function getUserRightsModuleNames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $module_type=($aobj_context->mobj_data["module_type"]); $serach_value=($aobj_context->mobj_data["serach_value"]); $user_id=($aobj_context->mobj_data["user_id_value"]); if(($serach_value!='')) $serach =" where search_name like '%{$serach_value}%'"; else $serach=''; $modules = "45*,46*,5*,54*,9*"; if(strpos($modules, $module_type) !== false) { $module_type = "s.module_type = {$module_type}"; } else { $module_type = "s.main_memu = {$module_type}"; } $get_user_type="select a.*,b.group_id_for_check from (select a.*, IFNULL(ur.is_view,0) as is_view, IFNULL(ur.is_view_group_records,0) as is_view_group_records, IFNULL(ur.is_view_dep_records,0) as is_view_dep_records, IFNULL(ur.is_view_all_records,0) as is_view_all_records, IFNULL(ur.is_add,0) as is_add, IFNULL(ur.is_edit,0) as is_edit, IFNULL(ur.is_edit_group_records,0) as is_edit_group_records, IFNULL(ur.is_edit_dep_records,0) as is_edit_dep_records, IFNULL(ur.is_edit_all_records,0) as is_edit_all_records, IFNULL(ur.is_del,0) as is_del, IFNULL(ur.is_del_group_records,0) as is_del_group_records, IFNULL(ur.is_del_dep_records,0) as is_del_dep_records, IFNULL(ur.is_del_all_records,0) as is_del_all_records from (select s.group_id, if(s.group_id!=0,concat(s.internal_code,'_',s.group_id),s.internal_code) as internal_code, s.internal_code as is_group_exstis, if(s.group_id!=0,concat(' --',s.group_name),s.display_module_name) as module_name,display_module_name as search_name from ((select s.internal_code,display_module_name,IFNULL(sg.internal_code,0) as group_id,ifnull(sg.name,'')as group_name from s_user_schema s left join s_user_schema_group sg on s.internal_code=ref_s_user_schema_code where s.module_type={$module_type} and s.active=1) union (select s.internal_code,display_module_name,'0' group_id,'' group_name from s_user_schema s where s.module_type={$module_type} and s.active=1 ) order by internal_code,group_id) s )a left join user_rights ur on ur.module_id=a.internal_code and ur.ref_s_sysdb_code={$user_id} and ur.module_type={$module_type} ) a left join (select s.internal_code as module_code,GROUP_CONCAT(IFNULL(sg.internal_code,0)) as group_id_for_check, s.sequence from s_user_schema s left join s_user_schema_group sg on s.internal_code=ref_s_user_schema_code where s.module_type={$module_type} group by s.internal_code) b on b.module_code=a.internal_code {$serach} order by b.sequence"; //var_dump($get_user_type);die(); $lobj_get_user_type = $aobj_context->mobj_db->GetAll($get_user_type); $module_data="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='user_rights_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>"; //$module_data.= "<th>"; $module_data.="<th align='left' colspan='6' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>User Rights</th>"; $module_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $module_data.="<td align='center' style='width:155px; font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Module Name</td>"; $module_data.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>All</td>"; $module_data.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>View <input id='column_view' value ='' onclick= CheckAllColumnValue('View'); type='checkbox' style='width: 20px;'></td>"; $module_data.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Add <input id='column_add' value ='' onclick= CheckAllColumnValue('Add'); type='checkbox' style='width: 20px;'></td>"; $module_data.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Edit <input id='column_edit' value ='' onclick= CheckAllColumnValue('Edit'); type='checkbox' style='width: 20px;'></td>"; $module_data.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Delete <input id='column_delete' value ='' onclick= CheckAllColumnValue('Delete'); type='checkbox' style='width: 20px;'></td>"; $module_data.="</tr>"; $module_data.="<tr class='ui-state-default ui-jqgrid-hdiv'><td align='center' style='width:155px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'></td>"; $module_data.=" <td align='center' style=' border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'></td>"; $module_data.="<td align='center' style='font-size:12px; width:140px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' >Own|group|Dep|All</td>"; $module_data.="<td align='center' style='font-size:12px; width:140px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'></td>"; $module_data.="<td align='center' style='font-size:12px; width:140px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Own|group|Dep|All</td>"; $module_data.="<td align='center' style='font-size:12px; width:140px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Own|group|Dep|All</td></tr>"; $k=0; foreach($lobj_get_user_type as $key =>$value) { $group_color=($value[group_id]=='0')? " font-size:11px;font-weight:bold; ":""; if($k%2==0) $class='tbl_row'; else $class='tbl_row1'; //View $is_view_own_checked=''; $is_view_group_checked=''; $is_view_dep_checked=''; $is_view_all_checked=''; if($value[is_view]==1) $is_view_own_checked='checked'; if($value[is_view_group_records]==1) $is_view_group_checked='checked'; if($value[is_view_dep_records]==1) $is_view_dep_checked='checked'; if($value[is_view_all_records]==1) $is_view_all_checked='checked'; //Add $is_add_checked=''; if($value[is_add]==1) $is_add_checked='checked'; //Edit $is_edit_own_checked=''; $is_edit_group_checked=''; $is_edit_dep_checked=''; $is_edit_all_checked=''; if($value[is_edit]==1) $is_edit_own_checked='checked'; if($value[is_edit_group_records]==1) $is_edit_group_checked='checked'; if($value[is_edit_dep_records]==1) $is_edit_dep_checked='checked'; if($value[is_edit_all_records]==1) $is_edit_all_checked='checked'; //Delete $is_del_own_checked=''; $is_del_group_checked=''; $is_del_dep_checked=''; $is_del_all_checked=''; if($value[is_del]==1) $is_del_own_checked='checked'; if($value[is_del_group_records]==1) $is_del_group_checked='checked'; if($value[is_del_dep_records]==1) $is_del_dep_checked='checked'; if($value[is_del_all_records]==1) $is_del_all_checked='checked'; $disabled=$value[group_id]>=1?" disabled ":" "; $module_data.="<tr class='ui-widget-content jqgrow'>"; $module_data.="<td class='tbl_row_new' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; {$group_color} width:151px;' id=module_{$value[internal_code]}>{$value[module_name]}</td>"; $module_data.="<td class='tbl_row_new' style=' border-right:1px solid #C5DBEC; padding:2px; font-size:12px; {$group_color} width:20px;' id=row_check_{$value[internal_code]}><input type=checkbox id=check_row_{$value[internal_code]} onclick='CheckAllRowValues({$value[internal_code]});' ></input></td>"; $module_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px; font-size:12px; width:134px;'><input {$is_view_own_checked} id=view_own_{$value[internal_code]} value ={$value[internal_code]} onclick='uncheckIsViewChecked(this.value);' type='checkbox' style='width: 20px;'>"; $module_data.="<input {$is_view_group_checked} id='view_group_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'>"; $module_data.="<input {$is_view_dep_checked} id='view_dep_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'>"; $module_data.="<input {$is_view_all_checked} id='view_all_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'></td>"; $module_data.="<td class='tbl_row_new' align='center'style='border-right:1px solid #C5DBEC; padding:2px; font-size:12px;'><input {$is_add_checked} id=add_{$value[internal_code]} value ={$value[internal_code]} onclick='checkIsViewChecked(this.value);' type='checkbox' style='width: 20px;'></td>"; $module_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px; font-size:12px;'><input {$is_edit_own_checked} id=edit_own_{$value[internal_code]} value ={$value[internal_code]} onclick='checkIsViewChecked(this.value);' type='checkbox' style='width: 20px;'>"; $module_data.="<input {$is_edit_group_checked} id='edit_group_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'>"; $module_data.="<input {$is_edit_dep_checked} id='edit_dep_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'>"; $module_data.="<input {$is_edit_all_checked} id='edit_all_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'></td>"; $module_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px; font-size:12px;'><input {$is_del_own_checked} id=delete_own_{$value[internal_code]} {$disabled} value ={$value[internal_code]} onclick='checkIsViewChecked(this.value);' type='checkbox' style='width: 20px;'>"; $module_data.="<input {$is_del_group_checked} id='delete_group_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'>"; $module_data.="<input {$is_del_dep_checked} id='delete_dep_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'>"; $module_data.="<input {$is_del_all_checked} id='delete_all_{$value[internal_code]}' type='checkbox' value ={$value[internal_code]} style='width: 20px;'></td>"; $module_data.="</tr>"; $k++; } $module_data.="</table>"; $arr['module_data']=$module_data; $arr['module_id_details']=$lobj_get_user_type; //echo $module_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function addUserRightsDetails($aobj_context) { session_start(); include_once("/JSON.php"); $json = new Services_JSON(); $module_type = ($aobj_context->mobj_data["module_type"]); $user_id = ($aobj_context->mobj_data["user_rights_user"]); $lstr_param = stripslashes($aobj_context->mobj_data["user_rights_data"]); $mobj_jsondata = $json->decode($lstr_param); $larr_user_rights_data = get_object_vars($mobj_jsondata); $college_code=$_SESSION['collcode']; for( $i = 0; $i < count($larr_user_rights_data); $i++ ) { $del_qry="delete from user_rights where ref_s_sysdb_code={$user_id} and module_type={$module_type} and module_id={$larr_user_rights_data[$i]->id} and college_code='{$college_code}'"; $lobj_del_qry = $aobj_context->mobj_db->Execute($del_qry); $insert_user_rights="insert into user_rights( college_code, ref_s_sysdb_code, module_type, module_id, is_view, is_add, is_edit, is_del) values ( '{$college_code}', {$user_id}, {$module_type}, '{$larr_user_rights_data[$i]->id}', {$larr_user_rights_data[$i]->view_own}, {$larr_user_rights_data[$i]->add}, {$larr_user_rights_data[$i]->view_own}, {$larr_user_rights_data[$i]->delete_own} )"; $lobj_insert_user_rights = $aobj_context->mobj_db->Execute($insert_user_rights); } if($lobj_insert_user_rights) { $arr='User rights inserted Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr='Insertion Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } //User notes details function getUserNotesDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $notedate = ($aobj_context->mobj_data["notedate"]); $user_id = ($aobj_context->mobj_data["user_id"]); $ger_notes="select notes from planner where ref_user_code={$user_id} and act_date='{$notedate}'"; $lobj_ger_notes = $aobj_context->mobj_db->GetRow($ger_notes); if($lobj_ger_notes) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_ger_notes,0,"success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_ger_notes,-1,"Failure"); return; } } function updatePlannerNotes($aobj_context) { $notedate = ($aobj_context->mobj_data["notedate"]); $user_id = ($aobj_context->mobj_data["user_id"]); $planner_note = ($aobj_context->mobj_data["planner_note"]); $del_notes="delete from planner where ref_user_code={$user_id} and act_date='{$notedate}'"; $lobj_del_notes = $aobj_context->mobj_db->Execute($del_notes); $insert_notes="insert into planner (ref_user_code,act_date,notes,modified_date) values ( {$user_id}, '{$notedate}', \"{$planner_note}\", now() )"; $lobj_insert_notes = $aobj_context->mobj_db->Execute($insert_notes); if($lobj_insert_notes) { $data="Notes Updated Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } else { $data="Failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_ger_notes,-1,"Failure"); return; } } function getSavedEventDates($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $year_month = ($aobj_context->mobj_data["year_month"]); $user_id = ($aobj_context->mobj_data["user_id"]); $get_data="select date_format(act_date,'%e') as date_id from planner where date_format(act_date,'%Y%m')='{$year_month}' and ref_user_code={$user_id}"; $lobj_get_data = $aobj_context->mobj_db->GetAll($get_data); if($lobj_get_data) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,-1,"Failure"); return; } } ?>
Close