"select mo.*
,DATE_ADD(start_date,INTERVAL day DAY) as end_date,
TO_DAYS(CURRENT_DATE)-TO_DAYS(start_date) AS start_diff_date,TO_DAYS(CURRENT_DATE)-TO_DAYS(DATE_ADD(start_date,INTERVAL day DAY)) AS end_diff_date,
m.name as user_name
from ".$this->table." mo
left join member m on(mo.member_code=m.code)
where 1".$add_where." order by mo.code desc";
foreach($data['list'] as $key => $val) {
if($val['start_diff_date']<0){
$data['list'][$key]['status3']='w';
}else if($val['end_diff_date']>0){
$data['list'][$key]['status3']='e';
}else if($val['start_diff_date']>=0&&$val['end_diff_date']<=0){
$data['list'][$key]['status3']='i';
}
}
댓글