118
118
$query->condition('qatracker_build_milestone.status', array(0, 1, 4), "IN");
121
if(array_key_exists("date_from", $_POST) && $_POST['date_from']) {
122
$query->condition('qatracker_build.date', DateTime::createFromFormat('m/d/Y', $_POST['date_from'])->format("Ymd"), ">=");
121
if(array_key_exists('date_from', $_POST) && $_POST['date_from']) {
122
$query->condition('qatracker_build_milestone.date', DateTime::createFromFormat('m/d/Y', $_POST['date_from'])->format('Ymd'), '>=');
124
$date_from = new DateTime();
125
$date_from->sub(new DateInterval('P31D'));
126
$query->condition('qatracker_build_milestone.date', $date_from->format('Ymd'), '>=');
124
if(array_key_exists("date_to", $_POST) && $_POST['date_to']) {
125
$query->condition('qatracker_build.date', DateTime::createFromFormat('m/d/Y', $_POST['date_to'])->format("Ymd"), "<=");
129
if(array_key_exists('date_to', $_POST) && $_POST['date_to']) {
130
$query->condition('qatracker_build_milestone.date', DateTime::createFromFormat('m/d/Y', $_POST['date_to'])->format('Ymd'), '<=');
132
$date_to = new DateTime();
133
$query->condition('qatracker_build_milestone.date', $date_to->format('Ymd'), '<=');
128
136
$query->condition('qatracker_build_milestone.milestoneid', $milestoneid);