Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
cielist.php	[ DIR ]	drwxr-xr-x
system	[ DIR ]	drwxr-xr-x
CIEAttendanceNotEligible.php	3.28 KB	-rwxr-xr-x
CIEpendingList.php	2.96 KB	-rwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
DisplayPrintApplication_ru.php	65.63 KB	-rwxr-xr-x
ECHblk.php	14.02 KB	-rwxr-xr-x
ECHblk_15042021.php	11.68 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MainPage.html	11.66 KB	-rwxr-xr-x
MarkEntry-Setup.php	30.56 KB	-rwxr-xr-x
MarkEntry-Setup_bf_gcg.php	22.89 KB	-rwxr-xr-x
SelectSubjType.php	3.05 KB	-rwxr-xr-x
SubjectType.php	3.64 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
UpdateCollDet.php	2.04 KB	-rwxr-xr-x
absentAndMalReportPdf.php	8.25 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	10.93 KB	-rwxr-xr-x
ack_adm_application.php	66.01 KB	-rwxr-xr-x
ack_adm_application.php.orig	58.73 KB	-rwxr-xr-x
ack_admentry_application.php	59.63 KB	-rwxr-xr-x
ack_exam_app_form.php	17.74 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.71 KB	-rwxr-xr-x
ack_report.php	3.66 KB	-rwxr-xr-x
ack_rv_rt_application.php	9.34 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
adm.php	15.4 KB	-rwxr-xr-x
adm_delete_data.php	5.58 KB	-rwxr-xr-x
admapprove.php	10.33 KB	-rwxr-xr-x
admapprove_kus.php	9.28 KB	-rwxr-xr-x
admissionHallTicket.php	1.8 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	5.06 KB	-rwxr-xr-x
admlist.php	13.87 KB	-rwxr-xr-x
admstuddate.php	6.06 KB	-rwxr-xr-x
admuploadexsheet.php	20.48 KB	-rwxr-xr-x
affliation_fee.php	5.04 KB	-rwxr-xr-x
approve.php	41.53 KB	-rwxr-xr-x
approve_kus.php	24.12 KB	-rwxr-xr-x
attCisshortList_sjbit.php	11.91 KB	-rwxr-xr-x
attEntTeachWise.php	2.07 KB	-rwxr-xr-x
attTeachSum.php	3.63 KB	-rwxr-xr-x
attendEntry.php	3.89 KB	-rwxr-xr-x
attendance.php	16 KB	-rwxr-xr-x
attendanceReportForm.php	5.81 KB	-rwxr-xr-x
attendance_freez.php	8.51 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendanceentrydaywise.php	11.36 KB	-rwxr-xr-x
attendenceshort.php	7.5 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
atttechblp.php	2.48 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	4.12 KB	-rwxr-xr-x
backup_1.php	7.73 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
backupold.php	2.73 KB	-rwxr-xr-x
bill_details.php	14.21 KB	-rwxr-xr-x
board.php	4 KB	-rwxr-xr-x
bundle_dispatch.php	3.2 KB	-rwxr-xr-x
bundle_rec_ack.php	4.67 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	50.68 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
challan_entries.php	15.05 KB	-rwxr-xr-x
challan_preparation.php	11.29 KB	-rwxr-xr-x
changeDegree.php	1.56 KB	-rwxr-xr-x
changeMobile.php	2.13 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
cntDeclaration.php	4.23 KB	-rwxr-xr-x
coll_exam_app_form.php	3.29 KB	-rwxr-xr-x
collbankdet.php	1.9 KB	-rwxr-xr-x
colldesp_ack.php	4.03 KB	-rwxr-xr-x
college.php	5.39 KB	-rwxr-xr-x
college_approve.php	5.59 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
collegewisedownload.php	9.46 KB	-rwxr-xr-x
colltransfer.php	6.83 KB	-rwxr-xr-x
connect.php	2.58 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
convo.php	8.14 KB	-rwxr-xr-x
copomarksentry.php	10.46 KB	-rwxr-xr-x
copomarksexternal.php	22.46 KB	-rwxr-xr-x
coporeport.php	4.56 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
createAdmission.php	14.75 KB	-rwxr-xr-x
createUser.php	6.93 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
createattclass.php	6.87 KB	-rwxr-xr-x
createclassattend.php	19.79 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	6.67 KB	-rwxr-xr-x
degree.php	8.28 KB	-rwxr-xr-x
degstudymat.php	6.51 KB	-rwxr-xr-x
degstudymatdet.php	6.27 KB	-rwxr-xr-x
delegate.php	3.29 KB	-rwxr-xr-x
display_details_in_grid.php	107.06 KB	-rwxr-xr-x
display_details_in_grid_bf_231...	111.76 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.72 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
doc_verify.php	7.52 KB	-rwxr-xr-x
download_misc_files.php	5.19 KB	-rwxr-xr-x
download_misc_files_bcu_comm.p...	4.19 KB	-rwxr-xr-x
download_photo.php	35.98 KB	-rwxr-xr-x
download_photo_pgadm_photos.ph...	4.73 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
editstddet.php	4.61 KB	-rwxr-xr-x
entregupd.php	1.91 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxr-xr-x
examappfeereport.php	2.12 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
feepaidreports.php	2.42 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.64 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10.48 KB	-rwxr-xr-x
freeze_module_at_admin_college...	9.35 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
freezeiaprici.php	10.87 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getDegreeAndSem.php	4.28 KB	-rwxr-xr-x
getMessages.php	11.39 KB	-rwxr-xr-x
getdata.php	38.11 KB	-rwxr-xr-x
getdataold.php	29.62 KB	-rwxr-xr-x
getfeeinformation.php	7.26 KB	-rwxr-xr-x
getmoduledetails.php	23.77 KB	-rwxr-xr-x
getnumword.php	7.45 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
htblk.php	6.13 KB	-rwxr-xr-x
iamarks.php	7.63 KB	-rwxr-xr-x
iasectionwise.php	30.09 KB	-rwxr-xr-x
iasectionwisenew.php	34.58 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
kusphdadm.php	7.25 KB	-rwxr-xr-x
lateralentry.php	2.39 KB	-rwxr-xr-x
login.php	8.81 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
marksEntryExt.php	13.1 KB	-rwxr-xr-x
marksentryquestionwise.php	41.93 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
messagetext.php	1.68 KB	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	139.86 KB	-rwxr-xr-x
mregistry18.06.2021.php	99.46 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
newuser.php	2.69 KB	-rwxr-xr-x
oldqnpaper.php	4.44 KB	-rwxr-xr-x
pendingcie.php	4.17 KB	-rwxr-xr-x
pmarks.php	5.67 KB	-rwxr-xr-x
post.php	6 KB	-rwxr-xr-x
practicalMarks.php	8.65 KB	-rwxr-xr-x
princiOTPsubjectfreeze.php	3.05 KB	-rwxr-xr-x
principalFreeze.php	6.92 KB	-rwxr-xr-x
principalfreezingsubject.php	1.81 KB	-rwxr-xr-x
printApp_ru.php	1.12 KB	-rwxr-xr-x
qnwiseMarksStats.php	5.95 KB	-rwxr-xr-x
qpSummaryReport.php	1.03 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.33 KB	-rwxr-xr-x
receive_teach_trans.php	2.49 KB	-rwxr-xr-x
receive_teach_transfer.js	5.06 KB	-rwxr-xr-x
report_bulk_applications.php	19.42 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	22.93 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.54 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
resetPasswordUser.php	2.69 KB	-rwxr-xr-x
result.php	5.06 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	8.75 KB	-rwxr-xr-x
room_allotment_datewise.php	25.85 KB	-rwxr-xr-x
room_allotment_datewise_bf_rcu...	16.97 KB	-rwxr-xr-x
room_allotment_datewise_stph.p...	21.49 KB	-rwxr-xr-x
room_allotment_shifiting.php	3.09 KB	-rwxr-xr-x
roomcreationnew.php	2.81 KB	-rwxr-xr-x
roomdeclaration.php	2.2 KB	-rwxr-xr-x
roomdeclaration_stph.php	2.51 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
rvrt_ack_exam_app.php	5.8 KB	-rwxr-xr-x
rvrt_report.php	1.92 KB	-rwxr-xr-x
saveclsdets.php	1.91 KB	-rwxr-xr-x
savesspdetails.php	9.93 KB	-rwxr-xr-x
sectionwisepermission.php	5.62 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendusrandpws.php	1002 B	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
shortLists.php	1.65 KB	-rwxr-xr-x
std_register_det.php	3.56 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
studSubIdent.php	11.23 KB	-rwxr-xr-x
stud_name_doc_upload.php	1.24 KB	-rwxr-xr-x
stud_wise_report.php	3.02 KB	-rwxr-xr-x
student.php	58.35 KB	-rwxr-xr-x
student_entry.php	61.38 KB	-rwxr-xr-x
student_entry_kswu.php	51.23 KB	-rwxr-xr-x
student_entry_nitte.php	87.54 KB	-rwxr-xr-x
student_entry_rur.php	74.42 KB	-rwxr-xr-x
student_entry_vku.php	66.58 KB	-rwxr-xr-x
student_rur.php	64.37 KB	-rwxr-xr-x
student_vku.php	57.95 KB	-rwxr-xr-x
studentportal_remove.php	6.18 KB	-rwxr-xr-x
studentreport.php	14.53 KB	-rwxr-xr-x
studnamecorr.php	6.69 KB	-rwxr-xr-x
subIAMarksEntry.php	11.14 KB	-rwxr-xr-x
subblock.php	6.12 KB	-rwxr-xr-x
subdet.php	9.61 KB	-rwxr-xr-x
subjReg.php	8.75 KB	-rwxr-xr-x
subjectList_display.php	11.7 KB	-rwxr-xr-x
subject_freshExam.php	32.99 KB	-rwxr-xr-x
subject_freshExam_rcub.php	28.33 KB	-rwxr-xr-x
subjectfreez.php	13.02 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	12.43 KB	-rwxr-xr-x
subshort.php	8.57 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.41 KB	-rwxr-xr-x
teachFreeze.php	8.09 KB	-rwxr-xr-x
teachOficerEntry.php	11.46 KB	-rwxr-xr-x
teachers.php	19.86 KB	-rwxr-xr-x
time_table_degreewise.php	5 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	5.11 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updatecopo.php	9.34 KB	-rwxr-xr-x
updatedegreegroup.php	3.21 KB	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
updatefreshexam.php	1.33 KB	-rwxr-xr-x
updatestudentsem.php	1.65 KB	-rwxr-xr-x
updatetimetable.php	9.14 KB	-rwxr-xr-x
updateuvcms.php	2.37 KB	-rwxr-xr-x
updmarks.php	16.28 KB	-rwxr-xr-x
upload_doc_demo.php	84 B	-rwxr-xr-x
upload_studentPhoto.php	10.81 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadcopo.php	7.89 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadteacherattendance.php	5.23 KB	-rwxr-xr-x
userpasswordreset.php	754 B	-rwxr-xr-x
usersetup.php	24.23 KB	-rwxr-xr-x
usersetupNew.php	8.77 KB	-rwxr-xr-x
usersubj_identification.php	5.08 KB	-rwxr-xr-x
viewNotifications.php	1.21 KB	-rwxr-xr-x
view_ledger.php	3.44 KB	-rwxr-xr-x

