Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-sr-x
Dispatch_ans_script_setup.php	5.95 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.3 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.28 KB	-rwxr-xr-x
ECHblk.php	11.31 KB	-rwxr-xr-x
FormulaEvaluate.php	14.48 KB	-rwxr-xr-x
MarkEntry-Setup.php	26.9 KB	-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...	27.69 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.87 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.82 KB	-rwxr-xr-x
UpdateCollDet.php	1.71 KB	-rwxr-xr-x
XLSXReader.php	9.62 KB	-rwxr-xr-x
absent_entry_setup.php	8.33 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.46 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.22 KB	-rwxr-xr-x
ack_adm_application.php	56.32 KB	-rwxr-xr-x
ack_admentry_application.php	49.35 KB	-rwxr-xr-x
ack_application.php	7.85 KB	-rwxr-xr-x
ack_exam_app_form.php	16.96 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.87 KB	-rwxr-xr-x
ack_registration.php	7.95 KB	-rwxr-xr-x
ack_report.php	2.34 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.7 KB	-rwxr-xr-x
actClass.php	6.38 KB	-rwxr-xr-x
adm_challan_entries.php	14.13 KB	-rwxr-xr-x
adm_delete_data.php	5.71 KB	-rwxr-xr-x
admapprove.php	9.55 KB	-rwxr-xr-x
admchallanpreparation.php	9.01 KB	-rwxr-xr-x
admission_entry_reg.php	40.87 KB	-rwxr-xr-x
admission_entry_status.php	2.79 KB	-rwxr-xr-x
admission_sms_push.php	2.33 KB	-rwxr-xr-x
admissionapplist.php	9.15 KB	-rwxr-xr-x
admregisterlist.php	14.82 KB	-rwxr-xr-x
admstuddate.php	6.27 KB	-rwxr-xr-x
admsumsendsms.php	6.28 KB	-rwxr-xr-x
admuploadexsheet.php	12.57 KB	-rwxr-xr-x
ansbookcancel.php	9.7 KB	-rwxr-xr-x
answer_book_issued.php	10.56 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	26.67 KB	-rwxr-xr-x
apprCandidReport.php	7.14 KB	-rwxr-xr-x
approve.php	38.33 KB	-rwxr-xr-x
attendance.php	10.44 KB	-rwxr-xr-x
attendance_freez.php	8.65 KB	-rwxr-xr-x
attendance_freez_mth.php	8.42 KB	-rwxr-xr-x
attshort.php	6.45 KB	-rwxr-xr-x
auto-complete.php	5.04 KB	-rwxr-xr-x
backup.php	2.95 KB	-rwxr-xr-x
backup_restore.php	8.36 KB	-rwxr-xr-x
backupandrestore.php	10.43 KB	-rwxr-xr-x
batch_close.php	4.43 KB	-rwxr-xr-x
board.php	2.71 KB	-rwxr-xr-x
boeselection.php	1.69 KB	-rwxr-xr-x
bundle_dispatch.php	3.21 KB	-rwxr-xr-x
bundle_rec_ack.php	4.13 KB	-rwxr-xr-x
bundledispatchdatewise.php	12.74 KB	-rwxr-xr-x
bundlereceive.php	1.12 KB	-rwxr-xr-x
bundlestatus.php	5.38 KB	-rwxr-xr-x
cManualMailer.php	2.63 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	44.67 KB	-rwxr-xr-x
cappcontext.php	2.7 KB	-rwxr-xr-x
challan_entries.php	15.65 KB	-rwxr-xr-x
challan_preparation.php	11.91 KB	-rwxr-xr-x
changeDegree.php	1.61 KB	-rwxr-xr-x
changeMobile.php	2.51 KB	-rwxr-xr-x
cmailer.php	6.96 KB	-rwxr-xr-x
cntDeclaration.php	4.23 KB	-rwxr-xr-x
code39.php	6.54 KB	-rwxr-xr-x
coll_exam_app_form.php	1014 B	-rwxr-xr-x
collbankdet.php	1.9 KB	-rwxr-xr-x
colldesp_ack.php	4.08 KB	-rwxr-xr-x
college.php	5.15 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.61 KB	-rwxr-xr-x
college_approve.php	5.71 KB	-rwxr-xr-x
college_degree_status.php	5.76 KB	-rwxr-xr-x
collegebank.php	1.89 KB	-rwxr-xr-x
collfundtransfer.php	2.32 KB	-rwxr-xr-x
connect.php	2.31 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
createAdmission.php	4.06 KB	-rwxr-xr-x
create_all_grid_files.php	8.8 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	10.18 KB	-rwxr-xr-x
create_all_popup_files.php	6.08 KB	-rwxr-xr-x
create_all_schema_files.php	4.42 KB	-rwxr-xr-x
create_all_views.php	16.87 KB	-rwxr-xr-x
create_html_files.php	52.9 KB	-rwxr-xr-x
create_html_files_without_tab....	45.23 KB	-rwxr-xr-x
create_module_meta_columns.php	5.26 KB	-rwxr-xr-x
crequestbroker.php	2.58 KB	-rwxr-xr-x
cronjob_sendsms.php	3.04 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	124 B	-rwxr-xr-x
database.php	474 B	-rwxr-xr-x
datadictionary.php	4.06 KB	-rwxr-xr-x
daterange.php	8.08 KB	-rwxr-xr-x
degree.php	6.66 KB	-rwxr-xr-x
degreeGroup.php	4 B	-rwxr-xr-x
degstudymat.php	6.45 KB	-rwxr-xr-x
degstudymatdet.php	5.16 KB	-rwxr-xr-x
display_details_in_grid.php	109.22 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.72 KB	-rwxr-xr-x
display_details_in_grid_studta...	99.65 KB	-rwxr-xr-x
display_details_in_grid_withde...	100.58 KB	-rwxr-xr-x
doc_verify.php	7.31 KB	-rwxr-xr-x
downloadFeeStatement.php	5.47 KB	-rwxr-xr-x
download_misc_files.php	4.72 KB	-rwxr-xr-x
download_photo.php	4.17 KB	-rwxr-xr-x
download_upload.php	3.99 KB	-rwxr-xr-x
dynamicmastersdetails.php	120.21 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	122.19 KB	-rwxr-xr-x
entryexitevents.php	3.19 KB	-rwxr-xr-x
examAppChallan.php	7.92 KB	-rwxr-xr-x
execute_query.php	2.57 KB	-rwxr-xr-x
export_import_setup.php	7.8 KB	-rwxr-xr-x
export_import_utility.php	2.75 KB	-rwxr-xr-x
feepaidreports.php	994 B	-rwxr-xr-x
forgotpassword.php	3.22 KB	-rwxr-xr-x
format.php	7.76 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.79 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10.3 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.93 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.99 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.61 KB	-rwxr-xr-x
freezeiaprici.php	10.14 KB	-rwxr-xr-x
general_report_format.php	11.33 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	3.05 KB	-rwxr-xr-x
getMessages.php	11.4 KB	-rwxr-xr-x
getdata.php	36.93 KB	-rwxr-xr-x
getfeeinformation.php	7.28 KB	-rwxr-xr-x
getfeeinformation_bulk.php	7.74 KB	-rwxr-xr-x
getmoduledetails.php	23.94 KB	-rwxr-xr-x
getnumword.php	7.8 KB	-rwxr-xr-x
getreportdetails.php	3.29 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.43 KB	-rwxr-xr-x
getsearchcondition.php	1.37 KB	-rwxr-xr-x
ggridmodel.php	9.59 KB	-rwxr-xr-x
golden_palm_payslip.php	12.86 KB	-rwxr-xr-x
helptext.php	5.54 KB	-rwxr-xr-x
identify_transactions.php	6.56 KB	-rwxr-xr-x
import_marks.php	4.27 KB	-rwxr-xr-x
index.php	5.17 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
login.php	18.88 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.33 KB	-rwxr-xr-x
login_old.php	3.23 KB	-rwxr-xr-x
login_wait.php	11.78 KB	-rwxr-xr-x
mascomb.php	10.27 KB	-rwxr-xr-x
mcverifydet.php	14.61 KB	-rwxr-xr-x
message_board.php	4.84 KB	-rwxr-xr-x
messagetext.php	1010 B	-rwxr-xr-x
module_setup.php	2.56 KB	-rwxr-xr-x
mregistry.php	92.4 KB	-rwxr-xr-x
mrn_approval.php	9.24 KB	-rwxr-xr-x
nobleRegn.php	4.08 KB	-rwxr-xr-x
payment_gateway.php	8.01 KB	-rwxr-xr-x
photoupload.php	9.52 KB	-rwxr-xr-x
post.php	5.21 KB	-rwxr-xr-x
printexamform.php	11.87 KB	-rwxr-xr-x
push_data_to_studentportal.php	1.86 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.72 KB	-rwxr-xr-x
remove_exam_ack.php	3.63 KB	-rwxr-xr-x
report_admission_ticket.php	48.07 KB	-rwxr-xr-x
report_hall_ticket.php	11.47 KB	-rwxr-xr-x
report_iamarks_pending.php	12.35 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	12.15 KB	-rwxr-xr-x
report_setup.php	25.56 KB	-rwxr-xr-x
report_tool.php	74.93 KB	-rwxr-xr-x
result.php	5.18 KB	-rwxr-xr-x
resultsheet.php	9.15 KB	-rwxr-xr-x
revaluation.php	17.01 KB	-rwxr-xr-x
revaluation_withdegree.php	17.13 KB	-rwxr-xr-x
room_allotment.php	8.13 KB	-rwxr-xr-x
room_allotment_datewise.php	15.75 KB	-rwxr-xr-x
roomdeclaration.php	1.87 KB	-rwxr-xr-x
rotation.php	634 B	-rwxr-xr-x
rvdates.php	6.58 KB	-rwxr-xr-x
sample.php	2.13 KB	-rwxr-xr-x
sectionwisepermission.php	5.66 KB	-rwxr-xr-x
sendGridMail.php	1.25 KB	-rwxr-xr-x
sendLoginPassword.php	3.2 KB	-rwxr-xr-x
sendnotification.php	6.17 KB	-rwxr-xr-x
sendsmsapi.php	788 B	-rwxr-xr-x
sendusrandpws.php	1.01 KB	-rwxr-xr-x
serchbygrid.php	868 B	-rwxr-xr-x
servfeehead.php	3.97 KB	-rwxr-xr-x
services.php	3.58 KB	-rwxr-xr-x
sfeehead.php	5.62 KB	-rwxr-xr-x
stringspliter.php	731 B	-rwxr-xr-x
stuIAMarksPending.php	6.09 KB	-rwxr-xr-x
student.php	57.31 KB	-rwxr-xr-x
student_entry.php	61.92 KB	-rwxr-xr-x
studentportal_remove.php	6.3 KB	-rwxr-xr-x
subjectList_display.php	11.23 KB	-rwxr-xr-x
subject_freshExam.php	28.5 KB	-rwxr-xr-x
subjectfreez.php	13.52 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	10.21 KB	-rwxr-xr-x
subshort.php	5.83 KB	-rwxr-xr-x
system_utility.php	1.89 KB	-rwxr-xr-x
systemsetup.php	81.71 KB	-rwxr-xr-x
teachOficerEntry.php	7.21 KB	-rwxr-xr-x
teachers.php	15.78 KB	-rwxr-xr-x
transaction-series.php	4.99 KB	-rwxr-xr-x
update.php	720 B	-rwxr-xr-x
updateSection.php	4.87 KB	-rwxr-xr-x
update_defined_flag.php	3.5 KB	-rwxr-xr-x
update_query.php	334 B	-rwxr-xr-x
updateexamcnt.php	3.01 KB	-rwxr-xr-x
upload_studentPhoto.php	10.94 KB	-rwxr-xr-x
uploadmoduledetails.php	40.61 KB	-rwxr-xr-x
uploadzip.php	9.42 KB	-rwxr-xr-x
usersetup.php	25.66 KB	-rwxr-xr-x
usersubj_identification.php	5.71 KB	-rwxr-xr-x

