/** * 取得获取数据的Select对象 * * @see ZtChart_Model_Assemble_Backend_Abstract::select() * @param string $start 起始时间 * @param string $end 结束时间 * @param integer $pos 时间位置 * @return Zend_Db_Select */ public function select($start, $end, $pos) { $select = $this->columns(self::ROW_LABEL, self::ROW_DATA); $select->where('usertrade_datetime >= ?', ZtChart_Model_Assemble_Datetime::padDatetime($start, $pos))->where('usertrade_datetime < ?', ZtChart_Model_Assemble_Datetime::padDatetime($end, $pos)); if (null !== $this->_opType) { $select->where('usertrade_optype = ?', $this->_opType); } if (null !== $this->_netbank) { // $this->clearGameTypes(); $select->where('usertrade_netbank = ?', $this->_netbank); } return $select; }
/** * 比较截止日期与当前日期 * * @param string $datetime * @return string */ public function deadline($datetime) { if (!empty($datetime)) { $padDatetime = ZtChart_Model_Assemble_Datetime::padDatetime($datetime, Zend_Date::SECOND); switch (strcmp($padDatetime, $this->_deadline)) { case -1: case 0: return $datetime; case 1: return substr($this->_deadline, 0, strlen($datetime)); } } }
/** * 取得获取数据的Select对象 * * @see ZtChart_Model_Assemble_Backend_Abstract::select() * @param string $start 起始时间 * @param string $end 结束时间 * @param integer $pos 时间位置 * @return Zend_Db_Select */ public function select($start, $end, $pos) { $select = $this->columns(self::ROW_LABEL, self::ROW_DATA); $select->where("flserver_datetime >= ?", ZtChart_Model_Assemble_Datetime::padDatetime($start, $pos))->where("flserver_datetime < ?", ZtChart_Model_Assemble_Datetime::padDatetime($end, $pos)); return $select; }
/** * 取得时间范围 * * @param string $start * @param string $end * @param string $unit * @return array */ protected function _getDatetimeRange(&$start, &$end, $unit) { if (empty($start) && empty($end)) { $start = $end = ZtChart_Model_Assemble_Datetime::padDatetime(time(), $unit); } else { if (empty($start)) { $start = ZtChart_Model_Assemble_Datetime::ERA_DATETIME; } else { if (empty($end)) { $end = ZtChart_Model_Assemble_Datetime::padDatetime(time(), $unit); } } } return ZtChart_Model_Assemble_Datetime::getDatetimeRange($start, $end, $unit); }