o #i @sddlZddlmZddlmZddlmZmZddlmZddl m Z ddl m Z ddl m Z mZdd lmZdd lmZdd lmZmZmZmZmZmZdd lmZmZdd lmZddlm Z m!Z!ddl"Z"ddl#Z#ddlm$Z$m%Z%ddl&m'Z'ddl(m(Z(Gddde)Z*Gddde)Z+Gddde)Z,Gddde)Z-Gddde)Z.Gddde)Z/Gddde)Z0dyd!d"Z1d#e2d efd$d%Z3d&ed e4fd'd(Z5d&ed e4fd)d*Z6d&ed e4fd+d,Z7dd-l8m9Z9d&ed e:fd.d/Z;d&ed e4fd0d1Zd#e2d e4fd6d7Z?dyd8d9Z@d e fd:d;ZAdd?ZBd@edAeCdBeCd dfdCdDZDd@edEe4d dfdFdGZEd@edHe4d dfdIdJZFdzd@edKe4dLeCd dfdMdNZGd@edOeCdPeHd dfdQdRZId{d@edTe:dPeHd dfdUdVZJd@edWe4d dfdXdYZKdZeHd e2fd[d\ZLdzd@ed]e4dLeCd dfd^d_ZMd@ed`e4d dfdadbZNdceddeCdeeCd dfdfdgZOdcedAeCd dfdhdiZPdcedjeCdkeCd dfdldmZQd=e2d#e2dne2d dfdodpZRd#e2d=e2d dfdqdrZSd#e2dse2d dfdtduZTd#e2dve2d dfdwdxZUdS)|N) load_workbook) PatternFill)BorderSide) Worksheet)Workbook)copy)coordinate_from_stringcolumn_index_from_string) CellRange) MergedCell)CustomOrderTrackingDiscountOrdersPayment OrderProducts DeliverySlot)SKUProducts)Users)ShopProductionUnit)Font Alignment)Path) num2wordsc&eZdZdeddffdd ZZS)OutputPDFNotFoundErrorvaluereturnNc*||_d|_t|jd|jdS)Nz8Output pdf file not found, please check the output path.: rmessagesuper__init__selfr __class__@/var/www/html/Testing_prj/Navya-Bakers/bill_writer/BillWriter.pyr%zOutputPDFNotFoundError.__init____name__ __module__ __qualname__strr% __classcell__r*r*r(r+rrcr)ErrorConvertingPDFrrNcr )Nz#Output pdf file generation failed!.r!r"r&r(r*r+r%r,zErrorConvertingPDF.__init__r-r*r*r(r+r4r3r4cr)OuptputExcelNotFoundErrorrrNcr )Nz:Output excel file not found, please check the output path.r!r"r&r(r*r+r%#r,z"OuptputExcelNotFoundError.__init__r-r*r*r(r+r5"r3r5cr)TemplateNotFoundErrorrrNcr )Nz&Invalid template path, file not found.r!r"r&r(r*r+r%)r,zTemplateNotFoundError.__init__r-r*r*r(r+r6(r3r6cseZdZdfdd ZZS)OutputFolderCreationErrorrNcs*d|_d|_t|jd|jdS)NzPlease check permission issueszError creating Output Foldersr!r")r'r(r*r+r%/r,z"OutputFolderCreationError.__init__rN)r.r/r0r%r2r*r*r(r+r7.sr7cr)TemplateFileAlreadyOpenedrrNcr )NzBTemplate file already opened, please close the file and try again.r!r"r&r(r*r+r%5r,z"TemplateFileAlreadyOpened.__init__r-r*r*r(r+r94r3r9cr)DataNotFoundErrorrrNcr )NzData Not Foundr!r"r&r(r*r+r%;r,zDataNotFoundError.__init__r-r*r*r(r+r::r3r:rcCstj|s t|dSN)ospathexistsr6) template_pathr*r*r+_check_template_existAs r@order_idcCs$tjj|d}|std||S)Norder_IDNo data found for order ID: )robjectsgetr:)rAorderr*r*r+_fetch_order_dataFsrHrGcCsJtjj|d}|std|j|jj|jr|jdndd}|S)NrGz$No payment data found for order ID: %Y-%m-%dN/A)Invoice Number Invoice Date) rrEfilterfirstr:rCrG payment_datestrftime)rGpaymentinvoice_detailsr*r*r+_fetch_invoice_detailsMsrTc Cs zi|jr |jdnd}|jr|jdnd}|dkr"|d|n|}|jr.d|jdnd}|jr7|jjnd}|jrBt|jjnd}|j d krSt j j |d  }nd }|j|||||d }td ||WSty} ztd| td|jd} ~ ww)NrJrKz%H:%M ₹.2f₹0 Custom OrdersrI)Order NoSlotPayable Amount Payment ModeSource No of itemszAdditional details: z#Error fetching additional details: z*No additional details found for order ID: )delivery_slot_daterQdelivery_slot_time grand_total payment_mode mode_name store_uuidr1 unit_name order_typerrErNcountrClogginginfo Exceptionerrorr:) rGrbrcslotpayable_amountresource no_of_itemsadditional_detailser*r*r+_fetch_additional_detailsXs0  rucCsz:|jr d|jdnd}|jrd|jdnd}|jr#d|jdnd}|jr/d|jdnd}||||d}|WStd|j)NrVrWrX)Handling ChargesDelivery Chargesrz Total Amountz%No other charges found for order ID: )coupon_savingsdelivery_chargesdiscountrdr:rC)rGhandling_chargesryrz total_amount other_chargesr*r*r+_fetch_other_chargesxsr~)Qc Cs\z|jdkr'tjj|d}g}|D]}|j}|j}t|jjp"d}t|jjp*d}t|jj p2d}d} t jt d|j gdt d|j gdBt d |gd Bt d |gd B} | D]D} | jdkrm|j | jvrm| } n2| jdkr~|j | jvr~| } n!| jd kr|| jvr| } n| jd kr|| jvr| } nqZt|j} t|j} | rt| j}t| |d d}nd}t| | d}t|| d}|||d }t|||d}t|||d}|jr|jr|jd|j|j}n|j}||jt| rt| n| | d|d|d||||d|dd }||q|WSt jj|d}t!jj"|j#d}|j$r?t|j$nd}g}|D]M}|j%rN|j%nd}|jd|&}t|j'p`d}d}t|||d}|j(rt|j(ndd||d|d|dddd|d|dd }||qE|WSt)y}z t*d|j#d|d}~ww)uP Returns item details with the updated calculation logic: - Gross Value = Unit Price (MRP) × Quantity - Discount = discount_per_unit × Quantity (cumulative for all units) - Total Tax = (Gross Value − Discount) × (CGST + SGST + CESS) / 100 - Total Value = Gross Value − Discount + Total Tax rZrIrNCategory) DiscountOnApplicableCategory__in SubCategory)rApplicableSubCategory__inProduct)rApplicableProduct__inSku)rApplicableSku__ind-rW) Item DescriptionHSN CodeQuantity Unit Price Gross ValuerCGST Rate(%) AmountSGST Rate Amount CESS Amount Total Tax Total Value)rArBrYrUzCustom Order ItemrKz$No item details found for order ID:  :: )+rirrErNskuproductfloatc_gsts_gstcessrr item_categoryitem_sub_categoryrApplicableCategoryallApplicableSubCategoryApplicableProduct ApplicableSkusku_mrpquantityDiscountPercentageround sku_quantitysku_unitsku_namesku_coder1 is_integerintappendr rrFrCrz quantity_unitstriprd item_namermr:)rGitems item_detailsitemrrrrrapplicable_discount discountsrzmrprdiscount_percentdiscount_per_unit gross_valuetotal_discounttax_rate total_tax total_value item_desc item_detail custom_items order_obj discount_valqty_unit qty_displayrtr*r*r+ _item_detailss         rcCs.z|j|j}Wnd}Y|j|d}|S)Nr)Totalz Sub Total) sub_totaltaxes_and_chargesrd)rGtotaltotalsr*r*r+_total s  rc CszU|jdkrr|j}|rLg}|jr||j|jr ||j|jr)||j|jr2||j|jr;||j|jrF|t |jd |}nd}|rS|j nd||rZ|j nd|r`|j nd|rkt|drk|jndd}|WS|jdkr|j}|rg}|jr||j|jr||j|jr||j|jr||j|jr||j|jr|t |jd |}nd}|r|jnd||r|j nd|r|j nd|rt|dr|jndd}|WS|j}|r,g}|jr||j|jr||j|jr||j|jr||j|jr||j|jr&|t |jd |}nd}|r4|j nd||r<|j nd|rC|j nd|rPt|drP|jndd}|WStyn}z td|jd|d}~ww) Nz Local Orders rKgstin) Shop Name Shop Address Shop Phone Shop Email Shop GSTINzLong Distance Ordersz$No shop details found for order ID: r)rirg unit_locationrstreetcitydistrictstate_or_provincepin_coder1joinrh contact_noemailhasattrrpu_uuid pu_locationpu_namermr:rC) rGshopshop_address_lines shop_address shop_detailsproduction_unitproduction_unit_address_linesproduction_unit_addressrtr*r*r+_fetch_shop_detailss          >          #      rc Csz|j}|std|j|jdkr|jrg}|jjr#||jj|jjr.||jj|jjr9||jj|jj rD||jj |jj rO||jj |jj rZ||jj |jj rg|t |jj d|}|jjrt|jjnd}|jjr~|jjn|jr|jnd}nd}|js|jr|jd|jnd}|jr|jnd}||||jr|jndd}|WSty}z td|jd|d}~ww) Nz$No user details found for order ID: zPick UprrYrKrU) User Name User Address User Phone User Emailz::) user_uuidr:rCri drop_addresshouse_number_or_namerr land_markrrrrr1rnamecontact_number phone_number first_name last_namerrrm)rGuseruser_address_lines user_address user_namer user_detailsrtr*r*r+_fetch_user_detailsmsH "&rc Csz?t|}t|}t|}t|}t|}td|d|t|}t|}t |}|s5t d||||||||dWSt yU} z t d|d| d} ~ ww)NzItem Details for order r!rD)rSadditonal_detailsr}rrrrr) rHrTrur~rrkrlrrrr:rm) rA order_datarSrsr}rrrrrtr*r*r+_serialize_order_datas0 rc Cstjds(ztdtdtdWdSty'}ztd}~wwtjdsmkdirrmr7)rtr*r*r+_check_output_dirs(     rcCszt|}|WSt|r;)rr9)r?wbr*r*r+ _open_excels rr output_excelcCs>|std||d|d|td|dS)Nz?Workbook is not opened. Please open the workbook before saving./.xlsxzExcel file saved at ) ValueErrorsavecloserkrl)rrrAr*r*r+ _save_excels r  worksheetrowcolumnc CszO|j||d}t|trJg}|jjD]#}|j|kr!|jkr6nq|j|kr/|jkr6nq| |q|D] }| t |q9|j||d}||_ WdSt y}z+td|d|d|z |j|||dWn YWYd}~dSWYd}~dSd}~ww)z>Safely write to a cell, unmerging merged cells before writing.r r zError writing to cell (, z): )r r rN)cell isinstancer merged_cellsrangesmin_rowmax_rowmin_colmax_colr unmerge_cellsr1rrmrkrn)r r r rrranges_to_unmerge merged_rangertr*r*r+_safe_write_cells,    rrScCsTtd||std|dd}|dd}t|dd|t|dd|dS) NzInvoice Details: z7No invoice details provided to write to the excel file.rLrKrM)rkrlr:rFr)r rSinvoice_number invoice_dater*r*r+_write_invoice_detailss  r!rscCs|std|dd}|dd}|dd}|dd}|dd}|dd}t|d d |t|d d |t|d d |t|d d |t|dd |t|dd |td|d|d|d|d|d| dS)Nz:No additional details provided to write to the excel file.r\rKr]r^r_r`rar z%Written additional details: Order No=z, Slot=z , Amount=z, Mode=z , Source=z, Items=r:rFrrkrl)r rsorder_nororprerqrrr*r*r+_write_additional_detailss.       r*r} row_offsetcCs|std|dd}|dd}|dd}t|d|d|t|d|d|t|d |d|td |d |d |dS) Nz5No other charges provided to write to the excel file.rwrXrrvz Written other charges: Delivery=z , Discount=z , Coupon=r()r r}r+ryrzr{r*r*r+_write_other_chargess    r0 total_rowrdcCstdd}t||||d}d|d|}z||Wn ty%Ynw|j|dd}d|_td d |_td d d |_ ||_ |j|dd}d|d|_td d |_td d d |_ ||_ d|j |_ dS)zBWrite the grand-total summary row immediately after all item rows.thinstyle)topbottomleftrightEz:OrrrT)boldr8center) horizontalverticalrrVrWN) rr merge_cellsrmrrrfontr alignmentborderrow_dimensionsheight)r r1rdr2 full_border label_range label_cell value_cellr*r*r+_write_row_total*s&    rIrrcCs|stdd}t|ddD]\}}||d}|dd}|dd}|dd} |d d} |d d} |d d } t|d d} t|dd}t|dd}|dd }|dd}t||d|t||d|t||d|t||d| t||d| t||d| t||dt| dsd| n| t||d| dt||d|dt||d|dt||d|t||d|tdd D]}|j||d!}t d"d"d#d$|_ qq|t |}t |||d%S)&u% Write item rows using the updated template column layout: E(5) = Sl No. F(6) = Item Description G(7) = SKU Code H(8) = Quantity I(9) = Unit Price* J(10) = Gross Value* (Unit Price × Quantity) K(11) = Discount* (discount_per_unit × Quantity) L(12) = CGST Rate(%) Amount M(13) = SGST/UTGST Rate(%) Amount N(14) = CESS Amount O(15) = Total Tax ((Gross Value − Discount) × tax_rate) P(16) = TOTAL Value (Gross Value − Discount + Total Tax) z4No item details provided to write to the excel file.rr[)startrrKrrrrrz0.00rrrrrrrr"r#r$r%rVr&%r'r-rr;Tr<r= wrap_textN) r: enumeraterFrrr1 startswithrangerrrAlenrI)r rrd start_rowidxr current_rowitem_descriptionhsn_coder unit_pricerrz cgst_rate sgst_rate cess_amountrrcolrr1r*r*r+_write_item_detailsFsD         & r`rc Cs|std|dd}|dd}|dd}|dd}|dd}d dg}|||r;|dkr;||d |rF|dkrF|||rQ|dkrQ|||r_|d vr_|d |t|d dd ||jd dd}tdddd|_ dS)Nz4No shop details provided to write to the excel file.rrKrrrrrYzDetails of Supplierr)rKrYzGSTIN: rrrr7r5TrP) r:rFrextendsplitrrrrrA) r r shop_namer shop_phone shop_email shop_gstinlinesrr*r*r+_write_shop_detailss(            rhrcCszz0t|}tt||d}dt|dd}|dkr*|dt|ddd7}|d7}|WSd|d dYS) NrzRupees en_IN)langrz and z paisez onlyrW)rrr capitalize)rrupeespaisewordsr*r*r+_convert_to_wordssrorc Cs|std|dd}t|}d|}d|}t||dd|dt||d||df|dffD]\}}|j||d } td d d d | _q2td|d|dS)Nz5No total details provided to write to the excel file.rrr&rVrWrr7r;TrPzWritten totals: Amount=z, Words=) r:rFrorrrrArkrl) r rr+item_details_totaltextfig_rowwrd_rowr r_rr*r*r+ _write_totalss rvrcCs|std|dd}|dd}|dd}|dd}ddg}|r/|r/|||r?|r?||d |rL|rL|||rY|rY||t|d d d ||jd d d }t d ddd|_ t d|d|dS)Nz4No user details provided to write to the excel file.rrKrrrzBill to/Ship torYrrr#rr7r5TrPzWritten user details: r) r:rFrrrarbrrrrrArkrl)r rrr user_phone user_emailrgrr*r*r+_write_user_detailss&        rywsrVoffsetcCstg}t|jjD]#}|j|kr+|jj|t|j||j||j|jd}| |q|D] }| t |q.dS)N)rrrr) listrrrremover rrrrr?r1)rzrVr{ new_rangescrnew_crrr*r*r+_shift_merged_cellss  rcCst||d|j|ddS)Nr[)rW)r insert_rows)rzr r*r*r+_add_rows rfrom_rowto_rowcCs|j}ttddtddtddtddd}td|dD]O}|j||d}|j||d}t|ts7|j|_|jrat |j |_ t |j |_ t |j |_ t |j |_ d|kr\dkrann||_t |j|_t |j|_qd|j|_dS) Nr2r3)r6r7r8r5r[rrr() max_columnrrrTrrr r has_stylerr@fill protectionrArBcomment hyperlinkrCrD)rzrrr thin_borderr_ source_cell target_cellr*r*r+ _copy_rows,      rpdf_dirc CsNztj||d}d}t|}t|}|jddd|s+td|d|d|d}tj }t d kr]t d d |d <||d <tj |d ddt|d dztj|ddtj|dt dWWdSty}zt d|tt|d}~wwty}zt d|td|d}~ww)Nrz*/var/www/.cache/.config/libreoffice/4/userT)parentsexist_okzInput file not found:zLlibreoffice --headless --norestore --nolockcheck --convert-to pdf --outdir 'z' ''rzRunning as Root Userz/tmp/libreoffice-profile/XDG_RUNTIME_DIRHOME)riz /bin/bash)shell executablestderrenvzPDF conversion successfulzError in PDF Conversion: zError converting excel to pdf: )r<r=rrresolverr>r4environrgeteuidrkrlmakedirschmod subprocess check_outputSTDOUTrmrnr1) rrAr output_filelibreoffice_home file_pathcommandrrtr*r*r+_convert_to_pdf sJ      rcCBtj||d}tj|std|td|dS)Nrz"Output excel file does not exist: zOutput excel file exists: )r<r=rr>r5rkrl)rArrr*r*r+_check_ouptput_excel_exist2 r output_pdfcCr)Nz.pdfz Output pdf file does not exist: zOutput pdf file exists: )r<r=rr>rrkrl)rArrr*r*r+_check_ouptput_pdf_exist9rrr?cCstdt|tt|}|d}d|j_t|}td||di}|di}|di}|di}|d i} |d i} t ||t ||t || t |||d g} t d t| d } | d krtd t| D]} t|d| t|dd| qvt| dd pd }t|| |dt||| dt|| | dd}d}t|||t||t|||t||tddS)NzExcel Writer ModuleSheet2FzData Details: rSrr}rrrrrr[rr)rd)r+zmedia/output/excelzmedia/output/pdfz)Excel Writer Module Executed Successfully)rkrlr@rr sheet_view showGridLinesrrFr!rhryr*maxrUrTrrrr`r0rvr rrr)rAr?rr datarSrsr}rrtotal_calculated_chargesrr+irdrrr*r*r+template_writer@sF                rr8)r)r)Vr<openpyxlropenpyxl.stylesrrropenpyxl.worksheet.worksheetropenpyxl.workbookrropenpyxl.utils.cellr r openpyxl.worksheet.cell_ranger openpyxl.cellr orders.modelsr rrrrrproducts.modelsrraccounts.modelsr shops.modelsrrrkrrrpathlibrrrmrr4r5r6r7r9r:r@r1rHdictrTrur~django.db.modelsrr|rrrrrrrr rrr!r*r0rrIr`rhrorvryrrrrrrrr*r*r*r+sr               Y*  < &