/**
* 取得获取数据的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);
}
