[Fmsystem-commits] [17223] prepare for custom code outside tree

[sigurdne]

Revision: 17223
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=17223
Author:   sigurdne
Date:     2017-11-01 14:47:56 -0400 (Wed, 01 Nov 2017)
Log Message:
-----------
prepare for custom code outside tree

Added Paths:
-----------
    
thirdparty/PE_custom/BK_EBF/property/inc/cron/default/oppdater_betalte_faktura_BK.php

Copied: 
thirdparty/PE_custom/BK_EBF/property/inc/cron/default/oppdater_betalte_faktura_BK.php
 (from rev 17218, 
trunk/property/inc/cron/default/oppdater_betalte_faktura_BK.php)
===================================================================
--- 
thirdparty/PE_custom/BK_EBF/property/inc/cron/default/oppdater_betalte_faktura_BK.php
                               (rev 0)
+++ 
thirdparty/PE_custom/BK_EBF/property/inc/cron/default/oppdater_betalte_faktura_BK.php
       2017-11-01 18:47:56 UTC (rev 17223)
@@ -0,0 +1,243 @@
+<?php
+       /**
+        * phpGroupWare - property: a Facilities Management System.
+        *
+        * @author Sigurd Nes <address@hidden>
+        * @copyright Copyright (C) 2003,2004,2005,2006,2007 Free Software 
Foundation, Inc. http://www.fsf.org/
+        * This file is part of phpGroupWare.
+        *
+        * phpGroupWare is free software; you can redistribute it and/or modify
+        * it under the terms of the GNU General Public License as published by
+        * the Free Software Foundation; either version 2 of the License, or
+        * (at your option) any later version.
+        *
+        * phpGroupWare is distributed in the hope that it will be useful,
+        * but WITHOUT ANY WARRANTY; without even the implied warranty of
+        * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+        * GNU General Public License for more details.
+        *
+        * You should have received a copy of the GNU General Public License
+        * along with phpGroupWare; if not, write to the Free Software
+        * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  
02110-1301  USA
+        *
+        * @license http://www.gnu.org/licenses/gpl.html GNU General Public 
License
+        * @internal Development of this application was funded by 
http://www.bergen.kommune.no/bbb_/ekstern/
+        * @package property
+        * @subpackage cron
+        * @version $Id: oppdater_betalte_faktura_BK.php 16075 2016-12-12 
15:26:41Z sigurdne $
+        */
+       /**
+        * Description
+        * example cron : /usr/local/bin/php -q 
/var/www/html/phpgroupware/property/inc/cron/cron.php default 
oppdater_betalte_faktura_BK
+        * @package property
+        */
+       include_class('property', 'cron_parent', 'inc/cron/');
+       phpgw::import_class('phpgwapi.datetime');
+
+       class oppdater_betalte_faktura_BK extends property_cron_parent
+       {
+
+               public function __construct()
+               {
+                       parent::__construct();
+
+                       $this->function_name = get_class($this);
+                       $this->sub_location = lang('property');
+                       $this->function_msg = 'oppdater bestillinger med 
grunnlag i betalte faktura';
+                       /**
+                        * Bruker konffigurasjon fra '.ticket' - fordi denne 
definerer oppslaget mot fullmaktsregisteret ved bestilling.
+                        */
+                       $config                                 = 
CreateObject('admin.soconfig', $GLOBALS['phpgw']->locations->get_id('property', 
'.ticket'));
+                       $this->soap_url                 = 
$config->config_data['external_register']['url'];
+                       $this->soap_username    = 
$config->config_data['external_register']['username'];
+                       $this->soap_password    = 
$config->config_data['external_register']['password'];
+               }
+
+               function execute()
+               {
+                       $start = time();
+
+                       //curl -s -u portico:BgPor790gfol 
http://tjenester.usrv.ubergenkom.no/api/agresso/art
+                       //curl -s -u portico:BgPor790gfol 
http://tjenester.usrv.ubergenkom.no/api/agresso/ansvar?id=013000
+                       //curl -s -u portico:BgPor790gfol 
http://tjenester.usrv.ubergenkom.no/api/agresso/objekt?id=5001
+                       //curl -s -u portico:BgPor790gfol 
http://tjenester.usrv.ubergenkom.no/api/agresso/prosjekt?id=5001
+                       //curl -s -u portico:BgPor790gfol 
http://tjenester.usrv.ubergenkom.no/api/agresso/tjeneste?id=88010
+
+                       //curl -s -u portico:BgPor790gfol 
http://tjenester.usrv.ubergenkom.no/api/agresso/leverandorer?leverandorNr=722920
+                       if ($this->debug)
+                       {
+                       }
+                       set_time_limit(2000);
+
+                       try
+                       {
+                               $this->update_order();
+                       }
+                       catch (Exception $e)
+                       {
+                               $this->receipt['error'][] = array('msg' => 
$e->getMessage());
+                       }
+
+                       $msg = 'Tidsbruk: ' . (time() - $start) . ' sekunder';
+                       $this->cron_log($msg, $cron);
+                       echo "$msg\n";
+                       $this->receipt['message'][] = array('msg' => $msg);
+
+               }
+
+               function cron_log( $receipt = '' )
+               {
+
+                       $insert_values = array(
+                               $this->cron,
+                               date($this->db->datetime_format()),
+                               $this->function_name,
+                               $receipt
+                       );
+
+                       $insert_values = 
$this->db->validate_insert($insert_values);
+
+                       $sql = "INSERT INTO fm_cron_log 
(cron,cron_date,process,message) "
+                               . "VALUES ($insert_values)";
+                       $this->db->query($sql, __LINE__, __FILE__);
+               }
+
+               private function update_order()
+               {
+                       $config = CreateObject('phpgwapi.config', 
'property')->read();
+                       $sql = "SELECT DISTINCT pmwrkord_code, 
external_voucher_id FROM fm_ecobilag";
+                       $this->db->query($sql, __LINE__, __FILE__);
+                       $vouchers = array();
+                       while ($this->db->next_record())
+                       {
+                               $vouchers[] = array
+                               (
+                                       'order_id' => 
$this->db->f('pmwrkord_code'),
+                                       'voucher_id' => 
$this->db->f('external_voucher_id')
+                               );
+                       }
+
+                       $socommon = CreateObject('property.socommon');
+                       $soworkorder = CreateObject('property.soworkorder');
+                       $sotts = CreateObject('property.sotts');
+                       $workorder_closed_status = 
!empty($config['workorder_closed_status']) ? $config['workorder_closed_status'] 
: false;
+
+                       if(!$workorder_closed_status)
+                       {
+                               throw new Exception('Order closed status not 
defined');
+                       }
+
+                       $vouchers_ok = array();
+                       foreach ($vouchers as $voucher)
+                       {
+                               
if(!$this->check_payment($voucher['voucher_id']))
+                               {
+                                       $this->receipt['error'][] = array('msg' 
=> "{$voucher['voucher_id']} er ikke betalt");
+                                       continue;
+                               }
+
+                               $this->receipt['message'][] = array('msg' => 
"{$voucher['voucher_id']} er betalt");
+
+                               $ok = false;
+                               $order_type = 
$socommon->get_order_type($voucher['order_id']);
+                               switch ($order_type)
+                               {
+                                       case 's_agreement':
+                                               break;
+                                       case 'workorder':
+                                               $workorder = 
$soworkorder->read_single($voucher['order_id']);
+                                               if($workorder['continuous'])
+                                               {
+                                                       $ok = true;
+                                               }
+                                               else
+                                               {
+                                                       $ok = 
$soworkorder->update_status(array('order_id' => $voucher['order_id'],'status' 
=> $workorder_closed_status));
+                                               }
+                                               break;
+                                       case 'ticket':
+                                               $this->db->query("SELECT id, 
continuous FROM fm_tts_tickets WHERE order_id= '{$voucher['order_id']}'", 
__LINE__, __FILE__);
+                                               $this->db->next_record();
+                                               $ticket_id = $this->db->f('id');
+
+                                               if($this->db->f('continuous'))
+                                               {
+                                                       $ok = true;
+                                               }
+                                               else
+                                               {
+                                                       $ticket = array(
+                                                                       
'status' => 'C8' //Avsluttet og fakturert (C)
+                                                               );
+                                                       $ok = 
$sotts->update_status($ticket, $ticket_id);
+                                               }
+                                               break;
+                                       default:
+                                               throw new Exception('Order type 
not supported');
+                               }
+
+                               if($ok)
+                               {
+                                       $vouchers_ok[] = $voucher;
+                               //      $i = 60;
+                               }
+
+                       }
+                       unset($voucher);
+
+                       $metadata = $this->db->metadata('fm_ecobilag');
+                       $cols = array_keys($metadata);
+                       foreach ($vouchers_ok as $voucher)
+                       {
+                               $this->db->transaction_begin();
+                               $value_set = array();
+                               $this->db->query("SELECT * FROM fm_ecobilag 
WHERE external_voucher_id= '{$voucher['voucher_id']}'", __LINE__, __FILE__);
+                               $this->db->next_record();
+                               foreach ($cols as $col)
+                               {
+                                       $value_set[$col] = $this->db->f($col);
+                               }
+                               $value_set['filnavn'] = date('d.m.Y-H:i:s', 
phpgwapi_datetime::user_localtime());
+                               $value_set['ordrebelop'] = $value_set['belop'];
+                               unset($value_set['pre_transfer']);
+
+                               $_cols = implode(',', array_keys($value_set));
+                               $values = 
$this->db->validate_insert(array_values($value_set));
+                               $this->db->query("INSERT INTO fm_ecobilagoverf 
({$_cols}) VALUES ({$values})", __LINE__, __FILE__);
+                               $this->db->query("DELETE FROM fm_ecobilag WHERE 
external_voucher_id= '{$voucher['voucher_id']}'", __LINE__, __FILE__);
+                               $this->db->transaction_commit();
+                               $this->receipt['message'][] = array('msg' => 
"{$voucher['voucher_id']} er overført til historikk");
+                       }
+               }
+
+               function check_payment( $voucher_id )
+               {
+                       //curl -s -u portico:BgPor790gfol 
http://tjenester.usrv.ubergenkom.no/api/agresso/utlignetfaktura?bilagsNr=917039148
+                       $url = 
"{$this->soap_url}/utlignetfaktura?bilagsNr={$voucher_id}";
+                       $username       = $this->soap_username; //'portico';
+                       $password       = $this->soap_password; 
//'BgPor790gfol';
+
+                       $ch = curl_init();
+                       curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 30);
+                       curl_setopt($ch, CURLOPT_URL, $url);
+                       curl_setopt($ch, CURLOPT_USERPWD, 
"{$username}:{$password}");
+                       curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
+                       curl_setopt($ch, CURLOPT_HTTPHEADER, array( 
'Content-Type: application/json'));
+                       curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
+
+                       $result = curl_exec($ch);
+
+                       $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
+                       if(!$httpCode)
+                       {
+                               throw new Exception("No connection: {$url}");
+                       }
+                       curl_close($ch);
+
+                       $result = json_decode($result, true);
+
+                       return $result;
+
+               }
+
+       }


Property changes on: 
thirdparty/PE_custom/BK_EBF/property/inc/cron/default/oppdater_betalte_faktura_BK.php
___________________________________________________________________
Added: svn:mergeinfo
## -0,0 +1,3 ##
+/branches/dev-syncromind/property/inc/cron/default/oppdater_betalte_faktura_BK.php:13653
+/branches/dev-syncromind-2/property/inc/cron/default/oppdater_betalte_faktura_BK.php:14933-16846
+/branches/stavangerkommune/property/inc/cron/default/oppdater_betalte_faktura_BK.php:12743-12875,12986
\ No newline at end of property