[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] property/inc/class.sopricebook.inc.php, 1.2
|
From: |
nomail |
|
Subject: |
[Phpgroupware-cvs] property/inc/class.sopricebook.inc.php, 1.2 |
|
Date: |
Wed, 2 Jun 2004 20:54:28 +0200 |
Update of /property/inc
Added Files:
Branch:
class.sopricebook.inc.php
date: 2004/06/02 18:54:28; author: sigurdne; state: Exp; lines: +753 -0
Log Message:
no message
=====================================================================
<?php
/**************************************************************************\
* phpGroupWare - property
*
* http://www.phpgroupware.org
*
*
*
* Facilities Management
*
* Written by Sigurd Nes [sigurdne at online.no]
*
*
------------------------------------------------------------------------ *
* Copyright 2000 - 2003 Free Software Foundation, Inc
*
* This program is part of the GNU project, see http://www.gnu.org/
*
*
------------------------------------------------------------------------ *
* This program 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.
*
\**************************************************************************/
class sopricebook
{
function sopricebook()
{
$this->currentapp =
$GLOBALS['phpgw_info']['flags']['currentapp'];
$this->db = $GLOBALS['phpgw']->db;
$this->db2 = $this->db;
$this->account =
$GLOBALS['phpgw_info']['user']['account_id'];
$this->socommon =
CreateObject($this->currentapp.'.socommon');
$this->join = $this->socommon->join;
}
function
add_activity_first_prize($m_cost,$w_cost,$total_cost,$activity_id,$vendor_id,$date)
{
$this->db->query("update fm_activity_price_index set
index_count='1',this_index='1',
m_cost='$m_cost',w_cost='$w_cost',total_cost='$total_cost',date='$date',current_index='1'
where activity_id='$activity_id' and vendor_id= '$vendor_id' and index_count=
'1'",__LINE__,__FILE__);
$receipt['message'][] = array('msg'=>lang('First entry
is added!'));
return $receipt;
}
function update_pricebook($update)
{
for ($i=0; $i<count($update); $i++)
{
$this->db->query("select max(index_count) as
max_index_count from fm_activity_price_index Where activity_id='".
$update[$i]['activity_id'] . "' and vendor_id='".$update[$i]['vendor_id'] .
"'",__LINE__,__FILE__);
$this->db->next_record();
$next_index_count =
$this->db->f('max_index_count')+1;
$this->db->query("update
fm_activity_price_index set current_index = Null"
. " WHERE activity_id='" .
$update[$i]['activity_id'] . "' and vendor_id='" . $update[$i]['vendor_id'] .
"'",__LINE__,__FILE__);
$this->db->query("insert into
fm_activity_price_index (activity_id, vendor_id, index_count, this_index,
m_cost, w_cost, total_cost, date,current_index) "
. " values ('" .
$update[$i]['activity_id'] . "','" .
$update[$i]['vendor_id'] . "','" .
$next_index_count . "','" .
$update[$i]['new_index'] . "','" .
$update[$i]['new_m_cost'] . "','" .
$update[$i]['new_w_cost'] . "','" .
$update[$i]['new_total_cost'] . "','" .
$update[$i]['new_date']. "',
'1')",__LINE__,__FILE__);
}
$receipt['message'][] = array('msg'=>lang('%1 entries
is updated!',$i));
return $receipt;
}
function get_vendor_list()
{
$this->db->query("SELECT fm_vendor.org_name ,vendor_id "
. " FROM (fm_activities $this->join
fm_activity_price_index ON fm_activities.id =
fm_activity_price_index.activity_id) $this->join fm_vendor ON
fm_activity_price_index.vendor_id = fm_vendor.id "
. " GROUP by fm_vendor.org_name ,vendor_id "
. " ORDER BY fm_vendor.org_name ");
while ($this->db->next_record())
{
//--------->fix this------->
if($this->db->f('vendor_id'))
{
$vendor_list[]=array
(
'id' =>
$this->db->f('vendor_id'),
'name' =>
$this->db->f('org_name')
);
}
}
return $vendor_list;
}
function get_agreement_list()
{
$this->db->query("SELECT * FROM fm_agreement ORDER BY
descr asc");
while ($this->db->next_record())
{
$agreement_list[]=array
(
'id' => $this->db->f('id'),
'name' =>
$GLOBALS['phpgw']->strip_html($this->db->f('descr')).' [ '.
$GLOBALS['phpgw']->strip_html($this->db->f('status')).' ] '
);
}
return $agreement_list;
}
function get_dim_d_list()
{
$this->db->query("SELECT * FROM fm_dim_d ORDER BY descr
asc");
while ($this->db->next_record())
{
$dim_d_list[]=array
(
'id' => $this->db->f('id'),
'name' => $this->db->f('id')
);
}
return $dim_d_list;
}
function get_unit_list()
{
$this->db->query("SELECT * FROM fm_standard_unit ORDER
BY descr asc");
while ($this->db->next_record())
{
$unit_list[]=array
(
'id' => $this->db->f('id'),
'name' =>
$GLOBALS['phpgw']->strip_html($this->db->f('descr'))
);
}
return $unit_list;
}
function get_branch_list()
{
$this->db->query("SELECT * FROM fm_branch ORDER BY
descr asc");
while ($this->db->next_record())
{
$branch_list[]=array
(
'id' => $this->db->f('id'),
'name' =>
$GLOBALS['phpgw']->strip_html($this->db->f('descr'))
);
}
return $branch_list;
}
function check_activity_num($num='',$agreement_id='')
{
$this->db->query("SELECT count(*) FROM fm_activities
where num='$num' and agreement_id ='$agreement_id'");
$this->db->next_record();
if ( $this->db->f(0))
{
return True;
}
}
function check_agreement_num($num='')
{
$this->db->query("SELECT count(*) FROM fm_agreement
where num='$num'");
$this->db->next_record();
if ( $this->db->f(0))
{
return True;
}
}
function read($data)
{
if(is_array($data))
{
if ($data['start'])
{
$start=$data['start'];
}
else
{
$start=0;
}
$filter =
(isset($data['filter'])?$data['filter']:'none');
$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);
$allrows =
(isset($data['allrows'])?$data['allrows']:'');
}
//_debug_array($data);
if ($order)
{
$ordermethod = " order by $order $sort";
}
else
{
$ordermethod = ' order by
fm_vendor.org_name,activity_id';
}
if ($cat_id > 0)
{
$filtermethod .= " AND cat_id='$cat_id' ";
$vendor_condition= "= $cat_id";
}
else
{
$vendor_condition= " IS NULL";
}
if($query)
{
$query = ereg_replace("'",'',$query);
$query = ereg_replace('"','',$query);
$querymethod = " AND (fm_activities.descr LIKE
'%$query%' or fm_activities.num LIKE '%$query%')";
}
$sql = "SELECT
fm_activities.num,fm_activities.unit,fm_activities.dim_d,fm_activities.ns3420,fm_activities.descr
as descr, fm_activities.base_descr,activity_id,
fm_vendor.org_name,fm_branch.descr as branch
,vendor_id,total_cost,m_cost,w_cost,index_count,fm_activity_price_index.this_index
"
. " FROM (fm_activities $this->join
fm_activity_price_index ON fm_activities.id =
fm_activity_price_index.activity_id) $this->join fm_vendor ON
fm_activity_price_index.vendor_id = fm_vendor.id "
. " $this->join fm_branch ON
fm_activities.branch_id = fm_branch.id "
. " WHERE (vendor_id $vendor_condition and
current_index is not null "
. " OR (fm_activity_price_index.vendor_id
$vendor_condition) AND (fm_activity_price_index.this_index IS NULL))
$querymethod";
$this->db2->query($sql,__LINE__,__FILE__);
$this->total_records = $this->db2->num_rows();
if(!$allrows)
{
$this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
}
else
{
$this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
}
while ($this->db->next_record())
{
$pricebook[] = array
(
'activity_id' =>
$this->db->f('activity_id'),
'num' =>
$this->db->f('num'),
'branch' =>
$this->db->f('branch'),
'vendor_id' =>
$this->db->f('vendor_id'),
'm_cost' =>
$this->db->f('m_cost'),
'w_cost' =>
$this->db->f('w_cost'),
'total_cost' =>
$this->db->f('total_cost'),
'this_index' =>
$this->db->f('this_index'),
'unit' =>
$this->db->f('unit'),
'dim_d' =>
$this->db->f('dim_d'),
'ns3420_id' =>
$this->db->f('ns3420'),
'descr' =>
stripslashes($this->db->f('descr')),
'base_descr' =>
stripslashes($this->db->f('base_descr')),
'index_count' =>
$this->db->f('index_count')
);
}
// _debug_array($pricebook);
return $pricebook;
}
function read_agreement($data)
{
if(is_array($data))
{
if ($data['start'])
{
$start=$data['start'];
}
else
{
$start=0;
}
$filter =
(isset($data['filter'])?$data['filter']:'none');
$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);
$allrows =
(isset($data['allrows'])?$data['allrows']:'');
}
if ($order)
{
$ordermethod = " order by $order $sort";
}
else
{
$ordermethod = ' order by id asc';
}
$where = 'WHERE';
if ($cat_id)
{
$filtermethod .= " $where status='$cat_id' ";
$where = 'AND';
}
if($query)
{
$query = ereg_replace("'",'',$query);
$query = ereg_replace('"','',$query);
$querymethod = " $where (descr LIKE '%$query%'
or num LIKE '%$query%')";
}
$sql = "SELECT * FROM fm_agreement $filtermethod
$querymethod";
$this->db2->query($sql,__LINE__,__FILE__);
$this->total_records = $this->db2->num_rows();
if(!$allrows)
{
$this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
}
else
{
$this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
}
while ($this->db->next_record())
{
$agreement[] = array
(
'agreement_id' =>
$this->db->f('id'),
'num' =>
$this->db->f('num'),
'status' =>
$this->db->f('status'),
'descr' =>
stripslashes($this->db->f('descr'))
);
}
// _debug_array($agreement);
return $agreement;
}
function select_status_list()
{
$this->db->query("SELECT id, descr FROM
fm_agreement_status ORDER BY id ");
$i = 0;
while ($this->db->next_record())
{
$status_entries[$i]['id']
= $this->db->f('id');
$status_entries[$i]['name']
= stripslashes($this->db->f('descr'));
$i++;
}
return $status_entries;
}
function read_activity_prize($data)
{
if(is_array($data))
{
if ($data['start'])
{
$start=$data['start'];
}
else
{
$start=0;
}
$filter =
(isset($data['filter'])?$data['filter']:'none');
$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);
$activity_id =
(isset($data['activity_id'])?$data['activity_id']:0);
$vendor_id =
(isset($data['vendor_id'])?$data['vendor_id']:0);
$allrows =
(isset($data['allrows'])?$data['allrows']:'');
}
if ($order)
{
$ordermethod = " order by $order $sort";
}
else
{
$ordermethod = ' order by index_count';
}
if ($cat_id > 0)
{
$filtermethod .= " AND cat_id='$cat_id' ";
}
if($query)
{
$query = ereg_replace("'",'',$query);
$query = ereg_replace('"','',$query);
$querymethod = " AND (fm_activities.descr LIKE
'%$query%' or fm_activities.num LIKE '%$query%')";
}
$sql = "SELECT
index_count,this_index,current_index,m_cost,w_cost,total_cost,date"
. " FROM fm_activity_price_index Where
activity_id= '$activity_id' and vendor_id= '$vendor_id'";
$this->db2->query($sql,__LINE__,__FILE__);
$this->total_records = $this->db2->num_rows();
if(!$allrows)
{
$this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
}
else
{
$this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
}
while ($this->db->next_record())
{
$pricebook[] = array
(
'index_count' =>
$this->db->f('index_count'),
'this_index' =>
$this->db->f('this_index'),
'current_index' =>
$this->db->f('current_index'),
'm_cost' =>
$this->db->f('m_cost'),
'w_cost' =>
$this->db->f('w_cost'),
'total_cost' =>
$this->db->f('total_cost'),
'date' =>
$this->db->f('date')
);
}
// _debug_array($pricebook);
return $pricebook;
}
function read_activities_pr_aggreement($data)
{
if(is_array($data))
{
if ($data['start'])
{
$start=$data['start'];
}
else
{
$start=0;
}
$filter =
(isset($data['filter'])?$data['filter']:'none');
$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);
$allrows =
(isset($data['allrows'])?$data['allrows']:'');
}
if ($order)
{
$ordermethod = " order by $order $sort";
}
else
{
$ordermethod = " order by activity_id asc";
}
if ($cat_id > 0)
{
$filtermethod .= " Where agreement_id='$cat_id'
";
}
else
{
$filtermethod = " Where agreement_id IS NULL";
}
if($query)
{
$query = ereg_replace("'",'',$query);
$query = ereg_replace('"','',$query);
// $querymethod = " AND (fm_activities.descr LIKE
'%$query%' or fm_activities.num LIKE '%$query%')";
$querymethod = " and (fm_activities.descr like
'%$query%' or fm_activities.base_descr like '%$query%' or fm_activities.num
like '%$query%') ";
}
$sql = "SELECT fm_activities.id AS activity_id,
fm_activities.num, fm_activities.base_descr, fm_activities.unit,
fm_activities.dim_d, fm_branch.descr as branch, fm_activities.descr, ns3420 "
. " FROM fm_activities $this->join fm_branch
on fm_activities.branch_id=fm_branch.id"
. " $filtermethod $querymethod ";
$this->db2->query($sql,__LINE__,__FILE__);
$this->total_records = $this->db2->num_rows();
if(!$allrows)
{
$this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
}
else
{
$this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
}
while ($this->db->next_record())
{
$pricebook[] = array
(
'activity_id' =>
$this->db->f('activity_id'),
'num' =>
$this->db->f('num'),
'base_descr' =>
stripslashes($this->db->f('base_descr')),
'branch' =>
$this->db->f('branch'),
'dim_d' =>
$this->db->f('dim_d'),
'ns3420' =>
$this->db->f('ns3420'),
'unit' =>
$this->db->f('unit'),
'descr' =>
stripslashes($this->db->f('descr'))
);
}
// _debug_array($pricebook);
return $pricebook;
}
function read_vendor_pr_activity($data)
{
if(is_array($data))
{
if ($data['start'])
{
$start=$data['start'];
}
else
{
$start=0;
}
$filter =
(isset($data['filter'])?$data['filter']:'none');
$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);
$allrows =
(isset($data['allrows'])?$data['allrows']:'');
$activity_id =
(isset($data['activity_id'])?$data['activity_id']:'');
}
if ($order)
{
$ordermethod = " order by $order $sort";
}
else
{
$ordermethod = " order by fm_vendor.org_name
asc";
}
if ($cat_id > 0)
{
$filtermethod .= " Where agreement_id='$cat_id'
";
}
else
{
$filtermethod = " Where agreement_id = ''";
}
if($query)
{
$query = ereg_replace("'",'',$query);
$query = ereg_replace('"','',$query);
$querymethod = " AND (fm_vendor.org_name LIKE
'%$query%' or vendor_id LIKE '%$query%')";
}
$sql = "SELECT fm_activities.id as
activity_id,fm_activities.num, fm_vendor.org_name,fm_branch.descr as branch
,vendor_id "
. " FROM (fm_activities $this->join
fm_activity_price_index ON fm_activities.id =
fm_activity_price_index.activity_id) $this->join fm_vendor ON
fm_activity_price_index.vendor_id = fm_vendor.id "
. " $this->join fm_branch on fm_branch.id =
fm_activities.branch_id "
. " Where fm_activity_price_index.activity_id=
'$activity_id' $querymethod group by
fm_activities.id,fm_activities.num,fm_branch.descr,org_name ,vendor_id ";
$this->db2->query($sql,__LINE__,__FILE__);
$this->total_records = $this->db2->num_rows();
if(!$allrows)
{
$this->db->limit_query($sql .
$ordermethod,$start,__LINE__,__FILE__);
}
else
{
$this->db->query($sql .
$ordermethod,__LINE__,__FILE__);
}
while ($this->db->next_record())
{
$pricebook[] = array
(
'activity_id' =>
$this->db->f('activity_id'),
'num' =>
$this->db->f('num'),
'branch' =>
$this->db->f('branch'),
'vendor_name' =>
$this->db->f('org_name'),
'vendor_id' =>
$this->db->f('vendor_id')
);
}
return $pricebook;
}
function read_single_activity($id)
{
$sql = "SELECT * FROM fm_activities where id='$id'";
$this->db->query($sql,__LINE__,__FILE__);
if ($this->db->next_record())
{
$activity['activity_id']= $id;
$activity['num'] =
$this->db->f('num');
$activity['unit'] =
$this->db->f('unit');
$activity['cat_id'] =
$this->db->f('agreement_id');
$activity['ns3420_id'] =
$this->db->f('ns3420');
$activity['descr'] =
stripslashes($this->db->f('descr'));
$activity['base_descr'] =
stripslashes($this->db->f('base_descr'));
$activity['dim_d'] =
$this->db->f('dim_d');
$activity['branch_id'] =
$this->db->f('branch_id');
return $activity;
}
}
function read_single_agreement($id)
{
$sql = "SELECT * FROM fm_agreement where id='$id'";
$this->db->query($sql,__LINE__,__FILE__);
if ($this->db->next_record())
{
$agreement['agreement_id'] = $id;
$agreement['num'] =
$this->db->f('num');
$agreement['status'] =
$this->db->f('status');
$agreement['descr'] =
stripslashes($this->db->f('descr'));
return $agreement;
}
}
function add_activity($values)
{
$values['descr'] =
$this->db->db_addslashes($values['descr']);
$values['base_descr'] =
$this->db->db_addslashes($values['base_descr']);
$this->db->query("INSERT INTO fm_activities (id,
num,unit,agreement_id,ns3420,dim_d,branch_id,descr,base_descr) "
. "VALUES ('" .
$values['activity_id']. "','" .
$values['num'] . "','" .
$values['unit'] . "','" .
$values['cat_id'] . "','" . // agreement
$values['ns3420_id'] . "','" .
$values['dim_d'] . "','" .
$values['branch_id'] ."','" .
$values['descr'] ."','" .
$values['base_descr']. "')",__LINE__,__FILE__);
$receipt['message'][] = array('msg'=>lang('Activity has
been saved'));
$receipt['activity_id']= $values['activity_id'];
return $receipt;
}
function edit_activity($values)
{
$values['descr'] =
$this->db->db_addslashes($values['descr']);
$values['base_descr'] =
$this->db->db_addslashes($values['base_descr']);
$this->db->query("UPDATE fm_activities set
num='" . $values['num'] . "',
unit='" . $values['unit'] . "',
agreement_id='" . $values['cat_id'] . "',
ns3420='" . $values['ns3420_id'] . "',
dim_d='" . $values['dim_d'] . "',
branch_id='" . $values['branch_id'] . "',
descr='" . $values['descr'] . "',
base_descr='" . $values['base_descr']
. "' WHERE id= '" . $values['activity_id'] .
"'",__LINE__,__FILE__);
$receipt['activity_id']= $values['activity_id'];
$receipt['message'][] = array('msg'=>lang('Activity has
been edited'));
return $receipt;
}
function add_agreement($values)
{
$values['descr'] =
$this->db->db_addslashes($values['descr']);
$this->db->query("INSERT INTO fm_agreement
(id,num,status,descr) "
. "VALUES ('" .
$values['agreement_id']. "','" .
$values['num'] . "','" .
$values['status'] . "','" .
$values['descr']. "')",__LINE__,__FILE__);
$receipt['message'][] = array('msg'=>lang('Agreement
has been saved'));
$receipt['agreement_id'] = $values['agreement_id'];
return $receipt;
}
function edit_agreement($values)
{
$values['descr'] =
$this->db->db_addslashes($values['descr']);
$this->db->query("UPDATE fm_agreement set
num='" . $values['num'] . "',
status='" . $values['status'] . "',
descr='" . $values['descr']
. "' WHERE id= '" . $values['agreement_id'] .
"'",__LINE__,__FILE__);
$receipt['message'][] = array('msg'=>lang('Agreement
has been edited'));
return $receipt;
}
function delete_activity_vendor($activity_id,$vendor_id)
{
$this->db->query("DELETE FROM fm_activity_price_index
WHERE activity_id='$activity_id' and vendor_id='$vendor_id'",__LINE__,__FILE__);
}
function delete_activity($activity_id)
{
$this->db->query("DELETE FROM fm_activities WHERE
id='$activity_id'",__LINE__,__FILE__);
$this->db->query("DELETE FROM fm_activity_price_index
WHERE activity_id='$activity_id'",__LINE__,__FILE__);
}
function
delete_prize_index($activity_id,$vendor_id,$index_count)
{
if ($index_count==1)
{
$this->db->query("update
fm_activity_price_index set index_count = '1', current_index = '0',
this_index=Null, m_cost=Null,w_cost=Null,total_cost=Null,date=Null where
activity_id='$activity_id' and vendor_id= '$vendor_id' and index_count=
'1'",__LINE__,__FILE__);
}
else
{
$this->db->query("delete from
fm_activity_price_index where activity_id='$activity_id' and vendor_id=
'$vendor_id' and index_count= '$index_count'",__LINE__,__FILE__);
$new_index_count= $index_count -1;
$this->db->query("update
fm_activity_price_index set current_index = '1' where
activity_id='$activity_id' and vendor_id= '$vendor_id' and index_count=
'$new_index_count'",__LINE__,__FILE__);
}
}
function delete_agreement($agreement_id)
{
$this->db->query("DELETE FROM fm_agreement WHERE
id='$agreement_id'",__LINE__,__FILE__);
//how to handle the activities and vendors ...?
}
function add_activity_vendor($values)
{
$this->db->query("SELECT count(*) FROM
fm_activity_price_index where activity_id='" . $values['activity_id'] . "'
and vendor_id='" . $values['vendor_id'] . "'",__LINE__,__FILE__);
$this->db->next_record();
if ( $this->db->f(0))
{
$receipt['error'][] = array('msg'=>lang('This
Vendor is already registered for this activity'));
}
else
{
$this->db->query("insert into
fm_activity_price_index (activity_id, vendor_id,
index_count,current_index,m_cost,w_cost,total_cost) "
. " values ('" .
$values['activity_id']. "','" .
$values['vendor_id'].
"','1','0',NULL,NULL,NULL)",__LINE__,__FILE__);
$receipt['message'][] =
array('msg'=>lang('Vendor has been added'));
}
return $receipt;
}
}
?>
- [Phpgroupware-cvs] property/inc/class.sopricebook.inc.php, 1.2,
nomail <=