<?php

class modules_helper {
    

    static function dbconnect() {
        global $config;
        global $conn;
        $conn = mysqli_connect($config['db_host'],$config['db_username'],$config['db_password'],$config['db_name']);
        mysqli_query($conn,"SET NAMES utf8");
        mysqli_query($conn,"SET CHARACTER utf8");

        return true;
    }

    
    static function getModules() {
        self::dbconnect();
        global $conn;

        $result = mysqli_query($conn,"select * from azonics_modules where module_status='1' order by module_name asc;");
        
        if (mysqli_num_rows($result)>0) {
            while($row = mysqli_fetch_object($result)) $resultObjects[] = $row;
            return $resultObjects;
        }
        else {
            return false;
        }
    }
    
    
    static function checkRoleModuleStatus($roleID,$moduleID='') {
        self::dbconnect();
        global $conn;

        if ($moduleID!='') {
            $result = mysqli_query($conn,"select * from azonics_modules_role where "
                    . "modrole_role_id='".$roleID."' and "
                    . "modrole_module_id='".$moduleID."' and "
                    . "modrole_status='1';");
            if (mysqli_num_rows($result)>0) {
                return true;
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }
    
    
    static function getUserAccess($userid='') {
        self::dbconnect();
        global $conn;

        $userid = mysql_real_escape_string($userid);
        $res = mysqli_query($conn,"select * from azonics_users where user_id='".$userid."';");
        if (mysqli_num_rows($res)>0) {
            $row = mysqli_fetch_array($res);
            if ($row['user_type']=='1' || $row['user_type']=='4') {
                return 1;
            }
            else {
                return false;
            }
        }
        else {
            return false;
        }
    }
    
    
    static function getDefaultMailer($sales_id) {
        self::dbconnect();
        global $conn;

        if ($sales_id==0) {
            $res = mysqli_query($conn,"select * from azonics_users where user_default_mailer_status='1';");
        }
        else {
            $res = mysqli_query($conn,"select * from azonics_users where user_id='".$sales_id."';");
        }
        
        if (mysqli_num_rows($res)>0) {
            $row = mysqli_fetch_object($res);
            return $row;
        }
        else {
            return false;
        }
    }
    
    
}