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 : admuploadexsheet.php

<?php

function replaceChars($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}

function admuploadexeclsheet($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	require_once dirname(__FILE__) . '/../PHPExcel/Classes/PHPExcel/IOFactory.php';

require_once('sendsmsapi.php');

$date = date("dmYhis");
	$collcode = $_SESSION['collcode'];
	$file_name=replaceChars(basename($_FILES['admuploadsheet']['name']));
	$path_arr=pathinfo($_FILES['admuploadsheet']['name']);
	$file_ext=$path_arr['extension'];
	//var_dump($file_ext);
	$folderpath = $aobj_context->main_src."/admupload/"; 
	$temp_path = $aobj_context->main_src."/admupload/";
	if(!file_exists($temp_path))
	{
		mkdir($temp_path);
	}

$file_path="/{$collcode}_{$date}_{$file_name}";
	$temp_path.=$file_path;
	
	if($collcode == '')
	{
		$data = "Please login and try again";
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
		return;
	}	
	
	if(isset($_FILES['admuploadsheet']['name']) && $_FILES['admuploadsheet']['name'] != '')  
	{ 
		$size=($_FILES['admuploadsheet']['size']/1024);
		
		if($size>1024)
		{
			$data="Please Upload file of size less than 1 MB";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"failure"); 
			return;
		}
		
		$ext = pathinfo($_FILES['admuploadsheet']['name'], PATHINFO_EXTENSION);

if($ext != 'xlsx')
		{
			$data="Please Upload file xlsx format only";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-2,"failure"); 
			return;
		}

if(move_uploaded_file($_FILES['admuploadsheet']['tmp_name'],$temp_path))
		{
			$data="admupload{$file_path}";

$query = "insert into admfile(fcollcode,ffilename,fuploadtime) 
			value ('{$collcode}','{$data}',now())";
			$results = $aobj_context->mobj_db->Execute($query);
			
			if(!$results)
			{
				$data = "Upload failure. Error inserting uploaded file";
				echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			}

if(!file_exists($temp_path))
			{
				$data = "Upload failure. Upload file does not exist";
				echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			}
			$inputFileName = $temp_path;
			$inputFileType = 'Excel2007';
			///////////////////// Code To convert xlsx to csv \\\\\\\\\\\\\
			$objReader = PHPExcel_IOFactory::createReader($inputFileType);
			$objPHPExcelReader = $objReader->load($inputFileName);

$loadedSheetNames = $objPHPExcelReader->getSheetNames();

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcelReader, 'CSV');
			$i = 0;
			foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) 
			{
				if($i != 0)
					break;
				
				$objWriter->setSheetIndex($sheetIndex);
				
				$csvFile = $folderpath.$date.$loadedSheetName.'.csv';
				$objWriter->setUseBOM(true);
			    $objWriter->save($csvFile);
			    $query = "LOAD DATA LOCAL INFILE '{$csvFile}'
		        INTO TABLE tmpcollstud
		        FIELDS TERMINATED BY \",\"
		        OPTIONALLY ENCLOSED BY '\"' 
		        LINES TERMINATED BY \"\n\" 
		        IGNORE 1 LINES
		        (@col1,@col2,@col3,@col4,@col5,@col6) set
		        fslno=@col1, fcollcode='{$collcode}', fdegree=@col3,
		        fname=@col4, fmobileno=@col5, femail=@col6";
				// var_dump($query);    
				$results = $aobj_context->mobj_db->Execute($query);
				// var_dump($results);
				$rows_affected = $aobj_context->mobj_db->affected_rows();
				// var_dump($rows_affected);
				//return;
				if(!$results)
				{
					$data = "Upload failure. Error while loading excel data to database";
					echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
					return;
				}
				// Delete All the blank values from table
				$query = "delete from tmpcollstud where fcollcode = '' or fdegree = '' or fname = '' 
				or fdegree = 'Degree'";
				$results = $aobj_context->mobj_db->Execute($query);
				// For second sheet 
				if($i > 0)
				{
					// Check for the data in second sheet
					$query = "select count(*) as fcnt from tmpcollstud 
					where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'";
					
					$results = $aobj_context->mobj_db->GetRow($query);
					
					if($results['fcnt'] == 0)
					{
						break;
					}
				}

$query = "select distinct fdegree from tmpcollstud 
				where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T' 
				and fdegree not in (select distinct fdegree from degree where ifnull(fadmdata,'') = 'T')";
						
				$results = $aobj_context->mobj_db->GetAll($query);
						
				if(count($results) > 0)
				{
					$query = "delete from tmpcollstud where ifnull(fimported,'') <> 'T' 
					and fcollcode = '{$collcode}'";
					// var_dump($query);
					$results = $aobj_context->mobj_db->GetAll($query);

$data = "Upload failure. Invalid degree codes";
					echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
					return;
				}

$query = "update tmpcollstud set fimported = 'F' where ifnull(fimported,'') = ''";
				$results = $aobj_context->mobj_db->Execute($query);
				
				// insert records with no mobile number to collstudnb
				$query = "insert into collstudnb(fslno, fcollcode, fdegree, fmobileno, femail, fname) 
				select fslno, fcollcode, fdegree, fmobileno, femail, fname 
				from tmpcollstud where replace(ifnull(tmpcollstud.fmobileno,''),' ','') = '' 
				and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);
				// delete records in temp table with no mobilenumber
				$query = "delete from tmpcollstud where replace(ifnull(tmpcollstud.fmobileno,''),' ','') = '' 
				and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);

// check for duplicates in the file uploading
				$query = "insert into tmpcollstuddup 
				select fmobileno, count(fmobileno) as fcnt from tmpcollstud 
				where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T' 
				group by fmobileno having count(fmobileno) > 1";
				$results = $aobj_context->mobj_db->Execute($query);

// identify duplicates in file uploading
				$query = "update tmpcollstud a, tmpcollstuddup b set a.fdeleted = 'X' 
				where a.fmobileno = b.fmobileno and a.fcollcode = '{$collcode}' 
				and ifnull(a.fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);

// insert duplicate records of that college to collstuddup
				$query = "insert into collstuddup 
				select * from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' 
				and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);
				// delete duplicates in temp table
				$query = "delete from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' 
				and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);

// identify dulicates with previous inserted records (other than currently uploading college)
				$query = "update tmpcollstud, collstud set tmpcollstud.fdeleted = 'X' 
				where collstud.fmobileno = tmpcollstud.fmobileno and collstud.fcollcode <> tmpcollstud.fcollcode 
				and replace(ifnull(tmpcollstud.fmobileno,''),' ','') <> '' 
				and tmpcollstud.fcollcode = '{$collcode}' and ifnull(tmpcollstud.fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);
				// insert duplicates to collstuddup
				$query = "insert into collstuddup select * from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);

// identify duplicate records (overall)
				$query = "update tmpcollstud, collstud set tmpcollstud.fdeleted = 'X' 
				where collstud.fmobileno = tmpcollstud.fmobileno 
				and replace(ifnull(tmpcollstud.fmobileno,''),' ','') <> '' and tmpcollstud.fcollcode = '{$collcode}' 
				and ifnull(tmpcollstud.fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);

// delete duplicate records in temp table
				$query = "delete from tmpcollstud where fdeleted = 'X' and fcollcode = '{$collcode}' 
				and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);

// insert remaining records to collstud
				$query = "insert into collstud(fslno, fcollcode, fdegree, fmobileno, femail, fname, fimpdate) 
				select fslno, fcollcode, fdegree, fmobileno, femail, fname, fimpdate from tmpcollstud 
				where fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);
				// Update records as imported 
				$query = "update tmpcollstud set fimported = 'T' where 
				fcollcode = '{$collcode}' and ifnull(fimported,'') <> 'T'";
				$results = $aobj_context->mobj_db->Execute($query);
				$i++;
			}

$enttype = "AI{$collcode}";

$query = 'select funivcode, funivname from control';

$res = $aobj_context->mobj_db->GetRow($query);

