Gecko [ thearyasamaj.org ]

Name	Size	Permission
common	[ DIR ]	drwxr-xr-x
arya_AdminInclude_11-01-16.php	1002 B	-rw-r--r--
arya_AdminInclude_13-01-16.php	1.06 KB	-rw-r--r--
arya_AdminInclude_16-09-14.php	811 B	-rw-r--r--
arya_addactivities_28-03-14.ph...	16.43 KB	-rw-r--r--
arya_addadminpages_14-08-14.ph...	13.62 KB	-rw-r--r--
arya_addadmissionnotification_...	32.91 KB	-rw-r--r--
arya_addadvertisement_18-12-14...	23.42 KB	-rw-r--r--
arya_addarticle_05-08-14.php	30.03 KB	-rw-r--r--
arya_addarticle_25-11-15.php	29.99 KB	-rw-r--r--
arya_addaryasamajtab_28-03-14....	22.29 KB	-rw-r--r--
arya_addaudioalbum_28-03-14.ph...	23.93 KB	-rw-r--r--
arya_addauthor_13-09-14.php	20.12 KB	-rw-r--r--
arya_adddiscategory_28-03-14.p...	28.26 KB	-rw-r--r--
arya_adddiscover_04-08-14.php	27.41 KB	-rw-r--r--
arya_addelectionappointment_02...	16.17 KB	-rw-r--r--
arya_addengvarriable_25-03-14....	8.84 KB	-rw-r--r--
arya_addevents_26-01-16.php	50.97 KB	-rw-r--r--
arya_addevents_28-03-14.php	50.96 KB	-rw-r--r--
arya_addeventtype_28-03-14.php	29.83 KB	-rw-r--r--
arya_addfestival_23-07-14.php	30.54 KB	-rw-r--r--
arya_addfiledownload_09-12-14....	12.06 KB	-rw-r--r--
arya_addimportantplaces_28-03-...	35.98 KB	-rw-r--r--
arya_addinstituteprofile_02-10...	23.85 KB	-rw-r--r--
arya_addinstituteprofile_09-05...	23.84 KB	-rw-r--r--
arya_addinstitutetype_04-08-14...	33.23 KB	-rw-r--r--
arya_addinstitution_09-10-14.p...	56.08 KB	-rw-r--r--
arya_addlanguage_04-08-14.php	13.81 KB	-rw-r--r--
arya_addmagazines_02-01-15.php	38.12 KB	-rw-r--r--
arya_addmagazinetitle_09-10-14...	44.28 KB	-rw-r--r--
arya_addmember_29-05-14.php	37.84 KB	-rw-r--r--
arya_addmembertype_04-08-14.ph...	22.95 KB	-rw-r--r--
arya_addmobileaudio_05-12-14.p...	23.51 KB	-rw-r--r--
arya_addmobileaudio_06-01-16.p...	9.1 KB	-rw-r--r--
arya_addmobileaudio_08-01-16.p...	8.69 KB	-rw-r--r--
arya_addmobileimage_05-12-14.p...	20.91 KB	-rw-r--r--
arya_addnews_arvind-18-01-19.p...	61.42 KB	-rw-r--r--
arya_addobituary_18-10-14.php	27.42 KB	-rw-r--r--
arya_addphotogallery_28-03-14....	29.04 KB	-rw-r--r--
arya_addportalhomeslidebanner_...	11.62 KB	-rw-r--r--
arya_addportalsection_04-08-14...	22.76 KB	-rw-r--r--
arya_addportaltab_18-04-14.php	24.93 KB	-rw-r--r--
arya_addprimaryrecord_28-03-14...	47.92 KB	-rw-r--r--
arya_addproduct_28-03-14.php	20.39 KB	-rw-r--r--
arya_addradioairing_04-08-14.p...	18.93 KB	-rw-r--r--
arya_addscndtestquestions_12-1...	24.82 KB	-rw-r--r--
arya_addscndtimeline_17-12-14....	24.27 KB	-rw-r--r--
arya_addsecndryfestival_20-02-...	20.89 KB	-rw-r--r--
arya_addsecondaryactivity_18-0...	15.66 KB	-rw-r--r--
arya_addservices_28-03-14.php	17.99 KB	-rw-r--r--
arya_addstreamingbanner_28-03-...	20.97 KB	-rw-r--r--
arya_addtest_28-05-14.php	15.62 KB	-rw-r--r--
arya_addtestlevel_28-05-14.php	22.6 KB	-rw-r--r--
arya_addtestquestions_27-08-14...	45.74 KB	-rw-r--r--
arya_addtimeline_16-12-14.php	16.6 KB	-rw-r--r--
arya_addtimeline_17-12-14.php	16.92 KB	-rw-r--r--
arya_addtimeline_29-12-14.php	14.26 KB	-rw-r--r--
arya_addvacancy_27-05-14.php	34.54 KB	-rw-r--r--
arya_addvideoalbum_28-03-14.ph...	23.91 KB	-rw-r--r--
arya_addvideogallery_28-03-14....	21.82 KB	-rw-r--r--
arya_addwallpaper_28-03-14.php	9.19 KB	-rw-r--r--
arya_addwebsite_28-03-14.php	18.06 KB	-rw-r--r--
arya_adminlogin_18-03-15.php	7.26 KB	-rw-r--r--
arya_articleautoauthor_05-06-1...	342 B	-rw-r--r--
arya_articlependinglist_22-09-...	21.08 KB	-rw-r--r--
arya_autologout_15-03-14.php	1.94 KB	-rw-r--r--
arya_changepasswordpopup_05-05...	5.53 KB	-rw-r--r--
arya_ckeditor2_14-10-14.php	1.64 KB	-rw-r--r--
arya_ckeditor3_14-10-14.php	1.64 KB	-rw-r--r--
arya_downloadallfile_31-03-14....	2.06 KB	-rw-r--r--
arya_downloadfile_20-12-14.php	1.21 KB	-rw-r--r--
arya_downloadpendinglist_03-03...	24.68 KB	-rw-r--r--
arya_editactivities_28-03-14.p...	23.07 KB	-rw-r--r--
arya_editadminpages_14-08-14.p...	17.92 KB	-rw-r--r--
arya_editadmissionnotification...	40.28 KB	-rw-r--r--
arya_editadvertisement_04-08-1...	29.7 KB	-rw-r--r--
arya_editarticle_11-01-16.php	38.44 KB	-rw-r--r--
arya_editarticle_25-11-15.php	38.41 KB	-rw-r--r--
arya_editarticle_27-10-14.php	38.39 KB	-rw-r--r--
arya_editaryasamajtab_28-03-14...	21.9 KB	-rw-r--r--
arya_editaudioalbum_28-03-14.p...	28.46 KB	-rw-r--r--
arya_editauthor_04-11-14.php	24.92 KB	-rw-r--r--
arya_editdiscategory_28-03-14....	16.11 KB	-rw-r--r--
arya_editdiscover_04-08-14.php	34.54 KB	-rw-r--r--
arya_editelectionappointment_1...	20.12 KB	-rw-r--r--
arya_editelectionappointment_1...	20.06 KB	-rw-r--r--
arya_editevents_19-11-14.php	64.12 KB	-rw-r--r--
arya_editeventtype_28-03-14.ph...	20.59 KB	-rw-r--r--
arya_editfestival_28-03-14.php	38.51 KB	-rw-r--r--
arya_editfiledownload_20-12-14...	22.21 KB	-rw-r--r--
arya_editimportantplaces_18-09...	43.96 KB	-rw-r--r--
arya_editinstitutetype_04-08-1...	23.15 KB	-rw-r--r--
arya_editinstitution_01-10-15....	71.83 KB	-rw-r--r--
arya_editinstitution_02-10-15....	73.92 KB	-rw-r--r--
arya_editinstitution_09-10-14....	55.89 KB	-rw-r--r--
arya_editinstitution_29-09-15....	55.8 KB	-rw-r--r--
arya_editlanguage_04-08-14.php	16.45 KB	-rw-r--r--
arya_editmagazines_08-11-14.ph...	54.04 KB	-rw-r--r--
arya_editmagazinetitle_09-10-1...	53.82 KB	-rw-r--r--
arya_editmember_28-03-14.php	47.21 KB	-rw-r--r--
arya_editmembertype_04-08-14.p...	9.27 KB	-rw-r--r--
arya_editmlevelcategory_04-08-...	9.71 KB	-rw-r--r--
arya_editmobileaudio_06-01-16....	8.9 KB	-rw-r--r--
arya_editmobileaudio_08-01-16....	8.5 KB	-rw-r--r--
arya_editmobileaudio_11-12-14....	8.9 KB	-rw-r--r--
arya_editmobileimage_11-12-14....	9.32 KB	-rw-r--r--
arya_editmpowercategory_04-08-...	10.36 KB	-rw-r--r--
arya_editnews_05-12-14.php	70.37 KB	-rw-r--r--
arya_editnews_13-10-15.php	70.37 KB	-rw-r--r--
arya_editobituary_18_10-14.php	31.32 KB	-rw-r--r--
arya_editphotogallery_28-03-14...	22.85 KB	-rw-r--r--
arya_editportalhomeslidebanner...	13.23 KB	-rw-r--r--
arya_editportaltab_16-04-14.ph...	14.91 KB	-rw-r--r--
arya_editportaltab_17-04-14.ph...	15.18 KB	-rw-r--r--
arya_editprimaryrecord_28-03-1...	68.73 KB	-rw-r--r--
arya_editproduct_28-03-14.php	24.67 KB	-rw-r--r--
arya_editquestioncategory_04-0...	4.83 KB	-rw-r--r--
arya_editradioairing_04-08-14....	23.88 KB	-rw-r--r--
arya_editscndtestquestions_27-...	19.24 KB	-rw-r--r--
arya_editscndtimeline_17-12-14...	19.98 KB	-rw-r--r--
arya_editsecndryfestival_20-02...	15.32 KB	-rw-r--r--
arya_editsecondaryactivity_18-...	13.04 KB	-rw-r--r--
arya_editsecondaryservice_18-0...	13.08 KB	-rw-r--r--
arya_editservices_28-03-14.php	27.4 KB	-rw-r--r--
arya_editstreamingbanner_28-03...	24.27 KB	-rw-r--r--
arya_edittestquestions_27-08-1...	36.17 KB	-rw-r--r--
arya_edittestquestions_28-03-1...	34.6 KB	-rw-r--r--
arya_edittimeline_29-12-14.php	16.88 KB	-rw-r--r--
arya_editvacancy_27-05-14.php	44.08 KB	-rw-r--r--
arya_editvideoalbum_28-03-14.p...	29.72 KB	-rw-r--r--
arya_editvideogallery_28-03-14...	26.26 KB	-rw-r--r--
arya_editwallpaper_28-03-14.ph...	10.34 KB	-rw-r--r--
arya_editwebsite_28-03-14.php	22.98 KB	-rw-r--r--
arya_forgotpwd_06-05-14.php	5.37 KB	-rw-r--r--
arya_ftpfile_02-01-15.php	1.44 KB	-rw-r--r--
arya_header_29-10-14.php	7.48 KB	-rw-r--r--
arya_home_24-12-15.php	640 B	-rw-r--r--
arya_insertpamphlet_21-09-15.p...	15.51 KB	-rw-r--r--
arya_insertpamphlet_25-01-16.p...	15.51 KB	-rw-r--r--
arya_insertpamphlet_28-03-14.p...	16.01 KB	-rw-r--r--
arya_instoffpendinglist_26-05-...	19.27 KB	-rw-r--r--
arya_instpendinglist_01-10-15....	17.35 KB	-rw-r--r--
arya_instpendinglist_28-09-15....	16.42 KB	-rw-r--r--
arya_instphotoupload_18-12-14....	14.98 KB	-rw-r--r--
arya_mailinsquickupload_28-11-...	9.64 KB	-rw-r--r--
arya_memberautodelete_21-06-14...	4.96 KB	-rw-r--r--
arya_menu_14-03-16.php	13.82 KB	-rw-r--r--
arya_mgzndownload_20-12-14.php	2.06 KB	-rw-r--r--
arya_mlevelcategory_04-08-14.p...	23.69 KB	-rw-r--r--
arya_mngactivities_19-06-14.ph...	26.23 KB	-rw-r--r--
arya_mngadmin_18-06-14.php	23.63 KB	-rw-r--r--
arya_mngadminpages_19-06-14.ph...	18.29 KB	-rw-r--r--
arya_mngadmissionnotification_...	20.56 KB	-rw-r--r--
arya_mngadvertisement_19-06-14...	24.17 KB	-rw-r--r--
arya_mngarticle_03-11-14.php	80.54 KB	-rw-r--r--
arya_mngarticle_16_Dec_15.php	80.66 KB	-rw-r--r--
arya_mngauthor_13-09-14.php	22.95 KB	-rw-r--r--
arya_mngblocksequence_15-10-14...	11.64 KB	-rw-r--r--
arya_mngcity_19-06-14.php	22.76 KB	-rw-r--r--
arya_mngcountry_19-06-14.php	19.4 KB	-rw-r--r--
arya_mngcurrentadminlogin_15-0...	4.32 KB	-rw-r--r--
arya_mngdiscover_19-06-14.php	31.28 KB	-rw-r--r--
arya_mngdynamicpages_21-06-14....	18.32 KB	-rw-r--r--
arya_mngelectionappointment_11...	26.85 KB	-rw-r--r--
arya_mngelectionappointment_12...	26.84 KB	-rw-r--r--
arya_mngelectionappointment_16...	27.22 KB	-rw-r--r--
arya_mngengvariable_25-03-14.p...	20.87 KB	-rw-r--r--
arya_mngevents_19-06-14.php	43.6 KB	-rw-r--r--
arya_mngfestival_19-06-14.php	30.69 KB	-rw-r--r--
arya_mngfiledownload_12-03-15....	31.33 KB	-rw-r--r--
arya_mngfiledownload_24-09-15....	31.39 KB	-rw-r--r--
arya_mngimportantplaces_19-06-...	35.95 KB	-rw-r--r--
arya_mnginstitution_09-10-14.p...	107.28 KB	-rw-r--r--
arya_mnginstitution_29-09-15.p...	107.21 KB	-rw-r--r--
arya_mnginstmgzadmin_17-06-14....	38.8 KB	-rw-r--r--
arya_mngmagazines_08-11-14.php	25.66 KB	-rw-r--r--
arya_mngmagazinetitle_09-10-14...	51.98 KB	-rw-r--r--
arya_mngmember_03-10-15.php	76.76 KB	-rw-r--r--
arya_mngmember_09-02-16.php	77.33 KB	-rw-r--r--
arya_mngmember_16_dec_15.php	77.04 KB	-rw-r--r--
arya_mngmember_17-10-14.php	76.08 KB	-rw-r--r--
arya_mngmobileaudio_11-06-15.p...	17.53 KB	-rw-r--r--
arya_mngnews_27-11-14.php	52.54 KB	-rw-r--r--
arya_mngobituary_15-10-14.php	23.06 KB	-rw-r--r--
arya_mngperson_19-06-14.php	51.31 KB	-rw-r--r--
arya_mngpollquestions_19-06-14...	33.89 KB	-rw-r--r--
arya_mngportalhomeslidebanner_...	22.52 KB	-rw-r--r--
arya_mngproduct_19-06-14.php	19.32 KB	-rw-r--r--
arya_mngquickuploads_16-12-14....	28.25 KB	-rw-r--r--
arya_mngradioairing_19-06-14.p...	17.72 KB	-rw-r--r--
arya_mngreporter_19-06-14.php	39.48 KB	-rw-r--r--
arya_mngservices_19-06-14.php	25.44 KB	-rw-r--r--
arya_mngstate_19-06-14.php	20.19 KB	-rw-r--r--
arya_mngstreaming_19-06-14.php	21.1 KB	-rw-r--r--
arya_mngstreamingbanner_19-06-...	20.88 KB	-rw-r--r--
arya_mngtestquestions_04-12-14...	33.56 KB	-rw-r--r--
arya_mngtimeline_26-12-14.php	35.04 KB	-rw-r--r--
arya_mngvacancy_19-06-14.php	25.94 KB	-rw-r--r--
arya_mngvacancy_29-04-14.php	26.58 KB	-rw-r--r--
arya_mngvedmantra_19-06-14.php	25.09 KB	-rw-r--r--
arya_mngwallpaper_19-06-14.php	13.99 KB	-rw-r--r--
arya_mngwebsite_19-06-2014.php	19.61 KB	-rw-r--r--
arya_mobileaudiopending_11-12-...	14.4 KB	-rw-r--r--
arya_mpowercategory_04-08-14.p...	26.06 KB	-rw-r--r--
arya_newsphotoupload_31-01-15....	16.3 KB	-rw-r--r--
arya_obituaryphotos_28-03-14.p...	15.62 KB	-rw-r--r--
arya_otherlangvarriable_25-04-...	12.02 KB	-rw-r--r--
arya_pendingtabs_18-12-14.php	5.19 KB	-rw-r--r--
arya_pendingtabs_29-09-15.php	5.26 KB	-rw-r--r--
arya_persnphotoupload_28-03-14...	16.76 KB	-rw-r--r--
arya_placephotoupload_28-03-14...	16.99 KB	-rw-r--r--
arya_pushnotification_23-09-14...	6.45 KB	-rw-r--r--
arya_quickautodelete_14-05-14....	1.39 KB	-rw-r--r--
arya_quickupldpendinglist_19-1...	36.03 KB	-rw-r--r--
arya_reportpendinglist_13-05-1...	53.47 KB	-rw-r--r--
arya_searchvariablename_15-03-...	352 B	-rw-r--r--
arya_sendquickuploadmail_29-10...	4.41 KB	-rw-r--r--
arya_timelinependinglist_17-12...	28.17 KB	-rw-r--r--
arya_uploadtakeatour_28-05-14....	38.87 KB	-rw-r--r--
arya_viewadminLaPower_arvind-1...	9.24 KB	-rw-r--r--
arya_viewadminactivity_27-03-1...	9.14 KB	-rw-r--r--
arya_viewadminactivity_arvind-...	9.15 KB	-rw-r--r--
arya_viewadminhistory_arvind-1...	7.21 KB	-rw-r--r--
arya_viewadminpower_arvind-14-...	12.76 KB	-rw-r--r--
arya_viewadminprofile_arvind-1...	5.43 KB	-rw-r--r--
arya_viewnewsphotos_28-11-14.p...	7.77 KB	-rw-r--r--
arya_viewobituarymessage_15-10...	6.17 KB	-rw-r--r--
arya_viewobituaryphoto_14-03-1...	7.08 KB	-rw-r--r--
arya_viewpendingquickupload_02...	18.1 KB	-rw-r--r--
arya_viewpendingreport_09-04-1...	17.43 KB	-rw-r--r--
arya_viewquickuploads_02-10-14...	17.91 KB	-rw-r--r--
arya_viewreport_09-04-14.php	17.43 KB	-rw-r--r--
arya_wallpaper_24-02-14.php	570 B	-rw-r--r--

