File Manager

✏️ nkyou.php

<?php 
include("include/header.php");
include_once("include/connection.php");
include("sadmin/include/db_connect.php");
include_once('libs/fpdf.php');

$oid = $_POST['oid'];

$db = new dbObj();
$connString =  $db->getConnstring();

$name = $_POST['name'];
$totalamount = $_POST['net_total'];
$subtotal = $_POST['total_amount'];
$packaging = $_POST['packing_charges_value'];
$email = $_POST['email'];
$emailadmin = "wesreeramtraders@gmail.com";
$ccEmail =  "shankarsmpt007@gmail.com";
$mobile = $_POST['mobile'];
$address = $_POST['address'];
$state = $_POST['state'];
$city = $_POST['city'];
$referal_code = $_POST['referal_code'];
$comments = $_POST['comments']; // ✅ New Comments field

/* Build order_details string (legacy style) */
foreach ($_POST["category"] as $key1 => $val1) { if (isset($val1)) $data1 .= $val1 . ",nxt"; }
$category = "Category:" . $data1 . "loremmark";

foreach ($_POST["product"] as $key2 => $val2) { if (isset($val2)) $data2 .= $val2 . ",nxt"; }
$product = "Product:" . $data2 . "loremmark";

foreach ($_POST["umtype"] as $key3 => $val3) { if (isset($val3)) $data3 .= $val3 . ",nxt"; }
$umtype = "Umtype:" . $data3 . "loremmark";

foreach ($_POST["originalprice"] as $key4 => $val4) { if (isset($val4)) $data4 .= $val4 . ",nxt"; }
$originalprice = "Originalprice:" . $data4 . "loremmark";

foreach ($_POST["offerprice"] as $key5 => $val5) { if (isset($val5)) $data5 .= $val5 . ",nxt"; }
$offerprice = "Offerprice:" . $data5 . "loremmark";

foreach ($_POST["quantity"] as $key6 => $val6) { if (isset($val6)) $data6 .= $val6 . ",nxt"; }
$qty = "Qty:" . $data6 . "loremmark";

foreach ($_POST["amount"] as $key7 => $val7) { if (isset($val7)) $data7 .= $val7 . ",nxt"; }
$total = "Total:" . $data7 . "loremmark";

/* JSON Order items */
$productsArray = [];
foreach ($_POST["category"] as $key => $categoryVal) {
    $productVal = $_POST["products"][$key] ?? null;
    $quantityVal = $_POST["quantity"][$key] ?? null;
    if ($productVal && $quantityVal) {
        $productsArray[] = [
            'pid' => $productVal,
            'qty' => $quantityVal,
        ];
    }
}
$productsJson = json_encode($productsArray);

$totaldata = $category . $product . $umtype . $originalprice . $offerprice . $qty . $total;
$order_id = $oid;
$txn_id = "SRMT" . $oid;

/* ✅ Update Order with comments */
$Insert_member = "UPDATE tbl_orders 
                  SET `name` = '" . mysqli_real_escape_string($mysqli, $name) . "',
                      `mobile` = '" . mysqli_real_escape_string($mysqli, $mobile) . "',
                      `email` = '" . mysqli_real_escape_string($mysqli, $email) . "',
                      `address` = '" . mysqli_real_escape_string($mysqli, $address) . "',
                      `state` = '" . mysqli_real_escape_string($mysqli, $state) . "',
                      `city` = '" . mysqli_real_escape_string($mysqli, $city) . "',
                      `referal_code` = '" . mysqli_real_escape_string($mysqli, $referal_code) . "',
                      `comments` = '" . mysqli_real_escape_string($mysqli, $comments) . "',
                      `order_details` = '$totaldata',
                      `total_qty` = '" . $_POST['no_of_items'] . "',
                      `total_amount` = '" . $_POST['net_total'] . "',
                      `subtotal` = '" . $_POST['total_amount'] . "',
                      `packaging` = '" . $_POST['packing_charges_value'] . "',
                      `varstatus` = 'Pending',
                      `date` = CURDATE(),
                      `Order_id` ='$txn_id',
                      `amount_status` = 'Pending',
                      `orders` = '$productsJson'
                  WHERE `Oid` = '$oid'";

$inexe = mysqli_query($mysqli, $Insert_member);

