fmsystem-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Fmsystem-commits] [7280] Merge 7274:7279 from trunk


From: Sigurd Nes
Subject: [Fmsystem-commits] [7280] Merge 7274:7279 from trunk
Date: Tue, 10 May 2011 10:09:43 +0000

Revision: 7280
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7280
Author:   sigurdne
Date:     2011-05-10 10:09:42 +0000 (Tue, 10 May 2011)
Log Message:
-----------
Merge 7274:7279 from trunk

Modified Paths:
--------------
    branches/Version-1_0-branch/activitycalendar/inc/class.soactivity.inc.php
    branches/Version-1_0-branch/activitycalendar/inc/class.uiactivities.inc.php
    branches/Version-1_0-branch/activitycalendar/inc/class.uiimport.inc.php
    
branches/Version-1_0-branch/activitycalendar/inc/model/class.activity.inc.php
    branches/Version-1_0-branch/activitycalendar/setup/phpgw_no.lang
    branches/Version-1_0-branch/activitycalendar/templates/base/activity.php
    branches/Version-1_0-branch/property/inc/class.sogeneric.inc.php

Property Changed:
----------------
    branches/Version-1_0-branch/


Property changes on: branches/Version-1_0-branch
___________________________________________________________________
Modified: svn:mergeinfo
   - 
/trunk:6439-6441,6443,6445-6447,6449-6464,6466-6468,6470-6474,6476-6477,6479-6480,6483-6488,6490-6491,6493-6494,6496-6501,6503-6504,6506,6508,6510-6511,6513,6515-6516,6518,6520-6524,6526-6528,6533-6534,6536-6541,6543-6565,6567,6569,6571-6576,6578,6580-6586,6588-6596,6598-6600,6602-6604,6606-6607,6609-6611,6613-6625,6629-6639,6641-6643,6645-6646,6648,6650-6654,6656-6659,6661-6663,6665-6666,6668-6669,6672-6673,6675,6677-6678,6680,6682-6686,6688-6717,6719,6721-6722,6724-6728,6730,6732-6734,6736-6739,6741,6743,6745-6746,6748-6756,6758-6762,6764,6766-6788,6790,6792-6798,6800-6814,6816-6819,6821-6822,6824-6826,6828-6837,6839,6841,6843-6849,6851,6853-6869,6871-6874,6876-6877,6879,6881,6883,6885-6886,6888-6893,6895-6897,6899-6901,6903,6905-6907,6909,6911-6929,6931-6936,6938-6947,6949,6951,6953,6955-6956,6958-6959,6961-6968,6970-6971,6973-6974,6976-6978,6980,6982-7017,7019-7025,7027-7035,7037-7039,7041-7045,7047-7055,7057,7059-7065,7067-7069,7071,7073,7075-7076,7078,7080-7081,7083,7085,7087,7089-7097,7099-7102,7104-7105,7107-7111,7113-7120,7122-7124,7126-7129,7131,7133-7141,7143,7145-7146,7148-7150,7152-7153,7155-7158,7160-7164,7166-7167,7169-7170,7172,7174,7176,7178,7180-7181,7183,7185,7187-7188,7190,7192-7196,7198-7199,7201-7203,7205,7207,7209-7210,7212,7214,7216-7217,7219-7222,7224-7226,7228-7229,7231,7233-7234,7236-7238,7240-7241,7243-7244,7246,7248,7250,7252-7256,7258-7259,7261-7264,7266-7273
   + 
/trunk:6439-6441,6443,6445-6447,6449-6464,6466-6468,6470-6474,6476-6477,6479-6480,6483-6488,6490-6491,6493-6494,6496-6501,6503-6504,6506,6508,6510-6511,6513,6515-6516,6518,6520-6524,6526-6528,6533-6534,6536-6541,6543-6565,6567,6569,6571-6576,6578,6580-6586,6588-6596,6598-6600,6602-6604,6606-6607,6609-6611,6613-6625,6629-6639,6641-6643,6645-6646,6648,6650-6654,6656-6659,6661-6663,6665-6666,6668-6669,6672-6673,6675,6677-6678,6680,6682-6686,6688-6717,6719,6721-6722,6724-6728,6730,6732-6734,6736-6739,6741,6743,6745-6746,6748-6756,6758-6762,6764,6766-6788,6790,6792-6798,6800-6814,6816-6819,6821-6822,6824-6826,6828-6837,6839,6841,6843-6849,6851,6853-6869,6871-6874,6876-6877,6879,6881,6883,6885-6886,6888-6893,6895-6897,6899-6901,6903,6905-6907,6909,6911-6929,6931-6936,6938-6947,6949,6951,6953,6955-6956,6958-6959,6961-6968,6970-6971,6973-6974,6976-6978,6980,6982-7017,7019-7025,7027-7035,7037-7039,7041-7045,7047-7055,7057,7059-7065,7067-7069,7071,7073,7075-7076,7078,7080-7081,7083,7085,7087,7089-7097,7099-7102,7104-7105,7107-7111,7113-7120,7122-7124,7126-7129,7131,7133-7141,7143,7145-7146,7148-7150,7152-7153,7155-7158,7160-7164,7166-7167,7169-7170,7172,7174,7176,7178,7180-7181,7183,7185,7187-7188,7190,7192-7196,7198-7199,7201-7203,7205,7207,7209-7210,7212,7214,7216-7217,7219-7222,7224-7226,7228-7229,7231,7233-7234,7236-7238,7240-7241,7243-7244,7246,7248,7250,7252-7256,7258-7259,7261-7264,7266-7273,7275-7279