Code Editor : arya_mngreporter_19-06-14.php

<?php 
if($_SERVER['SERVER_NAME']=='www.thearyasamaj.org' || $_SERVER['SERVER_NAME']=='thearyasamaj.org')
{
	date_default_timezone_set('Asia/Kolkata');
}
include('arya_AdminInclude.php');
// created by vaishali
//header start
include('arya_header.php'); 
//header over
// link start
include("arya_menu.php");
// link over
// content start
//This is used for admin rights wise display field Start Added By Navneet 22/01/2013
$usersessid=$_SESSION["adminuserid"];
//$dbusername=getFieldValue('user_name','arya_adminuser','admuser_id="'.$usersessid.'"');
$dbusercatid=getFieldValue('admcat_id','arya_adminuser','admuser_id="'.$usersessid.'"');
$dbusercatname=getFieldValue('admcat_title','arya_adminusercategory','admcat_id="'.$dbusercatid.'"');
$rightsid=mysql_query('SELECT admsecright_pageid FROM arya_adminsectionrights WHERE admcat_id IN('.$dbusercatid.') AND admuser_id="'.$usersessid.'"');
while($rightfetch=mysql_fetch_array($rightsid))
{
	$admcatrightsid[]=$rightfetch['admsecright_pageid'];	
}
foreach($admcatrightsid as $key)
{
	$qry="select * from arya_adminpage where page_sectionid='".$key."'";
	$q=mysql_query($qry);
	while($fetch=mysql_fetch_array($q))
	{
		$pagename=$fetch['page_filename'];
		$path = $_SERVER['REQUEST_URI'];
		$headername = basename($path);
		$url_parts = parse_url($headername);
   		$constructed_url = $url_parts['scheme'] . '' . $url_parts['hostname'] . $url_parts['path'];
		if($constructed_url==$pagename)
		{
			
			$newrightsarray=getFieldValueArray('admsecright_edit,admsecright_delete,admsecright_approve,admsecright_sdelete,admsecright_view','arya_adminsectionrights','admsecright_pageid="'.$key.'" AND admuser_id="'.$usersessid.'" AND admcat_id="'.$dbusercatid.'"');
			$rightedit=$newrightsarray[0];
			$rightdelete=$newrightsarray[1];
			$fesaproveid=$newrightsarray[2];
			$superdelete=$newrightsarray[3];
			$viewrights=$newrightsarray[4];

}
	}
}
//This is used for admin rights wise display field End Added By Navneet 22/01/2013