/* ---------------- Email to Admin ------------------- */
$Msg1 = '<table width="865" border="0">
<tr><td>Dear Admin,</td></tr>
<tr><td>Order Update From Sree Ram Traders </td></tr>
<tr><td>Below is the Enquiry details:<br />
Order Id : ' . $txn_id . '<br />
Total Amount : Rs.' . $totalamount . '<br />
Name : ' . $name . '<br />
Email : ' . $email . '<br />
Mobile : ' . $mobile . '<br />
Address : ' . $address . '<br />
State : ' . $state . '<br />
City : ' . $city . '<br />
Pincode : ' . $referal_code . '<br />
Comments : ' . nl2br($comments) . '<br />
</td></tr>
<tr><td>Yours sincerely,<br />Sree Ram Traders</td></tr>
</table>';

$Subject = "Order Update from Sree Ram Traders";
$headers1 = "MIME-Version: 1.0\r\n";
$headers1 .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers1 .= 'From: Sree Ram Traders <info@sreeramtraders.com>' . "\r\n";

mail($emailadmin, $Subject, $Msg1, $headers1);

/* ---------------- Fetch for PDF ------------------- */
$Oid=$order_id;
$objResult    = mysqli_query($mysqli,"SELECT * from tbl_orders WHERE  `Oid` = '$Oid'") or die ("Error:".mysqli_error($mysqli));
$Fetch        = mysqli_fetch_array($objResult);

$subtotal=$Fetch['subtotal'];
$packcharge=$Fetch['packaging'];
$total=$Fetch['total_amount'];
$memname=$Fetch['name'];
$memmobile=$Fetch['mobile'];
$memaddress=$Fetch['address'];
$enquiryid=$Fetch['Order_id'];
$enquirydate=$Fetch['date'];
$particulardata=$Fetch['order_details'];
$memcomments=$Fetch['comments']; // ✅ Fetch comments

/* ---------------- PDF Generate ------------------- */
class PDF extends FPDF {
    function Header() {
        $this->Image('sreeramtraders_logo.png',10,5,70);
        $this->SetFont('Arial','B',13);
        $this->Cell(80);
        $this->Cell(40,10,'',0,0,'C');
        $this->Cell(70,10,'Estimate',1,0,'C');
        $this->Ln(15);
    }
    function Footer() {
        $this->SetY(-15);
        $this->SetFont('Arial','I',8);
        $this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
    }
}

$display_heading = ['sno'=>'Sno','Category'=>'Category','ProductName'=>'Product Name','UM'=>'UM','Price'=>'Price','Qty'=>'Qty','Total'=>'Total(Rs.)'];

/* Decode old style order_details */
$categoryarray = explode(",nxt", explode('loremmark', explode('Category:', $particulardata)[1])[0]);
$productarray = explode(",nxt", explode('loremmark', explode('Product:', $particulardata)[1])[0]);
$umtypearray = explode(",nxt", explode('loremmark', explode('Umtype:', $particulardata)[1])[0]);
$originalpricearray = explode(",nxt", explode('loremmark', explode('Originalprice:', $particulardata)[1])[0]);
$offerpricearray = explode(",nxt", explode('loremmark', explode('Offerprice:', $particulardata)[1])[0]);
$qtyarray = explode(",nxt", explode('loremmark', explode('Qty:', $particulardata)[1])[0]);
$totalarray = explode(",nxt", explode('loremmark', explode('Total:', $particulardata)[1])[0]);

$resultcount = count($qtyarray);

$pdf = new PDF();
$pdf->AddPage();
$pdf->AliasNbPages();
$pdf->SetFont('Arial','B',8);

/* Table Headings */
$k=1;
foreach($display_heading as $val) {
    if($k==1) $pdf->Cell(20, 7, $val, 1,0,'C');
    if($k==2) $pdf->Cell(50, 7, $val, 1,0,'C');
    if($k==3) $pdf->Cell(60, 7, $val, 1,0,'C');
    if($k==4) $pdf->Cell(10, 7, $val, 1,0,'C');
    if($k==5) $pdf->Cell(20, 7, $val, 1,0,'C');
    if($k==6) $pdf->Cell(10, 7, $val, 1,0,'C');
    if($k==7) $pdf->Cell(20, 7, $val, 1,0,'C');
    $k++;
    if($k==7) $k=1;
}
$pdf->SetFont('Arial','I',8);

$j=0;
for($i=0;$i<$resultcount;$i++) {
    if(trim($qtyarray[$i])!="") {
        $j++;
        $catid=$categoryarray[$i];
        $objResult1 = mysqli_query($mysqli,"SELECT * from tbl_category WHERE `Cid` = '$catid'") or die ("Error:".mysqli_error($mysqli));
        $Fetch1 = mysqli_fetch_array($objResult1);
        $categoryfetch=$Fetch1['category'];

$pdf->Ln();
        $pdf->Cell(20, 7, $j, 1,0,'C');
        $pdf->Cell(50, 7, $categoryfetch, 1); 
        $pdf->Cell(60, 7, $productarray[$i], 1);
        $pdf->Cell(10, 7, $umtypearray[$i], 1,0,'C');
        $pdf->Cell(20, 7, $offerpricearray[$i], 1,0,'C');
        $pdf->Cell(10, 7, $qtyarray[$i], 1,0,'C');
        $pdf->Cell(20, 7, $totalarray[$i], 1,0,'C');
    }
}

