OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	10/11/2024 05:53:15 AM	rwxr-xr-x
📄 advance_report.php	5.35 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 applications_list.php	36.88 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 appr_committee-05-10-20.php	14.35 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 appr_committee.php	22.72 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 approval_report.php	20.25 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📁 certs	-	10/11/2024 05:51:58 AM	rwxr-xr-x
📄 cms_add_signature.php	3.01 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_committee.php	15.42 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_event_mailer.php	7.32 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_event_transactions.php	10.9 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_events.php	135.15 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_events.php.12.1.2021	121.98 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_events_calendar.php	4.04 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_functions.php	29.98 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_general.php	17.1 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_journal.php	14.6 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_lw_reg.php	70.44 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_lw_stallbooking.php	20.88 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_lw_transactions.php	11.07 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_lw_transactions_export.php	2.82 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_media.php	11.31 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_membership_transactions.php	9.87 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_reports.php	91.17 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_reports_accounts.php	11.09 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_revenue_reports.php	90.31 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_users.php	17.81 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_venue.php	24.9 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_venue_tracker.php	49.28 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_venue_transactions.php	10.88 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_venues_calendar.php	3.3 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 cms_ylf_transactions.php	8.73 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_add_signature2.php	5.12 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_add_signature2_last_year.php	5.02 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_advance_vouchers.php	14.73 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_billing.php	46.6 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_billing.php.2.11.2021	45.57 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_cha.php	25.18 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_export_to_excel.php	64.54 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_generate_pdf.php	5.72 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_generate_pdf_last_year.php	5.62 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_get_cha.php	1.19 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_get_cha_balance.php	706 bytes	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_get_company_id.php	3.45 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_get_membership_details.php	1.57 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_grn.php	19.04 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_irn_qrcode.php	1 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_irn_qrcode_delhi.php	1.01 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_member_status_update.php	2.26 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_members.php	52.31 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_membership_reconcile.php	2.42 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_online_manager.php	30.02 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_online_test_stamping.php	4.47 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_print_invoice.php	28.48 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_print_other.php	4.9 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_quick_print.php	6.54 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_receipts.php	22.54 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_recharge.php	19.01 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_recharge_balance_update.php	2.34 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_recharge_transfer.php	19.59 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_reports.php	89.15 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 co_visa_request.php	23.38 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 coo_add_signature.php	5.85 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📁 css	-	10/11/2024 05:51:58 AM	rwxr-xr-x
📄 dashboard.php	6.32 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 dblib.php	4.55 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 dm_applications_list.php	37.17 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📁 e-invoice	-	10/11/2024 05:51:58 AM	rwxr-xr-x
📄 ed_course_track.php	12.14 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_courses.php	20.47 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_exam_registrations.php	38.45 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_exams.php	10.8 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_export_excel.php	3.42 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_generate_pdf.php	5.25 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_institutes.php	14.49 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_print.php	20.65 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_seats.php	1.73 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_students.php	21.29 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_students_export.php	1.51 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_transactions.php	50.62 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 ed_transactions_export.php	2.87 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 events_calendar_public.php	6.28 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 events_mark_attendance.php	956 bytes	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 example_052.php	3.77 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 export_to_excel.php	59.34 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 export_to_excel_revenue.php	59.7 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 fee_structure.php	3.17 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 footer.php	1.53 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 forgot-password.html	2.05 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 func_lib.php	29.33 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 generate_doc.php	29.58 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 generate_pdf-09-11-20.php	13.16 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 generate_pdf.php	12.32 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 get_company_details.php	3.58 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 get_exhibitor_details.php	1.43 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 get_lw_details.php	1.45 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 gulpfile.js	3.21 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 header-bare.php	1.72 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 header.php	5.28 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📁 images	-	10/11/2024 05:51:58 AM	rwxr-xr-x
📄 index.php	2.36 KB	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 interstitial.php	804 bytes	10/11/2024 05:51:58 AM	rw-rw-rw-
📄 irn_qrcode.php	1006 bytes	10/11/2024 05:51:58 AM	rw-rw-rw-
📁 js	-	10/11/2024 05:51:59 AM	rwxr-xr-x
📄 label_print.php	8.82 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 login.php	2.54 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 lw_label_print.php	5.61 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 mailtest.php	598 bytes	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 member_data_print.php	16.79 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 member_renewal.php	12.86 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 members-13-10-2020.php	227 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 members-16-03-21.php	241.02 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 members-23-12-20.php	235.39 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 members.php	266.25 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 members.php.28.10.2021	260.54 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 membership_cost.php	8.9 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 membership_dashboard.php	6.13 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 membership_dashboard_test.php	6.19 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 membership_export_to_excel.php	62.55 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 membership_filters.php	26.02 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 menu.php	2.14 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 order_process.php	3.94 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 order_report.php	39.43 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📁 phpqrcode	-	10/11/2024 05:51:59 AM	rwxr-xr-x
📄 print-09-11-2020.php	19.9 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 print.php	25.41 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 print_approval_report-approvaldate.php	16.64 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 print_approval_report.php	18.89 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 register.html	3.33 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 renew_membership.php	10.77 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 requirements.php	22.47 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📁 scss	-	10/11/2024 05:51:59 AM	rwxr-xr-x
📄 tables.html	25.73 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 tally.php	24.87 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 test_renewal_pending.php	2.59 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 test_report.php	5.38 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 test_report_coo.php	5.83 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 test_report_coo_advance.php	5.8 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 test_report_invoices.php	5.46 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 test_report_lw.php	5.36 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 testexport.php	2.36 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 track-test.php	1.46 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📁 vendor	-	10/11/2024 05:51:59 AM	rwxr-xr-x
📁 vendor1	-	10/11/2024 05:51:59 AM	rwxr-xr-x
📄 visiting_card.php	17.32 KB	10/11/2024 05:51:59 AM	rw-rw-rw-
📄 year_selection_module.php	3.44 KB	10/11/2024 05:51:59 AM	rw-rw-rw-

Editing: cms_functions.php

<?php

function get_event_readonly($event_id = "", $user_id = "", $level = "")
{
	
$sql_temp = "select count(*) from event_admins where user_id = '".$user_id."' and event_id = '".$event_id."'";
$qid_temp = db_query($sql_temp);
$result_temp = db_fetch_row($qid_temp);

if ($result_temp[0] > 0 || $level == 3)
{
$readonly_flag = "";
}
else
{
$readonly_flag = "readonly";	
}

return $readonly_flag;

}

function get_main_committee($main_cat_id)
{
	$sql_committee = "select main_cat_name from committee_main_cat where main_cat_id = '".$main_cat_id."'";
	$qid_committee = db_query($sql_committee);
	$result_committee = db_fetch_row($qid_committee);
	return $result_committee[0];
}

function get_sub_committee($sub_cat_id)
{
	$sql_sub_committee = "select sub_cat_name from committee_sub_cat where sub_cat_id = '".$sub_cat_id."'";
	$qid_sub_committee = db_query($sql_sub_committee);
	$result_sub_committee = db_fetch_row($qid_sub_committee);
	return $result_sub_committee[0];
}

function gen_institute_array()
{
	
	$institute_array = array();
	
	$sql2 = "select institute_id, title from ed_institute_master where status != 'deleted'";
	$qid2 = db_query($sql2);
	$num2 = db_num_rows($qid2);

for ($k=0;$k<=$num2-1;$k++)
	{
	$result2 = db_fetch_row($qid2);	
	
	$institute_array[$result2[0]] = $result2[1];
	
	}

return 	$institute_array;

}

function gen_course_array()
{
	
	$course_array = array();
	
	$sql2 = "select course_id, title from ed_course_master where status != 'deleted'";
	$qid2 = db_query($sql2);
	$num2 = db_num_rows($qid2);

for ($k=0;$k<=$num2-1;$k++)
	{
	$result2 = db_fetch_row($qid2);	
	
	$course_array[$result2[0]] = $result2[1];
	
	}

return 	$course_array;

}

$data .= "Member Name : ".$result_member_details->member_name." 
	Company Email Id : ".$result_member_details->member_email."";
	if($result_member_details->member_email2 != ""){$data .= ", ".$result_member_details->member_email2."";}
	if($result_member_details->member_email3 != ""){$data .= ", ".$result_member_details->member_email3."";}
	if($result_member_details->email2 != ""){$data .= ", ".$result_member_details->email2."";}
	$data .= " ";

}

function change_log($department,$member_id="",$change_in, $change_type, $user_session)
{
	$sql_change_log = "insert into change_log (department, member_id, change_in, change_type, modified_by, modified_on, post_date) values('".$department."',  '".$member_id."', '".$change_in."', '".$change_type."', '".$user_session."', '".date("Y-m-d h:i:sa")."', '".date('Y-m-d')."')";
	  $qid_change_log = db_query($sql_change_log);
}

function member_name($member_id)
{
$sql = "select member_name from membership_reg where member_id= '".$member_id."'";
$qid = db_query($sql);
$result = db_fetch_row($qid);
return cleanquery($result[0]);
}

function doc_name($sr_no)
{
$sql = "select description from member_documents where sr_no= '".$sr_no."'";
$qid = db_query($sql);
$result = db_fetch_row($qid);
return $result[0];
}

function venue_time_dropdown($label="", $default="", $field_name="")
{

echo "<select name=\"".$field_name."\" id=\"".$field_name."\" class=\"form-control\" >\n";
						echo "<option value=\"\">".$label."</option>\n";
						echo "<option value=\"900\""; if ($default == "900") { echo " selected "; } echo ">09:00 am</option>\n";
						echo "<option value=\"930\""; if ($default == "930") { echo " selected "; } echo ">09:30 am</option>\n";
						echo "<option value=\"1000\""; if ($default == "1000") { echo " selected "; } echo ">10:00 am</option>\n";
						echo "<option value=\"1030\""; if ($default == "1030") { echo " selected "; } echo ">10:30 am</option>\n";
						echo "<option value=\"1100\""; if ($default == "1100") { echo " selected "; } echo ">11:00 am</option>\n";
						echo "<option value=\"1130\""; if ($default == "1130") { echo " selected "; } echo ">11:30 am</option>\n";
						echo "<option value=\"1200\""; if ($default == "1200") { echo " selected "; } echo ">12:00 pm</option>\n";
						echo "<option value=\"1230\""; if ($default == "1230") { echo " selected "; } echo ">12:30 pm</option>\n";
						echo "<option value=\"1300\""; if ($default == "1300") { echo " selected "; } echo ">01:00 pm</option>\n";
						echo "<option value=\"1330\""; if ($default == "1330") { echo " selected "; } echo ">01:30 pm</option>\n";
						echo "<option value=\"1400\""; if ($default == "1400") { echo " selected "; } echo ">02:00 pm</option>\n";
						echo "<option value=\"1430\""; if ($default == "1430") { echo " selected "; } echo ">02:30 pm</option>\n";
						echo "<option value=\"1500\""; if ($default == "1500") { echo " selected "; } echo ">03:00 pm</option>\n";
						echo "<option value=\"1530\""; if ($default == "1530") { echo " selected "; } echo ">03:30 pm</option>\n";
						echo "<option value=\"1600\""; if ($default == "1600") { echo " selected "; } echo ">04:00 pm</option>\n";
						echo "<option value=\"1630\""; if ($default == "1630") { echo " selected "; } echo ">04:30 pm</option>\n";
						echo "<option value=\"1700\""; if ($default == "1700") { echo " selected "; } echo ">05:00 pm</option>\n";
						echo "<option value=\"1730\""; if ($default == "1730") { echo " selected "; } echo ">05:30 pm</option>\n";
						echo "<option value=\"1800\""; if ($default == "1800") { echo " selected "; } echo ">06:00 pm</option>\n";
						echo "<option value=\"1830\""; if ($default == "1830") { echo " selected "; } echo ">06:30 pm</option>\n";
						echo "<option value=\"1900\""; if ($default == "1900") { echo " selected "; } echo ">07:00 pm</option>\n";
						echo "<option value=\"1930\""; if ($default == "1930") { echo " selected "; } echo ">07:30 pm</option>\n";
						echo "<option value=\"2000\""; if ($default == "2000") { echo " selected "; } echo ">08:00 pm</option>\n";
						echo "<option value=\"2030\""; if ($default == "2030") { echo " selected "; } echo ">08:30 pm</option>\n";
						echo "<option value=\"2100\""; if ($default == "2100") { echo " selected "; } echo ">09:00 pm</option>\n";
						echo "<option value=\"2130\""; if ($default == "2130") { echo " selected "; } echo ">09:30 pm</option>\n";
						echo "<option value=\"2200\""; if ($default == "2200") { echo " selected "; } echo ">10:00 pm</option>\n";
						echo "<option value=\"2230\""; if ($default == "2230") { echo " selected "; } echo ">10:30 pm</option>\n";
						echo "<option value=\"2300\""; if ($default == "2300") { echo " selected "; } echo ">11:00 pm</option>\n";
						echo "<option value=\"2330\""; if ($default == "2330") { echo " selected "; } echo ">11:30 pm</option>\n";
						echo "</select>\n";
	
	
}