$pagesecid=getFieldValue('page_sectionid','arya_adminpage','page_filename="'.$constructed_url.'"');
$modulenm=getFieldValue('page_title','arya_adminpage','page_filename="'.$constructed_url.'"');
$logindate=date('Y-m-d h:i:s');
$curntdate=date('Y-m-d');
$curnttime= date('h:i:s');
if(isset($_POST['submitdelete']))//sequence update start
{

foreach($_POST["txtsupercheck"] as $urgnt_msg_id)
	{
// 		$sleupldfiles="SELECT * FROM arya_quickuploadfiles WHERE qckupld_id='".$urgnt_msg_id."'";
// 		$Qsleupldfiles=mysql_query($sleupldfiles);
// 		while($Fetchupldfiles=mysql_fetch_array($Qsleupldfiles))
// 		{
// 			$filename=$Fetchupldfiles["qupf_files"];
// 			unlink('images/quickuploadfiles/'.$filename);
// 			unlink('images/quickuploadfiles/thumb/'.$filename);
// 		}
		
		$selectquery=mysql_query("select * from arya_reporterfile where rptr_id='".$urgnt_msg_id."'");
		while($fetchsel=mysql_fetch_array($selectquery))
		{
			$fetchsmallimage=$fetchsel['rptrf_file'];
			//code for delete quick upload image in 66.232.110.84 put by nitesh date:=27-03-14
			$nvyearfolder=substr($fetchsmallimage,2,8);
			$nvfetchsmallimage=substr($fetchsmallimage,17);
			
			//nitesh code over
			
			
			$mainimage=str_replace('SM_','',$fetchsmallimage);
			
			if($conditionvar=='2')
			{
				unlink($fetchsmallimage);
				unlink($mainimage);
			}
			if($conditionvar=='1')
			{
				include('arya_ftpfile.php');
		
				ftp_delete($srvconnect_id,$fetchsmallimage);
				ftp_delete($srvconn_id,$fetchsmallimage);
			}
		}
		
	$updtmodtitle=getFieldValue('rptr_text','arya_reporter','rptr_id="'.$urgnt_msg_id.'"');
	$position=50;
	$postqckuptitle = substr($updtmodtitle, 0, $position);

getadminactivity('title_mngreport',$pagesecid,$_SESSION["adminuserid"],$_SERVER["REMOTE_ADDR"],$postqckuptitle,$curntdate,$curnttime);

$quckuplddelete="DELETE FROM arya_reporter WHERE rptr_id=".$urgnt_msg_id."";
		$reupdseq=mysql_query($quckuplddelete);
		
		$quckupldfiles="DELETE FROM arya_reporterfile WHERE rptr_id=".$urgnt_msg_id."";
		$resqckupldfiles=mysql_query($quckupldfiles);
	}

}
if($_POST['page']=="" && $_GET["clnm"]=="" && $_POST["txtsupercheck"]=="")
{
	unset($_SESSION["type"]);
	unset($_SESSION["approve"]);
	unset($_SESSION["doneby"]);
	unset($_SESSION["section"]);
}
//this is use for come from edit form display select page start
if($_POST['page'] != "")
{
	$_SESSION["pagesesid"]=$_POST['page'];
}
else if($_GET["msg"] != '' || $msg1 != "")
{
	$_POST['page']=$_SESSION["pagesesid"];
}
else
{
	unset($_SESSION["pagesesid"]);
}

