/**
  * Get a static reference to the storage object associated with this model object
  * 
  * @return the storage object
  */
 public static function get_instance()
 {
     if (self::$so == null) {
         self::$so = CreateObject('rental.sobilling_info');
     }
     return self::$so;
 }
Ejemplo n.º 2
0
 public function download_export()
 {
     if (!$this->isExecutiveOfficer()) {
         $this->render('permission_denied.php');
         return;
     }
     //$browser = CreateObject('phpgwapi.browser');
     //$browser->content_header('export.txt','text/plain');
     $stop = phpgw::get_var('date');
     $cs15 = phpgw::get_var('generate_cs15');
     $toExcel = phpgw::get_var('toExcel');
     if ($cs15 == null) {
         if ($toExcel == null) {
             $export_format = explode('_', phpgw::get_var('export_format'));
             $file_ending = $export_format[1];
             if ($file_ending == 'gl07') {
                 $type = 'intern';
             } else {
                 if ($file_ending == 'lg04') {
                     $type = 'faktura';
                 }
             }
             $date = date('Ymd', $stop);
             header('Content-type: text/plain');
             header("Content-Disposition: attachment; filename=PE_{$type}_{$date}.{$file_ending}");
             $id = phpgw::get_var('id');
             $path = "/rental/billings/{$id}";
             $vfs = CreateObject('phpgwapi.vfs');
             $vfs->override_acl = 1;
             print $vfs->read(array('string' => $path, RELATIVE_NONE));
             //print rental_sobilling::get_instance()->get_export_data((int)phpgw::get_var('id'));
         } else {
             $billing_job = rental_sobilling::get_instance()->get_single((int) phpgw::get_var('id'));
             $billing_info_array = rental_sobilling_info::get_instance()->get(null, null, null, null, null, null, array('billing_id' => phpgw::get_var('id')));
             $type = phpgw::get_var('type', 'string', 'GET', 'bk');
             if ($billing_job == null) {
                 $errorMsgs[] = lang('Could not find specified billing job.');
             } else {
                 //Loop through  billing info array to find the first month
                 $month = 12;
                 foreach ($billing_info_array as $billing_info) {
                     $year = $billing_info->get_year();
                     if ($month > $billing_info->get_month()) {
                         $month = $billing_info->get_month();
                     }
                 }
                 $billing_job->set_year($year);
                 $billing_job->set_month($month);
                 $list = rental_sobilling::get_instance()->generate_export($billing_job, $type);
                 //_debug_array($list[0]);
                 /*foreach ($list as $l)
                   {
                       _debug_array($l);
                   }*/
                 if (isset($list)) {
                     $infoMsgs[] = lang('Export generated.');
                     $keys = array();
                     if (count($list[0]) > 0) {
                         foreach ($list[0] as $key => $value) {
                             if (!is_array($value)) {
                                 array_push($keys, $key);
                             }
                         }
                     }
                     // Remove newlines from output
                     //                                    $count = count($list);
                     //                                    for($i = 0; $i < $count; $i++)
                     //                                    {
                     //                                        foreach ($list[$i] as $key => &$data)
                     //                                        {
                     //                                                $data = str_replace(array("\n","\r\n", "<br>"),'',$data);
                     //                                        }
                     //                                    }
                     // Use keys as headings
                     $headings = array();
                     $count_keys = count($keys);
                     for ($j = 0; $j < $count_keys; $j++) {
                         array_push($headings, lang($keys[$j]));
                     }
                     //                                    _debug_array($list);
                     $property_common = CreateObject('property.bocommon');
                     $property_common->download($list, $keys, $headings);
                 } else {
                     $errorMsgs = lang('Export failed.');
                 }
             }
         }
     } else {
         $file_ending = 'cs15';
         $type = 'kundefil';
         $date = date('Ymd', $stop);
         header('Content-type: text/plain');
         header("Content-Disposition: attachment; filename=PE_{$type}_{$date}.{$file_ending}");
         print rental_sobilling::get_instance()->generate_customer_export((int) phpgw::get_var('id'));
     }
 }
Ejemplo n.º 3
0
 public function create_billing(int $decimals, int $contract_type, int $billing_term, int $year, int $month, $title, int $created_by, array $contracts_to_bill, array $contracts_overriding_billing_start, string $export_format, int $existing_billing, array $contracts_bill_only_one_time)
 {
     if ($contracts_overriding_billing_start == null) {
         $contracts_overriding_billing_start = array();
     }
     if ($contracts_bill_only_one_time == null) {
         $contracts_bill_only_one_time = array();
     }
     // We start a transaction before running the billing
     $this->db->transaction_begin();
     if ($existing_billing < 1) {
         //new billing
         $billing = new rental_billing(-1, $contract_type, $title, $created_by);
         // The billing job itself
         $billing->set_timestamp_start(time());
         // Start of run
         $billing->set_export_format($export_format);
         $billing->set_title($title);
         $this->store($billing);
         // Store job as it is
         $billing_end_timestamp = strtotime('-1 day', strtotime(($month == 12 ? $year + 1 : $year) . '-' . ($month == 12 ? '01' : $month + 1) . '-01'));
         // Last day of billing period is the last day of the month we're billing
         $counter = 0;
         $total_sum = 0;
     } else {
         $billing = $this->get_single($existing_billing);
         $billing_end_timestamp = strtotime('-1 day', strtotime(($month == 12 ? $year + 1 : $year) . '-' . ($month == 12 ? '01' : $month + 1) . '-01'));
         // Last day of billing period is the last day of the month we're billing
         $total_sum = $billing->get_total_sum();
     }
     $billing_info = new rental_billing_info(null, $billing->get_id(), $contract_type, $billing_term, $year, $month);
     $res = rental_sobilling_info::get_instance()->store($billing_info);
     // Get the number of months in selected term for contract
     $months = rental_socontract::get_instance()->get_months_in_term($billing_term);
     // The billing should start from the first date of the periode (term) we're billing for
     $first_day_of_selected_month = strtotime($year . '-' . $month . '-01');
     $bill_from_timestamp = strtotime('-' . ($months - 1) . ' month', $first_day_of_selected_month);
     foreach ($contracts_to_bill as $contract_id) {
         $invoice = rental_invoice::create_invoice($decimals, $billing->get_id(), $contract_id, in_array($contract_id, $contracts_overriding_billing_start) ? true : false, $bill_from_timestamp, $billing_end_timestamp, in_array($contract_id, $contracts_bill_only_one_time) ? true : false, false, $billing_term);
         // Creates an invoice of the contract
         if ($invoice != null) {
             $total_sum += $invoice->get_total_sum();
         }
     }
     $billing->set_total_sum(round($total_sum, $decimals));
     $billing->set_timestamp_stop(time());
     //  End of run
     $billing->set_success(true);
     // Billing job is a success
     $this->store($billing);
     // Store job now that we're done
     // End of transaction!
     if ($this->db->transaction_commit()) {
         return $billing;
     }
     throw new UnexpectedValueException('Transaction failed.');
 }