def news_list(): search_form = SearchNewsForm() ret, page = process_paginated_session_search('news_search_page', [ ('news_search', search_form.q), ]) per_page = get_items_per_page(search_form.items_per_page) if not ret: return redirect(url_for('main_news.news_list')) offset = (page - 1) * per_page news = News.query.filter(News.lang_code == get_site_lang_code()) if search_form.q.data: news = news.filter(News.name.like('%' + search_form.q.data + '%')) news_for_render = news.order_by( News.id.desc()).limit(per_page).offset(offset).all() pagination = Pagination(page=page, per_page=per_page, total=news.count(), search=False, record_name='news', css_framework='semantic', not_passed_args='back') return render_template('main/news/news_list.html', news=news_for_render, pagination=pagination, search_form=search_form)
def observed_list_info(): """View observed list.""" add_form = AddToObservedListForm() search_form = SearchObservedForm() ret, page = process_paginated_session_search('observed_search_page', [ ('observed_search', search_form.q), ('items_per_page', search_form.items_per_page) ]) per_page = get_items_per_page(search_form.items_per_page) if not ret: return redirect(url_for('main_observed.observed_list_info')) observed_list = ObservedList.create_get_observed_list_by_user_id(current_user.id) observed_list_items = observed_list.observed_list_items page_offset = (page - 1) * per_page if page_offset < len(observed_list_items): page_items = observed_list_items[page_offset:page_offset + per_page] else: page_items = [] pagination = Pagination(page=page, per_page=per_page, total=len(observed_list.observed_list_items), search=False, record_name='observed', css_framework='semantic', not_passed_args='back') return render_template('main/observation/observed_list.html', observed_list=observed_list, type='info', add_form=add_form, search_form=search_form, observed_list_items=enumerate(page_items), page_offset=page_offset, pagination=pagination)
def comets(): """View comets.""" search_form = SearchCometForm() ret, page = process_paginated_session_search('comet_search_page', [ ('comet_search', search_form.q), ]) per_page = get_items_per_page(search_form.items_per_page) if not ret: return redirect(url_for('main_comet.comets')) offset = (page - 1) * per_page comets = get_all_comets() comets = comets[comets['mag'] < 20.0].sort_values(by=['mag']) if search_form.q.data: search_expr = search_form.q.data.replace('"', '') comets = comets.query('designation.str.contains("{}")'.format(search_expr)) if len(comets) > 0: comets_for_render = comets.iloc[offset:offset + per_page] else: comets_for_render = comets pagination = Pagination(page=page, per_page=per_page, total=len(comets), search=False, record_name='comets', css_framework='semantic', not_passed_args='back') return render_template('main/solarsystem/comets.html', comets=comets_for_render, pagination=pagination, search_form=search_form)
def import_history_records(): search_form = SearchImportHistoryRecsForm() ret, page = process_paginated_session_search( 'import_history_search_page', [('import_history_search', search_form.q), ('items_per_page', search_form.items_per_page)]) per_page = get_items_per_page(search_form.items_per_page) if not ret: return redirect(url_for('main_import_history.import_history_records')) offset = (page - 1) * per_page import_type_code = request.args.get('type') import_type = None if import_type_code == 'obs': import_type = ImportType.OBSERVATION elif import_type_code == 'sess': import_type = ImportType.SESSION import_history_recs = ImportHistoryRec.query.filter_by( create_by=current_user.id) if import_type: import_history_recs = import_history_recs.filter_by( import_type=import_type) import_history_recs = import_history_recs.order_by( ImportHistoryRec.create_date.desc()) import_history_recs_for_render = import_history_recs.limit( per_page).offset(offset).all() pagination = Pagination(page=page, per_page=per_page, total=import_history_recs.count(), search=False, rec_name='import_history_recs', css_framework='semantic', not_passed_args='back') return render_template('main/import_history/import_history_records.html', import_history_recs=import_history_recs_for_render, pagination=pagination, search_form=search_form)
def locations(): search_form = SearchLocationForm() ret, page = process_paginated_session_search( 'location_search_page', [('location_search', search_form.q), ('items_per_page', search_form.items_per_page)]) per_page = get_items_per_page(search_form.items_per_page) if not ret: return redirect(url_for('main_location.locations')) offset = (page - 1) * per_page locations = Location.query.filter( or_( and_(Location.is_public == True, Location.is_for_observation == True), Location.user_id == current_user.id)) if search_form.q.data: locations = locations.filter( Location.name.like('%' + search_form.q.data + '%')) locations_for_render = locations.limit(per_page).offset(offset).all() pagination = Pagination(page=page, per_page=per_page, total=locations.count(), search=False, record_name='locations', css_framework='semantic', not_passed_args='back') return render_template('main/location/locations.html', locations=locations_for_render, pagination=pagination, search_form=search_form)
def standalone_observations(): """View standalone observations.""" search_form = SearchStandaloneObservationForm() sort_by = request.args.get('sortby') ret, page = process_paginated_session_search( 'stobservation_search_page', [('items_per_page', search_form.items_per_page)]) if not ret: return redirect( url_for('main_standalone_observation.standalone_observations', page=page, sortby=sort_by)) per_page = get_items_per_page(search_form.items_per_page) offset = (page - 1) * per_page observations = Observation.query.filter_by( user_id=current_user.id).order_by(Observation.date_from.desc()) search = False observations_for_render = observations.limit(per_page).offset(offset).all() pagination = Pagination(page=page, per_page=per_page, total=observations.count(), search=search, record_name='observations', css_framework='semantic') return render_template('main/observation/standalone_observations.html', observations=observations_for_render, pagination=pagination, search_form=search_form)
def double_stars(): """View double stars.""" search_form = SearchDoubleStarForm() sort_by = request.args.get('sortby') ret, page = process_paginated_session_search('dbl_star_search_page', [ ('dbl_star_search', search_form.q), ('constellation_id', search_form.constellation_id), ('dbl_mag_max', search_form.mag_max), ('dbl_delta_mag_min', search_form.delta_mag_min), ('dbl_separation_min', search_form.separation_min), ('dbl_separation_max', search_form.separation_max), ('dec_min', search_form.dec_min), ('items_per_page', search_form.items_per_page) ]) if not ret: return redirect(url_for('main_double_star.double_stars', page=page, sortby=sort_by)) per_page = get_items_per_page(search_form.items_per_page) offset = (page - 1) * per_page dbl_star_query = DoubleStar.query if search_form.q.data: dbl_star_query = dbl_star_query.filter(or_(DoubleStar.common_cat_id == search_form.q.data, DoubleStar.wds_number == search_form.q.data, DoubleStar.norm_other_designation.like('%;' + search_form.q.data + ';%') )) else: if search_form.constellation_id.data is not None: dbl_star_query = dbl_star_query.filter(DoubleStar.constellation_id == search_form.constellation_id.data) if search_form.mag_max.data: dbl_star_query = dbl_star_query.filter(DoubleStar.mag_first < search_form.mag_max.data, DoubleStar.mag_second < search_form.mag_max.data) if search_form.delta_mag_min.data: dbl_star_query = dbl_star_query.filter(DoubleStar.delta_mag > search_form.delta_mag_min.data) if search_form.separation_min.data: dbl_star_query = dbl_star_query.filter(DoubleStar.separation > search_form.separation_min.data) if search_form.separation_max.data: dbl_star_query = dbl_star_query.filter(DoubleStar.separation < search_form.separation_max.data) if search_form.dec_min.data: dbl_star_query = dbl_star_query.filter(DoubleStar.dec_first > (np.pi * search_form.dec_min.data / 180.0)) sort_def = { 'wds_number': DoubleStar.wds_number, 'common_cat_id': DoubleStar.common_cat_id, 'components': DoubleStar.components, 'other_designation': DoubleStar.other_designation, 'ra': DoubleStar.ra_first, 'dec': DoubleStar.dec_first, 'mag_first': DoubleStar.mag_first, 'mag_second': DoubleStar.mag_second, 'separation': DoubleStar.separation, 'spectral_type': DoubleStar.spectral_type, 'constellation': DoubleStar.constellation_id, } table_sort = create_table_sort(sort_by, sort_def.keys()) order_by_field = None if sort_by: desc = sort_by[0] == '-' sort_by_name = sort_by[1:] if desc else sort_by order_by_field = sort_def.get(sort_by_name) if order_by_field and desc: order_by_field = order_by_field.desc() if order_by_field is None: order_by_field = DoubleStar.id shown_double_stars = dbl_star_query.order_by(order_by_field).limit(per_page).offset(offset).all() pagination = Pagination(page=page, per_page=per_page, total=dbl_star_query.count(), search=False, record_name='double_stars', css_framework='semantic', not_passed_args='back') packed_constell_list = get_packed_constell_list() return render_template('main/catalogue/double_stars.html', double_stars=shown_double_stars, pagination=pagination, search_form=search_form, table_sort=table_sort, packed_constell_list=packed_constell_list)
def deepskyobjects(): """View deepsky objects.""" search_form = SearchDsoForm() sort_by = request.args.get('sortby') ret, page = process_paginated_session_search( 'dso_search_page', [('dso_search', search_form.q), ('dso_type', search_form.dso_type), ('dso_catal', search_form.catalogue), ('dso_maglim', search_form.maglim), ('items_per_page', search_form.items_per_page)]) if not ret: return redirect( url_for('main_deepskyobject.deepskyobjects', page=page, sortby=sort_by)) per_page = get_items_per_page(search_form.items_per_page) offset = (page - 1) * per_page dso_query = DeepskyObject.query if search_form.q.data: dso_query = dso_query.filter( DeepskyObject.name.like('%' + normalize_dso_name(search_form.q.data) + '%')) mag_scale = (8, 16) if search_form.dso_type.data and search_form.dso_type.data != 'All': dso_query = dso_query.filter( DeepskyObject.type == search_form.dso_type.data) if search_form.catalogue.data and search_form.catalogue.data != 'All': cat_id = Catalogue.get_catalogue_id_by_cat_code( search_form.catalogue.data) if cat_id: dso_query = dso_query.filter_by(catalogue_id=cat_id) if not search_form.q.data and search_form.maglim.data is not None and search_form.maglim.data < mag_scale[ 1]: dso_query = dso_query.filter( DeepskyObject.mag < search_form.maglim.data) sort_def = { 'name': DeepskyObject.name, 'type': DeepskyObject.type, 'ra': DeepskyObject.ra, 'dec': DeepskyObject.dec, 'constellation': DeepskyObject.constellation_id, 'mag': DeepskyObject.mag, } table_sort = create_table_sort(sort_by, sort_def.keys()) order_by_field = None if sort_by: desc = sort_by[0] == '-' sort_by_name = sort_by[1:] if desc else sort_by order_by_field = sort_def.get(sort_by_name) if order_by_field and desc: order_by_field = order_by_field.desc() if order_by_field is None: order_by_field = DeepskyObject.id shown_dsos = dso_query.order_by(order_by_field).limit(per_page).offset( offset).all() observed = set() if not current_user.is_anonymous: for dso in ObservedList.get_observed_dsos_by_user_id(current_user.id): observed.add(dso.id) pagination = Pagination(page=page, per_page=per_page, total=dso_query.count(), search=False, record_name='deepskyobjects', css_framework='semantic', not_passed_args='back') return render_template('main/catalogue/deepskyobjects.html', deepskyobjects=shown_dsos, mag_scale=mag_scale, pagination=pagination, search_form=search_form, table_sort=table_sort, observed=observed)
def session_plan_schedule(session_plan_id): """View a session plan schedule.""" session_plan = SessionPlan.query.filter_by(id=session_plan_id).first() is_mine_session_plan = _check_session_plan(session_plan, allow_public=True) if not is_mine_session_plan: return redirect( url_for('main_sessionplan.session_plan_info', session_plan_id=session_plan.id)) schedule_form = SessionPlanScheduleFilterForm() src_sort_by = request.args.get('src_sortby') str_per_page = request.args.get('per_page', None) if str_per_page is not None: session['items_per_page'] = int(str_per_page) ret, page = process_paginated_session_search( 'planner_page', [('planner_dso_type', schedule_form.dso_type), ('planner_dso_obj_source', schedule_form.obj_source), ('planner_dso_maglim', schedule_form.maglim), ('planner_constellation_id', schedule_form.constellation_id), ('planner_min_altitude', schedule_form.min_altitude), ('planner_time_from', schedule_form.time_from), ('planner_time_to', schedule_form.time_to), ('planner_not_observed', schedule_form.not_observed), ('planner_selected_dso_name', schedule_form.selected_dso_name), ('items_per_page', schedule_form.items_per_page)]) if not ret: return redirect( url_for('main_sessionplan.session_plan_schedule', session_plan_id=session_plan_id, page=page, sortby=src_sort_by)) add_form = AddToSessionPlanForm() add_form.session_plan_id.data = session_plan.id per_page = get_items_per_page(schedule_form.items_per_page) offset = (page - 1) * per_page mag_scale = (8, 16) sort_def = { 'name': DeepskyObject.name, 'type': DeepskyObject.type, 'constellation': DeepskyObject.constellation_id, 'mag': DeepskyObject.mag, } src_table_sort = create_table_sort(src_sort_by, sort_def.keys()) observer, tz_info = _get_observer_tzinfo(session_plan) observation_time = Time(session_plan.for_date) # try astronomical twilight default_t1, default_t2 = _get_twighligh_component(session_plan, 1) if not default_t2 and not default_t2: # try nautical twilight default_t1, default_t2 = _get_twighligh_component(session_plan, 1) time_from = _setup_search_from(schedule_form, observer, observation_time, tz_info, default_t1) time_to = _setup_search_to(schedule_form, observer, observation_time, time_from, tz_info, default_t2) selection_compound_list, page, all_count = create_selection_coumpound_list( session_plan, schedule_form, observer, observation_time, time_from, time_to, tz_info, page, offset, per_page, src_sort_by, mag_scale, sort_def) src_pagination = Pagination(page=page, per_page=per_page, total=all_count, search=False, record_name='deepskyobjects', css_framework='semantic', not_passed_args='back') session_plan_compound_list = create_session_plan_compound_list( session_plan, observer, observation_time, tz_info, sort_def) dst_page = request.args.get('dst_page', type=int, default=session.get('planner_dst_page', 1)) last_dst_page = (len(session_plan_compound_list) - 1) // per_page + 1 if dst_page >= last_dst_page: dst_page = last_dst_page if dst_page < 1: dst_page = 1 session['planner_dst_page'] = dst_page dst_offset = (dst_page - 1) * per_page session_plan_compound_list_for_render = session_plan_compound_list[ dst_offset:dst_offset + per_page] dst_pagination = Pagination(dst_page=dst_page, page_parameter='dst_page', total=len(session_plan_compound_list), search=False, per_page=per_page, record_name='deepskyobjects', css_framework='semantic', not_passed_args='back') selected_dso_name = None srow_index = request.args.get('srow_index', type=int, default=-1) drow_index = request.args.get('drow_index', type=int, default=-1) if drow_index == -1 and srow_index == -1: srow_index = 1 if srow_index > len(selection_compound_list): srow_index = len(selection_compound_list) if srow_index > 0: selected_dso_name = selection_compound_list[srow_index - 1][0].name if drow_index > len(session_plan_compound_list_for_render): drow_index = len(session_plan_compound_list_for_render) if drow_index > 0: selected_dso_name = session_plan_compound_list_for_render[ drow_index - 1][0].deepskyObject.name if not schedule_form.selected_dso_name.data: schedule_form.selected_dso_name.data = 'M1' if not selected_dso_name: selected_dso_name = schedule_form.selected_dso_name.data packed_constell_list = get_packed_constell_list() return render_template( 'main/planner/session_plan_info.html', type='schedule', session_plan=session_plan, selection_compound_list=selection_compound_list, session_plan_compound_list=session_plan_compound_list_for_render, dso_lists=DsoList.query.all(), catalogues_menu_items=get_catalogues_menu_items(), mag_scale=mag_scale, add_form=add_form, schedule_form=schedule_form, min_alt_item_list=min_alt_item_list, src_pagination=src_pagination, src_table_sort=src_table_sort, dst_pagination=dst_pagination, selected_dso_name=selected_dso_name, srow_index=srow_index, drow_index=drow_index, is_mine_session_plan=is_mine_session_plan, packed_constell_list=packed_constell_list)
def minor_planets(): """View minor_planets.""" search_form = SearchMinorPlanetForm() ret, page = process_paginated_session_search('minor_planet_search_page', [ ('minor_planet_search', search_form.q), ]) per_page = get_items_per_page(search_form.items_per_page) if not ret: return redirect(url_for('main_minor_planet.minor_planets')) offset = (page - 1) * per_page minor_planet_query = MinorPlanet.query if search_form.q.data: search_expr = search_form.q.data.replace('"', '') minor_planet_query = minor_planet_query.filter( MinorPlanet.designation.like('%' + search_expr + '%')) magnitudes = {} minor_planets_for_render = minor_planet_query.order_by( MinorPlanet.int_designation).limit(per_page).offset(offset).all() ts = load.timescale(builtin=True) eph = load('de421.bsp') sun, earth = eph['sun'], eph['earth'] t = ts.now() ra, dec, earth_sun_distance = earth.at(t).observe(sun).apparent().radec() mpc_minor_planets = _get_mpc_minor_planets() for minor_planet in minor_planets_for_render: mpc_minor_planet = mpc_minor_planets.iloc[minor_planet.int_designation] body = sun + mpc.mpcorb_orbit(mpc_minor_planet, ts, GM_SUN) ra, dec, sun_body_distance = sun.at(t).observe(body).radec() ra, dec, earth_body_distance = earth.at(t).observe( body).apparent().radec() apparent_magnitude = _get_apparent_magnitude_hg( minor_planet.magnitude_H, minor_planet.magnitude_G, earth_body_distance.au, sun_body_distance.au, earth_sun_distance.au) if apparent_magnitude: magnitudes[minor_planet.int_designation] = '{:.2f}'.format( apparent_magnitude) pagination = Pagination(page=page, per_page=per_page, total=minor_planet_query.count(), search=False, record_name='minor_planets', css_framework='semantic', not_passed_args='back') return render_template('main/solarsystem/minor_planets.html', minor_planets=minor_planets_for_render, pagination=pagination, search_form=search_form, magnitudes=magnitudes)