function quick_months_venue($url,$start_fieldname, $end_fieldname)
{

$month = date("m");
$year = date("Y");

$start_year = $year;
$start_month = $month-6;

if ($start_month <= 0) 
{ 
$start_month = $start_month+12; 
$start_year = $year - 1; 
}

$month_array = array("","Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec");
$month_array_num = array("","01","02","03","04","05","06","07","08","09","10","11","12");

for ($i=0;$i<=11;$i++)
	{
		if ($start_month == $month && $start_year == $year)
		{
		echo "<a href=\"".$url."?".$start_fieldname."=".$start_year."-".$month_array_num[$start_month]."-01&".$end_fieldname."=".$start_year."-".$month_array_num[$start_month]."-31\">".$month_array[$start_month]." ".substr($start_year,2,2)."</a> &nbsp;|&nbsp; \n";
		}
		else
		{
		echo "<a href=\"".$url."?".$start_fieldname."=".$start_year."-".$month_array_num[$start_month]."-01&".$end_fieldname."=".$start_year."-".$month_array_num[$start_month]."-31\">".$month_array[$start_month]." ".substr($start_year,2,2)."</a> &nbsp;|&nbsp; \n";
		}

$start_month ++;
		if ($start_month > 12) 
		{ 
		$start_month -= 12;
		$start_year++; 
		}
	}

}

function generate_online_url($order_no = "")
{

$salt = "imcverify";
$c = md5($salt.$order_no);

$url = "https://www.imcnet.org/online_payments.php?id=".$order_no."&c=".$c;

return $url;
}

function show_time($time_var ="")
{

if ($time_var <= 1200) 	{ 	$time_suffix = "am"; } else { $time_suffix = "pm"; }
	
	if ($time_var >= 1300) 	{ $time_actual = $time_var-1200; } else { $time_actual = $time_var; }
	
	
	$time_actual = substr_replace($time_actual, ":", -2, 0);
	return $time_actual." ".$time_suffix;
	
}

function show_time_calendar($time_var ="")
{
	
	$time_array = array("00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24");

if ($time_var <= 1200) 	{ 	$time_suffix = "am"; } else { $time_suffix = "pm"; }
	
	//if ($time_var >= 1300) 	{ $time_actual = $time_var-1200; } else { $time_actual = $time_var; }
	
	$time_actual = $time_var;
	
	if ($time_actual <= 900) { $time_actual = "0".$time_actual; }
	
	$time_actual = substr_replace($time_actual, ":", -2, 0);
	
	
	return $time_actual;
	
}

