View Code - 20260721

purchase_entry_add.php | 20260721_154033.php Initial Bulk Import

<?php

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

$pdo        = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];
$u          = $ctx['user'];
$user_id    = (int)($u['id'] ?? 0);

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

$msg='';

/* ===== PARTY LIST ===== */

$stm = $pdo->prepare("
SELECT party_id, party_name
FROM party_master
WHERE company_id=?
AND is_active=1
ORDER BY party_name
");

$stm->execute([$company_id]);
$party_list = $stm->fetchAll();

/* ===== SAVE ENTRY ===== */

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

$party        = trim($_POST['party']);
$challan_no   = trim($_POST['challan_no']);
$bill_no      = trim($_POST['bill_no']);
$item_name    = trim($_POST['item_name']);
$qty          = (float)$_POST['quantity'];
$amount       = (float)$_POST['total_amount'];
$date         = $_POST['purchase_date'];

$stm = $pdo->prepare("
INSERT INTO purchase_entry
(company_id,party_name,challan_no,bill_no,item_name,quantity,total_amount,purchase_date)
VALUES (?,?,?,?,?,?,?,?)
");

$stm->execute([
$company_id,
$party,
$challan_no,
$bill_no,
$item_name,
$qty,
$amount,
$date
]);

$purchase_id = $pdo->lastInsertId();

/* ===== VIDEO UPLOAD ===== */

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 = "Purchase saved successfully (Entry No: ".$purchase_id.")";

activity_log([
	'company_id' => $company_id ?? 0,
	'user_id' => $u['id'] ?? ($_SESSION['user_id'] ?? 0),
	'module' => 'purchase',
	'action_name' => 'create',
	'entity_type' => 'purchase_entry',
	'entity_id' => $purchase_id ?? 0,
	'remarks' => 'Purchase entry created'
]);

}

<h4>Purchase Entry</h4>

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

<div class="col-md-6 mb-3">
<label>Party Name</label>

<option value="">Select Party</option>

<?php foreach($party_list as $p){ ?>

<?php } ?>

</select>

</div>

<div class="col-md-3 mb-3">
<label>Challan No</label>
<input type="text" name="challan_no" class="form-control">
</div>

<div class="col-md-3 mb-3">
<label>Quantity</label>
<input type="number" step="0.01" name="quantity" class="form-control">
</div>

<div class="col-md-3 mb-3">
<label>Total Amount</label>
<input type="number" step="0.01" name="total_amount" class="form-control">
</div>

<div class="col-md-8 mb-3">
<label>Video Upload</label>
<input type="file" name="video" class="form-control" accept="video/mp4,video/quicktime">
</div>

</div>

<button class="btn btn-primary">Save Purchase</button>

</form>

</div>

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