VoidSalesAndPurchaseOrders.php

[Pman.Xtuple] / VoidSalesAndPurchaseOrders.php

<?php
require_once 'Pman/Roo.php';

class Pman_Xtuple_VoidSalesAndPurchaseOrders extends Pman_Roo
{   
    static $cli_desc = "Void ALL the Sales Orders / Vouchers / Purchase Orders - Make Sure you know what is going to do!!!";
    
    static $cli_opts = array(
        'confirm' => array(
            'desc' => 'Confirm',
            'default' => '',
            'short' => 'f',
            'min' => 0,
            'max' => 1,
        )
    );
    
    function getAuth()
    {
        if (HTML_FlexyFramework::get()->cli) {
            return true;
        }
        
        return false;
    }
   
    function get($v = '', $opts)
    {
        if(empty($opts['confirm']) || $opts['confirm'] !== 'I am sure to void all things'){
            $this->jerr("If you know what is going to do, try -f 'I am sure to void all things'");
        }
        
        $this->transObj = DB_DataObject::Factory('cohead');
        
        $this->transObj->query('BEGIN');
        
        PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
        
        DB_DataObject::factory('cohead')->lockTables();
        
        $cohead = DB_DataObject::factory('cohead');
        $cohead->whereAdd("
            cohead_status != 'X'
        ");
        $cohead->find();
        
        while ($cohead->fetch()){
            $this->log("Voiding Sales Order : {$cohead->cohead_number}");
            
            $cohead->clear($this);
        }
        
        
        $pohead = DB_DataObject::factory('pohead');
        $pohead->find();
        
        while ($pohead->fetch()){
            $po = clone ($pohead);
            $po->clear($this);
        }
        
        
        $this->jerr('DONE');
        exit;
    }
    
    function log($str)
    {
        echo "$str \n";
    }
        
}