:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/crm/quatation/**
:: Editing File: generated_stock_challan.php
<?php include("db.php"); require_once __DIR__ . '/vendor/autoload.php'; // Validate ID if (!isset($_GET['id']) || empty($_GET['id'])) { die("Error: Movement ID missing."); } $movement_id = mysqli_real_escape_string($conn, $_GET['id']); // ----------------------------------------------------------------------------- // 1. FETCH STOCK MOVEMENT (MASTER DATA) // ----------------------------------------------------------------------------- $sql_movement = " SELECT sm.*, p.name AS vendor_name, cs.company_name AS cold_storage_name FROM stock_movements sm LEFT JOIN party p ON sm.vendor_id = p.id LEFT JOIN cold_storage cs ON sm.cold_storage_id = cs.id WHERE sm.id = '$movement_id' "; $res_m = mysqli_query($conn, $sql_movement); if (!$res_m || mysqli_num_rows($res_m) == 0) { die("Error: No movement record found."); } $move = mysqli_fetch_assoc($res_m); // ----------------------------------------------------------------------------- // 2. FETCH ALL BOX DETAILS (MULTIPLE ROWS) // ----------------------------------------------------------------------------- $sql_box = "SELECT * FROM stock_movement_boxes WHERE movement_id = '$movement_id'"; $res_box = mysqli_query($conn, $sql_box); // Default values $boxData = [ "4H" => 0, "5H" => 0, "6H" => 0, "7H" => 0, "8H" => 0, "9H" => 0, "10H" => 0, "CL" => 0 ]; $total_box_final = 0; while ($row = mysqli_fetch_assoc($res_box)) { $cat = $row['category_name']; // 4H / 5H / 6H / … if (isset($boxData[$cat])) { $boxData[$cat] = $row['box_count']; } $total_box_final += $row['box_count']; } // ----------------------------------------------------------------------------- // START HTML PDF OUTPUT // ----------------------------------------------------------------------------- ob_start(); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>Stock Movement Challan</title> <style> body { font-family: sans-serif; font-size: 12px; } table { width: 100%; border-collapse: collapse; margin-bottom: 10px; } th, td { border: 1px solid #333; padding: 6px; } th { background: #f0f0f0; text-align:center; } .header { text-align:center; margin-bottom:20px; } .challan-title { text-align:center; background:#d2eaff; padding:8px; border:1px solid #004d99; font-size:18px; font-weight:bold; margin-bottom:20px; } .label { background:#f7f7f7; width:25%; font-weight:bold; } .signature-box { margin-top: 40px; width:45%; display:inline-block; border-top:1px solid #000; text-align:center; padding-top:5px; } </style> </head> <body> <div class="header"> <h1>BARJEEL GROUP</h1> <p>1807 Bhairav Lakhani Building Sector 18 Vashi Navi Mumbai Maharashtra 400703</p> <p>Email: barjeelgroup@gmail.com | Mob. No. 9016887760</p> </div> <div class="challan-title"> STOCK MOVEMENT CHALLAN </div> <table> <tr> <!--<td class="label">Movement No:</td><td><?= $move['movement_no'] ?></td>--> <td class="label">Date:</td><td><?= date("d-m-Y", strtotime($move['movement_date'])) ?></td> <td class="label">Type:</td> <td><?= ($move['movement_type'] == 'IN') ? 'INWARD' : 'OUTWARD' ?></td> </tr> <tr> <!--<td class="label">Type:</td> <td><?= ($move['movement_type'] == 'IN') ? 'INWARD' : 'OUTWARD' ?></td>--> <td class="label">Vendor Name:</td> <td><?= $move['vendor_name'] ?></td> <td class="label">Product:</td><td><?= $move['product_name'] ?></td> </tr> <tr> <td class="label">Cold Storage:</td><td colspan=3><?= $move['cold_storage_name'] ?></td> </tr> <!--<tr> <td class="label">Vehicle No:</td><td><?= $move['vehicle_number'] ?></td> <td class="label">Supervisor:</td><td><?= $move['supervisior_name'] ?></td> </tr> --> </table> <!-- BOX TABLE --> <table> <thead> <tr> <th>4H</th> <th>5H</th> <th>6H</th> <th>7H</th> <th>8H</th> <th>9H</th> <th>10H</th> <th>CL</th> <th>Total Box</th> </tr> </thead> <tbody> <tr> <td><?= $boxData['4H'] ?></td> <td><?= $boxData['5H'] ?></td> <td><?= $boxData['6H'] ?></td> <td><?= $boxData['7H'] ?></td> <td><?= $boxData['8H'] ?></td> <td><?= $boxData['9H'] ?></td> <td><?= $boxData['10H'] ?></td> <td><?= $boxData['CL'] ?></td> <td><b><?= $total_box_final ?></b></td> </tr> </tbody> </table> <div> <div class="signature-box">Approved By</div> <div class="signature-box" style="float:right">Received By</div> </div> </body> </html> <?php $html = ob_get_clean(); $mpdf = new \Mpdf\Mpdf(); $mpdf->WriteHTML($html); $mpdf->Output("StockChallan-$movement_id.pdf", "I");