o 3wh-<@s(ddlmZmZmZddlmZmZddlmZddl m Z ddl m Z ddl mZddlmZddlmZdd lmZdd lmZd d lmZmZmZmZd d lmZmZmZddl m!Z!m"Z"m#Z#ddl$Z$ddl%Z%ddl&Z&ddl'm(Z(ddl)m*Z*e ddddZ+e ddddZ,e ddddZ-e ddddZ.e ddddZ/e ddddZ0e ddd d!Z1e ddd"d#Z2e ddd$d%Z3e ddd&d'Z4e ddd(d)Z5e ddd*d+Z6dd,l7m7Z7e ddd-d.Z8e ddd/d0Z9ee ddd1d2Z:e ddd3d4Z;dS)5)renderredirectget_object_or_404) JsonResponse HttpResponse) Paginator)messages)login_required) require_POST)reverse)canvas)code39)letter)ProductCategoryBatch ProductImage) ProductForm CategoryForm BatchForm)SumQFN) transaction)IntegrityErrorz /auth/login/) login_urlcCsLtjjdddd}tjddddd}t}t|d|||dS) NT)parent__isnull subcategoriesproductsparentnamezinventory/category_list.html) categoriesall_categoriesform)robjectsfilterprefetch_relatedallorder_byrr)requestr"r#r$r++/var/www/html/hyperkenya/inventory/views.py category_listsr-cCsD|jdkrt|j}|r|tdSnt}t|dd|iS)NPOSTr-zinventory/add_category.htmlr$)methodrr.is_validsaverr)r*r$r+r+r, add_category%s  r2cCsXtt|d}|jdkrt|j|d}|r|tdSnt|d}t|dd|iS)Npkr.instancer-zinventory/edit_category.htmlr$) rrr/rr.r0r1rr)r*r4categoryr$r+r+r, edit_category1s   r8cCsDtt|d}|jdkr|t|d|jdtdStdS)Nr3r.z Category "z " has been deleted successfully.r-)rrr/deletersuccessr!r)r* category_idr7r+r+r,delete_category>s  r<cCshtj}tjd}|jd}|r|j|d}|jd}|dkr,|jdd}n|dkr7|jd d}n |d krC|jtd d }|jd }|r]|t |dt |dBt |dB}|jdd}|dkrn|d}n7|dkrx|d}n-|dkr|d}n#|dkr|d}n|dkr|d}n|dkr|d}n|d}||||||d}t |d|S) Nr!r7)r;statusactiveT is_activeinactiveF low_stocklow_stock_threshold)stock_quantity__ltesearchname__icontainsbarcode__icontainsdescription__icontainssort price_asc selling_price price_descz-selling_price stock_ascstock_quantity stock_descz-stock_quantitydate_asc created_at date_descz -created_at)rr"current_categorycurrent_status current_sort search_queryzinventory/product_list.html) rr%r(rr)GETgetr&rrr)r*r"rr;r=rYsort_bycontextr+r+r, product_listHsV             r^c Cs|jdd}t|dkrtgddStjjt|dt|dBt|dBd d d d }g}|D]}| |j |j |j p>dt |j|jtd |j gddq2t|ddS)z AJAX endpoint for product searchqFsaferFrHrJTr?N product_detail)args)idr!barcodepricestockurl)rZr[striplenrrr%r&rappendrgr!rhstrrNrQr )r*queryrresultsproductr+r+r,search_products_ajaxs0   rscCs(tt|d}|j}t|d||dS)Nr3zinventory/product_detail.html)rrbatches)rrrtr(r)r*r4rrrtr+r+r,res  recCs|jdkrIt|j|j}|rB|jdd}d|jvr!|jd|_||jd}|D] }tj j ||dq-t |dt dSt |d nt}tj }t|d ||d S) Nr.FcommitimageimagesrrrwzProduct added successfully!r^z&There was an error adding the product.zinventory/add_product.html)r$r")r/rr.FILESr0r1rwgetlistrr%createrr:rerrorrr(r)r*r$rrrxrwr"r+r+r, add_products&       r~cCstt|d}|jdkrQt|j|j|d}|rJ|jdd}d|jvr)|jd|_||j d}|D] }t j j ||dq5t |d td St |d nt|d}tj }t|d |||d S)Nr3r.r5FrurwrxryzProduct updated successfully!r^z(There was an error updating the product.zinventory/edit_product.html)r$rrr")rrr/rr.rzr0r1rwr{rr%r|rr:rr}rr(r)r*r4rrr$rxrwr"r+r+r, edit_products*         rcCstt|d}|tdS)Nr3r^)rrr9r)r*r4rrr+r+r,delete_products rcCstt|d}|jdkr@t|j}|r?|jdd}||_||_ ||j |j 7_ |t |dtd|jdSnt}t|d||d S) N)rgr.FruzStock received successfully!rer3zinventory/receive_stock.html)rrr$)rrr/rr.r0r1rrgenerate_batch_code batch_coderQquantityrr:rrgr)r* product_idrrr$batchr+r+r, receive_stocks$       rc Csxtj}tdd}d|d<t|}|gd|D]}||j|j|j |j |j |j |j |jr5|jjndgq|S)Nztext/csv content_typez#attachment; filename="products.csv"Content-Disposition)BarcodeNamez Buying Pricez Selling PricezStock Quantityz Expiry DatezPackaging Typer Uncategorized)rr%r(rcsvwriterwriterowrhr! buying_pricerNrQ expiry_datepackaging_typer7)r*rresponserrrr+r+r,export_productss"    r)datetimec Csz|jdkr9|jd}|jdst|dtdSz| d}t |}t |t ttj|ddd d D]\}}zt|d krTt|d |d Wq=|dr^|dnd}|d}t|d }t|d} t|d kr|d rt|d nd} t|dkr|drt|ddnd} t|dkr|dnd} t|dkr|dnd} tjj| d\}}tjj||| || | | |ddWq=ty}zt|d|dt|WYd}~q=d}~wwWdn 1swYt |dWtdSty8}zt|dt|WYd}~tdSd}~wwtdS)Nr. imported_filez.csvzFile is not CSV typer^zUTF-8,) delimiterra)startzRow z: Missing required fields.rrz%Y-%m-%dr)r!)r!rrNrQrrr7)rhdefaultsz Error on row z: zProducts imported successfully!zError processing file: )!r/rzr[r!endswithrr}rreaddecodeioStringIOnextratomic enumeraterreaderrmrlfloatintrstrptimedaterr% get_or_createrupdate_or_create Exceptionror:)r*csv_filedata_set io_string row_numbercolumnrhr!rNrQrrr category_namer7_er+r+r,import_products)sd        ,4   ( rc Cs|jdd}|r;ztjt|dt|dBddddd }t|}Wnt y:}zg}WYd}~nd}~wwg}t |d d S) Nr_r`rFrHrgr!rhrNrQFrb) rZr[rlrr%r&rvalueslistrr)r*rprrqrr+r+r,product_live_searchfs  rc Csz.|jdd}|r|d}tjj|dt|dn t |dWt dSWt dSt yN}zt |dt |WYd}~t dSd}~ww) Nselected_productsr`rid__inz1Selected products have been deleted successfully.z'No products were selected for deletion.zAn error occurred: r^) r.r[splitrr%r&r9rr:r}rror)r* product_idsidsrr+r+r,delete_selected_productsxs  rc Cs|jdg}t|jdd}tjj|d}tdd}d|d<tj |t d }t \}}|d }|D]:} t j | j d d d d} t|D])} |dkrO||d }| |d ||d |d | jd| j |d 8}qAq1||S)Nrrrrzapplication/pdfrz#attachment; filename="barcodes.pdf"r)pagesizedg?F) barHeightbarWidthchecksum2z - )rZr{rr[rr%r&rr Canvasrr Extended39rhrangeshowPagedrawOn drawStringr!r1) r*rrrrcwidthheight y_positionrrrhrr+r+r,print_barcodess(     r)<django.shortcutsrrr django.httprrdjango.core.paginatorrdjango.contribrdjango.contrib.auth.decoratorsr django.views.decorators.httpr django.urlsr reportlab.pdfgenr reportlab.graphics.barcoder reportlab.lib.pagesizesrmodelsrrrrformsrrrdjango.db.modelsrrrrrjson django.dbrdjango.db.utilsrr-r2r8r<r^rsrer~rrrrrrrrrr+r+r+r,sh               :    !     <