File manager

File manager - Edit - /home/autoph/public_html/connectv1/api/car_club/car_club.php

Back
<?php include_once("../../cfg/db.php"); include_once("../controllers/car_club.php"); include_once("../controllers/brand.php"); include_once("../controllers/model.php"); $car_club = new CarClub(); $brand_class = new Brand(); $model_class = new Model(); $server_method = $_SERVER["REQUEST_METHOD"]; if (isset($_REQUEST['apiKey'])) { $apiKey = $_REQUEST['apiKey']; if ($apiKey === '1548475351132319') { //Get Interest Content $search = isset($_REQUEST['search']) ? $db->escape($_REQUEST['search']) : ''; $car_club->read_car_club_content($search, $db); } else if ($apiKey == '81c753aa8afe11eca54300ff70631b9a') { $request = $_REQUEST; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; $obj = $car_club->read_car_club_autocomplete( $search, $offset, $limit, $db ); $json_arr['rows'] = array(); foreach ($obj as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'id' => $row['id'], 'text' => $row['name'], )) ); } echo json_encode($json_arr); } else if ($apiKey == '4958c8c78b0811eca54300ff70631b9a') { $request = $_REQUEST; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; $obj = $car_club->read_car_club_assigned_person_autocomplete( $search, $offset, $limit, $db ); $json_arr['rows'] = array(); foreach ($obj as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'id' => $row['id'], 'text' => $row['name'], )) ); } echo json_encode($json_arr); } else if ($apiKey == '0e2858e48b1211eca54300ff70631b9a') { $request = $_REQUEST; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; $obj = $car_club->read_car_club_position_autocomplete( $search, $offset, $limit, $db ); $json_arr['rows'] = array(); foreach ($obj as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'id' => $row['id'], 'text' => $row['name'], )) ); } echo json_encode($json_arr); } else if ($apiKey == '8b932f1f8ba111ec9f3e00ff70631b9a') { $request = $_REQUEST; $record_id = $request['id']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape(strtoupper($array_data[$key])); } $array_officers = json_decode($request['officers'], true); // print_r($array_data);exit; //car club name id //get affiliations_content_id exist $car_club_obj = $car_club->read_affiliation_car_club_by_name($array_data['txt_name'], $db); //insert affiliations_content and get id if not exist $car_club_arr = array(); foreach ($car_club_obj as $car_club_row) { $car_club_arr = $car_club_row; } if (count($car_club_arr) <= 0) { $affiliation_car_club_id = $car_club->create_affiliation_car_club($array_data['txt_name'], $db); } else { $affiliation_car_club_id = $car_club_arr['id']; } //assigned name id //get assigned_id if exist $car_club_assigned_obj = $car_club->read_car_club_assigned_by_name($array_data['txt_assigned_person'], $db); //insert affiliations_content and get id if not exist $car_club_assigned_arr = array(); foreach ($car_club_assigned_obj as $car_club_assigned_row) { $car_club_assigned_arr = $car_club_assigned_row; } if (count($car_club_assigned_arr) <= 0) { $car_club_assigned_id = $car_club->create_car_club_assigned($array_data['txt_assigned_person'], $db); } else { $car_club_assigned_id = $car_club_assigned_arr['id']; } if ($utility_class->isNotEmpty($record_id)) { //read update data $array_data['db'] = $db; $array_data['utility_class'] = $utility_class; $array_data['id'] = $record_id; $obj = $car_club->read_car_club($array_data); $car_club_information = array(); foreach ($obj as $row) { $car_club_information = $row; } // print_r($car_club_information);exit; } //check duplicate of car club name id in car_clubs tbl (later) $car_club_main_obj = $car_club->read_car_club_main_by_car_club_name_id($affiliation_car_club_id, $db); //insert affiliations_content and get id if not exist $car_club_main_arr = array(); foreach ($car_club_main_obj as $car_club_main_row) { $car_club_main_arr = $car_club_main_row; } if (!$utility_class->isNotEmpty($record_id)) { if (count($car_club_main_arr) >= 1) { //duplicate $json_arr['id'] = $car_club_main_arr['id']; $json_arr['status'] = 2; //duplicate $json_arr['message'] = 'Duplicate: Car club is already exist.'; echo json_encode($json_arr); exit; } } else { if (count($car_club_main_arr) >= 1 && ($car_club_information['car_club_name_id'] != $car_club_main_arr['car_club_name_id'])) { //duplicate $json_arr['id'] = $car_club_main_arr['id']; $json_arr['status'] = 2; //duplicate $json_arr['message'] = 'Duplicate: Car club is already exist.'; echo json_encode($json_arr); exit; } } //brand and model if ($utility_class->isNotEmpty($array_data['dd_brand']) && !intval($array_data['dd_brand'])) { $brand_id = $brand_class->read_brand_id_by_name_v2($array_data['dd_brand'], $db); if (!$utility_class->isNotEmpty($brand_id)) { $array_data['dd_brand'] = $brand_class->create_brand_v2($array_data['dd_brand'], 0, $db); } else { $array_data['dd_brand'] = $brand_id; } } if ($utility_class->isNotEmpty($array_data['dd_model']) && !intval($array_data['dd_model'])) { $model_id = $model_class->read_model_id_by_name_v2($array_data['dd_brand'], $array_data['dd_model'], $db); if (!$utility_class->isNotEmpty($model_id)) { $array_data['dd_model'] = $model_class->create_model_v2($array_data['dd_brand'], $array_data['dd_model'], 0, $db); } else { $array_data['dd_model'] = $model_id; } } //insert data to car_clubs $require_array_data['car_club_id'] = $record_id; $require_array_data['name_id'] = $affiliation_car_club_id; $require_array_data['facebook_name'] = ""; $require_array_data['brand_id'] = $array_data['dd_brand']; $require_array_data['model_id'] = $array_data['dd_model']; $require_array_data['active_members_count'] = $array_data['txt_active_members_count']; $require_array_data['members_count'] = $array_data['txt_members_count']; $require_array_data['facebook_members_count'] = $array_data['txt_fb_members_count']; $require_array_data['membership_fee'] = $array_data['txt_fee']; $require_array_data['assigned_person'] = $car_club_assigned_id; $user_session = $utility_class->user(); $require_array_data['user_id'] = $user_session['id']; $require_array_data['car_club_status'] = $array_data['dd_club_status']; $require_array_data['status'] = 1; if (!$utility_class->isNotEmpty($record_id)) { $car_club_id = $car_club->create_car_club_main($require_array_data, $utility_class, $db); } else { $car_club_id = $record_id; $car_club->update_car_club_main($require_array_data, $utility_class, $db); } // echo $car_club_id; // $car_club->update_car_club_officers_status($car_club_id,0,$db); $car_club->remove_car_club_officers($car_club_id, $db); //create officers $customer_contact_person_array = array(); if (count($array_officers) > 0) { $array_officers = array_map(array($utility_class, 'upperCaseNestedArray'), $array_officers); $array_officers = array_map(array($db, 'escape'), $array_officers); foreach ($array_officers as $customer_contact_person) { //read position id $position_id = $car_club->read_position_id_by_name($customer_contact_person['Position'], $db); if (!$utility_class->isNotEmpty($position_id)) { $position_id = $car_club->create_position($customer_contact_person['Position'], $db); } //read member id $member_id = $car_club->read_user_id_by_name_mobile($customer_contact_person, $db); if (!$utility_class->isNotEmpty($member_id)) { $member_id = $car_club->create_user($customer_contact_person, $utility_class, $db); } //insert member to car club $car_club_user_array_data['car_club_id'] = $car_club_id; $car_club_user_array_data['car_club_user_id'] = $member_id; $car_club_user_array_data['user_id'] = $user_session['id']; $car_club_user_array_data['member_status'] = 1; $car_club_user_id = $car_club->read_member_id_by_user_id_car_club_id($car_club_user_array_data, $db); if (!$utility_class->isNotEmpty($car_club_user_id)) { $car_club_user_id = $car_club->create_member($car_club_user_array_data, $db); } // $officer_arr['position_id'] = $position_id; // $officer_arr['member_id'] = $member_id; // $officer_arr['car_club_id'] = $car_club_id; // $officer_arr['user_id'] = $user_session['id']; // $officer_arr['db'] = $db; // $officer_arr['utility_class'] = $utility_class; // $officer_id = $car_club->read_car_club_officer_by_member_id_position_id($officer_arr,$db); // if($utility_class->isNotEmpty($officer_id)){ // $car_club->update_car_club_officer_status($officer_id,1,$db); // }else{ $customer_contact_person_array[] = "('$position_id','$member_id','" . $user_session['id'] . "',NOW(),'$car_club_id','1')"; // } } $contact_person_to_insert = implode(',', $customer_contact_person_array); $car_club->create_car_club_officers($contact_person_to_insert, $db); } // exit; $json_arr['status'] = 1; $json_arr['message'] = 'Car club successfully saved.'; echo json_encode($json_arr); } else if ($apiKey == '21f8621b8ed411ecb64500ff70631b9a') { $request = $_REQUEST; $car_club_id = $request['id']; $user_member_id = $request['member_id']; $user_session = $utility_class->user(); $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape(strtoupper($array_data[$key])); } $pass_data['id'] = $user_member_id; $pass_data['Firstname'] = $array_data['txt_member_fname']; $pass_data['Lastname'] = $array_data['txt_member_lname']; $pass_data['Mobile'] = $array_data['txt_member_mobile']; $pass_data['Email'] = ""; if ($utility_class->isNotEmpty($user_member_id)) { $car_club->update_user($pass_data, $utility_class, $db); } else { if ($utility_class->isNotEmpty($array_data['txt_member_mobile'])) { $user_member_id = $car_club->read_user_id_by_name_mobile($pass_data, $db); if (!$utility_class->isNotEmpty($user_member_id)) { $user_member_id = $car_club->create_user($pass_data, $utility_class, $db); } } else { $user_member_id = $car_club->create_user($pass_data, $utility_class, $db); } } //insert member to car club $car_club_user_array_data['car_club_id'] = $car_club_id; $car_club_user_array_data['car_club_user_id'] = $user_member_id; $car_club_user_array_data['user_id'] = $user_session['id']; $car_club_user_array_data['member_status'] = $array_data['dd_member_status']; $car_club_user_id = $car_club->read_member_id_by_user_id_car_club_id($car_club_user_array_data, $db); if (!$utility_class->isNotEmpty($car_club_user_id)) { $car_club_user_id = $car_club->create_member($car_club_user_array_data, $db); } else { $car_club_user_array_data['car_club_member_id'] = $car_club_user_id; $car_club->update_member($car_club_user_array_data, $db); } $json_arr['status'] = 1; $json_arr['message'] = 'Member successfully saved.'; echo json_encode($json_arr); } else if ($apiKey == 'a6fea5ab8d4111ecb31800ff70631b9a') { $request = $_REQUEST; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; $club_status = isset($request['club_status']) ? $db->escape($request['club_status']) : ''; $model_id = isset($request['model_id']) ? $db->escape($request['model_id']) : ''; $brand_id = isset($request['brand_id']) ? $db->escape($request['brand_id']) : ''; // Filter by Category $array_data['db'] = $db; $array_data['utility_class'] = $utility_class; $array_data['search'] = $search; $array_data['offset'] = $offset; $array_data['limit'] = $limit; $array_data['club_status'] = $club_status; $array_data['model_id'] = $model_id; $array_data['brand_id'] = $brand_id; $car_club_list_array = $car_club->read_car_club_list_table($array_data); $json_arr['total'] = $car_club_list_array[0]; $car_club_list_obj = $car_club_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($car_club_list_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $vehicle_type = "ALL"; if ($utility_class->isNotEmpty($row['brand']) && $utility_class->isNotEmpty($row['model'])) { $vehicle_type = $row['brand'] . ' ' . $row['model']; } else if ($utility_class->isNotEmpty($row['brand'])) { $vehicle_type = 'ALL ' . $row['brand']; } $car_club_status = $row['car_club_status'] == '1' ? 'Active' : 'Inactive'; $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'id' => $row['id'], 'name' => $row['name'], 'vehicle' => $vehicle_type, 'president' => $row['president'], 'members_count' => $row['members_count'], 'assigned_person' => $row['assigned_person'], 'club_status' => $car_club_status, )) ); } echo json_encode($json_arr); } else if ($apiKey == '1a122921970c11ec964300ff70631b9a') { $request = $_REQUEST; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; // $club_status = isset($request['club_status']) ? $db->escape($request['club_status']) : '' ; $model_id = isset($request['model_id']) ? $db->escape($request['model_id']) : ''; $brand_id = isset($request['brand_id']) ? $db->escape($request['brand_id']) : ''; // Filter by Category $array_data['db'] = $db; $array_data['utility_class'] = $utility_class; $array_data['search'] = $search; $array_data['offset'] = $offset; $array_data['limit'] = $limit; // $array_data['club_status'] = $club_status; $array_data['model_id'] = $model_id; $array_data['brand_id'] = $brand_id; $car_club_list_array = $car_club->read_car_club_list_affiliation_table($array_data); $json_arr['total'] = $car_club_list_array[0]; $car_club_list_obj = $car_club_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($car_club_list_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $array_data_count['id'] = $row['id']; $array_data_count['db'] = $db; $members_count = $car_club->read_car_club_list_affiliation_members_count($array_data_count); $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'id' => $row['id'], 'name' => $row['name'], // 'vehicle'=>$vehicle_type, // 'president'=>$row['president'], 'members_count' => $members_count, // 'assigned_person'=>$row['assigned_person'], // 'club_status'=>$car_club_status, )) ); } echo json_encode($json_arr); } else if ($apiKey == '5e76998a971511ec964300ff70631b9a') { $request = $_REQUEST; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $id = isset($request['id']) ? $db->escape($request['id']) : ''; $offset = $request['offset']; $limit = $request['limit']; // Filter by Category $array_data['db'] = $db; $array_data['id'] = $id; $array_data['utility_class'] = $utility_class; $array_data['search'] = $search; $array_data['offset'] = $offset; $array_data['limit'] = $limit; $car_club_list_array = $car_club->read_car_club_list_affiliation_members($array_data); $json_arr['total'] = $car_club_list_array[0]; $car_club_list_obj = $car_club_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($car_club_list_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'id' => $row['id'], 'name' => $row['last_name'] . ', ' . $row['first_name'], 'email_1' => $row['email_1'], 'mobile_phone_1' => $row['mobile_phone_1'], 'type' => (intval($row['type']) === 1) ? 'Individual' : 'Corporation' )) ); } echo json_encode($json_arr); } else if ($apiKey == '1e9afe598ee811ecb64500ff70631b9a') { $request = $_REQUEST; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; $car_club_id = $request['car_club_id']; $member_status = $request['member_status']; // Filter by Category $array_data['db'] = $db; $array_data['utility_class'] = $utility_class; $array_data['search'] = $search; $array_data['offset'] = $offset; $array_data['limit'] = $limit; $array_data['id'] = $car_club_id; $array_data['member_status'] = $member_status; $car_club_list_array = $car_club->read_car_club_members_list_table($array_data); $json_arr['total'] = $car_club_list_array[0]; $car_club_list_obj = $car_club_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($car_club_list_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $vehicle_type = "All"; $fullname = $row['firstname'] . ' ' . $row['lastname']; $car_club_member_status = $row['member_status'] == '1' ? 'Active' : 'Inactive'; $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'member_id' => $row['member_id'], 'id' => $row['id'], 'name' => $fullname, 'mobile' => $row['mobilef'], 'date_added' => $row['date_addedf'], 'member_status' => $car_club_member_status, )) ); } echo json_encode($json_arr); } else if ($apiKey == '6eaafd758d6211ecb31800ff70631b9a') { //removing the car club data $request = $_REQUEST; $id = isset($request['id']) ? $db->escape($request['id']) : ''; $array_data['db'] = $db; $array_data['id'] = $id; $array_data['status'] = 0; $car_club->update_car_club_status($array_data); $json_arr['status'] = 1; //duplicate $json_arr['message'] = 'Data successfully removed.'; echo json_encode($json_arr); } else if ($apiKey == 'd50fdb5292b011ecb80c00ff70631b9a') { //removing the car club data $request = $_REQUEST; $array_data['db'] = $db; $json_arr = array(); $obj = $car_club->read_car_club_fields($array_data); foreach ($obj as $row) { $json_arr[$row['id']] = $row; } echo json_encode($json_arr); } else if ($apiKey == 'b70507fa8ef211ecb64500ff70631b9a') { //removing the car club data $request = $_REQUEST; $id = isset($request['id']) ? $db->escape($request['id']) : ''; $array_data['db'] = $db; $array_data['id'] = $id; $array_data['status'] = 0; $array_data['utility_class'] = $utility_class; $obj = $car_club->read_member_data($array_data); $arr = array(); foreach ($obj as $row) { $arr = $row; } echo json_encode($arr); } else if ($apiKey == '2b5e93968ef011ecb64500ff70631b9a') { //removing the car club data $request = $_REQUEST; $id = isset($request['id']) ? $db->escape($request['id']) : ''; $car_club_id = isset($request['car_club_id']) ? $db->escape($request['car_club_id']) : ''; $array_data['db'] = $db; $array_data['id'] = $id; $array_data['status'] = 0; $array_data['utility_class'] = $utility_class; $car_club->update_member_status($array_data); $obj = $car_club->read_member_data($array_data); $arr = array(); foreach ($obj as $row) { $arr = $row; } $array_data['car_club_id'] = $car_club_id; $array_data['officer_status'] = 0; $array_data['user_id'] = $arr['id']; $car_club->update_member_officer_status($array_data); $json_arr['status'] = 1; //duplicate $json_arr['message'] = 'Data successfully removed.'; echo json_encode($json_arr); } else if ($apiKey == '049f14eb971011ec964300ff70631b9a') { //removing the car club data $request = $_REQUEST; $id = isset($request['id']) ? $db->escape($request['id']) : ''; $array_data['db'] = $db; $array_data['id'] = $id; $array_data['status'] = 0; $array_data['utility_class'] = $utility_class; $car_club->update_car_club_affiliation_status($array_data); $json_arr['status'] = 1; //duplicate $json_arr['message'] = 'Data successfully removed.'; echo json_encode($json_arr); } else if ($apiKey == '131f3d32971111ec964300ff70631b9a') { //removing the car club data $request = $_REQUEST; $id = isset($request['id']) ? $db->escape($request['id']) : ''; $name = isset($request['name']) ? $db->escape($request['name']) : ''; $array_data['db'] = $db; $array_data['name'] = $name; $array_data['id'] = $id; $array_data['status'] = 0; $array_data['utility_class'] = $utility_class; $car_club->update_car_club_affiliation_name($array_data); $json_arr['status'] = 1; //duplicate $json_arr['message'] = 'Data successfully updated.'; echo json_encode($json_arr); } else if ($apiKey == 'e3a50dda8d6e11ecb31800ff70631b9a') { // the car club data $request = $_REQUEST; $id = isset($request['id']) ? $db->escape($request['id']) : ''; $array_data['db'] = $db; $array_data['utility_class'] = $utility_class; $array_data['id'] = $id; $obj = $car_club->read_car_club($array_data); $arr_data['information'] = array(); foreach ($obj as $row) { $row = $utility_class->arrayNullToBlank($row); $car_club_status = $row['car_club_status'] == '1' ? 'Active' : 'Inactive'; $arr_data['information'] = array_merge($arr_data['information'], array( 'name' => $row['name'], 'brand' => $utility_class->isNotEmpty($row['brand']) ? $row['brand'] : 'All', 'model' => $utility_class->isNotEmpty($row['model']) ? $row['model'] : 'All', 'fee' => $row['membership_fee'], 'assigned_person' => $row['assigned_person'], 'members_count' => $row['members_count'], 'active_members_count' => $row['active_members_count'], 'fb_members_count' => $row['facebook_members_count'], 'club_status' => $car_club_status, 'name_id' => $row['car_club_name_id'], 'assigned_person_id' => $row['assigned_person_id'], 'car_club_status_id' => $row['car_club_status'], 'brand_id' => $row['brand_id'], 'model_id' => $row['model_id'], )); } $arr_data['officers'] = array(); $obj1 = $car_club->read_car_club_officers($array_data); foreach ($obj1 as $row1) { $row1 = $utility_class->arrayNullToBlank($row1); $arr_data['officers'] = array_merge($arr_data['officers'], array($row1)); } echo json_encode($arr_data); } else { $return_arr["message"] = " You are not allowed to do this action."; echo $return_arr["message"]; return; } } else { $return_arr["message"] = " You are not allowed to do this action."; echo $return_arr["message"]; return; }

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings