<?php
/**
 * Created by PhpStorm.
 * User: liyifei2012it
 * Date: 17/5/18
 * Time: 11:35
 */

namespace Common\Model;

class ColumnModel extends AbstractModel
{

    // 构造方法
    public function __construct()
    {
        parent::__construct();
    }


    /**
     * @param array $conds
     * @param array $conds 传入条件
     *              + string startdate 开始日期
     *              + string enddate  结束日期
     *              + array uids    用户uid集合
     *              + array obj_ids 栏目id集合
     * @return list
     */
    public function list_column_data($conds = array())
    {
        // 组装查询语句
        $where = " status <? AND domain=?";
        // 操作状态和域名
        $params[] = $this->get_st_delete();
        $params[] = QY_DOMAIN;

        if (!empty($conds['uids'])) {

            $where .= " AND uid in(?)";
            $params[] = $conds['uids'];
        }

        $where .= " AND obj_id in(?)";
        $params[] = $conds['obj_ids'];

        $where .= " AND created >=? AND created<=?";
        $params[] = $conds['starttime'];
        $params[] = $conds['endtime'];

        $sql = 'SELECT COUNT(*) as total ,obj_id FROM __TABLE__ WHERE ' . $where .' group by obj_id';

        return $this->_m->fetch_array($sql, $params);
    }



}