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

[sigurdne]

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

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

Copied: 
thirdparty/PE_custom/BK_EBF/property/inc/cron/default/update_googlemap.php 
(from rev 17218, trunk/property/inc/cron/default/update_googlemap.php)
===================================================================
--- thirdparty/PE_custom/BK_EBF/property/inc/cron/default/update_googlemap.php  
                        (rev 0)
+++ thirdparty/PE_custom/BK_EBF/property/inc/cron/default/update_googlemap.php  
2017-11-01 18:51:12 UTC (rev 17229)
@@ -0,0 +1,67 @@
+<?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 custom
+        * @version $Id$
+        */
+       /**
+        * Description
+        * @package property
+        */
+       include_class('property', 'cron_parent', 'inc/cron/');
+
+       class update_googlemap extends property_cron_parent
+       {
+
+               public function __construct()
+               {
+                       parent::__construct();
+
+                       $this->function_name = get_class($this);
+                       $this->sub_location = lang('location');
+                       $this->function_msg = 'update googlemap';
+
+                       $this->bocommon = CreateObject('property.bocommon');
+                       $this->db2 = clone($this->db);
+               }
+
+               function execute()
+               {
+                       $fieldname = 'googlemap';
+                       $area = "Bergen";
+                       $sql = "SELECT 
fm_location4.location_code,fm_location4.loc1,fm_location4.loc2,fm_location4.loc3,fm_location4.loc4,"
+                               . " fm_location1.loc1_name,fm_tenant.id as 
tenant_id,fm_tenant.last_name,fm_tenant.first_name,fm_tenant.contact_phone,fm_streetaddress.descr
 as 
street_name,street_number,fm_location4.street_id,fm_location4.etasje,fm_location4.antallrom,fm_location4.boareal"
+                               . " FROM ((((((( fm_location4 JOIN fm_location3 
ON (fm_location4.loc3 = fm_location3.loc3) AND (fm_location4.loc2 = 
fm_location3.loc2) AND (fm_location4.loc1 = fm_location3.loc1)) JOIN 
fm_location2 ON (fm_location3.loc2 = fm_location2.loc2) AND (fm_location3.loc1 
= fm_location2.loc1)) JOIN fm_location1 ON (fm_location2.loc1 = 
fm_location1.loc1)) JOIN fm_owner ON ( fm_location1.owner_id=fm_owner.id)) JOIN 
fm_part_of_town ON ( fm_location1.part_of_town_id=fm_part_of_town.id)) JOIN 
fm_streetaddress ON ( fm_location4.street_id=fm_streetaddress.id)) JOIN 
fm_tenant ON ( fm_location4.tenant_id=fm_tenant.id)) WHERE 
(fm_location4.category !=99 OR fm_location4.category IS NULL) AND 
driftsstatus_id > 0 ";
+
+                       $this->db->query($sql, __LINE__, __FILE__);
+
+                       while ($this->db->next_record())
+                       {
+                               $sql2 = "UPDATE fm_location4 SET $fieldname 
='http://maps.google.no/maps?&q=$area,"; . $this->db->f('street_name') . ',' . 
$this->db->f('street_number') . "' WHERE location_code = '" . 
$this->db->f('location_code') . "'";
+//_debug_array($sql2);
+                               $this->db2->query($sql2, __LINE__, __FILE__);
+                       }
+               }
+       }
\ No newline at end of file


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