protected function getModelCriteria()
 {
     $input = self::getRequiredInput(array("sort_by" => FILTER_UNSAFE_RAW, "is_ascending" => FILTER_VALIDATE_BOOLEAN)) + self::getInput(array("search" => FILTER_UNSAFE_RAW));
     $query = DB_noma_registerQuery::create();
     //filter search input
     if ($input["search"] != "") {
         $query->filterByFname('%' . $input["search"] . '%')->_or()->filterByLname('%' . $input["search"] . '%')->_or()->filterByEmail('%' . $input["search"] . '%');
     }
     $query->orderBy($input["sort_by"], $input["is_ascending"] ? Criteria::ASC : Criteria::DESC);
     return $query;
 }
 protected function getModelCriteria()
 {
     return DB_noma_registerQuery::create()->select(array('Fname', 'Lname', 'Email', 'Address1', 'Address2', 'City', 'State', 'Zip', 'Country', 'Product', 'ProductPrice', 'CreatedAt'))->orderByCreatedAt();
 }