},
'sqlradacct_hour' => {
- 'name' => 'Base charge plus charge per-hour from an external SQL radacct table',
+ 'name' => 'Base charge plus charge per-hour from an external sqlradius radacct table',
'fields' => {
'setup_fee' => { 'name' => 'Setup fee for this package',
'default' => 0,
'recur_flat' => { 'name' => 'Base monthly charge for this package',
'default' => 0,
},
- 'sql_datasrc' => { 'name' => 'DBI data source',
- 'default' => 'DBI:mysql:host=radius.server.name;dbname=radius',
- },
- 'sql_username' => { 'name' => 'Database username',
- 'default' => 'radius',
- },
- 'sql_password' => { 'name' => 'Database password',
- 'default' => '',
- },
'recur_included_hours' => { 'name' => 'Hours included',
'default' => 0,
},
},
'fieldorder' => [ 'setup_fee', 'recur_flat', 'recur_included_hours', 'recur_hourly_charge' ],
'setup' => 'what.setup_fee.value',
- 'recur' => '\'my $hours = $cust_pkg->seconds_since_sqlradacct($cust_pkg->last_bill, $sdate, \' + what.sql_datasrc + \', \' + what.sql_username + \', \' + what.sql_password + \' ) / 3600 - \' + what.recur_included_hours.value + \'; $hours = 0 if $hours < 0; \' + what.recur_flat.value + \' + \' + what.recur_hourly_charge.value + \' * $hours;\'',
+ 'recur' => '\'my $hours = $cust_pkg->seconds_since_sqlradacct($cust_pkg->last_bill, $sdate ) / 3600 - \' + what.recur_included_hours.value + \'; $hours = 0 if $hours < 0; \' + what.recur_flat.value + \' + \' + what.recur_hourly_charge.value + \' * $hours;\'',
},