File manager

File manager - Edit - /home/autoph/public_html/connectv1/lms/app/controllers/group.php

Back
<?php class Group{ function add_temporary_group($user_id,$db){ $query_insert_group = "INSERT INTO `lms2_groups`(`status`) VALUES (0)"; $group_id = $db->sql_query_id($query_insert_group); return $group_id; } function remove_temporary_group($group_id,$utility_class,$db){ $query_remove_group_member = "DELETE FROM `lms2_group_members` WHERE group_id = $group_id "; $db->sql_query($query_remove_group_member); $query_remove_group = "DELETE FROM `lms2_groups` WHERE id = $group_id "; return $db->sql_query_affected_rows($query_remove_group); } function get_group_owner_id($group_id,$utility_class,$db){ return $db->select("SELECT g.added_by FROM `lms2_groups` g WHERE 1 AND g.id = $group_id LIMIT 1"); } function get_member_group_id($group_owner_id,$utility_class,$db){ $query= "SELECT g.id FROM `lms2_groups` g INNER JOIN lms2_group_members gm ON g.id = gm.group_id WHERE 1 AND gm.member_id = $group_owner_id AND g.status = 1 AND gm.status = 1 "; // echo $query;exit; return $db->select($query); } function group_user_table($array_data,$excepted_ids_arr,$utility_class,$db){ if(count($excepted_ids_arr) > 0){ $excepted_ids = " AND u.id NOT IN (".implode(',', $excepted_ids_arr).") "; }else{ $excepted_ids = ""; } $search = $array_data['search']; $group_id = $array_data['group_id']; $offset_limit = ""; $field = " u.`id`,u.`id_number`,CONCAT(u.`firstname`,' ',u.`lastname`) as name, IFNULL((SELECT CONCAT(g.status,gms.status) FROM `lms2_users` uu LEFT OUTER JOIN lms2_group_members gms ON uu.id = gms.member_id LEFT OUTER JOIN lms2_groups g ON gms.group_id = g.id WHERE 1 AND uu.id = u.id AND uu.`status` = 1 AND g.status = 1 AND gms.status = 1 GROUP BY uu.id LIMIT 1),'') AS sstatus "; $field_count = " COUNT(1) "; $query = " SELECT %s FROM `lms2_users` u LEFT OUTER JOIN lms2_group_members gms ON u.id = gms.member_id LEFT OUTER JOIN lms2_groups g ON gms.group_id = g.id WHERE 1 AND CONCAT(u.`id_number`,' ',u.`firstname`,' ',u.`lastname`) LIKE '%%%s%%' AND u.`status` = 1 %s /excempted/ GROUP BY u.id HAVING sstatus <> '11' ORDER BY u.id_number ASC %s "; $query_formatted = sprintf( $query, $field, $search, $excepted_ids, $offset_limit ); // echo $query_formatted;exit; $query_formatted_count = "SELECT COUNT(1) FROM (".sprintf( $query, $field, $search, $excepted_ids, '' ).") t1"; // echo $query_formatted_count;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function group_member_table($array_data,$utility_class,$db){ $search = $array_data['search']; $group_id = $array_data['group_id']; $offset_limit = ""; $field = " u.`id`,u.`id_number`,CONCAT(u.`firstname`,' ',u.`lastname`) as name "; $field_count = " COUNT(1) "; $query = "SELECT %s FROM `lms2_users` u INNER JOIN lms2_group_members gm ON u.id = gm.member_id WHERE 1 AND CONCAT(u.`id_number`,' ',u.`firstname`,' ',u.`lastname`) LIKE '%%%s%%' AND u.`status` = 1 AND gm.status = 1 AND gm.group_id = $group_id ORDER BY u.id_number ASC %s "; $query_formatted = sprintf( $query, $field, $search, $offset_limit ); // echo $query_formatted;exit; $query_formatted_count = sprintf( $query, $field_count, $search, '' ); // echo $query_formatted;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_user_membership($group_id,$user_id,$utility_class,$db){ $query = "SELECT status FROM `lms2_group_members` WHERE `group_id` = $group_id AND `member_id` = $user_id "; // echo $query; return $db->sql_query($query); } function insert_member_status($group_id,$user_id,$status,$utility_class,$db){ $query = "INSERT INTO `lms2_group_members`(`group_id`, `member_id`, `date_added`, `status`) VALUES ($group_id,$user_id,NOW(),$status) "; return $db->sql_query_affected_rows($query); } function update_member_status($group_id,$user_id,$status,$utility_class,$db){ $query = "UPDATE `lms2_group_members` SET `status`=$status WHERE 1 AND `group_id`=$group_id AND `member_id`=$user_id "; // echo $query; return $db->sql_query_affected_rows($query); } function group_table($array_data,$user_id,$utility_class,$db){ // $offset_limit = "LIMIT ".$array_data['offset'].",".$array_data['limit']." "; $offset_limit = ""; $field = " g.id, g.name, g.added_by, CONCAT(u.firstname) as added_by_name, (SELECT COUNT(1) FROM lms2_users su INNER JOIN lms2_user_accounts sus ON su.id = sus.user_id INNER JOIN lms2_group_members gms ON su.id = gms.member_id WHERE 1 AND gms.group_id = g.id AND gms.status = 1 AND su.status = 1 AND sus.is_active_account = 1) as user_count "; $field_count = " COUNT(1) "; $query = "SELECT %s FROM `lms2_groups` g INNER JOIN lms2_users u ON g.added_by = u.id WHERE 1 AND g.name LIKE '%%%s%%' AND g.status = 1 AND g.added_by = $user_id ORDER BY g.`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;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function remove_group($id,$utility_class,$db){ $query = "UPDATE `lms2_groups` SET `status`=0 WHERE id = $id"; $affected_rows = $db->sql_query_affected_rows($query); return intval($affected_rows); } function update_group($group_id,$array_data,$user_id,$utility_class,$db){ $query = "UPDATE `lms2_groups` SET `name`=NULLIF('".$array_data['txt_group_name']."',''),`added_by`=NULLIF('$user_id',''),date_added = NOW(),`status`=1 WHERE id = $group_id"; $db->sql_query_affected_rows($query); } function insert_group($array_data,$user_id,$utility_class,$db){ $query = "INSERT INTO `lms2_groups`(`added_by`, `name`, `date_added`, `status`) VALUES (NULLIF('$user_id',''), NULLIF('".$array_data['txt_group_name']."',''),NOW(),1 )"; return $db->sql_query_id($query); } function insert_group_members($group_id,$selected_group_members_query,$user_id,$utility_class,$db){ $query = "INSERT INTO `lms2_group_members`(`group_id`, `member_id`, `date_added`, `status`) VALUES ".implode(", ",$selected_group_members_query).""; // echo $query;exit; return $db->sql_query($query); } } ?>

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