Showing posts with label Invoice. Show all posts
Showing posts with label Invoice. Show all posts

Thursday, October 5, 2023

Export multiple records to PDF one by one from Excel

 Sub ExportRangeToPDF()

    For a = 3 To 10

        Sheet1.Range("D4").Value = Sheet2.Cells(a, "A")

        Sheet1.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Naeem\OneDrive\Desktop\PrintingPDF\" & Sheet1.Range("D4").Value & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

    Next

End Sub

Tuesday, June 1, 2021

Bkash Merchant QR Code on WHMCS invoice

At the line number 104 of invoicepdf.tpl

 # QR Payment Code

$qrFilename = 'QR_INVOICE.png';

if (file_exists(ROOTDIR . '/assets/img/QR_INVOICE.png')) {

    $qrFilename = 'QR_INVOICE.png';

} elseif (file_exists(ROOTDIR . '/assets/img/logo.jpg')) {

    $qrFilename = 'logo.jpg';

}

$pdf->Image(ROOTDIR . '/assets/img/' . $qrFilename, 120, 110, 75);


$pdf->Ln(10);

SQL to delete all WooCommerce products except those with "draft" status

 -- Disable foreign key checks (important for InnoDB) SET     FOREIGN_KEY_CHECKS = 0;     -- Delete product meta DELETE     pm FROM     wp_p...