View Code - 20260721

« Back to History

purchase_video_add.php | 20260721_154033.php Initial Bulk Import

<?php

require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('purchase_entry');

$pdo        = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];
$u          = $ctx['user'];

require_once __DIR__ . '/partials/header.php';

$msg='';
$purchase_id='';

/* ===== SEARCH PURCHASE ===== */

if(isset($_GET['id'])){
$purchase_id = (int)$_GET['id'];
}

$row = null;

if($purchase_id){

$stm = $pdo->prepare("
SELECT *
FROM purchase_entry
WHERE purchase_id=? AND company_id=?
");

$stm->execute([$purchase_id,$company_id]);

$row = $stm->fetch();

}

/* ===== VIDEO SAVE ===== */

if($_SERVER['REQUEST_METHOD']=='POST'){

$purchase_id = (int)$_POST['purchase_id'];

if(!empty($_FILES['video']['name'])){

$ext = strtolower(pathinfo($_FILES['video']['name'],PATHINFO_EXTENSION));

$allowed = ['mp4','mov'];

if(in_array($ext,$allowed)){

$new_name = "purchase_".$purchase_id.".".$ext;

$dir = __DIR__."/uploads/purchase_videos/";

if(!is_dir($dir)){
mkdir($dir,0777,true);
}

$target = $dir.$new_name;

move_uploaded_file($_FILES['video']['tmp_name'],$target);

$path = "uploads/purchase_videos/".$new_name;

$up = $pdo->prepare("
UPDATE purchase_entry
SET video_path=?
WHERE purchase_id=? AND company_id=?
");

$up->execute([$path,$purchase_id,$company_id]);

$msg="Video uploaded successfully";

}

<h4>Purchase Video Upload</h4>

<?php if($msg){ ?>
<div class="alert alert-success"><?php echo $msg; ?></div>
<?php } ?>

<div class="col-md-3">
<label>Purchase Entry No</label>
<input type="number" name="id" value="<?php echo htmlspecialchars($purchase_id); ?>" class="form-control">
</div>

<div class="col-md-2 d-flex align-items-end">
<button class="btn btn-primary w-100">Search</button>
</div>

</form>

<?php if($row){ ?>

<strong>Party:</strong> <?php echo htmlspecialchars($row['party_name']); ?><br>
<strong>Date:</strong> <?php echo $row['purchase_date']; ?><br>
<strong>Challan:</strong> <?php echo htmlspecialchars($row['challan_no']); ?><br>
<strong>Bill:</strong> <?php echo htmlspecialchars($row['bill_no']); ?><br>
<strong>Amount:</strong> <?php echo number_format($row['total_amount'],2); ?>

</div>
</div>

<label>Upload Video</label>

</div>

<button class="btn btn-success">Upload Video</button>

</form>

<?php } ?>

</div>

<?php require_once __DIR__ . '/partials/footer.php'; ?>