$date_end = $query->row['date_end'];
if($date_end=='0000-00-00'){
$date_end = date('Y-m-d', strtotime('+1 year'));
}
$date_end = date('Y-m-d', strtotime('+1 year'));
if($date_end=='0000-00-00'){
$date_end = date('Y-m-d', strtotime('+1 year'));
}