:j 8dZddlmZmZmZmZmZmZmZm Z ddl m Z m Z ddl mZmZddlmZddlmZmZddlmZddlmZdd lmZdd lZdd lZej:j=ej:j?ej:j?ej:jAe!dd l"m#Z#ed e$Z%e%jMd dZ'dZ(e%jMdddgdZ)e%jMddZ*e%jMddZ+e%jMddZ,e%jMddZ-e%jMddZ.e%jMdd Z/e%jMd!d"Z0e%jMd#d$Z1e%jMd%d&Z2e%jMd'd(Z3e%jMd)d*Z4e%jMd+dgd,Z5e%jMd-dgd.Z6e%jMd/dgd0Z7e%jMd1dgd2Z8e%jMd3dgd4Z9e%jMd5dgd6Z:e%jMd7dgd8Z;e%jMd9d:gd;Zd:gd?Z>e%jMd@d:gdAZ?e%jMdBdCgdDZ@e%jMdEdCgdFZAe%jMdGdCgdHZBe%jMdIdCgdJZCe%jMdKdge dLZDy )Mze Admin Routes Blueprint Contains admin panel functionality, user management, and business management ) Blueprintrequestrender_templateredirecturl_forflashjsonifysession)login_required current_user)generate_password_hashcheck_password_hash)secure_filename) create_enginetext) sessionmaker)UUID) quote_plusN) ADMIN_CONFIGadminz/adminc tjds tddtt dSd} t d}t |}tdd|}|}i} |jtd j}|r|d nd }||d < |j|} |jtd j}|r|d nd }||d< |j|} |jtdj}|r|d nd } | |d< |j|} |jtdj}|r|d nd } | |d< |j|} |jtdj}|r|d nd } | |d< |j|} |jtdj}|r|d nd } | |d< |j|} |jtdj} | r<| d r7|jtdj}|r|d nd }||d<nd |d< |j|} |jtd j} | r:| d r5|jtd!j}|r|d nd |d"<nd#|d"< |j|} |jtd%j} | r| d r|jtd&j}|r:|d r5|jtd'j}|r|d nd |d(<no|jtd)j}|r:|d r5|jtd*j}|r|d nd |d(<n d+|d(<nd+|d(< |j|} |jtdj} | r:| d r5|jtd-j}|r|d nd |d.<nd |d.< |j|} |jtd0j} | r:| d r5|jtd1j}|r|d nd |d2<nd3|d2< |j|} |jtd5j}|r|d nd |d6< |j|}g} |jtd8j}|D]D}|jd9d:|j d;|j"t%|j&d<F |j|} |jtdj} | r| d r|jtd>j}|D]y}|j(xsd?}|j*d@k(rdAndB}|j|dC|j*dDdE|j d;|j"dF|t%|j&d<{ |j|} |jtdHj}|r.|d r)|jtdIj}nZ|jtdJj}|r.|d r)|jtdKj}ng}|D]5}|jdLdM|j,t%|j&d<7 |jt/|dOdPQdd3}|jdd |jdd |jd d |jd.d |jd6d |jd"d |jd(d |jd2d dR}t1dS||TS#t$r}td |d |d <Yd}~\d}~wwxYw#YXxYw# |jn#YnxYw|}wxYw#t$r}td|d |d<Yd}~dd}~wwxYw#Y`xYw# |jn#YnxYw|}wxYw#t$r}td|d |d<Yd}~ld}~wwxYw#YhxYw# |jn#YnxYw|}wxYw#t$r}td|d |d<Yd}~td}~wwxYw#YpxYw# |jn#YnxYw|}wxYw#t$r}td|d |d<Yd}~|d}~wwxYw#YxxYw# |jn#YnxYw|}wxYw#t$r}td|d |d<Yd}~d}~wwxYw#YxYw# |jn#YnxYw|}wxYw#t$r}td|d |d<Yd}~Wd}~wwxYw#YSxYw# |jn#YnxYw|}wxYw#t$r}td$|d#|d"<Yd}~,d}~wwxYw#Y(xYw# |jn#YnxYw|}wxYw#t$r}td,|d+|d(<Yd}~hd}~wwxYw#YdxYw# |jn#YnxYw|}wxYw#t$r}td/|d |d.<Yd}~=d}~wwxYw#Y9xYw# |jn#YnxYw|}wxYw#t$r}td4|d3|d2<Yd}~d}~wwxYw#YxYw# |jn#YnxYw|}wxYw#t$r}td7|d |d6<Yd}~d}~wwxYw#YxYw# |jn#YnxYw|}wxYw#t$r}td=|Yd}~d}~wwxYw#YxYw# |jn#YnxYw|}wxYw#t$r}tdG|Yd}~Ed}~wwxYw#YAxYw# |jn#YnxYw|}wxYw#t$r}tdN|Yd}~d}~wwxYw#YxYw# |jw#YwxYwxYw#t$rb}tdUt3|tdUt3|d |r|jn#YnxYwt1dSigTcYd}~Sd}~wwxYw)Vz(Admin dashboard with overview statisticsis_admin>You must be logged in as an administrator to access this page.erroradmin.admin_loginN DATABASE_URLF autocommit autoflushbindz!SELECT COUNT(*) FROM beach_placesrbeacheszError counting beaches: z SELECT COUNT(*) FROM restaurants restaurantszError counting restaurants: zSELECT COUNT(*) FROM marketsmarketszError counting markets: zSELECT COUNT(*) FROM adventures adventureszError counting adventures: z1SELECT COUNT(*) FROM users WHERE is_active = trueuserszError counting users: zSELECT COUNT(*) FROM companies companieszError counting companies: z SELECT EXISTS ( SELECT FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'bookings' ) z SELECT COUNT(*) FROM bookings WHERE created_at >= CURRENT_DATE - INTERVAL '30 days' recent_bookingsz Error counting recent bookings: z SELECT EXISTS ( SELECT FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'messages' ) z5SELECT COUNT(*) FROM messages WHERE status = 'unread'messageszError counting messages: z SELECT EXISTS ( SELECT FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'reviews' ) z SELECT EXISTS ( SELECT column_name FROM information_schema.columns WHERE table_name = 'reviews' AND column_name = 'status' ) z5SELECT COUNT(*) FROM reviews WHERE status = 'pending'reviewsa SELECT EXISTS ( SELECT column_name FROM information_schema.columns WHERE table_name = 'reviews' AND column_name = 'review_status' ) z