File manager - Edit - /home/autoph/public_html/tasks/v1.tar
Back
asa.php 0000644 00000006467 15024755445 0006051 0 ustar 00 <?php // API ACCESS KEY: 4 // TASKS LOGIN API WITH DATA ENCRYPTION USE USER ID ONLY TO LOGIN $api_access_key = 4; include '../../cfg/db.php'; if((!isset($_REQUEST['value']) || !$utility_class->isNotEmpty($_REQUEST['value'])) || // (!isset($_REQUEST['api']) || !$utility_class->isNotEmpty($_REQUEST['api'])) || // (!isset($_REQUEST['ref']) || !$utility_class->isNotEmpty($_REQUEST['ref'])) || (!isset($_REQUEST['key']) || !$utility_class->isNotEmpty($_REQUEST['key'])) ){ $json_arr['status'] = 0; $json_arr['message'] = 'Invalid request.'; echo json_encode($json_arr); exit; } // $api = $db->escape($_REQUEST['api']); // $ref = $db->escape($_REQUEST['ref']); $key = $db->escape($_REQUEST['key']); $value = $db->escape($_REQUEST['value']); //check api key if exist // code here // $query = "SELECT * FROM `api` WHERE 1 AND `key` = '$api' AND `address` = '$ref' AND `status` = 1"; // $api_data_obj = $db->sql_query($query); // $api_data_arr = array(); // foreach($api_data_obj as $api_data_row){ // $api_data_arr = $api_data_row; // } // if(count($api_data_arr) <= 0){ // $json_arr['status'] = 0; // $json_arr['message'] = 'Invalid api key.'; // echo json_encode($json_arr); // exit; // } //manage api access // if(!$utility_class->isNotEmpty($api_data_arr['json_access']) || !in_array($api_access_key,json_decode($api_data_arr['json_access'],true))){ // $json_arr['status'] = 0; // $json_arr['message'] = 'Your api key has no access to this page.'; // echo json_encode($json_arr); // exit; // } $main_uri = $global_system_settings['url']; //check if key is still valid $key_query = "SELECT status FROM `api_generated_keys` WHERE `key` = '".$key."' "; // echo $key_query;exit; $key_query_status = $db->select($key_query); if(!$key_query_status){ $json_arr['status'] = 0; $json_arr['message'] = 'Key is not valid anymore.'; echo json_encode($json_arr); exit; } if(isset($_SESSION['cc_user'])){ session_destroy(); session_start(); // header('Location: '.$main_uri); // exit; } $response_arr = json_decode($utility_class->decrypt($key,$value),true); // START // asa id // fetch username and password $user_asa_id = $response_arr['value']; //asa id $params['model'] = 'signin_api_asa'; $params['asa_id'] = $user_asa_id; $params['api'] = true; $resp = $utility_class -> curl_me( $main_uri.'app/models/user.php', $params, 'POST'); $resp_arr = json_decode($resp,true); $user_id = $resp_arr['id']; //sample data if($utility_class->isNotEmpty($user_id)){ $where_statement = " AND (u.`id` = $user_id) "; $user_class->system_user_security($where_statement,array(),'main',$utility_class,$db); } // END $db->sql_query("UPDATE `api_generated_keys` SET `status`= 0 WHERE `key` = '".$key."'"); $main_uri = $global_system_settings['url']; header('Location: '.$main_uri); ?> user/user.php 0000644 00000124024 15024755445 0007227 0 ustar 00 <?php include_once dirname(__FILE__) . '/../../../cfg/db_api.php'; // echo $db->select("SELECT REPLACE(UUID(), '-', '')");exit; //gen key 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['key']) ){ $function_name = $db->escape($_REQUEST['key']); $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, 'global_system_settings'=>$global_system_settings, '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) "; }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); } //web service for ticket information viewing function b8b3f5864711eca0f900ff70631b9a55($param){ $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $global_system_settings = $param['global_system_settings']; if(!isset($request['asa_id'])){ $json_arr['status'] = 0 ; $json_arr['message'] = 'ASA ID is required.'; echo json_encode($json_arr); exit; } if(!isset($request['ticket_id'])){ $json_arr['message'] = "Ticket ID is required."; $json_arr['status'] = 0; echo json_encode($json_arr); exit; } $asa_id = $request['asa_id']; $user_obj = $user_class->read_user_by_source_id($asa_id,$utility_class,$db); $user_arr = array(); foreach($user_obj as $user_row){ $user_arr = $user_row; } //for saving sessions using api // $where_statement = " AND (u.`id` = ".$user_arr['id'].") "; // $user_class->system_user_security($where_statement,array(),'main',$utility_class,$db); $to_user_id = $user_arr['id']; $from_user_id = $user_arr['id']; $target_id = $request['ticket_id']; $type = 1; //ticket id $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id,$from_user_id,$target_id,$token,$type,$utility_class,$db); $url_params = array( 'token'=>$token, 'type'=>$type, 'id'=>$target_id, ); $append_link = $global_system_settings['url']."token.php"."?".http_build_query($url_params); // $append_link = urlencode($append_link); // echo $append_link; $json_arr['status'] = 1; $json_arr['url'] = $append_link; echo json_encode($json_arr); } //web service for dashboard viewing function bb8da4865711eca0f900ff70631b9a14($param){ $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $global_system_settings = $param['global_system_settings']; if(!isset($request['asa_id'])){ $json_arr['status'] = 0 ; $json_arr['message'] = 'ASA ID is required.'; echo json_encode($json_arr); exit; } $asa_id = $request['asa_id']; $user_obj = $user_class->read_user_by_source_id($asa_id,$utility_class,$db); $user_arr = array(); foreach($user_obj as $user_row){ $user_arr = $user_row; } if(count($user_arr) <= 0){ //create asa user $asa_id_to_system = $utility_class -> curl_me( $global_system_settings['url'].'app/models/user.php', array('model'=>'signin_api_asa','asa_id'=>$request['asa_id']), 'POST'); $asa_id_to_system_arr = json_decode($asa_id_to_system,true); if(!intval($asa_id_to_system_arr['status'])){ $json_arr['status'] = 0; $json_arr['message'] = "Token generation failed."; $json_arr['id'] = $request['asa_id']; echo json_encode($json_arr); exit; } $params['model'] = 'signin_api_asa'; $params['asa_id'] = $request['asa_id']; $params['api'] = true; $main_uri = $global_system_settings['url']; $resp = $utility_class -> curl_me( $main_uri.'app/models/user.php', $params, 'POST'); $resp_arr = json_decode($resp,true); $user_arr['id'] = $resp_arr['id']; //sample data } $to_user_id = $user_arr['id']; $from_user_id = $user_arr['id']; $target_id = 0; $type = 5; // proceed to tasks $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id,$from_user_id,$target_id,$token,$type,$utility_class,$db); $url_params = array( 'token'=>$token, 'type'=>$type, 'id'=>$target_id, ); $append_link = $global_system_settings['url']."token.php"."?".http_build_query($url_params); // $append_link = urlencode($append_link); // echo $append_link; $json_arr['status'] = 1; $json_arr['url'] = $append_link; echo json_encode($json_arr); } ?> user/a.php 0000644 00000124064 15024755445 0006475 0 ustar 00 <?php include_once dirname(__FILE__) . '/../../../cfg/db_api.php'; // echo $db->select("SELECT REPLACE(UUID(), '-', '')");exit; //gen key 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['key']) ){ $function_name = $db->escape($_REQUEST['key']); $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, 'global_system_settings'=>$global_system_settings, '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) "; }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); } //web service for ticket information viewing function b8b3f5864711eca0f900ff70631b9a55($param){ $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $global_system_settings = $param['global_system_settings']; if(!isset($request['asa_id'])){ $json_arr['status'] = 0 ; $json_arr['message'] = 'ASA ID is required.'; echo json_encode($json_arr); exit; } if(!isset($request['ticket_id'])){ $json_arr['message'] = "Ticket ID is required."; $json_arr['status'] = 0; echo json_encode($json_arr); exit; } $asa_id = $request['asa_id']; $user_obj = $user_class->read_user_by_source_id($asa_id,$utility_class,$db); $user_arr = array(); foreach($user_obj as $user_row){ $user_arr = $user_row; } //for saving sessions using api // $where_statement = " AND (u.`id` = ".$user_arr['id'].") "; // $user_class->system_user_security($where_statement,array(),'main',$utility_class,$db); $to_user_id = $user_arr['id']; $from_user_id = $user_arr['id']; $target_id = $request['ticket_id']; $type = 1; //ticket id $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id,$from_user_id,$target_id,$token,$type,$utility_class,$db); $url_params = array( 'token'=>$token, 'type'=>$type, 'id'=>$target_id, ); $append_link = $global_system_settings['url']."token.php"."?".http_build_query($url_params); // $append_link = urlencode($append_link); // echo $append_link; $json_arr['status'] = 1; $json_arr['url'] = $append_link; echo json_encode($json_arr); } //web service for dashboard viewing function bb8da4865711eca0f900ff70631b9a14($param){ $db = $param['db']; $utility_class = $param['utility_class']; $user_class = $param['user_class']; $request = $param['request']; $global_system_settings = $param['global_system_settings']; if(!isset($request['asa_id'])){ $json_arr['status'] = 0 ; $json_arr['message'] = 'ASA ID is required.'; echo json_encode($json_arr); exit; } $asa_id = $request['asa_id']; $user_obj = $user_class->read_user_by_source_id($asa_id,$utility_class,$db); $user_arr = array(); foreach($user_obj as $user_row){ $user_arr = $user_row; } if(count($user_arr) <= 0){ //create asa user $asa_id_to_system = $utility_class -> curl_me( $global_system_settings['url'].'app/models/user.php', array('model'=>'signin_api_asa','asa_id'=>$request['asa_id']), 'POST'); $asa_id_to_system_arr = json_decode($asa_id_to_system,true); if(!intval($asa_id_to_system_arr['status'])){ $json_arr['status'] = 0; $json_arr['message'] = "Token generation failed."; $json_arr['id'] = $request['asa_id']; echo json_encode($json_arr); exit; } $params['model'] = 'signin_api_asa'; $params['asa_id'] = $request['asa_id']; $params['api'] = true; $main_uri = $global_system_settings['url']; $resp = $utility_class -> curl_me( $main_uri.'app/models/user.php', $params, 'POST'); $resp_arr = json_decode($resp,true); $user_arr['id'] = $resp_arr['id']; //sample data } $to_user_id = $user_arr['id']; $from_user_id = $user_arr['id']; $target_id = 0; $type = 5; // proceed to tasks $token = $db->select('SELECT UUID()'); $user_class->create_user_login_token($to_user_id,$from_user_id,$target_id,$token,$type,$utility_class,$db); $url_params = array( 'token'=>$token, 'type'=>$type, 'id'=>$target_id, ); $append_link = $global_system_settings['url']."token.php"."?".http_build_query($url_params); // $append_link = urlencode($append_link); // echo $append_link; $json_arr['status'] = 1; $json_arr['url'] = $append_link; echo json_encode($json_arr); } ?> ticket/ticket.php 0000644 00000311647 15024755445 0010052 0 ustar 00 <?php // if(isset($_REQUEST['api'])){ // include_once dirname(__FILE__) . '/../../../cfg/db_api.php'; // }else{ include_once dirname(__FILE__) . '/../../../cfg/db_api.php'; // if(!intval($global_user_status)){ // echo $global_user_message; // exit; // } // } // echo $db->select("SELECT REPLACE(UUID(), '-', '')");exit; //gen key 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['key'])) { $function_name = $db->escape($_REQUEST['key']); $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']; $sms_class = $param['sms_class']; $is_new_ticket = $request['is_new_ticket']; $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); $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); // $sms_status = $utility_class->curl_me( // $active_api_array['base_url'], // json_decode($final_template, true), // 'POST', // $active_api_array['headers'] // ); 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']; $sms_class = $param['sms_class']; $request = $param['request']; $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']; $user_class = $param['user_class']; $sms_class = $param['sms_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']; $sms_class = $param['sms_class']; $request = $param['request']; $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 = ''; // 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) : ''; // 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); } //view all open tickets function e9a08ee861a11eca0f900ff70631b9a1($param) { header('Content-type: application/json; charset=utf-8'); $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $user_class = $param['user_class']; $request = $param['request']; //check required parameters if (!isset($request['asa_id'])) { $json_arr['message'] = "ASA ID is required."; $json_arr['status'] = 0; echo json_encode($json_arr); exit; } if (!isset($request['offset'])) { $json_arr['message'] = "Offset is required."; $json_arr['status'] = 0; echo json_encode($json_arr); exit; } if (!isset($request['limit'])) { $json_arr['message'] = "Limit is required."; $json_arr['status'] = 0; echo json_encode($json_arr); exit; } $asa_id = $request['asa_id']; $user_obj = $user_class->read_user_by_source_id($asa_id, $utility_class, $db); $user_arr = array(); foreach ($user_obj as $user_row) { $user_arr = $user_row; } $where_statement = " AND (u.`id` = " . $user_arr['id'] . ") "; $user_class->system_user_security($where_statement, array(), 'main', $utility_class, $db); $user_session = $_SESSION['cc_user']; $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'] : '["On Hold","In Progress"]', 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); } //read ticket information function a135806862111eca0f900ff70631b9a8($param) { header('Content-type: application/json; charset=utf-8'); $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; $json['rows'] = array(); $json['attachments'] = array(); //check required parameters if (!isset($request['ticket_id'])) { $json_arr['message'] = "Ticket ID is required."; $json_arr['status'] = 0; echo json_encode($json_arr); exit; } $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); $display_name = $row['firstname'] . ' ' . substr($row['lastname'], 0, 1); $display_name = ucwords(strtolower($display_name)); $json['rows'] = array( 'ticket_subject' => $row['title'], 'reference_no' => $row['reference_no'], 'ticket_info' => 'Created by ' . $display_name . ' on ' . $row['date_addedf'], 'ticket_date_created_by' => $row['date_addedf'], 'ticket_description' => str_replace("\n", "<br>", $row['description']), 'ticket_priority' => $row['priority_level'], 'ticket_category' => $row['sub_category'], 'kb_category' => $row['sub_category'], /*for kb */ 'kb_posted_date' => $row['date_addedf'], /*for kb */ 'ticket_brand' => $row['brand'], 'ticket_model' => $row['model'], 'ticket_mv' => $row['model_variant'], 'ticket_ym' => $row['year_model'], 'ticket_plate_cs' => $row['plate_cs'], 'ticket_vin' => $row['vin'], 'ticket_mileage' => $row['mileage'] . ' km', 'ticket_created_by' => $display_name, 'ticket_workshop_visit' => $row['workshop_visit_count'], 'ticket_complaint' => str_replace("\n", "<br>", $row['complaint']), //$row['complaint'], 'ticket_work_done' => str_replace("\n", "<br>", $row['work_performed']), //$row['work_performed'], 'ticket_fault_codes' => $row['fault_codes'], 'ticket_status' => $row['ticket_status'], 'ticket_breakdown' => (intval($row['breakdown']) ? 'Yes' : 'No'), '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'], ); } $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); } //read ticket replies function fb7a6812864311eca0f900ff70631b9a($param) { header('Content-type: application/json; charset=utf-8'); $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $request = $param['request']; // $user_session = $param['user_session']; $offset = 0; //$request['offset']; $limit = 999; //$request['limit']; $order = "DESC"; //$request['order']; //check required parameters if (!isset($request['ticket_id'])) { $json_arr['message'] = "Ticket ID is required."; $json_arr['status'] = 0; echo json_encode($json_arr); exit; } $ticket_id = $request['ticket_id']; $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) { $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 e1c7b533865c11eca0f900ff70631b9a($param) { $db = $param['db']; $utility_class = $param['utility_class']; $ticket_class = $param['ticket_class']; $user_class = $param['user_class']; $request = $param['request']; $brand_class = $param['brand_class']; $model_class = $param['model_class']; $asa_id = $request['asa_id']; $user_obj = $user_class->read_user_by_source_id($asa_id, $utility_class, $db); $user_arr = array(); foreach ($user_obj as $user_row) { $user_arr = $user_row; } $where_statement = " AND (u.`id` = " . $user_arr['id'] . ") "; $user_class->system_user_security($where_statement, array(), 'main', $utility_class, $db); $user_session = $_SESSION['cc_user']; $brand_access_arr = $user_session['json_brand']; $search = ''; $offset = ''; $limit = ''; $owned_ticket_only = '1'; // 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'] : '["On Hold","In Progress"]', 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) : ''; $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); } a.php 0000644 00000001033 15024755445 0005505 0 ustar 00 <?php include '../../cfg/db.php'; // $ch = curl_init(); // curl_setopt($ch, CURLOPT_URL, "http://localhost/AutoHub-CC/api/v1/viber/a.php"); // curl_setopt($ch, CURLOPT_FRESH_CONNECT, true); // curl_setopt($ch, CURLOPT_TIMEOUT, 1); // curl_exec($ch); // curl_close($ch); $sdsd = $utility_class -> curl_me_async( "https://tasks.autohub.ph/api/v1/viber/a.php", array("json"=>'{"target_id":"89","type":1,"target_json":["sd","232"]}'), 'POST'); var_dump($sdsd); ?> dec_keys.php 0000644 00000003205 15024755445 0007056 0 ustar 00 <?php // API ACCESS KEY: 2 $api_access_key = 2; include '../../cfg/db.php'; if((!isset($_REQUEST['value']) || !$utility_class->isNotEmpty($_REQUEST['value'])) || (!isset($_REQUEST['api']) || !$utility_class->isNotEmpty($_REQUEST['api'])) || (!isset($_REQUEST['ref']) || !$utility_class->isNotEmpty($_REQUEST['ref'])) || (!isset($_REQUEST['key']) || !$utility_class->isNotEmpty($_REQUEST['key'])) ){ $json_arr['status'] = 0; $json_arr['message'] = 'Invalid request.'; echo json_encode($json_arr); exit; } $api = $db->escape($_REQUEST['api']); $ref = $db->escape($_REQUEST['ref']); $key = $db->escape($_REQUEST['key']); $value = $db->escape($_REQUEST['value']); //check api key if exist // code here $query = "SELECT * FROM `api` WHERE 1 AND `key` = '$api' AND `address` = '$ref' AND `status` = 1"; $api_data_obj = $db->sql_query($query); $api_data_arr = array(); foreach($api_data_obj as $api_data_row){ $api_data_arr = $api_data_row; } if(count($api_data_arr) <= 0){ $json_arr['status'] = 0; $json_arr['message'] = 'Invalid api key.'; echo json_encode($json_arr); exit; } //manage api access if(!$utility_class->isNotEmpty($api_data_arr['json_access']) || !in_array($api_access_key,json_decode($api_data_arr['json_access'],true))){ $json_arr['status'] = 0; $json_arr['message'] = 'Your api key has no access to this page.'; echo json_encode($json_arr); exit; } echo $utility_class->decrypt($key,$value); ?> login.php 0000644 00000005247 15024755445 0006410 0 ustar 00 <?php // API ACCESS KEY: 3 // TASKS LOGIN API WITH DATA ENCRYPTION USE USER ID ONLY TO LOGIN $api_access_key = 3; include '../../cfg/db.php'; if((!isset($_REQUEST['value']) || !$utility_class->isNotEmpty($_REQUEST['value'])) || // (!isset($_REQUEST['api']) || !$utility_class->isNotEmpty($_REQUEST['api'])) || // (!isset($_REQUEST['ref']) || !$utility_class->isNotEmpty($_REQUEST['ref'])) || (!isset($_REQUEST['key']) || !$utility_class->isNotEmpty($_REQUEST['key'])) ){ $json_arr['status'] = 0; $json_arr['message'] = 'Invalid request.'; echo json_encode($json_arr); exit; } // $api = $db->escape($_REQUEST['api']); // $ref = $db->escape($_REQUEST['ref']); $key = $db->escape($_REQUEST['key']); $value = $db->escape($_REQUEST['value']); //check api key if exist // code here // $query = "SELECT * FROM `api` WHERE 1 AND `key` = '$api' AND `address` = '$ref' AND `status` = 1"; // $api_data_obj = $db->sql_query($query); // $api_data_arr = array(); // foreach($api_data_obj as $api_data_row){ // $api_data_arr = $api_data_row; // } // if(count($api_data_arr) <= 0){ // $json_arr['status'] = 0; // $json_arr['message'] = 'Invalid api key.'; // echo json_encode($json_arr); // exit; // } //manage api access // if(!$utility_class->isNotEmpty($api_data_arr['json_access']) || !in_array($api_access_key,json_decode($api_data_arr['json_access'],true))){ // $json_arr['status'] = 0; // $json_arr['message'] = 'Your api key has no access to this page.'; // echo json_encode($json_arr); // exit; // } //check if key is still valid $key_query = "SELECT status FROM `api_generated_keys` WHERE `key` = '".$key."' "; // echo $key_query;exit; $key_query_status = $db->select($key_query); if(!$key_query_status){ $json_arr['status'] = 0; $json_arr['message'] = 'Key is not valid anymore.'; echo json_encode($json_arr); exit; } $response_arr = json_decode($utility_class->decrypt($key,$value),true); $user_id = $response_arr['value']; if($utility_class->isNotEmpty($user_id)){ $where_statement = " AND (u.`id` = $user_id) "; $user_class->system_user_security($where_statement,array(),'main',$utility_class,$db); } $db->sql_query("UPDATE `api_generated_keys` SET `status`= 0 WHERE `key` = '".$key."'"); $main_uri = $global_system_settings['url']; header('Location: '.$main_uri); ?> enc_keys.php 0000644 00000003455 15024755445 0007077 0 ustar 00 <?php // API ACCESS KEY: 1 $api_access_key = 1; include '../../cfg/db.php'; if((!isset($_REQUEST['value']) || !$utility_class->isNotEmpty($_REQUEST['value'])) || (!isset($_REQUEST['api']) || !$utility_class->isNotEmpty($_REQUEST['api']))|| (!isset($_REQUEST['ref']) || !$utility_class->isNotEmpty($_REQUEST['ref'])) ){ $json_arr['status'] = 0; $json_arr['message'] = 'Invalid request.'; echo json_encode($json_arr); exit; } $api = $db->escape($_REQUEST['api']); $ref = $db->escape($_REQUEST['ref']); $value = $db->escape($_REQUEST['value']); //check api key if exist // code here $query = "SELECT * FROM `api` WHERE 1 AND `key` = '$api' AND `address` = '$ref' AND `status` = 1"; $api_data_obj = $db->sql_query($query); $api_data_arr = array(); foreach($api_data_obj as $api_data_row){ $api_data_arr = $api_data_row; } if(count($api_data_arr) <= 0){ $json_arr['status'] = 0; $json_arr['message'] = 'Invalid api key.'; echo json_encode($json_arr); exit; } //manage api access if(!$utility_class->isNotEmpty($api_data_arr['json_access']) || !in_array($api_access_key,json_decode($api_data_arr['json_access'],true))){ $json_arr['status'] = 0; $json_arr['message'] = 'Your api key has no access to this page.'; echo json_encode($json_arr); exit; } $generated_keys = $utility_class->encrypt($value); $response_arr = json_decode($generated_keys,true); if($response_arr['status']){ $db->sql_query("INSERT INTO `api_generated_keys`( `key`, `api_id`,`date_added`, `status`) VALUES ('".$response_arr['key']."','".$api_data_arr['id']."',NOW(),1)"); } echo $generated_keys; ?> viber/send_video_notification.php 0000644 00000007362 15024755445 0013274 0 ustar 00 <?php // echo $_REQUEST['json'];exit; /** * Before you run this example: * 1. install monolog/monolog: composer require monolog/monolog * 2. copy config.php.dist to config.php: cp config.php.dist config.php * * @author Novikov Bogdan <hcbogdan@gmail.com> */ //sample json request // {"target_id":"80","type":1,"target_json":["262","292"]} require_once("../../../vendor/autoload.php"); include_once '../../../cfg/db_console.php'; use Viber\Bot; use Viber\Api\Sender; // use Monolog\Logger; // use Monolog\Handler\StreamHandler; $apiKey = '4ea7a840c9e7e7da-6455ceb946c2433c-569e8f349ab53511'; // reply name $botSender = new Sender([ 'name' => 'TASKS', 'avatar' => 'https://connect.autohub.ph/dist/img/default.png', ]); try { if(!isset($_REQUEST['json']) || is_null(json_decode($_REQUEST['json']))){ $json_arr['status'] = 0; $json_arr['message'] = "Invalid parameters."; echo json_encode($json_arr); exit; } include_once dirname(__FILE__) . '../../../../app/classes/user_class.php'; $user_class = new User(); $param_json = json_decode($_REQUEST['json'], true); $type = $param_json['type']; $target_id = $param_json['target_id']; $target_position_arr = $param_json['target_json']; //get target id details $video_title = $db->select("SELECT title FROM `videos` WHERE id = $target_id"); $query = "SELECT u.*,ati.api_id FROM `users` u LEFT OUTER JOIN cnf_api_token_ids ati ON u.id = ati.user_id WHERE 1 AND u.position_id IN (".implode(",",$target_position_arr).") AND ati.type = $type AND ati.status = 1;"; // echo $query; $user_obj = $db->sql_query($query); $user_arr = array(); foreach($user_obj as $user_row){ // $user_arr = array_merge($user_arr,array($user_row)); $user_arr[] = $user_row; } foreach($user_arr as $user_row1){ $token = $db->select('SELECT UUID()'); $to_user_id = $user_row1['id']; $from_user_id = $user_row1['id']; $user_class->create_user_login_token($to_user_id,$from_user_id,$target_id,$token,4,$utility_class,$db); $url_params = array( 'token'=>$token, 'type'=>4, // 'category'=>'tickets', // 'action'=>'view', 'id'=>$target_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'); $message_will_be_sent = "\n\nNew Video: ".$video_title."\nClick to view: ".$append_link; // echo $user_row1['api_id'];exit; $bot = new Bot(['token' => $apiKey]); $bot->getClient()->sendMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setReceiver($user_row1['api_id']) ->setText($message_will_be_sent) ); } } catch (Exception $e) { echo $e; } viber/bot.php 0000644 00000015314 15024755445 0007167 0 ustar 00 <?php /** * Before you run this example: * 1. install monolog/monolog: composer require monolog/monolog * 2. copy config.php.dist to config.php: cp config.php.dist config.php * * @author Novikov Bogdan <hcbogdan@gmail.com> */ require_once("../../../vendor/autoload.php"); use Viber\Bot; use Viber\Api\Sender; // use Monolog\Logger; // use Monolog\Handler\StreamHandler; $apiKey = '4ea7a840c9e7e7da-6455ceb946c2433c-569e8f349ab53511'; // reply name $botSender = new Sender([ 'name' => 'TASKS', 'avatar' => 'https://connect.autohub.ph/dist/img/default.png', ]); try { // create bot instance $bot = new Bot(['token' => $apiKey]); $bot // first interaction with bot - return "welcome message" ->onConversation(function ($event) use ($bot, $botSender) { // $log->info('onConversation handler'); $buttons = []; $buttons[] = (new \Viber\Api\Keyboard\Button()) ->setBgColor('#ffc107') ->setTextHAlign('center') ->setActionType('reply') ->setActionBody('btn-click') ->setText('Get Started'); $receiverId = $event->getUser()->getId(); $user_id_context = $event->getContext(); $user_id_context = intval($user_id_context); include_once '../../../cfg/db_console.php'; if($utility_class->isNotEmpty($user_id_context)){ //check if token exist // $query = "SELECT id FROM `cnf_api_token_ids` WHERE 1 AND `api_id` = '$receiverId' AND `type` = 1 AND `status` = 1 AND is_subscribe = 1 AND `user_id` = $user_id_context LIMIT 1 "; // $api_token_id = $db->select($query); // if(!$utility_class->isNotEmpty($api_token_id)){ // insert viber id $query = "INSERT INTO `cnf_api_token_ids`(`api_id`, `type`, `date_added`, `user_id`,`status`,`is_subscribe`) VALUES ('$receiverId',1,NOW(),$user_id_context,1,0) ON DUPLICATE KEY UPDATE api_id = VALUES (api_id), type = VALUES (type) "; $db->sql_query($query); // } } return (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setText("Welcome to AutoHub TASKS.\nClick \"Get Started\" to start.") ->setKeyboard( (new \Viber\Api\Keyboard()) ->setButtons($buttons) ); }) // when user subscribe to PA ->onSubscribe(function ($event) use ($bot, $botSender) { // $log->info('onSubscribe handler'); $receiverId = $event->getSender()->getId(); include_once '../../../cfg/db_console.php'; $query = "UPDATE `cnf_api_token_ids` SET `is_subscribe`=1 WHERE 1 AND api_id = '$receiverId' "; $db->sql_query($query); $bot->getClient()->sendMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setReceiver($receiverId) // ->setText("Type menu to view all commands.") ->setText('Thanks for subscription!') ); }) ->onUnsubscribe(function ($event) use ($bot, $botSender) { // $log->info('onSubscribe handler'); $receiverId = $event->getSender()->getId(); include_once '../../../cfg/db_console.php'; $query = "UPDATE `cnf_api_token_ids` SET `is_subscribe`= 0 WHERE 1 AND api_id = '$receiverId' "; $db->sql_query($query); $bot->getClient()->sendMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setReceiver($receiverId) // ->setText("Type menu to view all commands.") ->setText('We will miss you.') ); }) ->onText('|btn-click|s', function ($event) use ($bot, $botSender) { // $log->info('click on button'); $receiverId = $event->getSender()->getId(); include_once '../../../cfg/db_console.php'; $query = "UPDATE `cnf_api_token_ids` SET `is_subscribe`=1,`status`=1 WHERE 1 AND api_id = '$receiverId' "; $db->sql_query($query); $bot->getClient()->sendMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setReceiver($receiverId) // ->setText("Type menu to view all commands.") ->setText('Thanks for subscription!') ); }) ->onText('|sendall .*|si', function ($event) use ($bot, $botSender) { include_once '../../../cfg/db_console.php'; // //check if token exist // $query = "SELECT * FROM `cnf_api_token_ids` WHERE 1 AND type = 1 AND `status` = 1 AND is_subscribe = 1 LIMIT 100"; // $api_token_list_obj = $db->sql_query($query); // $api_token_list_arr = array(); // foreach($api_token_list_obj as $api_token_list_row){ // $api_token_list_arr = array_merge($api_token_list_arr,array($api_token_list_row)); // } //send 1 by 1 // foreach($api_token_list_arr as $api_token_list_row1){ // $bot->getClient()->sendMessage( // (new \Viber\Api\Message\Text()) // ->setSender($botSender) // ->setReceiver($api_token_list_row1['api_id']) // ->setText(str_replace("sendall","",$event->getMessage()->getText())) // ); // } $bot->getClient()->broadcastMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setBroadcastList(array('BzoOWFX2s4hPSaCBNw+ZQA==','BzoOWFX2s4hPSaCBNw+ZQA==')) ->setText(str_replace("sendall","",$event->getMessage()->getText())) ); }) ->onText('|myid|si', function ($event) use ($bot, $botSender) { // match by template, for example "whois Bogdaan" //echo $event->getSender()->getId();exit; $bot->getClient()->sendMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setReceiver($event->getSender()->getId()) ->setText('ID: '.$event->getSender()->getId()) ); }) ->run(); } catch (Exception $e) { echo $e; } viber/a.php 0000644 00000000132 15024755445 0006613 0 ustar 00 <?php // sleep for 10 seconds sleep(5); $myfile = fopen("testfile.txt", "w"); exit; viber/send.php 0000644 00000002522 15024755445 0007331 0 ustar 00 <?php /** * Before you run this example: * 1. install monolog/monolog: composer require monolog/monolog * 2. copy config.php.dist to config.php: cp config.php.dist config.php * * @author Novikov Bogdan <hcbogdan@gmail.com> */ //id must url encoded // {"id":"BzoOWFX2s4hPSaCBNw+ZQA==","msg":"Test"} // print_r($param_json); // exit; require_once("../../../vendor/autoload.php"); use Viber\Bot; use Viber\Api\Sender; // use Monolog\Logger; // use Monolog\Handler\StreamHandler; $apiKey = '4ea7a840c9e7e7da-6455ceb946c2433c-569e8f349ab53511'; // reply name $botSender = new Sender([ 'name' => 'TASKS', 'avatar' => 'https://connect.autohub.ph/dist/img/default.png', ]); try { if(!isset($_REQUEST['json']) || is_null(json_decode($_REQUEST['json']))){ $json_arr['status'] = 0; $json_arr['message'] = "Invalid parameters."; echo json_encode($json_arr); exit; } $param_json = json_decode($_REQUEST['json'], true); // create bot instance $bot = new Bot(['token' => $apiKey]); $bot->getClient()->sendMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setReceiver($param_json['id']) ->setText($param_json['msg']) ); } catch (Exception $e) { echo $e; } viber/broadcast.php 0000644 00000016460 15024755445 0010350 0 ustar 00 <?php /** * Before you run this example: * 1. install monolog/monolog: composer require monolog/monolog * 2. copy config.php.dist to config.php: cp config.php.dist config.php * * @author Novikov Bogdan <hcbogdan@gmail.com> */ require_once("../../../vendor/autoload.php"); use Viber\Bot; use Viber\Api\Sender; // use Monolog\Logger; // use Monolog\Handler\StreamHandler; $apiKey = '4ea7a840c9e7e7da-6455ceb946c2433c-569e8f349ab53511'; // reply name $botSender = new Sender([ 'name' => 'TASKS', 'avatar' => 'https://connect.autohub.ph/dist/img/default.png', ]); try { // create bot instance $bot = new Bot(['token' => $apiKey]); include_once '../../../cfg/db_console.php'; //check if token exist $query = "SELECT * FROM `cnf_api_token_ids` WHERE 1 AND type = 1 AND `status` = 1 AND is_subscribe = 1 LIMIT 100"; $api_token_list_obj = $db->sql_query($query); $api_token_list_arr = array(); foreach($api_token_list_obj as $api_token_list_row){ $api_token_list_arr = array_merge($api_token_list_arr,array($api_token_list_row)); } $token_ids_arr = array(); foreach($api_token_list_arr as $api_token_list_row1){ $token_ids_arr[] = $api_token_list_row1['api_id']; } if(count($token_ids_arr) > 0){ $bot->getClient()->broadcastMessage( (new \Viber\Api\Message\Text()) ->setSender($botSender) ->setBroadcastList($token_ids_arr) ->setText('Test Broadcast') ); } // $bot // // first interaction with bot - return "welcome message" // ->onConversation(function ($event) use ($bot, $botSender) { // // $log->info('onConversation handler'); // // $buttons = []; // // $buttons[] = (new \Viber\Api\Keyboard\Button()) // // ->setBgColor('#ffc107') // // ->setTextHAlign('center') // // ->setActionType('reply') // // ->setActionBody('btn-click') // // ->setText('Get Started'); // $receiverId = $event->getUser()->getId(); // $user_id_context = $event->getContext(); // $user_id_context = intval($user_id_context); // include_once '../../../cfg/db_console.php'; // if($utility_class->isNotEmpty($user_id_context)){ // //check if token exist // // $query = "SELECT id FROM `cnf_api_token_ids` WHERE 1 AND `api_id` = '$receiverId' AND `type` = 1 AND `status` = 1 AND is_subscribe = 1 AND `user_id` = $user_id_context LIMIT 1 "; // // $api_token_id = $db->select($query); // // if(!$utility_class->isNotEmpty($api_token_id)){ // // insert viber id // $query = "INSERT INTO `cnf_api_token_ids`(`api_id`, `type`, `date_added`, `user_id`,`status`,`is_subscribe`) VALUES ('$receiverId',1,NOW(),$user_id_context,1,1) // ON DUPLICATE KEY UPDATE // api_id = VALUES (api_id), // type = VALUES (type), // status = VALUES (status), // is_subscribe = VALUES (is_subscribe) // "; // $db->sql_query($query); // // } // } // return (new \Viber\Api\Message\Text()) // ->setSender($botSender) // ->setText("Welcome to AutoHub TASKS."); // // ->setKeyboard( // // (new \Viber\Api\Keyboard()) // // ->setButtons($buttons) // // ); // }) // // when user subscribe to PA // ->onSubscribe(function ($event) use ($bot, $botSender) { // // $log->info('onSubscribe handler'); // $this->getClient()->sendMessage( // (new \Viber\Api\Message\Text()) // ->setSender($botSender) // ->setText('Thanks for subscription!') // ); // }) // ->onText('|btn-click|s', function ($event) use ($bot, $botSender) { // // $log->info('click on button'); // $receiverId = $event->getSender()->getId(); // include_once '../../../cfg/db_console.php'; // //check if token exist // $query = "SELECT id FROM `cnf_api_token_ids` WHERE 1 AND `api_id` = '$receiverId' AND `type` = 1 AND status = 1"; // $api_token_id = $db->select($query); // if(!$utility_class->isNotEmpty($api_token_id)){ // // insert viber id // $query = "INSERT INTO `cnf_api_token_ids`(`api_id`, `type`, `date_added`, `status`) VALUES ('$receiverId',1,NOW(),1)"; // $db->sql_query($query); // } // $bot->getClient()->sendMessage( // (new \Viber\Api\Message\Text()) // ->setSender($botSender) // ->setReceiver($receiverId) // ->setText("Type menu to view all commands.") // ); // }) // ->onText('|sendall .*|si', function ($event) use ($bot, $botSender) { // include_once '../../../cfg/db_console.php'; // // //check if token exist // // $query = "SELECT * FROM `cnf_api_token_ids` WHERE 1 AND type = 1 AND `status` = 1 AND is_subscribe = 1 LIMIT 100"; // // $api_token_list_obj = $db->sql_query($query); // // $api_token_list_arr = array(); // // foreach($api_token_list_obj as $api_token_list_row){ // // $api_token_list_arr = array_merge($api_token_list_arr,array($api_token_list_row)); // // } // //send 1 by 1 // // foreach($api_token_list_arr as $api_token_list_row1){ // // $bot->getClient()->sendMessage( // // (new \Viber\Api\Message\Text()) // // ->setSender($botSender) // // ->setReceiver($api_token_list_row1['api_id']) // // ->setText(str_replace("sendall","",$event->getMessage()->getText())) // // ); // // } // $bot->getClient()->broadcastMessage( // (new \Viber\Api\Message\Text()) // ->setSender($botSender) // ->setBroadcastList(array('BzoOWFX2s4hPSaCBNw+ZQA==','BzoOWFX2s4hPSaCBNw+ZQA==')) // ->setText(str_replace("sendall","",$event->getMessage()->getText())) // ); // }) // ->onText('|myid|si', function ($event) use ($bot, $botSender) { // // match by template, for example "whois Bogdaan" // //echo $event->getSender()->getId();exit; // $bot->getClient()->sendMessage( // (new \Viber\Api\Message\Text()) // ->setSender($botSender) // ->setReceiver($event->getSender()->getId()) // ->setText('ID: '.$event->getSender()->getId()) // ); // }) // ->run(); } catch (Exception $e) { echo $e; } viber/testfile.txt 0000644 00000000000 15024755445 0010234 0 ustar 00 viber/webhook.php 0000644 00000000717 15024755445 0010042 0 ustar 00 <?php require_once("../../../vendor/autoload.php"); use Viber\Client; $apiKey = '4ea7a840c9e7e7da-6455ceb946c2433c-569e8f349ab53511'; // from "Edit Details" page $webhookUrl = 'https://tasks.autohub.ph/api/v1/viber/bot.php'; // for exmaple https://my.com/bot.php try { $client = new Client([ 'token' => $apiKey ]); $result = $client->setWebhook($webhookUrl); echo "Success!\n"; } catch (Exception $e) { echo "Error: ". $e->getError() ."\n"; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings