OXIESEC PANEL
- Current Dir:
/
/
home
/
u116888525
/
domains
/
aretetesting.in
/
public_html
/
imc_testing
/
cms
Server IP: 82.112.239.19
Upload:
Create Dir:
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: generate_doc.php
Close
<?php session_start(); include('../admin/dblib.php'); include('../admin/func_lib.php'); include('cms_functions.php'); $getar = $_GET; $getkeys = array_keys($getar); for($i=0; $i<count($getkeys); $i++){ $k = $getkeys[$i]; $v = $getar[$k]; ${$k}=cleanQuery($v); } $getar = $_POST; $getkeys = array_keys($getar); for($i=0; $i<count($getkeys); $i++){ $k = $getkeys[$i]; $v = $getar[$k]; ${$k}=cleanQuery($v); } $user_session = $_SESSION["user_session"]; if ($user_session != "") { if($action == "label_doc"){ $filename = "Labels_".date("d-m-Y h-i-s").".doc"; header("Content-type:application/msword"); header("Content-Disposition: attachment;filename=\"$filename\""); if ($status == "confirmed") { $sql_memeber_details = "select ceo_name, designation, member_name, member_address, address_1, address_2, address_3, member_city, member_state, member_pincode, ceo_telephone, membership_no, post_date, salutation, valid_upto from membership_reg where status = 'active' and membership_category = 'IMC' and valid_upto >= '2023-03-31'"; } elseif ($status == "renewal_pending") { $sql_memeber_details = "select ceo_name, designation, member_name, member_address, address_1, address_2, address_3, member_city, member_state, member_pincode, ceo_telephone, membership_no, post_date, salutation, valid_upto from membership_reg where (status != 'resigned' and status != 'lapsed' and status != 'inactive' and status != 'cancelled') and membership_category = 'IMC' and valid_upto < '2023-03-31'"; } elseif ($status != "") { if($status =='active'){ $sql_memeber_details = "select ceo_name, designation, member_name, member_address, address_1, address_2, address_3, member_city, member_state, member_pincode, ceo_telephone, membership_no, post_date, salutation, valid_upto from membership_reg where membership_category = 'IMC' and (status = '".$status."' OR status = 'active renewal')"; }else{ $sql_memeber_details = "select ceo_name, designation, member_name, member_address, address_1, address_2, address_3, member_city, member_state, member_pincode, ceo_telephone, membership_no, post_date, salutation, valid_upto from membership_reg where status = '".$status."' and membership_category = 'IMC'"; } } else { $sql_memeber_details = "select ceo_name, designation, member_name, member_address, address_1, address_2, address_3, member_city, member_state, member_pincode, ceo_telephone, membership_no, post_date, salutation, valid_upto from membership_reg where status = 'active' and membership_category = 'IMC'"; } if ($membership_no !="") { $key_array = explode(",",$membership_no); for ($k=0;$k<=sizeof($key_array)-1;$k++) { if($k==0){$sql_memeber_details .= " and (membership_no = '".$key_array[$k]."') ";} else{ $sql_memeber_details .= " or (membership_no = '".$key_array[$k]."') ";} } } if($mem_cat >0) { $sql_memeber_details .= " and member_type_id = '".$mem_cat."'"; } $sql_memeber_details .=" order by post_date desc"; $qid_member_details = db_query($sql_memeber_details); $sql_num_member_details = db_num_rows($qid_member_details); echo "<table cellpadding=\"5\" cellspacing=\"0\" border=\"1\" width=\"100%\" style=\"font-family:Calibri; font-size:12px; text-transform:uppercase\">\n"; echo "<tr>"; for($i=1; $i<=$sql_num_member_details; $i++){ $result_member_details = db_fetch_object($qid_member_details); echo "<td width=\"30%\" valign=\"top\">\n"; echo "<div style=\"padding:2px 15px; width:270px; height:230px; display:table-cell; vertical-align:middle; text-transform:uppercase\">\n"; echo "".$result_member_details->salutation." ".$result_member_details->ceo_name."<br/>".$result_member_details->designation."<b><br/>".$result_member_details->member_name."</b><br/>"; if ($result_member_details->address_1 != "") { echo $result_member_details->address_1.", "; } if ($result_member_details->address_2 != "") { echo $result_member_details->address_2.", "; } if ($result_member_details->address_3 != "") { echo $result_member_details->address_3.", "; } echo "<br/>".$result_member_details->member_city." - ".$result_member_details->member_pincode."<br/>"; if($result_member_details->ceo_telephone != ""){ echo "Telephone : ".$result_member_details->ceo_telephone."<br/>"; } echo "<b>Membership No : ".$result_member_details->membership_no."</b>"; echo "</div>\n"; echo "</td>\n"; if ($i%3==0) { echo "</tr>\n"; } if ($i%18==0) { echo "</table>\n"; echo "<br style=\"page-break-before: always\">"; //echo "<p style=\"page-break-before: always;\"></p>\n"; echo "<table cellpadding=\"5\" cellspacing=\"0\" border=\"1\" width=\"100%\" style=\"font-family:Calibri; font-size:12px; \"><tr>\n"; } } echo "</tr>\n"; echo "</table>\n"; } if($action=="member_app"){ $filename = "MEMBERSHIP_APPLICATIONS_".date("d-m-Y h-i-s").".doc"; header("Content-type:application/msword"); header("Content-Disposition: attachment;filename=\"$filename\""); $sql_app = "select member_name, member_type_id, region, member_id, proposer_name, seconder_name, member_address, address_1, address_2, address_3, member_city, member_state, member_pincode, ceo_name, ceo_telephone, ceo_mobile, member_telephone, salutation, designation from membership_reg where membership_category = 'IMC' and status = 'waiting' order by sr_no desc"; $qid_app = db_query($sql_app); $sql_num_app = db_num_rows($qid_app); $sql_app_id = "select mem_committee_id from membership_appr_committe where hashtag = '".$code."'"; $qid_app_id = db_query($sql_app_id); $result_app_id = db_fetch_row($qid_app_id); echo "<h4 style=\"text-transform:uppercase; border:2px solid #000; padding:10px 0; width:50%; margin:0 auto; text-align:center; font-family:Calibri; font-size:12.5px; margin-top:15px;\"> Membership Applications</h4>\n"; echo "<p style=\"margin-top:25px; font-family:Calibri; font-size:15px; margin-top:15px;\" align=\"left\">The Membership Scrutinizing Committee has scrutinized and approved the following ".$sql_num_app." (".number_to_word($sql_num_app).") applications for membership. The same may be noted.</p><br/><br/><br/>"; echo "<p align=\"right\" style=\"font-weight:600; font-family:Calibri; font-size:12.5px;\">Sanjay Mehta<br/>Deputy Director General</p>"; echo "<h4 style=\"text-transform:uppercase; text-align:center; font-family:Calibri; font-size:15px;\"> Applications for Membership ".date('M')." ".date('Y')."</h4>\n"; echo "<div class=\"table-responsive padt10\">\n"; echo " <table width=\"100%\" cellspacing=\"0\" border='1' cellpadding='1' bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px; \">\n"; echo "<thead>\n"; echo "<tr align=\"center\">\n"; echo "<th>Sr No</th>\n"; echo "<th>Application Details</th>\n"; echo "<th>Category</th>\n"; echo "<th>Business Interest</th>\n"; echo "<th>Proposer & Seconder</th>\n"; echo "</tr>\n"; echo " </thead>\n"; echo " <tbody>"; for($i=1; $i<=$sql_num_app; $i++){ $result_app = db_fetch_object($qid_app); if($result_app->region == 'out'){$region = 'MOFUSSIL';} else{$region = 'LOCAL';} $sql_mnot = "select member_id from accepted_applications where mem_committee_id = '".$result_app_id[0]."' and member_id = '".$result_app->member_id."'"; $qid_mnot = db_query($sql_mnot); $sql_num_mnot= db_num_rows($qid_mnot); if($sql_num_mnot == 0){ $sql_contact = "select person_name, designation, address, telephone, mobile from member_contacts where member_id = '".$result_app->member_id."' and status = 'active'"; $qid_contact = db_query($sql_contact); $result_contact = db_fetch_row($qid_contact); $sql_manufacturing = "select manufacturing, trading, services, man_size, man_products, trade_type, trade_dom_products, trade_exp_countries, trade_exp_products, trade_imp_countries, trade_imp_products, services_list, services_other from member_business_type where member_id = '".$result_app->member_id."'"; $qid_manufacturing = db_query($sql_manufacturing); $result_manufacturing = db_fetch_object($qid_manufacturing); echo "<tr valign=\"top\">\n"; echo "<td style=\"padding:2px 10px\">".($i)."</td>\n"; echo "<td width=\"30%\" style=\"text-transform:uppercase; padding:2px 10px\" valign=\"top\"><b>".$result_app->member_name."</b><br/>".$result_app->salutation." ".$result_app->ceo_name."<br/>".$result_app->designation."<br/>"; if ($result_app->address_1 != "") { echo $result_app->address_1.", "; } if ($result_app->address_2 != "") { echo $result_app->address_2.", "; } if ($result_app->address_3 != "") { echo $result_app->address_3.", "; } echo "<br/>".$result_app->member_city." - ".$result_app->member_pincode."<br/>TEL : ".$result_app->member_telephone."</td>\n"; echo "<td width=\"20%\" style=\"padding:2px 10px\">".membership_type($result_app->member_type_id)."<br/>(".$region.")</td>\n"; echo "<td width=\"25%\" style=\"padding:2px 10px\">"; /* $sql_business = "select parameter_1, parameter_2, parameter_3, parameter_4, parameter_5 from member_buisness_details where member_id = '".$result_app->member_id."' and status = 'active'"; $qid_business = db_query($sql_business); $sql_num_business_details = db_num_rows($qid_business); if($sql_num_business_details > 0){ for($j=0; $j<$sql_num_business_details; $j++) { $result_business = db_fetch_row($qid_business); if($result_business[0] != ""){echo "(".($j+1).") Sector : ".$result_business[0]."<br/>";} if($result_business[1] != ""){echo "Industry Group : ".$result_business[1]."<br/>";} if($result_business[2] != ""){echo "Industry : ".$result_business[2]."<br/>";} if($result_business[3] != ""){echo "Sub Industry : ".$result_business[3]."<br/><br/>";} } } */ if($result_manufacturing->manufacturing > 0){ //echo "Manufacturing : ".$result_manufacturing->man_size." echo "Manufacturer of : <br/>".strtoupper($result_manufacturing->man_products)."<br/><br/>"; } if($result_manufacturing->trading > 0){ if($result_manufacturing->trade_dom_products != ""){ echo "Trader of : <br/> ".strtoupper($result_manufacturing->trade_dom_products)."<br/><br/>"; } if($result_manufacturing->trade_exp_products != ""){ echo "Exporter of : <br/> ".strtoupper($result_manufacturing->trade_exp_products)."";} if($result_manufacturing->trade_exp_countries != ""){ $exp_countries = explode(",",$result_manufacturing->trade_exp_countries); $exp_c_length = sizeof($exp_countries); echo "<br/><br/>Exporting "; if($exp_c_length > 1){ echo "Countries";} else{echo "Country";} echo " : <br/>".strtoupper($result_manufacturing->trade_exp_countries)."<br/><br/>";} if($result_manufacturing->trade_imp_products != ""){ echo "Importer of :<br/> ".strtoupper($result_manufacturing->trade_imp_products)."<br/><br/>";} if($result_manufacturing->trade_imp_countries != ""){ $imp_countries = explode(",",$result_manufacturing->trade_imp_countries); $imp_c_length = sizeof($imp_countries); echo "Importing "; if($imp_c_length > 1){ echo "Countries";} else{echo "Country";} echo " :<br/> ".strtoupper($result_manufacturing->trade_imp_countries)."";} } if($result_manufacturing->services > 0){ if($result_manufacturing->services_list != ""){ echo "Services of : <br/> ".strtoupper($result_manufacturing->services_list)."<br/>"; } if($result_manufacturing->services_other != ""){ echo "Services of : <br/> ".strtoupper($result_manufacturing->services_other)."";} } echo "</td>\n"; echo "<td width=\"25%\" style=\"padding:2px 10px\"> "; if($result_app->proposer_name != ""){ echo "1: ".$result_app->proposer_name."<br/>";} if($result_app->seconder_name != ""){ echo "2: ".$result_app->seconder_name."";} echo "</td>\n"; echo "</tr>"; } if ($i%3==0) { echo "</table>\n"; echo "<br style=\"page-break-before: always\">"; //echo "<p style=\"page-break-before: always;\"></p>\n"; echo " <table width=\"100%\" cellspacing=\"0\" border='1' cellpadding='1' bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px; \">\n"; } } echo "</tbody>\n"; echo "</table>\n"; echo "</div>\n"; //echo "<p style=\"page-break-before: always;\"></p>\n"; echo "<pre><br clear=all style='mso-special-character:line-break;page-break-before:always'></pre>"; /****************************** Resignation from Membership ******************/ $sql_resign = "select * from additional_requests where status = 'preapproved' and request_type = 'resign'"; $qid_resign = db_query($sql_resign); $sql_num_resign = db_num_rows($qid_resign); if($sql_num_resign >0){ echo "<h4 style=\"text-transform:uppercase; text-decoration:underline; padding:10px 0; width:80%; margin:0 auto; padding-top:50px; text-align:center; font-family:Calibri; font-size:12.5px; margin-top:15px;\"> RESIGNATION FROM MEMBERSHIP OF THE CHAMBER</h4>\n"; echo "<p style=\"margin-top:15px; font-family:Calibri; font-size:12.5px; margin-top:15px;\">The Membership Scrutinizing Committee has approved the following resignations from membership of the Chamber. The same may be noted.</p>"; echo "<div class=\"table-responsive padt10\">\n"; echo " <table width=\"100%\" cellspacing=\"0\" border='1' cellpadding='10' bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px;\">\n"; echo "<thead>\n"; echo "<tr align=\"center\">\n"; echo "<th>Sr No</th>\n"; echo "<th>Name</th>\n"; echo "<th>Category</th>\n"; echo "<th>Representative</th>\n"; echo "<th>Membership No</th>\n"; echo "<th>Reason</th>\n"; echo "</tr>\n"; echo " </thead>\n"; echo " <tbody>"; for($i=0; $i<$sql_num_resign; $i++) { $result_resign = db_fetch_object($qid_resign); $sql_member = "select * from membership_reg where member_id = '".$result_resign->member_id."'"; $qid_member = db_query($sql_member); $result_member= db_fetch_object($qid_member); echo "<tr>"; echo "<td>".($i+1)."</td>\n"; echo "<td width=\"30%\"><b>".$result_member->member_name."</b><br/>"; if ($result_member->address_1 != "") { echo $result_member->address_1.", "; } if ($result_member->address_2 != "") { echo $result_member->address_2.", "; } if ($result_member->address_3 != "") { echo $result_member->address_3.", "; } echo "<br/>".$result_member->member_city." - ".$result_member->member_pincode."<br/>TEL : ".$result_member->member_telephone."</td>"; if($result_member->region == 'out'){$region = 'MOFUSSIL';} else{$region = 'LOCAL';} echo "<td>".membership_type($result_member->member_type_id)."<br/>(".$region.")</td>\n"; echo "<td>".$result_member->ceo_name."<br/>".$result_member->designation."</td>"; echo "<td align=\"center\">".$result_member->membership_no."</td>"; echo "<td width=\"40%\">".$result_resign->resignation_reason."</td>"; echo "</tr>"; } echo "</tbody>"; echo "</table>"; echo "</div>"; } echo "<br style=\"page-break-before: always\">"; // echo "<p style=\"page-break-before: always;\"></p>\n"; //echo "<pre><br clear=all style='mso-special-character:line-break;page-break-before:always'></pre>"; /*************************** Change in Name/ Classification ************************/ $sql_resign = "select * from additional_requests where status = 'preapproved' and request_type = 'change_name'"; $qid_resign = db_query($sql_resign); $sql_num_resign = db_num_rows($qid_resign); if($sql_num_resign >0){ echo "<h4 style=\"text-transform:uppercase; text-decoration:underline; padding:10px 0; width:80%; margin:0 auto; padding-top:50px; text-align:center; font-family:Calibri; font-size:12.5px; margin-top:15px;\"> REQUEST FOR CHANGE IN NAME / CLASSIFICATION</h4>\n"; echo "<p style=\"margin-top:15px; font-family: arial; font-size:12.5px; margin-top:15px;\">The Membership Scrutinizing Committee has approved the following Change in Name. The same may be noted.</p>"; echo "<p class=\"padt20\"><b><u>CHANGE IN NAME</u></b></p>"; echo "<table width=100% border='1' cellspacing=0 cellpadding=10 bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px;\">"; for($i=0; $i<$sql_num_resign; $i++) { $result_resign = db_fetch_object($qid_resign); echo "<tr>"; echo "<td>From : </td><td>".$result_resign->old_name."</td>"; echo "</tr>"; echo "<tr>"; echo "<td>To : </td><td>".$result_resign->new_name."</td>"; echo "</tr>"; } echo "</table>"; } /*************************** Change in Name/ Classification ************************/ $sql_resign = "select * from additional_requests where status = 'preapproved' and request_type = 'change_classification'"; $qid_resign = db_query($sql_resign); $sql_num_resign = db_num_rows($qid_resign); if($sql_num_resign >0){ echo "<p class=\"padt20\"><b><u>CHANGE IN CLASSIFICATION</u></b></p>"; echo "<table width=100% border='1' cellspacing=0 cellpadding=10 bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px;\">"; for($i=0; $i<$sql_num_resign; $i++) { $result_resign = db_fetch_object($qid_resign); echo "<tr>"; echo "<td>From : </td><td>".$result_resign->old_name."</td>"; echo "</tr>"; echo "<tr>"; echo "<td>To : </td><td>".$result_resign->new_name."</td>"; echo "</tr>"; } echo "</table>"; } } //****** Member Pre approval**********/ if($action=="member_pre_app"){ $filename = "MEMBERSHIP_APPLICATIONS_".date("d-m-Y h-i-s").".doc"; header("Content-type:application/msword"); header("Content-Disposition: attachment;filename=\"$filename\""); $sql_app = "select member_name, member_type_id, region, member_id, proposer_name, seconder_name, member_address, address_1, address_2, address_3, member_city, member_state, member_pincode, ceo_name, ceo_telephone, ceo_mobile, member_telephone, salutation, designation from membership_reg where membership_category = 'IMC' and status = 'preapproval' order by sr_no desc"; $qid_app = db_query($sql_app); $sql_num_app = db_num_rows($qid_app); $sql_app_id = "select mem_committee_id from membership_appr_committe where hashtag = '".$code."'"; $qid_app_id = db_query($sql_app_id); $result_app_id = db_fetch_row($qid_app_id); echo "<h4 style=\"text-transform:uppercase; border:2px solid #000; padding:10px 0; width:50%; margin:0 auto; text-align:center; font-family:Calibri; font-size:12.5px; margin-top:15px;\"> Membership Applications</h4>\n"; echo "<p style=\"margin-top:25px; font-family:Calibri; font-size:15px; margin-top:15px;\" align=\"left\">The Membership Scrutinizing Committee has scrutinized and approved the following ".$sql_num_app." (".number_to_word($sql_num_app).") applications for membership. The same may be noted.</p><br/><br/><br/>"; echo "<p align=\"right\" style=\"font-weight:600; font-family:Calibri; font-size:12.5px;\">Sanjay Mehta<br/>Deputy Director General</p>"; echo "<h4 style=\"text-transform:uppercase; text-align:center; font-family:Calibri; font-size:15px;\"> Applications for Membership ".date('M')." ".date('Y')."</h4>\n"; echo "<div class=\"table-responsive padt10\">\n"; echo " <table width=\"100%\" cellspacing=\"0\" border='1' cellpadding='1' bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px; \">\n"; echo "<thead>\n"; echo "<tr align=\"center\">\n"; echo "<th>Sr No</th>\n"; echo "<th>Application Details</th>\n"; echo "<th>Category</th>\n"; echo "<th>Business Interest</th>\n"; echo "<th>Proposer & Seconder</th>\n"; echo "</tr>\n"; echo " </thead>\n"; echo " <tbody>"; for($i=1; $i<=$sql_num_app; $i++){ $result_app = db_fetch_object($qid_app); if($result_app->region == 'out'){$region = 'MOFUSSIL';} else{$region = 'LOCAL';} $sql_mnot = "select member_id from accepted_applications where mem_committee_id = '".$result_app_id[0]."' and member_id = '".$result_app->member_id."'"; $qid_mnot = db_query($sql_mnot); $sql_num_mnot= db_num_rows($qid_mnot); if($sql_num_mnot == 0){ $sql_contact = "select person_name, designation, address, telephone, mobile from member_contacts where member_id = '".$result_app->member_id."' and status = 'active'"; $qid_contact = db_query($sql_contact); $result_contact = db_fetch_row($qid_contact); $sql_manufacturing = "select manufacturing, trading, services, man_size, man_products, trade_type, trade_dom_products, trade_exp_countries, trade_exp_products, trade_imp_countries, trade_imp_products, services_list, services_other from member_business_type where member_id = '".$result_app->member_id."'"; $qid_manufacturing = db_query($sql_manufacturing); $result_manufacturing = db_fetch_object($qid_manufacturing); echo "<tr valign=\"top\">\n"; echo "<td style=\"padding:2px 10px\">".($i)."</td>\n"; echo "<td width=\"30%\" style=\"text-transform:uppercase; padding:2px 10px\" valign=\"top\"><b>".$result_app->member_name."</b><br/>".$result_app->salutation." ".$result_app->ceo_name."<br/>".$result_app->designation."<br/>"; if ($result_app->address_1 != "") { echo $result_app->address_1.", "; } if ($result_app->address_2 != "") { echo $result_app->address_2.", "; } if ($result_app->address_3 != "") { echo $result_app->address_3.", "; } echo "<br/>".$result_app->member_city." - ".$result_app->member_pincode."<br/>TEL : ".$result_app->member_telephone."</td>\n"; echo "<td width=\"20%\" style=\"padding:2px 10px\">".membership_type($result_app->member_type_id)."<br/>(".$region.")</td>\n"; echo "<td width=\"25%\" style=\"padding:2px 10px\">"; /* $sql_business = "select parameter_1, parameter_2, parameter_3, parameter_4, parameter_5 from member_buisness_details where member_id = '".$result_app->member_id."' and status = 'active'"; $qid_business = db_query($sql_business); $sql_num_business_details = db_num_rows($qid_business); if($sql_num_business_details > 0){ for($j=0; $j<$sql_num_business_details; $j++) { $result_business = db_fetch_row($qid_business); if($result_business[0] != ""){echo "(".($j+1).") Sector : ".$result_business[0]."<br/>";} if($result_business[1] != ""){echo "Industry Group : ".$result_business[1]."<br/>";} if($result_business[2] != ""){echo "Industry : ".$result_business[2]."<br/>";} if($result_business[3] != ""){echo "Sub Industry : ".$result_business[3]."<br/><br/>";} } } */ if($result_manufacturing->manufacturing > 0){ //echo "Manufacturing : ".$result_manufacturing->man_size." echo "Manufacturer of : <br/>".strtoupper($result_manufacturing->man_products)."<br/><br/>"; } if($result_manufacturing->trading > 0){ if($result_manufacturing->trade_dom_products != ""){ echo "Trader of : <br/> ".strtoupper($result_manufacturing->trade_dom_products)."<br/><br/>"; } if($result_manufacturing->trade_exp_products != ""){ echo "Exporter of : <br/> ".strtoupper($result_manufacturing->trade_exp_products)."";} if($result_manufacturing->trade_exp_countries != ""){ $exp_countries = explode(",",$result_manufacturing->trade_exp_countries); $exp_c_length = sizeof($exp_countries); echo "<br/><br/>Exporting "; if($exp_c_length > 1){ echo "Countries";} else{echo "Country";} echo " : <br/>".strtoupper($result_manufacturing->trade_exp_countries)."<br/><br/>";} if($result_manufacturing->trade_imp_products != ""){ echo "Importer of :<br/> ".strtoupper($result_manufacturing->trade_imp_products)."<br/><br/>";} if($result_manufacturing->trade_imp_countries != ""){ $imp_countries = explode(",",$result_manufacturing->trade_imp_countries); $imp_c_length = sizeof($imp_countries); echo "Importing "; if($imp_c_length > 1){ echo "Countries";} else{echo "Country";} echo " :<br/> ".strtoupper($result_manufacturing->trade_imp_countries)."";} } if($result_manufacturing->services > 0){ if($result_manufacturing->services_list != ""){ echo "Services of : <br/> ".strtoupper($result_manufacturing->services_list)."<br/>"; } if($result_manufacturing->services_other != ""){ echo "Services of : <br/> ".strtoupper($result_manufacturing->services_other)."";} } echo "</td>\n"; echo "<td width=\"25%\" style=\"padding:2px 10px\"> "; if($result_app->proposer_name != ""){ echo "1: ".$result_app->proposer_name."<br/>";} if($result_app->seconder_name != ""){ echo "2: ".$result_app->seconder_name."";} echo "</td>\n"; echo "</tr>"; } if ($i%3==0) { echo "</table>\n"; echo "<br style=\"page-break-before: always\">"; //echo "<p style=\"page-break-before: always;\"></p>\n"; echo " <table width=\"100%\" cellspacing=\"0\" border='1' cellpadding='1' bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px; \">\n"; } } echo "</tbody>\n"; echo "</table>\n"; echo "</div>\n"; //echo "<p style=\"page-break-before: always;\"></p>\n"; echo "<pre><br clear=all style='mso-special-character:line-break;page-break-before:always'></pre>"; /****************************** Resignation from Membership ******************/ $sql_resign = "select * from additional_requests where status = 'pending' and request_type = 'resign'"; $qid_resign = db_query($sql_resign); $sql_num_resign = db_num_rows($qid_resign); if($sql_num_resign >0){ echo "<h4 style=\"text-transform:uppercase; text-decoration:underline; padding:10px 0; width:80%; margin:0 auto; padding-top:50px; text-align:center; font-family:Calibri; font-size:12.5px; margin-top:15px;\"> RESIGNATION FROM MEMBERSHIP OF THE CHAMBER</h4>\n"; echo "<p style=\"margin-top:15px; font-family:Calibri; font-size:12.5px; margin-top:15px;\">The Membership Scrutinizing Committee has approved the following resignations from membership of the Chamber. The same may be noted.</p>"; echo "<div class=\"table-responsive padt10\">\n"; echo " <table width=\"100%\" cellspacing=\"0\" border='1' cellpadding='10' bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px;\">\n"; echo "<thead>\n"; echo "<tr align=\"center\">\n"; echo "<th>Sr No</th>\n"; echo "<th>Name</th>\n"; echo "<th>Category</th>\n"; echo "<th>Representative</th>\n"; echo "<th>Membership No</th>\n"; echo "<th>Reason</th>\n"; echo "</tr>\n"; echo " </thead>\n"; echo " <tbody>"; for($i=0; $i<$sql_num_resign; $i++) { $result_resign = db_fetch_object($qid_resign); $sql_member = "select * from membership_reg where member_id = '".$result_resign->member_id."'"; $qid_member = db_query($sql_member); $result_member= db_fetch_object($qid_member); echo "<tr>"; echo "<td>".($i+1)."</td>\n"; echo "<td width=\"30%\"><b>".$result_member->member_name."</b><br/>"; if ($result_member->address_1 != "") { echo $result_member->address_1.", "; } if ($result_member->address_2 != "") { echo $result_member->address_2.", "; } if ($result_member->address_3 != "") { echo $result_member->address_3.", "; } echo "<br/>".$result_member->member_city." - ".$result_member->member_pincode."<br/>TEL : ".$result_member->member_telephone."</td>"; if($result_member->region == 'out'){$region = 'MOFUSSIL';} else{$region = 'LOCAL';} echo "<td>".membership_type($result_member->member_type_id)."<br/>(".$region.")</td>\n"; echo "<td>".$result_member->ceo_name."<br/>".$result_member->designation."</td>"; echo "<td align=\"center\">".$result_member->membership_no."</td>"; echo "<td width=\"40%\">".$result_resign->resignation_reason."</td>"; echo "</tr>"; } echo "</tbody>"; echo "</table>"; echo "</div>"; } echo "<br style=\"page-break-before: always\">"; // echo "<p style=\"page-break-before: always;\"></p>\n"; //echo "<pre><br clear=all style='mso-special-character:line-break;page-break-before:always'></pre>"; /*************************** Change in Name/ Classification ************************/ $sql_resign = "select * from additional_requests where status = 'pending' and request_type = 'change_name'"; $qid_resign = db_query($sql_resign); $sql_num_resign = db_num_rows($qid_resign); if($sql_num_resign >0){ echo "<h4 style=\"text-transform:uppercase; text-decoration:underline; padding:10px 0; width:80%; margin:0 auto; padding-top:50px; text-align:center; font-family:Calibri; font-size:12.5px; margin-top:15px;\"> REQUEST FOR CHANGE IN NAME / CLASSIFICATION</h4>\n"; echo "<p style=\"margin-top:15px; font-family: arial; font-size:12.5px; margin-top:15px;\">The Membership Scrutinizing Committee has approved the following Change in Name. The same may be noted.</p>"; echo "<p class=\"padt20\"><b><u>CHANGE IN NAME</u></b></p>"; echo "<table width=100% border='1' cellspacing=0 cellpadding=10 bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px;\">"; for($i=0; $i<$sql_num_resign; $i++) { $result_resign = db_fetch_object($qid_resign); echo "<tr>"; echo "<td>From : </td><td>".$result_resign->old_name."</td>"; echo "</tr>"; echo "<tr>"; echo "<td>To : </td><td>".$result_resign->new_name."</td>"; echo "</tr>"; } echo "</table>"; } /*************************** Change in Name/ Classification ************************/ $sql_resign = "select * from additional_requests where status = 'pending' and request_type = 'change_classification'"; $qid_resign = db_query($sql_resign); $sql_num_resign = db_num_rows($qid_resign); if($sql_num_resign >0){ echo "<p class=\"padt20\"><b><u>CHANGE IN CLASSIFICATION</u></b></p>"; echo "<table width=100% border='1' cellspacing=0 cellpadding=10 bordercolor=\"#CCCCCC\" style=\"font-family:Calibri; font-size:12.5px;\">"; for($i=0; $i<$sql_num_resign; $i++) { $result_resign = db_fetch_object($qid_resign); echo "<tr>"; echo "<td>From : </td><td>".$result_resign->old_name."</td>"; echo "</tr>"; echo "<tr>"; echo "<td>To : </td><td>".$result_resign->new_name."</td>"; echo "</tr>"; } echo "</table>"; } } } ?>