def brand_add(): """ Add a new brand """ from openstudio.os_forms import OsForms response.title = T('Shop') response.subtitle = T('Catalog') response.view = 'general/tabs_menu.html' return_url = shop_brand_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_create( db.shop_brands, return_url, ) form = result['form'] back = os_gui.get_button('back', return_url) menu = catalog_get_menu('brands') content = DIV( H4(T('Add brand')), form ) return dict(content=content, save=result['submit'], back=back, menu=menu)
def product_edit(): """ Edit a product """ from openstudio.os_forms import OsForms response.title = T('Shop') response.subtitle = T('Catalog') response.view = 'general/tabs_menu.html' return_url = shop_products_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update( db.shop_products, return_url, request.vars['spID'], onaccept=product_onaccept ) form = result['form'] back = os_gui.get_button('back', return_url) content = DIV( H4(T('Edit product')), form ) menu = catalog_get_menu('products') return dict(content=content, save=result['submit'], back=back, menu=menu)
def payment_attendance_list_rate_edit(): """ Edit a supplier request.vars['tpalID'] is expected to be teachers payment attendance list Id """ from openstudio.os_forms import OsForms response.title = T('Teachers Payment Attendance List') response.subtitle = T('Edit') response.view = 'general/only_content.html' tpalrID = request.vars['tpalrID'] tpalID = request.vars['tpalID'] return_url = URL('payment_attendance_list_rates', vars = dict(tpalID=tpalID)) os_forms = OsForms() result = os_forms.get_crud_form_update( db.teachers_payment_attendance_lists_rates, return_url, tpalrID ) form = result['form'] back = os_gui.get_button('back', return_url) content = DIV( H4(T('Edit List Rate')), form ) return dict(content=content, save=result['submit'], back=back)
def product_edit(): """ Edit a product """ from openstudio.os_forms import OsForms spID = request.vars['spID'] sp = db.shop_products(spID) response.title = T('Shop') response.subtitle = T( 'Edit product - {product_name}'.format(product_name=sp.Name)) response.view = 'general/tabs_menu.html' return_url = shop_products_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update(db.shop_products, URL(vars={'spID': spID}), spID, onaccept=product_onaccept) form = result['form'] back = os_gui.get_button('back', return_url) content = DIV(H4(T('Edit product')), form) menu = product_edit_get_menu(request.function, spID) return dict(content=content, save=result['submit'], back=back, menu=menu)
def product_variant_edit(): """ Edit a product variant """ from openstudio.os_forms import OsForms from openstudio.os_shop_product import ShopProduct spID = request.vars['spID'] spvID = request.vars['spvID'] product = ShopProduct(spID) response.title = T('Shop') response.subtitle = T( 'Edit product - {product_name}'.format(product_name=product.row.Name)) response.view = 'general/tabs_menu.html' return_url = product_variants_get_return_url(spID) if product.has_products_set(): db.shop_products_variants.Name.writable = False os_forms = OsForms() result = os_forms.get_crud_form_update( db.shop_products_variants, return_url, spvID, ) form = result['form'] back = os_gui.get_button('back', return_url) menu = product_edit_get_menu('product_variants', spID) return dict(content=form, save=result['submit'], back=back, menu=menu)
def product_variant_add(): """ Add a product variant """ from openstudio.os_shop_product import ShopProduct from openstudio.os_forms import OsForms spID = request.vars['spID'] product_variant_add_check_products_set(spID) product = ShopProduct(spID) response.title = T('Shop') response.subtitle = T( 'Edit product - {product_name}'.format(product_name=product.row.Name)) response.view = 'general/tabs_menu.html' return_url = product_variants_get_return_url(spID) db.shop_products_variants.shop_products_id.default = spID os_forms = OsForms() result = os_forms.get_crud_form_create( db.shop_products_variants, return_url, ) form = result['form'] content = DIV(H4(T("Add variant")), BR(), form) back = os_gui.get_button('back', return_url) menu = product_edit_get_menu('product_variants', spID) return dict(content=content, save=result['submit'], back=back, menu=menu)
def payment_fixed_rate_class(): """ Add default fixed rate for this teacher """ from openstudio.os_customer import Customer from openstudio.os_teacher import Teacher from openstudio.os_forms import OsForms teID = request.vars['teID'] clsID = request.vars['clsID'] response.view = 'general/only_content.html' customer = Customer(teID) response.title = customer.get_name() response.subtitle = T("Set class rate") record = db.classes(clsID) location = db.school_locations[record.school_locations_id].Name classtype = db.school_classtypes[record.school_classtypes_id].Name class_name = NRtoDay(record.Week_day) + ' ' + \ record.Starttime.strftime(TIME_FORMAT) + ' - ' + \ classtype + ', ' + location os_forms = OsForms() return_url = payment_fixed_rate_default_return_url(teID) db.teachers_payment_fixed_rate_class.auth_teacher_id.default = teID db.teachers_payment_fixed_rate_class.classes_id.default = clsID teacher = Teacher(teID) payment = db.teachers_payment_fixed_rate_class( classes_id = clsID, auth_teacher_id = teID ) if payment: title = H4(T('Edit class rate for'), ' ', class_name) result = os_forms.get_crud_form_update( db.teachers_payment_fixed_rate_class, return_url, payment.id ) else: title = H4(T('Add class rate for'), ' ', class_name) result = os_forms.get_crud_form_create( db.teachers_payment_fixed_rate_class, return_url, ) form = result['form'] content = DIV( title, form ) back = os_gui.get_button('back', return_url) return dict(content=content, back=back, save=result['submit'])
def product_add(): """ Add a new product """ from openstudio.os_forms import OsForms response.title = T('Shop') response.subtitle = T('Catalog') response.view = 'general/tabs_menu.html' return_url = shop_products_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_create( db.shop_products, '/shop_manage/product_edit?spID=[id]', onaccept=product_onaccept, message_record_created=T( "Added product, you can now add variants and categories")) form = result['form'] back = os_gui.get_button('back', return_url) content = DIV(H4(T('Add product')), form) menu = catalog_get_menu('products') return dict(content=content, save=result['submit'], back=back, menu=menu)
def payment_attendance_list_add(): """ page to add a new attendance list :return: """ from openstudio.os_forms import OsForms response.title = T("Payment Attendance List") response.subtitle = T('New Payment Attendance List') response.view = 'general/only_content.html' return_url = payment_attendance_list_add_edit_return_url() os_forms = OsForms() result = os_forms.get_crud_form_create( db.teachers_payment_attendance_lists, return_url, ) form = result['form'] back = os_gui.get_button('back', return_url) content = DIV( H4(T('Add Attendance List')), form ) return dict(content=content, save=result['submit'], back=back)
def payment_travel_edit(): """ Add travel allowance for a teacher """ from openstudio.os_customer import Customer from openstudio.os_forms import OsForms teID = request.vars['teID'] tpfrtID = request.vars['tpfrtID'] customer = Customer(teID) response.title = customer.get_name() response.subtitle = T("Edit travel allowance") response.view = 'general/only_content.html' return_url = payment_travel_return_url(teID) os_forms = OsForms() result = os_forms.get_crud_form_update( db.teachers_payment_travel, return_url, tpfrtID ) form = result['form'] back = os_gui.get_button('back', return_url) return dict(content=form, save=result['submit'], back=back)
def payment_attendance_list_edit(): """ Edit an attendance list request.vars['tpalID'] is expected to be db.teachers_payment_attendance_lists.id """ from openstudio.os_forms import OsForms response.title = T("Payment Attendance List") response.subtitle = T('Edit Name') response.view = 'general/only_content.html' tpalID = request.vars['tpalID'] return_url = payment_attendance_list_add_edit_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update( db.teachers_payment_attendance_lists, return_url, tpalID ) form = result['form'] back = os_gui.get_button('back', return_url) content = DIV( H4(T('Edit name of attendance list')), form ) return dict(content=content, save=result['submit'], back=back)
def notifications_email_add(): """ Subscribe email address to notification """ from openstudio.os_forms import OsForms response.title = T('Settings') response.subtitle = T('Mail') response.view = 'general/tabs_menu.html' snID = request.vars['snID'] return_url = URL('notifications') db.sys_notifications_email.sys_notifications_id.default = snID os_forms = OsForms() result = os_forms.get_crud_form_create( db.sys_notifications_email, return_url, ) form = result['form'] back = os_gui.get_button('back', return_url) menu = mail_get_menu(request.function) row = db.sys_notifications(snID) content = DIV(H4(T('Add Email to '), row.Notification), form) return dict(content=content, save=result['submit'], back=back, menu=menu)
def brand_edit(): """ Edit a brand request.vars['sbID'] is expected to be db.shop_brands.id """ from openstudio.os_forms import OsForms response.title = T('Shop') response.subtitle = T('Catalog') response.view = 'general/tabs_menu.html' sbID = request.vars['sbID'] return_url = shop_brand_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update( db.shop_brands, return_url, sbID ) form = result['form'] back = os_gui.get_button('back', return_url) menu = catalog_get_menu('brands') content = DIV( H4(T('Edit brand')), form ) return dict(content=content, save=result['submit'], back=back, menu=menu)
def reminder_add(): """ add a reminder :return: """ from openstudio.os_forms import OsForms response.title = T('Classes') response.subtitle = T('Sub teachers') response.view = 'general/tabs_menu.html' db.sys_email_reminders.Reminder.default = 'teachers_sub_request_open' return_url = reminders_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_create( db.sys_email_reminders, return_url, ) form = result['form'] back = os_gui.get_button('back', return_url) menu = get_menu('reminders') content = DIV( H4(T('Add reminder')), form ) return dict(content=content, save=result['submit'], back=back, menu=menu)
def payment_fixed_rate_default(): """ Add default fixed rate for this teacher """ from openstudio.os_customer import Customer from openstudio.os_teacher import Teacher from openstudio.os_forms import OsForms teID = request.vars['teID'] response.view = 'general/only_content.html' customer = Customer(teID) response.title = customer.get_name() response.subtitle = T("Teacher profile") os_forms = OsForms() return_url = payment_fixed_rate_default_return_url(teID) db.teachers_payment_fixed_rate_default.auth_teacher_id.default = teID teacher = Teacher(teID) default_payments = teacher.get_payment_fixed_rate_default() if default_payments: title = H4(T('Edit default rate')) result = os_forms.get_crud_form_update( db.teachers_payment_fixed_rate_default, return_url, default_payments.first().id ) else: title = H4(T('Add default rate')) result = os_forms.get_crud_form_create( db.teachers_payment_fixed_rate_default, return_url, ) form = result['form'] content = DIV( title, form ) back = os_gui.get_button('back', return_url) return dict(content=content, #menu=menu, back=back, save=result['submit'])
def edit_template(): """ Page to edit an email_template """ from openstudio.os_forms import OsForms response.title = T('Settings') response.subtitle = T('Mail') response.view = 'settings/email_templates.html' template = request.vars['template'] row = db.sys_email_templates(Name=template) template_content = row.TemplateContent form = SQLFORM.factory(Field("email_template", 'text', default=template_content, label=T("Template content")), submit_button=T("Save"), separator=' ', formstyle='bootstrap3_stacked') form_element = form.element('#no_table_email_template') form_element['_class'] += ' tmced' os_forms = OsForms() result = os_forms.set_form_id_and_get_submit_button(form, 'MainForm') form = result['form'] submit = result['submit'] if form.accepts(request.vars, session): # check smtp_signature email_template = request.vars['email_template'] query = (db.sys_email_templates.Name == template) db(query).update(TemplateContent=email_template) # User feedback session.flash = T('Saved') # reload so the user sees how the values are stored in the db now redirect(URL(vars={'template': template})) back = os_gui.get_button('back', URL('templates')) # submenu = email_templates_get_menu(template) content = DIV(H4(T("Edit template: {name}".format(name=row.Title))), form) return dict(content=content, back=back, menu=mail_get_menu('templates'), save=submit)
def template(): """ Page to edit an email_template """ from openstudio.os_forms import OsForms response.title = T('Email Settings') response.subtitle = T('Templates') response.view = 'settings/email_templates.html' template = request.vars['template'] template_content = get_sys_property(template) form = SQLFORM.factory(Field("email_template", 'text', default=template_content, label=T("Edit template")), submit_button=T("Save"), separator=' ', formstyle='bootstrap3_stacked') form_element = form.element('#no_table_email_template') form_element['_class'] += ' tmced' os_forms = OsForms() result = os_forms.set_form_id_and_get_submit_button(form, 'MainForm') form = result['form'] submit = result['submit'] if form.accepts(request.vars, session): # check smtp_signature email_template = request.vars['email_template'] set_sys_property(template, email_template) # User feedback session.flash = T('Saved') # reload so the user sees how the values are stored in the db now redirect(URL(vars={'template': template})) submenu = email_templates_get_menu(template) content = DIV(submenu, BR(), form) return dict(content=content, menu=mail_get_menu('templates'), save=submit)
def list_rates_get_form_add(tpalID): """ Returns add form for invoice items """ from openstudio.os_forms import OsForms db.teachers_payment_attendance_lists_rates.teachers_payment_attendance_lists_id.default = tpalID number_of_rates = payment_attendance_list_count_rates(tpalID) db.teachers_payment_attendance_lists_rates.AttendanceCount.default = number_of_rates + 1 return_url = URL(vars={'tpalID': tpalID}) os_forms = OsForms() result = os_forms.get_crud_form_create( db.teachers_payment_attendance_lists_rates, return_url, ) return result['form']
def add(): """ Add a new expense """ from openstudio.os_forms import OsForms response.title = T('Finance') response.subtitle = T('Add expense') response.view = 'general/only_content.html' return_url = add_edit_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_create( db.accounting_expenses, return_url, ) form = result['form'] back = os_gui.get_button('back', return_url) return dict(content=form, save=result['submit'], back=back)
def additional_item_edit(): """ Set opening balance """ from openstudio.os_forms import OsForms acaiID = request.vars['acaiID'] date = session.finance_cashbook_date item = db.accounting_cashbooks_additional_items(acaiID) booking_type = item.BookingType if booking_type == 'credit': subtitle_type = T("Income") elif booking_type == 'debit': subtitle_type = T("Expense") response.title = T('Cash book') response.subtitle = SPAN(T("Daily summary"), ': ', date.strftime(DATE_FORMAT), ' - ', T("Edit %s item") % subtitle_type) response.view = 'general/only_content.html' return_url = index_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update( db.accounting_cashbooks_additional_items, return_url, acaiID, message_record_updated=T("Saved"), ) form = result['form'] back = os_gui.get_button('back', return_url) content = form return dict(content=content, save=result['submit'], back=back)
def edit(): """ Edit expense request.vars['aeID'] is expected to be db.accounting_expenses.id """ from openstudio.os_forms import OsForms response.title = T('Finance') response.subtitle = T('Edit expense') response.view = 'general/only_content.html' aeID = request.vars['aeID'] return_url = add_edit_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update(db.accounting_expenses, return_url, aeID) form = result['form'] back = os_gui.get_button('back', return_url) return dict(content=form, save=result['submit'], back=back)
def cash_count_edit(): """ Set opening balance """ from openstudio.os_forms import OsForms ccID = request.vars['ccID'] date = session.finance_cashbook_date cc = db.accounting_cashbooks_cash_count(ccID) if cc.CountType == 'opening': count_type = T("opening") elif cc.CountType == 'closing': count_type = T("closing") response.title = T('Cash book') response.subtitle = SPAN(T("Daily summary"), ': ', date.strftime(DATE_FORMAT), ' - ', T("Edit %s count") % count_type) response.view = 'general/only_content.html' return_url = index_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update( db.accounting_cashbooks_cash_count, return_url, ccID, message_record_updated=T("Saved"), ) form = result['form'] back = os_gui.get_button('back', return_url) content = form return dict(content=content, save=result['submit'], back=back)
def mailing_list_add(): """ Add a new mailing_list """ from openstudio.os_forms import OsForms response.title = T('Settings') response.subtitle = T('Mail') response.view = 'general/tabs_menu.html' return_url = mailing_list_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_create( db.mailing_lists, return_url, ) form = result['form'] back = os_gui.get_button('back', return_url) menu = mail_get_menu('mailing_lists') content = DIV(H4(T('Add mailing list')), form) return dict(content=content, save=result['submit'], back=back, menu=menu)
def mailing_list_edit(): """ Edit a mailing_list request.vars['mlID'] is expected to be db.mailing_lists.id """ from openstudio.os_forms import OsForms response.title = T('Settings') response.subtitle = T('Mail') response.view = 'general/tabs_menu.html' mlID = request.vars['mlID'] return_url = mailing_list_get_return_url() os_forms = OsForms() result = os_forms.get_crud_form_update(db.mailing_lists, return_url, mlID) form = result['form'] back = os_gui.get_button('back', return_url) menu = mail_get_menu('mailing_lists') content = DIV(H4(T('Edit mailing list')), form) return dict(content=content, save=result['submit'], back=back, menu=menu)
def product_variant_add(): """ Add a product variant """ from openstudio.os_forms import OsForms spID = request.vars['spID'] product_variant_add_check_products_set(spID) response.title = T('Shop') response.subtitle = T('Catalog') response.view = 'general/tabs_menu.html' return_url = product_variants_get_return_url(spID) db.shop_products_variants.shop_products_id.default = spID os_forms = OsForms() result = os_forms.get_crud_form_create( db.shop_products_variants, return_url, ) form = result['form'] back = os_gui.get_button('back', return_url) content = DIV( H4(T('Add product variant')), form ) menu = catalog_get_menu('products') return dict(content=content, save=result['submit'], back=back, menu=menu)