/* Totals + Customer Info */
$pdf->SetFont('Arial','B',8);
$pdf->Ln();
$pdf->Cell(20, 7, ' ', 0);
$pdf->Cell(110,7, '');
$pdf->Cell(40, 7, "Subtotal", 1,0,'C');
$pdf->Cell(20, 7, $subtotal, 1,0,'C');

$pdf->Ln();
$pdf->Cell(20, 7, 'Name -', 0);
$pdf->Cell(50, 7, $memname, 0);
$pdf->Cell(20, 7, 'Mobile -', 0);
$pdf->Cell(40, 7, $memmobile, 0);
$pdf->Cell(40, 7, "Packaging Charges", 1,0,'C');
$pdf->Cell(20, 7, $packcharge, 1,0,'C');

$pdf->Ln();
$pdf->Cell(20, 7, 'Enquiry ID -', 0);
$pdf->Cell(50, 7, $enquiryid, 0);
$pdf->Cell(20, 7, 'Date -', 0);
$pdf->Cell(40, 7, $enquirydate, 0);
$pdf->Cell(40, 7, "Total", 1,0,'C');
$pdf->Cell(20, 7, $total, 1,0,'C');

$pdf->Ln();
$pdf->Cell(20, 7, 'Address -', 0);
$pdf->Cell(110,7, $memaddress, 0);

/* ✅ Add Comments */
$pdf->Ln(12);
$pdf->SetFont('Arial','B',9);
$pdf->Cell(30, 7, 'Comments:', 0);
$pdf->SetFont('Arial','',9);
$pdf->MultiCell(0, 6, $memcomments);

$filename="pdf/sreeramtraders$Oid.pdf";
$pdf->Output($filename,'F');

/* ---------------- Email with PDF to Customer ------------------- */
$to          = $email;
$from        = "info@sreeramtraders.com";
$subject     = "Order Update from Sree Ram Traders";
$body        = '<table width="865" border="0">
<tr><td>Dear ' . $name . ',</td></tr>
<tr><td>Thank You for your enquiry. </td></tr>
<tr><td>Your Enquiry Reference:<br />
Enquiry Id: ' . $txn_id . '<br />
Estimate: Rs.' . $totalamount . '</td></tr>
<tr><td><strong>Comments:</strong><br/>'.nl2br($memcomments).'</td></tr>
<tr><td>Yours Sincerely,<br />Sree Ram Traders</td></tr>
</table>';

$pdfLocation = $filename;
$pdfName     = "sreeramtraders$Oid.pdf";
$filetype    = "application/pdf";

$eol = PHP_EOL;
$semi_rand     = md5(time());
$mime_boundary = "==Multipart_Boundary_$semi_rand";
$headers       = "From: Sree Ram Traders <info@sreeramtraders.com>$eol" . "CC: $emailadmin$eol" .
    "Content-Type: multipart/mixed;$eol boundary=\"$mime_boundary\"";

$message = "--$mime_boundary$eol" .
    "Content-Type: text/html; charset=\"iso-8859-1\"$eol" .
    "Content-Transfer-Encoding: 7bit$eol$eol$body$eol";

$file = fopen($pdfLocation, 'rb');
$data = fread($file, filesize($pdfLocation));
fclose($file);
$pdf = chunk_split(base64_encode($data));

$message .= "--$mime_boundary$eol" .
    "Content-Type: $filetype;$eol name=\"$pdfName\"$eol" .
    "Content-Disposition: attachment;$eol filename=\"$pdfName\"$eol" .
    "Content-Transfer-Encoding: base64$eol$eol$pdf$eol--$mime_boundary--";

@mail($to, $subject, $message, $headers);
?>

