[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [17229] prepare for custom code outside tree
From: |
sigurdne |
Subject: |
[Fmsystem-commits] [17229] prepare for custom code outside tree |
Date: |
Wed, 1 Nov 2017 14:51:13 -0400 (EDT) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [17229] prepare for custom code outside tree,
sigurdne <=