File manager

File manager - Edit - /home/autoph/public_html/tasks/models.tar

Back
brand.php��0000644��00000003142�15024755361�0006353 0��ustar�00��<?php if(isset($_REQUEST['api'])){ include_once dirname(__FILE__) . '/../../cfg/db_api.php'; }else{ include_once dirname(__FILE__) . '/../../cfg/db.php'; // if(!intval($global_user_status)){ // echo $global_user_message; // exit; // } } include_once dirname(__FILE__) . '/../../app/classes/brand_class.php'; include_once dirname(__FILE__) . '/../../app/classes/utility.php'; $utility_class = new Utility(); $brand_class = new Brand(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['model'])){ $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db'=>$db, 'utility_class'=>$utility_class, 'brand_class'=>$brand_class, 'server_method'=>$server_method, 'user_session'=>$session_user, // 'user'=>$session_user, // 'global_system_settings'=>$global_system_settings, 'request'=>$_REQUEST, ); call_user_func($function_name,$parameters); }else{ echo "Invalid Request."; exit; } function read_brands($param){ $db = $param['db']; $utility_class = $param['utility_class']; $brand_class = $param['brand_class']; $request = $param['request']; $search = isset($request['search']) ? $db -> escape($request['search']) : '' ; $brand_access_arr = $param['user_session']['json_brand']; $brand_list_obj = $brand_class->read_brands($search,$brand_access_arr,$utility_class,$db); $json = []; foreach($brand_list_obj as $row){ $json[] = ['id'=>$row['name'], 'text'=>$row['name']]; } echo json_encode($json); } ?>��sms.php��0000644��00000006651�15024755361�0006077 0��ustar�00��<?php if (isset($_REQUEST['api'])) { include_once dirname(__FILE__) . '/../../cfg/db_api.php'; } else { include_once dirname(__FILE__) . '/../../cfg/db.php'; // if(!intval($global_user_status)){ // echo $global_user_message; // exit; // } } include_once dirname(__FILE__) . '/../../app/classes/utility.php'; include_once dirname(__FILE__) . '/../../app/classes/sms_class.php'; include_once dirname(__FILE__) . '/../../app/classes/user_class.php'; $utility_class = new Utility(); $user_class = new User(); $sms_class = new Sms(); $server_method = $_SERVER["REQUEST_METHOD"]; if (isset($_REQUEST['model'])) { $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db' => $db, 'utility_class' => $utility_class, 'server_method' => $server_method, 'user_class' => $user_class, 'sms_class' => $sms_class, 'global_system_settings' => $global_system_settings, 'user_session' => $session_user, 'request' => $_REQUEST, ); call_user_func($function_name, $parameters); } else { echo "Invalid Request."; exit; } function test($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $sms_class = $param['sms_class']; $request = $param['request']; if (empty($request['message']) \|\| empty($request['mobile'])) { $return_arr['status'] = 0; $return_arr['message'] = "Mobile no. and message are required."; echo json_encode($return_arr); exit; } $active_api_sql_obj = $user_class->read_active_api($utility_class, $db); $active_api_array = array(); foreach ($active_api_sql_obj as $row) { $active_api_array = $row; } if (count($active_api_array) > 0) { // print_r($sms_class->test()); // // $replace_parameter = array( // // '[no]' => $request['mobile'], // // '[msg]' => addslashes($request['message']), // // ); // // $final_template = strtr($active_api_array['json_parameters'], $replace_parameter); // // $final_template = preg_replace("/\\n/m", "\\n", $final_template); // // $final_template = str_replace("\'", "'", $final_template); $array_data['mobile'] = $request['mobile']; $array_data['message'] = $request['message']; $array_data['data'] = $active_api_array; // $function = "test"; // echo $active_api_array['name']; $sms_status = $sms_class->{$active_api_array['name']}($array_data); // $sms_status = $sms_class->$function($array_data); // // $sms_status = $utility_class->curl_me( // // $active_api_array['base_url'], // // $final_template, // // 'POST', // // $active_api_array['headers'] // // ); // if ($sms_status == $active_api_array['sent_response']) { // //send succcess // } else { // //send failed // } print_r($sms_status); // // $return_arr['status'] = 1; // // $return_arr['message'] = "No SMS API Selected."; // // echo json_encode($return_arr); // // exit; } else { $return_arr['status'] = 0; $return_arr['message'] = "No SMS API Selected."; echo json_encode($return_arr); exit; } } ��user.php��0000644��00000112775�15024755361�0006260 0��ustar�00��<?php if (isset($_REQUEST['api'])) { include_once dirname(__FILE__) . '/../../cfg/db_api.php'; } else { include_once dirname(__FILE__) . '/../../cfg/db.php'; } include_once dirname(__FILE__) . '/../../app/classes/user_class.php'; include_once dirname(__FILE__) . '/../../app/classes/ticket_class.php'; include_once dirname(__FILE__) . '/../../app/classes/company_class.php'; include_once dirname(__FILE__) . '/../../app/classes/brand_class.php'; include_once dirname(__FILE__) . '/../../app/classes/utility.php'; $user_class = new User(); $company_class = new Company(); $ticket_class = new Ticket(); $brand_class = new Brand(); $utility_class = new Utility(); $server_method = $_SERVER["REQUEST_METHOD"]; if (isset($_REQUEST['model'])) { $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db' => $db, 'user_class' => $user_class, 'ticket_class' => $ticket_class, 'company_class' => $company_class, 'utility_class' => $utility_class, 'brand_class' => $brand_class, 'server_method' => $server_method, // 'user'=>$session_user, 'user_session' => $session_user, 'request' => $_REQUEST, ); call_user_func($function_name, $parameters); } else { echo "Invalid request."; exit; } // function signup($param){ // if($param['server_method'] !== 'POST'){ // echo "Invalid request."; // exit; // } // $request = $param['request']; // $db = $param['db']; // $array_data = json_decode($request['json_data'],true); // foreach ($array_data as $key => $value){ // if($key != 'password'){ // $array_data[$key] = trim(mb_strtoupper($array_data[$key])); // $array_data[$key] = $param['db']->escape($array_data[$key]); // } // } // //check dup id no. // $id_no_count = $param['user_class']->read_id_number_count($array_data['id_no'],$param['utility_class'],$db); // if(intval($id_no_count) > 0){ // $return_arr['message'] = "ID number already exist."; // $return_arr['status'] = 0; // echo json_encode($return_arr); // exit; // } // $email_count = $param['user_class']->read_email_count($array_data['email'],$param['utility_class'],$db); // if(intval($email_count) > 0){ // $return_arr['message'] = "Email address already exist."; // $return_arr['status'] = 0; // echo json_encode($return_arr); // exit; // } // $mobile_count = $param['user_class']->read_mobile_count($array_data['mobile'],$param['utility_class'],$db); // if(intval($mobile_count) > 0){ // $return_arr['message'] = "Mobile number already exist."; // $return_arr['status'] = 0; // echo json_encode($return_arr); // exit; // } // if($param['user_class']->insert_user_details($array_data,$param['utility_class'],$db) === 2){ // $return_arr['message'] = "Account successfully created."; // $return_arr['status'] = 1; // echo json_encode($return_arr); // exit; // }else{ // $return_arr['message'] = "Account not created. Try again."; // $return_arr['status'] = 0; // echo json_encode($return_arr); // exit; // } // } function read_role_list($param) { $db = $param['db']; $utility_class = $param['utility_class']; $request = $param['request']; $user_session = $param['user_session']; $user_class = $param['user_class']; // print_r($request);exit; $search = $db->escape($request['search']); $offset = $request['offset']; $limit = $request['limit']; $role_list_array = $user_class->read_role_list( $user_session['id'], $search, $offset, $limit, $utility_class, $db ); $json_arr['total'] = $role_list_array[0]; $role_list_obj = $role_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($role_list_obj as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'id' => $row['id'], 'name' => $row['name'], 'user_category' => $row['user_category'], 'json_access' => $row['json_access'], 'json_dealer' => $row['json_dealer'], 'json_brand' => $row['json_brand'], 'user_count' => intval($row['user_count']), )) ); } echo json_encode($json_arr); } function read_role_brand_list($param) { $db = $param['db']; $utility_class = $param['utility_class']; $request = $param['request']; $user_session = $param['user_session']; $user_class = $param['user_class']; // print_r($request);exit; $search = $db->escape($request['search']); $offset = $request['offset']; $limit = $request['limit']; $selected_brands_arr = json_decode($request['selected_brands'], true); $role_list_array = $user_class->read_role_brand_list( $user_session['id'], $search, $offset, $limit, $utility_class, $db ); $json_arr['total'] = $role_list_array[0]; $role_list_obj = $role_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($role_list_obj as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'id' => $row['id'], 'name' => $row['name'], 'status' => (in_array($row['id'], $selected_brands_arr) ? 1 : 0), )) ); } echo json_encode($json_arr); } function read_position_list($param) { $db = $param['db']; $utility_class = $param['utility_class']; $request = $param['request']; $user_session = $param['user_session']; $user_class = $param['user_class']; // print_r($request);exit; $search = $db->escape($request['search']); $offset = $request['offset']; $limit = $request['limit']; $selected_positions_arr = json_decode($request['selected_positions'], true); $role_list_array = $user_class->read_position_list( $user_session['id'], $search, $offset, $limit, $utility_class, $db ); $json_arr['total'] = $role_list_array[0]; $role_list_obj = $role_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($role_list_obj as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'id' => $row['id'], 'name' => $row['name'], 'status' => (in_array($row['id'], $selected_positions_arr) ? 1 : 0), )) ); } echo json_encode($json_arr); } function remove_role($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $user_session = $param['user_session']; $role_id = $request['id']; if ($user_class->remove_role($role_id, $utility_class, $db) === 1) { $return_arr['message'] = "Successfully removed."; $return_arr['status'] = 1; echo json_encode($return_arr); exit; } else { $return_arr['message'] = "Not removed. Try again."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } function create_role($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $brand_class = $param['brand_class']; $request = $param['request']; $user_session = $param['user_session']; $is_new_role = $request['is_new_role']; $role_data = $request['role_data']; $brand_data = $request['brand_data']; $brand_data_arr = json_decode($brand_data, true); $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $json_dealer = ""; $role_id = $request['role_id']; $role_info_obj = $user_class->read_role_information($role_id, $utility_class, $db); $role_info_arr = array(); foreach ($role_info_obj as $role_info_row) { $role_info_arr = $role_info_row; } //secure the admin role if (!$is_new_role) { $admin_role_id = 13; if (intval($_SESSION['cc_user']['role_id']) != $admin_role_id && $role_id == $admin_role_id) { $return_arr['message'] = "Only admin can modify this role."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } if ((isset($role_info_arr['name']) && $role_info_arr['name'] != $array_data['txt_role_name']) \|\| $is_new_role) { // check if duplicate role name $role_count = $user_class->read_role_count_by_name($array_data['txt_role_name'], $utility_class, $db); if (intval($role_count) > 0) { $return_arr['message'] = "Role name already exist."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } } // clean unknown or status 0 brand ids // read every brand id if still active // $brand_data = $brand_ids_obj = $brand_class->read_brand_ids($db); $brand_ids_arr = array(); foreach ($brand_ids_obj as $brand_ids_row) { $brand_ids_arr[] = $brand_ids_row['id']; } $valid_brand_data = array(); foreach ($brand_data_arr as $brand_data_row) { if (in_array($brand_data_row, $brand_ids_arr)) { $valid_brand_data[] = $brand_data_row; } } if (count($valid_brand_data) <= 0) { $brand_data_to_insert = ""; } else { $brand_data_to_insert = json_encode($valid_brand_data); } $category_id = $user_class->read_category_id_by_name($array_data['dd_user_type'], $utility_class, $db); if (intval($is_new_role)) { $role_id = $user_class->create_role($user_session['id'], $array_data['txt_role_name'], $utility_class, $db); $user_class->create_role_access($role_id, $role_data, $brand_data_to_insert, $json_dealer, $category_id, $utility_class, $db); } else { $user_class->update_role($user_session['id'], $role_id, $array_data['txt_role_name'], $utility_class, $db); $user_class->update_role_access($role_id, $role_data, $brand_data_to_insert, $json_dealer, $category_id, $utility_class, $db); } if (intval($is_new_role)) { $return_arr['message'] = "Role has been created."; } else { $return_arr['message'] = "Role has been updated."; } $return_arr['id'] = $role_id; $return_arr['status'] = 1; echo json_encode($return_arr); } function read_user_categories($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $category_list_obj = $user_class->read_user_categories($search, $utility_class, $db); $json = []; foreach ($category_list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_sms_apis($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $category_list_obj = $user_class->read_sms_apis($search, $utility_class, $db); $json = []; foreach ($category_list_obj as $row) { $json[] = ['id' => $row['id'], 'text' => $row['name'], 'activated' => $row['is_activated']]; } echo json_encode($json); } function read_system_config($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $obj = $user_class->read_system_config($utility_class, $db); $arr = array(); foreach ($obj as $row) { $arr = array_merge($arr, array(array( 'id' => $row['id'], 'name' => $row['name'], 'value' => $row['value'], ))); } echo json_encode($arr); } function read_sms_templates($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $obj = $user_class->read_sms_templates($utility_class, $db); $arr = array(); foreach ($obj as $row) { $row = $utility_class->arrayNullToBlank($row); $arr = array_merge($arr, array(array( 'id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'type' => $row['type'], ))); } echo json_encode($arr); } function read_notification_template($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $obj = $user_class->read_notification_template($utility_class, $db); $arr = array(); foreach ($obj as $row) { $row = $utility_class->arrayNullToBlank($row); $arr = array_merge( $arr, array(array( 'id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'is_active' => $row['is_active'], 'type' => $row['type'], )) ); } echo json_encode($arr); } function read_notification_reminder($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $obj = $user_class->read_notification_reminder($utility_class, $db); $arr = array(); foreach ($obj as $row) { $row = $utility_class->arrayNullToBlank($row); $arr = array_merge( $arr, array(array( 'id' => $row['id'], 'type' => $row['type'], 'minutes' => $row['minutes'], 'hours' => $row['hours'], 'days' => $row['days'], )) ); } echo json_encode($arr); } function update_system_config($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $obj = $user_class->update_system_config($array_data, $utility_class, $db); $return_arr['message'] = "Update successful..."; $return_arr['status'] = 1; echo json_encode($return_arr); } function update_sms_config($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } // print_r($array_data);exit; $sms_api_id = $array_data['api']; $user_class->update_all_sms_config_api_status(0, $utility_class, $db); if ($utility_class->isNotEmpty($sms_api_id)) { $user_class->update_sms_config_api_status($sms_api_id, 1, $utility_class, $db); } // $obj = $user_class->update_sms_config($array_data,$utility_class,$db); // update templates foreach ($array_data as $key => $value) { if ($utility_class->stringStartsWith($key, 't_')) { $template_id = substr($key, 2, strlen($key)); $user_class->update_sms_config_template($template_id, $value, $utility_class, $db); } } // if(){ // } $return_arr['message'] = "Update successful..."; $return_arr['status'] = 1; echo json_encode($return_arr); } function update_notification_template($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $array_data_reminder = json_decode($request['json_data_reminder'], true); foreach ($array_data_reminder as $key1 => $value1) { $array_data_reminder[$key1] = $db->escape($array_data_reminder[$key1]); } // $obj = $user_class->update_sms_config($array_data,$utility_class,$db); // update templates foreach ($array_data as $key => $value) { if ($utility_class->stringStartsWith($key, 't_')) { $template_id = substr($key, 2, strlen($key)); $template_obj = $user_class->read_notification_by_id($template_id, $db); $template_arr = array(); foreach ($template_obj as $template_row) { $template_arr = $template_row; } $name = $array_data['ttitle_' . $template_id]; $is_active = $array_data['status_' . $template_id]; if (count($template_arr) > 0) { $user_class->update_notification_template($template_id, $name, $value, $is_active, $utility_class, $db); } else { $user_class->insert_notification_template($template_id, $name, $value, $is_active, $utility_class, $db); } } } $reminder_data = array(); foreach ($array_data_reminder as $key => $value) { $reminder_type = substr($key, 9, strlen($key)); $reminder_minutes = abs(intval($value['reminder_min_' . $reminder_type])); $reminder_hours = abs(intval($value['reminder_hr_' . $reminder_type])); $reminder_days = abs(intval($value['reminder_day_' . $reminder_type])); $reminder_data[] = "('$reminder_type', '$reminder_minutes','$reminder_hours','$reminder_days')"; } $user_class->update_reminder_times($reminder_data, $utility_class, $db); $return_arr['message'] = "Update successful..."; $return_arr['status'] = 1; echo json_encode($return_arr); } function signin($param) { if ($param['server_method'] !== 'POST') { echo "Invalid request."; exit; } $db = $param['db']; $utility_class = $param['utility_class']; $array_data = json_decode($param['request']['json_data'], true); $username = $db->escape($array_data['username']); $where_statement = " AND (uc.email = '" . $array_data['username'] . "' OR ua.username = '" . $array_data['username'] . "') "; $result_arr = $param['user_class']->system_user_security($where_statement, $array_data, 'login', $utility_class, $db); echo json_encode($result_arr); } function signin_api_asa($param) { // echo "sds";exit; if ($param['server_method'] !== 'POST') { echo "Invalid request."; exit; } $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $company_class = $param['company_class']; $request = $param['request']; $user_id = ""; if (isset($request['json_data'])) { $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $username = $array_data['username']; $password = $array_data['password']; $user_info_json = $utility_class->curl_me( "https://autohub.ph/connect/api/v1/users/users.php", array('key' => '5463358374534', 'username' => $username, 'password' => $password), 'POST' ); } else if (isset($request['asa_id'])) { $user_info_json = $utility_class->curl_me( "https://autohub.ph/connect/api/v1/users/users.php", array('key' => '54633343444223', 'id' => $request['asa_id']), 'POST' ); } else { $return_arr['message'] = "Error."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } $user_info_arr = json_decode($user_info_json, true); if ($user_info_arr['api_status'] == 1) { // Process Company // insert/update company $company_source_id = $user_info_arr['company_id']; $company_name = $user_info_arr['company']; $company_code = $user_info_arr['company_code']; $company_obj = $company_class->read_company_by_source_id($company_source_id, $utility_class, $db); $company_arr = array(); foreach ($company_obj as $company_obj_row) { $company_arr = $company_obj_row; } if (count($company_arr) > 0) { // update $company_id = $company_arr['id']; $company_class->update_company($company_id, $user_id, $company_source_id, $company_name, $company_code, $utility_class, $db); } else { // insert and get system id $company_id = $company_class->create_company($user_id, $company_source_id, $company_name, $company_code, $utility_class, $db); } // insert update dealer $dealer_source_id = $user_info_arr['dealer_id']; $dealer_name = $user_info_arr['dealer']; $dealer_code = $user_info_arr['dealer_code']; $dealer_obj = $company_class->read_dealer_by_source_id($dealer_source_id, $utility_class, $db); $dealer_arr = array(); foreach ($dealer_obj as $dealer_obj_row) { $dealer_arr = $dealer_obj_row; } if (count($dealer_arr) > 0) { // update $dealer_id = $dealer_arr['id']; $company_class->update_dealer($company_id, $dealer_id, $user_id, $dealer_source_id, $dealer_name, $dealer_code, $utility_class, $db); } else { // insert and get system id $dealer_id = $company_class->create_dealer($user_id, $company_id, $dealer_source_id, $dealer_name, $dealer_code, $utility_class, $db); } // insert update position $position_name = $user_info_arr['u_position']; $position_obj = $user_class->read_user_position_by_name($position_name, $utility_class, $db); $position_arr = array(); foreach ($position_obj as $position_obj_row) { $position_arr = $position_obj_row; } if (count($position_arr) > 0) { // update $position_id = $position_arr['id']; $user_class->update_user_position($user_id, $position_id, $position_name, '', '', $utility_class, $db); } else { // insert and get system id $position_id = $user_class->create_user_position($user_id, $position_name, '', '', $utility_class, $db); } $user_source_id = $user_info_arr['u_id']; $user_obj = $user_class->read_user_by_source_id($user_source_id, $utility_class, $db); $user_arr = array(); foreach ($user_obj as $user_obj_row) { $user_arr = $user_obj_row; } $id_number = $user_info_arr['employee_id']; $firstname = $user_info_arr['u_fname']; $middlename = $user_info_arr['u_mname']; $lastname = $user_info_arr['u_lname']; $mobile = $utility_class->fix_mobile_format_v2($user_info_arr['usr_mobile']); $email = ($utility_class->isValidEmail($user_info_arr['email']) ? $user_info_arr['email'] : ''); $username = $user_info_arr['u_name']; $password = password_hash($user_info_arr['u_password'], PASSWORD_DEFAULT); $user_source = 2; if (count($user_arr) > 0) { // update $user_id = $user_arr['id']; $user_class->update_user_api($user_id, $user_source_id, $user_source, $id_number, $position_id, $dealer_id, $firstname, $middlename, $lastname, $utility_class, $db); $user_class->update_user_contact_api($user_id, $mobile, $email, $utility_class, $db); $user_class->update_user_account_api($user_id, $username, $password, $utility_class, $db); // $user_class->update_user($user_id,$user_id,$user_source_id,$user_name,$user_code,$utility_class,$db); // $user_class->update_user_contact($utility_class,$db); // $user_class->update_user_account($utility_class,$db); } else { // insert and get system id $user_id = $user_class->create_user_api($user_source_id, $user_source, $id_number, $position_id, $dealer_id, $firstname, $middlename, $lastname, $utility_class, $db); $user_class->create_user_contact_api($user_id, $mobile, $email, $utility_class, $db); $user_class->create_user_account_api($user_id, $username, $password, $utility_class, $db); } $where_statement = " AND (u.`id` = $user_id) "; //check user status $result_arr = $user_class->system_user_security($where_statement, array(), 'main', $utility_class, $db); // $result_arr = $param['user_class'] -> system_user_security($where_statement,$array_data,'login',$utility_class,$db); // remove previous login token $user_class->update_user_login_token_status($user_id, 0, 3, $utility_class, $db); //create login token for cache $token = $db->select('SELECT UUID()'); $to_user_id = $user_id; $from_user_id = $user_id; $source_id = $user_id; $user_class->create_user_login_token($to_user_id, $from_user_id, $source_id, $token, 3, $utility_class, $db); //create cookie $cookie_name = "login_token"; $cookie_value = $token; setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/"); // 86400 = 1 day // loggerr $log_data['user_id'] = $user_id; $log_data['description'] = 'User has login'; //important $log_data['type'] = 1; //login $log_data['db'] = $db; $GLOBALS['logger_class']->log($log_data); echo json_encode($result_arr); // insert update user } else { $return_arr['message'] = "Login failed."; $return_arr['status'] = 0; echo json_encode($return_arr); } } function signout($param) { if ($param['server_method'] !== 'POST') { echo "Invalid request."; exit; } if (isset($_SESSION['cc_user'])) { session_destroy(); } else { echo "No Session Found."; } } function user_login_info($param) { if ($param['server_method'] !== 'POST') { echo "Invalid request."; exit; } // print_r($_SESSION['cc_user']); echo json_encode($_SESSION['cc_user']); } function user_notification_info($param) { if ($param['server_method'] !== 'POST') { echo "Invalid request."; exit; } $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $user_id = $param['user_id']; $notification_obj = $user_class->get_user_notification_info($user_id, $utility_class, $db); $notification_arr['data'] = array(); $total_count = 0; foreach ($notification_obj as $row) { $total_count += intval($row['total']); $notification_arr['data'] = array_merge( $notification_arr['data'], array(array( 'id' => $row['id'], 'count' => $row['total'], 'type' => $row['name'], 'ago' => $utility_class->time_elapsed_string($row['ago_time']), )) ); } $notification_arr['total'] = $total_count; // print_r($notification_arr); echo json_encode($notification_arr); } function read_user_notification($param) { $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $user_session = $param['user_session']; $user_id = $user_session['id']; $request = $param['request']; $offset = $request['offset']; $limit = $request['limit']; $notification_list_arr = $user_class->read_user_notification($user_id, $offset, $limit, $utility_class, $db); $notification_arr['total'] = $notification_list_arr[0]; $notification_obj = $notification_list_arr[1]; $notification_arr['rows'] = array(); foreach ($notification_obj as $row) { // print_r($row); $notification_formatted_description = read_notification_description($row['target_id'], $row['from_user_id'], $row['template_id'], $row['description'], $param); // echo $notification_formatted_description; $notification_arr['rows'] = array_merge( $notification_arr['rows'], array(array( 'id' => $row['id'], 'target_id' => $row['target_id'], 'is_read' => $row['is_read'], 'from_user_id' => $row['from_user_id'], 'to_user_id' => $row['to_user_id'], 'notification_id' => $row['id'], 'notification_type' => $row['template_id'], 'type' => $row['type'], 'description' => $notification_formatted_description, 'ago' => $utility_class->time_elapsed_string($row['date_added']), )) ); } echo json_encode($notification_arr); } function read_user_notification_count($param) { $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $user_session = $param['user_session']; $user_id = $user_session['id']; $request = $param['request']; $notification_arr['total'] = $user_class->read_user_notification_count($user_id, $utility_class, $db); echo json_encode($notification_arr); } function update_notification_status($param) { $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $user_session = $param['user_session']; $user_id = $user_session['id']; $request = $param['request']; $to_user_id = $request['to_user_id']; $target_id = $request['target_id']; $user_class->update_notification_status($target_id, $to_user_id, 1, $db); } function update_notification_status_close($param) { $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $user_session = $param['user_session']; $user_id = $user_session['id']; $request = $param['request']; $target_id = $request['target_id']; $user_class->update_notification_status($target_id, $user_id, 1, $db); } function read_roles($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $no_roles = isset($request['no_roles']) ? true : false; $search = isset($request['search']) ? $db->escape($request['search']) : ''; //secure the admin role $admin_role_id = 13; if (intval($_SESSION['cc_user']['role_id']) != $admin_role_id) { $no_admin = " AND id NOT IN ($admin_role_id) "; } else { $no_admin = ""; } $list_obj = $user_class->read_roles($search, $no_admin, $utility_class, $db); $json = []; if ($no_roles) { $json[] = ['id' => '0', 'text' => 'No roles']; } foreach ($list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_notification_description($target_id, $from_user_id, $notification_type, $description, $param) { $db = $param['db']; $user_class = $param['user_class']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; switch (intval($notification_type)) { case 1: case 3: // read ticket information $ticket_info_obj = $ticket_class->read_ticket_information($target_id, $utility_class, $db); $arr_data = array(); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $arr_data = $row; } $display_name = $arr_data['firstname'] . ' ' . substr($arr_data['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $replace_parameter = array( '<user>' => $display_name, '<ref_no>' => $arr_data['reference_no'], '<title>' => $arr_data['title'], '<description>' => $arr_data['description'], //str_replace("\n"," ",$arr_data['description']), '<category>' => $arr_data['sub_category'], '<priority>' => $arr_data['priority_level'], '<brand>' => $arr_data['brand'], '<model>' => $arr_data['model'], '<variant>' => $arr_data['model_variant'], ); return strtr($description, $replace_parameter); // break; case 2: case 4: // read ticket information $ticket_info_obj = $ticket_class->read_ticket_information($target_id, $utility_class, $db); $arr_data = array(); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $arr_data = $row; } $user_info_obj = $user_class->read_user_information($from_user_id, $db); $user_data = array(); foreach ($user_info_obj as $user_row) { $user_row = $utility_class->arrayNullToBlank($user_row); $user_data = $user_row; } $display_name = $user_data['firstname'] . ' ' . substr($user_data['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $replace_parameter = array( '<user>' => $display_name, '<ref_no>' => $arr_data['reference_no'], '<title>' => $arr_data['title'], '<description>' => $arr_data['description'], //str_replace("\n"," ",$arr_data['description']), '<category>' => $arr_data['sub_category'], '<priority>' => $arr_data['priority_level'], '<brand>' => $arr_data['brand'], '<model>' => $arr_data['model'], '<variant>' => $arr_data['model_variant'], ); return strtr($description, $replace_parameter); // break; } } function read_positions($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $position_list_obj = $user_class->read_positions($search, $utility_class, $db); $json = []; foreach ($position_list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function update_user_role($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $user_session = $param['user_session']; $user_id = intval($request['user_id']); $role_id = $utility_class->isNotEmpty($request['role_id']) ? $user_class->read_role_id_by_name($request['role_id'], $utility_class, $db) : ''; $user_class->update_user_role($user_id, $role_id, $db); $return_arr['message'] = "Success."; $return_arr['status'] = 1; echo json_encode($return_arr); } function read_users_list($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $user_session = $param['user_session']; $search = $db->escape($request['search']); $offset = $request['offset']; $limit = $request['limit']; if ($request['filter_role'] == '0') { $filter_role_id = 0; } else { $filter_role_id = $utility_class->isNotEmpty($request['filter_role']) ? $user_class->read_role_id_by_name($request['filter_role'], $utility_class, $db) : ''; } //secure the admin role $admin_role_id = 13; if (intval($user_session['role_id']) != $admin_role_id) { $no_admin = " AND (r.id NOT IN ($admin_role_id) OR r.id IS NULL) "; } else { $no_admin = ""; } $user_list_array = $user_class->read_user_list( $user_session['id'], $filter_role_id, $no_admin, $search, $offset, $limit, $utility_class, $db ); $json_arr['total'] = $user_list_array[0]; $user_list_obj = $user_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($user_list_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'id' => $row['id'], 'name' => $row['name'], 'user_id' => $row['id_number'], 'mobile' => '+63' . $row['mobile'], 'email' => $row['email'], 'position' => $row['position'], 'role_id' => $row['role_id'], 'role' => $row['role'], )) ); } echo json_encode($json_arr); } function read_viber_subscription($param) { $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $user_session = $param['user_session']; $viber_obj = $user_class->read_viber_subscription($user_session['id'], $utility_class, $db); $viber_arr = array(); foreach ($viber_obj as $viber_row) { $viber_arr = $viber_row; } $json_arr['status'] = count($viber_arr); $json_arr['user_id'] = $user_session['id']; echo json_encode($json_arr); } ��file.php��0000644��00000005520�15024755361�0006206 0��ustar�00��<?php if(isset($_REQUEST['api'])){ include_once dirname(__FILE__) . '/../../cfg/db_api.php'; }else{ include_once dirname(__FILE__) . '/../../cfg/db.php'; // if(!intval($global_user_status)){ // echo $global_user_message; // exit; // } } include_once dirname(__FILE__) . '/../../app/classes/upload_class.php'; include_once dirname(__FILE__) . '/../../app/classes/utility.php'; $utility_class = new Utility(); $upload_class = new Upload(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['model'])){ $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db'=>$db, 'utility_class'=>$utility_class, 'upload_class'=>$upload_class, 'server_method'=>$server_method, // 'user'=>$session_user, // 'global_system_settings'=>$global_system_settings, 'request'=>$_REQUEST, ); call_user_func($function_name,$parameters); }else{ echo "Invalid Request."; exit; } function create_file($param){ $db = $param['db']; $utility_class = $param['utility_class']; $upload_class = $param['upload_class']; $request = $param['request']; switch($request['file']){ case 'videos': $target_dir = dirname(__FILE__) . '../../../dist/'.$request['file'];; break; case 'knowledgebase': $target_dir = dirname(__FILE__) . '../../../dist/'.$request['file']; break; case 'video_attach': $target_dir = dirname(__FILE__) . '../../../dist/videos/resources'; break; default: $target_dir = dirname(__FILE__) . '../../../dist/attachments'; } $response = $upload_class->create_attachment($_FILES['file'],$target_dir,$utility_class,$db); echo json_encode($response); } function delete_file($param){ $db = $param['db']; $utility_class = $param['utility_class']; $upload_class = $param['upload_class']; $request = $param['request']; $files = json_decode($request['file_names'],true); switch($request['file']){ case 'videos': $target_dir = dirname(__FILE__) . '../../../dist/'.$request['file']; break; case 'knowledgebase': $target_dir = dirname(__FILE__) . '../../../dist/'.$request['file']; break; case 'video_attach': $target_dir = dirname(__FILE__) . '../../../dist/videos/resources'; break; default: $target_dir = dirname(__FILE__) . '../../../dist/attachments'; } // $target_dir = dirname(__FILE__) . '../../../dist/attachments'; $response = $upload_class->delete_attachment($files, $target_dir); $return_arr['message'] = "Files has been deleted."; $return_arr['status'] = 1; echo json_encode($return_arr); } ?>��index.php��0000644��00000000000�15024755361�0006362 0��ustar�00��knowledgebase.php��0000644��00000144065�15024755361�0010111 0��ustar�00��<?php if(isset($_REQUEST['api'])){ include_once dirname(__FILE__) . '/../../cfg/db_api.php'; }else{ include_once dirname(__FILE__) . '/../../cfg/db.php'; // if(!intval($global_user_status)){ // echo $global_user_message; // exit; // } } include_once dirname(__FILE__) . '/../../app/classes/knowledgebase_class.php'; include_once dirname(__FILE__) . '/../../app/classes/ticket_class.php'; include_once dirname(__FILE__) . '/../../app/classes/brand_class.php'; include_once dirname(__FILE__) . '/../../app/classes/model_class.php'; include_once dirname(__FILE__) . '/../../app/classes/upload_class.php'; include_once dirname(__FILE__) . '/../../app/classes/user_class.php'; include_once dirname(__FILE__) . '/../../app/classes/utility.php'; $utility_class = new Utility(); $knowledgebase_class = new Knowledgebase(); $ticket_class = new Ticket(); $brand_class = new Brand(); $model_class = new Model(); $user_class = new User(); $upload_class = new Upload(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['model'])){ $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db'=>$db, 'utility_class'=>$utility_class, 'brand_class'=>$brand_class, 'model_class'=>$model_class, 'user_class'=>$user_class, 'knowledgebase_class'=>$knowledgebase_class, 'ticket_class'=>$ticket_class, 'upload_class'=>$upload_class, 'server_method'=>$server_method, 'user_session'=>$session_user, 'session_access'=>$session_access, 'global_system_settings'=>$global_system_settings, 'request'=>$_REQUEST, ); call_user_func($function_name,$parameters); }else{ echo "Invalid Request."; exit; } function read_knowledgebase_information($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $knowledgebase_id = $request['knowledgebase_id']; $knowledgebase_info_obj = $knowledgebase_class->read_knowledgebase_information($knowledgebase_id,$utility_class,$db); $json = array(); foreach($knowledgebase_info_obj as $row){ $row = $utility_class->arrayNullToBlank($row); $display_name = $row['firstname']. ' '.substr($row['lastname'],0,1); $json = array( 'lbl_kb_subject'=>$row['title'], 'lbl_kb_description'=>$row['description'], 'lbl_kb_category'=>$row['sub_category'], 'lbl_kb_posted_by'=>$display_name, 'lbl_v_kb_brand'=>$row['brand'], 'lbl_v_kb_model'=>$row['model'], 'lbl_v_kb_mv'=>$row['model_variant'], 'lbl_kb_posted_date'=>$row['date_addedf'], 'lbl_ticket_fault_codes'=>$row['fault_codes'], 'category_id'=>$row['category_id'], 'show_vehicle'=>$row['show_vehicle'], 'kb_vehicle_id'=>$row['knowledgebase_vehicle_id'], ); } echo json_encode($json); } function read_knowledgebase_data($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $knowledgebase_id = $request['knowledgebase_id']; $json['rows'] = array(); $json['attachments'] = array(); $knowledgebase_id = $request['knowledgebase_id']; $knowledgebase_info_obj = $knowledgebase_class->read_knowledgebase_information($knowledgebase_id,$utility_class,$db); foreach($knowledgebase_info_obj as $row){ $row = $utility_class->arrayNullToBlank($row); $json['rows'] = array( 'category'=>$row['sub_category'], 'section'=>$row['section'], 'title'=>$row['title'], 'description'=>$row['description'], 'fault_codes'=>$row['fault_codes'], // 'sub_category_id'=>$row['sub_category_id'], // 'sub_category'=>$row['sub_category'], // 'subject'=>$row['title'], // 'description'=>$row['description'], // 'priority_id'=>$row['priority_level_id'], // 'priority_level'=>$row['priority_level'], // // 'brand_id'=>$row['brand_id'], 'brand'=>$row['brand'], // 'model_id'=>$row['model_id'], 'model'=>$row['model'], 'model_variant_id'=>$row['model_variant_id'], 'model_variant'=>$row['model_variant'], // 'year_model'=>$row['year_model'], // 'plate_cs'=>$row['plate_cs'], // 'vin'=>$row['vin'], // 'category_id'=>$row['category_id'], // 'knowledgebase_status_id'=>$row['knowledgebase_status_id'], // 'knowledgebase_status'=>$row['knowledgebase_status'], ); } $knowledgebase_attach_obj = $knowledgebase_class->read_knowledgebase_attachments($knowledgebase_id,$utility_class,$db); foreach($knowledgebase_attach_obj as $row){ $file = dirname(__FILE__) . '/../../dist/knowledgebase/'.$row['attachment_name']; $unreadable_size = (is_file($file) ? filesize($file) : 0 ); $readable_file_size = $utility_class->humanFileSize($unreadable_size); $file_ext = pathinfo($file, PATHINFO_EXTENSION); $fa_icon = $utility_class->getFileIcon($file_ext); $json['attachments'] = array_merge($json['attachments'],array(array( 'id'=>$row['id'], 'change_name'=>$row['attachment_name'], 'original_name'=>$row['original_name'], 'date'=>$row['date_addedf'], 'size'=>$readable_file_size, 'unreadable_size'=>$unreadable_size, 'icon'=>$fa_icon, ))); } echo json_encode($json); } function create_knowledgebase($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $user_session = $param['user_session']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $is_new_kb = $request['is_new_kb']; $knowledgebase_attachments = json_decode($request['attachments'],true); $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = $db->escape($array_data[$key]); } $knowledgebase_id = $request['knowledgebase_id']; // get category id $sub_category_id = $ticket_class->read_sub_category_id_by_name($array_data['category'],$utility_class,$db); // get section id $section_id = $ticket_class->read_section_id_by_name($array_data['section'],$utility_class,$db); // get main category id $category_obj = $ticket_class->read_category_id_by_sub_category_id($sub_category_id,$utility_class,$db); $category_arr = array(); foreach($category_obj as $category_row){ $category_arr = $category_row; } $cat_show_vehicle = $category_arr['show_vehicle']; $category_id = $category_arr['category_id']; if(intval($cat_show_vehicle) === 1){ //means vehicle // get brand id if($utility_class->isNotEmpty($array_data['brand'])){ $brand_id = $brand_class->read_brand_id_by_name($array_data['brand'],$utility_class,$db); }else{ $brand_id = ""; } if($utility_class->isNotEmpty($array_data['model']) && $utility_class->isNotEmpty($brand_id)){ $model_id = $model_class->read_model_id_by_name_n_brand_id($brand_id,$array_data['model'],$utility_class,$db); }else{ $model_id = ""; } // get model variant id $model_variant_id = $array_data['model_variant_id']; if(!$utility_class->isNotEmpty($model_variant_id) && $utility_class->isNotEmpty($array_data['model_variant']) && $utility_class->isNotEmpty($model_id)){ $model_variant_id = $model_class->insert_model_variant($model_id,$array_data['model_variant'],$utility_class,$db); } // echo $is_new_kb;exit; if($is_new_kb){ $knowledgebase_id = $knowledgebase_class->create_knowledgebase($user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$utility_class,$db); $knowledgebase_class->create_vehicle_type_knowledgebase($knowledgebase_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db); }else{ $knowledgebase_class->update_knowledgebase($knowledgebase_id,$user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$utility_class,$db); $knowledgebase_type_vehicle_obj = $knowledgebase_class->read_vehicle_type_knowledgebase($knowledgebase_id,$utility_class,$db); $knowledgebase_type_vehicle_arr = array(); foreach($knowledgebase_type_vehicle_obj as $row_vehicle_type){ $knowledgebase_type_vehicle_arr = $row_vehicle_type; } if(count($knowledgebase_type_vehicle_arr) > 0){ $knowledgebase_class->update_vehicle_type_knowledgebase($knowledgebase_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db); }else{ $knowledgebase_class->create_vehicle_type_knowledgebase($knowledgebase_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db); } } }else{ if($is_new_kb){ // Insert no type (general) ticket and no $knowledgebase_id = $knowledgebase_class->create_knowledgebase($user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$utility_class,$db); }else{ $knowledgebase_class->update_knowledgebase($knowledgebase_id,$user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$utility_class,$db); $knowledgebase_class->update_vehicle_type_knowledgebase_status($knowledgebase_id,0,$utility_class,$db); } } foreach($knowledgebase_attachments as $knowledgebase_attachment){ $knowledgebase_class->create_knowledgebase_attachment($knowledgebase_id,$knowledgebase_attachment['change_name'],$knowledgebase_attachment['original_name'],$utility_class,$db); } if(!$is_new_kb){ // update remove attachments $attachment_ids_arr = json_decode($request['remove_attachments'],true); if(count($attachment_ids_arr) > 0){ $attachment_ids = implode(',', $attachment_ids_arr); $knowledgebase_class->update_knowledgebase_attachment_status($attachment_ids,0,$utility_class,$db); } } if($is_new_kb){ $return_arr['message'] = "Article has been added."; }else{ $return_arr['message'] = "Article has been updated."; } $return_arr['id'] = $knowledgebase_id; $return_arr['status'] = 1; echo json_encode($return_arr); } function read_knowledgebase_attachments($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $knowledgebase_id = $request['knowledgebase_id']; $knowledgebase_info_obj = $knowledgebase_class->read_knowledgebase_attachments($knowledgebase_id,$utility_class,$db); $json = array(); foreach($knowledgebase_info_obj as $row){ $file = dirname(__FILE__) . '/../../dist/knowledgebase/'.$row['attachment_name']; $readable_file_size = $utility_class->humanFileSize((is_file($file) ? filesize($file) : 0 )); $file_ext = pathinfo($file, PATHINFO_EXTENSION); $fa_icon = $utility_class->getFileIcon($file_ext); $json[] = array( 'id'=>$row['id'], 'change_name'=>$row['attachment_name'], 'original_name'=>$row['original_name'], 'date'=>$row['date_addedf'], 'size'=>$readable_file_size, 'icon'=>$fa_icon, ); } echo json_encode($json); } function read_knowledgebase_list($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_session = $param['user_session']; $session_access = $param['session_access']; $brand_access_arr = $user_session['json_brand']; $request = $param['request']; $array_data = array(); $search = isset($request['search']) ? $db->escape($request['search']) : '' ; $offset = $request['offset']; $limit = $request['limit']; $owned_kb_only = isset($request['owned_kb_only']) ? $request['owned_kb_only'] : '' ; $short_description = isset($request['short_description']) ? $request['short_description'] : '' ; $filter_start_date = isset($request['start_date']) ? $request['start_date'] : '' ; //$request['start_date']; $filter_end_date = isset($request['end_date']) ? $request['end_date'] : '' ; //$request['end_date']; $filter_src_type = isset($request['filter_type']) ? $request['filter_type'] : '' ; $filter_brand_id = isset($request['filter_brand']) && ($utility_class->isNotEmpty($request['filter_brand']))? $brand_class->read_brand_id_by_name($request['filter_brand'],$utility_class,$db) : ''; $filter_model_id = (isset($request['filter_model']) && $utility_class->isNotEmpty($request['filter_model']))? $model_class->read_model_id_by_name_n_brand_id($filter_brand_id,$request['filter_model'],$utility_class,$db) : ''; // if(!(isset($session_access['4']) && in_array('4_3', $session_access['4']))){ // $ait_access= ""; // }else{ // $ait_access= " AND ks.id IS NULL"; // } //enable if empty section or no access in ait if( (isset($request['filter_section']) && ($request['filter_section'] == 'EMPTY_SECTION')) \|\| !(isset($session_access['4']) && in_array('4_3', $session_access['4'])) ){ $array_data['all_null_section'] = 1; } $filter_section_id = isset($request['filter_section']) && ($utility_class->isNotEmpty($request['filter_section']))? $ticket_class->read_section_id_by_name($request['filter_section'],$utility_class,$db) : ''; $req_filter_category = isset($request['filter_category']) ? $request['filter_category'] : '[]' ; $filter_category = json_decode($req_filter_category,true); $filter_category_ids = array(); if(count($filter_category) > 0){ $filter_category_names = "'" . implode("','", $filter_category) . "'"; $category_id_list_obj = $ticket_class->read_ticket_sub_category_ids_by_names($filter_category_names,$utility_class,$db); foreach($category_id_list_obj as $category_id_list){ $filter_category_ids[] = $category_id_list['id']; } } $filter_category_ids_str = count($filter_category_ids) > 0 ? implode(",",$filter_category_ids) : '' ; // $req_filter_final_status = isset($request['filter_final_status']) ? $request['filter_final_status'] : '[]' ; // // Filter by final Status // $filter_final_status = json_decode($req_filter_final_status,true); // $filter_final_status_ids = array(); // if(count($filter_final_status) > 0){ // $filter_final_status_names = "'" . implode("','", $filter_final_status) . "'"; // $status_id_list_obj = $ticket_class->read_ticket_final_status_ids_by_names($filter_final_status_names,$utility_class,$db); // foreach($status_id_list_obj as $status_id_list){ // $filter_final_status_ids[] = $status_id_list['id']; // } // } // $filter_final_status_ids_str = count($filter_final_status_ids) > 0 ? implode(",",$filter_final_status_ids) : '' ; // $filter_escalated_status = array(); // if(in_array('Escalated (Solve)',$filter_final_status)){ // $filter_escalated_status[] = 1; // } // $filter_escalated_str = count($filter_escalated_status) > 0 ? implode(",",$filter_escalated_status) : '' ; $universal_knowledgebase_query = $knowledgebase_class->universal_knowledgebase_query(); $universal_ticket_query = $ticket_class->universal_ticket_query(); $display_union_count = 50; $kb_list_array = $knowledgebase_class->read_knowledgebase_list($user_session['id'], $array_data, $filter_src_type, $owned_kb_only, $short_description, $filter_category_ids_str, $filter_brand_id, $filter_model_id, $filter_section_id, $brand_access_arr, $search, $filter_start_date, $filter_end_date, $offset, $limit, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db); $json_arr['total'] = (intval($kb_list_array[0]) < ($display_union_count2)) ? $kb_list_array[0] : ($display_union_count2) ; //$kb_list_array[0]; $kb_list_obj = $kb_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach($kb_list_obj as $row){ // $row = $utility_class->arrayNullToBlank($row); // $final_status = $utility_class->isNotEmpty($row['final_status']) ? $row['status']. ' ('.$row['final_status'].')' : $row['status'] ; // $final_status = $utility_class->isNotEmpty($row['final_status']) ? $row['status']. ' ('.$row['final_status'].')' : $row['status'] ; $display_name = $row['firstname']. ' '.substr($row['lastname'],0,1); $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'no'=>$counter++, 'id'=>$row['id'], 'source'=>$row['source'], 'date'=>$row['date_addedf'], 'datew'=>date("M. j, Y", strtotime($row['date_addedf'])), 'category'=>$row['sub_category'], 'vehicle'=>$row['brand'].' - '.$row['model'], 'title'=>$row['title'], 'descriptionf'=>$row['descriptionf'], 'created_by'=>$display_name, // 'status'=>$row['final_status'], // 'final_status_id'=>$row['final_status_id'], )) ); } echo json_encode($json_arr); } function read_knowledgebase_video_autocomplete($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $request = $param['request']; $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; // print_r($request);exit; $search = isset($request['search']) ? $db->escape($request['search']) : '' ; $offset = $request['offset']; $limit = $request['limit']; $list_obj = $knowledgebase_class->read_knowledgebase_video_autocomplete( $search, $offset, $limit, $utility_class,$db); $json_arr['rows'] = array(); foreach($list_obj as $row){ $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id'=>$row['id'], 'text'=>$row['title'], )) ); } echo json_encode($json_arr); } function read_knowledgebase_list_autocomplete($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : '' ; $offset = $request['offset']; $limit = $request['limit']; $universal_knowledgebase_query = $knowledgebase_class->universal_knowledgebase_query(); $universal_ticket_query = $ticket_class->universal_ticket_query(); $display_union_count = 50; $kb_list_obj = $knowledgebase_class->read_knowledgebase_list_autocomplete( $search, $offset, $limit, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db); $json_arr['rows'] = array(); foreach($kb_list_obj as $row){ // $row = $utility_class->arrayNullToBlank($row); // $final_status = $utility_class->isNotEmpty($row['final_status']) ? $row['status']. ' ('.$row['final_status'].')' : $row['status'] ; // $final_status = $utility_class->isNotEmpty($row['final_status']) ? $row['status']. ' ('.$row['final_status'].')' : $row['status'] ; $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'id'=>$row['id'], 'text'=>$row['title'], )) ); } echo json_encode($json_arr); } function read_related_articles($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_session = $param['user_session']; $request = $param['request']; $brand_access_arr = $user_session['json_brand']; $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = $db->escape($array_data[$key]); } $title = $array_data['title']; $fault_codes = $array_data['fault_codes']; $offset = $request['offset']; $limit = $request['limit']; $sub_category_id = $ticket_class->read_sub_category_id_by_name($array_data['category'],$utility_class,$db); // get main category id $category_obj = $ticket_class->read_category_id_by_sub_category_id($sub_category_id,$utility_class,$db); $category_arr = array(); foreach($category_obj as $category_row){ $category_arr = $category_row; } $cat_show_vehicle = $category_arr['show_vehicle']; $category_id = $category_arr['category_id']; if($utility_class->isNotEmpty($array_data['brand'])){ $brand_id = $brand_class->read_brand_id_by_name($array_data['brand'],$utility_class,$db); }else{ $brand_id = ""; } if($utility_class->isNotEmpty($array_data['model'])){ $model_id = $model_class->read_model_id_by_name_n_brand_id($brand_id,$array_data['model'],$utility_class,$db); }else{ $model_id = ""; } if($utility_class->isNotEmpty($array_data['model_variant_id'])){ $model_variant_id = $array_data['model_variant_id']; }else{ $model_variant_id =""; } $universal_knowledgebase_query = $knowledgebase_class->universal_knowledgebase_query(); $universal_ticket_query = $ticket_class->universal_ticket_query(); $display_union_count = 50; $kb_list_array = $knowledgebase_class->read_related_articles( $title, $fault_codes, $sub_category_id, $brand_id, $model_id, $model_variant_id, $brand_access_arr, $offset, $limit, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db); $json_arr['total'] = (intval($kb_list_array[0]) < ($display_union_count2)) ? $kb_list_array[0] : ($display_union_count2) ; //$kb_list_array[0]; $kb_list_obj = $kb_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach($kb_list_obj as $row){ // $row = $utility_class->arrayNullToBlank($row); // $final_status = $utility_class->isNotEmpty($row['final_status']) ? $row['status']. ' ('.$row['final_status'].')' : $row['status'] ; // $final_status = $utility_class->isNotEmpty($row['final_status']) ? $row['status']. ' ('.$row['final_status'].')' : $row['status'] ; $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'no'=>$counter++, 'id'=>$row['id'], 'source'=>$row['source'], 'date'=>$row['date_addedf'], 'datew'=>date("F j, Y", strtotime($row['date_addedf'])), 'category'=>$row['sub_category'], 'vehicle'=>$row['brand'].' - '.$row['model'], 'title'=>$row['title'], 'descriptionf'=>$row['descriptionf'], // 'status'=>$row['final_status'], // 'final_status_id'=>$row['final_status_id'], )) ); } echo json_encode($json_arr); } function create_video($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $request = $param['request']; $user_session = $param['user_session']; $is_new_video = $request['is_new_video']; $user_class = $param['user_class']; $send_notif = $request['send_notif']; $global_system_settings = $param['global_system_settings']; $position_data = $request['position_data']; $position_data_arr = json_decode($position_data,true); $array_data = json_decode($request['json_data'],true); foreach ($array_data as $key => $value){ $array_data[$key] = $db->escape($array_data[$key]); } $knowledgebase_attachments = json_decode($request['rsc_attachments'],true); $ticket_attachments = json_decode($request['attachments'],true); $ticket_attachments_arr = array(); foreach($ticket_attachments as $ticket_attachment){ $ticket_attachments_arr = $ticket_attachment; break; } // print_r($ticket_attachments_arr);exit; // get category id $sub_category_id = $ticket_class->read_sub_category_id_by_name($array_data['category'],$utility_class,$db); // get section id $section_id = $ticket_class->read_section_id_by_name($array_data['section'],$utility_class,$db); // get main category id $category_obj = $ticket_class->read_category_id_by_sub_category_id($sub_category_id,$utility_class,$db); $category_arr = array(); foreach($category_obj as $category_row){ $category_arr = $category_row; } $cat_show_vehicle = $category_arr['show_vehicle']; $category_id = $category_arr['category_id']; // get priority id // $priority_id = $ticket_class->read_priority_level_id_by_name($array_data['priority_level'],$utility_class,$db); // insert main ticket $video_id = 0; // $array_data['description'] = str_replace("\\n","<br>",$array_data['description']); // echo $array_data['description'];exit; //if the sub category is under vehicle catgory execute this // current Vehicle Category is 2, change it depends to your database category table if(intval($cat_show_vehicle) === 1){ // get brand id if($utility_class->isNotEmpty($array_data['brand'])){ $brand_id = $brand_class->read_brand_id_by_name($array_data['brand'],$utility_class,$db); }else{ $brand_id = ""; } if($utility_class->isNotEmpty($array_data['model']) && $utility_class->isNotEmpty($brand_id)){ $model_id = $model_class->read_model_id_by_name_n_brand_id($brand_id,$array_data['model'],$utility_class,$db); }else{ $model_id = ""; } // get model variant id $model_variant_id = $array_data['model_variant_id']; if(!$utility_class->isNotEmpty($model_variant_id) && $utility_class->isNotEmpty($array_data['model_variant']) && $utility_class->isNotEmpty($model_id)){ $model_variant_id = $model_class->insert_model_variant($model_id,$array_data['model_variant'],$utility_class,$db); } // echo $is_new_video;exit; if($is_new_video){ $video_id = $knowledgebase_class->create_video($user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$ticket_attachments_arr['original_name'],$ticket_attachments_arr['change_name'],$utility_class,$db); $knowledgebase_class->create_vehicle_type_video($video_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db); }else{ $video_id = $request['video_id']; $knowledgebase_class->update_video($video_id,$user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$utility_class,$db); $video_type_vehicle_obj = $knowledgebase_class->read_vehicle_type_video($video_id,$utility_class,$db); $video_type_vehicle_arr = array(); foreach($video_type_vehicle_obj as $row_vehicle_type){ $video_type_vehicle_arr = $row_vehicle_type; } // echo $video_type_vehicle_arr;exit; if(count($video_type_vehicle_arr) > 0){ $knowledgebase_class->update_vehicle_type_video($video_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db); }else{ $knowledgebase_class->create_vehicle_type_video($video_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db); } } }else{ if($is_new_video){ // Insert no type (general) ticket and no $video_id = $knowledgebase_class->create_video($user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$ticket_attachments_arr['original_name'],$ticket_attachments_arr['change_name'],$utility_class,$db); }else{ $video_id = $request['video_id']; $knowledgebase_class->update_video($video_id,$user_session['id'],$sub_category_id,$section_id,$array_data['title'],$array_data['description'],$array_data['fault_codes'],$utility_class,$db); $knowledgebase_class->update_vehicle_type_video_status($video_id,0,$utility_class,$db); } } // print_r($knowledgebase_attachments);exit; foreach($knowledgebase_attachments as $knowledgebase_attachment){ $knowledgebase_class->create_video_attachment($video_id,$knowledgebase_attachment['change_name'],$knowledgebase_attachment['original_name'],$utility_class,$db); } if(!$is_new_video){ // update remove attachments $attachment_ids_arr = json_decode($request['rsc_remove_attachments'],true); if(count($attachment_ids_arr) > 0){ $attachment_ids = implode(',', $attachment_ids_arr); $knowledgebase_class->update_video_attachment_status($attachment_ids,0,$utility_class,$db); } } $knowledgebase_class->create_video_access($video_id,$position_data,$utility_class,$db); if($is_new_video && count($position_data_arr) > 0 && $send_notif ){ $array_data['target_json'] = $position_data; $array_data['target_id'] = $video_id; $array_data['api_type'] = 1; $array_data['data_type'] = 1; //table of this will remove // $user_class->create_api_notifications($array_data,$utility_class,$db); // $query = "SELECT * FROM `cnf_api_notifications` WHERE 1 AND api_type = 1 AND data_type = 1 AND status = 1"; // $api_notif_obj = $db->sql_query($query); // foreach($api_notif_obj as $api_notif_row){ // $db->sql_query("UPDATE `cnf_api_notifications` SET `status`=0 WHERE 1 AND id = ".$api_notif_row['id'].""); $utility_class -> curl_me_async( $global_system_settings['url']."api/v1/viber/send_video_notification.php", array("json"=>'{"target_id":"'.$array_data['target_id'].'","type":1,"target_json":'.$array_data['target_json'].'}'), 'POST'); // echo '{"target_id":"'.$api_notif_row['target_id'].'","type":1,"target_json":'.$api_notif_row['target_json'].'} ....'; // } } if($is_new_video){ $return_arr['message'] = "Video has been added."; }else{ $return_arr['message'] = "Video has been updated."; } $return_arr['id'] = $video_id; $return_arr['status'] = 1; echo json_encode($return_arr); } function read_video_viewers($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $user_session = $param['user_session']; $video_id = $request['video_id']; $offset = $request['offset']; $limit = $request['limit']; $search = isset($request['search']) ? $db->escape($request['search']) : '' ; $order = $request['order']; $data_obj = $knowledgebase_class->read_video_viewers($video_id,$search,$offset,$limit,$order,$utility_class,$db); $json['rows'] = array(); foreach($data_obj as $row){ $json['rows'] = array_merge($json['rows'],array(array( 'id'=>$row['id'], 'user'=>$row['firstname'].' '.$row['lastname'], 'id_number'=> $row['id_number'], 'date_added'=>$row['date_addedf'], ))); } echo json_encode($json); } function read_videos($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_class = $param['user_class']; $request = $param['request']; $session_access = $param['session_access']; $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; $owned_video_only = isset($request['owned_video_only']) ? $request['owned_video_only'] : '' ; $array_data = array(); $search = isset($request['search']) ? $db->escape($request['search']) : '' ; $offset = $request['offset']; $limit = $request['limit']; $filter_category = json_decode(isset($request['filter_category']) ? $request['filter_category'] : "[]",true); $filter_category_ids = array(); if(count($filter_category) > 0){ $filter_category_names = "'" . implode("','", $filter_category) . "'"; $category_id_list_obj = $ticket_class->read_ticket_sub_category_ids_by_names($filter_category_names,$utility_class,$db); foreach($category_id_list_obj as $category_id_list){ $filter_category_ids[] = $category_id_list['id']; } } $filter_category_ids_str = count($filter_category_ids) > 0 ? implode(",",$filter_category_ids) : '' ; $filter_brand_id = isset($request['filter_brand']) && $utility_class->isNotEmpty($request['filter_brand']) ? $brand_class->read_brand_id_by_name($request['filter_brand'],$utility_class,$db) : ''; $filter_model_id = isset($request['filter_model']) && $utility_class->isNotEmpty($request['filter_model']) ? $model_class->read_model_id_by_name_n_brand_id($filter_brand_id,$request['filter_model'],$utility_class,$db) : ''; $filter_position_id = isset($request['filter_position']) && $utility_class->isNotEmpty($request['filter_position']) ? $user_class->read_position_id_by_name($request['filter_position'],$utility_class,$db) : ''; if( (isset($request['filter_section']) && ($request['filter_section'] == 'EMPTY_SECTION')) \|\| !(isset($session_access['5']) && in_array('5_4', $session_access['5'])) ){ $array_data['all_null_section'] = 1; } $filter_section_id = isset($request['filter_section']) && ($utility_class->isNotEmpty($request['filter_section']))? $ticket_class->read_section_id_by_name($request['filter_section'],$utility_class,$db) : ''; // print_r($user_session);exit; if($utility_class->isNotEmpty($filter_position_id)){ $position_ids_arr = array($user_session['position_id'],$filter_position_id); }else{ $position_ids_arr = array($user_session['position_id']); } $video_list_array = $knowledgebase_class->read_video_list($user_session['id'],$array_data,$position_ids_arr,$owned_video_only,$filter_category_ids_str,$filter_brand_id,$filter_model_id,$filter_section_id,$brand_access_arr,$search,$offset,$limit,$utility_class,$db); $json_arr['total'] = $video_list_array[0]; $video_list_obj = $video_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach($video_list_obj as $row){ $row = $utility_class->arrayNullToBlank($row); $file = dirname(__FILE__) . '/../../dist/videos/'.$row['attachment_name']; $readable_file_size = $utility_class->humanFileSize((is_file($file) ? filesize($file) : 0 )); $json_arr['rows'] = array_merge($json_arr['rows'], array(array( 'no'=>$counter++, 'id'=>$row['id'], 'date'=>$row['date_addedf'], 'original_name'=>$row['original_name'], 'attachment_name'=>$row['attachment_name'], 'title'=>$row['title'], 'description'=>$row['description'], 'descriptionf'=>$row['descriptionf'], 'size'=>$readable_file_size, 'brand'=>$row['brand'], 'model'=>$row['model'], 'model_variant'=>$row['model_variant'], // 'category'=>$row['sub_category'], // 'vehicle'=>$row['brand'].' - '.$row['model'], // 'plate_cs'=>$row['plate_cs'], // 'title'=>$row['title'], // 'priority'=>$row['priority_level'], // 'status'=>$row['status'], )) ); } echo json_encode($json_arr); } function read_ticket_attachments($param){ $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $ticket_id = $request['ticket_id']; $ticket_info_obj = $ticket_class->read_ticket_attachments($ticket_id,$utility_class,$db); $json = array(); foreach($ticket_info_obj as $row){ $file = dirname(__FILE__) . '/../../dist/attachments/'.$row['attachment_name']; $readable_file_size = $utility_class->humanFileSize((is_file($file) ? filesize($file) : 0 )); $file_ext = pathinfo($file, PATHINFO_EXTENSION); $fa_icon = $utility_class->getFileIcon($file_ext); $json[] = array( 'id'=>$row['id'], 'change_name'=>$row['attachment_name'], 'original_name'=>$row['original_name'], 'date'=>$row['date_addedf'], 'size'=>$readable_file_size, 'icon'=>$fa_icon, ); } echo json_encode($json); } function delete_video($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $user_session = $param['user_session']; $video_id = $request['video_id']; $knowledgebase_class->update_video_status($video_id,0,$utility_class,$db); $json['message'] = "Successfully removed."; echo json_encode($json); } function create_watched_video($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $user_session = $param['user_session']; $video_id = $request['video_id']; $watched_video_id = $knowledgebase_class->read_watched_video($video_id,$user_session['id'],$utility_class,$db); if(!$utility_class->isNotEmpty($watched_video_id)){ $knowledgebase_class->create_watched_video($video_id,$user_session['id'],$utility_class,$db); } $json['status'] = 1; $json['message'] = "Successful."; echo json_encode($json); } function read_video_data($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $video_id = $request['video_id']; $json['rows'] = array(); $json['attachments'] = array(); $video_info_obj = $knowledgebase_class->read_video_information($video_id,$utility_class,$db); foreach($video_info_obj as $row){ $row = $utility_class->arrayNullToBlank($row); // $file = dirname(__FILE__) . '/../../dist/videos/'.$row['attachment_name']; // $readable_file_size = $utility_class->humanFileSize((is_file($file) ? filesize($file) : 0 )); $display_name = $row['firstname']. ' '.substr($row['lastname'],0,1); $display_name = ucwords(strtolower($display_name)); $json['rows'] = array( 'id'=>$row['id'], 'date'=>$row['date_addedf'], 'user'=>'Created by '.$display_name.' on '.$row['date_addedf'], 'original_name'=>$row['original_name'], 'attachment_name'=>$row['attachment_name'], 'title'=>$row['title'], 'description'=>$row['description'], 'category'=>$row['sub_category'], 'section'=>$row['section'], 'brand'=>$row['brand'], 'model'=>$row['model'], 'fault_codes'=>$row['fault_codes'], 'model_variant'=>$row['model_variant'], 'model_variant_id'=>$row['model_variant_id'], 'position_access'=>$row['json_data'], ); } $attach_obj = $knowledgebase_class->read_video_attachments($video_id,$utility_class,$db); foreach($attach_obj as $row){ $file = dirname(__FILE__) . '/../../dist/videos/resources/'.$row['attachment_name']; $unreadable_size = (is_file($file) ? filesize($file) : 0 ); $readable_file_size = $utility_class->humanFileSize($unreadable_size); $file_ext = pathinfo($file, PATHINFO_EXTENSION); $fa_icon = $utility_class->getFileIcon($file_ext); $json['attachments'] = array_merge($json['attachments'],array(array( 'id'=>$row['id'], 'change_name'=>$row['attachment_name'], 'original_name'=>$row['original_name'], 'date'=>$row['date_addedf'], 'size'=>$readable_file_size, 'unreadable_size'=>$unreadable_size, 'icon'=>$fa_icon, ))); } echo json_encode($json); } function read_video_information($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $request = $param['request']; $video_id = $request['video_id']; $json['rows'] = array(); $json['attachments'] = array(); $video_info_obj = $knowledgebase_class->read_video_information($video_id,$utility_class,$db); foreach($video_info_obj as $row){ $row = $utility_class->arrayNullToBlank($row); // $file = dirname(__FILE__) . '/../../dist/videos/'.$row['attachment_name']; // $readable_file_size = $utility_class->humanFileSize((is_file($file) ? filesize($file) : 0 )); $display_name = $row['firstname']. ' '.substr($row['lastname'],0,1); $display_name = ucwords(strtolower($display_name)); $json['rows'] = array( 'id'=>$row['id'], 'date'=>$row['date_addedf'], 'user'=>'Created by '.$display_name.' on '.$row['date_addedf'], 'original_name'=>$row['original_name'], 'attachment_name'=>$row['attachment_name'], 'title'=>$row['title'], 'lbl_description'=>str_replace("\n","<br>",$row['description']), //$row['description'], 'lbl_category'=>$row['sub_category'], 'v_view_brand'=>$row['brand'], 'v_view_model'=>$row['model'], 'v_view_model_variant'=>$row['model_variant'], 'model_variant_id'=>$row['model_variant_id'], 'lbl_ticket_fault_codes'=>$row['fault_codes'], ); } $attach_obj = $knowledgebase_class->read_video_attachments($video_id,$utility_class,$db); foreach($attach_obj as $row){ $file = dirname(__FILE__) . '/../../dist/videos/resources/'.$row['attachment_name']; $unreadable_size = (is_file($file) ? filesize($file) : 0 ); $readable_file_size = $utility_class->humanFileSize($unreadable_size); $file_ext = pathinfo($file, PATHINFO_EXTENSION); $fa_icon = $utility_class->getFileIcon($file_ext); $json['attachments'] = array_merge($json['attachments'],array(array( 'id'=>$row['id'], 'change_name'=>$row['attachment_name'], 'original_name'=>$row['original_name'], 'date'=>$row['date_addedf'], 'size'=>$readable_file_size, 'unreadable_size'=>$unreadable_size, 'icon'=>$fa_icon, ))); } echo json_encode($json); } function read_sub_categories_content_count($param){ $db = $param['db']; $utility_class = $param['utility_class']; $knowledgebase_class = $param['knowledgebase_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; $session_access = $param['session_access']; $universal_knowledgebase_query = $knowledgebase_class->universal_knowledgebase_query(); $universal_ticket_query = $ticket_class->universal_ticket_query(); $display_union_count = 0; $knowledgebase_cat_obj = $knowledgebase_class->read_sub_category_count_v2( $session_access, $brand_access_arr, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db); $knowledgebase_cat_arr = array(); foreach($knowledgebase_cat_obj as $knowledgebase_cat){ $knowledgebase_cat_arr = array_merge($knowledgebase_cat_arr, array(array( 'id'=>$knowledgebase_cat['id'], 'name'=>$knowledgebase_cat['name'], 'count'=>$knowledgebase_cat['sub_category_count'], ))); } $category_list_obj = $ticket_class->read_sub_categories('',$utility_class,$db); $category_list_arr = array(); foreach($category_list_obj as $row){ $knowledgebase_count = 0; foreach($knowledgebase_cat_arr as $knowledgebase_cat_row){ if($row['id'] == $knowledgebase_cat_row['id']){ $knowledgebase_count = $knowledgebase_cat_row['count']; } } $category_list_arr = array_merge($category_list_arr,array(array( 'id'=>$row['id'], 'name'=>$row['name'], 'count'=>$knowledgebase_count, ))); } echo json_encode($category_list_arr); } ?>��ticket.php��0000644��00000250214�15024755361�0006554 0��ustar�00��<?php if (isset($_REQUEST['api'])) { include_once dirname(__FILE__) . '/../../cfg/db_api.php'; } else { include_once dirname(__FILE__) . '/../../cfg/db.php'; // if(!intval($global_user_status)){ // echo $global_user_message; // exit; // } } include_once dirname(__FILE__) . '/../../app/classes/ticket_class.php'; include_once dirname(__FILE__) . '/../../app/classes/brand_class.php'; include_once dirname(__FILE__) . '/../../app/classes/model_class.php'; include_once dirname(__FILE__) . '/../../app/classes/upload_class.php'; include_once dirname(__FILE__) . '/../../app/classes/user_class.php'; include_once dirname(__FILE__) . '/../../app/classes/sms_class.php'; include_once dirname(__FILE__) . '/../../app/classes/utility.php'; $utility_class = new Utility(); $ticket_class = new Ticket(); $brand_class = new Brand(); $model_class = new Model(); $user_class = new User(); $sms_class = new Sms(); $upload_class = new Upload(); $server_method = $_SERVER["REQUEST_METHOD"]; if (isset($_REQUEST['model'])) { $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db' => $db, 'utility_class' => $utility_class, 'brand_class' => $brand_class, 'model_class' => $model_class, 'ticket_class' => $ticket_class, 'sms_class' => $sms_class, 'upload_class' => $upload_class, 'server_method' => $server_method, 'user_class' => $user_class, 'global_system_settings' => $global_system_settings, 'user_session' => $session_user, // 'global_system_settings'=>$global_system_settings, 'request' => $_REQUEST, ); call_user_func($function_name, $parameters); } else { echo "Invalid Request."; exit; } function create_ticket($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_class = $param['user_class']; $global_system_settings = $param['global_system_settings']; $request = $param['request']; $user_session = $param['user_session']; $is_new_ticket = $request['is_new_ticket']; $sms_class = $param['sms_class']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $ticket_attachments = json_decode($request['attachments'], true); // get category id $sub_category_id = $ticket_class->read_sub_category_id_by_name($array_data['category'], $utility_class, $db); // get main category id $category_obj = $ticket_class->read_category_id_by_sub_category_id($sub_category_id, $utility_class, $db); $category_arr = array(); foreach ($category_obj as $category_row) { $category_arr = $category_row; } // print_r($category_arr);exit; $cat_show_vehicle = $category_arr['show_vehicle']; $category_id = $category_arr['category_id']; // get priority id $priority_id = $ticket_class->read_priority_level_id_by_name($array_data['priority_level'], $utility_class, $db); // insert main ticket $ticket_id = 0; //if the sub category is under vehicle catgory execute this // current Vehicle Category is 2, change it depends to your database category table $brand_id = ''; if (intval($cat_show_vehicle) === 1) { // get brand id $brand_id = $brand_class->read_brand_id_by_name($array_data['brand'], $utility_class, $db); if (!$utility_class->isNotEmpty($brand_id)) { $return_arr['message'] = "Brand is required..."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } // get model id $model_id = $model_class->read_model_id_by_name_n_brand_id($brand_id, $array_data['model'], $utility_class, $db); if (!$utility_class->isNotEmpty($model_id)) { $return_arr['message'] = "Model is required..."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } if (!$utility_class->isNotEmpty($array_data['plate_cs'])) { $return_arr['message'] = "Plate or CS is required..."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } // get model variant id $model_variant_id = $array_data['model_variant_id']; if (!$utility_class->isNotEmpty($model_variant_id) && $utility_class->isNotEmpty($array_data['model_variant'])) { $model_variant_id = $model_class->insert_model_variant($model_id, $array_data['model_variant'], $utility_class, $db); } if ($is_new_ticket) { $ticket_id = $ticket_class->create_ticket($user_session['id'], $sub_category_id, $priority_id, $array_data['title'], $array_data['description'], 1, $utility_class, $db); $ticket_class->create_vehicle_type_ticket( $ticket_id, $model_id, $model_variant_id, $array_data['plate_cs'], $array_data['vin'], $array_data['year_model'], $utility_class, $db ); } else { $ticket_id = $request['ticket_id']; $ticket_class->update_ticket($ticket_id, $user_session['id'], $sub_category_id, $priority_id, $array_data['title'], $array_data['description'], $utility_class, $db); $ticket_type_vehicle_obj = $ticket_class->read_vehicle_type_ticket($ticket_id, $utility_class, $db); $ticket_type_vehicle_arr = array(); foreach ($ticket_type_vehicle_obj as $row_vehicle_type) { $ticket_type_vehicle_arr = $row_vehicle_type; } if (count($ticket_type_vehicle_arr) > 0) { $ticket_class->update_vehicle_type_ticket( $ticket_id, $model_id, $model_variant_id, $array_data['plate_cs'], $array_data['vin'], $array_data['year_model'], 1, $utility_class, $db ); } else { $ticket_class->create_vehicle_type_ticket( $ticket_id, $model_id, $model_variant_id, $array_data['plate_cs'], $array_data['vin'], $array_data['year_model'], $utility_class, $db ); } } } else { if ($is_new_ticket) { // Insert no type (general) ticket and no $ticket_id = $ticket_class->create_ticket($user_session['id'], $sub_category_id, $priority_id, $array_data['title'], $array_data['description'], 1, $utility_class, $db); } else { $ticket_id = $request['ticket_id']; $ticket_class->update_ticket($ticket_id, $user_session['id'], $sub_category_id, $priority_id, $array_data['title'], $array_data['description'], $utility_class, $db); $ticket_class->update_vehicle_type_ticket_status($ticket_id, 0, $utility_class, $db); } } if ($is_new_ticket) { //assign ref no. $ref_no = 1000 + intval($ticket_id); $ticket_class->create_ticket_ref_no($ticket_id, $ref_no, $db); } // if(count($ticket_attachments) > 0){ // insert attachments foreach ($ticket_attachments as $ticket_attachment) { $ticket_class->create_ticket_attachment($ticket_id, $ticket_attachment['change_name'], $ticket_attachment['original_name'], $utility_class, $db); } // } if (!$is_new_ticket) { // update remove attachments $attachment_ids_arr = json_decode($request['remove_attachments'], true); if (count($attachment_ids_arr) > 0) { $attachment_ids = implode(',', $attachment_ids_arr); $ticket_class->update_ticket_attachment_status($attachment_ids, 0, $utility_class, $db); } } if ($is_new_ticket) { $return_arr['message'] = "Ticket has been added."; } else { $return_arr['message'] = "Ticket has been updated."; } // SEND NOTIF if ($is_new_ticket) { $from_user_id = $user_session['id']; $notification_type_id = 3; //Send Notification to experts (System Notification) if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { if ($utility_class->isNotEmpty($brand_id)) { $expert_users_obj = $user_class->read_user_by_category_id_and_brand_id(2, $brand_id, $db); $expert_users_arr = array(); foreach ($expert_users_obj as $expert_users_arr) { //fetch experts loop $to_user_id = $expert_users_arr['id']; if ($from_user_id != $to_user_id) { $target_id = $ticket_id; $notification_id = $user_class->create_user_notification($notification_type_id, $from_user_id, $to_user_id, $target_id, 1, $utility_class, $db); } } } } // send sms to expert $notification_type_id = 1; //Send Notification to experts (System Notification) if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { $description = $user_class->read_notification_template_by_id($notification_type_id, $utility_class, $db); $display_name = $user_session['firstname'] . ' ' . substr($user_session['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $replace_parameter = array( '<user>' => $display_name, '<ref_no>' => $ref_no, '<title>' => $array_data['title'], '<description>' => $array_data['description'], //str_replace("\n"," ",$arr_data['description']), '<category>' => $array_data['category'], '<priority>' => $array_data['priority_level'], '<brand>' => $array_data['brand'], '<model>' => $array_data['model'], '<variant>' => $array_data['model_variant'], ); $sms_description = strtr($description, $replace_parameter); if ($utility_class->isNotEmpty($brand_id)) { $active_api_sql_obj = $user_class->read_active_api($utility_class, $db); $active_api_array = array(); foreach ($active_api_sql_obj as $row) { $active_api_array = $row; } if (count($active_api_array) > 0) { $user_data_obj = $user_class->read_user_by_category_id_and_brand_id(2, $brand_id, $db); // $user_data_arr = array(); foreach ($user_data_obj as $user_data_row) { $message_will_be_sent = ""; // $user_data_arr = array_merge($user_data_arr,array($user_data_row)); $to_user_id = $user_data_row['id']; if ($from_user_id != $to_user_id) { // start create login token $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id, $from_user_id, $ticket_id, $token, 1, $utility_class, $db); $url_params = array( 'token' => $token, 'type' => 1, 'category' => 'tickets', 'action' => 'view', 'id' => $ticket_id, 'notification' => "[$ticket_id,$to_user_id]", ); $append_link = $global_system_settings['url'] . "token.php" . "?" . http_build_query($url_params); $append_link = urlencode($append_link); $append_link = $utility_class->curl_me( "https://s.autohub.ph/?url=$append_link&format=text", array(), 'GET' ); // echo $append_link;exit; $message_will_be_sent = $sms_description . "\n\nClick to view: " . $append_link; // end create login token // $replace_parameter = array( // '[no]' => '0' . $user_data_row['mobile'], // '[msg]' => addslashes($message_will_be_sent), // ); // $final_template = strtr($active_api_array['json_parameters'], $replace_parameter); // $final_template = preg_replace("/\\n/m", "\\n", $final_template); // $final_template = str_replace("\'", "'", $final_template); // $sms_status = $utility_class->curl_me( // $active_api_array['base_url'], // json_decode($final_template, true), // 'POST', // $active_api_array['headers'] // ); $array_data['mobile'] = '0' . $user_data_row['mobile']; $array_data['message'] = $message_will_be_sent; $array_data['data'] = $active_api_array; $sms_status = $sms_class->{$active_api_array['name']}($array_data); if ($sms_status == $active_api_array['sent_response']) { //send succcess } else { //send failed } } } } } } } $return_arr['id'] = $ticket_id; $return_arr['status'] = 1; echo json_encode($return_arr); } function create_ticket_reply($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $user_class = $param['user_class']; $request = $param['request']; $sms_class = $param['sms_class']; $user_session = $param['user_session']; $global_system_settings = $param['global_system_settings']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $ticket_id = $request['ticket_id']; $ticket_description = $array_data['ticket_reply']; $ticket_status = intval($array_data['chk_close_ticket']); //ignored by line below $ticket_info_arr = array(); $ticket_info_obj = $ticket_class->read_ticket_information($ticket_id, $utility_class, $db); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $ticket_info_arr = $row; } $ticket_reopen_status = /intval/ ($array_data['chk_reopen_ticket']); $ticket_escalated_solve_status = /intval/ ($array_data['chk_escalated_solve_ticket']); $ticket_final_status = /intval/ ($array_data['txt_final_status']); if ($utility_class->isNotEmpty($ticket_final_status) \|\| $utility_class->isNotEmpty($ticket_reopen_status) \|\| $utility_class->isNotEmpty($ticket_escalated_solve_status)) { if ($ticket_final_status \|\| $ticket_escalated_solve_status) { $ticket_status = 3; //closed or complete if ($ticket_escalated_solve_status) { $ticket_final_status = 2; //escalated } } else { $ticket_status = 2; //in progress } if ($ticket_reopen_status) { $ticket_status = 2; //in progress } } else { // same sa old yung status // fetch customer current status & final status $ticket_status = $utility_class->isNotEmpty($ticket_info_arr['ticket_status_id']) ? $ticket_info_arr['ticket_status_id'] : '2'; $ticket_final_status = $ticket_info_arr['final_status_id']; } $reply_ticket_id = $ticket_class->create_reply_ticket($user_session['id'], $ticket_id, $ticket_description, $ticket_status, $ticket_final_status, $utility_class, $db); //record reopen ticket if ($ticket_reopen_status) { $ticket_class->create_reopen_ticket($reply_ticket_id, $db); } //record escalated status ticket if ($ticket_escalated_solve_status) { $escalated_type = 1; // 1 means solve $ticket_class->create_escalated_ticket($reply_ticket_id, $escalated_type, $db); } $ticket_attachments = json_decode($request['attachments'], true); foreach ($ticket_attachments as $ticket_attachment) { $ticket_class->create_reply_ticket_attachment($reply_ticket_id, $ticket_attachment['change_name'], $ticket_attachment['original_name'], $utility_class, $db); } $from_user_id = $user_session['id']; // INSERT reply notification $notification_type_id = 4; //Reply Ticket System Notification if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { $to_user_id = $ticket_info_arr['user_id']; if ($from_user_id != $to_user_id) { $target_id = $ticket_id; $user_class->create_user_notification($notification_type_id, $from_user_id, $to_user_id, $target_id, 1, $utility_class, $db); } } // send sms to expert $notification_type_id = 2; //Send Notification to experts (System Notification) if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { $to_user_id = $ticket_info_arr['user_id']; if ($from_user_id != $to_user_id) { $active_api_sql_obj = $user_class->read_active_api($utility_class, $db); $active_api_array = array(); foreach ($active_api_sql_obj as $row) { $active_api_array = $row; } if (count($active_api_array) > 0) { $description = $user_class->read_notification_template_by_id($notification_type_id, $utility_class, $db); $display_name = $user_session['firstname'] . ' ' . substr($user_session['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $replace_parameter = array( '<user>' => $display_name, '<ref_no>' => $ticket_info_arr['reference_no'], '<title>' => $ticket_info_arr['title'], '<description>' => $ticket_info_arr['description'], //str_replace("\n"," ",$arr_data['description']), '<category>' => $ticket_info_arr['sub_category'], '<priority>' => $ticket_info_arr['priority_level'], '<brand>' => $ticket_info_arr['brand'], '<model>' => $ticket_info_arr['model'], '<variant>' => $ticket_info_arr['model_variant'], ); $sms_description = strtr($description, $replace_parameter); // start create login token $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id, $from_user_id, $ticket_id, $token, 2, $utility_class, $db); $url_params = array( 'token' => $token, 'type' => 2, 'category' => 'tickets', 'action' => 'view', 'id' => $ticket_id, 'notification' => "[$ticket_id,$to_user_id]", ); $append_link = $global_system_settings['url'] . "token.php" . "?" . http_build_query($url_params); $append_link = urlencode($append_link); $append_link = $utility_class->curl_me( "https://s.autohub.ph/?url=$append_link&format=text", array(), 'GET' ); $sms_description = $sms_description . "\n\nClick to view: " . $append_link; // end create login token // $replace_parameter = array( // '[no]' => '0' . $ticket_info_arr['mobile'], // '[msg]' => addslashes($sms_description), // ); // $final_template = strtr($active_api_array['json_parameters'], $replace_parameter); // $final_template = preg_replace("/\\n/m", "\\n", $final_template); // $final_template = str_replace("\'", "'", $final_template); // $sms_status = $utility_class->curl_me( // $active_api_array['base_url'], // json_decode($final_template, true), // 'POST', // $active_api_array['headers'] // ); $array_data['mobile'] = '0' . $ticket_info_arr['mobile']; $array_data['message'] = $sms_description; $array_data['data'] = $active_api_array; $sms_status = $sms_class->{$active_api_array['name']}($array_data); if ($sms_status == $active_api_array['sent_response']) { //send succcess } else { //send failed } } } } $return_arr['message'] = "Response submitted."; $return_arr['id'] = $reply_ticket_id; $return_arr['status'] = 1; echo json_encode($return_arr); } function create_ticket_header($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_class = $param['user_class']; $global_system_settings = $param['global_system_settings']; $request = $param['request']; $user_session = $param['user_session']; $is_new_ticket = true; if ($utility_class->isNotEmpty($request['id'])) { $is_new_ticket = false; } $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } // get category id $sub_category_id = $ticket_class->read_sub_category_id_by_name($array_data['category'], $utility_class, $db); // get main category id $category_obj = $ticket_class->read_category_id_by_sub_category_id($sub_category_id, $utility_class, $db); $category_arr = array(); foreach ($category_obj as $category_row) { $category_arr = $category_row; } $cat_show_vehicle = $category_arr['show_vehicle']; $category_id = $category_arr['category_id']; // get priority id $priority_id = $request['priority_id']; // insert main ticket $ticket_id = $request['id']; if ($is_new_ticket) { $ticket_id = $ticket_class->create_ticket($user_session['id'], $sub_category_id, $priority_id, $array_data['title'], $array_data['description'], 0, $utility_class, $db); } else { $ticket_class->update_ticket($ticket_id, $user_session['id'], $sub_category_id, $priority_id, $array_data['title'], $array_data['description'], $utility_class, $db); } $brand_id = ''; if (intval($cat_show_vehicle) === 1) { // get brand id $brand_id = $brand_class->read_brand_id_by_name($array_data['brand'], $utility_class, $db); if (!$utility_class->isNotEmpty($brand_id)) { $return_arr['message'] = "Brand is required..."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } // get model id $model_id = $model_class->read_model_id_by_name_n_brand_id($brand_id, $array_data['model'], $utility_class, $db); if (!$utility_class->isNotEmpty($model_id)) { $return_arr['message'] = "Model is required..."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } if (!$utility_class->isNotEmpty($array_data['plate_cs'])) { $return_arr['message'] = "Plate or CS is required..."; $return_arr['status'] = 0; echo json_encode($return_arr); exit; } // get model variant id $model_variant_id = $array_data['model_variant_id']; if (!$utility_class->isNotEmpty($model_variant_id) && $utility_class->isNotEmpty($array_data['model_variant'])) { $model_variant_id = $model_class->insert_model_variant($model_id, $array_data['model_variant'], $utility_class, $db); } // $ticket_id = $ticket_class->create_ticket($user_session['id'],$sub_category_id,$priority_id,$array_data['title'],$array_data['description'],$utility_class,$db); if ($is_new_ticket) { $ticket_class->create_vehicle_type_ticket_v2( $ticket_id, $model_id, $model_variant_id, $array_data['plate_cs'], $array_data['vin'], $array_data['year_model'], $array_data['mileage'], $array_data['chk_breakdown'], $array_data['chk_on_site'], $array_data['workshop_visit'], 0, $utility_class, $db ); } else { $ticket_class->update_vehicle_type_ticket_v2( $ticket_id, $model_id, $model_variant_id, $array_data['plate_cs'], $array_data['vin'], $array_data['year_model'], $array_data['mileage'], $array_data['chk_breakdown'], $array_data['chk_on_site'], $array_data['workshop_visit'], 0, $utility_class, $db ); } } //assign ref no. $ref_no = 1000 + intval($ticket_id); $ticket_class->create_ticket_ref_no($ticket_id, $ref_no, $db); $ticket_class->create_ticket_progress_status($ticket_id, $user_session['id'], 1, $utility_class, $db); if ($is_new_ticket) { $return_arr['message'] = "Add Success..."; } else { $return_arr['message'] = "Change Success..."; } $return_arr['status'] = 1; $return_arr['id'] = $ticket_id; echo json_encode($return_arr); } function update_ticket_vehicle_customer($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_class = $param['user_class']; $global_system_settings = $param['global_system_settings']; $request = $param['request']; $user_session = $param['user_session']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $ticket_id = $request['id']; // print_r($request); $ticket_class->update_ticket_customer( $ticket_id, $array_data['complaint'], $array_data['work_performed'], $array_data['fault_codes'], $utility_class, $db ); $return_arr['status'] = 1; $return_arr['message'] = "Success."; echo json_encode($return_arr); } function create_ticket_final($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $sms_class = $param['sms_class']; $user_class = $param['user_class']; $global_system_settings = $param['global_system_settings']; $request = $param['request']; $user_session = $param['user_session']; $status = $request['status']; $ticket_id = $request['id']; $ticket_info_obj = $ticket_class->read_ticket_information($ticket_id, $utility_class, $db); $ticket_info_arr = array(); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $ticket_info_arr = $row; } $ticket_class->update_ticket_status($ticket_id, $status, $utility_class, $db); $ticket_class->update_vehicle_type_ticket_status($ticket_id, $status, $utility_class, $db); $ticket_class->update_ticket_date_creation($ticket_id, $utility_class, $db); // loggerr $log_data['user_id'] = $user_session['id']; $log_data['target_id'] = $ticket_id; $log_data['description'] = 'Created a ticket'; //important $log_data['type'] = 2; //create ticket $log_data['db'] = $db; $GLOBALS['logger_class']->log($log_data); if (intval($ticket_info_arr['priority_level_id']) === 1) { //info ticket $ticket_class->create_ticket_progress_status($ticket_id, $user_session['id'], 3, $utility_class, $db); $return_arr['status'] = 1; $return_arr['message'] = "Success."; echo json_encode($return_arr); exit; } // SEND NOTIF $brand_id = $ticket_info_arr['brand_id']; $from_user_id = $user_session['id']; $notification_type_id = 3; //Send Notification to experts (System Notification) if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { if ($utility_class->isNotEmpty($brand_id)) { $expert_users_obj = $user_class->read_user_by_category_id_and_brand_id(2, $brand_id, $db); $expert_users_arr = array(); foreach ($expert_users_obj as $expert_users_arr) { //fetch experts loop $to_user_id = $expert_users_arr['id']; if ($from_user_id != $to_user_id) { $target_id = $ticket_id; $notification_id = $user_class->create_user_notification($notification_type_id, $from_user_id, $to_user_id, $target_id, 1, $utility_class, $db); } } } } $notification_type_id = 1; //Send Notification to experts (System Notification) if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { $description = $user_class->read_notification_template_by_id($notification_type_id, $utility_class, $db); $display_name = $user_session['firstname'] . ' ' . substr($user_session['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $replace_parameter = array( '<user>' => $display_name, '<ref_no>' => $ticket_info_arr['reference_no'], '<title>' => $ticket_info_arr['title'], '<description>' => $ticket_info_arr['description'], //str_replace("\n"," ",$arr_data['description']), '<category>' => $ticket_info_arr['category'], '<priority>' => $ticket_info_arr['priority_level'], '<brand>' => $ticket_info_arr['brand'], '<model>' => $ticket_info_arr['model'], '<variant>' => $ticket_info_arr['model_variant'], ); $sms_description = strtr($description, $replace_parameter); if ($utility_class->isNotEmpty($brand_id)) { $active_api_sql_obj = $user_class->read_active_api($utility_class, $db); $active_api_array = array(); foreach ($active_api_sql_obj as $row) { $active_api_array = $row; } if (count($active_api_array) > 0) { $user_data_obj = $user_class->read_user_by_category_id_and_brand_id(2, $brand_id, $db); // $user_data_arr = array(); foreach ($user_data_obj as $user_data_row) { $message_will_be_sent = ""; // $user_data_arr = array_merge($user_data_arr,array($user_data_row)); $to_user_id = $user_data_row['id']; if ($from_user_id != $to_user_id) { // start create login token $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id, $from_user_id, $ticket_id, $token, 1, $utility_class, $db); $url_params = array( 'token' => $token, 'type' => 1, // 'category'=>'tickets', // 'action'=>'view', 'id' => $ticket_id, // 'notification'=>"[$ticket_id,$to_user_id]", ); $append_link = $global_system_settings['url'] . "token.php" . "?" . http_build_query($url_params); $append_link = urlencode($append_link); $append_link = $utility_class->curl_me( "https://s.autohub.ph/?url=$append_link&format=text", array(), 'GET' ); // echo $append_link;exit; $message_will_be_sent = $sms_description . "\n\nClick to view: " . $append_link; // end create login token // $replace_parameter = array( // '[no]' => '0' . $user_data_row['mobile'], // '[msg]' => addslashes($message_will_be_sent), // ); // $final_template = strtr($active_api_array['json_parameters'], $replace_parameter); // $final_template = preg_replace("/\\n/m", "\\n", $final_template); // $final_template = str_replace("\'", "'", $final_template); // $sms_status = $utility_class->curl_me( // $active_api_array['base_url'], // json_decode($final_template, true), // 'POST', // $active_api_array['headers'] // ); $array_data['mobile'] = '0' . $user_data_row['mobile']; $array_data['message'] = $message_will_be_sent; $array_data['data'] = $active_api_array; $sms_status = $sms_class->{$active_api_array['name']}($array_data); if ($sms_status == $active_api_array['sent_response']) { //send succcess } else { //send failed } } } } } } $return_arr['status'] = 1; $return_arr['message'] = "Success."; echo json_encode($return_arr); } function create_ticket_reply_v2($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $user_class = $param['user_class']; $request = $param['request']; $sms_class = $param['sms_class']; $user_session = $param['user_session']; $global_system_settings = $param['global_system_settings']; $array_data = json_decode($request['json_data'], true); foreach ($array_data as $key => $value) { $array_data[$key] = $db->escape($array_data[$key]); } $ticket_id = $request['ticket_id']; $ticket_description = $array_data['ticket_reply']; $ticket_info_arr = array(); $ticket_info_obj = $ticket_class->read_ticket_information($ticket_id, $utility_class, $db); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $ticket_info_arr = $row; } if (intval($ticket_info_arr['ticket_status_id']) === 1) { $progress_status = 2; $ticket_class->create_ticket_progress_status($ticket_id, $user_session['id'], $progress_status, $utility_class, $db); } else { $progress_status = intval($ticket_info_arr['ticket_status_id']); } $reply_ticket_id = $ticket_class->create_reply_ticket_v2($user_session['id'], $ticket_id, $ticket_description, $progress_status, $utility_class, $db); $ticket_attachments = json_decode($request['attachments'], true); foreach ($ticket_attachments as $ticket_attachment) { $ticket_class->create_reply_ticket_attachment($reply_ticket_id, $ticket_attachment['change_name'], $ticket_attachment['original_name'], $utility_class, $db); } // loggerr $log_data['user_id'] = $user_session['id']; $log_data['target_id'] = $ticket_id; $log_data['description'] = 'Reply to ticket'; //important $log_data['type'] = 3; //reply ticket $log_data['db'] = $db; $GLOBALS['logger_class']->log($log_data); $from_user_id = $user_session['id']; // INSERT reply notification $notification_type_id = 4; //Reply Ticket System Notification if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { $to_user_id = $ticket_info_arr['user_id']; if ($from_user_id != $to_user_id) { $target_id = $ticket_id; $user_class->create_user_notification($notification_type_id, $from_user_id, $to_user_id, $target_id, 1, $utility_class, $db); } } // send sms $notification_type_id = 2; //Send Notification to experts (System Notification) if ($user_class->read_notification_type_if_active($notification_type_id, $db)) { $to_user_id = $ticket_info_arr['user_id']; if ($from_user_id != $to_user_id) { $active_api_sql_obj = $user_class->read_active_api($utility_class, $db); $active_api_array = array(); foreach ($active_api_sql_obj as $row) { $active_api_array = $row; } if (count($active_api_array) > 0) { $description = $user_class->read_notification_template_by_id($notification_type_id, $utility_class, $db); $display_name = $user_session['firstname'] . ' ' . substr($user_session['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $replace_parameter = array( '<user>' => $display_name, '<ref_no>' => $ticket_info_arr['reference_no'], '<title>' => $ticket_info_arr['title'], '<description>' => $ticket_info_arr['description'], //str_replace("\n"," ",$arr_data['description']), '<category>' => $ticket_info_arr['sub_category'], '<priority>' => $ticket_info_arr['priority_level'], '<brand>' => $ticket_info_arr['brand'], '<model>' => $ticket_info_arr['model'], '<variant>' => $ticket_info_arr['model_variant'], ); $sms_description = strtr($description, $replace_parameter); // start create login token $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id, $from_user_id, $ticket_id, $token, 2, $utility_class, $db); $url_params = array( 'token' => $token, 'type' => 2, // 'category'=>'tickets', // 'action'=>'view', 'id' => $ticket_id, // 'notification'=>"[$ticket_id,$to_user_id]", ); $append_link = $global_system_settings['url'] . "token.php" . "?" . http_build_query($url_params); $append_link = urlencode($append_link); $append_link = $utility_class->curl_me( "https://s.autohub.ph/?url=$append_link&format=text", array(), 'GET' ); $sms_description = $sms_description . "\n\nClick to view: " . $append_link; // end create login token // $replace_parameter = array( // '[no]' => '0' . $ticket_info_arr['mobile'], // '[msg]' => addslashes($sms_description), // ); // $final_template = strtr($active_api_array['json_parameters'], $replace_parameter); // $final_template = preg_replace("/\\n/m", "\\n", $final_template); // $final_template = str_replace("\'", "'", $final_template); // $sms_status = $utility_class->curl_me( // $active_api_array['base_url'], // json_decode($final_template, true), // 'POST', // $active_api_array['headers'] // ); $array_data['mobile'] = '0' . $ticket_info_arr['mobile']; $array_data['message'] = $sms_description; $array_data['data'] = $active_api_array; $sms_status = $sms_class->{$active_api_array['name']}($array_data); if ($sms_status == $active_api_array['sent_response']) { //send succcess } else { //send failed } } } } $return_arr['message'] = "Response submitted."; $return_arr['id'] = $reply_ticket_id; $return_arr['status'] = 1; echo json_encode($return_arr); } function update_ticket_status($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_class = $param['user_class']; $global_system_settings = $param['global_system_settings']; $request = $param['request']; $user_session = $param['user_session']; $ticket_id = $request['id']; $status = $request['status']; $status_id = $ticket_class->read_ticket_status_id_by_name($status, $utility_class, $db); $ticket_class->create_ticket_progress_status($ticket_id, $user_session['id'], $status_id, $utility_class, $db); // loggerr $log_data['user_id'] = $user_session['id']; $log_data['target_id'] = $ticket_id; $log_data['description'] = "Change status to $status"; //important $log_data['type'] = 4; //change ticket status $log_data['db'] = $db; $GLOBALS['logger_class']->log($log_data); $return_arr['status'] = 1; $return_arr['message'] = "Success."; echo json_encode($return_arr); } function update_ticket_attachments($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $model_class = $param['model_class']; $brand_class = $param['brand_class']; $user_class = $param['user_class']; $global_system_settings = $param['global_system_settings']; $request = $param['request']; $user_session = $param['user_session']; $ticket_id = $request['id']; $ticket_attachments = json_decode($request['attachments'], true); $ticket_class->remove_all_ticket_attachment_status($ticket_id, $utility_class, $db); foreach ($ticket_attachments as $ticket_attachment) { $ticket_class->create_ticket_attachment($ticket_id, $ticket_attachment['change_name'], $ticket_attachment['original_name'], $utility_class, $db); } $return_arr['status'] = 1; $return_arr['message'] = "Success."; echo json_encode($return_arr); } // function create_ticket_attachment($param){ // $db = $param['db']; // $utility_class = $param['utility_class']; // $ticket_class = $param['ticket_class']; // $upload_class = $param['upload_class']; // $request = $param['request']; // $response = $upload_class->create_attachment($_FILES['file'],$utility_class,$db); // echo json_encode($response); // } function read_sub_categories($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $category_list_obj = $ticket_class->read_sub_categories($search, $utility_class, $db); $json = []; foreach ($category_list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_sections($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $category_list_obj = $ticket_class->read_sections($search, $utility_class, $db); $json = []; foreach ($category_list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_final_status($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $category_list_obj = $ticket_class->read_final_status($search, $utility_class, $db); $json = []; foreach ($category_list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_priority_level($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $category_list_obj = $ticket_class->read_priority_level($search, $utility_class, $db); $json = []; foreach ($category_list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_ticket_data($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $ticket_id = $request['ticket_id']; $json['rows'] = array(); $json['attachments'] = array(); $ticket_id = $request['ticket_id']; $ticket_info_obj = $ticket_class->read_ticket_information($ticket_id, $utility_class, $db); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $json['rows'] = array( 'category' => $row['sub_category'], 'title' => $row['title'], 'description' => $row['description'], // 'sub_category_id'=>$row['sub_category_id'], // 'sub_category'=>$row['sub_category'], // 'subject'=>$row['title'], // 'description'=>$row['description'], // 'priority_id'=>$row['priority_level_id'], 'priority_level' => $row['priority_level'], // 'brand_id'=>$row['brand_id'], 'brand' => $row['brand'], // 'model_id'=>$row['model_id'], 'model' => $row['model'], 'model_variant_id' => $row['model_variant_id'], 'model_variant' => $row['model_variant'], 'year_model' => $row['year_model'], 'plate_cs' => $row['plate_cs'], 'vin' => $row['vin'], // 'category_id'=>$row['category_id'], // 'ticket_status_id'=>$row['ticket_status_id'], // 'ticket_status'=>$row['ticket_status'], ); } $ticket_attach_obj = $ticket_class->read_ticket_attachments($ticket_id, $utility_class, $db); foreach ($ticket_attach_obj as $row) { $file = dirname(__FILE__) . '/../../dist/attachments/' . $row['attachment_name']; $unreadable_size = (is_file($file) ? filesize($file) : 0); $readable_file_size = $utility_class->humanFileSize($unreadable_size); $file_ext = pathinfo($file, PATHINFO_EXTENSION); $fa_icon = $utility_class->getFileIcon($file_ext); $json['attachments'] = array_merge($json['attachments'], array(array( 'id' => $row['id'], 'change_name' => $row['attachment_name'], 'original_name' => $row['original_name'], 'date' => $row['date_addedf'], 'size' => $readable_file_size, 'unreadable_size' => $unreadable_size, 'icon' => $fa_icon, ))); } echo json_encode($json); } function read_ticket_list($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $request = $param['request']; $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; // print_r($request);exit; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; $owned_ticket_only = isset($request['owned_ticket_only']) ? $db->escape($request['owned_ticket_only']) : ''; // Filter by Category $filter_category = json_decode(isset($request['filter_category']) ? $request['filter_category'] : "[]", true); $filter_category_ids = array(); if (count($filter_category) > 0) { $filter_category_names = "'" . implode("','", $filter_category) . "'"; $category_id_list_obj = $ticket_class->read_ticket_sub_category_ids_by_names($filter_category_names, $utility_class, $db); foreach ($category_id_list_obj as $category_id_list) { $filter_category_ids[] = $category_id_list['id']; } } $filter_category_ids_str = count($filter_category_ids) > 0 ? implode(",", $filter_category_ids) : ''; // Filter by Status $filter_status = json_decode(isset($request['filter_status']) ? $request['filter_status'] : "[]", true); // print_r($filter_status); $filter_status_ids = array(); if (count($filter_status) > 0) { $filter_status_names = "'" . implode("','", $filter_status) . "'"; $status_id_list_obj = $ticket_class->read_ticket_status_ids_by_names($filter_status_names, $utility_class, $db); foreach ($status_id_list_obj as $status_id_list) { $filter_status_ids[] = $status_id_list['id']; } } $filter_status_ids_str = count($filter_status_ids) > 0 ? implode(",", $filter_status_ids) : ''; // Filter by priority $filter_priority = json_decode(isset($request['filter_priority']) ? $request['filter_priority'] : "[]", true); $filter_priority_ids = array(); if (count($filter_priority) > 0) { $filter_priority_names = "'" . implode("','", $filter_priority) . "'"; $priority_id_list_obj = $ticket_class->read_ticket_priority_ids_by_names($filter_priority_names, $utility_class, $db); foreach ($priority_id_list_obj as $priority_id_list) { $filter_priority_ids[] = $priority_id_list['id']; } } $filter_priority_ids_str = count($filter_priority_ids) > 0 ? implode(",", $filter_priority_ids) : ''; $filter_start_date = isset($request['start_date']) ? $request['start_date'] : ''; $filter_end_date = isset($request['end_date']) ? $request['end_date'] : ''; $filter_brand_id = isset($request['filter_brand']) && $utility_class->isNotEmpty($request['filter_brand']) ? $brand_class->read_brand_id_by_name($request['filter_brand'], $utility_class, $db) : ''; $filter_model_id = isset($request['filter_model']) && $utility_class->isNotEmpty($request['filter_model']) ? $model_class->read_model_id_by_name_n_brand_id($filter_brand_id, $request['filter_model'], $utility_class, $db) : ''; $ticket_list_array = $ticket_class->read_ticket_list( 1, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, $filter_status_ids_str, // $filter_status_ids_str_null, // $filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); $json_arr['total'] = $ticket_list_array[0]; $ticket_list_obj = $ticket_list_array[1]; $json_arr['rows'] = array(); $counter = $request['offset'] + 1; foreach ($ticket_list_obj as $row) { // $row = $utility_class->arrayNullToBlank($row); $display_name = $row['firstname'] . ' ' . substr($row['lastname'], 0, 1); $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'no' => $counter++, 'id' => $row['id'], 'reference_no' => $row['reference_no'], 'date' => $row['date_addedw'], 'datew' => date("F j, Y", strtotime($row['date_addedf'])), 'category' => $row['sub_category'], 'vehicle' => $row['brand'] . ' - ' . $row['model'], 'plate_cs' => $row['plate_cs'], 'title' => $row['title'], 'priority' => $row['priority_level'], 'status' => $row['status'], 'created_by' => $display_name, )) ); } echo json_encode($json_arr); } function read_ticket_list_autocomplete($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $request = $param['request']; $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; // print_r($request);exit; $search = isset($request['search']) ? $db->escape($request['search']) : ''; $offset = $request['offset']; $limit = $request['limit']; $ticket_list_obj = $ticket_class->read_ticket_list_autocomplete( $search, $offset, $limit, $utility_class, $db ); $json_arr['rows'] = array(); foreach ($ticket_list_obj as $row) { $json_arr['rows'] = array_merge( $json_arr['rows'], array(array( 'id' => $row['id'], 'text' => $row['title'], )) ); } echo json_encode($json_arr); } function read_ticket_category($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $category_list_obj = $ticket_class->read_priority_level('', $utility_class, $db); $json = []; foreach ($category_list_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_ticket_information($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $user_session = $param['user_session']; $ticket_id = $request['ticket_id']; $ticket_info_obj = $ticket_class->read_ticket_information($ticket_id, $utility_class, $db); $json = array(); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $display_name = $row['firstname'] . ' ' . substr($row['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $json = array( 'lbl_ticket_subject' => $row['title'], 'lbl_reference_no' => $row['reference_no'], 'lbl_ticket_info' => 'Created by ' . $display_name . ' on ' . $row['date_addedf'], 'lbl_ticket_date_created_by' => $row['date_addedf'], 'lbl_ticket_description' => str_replace("\n", "<br>", $row['description']), 'lbl_ticket_priority' => $row['priority_level'], 'lbl_ticket_category' => $row['sub_category'], 'lbl_kb_category' => $row['sub_category'], /for kb / 'lbl_kb_posted_date' => $row['date_addedf'], /for kb / 'lbl_ticket_brand' => $row['brand'], 'lbl_ticket_model' => $row['model'], 'lbl_ticket_mv' => $row['model_variant'], 'lbl_ticket_ym' => $row['year_model'], 'lbl_ticket_plate_cs' => $row['plate_cs'], 'lbl_ticket_vin' => $row['vin'], 'lbl_ticket_mileage' => $row['mileage'] . ' km', 'lbl_ticket_created_by' => $display_name, 'lbl_ticket_workshop_visit' => $row['workshop_visit_count'], 'lbl_ticket_complaint' => str_replace("\n", "<br>", $row['complaint']), //$row['complaint'], 'lbl_ticket_work_done' => str_replace("\n", "<br>", $row['work_performed']), //$row['work_performed'], 'lbl_ticket_fault_codes' => $row['fault_codes'], 'lbl_ticket_status' => $row['ticket_status'], 'lbl_ticket_breakdown' => (intval($row['breakdown']) ? 'Yes' : 'No'), 'lbl_ticket_on_site' => (intval($row['on_site']) ? 'Yes' : 'No'), 'category_id' => $row['category_id'], 'priority_id' => $row['priority_level_id'], 'show_vehicle' => $row['show_vehicle'], 'ticket_type' => $row['type'], 'ticket_status_id' => $row['ticket_status_id'], 'ticket_rating' => $row['rating'], 'is_owner' => ($row['user_id'] == $user_session['id']) ? 1 : 0, ); } echo json_encode($json); } function read_ticket_attachments($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $ticket_id = $request['ticket_id']; $ticket_info_obj = $ticket_class->read_ticket_attachments($ticket_id, $utility_class, $db); $json = array(); foreach ($ticket_info_obj as $row) { $file = dirname(__FILE__) . '/../../dist/attachments/' . $row['attachment_name']; $readable_file_size = $utility_class->humanFileSize((is_file($file) ? filesize($file) : 0)); $file_ext = pathinfo($file, PATHINFO_EXTENSION); // echo $file_ext;exit; $fa_icon = $utility_class->getFileIcon($file_ext); $json[] = array( 'id' => $row['id'], 'change_name' => $row['attachment_name'], 'original_name' => $row['original_name'], 'date' => $row['date_addedf'], 'size' => $readable_file_size, 'icon' => $fa_icon, ); } echo json_encode($json); } function read_ticket_replies($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $user_session = $param['user_session']; $ticket_id = $request['ticket_id']; $offset = $request['offset']; $limit = $request['limit']; $order = $request['order']; $ticket_replies_obj = $ticket_class->read_ticket_replies($ticket_id, $offset, $limit, $order, $utility_class, $db); // $ticket_replies_obj = $ticket_class->read_ticket_replies($ticket_id,$offset,$limit,$utility_class,$db); $json['rows'] = array(); $json['attachments'] = array(); foreach ($ticket_replies_obj as $row) { // echo $user_session['id'] .' - '. $row['owner_id'] ."\n"; $json['rows'] = array_merge($json['rows'], array(array( 'id' => $row['id'], 'ticket_id' => $row['ticket_id'], 'user' => $row['firstname'] . ' ' . $row['lastname'], 'creator' => ($row['from_user'] == $row['owner_id']) ? ' (Creator)' : '', 'remove' => ($user_session['id'] == $row['from_user']) ? 'Remove' : '', 'description' => str_replace("\n", "<br>", $row['description']), 'ticket_status' => $row['ticket_status'], 'date_added' => $row['date_addedf'], 'final_status_id' => $row['final_status_id'], 'reopen_ticket_id' => $row['reopen_ticket_id'], 'escalated_ticket_id' => $row['escalated_ticket_id'], ))); $ticket_replies_attachment_obj = $ticket_class->read_ticket_reply_attachments($row['id'], $utility_class, $db); foreach ($ticket_replies_attachment_obj as $row) { $json['attachments'] = array_merge($json['attachments'], array(array( 'id' => $row['id'], 'reply_id' => $row['ticket_reply_id'], 'attachment_name' => $row['attachment_name'], 'original_name' => $row['original_name'], ))); } } echo json_encode($json); } function read_ticket_replies_v2($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $user_session = $param['user_session']; $ticket_id = $request['ticket_id']; $offset = $request['offset']; $limit = $request['limit']; $order = $request['order']; $ticket_replies_obj = $ticket_class->read_ticket_replies($ticket_id, $offset, $limit, $order, $utility_class, $db); $json['rows'] = array(); $json['attachments'] = array(); foreach ($ticket_replies_obj as $row) { // echo $user_session['id'] .' - '. $row['owner_id'] ."\n"; $json['rows'] = array_merge($json['rows'], array(array( 'id' => $row['id'], 'ticket_id' => $row['ticket_id'], 'user' => $row['firstname'] . ' ' . $row['lastname'], 'creator' => ($row['from_user'] == $row['owner_id']) ? ' (Creator)' : '', 'remove' => ($user_session['id'] == $row['from_user']) ? 'Remove' : '', 'reply_owner' => ($user_session['id'] == $row['from_user']) ? 1 : 0, 'description' => str_replace("\n", "<br>", $row['description']), 'ticket_status' => $row['ticket_status'], 'date_added' => $row['date_addedf'], ))); $ticket_replies_attachment_obj = $ticket_class->read_ticket_reply_attachments($row['id'], $utility_class, $db); foreach ($ticket_replies_attachment_obj as $row) { $json['attachments'] = array_merge($json['attachments'], array(array( 'id' => $row['id'], 'reply_id' => $row['ticket_reply_id'], 'attachment_name' => $row['attachment_name'], 'original_name' => $row['original_name'], ))); } } echo json_encode($json); } function read_ticket_activities($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $user_session = $param['user_session']; $ticket_id = $request['ticket_id']; $offset = $request['offset']; $limit = $request['limit']; $order = $request['order']; $ticket_activities_obj = $ticket_class->read_ticket_activities($ticket_id, $offset, $limit, $order, $utility_class, $db); $json['rows'] = array(); foreach ($ticket_activities_obj as $row) { $json['rows'] = array_merge($json['rows'], array(array( 'id' => $row['id'], 'user' => $row['firstname'] . ' ' . $row['lastname'], 'description' => str_replace("\n", "<br>", $row['description']), 'date_added' => $row['date_addedf'], ))); } echo json_encode($json); } function read_ticket_status($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $ticket_status_obj = $ticket_class->read_ticket_status('', $utility_class, $db); $json = []; foreach ($ticket_status_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_ticket_available_status($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $ticket_id = $request['ticket_id']; $ticket_info_obj = $ticket_class->read_ticket_information($ticket_id, $utility_class, $db); $ticket_info_arr = array(); foreach ($ticket_info_obj as $row) { $row = $utility_class->arrayNullToBlank($row); $ticket_info_arr = $row; } $exclude_status = $ticket_info_arr['ticket_status_id'] . ',' . '1'; $ticket_status_obj = $ticket_class->read_ticket_available_status($exclude_status, $utility_class, $db); $json = []; foreach ($ticket_status_obj as $row) { $json[] = ['id' => $row['name'], 'text' => $row['name']]; } echo json_encode($json); } function read_category_id_by_sub_category_name($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; // get category id if ($utility_class->isNotEmpty($request['sub_category'])) { $sub_category_id = $ticket_class->read_sub_category_id_by_name($request['sub_category'], $utility_class, $db); // get main category id $category_obj = $ticket_class->read_category_id_by_sub_category_id($sub_category_id, $utility_class, $db); $category_arr = array(); foreach ($category_obj as $category_row) { $category_arr = $category_row; } $cat_show_vehicle = $category_arr['show_vehicle']; $category_id = $category_arr['category_id']; } else { $cat_show_vehicle = 0; $category_id = 0; } $return_arr['category_id'] = $category_id; $return_arr['show_vehicle'] = $cat_show_vehicle; echo json_encode($return_arr); } function delete_ticket_reply($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $ticket_reply_id = $request['ticket_reply_id']; $ticket_class->delete_ticket_reply($ticket_reply_id, 0, $db); $json['message'] = "Successfully removed."; echo json_encode($json); } function delete_ticket($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $ticket_id = $request['id']; $status = 0; $ticket_class->update_ticket_status($ticket_id, $status, $utility_class, $db); $json['status'] = 1; $json['message'] = "Successfully removed."; echo json_encode($json); } function read_data_countings($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; // START $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; $search = ''; $offset = ''; $limit = ''; $owned_ticket_only = isset($request['owned_ticket_only']) ? $db->escape($request['owned_ticket_only']) : ''; // Filter by Category $filter_category = json_decode($request['filter_category'], true); $filter_category_ids = array(); if (count($filter_category) > 0) { $filter_category_names = "'" . implode("','", $filter_category) . "'"; $category_id_list_obj = $ticket_class->read_ticket_sub_category_ids_by_names($filter_category_names, $utility_class, $db); foreach ($category_id_list_obj as $category_id_list) { $filter_category_ids[] = $category_id_list['id']; } } $filter_category_ids_str = count($filter_category_ids) > 0 ? implode(",", $filter_category_ids) : ''; // Filter by Status $filter_status = json_decode($request['filter_status'], true); $filter_status_ids = array(); if (count($filter_status) > 0) { $filter_status_names = "'" . implode("','", $filter_status) . "'"; $status_id_list_obj = $ticket_class->read_ticket_status_ids_by_names($filter_status_names, $utility_class, $db); foreach ($status_id_list_obj as $status_id_list) { $filter_status_ids[] = $status_id_list['id']; } } $filter_status_ids_str = count($filter_status_ids) > 0 ? implode(",", $filter_status_ids) : ''; // // check if has level 1 // $filter_status_ids_str_null = in_array(1,$filter_status_ids) ? true : false ; // // Filter by final Status // $filter_final_status = json_decode($request['filter_final_status'],true); // $filter_final_status_ids = array(); // if(count($filter_final_status) > 0){ // $filter_final_status_names = "'" . implode("','", $filter_final_status) . "'"; // $status_id_list_obj = $ticket_class->read_ticket_final_status_ids_by_names($filter_final_status_names,$utility_class,$db); // foreach($status_id_list_obj as $status_id_list){ // $filter_final_status_ids[] = $status_id_list['id']; // } // } // $filter_final_status_ids_str = count($filter_final_status_ids) > 0 ? implode(",",$filter_final_status_ids) : '' ; // $filter_escalated_status = array(); // if(in_array('Escalated (Solve)',$filter_final_status)){ // $filter_escalated_status[] = 1; // } // $filter_escalated_str = count($filter_escalated_status) > 0 ? implode(",",$filter_escalated_status) : '' ; // Filter by priority $filter_priority = json_decode($request['filter_priority'], true); $filter_priority_ids = array(); if (count($filter_priority) > 0) { $filter_priority_names = "'" . implode("','", $filter_priority) . "'"; $priority_id_list_obj = $ticket_class->read_ticket_priority_ids_by_names($filter_priority_names, $utility_class, $db); foreach ($priority_id_list_obj as $priority_id_list) { $filter_priority_ids[] = $priority_id_list['id']; } } $filter_priority_ids_str = count($filter_priority_ids) > 0 ? implode(",", $filter_priority_ids) : ''; $filter_start_date = $request['start_date']; $filter_end_date = $request['end_date']; $filter_brand_id = $utility_class->isNotEmpty($request['filter_brand']) ? $brand_class->read_brand_id_by_name($request['filter_brand'], $utility_class, $db) : ''; $filter_model_id = $utility_class->isNotEmpty($request['filter_model']) ? $model_class->read_model_id_by_name_n_brand_id($filter_brand_id, $request['filter_model'], $utility_class, $db) : ''; $return_arr['on_hold_total'] = $ticket_class->read_ticket_list( 2, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, "1", //$filter_status_ids_str, // true,//$filter_status_ids_str_null, // $filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); $return_arr['in_progress_total'] = $ticket_class->read_ticket_list( 2, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, "2", //$filter_status_ids_str, // false,//$filter_status_ids_str_null, // $filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); $return_arr['solve_total'] = $ticket_class->read_ticket_list( 2, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, "3", // $filter_status_ids_str_null, // 1,//$filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); $return_arr['not_solve_total'] = $ticket_class->read_ticket_list( 2, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, "4,5", // $filter_status_ids_str_null, // 2,//$filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); // $return_arr['on_hold_total'] = $ticket_class->read_ticket_count_by_progress(1,$db); // $return_arr['in_progress_total'] = $ticket_class->read_ticket_count_by_progress(2,$db); // $return_arr['solve_total'] = $ticket_class->read_ticket_count_by_final_status(1,$db); // $return_arr['not_solve_total'] = $ticket_class->read_ticket_count_by_final_status(2,$db); echo json_encode($return_arr); } function read_open_close_graph($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; // START $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; $search = ''; $offset = ''; $limit = ''; $owned_ticket_only = ''; // Filter by Category $filter_category = json_decode($request['filter_category'], true); $filter_category_ids = array(); if (count($filter_category) > 0) { $filter_category_names = "'" . implode("','", $filter_category) . "'"; $category_id_list_obj = $ticket_class->read_ticket_sub_category_ids_by_names($filter_category_names, $utility_class, $db); foreach ($category_id_list_obj as $category_id_list) { $filter_category_ids[] = $category_id_list['id']; } } $filter_category_ids_str = count($filter_category_ids) > 0 ? implode(",", $filter_category_ids) : ''; // Filter by Status $filter_status = json_decode($request['filter_status'], true); $filter_status_ids = array(); if (count($filter_status) > 0) { $filter_status_names = "'" . implode("','", $filter_status) . "'"; $status_id_list_obj = $ticket_class->read_ticket_status_ids_by_names($filter_status_names, $utility_class, $db); foreach ($status_id_list_obj as $status_id_list) { $filter_status_ids[] = $status_id_list['id']; } } $filter_status_ids_str = count($filter_status_ids) > 0 ? implode(",", $filter_status_ids) : ''; // check if has level 1 // $filter_status_ids_str_null = in_array(1,$filter_status_ids) ? true : false ; // // Filter by final Status // $filter_final_status = json_decode($request['filter_final_status'],true); // $filter_final_status_ids = array(); // if(count($filter_final_status) > 0){ // $filter_final_status_names = "'" . implode("','", $filter_final_status) . "'"; // $status_id_list_obj = $ticket_class->read_ticket_final_status_ids_by_names($filter_final_status_names,$utility_class,$db); // foreach($status_id_list_obj as $status_id_list){ // $filter_final_status_ids[] = $status_id_list['id']; // } // } // $filter_final_status_ids_str = count($filter_final_status_ids) > 0 ? implode(",",$filter_final_status_ids) : '' ; // $filter_escalated_status = array(); // if(in_array('Escalated (Solve)',$filter_final_status)){ // $filter_escalated_status[] = 1; // } // $filter_escalated_str = count($filter_escalated_status) > 0 ? implode(",",$filter_escalated_status) : '' ; // Filter by priority $filter_priority = json_decode($request['filter_priority'], true); $filter_priority_ids = array(); if (count($filter_priority) > 0) { $filter_priority_names = "'" . implode("','", $filter_priority) . "'"; $priority_id_list_obj = $ticket_class->read_ticket_priority_ids_by_names($filter_priority_names, $utility_class, $db); foreach ($priority_id_list_obj as $priority_id_list) { $filter_priority_ids[] = $priority_id_list['id']; } } $filter_priority_ids_str = count($filter_priority_ids) > 0 ? implode(",", $filter_priority_ids) : ''; $filter_start_date = $request['start_date']; $filter_end_date = $request['end_date']; $filter_brand_id = $utility_class->isNotEmpty($request['filter_brand']) ? $brand_class->read_brand_id_by_name($request['filter_brand'], $utility_class, $db) : ''; $filter_model_id = $utility_class->isNotEmpty($request['filter_model']) ? $model_class->read_model_id_by_name_n_brand_id($filter_brand_id, $request['filter_model'], $utility_class, $db) : ''; $tikcet_obj = $ticket_class->read_ticket_list( 4, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, $filter_status_ids_str, // $filter_status_ids_str_null, // $filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); // $tikcet_obj = $ticket_class->read_open_close_graph_open($db); $tikcet_arr['recieve'] = array(); foreach ($tikcet_obj as $tikcet_row) { $tikcet_arr['recieve'] = array_merge($tikcet_arr['recieve'], array($tikcet_row)); } $tikcet_obj = $ticket_class->read_ticket_list( 5, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, $filter_status_ids_str, // $filter_status_ids_str_null, // $filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); // $tikcet_obj = $ticket_class->read_open_close_graph_close($db); $tikcet_arr['close'] = array(); foreach ($tikcet_obj as $tikcet_row) { $tikcet_arr['close'] = array_merge($tikcet_arr['close'], array($tikcet_row)); } echo json_encode($tikcet_arr); } function read_active_support_count($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; // START $user_session = $param['user_session']; $brand_access_arr = $user_session['json_brand']; $search = ''; $offset = ''; $limit = ''; $owned_ticket_only = ''; // Filter by Category $filter_category = json_decode($request['filter_category'], true); $filter_category_ids = array(); if (count($filter_category) > 0) { $filter_category_names = "'" . implode("','", $filter_category) . "'"; $category_id_list_obj = $ticket_class->read_ticket_sub_category_ids_by_names($filter_category_names, $utility_class, $db); foreach ($category_id_list_obj as $category_id_list) { $filter_category_ids[] = $category_id_list['id']; } } $filter_category_ids_str = count($filter_category_ids) > 0 ? implode(",", $filter_category_ids) : ''; // Filter by Status $filter_status = json_decode($request['filter_status'], true); $filter_status_ids = array(); if (count($filter_status) > 0) { $filter_status_names = "'" . implode("','", $filter_status) . "'"; $status_id_list_obj = $ticket_class->read_ticket_status_ids_by_names($filter_status_names, $utility_class, $db); foreach ($status_id_list_obj as $status_id_list) { $filter_status_ids[] = $status_id_list['id']; } } $filter_status_ids_str = count($filter_status_ids) > 0 ? implode(",", $filter_status_ids) : ''; // check if has level 1 // $filter_status_ids_str_null = in_array(1,$filter_status_ids) ? true : false ; // // Filter by final Status // $filter_final_status = json_decode($request['filter_final_status'],true); // $filter_final_status_ids = array(); // if(count($filter_final_status) > 0){ // $filter_final_status_names = "'" . implode("','", $filter_final_status) . "'"; // $status_id_list_obj = $ticket_class->read_ticket_final_status_ids_by_names($filter_final_status_names,$utility_class,$db); // foreach($status_id_list_obj as $status_id_list){ // $filter_final_status_ids[] = $status_id_list['id']; // } // } // $filter_final_status_ids_str = count($filter_final_status_ids) > 0 ? implode(",",$filter_final_status_ids) : '' ; // $filter_escalated_status = array(); // if(in_array('Escalated (Solve)',$filter_final_status)){ // $filter_escalated_status[] = 1; // } // $filter_escalated_str = count($filter_escalated_status) > 0 ? implode(",",$filter_escalated_status) : '' ; // Filter by priority $filter_priority = json_decode($request['filter_priority'], true); $filter_priority_ids = array(); if (count($filter_priority) > 0) { $filter_priority_names = "'" . implode("','", $filter_priority) . "'"; $priority_id_list_obj = $ticket_class->read_ticket_priority_ids_by_names($filter_priority_names, $utility_class, $db); foreach ($priority_id_list_obj as $priority_id_list) { $filter_priority_ids[] = $priority_id_list['id']; } } $filter_priority_ids_str = count($filter_priority_ids) > 0 ? implode(",", $filter_priority_ids) : ''; $filter_start_date = $request['start_date']; $filter_end_date = $request['end_date']; $filter_brand_id = $utility_class->isNotEmpty($request['filter_brand']) ? $brand_class->read_brand_id_by_name($request['filter_brand'], $utility_class, $db) : ''; $filter_model_id = $utility_class->isNotEmpty($request['filter_model']) ? $model_class->read_model_id_by_name_n_brand_id($filter_brand_id, $request['filter_model'], $utility_class, $db) : ''; $tikcet_brand_obj = $ticket_class->read_ticket_list( 3, $user_session['id'], $owned_ticket_only, $filter_category_ids_str, $filter_status_ids_str, // true,//$filter_status_ids_str_null, // $filter_final_status_ids_str, // $filter_escalated_str, $filter_priority_ids_str, $filter_start_date, $filter_end_date, $filter_brand_id, $filter_model_id, $brand_access_arr, $search, $offset, $limit, $utility_class, $db ); // $tikcet_brand_obj = $ticket_class->read_ticket_active_support_count_per_brand($db); $tikcet_brand_arr = array(); foreach ($tikcet_brand_obj as $tikcet_brand_row) { $tikcet_brand_arr = array_merge($tikcet_brand_arr, array($tikcet_brand_row)); } $brand_list_obj = $brand_class->read_brands('', $brand_access_arr, $utility_class, $db); $brands = []; foreach ($brand_list_obj as $row) { $count = 0; foreach ($tikcet_brand_arr as $sub_array) { if (@$sub_array['id'] == $row['id']) { $count = $sub_array['count']; } } if ($utility_class->isNotEmpty($filter_brand_id)) { if ($filter_brand_id == $row['id']) { $brands[] = ['id' => $row['id'], 'name' => $row['name'], 'count' => $count]; } } else { $brands[] = ['id' => $row['id'], 'name' => $row['name'], 'count' => $count]; } } echo json_encode($brands); } function update_ticket_type($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $type = $request['type']; $ticket_id = $request['ticket_id']; $ticket_class->update_ticket_type($ticket_id, $type, $utility_class, $db); $json_arr['message'] = "Type updated."; $json_arr['status'] = 1; echo json_encode($json_arr); } function create_ticket_rating($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $user_session = $param['user_session']; $request = $param['request']; $ticket_id = $request['id']; $rating = $request['rating']; $progress_id = $ticket_class->read_latest_progress_status_id($ticket_id, $db); $ticket_class->create_ticket_rating($user_session['id'], $ticket_id, $progress_id, $rating, $utility_class, $db); // loggerr $log_data['user_id'] = $user_session['id']; $log_data['target_id'] = $ticket_id; $log_data['description'] = 'Rate a ticket with ' . $rating . ' stars.'; //important $log_data['type'] = 5; //create ticket $log_data['db'] = $db; $GLOBALS['logger_class']->log($log_data); $json_arr['message'] = "Rated."; $json_arr['status'] = 1; echo json_encode($json_arr); } ��model.php��0000644��00000005677�15024755361�0006404 0��ustar�00��<?php if(isset($_REQUEST['api'])){ include_once dirname(__FILE__) . '/../../cfg/db_api.php'; }else{ include_once dirname(__FILE__) . '/../../cfg/db.php'; // if(!intval($global_user_status)){ // echo $global_user_message; // exit; // } } include_once dirname(__FILE__) . '/../../app/classes/brand_class.php'; include_once dirname(__FILE__) . '/../../app/classes/model_class.php'; include_once dirname(__FILE__) . '/../../app/classes/utility.php'; $utility_class = new Utility(); $brand_class = new Brand(); $model_class = new Model(); $server_method = $_SERVER["REQUEST_METHOD"]; if(isset($_REQUEST['model'])){ $function_name = $db->escape($_REQUEST['model']); $parameters = array( 'db'=>$db, 'utility_class'=>$utility_class, 'brand_class'=>$brand_class, 'model_class'=>$model_class, 'server_method'=>$server_method, // 'user'=>$session_user, // 'global_system_settings'=>$global_system_settings, 'request'=>$_REQUEST, ); call_user_func($function_name,$parameters); }else{ echo "Invalid Request."; exit; } function read_model_variants($param){ $db = $param['db']; $utility_class = $param['utility_class']; $model_class = $param['model_class']; $request = $param['request']; $search = isset($request['search']) ? $db -> escape($request['search']) : '' ; $vehicle_model = isset($request['vehicle_model']) ? $db -> escape($request['vehicle_model']) : '' ; $vehicle_model_id = $utility_class->isNotEmpty($vehicle_model) ? $model_class->read_model_id_by_name($vehicle_model,$utility_class,$db) : '' ; $model_variants = $model_class->read_model_variants($vehicle_model_id,$search,$utility_class,$db); $json_arr['data'] = array(); foreach($model_variants as $row){ $json_arr['data'] = array_merge($json_arr['data'], array(array( 'id'=>$row['id'], 'text'=>$row['description'], 'model_id'=>$row['model_id'], 'model'=>$row['model'], 'brand_id'=>$row['brand_id'], 'brand'=>$row['brand'], )) ); } echo json_encode($json_arr); } function read_models($param){ $db = $param['db']; $utility_class = $param['utility_class']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $request = $param['request']; $search = isset($request['search']) ? $db -> escape($request['search']) : '' ; $brand_id = 0; $brand_info = $brand_class->read_brand_by_name($request['brand_name'],$param['utility_class'],$db); foreach($brand_info as $row){ $brand_id = $row['id']; } $model_list_obj = $model_class->read_models($brand_id,$search,$utility_class,$db); $json = []; foreach($model_list_obj as $row){ $json[] = ['id'=>$row['name'], 'text'=>$row['name']]; } echo json_encode($json); } ?>��

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