if($_GET["msg"]=='send')
{
	$msg='Mail Sent Successfully';
}
//this is use for come from edit form display select page end
?>
<script language="javascript">
$(function(){
//DELETE BUTTON AND SEE IF CHECKBOXES ARE CHECKED
$('#submitdelete').click(function(){
$('input[type=checkbox]:checked').each(function(){
var the_id = $(this).val();

var data = "id="+the_id;
//DELETES THE ITEMS ONE AT A TIME

});
});

//FOR THE CHECKBOX
$("input[type=checkbox]").click(function(){
var x = $("input[type=checkbox]:checked").length;
var t = $("input[type=checkbox]").length;
//IF EVERY CHECKBOX IS CHECKED...
if(t==x){
//HIDES 'CHECK ALL' AND SHOWS UNCHECK ALL' & 'DELETE' BUTTONS
$("#chkall").hide(); $("#submitdelete").show();
} else {
//IF NOT, ALL BUTTONS WILL BE SHOWN, HIDES 'UNCHECK ALL' & 'DELETE' IF NOTHING IS CHECKED
$("#chkall").hide();
$("#submitdelete").show();
if(x==0){
$("#submitdelete").hide();
if($("#submitdelete").hide())
{
	$("#chkall").show();
}
}
}
});

//IF CHECK ALL IS PRESS...
$("#chkall").live("click", function(){
//FILL IN ALL CHECKBOXES
$("input[type=checkbox]").each(function(){
$(this).attr("checked", true);
});
//JUST SHOWS 'UNCHECK ALL' & 'DELETE' BECAUSE NOW ALL BOXES ARE CHECKED
$(this).hide();
$("#submitdelete").show();
});

//IF UNCHECK ALL IS PRESS...

//CLEARS IN ALL CHECKBOXES
$("input[type=checkbox]").each(function(){
$(this).attr("checked", false);
});
//JUST SHOWS 'CHECK ALL' BECAUSE NOW ALL BOXES ARE UNCHECKED
$("#submitdelete").hide();
$("#chkall").show();

});
</script>
<?php

