File manager

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

Back
<?php class CarClub { function read_car_club_content($search, $db) { $car_clubs = $db->return_result("SELECT id,name FROM `source_car_clubs` WHERE status=1 AND `name` LIKE '%$search%' ORDER BY name ASC LIMIT 10"); $json = []; foreach ($car_clubs as $car_club) { $json[] = ['id' => $car_club['name'], 'text' => $car_club['name']]; } echo json_encode($json); } function read_car_club_id_by_name($name, $db) { return $db->select("SELECT id FROM `source_car_clubs` WHERE status=1 AND `name` = '$name' "); } function create_car_club($name, $db) { return $db->sql_query_id("INSERT INTO source_car_clubs (name,date_added,status) VALUES ('$name',NOW(),'1')"); } function read_car_club_id_by_car_club_name_id($car_club_name_id, $db) { $query = "SELECT id FROM `car_clubs` WHERE 1 AND `car_club_name_id` = $car_club_name_id AND `status` = 1 LIMIT 1"; return $db->select($query); } function read_car_club_autocomplete( $search, $offset, $limit, $db ) { $offset_limit = "LIMIT " . $offset . "," . $limit . " "; $field = " * "; $query = "SELECT %s FROM `customer_affiliations_content` WHERE 1 AND name LIKE '%%%s%%' AND `affiliation_id` = 5 /car clubs id/ AND status = 1 %s "; $query_formatted = sprintf( $query, $field, $search, $offset_limit ); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_car_club_assigned_person_autocomplete( $search, $offset, $limit, $db ) { $offset_limit = "LIMIT " . $offset . "," . $limit . " "; $field = " * "; $query = "SELECT %s FROM `car_club_assigned_persons` WHERE 1 AND name LIKE '%%%s%%' AND status = 1 %s"; $query_formatted = sprintf( $query, $field, $search, $offset_limit ); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_car_club_position_autocomplete( $search, $offset, $limit, $db ) { $offset_limit = "LIMIT " . $offset . "," . $limit . " "; $field = " * "; $query = "SELECT %s FROM `car_club_positions` WHERE 1 AND name LIKE '%%%s%%' AND status = 1 %s"; $query_formatted = sprintf( $query, $field, $search, $offset_limit ); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_affiliation_car_club_by_name($name, $db) { $query = "SELECT * FROM `customer_affiliations_content` WHERE 1 AND affiliation_id = 5 AND name = '$name' LIMIT 1"; return $db->sql_query($query); } function create_affiliation_car_club($name, $db) { $affiliation_id = 5; $query = "INSERT INTO `customer_affiliations_content`( `affiliation_id`, `name`, `status`) VALUES ('$affiliation_id','$name','1')"; return $db->sql_query_id($query); } function car_club_universal_query() { return "SELECT %s FROM `car_clubs` cc LEFT OUTER JOIN employee e ON cc.user_id = e.id LEFT OUTER JOIN source_brand sb ON cc.brand_id=sb.id LEFT OUTER JOIN source_car_model scm ON cc.model_id=scm.id LEFT OUTER JOIN customer_affiliations_content cac ON cc.car_club_name_id = cac.id LEFT OUTER JOIN car_club_assigned_persons ccap ON cc.assigned_person = ccap.id LEFT OUTER JOIN car_club_users ccu ON ccu.id = (SELECT ccus.id FROM car_club_officers ccos LEFT OUTER JOIN car_club_positions ccp ON ccos.position_id = ccp.id LEFT OUTER JOIN car_club_users ccus ON ccos.member_id = ccus.id WHERE 1 AND ccp.name IN ('president','pres','pres.') AND cc.status = 1 AND ccos.status = 1 AND ccus.status = 1 AND ccos.car_club_id = cc.id LIMIT 1) WHERE 1 "; } function create_car_club_main($array_data, $utility_class, $db) { $car_club_name_id = $array_data['name_id']; $facebook_name = $array_data['facebook_name']; $brand_id = $array_data['brand_id']; $model_id = $array_data['model_id']; $active_members_count = $array_data['active_members_count']; $members_count = $array_data['members_count']; $facebook_members_count = $array_data['facebook_members_count']; $membership_fee = $array_data['membership_fee']; $assigned_person = $array_data['assigned_person']; $user_id = $array_data['user_id']; $car_club_status = $array_data['car_club_status']; $status = $array_data['status']; $query = "INSERT INTO `car_clubs`(`car_club_name_id`, `facebook_name`, `brand_id`, `model_id`, `active_members_count`, `members_count`, `facebook_members_count`, `membership_fee`, `assigned_person`, `user_id`, `car_club_status`, `date_added`, `status`) VALUES ('$car_club_name_id',NULLIF('$facebook_name',''),NULLIF('$brand_id',''),NULLIF('$model_id',''),NULLIF('$active_members_count',''),NULLIF('$members_count',''),NULLIF('$facebook_members_count',''),NULLIF('$membership_fee',''),NULLIF('$assigned_person',''),NULLIF('$user_id',''),NULLIF('$car_club_status',''),NOW(),NULLIF('$status',''))"; return $db->sql_query_id($query); } function update_car_club_main($array_data, $utility_class, $db) { $id = $array_data['car_club_id']; $car_club_name_id = $array_data['name_id']; $facebook_name = $array_data['facebook_name']; $brand_id = $array_data['brand_id']; $model_id = $array_data['model_id']; $active_members_count = $array_data['active_members_count']; $members_count = $array_data['members_count']; $facebook_members_count = $array_data['facebook_members_count']; $membership_fee = $array_data['membership_fee']; $assigned_person = $array_data['assigned_person']; $user_id = $array_data['user_id']; $car_club_status = $array_data['car_club_status']; $status = $array_data['status']; $query = "UPDATE `car_clubs` SET `car_club_name_id`='$car_club_name_id', `facebook_name`=NULLIF('$facebook_name',''), `brand_id`=NULLIF('$brand_id',''), `model_id`=NULLIF('$model_id',''), `active_members_count`=NULLIF('$active_members_count',''), `members_count`=NULLIF('$members_count',''), `facebook_members_count`=NULLIF('$facebook_members_count',''), `membership_fee`=NULLIF('$membership_fee',''), `assigned_person`=NULLIF('$assigned_person',''), `car_club_status`=NULLIF('$car_club_status',''), `status`=NULLIF('$status','') WHERE 1 AND id = $id"; return $db->sql_query($query); } function read_car_club_assigned_by_name($name, $db) { $query = "SELECT * FROM `car_club_assigned_persons` WHERE 1 AND `name` = '$name' AND `status` = 1"; return $db->sql_query($query); } function create_car_club_assigned($name, $db) { $query = "INSERT INTO `car_club_assigned_persons`(`name`, `date_added`, `status`) VALUES ('$name',NOW(),1)"; return $db->sql_query_id($query); } function read_car_club_main_by_car_club_name_id($car_club_name_id, $db) { $universal_query = $this->car_club_universal_query(); $fields = " cc.id,cc.car_club_name_id "; $query = $universal_query . " AND cc.car_club_name_id = %s AND cc.status = 1 LIMIT 1 "; $query_final = sprintf($query, $fields, $car_club_name_id); // echo $query_final;exit; return $db->sql_query($query_final); } function read_position_id_by_name($name, $db) { $query = "SELECT id FROM `car_club_positions` WHERE 1 AND name = '$name' AND status = 1 LIMIT 1"; return $db->select($query); } function create_position($name, $db) { $query = "INSERT INTO `car_club_positions`(`name`, `status`) VALUES ('$name','1')"; return $db->sql_query_id($query); } function remove_car_club_officers($id, $db) { $query = "DELETE FROM `car_club_officers` WHERE 1 AND `car_club_id` = $id "; return $db->sql_query($query); } function create_car_club_officers($data_to_insert, $db) { $query_customer_contact_person = "INSERT INTO `car_club_officers`( `position_id`, `member_id`, `user_id`, `date_added`, `car_club_id`, `status`) VALUES " . $data_to_insert . ""; // echo $query_customer_contact_person;exit; $rows_affected = $db->sql_query_num_inserted($query_customer_contact_person); return $rows_affected; } function update_car_club_officers_status($id, $status, $db) { $query = "UPDATE `car_club_officers` SET `status`='$status' WHERE 1 AND `car_club_id` = $id "; return $db->sql_query($query); } function update_car_club_officer_status($id, $status, $db) { $query = "UPDATE `car_club_officers` SET `status`='$status' WHERE 1 AND `id` = $id "; return $db->sql_query($query); } function update_car_club_member_officers_status($car_club_id, $member_id, $position_id, $status, $db) { $query = "UPDATE `car_club_officers` SET `status`='$status' WHERE 1 AND position_id = $position_id AND `car_club_id` = $car_club_id "; // echo $query;exit; return $db->sql_query($query); } function read_car_club_officer_by_member_id_position_id($arr_data) { $db = $arr_data['db']; $member_id = $arr_data['member_id']; $position_id = $arr_data['position_id']; $car_club_id = $arr_data['car_club_id']; $user_id = $arr_data['user_id']; $utility_class = $arr_data['utility_class']; $query = "SELECT id FROM `car_club_officers` WHERE 1 AND position_id = $position_id AND member_id = $member_id AND car_club_id = $car_club_id "; // echo $query; // exit; return $db->select($query); } function read_user_id_by_name_mobile($array_data, $db) { $firstname = $array_data['Firstname']; $lastname = $array_data['Lastname']; $mobile = $array_data['Mobile']; $query = "SELECT `id` FROM `car_club_users` WHERE 1 AND firstname = '$firstname' AND lastname = '$lastname' AND mobile = '$mobile' AND status = 1 LIMIT 1"; return $db->select($query); } function read_user_id_by_name($array_data, $db) { $firstname = $array_data['Firstname']; $lastname = $array_data['Lastname']; $mobile = $array_data['Mobile']; $query = "SELECT `id` FROM `car_club_users` WHERE 1 AND firstname = '$firstname' AND lastname = '$lastname' AND status = 1 LIMIT 1"; return $db->select($query); } function create_user($array_data, $utility_class, $db) { $firstname = $array_data['Firstname']; $lastname = $array_data['Lastname']; $mobile = $array_data['Mobile']; $email = ""; $user_session = $utility_class->user(); $user_id = $user_session['id']; $query = "INSERT INTO `car_club_users`(`firstname`, `lastname`, `mobile`, `email`, `user_id`, `status`) VALUES (NULLIF('$firstname',''),NULLIF('$lastname',''),NULLIF('$mobile',''),NULLIF('$email',''),$user_id,1)"; return $db->sql_query_id($query); } function update_user($array_data, $utility_class, $db) { $id = $array_data['id']; $firstname = $array_data['Firstname']; $lastname = $array_data['Lastname']; $mobile = $array_data['Mobile']; $email = ""; $user_session = $utility_class->user(); $user_id = $user_session['id']; $query = "UPDATE `car_club_users` SET `firstname`=NULLIF('$firstname',''),`lastname`=NULLIF('$lastname',''), `mobile`=NULLIF('$mobile',''),`email`=NULLIF('$email','') WHERE 1 AND id = $id"; return $db->sql_query_id($query); } function read_member_id_by_user_id_car_club_id($array_data, $db) { $car_club_id = $array_data['car_club_id']; $car_club_user_id = $array_data['car_club_user_id']; $query = "SELECT `id` FROM `car_club_members` WHERE 1 AND car_club_id = '$car_club_id' AND car_club_user_id = '$car_club_user_id' AND status = 1 LIMIT 1"; return $db->select($query); } function create_member($array_data, $db) { $car_club_id = $array_data['car_club_id']; $member_id = $array_data['car_club_user_id']; $user_id = $array_data['user_id']; $member_status = $array_data['member_status']; $query = "INSERT INTO `car_club_members`(`car_club_id`, `car_club_user_id`, `date_added`, `user_id`,`member_status`, `status`) VALUES ($car_club_id,$member_id,NOW(),$user_id,$member_status,1)"; return $db->sql_query_id($query); } function update_member($array_data, $db) { $car_club_id = $array_data['car_club_id']; $car_club_member_id = $array_data['car_club_member_id']; $member_id = $array_data['car_club_user_id']; $user_id = $array_data['user_id']; $member_status = $array_data['member_status']; $query = "UPDATE `car_club_members` SET `car_club_id`='$car_club_id',`car_club_user_id`='$member_id',`member_status`='$member_status' WHERE 1 AND id = $car_club_member_id"; return $db->sql_query_id($query); } function read_car_club_list_table($array_data) { $db = $array_data['db']; $utility_class = $array_data['utility_class']; $search = $array_data['search']; $offset = $array_data['offset']; $limit = $array_data['limit']; $offset_limit = "LIMIT " . $offset . "," . $limit . " "; $brand_id = $array_data['brand_id']; $model_id = $array_data['model_id']; $club_status_id = $array_data['club_status']; //filters $brand = $utility_class->isNotEmpty($brand_id) ? " AND sb.id = $brand_id " : ''; $model = $utility_class->isNotEmpty($model_id) ? " AND scm.id = $model_id " : ''; $club_status = $utility_class->isNotEmpty($club_status_id) ? " AND cc.car_club_status = $club_status_id " : ''; $universal_query = $this->car_club_universal_query(); $fields = " cc.id, cac.name, sb.name AS brand, scm.name AS model, cc.active_members_count, cc.members_count, CONCAT(ccu.firstname,' ',ccu.lastname) as president, ccap.name AS assigned_person, cc.car_club_status "; $field_counts = " COUNT(1) "; $query = $universal_query . " AND cac.name LIKE '%%%s%%' AND cc.status = 1 %s %s %s ORDER BY cc.date_added DESC %s "; $query_final = sprintf($query, $fields, $search, $brand, $model, $club_status, $offset_limit); // echo $query_final;exit; $query_count_final = sprintf($query, $field_counts, $search, $brand, $model, $club_status, ''); return array(intval($db->select($query_count_final)), $db->sql_query($query_final)); } function read_car_club_list_affiliation_members_count($array_data) { $id = $array_data['id']; $db = $array_data['db']; return $db->select("SELECT COUNT(1) as member_count FROM `customer_affiliations_content` cac INNER JOIN customer_affiliations_list cil ON cac.id = cil.affiliations_content_id INNER JOIN customer c ON cil.customer_id = c.id WHERE 1 AND cac.`affiliation_id` = 5 AND cac.status = 1 AND cac.id = $id AND c.status = 1 GROUP BY cac.id,c.id"); } function read_car_club_list_affiliation_table($array_data) { $db = $array_data['db']; $utility_class = $array_data['utility_class']; $search = $array_data['search']; $offset = $array_data['offset']; $limit = $array_data['limit']; $offset_limit = "LIMIT " . $offset . "," . $limit . " "; $brand_id = $array_data['brand_id']; $model_id = $array_data['model_id']; //filters $brand = $utility_class->isNotEmpty($brand_id) ? " AND sb.id = $brand_id " : ''; $model = $utility_class->isNotEmpty($model_id) ? " AND scm.id = $model_id " : ''; $fields = " * "; $field_counts = " COUNT(1) "; $query = " SELECT %s FROM `customer_affiliations_content` WHERE 1 AND name LIKE '%%%s%%' AND `affiliation_id` = 5 AND status = 1 ORDER BY name ASC %s "; $query_final = sprintf($query, $fields, $search, $offset_limit); // echo $query_final;exit; $query_count_final = sprintf($query, $field_counts, $search, ''); return array(intval($db->select($query_count_final)), $db->sql_query($query_final)); } function read_car_club_list_affiliation_members($array_data) { $db = $array_data['db']; $utility_class = $array_data['utility_class']; $search = $array_data['search']; $offset = $array_data['offset']; $limit = $array_data['limit']; $offset_limit = "LIMIT " . $offset . "," . $limit . " "; $id = $array_data['id']; if ($utility_class->isNotEmpty($search)) { $filter_email = " OR cc.email_1 = '" . $search . "' "; } else { $filter_email = ""; } $fields = " c.,cc.mobile_phone_1,cc.email_1 "; $field_counts = " COUNT(1) "; $query = " SELECT %s FROM `customer_affiliations_content` cac INNER JOIN customer_affiliations_list cil ON cac.id = cil.affiliations_content_id INNER JOIN customer c ON cil.customer_id = c.id INNER JOIN customer_contact cc ON c.id = cc.customer_id WHERE 1 AND (CONCAT('', CONCAT( c.corporation_name, ' ', c.first_name, ' ', c.last_name , ' ', c.first_name, ' ', c.middle_name, ' ', c.last_name ),' ', CONCAT('0',SUBSTRING(cc.mobile_phone_1, 4) ), ' ', cc.mobile_phone_1) LIKE '%%%s%%' / 1 search / ) %s / email / AND cac.`affiliation_id` = 5 AND cac.status = 1 AND cac.id = $id AND c.status = 1 GROUP BY c.id ORDER BY c.last_name ASC %s "; $query_final = sprintf($query, $fields, $search, $filter_email, $offset_limit); // echo $query_final;exit; $query_count_final = sprintf($query, $field_counts, $search, $filter_email, ''); return array(intval($db->select($query_count_final)), $db->sql_query($query_final)); } function read_car_club_members_list_table($array_data) { $db = $array_data['db']; $utility_class = $array_data['utility_class']; $search = $array_data['search']; $offset = $array_data['offset']; $limit = $array_data['limit']; $car_club_id = $array_data['id']; $member_status_id = $array_data['member_status']; $offset_limit = "LIMIT " . $offset . "," . $limit . " "; $member_status = $utility_class->isNotEmpty($member_status_id) ? " AND ccm.member_status = $member_status_id " : ""; $fields = " ccu.,ccm.id as member_id,CONCAT('0',ccu.mobile) as mobilef,ccm.member_status,DATE_FORMAT(ccm.date_added,'%M %d, %Y') as date_addedf "; $field_counts = " COUNT(1) "; $query = " SELECT %s FROM `car_club_members` ccm LEFT OUTER JOIN car_club_users ccu ON ccm.car_club_user_id = ccu.id WHERE 1 AND CONCAT(ccu.firstname,' ',ccu.lastname,' ',ccu.firstname) LIKE '%%%s%%' AND ccm.status = 1 AND ccu.status = 1 AND ccm.car_club_id = $car_club_id %s /member status/ ORDER BY ccm.date_added DESC %s "; $query_final = sprintf($query, $fields, $search, $member_status, $offset_limit); // echo $query_final;exit; $query_count_final = sprintf($query, $field_counts, $search, $member_status, ''); return array(intval($db->select($query_count_final)), $db->sql_query($query_final)); } function read_member_data($array_data) { $db = $array_data['db']; $utility_class = $array_data['utility_class']; $id = $array_data['id']; $fields = " ccu.,ccm.id as member_id,CONCAT('0',ccu.mobile) as mobilef,ccm.member_status,DATE_FORMAT(ccm.date_added,'%M %d, %Y') as date_addedf "; $query = " SELECT %s FROM `car_club_members` ccm LEFT OUTER JOIN car_club_users ccu ON ccm.car_club_user_id = ccu.id WHERE 1 AND ccu.id = %s LIMIT 1 "; $query_final = sprintf($query, $fields, $id); return $db->sql_query($query_final); } function create_car_club_member($array_data) { $db = $array_data['db']; $utility_class = $array_data['utility_class']; $id = $array_data['id']; $firstname = $array_data['txt_member_fname']; $lastname = $array_data['txt_member_lname']; $mobile = $array_data['txt_member_mobile']; $member_status = $array_data['dd_member_status']; $user_id = $array_data['user_id']; return $db->sql_query_id("INSERT INTO `car_club_members`(`id`, `car_club_id`, `car_club_user_id`, `date_added`, `user_id`, `member_status`, `status`) VALUES ('[value-1]','[value-2]','[value-3]','[value-4]','[value-5]','[value-6]','[value-7]')"); } function read_car_club($array_data) { $db = $array_data['db']; $utility_class = $array_data['utility_class']; $id = $array_data['id']; $universal_query = $this->car_club_universal_query(); $fields = " cc.id, cac.name, sb.name AS brand, scm.name AS model, cc.active_members_count, cc.facebook_members_count, cc.members_count, cc.membership_fee, CONCAT(ccu.firstname,' ',ccu.lastname) as president, ccap.name AS assigned_person, cc.car_club_status, cc.assigned_person as assigned_person_id, cc.car_club_name_id, cc.brand_id, cc.model_id "; $field_counts = " COUNT(1) "; $query = $universal_query . " AND cc.id = %s AND cc.status = 1 "; $query_final = sprintf($query, $fields, $id); return $db->sql_query($query_final); } function read_car_club_officers($array_data) { $db = $array_data['db']; $id = $array_data['id']; $query = "SELECT cco.id, ccp.name as position, CONCAT(ccu.firstname,' ',ccu.lastname) as name, ccu.firstname, ccu.lastname, CONCAT('0',ccu.mobile) as mobilef, ccu.mobile FROM `car_club_officers` cco LEFT OUTER JOIN car_club_positions ccp ON cco.position_id = ccp.id LEFT OUTER JOIN car_club_users ccu ON cco.member_id = ccu.id WHERE 1 AND cco.status = 1 AND ccu.status =1 AND ccp.status = 1 AND cco.car_club_id = $id ORDER BY cco.id ASC "; return $db->sql_query($query); } function update_car_club_status($array_data) { $db = $array_data['db']; $id = $array_data['id']; $status = $array_data['status']; $query = "UPDATE `car_clubs` SET `status`= $status WHERE 1 AND `id` = $id "; $db->sql_query($query); } function update_car_club_affiliation_name($array_data) { $db = $array_data['db']; $id = $array_data['id']; $name = $array_data['name']; $query = "UPDATE `customer_affiliations_content` SET `name`='$name' WHERE 1 AND `id` = $id "; // echo $query;exit; $db->sql_query($query); } function update_car_club_affiliation_status($array_data) { $db = $array_data['db']; $id = $array_data['id']; $status = $array_data['status']; $query = "UPDATE `customer_affiliations_content` SET `status`=$status WHERE 1 AND `id` = $id "; $db->sql_query($query); } function update_member_status($array_data) { $db = $array_data['db']; $id = $array_data['id']; $status = $array_data['status']; $query = "UPDATE `car_club_members` SET `status`= $status WHERE 1 AND `id` = $id "; $db->sql_query($query); } function update_member_officer_status($array_data) { $db = $array_data['db']; $id = $array_data['id']; $status = $array_data['status']; $car_club_id = $array_data['car_club_id']; $officer_status = $array_data['officer_status']; $user_id = $array_data['user_id']; $query = "UPDATE `car_club_officers` SET `status` = $officer_status WHERE `member_id` = $user_id AND car_club_id = $car_club_id "; // echo $query;exit; $db->sql_query($query); } function read_car_club_fields($array_data) { $db = $array_data['db']; $query = "SELECT FROM `import_module_fields` WHERE module_id = 1"; // echo $query;exit; return $db->sql_query($query); } }

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