$univcode = $res['funivcode'];
			$link = "";
			if($univcode == '041')
				$link = 'http://universitysolutions.in/bcu/adm';
			else if($univcode == '042')
				$link = 'http://universitysolutions.in/bnu/adm';
			else if($univcode == '023')
				$link = 'http://universitysolutions.in/dud/adm';
			else if($univcode == '027')
				$link = 'http://universitysolutions.in/rcub/adm';

$sql1 = "insert ignore into logisys3_comexam.sendsms(funivcode, fregno, fmobileno, 
			fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate)
			select distinct '{$univcode}', x.fmobileno, x.fmobileno, '{$enttype}', '{$enttype}', 
			concat('Message from {$res['funivname']}:',CHAR(13),'Dear ', x.fname, ', 
			You are required to submit the admission details in online within 3 days.',CHAR(13),'
			Visit {$link}') as fmessage, 'F', 'F', '2019', '2', now() 
			from collstud x  where ifnull(x.fsmspush,'') <> 'T' 
			and x.fcollcode = '{$collcode}'
			and ifnull(x.factive,'') <> 'T'";

$results = $aobj_context->mobj_db->Execute($sql1);

if($results) {

$sql1 = "update collstud x set x.fsmspush = 'T'
				where ifnull(x.fsmspush,'') <> 'T' and x.fcollcode = '{$collcode}'";
				
				$res = $aobj_context->mobj_db->Execute($sql1);
				
				$query = "select funivcode, fregno, fenttype, fmobileno as mobileno, 
				concat(fmessage,' Sent Time: ',time(now())) as fmessage
				from logisys3_comexam.sendsms 
				where ifnull(fstatus, 'F') = 'F' and fenttype = '{$enttype}' 
				and funivcode = '041' and fmobileno is not null";

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

$username = 'logisyhttp';
				$password = 'Logis986';
				$from = 'UNISOL';
				$category = '';

$commondb = 'logisys3_comexam';

if(count($results) >0)
				{
					$i = 0;
					foreach( $results as $key => $row)
					{
						$to = $row['mobileno'];
						$text = $row['fmessage'];

$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);

$rgInsert[] = "('".$row['funivcode']."','".$row['fregno']."','{$to}','0',
						'{$smsresp}','".$row['fenttype']."','T', DATE_FORMAT(NOW(),'%Y-%m-%d'), 
						DATE_FORMAT(NOW(),'%T'))";
						$rgTrimedMobs[$i] = $to;
						
						if($i == 50)
						{
							$strInsertQuery = "insert into {$commondb}.smslog(funivcode, fregno,fmobileno, 
							freasoncode, fguid, fenttype, fstatus,fackdate, facktime) 
							values".implode(',',$rgInsert);
							//var_dump($strInsertQuery);
							$result1 = $aobj_context->mobj_db->Execute($strInsertQuery);

$srtImplodedMobs = implode("','",$rgTrimedMobs); 
							$strUpdateQuery = "update {$commondb}.sendsms set fstatus = 'T' 
							where fenttype = '{$row['fenttype']}' and fmobileno in ('{$srtImplodedMobs}')";
							//var_dump($strUpdateQuery);	
							
							$result2 = $aobj_context->mobj_db->Execute($strUpdateQuery);
							
							unset($rgInsert);
							$rgInsert = array();

unset($rgTrimedMobs);
							$rgTrimedMobs = array();
							$i = 0;
						}

$i++;
					}

$strInsertQuery = "insert into {$commondb}.smslog(funivcode,fregno,fmobileno, freasoncode, 
					fguid, fenttype, fstatus,fackdate, facktime) values".implode(',',$rgInsert);
					//var_dump($strInsertQuery);
					$result3 = $aobj_context->mobj_db->Execute($strInsertQuery);

$srtImplodedMobs = implode("','",$rgTrimedMobs); 
					$strUpdateQuery = "update {$commondb}.sendsms set fstatus = 'T' 
					where  fenttype = '{$row['fenttype']}' and fmobileno in ('{$srtImplodedMobs}')";
					//var_dump($strUpdateQuery);	
					$result3 = $aobj_context->mobj_db->Execute($strUpdateQuery);

}

$data = "Uploaded Successfully.";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			return;	
		}
	}
	
}
}

${this.title}

Code Editor : admuploadexsheet.php