20 lines
3.2 KiB
PHP
20 lines
3.2 KiB
PHP
<?php
|
|
$book=$argv[1]??'regression';require __DIR__.'/sgf-single-bootstrap.php';
|
|
$input=json_decode(file_get_contents($s['root'].'/single-stock-lot-input.json'),true);$scope=$f['scope'];
|
|
$native->transaction(function()use($native,$input,$scope){
|
|
$meta=['created_by'=>4,'reason'=>'Recorte QA de lotes aprovado expressamente em10/11/2026.','created_at'=>now()];
|
|
$book=$native->table('gl_stock_books')->where($scope)->where(['stock_item_id'=>$input['stock_item'],'warehouse_id'=>$input['warehouse']])->first();
|
|
if(!$book)$native->table('gl_stock_books')->insert($scope+$meta+['stock_item_id'=>$input['stock_item'],'warehouse_id'=>$input['warehouse'],'unit_code'=>'UN','period_key'=>'QA-2026-INTEGRADO']);
|
|
$expense=$native->table('gl_accounts')->where($scope)->where('code','QA-DIFERENCA-INVENTARIO')->value('id');if(!$expense)$expense=$native->table('gl_accounts')->insertGetId($scope+['code'=>'QA-DIFERENCA-INVENTARIO','label'=>'Diferença de inventário exclusivamente QA','currency'=>'MZN','is_movement'=>true]);
|
|
if(!$native->table('gl_rules')->where($scope)->where('rule_key','stock.adjustment')->exists())$native->table('gl_rules')->insert($scope+$meta+['rule_key'=>'stock.adjustment','effect_type'=>'stock.adjustment','version'=>1,'policy'=>'QA-STOCK-VALUATION-v1','currency'=>'MZN','valid_from'=>'2026-01-01','valid_to'=>'2026-12-31','debit_account_id'=>$expense,'credit_account_id'=>$native->table('gl_accounts')->where($scope)->where('code','QA-STOCK')->value('id')]);
|
|
$definition=$native->selectOne("SELECT pg_get_functiondef('gl_stock_journal_assert()'::regprocedure) body")->body;
|
|
if(!str_contains($definition,"WHEN 'stock.adjustment'")){
|
|
$pairs=["WHEN 'stock.return' THEN ARRAY['QA-STOCK','QA-CONSUMO-STOCK']"=>"WHEN 'stock.return' THEN ARRAY['QA-STOCK','QA-CONSUMO-STOCK'] WHEN 'stock.adjustment' THEN ARRAY['QA-DIFERENCA-INVENTARIO','QA-STOCK']", "WHEN 'stock.return' THEN 'workshop_return_in'"=>"WHEN 'stock.return' THEN 'workshop_return_in' WHEN 'stock.adjustment' THEN 'adjustment_out'"];
|
|
foreach($pairs as $from=>$to){if(substr_count($definition,$from)!==1)throw new LogicException('Preserve unfamiliar stock journal guard');$definition=str_replace($from,$to,$definition);}$native->unprepared($definition);
|
|
}
|
|
$native->statement("CREATE UNIQUE INDEX IF NOT EXISTS gl_stock_movement_once_final ON gl_journals(tenant_id,(snapshot->'source'->>'stock_movement_id')) WHERE snapshot->'source'->>'effect_type' IN('stock.receipt','stock.issue','stock.return','stock.adjustment')");
|
|
});
|
|
$path=$s['root'].'/single-material-perimeter.json';$p=json_decode(file_get_contents($path),true);copy($path,$work.'/material-perimeter-before.json');
|
|
$p['valued_stock']=$native->table('gl_stock_books')->where($scope)->orderBy('id')->get(['stock_item_id','warehouse_id'])->map(fn($r)=>(array)$r)->all();$p['extension_reason']='Novo artigo de lotes aprovado individualmente, distinto de materiais directos e industriais.';file_put_contents($path,json_encode($p,JSON_PRETTY_PRINT));
|
|
echo json_encode(['passed'=>true,'book'=>$book,'new_qa_account'=>'QA-DIFERENCA-INVENTARIO','new_qa_rule'=>'stock.adjustment','journal_count'=>$native->table('gl_journals')->count(),'existing_journals_not_rewritten'=>true]).PHP_EOL;
|