Code Editor : bundledispatchdatewise.php

<?php
/*error_reporting(E_ALL);
ini_set('display_errors','on');*/

class room_allotment 
{
		function __construct($aobj_context)
		{
			session_start();
			$this->aobj_context=$aobj_context;
			$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$this->user_id = $_SESSION['user_id'];
			$this->funivcode = $_SESSION['FUNIVCODE'];			
			$this->collcode = $_SESSION['collcode'];	
			$this->log_name = $_SESSION['usr'];	
		}
	 
		function DisplayBundalDetailsDatewise()
		{
			session_start();
			$this->collcode = $_SESSION['collcode'];
			$edate = ($this->aobj_context->mobj_data["edate"]);
            $session = ($this->aobj_context->mobj_data["session"]);
           
            if($this->collcode == '')
            {
                $data="Please login and try again";
                echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 		
                return;
			}
			$this->collcode = $this->collcode;

$qyer = "delete from colldesp where fcollcode = '{$this->collcode}' and fdoe = date_format(STR_TO_DATE('{$edate}', '%d/%m/%Y'),'%Y-%m-%d')";
			$lobj_insert = $this->aobj_context->mobj_db->Execute($qyer);

$query = "select b.fpresent,b.fqpcode,b.fsubname,ifnull(a.abcnt,0) as abcnt,ifnull(a.MPcnt,0) as MPcnt,
			(b.fpresent-(ifnull(a.abcnt,0)+ifnull(a.MPcnt,0))) as buncnt,b.fbundscript from (
			select count(distinct cd.fregno) as fpresent,fqpcode,fsubname,'{$this->collcode}' as fcollcode,fbundscript 
			from control cl, canddet cd 
			inner join subject s
			on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno and cd.fsubcode = s.fsubcode 
			and ifnull(s.fqpcode,'') <> '' 
			inner join candsum cs on cd.fcollcode = cs.fcollcode and cd.fdegree = cs.fdegree 
			and cd.fregno = cs.fregno
			where fpresent = 'P' and cs.fcntrcode = '{$this->collcode}' 
			and ifnull(frecptdate,'0000-00-00') <> '0000-00-00'
			and s.fdoe =  date_format(STR_TO_DATE('{$edate}', '%d/%m/%Y'),'%Y-%m-%d')
			and s.fsession like '{$session}%'
			group by fqpcode
			order by fqpcode) b
			left join
			 (select ifnull(sum(if(fabstype = 'QpA',1,0)),0) as abcnt, 
			ifnull(sum(if(fabstype = 'QpM',1,0)),0) as MPcnt,fcollcode,FQPCODE from absent 
			where fcollcode = '{$this->collcode}' 
			and fdoe = date_format(STR_TO_DATE('{$edate}', '%d/%m/%Y'),'%Y-%m-%d')
			group by fqpcode) a
			on a.fqpcode = b.fqpcode and a.fcollcode = b.fcollcode";

$results = $this->aobj_context->mobj_db->GetAll($query);

$str_reval.="<br>";
            $str_reval.="<table style='padding:' class='tr_ventor_row' id='reval_table_data' width='95%' name = 'HALL' border='0' cellspacing='0' cellpadding='0'>";
            $str_reval.="<tr class='tr_bg1'>";
            $str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl. No.</td>";
			$str_reval.="<td align='center' style='width:40%;font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>";
			$str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>QP Code</td>";
            $str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Total Present</td>";
            $str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Total Absent</td>";
            $str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Total Malpractice</td>";
            $str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>No. of Scripts</td>";
            $str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Bundle No.</td>";
			$str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Scripts in Bundle</td>";
			
            $str_reval.="<td align='center' style='width:8%; font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Actions</td>";
            $str_reval.="</tr>";

if($session == 'M')
                $am = 'AM';
            if($session == 'N')
				$am = 'PM';

$i=1;	
            foreach($results as $value)
            {
                $fqpcode     = $value['fqpcode'];
				$fsubanme    = $value['fsubname'];
				$fpresent    = $value['fpresent'];
				$abcnt = $value['abcnt'];
				$MPcnt = $value['MPcnt'];
				$qpcnt = $value['buncnt'];
				$qpcnt1 = $value['buncnt'];
				$fbundscript = $value['fbundscript'];

do{
                    //$qpcnt = $qpcnt - $fbundscript;
                    $cnt = 0;
                    if($qpcnt > $fbundscript)
                    {
                        $qpcnt = $qpcnt - $fbundscript;
                        $cnt = $fbundscript;
                    }else
                    {
                        $cnt = $qpcnt;
                        $qpcnt = 0;
                    }

$query = "insert into colldesp(FCOLLCODE,FDOE,FSESSION,FQPCODE,FTOTSCRIPT) 
                    values('{$this->collcode}',date_format(STR_TO_DATE('{$edate}', '%d/%m/%Y'),'%Y-%m-%d'),'{$am}',
					'{$fqpcode}','{$cnt}')";  
					
					$lobj_insert = $this->aobj_context->mobj_db->Execute($query);

$id = $this->aobj_context->mobj_db->Insert_ID();
					
					$str_reval.="<tr>";		
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$i</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:left; border :1px solid #C5DBEC;  padding:5px;' >$fsubanme</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$fqpcode</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$fpresent</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$abcnt</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$MPcnt</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$qpcnt1</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$id</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >$cnt</td>";
					$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border :1px solid #C5DBEC;  padding:5px;' >
					<span
              style='margin-top: 2px;float:left;margin-left:0px;cursor: pointer; color:#35721F;line-height: 19px;font-size:14px;font-weight:bold;'
              onclick='generateBundleNosDispatchQPWise(\"{$id}\");''
              >Print</span
            ></td>";
					$str_reval.="</tr>";

$i++;
                }while($qpcnt >0);

}
			$str_reval.="</table>";
			$arr['html']=$str_reval;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
					
		}
		
