Esempio n. 1
0
 function buildReport($args)
 {
     // $MFWorkorders, $data, $bulk=true) {
     // specify default args
     $default_args = array('bulk' => TRUE);
     // build args from merged args + defaults
     $args = array_merge($default_args, $args);
     // make sure required items have been set
     if (!isset($args['model']) || !isset($args['data'])) {
         return FALSE;
     }
     // set a few vars
     $MFWorkorders = $args['model'];
     $data = $args['data'];
     $bulk = $args['bulk'];
     $dynamic_limit = 30;
     // must be even
     $pages = 1;
     $cases;
     $pallets;
     $extra = array();
     if ($MFWorkorders->order_qty != '' && $bulk == true) {
         $st_uom_conversion = new STuomconversion();
         $st_uom = new STuom();
         $cases = $MFWorkorders->order_qty;
         // get the id of each uom we need
         $uom_pallet_id = $st_uom->getUomID('pallet');
         $uom_case_id = $st_uom->getUomID('case');
         $pallets = ceil($st_uom_conversion->convertFrom($MFWorkorders->stitem_id, $uom_case_id, $uom_pallet_id, $MFWorkorders->order_qty));
         $pages = ceil($pallets / $dynamic_limit);
         if ($pages == 0) {
             $pages = 1;
         }
     } else {
         $cases = '';
         $pallets = '';
         // fire report with single page
     }
     $extra['cases'] = $cases;
     $extra['pallets'] = $pallets;
     // get stitem item_code
     $stitem = new STItem();
     $stitem->load($MFWorkorders->stitem_id);
     $extra['item_code'] = $stitem->item_code;
     // construct the lines
     $row_count = $dynamic_limit / 2;
     /*
      * $p = page
      * $r = row
      */
     for ($p = 0; $p < $pages; $p++) {
         $start_value = $dynamic_limit * $p + 1;
         for ($r = 0; $r < $row_count; $r++) {
             if ($bulk == true) {
                 $field1 = $r + $start_value;
                 $field2 = $r + $start_value + $row_count;
             } else {
                 $field1 = '-';
                 $field2 = '-';
             }
             $extra['pages'][$p]['page'][$r]['line'] = array('field1' => $field1, 'field2' => $field2);
         }
     }
     // construct filler xml to prevent repeating xsl
     $dummy_tables = array('table_1' => 9, 'table_2' => 6, 'table_3' => 2);
     foreach ($dummy_tables as $table => $rows) {
         for ($i = 0; $i < $rows; $i++) {
             $extra[$table][]['line'] = '';
         }
     }
     // generate the XML, include the extras array too
     $xml = $this->controller->generateXML(array('model' => $MFWorkorders, 'extra' => $extra));
     // build a basic list of options
     $options = array('report' => 'MF_PCMCOrderForm', 'xmlSource' => $xml);
     if (isset($args['merge_file_name'])) {
         $options['merge_file_name'] = $args['merge_file_name'];
     }
     return json_decode($this->controller->generate_output($data, $options));
 }