$clnm = "";
if ($_GET['clnm']) {
$clnm = $_GET['clnm'];
}

else 
{
$clnm ="rptr_date";
}
// Get the value of either ascending or descending
$order = "";
if ($_GET['order']) {
$order = $_GET['order'];
}
else 
{
	$order ="ASC";
}

// Make the default order sorting
if ($order == "") {
$order = "DESC"; }
elseif ($order == "ASC") {
$order = "DESC";}
elseif ($order == "DESC") {
$order = "ASC";}

if($order=='ASC')
{
	$style='class="asecnding"';
	$ascdescicon='images/up.png';
}
if($order=='DESC')
{
	$style='class="descending"';
	$ascdescicon='images/down.png';
}
if($_GET['clnm']=='rptr_date')
{
	$reportdate='<img src='.$ascdescicon.' '.$style.' />';	
}
else if($_GET['clnm']=='rptr_inappropriateid')
{
	$uploaddate='<img src='.$ascdescicon.' '.$style.' />';	
}
else if($_GET['clnm']=='rptr_donedate')
{
	$donedate='<img src='.$ascdescicon.' '.$style.' />';	
}
else if($_GET['clnm']=='rptr_delstatus')
{
	$delstts='<img src='.$ascdescicon.' '.$style.' />';	
}
else if($_GET['clnm']=='rptr_approve')
{
	$varapprov='<img src='.$ascdescicon.' '.$style.' />';	
}
else
{
	$reportdate='<img src='.$ascdescicon.' '.$style.' />';	
}

if($_POST["cmbtype"]!="" || $_POST["cmbapprove"]!="" || $_POST["cmbdoneby"]!="")
{
	$cmbtype=$_POST["cmbtype"];
	$cmbapprove=$_POST["cmbapprove"];
	$cmbdoneby=$_POST["cmbdoneby"];
	$cmbsection=$_POST["cmbsection"];

$_SESSION["type"]=$cmbtype;
	$_SESSION["approve"]=$cmbapprove;
	$_SESSION["doneby"]=$cmbdoneby;
	$_SESSION["section"]=$cmbsection;

}

?>
<form action="" method="post" name="frmpaging" id="frmpaging" >
	<input type="hidden" name="page" value="" />
</form>

<form action="http://<?php echo $_SERVER['HTTP_HOST'];?>/publicprofilepage" method="post" name="frmpubprofile" id="frmpubprofile" target="_new">
	<input type="hidden" name="clientuserid" id="clientuserid" value="" />
</form>

