« Back to History
yarn_in_last_entry.php
|
20260723_000646.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__.'/../modules/auth/page_acl.php'; $ctx = page_require_access('yarn_in_boxwise'); $pdo = $ctx['pdo']; $cid = (int)$ctx['company_id']; $e=$pdo->query(" SELECT entry_id, MAX(txn_date) dt, COUNT(*) boxes, SUM(weight) weight FROM yarn_in_boxwise WHERE company_id=$cid GROUP BY entry_id ORDER BY entry_id DESC LIMIT 1 ")->fetch(PDO::FETCH_ASSOC); $it=$pdo->prepare("SELECT box_no, weight FROM yarn_in_boxwise WHERE company_id=? AND entry_id=?"); $it->execute([$cid,$e['entry_id']]); echo json_encode([ 'summary'=>$e, 'items'=>$it->fetchAll(PDO::FETCH_ASSOC) ]);