/**
* 每月输出
* return array
*/
function cmd_month_out()
{
$tt = date("n", time());//本月是第几个月
//echo $tt; global $tablename, $pageassigns, $per_page, $np;
global $selectClause, $whereClause, $orderClause, $groupClause;
global $totalRows_month;
$arrWeek = array('一','二','三','四','五','六','七','八','九','十','十一','十二');
for($i=1;$i<=$tt;$i++)
{
$tablename = " shopvisit as s, product as p, user as u ";
$selectClause = " if(sum(s.total), sum(s.total), 0) as total, '".$arrWeek[$tt-$i]."' as days ";
$whereClause = " s.type = 1 and s.objId = p.id and u.id = p.userid and p.userid =".(int)$_SESSION['userid']." and (s.dateline between (这里怎么写????))";
//从第几条记录返回
$begin = ($np - 1) * $per_page;
// 分页查询记录
$pageassigns['mysqlData_month'][$i] = func_search($selectClause, $tablename, $whereClause, '', '', $per_page, $begin);
$pageassigns['totalRows_month'] +=$pageassigns['mysqlData_month'][$i][0]["TOTAL"];
}
//print_R($pageassigns['mysqlData_month']);
}
* 每月输出
* return array
*/
function cmd_month_out()
{
$tt = date("n", time());//本月是第几个月
//echo $tt; global $tablename, $pageassigns, $per_page, $np;
global $selectClause, $whereClause, $orderClause, $groupClause;
global $totalRows_month;
$arrWeek = array('一','二','三','四','五','六','七','八','九','十','十一','十二');
for($i=1;$i<=$tt;$i++)
{
$tablename = " shopvisit as s, product as p, user as u ";
$selectClause = " if(sum(s.total), sum(s.total), 0) as total, '".$arrWeek[$tt-$i]."' as days ";
$whereClause = " s.type = 1 and s.objId = p.id and u.id = p.userid and p.userid =".(int)$_SESSION['userid']." and (s.dateline between (这里怎么写????))";
//从第几条记录返回
$begin = ($np - 1) * $per_page;
// 分页查询记录
$pageassigns['mysqlData_month'][$i] = func_search($selectClause, $tablename, $whereClause, '', '', $per_page, $begin);
$pageassigns['totalRows_month'] +=$pageassigns['mysqlData_month'][$i][0]["TOTAL"];
}
//print_R($pageassigns['mysqlData_month']);
}
数据库中日期是怎么存放的呀应该很好解决的多想想办法就会出来的