ChMbpDb.php

Go to the documentation of this file.

<?php
 
ch_import('ChWsbModuleDb');
 
class ChMbpDb extends ChWsbModuleDb
{
    var $_oConfig;
    /*
     * Constructor.
     */
    function __construct(&$oConfig)
    {
        parent::__construct($oConfig);
 
        $this->_oConfig = &$oConfig;
    }
 
    function getMembershipsBy($aParams = array())
    {
        $sMethod = "getAll";
        $sSelectClause = $sJoinClause = $sWhereClause = $sOrderClause = $sLimitClause = "";
        if(isset($aParams['type']))
            switch($aParams['type']) {
                case 'price_id':
                    $sMethod = "getRow";
                    $sSelectClause .= ", `tlp`.`id` AS `price_id`, `tlp`.`Days` AS `price_days`, `tlp`.`Price` AS `price_amount`";
                    $sJoinClause .= "LEFT JOIN `sys_acl_level_prices` AS `tlp` ON `tl`.`ID`=`tlp`.`IDLevel`";
                    $sWhereClause .= " AND `tl`.`Active`='yes' AND `tl`.`Purchasable`='yes' AND `tlp`.`id`='" . $aParams['id'] . "'";
                    break;
                case 'price_all':
                    $sSelectClause .= ", `tlp`.`id` AS `price_id`, `tlp`.`Days` AS `price_days`, `tlp`.`Price` AS `price_amount`";
                    $sJoinClause .= "LEFT JOIN `sys_acl_level_prices` AS `tlp` ON `tl`.`ID`=`tlp`.`IDLevel`";
                    $sWhereClause = " AND `tl`.`Active`='yes' AND `tl`.`Purchasable`='yes' AND NOT ISNULL(`tlp`.`id`)";
                    if(isset($aParams['include_standard']) && $aParams['include_standard'] === true)
                        $sWhereClause .= " OR `tl`.`ID`=" . MEMBERSHIP_ID_STANDARD;
                    $sOrderClause = " ORDER BY `tl`.`Order` ASC, `tlp`.`Price` ASC";
                    break;
                case 'level_id':
                    $sMethod = "getRow";
                    $sWhereClause .= " AND `tl`.`ID`='" . $aParams['id'] . "'";
                    break;
            }
 
        $sSql = "SELECT
                `tl`.`ID` AS `mem_id`,
                `tl`.`Name` AS `mem_name`,
                `tl`.`Icon` AS `mem_icon`,
                `tl`.`Description` AS `mem_description` " . $sSelectClause . "
            FROM `sys_acl_levels` AS `tl` " . $sJoinClause . "
            WHERE 1" . $sWhereClause . $sOrderClause . $sLimitClause;
       return $this->$sMethod($sSql);
    }
 
    function getExpiringMemberships()
    {
        $sSql = "SELECT
                `tlm`.`IDMember` AS `member_id`,
                `tlm`.`IDLevel` AS `level_id`,
                `tlm`.`DateStarts` AS `date_starts`,
                `tlm`.`DateExpires` AS `date_expires`,
                `tlm`.`TransactionID` AS `transaction_id`,
                `tlm`.`Expiring` AS `expiring`
            FROM `sys_acl_levels_members` AS `tlm`
            WHERE `tlm`.`Expiring`='1'";
 
        return $this->getAll($sSql);
    }
}