Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u506365997

Directory:

/home/u506365997/domains/creativeink.in/public_html/creativeinkadmin

Free Space:

3.15 TB

🔧 Quick Actions

✏️ Editing: getpdf.php

<?php
session_start();
include './sql/config.php';
	if(empty($_SESSION['username'])){

echo "<script>
            window.location = 'login.php';
          </script>";
    exit();
}
require_once('../fpdf/fpdf.php');
require_once('../FPDI/src/autoload.php');
if (isset($_GET['p_id'])) {
    $productid = $_GET['p_id'];
    if(isset($productid)){
        $sql = mysqli_query($conn, "SELECT * FROM `bill` WHERE p_id = '$productid' AND status = 1") or mysqli_error($conn);
        if(mysqli_num_rows($sql) > 0){
            $row = mysqli_fetch_array($sql);
            $pid = $row['p_id'];
            $cid = $row['c_id'];
            $product = mysqli_query($conn, "SELECT * FROM `product_order` WHERE id = '$pid'") or mysqli_error($conn);
            if(mysqli_num_rows($product) > 0){
                $row_product = mysqli_fetch_array($product);
            }
            $customer = mysqli_query($conn, "SELECT * FROM `user` WHERE id = '$cid'") or mysqli_error($conn);
            if(mysqli_num_rows($customer) > 0){
                $rowcustomer = mysqli_fetch_array($customer);
            }
            $addresscustomer = mysqli_query($conn, "SELECT * FROM customer_details WHERE c_id = '$cid'") or mysqli_error($conn);
            if(mysqli_num_rows($addresscustomer) > 0){
                $rowaddress = mysqli_fetch_array($addresscustomer);
            }
        }else{
            header('location:./index.php');
        }
    } 
} else {
    header('location:./index.php');
}

// number to word
function convertNumberToWords($number) {
    $hyphen      = '-';
    $conjunction = ' and ';
    $separator   = ', ';
    $negative    = 'negative ';
    $decimal     = ' point ';
    $dictionary  = array(
        0                   => 'zero',
        1                   => 'one',
        2                   => 'two',
        3                   => 'three',
        4                   => 'four',
        5                   => 'five',
        6                   => 'six',
        7                   => 'seven',
        8                   => 'eight',
        9                   => 'nine',
        10                  => 'ten',
        11                  => 'eleven',
        12                  => 'twelve',
        13                  => 'thirteen',
        14                  => 'fourteen',
        15                  => 'fifteen',
        16                  => 'sixteen',
        17                  => 'seventeen',
        18                  => 'eighteen',
        19                  => 'nineteen',
        20                  => 'twenty',
        30                  => 'thirty',
        40                  => 'forty',
        50                  => 'fifty',
        60                  => 'sixty',
        70                  => 'seventy',
        80                  => 'eighty',
        90                  => 'ninety',
        100                 => 'hundred',
        1000                => 'thousand',
        1000000             => 'million',
        1000000000          => 'billion',
        1000000000000       => 'trillion',
        1000000000000000    => 'quadrillion',
        1000000000000000000 => 'quintillion'
    );

if (!is_numeric($number)) {
        return false;
    }

if (($number >= 0 && (int) $number < 0) || (int) $number < 0 - PHP_INT_MAX) {
        // Overflow
        return false;
    }

if ($number < 0) {
        return $negative . convertNumberToWords(abs($number));
    }

$string = $fraction = null;

if (strpos($number, '.') !== false) {
        list($number, $fraction) = explode('.', $number);
    }

switch (true) {
        case $number < 21:
            $string = $dictionary[$number];
            break;
        case $number < 100:
            $tens   = ((int) ($number / 10)) * 10;
            $units  = $number % 10;
            $string = $dictionary[$tens];
            if ($units) {
                $string .= $hyphen . $dictionary[$units];
            }
            break;
        case $number < 1000:
            $hundreds  = (int) ($number / 100);
            $remainder = (int) ($number % 100);
            $string = $dictionary[$hundreds] . ' ' . $dictionary[100];
            if ($remainder) {
                $string .= $conjunction . convertNumberToWords($remainder);
            }
            break;
        default:
            $baseUnit = pow(1000, floor(log($number, 1000)));
            $numBaseUnits = (int) ($number / $baseUnit);
            $remainder = $number % $baseUnit;
            $string = convertNumberToWords($numBaseUnits) . ' ' . $dictionary[$baseUnit];
            if ($remainder) {
                $string .= $remainder < 100 ? $conjunction : $separator;
                $string .= convertNumberToWords($remainder);
            }
            break;
    }

if ($fraction !== null && is_numeric($fraction)) {
        $string .= $decimal;
        $words = array();
        foreach (str_split((string) $fraction) as $number) {
            $words[] = $dictionary[$number];
        }
        $string .= implode(' ', $words);
    }

return $string;
}

