View Code - 20260721

yarn_planner_helper.php | 20260721_154032.php Initial Bulk Import

<?php

function yarn_daily_requirement(PDO $pdo,int $cid){

$sql="
SELECT quality_id,COUNT(*) machines
FROM loom_quality_master
WHERE company_id=:cid
GROUP BY quality_id
";

$st=$pdo->prepare($sql);
$st->execute([':cid'=>$cid]);

$machines=$st->fetchAll(PDO::FETCH_KEY_PAIR);

$sql="
SELECT id,avg_per_day_pro
FROM qualities
WHERE company_id=:cid
";

$st=$pdo->prepare($sql);
$st->execute([':cid'=>$cid]);

$avg=$st->fetchAll(PDO::FETCH_KEY_PAIR);

$meter=[];

foreach($machines as $qid=>$m){

$meter[$qid]=$m*($avg[$qid]??0);

}

$sql="
SELECT loom_quality_id,yarn_name,gram_per_meter
FROM loom_quality_yarn_data
WHERE cid=:cid
";

$st=$pdo->prepare($sql);
$st->execute([':cid'=>$cid]);

$planner=[];

foreach($st->fetchAll(PDO::FETCH_ASSOC) as $r){

$qid=$r['loom_quality_id'];

if(!isset($meter[$qid])) continue;

$kg=($meter[$qid]*$r['gram_per_meter'])/1000;

$name=strtoupper(trim($r['yarn_name']));

preg_match('/(\d+[^ ]*)/',$name,$m);
$denier=$m[1]??'';

$parts=explode(' ',$name);
$color=end($parts);

$key=strtoupper($denier).'|'.strtoupper($color);

$planner[$key]['name']=$name;
$planner[$key]['req']=($planner[$key]['req']??0)+$kg;

}

return $planner;

}