View Code - 20260723

kasab_out_add.php | 20260723_000646.php Initial Domain Snapshot

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

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

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

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

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

$roll_type = $_POST['roll_type'];
$color     = $_POST['color'];
$rolls     = (int)$_POST['rolls'];
$weight    = (float)$_POST['weight'];
$assign_id = (int)$_POST['employee_id'];
$date      = $_POST['entry_date'];
$remark    = $_POST['remark'];

/* ===== STOCK CHECK ===== */

$check = $pdo->prepare("

SELECT
SUM(CASE WHEN txn_type='IN' THEN rolls ELSE -rolls END) stock_rolls,
SUM(CASE WHEN txn_type='IN' THEN weight ELSE -weight END) stock_weight

FROM kasab_stock_txn

WHERE company_id=:cid
AND roll_type=:rt
AND color=:clr

");

$check->execute([
':cid'=>$company_id,
':rt'=>$roll_type,
':clr'=>$color
]);

$stock = $check->fetch(PDO::FETCH_ASSOC);

if($rolls > $stock['stock_rolls'] || $weight > $stock['stock_weight']){

echo "<div class='alert alert-danger'>Stock Not Available</div>";

}else{

$ins = $pdo->prepare("

INSERT INTO kasab_stock_txn
(company_id,txn_type,roll_type,color,rolls,weight,entry_date,employee_id,remark)

VALUES
(:cid,'OUT',:rt,:clr,:rolls,:weight,:dt,:emp,:remark)

");

$ins->execute([

':cid'=>$company_id,
':rt'=>$roll_type,
':clr'=>$color,
':rolls'=>$rolls,
':weight'=>$weight,
':dt'=>$date,
':emp'=>$assign_id,
':remark'=>$remark

]);

echo "<div class='alert alert-success'>OUT Entry Saved</div>";

}

/* ================= STOCK LIST ================= */

$sql="

SELECT
roll_type,
color,

SUM(CASE WHEN txn_type='IN' THEN rolls ELSE -rolls END) stock_rolls,
SUM(CASE WHEN txn_type='IN' THEN weight ELSE -weight END) stock_weight

FROM kasab_stock_txn

WHERE company_id=:cid

GROUP BY roll_type,color
HAVING stock_rolls>0

ORDER BY roll_type,color

$stmt=$pdo->prepare($sql);
$stmt->execute([':cid'=>$company_id]);
$stocks=$stmt->fetchAll(PDO::FETCH_ASSOC);

/* ================= ASSIGN LIST ================= */

$a=$pdo->prepare("

SELECT id,assign_name
FROM assign_master
WHERE company_id=:cid
AND is_active=1
ORDER BY assign_name

");

$a->execute([':cid'=>$company_id]);
$assigns=$a->fetchAll(PDO::FETCH_ASSOC);

Kasab OUT Entry

</div>

<?php foreach($stocks as $s): ?>

<?=$s['roll_type']?>

</option>

<?php endforeach; ?>

</select>

</div>

<label>Color</label>

<?php foreach($stocks as $s): ?>

<?=$s['color']?>

</option>

<?php endforeach; ?>

</select>

</div>

<label>Rolls</label>

</div>

<label>Weight</label>

</div>

</div>

<label>Assign</label>

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

<?php foreach($assigns as $as): ?>

<?=$as['assign_name']?>

</option>

<?php endforeach; ?>

</select>

</div>

<label>Remark</label>

</div>

Save OUT Entry

</button>

</div>

</form>

</div>
</div>

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