card.class.php

是一个基于PHP+Mysql架构的开源内容管理系统

<?php
class card
{
	var $card_table = '';
	var $cardtype_table = '';
	var $db = '';
	var $lang ;
	function card()
	{
		global $db , $LANG;
		$this->lang		= $LANG;
		$this->db		= $db;
		$this->table_c	= DB_PRE.'pay_card';
		$this->table_t	= DB_PRE.'pay_pointcard_type';
	}

	function get_list( $condition = null, $page = 1, $pagesize )
	{

		$cards = array();
		$arg['where']	= $this->_make_condition($condition);
		$page			= max(intval($page), 1);
        $offset			= $pagesize*($page-1);
		$cards['num']	= $this->db->get_one("SELECT COUNT(*) AS number FROM `$this->table_c` WHERE 1 {$arg['where']} ");
		$cards['pages'] = pages($cards['num']['number'], $page, $pagesize);
		$sql = "SELECT *,c.amount,c.point,name FROM `$this->table_c` AS c INNER JOIN `$this->table_t` AS t ON c.ptypeid = t.ptypeid  WHERE 1 {$arg['where']}   ORDER BY `mtime` DESC LIMIT $offset,$pagesize";
		$result = $this->db->query($sql);
		while($r = $this->db->fetch_array($result))
		{
            if($r['endtime'] <= TIME && !empty($r['endtime'])) $r['endstatus'] = 1;
            $r['endtime'] = date('Y-m-d',$r['endtime']);
            $mtime = explode(" ",$r['mtime']);
            $r['mtime'] = $mtime['0'];
            $regtime = explode(" ",$r['regtime']);
            $r['regtime'] = $regtime['0'];
            $cards['info'][] = $r;
		}
		return $cards;
	}

	function add($typeid, $cardnum, $carlength, $prefix, $endtime = '')
	{
		global $_userid, $_username;
        $endtim = trim($endtime);
        if(!empty($endtime))
        {
            $endtime = strtotime($endtime);
        }
        else
        {
            $endtime = TIME+365*2*24*60*60;
        }
		$ptypeid = intval($typeid);//鍗＄被鍨