« Back to History
karigar_name_swap.php
|
20260921_175631.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('karigar_name_swap'); $pdo = $ctx['pdo'] ?? null; $COMPANY_ID = (int)($ctx['company_id'] ?? 0); $USER_ID = (int)($ctx['user']['id'] ?? 0); if (!$pdo) require_once __DIR__ . '/core/db.php'; $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $ENTRY_TABLE = 'production_entry'; function jexit($arr,$code=200){ header('Content-Type: application/json; charset=utf-8'); http_response_code($code); echo json_encode($arr, JSON_UNESCAPED_UNICODE); exit; } function month_period_to_range($month,$period){ $parts = explode('-',$month); if(count($parts)!=2) return null; $y=intval($parts[0]); $m=intval($parts[1]); if($m<1||$m>12) return null; if($period==='H1'){ $from = sprintf('%04d-%02d-01',$y,$m); $to = sprintf('%04d-%02d-15',$y,$m); } else { $from = sprintf('%04d-%02d-16',$y,$m); $dim = (int)date('t', strtotime("$y-$m-01")); $to = sprintf('%04d-%02d-%02d',$y,$m,$dim); } return [$from,$to]; } function fetch_khata_by_code($pdo,$cid,$code){ $st=$pdo->prepare("SELECT id,code,machine_from,machine_to FROM khatas WHERE company_id=? AND code=? AND is_active=1 LIMIT 1"); $st->execute([$cid,$code]); return $st->fetch(PDO::FETCH_ASSOC); } /* ================= AJAX ================= */ $act=$_GET['act']??''; if($act){ switch($act){ case 'khata_list': $st=$pdo->prepare("SELECT code,machine_from,machine_to FROM khatas WHERE company_id=? AND is_active=1 ORDER BY code"); $st->execute([$COMPANY_ID]); jexit(['ok'=>true,'khatas'=>$st->fetchAll(PDO::FETCH_ASSOC)]); break; case 'khata_karigars': $kcode=$_GET['khata']??''; $kh=fetch_khata_by_code($pdo,$COMPANY_ID,$kcode); if(!$kh) jexit(['ok'=>false,'msg'=>'Khata not found'],404); $st=$pdo->prepare("SELECT id,karigar_name FROM loom_karigar_master WHERE company_id=? AND khata_id=? AND is_active=1 ORDER BY karigar_name"); $st->execute([$COMPANY_ID,$kh['id']]); jexit(['ok'=>true,'karigars'=>$st->fetchAll(PDO::FETCH_ASSOC)]); break; case 'summary': $kcode=$_GET['khata']??''; $machine=(int)($_GET['machine']??0); $month=$_GET['month']??''; $period=$_GET['period']??'H1'; $kh=fetch_khata_by_code($pdo,$COMPANY_ID,$kcode); if(!$kh) jexit(['ok'=>false,'msg'=>'Khata not found'],404); $rng=month_period_to_range($month,$period); if(!$rng) jexit(['ok'=>false,'msg'=>'Invalid range'],400); list($from,$to)=$rng; $q=$pdo->prepare("SELECT lines_json FROM {$ENTRY_TABLE} WHERE company_id=? AND khata_id=? AND machine_id=? AND entry_date BETWEEN ? AND ?"); $q->execute([$COMPANY_ID,$kh['id'],$machine,$from,$to]); $rows=$q->fetchAll(PDO::FETCH_ASSOC); $agg=[]; foreach($rows as $r){ $lines=json_decode($r['lines_json']??'[]',true); if(!is_array($lines)) continue; foreach($lines as $ln){ $kid=(int)($ln['karigar_id']??0); $m=floatval($ln['meter']??0); if($kid<=0) continue; if(!isset($agg[$kid])) $agg[$kid]=0; $agg[$kid]+=$m; } } $kar_ids=array_keys($agg); $kar_map=[]; if($kar_ids){ $place=implode(',',array_fill(0,count($kar_ids),'?')); $st=$pdo->prepare("SELECT id,karigar_name FROM loom_karigar_master WHERE company_id=? AND id IN ($place)"); $st->execute(array_merge([$COMPANY_ID],$kar_ids)); while($r=$st->fetch(PDO::FETCH_ASSOC)){ $kar_map[$r['id']]=$r['karigar_name']; } } $out=[]; foreach($agg as $kid=>$mtr){ $out[]=[ 'id'=>$kid, 'name'=>$kar_map[$kid]??"K#$kid", 'meter'=>round($mtr,2) ]; } usort($out,function($a,$b){ return $b['meter'] <=> $a['meter']; }); jexit(['ok'=>true,'summary'=>$out]); break; case 'preview': $in=json_decode(file_get_contents('php://input'),true); $kcode=$in['khata']; $machine=$in['machine']; $month=$in['month']; $period=$in['period']; $source=$in['source']; $kh=fetch_khata_by_code($pdo,$COMPANY_ID,$kcode); $rng=month_period_to_range($month,$period); list($from,$to)=$rng; $q=$pdo->prepare("SELECT lines_json FROM {$ENTRY_TABLE} WHERE company_id=? AND khata_id=? AND machine_id=? AND entry_date BETWEEN ? AND ?"); $q->execute([$COMPANY_ID,$kh['id'],$machine,$from,$to]); $rows=$q->fetchAll(PDO::FETCH_ASSOC); $count=0; foreach($rows as $r){ $lines=json_decode($r['lines_json']??'[]',true); foreach($lines as $ln){ if((int)$ln['karigar_id']==$source) $count++; } } jexit(['ok'=>true,'count'=>$count]); break; case 'apply': $in=json_decode(file_get_contents('php://input'),true); $kcode=$in['khata']; $machine=$in['machine']; $month=$in['month']; $period=$in['period']; $source=$in['source']; $target=$in['target']; $kh=fetch_khata_by_code($pdo,$COMPANY_ID,$kcode); $rng=month_period_to_range($month,$period); list($from,$to)=$rng; $pdo->beginTransaction(); $q=$pdo->prepare("SELECT id,lines_json FROM {$ENTRY_TABLE} WHERE company_id=? AND khata_id=? AND machine_id=? AND entry_date BETWEEN ? AND ? FOR UPDATE"); $q->execute([$COMPANY_ID,$kh['id'],$machine,$from,$to]); $rows=$q->fetchAll(PDO::FETCH_ASSOC); $total=0; foreach($rows as $r){ $lines=json_decode($r['lines_json']??'[]',true); $changed=false; foreach($lines as &$ln){ if((int)$ln['karigar_id']==$source){ $ln['karigar_id']=$target; $total++; $changed=true; } } unset($ln); if($changed){ $pdo->prepare("UPDATE {$ENTRY_TABLE} SET lines_json=?, updated_at=NOW() WHERE id=? AND company_id=?") ->execute([json_encode($lines),$r['id'],$COMPANY_ID]); } } $pdo->commit(); jexit(['ok'=>true,'total'=>$total]); break; } } /* ================= UI ================= */ require_once __DIR__ . '/partials/header.php'; ?> <div class="container-fluid py-3"> <div class="card shadow-sm"> <div class="card-header bg-light"> <h5 class="mb-0">Change Karigar (Bulk Reassign)</h5> </div> <div class="card-body"> <div class="row g-3 align-items-end"> <div class="col-md-3"> <label class="form-label">Khata</label> <select id="khata" class="form-select"></select> </div> <div class="col-md-2"> <label class="form-label">Machine</label> <select id="machine" class="form-select"></select> </div> <div class="col-md-2"> <label class="form-label">Month</label> <input type="month" id="month" class="form-control"> </div> <div class="col-md-2"> <label class="form-label">Period</label> <select id="period" class="form-select"> <option value="H1">H1</option> <option value="H2">H2</option> </select> </div> <div class="col-md-3"> <button id="btnLoad" class="btn btn-primary">Load</button> </div> </div> <hr> <div id="summaryWrap" class="row g-3"></div> </div> </div> </div> <!-- Modal --> <div class="modal fade" id="reassignModal"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title">Reassign Karigar</h5> <button type="button" class="btn-close" data-bs-dismiss="modal"></button> </div> <div class="modal-body"> <select id="targetSelect" class="form-select mb-3"></select> <div id="previewText" class="text-muted small"></div> </div> <div class="modal-footer"> <button class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button> <button id="confirmBtn" class="btn btn-primary">Confirm</button> </div> </div> </div> </div> <script> const $=id=>document.getElementById(id); let currentSource=null; async function fetchJSON(url,opt){ const r=await fetch(url,opt); return await r.json(); } async function loadKhatas(){ let j=await fetchJSON('?act=khata_list'); $('khata').innerHTML='<option value="">Select</option>'; j.khatas.forEach(k=>{ let o=document.createElement('option'); o.value=k.code; o.dataset.from=k.machine_from; o.dataset.to=k.machine_to; o.textContent=k.code; $('khata').appendChild(o); }); } loadKhatas(); $('khata').addEventListener('change',e=>{ let opt=e.target.selectedOptions[0]; $('machine').innerHTML=''; if(!opt) return; for(let i=opt.dataset.from;i<=opt.dataset.to;i++){ let o=document.createElement('option'); o.value=i; o.textContent=i; $('machine').appendChild(o); } }); $('btnLoad').onclick=async()=>{ let j=await fetchJSON(`?act=summary&khata=${$('khata').value}&machine=${$('machine').value}&month=${$('month').value}&period=${$('period').value}`); let wrap=$('summaryWrap'); wrap.innerHTML=''; j.summary.forEach(k=>{ let col=document.createElement('div'); col.className='col-md-3'; col.innerHTML=` <div class="card shadow-sm"> <div class="card-body"> <h6>${k.name}</h6> <div class="text-muted mb-2">${k.meter} mtr</div> <button class="btn btn-warning btn-sm" onclick="openModal(${k.id})">Reassign</button> </div> </div>`; wrap.appendChild(col); }); }; async function openModal(source){ currentSource=source; let kh=$('khata').value; let j=await fetchJSON(`?act=khata_karigars&khata=${kh}`); let sel=$('targetSelect'); sel.innerHTML=''; j.karigars.forEach(k=>{ if(k.id==source) return; let o=document.createElement('option'); o.value=k.id; o.textContent=k.karigar_name; sel.appendChild(o); }); new bootstrap.Modal(document.getElementById('reassignModal')).show(); } $('confirmBtn').onclick=async()=>{ let target=$('targetSelect').value; let kh=$('khata').value; let m=$('machine').value; let mo=$('month').value; let per=$('period').value; let preview=await fetchJSON('?act=preview',{ method:'POST', headers:{'Content-Type':'application/json'}, body:JSON.stringify({khata:kh,machine:m,month:mo,period:per,source:currentSource}) }); if(!confirm(preview.count+' lines will change. Proceed?')) return; let apply=await fetchJSON('?act=apply',{ method:'POST', headers:{'Content-Type':'application/json'}, body:JSON.stringify({khata:kh,machine:m,month:mo,period:per,source:currentSource,target:target}) }); alert('Changed lines: '+apply.total); bootstrap.Modal.getInstance(document.getElementById('reassignModal')).hide(); $('btnLoad').click(); }; </script> <?php require_once __DIR__ . '/partials/footer.php'; ?>