function load_venue_details()
{

$venue_array = array();

$sql_venue = "select venue_id, name from venues where status = 'active'";
	$qid_venue = db_query($sql_venue);
	$num_venue = db_num_rows($qid_venue);
			
	for ($i=0;$i<=$num_venue-1;$i++)
	{	
	$result_venue = db_fetch_row($qid_venue);
	
	$venue_array[$result_venue[0]] = $result_venue[1]; 
	}	
	
	return $venue_array;
	
}

function membership_cat($type_id)
{
	$sql = "select member_type_name from  membership_type where member_type_id = '".$type_id."'";
	$qid = db_query($sql);
	$result = db_fetch_row($qid);
	
	return $result[0];
	
	
}
function membership_code($type_id)
{
	$sql = "select short_code from  membership_type where member_type_id = '".$type_id."'";
	$qid = db_query($sql);
	$result = db_fetch_row($qid);
	
	return $result[0];
	
	
}

$sql_orders= "insert into  orders(order_no, item_1, cost_1, type_1, item_2, cost_2, cgst,sgst, igst, gstin,  grand_total, total, name,  email, mobile, landline, address, city, state, country, pincode, order_date, post_date, application_status, department, member_id, payment_method, payment_status, trans_type)
		values('".$order_no."', '".$item_1."', '".$cost_1."', '".$type_1."','".$item_2."','".$cost_2."', '".$cgst."', '".$sgst."', '".$igst."', '".cleanQuery($result_member_details[10])."', '".round($total_membership_fee)."', '".round($total_fee)."',  '".cleanQuery($member_name)."', '".cleanQuery($result_member_details[8])."', '".cleanQuery($result_member_details[7])."', '".cleanQuery($result_member_details[6])."', '".cleanQuery($result_member_details[1])."', '".cleanQuery($result_member_details[2])."', '".cleanQuery($result_member_details[3])."','".cleanQuery($result_member_details[5])."', '".cleanQuery($result_member_details[4])."', '".date("Y-m-d h:i:s")."', '".date('Y-m-d')."', 'Renew', '".$department."', '".$member_id."', '".$payment_method."', 'pending', 'MemberRenewal')"; 
		$qid_orders = db_query($sql_orders);
		
		$url = generate_online_url($order_no);

}

function statelist($member_state = "")
{
	echo "<select name=\"member_state\" id=\"member_state\" class=\"form-control\">\n";
echo "<option value=\"\">Select State</option>\n";

$sql_state = "select state from states_master";
$qid_state = db_query($sql_state);
$sql_num_state = db_num_rows($qid_state);

for($i=0; $i<$sql_num_state; $i++)
{
	$result_state = db_fetch_row($qid_state);
	echo "<option value=\"".$result_state[0]."\""; if($member_state == $result_state[0]){echo "selected"; }echo ">".$result_state[0]."</option>\n";

}

echo "</select>";

}

function billing_statelist($member_state = "")
{
	echo "<select name=\"billing_state\" id=\"billing_state\" class=\"form-control\">\n";
echo "<option value=\"\">Select State</option>\n";

$sql_state = "select state from states_master";
$qid_state = db_query($sql_state);
$sql_num_state = db_num_rows($qid_state);

}

function countrylist($country="")
{

echo "<option value=\"\">Select Country</option>\n";
$sql_country= "select country from country_master";
$qid_country = db_query($sql_country);
$sql_num_country = db_num_rows($qid_country);

for($i=0; $i<$sql_num_country; $i++)
{
	$result_country = db_fetch_row($qid_country);
	echo "<option value=\"".$result_country[0]."\" "; if($country == $result_state[0]){echo "selected"; }echo ">".$result_country[0]."</option>\n";

}
}

echo "</select>";

}

