o 4%i_@sddlZddlmZddlmZddlmZmZddlmZddl m Z ddl m Z ddl m Z mZdd lmZdd lmZmZmZmZmZdd lmZmZdd lmZdd lmZmZddlZddl Z ddlm!Z!m"Z"ddl#m$Z$ddl%m%Z%Gddde&Z'Gddde&Z(Gddde&Z)Gddde&Z*Gddde&Z+Gddde&Z,Gddde&Z-Gdd d e&Z.dtd"d#Z/d$e0d!efd%d&Z1d'ed!e2fd(d)Z3d'ed!e2fd*d+Z4d'ed!e2fd,d-Z5d'ed!e6fd.d/Z7d'ed!e2fd0d1Z8d2e6d!e2fd3d4Z9d'ed!e2fd5d6Z:d'ed!e2fd7d8Z;d$e0d!e2fd9d:ZZ>d!e?fd?d@Z@dAe dBe0d$e0d!dfdCdDZAdEed2e2d!dfdFdGZBdEedHe2d!dfdIdJZCdEedKe2d!dfdLdMZDdEedNe2dOeEd!dfdPdQZFdEedRe6d!eEfdSdTZGdEedUe2d!dfdVdWZHdXeIfdYdZZJdEed[e2dOeEd!dfd\d]ZKdEed^e2d!dfd_d`ZLdadbZMdceddeEd!dfdedfZNdgdhZOdBe0d$e0die0d!dfdjdkZPd$e0dBe0d!dfdldmZQd$e0dne0d!dfdodpZRd$e0dqe0d!dfdrdsZSdS)uN) load_workbook) PatternFill)BorderSide) Worksheet)Workbook)copy)coordinate_from_stringcolumn_index_from_string) CellRange)CustomOrderTrackingOrdersPayment OrderProducts DeliverySlot)SKUProducts)Users)ShopProductionUnit)Font Alignment)Path) num2wordsc*eZdZdZdeddffdd ZZS)OutputPDFNotFoundError Exception for Output pdf not found instance value -- path provided message -- output pdf file not found, please check the output path valuereturnNc*||_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____doc__strr$ __classcell__r)r)r'r*rrcr)ErrorConvertingPDFrrrNcr)Nz#Output pdf file generation failed!.r r!r%r'r)r*r$*r+zErrorConvertingPDF.__init__r,r)r)r'r*r4"r3r4cr)OuptputExcelNotFoundErrorz Exception for Output Excel not found instance value -- path provided message -- output excel file not found, please check the output path rrNcr)Nz:Output excel file not found, please check the output path.r r!r%r'r)r*r$8r+z"OuptputExcelNotFoundError.__init__r,r)r)r'r*r50r3r5cr)TemplateNotFoundErrorz Exception for Template not found instance value -- path provided message -- invalid template path, file not found rrNcr)N&Invalid template path, file not found.r r!r%r'r)r*r$Fr+zTemplateNotFoundError.__init__r,r)r)r'r*r6>r3r6cs"eZdZdZdfdd ZZS)OutputFolderCreationErrorz Exception for creating folder for storing ouput value -- Please check permission issues message -- Error creating Output Folders rNcs*d|_d|_t|jd|jdS)NzPlease check permission issuesr7r r!r&r'r)r*r$Tr+z"OutputFolderCreationError.__init__rN)r-r.r/r0r$r2r)r)r'r*r8Lsr8cr)TemplateFileAlreadyOpenedz Exception for Template file already opened value -- path provided message -- template file already opened, please close the file and try again rrNcr)NzBTemplate file already opened, please close the file and try again.r r!r%r'r)r*r$br+z"TemplateFileAlreadyOpened.__init__r,r)r)r'r*r;Zr3r;cs.eZdZdZdededdffdd ZZS)HeaderMismatchErrorz Exception for Header mismatch value -- expected header, actual header message -- Header mismatch, please check the template file expected_header actual_headerrNcs8||_||_d|_t|jd|jd|jdS)Nz0Header mismatch, please check the template file.z Expected: z , Actual: )r=r>r"r#r$)r&r=r>r'r)r*r$ps&zHeaderMismatchError.__init__)r-r.r/r0listr$r2r)r)r'r*r<hs"r<cr)DataNotFoundErrorz} Exception for Data not found value -- data provided message -- No data provided to write to the excel file rrNcr)NzData Not Foundr r!r%r'r)r*r$r+zDataNotFoundError.__init__r,r)r)r'r*r@wr3r@rcCstj|s t|dSN)ospathexistsr6) template_pathr)r)r*_check_template_exists rForder_idcCs$tjj|d}|std||S)z Fetch order data from the database. This is a placeholder function and should be replaced with actual logic to fetch order data. )order_IDNo data found for order ID: )r objectsgetr@)rGorderr)r)r*_fetch_order_datasrMrLcCsJtjj|d}|std|j|jj|jr|jdndd}|S)z Fetch payment data related to the order. This is a placeholder function and should be replaced with actual logic to fetch payment data. rLz$No payment data found for order ID: %Y-%m-%dN/A)Invoice Number Invoice Date) rrJfilterfirstr@rHrL payment_datestrftime)rLpaymentinvoice_detailsr)r)r*_fetch_invoice_detailssrYc Csz`|jr |jdnd}|jr|jdnd}|d|}|dkr$|}|jr-d|jnd}d}|jr:t|jjnd}|jd krKtj j |d  }nd }|j |||||jd krZ|nd d }W|St d |j )z Fetch additional details related to the order. This is a placeholder function and should be replaced with actual logic to fetch additional details. rOrPz%H:%M ₹₹0UPI Custom OrdersrN)Order NoSlotPayable Amount Payment ModeSource No of itemsz*No additional details found for order ID: )delivery_slot_daterVdelivery_slot_time grand_total store_uuidr1 unit_name order_typerrJrScountrHr@) rLrgrhslotpayable_amount payment_modesource no_of_itemsadditional_detailsr)r)r*_fetch_additional_detailss,  rtcCsz:|jr d|jdnd}|jrd|jdnd}|jr#d|jdnd}|jr/d|jdnd}||||d}W|Std|j)z Fetch other charges related to the order. This is a placeholder function and should be replaced with actual logic to fetch other charges. r[.2fr\)Handling ChargesDelivery ChargesDiscount Total Amountz%No other charges found for order ID: )coupon_savingsdelivery_chargesdiscountrir@rH)rLhandling_chargesr{r| total_amount other_chargesr)r)r*_fetch_other_chargessrc Csz|jdkrtjj|d}g}|D]v}|jjjpd}|jjjp d}|jjjp'd}|||d}t |jj |}t |jj |} t |j | } |jj r^|jj r^|jjd|jj |jj n|jj|jjt|j |jj d|d| dt |t |t || dd } || q|WStjj|d} g}| D]5}|jr|jnd } |j d | }t |jpd}|} d d ||dd |dddd| dd } || q|WSty}z td|jd|d}~ww)zF Fetch item details for both normal orders and custom orders. r_rNrd-ru) Item DescriptionHSN CodeQuantity Unit PriceUnit Tax Value Gross ValueCGST Rate(%) AmountSGST Rate Amount CESS AmountTotal)rGr^rZzCustom Order ItemrPz0.00z$No item details found for order ID:  :: N)rlrrJrSskuproductc_gsts_gstcessfloatsku_mrpquantity sku_quantitysku_unitsku_namesku_coder1appendr quantity_unitstripri Exceptionr@rH)rLitems item_detailsitemrrr tax_totalunit_tax_value gross_valuetotal item_detail custom_itemsqty_unit qty_displaypriceer)r)r* _item_detailssn     rcCs.z|j|j}Wnd}Y|j|d}|S)Nr)r Sub Total) sub_totaltaxes_and_chargesri)rLrtotalsr)r)r*_total1s  rrXc Csz=d}d}d}|D]+}z |t|dd}|t|dd}|t|dd}Wq ty4Yq w|||d}|WStyM}ztdd}~ww)NrrzTaxable Valuesz Other Charges)rzTotal Other ChargeszTotal Taxable Valuesz*Error calculating total for invoice detais)rrK ValueErrorr)rXrtotal_taxable_chargestotal_other_chargesirrr)r)r*_item_details_total:s( rc CsRz|jdkrc|j}|rT|jr|jdnd}||jr!|jdnd7}||jr.|jdn|jr9d|jdn |jrDd|jdnd7}||jrPt|jnd7}nd}|j ||j |j d}|WS|jdkr|j }|r|j rv|j dnd}||jr|jdn,|jrd|jdn!|jrd|jdn|jrd|jdn |jrdt|jnd7}nd}|j||j |j d}|WS|j}|r|jr|jdnd}||jr|jnd7}||jr|jn|jrd|jn |jrd|jnd7}||jrt|jnd7}nd}|j ||j |j d}|WSty(}z td|jd|d }~ww) z Fetch shop details related to the order. This is a placeholder function and should be replaced with actual logic to fetch shop details. z Local Orders r^rP) Shop Name Shop Address Shop Phone Shop EmailzLong Distance Ordersz$No shop details found for order ID: rN)rlrj unit_locationstreetcitydistrictstate_or_provincepin_coder1rk contact_noemailpu_uuid pu_locationpu_namerr@rH)rLshop shop_address shop_detailsproduction_unitproduction_unit_addressrr)r)r*_fetch_shop_detailsQs   )    rc Csz|j}|std|j|jdkr|jjr|jjdnO|jjr+d|jjdnB|jjr8d|jjdn5|jjrEd|jjdn(|jj rRd|jj dn|jj r_d|jj dn|jj rld|jj dnd}|jj rv|jj n|jj }|jj r|jj n|jr|jnd}nd}|jrt|jn |jrdt|jnd}|jr|jnd}||||jr|jndd}|WSty}z td|jd|d}~ww) z Fetch user details related to the order. This is a placeholder function and should be replaced with actual logic to fetch user details. z$No user details found for order ID: zPick Uprr^rP) User Name User Address User Phone User Emailz::N) user_uuidr@rHrl drop_addresshouse_number_or_namer land_markrrrrnamecontact_number phone_number first_namer1 last_namerr)rLuser user_address user_namer user_detailsrr)r)r*_fetch_user_detailssX      "(rc CszFt|}t|}t|}t|}t|}td|d|t|}t|}t |}|s5t d|||dddddd|||||dWSt y\} z t d|d | d} ~ ww) Nz Item Details for all the orders r rI i)CGST%SGST%Sale Taxable Value Tax Value)rXadditonal_detailsgst_inforrrrrr) rMrYrtrrlogginginforrrr@r) rG order_datarXrsrrrrrrr)r)r*_serialize_order_datas4 rc Cstjds(ztdtdtdWdSty'}ztd}~wwtjds=ztdWdSttjdsRztdWdStdS)Nz./media/outputz./media/output/excelz./media/output/pdf)rBrCrDmkdirrr8)rr)r)r*_check_output_dirs(     rcCszt|}W|St|rA)rr;)rEwbr)r)r* _open_excels   rcCs&|jstdt|jtstddS)zu Write data to the excel file data -- dictionary with key as column name and value as data to be written z,No data provided to write to the excel file.zTData should be a dictionary with key as column name and value as data to be written.T)datar@ isinstancer? TypeErrorr9r)r)r* _write_excels  rr output_excelcCs>|std||d|d|td|dS)z0 Save the excel file to the output path z?Workbook is not opened. Please open the workbook before saving./.xlsxzExcel file saved at N)rsavecloserr)rrrGr)r)r* _save_excel s r worksheetcCsjtd||stdt|tstd|dd}|dd}|jdd|d |jd d|d d S) z4 Write the invoice details to the worksheet Invoice Details: z7No invoice details provided to write to the excel file.z_Invoice details should be a dictionary with key as column name and value as data to be written.rQrPrRrowcolumnrN)rrr@rdictrrKcell)rrXinvoice_number invoice_dater)r)r*_write_invoice_detailss   rrscCs|stdt|tstd|dd}|dd}|dd}|dd}|dd}|d d}|jd d |d |jd d |d |jdd |d |jdd |d |jdd |d |jdd |d dS)Nz:No additional details provided to write to the excel file.zbAdditional details should be a dictionary with key as column name and value as data to be written.rarPrbrcrdrerfrrr r@rrrrKr)rrsorder_nornrorprqrrr)r)r*_write_additional_details*s$       rrcCs|stdt|tstd|dd}|dd}|dd}|dd}|dd}|jd d |d |jd d |d |jd d |d |jdd |d |jdd |d dS)Nz0No GST info provided to write to the excel file.zXGST info should be a dictionary with key as column name and value as data to be written.rrPrrrrrrr )rrcgstsgstsale taxable_value tax_valuer)r)r*_write_gst_info?s      rrrow_nocCs|stdt|tstd|dd}|dd}|dd}|dd}|j|dd |d |j|d d |d |j|d d |d dS) Nz5No other charges provided to write to the excel file.z]Other charges should be a dictionary with key as column name and value as data to be written.rvrPrwrxryrrrr r )rrrr}r{r|r~r)r)r*_write_other_chargesTs     rrcCs|stdt|tstdd}t|ddD]\}}|dd}|dd}|d d}|d d}|d d} |d d} |d d} |dd} |dd} |dd}|jd|d|d|jd|d|d|jd|d|d|jd|d|d|jd|d|d|jd|d| d|jd|d| d|jd|dt| dd|jd|dt| dd|jd|dt| dd|jd|d|dd|}q|S)Nz4No item details provided to write to the excel file.zfItem details should be a list of dictionaries with key as column name and value as data to be written.rr`)startrrPrrrrrrrrrrrrrrrrr r rr r)r@rr?r enumeraterKrr)rrridxritem_descriptionhsn_coder unit_pricerrcgst_rate_amountsgst_rate_amount cess_amountrr)r)r*_write_item_detailses>            r(rcCs|stdt|tstd|dd}|dd}|dd}|dd}d|d |d |d |}|jd d |d dS) Nz4No shop details provided to write to the excel file.z\Shop details should be a dictionary with key as column name and value as data to be written.rrPrrrzDetails of Supplier rrrrr )rr shop_namer shop_phone shop_email shop_datar)r)r*_write_shop_detailss      r-rcCs^t|}tt||d}dt|dd}|dkr)|dt|ddd7}|d7}|S) NrzRupees en_IN)langrz and z paisez only)introundr capitalize)rrupeespaisewordsr)r)r*_convert_to_wordssr6rcCs|stdt|tstd|dd}|dd}t|}|r'd|dnd}|r1d|dnd}|j|d d |d |j|d d |d td dd|j|d d d_|j|dd |d dS)Nz5No total details provided to write to the excel file.z]Total details should be a dictionary with key as column name and value as data to be written.rrrr[rur\r`rrr leftcenter) horizontalverticalrrr ) r@rrrrKr6rr alignment)rrritem_details_totalritextr)r)r* _write_totalss   r?rcCs|stdt|tstd|dd}|dd}|dd}|dd}d}||r3|d nd 7}||r@|d nd 7}||rM|d nd 7}||rZ|d nd 7}|jd d |d dS)Nz4No user details provided to write to the excel file.z\User details should be a dictionary with key as column name and value as data to be written.rrPrrrzBill to/Ship to rr^rrr)r@rrrrKrr)rrrr user_phone user_email user_datar)r)r*_write_user_detailss     rCcCstg}t|jjD]#}|j|kr+|jj|t|j||j||j|jd}| |q|D] }| t |q.dS)N)min_rowmax_rowmin_colmax_col) r? merged_cellsrangesrDremover rErFrGr merge_cellsr1)ws start_rowoffset new_rangescrnew_crrr)r)r*_shift_merged_cellss  rSrLrcCst||d|j|ddS)z Add a new row to the worksheet with the given data. :param ws: The worksheet to add the row to. :param row_data: A list of values to be added in the new row. :param start_row: The row number where the new row will be added. r`)r!N)rS insert_rows)rLrr)r)r*_add_rows rUcCs4|j}td|dD]}|j||d}|j||d}|j|_|jrt|j|_|dkrD|dkrDttddtddtddtddd|_ |dkrQttddd |_ |d kr^ttddd |_ |d ksj|d ksj|dkrmd|_ t|j |_ t|j |_ t|j |_ t|j|_t|j|_q d|j|_d|j|_dS)Nr`r;rrthin)style)bottomr7righttop)r7r)rYr r rz0.00%() max_columnrangerr has_stylerfontrrborder number_formatfill protectionr<comment hyperlinkrow_dimensionsheight)rLfrom_rowto_rowrGcol source_cell target_cellr)r)r* _copy_rows0      rnpdf_dirc Csztj||d}d}|}t|}t|}|jddd|s-td|d|d|d}tj }t d kr_t d d |d <||d <tj |d ddt|d dztjdddtjd}t d|Wnty} zt d| WYd} ~ nd} ~ wwz tj|ddtj|d}Wnty} z| }t d|tt| d} ~ wwt d|d|WdSty} zt d| td| d} ~ ww)z Convert the excel file to pdf format. This is a placeholder function and should be replaced with actual logic to convert excel to pdf. rz*/var/www/.cache/.config/libreoffice/4/userT)parentsexist_oku❌ Input file not found:zLlibreoffice --headless --norestore --nolockcheck --convert-to pdf --outdir 'z' ''rzRunning as Root Userz/tmp/libreoffice-profile/XDG_RUNTIME_DIRHOME)rqipwdz /bin/bash)shell executablestderrz"PDF conversion working directory: zChecking logic error: N)rvrwrxenvzError in PDF Conversion: z Converting z to zError converting excel to pdf: )rBrCjoinrresolverrDr4environrgeteuidrrmakedirschmod subprocess check_outputSTDOUTrr1error) rrGro output_filelibreoffice_home file_pathcommandryresultrr)r)r*_convert_to_pdf"sP       rcCBtj||d}tj|std|td|dS)a Check if the output excel file exists. Args: order_id (str): The order ID to check. output_excel (str): The path to the output excel directory. # output path creation pending Raises: DataNotFoundError: If the output excel file does not exist. rz"Output excel file does not exist: zOutput excel file exists: N)rBrCrzrDr5rr)rGrrr)r)r*_check_ouptput_excel_existW r output_pdfcCr)a Check if the output pdf file exists. Args: order_id (str): The order ID to check. output_pdf (str): The path to the output excel directory. # output path creation pending Raises: DataNotFoundError: If the output pdf file does not exist. z.pdfz Output pdf file does not exist: zOutput pdf file exists: N)rBrCrzrDrrr)rGrrr)r)r*_check_ouptput_pdf_existfrrrEcCstdt|tt|}|d}d|j_t|}td||di}td||di}|di}|d i}|d i} |d i} |d i} t ||t ||d } |dg} t | dkrt dt | D]}t |d|t|dd|qut|| }t|| |t|||t|| t|| d}d}t|||t||t|||t||tddS)NzExcel Writer ModuleSheet2FzData Details: rXrrrrrrrrrr`rzmedia/output/excelzmedia/output/pdfz)Excel Writer Module Executed Successfully)rrrFrr sheet_view showGridLinesrrKrrlenr^rUrnr(r?rr-rCrrrr)rGrErrrrXrsrrrrtotal_calculated_chargescounterrrrrror)r)r*template_writervsH                     rr:)TrBopenpyxlropenpyxl.stylesrrropenpyxl.worksheet.worksheetropenpyxl.workbookrropenpyxl.utils.cellr r openpyxl.worksheet.cell_ranger orders.modelsr r rrrproducts.modelsrraccounts.modelsr shops.modelsrrrrrrpathlibrrrrr4r5r6r8r;r<r@rFr1rMrrYrtrr?rrrrrrrrboolrrrrrr0rr(r-rr6r?rCrSrUrnrrrrr)r)r)r*sr             U ?! ' *  #5