Steps to generate new bill for customer (Jinercel)

Login to Jinercel Server

 mysql --user=root --password=xxxxxx

use mya2billing;

search for the account id for the customer - refer to the elastix, "Extras", "Calling Cards",

SELECT a.starttime, a.src, a.sessionid, a.calledstation, a.sessiontime, a.sessionbill into outfile "/tmp/VENUS20140926_01" FIELDS TERMINATED BY '|' from cc_call a, cc_card b where b.id = a.card_id and a.starttime >= "2014-08-01 00:00:00" and  a.starttime <= "2014-08-31 23:59:59" and b.username = '1483798503' and a.sessionbill > 0 order by a.starttime;

scp the outfile to the local PC

start up the "wkhtmltopdf TRIAL" instance

login to the instance and cd "/var/tmp/perldev/jinercel/v01"

scp the outfile into this instance