<div class="container">
    <div class="row">
        <div class="col-12 text-center mb-3">
            <img src="images/banner1.jpg" class="img-fluid shadow-1-strong rounded" alt="About Us" style="width:100%;">
        </div>
    </div>
    <div class="row bg-red text-white ml-0 mr-0">
        <div class="col-12 pt-2 pb-2 d-flex align-items-center justify-content-center">
            Use always Genuine Fireworks and Crackers
        </div>
    </div>
    <div class="text-center mt-5 mb-5" style="font-size:16px;">
        <blockquote>
            Your Enquiry <span style="font-size:30px;"><b><?php echo $Fetch['Order_id']; ?></b></span> 
            amount of <span style="font-size:30px;">Rs.<?php echo $totalamount; ?></span> was successfully updated.<br>
            <b>Comments:</b> <?php echo htmlspecialchars($memcomments); ?>
        </blockquote>
        For further details please call: +91 9080765480 <br><br>
        <a href="pdf/sreeramtraders<?php echo $Oid; ?>.pdf" class="btn bg-dark p-3 text-white" role="button">
            Download Enquiry
        </a>
    </div>
    <div class="text-center mt-5 mb-5" style="font-size:16px;">
        <iframe src="pdf/sreeramtraders<?php echo $Oid; ?>.pdf" width="900" height="600" title="Enquiry PDF"></iframe>
    </div>
</div>
<?php include ('include/footer.php') ?>
</body>
</html>

Batal

⬅ sreeramtraders.com 40 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁editor	dir	—	2025-10-17 06:05	📂 Buka
📁images	dir	—	2025-09-25 07:18	📂 Buka
📁include	dir	—	2025-10-17 06:05	📂 Buka
📁js	dir	—	2025-10-17 06:05	📂 Buka
📁libs	dir	—	2025-09-03 09:04	📂 Buka
📁pdf	dir	—	2026-09-18 21:49	📂 Buka
📁sadmin	dir	—	2025-09-03 09:04	📂 Buka
📄.htaccess	htaccess	825 B	2025-10-17 06:06	✏️ 👁️
📄.user.ini	ini	585 B	2025-09-03 09:04	✏️ 👁️
🐘about-us.php	php	2.6 KB	2025-09-03 09:04	✏️ 👁️
🐘blurbs.php	php	175.5 KB	2025-09-03 09:04	✏️ 👁️
🐘contact.php	php	2.9 KB	2025-09-03 09:04	✏️ 👁️
📄css2	file	11.6 KB	2025-09-03 09:04	✏️ 👁️
🐘download_pdf.php	php	3.1 KB	2025-09-03 09:04	✏️ 👁️
🐘edit_order.php	php	22.4 KB	2025-09-24 09:06	✏️ 👁️
🐘editfeb14.php	php	5.6 KB	2025-09-03 09:04	✏️ 👁️
🐘editthankyou.php	php	11.8 KB	2025-09-06 04:49	✏️ 👁️
🐘enquirenow.php	php	35.6 KB	2025-09-24 04:54	✏️ 👁️
📄error_log	file	63 KB	2025-09-03 09:04	✏️ 👁️
🎨floating-wpp.min.css	css	1.8 KB	2025-09-03 09:04	✏️ 👁️
📜floating-wpp.min.js	js	7.3 KB	2025-09-03 09:04	✏️ 👁️
📄floating-wpp.min.js.download	download	7.3 KB	2025-09-03 09:04	✏️ 👁️
📜functions.js	js	2.6 KB	2025-09-03 09:04	✏️ 👁️
📄functions.js.download	download	2.6 KB	2025-09-03 09:04	✏️ 👁️
🐘generate_pdf.php	php	3 KB	2025-09-03 09:04	✏️ 👁️
🐘gift-boxes.php	php	3.2 KB	2025-09-03 09:04	✏️ 👁️
🐘index.php	php	11 KB	2026-09-17 14:24	✏️ 👁️
🐘iniphp.php	php	644 B	2025-09-03 09:04	✏️ 👁️
🎨plugins.css	css	202.5 KB	2025-09-03 09:04	✏️ 👁️
📜plugins.js	js	433.4 KB	2025-09-03 09:04	✏️ 👁️
📄plugins.js.download	download	433.4 KB	2025-09-03 09:04	✏️ 👁️
🐘price-list.php	php	5.7 KB	2025-09-03 09:04	✏️ 👁️
🖼️sreeramtraders_logo.png	png	22 KB	2025-09-03 09:04	✏️ 👁️
🎨style.css	css	331 B	2025-09-03 09:04	✏️ 👁️
🎨sweetalert2.css	css	37.7 KB	2025-09-03 09:04	✏️ 👁️
📜sweetalert2.min.js	js	35 KB	2025-09-03 09:04	✏️ 👁️
📄sweetalert2.min.js.download	download	35 KB	2025-09-03 09:04	✏️ 👁️
🐘testenquirenow.php	php	35.6 KB	2025-09-25 07:18	✏️ 👁️
🐘testthankyou.php	php	12.8 KB	2025-09-25 07:38	✏️ 👁️
🐘thankyou.php	php	12.8 KB	2026-09-17 14:30	✏️ 👁️

✏️ Rename