function communication_statelist($member_state = "")
{
	echo "<select name=\"communication_state\" id=\"communication_state\" class=\"form-control\">\n";
echo "<option value=\"\">Select State</option>\n";

$sql_state = "select state from states_master";
$qid_state = db_query($sql_state);
$sql_num_state = db_num_rows($qid_state);

}
echo "</select>";
}

function renewal_confirmation_mail($order_no = "")
{

$sql = "select name, company, designation, email, order_date, item_1, cost_1, item_2, cost_2, item_3, cost_3, item_4, cost_4, item_5, cost_5, cgst, sgst, igst, grand_total from orders where order_no = '".$order_no."'";
$qid = db_query($sql);
$result = db_fetch_row($qid);

$name = $result[0];
$company = $result[1];
$designation = $result[2];
$email = $result[3];
$order_date = $result[4];
$item_1 = $result[5];
$cost_1 = $result[6];
$item_2 = $result[7];
$cost_2 = $result[8];
$item_3 = $result[9];
$cost_3 = $result[10];
$item_4 = $result[11];
$cost_4 = $result[12];
$item_5 = $result[13];
$cost_5 = $result[14];
$cgst = $result[15];
$sgst = $result[16];
$igst = $result[17];
$grand_total = $result[18];

$subject = "IMC - Confirmation for transaction #".$order_no;
$msg = "";

$msg .= "Dear ".$name.", ";

$msg .= "We are happy to serve you at IMC Chamber of Commerce and Industry. ";

$msg .= "The details of your transaction are below (please note the transaction no for future reference) ";

$msg .= "Transaction No: ".$order_no." ";
$msg .= "Transaction Date: ".text_date($order_date)." ";
$msg .= "Service Availed: ".$item_1." ";
$msg .= "Total Due: INR ".$grand_total." ";

$msg .= "<table cellpadding=\"8\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"border:1px solid #000; font-size:12px;\"><tr><td>";
$msg .= "Payment Methods (Please ignore if already paid) ";

$msg .= "Online - Click on the link below for payment using credit card/ debit card and net banking ";

$url = generate_online_url($order_no);

$msg .= $url." ";

$msg .= "Cheque - Please make a cheque in the name of 'IMC Chamber of Commerce and Industry' ";
$msg .= "The cheque can be sent to the following address: ";
$msg .= "IMC Bldg., IMC Marg, Churchgate, Mumbai - 400 020 India. Tel : +91-22-71226633 ";
$msg .= "(Please mention the transaction number ".$order_no." at the back of the cheque.) ";

$msg .= "Cash - Payment in cash can also be handed over at the above address. Kindly bring a printout of this acknowledgement mail for reference. ";

$msg .= "</td></tr></table>";

$msg .= " For any issues or clarifications regarding this transaction please email us at info@imcnet.org or call us on +91-22-71226633 ";

$msg .= "Thank you for giving us the opportunity to serve you. ";

$msg .= "Warm Regards, ";
$msg .= "Service Team, ";
$msg .= "IMC Chamber of Commerce and Industry ";

$msg .= "*** This is an auto generated mail and does not require acknowledgement ***";

//echo $msg;

//imc_mail("info@imcnet.org",$subject,$msg,"info@imcnet.org");

/*imc_mail("sanjaymehta@imcnet.org",$subject,$msg,"info@imcnet.org");
imc_mail("chitra.kamath@imcnet.org",$subject,$msg,"info@imcnet.org");
imc_mail("abhijit.vaidya@imcnet.org",$subject,$msg,"info@imcnet.org");
imc_mail("priyanka@imcnet.org",$subject,$msg,"info@imcnet.org");
imc_mail("nitin.bhapkar@imcnet.org",$subject,$msg,"info@imcnet.org");*/

imc_mail($email,$subject,$msg,"info@imcnet.org");

}

