File manager - Edit - /home/autoph/public_html/tasks/app/classes/user_class.php
Back
<?php class User{ function read_id_number_count($id_no,$utility_class,$db){ return $db->sql_query_num_rows("SELECT id FROM lms2_users WHERE id_number = '$id_no' AND status = 1"); } function read_email_count($email,$utility_class,$db){ return $db->sql_query_num_rows("SELECT lu.id FROM lms2_user_contacts luc INNER JOIN lms2_users lu ON luc.user_id = lu.id WHERE luc.email = '$email' AND lu.status = 1"); } function read_mobile_count($mobile,$utility_class,$db){ return $db->sql_query_num_rows("SELECT lu.id FROM lms2_user_contacts luc INNER JOIN lms2_users lu ON luc.user_id = lu.id WHERE luc.mobile = '$mobile' AND lu.status = 1"); } function read_position_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `user_positions` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function insert_user_details($array_data,$utility_class,$db){ $query = "INSERT INTO `lms2_users`( `id_number`,`default_position_id`, `default_dealer_id`, `firstname`, `lastname`, `date_added`, `status`) VALUES ('".$array_data['id_no']."','".$array_data['position']."','".$array_data['dealer']."','".$array_data['firstname']."','".$array_data['lastname']."',NOW(),'1')"; $inserted_user_id = $db->sql_query_id($query); $query_contact = "INSERT INTO `lms2_user_contacts`(`user_id`, `mobile`, `email`) VALUES ('$inserted_user_id','".$array_data['mobile']."','".$array_data['email']."')"; $inserted_user_contact_count = $db->sql_query_affected_rows($query_contact); $hash_password = password_hash(md5($array_data['password']), PASSWORD_DEFAULT); $query_account = "INSERT INTO `lms2_user_accounts`( `user_id`, `username`, `password`, `is_active_account`) VALUES ('$inserted_user_id','".$array_data['id_no']."','$hash_password','0')"; $inserted_user_account_count = $db->sql_query_affected_rows($query_account); return intval($inserted_user_contact_count + $inserted_user_account_count); } function read_user_status($array_data,$utility_class,$db){ } function read_user_account_status($array_data,$utility_class,$db){ } function insert_temporary_role($array_data,$user_id,$utility_class,$db){ $query_insert_role = "INSERT INTO `lms2_roles`( `status`) VALUES (0)"; $role_id = $db->sql_query_id($query_insert_role); $query_insert_role_access = "INSERT INTO `lms2_role_access`( `role_id`, `json_dealers`, `json_menus`) VALUES ($role_id,'[]','[]')"; $db->sql_query($query_insert_role_access); return $role_id; } function delete_temporary_role($array_data,$user_id,$utility_class,$db){ $query_remove_role_access = "DELETE FROM `lms2_role_access` WHERE role_id = ".$array_data['id'].""; $db->sql_query($query_remove_role_access); $query_remove_role = "DELETE FROM `lms2_roles` WHERE id = ".$array_data['id'].""; return $db->sql_query_affected_rows($query_remove_role); } function update_role($user_id,$role_id,$name,$utility_class,$db){ $query_update_role = "UPDATE `cnf_roles` SET `name`=NULLIF('".$name."','') WHERE id = $role_id"; $db->sql_query_affected_rows($query_update_role); } function update_role_access($role_id,$role_data,$brand_data,$json_dealer,$category_id,$utility_class,$db){ $query = "UPDATE `cnf_role_access` SET `json_access`= NULLIF('$role_data',''), `json_brand`= NULLIF('$brand_data',''), `json_dealer`= NULLIF('$json_dealer',''), `user_category_id`= NULLIF('$category_id','') WHERE `role_id` = $role_id"; return $db->sql_query_affected_rows($query); } function read_role_dealers($role_id ,$utility_class,$db){ $query = "SELECT `json_dealers` FROM `lms2_role_access` WHERE `role_id` = $role_id LIMIT 1"; return $db->select($query); } function update_role_dealers($role_id,$role_dealers,$utility_class,$db){ $query = "UPDATE `lms2_role_access` SET `json_dealers`= '$role_dealers' WHERE `role_id` = $role_id"; return $db->sql_query_affected_rows($query); } function update_role_menus($role_id,$role_menus,$utility_class,$db){ $query = "UPDATE `lms2_role_access` SET `json_menus`= '$role_menus' WHERE `role_id` = $role_id"; return $db->sql_query_affected_rows($query); } function role_dealer_list($array_data,$utility_class,$db){ // $offset_limit = "LIMIT ".$array_data['offset'].",".$array_data['limit']." "; $offset_limit = ""; $field = " c.id as c_id, c.code as c_code, c.name as c_name, d.id as d_id, d.code as d_code, d.name as d_name "; $field_count = " COUNT(1) "; $query = "SELECT %s FROM `lms2_companies` c INNER JOIN lms2_dealers d ON c.id = d.company_id WHERE 1 AND (CONCAT(c.code,' ',c.name) LIKE '%%%s%%' OR CONCAT(d.code,' ',d.name) LIKE '%%%s%%') AND c.status = 1 AND d.status = 1 ORDER BY d.name ASC %s "; $query_formatted = sprintf( $query, $field, $array_data['search'], $array_data['search'], $offset_limit ); $query_formatted_count = sprintf( $query, $field_count, $array_data['search'], $array_data['search'], '' ); // echo $query_formatted;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function get_user_notification_info($user_id,$utility_class,$db){ $query = " SELECT nt.id,COUNT(nt.id) as total,nt.name , MAX(nl.date_added) ago_time FROM `lms2_notification_type` nt INNER JOIN lms2_notification_list nl ON nt.id = nl.notification_type_id WHERE 1 AND nt.status = 1 AND nl.status = 1 AND nl.is_read = 0 AND nl.to_user = $user_id GROUP BY nt.id ORDER BY nl.date_added DESC"; return $db->sql_query($query); } function read_user_notification($user_id,$offset,$limit,$utility_class,$db){ $offset_limit = "LIMIT 0,".$limit." "; // $offset_limit = "LIMIT ".$offset.",".$limit." "; $is_read = " AND cl.`is_read` = 0 "; $fields = " cl.`id`, cl.target_id, cl.`template_id`, cl.`from_user_id`, cl.`to_user_id`, cl.`date_added`, cl.is_read, cl.type, cnt.description "; $count = " COUNT(1) "; $query = " SELECT %s FROM `cnf_notification_list` cl INNER JOIN cnf_notification_templates cnt ON cl.`template_id` = cnt.id WHERE 1 %s AND cl.`status` = 1 AND `to_user_id` = $user_id ORDER BY cl.date_added DESC %s "; $query_formatted = sprintf($query,$fields,$is_read,$offset_limit); // echo $query_formatted;exit; // $query_formatted_count = sprintf($query,$count,'',''); $query_formatted_count = sprintf($query,$count,$is_read,$offset_limit); // // echo $query_formatted;exit; // return $db->sql_query($query_formatted); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_notification_template_by_id($id,$utility_class,$db){ $query = "SELECT description FROM `cnf_notification_templates` WHERE 1 AND id = $id LIMIT 1"; return $db->select($query); } function read_user_notification_count($user_id,$utility_class,$db){ $query = " SELECT COUNT(1) FROM `cnf_notification_list` cl INNER JOIN cnf_notification_templates cnt ON cl.`template_id` = cnt.id WHERE 1 AND cl.`is_read` = 0 AND cl.`status` = 1 AND `to_user_id` = $user_id ORDER BY cl.date_added DESC "; return $db->select($query); } function get_user_notification_list($user_id,$type_id,$offset,$limit,$utility_class,$db){ $notif_type = ""; if(intval($type_id)){ $notif_type = " AND nl.`notification_type_id` = $type_id "; } $query = "SELECT u1.firstname,u1.lastname,nl.`id` as notif_id, nl.`notification_type_id`, nl.`description`, nl.`date_added`, nl.`is_read`, nl.target_id, DATE_FORMAT(nl.date_added,'%%M %%d, %%Y %%h:%%i %%p') as date_addedf FROM `lms2_notification_list` nl INNER JOIN lms2_users u1 ON nl.`from_user` = u1.id WHERE 1 AND nl.status = 1 AND nl.`to_user` = %s %s /*type_id*/ ORDER BY nl.`date_added` DESC LIMIT %s,%s"; $query_final = sprintf($query,$user_id,$notif_type,$offset,$limit); // echo $query; return $db->sql_query($query_final); } function mark_as_read_notification($user_id,$type_id,$utility_class,$db){ $notif_type = ""; if(intval($type_id)){ $notif_type = " AND `notification_type_id` = $type_id "; } $query = "UPDATE `lms2_notification_list` SET `is_read`=1 WHERE 1 AND `to_user` = %s %s"; $query_final = sprintf($query,$user_id,$notif_type); // echo $query_final; return $db->sql_query($query_final); } function read_active_api($utility_class,$db){ $query = "SELECT * FROM `cnf_sms_api` WHERE `is_activated` = 1 AND `status` = 1"; return $db->sql_query($query); } function read_user_by_category_id_and_brand_id($category_id,$brand_id,$db){ $query = "SELECT u.*,uc.mobile,uc.email FROM users u INNER JOIN user_accounts ua ON u.id = ua.user_id INNER JOIN user_contacts uc ON u.id = uc.user_id INNER JOIN cnf_roles cr ON ua.role_id = cr.id INNER JOIN cnf_role_access cra ON cr.id = cra.role_id WHERE 1 AND cra.user_category_id = $category_id AND JSON_CONTAINS(cra.json_brand,'\"$brand_id\"','$') = 1 AND cra.json_brand IS NOT NULL GROUP BY u.id "; return $db->sql_query($query); } function read_positions($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `user_positions` WHERE name LIKE '%$search%' AND status = 1 ORDER BY name ASC;"; return $db->sql_query($query); } function read_notification_type_if_active($type_id,$db){ $query = "SELECT is_active FROM `cnf_notification_templates` WHERE 1 AND id = $type_id LIMIT 1"; return intval($db->select($query)); } function create_user_notification($notification_type_id,$from_user_id,$to_user_id,$target_id,$type,$utility_class,$db){ $query = "INSERT INTO `cnf_notification_list`(`template_id`, `from_user_id`, `to_user_id`, `target_id`, `date_added`, `is_read`, `status`,`type`) VALUES (NULLIF('$notification_type_id',''),NULLIF('$from_user_id',''),NULLIF('$to_user_id',''),NULLIF('$target_id',''),NOW(),0,1,NULLIF('$type',''))"; return $db->sql_query_id($query); } function role_list($array_data,$utility_class,$db){ // $offset_limit = "LIMIT ".$array_data['offset'].",".$array_data['limit']." "; $offset_limit = ""; $field = " r.`id`, r.`name`, (SELECT COUNT(1) FROM lms2_users su INNER JOIN lms2_user_accounts sus ON su.id = sus.user_id WHERE sus.role_id = r.id AND su.status = 1 AND sus.is_active_account = 1) as user_count,ra.json_menus "; $field_count = " COUNT(1) "; $query = "SELECT %s FROM `lms2_roles` r LEFT OUTER JOIN lms2_role_access ra ON r.id = ra.role_id WHERE 1 AND r.name LIKE '%%%s%%' AND r.status = 1 ORDER BY r.name ASC %s "; $query_formatted = sprintf( $query, $field, $array_data['search'], $offset_limit ); $query_formatted_count = sprintf( $query, $field_count, $array_data['search'], '' ); // echo $query_formatted_count;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function update_notification_status($target_id,$to_user_id,$is_read,$db){ $query = "UPDATE cnf_notification_list SET is_read = $is_read WHERE target_id = $target_id AND to_user_id = $to_user_id"; $db->sql_query($query); } function read_user_information($user_id,$db){ $query = "SELECT u.* FROM `users` u WHERE 1 AND u.id = $user_id "; return $db->sql_query($query); } function system_user_security($where_statement,$array_data,$source,$utility_class,$db){ //check user status $query = "SELECT u.`id`, u.`gender_id`, u.`id_number`, u.`position_id`, CONCAT(u.`firstname`, ' ', u.`lastname`) as fullname ,u.`firstname`, u.`middlename`, u.`lastname`, u.`birthday`, u.`avatar`, u.`date_added`, u.`status`, uc.`mobile`, uc.`email`, uc.`address`, uc.`city_id`, uc.`facebook`, uc.`instagram`, uc.`whatsapp`, uc.`viber`, uc.`linkedin`, ua.`username`, ua.`password`, ua.`is_active`,cra.json_access,cra.json_brand,ua.role_id FROM users u INNER JOIN user_contacts uc ON u.id = uc.user_id INNER JOIN user_accounts ua ON u.id = ua.user_id LEFT OUTER JOIN cnf_roles cr ON ua.role_id = cr.id LEFT OUTER JOIN cnf_role_access cra ON cr.id = cra.role_id WHERE 1 %s "; // echo sprintf($query,$where_statement);exit; $user_information_obj = $db->sql_query(sprintf($query,$where_statement)); $user_information = array(); foreach($user_information_obj as $row){ // print_r($row);exit; $user_information = $row; } if(count($user_information) > 0){ //check password if($source == 'login'){ $md5_password = md5($array_data['password']); if (!password_verify($md5_password, $user_information['password'])) { $return_arr['message'] = "Invalid password."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } } if (intval($user_information['status']) !== 1) { $return_arr['message'] = "Your account is deactivated."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } if (intval($user_information['is_active']) !== 1) { $return_arr['message'] = "Your account is not yet approved."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } // $json_dealers = array(); // //merge dealers // if($utility_class->isJson($user_information['json_dealers'])){ // $json_dealers = json_decode($user_information['json_dealers']); // } // if($utility_class -> isNotEmpty($user_information['default_dealer_id'])){ // $json_dealers = array_merge($json_dealers,array($user_information['default_dealer_id'])); // } // $json_dealers = $utility_class -> toArrayInt($json_dealers); $json_access = array(); if($utility_class->isJson($user_information['json_access'])){ $json_access = json_decode($user_information['json_access'],true); } $json_brand = array(); if($utility_class->isJson($user_information['json_brand'])){ $json_brand = json_decode($user_information['json_brand'],true); } $json_brand = $utility_class -> toArrayInt($json_brand); //merge dealers to session // $user_information = array_merge($user_information,array('dealer_access'=>$json_dealers),array('menu_access'=>$json_menus)); $user_information = array_merge($user_information,array('json_brand'=>$json_brand),array('json_access'=>$json_access)); $_SESSION['cc_user'] = $user_information; // echo ($_SESSION['cc_user']['role_id']);exit; $display_name = $user_information['firstname']. ' '.substr($user_information['lastname'],0,1); // echo ; // if($source == 'login'){ $return_arr['id'] = $user_information['id']; $return_arr['message'] = "Welcome ".ucwords(strtolower($display_name))."."; // $return_arr['data'] = $user_information; $return_arr['status'] = 1; return $return_arr; // echo json_encode($return_arr); // exit; // } }else{ $return_arr['message'] = "No account associated with this credentials."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } } function update_all_sms_config_api_status($status,$utility_class,$db){ $query = "UPDATE `cnf_sms_api` SET `is_activated`=$status WHERE 1"; $db->sql_query($query); } function update_sms_config_api_status($sms_api_id,$status,$utility_class,$db){ $query = "UPDATE `cnf_sms_api` SET `is_activated`=$status WHERE 1 AND id = $sms_api_id"; $db->sql_query($query); } function update_sms_config_template($template_id,$value,$utility_class,$db){ $query = "UPDATE `cnf_sms_templates` SET `description`=NULLIF('$value','') WHERE 1 AND id = $template_id"; $db->sql_query($query); } function update_notification_template($template_id,$name,$value,$is_active,$utility_class,$db){ $query = "UPDATE `cnf_notification_templates` SET `name` = NULLIF('$name',''),`description`=NULLIF('$value',''),`is_active`=NULLIF('$is_active','') WHERE 1 AND id = $template_id"; $db->sql_query($query); } function read_notification_by_id($id,$db){ $query = "SELECT * FROM `cnf_notification_templates` WHERE 1 AND `id` = $id"; return $db->sql_query($query); } function insert_notification_template($template_id,$name,$value,$is_active,$utility_class,$db){ $query = "INSERT INTO `cnf_notification_templates`(`id`, `name`, `description`, `is_active`,`status`) VALUES ($template_id,NULLIF('$name',''),NULLIF('$value',''),NULLIF('$is_active',''),1)"; $db->sql_query($query); } function read_system_config($utility_class,$db){ $query = "SELECT * FROM `cnf_system` WHERE 1"; return $db->sql_query($query); } function read_sms_templates($utility_class,$db){ $query = "SELECT * FROM `cnf_sms_templates` WHERE 1 AND status = 1"; return $db->sql_query($query); } function read_notification_template($utility_class,$db){ $query = "SELECT * FROM `cnf_notification_templates` WHERE 1 AND status = 1"; return $db->sql_query($query); } function read_notification_reminder($utility_class,$db){ $query = "SELECT * FROM `cnf_reminder_times` WHERE 1 "; return $db->sql_query($query); } function read_notification_reminder_by_type($type,$utility_class,$db){ $query = "SELECT * FROM `cnf_reminder_times` WHERE 1 AND type=$type"; return $db->sql_query($query); } function remove_role($id,$utility_class,$db){ $query = "UPDATE `cnf_roles` SET `status`=0 WHERE id = $id"; $affected_rows = $db->sql_query_affected_rows($query); return intval($affected_rows); } function update_system_config($array_data,$utility_class,$db){ $url = $array_data['url']; $url = ($utility_class->stringStartsWith($url,'http://') || $utility_class->stringStartsWith($url,'https://')) ? $url : 'https://'.$url ; $url = $utility_class->stringEndsWith($url,'/') ? $url : $url.'/' ; $query = "UPDATE `cnf_system` SET `value`='$url' WHERE `name` = 'url' "; $db->sql_query($query); //NAME $name = $array_data['name']; $query = "UPDATE `cnf_system` SET `value`='$name' WHERE `name` = 'name' "; $db->sql_query($query); } function role_universal_query(){ return "SELECT %s FROM `cnf_roles` cr INNER JOIN cnf_role_access cra ON cr.id = cra.role_id LEFT OUTER JOIN user_categories uc ON cra.user_category_id = uc.id WHERE 1 "; } function read_role_information($role_id,$utility_class,$db){ $role_universal_query = $this->role_universal_query(); $fields = " cr.id,cr.name,(SELECT COUNT(1) FROM users su INNER JOIN user_accounts sus ON su.id = sus.user_id WHERE sus.role_id = cr.id AND su.status = 1 AND sus.is_active = 1) as user_count, cra.json_access, cra.json_dealer, uc.name as user_category "; $query = $role_universal_query." AND cr.id = %s AND cr.status = 1"; $query_formatted = sprintf($query,$fields,$role_id); return $db->sql_query($query_formatted); } function read_role_list($user_id,$search,$offset,$limit,$utility_class,$db){ $role_universal_query = $this->role_universal_query(); $offset_limit = "LIMIT ".$offset.",".$limit." "; $fields = " cr.id,cr.name,(SELECT COUNT(1) FROM users su INNER JOIN user_accounts sus ON su.id = sus.user_id WHERE sus.role_id = cr.id AND su.status = 1 AND sus.is_active = 1) as user_count, cra.json_access, cra.json_dealer, cra.json_brand, uc.name as user_category "; $count = " COUNT(1) "; $query = $role_universal_query." AND cr.name LIKE '%%%s%%' AND cr.status = 1 ORDER BY name ASC %s"; $query_formatted = sprintf($query,$fields,$search,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_role_brand_list($user_id,$search,$offset,$limit,$utility_class,$db){ $offset_limit = "LIMIT ".$offset.",".$limit." "; $fields = " `id`, `name` "; $count = " COUNT(1) "; $query = "SELECT %s FROM `vehicle_brands` WHERE 1 AND name LIKE '%%%s%%' AND status = 1 ORDER BY name ASC %s"; $query_formatted = sprintf($query,$fields,$search,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_position_list($user_id,$search,$offset,$limit,$utility_class,$db){ $offset_limit = "LIMIT ".$offset.",".$limit." "; $fields = " `id`, `name` "; $count = " COUNT(1) "; $query = "SELECT %s FROM `user_positions` WHERE 1 AND name LIKE '%%%s%%' AND status = 1 ORDER BY name ASC %s"; $query_formatted = sprintf($query,$fields,$search,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_category_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `user_categories` WHERE 1 AND name = '$name' AND status = 1 LIMIT 1"; return $db->select($query); } function read_role_count_by_name($name,$utility_class,$db){ $query = "SELECT COUNT(1) FROM `cnf_roles` WHERE 1 AND name = '$name' AND status = 1"; return $db->select($query); } function create_role($user_id,$name,$utility_class,$db){ $query = "INSERT INTO `cnf_roles`(`name`, `user_id`, `date_added`, `status`) VALUES ('$name',$user_id,NOW(),1)"; return $db->sql_query_id($query); } function create_role_access($role_id,$role_data,$brand_data,$json_dealer,$category_id,$utility_class,$db){ $query = "INSERT INTO `cnf_role_access`( `role_id`, `json_access`, `json_brand`, `json_dealer`, `user_category_id`) VALUES ($role_id,NULLIF('$role_data',''),NULLIF('$brand_data',''),NULLIF('$json_dealer',''),NULLIF('$category_id',''))"; return $db->sql_query_id($query); } function read_user_categories($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `user_categories` WHERE name LIKE '%$search%' AND status = 1 ORDER BY id ASC;"; return $db->sql_query($query); } function read_sms_apis($search,$utility_class,$db){ $query = "SELECT * FROM `cnf_sms_api` WHERE 1 AND `status` = 1 ORDER BY `name` ASC"; return $db->sql_query($query); } function read_user_by_source_id($user_source_id,$utility_class,$db){ $query = "SELECT * FROM `users` WHERE 1 AND `source_id` = $user_source_id"; return $db->sql_query($query); } function create_user_api($user_source_id,$user_source,$id_number,$position_id,$dealer_id,$firstname,$middlename,$lastname,$utility_class,$db){ $query = "INSERT INTO `users`(`id_number`, `position_id`,`dealer_id`, `firstname`, `middlename`, `lastname`, `date_added`, `status`, `source`, `source_id`) VALUES (NULLIF('$id_number',''),NULLIF('$position_id',''),NULLIF('$dealer_id',''),NULLIF('$firstname',''),NULLIF('$middlename',''),NULLIF('$lastname',''),NOW(),1,NULLIF('$user_source',''),NULLIF('$user_source_id',''))"; return $db->sql_query_id($query); } function create_user_contact_api($user_id,$mobile,$email,$utility_class,$db){ $query = "INSERT INTO `user_contacts`(`user_id`, `mobile`, `email`) VALUES (NULLIF('$user_id',''),NULLIF('$mobile',''),NULLIF('$email',''))"; $db->sql_query($query); } function create_user_account_api($user_id,$username,$password,$utility_class,$db){ $query = "INSERT INTO `user_accounts`(`user_id`, `username`, `password`, `is_active`) VALUES (NULLIF('$user_id',''),NULLIF('$username',''),NULLIF('$password',''),1)"; $db->sql_query($query); } function update_user_api($user_id,$user_source_id,$user_source,$id_number,$position_id,$dealer_id,$firstname,$middlename,$lastname,$utility_class,$db){ $query = "UPDATE `users` SET `id_number`=NULLIF('$id_number',''),`position_id` = NULLIF('$position_id',''),`dealer_id`=NULLIF('$dealer_id',''),`firstname`=NULLIF('$firstname',''),`middlename`=NULLIF('$middlename',''),`lastname`=NULLIF('$lastname','') WHERE 1 AND id = $user_id"; return $db->sql_query_id($query); } function update_user_contact_api($user_id,$mobile,$email,$utility_class,$db){ $query = "UPDATE `user_contacts` SET `mobile`=NULLIF('$mobile',''),`email`=NULLIF('$email','') WHERE 1 AND user_id = $user_id "; $db->sql_query($query); } function update_user_account_api($user_id,$username,$password,$utility_class,$db){ $query = "UPDATE `user_accounts` SET `username`=NULLIF('$username',''),`password`=NULLIF('$password','') WHERE 1 AND user_id = $user_id"; $db->sql_query($query); } function create_user_login_token($user_id,$added_by_user_id,$source_id,$token,$type,$utility_class,$db){ $query = "INSERT INTO `user_login_token`(`added_by_user_id`,`user_id`, `source_id`, `token`, `type`, `date_added`, `status`) VALUES ($added_by_user_id,$user_id,$source_id,'$token',$type,NOW(),1)"; $db->sql_query($query); } function read_roles($search,$no_admin,$utility_class,$db){ $query = "SELECT * FROM `cnf_roles` WHERE 1 AND name LIKE '%$search%' AND status = 1 $no_admin ORDER BY name"; return $db->sql_query($query); } function read_role_id_by_name($name,$utility_class,$db){ return $db->select("SELECT id FROM `cnf_roles` WHERE 1 AND name = '$name' AND status = 1 LIMIT 1"); } function user_universal_query(){ return "SELECT %s FROM `users` u INNER JOIN user_contacts uc ON u.id = uc.user_id INNER JOIN user_accounts ua ON u.id = ua.user_id LEFT OUTER JOIN cnf_roles r ON ua.role_id = r.id LEFT OUTER JOIN user_positions up ON u.position_id = up.id WHERE 1"; } function create_api_notifications($array_data,$utility_class,$db){ $target_json = $array_data['target_json']; $target_id = $array_data['target_id']; $api_type = $array_data['api_type']; $data_type = $array_data['data_type']; $query="INSERT INTO `cnf_api_notifications`(`target_json`, `target_id`, `api_type`, `data_type`, `date_added`, `status`) VALUES (NULLIF('$target_json',''),NULLIF('$target_id',''),NULLIF('$api_type',''),NULLIF('$data_type',''),NOW(),1)"; $db->sql_query($query); } function update_user_role($user_id,$role_id,$db){ $query = "UPDATE `user_accounts` SET `role_id`=NULLIF('$role_id','') WHERE 1 AND user_id = $user_id"; $db->sql_query($query); } function read_user_list($user_id,$role_id,$no_admin,$search,$offset,$limit,$utility_class,$db){ $user_universal_query = $this->user_universal_query(); $offset_limit = "LIMIT ".$offset.",".$limit." "; if($utility_class->isNotEmpty($role_id)){ if($role_id === 0){ $role_filter = $utility_class->isNotEmpty($role_id) ? " AND r.id IS NULL " : '' ; }else{ $role_filter = $utility_class->isNotEmpty($role_id) ? " AND r.id IN ($role_id) " : '' ; } }else{ $role_filter = ''; } $fields = " u.id,CONCAT(u.firstname,' ',u.lastname) as name,u.id_number,uc.mobile,uc.email,r.id as role_id, r.name as role,up.name as position"; $count = " COUNT(1) "; $query = $user_universal_query." AND CONCAT(u.id_number,' ',u.firstname,' ',u.lastname,' ',uc.mobile,' ',uc.email) LIKE '%%%s%%' %s /*role_filter*/ %s /*filter admin*/ AND u.status = 1 %s /*offset Limit*/"; $query_formatted = sprintf($query,$fields,$search,$role_filter,$no_admin,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,$role_filter,$no_admin,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_user_position_by_name($name,$utility_class,$db){ $query = "SELECT * FROM `user_positions` WHERE 1 AND name = '$name' LIMIT 1"; return $db->sql_query($query); } function create_user_position($user_id,$name,$code,$rank_level,$utility_class,$db){ $query = "INSERT INTO `user_positions`( `name`, `rank`,`code`, `user_id`, `date_added`, `status`) VALUES (NULLIF('$name',''),NULLIF('$rank_level',''),NULLIF('$code',''),NULLIF('$user_id',''),NOW(),1)"; return $db->sql_query_id($query); } function update_user_position($user_id,$position_id,$name,$code,$rank_level,$utility_class,$db){ $query = "UPDATE `user_positions` SET `name`=NULLIF('$name','') WHERE 1 AND id = $position_id"; $db->sql_query($query); } function update_reminder_times($reminder_data,$utility_class,$db){ $q = 'INSERT INTO `cnf_reminder_times`(`type`, `minutes`, `hours`, `days`) VALUES '.implode(",",$reminder_data).' ON DUPLICATE KEY UPDATE minutes = VALUES (minutes), hours = VALUES (hours), days = VALUES (days) '; return $db->sql_query_affected_rows($q); } function update_user_login_token_status($user_id,$status,$type,$utility_class,$db){ $query = "UPDATE user_login_token SET status = $status WHERE user_id = $user_id AND type = $type"; $db->sql_query($query); } function read_user_login_token($token,$type,$status,$db){ $query = "SELECT * FROM `user_login_token` WHERE `token` = '$token' AND `type` = $type AND `status` = $status LIMIT 1"; return $db->sql_query($query); } function read_viber_subscription($user_id,$utility_class,$db){ $query = "SELECT * FROM `cnf_api_token_ids` WHERE 1 AND `status` = 1 AND `is_subscribe` = 1 AND `user_id` = $user_id AND type = 1 LIMIT 1"; return $db->sql_query($query); } }
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings