<?php

/**
 * fill in any fifo basic entries that have not been processed..
 * -- does not fill in values.. - just qty's
 *
 */
require_once 'ProcessBase.php';
 
class Pman_Xtuple_Fifo_ProcessCoheadVoids extends Pman_Xtuple_Fifo_ProcessBase
{
     static $cli_desc = "Flag voids for coheads.";
   
    static $permitError = false;
    
   
    function get()
    {
        // set up the failure code..
        PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
        
        // we have to have a pointer to work out where we left off..
        // this process can go by invdetail_id ASC..
        
        $co = DB_DataObject::Factory('invfifo');
        
        $co->selecTAdd();
        $co->selecTAdd('distinct(invfifo_cohead_id) as cohead_id');
        $co->whereAdd('
                        invfifo_void = -1
                    AND
                        invfifo_cohead_id > 0
                       ');
        $locs = $co->fetchAll('cohead_id');
        print_R($locs);
        if (!$locs) {
            die("no changed needed\n");
            return;
        }
            $co = DB_DataObject::Factory('invfifo');
            
            $co->query('
                update
                    invfifo
                set
                    invfifo_void = 0
                WHERE
                    invfifo_cohead_id IN (
                        ' . implode(',', $locs) .'
                    )
                '); 
            
            
            //$id = DB_DataObject::Factory('cohead');
            //$id->query('SELECT invfifo_cohead_void_flag_order(cohead_id) FROM cohead where cohead_id IN ( 
            //             ' . implode(',', $locs) .'
            //        )
            //    ');
            //   
            
        
        
        
       
        
         
        
        $tot = count($locs);

        foreach($locs as $n=>$cohead_id) {
        
            $id = DB_DataObject::Factory('invdetail');
            $id->query("SELECT invfifo_cohead_void_flag_order($cohead_id)");
            $id->free();
            usleep(10);
            if (!($n % 50)) {
                sleep(5);
                echo "$n/$tot\n";
            }
            
        }
        
        die("DONE\n");

         
   
    }
     
}