git.roojs.org Git - Pman.Xtuple/blob - VoidSalesAndPurchaseOrders.php

   1 <?php
   2 require_once 'Pman/Roo.php';
   3
   4 class Pman_Xtuple_VoidSalesAndPurchaseOrders extends Pman_Roo
   5 {
   6     function getAuth()
   7     {
   8         if (HTML_FlexyFramework::get()->cli) {
   9             return false;
  10         }
  11         return parent::getAuth();
  12     }
  13
  14     function get()
  15     {
  16         $cohead = DB_DataObject::factory('cohead');
  17         $cohead->whereAdd("
  18             cohead_status != 'X'
  19         ");
  20         $cohead->orderBy('cohead_id DESC');
  21         $cohead->find();
  22
  23         while ($cohead->fetch()){
  24             $co = clone ($cohead);
  25
  26             $cobmiscs = $co->cobmiscs();
  27
  28             foreach ($cobmiscs as $cobmisc){
  29                 $cobapply = DB_DataObject::factory('cobapply');
  30                 $cobapply->cobapply_cobmisc_id = $cobmisc->pid();
  31                 print_r($cobapply->count());exit;
  32                 if($cobapply->count()){
  33                     foreach($cobapply->fetchAll() as $coba){
  34
  35                         $coba->delete();
  36                         $coba->void($this);
  37
  38                         $checkitem = DB_DataObject::factory('checkitem');
  39                         $checkitem->autoJoin();
  40                         $checkitem->checkitem_aropen_id = $coba->cobapply_aropen_id;
  41                         $checkitem->whereAdd("
  42                             join_checkitem_checkhead_id_checkhead_id.checkhead_posted = TRUE
  43                             AND
  44                             join_checkitem_checkhead_id_checkhead_id.checkhead_void = FALSE
  45                             AND
  46                             join_checkitem_checkhead_id_checkhead_id.checkhead_deleted = FALSE
  47
  48                         ");
  49
  50                         foreach ($checkitem->fetchAll() as $checki){
  51                             $checkhead = $checki->checkhead();
  52                             $checkhead->voidPostedCheck($this);
  53                         }
  54                     }
  55                 }
  56
  57
  58             }
  59
  60
  61         }
  62     }
  63
  64
  65 }