//-----------------------
// Quick Months Function
//-----------------------
function quick_months($url)
{

$month = date("m");
$year = date("Y");

$start_year = $year;
$start_month = $month-6;

if ($start_month <= 0) 
{ 
$start_month += 12; 
$start_year = $year - 1; 
}

$month_array = array("","Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec");
$month_array_num = array("","01","02","03","04","05","06","07","08","09","10","11","12");

for ($i=0;$i<=11;$i++)
{
	if ($start_month == $month && $start_year == $year)
	{
	echo "<a href=\"".$url."?start=".$start_year."-".$month_array_num[$start_month]."-01&end=".$start_year."-".$month_array_num[$start_month]."-31\">".$month_array[$start_month]." ".substr($start_year,2,2)."</A> \n";
	}
	else
	{
	echo "<a href=\"".$url."?start=".$start_year."-".$month_array_num[$start_month]."-01&end=".$start_year."-".$month_array_num[$start_month]."-31\">".$month_array[$start_month]." ".substr($start_year,2,2)."</A> \n";
	}

$start_month ++;
	if ($start_month > 12) 
	{ 
	$start_month -= 12;
	$start_year++; 
	}
}

}

function approval_com($mem_committee_id)
{
	$sql = "select name from membership_appr_committe where mem_committee_id = '$mem_committee_id'";
	$qid = db_query($sql);
	$result = db_fetch_row($qid);
	return($result[0]);
}

function user_name($user_id)
{
	$sql = "select name from users where user_id = '$user_id'";
	$qid = db_query($sql);
	$result = db_fetch_row($qid);
	return($result[0]);
}

function membership_type($type_id)
{
	$sql = "select member_type_name from membership_type where member_type_id = '$type_id'";
	$qid = db_query($sql);
	$result = db_fetch_row($qid);
	return($result[0]);
}

function industry($industry_id)
{
	$sql = "select industry from industry_master where sr_no = '$industry_id'";
	$qid = db_query($sql);
	$result = db_fetch_row($qid);
	return($result[0]);
}

//--------------------------------------------------------------------------------------------------------------------
// Function to convert number to words : works only if number if < 999999999
//--------------------------------------------------------------------------------------------------------------------
function convert_number($number) 
{ 
 if (($number > 0) && ($number < 999999999)) 
 { 
 	//throw new Exception("Number is out of range");

$Gn = floor($number / 100000);  /* Millions (giga) */ 
		$number -= $Gn * 100000; 
		$kn = floor($number / 1000);     /* Thousands (kilo) */ 
		$number -= $kn * 1000; 
		$Hn = floor($number / 100);      /* Hundreds (hecto) */ 
		$number -= $Hn * 100; 
		$Dn = floor($number / 10);       /* Tens (deca) */ 
		$n = $number % 10;               /* Ones */ 
	
		$res = ""; 
	
		if ($Gn) 
		{ 
			$res .= convert_number($Gn) . " Lakh"; 
		} 
	
		if ($kn) 
		{ 
			$res .= (empty($res) ? "" : " ") . 
				convert_number($kn) . " Thousand"; 
		} 
	
		if ($Hn) 
		{ 
			$res .= (empty($res) ? "" : " ") . 
				convert_number($Hn) . " Hundred"; 
		} 
	
		$ones = array("", "One", "Two", "Three", "Four", "Five", "Six", 
			"Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", 
			"Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eightteen", 
			"Nineteen"); 
		$tens = array("", "", "Twenty", "Thirty", "Fourty", "Fifty", "Sixty", 
			"Seventy", "Eigthy", "Ninety");

if ($Dn || $n) 
		{ 
			if (!empty($res)) 
			{ 
				$res .= " and "; 
			} 
	
			if ($Dn < 2) 
			{ 
				$res .= $ones[$Dn * 10 + $n]; 
			} 
			else 
			{ 
				$res .= $tens[$Dn]; 
	
				if ($n) 
				{ 
					$res .= "-" . $ones[$n]; 
				} 
			} 
		}

if (empty($res)) 
		{ 
			$res = "zero"; 
		} 
	}
	else
	{
		if($number == 0)
		{
			$res = "zero";
		}
		else
		{
			$res = $number;	
		}
	}
    return $res; 
}