$str_field = $field ? "AND c.field ='" . asCleanString($field) . "'" : '';
$str_person = $person ? "AND c.modified_by = " . intval($person) : '';
### show all ###
$str_query = "SELECT c.* from {$prefix}itemchange c\r\n WHERE 1\r\n {$str_project}\r\n {$str_item}\r\n {$str_person}\r\n {$str_field}\r\n {$str_date_max}\r\n {$str_date_min}\r\n " . getOrderByString($order_by);
$dbh = new DB_Mysql();
$sth = $dbh->prepare($str_query);
$sth->execute("", 1);
$tmp = $sth->fetchall_assoc();
$item_changes = array();
foreach ($tmp as $t) {
$c = new ItemChange($t);
$item_changes[] = $c;
}
return $item_changes;
}
/**
* query from db
*
* - returns NULL if failed
*/
static function getById($id)
{
$i = new DbItemChange($id);
if ($i->id) {
return $i;
}
return NULL;
}
}
ItemChange::initFields();