Modified: 
branches/Version-1_0-branch/activitycalendar/inc/class.soactivity.inc.php
===================================================================
--- branches/Version-1_0-branch/activitycalendar/inc/class.soactivity.inc.php   
2011-05-10 08:57:32 UTC (rev 7279)
+++ branches/Version-1_0-branch/activitycalendar/inc/class.soactivity.inc.php   
2011-05-10 10:09:42 UTC (rev 7280)
@@ -151,6 +151,7 @@
                        $columns[] = 'activity.organization_id';
                        $columns[] = 'activity.group_id';
                        $columns[] = 'activity.district';
+                       $columns[] = 'activity.office';
                        $columns[] = 'activity.state';
                        $columns[] = 'activity.category';
                        $columns[] = 'activity.target';
@@ -218,6 +219,7 @@
                        'organization_id = '. 
$this->marshal($activity->get_organization_id(), 'int'),
                        'group_id = '     . 
$this->marshal($activity->get_group_id(), 'int'),
                        'district =  '     . 
$this->marshal($activity->get_district(), 'int'),
+                       'office =  '     . 
$this->marshal($activity->get_office(), 'int'),
                        'category = '          . 
$this->marshal($activity->get_category(), 'int'),
                        'state = '          . 
$this->marshal($activity->get_state(), 'int'),
                        'target = '   . $this->marshal($activity->get_target(), 
'string'),
@@ -263,6 +265,7 @@
                        
$activity->set_organization_id($this->unmarshal($this->db->f('organization_id'),
 'int'));
                        
$activity->set_group_id($this->unmarshal($this->db->f('group_id'), 'int'));
                        
$activity->set_district($this->unmarshal($this->db->f('district'), 'int'));
+                       
$activity->set_office($this->unmarshal($this->db->f('office'), 'int'));
                        
$activity->set_category($this->unmarshal($this->db->f('category'), 'int'));
                        
$activity->set_state($this->unmarshal($this->db->f('state'), 'int'));
                        
$activity->set_target($this->unmarshal($this->db->f('target'), 'string'));
@@ -320,6 +323,15 @@
                return $district;
        }
        
+       function get_district_from_name($name)
+       {
+               $this->db->query("SELECT district_id FROM fm_part_of_town where 
name like UPPER('%{$name}%') ", __LINE__, __FILE__);
+               while($this->db->next_record()){
+                       $result = $this->db->f('district_id');
+               }       
+               return $result;
+       }
+       
        function get_district_name($district_id)
        {
                $result = "Ingen";
@@ -334,7 +346,21 @@
                return $result;
        }
        
+       function get_office_name($district_id)
+       {
+               $result = "Ingen";
+               if($district_id != null)
+               {
+                       $sql = "SELECT descr FROM fm_district where 
id=$district_id";
+                       $this->db->query($sql, __LINE__, __FILE__);
+                       while($this->db->next_record()){
+                               $result = $this->db->f('descr');
+                       }
+       }
+               return $result;
+       }
        
+       
        function get_target_name($target_id)
        {
                $result = "Ingen";

Modified: 
branches/Version-1_0-branch/activitycalendar/inc/class.uiactivities.inc.php
===================================================================
--- branches/Version-1_0-branch/activitycalendar/inc/class.uiactivities.inc.php 
2011-05-10 08:57:32 UTC (rev 7279)
+++ branches/Version-1_0-branch/activitycalendar/inc/class.uiactivities.inc.php 
2011-05-10 10:09:42 UTC (rev 7280)
@@ -73,6 +73,7 @@
                
                $categories = 
activitycalendar_soactivity::get_instance()->get_categories();
                $targets = 
activitycalendar_soactivity::get_instance()->get_targets();
+               $offices = 
activitycalendar_soactivity::get_instance()->select_district_list();
                $districts = 
activitycalendar_soactivity::get_instance()->select_district_list();
                                
                // Retrieve the arena object or create a new one
@@ -108,6 +109,7 @@
                                
$activity->set_group_id(phpgw::get_var('group_id'));
                                
$activity->set_arena(phpgw::get_var('arena_id'));
                                
$activity->set_district(phpgw::get_var('district'));
+                               $activity->set_office(phpgw::get_var('office'));
                                $activity->set_state(phpgw::get_var('state'));
                                
$activity->set_category(phpgw::get_var('category'));
                                $target_array = phpgw::get_var('target');
@@ -137,6 +139,7 @@
                                'categories' => $categories,
                                'targets' => $targets,
                                'districts' => $districts,
+                               'offices' => $offices,
                                'editable' => true,
                                'message' => isset($message) ? $message : 
phpgw::get_var('message'),
                                'error' => isset($error) ? $error : 
phpgw::get_var('error')

Modified: 
branches/Version-1_0-branch/activitycalendar/inc/class.uiimport.inc.php
===================================================================
--- branches/Version-1_0-branch/activitycalendar/inc/class.uiimport.inc.php     
2011-05-10 08:57:32 UTC (rev 7279)
+++ branches/Version-1_0-branch/activitycalendar/inc/class.uiimport.inc.php     
2011-05-10 10:09:42 UTC (rev 7280)
@@ -65,9 +65,9 @@
                        {
                                // Get the path for user input or use a default 
path
                                $this->path = phpgw::get_var("import_path") ? 
phpgw::get_var("import_path") : '/home/notroot/FacilitExport';
-                               $this->district = phpgw::get_var("district") ? 
phpgw::get_var("district") : '1';
+                               $this->office = phpgw::get_var("district") ? 
phpgw::get_var("district") : '1';
                                phpgwapi_cache::session_set('activitycalendar', 
'import_path', $this->path);
-                               phpgwapi_cache::session_set('activitycalendar', 
'import_district', $this->district);
+                               phpgwapi_cache::session_set('activitycalendar', 
'import_district', $this->office);
                                $GLOBALS['phpgw']->redirect_link('/index.php', 
array('menuaction' => 'activitycalendar.uiimport.index', 'importstep' => 
'true'));
                        } 
                        else if(phpgw::get_var("importstep"))
@@ -77,7 +77,7 @@
                                echo "<h3>Import started at: {$start}</h3>";
                                echo "<ul>";
                                $this->path = 
phpgwapi_cache::session_get('activitycalendar', 'import_path') . '/aktiviteter';
-                               $this->district = 
phpgwapi_cache::session_get('activitycalendar', 'import_district');
+                               $this->office = 
phpgwapi_cache::session_get('activitycalendar', 'import_district');
                                //$this->path = 
'/home/notroot/FacilitExport/aktiviteter';
                                
                                $result = $this->import(); // Do import step, 
result determines if finished for this area
@@ -175,7 +175,7 @@
                        return '1';
                }
                
-               protected function import_arenas($office)
+               protected function import_arenas()
                {
                        $start_time = time();
                        
@@ -268,7 +268,11 @@
                                                $activity_updated_date = 
strtotime($y."-".$m."-".$d);
                                        }
                                }
