FuelPHP Forums

rrlledo

I have this model:

class Model_Philhealth extends Orm\Model

{

protected static $_table_name = 'philhealth_contribution';

// protected static $_properties = array(

// 'id',

// 'SalaryRange_From', 'SalaryRange_To'

// );

protected static $_observers = array(

// This typing should be modified to format and return only the specified fields!

'Orm\\Observer_Typing'

);

/**

* @param $monthlyBasicPay

* @param int $year date('Y')

* @return bool|array

*/

public static function getShare($monthlyBasicPay, $year = 2014)

{

// query() doesn't support column alias

$share = static::query()

->select('EmployeeShare', 'EmployerShare', 'SalaryBase')

->where('year', $year)

->where('SalaryRange_From', '<=', $monthlyBasicPay) // $monthlyBasicPay >= SalaryRange_From

->where('SalaryRange_To', '>=', $monthlyBasicPay) // $monthlyBasicPay <= SalaryRange_To

->get_one()

->to_array()

;

print_r($share);die;

// % - get from phic

$premiumRate = 2.5;

$share['Employee'] = ($share['SalaryBase'] * ($premiumRate / 100) / 2);

$share['Employer'] = ($share['SalaryBase'] * ($premiumRate / 100) / 2);

unset($share['SalaryBase']);

unset($share['EmployeeShare']);

unset($share['EmployerShare']);

return $share;

}

I tried using:

->select(array("EmployeeShare", "Employee"), array("EmployerShare", "Employer), "SalaryBase")

but above didn't work.

Harro

With a column alias you mean "SELECT a AS b"?

Remember that the ORM is not a query builder, if you omit columns from the result, or worse, rename columns, the result is unpredictable as when it hydrates the raw result it won't be able to map the result back to the ORM's record properties.

Furthermore, the ORM already uses column aliasing, so you can't add your own.

If you want to use custom queries, use DB::query() instead.

rrlledo

Yes, I'm using DB::query() now.

Thanks.

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion