class.ilAccountCode.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilAccountCode
{
        const DB_TABLE = 'usr_account_codes';
        const CODE_LENGTH = 10;
        
        public static function create($valid_until, $stamp)
        {
                global $ilDB;
                
                $id = $ilDB->nextId(self::DB_TABLE);
                
                // create unique code
                $found = true;
                while ($found)
                {
                        $code = self::generateRandomCode();
                        $chk = $ilDB->queryF("SELECT code_id FROM ".self::DB_TABLE." WHERE code = %s", array("text"), array($code));
                        $found = (bool)$ilDB->numRows($chk);
                }
                
                $data = array(
                        'code_id' => array('integer', $id),
                        'code' => array('text', $code),
                        'generated' => array('integer', $stamp),
                        'valid_until' => array('text', $valid_until)
                        );

                $ilDB->insert(self::DB_TABLE, $data);
                return $id;
        }
        
        protected static function generateRandomCode()
        {
                // missing : 01iloO
                $map = "23456789abcdefghjkmnpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ";
                
                $code = "";
                $max = strlen($map)-1;
                for($loop = 1; $loop <= self::CODE_LENGTH; $loop++)
                {
                  $code .= $map[mt_rand(0, $max)];
                }
                return $code;
        }
        
        public static function getCodesData($order_field, $order_direction, $offset, $limit, $filter_code, $filter_valid_until, $filter_generated)
        {
                global $ilDB;
                
                // filter
                $where = self::filterToSQL($filter_code, $filter_valid_until, $filter_generated);

                // count query
                $set = $ilDB->query("SELECT COUNT(*) AS cnt FROM ".self::DB_TABLE.$where);
                $cnt = 0;
                if ($rec = $ilDB->fetchAssoc($set))
                {
                        $cnt = $rec["cnt"];
                }
                
                $sql = "SELECT * FROM ".self::DB_TABLE.$where;
                if($order_field)
                {
                        $sql .= " ORDER BY ".$order_field." ".$order_direction;
                }
                
                // set query
                $ilDB->setLimit((int)$limit, (int)$offset);
                $set = $ilDB->query($sql);
                $result = array();
                while($rec = $ilDB->fetchAssoc($set))
                {
                        $result[] = $rec;
                }
                return array("cnt" => $cnt, "set" => $result);
        }
        
        public static function loadCodesByIds(array $ids)
        {
                global $ilDB;

                $set = $ilDB->query("SELECT * FROM ".self::DB_TABLE." WHERE ".$ilDB->in("code_id", $ids, false, "integer"));
                $result = array();
                while($rec = $ilDB->fetchAssoc($set))
                {
                        $result[] = $rec;
                }
                return $result;
        }
        
        public static function deleteCodes(array $ids)
        {
                global $ilDB;

                if(sizeof($ids))
                {
                        return $ilDB->manipulate("DELETE FROM ".self::DB_TABLE." WHERE ".$ilDB->in("code_id", $ids, false, "integer"));
                }
                return false;
        }
        
        public static function getGenerationDates()
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT DISTINCT(generated) AS generated FROM ".self::DB_TABLE." ORDER BY generated");
                $result = array();
                while($rec = $ilDB->fetchAssoc($set))
                {
                        $result[] = $rec["generated"];
                }
                return $result;
        }
        
        protected static function filterToSQL($filter_code, $filter_valid_until, $filter_generated)
        {
                global $ilDB;

                $where = array();
                if($filter_code)
                {
                        $where[] = $ilDB->like("code", "text", "%".$filter_code."%");
                }
                if($filter_valid_until)
                {
                        $where[] ="valid_until = ".$ilDB->quote($filter_valid_until, "text");
                }
                if($filter_generated)
                {
                        $where[] ="generated = ".$ilDB->quote($filter_generated, "text");
                }
                if(sizeof($where))
                {
                        return " WHERE ".implode(" AND ", $where);
                }
                else
                {
                        return "";
                }
        }
        
        public static function getCodesForExport($filter_code, $filter_valid_until, $filter_generated)
        {
                global $ilDB;

                // filter
                $where = self::filterToSQL($filter_code, $filter_valid_until, $filter_generated);

                // set query
                $set = $ilDB->query("SELECT code FROM ".self::DB_TABLE.$where." ORDER BY code_id");
                $result = array();
                while($rec = $ilDB->fetchAssoc($set))
                {
                        $result[] = $rec["code"];
                }
                return $result;
        }
        
        public static function isUnusedCode($code)
        {
                global $ilDB;
                
                $set = $ilDB->query("SELECT used FROM ".self::DB_TABLE." WHERE code = ".$ilDB->quote($code, "text"));
                $set = $ilDB->fetchAssoc($set);
                if($set && !$set["used"])
                {
                        return true;
                }
                return false;
        }
        
        public static function useCode($code)
        {
                global $ilDB;

                return (bool)$ilDB->update(self::DB_TABLE, array("used"=>array("timestamp", time())), array("code"=>array("text", $code)));
        }

        public static function getCodeValidUntil($code)
    {
                global $ilDB;

                $set = $ilDB->query("SELECT valid_until FROM ".self::DB_TABLE." WHERE code = ".$ilDB->quote($code, "text"));
                $row = $ilDB->fetchAssoc($set);
                if(isset($row["valid_until"]))
                {
                        return $row["valid_until"];
                }
        }
}

?>