-                               //$activity_district = $this->decode($data[21]);
+                               $activity_district = $this->decode($data[21]);
+                               if($activity_district)
+                               {
+                                       $activity_district = 
$soactivity->get_district_from_name($activity_district);
+                               }
                                
                                if($activity_title){
                                        $activity->set_title($activity_title);
@@ -282,7 +286,8 @@
                                        {
                                                
$activity->set_special_adaptation(true);
                                        }
-                                       
$activity->set_district($this->district);
+                                       $activity->set_office($this->office);
+                                       
$activity->set_district($activity_district);
                                        
$activity->set_last_change_date($activity_updated_date);
                                        //var_dump($activity);
                                        // All is good, store activity

Modified: 
branches/Version-1_0-branch/activitycalendar/inc/model/class.activity.inc.php
===================================================================
--- 
branches/Version-1_0-branch/activitycalendar/inc/model/class.activity.inc.php   
    2011-05-10 08:57:32 UTC (rev 7279)
+++ 
branches/Version-1_0-branch/activitycalendar/inc/model/class.activity.inc.php   
    2011-05-10 10:09:42 UTC (rev 7280)
@@ -14,6 +14,7 @@
                protected $organization_id;
                protected $group_id;
                protected $district;
+               protected $office;
                protected $category;
                protected $state;
                protected $target;
@@ -72,6 +73,13 @@
                
                public function get_district() { return $this->district; }
                
+               public function set_office($office)
+               {
+                       $this->office = $office;
+               }
+               
+               public function get_office() { return $this->office; }
+               
                public function set_target($target)
                {
                        $this->target = $target;
@@ -211,6 +219,7 @@
                                'organization_id' => 
activitycalendar_soorganization::get_instance()->get_organization_name($this->get_organization_id()),
                                'group_id' => 
activitycalendar_sogroup::get_instance()->get_group_name($this->get_group_id()),
                                'district' => 
activitycalendar_soactivity::get_instance()->get_district_name($this->get_district()),
+                               'office' => 
activitycalendar_soactivity::get_instance()->get_office_name($this->get_office()),
                                'category' => 
$this->get_so()->get_category_name($this->get_category()),
                                'state' => lang('state_'.$this->get_state()),
                                'description' => $this->get_description(),

Modified: branches/Version-1_0-branch/activitycalendar/setup/phpgw_no.lang
===================================================================
--- branches/Version-1_0-branch/activitycalendar/setup/phpgw_no.lang    
2011-05-10 08:57:32 UTC (rev 7279)
+++ branches/Version-1_0-branch/activitycalendar/setup/phpgw_no.lang    
2011-05-10 10:09:42 UTC (rev 7280)
@@ -369,4 +369,5 @@
 state_3        activitycalendar        no      Akseptert
 state_4        activitycalendar        no      Behandlet
 state_5        activitycalendar        no      Avvist
-activity_import        activitycalendar        no      Importer aktiviteter
\ No newline at end of file
+activity_import        activitycalendar        no      Importer aktiviteter
+office activitycalendar        no      Kontor
\ No newline at end of file

Modified: 
branches/Version-1_0-branch/activitycalendar/templates/base/activity.php
===================================================================
--- branches/Version-1_0-branch/activitycalendar/templates/base/activity.php    
2011-05-10 08:57:32 UTC (rev 7279)
+++ branches/Version-1_0-branch/activitycalendar/templates/base/activity.php    
2011-05-10 10:09:42 UTC (rev 7280)
@@ -222,22 +222,22 @@
                                        ?>
                                </dd>
                                <dt>
-                                       <?php if($activity->get_district() || 
$editable) { ?>
-                                       <label for="district"><?php echo 
lang('district') ?></label>
+                                       <?php if($activity->get_office() || 
$editable) { ?>
+                                       <label for="office"><?php echo 
lang('office') ?></label>
                                        <?php  } ?>
                                </dt>
                                <dd>
                                        <?php
                                        if ($editable)
                                        {
-                                               $selected_district = 
$activity->get_district();
+                                               $selected_office = 
$activity->get_office();
                                        ?>
-                                               <select name="district">
-                                                       <option value="0">Ingen 
bydel valgt</option>
+                                               <select name="office">
+                                                       <option value="0">Ingen 
kontor valgt</option>
                                                        <?php
-                                                       foreach($districts as 
$district)
+                                                       foreach($offices as 
$office)
                                                        {
-                                                               echo "<option 
".($selected_district == $district['id'] ? 'selected="selected"' : "")." 
value=\"{$district['id']}\">".$district['name']."</option>";
+                                                               echo "<option 
".($selected_office == $office['id'] ? 'selected="selected"' : "")." 
value=\"{$office['id']}\">".$office['name']."</option>";
                                                        }
                                                        ?>
                                                </select>

Modified: branches/Version-1_0-branch/property/inc/class.sogeneric.inc.php
===================================================================
--- branches/Version-1_0-branch/property/inc/class.sogeneric.inc.php    
2011-05-10 08:57:32 UTC (rev 7279)
+++ branches/Version-1_0-branch/property/inc/class.sogeneric.inc.php    
2011-05-10 10:09:42 UTC (rev 7280)
@@ -2130,7 +2130,7 @@
 
                        $fields = implode(',', $fields);
 
-                       $this->_db->query("SELECT id, {$fields} FROM {$table} 
{$filtermthod} {$ordermethod}");
+                       $this->_db->query("SELECT 
{$this->location_info['id']['name']} as id, {$fields} FROM {$table} 
{$filtermthod} {$ordermethod}");
 
                        $return_fields = isset($data['fields']) && 
$data['fields'] && is_array($data['fields']) ? $data['fields'] : array();
                        




reply via email to

[Prev in Thread] Current Thread [Next in Thread]