Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.12 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	24.41 KB	-rwxr-xr-x
MarkEntry-Setup22.php	21.76 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	6.91 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
absententrysubjectwiseQP.js	16.34 KB	-rwxr-xr-x
ack_exam_app_form.php	15.86 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.58 KB	-rwxr-xr-x
ack_exam_app_form_oldformat.ph...	12.53 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.35 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admapprove.php	9.24 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	9.9 KB	-rwxr-xr-x
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.34 KB	-rwxr-xr-x
approve.php	23.86 KB	-rwxr-xr-x
attendance.php	9.7 KB	-rwxr-xr-x
attendance_freez.php	8.45 KB	-rwxr-xr-x
attendance_freez_old.php	8.55 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	2.73 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
basic_old.css	13.33 KB	-rwxr-xr-x
batch_close.php	4.31 KB	-rwxr-xr-x
bundle_dispatch.php	2.93 KB	-rwxr-xr-x
bundlereceive.php	1.08 KB	-rwxr-xr-x
bundlestatus.php	5.3 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	45.51 KB	-rwxr-xr-x
candidate-entry_new.php	42.85 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entrynewformat.php	44.16 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
candidate_list.js	39.62 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
challan_entries.php	15.41 KB	-rwxr-xr-x
challan_preparation.php	11.69 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
connect.php	2.11 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	4.95 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	105.12 KB	-rwxr-xr-x
display_details_in_grid22.php	104.95 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.6 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
display_details_in_gridold.php	102.19 KB	-rwxr-xr-x
doc_verify.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	5.32 KB	-rwxr-xr-x
download_misc_files.php	4.59 KB	-rwxr-xr-x
download_misc_files_old.php	4.3 KB	-rwxr-xr-x
download_photo.php	3.54 KB	-rwxr-xr-x
download_photo22.php	6.83 KB	-rwxr-xr-x
download_photo_new.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim.php	4.82 KB	-rwxr-xr-x
download_photoold.php	3.58 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.63 KB	-rwxr-xr-x
freeze_module_at_admin_college...	9.74 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.76 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.81 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.59 KB	-rwxr-xr-x
getdata22.php	32.91 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.03 KB	-rwxr-xr-x
getmoduledetails.php	23.59 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
index.php	5.06 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	10.94 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
mascomb.php	10.02 KB	-rwxr-xr-x
mcverifydet.php	14.26 KB	-rwxr-xr-x
message_board.php	4.7 KB	-rwxr-xr-x
messagetext.php	980 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	71.94 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
payment_gateway.php	7.78 KB	-rwxr-xr-x
pclzip.lib.php	192.53 KB	-rwxr-xr-x
photoupload.php	9.28 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.57 KB	-rwxr-xr-x
report_admission_ticket.php	46.77 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
result.php	5.06 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	16.41 KB	-rwxr-xr-x
room_allotment_datewise.php	16.47 KB	-rwxr-xr-x
room_allotmentnew.php	9.24 KB	-rwxr-xr-x
room_allotmentold.php	15.27 KB	-rwxr-xr-x
roomdeclaration.php	1.88 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
servfeehead.php	3.84 KB	-rwxr-xr-x
services.php	3.47 KB	-rwxr-xr-x
sfeehead.php	5.45 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	43.89 KB	-rwxr-xr-x
student_entry.php	46.56 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entry_24112017.php	42.7 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.05 KB	-rwxr-xr-x
subject_freshExam.php	18.98 KB	-rwxr-xr-x
subjectfreez.php	13.16 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	79.94 KB	-rwxr-xr-x
teachers.php	14.51 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
teachersnew.php	16.83 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
upload_studentPhoto.php	8.61 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	8.46 KB	-rwxr-xr-x
usersetup.php	25.06 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.88 KB	-rwxr-xr-x

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