View Code - 20260721

taka_next.php | 20260721_154032.php Initial Bulk Import

<?php
/* ============================================================
   NEXT TAKA NO (last + 1) — uses machine_id ONLY
   ============================================================ */
header('Content-Type: application/json; charset=utf-8');
ini_set('display_errors','0'); error_reporting(EALL);

require __DIR__ . '/../modules/auth/auth.php';
require_login();
$u=auth_user(); $company_id=(int)$u['company_id'];

try{
  if(!isset($GLOBALS['pdo']) || !$GLOBALS['pdo']) require __DIR__ . '/../core/db.php';
  /** @var PDO $pdo */ $pdo=$GLOBALS['pdo']; $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

$machine_id = isset($_GET['machine_id']) ? (int)$_GET['machine_id'] : 0; // loom no.
  $khata_id   = isset($_GET['khata_id'])   ? (int)$_GET['khata_id']   : 0;
  if($machine_id<=0 || $khata_id<=0){ echo json_encode(['ok'=>false,'msg'=>'Missing params']); exit; }

$q=$pdo->prepare("SELECT COALESCE(MAX(taka_no),0)
                      FROM loom_production_entry
                     WHERE company_id=? AND khata_id=? AND machine_id=?");
  $q->execute([$company_id,$khata_id,$machine_id]);
  $last=(int)$q->fetchColumn();

echo json_encode(['ok'=>true,'next_taka_no'=>$last+1]);
}catch(Throwable $e){
  http_response_code(500); echo json_encode(['ok'=>false,'msg'=>'Server error','detail'=>$e->getMessage()]);
}