$pdf = new \setasign\Fpdi\Fpdi();

// Set the source PDF file
$pageCount = $pdf->setSourceFile('../creativinkinvoice.pdf');

$pageId = $pdf->importPage(1, \setasign\Fpdi\PdfReader\PageBoundaries::MEDIA_BOX);

$size = $pdf->getTemplateSize($pageId);

$pdf->addPage();

$scaleWidth = 210; 
$scaleHeight = ($size['height'] / $size['width']) * $scaleWidth;

$pdf->useImportedPage($pageId, 0, 0, $scaleWidth, $scaleHeight);

$pdf->SetFont('Arial', 'B', 8); 
$pdf->SetTextColor(0, 0, 0);    
$pdf->SetXY(30, 51); 
$pdf->Cell(40, 10, $rowcustomer['customer_name'], 0, 1);

$pdf->SetFont('Arial', '', 8); 
$pdf->SetXY(30, 58.7);
$address = $rowaddress['address']." ".$rowaddress['landmark']." ".$rowaddress['dist']." ". $rowaddress['state']." ".$rowaddress['pin'];
$cellWidth = 50; 
$cellHeight = 4;

$pdf->MultiCell($cellWidth, $cellHeight, $address, 0, 'L');

$pdf->SetFont('Arial', '', 10); 
$pdf->SetXY(30, 67.5);
$pdf->Cell(40, 10, $rowcustomer['customer_phone'], 0, 1);

$pdf->SetFont('Arial', '', 8); 
$pdf->SetXY(30, 77);
$pdf->Cell(40, 10, $rowaddress['dist'], 0, 1);

$pdf->SetFont('Arial', 'B', 11); 
$pdf->SetXY(110, 47);
$pdf->Cell(40, 10, $row['id'], 0, 1);

$pdf->SetFont('Arial', '', 8); 
$pdf->SetXY(168, 46.6);
$date = $row['billdate'];
$orgdate = date('d-m-Y', strtotime($date));
$pdf->Cell(40, 10, $orgdate, 0, 1);

$pdf->SetFont('Arial', '', 8); 
$pdf->SetXY(14, 100);
$pdf->Cell(40, 10, 1, 0, 1);

$pdf->SetFont('Arial', 'B', 9); 
$pdf->SetXY(20, 99.9);
$pdf->Cell(40, 10, $row_product['p_name'], 0, 1);

