1*9b5730f6SAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3*9b5730f6SAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4*9b5730f6SAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5*9b5730f6SAndrew Rist  * distributed with this work for additional information
6*9b5730f6SAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7*9b5730f6SAndrew Rist  * to you under the Apache License, Version 2.0 (the
8*9b5730f6SAndrew Rist  * "License"); you may not use this file except in compliance
9*9b5730f6SAndrew Rist  * with the License.  You may obtain a copy of the License at
10*9b5730f6SAndrew Rist  *
11*9b5730f6SAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12*9b5730f6SAndrew Rist  *
13*9b5730f6SAndrew Rist  * Unless required by applicable law or agreed to in writing,
14*9b5730f6SAndrew Rist  * software distributed under the License is distributed on an
15*9b5730f6SAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*9b5730f6SAndrew Rist  * KIND, either express or implied.  See the License for the
17*9b5730f6SAndrew Rist  * specific language governing permissions and limitations
18*9b5730f6SAndrew Rist  * under the License.
19*9b5730f6SAndrew Rist  *
20*9b5730f6SAndrew Rist  *************************************************************/
21*9b5730f6SAndrew Rist 
22*9b5730f6SAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_connectivity.hxx"
26cdf0e10cSrcweir 
27cdf0e10cSrcweir #include <cmath>
28cdf0e10cSrcweir #include "file/FNumericFunctions.hxx"
29cdf0e10cSrcweir #include <rtl/math.hxx>
30cdf0e10cSrcweir 
31cdf0e10cSrcweir using namespace connectivity;
32cdf0e10cSrcweir using namespace connectivity::file;
33cdf0e10cSrcweir //------------------------------------------------------------------
operate(const ORowSetValue & lhs) const34cdf0e10cSrcweir ORowSetValue OOp_Abs::operate(const ORowSetValue& lhs) const
35cdf0e10cSrcweir {
36cdf0e10cSrcweir 	if ( lhs.isNull() )
37cdf0e10cSrcweir 		return lhs;
38cdf0e10cSrcweir 
39cdf0e10cSrcweir 	double nVal(lhs);
40cdf0e10cSrcweir 	if ( nVal < 0 )
41cdf0e10cSrcweir 		nVal *= -1.0;
42cdf0e10cSrcweir 	return fabs(nVal);
43cdf0e10cSrcweir }
44cdf0e10cSrcweir //------------------------------------------------------------------
operate(const ORowSetValue & lhs) const45cdf0e10cSrcweir ORowSetValue OOp_Sign::operate(const ORowSetValue& lhs) const
46cdf0e10cSrcweir {
47cdf0e10cSrcweir 	if ( lhs.isNull() )
48cdf0e10cSrcweir 		return lhs;
49cdf0e10cSrcweir 
50cdf0e10cSrcweir 	sal_Int32 nRet = 0;
51cdf0e10cSrcweir 	double nVal(lhs);
52cdf0e10cSrcweir 	if ( nVal < 0 )
53cdf0e10cSrcweir 		nRet = -1;
54cdf0e10cSrcweir 	else if ( nVal > 0 )
55cdf0e10cSrcweir 		nRet = 1;
56cdf0e10cSrcweir 
57cdf0e10cSrcweir 	return nRet;
58cdf0e10cSrcweir }
59cdf0e10cSrcweir //------------------------------------------------------------------
operate(const ORowSetValue & lhs,const ORowSetValue & rhs) const60cdf0e10cSrcweir ORowSetValue OOp_Mod::operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const
61cdf0e10cSrcweir {
62cdf0e10cSrcweir 	if ( lhs.isNull() || rhs.isNull() )
63cdf0e10cSrcweir 		return ORowSetValue();
64cdf0e10cSrcweir 
65cdf0e10cSrcweir 	return fmod((double)lhs,(double)rhs);
66cdf0e10cSrcweir }
67cdf0e10cSrcweir //------------------------------------------------------------------
operate(const ORowSetValue & lhs) const68cdf0e10cSrcweir ORowSetValue OOp_Floor::operate(const ORowSetValue& lhs) const
69cdf0e10cSrcweir {
70cdf0e10cSrcweir 	if ( lhs.isNull() )
71cdf0e10cSrcweir 		return lhs;
72cdf0e10cSrcweir 
73cdf0e10cSrcweir 	return floor((double)lhs);
74cdf0e10cSrcweir }
75cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const76cdf0e10cSrcweir ORowSetValue OOp_Ceiling::operate(const ORowSetValue& lhs) const
77cdf0e10cSrcweir {
78cdf0e10cSrcweir 	if ( lhs.isNull() )
79cdf0e10cSrcweir 		return lhs;
80cdf0e10cSrcweir 
81cdf0e10cSrcweir 	double nVal(lhs);
82cdf0e10cSrcweir 	return ceil(nVal);
83cdf0e10cSrcweir }
84cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const::std::vector<ORowSetValue> & lhs) const85cdf0e10cSrcweir ORowSetValue OOp_Round::operate(const ::std::vector<ORowSetValue>& lhs) const
86cdf0e10cSrcweir {
87cdf0e10cSrcweir 	if ( lhs.empty() || lhs.size() > 2 )
88cdf0e10cSrcweir 		return ORowSetValue();
89cdf0e10cSrcweir 
90cdf0e10cSrcweir 	size_t nSize = lhs.size();
91cdf0e10cSrcweir 	double nVal = lhs[nSize-1];
92cdf0e10cSrcweir 
93cdf0e10cSrcweir 	sal_Int32 nDec = 0;
94cdf0e10cSrcweir 	if ( nSize == 2 && !lhs[0].isNull() )
95cdf0e10cSrcweir 		nDec = lhs[0];
96cdf0e10cSrcweir 	return ::rtl::math::round(nVal,nDec);
97cdf0e10cSrcweir }
98cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const99cdf0e10cSrcweir ORowSetValue OOp_Exp::operate(const ORowSetValue& lhs) const
100cdf0e10cSrcweir {
101cdf0e10cSrcweir 	if ( lhs.isNull() )
102cdf0e10cSrcweir 		return lhs;
103cdf0e10cSrcweir 
104cdf0e10cSrcweir 	double nVal(lhs);
105cdf0e10cSrcweir 	return exp(nVal);
106cdf0e10cSrcweir }
107cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const108cdf0e10cSrcweir ORowSetValue OOp_Ln::operate(const ORowSetValue& lhs) const
109cdf0e10cSrcweir {
110cdf0e10cSrcweir 	if ( lhs.isNull() || static_cast<double>(lhs) < 0.0 )
111cdf0e10cSrcweir 		return lhs;
112cdf0e10cSrcweir 
113cdf0e10cSrcweir 	double nVal(lhs);
114cdf0e10cSrcweir 	nVal = log(nVal);
115cdf0e10cSrcweir 	if ( rtl::math::isNan(nVal) )
116cdf0e10cSrcweir 		return ORowSetValue();
117cdf0e10cSrcweir 	return nVal;
118cdf0e10cSrcweir }
119cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const::std::vector<ORowSetValue> & lhs) const120cdf0e10cSrcweir ORowSetValue OOp_Log::operate(const ::std::vector<ORowSetValue>& lhs) const
121cdf0e10cSrcweir {
122cdf0e10cSrcweir 	if ( lhs.empty() || lhs.size() > 2 )
123cdf0e10cSrcweir 		return ORowSetValue();
124cdf0e10cSrcweir 	size_t nSize = lhs.size();
125cdf0e10cSrcweir 	double nVal = log( (double)lhs[nSize-1] );
126cdf0e10cSrcweir 
127cdf0e10cSrcweir 
128cdf0e10cSrcweir 	if ( nSize == 2 && !lhs[0].isNull() )
129cdf0e10cSrcweir 		nVal /= log((double)lhs[0]);
130cdf0e10cSrcweir 
131cdf0e10cSrcweir 	if ( rtl::math::isNan(nVal) )
132cdf0e10cSrcweir 		return ORowSetValue();
133cdf0e10cSrcweir 	return nVal;
134cdf0e10cSrcweir }
135cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const136cdf0e10cSrcweir ORowSetValue OOp_Log10::operate(const ORowSetValue& lhs) const
137cdf0e10cSrcweir {
138cdf0e10cSrcweir 	if ( lhs.isNull() || static_cast<double>(lhs) < 0.0 )
139cdf0e10cSrcweir 		return lhs;
140cdf0e10cSrcweir 
141cdf0e10cSrcweir 	double nVal = log((double)lhs);
142cdf0e10cSrcweir 	if ( rtl::math::isNan(nVal) )
143cdf0e10cSrcweir 		return ORowSetValue();
144cdf0e10cSrcweir 	nVal /= log(10.0);
145cdf0e10cSrcweir 	return nVal;
146cdf0e10cSrcweir }
147cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs,const ORowSetValue & rhs) const148cdf0e10cSrcweir ORowSetValue OOp_Pow::operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const
149cdf0e10cSrcweir {
150cdf0e10cSrcweir 	if ( lhs.isNull() || rhs.isNull() )
151cdf0e10cSrcweir 		return lhs;
152cdf0e10cSrcweir 
153cdf0e10cSrcweir 	return pow((double)lhs,(double)rhs);
154cdf0e10cSrcweir }
155cdf0e10cSrcweir //------------------------------------------------------------------
operate(const ORowSetValue & lhs) const156cdf0e10cSrcweir ORowSetValue OOp_Sqrt::operate(const ORowSetValue& lhs) const
157cdf0e10cSrcweir {
158cdf0e10cSrcweir 	if ( lhs.isNull() )
159cdf0e10cSrcweir 		return lhs;
160cdf0e10cSrcweir 
161cdf0e10cSrcweir 	double nVal = sqrt((double)lhs);
162cdf0e10cSrcweir 	if ( rtl::math::isNan(nVal) )
163cdf0e10cSrcweir 		return ORowSetValue();
164cdf0e10cSrcweir 	return nVal;
165cdf0e10cSrcweir }
166cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const::std::vector<ORowSetValue> &) const167cdf0e10cSrcweir ORowSetValue OOp_Pi::operate(const ::std::vector<ORowSetValue>& /*lhs*/) const
168cdf0e10cSrcweir {
169cdf0e10cSrcweir 	return 3.141592653589793116;
170cdf0e10cSrcweir }
171cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const172cdf0e10cSrcweir ORowSetValue OOp_Cos::operate(const ORowSetValue& lhs) const
173cdf0e10cSrcweir {
174cdf0e10cSrcweir 	if ( lhs.isNull() )
175cdf0e10cSrcweir 		return lhs;
176cdf0e10cSrcweir 
177cdf0e10cSrcweir 	return cos((double)lhs);
178cdf0e10cSrcweir }
179cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const180cdf0e10cSrcweir ORowSetValue OOp_Sin::operate(const ORowSetValue& lhs) const
181cdf0e10cSrcweir {
182cdf0e10cSrcweir 	if ( lhs.isNull() )
183cdf0e10cSrcweir 		return lhs;
184cdf0e10cSrcweir 
185cdf0e10cSrcweir 	return sin((double)lhs);
186cdf0e10cSrcweir }
187cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const188cdf0e10cSrcweir ORowSetValue OOp_Tan::operate(const ORowSetValue& lhs) const
189cdf0e10cSrcweir {
190cdf0e10cSrcweir 	if ( lhs.isNull() )
191cdf0e10cSrcweir 		return lhs;
192cdf0e10cSrcweir 
193cdf0e10cSrcweir 	return tan((double)lhs);
194cdf0e10cSrcweir }
195cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const196cdf0e10cSrcweir ORowSetValue OOp_ACos::operate(const ORowSetValue& lhs) const
197cdf0e10cSrcweir {
198cdf0e10cSrcweir 	if ( lhs.isNull() )
199cdf0e10cSrcweir 		return lhs;
200cdf0e10cSrcweir 
201cdf0e10cSrcweir 	return acos((double)lhs);
202cdf0e10cSrcweir }
203cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const204cdf0e10cSrcweir ORowSetValue OOp_ASin::operate(const ORowSetValue& lhs) const
205cdf0e10cSrcweir {
206cdf0e10cSrcweir 	if ( lhs.isNull() )
207cdf0e10cSrcweir 		return lhs;
208cdf0e10cSrcweir 
209cdf0e10cSrcweir 	return asin((double)lhs);
210cdf0e10cSrcweir }
211cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const212cdf0e10cSrcweir ORowSetValue OOp_ATan::operate(const ORowSetValue& lhs) const
213cdf0e10cSrcweir {
214cdf0e10cSrcweir 	if ( lhs.isNull() )
215cdf0e10cSrcweir 		return lhs;
216cdf0e10cSrcweir 
217cdf0e10cSrcweir 	return atan((double)lhs);
218cdf0e10cSrcweir }
219cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs,const ORowSetValue & rhs) const220cdf0e10cSrcweir ORowSetValue OOp_ATan2::operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const
221cdf0e10cSrcweir {
222cdf0e10cSrcweir 	if ( lhs.isNull() || rhs.isNull() )
223cdf0e10cSrcweir 		return lhs;
224cdf0e10cSrcweir 
225cdf0e10cSrcweir 	return atan2((double)lhs,(double)rhs);
226cdf0e10cSrcweir }
227cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const228cdf0e10cSrcweir ORowSetValue OOp_Degrees::operate(const ORowSetValue& lhs) const
229cdf0e10cSrcweir {
230cdf0e10cSrcweir 	if ( lhs.isNull() )
231cdf0e10cSrcweir 		return lhs;
232cdf0e10cSrcweir 
233cdf0e10cSrcweir 	double nLhs = lhs;
234cdf0e10cSrcweir 	return nLhs*180*(1.0/3.141592653589793116);
235cdf0e10cSrcweir }
236cdf0e10cSrcweir // -----------------------------------------------------------------------------
operate(const ORowSetValue & lhs) const237cdf0e10cSrcweir ORowSetValue OOp_Radians::operate(const ORowSetValue& lhs) const
238cdf0e10cSrcweir {
239cdf0e10cSrcweir 	if ( lhs.isNull() )
240cdf0e10cSrcweir 		return lhs;
241cdf0e10cSrcweir 
242cdf0e10cSrcweir 	double nLhs = lhs;
243cdf0e10cSrcweir 	return nLhs*3.141592653589793116*(1.0/180.0);
244cdf0e10cSrcweir }
245cdf0e10cSrcweir // -----------------------------------------------------------------------------
246