* USA.
*
* $Id$
* Modyfikacja: Aplikacja IPTV versja 1.2
* 2011 ITMSOFT
* 1.2.1 23/08/2011 19:00:00
* Modyfikacja: Aplikacja IPTV versja 1.2
* 2014 SGT
* 1.2.1 23/08/2011 19:00:00
*/
include '/etc/lms/init_lms.php';
if (get_conf('jambox.enabled')) {
require_once LIB_DIR . '/LMS.tv.class.php';
$LMSTV = new LMSTV($DB, $AUTH, $CONFIG);
}
$end = cal_days_in_month(CAL_GREGORIAN, Date("m"), Date("Y"));
$start_date = Date("Y-m-02", strtotime("last month"));
$end_date = Date("Y-m-" . $end);
print "\n" . $start_date . " - " . $end_date . "\n";
$res = $LMSTV->GetBillingEvents($start_date, $end_date);
//print_r($res);
if (count($res)) {
foreach ($res as $key => $r) {
try {
$DB->Execute('INSERT INTO tv_billingevent (customerid, account_id, be_selling_date, be_desc, be_vat, be_gross, be_b2b_netto, group_id, cust_number, package_id, hash, beid)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', array(empty($r['cust_external_id']) ? 0 : $r['cust_external_id'], $r['account_id'], $r['be_selling_date'], $r['be_desc'], $r['be_vat'], $r['be_gross'], $r['be_b2b_netto'], empty($r['group_id']) ? 0 : $r['group_id'], $r['cust_number'], $r['package_id'], md5($r['id']), $r['id']));
} catch (Exception $e) {
print_r($e);
}
}
}
