[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [6494] Property: list projects and orders by sub-cate
From: |
Sigurd Nes |
Subject: |
[Fmsystem-commits] [6494] Property: list projects and orders by sub-categories, add title to order list within project |
Date: |
Mon, 18 Oct 2010 13:39:58 +0000 |
Revision: 6494
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6494
Author: sigurdne
Date: 2010-10-18 13:39:55 +0000 (Mon, 18 Oct 2010)
Log Message:
-----------
Property: list projects and orders by sub-categories, add title to order list
within project
Modified Paths:
--------------
trunk/property/inc/class.boproject.inc.php
trunk/property/inc/class.soproject.inc.php
trunk/property/inc/class.soworkorder.inc.php
trunk/property/inc/class.uiproject.inc.php
trunk/property/js/yahoo/project.edit.js
Modified: trunk/property/inc/class.boproject.inc.php
===================================================================
--- trunk/property/inc/class.boproject.inc.php 2010-10-18 08:06:49 UTC (rev
6493)
+++ trunk/property/inc/class.boproject.inc.php 2010-10-18 13:39:55 UTC (rev
6494)
@@ -402,6 +402,7 @@
$sum_workorder_calculation=
$sum_workorder_calculation+$workorder_data[$i]['calculation'];
$sum_workorder_actual_cost=
$sum_workorder_actual_cost+$workorder_data[$i]['act_mtrl_cost']+$workorder_data[$i]['act_vendor_cost'];
+
$values['workorder_budget'][$i]['title']=$workorder_data[$i]['title'];
$values['workorder_budget'][$i]['workorder_id']=$workorder_data[$i]['workorder_id'];
$values['workorder_budget'][$i]['budget']=number_format($workorder_data[$i]['budget'],
2, ',', '');
$values['workorder_budget'][$i]['calculation']=number_format($workorder_data[$i]['calculation']*$tax,
2, ',', '');
Modified: trunk/property/inc/class.soproject.inc.php
===================================================================
--- trunk/property/inc/class.soproject.inc.php 2010-10-18 08:06:49 UTC (rev
6493)
+++ trunk/property/inc/class.soproject.inc.php 2010-10-18 13:39:55 UTC (rev
6494)
@@ -107,7 +107,7 @@
$query = (isset($data['query'])?$data['query']:'');
$sort = (isset($data['sort'])?$data['sort']:'DESC');
$order = (isset($data['order'])?$data['order']:'');
- $cat_id = (isset($data['cat_id'])?$data['cat_id']:0);
+ $cat_id = isset($data['cat_id']) && $data['cat_id'] ?
$data['cat_id'] : 0;
$status_id =
(isset($data['status_id'])?$data['status_id']:'');
$start_date = isset($data['start_date']) &&
$data['start_date'] ? (int)$data['start_date'] : 0;
$end_date = isset($data['end_date']) &&
$data['end_date'] ? (int)$data['end_date'] : 0;
@@ -338,7 +338,16 @@
if ($cat_id > 0)
{
- $filtermethod .= " $where
fm_project.category=$cat_id ";
+ $cats = CreateObject('phpgwapi.categories',
-1, 'property', '.project');
+ $cats->supress_info = true;
+ $cat_list_project =
$cats->return_sorted_array(0,$limit = false,$query = '',$sort = '',$order =
'',$globals = False, $parent_id = $cat_id, $use_acl = false);
+ $cat_filter = array($cat_id);
+ foreach ($cat_list_project as $_category)
+ {
+ $cat_filter[] = $_category['id'];
+ }
+ $filtermethod .= " {$where} fm_project.category
IN (" . implode(',', $cat_filter) .')';
+
$where= 'AND';
}
@@ -601,13 +610,14 @@
{
$project_id = (int) $project_id;
$budget = array();
- $this->db->query("SELECT act_mtrl_cost,
act_vendor_cost, budget, fm_workorder.id as workorder_id,"
+ $this->db->query("SELECT fm_workorder.title,
act_mtrl_cost, act_vendor_cost, budget, fm_workorder.id as workorder_id,"
." vendor_id,
calculation,rig_addition,addition,deviation,charge_tenant,fm_workorder_status.descr
as status, fm_workorder.account_id as b_account_id"
." FROM fm_workorder $this->join fm_workorder_status ON
fm_workorder.status = fm_workorder_status.id WHERE project_id={$project_id}");
while ($this->db->next_record())
{
$budget[] = array(
'workorder_id' =>
$this->db->f('workorder_id'),
+ 'title' =>
$this->db->f('title',true),
'budget' =>
(int)$this->db->f('budget'),
'deviation' =>
$this->db->f('deviation'),
'calculation' =>
$this->db->f('calculation'),
Modified: trunk/property/inc/class.soworkorder.inc.php
===================================================================
--- trunk/property/inc/class.soworkorder.inc.php 2010-10-18 08:06:49 UTC
(rev 6493)
+++ trunk/property/inc/class.soworkorder.inc.php 2010-10-18 13:39:55 UTC
(rev 6494)
@@ -368,7 +368,16 @@
if ($cat_id > 0)
{
- $filtermethod .= " $where
fm_project.category=$cat_id ";
+ $cats = CreateObject('phpgwapi.categories',
-1, 'property', '.project');
+ $cats->supress_info = true;
+ $cat_list_project =
$cats->return_sorted_array(0,$limit = false,$query = '',$sort = '',$order =
'',$globals = False, $parent_id = $cat_id, $use_acl = false);
+ $cat_filter = array($cat_id);
+ foreach ($cat_list_project as $_category)
+ {
+ $cat_filter[] = $_category['id'];
+ }
+ $filtermethod .= " {$where} fm_project.category
IN (" . implode(',', $cat_filter) .')';
+
$where= 'AND';
}
Modified: trunk/property/inc/class.uiproject.inc.php
===================================================================
--- trunk/property/inc/class.uiproject.inc.php 2010-10-18 08:06:49 UTC (rev
6493)
+++ trunk/property/inc/class.uiproject.inc.php 2010-10-18 13:39:55 UTC (rev
6494)
@@ -1260,6 +1260,7 @@
$table_header_workorder_budget[] = array
(
'lang_workorder_id' => lang('Workorder'),
+ 'lang_title' => lang('title'),
'lang_budget' => lang('Budget'),
'lang_calculation' => lang('Calculation'),
'lang_vendor' => lang('Vendor'),
@@ -1489,6 +1490,7 @@
(
'name' => "0",
'values' => json_encode(array(
array('key' =>
'workorder_id','label'=>lang('Workorder'),'sortable'=>true,'resizeable'=>true,'formatter'=>'YAHOO.widget.DataTable.formatLink'),
+
array('key' =>
'title','label'=>lang('title'),'sortable'=>true,'resizeable'=>true),
array('key' => 'b_account_id','label'=>lang('Budget
account'),'sortable'=>true,'resizeable'=>true,'formatter'=>'FormatterRight'),
array('key' =>
'budget','label'=>lang('Budget'),'sortable'=>true,'resizeable'=>true,'formatter'=>'FormatterRight'),
array('key' =>
'calculation','label'=>lang('Calculation'),'sortable'=>true,'resizeable'=>true,'formatter'=>'FormatterRight'),
Modified: trunk/property/js/yahoo/project.edit.js
===================================================================
--- trunk/property/js/yahoo/project.edit.js 2010-10-18 08:06:49 UTC (rev
6493)
+++ trunk/property/js/yahoo/project.edit.js 2010-10-18 13:39:55 UTC (rev
6494)
@@ -23,7 +23,7 @@
{
//call getSumPerPage(name of column) in property.js
tmp_sum1 = getSumPerPage('budget',2,paginator,datatable);
- tmp_sum2 = getSumPerPage('calculation',2,paginator,datatable);
+ tmp_sum2 = getSumPerPage('calculation',2,paginator,datatable);
tmp_sum3 = getSumPerPage('actual_cost',2,paginator,datatable);
if(typeof(tableYUI)=='undefined')
@@ -40,9 +40,9 @@
newTR = document.createElement('tr');
td_sum('Sum');
- td_empty(1);
+ td_empty(2);
td_sum(tmp_sum1);
- td_sum(tmp_sum2);
+ td_sum(tmp_sum2);
td_sum(tmp_sum3);
td_empty(3);
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [6494] Property: list projects and orders by sub-categories, add title to order list within project,
Sigurd Nes <=