$pdf->SetFont('Arial', '', 8); 
$pdf->SetXY(20, 105);
$pdf->Cell(40, 10, "(" . $row_product['categori'] . ")", 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(133, 99.9);
$pdf->Cell(40, 10, $row_product['quantity'] . ".00", 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(153, 99.9);
$pdf->Cell(40, 10, $row_product['price'] . ".00", 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(180, 99.9);
$pdf->Cell(40, 10, $row_product['total'] . ".00", 0, 1);

// shipping details
$pdf->SetFont('Arial', 'B', 9); 
$pdf->SetXY(20, 112);
$pdf->Cell(40, 10, 'Shipping Charge', 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(133, 112);
$pdf->Cell(40, 10,   "0.00", 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(153, 112);
$pdf->Cell(40, 10, $row['shiping'] . ".00", 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(180, 112);
$pdf->Cell(40, 10, $row['shiping'] . ".00", 0, 1);

// tax charges
$pdf->SetFont('Arial', 'B', 9); 
$pdf->SetXY(20, 118);
$pdf->Cell(40, 10, 'TAX / GST', 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(133, 118);
$pdf->Cell(40, 10,   "0.00", 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(153, 118);
$pdf->Cell(40, 10, $row['tax'] . ".00", 0, 1);

$pdf->SetFont('Arial', '', 9); 
$pdf->SetXY(180, 118);
$pdf->Cell(40, 10, $row['tax'] . ".00", 0, 1);

// total quantity

$pdf->SetFont('Arial', 'B', 9); 
$pdf->SetXY(133, 195);
$pdf->Cell(40, 10,   $row_product['quantity'].".00", 0, 1);

$pdf->SetFont('Arial', 'B', 9); 
$pdf->SetXY(180, 195);
$pdf->Cell(40, 10, $row['total'] . ".00", 0, 1);

// ruppe in word
$totalInWords = convertNumberToWords($row['total']);
$pdf->SetFont('Arial', '', 8); 
$pdf->SetXY(0, 213);
$totalWidth = $pdf->GetStringWidth(ucfirst($totalInWords) . " RUPEES ONLY");

// Calculate the X position to center the text
$x = ($pdf->GetPageWidth() - $totalWidth) / 4;
$pdf->SetX($x);

// Add the total in words, centered
$pdf->Cell(0, 10, strtoupper(ucfirst($totalInWords)) . " RUPEES ONLY", 0, 1);

$pdf->Image('rupee-indian.png', 176, 208.5, 3, 3); 
$pdf->SetFont('Arial', 'B', 9); 
$pdf->SetXY(180, 205);
$pdf->Cell(40, 10, $row['total'].".00", 0, 1);

if($row['paidby'] == 'bank'){
    $pdf->SetFont('Arial', '', 8); 
    $pdf->SetXY(13, 226);
    $pdf->Cell(40, 10, "Bank Name : ", 0, 1);
    $pdf->SetXY(33, 226);
    $pdf->Cell(40, 10, $row['bank'], 0, 1);

$pdf->SetXY(13, 230);
    $pdf->Cell(40, 10, "Branch : ", 0, 1);
    $pdf->SetXY(33, 230);
    $pdf->Cell(40, 10, $row['branch'], 0, 1);

$pdf->SetXY(13, 234);
    $pdf->Cell(40, 10, "Account : ", 0, 1);
    $pdf->SetXY(32.6, 234);
    $pdf->Cell(40, 10, $row['account'], 0, 1);

$pdf->SetXY(13, 238);
    $pdf->Cell(40, 10, "IFSC : ", 0, 1);
    $pdf->SetXY(33, 238);
    $pdf->Cell(40, 10, strtoupper($row['ifsc']), 0, 1);
}else if($row['paidby'] == 'cash'){
    $pdf->SetFont('Arial', '', 8); 
    $pdf->SetXY(13, 226);
    $pdf->Cell(40, 10, "Payment Type : ", 0, 1);
    $pdf->SetXY(45, 226);
    $pdf->Cell(40, 10, strtoupper($row['paidby']), 0, 1);
}else if($row['paidby'] == 'upi'){
    $pdf->SetFont('Arial', '', 8); 
    $pdf->SetXY(13, 226);
    $pdf->Cell(40, 10, "Paid By : ", 0, 1);
    $pdf->SetXY(30, 226);
    $pdf->Cell(40, 10, strtoupper($row['paidby']), 0, 1);

$pdf->SetXY(13, 231);
    $pdf->Cell(40, 10, "UPI ID. : ", 0, 1);
    $pdf->SetXY(30, 231);
    $pdf->Cell(40, 10, $row['upi'], 0, 1);  
}
else if($row['paidby'] == 'other'){
    $pdf->SetFont('Arial', '', 8); 
    $pdf->SetXY(13, 226);
    $pdf->Cell(40, 10, "Paid By. : ", 0, 1);
    $pdf->SetXY(30, 226);
    $pdf->Cell(40, 10, $row['other'], 0, 1);
}

$customerName = $rowcustomer['customer_name'];
$sanitizedCustomerName = preg_replace('/[^A-Za-z0-9_\-]/', '_', $customerName);
$sanitizedCustomerName = substr($sanitizedCustomerName, 0, 50);
// Generate PDF
$pdf->Output('I', $sanitizedCustomerName . '.pdf');
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: getpdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation