public function moveHistoryFromJoomlaToSS()
{
die('test3');
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('max_execution_time', 0);
ini_set('memory_limit', '-1');
$mysqli = $this->getDbConnection();
$result = $mysqli->query("SELECT * FROM jos_users u\n\t\tINNER JOIN jos_osemsc_mem_history mh ON u.id = mh.member_id");
$count = 0;
while ($obj = $result->fetch_object()) {
$ssMember = $this->getSSMember($obj->email);
if (!$ssMember) {
continue;
}
if ($obj->date == '0000-00-00 00:00:00') {
$transDate = $obj->expired_date;
} else {
$transDate = $obj->date;
}
$billingHistory = new MemberBillingHistory();
$billingHistory->Created = $transDate;
$billingHistory->LastEdited = $transDate;
$billingHistory->MemberID = $ssMember->ID;
$creditCardId = $this->getSSCreditCardId($obj->member_id, $ssMember->ID, $transDate);
if ($creditCardId) {
$billingHistory->CreditCardID = $creditCardId;
}
$subscriptionId = $this->getSSSubscriptionId($ssMember->ID, $obj->msc_id, $transDate);
if ($subscriptionId) {
$billingHistory->SubscriptionID = $subscriptionId;
}
$billingHistory->ProductID = $obj->msc_id;
$billingHistory->write();
$count++;
}
$mysqli->close();
echo "Total history moved: {$count}";
}