		function SaveRoomAllotmentDatewise()
		{
			ini_set('memory_limit','900M');
			ini_set('max_execution_time',0);
			include_once($this->aobj_context->main_src."/src/json.php"); 
			$json = new Services_JSON();
			$hall_arr = stripslashes($this->aobj_context->mobj_data["hall_arr"]);
			//$faculty = ($this->aobj_context->mobj_data["faculty"]);
			
			$mobj_jsondata = $json->decode($hall_arr);
			$hall_arr = get_object_vars($mobj_jsondata);
			//var_dump($hall_arr);
			$i = 0;
			$oldqp = '';
			$newqp = '';
			$j = 0;
				$mpcnd = "and ifnull(ab.fabstype,'') <> 'QpM'";
				if($this->funivcode == '027')
					$mpcnd = "";
			for($k=1;$k<=count($hall_arr);$k++)
			{		
		
				$newqp = $hall_arr[$k]->qpcode;
				if($newqp != $oldqp)
				{
					$i = 0;
					
					$query1 = "SET SESSION group_concat_max_len=100000";
					$results1 = $this->aobj_context->mobj_db->Execute($query1);

$query1 = "SET SESSION group_concat_max_len=10000000";
					$results = $this->aobj_context->mobj_db->Execute($query1);
					
					$query = "SELECT s.fqpcode, group_concat(distinct concat(\"'\",concat(cd.fdegree,cd.fsubcode,cd.FREGNO),\"'\") order by cd.fdegree, 
					cd.fsubcode, cd.fregno) as fregno,cd.FEXAMNO,cd.FDEGREE,cd.FSUBCODE
					FROM canddet cd INNER JOIN subject s ON s.fdegree = cd.fdegree 
					AND s.fexamno = cd.fexamno AND s.FSUBCODE=cd.FSUBCODE
					INNER JOIN candsum cs ON cs.fdegree = cd.fdegree and cs.FCOLLCODE = cd.FCOLLCODE and cs.FREGNO=cd.FREGNO
					inner join degree dd on dd.fdegree=cd.fdegree and dd.fexamno=cd.fexamno
					WHERE cs.FCNTRCODE='{$this->collcode}' AND TRIM(s.FQPCODE)='{$hall_arr[$k]->qpcode}' 
					AND FPRESENT='P' AND IFNULL(cd.fpassmth,'') = '' 
					AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' 
					group by s.fqpcode";
					
					$results = $this->aobj_context->mobj_db->GetRow($query);

}

if($hall_arr[$j]->remaing > 0)
				{
					$hall_arr[$k]->capacity = $hall_arr[$j]->remaing;
				}
				
				$insert = " insert into room_allotment(FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION,FORDER)
							values ('{$this->collcode}','{$hall_arr[$k]->qpcode}' ,'{$hall_arr[$k]->hallno}','{$hall_arr[$k]->alloted}',
							'{$this->log_name}',now(),'{$hall_arr[$k]->fdoe}','{$hall_arr[$k]->sestion}','{$k}')
							ON DUPLICATE KEY UPDATE 
							FCOLLCODE = '{$this->collcode}',
							FQPCODE = '{$hall_arr[$k]->qpcode}',
							FHALLNO = '{$hall_arr[$k]->hallno}',
							FCAPACITY = '{$hall_arr[$k]->alloted}',
							FLOGNAME = '{$this->log_name}',
							FLOGDATE = now(),
							FDOE = '{$hall_arr[$k]->fdoe}',
							FSESSION = '{$hall_arr[$k]->sestion}',
							FORDER = '{$k}'";
				$lobj_insert = $this->aobj_context->mobj_db->Execute($insert);
			
				//var_dump($insert);
				
				$fregno = explode(',',$results['fregno']);
				//var_dump($fregno);
				$FSUBCODE = $results['FSUBCODE'];
				$regnoin = array_slice($fregno,$i,$hall_arr[$k]->capacity);
				$regnoin = implode(',',$regnoin);
				
				//var_dump($regnoin);
			
				$update = "update canddet,candsum
				set canddet.FHALLNO='{$hall_arr[$k]->hallno}'
				where canddet.FDEGREE = candsum.FDEGREE 
				and canddet.FCOLLCODE = candsum.FCOLLCODE
				and canddet.FREGNO = candsum.FREGNO
				and candsum.FCNTRCODE='{$this->collcode}'
				and concat(canddet.fdegree,canddet.fsubcode,canddet.FREGNO) in({$regnoin})";
				$lobj_update = $this->aobj_context->mobj_db->Execute($update);	
				
				//var_dump($update);
				
				$i = $i+$hall_arr[$k]->capacity; 
				$oldqp = $hall_arr[$k]->qpcode;
				$j++;
			}

if($lobj_update)
		{
			$data="Update Successfully.";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 				
		}
		else
		{
			$data="Failed";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 		
		}
	}	 
 }
	
function DisplayBundalDetailsDatewise($aobj_context)
{
    $class_obj=new room_allotment($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->DisplayBundalDetailsDatewise();
}

function SaveRoomAllotmentDatewise($aobj_context)
{
    $class_obj=new room_allotment($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->SaveRoomAllotmentDatewise();
}

function getRoomdetails($aobj_context)
{
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$collcode = $_SESSION['collcode'];
	
	$query = "select froomno as id, froomname as value from masroom 
			where ifnull(fdeleted,'') <>'T' and  fcollcode = '{$collcode}' order by ifnull(forder,0), froomno ";
	//var_dump($query);die();	
	$rst = 	$aobj_context->mobj_db->getAll($query);	//forder,
	
	echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); 
}	
?>

${this.title}

Code Editor : bundledispatchdatewise.php