<form method="post" action="" name="frmreport" id="frmreport" enctype="multipart/form-data" />
	<table width="100%" summary="" border="0" cellpadding="0" cellspacing="0">
	<tr><td align="center" height="85" colspan="2"><h2 class="bigheader"><?php echo $title_mngreport; ?></h2></td>
	</tr><?php echo SuccessMessage($msg);?>
    <tr>
			<td align="right" width="45%"><?php echo $lbl_type; ?>&nbsp;:&nbsp;</td>
			<td><select id="cmbtype" name="cmbtype" class="selbox" >
            <?php
			if($_SESSION["type"]==1)
			{
				$selecttpe1='selected="selected"';
			}
			if($_SESSION["type"]==2)
			{
				$selecttpe2='selected="selected"';
			}
			?>
							<option value="0">Select Type</option>
                            <option value="1" <?php echo $selecttpe1; ?>>Wrong</option>
                            <option value="2" <?php echo $selecttpe2; ?>>Contribute</option>
                                       
                             </select></td>
		</tr>
        <tr><td height="5" colspan="2"></td></tr>
         
        <tr>
			<td align="right" width="45%"><?php echo "Section"; ?>&nbsp;:&nbsp;</td>
			<td><select id="cmbsection" name="cmbsection" class="selbox" >
            				<option value="">Select Section</option>
                            <?php echo getReportSection($_SESSION["section"]); ?>
                             </select></td>
		</tr>
        <tr><td height="5" colspan="2"></td></tr>
        <tr>
			<td align="right" width="45%"><?php echo $lbl_approve; ?>&nbsp;:&nbsp;</td>
			<td><select id="cmbapprove" name="cmbapprove" class="selbox" >
            				<?php
								if($_SESSION["approve"]==1)
								{
									$select1='selected="selected"';
								}
								else if($_SESSION["approve"]==2)
								{
									$select2='selected="selected"';
								}
								else
								{
									$select3='selected="selected"';
								}
							?>
							<option value="0" <?php echo $select3; ?>>Select Approve</option>
                            <option value="1" <?php echo $select1; ?>>Yes</option>
                            <option value="2" <?php echo $select2; ?>>No</option>
                             </select></td>
		</tr>
        <tr><td height="5" colspan="2"></td></tr>
        <tr>
			<td align="right" width="45%"><?php echo $lbl_vardone; ?>&nbsp;:&nbsp;</td>
			<td><select id="cmbdoneby" name="cmbdoneby" class="selbox" >
							<option value="0">Select Done By</option>
                            <?php echo GetPortalStaffList($_SESSION["doneby"]);
							?>
                             </select></td>
		</tr>
		<tr>
		<tr><td height="5" colspan="2"></td></tr>
		<tr>
			<td>&nbsp;</td><td height="5">
			<input type="submit" name="btnsearch" id="btnsearch" value="Search"/>
			</td>
		</tr>
		<tr><td height="5" colspan="2"></td></tr>
		<tr>
			<td align="center" colspan="2">
				<table cellpadding="0" cellspacing="0" border="0">
					<tr><td height="5" colspan="2"></td></tr>
					<table summary="" border="1" align="center" width="95%" cellpadding="0" cellspacing="0">					
						<tr align="center" class="tblborder">
						
						<td width="4%"><?php echo $lbl_delete; ?></td>
						
						<td width="8%"><a href="arya_mngreporter.php?clnm=rptr_inappropriateid&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo "Report Type"; ?><?php echo $uploaddate; ?></a></td>
						<td width="10%"><a href="arya_mngreporter.php?clnm=rptr_date&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo "Report Date"; ?><?php echo $reportdate; ?></a></td>
						<td width="10%"><?php echo "Title"; ?></td>
						<td width="6%"><?php echo "Section"; ?></td>
                        <td width="13%"><?php echo "Reporter"; ?></td>
                        <td width="6%"><?php echo "Level"; ?></td>
						<td width="6%"><?php echo $lbl_view; ?></td>
						
						<td width="5%"><a href="arya_mngreporter.php?clnm=rptr_approve&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_approve; ?><?php echo $varapprov; ?> </a></td>
                        <td width="6%"><a href="arya_mngreporter.php?clnm=rptr_delstatus&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo "Done"; ?><?php echo $delstts;?> </a><?php //echo $lbl_done; ?></td>
						<td width="10%"><?php echo $lbl_vardone; ?><?php //echo $lbl_approve; ?></td>
						<td width="10%"><a href="arya_mngreporter.php?clnm=rptr_donedate&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_donedatetime; ?><?php echo $donedate;?> </a><?php //echo $lbl_approve; ?></td>
						<?php if($dbusercatname=='Super Admin') { ?><td width="10%">Send Email<?php //echo $lbl_approve; ?></td><?php } ?>		
					</tr>
				<?php
				
				unset($_SESSION['newcmbtype']);
				unset($_SESSION['newcmbapprove']);
				unset($_SESSION['newcmbdoneby']);
				unset($_SESSION["newsection"]);
				if($_SESSION['type']==1 && $_SESSION["section"]!="" && $_SESSION['doneby']>0 && $_SESSION["approve"]=='1')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==1 && $_SESSION["section"]!="" && $_SESSION['doneby']>0 && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]!="" && $_SESSION['doneby']>0 && $_SESSION["approve"]==1)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]!="" && $_SESSION['doneby']>0 && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==1 && $_SESSION["section"]=="" && $_SESSION['doneby']>0 && $_SESSION["approve"]==1)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==1 && $_SESSION["section"]=="" && $_SESSION['doneby']>0 && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]=="" && $_SESSION['doneby']>0 && $_SESSION["approve"]==1)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]=="" && $_SESSION['doneby']>0 && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==1 && $_SESSION['doneby']>0 && $_SESSION["approve"]=='0')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_assign='".$_SESSION['doneby']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]!="" && $_SESSION['doneby']>0 && $_SESSION["approve"]=='0')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND rptr_assign='".$_SESSION['doneby']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['doneby']>0 && $_SESSION["approve"]=='0' && $_SESSION["section"]=="" && $_SESSION['type']==0)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_assign='".$_SESSION['doneby']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['doneby']>0 && $_SESSION["section"]!="" && $_SESSION["approve"]=='0')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_section='".$_SESSION["section"]."' AND  rptr_assign='".$_SESSION['doneby']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']=='1' && $_SESSION["approve"]=='0' && $_SESSION["section"]=="" && $_SESSION['doneby']==0)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
					}
					else if($_SESSION['type']==2 && $_SESSION["approve"]=='0' && $_SESSION["section"]=="")
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
					}
					else if($_SESSION['type']==1 && $_SESSION["section"]!="" && $_SESSION["approve"]=='0')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]!="" && $_SESSION["approve"]=='0')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['doneby']>0 && $_SESSION["approve"]=='1' && $_SESSION["section"]=="" && $_SESSION['type']==0)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
					}
					else if($_SESSION['doneby']>0 && $_SESSION["approve"]=='2' && $_SESSION["section"]=="" && $_SESSION['type']==0)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
					}
					else if($_SESSION['doneby']>0 && $_SESSION["section"]!="" && $_SESSION["approve"]=='1')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_section='".$_SESSION["section"]."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['doneby']>0 && $_SESSION["section"]!="" && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_section='".$_SESSION["section"]."' AND rptr_assign='".$_SESSION['doneby']."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==1 && $_SESSION["approve"]=='1' && $_SESSION["section"]=="" && $_SESSION['doneby']==0)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
					}
					else if($_SESSION['type']==1 && $_SESSION["approve"]=='2' && $_SESSION["section"]=="")
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
					}
					else if($_SESSION['type']==1 && $_SESSION["section"]!="" && $_SESSION["approve"]=='1')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_sssSESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==1 && $_SESSION["section"]!="" && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["approve"]=='1' && $_SESSION["section"]=="")
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
					}
					else if($_SESSION['type']==2 && $_SESSION["approve"]=='2' && $_SESSION["section"]=="" && $_SESSION['doneby']==0)
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]!="" && $_SESSION["approve"]=='1')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION["section"]!="" && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_section='".$_SESSION["section"]."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION["section"]!="" && $_SESSION["approve"]=='1')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_section='".$_SESSION["section"]."' AND (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION["section"]!="" && $_SESSION["approve"]=='2')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_section='".$_SESSION["section"]."' AND (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION["section"]!="")
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_section='".$_SESSION["section"]."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==0 && $_SESSION["approve"]=='1' && $_SESSION["section"]=="")
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE (rptr_approve='Green' AND rptr_delstatus='Yes') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
					}
					else if($_SESSION['type']==0 && $_SESSION["approve"]=='2' && $_SESSION["section"]=="")
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE (rptr_approve='Red' AND rptr_delstatus='No') order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
					}
					else if($_SESSION['type']==1 && $_SESSION['doneby']>0 && $_SESSION["approve"]=='0')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_assign='".$_SESSION['doneby']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
						$_SESSION["newsection"]=$_SESSION["section"];
					}
					else if($_SESSION['type']==2 && $_SESSION['doneby']>0 && $_SESSION["approve"]=='0')
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE rptr_inappropriateid='".$_SESSION['type']."' AND rptr_assign='".$_SESSION['doneby']."' AND ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
						$_SESSION['newcmbtype']=$_SESSION['type'];
						$_SESSION['newcmbapprove']=$_SESSION['approve'];
						$_SESSION['newcmbdoneby']=$_SESSION['doneby'];
					}
					else
					{
						$selreportqry="SELECT * FROM arya_reporter WHERE ((rptr_approve='Green' AND rptr_delstatus='Yes') OR (rptr_approve='Red' AND rptr_delstatus='No')) order by $clnm $order";
					}
					$qquckupldqry=mysql_query($selreportqry);
					$numrows=mysql_num_rows($qquckupldqry);
					if($numrows > 0)
					{
						$page =$_POST['page'];
						$limit=$mngquickupldlimit;
						$script_name="arya_mngreporter.php";
						$paging=display_paginglist($page,$numrows,$limit,$script_name,$pagequery_vars);
						$qryadmnotific=mysql_query($selreportqry." limit $eu, $limit ") or GoToErrorPage();
						while($qFetchquckupld=mysql_fetch_array($qryadmnotific))//while start
						{
							$reportid=$qFetchquckupld['rptr_id'];
							$reporttypid = $qFetchquckupld['rptr_inappropriateid'];
							if($reporttypid==1)
							{
								$reporttype="Wrong";
							}
							else if($reporttypid==2)
							{
								$reporttype="Contribute";
							}
							$obiid=$qFetchquckupld['obi_id'];
							if($obiid>0)
							{
								$pagesecid=getFieldValue('page_sectionid','arya_adminpage','page_filename="arya_mngobituary.php"');
							}
							$userid=$qFetchquckupld['user_id'];
							$username=getFieldValue('user_name','arya_adminuser','admuser_id="'.$userid.'"');
							$dbusercatid=getFieldValue('admcat_id','arya_adminuser','admuser_id="'.$userid.'"');
							$dbusercatnm=getFieldValue('admcat_title','arya_adminusercategory','admcat_id="'.$dbusercatid.'"');

//$mlevel_id=$qFetchquckupld['rptr_inappropriateid'];
							$reportdate=$qFetchquckupld['rptr_date'];
							$Nvreportdate = date('d-M-Y h:i:s',strtotime($reportdate));
							$clientid=$qFetchquckupld['rptr_clientuserid'];
							$profilename=getFieldValue("meb_profilename_english","arya_member","login_id='".$clientid."'");
							$clientemail=getFieldValue("login_name","arya_userlogin","login_id='".$clientid."'");
							$powelevelname="";
								$sum="";
							$pointget=getFieldsValueArray('upa_pointgiven','arya_userpointactivity','user_id="'.$clientid.'"');
							foreach($pointget as $val)//this is used to sum user points
							{
								$sum+=$val;
							}
							$qry="select * from arya_memberlevel where $sum BETWEEN mlevel_spoint AND  mlevel_epoint";
							$q=mysql_query($qry);
							$level=mysql_fetch_array($q);
							$powelevelname=$level['mlevel_name'];
							
							$reportedby="(".$profilename.", ".$clientemail.")";
							$rptwebadd=$qFetchquckupld['rptr_webpageurl'];
							$clientwebaddress = substr($rptwebadd, 0, 7);
							if($clientwebaddress != "http://")
							{
								$clientwebaddress = "http://".$rptwebadd;
							}
							else
							{
								$clientwebaddress = $rptwebadd;
							}
							
							$rptapprove=$qFetchquckupld["rptr_approve"];
							$rptdelstatus=$qFetchquckupld["rptr_delstatus"];
							$qckupld_assign=$qFetchquckupld["rptr_assign"];
							$udbid=$qFetchquckupld["user_id"];
							$admnusername=getFieldValue('user_name','arya_adminuser','admuser_id="'.$udbid.'"');
							$donedate=date("d-M-Y h:i:s",strtotime($qFetchquckupld["rptr_donedate"]));
							$rprtdelstatus=$qFetchquckupld["rptr_delstatus"];
							$rprtsection=$qFetchquckupld["rptr_section"];
						?>
                  <tr align="center" >
						<td>
                   <?php
							if($fesaproveid == 'Self')
							{
						?>
                  <input type="checkbox" name="txtsupercheck[<?php echo $reportid; ?>]" id="txtsupercheck[]" value="<?php echo $reportid; ?>" />
                   <?php
							}
							else if($fesaproveid=='All')
							{
							?>
                            	<input type="checkbox" name="txtsupercheck[<?php echo $reportid; ?>]" id="txtsupercheck[]" value="<?php echo $reportid; ?>"/>
                            <?php	
							}
							else
							{
							?>
                            	<input type="checkbox" name="txtsupercheck[<?php echo $reportid; ?>]" id="txtsupercheck[]" value="<?php echo $reportid; ?>" disabled="true" />
                            <?php
							}
							?>
						</td>
						<td><?php echo $reporttype ; ?> </td>
						<td><?php echo $Nvreportdate; ?></td>
						
                        <td>
                        <?php
                        if($obiid>0)
						{
						
						?>
                        <a href="http://www.aryasamajdelhi.pb/aryaadmin/arya_viewobituarymessage.php?obiid=<?php echo $obiids;?>&scid=<?php echo $pagesecid;?>&name=<?php echo '1';?>" class="iframe6"><?php echo $rptwebadd; ?></a>
                        
						<?php
						}
						else
						{
						?>
                         <a href="<?php echo $clientwebaddress; ?>" target="_blank"><?php echo $rptwebadd; ?></a>
                        <?php
						}
						?>
                         </td>
						<td><?php echo $rprtsection; ?></td>
                        <td>
                        <?php
						if($userid>0)
						{
							echo '('.$username.', '.$dbusercatnm.')';
						}
						else
						{
						?>
                        <a href="javascript:RedirectFinduserid(<?php echo $clientid;?>);"><?php echo $reportedby; ?></a>
                        <?php
						}
						?>
                        </td>
                        <td>
						<?php
						if($userid>0)
						{
							echo $dbusercatnm;
						}
						else
						{
					 	echo $powelevelname; 
						}?></td>
						
                        			
                        <td>
                        <?php
						if($viewrights == 'Self')
						{
						?>
                        	<a href="arya_viewreport.php?qckid=<?php echo $reportid;?>&scid=<?php echo $pagesecid;?>" class="iframe4"><img src="./images/pamp_icon.png" border="0"  title='<?php echo "Click here to view files";?>' alt=""></a>
                        <?php
						}
						else if($viewrights=='All')
						{
						?>
                        	<a href="arya_viewreport.php?qckid=<?php echo $reportid;?>&scid=<?php echo $pagesecid;?>" class="iframe4"><img src="./images/pamp_icon.png" border="0"  title='<?php echo "Click here to view files";?>' alt=""></a> 
                        <?php
						}
						else
						{	
						?>
                        	<img src="./images/pamp_icon_dis.png" border="0"  title='<?php echo "Click here to view files";?>' alt="">
                        <?php
						}
						?>
                        </td>
                       
		 
						<td align="center" width="7%">
							<div id="FetchAjaxDataEnable[<?php echo $reportid;?>]">
							<?php if($rptapprove=='Green')
							{
								if($udbid==$usersessid && $fesaproveid == 'Self')
								{
							?>
							<img src="images/greendot.png" title="Click the button then update approve" alt="" onclick="return UpdateEnableDisableVal('reportapprove','Red',<?php echo $reportid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/>
							<?php 	}
								else if($fesaproveid == 'All')
								{ 
							?>
							<img src="images/greendot.png" title="Click the button then update approve" alt="" onclick="return UpdateEnableDisableVal('reportapprove','Red',<?php echo $reportid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/>
							<?php 	}
								else
								{
							?>
								<img src="images/greendot_d.png" />
							<?php 	}
							}
							else if($rptapprove=='Red') 
							{
								if($udbid==$usersessid && $fesaproveid == 'Self')
								{
							?> <img src="images/reddot.png" title="Click the button then update approve" alt="" onclick="return UpdateEnableDisableVal('reportapprove','Green',<?php echo $reportid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/>
							<?php 	
								}
								else if($fesaproveid == 'All')
								{
							?> <img src="images/reddot.png" title="Click the button then update approve" alt="" onclick="return UpdateEnableDisableVal('reportapprove','Green',<?php echo $reportid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/>
							<?php 	
								}
								else
								{
							?> <img src="images/reddot_d.png" />
							<?php 	
								}
							}?>
							</div>
                   </td>
                    <td>
							<?php	
							if($rprtdelstatus=='Yes')
							{
								?>
                            <img src="images/right_d.png"  alt=""/>
                      <?php
							}
							else
							{ ?>
                       <img src="images/wrong_d.png"  alt="" />
                       <?php
							}
							?>
                   </td>

<td><?php echo $admnusername;?></td>
						<td><?php echo $donedate; ?></td>	
						<?php if($dbusercatname=='Super Admin') { ?><td align="center"><a href="arya_sendreporteremail.php?reportid=<?php echo $reportid; ?>&scid=<?php echo $pagesecid;?>" class="sendmailqucik"><img src="images/sendmail.png" title="" alt="" /> </a></td><?php } ?>
					</tr>
					<?php
					}
					?>
				<tr align="center">
					<td align="center">
                     <?php
					if($fesaproveid == 'Self')
					{
					?>	
					<input class="chktoggle" id="chkall" type="button" value="<?php echo "Super Delete"; ?>" disabled="true"><input id="submitdelete" name="submitdelete" type="submit" value="<?php echo "Super Delete"; ?>" onclick="return confirm('Are you sure you want to permanent delete this record?')" />
				<?php
					}
					else if($fesaproveid=='All')
					{
					?>
                    	<input class="chktoggle" id="chkall" type="button" value="<?php echo "Super Delete"; ?>" disabled="true"><input id="submitdelete" name="submitdelete" type="submit" value="<?php echo "Super Delete"; ?>" onclick="return confirm('Are you sure you want to permanent delete this record?')" />

<?php
					}
					else
					{
					?>
                    	<input type="submit" name="submitdelete" id="submitdelete" value="<?php echo "Super Delete"; ?>" disabled="true" />
                    <?php
					}
					?>
               </td>	
               <td colspan="10"></td>			
					
				
					
				</tr>
				<?php
						if($paging!="")
						{ ?>  
							<tr>
							<td class="pagination" align="center" colspan="12">								    
							<?php echo $paging;?>
							</td>
							<?php
						}// if($paging!="")
					} 
					else 
					{
						echo '<tr><td height="20" colspan="14" align="center"><span  class="redMsg">'.$msgNoRecordFound.'</span></td></tr>';
					} ?>
				</table>
			</td>
           </tr>
		</table>
	  </td>
	</tr>
 </table>
</form>
<?php
// content over
// footer start
	include("arya_footer.php");
// footer over
?>

${this.title}

Code Editor : arya_mngreporter_19-06-14.php