Code Editor : FormulaEvaluate.php

<?php
  /*
            Author :  Natesha
	 Date : 2009-9-19
	 Module : Purchase Order

*/  
  
  
  class FormulaEvaluate
	{
    public $login_ctr;
    public $qty;
    public $alt_qty;
    public $rate_for;
    public $rate;
    public $item_basic_value;
    public $lobj_select_item_data;
    public $final_item_value;
       //Start :  Constructor
	           function __construct($aobj_context)
	              {
		              session_start();
		              $this->aobj_context=$aobj_context;
		              $this->aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
					  require_once($aobj_context->main_src."\custom_src\inventory_master.php");
					  require_once($aobj_context->main_src."\src\getnumword.php");
		              $this->user_id = $_SESSION['user_id'];
		              $this->login_ctr =$_SESSION['login_cnt'];
					   $this->ref_s_ref_data_code=$aobj_context->mobj_data["ref_s_ref_data_code"];
		              					  
		           }
		//End : Constructor 
		
	    function getItemCommercialTableValues()
		{
			if($this->entry_table_name=='grn_item_commercials')
			$value_field="item_value";
			else
			$value_field="item_value";
	 
			$this->alt_qty=empty($this->alt_qty)?0:$this->alt_qty;
			$this->rate=empty($this->rate)?0:$this->rate;
			$drop_table1 = "DROP TABLE IF EXISTS `formula_temp_{$this->login_ctr}`";
	                 $lobj_drop_table1 = $this->aobj_context->mobj_db->Execute($drop_table1);		
			
			$get_system_parameters="select internal_code,parameter_name from {$this->entry_table_name} where parameter_type='System'";
			$lobj_get_system_parameters = $this->aobj_context->mobj_db->GetAll($get_system_parameters);
		 
			foreach($lobj_get_system_parameters as $key=>$v)
			{
			$this->system_params_int_code[$v[parameter_name]]=$v[internal_code];
			}
			 
		
			 
			$create_temp_data="create table formula_temp_{$this->login_ctr} as 
							select {$this->system_params_int_code['Qty']} as internal_code,'Qty' as name,0 as percentage,0 as amount,{$this->qty} as value,'USER' as type, 'USER' as level,'USER' as action,{$this->qty} as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-1 as seq
							union
							select {$this->system_params_int_code['Alt Qty']} as internal_code,'Alt Qty' as name,0 as percentage,0 as amount,{$this->alt_qty} as value,'USER' as type, 'USER' as level,'USER' as action,{$this->alt_qty} as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-2 as seq
							union
							select {$this->system_params_int_code['Rate']} as internal_code,'Rate' as name,0 as percentage,0 as amount,{$this->rate} as value,'USER' as type, 'USER' as level,'USER' as action,0 as 'e_formula',{$this->rate} as 'formula','Nearest Paisa' as round_off,-3 as seq
							union
							select {$this->system_params_int_code['Basic Value']} as internal_code,'Basic Value' as name,0 as percentage,0 as amount,if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as value,'USER' as type, 'USER' as level,'USER' as action,
							if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-4 as seq
							union
							select {$this->system_params_int_code['Item Value']} as internal_code,'Item Value' as name,0 as percentage,0 as amount,if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as value,'USER' as type, 'USER' as level,'USER' as action,
							if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-4 as seq
							
							union
							(select poic.internal_code,name,if(action='None',100,poic.percentage) as percentage,
							if(action='None',0,poic.amount) as amount,
							poic.value,p.type,fsd.level,fsd.action,
							if(amount<>0 && action<>'None',
							if('{$this->rate_for}'='UOM',{$this->qty}*amount,{$this->alt_qty}*amount),
							trim(formula)) as e_formula,
							formula	,round_off,fsd.sequence
							from 
							{$this->entry_table_name} poic
							inner join parameters p on p.internal_code=poic.parameter_int_code
							inner join formula_setup_details fsd on 
							fsd.internal_code=poic.formula_details_int_code
							where fsd.level='Item'
							and poic.login_cnt={$this->login_ctr}
							and 
							(poic.ref_s_ref_data_code={$this->ref_s_ref_data_code}
							or poic.ref_s_ref_data_code=0) order by fsd.sequence)";
					  //
							
					
					$lobj_create_temp_data = $this->aobj_context->mobj_db->Execute($create_temp_data);
					
					$select_data = "select * from formula_temp_{$this->login_ctr} order by seq ";
					$this->lobj_select_data = $this->aobj_context->mobj_db->GetAll($select_data);
			 
					 $drop_table1 = "DROP TABLE IF EXISTS `formula_temp_{$this->login_ctr}`";
	                 $lobj_drop_table1 = $this->aobj_context->mobj_db->Execute($drop_table1);		
					 
					$this->item_basic_value=($this->rate_for=='UOM')?$this->qty*$this->rate:$this->alt_qty*$this->rate;
				 $this->lobj_formula_result=array();
				  $this->final_item_value=$this->item_basic_value;
		}
		
		
		function getItemCommercialGroupTable()
		{
			$get_system_parameters="select* from {$this->group_table_name} where parameter_type='System'";
			$lobj_get_system_parameters = $this->aobj_context->mobj_db->GetAll($get_system_parameters);
			foreach($lobj_get_system_parameters as $key=>$v)
			{
			$this->system_params_int_code[$v[paramater_name]]=$v[internal_code];
			}
			$this->alt_qty=empty($this->alt_qty)?0:$this->alt_qty;
			$this->rate=empty($this->rate)?0:$this->rate;
		 
					//echo $select_data;
					$create_temp_data="create table formula_po_temp_{$this->login_ctr} as 
							select {$this->system_params_int_code['Qty']} as internal_code,'Qty' as name,0 as percentage,0 as amount,{$this->qty} as value,'USER' as type, 'USER' as level,'USER' as action,{$this->qty} as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-1 as seq
							union
							select {$this->system_params_int_code['Alt Qty']} as internal_code,'Alt Qty' as name,0 as percentage,0 as amount,{$this->alt_qty} as value,'USER' as type, 'USER' as level,'USER' as action,{$this->alt_qty} as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-2 as seq
							union
							select {$this->system_params_int_code['Rate']} as internal_code,'Rate' as name,0 as percentage,0 as amount,{$this->rate} as value,'USER' as type, 'USER' as level,'USER' as action,0 as 'e_formula',{$this->rate} as 'formula','Nearest Paisa' as round_off,-3 as seq
							union
							select {$this->system_params_int_code['Basic Value']} as internal_code,'Basic Value' as name,0 as percentage,0 as amount,if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as value,'USER' as type, 'USER' as level,'USER' as action,
							if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-4 as seq
							union
							select {$this->system_params_int_code['Item Value']} as internal_code,'Item Value' as name,0 as percentage,0 as amount,if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as value,'USER' as type, 'USER' as level,'USER' as action,
							if('{$this->rate_for}'='UOM',{$this->qty}*{$this->rate},{$this->alt_qty}*{$this->rate}) as 'e_formula',0 as 'formula','Nearest Paisa' as round_off,-4 as seq
							
							union
							(select poic.internal_code,name,if(action='None',100,poic.percentage) as percentage,
							if(action='None',0,poic.amount) as amount,
							poic.value,p.type,fsd.level,fsd.action,
							if(amount<>0 && action<>'None',
							if('{$this->rate_for}'='UOM',{$this->qty}*amount,{$this->alt_qty}*amount),
							trim(formula)) as e_formula,
							formula	,round_off,fsd.sequence
							from 
							{$this->group_table_name} poic
							inner join parameters p on p.internal_code=poic.parameter_int_code
							inner join formula_setup_details fsd on 
							fsd.internal_code=poic.formula_details_int_code
							where fsd.level='Item' and 
							poic.ref_s_ref_data_code={$this->ref_s_ref_data_code} order by fsd.sequence)";
					  
					$lobj_create_temp_data = $this->aobj_context->mobj_db->Execute($create_temp_data);
					
					
					$select_data = "select * from formula_po_temp_{$this->login_ctr} order by seq ";
					$this->lobj_select_data = $this->aobj_context->mobj_db->GetAll($select_data);
				 
					 $drop_table2 = "DROP TABLE IF EXISTS `formula_po_temp_{$this->login_ctr}`";
	                $lobj_drop_table2 = $this->aobj_context->mobj_db->Execute($drop_table2);		
									 
					$this->item_basic_value=($this->rate_for=='UOM')?$this->qty*$this->rate:$this->alt_qty*$this->rate;
				 $this->final_item_value=$this->item_basic_value;
				  	 $this->lobj_formula_result=array();
		}
		
		
		function getPoOrderCommercialTableValues()
		{
		 
		$select_data="		select poic.internal_code,name,poic.order_percentage as percentage,
							poic.order_amount as amount,poic.order_value as value,
							p.type,fsd.level,fsd.action,
							if(fsd.level='Item',order_amount,trim(formula))  as e_formula,
							formula	,round_off
							from 
							{$this->entry_table_name} poic
							inner join parameters p on p.internal_code=poic.order_parameter_int_code
							inner join formula_setup_details fsd on 
							fsd.internal_code=poic.order_formula_details_int_code						 
							and poic.login_cnt={$this->login_ctr} order by fsd.sequence
							";
		 	$this->lobj_select_data = $this->aobj_context->mobj_db->GetAll($select_data);
				 $this->lobj_formula_result=array();
			
			$get_formula_result="SELECT  parameter_name,SUM(VALUE) AS amt
							FROM  purchase_order_item_commercials_entry
							WHERE login_cnt='{$this->login_ctr}'
							 GROUP BY parameter_name";
			$get_formula_result = $this->aobj_context->mobj_db->GetAll($get_formula_result);
			foreach($get_formula_result as $fk=>$fv)
			{
			$this->lobj_formula_result[$fv[parameter_name]]=$fv[amt];
			}
			$this->final_item_value=$this->lobj_formula_result['Item Value']; 
		 
		 
		function CalculateFormulaValues()
		{
				
			
			  
			
			for($i=0;$i<count($this->lobj_select_data);$i++)
			{
					$name=trim($this->lobj_select_data[$i]['name']);
					$round_off_type=$this->lobj_select_data[$i]['round_off'];
					$formula=$this->lobj_select_data[$i]['e_formula'];
					$this->lobj_formula_result[$name]=trim($this->lobj_select_data[$i]['e_formula']);
					$brace_count=substr_count($formula, "{");
					if($brace_count>0) 
					{
						for($k=0;$k<($brace_count);$k++)
						{
							$pos_open_brace=strpos($formula,'{');
							$pos_close_brace=strpos($formula,'}');
							if ($pos_open_brace === false && $pos_close_brace===false) {
							}
							else 
							{
							
							$id=substr($formula, $pos_open_brace+1, (($pos_close_brace)-($pos_open_brace+1)));  
							$calc_val=empty($this->lobj_formula_result[$id])?0:$this->lobj_formula_result[$id];
							$value= str_replace("{".$id."}",$calc_val, $formula);
							$formula=$value;						
							}				
						}
						 
					}
					else {
					$value=$formula;
					}
					$value=(empty($value))?0:$value; 
				 
					 error_reporting(0); 
					if(false===eval("\$value =  ($value);"))
					{	
						$get_sql_value="select ". stripslashes($value)." as result";
						$lobj_get_sql_value = $this->aobj_context->mobj_db->GetRow($get_sql_value);
						$value= empty($lobj_get_sql_value[result])?0:$lobj_get_sql_value[result];
					}
					else
					{
						$value=$value;
					}
					$value=(empty($value))?0:$value; 
					$value=roundOff($value,$round_off_type);
					 
					if($this->lobj_select_data[$i]['level']=='Item' or $this->lobj_select_data[$i]['level']=='Document')
					{
						if($this->lobj_select_data[$i]['percentage']>0 && $this->lobj_select_data[$i]['action']!='None')
						{
							
							$value=$value*($this->lobj_select_data[$i]['percentage']/100);
						}if($this->lobj_select_data[$i]['amount']>0 && $this->lobj_select_data[$i]['action']!='None')
						{
							
							$value=$this->lobj_select_data[$i]['amount'];
						}	
						 else if($this->lobj_select_data[$i]['percentage']==0 && $this->lobj_select_data[$i]['amount']==0 && $this->lobj_select_data[$i]['action']!='None')
						 {
						 $value=0;
						 }
						 //else
						 //$value=$this->lobj_select_data[$i]['amount'];
						 
						 $value=empty($value)?0:$value;
						// echo '--'.$value;
							if($this->lobj_select_data[$i]['action']=='Add')
							{
							$this->final_item_value+=$value;
							}
							else if($this->lobj_select_data[$i]['action']=='Deduct')
							$this->final_item_value-=$value;	
                   	}
					$this->lobj_formula_result[$name]= ($value);
					$this->lobj_select_data[$i]['e_formula']=$value;
			}	
 				$this->final_item_value=round($this->final_item_value,2);  
		 	   // echo "<pre>";print_r($this->lobj_select_data);
			 // print_r($this->lobj_formula_result);	 
		}
	
		function UpdateItemCommericials()
		{
	 
			foreach($this->lobj_select_data as $key=>$val)
			{
				if($val['internal_code']>0)
				{
				if(strtolower($val[name])=='item value')
				$row_val=$this->final_item_value;
				else
				$row_val=$val[e_formula];
				$update_value="update {$this->entry_table_name}
								set value={$row_val}
								where internal_code={$val['internal_code']}";
				$lobj_update_value = $this->aobj_context->mobj_db->Execute($update_value);	
 			// echo $update_value.'<br>';
				}
			} 
		}
		
		function UpdateItemGroupCommericials()
		{
			foreach($this->lobj_select_data as $key=>$val)
			{
				if($val['internal_code']>0)
				{
				$update_value="update {$this->group_table_name}
								set value={$val[e_formula]}
								where internal_code={$val['internal_code']}";
				$lobj_update_value = $this->aobj_context->mobj_db->Execute($update_value);	
 			
				}
			}
		}
		
		function UpdateOrderCommericials()
		{
			foreach($this->lobj_select_data as $key=>$val)
			{
				if($val['internal_code']>0 && $val['level']=='Document')
				{
				$update_value="update {$this->entry_table_name}
								set order_value={$val[e_formula]}
								where internal_code={$val['internal_code']}";
				$lobj_update_value = $this->aobj_context->mobj_db->Execute($update_value);		
				 			
				}
			}
		}
}	
       
       
function  EvaluatePOItemLevelFormulaValues($aobj_context) 
 {
    
	 
 }
 
?>

${this.title}

Code Editor : FormulaEvaluate.php