You can see an (older) version of my work-in-progress along with some discussion of how it works at:<div><br></div><div><a href="http://jira.freeswitch.org/browse/MODAPP-340">http://jira.freeswitch.org/browse/MODAPP-340</a></div>
<div><br></div><div><a href="http://jira.freeswitch.org/browse/MODAPP-340"></a>I haven't updated the patch since the version in my tree also depends on my limit work. But the discussion should give you a better idea of how this will work.<br>
<br><div class="gmail_quote">On Fri, Mar 26, 2010 at 7:13 PM, Sergey Okhapkin <span dir="ltr"><<a href="mailto:sos@sokhapkin.dyndns.org">sos@sokhapkin.dyndns.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Could you give more info about "since you can query/set arbitrary channel vars<br>
via custom sql"? How can I set a channel variable using mod_lcr with custom<br>
sql query?<br>
<div><div></div><div class="h5"><br>
On Friday 26 March 2010, Rupa Schomaker wrote:<br>
> sell_rate you can get as a user_rate from mod_lcr or do your<br>
> own separate query if you don't want lcr info too.<br>
><br>
> billing increment, I've seen a patch that implements this. I was gonna<br>
> port that forward to current rev. If Darren or someone else doesn't get<br>
> it first I'll get to it eventually.<br>
><br>
> init_block - would implement at same time as billing_increment.<br>
><br>
> connection_fee - again, like init_block.<br>
><br>
> In fact, you *could* get all the values you need via the version of mod_lcr<br>
> that is sitting locally since you can query/set arbitrary channel vars via<br>
> custom sql. You can decide how these fields relate to your lcr tables<br>
> (they may not, it is up to you based on the sql you craft).<br>
><br>
> You also mentioned you don't want to bill in real-time but only at end of<br>
> call. This you can do today by turning off the heartbeat. I think this<br>
> is already discussed on the wiki.<br>
><br>
> As always, a bounty goes a long way. One of the devs might jump on it<br>
> sooner if there is money in it. I'm swamped for the next week at least<br>
> so... won't have a chance to even look at this until then. Not to<br>
> mention I want to finish cleaning up my limit stuff.<br>
><br>
> On Fri, Mar 26, 2010 at 6:12 PM, Jean-Yves F. Barbier<br>
<<a href="mailto:12ukwn@gmail.com">12ukwn@gmail.com</a>>wrote:<br>
> > Le Fri, 26 Mar 2010 17:29:57 -0500,<br>
> > Anthony Minessale <<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>> a écrit :<br>
> ><br>
> > Ok, thanks, I read the mod_nibblebill page and What I'd like to ask is to<br>
> > have some more features:<br>
> ><br>
> > * Connection fee<br>
> ><br>
> > * Time-credit (from french term "crédit-temps", means when you make a<br>
> > call you're first invoiced a minimum of X seconds - sometimes along a<br>
> > connection fee:(<br>
> ><br>
> > * A per second invoicing instead of per minute, but without a DB call<br>
> > every second, just one call at hangup.<br>
> ><br>
> > > you can post ideas here for discussion.<br>
> > > if you want something specific you can open a jira incident at<br>
> > > <a href="http://jira.freeswitch.org" target="_blank">http://jira.freeswitch.org</a> under "improvement" category.<br>
> ><br>
> > --<br>
> > Conscious is when you are aware of something and conscience is when you<br>
> > wish you weren't.<br>
> ><br>
> > _______________________________________________<br>
> > FreeSWITCH-users mailing list<br>
> > <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
<br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>-Rupa<br>
</div>