o hY7@sdddlmZddlmZmZddlmZmZmZm Z ddl m Z ddl m Z ddlmZddlmZddlmZdd lmZdd lmZmZdd lmZdd lmZdd lmZddlm Z ddl!Z!eddZ"eddddZ#eddddZ$eddddZ%eddddZ&eddddZ'eddddZ(eddd d!Z)eddd"d#Z*dS)$render) JsonResponse HttpResponse)QSumCountF) TruncMonth)reverse)Product)Customer)Supplier)Sale)Employee Attendance)Order)login_required)timezone) timedeltaNc Cs|jdd}t|dkrtdgiSg}z9tjjt|dt|dBt|dBdd dd }|D]}| d |j d |j d |j t d|jgddq3WnYzGtjt|dt|dBt|dBt|dBt|dBdd }|D]!}| d|jd|jd|jd|jt d|jgddqyWnYzCtjt|dt|dBt|dBt|dBt|dBdd }|D]}| d|j d|jd|jpdt d |jgddqWnYzKtjt|d!t|d"Bt|d#Bdd$} | D]/} | jr| jjd| jjnd%} | d&d'| jd(| d)| jt d*| jgddqWnYzCtjt|dt|dBt|d+Bt|d,Bdd$} | D]"} | d-| jd| jd| jd.| jt d/| jgddqXWnYz7tjt|d0t|d1Bdd$}|D] }| d2d3|jd4|jj d5|j t d6|jgddqWnYtd|iS)7Nqresults)name__icontains)barcode__icontains)description__icontainsT is_activer z Price: KSh z | Stock: product_detail)args)categorytitlesubtitleurl)first_name__icontains)last_name__icontains)phone__icontains)email__icontains)customer_id__icontainsr  zID: z | Phone: customer_detail)contact_person__icontains)supplier_id__icontainsrz | Contact: zN/A view_supplier) id__icontains)customer__first_name__icontains)customer__last_name__icontainszWalk-in CustomerrzSale #z Customer: z | Amount: KSh sale_detail)employee_id__icontains)job_title__icontainsrz | Position: employee_detail)order_number__icontains)supplier__name__icontainsrzOrder z Supplier: z | Total: KSh order_detail)!GETgetstriplenrr objectsfilterrappendname selling_pricestock_quantityr idr first_name last_name customer_idphoner supplier_idcontact_personrcustomer total_amountr employee_id job_titler order_numbersupplier total_cost)requestqueryrproductsproduct customersrL suppliersrQsalessale customer_name employeesemployeeordersorderr`$/var/www/html/pos/dashboard/views.py global_searchs     "      rbz /auth/login/) login_urlcCst}|tdd}|t|d}|jdd}|tdd}|tdd}tjj|dj t dt dt d d d t dt d d d t dt d d d t dt dd d t dd}tjj|dj t dt dt d d d t dt d d d t dt d d d t dt dd d d}tjj|dj t dt dt d d d t dt d d d t dt d d d t dt dd d d} tjj t dddpd} | d} tj djt ddd} z tjjdd} Wnd} Yz0tjjtdd}tjj||d}tjjdddj t tdtdd d!pd}Wn d}d}d}Yztjjt d"d#jdd$d%dd&}tjj|d'}Wng}d}Yztjjd(d)}tjj|d*}Wnd}g}Y| | | |||td+|d,psd|d,pyd| d,pd| ||||d-}t|d.|S)/N)days)day)sale_date__daterMcash)payment_method)r@mpesacreditchequerE) total_sales cash_sales mpesa_sales credit_sales cheque_salestransaction_count)sale_date__date__gte)rprqrrrsrt)totalrwrrlz-totalF) is_receivedlow_stock_threshold)stock_quantity__lt)expiry_date__lteexpiry_date__gte)stock_quantity__gtbuying_price__gtrD buying_price) total_valuersale__total_amount) total_spent)total_spent__gtz -total_spentr)date_added__gteTr)datezreports:inventory_reportrp)rp profit_losspending_orderslow_stock_countnear_expiry_countinventory_valueinventory_report_url daily_sales weekly_sales monthly_salessales_by_payment_method top_customerscustomer_growthemployee_countemployee_attendancezdashboard/dashboard.html)rnowrrweekdayreplacerr?r@ aggregaterrrvaluesannotateorder_byrcountr r r rrr r)rStodayexpiry_threshold start_of_weekstart_of_monthsix_months_ago two_weeks_agorrrrprrrrrrrrrrcontextr`r`radashboard_views          rc Csfddddddddd d d d dd ddddddddddddddddddddddgd}t|d|S) zMain onboarding guide pagez Getting Started with Sales SharkCreate Your First CustomerzLLearn how to add customers to track sales and manage customer relationships.onboarding_customersz fas fa-usersEasyz 3 minutes)r# descriptionr%icon difficultytimeAdd Your First ProductzLSet up your inventory by adding products with pricing and stock information.onboarding_productsz fas fa-boxz 5 minutesImport Products from ExcelzABulk import your entire product catalog using our Excel template.onboarding_importzfas fa-file-excelMediumz 10 minutesAdd Your First SupplierzEManage your supply chain by adding supplier information and contacts.onboarding_suppliersz fas fa-truckz 4 minutesRegister Your First Employeez=Set up employee records for HR management and access control.onboarding_employeeszfas fa-user-tiez 6 minutes) page_titleguideszdashboard/onboarding_home.htmlrrSrr`r`raonboarding_homesN     -rcC$dddtdtdd}t|d|S)zCustomer creation guiderrf customer_add customer_list)r current_step total_stepsadd_customer_urlcustomer_list_urlz#dashboard/onboarding_customers.htmlr rrr`r`rar- rcCr)zProduct creation guiderrr add_product product_list)rrradd_product_urlproduct_list_urlz"dashboard/onboarding_products.htmlrrr`r`rar:rrcCr)zProduct import guiderr3rimport_productsdownload_sample_csv)rrr import_urlsample_csv_urlz dashboard/onboarding_import.htmlrrr`r`rarGrrcC$dddtdtdd}t|d|S)zSupplier creation guiderr add_supplier supplier_list)rrradd_supplier_urlsupplier_list_urlz#dashboard/onboarding_suppliers.htmlrrr`r`rarTrrcCr)zEmployee creation guiderr employee_add employee_list)rrradd_employee_urlemployee_list_urlz#dashboard/onboarding_employees.htmlrrr`r`rararrcCsttdd}d|d<t|}|gd|gd|gd|gd|gd |gd |S) z8Generate and download sample CSV file for product importztext/csv) content_typez*attachment; filename="sample_products.csv"zContent-Disposition)barcoderBrCrDr expiry_datepackaging_typer") 001234567890zPremium Coffee Beans 500gz1200.0025z800.00z 2025-12-31Packets Beverages) 001234567891zOrganic Rice 2kgz450.0050z320.00z 2025-06-30BagsGrains) 001234567892zNatural Honey 250mlz650.0015z400.00z 2026-03-15Bottles Sweeteners) 001234567893z Fresh Milk 1Lz120.0040z85.00z 2025-01-15CartonsDairy) 001234567894zWhole Wheat Breadz80.0030z60.00z 2025-01-05LoavesBakery)rcsvwriterwriterow)rSresponserr`r`rarns  r)+django.shortcutsr django.httprrdjango.db.modelsrrrr django.db.models.functionsr django.urlsr inventory.modelsr customers.modelsr suppliers.modelsr sales.modelsr hr.modelsrr orders.modelsrdjango.contrib.auth.decoratorsr django.utilsrdatetimerrrbrrrrrrrrr`r`r`rasB            } i 2